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 APP_EXCEPTION

Line 251: APP_EXCEPTION.Raise_Exception;

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;
252: ELSE
253: x_msg_data := FND_MESSAGE.Get;
254: END IF;
255:

Line 259: x_oracle_error := APP_EXCEPTION.Get_Code;

255:
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,

Line 266: APP_EXCEPTION.Raise_Exception;

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;
267: ELSE
268: x_msg_data := FND_MESSAGE.Get;
269: END IF;
270:

Line 274: x_oracle_error := APP_EXCEPTION.Get_Code;

270:
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,

Line 281: APP_EXCEPTION.Raise_Exception;

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;
282: ELSE
283: x_msg_data := FND_MESSAGE.Get;
284: END IF;
285:

Line 289: x_oracle_error := APP_EXCEPTION.Get_Code;

285:
286: WHEN OTHERS THEN
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',

Line 290: l_msg_data := APP_EXCEPTION.Get_Text;

286: WHEN OTHERS THEN
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,

Line 297: APP_EXCEPTION.Raise_Exception;

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;
298: ELSE
299: x_msg_data := FND_MESSAGE.Get;
300: END IF;
301:

Line 486: APP_EXCEPTION.Raise_Exception;

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;
487: ELSE
488: x_msg_data := FND_MESSAGE.Get;
489: END IF;
490:

Line 494: x_oracle_error := APP_EXCEPTION.Get_Code;

490:
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,

Line 501: APP_EXCEPTION.Raise_Exception;

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;
502: ELSE
503: x_msg_data := FND_MESSAGE.Get;
504: END IF;
505:

Line 509: x_oracle_error := APP_EXCEPTION.Get_Code;

505:
506: WHEN OTHERS THEN
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',

Line 510: l_msg_data := APP_EXCEPTION.Get_Text;

506: WHEN OTHERS THEN
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,

Line 517: APP_EXCEPTION.Raise_Exception;

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;
518: ELSE
519: x_msg_data := FND_MESSAGE.Get;
520: END IF;
521:

Line 634: APP_EXCEPTION.Raise_Exception;

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;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;
638:

Line 645: APP_EXCEPTION.Raise_Exception;

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
647: x_msg_data := FND_MESSAGE.Get;
648: END IF;
649: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 649: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION 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';
652: x_oracle_error := APP_EXCEPTION.Get_Code;
653: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 652: x_oracle_error := APP_EXCEPTION.Get_Code;

648: END IF;
649: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
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;

Line 662: x_oracle_error := APP_EXCEPTION.Get_Code;

658:
659: WHEN OTHERS THEN
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',

Line 663: l_msg_data := APP_EXCEPTION.Get_Text;

659: WHEN OTHERS THEN
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,

Line 670: APP_EXCEPTION.Raise_Exception;

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;
671: ELSE
672: x_msg_data := FND_MESSAGE.Get;
673: END IF;
674:

Line 815: APP_EXCEPTION.Raise_Exception;

811: ROLLBACK TO SAVEPOINT Delete_Row;
812: x_return_status := l_return_status;
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:

Line 823: x_oracle_error := APP_EXCEPTION.Get_Code;

819:
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,

Line 830: APP_EXCEPTION.Raise_Exception;

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;
831: ELSE
832: x_msg_data := FND_MESSAGE.Get;
833: END IF;
834:

Line 838: x_oracle_error := APP_EXCEPTION.Get_Code;

834:
835: WHEN OTHERS THEN
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: l_msg_data := APP_EXCEPTION.Get_Text;
841: FND_MESSAGE.SET_NAME('GR',
842: 'GR_UNEXPECTED_ERROR');

Line 839: l_msg_data := APP_EXCEPTION.Get_Text;

835: WHEN OTHERS THEN
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: l_msg_data := APP_EXCEPTION.Get_Text;
841: FND_MESSAGE.SET_NAME('GR',
842: 'GR_UNEXPECTED_ERROR');
843: FND_MESSAGE.SET_TOKEN('TEXT',

Line 840: l_msg_data := APP_EXCEPTION.Get_Text;

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: 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,

Line 847: APP_EXCEPTION.Raise_Exception;

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;
848: ELSE
849: x_msg_data := FND_MESSAGE.Get;
850: END IF;
851:

Line 934: x_oracle_error := APP_EXCEPTION.Get_Code;

930:
931: WHEN OTHERS THEN
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',

Line 935: l_msg_data := APP_EXCEPTION.Get_Text;

931: WHEN OTHERS THEN
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,

Line 1052: APP_EXCEPTION.Raise_Exception;

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;
1053: ELSE
1054: x_msg_data := FND_MESSAGE.Get;
1055: END IF;
1056: WHEN OTHERS THEN

Line 1059: x_oracle_error := APP_EXCEPTION.Get_Code;

1055: END IF;
1056: WHEN OTHERS THEN
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',

Line 1060: l_msg_data := APP_EXCEPTION.Get_Text;

1056: WHEN OTHERS THEN
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,

Line 1067: APP_EXCEPTION.Raise_Exception;

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;
1068: ELSE
1069: x_msg_data := FND_MESSAGE.Get;
1070: END IF;
1071:

Line 1115: l_msg_data := APP_EXCEPTION.Get_Text;

1111:
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,

Line 1122: APP_EXCEPTION.Raise_Exception;

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;
1123: END IF;
1124:
1125: END Check_Primary_Key;
1126: