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

Line 126: APP_EXCEPTION.Raise_Exception;

122: FND_MESSAGE.SET_TOKEN('TEXT',
123: l_msg_data,
124: FALSE);
125: IF FND_API.To_Boolean(p_called_by_form) THEN
126: APP_EXCEPTION.Raise_Exception;
127: ELSE
128: x_msg_data := FND_MESSAGE.Get;
129: END IF;
130:

Line 134: x_oracle_error := APP_EXCEPTION.Get_Code;

130:
131: WHEN Item_Exists_Error THEN
132: ROLLBACK TO SAVEPOINT Insert_Row;
133: x_return_status := 'E';
134: x_oracle_error := APP_EXCEPTION.Get_Code;
135: FND_MESSAGE.SET_NAME('GR',
136: 'GR_RECORD_EXISTS');
137: FND_MESSAGE.SET_TOKEN('CODE',
138: p_toxic_species_code,

Line 141: APP_EXCEPTION.Raise_Exception;

137: FND_MESSAGE.SET_TOKEN('CODE',
138: p_toxic_species_code,
139: FALSE);
140: IF FND_API.To_Boolean(p_called_by_form) THEN
141: APP_EXCEPTION.Raise_Exception;
142: ELSE
143: x_msg_data := FND_MESSAGE.Get;
144: END IF;
145:

Line 149: x_oracle_error := APP_EXCEPTION.Get_Code;

145:
146: WHEN Row_Missing_Error THEN
147: ROLLBACK TO SAVEPOINT Insert_Row;
148: x_return_status := 'E';
149: x_oracle_error := APP_EXCEPTION.Get_Code;
150: FND_MESSAGE.SET_NAME('GR',
151: 'GR_NO_RECORD_INSERTED');
152: FND_MESSAGE.SET_TOKEN('CODE',
153: p_toxic_species_code,

Line 156: APP_EXCEPTION.Raise_Exception;

152: FND_MESSAGE.SET_TOKEN('CODE',
153: p_toxic_species_code,
154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;
157: ELSE
158: x_msg_data := FND_MESSAGE.Get;
159: END IF;
160:

Line 164: x_oracle_error := APP_EXCEPTION.Get_Code;

160:
161: WHEN OTHERS THEN
162: ROLLBACK TO SAVEPOINT Insert_Row;
163: x_return_status := 'U';
164: x_oracle_error := APP_EXCEPTION.Get_Code;
165: l_msg_data := APP_EXCEPTION.Get_Text;
166: FND_MESSAGE.SET_NAME('GR',
167: 'GR_UNEXPECTED_ERROR');
168: FND_MESSAGE.SET_TOKEN('TEXT',

Line 165: l_msg_data := APP_EXCEPTION.Get_Text;

161: WHEN OTHERS THEN
162: ROLLBACK TO SAVEPOINT Insert_Row;
163: x_return_status := 'U';
164: x_oracle_error := APP_EXCEPTION.Get_Code;
165: l_msg_data := APP_EXCEPTION.Get_Text;
166: FND_MESSAGE.SET_NAME('GR',
167: 'GR_UNEXPECTED_ERROR');
168: FND_MESSAGE.SET_TOKEN('TEXT',
169: l_msg_data,

Line 172: APP_EXCEPTION.Raise_Exception;

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

Line 266: APP_EXCEPTION.Raise_Exception;

262: FND_MESSAGE.SET_TOKEN('TEXT',
263: l_msg_data,
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 Row_Missing_Error THEN
272: ROLLBACK TO SAVEPOINT Update_Row;
273: x_return_status := 'E';
274: x_oracle_error := APP_EXCEPTION.Get_Code;
275: FND_MESSAGE.SET_NAME('GR',
276: 'GR_NO_RECORD_INSERTED');
277: FND_MESSAGE.SET_TOKEN('CODE',
278: p_toxic_species_code,

Line 281: APP_EXCEPTION.Raise_Exception;

277: FND_MESSAGE.SET_TOKEN('CODE',
278: p_toxic_species_code,
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 289: x_oracle_error := APP_EXCEPTION.Get_Code;

285:
286: WHEN OTHERS THEN
287: ROLLBACK TO SAVEPOINT Update_Row;
288: x_return_status := 'U';
289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: l_msg_data := APP_EXCEPTION.Get_Text;
291: FND_MESSAGE.SET_NAME('GR',
292: 'GR_UNEXPECTED_ERROR');
293: FND_MESSAGE.SET_TOKEN('TEXT',

Line 290: l_msg_data := APP_EXCEPTION.Get_Text;

286: WHEN OTHERS THEN
287: ROLLBACK TO SAVEPOINT Update_Row;
288: x_return_status := 'U';
289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: l_msg_data := APP_EXCEPTION.Get_Text;
291: FND_MESSAGE.SET_NAME('GR',
292: 'GR_UNEXPECTED_ERROR');
293: FND_MESSAGE.SET_TOKEN('TEXT',
294: l_msg_data,

Line 297: APP_EXCEPTION.Raise_Exception;

293: FND_MESSAGE.SET_TOKEN('TEXT',
294: l_msg_data,
295: FALSE);
296: IF FND_API.To_Boolean(p_called_by_form) THEN
297: APP_EXCEPTION.Raise_Exception;
298: ELSE
299: x_msg_data := FND_MESSAGE.Get;
300: END IF;
301:

Line 382: APP_EXCEPTION.Raise_Exception;

378: FND_MESSAGE.SET_TOKEN('CODE',
379: p_toxic_species_code,
380: FALSE);
381: IF FND_API.To_Boolean(p_called_by_form) THEN
382: APP_EXCEPTION.Raise_Exception;
383: ELSE
384: x_msg_data := FND_MESSAGE.Get;
385: END IF;
386:

Line 393: APP_EXCEPTION.Raise_Exception;

389: X_return_status := 'E';
390: FND_MESSAGE.SET_NAME('FND',
391: 'FORM_RECORD_CHANGED');
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: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 397: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

393: APP_EXCEPTION.Raise_Exception;
394: ELSE
395: x_msg_data := FND_MESSAGE.Get;
396: END IF;
397: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
398: ROLLBACK TO SAVEPOINT Lock_Row;
399: x_return_status := 'L';
400: x_oracle_error := APP_EXCEPTION.Get_Code;
401: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 400: x_oracle_error := APP_EXCEPTION.Get_Code;

396: END IF;
397: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
398: ROLLBACK TO SAVEPOINT Lock_Row;
399: x_return_status := 'L';
400: x_oracle_error := APP_EXCEPTION.Get_Code;
401: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
402: FND_MESSAGE.SET_NAME('GR',
403: 'GR_ROW_IS_LOCKED');
404: x_msg_data := FND_MESSAGE.Get;

Line 411: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 412: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 419: APP_EXCEPTION.Raise_Exception;

415: FND_MESSAGE.SET_TOKEN('TEXT',
416: l_msg_data,
417: FALSE);
418: IF FND_API.To_Boolean(p_called_by_form) THEN
419: APP_EXCEPTION.Raise_Exception;
420: ELSE
421: x_msg_data := FND_MESSAGE.Get;
422: END IF;
423:

Line 493: APP_EXCEPTION.Raise_Exception;

489: ROLLBACK TO SAVEPOINT Delete_Row;
490: x_return_status := l_return_status;
491: x_oracle_error := l_oracle_error;
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;
494: ELSE
495: x_msg_data := FND_MESSAGE.Get;
496: END IF;
497:

Line 501: x_oracle_error := APP_EXCEPTION.Get_Code;

497:
498: WHEN Row_Missing_Error THEN
499: ROLLBACK TO SAVEPOINT Delete_Row;
500: x_return_status := 'E';
501: x_oracle_error := APP_EXCEPTION.Get_Code;
502: FND_MESSAGE.SET_NAME('GR',
503: 'GR_RECORD_NOT_FOUND');
504: FND_MESSAGE.SET_TOKEN('CODE',
505: p_toxic_species_code,

Line 508: APP_EXCEPTION.Raise_Exception;

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

Line 516: x_oracle_error := APP_EXCEPTION.Get_Code;

512:
513: WHEN OTHERS THEN
514: ROLLBACK TO SAVEPOINT Delete_Row;
515: x_return_status := 'U';
516: x_oracle_error := APP_EXCEPTION.Get_Code;
517: l_msg_data := APP_EXCEPTION.Get_Text;
518: l_msg_data := APP_EXCEPTION.Get_Text;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_UNEXPECTED_ERROR');

Line 517: l_msg_data := APP_EXCEPTION.Get_Text;

513: WHEN OTHERS THEN
514: ROLLBACK TO SAVEPOINT Delete_Row;
515: x_return_status := 'U';
516: x_oracle_error := APP_EXCEPTION.Get_Code;
517: l_msg_data := APP_EXCEPTION.Get_Text;
518: l_msg_data := APP_EXCEPTION.Get_Text;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_UNEXPECTED_ERROR');
521: FND_MESSAGE.SET_TOKEN('TEXT',

Line 518: l_msg_data := APP_EXCEPTION.Get_Text;

514: ROLLBACK TO SAVEPOINT Delete_Row;
515: x_return_status := 'U';
516: x_oracle_error := APP_EXCEPTION.Get_Code;
517: l_msg_data := APP_EXCEPTION.Get_Text;
518: l_msg_data := APP_EXCEPTION.Get_Text;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_UNEXPECTED_ERROR');
521: FND_MESSAGE.SET_TOKEN('TEXT',
522: l_msg_data,

Line 525: APP_EXCEPTION.Raise_Exception;

521: FND_MESSAGE.SET_TOKEN('TEXT',
522: l_msg_data,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;
529:

Line 567: x_oracle_error := APP_EXCEPTION.Get_Code;

563:
564: WHEN OTHERS THEN
565: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
566: x_return_status := 'U';
567: x_oracle_error := APP_EXCEPTION.Get_Code;
568: l_msg_data := APP_EXCEPTION.Get_Text;
569: FND_MESSAGE.SET_NAME('GR',
570: 'GR_UNEXPECTED_ERROR');
571: FND_MESSAGE.SET_TOKEN('TEXT',

Line 568: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 646: APP_EXCEPTION.Raise_Exception;

642: FND_MESSAGE.SET_TOKEN('TABLES',
643: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
644: FALSE);
645: IF FND_API.To_Boolean(p_called_by_form) THEN
646: APP_EXCEPTION.Raise_Exception;
647: ELSE
648: x_msg_data := FND_MESSAGE.Get;
649: END IF;
650: WHEN OTHERS THEN

Line 653: x_oracle_error := APP_EXCEPTION.Get_Code;

649: END IF;
650: WHEN OTHERS THEN
651: ROLLBACK TO SAVEPOINT Check_Integrity;
652: x_return_status := 'U';
653: x_oracle_error := APP_EXCEPTION.Get_Code;
654: l_msg_data := APP_EXCEPTION.Get_Text;
655: FND_MESSAGE.SET_NAME('GR',
656: 'GR_UNEXPECTED_ERROR');
657: FND_MESSAGE.SET_TOKEN('TEXT',

Line 654: l_msg_data := APP_EXCEPTION.Get_Text;

650: WHEN OTHERS THEN
651: ROLLBACK TO SAVEPOINT Check_Integrity;
652: x_return_status := 'U';
653: x_oracle_error := APP_EXCEPTION.Get_Code;
654: l_msg_data := APP_EXCEPTION.Get_Text;
655: FND_MESSAGE.SET_NAME('GR',
656: 'GR_UNEXPECTED_ERROR');
657: FND_MESSAGE.SET_TOKEN('TEXT',
658: l_msg_data,

Line 661: APP_EXCEPTION.Raise_Exception;

657: FND_MESSAGE.SET_TOKEN('TEXT',
658: l_msg_data,
659: FALSE);
660: IF FND_API.To_Boolean(p_called_by_form) THEN
661: APP_EXCEPTION.Raise_Exception;
662: ELSE
663: x_msg_data := FND_MESSAGE.Get;
664: END IF;
665:

Line 701: l_msg_data := APP_EXCEPTION.Get_Text;

697:
698: EXCEPTION
699:
700: WHEN Others THEN
701: l_msg_data := APP_EXCEPTION.Get_Text;
702: FND_MESSAGE.SET_NAME('GR',
703: 'GR_UNEXPECTED_ERROR');
704: FND_MESSAGE.SET_TOKEN('TEXT',
705: l_msg_data,

Line 708: APP_EXCEPTION.Raise_Exception;

704: FND_MESSAGE.SET_TOKEN('TEXT',
705: l_msg_data,
706: FALSE);
707: IF FND_API.To_Boolean(p_called_by_form) THEN
708: APP_EXCEPTION.Raise_Exception;
709: END IF;
710:
711: END Check_Primary_Key;
712: