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 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_route_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_route_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_route_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_route_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 245: FND_MESSAGE.SET_NAME('GR',

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

Line 247: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 253: x_msg_data := FND_MESSAGE.Get;

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

Line 260: FND_MESSAGE.SET_NAME('GR',

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

Line 262: FND_MESSAGE.SET_TOKEN('CODE',

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,
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 OTHERS THEN
272: ROLLBACK TO SAVEPOINT Update_Row;

Line 276: FND_MESSAGE.SET_NAME('GR',

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

Line 278: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 284: x_msg_data := FND_MESSAGE.Get;

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

Line 359: FND_MESSAGE.SET_NAME('GR',

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

Line 361: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 367: x_msg_data := FND_MESSAGE.Get;

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
370: ROLLBACK TO SAVEPOINT Lock_Row;
371: X_return_status := 'E';

Line 372: FND_MESSAGE.SET_NAME('FND',

368: END IF;
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 476: x_msg_data := FND_MESSAGE.Get;

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

Line 483: FND_MESSAGE.SET_NAME('GR',

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

Line 485: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 491: x_msg_data := FND_MESSAGE.Get;

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

Line 500: FND_MESSAGE.SET_NAME('GR',

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

Line 502: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 508: x_msg_data := FND_MESSAGE.Get;

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

Line 550: FND_MESSAGE.SET_NAME('GR',

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

Line 552: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 555: x_msg_data := FND_MESSAGE.Get;

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

Line 620: FND_MESSAGE.SET_NAME('GR',

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

Line 622: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 625: FND_MESSAGE.SET_TOKEN('TABLES',

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

Line 631: x_msg_data := FND_MESSAGE.Get;

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

Line 638: FND_MESSAGE.SET_NAME('GR',

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

Line 640: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 646: x_msg_data := FND_MESSAGE.Get;

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;
649:
650: PROCEDURE Check_Primary_Key

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;