DBA Data[Home] [Help]

APPS.WSH_FACILITIES_INTEGRATION dependencies on WSH_DEBUG_SV

Line 60: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

56:
57: --
58: -- Variables used for debugging
59: --
60: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
61: --
62: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Facilities';
63:
64: BEGIN

Line 66: WSH_DEBUG_SV.push(l_module_name);

62: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Facilities';
63:
64: BEGIN
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.push(l_module_name);
67: END IF;
68:
69: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' THEN
70: FTE_LOCATION_PARAMETERS_PKG.Create_Facilities( p_location_ids => p_location_ids,

Line 78: WSH_DEBUG_SV.pop(l_module_name);

74: x_error_msg => x_error_msg);
75: END IF;
76:
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.pop(l_module_name);
79: END IF;
80:
81: EXCEPTION
82: WHEN OTHERS THEN

Line 85: WSH_DEBUG_SV.logmsg(l_module_name,

81: EXCEPTION
82: WHEN OTHERS THEN
83: x_error_msg := SQLERRM;
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.logmsg(l_module_name,
86: 'UNEXP. ERROR IN WSH_FACILITIES_INTEGRATION.Create_Facilities: '|| x_error_msg);
87: WSH_DEBUG_SV.logmsg(l_module_name,
88: 'Error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
89: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 87: WSH_DEBUG_SV.logmsg(l_module_name,

83: x_error_msg := SQLERRM;
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.logmsg(l_module_name,
86: 'UNEXP. ERROR IN WSH_FACILITIES_INTEGRATION.Create_Facilities: '|| x_error_msg);
87: WSH_DEBUG_SV.logmsg(l_module_name,
88: 'Error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
89: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
90: END IF;
91: --

Line 88: 'Error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

84: IF l_debug_on THEN
85: WSH_DEBUG_SV.logmsg(l_module_name,
86: 'UNEXP. ERROR IN WSH_FACILITIES_INTEGRATION.Create_Facilities: '|| x_error_msg);
87: WSH_DEBUG_SV.logmsg(l_module_name,
88: 'Error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
89: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
90: END IF;
91: --
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 89: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

85: WSH_DEBUG_SV.logmsg(l_module_name,
86: 'UNEXP. ERROR IN WSH_FACILITIES_INTEGRATION.Create_Facilities: '|| x_error_msg);
87: WSH_DEBUG_SV.logmsg(l_module_name,
88: 'Error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
89: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
90: END IF;
91: --
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
93:

Line 95: WSH_DEBUG_SV.pop(l_module_name);

91: --
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
93:
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.pop(l_module_name);
96: END IF;
97: END Create_Facilities;
98: ------------------------------------------------------------------
99: