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

Line 253: FND_MESSAGE.SET_NAME('GR',

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

Line 255: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 261: x_msg_data := FND_MESSAGE.Get;

257: FALSE);
258: IF FND_API.To_Boolean(p_called_by_form) THEN
259: APP_EXCEPTION.Raise_Exception;
260: ELSE
261: x_msg_data := FND_MESSAGE.Get;
262: END IF;
263:
264: WHEN Label_Exists_Error THEN
265: ROLLBACK TO SAVEPOINT Insert_Row;

Line 268: FND_MESSAGE.SET_NAME('GR',

264: WHEN Label_Exists_Error THEN
265: ROLLBACK TO SAVEPOINT Insert_Row;
266: x_return_status := 'E';
267: x_oracle_error := APP_EXCEPTION.Get_Code;
268: FND_MESSAGE.SET_NAME('GR',
269: 'GR_RECORD_EXISTS');
270: FND_MESSAGE.SET_TOKEN('CODE',
271: p_phrase_code,
272: FALSE);

Line 270: FND_MESSAGE.SET_TOKEN('CODE',

266: x_return_status := 'E';
267: x_oracle_error := APP_EXCEPTION.Get_Code;
268: FND_MESSAGE.SET_NAME('GR',
269: 'GR_RECORD_EXISTS');
270: FND_MESSAGE.SET_TOKEN('CODE',
271: p_phrase_code,
272: FALSE);
273: IF FND_API.To_Boolean(p_called_by_form) THEN
274: APP_EXCEPTION.Raise_Exception;

Line 276: x_msg_data := FND_MESSAGE.Get;

272: FALSE);
273: IF FND_API.To_Boolean(p_called_by_form) THEN
274: APP_EXCEPTION.Raise_Exception;
275: ELSE
276: x_msg_data := FND_MESSAGE.Get;
277: END IF;
278:
279: WHEN Row_Missing_Error THEN
280: ROLLBACK TO SAVEPOINT Insert_Row;

Line 283: FND_MESSAGE.SET_NAME('GR',

279: WHEN Row_Missing_Error THEN
280: ROLLBACK TO SAVEPOINT Insert_Row;
281: x_return_status := 'E';
282: x_oracle_error := APP_EXCEPTION.Get_Code;
283: FND_MESSAGE.SET_NAME('GR',
284: 'GR_NO_RECORD_INSERTED');
285: FND_MESSAGE.SET_TOKEN('CODE',
286: p_phrase_code,
287: FALSE);

Line 285: FND_MESSAGE.SET_TOKEN('CODE',

281: x_return_status := 'E';
282: x_oracle_error := APP_EXCEPTION.Get_Code;
283: FND_MESSAGE.SET_NAME('GR',
284: 'GR_NO_RECORD_INSERTED');
285: FND_MESSAGE.SET_TOKEN('CODE',
286: p_phrase_code,
287: FALSE);
288: IF FND_API.To_Boolean(p_called_by_form) THEN
289: APP_EXCEPTION.Raise_Exception;

Line 291: x_msg_data := FND_MESSAGE.Get;

287: FALSE);
288: IF FND_API.To_Boolean(p_called_by_form) THEN
289: APP_EXCEPTION.Raise_Exception;
290: ELSE
291: x_msg_data := FND_MESSAGE.Get;
292: END IF;
293:
294: WHEN OTHERS THEN
295: ROLLBACK TO SAVEPOINT Insert_Row;

Line 299: FND_MESSAGE.SET_NAME('GR',

295: ROLLBACK TO SAVEPOINT Insert_Row;
296: x_return_status := 'U';
297: x_oracle_error := APP_EXCEPTION.Get_Code;
298: l_msg_data := APP_EXCEPTION.Get_Text;
299: FND_MESSAGE.SET_NAME('GR',
300: 'GR_UNEXPECTED_ERROR');
301: FND_MESSAGE.SET_TOKEN('TEXT',
302: l_msg_data,
303: FALSE);

Line 301: FND_MESSAGE.SET_TOKEN('TEXT',

297: x_oracle_error := APP_EXCEPTION.Get_Code;
298: l_msg_data := APP_EXCEPTION.Get_Text;
299: FND_MESSAGE.SET_NAME('GR',
300: 'GR_UNEXPECTED_ERROR');
301: FND_MESSAGE.SET_TOKEN('TEXT',
302: l_msg_data,
303: FALSE);
304: IF FND_API.To_Boolean(p_called_by_form) THEN
305: APP_EXCEPTION.Raise_Exception;

Line 307: x_msg_data := FND_MESSAGE.Get;

303: FALSE);
304: IF FND_API.To_Boolean(p_called_by_form) THEN
305: APP_EXCEPTION.Raise_Exception;
306: ELSE
307: x_msg_data := FND_MESSAGE.Get;
308: END IF;
309:
310: END Insert_Row;
311:

Line 491: FND_MESSAGE.SET_NAME('GR',

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

Line 493: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 499: x_msg_data := FND_MESSAGE.Get;

495: FALSE);
496: IF FND_API.To_Boolean(p_called_by_form) THEN
497: APP_EXCEPTION.Raise_Exception;
498: ELSE
499: x_msg_data := FND_MESSAGE.Get;
500: END IF;
501:
502: WHEN Row_Missing_Error THEN
503: ROLLBACK TO SAVEPOINT Update_Row;

Line 506: FND_MESSAGE.SET_NAME('GR',

502: WHEN Row_Missing_Error THEN
503: ROLLBACK TO SAVEPOINT Update_Row;
504: x_return_status := 'E';
505: x_oracle_error := APP_EXCEPTION.Get_Code;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_NO_RECORD_INSERTED');
508: FND_MESSAGE.SET_TOKEN('CODE',
509: p_phrase_code,
510: FALSE);

Line 508: FND_MESSAGE.SET_TOKEN('CODE',

504: x_return_status := 'E';
505: x_oracle_error := APP_EXCEPTION.Get_Code;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_NO_RECORD_INSERTED');
508: FND_MESSAGE.SET_TOKEN('CODE',
509: p_phrase_code,
510: FALSE);
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;

Line 514: x_msg_data := FND_MESSAGE.Get;

510: FALSE);
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;
513: ELSE
514: x_msg_data := FND_MESSAGE.Get;
515: END IF;
516:
517: WHEN OTHERS THEN
518: ROLLBACK TO SAVEPOINT Update_Row;

Line 522: FND_MESSAGE.SET_NAME('GR',

518: ROLLBACK TO SAVEPOINT Update_Row;
519: x_return_status := 'U';
520: x_oracle_error := APP_EXCEPTION.Get_Code;
521: l_msg_data := APP_EXCEPTION.Get_Text;
522: FND_MESSAGE.SET_NAME('GR',
523: 'GR_UNEXPECTED_ERROR');
524: FND_MESSAGE.SET_TOKEN('TEXT',
525: l_msg_data,
526: FALSE);

Line 524: FND_MESSAGE.SET_TOKEN('TEXT',

520: x_oracle_error := APP_EXCEPTION.Get_Code;
521: l_msg_data := APP_EXCEPTION.Get_Text;
522: FND_MESSAGE.SET_NAME('GR',
523: 'GR_UNEXPECTED_ERROR');
524: FND_MESSAGE.SET_TOKEN('TEXT',
525: l_msg_data,
526: FALSE);
527: IF FND_API.To_Boolean(p_called_by_form) THEN
528: APP_EXCEPTION.Raise_Exception;

Line 530: x_msg_data := FND_MESSAGE.Get;

526: FALSE);
527: IF FND_API.To_Boolean(p_called_by_form) THEN
528: APP_EXCEPTION.Raise_Exception;
529: ELSE
530: x_msg_data := FND_MESSAGE.Get;
531: END IF;
532:
533: END Update_Row;
534:

Line 641: FND_MESSAGE.SET_NAME('GR',

637:
638: WHEN No_Data_Found_Error THEN
639: ROLLBACK TO SAVEPOINT Lock_Row;
640: x_return_status := 'E';
641: FND_MESSAGE.SET_NAME('GR',
642: 'GR_RECORD_NOT_FOUND');
643: FND_MESSAGE.SET_TOKEN('CODE',
644: p_phrase_code,
645: FALSE);

Line 643: FND_MESSAGE.SET_TOKEN('CODE',

639: ROLLBACK TO SAVEPOINT Lock_Row;
640: x_return_status := 'E';
641: FND_MESSAGE.SET_NAME('GR',
642: 'GR_RECORD_NOT_FOUND');
643: FND_MESSAGE.SET_TOKEN('CODE',
644: p_phrase_code,
645: FALSE);
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;

Line 649: x_msg_data := FND_MESSAGE.Get;

645: FALSE);
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;
648: ELSE
649: x_msg_data := FND_MESSAGE.Get;
650: END IF;
651:
652: WHEN RECORD_CHANGED_ERROR THEN
653: ROLLBACK TO SAVEPOINT Lock_Row;

Line 655: FND_MESSAGE.SET_NAME('FND',

651:
652: WHEN RECORD_CHANGED_ERROR THEN
653: ROLLBACK TO SAVEPOINT Lock_Row;
654: X_return_status := 'E';
655: FND_MESSAGE.SET_NAME('FND',
656: 'FORM_RECORD_CHANGED');
657: IF FND_API.To_Boolean(p_called_by_form) THEN
658: APP_EXCEPTION.Raise_Exception;
659: ELSE

Line 660: x_msg_data := FND_MESSAGE.Get;

656: 'FORM_RECORD_CHANGED');
657: IF FND_API.To_Boolean(p_called_by_form) THEN
658: APP_EXCEPTION.Raise_Exception;
659: ELSE
660: x_msg_data := FND_MESSAGE.Get;
661: END IF;
662: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
663: ROLLBACK TO SAVEPOINT Lock_Row;
664: x_return_status := 'L';

Line 667: FND_MESSAGE.SET_NAME('GR',

663: ROLLBACK TO SAVEPOINT Lock_Row;
664: x_return_status := 'L';
665: x_oracle_error := APP_EXCEPTION.Get_Code;
666: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_ROW_IS_LOCKED');
669: x_msg_data := FND_MESSAGE.Get;
670: END IF;
671:

Line 669: x_msg_data := FND_MESSAGE.Get;

665: x_oracle_error := APP_EXCEPTION.Get_Code;
666: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_ROW_IS_LOCKED');
669: x_msg_data := FND_MESSAGE.Get;
670: END IF;
671:
672: WHEN OTHERS THEN
673: ROLLBACK TO SAVEPOINT Lock_Row;

Line 677: FND_MESSAGE.SET_NAME('GR',

673: ROLLBACK TO SAVEPOINT Lock_Row;
674: x_return_status := 'U';
675: x_oracle_error := APP_EXCEPTION.Get_Code;
676: l_msg_data := APP_EXCEPTION.Get_Text;
677: FND_MESSAGE.SET_NAME('GR',
678: 'GR_UNEXPECTED_ERROR');
679: FND_MESSAGE.SET_TOKEN('TEXT',
680: l_msg_data,
681: FALSE);

Line 679: FND_MESSAGE.SET_TOKEN('TEXT',

675: x_oracle_error := APP_EXCEPTION.Get_Code;
676: l_msg_data := APP_EXCEPTION.Get_Text;
677: FND_MESSAGE.SET_NAME('GR',
678: 'GR_UNEXPECTED_ERROR');
679: FND_MESSAGE.SET_TOKEN('TEXT',
680: l_msg_data,
681: FALSE);
682: IF FND_API.To_Boolean(p_called_by_form) THEN
683: APP_EXCEPTION.Raise_Exception;

Line 685: x_msg_data := FND_MESSAGE.Get;

681: FALSE);
682: IF FND_API.To_Boolean(p_called_by_form) THEN
683: APP_EXCEPTION.Raise_Exception;
684: ELSE
685: x_msg_data := FND_MESSAGE.Get;
686: END IF;
687:
688: END Lock_Row;
689:

Line 832: x_msg_data := FND_MESSAGE.Get;

828: x_oracle_error := l_oracle_error;
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 Row_Missing_Error THEN
836: ROLLBACK TO SAVEPOINT Delete_Row;

Line 839: FND_MESSAGE.SET_NAME('GR',

835: WHEN Row_Missing_Error THEN
836: ROLLBACK TO SAVEPOINT Delete_Row;
837: x_return_status := 'E';
838: x_oracle_error := APP_EXCEPTION.Get_Code;
839: FND_MESSAGE.SET_NAME('GR',
840: 'GR_RECORD_NOT_FOUND');
841: FND_MESSAGE.SET_TOKEN('CODE',
842: p_phrase_code,
843: FALSE);

Line 841: FND_MESSAGE.SET_TOKEN('CODE',

837: x_return_status := 'E';
838: x_oracle_error := APP_EXCEPTION.Get_Code;
839: FND_MESSAGE.SET_NAME('GR',
840: 'GR_RECORD_NOT_FOUND');
841: FND_MESSAGE.SET_TOKEN('CODE',
842: p_phrase_code,
843: FALSE);
844: IF FND_API.To_Boolean(p_called_by_form) THEN
845: APP_EXCEPTION.Raise_Exception;

Line 847: x_msg_data := FND_MESSAGE.Get;

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

Line 856: FND_MESSAGE.SET_NAME('GR',

852: x_return_status := 'U';
853: x_oracle_error := APP_EXCEPTION.Get_Code;
854: l_msg_data := APP_EXCEPTION.Get_Text;
855: l_msg_data := APP_EXCEPTION.Get_Text;
856: FND_MESSAGE.SET_NAME('GR',
857: 'GR_UNEXPECTED_ERROR');
858: FND_MESSAGE.SET_TOKEN('TEXT',
859: l_msg_data,
860: FALSE);

Line 858: FND_MESSAGE.SET_TOKEN('TEXT',

854: l_msg_data := APP_EXCEPTION.Get_Text;
855: l_msg_data := APP_EXCEPTION.Get_Text;
856: FND_MESSAGE.SET_NAME('GR',
857: 'GR_UNEXPECTED_ERROR');
858: FND_MESSAGE.SET_TOKEN('TEXT',
859: l_msg_data,
860: FALSE);
861: IF FND_API.To_Boolean(p_called_by_form) THEN
862: APP_EXCEPTION.Raise_Exception;

Line 864: x_msg_data := FND_MESSAGE.Get;

860: FALSE);
861: IF FND_API.To_Boolean(p_called_by_form) THEN
862: APP_EXCEPTION.Raise_Exception;
863: ELSE
864: x_msg_data := FND_MESSAGE.Get;
865: END IF;
866:
867: END Delete_Row;
868:

Line 914: FND_MESSAGE.SET_NAME('GR',

910: ROLLBACK TO SAVEPOINT Delete_Rows;
911: x_return_status := 'U';
912: x_oracle_error := APP_EXCEPTION.Get_Code;
913: l_msg_data := APP_EXCEPTION.Get_Text;
914: FND_MESSAGE.SET_NAME('GR',
915: 'GR_UNEXPECTED_ERROR');
916: FND_MESSAGE.SET_TOKEN('TEXT',
917: l_msg_token,
918: FALSE);

Line 916: FND_MESSAGE.SET_TOKEN('TEXT',

912: x_oracle_error := APP_EXCEPTION.Get_Code;
913: l_msg_data := APP_EXCEPTION.Get_Text;
914: FND_MESSAGE.SET_NAME('GR',
915: 'GR_UNEXPECTED_ERROR');
916: FND_MESSAGE.SET_TOKEN('TEXT',
917: l_msg_token,
918: FALSE);
919: IF FND_API.To_Boolean(p_called_by_form) THEN
920: APP_EXCEPTION.Raise_Exception;

Line 922: x_msg_data := FND_MESSAGE.Get;

918: FALSE);
919: IF FND_API.To_Boolean(p_called_by_form) THEN
920: APP_EXCEPTION.Raise_Exception;
921: ELSE
922: x_msg_data := FND_MESSAGE.Get;
923: END IF;
924:
925: END Delete_Rows;
926:

Line 1004: FND_MESSAGE.SET_NAME('GR',

1000: END IF;
1001:
1002: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1003: x_return_status := 'E';
1004: FND_MESSAGE.SET_NAME('GR',
1005: 'GR_RECORD_NOT_FOUND');
1006: FND_MESSAGE.SET_TOKEN('CODE',
1007: p_phrase_type_code,
1008: FALSE);

Line 1006: FND_MESSAGE.SET_TOKEN('CODE',

1002: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1003: x_return_status := 'E';
1004: FND_MESSAGE.SET_NAME('GR',
1005: 'GR_RECORD_NOT_FOUND');
1006: FND_MESSAGE.SET_TOKEN('CODE',
1007: p_phrase_type_code,
1008: FALSE);
1009: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1010: END IF;

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

1005: 'GR_RECORD_NOT_FOUND');
1006: FND_MESSAGE.SET_TOKEN('CODE',
1007: p_phrase_type_code,
1008: FALSE);
1009: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1010: END IF;
1011:
1012: IF x_return_status <> 'S' THEN
1013: x_msg_data := l_msg_data;

Line 1023: FND_MESSAGE.SET_NAME('GR',

1019: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1020: x_return_status := 'U';
1021: x_oracle_error := APP_EXCEPTION.Get_Code;
1022: l_msg_data := APP_EXCEPTION.Get_Text;
1023: FND_MESSAGE.SET_NAME('GR',
1024: 'GR_UNEXPECTED_ERROR');
1025: FND_MESSAGE.SET_TOKEN('TEXT',
1026: l_msg_data,
1027: FALSE);

Line 1025: FND_MESSAGE.SET_TOKEN('TEXT',

1021: x_oracle_error := APP_EXCEPTION.Get_Code;
1022: l_msg_data := APP_EXCEPTION.Get_Text;
1023: FND_MESSAGE.SET_NAME('GR',
1024: 'GR_UNEXPECTED_ERROR');
1025: FND_MESSAGE.SET_TOKEN('TEXT',
1026: l_msg_data,
1027: FALSE);
1028: x_msg_data := FND_MESSAGE.Get;
1029:

Line 1028: x_msg_data := FND_MESSAGE.Get;

1024: 'GR_UNEXPECTED_ERROR');
1025: FND_MESSAGE.SET_TOKEN('TEXT',
1026: l_msg_data,
1027: FALSE);
1028: x_msg_data := FND_MESSAGE.Get;
1029:
1030: END Check_Foreign_Keys;
1031:
1032: PROCEDURE Check_Integrity

Line 1113: FND_MESSAGE.SET_NAME('GR',

1109: ROLLBACK TO SAVEPOINT Check_Integrity;
1110: x_return_status := 'U';
1111: x_oracle_error := APP_EXCEPTION.Get_Code;
1112: l_msg_data := APP_EXCEPTION.Get_Text;
1113: FND_MESSAGE.SET_NAME('GR',
1114: 'GR_UNEXPECTED_ERROR');
1115: FND_MESSAGE.SET_TOKEN('TEXT',
1116: l_msg_data,
1117: FALSE);

Line 1115: FND_MESSAGE.SET_TOKEN('TEXT',

1111: x_oracle_error := APP_EXCEPTION.Get_Code;
1112: l_msg_data := APP_EXCEPTION.Get_Text;
1113: FND_MESSAGE.SET_NAME('GR',
1114: 'GR_UNEXPECTED_ERROR');
1115: FND_MESSAGE.SET_TOKEN('TEXT',
1116: l_msg_data,
1117: FALSE);
1118: IF FND_API.To_Boolean(p_called_by_form) THEN
1119: APP_EXCEPTION.Raise_Exception;

Line 1121: x_msg_data := FND_MESSAGE.Get;

1117: FALSE);
1118: IF FND_API.To_Boolean(p_called_by_form) THEN
1119: APP_EXCEPTION.Raise_Exception;
1120: ELSE
1121: x_msg_data := FND_MESSAGE.Get;
1122: END IF;
1123:
1124: END Check_Integrity;
1125:

Line 1175: FND_MESSAGE.SET_NAME('GR',

1171: EXCEPTION
1172:
1173: WHEN Others THEN
1174: l_msg_data := APP_EXCEPTION.Get_Text;
1175: FND_MESSAGE.SET_NAME('GR',
1176: 'GR_UNEXPECTED_ERROR');
1177: FND_MESSAGE.SET_TOKEN('TEXT',
1178: l_msg_data,
1179: FALSE);

Line 1177: FND_MESSAGE.SET_TOKEN('TEXT',

1173: WHEN Others THEN
1174: l_msg_data := APP_EXCEPTION.Get_Text;
1175: FND_MESSAGE.SET_NAME('GR',
1176: 'GR_UNEXPECTED_ERROR');
1177: FND_MESSAGE.SET_TOKEN('TEXT',
1178: l_msg_data,
1179: FALSE);
1180: IF FND_API.To_Boolean(p_called_by_form) THEN
1181: APP_EXCEPTION.Raise_Exception;