DBA Data[Home] [Help]

APPS.WSH_WF_STD dependencies on WSH_SHIPPING_PARAMS_PVT

Line 392: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

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);

Line 393: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

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:

Line 497: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',

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(

Line 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

Line 518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',

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,

Line 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);

Line 671: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

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

Line 772: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET', WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 775: WSH_SHIPPING_PARAMS_PVT.Get(

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

Line 970: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

966: p_organization_id IN NUMBER DEFAULT NULL,
967: x_return_status OUT NOCOPY VARCHAR2) IS
968:
969:
970: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
971: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
972: l_parameters WF_PARAMETER_LIST_T;
973: l_raise_event BOOLEAN;
974: l_wf_process_exists VARCHAR2(1);

Line 971: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

967: x_return_status OUT NOCOPY VARCHAR2) IS
968:
969:
970: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
971: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
972: l_parameters WF_PARAMETER_LIST_T;
973: l_raise_event BOOLEAN;
974: l_wf_process_exists VARCHAR2(1);
975: l_return_status VARCHAR2(1);

Line 1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',

1040:
1041: -- Get Global event parameters and raise event accordingly
1042: IF ( NOT l_raise_event) THEN
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1045: WSH_DEBUG_SV.C_PROC_LEVEL);
1046: END IF;
1047:
1048: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,

Line 1048: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,

1044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1045: WSH_DEBUG_SV.C_PROC_LEVEL);
1046: END IF;
1047:
1048: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1049: x_return_status => l_return_status);
1050:
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 1072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',

1068:
1069: -- Get Shipping event parameters and raise event accordingly
1070: IF ( NOT l_raise_event AND p_organization_id is not null) THEN
1071: IF l_debug_on THEN
1072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1073: WSH_DEBUG_SV.C_PROC_LEVEL);
1074: END IF;
1075:
1076: WSH_SHIPPING_PARAMS_PVT.Get(

Line 1076: WSH_SHIPPING_PARAMS_PVT.Get(

1072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1073: WSH_DEBUG_SV.C_PROC_LEVEL);
1074: END IF;
1075:
1076: WSH_SHIPPING_PARAMS_PVT.Get(
1077: p_organization_id => p_organization_id,
1078: x_param_info => l_param_info,
1079: x_return_status => l_return_status);
1080:

Line 1180: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

1176: p_organization_id IN NUMBER,
1177: x_start_wf_process OUT NOCOPY VARCHAR2,
1178: x_return_status OUT NOCOPY VARCHAR2) IS
1179:
1180: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1181: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
1182:
1183: l_global_enable_tracking_wfs VARCHAR2(30);
1184: l_shipping_enable_tracking_wfs VARCHAR2(30);

Line 1181: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

1177: x_start_wf_process OUT NOCOPY VARCHAR2,
1178: x_return_status OUT NOCOPY VARCHAR2) IS
1179:
1180: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1181: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
1182:
1183: l_global_enable_tracking_wfs VARCHAR2(30);
1184: l_shipping_enable_tracking_wfs VARCHAR2(30);
1185:

Line 1217: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',

1213:
1214: IF (p_entity_type <> 'TRIP') THEN
1215:
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1218: WSH_DEBUG_SV.C_PROC_LEVEL);
1219: END IF;
1220:
1221: WSH_SHIPPING_PARAMS_PVT.Get(

Line 1221: WSH_SHIPPING_PARAMS_PVT.Get(

1217: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1218: WSH_DEBUG_SV.C_PROC_LEVEL);
1219: END IF;
1220:
1221: WSH_SHIPPING_PARAMS_PVT.Get(
1222: p_organization_id => p_organization_id,
1223: x_param_info => l_param_info,
1224: x_return_status => l_return_status);
1225: IF l_debug_on THEN

Line 1241: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',

1237: END IF;
1238: END IF;
1239:
1240: IF l_debug_on THEN
1241: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1242: WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244:
1245: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,

Line 1245: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,

1241: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',
1242: WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244:
1245: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_parameters,
1246: x_return_status => l_return_status);
1247:
1248: IF l_debug_on THEN
1249: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);