APPS.WSH_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_INBOUND_SHIP_ADVICE_PKG

Line 1: PACKAGE BODY WSH_INBOUND_SHIP_ADVICE_PKG as

1: PACKAGE BODY WSH_INBOUND_SHIP_ADVICE_PKG as
2: /* $Header: WSHINSAB.pls 120.5 2011/12/21 10:12:24 skanduku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INBOUND_SHIP_ADVICE_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INBOUND_SHIP_ADVICE_PKG';

1: PACKAGE BODY WSH_INBOUND_SHIP_ADVICE_PKG as
2: /* $Header: WSHINSAB.pls 120.5 2011/12/21 10:12:24 skanduku ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INBOUND_SHIP_ADVICE_PKG';
6: --
7: PROCEDURE Process_Ship_Advice(
8: p_delivery_interface_id IN NUMBER,
9: p_event_key IN VARCHAR2,

Line 219: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

215: -- For delivery details, only the non-container records would be checked
216: -- Because, for inbound from TPW, there could be new delivery details for containers
217:
218: -- TPW - Distributed changes
219: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN
220: WSH_INTERFACE_VALIDATIONS_PKG.Validate_Delivery_Details
221: (p_delivery_interface_id => p_delivery_interface_id,
222: x_return_Status => l_return_status);
223: IF l_debug_on THEN

Line 263: IF (l_delivery_id IS NULL) AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ('TPW', 'CMS')) THEN

259: END IF;
260: END IF; */
261:
262: -- TPW - Distributed changes
263: IF (l_delivery_id IS NULL) AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') in ('TPW', 'CMS')) THEN
264: raise invalid_input;
265: END IF;
266:
267: SAVEPOINT before_update_dlvy_det;

Line 272: IF nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2' THEN

268:
269: BEGIN
270:
271: -- TPW - Distributed changes
272: IF nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2' THEN
273: WSH_INTERFACE_COMMON_ACTIONS.Delivery_Interface_Wrapper(
274: p_delivery_interface_id => p_delivery_interface_id,
275: p_action_code => 'CREATE',
276: x_delivery_id => l_delivery_id,

Line 626: END WSH_INBOUND_SHIP_ADVICE_PKG;

622:
623: END Process_Ship_Advice;
624:
625:
626: END WSH_INBOUND_SHIP_ADVICE_PKG;