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

Line 146: APP_EXCEPTION.Raise_Exception;

142: FND_MESSAGE.SET_TOKEN('TEXT',
143: l_msg_data,
144: FALSE);
145: IF FND_API.To_Boolean(p_called_by_form) THEN
146: APP_EXCEPTION.Raise_Exception;
147: ELSE
148: x_msg_data := FND_MESSAGE.Get;
149: END IF;
150:

Line 155: x_oracle_error := APP_EXCEPTION.Get_Code;

151: WHEN Item_Exists_Error THEN
152: ROLLBACK TO SAVEPOINT Insert_Row;
153: l_msg_token := p_item_code || ' ' || p_document_code;
154: x_return_status := 'E';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: FND_MESSAGE.SET_NAME('GR',
157: 'GR_RECORD_THERE');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,

Line 162: APP_EXCEPTION.Raise_Exception;

158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,
160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;
163: ELSE
164: x_msg_data := FND_MESSAGE.Get;
165: END IF;
166:

Line 171: x_oracle_error := APP_EXCEPTION.Get_Code;

167: WHEN Row_Missing_Error THEN
168: ROLLBACK TO SAVEPOINT Insert_Row;
169: l_msg_token := p_item_code || ' ' || p_document_code;
170: x_return_status := 'E';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: FND_MESSAGE.SET_NAME('GR',
173: 'GR_NO_RECORD_INSERTED');
174: FND_MESSAGE.SET_TOKEN('CODE',
175: l_msg_token,

Line 178: APP_EXCEPTION.Raise_Exception;

174: FND_MESSAGE.SET_TOKEN('CODE',
175: l_msg_token,
176: FALSE);
177: IF FND_API.To_Boolean(p_called_by_form) THEN
178: APP_EXCEPTION.Raise_Exception;
179: ELSE
180: x_msg_data := FND_MESSAGE.Get;
181: END IF;
182:

Line 187: x_oracle_error := APP_EXCEPTION.Get_Code;

183: WHEN OTHERS THEN
184: ROLLBACK TO SAVEPOINT Insert_Row;
185: l_msg_token := p_item_code || ' ' || p_document_code;
186: x_return_status := 'U';
187: x_oracle_error := APP_EXCEPTION.Get_Code;
188: l_msg_data := APP_EXCEPTION.Get_Text;
189: FND_MESSAGE.SET_NAME('GR',
190: 'GR_UNEXPECTED_ERROR');
191: FND_MESSAGE.SET_TOKEN('TEXT',

Line 188: l_msg_data := APP_EXCEPTION.Get_Text;

184: ROLLBACK TO SAVEPOINT Insert_Row;
185: l_msg_token := p_item_code || ' ' || p_document_code;
186: x_return_status := 'U';
187: x_oracle_error := APP_EXCEPTION.Get_Code;
188: l_msg_data := APP_EXCEPTION.Get_Text;
189: FND_MESSAGE.SET_NAME('GR',
190: 'GR_UNEXPECTED_ERROR');
191: FND_MESSAGE.SET_TOKEN('TEXT',
192: l_msg_token,

Line 195: APP_EXCEPTION.Raise_Exception;

191: FND_MESSAGE.SET_TOKEN('TEXT',
192: l_msg_token,
193: FALSE);
194: IF FND_API.To_Boolean(p_called_by_form) THEN
195: APP_EXCEPTION.Raise_Exception;
196: ELSE
197: x_msg_data := FND_MESSAGE.Get;
198: END IF;
199:

Line 305: APP_EXCEPTION.Raise_Exception;

301: FND_MESSAGE.SET_TOKEN('TEXT',
302: l_msg_data,
303: FALSE);
304: IF FND_API.To_Boolean(p_called_by_form) THEN
305: APP_EXCEPTION.Raise_Exception;
306: ELSE
307: x_msg_data := FND_MESSAGE.Get;
308: END IF;
309:

Line 313: x_oracle_error := APP_EXCEPTION.Get_Code;

309:
310: WHEN Row_Missing_Error THEN
311: ROLLBACK TO SAVEPOINT Update_Row;
312: x_return_status := 'E';
313: x_oracle_error := APP_EXCEPTION.Get_Code;
314: FND_MESSAGE.SET_NAME('GR',
315: 'GR_NO_RECORD_INSERTED');
316: FND_MESSAGE.SET_TOKEN('CODE',
317: l_msg_token,

Line 320: APP_EXCEPTION.Raise_Exception;

316: FND_MESSAGE.SET_TOKEN('CODE',
317: l_msg_token,
318: FALSE);
319: IF FND_API.To_Boolean(p_called_by_form) THEN
320: APP_EXCEPTION.Raise_Exception;
321: ELSE
322: x_msg_data := FND_MESSAGE.Get;
323: END IF;
324:

Line 328: x_oracle_error := APP_EXCEPTION.Get_Code;

324:
325: WHEN OTHERS THEN
326: ROLLBACK TO SAVEPOINT Update_Row;
327: x_return_status := 'U';
328: x_oracle_error := APP_EXCEPTION.Get_Code;
329: l_msg_data := APP_EXCEPTION.Get_Text;
330: FND_MESSAGE.SET_NAME('GR',
331: 'GR_UNEXPECTED_ERROR');
332: FND_MESSAGE.SET_TOKEN('TEXT',

Line 329: l_msg_data := APP_EXCEPTION.Get_Text;

325: WHEN OTHERS THEN
326: ROLLBACK TO SAVEPOINT Update_Row;
327: x_return_status := 'U';
328: x_oracle_error := APP_EXCEPTION.Get_Code;
329: l_msg_data := APP_EXCEPTION.Get_Text;
330: FND_MESSAGE.SET_NAME('GR',
331: 'GR_UNEXPECTED_ERROR');
332: FND_MESSAGE.SET_TOKEN('TEXT',
333: l_msg_token,

Line 336: APP_EXCEPTION.Raise_Exception;

332: FND_MESSAGE.SET_TOKEN('TEXT',
333: l_msg_token,
334: FALSE);
335: IF FND_API.To_Boolean(p_called_by_form) THEN
336: APP_EXCEPTION.Raise_Exception;
337: ELSE
338: x_msg_data := FND_MESSAGE.Get;
339: END IF;
340:

Line 426: APP_EXCEPTION.Raise_Exception;

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

Line 434: x_oracle_error := APP_EXCEPTION.Get_Code;

430:
431: WHEN Row_Already_Locked_Error THEN
432: ROLLBACK TO SAVEPOINT Lock_Row;
433: x_return_status := 'E';
434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: FND_MESSAGE.SET_NAME('GR',
436: 'GR_ROW_IS_LOCKED');
437: IF FND_API.To_Boolean(p_called_by_form) THEN
438: APP_EXCEPTION.Raise_Exception;

Line 438: APP_EXCEPTION.Raise_Exception;

434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: FND_MESSAGE.SET_NAME('GR',
436: 'GR_ROW_IS_LOCKED');
437: IF FND_API.To_Boolean(p_called_by_form) THEN
438: APP_EXCEPTION.Raise_Exception;
439: ELSE
440: x_msg_data := FND_MESSAGE.Get;
441: END IF;
442:

Line 446: x_oracle_error := APP_EXCEPTION.Get_Code;

442:
443: WHEN OTHERS THEN
444: ROLLBACK TO SAVEPOINT Lock_Row;
445: x_return_status := 'U';
446: x_oracle_error := APP_EXCEPTION.Get_Code;
447: l_msg_data := APP_EXCEPTION.Get_Text;
448: FND_MESSAGE.SET_NAME('GR',
449: 'GR_UNEXPECTED_ERROR');
450: FND_MESSAGE.SET_TOKEN('TEXT',

Line 447: l_msg_data := APP_EXCEPTION.Get_Text;

443: WHEN OTHERS THEN
444: ROLLBACK TO SAVEPOINT Lock_Row;
445: x_return_status := 'U';
446: x_oracle_error := APP_EXCEPTION.Get_Code;
447: l_msg_data := APP_EXCEPTION.Get_Text;
448: FND_MESSAGE.SET_NAME('GR',
449: 'GR_UNEXPECTED_ERROR');
450: FND_MESSAGE.SET_TOKEN('TEXT',
451: l_msg_token,

Line 454: APP_EXCEPTION.Raise_Exception;

450: FND_MESSAGE.SET_TOKEN('TEXT',
451: l_msg_token,
452: FALSE);
453: IF FND_API.To_Boolean(p_called_by_form) THEN
454: APP_EXCEPTION.Raise_Exception;
455: ELSE
456: x_msg_data := FND_MESSAGE.Get;
457: END IF;
458:

Line 547: APP_EXCEPTION.Raise_Exception;

543: ROLLBACK TO SAVEPOINT Delete_Row;
544: x_return_status := l_return_status;
545: x_oracle_error := l_oracle_error;
546: IF FND_API.To_Boolean(p_called_by_form) THEN
547: APP_EXCEPTION.Raise_Exception;
548: ELSE
549: x_msg_data := FND_MESSAGE.Get;
550: END IF;
551:

Line 555: x_oracle_error := APP_EXCEPTION.Get_Code;

551:
552: WHEN Row_Missing_Error THEN
553: ROLLBACK TO SAVEPOINT Delete_Row;
554: x_return_status := 'E';
555: x_oracle_error := APP_EXCEPTION.Get_Code;
556: FND_MESSAGE.SET_NAME('GR',
557: 'GR_RECORD_NOT_FOUND');
558: FND_MESSAGE.SET_TOKEN('CODE',
559: l_msg_token,

Line 562: APP_EXCEPTION.Raise_Exception;

558: FND_MESSAGE.SET_TOKEN('CODE',
559: l_msg_token,
560: FALSE);
561: IF FND_API.To_Boolean(p_called_by_form) THEN
562: APP_EXCEPTION.Raise_Exception;
563: ELSE
564: x_msg_data := FND_MESSAGE.Get;
565: END IF;
566:

Line 570: x_oracle_error := APP_EXCEPTION.Get_Code;

566:
567: WHEN OTHERS THEN
568: ROLLBACK TO SAVEPOINT Delete_Row;
569: x_return_status := 'U';
570: x_oracle_error := APP_EXCEPTION.Get_Code;
571: l_msg_data := APP_EXCEPTION.Get_Text;
572: l_msg_data := APP_EXCEPTION.Get_Text;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_UNEXPECTED_ERROR');

Line 571: l_msg_data := APP_EXCEPTION.Get_Text;

567: WHEN OTHERS THEN
568: ROLLBACK TO SAVEPOINT Delete_Row;
569: x_return_status := 'U';
570: x_oracle_error := APP_EXCEPTION.Get_Code;
571: l_msg_data := APP_EXCEPTION.Get_Text;
572: l_msg_data := APP_EXCEPTION.Get_Text;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_UNEXPECTED_ERROR');
575: FND_MESSAGE.SET_TOKEN('TEXT',

Line 572: l_msg_data := APP_EXCEPTION.Get_Text;

568: ROLLBACK TO SAVEPOINT Delete_Row;
569: x_return_status := 'U';
570: x_oracle_error := APP_EXCEPTION.Get_Code;
571: l_msg_data := APP_EXCEPTION.Get_Text;
572: l_msg_data := APP_EXCEPTION.Get_Text;
573: FND_MESSAGE.SET_NAME('GR',
574: 'GR_UNEXPECTED_ERROR');
575: FND_MESSAGE.SET_TOKEN('TEXT',
576: l_msg_token,

Line 579: APP_EXCEPTION.Raise_Exception;

575: FND_MESSAGE.SET_TOKEN('TEXT',
576: l_msg_token,
577: FALSE);
578: IF FND_API.To_Boolean(p_called_by_form) THEN
579: APP_EXCEPTION.Raise_Exception;
580: ELSE
581: x_msg_data := FND_MESSAGE.Get;
582: END IF;
583:

Line 656: x_oracle_error := APP_EXCEPTION.Get_Code;

652: EXCEPTION
653:
654: WHEN Null_Delete_Option_Error THEN
655: x_return_status := 'E';
656: x_oracle_error := APP_EXCEPTION.Get_Code;
657: FND_MESSAGE.SET_NAME('GR',
658: 'GR_NULL_VALUE');
659: FND_MESSAGE.SET_TOKEN('CODE',
660: l_msg_token,

Line 663: APP_EXCEPTION.Raise_Exception;

659: FND_MESSAGE.SET_TOKEN('CODE',
660: l_msg_token,
661: FALSE);
662: IF FND_API.To_Boolean(p_called_by_form) THEN
663: APP_EXCEPTION.Raise_Exception;
664: ELSE
665: x_msg_data := FND_MESSAGE.Get;
666: END IF;
667:

Line 671: x_oracle_error := APP_EXCEPTION.Get_Code;

667:
668: WHEN OTHERS THEN
669: ROLLBACK TO SAVEPOINT Delete_Rows;
670: x_return_status := 'U';
671: x_oracle_error := APP_EXCEPTION.Get_Code;
672: l_msg_data := APP_EXCEPTION.Get_Text;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_UNEXPECTED_ERROR');
675: FND_MESSAGE.SET_TOKEN('TEXT',

Line 672: l_msg_data := APP_EXCEPTION.Get_Text;

668: WHEN OTHERS THEN
669: ROLLBACK TO SAVEPOINT Delete_Rows;
670: x_return_status := 'U';
671: x_oracle_error := APP_EXCEPTION.Get_Code;
672: l_msg_data := APP_EXCEPTION.Get_Text;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_UNEXPECTED_ERROR');
675: FND_MESSAGE.SET_TOKEN('TEXT',
676: l_msg_token,

Line 679: APP_EXCEPTION.Raise_Exception;

675: FND_MESSAGE.SET_TOKEN('TEXT',
676: l_msg_token,
677: FALSE);
678: IF FND_API.To_Boolean(p_called_by_form) THEN
679: APP_EXCEPTION.Raise_Exception;
680: ELSE
681: x_msg_data := FND_MESSAGE.Get;
682: END IF;
683:

Line 761: x_oracle_error := APP_EXCEPTION.Get_Code;

757: EXCEPTION
758:
759: WHEN Row_Missing_Error THEN
760: x_return_status := 'E';
761: x_oracle_error := APP_EXCEPTION.Get_Code;
762: FND_MESSAGE.SET_NAME('GR',
763: 'GR_RECORD_NOT_FOUND');
764: FND_MESSAGE.SET_TOKEN('CODE',
765: l_msg_token,

Line 771: x_oracle_error := APP_EXCEPTION.Get_Code;

767: x_msg_data := FND_MESSAGE.Get;
768:
769: WHEN OTHERS THEN
770: x_return_status := 'U';
771: x_oracle_error := APP_EXCEPTION.Get_Code;
772: l_msg_data := APP_EXCEPTION.Get_Text;
773: FND_MESSAGE.SET_NAME('GR',
774: 'GR_UNEXPECTED_ERROR');
775: FND_MESSAGE.SET_TOKEN('TEXT',

Line 772: l_msg_data := APP_EXCEPTION.Get_Text;

768:
769: WHEN OTHERS THEN
770: x_return_status := 'U';
771: x_oracle_error := APP_EXCEPTION.Get_Code;
772: l_msg_data := APP_EXCEPTION.Get_Text;
773: FND_MESSAGE.SET_NAME('GR',
774: 'GR_UNEXPECTED_ERROR');
775: FND_MESSAGE.SET_TOKEN('TEXT',
776: l_msg_token,

Line 827: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 828: l_msg_data := APP_EXCEPTION.Get_Text;

824: WHEN OTHERS THEN
825: ROLLBACK TO SAVEPOINT Check_Integrity;
826: x_return_status := 'U';
827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: FND_MESSAGE.SET_NAME('GR',
830: 'GR_UNEXPECTED_ERROR');
831: FND_MESSAGE.SET_TOKEN('TEXT',
832: l_msg_data,

Line 835: APP_EXCEPTION.Raise_Exception;

831: FND_MESSAGE.SET_TOKEN('TEXT',
832: l_msg_data,
833: FALSE);
834: IF FND_API.To_Boolean(p_called_by_form) THEN
835: APP_EXCEPTION.Raise_Exception;
836: ELSE
837: x_msg_data := FND_MESSAGE.Get;
838: END IF;
839:

Line 888: l_msg_data := APP_EXCEPTION.Get_Text;

884:
885: EXCEPTION
886:
887: WHEN Others THEN
888: l_msg_data := APP_EXCEPTION.Get_Text;
889: FND_MESSAGE.SET_NAME('GR',
890: 'GR_UNEXPECTED_ERROR');
891: FND_MESSAGE.SET_TOKEN('TEXT',
892: l_msg_data,

Line 895: APP_EXCEPTION.Raise_Exception;

891: FND_MESSAGE.SET_TOKEN('TEXT',
892: l_msg_data,
893: FALSE);
894: IF FND_API.To_Boolean(p_called_by_form) THEN
895: APP_EXCEPTION.Raise_Exception;
896: END IF;
897:
898: END Check_Primary_Key;
899: