eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WMS_LPN_GRP dependencies on WSH_DEBUG_SV

Line 88: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

84: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
85: --
86: IF l_debug_on IS NULL
87: THEN
88: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
89: END IF;
90: --
91: IF l_debug_on THEN
92: --

Line 93: wsh_debug_sv.push (l_module_name);

89: END IF;
90: --
91: IF l_debug_on THEN
92: --
93: wsh_debug_sv.push (l_module_name);
94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);
95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',

Line 94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);

90: --
91: IF l_debug_on THEN
92: --
93: wsh_debug_sv.push (l_module_name);
94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);
95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);

Line 95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);

91: IF l_debug_on THEN
92: --
93: wsh_debug_sv.push (l_module_name);
94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);
95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);

Line 96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);

92: --
93: wsh_debug_sv.push (l_module_name);
94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);
95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);

Line 97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',

93: wsh_debug_sv.push (l_module_name);
94: wsh_debug_sv.log (l_module_name,'p_api_version',p_api_version);
95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);
101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);

Line 99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);

95: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);
101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);
102: wsh_debug_sv.log (l_module_name,'g_update_to_containers',g_update_to_containers);
103: --

Line 100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);

96: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);
101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);
102: wsh_debug_sv.log (l_module_name,'g_update_to_containers',g_update_to_containers);
103: --
104: END IF;

Line 101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);

97: wsh_debug_sv.log (l_module_name,'p_detail_info_tab.count',
98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);
101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);
102: wsh_debug_sv.log (l_module_name,'g_update_to_containers',g_update_to_containers);
103: --
104: END IF;
105: --

Line 102: wsh_debug_sv.log (l_module_name,'g_update_to_containers',g_update_to_containers);

98: p_detail_info_tab.count);
99: wsh_debug_sv.log (l_module_name,'caller',p_IN_rec.caller);
100: wsh_debug_sv.log (l_module_name,'action_code',p_IN_rec.action_code);
101: wsh_debug_sv.log (l_module_name,'g_call_group_api',g_call_group_api);
102: wsh_debug_sv.log (l_module_name,'g_update_to_containers',g_update_to_containers);
103: --
104: END IF;
105: --
106: IF NOT FND_API.Compatible_API_Call

Line 141: wsh_debug_sv.log(l_module_name,'Invalid Caller',p_IN_rec.caller);

137: --
138: IF p_IN_rec.caller not like 'WMS%' THEN
139: IF l_debug_on THEN
140: --
141: wsh_debug_sv.log(l_module_name,'Invalid Caller',p_IN_rec.caller);
142: END IF;
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:

Line 158: wsh_debug_sv.log(l_module_name,'lpn_id',

154: IF p_in_rec.action_code = 'UPDATE_NULL' THEN --{
155: i := p_detail_info_tab.FIRST;
156: WHILE i IS NOT NULL LOOP --{
157: IF l_debug_on THEN
158: wsh_debug_sv.log(l_module_name,'lpn_id',
159: p_detail_info_tab(i).lpn_id);
160: END IF;
161:
162: --lock the record

Line 197: wsh_debug_sv.log(l_module_name,'lpn_id',

193: IF p_in_rec.action_code = 'UPDATE' THEN --{
194: i := p_detail_info_tab.FIRST;
195: WHILE i IS NOT NULL LOOP --{
196: IF l_debug_on THEN
197: wsh_debug_sv.log(l_module_name,'lpn_id',
198: p_detail_info_tab(i).lpn_id);
199: END IF;
200: IF p_detail_info_tab(i).lpn_id IS NULL THEN
201: IF l_debug_on THEN

Line 202: wsh_debug_sv.logmsg(l_module_name,'lpn_id cannot be null');

198: p_detail_info_tab(i).lpn_id);
199: END IF;
200: IF p_detail_info_tab(i).lpn_id IS NULL THEN
201: IF l_debug_on THEN
202: wsh_debug_sv.logmsg(l_module_name,'lpn_id cannot be null');
203: END IF;
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
206: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 223: wsh_debug_sv.log(l_module_name,'There are no records in wsh_delivery_details for lpn_id: ', p_detail_info_tab(i).lpn_id);

219:
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: IF l_debug_on THEN
223: wsh_debug_sv.log(l_module_name,'There are no records in wsh_delivery_details for lpn_id: ', p_detail_info_tab(i).lpn_id);
224: END IF;
225:
226: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DETAIL'); --bmso new message
227: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);

231:
232: --handle_miss_info is not used, when wsh_container_grp.update_container calls this API.
233:
234: IF l_debug_on THEN
235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);

Line 236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);

232: --handle_miss_info is not used, when wsh_container_grp.update_container calls this API.
233:
234: IF l_debug_on THEN
235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);

Line 237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);

233:
234: IF l_debug_on THEN
235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);

Line 238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);

234: IF l_debug_on THEN
235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
242: END IF;

Line 239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);

235: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
242: END IF;
243:

Line 240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);

236: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
242: END IF;
243:
244: handle_miss_info( p_container_info_rec => p_detail_info_tab(i),

Line 241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);

237: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
238: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
239: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
240: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
241: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
242: END IF;
243:
244: handle_miss_info( p_container_info_rec => p_detail_info_tab(i),
245: x_return_status => l_return_status

Line 263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);

259: i:= p_detail_info_tab.FIRST;
260: WHILE i IS NOT NULL LOOP --{
261:
262: IF l_debug_on THEN
263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);

Line 264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);

260: WHILE i IS NOT NULL LOOP --{
261:
262: IF l_debug_on THEN
263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);

Line 265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);

261:
262: IF l_debug_on THEN
263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);

Line 266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);

262: IF l_debug_on THEN
263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
270: END IF;

Line 267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);

263: wsh_debug_sv.log(l_module_name,'lpn_id',p_detail_info_tab(i).lpn_id);
264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
270: END IF;
271:

Line 268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);

264: wsh_debug_sv.log(l_module_name,'net_weight',p_detail_info_tab(i).net_weight);
265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
270: END IF;
271:
272: OPEN c_lpn_exist(p_detail_info_tab(i).lpn_id);

Line 269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);

265: wsh_debug_sv.log(l_module_name,'weight_uom_code',p_detail_info_tab(i).weight_uom_code);
266: wsh_debug_sv.log(l_module_name,'gross_weight',p_detail_info_tab(i).gross_weight);
267: wsh_debug_sv.log(l_module_name,'volume',p_detail_info_tab(i).volume);
268: wsh_debug_sv.log(l_module_name,'volume_uom_code',p_detail_info_tab(i).volume_uom_code);
269: wsh_debug_sv.log(l_module_name,'filled_volume',p_detail_info_tab(i).filled_volume);
270: END IF;
271:
272: OPEN c_lpn_exist(p_detail_info_tab(i).lpn_id);
273: FETCH c_lpn_exist INTO l_dummy;

Line 303: wsh_debug_sv.log(l_module_name,'Invalid Action Code',

299: x_num_errors => l_num_errors,
300: p_msg_data => l_msg_data);
301: ELSE --}{
302: IF l_debug_on THEN
303: wsh_debug_sv.log(l_module_name,'Invalid Action Code',
304: p_IN_rec.action_code);
305: END IF;
306: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
307: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_IN_rec.action_code);

Line 336: WSH_DEBUG_SV.pop(l_module_name);

332: p_data => x_msg_data,
333: p_encoded => FND_API.G_FALSE);
334: --
335: IF l_debug_on THEN
336: WSH_DEBUG_SV.pop(l_module_name);
337: END IF;
338: --
339: EXCEPTION
340:

Line 354: WSH_DEBUG_SV.pop(l_module_name,'Success');

350: p_encoded => FND_API.G_FALSE
351: );
352:
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.pop(l_module_name,'Success');
355: END IF;
356: --
357: WHEN FND_API.G_EXC_ERROR THEN
358: G_CALLBACK_REQUIRED := 'Y';

Line 371: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

367: p_encoded => FND_API.G_FALSE
368: );
369:
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
373: END IF;
374: --
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

368: );
369:
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
373: END IF;
374: --
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: G_CALLBACK_REQUIRED := 'Y';

Line 391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

387: );
388:
389: --
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
393: END IF;
394: --
395: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

388:
389: --
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
393: END IF;
394: --
395: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
396: G_CALLBACK_REQUIRED := 'Y';

Line 410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

406: );
407:
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
412: END IF;
413: --
414: WHEN OTHERS THEN

Line 411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

407:
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
412: END IF;
413: --
414: WHEN OTHERS THEN
415: G_CALLBACK_REQUIRED := 'Y';

Line 430: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

426: );
427:
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
432: END IF;
433: --
434:

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

427:
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
431: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
432: END IF;
433: --
434:
435: END create_update_containers;

Line 470: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

466: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
467: --
468: IF l_debug_on IS NULL
469: THEN
470: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
471: END IF;
472: --
473: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
474: IF l_debug_on THEN

Line 476: wsh_debug_sv.push (l_module_name);

472: --
473: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
474: IF l_debug_on THEN
475: --
476: wsh_debug_sv.push (l_module_name);
477: --
478: END IF;
479: --
480:

Line 679: WSH_DEBUG_SV.pop(l_module_name);

675: p_container_info_rec.po_revision_number := FND_API.G_MISS_NUM;
676: p_container_info_rec.release_revision_number := FND_API.G_MISS_NUM;
677: --
678: IF l_debug_on THEN
679: WSH_DEBUG_SV.pop(l_module_name);
680: END IF;
681: --
682: EXCEPTION
683:

Line 689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

685: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
691: END IF;
692: --
693:

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

686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
691: END IF;
692: --
693:
694: END Handle_miss_info;

Line 860: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

856: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
857: --
858: IF l_debug_on IS NULL
859: THEN
860: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
861: END IF;
862: --
863: --
864: -- Debug Statements

Line 867: WSH_DEBUG_SV.push(l_module_name);

863: --
864: -- Debug Statements
865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

865: --
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);

Line 870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

866: IF l_debug_on THEN
867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);

Line 871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

867: WSH_DEBUG_SV.push(l_module_name);
868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);

Line 872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);

868: --
869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);
876: END IF;

Line 873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);

869: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);
876: END IF;
877: --

Line 874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);

870: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);
876: END IF;
877: --
878: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);

871: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
872: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.caller',p_action_prms.caller);
873: WSH_DEBUG_SV.log(l_module_name,'p_action_prms.action_code',p_action_prms.action_code);
874: WSH_DEBUG_SV.log(l_module_name,'Count of lpn_id tbl is',p_lpn_id_tbl.count);
875: WSH_DEBUG_SV.log(l_module_name,'Count of delivery_detail_id tbl is',p_del_det_id_tbl.count);
876: END IF;
877: --
878: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
879:

Line 928: WSH_DEBUG_SV.pop(l_module_name);

924: --
925: -- Debug Statements
926: --
927: IF l_debug_on THEN
928: WSH_DEBUG_SV.pop(l_module_name);
929: END IF;
930: --
931: return;
932: END IF;

Line 958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

954: --
955: -- Debug Statements
956: --
957: IF l_debug_on THEN
958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
959: END IF;
960: --
961: wsh_delivery_details_grp.create_update_delivery_detail(
962: p_api_version_number => p_api_version_number,

Line 976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

972: --
973: -- Debug Statements
974: --
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
977: END IF;
978: --
979: wsh_util_core.api_post_call(
980: p_return_status => l_return_status,

Line 1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1142: --
1143: -- Debug Statements
1144: --
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149: wsh_delivery_details_grp.Delivery_Detail_Action(
1150: p_api_version_number => p_api_version_number,

Line 1166: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1162: --
1163: -- Debug Statements
1164: --
1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1167: END IF;
1168: --
1169: wsh_util_core.api_post_call(
1170: p_return_status => l_return_status,

Line 1191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1187: --
1188: -- Debug Statements
1189: --
1190: IF l_debug_on THEN
1191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1192: END IF;
1193: --
1194: wsh_delivery_details_grp.create_update_delivery_detail(
1195: p_api_version_number => p_api_version_number,

Line 1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1207: --
1208: -- Debug Statements
1209: --
1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1212: END IF;
1213: --
1214: wsh_util_core.api_post_call(
1215: p_return_status => l_return_status,

Line 1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CHILD_INV_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1228: --
1229: -- Debug Statements
1230: --
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CHILD_INV_INFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234: --
1235: WSH_CONTAINER_ACTIONS.Update_child_inv_info(
1236: p_container_id => l_exist_detail_id,

Line 1247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1243: --
1244: -- Debug Statements
1245: --
1246: IF l_debug_on THEN
1247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1248: END IF;
1249: --
1250: wsh_util_core.api_post_call(
1251: p_return_status => l_return_status,

Line 1269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CALC_CONT_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);

1265: --
1266: -- Debug Statements
1267: --
1268: IF l_debug_on THEN
1269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TPA_CONTAINER_PKG.CALC_CONT_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);
1270: END IF;
1271: --
1272: WSH_TPA_CONTAINER_PKG.Calc_Cont_Fill_Pc (
1273: l_exist_detail_id,

Line 1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1281: --
1282: -- Debug Statements
1283: --
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,

Line 1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CHECK_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);

1300: --
1301: -- Debug Statements
1302: --
1303: IF l_debug_on THEN
1304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CHECK_FILL_PC',WSH_DEBUG_SV.C_PROC_LEVEL);
1305: END IF;
1306: --
1307: WSH_WV_UTILS.Check_Fill_Pc (
1308: p_container_instance_id => l_exist_detail_id,

Line 1317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1313: --
1314: -- Debug Statements
1315: --
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1318: END IF;
1319: --
1320: wsh_util_core.api_post_call(
1321: p_return_status => l_return_status,

Line 1355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1351: --
1352: -- Debug Statements
1353: --
1354: IF l_debug_on THEN
1355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1356: END IF;
1357: --
1358: wsh_container_actions.delete_containers (
1359: p_container_id => l_del_det_id_tbl(l_index),

Line 1366: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1362: --
1363: -- Debug Statements
1364: --
1365: IF l_debug_on THEN
1366: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1367: END IF;
1368: --
1369: wsh_util_core.api_post_call(
1370: p_return_status => l_return_status,

Line 1387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1383: --
1384: -- Debug Statements
1385: --
1386: IF l_debug_on THEN
1387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389: --
1390: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1391: (

Line 1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1397: --
1398: -- Debug Statements
1399: --
1400: IF l_debug_on THEN
1401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1402: END IF;
1403: --
1404: WSH_UTIL_CORE.API_POST_CALL
1405: (

Line 1441: WSH_DEBUG_SV.pop(l_module_name);

1437: --
1438: -- Debug Statements
1439: --
1440: IF l_debug_on THEN
1441: WSH_DEBUG_SV.pop(l_module_name);
1442: END IF;
1443: --
1444: EXCEPTION
1445: --{

Line 1461: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1457: --
1458: -- Debug Statements
1459: --
1460: IF l_debug_on THEN
1461: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1463: END IF;
1464: --
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1458: -- Debug Statements
1459: --
1460: IF l_debug_on THEN
1461: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1462: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1463: END IF;
1464: --
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;

Line 1480: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1476: --
1477: -- Debug Statements
1478: --
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1482: END IF;
1483: --
1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1477: -- Debug Statements
1478: --
1479: IF l_debug_on THEN
1480: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1481: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1482: END IF;
1483: --
1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1484: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1486: --
1487: IF l_debug_on THEN
1488: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1489: END IF;
1490: --
1491: IF (g_callback_required = 'Y') THEN
1492: --{

Line 1497: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);

1493: --
1494: -- Debug Statements
1495: --
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1498: END IF;
1499: --
1500: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1501: (

Line 1529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

1525: --
1526: -- Debug Statements
1527: --
1528: IF l_debug_on THEN
1529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1530: END IF;
1531: --
1532: WHEN OTHERS THEN
1533: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;

Line 1543: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1539: --
1540: -- Debug Statements
1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1545: END IF;
1546: --
1547: END Delivery_Detail_Action;

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

1540: -- Debug Statements
1541: --
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1545: END IF;
1546: --
1547: END Delivery_Detail_Action;
1548:

Line 1600: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1596: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1597: --
1598: IF l_debug_on IS NULL
1599: THEN
1600: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1601: END IF;
1602: --
1603: SAVEPOINT check_purge_WSHWLGPB;
1604: --

Line 1621: wsh_debug_sv.push (l_module_name);

1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: --
1621: wsh_debug_sv.push (l_module_name);
1622: wsh_debug_sv.log (l_module_name,'lpn_ids.count',p_lpn_rec.lpn_ids.COUNT);
1623: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
1624: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
1625: --

Line 1622: wsh_debug_sv.log (l_module_name,'lpn_ids.count',p_lpn_rec.lpn_ids.COUNT);

1618: --
1619: IF l_debug_on THEN
1620: --
1621: wsh_debug_sv.push (l_module_name);
1622: wsh_debug_sv.log (l_module_name,'lpn_ids.count',p_lpn_rec.lpn_ids.COUNT);
1623: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
1624: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
1625: --
1626: END IF;

Line 1623: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);

1619: IF l_debug_on THEN
1620: --
1621: wsh_debug_sv.push (l_module_name);
1622: wsh_debug_sv.log (l_module_name,'lpn_ids.count',p_lpn_rec.lpn_ids.COUNT);
1623: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
1624: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
1625: --
1626: END IF;
1627: --

Line 1624: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);

1620: --
1621: wsh_debug_sv.push (l_module_name);
1622: wsh_debug_sv.log (l_module_name,'lpn_ids.count',p_lpn_rec.lpn_ids.COUNT);
1623: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
1624: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
1625: --
1626: END IF;
1627: --
1628: IF p_lpn_rec.lpn_ids.COUNT > 0 THEN --{

Line 1639: wsh_debug_sv.log (l_module_name,'l_count',l_count);

1635: l_count := 0;
1636: END;
1637:
1638: IF l_debug_on THEN
1639: wsh_debug_sv.log (l_module_name,'l_count',l_count);
1640: END IF;
1641:
1642: IF l_count > 0 THEN
1643: DELETE FROM wsh_lpn_purge_tmp;

Line 1666: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);

1662: And NVL(wdd.line_direction,'O') IN ('IO','O')
1663: And wdd.released_status <> 'C');
1664:
1665: IF l_debug_on THEN
1666: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);
1667: END IF;
1668:
1669: Update wsh_lpn_purge_tmp
1670: Set ELIGIBLE_FLAG = 'N'

Line 1684: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);

1680: and wlh.source_header_id = wth.shipment_header_id
1681: and wth.transaction_type in ('RECEIPT', 'ASN'));
1682:
1683: IF l_debug_on THEN
1684: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);
1685: END IF;
1686:
1687: UPDATE wsh_delivery_details
1688: SET lpn_id = NULL WHERE

Line 1697: wsh_debug_sv.log (l_module_name,'lpn_ids.COUNT',

1693: FETCH c_populate_out_rec BULK COLLECT INTO p_lpn_rec.lpn_ids;
1694: CLOSE c_populate_out_rec;
1695:
1696: IF l_debug_on THEN
1697: wsh_debug_sv.log (l_module_name,'lpn_ids.COUNT',
1698: p_lpn_rec.lpn_ids.COUNT);
1699: END IF;
1700:
1701: END IF; --}

Line 1711: WSH_DEBUG_SV.pop(l_module_name);

1707: p_data => x_msg_data,
1708: p_encoded => FND_API.G_FALSE);
1709: --
1710: IF l_debug_on THEN
1711: WSH_DEBUG_SV.pop(l_module_name);
1712: END IF;
1713: --
1714: EXCEPTION
1715:

Line 1730: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1726: );
1727:
1728: --
1729: IF l_debug_on THEN
1730: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1732: END IF;
1733: --
1734: END Check_purge;

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

1727:
1728: --
1729: IF l_debug_on THEN
1730: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1731: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1732: END IF;
1733: --
1734: END Check_purge;
1735:

Line 1804: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1800: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1801: --
1802: IF l_debug_on IS NULL
1803: THEN
1804: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1805: END IF;
1806: --
1807: IF l_debug_on THEN
1808: --

Line 1809: wsh_debug_sv.push (l_module_name);

1805: END IF;
1806: --
1807: IF l_debug_on THEN
1808: --
1809: wsh_debug_sv.push (l_module_name);
1810: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab.count',p_input_delivery_id_tab.COUNT);
1811: wsh_debug_sv.log (l_module_name,'p_target_consol_delivery_id',p_target_consol_delivery_id);
1812: --
1813: END IF;

Line 1810: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab.count',p_input_delivery_id_tab.COUNT);

1806: --
1807: IF l_debug_on THEN
1808: --
1809: wsh_debug_sv.push (l_module_name);
1810: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab.count',p_input_delivery_id_tab.COUNT);
1811: wsh_debug_sv.log (l_module_name,'p_target_consol_delivery_id',p_target_consol_delivery_id);
1812: --
1813: END IF;
1814: --

Line 1811: wsh_debug_sv.log (l_module_name,'p_target_consol_delivery_id',p_target_consol_delivery_id);

1807: IF l_debug_on THEN
1808: --
1809: wsh_debug_sv.push (l_module_name);
1810: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab.count',p_input_delivery_id_tab.COUNT);
1811: wsh_debug_sv.log (l_module_name,'p_target_consol_delivery_id',p_target_consol_delivery_id);
1812: --
1813: END IF;
1814: --
1815:

Line 1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');

1828: CLOSE c_parent_info;
1829:
1830: IF l_debug_on THEN
1831: --
1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);

Line 1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));

1829:
1830: IF l_debug_on THEN
1831: --
1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);

Line 1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);

1830: IF l_debug_on THEN
1831: --
1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);

Line 1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);

1831: --
1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);
1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');

Line 1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);

1832: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);
1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1840: --

Line 1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);

1833: wsh_debug_sv.log (l_module_name,'p_input_delivery_id_tab-->',p_input_delivery_id_tab(i));
1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);
1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1840: --
1841: END IF;

Line 1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);

1834: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);
1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1840: --
1841: END IF;
1842:

Line 1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');

1835: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1836: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1837: wsh_debug_sv.log (l_module_name,'l_temp_parent_del_id-->',l_temp_parent_del_id);
1838: wsh_debug_sv.log (l_module_name,'l_parent_del_id-->',l_parent_del_id);
1839: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1840: --
1841: END IF;
1842:
1843: IF l_temp_trip_id IS NOT NULL AND l_consol_trip_id IS NULL THEN

Line 1858: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');

1854: END LOOP;
1855:
1856: IF l_debug_on THEN
1857: --
1858: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1859: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_consol_trip_id-->',l_consol_trip_id);
1860: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_parent_del_id-->',l_parent_del_id);
1861: --
1862: END IF;

Line 1859: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_consol_trip_id-->',l_consol_trip_id);

1855:
1856: IF l_debug_on THEN
1857: --
1858: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1859: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_consol_trip_id-->',l_consol_trip_id);
1860: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_parent_del_id-->',l_parent_del_id);
1861: --
1862: END IF;
1863:

Line 1860: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_parent_del_id-->',l_parent_del_id);

1856: IF l_debug_on THEN
1857: --
1858: wsh_debug_sv.logmsg (l_module_name,'----------------------------------');
1859: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_consol_trip_id-->',l_consol_trip_id);
1860: wsh_debug_sv.log (l_module_name,'AFTER THE LOOP,l_parent_del_id-->',l_parent_del_id);
1861: --
1862: END IF;
1863:
1864: IF p_target_consol_delivery_id IS NOT NULL THEN

Line 1872: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);

1868: CLOSE c_pickup_trip;
1869:
1870: IF l_debug_on THEN
1871: --
1872: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1873: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1874: --
1875: END IF;
1876:

Line 1873: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);

1869:
1870: IF l_debug_on THEN
1871: --
1872: wsh_debug_sv.log (l_module_name,'l_temp_trip_id-->',l_temp_trip_id);
1873: wsh_debug_sv.log (l_module_name,'l_consol_trip_id-->',l_consol_trip_id);
1874: --
1875: END IF;
1876:
1877: IF l_temp_trip_id <> l_consol_trip_id THEN

Line 1903: WSH_DEBUG_SV.pop(l_module_name);

1899: RAISE WSH_INVALID_DECONSOL_POINT;
1900: END IF;
1901:
1902: IF l_debug_on THEN
1903: WSH_DEBUG_SV.pop(l_module_name);
1904: END IF;
1905:
1906: EXCEPTION
1907:

Line 1916: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_PARENT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1912: --
1913: -- Debug Statements
1914: --
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_PARENT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1917:
1918: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_PARENT');
1919: END IF;
1920: --

Line 1918: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_PARENT');

1914: --
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_PARENT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1917:
1918: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_PARENT');
1919: END IF;
1920: --
1921: WHEN WSH_INVALID_TRIP THEN
1922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1929: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1925: --
1926: -- Debug Statements
1927: --
1928: IF l_debug_on THEN
1929: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1930:
1931: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIP');
1932: END IF;
1933:

Line 1931: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIP');

1927: --
1928: IF l_debug_on THEN
1929: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1930:
1931: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_TRIP');
1932: END IF;
1933:
1934: WHEN WSH_INVALID_DECONSOL_POINT THEN
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1942: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DECONSOL_POINT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1938: --
1939: -- Debug Statements
1940: --
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DECONSOL_POINT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1943:
1944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DECONSOL_POINT');
1945: END IF;
1946:

Line 1944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DECONSOL_POINT');

1940: --
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DECONSOL_POINT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1943:
1944: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DECONSOL_POINT');
1945: END IF;
1946:
1947: WHEN OTHERS THEN
1948: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);

Line 1951: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');

1947: WHEN OTHERS THEN
1948: wsh_util_core.default_handler('wsh_new_delivery_actions.Unassign_Dels_from_Consol_Del',l_module_name);
1949: --
1950: IF l_debug_on THEN
1951: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1952: END IF;
1953:
1954:
1955: END is_valid_consol;