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_RISK_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_THERE');
262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_risk_phrase_code,

Line 266: APP_EXCEPTION.Raise_Exception;

262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_risk_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_risk_phrase_code,

Line 281: APP_EXCEPTION.Raise_Exception;

277: FND_MESSAGE.SET_TOKEN('CODE',
278: p_risk_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 485: APP_EXCEPTION.Raise_Exception;

481: FND_MESSAGE.SET_TOKEN('TEXT',
482: l_msg_data,
483: FALSE);
484: IF FND_API.To_Boolean(p_called_by_form) THEN
485: APP_EXCEPTION.Raise_Exception;
486: ELSE
487: x_msg_data := FND_MESSAGE.Get;
488: END IF;
489:

Line 493: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 500: APP_EXCEPTION.Raise_Exception;

496: FND_MESSAGE.SET_TOKEN('CODE',
497: p_risk_phrase_code,
498: FALSE);
499: IF FND_API.To_Boolean(p_called_by_form) THEN
500: APP_EXCEPTION.Raise_Exception;
501: ELSE
502: x_msg_data := FND_MESSAGE.Get;
503: END IF;
504:

Line 508: x_oracle_error := APP_EXCEPTION.Get_Code;

504:
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT Update_Row;
507: x_return_status := 'U';
508: x_oracle_error := APP_EXCEPTION.Get_Code;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: FND_MESSAGE.SET_NAME('GR',
511: 'GR_UNEXPECTED_ERROR');
512: FND_MESSAGE.SET_TOKEN('TEXT',

Line 509: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 516: APP_EXCEPTION.Raise_Exception;

512: FND_MESSAGE.SET_TOKEN('TEXT',
513: l_msg_data,
514: FALSE);
515: IF FND_API.To_Boolean(p_called_by_form) THEN
516: APP_EXCEPTION.Raise_Exception;
517: ELSE
518: x_msg_data := FND_MESSAGE.Get;
519: END IF;
520:

Line 633: APP_EXCEPTION.Raise_Exception;

629: FND_MESSAGE.SET_TOKEN('CODE',
630: p_risk_phrase_code,
631: FALSE);
632: IF FND_API.To_Boolean(p_called_by_form) THEN
633: APP_EXCEPTION.Raise_Exception;
634: ELSE
635: x_msg_data := FND_MESSAGE.Get;
636: END IF;
637:

Line 644: APP_EXCEPTION.Raise_Exception;

640: X_return_status := 'E';
641: FND_MESSAGE.SET_NAME('FND',
642: 'FORM_RECORD_CHANGED');
643: IF FND_API.To_Boolean(p_called_by_form) THEN
644: APP_EXCEPTION.Raise_Exception;
645: ELSE
646: x_msg_data := FND_MESSAGE.Get;
647: END IF;
648: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 648: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

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

Line 651: x_oracle_error := APP_EXCEPTION.Get_Code;

647: END IF;
648: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
649: ROLLBACK TO SAVEPOINT Lock_Row;
650: x_return_status := 'L';
651: x_oracle_error := APP_EXCEPTION.Get_Code;
652: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
653: FND_MESSAGE.SET_NAME('GR',
654: 'GR_ROW_IS_LOCKED');
655: 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: x_return_status := l_return_status;
812: x_oracle_error := l_oracle_error;
813: x_msg_data := l_msg_data;
814: IF FND_API.To_Boolean(p_called_by_form) THEN
815: APP_EXCEPTION.Raise_Exception;
816: END IF;
817:
818: WHEN Row_Missing_Error THEN
819: ROLLBACK TO SAVEPOINT Delete_Row;

Line 821: x_oracle_error := APP_EXCEPTION.Get_Code;

817:
818: WHEN Row_Missing_Error THEN
819: ROLLBACK TO SAVEPOINT Delete_Row;
820: x_return_status := 'E';
821: x_oracle_error := APP_EXCEPTION.Get_Code;
822: FND_MESSAGE.SET_NAME('GR',
823: 'GR_RECORD_NOT_FOUND');
824: FND_MESSAGE.SET_TOKEN('CODE',
825: p_risk_phrase_code,

Line 828: APP_EXCEPTION.Raise_Exception;

824: FND_MESSAGE.SET_TOKEN('CODE',
825: p_risk_phrase_code,
826: FALSE);
827: IF FND_API.To_Boolean(p_called_by_form) THEN
828: APP_EXCEPTION.Raise_Exception;
829: ELSE
830: x_msg_data := FND_MESSAGE.Get;
831: END IF;
832:

Line 836: x_oracle_error := APP_EXCEPTION.Get_Code;

832:
833: WHEN OTHERS THEN
834: ROLLBACK TO SAVEPOINT Delete_Row;
835: x_return_status := 'U';
836: x_oracle_error := APP_EXCEPTION.Get_Code;
837: l_msg_data := APP_EXCEPTION.Get_Text;
838: l_msg_data := APP_EXCEPTION.Get_Text;
839: FND_MESSAGE.SET_NAME('GR',
840: 'GR_UNEXPECTED_ERROR');

Line 837: l_msg_data := APP_EXCEPTION.Get_Text;

833: WHEN OTHERS THEN
834: ROLLBACK TO SAVEPOINT Delete_Row;
835: x_return_status := 'U';
836: x_oracle_error := APP_EXCEPTION.Get_Code;
837: l_msg_data := APP_EXCEPTION.Get_Text;
838: l_msg_data := APP_EXCEPTION.Get_Text;
839: FND_MESSAGE.SET_NAME('GR',
840: 'GR_UNEXPECTED_ERROR');
841: FND_MESSAGE.SET_TOKEN('TEXT',

Line 838: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 845: APP_EXCEPTION.Raise_Exception;

841: FND_MESSAGE.SET_TOKEN('TEXT',
842: l_msg_data,
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:

Line 932: x_oracle_error := APP_EXCEPTION.Get_Code;

928:
929: WHEN OTHERS THEN
930: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
931: x_return_status := 'U';
932: x_oracle_error := APP_EXCEPTION.Get_Code;
933: l_msg_data := APP_EXCEPTION.Get_Text;
934: FND_MESSAGE.SET_NAME('GR',
935: 'GR_UNEXPECTED_ERROR');
936: FND_MESSAGE.SET_TOKEN('TEXT',

Line 933: l_msg_data := APP_EXCEPTION.Get_Text;

929: WHEN OTHERS THEN
930: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
931: x_return_status := 'U';
932: x_oracle_error := APP_EXCEPTION.Get_Code;
933: l_msg_data := APP_EXCEPTION.Get_Text;
934: FND_MESSAGE.SET_NAME('GR',
935: 'GR_UNEXPECTED_ERROR');
936: FND_MESSAGE.SET_TOKEN('TEXT',
937: l_msg_data,

Line 1218: APP_EXCEPTION.Raise_Exception;

1214: FND_MESSAGE.SET_TOKEN('TABLES',
1215: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1216: FALSE);
1217: IF FND_API.To_Boolean(p_called_by_form) THEN
1218: APP_EXCEPTION.Raise_Exception;
1219: ELSE
1220: x_msg_data := FND_MESSAGE.Get;
1221: END IF;
1222:

Line 1226: x_oracle_error := APP_EXCEPTION.Get_Code;

1222:
1223: WHEN OTHERS THEN
1224: ROLLBACK TO SAVEPOINT Check_Integrity;
1225: x_return_status := 'U';
1226: x_oracle_error := APP_EXCEPTION.Get_Code;
1227: l_msg_data := APP_EXCEPTION.Get_Text;
1228: FND_MESSAGE.SET_NAME('GR',
1229: 'GR_UNEXPECTED_ERROR');
1230: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1227: l_msg_data := APP_EXCEPTION.Get_Text;

1223: WHEN OTHERS THEN
1224: ROLLBACK TO SAVEPOINT Check_Integrity;
1225: x_return_status := 'U';
1226: x_oracle_error := APP_EXCEPTION.Get_Code;
1227: l_msg_data := APP_EXCEPTION.Get_Text;
1228: FND_MESSAGE.SET_NAME('GR',
1229: 'GR_UNEXPECTED_ERROR');
1230: FND_MESSAGE.SET_TOKEN('TEXT',
1231: l_msg_data,

Line 1234: APP_EXCEPTION.Raise_Exception;

1230: FND_MESSAGE.SET_TOKEN('TEXT',
1231: l_msg_data,
1232: FALSE);
1233: IF FND_API.To_Boolean(p_called_by_form) THEN
1234: APP_EXCEPTION.Raise_Exception;
1235: ELSE
1236: x_msg_data := FND_MESSAGE.Get;
1237: END IF;
1238:

Line 1282: l_msg_data := APP_EXCEPTION.Get_Text;

1278:
1279: EXCEPTION
1280:
1281: WHEN Others THEN
1282: l_msg_data := APP_EXCEPTION.Get_Text;
1283: FND_MESSAGE.SET_NAME('GR',
1284: 'GR_UNEXPECTED_ERROR');
1285: FND_MESSAGE.SET_TOKEN('TEXT',
1286: l_msg_data,

Line 1289: APP_EXCEPTION.Raise_Exception;

1285: FND_MESSAGE.SET_TOKEN('TEXT',
1286: l_msg_data,
1287: FALSE);
1288: IF FND_API.To_Boolean(p_called_by_form) THEN
1289: APP_EXCEPTION.Raise_Exception;
1290: END IF;
1291:
1292: END Check_Primary_Key;
1293: