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

Line 293: FND_MESSAGE.SET_NAME('GR',

289: WHEN Foreign_Key_Error THEN
290: ROLLBACK TO SAVEPOINT Insert_Row;
291: x_return_status := l_return_status;
292: x_oracle_error := l_oracle_error;
293: FND_MESSAGE.SET_NAME('GR',
294: 'GR_FOREIGN_KEY_ERROR');
295: FND_MESSAGE.SET_TOKEN('TEXT',
296: l_msg_data,
297: FALSE);

Line 295: FND_MESSAGE.SET_TOKEN('TEXT',

291: x_return_status := l_return_status;
292: x_oracle_error := l_oracle_error;
293: FND_MESSAGE.SET_NAME('GR',
294: 'GR_FOREIGN_KEY_ERROR');
295: FND_MESSAGE.SET_TOKEN('TEXT',
296: l_msg_data,
297: FALSE);
298: IF FND_API.To_Boolean(p_called_by_form) THEN
299: APP_EXCEPTION.Raise_Exception;

Line 301: x_msg_data := FND_MESSAGE.Get;

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

Line 308: FND_MESSAGE.SET_NAME('GR',

304: WHEN Label_Exists_Error THEN
305: ROLLBACK TO SAVEPOINT Insert_Row;
306: x_return_status := 'E';
307: x_oracle_error := APP_EXCEPTION.Get_Code;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_RECORD_EXISTS');
310: FND_MESSAGE.SET_TOKEN('CODE',
311: p_recipient_code,
312: FALSE);

Line 310: FND_MESSAGE.SET_TOKEN('CODE',

306: x_return_status := 'E';
307: x_oracle_error := APP_EXCEPTION.Get_Code;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_RECORD_EXISTS');
310: FND_MESSAGE.SET_TOKEN('CODE',
311: p_recipient_code,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;

Line 316: x_msg_data := FND_MESSAGE.Get;

312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:
319: WHEN Row_Missing_Error THEN
320: ROLLBACK TO SAVEPOINT Insert_Row;

Line 323: FND_MESSAGE.SET_NAME('GR',

319: WHEN Row_Missing_Error THEN
320: ROLLBACK TO SAVEPOINT Insert_Row;
321: x_return_status := 'E';
322: x_oracle_error := APP_EXCEPTION.Get_Code;
323: FND_MESSAGE.SET_NAME('GR',
324: 'GR_NO_RECORD_INSERTED');
325: FND_MESSAGE.SET_TOKEN('CODE',
326: p_recipient_code,
327: FALSE);

Line 325: FND_MESSAGE.SET_TOKEN('CODE',

321: x_return_status := 'E';
322: x_oracle_error := APP_EXCEPTION.Get_Code;
323: FND_MESSAGE.SET_NAME('GR',
324: 'GR_NO_RECORD_INSERTED');
325: FND_MESSAGE.SET_TOKEN('CODE',
326: p_recipient_code,
327: FALSE);
328: IF FND_API.To_Boolean(p_called_by_form) THEN
329: APP_EXCEPTION.Raise_Exception;

Line 331: x_msg_data := FND_MESSAGE.Get;

327: FALSE);
328: IF FND_API.To_Boolean(p_called_by_form) THEN
329: APP_EXCEPTION.Raise_Exception;
330: ELSE
331: x_msg_data := FND_MESSAGE.Get;
332: END IF;
333:
334: WHEN OTHERS THEN
335: ROLLBACK TO SAVEPOINT Insert_Row;

Line 339: FND_MESSAGE.SET_NAME('GR',

335: ROLLBACK TO SAVEPOINT Insert_Row;
336: x_return_status := 'U';
337: x_oracle_error := APP_EXCEPTION.Get_Code;
338: l_msg_data := APP_EXCEPTION.Get_Text;
339: FND_MESSAGE.SET_NAME('GR',
340: 'GR_UNEXPECTED_ERROR');
341: FND_MESSAGE.SET_TOKEN('TEXT',
342: l_msg_data,
343: FALSE);

Line 341: FND_MESSAGE.SET_TOKEN('TEXT',

337: x_oracle_error := APP_EXCEPTION.Get_Code;
338: l_msg_data := APP_EXCEPTION.Get_Text;
339: FND_MESSAGE.SET_NAME('GR',
340: 'GR_UNEXPECTED_ERROR');
341: FND_MESSAGE.SET_TOKEN('TEXT',
342: l_msg_data,
343: FALSE);
344: IF FND_API.To_Boolean(p_called_by_form) THEN
345: APP_EXCEPTION.Raise_Exception;

Line 347: x_msg_data := FND_MESSAGE.Get;

343: FALSE);
344: IF FND_API.To_Boolean(p_called_by_form) THEN
345: APP_EXCEPTION.Raise_Exception;
346: ELSE
347: x_msg_data := FND_MESSAGE.Get;
348: END IF;
349:
350: END Insert_Row;
351:

Line 564: FND_MESSAGE.SET_NAME('GR',

560: WHEN Foreign_Key_Error THEN
561: ROLLBACK TO SAVEPOINT Update_Row;
562: x_return_status := l_return_status;
563: x_oracle_error := l_oracle_error;
564: FND_MESSAGE.SET_NAME('GR',
565: 'GR_FOREIGN_KEY_ERROR');
566: FND_MESSAGE.SET_TOKEN('TEXT',
567: l_msg_data,
568: FALSE);

Line 566: FND_MESSAGE.SET_TOKEN('TEXT',

562: x_return_status := l_return_status;
563: x_oracle_error := l_oracle_error;
564: FND_MESSAGE.SET_NAME('GR',
565: 'GR_FOREIGN_KEY_ERROR');
566: FND_MESSAGE.SET_TOKEN('TEXT',
567: l_msg_data,
568: FALSE);
569: IF FND_API.To_Boolean(p_called_by_form) THEN
570: APP_EXCEPTION.Raise_Exception;

Line 572: x_msg_data := FND_MESSAGE.Get;

568: FALSE);
569: IF FND_API.To_Boolean(p_called_by_form) THEN
570: APP_EXCEPTION.Raise_Exception;
571: ELSE
572: x_msg_data := FND_MESSAGE.Get;
573: END IF;
574:
575: WHEN Row_Missing_Error THEN
576: ROLLBACK TO SAVEPOINT Update_Row;

Line 579: FND_MESSAGE.SET_NAME('GR',

575: WHEN Row_Missing_Error THEN
576: ROLLBACK TO SAVEPOINT Update_Row;
577: x_return_status := 'E';
578: x_oracle_error := APP_EXCEPTION.Get_Code;
579: FND_MESSAGE.SET_NAME('GR',
580: 'GR_NO_RECORD_INSERTED');
581: FND_MESSAGE.SET_TOKEN('CODE',
582: p_recipient_code,
583: FALSE);

Line 581: FND_MESSAGE.SET_TOKEN('CODE',

577: x_return_status := 'E';
578: x_oracle_error := APP_EXCEPTION.Get_Code;
579: FND_MESSAGE.SET_NAME('GR',
580: 'GR_NO_RECORD_INSERTED');
581: FND_MESSAGE.SET_TOKEN('CODE',
582: p_recipient_code,
583: FALSE);
584: IF FND_API.To_Boolean(p_called_by_form) THEN
585: APP_EXCEPTION.Raise_Exception;

Line 587: x_msg_data := FND_MESSAGE.Get;

583: FALSE);
584: IF FND_API.To_Boolean(p_called_by_form) THEN
585: APP_EXCEPTION.Raise_Exception;
586: ELSE
587: x_msg_data := FND_MESSAGE.Get;
588: END IF;
589:
590: WHEN OTHERS THEN
591: ROLLBACK TO SAVEPOINT Update_Row;

Line 595: FND_MESSAGE.SET_NAME('GR',

591: ROLLBACK TO SAVEPOINT Update_Row;
592: x_return_status := 'U';
593: x_oracle_error := APP_EXCEPTION.Get_Code;
594: l_msg_data := APP_EXCEPTION.Get_Text;
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_UNEXPECTED_ERROR');
597: FND_MESSAGE.SET_TOKEN('TEXT',
598: l_msg_data,
599: FALSE);

Line 597: FND_MESSAGE.SET_TOKEN('TEXT',

593: x_oracle_error := APP_EXCEPTION.Get_Code;
594: l_msg_data := APP_EXCEPTION.Get_Text;
595: FND_MESSAGE.SET_NAME('GR',
596: 'GR_UNEXPECTED_ERROR');
597: FND_MESSAGE.SET_TOKEN('TEXT',
598: l_msg_data,
599: FALSE);
600: IF FND_API.To_Boolean(p_called_by_form) THEN
601: APP_EXCEPTION.Raise_Exception;

Line 603: x_msg_data := FND_MESSAGE.Get;

599: FALSE);
600: IF FND_API.To_Boolean(p_called_by_form) THEN
601: APP_EXCEPTION.Raise_Exception;
602: ELSE
603: x_msg_data := FND_MESSAGE.Get;
604: END IF;
605:
606: END Update_Row;
607:

Line 726: FND_MESSAGE.SET_NAME('GR',

722:
723: WHEN No_Data_Found_Error THEN
724: ROLLBACK TO SAVEPOINT Lock_Row;
725: x_return_status := 'E';
726: FND_MESSAGE.SET_NAME('GR',
727: 'GR_RECORD_NOT_FOUND');
728: FND_MESSAGE.SET_TOKEN('CODE',
729: p_recipient_code,
730: FALSE);

Line 728: FND_MESSAGE.SET_TOKEN('CODE',

724: ROLLBACK TO SAVEPOINT Lock_Row;
725: x_return_status := 'E';
726: FND_MESSAGE.SET_NAME('GR',
727: 'GR_RECORD_NOT_FOUND');
728: FND_MESSAGE.SET_TOKEN('CODE',
729: p_recipient_code,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;

Line 734: x_msg_data := FND_MESSAGE.Get;

730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;
736:
737: WHEN RECORD_CHANGED_ERROR THEN
738: ROLLBACK TO SAVEPOINT Lock_Row;

Line 740: FND_MESSAGE.SET_NAME('FND',

736:
737: WHEN RECORD_CHANGED_ERROR THEN
738: ROLLBACK TO SAVEPOINT Lock_Row;
739: X_return_status := 'E';
740: FND_MESSAGE.SET_NAME('FND',
741: 'FORM_RECORD_CHANGED');
742: IF FND_API.To_Boolean(p_called_by_form) THEN
743: APP_EXCEPTION.Raise_Exception;
744: ELSE

Line 745: x_msg_data := FND_MESSAGE.Get;

741: 'FORM_RECORD_CHANGED');
742: IF FND_API.To_Boolean(p_called_by_form) THEN
743: APP_EXCEPTION.Raise_Exception;
744: ELSE
745: x_msg_data := FND_MESSAGE.Get;
746: END IF;
747: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
748: ROLLBACK TO SAVEPOINT Lock_Row;
749: x_return_status := 'L';

Line 752: FND_MESSAGE.SET_NAME('GR',

748: ROLLBACK TO SAVEPOINT Lock_Row;
749: x_return_status := 'L';
750: x_oracle_error := APP_EXCEPTION.Get_Code;
751: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
752: FND_MESSAGE.SET_NAME('GR',
753: 'GR_ROW_IS_LOCKED');
754: x_msg_data := FND_MESSAGE.Get;
755: END IF;
756:

Line 754: x_msg_data := FND_MESSAGE.Get;

750: x_oracle_error := APP_EXCEPTION.Get_Code;
751: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
752: FND_MESSAGE.SET_NAME('GR',
753: 'GR_ROW_IS_LOCKED');
754: x_msg_data := FND_MESSAGE.Get;
755: END IF;
756:
757: WHEN OTHERS THEN
758: ROLLBACK TO SAVEPOINT Lock_Row;

Line 762: FND_MESSAGE.SET_NAME('GR',

758: ROLLBACK TO SAVEPOINT Lock_Row;
759: x_return_status := 'U';
760: x_oracle_error := APP_EXCEPTION.Get_Code;
761: l_msg_data := APP_EXCEPTION.Get_Text;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_UNEXPECTED_ERROR');
764: FND_MESSAGE.SET_TOKEN('TEXT',
765: l_msg_data,
766: FALSE);

Line 764: FND_MESSAGE.SET_TOKEN('TEXT',

760: x_oracle_error := APP_EXCEPTION.Get_Code;
761: l_msg_data := APP_EXCEPTION.Get_Text;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_UNEXPECTED_ERROR');
764: FND_MESSAGE.SET_TOKEN('TEXT',
765: l_msg_data,
766: FALSE);
767: IF FND_API.To_Boolean(p_called_by_form) THEN
768: APP_EXCEPTION.Raise_Exception;

Line 770: x_msg_data := FND_MESSAGE.Get;

766: FALSE);
767: IF FND_API.To_Boolean(p_called_by_form) THEN
768: APP_EXCEPTION.Raise_Exception;
769: ELSE
770: x_msg_data := FND_MESSAGE.Get;
771: END IF;
772:
773: END Lock_Row;
774:

Line 939: x_msg_data := FND_MESSAGE.Get;

935: x_oracle_error := l_oracle_error;
936: IF FND_API.To_Boolean(p_called_by_form) THEN
937: APP_EXCEPTION.Raise_Exception;
938: ELSE
939: x_msg_data := FND_MESSAGE.Get;
940: END IF;
941:
942: WHEN Row_Missing_Error THEN
943: ROLLBACK TO SAVEPOINT Delete_Row;

Line 946: FND_MESSAGE.SET_NAME('GR',

942: WHEN Row_Missing_Error THEN
943: ROLLBACK TO SAVEPOINT Delete_Row;
944: x_return_status := 'E';
945: x_oracle_error := APP_EXCEPTION.Get_Code;
946: FND_MESSAGE.SET_NAME('GR',
947: 'GR_RECORD_NOT_FOUND');
948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_recipient_code,
950: FALSE);

Line 948: FND_MESSAGE.SET_TOKEN('CODE',

944: x_return_status := 'E';
945: x_oracle_error := APP_EXCEPTION.Get_Code;
946: FND_MESSAGE.SET_NAME('GR',
947: 'GR_RECORD_NOT_FOUND');
948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_recipient_code,
950: FALSE);
951: IF FND_API.To_Boolean(p_called_by_form) THEN
952: APP_EXCEPTION.Raise_Exception;

Line 954: x_msg_data := FND_MESSAGE.Get;

950: FALSE);
951: IF FND_API.To_Boolean(p_called_by_form) THEN
952: APP_EXCEPTION.Raise_Exception;
953: ELSE
954: x_msg_data := FND_MESSAGE.Get;
955: END IF;
956:
957: WHEN OTHERS THEN
958: ROLLBACK TO SAVEPOINT Delete_Row;

Line 963: FND_MESSAGE.SET_NAME('GR',

959: x_return_status := 'U';
960: x_oracle_error := APP_EXCEPTION.Get_Code;
961: l_msg_data := APP_EXCEPTION.Get_Text;
962: l_msg_data := APP_EXCEPTION.Get_Text;
963: FND_MESSAGE.SET_NAME('GR',
964: 'GR_UNEXPECTED_ERROR');
965: FND_MESSAGE.SET_TOKEN('TEXT',
966: l_msg_data,
967: FALSE);

Line 965: FND_MESSAGE.SET_TOKEN('TEXT',

961: l_msg_data := APP_EXCEPTION.Get_Text;
962: l_msg_data := APP_EXCEPTION.Get_Text;
963: FND_MESSAGE.SET_NAME('GR',
964: 'GR_UNEXPECTED_ERROR');
965: FND_MESSAGE.SET_TOKEN('TEXT',
966: l_msg_data,
967: FALSE);
968: IF FND_API.To_Boolean(p_called_by_form) THEN
969: APP_EXCEPTION.Raise_Exception;

Line 971: x_msg_data := FND_MESSAGE.Get;

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

Line 1076: FND_MESSAGE.SET_NAME('GR',

1072: l_key_exists);
1073:
1074: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1075: x_return_status := 'E';
1076: FND_MESSAGE.SET_NAME('GR',
1077: 'GR_RECORD_NOT_FOUND');
1078: FND_MESSAGE.SET_TOKEN('CODE',
1079: p_document_code,
1080: FALSE);

Line 1078: FND_MESSAGE.SET_TOKEN('CODE',

1074: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1075: x_return_status := 'E';
1076: FND_MESSAGE.SET_NAME('GR',
1077: 'GR_RECORD_NOT_FOUND');
1078: FND_MESSAGE.SET_TOKEN('CODE',
1079: p_document_code,
1080: FALSE);
1081: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1082: END IF;

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

1077: 'GR_RECORD_NOT_FOUND');
1078: FND_MESSAGE.SET_TOKEN('CODE',
1079: p_document_code,
1080: FALSE);
1081: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1082: END IF;
1083: END IF;
1084: /* Region Code */
1085:

Line 1096: FND_MESSAGE.SET_NAME('GR',

1092: l_key_exists);
1093:
1094: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1095: x_return_status := 'E';
1096: FND_MESSAGE.SET_NAME('GR',
1097: 'GR_RECORD_NOT_FOUND');
1098: FND_MESSAGE.SET_TOKEN('CODE',
1099: p_region_code,
1100: FALSE);

Line 1098: FND_MESSAGE.SET_TOKEN('CODE',

1094: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1095: x_return_status := 'E';
1096: FND_MESSAGE.SET_NAME('GR',
1097: 'GR_RECORD_NOT_FOUND');
1098: FND_MESSAGE.SET_TOKEN('CODE',
1099: p_region_code,
1100: FALSE);
1101: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1102: END IF;

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

1097: 'GR_RECORD_NOT_FOUND');
1098: FND_MESSAGE.SET_TOKEN('CODE',
1099: p_region_code,
1100: FALSE);
1101: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1102: END IF;
1103: END IF;
1104:
1105: /* Disclosure Code */

Line 1112: FND_MESSAGE.SET_NAME('GR',

1108: OPEN c_get_disc_code;
1109: FETCH c_get_disc_code INTO DiscRecord;
1110: IF c_get_disc_code%NOTFOUND THEN
1111: x_return_status := 'E';
1112: FND_MESSAGE.SET_NAME('GR',
1113: 'GR_RECORD_NOT_FOUND');
1114: FND_MESSAGE.SET_TOKEN('CODE',
1115: p_disclosure_code,
1116: FALSE);

Line 1114: FND_MESSAGE.SET_TOKEN('CODE',

1110: IF c_get_disc_code%NOTFOUND THEN
1111: x_return_status := 'E';
1112: FND_MESSAGE.SET_NAME('GR',
1113: 'GR_RECORD_NOT_FOUND');
1114: FND_MESSAGE.SET_TOKEN('CODE',
1115: p_disclosure_code,
1116: FALSE);
1117: l_msg_data := l_msg_data || ' ' || FND_MESSAGE.Get;
1118: END IF;

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

1113: 'GR_RECORD_NOT_FOUND');
1114: FND_MESSAGE.SET_TOKEN('CODE',
1115: p_disclosure_code,
1116: FALSE);
1117: l_msg_data := l_msg_data || ' ' || FND_MESSAGE.Get;
1118: END IF;
1119: CLOSE c_get_disc_code;
1120: END IF;
1121:

Line 1128: FND_MESSAGE.SET_NAME('GR',

1124: OPEN c_get_territory;
1125: FETCH c_get_territory INTO TerrRecord;
1126: IF c_get_territory%NOTFOUND THEN
1127: x_return_status := 'E';
1128: FND_MESSAGE.SET_NAME('GR',
1129: 'GR_RECORD_NOT_FOUND');
1130: FND_MESSAGE.SET_TOKEN('CODE',
1131: p_territory_code,
1132: FALSE);

Line 1130: FND_MESSAGE.SET_TOKEN('CODE',

1126: IF c_get_territory%NOTFOUND THEN
1127: x_return_status := 'E';
1128: FND_MESSAGE.SET_NAME('GR',
1129: 'GR_RECORD_NOT_FOUND');
1130: FND_MESSAGE.SET_TOKEN('CODE',
1131: p_territory_code,
1132: FALSE);
1133: l_msg_data := l_msg_data || ' ' || FND_MESSAGE.Get;
1134: END IF;

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

1129: 'GR_RECORD_NOT_FOUND');
1130: FND_MESSAGE.SET_TOKEN('CODE',
1131: p_territory_code,
1132: FALSE);
1133: l_msg_data := l_msg_data || ' ' || FND_MESSAGE.Get;
1134: END IF;
1135: CLOSE c_get_territory;
1136:
1137: IF x_return_status <> 'S' THEN

Line 1148: FND_MESSAGE.SET_NAME('GR',

1144: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1145: x_return_status := 'U';
1146: x_oracle_error := APP_EXCEPTION.Get_Code;
1147: l_msg_data := APP_EXCEPTION.Get_Text;
1148: FND_MESSAGE.SET_NAME('GR',
1149: 'GR_UNEXPECTED_ERROR');
1150: FND_MESSAGE.SET_TOKEN('TEXT',
1151: l_msg_data,
1152: FALSE);

Line 1150: FND_MESSAGE.SET_TOKEN('TEXT',

1146: x_oracle_error := APP_EXCEPTION.Get_Code;
1147: l_msg_data := APP_EXCEPTION.Get_Text;
1148: FND_MESSAGE.SET_NAME('GR',
1149: 'GR_UNEXPECTED_ERROR');
1150: FND_MESSAGE.SET_TOKEN('TEXT',
1151: l_msg_data,
1152: FALSE);
1153: x_msg_data := FND_MESSAGE.Get;
1154:

Line 1153: x_msg_data := FND_MESSAGE.Get;

1149: 'GR_UNEXPECTED_ERROR');
1150: FND_MESSAGE.SET_TOKEN('TEXT',
1151: l_msg_data,
1152: FALSE);
1153: x_msg_data := FND_MESSAGE.Get;
1154:
1155: END Check_Foreign_Keys;
1156:
1157: PROCEDURE Check_Integrity

Line 1240: FND_MESSAGE.SET_NAME('GR',

1236: x_return_status := 'S';
1237: x_oracle_error := 0;
1238: x_msg_data := NULL;
1239:
1240: FND_MESSAGE.SET_NAME('GR',
1241: 'GR_INTEGRITY_HEADER');
1242: FND_MESSAGE.SET_TOKEN('CODE',
1243: p_recipient_code,
1244: FALSE);

Line 1242: FND_MESSAGE.SET_TOKEN('CODE',

1238: x_msg_data := NULL;
1239:
1240: FND_MESSAGE.SET_NAME('GR',
1241: 'GR_INTEGRITY_HEADER');
1242: FND_MESSAGE.SET_TOKEN('CODE',
1243: p_recipient_code,
1244: FALSE);
1245: l_msg_data := FND_MESSAGE.Get;
1246:

Line 1245: l_msg_data := FND_MESSAGE.Get;

1241: 'GR_INTEGRITY_HEADER');
1242: FND_MESSAGE.SET_TOKEN('CODE',
1243: p_recipient_code,
1244: FALSE);
1245: l_msg_data := FND_MESSAGE.Get;
1246:
1247: /* Now read the cursors to make sure the recipient code isn't used. */
1248:
1249: /* Dispatch Histories */

Line 1275: FND_MESSAGE.SET_NAME('GR',

1271: ROLLBACK TO SAVEPOINT Check_Integrity;
1272: x_return_status := 'U';
1273: x_oracle_error := APP_EXCEPTION.Get_Code;
1274: l_msg_data := APP_EXCEPTION.Get_Text;
1275: FND_MESSAGE.SET_NAME('GR',
1276: 'GR_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('TEXT',
1278: l_msg_data,
1279: FALSE);

Line 1277: FND_MESSAGE.SET_TOKEN('TEXT',

1273: x_oracle_error := APP_EXCEPTION.Get_Code;
1274: l_msg_data := APP_EXCEPTION.Get_Text;
1275: FND_MESSAGE.SET_NAME('GR',
1276: 'GR_UNEXPECTED_ERROR');
1277: FND_MESSAGE.SET_TOKEN('TEXT',
1278: l_msg_data,
1279: FALSE);
1280: IF FND_API.To_Boolean(p_called_by_form) THEN
1281: APP_EXCEPTION.Raise_Exception;

Line 1283: x_msg_data := FND_MESSAGE.Get;

1279: FALSE);
1280: IF FND_API.To_Boolean(p_called_by_form) THEN
1281: APP_EXCEPTION.Raise_Exception;
1282: ELSE
1283: x_msg_data := FND_MESSAGE.Get;
1284: END IF;
1285:
1286: END Check_Integrity;
1287:

Line 1331: FND_MESSAGE.SET_NAME('GR',

1327: EXCEPTION
1328:
1329: WHEN Others THEN
1330: l_msg_data := APP_EXCEPTION.Get_Text;
1331: FND_MESSAGE.SET_NAME('GR',
1332: 'GR_UNEXPECTED_ERROR');
1333: FND_MESSAGE.SET_TOKEN('TEXT',
1334: l_msg_data,
1335: FALSE);

Line 1333: FND_MESSAGE.SET_TOKEN('TEXT',

1329: WHEN Others THEN
1330: l_msg_data := APP_EXCEPTION.Get_Text;
1331: FND_MESSAGE.SET_NAME('GR',
1332: 'GR_UNEXPECTED_ERROR');
1333: FND_MESSAGE.SET_TOKEN('TEXT',
1334: l_msg_data,
1335: FALSE);
1336: IF FND_API.To_Boolean(p_called_by_form) THEN
1337: APP_EXCEPTION.Raise_Exception;