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.MSC_CALENDAR dependencies on MSC_SCH_WB

Line 986: msc_sch_wb.atp_debug ('* Begin Function Get_Calendar_Code *');

982: C_ITEM_VENDOR_SITE CONSTANT NUMBER := 13;
983:
984: BEGIN
985: IF PG_DEBUG in ('Y','C') THEN
986: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);

Line 987: msc_sch_wb.atp_debug ('Input');

983:
984: BEGIN
985: IF PG_DEBUG in ('Y','C') THEN
986: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );

Line 988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );

984: BEGIN
985: IF PG_DEBUG in ('Y','C') THEN
986: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );

Line 989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );

985: IF PG_DEBUG in ('Y','C') THEN
986: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);

Line 990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);

986: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);

Line 991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );

987: msc_sch_wb.atp_debug ('________________Input________________');
988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);

Line 992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );

988: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);

Line 993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);

989: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);

Line 994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);

990: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
998: msc_sch_wb.atp_debug (' ');

Line 995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);

991: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
998: msc_sch_wb.atp_debug (' ');
999: END IF;

Line 996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);

992: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
998: msc_sch_wb.atp_debug (' ');
999: END IF;
1000:

Line 997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);

993: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
998: msc_sch_wb.atp_debug (' ');
999: END IF;
1000:
1001: -- case 1. Searching for a valid suplier's shipping calendar (SSC) or valid customer receiving calendar (CRC)

Line 998: msc_sch_wb.atp_debug (' ');

994: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
995: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
996: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
997: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
998: msc_sch_wb.atp_debug (' ');
999: END IF;
1000:
1001: -- case 1. Searching for a valid suplier's shipping calendar (SSC) or valid customer receiving calendar (CRC)
1002: IF (p_calendar_type = MSC_CALENDAR.SSC OR p_calendar_type = MSC_CALENDAR.CRC) THEN

Line 1060: msc_sch_wb.atp_debug ('Get_Calendar_Code :' || ' Use OMC instead on ORC/OSC');

1056:
1057: -- Bug 3647208 - For b/w compatibility use OMC instead of ORC/OSC
1058: -- Raise exception so that the OMC query gets executed.
1059: IF PG_DEBUG in ('Y','C') THEN
1060: msc_sch_wb.atp_debug ('Get_Calendar_Code :' || ' Use OMC instead on ORC/OSC');
1061: END IF;
1062: RAISE NO_DATA_FOUND;
1063:
1064: END IF;

Line 1119: msc_sch_wb.atp_debug ('Output');

1115:
1116: END IF;
1117:
1118: IF PG_DEBUG in ('Y','C') THEN
1119: msc_sch_wb.atp_debug ('________________Output________________');
1120: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1121: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1122: msc_sch_wb.atp_debug (' ');
1123: END IF;

Line 1120: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);

1116: END IF;
1117:
1118: IF PG_DEBUG in ('Y','C') THEN
1119: msc_sch_wb.atp_debug ('________________Output________________');
1120: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1121: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1122: msc_sch_wb.atp_debug (' ');
1123: END IF;
1124:

Line 1121: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);

1117:
1118: IF PG_DEBUG in ('Y','C') THEN
1119: msc_sch_wb.atp_debug ('________________Output________________');
1120: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1121: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1122: msc_sch_wb.atp_debug (' ');
1123: END IF;
1124:
1125: RETURN l_calendar_code;

Line 1122: msc_sch_wb.atp_debug (' ');

1118: IF PG_DEBUG in ('Y','C') THEN
1119: msc_sch_wb.atp_debug ('________________Output________________');
1120: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1121: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1122: msc_sch_wb.atp_debug (' ');
1123: END IF;
1124:
1125: RETURN l_calendar_code;
1126:

Line 1140: msc_sch_wb.atp_debug (' No Data Found Exception *');

1136: AND SR_TP_ID = p_organization_id;
1137: END IF;
1138:
1139: IF PG_DEBUG in ('Y','C') THEN
1140: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1141: msc_sch_wb.atp_debug ('________________Output________________');
1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1144: msc_sch_wb.atp_debug (' ');

Line 1141: msc_sch_wb.atp_debug ('Output');

1137: END IF;
1138:
1139: IF PG_DEBUG in ('Y','C') THEN
1140: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1141: msc_sch_wb.atp_debug ('________________Output________________');
1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1144: msc_sch_wb.atp_debug (' ');
1145: END IF;

Line 1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);

1138:
1139: IF PG_DEBUG in ('Y','C') THEN
1140: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1141: msc_sch_wb.atp_debug ('________________Output________________');
1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1144: msc_sch_wb.atp_debug (' ');
1145: END IF;
1146:

Line 1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);

1139: IF PG_DEBUG in ('Y','C') THEN
1140: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1141: msc_sch_wb.atp_debug ('________________Output________________');
1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1144: msc_sch_wb.atp_debug (' ');
1145: END IF;
1146:
1147: RETURN l_calendar_code;

Line 1144: msc_sch_wb.atp_debug (' ');

1140: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1141: msc_sch_wb.atp_debug ('________________Output________________');
1142: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1143: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1144: msc_sch_wb.atp_debug (' ');
1145: END IF;
1146:
1147: RETURN l_calendar_code;
1148:

Line 1176: msc_sch_wb.atp_debug ('* Begin Function Get_Calendar_Code *');

1172: C_ITEM_VENDOR_SITE CONSTANT NUMBER := 13;
1173:
1174: BEGIN
1175: IF PG_DEBUG in ('Y','C') THEN
1176: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);

Line 1177: msc_sch_wb.atp_debug ('Input');

1173:
1174: BEGIN
1175: IF PG_DEBUG in ('Y','C') THEN
1176: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );

Line 1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );

1174: BEGIN
1175: IF PG_DEBUG in ('Y','C') THEN
1176: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );

Line 1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );

1175: IF PG_DEBUG in ('Y','C') THEN
1176: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);

Line 1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);

1176: msc_sch_wb.atp_debug ('***** Begin Function Get_Calendar_Code *****');
1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);

Line 1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );

1177: msc_sch_wb.atp_debug ('________________Input________________');
1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);

Line 1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );

1178: msc_sch_wb.atp_debug (' Instance ID : ' || p_instance_id );
1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);

Line 1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);

1179: msc_sch_wb.atp_debug (' Plan ID : ' || p_plan_id );
1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);

Line 1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);

1180: msc_sch_wb.atp_debug (' Inv Item ID : ' || p_inventory_item_id);
1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
1188: msc_sch_wb.atp_debug (' ');

Line 1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);

1181: msc_sch_wb.atp_debug (' Partner ID : ' || p_partner_id );
1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
1188: msc_sch_wb.atp_debug (' ');
1189: END IF;

Line 1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);

1182: msc_sch_wb.atp_debug (' Partner Site ID : ' || p_partner_site_id );
1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
1188: msc_sch_wb.atp_debug (' ');
1189: END IF;
1190:

Line 1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);

1183: msc_sch_wb.atp_debug (' Partner Type : ' || p_partner_type);
1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
1188: msc_sch_wb.atp_debug (' ');
1189: END IF;
1190:
1191: -- case 1. Searching for a valid suplier's shipping calendar (SSC) or valid customer receiving calendar (CRC)

Line 1188: msc_sch_wb.atp_debug (' ');

1184: msc_sch_wb.atp_debug (' Organization ID : ' || p_organization_id);
1185: msc_sch_wb.atp_debug (' Ship Method Code : ' || p_ship_method_code);
1186: msc_sch_wb.atp_debug (' Calendar Type : ' || p_calendar_type);
1187: msc_sch_wb.atp_debug ('G_USE_SHIP_REC_CAL: ' || MSC_ATP_PVT.G_USE_SHIP_REC_CAL);
1188: msc_sch_wb.atp_debug (' ');
1189: END IF;
1190:
1191: -- case 1. Searching for a valid suplier's shipping calendar (SSC) or valid customer receiving calendar (CRC)
1192: IF (p_calendar_type = MSC_CALENDAR.SSC OR p_calendar_type = MSC_CALENDAR.CRC) THEN

Line 1244: msc_sch_wb.atp_debug ('Get_Calendar_Code :' || ' Use OMC instead on ORC/OSC');

1240: /*ELSE
1241: -- Bug 3647208 - For b/w compatibility use OMC instead of ORC/OSC
1242: -- Raise exception so that the OMC query gets executed.
1243: IF PG_DEBUG in ('Y','C') THEN
1244: msc_sch_wb.atp_debug ('Get_Calendar_Code :' || ' Use OMC instead on ORC/OSC');
1245: END IF;
1246: RAISE NO_DATA_FOUND;
1247: END IF;*/
1248: -- case 3. Searching for valid Intransit Calendar (VIC)

Line 1292: msc_sch_wb.atp_debug ('Output');

1288: AND PARTNER_TYPE = 3
1289: AND SR_TP_ID = p_organization_id;
1290: END IF;
1291: IF PG_DEBUG in ('Y','C') THEN
1292: msc_sch_wb.atp_debug ('________________Output________________');
1293: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1294: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1295: msc_sch_wb.atp_debug (' ');
1296: END IF;

Line 1293: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);

1289: AND SR_TP_ID = p_organization_id;
1290: END IF;
1291: IF PG_DEBUG in ('Y','C') THEN
1292: msc_sch_wb.atp_debug ('________________Output________________');
1293: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1294: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1295: msc_sch_wb.atp_debug (' ');
1296: END IF;
1297: RETURN l_calendar_code;

Line 1294: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);

1290: END IF;
1291: IF PG_DEBUG in ('Y','C') THEN
1292: msc_sch_wb.atp_debug ('________________Output________________');
1293: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1294: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1295: msc_sch_wb.atp_debug (' ');
1296: END IF;
1297: RETURN l_calendar_code;
1298: EXCEPTION

Line 1295: msc_sch_wb.atp_debug (' ');

1291: IF PG_DEBUG in ('Y','C') THEN
1292: msc_sch_wb.atp_debug ('________________Output________________');
1293: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1294: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1295: msc_sch_wb.atp_debug (' ');
1296: END IF;
1297: RETURN l_calendar_code;
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN

Line 1311: msc_sch_wb.atp_debug (' No Data Found Exception *');

1307: AND SR_TP_ID = p_organization_id;
1308: END IF;
1309:
1310: IF PG_DEBUG in ('Y','C') THEN
1311: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1312: msc_sch_wb.atp_debug ('________________Output________________');
1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1315: msc_sch_wb.atp_debug (' ');

Line 1312: msc_sch_wb.atp_debug ('Output');

1308: END IF;
1309:
1310: IF PG_DEBUG in ('Y','C') THEN
1311: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1312: msc_sch_wb.atp_debug ('________________Output________________');
1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1315: msc_sch_wb.atp_debug (' ');
1316: END IF;

Line 1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);

1309:
1310: IF PG_DEBUG in ('Y','C') THEN
1311: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1312: msc_sch_wb.atp_debug ('________________Output________________');
1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1315: msc_sch_wb.atp_debug (' ');
1316: END IF;
1317:

Line 1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);

1310: IF PG_DEBUG in ('Y','C') THEN
1311: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1312: msc_sch_wb.atp_debug ('________________Output________________');
1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1315: msc_sch_wb.atp_debug (' ');
1316: END IF;
1317:
1318: RETURN l_calendar_code;

Line 1315: msc_sch_wb.atp_debug (' ');

1311: msc_sch_wb.atp_debug ('****** No Data Found Exception *******');
1312: msc_sch_wb.atp_debug ('________________Output________________');
1313: msc_sch_wb.atp_debug (' Calendar Code : ' || l_calendar_code);
1314: msc_sch_wb.atp_debug (' Association Type : ' || p_association_type);
1315: msc_sch_wb.atp_debug (' ');
1316: END IF;
1317:
1318: RETURN l_calendar_code;
1319:

Line 1619: msc_sch_wb.atp_debug ('* Begin Function THREE_STEP_CAL_OFFSET_DATE *');

1615: l_output_date DATE := NULL;
1616:
1617: BEGIN
1618: IF PG_DEBUG in ('Y','C') THEN
1619: msc_sch_wb.atp_debug ('***** Begin Function THREE_STEP_CAL_OFFSET_DATE *****');
1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );

Line 1620: msc_sch_wb.atp_debug ('Input');

1616:
1617: BEGIN
1618: IF PG_DEBUG in ('Y','C') THEN
1619: msc_sch_wb.atp_debug ('***** Begin Function THREE_STEP_CAL_OFFSET_DATE *****');
1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );

Line 1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );

1617: BEGIN
1618: IF PG_DEBUG in ('Y','C') THEN
1619: msc_sch_wb.atp_debug ('***** Begin Function THREE_STEP_CAL_OFFSET_DATE *****');
1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );

Line 1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );

1618: IF PG_DEBUG in ('Y','C') THEN
1619: msc_sch_wb.atp_debug ('***** Begin Function THREE_STEP_CAL_OFFSET_DATE *****');
1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
1626: msc_sch_wb.atp_debug (' ');

Line 1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );

1619: msc_sch_wb.atp_debug ('***** Begin Function THREE_STEP_CAL_OFFSET_DATE *****');
1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
1626: msc_sch_wb.atp_debug (' ');
1627: END IF;

Line 1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );

1620: msc_sch_wb.atp_debug ('________________Input________________');
1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
1626: msc_sch_wb.atp_debug (' ');
1627: END IF;
1628: -- First date is computed using p_input_date, first calendar and its validation_type

Line 1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );

1621: msc_sch_wb.atp_debug (' Input Date : ' || p_input_date );
1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
1626: msc_sch_wb.atp_debug (' ');
1627: END IF;
1628: -- First date is computed using p_input_date, first calendar and its validation_type
1629: IF p_first_cal_code = MSC_CALENDAR.FOC THEN

Line 1626: msc_sch_wb.atp_debug (' ');

1622: msc_sch_wb.atp_debug (' First Cal Code : ' || p_first_cal_code );
1623: msc_sch_wb.atp_debug (' Second Cal Code : ' || p_second_cal_code );
1624: msc_sch_wb.atp_debug (' Third Cal Code : ' || p_third_cal_code );
1625: msc_sch_wb.atp_debug (' Days Offset : ' || p_offset_days );
1626: msc_sch_wb.atp_debug (' ');
1627: END IF;
1628: -- First date is computed using p_input_date, first calendar and its validation_type
1629: IF p_first_cal_code = MSC_CALENDAR.FOC THEN
1630: l_first_date := p_input_date;

Line 1646: msc_sch_wb.atp_debug (' Date after validation on first cal: ' || l_first_date );

1642: l_first_date := p_input_date;
1643: END IF;
1644:
1645: IF PG_DEBUG in ('Y','C') THEN
1646: msc_sch_wb.atp_debug (' Date after validation on first cal: ' || l_first_date );
1647: END IF;
1648:
1649: -- Second date is computed using first date, 2nd calendar and offset days
1650: IF (p_offset_days = 0) and (p_second_cal_code = MSC_CALENDAR.FOC) THEN

Line 1683: msc_sch_wb.atp_debug (' Date after offset using second cal: ' || l_second_date );

1679: l_second_date := l_first_date;
1680: END IF;
1681:
1682: IF PG_DEBUG in ('Y','C') THEN
1683: msc_sch_wb.atp_debug (' Date after offset using second cal: ' || l_second_date );
1684: END IF;
1685:
1686: -- Third date = Output Date is computed using 2nd date, 3rd calendar and validation_type
1687: IF p_third_cal_code = MSC_CALENDAR.FOC THEN

Line 1704: msc_sch_wb.atp_debug (' Date after validation on third cal: ' || l_output_date );

1700: l_output_date := l_second_date;
1701: END IF;
1702:
1703: IF PG_DEBUG in ('Y','C') THEN
1704: msc_sch_wb.atp_debug (' Date after validation on third cal: ' || l_output_date );
1705: END IF;
1706:
1707: RETURN l_output_date;
1708: