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 201: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 205: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 370: wsh_debug_sv.pop (l_module_name);

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

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

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

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

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

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

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

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

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

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

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

Line 391: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 513: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 517: wsh_debug_sv.push(l_module_name);

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

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

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

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

515: --
516: IF l_debug_on THEN
517: wsh_debug_sv.push(l_module_name);
518: wsh_debug_sv.log (l_module_name, 'Partner Type', p_partner_type);
519: wsh_debug_sv.log (l_module_name, 'Delivery Id', p_delivery_id);
520: END IF;
521:
522: OPEN loc_ids_cur;
523: 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 527: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);

523: 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;
524: CLOSE loc_ids_cur;
525:
526: IF l_debug_on THEN
527: wsh_debug_sv.logmsg(l_module_name, 'Calling program unit WSH_UTIL_CORE.GET_OPERATINGUNIT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
528: END IF;
529:
530: /* Patchset I: Locations Project. Get the OperatingUnit Id */
531: l_opUnit_id := wsh_util_core.get_OperatingUnit_id(p_delivery_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 633: wsh_debug_sv.pop(l_module_name);

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

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

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

Line 641: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 679: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 683: wsh_debug_sv.push(l_module_name);

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

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

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

Line 696: wsh_debug_sv.pop(l_module_name);

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

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

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

Line 704: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 753: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 757: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 786: wsh_debug_sv.pop(l_module_name);

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

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

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

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

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

Line 980: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 986: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: