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

Line 168: FND_MESSAGE.SET_NAME('GR',

164: WHEN Foreign_Key_Error THEN
165: ROLLBACK TO SAVEPOINT Insert_Row;
166: x_return_status := l_return_status;
167: x_oracle_error := l_oracle_error;
168: FND_MESSAGE.SET_NAME('GR',
169: 'GR_FOREIGN_KEY_ERROR');
170: FND_MESSAGE.SET_TOKEN('TEXT',
171: l_msg_data,
172: FALSE);

Line 170: FND_MESSAGE.SET_TOKEN('TEXT',

166: x_return_status := l_return_status;
167: x_oracle_error := l_oracle_error;
168: FND_MESSAGE.SET_NAME('GR',
169: 'GR_FOREIGN_KEY_ERROR');
170: FND_MESSAGE.SET_TOKEN('TEXT',
171: l_msg_data,
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 Item_Exists_Error THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;

Line 183: FND_MESSAGE.SET_NAME('GR',

179: WHEN Item_Exists_Error THEN
180: ROLLBACK TO SAVEPOINT Insert_Row;
181: x_return_status := 'E';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: FND_MESSAGE.SET_NAME('GR',
184: 'GR_RECORD_EXISTS');
185: FND_MESSAGE.SET_TOKEN('CODE',
186: p_item_code,
187: FALSE);

Line 185: FND_MESSAGE.SET_TOKEN('CODE',

181: x_return_status := 'E';
182: x_oracle_error := APP_EXCEPTION.Get_Code;
183: FND_MESSAGE.SET_NAME('GR',
184: 'GR_RECORD_EXISTS');
185: FND_MESSAGE.SET_TOKEN('CODE',
186: p_item_code,
187: FALSE);
188: IF FND_API.To_Boolean(p_called_by_form) THEN
189: APP_EXCEPTION.Raise_Exception;

Line 191: x_msg_data := FND_MESSAGE.Get;

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

Line 198: FND_MESSAGE.SET_NAME('GR',

194: WHEN Row_Missing_Error THEN
195: ROLLBACK TO SAVEPOINT Insert_Row;
196: x_return_status := 'E';
197: x_oracle_error := APP_EXCEPTION.Get_Code;
198: FND_MESSAGE.SET_NAME('GR',
199: 'GR_NO_RECORD_INSERTED');
200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);

Line 200: FND_MESSAGE.SET_TOKEN('CODE',

196: x_return_status := 'E';
197: x_oracle_error := APP_EXCEPTION.Get_Code;
198: FND_MESSAGE.SET_NAME('GR',
199: 'GR_NO_RECORD_INSERTED');
200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);
203: x_msg_data := FND_MESSAGE.Get;
204: IF FND_API.To_Boolean(p_called_by_form) THEN

Line 203: x_msg_data := FND_MESSAGE.Get;

199: 'GR_NO_RECORD_INSERTED');
200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);
203: x_msg_data := FND_MESSAGE.Get;
204: IF FND_API.To_Boolean(p_called_by_form) THEN
205: APP_EXCEPTION.Raise_Exception;
206: ELSE
207: x_msg_data := FND_MESSAGE.Get;

Line 207: x_msg_data := FND_MESSAGE.Get;

203: x_msg_data := FND_MESSAGE.Get;
204: IF FND_API.To_Boolean(p_called_by_form) THEN
205: APP_EXCEPTION.Raise_Exception;
206: ELSE
207: x_msg_data := FND_MESSAGE.Get;
208: END IF;
209:
210: WHEN OTHERS THEN
211: ROLLBACK TO SAVEPOINT Insert_Row;

Line 215: FND_MESSAGE.SET_NAME('GR',

211: ROLLBACK TO SAVEPOINT Insert_Row;
212: x_return_status := 'U';
213: x_oracle_error := SQLCODE;
214: l_msg_data := SUBSTR(SQLERRM, 1, 200);
215: FND_MESSAGE.SET_NAME('GR',
216: 'GR_UNEXPECTED_ERROR');
217: FND_MESSAGE.SET_TOKEN('TEXT',
218: l_msg_data,
219: FALSE);

Line 217: FND_MESSAGE.SET_TOKEN('TEXT',

213: x_oracle_error := SQLCODE;
214: l_msg_data := SUBSTR(SQLERRM, 1, 200);
215: FND_MESSAGE.SET_NAME('GR',
216: 'GR_UNEXPECTED_ERROR');
217: FND_MESSAGE.SET_TOKEN('TEXT',
218: l_msg_data,
219: FALSE);
220: IF FND_API.To_Boolean(p_called_by_form) THEN
221: APP_EXCEPTION.Raise_Exception;

Line 223: x_msg_data := FND_MESSAGE.Get;

219: FALSE);
220: IF FND_API.To_Boolean(p_called_by_form) THEN
221: APP_EXCEPTION.Raise_Exception;
222: ELSE
223: x_msg_data := FND_MESSAGE.Get;
224: END IF;
225:
226: END Insert_Row;
227:

Line 347: FND_MESSAGE.SET_NAME('GR',

343: WHEN Foreign_Key_Error THEN
344: ROLLBACK TO SAVEPOINT Update_Row;
345: x_return_status := l_return_status;
346: x_oracle_error := l_oracle_error;
347: FND_MESSAGE.SET_NAME('GR',
348: 'GR_FOREIGN_KEY_ERROR');
349: FND_MESSAGE.SET_TOKEN('TEXT',
350: l_msg_data,
351: FALSE);

Line 349: FND_MESSAGE.SET_TOKEN('TEXT',

345: x_return_status := l_return_status;
346: x_oracle_error := l_oracle_error;
347: FND_MESSAGE.SET_NAME('GR',
348: 'GR_FOREIGN_KEY_ERROR');
349: FND_MESSAGE.SET_TOKEN('TEXT',
350: l_msg_data,
351: FALSE);
352: IF FND_API.To_Boolean(p_called_by_form) THEN
353: APP_EXCEPTION.Raise_Exception;

Line 355: x_msg_data := FND_MESSAGE.Get;

351: FALSE);
352: IF FND_API.To_Boolean(p_called_by_form) THEN
353: APP_EXCEPTION.Raise_Exception;
354: ELSE
355: x_msg_data := FND_MESSAGE.Get;
356: END IF;
357:
358: WHEN Row_Missing_Error THEN
359: ROLLBACK TO SAVEPOINT Update_Row;

Line 362: FND_MESSAGE.SET_NAME('GR',

358: WHEN Row_Missing_Error THEN
359: ROLLBACK TO SAVEPOINT Update_Row;
360: x_return_status := 'E';
361: x_oracle_error := APP_EXCEPTION.Get_Code;
362: FND_MESSAGE.SET_NAME('GR',
363: 'GR_NO_RECORD_INSERTED');
364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_item_code,
366: FALSE);

Line 364: FND_MESSAGE.SET_TOKEN('CODE',

360: x_return_status := 'E';
361: x_oracle_error := APP_EXCEPTION.Get_Code;
362: FND_MESSAGE.SET_NAME('GR',
363: 'GR_NO_RECORD_INSERTED');
364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_item_code,
366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;

Line 370: x_msg_data := FND_MESSAGE.Get;

366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;
369: ELSE
370: x_msg_data := FND_MESSAGE.Get;
371: END IF;
372:
373: WHEN OTHERS THEN
374: ROLLBACK TO SAVEPOINT Update_Row;

Line 378: FND_MESSAGE.SET_NAME('GR',

374: ROLLBACK TO SAVEPOINT Update_Row;
375: x_return_status := 'U';
376: x_oracle_error := SQLCODE;
377: l_msg_data := SUBSTR(SQLERRM, 1, 200);
378: FND_MESSAGE.SET_NAME('GR',
379: 'GR_UNEXPECTED_ERROR');
380: FND_MESSAGE.SET_TOKEN('TEXT',
381: l_msg_data,
382: FALSE);

Line 380: FND_MESSAGE.SET_TOKEN('TEXT',

376: x_oracle_error := SQLCODE;
377: l_msg_data := SUBSTR(SQLERRM, 1, 200);
378: FND_MESSAGE.SET_NAME('GR',
379: 'GR_UNEXPECTED_ERROR');
380: FND_MESSAGE.SET_TOKEN('TEXT',
381: l_msg_data,
382: FALSE);
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;

Line 386: x_msg_data := FND_MESSAGE.Get;

382: FALSE);
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;
385: ELSE
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;
388:
389: END Update_Row;
390:

Line 598: FND_MESSAGE.SET_NAME('GR',

594: WHEN Language_Missing_Error THEN
595: ROLLBACK TO SAVEPOINT Add_Language;
596: x_return_status := 'E';
597: x_oracle_error := APP_EXCEPTION.Get_Code;
598: FND_MESSAGE.SET_NAME('GR',
599: 'GR_RECORD_NOT_FOUND');
600: FND_MESSAGE.SET_TOKEN('CODE',
601: l_msg_token,
602: FALSE);

Line 600: FND_MESSAGE.SET_TOKEN('CODE',

596: x_return_status := 'E';
597: x_oracle_error := APP_EXCEPTION.Get_Code;
598: FND_MESSAGE.SET_NAME('GR',
599: 'GR_RECORD_NOT_FOUND');
600: FND_MESSAGE.SET_TOKEN('CODE',
601: l_msg_token,
602: FALSE);
603: IF FND_API.To_Boolean(p_called_by_form) THEN
604: APP_EXCEPTION.Raise_Exception;

Line 606: x_msg_data := FND_MESSAGE.Get;

602: FALSE);
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 Add_Language;

Line 614: FND_MESSAGE.SET_NAME('GR',

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

Line 616: FND_MESSAGE.SET_TOKEN('TEXT',

612: x_oracle_error := SQLCODE;
613:
614: FND_MESSAGE.SET_NAME('GR',
615: 'GR_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('TEXT',
617: l_msg_token||SQLERRM,
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 Add_Language;
626:

Line 733: FND_MESSAGE.SET_NAME('GR',

729:
730: WHEN No_Data_Found_Error THEN
731: ROLLBACK TO SAVEPOINT Lock_Row;
732: x_return_status := 'E';
733: FND_MESSAGE.SET_NAME('GR',
734: 'GR_RECORD_NOT_FOUND');
735: FND_MESSAGE.SET_TOKEN('CODE',
736: p_item_code,
737: FALSE);

Line 735: FND_MESSAGE.SET_TOKEN('CODE',

731: ROLLBACK TO SAVEPOINT Lock_Row;
732: x_return_status := 'E';
733: FND_MESSAGE.SET_NAME('GR',
734: 'GR_RECORD_NOT_FOUND');
735: FND_MESSAGE.SET_TOKEN('CODE',
736: p_item_code,
737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;

Line 741: x_msg_data := FND_MESSAGE.Get;

737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;
740: ELSE
741: x_msg_data := FND_MESSAGE.Get;
742: END IF;
743: WHEN RECORD_CHANGED_ERROR THEN
744: ROLLBACK TO SAVEPOINT Lock_Row;
745: X_return_status := 'E';

Line 746: FND_MESSAGE.SET_NAME('FND',

742: END IF;
743: WHEN RECORD_CHANGED_ERROR THEN
744: ROLLBACK TO SAVEPOINT Lock_Row;
745: X_return_status := 'E';
746: FND_MESSAGE.SET_NAME('FND',
747: 'FORM_RECORD_CHANGED');
748: IF FND_API.To_Boolean(p_called_by_form) THEN
749: APP_EXCEPTION.Raise_Exception;
750: ELSE

Line 751: x_msg_data := FND_MESSAGE.Get;

747: 'FORM_RECORD_CHANGED');
748: IF FND_API.To_Boolean(p_called_by_form) THEN
749: APP_EXCEPTION.Raise_Exception;
750: ELSE
751: x_msg_data := FND_MESSAGE.Get;
752: END IF;
753: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
754: ROLLBACK TO SAVEPOINT Lock_Row;
755: x_return_status := 'L';

Line 758: FND_MESSAGE.SET_NAME('GR',

754: ROLLBACK TO SAVEPOINT Lock_Row;
755: x_return_status := 'L';
756: x_oracle_error := APP_EXCEPTION.Get_Code;
757: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
758: FND_MESSAGE.SET_NAME('GR',
759: 'GR_ROW_IS_LOCKED');
760: x_msg_data := FND_MESSAGE.Get;
761: END IF;
762: WHEN OTHERS THEN

Line 760: x_msg_data := FND_MESSAGE.Get;

756: x_oracle_error := APP_EXCEPTION.Get_Code;
757: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
758: FND_MESSAGE.SET_NAME('GR',
759: 'GR_ROW_IS_LOCKED');
760: x_msg_data := FND_MESSAGE.Get;
761: END IF;
762: WHEN OTHERS THEN
763: ROLLBACK TO SAVEPOINT Lock_Row;
764: x_return_status := 'U';

Line 767: FND_MESSAGE.SET_NAME('GR',

763: ROLLBACK TO SAVEPOINT Lock_Row;
764: x_return_status := 'U';
765: x_oracle_error := SQLCODE;
766: l_msg_data := SUBSTR(SQLERRM, 1, 200);
767: FND_MESSAGE.SET_NAME('GR',
768: 'GR_UNEXPECTED_ERROR');
769: FND_MESSAGE.SET_TOKEN('TEXT',
770: l_msg_data,
771: FALSE);

Line 769: FND_MESSAGE.SET_TOKEN('TEXT',

765: x_oracle_error := SQLCODE;
766: l_msg_data := SUBSTR(SQLERRM, 1, 200);
767: FND_MESSAGE.SET_NAME('GR',
768: 'GR_UNEXPECTED_ERROR');
769: FND_MESSAGE.SET_TOKEN('TEXT',
770: l_msg_data,
771: FALSE);
772: IF FND_API.To_Boolean(p_called_by_form) THEN
773: APP_EXCEPTION.Raise_Exception;

Line 775: x_msg_data := FND_MESSAGE.Get;

771: FALSE);
772: IF FND_API.To_Boolean(p_called_by_form) THEN
773: APP_EXCEPTION.Raise_Exception;
774: ELSE
775: x_msg_data := FND_MESSAGE.Get;
776: END IF;
777:
778: END Lock_Row;
779:

Line 856: FND_MESSAGE.SET_NAME('GR',

852: WHEN Row_Missing_Error THEN
853: ROLLBACK TO SAVEPOINT Delete_Row;
854: x_return_status := 'E';
855: x_oracle_error := APP_EXCEPTION.Get_Code;
856: FND_MESSAGE.SET_NAME('GR',
857: 'GR_RECORD_NOT_FOUND');
858: FND_MESSAGE.SET_TOKEN('CODE',
859: p_item_code,
860: FALSE);

Line 858: FND_MESSAGE.SET_TOKEN('CODE',

854: x_return_status := 'E';
855: x_oracle_error := APP_EXCEPTION.Get_Code;
856: FND_MESSAGE.SET_NAME('GR',
857: 'GR_RECORD_NOT_FOUND');
858: FND_MESSAGE.SET_TOKEN('CODE',
859: p_item_code,
860: FALSE);
861: IF FND_API.To_Boolean(p_called_by_form) THEN
862: APP_EXCEPTION.Raise_Exception;

Line 864: x_msg_data := FND_MESSAGE.Get;

860: FALSE);
861: IF FND_API.To_Boolean(p_called_by_form) THEN
862: APP_EXCEPTION.Raise_Exception;
863: ELSE
864: x_msg_data := FND_MESSAGE.Get;
865: END IF;
866:
867: WHEN OTHERS THEN
868: ROLLBACK TO SAVEPOINT Delete_Row;

Line 872: FND_MESSAGE.SET_NAME('GR',

868: ROLLBACK TO SAVEPOINT Delete_Row;
869: x_return_status := 'U';
870: x_oracle_error := SQLCODE;
871: l_msg_data := SUBSTR(SQLERRM, 1, 200);
872: FND_MESSAGE.SET_NAME('GR',
873: 'GR_UNEXPECTED_ERROR');
874: FND_MESSAGE.SET_TOKEN('TEXT',
875: l_msg_data,
876: FALSE);

Line 874: FND_MESSAGE.SET_TOKEN('TEXT',

870: x_oracle_error := SQLCODE;
871: l_msg_data := SUBSTR(SQLERRM, 1, 200);
872: FND_MESSAGE.SET_NAME('GR',
873: 'GR_UNEXPECTED_ERROR');
874: FND_MESSAGE.SET_TOKEN('TEXT',
875: l_msg_data,
876: FALSE);
877: IF FND_API.To_Boolean(p_called_by_form) THEN
878: APP_EXCEPTION.Raise_Exception;

Line 880: x_msg_data := FND_MESSAGE.Get;

876: FALSE);
877: IF FND_API.To_Boolean(p_called_by_form) THEN
878: APP_EXCEPTION.Raise_Exception;
879: ELSE
880: x_msg_data := FND_MESSAGE.Get;
881: END IF;
882:
883: END Delete_Row;
884:

Line 952: FND_MESSAGE.SET_NAME('GR',

948: ROLLBACK TO SAVEPOINT Delete_Rows;
949: x_return_status := 'U';
950: x_oracle_error := SQLCODE;
951: l_msg_data := SUBSTR(SQLERRM, 1, 200);
952: FND_MESSAGE.SET_NAME('GR',
953: 'GR_UNEXPECTED_ERROR');
954: FND_MESSAGE.SET_TOKEN('TEXT',
955: l_msg_token||SQLERRM,
956: FALSE);

Line 954: FND_MESSAGE.SET_TOKEN('TEXT',

950: x_oracle_error := SQLCODE;
951: l_msg_data := SUBSTR(SQLERRM, 1, 200);
952: FND_MESSAGE.SET_NAME('GR',
953: 'GR_UNEXPECTED_ERROR');
954: FND_MESSAGE.SET_TOKEN('TEXT',
955: l_msg_token||SQLERRM,
956: FALSE);
957: IF FND_API.To_Boolean(p_called_by_form) THEN
958: APP_EXCEPTION.Raise_Exception;

Line 960: x_msg_data := FND_MESSAGE.Get;

956: FALSE);
957: IF FND_API.To_Boolean(p_called_by_form) THEN
958: APP_EXCEPTION.Raise_Exception;
959: ELSE
960: x_msg_data := FND_MESSAGE.Get;
961: END IF;
962:
963: END Delete_Rows;
964:

Line 1038: FND_MESSAGE.SET_NAME('GR',

1034: IF c_get_language%NOTFOUND THEN
1035: l_msg_token := l_language_code;
1036: x_return_status := 'E';
1037: x_oracle_error := APP_EXCEPTION.Get_Code;
1038: FND_MESSAGE.SET_NAME('GR',
1039: 'GR_RECORD_NOT_FOUND');
1040: FND_MESSAGE.SET_TOKEN('CODE',
1041: l_msg_token,
1042: FALSE);

Line 1040: FND_MESSAGE.SET_TOKEN('CODE',

1036: x_return_status := 'E';
1037: x_oracle_error := APP_EXCEPTION.Get_Code;
1038: FND_MESSAGE.SET_NAME('GR',
1039: 'GR_RECORD_NOT_FOUND');
1040: FND_MESSAGE.SET_TOKEN('CODE',
1041: l_msg_token,
1042: FALSE);
1043: l_msg_data := FND_MESSAGE.Get;
1044: END IF;

Line 1043: l_msg_data := FND_MESSAGE.Get;

1039: 'GR_RECORD_NOT_FOUND');
1040: FND_MESSAGE.SET_TOKEN('CODE',
1041: l_msg_token,
1042: FALSE);
1043: l_msg_data := FND_MESSAGE.Get;
1044: END IF;
1045: CLOSE c_get_language;
1046:
1047: l_language_code := p_source_lang;

Line 1054: FND_MESSAGE.SET_NAME('GR',

1050: IF c_get_language%NOTFOUND THEN
1051: l_msg_token := l_language_code;
1052: x_return_status := 'E';
1053: x_oracle_error := APP_EXCEPTION.Get_Code;
1054: FND_MESSAGE.SET_NAME('GR',
1055: 'GR_RECORD_NOT_FOUND');
1056: FND_MESSAGE.SET_TOKEN('CODE',
1057: l_msg_token,
1058: FALSE);

Line 1056: FND_MESSAGE.SET_TOKEN('CODE',

1052: x_return_status := 'E';
1053: x_oracle_error := APP_EXCEPTION.Get_Code;
1054: FND_MESSAGE.SET_NAME('GR',
1055: 'GR_RECORD_NOT_FOUND');
1056: FND_MESSAGE.SET_TOKEN('CODE',
1057: l_msg_token,
1058: FALSE);
1059: l_msg_data := FND_MESSAGE.Get;
1060: END IF;

Line 1059: l_msg_data := FND_MESSAGE.Get;

1055: 'GR_RECORD_NOT_FOUND');
1056: FND_MESSAGE.SET_TOKEN('CODE',
1057: l_msg_token,
1058: FALSE);
1059: l_msg_data := FND_MESSAGE.Get;
1060: END IF;
1061: CLOSE c_get_language;
1062:
1063: IF x_return_status <> 'S' THEN

Line 1075: FND_MESSAGE.SET_NAME('GR',

1071: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1072: x_return_status := 'U';
1073: x_oracle_error := SQLCODE;
1074: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1075: FND_MESSAGE.SET_NAME('GR',
1076: 'GR_UNEXPECTED_ERROR');
1077: FND_MESSAGE.SET_TOKEN('TEXT',
1078: l_msg_data,
1079: FALSE);

Line 1077: FND_MESSAGE.SET_TOKEN('TEXT',

1073: x_oracle_error := SQLCODE;
1074: l_msg_data := SUBSTR(SQLERRM, 1, 200);
1075: FND_MESSAGE.SET_NAME('GR',
1076: 'GR_UNEXPECTED_ERROR');
1077: FND_MESSAGE.SET_TOKEN('TEXT',
1078: l_msg_data,
1079: FALSE);
1080: x_msg_data := FND_MESSAGE.Get;
1081:

Line 1080: x_msg_data := FND_MESSAGE.Get;

1076: 'GR_UNEXPECTED_ERROR');
1077: FND_MESSAGE.SET_TOKEN('TEXT',
1078: l_msg_data,
1079: FALSE);
1080: x_msg_data := FND_MESSAGE.Get;
1081:
1082: END Check_Foreign_Keys;
1083:
1084:

Line 1144: FND_MESSAGE.SET_NAME('GR',

1140: EXCEPTION
1141:
1142: WHEN Others THEN
1143: l_msg_data := sqlerrm;
1144: FND_MESSAGE.SET_NAME('GR',
1145: 'GR_UNEXPECTED_ERROR');
1146: FND_MESSAGE.SET_TOKEN('TEXT',
1147: l_msg_data,
1148: FALSE);

Line 1146: FND_MESSAGE.SET_TOKEN('TEXT',

1142: WHEN Others THEN
1143: l_msg_data := sqlerrm;
1144: FND_MESSAGE.SET_NAME('GR',
1145: 'GR_UNEXPECTED_ERROR');
1146: FND_MESSAGE.SET_TOKEN('TEXT',
1147: l_msg_data,
1148: FALSE);
1149: IF FND_API.To_Boolean(p_called_by_form) THEN
1150: APP_EXCEPTION.Raise_Exception;