eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_DISPATCH_HISTORIES_PKG dependencies on FND_MESSAGE

Line 265: FND_MESSAGE.SET_NAME('GR',

261: WHEN Foreign_Key_Error THEN
262: ROLLBACK TO SAVEPOINT Insert_Row;
263: x_return_status := l_return_status;
264: x_oracle_error := l_oracle_error;
265: FND_MESSAGE.SET_NAME('GR',
266: 'GR_FOREIGN_KEY_ERROR');
267: FND_MESSAGE.SET_TOKEN('TEXT',
268: l_msg_data,
269: FALSE);

Line 267: FND_MESSAGE.SET_TOKEN('TEXT',

263: x_return_status := l_return_status;
264: x_oracle_error := l_oracle_error;
265: FND_MESSAGE.SET_NAME('GR',
266: 'GR_FOREIGN_KEY_ERROR');
267: FND_MESSAGE.SET_TOKEN('TEXT',
268: l_msg_data,
269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;

Line 273: x_msg_data := FND_MESSAGE.Get;

269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;
272: ELSE
273: x_msg_data := FND_MESSAGE.Get;
274: END IF;
275:
276: WHEN Label_Exists_Error THEN
277: ROLLBACK TO SAVEPOINT Insert_Row;

Line 280: FND_MESSAGE.SET_NAME('GR',

276: WHEN Label_Exists_Error THEN
277: ROLLBACK TO SAVEPOINT Insert_Row;
278: x_return_status := 'E';
279: x_oracle_error := APP_EXCEPTION.Get_Code;
280: FND_MESSAGE.SET_NAME('GR',
281: 'GR_RECORD_EXISTS');
282: FND_MESSAGE.SET_TOKEN('CODE',
283: p_document_code,
284: FALSE);

Line 282: FND_MESSAGE.SET_TOKEN('CODE',

278: x_return_status := 'E';
279: x_oracle_error := APP_EXCEPTION.Get_Code;
280: FND_MESSAGE.SET_NAME('GR',
281: 'GR_RECORD_EXISTS');
282: FND_MESSAGE.SET_TOKEN('CODE',
283: p_document_code,
284: FALSE);
285: IF FND_API.To_Boolean(p_called_by_form) THEN
286: APP_EXCEPTION.Raise_Exception;

Line 288: x_msg_data := FND_MESSAGE.Get;

284: FALSE);
285: IF FND_API.To_Boolean(p_called_by_form) THEN
286: APP_EXCEPTION.Raise_Exception;
287: ELSE
288: x_msg_data := FND_MESSAGE.Get;
289: END IF;
290:
291: WHEN Row_Missing_Error THEN
292: ROLLBACK TO SAVEPOINT Insert_Row;

Line 295: FND_MESSAGE.SET_NAME('GR',

291: WHEN Row_Missing_Error THEN
292: ROLLBACK TO SAVEPOINT Insert_Row;
293: x_return_status := 'E';
294: x_oracle_error := APP_EXCEPTION.Get_Code;
295: FND_MESSAGE.SET_NAME('GR',
296: 'GR_NO_RECORD_INSERTED');
297: FND_MESSAGE.SET_TOKEN('CODE',
298: p_document_code,
299: FALSE);

Line 297: FND_MESSAGE.SET_TOKEN('CODE',

293: x_return_status := 'E';
294: x_oracle_error := APP_EXCEPTION.Get_Code;
295: FND_MESSAGE.SET_NAME('GR',
296: 'GR_NO_RECORD_INSERTED');
297: FND_MESSAGE.SET_TOKEN('CODE',
298: p_document_code,
299: FALSE);
300: IF FND_API.To_Boolean(p_called_by_form) THEN
301: APP_EXCEPTION.Raise_Exception;

Line 303: x_msg_data := FND_MESSAGE.Get;

299: FALSE);
300: IF FND_API.To_Boolean(p_called_by_form) THEN
301: APP_EXCEPTION.Raise_Exception;
302: ELSE
303: x_msg_data := FND_MESSAGE.Get;
304: END IF;
305:
306: WHEN OTHERS THEN
307: ROLLBACK TO SAVEPOINT Insert_Row;

Line 311: FND_MESSAGE.SET_NAME('GR',

307: ROLLBACK TO SAVEPOINT Insert_Row;
308: x_return_status := 'U';
309: x_oracle_error := APP_EXCEPTION.Get_Code;
310: l_msg_data := APP_EXCEPTION.Get_Text;
311: FND_MESSAGE.SET_NAME('GR',
312: 'GR_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',
314: l_msg_data,
315: FALSE);

Line 313: FND_MESSAGE.SET_TOKEN('TEXT',

309: x_oracle_error := APP_EXCEPTION.Get_Code;
310: l_msg_data := APP_EXCEPTION.Get_Text;
311: FND_MESSAGE.SET_NAME('GR',
312: 'GR_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',
314: l_msg_data,
315: FALSE);
316: IF FND_API.To_Boolean(p_called_by_form) THEN
317: APP_EXCEPTION.Raise_Exception;

Line 319: x_msg_data := FND_MESSAGE.Get;

315: FALSE);
316: IF FND_API.To_Boolean(p_called_by_form) THEN
317: APP_EXCEPTION.Raise_Exception;
318: ELSE
319: x_msg_data := FND_MESSAGE.Get;
320: END IF;
321:
322: END Insert_Row;
323:

Line 509: FND_MESSAGE.SET_NAME('GR',

505: WHEN Foreign_Key_Error THEN
506: ROLLBACK TO SAVEPOINT Update_Row;
507: x_return_status := l_return_status;
508: x_oracle_error := l_oracle_error;
509: FND_MESSAGE.SET_NAME('GR',
510: 'GR_FOREIGN_KEY_ERROR');
511: FND_MESSAGE.SET_TOKEN('TEXT',
512: l_msg_data,
513: FALSE);

Line 511: FND_MESSAGE.SET_TOKEN('TEXT',

507: x_return_status := l_return_status;
508: x_oracle_error := l_oracle_error;
509: FND_MESSAGE.SET_NAME('GR',
510: 'GR_FOREIGN_KEY_ERROR');
511: FND_MESSAGE.SET_TOKEN('TEXT',
512: l_msg_data,
513: FALSE);
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;

Line 517: x_msg_data := FND_MESSAGE.Get;

513: FALSE);
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;
519:
520: WHEN Row_Missing_Error THEN
521: ROLLBACK TO SAVEPOINT Update_Row;

Line 524: FND_MESSAGE.SET_NAME('GR',

520: WHEN Row_Missing_Error THEN
521: ROLLBACK TO SAVEPOINT Update_Row;
522: x_return_status := 'E';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: FND_MESSAGE.SET_NAME('GR',
525: 'GR_NO_RECORD_INSERTED');
526: FND_MESSAGE.SET_TOKEN('CODE',
527: p_document_code,
528: FALSE);

Line 526: FND_MESSAGE.SET_TOKEN('CODE',

522: x_return_status := 'E';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: FND_MESSAGE.SET_NAME('GR',
525: 'GR_NO_RECORD_INSERTED');
526: FND_MESSAGE.SET_TOKEN('CODE',
527: p_document_code,
528: FALSE);
529: IF FND_API.To_Boolean(p_called_by_form) THEN
530: APP_EXCEPTION.Raise_Exception;

Line 532: x_msg_data := FND_MESSAGE.Get;

528: FALSE);
529: IF FND_API.To_Boolean(p_called_by_form) THEN
530: APP_EXCEPTION.Raise_Exception;
531: ELSE
532: x_msg_data := FND_MESSAGE.Get;
533: END IF;
534:
535: WHEN OTHERS THEN
536: ROLLBACK TO SAVEPOINT Update_Row;

Line 540: FND_MESSAGE.SET_NAME('GR',

536: ROLLBACK TO SAVEPOINT Update_Row;
537: x_return_status := 'U';
538: x_oracle_error := APP_EXCEPTION.Get_Code;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,
544: FALSE);

Line 542: FND_MESSAGE.SET_TOKEN('TEXT',

538: x_oracle_error := APP_EXCEPTION.Get_Code;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,
544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;

Line 548: x_msg_data := FND_MESSAGE.Get;

544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;
547: ELSE
548: x_msg_data := FND_MESSAGE.Get;
549: END IF;
550:
551: END Update_Row;
552:

Line 658: FND_MESSAGE.SET_NAME('GR',

654:
655: WHEN No_Data_Found_Error THEN
656: ROLLBACK TO SAVEPOINT Lock_Row;
657: x_return_status := 'E';
658: FND_MESSAGE.SET_NAME('GR',
659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_code,
662: FALSE);

Line 660: FND_MESSAGE.SET_TOKEN('CODE',

656: ROLLBACK TO SAVEPOINT Lock_Row;
657: x_return_status := 'E';
658: FND_MESSAGE.SET_NAME('GR',
659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_code,
662: FALSE);
663: IF FND_API.To_Boolean(p_called_by_form) THEN
664: APP_EXCEPTION.Raise_Exception;

Line 666: x_msg_data := FND_MESSAGE.Get;

662: FALSE);
663: IF FND_API.To_Boolean(p_called_by_form) THEN
664: APP_EXCEPTION.Raise_Exception;
665: ELSE
666: x_msg_data := FND_MESSAGE.Get;
667: END IF;
668:
669: WHEN Row_Already_Locked_Error THEN
670: ROLLBACK TO SAVEPOINT Lock_Row;

Line 673: FND_MESSAGE.SET_NAME('GR',

669: WHEN Row_Already_Locked_Error THEN
670: ROLLBACK TO SAVEPOINT Lock_Row;
671: x_return_status := 'E';
672: x_oracle_error := APP_EXCEPTION.Get_Code;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_ROW_IS_LOCKED');
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;
677: ELSE

Line 678: x_msg_data := FND_MESSAGE.Get;

674: 'GR_ROW_IS_LOCKED');
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;
677: ELSE
678: x_msg_data := FND_MESSAGE.Get;
679: END IF;
680:
681: WHEN OTHERS THEN
682: ROLLBACK TO SAVEPOINT Lock_Row;

Line 686: FND_MESSAGE.SET_NAME('GR',

682: ROLLBACK TO SAVEPOINT Lock_Row;
683: x_return_status := 'U';
684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_data,
690: FALSE);

Line 688: FND_MESSAGE.SET_TOKEN('TEXT',

684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_data,
690: FALSE);
691: IF FND_API.To_Boolean(p_called_by_form) THEN
692: APP_EXCEPTION.Raise_Exception;

Line 694: x_msg_data := FND_MESSAGE.Get;

690: FALSE);
691: IF FND_API.To_Boolean(p_called_by_form) THEN
692: APP_EXCEPTION.Raise_Exception;
693: ELSE
694: x_msg_data := FND_MESSAGE.Get;
695: END IF;
696:
697: END Lock_Row;
698:

Line 845: x_msg_data := FND_MESSAGE.Get;

841: x_oracle_error := l_oracle_error;
842: IF FND_API.To_Boolean(p_called_by_form) THEN
843: APP_EXCEPTION.Raise_Exception;
844: ELSE
845: x_msg_data := FND_MESSAGE.Get;
846: END IF;
847:
848: WHEN Row_Missing_Error THEN
849: ROLLBACK TO SAVEPOINT Delete_Row;

Line 852: FND_MESSAGE.SET_NAME('GR',

848: WHEN Row_Missing_Error THEN
849: ROLLBACK TO SAVEPOINT Delete_Row;
850: x_return_status := 'E';
851: x_oracle_error := APP_EXCEPTION.Get_Code;
852: FND_MESSAGE.SET_NAME('GR',
853: 'GR_RECORD_NOT_FOUND');
854: FND_MESSAGE.SET_TOKEN('CODE',
855: p_document_code,
856: FALSE);

Line 854: FND_MESSAGE.SET_TOKEN('CODE',

850: x_return_status := 'E';
851: x_oracle_error := APP_EXCEPTION.Get_Code;
852: FND_MESSAGE.SET_NAME('GR',
853: 'GR_RECORD_NOT_FOUND');
854: FND_MESSAGE.SET_TOKEN('CODE',
855: p_document_code,
856: FALSE);
857: IF FND_API.To_Boolean(p_called_by_form) THEN
858: APP_EXCEPTION.Raise_Exception;

Line 860: x_msg_data := FND_MESSAGE.Get;

856: FALSE);
857: IF FND_API.To_Boolean(p_called_by_form) THEN
858: APP_EXCEPTION.Raise_Exception;
859: ELSE
860: x_msg_data := FND_MESSAGE.Get;
861: END IF;
862:
863: WHEN OTHERS THEN
864: ROLLBACK TO SAVEPOINT Delete_Row;

Line 869: FND_MESSAGE.SET_NAME('GR',

865: x_return_status := 'U';
866: x_oracle_error := APP_EXCEPTION.Get_Code;
867: l_msg_data := APP_EXCEPTION.Get_Text;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,
873: FALSE);

Line 871: FND_MESSAGE.SET_TOKEN('TEXT',

867: l_msg_data := APP_EXCEPTION.Get_Text;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,
873: FALSE);
874: IF FND_API.To_Boolean(p_called_by_form) THEN
875: APP_EXCEPTION.Raise_Exception;

Line 877: x_msg_data := FND_MESSAGE.Get;

873: FALSE);
874: IF FND_API.To_Boolean(p_called_by_form) THEN
875: APP_EXCEPTION.Raise_Exception;
876: ELSE
877: x_msg_data := FND_MESSAGE.Get;
878: END IF;
879:
880: END Delete_Row;
881:

Line 977: FND_MESSAGE.SET_NAME('GR',

973:
974: WHEN Null_Delete_Option_Error THEN
975: x_return_status := 'E';
976: x_oracle_error := APP_EXCEPTION.Get_Code;
977: FND_MESSAGE.SET_NAME('GR',
978: 'GR_NULL_VALUE');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);

Line 979: FND_MESSAGE.SET_TOKEN('CODE',

975: x_return_status := 'E';
976: x_oracle_error := APP_EXCEPTION.Get_Code;
977: FND_MESSAGE.SET_NAME('GR',
978: 'GR_NULL_VALUE');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;

Line 985: x_msg_data := FND_MESSAGE.Get;

981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;
984: ELSE
985: x_msg_data := FND_MESSAGE.Get;
986: END IF;
987:
988: WHEN OTHERS THEN
989: ROLLBACK TO SAVEPOINT Delete_Rows;

Line 993: FND_MESSAGE.SET_NAME('GR',

989: ROLLBACK TO SAVEPOINT Delete_Rows;
990: x_return_status := 'U';
991: x_oracle_error := APP_EXCEPTION.Get_Code;
992: l_msg_data := APP_EXCEPTION.Get_Text;
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);

Line 995: FND_MESSAGE.SET_TOKEN('TEXT',

991: x_oracle_error := APP_EXCEPTION.Get_Code;
992: l_msg_data := APP_EXCEPTION.Get_Text;
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;

Line 1001: x_msg_data := FND_MESSAGE.Get;

997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;
1000: ELSE
1001: x_msg_data := FND_MESSAGE.Get;
1002: END IF;
1003:
1004: END Delete_Rows;
1005:

Line 1084: FND_MESSAGE.SET_NAME('GR',

1080: l_key_exists);
1081:
1082: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1083: x_return_status := 'E';
1084: FND_MESSAGE.SET_NAME('GR',
1085: 'GR_RECORD_NOT_FOUND');
1086: FND_MESSAGE.SET_TOKEN('CODE',
1087: p_item_code,
1088: FALSE);

Line 1086: FND_MESSAGE.SET_TOKEN('CODE',

1082: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1083: x_return_status := 'E';
1084: FND_MESSAGE.SET_NAME('GR',
1085: 'GR_RECORD_NOT_FOUND');
1086: FND_MESSAGE.SET_TOKEN('CODE',
1087: p_item_code,
1088: FALSE);
1089: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1090: END IF;

Line 1089: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1085: 'GR_RECORD_NOT_FOUND');
1086: FND_MESSAGE.SET_TOKEN('CODE',
1087: p_item_code,
1088: FALSE);
1089: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1090: END IF;
1091:
1092: /* Check the document code */
1093:

Line 1103: FND_MESSAGE.SET_NAME('GR',

1099: l_key_exists);
1100:
1101: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1102: x_return_status := 'E';
1103: FND_MESSAGE.SET_NAME('GR',
1104: 'GR_RECORD_NOT_FOUND');
1105: FND_MESSAGE.SET_TOKEN('CODE',
1106: p_document_code,
1107: FALSE);

Line 1105: FND_MESSAGE.SET_TOKEN('CODE',

1101: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1102: x_return_status := 'E';
1103: FND_MESSAGE.SET_NAME('GR',
1104: 'GR_RECORD_NOT_FOUND');
1105: FND_MESSAGE.SET_TOKEN('CODE',
1106: p_document_code,
1107: FALSE);
1108: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1109: END IF;

Line 1108: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1104: 'GR_RECORD_NOT_FOUND');
1105: FND_MESSAGE.SET_TOKEN('CODE',
1106: p_document_code,
1107: FALSE);
1108: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1109: END IF;
1110:
1111: /* Check the recipient code */
1112:

Line 1122: FND_MESSAGE.SET_NAME('GR',

1118: l_key_exists);
1119:
1120: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1121: x_return_status := 'E';
1122: FND_MESSAGE.SET_NAME('GR',
1123: 'GR_RECORD_NOT_FOUND');
1124: FND_MESSAGE.SET_TOKEN('CODE',
1125: p_recipient_code,
1126: FALSE);

Line 1124: FND_MESSAGE.SET_TOKEN('CODE',

1120: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1121: x_return_status := 'E';
1122: FND_MESSAGE.SET_NAME('GR',
1123: 'GR_RECORD_NOT_FOUND');
1124: FND_MESSAGE.SET_TOKEN('CODE',
1125: p_recipient_code,
1126: FALSE);
1127: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1128: END IF;

Line 1127: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1123: 'GR_RECORD_NOT_FOUND');
1124: FND_MESSAGE.SET_TOKEN('CODE',
1125: p_recipient_code,
1126: FALSE);
1127: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1128: END IF;
1129:
1130: IF x_return_status <> 'S' THEN
1131: x_msg_data := l_msg_data;

Line 1141: FND_MESSAGE.SET_NAME('GR',

1137: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1138: x_return_status := 'U';
1139: x_oracle_error := APP_EXCEPTION.Get_Code;
1140: l_msg_data := APP_EXCEPTION.Get_Text;
1141: FND_MESSAGE.SET_NAME('GR',
1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',
1144: l_msg_data,
1145: FALSE);

Line 1143: FND_MESSAGE.SET_TOKEN('TEXT',

1139: x_oracle_error := APP_EXCEPTION.Get_Code;
1140: l_msg_data := APP_EXCEPTION.Get_Text;
1141: FND_MESSAGE.SET_NAME('GR',
1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',
1144: l_msg_data,
1145: FALSE);
1146: x_msg_data := FND_MESSAGE.Get;
1147:

Line 1146: x_msg_data := FND_MESSAGE.Get;

1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',
1144: l_msg_data,
1145: FALSE);
1146: x_msg_data := FND_MESSAGE.Get;
1147:
1148: END Check_Foreign_Keys;
1149:
1150: PROCEDURE Check_Integrity

Line 1233: FND_MESSAGE.SET_NAME('GR',

1229: ROLLBACK TO SAVEPOINT Check_Integrity;
1230: x_return_status := 'U';
1231: x_oracle_error := APP_EXCEPTION.Get_Code;
1232: l_msg_data := APP_EXCEPTION.Get_Text;
1233: FND_MESSAGE.SET_NAME('GR',
1234: 'GR_UNEXPECTED_ERROR');
1235: FND_MESSAGE.SET_TOKEN('TEXT',
1236: l_msg_data,
1237: FALSE);

Line 1235: FND_MESSAGE.SET_TOKEN('TEXT',

1231: x_oracle_error := APP_EXCEPTION.Get_Code;
1232: l_msg_data := APP_EXCEPTION.Get_Text;
1233: FND_MESSAGE.SET_NAME('GR',
1234: 'GR_UNEXPECTED_ERROR');
1235: FND_MESSAGE.SET_TOKEN('TEXT',
1236: l_msg_data,
1237: FALSE);
1238: IF FND_API.To_Boolean(p_called_by_form) THEN
1239: APP_EXCEPTION.Raise_Exception;

Line 1241: x_msg_data := FND_MESSAGE.Get;

1237: FALSE);
1238: IF FND_API.To_Boolean(p_called_by_form) THEN
1239: APP_EXCEPTION.Raise_Exception;
1240: ELSE
1241: x_msg_data := FND_MESSAGE.Get;
1242: END IF;
1243:
1244: END Check_Integrity;
1245:

Line 1301: FND_MESSAGE.SET_NAME('GR',

1297: EXCEPTION
1298:
1299: WHEN Others THEN
1300: l_msg_data := APP_EXCEPTION.Get_Text;
1301: FND_MESSAGE.SET_NAME('GR',
1302: 'GR_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('TEXT',
1304: l_msg_data,
1305: FALSE);

Line 1303: FND_MESSAGE.SET_TOKEN('TEXT',

1299: WHEN Others THEN
1300: l_msg_data := APP_EXCEPTION.Get_Text;
1301: FND_MESSAGE.SET_NAME('GR',
1302: 'GR_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('TEXT',
1304: l_msg_data,
1305: FALSE);
1306: IF FND_API.To_Boolean(p_called_by_form) THEN
1307: APP_EXCEPTION.Raise_Exception;