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

Line 174: APP_EXCEPTION.Raise_Exception;

170: FND_MESSAGE.SET_TOKEN('TEXT',
171: l_msg_data,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;
178:

Line 182: x_oracle_error := APP_EXCEPTION.Get_Code;

178:
179: WHEN Label_Exists_Error THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;
181: x_return_status := 'E';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: FND_MESSAGE.SET_NAME('GR',
184: 'GR_RECORD_EXISTS');
185: FND_MESSAGE.SET_TOKEN('CODE',
186: p_item_code,

Line 189: APP_EXCEPTION.Raise_Exception;

185: FND_MESSAGE.SET_TOKEN('CODE',
186: p_item_code,
187: FALSE);
188: IF FND_API.To_Boolean(p_called_by_form) THEN
189: APP_EXCEPTION.Raise_Exception;
190: ELSE
191: x_msg_data := FND_MESSAGE.Get;
192: END IF;
193:

Line 197: x_oracle_error := APP_EXCEPTION.Get_Code;

193:
194: WHEN Row_Missing_Error THEN
195: ROLLBACK TO SAVEPOINT Insert_Row;
196: x_return_status := 'E';
197: x_oracle_error := APP_EXCEPTION.Get_Code;
198: FND_MESSAGE.SET_NAME('GR',
199: 'GR_NO_RECORD_INSERTED');
200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,

Line 204: APP_EXCEPTION.Raise_Exception;

200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);
203: IF FND_API.To_Boolean(p_called_by_form) THEN
204: APP_EXCEPTION.Raise_Exception;
205: ELSE
206: x_msg_data := FND_MESSAGE.Get;
207: END IF;
208:

Line 212: x_oracle_error := APP_EXCEPTION.Get_Code;

208:
209: WHEN OTHERS THEN
210: ROLLBACK TO SAVEPOINT Insert_Row;
211: x_return_status := 'U';
212: x_oracle_error := APP_EXCEPTION.Get_Code;
213: l_msg_data := APP_EXCEPTION.Get_Text;
214: FND_MESSAGE.SET_NAME('GR',
215: 'GR_UNEXPECTED_ERROR');
216: FND_MESSAGE.SET_TOKEN('TEXT',

Line 213: l_msg_data := APP_EXCEPTION.Get_Text;

209: WHEN OTHERS THEN
210: ROLLBACK TO SAVEPOINT Insert_Row;
211: x_return_status := 'U';
212: x_oracle_error := APP_EXCEPTION.Get_Code;
213: l_msg_data := APP_EXCEPTION.Get_Text;
214: FND_MESSAGE.SET_NAME('GR',
215: 'GR_UNEXPECTED_ERROR');
216: FND_MESSAGE.SET_TOKEN('TEXT',
217: l_msg_data,

Line 220: APP_EXCEPTION.Raise_Exception;

216: FND_MESSAGE.SET_TOKEN('TEXT',
217: l_msg_data,
218: FALSE);
219: IF FND_API.To_Boolean(p_called_by_form) THEN
220: APP_EXCEPTION.Raise_Exception;
221: ELSE
222: x_msg_data := FND_MESSAGE.Get;
223: END IF;
224:

Line 346: APP_EXCEPTION.Raise_Exception;

342: FND_MESSAGE.SET_TOKEN('TEXT',
343: l_msg_data,
344: FALSE);
345: IF FND_API.To_Boolean(p_called_by_form) THEN
346: APP_EXCEPTION.Raise_Exception;
347: ELSE
348: x_msg_data := FND_MESSAGE.Get;
349: END IF;
350:

Line 354: x_oracle_error := APP_EXCEPTION.Get_Code;

350:
351: WHEN Row_Missing_Error THEN
352: ROLLBACK TO SAVEPOINT Update_Row;
353: x_return_status := 'E';
354: x_oracle_error := APP_EXCEPTION.Get_Code;
355: FND_MESSAGE.SET_NAME('GR',
356: 'GR_NO_RECORD_INSERTED');
357: FND_MESSAGE.SET_TOKEN('CODE',
358: p_item_code,

Line 361: APP_EXCEPTION.Raise_Exception;

357: FND_MESSAGE.SET_TOKEN('CODE',
358: p_item_code,
359: FALSE);
360: IF FND_API.To_Boolean(p_called_by_form) THEN
361: APP_EXCEPTION.Raise_Exception;
362: ELSE
363: x_msg_data := FND_MESSAGE.Get;
364: END IF;
365:

Line 369: x_oracle_error := APP_EXCEPTION.Get_Code;

365:
366: WHEN OTHERS THEN
367: ROLLBACK TO SAVEPOINT Update_Row;
368: x_return_status := 'U';
369: x_oracle_error := APP_EXCEPTION.Get_Code;
370: l_msg_data := APP_EXCEPTION.Get_Text;
371: FND_MESSAGE.SET_NAME('GR',
372: 'GR_UNEXPECTED_ERROR');
373: FND_MESSAGE.SET_TOKEN('TEXT',

Line 370: l_msg_data := APP_EXCEPTION.Get_Text;

366: WHEN OTHERS THEN
367: ROLLBACK TO SAVEPOINT Update_Row;
368: x_return_status := 'U';
369: x_oracle_error := APP_EXCEPTION.Get_Code;
370: l_msg_data := APP_EXCEPTION.Get_Text;
371: FND_MESSAGE.SET_NAME('GR',
372: 'GR_UNEXPECTED_ERROR');
373: FND_MESSAGE.SET_TOKEN('TEXT',
374: l_msg_data,

Line 377: APP_EXCEPTION.Raise_Exception;

373: FND_MESSAGE.SET_TOKEN('TEXT',
374: l_msg_data,
375: FALSE);
376: IF FND_API.To_Boolean(p_called_by_form) THEN
377: APP_EXCEPTION.Raise_Exception;
378: ELSE
379: x_msg_data := FND_MESSAGE.Get;
380: END IF;
381:

Line 471: APP_EXCEPTION.Raise_Exception;

467: FND_MESSAGE.SET_TOKEN('CODE',
468: p_item_code,
469: FALSE);
470: IF FND_API.To_Boolean(p_called_by_form) THEN
471: APP_EXCEPTION.Raise_Exception;
472: ELSE
473: x_msg_data := FND_MESSAGE.Get;
474: END IF;
475:

Line 479: x_oracle_error := APP_EXCEPTION.Get_Code;

475:
476: WHEN Row_Already_Locked_Error THEN
477: ROLLBACK TO SAVEPOINT Lock_Row;
478: x_return_status := 'E';
479: x_oracle_error := APP_EXCEPTION.Get_Code;
480: FND_MESSAGE.SET_NAME('GR',
481: 'GR_ROW_IS_LOCKED');
482: IF FND_API.To_Boolean(p_called_by_form) THEN
483: APP_EXCEPTION.Raise_Exception;

Line 483: APP_EXCEPTION.Raise_Exception;

479: x_oracle_error := APP_EXCEPTION.Get_Code;
480: FND_MESSAGE.SET_NAME('GR',
481: 'GR_ROW_IS_LOCKED');
482: IF FND_API.To_Boolean(p_called_by_form) THEN
483: APP_EXCEPTION.Raise_Exception;
484: ELSE
485: x_msg_data := FND_MESSAGE.Get;
486: END IF;
487:

Line 491: x_oracle_error := APP_EXCEPTION.Get_Code;

487:
488: WHEN OTHERS THEN
489: ROLLBACK TO SAVEPOINT Lock_Row;
490: x_return_status := 'U';
491: x_oracle_error := APP_EXCEPTION.Get_Code;
492: l_msg_data := APP_EXCEPTION.Get_Text;
493: FND_MESSAGE.SET_NAME('GR',
494: 'GR_UNEXPECTED_ERROR');
495: FND_MESSAGE.SET_TOKEN('TEXT',

Line 492: l_msg_data := APP_EXCEPTION.Get_Text;

488: WHEN OTHERS THEN
489: ROLLBACK TO SAVEPOINT Lock_Row;
490: x_return_status := 'U';
491: x_oracle_error := APP_EXCEPTION.Get_Code;
492: l_msg_data := APP_EXCEPTION.Get_Text;
493: FND_MESSAGE.SET_NAME('GR',
494: 'GR_UNEXPECTED_ERROR');
495: FND_MESSAGE.SET_TOKEN('TEXT',
496: l_msg_data,

Line 499: APP_EXCEPTION.Raise_Exception;

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

Line 602: APP_EXCEPTION.Raise_Exception;

598: ROLLBACK TO SAVEPOINT Delete_Row;
599: x_return_status := l_return_status;
600: x_oracle_error := l_oracle_error;
601: IF FND_API.To_Boolean(p_called_by_form) THEN
602: APP_EXCEPTION.Raise_Exception;
603: ELSE
604: x_msg_data := FND_MESSAGE.Get;
605: END IF;
606:

Line 610: x_oracle_error := APP_EXCEPTION.Get_Code;

606:
607: WHEN Row_Missing_Error THEN
608: ROLLBACK TO SAVEPOINT Delete_Row;
609: x_return_status := 'E';
610: x_oracle_error := APP_EXCEPTION.Get_Code;
611: FND_MESSAGE.SET_NAME('GR',
612: 'GR_RECORD_NOT_FOUND');
613: FND_MESSAGE.SET_TOKEN('CODE',
614: p_item_code,

Line 617: APP_EXCEPTION.Raise_Exception;

613: FND_MESSAGE.SET_TOKEN('CODE',
614: p_item_code,
615: FALSE);
616: IF FND_API.To_Boolean(p_called_by_form) THEN
617: APP_EXCEPTION.Raise_Exception;
618: ELSE
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;
621:

Line 625: x_oracle_error := APP_EXCEPTION.Get_Code;

621:
622: WHEN OTHERS THEN
623: ROLLBACK TO SAVEPOINT Delete_Row;
624: x_return_status := 'U';
625: x_oracle_error := APP_EXCEPTION.Get_Code;
626: l_msg_data := APP_EXCEPTION.Get_Text;
627: l_msg_data := APP_EXCEPTION.Get_Text;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_UNEXPECTED_ERROR');

Line 626: l_msg_data := APP_EXCEPTION.Get_Text;

622: WHEN OTHERS THEN
623: ROLLBACK TO SAVEPOINT Delete_Row;
624: x_return_status := 'U';
625: x_oracle_error := APP_EXCEPTION.Get_Code;
626: l_msg_data := APP_EXCEPTION.Get_Text;
627: l_msg_data := APP_EXCEPTION.Get_Text;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('TEXT',

Line 627: l_msg_data := APP_EXCEPTION.Get_Text;

623: ROLLBACK TO SAVEPOINT Delete_Row;
624: x_return_status := 'U';
625: x_oracle_error := APP_EXCEPTION.Get_Code;
626: l_msg_data := APP_EXCEPTION.Get_Text;
627: l_msg_data := APP_EXCEPTION.Get_Text;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('TEXT',
631: l_msg_data,

Line 634: APP_EXCEPTION.Raise_Exception;

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

Line 684: x_oracle_error := APP_EXCEPTION.Get_Code;

680:
681: WHEN OTHERS THEN
682: ROLLBACK TO SAVEPOINT Delete_Rows;
683: x_return_status := 'U';
684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',

Line 685: l_msg_data := APP_EXCEPTION.Get_Text;

681: WHEN OTHERS THEN
682: ROLLBACK TO SAVEPOINT Delete_Rows;
683: x_return_status := 'U';
684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_token,

Line 692: APP_EXCEPTION.Raise_Exception;

688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_token,
690: FALSE);
691: IF FND_API.To_Boolean(p_called_by_form) THEN
692: APP_EXCEPTION.Raise_Exception;
693: ELSE
694: x_msg_data := FND_MESSAGE.Get;
695: END IF;
696:

Line 797: x_oracle_error := APP_EXCEPTION.Get_Code;

793:
794: WHEN OTHERS THEN
795: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
796: x_return_status := 'U';
797: x_oracle_error := APP_EXCEPTION.Get_Code;
798: l_msg_data := APP_EXCEPTION.Get_Text;
799: FND_MESSAGE.SET_NAME('GR',
800: 'GR_UNEXPECTED_ERROR');
801: FND_MESSAGE.SET_TOKEN('TEXT',

Line 798: l_msg_data := APP_EXCEPTION.Get_Text;

794: WHEN OTHERS THEN
795: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
796: x_return_status := 'U';
797: x_oracle_error := APP_EXCEPTION.Get_Code;
798: l_msg_data := APP_EXCEPTION.Get_Text;
799: FND_MESSAGE.SET_NAME('GR',
800: 'GR_UNEXPECTED_ERROR');
801: FND_MESSAGE.SET_TOKEN('TEXT',
802: l_msg_data,

Line 867: x_oracle_error := APP_EXCEPTION.Get_Code;

863:
864: WHEN OTHERS THEN
865: ROLLBACK TO SAVEPOINT Check_Integrity;
866: x_return_status := 'U';
867: x_oracle_error := APP_EXCEPTION.Get_Code;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',

Line 868: l_msg_data := APP_EXCEPTION.Get_Text;

864: WHEN OTHERS THEN
865: ROLLBACK TO SAVEPOINT Check_Integrity;
866: x_return_status := 'U';
867: x_oracle_error := APP_EXCEPTION.Get_Code;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,

Line 875: APP_EXCEPTION.Raise_Exception;

871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,
873: FALSE);
874: IF FND_API.To_Boolean(p_called_by_form) THEN
875: APP_EXCEPTION.Raise_Exception;
876: ELSE
877: x_msg_data := FND_MESSAGE.Get;
878: END IF;
879:

Line 930: l_msg_data := APP_EXCEPTION.Get_Text;

926:
927: EXCEPTION
928:
929: WHEN Others THEN
930: l_msg_data := APP_EXCEPTION.Get_Text;
931: FND_MESSAGE.SET_NAME('GR',
932: 'GR_UNEXPECTED_ERROR');
933: FND_MESSAGE.SET_TOKEN('TEXT',
934: l_msg_data,

Line 937: APP_EXCEPTION.Raise_Exception;

933: FND_MESSAGE.SET_TOKEN('TEXT',
934: l_msg_data,
935: FALSE);
936: IF FND_API.To_Boolean(p_called_by_form) THEN
937: APP_EXCEPTION.Raise_Exception;
938: END IF;
939:
940: END Check_Primary_Key;
941: