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

Line 117: APP_EXCEPTION.Raise_Exception;

113: FND_MESSAGE.SET_TOKEN('TEXT',
114: l_msg_data,
115: FALSE);
116: IF FND_API.To_Boolean(p_called_by_form) THEN
117: APP_EXCEPTION.Raise_Exception;
118: ELSE
119: x_msg_data := FND_MESSAGE.Get;
120: END IF;
121:

Line 125: x_oracle_error := APP_EXCEPTION.Get_Code;

121:
122: WHEN Item_Exists_Error THEN
123: ROLLBACK TO SAVEPOINT Insert_Row;
124: x_return_status := 'E';
125: x_oracle_error := APP_EXCEPTION.Get_Code;
126: FND_MESSAGE.SET_NAME('GR',
127: 'GR_RECORD_EXISTS');
128: FND_MESSAGE.SET_TOKEN('CODE',
129: p_toxic_route_code,

Line 132: APP_EXCEPTION.Raise_Exception;

128: FND_MESSAGE.SET_TOKEN('CODE',
129: p_toxic_route_code,
130: FALSE);
131: IF FND_API.To_Boolean(p_called_by_form) THEN
132: APP_EXCEPTION.Raise_Exception;
133: ELSE
134: x_msg_data := FND_MESSAGE.Get;
135: END IF;
136:

Line 140: x_oracle_error := APP_EXCEPTION.Get_Code;

136:
137: WHEN Row_Missing_Error THEN
138: ROLLBACK TO SAVEPOINT Insert_Row;
139: x_return_status := 'E';
140: x_oracle_error := APP_EXCEPTION.Get_Code;
141: FND_MESSAGE.SET_NAME('GR',
142: 'GR_NO_RECORD_INSERTED');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: p_toxic_route_code,

Line 147: APP_EXCEPTION.Raise_Exception;

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

Line 155: x_oracle_error := APP_EXCEPTION.Get_Code;

151:
152: WHEN OTHERS THEN
153: ROLLBACK TO SAVEPOINT Insert_Row;
154: x_return_status := 'U';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: l_msg_data := APP_EXCEPTION.Get_Text;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_UNEXPECTED_ERROR');
159: FND_MESSAGE.SET_TOKEN('TEXT',

Line 156: l_msg_data := APP_EXCEPTION.Get_Text;

152: WHEN OTHERS THEN
153: ROLLBACK TO SAVEPOINT Insert_Row;
154: x_return_status := 'U';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: l_msg_data := APP_EXCEPTION.Get_Text;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_UNEXPECTED_ERROR');
159: FND_MESSAGE.SET_TOKEN('TEXT',
160: l_msg_data,

Line 163: APP_EXCEPTION.Raise_Exception;

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

Line 251: APP_EXCEPTION.Raise_Exception;

247: FND_MESSAGE.SET_TOKEN('TEXT',
248: l_msg_data,
249: FALSE);
250: IF FND_API.To_Boolean(p_called_by_form) THEN
251: APP_EXCEPTION.Raise_Exception;
252: ELSE
253: x_msg_data := FND_MESSAGE.Get;
254: END IF;
255:

Line 259: x_oracle_error := APP_EXCEPTION.Get_Code;

255:
256: WHEN Row_Missing_Error THEN
257: ROLLBACK TO SAVEPOINT Update_Row;
258: x_return_status := 'E';
259: x_oracle_error := APP_EXCEPTION.Get_Code;
260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_NO_RECORD_INSERTED');
262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_toxic_route_code,

Line 266: APP_EXCEPTION.Raise_Exception;

262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_toxic_route_code,
264: FALSE);
265: IF FND_API.To_Boolean(p_called_by_form) THEN
266: APP_EXCEPTION.Raise_Exception;
267: ELSE
268: x_msg_data := FND_MESSAGE.Get;
269: END IF;
270:

Line 274: x_oracle_error := APP_EXCEPTION.Get_Code;

270:
271: WHEN OTHERS THEN
272: ROLLBACK TO SAVEPOINT Update_Row;
273: x_return_status := 'U';
274: x_oracle_error := APP_EXCEPTION.Get_Code;
275: l_msg_data := APP_EXCEPTION.Get_Text;
276: FND_MESSAGE.SET_NAME('GR',
277: 'GR_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('TEXT',

Line 275: l_msg_data := APP_EXCEPTION.Get_Text;

271: WHEN OTHERS THEN
272: ROLLBACK TO SAVEPOINT Update_Row;
273: x_return_status := 'U';
274: x_oracle_error := APP_EXCEPTION.Get_Code;
275: l_msg_data := APP_EXCEPTION.Get_Text;
276: FND_MESSAGE.SET_NAME('GR',
277: 'GR_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('TEXT',
279: l_msg_data,

Line 282: APP_EXCEPTION.Raise_Exception;

278: FND_MESSAGE.SET_TOKEN('TEXT',
279: l_msg_data,
280: FALSE);
281: IF FND_API.To_Boolean(p_called_by_form) THEN
282: APP_EXCEPTION.Raise_Exception;
283: ELSE
284: x_msg_data := FND_MESSAGE.Get;
285: END IF;
286:

Line 365: APP_EXCEPTION.Raise_Exception;

361: FND_MESSAGE.SET_TOKEN('CODE',
362: p_toxic_route_code,
363: FALSE);
364: IF FND_API.To_Boolean(p_called_by_form) THEN
365: APP_EXCEPTION.Raise_Exception;
366: ELSE
367: x_msg_data := FND_MESSAGE.Get;
368: END IF;
369: WHEN RECORD_CHANGED_ERROR THEN

Line 375: APP_EXCEPTION.Raise_Exception;

371: X_return_status := 'E';
372: FND_MESSAGE.SET_NAME('FND',
373: 'FORM_RECORD_CHANGED');
374: IF FND_API.To_Boolean(p_called_by_form) THEN
375: APP_EXCEPTION.Raise_Exception;
376: ELSE
377: x_msg_data := FND_MESSAGE.Get;
378: END IF;
379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

375: APP_EXCEPTION.Raise_Exception;
376: ELSE
377: x_msg_data := FND_MESSAGE.Get;
378: END IF;
379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
380: ROLLBACK TO SAVEPOINT Lock_Row;
381: x_return_status := 'L';
382: x_oracle_error := APP_EXCEPTION.Get_Code;
383: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 382: x_oracle_error := APP_EXCEPTION.Get_Code;

378: END IF;
379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
380: ROLLBACK TO SAVEPOINT Lock_Row;
381: x_return_status := 'L';
382: x_oracle_error := APP_EXCEPTION.Get_Code;
383: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_ROW_IS_LOCKED');
386: x_msg_data := FND_MESSAGE.Get;

Line 392: x_oracle_error := APP_EXCEPTION.Get_Code;

388:
389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'U';
392: x_oracle_error := APP_EXCEPTION.Get_Code;
393: l_msg_data := APP_EXCEPTION.Get_Text;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_UNEXPECTED_ERROR');
396: FND_MESSAGE.SET_TOKEN('TEXT',

Line 393: l_msg_data := APP_EXCEPTION.Get_Text;

389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'U';
392: x_oracle_error := APP_EXCEPTION.Get_Code;
393: l_msg_data := APP_EXCEPTION.Get_Text;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_UNEXPECTED_ERROR');
396: FND_MESSAGE.SET_TOKEN('TEXT',
397: l_msg_data,

Line 400: APP_EXCEPTION.Raise_Exception;

396: FND_MESSAGE.SET_TOKEN('TEXT',
397: l_msg_data,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:

Line 474: APP_EXCEPTION.Raise_Exception;

470: ROLLBACK TO SAVEPOINT Delete_Row;
471: x_return_status := l_return_status;
472: x_oracle_error := l_oracle_error;
473: IF FND_API.To_Boolean(p_called_by_form) THEN
474: APP_EXCEPTION.Raise_Exception;
475: ELSE
476: x_msg_data := FND_MESSAGE.Get;
477: END IF;
478:

Line 482: x_oracle_error := APP_EXCEPTION.Get_Code;

478:
479: WHEN Row_Missing_Error THEN
480: ROLLBACK TO SAVEPOINT Delete_Row;
481: x_return_status := 'E';
482: x_oracle_error := APP_EXCEPTION.Get_Code;
483: FND_MESSAGE.SET_NAME('GR',
484: 'GR_RECORD_NOT_FOUND');
485: FND_MESSAGE.SET_TOKEN('CODE',
486: p_toxic_route_code,

Line 489: APP_EXCEPTION.Raise_Exception;

485: FND_MESSAGE.SET_TOKEN('CODE',
486: p_toxic_route_code,
487: FALSE);
488: IF FND_API.To_Boolean(p_called_by_form) THEN
489: APP_EXCEPTION.Raise_Exception;
490: ELSE
491: x_msg_data := FND_MESSAGE.Get;
492: END IF;
493:

Line 497: x_oracle_error := APP_EXCEPTION.Get_Code;

493:
494: WHEN OTHERS THEN
495: ROLLBACK TO SAVEPOINT Delete_Row;
496: x_return_status := 'U';
497: x_oracle_error := APP_EXCEPTION.Get_Code;
498: l_msg_data := APP_EXCEPTION.Get_Text;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');

Line 498: l_msg_data := APP_EXCEPTION.Get_Text;

494: WHEN OTHERS THEN
495: ROLLBACK TO SAVEPOINT Delete_Row;
496: x_return_status := 'U';
497: x_oracle_error := APP_EXCEPTION.Get_Code;
498: l_msg_data := APP_EXCEPTION.Get_Text;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',

Line 499: l_msg_data := APP_EXCEPTION.Get_Text;

495: ROLLBACK TO SAVEPOINT Delete_Row;
496: x_return_status := 'U';
497: x_oracle_error := APP_EXCEPTION.Get_Code;
498: l_msg_data := APP_EXCEPTION.Get_Text;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,

Line 506: APP_EXCEPTION.Raise_Exception;

502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,
504: FALSE);
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 548: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 549: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 629: APP_EXCEPTION.Raise_Exception;

625: FND_MESSAGE.SET_TOKEN('TABLES',
626: l_msg_data,
627: FALSE);
628: IF FND_API.To_Boolean(p_called_by_form) THEN
629: APP_EXCEPTION.Raise_Exception;
630: ELSE
631: x_msg_data := FND_MESSAGE.Get;
632: END IF;
633: WHEN OTHERS THEN

Line 636: x_oracle_error := APP_EXCEPTION.Get_Code;

632: END IF;
633: WHEN OTHERS THEN
634: ROLLBACK TO SAVEPOINT Check_Integrity;
635: x_return_status := 'U';
636: x_oracle_error := APP_EXCEPTION.Get_Code;
637: l_msg_data := APP_EXCEPTION.Get_Text;
638: FND_MESSAGE.SET_NAME('GR',
639: 'GR_UNEXPECTED_ERROR');
640: FND_MESSAGE.SET_TOKEN('TEXT',

Line 637: l_msg_data := APP_EXCEPTION.Get_Text;

633: WHEN OTHERS THEN
634: ROLLBACK TO SAVEPOINT Check_Integrity;
635: x_return_status := 'U';
636: x_oracle_error := APP_EXCEPTION.Get_Code;
637: l_msg_data := APP_EXCEPTION.Get_Text;
638: FND_MESSAGE.SET_NAME('GR',
639: 'GR_UNEXPECTED_ERROR');
640: FND_MESSAGE.SET_TOKEN('TEXT',
641: l_msg_data,

Line 644: APP_EXCEPTION.Raise_Exception;

640: FND_MESSAGE.SET_TOKEN('TEXT',
641: l_msg_data,
642: FALSE);
643: IF FND_API.To_Boolean(p_called_by_form) THEN
644: APP_EXCEPTION.Raise_Exception;
645: ELSE
646: x_msg_data := FND_MESSAGE.Get;
647: END IF;
648: END Check_Integrity;

Line 683: l_msg_data := APP_EXCEPTION.Get_Text;

679:
680: EXCEPTION
681:
682: WHEN Others THEN
683: l_msg_data := APP_EXCEPTION.Get_Text;
684: FND_MESSAGE.SET_NAME('GR',
685: 'GR_UNEXPECTED_ERROR');
686: FND_MESSAGE.SET_TOKEN('TEXT',
687: l_msg_data,

Line 690: APP_EXCEPTION.Raise_Exception;

686: FND_MESSAGE.SET_TOKEN('TEXT',
687: l_msg_data,
688: FALSE);
689: IF FND_API.To_Boolean(p_called_by_form) THEN
690: APP_EXCEPTION.Raise_Exception;
691: END IF;
692:
693: END Check_Primary_Key;
694: