DBA Data[Home] [Help]

APPS.GR_SAFETY_PHRASES_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_safety_phrase_code || ' ' || p_language;
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_safety_phrase_code || ' ' || p_language;
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_safety_phrase_code || ' ' || p_language;
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 487: FND_MESSAGE.SET_NAME('GR',

483: WHEN Language_Missing_Error THEN
484: ROLLBACK TO SAVEPOINT Add_Language;
485: x_return_status := 'E';
486: x_oracle_error := APP_EXCEPTION.Get_Code;
487: FND_MESSAGE.SET_NAME('GR',
488: 'GR_RECORD_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('CODE',
490: l_msg_token,
491: FALSE);

Line 489: FND_MESSAGE.SET_TOKEN('CODE',

485: x_return_status := 'E';
486: x_oracle_error := APP_EXCEPTION.Get_Code;
487: FND_MESSAGE.SET_NAME('GR',
488: 'GR_RECORD_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('CODE',
490: l_msg_token,
491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;

Line 495: x_msg_data := FND_MESSAGE.Get;

491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;
494: ELSE
495: x_msg_data := FND_MESSAGE.Get;
496: END IF;
497:
498: WHEN OTHERS THEN
499: ROLLBACK TO SAVEPOINT Add_Language;

Line 503: FND_MESSAGE.SET_NAME('GR',

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

Line 505: FND_MESSAGE.SET_TOKEN('TEXT',

501: x_oracle_error := SQLCODE;
502: l_msg_data := SUBSTR(SQLERRM, 1, 200);
503: FND_MESSAGE.SET_NAME('GR',
504: 'GR_UNEXPECTED_ERROR');
505: FND_MESSAGE.SET_TOKEN('TEXT',
506: l_msg_token,
507: FALSE);
508: IF FND_API.To_Boolean(p_called_by_form) THEN
509: APP_EXCEPTION.Raise_Exception;

Line 511: x_msg_data := FND_MESSAGE.Get;

507: FALSE);
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: END Add_Language;
515:

Line 591: FND_MESSAGE.SET_NAME('GR',

587:
588: WHEN No_Data_Found_Error THEN
589: ROLLBACK TO SAVEPOINT Lock_Row;
590: x_return_status := 'E';
591: FND_MESSAGE.SET_NAME('GR',
592: 'GR_RECORD_NOT_FOUND');
593: FND_MESSAGE.SET_TOKEN('CODE',
594: l_msg_token,
595: FALSE);

Line 593: FND_MESSAGE.SET_TOKEN('CODE',

589: ROLLBACK TO SAVEPOINT Lock_Row;
590: x_return_status := 'E';
591: FND_MESSAGE.SET_NAME('GR',
592: 'GR_RECORD_NOT_FOUND');
593: FND_MESSAGE.SET_TOKEN('CODE',
594: l_msg_token,
595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;

Line 599: x_msg_data := FND_MESSAGE.Get;

595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;
598: ELSE
599: x_msg_data := FND_MESSAGE.Get;
600: END IF;
601:
602: WHEN RECORD_CHANGED_ERROR THEN
603: ROLLBACK TO SAVEPOINT Lock_Row;

Line 605: FND_MESSAGE.SET_NAME('FND',

601:
602: WHEN RECORD_CHANGED_ERROR THEN
603: ROLLBACK TO SAVEPOINT Lock_Row;
604: X_return_status := 'E';
605: FND_MESSAGE.SET_NAME('FND',
606: 'FORM_RECORD_CHANGED');
607: IF FND_API.To_Boolean(p_called_by_form) THEN
608: APP_EXCEPTION.Raise_Exception;
609: ELSE

Line 610: x_msg_data := FND_MESSAGE.Get;

606: 'FORM_RECORD_CHANGED');
607: IF FND_API.To_Boolean(p_called_by_form) THEN
608: APP_EXCEPTION.Raise_Exception;
609: ELSE
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;
612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';

Line 617: FND_MESSAGE.SET_NAME('GR',

613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';
615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
617: FND_MESSAGE.SET_NAME('GR',
618: 'GR_ROW_IS_LOCKED');
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;
621:

Line 619: x_msg_data := FND_MESSAGE.Get;

615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
617: FND_MESSAGE.SET_NAME('GR',
618: 'GR_ROW_IS_LOCKED');
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;
621:
622:
623: WHEN OTHERS THEN

Line 628: FND_MESSAGE.SET_NAME('GR',

624: ROLLBACK TO SAVEPOINT Lock_Row;
625: x_return_status := 'U';
626: x_oracle_error := SQLCODE;
627: l_msg_data := SUBSTR(SQLERRM, 1, 200);
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('TEXT',
631: l_msg_token,
632: FALSE);

Line 630: FND_MESSAGE.SET_TOKEN('TEXT',

626: x_oracle_error := SQLCODE;
627: l_msg_data := SUBSTR(SQLERRM, 1, 200);
628: FND_MESSAGE.SET_NAME('GR',
629: 'GR_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('TEXT',
631: l_msg_token,
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: END Lock_Row;
640:

Line 724: x_msg_data := FND_MESSAGE.Get;

720: x_msg_data := l_msg_data;
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 Row_Missing_Error THEN
728: ROLLBACK TO SAVEPOINT Delete_Row;

Line 731: FND_MESSAGE.SET_NAME('GR',

727: WHEN Row_Missing_Error THEN
728: ROLLBACK TO SAVEPOINT Delete_Row;
729: x_return_status := 'E';
730: x_oracle_error := APP_EXCEPTION.Get_Code;
731: FND_MESSAGE.SET_NAME('GR',
732: 'GR_RECORD_NOT_FOUND');
733: FND_MESSAGE.SET_TOKEN('CODE',
734: l_msg_token,
735: FALSE);

Line 733: FND_MESSAGE.SET_TOKEN('CODE',

729: x_return_status := 'E';
730: x_oracle_error := APP_EXCEPTION.Get_Code;
731: FND_MESSAGE.SET_NAME('GR',
732: 'GR_RECORD_NOT_FOUND');
733: FND_MESSAGE.SET_TOKEN('CODE',
734: l_msg_token,
735: FALSE);
736: IF FND_API.To_Boolean(p_called_by_form) THEN
737: APP_EXCEPTION.Raise_Exception;

Line 739: x_msg_data := FND_MESSAGE.Get;

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

Line 747: FND_MESSAGE.SET_NAME('GR',

743: ROLLBACK TO SAVEPOINT Delete_Row;
744: x_return_status := 'U';
745: x_oracle_error := SQLCODE;
746: l_msg_data := SUBSTR(SQLERRM, 1, 200);
747: FND_MESSAGE.SET_NAME('GR',
748: 'GR_UNEXPECTED_ERROR');
749: FND_MESSAGE.SET_TOKEN('TEXT',
750: l_msg_token,
751: FALSE);

Line 749: FND_MESSAGE.SET_TOKEN('TEXT',

745: x_oracle_error := SQLCODE;
746: l_msg_data := SUBSTR(SQLERRM, 1, 200);
747: FND_MESSAGE.SET_NAME('GR',
748: 'GR_UNEXPECTED_ERROR');
749: FND_MESSAGE.SET_TOKEN('TEXT',
750: l_msg_token,
751: FALSE);
752: IF FND_API.To_Boolean(p_called_by_form) THEN
753: APP_EXCEPTION.Raise_Exception;

Line 755: x_msg_data := FND_MESSAGE.Get;

751: FALSE);
752: IF FND_API.To_Boolean(p_called_by_form) THEN
753: APP_EXCEPTION.Raise_Exception;
754: ELSE
755: x_msg_data := FND_MESSAGE.Get;
756: END IF;
757:
758: END Delete_Row;
759:

Line 805: FND_MESSAGE.SET_NAME('GR',

801: ROLLBACK TO SAVEPOINT Delete_Rows;
802: x_return_status := 'U';
803: x_oracle_error := SQLCODE;
804: l_msg_data := SUBSTR(SQLERRM, 1, 200);
805: FND_MESSAGE.SET_NAME('GR',
806: 'GR_UNEXPECTED_ERROR');
807: FND_MESSAGE.SET_TOKEN('TEXT',
808: l_msg_token,
809: FALSE);

Line 807: FND_MESSAGE.SET_TOKEN('TEXT',

803: x_oracle_error := SQLCODE;
804: l_msg_data := SUBSTR(SQLERRM, 1, 200);
805: FND_MESSAGE.SET_NAME('GR',
806: 'GR_UNEXPECTED_ERROR');
807: FND_MESSAGE.SET_TOKEN('TEXT',
808: l_msg_token,
809: FALSE);
810: IF FND_API.To_Boolean(p_called_by_form) THEN
811: APP_EXCEPTION.Raise_Exception;

Line 813: x_msg_data := FND_MESSAGE.Get;

809: FALSE);
810: IF FND_API.To_Boolean(p_called_by_form) THEN
811: APP_EXCEPTION.Raise_Exception;
812: ELSE
813: x_msg_data := FND_MESSAGE.Get;
814: END IF;
815:
816: END Delete_Rows;
817:

Line 890: FND_MESSAGE.SET_NAME('GR',

886: WHEN Row_Missing_Error THEN
887: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
888: x_return_status := 'E';
889: x_oracle_error := APP_EXCEPTION.Get_Code;
890: FND_MESSAGE.SET_NAME('GR',
891: 'GR_RECORD_NOT_FOUND');
892: FND_MESSAGE.SET_TOKEN('CODE',
893: l_msg_token,
894: FALSE);

Line 892: FND_MESSAGE.SET_TOKEN('CODE',

888: x_return_status := 'E';
889: x_oracle_error := APP_EXCEPTION.Get_Code;
890: FND_MESSAGE.SET_NAME('GR',
891: 'GR_RECORD_NOT_FOUND');
892: FND_MESSAGE.SET_TOKEN('CODE',
893: l_msg_token,
894: FALSE);
895: x_msg_data := FND_MESSAGE.Get;
896:

Line 895: x_msg_data := FND_MESSAGE.Get;

891: 'GR_RECORD_NOT_FOUND');
892: FND_MESSAGE.SET_TOKEN('CODE',
893: l_msg_token,
894: FALSE);
895: x_msg_data := FND_MESSAGE.Get;
896:
897: WHEN OTHERS THEN
898: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
899: x_return_status := 'U';

Line 902: FND_MESSAGE.SET_NAME('GR',

898: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
899: x_return_status := 'U';
900: x_oracle_error := SQLCODE;
901: l_msg_data := SUBSTR(SQLERRM, 1, 200);
902: FND_MESSAGE.SET_NAME('GR',
903: 'GR_UNEXPECTED_ERROR');
904: FND_MESSAGE.SET_TOKEN('TEXT',
905: l_msg_token,
906: FALSE);

Line 904: FND_MESSAGE.SET_TOKEN('TEXT',

900: x_oracle_error := SQLCODE;
901: l_msg_data := SUBSTR(SQLERRM, 1, 200);
902: FND_MESSAGE.SET_NAME('GR',
903: 'GR_UNEXPECTED_ERROR');
904: FND_MESSAGE.SET_TOKEN('TEXT',
905: l_msg_token,
906: FALSE);
907: x_msg_data := FND_MESSAGE.Get;
908:

Line 907: x_msg_data := FND_MESSAGE.Get;

903: 'GR_UNEXPECTED_ERROR');
904: FND_MESSAGE.SET_TOKEN('TEXT',
905: l_msg_token,
906: FALSE);
907: x_msg_data := FND_MESSAGE.Get;
908:
909: END Check_Foreign_Keys;
910:
911: PROCEDURE Check_Integrity

Line 971: FND_MESSAGE.SET_NAME('GR',

967:
968: WHEN Installed_Language_Error THEN
969: ROLLBACK TO SAVEPOINT Check_Integrity;
970: x_return_status := 'E';
971: FND_MESSAGE.SET_NAME('GR',
972: 'GR_INSTALLED_LANG');
973: FND_MESSAGE.SET_TOKEN('CODE',
974: p_language,
975: FALSE);

Line 973: FND_MESSAGE.SET_TOKEN('CODE',

969: ROLLBACK TO SAVEPOINT Check_Integrity;
970: x_return_status := 'E';
971: FND_MESSAGE.SET_NAME('GR',
972: 'GR_INSTALLED_LANG');
973: FND_MESSAGE.SET_TOKEN('CODE',
974: p_language,
975: FALSE);
976: IF FND_API.To_Boolean(p_called_by_form) THEN
977: APP_EXCEPTION.Raise_Exception;

Line 979: x_msg_data := FND_MESSAGE.Get;

975: FALSE);
976: IF FND_API.To_Boolean(p_called_by_form) THEN
977: APP_EXCEPTION.Raise_Exception;
978: ELSE
979: x_msg_data := FND_MESSAGE.Get;
980: END IF;
981:
982: WHEN OTHERS THEN
983: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 987: FND_MESSAGE.SET_NAME('GR',

983: ROLLBACK TO SAVEPOINT Check_Integrity;
984: x_return_status := 'U';
985: x_oracle_error := SQLCODE;
986: l_msg_data := SUBSTR(SQLERRM, 1, 200);
987: FND_MESSAGE.SET_NAME('GR',
988: 'GR_UNEXPECTED_ERROR');
989: FND_MESSAGE.SET_TOKEN('TEXT',
990: l_msg_data,
991: FALSE);

Line 989: FND_MESSAGE.SET_TOKEN('TEXT',

985: x_oracle_error := SQLCODE;
986: l_msg_data := SUBSTR(SQLERRM, 1, 200);
987: FND_MESSAGE.SET_NAME('GR',
988: 'GR_UNEXPECTED_ERROR');
989: FND_MESSAGE.SET_TOKEN('TEXT',
990: l_msg_data,
991: FALSE);
992: IF FND_API.To_Boolean(p_called_by_form) THEN
993: APP_EXCEPTION.Raise_Exception;

Line 995: x_msg_data := FND_MESSAGE.Get;

991: FALSE);
992: IF FND_API.To_Boolean(p_called_by_form) THEN
993: APP_EXCEPTION.Raise_Exception;
994: ELSE
995: x_msg_data := FND_MESSAGE.Get;
996: END IF;
997:
998: END Check_Integrity;
999:

Line 1047: FND_MESSAGE.SET_NAME('GR',

1043: EXCEPTION
1044:
1045: WHEN Others THEN
1046: l_msg_data := SQLCODE;
1047: FND_MESSAGE.SET_NAME('GR',
1048: 'GR_UNEXPECTED_ERROR');
1049: FND_MESSAGE.SET_TOKEN('TEXT',
1050: l_msg_data,
1051: FALSE);

Line 1049: FND_MESSAGE.SET_TOKEN('TEXT',

1045: WHEN Others THEN
1046: l_msg_data := SQLCODE;
1047: FND_MESSAGE.SET_NAME('GR',
1048: 'GR_UNEXPECTED_ERROR');
1049: FND_MESSAGE.SET_TOKEN('TEXT',
1050: l_msg_data,
1051: FALSE);
1052: IF FND_API.To_Boolean(p_called_by_form) THEN
1053: APP_EXCEPTION.Raise_Exception;