DBA Data[Home] [Help]

APPS.WSH_DEL_OI_CORE dependencies on APP_EXCEPTION

Line 30: APP_EXCEPTION.Raise_Exception;

26: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
27: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_order_info');
28: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
29: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
30: APP_EXCEPTION.Raise_Exception;
31:
32: end;
33: END GET_ORDER_INFO;
34:

Line 66: APP_EXCEPTION.Raise_Exception;

62: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
63: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.pickslip_closed');
64: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
65: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
66: APP_EXCEPTION.Raise_Exception;
67:
68: END;
69:
70:

Line 118: APP_EXCEPTION.Raise_Exception;

114: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
115: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_item_control_codes');
116: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
117: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
118: APP_EXCEPTION.Raise_Exception;
119: end;
120: END get_item_control_codes;
121:
122:

Line 191: APP_EXCEPTION.Raise_Exception;

187: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
188: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_subinventory');
189: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
190: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
191: APP_EXCEPTION.Raise_Exception;
192: end;
193: END valid_subinventory;
194:
195:

Line 243: APP_EXCEPTION.Raise_Exception;

239: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
240: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_subinventory');
241: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
242: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
243: APP_EXCEPTION.Raise_Exception;
244:
245: end;
246: END DEFAULT_SUBINVENTORY;
247:

Line 308: APP_EXCEPTION.Raise_Exception;

304: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
305: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.get_locator_controls');
306: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
307: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
308: APP_EXCEPTION.Raise_Exception;
309: end;
310: END get_locator_controls;
311:
312:

Line 357: APP_EXCEPTION.Raise_Exception;

353: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
354: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_lot_number');
355: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
356: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
357: APP_EXCEPTION.Raise_Exception;
358:
359: end;
360: END valid_lot_number;
361:

Line 404: APP_EXCEPTION.Raise_Exception;

400: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
401: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_revision');
402: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
403: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
404: APP_EXCEPTION.Raise_Exception;
405: end;
406: END VALID_REVISION;
407:
408:

Line 464: APP_EXCEPTION.Raise_Exception;

460: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
461: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_locator_id');
462: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
463: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
464: APP_EXCEPTION.Raise_Exception;
465:
466: end;
467: END valid_locator_id;
468:

Line 528: APP_EXCEPTION.Raise_Exception;

524: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
525: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.default_locator');
526: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
527: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
528: APP_EXCEPTION.Raise_Exception;
529: end;
530: END default_locator;
531:
532:

Line 637: APP_EXCEPTION.Raise_Exception;

633: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
634: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_serial_number');
635: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
636: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
637: APP_EXCEPTION.Raise_Exception;
638:
639: end;
640: END valid_serial_number;
641:

Line 679: APP_EXCEPTION.Raise_Exception;

675: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
676: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.AR_INTERFACED');
677: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
678: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
679: APP_EXCEPTION.Raise_Exception;
680: end;
681:
682: END AR_INTERFACED;
683:

Line 719: APP_EXCEPTION.Raise_Exception;

715: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
716: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');
717: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
718: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
719: APP_EXCEPTION.Raise_Exception;
720: end;
721: END Valid_freight_type;
722:
723:

Line 760: APP_EXCEPTION.Raise_Exception;

756: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
757: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.valid_freight_type');
758: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
759: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
760: APP_EXCEPTION.Raise_Exception;
761: end;
762: END Valid_Carrier_Code;
763:
764:

Line 822: APP_EXCEPTION.Raise_Exception;

818: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
819: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_container_id');
820: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
821: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
822: APP_EXCEPTION.Raise_Exception;
823: end;
824: END Validate_container_id;
825:
826:

Line 889: APP_EXCEPTION.Raise_Exception;

885: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
886: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_currency');
887: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
888: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
889: APP_EXCEPTION.Raise_Exception;
890: end;
891:
892: END validate_currency;
893:

Line 933: APP_EXCEPTION.Raise_Exception;

929: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
930: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_uom');
931: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
932: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
933: APP_EXCEPTION.Raise_Exception;
934: end;
935:
936: END validate_uom;
937:

Line 976: APP_EXCEPTION.Raise_Exception;

972: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
973: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_user');
974: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
975: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
976: APP_EXCEPTION.Raise_Exception;
977: end;
978:
979: END validate_user;
980:

Line 1152: APP_EXCEPTION.Raise_Exception;

1148: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1149: FND_MESSAGE.Set_Token('PACKAGE','WSH_DEL_OI_CORE.validate_so_code');
1150: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1151: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1152: APP_EXCEPTION.Raise_Exception;
1153: end;
1154: END Validate_so_code;
1155:
1156: