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_LPN_SYNC_COMM_PKG dependencies on WSH_DEBUG_SV

Line 155: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

151: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
152: --
153: IF l_debug_on IS NULL
154: THEN
155: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
156: END IF;
157: --
158: --
159: -- Debug Statements

Line 162: WSH_DEBUG_SV.push(l_module_name);

158: --
159: -- Debug Statements
160: --
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.push(l_module_name);
163: END IF;
164: --
165: -- Setting the return status in the begining
166: x_return_status := wsh_util_core.g_ret_sts_success;

Line 169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);

165: -- Setting the return status in the begining
166: x_return_status := wsh_util_core.g_ret_sts_success;
167: --
168: IF l_debug_on THEN
169: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
170: END IF;
171: --
172: IF ( wsh_wms_lpn_grp.g_hw_time_stamp is null ) THEN
173: wsh_wms_lpn_grp.g_hw_time_stamp := sysdate;

Line 189: WSH_DEBUG_SV.log(l_module_name,'l_current_hw_time_stamp', l_current_hw_time_stamp);

185: -- Logic for 'UNPACK'
186: i := 1;
187: --
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.log(l_module_name,'l_current_hw_time_stamp', l_current_hw_time_stamp);
190: END IF;
191:
192: -- Bug 8314220: Moved following query out from debug
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp

Line 197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);

193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
198: END IF;
199:
200: -- Bug 8314220: Execute following code only if there are any records in wsh_wms_sync_tmp table.
201: IF l_tmp_tbl_size > 0 THEN

Line 216: WSH_DEBUG_SV.log(l_module_name,'Count of rows updated is', SQL%ROWCOUNT);

212: and operation_type = 'UPDATE'
213: and creation_date = l_current_hw_time_stamp;
214:
215: IF l_debug_on THEN
216: WSH_DEBUG_SV.log(l_module_name,'Count of rows updated is', SQL%ROWCOUNT);
217: END IF;
218:
219: FOR unpack_rec in l_unpack_csr(l_current_hw_time_stamp) LOOP
220: --{

Line 234: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);

230: --
231: ELSE
232: --
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);
235: WSH_DEBUG_SV.log(l_module_name,'old parent lpn id is', l_prev_unpack_parent_lpn_id);
236: END IF;
237: -- This infrastructure is built for future so that when
238: -- WMS is interested in getting this information, we

Line 235: WSH_DEBUG_SV.log(l_module_name,'old parent lpn id is', l_prev_unpack_parent_lpn_id);

231: ELSE
232: --
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);
235: WSH_DEBUG_SV.log(l_module_name,'old parent lpn id is', l_prev_unpack_parent_lpn_id);
236: END IF;
237: -- This infrastructure is built for future so that when
238: -- WMS is interested in getting this information, we
239: -- need to make a call at this point

Line 256: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);

252: -- Need to make one extra call to WMS for UNPACK to take care of the last set of lpns
253: -- in the l_unpack_lpn_id_tbl after teh loop
254: --
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);
257: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unpack_parent_lpn_id);
258: END IF;
259:
260: -- Logic for 'PACK'

Line 257: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unpack_parent_lpn_id);

253: -- in the l_unpack_lpn_id_tbl after teh loop
254: --
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name,'Count of l_unpack_lpn_id_tbl is', l_unpack_lpn_id_tbl.count);
257: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unpack_parent_lpn_id);
258: END IF;
259:
260: -- Logic for 'PACK'
261: i := 1;

Line 278: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);

274: --
275: ELSE
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);
279: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);
280: END IF;
281: -- This infrastructure is built for future so that when
282: -- WMS is interested in getting this information, we

Line 279: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);

275: ELSE
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);
279: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);
280: END IF;
281: -- This infrastructure is built for future so that when
282: -- WMS is interested in getting this information, we
283: -- need to make a call at this point

Line 300: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);

296: -- Need to make one extra call to WMS for PACK to take care of the last set of lpns
297: -- in the l_pack_lpn_id_tbl after teh loop
298: --
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);
301: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);
302: END IF;
303:
304: -- Logic for 'UNASSIGN'

Line 301: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);

297: -- in the l_pack_lpn_id_tbl after teh loop
298: --
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.log(l_module_name,'Count of l_pack_lpn_id_tbl is', l_pack_lpn_id_tbl.count);
301: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_pack_parent_lpn_id);
302: END IF;
303:
304: -- Logic for 'UNASSIGN'
305: i := 1;

Line 321: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);

317: --
318: ELSE
319: --
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);
322: WSH_DEBUG_SV.log(l_module_name,'old delivery id is', l_prev_unasgn_del_id);
323: END IF;
324: -- This infrastructure is built for future so that when
325: -- WMS is interested in getting this information, we

Line 322: WSH_DEBUG_SV.log(l_module_name,'old delivery id is', l_prev_unasgn_del_id);

318: ELSE
319: --
320: IF l_debug_on THEN
321: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);
322: WSH_DEBUG_SV.log(l_module_name,'old delivery id is', l_prev_unasgn_del_id);
323: END IF;
324: -- This infrastructure is built for future so that when
325: -- WMS is interested in getting this information, we
326: -- need to make a call at this point

Line 343: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);

339: -- Need to make one extra call to WMS for UNASSIGN to take care of the last set of lpns
340: -- in the l_unasgn_lpn_id_tbl after the loop
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);
344: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unasgn_del_id);
345: END IF;
346:
347: -- Logic for 'UNASSIGN'

Line 344: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unasgn_del_id);

340: -- in the l_unasgn_lpn_id_tbl after the loop
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);
344: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unasgn_del_id);
345: END IF;
346:
347: -- Logic for 'UNASSIGN'
348: i := 1;

Line 365: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);

361: --
362: ELSE
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);
366: WSH_DEBUG_SV.log(l_module_name,'new delivery id is', l_prev_asgn_del_id);
367: END IF;
368: -- This infrastructure is built for future so that when
369: -- WMS is interested in getting this information, we

Line 366: WSH_DEBUG_SV.log(l_module_name,'new delivery id is', l_prev_asgn_del_id);

362: ELSE
363: --
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);
366: WSH_DEBUG_SV.log(l_module_name,'new delivery id is', l_prev_asgn_del_id);
367: END IF;
368: -- This infrastructure is built for future so that when
369: -- WMS is interested in getting this information, we
370: -- need to make a call at this point

Line 387: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);

383: -- Need to make one extra call to WMS for ASSIGN to take care of the last set of lpns
384: -- in the l_asgn_lpn_id_tbl after the loop
385: --
386: IF l_debug_on THEN
387: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);
388: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_asgn_del_id);
389: END IF;
390:
391: i := 1;

Line 388: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_asgn_del_id);

384: -- in the l_asgn_lpn_id_tbl after the loop
385: --
386: IF l_debug_on THEN
387: WSH_DEBUG_SV.log(l_module_name,'Count of l_asgn_lpn_id_tbl is', l_asgn_lpn_id_tbl.count);
388: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_asgn_del_id);
389: END IF;
390:
391: i := 1;
392: FOR update_rec in l_update_csr(l_current_hw_time_stamp) LOOP

Line 395: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);

391: i := 1;
392: FOR update_rec in l_update_csr(l_current_hw_time_stamp) LOOP
393: --{
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
396: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
397: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
398: END IF;
399:

Line 396: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);

392: FOR update_rec in l_update_csr(l_current_hw_time_stamp) LOOP
393: --{
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
396: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
397: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
398: END IF;
399:
400: IF (update_rec.lpn_id IS NOT NULL) THEN

Line 397: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);

393: --{
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
396: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
397: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
398: END IF;
399:
400: IF (update_rec.lpn_id IS NOT NULL) THEN
401: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;

Line 423: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);

419: --}
420: END IF;
421: --
422: IF l_debug_on THEN
423: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
424: END IF;
425: --
426: IF ( l_wms_lpn_tbl.count > 0 ) THEN
427: --{

Line 432: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);

428: -- setting the globals appropriately before calling WMS.
429: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
430:
431: IF l_debug_on THEN
432: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
433: END IF;
434:
435: WMS_Container_GRP.Modify_LPNs (
436: p_api_version => 1.0,

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

452: --
453: -- Debug Statements
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
457: END IF;
458: --
459: wsh_util_core.api_post_call(
460: p_return_status => l_return_status,

Line 482: WSH_DEBUG_SV.pop(l_module_name);

478: --
479: -- Debug Statements
480: --
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.pop(l_module_name);
483: END IF;
484: --
485: EXCEPTION
486: --{

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

495: --
496: -- Debug Statements
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

496: -- Debug Statements
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
501: END IF;
502: --
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

511: --
512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
517: END IF;
518: --
519: WHEN OTHERS THEN

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

512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
516: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
517: END IF;
518: --
519: WHEN OTHERS THEN
520: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

526: --
527: -- Debug Statements
528: --
529: IF l_debug_on THEN
530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
531: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
532: END IF;
533: --
534: --}

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

527: -- Debug Statements
528: --
529: IF l_debug_on THEN
530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
531: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
532: END IF;
533: --
534: --}
535: END SYNC_LPNS_TO_WMS;

Line 597: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

593: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
594: --
595: IF l_debug_on IS NULL
596: THEN
597: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
598: END IF;
599: --
600: --
601: -- Debug Statements

Line 604: WSH_DEBUG_SV.push(l_module_name);

600: --
601: -- Debug Statements
602: --
603: IF l_debug_on THEN
604: WSH_DEBUG_SV.push(l_module_name);
605: END IF;
606: --
607: -- Setting the return status in the begining
608: x_return_status := wsh_util_core.g_ret_sts_success;

Line 618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);

614: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
619: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);
620: END IF;
621: --
622: i := 1;

Line 619: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);

615: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
616:
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
619: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);
620: END IF;
621: --
622: i := 1;
623: l_loopCounter := 1;

Line 630: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);

626: FOR update_rec in l_pr_update_csr(l_current_hw_time_stamp) LOOP
627: --{
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
631: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
632: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
633: END IF;
634: --

Line 631: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);

627: --{
628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
631: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
632: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
633: END IF;
634: --
635: l_call_level := nvl(update_rec.call_level,0);

Line 632: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);

628: --
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
631: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
632: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
633: END IF;
634: --
635: l_call_level := nvl(update_rec.call_level,0);
636: --

Line 644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);

640: -- setting the globals appropriately before calling WMS.
641: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
642:
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
645: END IF;
646:
647: WMS_Container_GRP.Modify_LPNs (
648: p_api_version => 1.0,

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

664: --
665: -- Debug Statements
666: --
667: IF l_debug_on THEN
668: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
669: END IF;
670: --
671: wsh_util_core.api_post_call(
672: p_return_status => l_return_status,

Line 686: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);

682: --}
683: END IF;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
687: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
688: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
689: END IF;
690:

Line 687: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);

683: END IF;
684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
687: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
688: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
689: END IF;
690:
691: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;

Line 688: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);

684: --
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
687: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
688: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
689: END IF;
690:
691: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;
692: l_wms_lpn_tbl(i).LICENSE_PLATE_NUMBER := update_rec.container_name;

Line 713: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);

709: --}
710: END LOOP;
711: --
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
714: END IF;
715: --
716: IF ( l_wms_lpn_tbl.count > 0 ) THEN
717: --{

Line 722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);

718: -- setting the globals appropriately before calling WMS.
719: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
720:
721: IF l_debug_on THEN
722: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
723: END IF;
724:
725: WMS_Container_GRP.Modify_LPNs (
726: p_api_version => 1.0,

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

742: --
743: -- Debug Statements
744: --
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
747: END IF;
748: --
749: wsh_util_core.api_post_call(
750: p_return_status => l_return_status,

Line 772: WSH_DEBUG_SV.pop(l_module_name);

768: --
769: -- Debug Statements
770: --
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.pop(l_module_name);
773: END IF;
774: --
775: EXCEPTION
776: --{

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

785: --
786: -- Debug Statements
787: --
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

786: -- Debug Statements
787: --
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
791: END IF;
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

801: --
802: -- Debug Statements
803: --
804: IF l_debug_on THEN
805: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
807: END IF;
808: --
809: WHEN OTHERS THEN

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

802: -- Debug Statements
803: --
804: IF l_debug_on THEN
805: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
806: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
807: END IF;
808: --
809: WHEN OTHERS THEN
810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

816: --
817: -- Debug Statements
818: --
819: IF l_debug_on THEN
820: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
821: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
822: END IF;
823: --
824: --}

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

817: -- Debug Statements
818: --
819: IF l_debug_on THEN
820: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
821: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
822: END IF;
823: --
824: --}
825: END SYNC_PRORATED_LPNS_TO_WMS;