1031: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1032: --
1033: IF l_debug_on IS NULL
1034: THEN
1035: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1036: END IF;
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1035: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1036: END IF;
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1036: END IF;
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1037: --
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.push(l_module_name);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1039: WSH_DEBUG_SV.push(l_module_name);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1040: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1041: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1042: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_ORG_ID',P_SHIP_TO_ORG_ID);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1043: WSH_DEBUG_SV.log(l_module_name,'P_INTMED_SHIP_TO_ORG_ID',P_INTMED_SHIP_TO_ORG_ID); --Bugfix 5911991
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1044: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_ORG_ID',P_SHIP_FROM_ORG_ID);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1045: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1046: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ITEM_ID',P_CUSTOMER_ITEM_ID);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1047: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_HEADER_ID',P_ORDER_HEADER_ID);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1048: WSH_DEBUG_SV.log(l_module_name,'P_BLANKET_NUMBER',P_BLANKET_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1049: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',P_ORG_ID);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1050: WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_TYPE',P_SCHEDULE_TYPE);
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1051: WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_DATE',P_SHIPMENT_DATE);
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1052: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_LINE);
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1053: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE',P_OPTIONAL_MATCH_REC.CUSTOMER_DOCK_CODE);
1054: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER',P_OPTIONAL_MATCH_REC.CUST_PO_NUMBER);
1055: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUSTOMER_JOB',P_OPTIONAL_MATCH_REC.CUSTOMER_JOB);
1056: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER',P_OPTIONAL_MATCH_REC.CUST_MODEL_SERIAL_NUMBER);
1057: WSH_DEBUG_SV.log(l_module_name,'P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM',P_OPTIONAL_MATCH_REC.CUST_PRODUCTION_SEQ_NUM);
1058: END IF;
1059: --
1060: rlm_core_sv.dlog('Entering WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1061: rlm_core_sv.dlog('Blanket Number = ' || p_blanket_number);
1071: rlm_core_sv.dlog('Intransit Calculation for ATP Item');
1072: ELSE
1073: --
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: END IF;
1077: --
1078: wsh_util_core.get_location_id('ORG',p_ship_from_org_id,
1079: l_ship_from_location_id,
1086: AND (l_ship_from_location_id IS NULL) THEN
1087: x_in_transit_qty := 0 ;
1088: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',
1091: x_in_transit_qty);
1092: WSH_DEBUG_SV.pop(l_module_name);
1093: END IF;
1094: RETURN;
1088: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',
1091: x_in_transit_qty);
1092: WSH_DEBUG_SV.pop(l_module_name);
1093: END IF;
1094: RETURN;
1095: ELSE
1096: raise INVALID_ORG;
1099:
1100: IF p_source_code = 'OE' THEN
1101: --
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
1104: END IF;
1105: --
1106: wsh_util_core.get_location_id('CUSTOMER SITE',p_ship_to_org_id,
1107: l_ship_to_location_id,
1113: AND (l_ship_to_location_id IS NULL) THEN
1114: x_in_transit_qty := 0 ;
1115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1116: IF l_debug_on THEN
1117: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY', x_in_transit_qty);
1118: WSH_DEBUG_SV.pop(l_module_name);
1119: END IF;
1120: RETURN;
1121: ELSE
1114: x_in_transit_qty := 0 ;
1115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1116: IF l_debug_on THEN
1117: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY', x_in_transit_qty);
1118: WSH_DEBUG_SV.pop(l_module_name);
1119: END IF;
1120: RETURN;
1121: ELSE
1122: raise invalid_cust_site;
1261: rlm_core_sv.dlog('intransit qty = '|| x_in_transit_qty);
1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');
1263: --
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',x_in_transit_qty);
1266: WSH_DEBUG_SV.pop(l_module_name);
1267: END IF;
1268: --
1269: EXCEPTION
1262: rlm_core_sv.dlog('Exiting WSH_RLM_INTERFACE.get_in_transit_qty');
1263: --
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name,'X_INTRANSIT_QTY',x_in_transit_qty);
1266: WSH_DEBUG_SV.pop(l_module_name);
1267: END IF;
1268: --
1269: EXCEPTION
1270:
1275: --
1276: -- Debug Statements
1277: --
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_ORG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_ORG');
1281: END IF;
1282: --
1283: WHEN invalid_cust_site THEN
1276: -- Debug Statements
1277: --
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_ORG exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1280: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_ORG');
1281: END IF;
1282: --
1283: WHEN invalid_cust_site THEN
1284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: --
1288: -- Debug Statements
1289: --
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_CUST_SITE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1292: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_CUST_SITE');
1293: END IF;
1294: --
1295: WHEN others THEN
1288: -- Debug Statements
1289: --
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_CUST_SITE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1292: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_CUST_SITE');
1293: END IF;
1294: --
1295: WHEN others THEN
1296: wsh_util_core.default_handler('WSH_RLM_INTERFACE.Get_In_Transit_Qty');
1299: --
1300: -- Debug Statements
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1305: END IF;
1306: --
1307: END Get_In_Transit_Qty;
1300: -- Debug Statements
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1305: END IF;
1306: --
1307: END Get_In_Transit_Qty;
1308: