DBA Data[Home] [Help]

APPS.GR_PHRASE_GROUP_ASSOC_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 139: FND_MESSAGE.SET_NAME('GR',

135: WHEN Item_Exists_Error THEN
136: ROLLBACK TO SAVEPOINT Insert_Row;
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: p_phrase_group_code || ' ' || p_phrase_code,
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: p_phrase_group_code || ' ' || p_phrase_code,
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 154: FND_MESSAGE.SET_NAME('GR',

150: WHEN Row_Missing_Error THEN
151: ROLLBACK TO SAVEPOINT Insert_Row;
152: x_return_status := 'E';
153: x_oracle_error := APP_EXCEPTION.Get_Code;
154: FND_MESSAGE.SET_NAME('GR',
155: 'GR_NO_RECORD_INSERTED');
156: FND_MESSAGE.SET_TOKEN('CODE',
157: p_phrase_group_code || ' ' || p_phrase_code,
158: FALSE);

Line 156: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 162: x_msg_data := FND_MESSAGE.Get;

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

Line 170: FND_MESSAGE.SET_NAME('GR',

166: ROLLBACK TO SAVEPOINT Insert_Row;
167: x_return_status := 'U';
168: x_oracle_error := APP_EXCEPTION.Get_Code;
169: l_msg_data := APP_EXCEPTION.Get_Text;
170: FND_MESSAGE.SET_NAME('GR',
171: 'GR_UNEXPECTED_ERROR');
172: FND_MESSAGE.SET_TOKEN('TEXT',
173: l_msg_data,
174: FALSE);

Line 172: FND_MESSAGE.SET_TOKEN('TEXT',

168: x_oracle_error := APP_EXCEPTION.Get_Code;
169: l_msg_data := APP_EXCEPTION.Get_Text;
170: FND_MESSAGE.SET_NAME('GR',
171: 'GR_UNEXPECTED_ERROR');
172: FND_MESSAGE.SET_TOKEN('TEXT',
173: l_msg_data,
174: FALSE);
175: IF FND_API.To_Boolean(p_called_by_form) THEN
176: APP_EXCEPTION.Raise_Exception;

Line 178: x_msg_data := FND_MESSAGE.Get;

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

Line 266: FND_MESSAGE.SET_NAME('GR',

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

Line 268: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 274: x_msg_data := FND_MESSAGE.Get;

270: FALSE);
271: IF FND_API.To_Boolean(p_called_by_form) THEN
272: APP_EXCEPTION.Raise_Exception;
273: ELSE
274: x_msg_data := FND_MESSAGE.Get;
275: END IF;
276:
277: WHEN Row_Missing_Error THEN
278: ROLLBACK TO SAVEPOINT Update_Row;

Line 281: FND_MESSAGE.SET_NAME('GR',

277: WHEN Row_Missing_Error THEN
278: ROLLBACK TO SAVEPOINT Update_Row;
279: x_return_status := 'E';
280: x_oracle_error := APP_EXCEPTION.Get_Code;
281: FND_MESSAGE.SET_NAME('GR',
282: 'GR_NO_RECORD_INSERTED');
283: FND_MESSAGE.SET_TOKEN('CODE',
284: p_phrase_group_code || ' ' || p_phrase_code,
285: FALSE);

Line 283: FND_MESSAGE.SET_TOKEN('CODE',

279: x_return_status := 'E';
280: x_oracle_error := APP_EXCEPTION.Get_Code;
281: FND_MESSAGE.SET_NAME('GR',
282: 'GR_NO_RECORD_INSERTED');
283: FND_MESSAGE.SET_TOKEN('CODE',
284: p_phrase_group_code || ' ' || p_phrase_code,
285: FALSE);
286: IF FND_API.To_Boolean(p_called_by_form) THEN
287: APP_EXCEPTION.Raise_Exception;

Line 289: x_msg_data := FND_MESSAGE.Get;

285: FALSE);
286: IF FND_API.To_Boolean(p_called_by_form) THEN
287: APP_EXCEPTION.Raise_Exception;
288: ELSE
289: x_msg_data := FND_MESSAGE.Get;
290: END IF;
291:
292: WHEN OTHERS THEN
293: ROLLBACK TO SAVEPOINT Update_Row;

Line 297: FND_MESSAGE.SET_NAME('GR',

293: ROLLBACK TO SAVEPOINT Update_Row;
294: x_return_status := 'U';
295: x_oracle_error := APP_EXCEPTION.Get_Code;
296: l_msg_data := APP_EXCEPTION.Get_Text;
297: FND_MESSAGE.SET_NAME('GR',
298: 'GR_UNEXPECTED_ERROR');
299: FND_MESSAGE.SET_TOKEN('TEXT',
300: l_msg_data,
301: FALSE);

Line 299: FND_MESSAGE.SET_TOKEN('TEXT',

295: x_oracle_error := APP_EXCEPTION.Get_Code;
296: l_msg_data := APP_EXCEPTION.Get_Text;
297: FND_MESSAGE.SET_NAME('GR',
298: 'GR_UNEXPECTED_ERROR');
299: FND_MESSAGE.SET_TOKEN('TEXT',
300: l_msg_data,
301: FALSE);
302: IF FND_API.To_Boolean(p_called_by_form) THEN
303: APP_EXCEPTION.Raise_Exception;

Line 305: x_msg_data := FND_MESSAGE.Get;

301: FALSE);
302: IF FND_API.To_Boolean(p_called_by_form) THEN
303: APP_EXCEPTION.Raise_Exception;
304: ELSE
305: x_msg_data := FND_MESSAGE.Get;
306: END IF;
307:
308: END Update_Row;
309:

Line 383: FND_MESSAGE.SET_NAME('GR',

379:
380: WHEN No_Data_Found_Error THEN
381: ROLLBACK TO SAVEPOINT Lock_Row;
382: x_return_status := 'E';
383: FND_MESSAGE.SET_NAME('GR',
384: 'GR_RECORD_NOT_FOUND');
385: FND_MESSAGE.SET_TOKEN('CODE',
386: p_phrase_group_code || ' ' || p_phrase_code,
387: FALSE);

Line 385: FND_MESSAGE.SET_TOKEN('CODE',

381: ROLLBACK TO SAVEPOINT Lock_Row;
382: x_return_status := 'E';
383: FND_MESSAGE.SET_NAME('GR',
384: 'GR_RECORD_NOT_FOUND');
385: FND_MESSAGE.SET_TOKEN('CODE',
386: p_phrase_group_code || ' ' || p_phrase_code,
387: FALSE);
388: IF FND_API.To_Boolean(p_called_by_form) THEN
389: APP_EXCEPTION.Raise_Exception;

Line 391: x_msg_data := FND_MESSAGE.Get;

387: FALSE);
388: IF FND_API.To_Boolean(p_called_by_form) THEN
389: APP_EXCEPTION.Raise_Exception;
390: ELSE
391: x_msg_data := FND_MESSAGE.Get;
392: END IF;
393:
394: WHEN RECORD_CHANGED_ERROR THEN
395: ROLLBACK TO SAVEPOINT Lock_Row;

Line 397: FND_MESSAGE.SET_NAME('FND',

393:
394: WHEN RECORD_CHANGED_ERROR THEN
395: ROLLBACK TO SAVEPOINT Lock_Row;
396: X_return_status := 'E';
397: FND_MESSAGE.SET_NAME('FND',
398: 'FORM_RECORD_CHANGED');
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE

Line 402: x_msg_data := FND_MESSAGE.Get;

398: 'FORM_RECORD_CHANGED');
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:
405: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
406: ROLLBACK TO SAVEPOINT Lock_Row;

Line 410: FND_MESSAGE.SET_NAME('GR',

406: ROLLBACK TO SAVEPOINT Lock_Row;
407: x_return_status := 'L';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_ROW_IS_LOCKED');
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;
414:

Line 412: x_msg_data := FND_MESSAGE.Get;

408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
410: FND_MESSAGE.SET_NAME('GR',
411: 'GR_ROW_IS_LOCKED');
412: x_msg_data := FND_MESSAGE.Get;
413: END IF;
414:
415: WHEN OTHERS THEN
416: ROLLBACK TO SAVEPOINT Lock_Row;

Line 420: FND_MESSAGE.SET_NAME('GR',

416: ROLLBACK TO SAVEPOINT Lock_Row;
417: x_return_status := 'U';
418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);

Line 422: FND_MESSAGE.SET_TOKEN('TEXT',

418: x_oracle_error := APP_EXCEPTION.Get_Code;
419: l_msg_data := APP_EXCEPTION.Get_Text;
420: FND_MESSAGE.SET_NAME('GR',
421: 'GR_UNEXPECTED_ERROR');
422: FND_MESSAGE.SET_TOKEN('TEXT',
423: l_msg_data,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;

Line 428: x_msg_data := FND_MESSAGE.Get;

424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;
430:
431: END Lock_Row;
432:

Line 511: x_msg_data := FND_MESSAGE.Get;

507: x_oracle_error := l_oracle_error;
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: WHEN Row_Missing_Error THEN
515: ROLLBACK TO SAVEPOINT Delete_Row;

Line 518: FND_MESSAGE.SET_NAME('GR',

514: WHEN Row_Missing_Error THEN
515: ROLLBACK TO SAVEPOINT Delete_Row;
516: x_return_status := 'E';
517: x_oracle_error := APP_EXCEPTION.Get_Code;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_phrase_group_code || ' ' || p_phrase_code,
522: FALSE);

Line 520: FND_MESSAGE.SET_TOKEN('CODE',

516: x_return_status := 'E';
517: x_oracle_error := APP_EXCEPTION.Get_Code;
518: FND_MESSAGE.SET_NAME('GR',
519: 'GR_RECORD_NOT_FOUND');
520: FND_MESSAGE.SET_TOKEN('CODE',
521: p_phrase_group_code || ' ' || p_phrase_code,
522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;

Line 526: x_msg_data := FND_MESSAGE.Get;

522: FALSE);
523: IF FND_API.To_Boolean(p_called_by_form) THEN
524: APP_EXCEPTION.Raise_Exception;
525: ELSE
526: x_msg_data := FND_MESSAGE.Get;
527: END IF;
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO SAVEPOINT Delete_Row;

Line 535: FND_MESSAGE.SET_NAME('GR',

531: x_return_status := 'U';
532: x_oracle_error := APP_EXCEPTION.Get_Code;
533: l_msg_data := APP_EXCEPTION.Get_Text;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: FND_MESSAGE.SET_NAME('GR',
536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_data,
539: FALSE);

Line 537: FND_MESSAGE.SET_TOKEN('TEXT',

533: l_msg_data := APP_EXCEPTION.Get_Text;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: FND_MESSAGE.SET_NAME('GR',
536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_data,
539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;

Line 543: x_msg_data := FND_MESSAGE.Get;

539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;
542: ELSE
543: x_msg_data := FND_MESSAGE.Get;
544: END IF;
545:
546: END Delete_Row;
547:

Line 593: FND_MESSAGE.SET_NAME('GR',

589: ROLLBACK TO SAVEPOINT Delete_Rows;
590: x_return_status := 'U';
591: x_oracle_error := APP_EXCEPTION.Get_Code;
592: l_msg_data := APP_EXCEPTION.Get_Text;
593: FND_MESSAGE.SET_NAME('GR',
594: 'GR_UNEXPECTED_ERROR');
595: FND_MESSAGE.SET_TOKEN('TEXT',
596: l_msg_token,
597: FALSE);

Line 595: FND_MESSAGE.SET_TOKEN('TEXT',

591: x_oracle_error := APP_EXCEPTION.Get_Code;
592: l_msg_data := APP_EXCEPTION.Get_Text;
593: FND_MESSAGE.SET_NAME('GR',
594: 'GR_UNEXPECTED_ERROR');
595: FND_MESSAGE.SET_TOKEN('TEXT',
596: l_msg_token,
597: FALSE);
598: IF FND_API.To_Boolean(p_called_by_form) THEN
599: APP_EXCEPTION.Raise_Exception;

Line 601: x_msg_data := FND_MESSAGE.Get;

597: FALSE);
598: IF FND_API.To_Boolean(p_called_by_form) THEN
599: APP_EXCEPTION.Raise_Exception;
600: ELSE
601: x_msg_data := FND_MESSAGE.Get;
602: END IF;
603:
604: END Delete_Rows;
605:

Line 651: FND_MESSAGE.SET_NAME('GR',

647: l_key_exists);
648:
649: IF NOT FND_API.To_Boolean(l_key_exists) THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('GR',
652: 'GR_RECORD_NOT_FOUND');
653: FND_MESSAGE.SET_TOKEN('CODE',
654: p_phrase_group_code,
655: FALSE);

Line 653: FND_MESSAGE.SET_TOKEN('CODE',

649: IF NOT FND_API.To_Boolean(l_key_exists) THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('GR',
652: 'GR_RECORD_NOT_FOUND');
653: FND_MESSAGE.SET_TOKEN('CODE',
654: p_phrase_group_code,
655: FALSE);
656: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
657: END IF;

Line 656: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

652: 'GR_RECORD_NOT_FOUND');
653: FND_MESSAGE.SET_TOKEN('CODE',
654: p_phrase_group_code,
655: FALSE);
656: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
657: END IF;
658:
659: /* Check the phrase code */
660:

Line 670: FND_MESSAGE.SET_NAME('GR',

666: l_key_exists);
667:
668: IF NOT FND_API.To_Boolean(l_key_exists) THEN
669: x_return_status := 'E';
670: FND_MESSAGE.SET_NAME('GR',
671: 'GR_RECORD_NOT_FOUND');
672: FND_MESSAGE.SET_TOKEN('CODE',
673: p_phrase_code,
674: FALSE);

Line 672: FND_MESSAGE.SET_TOKEN('CODE',

668: IF NOT FND_API.To_Boolean(l_key_exists) THEN
669: x_return_status := 'E';
670: FND_MESSAGE.SET_NAME('GR',
671: 'GR_RECORD_NOT_FOUND');
672: FND_MESSAGE.SET_TOKEN('CODE',
673: p_phrase_code,
674: FALSE);
675: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
676: END IF;

Line 675: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

671: 'GR_RECORD_NOT_FOUND');
672: FND_MESSAGE.SET_TOKEN('CODE',
673: p_phrase_code,
674: FALSE);
675: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
676: END IF;
677:
678: /* Now manage the error handling */
679:

Line 691: FND_MESSAGE.SET_NAME('GR',

687: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
688: x_return_status := 'U';
689: x_oracle_error := APP_EXCEPTION.Get_Code;
690: l_msg_data := APP_EXCEPTION.Get_Text;
691: FND_MESSAGE.SET_NAME('GR',
692: 'GR_UNEXPECTED_ERROR');
693: FND_MESSAGE.SET_TOKEN('TEXT',
694: l_msg_data,
695: FALSE);

Line 693: FND_MESSAGE.SET_TOKEN('TEXT',

689: x_oracle_error := APP_EXCEPTION.Get_Code;
690: l_msg_data := APP_EXCEPTION.Get_Text;
691: FND_MESSAGE.SET_NAME('GR',
692: 'GR_UNEXPECTED_ERROR');
693: FND_MESSAGE.SET_TOKEN('TEXT',
694: l_msg_data,
695: FALSE);
696: x_msg_data := FND_MESSAGE.Get;
697:

Line 696: x_msg_data := FND_MESSAGE.Get;

692: 'GR_UNEXPECTED_ERROR');
693: FND_MESSAGE.SET_TOKEN('TEXT',
694: l_msg_data,
695: FALSE);
696: x_msg_data := FND_MESSAGE.Get;
697:
698: END Check_Foreign_Keys;
699:
700: PROCEDURE Check_Integrity

Line 742: FND_MESSAGE.SET_NAME('GR',

738:
739: IF l_return_status <> 'S' THEN
740: x_return_status := l_return_status;
741: x_msg_data := l_msg_data;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);

Line 744: FND_MESSAGE.SET_TOKEN('TEXT',

740: x_return_status := l_return_status;
741: x_msg_data := l_msg_data;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
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: END IF;
753:
754: EXCEPTION

Line 761: FND_MESSAGE.SET_NAME('GR',

757: ROLLBACK TO SAVEPOINT Check_Integrity;
758: x_return_status := 'U';
759: x_oracle_error := APP_EXCEPTION.Get_Code;
760: l_msg_data := APP_EXCEPTION.Get_Text;
761: FND_MESSAGE.SET_NAME('GR',
762: 'GR_UNEXPECTED_ERROR');
763: FND_MESSAGE.SET_TOKEN('TEXT',
764: l_msg_data,
765: FALSE);

Line 763: FND_MESSAGE.SET_TOKEN('TEXT',

759: x_oracle_error := APP_EXCEPTION.Get_Code;
760: l_msg_data := APP_EXCEPTION.Get_Text;
761: FND_MESSAGE.SET_NAME('GR',
762: 'GR_UNEXPECTED_ERROR');
763: FND_MESSAGE.SET_TOKEN('TEXT',
764: l_msg_data,
765: FALSE);
766: IF FND_API.To_Boolean(p_called_by_form) THEN
767: APP_EXCEPTION.Raise_Exception;

Line 769: x_msg_data := FND_MESSAGE.Get;

765: FALSE);
766: IF FND_API.To_Boolean(p_called_by_form) THEN
767: APP_EXCEPTION.Raise_Exception;
768: ELSE
769: x_msg_data := FND_MESSAGE.Get;
770: END IF;
771:
772: END Check_Integrity;
773:

Line 819: FND_MESSAGE.SET_NAME('GR',

815: EXCEPTION
816:
817: WHEN Others THEN
818: l_msg_data := APP_EXCEPTION.Get_Text;
819: FND_MESSAGE.SET_NAME('GR',
820: 'GR_UNEXPECTED_ERROR');
821: FND_MESSAGE.SET_TOKEN('TEXT',
822: l_msg_data,
823: FALSE);

Line 821: FND_MESSAGE.SET_TOKEN('TEXT',

817: WHEN Others THEN
818: l_msg_data := APP_EXCEPTION.Get_Text;
819: FND_MESSAGE.SET_NAME('GR',
820: 'GR_UNEXPECTED_ERROR');
821: FND_MESSAGE.SET_TOKEN('TEXT',
822: l_msg_data,
823: FALSE);
824: IF FND_API.To_Boolean(p_called_by_form) THEN
825: APP_EXCEPTION.Raise_Exception;