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 FND_MESSAGE

Line 120: FND_MESSAGE.SET_NAME('GR',

116: WHEN Foreign_Key_Error THEN
117: ROLLBACK TO SAVEPOINT Insert_Row;
118: x_return_status := l_return_status;
119: x_oracle_error := l_oracle_error;
120: FND_MESSAGE.SET_NAME('GR',
121: 'GR_FOREIGN_KEY_ERROR');
122: FND_MESSAGE.SET_TOKEN('TEXT',
123: l_msg_data,
124: FALSE);

Line 122: FND_MESSAGE.SET_TOKEN('TEXT',

118: x_return_status := l_return_status;
119: x_oracle_error := l_oracle_error;
120: FND_MESSAGE.SET_NAME('GR',
121: 'GR_FOREIGN_KEY_ERROR');
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;

Line 128: x_msg_data := FND_MESSAGE.Get;

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:
131: WHEN Item_Exists_Error THEN
132: ROLLBACK TO SAVEPOINT Insert_Row;

Line 135: FND_MESSAGE.SET_NAME('GR',

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,
139: FALSE);

Line 137: FND_MESSAGE.SET_TOKEN('CODE',

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,
139: FALSE);
140: IF FND_API.To_Boolean(p_called_by_form) THEN
141: APP_EXCEPTION.Raise_Exception;

Line 143: x_msg_data := FND_MESSAGE.Get;

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:
146: WHEN Row_Missing_Error THEN
147: ROLLBACK TO SAVEPOINT Insert_Row;

Line 150: FND_MESSAGE.SET_NAME('GR',

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,
154: FALSE);

Line 152: FND_MESSAGE.SET_TOKEN('CODE',

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,
154: FALSE);
155: IF FND_API.To_Boolean(p_called_by_form) THEN
156: APP_EXCEPTION.Raise_Exception;

Line 158: x_msg_data := FND_MESSAGE.Get;

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:
161: WHEN OTHERS THEN
162: ROLLBACK TO SAVEPOINT Insert_Row;

Line 166: FND_MESSAGE.SET_NAME('GR',

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,
170: FALSE);

Line 168: FND_MESSAGE.SET_TOKEN('TEXT',

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,
170: FALSE);
171: IF FND_API.To_Boolean(p_called_by_form) THEN
172: APP_EXCEPTION.Raise_Exception;

Line 174: x_msg_data := FND_MESSAGE.Get;

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:
177: END Insert_Row;
178:

Line 260: FND_MESSAGE.SET_NAME('GR',

256: WHEN Foreign_Key_Error THEN
257: ROLLBACK TO SAVEPOINT Update_Row;
258: x_return_status := l_return_status;
259: x_oracle_error := l_oracle_error;
260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_FOREIGN_KEY_ERROR');
262: FND_MESSAGE.SET_TOKEN('TEXT',
263: l_msg_data,
264: FALSE);

Line 262: FND_MESSAGE.SET_TOKEN('TEXT',

258: x_return_status := l_return_status;
259: x_oracle_error := l_oracle_error;
260: FND_MESSAGE.SET_NAME('GR',
261: 'GR_FOREIGN_KEY_ERROR');
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;

Line 268: x_msg_data := FND_MESSAGE.Get;

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:
271: WHEN Row_Missing_Error THEN
272: ROLLBACK TO SAVEPOINT Update_Row;

Line 275: FND_MESSAGE.SET_NAME('GR',

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,
279: FALSE);

Line 277: FND_MESSAGE.SET_TOKEN('CODE',

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,
279: FALSE);
280: IF FND_API.To_Boolean(p_called_by_form) THEN
281: APP_EXCEPTION.Raise_Exception;

Line 283: x_msg_data := FND_MESSAGE.Get;

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:
286: WHEN OTHERS THEN
287: ROLLBACK TO SAVEPOINT Update_Row;

Line 291: FND_MESSAGE.SET_NAME('GR',

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,
295: FALSE);

Line 293: FND_MESSAGE.SET_TOKEN('TEXT',

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,
295: FALSE);
296: IF FND_API.To_Boolean(p_called_by_form) THEN
297: APP_EXCEPTION.Raise_Exception;

Line 299: x_msg_data := FND_MESSAGE.Get;

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:
302: END Update_Row;
303:

Line 376: FND_MESSAGE.SET_NAME('GR',

372:
373: WHEN No_Data_Found_Error THEN
374: ROLLBACK TO SAVEPOINT Lock_Row;
375: x_return_status := 'E';
376: FND_MESSAGE.SET_NAME('GR',
377: 'GR_RECORD_NOT_FOUND');
378: FND_MESSAGE.SET_TOKEN('CODE',
379: p_toxic_species_code,
380: FALSE);

Line 378: FND_MESSAGE.SET_TOKEN('CODE',

374: ROLLBACK TO SAVEPOINT Lock_Row;
375: x_return_status := 'E';
376: FND_MESSAGE.SET_NAME('GR',
377: 'GR_RECORD_NOT_FOUND');
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;

Line 384: x_msg_data := FND_MESSAGE.Get;

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:
387: WHEN RECORD_CHANGED_ERROR THEN
388: ROLLBACK TO SAVEPOINT Lock_Row;

Line 390: FND_MESSAGE.SET_NAME('FND',

386:
387: WHEN RECORD_CHANGED_ERROR THEN
388: ROLLBACK TO SAVEPOINT Lock_Row;
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

Line 395: x_msg_data := FND_MESSAGE.Get;

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
398: ROLLBACK TO SAVEPOINT Lock_Row;
399: x_return_status := 'L';

Line 402: FND_MESSAGE.SET_NAME('GR',

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;
405: END IF;
406:

Line 404: x_msg_data := FND_MESSAGE.Get;

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;
405: END IF;
406:
407:
408: WHEN OTHERS THEN

Line 413: FND_MESSAGE.SET_NAME('GR',

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,
417: FALSE);

Line 415: FND_MESSAGE.SET_TOKEN('TEXT',

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,
417: FALSE);
418: IF FND_API.To_Boolean(p_called_by_form) THEN
419: APP_EXCEPTION.Raise_Exception;

Line 421: x_msg_data := FND_MESSAGE.Get;

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:
424: END Lock_Row;
425:

Line 495: x_msg_data := FND_MESSAGE.Get;

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:
498: WHEN Row_Missing_Error THEN
499: ROLLBACK TO SAVEPOINT Delete_Row;

Line 502: FND_MESSAGE.SET_NAME('GR',

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,
506: FALSE);

Line 504: FND_MESSAGE.SET_TOKEN('CODE',

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,
506: FALSE);
507: IF FND_API.To_Boolean(p_called_by_form) THEN
508: APP_EXCEPTION.Raise_Exception;

Line 510: x_msg_data := FND_MESSAGE.Get;

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:
513: WHEN OTHERS THEN
514: ROLLBACK TO SAVEPOINT Delete_Row;

Line 519: FND_MESSAGE.SET_NAME('GR',

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,
523: FALSE);

Line 521: FND_MESSAGE.SET_TOKEN('TEXT',

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,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;

Line 527: x_msg_data := FND_MESSAGE.Get;

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:
530: END Delete_Row;
531:

Line 569: FND_MESSAGE.SET_NAME('GR',

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,
573: FALSE);

Line 571: FND_MESSAGE.SET_TOKEN('TEXT',

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,
573: FALSE);
574: x_msg_data := FND_MESSAGE.Get;
575:

Line 574: x_msg_data := FND_MESSAGE.Get;

570: 'GR_UNEXPECTED_ERROR');
571: FND_MESSAGE.SET_TOKEN('TEXT',
572: l_msg_data,
573: FALSE);
574: x_msg_data := FND_MESSAGE.Get;
575:
576: END Check_Foreign_Keys;
577:
578: PROCEDURE Check_Integrity

Line 637: FND_MESSAGE.SET_NAME('GR',

633: EXCEPTION
634:
635: WHEN INTEGRITY_ERROR THEN
636: x_return_status := 'E';
637: FND_MESSAGE.SET_NAME('GR',
638: 'GR_INTEGRITY_HEADER');
639: FND_MESSAGE.SET_TOKEN('CODE',
640: p_toxic_species_code,
641: FALSE);

Line 639: FND_MESSAGE.SET_TOKEN('CODE',

635: WHEN INTEGRITY_ERROR THEN
636: x_return_status := 'E';
637: FND_MESSAGE.SET_NAME('GR',
638: 'GR_INTEGRITY_HEADER');
639: FND_MESSAGE.SET_TOKEN('CODE',
640: p_toxic_species_code,
641: FALSE);
642: FND_MESSAGE.SET_TOKEN('TABLES',
643: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 642: FND_MESSAGE.SET_TOKEN('TABLES',

638: 'GR_INTEGRITY_HEADER');
639: FND_MESSAGE.SET_TOKEN('CODE',
640: p_toxic_species_code,
641: FALSE);
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;

Line 648: x_msg_data := FND_MESSAGE.Get;

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
651: ROLLBACK TO SAVEPOINT Check_Integrity;
652: x_return_status := 'U';

Line 655: FND_MESSAGE.SET_NAME('GR',

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,
659: FALSE);

Line 657: FND_MESSAGE.SET_TOKEN('TEXT',

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,
659: FALSE);
660: IF FND_API.To_Boolean(p_called_by_form) THEN
661: APP_EXCEPTION.Raise_Exception;

Line 663: x_msg_data := FND_MESSAGE.Get;

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:
666: END Check_Integrity;
667:

Line 702: FND_MESSAGE.SET_NAME('GR',

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,
706: FALSE);

Line 704: FND_MESSAGE.SET_TOKEN('TEXT',

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,
706: FALSE);
707: IF FND_API.To_Boolean(p_called_by_form) THEN
708: APP_EXCEPTION.Raise_Exception;