DBA Data[Home] [Help]

APPS.WSH_CARRIERS_GRP dependencies on WSH_CREATE_CARRIERS_PKG

Line 77: l_Carrier_Info WSH_CREATE_CARRIERS_PKG.CARecType;

73:
74: l_input_param_flag BOOLEAN := TRUE;
75: l_param_name VARCHAR2(100);
76:
77: l_Carrier_Info WSH_CREATE_CARRIERS_PKG.CARecType;
78: l_carrier_id NUMBER := 0;
79: l_rowid VARCHAR2(4000);
80:
81: --- Bug 3392826 Start: Validation

Line 330: WSH_CREATE_CARRIERS_PKG.CREATE_CARRIERINFO

326:
327: END IF;
328: --- Bug 3392826 End
329:
330: WSH_CREATE_CARRIERS_PKG.CREATE_CARRIERINFO
331: (
332: P_CARRIER_INFO => l_Carrier_Info,
333: P_COMMIT => p_commit,
334: X_ROWID => l_rowid,

Line 351: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.CREATE_CARRIERINFO',l_return_status);

347: x_num_warnings =>l_num_warnings,
348: x_num_errors =>l_num_errors
349: );
350: IF l_debug_on THEN
351: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.CREATE_CARRIERINFO',l_return_status);
352: END IF;
353:
354: ELSIF p_action_code = 'UPDATE' OR l_action_code = 'UPDATE' THEN
355:

Line 395: WSH_CREATE_CARRIERS_PKG.CARRIER_DEACTIVATE

391:
392: -- If carrier is deactivated,
393: -- deactivate Services and Organization Assignments.
394: IF p_status = 'I' THEN
395: WSH_CREATE_CARRIERS_PKG.CARRIER_DEACTIVATE
396: (
397: p_carrier_id => l_carrier_id,
398: X_RETURN_STATUS => l_return_status,
399: X_EXCEPTION_MSG => l_exception_msg,

Line 415: WSH_CREATE_CARRIERS_PKG.UPDATE_CARRIERINFO

411: x_num_errors =>l_num_errors
412: );
413:
414:
415: WSH_CREATE_CARRIERS_PKG.UPDATE_CARRIERINFO
416: (
417: P_CARRIER_INFO => l_Carrier_Info,
418: P_COMMIT => p_commit,
419: X_RETURN_STATUS => l_return_status,

Line 428: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.UPDATE_CARRIERINFO',l_return_status);

424: X_SQL_CODE => l_sql_code
425: );
426:
427: IF l_debug_on THEN
428: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.UPDATE_CARRIERINFO',l_return_status);
429: END IF;
430:
431: END IF;
432: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 818: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Create_Carrier_Service',l_return_status);

814: X_SQLERR => l_sqlerr,
815: X_SQL_CODE => l_sql_code
816: );
817: IF l_debug_on THEN
818: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Create_Carrier_Service',l_return_status);
819: END IF;
820:
821: ELSIF p_action_code = 'UPDATE' OR l_action_code = 'UPDATE' THEN
822:

Line 858: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Update_Carrier_Service',l_return_status);

854: );
855: END IF;
856:
857: IF l_debug_on THEN
858: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Update_Carrier_Service',l_return_status);
859: END IF;
860:
861: END IF;
862: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 1187: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.assign_org_carrier_service',l_return_status);

1183: X_SQL_CODE => l_sql_code,
1184: x_exception_msg => l_exception_msg
1185: );
1186: IF l_debug_on THEN
1187: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.assign_org_carrier_service',l_return_status);
1188: END IF;
1189: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1190: x_num_warnings =>l_num_warnings,
1191: x_num_errors =>l_num_errors

Line 1421: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Assign_Org_Carrier_Service',l_return_status);

1417: x_msg_count => x_msg_count,
1418: x_msg_data => x_msg_data
1419: );
1420: IF l_debug_on THEN
1421: wsh_debug_sv.log(l_module_name,'return status WSH_CREATE_CARRIERS_PKG.Assign_Org_Carrier_Service',l_return_status);
1422: END IF;
1423: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1424: x_num_warnings =>l_num_warnings,
1425: x_num_errors =>l_num_errors