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_CAL_ASG_VALIDATIONS dependencies on WSH_CAL_ASG_VALIDATIONS

Line 1: PACKAGE BODY WSH_CAL_ASG_VALIDATIONS AS

1: PACKAGE BODY WSH_CAL_ASG_VALIDATIONS AS
2: -- $Header: WSHCAVLB.pls 120.2.12010000.3 2009/11/02 12:41:58 skanduku ship $
3:
4: /*+=======================================================================+
5: --| Copyright (c) 1998 Oracle Corporation |

Line 21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CAL_ASG_VALIDATIONS';

17: --+======================================================================*/
18: --===================
19: -- CONSTANTS
20: --===================
21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CAL_ASG_VALIDATIONS';
22: -- add your constants here if any
23:
24: --===================
25: -- PUBLIC VARIABLES

Line 453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

449: --
450: -- Debug Statements
451: --
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
454: END IF;
455: --
456: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
457: ( p_receive_date

Line 456: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
454: END IF;
455: --
456: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
457: ( p_receive_date
458: , 'RECEIVING'
459: , p_receive_assoc_type
460: , p_receive_location_id

Line 476: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

472: --
473: -- Debug Statements
474: --
475: IF l_debug_on THEN
476: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
477: END IF;
478: --
479: WSH_CAL_ASG_VALIDATIONS.Single_Date(
480: x_suggest_receive_date

Line 479: WSH_CAL_ASG_VALIDATIONS.Single_Date(

475: IF l_debug_on THEN
476: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
477: END IF;
478: --
479: WSH_CAL_ASG_VALIDATIONS.Single_Date(
480: x_suggest_receive_date
481: , 'CARRIER'
482: , 'CARRIER'
483: , p_receive_location_id

Line 511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

507: --
508: -- Debug Statements
509: --
510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
512: END IF;
513: --
514: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
515: ( p_ship_date

Line 514: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

510: IF l_debug_on THEN
511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
512: END IF;
513: --
514: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
515: ( p_ship_date
516: , 'SHIPPING'
517: , p_ship_assoc_type
518: , p_ship_location_id

Line 534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

530: --
531: -- Debug Statements
532: --
533: IF l_debug_on THEN
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: WSH_CAL_ASG_VALIDATIONS.Single_Date(
538: x_suggest_ship_date

Line 537: WSH_CAL_ASG_VALIDATIONS.Single_Date(

533: IF l_debug_on THEN
534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
535: END IF;
536: --
537: WSH_CAL_ASG_VALIDATIONS.Single_Date(
538: x_suggest_ship_date
539: , 'CARRIER'
540: , 'CARRIER'
541: , p_ship_location_id

Line 573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

569: --
570: -- Debug Statements
571: --
572: IF l_debug_on THEN
573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
574: END IF;
575: --
576:
577: /*

Line 578: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

574: END IF;
575: --
576:
577: /*
578: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
579: ( p_ship_date
580: , 'SHIPPING'
581: , p_ship_assoc_type
582: , p_ship_location_id

Line 598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

594: --
595: -- Debug Statements
596: --
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
599: END IF;
600: --
601: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
602: ( p_receive_date - (p_ship_date - x_suggest_ship_date)

Line 601: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
599: END IF;
600: --
601: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
602: ( p_receive_date - (p_ship_date - x_suggest_ship_date)
603: , 'RECEIVING'
604: , p_receive_assoc_type
605: , p_receive_location_id

Line 643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

639: --
640: -- Debug Statements
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
644: END IF;
645: --
646: WSH_CAL_ASG_VALIDATIONS.Single_Date(
647: x_suggest_ship_date

Line 646: WSH_CAL_ASG_VALIDATIONS.Single_Date(

642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
644: END IF;
645: --
646: WSH_CAL_ASG_VALIDATIONS.Single_Date(
647: x_suggest_ship_date
648: , 'CARRIER'
649: , p_ship_assoc_type
650: , p_ship_location_id

Line 663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

659: --
660: -- Debug Statements
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
664: END IF;
665: --
666: WSH_CAL_ASG_VALIDATIONS.Single_Date(
667: x_suggest_receive_date

Line 666: WSH_CAL_ASG_VALIDATIONS.Single_Date(

662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
664: END IF;
665: --
666: WSH_CAL_ASG_VALIDATIONS.Single_Date(
667: x_suggest_receive_date
668: , 'CARRIER'
669: , p_receive_assoc_type
670: , p_receive_location_id

Line 706: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

702: WSH_DEBUG_SV.log(l_module_name,'l_suggest_ship_date',l_suggest_ship_date);
703: WSH_DEBUG_SV.log(l_module_name,'l_primary_threshold',l_primary_threshold);
704: END IF;
705:
706: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
707: ( l_suggest_ship_date
708: , 'SHIPPING'
709: , p_ship_assoc_type
710: , p_ship_location_id

Line 735: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

731: --
732: -- Debug Statements
733: --
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
736: END IF;
737: --
738: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
739: ( p_receive_date - (p_ship_date - x_suggest_ship_date)

Line 738: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
736: END IF;
737: --
738: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
739: ( p_receive_date - (p_ship_date - x_suggest_ship_date)
740: , 'RECEIVING'
741: , p_receive_assoc_type
742: , p_receive_location_id

Line 795: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

791: WSH_DEBUG_SV.log(l_module_name,'l_primary_threshold',l_primary_threshold);
792: END IF;
793: --Bug 8567091 : 'Find_Valid_Date' is called for carrier Calendar validation instead of 'Single_Date'
794:
795: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
796: ( l_suggest_ship_date
797: , 'CARRIER'
798: , p_ship_assoc_type
799: , p_ship_location_id

Line 821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

817: --
818: -- Debug Statements
819: --
820: IF l_debug_on THEN
821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
822: END IF;
823: --
824: WSH_CAL_ASG_VALIDATIONS.Single_Date(
825: x_suggest_receive_date

Line 824: WSH_CAL_ASG_VALIDATIONS.Single_Date(

820: IF l_debug_on THEN
821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
822: END IF;
823: --
824: WSH_CAL_ASG_VALIDATIONS.Single_Date(
825: x_suggest_receive_date
826: , 'CARRIER'
827: , p_receive_assoc_type
828: , p_receive_location_id

Line 866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

862: --
863: -- Debug Statements
864: --
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
867: END IF;
868: --
869: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
870: ( p_receive_date

Line 869: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
867: END IF;
868: --
869: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
870: ( p_receive_date
871: , 'RECEIVING'
872: , p_receive_assoc_type
873: , p_receive_location_id

Line 889: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

885: --
886: -- Debug Statements
887: --
888: IF l_debug_on THEN
889: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
890: END IF;
891: --
892: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
893: ( p_ship_date - (p_receive_date - x_suggest_receive_date)

Line 892: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date

888: IF l_debug_on THEN
889: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.FIND_VALID_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
890: END IF;
891: --
892: WSH_CAL_ASG_VALIDATIONS.Find_Valid_Date
893: ( p_ship_date - (p_receive_date - x_suggest_receive_date)
894: , 'SHIPPING'
895: , p_ship_assoc_type
896: , p_ship_location_id

Line 934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

930: --
931: -- Debug Statements
932: --
933: IF l_debug_on THEN
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
935: END IF;
936: --
937: WSH_CAL_ASG_VALIDATIONS.Single_Date(
938: x_suggest_ship_date

Line 937: WSH_CAL_ASG_VALIDATIONS.Single_Date(

933: IF l_debug_on THEN
934: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
935: END IF;
936: --
937: WSH_CAL_ASG_VALIDATIONS.Single_Date(
938: x_suggest_ship_date
939: , 'CARRIER'
940: , p_ship_assoc_type
941: , p_ship_location_id

Line 954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

950: --
951: -- Debug Statements
952: --
953: IF l_debug_on THEN
954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
955: END IF;
956: --
957: WSH_CAL_ASG_VALIDATIONS.Single_Date(
958: x_suggest_receive_date

Line 957: WSH_CAL_ASG_VALIDATIONS.Single_Date(

953: IF l_debug_on THEN
954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
955: END IF;
956: --
957: WSH_CAL_ASG_VALIDATIONS.Single_Date(
958: x_suggest_receive_date
959: , p_receive_assoc_type
960: , 'CARRIER'
961: , p_receive_location_id

Line 1159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);

1155: --
1156: -- Debug Statements
1157: --
1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
1160: END IF;
1161: --
1162: WSH_CAL_ASG_VALIDATIONS.Single_Date(
1163: x_suggest_date

Line 1162: WSH_CAL_ASG_VALIDATIONS.Single_Date(

1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CAL_ASG_VALIDATIONS.SINGLE_DATE',WSH_DEBUG_SV.C_PROC_LEVEL);
1160: END IF;
1161: --
1162: WSH_CAL_ASG_VALIDATIONS.Single_Date(
1163: x_suggest_date
1164: , p_calendar_type
1165: , p_assoc_type
1166: , p_location_id

Line 1523: END WSH_CAL_ASG_VALIDATIONS;

1519: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1520: END IF;
1521: --
1522: END Single_Date;
1523: END WSH_CAL_ASG_VALIDATIONS;