DBA Data[Home] [Help]

APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_MAP_LOCATION_REGION_PKG

Line 1760: --not happen in WSH_MAP_LOCATION_REGION_PKG.Rule_Location

1756: MO_GLOBAL.init('ONT'); -- 1/2/2009 => Added this for integration testing after discussing with Srihari Mani
1757: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1758:
1759: --Setting value for G_MODE to 'STANDALONE', so that intermediate COMMIT does
1760: --not happen in WSH_MAP_LOCATION_REGION_PKG.Rule_Location
1761: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'STANDALONE';
1762:
1763: --
1764: IF l_debug_on THEN

Line 1761: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'STANDALONE';

1757: MO_GLOBAL.Set_Policy_Context('S', l_org_id);
1758:
1759: --Setting value for G_MODE to 'STANDALONE', so that intermediate COMMIT does
1760: --not happen in WSH_MAP_LOCATION_REGION_PKG.Rule_Location
1761: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'STANDALONE';
1762:
1763: --
1764: IF l_debug_on THEN
1765: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Print_OE_Header_Record', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1837: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';

1833: p_line_customer_info_tbl => l_line_customer_info_tbl,
1834: p_control_rec => l_control_rec );
1835:
1836: --Setting value for G_MODE back to 'NORMAL'
1837: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';
1838: l_po_end_time := SYSDATE;
1839: l_po_tot_time := ( l_po_end_time - l_po_start_time ) * 24 * 60 * 60;
1840: g_po_total_time := g_po_total_time + l_po_tot_time;
1841:

Line 2522: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN

2518: END IF;
2519: --
2520: ROLLBACK;
2521: --Setting value for G_MODE back to 'NORMAL'
2522: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN
2523: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';
2524: END IF;
2525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2526:

Line 2523: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';

2519: --
2520: ROLLBACK;
2521: --Setting value for G_MODE back to 'NORMAL'
2522: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN
2523: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';
2524: END IF;
2525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2526:
2527: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 2566: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN

2562: END IF;
2563: --
2564: ROLLBACK;
2565: --Setting value for G_MODE back to 'NORMAL'
2566: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN
2567: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';
2568: END IF;
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2570:

Line 2567: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';

2563: --
2564: ROLLBACK;
2565: --Setting value for G_MODE back to 'NORMAL'
2566: IF WSH_MAP_LOCATION_REGION_PKG.G_MODE <> 'NORMAL' THEN
2567: WSH_MAP_LOCATION_REGION_PKG.G_MODE := 'NORMAL';
2568: END IF;
2569: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2570:
2571: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'