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

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

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

Line 481: FND_MESSAGE.SET_TOKEN('TEXT',

477: x_return_status := l_return_status;
478: x_oracle_error := l_oracle_error;
479: FND_MESSAGE.SET_NAME('GR',
480: 'GR_FOREIGN_KEY_ERROR');
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;

Line 487: x_msg_data := FND_MESSAGE.Get;

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:
490: WHEN Row_Missing_Error THEN
491: ROLLBACK TO SAVEPOINT Update_Row;

Line 494: FND_MESSAGE.SET_NAME('GR',

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,
498: FALSE);

Line 496: FND_MESSAGE.SET_TOKEN('CODE',

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,
498: FALSE);
499: IF FND_API.To_Boolean(p_called_by_form) THEN
500: APP_EXCEPTION.Raise_Exception;

Line 502: x_msg_data := FND_MESSAGE.Get;

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:
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT Update_Row;

Line 510: FND_MESSAGE.SET_NAME('GR',

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,
514: FALSE);

Line 512: FND_MESSAGE.SET_TOKEN('TEXT',

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,
514: FALSE);
515: IF FND_API.To_Boolean(p_called_by_form) THEN
516: APP_EXCEPTION.Raise_Exception;

Line 518: x_msg_data := FND_MESSAGE.Get;

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:
521: END Update_Row;
522:

Line 627: FND_MESSAGE.SET_NAME('GR',

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

Line 629: FND_MESSAGE.SET_TOKEN('CODE',

625: ROLLBACK TO SAVEPOINT Lock_Row;
626: x_return_status := 'E';
627: FND_MESSAGE.SET_NAME('GR',
628: 'GR_RECORD_NOT_FOUND');
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;

Line 635: x_msg_data := FND_MESSAGE.Get;

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:
638: WHEN RECORD_CHANGED_ERROR THEN
639: ROLLBACK TO SAVEPOINT Lock_Row;

Line 641: FND_MESSAGE.SET_NAME('FND',

637:
638: WHEN RECORD_CHANGED_ERROR THEN
639: ROLLBACK TO SAVEPOINT Lock_Row;
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

Line 646: x_msg_data := FND_MESSAGE.Get;

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
649: ROLLBACK TO SAVEPOINT Lock_Row;
650: x_return_status := 'L';

Line 653: FND_MESSAGE.SET_NAME('GR',

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;
656: END IF;
657:

Line 655: x_msg_data := FND_MESSAGE.Get;

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;
656: END IF;
657:
658:
659: WHEN OTHERS THEN

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

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,
826: FALSE);

Line 824: FND_MESSAGE.SET_TOKEN('CODE',

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,
826: FALSE);
827: IF FND_API.To_Boolean(p_called_by_form) THEN
828: APP_EXCEPTION.Raise_Exception;

Line 830: x_msg_data := FND_MESSAGE.Get;

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:
833: WHEN OTHERS THEN
834: ROLLBACK TO SAVEPOINT Delete_Row;

Line 839: FND_MESSAGE.SET_NAME('GR',

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,
843: FALSE);

Line 841: FND_MESSAGE.SET_TOKEN('TEXT',

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,
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: END Delete_Row;
851:

Line 934: FND_MESSAGE.SET_NAME('GR',

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,
938: FALSE);

Line 936: FND_MESSAGE.SET_TOKEN('TEXT',

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,
938: FALSE);
939:
940: END Check_Foreign_Keys;

Line 1209: FND_MESSAGE.SET_NAME('GR',

1205:
1206: EXCEPTION
1207: WHEN INTEGRITY_ERROR THEN
1208: x_return_status := 'E';
1209: FND_MESSAGE.SET_NAME('GR',
1210: 'GR_INTEGRITY_HEADER');
1211: FND_MESSAGE.SET_TOKEN('CODE',
1212: p_risk_phrase_code,
1213: FALSE);

Line 1211: FND_MESSAGE.SET_TOKEN('CODE',

1207: WHEN INTEGRITY_ERROR THEN
1208: x_return_status := 'E';
1209: FND_MESSAGE.SET_NAME('GR',
1210: 'GR_INTEGRITY_HEADER');
1211: FND_MESSAGE.SET_TOKEN('CODE',
1212: p_risk_phrase_code,
1213: FALSE);
1214: FND_MESSAGE.SET_TOKEN('TABLES',
1215: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 1214: FND_MESSAGE.SET_TOKEN('TABLES',

1210: 'GR_INTEGRITY_HEADER');
1211: FND_MESSAGE.SET_TOKEN('CODE',
1212: p_risk_phrase_code,
1213: FALSE);
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;

Line 1220: x_msg_data := FND_MESSAGE.Get;

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:
1223: WHEN OTHERS THEN
1224: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 1228: FND_MESSAGE.SET_NAME('GR',

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,
1232: FALSE);

Line 1230: FND_MESSAGE.SET_TOKEN('TEXT',

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,
1232: FALSE);
1233: IF FND_API.To_Boolean(p_called_by_form) THEN
1234: APP_EXCEPTION.Raise_Exception;

Line 1236: x_msg_data := FND_MESSAGE.Get;

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:
1239: END Check_Integrity;
1240:

Line 1283: FND_MESSAGE.SET_NAME('GR',

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,
1287: FALSE);

Line 1285: FND_MESSAGE.SET_TOKEN('TEXT',

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,
1287: FALSE);
1288: IF FND_API.To_Boolean(p_called_by_form) THEN
1289: APP_EXCEPTION.Raise_Exception;