388: x_process_started OUT NOCOPY VARCHAR2,
389: x_return_status OUT NOCOPY VARCHAR2) IS
390:
391:
392: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
393: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
394:
395: l_itemtype VARCHAR2(30);
396: l_itemkey VARCHAR2(30);
389: x_return_status OUT NOCOPY VARCHAR2) IS
390:
391:
392: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
393: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
394:
395: l_itemtype VARCHAR2(30);
396: l_itemkey VARCHAR2(30);
397:
493: RETURN;
494: ELSE
495:
496: IF l_debug_on THEN
497: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
498: WSH_DEBUG_SV.C_PROC_LEVEL);
499: END IF;
500:
501: WSH_SHIPPING_PARAMS_PVT.Get(
497: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
498: WSH_DEBUG_SV.C_PROC_LEVEL);
499: END IF;
500:
501: WSH_SHIPPING_PARAMS_PVT.Get(
502: p_organization_id => p_organization_id,
503: x_param_info => l_param_info,
504: x_return_status => l_return_status);
505: IF l_debug_on THEN
514: RETURN;
515: END IF;
516:
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
519: WSH_DEBUG_SV.C_PROC_LEVEL);
520: END IF;
521:
522: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
519: WSH_DEBUG_SV.C_PROC_LEVEL);
520: END IF;
521:
522: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
523: x_return_status => l_return_status);
524:
525: IF l_debug_on THEN
526: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
667: CURSOR get_ship_dir_control IS
668: SELECT shipment_direction,shipping_control
669: FROM WSH_NEW_DELIVERIES WHERE delivery_id=p_entity_id;
670:
671: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
672:
673: CURSOR get_org_code IS
674: SELECT organization_code
675: FROM MTL_PARAMETERS
768:
769: -- CHECK IF EXPORT SCREENING REQUIRED
770: /*SR
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET', WSH_DEBUG_SV.C_PROC_LEVEL);
773: END IF;
774:
775: WSH_SHIPPING_PARAMS_PVT.Get(
776: p_organization_id => p_organization_id,
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET', WSH_DEBUG_SV.C_PROC_LEVEL);
773: END IF;
774:
775: WSH_SHIPPING_PARAMS_PVT.Get(
776: p_organization_id => p_organization_id,
777: x_param_info => l_param_info,
778: x_return_status => l_return_status);
779: IF l_debug_on THEN
960: p_organization_id IN NUMBER DEFAULT NULL,
961: x_return_status OUT NOCOPY VARCHAR2) IS
962:
963:
964: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
965: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
966: l_parameters WF_PARAMETER_LIST_T;
967: l_raise_event BOOLEAN;
968: l_wf_process_exists VARCHAR2(1);
961: x_return_status OUT NOCOPY VARCHAR2) IS
962:
963:
964: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
965: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
966: l_parameters WF_PARAMETER_LIST_T;
967: l_raise_event BOOLEAN;
968: l_wf_process_exists VARCHAR2(1);
969: l_return_status VARCHAR2(1);
1034:
1035: -- Get Global event parameters and raise event accordingly
1036: IF ( NOT l_raise_event) THEN
1037: IF l_debug_on THEN
1038: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1039: WSH_DEBUG_SV.C_PROC_LEVEL);
1040: END IF;
1041:
1042: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1038: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1039: WSH_DEBUG_SV.C_PROC_LEVEL);
1040: END IF;
1041:
1042: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1043: x_return_status => l_return_status);
1044:
1045: IF l_debug_on THEN
1046: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1062:
1063: -- Get Shipping event parameters and raise event accordingly
1064: IF ( NOT l_raise_event AND p_organization_id is not null) THEN
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1067: WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069:
1070: WSH_SHIPPING_PARAMS_PVT.Get(
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1067: WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069:
1070: WSH_SHIPPING_PARAMS_PVT.Get(
1071: p_organization_id => p_organization_id,
1072: x_param_info => l_param_info,
1073: x_return_status => l_return_status);
1074:
1170: p_organization_id IN NUMBER,
1171: x_start_wf_process OUT NOCOPY VARCHAR2,
1172: x_return_status OUT NOCOPY VARCHAR2) IS
1173:
1174: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1175: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
1176:
1177: l_global_enable_tracking_wfs VARCHAR2(30);
1178: l_shipping_enable_tracking_wfs VARCHAR2(30);
1171: x_start_wf_process OUT NOCOPY VARCHAR2,
1172: x_return_status OUT NOCOPY VARCHAR2) IS
1173:
1174: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1175: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
1176:
1177: l_global_enable_tracking_wfs VARCHAR2(30);
1178: l_shipping_enable_tracking_wfs VARCHAR2(30);
1179:
1207:
1208: IF (p_entity_type <> 'TRIP') THEN
1209:
1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1212: WSH_DEBUG_SV.C_PROC_LEVEL);
1213: END IF;
1214:
1215: WSH_SHIPPING_PARAMS_PVT.Get(
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1212: WSH_DEBUG_SV.C_PROC_LEVEL);
1213: END IF;
1214:
1215: WSH_SHIPPING_PARAMS_PVT.Get(
1216: p_organization_id => p_organization_id,
1217: x_param_info => l_param_info,
1218: x_return_status => l_return_status);
1219: IF l_debug_on THEN
1231: END IF;
1232: END IF;
1233:
1234: IF l_debug_on THEN
1235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1236: WSH_DEBUG_SV.C_PROC_LEVEL);
1237: END IF;
1238:
1239: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1236: WSH_DEBUG_SV.C_PROC_LEVEL);
1237: END IF;
1238:
1239: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1240: x_return_status => l_return_status);
1241:
1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);