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_DOCUMENT_STRUCTURES_PKG dependencies on FND_MESSAGE

Line 272: FND_MESSAGE.SET_NAME('GR',

268: WHEN Foreign_Key_Error THEN
269: ROLLBACK TO SAVEPOINT Insert_Row;
270: x_return_status := l_return_status;
271: x_oracle_error := l_oracle_error;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_FOREIGN_KEY_ERROR');
274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);

Line 274: FND_MESSAGE.SET_TOKEN('TEXT',

270: x_return_status := l_return_status;
271: x_oracle_error := l_oracle_error;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_FOREIGN_KEY_ERROR');
274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;

Line 280: x_msg_data := FND_MESSAGE.Get;

276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;
282:
283: WHEN Label_Exists_Error THEN
284: ROLLBACK TO SAVEPOINT Insert_Row;

Line 287: FND_MESSAGE.SET_NAME('GR',

283: WHEN Label_Exists_Error THEN
284: ROLLBACK TO SAVEPOINT Insert_Row;
285: x_return_status := 'E';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_RECORD_EXISTS');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: p_document_structures_seqno ,
291: FALSE);

Line 289: FND_MESSAGE.SET_TOKEN('CODE',

285: x_return_status := 'E';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_RECORD_EXISTS');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: p_document_structures_seqno ,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;

Line 295: x_msg_data := FND_MESSAGE.Get;

291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;
297:
298: WHEN Row_Missing_Error THEN
299: ROLLBACK TO SAVEPOINT Insert_Row;

Line 303: FND_MESSAGE.SET_NAME('GR',

299: ROLLBACK TO SAVEPOINT Insert_Row;
300: l_msg_data := p_document_structures_seqno || ' ' || p_document_headings_seqno;
301: x_return_status := 'E';
302: x_oracle_error := APP_EXCEPTION.Get_Code;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_NO_RECORD_INSERTED');
305: FND_MESSAGE.SET_TOKEN('CODE',
306: l_msg_data,
307: FALSE);

Line 305: FND_MESSAGE.SET_TOKEN('CODE',

301: x_return_status := 'E';
302: x_oracle_error := APP_EXCEPTION.Get_Code;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_NO_RECORD_INSERTED');
305: FND_MESSAGE.SET_TOKEN('CODE',
306: l_msg_data,
307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;

Line 311: x_msg_data := FND_MESSAGE.Get;

307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;
310: ELSE
311: x_msg_data := FND_MESSAGE.Get;
312: END IF;
313:
314: WHEN OTHERS THEN
315: ROLLBACK TO SAVEPOINT Insert_Row;

Line 319: FND_MESSAGE.SET_NAME('GR',

315: ROLLBACK TO SAVEPOINT Insert_Row;
316: x_return_status := 'U';
317: x_oracle_error := APP_EXCEPTION.Get_Code;
318: l_msg_data := APP_EXCEPTION.Get_Text;
319: FND_MESSAGE.SET_NAME('GR',
320: 'GR_UNEXPECTED_ERROR');
321: FND_MESSAGE.SET_TOKEN('TEXT',
322: l_msg_data,
323: FALSE);

Line 321: FND_MESSAGE.SET_TOKEN('TEXT',

317: x_oracle_error := APP_EXCEPTION.Get_Code;
318: l_msg_data := APP_EXCEPTION.Get_Text;
319: FND_MESSAGE.SET_NAME('GR',
320: 'GR_UNEXPECTED_ERROR');
321: FND_MESSAGE.SET_TOKEN('TEXT',
322: l_msg_data,
323: FALSE);
324: IF FND_API.To_Boolean(p_called_by_form) THEN
325: APP_EXCEPTION.Raise_Exception;

Line 327: x_msg_data := FND_MESSAGE.Get;

323: FALSE);
324: IF FND_API.To_Boolean(p_called_by_form) THEN
325: APP_EXCEPTION.Raise_Exception;
326: ELSE
327: x_msg_data := FND_MESSAGE.Get;
328: END IF;
329:
330: END Insert_Row;
331:

Line 520: FND_MESSAGE.SET_NAME('GR',

516: WHEN Foreign_Key_Error THEN
517: ROLLBACK TO SAVEPOINT Update_Row;
518: x_return_status := l_return_status;
519: x_oracle_error := l_oracle_error;
520: FND_MESSAGE.SET_NAME('GR',
521: 'GR_FOREIGN_KEY_ERROR');
522: FND_MESSAGE.SET_TOKEN('TEXT',
523: l_msg_data,
524: FALSE);

Line 522: FND_MESSAGE.SET_TOKEN('TEXT',

518: x_return_status := l_return_status;
519: x_oracle_error := l_oracle_error;
520: FND_MESSAGE.SET_NAME('GR',
521: 'GR_FOREIGN_KEY_ERROR');
522: FND_MESSAGE.SET_TOKEN('TEXT',
523: l_msg_data,
524: FALSE);
525: IF FND_API.To_Boolean(p_called_by_form) THEN
526: APP_EXCEPTION.Raise_Exception;

Line 528: x_msg_data := FND_MESSAGE.Get;

524: FALSE);
525: IF FND_API.To_Boolean(p_called_by_form) THEN
526: APP_EXCEPTION.Raise_Exception;
527: ELSE
528: x_msg_data := FND_MESSAGE.Get;
529: END IF;
530:
531: WHEN Row_Missing_Error THEN
532: ROLLBACK TO SAVEPOINT Update_Row;

Line 536: FND_MESSAGE.SET_NAME('GR',

532: ROLLBACK TO SAVEPOINT Update_Row;
533: l_msg_data := p_document_structures_seqno || ' ' || p_document_headings_seqno;
534: x_return_status := 'E';
535: x_oracle_error := APP_EXCEPTION.Get_Code;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_NO_RECORD_INSERTED');
538: FND_MESSAGE.SET_TOKEN('CODE',
539: l_msg_data,
540: FALSE);

Line 538: FND_MESSAGE.SET_TOKEN('CODE',

534: x_return_status := 'E';
535: x_oracle_error := APP_EXCEPTION.Get_Code;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_NO_RECORD_INSERTED');
538: FND_MESSAGE.SET_TOKEN('CODE',
539: l_msg_data,
540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;

Line 544: x_msg_data := FND_MESSAGE.Get;

540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;
543: ELSE
544: x_msg_data := FND_MESSAGE.Get;
545: END IF;
546:
547: WHEN OTHERS THEN
548: ROLLBACK TO SAVEPOINT Update_Row;

Line 552: FND_MESSAGE.SET_NAME('GR',

548: ROLLBACK TO SAVEPOINT Update_Row;
549: x_return_status := 'U';
550: x_oracle_error := APP_EXCEPTION.Get_Code;
551: l_msg_data := APP_EXCEPTION.Get_Text;
552: FND_MESSAGE.SET_NAME('GR',
553: 'GR_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('TEXT',
555: l_msg_data,
556: FALSE);

Line 554: FND_MESSAGE.SET_TOKEN('TEXT',

550: x_oracle_error := APP_EXCEPTION.Get_Code;
551: l_msg_data := APP_EXCEPTION.Get_Text;
552: FND_MESSAGE.SET_NAME('GR',
553: 'GR_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('TEXT',
555: l_msg_data,
556: FALSE);
557: IF FND_API.To_Boolean(p_called_by_form) THEN
558: APP_EXCEPTION.Raise_Exception;

Line 560: x_msg_data := FND_MESSAGE.Get;

556: FALSE);
557: IF FND_API.To_Boolean(p_called_by_form) THEN
558: APP_EXCEPTION.Raise_Exception;
559: ELSE
560: x_msg_data := FND_MESSAGE.Get;
561: END IF;
562:
563: END Update_Row;
564:

Line 628: FND_MESSAGE.SET_NAME('GR',

624: WHEN Row_Missing_Error THEN
625: ROLLBACK TO SAVEPOINT Update_Display_Columns;
626: x_return_status := 'E';
627: x_oracle_error := APP_EXCEPTION.Get_Code;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_NO_RECORD_INSERTED');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_structures_seqno,
632: FALSE);

Line 630: FND_MESSAGE.SET_TOKEN('CODE',

626: x_return_status := 'E';
627: x_oracle_error := APP_EXCEPTION.Get_Code;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_NO_RECORD_INSERTED');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_structures_seqno,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;

Line 636: x_msg_data := FND_MESSAGE.Get;

632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;
638:
639: WHEN OTHERS THEN
640: ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line 644: FND_MESSAGE.SET_NAME('GR',

640: ROLLBACK TO SAVEPOINT Update_Display_Columns;
641: x_return_status := 'U';
642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: FND_MESSAGE.SET_NAME('GR',
645: 'GR_UNEXPECTED_ERROR');
646: FND_MESSAGE.SET_TOKEN('TEXT',
647: l_msg_data,
648: FALSE);

Line 646: FND_MESSAGE.SET_TOKEN('TEXT',

642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: FND_MESSAGE.SET_NAME('GR',
645: 'GR_UNEXPECTED_ERROR');
646: FND_MESSAGE.SET_TOKEN('TEXT',
647: l_msg_data,
648: FALSE);
649: IF FND_API.To_Boolean(p_called_by_form) THEN
650: APP_EXCEPTION.Raise_Exception;

Line 652: x_msg_data := FND_MESSAGE.Get;

648: FALSE);
649: IF FND_API.To_Boolean(p_called_by_form) THEN
650: APP_EXCEPTION.Raise_Exception;
651: ELSE
652: x_msg_data := FND_MESSAGE.Get;
653: END IF;
654:
655: END Update_Display_Columns;
656:

Line 766: FND_MESSAGE.SET_NAME('GR',

762: WHEN No_Data_Found_Error THEN
763: ROLLBACK TO SAVEPOINT Lock_Row;
764: l_msg_data := p_document_structures_seqno || ' ' || p_document_headings_seqno;
765: x_return_status := 'E';
766: FND_MESSAGE.SET_NAME('GR',
767: 'GR_RECORD_NOT_FOUND');
768: FND_MESSAGE.SET_TOKEN('CODE',
769: l_msg_data,
770: FALSE);

Line 768: FND_MESSAGE.SET_TOKEN('CODE',

764: l_msg_data := p_document_structures_seqno || ' ' || p_document_headings_seqno;
765: x_return_status := 'E';
766: FND_MESSAGE.SET_NAME('GR',
767: 'GR_RECORD_NOT_FOUND');
768: FND_MESSAGE.SET_TOKEN('CODE',
769: l_msg_data,
770: FALSE);
771: IF FND_API.To_Boolean(p_called_by_form) THEN
772: APP_EXCEPTION.Raise_Exception;

Line 774: x_msg_data := FND_MESSAGE.Get;

770: FALSE);
771: IF FND_API.To_Boolean(p_called_by_form) THEN
772: APP_EXCEPTION.Raise_Exception;
773: ELSE
774: x_msg_data := FND_MESSAGE.Get;
775: END IF;
776:
777: WHEN Row_Already_Locked_Error THEN
778: ROLLBACK TO SAVEPOINT Lock_Row;

Line 781: FND_MESSAGE.SET_NAME('GR',

777: WHEN Row_Already_Locked_Error THEN
778: ROLLBACK TO SAVEPOINT Lock_Row;
779: x_return_status := 'E';
780: x_oracle_error := APP_EXCEPTION.Get_Code;
781: FND_MESSAGE.SET_NAME('GR',
782: 'GR_ROW_IS_LOCKED');
783: IF FND_API.To_Boolean(p_called_by_form) THEN
784: APP_EXCEPTION.Raise_Exception;
785: ELSE

Line 786: x_msg_data := FND_MESSAGE.Get;

782: 'GR_ROW_IS_LOCKED');
783: IF FND_API.To_Boolean(p_called_by_form) THEN
784: APP_EXCEPTION.Raise_Exception;
785: ELSE
786: x_msg_data := FND_MESSAGE.Get;
787: END IF;
788:
789: WHEN OTHERS THEN
790: ROLLBACK TO SAVEPOINT Lock_Row;

Line 794: FND_MESSAGE.SET_NAME('GR',

790: ROLLBACK TO SAVEPOINT Lock_Row;
791: x_return_status := 'U';
792: x_oracle_error := APP_EXCEPTION.Get_Code;
793: l_msg_data := APP_EXCEPTION.Get_Text;
794: FND_MESSAGE.SET_NAME('GR',
795: 'GR_UNEXPECTED_ERROR');
796: FND_MESSAGE.SET_TOKEN('TEXT',
797: l_msg_data,
798: FALSE);

Line 796: FND_MESSAGE.SET_TOKEN('TEXT',

792: x_oracle_error := APP_EXCEPTION.Get_Code;
793: l_msg_data := APP_EXCEPTION.Get_Text;
794: FND_MESSAGE.SET_NAME('GR',
795: 'GR_UNEXPECTED_ERROR');
796: FND_MESSAGE.SET_TOKEN('TEXT',
797: l_msg_data,
798: FALSE);
799: IF FND_API.To_Boolean(p_called_by_form) THEN
800: APP_EXCEPTION.Raise_Exception;

Line 802: x_msg_data := FND_MESSAGE.Get;

798: FALSE);
799: IF FND_API.To_Boolean(p_called_by_form) THEN
800: APP_EXCEPTION.Raise_Exception;
801: ELSE
802: x_msg_data := FND_MESSAGE.Get;
803: END IF;
804:
805: END Lock_Row;
806:

Line 956: x_msg_data := FND_MESSAGE.Get;

952: x_oracle_error := l_oracle_error;
953: IF FND_API.To_Boolean(p_called_by_form) THEN
954: APP_EXCEPTION.Raise_Exception;
955: ELSE
956: x_msg_data := FND_MESSAGE.Get;
957: END IF;
958:
959: WHEN Row_Missing_Error THEN
960: ROLLBACK TO SAVEPOINT Delete_Row;

Line 964: FND_MESSAGE.SET_NAME('GR',

960: ROLLBACK TO SAVEPOINT Delete_Row;
961: l_msg_data := p_document_structures_seqno || ' ' || p_document_headings_seqno;
962: x_return_status := 'E';
963: x_oracle_error := APP_EXCEPTION.Get_Code;
964: FND_MESSAGE.SET_NAME('GR',
965: 'GR_RECORD_NOT_FOUND');
966: FND_MESSAGE.SET_TOKEN('CODE',
967: l_msg_data,
968: FALSE);

Line 966: FND_MESSAGE.SET_TOKEN('CODE',

962: x_return_status := 'E';
963: x_oracle_error := APP_EXCEPTION.Get_Code;
964: FND_MESSAGE.SET_NAME('GR',
965: 'GR_RECORD_NOT_FOUND');
966: FND_MESSAGE.SET_TOKEN('CODE',
967: l_msg_data,
968: FALSE);
969: IF FND_API.To_Boolean(p_called_by_form) THEN
970: APP_EXCEPTION.Raise_Exception;

Line 972: x_msg_data := FND_MESSAGE.Get;

968: FALSE);
969: IF FND_API.To_Boolean(p_called_by_form) THEN
970: APP_EXCEPTION.Raise_Exception;
971: ELSE
972: x_msg_data := FND_MESSAGE.Get;
973: END IF;
974:
975: WHEN OTHERS THEN
976: ROLLBACK TO SAVEPOINT Delete_Row;

Line 981: FND_MESSAGE.SET_NAME('GR',

977: x_return_status := 'U';
978: x_oracle_error := APP_EXCEPTION.Get_Code;
979: l_msg_data := APP_EXCEPTION.Get_Text;
980: l_msg_data := APP_EXCEPTION.Get_Text;
981: FND_MESSAGE.SET_NAME('GR',
982: 'GR_UNEXPECTED_ERROR');
983: FND_MESSAGE.SET_TOKEN('TEXT',
984: l_msg_data,
985: FALSE);

Line 983: FND_MESSAGE.SET_TOKEN('TEXT',

979: l_msg_data := APP_EXCEPTION.Get_Text;
980: l_msg_data := APP_EXCEPTION.Get_Text;
981: FND_MESSAGE.SET_NAME('GR',
982: 'GR_UNEXPECTED_ERROR');
983: FND_MESSAGE.SET_TOKEN('TEXT',
984: l_msg_data,
985: FALSE);
986: IF FND_API.To_Boolean(p_called_by_form) THEN
987: APP_EXCEPTION.Raise_Exception;

Line 989: x_msg_data := FND_MESSAGE.Get;

985: FALSE);
986: IF FND_API.To_Boolean(p_called_by_form) THEN
987: APP_EXCEPTION.Raise_Exception;
988: ELSE
989: x_msg_data := FND_MESSAGE.Get;
990: END IF;
991:
992: END Delete_Row;
993:

Line 1072: FND_MESSAGE.SET_NAME('GR',

1068: l_key_exists);
1069:
1070: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1071: x_return_status := 'E';
1072: FND_MESSAGE.SET_NAME('GR',
1073: 'GR_RECORD_NOT_FOUND');
1074: FND_MESSAGE.SET_TOKEN('CODE',
1075: p_document_headings_seqno,
1076: FALSE);

Line 1074: FND_MESSAGE.SET_TOKEN('CODE',

1070: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1071: x_return_status := 'E';
1072: FND_MESSAGE.SET_NAME('GR',
1073: 'GR_RECORD_NOT_FOUND');
1074: FND_MESSAGE.SET_TOKEN('CODE',
1075: p_document_headings_seqno,
1076: FALSE);
1077: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1078: END IF;

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

1073: 'GR_RECORD_NOT_FOUND');
1074: FND_MESSAGE.SET_TOKEN('CODE',
1075: p_document_headings_seqno,
1076: FALSE);
1077: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1078: END IF;
1079:
1080: /* Check the label code */
1081:

Line 1092: FND_MESSAGE.SET_NAME('GR',

1088: l_key_exists);
1089:
1090: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1091: x_return_status := 'E';
1092: FND_MESSAGE.SET_NAME('GR',
1093: 'GR_RECORD_NOT_FOUND');
1094: FND_MESSAGE.SET_TOKEN('CODE',
1095: p_label_code,
1096: FALSE);

Line 1094: FND_MESSAGE.SET_TOKEN('CODE',

1090: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1091: x_return_status := 'E';
1092: FND_MESSAGE.SET_NAME('GR',
1093: 'GR_RECORD_NOT_FOUND');
1094: FND_MESSAGE.SET_TOKEN('CODE',
1095: p_label_code,
1096: FALSE);
1097: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1098: END IF;

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

1093: 'GR_RECORD_NOT_FOUND');
1094: FND_MESSAGE.SET_TOKEN('CODE',
1095: p_label_code,
1096: FALSE);
1097: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1098: END IF;
1099: END IF;
1100:
1101: /* Check the phrase group code */

Line 1113: FND_MESSAGE.SET_NAME('GR',

1109: l_key_exists);
1110:
1111: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1112: x_return_status := 'E';
1113: FND_MESSAGE.SET_NAME('GR',
1114: 'GR_RECORD_NOT_FOUND');
1115: FND_MESSAGE.SET_TOKEN('CODE',
1116: p_phrase_group_code,
1117: FALSE);

Line 1115: FND_MESSAGE.SET_TOKEN('CODE',

1111: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1112: x_return_status := 'E';
1113: FND_MESSAGE.SET_NAME('GR',
1114: 'GR_RECORD_NOT_FOUND');
1115: FND_MESSAGE.SET_TOKEN('CODE',
1116: p_phrase_group_code,
1117: FALSE);
1118: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1119: END IF;

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

1114: 'GR_RECORD_NOT_FOUND');
1115: FND_MESSAGE.SET_TOKEN('CODE',
1116: p_phrase_group_code,
1117: FALSE);
1118: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1119: END IF;
1120: END IF;
1121:
1122: /* Check the phrase code */

Line 1134: FND_MESSAGE.SET_NAME('GR',

1130: l_key_exists);
1131:
1132: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1133: x_return_status := 'E';
1134: FND_MESSAGE.SET_NAME('GR',
1135: 'GR_RECORD_NOT_FOUND');
1136: FND_MESSAGE.SET_TOKEN('CODE',
1137: p_phrase_code,
1138: FALSE);

Line 1136: FND_MESSAGE.SET_TOKEN('CODE',

1132: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1133: x_return_status := 'E';
1134: FND_MESSAGE.SET_NAME('GR',
1135: 'GR_RECORD_NOT_FOUND');
1136: FND_MESSAGE.SET_TOKEN('CODE',
1137: p_phrase_code,
1138: FALSE);
1139: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1140: END IF;

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

1135: 'GR_RECORD_NOT_FOUND');
1136: FND_MESSAGE.SET_TOKEN('CODE',
1137: p_phrase_code,
1138: FALSE);
1139: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1140: END IF;
1141: END IF;
1142:
1143: IF x_return_status <> 'S' THEN

Line 1154: FND_MESSAGE.SET_NAME('GR',

1150: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1151: x_return_status := 'U';
1152: x_oracle_error := APP_EXCEPTION.Get_Code;
1153: l_msg_data := APP_EXCEPTION.Get_Text;
1154: FND_MESSAGE.SET_NAME('GR',
1155: 'GR_UNEXPECTED_ERROR');
1156: FND_MESSAGE.SET_TOKEN('TEXT',
1157: l_msg_data,
1158: FALSE);

Line 1156: FND_MESSAGE.SET_TOKEN('TEXT',

1152: x_oracle_error := APP_EXCEPTION.Get_Code;
1153: l_msg_data := APP_EXCEPTION.Get_Text;
1154: FND_MESSAGE.SET_NAME('GR',
1155: 'GR_UNEXPECTED_ERROR');
1156: FND_MESSAGE.SET_TOKEN('TEXT',
1157: l_msg_data,
1158: FALSE);
1159: x_msg_data := FND_MESSAGE.Get;
1160:

Line 1159: x_msg_data := FND_MESSAGE.Get;

1155: 'GR_UNEXPECTED_ERROR');
1156: FND_MESSAGE.SET_TOKEN('TEXT',
1157: l_msg_data,
1158: FALSE);
1159: x_msg_data := FND_MESSAGE.Get;
1160:
1161: END Check_Foreign_Keys;
1162:
1163: PROCEDURE Check_Integrity

Line 1248: FND_MESSAGE.SET_NAME('GR',

1244: ROLLBACK TO SAVEPOINT Check_Integrity;
1245: x_return_status := 'U';
1246: x_oracle_error := APP_EXCEPTION.Get_Code;
1247: l_msg_data := APP_EXCEPTION.Get_Text;
1248: FND_MESSAGE.SET_NAME('GR',
1249: 'GR_UNEXPECTED_ERROR');
1250: FND_MESSAGE.SET_TOKEN('TEXT',
1251: l_msg_data,
1252: FALSE);

Line 1250: FND_MESSAGE.SET_TOKEN('TEXT',

1246: x_oracle_error := APP_EXCEPTION.Get_Code;
1247: l_msg_data := APP_EXCEPTION.Get_Text;
1248: FND_MESSAGE.SET_NAME('GR',
1249: 'GR_UNEXPECTED_ERROR');
1250: FND_MESSAGE.SET_TOKEN('TEXT',
1251: l_msg_data,
1252: FALSE);
1253: IF FND_API.To_Boolean(p_called_by_form) THEN
1254: APP_EXCEPTION.Raise_Exception;

Line 1256: x_msg_data := FND_MESSAGE.Get;

1252: FALSE);
1253: IF FND_API.To_Boolean(p_called_by_form) THEN
1254: APP_EXCEPTION.Raise_Exception;
1255: ELSE
1256: x_msg_data := FND_MESSAGE.Get;
1257: END IF;
1258:
1259: END Check_Integrity;
1260:

Line 1307: FND_MESSAGE.SET_NAME('GR',

1303: EXCEPTION
1304:
1305: WHEN Others THEN
1306: l_msg_data := APP_EXCEPTION.Get_Text;
1307: FND_MESSAGE.SET_NAME('GR',
1308: 'GR_UNEXPECTED_ERROR');
1309: FND_MESSAGE.SET_TOKEN('TEXT',
1310: l_msg_data,
1311: FALSE);

Line 1309: FND_MESSAGE.SET_TOKEN('TEXT',

1305: WHEN Others THEN
1306: l_msg_data := APP_EXCEPTION.Get_Text;
1307: FND_MESSAGE.SET_NAME('GR',
1308: 'GR_UNEXPECTED_ERROR');
1309: FND_MESSAGE.SET_TOKEN('TEXT',
1310: l_msg_data,
1311: FALSE);
1312: IF FND_API.To_Boolean(p_called_by_form) THEN
1313: APP_EXCEPTION.Raise_Exception;