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

Line 124: FND_MESSAGE.SET_NAME('GR',

120: WHEN Foreign_Key_Error THEN
121: ROLLBACK TO SAVEPOINT Insert_Row;
122: x_return_status := l_return_status;
123: x_oracle_error := l_oracle_error;
124: FND_MESSAGE.SET_NAME('GR',
125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);

Line 126: FND_MESSAGE.SET_TOKEN('TEXT',

122: x_return_status := l_return_status;
123: x_oracle_error := l_oracle_error;
124: FND_MESSAGE.SET_NAME('GR',
125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);
129: IF FND_API.To_Boolean(p_called_by_form) THEN
130: APP_EXCEPTION.Raise_Exception;

Line 132: x_msg_data := FND_MESSAGE.Get;

128: FALSE);
129: IF FND_API.To_Boolean(p_called_by_form) THEN
130: APP_EXCEPTION.Raise_Exception;
131: ELSE
132: x_msg_data := FND_MESSAGE.Get;
133: END IF;
134:
135: WHEN Item_Exists_Error THEN
136: ROLLBACK TO SAVEPOINT Insert_Row;

Line 140: FND_MESSAGE.SET_NAME('GR',

136: ROLLBACK TO SAVEPOINT Insert_Row;
137: l_msg_token := p_main_heading_code;
138: x_return_status := 'E';
139: x_oracle_error := APP_EXCEPTION.Get_Code;
140: FND_MESSAGE.SET_NAME('GR',
141: 'GR_RECORD_EXISTS');
142: FND_MESSAGE.SET_TOKEN('CODE',
143: l_msg_token,
144: FALSE);

Line 142: FND_MESSAGE.SET_TOKEN('CODE',

138: x_return_status := 'E';
139: x_oracle_error := APP_EXCEPTION.Get_Code;
140: FND_MESSAGE.SET_NAME('GR',
141: 'GR_RECORD_EXISTS');
142: FND_MESSAGE.SET_TOKEN('CODE',
143: l_msg_token,
144: FALSE);
145: IF FND_API.To_Boolean(p_called_by_form) THEN
146: APP_EXCEPTION.Raise_Exception;

Line 148: x_msg_data := FND_MESSAGE.Get;

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

Line 156: FND_MESSAGE.SET_NAME('GR',

152: ROLLBACK TO SAVEPOINT Insert_Row;
153: l_msg_token := p_main_heading_code;
154: x_return_status := 'E';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: FND_MESSAGE.SET_NAME('GR',
157: 'GR_NO_RECORD_INSERTED');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,
160: FALSE);

Line 158: FND_MESSAGE.SET_TOKEN('CODE',

154: x_return_status := 'E';
155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: FND_MESSAGE.SET_NAME('GR',
157: 'GR_NO_RECORD_INSERTED');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,
160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;

Line 164: x_msg_data := FND_MESSAGE.Get;

160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;
163: ELSE
164: x_msg_data := FND_MESSAGE.Get;
165: END IF;
166:
167: WHEN OTHERS THEN
168: ROLLBACK TO SAVEPOINT Insert_Row;

Line 173: FND_MESSAGE.SET_NAME('GR',

169: l_msg_token := p_main_heading_code;
170: x_return_status := 'U';
171: x_oracle_error := SQLCODE;
172: l_msg_data := SUBSTR(SQLERRM, 1, 200);
173: FND_MESSAGE.SET_NAME('GR',
174: 'GR_UNEXPECTED_ERROR');
175: FND_MESSAGE.SET_TOKEN('TEXT',
176: l_msg_token,
177: FALSE);

Line 175: FND_MESSAGE.SET_TOKEN('TEXT',

171: x_oracle_error := SQLCODE;
172: l_msg_data := SUBSTR(SQLERRM, 1, 200);
173: FND_MESSAGE.SET_NAME('GR',
174: 'GR_UNEXPECTED_ERROR');
175: FND_MESSAGE.SET_TOKEN('TEXT',
176: l_msg_token,
177: FALSE);
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;

Line 181: x_msg_data := FND_MESSAGE.Get;

177: FALSE);
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;
180: ELSE
181: x_msg_data := FND_MESSAGE.Get;
182: END IF;
183:
184: END Insert_Row;
185:

Line 271: FND_MESSAGE.SET_NAME('GR',

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

Line 273: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 279: x_msg_data := FND_MESSAGE.Get;

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

Line 286: FND_MESSAGE.SET_NAME('GR',

282: WHEN Row_Missing_Error THEN
283: ROLLBACK TO SAVEPOINT Update_Row;
284: x_return_status := 'E';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,
290: FALSE);

Line 288: FND_MESSAGE.SET_TOKEN('CODE',

284: x_return_status := 'E';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,
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 OTHERS THEN
298: ROLLBACK TO SAVEPOINT Update_Row;

Line 302: FND_MESSAGE.SET_NAME('GR',

298: ROLLBACK TO SAVEPOINT Update_Row;
299: x_return_status := 'U';
300: x_oracle_error := SQLCODE;
301: l_msg_data := SUBSTR(SQLERRM, 1, 200);
302: FND_MESSAGE.SET_NAME('GR',
303: 'GR_UNEXPECTED_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_token,
306: FALSE);

Line 304: FND_MESSAGE.SET_TOKEN('TEXT',

300: x_oracle_error := SQLCODE;
301: l_msg_data := SUBSTR(SQLERRM, 1, 200);
302: FND_MESSAGE.SET_NAME('GR',
303: 'GR_UNEXPECTED_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_token,
306: FALSE);
307: IF FND_API.To_Boolean(p_called_by_form) THEN
308: APP_EXCEPTION.Raise_Exception;

Line 310: x_msg_data := FND_MESSAGE.Get;

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

Line 484: FND_MESSAGE.SET_NAME('GR',

480: WHEN Language_Missing_Error THEN
481: ROLLBACK TO SAVEPOINT Add_Language;
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: l_msg_token,
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: l_msg_token,
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 Add_Language;

Line 500: FND_MESSAGE.SET_NAME('GR',

496: ROLLBACK TO SAVEPOINT Add_Language;
497: x_return_status := 'U';
498: x_oracle_error := SQLCODE;
499: l_msg_data := SUBSTR(SQLERRM, 1, 200);
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_token,
504: FALSE);

Line 502: FND_MESSAGE.SET_TOKEN('TEXT',

498: x_oracle_error := SQLCODE;
499: l_msg_data := SUBSTR(SQLERRM, 1, 200);
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_token,
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 Add_Language;
512:

Line 586: FND_MESSAGE.SET_NAME('GR',

582:
583: WHEN No_Data_Found_Error THEN
584: ROLLBACK TO SAVEPOINT Lock_Row;
585: x_return_status := 'E';
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_RECORD_NOT_FOUND');
588: FND_MESSAGE.SET_TOKEN('CODE',
589: l_msg_token,
590: FALSE);

Line 588: FND_MESSAGE.SET_TOKEN('CODE',

584: ROLLBACK TO SAVEPOINT Lock_Row;
585: x_return_status := 'E';
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_RECORD_NOT_FOUND');
588: FND_MESSAGE.SET_TOKEN('CODE',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;

Line 594: x_msg_data := FND_MESSAGE.Get;

590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;
596:
597: WHEN Row_Already_Locked_Error THEN
598: ROLLBACK TO SAVEPOINT Lock_Row;

Line 601: FND_MESSAGE.SET_NAME('GR',

597: WHEN Row_Already_Locked_Error THEN
598: ROLLBACK TO SAVEPOINT Lock_Row;
599: x_return_status := 'E';
600: x_oracle_error := APP_EXCEPTION.Get_Code;
601: FND_MESSAGE.SET_NAME('GR',
602: 'GR_ROW_IS_LOCKED');
603: IF FND_API.To_Boolean(p_called_by_form) THEN
604: APP_EXCEPTION.Raise_Exception;
605: ELSE

Line 606: x_msg_data := FND_MESSAGE.Get;

602: 'GR_ROW_IS_LOCKED');
603: IF FND_API.To_Boolean(p_called_by_form) THEN
604: APP_EXCEPTION.Raise_Exception;
605: ELSE
606: x_msg_data := FND_MESSAGE.Get;
607: END IF;
608:
609: WHEN OTHERS THEN
610: ROLLBACK TO SAVEPOINT Lock_Row;

Line 614: FND_MESSAGE.SET_NAME('GR',

610: ROLLBACK TO SAVEPOINT Lock_Row;
611: x_return_status := 'U';
612: x_oracle_error := SQLCODE;
613: l_msg_data := SUBSTR(SQLERRM, 1, 200);
614: FND_MESSAGE.SET_NAME('GR',
615: 'GR_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('TEXT',
617: l_msg_token,
618: FALSE);

Line 616: FND_MESSAGE.SET_TOKEN('TEXT',

612: x_oracle_error := SQLCODE;
613: l_msg_data := SUBSTR(SQLERRM, 1, 200);
614: FND_MESSAGE.SET_NAME('GR',
615: 'GR_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('TEXT',
617: l_msg_token,
618: FALSE);
619: IF FND_API.To_Boolean(p_called_by_form) THEN
620: APP_EXCEPTION.Raise_Exception;

Line 622: x_msg_data := FND_MESSAGE.Get;

618: FALSE);
619: IF FND_API.To_Boolean(p_called_by_form) THEN
620: APP_EXCEPTION.Raise_Exception;
621: ELSE
622: x_msg_data := FND_MESSAGE.Get;
623: END IF;
624:
625: END Lock_Row;
626:

Line 709: x_msg_data := FND_MESSAGE.Get;

705: x_oracle_error := l_oracle_error;
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;
708: ELSE
709: x_msg_data := FND_MESSAGE.Get;
710: END IF;
711:
712: WHEN Row_Missing_Error THEN
713: ROLLBACK TO SAVEPOINT Delete_Row;

Line 716: FND_MESSAGE.SET_NAME('GR',

712: WHEN Row_Missing_Error THEN
713: ROLLBACK TO SAVEPOINT Delete_Row;
714: x_return_status := 'E';
715: x_oracle_error := APP_EXCEPTION.Get_Code;
716: FND_MESSAGE.SET_NAME('GR',
717: 'GR_RECORD_NOT_FOUND');
718: FND_MESSAGE.SET_TOKEN('CODE',
719: l_msg_token,
720: FALSE);

Line 718: FND_MESSAGE.SET_TOKEN('CODE',

714: x_return_status := 'E';
715: x_oracle_error := APP_EXCEPTION.Get_Code;
716: FND_MESSAGE.SET_NAME('GR',
717: 'GR_RECORD_NOT_FOUND');
718: FND_MESSAGE.SET_TOKEN('CODE',
719: l_msg_token,
720: FALSE);
721: IF FND_API.To_Boolean(p_called_by_form) THEN
722: APP_EXCEPTION.Raise_Exception;

Line 724: x_msg_data := FND_MESSAGE.Get;

720: FALSE);
721: IF FND_API.To_Boolean(p_called_by_form) THEN
722: APP_EXCEPTION.Raise_Exception;
723: ELSE
724: x_msg_data := FND_MESSAGE.Get;
725: END IF;
726:
727: WHEN OTHERS THEN
728: ROLLBACK TO SAVEPOINT Delete_Row;

Line 732: FND_MESSAGE.SET_NAME('GR',

728: ROLLBACK TO SAVEPOINT Delete_Row;
729: x_return_status := 'U';
730: x_oracle_error := SQLCODE;
731: l_msg_data := SUBSTR(SQLERRM, 1, 200);
732: FND_MESSAGE.SET_NAME('GR',
733: 'GR_UNEXPECTED_ERROR');
734: FND_MESSAGE.SET_TOKEN('TEXT',
735: l_msg_data,
736: FALSE);

Line 734: FND_MESSAGE.SET_TOKEN('TEXT',

730: x_oracle_error := SQLCODE;
731: l_msg_data := SUBSTR(SQLERRM, 1, 200);
732: FND_MESSAGE.SET_NAME('GR',
733: 'GR_UNEXPECTED_ERROR');
734: FND_MESSAGE.SET_TOKEN('TEXT',
735: l_msg_data,
736: FALSE);
737: IF FND_API.To_Boolean(p_called_by_form) THEN
738: APP_EXCEPTION.Raise_Exception;

Line 740: x_msg_data := FND_MESSAGE.Get;

736: FALSE);
737: IF FND_API.To_Boolean(p_called_by_form) THEN
738: APP_EXCEPTION.Raise_Exception;
739: ELSE
740: x_msg_data := FND_MESSAGE.Get;
741: END IF;
742:
743: END Delete_Row;
744:

Line 790: FND_MESSAGE.SET_NAME('GR',

786: ROLLBACK TO SAVEPOINT Delete_Rows;
787: x_return_status := 'U';
788: x_oracle_error := SQLCODE;
789: l_msg_data := SUBSTR(SQLERRM, 1, 200);
790: FND_MESSAGE.SET_NAME('GR',
791: 'GR_UNEXPECTED_ERROR');
792: FND_MESSAGE.SET_TOKEN('TEXT',
793: l_msg_token,
794: FALSE);

Line 792: FND_MESSAGE.SET_TOKEN('TEXT',

788: x_oracle_error := SQLCODE;
789: l_msg_data := SUBSTR(SQLERRM, 1, 200);
790: FND_MESSAGE.SET_NAME('GR',
791: 'GR_UNEXPECTED_ERROR');
792: FND_MESSAGE.SET_TOKEN('TEXT',
793: l_msg_token,
794: FALSE);
795: IF FND_API.To_Boolean(p_called_by_form) THEN
796: APP_EXCEPTION.Raise_Exception;

Line 798: x_msg_data := FND_MESSAGE.Get;

794: FALSE);
795: IF FND_API.To_Boolean(p_called_by_form) THEN
796: APP_EXCEPTION.Raise_Exception;
797: ELSE
798: x_msg_data := FND_MESSAGE.Get;
799: END IF;
800:
801: END Delete_Rows;
802:

Line 875: FND_MESSAGE.SET_NAME('GR',

871: WHEN Row_Missing_Error THEN
872: ROLLBACK TO SAVEPOINT Delete_Row;
873: x_return_status := 'E';
874: x_oracle_error := APP_EXCEPTION.Get_Code;
875: FND_MESSAGE.SET_NAME('GR',
876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: l_msg_token,
879: FALSE);

Line 877: FND_MESSAGE.SET_TOKEN('CODE',

873: x_return_status := 'E';
874: x_oracle_error := APP_EXCEPTION.Get_Code;
875: FND_MESSAGE.SET_NAME('GR',
876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: l_msg_token,
879: FALSE);
880: x_msg_data := FND_MESSAGE.Get;
881:

Line 880: x_msg_data := FND_MESSAGE.Get;

876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: l_msg_token,
879: FALSE);
880: x_msg_data := FND_MESSAGE.Get;
881:
882: WHEN OTHERS THEN
883: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
884: x_return_status := 'U';

Line 887: FND_MESSAGE.SET_NAME('GR',

883: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
884: x_return_status := 'U';
885: x_oracle_error := SQLCODE;
886: l_msg_data := SUBSTR(SQLERRM, 1, 200);
887: FND_MESSAGE.SET_NAME('GR',
888: 'GR_UNEXPECTED_ERROR');
889: FND_MESSAGE.SET_TOKEN('TEXT',
890: l_msg_token,
891: FALSE);

Line 889: FND_MESSAGE.SET_TOKEN('TEXT',

885: x_oracle_error := SQLCODE;
886: l_msg_data := SUBSTR(SQLERRM, 1, 200);
887: FND_MESSAGE.SET_NAME('GR',
888: 'GR_UNEXPECTED_ERROR');
889: FND_MESSAGE.SET_TOKEN('TEXT',
890: l_msg_token,
891: FALSE);
892: x_msg_data := FND_MESSAGE.Get;
893:

Line 892: x_msg_data := FND_MESSAGE.Get;

888: 'GR_UNEXPECTED_ERROR');
889: FND_MESSAGE.SET_TOKEN('TEXT',
890: l_msg_token,
891: FALSE);
892: x_msg_data := FND_MESSAGE.Get;
893:
894: END Check_Foreign_Keys;
895:
896: PROCEDURE Check_Integrity

Line 957: FND_MESSAGE.SET_NAME('GR',

953:
954: WHEN Installed_Language_Error THEN
955: ROLLBACK TO SAVEPOINT Check_Integrity;
956: x_return_status := 'E';
957: FND_MESSAGE.SET_NAME('GR',
958: 'GR_INSTALLED_LANG');
959: FND_MESSAGE.SET_TOKEN('CODE',
960: p_language,
961: FALSE);

Line 959: FND_MESSAGE.SET_TOKEN('CODE',

955: ROLLBACK TO SAVEPOINT Check_Integrity;
956: x_return_status := 'E';
957: FND_MESSAGE.SET_NAME('GR',
958: 'GR_INSTALLED_LANG');
959: FND_MESSAGE.SET_TOKEN('CODE',
960: p_language,
961: FALSE);
962: IF FND_API.To_Boolean(p_called_by_form) THEN
963: APP_EXCEPTION.Raise_Exception;

Line 965: x_msg_data := FND_MESSAGE.Get;

961: FALSE);
962: IF FND_API.To_Boolean(p_called_by_form) THEN
963: APP_EXCEPTION.Raise_Exception;
964: ELSE
965: x_msg_data := FND_MESSAGE.Get;
966: END IF;
967:
968: WHEN OTHERS THEN
969: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 973: FND_MESSAGE.SET_NAME('GR',

969: ROLLBACK TO SAVEPOINT Check_Integrity;
970: x_return_status := 'U';
971: x_oracle_error := SQLCODE;
972: l_msg_data := SUBSTR(SQLERRM, 1, 200);
973: FND_MESSAGE.SET_NAME('GR',
974: 'GR_UNEXPECTED_ERROR');
975: FND_MESSAGE.SET_TOKEN('TEXT',
976: l_msg_data,
977: FALSE);

Line 975: FND_MESSAGE.SET_TOKEN('TEXT',

971: x_oracle_error := SQLCODE;
972: l_msg_data := SUBSTR(SQLERRM, 1, 200);
973: FND_MESSAGE.SET_NAME('GR',
974: 'GR_UNEXPECTED_ERROR');
975: FND_MESSAGE.SET_TOKEN('TEXT',
976: l_msg_data,
977: FALSE);
978: IF FND_API.To_Boolean(p_called_by_form) THEN
979: APP_EXCEPTION.Raise_Exception;

Line 981: x_msg_data := FND_MESSAGE.Get;

977: FALSE);
978: IF FND_API.To_Boolean(p_called_by_form) THEN
979: APP_EXCEPTION.Raise_Exception;
980: ELSE
981: x_msg_data := FND_MESSAGE.Get;
982: END IF;
983:
984: END Check_Integrity;
985:

Line 1033: FND_MESSAGE.SET_NAME('GR',

1029: EXCEPTION
1030:
1031: WHEN Others THEN
1032: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1033: FND_MESSAGE.SET_NAME('GR',
1034: 'GR_UNEXPECTED_ERROR');
1035: FND_MESSAGE.SET_TOKEN('TEXT',
1036: l_msg_data,
1037: FALSE);

Line 1035: FND_MESSAGE.SET_TOKEN('TEXT',

1031: WHEN Others THEN
1032: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1033: FND_MESSAGE.SET_NAME('GR',
1034: 'GR_UNEXPECTED_ERROR');
1035: FND_MESSAGE.SET_TOKEN('TEXT',
1036: l_msg_data,
1037: FALSE);
1038: IF FND_API.To_Boolean(p_called_by_form) THEN
1039: APP_EXCEPTION.Raise_Exception;