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

Line 133: FND_MESSAGE.SET_NAME('GR',

129: WHEN Foreign_Key_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;
131: x_return_status := l_return_status;
132: x_oracle_error := l_oracle_error;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_FOREIGN_KEY_ERROR');
135: FND_MESSAGE.SET_TOKEN('TEXT',
136: l_msg_data,
137: FALSE);

Line 135: FND_MESSAGE.SET_TOKEN('TEXT',

131: x_return_status := l_return_status;
132: x_oracle_error := l_oracle_error;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_FOREIGN_KEY_ERROR');
135: FND_MESSAGE.SET_TOKEN('TEXT',
136: l_msg_data,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;

Line 141: x_msg_data := FND_MESSAGE.Get;

137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;
143:
144: WHEN Item_Exists_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;

Line 148: FND_MESSAGE.SET_NAME('GR',

144: WHEN Item_Exists_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_risk_phrase_code,
152: FALSE);

Line 150: FND_MESSAGE.SET_TOKEN('CODE',

146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_risk_phrase_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;

Line 156: x_msg_data := FND_MESSAGE.Get;

152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;
158:
159: WHEN Row_Missing_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;

Line 163: FND_MESSAGE.SET_NAME('GR',

159: WHEN Row_Missing_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_risk_phrase_code,
167: FALSE);

Line 165: FND_MESSAGE.SET_TOKEN('CODE',

161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_risk_phrase_code,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;

Line 171: x_msg_data := FND_MESSAGE.Get;

167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;
173:
174: WHEN OTHERS THEN
175: ROLLBACK TO SAVEPOINT Insert_Row;

Line 179: FND_MESSAGE.SET_NAME('GR',

175: ROLLBACK TO SAVEPOINT Insert_Row;
176: x_return_status := 'U';
177: x_oracle_error := APP_EXCEPTION.Get_Code;
178: l_msg_data := APP_EXCEPTION.Get_Text;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_data,
183: FALSE);

Line 181: FND_MESSAGE.SET_TOKEN('TEXT',

177: x_oracle_error := APP_EXCEPTION.Get_Code;
178: l_msg_data := APP_EXCEPTION.Get_Text;
179: FND_MESSAGE.SET_NAME('GR',
180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_data,
183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;

Line 187: x_msg_data := FND_MESSAGE.Get;

183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;
186: ELSE
187: x_msg_data := FND_MESSAGE.Get;
188: END IF;
189:
190: END Insert_Row;
191:

Line 277: FND_MESSAGE.SET_NAME('GR',

273: WHEN Foreign_Key_Error THEN
274: ROLLBACK TO SAVEPOINT Update_Row;
275: x_return_status := l_return_status;
276: x_oracle_error := l_oracle_error;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);

Line 279: FND_MESSAGE.SET_TOKEN('TEXT',

275: x_return_status := l_return_status;
276: x_oracle_error := l_oracle_error;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;

Line 285: x_msg_data := FND_MESSAGE.Get;

281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;
287:
288: WHEN Row_Missing_Error THEN
289: ROLLBACK TO SAVEPOINT Update_Row;

Line 292: FND_MESSAGE.SET_NAME('GR',

288: WHEN Row_Missing_Error THEN
289: ROLLBACK TO SAVEPOINT Update_Row;
290: x_return_status := 'E';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: FND_MESSAGE.SET_NAME('GR',
293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_risk_phrase_code,
296: FALSE);

Line 294: FND_MESSAGE.SET_TOKEN('CODE',

290: x_return_status := 'E';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: FND_MESSAGE.SET_NAME('GR',
293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_risk_phrase_code,
296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;

Line 300: x_msg_data := FND_MESSAGE.Get;

296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;
299: ELSE
300: x_msg_data := FND_MESSAGE.Get;
301: END IF;
302:
303: WHEN OTHERS THEN
304: ROLLBACK TO SAVEPOINT Update_Row;

Line 308: FND_MESSAGE.SET_NAME('GR',

304: ROLLBACK TO SAVEPOINT Update_Row;
305: x_return_status := 'U';
306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);

Line 310: FND_MESSAGE.SET_TOKEN('TEXT',

306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;

Line 316: x_msg_data := FND_MESSAGE.Get;

312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:
319: END Update_Row;
320:

Line 392: FND_MESSAGE.SET_NAME('GR',

388:
389: WHEN No_Data_Found_Error THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'E';
392: FND_MESSAGE.SET_NAME('GR',
393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_risk_phrase_code,
396: FALSE);

Line 394: FND_MESSAGE.SET_TOKEN('CODE',

390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'E';
392: FND_MESSAGE.SET_NAME('GR',
393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_risk_phrase_code,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;

Line 400: x_msg_data := FND_MESSAGE.Get;

396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;
402:
403: WHEN Row_Already_Locked_Error THEN
404: ROLLBACK TO SAVEPOINT Lock_Row;

Line 407: FND_MESSAGE.SET_NAME('GR',

403: WHEN Row_Already_Locked_Error THEN
404: ROLLBACK TO SAVEPOINT Lock_Row;
405: x_return_status := 'E';
406: x_oracle_error := APP_EXCEPTION.Get_Code;
407: FND_MESSAGE.SET_NAME('GR',
408: 'GR_ROW_IS_LOCKED');
409: IF FND_API.To_Boolean(p_called_by_form) THEN
410: APP_EXCEPTION.Raise_Exception;
411: ELSE

Line 412: x_msg_data := FND_MESSAGE.Get;

408: 'GR_ROW_IS_LOCKED');
409: IF FND_API.To_Boolean(p_called_by_form) THEN
410: APP_EXCEPTION.Raise_Exception;
411: ELSE
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;
414:
415: WHEN OTHERS THEN
416: ROLLBACK TO SAVEPOINT Lock_Row;

Line 420: FND_MESSAGE.SET_NAME('GR',

416: ROLLBACK TO SAVEPOINT Lock_Row;
417: x_return_status := 'U';
418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);

Line 422: FND_MESSAGE.SET_TOKEN('TEXT',

418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;

Line 428: x_msg_data := FND_MESSAGE.Get;

424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;
430:
431: END Lock_Row;
432:

Line 519: FND_MESSAGE.SET_NAME('GR',

515: WHEN Row_Missing_Error THEN
516: ROLLBACK TO SAVEPOINT Delete_Row;
517: x_return_status := 'E';
518: x_oracle_error := APP_EXCEPTION.Get_Code;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_RECORD_NOT_FOUND');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: p_risk_phrase_code,
523: FALSE);

Line 521: FND_MESSAGE.SET_TOKEN('CODE',

517: x_return_status := 'E';
518: x_oracle_error := APP_EXCEPTION.Get_Code;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_RECORD_NOT_FOUND');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: p_risk_phrase_code,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;

Line 527: x_msg_data := FND_MESSAGE.Get;

523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;
529:
530: WHEN OTHERS THEN
531: ROLLBACK TO SAVEPOINT Delete_Row;

Line 536: FND_MESSAGE.SET_NAME('GR',

532: x_return_status := 'U';
533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: l_msg_data := APP_EXCEPTION.Get_Text;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_UNEXPECTED_ERROR');
538: FND_MESSAGE.SET_TOKEN('TEXT',
539: l_msg_data,
540: FALSE);

Line 538: FND_MESSAGE.SET_TOKEN('TEXT',

534: l_msg_data := APP_EXCEPTION.Get_Text;
535: l_msg_data := APP_EXCEPTION.Get_Text;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_UNEXPECTED_ERROR');
538: FND_MESSAGE.SET_TOKEN('TEXT',
539: l_msg_data,
540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;

Line 544: x_msg_data := FND_MESSAGE.Get;

540: FALSE);
541: IF FND_API.To_Boolean(p_called_by_form) THEN
542: APP_EXCEPTION.Raise_Exception;
543: ELSE
544: x_msg_data := FND_MESSAGE.Get;
545: END IF;
546:
547: END Delete_Row;
548:

Line 594: FND_MESSAGE.SET_NAME('GR',

590: ROLLBACK TO SAVEPOINT Delete_Rows;
591: x_return_status := 'U';
592: x_oracle_error := APP_EXCEPTION.Get_Code;
593: l_msg_data := APP_EXCEPTION.Get_Text;
594: FND_MESSAGE.SET_NAME('GR',
595: 'GR_UNEXPECTED_ERROR');
596: FND_MESSAGE.SET_TOKEN('TEXT',
597: l_msg_token,
598: FALSE);

Line 596: FND_MESSAGE.SET_TOKEN('TEXT',

592: x_oracle_error := APP_EXCEPTION.Get_Code;
593: l_msg_data := APP_EXCEPTION.Get_Text;
594: FND_MESSAGE.SET_NAME('GR',
595: 'GR_UNEXPECTED_ERROR');
596: FND_MESSAGE.SET_TOKEN('TEXT',
597: l_msg_token,
598: FALSE);
599: END Delete_Rows;
600:

Line 648: FND_MESSAGE.SET_NAME('GR',

644: l_rowid,
645: l_key_exists);
646:
647: IF NOT FND_API.To_Boolean(l_key_exists) THEN
648: FND_MESSAGE.SET_NAME('GR',
649: 'GR_RECORD_NOT_FOUND');
650: FND_MESSAGE.SET_TOKEN('CODE',
651: l_risk_phrase,
652: FALSE);

Line 650: FND_MESSAGE.SET_TOKEN('CODE',

646:
647: IF NOT FND_API.To_Boolean(l_key_exists) THEN
648: FND_MESSAGE.SET_NAME('GR',
649: 'GR_RECORD_NOT_FOUND');
650: FND_MESSAGE.SET_TOKEN('CODE',
651: l_risk_phrase,
652: FALSE);
653: l_msg_data := l_msg_data || FND_MESSAGE.Get;
654: x_return_status := 'E';

Line 653: l_msg_data := l_msg_data || FND_MESSAGE.Get;

649: 'GR_RECORD_NOT_FOUND');
650: FND_MESSAGE.SET_TOKEN('CODE',
651: l_risk_phrase,
652: FALSE);
653: l_msg_data := l_msg_data || FND_MESSAGE.Get;
654: x_return_status := 'E';
655: END IF;
656:
657: /* Now check the combination phrase */

Line 667: FND_MESSAGE.SET_NAME('GR',

663: l_rowid,
664: l_key_exists);
665:
666: IF NOT FND_API.To_Boolean(l_key_exists) THEN
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_RECORD_NOT_FOUND');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: l_risk_phrase,
671: FALSE);

Line 669: FND_MESSAGE.SET_TOKEN('CODE',

665:
666: IF NOT FND_API.To_Boolean(l_key_exists) THEN
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_RECORD_NOT_FOUND');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: l_risk_phrase,
671: FALSE);
672: l_msg_data := l_msg_data || FND_MESSAGE.Get;
673: x_return_status := 'E';

Line 672: l_msg_data := l_msg_data || FND_MESSAGE.Get;

668: 'GR_RECORD_NOT_FOUND');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: l_risk_phrase,
671: FALSE);
672: l_msg_data := l_msg_data || FND_MESSAGE.Get;
673: x_return_status := 'E';
674: END IF;
675:
676: IF x_return_status <> 'S' THEN

Line 688: FND_MESSAGE.SET_NAME('GR',

684:
685: x_return_status := 'U';
686: x_oracle_error := APP_EXCEPTION.Get_Code;
687: l_msg_data := APP_EXCEPTION.Get_Text;
688: FND_MESSAGE.SET_NAME('GR',
689: 'GR_UNEXPECTED_ERROR');
690: FND_MESSAGE.SET_TOKEN('TEXT',
691: l_msg_data,
692: FALSE);

Line 690: FND_MESSAGE.SET_TOKEN('TEXT',

686: x_oracle_error := APP_EXCEPTION.Get_Code;
687: l_msg_data := APP_EXCEPTION.Get_Text;
688: FND_MESSAGE.SET_NAME('GR',
689: 'GR_UNEXPECTED_ERROR');
690: FND_MESSAGE.SET_TOKEN('TEXT',
691: l_msg_data,
692: FALSE);
693: END Check_Foreign_Keys;
694:

Line 746: FND_MESSAGE.SET_NAME('GR',

742: ROLLBACK TO SAVEPOINT Check_Integrity;
743: x_return_status := 'U';
744: x_oracle_error := APP_EXCEPTION.Get_Code;
745: l_msg_data := APP_EXCEPTION.Get_Text;
746: FND_MESSAGE.SET_NAME('GR',
747: 'GR_UNEXPECTED_ERROR');
748: FND_MESSAGE.SET_TOKEN('TEXT',
749: l_msg_data,
750: FALSE);

Line 748: FND_MESSAGE.SET_TOKEN('TEXT',

744: x_oracle_error := APP_EXCEPTION.Get_Code;
745: l_msg_data := APP_EXCEPTION.Get_Text;
746: FND_MESSAGE.SET_NAME('GR',
747: 'GR_UNEXPECTED_ERROR');
748: FND_MESSAGE.SET_TOKEN('TEXT',
749: l_msg_data,
750: FALSE);
751: IF FND_API.To_Boolean(p_called_by_form) THEN
752: APP_EXCEPTION.Raise_Exception;

Line 754: x_msg_data := FND_MESSAGE.Get;

750: FALSE);
751: IF FND_API.To_Boolean(p_called_by_form) THEN
752: APP_EXCEPTION.Raise_Exception;
753: ELSE
754: x_msg_data := FND_MESSAGE.Get;
755: END IF;
756:
757: END Check_Integrity;
758:

Line 801: FND_MESSAGE.SET_NAME('GR',

797: EXCEPTION
798:
799: WHEN Others THEN
800: l_msg_data := APP_EXCEPTION.Get_Text;
801: FND_MESSAGE.SET_NAME('GR',
802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);

Line 803: FND_MESSAGE.SET_TOKEN('TEXT',

799: WHEN Others THEN
800: l_msg_data := APP_EXCEPTION.Get_Text;
801: FND_MESSAGE.SET_NAME('GR',
802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;