[Home] [Help]
1: PACKAGE BODY WSH_DELIVERY_DETAILS_GRP as
2: /* $Header: WSHDDGPB.pls 120.37.12020000.2 2012/11/21 12:32:20 ravmamid ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_GRP';
1: PACKAGE BODY WSH_DELIVERY_DETAILS_GRP as
2: /* $Header: WSHDDGPB.pls 120.37.12020000.2 2012/11/21 12:32:20 ravmamid ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERY_DETAILS_GRP';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7: c_wms_code_present VARCHAR2(1) := 'Y';
8:
9: -- anxsharm for Load Tender
46: --Added for bug 12850936
47: wv_frozen_flag,
48: wdd.inv_interfaced_flag
49: -- Added for bug 13574503
50: FROM wsh_delivery_details wdd,
51: wsh_delivery_assignments_v wda
52: WHERE wdd.delivery_detail_id = p_detail_id
53: AND wdd.delivery_detail_id = wda.delivery_detail_id;
54:
213: -- deliveryMerge
214: CURSOR c_get_assigned_delivery (c_delivery_detail_id NUMBER) IS
215: SELECT wda.delivery_id
216: FROM wsh_delivery_assignments_v wda,
217: wsh_delivery_details wdd
218: WHERE wda.delivery_detail_id = c_delivery_detail_id
219: AND wda.delivery_detail_id = wdd.delivery_detail_id
220: AND wdd.container_flag = 'N'
221: AND NVL(wdd.line_direction,'O') in ('O','IO');
408: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DLVB_COMMON_ACTIONS.UNASSIGN_DETAILS', wsh_debug_sv.c_proc_level);
409: END IF;
410:
411: /* Patchset I : Harmonization Project Begin
412: Instead of the old call to WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details We now have call to wsh_dlvb_common_actions.unassign_details */
413: -- deliveryMerge
414:
415: i := l_tabofdeldets.FIRST;
416: WHILE i is not NULL LOOP
609:
610: WHEN OTHERS THEN
611: ROLLBACK TO detail_to_delivery_grp;
612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
613: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
615: p_encoded => fnd_api.g_false);
616:
617: IF l_debug_on THEN
671: END IF;
672:
673:
674: IF l_debug_on THEN
675: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY', wsh_debug_sv.c_proc_level);
676: END IF;
677:
678: DETAIL_TO_DELIVERY
679: (
697: EXCEPTION
698:
699: WHEN OTHERS THEN
700: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
701: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704:
705: IF l_debug_on THEN
752: NVL(received_quantity, shipped_quantity),
753: NVL(received_quantity2, shipped_quantity2),
754: NVL(picked_quantity, requested_quantity),
755: NVL(picked_quantity2, requested_quantity2)
756: FROM wsh_delivery_details
757: WHERE delivery_detail_id = c_delivery_detail_id;
758:
759: wsh_invalid_split_qty EXCEPTION;
760: wsh_invalid_split_qty2 EXCEPTION; /* Added for OPM. NC - 03/19/01 */
781:
782: --
783: CURSOR det_cur(p_del_det_id NUMBER) IS
784: SELECT inventory_item_id, organization_id, requested_quantity_uom, top_model_line_id
785: FROM wsh_delivery_details
786: WHERE delivery_detail_id = p_del_det_id;
787: BEGIN
788: --
789: l_debug_on := wsh_debug_interface.g_debug;
915:
916: END IF;
917:
918: IF l_debug_on THEN
919: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS', wsh_debug_sv.c_proc_level);
920: END IF;
921:
922: --
923: -- HW added p_converted_flag
920: END IF;
921:
922: --
923: -- HW added p_converted_flag
924: wsh_delivery_details_actions.split_delivery_details(
925: p_from_detail_id => p_from_detail_id,
926: p_req_quantity => x_split_quantity,
927: p_req_quantity2 => x_split_quantity2,
928: p_manual_split => p_manual_split,
1051: WHEN OTHERS THEN
1052: ROLLBACK TO split_line_grp;
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: wsh_util_core.add_message(x_return_status, l_module_name);
1055: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1056:
1057: fnd_msg_pub.count_and_get(
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,
1140: l_org NUMBER;
1141:
1142: cursor get_org (p_detail_id in number)is
1143: select organization_id
1144: from wsh_delivery_details
1145: where delivery_detail_id = p_detail_id;
1146: --
1147: l_debug_on BOOLEAN;
1148: --
1495: END IF;
1496: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1498: WSH_UTIL_CORE.add_message (x_return_status);
1499: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => FND_API.G_FALSE
1576:
1577: /*
1578: EXCEPTION
1579: WHEN others then
1580: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');
1581: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1582: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1583: if x_msg_count > 1 then
1584: x_msg_data := l_msg_summary || l_msg_details;
1983: WHEN OTHERS THEN
1984: ROLLBACK TO AUTOCREATE_DEL_GRP;
1985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1986: wsh_util_core.add_message(x_return_status, l_module_name);
1987: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1988: --
1989: -- Start of code for Bugfix 4070732
1990: --
1991: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
2193: WHEN OTHERS THEN
2194: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2196: wsh_util_core.add_message(x_return_status, l_module_name);
2197: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,
2337: , organization_id
2338: , requested_quantity_uom
2339: , nvl(line_direction,'O') line_direction -- J-IB-NPARIKH
2340: , released_status
2341: FROM wsh_delivery_details
2342: WHERE delivery_detail_id = p_del_det_id;
2343:
2344: -- HW Harmonization project for OPM. Need to get organization_id
2345: -- HW OPMCONV - 1) Added retrieval of UOM2 -
2345: -- HW OPMCONV - 1) Added retrieval of UOM2 -
2346: -- - 2) Changed name to det_line
2347: CURSOR det_line(l_del_det_id NUMBER) IS
2348: SELECT nvl(line_direction,'O') line_direction, requested_quantity_uom2
2349: FROM wsh_delivery_details
2350: WHERE delivery_detail_id = l_del_det_id;
2351: -- HW OPM end
2352:
2353: --
2354: CURSOR cycle_count_cur(p_del_det_id NUMBER) IS
2355: SELECT released_status, requested_quantity, requested_quantity2,
2356: picked_quantity, picked_quantity2 , shipped_quantity , shipped_quantity2,
2357: organization_id, inventory_item_id , source_code -- RTV BO Cons Changes
2358: FROM wsh_delivery_details
2359: WHERE delivery_detail_id = p_del_det_id;
2360:
2361: --
2362: CURSOR del_cur(p_dlvy_id NUMBER) IS
2373: -- deliveryMerge
2374:
2375: CURSOR get_delivery(p_del_det_id NUMBER) IS
2376: SELECT wda.delivery_id
2377: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
2378: WHERE wdd.delivery_detail_id = p_del_det_id
2379: AND wdd.delivery_detail_id = wda.delivery_detail_id
2380: AND wdd.container_flag = 'N'
2381: AND wdd.source_code = 'OE'
2834:
2835: -- we need to send only the valid records to lock procedure
2836: -- Build the table using the valid index output from Is_Action_Enabled
2837: IF l_debug_on THEN
2838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2839: END IF;
2840: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
2841: AND p_action_prms.action_code = 'DELETE'
2842: ) THEN --BUG 4354579
2839: END IF;
2840: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
2841: AND p_action_prms.action_code = 'DELETE'
2842: ) THEN --BUG 4354579
2843: wsh_delivery_details_pkg.Lock_Delivery_Details(
2844: p_rec_attr_tab => p_rec_attr_tab,
2845: p_caller => p_action_prms.caller,
2846: p_valid_index_tab => l_valid_index_tab,
2847: x_valid_ids_tab => l_valid_ids_tab,
3150: l_index := l_id_tab.NEXT(l_index);
3151: END LOOP;
3152: --
3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,
3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,
3159: p_init_msg_list => FND_API.G_FALSE,
3160: p_commit => FND_API.G_FALSE,
3161: p_validation_level => l_validation_level,
3284:
3285: -- HW Harmonization project forOPM. Added p_manual_split parameter
3286: -- HW added p_converted_flag
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,
3286: -- HW added p_converted_flag
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,
3293: p_commit => FND_API.G_FALSE,
3294: p_validation_level => l_validation_level,
3316: --
3317: ELSIF p_action_prms.action_code = 'AUTOCREATE-DEL' THEN
3318: --
3319: IF l_debug_on THEN
3320: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3321: END IF;
3322: --
3323: --Compatibility Changes
3324: IF wsh_util_core.fte_is_installed = 'Y' AND l_cc_line_groups.COUNT>0 THEN
3355: IF l_debug_on THEN
3356: wsh_debug_sv.log(l_module_name,'id_tab_temp count ',l_id_tab_temp.COUNT);
3357: END IF;
3358:
3359: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3360: p_api_version_number => l_api_version,
3361: p_init_msg_list => FND_API.G_FALSE,
3362: p_commit => FND_API.G_FALSE,
3363: p_caller => p_action_prms.caller,
3446: END IF;
3447:
3448: ELSE
3449:
3450: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3451: p_api_version_number => l_api_version,
3452: p_init_msg_list => FND_API.G_FALSE,
3453: p_commit => FND_API.G_FALSE,
3454: p_caller => p_action_prms.caller,
3492: --
3493: ELSIF p_action_prms.action_code = 'AUTOCREATE-TRIP' THEN
3494: --
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3497: END IF;
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,
3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
3497: END IF;
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => l_return_status,
4605: IF cycle_count_cur%ISOPEN THEN
4606: Close cycle_count_cur;
4607: END IF;
4608: wsh_util_core.add_message(x_return_status, l_module_name);
4609: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');
4610: --
4611: -- K LPN CONV. rv
4612: --
4613: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4896: WHEN OTHERS THEN
4897: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4899: wsh_util_core.add_message(x_return_status, l_module_name);
4900: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4901: FND_MSG_PUB.Count_And_Get
4902: (
4903: p_count => x_msg_count,
4904: p_data => x_msg_data,
4960: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4961: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4962: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4963: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4964: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4965: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4966: l_wms_enabled BOOLEAN;
4967: l_return_status VARCHAR2(2);
4968: l_number_of_warnings NUMBER := 0;
5441: p_return_status => l_return_status,
5442: x_num_warnings => l_number_of_warnings,
5443: x_num_errors => l_number_of_errors
5444: );
5445: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5446: ( p_delivery_details_info => l_container_rec,
5447: p_num_of_rec => p_detail_IN_rec.quantity,
5448: p_container_info_rec => l_container_info_rec,
5449: x_return_status => l_return_status,
5473: x_num_warnings => l_number_of_warnings,
5474: x_num_errors => l_number_of_errors
5475: );
5476:
5477: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5478: ( p_delivery_assignments_info => l_del_assg_rec,
5479: p_num_of_rec => p_detail_IN_rec.quantity,
5480: p_dd_id_tab => l_cont_dummy_tab,
5481: x_da_id_tab => l_assignment_dummy_tab,
5553: p_return_status => l_return_status,
5554: x_num_warnings => l_number_of_warnings,
5555: x_num_errors => l_number_of_errors
5556: );
5557: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5558: ( p_delivery_details_info => l_container_rec,
5559: p_num_of_rec => 1,
5560: p_container_info_rec => l_container_info_rec,
5561: x_return_status => l_return_status,
5585: x_num_warnings => l_number_of_warnings,
5586: x_num_errors => l_number_of_errors
5587: );
5588:
5589: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5590: ( p_delivery_assignments_info => l_del_assg_rec,
5591: p_num_of_rec => 1,
5592: p_dd_id_tab => l_cont_dummy_tab,
5593: x_da_id_tab => l_assignment_dummy_tab,
5701: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5702: rollback to s_create_containers_DDGPB;
5703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5704: wsh_util_core.add_message(x_return_status, l_module_name);
5705: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5706: IF l_debug_on THEN
5707: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5708: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5709: END IF;
5747: l_new_detail_id NUMBER;
5748: l_dummy_rowid VARCHAR2(32767);
5749: l_dummy_assgn_rowid VARCHAR2(32767);
5750: l_delivery_assignment_id NUMBER;
5751: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
5752: l_item_type VARCHAR2(30);
5753:
5754: l_validation_level NUMBER;
5755:
5899: END IF; --}
5900:
5901:
5902: IF l_debug_on THEN
5903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5904: END IF;
5905: --
5906: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5907: p_delivery_details_info => p_detail_info_tab(l_index),
5902: IF l_debug_on THEN
5903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5904: END IF;
5905: --
5906: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5907: p_delivery_details_info => p_detail_info_tab(l_index),
5908: x_rowid => l_dummy_rowid,
5909: x_delivery_detail_id => l_new_detail_id,
5910: x_return_status => l_return_status);
5933: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
5934:
5935:
5936: IF l_debug_on THEN
5937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5938: END IF;
5939: --
5940: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5941: p_delivery_assignments_info => l_delivery_assignments_info,
5936: IF l_debug_on THEN
5937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5938: END IF;
5939: --
5940: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5941: p_delivery_assignments_info => l_delivery_assignments_info,
5942: x_rowid => l_dummy_assgn_rowid,
5943: x_delivery_assignment_id => l_delivery_assignment_id,
5944: x_return_status => l_return_status);
5999: --OTM R12, after loop call split with all the data
6000: IF (l_counter > 1) THEN
6001:
6002: IF l_debug_on THEN
6003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
6004: END IF;
6005:
6006: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
6007: p_detail_tab => l_delivery_detail_tab,
6002: IF l_debug_on THEN
6003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
6004: END IF;
6005:
6006: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
6007: p_detail_tab => l_delivery_detail_tab,
6008: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
6009: x_return_status => l_return_status);
6010:
6008: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
6009: x_return_status => l_return_status);
6010:
6011: IF l_debug_on THEN
6012: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
6013: END IF;
6014:
6015: -- we will not fail based on l_return_status here because
6016: -- we do not want to stop the flow
6086:
6087: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6089: wsh_util_core.add_message(x_return_status, l_module_name);
6090: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6091: FND_MSG_PUB.Count_And_Get
6092: (
6093: p_count => x_msg_count,
6094: p_data => x_msg_data,
6165: l_new_detail_id NUMBER;
6166: l_dummy_rowid NUMBER;
6167: l_dummy_assgn_rowid NUMBER;
6168: l_delivery_assignment_id NUMBER;
6169: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
6170: l_required_field VARCHAR2(32767);
6171:
6172: l_validation_level NUMBER;
6173: l_org_id NUMBER;
6210: subinventory,
6211: lot_number,
6212: released_status,
6213: requested_quantity_uom
6214: FROM wsh_delivery_details
6215: WHERE delivery_detail_id = x_detail_info_tab(p_counter).delivery_detail_id;
6216: -- AND source_code = p_source_code;
6217:
6218: l_old_delivery_detail_rec c_original_line%ROWTYPE;
6254: NVL(wdd.picked_quantity,
6255: wdd.requested_quantity)),
6256: wdd.inventory_item_id) ),
6257: wdd.inventory_item_id ) volume
6258: FROM wsh_delivery_details wdd,
6259: mtl_system_items msi
6260: WHERE wdd.delivery_detail_id = c_delivery_detail_id
6261: AND msi.inventory_item_id = wdd.inventory_item_id
6262: AND msi.organization_id = wdd.organization_id;
6933:
6934: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: wsh_util_core.add_message(x_return_status, l_module_name);
6937: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6938:
6939: FND_MSG_PUB.Count_And_Get
6940: (
6941: p_count => x_msg_count,
6969: IS
6970:
6971: cursor lock_delivery_details(p_del_det IN NUMBER) is
6972: select delivery_detail_id
6973: from wsh_delivery_details
6974: where delivery_detail_id = p_del_det
6975: for update nowait;
6976:
6977:
7046: END IF;
7047:
7048:
7049: IF l_debug_on THEN
7050: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
7051: END IF;
7052: --
7053: wsh_delivery_details_pkg.Update_Delivery_Details(
7054: p_rowid => p_detail_info_tab(l_index).rowid,
7049: IF l_debug_on THEN
7050: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
7051: END IF;
7052: --
7053: wsh_delivery_details_pkg.Update_Delivery_Details(
7054: p_rowid => p_detail_info_tab(l_index).rowid,
7055: p_delivery_details_info => p_detail_info_tab(l_index),
7056: x_return_status => l_return_status);
7057:
7255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7256: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7257: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7258: wsh_util_core.add_message(x_return_status, l_module_name);
7259: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7260:
7261: FND_MSG_PUB.Count_And_Get
7262: (
7263: p_count => x_msg_count,
7463:
7464: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7466: wsh_util_core.add_message(x_return_status, l_module_name);
7467: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7468: FND_MSG_PUB.Count_And_Get
7469: (
7470: p_count => x_msg_count,
7471: p_data => x_msg_data,
7534: -- HW OPMCONV - Increased length to 80
7535: l_lot VARCHAR2(80);
7536: l_result BOOLEAN;
7537: l_quantity NUMBER;
7538: l_inv_controls wsh_delivery_details_inv.inv_control_flag_rec;
7539: l_ship_method_name VARCHAR2(32767);
7540: -- HW Harmonization project for OPM. Added l_process flag variable
7541: -- HW OPMCONV - Removed OPM variables
7542:
7611: --added cursor to fetch lpn_id for bug 12597783.
7612:
7613: CURSOR get_lpn_id IS
7614: SELECT wdd.lpn_id
7615: FROM wsh_delivery_details wdd
7616: ,wsh_delivery_assignments wda
7617: WHERE wdd.delivery_detail_id = wda.parent_delivery_detail_id
7618: AND wda.delivery_detail_id = x_detail_rec.delivery_detail_id
7619: AND wdd.container_flag = 'Y';
7732:
7733: l_org_id := p_original_rec.organization_id;
7734:
7735: /***************Material Status Impact***********/
7736: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
7737: p_source_line_id => x_detail_rec.source_line_id, --RTV changes
7738: p_source_code => x_detail_rec.source_code, --RTV changes
7739: x_transaction_type_id => l_trx_type_id,
7740: x_return_status => l_return_status);
7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN
7789: --(
7790: IF l_debug_on THEN
7791: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7792: END IF;
7793:
7794: wsh_delivery_details_inv.fetch_inv_controls(
7795: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
7790: IF l_debug_on THEN
7791: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7792: END IF;
7793:
7794: wsh_delivery_details_inv.fetch_inv_controls(
7795: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
7796: p_inventory_item_id => p_original_rec.inventory_item_id,
7797: p_organization_id => l_org_id,
7798: p_subinventory => l_subinventory,
8147: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8148: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8149: IF l_debug_on THEN
8150: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8152: END IF;
8153:
8154: --
8155: wsh_delivery_details_inv.validate_subinventory(
8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8152: END IF;
8153:
8154: --
8155: wsh_delivery_details_inv.validate_subinventory(
8156: p_subinventory => x_detail_rec.subinventory,
8157: p_organization_id => l_org_id,
8158: p_inventory_item_id => p_original_rec.inventory_item_id,
8159: p_transaction_type_id => l_trx_type_id,
8208: END IF;
8209: ELSE
8210: IF l_debug_on THEN
8211: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8212: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8213: END IF;
8214:
8215: wsh_delivery_details_inv.validate_revision(
8216: p_revision => x_detail_rec.revision,
8211: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8212: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8213: END IF;
8214:
8215: wsh_delivery_details_inv.validate_revision(
8216: p_revision => x_detail_rec.revision,
8217: p_organization_id => l_org_id,
8218: p_inventory_item_id => p_original_rec.inventory_item_id,
8219: x_return_status => l_return_status,
8269: ELSE
8270:
8271: IF l_debug_on THEN
8272: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8274: END IF;
8275: wsh_delivery_details_inv.validate_locator(
8276: p_locator_id => x_detail_rec.locator_id,
8277: p_organization_id => l_org_id,
8271: IF l_debug_on THEN
8272: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8274: END IF;
8275: wsh_delivery_details_inv.validate_locator(
8276: p_locator_id => x_detail_rec.locator_id,
8277: p_organization_id => l_org_id,
8278: p_inventory_item_id => p_original_rec.inventory_item_id,
8279: p_subinventory => l_subinventory,
8335: END IF;
8336: ELSE
8337: -- bug 4766908 get the reservable_flag
8338: IF p_original_rec.released_status = 'Y' THEN
8339: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
8340: x_item_id => p_original_rec.inventory_item_id,
8341: x_organization_id => p_original_rec.organization_id,
8342: x_pickable_flag => p_original_rec.pickable_flag);
8343: END IF;
8342: x_pickable_flag => p_original_rec.pickable_flag);
8343: END IF;
8344: IF (nvl(l_reservable_flag, 'Y') = 'Y') THEN
8345: IF l_debug_on THEN
8346: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8347: END IF;
8348:
8349: wsh_delivery_details_inv.validate_lot_number(
8350: p_lot_number => x_detail_rec.lot_number,
8345: IF l_debug_on THEN
8346: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8347: END IF;
8348:
8349: wsh_delivery_details_inv.validate_lot_number(
8350: p_lot_number => x_detail_rec.lot_number,
8351: p_organization_id => l_org_id,
8352: p_inventory_item_id => p_original_rec.inventory_item_id,
8353: p_revision => l_revision,
8827: -- x_detail_rec.serial_number <> p_original_rec.serial_number)
8828: THEN
8829:
8830: IF l_debug_on THEN
8831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8832: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8833: END IF;
8834: wsh_delivery_details_inv.unmark_serial_number(
8835: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8830: IF l_debug_on THEN
8831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8832: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8833: END IF;
8834: wsh_delivery_details_inv.unmark_serial_number(
8835: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8836: p_serial_number_code => l_inv_controls.serial_code,
8837: p_serial_number => p_original_rec.serial_number,
8838: p_transaction_temp_id => NULL,
8860: -- derive serial number from MSNT for this transaction temp id
8861: -- compare with x_detail_rec.serial_number
8862:
8863: IF l_debug_on THEN
8864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8865: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8866: END IF;
8867: wsh_delivery_details_inv.unmark_serial_number(
8868: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8863: IF l_debug_on THEN
8864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8865: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8866: END IF;
8867: wsh_delivery_details_inv.unmark_serial_number(
8868: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8869: p_serial_number_code => l_inv_controls.serial_code,
8870: p_serial_number => NULL,
8871: p_transaction_temp_id => p_original_rec.transaction_temp_id,
8897: IF l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8898: IF l_debug_on THEN
8899: WSH_DEBUG_SV.log(l_module_name, 'To Serial Number', l_det_ser_range_tab(l_det_index).to_serial_number);
8900: WSH_DEBUG_SV.log(l_module_name, 'Transaction Id', l_transaction_id);
8901: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8902: END IF;
8903:
8904: --
8905: -- Validates the Range of Serial Number
8902: END IF;
8903:
8904: --
8905: -- Validates the Range of Serial Number
8906: wsh_delivery_details_inv.validate_serial_range(
8907: p_from_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8908: p_to_serial_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8909: p_lot_number => l_lot,
8910: p_organization_id => l_org_id,
8938: p_msg_data => l_msg_data
8939: );
8940: ELSE
8941: IF l_debug_on THEN
8942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8943: END IF;
8944:
8945: --
8946: wsh_delivery_details_inv.validate_serial(
8942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8943: END IF;
8944:
8945: --
8946: wsh_delivery_details_inv.validate_serial(
8947: p_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8948: p_lot_number => l_lot,
8949: p_organization_id => l_org_id,
8950: p_inventory_item_id => p_original_rec.inventory_item_id,
8986: )
8987: AND l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8988: IF l_debug_on THEN
8989: WSH_DEBUG_SV.log(l_module_name, 'Transaction id created', l_transaction_id);
8990: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8991: END IF;
8992:
8993: --
8994: -- Creates/Validates the Range of Serial Number
8991: END IF;
8992:
8993: --
8994: -- Creates/Validates the Range of Serial Number
8995: wsh_delivery_details_inv.create_dynamic_serial_range(
8996: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8997: p_to_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8998: -- Earlier l_transaction_id was being passed to p_delivery_detail below (frontport from 1159) - jckwok
8999: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9016: p_msg_data => l_msg_data
9017: );
9018: ELSE
9019: IF l_debug_on THEN
9020: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
9021: END IF;
9022:
9023: --
9024: wsh_delivery_details_inv.create_dynamic_serial(
9020: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
9021: END IF;
9022:
9023: --
9024: wsh_delivery_details_inv.create_dynamic_serial(
9025: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
9026: p_to_number => l_det_ser_range_tab(l_det_index).from_serial_number,
9027: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9028: p_source_line_id => p_original_rec.source_line_id,
9183: --{
9184: IF l_transaction_id IS NOT NULL
9185: THEN
9186: -- (
9187: wsh_delivery_details_inv.mark_serial_number(
9188: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9189: p_serial_number => NULL,
9190: p_transaction_temp_id => l_transaction_id,
9191: x_return_status => l_return_status
9200: AND p_in_detail_rec.serial_number <> FND_API.G_MISS_CHAR
9201: THEN
9202: --
9203: IF l_debug_on THEN
9204: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9205: END IF;
9206:
9207: --
9208: wsh_delivery_details_inv.mark_serial_number(
9204: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9205: END IF;
9206:
9207: --
9208: wsh_delivery_details_inv.mark_serial_number(
9209: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9210: p_serial_number => p_in_detail_rec.serial_number,
9211: p_transaction_temp_id => l_transaction_id,
9212: x_return_status => l_return_status
9228: -- newly generated transaction_temp_id in the scenario where
9229: -- only the serial attributes are updated and not the serial #
9230: --
9231: IF l_debug_on THEN
9232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9233: END IF;
9234: --
9235: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9236: p_from_serial_number => p_original_rec.serial_number,
9231: IF l_debug_on THEN
9232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9233: END IF;
9234: --
9235: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9236: p_from_serial_number => p_original_rec.serial_number,
9237: p_to_serial_number => NULL, -- always pass NULL for single serial number
9238: p_inventory_item_id => p_original_rec.inventory_item_id,
9239: p_organization_id => l_org_id,
9337: WHEN OTHERS THEN
9338: ROLLBACK TO validate_det_line_grp;
9339: x_return_status := fnd_api.g_ret_sts_unexp_error;
9340: wsh_util_core.add_message(x_return_status, l_module_name);
9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9342: fnd_msg_pub.count_and_get(
9343: p_count => x_msg_count,
9344: p_data => x_msg_data,
9345: p_encoded => fnd_api.g_false);
9544: WHEN OTHERS THEN
9545: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9547: wsh_util_core.add_message(x_return_status, l_module_name);
9548: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9549: FND_MSG_PUB.Count_And_Get
9550: (
9551: p_count => x_msg_count,
9552: p_data => x_msg_data,
9880: WHEN OTHERS THEN
9881: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9883: wsh_util_core.add_message(x_return_status, l_module_name);
9884: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9885: FND_MSG_PUB.Count_And_Get
9886: (
9887: p_count => x_msg_count,
9888: p_data => x_msg_data,
9996:
9997: WHEN OTHERS THEN
9998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9999: wsh_util_core.add_message(x_return_status, l_module_name);
10000: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
10001: --
10002:
10003: IF l_debug_on THEN
10004: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10819: WHEN OTHERS THEN
10820: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10822: wsh_util_core.add_message(x_return_status, l_module_name);
10823: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10824: --
10825: -- Start code for Bugfix 4070732
10826: --
10827: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10991:
10992: WHEN OTHERS THEN
10993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10994: wsh_util_core.add_message(x_return_status, l_module_name);
10995: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10996: --
10997: IF l_debug_on THEN
10998: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10999: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
10999: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
11000: END IF;
11001: END Get_Carton_Grouping;
11002:
11003: END WSH_DELIVERY_DETAILS_GRP;