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

Line 506: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

502: --{
503: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
504: --
505: IF l_debug_on IS NULL THEN
506: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
507: END IF;
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.push(l_module_name);

Line 510: WSH_DEBUG_SV.push(l_module_name);

506: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
507: END IF;
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.push(l_module_name);
511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);

Line 511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);

507: END IF;
508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.push(l_module_name);
511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);

Line 512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);

508: --
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.push(l_module_name);
511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);

Line 513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);

509: IF l_debug_on THEN
510: WSH_DEBUG_SV.push(l_module_name);
511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);

Line 514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);

510: WSH_DEBUG_SV.push(l_module_name);
511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
518: END IF;

Line 515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);

511: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
518: END IF;
519: --

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

512: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
518: END IF;
519: --
520: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);

513: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
514: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
515: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
516: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
517: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
518: END IF;
519: --
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521: --

Line 527: WSH_DEBUG_SV.logmsg(l_module_name, 'p_from_fk_id = p_to_fk_id', WSH_DEBUG_SV.C_STMT_LEVEL);

523: --
524: x_to_id:=p_from_id;
525: --
526: IF l_debug_on THEN
527: WSH_DEBUG_SV.logmsg(l_module_name, 'p_from_fk_id = p_to_fk_id', WSH_DEBUG_SV.C_STMT_LEVEL);
528: WSH_DEBUG_SV.log(l_module_name, 'x_to_id', x_to_id);
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531: --

Line 528: WSH_DEBUG_SV.log(l_module_name, 'x_to_id', x_to_id);

524: x_to_id:=p_from_id;
525: --
526: IF l_debug_on THEN
527: WSH_DEBUG_SV.logmsg(l_module_name, 'p_from_fk_id = p_to_fk_id', WSH_DEBUG_SV.C_STMT_LEVEL);
528: WSH_DEBUG_SV.log(l_module_name, 'x_to_id', x_to_id);
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531: --
532: RETURN;

Line 529: WSH_DEBUG_SV.pop(l_module_name);

525: --
526: IF l_debug_on THEN
527: WSH_DEBUG_SV.logmsg(l_module_name, 'p_from_fk_id = p_to_fk_id', WSH_DEBUG_SV.C_STMT_LEVEL);
528: WSH_DEBUG_SV.log(l_module_name, 'x_to_id', x_to_id);
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531: --
532: RETURN;
533: --

Line 562: WSH_DEBUG_SV.log(l_module_name, 'l_query_count', l_query_count);

558: l_query_count := 0;
559: END;
560: --
561: IF l_debug_on THEN
562: WSH_DEBUG_SV.log(l_module_name, 'l_query_count', l_query_count);
563: END IF;
564: --
565: IF l_query_count > 0 THEN
566: --{

Line 573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);

569: wsh_util_core.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR, l_Module_name);
570: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);
574: WSH_DEBUG_SV.log(l_module_name, 'x_Return_Status', x_Return_Status);
575: WSH_DEBUG_SV.pop(l_module_name);
576: END IF;
577: --

Line 574: WSH_DEBUG_SV.log(l_module_name, 'x_Return_Status', x_Return_Status);

570: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);
574: WSH_DEBUG_SV.log(l_module_name, 'x_Return_Status', x_Return_Status);
575: WSH_DEBUG_SV.pop(l_module_name);
576: END IF;
577: --
578: RETURN;

Line 575: WSH_DEBUG_SV.pop(l_module_name);

571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name, 'Supplier SF sites cannot be merged', WSH_DEBUG_SV.C_STMT_LEVEL);
574: WSH_DEBUG_SV.log(l_module_name, 'x_Return_Status', x_Return_Status);
575: WSH_DEBUG_SV.pop(l_module_name);
576: END IF;
577: --
578: RETURN;
579: --}

Line 587: WSH_DEBUG_SV.log(l_module_name, 'Merge From Party ID', l_from_party_id);

583: FETCH getPartyID INTO l_from_party_id;
584: CLOSE getPartyID;
585: --
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.log(l_module_name, 'Merge From Party ID', l_from_party_id);
588: END IF;
589: --
590: OPEN getPartyID(p_to_fk_id);
591: FETCH getPartyID INTO l_to_party_id;

Line 595: WSH_DEBUG_SV.log(l_module_name, 'Merge to Party ID', l_to_party_id);

591: FETCH getPartyID INTO l_to_party_id;
592: CLOSE getPartyID;
593: --
594: IF l_debug_on THEN
595: WSH_DEBUG_SV.log(l_module_name, 'Merge to Party ID', l_to_party_id);
596: END IF;
597: --
598: OPEN getVendorID(l_to_party_id);
599: FETCH getVendorID INTO l_to_vendor_id;

Line 603: WSH_DEBUG_SV.log(l_module_name, 'Merge to Vendor ID', l_to_vendor_id);

599: FETCH getVendorID INTO l_to_vendor_id;
600: CLOSE getVendorID;
601: --
602: IF l_debug_on THEN
603: WSH_DEBUG_SV.log(l_module_name, 'Merge to Vendor ID', l_to_vendor_id);
604: END IF;
605: --
606: OPEN getLocationID(p_from_fk_id);
607: FETCH getLocationID INTO l_location_id;

Line 611: WSH_DEBUG_SV.log(l_module_name, 'Location ID', l_location_id);

607: FETCH getLocationID INTO l_location_id;
608: CLOSE getLocationID;
609: --
610: IF l_debug_on THEN
611: WSH_DEBUG_SV.log(l_module_name, 'Location ID', l_location_id);
612: END IF;
613: --
614: IF l_from_party_id <> l_to_party_id THEN
615: --{

Line 617: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling create_site', WSH_DEBUG_SV.C_PROC_LEVEL);

613: --
614: IF l_from_party_id <> l_to_party_id THEN
615: --{
616: IF l_debug_on THEN
617: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling create_site', WSH_DEBUG_SV.C_PROC_LEVEL);
618: END IF;
619: --
620: WSH_VENDOR_PARTY_MERGE_PKG.Create_Site
621: (

Line 632: WSH_DEBUG_SV.log(l_module_name, 'After calling Create_Site, return status', l_return_status);

628: x_return_status => l_return_status
629: );
630: --
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.log(l_module_name, 'After calling Create_Site, return status', l_return_status);
633: END IF;
634: --
635: WSH_UTIL_CORE.api_post_call
636: (

Line 659: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);

655: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
656: END IF;
657: --
658: IF l_debug_on THEN
659: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);
660: WSH_DEBUG_SV.pop(l_module_name);
661: END IF;
662: --
663: EXCEPTION

Line 660: WSH_DEBUG_SV.pop(l_module_name);

656: END IF;
657: --
658: IF l_debug_on THEN
659: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);
660: WSH_DEBUG_SV.pop(l_module_name);
661: END IF;
662: --
663: EXCEPTION
664: WHEN OTHERS THEN

Line 671: WSH_DEBUG_SV.log(l_module_name, 'In When Others, Error Msg is', SUBSTRB(SQLERRM, 1, 200));

667: FND_MSG_PUB.ADD;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.log(l_module_name, 'In When Others, Error Msg is', SUBSTRB(SQLERRM, 1, 200));
672: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);
673: WSH_DEBUG_SV.pop(l_module_name);
674: END IF;
675: --

Line 672: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.log(l_module_name, 'In When Others, Error Msg is', SUBSTRB(SQLERRM, 1, 200));
672: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);
673: WSH_DEBUG_SV.pop(l_module_name);
674: END IF;
675: --
676:

Line 673: WSH_DEBUG_SV.pop(l_module_name);

669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.log(l_module_name, 'In When Others, Error Msg is', SUBSTRB(SQLERRM, 1, 200));
672: WSH_DEBUG_SV.log(l_module_name, 'x_return_Status', x_return_status);
673: WSH_DEBUG_SV.pop(l_module_name);
674: END IF;
675: --
676:
677: --}

Line 752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

748: --
749: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
750: --
751: IF l_debug_on IS NULL THEN
752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
753: END IF;
754: --
755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
756: --

Line 758: WSH_DEBUG_SV.push(l_module_name);

754: --
755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);

Line 759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);

755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);

Line 760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);

756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);

Line 761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);

757: IF l_debug_on THEN
758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);

Line 762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);

758: WSH_DEBUG_SV.push(l_module_name);
759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);
766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);

Line 763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);

759: WSH_DEBUG_SV.log(l_module_name,'P_TO_ID',p_to_id);
760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);
766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
767: END IF;

Line 764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);

760: WSH_DEBUG_SV.log(l_module_name,'P_FROM_ID',p_from_id);
761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);
766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
767: END IF;
768: --

Line 765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);

761: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_ID',p_to_party_id);
762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);
766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
767: END IF;
768: --
769: IF NOT (p_site_merge) THEN

Line 766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);

762: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_ID',p_from_party_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_TO_SITE_ID',p_to_site_id);
764: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SITE_ID',p_from_site_id);
765: WSH_DEBUG_SV.log(l_module_name,'P_SITE_MERGE',p_site_merge);
766: WSH_DEBUG_SV.log(l_module_name,'P_FROM_SUPPLIER_NAME',p_from_supplier_name);
767: END IF;
768: --
769: IF NOT (p_site_merge) THEN
770: --{

Line 780: wsh_debug_sv.log(l_module_name, 'No. of rows in WSH_carriers that were updated', SQL%ROWCOUNT);

776: WHERE supplier_id = p_from_id
777: AND supplier_site_id IS NULL;
778: --
779: IF l_debug_on THEN
780: wsh_debug_sv.log(l_module_name, 'No. of rows in WSH_carriers that were updated', SQL%ROWCOUNT);
781: END IF;
782: --
783: FOR check_calendar_rec IN check_calendar
784: LOOP

Line 788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);

784: LOOP
785: --{
786: IF l_debug_on THEN
787: --
788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);
789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);

Line 789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);

785: --{
786: IF l_debug_on THEN
787: --
788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);
789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);
793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);

Line 790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);

786: IF l_debug_on THEN
787: --
788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);
789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);
793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);
794: --

Line 791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);

787: --
788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);
789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);
793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);
794: --
795: END IF;

Line 792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);

788: WSH_DEBUG_SV.logmsg(l_module_name, '----------------------------', WSH_DEBUG_SV.C_STMT_LEVEL);
789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);
793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);
794: --
795: END IF;
796: --

Line 793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);

789: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_TYPE', check_calendar_rec.calendar_type);
790: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.CALENDAR_ASSIGNMENT_ID',check_calendar_rec.calendar_assignment_id);
791: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.VENDOR_SITE_ID', check_calendar_rec.vendor_site_id);
792: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.ASSOCIATION_TYPE', check_calendar_rec.association_type);
793: WSH_DEBUG_SV.log(l_module_name,'CHECK_CALENDAR_REC.FREIGHT_CODE', check_calendar_rec.freight_code);
794: --
795: END IF;
796: --
797: OPEN check_dup_assignment

Line 820: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID updated', check_calendar_rec.calendar_assignment_id);

816: WHERE calendar_assignment_id = check_calendar_rec.calendar_assignment_id;
817: --
818: IF l_debug_on THEN
819: --
820: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID updated', check_calendar_rec.calendar_assignment_id);
821: WSH_DEBUG_SV.log(l_module_name,'Number of Rows updated is', sql%rowcount);
822: --
823: END IF;
824: --}

Line 821: WSH_DEBUG_SV.log(l_module_name,'Number of Rows updated is', sql%rowcount);

817: --
818: IF l_debug_on THEN
819: --
820: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID updated', check_calendar_rec.calendar_assignment_id);
821: WSH_DEBUG_SV.log(l_module_name,'Number of Rows updated is', sql%rowcount);
822: --
823: END IF;
824: --}
825: ELSE

Line 833: WSH_DEBUG_SV.log(l_module_name, 'Deleted cal. assgn ID',

829: WHERE calendar_assignment_id = check_calendar_rec.calendar_assignment_id;
830: --
831: IF l_debug_on THEN
832: --
833: WSH_DEBUG_SV.log(l_module_name, 'Deleted cal. assgn ID',
834: check_calendar_rec.calendar_assignment_id);
835: WSH_DEBUG_SV.log(l_module_name,'Number of Rows deleted is', sql%rowcount);
836: --
837: END IF;

Line 835: WSH_DEBUG_SV.log(l_module_name,'Number of Rows deleted is', sql%rowcount);

831: IF l_debug_on THEN
832: --
833: WSH_DEBUG_SV.log(l_module_name, 'Deleted cal. assgn ID',
834: check_calendar_rec.calendar_assignment_id);
835: WSH_DEBUG_SV.log(l_module_name,'Number of Rows deleted is', sql%rowcount);
836: --
837: END IF;
838: --
839: IF check_calendar_rec.freight_code IS NULL THEN

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

856: --}
857: END IF;
858: --
859: IF l_debug_on THEN
860: wsh_debug_sv.log(l_module_name, 'x_return_status', x_return_status);
861: wsh_debug_sv.pop(l_module_name);
862: END IF;
863: --
864: EXCEPTION

Line 861: wsh_debug_sv.pop(l_module_name);

857: END IF;
858: --
859: IF l_debug_on THEN
860: wsh_debug_sv.log(l_module_name, 'x_return_status', x_return_status);
861: wsh_debug_sv.pop(l_module_name);
862: END IF;
863: --
864: EXCEPTION
865: --

Line 872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.

868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
869: wsh_util_core.default_handler('WSH_PARTY_MERGE.Update_Entities_during_merge');
870: IF l_debug_on THEN
871: --
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.
873: occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
875: --
876: END IF;

Line 873: occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

869: wsh_util_core.default_handler('WSH_PARTY_MERGE.Update_Entities_during_merge');
870: IF l_debug_on THEN
871: --
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.
873: occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
875: --
876: END IF;
877: --

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

870: IF l_debug_on THEN
871: --
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occurred.
873: occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
875: --
876: END IF;
877: --
878: END Update_Entities_During_Merge;

Line 940: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

936: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
937: --
938: IF l_debug_on IS NULL
939: THEN
940: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
941: END IF;
942: --
943: --
944: IF l_debug_on THEN

Line 945: WSH_DEBUG_SV.push(l_module_name);

941: END IF;
942: --
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.push(l_module_name);
946: -- Printing the parameters passed to API
947: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );
948: END IF;
949: --

Line 947: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );

943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.push(l_module_name);
946: -- Printing the parameters passed to API
947: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );
948: END IF;
949: --
950:
951: -- Call Mark_Reprice_Reqired, only when Unassigning from delivery

Line 969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');

965: WSH_UTIL_CORE.G_RET_STS_WARNING) )
966: THEN
967: --
968: IF ( l_debug_on ) THEN
969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');
970: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
971: END IF;
972: --
973: RAISE Weight_Volume_Exp;

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

966: THEN
967: --
968: IF ( l_debug_on ) THEN
969: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');
970: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
971: END IF;
972: --
973: RAISE Weight_Volume_Exp;
974: END IF;

Line 1001: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_WV_UTILS.DD_WV_Post_Process', WSH_DEBUG_SV.C_PROC_LEVEL);

997: l_return_status := NULL;
998:
999: --
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_WV_UTILS.DD_WV_Post_Process', WSH_DEBUG_SV.C_PROC_LEVEL);
1002: END IF;
1003: --
1004:
1005: WSH_WV_UTILS.DD_WV_Post_Process (

Line 1019: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.DD_WV_Post_Process : ' || l_return_status);

1015: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1016: THEN
1017: --
1018: IF l_debug_on THEN
1019: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.DD_WV_Post_Process : ' || l_return_status);
1020: END IF;
1021: --
1022: RAISE Weight_Volume_Exp;
1023: END IF;

Line 1033: WSH_DEBUG_SV.pop(l_module_name);

1029: END IF;
1030:
1031: --
1032: IF ( l_debug_on ) THEN
1033: WSH_DEBUG_SV.pop(l_module_name);
1034: END IF;
1035: --
1036:
1037: EXCEPTION

Line 1042: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Weight_Volume');

1038: WHEN Weight_Volume_Exp THEN
1039: x_return_status := l_return_status;
1040: --
1041: IF l_debug_on THEN
1042: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Weight_Volume');
1043: WSH_DEBUG_SV.pop(l_module_name);
1044: END IF;
1045: --
1046:

Line 1043: WSH_DEBUG_SV.pop(l_module_name);

1039: x_return_status := l_return_status;
1040: --
1041: IF l_debug_on THEN
1042: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Weight_Volume');
1043: WSH_DEBUG_SV.pop(l_module_name);
1044: END IF;
1045: --
1046:
1047: WHEN OTHERS THEN

Line 1051: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Weight_Volume');

1047: WHEN OTHERS THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: --
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Weight_Volume');
1052: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1053: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;

Line 1052: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: --
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Weight_Volume');
1052: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1053: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: --

Line 1053: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);

1049: --
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Weight_Volume');
1052: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1053: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: --
1057: END Adjust_Weight_Volume;

Line 1054: WSH_DEBUG_SV.pop(l_module_name);

1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Weight_Volume');
1052: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1053: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1054: WSH_DEBUG_SV.pop(l_module_name);
1055: END IF;
1056: --
1057: END Adjust_Weight_Volume;
1058: --

Line 1110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1106: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1107: --
1108: IF l_debug_on IS NULL
1109: THEN
1110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1111: END IF;
1112: --
1113: --
1114: IF l_debug_on THEN

Line 1115: WSH_DEBUG_SV.push(l_module_name);

1111: END IF;
1112: --
1113: --
1114: IF l_debug_on THEN
1115: WSH_DEBUG_SV.push(l_module_name);
1116: -- Printing the parameters passed to API
1117: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );
1118: END IF;
1119: --

Line 1117: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );

1113: --
1114: IF l_debug_on THEN
1115: WSH_DEBUG_SV.push(l_module_name);
1116: -- Printing the parameters passed to API
1117: WSH_DEBUG_SV.log(l_module_name, 'p_entity_type', p_entity_type );
1118: END IF;
1119: --
1120:
1121: -- Weight/Volume adjustments

Line 1146: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPPING_PARAMS_PVT.Get', WSH_DEBUG_SV.C_PROC_LEVEL);

1142: l_return_status := NULL;
1143:
1144: --
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_SHIPPING_PARAMS_PVT.Get', WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149:
1150: WSH_SHIPPING_PARAMS_PVT.Get(

Line 1158: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);

1154:
1155: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1156: --
1157: IF ( l_debug_on ) THEN
1158: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
1159: END IF;
1160: --
1161: RAISE Weight_Volume_Exp;
1162: END IF;

Line 1175: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_WV_UTILS.Adjust_Parent_WV', WSH_DEBUG_SV.C_PROC_LEVEL);

1171: l_return_status := NULL;
1172:
1173: --
1174: IF l_debug_on THEN
1175: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_WV_UTILS.Adjust_Parent_WV', WSH_DEBUG_SV.C_PROC_LEVEL);
1176: END IF;
1177: --
1178:
1179: WSH_WV_UTILS.Adjust_Parent_WV(

Line 1196: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.Adjust_Parent_WV : ' || l_return_status);

1192: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1193: THEN
1194: --
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_WV_UTILS.Adjust_Parent_WV : ' || l_return_status);
1197: END IF;
1198: --
1199: RAISE Weight_Volume_Exp;
1200: END IF;

Line 1209: WSH_DEBUG_SV.pop(l_module_name);

1205: END LOOP;
1206:
1207: --
1208: IF ( l_debug_on ) THEN
1209: WSH_DEBUG_SV.pop(l_module_name);
1210: END IF;
1211: --
1212:
1213: EXCEPTION

Line 1218: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Parent_WV');

1214: WHEN Weight_Volume_Exp THEN
1215: x_return_status := l_return_status;
1216: --
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Parent_WV');
1219: WSH_DEBUG_SV.pop(l_module_name);
1220: END IF;
1221: --
1222:

Line 1219: WSH_DEBUG_SV.pop(l_module_name);

1215: x_return_status := l_return_status;
1216: --
1217: IF l_debug_on THEN
1218: WSH_DEBUG_SV.log(l_module_name, 'Weight_Volume_Exp Exception occurred in Adjust_Parent_WV');
1219: WSH_DEBUG_SV.pop(l_module_name);
1220: END IF;
1221: --
1222:
1223: WHEN OTHERS THEN

Line 1227: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Parent_WV');

1223: WHEN OTHERS THEN
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: --
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Parent_WV');
1228: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1229: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1230: WSH_DEBUG_SV.pop(l_module_name);
1231: END IF;

Line 1228: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: --
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Parent_WV');
1228: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1229: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1230: WSH_DEBUG_SV.pop(l_module_name);
1231: END IF;
1232: --

Line 1229: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);

1225: --
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Parent_WV');
1228: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1229: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1230: WSH_DEBUG_SV.pop(l_module_name);
1231: END IF;
1232: --
1233: END Adjust_Parent_WV;

Line 1230: WSH_DEBUG_SV.pop(l_module_name);

1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Adjust_Parent_WV');
1228: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1229: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1230: WSH_DEBUG_SV.pop(l_module_name);
1231: END IF;
1232: --
1233: END Adjust_Parent_WV;
1234: End of comment for bug 5749968 */

Line 1277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1273: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1274: --
1275: IF l_debug_on IS NULL
1276: THEN
1277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1278: END IF;
1279: --
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.push(l_module_name);

Line 1281: WSH_DEBUG_SV.push(l_module_name);

1277: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1278: END IF;
1279: --
1280: IF l_debug_on THEN
1281: WSH_DEBUG_SV.push(l_module_name);
1282: END IF;
1283: --
1284:
1285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1303: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_AUTOCREATE.Create_Hash', WSH_DEBUG_SV.C_PROC_LEVEL);

1299: l_grp_attr_tab_type(1).Entity_Id := p_delivery_detail_id;
1300:
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_AUTOCREATE.Create_Hash', WSH_DEBUG_SV.C_PROC_LEVEL);
1304: END IF;
1305: --
1306:
1307: WSH_DELIVERY_AUTOCREATE.Create_Hash (

Line 1322: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_AUTOCREATE.Create_Hash : ' || l_return_status);

1318: WSH_UTIL_CORE.G_RET_STS_WARNING) )
1319: THEN
1320: --
1321: IF ( l_debug_on ) THEN
1322: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_DELIVERY_AUTOCREATE.Create_Hash : ' || l_return_status);
1323: END IF;
1324: --
1325: RAISE Update_Hash_Exp;
1326: END IF;

Line 1337: WSH_DEBUG_SV.pop(l_module_name);

1333:
1334:
1335: --
1336: IF l_debug_on THEN
1337: WSH_DEBUG_SV.pop(l_module_name);
1338: END IF;
1339: --
1340: EXCEPTION
1341: WHEN Update_Hash_Exp THEN

Line 1345: WSH_DEBUG_SV.log(l_module_name, 'Update_Hash_Exp Exception occurred in Get_Delivery_Hash');

1341: WHEN Update_Hash_Exp THEN
1342: x_return_status := l_return_status;
1343: --
1344: IF ( l_debug_on ) THEN
1345: WSH_DEBUG_SV.log(l_module_name, 'Update_Hash_Exp Exception occurred in Get_Delivery_Hash');
1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348: --
1349: WHEN OTHERS THEN

Line 1346: WSH_DEBUG_SV.pop(l_module_name);

1342: x_return_status := l_return_status;
1343: --
1344: IF ( l_debug_on ) THEN
1345: WSH_DEBUG_SV.log(l_module_name, 'Update_Hash_Exp Exception occurred in Get_Delivery_Hash');
1346: WSH_DEBUG_SV.pop(l_module_name);
1347: END IF;
1348: --
1349: WHEN OTHERS THEN
1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');

1349: WHEN OTHERS THEN
1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1351: --
1352: IF ( l_debug_on ) THEN
1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');
1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1355: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1356: WSH_DEBUG_SV.pop(l_module_name);
1357: END IF;

Line 1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

1350: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1351: --
1352: IF ( l_debug_on ) THEN
1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');
1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1355: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1356: WSH_DEBUG_SV.pop(l_module_name);
1357: END IF;
1358: --

Line 1355: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);

1351: --
1352: IF ( l_debug_on ) THEN
1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');
1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1355: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1356: WSH_DEBUG_SV.pop(l_module_name);
1357: END IF;
1358: --
1359: END Get_Delivery_Hash;

Line 1356: WSH_DEBUG_SV.pop(l_module_name);

1352: IF ( l_debug_on ) THEN
1353: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Get_Delivery_Hash');
1354: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1355: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1356: WSH_DEBUG_SV.pop(l_module_name);
1357: END IF;
1358: --
1359: END Get_Delivery_Hash;
1360: --

Line 1423: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1419: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1420: --
1421: IF l_debug_on IS NULL
1422: THEN
1423: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1424: END IF;
1425: --
1426: IF l_debug_on THEN
1427: WSH_DEBUG_SV.push(l_module_name);

Line 1427: WSH_DEBUG_SV.push(l_module_name);

1423: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1424: END IF;
1425: --
1426: IF l_debug_on THEN
1427: WSH_DEBUG_SV.push(l_module_name);
1428: WSH_DEBUG_SV.logmsg(l_module_name, 'Party Site Id : ' || p_party_site_id || ', Location Id : ' || p_location_id);
1429: END IF;
1430: --
1431:

Line 1428: WSH_DEBUG_SV.logmsg(l_module_name, 'Party Site Id : ' || p_party_site_id || ', Location Id : ' || p_location_id);

1424: END IF;
1425: --
1426: IF l_debug_on THEN
1427: WSH_DEBUG_SV.push(l_module_name);
1428: WSH_DEBUG_SV.logmsg(l_module_name, 'Party Site Id : ' || p_party_site_id || ', Location Id : ' || p_location_id);
1429: END IF;
1430: --
1431:
1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1452: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );

1448: IF ( G_WMS_ENABLED(l_org_id_tab(orgCnt)) = 'Y' )
1449: THEN
1450: --
1451: IF ( l_debug_on ) THEN
1452: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );
1453: END IF;
1454: --
1455: CLOSE C1;
1456: RAISE Wms_Exception;

Line 1484: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers and Deliveries for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );

1480: IF ( G_WMS_ENABLED(l_org_id_tab(orgCnt)) = 'Y' )
1481: THEN
1482: --
1483: IF ( l_debug_on ) THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name, 'There exists WMS records in shipping which are assigned to Containers and Deliveries for organization : ' || WSH_UTIL_CORE.Get_Org_Name(l_org_id_tab(orgCnt)) );
1485: END IF;
1486: --
1487: CLOSE C2;
1488: RAISE Wms_Exception;

Line 1500: WSH_DEBUG_SV.pop(l_module_name);

1496: CLOSE C2;
1497:
1498: --
1499: IF l_debug_on THEN
1500: WSH_DEBUG_SV.pop(l_module_name);
1501: END IF;
1502: --
1503: EXCEPTION
1504: WHEN Wms_Exception THEN

Line 1508: WSH_DEBUG_SV.pop(l_module_name);

1504: WHEN Wms_Exception THEN
1505: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1506: --
1507: IF ( l_debug_on ) THEN
1508: WSH_DEBUG_SV.pop(l_module_name);
1509: END IF;
1510: --
1511: IF ( C1%ISOPEN ) THEN
1512: CLOSE C1;

Line 1520: WSH_DEBUG_SV.logmsg(l_module_name, 'WMS_Exception occurred');

1516: CLOSE C2;
1517: END IF;
1518: --
1519: IF l_debug_on THEN
1520: WSH_DEBUG_SV.logmsg(l_module_name, 'WMS_Exception occurred');
1521: WSH_DEBUG_SV.pop(l_module_name);
1522: END IF;
1523: --
1524: WHEN OTHERS THEN

Line 1521: WSH_DEBUG_SV.pop(l_module_name);

1517: END IF;
1518: --
1519: IF l_debug_on THEN
1520: WSH_DEBUG_SV.logmsg(l_module_name, 'WMS_Exception occurred');
1521: WSH_DEBUG_SV.pop(l_module_name);
1522: END IF;
1523: --
1524: WHEN OTHERS THEN
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');

1524: WHEN OTHERS THEN
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1526: --
1527: IF ( l_debug_on ) THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');
1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1530: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1531: WSH_DEBUG_SV.pop(l_module_name);
1532: END IF;

Line 1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1526: --
1527: IF ( l_debug_on ) THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');
1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1530: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1531: WSH_DEBUG_SV.pop(l_module_name);
1532: END IF;
1533: --

Line 1530: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);

1526: --
1527: IF ( l_debug_on ) THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');
1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1530: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1531: WSH_DEBUG_SV.pop(l_module_name);
1532: END IF;
1533: --
1534: IF ( C1%ISOPEN ) THEN

Line 1531: WSH_DEBUG_SV.pop(l_module_name);

1527: IF ( l_debug_on ) THEN
1528: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error in Check_Wms_Details');
1529: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
1530: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
1531: WSH_DEBUG_SV.pop(l_module_name);
1532: END IF;
1533: --
1534: IF ( C1%ISOPEN ) THEN
1535: CLOSE C1;

Line 1826: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1822: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1823: --
1824: IF l_debug_on IS NULL
1825: THEN
1826: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1827: END IF;
1828: --
1829:
1830: --

Line 1832: WSH_DEBUG_SV.push(l_module_name);

1828: --
1829:
1830: --
1831: IF l_debug_on THEN
1832: WSH_DEBUG_SV.push(l_module_name);
1833:
1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);

Line 1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));

1831: IF l_debug_on THEN
1832: WSH_DEBUG_SV.push(l_module_name);
1833:
1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);

Line 1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);

1832: WSH_DEBUG_SV.push(l_module_name);
1833:
1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);

Line 1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);

1833:
1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);

Line 1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);

1834: -- Printing the parameters passed to API
1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);

Line 1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);

1835: WSH_DEBUG_SV.log(l_module_name,'WSH_PARTY_MERGE.merge_location()+', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);

Line 1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);

1836: WSH_DEBUG_SV.log(l_module_name, 'p_entity_name', p_entity_name);
1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
1844: END IF;

Line 1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);

1837: WSH_DEBUG_SV.log(l_module_name, 'p_from_id', p_from_id);
1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
1844: END IF;
1845: --

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

1838: WSH_DEBUG_SV.log(l_module_name, 'p_to_id', p_to_id);
1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
1844: END IF;
1845: --
1846:

Line 1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);

1839: WSH_DEBUG_SV.log(l_module_name, 'p_from_fk_id', p_from_fk_id);
1840: WSH_DEBUG_SV.log(l_module_name, 'p_to_fk_id', p_to_fk_id);
1841: WSH_DEBUG_SV.log(l_module_name, 'p_parent_entity_name', p_parent_entity_name);
1842: WSH_DEBUG_SV.log(l_module_name, 'p_batch_id', p_batch_id);
1843: WSH_DEBUG_SV.log(l_module_name, 'p_batch_party_id', p_batch_party_id);
1844: END IF;
1845: --
1846:
1847: -- Get To_Location_Id which is to be updated in Shipping tables.

Line 1854: WSH_DEBUG_SV.log(l_module_name, 'Invaild To Party Site Id', p_to_fk_id);

1850: IF Get_Location_Id%NOTFOUND
1851: THEN -- {
1852: -- Error Handling Part
1853: IF l_debug_on THEN
1854: WSH_DEBUG_SV.log(l_module_name, 'Invaild To Party Site Id', p_to_fk_id);
1855: END IF;
1856: --
1857: x_return_status := FND_API.G_RET_STS_ERROR;
1858: CLOSE Get_Location_Id;

Line 1871: WSH_DEBUG_SV.log(l_module_name, 'Invalid From Party Site Id', p_from_fk_id);

1867: IF Get_Location_Id%NOTFOUND
1868: THEN -- {
1869: -- Error Handling Part
1870: IF l_debug_on THEN
1871: WSH_DEBUG_SV.log(l_module_name, 'Invalid From Party Site Id', p_from_fk_id);
1872: END IF;
1873: --
1874: x_return_status := FND_API.G_RET_STS_ERROR;
1875: CLOSE Get_Location_Id;

Line 1882: WSH_DEBUG_SV.log(l_module_name, 'To Party Id', l_to_party_id);

1878: CLOSE Get_Location_Id;
1879:
1880: --
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.log(l_module_name, 'To Party Id', l_to_party_id);
1883: WSH_DEBUG_SV.log(l_module_name, 'To Location Id', l_to_location_id);
1884: WSH_DEBUG_SV.log(l_module_name, 'From Party Id', l_from_party_id);
1885: WSH_DEBUG_SV.log(l_module_name, 'From Location Id', l_from_location_id);
1886: END IF;

Line 1883: WSH_DEBUG_SV.log(l_module_name, 'To Location Id', l_to_location_id);

1879:
1880: --
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.log(l_module_name, 'To Party Id', l_to_party_id);
1883: WSH_DEBUG_SV.log(l_module_name, 'To Location Id', l_to_location_id);
1884: WSH_DEBUG_SV.log(l_module_name, 'From Party Id', l_from_party_id);
1885: WSH_DEBUG_SV.log(l_module_name, 'From Location Id', l_from_location_id);
1886: END IF;
1887: --

Line 1884: WSH_DEBUG_SV.log(l_module_name, 'From Party Id', l_from_party_id);

1880: --
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.log(l_module_name, 'To Party Id', l_to_party_id);
1883: WSH_DEBUG_SV.log(l_module_name, 'To Location Id', l_to_location_id);
1884: WSH_DEBUG_SV.log(l_module_name, 'From Party Id', l_from_party_id);
1885: WSH_DEBUG_SV.log(l_module_name, 'From Location Id', l_from_location_id);
1886: END IF;
1887: --
1888:

Line 1885: WSH_DEBUG_SV.log(l_module_name, 'From Location Id', l_from_location_id);

1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.log(l_module_name, 'To Party Id', l_to_party_id);
1883: WSH_DEBUG_SV.log(l_module_name, 'To Location Id', l_to_location_id);
1884: WSH_DEBUG_SV.log(l_module_name, 'From Party Id', l_from_party_id);
1885: WSH_DEBUG_SV.log(l_module_name, 'From Location Id', l_from_location_id);
1886: END IF;
1887: --
1888:
1889: -- If FROM and TO Locations are same return Success.

Line 1895: WSH_DEBUG_SV.log(l_module_name, 'From and To Location IDs are the same');

1891: THEN
1892: x_return_status := FND_API.G_RET_STS_SUCCESS;
1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name, 'From and To Location IDs are the same');
1896: WSH_DEBUG_SV.pop(l_module_name);
1897: END IF;
1898: --
1899: RETURN;

Line 1896: WSH_DEBUG_SV.pop(l_module_name);

1892: x_return_status := FND_API.G_RET_STS_SUCCESS;
1893: --
1894: IF l_debug_on THEN
1895: WSH_DEBUG_SV.log(l_module_name, 'From and To Location IDs are the same');
1896: WSH_DEBUG_SV.pop(l_module_name);
1897: END IF;
1898: --
1899: RETURN;
1900: END IF;

Line 1908: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location', WSH_DEBUG_SV.C_PROC_LEVEL);

1904:
1905:
1906: --
1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location', WSH_DEBUG_SV.C_PROC_LEVEL);
1909: END IF;
1910: --
1911:
1912: -- Check whether the To_Location exists in WSH_LOCATIONS table

Line 1925: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location : ' || l_return_status);

1921: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
1922: THEN -- { Error Handling
1923: --
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_MAP_LOCATION_REGION_PKG.Transfer_Location : ' || l_return_status);
1926: END IF;
1927: --
1928: x_return_status := l_return_status;
1929: RAISE Merge_Location_Exp;

Line 1942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Check_Wms_Details', WSH_DEBUG_SV.C_PROC_LEVEL);

1938: -- Check for WMS records
1939: l_return_status := NULL;
1940: --
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Check_Wms_Details', WSH_DEBUG_SV.C_PROC_LEVEL);
1943: END IF;
1944: --
1945:
1946: WSH_PARTY_MERGE.Check_Wms_Details (

Line 1956: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_PARTY_MERGE.Check_Wms_Details : ' || l_return_status);

1952: THEN
1953: -- { Error Handling
1954: --
1955: IF l_debug_on THEN
1956: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_PARTY_MERGE.Check_Wms_Details : ' || l_return_status);
1957: END IF;
1958: --
1959: x_return_status := l_return_status;
1960: RAISE Merge_Location_Exp;

Line 1965: WSH_DEBUG_SV.log(l_module_name, 'Starting updates on shipping tables', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));

1961: END IF; -- } Error Handling
1962:
1963: --
1964: IF ( l_debug_on ) THEN
1965: WSH_DEBUG_SV.log(l_module_name, 'Starting updates on shipping tables', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
1966: END IF;
1967: --
1968:
1969: -- Get Shipping details based on ship_to_location for which the location

Line 1996: WSH_DEBUG_SV.log(l_module_name, 'No of rows fetched from Get_Wsh_Details', l_del_detail_rowid_tab.COUNT);

1992: LIMIT G_FETCH_LIMIT;
1993:
1994: --
1995: IF ( l_debug_on ) THEN
1996: WSH_DEBUG_SV.log(l_module_name, 'No of rows fetched from Get_Wsh_Details', l_del_detail_rowid_tab.COUNT);
1997: END IF;
1998: --
1999:
2000: -- Update Ship_to_Location and Deliver_to_Location in Wsh_Delivery_Details

Line 2021: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD : '

2017: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2018:
2019: --
2020: IF l_debug_on THEN
2021: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD : '
2022: || sql%rowcount || ', Time : '
2023: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2024: END IF;
2025: --

Line 2052: WSH_DEBUG_SV.logmsg(l_module_name, 'Before calling container unassign standard api: '

2048:
2049: --Start of fix for bug 5749968
2050: --
2051: IF l_debug_on THEN
2052: WSH_DEBUG_SV.logmsg(l_module_name, 'Before calling container unassign standard api: '
2053: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2054: END IF;
2055: --
2056:

Line 2075: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Cont returned error : ' || l_return_status);

2071: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2072: THEN
2073: --
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Cont returned error : ' || l_return_status);
2076: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignCnt) );
2077: END IF;
2078: --
2079: x_return_status := l_return_status;

Line 2076: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignCnt) );

2072: THEN
2073: --
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Cont returned error : ' || l_return_status);
2076: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignCnt) );
2077: END IF;
2078: --
2079: x_return_status := l_return_status;
2080: RAISE Merge_Location_Exp;

Line 2087: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling container unassign standard api: '

2083: END LOOP;
2084:
2085: --
2086: IF l_debug_on THEN
2087: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling container unassign standard api: '
2088: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2089: END IF;
2090: --
2091: --End of fix for bug 5749968

Line 2110: WSH_DEBUG_SV.logmsg(l_module_name, 'No of rows inserted into wsh_temp : '

2106: AND ( Column2 = l_stop_id_tab(i) OR l_stop_id_tab(i) IS NULL ) );
2107:
2108: --
2109: IF ( l_debug_on ) THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name, 'No of rows inserted into wsh_temp : '
2111: || sql%rowcount || ', Time : '
2112: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2113: END IF;
2114: --

Line 2141: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);

2137: l_message_text := FND_MESSAGE.Get;
2138:
2139: --
2140: IF l_debug_on THEN
2141: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2142: END IF;
2143: --
2144:
2145: l_return_status := NULL;

Line 2173: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception : ' || l_return_status);

2169: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2170: THEN
2171: --
2172: IF l_debug_on THEN
2173: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception : ' || l_return_status);
2174: END IF;
2175: --
2176: x_return_status := l_return_status;
2177: RAISE Merge_Location_Exp;

Line 2213: WSH_DEBUG_SV.log(l_module_name, 'No of rows fetched from Get_Wsh_Unassign_Details', l_del_assignments_rowid_tab.COUNT);

2209: LIMIT G_FETCH_LIMIT;
2210:
2211: --
2212: IF ( l_debug_on ) THEN
2213: WSH_DEBUG_SV.log(l_module_name, 'No of rows fetched from Get_Wsh_Unassign_Details', l_del_assignments_rowid_tab.COUNT);
2214: END IF;
2215: --
2216:
2217: IF ( l_del_assignments_rowid_tab.COUNT > 0 )

Line 2241: WSH_DEBUG_SV.logmsg(l_module_name, 'Before calling delivery unassign standard api: '

2237:
2238: --Start of fix for bug 5749968
2239: --
2240: IF l_debug_on THEN
2241: WSH_DEBUG_SV.logmsg(l_module_name, 'Before calling delivery unassign standard api: '
2242: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2243: END IF;
2244: --
2245:

Line 2259: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Delivery returned error : ' || l_return_status);

2255: WSH_UTIL_CORE.G_RET_STS_WARNING) )
2256: THEN
2257: --
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Delivery returned error : ' || l_return_status);
2260: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignDelCnt) );
2261: END IF;
2262: --
2263: x_return_status := l_return_status;

Line 2260: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignDelCnt) );

2256: THEN
2257: --
2258: IF l_debug_on THEN
2259: WSH_DEBUG_SV.logmsg(l_module_name, 'Unassign_Detail_from_Delivery returned error : ' || l_return_status);
2260: WSH_DEBUG_SV.logmsg(l_module_name, 'Error while processing delivery detail : ' || l_del_detail_id_tab(unassignDelCnt) );
2261: END IF;
2262: --
2263: x_return_status := l_return_status;
2264: RAISE Merge_Location_Exp;

Line 2270: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling delivery unassign standard api: '

2266: END LOOP;
2267:
2268: --
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling delivery unassign standard api: '
2271: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2272: END IF;
2273: --
2274: --End of fix for bug 5749968

Line 2284: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from wsh_tmp table after unassigning from delivery : '

2280: DELETE FROM wsh_tmp WHERE column1 = l_delivery_id_tab(i);
2281:
2282: --
2283: IF l_debug_on THEN
2284: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from wsh_tmp table after unassigning from delivery : '
2285: || sql%rowcount || ', Time : '
2286: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2287: END IF;
2288: --

Line 2307: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);

2303: l_message_text := FND_MESSAGE.Get;
2304:
2305: --
2306: IF l_debug_on THEN
2307: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2308: END IF;
2309: --
2310:
2311: l_return_status := NULL;

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

2336: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2337: THEN
2338: --
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
2341: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2342: END IF;
2343: --
2344: x_return_status := l_return_status;

Line 2341: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);

2337: THEN
2338: --
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
2341: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2342: END IF;
2343: --
2344: x_return_status := l_return_status;
2345: RAISE Merge_Location_Exp;

Line 2390: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Container records Updated in WDD : '

2386: WHERE Wdd.Rowid = l_del_detail_rowid_tab(updCnt);
2387:
2388: --
2389: IF l_debug_on THEN
2390: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Container records Updated in WDD : '
2391: || sql%rowcount || ', Time : '
2392: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2393: END IF;
2394: --

Line 2405: WSH_DEBUG_SV.log(l_module_name, 'After Container records Update', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));

2401: CLOSE Get_Delivery_Containers;
2402:
2403: --
2404: IF l_debug_on THEN
2405: WSH_DEBUG_SV.log(l_module_name, 'After Container records Update', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
2406: END IF;
2407: --
2408:
2409: FOR TmpDelRec IN Get_Tmp_Deliveries

Line 2414: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_NEW_DELIVERIES_PVT.Table_To_Record', WSH_DEBUG_SV.C_PROC_LEVEL);

2410: LOOP
2411: -- Bug 5606960# G-Log Changes: Calling API's to update delivery's location.
2412: --
2413: IF l_debug_on THEN
2414: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_NEW_DELIVERIES_PVT.Table_To_Record', WSH_DEBUG_SV.C_PROC_LEVEL);
2415: END IF;
2416: --
2417:
2418: l_return_status := NULL;

Line 2428: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Table_To_Record : ' || l_return_status);

2424: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2425: THEN
2426: --
2427: IF l_debug_on THEN
2428: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Table_To_Record : ' || l_return_status);
2429: END IF;
2430: --
2431: Raise Merge_Location_Exp;
2432: END IF;

Line 2446: WSH_DEBUG_SV.log(l_module_name, 'Error returned from Get_Delivery_Hash : ' || l_return_status);

2442: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2443: THEN
2444: --
2445: IF l_debug_on THEN
2446: WSH_DEBUG_SV.log(l_module_name, 'Error returned from Get_Delivery_Hash : ' || l_return_status);
2447: END IF;
2448: --
2449: Raise Merge_Location_Exp;
2450: END IF;

Line 2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_NEW_DELIVERIES_PVT.Update_Delivery', WSH_DEBUG_SV.C_PROC_LEVEL);

2460: l_delivery_rec.program_update_date := SYSDATE;
2461:
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_NEW_DELIVERIES_PVT.Update_Delivery', WSH_DEBUG_SV.C_PROC_LEVEL);
2465: END IF;
2466: --
2467:
2468: l_return_status := NULL;

Line 2478: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Update_Delivery : ' || l_return_status);

2474: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2475: THEN
2476: --
2477: IF l_debug_on THEN
2478: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_NEW_DELIVERIES_PVT.Update_Delivery : ' || l_return_status);
2479: END IF;
2480: --
2481: Raise Merge_Location_Exp;
2482: END IF;

Line 2519: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_DELIVERIES_GRP.Delivery_Action', WSH_DEBUG_SV.C_PROC_LEVEL);

2515: l_del_attrs(1).organization_id := l_organization_id_tab(i);
2516: l_return_status := NULL;
2517: --
2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling API WSH_DELIVERIES_GRP.Delivery_Action', WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522:
2523: WSH_DELIVERIES_GRP.Delivery_Action (

Line 2539: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_DELIVERIES_GRP.Delivery_Action : ' || l_return_status);

2535: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2536: THEN
2537: --
2538: IF l_debug_on THEN
2539: WSH_DEBUG_SV.log(l_module_name, 'Error returned from WSH_DELIVERIES_GRP.Delivery_Action : ' || l_return_status);
2540: END IF;
2541: --
2542: Raise Merge_Location_Exp;
2543: END IF;

Line 2558: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from Wsh_Tmp : '

2554: WHERE Rowid = l_tmp_rowid_tab(updCnt);
2555:
2556: --
2557: IF l_debug_on THEN
2558: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from Wsh_Tmp : '
2559: || sql%rowcount || ', Time : '
2560: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2561: END IF;
2562: --

Line 2587: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);

2583: l_message_text := FND_MESSAGE.Get;
2584:
2585: --
2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2588: END IF;
2589: --
2590:
2591: l_return_status := NULL;

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

2616: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS )
2617: THEN
2618: --
2619: IF l_debug_on THEN
2620: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
2621: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2622: END IF;
2623: --
2624: x_return_status := l_return_status;

Line 2621: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);

2617: THEN
2618: --
2619: IF l_debug_on THEN
2620: WSH_DEBUG_SV.log(l_module_name, 'l_return_status', l_return_status);
2621: WSH_DEBUG_SV.logmsg(l_module_name, 'Error While Calling WSH_XC_UTIL.Log_Exception', WSH_DEBUG_SV.C_PROC_LEVEL);
2622: END IF;
2623: --
2624: x_return_status := l_return_status;
2625: RAISE Merge_Location_Exp;

Line 2646: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Stop records Updated in WTS : '

2642: WHERE Column2 IS NOT NULL);
2643:
2644: --
2645: IF l_debug_on THEN
2646: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Stop records Updated in WTS : '
2647: || sql%rowcount || ', Time : '
2648: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2649: END IF;
2650: --

Line 2657: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from temp table : '

2653: DELETE FROM wsh_tmp;
2654:
2655: --
2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name, 'No of records deleted from temp table : '
2658: || sql%rowcount || ', Time : '
2659: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2660: END IF;
2661: --

Line 2676: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Deliver_Loc_details', l_del_detail_rowid_tab.COUNT);

2672: l_del_detail_rowid_tab LIMIT G_FETCH_LIMIT;
2673:
2674: --
2675: IF ( l_debug_on ) THEN
2676: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Deliver_Loc_details', l_del_detail_rowid_tab.COUNT);
2677: END IF;
2678: --
2679:
2680: -- Update Deliver to Locations in Wsh_Delivery_Details table during

Line 2699: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD : '

2695: WHERE WDD.Rowid = l_del_detail_rowid_tab(i);
2696:
2697: --
2698: IF l_debug_on THEN
2699: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD : '
2700: || sql%rowcount || ', Time : '
2701: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2702: END IF;
2703: --

Line 2720: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Del_Loc_Cont_Details', l_del_detail_id_tab.COUNT);

2716: l_del_detail_id_tab LIMIT G_FETCH_LIMIT;
2717:
2718: --
2719: IF ( l_debug_on ) THEN
2720: WSH_DEBUG_SV.log(l_module_name, 'No of Records Fetched from Get_Del_Loc_Cont_Details', l_del_detail_id_tab.COUNT);
2721: END IF;
2722: --
2723:
2724: -- Update Deliver to Locations in Wsh_Delivery_Details table during

Line 2743: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD Cont Del Loc : '

2739: AND WDD.Container_Flag = 'Y'; -- To make sure that we are updating container records
2740:
2741: --
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.logmsg(l_module_name, 'No of Rows Updated in WDD Cont Del Loc : '
2744: || sql%rowcount || ', Time : '
2745: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2746: END IF;
2747: --

Line 2757: WSH_DEBUG_SV.log(l_module_name, 'Before WPR Update', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));

2753: CLOSE Get_Del_Loc_Cont_Details;
2754:
2755: --
2756: IF l_debug_on THEN
2757: WSH_DEBUG_SV.log(l_module_name, 'Before WPR Update', TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS'));
2758: END IF;
2759: --
2760:
2761: UPDATE WSH_PICKING_RULES WPR

Line 2778: WSH_DEBUG_SV.logmsg(l_module_name, 'No of rows updated in WPR : '

2774: AND CA.Cust_Account_Id = WPR.Customer_Id );
2775:
2776: --
2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.logmsg(l_module_name, 'No of rows updated in WPR : '
2779: || sql%rowcount || ', Time : '
2780: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF ;

Line 2781: WSH_DEBUG_SV.pop(l_module_name);

2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.logmsg(l_module_name, 'No of rows updated in WPR : '
2779: || sql%rowcount || ', Time : '
2780: || TO_CHAR(SYSDATE,'YYYY/MM/DD HH24:MI:SS') );
2781: WSH_DEBUG_SV.pop(l_module_name);
2782: END IF ;
2783: --
2784: EXCEPTION
2785: --

Line 2820: WSH_DEBUG_SV.logmsg(l_module_name, 'Merge_Location_Exp occurred');

2816: END IF;
2817:
2818: --
2819: IF l_debug_on THEN
2820: WSH_DEBUG_SV.logmsg(l_module_name, 'Merge_Location_Exp occurred');
2821: WSH_DEBUG_SV.pop(l_module_name);
2822: END IF;
2823: --
2824:

Line 2821: WSH_DEBUG_SV.pop(l_module_name);

2817:
2818: --
2819: IF l_debug_on THEN
2820: WSH_DEBUG_SV.logmsg(l_module_name, 'Merge_Location_Exp occurred');
2821: WSH_DEBUG_SV.pop(l_module_name);
2822: END IF;
2823: --
2824:
2825: WHEN OTHERS THEN

Line 2862: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error......');

2858: END IF;
2859:
2860: --
2861: IF l_debug_on THEN
2862: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error......');
2863: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
2864: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
2865: WSH_DEBUG_SV.pop(l_module_name);
2866: END IF;

Line 2863: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);

2859:
2860: --
2861: IF l_debug_on THEN
2862: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error......');
2863: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
2864: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
2865: WSH_DEBUG_SV.pop(l_module_name);
2866: END IF;
2867: --

Line 2864: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);

2860: --
2861: IF l_debug_on THEN
2862: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error......');
2863: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
2864: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
2865: WSH_DEBUG_SV.pop(l_module_name);
2866: END IF;
2867: --
2868: END Merge_Location;

Line 2865: WSH_DEBUG_SV.pop(l_module_name);

2861: IF l_debug_on THEN
2862: WSH_DEBUG_SV.logmsg(l_module_name, 'Unexpected Error......');
2863: WSH_DEBUG_SV.log(l_module_name, 'Error Code', sqlcode);
2864: WSH_DEBUG_SV.log(l_module_name, 'Error Mesg', sqlerrm);
2865: WSH_DEBUG_SV.pop(l_module_name);
2866: END IF;
2867: --
2868: END Merge_Location;
2869: