DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on INV_PICK_RELEASE_PUB

Line 2453: l_pick_release_stat INV_PICK_RELEASE_PUB.INV_Release_Status_Tbl_Type;

2449: l_prev_detail_id NUMBER;
2450: l_prev_sc_rule_id NUMBER;
2451: --
2452: l_done_flag VARCHAR2(1);
2453: l_pick_release_stat INV_PICK_RELEASE_PUB.INV_Release_Status_Tbl_Type;
2454: l_mmtt_tbl INV_MO_LINE_DETAIL_UTIL.G_MMTT_Tbl_Type;
2455: l_org_info WSH_PICK_LIST.Org_Params_Rec;
2456: l_tmp_rel_status VARCHAR2(1);
2457: --

Line 2906: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE',

2902: ELSE
2903: WSH_DEBUG_SV.logmsg(l_module_name, 'l_skip_cartonization is FALSE');
2904: END IF;
2905: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2906: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE',
2907: WSH_DEBUG_SV.C_PROC_LEVEL);
2908: END IF;
2909: -- X-dock
2910: -- add parameters for X-dock

Line 2920: INV_Pick_Release_Pub.Pick_Release

2916: -- P_WSH_RELEASE_TABLE(wsh_pr_criteria.release_table) : IN/OUT variable,
2917: -- in case of splitting of delivery details new records will be added
2918: -- to p_wsh_release_table
2919: --bug# 6689448 (replenishment project): added the parameter P_dynamic_replenishment_flag
2920: INV_Pick_Release_Pub.Pick_Release
2921: (p_api_version => l_api_version_number,
2922: p_init_msg_list => fnd_api.g_true,
2923: p_commit => l_commit,
2924: p_mo_line_tbl => g_trolin_tbl,

Line 2940: WSH_DEBUG_SV.log(l_module_name,'INV_Pick_Release_Pub.Pick_Release l_return_status',

2936: x_msg_data => l_msg_data);
2937:
2938: IF l_debug_on THEN
2939: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2940: WSH_DEBUG_SV.log(l_module_name,'INV_Pick_Release_Pub.Pick_Release l_return_status',
2941: l_return_status);
2942: END IF;
2943: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2944: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

Line 2946: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Pick_Release_Pub.Pick_Release');

2942: END IF;
2943: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2944: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2945: --{
2946: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Pick_Release_Pub.Pick_Release');
2947: FOR i in 1..l_msg_count LOOP
2948: l_message := fnd_msg_pub.get(i,'F');
2949: l_message := replace(l_message,chr(0),' ');
2950: WSH_UTIL_CORE.PrintMsg(l_message);

Line 2958: WSH_UTIL_CORE.PrintMsg('Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting');

2954: END LOOP;
2955: l_completion_status := 'WARNING';
2956: fnd_msg_pub.delete_msg();
2957: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2958: WSH_UTIL_CORE.PrintMsg('Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting');
2959: RAISE e_return;
2960: ELSE
2961: --{
2962: ROLLBACK TO BEF_MOVE_ORDER_LINE_CREATE;