44: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
45: --
46: IF l_debug_on IS NULL
47: THEN
48: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
49: END IF;
50: --
51: IF l_debug_on THEN
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
48: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
49: END IF;
50: --
51: IF l_debug_on THEN
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
49: END IF;
50: --
51: IF l_debug_on THEN
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
50: --
51: IF l_debug_on THEN
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
51: IF l_debug_on THEN
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
52: wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
53: wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
54: wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
55: wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
56: wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64: wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
57: wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64: wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
65: END IF;
58: wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64: wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
65: END IF;
66:
59: wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64: wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
65: END IF;
66:
67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
60: wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61: wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62: wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63: wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64: wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
65: END IF;
66:
67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
68:
268: l_in_rec.action_code := 'CREATE';
269:
270:
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
273: END IF;
274:
275: wsh_interface_grp.create_update_delivery_detail(
276: p_api_version_number => l_api_version,
294: x_delivery_Detail_id := l_out_rec.detail_ids(l_out_rec.detail_ids.first);
295:
296: END IF;
297: IF l_debug_on THEN
298: wsh_debug_sv.pop(l_module_name);
299: END IF;
300:
301: EXCEPTION
302: when fnd_api.g_exc_error then
302: when fnd_api.g_exc_error then
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304:
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309: --
310: when others then
303: x_return_status := FND_API.G_RET_STS_ERROR ;
304:
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308: END IF;
309: --
310: when others then
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
310: when others then
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
312: wsh_util_core.default_handler('WSH_INTERFACE_PUB.Create_Shipment_Lines');
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
315: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
317: END IF;
318:
311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
312: wsh_util_core.default_handler('WSH_INTERFACE_PUB.Create_Shipment_Lines');
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
315: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
317: END IF;
318:
319: END Create_Shipment_Lines;
312: wsh_util_core.default_handler('WSH_INTERFACE_PUB.Create_Shipment_Lines');
313: IF l_debug_on THEN
314: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
315: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
316: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
317: END IF;
318:
319: END Create_Shipment_Lines;
320: