DBA Data[Home] [Help]

APPS.WSH_INTERFACE_MESSAGE_PKG dependencies on WSH_DEBUG_SV

Line 46: l_debug_on := wsh_debug_sv.is_debug_enabled;

42: x_return_status := wsh_util_core.G_RET_STS_SUCCESS;
43: l_debug_on := wsh_debug_interface.g_debug;
44: --
45: IF l_debug_on IS NULL THEN
46: l_debug_on := wsh_debug_sv.is_debug_enabled;
47: END IF;
48: --
49: IF l_debug_on THEN
50: wsh_debug_sv.push(l_module_name);

Line 50: wsh_debug_sv.push(l_module_name);

46: l_debug_on := wsh_debug_sv.is_debug_enabled;
47: END IF;
48: --
49: IF l_debug_on THEN
50: wsh_debug_sv.push(l_module_name);
51: END IF;
52: --
53: IF p_delivery_interface_id IS NOT NULL THEN
54:

Line 74: wsh_debug_sv.log(l_module_name,'Record does not exists for the Delivery Interface ID ',p_delivery_interface_id);

70: --
71: IF p_delivery_interface_id IS NOT NULL THEN
72: --
73: IF l_debug_on THEN
74: wsh_debug_sv.log(l_module_name,'Record does not exists for the Delivery Interface ID ',p_delivery_interface_id);
75: END IF;
76: --
77: ELSIF p_delivery_detail_interface_id IS NOT NULL THEN
78: --

Line 80: wsh_debug_sv.log(l_module_name,'Record does not exists for the Delivery Detail Interface ID',p_delivery_detail_interface_id);

76: --
77: ELSIF p_delivery_detail_interface_id IS NOT NULL THEN
78: --
79: IF l_debug_on THEN
80: wsh_debug_sv.log(l_module_name,'Record does not exists for the Delivery Detail Interface ID',p_delivery_detail_interface_id);
81: END IF;
82: --
83: END IF;
84: --

Line 86: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);

82: --
83: END IF;
84: --
85: IF l_debug_on THEN
86: wsh_debug_sv.log(l_module_name,'Value of L_ID = ',l_id);
87: END IF;
88: --
89: END IF;
90: --

Line 92: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

88: --
89: END IF;
90: --
91: IF l_debug_on THEN
92: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);
93: wsh_debug_sv.pop(l_module_name);
94: END IF;
95: --
96: EXCEPTION

Line 93: wsh_debug_sv.pop(l_module_name);

89: END IF;
90: --
91: IF l_debug_on THEN
92: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);
93: wsh_debug_sv.pop(l_module_name);
94: END IF;
95: --
96: EXCEPTION
97:

Line 105: wsh_debug_sv.log(l_module_name,'Delivery Interface ID is locked by another user',p_delivery_interface_id);

101: --
102: IF l_debug_on THEN
103: --
104: IF p_delivery_interface_id IS NOT NULL THEN
105: wsh_debug_sv.log(l_module_name,'Delivery Interface ID is locked by another user',p_delivery_interface_id);
106: ELSIF p_delivery_detail_interface_id IS NOT NULL THEN
107: wsh_debug_sv.log(l_module_name,'Delivery Detail Interface ID is Locked by another user',p_delivery_detail_interface_id);
108: END IF;
109: --

Line 107: wsh_debug_sv.log(l_module_name,'Delivery Detail Interface ID is Locked by another user',p_delivery_detail_interface_id);

103: --
104: IF p_delivery_interface_id IS NOT NULL THEN
105: wsh_debug_sv.log(l_module_name,'Delivery Interface ID is locked by another user',p_delivery_interface_id);
106: ELSIF p_delivery_detail_interface_id IS NOT NULL THEN
107: wsh_debug_sv.log(l_module_name,'Delivery Detail Interface ID is Locked by another user',p_delivery_detail_interface_id);
108: END IF;
109: --
110: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
111: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

Line 110: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );

106: ELSIF p_delivery_detail_interface_id IS NOT NULL THEN
107: wsh_debug_sv.log(l_module_name,'Delivery Detail Interface ID is Locked by another user',p_delivery_detail_interface_id);
108: END IF;
109: --
110: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
111: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);
112: wsh_debug_sv.pop(l_module_name);
113: END IF;
114: --

Line 111: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);

107: wsh_debug_sv.log(l_module_name,'Delivery Detail Interface ID is Locked by another user',p_delivery_detail_interface_id);
108: END IF;
109: --
110: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
111: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);
112: wsh_debug_sv.pop(l_module_name);
113: END IF;
114: --
115: WHEN OTHERS THEN

Line 112: wsh_debug_sv.pop(l_module_name);

108: END IF;
109: --
110: wsh_debug_sv.log(l_module_name,'SQLERRM = ', SQLERRM );
111: wsh_debug_sv.log(l_module_name,'x_return_status ',x_return_status);
112: wsh_debug_sv.pop(l_module_name);
113: END IF;
114: --
115: WHEN OTHERS THEN
116: x_return_status := wsh_util_core.g_ret_sts_error;

Line 119: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);

115: WHEN OTHERS THEN
116: x_return_status := wsh_util_core.g_ret_sts_error;
117: --
118: IF l_debug_on THEN
119: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
120: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
121: wsh_debug_sv.pop(l_module_name);
122: END IF;
123: --

Line 120: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);

116: x_return_status := wsh_util_core.g_ret_sts_error;
117: --
118: IF l_debug_on THEN
119: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
120: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
121: wsh_debug_sv.pop(l_module_name);
122: END IF;
123: --
124:

Line 121: wsh_debug_sv.pop(l_module_name);

117: --
118: IF l_debug_on THEN
119: wsh_debug_sv.log(l_module_name,'SQLERRM : ',sqlerrm);
120: wsh_debug_sv.log(l_module_name,'x_return_status : ',x_return_status);
121: wsh_debug_sv.pop(l_module_name);
122: END IF;
123: --
124:
125: End lock_record;