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

Line 249: FND_MESSAGE.SET_NAME('GR',

245: WHEN Foreign_Key_Error THEN
246: ROLLBACK TO SAVEPOINT Insert_Row;
247: x_return_status := l_return_status;
248: x_oracle_error := l_oracle_error;
249: FND_MESSAGE.SET_NAME('GR',
250: 'GR_FOREIGN_KEY_ERROR');
251: FND_MESSAGE.SET_TOKEN('TEXT',
252: l_msg_data,
253: FALSE);

Line 251: FND_MESSAGE.SET_TOKEN('TEXT',

247: x_return_status := l_return_status;
248: x_oracle_error := l_oracle_error;
249: FND_MESSAGE.SET_NAME('GR',
250: 'GR_FOREIGN_KEY_ERROR');
251: FND_MESSAGE.SET_TOKEN('TEXT',
252: l_msg_data,
253: FALSE);
254: IF FND_API.To_Boolean(p_called_by_form) THEN
255: APP_EXCEPTION.Raise_Exception;

Line 257: x_msg_data := FND_MESSAGE.Get;

253: FALSE);
254: IF FND_API.To_Boolean(p_called_by_form) THEN
255: APP_EXCEPTION.Raise_Exception;
256: ELSE
257: x_msg_data := FND_MESSAGE.Get;
258: END IF;
259:
260: WHEN Label_Exists_Error THEN
261: ROLLBACK TO SAVEPOINT Insert_Row;

Line 264: FND_MESSAGE.SET_NAME('GR',

260: WHEN Label_Exists_Error THEN
261: ROLLBACK TO SAVEPOINT Insert_Row;
262: x_return_status := 'E';
263: x_oracle_error := APP_EXCEPTION.Get_Code;
264: FND_MESSAGE.SET_NAME('GR',
265: 'GR_RECORD_EXISTS');
266: FND_MESSAGE.SET_TOKEN('CODE',
267: p_label_class_code,
268: FALSE);

Line 266: FND_MESSAGE.SET_TOKEN('CODE',

262: x_return_status := 'E';
263: x_oracle_error := APP_EXCEPTION.Get_Code;
264: FND_MESSAGE.SET_NAME('GR',
265: 'GR_RECORD_EXISTS');
266: FND_MESSAGE.SET_TOKEN('CODE',
267: p_label_class_code,
268: FALSE);
269: IF FND_API.To_Boolean(p_called_by_form) THEN
270: APP_EXCEPTION.Raise_Exception;

Line 272: x_msg_data := FND_MESSAGE.Get;

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

Line 279: FND_MESSAGE.SET_NAME('GR',

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

Line 281: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 287: x_msg_data := FND_MESSAGE.Get;

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

Line 295: FND_MESSAGE.SET_NAME('GR',

291: ROLLBACK TO SAVEPOINT Insert_Row;
292: x_return_status := 'U';
293: x_oracle_error := APP_EXCEPTION.Get_Code;
294: l_msg_data := APP_EXCEPTION.Get_Text;
295: FND_MESSAGE.SET_NAME('GR',
296: 'GR_UNEXPECTED_ERROR');
297: FND_MESSAGE.SET_TOKEN('TEXT',
298: l_msg_data,
299: FALSE);

Line 297: FND_MESSAGE.SET_TOKEN('TEXT',

293: x_oracle_error := APP_EXCEPTION.Get_Code;
294: l_msg_data := APP_EXCEPTION.Get_Text;
295: FND_MESSAGE.SET_NAME('GR',
296: 'GR_UNEXPECTED_ERROR');
297: FND_MESSAGE.SET_TOKEN('TEXT',
298: l_msg_data,
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: END Insert_Row;
307:

Line 487: FND_MESSAGE.SET_NAME('GR',

483: WHEN Foreign_Key_Error THEN
484: ROLLBACK TO SAVEPOINT Update_Row;
485: x_return_status := l_return_status;
486: x_oracle_error := l_oracle_error;
487: FND_MESSAGE.SET_NAME('GR',
488: 'GR_FOREIGN_KEY_ERROR');
489: FND_MESSAGE.SET_TOKEN('TEXT',
490: l_msg_data,
491: FALSE);

Line 489: FND_MESSAGE.SET_TOKEN('TEXT',

485: x_return_status := l_return_status;
486: x_oracle_error := l_oracle_error;
487: FND_MESSAGE.SET_NAME('GR',
488: 'GR_FOREIGN_KEY_ERROR');
489: FND_MESSAGE.SET_TOKEN('TEXT',
490: l_msg_data,
491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;

Line 495: x_msg_data := FND_MESSAGE.Get;

491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;
494: ELSE
495: x_msg_data := FND_MESSAGE.Get;
496: END IF;
497:
498: WHEN Row_Missing_Error THEN
499: ROLLBACK TO SAVEPOINT Update_Row;

Line 502: FND_MESSAGE.SET_NAME('GR',

498: WHEN Row_Missing_Error THEN
499: ROLLBACK TO SAVEPOINT Update_Row;
500: x_return_status := 'E';
501: x_oracle_error := APP_EXCEPTION.Get_Code;
502: FND_MESSAGE.SET_NAME('GR',
503: 'GR_NO_RECORD_INSERTED');
504: FND_MESSAGE.SET_TOKEN('CODE',
505: p_label_class_code,
506: FALSE);

Line 504: FND_MESSAGE.SET_TOKEN('CODE',

500: x_return_status := 'E';
501: x_oracle_error := APP_EXCEPTION.Get_Code;
502: FND_MESSAGE.SET_NAME('GR',
503: 'GR_NO_RECORD_INSERTED');
504: FND_MESSAGE.SET_TOKEN('CODE',
505: p_label_class_code,
506: FALSE);
507: IF FND_API.To_Boolean(p_called_by_form) THEN
508: APP_EXCEPTION.Raise_Exception;

Line 510: x_msg_data := FND_MESSAGE.Get;

506: FALSE);
507: IF FND_API.To_Boolean(p_called_by_form) THEN
508: APP_EXCEPTION.Raise_Exception;
509: ELSE
510: x_msg_data := FND_MESSAGE.Get;
511: END IF;
512:
513: WHEN OTHERS THEN
514: ROLLBACK TO SAVEPOINT Update_Row;

Line 518: FND_MESSAGE.SET_NAME('GR',

514: ROLLBACK TO SAVEPOINT Update_Row;
515: x_return_status := 'U';
516: x_oracle_error := APP_EXCEPTION.Get_Code;
517: l_msg_data := APP_EXCEPTION.Get_Text;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_UNEXPECTED_ERROR');
520: FND_MESSAGE.SET_TOKEN('TEXT',
521: l_msg_data,
522: FALSE);

Line 520: FND_MESSAGE.SET_TOKEN('TEXT',

516: x_oracle_error := APP_EXCEPTION.Get_Code;
517: l_msg_data := APP_EXCEPTION.Get_Text;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_UNEXPECTED_ERROR');
520: FND_MESSAGE.SET_TOKEN('TEXT',
521: l_msg_data,
522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;

Line 526: x_msg_data := FND_MESSAGE.Get;

522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;
525: ELSE
526: x_msg_data := FND_MESSAGE.Get;
527: END IF;
528:
529: END Update_Row;
530:

Line 634: FND_MESSAGE.SET_NAME('GR',

630:
631: WHEN No_Data_Found_Error THEN
632: ROLLBACK TO SAVEPOINT Lock_Row;
633: x_return_status := 'E';
634: FND_MESSAGE.SET_NAME('GR',
635: 'GR_RECORD_NOT_FOUND');
636: FND_MESSAGE.SET_TOKEN('CODE',
637: p_label_class_code,
638: FALSE);

Line 636: FND_MESSAGE.SET_TOKEN('CODE',

632: ROLLBACK TO SAVEPOINT Lock_Row;
633: x_return_status := 'E';
634: FND_MESSAGE.SET_NAME('GR',
635: 'GR_RECORD_NOT_FOUND');
636: FND_MESSAGE.SET_TOKEN('CODE',
637: p_label_class_code,
638: FALSE);
639: IF FND_API.To_Boolean(p_called_by_form) THEN
640: APP_EXCEPTION.Raise_Exception;

Line 642: x_msg_data := FND_MESSAGE.Get;

638: FALSE);
639: IF FND_API.To_Boolean(p_called_by_form) THEN
640: APP_EXCEPTION.Raise_Exception;
641: ELSE
642: x_msg_data := FND_MESSAGE.Get;
643: END IF;
644:
645: WHEN Row_Already_Locked_Error THEN
646: ROLLBACK TO SAVEPOINT Lock_Row;

Line 649: FND_MESSAGE.SET_NAME('GR',

645: WHEN Row_Already_Locked_Error THEN
646: ROLLBACK TO SAVEPOINT Lock_Row;
647: x_return_status := 'E';
648: x_oracle_error := APP_EXCEPTION.Get_Code;
649: FND_MESSAGE.SET_NAME('GR',
650: 'GR_ROW_IS_LOCKED');
651: IF FND_API.To_Boolean(p_called_by_form) THEN
652: APP_EXCEPTION.Raise_Exception;
653: ELSE

Line 654: x_msg_data := FND_MESSAGE.Get;

650: 'GR_ROW_IS_LOCKED');
651: IF FND_API.To_Boolean(p_called_by_form) THEN
652: APP_EXCEPTION.Raise_Exception;
653: ELSE
654: x_msg_data := FND_MESSAGE.Get;
655: END IF;
656:
657: WHEN OTHERS THEN
658: ROLLBACK TO SAVEPOINT Lock_Row;

Line 662: FND_MESSAGE.SET_NAME('GR',

658: ROLLBACK TO SAVEPOINT Lock_Row;
659: x_return_status := 'U';
660: x_oracle_error := APP_EXCEPTION.Get_Code;
661: l_msg_data := APP_EXCEPTION.Get_Text;
662: FND_MESSAGE.SET_NAME('GR',
663: 'GR_UNEXPECTED_ERROR');
664: FND_MESSAGE.SET_TOKEN('TEXT',
665: l_msg_data,
666: FALSE);

Line 664: FND_MESSAGE.SET_TOKEN('TEXT',

660: x_oracle_error := APP_EXCEPTION.Get_Code;
661: l_msg_data := APP_EXCEPTION.Get_Text;
662: FND_MESSAGE.SET_NAME('GR',
663: 'GR_UNEXPECTED_ERROR');
664: FND_MESSAGE.SET_TOKEN('TEXT',
665: l_msg_data,
666: FALSE);
667: IF FND_API.To_Boolean(p_called_by_form) THEN
668: APP_EXCEPTION.Raise_Exception;

Line 670: x_msg_data := FND_MESSAGE.Get;

666: FALSE);
667: IF FND_API.To_Boolean(p_called_by_form) THEN
668: APP_EXCEPTION.Raise_Exception;
669: ELSE
670: x_msg_data := FND_MESSAGE.Get;
671: END IF;
672:
673: END Lock_Row;
674:

Line 817: x_msg_data := FND_MESSAGE.Get;

813: x_oracle_error := l_oracle_error;
814: IF FND_API.To_Boolean(p_called_by_form) THEN
815: APP_EXCEPTION.Raise_Exception;
816: ELSE
817: x_msg_data := FND_MESSAGE.Get;
818: END IF;
819:
820: WHEN Row_Missing_Error THEN
821: ROLLBACK TO SAVEPOINT Delete_Row;

Line 824: FND_MESSAGE.SET_NAME('GR',

820: WHEN Row_Missing_Error THEN
821: ROLLBACK TO SAVEPOINT Delete_Row;
822: x_return_status := 'E';
823: x_oracle_error := APP_EXCEPTION.Get_Code;
824: FND_MESSAGE.SET_NAME('GR',
825: 'GR_RECORD_NOT_FOUND');
826: FND_MESSAGE.SET_TOKEN('CODE',
827: p_label_class_code,
828: FALSE);

Line 826: FND_MESSAGE.SET_TOKEN('CODE',

822: x_return_status := 'E';
823: x_oracle_error := APP_EXCEPTION.Get_Code;
824: FND_MESSAGE.SET_NAME('GR',
825: 'GR_RECORD_NOT_FOUND');
826: FND_MESSAGE.SET_TOKEN('CODE',
827: p_label_class_code,
828: FALSE);
829: IF FND_API.To_Boolean(p_called_by_form) THEN
830: APP_EXCEPTION.Raise_Exception;

Line 832: x_msg_data := FND_MESSAGE.Get;

828: FALSE);
829: IF FND_API.To_Boolean(p_called_by_form) THEN
830: APP_EXCEPTION.Raise_Exception;
831: ELSE
832: x_msg_data := FND_MESSAGE.Get;
833: END IF;
834:
835: WHEN OTHERS THEN
836: ROLLBACK TO SAVEPOINT Delete_Row;

Line 840: FND_MESSAGE.SET_NAME('GR',

836: ROLLBACK TO SAVEPOINT Delete_Row;
837: x_return_status := 'U';
838: x_oracle_error := APP_EXCEPTION.Get_Code;
839: l_msg_data := APP_EXCEPTION.Get_Text;
840: FND_MESSAGE.SET_NAME('GR',
841: 'GR_UNEXPECTED_ERROR');
842: FND_MESSAGE.SET_TOKEN('TEXT',
843: l_msg_data,
844: FALSE);

Line 842: FND_MESSAGE.SET_TOKEN('TEXT',

838: x_oracle_error := APP_EXCEPTION.Get_Code;
839: l_msg_data := APP_EXCEPTION.Get_Text;
840: FND_MESSAGE.SET_NAME('GR',
841: 'GR_UNEXPECTED_ERROR');
842: FND_MESSAGE.SET_TOKEN('TEXT',
843: l_msg_data,
844: FALSE);
845: IF FND_API.To_Boolean(p_called_by_form) THEN
846: APP_EXCEPTION.Raise_Exception;

Line 848: x_msg_data := FND_MESSAGE.Get;

844: FALSE);
845: IF FND_API.To_Boolean(p_called_by_form) THEN
846: APP_EXCEPTION.Raise_Exception;
847: ELSE
848: x_msg_data := FND_MESSAGE.Get;
849: END IF;
850:
851: END Delete_Row;
852:

Line 929: FND_MESSAGE.SET_NAME('GR',

925: l_key_exists);
926:
927: IF NOT FND_API.To_Boolean(l_key_exists) THEN
928: x_return_status := 'E';
929: FND_MESSAGE.SET_NAME('GR',
930: 'GR_RECORD_NOT_FOUND');
931: FND_MESSAGE.SET_TOKEN('CODE',
932: p_rollup_property,
933: FALSE);

Line 931: FND_MESSAGE.SET_TOKEN('CODE',

927: IF NOT FND_API.To_Boolean(l_key_exists) THEN
928: x_return_status := 'E';
929: FND_MESSAGE.SET_NAME('GR',
930: 'GR_RECORD_NOT_FOUND');
931: FND_MESSAGE.SET_TOKEN('CODE',
932: p_rollup_property,
933: FALSE);
934: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
935: END IF;

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

930: 'GR_RECORD_NOT_FOUND');
931: FND_MESSAGE.SET_TOKEN('CODE',
932: p_rollup_property,
933: FALSE);
934: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
935: END IF;
936: END IF;
937: /* Rollup Label */
938:

Line 949: FND_MESSAGE.SET_NAME('GR',

945: l_key_exists);
946:
947: IF NOT FND_API.To_Boolean(l_key_exists) THEN
948: x_return_status := 'E';
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_RECORD_NOT_FOUND');
951: FND_MESSAGE.SET_TOKEN('CODE',
952: p_rollup_label,
953: FALSE);

Line 951: FND_MESSAGE.SET_TOKEN('CODE',

947: IF NOT FND_API.To_Boolean(l_key_exists) THEN
948: x_return_status := 'E';
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_RECORD_NOT_FOUND');
951: FND_MESSAGE.SET_TOKEN('CODE',
952: p_rollup_label,
953: FALSE);
954: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
955: END IF;

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

950: 'GR_RECORD_NOT_FOUND');
951: FND_MESSAGE.SET_TOKEN('CODE',
952: p_rollup_label,
953: FALSE);
954: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
955: END IF;
956: END IF;
957:
958: IF x_return_status <> 'S' THEN

Line 969: FND_MESSAGE.SET_NAME('GR',

965: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
966: x_return_status := 'U';
967: x_oracle_error := APP_EXCEPTION.Get_Code;
968: l_msg_data := APP_EXCEPTION.Get_Text;
969: FND_MESSAGE.SET_NAME('GR',
970: 'GR_UNEXPECTED_ERROR');
971: FND_MESSAGE.SET_TOKEN('TEXT',
972: l_msg_data,
973: FALSE);

Line 971: FND_MESSAGE.SET_TOKEN('TEXT',

967: x_oracle_error := APP_EXCEPTION.Get_Code;
968: l_msg_data := APP_EXCEPTION.Get_Text;
969: FND_MESSAGE.SET_NAME('GR',
970: 'GR_UNEXPECTED_ERROR');
971: FND_MESSAGE.SET_TOKEN('TEXT',
972: l_msg_data,
973: FALSE);
974: x_msg_data := FND_MESSAGE.Get;
975:

Line 974: x_msg_data := FND_MESSAGE.Get;

970: 'GR_UNEXPECTED_ERROR');
971: FND_MESSAGE.SET_TOKEN('TEXT',
972: l_msg_data,
973: FALSE);
974: x_msg_data := FND_MESSAGE.Get;
975:
976: END Check_Foreign_Keys;
977:
978: PROCEDURE Check_Integrity

Line 1053: FND_MESSAGE.SET_NAME('GR',

1049: x_return_status := 'S';
1050: x_oracle_error := 0;
1051: x_msg_data := NULL;
1052:
1053: FND_MESSAGE.SET_NAME('GR',
1054: 'GR_INTEGRITY_HEADER');
1055: FND_MESSAGE.SET_TOKEN('CODE',
1056: p_label_class_code,
1057: FALSE);

Line 1055: FND_MESSAGE.SET_TOKEN('CODE',

1051: x_msg_data := NULL;
1052:
1053: FND_MESSAGE.SET_NAME('GR',
1054: 'GR_INTEGRITY_HEADER');
1055: FND_MESSAGE.SET_TOKEN('CODE',
1056: p_label_class_code,
1057: FALSE);
1058: l_msg_data := FND_MESSAGE.Get;
1059: /*

Line 1058: l_msg_data := FND_MESSAGE.Get;

1054: 'GR_INTEGRITY_HEADER');
1055: FND_MESSAGE.SET_TOKEN('CODE',
1056: p_label_class_code,
1057: FALSE);
1058: l_msg_data := FND_MESSAGE.Get;
1059: /*
1060: ** Now read the cursors to make sure the label class code isn't used.
1061: **
1062: ** Label codes

Line 1088: FND_MESSAGE.SET_NAME('GR',

1084: ROLLBACK TO SAVEPOINT Check_Integrity;
1085: x_return_status := 'U';
1086: x_oracle_error := APP_EXCEPTION.Get_Code;
1087: l_msg_data := APP_EXCEPTION.Get_Text;
1088: FND_MESSAGE.SET_NAME('GR',
1089: 'GR_UNEXPECTED_ERROR');
1090: FND_MESSAGE.SET_TOKEN('TEXT',
1091: l_msg_data,
1092: FALSE);

Line 1090: FND_MESSAGE.SET_TOKEN('TEXT',

1086: x_oracle_error := APP_EXCEPTION.Get_Code;
1087: l_msg_data := APP_EXCEPTION.Get_Text;
1088: FND_MESSAGE.SET_NAME('GR',
1089: 'GR_UNEXPECTED_ERROR');
1090: FND_MESSAGE.SET_TOKEN('TEXT',
1091: l_msg_data,
1092: FALSE);
1093: IF FND_API.To_Boolean(p_called_by_form) THEN
1094: APP_EXCEPTION.Raise_Exception;

Line 1096: x_msg_data := FND_MESSAGE.Get;

1092: FALSE);
1093: IF FND_API.To_Boolean(p_called_by_form) THEN
1094: APP_EXCEPTION.Raise_Exception;
1095: ELSE
1096: x_msg_data := FND_MESSAGE.Get;
1097: END IF;
1098:
1099: END Check_Integrity;
1100:

Line 1144: FND_MESSAGE.SET_NAME('GR',

1140: EXCEPTION
1141:
1142: WHEN Others THEN
1143: l_msg_data := APP_EXCEPTION.Get_Text;
1144: FND_MESSAGE.SET_NAME('GR',
1145: 'GR_UNEXPECTED_ERROR');
1146: FND_MESSAGE.SET_TOKEN('TEXT',
1147: l_msg_data,
1148: FALSE);

Line 1146: FND_MESSAGE.SET_TOKEN('TEXT',

1142: WHEN Others THEN
1143: l_msg_data := APP_EXCEPTION.Get_Text;
1144: FND_MESSAGE.SET_NAME('GR',
1145: 'GR_UNEXPECTED_ERROR');
1146: FND_MESSAGE.SET_TOKEN('TEXT',
1147: l_msg_data,
1148: FALSE);
1149: IF FND_API.To_Boolean(p_called_by_form) THEN
1150: APP_EXCEPTION.Raise_Exception;