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

Line 134: APP_EXCEPTION.Raise_Exception;

130: FND_MESSAGE.SET_TOKEN('TEXT',
131: l_msg_data,
132: FALSE);
133: IF FND_API.To_Boolean(p_called_by_form) THEN
134: APP_EXCEPTION.Raise_Exception;
135: ELSE
136: x_msg_data := FND_MESSAGE.Get;
137: END IF;
138:

Line 142: x_oracle_error := APP_EXCEPTION.Get_Code;

138:
139: WHEN Item_Exists_Error THEN
140: ROLLBACK TO SAVEPOINT Insert_Row;
141: x_return_status := 'E';
142: x_oracle_error := APP_EXCEPTION.Get_Code;
143: FND_MESSAGE.SET_NAME('GR',
144: 'GR_RECORD_EXISTS');
145: FND_MESSAGE.SET_TOKEN('CODE',
146: p_inventory_item_id,

Line 149: APP_EXCEPTION.Raise_Exception;

145: FND_MESSAGE.SET_TOKEN('CODE',
146: p_inventory_item_id,
147: FALSE);
148: IF FND_API.To_Boolean(p_called_by_form) THEN
149: APP_EXCEPTION.Raise_Exception;
150: ELSE
151: x_msg_data := FND_MESSAGE.Get;
152: END IF;
153:

Line 157: x_oracle_error := APP_EXCEPTION.Get_Code;

153:
154: WHEN Row_Missing_Error THEN
155: ROLLBACK TO SAVEPOINT Insert_Row;
156: x_return_status := 'E';
157: x_oracle_error := APP_EXCEPTION.Get_Code;
158: FND_MESSAGE.SET_NAME('GR',
159: 'GR_NO_RECORD_INSERTED');
160: FND_MESSAGE.SET_TOKEN('CODE',
161: p_inventory_item_id,

Line 164: APP_EXCEPTION.Raise_Exception;

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

Line 172: x_oracle_error := APP_EXCEPTION.Get_Code;

168:
169: WHEN OTHERS THEN
170: ROLLBACK TO SAVEPOINT Insert_Row;
171: x_return_status := 'U';
172: x_oracle_error := APP_EXCEPTION.Get_Code;
173: l_msg_data := APP_EXCEPTION.Get_Text;
174: FND_MESSAGE.SET_NAME('GR',
175: 'GR_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('TEXT',

Line 173: l_msg_data := APP_EXCEPTION.Get_Text;

169: WHEN OTHERS THEN
170: ROLLBACK TO SAVEPOINT Insert_Row;
171: x_return_status := 'U';
172: x_oracle_error := APP_EXCEPTION.Get_Code;
173: l_msg_data := APP_EXCEPTION.Get_Text;
174: FND_MESSAGE.SET_NAME('GR',
175: 'GR_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_data,

Line 180: APP_EXCEPTION.Raise_Exception;

176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_data,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;
184:

Line 278: APP_EXCEPTION.Raise_Exception;

274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;
282:

Line 286: x_oracle_error := APP_EXCEPTION.Get_Code;

282:
283: WHEN Row_Missing_Error THEN
284: ROLLBACK TO SAVEPOINT Update_Row;
285: x_return_status := 'E';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_NO_RECORD_INSERTED');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: p_inventory_item_id,

Line 293: APP_EXCEPTION.Raise_Exception;

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

Line 301: x_oracle_error := APP_EXCEPTION.Get_Code;

297:
298: WHEN OTHERS THEN
299: ROLLBACK TO SAVEPOINT Update_Row;
300: x_return_status := 'U';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: l_msg_data := APP_EXCEPTION.Get_Text;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',

Line 302: l_msg_data := APP_EXCEPTION.Get_Text;

298: WHEN OTHERS THEN
299: ROLLBACK TO SAVEPOINT Update_Row;
300: x_return_status := 'U';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: l_msg_data := APP_EXCEPTION.Get_Text;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_data,

Line 309: APP_EXCEPTION.Raise_Exception;

305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_data,
307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;
310: ELSE
311: x_msg_data := FND_MESSAGE.Get;
312: END IF;
313:

Line 393: APP_EXCEPTION.Raise_Exception;

389: FND_MESSAGE.SET_TOKEN('CODE',
390: p_inventory_item_id,
391: FALSE);
392: IF FND_API.To_Boolean(p_called_by_form) THEN
393: APP_EXCEPTION.Raise_Exception;
394: ELSE
395: x_msg_data := FND_MESSAGE.Get;
396: END IF;
397:

Line 401: x_oracle_error := APP_EXCEPTION.Get_Code;

397:
398: WHEN Row_Already_Locked_Error THEN
399: ROLLBACK TO SAVEPOINT Lock_Row;
400: x_return_status := 'E';
401: x_oracle_error := APP_EXCEPTION.Get_Code;
402: FND_MESSAGE.SET_NAME('GR',
403: 'GR_ROW_IS_LOCKED');
404: IF FND_API.To_Boolean(p_called_by_form) THEN
405: APP_EXCEPTION.Raise_Exception;

Line 405: APP_EXCEPTION.Raise_Exception;

401: x_oracle_error := APP_EXCEPTION.Get_Code;
402: FND_MESSAGE.SET_NAME('GR',
403: 'GR_ROW_IS_LOCKED');
404: IF FND_API.To_Boolean(p_called_by_form) THEN
405: APP_EXCEPTION.Raise_Exception;
406: ELSE
407: x_msg_data := FND_MESSAGE.Get;
408: END IF;
409:

Line 413: x_oracle_error := APP_EXCEPTION.Get_Code;

409:
410: WHEN OTHERS THEN
411: ROLLBACK TO SAVEPOINT Lock_Row;
412: x_return_status := 'U';
413: x_oracle_error := APP_EXCEPTION.Get_Code;
414: l_msg_data := APP_EXCEPTION.Get_Text;
415: FND_MESSAGE.SET_NAME('GR',
416: 'GR_UNEXPECTED_ERROR');
417: FND_MESSAGE.SET_TOKEN('TEXT',

Line 414: l_msg_data := APP_EXCEPTION.Get_Text;

410: WHEN OTHERS THEN
411: ROLLBACK TO SAVEPOINT Lock_Row;
412: x_return_status := 'U';
413: x_oracle_error := APP_EXCEPTION.Get_Code;
414: l_msg_data := APP_EXCEPTION.Get_Text;
415: FND_MESSAGE.SET_NAME('GR',
416: 'GR_UNEXPECTED_ERROR');
417: FND_MESSAGE.SET_TOKEN('TEXT',
418: l_msg_data,

Line 421: APP_EXCEPTION.Raise_Exception;

417: FND_MESSAGE.SET_TOKEN('TEXT',
418: l_msg_data,
419: FALSE);
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 506: APP_EXCEPTION.Raise_Exception;

502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := l_return_status;
504: x_oracle_error := l_oracle_error;
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;
507: ELSE
508: x_msg_data := FND_MESSAGE.Get;
509: END IF;
510:

Line 514: x_oracle_error := APP_EXCEPTION.Get_Code;

510:
511: WHEN Row_Missing_Error THEN
512: ROLLBACK TO SAVEPOINT Delete_Row;
513: x_return_status := 'E';
514: x_oracle_error := APP_EXCEPTION.Get_Code;
515: FND_MESSAGE.SET_NAME('GR',
516: 'GR_RECORD_NOT_FOUND');
517: FND_MESSAGE.SET_TOKEN('CODE',
518: p_inventory_item_id,

Line 521: APP_EXCEPTION.Raise_Exception;

517: FND_MESSAGE.SET_TOKEN('CODE',
518: p_inventory_item_id,
519: FALSE);
520: IF FND_API.To_Boolean(p_called_by_form) THEN
521: APP_EXCEPTION.Raise_Exception;
522: ELSE
523: x_msg_data := FND_MESSAGE.Get;
524: END IF;
525:

Line 529: x_oracle_error := APP_EXCEPTION.Get_Code;

525:
526: WHEN OTHERS THEN
527: ROLLBACK TO SAVEPOINT Delete_Row;
528: x_return_status := 'U';
529: x_oracle_error := APP_EXCEPTION.Get_Code;
530: l_msg_data := APP_EXCEPTION.Get_Text;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: FND_MESSAGE.SET_NAME('GR',
533: 'GR_UNEXPECTED_ERROR');

Line 530: l_msg_data := APP_EXCEPTION.Get_Text;

526: WHEN OTHERS THEN
527: ROLLBACK TO SAVEPOINT Delete_Row;
528: x_return_status := 'U';
529: x_oracle_error := APP_EXCEPTION.Get_Code;
530: l_msg_data := APP_EXCEPTION.Get_Text;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: FND_MESSAGE.SET_NAME('GR',
533: 'GR_UNEXPECTED_ERROR');
534: FND_MESSAGE.SET_TOKEN('TEXT',

Line 531: l_msg_data := APP_EXCEPTION.Get_Text;

527: ROLLBACK TO SAVEPOINT Delete_Row;
528: x_return_status := 'U';
529: x_oracle_error := APP_EXCEPTION.Get_Code;
530: l_msg_data := APP_EXCEPTION.Get_Text;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: FND_MESSAGE.SET_NAME('GR',
533: 'GR_UNEXPECTED_ERROR');
534: FND_MESSAGE.SET_TOKEN('TEXT',
535: l_msg_data,

Line 538: APP_EXCEPTION.Raise_Exception;

534: FND_MESSAGE.SET_TOKEN('TEXT',
535: l_msg_data,
536: FALSE);
537: IF FND_API.To_Boolean(p_called_by_form) THEN
538: APP_EXCEPTION.Raise_Exception;
539: ELSE
540: x_msg_data := FND_MESSAGE.Get;
541: END IF;
542:

Line 581: x_oracle_error := APP_EXCEPTION.Get_Code;

577:
578: WHEN OTHERS THEN
579: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
580: x_return_status := 'U';
581: x_oracle_error := APP_EXCEPTION.Get_Code;
582: l_msg_data := APP_EXCEPTION.Get_Text;
583: FND_MESSAGE.SET_NAME('GR',
584: 'GR_UNEXPECTED_ERROR');
585: FND_MESSAGE.SET_TOKEN('TEXT',

Line 582: l_msg_data := APP_EXCEPTION.Get_Text;

578: WHEN OTHERS THEN
579: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
580: x_return_status := 'U';
581: x_oracle_error := APP_EXCEPTION.Get_Code;
582: l_msg_data := APP_EXCEPTION.Get_Text;
583: FND_MESSAGE.SET_NAME('GR',
584: 'GR_UNEXPECTED_ERROR');
585: FND_MESSAGE.SET_TOKEN('TEXT',
586: l_msg_data,

Line 671: APP_EXCEPTION.Raise_Exception;

667: FND_MESSAGE.SET_TOKEN('TABLES',
668: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
669: FALSE);
670: IF FND_API.To_Boolean(p_called_by_form) THEN
671: APP_EXCEPTION.Raise_Exception;
672: ELSE
673: x_msg_data := FND_MESSAGE.Get;
674: END IF;
675: WHEN OTHERS THEN

Line 678: x_oracle_error := APP_EXCEPTION.Get_Code;

674: END IF;
675: WHEN OTHERS THEN
676: ROLLBACK TO SAVEPOINT Check_Integrity;
677: x_return_status := 'U';
678: x_oracle_error := APP_EXCEPTION.Get_Code;
679: l_msg_data := APP_EXCEPTION.Get_Text;
680: FND_MESSAGE.SET_NAME('GR',
681: 'GR_UNEXPECTED_ERROR');
682: FND_MESSAGE.SET_TOKEN('TEXT',

Line 679: l_msg_data := APP_EXCEPTION.Get_Text;

675: WHEN OTHERS THEN
676: ROLLBACK TO SAVEPOINT Check_Integrity;
677: x_return_status := 'U';
678: x_oracle_error := APP_EXCEPTION.Get_Code;
679: l_msg_data := APP_EXCEPTION.Get_Text;
680: FND_MESSAGE.SET_NAME('GR',
681: 'GR_UNEXPECTED_ERROR');
682: FND_MESSAGE.SET_TOKEN('TEXT',
683: l_msg_data,

Line 686: APP_EXCEPTION.Raise_Exception;

682: FND_MESSAGE.SET_TOKEN('TEXT',
683: l_msg_data,
684: FALSE);
685: IF FND_API.To_Boolean(p_called_by_form) THEN
686: APP_EXCEPTION.Raise_Exception;
687: ELSE
688: x_msg_data := FND_MESSAGE.Get;
689: END IF;
690:

Line 738: l_msg_data := APP_EXCEPTION.Get_Text;

734:
735: EXCEPTION
736:
737: WHEN Others THEN
738: l_msg_data := APP_EXCEPTION.Get_Text;
739: FND_MESSAGE.SET_NAME('GR',
740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_data,

Line 745: APP_EXCEPTION.Raise_Exception;

741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_data,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;
746: END IF;
747:
748: END Check_Primary_Key;
749: