262: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
263: --
264: IF l_debug_on IS NULL
265: THEN
266: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
267: END IF;
268: --
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.push(l_module_name);
266: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
267: END IF;
268: --
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.push(l_module_name);
271: END IF;
272:
273: --bug 10233629: Caching Inventory Item record
274: get_inv_item_table_index(
279: x_flag => l_flag );
280:
281: IF l_flag = 'U' AND l_index IS NOT NULL THEN
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.logmsg(l_module_name,'Organization ' || p_org.organization_id || ' and Inventory item ' || p_item.inventory_item_id || ' is not yet cached');
284: END IF ;
285:
286: SELECT *
287: INTO p_item
291: -- add record to cache
292: g_inv_item_tab(l_index) := p_item;
293: ELSE
294: IF l_debug_on THEN
295: WSH_DEBUG_SV.logmsg(l_module_name,'Organization ' || p_org.organization_id || ' and Inventory item ' || p_item.inventory_item_id || ' is already cached');
296: END IF;
297: -- retrieve record from cache
298: p_item := g_inv_item_tab(l_index);
299: END IF;
302: --
303: -- Debug Statements
304: --
305: IF l_debug_on THEN
306: WSH_DEBUG_SV.pop(l_module_name);
307: END IF;
308: --
309: RETURN INV_VALIDATE.T;
310:
323: --
324: -- Debug Statements
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
328: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
329: END IF;
330: --
331: RETURN INV_VALIDATE.F;
324: -- Debug Statements
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
328: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
329: END IF;
330: --
331: RETURN INV_VALIDATE.F;
332:
343: --
344: -- Debug Statements
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
349: END IF;
350: --
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: -- Debug Statements
345: --
346: IF l_debug_on THEN
347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
349: END IF;
350: --
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352:
386:
387: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
388: IF l_debug_on IS NULL
389: THEN
390: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
391: END IF;
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.push(l_module_name);
394: END IF;
389: THEN
390: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
391: END IF;
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.push(l_module_name);
394: END IF;
395:
396: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
397:
410: END IF;
411: CLOSE c_org_param_info;
412:
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.stock_locator_control_code',l_cache_rec.stock_locator_control_code);
415: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.negative_inv_receipt_code',l_cache_rec.negative_inv_receipt_code);
416: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.serial_number_type',l_cache_rec.serial_number_type);
417: END IF;
418: -- add record to cache
411: CLOSE c_org_param_info;
412:
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.stock_locator_control_code',l_cache_rec.stock_locator_control_code);
415: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.negative_inv_receipt_code',l_cache_rec.negative_inv_receipt_code);
416: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.serial_number_type',l_cache_rec.serial_number_type);
417: END IF;
418: -- add record to cache
419: g_param_tab(p_organization_id) := l_cache_rec;
412:
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.stock_locator_control_code',l_cache_rec.stock_locator_control_code);
415: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.negative_inv_receipt_code',l_cache_rec.negative_inv_receipt_code);
416: WSH_DEBUG_SV.log(l_module_name,'l_cache_rec.serial_number_type',l_cache_rec.serial_number_type);
417: END IF;
418: -- add record to cache
419: g_param_tab(p_organization_id) := l_cache_rec;
420: END IF;
425:
426: ELSE -- Org is is null
427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
430: END IF;
431: --
432: RETURN;
433: END IF;
432: RETURN;
433: END IF;
434:
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
437: END IF;
438:
439: EXCEPTION
440:
442: wsh_util_core.default_handler ('WSH_DELIVERY_DETAILS_INV.Get_Org_Param_information');
443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
444:
445: IF l_debug_on THEN
446: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
447: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
448: END IF;
449:
450: IF c_org_param_info%isopen THEN
443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
444:
445: IF l_debug_on THEN
446: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
447: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
448: END IF;
449:
450: IF c_org_param_info%isopen THEN
451: close c_org_param_info;
489:
490: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
491: IF l_debug_on IS NULL
492: THEN
493: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
494: END IF;
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.push(l_module_name);
497: END IF;
492: THEN
493: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
494: END IF;
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.push(l_module_name);
497: END IF;
498:
499: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
500:
515:
516: -- add record to cache
517: g_sec_inv_tab(l_key) := l_cache_rec;
518: IF l_debug_on THEN
519: WSH_DEBUG_SV.log(l_module_name,'x_mtl_sec_inv_rec.locator_type',x_mtl_sec_inv_rec.locator_type);
520: END IF;
521:
522: END IF;
523:
525:
526: ELSE -- Org is is null
527: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.pop(l_module_name, x_return_status);
530: END IF;
531: --
532: RETURN;
533: END IF;
532: RETURN;
533: END IF;
534:
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
537: END IF;
538:
539: EXCEPTION
540:
542: wsh_util_core.default_handler ('WSH_DELIVERY_DETAILS_INV.Get_Sec_Inv_information');
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
544:
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
548: END IF;
549:
550: IF c_sec_inv_info%isopen THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
544:
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
548: END IF;
549:
550: IF c_sec_inv_info%isopen THEN
551: close c_sec_inv_info;
701: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
702: --
703: IF l_debug_on IS NULL
704: THEN
705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
706: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
706: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
711: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
712: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
713: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
706: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
711: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
712: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
713: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
714: END IF;
707: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
711: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
712: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
713: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
714: END IF;
715: --
708: IF l_debug_on THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
711: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
712: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
713: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
714: END IF;
715: --
716: IF p_delivery_detail_id IS NULL THEN
709: WSH_DEBUG_SV.push(l_module_name);
710: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
711: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
712: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
713: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
714: END IF;
715: --
716: IF p_delivery_detail_id IS NULL THEN
717: --{
719: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
720: WSH_UTIL_CORE.Add_Message(x_return_status);
721: --
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.pop(l_module_name);
724: END IF;
725: --
726: return;
727: --}
749: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
750: WSH_UTIL_CORE.Add_Message(x_return_status);
751: --
752: IF l_debug_on THEN
753: WSH_DEBUG_SV.pop(l_module_name);
754: END IF;
755: --
756: return;
757: --}
800: -- This is a LPN record from WMS and a locator controlled -
801: IF l_subinv IS NULL -- fetch the subinv from wms_license_plate_numbers
802: THEN
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching subinventory name from wms_license_plate_numbers');
805: END IF;
806:
807: BEGIN
808: SELECT subinventory_code
812: AND organization_id= l_org_id;
813: EXCEPTION
814: WHEN No_Data_Found THEN
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.logmsg(l_module_name,'No_Data_Found while Fetching the subinventory name from wms_license_plate_numbers');
817: END IF;
818: END;
819: END IF;
820: IF l_subinv IS NOT NULL
822: -- wms subinventory always be locator controlled
823: -- and the locator can be either pre specified( loc control code 2) or dynamic ( loc control code 3)
824: -- so directly taking the location_control_code from mtl_secondary_inventories
825: IF l_debug_on THEN
826: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the location_control_code from sub inventory');
827: END IF;
828:
829: OPEN Get_location_control_code(l_subinv,l_org_id);
830: FETCH Get_location_control_code INTO l_location_control_code;
828:
829: OPEN Get_location_control_code(l_subinv,l_org_id);
830: FETCH Get_location_control_code INTO l_location_control_code;
831: IF l_debug_on THEN
832: WSH_DEBUG_SV.logmsg(l_module_name,'Returning back the location control code as :'||l_location_control_code);
833: END IF;
834: IF Get_location_control_code%NOTFOUND
835: THEN
836: CLOSE get_location_control_code;
834: IF Get_location_control_code%NOTFOUND
835: THEN
836: CLOSE get_location_control_code;
837: IF l_debug_on THEN
838: WSH_DEBUG_SV.logmsg(l_module_name,'No record found for LPN location control code Get_location_control_code ');
839: END IF;
840: END IF;
841:
842: IF Get_location_control_code%ISOPEN
849: --Bug#13949115 end
850:
851:
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Case where l_inv_item_id IS NULL or line is Container');
854: WSH_DEBUG_SV.pop(l_module_name);
855: END IF;
856: --
857: return;
850:
851:
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Case where l_inv_item_id IS NULL or line is Container');
854: WSH_DEBUG_SV.pop(l_module_name);
855: END IF;
856: --
857: return;
858: --}
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
909: WSH_UTIL_CORE.Add_Message(x_return_status);
910: --
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.pop(l_module_name);
913: END IF;
914: --
915: return;
916: --}
929: l_txn_type_id := 35;
930: end if;
931:
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_serial_number_pub.is_serial_controlled',WSH_DEBUG_SV.C_PROC_LEVEL);
934: END IF;
935: inv_serial_number_pub.is_serial_controlled (
936: p_inventory_item_id => l_inv_item_id,
937: p_organization_id => l_org_id,
943: p_xfer_serial_control => null,
944: x_serial_control => l_efc_serial_control,
945: x_return_status => l_efc_return_status);
946: IF l_debug_on THEN
947: wsh_debug_sv.logmsg(l_module_name, 'l_source_code '||l_source_code||' l_txn_type_id '||l_txn_type_id||' l_efc_return_status '||l_efc_return_status||' l_efc_serial_control '||l_efc_serial_control||' l_source_code '||l_source_code);
948: END IF;
949:
950: IF (l_efc_serial_control = 2 ) then
951: l_ser_flag := 'Y';
955: l_ser_flag := 'N';
956: END IF;
957: end if;
958: IF l_debug_on THEN
959: wsh_debug_sv.logmsg(l_module_name, 'l_ser_flag '||l_ser_flag);
960: END IF;
961: -- RTV changes
962:
963: -- bug 526487
992: IF (l_subinv IS NULL AND
993: NVL(l_txn_enabled_flag, 'N') = 'Y') THEN
994: --{
995: IF l_debug_on THEN
996: wsh_debug_sv.log(l_module_name, 'Txn Enabled Flag', l_txn_enabled_flag);
997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
998: END IF;
999: --
1000: WSH_DELIVERY_DETAILS_INV.Default_Subinventory (
993: NVL(l_txn_enabled_flag, 'N') = 'Y') THEN
994: --{
995: IF l_debug_on THEN
996: wsh_debug_sv.log(l_module_name, 'Txn Enabled Flag', l_txn_enabled_flag);
997: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
998: END IF;
999: --
1000: WSH_DELIVERY_DETAILS_INV.Default_Subinventory (
1001: l_org_id,
1009: --}
1010: END IF;
1011: --
1012: IF l_debug_on THEN
1013: wsh_debug_sv.log(l_module_name, 'Default Sub', l_dft_subinv);
1014: wsh_debug_sv.log(l_module_name, 'Input Default Sub', l_subinv);
1015: END IF;
1016: --
1017: IF (nvl(l_subinv, l_dft_subinv) IS NOT NULL) THEN
1010: END IF;
1011: --
1012: IF l_debug_on THEN
1013: wsh_debug_sv.log(l_module_name, 'Default Sub', l_dft_subinv);
1014: wsh_debug_sv.log(l_module_name, 'Input Default Sub', l_subinv);
1015: END IF;
1016: --
1017: IF (nvl(l_subinv, l_dft_subinv) IS NOT NULL) THEN
1018: --{
1016: --
1017: IF (nvl(l_subinv, l_dft_subinv) IS NOT NULL) THEN
1018: --{
1019: IF l_debug_on THEN
1020: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
1021: END IF;
1022: --
1023: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);
1024: --
1022: --
1023: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);
1024: --
1025: IF l_debug_on THEN
1026: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
1027: END IF;
1028: --
1029: l_sub_loc_code := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
1030: nvl(l_subinv,l_dft_subinv),
1031: l_org_id);
1032:
1033: --
1034: IF l_debug_on THEN
1035: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
1036: END IF;
1037: --
1038: l_loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
1039: l_org_id,
1062: x_inv_controls_rec.location_control_code := l_loc_ctl_code;
1063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1064: --
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOC_FLAG',x_inv_controls_rec.loc_flag);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1064: --
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOC_FLAG',x_inv_controls_rec.loc_flag);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1064: --
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOC_FLAG',x_inv_controls_rec.loc_flag);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOC_FLAG',x_inv_controls_rec.loc_flag);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1073: x_inv_controls_rec.transactable_flag);
1066: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOC_FLAG',x_inv_controls_rec.loc_flag);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1073: x_inv_controls_rec.transactable_flag);
1074: WSH_DEBUG_SV.pop(l_module_name);
1067: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SER_FLAG',x_inv_controls_rec.ser_flag);
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1073: x_inv_controls_rec.transactable_flag);
1074: WSH_DEBUG_SV.pop(l_module_name);
1075: END IF;
1068: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_LOC',x_inv_controls_rec.restrict_loc);
1069: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.RESTRICT_SUB',x_inv_controls_rec.restrict_sub);
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1073: x_inv_controls_rec.transactable_flag);
1074: WSH_DEBUG_SV.pop(l_module_name);
1075: END IF;
1076: --
1070: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.SERIAL_CODE',x_inv_controls_rec.serial_code);
1071: WSH_DEBUG_SV.log(l_module_name,'X_INV_CONTROLS_REC.LOCATION_CONTROL_CODE',x_inv_controls_rec.location_control_code);
1072: WSH_DEBUG_SV.log(l_module_name, 'X_INV_CONTROLS_REC.TRANSACTABLE_FLAG',
1073: x_inv_controls_rec.transactable_flag);
1074: WSH_DEBUG_SV.pop(l_module_name);
1075: END IF;
1076: --
1077: EXCEPTION
1078:
1091: --
1092: -- Debug Statements
1093: --
1094: IF l_debug_on THEN
1095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1097: END IF;
1098: --
1099: END Fetch_Inv_Controls;
1092: -- Debug Statements
1093: --
1094: IF l_debug_on THEN
1095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1097: END IF;
1098: --
1099: END Fetch_Inv_Controls;
1100:
1172: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1173: --
1174: IF l_debug_on IS NULL
1175: THEN
1176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1177: END IF;
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.push(l_module_name);
1176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1177: END IF;
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.push(l_module_name);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1177: END IF;
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.push(l_module_name);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.push(l_module_name);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.push(l_module_name);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1180: WSH_DEBUG_SV.push(l_module_name);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1181: WSH_DEBUG_SV.log(l_module_name,'P_SET_DEFAULT',P_SET_DEFAULT);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1182: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.DELIVERY_DETAIL_ID',P_LINE_INV_REC.delivery_detail_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1183: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.INVENTTORY_ITEM_ID',P_LINE_INV_REC.inventory_item_id);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1184: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SHP_QTY',P_LINE_INV_REC.shp_qty);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1185: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REQ_QTY',P_LINE_INV_REC.req_qty);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1186: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SER_QTY',P_LINE_INV_REC.ser_qty);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1194: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.ORGANIZATION_ID',P_LINE_INV_REC.organization_id);
1187: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.REVISION',P_LINE_INV_REC.revision);
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1194: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.ORGANIZATION_ID',P_LINE_INV_REC.organization_id);
1195: END IF;
1188: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SUBINVENTORY',P_LINE_INV_REC.subinventory);
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1194: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.ORGANIZATION_ID',P_LINE_INV_REC.organization_id);
1195: END IF;
1196: --
1189: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOT_NUMBER',P_LINE_INV_REC.lot_number);
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1194: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.ORGANIZATION_ID',P_LINE_INV_REC.organization_id);
1195: END IF;
1196: --
1197: --
1190: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_ID',P_LINE_INV_REC.locator_id);
1191: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.LOCATOR_CONTROL_CODE',P_LINE_INV_REC.locator_control_code);
1192: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.SERIAL_NUMBER_CONTROL_CODE',P_LINE_INV_REC.serial_number_control_code);
1193: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.TRANSACTION_TEMP_ID',P_LINE_INV_REC.transaction_temp_id);
1194: WSH_DEBUG_SV.log(l_module_name,'P_LINE_INV_REC.ORGANIZATION_ID',P_LINE_INV_REC.organization_id);
1195: END IF;
1196: --
1197: --
1198: -- Debug Statements
1197: --
1198: -- Debug Statements
1199: --
1200: IF l_debug_on THEN
1201: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
1202: END IF;
1203: --
1204: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls (
1205: p_line_inv_rec.delivery_detail_id,
1214: --
1215: -- Debug Statements
1216: --
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.pop(l_module_name);
1219: END IF;
1220: --
1221: return;
1222: END IF;
1237: --
1238: -- Debug Statements
1239: --
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.pop(l_module_name);
1242: END IF;
1243: --
1244: return;
1245: END IF;
1254: --
1255: -- Debug Statements
1256: --
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.pop(l_module_name);
1259: END IF;
1260: --
1261: return;
1262: END IF;
1267: --
1268: -- Debug Statements
1269: --
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;
1273: --
1274: RETURN;
1275: END IF;
1280: --
1281: -- Debug Statements
1282: --
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.pop(l_module_name);
1285: END IF;
1286: --
1287: RETURN;
1288: END IF;
1308: --
1309: -- Debug Statements
1310: --
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
1313: END IF;
1314: --
1315: WSH_DELIVERY_DETAILS_INV.Default_Subinventory (
1316: p_line_inv_rec.organization_id,
1323: --
1324: -- Debug Statements
1325: --
1326: IF l_debug_on THEN
1327: WSH_DEBUG_SV.pop(l_module_name);
1328: END IF;
1329: --
1330: RETURN;
1331: END IF;
1336: --
1337: -- Debug Statements
1338: --
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.pop(l_module_name);
1341: END IF;
1342: --
1343: RETURN;
1344: END IF;
1355: --
1356: -- Debug Statements
1357: --
1358: IF l_debug_on THEN
1359: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
1360: END IF;
1361: --
1362: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (p_line_inv_rec.organization_id);
1363:
1364: --
1365: -- Debug Statements
1366: --
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
1369: END IF;
1370: --
1371: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
1372: nvl(subinv,dft_subinv),
1378: --
1379: -- Debug Statements
1380: --
1381: IF l_debug_on THEN
1382: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
1383: END IF;
1384: --
1385: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
1386: p_line_inv_rec.organization_id,
1399: --
1400: -- Debug Statements
1401: --
1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
1404: END IF;
1405: --
1406: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
1407: p_line_inv_rec.organization_id,
1415: --
1416: -- Debug Statements
1417: --
1418: IF l_debug_on THEN
1419: WSH_DEBUG_SV.pop(l_module_name);
1420: END IF;
1421: --
1422: RETURN;
1423: END IF;
1438: --
1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_SERIAL_QTY',WSH_DEBUG_SV.C_PROC_LEVEL);
1443: END IF;
1444: --
1445: l_ser_qty := WSH_DELIVERY_DETAILS_INV.Get_Serial_Qty (
1446: p_line_inv_rec.organization_id,
1452: --
1453: -- Debug Statements
1454: --
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.pop(l_module_name);
1457: END IF;
1458: --
1459: return;
1460: END IF;
1472: --
1473: -- Debug Statements
1474: --
1475: IF l_debug_on THEN
1476: WSH_DEBUG_SV.pop(l_module_name);
1477: END IF;
1478: --
1479: RETURN;
1480: END IF;
1486: --
1487: -- Debug Statements
1488: --
1489: IF l_debug_on THEN
1490: WSH_DEBUG_SV.pop(l_module_name);
1491: END IF;
1492: --
1493: EXCEPTION
1494:
1500: --
1501: -- Debug Statements
1502: --
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1506: END IF;
1507: --
1508: END details_required;
1501: -- Debug Statements
1502: --
1503: IF l_debug_on THEN
1504: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1506: END IF;
1507: --
1508: END details_required;
1509:
1542: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1543: --
1544: IF l_debug_on IS NULL
1545: THEN
1546: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1547: END IF;
1548: --
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.push(l_module_name);
1546: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1547: END IF;
1548: --
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.push(l_module_name);
1551: --
1552: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1553: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1554: END IF;
1548: --
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.push(l_module_name);
1551: --
1552: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1553: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1554: END IF;
1555: --
1556:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.push(l_module_name);
1551: --
1552: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1553: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1554: END IF;
1555: --
1556:
1557: -- bug 5264874
1566:
1567: l_sub_loc_ctl := l_mtl_sec_inv_rec.locator_type;
1568:
1569: IF l_debug_on THEN
1570: WSH_DEBUG_SV.pop(l_module_name);
1571: END IF;
1572: --
1573: RETURN l_sub_loc_ctl;
1574: EXCEPTION
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.Add_Message(l_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1581: END IF;
1582: END Sub_Loc_Ctl;
1583:
1576: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1577: WSH_UTIL_CORE.Add_Message(l_return_status);
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1581: END IF;
1582: END Sub_Loc_Ctl;
1583:
1584:
1613: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1614: --
1615: IF l_debug_on IS NULL
1616: THEN
1617: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1618: END IF;
1619: --
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.push(l_module_name);
1617: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1618: END IF;
1619: --
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.push(l_module_name);
1622: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1623: END IF;
1624: --
1625:
1618: END IF;
1619: --
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.push(l_module_name);
1622: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1623: END IF;
1624: --
1625:
1626: -- bug 5264874
1636:
1637: l_org_loc_ctl := l_mtl_org_param_rec.stock_locator_control_code;
1638:
1639: IF l_debug_on THEN
1640: WSH_DEBUG_SV.log(l_module_name, 'l_org_loc_ctl',l_org_loc_ctl);
1641: WSH_DEBUG_SV.pop(l_module_name);
1642: END IF;
1643: --
1644: RETURN l_org_loc_ctl;
1637: l_org_loc_ctl := l_mtl_org_param_rec.stock_locator_control_code;
1638:
1639: IF l_debug_on THEN
1640: WSH_DEBUG_SV.log(l_module_name, 'l_org_loc_ctl',l_org_loc_ctl);
1641: WSH_DEBUG_SV.pop(l_module_name);
1642: END IF;
1643: --
1644: RETURN l_org_loc_ctl;
1645:
1647: WHEN FND_API.G_EXC_ERROR THEN
1648: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: WSH_UTIL_CORE.Add_Message(l_return_status);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1653: END IF;
1654:
1655: END Get_Org_Loc;
1648: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1649: WSH_UTIL_CORE.Add_Message(l_return_status);
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1653: END IF;
1654:
1655: END Get_Org_Loc;
1656:
1701: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1702: --
1703: IF l_debug_on IS NULL
1704: THEN
1705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1706: END IF;
1707: --
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.push(l_module_name);
1705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1706: END IF;
1707: --
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.push(l_module_name);
1710: --
1711: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1712: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1713: END IF;
1707: --
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.push(l_module_name);
1710: --
1711: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1712: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1713: END IF;
1714: --
1715: OPEN Default_Sub;
1708: IF l_debug_on THEN
1709: WSH_DEBUG_SV.push(l_module_name);
1710: --
1711: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1712: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1713: END IF;
1714: --
1715: OPEN Default_Sub;
1716: FETCH Default_Sub into l_dflt_sub;
1722: --
1723: -- Debug Statements
1724: --
1725: IF l_debug_on THEN
1726: WSH_DEBUG_SV.pop(l_module_name);
1727: END IF;
1728: --
1729: return;
1730: END IF;
1739: --
1740: -- Debug Statements
1741: --
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.pop(l_module_name);
1744: END IF;
1745: --
1746: EXCEPTION
1747:
1752: --
1753: -- Debug Statements
1754: --
1755: IF l_debug_on THEN
1756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1758: END IF;
1759: --
1760: END Default_Subinventory;
1753: -- Debug Statements
1754: --
1755: IF l_debug_on THEN
1756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1758: END IF;
1759: --
1760: END Default_Subinventory;
1761:
1814: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1815: --
1816: IF l_debug_on IS NULL
1817: THEN
1818: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1819: END IF;
1820: --
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.push(l_module_name);
1818: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1819: END IF;
1820: --
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.push(l_module_name);
1823: --
1824: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1825: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1826: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1820: --
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.push(l_module_name);
1823: --
1824: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1825: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1826: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1827: WSH_DEBUG_SV.log(l_module_name,'P_LOC_RESTRICTED_FLAG',P_LOC_RESTRICTED_FLAG);
1828: END IF;
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.push(l_module_name);
1823: --
1824: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1825: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1826: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1827: WSH_DEBUG_SV.log(l_module_name,'P_LOC_RESTRICTED_FLAG',P_LOC_RESTRICTED_FLAG);
1828: END IF;
1829: --
1822: WSH_DEBUG_SV.push(l_module_name);
1823: --
1824: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1825: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1826: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1827: WSH_DEBUG_SV.log(l_module_name,'P_LOC_RESTRICTED_FLAG',P_LOC_RESTRICTED_FLAG);
1828: END IF;
1829: --
1830: OPEN Default_Locator;
1823: --
1824: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
1825: WSH_DEBUG_SV.log(l_module_name,'P_INV_ITEM_ID',P_INV_ITEM_ID);
1826: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
1827: WSH_DEBUG_SV.log(l_module_name,'P_LOC_RESTRICTED_FLAG',P_LOC_RESTRICTED_FLAG);
1828: END IF;
1829: --
1830: OPEN Default_Locator;
1831: FETCH Default_Locator INTO dflt_locator_id;
1835: --
1836: -- Debug Statements
1837: --
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.pop(l_module_name);
1840: END IF;
1841: --
1842: RETURN NULL;
1843: END IF;
1849: --
1850: -- Debug Statements
1851: --
1852: IF l_debug_on THEN
1853: WSH_DEBUG_SV.pop(l_module_name);
1854: END IF;
1855: --
1856: RETURN (dflt_locator_id);
1857:
1903: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1904: --
1905: IF l_debug_on IS NULL
1906: THEN
1907: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1908: END IF;
1909: --
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.push(l_module_name);
1907: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1908: END IF;
1909: --
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.push(l_module_name);
1912: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1909: --
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.push(l_module_name);
1912: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'P_SUB_LOC_CODE',P_SUB_LOC_CODE);
1917: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_LOC_CODE',P_ITEM_LOC_CODE);
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.push(l_module_name);
1912: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'P_SUB_LOC_CODE',P_SUB_LOC_CODE);
1917: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_LOC_CODE',P_ITEM_LOC_CODE);
1918: END IF;
1911: WSH_DEBUG_SV.push(l_module_name);
1912: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'P_SUB_LOC_CODE',P_SUB_LOC_CODE);
1917: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_LOC_CODE',P_ITEM_LOC_CODE);
1918: END IF;
1919: --
1912: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'P_SUB_LOC_CODE',P_SUB_LOC_CODE);
1917: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_LOC_CODE',P_ITEM_LOC_CODE);
1918: END IF;
1919: --
1920: --
1913: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1914: WSH_DEBUG_SV.log(l_module_name,'P_RESTRICT_LOC',P_RESTRICT_LOC);
1915: WSH_DEBUG_SV.log(l_module_name,'P_ORG_LOC_CODE',P_ORG_LOC_CODE);
1916: WSH_DEBUG_SV.log(l_module_name,'P_SUB_LOC_CODE',P_SUB_LOC_CODE);
1917: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_LOC_CODE',P_ITEM_LOC_CODE);
1918: END IF;
1919: --
1920: --
1921: -- Debug Statements
1940: --
1941: -- Debug Statements
1942: --
1943: IF l_debug_on THEN
1944: WSH_DEBUG_SV.pop(l_module_name);
1945: END IF;
1946: --
1947: RETURN p_org_loc_code;
1948: ELSE
1953: --
1954: -- Debug Statements
1955: --
1956: IF l_debug_on THEN
1957: WSH_DEBUG_SV.pop(l_module_name);
1958: END IF;
1959: --
1960: RETURN prespecified;
1961: ELSIF (l_neg_inv_code = 1) THEN
1962: --
1963: -- Debug Statements
1964: --
1965: IF l_debug_on THEN
1966: WSH_DEBUG_SV.pop(l_module_name);
1967: END IF;
1968: --
1969: RETURN dynamic;
1970: ELSE
1973: --
1974: -- Debug Statements
1975: --
1976: IF l_debug_on THEN
1977: WSH_DEBUG_SV.pop(l_module_name);
1978: END IF;
1979: --
1980: RETURN prespecified;
1981: END IF;
1987: --
1988: -- Debug Statements
1989: --
1990: IF l_debug_on THEN
1991: WSH_DEBUG_SV.pop(l_module_name);
1992: END IF;
1993: --
1994: RETURN p_sub_loc_code;
1995: ELSE
1999: --
2000: -- Debug Statements
2001: --
2002: IF l_debug_on THEN
2003: WSH_DEBUG_SV.pop(l_module_name);
2004: END IF;
2005: --
2006: RETURN prespecified;
2007: ELSIF (l_neg_inv_code = 1) THEN
2008: --
2009: -- Debug Statements
2010: --
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.pop(l_module_name);
2013: END IF;
2014: --
2015: RETURN dynamic;
2016: ELSE
2019: --
2020: -- Debug Statements
2021: --
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.pop(l_module_name);
2024: END IF;
2025: --
2026: RETURN prespecified;
2027: END IF;
2033: --
2034: -- Debug Statements
2035: --
2036: IF l_debug_on THEN
2037: WSH_DEBUG_SV.pop(l_module_name);
2038: END IF;
2039: --
2040: RETURN p_item_loc_code;
2041: ELSE
2045: --
2046: -- Debug Statements
2047: --
2048: IF l_debug_on THEN
2049: WSH_DEBUG_SV.pop(l_module_name);
2050: END IF;
2051: --
2052: RETURN prespecified;
2053: ELSIF (l_neg_inv_code = 1) THEN
2054: --
2055: -- Debug Statements
2056: --
2057: IF l_debug_on THEN
2058: WSH_DEBUG_SV.pop(l_module_name);
2059: END IF;
2060: --
2061: RETURN dynamic;
2062: ELSE
2065: --
2066: -- Debug Statements
2067: --
2068: IF l_debug_on THEN
2069: WSH_DEBUG_SV.pop(l_module_name);
2070: END IF;
2071: --
2072: RETURN prespecified;
2073: END IF;
2079: WHEN FND_API.G_EXC_ERROR THEN
2080: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2081: WSH_UTIL_CORE.Add_Message(l_return_status);
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2085: END IF;
2086:
2087: WHEN others THEN
2080: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2081: WSH_UTIL_CORE.Add_Message(l_return_status);
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2085: END IF;
2086:
2087: WHEN others THEN
2088: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code');
2090: --
2091: -- Debug Statements
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2096: END IF;
2097: --
2098: END Locator_Ctl_Code;
2091: -- Debug Statements
2092: --
2093: IF l_debug_on THEN
2094: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2096: END IF;
2097: --
2098: END Locator_Ctl_Code;
2099:
2172: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2173: --
2174: IF l_debug_on IS NULL
2175: THEN
2176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2177: END IF;
2178: --
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.push(l_module_name);
2176: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2177: END IF;
2178: --
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.push(l_module_name);
2181: --
2182: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2183: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2184: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2178: --
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.push(l_module_name);
2181: --
2182: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2183: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2184: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2185: END IF;
2186: --
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.push(l_module_name);
2181: --
2182: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2183: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2184: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2185: END IF;
2186: --
2187: OPEN Fetch_Detail_Info;
2180: WSH_DEBUG_SV.push(l_module_name);
2181: --
2182: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2183: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2184: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2185: END IF;
2186: --
2187: OPEN Fetch_Detail_Info;
2188:
2196: --
2197: -- Debug Statements
2198: --
2199: IF l_debug_on THEN
2200: WSH_DEBUG_SV.pop(l_module_name);
2201: END IF;
2202: --
2203: return;
2204: END IF;
2214: --
2215: -- Debug Statements
2216: --
2217: IF l_debug_on THEN
2218: WSH_DEBUG_SV.pop(l_module_name);
2219: END IF;
2220: --
2221: return;
2222: END IF;
2231: CLOSE c_temp_id;
2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2233: --
2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.log(l_module_name,'Return Status is error',x_return_status);
2236: WSH_DEBUG_SV.pop(l_module_name);
2237: END IF;
2238: --
2239: return;
2232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2233: --
2234: IF l_debug_on THEN
2235: WSH_DEBUG_SV.log(l_module_name,'Return Status is error',x_return_status);
2236: WSH_DEBUG_SV.pop(l_module_name);
2237: END IF;
2238: --
2239: return;
2240: --}
2246: --
2247: -- Debug Statements
2248: --
2249: IF l_debug_on THEN
2250: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',l_transaction_temp_id);
2251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2252: END IF;
2253: --
2254: -- bug 5028993
2247: -- Debug Statements
2248: --
2249: IF l_debug_on THEN
2250: WSH_DEBUG_SV.log(l_module_name,'transaction_temp_id',l_transaction_temp_id);
2251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2252: END IF;
2253: --
2254: -- bug 5028993
2255: -- if serial_number is not null, while calling mark_serial,
2286: --
2287: -- Debug Statements
2288: --
2289: IF l_debug_on THEN
2290: WSH_DEBUG_SV.pop(l_module_name);
2291: END IF;
2292: --
2293: return;
2294: END IF;
2297: --
2298: -- Debug Statements
2299: --
2300: IF l_debug_on THEN
2301: WSH_DEBUG_SV.pop(l_module_name);
2302: END IF;
2303: --
2304: return;
2305:
2313: --
2314: -- Debug Statements
2315: --
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_MARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2318: END IF;
2319: --
2320: -- Fix for bug 2762219.
2321: -- if transaction_Temp_id is not null, while calling mark_serial,
2358: --
2359: -- Debug Statements
2360: --
2361: IF l_debug_on THEN
2362: WSH_DEBUG_SV.pop(l_module_name);
2363: END IF;
2364: --
2365: return;
2366: END IF;
2374: --
2375: -- Debug Statements
2376: --
2377: IF l_debug_on THEN
2378: WSH_DEBUG_SV.pop(l_module_name);
2379: END IF;
2380: --
2381: EXCEPTION
2382:
2387: --
2388: -- Debug Statements
2389: --
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2393: END IF;
2394: --
2395: END Mark_Serial_Number;
2388: -- Debug Statements
2389: --
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2393: END IF;
2394: --
2395: END Mark_Serial_Number;
2396:
2460: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2461: --
2462: IF l_debug_on IS NULL
2463: THEN
2464: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2465: END IF;
2466: --
2467: IF l_debug_on THEN
2468: WSH_DEBUG_SV.push(l_module_name);
2464: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2465: END IF;
2466: --
2467: IF l_debug_on THEN
2468: WSH_DEBUG_SV.push(l_module_name);
2469: --
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2466: --
2467: IF l_debug_on THEN
2468: WSH_DEBUG_SV.push(l_module_name);
2469: --
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2473: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2474: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2467: IF l_debug_on THEN
2468: WSH_DEBUG_SV.push(l_module_name);
2469: --
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2473: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2474: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2475: END IF;
2468: WSH_DEBUG_SV.push(l_module_name);
2469: --
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2473: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2474: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2475: END IF;
2476: IF p_serial_number_code IS NULL THEN
2469: --
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2473: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2474: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2475: END IF;
2476: IF p_serial_number_code IS NULL THEN
2477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SER_CODE_UNMARK');
2470: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
2471: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER_CODE',P_SERIAL_NUMBER_CODE);
2472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
2473: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',P_TRANSACTION_TEMP_ID);
2474: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2475: END IF;
2476: IF p_serial_number_code IS NULL THEN
2477: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SER_CODE_UNMARK');
2478: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2480: --
2481: -- Debug Statements
2482: --
2483: IF l_debug_on THEN
2484: WSH_DEBUG_SV.pop(l_module_name);
2485: END IF;
2486: --
2487: return;
2488: END IF;
2498: ELSE
2499: l_txn_type_id := 35; -- 35 for OSP
2500: END IF;
2501: IF l_debug_on THEN
2502: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit inv_serial_number_pub.is_serial_controlled',WSH_DEBUG_SV.C_PROC_LEVEL);
2503: END IF;
2504:
2505: inv_serial_number_pub.is_serial_controlled (
2506: p_inventory_item_id => l_inventory_item_id,
2514: x_serial_control => l_efc_serial_control,
2515: x_return_status => l_efc_return_status);
2516:
2517: IF l_debug_on THEN
2518: wsh_debug_sv.log(l_module_name, 'Calling program unit inv_serial_number_pub.is_serial_controlled. l_efc_return_status ', l_efc_return_status);
2519: wsh_debug_sv.log(l_module_name, 'l_efc_serial_control value : ', l_efc_serial_control);
2520: END IF;
2521: END IF; --}
2522: --RTV changes
2515: x_return_status => l_efc_return_status);
2516:
2517: IF l_debug_on THEN
2518: wsh_debug_sv.log(l_module_name, 'Calling program unit inv_serial_number_pub.is_serial_controlled. l_efc_return_status ', l_efc_return_status);
2519: wsh_debug_sv.log(l_module_name, 'l_efc_serial_control value : ', l_efc_serial_control);
2520: END IF;
2521: END IF; --}
2522: --RTV changes
2523: --
2528: --
2529: -- Debug Statements
2530: --
2531: IF l_debug_on THEN
2532: WSH_DEBUG_SV.pop(l_module_name);
2533: END IF;
2534: --
2535: return;
2536: END IF;
2542: --
2543: -- Debug Statements
2544: --
2545: IF l_debug_on THEN
2546: WSH_DEBUG_SV.pop(l_module_name);
2547: END IF;
2548: --
2549: return;
2550: END IF;
2555: --
2556: -- Debug Statements
2557: --
2558: IF l_debug_on THEN
2559: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2560: END IF;
2561: --
2562: Serial_Check.Inv_Unmark_Serial(
2563: p_serial_number,
2581: --
2582: -- Debug Statements
2583: --
2584: IF l_debug_on THEN
2585: WSH_DEBUG_SV.pop(l_module_name);
2586: END IF;
2587: --
2588: return;
2589:
2605: --
2606: -- Debug Statements
2607: --
2608: IF l_debug_on THEN
2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UNMARK_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: Serial_Check.Inv_Unmark_Serial(
2613: c.fm_Serial_number ,
2630: --
2631: -- Debug Statements
2632: --
2633: IF l_debug_on THEN
2634: WSH_DEBUG_SV.pop(l_module_name);
2635: END IF;
2636: --
2637: return;
2638: END IF;
2650: --
2651: -- Debug Statements
2652: --
2653: IF l_debug_on THEN
2654: WSH_DEBUG_SV.pop(l_module_name);
2655: END IF;
2656: --
2657: return;
2658:
2663: --
2664: -- Debug Statements
2665: --
2666: IF l_debug_on THEN
2667: WSH_DEBUG_SV.pop(l_module_name);
2668: END IF;
2669: --
2670: EXCEPTION
2671:
2681: --
2682: -- Debug Statements
2683: --
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2687: END IF;
2688: --
2689: END Unmark_Serial_Number;
2682: -- Debug Statements
2683: --
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2687: END IF;
2688: --
2689: END Unmark_Serial_Number;
2690:
2733: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2734: --
2735: IF l_debug_on IS NULL
2736: THEN
2737: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2738: END IF;
2739: --
2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.push(l_module_name);
2737: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2738: END IF;
2739: --
2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.push(l_module_name);
2742: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2739: --
2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.push(l_module_name);
2742: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2740: IF l_debug_on THEN
2741: WSH_DEBUG_SV.push(l_module_name);
2742: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2748: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
2741: WSH_DEBUG_SV.push(l_module_name);
2742: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2748: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
2749: END IF;
2742: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2748: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
2749: END IF;
2750: --
2743: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2748: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
2749: END IF;
2750: --
2751: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2744: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2745: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2746: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
2747: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
2748: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
2749: END IF;
2750: --
2751: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2752:
2754: --
2755: -- Debug Statements
2756: --
2757: IF l_debug_on THEN
2758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
2759: END IF;
2760: --
2761: l_result := INV_VALIDATE.organization(g_org);
2762: IF (l_result <> INV_VALIDATE.T) THEN
2769: --
2770: -- Debug Statements
2771: --
2772: IF l_debug_on THEN
2773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
2774: END IF;
2775: --
2776: l_result := wsh_delivery_details_inv.inventory_item(
2777: p_item => g_item,
2787: --
2788: -- Debug Statements
2789: --
2790: IF l_debug_on THEN
2791: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.FROM_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2792: END IF;
2793: --
2794: l_result := INV_VALIDATE.From_subinventory(
2795: p_sub => g_sub,
2809: --
2810: -- Debug Statements
2811: --
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATELOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
2814: END IF;
2815: --
2816: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
2817: l_result := INV_VALIDATE.ValidateLocator(
2837: --
2838: -- Debug Statements
2839: --
2840: IF l_debug_on THEN
2841: WSH_DEBUG_SV.pop(l_module_name);
2842: END IF;
2843: --
2844: EXCEPTION
2845:
2850: --
2851: -- Debug Statements
2852: --
2853: IF l_debug_on THEN
2854: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2856: END IF;
2857: --
2858: END Validate_Locator;
2851: -- Debug Statements
2852: --
2853: IF l_debug_on THEN
2854: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2855: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2856: END IF;
2857: --
2858: END Validate_Locator;
2859:
2895: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2896: --
2897: IF l_debug_on IS NULL
2898: THEN
2899: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2900: END IF;
2901: --
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.push(l_module_name);
2899: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2900: END IF;
2901: --
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.push(l_module_name);
2904: --
2905: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
2906: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2907: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2901: --
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.push(l_module_name);
2904: --
2905: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
2906: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2907: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2908: END IF;
2909: --
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.push(l_module_name);
2904: --
2905: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
2906: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2907: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2908: END IF;
2909: --
2910: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2903: WSH_DEBUG_SV.push(l_module_name);
2904: --
2905: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
2906: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2907: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2908: END IF;
2909: --
2910: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2911: g_org.organization_id := p_organization_id;
2912: --
2913: -- Debug Statements
2914: --
2915: IF l_debug_on THEN
2916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
2917: END IF;
2918: --
2919: l_result := INV_VALIDATE.organization(g_org);
2920: IF (l_result <> INV_VALIDATE.T) THEN
2927: --
2928: -- Debug Statements
2929: --
2930: IF l_debug_on THEN
2931: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
2932: END IF;
2933: --
2934: l_result := wsh_delivery_details_inv.inventory_item(
2935: p_item => g_item,
2944: --
2945: -- Debug Statements
2946: --
2947: IF l_debug_on THEN
2948: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.REVISION',WSH_DEBUG_SV.C_PROC_LEVEL);
2949: END IF;
2950: --
2951: l_result := INV_VALIDATE.Revision(
2952: p_revision => p_revision,
2963: --
2964: -- Debug Statements
2965: --
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.pop(l_module_name);
2968: END IF;
2969: --
2970: EXCEPTION
2971: WHEN others THEN
2975: --
2976: -- Debug Statements
2977: --
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2981: END IF;
2982: --
2983: END Validate_Revision;
2976: -- Debug Statements
2977: --
2978: IF l_debug_on THEN
2979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2981: END IF;
2982: --
2983: END Validate_Revision;
2984:
3030: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3031: --
3032: IF l_debug_on IS NULL
3033: THEN
3034: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3035: END IF;
3036: --
3037: IF l_debug_on THEN
3038: WSH_DEBUG_SV.push(l_module_name);
3034: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3035: END IF;
3036: --
3037: IF l_debug_on THEN
3038: WSH_DEBUG_SV.push(l_module_name);
3039: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3036: --
3037: IF l_debug_on THEN
3038: WSH_DEBUG_SV.push(l_module_name);
3039: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3037: IF l_debug_on THEN
3038: WSH_DEBUG_SV.push(l_module_name);
3039: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3045: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3038: WSH_DEBUG_SV.push(l_module_name);
3039: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3045: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3046: END IF;
3039: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3045: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3046: END IF;
3047: --
3040: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3045: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3046: END IF;
3047: --
3048: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3041: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3042: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3043: WSH_DEBUG_SV.log(l_module_name,'P_TO_SUBINVENTORY',P_TO_SUBINVENTORY);
3044: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3045: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3046: END IF;
3047: --
3048: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3049: g_org.organization_id := p_organization_id;
3050: --
3051: -- Debug Statements
3052: --
3053: IF l_debug_on THEN
3054: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3055: END IF;
3056: --
3057: l_result := INV_VALIDATE.organization(g_org);
3058: IF (l_result <> INV_VALIDATE.T) THEN
3065: --
3066: -- Debug Statements
3067: --
3068: IF l_debug_on THEN
3069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
3070: END IF;
3071: --
3072: l_result := wsh_delivery_details_inv.inventory_item(
3073: p_item => g_item,
3085: --
3086: -- Debug Statements
3087: --
3088: IF l_debug_on THEN
3089: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.FROM_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
3090: END IF;
3091: --
3092: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3093: l_result := INV_VALIDATE.from_subinventory(
3117: --
3118: -- Debug Statements
3119: --
3120: IF l_debug_on THEN
3121: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.TO_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
3122: END IF;
3123: --
3124: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3125: l_result := INV_VALIDATE.to_subinventory(
3152: --
3153: -- Debug Statements
3154: --
3155: IF l_debug_on THEN
3156: WSH_DEBUG_SV.pop(l_module_name);
3157: END IF;
3158: --
3159: EXCEPTION
3160:
3165: --
3166: -- Debug Statements
3167: --
3168: IF l_debug_on THEN
3169: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3170: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3171: END IF;
3172: --
3173: END Validate_Subinventory;
3166: -- Debug Statements
3167: --
3168: IF l_debug_on THEN
3169: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3170: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3171: END IF;
3172: --
3173: END Validate_Subinventory;
3174:
3221: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3222: --
3223: IF l_debug_on IS NULL
3224: THEN
3225: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3226: END IF;
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);
3225: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3226: END IF;
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3231: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3239: WSH_DEBUG_SV.log(l_module_name,'p_lpn_id',p_lpn_id);
3232: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3239: WSH_DEBUG_SV.log(l_module_name,'p_lpn_id',p_lpn_id);
3240: END IF;
3233: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3239: WSH_DEBUG_SV.log(l_module_name,'p_lpn_id',p_lpn_id);
3240: END IF;
3241: --
3234: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3239: WSH_DEBUG_SV.log(l_module_name,'p_lpn_id',p_lpn_id);
3240: END IF;
3241: --
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3235: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3236: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3237: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3238: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3239: WSH_DEBUG_SV.log(l_module_name,'p_lpn_id',p_lpn_id);
3240: END IF;
3241: --
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3243: g_org.organization_id := p_organization_id;
3249: --
3250: -- Debug Statements
3251: --
3252: IF l_debug_on THEN
3253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3254: END IF;
3255: --
3256: l_result := INV_VALIDATE.organization(g_org);
3257: IF (l_result <> INV_VALIDATE.T) THEN
3265: --
3266: -- Debug Statements
3267: --
3268: IF l_debug_on THEN
3269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
3270: END IF;
3271: --
3272: l_result := wsh_delivery_details_inv.inventory_item(
3273: p_item => g_item,
3283: --
3284: -- Debug Statements
3285: --
3286: IF l_debug_on THEN
3287: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.FROM_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
3288: END IF;
3289: --
3290: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3291: l_result := INV_VALIDATE.From_Subinventory(
3310: --
3311: -- Debug Statements
3312: --
3313: IF l_debug_on THEN
3314: WSH_DEBUG_SV.pop(l_module_name);
3315: END IF;
3316: --
3317: RETURN;
3318: END IF;
3322: --
3323: -- Debug Statements
3324: --
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATELOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
3327: END IF;
3328: --
3329: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3330: l_result := INV_VALIDATE.validateLocator(
3349: --
3350: -- Debug Statements
3351: --
3352: IF l_debug_on THEN
3353: WSH_DEBUG_SV.pop(l_module_name);
3354: END IF;
3355: --
3356: RETURN;
3357: END IF;
3360: --
3361: -- Debug Statements
3362: --
3363: IF l_debug_on THEN
3364: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.LOT_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
3365: END IF;
3366: --
3367: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3368: l_result := INV_VALIDATE.lot_number(
3395: --
3396: -- Debug Statements
3397: --
3398: IF l_debug_on THEN
3399: WSH_DEBUG_SV.pop(l_module_name);
3400: END IF;
3401: --
3402: EXCEPTION
3403: WHEN others THEN
3407: --
3408: -- Debug Statements
3409: --
3410: IF l_debug_on THEN
3411: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3412: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3413: END IF;
3414: --
3415: END Validate_lot_number;
3408: -- Debug Statements
3409: --
3410: IF l_debug_on THEN
3411: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3412: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3413: END IF;
3414: --
3415: END Validate_lot_number;
3416:
3462: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3463: --
3464: IF l_debug_on IS NULL
3465: THEN
3466: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3467: END IF;
3468: --
3469: IF l_debug_on THEN
3470: WSH_DEBUG_SV.push(l_module_name);
3466: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3467: END IF;
3468: --
3469: IF l_debug_on THEN
3470: WSH_DEBUG_SV.push(l_module_name);
3471: --
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3468: --
3469: IF l_debug_on THEN
3470: WSH_DEBUG_SV.push(l_module_name);
3471: --
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3469: IF l_debug_on THEN
3470: WSH_DEBUG_SV.push(l_module_name);
3471: --
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3470: WSH_DEBUG_SV.push(l_module_name);
3471: --
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3471: --
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3472: WSH_DEBUG_SV.log(l_module_name,'P_SERIAL_NUMBER',P_SERIAL_NUMBER);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3480: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3473: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3480: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3481: END IF;
3474: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3480: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3481: END IF;
3482: --
3475: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3480: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3481: END IF;
3482: --
3483: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3476: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3477: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3478: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3479: WSH_DEBUG_SV.log(l_module_name,'p_transaction_type_id',p_transaction_type_id);
3480: WSH_DEBUG_SV.log(l_module_name,'p_object_type',p_object_type);
3481: END IF;
3482: --
3483: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3484: g_org.organization_id := p_organization_id;
3485: --
3486: -- Debug Statements
3487: --
3488: IF l_debug_on THEN
3489: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
3490: END IF;
3491: --
3492: l_result := INV_VALIDATE.organization(g_org);
3493: IF (l_result <> INV_VALIDATE.T) THEN
3498: --
3499: -- Debug Statements
3500: --
3501: IF l_debug_on THEN
3502: WSH_DEBUG_SV.pop(l_module_name);
3503: END IF;
3504: --
3505: RETURN;
3506: END IF;
3508: --
3509: -- Debug Statements
3510: --
3511: IF l_debug_on THEN
3512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
3513: END IF;
3514: --
3515: l_result := wsh_delivery_details_inv.inventory_item(
3516: p_item => g_item,
3523: --
3524: -- Debug Statements
3525: --
3526: IF l_debug_on THEN
3527: WSH_DEBUG_SV.pop(l_module_name);
3528: END IF;
3529: --
3530: RETURN;
3531: END IF;
3534: --
3535: -- Debug Statements
3536: --
3537: IF l_debug_on THEN
3538: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.FROM_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
3539: END IF;
3540: --
3541: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3542: l_result := INV_VALIDATE.From_Subinventory(
3561: --
3562: -- Debug Statements
3563: --
3564: IF l_debug_on THEN
3565: WSH_DEBUG_SV.pop(l_module_name);
3566: END IF;
3567: --
3568: RETURN;
3569: END IF;
3575: --
3576: -- Debug Statements
3577: --
3578: IF l_debug_on THEN
3579: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATELOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
3580: END IF;
3581: --
3582: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3583: l_result := INV_VALIDATE.validateLocator(
3602: --
3603: -- Debug Statements
3604: --
3605: IF l_debug_on THEN
3606: WSH_DEBUG_SV.pop(l_module_name);
3607: END IF;
3608: --
3609: RETURN;
3610: END IF;
3615: --
3616: -- Debug Statements
3617: --
3618: IF l_debug_on THEN
3619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.LOT_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
3620: END IF;
3621: --
3622: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3623: l_result := INV_VALIDATE.Lot_Number(
3646: --
3647: -- Debug Statements
3648: --
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.pop(l_module_name);
3651: END IF;
3652: --
3653: RETURN;
3654: END IF;
3658: --
3659: -- Debug Statements
3660: --
3661: IF l_debug_on THEN
3662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
3663: END IF;
3664: --
3665: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
3666: l_result := INV_VALIDATE.Validate_serial(
3693: --
3694: -- Debug Statements
3695: --
3696: IF l_debug_on THEN
3697: WSH_DEBUG_SV.pop(l_module_name);
3698: END IF;
3699: --
3700: EXCEPTION
3701:
3706: --
3707: -- Debug Statements
3708: --
3709: IF l_debug_on THEN
3710: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3712: END IF;
3713: --
3714: END Validate_Serial;
3707: -- Debug Statements
3708: --
3709: IF l_debug_on THEN
3710: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3712: END IF;
3713: --
3714: END Validate_Serial;
3715:
3764: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3765: --
3766: IF l_debug_on IS NULL
3767: THEN
3768: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3769: END IF;
3770: --
3771: IF l_debug_on THEN
3772: WSH_DEBUG_SV.push(l_module_name);
3768: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3769: END IF;
3770: --
3771: IF l_debug_on THEN
3772: WSH_DEBUG_SV.push(l_module_name);
3773: --
3774: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3775: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3776: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3770: --
3771: IF l_debug_on THEN
3772: WSH_DEBUG_SV.push(l_module_name);
3773: --
3774: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3775: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3776: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3777: END IF;
3778: --
3771: IF l_debug_on THEN
3772: WSH_DEBUG_SV.push(l_module_name);
3773: --
3774: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3775: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3776: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3777: END IF;
3778: --
3779: OPEN Check_Dup_Loc;
3772: WSH_DEBUG_SV.push(l_module_name);
3773: --
3774: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3775: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3776: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
3777: END IF;
3778: --
3779: OPEN Check_Dup_Loc;
3780: FETCH Check_Dup_Loc INTO l_temp;
3790: --
3791: -- Debug Statements
3792: --
3793: IF l_debug_on THEN
3794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ORG_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3795: END IF;
3796: --
3797: l_temp := WSH_UTIL_CORE.Get_Org_Name(p_organization_id);
3798: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_temp);
3802: --
3803: -- Debug Statements
3804: --
3805: IF l_debug_on THEN
3806: WSH_DEBUG_SV.pop(l_module_name);
3807: END IF;
3808: --
3809: return;
3810:
3826: --
3827: -- Debug Statements
3828: --
3829: IF l_debug_on THEN
3830: WSH_DEBUG_SV.pop(l_module_name);
3831: END IF;
3832: --
3833: return;
3834: END IF;
3838: --
3839: -- Debug Statements
3840: --
3841: IF l_debug_on THEN
3842: WSH_DEBUG_SV.pop(l_module_name);
3843: END IF;
3844: --
3845: EXCEPTION
3846:
3851: --
3852: -- Debug Statements
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3857: END IF;
3858: --
3859: END Update_Locator_Subinv;
3852: -- Debug Statements
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3857: END IF;
3858: --
3859: END Update_Locator_Subinv;
3860:
3912: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3913: --
3914: IF l_debug_on IS NULL
3915: THEN
3916: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3917: END IF;
3918: --
3919: IF l_debug_on THEN
3920: WSH_DEBUG_SV.push(l_module_name);
3916: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3917: END IF;
3918: --
3919: IF l_debug_on THEN
3920: WSH_DEBUG_SV.push(l_module_name);
3921: --
3922: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3923: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3924: END IF;
3918: --
3919: IF l_debug_on THEN
3920: WSH_DEBUG_SV.push(l_module_name);
3921: --
3922: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3923: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3924: END IF;
3925: --
3926: IF p_delivery_detail_id IS NULL THEN
3919: IF l_debug_on THEN
3920: WSH_DEBUG_SV.push(l_module_name);
3921: --
3922: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3923: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
3924: END IF;
3925: --
3926: IF p_delivery_detail_id IS NULL THEN
3927: FND_MESSAGE.SET_NAME('WSH','WSH_DET_INVALID_DETAIL');
3930: --
3931: -- Debug Statements
3932: --
3933: IF l_debug_on THEN
3934: WSH_DEBUG_SV.pop(l_module_name);
3935: END IF;
3936: --
3937: return l_ser_qty;
3938: END IF;
3954: --
3955: -- Debug Statements
3956: --
3957: IF l_debug_on THEN
3958: WSH_DEBUG_SV.pop(l_module_name);
3959: END IF;
3960: --
3961: return l_ser_qty;
3962: END IF;
3970: --
3971: -- Debug Statements
3972: --
3973: IF l_debug_on THEN
3974: WSH_DEBUG_SV.pop(l_module_name);
3975: END IF;
3976: --
3977: return l_ser_qty;
3978: END IF;
3984: --
3985: -- Debug Statements
3986: --
3987: IF l_debug_on THEN
3988: WSH_DEBUG_SV.pop(l_module_name);
3989: END IF;
3990: --
3991: return l_ser_qty;
3992: END IF;
3998: --
3999: -- Debug Statements
4000: --
4001: IF l_debug_on THEN
4002: WSH_DEBUG_SV.pop(l_module_name);
4003: END IF;
4004: --
4005: return l_ser_qty;
4006: END IF;
4019: --
4020: -- Debug Statements
4021: --
4022: IF l_debug_on THEN
4023: WSH_DEBUG_SV.pop(l_module_name);
4024: END IF;
4025: --
4026: return l_ser_qty;
4027: END IF;
4033: --
4034: -- Debug Statements
4035: --
4036: IF l_debug_on THEN
4037: WSH_DEBUG_SV.pop(l_module_name);
4038: END IF;
4039: --
4040: return nvl(l_ser_qty,0);
4041:
4051: --
4052: -- Debug Statements
4053: --
4054: IF l_debug_on THEN
4055: WSH_DEBUG_SV.pop(l_module_name);
4056: END IF;
4057: --
4058: return l_ser_qty;
4059: END IF;
4061: --
4062: -- Debug Statements
4063: --
4064: IF l_debug_on THEN
4065: WSH_DEBUG_SV.pop(l_module_name);
4066: END IF;
4067: --
4068: return nvl(l_ser_qty,0);
4069:
4076: --
4077: -- Debug Statements
4078: --
4079: IF l_debug_on THEN
4080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4082: END IF;
4083: --
4084: return l_ser_qty;
4077: -- Debug Statements
4078: --
4079: IF l_debug_on THEN
4080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4082: END IF;
4083: --
4084: return l_ser_qty;
4085:
4114: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4115: --
4116: IF l_debug_on IS NULL
4117: THEN
4118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4119: END IF;
4120: --
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.push(l_module_name);
4118: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4119: END IF;
4120: --
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.push(l_module_name);
4123: --
4124: WSH_DEBUG_SV.log(l_module_name,'X_ITEM_ID',X_ITEM_ID);
4125: WSH_DEBUG_SV.log(l_module_name,'X_ORGANIZATION_ID',X_ORGANIZATION_ID);
4126: WSH_DEBUG_SV.log(l_module_name,'X_PICKABLE_FLAG',X_PICKABLE_FLAG);
4120: --
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.push(l_module_name);
4123: --
4124: WSH_DEBUG_SV.log(l_module_name,'X_ITEM_ID',X_ITEM_ID);
4125: WSH_DEBUG_SV.log(l_module_name,'X_ORGANIZATION_ID',X_ORGANIZATION_ID);
4126: WSH_DEBUG_SV.log(l_module_name,'X_PICKABLE_FLAG',X_PICKABLE_FLAG);
4127: END IF;
4128: --
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.push(l_module_name);
4123: --
4124: WSH_DEBUG_SV.log(l_module_name,'X_ITEM_ID',X_ITEM_ID);
4125: WSH_DEBUG_SV.log(l_module_name,'X_ORGANIZATION_ID',X_ORGANIZATION_ID);
4126: WSH_DEBUG_SV.log(l_module_name,'X_PICKABLE_FLAG',X_PICKABLE_FLAG);
4127: END IF;
4128: --
4129:
4122: WSH_DEBUG_SV.push(l_module_name);
4123: --
4124: WSH_DEBUG_SV.log(l_module_name,'X_ITEM_ID',X_ITEM_ID);
4125: WSH_DEBUG_SV.log(l_module_name,'X_ORGANIZATION_ID',X_ORGANIZATION_ID);
4126: WSH_DEBUG_SV.log(l_module_name,'X_PICKABLE_FLAG',X_PICKABLE_FLAG);
4127: END IF;
4128: --
4129:
4130: --Bug 5352779
4130: --Bug 5352779
4131: IF (x_item_id IS NULL) OR (x_organization_id IS NULL) THEN
4132: --
4133: IF l_debug_on THEN
4134: WSH_DEBUG_SV.pop(l_module_name);
4135: END IF;
4136: --
4137: return 'Y';
4138: END IF;
4167: --
4168: -- Debug Statements
4169: --
4170: IF l_debug_on THEN
4171: WSH_DEBUG_SV.pop(l_module_name);
4172: END IF;
4173: --
4174: return l_flag;
4175:
4178: WHEN FND_API.G_EXC_ERROR THEN
4179: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4180: WSH_UTIL_CORE.Add_Message(l_return_status);
4181: IF l_debug_on THEN
4182: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4183: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4184: END IF;
4185: --
4186: return 'Y';
4179: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4180: WSH_UTIL_CORE.Add_Message(l_return_status);
4181: IF l_debug_on THEN
4182: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4183: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4184: END IF;
4185: --
4186: return 'Y';
4187:
4190: --
4191: -- Debug Statements
4192: --
4193: IF l_debug_on THEN
4194: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4196: END IF;
4197: --
4198: RETURN 'Y';
4191: -- Debug Statements
4192: --
4193: IF l_debug_on THEN
4194: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4196: END IF;
4197: --
4198: RETURN 'Y';
4199:
4247: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4248: --
4249: IF l_debug_on IS NULL
4250: THEN
4251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4252: END IF;
4253: --
4254: IF l_debug_on THEN
4255: WSH_DEBUG_SV.push(l_module_name);
4251: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4252: END IF;
4253: --
4254: IF l_debug_on THEN
4255: WSH_DEBUG_SV.push(l_module_name);
4256: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4253: --
4254: IF l_debug_on THEN
4255: WSH_DEBUG_SV.push(l_module_name);
4256: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4254: IF l_debug_on THEN
4255: WSH_DEBUG_SV.push(l_module_name);
4256: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4262: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4255: WSH_DEBUG_SV.push(l_module_name);
4256: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4262: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4263: END IF;
4256: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4262: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4263: END IF;
4264: --
4257: WSH_DEBUG_SV.log(l_module_name,'P_DETAIL_ID',P_DETAIL_ID);
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4262: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4263: END IF;
4264: --
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4258: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
4259: WSH_DEBUG_SV.log(l_module_name,'P_RELEASED_STATUS',P_RELEASED_STATUS);
4260: WSH_DEBUG_SV.log(l_module_name,'P_PICKABLE_FLAG',P_PICKABLE_FLAG);
4261: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4262: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4263: END IF;
4264: --
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4266: IF p_pickable_flag = 'N'
4269: --
4270: -- Debug Statements
4271: --
4272: IF l_debug_on THEN
4273: WSH_DEBUG_SV.pop(l_module_name);
4274: END IF;
4275: --
4276: return 'N' ;
4277: END IF;
4282: --
4283: -- Debug Statements
4284: --
4285: IF l_debug_on THEN
4286: WSH_DEBUG_SV.pop(l_module_name);
4287: END IF;
4288: --
4289: RETURN g_cache_reservable_flag;
4290: END IF;
4313: --
4314: -- Debug Statements
4315: --
4316: IF l_debug_on THEN
4317: WSH_DEBUG_SV.pop(l_module_name);
4318: END IF;
4319: --
4320: RETURN g_cache_reservable_flag;
4321:
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4326: WSH_UTIL_CORE.Add_Message(x_return_status);
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4329: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4330: END IF;
4331:
4332: WHEN OTHERS THEN
4325: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4326: WSH_UTIL_CORE.Add_Message(x_return_status);
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4329: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4330: END IF;
4331:
4332: WHEN OTHERS THEN
4333: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERY_DETAILS_INV.Line_Reserved');
4335: --
4336: -- Debug Statements
4337: --
4338: IF l_debug_on THEN
4339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4341: END IF;
4342: --
4343: RETURN NULL;
4336: -- Debug Statements
4337: --
4338: IF l_debug_on THEN
4339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4341: END IF;
4342: --
4343: RETURN NULL;
4344:
4394: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4395: --
4396: IF l_debug_on IS NULL
4397: THEN
4398: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4399: END IF;
4400: --
4401: IF l_debug_on THEN
4402: WSH_DEBUG_SV.push(l_module_name);
4398: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4399: END IF;
4400: --
4401: IF l_debug_on THEN
4402: WSH_DEBUG_SV.push(l_module_name);
4403: --
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4400: --
4401: IF l_debug_on THEN
4402: WSH_DEBUG_SV.push(l_module_name);
4403: --
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4401: IF l_debug_on THEN
4402: WSH_DEBUG_SV.push(l_module_name);
4403: --
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4402: WSH_DEBUG_SV.push(l_module_name);
4403: --
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4403: --
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4404: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4405: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4406: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4407: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4415: WSH_DEBUG_SV.log(l_module_name,'p_source_document_type_id',p_source_document_type_id);
4408: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4415: WSH_DEBUG_SV.log(l_module_name,'p_source_document_type_id',p_source_document_type_id);
4416:
4409: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4415: WSH_DEBUG_SV.log(l_module_name,'p_source_document_type_id',p_source_document_type_id);
4416:
4417: END IF;
4410: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4415: WSH_DEBUG_SV.log(l_module_name,'p_source_document_type_id',p_source_document_type_id);
4416:
4417: END IF;
4418: --
4411: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4412: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4413: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4414: WSH_DEBUG_SV.log(l_module_name,'p_serial_number_type_id',p_serial_number_type_id);
4415: WSH_DEBUG_SV.log(l_module_name,'p_source_document_type_id',p_source_document_type_id);
4416:
4417: END IF;
4418: --
4419: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4468:
4469: l_to_number := p_to_number;
4470: -- RTV Changes
4471: IF l_debug_on THEN
4472: WSH_DEBUG_SV.logmsg(l_module_name,'trx_action_id '||trx_action_id||' trx_source_type '|| trx_source_type);
4473: END IF;
4474:
4475:
4476: --
4476: --
4477: -- Debug Statements
4478: --
4479: IF l_debug_on THEN
4480: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.TRX_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
4481: END IF;
4482: --
4483: -- RTV changes
4484: if (trx_action_id is NULL and l_header_info.source_code NOT IN ('RTV', 'OSP' ) ) then
4499: --
4500: -- Debug Statements
4501: --
4502: IF l_debug_on THEN
4503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS',WSH_DEBUG_SV.C_PROC_LEVEL);
4504: END IF;
4505: --
4506:
4507:
4535: --
4536: -- Debug Statements
4537: --
4538: IF l_debug_on THEN
4539: WSH_DEBUG_SV.pop(l_module_name);
4540: END IF;
4541: --
4542: EXCEPTION
4543:
4548: END IF;
4549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4550: WSH_UTIL_CORE.Add_Message(x_return_status);
4551: IF l_debug_on THEN
4552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4554: END IF;
4555:
4556: WHEN WSH_INVALID_SER_NUM THEN
4549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4550: WSH_UTIL_CORE.Add_Message(x_return_status);
4551: IF l_debug_on THEN
4552: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4553: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4554: END IF;
4555:
4556: WHEN WSH_INVALID_SER_NUM THEN
4557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4557: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4558: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SER_NUM');
4559: WSH_UTIL_CORE.Add_Message(x_return_status);
4560: IF l_debug_on THEN
4561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_SER_NUM');
4563: END IF;
4564:
4565: WHEN others THEN
4558: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_SER_NUM');
4559: WSH_UTIL_CORE.Add_Message(x_return_status);
4560: IF l_debug_on THEN
4561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_SER_NUM');
4563: END IF;
4564:
4565: WHEN others THEN
4566: IF c_header_info%ISOPEN THEN
4571: --
4572: -- Debug Statements
4573: --
4574: IF l_debug_on THEN
4575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4577: END IF;
4578:
4579: --
4572: -- Debug Statements
4573: --
4574: IF l_debug_on THEN
4575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4577: END IF;
4578:
4579: --
4580: END Create_Dynamic_Serial;
4647: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4648: --
4649: IF l_debug_on IS NULL
4650: THEN
4651: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4652: END IF;
4653: --
4654: IF l_debug_on THEN
4655: WSH_DEBUG_SV.push(l_module_name);
4651: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4652: END IF;
4653: --
4654: IF l_debug_on THEN
4655: WSH_DEBUG_SV.push(l_module_name);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4652: END IF;
4653: --
4654: IF l_debug_on THEN
4655: WSH_DEBUG_SV.push(l_module_name);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4653: --
4654: IF l_debug_on THEN
4655: WSH_DEBUG_SV.push(l_module_name);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4654: IF l_debug_on THEN
4655: WSH_DEBUG_SV.push(l_module_name);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4655: WSH_DEBUG_SV.push(l_module_name);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4656: WSH_DEBUG_SV.log(l_module_name, 'From Serial Num',p_from_serial_number);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4657: WSH_DEBUG_SV.log(l_module_name, 'To Serial Num', p_to_serial_number);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4658: WSH_DEBUG_SV.log(l_module_name, 'Lot Number', p_lot_number);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4666: WSH_DEBUG_SV.log(l_module_name, 'p_object_type', p_object_type);
4659: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', p_organization_id);
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4666: WSH_DEBUG_SV.log(l_module_name, 'p_object_type', p_object_type);
4667: END IF;
4660: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item id', p_inventory_item_id);
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4666: WSH_DEBUG_SV.log(l_module_name, 'p_object_type', p_object_type);
4667: END IF;
4668: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4661: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', p_subinventory);
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4666: WSH_DEBUG_SV.log(l_module_name, 'p_object_type', p_object_type);
4667: END IF;
4668: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4669: g_org.organization_id := p_organization_id;
4662: WSH_DEBUG_SV.log(l_module_name, 'Revision', p_revision);
4663: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', p_locator_id);
4664: WSH_DEBUG_SV.log(l_module_name, 'Quantity', p_quantity);
4665: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_type_id', p_transaction_type_id);
4666: WSH_DEBUG_SV.log(l_module_name, 'p_object_type', p_object_type);
4667: END IF;
4668: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4669: g_org.organization_id := p_organization_id;
4670:
4668: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4669: g_org.organization_id := p_organization_id;
4670:
4671: IF l_debug_on THEN
4672: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.ORGANIZATION',WSH_DEBUG_SV.C_PROC_LEVEL);
4673: END IF;
4674:
4675: l_result := INV_VALIDATE.organization(g_org);
4676:
4674:
4675: l_result := INV_VALIDATE.organization(g_org);
4676:
4677: IF(l_debug_on) THEN
4678: wsh_debug_sv.log(l_module_name, 'Org Result', l_result);
4679: END IF;
4680:
4681: IF (l_result <> INV_VALIDATE.T) THEN
4682: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4685: END IF;
4686: g_item.inventory_item_id := p_inventory_item_id;
4687:
4688: IF l_debug_on THEN
4689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.INVENTORY_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
4690: END IF;
4691: l_result := wsh_delivery_details_inv.inventory_item(
4692: p_item => g_item,
4693: p_org => g_org);
4692: p_item => g_item,
4693: p_org => g_org);
4694:
4695: IF(l_debug_on) THEN
4696: wsh_debug_sv.log(l_module_name, 'Inv Item Result', l_result);
4697: END IF;
4698:
4699: IF (l_result <> INV_VALIDATE.T) THEN
4700: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4704:
4705: g_sub.secondary_inventory_name := p_subinventory;
4706:
4707: IF l_debug_on THEN
4708: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.FROM_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4709: END IF;
4710: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
4711: l_result := INV_VALIDATE.From_Subinventory(
4712: p_org => g_org,
4722: p_item => g_item,
4723: p_acct_txn => 1);
4724: END IF;
4725: IF(l_debug_on) THEN
4726: wsh_debug_sv.log(l_module_name, 'Subinv Result', l_result);
4727: END IF;
4728:
4729: IF (l_result <> INV_VALIDATE.T) THEN
4730: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4736: -- Need to check if locator is NULL cause inventory validation API will
4737: -- validate on flex field and return false when locator is NULL
4738: IF (p_locator_id IS NOT NULL) THEN
4739: IF l_debug_on THEN
4740: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATELOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4741: END IF;
4742: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
4743: l_result := INV_VALIDATE.validateLocator(
4744: p_locator => g_loc,
4754: p_sub => g_sub,
4755: p_item => g_item);
4756: END IF;
4757: IF(l_debug_on) THEN
4758: wsh_debug_sv.log(l_module_name, 'Locator Result', l_result);
4759: END IF;
4760:
4761: IF (l_result = INV_VALIDATE.F) THEN
4762: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4767:
4768: g_lot.lot_number := p_lot_number;
4769: IF (p_lot_number IS NOT NULL) THEN
4770: IF l_debug_on THEN
4771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.LOT_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
4772: END IF;
4773: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
4774: l_result := INV_VALIDATE.Lot_Number(
4775: p_lot => g_lot,
4789: p_loc => g_loc,
4790: p_revision => p_revision);
4791: END IF;
4792: IF(l_debug_on) THEN
4793: wsh_debug_sv.log(l_module_name, 'Lot Number Result', l_result);
4794: END IF;
4795:
4796: IF (l_result <> INV_VALIDATE.T) THEN
4797: FND_MESSAGE.SET_NAME('WSH','WSH_INV_INVALID');
4800: END IF;
4801: END IF;
4802:
4803: IF l_debug_on THEN
4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit MTL_SERIAL_CHECK.INV_SERIAL_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
4805: END IF;
4806:
4807: IF NOT MTL_SERIAL_CHECK.INV_SERIAL_INFO(p_from_serial_number => p_from_serial_number ,
4808: p_to_serial_number => p_to_serial_number ,
4813: x_errorcode => x_errorcode)
4814: THEN
4815: x_result := FALSE;
4816: IF l_debug_on THEN
4817: WSH_DEBUG_SV.pop(l_module_name);
4818: END IF;
4819: RETURN;
4820: END IF;
4821: IF (x_quantity <> p_quantity) THEN
4820: END IF;
4821: IF (x_quantity <> p_quantity) THEN
4822: x_result := false;
4823: IF l_debug_on THEN
4824: WSH_DEBUG_SV.pop(l_module_name);
4825: END IF;
4826: RETURN;
4827: END IF;
4828: l_number_part := TO_NUMBER(l_FROM_NUMBER);
4830: -- Get the length of the serial number
4831: l_length := length(p_from_serial_number);
4832:
4833: IF(l_debug_on) THEN
4834: wsh_debug_sv.log(l_module_name, 'Length ', l_length);
4835: END IF;
4836:
4837: IF p_transaction_type_id IS NOT NULL AND p_object_type IS NOT NULL THEN
4838: l_fm_serial(1) := p_from_serial_number;
4854: ELSE
4855: x_result := FALSE;
4856: FOR i in 1..x_errored_serials.count LOOP
4857: IF l_debug_on THEN
4858: wsh_debug_sv.log(l_module_name, 'errored serial_number'||to_char(i), x_errored_serials(i));
4859: END IF;
4860: END LOOP;
4861: END IF;
4862: ELSE
4868: l_padded_length := l_length - length(l_number_part);
4869: g_serial.serial_number := RPAD(nvl(x_Prefix,'0'), l_padded_length, '0') ||l_number_part;
4870:
4871: IF l_debug_on THEN
4872: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_VALIDATE.VALIDATE_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
4873: END IF;
4874: l_result := INV_VALIDATE.Validate_serial(
4875: p_serial => g_serial,
4876: p_lot => g_lot,
4880: p_loc => g_loc,
4881: p_revision => p_revision);
4882:
4883: IF l_debug_on THEN
4884: wsh_debug_sv.log(l_module_name, 'Serial Result', l_result);
4885: END IF;
4886:
4887: IF (l_result = INV_VALIDATE.T) THEN
4888: x_result := TRUE;
4899: x_result := FALSE;
4900: END IF;
4901: END IF;
4902: IF l_debug_on THEN
4903: WSH_DEBUG_SV.pop(l_module_name);
4904: END IF;
4905:
4906: EXCEPTION
4907: WHEN FND_API.G_EXC_ERROR THEN
4907: WHEN FND_API.G_EXC_ERROR THEN
4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: WSH_UTIL_CORE.Add_Message(x_return_status);
4910: IF l_debug_on THEN
4911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4913: END IF;
4914:
4915: WHEN others THEN
4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: WSH_UTIL_CORE.Add_Message(x_return_status);
4910: IF l_debug_on THEN
4911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4913: END IF;
4914:
4915: WHEN others THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4915: WHEN others THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4917: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Validate_Serial_Range');
4918: IF l_debug_on THEN
4919: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4920: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4921: END IF;
4922:
4923: END Validate_Serial_Range;
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4917: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Validate_Serial_Range');
4918: IF l_debug_on THEN
4919: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4920: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4921: END IF;
4922:
4923: END Validate_Serial_Range;
4924:
4967: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4968: --
4969: IF l_debug_on IS NULL
4970: THEN
4971: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4972: END IF;
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.push(l_module_name);
4971: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4972: END IF;
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.push(l_module_name);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4972: END IF;
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.push(l_module_name);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.push(l_module_name);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.push(l_module_name);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4975: WSH_DEBUG_SV.push(l_module_name);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4976: WSH_DEBUG_SV.log(l_module_name,'P_FROM_NUMBER',P_FROM_NUMBER);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4977: WSH_DEBUG_SV.log(l_module_name,'P_TO_NUMBER',P_TO_NUMBER);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4978: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4986: WSH_DEBUG_SV.log(l_module_name, 'P_QUANTITY',p_quantity);
4979: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4986: WSH_DEBUG_SV.log(l_module_name, 'P_QUANTITY',p_quantity);
4987: END IF;
4980: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4986: WSH_DEBUG_SV.log(l_module_name, 'P_QUANTITY',p_quantity);
4987: END IF;
4988:
4981: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4986: WSH_DEBUG_SV.log(l_module_name, 'P_QUANTITY',p_quantity);
4987: END IF;
4988:
4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4982: WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
4983: WSH_DEBUG_SV.log(l_module_name,'P_LOT_NUMBER',P_LOT_NUMBER);
4984: WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY',P_SUBINVENTORY);
4985: WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
4986: WSH_DEBUG_SV.log(l_module_name, 'P_QUANTITY',p_quantity);
4987: END IF;
4988:
4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4990:
5024: l_trx_source_type := '5';
5025: end if; --}
5026:
5027: IF l_debug_on THEN
5028: WSH_DEBUG_SV.logmsg(l_module_name, 'Serial Number Type '||l_serial_number_type||' l_trx_action_id '||l_trx_action_id||' l_trx_source_type '||l_trx_source_type);
5029: END IF;
5030:
5031: l_to_number := p_to_number;
5032:
5032:
5033: -- RTV changes
5034: if (l_trx_action_id is NULL and l_header_info.source_code NOT IN ('RTV', 'OSP') ) then
5035: IF l_debug_on THEN
5036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.TRX_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
5037: END IF;
5038: l_trx_action_id := WSH_DETAILS_VALIDATIONS.Trx_Id('TRX_ACTION_ID',
5039: p_source_line_id,
5040: l_header_info.source_document_type_id);
5049: END IF;
5050: end if; -- RTV changes
5051:
5052: IF l_debug_on THEN
5053: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS',WSH_DEBUG_SV.C_PROC_LEVEL);
5054: END IF;
5055:
5056: l_return := INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS(
5057: p_org_id => p_organization_id,
5077:
5078:
5079:
5080: IF l_debug_on THEN
5081: wsh_debug_sv.log(l_module_name, 'Quantity', l_quantity);
5082: wsh_debug_sv.log(l_module_name, 'Prefix', l_prefix);
5083: END IF;
5084: IF (l_quantity <> p_quantity) THEN
5085: fnd_message.set_name('WSH', 'WSH_SERIAL_NUM_WRG_RANGE');
5078:
5079:
5080: IF l_debug_on THEN
5081: wsh_debug_sv.log(l_module_name, 'Quantity', l_quantity);
5082: wsh_debug_sv.log(l_module_name, 'Prefix', l_prefix);
5083: END IF;
5084: IF (l_quantity <> p_quantity) THEN
5085: fnd_message.set_name('WSH', 'WSH_SERIAL_NUM_WRG_RANGE');
5086: RAISE FND_API.G_EXC_ERROR;
5088:
5089: x_prefix := l_prefix;
5090:
5091: IF l_debug_on THEN
5092: WSH_DEBUG_SV.pop(l_module_name);
5093: END IF;
5094:
5095: EXCEPTION
5096: WHEN FND_API.G_EXC_ERROR THEN
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5098: WSH_UTIL_CORE.Add_Message(x_return_status);
5099: IF l_debug_on THEN
5100: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5101: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5102: END IF;
5103: --RTV changes
5104: IF c_header_info%ISOPEN THEN
5097: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5098: WSH_UTIL_CORE.Add_Message(x_return_status);
5099: IF l_debug_on THEN
5100: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5101: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5102: END IF;
5103: --RTV changes
5104: IF c_header_info%ISOPEN THEN
5105: close c_header_info;
5115: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5116: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Create_Dynamic_Serial_Range');
5117:
5118: IF l_debug_on THEN
5119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5121: END IF;
5122:
5123: END Create_Dynamic_Serial_Range;
5116: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Create_Dynamic_Serial_Range');
5117:
5118: IF l_debug_on THEN
5119: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5121: END IF;
5122:
5123: END Create_Dynamic_Serial_Range;
5124:
5146:
5147: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5148: --
5149: IF l_debug_on IS NULL THEN
5150: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5151: END IF;
5152:
5153: IF l_debug_on THEN
5154: WSH_DEBUG_SV.push(l_module_name);
5150: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5151: END IF;
5152:
5153: IF l_debug_on THEN
5154: WSH_DEBUG_SV.push(l_module_name);
5155: WSH_DEBUG_SV.log(l_module_name,'p_line_inv_rec.delivery_detail_id', p_line_inv_rec.delivery_detail_id);
5156: END IF;
5157:
5158: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5151: END IF;
5152:
5153: IF l_debug_on THEN
5154: WSH_DEBUG_SV.push(l_module_name);
5155: WSH_DEBUG_SV.log(l_module_name,'p_line_inv_rec.delivery_detail_id', p_line_inv_rec.delivery_detail_id);
5156: END IF;
5157:
5158: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5159:
5157:
5158: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5159:
5160: IF l_debug_on THEN
5161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_SHIPPING_INTERFACE_GRP.process_delivery_details',WSH_DEBUG_SV.C_PROC_LEVEL);
5162: END IF;
5163:
5164: -- Call to WMS API to check/default catch weights
5165:
5182: x_msg_count => l_msg_count,
5183: x_msg_data => l_msg_data);
5184:
5185: IF l_debug_on THEN
5186: WSH_DEBUG_SV.log(l_module_name,'return status after calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details', x_return_status);
5187: WSH_DEBUG_SV.log(l_module_name,'status of dd after calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details', l_wms_table(1).return_status);
5188: END IF;
5189:
5190: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) OR
5183: x_msg_data => l_msg_data);
5184:
5185: IF l_debug_on THEN
5186: WSH_DEBUG_SV.log(l_module_name,'return status after calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details', x_return_status);
5187: WSH_DEBUG_SV.log(l_module_name,'status of dd after calling WMS_SHIPPING_INTERFACE_GRP.process_delivery_details', l_wms_table(1).return_status);
5188: END IF;
5189:
5190: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) OR
5191: (l_wms_table(1).return_status = 'E')
5196: WSH_UTIL_CORE.Add_Message(x_return_status);
5197: END IF;
5198:
5199: IF l_debug_on THEN
5200: WSH_DEBUG_SV.pop(l_module_name);
5201: END IF;
5202:
5203: EXCEPTION
5204:
5206: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5207: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights');
5208:
5209: IF l_debug_on THEN
5210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5212: END IF;
5213:
5214: END Check_Default_Catch_Weights;
5207: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights');
5208:
5209: IF l_debug_on THEN
5210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5212: END IF;
5213:
5214: END Check_Default_Catch_Weights;
5215:
5256:
5257: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5258: IF l_debug_on IS NULL
5259: THEN
5260: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5261: END IF;
5262: IF l_debug_on THEN
5263: WSH_DEBUG_SV.push(l_module_name);
5264: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
5259: THEN
5260: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5261: END IF;
5262: IF l_debug_on THEN
5263: WSH_DEBUG_SV.push(l_module_name);
5264: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
5265: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',p_inventory_item_id);
5266: END IF;
5267:
5260: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5261: END IF;
5262: IF l_debug_on THEN
5263: WSH_DEBUG_SV.push(l_module_name);
5264: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
5265: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',p_inventory_item_id);
5266: END IF;
5267:
5268: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5261: END IF;
5262: IF l_debug_on THEN
5263: WSH_DEBUG_SV.push(l_module_name);
5264: WSH_DEBUG_SV.log(l_module_name,'p_organization_id',p_organization_id);
5265: WSH_DEBUG_SV.log(l_module_name,'p_inventory_item_id',p_inventory_item_id);
5266: END IF;
5267:
5268: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5269:
5281: );
5282:
5283: IF l_flag = 'U' AND l_index IS NOT NULL THEN
5284: IF l_debug_on THEN
5285: WSH_DEBUG_SV.log(l_module_name,'Org is not cached yet: ',p_organization_id);
5286: WSH_DEBUG_SV.log(l_module_name,'Item_id is not cached yet: ',p_inventory_item_id);
5287: END IF ;
5288: OPEN c_item_info (p_organization_id,p_inventory_item_id);
5289:
5282:
5283: IF l_flag = 'U' AND l_index IS NOT NULL THEN
5284: IF l_debug_on THEN
5285: WSH_DEBUG_SV.log(l_module_name,'Org is not cached yet: ',p_organization_id);
5286: WSH_DEBUG_SV.log(l_module_name,'Item_id is not cached yet: ',p_inventory_item_id);
5287: END IF ;
5288: OPEN c_item_info (p_organization_id,p_inventory_item_id);
5289:
5290: FETCH c_item_info INTO l_cache_rec;
5298: -- add record to cache
5299: g_item_tab(l_index) := l_cache_rec;
5300: ELSE
5301: IF l_debug_on THEN
5302: WSH_DEBUG_SV.log(l_module_name,'Org is already chached: ',p_organization_id);
5303: WSH_DEBUG_SV.log(l_module_name,'Inv_item_id is already chached',p_inventory_item_id);
5304: END IF;
5305: -- retrieve record from cache
5306: l_cache_rec := g_item_tab(l_index);
5299: g_item_tab(l_index) := l_cache_rec;
5300: ELSE
5301: IF l_debug_on THEN
5302: WSH_DEBUG_SV.log(l_module_name,'Org is already chached: ',p_organization_id);
5303: WSH_DEBUG_SV.log(l_module_name,'Inv_item_id is already chached',p_inventory_item_id);
5304: END IF;
5305: -- retrieve record from cache
5306: l_cache_rec := g_item_tab(l_index);
5307: END IF;
5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5315: wsh_util_core.add_message(x_return_status,l_module_name);
5316:
5317: IF l_debug_on THEN
5318: WSH_DEBUG_SV.pop(l_module_name);
5319: END IF;
5320:
5321: RETURN;
5322: END IF;
5348:
5349: ELSE -- Both or one is NULL (Org and Inv_item)
5350: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5351: IF l_debug_on THEN
5352: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5353: END IF;
5354: --
5355: RETURN;
5356: END IF;
5355: RETURN;
5356: END IF;
5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5356: END IF;
5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5357:
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5358: IF l_debug_on THEN
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5359: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.primary_uom_code',x_mtl_system_items_rec.primary_uom_code);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5364: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5365: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5375:
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5375:
5376: EXCEPTION
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);
5370: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.container_item_flag',x_mtl_system_items_rec.container_item_flag);
5371: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.reservable_type',x_mtl_system_items_rec.reservable_type);
5372: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.mtl_transactions_enabled_flag',x_mtl_system_items_rec.mtl_transactions_enabled_flag);
5373: WSH_DEBUG_SV.pop(l_module_name,x_return_status);
5374: END IF;
5375:
5376: EXCEPTION
5377:
5379: wsh_util_core.default_handler ('WSH_DELIVERY_DETAILS_INV .Get_item_information');
5380: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5381:
5382: IF l_debug_on THEN
5383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5385: END IF;
5386:
5387: IF c_item_info%isopen THEN
5380: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5381:
5382: IF l_debug_on THEN
5383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5385: END IF;
5386:
5387: IF c_item_info%isopen THEN
5388: close c_item_info;
5437: --
5438: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5439: --
5440: IF l_debug_on IS NULL THEN
5441: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5442: END IF;
5443: --
5444: IF l_debug_on THEN
5445: WSH_DEBUG_SV.push(l_module_name);
5441: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5442: END IF;
5443: --
5444: IF l_debug_on THEN
5445: WSH_DEBUG_SV.push(l_module_name);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5442: END IF;
5443: --
5444: IF l_debug_on THEN
5445: WSH_DEBUG_SV.push(l_module_name);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5443: --
5444: IF l_debug_on THEN
5445: WSH_DEBUG_SV.push(l_module_name);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5444: IF l_debug_on THEN
5445: WSH_DEBUG_SV.push(l_module_name);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5445: WSH_DEBUG_SV.push(l_module_name);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5446: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SERIAL_NUMBER',P_FROM_SERIAL_NUMBER);
5447: WSH_DEBUG_SV.log(l_module_name,'P_TO_SERIAL_NUMBER',P_TO_SERIAL_NUMBER);
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5454: END IF;
5448: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5454: END IF;
5455: --
5456: --RTV changes
5449: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
5450: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TEMP_ID',
5451: P_TRANSACTION_TEMP_ID);
5452: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
5453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit SERIAL_CHECK.INV_UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
5454: END IF;
5455: --
5456: --RTV changes
5457: OPEN Fetch_Detail_Info;
5463: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5464: WSH_UTIL_CORE.Add_Message(x_return_status);
5465:
5466: IF l_debug_on THEN
5467: WSH_DEBUG_SV.pop(l_module_name);
5468: END IF;
5469: RETURN;
5470: END IF;
5471:
5503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5504: WSH_UTIL_CORE.Add_Message(x_return_status);
5505: --
5506: IF l_debug_on THEN
5507: WSH_DEBUG_SV.log(l_module_name, 'Return status after INV API',
5508: x_return_status);
5509: WSH_DEBUG_SV.pop(l_module_name);
5510: END IF;
5511: --
5505: --
5506: IF l_debug_on THEN
5507: WSH_DEBUG_SV.log(l_module_name, 'Return status after INV API',
5508: x_return_status);
5509: WSH_DEBUG_SV.pop(l_module_name);
5510: END IF;
5511: --
5512: RETURN;
5513: --
5515: --
5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5517: --
5518: IF l_debug_on THEN
5519: WSH_DEBUG_SV.pop(l_module_name);
5520: END IF;
5521: --
5522: EXCEPTION
5523: --
5526: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial');
5527: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5528: --
5529: IF l_debug_on THEN
5530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5531: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5532: END IF;
5533: --
5534: --RTV changes
5527: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5528: --
5529: IF l_debug_on THEN
5530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5531: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5532: END IF;
5533: --
5534: --RTV changes
5535: IF Fetch_Detail_Info%ISOPEN THEN
5595: --
5596: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5597: --
5598: IF l_debug_on IS NULL THEN
5599: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5600: END IF;
5601: --
5602: IF l_debug_on THEN
5603: WSH_DEBUG_SV.push(l_module_name);
5599: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5600: END IF;
5601: --
5602: IF l_debug_on THEN
5603: WSH_DEBUG_SV.push(l_module_name);
5604: WSH_DEBUG_SV.log(l_module_name,'p_source_line_id',p_source_line_id);
5605: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
5606: END IF;
5607:
5600: END IF;
5601: --
5602: IF l_debug_on THEN
5603: WSH_DEBUG_SV.push(l_module_name);
5604: WSH_DEBUG_SV.log(l_module_name,'p_source_line_id',p_source_line_id);
5605: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
5606: END IF;
5607:
5608: IF p_source_code ='OE' THEN --{
5601: --
5602: IF l_debug_on THEN
5603: WSH_DEBUG_SV.push(l_module_name);
5604: WSH_DEBUG_SV.log(l_module_name,'p_source_line_id',p_source_line_id);
5605: WSH_DEBUG_SV.log(l_module_name,'p_source_code',p_source_code);
5606: END IF;
5607:
5608: IF p_source_code ='OE' THEN --{
5609:
5612: IF c_order_line_info%NOTFOUND THEN
5613: CLOSE c_order_line_info;
5614: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5615: IF l_debug_on THEN
5616: WSH_DEBUG_SV.log(l_module_name, 'No data found for order line',p_source_line_id);
5617: WSH_DEBUG_SV.pop(l_module_name);
5618: END IF;
5619: return;
5620: END IF;
5613: CLOSE c_order_line_info;
5614: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5615: IF l_debug_on THEN
5616: WSH_DEBUG_SV.log(l_module_name, 'No data found for order line',p_source_line_id);
5617: WSH_DEBUG_SV.pop(l_module_name);
5618: END IF;
5619: return;
5620: END IF;
5621: CLOSE c_order_line_info;
5627: IF c_po_info%NOTFOUND THEN
5628: CLOSE c_po_info;
5629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5630: IF l_debug_on THEN
5631: WSH_DEBUG_SV.logmsg(l_module_name, 'No data found for PO '||l_order_line_info.source_document_line_id||' ,'||l_order_line_info.source_document_id);
5632: WSH_DEBUG_SV.pop(l_module_name);
5633: END IF;
5634: return;
5635: END IF;
5628: CLOSE c_po_info;
5629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5630: IF l_debug_on THEN
5631: WSH_DEBUG_SV.logmsg(l_module_name, 'No data found for PO '||l_order_line_info.source_document_line_id||' ,'||l_order_line_info.source_document_id);
5632: WSH_DEBUG_SV.pop(l_module_name);
5633: END IF;
5634: return;
5635: END IF;
5636: CLOSE c_po_info;
5685: x_transaction_type_id := 32; -- miscellaneous issue
5686: END IF;
5687:
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.log(l_module_name, 'x_transaction_type_id',x_transaction_type_id);
5690: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',x_return_status);
5691: WSH_DEBUG_SV.pop(l_module_name);
5692: END IF;
5693:
5686: END IF;
5687:
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.log(l_module_name, 'x_transaction_type_id',x_transaction_type_id);
5690: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',x_return_status);
5691: WSH_DEBUG_SV.pop(l_module_name);
5692: END IF;
5693:
5694: EXCEPTION
5687:
5688: IF l_debug_on THEN
5689: WSH_DEBUG_SV.log(l_module_name, 'x_transaction_type_id',x_transaction_type_id);
5690: WSH_DEBUG_SV.log(l_module_name, 'x_return_status',x_return_status);
5691: WSH_DEBUG_SV.pop(l_module_name);
5692: END IF;
5693:
5694: EXCEPTION
5695:
5712: CLOSE c_get_rtv_type;
5713: END IF;
5714:
5715: IF l_debug_on THEN
5716: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5718: END IF;
5719:
5720: END get_trx_type_id;
5713: END IF;
5714:
5715: IF l_debug_on THEN
5716: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5718: END IF;
5719:
5720: END get_trx_type_id;
5721: