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

Line 133: FND_MESSAGE.SET_NAME('GR',

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

Line 135: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 141: x_msg_data := FND_MESSAGE.Get;

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

Line 148: FND_MESSAGE.SET_NAME('GR',

144: WHEN Item_Exists_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
152: FALSE);

Line 150: FND_MESSAGE.SET_TOKEN('CODE',

146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_RECORD_EXISTS');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;

Line 156: x_msg_data := FND_MESSAGE.Get;

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

Line 163: FND_MESSAGE.SET_NAME('GR',

159: WHEN Row_Missing_Error THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
167: FALSE);

Line 165: FND_MESSAGE.SET_TOKEN('CODE',

161: x_return_status := 'E';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
167: FALSE);
168: x_msg_data := FND_MESSAGE.Get;
169: IF FND_API.To_Boolean(p_called_by_form) THEN

Line 168: x_msg_data := FND_MESSAGE.Get;

164: 'GR_NO_RECORD_INSERTED');
165: FND_MESSAGE.SET_TOKEN('CODE',
166: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
167: FALSE);
168: x_msg_data := FND_MESSAGE.Get;
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;
171: ELSE
172: x_msg_data := FND_MESSAGE.Get;

Line 172: x_msg_data := FND_MESSAGE.Get;

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

Line 180: FND_MESSAGE.SET_NAME('GR',

176: ROLLBACK TO SAVEPOINT Insert_Row;
177: x_return_status := 'U';
178: x_oracle_error := APP_EXCEPTION.Get_Code;
179: l_msg_data := sqlerrm;
180: FND_MESSAGE.SET_NAME('GR',
181: 'GR_UNEXPECTED_ERROR');
182: FND_MESSAGE.SET_TOKEN('TEXT',
183: l_msg_data,
184: FALSE);

Line 182: FND_MESSAGE.SET_TOKEN('TEXT',

178: x_oracle_error := APP_EXCEPTION.Get_Code;
179: l_msg_data := sqlerrm;
180: FND_MESSAGE.SET_NAME('GR',
181: 'GR_UNEXPECTED_ERROR');
182: FND_MESSAGE.SET_TOKEN('TEXT',
183: l_msg_data,
184: FALSE);
185: IF FND_API.To_Boolean(p_called_by_form) THEN
186: APP_EXCEPTION.Raise_Exception;

Line 188: x_msg_data := FND_MESSAGE.Get;

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

Line 273: FND_MESSAGE.SET_NAME('GR',

269: WHEN Foreign_Key_Error THEN
270: ROLLBACK TO SAVEPOINT Update_Row;
271: x_return_status := l_return_status;
272: x_oracle_error := l_oracle_error;
273: FND_MESSAGE.SET_NAME('GR',
274: 'GR_FOREIGN_KEY_ERROR');
275: FND_MESSAGE.SET_TOKEN('TEXT',
276: l_msg_data,
277: FALSE);

Line 275: FND_MESSAGE.SET_TOKEN('TEXT',

271: x_return_status := l_return_status;
272: x_oracle_error := l_oracle_error;
273: FND_MESSAGE.SET_NAME('GR',
274: 'GR_FOREIGN_KEY_ERROR');
275: FND_MESSAGE.SET_TOKEN('TEXT',
276: l_msg_data,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;

Line 281: x_msg_data := FND_MESSAGE.Get;

277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;
280: ELSE
281: x_msg_data := FND_MESSAGE.Get;
282: END IF;
283:
284: WHEN Row_Missing_Error THEN
285: ROLLBACK TO SAVEPOINT Update_Row;

Line 288: FND_MESSAGE.SET_NAME('GR',

284: WHEN Row_Missing_Error THEN
285: ROLLBACK TO SAVEPOINT Update_Row;
286: x_return_status := 'E';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_NO_RECORD_INSERTED');
290: FND_MESSAGE.SET_TOKEN('CODE',
291: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
292: FALSE);

Line 290: FND_MESSAGE.SET_TOKEN('CODE',

286: x_return_status := 'E';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_NO_RECORD_INSERTED');
290: FND_MESSAGE.SET_TOKEN('CODE',
291: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;

Line 296: x_msg_data := FND_MESSAGE.Get;

292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;
295: ELSE
296: x_msg_data := FND_MESSAGE.Get;
297: END IF;
298:
299: WHEN OTHERS THEN
300: ROLLBACK TO SAVEPOINT Update_Row;

Line 304: FND_MESSAGE.SET_NAME('GR',

300: ROLLBACK TO SAVEPOINT Update_Row;
301: x_return_status := 'U';
302: x_oracle_error := APP_EXCEPTION.Get_Code;
303: l_msg_data := sqlerrm;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_UNEXPECTED_ERROR');
306: FND_MESSAGE.SET_TOKEN('TEXT',
307: l_msg_data,
308: FALSE);

Line 306: FND_MESSAGE.SET_TOKEN('TEXT',

302: x_oracle_error := APP_EXCEPTION.Get_Code;
303: l_msg_data := sqlerrm;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_UNEXPECTED_ERROR');
306: FND_MESSAGE.SET_TOKEN('TEXT',
307: l_msg_data,
308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;

Line 312: x_msg_data := FND_MESSAGE.Get;

308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;
311: ELSE
312: x_msg_data := FND_MESSAGE.Get;
313: END IF;
314:
315: END Update_Row;
316:

Line 392: FND_MESSAGE.SET_NAME('GR',

388:
389: WHEN No_Data_Found_Error THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'E';
392: FND_MESSAGE.SET_NAME('GR',
393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
396: FALSE);

Line 394: FND_MESSAGE.SET_TOKEN('CODE',

390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'E';
392: FND_MESSAGE.SET_NAME('GR',
393: 'GR_RECORD_NOT_FOUND');
394: FND_MESSAGE.SET_TOKEN('CODE',
395: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;

Line 400: x_msg_data := FND_MESSAGE.Get;

396: FALSE);
397: IF FND_API.To_Boolean(p_called_by_form) THEN
398: APP_EXCEPTION.Raise_Exception;
399: ELSE
400: x_msg_data := FND_MESSAGE.Get;
401: END IF;
402: WHEN RECORD_CHANGED_ERROR THEN
403: ROLLBACK TO SAVEPOINT Lock_Row;
404: X_return_status := 'E';

Line 405: FND_MESSAGE.SET_NAME('FND',

401: END IF;
402: WHEN RECORD_CHANGED_ERROR THEN
403: ROLLBACK TO SAVEPOINT Lock_Row;
404: X_return_status := 'E';
405: FND_MESSAGE.SET_NAME('FND',
406: 'FORM_RECORD_CHANGED');
407: IF FND_API.To_Boolean(p_called_by_form) THEN
408: APP_EXCEPTION.Raise_Exception;
409: ELSE

Line 410: x_msg_data := FND_MESSAGE.Get;

406: 'FORM_RECORD_CHANGED');
407: IF FND_API.To_Boolean(p_called_by_form) THEN
408: APP_EXCEPTION.Raise_Exception;
409: ELSE
410: x_msg_data := FND_MESSAGE.Get;
411: END IF;
412: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
413: ROLLBACK TO SAVEPOINT Lock_Row;
414: x_return_status := 'L';

Line 417: FND_MESSAGE.SET_NAME('GR',

413: ROLLBACK TO SAVEPOINT Lock_Row;
414: x_return_status := 'L';
415: x_oracle_error := APP_EXCEPTION.Get_Code;
416: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
417: FND_MESSAGE.SET_NAME('GR',
418: 'GR_ROW_IS_LOCKED');
419: x_msg_data := FND_MESSAGE.Get;
420: END IF;
421: WHEN OTHERS THEN

Line 419: x_msg_data := FND_MESSAGE.Get;

415: x_oracle_error := APP_EXCEPTION.Get_Code;
416: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
417: FND_MESSAGE.SET_NAME('GR',
418: 'GR_ROW_IS_LOCKED');
419: x_msg_data := FND_MESSAGE.Get;
420: END IF;
421: WHEN OTHERS THEN
422: ROLLBACK TO SAVEPOINT Lock_Row;
423: x_return_status := 'U';

Line 426: FND_MESSAGE.SET_NAME('GR',

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

Line 428: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 434: x_msg_data := FND_MESSAGE.Get;

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

Line 511: x_msg_data := FND_MESSAGE.Get;

507: x_oracle_error := l_oracle_error;
508: IF FND_API.To_Boolean(p_called_by_form) THEN
509: APP_EXCEPTION.Raise_Exception;
510: ELSE
511: x_msg_data := FND_MESSAGE.Get;
512: END IF;
513:
514: WHEN Row_Missing_Error THEN
515: ROLLBACK TO SAVEPOINT Delete_Row;

Line 518: FND_MESSAGE.SET_NAME('GR',

514: WHEN Row_Missing_Error THEN
515: ROLLBACK TO SAVEPOINT Delete_Row;
516: x_return_status := 'E';
517: x_oracle_error := APP_EXCEPTION.Get_Code;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
522: FALSE);

Line 520: FND_MESSAGE.SET_TOKEN('CODE',

516: x_return_status := 'E';
517: x_oracle_error := APP_EXCEPTION.Get_Code;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;

Line 526: x_msg_data := FND_MESSAGE.Get;

522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;
525: ELSE
526: x_msg_data := FND_MESSAGE.Get;
527: END IF;
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO SAVEPOINT Delete_Row;

Line 534: FND_MESSAGE.SET_NAME('GR',

530: ROLLBACK TO SAVEPOINT Delete_Row;
531: x_return_status := 'U';
532: x_oracle_error := APP_EXCEPTION.Get_Code;
533: l_msg_data := sqlerrm;
534: FND_MESSAGE.SET_NAME('GR',
535: 'GR_UNEXPECTED_ERROR');
536: FND_MESSAGE.SET_TOKEN('TEXT',
537: l_msg_data,
538: FALSE);

Line 536: FND_MESSAGE.SET_TOKEN('TEXT',

532: x_oracle_error := APP_EXCEPTION.Get_Code;
533: l_msg_data := sqlerrm;
534: FND_MESSAGE.SET_NAME('GR',
535: 'GR_UNEXPECTED_ERROR');
536: FND_MESSAGE.SET_TOKEN('TEXT',
537: l_msg_data,
538: FALSE);
539: IF FND_API.To_Boolean(p_called_by_form) THEN
540: APP_EXCEPTION.Raise_Exception;

Line 542: x_msg_data := FND_MESSAGE.Get;

538: FALSE);
539: IF FND_API.To_Boolean(p_called_by_form) THEN
540: APP_EXCEPTION.Raise_Exception;
541: ELSE
542: x_msg_data := FND_MESSAGE.Get;
543: END IF;
544:
545: END Delete_Row;
546:

Line 601: FND_MESSAGE.SET_NAME('GR',

597: IF c_get_document%NOTFOUND THEN
598: l_msg_token := p_document_code;
599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_RECORD_NOT_FOUND');
603: FND_MESSAGE.SET_TOKEN('CODE',
604: l_msg_token,
605: FALSE);

Line 603: FND_MESSAGE.SET_TOKEN('CODE',

599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_RECORD_NOT_FOUND');
603: FND_MESSAGE.SET_TOKEN('CODE',
604: l_msg_token,
605: FALSE);
606: l_msg_data := FND_MESSAGE.Get;
607: END IF;

Line 606: l_msg_data := FND_MESSAGE.Get;

602: 'GR_RECORD_NOT_FOUND');
603: FND_MESSAGE.SET_TOKEN('CODE',
604: l_msg_token,
605: FALSE);
606: l_msg_data := FND_MESSAGE.Get;
607: END IF;
608: CLOSE c_get_document;
609: END IF;
610:

Line 618: FND_MESSAGE.SET_NAME('GR',

614: IF c_get_label%NOTFOUND THEN
615: l_msg_token := p_left_label_code;
616: x_return_status := 'E';
617: x_oracle_error := APP_EXCEPTION.Get_Code;
618: FND_MESSAGE.SET_NAME('GR',
619: 'GR_RECORD_NOT_FOUND');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: l_msg_token,
622: FALSE);

Line 620: FND_MESSAGE.SET_TOKEN('CODE',

616: x_return_status := 'E';
617: x_oracle_error := APP_EXCEPTION.Get_Code;
618: FND_MESSAGE.SET_NAME('GR',
619: 'GR_RECORD_NOT_FOUND');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: l_msg_token,
622: FALSE);
623: l_msg_data := FND_MESSAGE.Get;
624: END IF;

Line 623: l_msg_data := FND_MESSAGE.Get;

619: 'GR_RECORD_NOT_FOUND');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: l_msg_token,
622: FALSE);
623: l_msg_data := FND_MESSAGE.Get;
624: END IF;
625: CLOSE c_get_label;
626: END IF;
627:

Line 635: FND_MESSAGE.SET_NAME('GR',

631: IF c_get_label%NOTFOUND THEN
632: l_msg_token := p_right_label_code;
633: x_return_status := 'E';
634: x_oracle_error := APP_EXCEPTION.Get_Code;
635: FND_MESSAGE.SET_NAME('GR',
636: 'GR_RECORD_NOT_FOUND');
637: FND_MESSAGE.SET_TOKEN('CODE',
638: l_msg_token,
639: FALSE);

Line 637: FND_MESSAGE.SET_TOKEN('CODE',

633: x_return_status := 'E';
634: x_oracle_error := APP_EXCEPTION.Get_Code;
635: FND_MESSAGE.SET_NAME('GR',
636: 'GR_RECORD_NOT_FOUND');
637: FND_MESSAGE.SET_TOKEN('CODE',
638: l_msg_token,
639: FALSE);
640: l_msg_data := FND_MESSAGE.Get;
641: END IF;

Line 640: l_msg_data := FND_MESSAGE.Get;

636: 'GR_RECORD_NOT_FOUND');
637: FND_MESSAGE.SET_TOKEN('CODE',
638: l_msg_token,
639: FALSE);
640: l_msg_data := FND_MESSAGE.Get;
641: END IF;
642: CLOSE c_get_label;
643: END IF;
644:

Line 656: FND_MESSAGE.SET_NAME('GR',

652: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
653: x_return_status := 'U';
654: x_oracle_error := APP_EXCEPTION.Get_Code;
655: l_msg_data := sqlerrm;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_UNEXPECTED_ERROR');
658: FND_MESSAGE.SET_TOKEN('TEXT',
659: l_msg_data,
660: FALSE);

Line 658: FND_MESSAGE.SET_TOKEN('TEXT',

654: x_oracle_error := APP_EXCEPTION.Get_Code;
655: l_msg_data := sqlerrm;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_UNEXPECTED_ERROR');
658: FND_MESSAGE.SET_TOKEN('TEXT',
659: l_msg_data,
660: FALSE);
661: x_msg_data := FND_MESSAGE.Get;
662:

Line 661: x_msg_data := FND_MESSAGE.Get;

657: 'GR_UNEXPECTED_ERROR');
658: FND_MESSAGE.SET_TOKEN('TEXT',
659: l_msg_data,
660: FALSE);
661: x_msg_data := FND_MESSAGE.Get;
662:
663: END Check_Foreign_Keys;
664:
665: PROCEDURE Check_Integrity

Line 708: FND_MESSAGE.SET_NAME('GR',

704: EXCEPTION
705:
706: WHEN INTEGRITY_ERROR THEN
707: x_return_status := 'E';
708: FND_MESSAGE.SET_NAME('GR',
709: 'GR_INTEGRITY_HEADER');
710: FND_MESSAGE.SET_TOKEN('CODE',
711: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
712: FALSE);

Line 710: FND_MESSAGE.SET_TOKEN('CODE',

706: WHEN INTEGRITY_ERROR THEN
707: x_return_status := 'E';
708: FND_MESSAGE.SET_NAME('GR',
709: 'GR_INTEGRITY_HEADER');
710: FND_MESSAGE.SET_TOKEN('CODE',
711: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
712: FALSE);
713: FND_MESSAGE.SET_TOKEN('TABLES',
714: l_msg_data,

Line 713: FND_MESSAGE.SET_TOKEN('TABLES',

709: 'GR_INTEGRITY_HEADER');
710: FND_MESSAGE.SET_TOKEN('CODE',
711: p_document_code||' '||p_left_label_code||' '||p_right_label_code,
712: FALSE);
713: FND_MESSAGE.SET_TOKEN('TABLES',
714: l_msg_data,
715: FALSE);
716: IF FND_API.To_Boolean(p_called_by_form) THEN
717: APP_EXCEPTION.Raise_Exception;

Line 719: x_msg_data := FND_MESSAGE.Get;

715: FALSE);
716: IF FND_API.To_Boolean(p_called_by_form) THEN
717: APP_EXCEPTION.Raise_Exception;
718: ELSE
719: x_msg_data := FND_MESSAGE.Get;
720: END IF;
721: WHEN OTHERS THEN
722: ROLLBACK TO SAVEPOINT Check_Integrity;
723: x_return_status := 'U';

Line 726: FND_MESSAGE.SET_NAME('GR',

722: ROLLBACK TO SAVEPOINT Check_Integrity;
723: x_return_status := 'U';
724: x_oracle_error := APP_EXCEPTION.Get_Code;
725: l_msg_data := sqlerrm;
726: FND_MESSAGE.SET_NAME('GR',
727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',
729: l_msg_data,
730: FALSE);

Line 728: FND_MESSAGE.SET_TOKEN('TEXT',

724: x_oracle_error := APP_EXCEPTION.Get_Code;
725: l_msg_data := sqlerrm;
726: FND_MESSAGE.SET_NAME('GR',
727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',
729: l_msg_data,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;

Line 734: x_msg_data := FND_MESSAGE.Get;

730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;
736:
737: END Check_Integrity;
738:

Line 779: FND_MESSAGE.SET_NAME('GR',

775: EXCEPTION
776:
777: WHEN Others THEN
778: l_msg_data := sqlerrm;
779: FND_MESSAGE.SET_NAME('GR',
780: 'GR_UNEXPECTED_ERROR');
781: FND_MESSAGE.SET_TOKEN('TEXT',
782: l_msg_data,
783: FALSE);

Line 781: FND_MESSAGE.SET_TOKEN('TEXT',

777: WHEN Others THEN
778: l_msg_data := sqlerrm;
779: FND_MESSAGE.SET_NAME('GR',
780: 'GR_UNEXPECTED_ERROR');
781: FND_MESSAGE.SET_TOKEN('TEXT',
782: l_msg_data,
783: FALSE);
784: IF FND_API.To_Boolean(p_called_by_form) THEN
785: APP_EXCEPTION.Raise_Exception;