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 FND_MESSAGE

Line 111: FND_MESSAGE.SET_NAME('GR',

107: WHEN Foreign_Key_Error THEN
108: ROLLBACK TO SAVEPOINT Insert_Row;
109: x_return_status := l_return_status;
110: x_oracle_error := l_oracle_error;
111: FND_MESSAGE.SET_NAME('GR',
112: 'GR_FOREIGN_KEY_ERROR');
113: FND_MESSAGE.SET_TOKEN('TEXT',
114: l_msg_data,
115: FALSE);

Line 113: FND_MESSAGE.SET_TOKEN('TEXT',

109: x_return_status := l_return_status;
110: x_oracle_error := l_oracle_error;
111: FND_MESSAGE.SET_NAME('GR',
112: 'GR_FOREIGN_KEY_ERROR');
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;

Line 119: x_msg_data := FND_MESSAGE.Get;

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

Line 126: FND_MESSAGE.SET_NAME('GR',

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

Line 128: FND_MESSAGE.SET_TOKEN('CODE',

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,
130: FALSE);
131: IF FND_API.To_Boolean(p_called_by_form) THEN
132: APP_EXCEPTION.Raise_Exception;

Line 134: x_msg_data := FND_MESSAGE.Get;

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

Line 141: FND_MESSAGE.SET_NAME('GR',

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

Line 143: FND_MESSAGE.SET_TOKEN('CODE',

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,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;

Line 149: x_msg_data := FND_MESSAGE.Get;

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

Line 157: FND_MESSAGE.SET_NAME('GR',

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

Line 159: FND_MESSAGE.SET_TOKEN('TEXT',

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,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;

Line 165: x_msg_data := FND_MESSAGE.Get;

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:
168: END Insert_Row;
169:

Line 244: FND_MESSAGE.SET_NAME('GR',

240: WHEN Foreign_Key_Error THEN
241: ROLLBACK TO SAVEPOINT Update_Row;
242: x_return_status := l_return_status;
243: x_oracle_error := l_oracle_error;
244: FND_MESSAGE.SET_NAME('GR',
245: 'GR_FOREIGN_KEY_ERROR');
246: FND_MESSAGE.SET_TOKEN('TEXT',
247: l_msg_data,
248: FALSE);

Line 246: FND_MESSAGE.SET_TOKEN('TEXT',

242: x_return_status := l_return_status;
243: x_oracle_error := l_oracle_error;
244: FND_MESSAGE.SET_NAME('GR',
245: 'GR_FOREIGN_KEY_ERROR');
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;

Line 252: x_msg_data := FND_MESSAGE.Get;

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

Line 259: FND_MESSAGE.SET_NAME('GR',

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

Line 261: FND_MESSAGE.SET_TOKEN('CODE',

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,
263: FALSE);
264: IF FND_API.To_Boolean(p_called_by_form) THEN
265: APP_EXCEPTION.Raise_Exception;

Line 267: x_msg_data := FND_MESSAGE.Get;

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

Line 275: FND_MESSAGE.SET_NAME('GR',

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

Line 277: FND_MESSAGE.SET_TOKEN('TEXT',

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,
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: END Update_Row;
287:

Line 358: FND_MESSAGE.SET_NAME('GR',

354:
355: WHEN No_Data_Found_Error THEN
356: ROLLBACK TO SAVEPOINT Lock_Row;
357: x_return_status := 'E';
358: FND_MESSAGE.SET_NAME('GR',
359: 'GR_RECORD_NOT_FOUND');
360: FND_MESSAGE.SET_TOKEN('CODE',
361: p_toxic_effect_code,
362: FALSE);

Line 360: FND_MESSAGE.SET_TOKEN('CODE',

356: ROLLBACK TO SAVEPOINT Lock_Row;
357: x_return_status := 'E';
358: FND_MESSAGE.SET_NAME('GR',
359: 'GR_RECORD_NOT_FOUND');
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;

Line 366: x_msg_data := FND_MESSAGE.Get;

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

Line 372: FND_MESSAGE.SET_NAME('FND',

368:
369: WHEN RECORD_CHANGED_ERROR THEN
370: ROLLBACK TO SAVEPOINT Lock_Row;
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

Line 377: x_msg_data := FND_MESSAGE.Get;

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

Line 384: FND_MESSAGE.SET_NAME('GR',

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;
387: END IF;
388:

Line 386: x_msg_data := FND_MESSAGE.Get;

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;
387: END IF;
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;

Line 394: FND_MESSAGE.SET_NAME('GR',

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

Line 396: FND_MESSAGE.SET_TOKEN('TEXT',

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,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;

Line 402: x_msg_data := FND_MESSAGE.Get;

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

Line 477: x_msg_data := FND_MESSAGE.Get;

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

Line 484: FND_MESSAGE.SET_NAME('GR',

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

Line 486: FND_MESSAGE.SET_TOKEN('CODE',

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,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;

Line 492: x_msg_data := FND_MESSAGE.Get;

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

Line 501: FND_MESSAGE.SET_NAME('GR',

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

Line 503: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 509: x_msg_data := FND_MESSAGE.Get;

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:
512: END Delete_Row;
513:

Line 551: FND_MESSAGE.SET_NAME('GR',

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

Line 553: FND_MESSAGE.SET_TOKEN('TEXT',

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,
555: FALSE);
556: x_msg_data := FND_MESSAGE.Get;
557:

Line 556: x_msg_data := FND_MESSAGE.Get;

552: 'GR_UNEXPECTED_ERROR');
553: FND_MESSAGE.SET_TOKEN('TEXT',
554: l_msg_data,
555: FALSE);
556: x_msg_data := FND_MESSAGE.Get;
557:
558: END Check_Foreign_Keys;
559:
560: PROCEDURE Check_Integrity

Line 619: FND_MESSAGE.SET_NAME('GR',

615: EXCEPTION
616:
617: WHEN INTEGRITY_ERROR THEN
618: x_return_status := 'E';
619: FND_MESSAGE.SET_NAME('GR',
620: 'GR_INTEGRITY_HEADER');
621: FND_MESSAGE.SET_TOKEN('CODE',
622: p_toxic_effect_code,
623: FALSE);

Line 621: FND_MESSAGE.SET_TOKEN('CODE',

617: WHEN INTEGRITY_ERROR THEN
618: x_return_status := 'E';
619: FND_MESSAGE.SET_NAME('GR',
620: 'GR_INTEGRITY_HEADER');
621: FND_MESSAGE.SET_TOKEN('CODE',
622: p_toxic_effect_code,
623: FALSE);
624: FND_MESSAGE.SET_TOKEN('TABLES',
625: l_msg_data,

Line 624: FND_MESSAGE.SET_TOKEN('TABLES',

620: 'GR_INTEGRITY_HEADER');
621: FND_MESSAGE.SET_TOKEN('CODE',
622: p_toxic_effect_code,
623: FALSE);
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;

Line 630: x_msg_data := FND_MESSAGE.Get;

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

Line 637: FND_MESSAGE.SET_NAME('GR',

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

Line 639: FND_MESSAGE.SET_TOKEN('TEXT',

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,
641: FALSE);
642: IF FND_API.To_Boolean(p_called_by_form) THEN
643: APP_EXCEPTION.Raise_Exception;

Line 645: x_msg_data := FND_MESSAGE.Get;

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:
648: END Check_Integrity;
649:

Line 684: FND_MESSAGE.SET_NAME('GR',

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

Line 686: FND_MESSAGE.SET_TOKEN('TEXT',

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,
688: FALSE);
689: IF FND_API.To_Boolean(p_called_by_form) THEN
690: APP_EXCEPTION.Raise_Exception;