[Home] [Help]
2388: l_prev_detail_id NUMBER;
2389: l_prev_sc_rule_id NUMBER;
2390: --
2391: l_done_flag VARCHAR2(1);
2392: l_pick_release_stat INV_PICK_RELEASE_PUB.INV_Release_Status_Tbl_Type;
2393: l_mmtt_tbl INV_MO_LINE_DETAIL_UTIL.G_MMTT_Tbl_Type;
2394: l_org_info WSH_PICK_LIST.Org_Params_Rec;
2395: l_tmp_rel_status VARCHAR2(1);
2396: --
2828: ELSE
2829: WSH_DEBUG_SV.logmsg(l_module_name, 'l_skip_cartonization is FALSE');
2830: END IF;
2831: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_RELEASE_PUB.PICK_RELEASE',
2833: WSH_DEBUG_SV.C_PROC_LEVEL);
2834: END IF;
2835: -- X-dock
2836: -- add parameters for X-dock
2842: -- P_WSH_RELEASE_TABLE(wsh_pr_criteria.release_table) : IN/OUT variable,
2843: -- in case of splitting of delivery details new records will be added
2844: -- to p_wsh_release_table
2845: --bug# 6689448 (replenishment project): added the parameter P_dynamic_replenishment_flag
2846: INV_Pick_Release_Pub.Pick_Release
2847: (p_api_version => l_api_version_number,
2848: p_init_msg_list => fnd_api.g_true,
2849: p_commit => l_commit,
2850: p_mo_line_tbl => g_trolin_tbl,
2862: x_msg_data => l_msg_data);
2863:
2864: IF l_debug_on THEN
2865: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2866: WSH_DEBUG_SV.log(l_module_name,'INV_Pick_Release_Pub.Pick_Release l_return_status',
2867: l_return_status);
2868: END IF;
2869: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2870: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2868: END IF;
2869: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2870: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2871: --{
2872: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Pick_Release_Pub.Pick_Release');
2873: FOR i in 1..l_msg_count LOOP
2874: l_message := fnd_msg_pub.get(i,'F');
2875: l_message := replace(l_message,chr(0),' ');
2876: WSH_UTIL_CORE.PrintMsg(l_message);
2880: END LOOP;
2881: l_completion_status := 'WARNING';
2882: fnd_msg_pub.delete_msg();
2883: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2884: WSH_UTIL_CORE.PrintMsg('Unexpected error from INV_Pick_Release_Pub.Pick_Release. Exiting');
2885: RAISE e_return;
2886: ELSE
2887: --{
2888: ROLLBACK TO BEF_MOVE_ORDER_LINE_CREATE;
5269: END IF;
5270:
5271: -- Call to WMS Cartonize API
5272: IF l_debug_on THEN
5273: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_RELEASE_PUB.Call_Cartonization'
5274: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5275: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5276: END IF;
5277: INV_PICK_RELEASE_PUB.Call_Cartonization (
5273: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_PICK_RELEASE_PUB.Call_Cartonization'
5274: ,WSH_DEBUG_SV.C_PROC_LEVEL);
5275: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5276: END IF;
5277: INV_PICK_RELEASE_PUB.Call_Cartonization (
5278: p_api_version => 1.0,
5279: p_init_msg_list => FND_API.G_FALSE,
5280: p_commit => FND_API.G_FALSE,
5281: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5288: x_msg_count => l_msg_count,
5289: x_msg_data => l_msg_data);
5290: IF l_debug_on THEN
5291: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
5292: WSH_DEBUG_SV.log(l_module_name,'Return status from INV_PICK_RELEASE_PUB.Call_Cartonization ', l_return_status);
5293: END IF;
5294: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5295: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
5296: WSH_UTIL_CORE.PrintMsg('Error occurred in INV_PICK_RELEASE_PUB.Call_Cartonization');
5292: WSH_DEBUG_SV.log(l_module_name,'Return status from INV_PICK_RELEASE_PUB.Call_Cartonization ', l_return_status);
5293: END IF;
5294: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5295: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
5296: WSH_UTIL_CORE.PrintMsg('Error occurred in INV_PICK_RELEASE_PUB.Call_Cartonization');
5297: RAISE e_return;
5298: END IF;
5299:
5300: l_detail_pfetch := c_wms_details%ROWCOUNT;