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

Line 123: FND_MESSAGE.SET_NAME('GR',

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

Line 125: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 131: x_msg_data := FND_MESSAGE.Get;

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

Line 139: FND_MESSAGE.SET_NAME('GR',

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

Line 141: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 147: x_msg_data := FND_MESSAGE.Get;

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

Line 155: FND_MESSAGE.SET_NAME('GR',

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

Line 157: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 163: x_msg_data := FND_MESSAGE.Get;

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

Line 172: FND_MESSAGE.SET_NAME('GR',

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

Line 174: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 180: x_msg_data := FND_MESSAGE.Get;

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

Line 270: FND_MESSAGE.SET_NAME('GR',

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

Line 272: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 278: x_msg_data := FND_MESSAGE.Get;

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

Line 285: FND_MESSAGE.SET_NAME('GR',

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

Line 287: FND_MESSAGE.SET_TOKEN('CODE',

283: x_return_status := 'E';
284: x_oracle_error := APP_EXCEPTION.Get_Code;
285: FND_MESSAGE.SET_NAME('GR',
286: 'GR_NO_RECORD_INSERTED');
287: FND_MESSAGE.SET_TOKEN('CODE',
288: l_msg_token,
289: FALSE);
290: IF FND_API.To_Boolean(p_called_by_form) THEN
291: APP_EXCEPTION.Raise_Exception;

Line 293: x_msg_data := FND_MESSAGE.Get;

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

Line 301: FND_MESSAGE.SET_NAME('GR',

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

Line 303: FND_MESSAGE.SET_TOKEN('TEXT',

299: x_oracle_error := SQLCODE;
300: l_msg_data := SUBSTR(SQLERRM, 1, 200);
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_UNEXPECTED_ERROR');
303: FND_MESSAGE.SET_TOKEN('TEXT',
304: l_msg_token,
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: END Update_Row;
313:

Line 482: FND_MESSAGE.SET_NAME('GR',

478: WHEN Language_Missing_Error THEN
479: ROLLBACK TO SAVEPOINT Add_Language;
480: x_return_status := 'E';
481: x_oracle_error := APP_EXCEPTION.Get_Code;
482: FND_MESSAGE.SET_NAME('GR',
483: 'GR_RECORD_NOT_FOUND');
484: FND_MESSAGE.SET_TOKEN('CODE',
485: l_msg_token,
486: FALSE);

Line 484: FND_MESSAGE.SET_TOKEN('CODE',

480: x_return_status := 'E';
481: x_oracle_error := APP_EXCEPTION.Get_Code;
482: FND_MESSAGE.SET_NAME('GR',
483: 'GR_RECORD_NOT_FOUND');
484: FND_MESSAGE.SET_TOKEN('CODE',
485: l_msg_token,
486: FALSE);
487: IF FND_API.To_Boolean(p_called_by_form) THEN
488: APP_EXCEPTION.Raise_Exception;

Line 490: x_msg_data := FND_MESSAGE.Get;

486: FALSE);
487: IF FND_API.To_Boolean(p_called_by_form) THEN
488: APP_EXCEPTION.Raise_Exception;
489: ELSE
490: x_msg_data := FND_MESSAGE.Get;
491: END IF;
492:
493: WHEN OTHERS THEN
494: ROLLBACK TO SAVEPOINT Add_Language;

Line 498: FND_MESSAGE.SET_NAME('GR',

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

Line 500: FND_MESSAGE.SET_TOKEN('TEXT',

496: x_oracle_error := SQLCODE;
497: l_msg_data := SUBSTR(SQLERRM, 1, 200);
498: FND_MESSAGE.SET_NAME('GR',
499: 'GR_UNEXPECTED_ERROR');
500: FND_MESSAGE.SET_TOKEN('TEXT',
501: l_msg_token,
502: FALSE);
503: IF FND_API.To_Boolean(p_called_by_form) THEN
504: APP_EXCEPTION.Raise_Exception;

Line 506: x_msg_data := FND_MESSAGE.Get;

502: FALSE);
503: IF FND_API.To_Boolean(p_called_by_form) THEN
504: APP_EXCEPTION.Raise_Exception;
505: ELSE
506: x_msg_data := FND_MESSAGE.Get;
507: END IF;
508:
509: END Add_Language;
510:

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 RECORD_CHANGED_ERROR THEN
598: ROLLBACK TO SAVEPOINT Lock_Row;

Line 600: FND_MESSAGE.SET_NAME('FND',

596:
597: WHEN RECORD_CHANGED_ERROR THEN
598: ROLLBACK TO SAVEPOINT Lock_Row;
599: X_return_status := 'E';
600: FND_MESSAGE.SET_NAME('FND',
601: 'FORM_RECORD_CHANGED');
602: IF FND_API.To_Boolean(p_called_by_form) THEN
603: APP_EXCEPTION.Raise_Exception;
604: ELSE

Line 605: x_msg_data := FND_MESSAGE.Get;

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

Line 612: FND_MESSAGE.SET_NAME('GR',

608: ROLLBACK TO SAVEPOINT Lock_Row;
609: x_return_status := 'L';
610: x_oracle_error := APP_EXCEPTION.Get_Code;
611: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
612: FND_MESSAGE.SET_NAME('GR',
613: 'GR_ROW_IS_LOCKED');
614: x_msg_data := FND_MESSAGE.Get;
615: END IF;
616:

Line 614: x_msg_data := FND_MESSAGE.Get;

610: x_oracle_error := APP_EXCEPTION.Get_Code;
611: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
612: FND_MESSAGE.SET_NAME('GR',
613: 'GR_ROW_IS_LOCKED');
614: x_msg_data := FND_MESSAGE.Get;
615: END IF;
616:
617: WHEN OTHERS THEN
618: ROLLBACK TO SAVEPOINT Lock_Row;

Line 622: FND_MESSAGE.SET_NAME('GR',

618: ROLLBACK TO SAVEPOINT Lock_Row;
619: x_return_status := 'U';
620: x_oracle_error := SQLCODE;
621: l_msg_data := SUBSTR(SQLERRM, 1, 200);
622: FND_MESSAGE.SET_NAME('GR',
623: 'GR_UNEXPECTED_ERROR');
624: FND_MESSAGE.SET_TOKEN('TEXT',
625: l_msg_token,
626: FALSE);

Line 624: FND_MESSAGE.SET_TOKEN('TEXT',

620: x_oracle_error := SQLCODE;
621: l_msg_data := SUBSTR(SQLERRM, 1, 200);
622: FND_MESSAGE.SET_NAME('GR',
623: 'GR_UNEXPECTED_ERROR');
624: FND_MESSAGE.SET_TOKEN('TEXT',
625: l_msg_token,
626: FALSE);
627: IF FND_API.To_Boolean(p_called_by_form) THEN
628: APP_EXCEPTION.Raise_Exception;

Line 630: x_msg_data := FND_MESSAGE.Get;

626: FALSE);
627: IF FND_API.To_Boolean(p_called_by_form) THEN
628: APP_EXCEPTION.Raise_Exception;
629: ELSE
630: x_msg_data := FND_MESSAGE.Get;
631: END IF;
632:
633: END Lock_Row;
634:

Line 723: FND_MESSAGE.SET_NAME('GR',

719: WHEN Row_Missing_Error THEN
720: ROLLBACK TO SAVEPOINT Delete_Row;
721: x_return_status := 'E';
722: x_oracle_error := APP_EXCEPTION.Get_Code;
723: FND_MESSAGE.SET_NAME('GR',
724: 'GR_RECORD_NOT_FOUND');
725: FND_MESSAGE.SET_TOKEN('CODE',
726: l_msg_token,
727: FALSE);

Line 725: FND_MESSAGE.SET_TOKEN('CODE',

721: x_return_status := 'E';
722: x_oracle_error := APP_EXCEPTION.Get_Code;
723: FND_MESSAGE.SET_NAME('GR',
724: 'GR_RECORD_NOT_FOUND');
725: FND_MESSAGE.SET_TOKEN('CODE',
726: l_msg_token,
727: FALSE);
728: IF FND_API.To_Boolean(p_called_by_form) THEN
729: APP_EXCEPTION.Raise_Exception;

Line 731: x_msg_data := FND_MESSAGE.Get;

727: FALSE);
728: IF FND_API.To_Boolean(p_called_by_form) THEN
729: APP_EXCEPTION.Raise_Exception;
730: ELSE
731: x_msg_data := FND_MESSAGE.Get;
732: END IF;
733:
734: WHEN OTHERS THEN
735: ROLLBACK TO SAVEPOINT Delete_Row;

Line 739: FND_MESSAGE.SET_NAME('GR',

735: ROLLBACK TO SAVEPOINT Delete_Row;
736: x_return_status := 'U';
737: x_oracle_error := SQLCODE;
738: l_msg_data := SUBSTR(SQLERRM, 1, 200);
739: FND_MESSAGE.SET_NAME('GR',
740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_token,
743: FALSE);

Line 741: FND_MESSAGE.SET_TOKEN('TEXT',

737: x_oracle_error := SQLCODE;
738: l_msg_data := SUBSTR(SQLERRM, 1, 200);
739: FND_MESSAGE.SET_NAME('GR',
740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_token,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;

Line 747: x_msg_data := FND_MESSAGE.Get;

743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;
746: ELSE
747: x_msg_data := FND_MESSAGE.Get;
748: END IF;
749:
750: END Delete_Row;
751:

Line 797: FND_MESSAGE.SET_NAME('GR',

793: ROLLBACK TO SAVEPOINT Delete_Rows;
794: x_return_status := 'U';
795: x_oracle_error := SQLCODE;
796: l_msg_data := SUBSTR(SQLERRM, 1, 200);
797: FND_MESSAGE.SET_NAME('GR',
798: 'GR_UNEXPECTED_ERROR');
799: FND_MESSAGE.SET_TOKEN('TEXT',
800: l_msg_token,
801: FALSE);

Line 799: FND_MESSAGE.SET_TOKEN('TEXT',

795: x_oracle_error := SQLCODE;
796: l_msg_data := SUBSTR(SQLERRM, 1, 200);
797: FND_MESSAGE.SET_NAME('GR',
798: 'GR_UNEXPECTED_ERROR');
799: FND_MESSAGE.SET_TOKEN('TEXT',
800: l_msg_token,
801: FALSE);
802: IF FND_API.To_Boolean(p_called_by_form) THEN
803: APP_EXCEPTION.Raise_Exception;

Line 805: x_msg_data := FND_MESSAGE.Get;

801: FALSE);
802: IF FND_API.To_Boolean(p_called_by_form) THEN
803: APP_EXCEPTION.Raise_Exception;
804: ELSE
805: x_msg_data := FND_MESSAGE.Get;
806: END IF;
807:
808: END Delete_Rows;
809:

Line 859: FND_MESSAGE.SET_NAME('GR',

855: IF c_get_language%NOTFOUND THEN
856: l_msg_token := l_language_code;
857: x_return_status := 'E';
858: x_oracle_error := APP_EXCEPTION.Get_Code;
859: FND_MESSAGE.SET_NAME('GR',
860: 'GR_RECORD_NOT_FOUND');
861: FND_MESSAGE.SET_TOKEN('CODE',
862: l_msg_token,
863: FALSE);

Line 861: FND_MESSAGE.SET_TOKEN('CODE',

857: x_return_status := 'E';
858: x_oracle_error := APP_EXCEPTION.Get_Code;
859: FND_MESSAGE.SET_NAME('GR',
860: 'GR_RECORD_NOT_FOUND');
861: FND_MESSAGE.SET_TOKEN('CODE',
862: l_msg_token,
863: FALSE);
864: l_msg_data := FND_MESSAGE.Get;
865: END IF;

Line 864: l_msg_data := FND_MESSAGE.Get;

860: 'GR_RECORD_NOT_FOUND');
861: FND_MESSAGE.SET_TOKEN('CODE',
862: l_msg_token,
863: FALSE);
864: l_msg_data := FND_MESSAGE.Get;
865: END IF;
866: CLOSE c_get_language;
867:
868: l_language_code := p_source_lang;

Line 875: FND_MESSAGE.SET_NAME('GR',

871: IF c_get_language%NOTFOUND THEN
872: l_msg_token := l_language_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);

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: l_msg_data := FND_MESSAGE.Get;
881: END IF;

Line 880: l_msg_data := FND_MESSAGE.Get;

876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: l_msg_token,
879: FALSE);
880: l_msg_data := FND_MESSAGE.Get;
881: END IF;
882: CLOSE c_get_language;
883:
884: IF x_return_status <> 'S' THEN

Line 895: FND_MESSAGE.SET_NAME('GR',

891: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
892: x_return_status := 'U';
893: x_oracle_error := SQLCODE;
894: l_msg_data := SUBSTR(SQLERRM, 1, 200);
895: FND_MESSAGE.SET_NAME('GR',
896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);

Line 897: FND_MESSAGE.SET_TOKEN('TEXT',

893: x_oracle_error := SQLCODE;
894: l_msg_data := SUBSTR(SQLERRM, 1, 200);
895: FND_MESSAGE.SET_NAME('GR',
896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);
900: x_msg_data := FND_MESSAGE.Get;
901:

Line 900: x_msg_data := FND_MESSAGE.Get;

896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);
900: x_msg_data := FND_MESSAGE.Get;
901:
902: END Check_Foreign_Keys;
903:
904: PROCEDURE Check_Integrity

Line 962: FND_MESSAGE.SET_NAME('GR',

958:
959: WHEN Installed_Language_Error THEN
960: ROLLBACK TO SAVEPOINT Check_Integrity;
961: x_return_status := 'E';
962: FND_MESSAGE.SET_NAME('GR',
963: 'GR_INSTALLED_LANG');
964: FND_MESSAGE.SET_TOKEN('CODE',
965: p_language,
966: FALSE);

Line 964: FND_MESSAGE.SET_TOKEN('CODE',

960: ROLLBACK TO SAVEPOINT Check_Integrity;
961: x_return_status := 'E';
962: FND_MESSAGE.SET_NAME('GR',
963: 'GR_INSTALLED_LANG');
964: FND_MESSAGE.SET_TOKEN('CODE',
965: p_language,
966: FALSE);
967: IF FND_API.To_Boolean(p_called_by_form) THEN
968: APP_EXCEPTION.Raise_Exception;

Line 970: x_msg_data := FND_MESSAGE.Get;

966: FALSE);
967: IF FND_API.To_Boolean(p_called_by_form) THEN
968: APP_EXCEPTION.Raise_Exception;
969: ELSE
970: x_msg_data := FND_MESSAGE.Get;
971: END IF;
972:
973: WHEN OTHERS THEN
974: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 978: FND_MESSAGE.SET_NAME('GR',

974: ROLLBACK TO SAVEPOINT Check_Integrity;
975: x_return_status := 'U';
976: x_oracle_error := SQLCODE;
977: l_msg_data := SUBSTR(SQLERRM, 1, 200);
978: FND_MESSAGE.SET_NAME('GR',
979: 'GR_UNEXPECTED_ERROR');
980: FND_MESSAGE.SET_TOKEN('TEXT',
981: l_msg_data,
982: FALSE);

Line 980: FND_MESSAGE.SET_TOKEN('TEXT',

976: x_oracle_error := SQLCODE;
977: l_msg_data := SUBSTR(SQLERRM, 1, 200);
978: FND_MESSAGE.SET_NAME('GR',
979: 'GR_UNEXPECTED_ERROR');
980: FND_MESSAGE.SET_TOKEN('TEXT',
981: l_msg_data,
982: FALSE);
983: IF FND_API.To_Boolean(p_called_by_form) THEN
984: APP_EXCEPTION.Raise_Exception;

Line 986: x_msg_data := FND_MESSAGE.Get;

982: FALSE);
983: IF FND_API.To_Boolean(p_called_by_form) THEN
984: APP_EXCEPTION.Raise_Exception;
985: ELSE
986: x_msg_data := FND_MESSAGE.Get;
987: END IF;
988:
989: END Check_Integrity;
990:

Line 1037: FND_MESSAGE.SET_NAME('GR',

1033: EXCEPTION
1034:
1035: WHEN Others THEN
1036: l_msg_data := SUBSTR(SQLERRM, 1, 200);
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: WHEN Others THEN
1036: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1037: FND_MESSAGE.SET_NAME('GR',
1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,
1041: FALSE);
1042: IF FND_API.To_Boolean(p_called_by_form) THEN
1043: APP_EXCEPTION.Raise_Exception;