278:
279: FOR i in l_org_info_tab.FIRST..l_org_info_tab.LAST LOOP
280: --{
281: IF l_debug_on THEN
282: wsh_debug_sv.logmsg(l_module_name,'Calling wsh_util_validate.validate_org',WSH_DEBUG_SV.C_PROC_LEVEL);
283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);
284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);
285: END IF;
286:
283: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_id',l_org_info_tab(i).org_id);
284: wsh_debug_sv.log(l_module_name,'l_org_info_tab('||i||').org_code',l_org_info_tab(i).org_code);
285: END IF;
286:
287: WSH_UTIL_VALIDATE.validate_org(
288: p_org_id => l_org_info_tab(i).org_id, --Out param
289: p_org_code => l_org_info_tab(i).org_code,
290: x_return_status => l_return_status );
291:
289: p_org_code => l_org_info_tab(i).org_code,
290: x_return_status => l_return_status );
291:
292: IF l_debug_on THEN
293: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_org',l_return_status);
294: END IF;
295:
296: WSH_UTIL_CORE.api_post_call(
297: p_return_status => l_return_status,
326: ELSIF ((l_ship_method_code IS NOT NULL ) OR (l_ship_method IS NOT NULL )) THEN
327: --{
328:
329: IF l_debug_on THEN
330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_validate.validate_ship_method',WSH_DEBUG_SV.C_PROC_LEVEL);
331: END IF;
332:
333: WSH_UTIL_VALIDATE.validate_ship_method(
334: p_ship_method_code => l_ship_method_code, --Out param
329: IF l_debug_on THEN
330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_validate.validate_ship_method',WSH_DEBUG_SV.C_PROC_LEVEL);
331: END IF;
332:
333: WSH_UTIL_VALIDATE.validate_ship_method(
334: p_ship_method_code => l_ship_method_code, --Out param
335: p_ship_method_name => l_ship_method, --Out param
336: x_return_status => l_return_status);
337:
335: p_ship_method_name => l_ship_method, --Out param
336: x_return_status => l_return_status);
337:
338: IF l_debug_on THEN
339: wsh_debug_sv.log(l_module_name,'Return Status After Calling wsh_util_validate.validate_ship_method',l_return_status);
340: END IF;
341:
342: WSH_UTIL_CORE.api_post_call(
343: p_return_status => l_return_status,
367: --Carrier validation
368: ELSIF ((l_carrier_id IS NOT NULL ) OR (l_freight_code IS NOT NULL)) THEN
369: --{
370: IF l_debug_on THEN
371: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',WSH_DEBUG_SV.C_PROC_LEVEL);
372: END IF;
373:
374: WSH_UTIL_VALIDATE.Validate_Freight_Code(
375: x_Carrier_id => l_carrier_id, --out param
370: IF l_debug_on THEN
371: wsh_debug_sv.logmsg(l_module_name,'Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',WSH_DEBUG_SV.C_PROC_LEVEL);
372: END IF;
373:
374: WSH_UTIL_VALIDATE.Validate_Freight_Code(
375: x_Carrier_id => l_carrier_id, --out param
376: p_freight_code => l_freight_code,
377: x_return_status => l_return_status);
378:
376: p_freight_code => l_freight_code,
377: x_return_status => l_return_status);
378:
379: IF l_debug_on THEN
380: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_UTIL_VALIDATE.Validate_Freight_Code',l_return_status);
381: END IF;
382:
383: WSH_UTIL_CORE.api_post_call(
384: p_return_status => l_return_status,