DBA Data[Home] [Help]

APPS.WMS_ENGINE_PVT dependencies on WMS_ENGINE_PVT

Line 1: PACKAGE BODY wms_engine_pvt AS

1: PACKAGE BODY wms_engine_pvt AS
2: /* $Header: WMSVPPEB.pls 120.33.12020000.6 2013/02/22 21:49:55 sahmahes ship $ */
3: --
4: -- File : WMSVPPEB.pls
5: -- Content : WMS_Engine_PVT package body

Line 5: -- Content : WMS_Engine_PVT package body

1: PACKAGE BODY wms_engine_pvt AS
2: /* $Header: WMSVPPEB.pls 120.33.12020000.6 2013/02/22 21:49:55 sahmahes ship $ */
3: --
4: -- File : WMSVPPEB.pls
5: -- Content : WMS_Engine_PVT package body
6: -- Description : wms rules engine private API's
7: -- Notes :
8: -- Modified : 30/10/98 ckuenzel created orginal file in inventory
9: -- 02/08/99 mzeckzer changed

Line 13: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Engine_PVT';

9: -- 02/08/99 mzeckzer changed
10: -- 07/31/99 bitang created in wms
11: -- 05/12/05 grao added logic for rule search - 'K'
12: --
13: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Engine_PVT';
14: g_debug NUMBER;
15: g_use_rule VARCHAR2(1) := 'Y' ;
16: -- [g_use_rule VARCHAR2(1) := 'Y'; used to track if stg/rule
17: -- search API is required to be called or not ]

Line 562: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remaining_quantity > 0)

558: );
559:
560: -- Bug # 2286454 ----
561: --
562: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remaining_quantity > 0)
563: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remaining_sec_qty > 0)
564: THEN
565: l_allow_non_partial_rules := FALSE;
566: ELSE

Line 563: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remaining_sec_qty > 0)

559:
560: -- Bug # 2286454 ----
561: --
562: IF (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'P' AND l_remaining_quantity > 0)
563: OR (NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' AND l_remaining_sec_qty > 0)
564: THEN
565: l_allow_non_partial_rules := FALSE;
566: ELSE
567: l_allow_non_partial_rules := TRUE;

Line 2797: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or

2793: END IF;
2794: IF l_return_status <> fnd_api.g_ret_sts_success then
2795: RAISE fnd_api.g_exc_error;
2796: ELSE
2797: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then
2799: IF l_debug = 1 THEN
2800: log_event(l_api_name, 'Create Suggestions',
2801: 'Quick Pick Validation failure message '

Line 2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then

2794: IF l_return_status <> fnd_api.g_ret_sts_success then
2795: RAISE fnd_api.g_exc_error;
2796: ELSE
2797: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then
2799: IF l_debug = 1 THEN
2800: log_event(l_api_name, 'Create Suggestions',
2801: 'Quick Pick Validation failure message '
2802: || WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE );

Line 2802: || WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE );

2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then
2799: IF l_debug = 1 THEN
2800: log_event(l_api_name, 'Create Suggestions',
2801: 'Quick Pick Validation failure message '
2802: || WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE );
2803: END IF;
2804: ROLLBACK TO create_suggestions_sa;
2805: exit;
2806: END IF;

Line 2947: x_msg_data := nvl(WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE, '');

2943: END IF;
2944:
2945: -- Patchset 'J' : New Error_messages
2946: -- Adding the Suggestion failure message to the message stack
2947: x_msg_data := nvl(WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE, '');
2948:
2949: --BUG 3440344: We should not add message to the stack if
2950: --G_SUGG_FAILURE_MESSAGE is null
2951: IF x_msg_data IS NOT NULL OR x_msg_data <> '' THEN

Line 2952: FND_MESSAGE.SET_NAME('WMS',WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE);

2948:
2949: --BUG 3440344: We should not add message to the stack if
2950: --G_SUGG_FAILURE_MESSAGE is null
2951: IF x_msg_data IS NOT NULL OR x_msg_data <> '' THEN
2952: FND_MESSAGE.SET_NAME('WMS',WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE);
2953: FND_MSG_PUB.ADD;
2954: END IF;
2955:
2956: IF l_debug = 1 THEN

Line 3114: END wms_engine_pvt;

3110: RETURN FALSE;
3111: END check_exp_lot_txn_allowed;
3112: -- 10182554 Function End
3113: --
3114: END wms_engine_pvt;