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_DOCUMENT_DETAILS_PKG dependencies on FND_MESSAGE

Line 131: FND_MESSAGE.SET_NAME('GR',

127: WHEN Foreign_Key_Error THEN
128: ROLLBACK TO SAVEPOINT Insert_Row;
129: x_return_status := l_return_status;
130: x_oracle_error := l_oracle_error;
131: FND_MESSAGE.SET_NAME('GR',
132: 'GR_FOREIGN_KEY_ERROR');
133: FND_MESSAGE.SET_TOKEN('TEXT',
134: l_msg_data,
135: FALSE);

Line 133: FND_MESSAGE.SET_TOKEN('TEXT',

129: x_return_status := l_return_status;
130: x_oracle_error := l_oracle_error;
131: FND_MESSAGE.SET_NAME('GR',
132: 'GR_FOREIGN_KEY_ERROR');
133: FND_MESSAGE.SET_TOKEN('TEXT',
134: l_msg_data,
135: FALSE);
136: IF FND_API.To_Boolean(p_called_by_form) THEN
137: APP_EXCEPTION.Raise_Exception;

Line 139: x_msg_data := FND_MESSAGE.Get;

135: FALSE);
136: IF FND_API.To_Boolean(p_called_by_form) THEN
137: APP_EXCEPTION.Raise_Exception;
138: ELSE
139: x_msg_data := FND_MESSAGE.Get;
140: END IF;
141:
142: WHEN Label_Exists_Error THEN
143: ROLLBACK TO SAVEPOINT Insert_Row;

Line 146: FND_MESSAGE.SET_NAME('GR',

142: WHEN Label_Exists_Error THEN
143: ROLLBACK TO SAVEPOINT Insert_Row;
144: x_return_status := 'E';
145: x_oracle_error := APP_EXCEPTION.Get_Code;
146: FND_MESSAGE.SET_NAME('GR',
147: 'GR_RECORD_EXISTS');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: p_document_text_id || ' ' || p_text_line_number,
150: FALSE);

Line 148: FND_MESSAGE.SET_TOKEN('CODE',

144: x_return_status := 'E';
145: x_oracle_error := APP_EXCEPTION.Get_Code;
146: FND_MESSAGE.SET_NAME('GR',
147: 'GR_RECORD_EXISTS');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: p_document_text_id || ' ' || p_text_line_number,
150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;

Line 154: x_msg_data := FND_MESSAGE.Get;

150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;
153: ELSE
154: x_msg_data := FND_MESSAGE.Get;
155: END IF;
156:
157: WHEN Row_Missing_Error THEN
158: ROLLBACK TO SAVEPOINT Insert_Row;

Line 161: FND_MESSAGE.SET_NAME('GR',

157: WHEN Row_Missing_Error THEN
158: ROLLBACK TO SAVEPOINT Insert_Row;
159: x_return_status := 'E';
160: x_oracle_error := APP_EXCEPTION.Get_Code;
161: FND_MESSAGE.SET_NAME('GR',
162: 'GR_NO_RECORD_INSERTED');
163: FND_MESSAGE.SET_TOKEN('CODE',
164: p_document_text_id || ' ' || p_text_line_number,
165: FALSE);

Line 163: FND_MESSAGE.SET_TOKEN('CODE',

159: x_return_status := 'E';
160: x_oracle_error := APP_EXCEPTION.Get_Code;
161: FND_MESSAGE.SET_NAME('GR',
162: 'GR_NO_RECORD_INSERTED');
163: FND_MESSAGE.SET_TOKEN('CODE',
164: p_document_text_id || ' ' || p_text_line_number,
165: FALSE);
166: IF FND_API.To_Boolean(p_called_by_form) THEN
167: APP_EXCEPTION.Raise_Exception;

Line 169: x_msg_data := FND_MESSAGE.Get;

165: FALSE);
166: IF FND_API.To_Boolean(p_called_by_form) THEN
167: APP_EXCEPTION.Raise_Exception;
168: ELSE
169: x_msg_data := FND_MESSAGE.Get;
170: END IF;
171:
172: WHEN OTHERS THEN
173: ROLLBACK TO SAVEPOINT Insert_Row;

Line 177: FND_MESSAGE.SET_NAME('GR',

173: ROLLBACK TO SAVEPOINT Insert_Row;
174: x_return_status := 'U';
175: x_oracle_error := APP_EXCEPTION.Get_Code;
176: l_msg_data := APP_EXCEPTION.Get_Text;
177: FND_MESSAGE.SET_NAME('GR',
178: 'GR_UNEXPECTED_ERROR');
179: FND_MESSAGE.SET_TOKEN('TEXT',
180: l_msg_data,
181: FALSE);

Line 179: FND_MESSAGE.SET_TOKEN('TEXT',

175: x_oracle_error := APP_EXCEPTION.Get_Code;
176: l_msg_data := APP_EXCEPTION.Get_Text;
177: FND_MESSAGE.SET_NAME('GR',
178: 'GR_UNEXPECTED_ERROR');
179: FND_MESSAGE.SET_TOKEN('TEXT',
180: l_msg_data,
181: FALSE);
182: IF FND_API.To_Boolean(p_called_by_form) THEN
183: APP_EXCEPTION.Raise_Exception;

Line 185: x_msg_data := FND_MESSAGE.Get;

181: FALSE);
182: IF FND_API.To_Boolean(p_called_by_form) THEN
183: APP_EXCEPTION.Raise_Exception;
184: ELSE
185: x_msg_data := FND_MESSAGE.Get;
186: END IF;
187:
188: END Insert_Row;
189:

Line 279: FND_MESSAGE.SET_NAME('GR',

275: WHEN Foreign_Key_Error THEN
276: ROLLBACK TO SAVEPOINT Update_Row;
277: x_return_status := l_return_status;
278: x_oracle_error := l_oracle_error;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_FOREIGN_KEY_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_data,
283: FALSE);

Line 281: FND_MESSAGE.SET_TOKEN('TEXT',

277: x_return_status := l_return_status;
278: x_oracle_error := l_oracle_error;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_FOREIGN_KEY_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_data,
283: FALSE);
284: IF FND_API.To_Boolean(p_called_by_form) THEN
285: APP_EXCEPTION.Raise_Exception;

Line 287: x_msg_data := FND_MESSAGE.Get;

283: FALSE);
284: IF FND_API.To_Boolean(p_called_by_form) THEN
285: APP_EXCEPTION.Raise_Exception;
286: ELSE
287: x_msg_data := FND_MESSAGE.Get;
288: END IF;
289:
290: WHEN Row_Missing_Error THEN
291: ROLLBACK TO SAVEPOINT Update_Row;

Line 294: FND_MESSAGE.SET_NAME('GR',

290: WHEN Row_Missing_Error THEN
291: ROLLBACK TO SAVEPOINT Update_Row;
292: x_return_status := 'E';
293: x_oracle_error := APP_EXCEPTION.Get_Code;
294: FND_MESSAGE.SET_NAME('GR',
295: 'GR_NO_RECORD_INSERTED');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: p_document_text_id || ' ' || p_text_line_number,
298: FALSE);

Line 296: FND_MESSAGE.SET_TOKEN('CODE',

292: x_return_status := 'E';
293: x_oracle_error := APP_EXCEPTION.Get_Code;
294: FND_MESSAGE.SET_NAME('GR',
295: 'GR_NO_RECORD_INSERTED');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: p_document_text_id || ' ' || p_text_line_number,
298: FALSE);
299: IF FND_API.To_Boolean(p_called_by_form) THEN
300: APP_EXCEPTION.Raise_Exception;

Line 302: x_msg_data := FND_MESSAGE.Get;

298: FALSE);
299: IF FND_API.To_Boolean(p_called_by_form) THEN
300: APP_EXCEPTION.Raise_Exception;
301: ELSE
302: x_msg_data := FND_MESSAGE.Get;
303: END IF;
304:
305: WHEN OTHERS THEN
306: ROLLBACK TO SAVEPOINT Update_Row;

Line 310: FND_MESSAGE.SET_NAME('GR',

306: ROLLBACK TO SAVEPOINT Update_Row;
307: x_return_status := 'U';
308: x_oracle_error := APP_EXCEPTION.Get_Code;
309: l_msg_data := APP_EXCEPTION.Get_Text;
310: FND_MESSAGE.SET_NAME('GR',
311: 'GR_UNEXPECTED_ERROR');
312: FND_MESSAGE.SET_TOKEN('TEXT',
313: l_msg_data,
314: FALSE);

Line 312: FND_MESSAGE.SET_TOKEN('TEXT',

308: x_oracle_error := APP_EXCEPTION.Get_Code;
309: l_msg_data := APP_EXCEPTION.Get_Text;
310: FND_MESSAGE.SET_NAME('GR',
311: 'GR_UNEXPECTED_ERROR');
312: FND_MESSAGE.SET_TOKEN('TEXT',
313: l_msg_data,
314: FALSE);
315: IF FND_API.To_Boolean(p_called_by_form) THEN
316: APP_EXCEPTION.Raise_Exception;

Line 318: x_msg_data := FND_MESSAGE.Get;

314: FALSE);
315: IF FND_API.To_Boolean(p_called_by_form) THEN
316: APP_EXCEPTION.Raise_Exception;
317: ELSE
318: x_msg_data := FND_MESSAGE.Get;
319: END IF;
320:
321: END Update_Row;
322:

Line 396: FND_MESSAGE.SET_NAME('GR',

392:
393: WHEN No_Data_Found_Error THEN
394: ROLLBACK TO SAVEPOINT Lock_Row;
395: x_return_status := 'E';
396: FND_MESSAGE.SET_NAME('GR',
397: 'GR_RECORD_NOT_FOUND');
398: FND_MESSAGE.SET_TOKEN('CODE',
399: p_document_text_id || ' ' || p_text_line_number,
400: FALSE);

Line 398: FND_MESSAGE.SET_TOKEN('CODE',

394: ROLLBACK TO SAVEPOINT Lock_Row;
395: x_return_status := 'E';
396: FND_MESSAGE.SET_NAME('GR',
397: 'GR_RECORD_NOT_FOUND');
398: FND_MESSAGE.SET_TOKEN('CODE',
399: p_document_text_id || ' ' || p_text_line_number,
400: FALSE);
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;

Line 404: x_msg_data := FND_MESSAGE.Get;

400: FALSE);
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE
404: x_msg_data := FND_MESSAGE.Get;
405: END IF;
406:
407: WHEN Row_Already_Locked_Error THEN
408: ROLLBACK TO SAVEPOINT Lock_Row;

Line 411: FND_MESSAGE.SET_NAME('GR',

407: WHEN Row_Already_Locked_Error THEN
408: ROLLBACK TO SAVEPOINT Lock_Row;
409: x_return_status := 'E';
410: x_oracle_error := APP_EXCEPTION.Get_Code;
411: FND_MESSAGE.SET_NAME('GR',
412: 'GR_ROW_IS_LOCKED');
413: IF FND_API.To_Boolean(p_called_by_form) THEN
414: APP_EXCEPTION.Raise_Exception;
415: ELSE

Line 416: x_msg_data := FND_MESSAGE.Get;

412: 'GR_ROW_IS_LOCKED');
413: IF FND_API.To_Boolean(p_called_by_form) THEN
414: APP_EXCEPTION.Raise_Exception;
415: ELSE
416: x_msg_data := FND_MESSAGE.Get;
417: END IF;
418:
419: WHEN OTHERS THEN
420: ROLLBACK TO SAVEPOINT Lock_Row;

Line 424: FND_MESSAGE.SET_NAME('GR',

420: ROLLBACK TO SAVEPOINT Lock_Row;
421: x_return_status := 'U';
422: x_oracle_error := APP_EXCEPTION.Get_Code;
423: l_msg_data := APP_EXCEPTION.Get_Text;
424: FND_MESSAGE.SET_NAME('GR',
425: 'GR_UNEXPECTED_ERROR');
426: FND_MESSAGE.SET_TOKEN('TEXT',
427: l_msg_data,
428: FALSE);

Line 426: FND_MESSAGE.SET_TOKEN('TEXT',

422: x_oracle_error := APP_EXCEPTION.Get_Code;
423: l_msg_data := APP_EXCEPTION.Get_Text;
424: FND_MESSAGE.SET_NAME('GR',
425: 'GR_UNEXPECTED_ERROR');
426: FND_MESSAGE.SET_TOKEN('TEXT',
427: l_msg_data,
428: FALSE);
429: IF FND_API.To_Boolean(p_called_by_form) THEN
430: APP_EXCEPTION.Raise_Exception;

Line 432: x_msg_data := FND_MESSAGE.Get;

428: FALSE);
429: IF FND_API.To_Boolean(p_called_by_form) THEN
430: APP_EXCEPTION.Raise_Exception;
431: ELSE
432: x_msg_data := FND_MESSAGE.Get;
433: END IF;
434:
435: END Lock_Row;
436:

Line 519: x_msg_data := FND_MESSAGE.Get;

515: x_oracle_error := l_oracle_error;
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;
518: ELSE
519: x_msg_data := FND_MESSAGE.Get;
520: END IF;
521:
522: WHEN Row_Missing_Error THEN
523: ROLLBACK TO SAVEPOINT Delete_Row;

Line 526: FND_MESSAGE.SET_NAME('GR',

522: WHEN Row_Missing_Error THEN
523: ROLLBACK TO SAVEPOINT Delete_Row;
524: x_return_status := 'E';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: FND_MESSAGE.SET_NAME('GR',
527: 'GR_RECORD_NOT_FOUND');
528: FND_MESSAGE.SET_TOKEN('CODE',
529: p_document_text_id || ' ' || p_text_line_number,
530: FALSE);

Line 528: FND_MESSAGE.SET_TOKEN('CODE',

524: x_return_status := 'E';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: FND_MESSAGE.SET_NAME('GR',
527: 'GR_RECORD_NOT_FOUND');
528: FND_MESSAGE.SET_TOKEN('CODE',
529: p_document_text_id || ' ' || p_text_line_number,
530: FALSE);
531: IF FND_API.To_Boolean(p_called_by_form) THEN
532: APP_EXCEPTION.Raise_Exception;

Line 534: x_msg_data := FND_MESSAGE.Get;

530: FALSE);
531: IF FND_API.To_Boolean(p_called_by_form) THEN
532: APP_EXCEPTION.Raise_Exception;
533: ELSE
534: x_msg_data := FND_MESSAGE.Get;
535: END IF;
536:
537: WHEN OTHERS THEN
538: ROLLBACK TO SAVEPOINT Delete_Row;

Line 543: FND_MESSAGE.SET_NAME('GR',

539: x_return_status := 'U';
540: x_oracle_error := APP_EXCEPTION.Get_Code;
541: l_msg_data := APP_EXCEPTION.Get_Text;
542: l_msg_data := APP_EXCEPTION.Get_Text;
543: FND_MESSAGE.SET_NAME('GR',
544: 'GR_UNEXPECTED_ERROR');
545: FND_MESSAGE.SET_TOKEN('TEXT',
546: l_msg_data,
547: FALSE);

Line 545: FND_MESSAGE.SET_TOKEN('TEXT',

541: l_msg_data := APP_EXCEPTION.Get_Text;
542: l_msg_data := APP_EXCEPTION.Get_Text;
543: FND_MESSAGE.SET_NAME('GR',
544: 'GR_UNEXPECTED_ERROR');
545: FND_MESSAGE.SET_TOKEN('TEXT',
546: l_msg_data,
547: FALSE);
548: IF FND_API.To_Boolean(p_called_by_form) THEN
549: APP_EXCEPTION.Raise_Exception;

Line 551: x_msg_data := FND_MESSAGE.Get;

547: FALSE);
548: IF FND_API.To_Boolean(p_called_by_form) THEN
549: APP_EXCEPTION.Raise_Exception;
550: ELSE
551: x_msg_data := FND_MESSAGE.Get;
552: END IF;
553:
554: END Delete_Row;
555:

Line 601: FND_MESSAGE.SET_NAME('GR',

597: ROLLBACK TO SAVEPOINT Delete_Rows;
598: x_return_status := 'U';
599: x_oracle_error := APP_EXCEPTION.Get_Code;
600: l_msg_data := APP_EXCEPTION.Get_Text;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_UNEXPECTED_ERROR');
603: FND_MESSAGE.SET_TOKEN('TEXT',
604: l_msg_token,
605: FALSE);

Line 603: FND_MESSAGE.SET_TOKEN('TEXT',

599: x_oracle_error := APP_EXCEPTION.Get_Code;
600: l_msg_data := APP_EXCEPTION.Get_Text;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_UNEXPECTED_ERROR');
603: FND_MESSAGE.SET_TOKEN('TEXT',
604: l_msg_token,
605: FALSE);
606: IF FND_API.To_Boolean(p_called_by_form) THEN
607: APP_EXCEPTION.Raise_Exception;

Line 609: x_msg_data := FND_MESSAGE.Get;

605: FALSE);
606: IF FND_API.To_Boolean(p_called_by_form) THEN
607: APP_EXCEPTION.Raise_Exception;
608: ELSE
609: x_msg_data := FND_MESSAGE.Get;
610: END IF;
611:
612: END Delete_Rows;
613:

Line 658: FND_MESSAGE.SET_NAME('GR',

654: l_rowid,
655: l_key_exists);
656: IF NOT FND_API.To_Boolean(l_key_exists) THEN
657: x_return_status := 'E';
658: FND_MESSAGE.SET_NAME('GR',
659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_text_id,
662: FALSE);

Line 660: FND_MESSAGE.SET_TOKEN('CODE',

656: IF NOT FND_API.To_Boolean(l_key_exists) THEN
657: x_return_status := 'E';
658: FND_MESSAGE.SET_NAME('GR',
659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_text_id,
662: FALSE);
663: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
664: END IF;

Line 663: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_text_id,
662: FALSE);
663: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
664: END IF;
665:
666: /* Handle any error routines. */
667:

Line 679: FND_MESSAGE.SET_NAME('GR',

675: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
676: x_return_status := 'U';
677: x_oracle_error := APP_EXCEPTION.Get_Code;
678: l_msg_data := APP_EXCEPTION.Get_Text;
679: FND_MESSAGE.SET_NAME('GR',
680: 'GR_UNEXPECTED_ERROR');
681: FND_MESSAGE.SET_TOKEN('TEXT',
682: l_msg_data,
683: FALSE);

Line 681: FND_MESSAGE.SET_TOKEN('TEXT',

677: x_oracle_error := APP_EXCEPTION.Get_Code;
678: l_msg_data := APP_EXCEPTION.Get_Text;
679: FND_MESSAGE.SET_NAME('GR',
680: 'GR_UNEXPECTED_ERROR');
681: FND_MESSAGE.SET_TOKEN('TEXT',
682: l_msg_data,
683: FALSE);
684: x_msg_data := FND_MESSAGE.Get;
685:

Line 684: x_msg_data := FND_MESSAGE.Get;

680: 'GR_UNEXPECTED_ERROR');
681: FND_MESSAGE.SET_TOKEN('TEXT',
682: l_msg_data,
683: FALSE);
684: x_msg_data := FND_MESSAGE.Get;
685:
686: END Check_Foreign_Keys;
687:
688: PROCEDURE Check_Integrity

Line 742: FND_MESSAGE.SET_NAME('GR',

738: ROLLBACK TO SAVEPOINT Check_Integrity;
739: x_return_status := 'U';
740: x_oracle_error := APP_EXCEPTION.Get_Code;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);

Line 744: FND_MESSAGE.SET_TOKEN('TEXT',

740: x_oracle_error := APP_EXCEPTION.Get_Code;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;

Line 750: x_msg_data := FND_MESSAGE.Get;

746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: ELSE
750: x_msg_data := FND_MESSAGE.Get;
751: END IF;
752:
753: END Check_Integrity;
754:

Line 801: FND_MESSAGE.SET_NAME('GR',

797: EXCEPTION
798:
799: WHEN Others THEN
800: l_msg_data := APP_EXCEPTION.Get_Text;
801: FND_MESSAGE.SET_NAME('GR',
802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);

Line 803: FND_MESSAGE.SET_TOKEN('TEXT',

799: WHEN Others THEN
800: l_msg_data := APP_EXCEPTION.Get_Text;
801: FND_MESSAGE.SET_NAME('GR',
802: 'GR_UNEXPECTED_ERROR');
803: FND_MESSAGE.SET_TOKEN('TEXT',
804: l_msg_data,
805: FALSE);
806: IF FND_API.To_Boolean(p_called_by_form) THEN
807: APP_EXCEPTION.Raise_Exception;