DBA Data[Home] [Help]

APPS.GR_EMEA_PKG dependencies on APP_EXCEPTION

Line 260: APP_EXCEPTION.Raise_Exception;

256: FND_MESSAGE.SET_TOKEN('TEXT',
257: l_msg_data,
258: FALSE);
259: IF FND_API.To_Boolean(p_called_by_form) THEN
260: APP_EXCEPTION.Raise_Exception;
261: ELSE
262: x_msg_data := FND_MESSAGE.Get;
263: END IF;
264:

Line 268: x_oracle_error := APP_EXCEPTION.Get_Code;

264:
265: WHEN Item_Exists_Error THEN
266: ROLLBACK TO SAVEPOINT Insert_Row;
267: x_return_status := 'E';
268: x_oracle_error := APP_EXCEPTION.Get_Code;
269: FND_MESSAGE.SET_NAME('GR',
270: 'GR_RECORD_EXISTS');
271: FND_MESSAGE.SET_TOKEN('CODE',
272: p_item_code,

Line 275: APP_EXCEPTION.Raise_Exception;

271: FND_MESSAGE.SET_TOKEN('CODE',
272: p_item_code,
273: FALSE);
274: IF FND_API.To_Boolean(p_called_by_form) THEN
275: APP_EXCEPTION.Raise_Exception;
276: ELSE
277: x_msg_data := FND_MESSAGE.Get;
278: END IF;
279:

Line 283: x_oracle_error := APP_EXCEPTION.Get_Code;

279:
280: WHEN Row_Missing_Error THEN
281: ROLLBACK TO SAVEPOINT Insert_Row;
282: x_return_status := 'E';
283: x_oracle_error := APP_EXCEPTION.Get_Code;
284: FND_MESSAGE.SET_NAME('GR',
285: 'GR_NO_RECORD_INSERTED');
286: FND_MESSAGE.SET_TOKEN('CODE',
287: p_item_code,

Line 290: APP_EXCEPTION.Raise_Exception;

286: FND_MESSAGE.SET_TOKEN('CODE',
287: p_item_code,
288: FALSE);
289: IF FND_API.To_Boolean(p_called_by_form) THEN
290: APP_EXCEPTION.Raise_Exception;
291: ELSE
292: x_msg_data := FND_MESSAGE.Get;
293: END IF;
294:

Line 298: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 299: l_msg_data := APP_EXCEPTION.Get_Text;

295: WHEN OTHERS THEN
296: ROLLBACK TO SAVEPOINT Insert_Row;
297: x_return_status := 'U';
298: x_oracle_error := APP_EXCEPTION.Get_Code;
299: l_msg_data := APP_EXCEPTION.Get_Text;
300: FND_MESSAGE.SET_NAME('GR',
301: 'GR_UNEXPECTED_ERROR');
302: FND_MESSAGE.SET_TOKEN('TEXT',
303: l_msg_data,

Line 306: APP_EXCEPTION.Raise_Exception;

302: FND_MESSAGE.SET_TOKEN('TEXT',
303: l_msg_data,
304: FALSE);
305: IF FND_API.To_Boolean(p_called_by_form) THEN
306: APP_EXCEPTION.Raise_Exception;
307: ELSE
308: x_msg_data := FND_MESSAGE.Get;
309: END IF;
310:

Line 500: APP_EXCEPTION.Raise_Exception;

496: FND_MESSAGE.SET_TOKEN('TEXT',
497: l_msg_data,
498: FALSE);
499: IF FND_API.To_Boolean(p_called_by_form) THEN
500: APP_EXCEPTION.Raise_Exception;
501: ELSE
502: x_msg_data := FND_MESSAGE.Get;
503: END IF;
504:

Line 508: x_oracle_error := APP_EXCEPTION.Get_Code;

504:
505: WHEN Row_Missing_Error THEN
506: ROLLBACK TO SAVEPOINT Update_Row;
507: x_return_status := 'E';
508: x_oracle_error := APP_EXCEPTION.Get_Code;
509: FND_MESSAGE.SET_NAME('GR',
510: 'GR_NO_RECORD_INSERTED');
511: FND_MESSAGE.SET_TOKEN('CODE',
512: p_item_code,

Line 515: APP_EXCEPTION.Raise_Exception;

511: FND_MESSAGE.SET_TOKEN('CODE',
512: p_item_code,
513: FALSE);
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;
519:

Line 523: x_oracle_error := APP_EXCEPTION.Get_Code;

519:
520: WHEN OTHERS THEN
521: ROLLBACK TO SAVEPOINT Update_Row;
522: x_return_status := 'U';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',

Line 524: l_msg_data := APP_EXCEPTION.Get_Text;

520: WHEN OTHERS THEN
521: ROLLBACK TO SAVEPOINT Update_Row;
522: x_return_status := 'U';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: l_msg_data := APP_EXCEPTION.Get_Text;
525: FND_MESSAGE.SET_NAME('GR',
526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,

Line 531: APP_EXCEPTION.Raise_Exception;

527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;
532: ELSE
533: x_msg_data := FND_MESSAGE.Get;
534: END IF;
535:

Line 647: APP_EXCEPTION.Raise_Exception;

643: FND_MESSAGE.SET_TOKEN('CODE',
644: p_item_code,
645: FALSE);
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;
648: ELSE
649: x_msg_data := FND_MESSAGE.Get;
650: END IF;
651:

Line 655: x_oracle_error := APP_EXCEPTION.Get_Code;

651:
652: WHEN Row_Already_Locked_Error THEN
653: ROLLBACK TO SAVEPOINT Lock_Row;
654: x_return_status := 'E';
655: x_oracle_error := APP_EXCEPTION.Get_Code;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_ROW_IS_LOCKED');
658: IF FND_API.To_Boolean(p_called_by_form) THEN
659: APP_EXCEPTION.Raise_Exception;

Line 659: APP_EXCEPTION.Raise_Exception;

655: x_oracle_error := APP_EXCEPTION.Get_Code;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_ROW_IS_LOCKED');
658: IF FND_API.To_Boolean(p_called_by_form) THEN
659: APP_EXCEPTION.Raise_Exception;
660: ELSE
661: x_msg_data := FND_MESSAGE.Get;
662: END IF;
663:

Line 667: x_oracle_error := APP_EXCEPTION.Get_Code;

663:
664: WHEN OTHERS THEN
665: ROLLBACK TO SAVEPOINT Lock_Row;
666: x_return_status := 'U';
667: x_oracle_error := APP_EXCEPTION.Get_Code;
668: l_msg_data := APP_EXCEPTION.Get_Text;
669: FND_MESSAGE.SET_NAME('GR',
670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',

Line 668: l_msg_data := APP_EXCEPTION.Get_Text;

664: WHEN OTHERS THEN
665: ROLLBACK TO SAVEPOINT Lock_Row;
666: x_return_status := 'U';
667: x_oracle_error := APP_EXCEPTION.Get_Code;
668: l_msg_data := APP_EXCEPTION.Get_Text;
669: FND_MESSAGE.SET_NAME('GR',
670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,

Line 675: APP_EXCEPTION.Raise_Exception;

671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,
673: FALSE);
674: IF FND_API.To_Boolean(p_called_by_form) THEN
675: APP_EXCEPTION.Raise_Exception;
676: ELSE
677: x_msg_data := FND_MESSAGE.Get;
678: END IF;
679:

Line 824: APP_EXCEPTION.Raise_Exception;

820: ROLLBACK TO SAVEPOINT Delete_Row;
821: x_return_status := l_return_status;
822: x_oracle_error := l_oracle_error;
823: IF FND_API.To_Boolean(p_called_by_form) THEN
824: APP_EXCEPTION.Raise_Exception;
825: ELSE
826: x_msg_data := FND_MESSAGE.Get;
827: END IF;
828:

Line 832: x_oracle_error := APP_EXCEPTION.Get_Code;

828:
829: WHEN Row_Missing_Error THEN
830: ROLLBACK TO SAVEPOINT Delete_Row;
831: x_return_status := 'E';
832: x_oracle_error := APP_EXCEPTION.Get_Code;
833: FND_MESSAGE.SET_NAME('GR',
834: 'GR_RECORD_NOT_FOUND');
835: FND_MESSAGE.SET_TOKEN('CODE',
836: p_item_code,

Line 839: APP_EXCEPTION.Raise_Exception;

835: FND_MESSAGE.SET_TOKEN('CODE',
836: p_item_code,
837: FALSE);
838: IF FND_API.To_Boolean(p_called_by_form) THEN
839: APP_EXCEPTION.Raise_Exception;
840: ELSE
841: x_msg_data := FND_MESSAGE.Get;
842: END IF;
843:

Line 847: x_oracle_error := APP_EXCEPTION.Get_Code;

843:
844: WHEN OTHERS THEN
845: ROLLBACK TO SAVEPOINT Delete_Row;
846: x_return_status := 'U';
847: x_oracle_error := APP_EXCEPTION.Get_Code;
848: l_msg_data := APP_EXCEPTION.Get_Text;
849: l_msg_data := APP_EXCEPTION.Get_Text;
850: FND_MESSAGE.SET_NAME('GR',
851: 'GR_UNEXPECTED_ERROR');

Line 848: l_msg_data := APP_EXCEPTION.Get_Text;

844: WHEN OTHERS THEN
845: ROLLBACK TO SAVEPOINT Delete_Row;
846: x_return_status := 'U';
847: x_oracle_error := APP_EXCEPTION.Get_Code;
848: l_msg_data := APP_EXCEPTION.Get_Text;
849: l_msg_data := APP_EXCEPTION.Get_Text;
850: FND_MESSAGE.SET_NAME('GR',
851: 'GR_UNEXPECTED_ERROR');
852: FND_MESSAGE.SET_TOKEN('TEXT',

Line 849: l_msg_data := APP_EXCEPTION.Get_Text;

845: ROLLBACK TO SAVEPOINT Delete_Row;
846: x_return_status := 'U';
847: x_oracle_error := APP_EXCEPTION.Get_Code;
848: l_msg_data := APP_EXCEPTION.Get_Text;
849: l_msg_data := APP_EXCEPTION.Get_Text;
850: FND_MESSAGE.SET_NAME('GR',
851: 'GR_UNEXPECTED_ERROR');
852: FND_MESSAGE.SET_TOKEN('TEXT',
853: l_msg_data,

Line 856: APP_EXCEPTION.Raise_Exception;

852: FND_MESSAGE.SET_TOKEN('TEXT',
853: l_msg_data,
854: FALSE);
855: IF FND_API.To_Boolean(p_called_by_form) THEN
856: APP_EXCEPTION.Raise_Exception;
857: ELSE
858: x_msg_data := FND_MESSAGE.Get;
859: END IF;
860:

Line 977: x_oracle_error := APP_EXCEPTION.Get_Code;

973:
974: WHEN OTHERS THEN
975: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
976: x_return_status := 'U';
977: x_oracle_error := APP_EXCEPTION.Get_Code;
978: l_msg_data := APP_EXCEPTION.Get_Text;
979: FND_MESSAGE.SET_NAME('GR',
980: 'GR_UNEXPECTED_ERROR');
981: FND_MESSAGE.SET_TOKEN('TEXT',

Line 978: l_msg_data := APP_EXCEPTION.Get_Text;

974: WHEN OTHERS THEN
975: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
976: x_return_status := 'U';
977: x_oracle_error := APP_EXCEPTION.Get_Code;
978: l_msg_data := APP_EXCEPTION.Get_Text;
979: FND_MESSAGE.SET_NAME('GR',
980: 'GR_UNEXPECTED_ERROR');
981: FND_MESSAGE.SET_TOKEN('TEXT',
982: l_msg_data,

Line 1068: APP_EXCEPTION.Raise_Exception;

1064: FND_MESSAGE.SET_TOKEN('TEXT',
1065: l_msg_data,
1066: FALSE);
1067: IF FND_API.To_Boolean(p_called_by_form) THEN
1068: APP_EXCEPTION.Raise_Exception;
1069: ELSE
1070: x_msg_data := FND_MESSAGE.Get;
1071: END IF;
1072: END IF;

Line 1079: x_oracle_error := APP_EXCEPTION.Get_Code;

1075:
1076: WHEN OTHERS THEN
1077: ROLLBACK TO SAVEPOINT Check_Integrity;
1078: x_return_status := 'U';
1079: x_oracle_error := APP_EXCEPTION.Get_Code;
1080: l_msg_data := APP_EXCEPTION.Get_Text;
1081: FND_MESSAGE.SET_NAME('GR',
1082: 'GR_UNEXPECTED_ERROR');
1083: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1080: l_msg_data := APP_EXCEPTION.Get_Text;

1076: WHEN OTHERS THEN
1077: ROLLBACK TO SAVEPOINT Check_Integrity;
1078: x_return_status := 'U';
1079: x_oracle_error := APP_EXCEPTION.Get_Code;
1080: l_msg_data := APP_EXCEPTION.Get_Text;
1081: FND_MESSAGE.SET_NAME('GR',
1082: 'GR_UNEXPECTED_ERROR');
1083: FND_MESSAGE.SET_TOKEN('TEXT',
1084: l_msg_data,

Line 1087: APP_EXCEPTION.Raise_Exception;

1083: FND_MESSAGE.SET_TOKEN('TEXT',
1084: l_msg_data,
1085: FALSE);
1086: IF FND_API.To_Boolean(p_called_by_form) THEN
1087: APP_EXCEPTION.Raise_Exception;
1088: ELSE
1089: x_msg_data := FND_MESSAGE.Get;
1090: END IF;
1091:

Line 1137: l_msg_data := APP_EXCEPTION.Get_Text;

1133:
1134: EXCEPTION
1135:
1136: WHEN Others THEN
1137: l_msg_data := APP_EXCEPTION.Get_Text;
1138: FND_MESSAGE.SET_NAME('GR',
1139: 'GR_UNEXPECTED_ERROR');
1140: FND_MESSAGE.SET_TOKEN('TEXT',
1141: l_msg_data,

Line 1144: APP_EXCEPTION.Raise_Exception;

1140: FND_MESSAGE.SET_TOKEN('TEXT',
1141: l_msg_data,
1142: FALSE);
1143: IF FND_API.To_Boolean(p_called_by_form) THEN
1144: APP_EXCEPTION.Raise_Exception;
1145: END IF;
1146:
1147: END Check_Primary_Key;
1148: