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

Line 202: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

198: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
199: --
200: IF l_debug_on IS NULL
201: THEN
202: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
203: END IF;
204: --
205: IF l_debug_on THEN
206: wsh_debug_sv.push(l_module_name);

Line 206: wsh_debug_sv.push(l_module_name);

202: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
203: END IF;
204: --
205: IF l_debug_on THEN
206: wsh_debug_sv.push(l_module_name);
207: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
208: wsh_debug_sv.log (l_module_name, 'document type' , p_document_type);
209: END IF;
210:

Line 207: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);

203: END IF;
204: --
205: IF l_debug_on THEN
206: wsh_debug_sv.push(l_module_name);
207: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
208: wsh_debug_sv.log (l_module_name, 'document type' , p_document_type);
209: END IF;
210:
211: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 208: wsh_debug_sv.log (l_module_name, 'document type' , p_document_type);

204: --
205: IF l_debug_on THEN
206: wsh_debug_sv.push(l_module_name);
207: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
208: wsh_debug_sv.log (l_module_name, 'document type' , p_document_type);
209: END IF;
210:
211: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
212:

Line 217: wsh_debug_sv.log (l_module_name, 'Error at cursor l_del_info_cur');

213: OPEN l_del_info_cur;
214: FETCH l_del_info_cur INTO x_name, l_customer_id, l_org_id,l_ship_to_location_id;--bug 3920178
215: IF ( l_del_info_cur % NOTFOUND) THEN
216: IF l_debug_on THEN
217: wsh_debug_sv.log (l_module_name, 'Error at cursor l_del_info_cur');
218: END IF;
219:
220: CLOSE l_del_info_cur;
221: RAISE wsh_invalid_delivery_id;

Line 238: WSH_DEBUG_SV.log(L_MODULE_NAME, 'l_ship_to_site_use_id' , l_ship_to_site_use_id);

234: END IF;
235: close l_ship_to_site_use_id_csr;
236:
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.log(L_MODULE_NAME, 'l_ship_to_site_use_id' , l_ship_to_site_use_id);
239: END IF;
240: IF nvl(l_ship_to_site_use_id, -1) <> -1 THEN
241: --{
242: open l_site_use_loc_csr(l_ship_to_site_use_id);

Line 256: WSH_DEBUG_SV.log(l_module_name, 'l_operating_unit' , l_operating_unit);

252: --{
253: l_operating_unit := WSH_UTIL_CORE.Get_OperatingUnit_Id(p_delivery_id);
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name, 'l_operating_unit' , l_operating_unit);
257: END IF;
258: open l_cust_ship_to_loc_csr
259: (l_customer_id,
260: l_ship_to_location_id,

Line 271: WSH_DEBUG_SV.logmsg(L_MODULE_NAME, 'Using Customer Relationship Cursor');

267:
268: IF l_ship_to_loc_code IS NULL THEN
269: --{
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.logmsg(L_MODULE_NAME, 'Using Customer Relationship Cursor');
272: END IF;
273:
274: open l_rel_cust_ship_to_loc_csr
275: (l_customer_id,

Line 285: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);

281: END IF;
282: --}
283: END IF;
284: IF l_debug_on THEN
285: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);
286: END IF;
287:
288: IF l_ship_to_loc_code IS NULL THEN
289: raise fnd_api.g_exc_error;

Line 310: WSH_DEBUG_SV.log (L_MODULE_NAME, 'Contact Person Name ',

306: --}
307: END IF;
308:
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log (L_MODULE_NAME, 'Contact Person Name ',
311: x_cnsgn_cont_per_name);
312: WSH_DEBUG_SV.log (L_MODULE_NAME, ' Contact Person Phone Number ',
313: x_cnsgn_cont_per_ph);
314: END IF;

Line 312: WSH_DEBUG_SV.log (L_MODULE_NAME, ' Contact Person Phone Number ',

308:
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log (L_MODULE_NAME, 'Contact Person Name ',
311: x_cnsgn_cont_per_name);
312: WSH_DEBUG_SV.log (L_MODULE_NAME, ' Contact Person Phone Number ',
313: x_cnsgn_cont_per_ph);
314: END IF;
315:
316:

Line 326: wsh_debug_sv.log (l_module_name, 'x_warehouse_type,x_return_status',x_warehouse_type||','||x_return_status);

322: p_organization_id =>l_org_id,
323: x_return_status =>x_return_status
324: );
325: IF l_debug_on THEN
326: wsh_debug_sv.log (l_module_name, 'x_warehouse_type,x_return_status',x_warehouse_type||','||x_return_status);
327: END IF;
328:
329: IF ( p_document_type = 'SA' ) THEN
330:

Line 335: wsh_debug_sv.log (l_module_name, 'Error at cursor l_src_hdr_no_cur');

331: OPEN l_src_hdr_no_cur;
332: FETCH l_src_hdr_no_cur INTO x_name;
333: IF ( l_src_hdr_no_cur % NOTFOUND) THEN
334: IF l_debug_on THEN
335: wsh_debug_sv.log (l_module_name, 'Error at cursor l_src_hdr_no_cur');
336: END IF;
337: CLOSE l_src_hdr_no_cur;
338: RAISE wsh_invalid_delivery_id;
339: END IF;

Line 355: wsh_debug_sv.log (l_module_name, 'Error at cursor l_get_dates_cur');

351: --Bug 3458160
352: x_operator;
353: IF ( l_get_dates_cur % NOTFOUND ) THEN
354: IF l_debug_on THEN
355: wsh_debug_sv.log (l_module_name, 'Error at cursor l_get_dates_cur');
356: END IF;
357: CLOSE l_get_dates_cur;
358: RAISE wsh_invalid_delivery_id;
359: END IF;

Line 362: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);

358: RAISE wsh_invalid_delivery_id;
359: END IF;
360: CLOSE l_get_dates_cur;
361: IF l_debug_on THEN
362: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
363: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
364: END IF;
365:
366:

Line 363: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);

359: END IF;
360: CLOSE l_get_dates_cur;
361: IF l_debug_on THEN
362: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
363: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
364: END IF;
365:
366:
367: END IF;

Line 370: wsh_debug_sv.log (l_module_name, 'name' , x_name);

366:
367: END IF;
368:
369: IF l_debug_on THEN
370: wsh_debug_sv.log (l_module_name, 'name' , x_name);
371: wsh_debug_sv.pop (l_module_name);
372: END IF;
373: EXCEPTION
374: --bug 3920178

Line 371: wsh_debug_sv.pop (l_module_name);

367: END IF;
368:
369: IF l_debug_on THEN
370: wsh_debug_sv.log (l_module_name, 'name' , x_name);
371: wsh_debug_sv.pop (l_module_name);
372: END IF;
373: EXCEPTION
374: --bug 3920178
375: WHEN fnd_api.g_exc_error THEN

Line 378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

374: --bug 3920178
375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

375: WHEN fnd_api.g_exc_error THEN
376: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
383: IF l_debug_on THEN

Line 384: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

380: END IF;
381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
386: END IF;
387:
388: WHEN OTHERS THEN

Line 385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');

381: WHEN wsh_invalid_delivery_id THEN
382: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
385: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
386: END IF;
387:
388: WHEN OTHERS THEN
389: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

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

Line 392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

388: WHEN OTHERS THEN
389: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
394: END IF;
395: END Get_Delivery_Info;
396:

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

389: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
392: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
393: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
394: END IF;
395: END Get_Delivery_Info;
396:
397:

Line 514: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

510: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
511: --
512: IF l_debug_on IS NULL
513: THEN
514: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
515: END IF;
516: --
517: IF l_debug_on THEN
518: wsh_debug_sv.push(l_module_name);

Line 518: wsh_debug_sv.push(l_module_name);

514: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
515: END IF;
516: --
517: IF l_debug_on THEN
518: wsh_debug_sv.push(l_module_name);
519: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
520: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
521: END IF;
522:

Line 519: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);

515: END IF;
516: --
517: IF l_debug_on THEN
518: wsh_debug_sv.push(l_module_name);
519: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
520: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
521: END IF;
522:
523: OPEN loc_ids_cur;

Line 520: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);

516: --
517: IF l_debug_on THEN
518: wsh_debug_sv.push(l_module_name);
519: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
520: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
521: END IF;
522:
523: OPEN loc_ids_cur;
524: FETCH loc_ids_cur INTO l_organization_id, l_init_loc_id, l_ult_loc_id, l_intmed_loc_id, l_pooled_loc_id, x_currency;

Line 528: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

524: FETCH loc_ids_cur INTO l_organization_id, l_init_loc_id, l_ult_loc_id, l_intmed_loc_id, l_pooled_loc_id, x_currency;
525: CLOSE loc_ids_cur;
526:
527: IF l_debug_on THEN
528: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
529: END IF;
530:
531: /* Patchset I: Locations Project. Get the OperatingUnit Id */
532: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);

Line 536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);

532: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);
533:
534:
535: IF l_debug_on THEN
536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);
537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);
539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);

Line 537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);

533:
534:
535: IF l_debug_on THEN
536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);
537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);
539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
541: END IF;

Line 538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);

534:
535: IF l_debug_on THEN
536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);
537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);
539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
541: END IF;
542:

Line 539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);

535: IF l_debug_on THEN
536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);
537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);
539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
541: END IF;
542:
543: IF(p_partner_type = 'ShipFrom') THEN

Line 540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);

536: wsh_debug_sv.log(l_module_name, 'Operating Unit Id', l_opUnit_id);
537: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
538: wsh_debug_sv.log (l_module_name, 'Ultimate Dropoff location Id', l_ult_loc_id);
539: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
540: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
541: END IF;
542:
543: IF(p_partner_type = 'ShipFrom') THEN
544: OPEN ship_from_info_cur(l_organization_id, l_init_loc_id);

Line 627: wsh_debug_sv.log (l_module_name, 'x_telephone,x_fax_number', x_telephone||','||x_fax_number);

623: x_url => x_url,
624: x_return_status => l_return_status);
625:
626: IF l_debug_on THEN
627: wsh_debug_sv.log (l_module_name, 'x_telephone,x_fax_number', x_telephone||','||x_fax_number);
628: wsh_debug_sv.log (l_module_name, 'x_url', x_url);
629: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
630: END IF;
631:

Line 628: wsh_debug_sv.log (l_module_name, 'x_url', x_url);

624: x_return_status => l_return_status);
625:
626: IF l_debug_on THEN
627: wsh_debug_sv.log (l_module_name, 'x_telephone,x_fax_number', x_telephone||','||x_fax_number);
628: wsh_debug_sv.log (l_module_name, 'x_url', x_url);
629: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
630: END IF;
631:
632: END IF;

Line 629: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);

625:
626: IF l_debug_on THEN
627: wsh_debug_sv.log (l_module_name, 'x_telephone,x_fax_number', x_telephone||','||x_fax_number);
628: wsh_debug_sv.log (l_module_name, 'x_url', x_url);
629: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
630: END IF;
631:
632: END IF;
633:

Line 635: wsh_debug_sv.pop(l_module_name);

631:
632: END IF;
633:
634: IF l_debug_on THEN
635: wsh_debug_sv.pop(l_module_name);
636: END IF;
637: EXCEPTION
638: WHEN OTHERS THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

638: WHEN OTHERS THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640:
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
643: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
645: END IF;
646: END get_part_addr_info;

Line 643: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640:
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
643: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
645: END IF;
646: END get_part_addr_info;
647:

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

640:
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
643: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
645: END IF;
646: END get_part_addr_info;
647:
648: PROCEDURE Get_Phone_Fax(

Line 681: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

677: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
678: --
679: IF l_debug_on IS NULL
680: THEN
681: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
682: END IF;
683: --
684: IF l_debug_on THEN
685: wsh_debug_sv.push(l_module_name);

Line 685: wsh_debug_sv.push(l_module_name);

681: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
682: END IF;
683: --
684: IF l_debug_on THEN
685: wsh_debug_sv.push(l_module_name);
686: wsh_debug_sv.log (l_module_name, 'Loc Id', p_loc_id);
687: END IF;
688:
689: OPEN phone_fax_cur('GEN');

Line 686: wsh_debug_sv.log (l_module_name, 'Loc Id', p_loc_id);

682: END IF;
683: --
684: IF l_debug_on THEN
685: wsh_debug_sv.push(l_module_name);
686: wsh_debug_sv.log (l_module_name, 'Loc Id', p_loc_id);
687: END IF;
688:
689: OPEN phone_fax_cur('GEN');
690: FETCH phone_fax_cur INTO x_phone, x_url;

Line 698: wsh_debug_sv.pop(l_module_name);

694: FETCH phone_fax_cur INTO x_fax, x_url;
695: CLOSE phone_fax_cur;
696:
697: IF l_debug_on THEN
698: wsh_debug_sv.pop(l_module_name);
699: END IF;
700:
701: EXCEPTION
702: WHEN OTHERS THEN

Line 705: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
706: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
707: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
708: END IF;
709: END Get_Phone_Fax;

Line 706: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

702: WHEN OTHERS THEN
703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
706: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
707: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
708: END IF;
709: END Get_Phone_Fax;
710:

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

703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
706: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
707: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
708: END IF;
709: END Get_Phone_Fax;
710:
711: PROCEDURE get_ship_method_code(

Line 755: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

751: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
752: --
753: IF l_debug_on IS NULL
754: THEN
755: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
756: END IF;
757: --
758: IF l_debug_on THEN
759: wsh_debug_sv.push(l_module_name);

Line 759: wsh_debug_sv.push(l_module_name);

755: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
756: END IF;
757: --
758: IF l_debug_on THEN
759: wsh_debug_sv.push(l_module_name);
760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);

Line 760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);

756: END IF;
757: --
758: IF l_debug_on THEN
759: wsh_debug_sv.push(l_module_name);
760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);
764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);

Line 761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);

757: --
758: IF l_debug_on THEN
759: wsh_debug_sv.push(l_module_name);
760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);
764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);
765: END IF;

Line 762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);

758: IF l_debug_on THEN
759: wsh_debug_sv.push(l_module_name);
760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);
764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);
765: END IF;
766: -- bug 3857041

Line 763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);

759: wsh_debug_sv.push(l_module_name);
760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);
764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);
765: END IF;
766: -- bug 3857041
767: IF (

Line 764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);

760: wsh_debug_sv.log (l_module_name, 'Carrier Name', p_carrier_name);
761: wsh_debug_sv.log (l_module_name, 'Service Level', p_service_level);
762: wsh_debug_sv.log (l_module_name, 'Mode of Transport', p_mode_of_transport);
763: wsh_debug_sv.log (l_module_name, 'Document Type', p_doc_type);
764: wsh_debug_sv.log (l_module_name, 'Delivery Name', p_delivery_name);
765: END IF;
766: -- bug 3857041
767: IF (
768: nvl(p_service_level,'!!!!') <> '!!!!'

Line 778: WSH_DEBUG_SV.logmsg(l_module_name,'Error -- Ship Method Not Found');

774: open c_ship_method_cur;
775: fetch c_ship_method_cur into x_ship_method_code;
776: IF ( c_ship_method_cur%NOTFOUND) THEN
777: IF l_debug_on THEN
778: WSH_DEBUG_SV.logmsg(l_module_name,'Error -- Ship Method Not Found');
779: END IF;
780: END IF;
781: close c_ship_method_cur;
782: --}

Line 788: wsh_debug_sv.pop(l_module_name);

784: -- bug 3857041
785:
786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
787: IF l_debug_on THEN
788: wsh_debug_sv.pop(l_module_name);
789: END IF;
790:
791: EXCEPTION
792: WHEN OTHERS THEN

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

791: EXCEPTION
792: WHEN OTHERS THEN
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
796: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
797: END IF;
798: END get_ship_method_code;
799:

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

792: WHEN OTHERS THEN
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
796: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
797: END IF;
798: END get_ship_method_code;
799:
800: -- ---------------------------------------------------------------------

Line 982: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

978: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
979: --
980: IF l_debug_on IS NULL
981: THEN
982: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
983: END IF;
984: --
985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
986:

Line 988: wsh_debug_sv.push(l_module_name);

984: --
985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
986:
987: IF l_debug_on THEN
988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);

Line 989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);

985: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
986:
987: IF l_debug_on THEN
988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);

Line 990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);

986:
987: IF l_debug_on THEN
988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);

Line 991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);

987: IF l_debug_on THEN
988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);

Line 992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);

988: wsh_debug_sv.push(l_module_name);
989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);

Line 993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);

989: wsh_debug_sv.log (l_module_name, 'Location Id', p_location_id);
990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);

Line 994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);

990: wsh_debug_sv.log(l_module_name, 'Org Id', p_org_id);
991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);
998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);

Line 995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);

991: wsh_debug_sv.log(l_module_name, 'Customer Id', p_customer_id);
992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);
998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
999: END IF;

Line 996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);

992: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);
998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
999: END IF;
1000:

Line 997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);

993: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);
998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
999: END IF;
1000:
1001:

Line 998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);

994: wsh_debug_sv.log(l_module_name, 'p_fm_serial_number',p_fm_serial_number);
995: wsh_debug_sv.log(l_module_name, 'p_to_serial_number',p_to_serial_number);
996: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
997: wsh_debug_sv.log(l_module_name, 'p_site_use_id',p_site_use_id);
998: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
999: END IF;
1000:
1001:
1002:

Line 1010: wsh_debug_sv.log(l_module_name, 'l_location',l_location);

1006: fetch l_site_use_loc_csr INTO l_location;
1007: close l_site_use_loc_csr;
1008: END IF;
1009: if l_debug_on then
1010: wsh_debug_sv.log(l_module_name, 'l_location',l_location);
1011: end if;
1012:
1013: IF l_location IS NULL AND
1014: --bug 3920178}

Line 1025: wsh_debug_sv.log (l_module_name, 'l_org_id', l_org_id);

1021: l_org_id := p_org_id;
1022: END IF;
1023:
1024: IF l_debug_on THEN
1025: wsh_debug_sv.log (l_module_name, 'l_org_id', l_org_id);
1026: END IF;
1027:
1028: OPEN loc_cust_cur(p_location_id, l_org_id, p_customer_id);
1029: FETCH loc_cust_cur INTO l_location; --bug 3920178

Line 1033: wsh_debug_sv.logmsg(l_module_name, 'Using l_rel_cust_ship_to_loc_csr');

1029: FETCH loc_cust_cur INTO l_location; --bug 3920178
1030: IF loc_cust_cur%NOTFOUND THEN
1031: --Bug 3920178{
1032: IF l_debug_on THEN
1033: wsh_debug_sv.logmsg(l_module_name, 'Using l_rel_cust_ship_to_loc_csr');
1034: END IF;
1035: OPEN l_rel_cust_ship_to_loc_csr(p_customer_id, p_location_id, l_org_id);
1036: FETCH l_rel_cust_ship_to_loc_csr INTO l_location;
1037: CLOSE l_rel_cust_ship_to_loc_csr;

Line 1050: wsh_debug_sv.log(l_module_name, 'l_location',l_location);

1046: CLOSE c_cust_info_cur;
1047: END IF;
1048:
1049: if l_debug_on then
1050: wsh_debug_sv.log(l_module_name, 'l_location',l_location);
1051: end if;
1052:
1053: /* bug 4227777
1054: IF l_location IS NULL THEN

Line 1061: wsh_debug_sv.log(l_module_name, 'Location', x_location);

1057: */
1058: x_location := l_location;
1059:
1060: IF l_debug_on THEN
1061: wsh_debug_sv.log(l_module_name, 'Location', x_location);
1062: wsh_debug_sv.log(l_module_name, 'Party Name', x_party_name);
1063: wsh_debug_sv.log(l_module_name, 'Party Number', x_party_number);
1064: END IF;
1065:

Line 1062: wsh_debug_sv.log(l_module_name, 'Party Name', x_party_name);

1058: x_location := l_location;
1059:
1060: IF l_debug_on THEN
1061: wsh_debug_sv.log(l_module_name, 'Location', x_location);
1062: wsh_debug_sv.log(l_module_name, 'Party Name', x_party_name);
1063: wsh_debug_sv.log(l_module_name, 'Party Number', x_party_number);
1064: END IF;
1065:
1066: IF p_wsn_rowid IS NOT NULL THEN

Line 1063: wsh_debug_sv.log(l_module_name, 'Party Number', x_party_number);

1059:
1060: IF l_debug_on THEN
1061: wsh_debug_sv.log(l_module_name, 'Location', x_location);
1062: wsh_debug_sv.log(l_module_name, 'Party Name', x_party_name);
1063: wsh_debug_sv.log(l_module_name, 'Party Number', x_party_number);
1064: END IF;
1065:
1066: IF p_wsn_rowid IS NOT NULL THEN
1067: OPEN get_wsn_qty(p_wsn_rowid);

Line 1077: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );

1073: FETCH get_rowid_count INTO l_wsn_rowid, l_wsn_count,l_wsn_sum_qty;
1074: CLOSE get_rowid_count;
1075:
1076: IF l_debug_on THEN
1077: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1078: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1079: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1080: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1081: END IF;

Line 1078: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );

1074: CLOSE get_rowid_count;
1075:
1076: IF l_debug_on THEN
1077: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1078: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1079: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1080: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1081: END IF;
1082:

Line 1079: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );

1075:
1076: IF l_debug_on THEN
1077: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1078: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1079: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1080: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1081: END IF;
1082:
1083: IF l_wsn_sum_qty = p_requested_quantity THEN

Line 1080: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );

1076: IF l_debug_on THEN
1077: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1078: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1079: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1080: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1081: END IF;
1082:
1083: IF l_wsn_sum_qty = p_requested_quantity THEN
1084: x_requested_quantity :=l_wsn_qty;

Line 1095: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);

1091: END IF;
1092: END IF;
1093:
1094: IF l_debug_on THEN
1095: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1096: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1097: END IF;
1098: END IF;
1099: --bug 4227777

Line 1096: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);

1092: END IF;
1093:
1094: IF l_debug_on THEN
1095: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1096: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1097: END IF;
1098: END IF;
1099: --bug 4227777
1100: l_uniq_ship_to_contact_id := null;

Line 1140: wsh_debug_sv.log(l_module_name, 'l_uniq_ship_to_contact_id',

1136: CLOSE l_get_ship_to_contact_csr;
1137: END IF; --}
1138:
1139: IF l_debug_on THEN
1140: wsh_debug_sv.log(l_module_name, 'l_uniq_ship_to_contact_id',
1141: l_uniq_ship_to_contact_id);
1142: END IF;
1143: IF l_uniq_ship_to_contact_id IS NOT NULL THEN --{
1144: get_name_number(

Line 1161: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_name',

1157: END IF; --}
1158:
1159:
1160: IF l_debug_on THEN
1161: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_name',
1162: x_cnsgn_cont_per_name);
1163: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_ph',
1164: x_cnsgn_cont_per_ph);
1165: wsh_debug_sv.pop(l_module_name);

Line 1163: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_ph',

1159:
1160: IF l_debug_on THEN
1161: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_name',
1162: x_cnsgn_cont_per_name);
1163: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_ph',
1164: x_cnsgn_cont_per_ph);
1165: wsh_debug_sv.pop(l_module_name);
1166: END IF;
1167:

Line 1165: wsh_debug_sv.pop(l_module_name);

1161: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_name',
1162: x_cnsgn_cont_per_name);
1163: wsh_debug_sv.log(l_module_name, 'x_cnsgn_cont_per_ph',
1164: x_cnsgn_cont_per_ph);
1165: wsh_debug_sv.pop(l_module_name);
1166: END IF;
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN

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

1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

1171: wsh_util_core.add_message(x_return_status, l_module_name);
1172: --
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1179: IF l_debug_on THEN

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

1176: END IF;
1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1181: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1182: END IF;
1183:
1184: END get_locn_cust_info;

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

1177: WHEN OTHERS THEN
1178: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1181: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1182: END IF;
1183:
1184: END get_locn_cust_info;
1185:

Line 1242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1238: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1239: --
1240: IF l_debug_on IS NULL
1241: THEN
1242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1243: END IF;
1244: --
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1246: IF l_debug_on THEN

Line 1247: wsh_debug_sv.push(l_module_name);

1243: END IF;
1244: --
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1246: IF l_debug_on THEN
1247: wsh_debug_sv.push(l_module_name);
1248: wsh_debug_sv.log (l_module_name, 'p_ship_to_site_contact_id', p_ship_to_site_contact_id);
1249: END IF;
1250:
1251: open l_ship_to_site_contact_csr(p_ship_to_site_contact_id);

Line 1248: wsh_debug_sv.log (l_module_name, 'p_ship_to_site_contact_id', p_ship_to_site_contact_id);

1244: --
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1246: IF l_debug_on THEN
1247: wsh_debug_sv.push(l_module_name);
1248: wsh_debug_sv.log (l_module_name, 'p_ship_to_site_contact_id', p_ship_to_site_contact_id);
1249: END IF;
1250:
1251: open l_ship_to_site_contact_csr(p_ship_to_site_contact_id);
1252: fetch l_ship_to_site_contact_csr into l_per_first_name,

Line 1276: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',

1272: --{
1273: x_contact_person_name := x_contact_person_name || l_per_last_name; --}
1274: END IF;
1275: IF l_debug_on THEN
1276: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',
1277: x_per_ph_number);
1278: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',
1279: l_owner_table_id);
1280: END IF;

Line 1278: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',

1274: END IF;
1275: IF l_debug_on THEN
1276: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',
1277: x_per_ph_number);
1278: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',
1279: l_owner_table_id);
1280: END IF;
1281:
1282: IF x_per_ph_number IS NULL

Line 1294: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);

1290: END IF;
1291:
1292:
1293: IF l_debug_on THEN
1294: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
1295: wsh_debug_sv.log (l_module_name, 'x_contact_person_name',
1296: x_contact_person_name);
1297: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
1298: wsh_debug_sv.pop(l_module_name);

Line 1295: wsh_debug_sv.log (l_module_name, 'x_contact_person_name',

1291:
1292:
1293: IF l_debug_on THEN
1294: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
1295: wsh_debug_sv.log (l_module_name, 'x_contact_person_name',
1296: x_contact_person_name);
1297: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
1298: wsh_debug_sv.pop(l_module_name);
1299: END IF;

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

1293: IF l_debug_on THEN
1294: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
1295: wsh_debug_sv.log (l_module_name, 'x_contact_person_name',
1296: x_contact_person_name);
1297: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
1298: wsh_debug_sv.pop(l_module_name);
1299: END IF;
1300:
1301: EXCEPTION

Line 1298: wsh_debug_sv.pop(l_module_name);

1294: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
1295: wsh_debug_sv.log (l_module_name, 'x_contact_person_name',
1296: x_contact_person_name);
1297: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
1298: wsh_debug_sv.pop(l_module_name);
1299: END IF;
1300:
1301: EXCEPTION
1302:

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

1302:
1303: WHEN OTHERS THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1308: END IF;
1309:
1310: END get_name_number;

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

1303: WHEN OTHERS THEN
1304: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1308: END IF;
1309:
1310: END get_name_number;
1311:

Line 1464: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1460: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1461: --
1462: IF l_debug_on IS NULL
1463: THEN
1464: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1465: END IF;
1466: --
1467: IF l_debug_on THEN
1468: wsh_debug_sv.push(l_module_name);

Line 1468: wsh_debug_sv.push(l_module_name);

1464: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1465: END IF;
1466: --
1467: IF l_debug_on THEN
1468: wsh_debug_sv.push(l_module_name);
1469: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
1470: END IF;
1471: --
1472: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 1469: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);

1465: END IF;
1466: --
1467: IF l_debug_on THEN
1468: wsh_debug_sv.push(l_module_name);
1469: wsh_debug_sv.log (l_module_name, 'delivery id' , p_delivery_id);
1470: END IF;
1471: --
1472: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
1473:

Line 1480: wsh_debug_sv.log (l_module_name, 'Error at cursor l_del_info_cur');

1476: --
1477: IF ( l_del_info_cur % NOTFOUND) THEN
1478: --
1479: IF l_debug_on THEN
1480: wsh_debug_sv.log (l_module_name, 'Error at cursor l_del_info_cur');
1481: END IF;
1482: --
1483: CLOSE l_del_info_cur;
1484: RAISE wsh_invalid_delivery_id;

Line 1507: WSH_DEBUG_SV.log(L_MODULE_NAME, 'l_ship_to_site_use_id' , l_ship_to_site_use_id);

1503: --
1504: CLOSE l_ship_to_site_use_id_csr;
1505: --
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.log(L_MODULE_NAME, 'l_ship_to_site_use_id' , l_ship_to_site_use_id);
1508: END IF;
1509: --
1510: IF nvl(l_ship_to_site_use_id, -1) <> -1 THEN
1511: --{

Line 1527: WSH_DEBUG_SV.log(l_module_name, 'l_operating_unit' , l_operating_unit);

1523: IF l_ship_to_loc_code IS NULL THEN
1524: --{
1525: --
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.log(l_module_name, 'l_operating_unit' , l_operating_unit);
1528: END IF;
1529: --
1530: OPEN l_cust_ship_to_loc_csr
1531: (l_customer_id,

Line 1545: WSH_DEBUG_SV.logmsg(L_MODULE_NAME, 'Using Customer Relationship Cursor');

1541: --
1542: IF l_ship_to_loc_code IS NULL THEN
1543: --{
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(L_MODULE_NAME, 'Using Customer Relationship Cursor');
1546: END IF;
1547:
1548: OPEN l_rel_cust_ship_to_loc_csr(
1549: l_customer_id,

Line 1559: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);

1555: END IF;
1556: --}
1557: END IF;
1558: IF l_debug_on THEN
1559: WSH_DEBUG_SV.log(l_module_name, 'l_ship_to_loc_code', l_ship_to_loc_code);
1560: END IF;
1561:
1562: IF l_ship_to_loc_code IS NULL THEN
1563: raise fnd_api.g_exc_error;

Line 1582: wsh_debug_sv.log (l_module_name, 'Error at cursor l_get_dates_cur');

1578: --
1579: IF ( l_get_dates_cur % NOTFOUND ) THEN
1580: --
1581: IF l_debug_on THEN
1582: wsh_debug_sv.log (l_module_name, 'Error at cursor l_get_dates_cur');
1583: END IF;
1584: --
1585: CLOSE l_get_dates_cur;
1586: RAISE wsh_invalid_delivery_id;

Line 1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);

1613: NULL;
1614: END; --}
1615: --
1616: IF l_debug_on THEN
1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);
1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);

Line 1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);

1614: END; --}
1615: --
1616: IF l_debug_on THEN
1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);
1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);

Line 1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);

1615: --
1616: IF l_debug_on THEN
1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);
1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);

Line 1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);

1616: IF l_debug_on THEN
1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);
1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);
1624: wsh_debug_sv.pop (l_module_name);

Line 1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);

1617: wsh_debug_sv.log (l_module_name, 'Name' , x_name);
1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);
1624: wsh_debug_sv.pop (l_module_name);
1625: END IF;

Line 1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);

1618: wsh_debug_sv.log (l_module_name, 'Ship To Loc Code' , x_ship_to_loc_code);
1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);
1624: wsh_debug_sv.pop (l_module_name);
1625: END IF;
1626: --

Line 1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);

1619: wsh_debug_sv.log (l_module_name, 'Arrival Date', x_arrival_date);
1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);
1624: wsh_debug_sv.pop (l_module_name);
1625: END IF;
1626: --
1627: EXCEPTION

Line 1624: wsh_debug_sv.pop (l_module_name);

1620: wsh_debug_sv.log (l_module_name, 'Departure Date', x_departure_date);
1621: wsh_debug_sv.log (l_module_name, 'Packing Slip Number' , x_pack_slip_num);
1622: wsh_debug_sv.log (l_module_name, 'BOL Number' , x_bill_of_lading_num);
1623: wsh_debug_sv.log (l_module_name, 'Customer Name' , x_customer_name);
1624: wsh_debug_sv.pop (l_module_name);
1625: END IF;
1626: --
1627: EXCEPTION
1628: WHEN fnd_api.g_exc_error THEN

Line 1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1627: EXCEPTION
1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line 1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');

1628: WHEN fnd_api.g_exc_error THEN
1629: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'fnd_api.g_exc_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:fnd_api.g_exc_error');
1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1636: IF l_debug_on THEN

Line 1637: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1633: END IF;
1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1639: END IF;
1640:
1641: WHEN OTHERS THEN

Line 1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');

1634: WHEN wsh_invalid_delivery_id THEN
1635: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1639: END IF;
1640:
1641: WHEN OTHERS THEN
1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 1644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

1640:
1641: WHEN OTHERS THEN
1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1645: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1647: END IF;
1648: END Get_Stnd_Delivery_Info;

Line 1645: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1641: WHEN OTHERS THEN
1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1645: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1647: END IF;
1648: END Get_Stnd_Delivery_Info;
1649:

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

1642: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1645: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1646: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1647: END IF;
1648: END Get_Stnd_Delivery_Info;
1649:
1650:

Line 1745: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1741: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1742: --
1743: IF l_debug_on IS NULL
1744: THEN
1745: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1746: END IF;
1747: --
1748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1749:

Line 1751: wsh_debug_sv.push(l_module_name);

1747: --
1748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1749:
1750: IF l_debug_on THEN
1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);

Line 1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);

1748: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1749:
1750: IF l_debug_on THEN
1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);

Line 1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);

1749:
1750: IF l_debug_on THEN
1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);

Line 1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);

1750: IF l_debug_on THEN
1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);

Line 1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);

1751: wsh_debug_sv.push(l_module_name);
1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
1759:

Line 1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);

1752: wsh_debug_sv.log(l_module_name, 'p_src_line_id',p_src_line_id);
1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
1759:
1760: END IF;

Line 1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);

1753: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
1759:
1760: END IF;
1761:

Line 1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);

1754: wsh_debug_sv.log(l_module_name, 'p_detail_seq_number',p_detail_seq_number);
1755: wsh_debug_sv.log(l_module_name, 'p_locator_id',p_locator_id);
1756: wsh_debug_sv.log(l_module_name, 'p_serial_type',P_serial_type);
1757: wsh_debug_sv.log(l_module_name, 'p_wsn_rowid',p_wsn_rowid);
1758: wsh_debug_sv.log(l_module_name, 'p_requested_quantity',p_requested_quantity);
1759:
1760: END IF;
1761:
1762: IF (p_locator_id is not null) THEN --{

Line 1776: wsh_debug_sv.log(l_module_name, 'x_locator_code', x_locator_code);

1772: end;
1773: END IF; --}
1774:
1775: IF l_debug_on THEN
1776: wsh_debug_sv.log(l_module_name, 'x_locator_code', x_locator_code);
1777: END IF;
1778:
1779: IF p_detail_seq_number = 1 THEN --{
1780:

Line 1796: wsh_debug_sv.log(l_module_name, 'x_open_quantity', x_open_quantity);

1792: and source_code = 'OE'
1793: and released_status = 'B';
1794:
1795: IF l_debug_on THEN
1796: wsh_debug_sv.log(l_module_name, 'x_open_quantity', x_open_quantity);
1797: wsh_debug_sv.log(l_module_name, 'x_bo_quantity', x_bo_quantity);
1798: END IF;
1799:
1800: END IF; --}

Line 1797: wsh_debug_sv.log(l_module_name, 'x_bo_quantity', x_bo_quantity);

1793: and released_status = 'B';
1794:
1795: IF l_debug_on THEN
1796: wsh_debug_sv.log(l_module_name, 'x_open_quantity', x_open_quantity);
1797: wsh_debug_sv.log(l_module_name, 'x_bo_quantity', x_bo_quantity);
1798: END IF;
1799:
1800: END IF; --}
1801:

Line 1818: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );

1814: FETCH get_rowid_count INTO l_wsn_rowid, l_wsn_count,l_wsn_sum_qty;
1815: CLOSE get_rowid_count;
1816:
1817: IF l_debug_on THEN
1818: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1819: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1820: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1821: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1822: END IF;

Line 1819: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );

1815: CLOSE get_rowid_count;
1816:
1817: IF l_debug_on THEN
1818: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1819: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1820: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1821: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1822: END IF;
1823:

Line 1820: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );

1816:
1817: IF l_debug_on THEN
1818: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1819: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1820: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1821: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1822: END IF;
1823:
1824: IF l_wsn_sum_qty = p_requested_quantity THEN

Line 1821: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );

1817: IF l_debug_on THEN
1818: wsh_debug_sv.log(l_module_name, 'l_wsn_qty',l_wsn_qty );
1819: wsh_debug_sv.log(l_module_name, 'l_wsn_rowid',l_wsn_rowid );
1820: wsh_debug_sv.log(l_module_name, 'l_wsn_count',l_wsn_count );
1821: wsh_debug_sv.log(l_module_name, 'l_wsn_sum_qty',l_wsn_sum_qty );
1822: END IF;
1823:
1824: IF l_wsn_sum_qty = p_requested_quantity THEN
1825: x_requested_quantity :=l_wsn_qty;

Line 1836: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);

1832: END IF;
1833: END IF;
1834:
1835: IF l_debug_on THEN
1836: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1837: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1838: END IF;
1839:
1840: ELSE

Line 1837: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);

1833: END IF;
1834:
1835: IF l_debug_on THEN
1836: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1837: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1838: END IF;
1839:
1840: ELSE
1841: OPEN get_msnt_qty(p_wsn_rowid);

Line 1851: wsh_debug_sv.log(l_module_name, 'l_msnt_qty',l_wsn_qty );

1847: FETCH get_msnt_rowid_count INTO l_wsn_rowid, l_wsn_count,l_wsn_sum_qty;
1848: CLOSE get_msnt_rowid_count;
1849:
1850: IF l_debug_on THEN
1851: wsh_debug_sv.log(l_module_name, 'l_msnt_qty',l_wsn_qty );
1852: wsh_debug_sv.log(l_module_name, 'l_msnt_rowid',l_wsn_rowid );
1853: wsh_debug_sv.log(l_module_name, 'l_msnt_count',l_wsn_count );
1854: wsh_debug_sv.log(l_module_name, 'l_msnt_sum_qty',l_wsn_sum_qty );
1855: END IF;

Line 1852: wsh_debug_sv.log(l_module_name, 'l_msnt_rowid',l_wsn_rowid );

1848: CLOSE get_msnt_rowid_count;
1849:
1850: IF l_debug_on THEN
1851: wsh_debug_sv.log(l_module_name, 'l_msnt_qty',l_wsn_qty );
1852: wsh_debug_sv.log(l_module_name, 'l_msnt_rowid',l_wsn_rowid );
1853: wsh_debug_sv.log(l_module_name, 'l_msnt_count',l_wsn_count );
1854: wsh_debug_sv.log(l_module_name, 'l_msnt_sum_qty',l_wsn_sum_qty );
1855: END IF;
1856:

Line 1853: wsh_debug_sv.log(l_module_name, 'l_msnt_count',l_wsn_count );

1849:
1850: IF l_debug_on THEN
1851: wsh_debug_sv.log(l_module_name, 'l_msnt_qty',l_wsn_qty );
1852: wsh_debug_sv.log(l_module_name, 'l_msnt_rowid',l_wsn_rowid );
1853: wsh_debug_sv.log(l_module_name, 'l_msnt_count',l_wsn_count );
1854: wsh_debug_sv.log(l_module_name, 'l_msnt_sum_qty',l_wsn_sum_qty );
1855: END IF;
1856:
1857: IF l_wsn_sum_qty = p_requested_quantity THEN

Line 1854: wsh_debug_sv.log(l_module_name, 'l_msnt_sum_qty',l_wsn_sum_qty );

1850: IF l_debug_on THEN
1851: wsh_debug_sv.log(l_module_name, 'l_msnt_qty',l_wsn_qty );
1852: wsh_debug_sv.log(l_module_name, 'l_msnt_rowid',l_wsn_rowid );
1853: wsh_debug_sv.log(l_module_name, 'l_msnt_count',l_wsn_count );
1854: wsh_debug_sv.log(l_module_name, 'l_msnt_sum_qty',l_wsn_sum_qty );
1855: END IF;
1856:
1857: IF l_wsn_sum_qty = p_requested_quantity THEN
1858: x_requested_quantity :=l_wsn_qty;

Line 1869: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);

1865: END IF;
1866: END IF;
1867:
1868: IF l_debug_on THEN
1869: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1870: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1871: END IF;
1872:
1873: END IF ;

Line 1870: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);

1866: END IF;
1867:
1868: IF l_debug_on THEN
1869: wsh_debug_sv.log(l_module_name, 'x_shipped_quantity', x_shipped_quantity);
1870: wsh_debug_sv.log(l_module_name, 'x_requested_quantity', x_requested_quantity);
1871: END IF;
1872:
1873: END IF ;
1874: --

Line 1882: wsh_debug_sv.log(l_module_name, 'l_uniq_ship_to_contact_id',

1878: FETCH l_get_contacts_csr INTO l_uniq_ship_to_contact_id;
1879: CLOSE l_get_contacts_csr;
1880:
1881: IF l_debug_on THEN
1882: wsh_debug_sv.log(l_module_name, 'l_uniq_ship_to_contact_id',
1883: l_uniq_ship_to_contact_id);
1884: END IF;
1885:
1886: IF l_uniq_ship_to_contact_id IS NOT NULL THEN --{

Line 1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);

1945: null;
1946: end;
1947:
1948: IF l_debug_on THEN
1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);
1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);

Line 1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);

1946: end;
1947:
1948: IF l_debug_on THEN
1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);
1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);

Line 1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);

1947:
1948: IF l_debug_on THEN
1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);
1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);
1955: wsh_debug_sv.pop(l_module_name);

Line 1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);

1948: IF l_debug_on THEN
1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);
1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);
1955: wsh_debug_sv.pop(l_module_name);
1956: END IF;

Line 1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);

1949: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_name', x_shipto_cont_per_name);
1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);
1955: wsh_debug_sv.pop(l_module_name);
1956: END IF;
1957:

Line 1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);

1950: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_ph', x_shipto_cont_per_ph);
1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);
1955: wsh_debug_sv.pop(l_module_name);
1956: END IF;
1957:
1958: EXCEPTION

Line 1955: wsh_debug_sv.pop(l_module_name);

1951: wsh_debug_sv.log(l_module_name, 'x_shipto_cont_per_id', x_shipto_cont_per_id);
1952: wsh_debug_sv.log(l_module_name, 'x_document_type', x_document_type);
1953: wsh_debug_sv.log(l_module_name, 'x_document_id', x_document_id);
1954: wsh_debug_sv.log(l_module_name, 'x_line_number', x_line_number);
1955: wsh_debug_sv.pop(l_module_name);
1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN

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

1960: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

1961: wsh_util_core.add_message(x_return_status, l_module_name);
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1965: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN

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

1966: END IF;
1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1971: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1972: END IF;
1973:
1974: END Get_Delivery_Detail_Info;

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

1967: WHEN OTHERS THEN
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1971: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1972: END IF;
1973:
1974: END Get_Delivery_Detail_Info;
1975:

Line 2062: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2058: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2059: --
2060: IF l_debug_on IS NULL
2061: THEN
2062: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2063: END IF;
2064: --
2065: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2066:

Line 2068: wsh_debug_sv.push(l_module_name);

2064: --
2065: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2066:
2067: IF l_debug_on THEN
2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);
2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);

Line 2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);

2065: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2066:
2067: IF l_debug_on THEN
2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);
2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);
2073: END IF;

Line 2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);

2066:
2067: IF l_debug_on THEN
2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);
2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);
2073: END IF;
2074:

Line 2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);

2067: IF l_debug_on THEN
2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);
2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);
2073: END IF;
2074:
2075: IF p_partner_type not in ('ShipTo', 'DeliverTo') THEN

Line 2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);

2068: wsh_debug_sv.push(l_module_name);
2069: wsh_debug_sv.log(l_module_name, 'p_delivery_detail_id',p_delivery_detail_id);
2070: wsh_debug_sv.log(l_module_name, 'p_entity_type',p_entity_type);
2071: wsh_debug_sv.log(l_module_name, 'p_org_id',p_org_id);
2072: wsh_debug_sv.log(l_module_name, 'p_partner_type',p_partner_type);
2073: END IF;
2074:
2075: IF p_partner_type not in ('ShipTo', 'DeliverTo') THEN
2076: return;

Line 2149: wsh_debug_sv.log(l_module_name, 'l_site_id', l_site_id);

2145: l_contact_id := l_uniq_deliver_to_contact_id;
2146: END IF;
2147:
2148: IF l_debug_on THEN
2149: wsh_debug_sv.log(l_module_name, 'l_site_id', l_site_id);
2150: wsh_debug_sv.log(l_module_name, 'l_contact_id', l_contact_id);
2151: END IF;
2152:
2153: IF (l_site_id is not null) THEN

Line 2150: wsh_debug_sv.log(l_module_name, 'l_contact_id', l_contact_id);

2146: END IF;
2147:
2148: IF l_debug_on THEN
2149: wsh_debug_sv.log(l_module_name, 'l_site_id', l_site_id);
2150: wsh_debug_sv.log(l_module_name, 'l_contact_id', l_contact_id);
2151: END IF;
2152:
2153: IF (l_site_id is not null) THEN
2154: Get_Cust_addr_Info (

Line 2180: wsh_debug_sv.pop(l_module_name);

2176: x_contact_id := l_contact_id;
2177: END IF;
2178:
2179: IF l_debug_on THEN
2180: wsh_debug_sv.pop(l_module_name);
2181: END IF;
2182:
2183: EXCEPTION
2184: WHEN FND_API.G_EXC_ERROR THEN

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

2185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

2186: wsh_util_core.add_message(x_return_status, l_module_name);
2187: --
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2194: IF l_debug_on THEN

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

2191: END IF;
2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2197: END IF;
2198:
2199: END Get_Detail_Part_addr_Info;

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

2192: WHEN OTHERS THEN
2193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2197: END IF;
2198:
2199: END Get_Detail_Part_addr_Info;
2200:

Line 2273: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2269: BEGIN
2270:
2271: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2272: IF l_debug_on IS NULL THEN
2273: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2274: END IF;
2275:
2276: IF l_debug_on THEN
2277: wsh_debug_sv.push(l_module_name);

Line 2277: wsh_debug_sv.push(l_module_name);

2273: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2274: END IF;
2275:
2276: IF l_debug_on THEN
2277: wsh_debug_sv.push(l_module_name);
2278: wsh_debug_sv.log (l_module_name, 'p_site_id', p_site_id);
2279: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2280: wsh_debug_sv.log (l_module_name, 'p_org_id', p_org_id);
2281: END IF;

Line 2278: wsh_debug_sv.log (l_module_name, 'p_site_id', p_site_id);

2274: END IF;
2275:
2276: IF l_debug_on THEN
2277: wsh_debug_sv.push(l_module_name);
2278: wsh_debug_sv.log (l_module_name, 'p_site_id', p_site_id);
2279: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2280: wsh_debug_sv.log (l_module_name, 'p_org_id', p_org_id);
2281: END IF;
2282:

Line 2279: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);

2275:
2276: IF l_debug_on THEN
2277: wsh_debug_sv.push(l_module_name);
2278: wsh_debug_sv.log (l_module_name, 'p_site_id', p_site_id);
2279: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2280: wsh_debug_sv.log (l_module_name, 'p_org_id', p_org_id);
2281: END IF;
2282:
2283: OPEN c_party_info_cur(p_site_id, p_org_id);

Line 2280: wsh_debug_sv.log (l_module_name, 'p_org_id', p_org_id);

2276: IF l_debug_on THEN
2277: wsh_debug_sv.push(l_module_name);
2278: wsh_debug_sv.log (l_module_name, 'p_site_id', p_site_id);
2279: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2280: wsh_debug_sv.log (l_module_name, 'p_org_id', p_org_id);
2281: END IF;
2282:
2283: OPEN c_party_info_cur(p_site_id, p_org_id);
2284: FETCH c_party_info_cur INTO

Line 2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);

2311: END IF;
2312: END IF;
2313:
2314: IF l_debug_on THEN
2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);
2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);

Line 2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);

2312: END IF;
2313:
2314: IF l_debug_on THEN
2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);
2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);

Line 2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);

2313:
2314: IF l_debug_on THEN
2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);
2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);

Line 2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);

2314: IF l_debug_on THEN
2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);
2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);

Line 2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);

2315: wsh_debug_sv.log(l_module_name, 'x_partner_id', x_partner_id);
2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);

Line 2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);

2316: wsh_debug_sv.log(l_module_name, 'x_partner_name', x_partner_name);
2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);

Line 2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);

2317: wsh_debug_sv.log(l_module_name, 'x_partner_location', x_partner_location);
2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);

Line 2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);

2318: wsh_debug_sv.log(l_module_name, 'x_duns_number', x_duns_number);
2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);

Line 2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);

2319: wsh_debug_sv.log(l_module_name, 'x_address_id', x_address_id);
2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);

Line 2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);

2320: wsh_debug_sv.log(l_module_name, 'x_address1', x_address1);
2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);

Line 2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);

2321: wsh_debug_sv.log(l_module_name, 'x_address2', x_address2);
2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);

Line 2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);

2322: wsh_debug_sv.log(l_module_name, 'x_address3', x_address3);
2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);

Line 2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);

2323: wsh_debug_sv.log(l_module_name, 'x_address4', x_address4);
2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);

Line 2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);

2324: wsh_debug_sv.log(l_module_name, 'x_city', x_city);
2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);
2332: wsh_debug_sv.pop(l_module_name);

Line 2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);

2325: wsh_debug_sv.log(l_module_name, 'x_country', x_country);
2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);
2332: wsh_debug_sv.pop(l_module_name);
2333: END IF;

Line 2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);

2326: wsh_debug_sv.log(l_module_name, 'x_county', x_county);
2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);
2332: wsh_debug_sv.pop(l_module_name);
2333: END IF;
2334:

Line 2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);

2327: wsh_debug_sv.log(l_module_name, 'x_postal_code', x_postal_code);
2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);
2332: wsh_debug_sv.pop(l_module_name);
2333: END IF;
2334:
2335: EXCEPTION

Line 2332: wsh_debug_sv.pop(l_module_name);

2328: wsh_debug_sv.log(l_module_name, 'x_region', x_region);
2329: wsh_debug_sv.log(l_module_name, 'x_state', x_state);
2330: wsh_debug_sv.log(l_module_name, 'x_contact_name', x_contact_name);
2331: wsh_debug_sv.log(l_module_name, 'x_contact_telephone', x_contact_telephone);
2332: wsh_debug_sv.pop(l_module_name);
2333: END IF;
2334:
2335: EXCEPTION
2336: WHEN OTHERS THEN

Line 2340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

2336: WHEN OTHERS THEN
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2338:
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2341: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2343: END IF;
2344: END Get_Cust_addr_Info;

Line 2341: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2338:
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2341: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2343: END IF;
2344: END Get_Cust_addr_Info;
2345:

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

2338:
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2341: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2343: END IF;
2344: END Get_Cust_addr_Info;
2345:
2346: -- R12.1.1 STANDALONE PROJECT

Line 2500: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2496:
2497: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2498: IF l_debug_on IS NULL
2499: THEN
2500: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2501: END IF;
2502:
2503: IF l_debug_on THEN
2504: wsh_debug_sv.push(l_module_name);

Line 2504: wsh_debug_sv.push(l_module_name);

2500: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2501: END IF;
2502:
2503: IF l_debug_on THEN
2504: wsh_debug_sv.push(l_module_name);
2505: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
2506: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
2507: wsh_debug_sv.log (l_module_name, 'Org Id', p_org_id);
2508: END IF;

Line 2505: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);

2501: END IF;
2502:
2503: IF l_debug_on THEN
2504: wsh_debug_sv.push(l_module_name);
2505: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
2506: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
2507: wsh_debug_sv.log (l_module_name, 'Org Id', p_org_id);
2508: END IF;
2509:

Line 2506: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);

2502:
2503: IF l_debug_on THEN
2504: wsh_debug_sv.push(l_module_name);
2505: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
2506: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
2507: wsh_debug_sv.log (l_module_name, 'Org Id', p_org_id);
2508: END IF;
2509:
2510: OPEN c_del_info;

Line 2507: wsh_debug_sv.log (l_module_name, 'Org Id', p_org_id);

2503: IF l_debug_on THEN
2504: wsh_debug_sv.push(l_module_name);
2505: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
2506: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
2507: wsh_debug_sv.log (l_module_name, 'Org Id', p_org_id);
2508: END IF;
2509:
2510: OPEN c_del_info;
2511: FETCH c_del_info INTO l_organization_id, l_init_loc_id, l_intmed_loc_id, l_pooled_loc_id;

Line 2515: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);

2511: FETCH c_del_info INTO l_organization_id, l_init_loc_id, l_intmed_loc_id, l_pooled_loc_id;
2512: CLOSE c_del_info;
2513:
2514: IF l_debug_on THEN
2515: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
2516: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
2517: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
2518: END IF;
2519:

Line 2516: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);

2512: CLOSE c_del_info;
2513:
2514: IF l_debug_on THEN
2515: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
2516: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
2517: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
2518: END IF;
2519:
2520: IF (p_partner_type = 'ShipFrom') THEN --{

Line 2517: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);

2513:
2514: IF l_debug_on THEN
2515: wsh_debug_sv.log (l_module_name, 'Initial Pickup Location Id', l_init_loc_id);
2516: wsh_debug_sv.log (l_module_name, 'Intmed ShipTo Location Id', l_intmed_loc_id);
2517: wsh_debug_sv.log (l_module_name, 'Pooled ShipTo Location Id', l_pooled_loc_id);
2518: END IF;
2519:
2520: IF (p_partner_type = 'ShipFrom') THEN --{
2521: OPEN ship_from_info_cur(l_organization_id, l_init_loc_id);

Line 2629: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);

2625: END IF;
2626: END IF;
2627:
2628: IF l_debug_on THEN
2629: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);
2630: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
2631: END IF;
2632:
2633: ELSIF(p_partner_type = 'BillTo') THEN

Line 2630: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);

2626: END IF;
2627:
2628: IF l_debug_on THEN
2629: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);
2630: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
2631: END IF;
2632:
2633: ELSIF(p_partner_type = 'BillTo') THEN
2634:

Line 2689: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);

2685: END IF;
2686: END IF; --}
2687:
2688: IF l_debug_on THEN
2689: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);
2690: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
2691: END IF;
2692:
2693: END IF;

Line 2690: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);

2686: END IF; --}
2687:
2688: IF l_debug_on THEN
2689: wsh_debug_sv.log (l_module_name, 'x_telephone,x_contact_name', x_telephone||','||x_contact_name);
2690: wsh_debug_sv.log (l_module_name, 'l_return_status', l_return_status);
2691: END IF;
2692:
2693: END IF;
2694:

Line 2696: wsh_debug_sv.pop(l_module_name);

2692:
2693: END IF;
2694:
2695: IF l_debug_on THEN
2696: wsh_debug_sv.pop(l_module_name);
2697: END IF;
2698:
2699: EXCEPTION
2700: WHEN OTHERS THEN

Line 2704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

2700: WHEN OTHERS THEN
2701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2702:
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2705: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2707: END IF;
2708: END get_del_part_addr_info;

Line 2705: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2702:
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2705: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2707: END IF;
2708: END get_del_part_addr_info;
2709:

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

2702:
2703: IF l_debug_on THEN
2704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2705: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2706: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2707: END IF;
2708: END get_del_part_addr_info;
2709:
2710: -- TPW - Distributed Organization Changes

Line 2766: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2762: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2763: --
2764: IF l_debug_on IS NULL
2765: THEN
2766: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2767: END IF;
2768: --
2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2770: IF l_debug_on THEN

Line 2771: wsh_debug_sv.push(l_module_name);

2767: END IF;
2768: --
2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2770: IF l_debug_on THEN
2771: wsh_debug_sv.push(l_module_name);
2772: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2773: END IF;
2774:
2775: open l_ship_to_site_contact_csr(p_contact_id);

Line 2772: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);

2768: --
2769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2770: IF l_debug_on THEN
2771: wsh_debug_sv.push(l_module_name);
2772: wsh_debug_sv.log (l_module_name, 'p_contact_id', p_contact_id);
2773: END IF;
2774:
2775: open l_ship_to_site_contact_csr(p_contact_id);
2776: fetch l_ship_to_site_contact_csr into l_per_first_name,

Line 2800: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',

2796: --{
2797: x_contact_person_name := x_contact_person_name || l_per_last_name; --}
2798: END IF;
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',
2801: x_per_ph_number);
2802: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',
2803: l_owner_table_id);
2804: END IF;

Line 2802: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',

2798: END IF;
2799: IF l_debug_on THEN
2800: WSH_DEBUG_SV.log (L_MODULE_NAME,' Contact Person Phone Number ',
2801: x_per_ph_number);
2802: WSH_DEBUG_SV.log (L_MODULE_NAME,' l_owner_table_id ',
2803: l_owner_table_id);
2804: END IF;
2805:
2806: IF x_per_ph_number IS NULL

Line 2818: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);

2814: END IF;
2815:
2816:
2817: IF l_debug_on THEN
2818: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
2819: wsh_debug_sv.log (l_module_name, 'x_contact_person_name', x_contact_person_name);
2820: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
2821: wsh_debug_sv.pop(l_module_name);
2822: END IF;

Line 2819: wsh_debug_sv.log (l_module_name, 'x_contact_person_name', x_contact_person_name);

2815:
2816:
2817: IF l_debug_on THEN
2818: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
2819: wsh_debug_sv.log (l_module_name, 'x_contact_person_name', x_contact_person_name);
2820: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
2821: wsh_debug_sv.pop(l_module_name);
2822: END IF;
2823:

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

2816:
2817: IF l_debug_on THEN
2818: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
2819: wsh_debug_sv.log (l_module_name, 'x_contact_person_name', x_contact_person_name);
2820: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
2821: wsh_debug_sv.pop(l_module_name);
2822: END IF;
2823:
2824: EXCEPTION

Line 2821: wsh_debug_sv.pop(l_module_name);

2817: IF l_debug_on THEN
2818: wsh_debug_sv.log (l_module_name, 'x_per_ph_number', x_per_ph_number);
2819: wsh_debug_sv.log (l_module_name, 'x_contact_person_name', x_contact_person_name);
2820: wsh_debug_sv.log (l_module_name, 'x_return_status', x_return_status);
2821: wsh_debug_sv.pop(l_module_name);
2822: END IF;
2823:
2824: EXCEPTION
2825: WHEN OTHERS THEN

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

2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2827: IF l_debug_on THEN
2828: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2830: END IF;
2831: END get_name_number;
2832:

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

2825: WHEN OTHERS THEN
2826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2827: IF l_debug_on THEN
2828: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM, WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2829: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2830: END IF;
2831: END get_name_number;
2832:
2833: PROCEDURE get_ship_method_details(

Line 2850: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2846: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2847: --
2848: IF l_debug_on IS NULL
2849: THEN
2850: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2851: END IF;
2852: --
2853: IF l_debug_on THEN
2854: WSH_DEBUG_SV.push(l_module_name);

Line 2854: WSH_DEBUG_SV.push(l_module_name);

2850: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2851: END IF;
2852: --
2853: IF l_debug_on THEN
2854: WSH_DEBUG_SV.push(l_module_name);
2855: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code', p_ship_method_code);
2856: END IF;
2857: --
2858: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2855: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code', p_ship_method_code);

2851: END IF;
2852: --
2853: IF l_debug_on THEN
2854: WSH_DEBUG_SV.push(l_module_name);
2855: WSH_DEBUG_SV.log(l_module_name, 'p_ship_method_code', p_ship_method_code);
2856: END IF;
2857: --
2858: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2859:

Line 2869: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

2865: and wcs.ship_method_code = p_ship_method_code;
2866:
2867: --
2868: IF l_debug_on THEN
2869: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
2870: WSH_DEBUG_SV.pop(l_module_name);
2871: END IF;
2872: --
2873: EXCEPTION

Line 2870: WSH_DEBUG_SV.pop(l_module_name);

2866:
2867: --
2868: IF l_debug_on THEN
2869: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
2870: WSH_DEBUG_SV.pop(l_module_name);
2871: END IF;
2872: --
2873: EXCEPTION
2874: WHEN others THEN

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

2874: WHEN others THEN
2875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2876: --
2877: IF l_debug_on THEN
2878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2880: END IF;
2881: --
2882: END Get_Ship_Method_Details;

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

2875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2876: --
2877: IF l_debug_on THEN
2878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2880: END IF;
2881: --
2882: END Get_Ship_Method_Details;
2883:

Line 2972: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2968: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2969: --
2970: IF l_debug_on IS NULL
2971: THEN
2972: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2973: END IF;
2974: --
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.push(l_module_name);

Line 2976: WSH_DEBUG_SV.push(l_module_name);

2972: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2973: END IF;
2974: --
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.push(l_module_name);
2977: WSH_DEBUG_SV.log(l_module_name, 'p_partner_type', p_partner_type);
2978: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
2979: END IF;
2980: --

Line 2977: WSH_DEBUG_SV.log(l_module_name, 'p_partner_type', p_partner_type);

2973: END IF;
2974: --
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.push(l_module_name);
2977: WSH_DEBUG_SV.log(l_module_name, 'p_partner_type', p_partner_type);
2978: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
2979: END IF;
2980: --
2981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2978: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);

2974: --
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.push(l_module_name);
2977: WSH_DEBUG_SV.log(l_module_name, 'p_partner_type', p_partner_type);
2978: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
2979: END IF;
2980: --
2981: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2982:

Line 3110: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

3106: END IF;
3107:
3108: --
3109: IF l_debug_on THEN
3110: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
3111: WSH_DEBUG_SV.pop(l_module_name);
3112: END IF;
3113: --
3114: EXCEPTION

Line 3111: WSH_DEBUG_SV.pop(l_module_name);

3107:
3108: --
3109: IF l_debug_on THEN
3110: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
3111: WSH_DEBUG_SV.pop(l_module_name);
3112: END IF;
3113: --
3114: EXCEPTION
3115: WHEN FND_API.G_EXC_ERROR THEN

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

3115: WHEN FND_API.G_EXC_ERROR THEN
3116: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3117: --
3118: IF l_debug_on THEN
3119: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3120: END IF;
3121: --
3122: WHEN others THEN
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

3122: WHEN others THEN
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124: --
3125: IF l_debug_on THEN
3126: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3128: END IF;
3129: --
3130: END Get_Batch_Addr_Info;

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

3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124: --
3125: IF l_debug_on THEN
3126: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3128: END IF;
3129: --
3130: END Get_Batch_Addr_Info;
3131:

Line 3170: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3166: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3167: --
3168: IF l_debug_on IS NULL
3169: THEN
3170: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3171: END IF;
3172: --
3173: IF l_debug_on THEN
3174: WSH_DEBUG_SV.push(l_module_name);

Line 3174: WSH_DEBUG_SV.push(l_module_name);

3170: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3171: END IF;
3172: --
3173: IF l_debug_on THEN
3174: WSH_DEBUG_SV.push(l_module_name);
3175: WSH_DEBUG_SV.log(l_module_name, 'p_reference_line_id', p_reference_line_id);
3176: END IF;
3177: --
3178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3175: WSH_DEBUG_SV.log(l_module_name, 'p_reference_line_id', p_reference_line_id);

3171: END IF;
3172: --
3173: IF l_debug_on THEN
3174: WSH_DEBUG_SV.push(l_module_name);
3175: WSH_DEBUG_SV.log(l_module_name, 'p_reference_line_id', p_reference_line_id);
3176: END IF;
3177: --
3178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3179:

Line 3243: WSH_DEBUG_SV.logmsg(l_module_name, 'Converting Unit Selling Price based on Primary UOM of Inventory Item');

3239: -- calculate Unit Selling Price based on Item's Primary UOM.
3240: if ( x_line_quantity_uom <> l_req_qty_uom ) then
3241: --
3242: IF l_debug_on THEN
3243: WSH_DEBUG_SV.logmsg(l_module_name, 'Converting Unit Selling Price based on Primary UOM of Inventory Item');
3244: END IF;
3245: --
3246: x_unit_selling_price := ROUND(x_unit_selling_price * WSH_WV_UTILS.CONVERT_UOM(l_req_qty_uom, x_line_quantity_uom, 1, l_inv_item_id),2);
3247: end if;

Line 3250: WSH_DEBUG_SV.logmsg(l_module_name, 'x_line_quantity '||x_line_quantity||' x_line_quantity_uom '||x_line_quantity_uom);

3246: x_unit_selling_price := ROUND(x_unit_selling_price * WSH_WV_UTILS.CONVERT_UOM(l_req_qty_uom, x_line_quantity_uom, 1, l_inv_item_id),2);
3247: end if;
3248: --
3249: IF l_debug_on THEN
3250: WSH_DEBUG_SV.logmsg(l_module_name, 'x_line_quantity '||x_line_quantity||' x_line_quantity_uom '||x_line_quantity_uom);
3251: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
3252: WSH_DEBUG_SV.pop(l_module_name);
3253: END IF;
3254: --

Line 3251: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);

3247: end if;
3248: --
3249: IF l_debug_on THEN
3250: WSH_DEBUG_SV.logmsg(l_module_name, 'x_line_quantity '||x_line_quantity||' x_line_quantity_uom '||x_line_quantity_uom);
3251: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
3252: WSH_DEBUG_SV.pop(l_module_name);
3253: END IF;
3254: --
3255: EXCEPTION

Line 3252: WSH_DEBUG_SV.pop(l_module_name);

3248: --
3249: IF l_debug_on THEN
3250: WSH_DEBUG_SV.logmsg(l_module_name, 'x_line_quantity '||x_line_quantity||' x_line_quantity_uom '||x_line_quantity_uom);
3251: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
3252: WSH_DEBUG_SV.pop(l_module_name);
3253: END IF;
3254: --
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN

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

3256: WHEN FND_API.G_EXC_ERROR THEN
3257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3258: --
3259: IF l_debug_on THEN
3260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3261: END IF;
3262: --
3263: WHEN others THEN
3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

3263: WHEN others THEN
3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3265: --
3266: IF l_debug_on THEN
3267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3269: END IF;
3270: --
3271: END get_detail_line_info;

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

3264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3265: --
3266: IF l_debug_on THEN
3267: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3269: END IF;
3270: --
3271: END get_detail_line_info;
3272: