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 964: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

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

Line 965: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

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

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

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,

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

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

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(

Line 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:

Line 1174: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

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

Line 1175: l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

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:

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

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(

Line 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

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

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,

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