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

Line 245: FND_MESSAGE.SET_NAME('GR',

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

Line 247: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 253: x_msg_data := FND_MESSAGE.Get;

249: FALSE);
250: IF FND_API.To_Boolean(p_called_by_form) THEN
251: APP_EXCEPTION.Raise_Exception;
252: ELSE
253: x_msg_data := FND_MESSAGE.Get;
254: END IF;
255:
256: WHEN Item_Exists_Error THEN
257: ROLLBACK TO SAVEPOINT Insert_Row;

Line 260: FND_MESSAGE.SET_NAME('GR',

256: WHEN Item_Exists_Error THEN
257: ROLLBACK TO SAVEPOINT Insert_Row;
258: x_return_status := 'E';
259: x_oracle_error := APP_EXCEPTION.Get_Code;
260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_RECORD_EXISTS');
262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_safety_phrase_code,
264: FALSE);

Line 262: FND_MESSAGE.SET_TOKEN('CODE',

258: x_return_status := 'E';
259: x_oracle_error := APP_EXCEPTION.Get_Code;
260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_RECORD_EXISTS');
262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_safety_phrase_code,
264: FALSE);
265: IF FND_API.To_Boolean(p_called_by_form) THEN
266: APP_EXCEPTION.Raise_Exception;

Line 268: x_msg_data := FND_MESSAGE.Get;

264: FALSE);
265: IF FND_API.To_Boolean(p_called_by_form) THEN
266: APP_EXCEPTION.Raise_Exception;
267: ELSE
268: x_msg_data := FND_MESSAGE.Get;
269: END IF;
270:
271: WHEN Row_Missing_Error THEN
272: ROLLBACK TO SAVEPOINT Insert_Row;

Line 275: FND_MESSAGE.SET_NAME('GR',

271: WHEN Row_Missing_Error THEN
272: ROLLBACK TO SAVEPOINT Insert_Row;
273: x_return_status := 'E';
274: x_oracle_error := APP_EXCEPTION.Get_Code;
275: FND_MESSAGE.SET_NAME('GR',
276: 'GR_NO_RECORD_INSERTED');
277: FND_MESSAGE.SET_TOKEN('CODE',
278: p_safety_phrase_code,
279: FALSE);

Line 277: FND_MESSAGE.SET_TOKEN('CODE',

273: x_return_status := 'E';
274: x_oracle_error := APP_EXCEPTION.Get_Code;
275: FND_MESSAGE.SET_NAME('GR',
276: 'GR_NO_RECORD_INSERTED');
277: FND_MESSAGE.SET_TOKEN('CODE',
278: p_safety_phrase_code,
279: FALSE);
280: IF FND_API.To_Boolean(p_called_by_form) THEN
281: APP_EXCEPTION.Raise_Exception;

Line 283: x_msg_data := FND_MESSAGE.Get;

279: FALSE);
280: IF FND_API.To_Boolean(p_called_by_form) THEN
281: APP_EXCEPTION.Raise_Exception;
282: ELSE
283: x_msg_data := FND_MESSAGE.Get;
284: END IF;
285:
286: WHEN OTHERS THEN
287: ROLLBACK TO SAVEPOINT Insert_Row;

Line 291: FND_MESSAGE.SET_NAME('GR',

287: ROLLBACK TO SAVEPOINT Insert_Row;
288: x_return_status := 'U';
289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: l_msg_data := APP_EXCEPTION.Get_Text;
291: FND_MESSAGE.SET_NAME('GR',
292: 'GR_UNEXPECTED_ERROR');
293: FND_MESSAGE.SET_TOKEN('TEXT',
294: l_msg_data,
295: FALSE);

Line 293: FND_MESSAGE.SET_TOKEN('TEXT',

289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: l_msg_data := APP_EXCEPTION.Get_Text;
291: FND_MESSAGE.SET_NAME('GR',
292: 'GR_UNEXPECTED_ERROR');
293: FND_MESSAGE.SET_TOKEN('TEXT',
294: l_msg_data,
295: FALSE);
296: IF FND_API.To_Boolean(p_called_by_form) THEN
297: APP_EXCEPTION.Raise_Exception;

Line 299: x_msg_data := FND_MESSAGE.Get;

295: FALSE);
296: IF FND_API.To_Boolean(p_called_by_form) THEN
297: APP_EXCEPTION.Raise_Exception;
298: ELSE
299: x_msg_data := FND_MESSAGE.Get;
300: END IF;
301:
302: END Insert_Row;
303:

Line 480: FND_MESSAGE.SET_NAME('GR',

476: WHEN Foreign_Key_Error THEN
477: ROLLBACK TO SAVEPOINT Update_Row;
478: x_return_status := l_return_status;
479: x_oracle_error := l_oracle_error;
480: FND_MESSAGE.SET_NAME('GR',
481: 'GR_FOREIGN_KEY_ERROR');
482: FND_MESSAGE.SET_TOKEN('TEXT',
483: l_msg_data,
484: FALSE);

Line 482: FND_MESSAGE.SET_TOKEN('TEXT',

478: x_return_status := l_return_status;
479: x_oracle_error := l_oracle_error;
480: FND_MESSAGE.SET_NAME('GR',
481: 'GR_FOREIGN_KEY_ERROR');
482: FND_MESSAGE.SET_TOKEN('TEXT',
483: l_msg_data,
484: FALSE);
485: IF FND_API.To_Boolean(p_called_by_form) THEN
486: APP_EXCEPTION.Raise_Exception;

Line 488: x_msg_data := FND_MESSAGE.Get;

484: FALSE);
485: IF FND_API.To_Boolean(p_called_by_form) THEN
486: APP_EXCEPTION.Raise_Exception;
487: ELSE
488: x_msg_data := FND_MESSAGE.Get;
489: END IF;
490:
491: WHEN Row_Missing_Error THEN
492: ROLLBACK TO SAVEPOINT Update_Row;

Line 495: FND_MESSAGE.SET_NAME('GR',

491: WHEN Row_Missing_Error THEN
492: ROLLBACK TO SAVEPOINT Update_Row;
493: x_return_status := 'E';
494: x_oracle_error := APP_EXCEPTION.Get_Code;
495: FND_MESSAGE.SET_NAME('GR',
496: 'GR_NO_RECORD_INSERTED');
497: FND_MESSAGE.SET_TOKEN('CODE',
498: p_safety_phrase_code,
499: FALSE);

Line 497: FND_MESSAGE.SET_TOKEN('CODE',

493: x_return_status := 'E';
494: x_oracle_error := APP_EXCEPTION.Get_Code;
495: FND_MESSAGE.SET_NAME('GR',
496: 'GR_NO_RECORD_INSERTED');
497: FND_MESSAGE.SET_TOKEN('CODE',
498: p_safety_phrase_code,
499: FALSE);
500: IF FND_API.To_Boolean(p_called_by_form) THEN
501: APP_EXCEPTION.Raise_Exception;

Line 503: x_msg_data := FND_MESSAGE.Get;

499: FALSE);
500: IF FND_API.To_Boolean(p_called_by_form) THEN
501: APP_EXCEPTION.Raise_Exception;
502: ELSE
503: x_msg_data := FND_MESSAGE.Get;
504: END IF;
505:
506: WHEN OTHERS THEN
507: ROLLBACK TO SAVEPOINT Update_Row;

Line 511: FND_MESSAGE.SET_NAME('GR',

507: ROLLBACK TO SAVEPOINT Update_Row;
508: x_return_status := 'U';
509: x_oracle_error := APP_EXCEPTION.Get_Code;
510: l_msg_data := APP_EXCEPTION.Get_Text;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_UNEXPECTED_ERROR');
513: FND_MESSAGE.SET_TOKEN('TEXT',
514: l_msg_data,
515: FALSE);

Line 513: FND_MESSAGE.SET_TOKEN('TEXT',

509: x_oracle_error := APP_EXCEPTION.Get_Code;
510: l_msg_data := APP_EXCEPTION.Get_Text;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_UNEXPECTED_ERROR');
513: FND_MESSAGE.SET_TOKEN('TEXT',
514: l_msg_data,
515: FALSE);
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;

Line 519: x_msg_data := FND_MESSAGE.Get;

515: FALSE);
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;
518: ELSE
519: x_msg_data := FND_MESSAGE.Get;
520: END IF;
521:
522: END Update_Row;
523:

Line 628: FND_MESSAGE.SET_NAME('GR',

624:
625: WHEN No_Data_Found_Error THEN
626: ROLLBACK TO SAVEPOINT Lock_Row;
627: x_return_status := 'E';
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_safety_phrase_code,
632: FALSE);

Line 630: FND_MESSAGE.SET_TOKEN('CODE',

626: ROLLBACK TO SAVEPOINT Lock_Row;
627: x_return_status := 'E';
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_safety_phrase_code,
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 RECORD_CHANGED_ERROR THEN
640: ROLLBACK TO SAVEPOINT Lock_Row;

Line 642: FND_MESSAGE.SET_NAME('FND',

638:
639: WHEN RECORD_CHANGED_ERROR THEN
640: ROLLBACK TO SAVEPOINT Lock_Row;
641: X_return_status := 'E';
642: FND_MESSAGE.SET_NAME('FND',
643: 'FORM_RECORD_CHANGED');
644: IF FND_API.To_Boolean(p_called_by_form) THEN
645: APP_EXCEPTION.Raise_Exception;
646: ELSE

Line 647: x_msg_data := FND_MESSAGE.Get;

643: 'FORM_RECORD_CHANGED');
644: IF FND_API.To_Boolean(p_called_by_form) THEN
645: APP_EXCEPTION.Raise_Exception;
646: ELSE
647: x_msg_data := FND_MESSAGE.Get;
648: END IF;
649: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
650: ROLLBACK TO SAVEPOINT Lock_Row;
651: x_return_status := 'L';

Line 654: FND_MESSAGE.SET_NAME('GR',

650: ROLLBACK TO SAVEPOINT Lock_Row;
651: x_return_status := 'L';
652: x_oracle_error := APP_EXCEPTION.Get_Code;
653: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
654: FND_MESSAGE.SET_NAME('GR',
655: 'GR_ROW_IS_LOCKED');
656: x_msg_data := FND_MESSAGE.Get;
657: END IF;
658:

Line 656: x_msg_data := FND_MESSAGE.Get;

652: x_oracle_error := APP_EXCEPTION.Get_Code;
653: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
654: FND_MESSAGE.SET_NAME('GR',
655: 'GR_ROW_IS_LOCKED');
656: x_msg_data := FND_MESSAGE.Get;
657: END IF;
658:
659: WHEN OTHERS THEN
660: ROLLBACK TO SAVEPOINT Lock_Row;

Line 664: FND_MESSAGE.SET_NAME('GR',

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

Line 666: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 672: x_msg_data := FND_MESSAGE.Get;

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

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_safety_phrase_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_safety_phrase_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 841: FND_MESSAGE.SET_NAME('GR',

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

Line 843: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 849: x_msg_data := FND_MESSAGE.Get;

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

Line 936: FND_MESSAGE.SET_NAME('GR',

932: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
933: x_return_status := 'U';
934: x_oracle_error := APP_EXCEPTION.Get_Code;
935: l_msg_data := APP_EXCEPTION.Get_Text;
936: FND_MESSAGE.SET_NAME('GR',
937: 'GR_UNEXPECTED_ERROR');
938: FND_MESSAGE.SET_TOKEN('TEXT',
939: l_msg_data,
940: FALSE);

Line 938: FND_MESSAGE.SET_TOKEN('TEXT',

934: x_oracle_error := APP_EXCEPTION.Get_Code;
935: l_msg_data := APP_EXCEPTION.Get_Text;
936: FND_MESSAGE.SET_NAME('GR',
937: 'GR_UNEXPECTED_ERROR');
938: FND_MESSAGE.SET_TOKEN('TEXT',
939: l_msg_data,
940: FALSE);
941: x_msg_data := FND_MESSAGE.Get;
942:

Line 941: x_msg_data := FND_MESSAGE.Get;

937: 'GR_UNEXPECTED_ERROR');
938: FND_MESSAGE.SET_TOKEN('TEXT',
939: l_msg_data,
940: FALSE);
941: x_msg_data := FND_MESSAGE.Get;
942:
943: END Check_Foreign_Keys;
944:
945: PROCEDURE Check_Integrity

Line 1043: FND_MESSAGE.SET_NAME('GR',

1039:
1040: EXCEPTION
1041: WHEN INTEGRITY_ERROR THEN
1042: x_return_status := 'E';
1043: FND_MESSAGE.SET_NAME('GR',
1044: 'GR_INTEGRITY_HEADER');
1045: FND_MESSAGE.SET_TOKEN('CODE',
1046: p_safety_phrase_code,
1047: FALSE);

Line 1045: FND_MESSAGE.SET_TOKEN('CODE',

1041: WHEN INTEGRITY_ERROR THEN
1042: x_return_status := 'E';
1043: FND_MESSAGE.SET_NAME('GR',
1044: 'GR_INTEGRITY_HEADER');
1045: FND_MESSAGE.SET_TOKEN('CODE',
1046: p_safety_phrase_code,
1047: FALSE);
1048: FND_MESSAGE.SET_TOKEN('TABLES',
1049: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 1048: FND_MESSAGE.SET_TOKEN('TABLES',

1044: 'GR_INTEGRITY_HEADER');
1045: FND_MESSAGE.SET_TOKEN('CODE',
1046: p_safety_phrase_code,
1047: FALSE);
1048: FND_MESSAGE.SET_TOKEN('TABLES',
1049: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1050: FALSE);
1051: IF FND_API.To_Boolean(p_called_by_form) THEN
1052: APP_EXCEPTION.Raise_Exception;

Line 1054: x_msg_data := FND_MESSAGE.Get;

1050: FALSE);
1051: IF FND_API.To_Boolean(p_called_by_form) THEN
1052: APP_EXCEPTION.Raise_Exception;
1053: ELSE
1054: x_msg_data := FND_MESSAGE.Get;
1055: END IF;
1056: WHEN OTHERS THEN
1057: ROLLBACK TO SAVEPOINT Check_Integrity;
1058: x_return_status := 'U';

Line 1061: FND_MESSAGE.SET_NAME('GR',

1057: ROLLBACK TO SAVEPOINT Check_Integrity;
1058: x_return_status := 'U';
1059: x_oracle_error := APP_EXCEPTION.Get_Code;
1060: l_msg_data := APP_EXCEPTION.Get_Text;
1061: FND_MESSAGE.SET_NAME('GR',
1062: 'GR_UNEXPECTED_ERROR');
1063: FND_MESSAGE.SET_TOKEN('TEXT',
1064: l_msg_data,
1065: FALSE);

Line 1063: FND_MESSAGE.SET_TOKEN('TEXT',

1059: x_oracle_error := APP_EXCEPTION.Get_Code;
1060: l_msg_data := APP_EXCEPTION.Get_Text;
1061: FND_MESSAGE.SET_NAME('GR',
1062: 'GR_UNEXPECTED_ERROR');
1063: FND_MESSAGE.SET_TOKEN('TEXT',
1064: l_msg_data,
1065: FALSE);
1066: IF FND_API.To_Boolean(p_called_by_form) THEN
1067: APP_EXCEPTION.Raise_Exception;

Line 1069: x_msg_data := FND_MESSAGE.Get;

1065: FALSE);
1066: IF FND_API.To_Boolean(p_called_by_form) THEN
1067: APP_EXCEPTION.Raise_Exception;
1068: ELSE
1069: x_msg_data := FND_MESSAGE.Get;
1070: END IF;
1071:
1072: END Check_Integrity;
1073:

Line 1116: FND_MESSAGE.SET_NAME('GR',

1112: EXCEPTION
1113:
1114: WHEN Others THEN
1115: l_msg_data := APP_EXCEPTION.Get_Text;
1116: FND_MESSAGE.SET_NAME('GR',
1117: 'GR_UNEXPECTED_ERROR');
1118: FND_MESSAGE.SET_TOKEN('TEXT',
1119: l_msg_data,
1120: FALSE);

Line 1118: FND_MESSAGE.SET_TOKEN('TEXT',

1114: WHEN Others THEN
1115: l_msg_data := APP_EXCEPTION.Get_Text;
1116: FND_MESSAGE.SET_NAME('GR',
1117: 'GR_UNEXPECTED_ERROR');
1118: FND_MESSAGE.SET_TOKEN('TEXT',
1119: l_msg_data,
1120: FALSE);
1121: IF FND_API.To_Boolean(p_called_by_form) THEN
1122: APP_EXCEPTION.Raise_Exception;