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_ITEM_RISK_PHRASES_PKG dependencies on APP_EXCEPTION

Line 141: APP_EXCEPTION.Raise_Exception;

137: FND_MESSAGE.SET_TOKEN('TEXT',
138: l_msg_data,
139: FALSE);
140: IF FND_API.To_Boolean(p_called_by_form) THEN
141: APP_EXCEPTION.Raise_Exception;
142: ELSE
143: x_msg_data := FND_MESSAGE.Get;
144: END IF;
145:

Line 149: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 156: APP_EXCEPTION.Raise_Exception;

152: FND_MESSAGE.SET_TOKEN('CODE',
153: l_msg_token,
154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;
157: ELSE
158: x_msg_data := FND_MESSAGE.Get;
159: END IF;
160:

Line 164: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 171: APP_EXCEPTION.Raise_Exception;

167: FND_MESSAGE.SET_TOKEN('CODE',
168: l_msg_token,
169: FALSE);
170: IF FND_API.To_Boolean(p_called_by_form) THEN
171: APP_EXCEPTION.Raise_Exception;
172: ELSE
173: x_msg_data := FND_MESSAGE.Get;
174: END IF;
175:

Line 179: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 180: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 187: APP_EXCEPTION.Raise_Exception;

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

Line 292: APP_EXCEPTION.Raise_Exception;

288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;
293: ELSE
294: x_msg_data := FND_MESSAGE.Get;
295: END IF;
296:

Line 300: x_oracle_error := APP_EXCEPTION.Get_Code;

296:
297: WHEN Row_Missing_Error THEN
298: ROLLBACK TO SAVEPOINT Update_Row;
299: x_return_status := 'E';
300: x_oracle_error := APP_EXCEPTION.Get_Code;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_NO_RECORD_INSERTED');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: l_msg_token,

Line 307: APP_EXCEPTION.Raise_Exception;

303: FND_MESSAGE.SET_TOKEN('CODE',
304: l_msg_token,
305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;
308: ELSE
309: x_msg_data := FND_MESSAGE.Get;
310: END IF;
311:

Line 315: x_oracle_error := APP_EXCEPTION.Get_Code;

311:
312: WHEN OTHERS THEN
313: ROLLBACK TO SAVEPOINT Update_Row;
314: x_return_status := 'U';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',

Line 316: l_msg_data := APP_EXCEPTION.Get_Text;

312: WHEN OTHERS THEN
313: ROLLBACK TO SAVEPOINT Update_Row;
314: x_return_status := 'U';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_token,

Line 323: APP_EXCEPTION.Raise_Exception;

319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_token,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;
327:

Line 409: APP_EXCEPTION.Raise_Exception;

405: FND_MESSAGE.SET_TOKEN('CODE',
406: l_msg_token,
407: FALSE);
408: IF FND_API.To_Boolean(p_called_by_form) THEN
409: APP_EXCEPTION.Raise_Exception;
410: ELSE
411: x_msg_data := FND_MESSAGE.Get;
412: END IF;
413:

Line 417: x_oracle_error := APP_EXCEPTION.Get_Code;

413:
414: WHEN Row_Already_Locked_Error THEN
415: ROLLBACK TO SAVEPOINT Lock_Row;
416: x_return_status := 'E';
417: x_oracle_error := APP_EXCEPTION.Get_Code;
418: FND_MESSAGE.SET_NAME('GR',
419: 'GR_ROW_IS_LOCKED');
420: IF FND_API.To_Boolean(p_called_by_form) THEN
421: APP_EXCEPTION.Raise_Exception;

Line 421: APP_EXCEPTION.Raise_Exception;

417: x_oracle_error := APP_EXCEPTION.Get_Code;
418: FND_MESSAGE.SET_NAME('GR',
419: 'GR_ROW_IS_LOCKED');
420: IF FND_API.To_Boolean(p_called_by_form) THEN
421: APP_EXCEPTION.Raise_Exception;
422: ELSE
423: x_msg_data := FND_MESSAGE.Get;
424: END IF;
425:

Line 429: x_oracle_error := APP_EXCEPTION.Get_Code;

425:
426: WHEN OTHERS THEN
427: ROLLBACK TO SAVEPOINT Lock_Row;
428: x_return_status := 'U';
429: x_oracle_error := APP_EXCEPTION.Get_Code;
430: l_msg_data := APP_EXCEPTION.Get_Text;
431: FND_MESSAGE.SET_NAME('GR',
432: 'GR_UNEXPECTED_ERROR');
433: FND_MESSAGE.SET_TOKEN('TEXT',

Line 430: l_msg_data := APP_EXCEPTION.Get_Text;

426: WHEN OTHERS THEN
427: ROLLBACK TO SAVEPOINT Lock_Row;
428: x_return_status := 'U';
429: x_oracle_error := APP_EXCEPTION.Get_Code;
430: l_msg_data := APP_EXCEPTION.Get_Text;
431: FND_MESSAGE.SET_NAME('GR',
432: 'GR_UNEXPECTED_ERROR');
433: FND_MESSAGE.SET_TOKEN('TEXT',
434: l_msg_token,

Line 437: APP_EXCEPTION.Raise_Exception;

433: FND_MESSAGE.SET_TOKEN('TEXT',
434: l_msg_token,
435: FALSE);
436: IF FND_API.To_Boolean(p_called_by_form) THEN
437: APP_EXCEPTION.Raise_Exception;
438: ELSE
439: x_msg_data := FND_MESSAGE.Get;
440: END IF;
441:

Line 529: APP_EXCEPTION.Raise_Exception;

525: x_return_status := l_return_status;
526: x_oracle_error := l_oracle_error;
527: x_msg_data := l_msg_data;
528: IF FND_API.To_Boolean(p_called_by_form) THEN
529: APP_EXCEPTION.Raise_Exception;
530: END IF;
531:
532: WHEN Row_Missing_Error THEN
533: ROLLBACK TO SAVEPOINT Delete_Row;

Line 535: x_oracle_error := APP_EXCEPTION.Get_Code;

531:
532: WHEN Row_Missing_Error THEN
533: ROLLBACK TO SAVEPOINT Delete_Row;
534: x_return_status := 'E';
535: x_oracle_error := APP_EXCEPTION.Get_Code;
536: FND_MESSAGE.SET_NAME('GR',
537: 'GR_RECORD_NOT_FOUND');
538: FND_MESSAGE.SET_TOKEN('CODE',
539: l_msg_token,

Line 542: APP_EXCEPTION.Raise_Exception;

538: FND_MESSAGE.SET_TOKEN('CODE',
539: l_msg_token,
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:

Line 550: x_oracle_error := APP_EXCEPTION.Get_Code;

546:
547: WHEN OTHERS THEN
548: ROLLBACK TO SAVEPOINT Delete_Row;
549: x_return_status := 'U';
550: x_oracle_error := APP_EXCEPTION.Get_Code;
551: l_msg_data := APP_EXCEPTION.Get_Text;
552: l_msg_data := APP_EXCEPTION.Get_Text;
553: FND_MESSAGE.SET_NAME('GR',
554: 'GR_UNEXPECTED_ERROR');

Line 551: l_msg_data := APP_EXCEPTION.Get_Text;

547: WHEN OTHERS THEN
548: ROLLBACK TO SAVEPOINT Delete_Row;
549: x_return_status := 'U';
550: x_oracle_error := APP_EXCEPTION.Get_Code;
551: l_msg_data := APP_EXCEPTION.Get_Text;
552: l_msg_data := APP_EXCEPTION.Get_Text;
553: FND_MESSAGE.SET_NAME('GR',
554: 'GR_UNEXPECTED_ERROR');
555: FND_MESSAGE.SET_TOKEN('TEXT',

Line 552: l_msg_data := APP_EXCEPTION.Get_Text;

548: ROLLBACK TO SAVEPOINT Delete_Row;
549: x_return_status := 'U';
550: x_oracle_error := APP_EXCEPTION.Get_Code;
551: l_msg_data := APP_EXCEPTION.Get_Text;
552: l_msg_data := APP_EXCEPTION.Get_Text;
553: FND_MESSAGE.SET_NAME('GR',
554: 'GR_UNEXPECTED_ERROR');
555: FND_MESSAGE.SET_TOKEN('TEXT',
556: l_msg_token,

Line 559: APP_EXCEPTION.Raise_Exception;

555: FND_MESSAGE.SET_TOKEN('TEXT',
556: l_msg_token,
557: FALSE);
558: IF FND_API.To_Boolean(p_called_by_form) THEN
559: APP_EXCEPTION.Raise_Exception;
560: ELSE
561: x_msg_data := FND_MESSAGE.Get;
562: END IF;
563:

Line 633: x_oracle_error := APP_EXCEPTION.Get_Code;

629: EXCEPTION
630:
631: WHEN Null_Delete_Option_Error THEN
632: x_return_status := 'E';
633: x_oracle_error := APP_EXCEPTION.Get_Code;
634: FND_MESSAGE.SET_NAME('GR',
635: 'GR_NULL_VALUE');
636: FND_MESSAGE.SET_TOKEN('CODE',
637: l_msg_token,

Line 640: APP_EXCEPTION.Raise_Exception;

636: FND_MESSAGE.SET_TOKEN('CODE',
637: l_msg_token,
638: FALSE);
639: IF FND_API.To_Boolean(p_called_by_form) THEN
640: APP_EXCEPTION.Raise_Exception;
641: ELSE
642: x_msg_data := FND_MESSAGE.Get;
643: END IF;
644:

Line 648: x_oracle_error := APP_EXCEPTION.Get_Code;

644:
645: WHEN OTHERS THEN
646: ROLLBACK TO SAVEPOINT Delete_Rows;
647: x_return_status := 'U';
648: x_oracle_error := APP_EXCEPTION.Get_Code;
649: l_msg_data := APP_EXCEPTION.Get_Text;
650: FND_MESSAGE.SET_NAME('GR',
651: 'GR_UNEXPECTED_ERROR');
652: FND_MESSAGE.SET_TOKEN('TEXT',

Line 649: l_msg_data := APP_EXCEPTION.Get_Text;

645: WHEN OTHERS THEN
646: ROLLBACK TO SAVEPOINT Delete_Rows;
647: x_return_status := 'U';
648: x_oracle_error := APP_EXCEPTION.Get_Code;
649: l_msg_data := APP_EXCEPTION.Get_Text;
650: FND_MESSAGE.SET_NAME('GR',
651: 'GR_UNEXPECTED_ERROR');
652: FND_MESSAGE.SET_TOKEN('TEXT',
653: l_msg_token,

Line 656: APP_EXCEPTION.Raise_Exception;

652: FND_MESSAGE.SET_TOKEN('TEXT',
653: l_msg_token,
654: FALSE);
655: IF FND_API.To_Boolean(p_called_by_form) THEN
656: APP_EXCEPTION.Raise_Exception;
657: ELSE
658: x_msg_data := FND_MESSAGE.Get;
659: END IF;
660:

Line 764: x_oracle_error := APP_EXCEPTION.Get_Code;

760:
761: WHEN OTHERS THEN
762: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
763: x_return_status := 'U';
764: x_oracle_error := APP_EXCEPTION.Get_Code;
765: l_msg_data := APP_EXCEPTION.Get_Text;
766: FND_MESSAGE.SET_NAME('GR',
767: 'GR_UNEXPECTED_ERROR');
768: FND_MESSAGE.SET_TOKEN('TEXT',

Line 765: l_msg_data := APP_EXCEPTION.Get_Text;

761: WHEN OTHERS THEN
762: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
763: x_return_status := 'U';
764: x_oracle_error := APP_EXCEPTION.Get_Code;
765: l_msg_data := APP_EXCEPTION.Get_Text;
766: FND_MESSAGE.SET_NAME('GR',
767: 'GR_UNEXPECTED_ERROR');
768: FND_MESSAGE.SET_TOKEN('TEXT',
769: l_msg_token,

Line 822: x_oracle_error := APP_EXCEPTION.Get_Code;

818:
819: WHEN OTHERS THEN
820: ROLLBACK TO SAVEPOINT Check_Integrity;
821: x_return_status := 'U';
822: x_oracle_error := APP_EXCEPTION.Get_Code;
823: l_msg_data := APP_EXCEPTION.Get_Text;
824: FND_MESSAGE.SET_NAME('GR',
825: 'GR_UNEXPECTED_ERROR');
826: FND_MESSAGE.SET_TOKEN('TEXT',

Line 823: l_msg_data := APP_EXCEPTION.Get_Text;

819: WHEN OTHERS THEN
820: ROLLBACK TO SAVEPOINT Check_Integrity;
821: x_return_status := 'U';
822: x_oracle_error := APP_EXCEPTION.Get_Code;
823: l_msg_data := APP_EXCEPTION.Get_Text;
824: FND_MESSAGE.SET_NAME('GR',
825: 'GR_UNEXPECTED_ERROR');
826: FND_MESSAGE.SET_TOKEN('TEXT',
827: l_msg_data,

Line 830: APP_EXCEPTION.Raise_Exception;

826: FND_MESSAGE.SET_TOKEN('TEXT',
827: l_msg_data,
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 883: l_msg_data := APP_EXCEPTION.Get_Text;

879:
880: EXCEPTION
881:
882: WHEN Others THEN
883: l_msg_data := APP_EXCEPTION.Get_Text;
884: FND_MESSAGE.SET_NAME('GR',
885: 'GR_UNEXPECTED_ERROR');
886: FND_MESSAGE.SET_TOKEN('TEXT',
887: l_msg_data,

Line 890: APP_EXCEPTION.Raise_Exception;

886: FND_MESSAGE.SET_TOKEN('TEXT',
887: l_msg_data,
888: FALSE);
889: IF FND_API.To_Boolean(p_called_by_form) THEN
890: APP_EXCEPTION.Raise_Exception;
891: END IF;
892:
893: END Check_Primary_Key;
894: