Customizing Oracle Forms Errors & Informative Messages In English

Customizing Oracle Forms 
Errors & Informative Messages In English

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,

According to the previous blog i had created to share my experience regarding:
The Best 3 Steps Handling Oracle Forms Messages,
 I was inspired by Allah swt for creating the following data script to facilitate customizing Oracle forms informative and error messages in English Language.

          If you run the following data script into "ERROR_MESSAGES"  database table  you will get your table filled out with the most common Oracle Forms  informative meaningful data which involves.  

      ·      MESSAGE_TYPE.
·      MESSAGE_CODE.
·     MESSAGE_TEXT.

INSERT INTO ERROR_MESSAGES (MSG_CODE, MSG_TYPE, MSG_DESC)

VALUES (41830 , '1', 'List of values has no entries.');

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',' 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', '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', ' This is the First Record');

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:

The Best 3 Steps For Handling 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.