APPS.WMS_SHIPPING_PUB dependencies on WMS_GLOBALS

Line 77: debug('wms_globals.g_ship_confirm_method: ' || wms_globals.g_ship_confirm_method);

73: l_delivery_id := p_delivery_ids(i);
74:
75: IF (l_debug = 1) THEN
76: debug('Deleted Delivery : '||l_delivery_id);
77: debug('wms_globals.g_ship_confirm_method: ' || wms_globals.g_ship_confirm_method);
78: END IF;
79:
80: OPEN get_delivery_detail_id(l_delivery_id);
81: LOOP

Line 87: debug('wms_globals.g_ship_confirm_method : ' || wms_globals.g_ship_confirm_method);

83: INTO l_delivery_detail_id;
84: EXIT WHEN get_delivery_detail_id%notfound;
85:
86: IF l_debug = 1 THEN
87: debug('wms_globals.g_ship_confirm_method : ' || wms_globals.g_ship_confirm_method);
88: END IF;
89:
90: -- MRANA .. bug4287561
91: -- Added the condition around the delete, as it should happen only if

Line 93: IF (wms_globals.g_ship_confirm_method IS NULL OR

89:
90: -- MRANA .. bug4287561
91: -- Added the condition around the delete, as it should happen only if
92: --it is not called from direct ship
93: IF (wms_globals.g_ship_confirm_method IS NULL OR
94: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
95:
96: IF l_organization_id IS NULL THEN
97: -- Assuming that all deliveries being ship confirmed belong to the same org

Line 94: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN

90: -- MRANA .. bug4287561
91: -- Added the condition around the delete, as it should happen only if
92: --it is not called from direct ship
93: IF (wms_globals.g_ship_confirm_method IS NULL OR
94: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
95:
96: IF l_organization_id IS NULL THEN
97: -- Assuming that all deliveries being ship confirmed belong to the same org
98: SELECT organization_id

Line 180: END IF; -- wms_globals.g_ship_confirm_method <> 'DIRECT' THEN

176: debug('Updated wms_license_plate_numbers : ' || l_outermost_lpn_id);
177: END IF;
178: END LOOP;
179: CLOSE get_lpn_id; */
180: END IF; -- wms_globals.g_ship_confirm_method <> 'DIRECT' THEN
181: END LOOP;
182:
183: IF l_debug = 1 THEN
184: debug('deleting wms_direct_ship_temp ' || l_delivery_detail_id);

Line 194: IF (wms_globals.g_ship_confirm_method IS NULL OR

190: -- Moved the deletion of the temp table records from delivery
191: -- detail loop to delivery_id loop for better efficieny.
192: -- In case this API is called from direct ship page, we do
193: -- not want to delete these records since it happens in DS page
194: IF (wms_globals.g_ship_confirm_method IS NULL OR
195: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
196: BEGIN
197: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
198:

Line 195: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN

191: -- detail loop to delivery_id loop for better efficieny.
192: -- In case this API is called from direct ship page, we do
193: -- not want to delete these records since it happens in DS page
194: IF (wms_globals.g_ship_confirm_method IS NULL OR
195: wms_globals.g_ship_confirm_method <> 'DIRECT') THEN
196: BEGIN
197: IF l_debug = 1 THEN debug('Ready to delete wms_direct_ship_temp '); END IF;
198:
199: DELETE FROM wms_direct_ship_temp