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

Line 55: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

51: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
52: --
53: IF l_debug_on IS NULL
54: THEN
55: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
56: END IF;
57: --
58: IF (p_doctype = 'SA') --{ K proj
59: OR

Line 382: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

378: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
379: --
380: IF l_debug_on IS NULL
381: THEN
382: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
383: END IF;
384: --
385: wsh_debug_sv.start_debug;
386:

Line 385: wsh_debug_sv.start_debug;

381: THEN
382: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
383: END IF;
384: --
385: wsh_debug_sv.start_debug;
386:
387: IF l_debug_on THEN
388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');

Line 388: wsh_debug_sv.push (l_module_name);

384: --
385: wsh_debug_sv.start_debug;
386:
387: IF l_debug_on THEN
388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));

Line 389: wsh_debug_sv.log(l_module_name,'Parameters');

385: wsh_debug_sv.start_debug;
386:
387: IF l_debug_on THEN
388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));

Line 390: wsh_debug_sv.log(l_module_name,'==========');

386:
387: IF l_debug_on THEN
388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));

Line 391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));

387: IF l_debug_on THEN
388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);

Line 392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));

388: wsh_debug_sv.push (l_module_name);
389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);

Line 393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));

389: wsh_debug_sv.log(l_module_name,'Parameters');
390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);

Line 394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));

390: wsh_debug_sv.log(l_module_name,'==========');
391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);

Line 395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);

391: wsh_debug_sv.log (l_module_name,'p_organization_id',to_char(p_organization_id));
392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);

Line 396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);

392: wsh_debug_sv.log (l_module_name,'p_carrier_id',to_char(p_carrier_id));
393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);

Line 397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);

393: wsh_debug_sv.log (l_module_name,'p_customer_id',to_char(p_customer_id));
394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'

Line 398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);

394: wsh_debug_sv.log (l_module_name,'p_customer_ship_to_id',to_char(p_customer_ship_to_id));
395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'
402: ,p_src_header_num_from);

Line 399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);

395: wsh_debug_sv.log (l_module_name,'p_scheduled_from_date',p_scheduled_from_date);
396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'
402: ,p_src_header_num_from);
403: wsh_debug_sv.log (l_module_name,'p_src_header_num_to'

Line 400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);

396: wsh_debug_sv.log (l_module_name,'p_scheduled_to_date',p_scheduled_to_date);
397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'
402: ,p_src_header_num_from);
403: wsh_debug_sv.log (l_module_name,'p_src_header_num_to'
404: ,p_src_header_num_to);

Line 401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'

397: wsh_debug_sv.log (l_module_name,'p_autopack',p_autopack);
398: wsh_debug_sv.log (l_module_name,'p_log_level',p_log_level);
399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'
402: ,p_src_header_num_from);
403: wsh_debug_sv.log (l_module_name,'p_src_header_num_to'
404: ,p_src_header_num_to);
405: END IF;

Line 403: wsh_debug_sv.log (l_module_name,'p_src_header_num_to'

399: wsh_debug_sv.log (l_module_name,'p_shipment_type',p_shipment_type);
400: wsh_debug_sv.log (l_module_name,'p_doctype',p_doctype);
401: wsh_debug_sv.log (l_module_name,'p_src_header_num_from'
402: ,p_src_header_num_from);
403: wsh_debug_sv.log (l_module_name,'p_src_header_num_to'
404: ,p_src_header_num_to);
405: END IF;
406:
407:

Line 412: wsh_debug_sv.log (l_module_name, 'Begining of FOR LOOP');

408:
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
410:
411: IF l_debug_on THEN
412: wsh_debug_sv.log (l_module_name, 'Begining of FOR LOOP');
413: END IF;
414: --Open the cursor based on p_shipment_type and p_doctype
415: IF p_doctype = 'SA' THEN
416: OPEN c_shipment_advice_del;

Line 443: wsh_debug_sv.log (l_module_name,' ');

439: EXIT;
440: END IF;
441: END IF;
442: IF l_debug_on THEN
443: wsh_debug_sv.log (l_module_name,' ');
444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);

Line 444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);

440: END IF;
441: END IF;
442: IF l_debug_on THEN
443: wsh_debug_sv.log (l_module_name,' ');
444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);
448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);

Line 445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);

441: END IF;
442: IF l_debug_on THEN
443: wsh_debug_sv.log (l_module_name,' ');
444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);
448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);
449: END IF;

Line 446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);

442: IF l_debug_on THEN
443: wsh_debug_sv.log (l_module_name,' ');
444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);
448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);
449: END IF;
450:

Line 447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);

443: wsh_debug_sv.log (l_module_name,' ');
444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);
448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);
449: END IF;
450:
451: SAVEPOINT start_process_delivery;

Line 448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);

444: wsh_debug_sv.log (l_module_name,'Delivery_id',l_cur_rec.delivery_id);
445: wsh_debug_sv.log (l_module_name,'organization_id',l_cur_rec.organization_id);
446: wsh_debug_sv.log (l_module_name,'Carrier_Id',l_cur_rec.carrier_id);
447: wsh_debug_sv.log (l_module_name,'Customer_Id',l_cur_rec.customer_id);
448: wsh_debug_sv.log (l_module_name,'Ship_To',l_cur_rec.ultimate_dropoff_location_id);
449: END IF;
450:
451: SAVEPOINT start_process_delivery;
452:

Line 476: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);

472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: END ;
474:
475: IF l_debug_on THEN
476: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);
477: END IF;
478:
479: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {
480:

Line 490: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_VALIDATIONS.Check_Pack Return Status',l_return_status);

486: p_delivery_id => l_entity_ids(1),
487: x_return_status => l_return_status);
488:
489: IF l_debug_on THEN
490: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_VALIDATIONS.Check_Pack Return Status',l_return_status);
491: END IF;
492:
493: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --3.IF {
494:

Line 505: wsh_debug_sv.log (l_module_name,'WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery Return Status',

501: x_cont_instance_tab => l_con_ids,
502: x_return_status => l_return_status);
503:
504: IF l_debug_on THEN
505: wsh_debug_sv.log (l_module_name,'WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery Return Status',
506: l_return_status);
507: END IF;
508:
509: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF

Line 539: wsh_debug_sv.log (l_module_name,'WSH_TRANSACTIONS_UTIL.Send_Document Return Status',l_return_status);

535: p_organization_id => l_cur_rec.organization_id,
536: x_return_status => l_return_status);
537:
538: IF l_debug_on THEN
539: wsh_debug_sv.log (l_module_name,'WSH_TRANSACTIONS_UTIL.Send_Document Return Status',l_return_status);
540: END IF;
541:
542: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{
543: l_delivery_status := 'ERROR';

Line 562: wsh_debug_sv.log (l_module_name,'l_msg_summary: ',l_msg_summary);

558: l_msg_details := NULL;
559: END IF;
560:
561: IF l_debug_on THEN
562: wsh_debug_sv.log (l_module_name,'l_msg_summary: ',l_msg_summary);
563: wsh_debug_sv.log (l_module_name,'l_msg_details: ',l_msg_details);
564: wsh_debug_sv.log (l_module_name,'l_msg_count: ',l_msg_count);
565: END IF;
566: FND_MSG_PUB.initialize;

Line 563: wsh_debug_sv.log (l_module_name,'l_msg_details: ',l_msg_details);

559: END IF;
560:
561: IF l_debug_on THEN
562: wsh_debug_sv.log (l_module_name,'l_msg_summary: ',l_msg_summary);
563: wsh_debug_sv.log (l_module_name,'l_msg_details: ',l_msg_details);
564: wsh_debug_sv.log (l_module_name,'l_msg_count: ',l_msg_count);
565: END IF;
566: FND_MSG_PUB.initialize;
567:

Line 564: wsh_debug_sv.log (l_module_name,'l_msg_count: ',l_msg_count);

560:
561: IF l_debug_on THEN
562: wsh_debug_sv.log (l_module_name,'l_msg_summary: ',l_msg_summary);
563: wsh_debug_sv.log (l_module_name,'l_msg_details: ',l_msg_details);
564: wsh_debug_sv.log (l_module_name,'l_msg_count: ',l_msg_count);
565: END IF;
566: FND_MSG_PUB.initialize;
567:
568: IF (l_delivery_status = 'SUCCESS' ) THEN --{

Line 571: wsh_debug_sv.log (l_module_name,'Success l_warning_index: ',l_warning_index);

567:
568: IF (l_delivery_status = 'SUCCESS' ) THEN --{
569:
570: IF l_debug_on THEN
571: wsh_debug_sv.log (l_module_name,'Success l_warning_index: ',l_warning_index);
572: END IF;
573:
574: --Start of bug 4070732
575: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

576:
577: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
578:
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:
583: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
584: x_return_status => l_return_status);

Line 587: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

583: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
584: x_return_status => l_return_status);
585:
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
588: END IF;
589: wsh_util_core.api_post_call
590: (
591: p_return_status => l_return_status,

Line 602: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');

598: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
599: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
600: IF ( l_warning_index > 0 ) THEN --{
601: IF l_debug_on THEN
602: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');
603: END IF;
604: l_warning_count := l_warning_count+1;
605: l_warning_delivery(l_warning_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
606: l_warning_delivery(l_warning_count).msg_summary := l_msg_summary;

Line 610: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS');

606: l_warning_delivery(l_warning_count).msg_summary := l_msg_summary;
607: l_warning_delivery(l_warning_count).msg_details := l_msg_details;
608: ELSE --}{
609: IF l_debug_on THEN
610: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS');
611: END IF;
612: l_success_count := l_success_count+1;
613: l_success_delivery(l_success_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
614: l_success_delivery(l_success_count).msg_summary := l_msg_summary;

Line 624: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');

620: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
621: COMMIT;
622: ELSE --}{
623: IF l_debug_on THEN
624: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
625: END IF;
626: l_error_count := l_error_count+1;
627: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
628: l_error_delivery(l_error_count).msg_summary := l_msg_summary;

Line 634: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');

630: ROLLBACK TO SAVEPOINT start_process_delivery;
631: END IF; --}
632: ELSE --}{
633: IF l_debug_on THEN
634: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');
635: END IF;
636: l_error_count := l_error_count+1;
637: l_error_delivery(l_error_count).delivery_name := wsh_new_deliveries_pvt.get_name(l_entity_ids(1));
638: l_error_delivery(l_error_count).msg_summary := l_msg_summary;

Line 650: wsh_debug_sv.log(l_module_name,'All Deliveries selected are having error');

646: IF l_error_count > 0 THEN
647: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
648: IF l_delivery_count = l_error_count THEN
649: IF l_debug_on THEN
650: wsh_debug_sv.log(l_module_name,'All Deliveries selected are having error');
651: END IF;
652: END IF;
653: END IF;
654:

Line 732: wsh_debug_sv.log(l_module_name,l_msg_summary);

728: FND_FILE.put_line(FND_FILE.output,' ');
729: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DEL_FOR_PARAMETERS');
730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
731: IF l_debug_on THEN
732: wsh_debug_sv.log(l_module_name,l_msg_summary);
733: END IF;
734:
735: ELSE
736: FND_FILE.put_line(FND_FILE.output,' ');

Line 742: wsh_debug_sv.log (l_module_name,'All Deliveries: ',l_delivery_count);

738: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
739:
740: FND_FILE.put_line(FND_FILE.output,'==============');
741: IF l_debug_on THEN
742: wsh_debug_sv.log (l_module_name,'All Deliveries: ',l_delivery_count);
743: END IF;
744: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ALL_DLVY');
745: FND_MESSAGE.SET_TOKEN('ALL_DLVY', to_char(l_delivery_count));
746: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 749: wsh_debug_sv.log (l_module_name,'Success Deliveries: ',l_success_count);

745: FND_MESSAGE.SET_TOKEN('ALL_DLVY', to_char(l_delivery_count));
746: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
747:
748: IF l_debug_on THEN
749: wsh_debug_sv.log (l_module_name,'Success Deliveries: ',l_success_count);
750: END IF;
751: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SUC_DLVY');
752: FND_MESSAGE.SET_TOKEN('SUC_DLVY', to_char(l_success_count));
753: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 756: wsh_debug_sv.log (l_module_name,'Warning Deliveries: ',l_warning_count);

752: FND_MESSAGE.SET_TOKEN('SUC_DLVY', to_char(l_success_count));
753: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
754:
755: IF l_debug_on THEN
756: wsh_debug_sv.log (l_module_name,'Warning Deliveries: ',l_warning_count);
757: END IF;
758: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_WAR_DLVY');
759: FND_MESSAGE.SET_TOKEN('WAR_DLVY', to_char(l_warning_count));
760: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 763: wsh_debug_sv.log (l_module_name,'Error Deliveries: ',l_error_count);

759: FND_MESSAGE.SET_TOKEN('WAR_DLVY', to_char(l_warning_count));
760: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
761:
762: IF l_debug_on THEN
763: wsh_debug_sv.log (l_module_name,'Error Deliveries: ',l_error_count);
764: END IF;
765: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ERR_DLVY');
766: FND_MESSAGE.SET_TOKEN('ERR_DLVY', to_char(l_error_count));
767: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 774: wsh_debug_sv.log(l_module_name,'Success Deliveries');

770: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HS_DLVY');
771: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
772:
773: IF l_debug_on THEN
774: wsh_debug_sv.log(l_module_name,'Success Deliveries');
775: END IF;
776: FOR s_count IN 1..l_success_count LOOP
777: IF (s_count <> 1) THEN
778: FND_FILE.put(FND_FILE.output,',');

Line 780: wsh_debug_sv.log(l_module_name,',');

776: FOR s_count IN 1..l_success_count LOOP
777: IF (s_count <> 1) THEN
778: FND_FILE.put(FND_FILE.output,',');
779: IF l_debug_on THEN
780: wsh_debug_sv.log(l_module_name,',');
781: END IF;
782: END IF;
783: FND_FILE.put(FND_FILE.output,l_success_delivery(s_count).delivery_name);
784: IF l_debug_on THEN

Line 785: wsh_debug_sv.log (l_module_name,' ',l_success_delivery(s_count).delivery_name);

781: END IF;
782: END IF;
783: FND_FILE.put(FND_FILE.output,l_success_delivery(s_count).delivery_name);
784: IF l_debug_on THEN
785: wsh_debug_sv.log (l_module_name,' ',l_success_delivery(s_count).delivery_name);
786: END IF;
787: END LOOP;
788:
789: IF l_debug_on THEN

Line 790: wsh_debug_sv.log(l_module_name,'Warning Deliveries');

786: END IF;
787: END LOOP;
788:
789: IF l_debug_on THEN
790: wsh_debug_sv.log(l_module_name,'Warning Deliveries');
791: END IF;
792: FND_FILE.put_line(FND_FILE.output,' ');
793: FND_FILE.put_line(FND_FILE.output,' ');
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HW_DLVY');

Line 799: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).delivery_name||': '||

795: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
796:
797: FOR w_count IN 1..l_warning_count LOOP
798: IF l_debug_on THEN
799: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).delivery_name||': '||
800: l_warning_delivery(w_count).msg_summary);
801: END IF;
802: FND_FILE.put_line(FND_FILE.output,l_warning_delivery(w_count).delivery_name||': '
803: ||l_warning_delivery(w_count).msg_summary);

Line 807: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).msg_details);

803: ||l_warning_delivery(w_count).msg_summary);
804:
805: IF (l_warning_delivery(w_count).msg_details IS NOT NULL ) THEN
806: IF l_debug_on THEN
807: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).msg_details);
808: END IF;
809: FND_FILE.put_line(FND_FILE.output,' '||l_warning_delivery(w_count).msg_details);
810: END IF;
811: END LOOP;

Line 814: wsh_debug_sv.log(l_module_name,'Error Deliveries');

810: END IF;
811: END LOOP;
812:
813: IF l_debug_on THEN
814: wsh_debug_sv.log(l_module_name,'Error Deliveries');
815: END IF;
816: FND_FILE.put_line(FND_FILE.output,' ');
817: FND_FILE.put_line(FND_FILE.output,' ');
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HE_DLVY');

Line 823: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).delivery_name||': '||

819: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
820:
821: FOR e_count IN 1..l_error_count LOOP
822: IF l_debug_on THEN
823: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).delivery_name||': '||
824: l_error_delivery(e_count).msg_summary);
825: END IF;
826: FND_FILE.put_line(FND_FILE.output,l_error_delivery(e_count).delivery_name||': '
827: ||l_error_delivery(e_count).msg_summary);

Line 831: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).msg_details);

827: ||l_error_delivery(e_count).msg_summary);
828:
829: IF (l_error_delivery(e_count).msg_details IS NOT NULL) THEN
830: IF l_debug_on THEN
831: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).msg_details);
832: END IF;
833: FND_FILE.put_line(FND_FILE.output,' '||l_error_delivery(e_count).msg_details);
834: END IF;
835: END LOOP;

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

841: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
842: THEN --{
843: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
846: END IF;
847: WSH_UTIL_CORE.Process_stops_for_load_tender(
848: p_reset_flags => TRUE,
849: x_return_status => l_return_status);

Line 851: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

847: WSH_UTIL_CORE.Process_stops_for_load_tender(
848: p_reset_flags => TRUE,
849: x_return_status => l_return_status);
850: IF l_debug_on THEN
851: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
852: END IF;
853:
854:
855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

Line 874: wsh_debug_sv.pop(l_module_name);

870:
871: --}
872: --End of bug 4070732
873: IF l_debug_on THEN
874: wsh_debug_sv.pop(l_module_name);
875: END IF;
876: wsh_debug_sv.stop_debug;
877:
878: EXCEPTION

Line 876: wsh_debug_sv.stop_debug;

872: --End of bug 4070732
873: IF l_debug_on THEN
874: wsh_debug_sv.pop(l_module_name);
875: END IF;
876: wsh_debug_sv.stop_debug;
877:
878: EXCEPTION
879:
880: WHEN others THEN

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

886:
887: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
888: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
891: END IF;
892:
893: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
894: x_return_status => l_return_status);

Line 896: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

892:
893: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
894: x_return_status => l_return_status);
895: IF l_debug_on THEN
896: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
897: END IF;
898:
899: END IF;
900: END IF;

Line 904: wsh_debug_sv.log(l_module_name,l_msg_summary);

900: END IF;
901: --End of bug 4070732
902:
903: IF l_debug_on THEN
904: wsh_debug_sv.log(l_module_name,l_msg_summary);
905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);
906: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);

901: --End of bug 4070732
902:
903: IF l_debug_on THEN
904: wsh_debug_sv.log(l_module_name,l_msg_summary);
905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);
906: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
909: END IF;

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

902:
903: IF l_debug_on THEN
904: wsh_debug_sv.log(l_module_name,l_msg_summary);
905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);
906: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
909: END IF;
910:

Line 907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

903: IF l_debug_on THEN
904: wsh_debug_sv.log(l_module_name,l_msg_summary);
905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);
906: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
909: END IF;
910:
911: END Process_Auto_Manifest;

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

904: wsh_debug_sv.log(l_module_name,l_msg_summary);
905: wsh_debug_sv.log(l_module_name,'Calling API :'||l_calling_api);
906: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
907: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
908: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
909: END IF;
910:
911: END Process_Auto_Manifest;
912:

Line 951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

947: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
948: --
949: IF l_debug_on IS NULL
950: THEN
951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
952: END IF;
953: --
954: IF l_debug_on THEN
955: wsh_debug_sv.push (l_module_name);

Line 955: wsh_debug_sv.push (l_module_name);

951: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
952: END IF;
953: --
954: IF l_debug_on THEN
955: wsh_debug_sv.push (l_module_name);
956: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
957: END IF;
958:
959: OPEN c_lock_delivery;

Line 956: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);

952: END IF;
953: --
954: IF l_debug_on THEN
955: wsh_debug_sv.push (l_module_name);
956: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
957: END IF;
958:
959: OPEN c_lock_delivery;
960: FETCH c_lock_delivery INTO l_delivery_id,l_status_code;

Line 965: wsh_debug_sv.pop(l_module_name);

961: CLOSE c_lock_delivery;
962:
963: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
964: IF l_debug_on THEN
965: wsh_debug_sv.pop(l_module_name);
966: END IF;
967: EXCEPTION
968: WHEN RECORD_LOCKED THEN
969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 973: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
970: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
971: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
975: END IF;
976:
977: WHEN others THEN

Line 974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

970: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
971: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
975: END IF;
976:
977: WHEN others THEN
978: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

978: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
979: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
980:
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
983: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986:

Line 983: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

979: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
980:
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
983: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986:
987: END Lock_Manifest_Delivery;

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

980:
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
983: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986:
987: END Lock_Manifest_Delivery;
988:

Line 1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1043: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1044: --
1045: IF l_debug_on IS NULL
1046: THEN
1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1048: END IF;
1049: --
1050: IF l_debug_on THEN
1051: wsh_debug_sv.push (l_module_name);

Line 1051: wsh_debug_sv.push (l_module_name);

1047: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1048: END IF;
1049: --
1050: IF l_debug_on THEN
1051: wsh_debug_sv.push (l_module_name);
1052: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
1053: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_FROM_DATE',p_scheduled_from_date);
1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1055: END IF;

Line 1052: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);

1048: END IF;
1049: --
1050: IF l_debug_on THEN
1051: wsh_debug_sv.push (l_module_name);
1052: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
1053: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_FROM_DATE',p_scheduled_from_date);
1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1055: END IF;
1056:

Line 1053: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_FROM_DATE',p_scheduled_from_date);

1049: --
1050: IF l_debug_on THEN
1051: wsh_debug_sv.push (l_module_name);
1052: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
1053: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_FROM_DATE',p_scheduled_from_date);
1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1055: END IF;
1056:
1057: x_validate := 'Y';

Line 1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);

1050: IF l_debug_on THEN
1051: wsh_debug_sv.push (l_module_name);
1052: wsh_debug_sv.log (l_module_name,'DELIVERY_ID',p_delivery_id);
1053: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_FROM_DATE',p_scheduled_from_date);
1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1055: END IF;
1056:
1057: x_validate := 'Y';
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1062: wsh_debug_sv.pop(l_module_name,'RETURN');

1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1059:
1060: IF (p_scheduled_from_date IS NULL AND p_scheduled_to_date IS NULL ) THEN
1061: IF l_debug_on THEN
1062: wsh_debug_sv.pop(l_module_name,'RETURN');
1063: END IF;
1064: RETURN;
1065: END IF;
1066:

Line 1089: wsh_debug_sv.pop(l_module_name);

1085: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1086: END IF;
1087:
1088: IF l_debug_on THEN
1089: wsh_debug_sv.pop(l_module_name);
1090: END IF;
1091: EXCEPTION
1092: WHEN others THEN
1093: x_validate := 'N';

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

1094: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);
1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1099: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1101: END IF;
1102:

Line 1099: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1099: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1101: END IF;
1102:
1103: END Validate_Scheduled_Ship_Date;

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

1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1099: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1101: END IF;
1102:
1103: END Validate_Scheduled_Ship_Date;
1104:

Line 1120: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1116: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1117: --
1118: IF l_debug_on IS NULL
1119: THEN
1120: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1121: END IF;
1122: --
1123: IF l_debug_on THEN
1124: wsh_debug_sv.push (l_module_name);

Line 1124: wsh_debug_sv.push (l_module_name);

1120: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1121: END IF;
1122: --
1123: IF l_debug_on THEN
1124: wsh_debug_sv.push (l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'p_doc_type', p_doc_type);
1126: WSH_DEBUG_SV.log(l_module_name,'p_shipment_type', p_shipment_type);
1127: END IF;
1128:

Line 1125: WSH_DEBUG_SV.log(l_module_name,'p_doc_type', p_doc_type);

1121: END IF;
1122: --
1123: IF l_debug_on THEN
1124: wsh_debug_sv.push (l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'p_doc_type', p_doc_type);
1126: WSH_DEBUG_SV.log(l_module_name,'p_shipment_type', p_shipment_type);
1127: END IF;
1128:
1129: IF p_doc_type = 'SR' AND p_shipment_type = 'CMS' THEN

Line 1126: WSH_DEBUG_SV.log(l_module_name,'p_shipment_type', p_shipment_type);

1122: --
1123: IF l_debug_on THEN
1124: wsh_debug_sv.push (l_module_name);
1125: WSH_DEBUG_SV.log(l_module_name,'p_doc_type', p_doc_type);
1126: WSH_DEBUG_SV.log(l_module_name,'p_shipment_type', p_shipment_type);
1127: END IF;
1128:
1129: IF p_doc_type = 'SR' AND p_shipment_type = 'CMS' THEN
1130: IF l_debug_on THEN

Line 1131: WSH_DEBUG_SV.logmsg(l_module_name,'return 1');

1127: END IF;
1128:
1129: IF p_doc_type = 'SR' AND p_shipment_type = 'CMS' THEN
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'return 1');
1132: wsh_debug_sv.pop(l_module_name);
1133: END IF;
1134: RETURN 1;
1135: END IF;

Line 1132: wsh_debug_sv.pop(l_module_name);

1128:
1129: IF p_doc_type = 'SR' AND p_shipment_type = 'CMS' THEN
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name,'return 1');
1132: wsh_debug_sv.pop(l_module_name);
1133: END IF;
1134: RETURN 1;
1135: END IF;
1136:

Line 1138: wsh_debug_sv.pop(l_module_name);

1134: RETURN 1;
1135: END IF;
1136:
1137: IF l_debug_on THEN
1138: wsh_debug_sv.pop(l_module_name);
1139: END IF;
1140:
1141: RETURN NULL;
1142: