DBA Data[Home] [Help]

APPS.GR_ITEM_GROUPS_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_item_group_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_item_group_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_item_group_code || ' ' || p_language;
170: x_return_status := 'U';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: l_msg_data := APP_EXCEPTION.Get_Text;
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 := APP_EXCEPTION.Get_Code;
172: l_msg_data := APP_EXCEPTION.Get_Text;
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 := APP_EXCEPTION.Get_Code;
301: l_msg_data := APP_EXCEPTION.Get_Text;
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 := APP_EXCEPTION.Get_Code;
301: l_msg_data := APP_EXCEPTION.Get_Text;
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 486: FND_MESSAGE.SET_NAME('GR',

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

Line 488: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 494: x_msg_data := FND_MESSAGE.Get;

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

Line 501: FND_MESSAGE.SET_NAME('GR',

497: WHEN OTHERS THEN
498: ROLLBACK TO SAVEPOINT Add_Language;
499: x_return_status := 'U';
500: x_oracle_error := APP_EXCEPTION.Get_Code;
501: FND_MESSAGE.SET_NAME('GR',
502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_token,
505: FALSE);

Line 503: FND_MESSAGE.SET_TOKEN('TEXT',

499: x_return_status := 'U';
500: x_oracle_error := APP_EXCEPTION.Get_Code;
501: FND_MESSAGE.SET_NAME('GR',
502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_token,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;

Line 509: x_msg_data := FND_MESSAGE.Get;

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

Line 587: FND_MESSAGE.SET_NAME('GR',

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

Line 589: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 595: x_msg_data := FND_MESSAGE.Get;

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

Line 602: FND_MESSAGE.SET_NAME('GR',

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

Line 607: x_msg_data := FND_MESSAGE.Get;

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

Line 615: FND_MESSAGE.SET_NAME('GR',

611: ROLLBACK TO SAVEPOINT Lock_Row;
612: x_return_status := 'U';
613: x_oracle_error := APP_EXCEPTION.Get_Code;
614: l_msg_data := APP_EXCEPTION.Get_Text;
615: FND_MESSAGE.SET_NAME('GR',
616: 'GR_UNEXPECTED_ERROR');
617: FND_MESSAGE.SET_TOKEN('TEXT',
618: l_msg_token,
619: FALSE);

Line 617: FND_MESSAGE.SET_TOKEN('TEXT',

613: x_oracle_error := APP_EXCEPTION.Get_Code;
614: l_msg_data := APP_EXCEPTION.Get_Text;
615: FND_MESSAGE.SET_NAME('GR',
616: 'GR_UNEXPECTED_ERROR');
617: FND_MESSAGE.SET_TOKEN('TEXT',
618: l_msg_token,
619: FALSE);
620: IF FND_API.To_Boolean(p_called_by_form) THEN
621: APP_EXCEPTION.Raise_Exception;

Line 623: x_msg_data := FND_MESSAGE.Get;

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

Line 718: x_msg_data := FND_MESSAGE.Get;

714: x_oracle_error := l_oracle_error;
715: IF FND_API.To_Boolean(p_called_by_form) THEN
716: APP_EXCEPTION.Raise_Exception;
717: ELSE
718: x_msg_data := FND_MESSAGE.Get;
719: END IF;
720:
721: WHEN Row_Missing_Error THEN
722: ROLLBACK TO SAVEPOINT Delete_Row;

Line 725: FND_MESSAGE.SET_NAME('GR',

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

Line 727: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 733: x_msg_data := FND_MESSAGE.Get;

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

Line 742: FND_MESSAGE.SET_NAME('GR',

738: x_return_status := 'U';
739: x_oracle_error := APP_EXCEPTION.Get_Code;
740: l_msg_data := APP_EXCEPTION.Get_Text;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_token,
746: FALSE);

Line 744: FND_MESSAGE.SET_TOKEN('TEXT',

740: l_msg_data := APP_EXCEPTION.Get_Text;
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_token,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;

Line 750: x_msg_data := FND_MESSAGE.Get;

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

Line 800: FND_MESSAGE.SET_NAME('GR',

796: ROLLBACK TO SAVEPOINT Delete_Rows;
797: x_return_status := 'U';
798: x_oracle_error := APP_EXCEPTION.Get_Code;
799: l_msg_data := APP_EXCEPTION.Get_Text;
800: FND_MESSAGE.SET_NAME('GR',
801: 'GR_UNEXPECTED_ERROR');
802: FND_MESSAGE.SET_TOKEN('TEXT',
803: l_msg_token,
804: FALSE);

Line 802: FND_MESSAGE.SET_TOKEN('TEXT',

798: x_oracle_error := APP_EXCEPTION.Get_Code;
799: l_msg_data := APP_EXCEPTION.Get_Text;
800: FND_MESSAGE.SET_NAME('GR',
801: 'GR_UNEXPECTED_ERROR');
802: FND_MESSAGE.SET_TOKEN('TEXT',
803: l_msg_token,
804: FALSE);
805: IF FND_API.To_Boolean(p_called_by_form) THEN
806: APP_EXCEPTION.Raise_Exception;

Line 808: x_msg_data := FND_MESSAGE.Get;

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

Line 862: FND_MESSAGE.SET_NAME('GR',

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

Line 864: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 867: l_msg_data := FND_MESSAGE.Get;

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

Line 878: FND_MESSAGE.SET_NAME('GR',

874: IF c_get_language%NOTFOUND THEN
875: l_msg_token := l_language_code;
876: x_return_status := 'E';
877: x_oracle_error := APP_EXCEPTION.Get_Code;
878: FND_MESSAGE.SET_NAME('GR',
879: 'GR_RECORD_NOT_FOUND');
880: FND_MESSAGE.SET_TOKEN('CODE',
881: l_msg_token,
882: FALSE);

Line 880: FND_MESSAGE.SET_TOKEN('CODE',

876: x_return_status := 'E';
877: x_oracle_error := APP_EXCEPTION.Get_Code;
878: FND_MESSAGE.SET_NAME('GR',
879: 'GR_RECORD_NOT_FOUND');
880: FND_MESSAGE.SET_TOKEN('CODE',
881: l_msg_token,
882: FALSE);
883: l_msg_data := FND_MESSAGE.Get;
884: END IF;

Line 883: l_msg_data := FND_MESSAGE.Get;

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

Line 898: FND_MESSAGE.SET_NAME('GR',

894: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
895: x_return_status := 'U';
896: x_oracle_error := APP_EXCEPTION.Get_Code;
897: l_msg_data := APP_EXCEPTION.Get_Text;
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_UNEXPECTED_ERROR');
900: FND_MESSAGE.SET_TOKEN('TEXT',
901: l_msg_token,
902: FALSE);

Line 900: FND_MESSAGE.SET_TOKEN('TEXT',

896: x_oracle_error := APP_EXCEPTION.Get_Code;
897: l_msg_data := APP_EXCEPTION.Get_Text;
898: FND_MESSAGE.SET_NAME('GR',
899: 'GR_UNEXPECTED_ERROR');
900: FND_MESSAGE.SET_TOKEN('TEXT',
901: l_msg_token,
902: FALSE);
903: x_msg_data := FND_MESSAGE.Get;
904:

Line 903: x_msg_data := FND_MESSAGE.Get;

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

Line 967: FND_MESSAGE.SET_NAME('GR',

963:
964: WHEN Installed_Language_Error THEN
965: ROLLBACK TO SAVEPOINT Check_Integrity;
966: x_return_status := 'E';
967: FND_MESSAGE.SET_NAME('GR',
968: 'GR_INSTALLED_LANG');
969: FND_MESSAGE.SET_TOKEN('CODE',
970: p_language,
971: FALSE);

Line 969: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 975: x_msg_data := FND_MESSAGE.Get;

971: FALSE);
972: IF FND_API.To_Boolean(p_called_by_form) THEN
973: APP_EXCEPTION.Raise_Exception;
974: ELSE
975: x_msg_data := FND_MESSAGE.Get;
976: END IF;
977:
978: WHEN OTHERS THEN
979: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 983: FND_MESSAGE.SET_NAME('GR',

979: ROLLBACK TO SAVEPOINT Check_Integrity;
980: x_return_status := 'U';
981: x_oracle_error := APP_EXCEPTION.Get_Code;
982: l_msg_data := APP_EXCEPTION.Get_Text;
983: FND_MESSAGE.SET_NAME('GR',
984: 'GR_UNEXPECTED_ERROR');
985: FND_MESSAGE.SET_TOKEN('TEXT',
986: l_msg_data,
987: FALSE);

Line 985: FND_MESSAGE.SET_TOKEN('TEXT',

981: x_oracle_error := APP_EXCEPTION.Get_Code;
982: l_msg_data := APP_EXCEPTION.Get_Text;
983: FND_MESSAGE.SET_NAME('GR',
984: 'GR_UNEXPECTED_ERROR');
985: FND_MESSAGE.SET_TOKEN('TEXT',
986: l_msg_data,
987: FALSE);
988: IF FND_API.To_Boolean(p_called_by_form) THEN
989: APP_EXCEPTION.Raise_Exception;

Line 991: x_msg_data := FND_MESSAGE.Get;

987: FALSE);
988: IF FND_API.To_Boolean(p_called_by_form) THEN
989: APP_EXCEPTION.Raise_Exception;
990: ELSE
991: x_msg_data := FND_MESSAGE.Get;
992: END IF;
993:
994: END Check_Integrity;
995:

Line 1043: FND_MESSAGE.SET_NAME('GR',

1039: EXCEPTION
1040:
1041: WHEN Others THEN
1042: l_msg_data := APP_EXCEPTION.Get_Text;
1043: FND_MESSAGE.SET_NAME('GR',
1044: 'GR_UNEXPECTED_ERROR');
1045: FND_MESSAGE.SET_TOKEN('TEXT',
1046: l_msg_data,
1047: FALSE);

Line 1045: FND_MESSAGE.SET_TOKEN('TEXT',

1041: WHEN Others THEN
1042: l_msg_data := APP_EXCEPTION.Get_Text;
1043: FND_MESSAGE.SET_NAME('GR',
1044: 'GR_UNEXPECTED_ERROR');
1045: FND_MESSAGE.SET_TOKEN('TEXT',
1046: l_msg_data,
1047: FALSE);
1048: IF FND_API.To_Boolean(p_called_by_form) THEN
1049: APP_EXCEPTION.Raise_Exception;