DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_XC_UTIL

Line 330: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;

326: l_is_action_not_performed BOOLEAN := TRUE;
327: --Bug#: 2867209 - End
328:
329: -- Exceptions Project
330: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;
331: l_exp_logged BOOLEAN := FALSE;
332: check_exceptions EXCEPTION;
333: l_msg_count NUMBER;
334: l_msg_summary VARCHAR2(4000);

Line 412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

408:
409: -- Check for Exceptions against Trip and its contents, only if trip is being set to In-Transit or Closed
410: IF p_intransit_flag = 'Y' OR p_close_flag = 'Y' THEN
411: IF l_debug_on THEN
412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
413: END IF;
414: l_exceptions_tab.delete;
415: l_exp_logged := FALSE;
416: WSH_XC_UTIL.Check_Exceptions (

Line 416: WSH_XC_UTIL.Check_Exceptions (

412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
413: END IF;
414: l_exceptions_tab.delete;
415: l_exp_logged := FALSE;
416: WSH_XC_UTIL.Check_Exceptions (
417: p_api_version => 1.0,
418: x_return_status => l_return_status,
419: x_msg_count => l_msg_count,
420: x_msg_data => l_msg_data,

Line 576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

572: CLOSE c_trip_status;
573:
574: IF l_trip_status = 'CL' THEN
575: IF l_debug_on THEN
576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
577: END IF;
578: WSH_XC_UTIL.Close_Exceptions (
579: p_api_version => 1.0,
580: x_return_status => l_return_status,

Line 578: WSH_XC_UTIL.Close_Exceptions (

574: IF l_trip_status = 'CL' THEN
575: IF l_debug_on THEN
576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
577: END IF;
578: WSH_XC_UTIL.Close_Exceptions (
579: p_api_version => 1.0,
580: x_return_status => l_return_status,
581: x_msg_count => l_msg_count,
582: x_msg_data => l_msg_data,

Line 927: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;

923: l_return_status VARCHAR2(30);
924: l_num_warn NUMBER := 0;
925:
926: -- Exceptions Project
927: l_exceptions_tab wsh_xc_util.XC_TAB_TYPE;
928: l_exp_logged BOOLEAN := FALSE;
929: check_exceptions EXCEPTION;
930: l_msg_count NUMBER;
931: l_msg_data VARCHAR2(4000);

Line 972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

968:
969: -- Check for Exceptions if p_status_code = 'CL' or 'IT'
970: IF p_status_code IN ('IT','CL') THEN
971: IF l_debug_on THEN
972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
973: END IF;
974: l_exceptions_tab.delete;
975: l_exp_logged := FALSE;
976: WSH_XC_UTIL.Check_Exceptions (

Line 976: WSH_XC_UTIL.Check_Exceptions (

972: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
973: END IF;
974: l_exceptions_tab.delete;
975: l_exp_logged := FALSE;
976: WSH_XC_UTIL.Check_Exceptions (
977: p_api_version => 1.0,
978: x_return_status => l_return_status,
979: x_msg_count => l_msg_count,
980: x_msg_data => l_msg_data,

Line 1111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

1107:
1108: -- Close Exceptions for the Trip and its contents
1109: IF p_status_code IN ('IT','CL') THEN
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1112: END IF;
1113: WSH_XC_UTIL.Close_Exceptions (
1114: p_api_version => 1.0,
1115: x_return_status => l_return_status,

Line 1113: WSH_XC_UTIL.Close_Exceptions (

1109: IF p_status_code IN ('IT','CL') THEN
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1112: END IF;
1113: WSH_XC_UTIL.Close_Exceptions (
1114: p_api_version => 1.0,
1115: x_return_status => l_return_status,
1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data,

Line 1420: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

1416: --
1417: -- Close Exceptions for the Trip and its contents, if new status = 'CL' or 'IT'
1418: IF p_in_rec.new_status_code IN ('IT','CL') THEN
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1421: END IF;
1422: WSH_XC_UTIL.Close_Exceptions (
1423: p_api_version => 1.0,
1424: x_return_status => l_return_status,

Line 1422: WSH_XC_UTIL.Close_Exceptions (

1418: IF p_in_rec.new_status_code IN ('IT','CL') THEN
1419: IF l_debug_on THEN
1420: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Close_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
1421: END IF;
1422: WSH_XC_UTIL.Close_Exceptions (
1423: p_api_version => 1.0,
1424: x_return_status => l_return_status,
1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data,