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

Line 138: FND_MESSAGE.SET_NAME('GR',

134: WHEN Foreign_Key_Error THEN
135: ROLLBACK TO SAVEPOINT Insert_Row;
136: x_return_status := l_return_status;
137: x_oracle_error := l_oracle_error;
138: FND_MESSAGE.SET_NAME('GR',
139: 'GR_FOREIGN_KEY_ERROR');
140: FND_MESSAGE.SET_TOKEN('TEXT',
141: l_msg_data,
142: FALSE);

Line 140: FND_MESSAGE.SET_TOKEN('TEXT',

136: x_return_status := l_return_status;
137: x_oracle_error := l_oracle_error;
138: FND_MESSAGE.SET_NAME('GR',
139: 'GR_FOREIGN_KEY_ERROR');
140: FND_MESSAGE.SET_TOKEN('TEXT',
141: l_msg_data,
142: FALSE);
143: IF FND_API.To_Boolean(p_called_by_form) THEN
144: APP_EXCEPTION.Raise_Exception;

Line 146: x_msg_data := FND_MESSAGE.Get;

142: FALSE);
143: IF FND_API.To_Boolean(p_called_by_form) THEN
144: APP_EXCEPTION.Raise_Exception;
145: ELSE
146: x_msg_data := FND_MESSAGE.Get;
147: END IF;
148:
149: WHEN Label_Exists_Error THEN
150: ROLLBACK TO SAVEPOINT Insert_Row;

Line 153: FND_MESSAGE.SET_NAME('GR',

149: WHEN Label_Exists_Error THEN
150: ROLLBACK TO SAVEPOINT Insert_Row;
151: x_return_status := 'E';
152: x_oracle_error := APP_EXCEPTION.Get_Code;
153: FND_MESSAGE.SET_NAME('GR',
154: 'GR_RECORD_EXISTS');
155: FND_MESSAGE.SET_TOKEN('CODE',
156: p_document_code,
157: FALSE);

Line 155: FND_MESSAGE.SET_TOKEN('CODE',

151: x_return_status := 'E';
152: x_oracle_error := APP_EXCEPTION.Get_Code;
153: FND_MESSAGE.SET_NAME('GR',
154: 'GR_RECORD_EXISTS');
155: FND_MESSAGE.SET_TOKEN('CODE',
156: p_document_code,
157: FALSE);
158: IF FND_API.To_Boolean(p_called_by_form) THEN
159: APP_EXCEPTION.Raise_Exception;

Line 161: x_msg_data := FND_MESSAGE.Get;

157: FALSE);
158: IF FND_API.To_Boolean(p_called_by_form) THEN
159: APP_EXCEPTION.Raise_Exception;
160: ELSE
161: x_msg_data := FND_MESSAGE.Get;
162: END IF;
163:
164: WHEN Row_Missing_Error THEN
165: ROLLBACK TO SAVEPOINT Insert_Row;

Line 168: FND_MESSAGE.SET_NAME('GR',

164: WHEN Row_Missing_Error THEN
165: ROLLBACK TO SAVEPOINT Insert_Row;
166: x_return_status := 'E';
167: x_oracle_error := APP_EXCEPTION.Get_Code;
168: FND_MESSAGE.SET_NAME('GR',
169: 'GR_NO_RECORD_INSERTED');
170: FND_MESSAGE.SET_TOKEN('CODE',
171: p_document_code,
172: FALSE);

Line 170: FND_MESSAGE.SET_TOKEN('CODE',

166: x_return_status := 'E';
167: x_oracle_error := APP_EXCEPTION.Get_Code;
168: FND_MESSAGE.SET_NAME('GR',
169: 'GR_NO_RECORD_INSERTED');
170: FND_MESSAGE.SET_TOKEN('CODE',
171: p_document_code,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;

Line 176: x_msg_data := FND_MESSAGE.Get;

172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;
178:
179: WHEN OTHERS THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;

Line 184: FND_MESSAGE.SET_NAME('GR',

180: ROLLBACK TO SAVEPOINT Insert_Row;
181: x_return_status := 'U';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: l_msg_data := APP_EXCEPTION.Get_Text;
184: FND_MESSAGE.SET_NAME('GR',
185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_data,
188: FALSE);

Line 186: FND_MESSAGE.SET_TOKEN('TEXT',

182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: l_msg_data := APP_EXCEPTION.Get_Text;
184: FND_MESSAGE.SET_NAME('GR',
185: 'GR_UNEXPECTED_ERROR');
186: FND_MESSAGE.SET_TOKEN('TEXT',
187: l_msg_data,
188: FALSE);
189: IF FND_API.To_Boolean(p_called_by_form) THEN
190: APP_EXCEPTION.Raise_Exception;

Line 192: x_msg_data := FND_MESSAGE.Get;

188: FALSE);
189: IF FND_API.To_Boolean(p_called_by_form) THEN
190: APP_EXCEPTION.Raise_Exception;
191: ELSE
192: x_msg_data := FND_MESSAGE.Get;
193: END IF;
194:
195: END Insert_Row;
196:

Line 286: FND_MESSAGE.SET_NAME('GR',

282: WHEN Foreign_Key_Error THEN
283: ROLLBACK TO SAVEPOINT Update_Row;
284: x_return_status := l_return_status;
285: x_oracle_error := l_oracle_error;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_FOREIGN_KEY_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
290: FALSE);

Line 288: FND_MESSAGE.SET_TOKEN('TEXT',

284: x_return_status := l_return_status;
285: x_oracle_error := l_oracle_error;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_FOREIGN_KEY_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;

Line 294: x_msg_data := FND_MESSAGE.Get;

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

Line 301: FND_MESSAGE.SET_NAME('GR',

297: WHEN Row_Missing_Error THEN
298: ROLLBACK TO SAVEPOINT Update_Row;
299: x_return_status := 'E';
300: x_oracle_error := APP_EXCEPTION.Get_Code;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_NO_RECORD_INSERTED');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_document_code,
305: FALSE);

Line 303: FND_MESSAGE.SET_TOKEN('CODE',

299: x_return_status := 'E';
300: x_oracle_error := APP_EXCEPTION.Get_Code;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_NO_RECORD_INSERTED');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_document_code,
305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;

Line 309: x_msg_data := FND_MESSAGE.Get;

305: FALSE);
306: IF FND_API.To_Boolean(p_called_by_form) THEN
307: APP_EXCEPTION.Raise_Exception;
308: ELSE
309: x_msg_data := FND_MESSAGE.Get;
310: END IF;
311:
312: WHEN OTHERS THEN
313: ROLLBACK TO SAVEPOINT Update_Row;

Line 317: FND_MESSAGE.SET_NAME('GR',

313: ROLLBACK TO SAVEPOINT Update_Row;
314: x_return_status := 'U';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,
321: FALSE);

Line 319: FND_MESSAGE.SET_TOKEN('TEXT',

315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: l_msg_data := APP_EXCEPTION.Get_Text;
317: FND_MESSAGE.SET_NAME('GR',
318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;

Line 325: x_msg_data := FND_MESSAGE.Get;

321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;
327:
328: END Update_Row;
329:

Line 394: FND_MESSAGE.SET_NAME('GR',

390: WHEN Row_Missing_Error THEN
391: ROLLBACK TO SAVEPOINT Update_Display_Columns;
392: x_return_status := 'E';
393: x_oracle_error := APP_EXCEPTION.Get_Code;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_NO_RECORD_INSERTED');
396: FND_MESSAGE.SET_TOKEN('CODE',
397: p_document_headings_seqno,
398: FALSE);

Line 396: FND_MESSAGE.SET_TOKEN('CODE',

392: x_return_status := 'E';
393: x_oracle_error := APP_EXCEPTION.Get_Code;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_NO_RECORD_INSERTED');
396: FND_MESSAGE.SET_TOKEN('CODE',
397: p_document_headings_seqno,
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: WHEN OTHERS THEN
406: ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line 410: FND_MESSAGE.SET_NAME('GR',

406: ROLLBACK TO SAVEPOINT Update_Display_Columns;
407: x_return_status := 'U';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: l_msg_data := APP_EXCEPTION.Get_Text;
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_UNEXPECTED_ERROR');
412: FND_MESSAGE.SET_TOKEN('TEXT',
413: l_msg_data,
414: FALSE);

Line 412: FND_MESSAGE.SET_TOKEN('TEXT',

408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: l_msg_data := APP_EXCEPTION.Get_Text;
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_UNEXPECTED_ERROR');
412: FND_MESSAGE.SET_TOKEN('TEXT',
413: l_msg_data,
414: FALSE);
415: IF FND_API.To_Boolean(p_called_by_form) THEN
416: APP_EXCEPTION.Raise_Exception;

Line 418: x_msg_data := FND_MESSAGE.Get;

414: FALSE);
415: IF FND_API.To_Boolean(p_called_by_form) THEN
416: APP_EXCEPTION.Raise_Exception;
417: ELSE
418: x_msg_data := FND_MESSAGE.Get;
419: END IF;
420:
421: END Update_Display_Columns;
422:

Line 497: FND_MESSAGE.SET_NAME('GR',

493:
494: WHEN No_Data_Found_Error THEN
495: ROLLBACK TO SAVEPOINT Lock_Row;
496: x_return_status := 'E';
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_RECORD_NOT_FOUND');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_document_code,
501: FALSE);

Line 499: FND_MESSAGE.SET_TOKEN('CODE',

495: ROLLBACK TO SAVEPOINT Lock_Row;
496: x_return_status := 'E';
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_RECORD_NOT_FOUND');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_document_code,
501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;

Line 505: x_msg_data := FND_MESSAGE.Get;

501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;
504: ELSE
505: x_msg_data := FND_MESSAGE.Get;
506: END IF;
507:
508: WHEN Row_Already_Locked_Error THEN
509: ROLLBACK TO SAVEPOINT Lock_Row;

Line 512: FND_MESSAGE.SET_NAME('GR',

508: WHEN Row_Already_Locked_Error THEN
509: ROLLBACK TO SAVEPOINT Lock_Row;
510: x_return_status := 'E';
511: x_oracle_error := APP_EXCEPTION.Get_Code;
512: FND_MESSAGE.SET_NAME('GR',
513: 'GR_ROW_IS_LOCKED');
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE

Line 517: x_msg_data := FND_MESSAGE.Get;

513: 'GR_ROW_IS_LOCKED');
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;
519:
520: WHEN OTHERS THEN
521: ROLLBACK TO SAVEPOINT Lock_Row;

Line 525: FND_MESSAGE.SET_NAME('GR',

521: ROLLBACK TO SAVEPOINT Lock_Row;
522: x_return_status := 'U';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);

Line 527: FND_MESSAGE.SET_TOKEN('TEXT',

523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;

Line 533: x_msg_data := FND_MESSAGE.Get;

529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;
532: ELSE
533: x_msg_data := FND_MESSAGE.Get;
534: END IF;
535:
536: END Lock_Row;
537:

Line 621: x_msg_data := FND_MESSAGE.Get;

617: x_oracle_error := l_oracle_error;
618: IF FND_API.To_Boolean(p_called_by_form) THEN
619: APP_EXCEPTION.Raise_Exception;
620: ELSE
621: x_msg_data := FND_MESSAGE.Get;
622: END IF;
623:
624: WHEN Row_Missing_Error THEN
625: ROLLBACK TO SAVEPOINT Delete_Row;

Line 628: FND_MESSAGE.SET_NAME('GR',

624: WHEN Row_Missing_Error THEN
625: ROLLBACK TO SAVEPOINT Delete_Row;
626: x_return_status := 'E';
627: x_oracle_error := APP_EXCEPTION.Get_Code;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_code,
632: FALSE);

Line 630: FND_MESSAGE.SET_TOKEN('CODE',

626: x_return_status := 'E';
627: x_oracle_error := APP_EXCEPTION.Get_Code;
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_RECORD_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('CODE',
631: p_document_code,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;

Line 636: x_msg_data := FND_MESSAGE.Get;

632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;
638:
639: WHEN OTHERS THEN
640: ROLLBACK TO SAVEPOINT Delete_Row;

Line 645: FND_MESSAGE.SET_NAME('GR',

641: x_return_status := 'U';
642: x_oracle_error := APP_EXCEPTION.Get_Code;
643: l_msg_data := APP_EXCEPTION.Get_Text;
644: l_msg_data := APP_EXCEPTION.Get_Text;
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_UNEXPECTED_ERROR');
647: FND_MESSAGE.SET_TOKEN('TEXT',
648: l_msg_data,
649: FALSE);

Line 647: FND_MESSAGE.SET_TOKEN('TEXT',

643: l_msg_data := APP_EXCEPTION.Get_Text;
644: l_msg_data := APP_EXCEPTION.Get_Text;
645: FND_MESSAGE.SET_NAME('GR',
646: 'GR_UNEXPECTED_ERROR');
647: FND_MESSAGE.SET_TOKEN('TEXT',
648: l_msg_data,
649: FALSE);
650: IF FND_API.To_Boolean(p_called_by_form) THEN
651: APP_EXCEPTION.Raise_Exception;

Line 653: x_msg_data := FND_MESSAGE.Get;

649: FALSE);
650: IF FND_API.To_Boolean(p_called_by_form) THEN
651: APP_EXCEPTION.Raise_Exception;
652: ELSE
653: x_msg_data := FND_MESSAGE.Get;
654: END IF;
655:
656: END Delete_Row;
657:

Line 703: FND_MESSAGE.SET_NAME('GR',

699: ROLLBACK TO SAVEPOINT Delete_Rows;
700: x_return_status := 'U';
701: x_oracle_error := APP_EXCEPTION.Get_Code;
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,
707: FALSE);

Line 705: FND_MESSAGE.SET_TOKEN('TEXT',

701: x_oracle_error := APP_EXCEPTION.Get_Code;
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,
707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;

Line 711: x_msg_data := FND_MESSAGE.Get;

707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;
710: ELSE
711: x_msg_data := FND_MESSAGE.Get;
712: END IF;
713:
714: END Delete_Rows;
715:

Line 774: FND_MESSAGE.SET_NAME('GR',

770: OPEN c_get_main_heading;
771: FETCH c_get_main_heading INTO MainHdgRcd;
772: IF c_get_main_heading%NOTFOUND THEN
773: x_return_status := 'E';
774: FND_MESSAGE.SET_NAME('GR',
775: 'GR_RECORD_NOT_FOUND');
776: FND_MESSAGE.SET_TOKEN('CODE',
777: p_main_heading_code,
778: FALSE);

Line 776: FND_MESSAGE.SET_TOKEN('CODE',

772: IF c_get_main_heading%NOTFOUND THEN
773: x_return_status := 'E';
774: FND_MESSAGE.SET_NAME('GR',
775: 'GR_RECORD_NOT_FOUND');
776: FND_MESSAGE.SET_TOKEN('CODE',
777: p_main_heading_code,
778: FALSE);
779: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
780: END IF;

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

775: 'GR_RECORD_NOT_FOUND');
776: FND_MESSAGE.SET_TOKEN('CODE',
777: p_main_heading_code,
778: FALSE);
779: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
780: END IF;
781: CLOSE c_get_main_heading;
782:
783: /* Check the sub heading code */

Line 790: FND_MESSAGE.SET_NAME('GR',

786: OPEN c_get_sub_heading;
787: FETCH c_get_sub_heading INTO SubHdgRcd;
788: IF c_get_sub_heading%NOTFOUND THEN
789: x_return_status := 'E';
790: FND_MESSAGE.SET_NAME('GR',
791: 'GR_RECORD_NOT_FOUND');
792: FND_MESSAGE.SET_TOKEN('CODE',
793: p_sub_heading_code,
794: FALSE);

Line 792: FND_MESSAGE.SET_TOKEN('CODE',

788: IF c_get_sub_heading%NOTFOUND THEN
789: x_return_status := 'E';
790: FND_MESSAGE.SET_NAME('GR',
791: 'GR_RECORD_NOT_FOUND');
792: FND_MESSAGE.SET_TOKEN('CODE',
793: p_sub_heading_code,
794: FALSE);
795: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
796: END IF;

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

791: 'GR_RECORD_NOT_FOUND');
792: FND_MESSAGE.SET_TOKEN('CODE',
793: p_sub_heading_code,
794: FALSE);
795: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
796: END IF;
797: CLOSE c_get_sub_heading;
798: END IF;
799:

Line 811: FND_MESSAGE.SET_NAME('GR',

807: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
808: x_return_status := 'U';
809: x_oracle_error := APP_EXCEPTION.Get_Code;
810: l_msg_data := APP_EXCEPTION.Get_Text;
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_UNEXPECTED_ERROR');
813: FND_MESSAGE.SET_TOKEN('TEXT',
814: l_msg_data,
815: FALSE);

Line 813: FND_MESSAGE.SET_TOKEN('TEXT',

809: x_oracle_error := APP_EXCEPTION.Get_Code;
810: l_msg_data := APP_EXCEPTION.Get_Text;
811: FND_MESSAGE.SET_NAME('GR',
812: 'GR_UNEXPECTED_ERROR');
813: FND_MESSAGE.SET_TOKEN('TEXT',
814: l_msg_data,
815: FALSE);
816: x_msg_data := FND_MESSAGE.Get;
817:

Line 816: x_msg_data := FND_MESSAGE.Get;

812: 'GR_UNEXPECTED_ERROR');
813: FND_MESSAGE.SET_TOKEN('TEXT',
814: l_msg_data,
815: FALSE);
816: x_msg_data := FND_MESSAGE.Get;
817:
818: END Check_Foreign_Keys;
819:
820: PROCEDURE Check_Integrity

Line 862: FND_MESSAGE.SET_NAME('GR',

858: x_return_status := 'S';
859: x_oracle_error := 0;
860: x_msg_data := NULL;
861:
862: FND_MESSAGE.SET_NAME('GR',
863: 'GR_INTEGRITY_HEADER');
864: FND_MESSAGE.SET_TOKEN('CODE',
865: p_main_heading_code || ' ' || p_sub_heading_code,
866: FALSE);

Line 864: FND_MESSAGE.SET_TOKEN('CODE',

860: x_msg_data := NULL;
861:
862: FND_MESSAGE.SET_NAME('GR',
863: 'GR_INTEGRITY_HEADER');
864: FND_MESSAGE.SET_TOKEN('CODE',
865: p_main_heading_code || ' ' || p_sub_heading_code,
866: FALSE);
867: l_msg_data := FND_MESSAGE.Get;
868:

Line 867: l_msg_data := FND_MESSAGE.Get;

863: 'GR_INTEGRITY_HEADER');
864: FND_MESSAGE.SET_TOKEN('CODE',
865: p_main_heading_code || ' ' || p_sub_heading_code,
866: FALSE);
867: l_msg_data := FND_MESSAGE.Get;
868:
869: /* Check for any rows defined in the item document table */
870:
871: l_record_count := 0;

Line 893: FND_MESSAGE.SET_NAME('GR',

889: ROLLBACK TO SAVEPOINT Check_Integrity;
890: x_return_status := 'U';
891: x_oracle_error := APP_EXCEPTION.Get_Code;
892: l_msg_data := APP_EXCEPTION.Get_Text;
893: FND_MESSAGE.SET_NAME('GR',
894: 'GR_UNEXPECTED_ERROR');
895: FND_MESSAGE.SET_TOKEN('TEXT',
896: l_msg_data,
897: FALSE);

Line 895: FND_MESSAGE.SET_TOKEN('TEXT',

891: x_oracle_error := APP_EXCEPTION.Get_Code;
892: l_msg_data := APP_EXCEPTION.Get_Text;
893: FND_MESSAGE.SET_NAME('GR',
894: 'GR_UNEXPECTED_ERROR');
895: FND_MESSAGE.SET_TOKEN('TEXT',
896: l_msg_data,
897: FALSE);
898: IF FND_API.To_Boolean(p_called_by_form) THEN
899: APP_EXCEPTION.Raise_Exception;

Line 901: x_msg_data := FND_MESSAGE.Get;

897: FALSE);
898: IF FND_API.To_Boolean(p_called_by_form) THEN
899: APP_EXCEPTION.Raise_Exception;
900: ELSE
901: x_msg_data := FND_MESSAGE.Get;
902: END IF;
903:
904: END Check_Integrity;
905:

Line 949: FND_MESSAGE.SET_NAME('GR',

945: EXCEPTION
946:
947: WHEN Others THEN
948: l_msg_data := APP_EXCEPTION.Get_Text;
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_UNEXPECTED_ERROR');
951: FND_MESSAGE.SET_TOKEN('TEXT',
952: l_msg_data,
953: FALSE);

Line 951: FND_MESSAGE.SET_TOKEN('TEXT',

947: WHEN Others THEN
948: l_msg_data := APP_EXCEPTION.Get_Text;
949: FND_MESSAGE.SET_NAME('GR',
950: 'GR_UNEXPECTED_ERROR');
951: FND_MESSAGE.SET_TOKEN('TEXT',
952: l_msg_data,
953: FALSE);
954: IF FND_API.To_Boolean(p_called_by_form) THEN
955: APP_EXCEPTION.Raise_Exception;

Line 1018: FND_MESSAGE.SET_NAME('GR',

1014:
1015: WHEN No_Data_Found_Error THEN
1016: ROLLBACK TO SAVEPOINT Lock_Rows;
1017: x_return_status := 'E';
1018: FND_MESSAGE.SET_NAME('GR',
1019: 'GR_RECORD_NOT_FOUND');
1020: FND_MESSAGE.SET_TOKEN('CODE',
1021: p_document_code,
1022: FALSE);

Line 1020: FND_MESSAGE.SET_TOKEN('CODE',

1016: ROLLBACK TO SAVEPOINT Lock_Rows;
1017: x_return_status := 'E';
1018: FND_MESSAGE.SET_NAME('GR',
1019: 'GR_RECORD_NOT_FOUND');
1020: FND_MESSAGE.SET_TOKEN('CODE',
1021: p_document_code,
1022: FALSE);
1023: APP_EXCEPTION.Raise_Exception;
1024: WHEN RECORD_CHANGED_ERROR THEN

Line 1026: FND_MESSAGE.SET_NAME('FND',

1022: FALSE);
1023: APP_EXCEPTION.Raise_Exception;
1024: WHEN RECORD_CHANGED_ERROR THEN
1025: X_return_status := 'E';
1026: FND_MESSAGE.SET_NAME('FND',
1027: 'FORM_RECORD_CHANGED');
1028: APP_EXCEPTION.Raise_Exception;
1029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1030: ROLLBACK TO SAVEPOINT Lock_Rows;

Line 1037: FND_MESSAGE.SET_NAME('GR',

1033: ROLLBACK TO SAVEPOINT Lock_Rows;
1034: x_return_status := 'U';
1035: x_oracle_error := APP_EXCEPTION.Get_Code;
1036: l_msg_data := APP_EXCEPTION.Get_Text;
1037: FND_MESSAGE.SET_NAME('GR',
1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,
1041: FALSE);

Line 1039: FND_MESSAGE.SET_TOKEN('TEXT',

1035: x_oracle_error := APP_EXCEPTION.Get_Code;
1036: l_msg_data := APP_EXCEPTION.Get_Text;
1037: FND_MESSAGE.SET_NAME('GR',
1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,
1041: FALSE);
1042: APP_EXCEPTION.Raise_Exception;
1043: