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: IF l_debug_on THEN
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp

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

191: --
192: IF l_debug_on THEN
193: select count(*) into l_tmp_tbl_size from wsh_wms_sync_tmp
194: where creation_date = l_current_hw_time_stamp;
195: WSH_DEBUG_SV.log(l_module_name,'Count of wsh_wms_sync_tmp table is', l_tmp_tbl_size);
196: END IF;
197:
198: -- We are doing the following update because, if a particular went through various
199: -- steps of for example, update, assign, unassign, and was finally deleted, then

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

207: and operation_type = 'UPDATE'
208: and creation_date = l_current_hw_time_stamp;
209:
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.log(l_module_name,'Count of rows updated is', SQL%ROWCOUNT);
212: END IF;
213:
214: FOR unpack_rec in l_unpack_csr(l_current_hw_time_stamp) LOOP
215: --{

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

335: -- in the l_unasgn_lpn_id_tbl after the loop
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.log(l_module_name,'Count of l_unasgn_lpn_id_tbl is', l_unasgn_lpn_id_tbl.count);
339: WSH_DEBUG_SV.log(l_module_name,'new parent lpn id is', l_prev_unasgn_del_id);
340: END IF;
341:
342: -- Logic for 'UNASSIGN'
343: i := 1;

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

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

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

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

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

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

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

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

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

386: i := 1;
387: FOR update_rec in l_update_csr(l_current_hw_time_stamp) LOOP
388: --{
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
391: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
392: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
393: END IF;
394:

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

387: FOR update_rec in l_update_csr(l_current_hw_time_stamp) LOOP
388: --{
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
391: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
392: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
393: END IF;
394:
395: IF (update_rec.lpn_id IS NOT NULL) THEN

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

388: --{
389: IF l_debug_on THEN
390: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
391: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
392: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
393: END IF;
394:
395: IF (update_rec.lpn_id IS NOT NULL) THEN
396: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;

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

412: --}
413: END LOOP;
414: --
415: IF l_debug_on THEN
416: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
417: END IF;
418: --
419: IF ( l_wms_lpn_tbl.count > 0 ) THEN
420: --{

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

421: -- setting the globals appropriately before calling WMS.
422: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
423:
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
426: END IF;
427:
428: WMS_Container_GRP.Modify_LPNs (
429: p_api_version => 1.0,

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

445: --
446: -- Debug Statements
447: --
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
450: END IF;
451: --
452: wsh_util_core.api_post_call(
453: p_return_status => l_return_status,

Line 475: WSH_DEBUG_SV.pop(l_module_name);

471: --
472: -- Debug Statements
473: --
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.pop(l_module_name);
476: END IF;
477: --
478: EXCEPTION
479: --{

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

488: --
489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
494: END IF;
495: --
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

489: -- Debug Statements
490: --
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
494: END IF;
495: --
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

504: --
505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: WHEN OTHERS THEN

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

505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: WHEN OTHERS THEN
513: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

519: --
520: -- Debug Statements
521: --
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
525: END IF;
526: --
527: --}

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

520: -- Debug Statements
521: --
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
525: END IF;
526: --
527: --}
528: END SYNC_LPNS_TO_WMS;

Line 590: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

586: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
587: --
588: IF l_debug_on IS NULL
589: THEN
590: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
591: END IF;
592: --
593: --
594: -- Debug Statements

Line 597: WSH_DEBUG_SV.push(l_module_name);

593: --
594: -- Debug Statements
595: --
596: IF l_debug_on THEN
597: WSH_DEBUG_SV.push(l_module_name);
598: END IF;
599: --
600: -- Setting the return status in the begining
601: x_return_status := wsh_util_core.g_ret_sts_success;

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

607: l_current_hw_time_stamp := wsh_wms_lpn_grp.g_hw_time_stamp;
608: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
609:
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
612: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);
613: END IF;
614: --
615: i := 1;

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

608: l_original_call_grp_api := wsh_wms_lpn_grp.g_call_group_api;
609:
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.log(l_module_name,'wsh_wms_lpn_grp.g_hw_time_stamp', wsh_wms_lpn_grp.g_hw_time_stamp);
612: WSH_DEBUG_SV.log(l_module_name,'l_original_call_grp_api', l_original_call_grp_api);
613: END IF;
614: --
615: i := 1;
616: l_loopCounter := 1;

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

619: FOR update_rec in l_pr_update_csr(l_current_hw_time_stamp) LOOP
620: --{
621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
624: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
625: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
626: END IF;
627: --

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

620: --{
621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
624: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
625: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
626: END IF;
627: --
628: l_call_level := nvl(update_rec.call_level,0);

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

621: --
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
624: WSH_DEBUG_SV.log(l_module_name,'l_call_level',l_call_level);
625: WSH_DEBUG_SV.log(l_module_name,'l_prev_call_level',l_prev_call_level);
626: END IF;
627: --
628: l_call_level := nvl(update_rec.call_level,0);
629: --

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

633: -- setting the globals appropriately before calling WMS.
634: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
635:
636: IF l_debug_on THEN
637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
638: END IF;
639:
640: WMS_Container_GRP.Modify_LPNs (
641: p_api_version => 1.0,

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

657: --
658: -- Debug Statements
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
662: END IF;
663: --
664: wsh_util_core.api_post_call(
665: p_return_status => l_return_status,

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

675: --}
676: END IF;
677: --
678: IF l_debug_on THEN
679: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
680: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
681: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
682: END IF;
683:

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

676: END IF;
677: --
678: IF l_debug_on THEN
679: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
680: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
681: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
682: END IF;
683:
684: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;

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

677: --
678: IF l_debug_on THEN
679: WSH_DEBUG_SV.log(l_module_name,'Inside the loop i is', i);
680: WSH_DEBUG_SV.log(l_module_name,'Inside the loop delivery_detail_id is', update_rec.delivery_detail_id);
681: WSH_DEBUG_SV.log(l_module_name,'Inside the loop lpn_id is', update_rec.lpn_id);
682: END IF;
683:
684: l_wms_lpn_tbl(i).LPN_ID := update_rec.lpn_id;
685: l_wms_lpn_tbl(i).LICENSE_PLATE_NUMBER := update_rec.container_name;

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

702: --}
703: END LOOP;
704: --
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.log(l_module_name,'count of plsql table l_wms_lpn_tbl is', l_wms_lpn_tbl.count);
707: END IF;
708: --
709: IF ( l_wms_lpn_tbl.count > 0 ) THEN
710: --{

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

711: -- setting the globals appropriately before calling WMS.
712: WSH_WMS_LPN_GRP.g_call_group_api := 'N';
713:
714: IF l_debug_on THEN
715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_CONTAINER_GRP.MODIFY_LPNS',WSH_DEBUG_SV.C_PROC_LEVEL);
716: END IF;
717:
718: WMS_Container_GRP.Modify_LPNs (
719: p_api_version => 1.0,

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

735: --
736: -- Debug Statements
737: --
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
740: END IF;
741: --
742: wsh_util_core.api_post_call(
743: p_return_status => l_return_status,

Line 765: WSH_DEBUG_SV.pop(l_module_name);

761: --
762: -- Debug Statements
763: --
764: IF l_debug_on THEN
765: WSH_DEBUG_SV.pop(l_module_name);
766: END IF;
767: --
768: EXCEPTION
769: --{

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

778: --
779: -- Debug Statements
780: --
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
784: END IF;
785: --
786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

779: -- Debug Statements
780: --
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
784: END IF;
785: --
786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

794: --
795: -- Debug Statements
796: --
797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
800: END IF;
801: --
802: WHEN OTHERS THEN

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

795: -- Debug Statements
796: --
797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
799: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
800: END IF;
801: --
802: WHEN OTHERS THEN
803: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

809: --
810: -- Debug Statements
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
815: END IF;
816: --
817: --}

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

810: -- Debug Statements
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
815: END IF;
816: --
817: --}
818: END SYNC_PRORATED_LPNS_TO_WMS;