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_EFFECT_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_effect_code,

Line 132: APP_EXCEPTION.Raise_Exception;

128: FND_MESSAGE.SET_TOKEN('CODE',
129: p_toxic_effect_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_effect_code,

Line 147: APP_EXCEPTION.Raise_Exception;

143: FND_MESSAGE.SET_TOKEN('CODE',
144: p_toxic_effect_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 250: APP_EXCEPTION.Raise_Exception;

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

Line 258: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 265: APP_EXCEPTION.Raise_Exception;

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

Line 273: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 274: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 281: APP_EXCEPTION.Raise_Exception;

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

Line 364: APP_EXCEPTION.Raise_Exception;

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

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 475: APP_EXCEPTION.Raise_Exception;

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

Line 483: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 490: APP_EXCEPTION.Raise_Exception;

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

Line 498: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 499: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 500: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 507: APP_EXCEPTION.Raise_Exception;

503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_data,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;
511:

Line 549: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 550: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 628: APP_EXCEPTION.Raise_Exception;

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

Line 635: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 636: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 643: APP_EXCEPTION.Raise_Exception;

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

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: