Sunday, June 19, 2016


Oracle Forms Errors & Informative 
English Messages Script 

In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      Oracle database & Oracle forms message structure composed of  


·        MESSAGE_TYPE.
·        MESSAGE_CODE.
·        MESSAGE_TEXT.

    Accordingly, the following script is created to customize your  Oracle forms informative and error messages in English Language as follow. 
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40401, '1', 'No changes currently made to be saved.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40202, '1', 'This field must be entered, navigation not allowed.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40301, '1', 'No records retrieved.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40400, '1', 'Data is successfully saved.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40600, '1', ' This record is already exist');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40508, '1', ' unable to insert record.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50000, '1',' Attention pls. your characters inputs exceeded the allowed limits.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50001, '1',' Acceptable characters are a-z, A-Z, and space.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50002, '1', 'Months must be between 1 and 12');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50003, '1', 'Year must be in proper range.);
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50004, '1', 'The Day must be between 1 and last day of the month');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50025, '1', 'Attention pls. your date or time must be in the proper format. ');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50026, '1', ' pls. re-enter the date in the requested format. ');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50006, '1',' Legal characters are 0-9 + and -.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
 VALUES (50007, '1',' Attention pls. too many digits after the decimal point.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50009, '1',' Attention pls. too many decimal points.');
  
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (50016, '1', 'Accepts Numbers Only');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40100, '1', ' The First Record');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (41830, '1', ' No LOV Entries.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (41049, '1', 'Delete Is Not Allowed');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40509, '1', 'Update Is Not Allowed');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (41051, '1', 'Insert Is Not Allowed');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40360, '1', 'Query Is Not Allowed');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40510, '1', 'This Record Related to Other Data');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40102, '1', 'Record Must Be Inserted or Deleted');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (41003, '1', 'Query Is Not Allowed.');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40212, '1', 'Incorrect Value Inserted');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40352, '1', 'Last Record');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40350, '1', 'No Data Retrieved');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40200, '1', 'Protected Against Update');
INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)
VALUES (40353, '1', ' Query Cancelled');
COMMIT;



 Insha'Allah, I will update this script from time to another.




Hope this helps…




Learn More about:




Top 3 Steps To Suppress Oracle Forms Messages



My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.



Post a Comment