DBA Data[Home] [Help]

APPS.GR_PHRASES_B_PKG dependencies on APP_EXCEPTION

Line 247: APP_EXCEPTION.Raise_Exception;

243: FND_MESSAGE.SET_TOKEN('TEXT',
244: l_msg_data,
245: FALSE);
246: IF FND_API.To_Boolean(p_called_by_form) THEN
247: APP_EXCEPTION.Raise_Exception;
248: ELSE
249: x_msg_data := FND_MESSAGE.Get;
250: END IF;
251:

Line 255: x_oracle_error := APP_EXCEPTION.Get_Code;

251:
252: WHEN Label_Exists_Error THEN
253: ROLLBACK TO SAVEPOINT Insert_Row;
254: x_return_status := 'E';
255: x_oracle_error := APP_EXCEPTION.Get_Code;
256: FND_MESSAGE.SET_NAME('GR',
257: 'GR_RECORD_EXISTS');
258: FND_MESSAGE.SET_TOKEN('CODE',
259: p_phrase_code,

Line 262: APP_EXCEPTION.Raise_Exception;

258: FND_MESSAGE.SET_TOKEN('CODE',
259: p_phrase_code,
260: FALSE);
261: IF FND_API.To_Boolean(p_called_by_form) THEN
262: APP_EXCEPTION.Raise_Exception;
263: ELSE
264: x_msg_data := FND_MESSAGE.Get;
265: END IF;
266:

Line 270: x_oracle_error := APP_EXCEPTION.Get_Code;

266:
267: WHEN Row_Missing_Error THEN
268: ROLLBACK TO SAVEPOINT Insert_Row;
269: x_return_status := 'E';
270: x_oracle_error := APP_EXCEPTION.Get_Code;
271: FND_MESSAGE.SET_NAME('GR',
272: 'GR_NO_RECORD_INSERTED');
273: FND_MESSAGE.SET_TOKEN('CODE',
274: p_phrase_code,

Line 277: APP_EXCEPTION.Raise_Exception;

273: FND_MESSAGE.SET_TOKEN('CODE',
274: p_phrase_code,
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:

Line 285: x_oracle_error := APP_EXCEPTION.Get_Code;

281:
282: WHEN OTHERS THEN
283: ROLLBACK TO SAVEPOINT Insert_Row;
284: x_return_status := 'U';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: l_msg_data := APP_EXCEPTION.Get_Text;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_UNEXPECTED_ERROR');
289: FND_MESSAGE.SET_TOKEN('TEXT',

Line 286: l_msg_data := APP_EXCEPTION.Get_Text;

282: WHEN OTHERS THEN
283: ROLLBACK TO SAVEPOINT Insert_Row;
284: x_return_status := 'U';
285: x_oracle_error := APP_EXCEPTION.Get_Code;
286: l_msg_data := APP_EXCEPTION.Get_Text;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_UNEXPECTED_ERROR');
289: FND_MESSAGE.SET_TOKEN('TEXT',
290: l_msg_data,

Line 293: APP_EXCEPTION.Raise_Exception;

289: FND_MESSAGE.SET_TOKEN('TEXT',
290: l_msg_data,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;
297:

Line 479: APP_EXCEPTION.Raise_Exception;

475: FND_MESSAGE.SET_TOKEN('TEXT',
476: l_msg_data,
477: FALSE);
478: IF FND_API.To_Boolean(p_called_by_form) THEN
479: APP_EXCEPTION.Raise_Exception;
480: ELSE
481: x_msg_data := FND_MESSAGE.Get;
482: END IF;
483:

Line 487: x_oracle_error := APP_EXCEPTION.Get_Code;

483:
484: WHEN Row_Missing_Error THEN
485: ROLLBACK TO SAVEPOINT Update_Row;
486: x_return_status := 'E';
487: x_oracle_error := APP_EXCEPTION.Get_Code;
488: FND_MESSAGE.SET_NAME('GR',
489: 'GR_NO_RECORD_INSERTED');
490: FND_MESSAGE.SET_TOKEN('CODE',
491: p_phrase_code,

Line 494: APP_EXCEPTION.Raise_Exception;

490: FND_MESSAGE.SET_TOKEN('CODE',
491: p_phrase_code,
492: FALSE);
493: IF FND_API.To_Boolean(p_called_by_form) THEN
494: APP_EXCEPTION.Raise_Exception;
495: ELSE
496: x_msg_data := FND_MESSAGE.Get;
497: END IF;
498:

Line 502: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 503: l_msg_data := APP_EXCEPTION.Get_Text;

499: WHEN OTHERS THEN
500: ROLLBACK TO SAVEPOINT Update_Row;
501: x_return_status := 'U';
502: x_oracle_error := APP_EXCEPTION.Get_Code;
503: l_msg_data := APP_EXCEPTION.Get_Text;
504: FND_MESSAGE.SET_NAME('GR',
505: 'GR_UNEXPECTED_ERROR');
506: FND_MESSAGE.SET_TOKEN('TEXT',
507: l_msg_data,

Line 510: APP_EXCEPTION.Raise_Exception;

506: FND_MESSAGE.SET_TOKEN('TEXT',
507: l_msg_data,
508: FALSE);
509: IF FND_API.To_Boolean(p_called_by_form) THEN
510: APP_EXCEPTION.Raise_Exception;
511: ELSE
512: x_msg_data := FND_MESSAGE.Get;
513: END IF;
514:

Line 627: APP_EXCEPTION.Raise_Exception;

623: FND_MESSAGE.SET_TOKEN('CODE',
624: p_phrase_code,
625: FALSE);
626: IF FND_API.To_Boolean(p_called_by_form) THEN
627: APP_EXCEPTION.Raise_Exception;
628: ELSE
629: x_msg_data := FND_MESSAGE.Get;
630: END IF;
631: WHEN RECORD_CHANGED_ERROR THEN

Line 637: APP_EXCEPTION.Raise_Exception;

633: X_return_status := 'E';
634: FND_MESSAGE.SET_NAME('FND',
635: 'FORM_RECORD_CHANGED');
636: IF FND_API.To_Boolean(p_called_by_form) THEN
637: APP_EXCEPTION.Raise_Exception;
638: ELSE
639: x_msg_data := FND_MESSAGE.Get;
640: END IF;
641: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 641: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

637: APP_EXCEPTION.Raise_Exception;
638: ELSE
639: x_msg_data := FND_MESSAGE.Get;
640: END IF;
641: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
642: ROLLBACK TO SAVEPOINT Lock_Row;
643: x_return_status := 'L';
644: x_oracle_error := APP_EXCEPTION.Get_Code;
645: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 644: x_oracle_error := APP_EXCEPTION.Get_Code;

640: END IF;
641: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
642: ROLLBACK TO SAVEPOINT Lock_Row;
643: x_return_status := 'L';
644: x_oracle_error := APP_EXCEPTION.Get_Code;
645: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
646: FND_MESSAGE.SET_NAME('GR',
647: 'GR_ROW_IS_LOCKED');
648: x_msg_data := FND_MESSAGE.Get;

Line 653: x_oracle_error := APP_EXCEPTION.Get_Code;

649: END IF;
650: WHEN OTHERS THEN
651: ROLLBACK TO SAVEPOINT Lock_Row;
652: x_return_status := 'U';
653: x_oracle_error := APP_EXCEPTION.Get_Code;
654: l_msg_data := APP_EXCEPTION.Get_Text;
655: FND_MESSAGE.SET_NAME('GR',
656: 'GR_UNEXPECTED_ERROR');
657: FND_MESSAGE.SET_TOKEN('TEXT',

Line 654: l_msg_data := APP_EXCEPTION.Get_Text;

650: WHEN OTHERS THEN
651: ROLLBACK TO SAVEPOINT Lock_Row;
652: x_return_status := 'U';
653: x_oracle_error := APP_EXCEPTION.Get_Code;
654: l_msg_data := APP_EXCEPTION.Get_Text;
655: FND_MESSAGE.SET_NAME('GR',
656: 'GR_UNEXPECTED_ERROR');
657: FND_MESSAGE.SET_TOKEN('TEXT',
658: l_msg_data,

Line 661: APP_EXCEPTION.Raise_Exception;

657: FND_MESSAGE.SET_TOKEN('TEXT',
658: l_msg_data,
659: FALSE);
660: IF FND_API.To_Boolean(p_called_by_form) THEN
661: APP_EXCEPTION.Raise_Exception;
662: ELSE
663: x_msg_data := FND_MESSAGE.Get;
664: END IF;
665:

Line 804: APP_EXCEPTION.Raise_Exception;

800: ROLLBACK TO SAVEPOINT Delete_Row;
801: x_return_status := l_return_status;
802: x_oracle_error := l_oracle_error;
803: IF FND_API.To_Boolean(p_called_by_form) THEN
804: APP_EXCEPTION.Raise_Exception;
805: ELSE
806: x_msg_data := FND_MESSAGE.Get;
807: END IF;
808:

Line 812: x_oracle_error := APP_EXCEPTION.Get_Code;

808:
809: WHEN Row_Missing_Error THEN
810: ROLLBACK TO SAVEPOINT Delete_Row;
811: x_return_status := 'E';
812: x_oracle_error := APP_EXCEPTION.Get_Code;
813: FND_MESSAGE.SET_NAME('GR',
814: 'GR_RECORD_NOT_FOUND');
815: FND_MESSAGE.SET_TOKEN('CODE',
816: p_phrase_code,

Line 819: APP_EXCEPTION.Raise_Exception;

815: FND_MESSAGE.SET_TOKEN('CODE',
816: p_phrase_code,
817: FALSE);
818: IF FND_API.To_Boolean(p_called_by_form) THEN
819: APP_EXCEPTION.Raise_Exception;
820: ELSE
821: x_msg_data := FND_MESSAGE.Get;
822: END IF;
823:

Line 827: x_oracle_error := APP_EXCEPTION.Get_Code;

823:
824: WHEN OTHERS THEN
825: ROLLBACK TO SAVEPOINT Delete_Row;
826: x_return_status := 'U';
827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: l_msg_data := APP_EXCEPTION.Get_Text;
830: FND_MESSAGE.SET_NAME('GR',
831: 'GR_UNEXPECTED_ERROR');

Line 828: l_msg_data := APP_EXCEPTION.Get_Text;

824: WHEN OTHERS THEN
825: ROLLBACK TO SAVEPOINT Delete_Row;
826: x_return_status := 'U';
827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: l_msg_data := APP_EXCEPTION.Get_Text;
830: FND_MESSAGE.SET_NAME('GR',
831: 'GR_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('TEXT',

Line 829: l_msg_data := APP_EXCEPTION.Get_Text;

825: ROLLBACK TO SAVEPOINT Delete_Row;
826: x_return_status := 'U';
827: x_oracle_error := APP_EXCEPTION.Get_Code;
828: l_msg_data := APP_EXCEPTION.Get_Text;
829: l_msg_data := APP_EXCEPTION.Get_Text;
830: FND_MESSAGE.SET_NAME('GR',
831: 'GR_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('TEXT',
833: l_msg_data,

Line 836: APP_EXCEPTION.Raise_Exception;

832: FND_MESSAGE.SET_TOKEN('TEXT',
833: l_msg_data,
834: FALSE);
835: IF FND_API.To_Boolean(p_called_by_form) THEN
836: APP_EXCEPTION.Raise_Exception;
837: ELSE
838: x_msg_data := FND_MESSAGE.Get;
839: END IF;
840:

Line 963: x_oracle_error := APP_EXCEPTION.Get_Code;

959:
960: WHEN OTHERS THEN
961: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
962: x_return_status := 'U';
963: x_oracle_error := APP_EXCEPTION.Get_Code;
964: l_msg_data := APP_EXCEPTION.Get_Text;
965: FND_MESSAGE.SET_NAME('GR',
966: 'GR_UNEXPECTED_ERROR');
967: FND_MESSAGE.SET_TOKEN('TEXT',

Line 964: l_msg_data := APP_EXCEPTION.Get_Text;

960: WHEN OTHERS THEN
961: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
962: x_return_status := 'U';
963: x_oracle_error := APP_EXCEPTION.Get_Code;
964: l_msg_data := APP_EXCEPTION.Get_Text;
965: FND_MESSAGE.SET_NAME('GR',
966: 'GR_UNEXPECTED_ERROR');
967: FND_MESSAGE.SET_TOKEN('TEXT',
968: l_msg_data,

Line 1198: x_oracle_error := APP_EXCEPTION.Get_Code;

1194:
1195: WHEN OTHERS THEN
1196: ROLLBACK TO SAVEPOINT Check_Integrity;
1197: x_return_status := 'U';
1198: x_oracle_error := APP_EXCEPTION.Get_Code;
1199: l_msg_data := APP_EXCEPTION.Get_Text;
1200: FND_MESSAGE.SET_NAME('GR',
1201: 'GR_UNEXPECTED_ERROR');
1202: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1199: l_msg_data := APP_EXCEPTION.Get_Text;

1195: WHEN OTHERS THEN
1196: ROLLBACK TO SAVEPOINT Check_Integrity;
1197: x_return_status := 'U';
1198: x_oracle_error := APP_EXCEPTION.Get_Code;
1199: l_msg_data := APP_EXCEPTION.Get_Text;
1200: FND_MESSAGE.SET_NAME('GR',
1201: 'GR_UNEXPECTED_ERROR');
1202: FND_MESSAGE.SET_TOKEN('TEXT',
1203: l_msg_data,

Line 1206: APP_EXCEPTION.Raise_Exception;

1202: FND_MESSAGE.SET_TOKEN('TEXT',
1203: l_msg_data,
1204: FALSE);
1205: IF FND_API.To_Boolean(p_called_by_form) THEN
1206: APP_EXCEPTION.Raise_Exception;
1207: ELSE
1208: x_msg_data := FND_MESSAGE.Get;
1209: END IF;
1210:

Line 1255: l_msg_data := APP_EXCEPTION.Get_Text;

1251:
1252: EXCEPTION
1253:
1254: WHEN Others THEN
1255: l_msg_data := APP_EXCEPTION.Get_Text;
1256: FND_MESSAGE.SET_NAME('GR',
1257: 'GR_UNEXPECTED_ERROR');
1258: FND_MESSAGE.SET_TOKEN('TEXT',
1259: l_msg_data,

Line 1262: APP_EXCEPTION.Raise_Exception;

1258: FND_MESSAGE.SET_TOKEN('TEXT',
1259: l_msg_data,
1260: FALSE);
1261: IF FND_API.To_Boolean(p_called_by_form) THEN
1262: APP_EXCEPTION.Raise_Exception;
1263: END IF;
1264:
1265: END Check_Primary_Key;
1266: