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_X_EX5_PKG dependencies on MSC_X_NETTING_PKG

Line 98: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

94: msc_item_suppliers itm,
95: MSC_X_ITEM_SUPPLIERS_GTT iut,
96: MSC_X_ITEM_ORGS_GTT iot,
97: MSC_X_ITEM_SITES_GTT ist
98: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
99: AND sd.publisher_order_type = 15 -- ASN
100: AND sd.vmi_flag = 1
101: AND sd.customer_site_id = iot.company_key
102: AND sd.supplier_id = iut.object_id

Line 133: WHERE itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

129: msc_trading_partner_sites tps,
130: MSC_X_ITEM_SUPPLIERS_GTT iut,
131: MSC_X_ITEM_ORGS_GTT iot,
132: MSC_X_ITEM_SITES_GTT ist
133: WHERE itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
134: AND itm.organization_id = iot.sr_tp_id
135: AND itm.supplier_id = iut.tp_key
136: AND iut.tp_key = tp2.partner_id
137: AND tp2.sr_instance_id = itm.sr_instance_id

Line 194: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

190: msc_item_suppliers itm,
191: MSC_X_ITEM_SUPPLIERS_GTT iut,
192: MSC_X_ITEM_ORGS_GTT iot,
193: MSC_X_ITEM_SITES_GTT ist
194: WHERE sd.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
195: AND sd.publisher_order_type IN (9, 13, 16, 20) -- Onhand, PO, Rcpt, Req
196: AND sd.vmi_flag = 1
197: AND sd.customer_site_id = iot.company_key
198: AND sd.supplier_id = iut.object_id

Line 466: AND itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

462: and tps.sr_instance_id = tp2.sr_instance_id
463: AND tp2.partner_type = tps.partner_type
464: AND tps.partner_site_id = p_tx_supplier_site_id
465: and (p_tx_supplier_site_id is not null or rownum = 1)
466: AND itm.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
467: AND itm.organization_id = tp.sr_tp_id
468: AND itm.sr_instance_id = tp.sr_instance_id
469: AND itm.inventory_item_id = p_tx_item_id
470: AND itm.vmi_flag = 1

Line 573: , MSC_X_NETTING_PKG.G_PLAN_ID

569:
570: -- dbms_output.put_line('After Loop - exception_9_29');
571:
572: OPEN c_asl_attributes ( l_item_id
573: , MSC_X_NETTING_PKG.G_PLAN_ID
574: , l_sr_instance_id
575: , l_aps_organization_id
576: , l_aps_supplier_id
577: , l_aps_supplier_site_id

Line 609: , MSC_X_NETTING_PKG.G_PLAN_ID

605: || l_vmi_refresh_flag
606: );
607:
608: OPEN c_item_attributes_9_29 ( l_item_id
609: , MSC_X_NETTING_PKG.G_PLAN_ID
610: , l_customer_site_id
611: , l_publisher_id
612: , l_publisher_site_id
613: );

Line 687: MSC_X_NETTING_PKG.delete_obsolete_exceptions

683: ----------------------------------------------------------
684:
685: print_debug_info ( ' delete obsolete exception');
686:
687: MSC_X_NETTING_PKG.delete_obsolete_exceptions
688: (l_publisher_id,
689: l_publisher_site_id, --owning org
690: l_customer_id,
691: l_customer_site_id,

Line 694: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,

690: l_customer_id,
691: l_customer_site_id,
692: null, --l_supplier_id,
693: null, --l_supplier_site_id,
694: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
695: MSC_X_NETTING_PKG.G_EXCEP9,
696: MSC_X_NETTING_PKG.G_EXCEP29,
697: l_item_id,
698: null, --l_start_date,

Line 695: MSC_X_NETTING_PKG.G_EXCEP9,

691: l_customer_site_id,
692: null, --l_supplier_id,
693: null, --l_supplier_site_id,
694: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
695: MSC_X_NETTING_PKG.G_EXCEP9,
696: MSC_X_NETTING_PKG.G_EXCEP29,
697: l_item_id,
698: null, --l_start_date,
699: null,

Line 696: MSC_X_NETTING_PKG.G_EXCEP29,

692: null, --l_supplier_id,
693: null, --l_supplier_site_id,
694: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
695: MSC_X_NETTING_PKG.G_EXCEP9,
696: MSC_X_NETTING_PKG.G_EXCEP29,
697: l_item_id,
698: null, --l_start_date,
699: null,
700: MSC_X_NETTING_PKG.vmi

Line 700: MSC_X_NETTING_PKG.vmi

696: MSC_X_NETTING_PKG.G_EXCEP29,
697: l_item_id,
698: null, --l_start_date,
699: null,
700: MSC_X_NETTING_PKG.vmi
701: );
702:
703: print_debug_info ( ' Number of obsolete exceptions deleted of type 9_29 = ' || SQL%ROWCOUNT);
704:

Line 707: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_customer_id,

703: print_debug_info ( ' Number of obsolete exceptions deleted of type 9_29 = ' || SQL%ROWCOUNT);
704:
705: -- bug# 4501946 : added delete procedure for exception type = 10, 30
706:
707: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_customer_id,
708: l_customer_site_id,
709: null, --customer_id
710: null, --customer_site_id
711: l_publisher_id, --supplier_id

Line 713: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,

709: null, --customer_id
710: null, --customer_site_id
711: l_publisher_id, --supplier_id
712: l_publisher_site_id, --supplier_site_id
713: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
714: MSC_X_NETTING_PKG.G_EXCEP10,
715: MSC_X_NETTING_PKG.G_EXCEP30,
716: l_item_id,
717: null,

Line 714: MSC_X_NETTING_PKG.G_EXCEP10,

710: null, --customer_site_id
711: l_publisher_id, --supplier_id
712: l_publisher_site_id, --supplier_site_id
713: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
714: MSC_X_NETTING_PKG.G_EXCEP10,
715: MSC_X_NETTING_PKG.G_EXCEP30,
716: l_item_id,
717: null,
718: null,

Line 715: MSC_X_NETTING_PKG.G_EXCEP30,

711: l_publisher_id, --supplier_id
712: l_publisher_site_id, --supplier_site_id
713: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
714: MSC_X_NETTING_PKG.G_EXCEP10,
715: MSC_X_NETTING_PKG.G_EXCEP30,
716: l_item_id,
717: null,
718: null,
719: MSC_X_NETTING_PKG.VMI);

Line 719: MSC_X_NETTING_PKG.VMI);

715: MSC_X_NETTING_PKG.G_EXCEP30,
716: l_item_id,
717: null,
718: null,
719: MSC_X_NETTING_PKG.VMI);
720:
721: print_debug_info ( ' Number of obsolete exceptions deleted of type 10,30= ' || SQL%ROWCOUNT);
722:
723:

Line 726: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(

722:
723:
724:
725:
726: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(
727: l_customer_id,
728: l_customer_site_id,
729: l_item_id,
730: p_refresh_number,

Line 731: MSC_X_NETTING_PKG.VMI,

727: l_customer_id,
728: l_customer_site_id,
729: l_item_id,
730: p_refresh_number,
731: MSC_X_NETTING_PKG.VMI,
732: MSC_X_NETTING_PKG.buyer
733: );
734:
735: -- calculate the end date of the replenish time window

Line 732: MSC_X_NETTING_PKG.buyer

728: l_customer_site_id,
729: l_item_id,
730: p_refresh_number,
731: MSC_X_NETTING_PKG.VMI,
732: MSC_X_NETTING_PKG.buyer
733: );
734:
735: -- calculate the end date of the replenish time window
736: l_time_fence_end_date := SYSDATE + NVL(p_replenish_time_fence * l_lead_time, 0);

Line 742: , MSC_X_NETTING_PKG.G_PLAN_ID

738: print_debug_info ( ' Time fence date = ' || l_time_fence_end_date);
739:
740: -- compute total supply
741: OPEN c_asn_quantity( l_item_id
742: , MSC_X_NETTING_PKG.G_PLAN_ID
743: , l_customer_id
744: , l_customer_site_id
745: , l_publisher_id
746: , l_publisher_site_id

Line 754: , MSC_X_NETTING_PKG.G_PLAN_ID

750: INTO l_asn_quantity;
751: CLOSE c_asn_quantity;
752:
753: OPEN c_allocated_onhand_quantity ( l_item_id
754: , MSC_X_NETTING_PKG.G_PLAN_ID
755: , l_customer_id
756: , l_customer_site_id
757: , l_publisher_id
758: , l_publisher_site_id

Line 766: , MSC_X_NETTING_PKG.G_PLAN_ID

762: INTO l_allocated_onhand_quantity;
763: CLOSE c_allocated_onhand_quantity;
764:
765: OPEN c_shipment_receipt_quantity( l_item_id
766: , MSC_X_NETTING_PKG.G_PLAN_ID
767: , l_customer_id
768: , l_customer_site_id
769: , l_publisher_id
770: , l_publisher_site_id

Line 777: , MSC_X_NETTING_PKG.G_PLAN_ID

773: FETCH c_shipment_receipt_quantity INTO l_shipment_receipt_quantity;
774: CLOSE c_shipment_receipt_quantity;
775:
776: OPEN c_requisition_quantity( l_item_id
777: , MSC_X_NETTING_PKG.G_PLAN_ID
778: , l_customer_id
779: , l_customer_site_id
780: , l_publisher_id
781: , l_publisher_site_id

Line 788: , MSC_X_NETTING_PKG.G_PLAN_ID

784: FETCH c_requisition_quantity INTO l_requisition_quantity;
785: CLOSE c_requisition_quantity;
786:
787: OPEN c_po_quantity( l_item_id
788: , MSC_X_NETTING_PKG.G_PLAN_ID
789: , l_customer_id
790: , l_customer_site_id
791: , l_publisher_id
792: , l_publisher_site_id

Line 841: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --vmi item shortage customer site

837: );
838:
839: if l_total_supply < l_lower_limit_quantity then
840: --exception 2.5 detected
841: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --vmi item shortage customer site
842: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
843: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
845:

Line 842: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;

838:
839: if l_total_supply < l_lower_limit_quantity then
840: --exception 2.5 detected
841: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --vmi item shortage customer site
842: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
843: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
845:
846: print_user_info ( ' VMI item shortage at customer site');

Line 843: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

839: if l_total_supply < l_lower_limit_quantity then
840: --exception 2.5 detected
841: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --vmi item shortage customer site
842: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
843: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
845:
846: print_user_info ( ' VMI item shortage at customer site');
847:

Line 844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

840: --exception 2.5 detected
841: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --vmi item shortage customer site
842: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
843: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
845:
846: print_user_info ( ' VMI item shortage at customer site');
847:
848: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

Line 848: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

844: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
845:
846: print_user_info ( ' VMI item shortage at customer site');
847:
848: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
849: l_publisher_site_id,
850: l_item_id,
851: l_exception_type,
852: l_exception_group);

Line 856: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,

852: l_exception_group);
853:
854: print_debug_info ( ' exception summary updated');
855:
856: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,
857: l_publisher_name,
858: l_publisher_site_id,
859: l_publisher_site_name,
860: l_item_id,

Line 904: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --vmi item shortage at your site

900: print_debug_info ( ' exception detail added');
901:
902: if l_generate_complement then
903: --dbms_output.put_line('In complement exception 9');
904: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --vmi item shortage at your site
905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
908:

Line 905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;

901:
902: if l_generate_complement then
903: --dbms_output.put_line('In complement exception 9');
904: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --vmi item shortage at your site
905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
908:
909: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at sup site

Line 906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

902: if l_generate_complement then
903: --dbms_output.put_line('In complement exception 9');
904: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --vmi item shortage at your site
905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
908:
909: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at sup site
910:

Line 907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

903: --dbms_output.put_line('In complement exception 9');
904: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --vmi item shortage at your site
905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
908:
909: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at sup site
910:
911: print_user_info ( ' VMI item excess at your site');

Line 909: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at sup site

905: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
906: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
907: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
908:
909: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at sup site
910:
911: print_user_info ( ' VMI item excess at your site');
912:
913: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----

Line 915: MSC_X_NETTING_PKG.update_exceptions_summary(l_customer_id,

911: print_user_info ( ' VMI item excess at your site');
912:
913: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----
914:
915: MSC_X_NETTING_PKG.update_exceptions_summary(l_customer_id,
916: l_customer_site_id,
917: l_item_id,
918: l_exception_type,
919: l_exception_group);

Line 921: MSC_X_NETTING_PKG.add_exception_details(l_customer_id,

917: l_item_id,
918: l_exception_type,
919: l_exception_group);
920:
921: MSC_X_NETTING_PKG.add_exception_details(l_customer_id,
922: l_customer_name,
923: l_customer_site_id,
924: l_customer_site_name,
925: l_item_id,

Line 973: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess customer site

969:
970: print_user_info( ' VMI item excess at customer site');
971:
972: --exception 7.5 detected
973: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess customer site
974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
977:

Line 974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;

970: print_user_info( ' VMI item excess at customer site');
971:
972: --exception 7.5 detected
973: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess customer site
974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
977:
978: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

Line 975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

971:
972: --exception 7.5 detected
973: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess customer site
974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
977:
978: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
979: l_publisher_site_id,

Line 976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

972: --exception 7.5 detected
973: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess customer site
974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
977:
978: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
979: l_publisher_site_id,
980: l_item_id,

Line 978: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

974: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
975: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
976: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
977:
978: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
979: l_publisher_site_id,
980: l_item_id,
981: l_exception_type,
982: l_exception_group);

Line 986: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,

982: l_exception_group);
983:
984: print_debug_info ( ' exception summary updated');
985:
986: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,
987: l_publisher_name,
988: l_publisher_site_id,
989: l_publisher_site_name,
990: l_item_id,

Line 1034: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at your site

1030: print_debug_info ( ' exception detail added');
1031:
1032: if l_generate_complement then
1033: --dbms_output.put_line('In complement exception 29');
1034: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at your site
1035: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1036: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1037: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1038:

Line 1035: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;

1031:
1032: if l_generate_complement then
1033: --dbms_output.put_line('In complement exception 29');
1034: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at your site
1035: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1036: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1037: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1038:
1039: l_obs_exception := 10; --outbound consignment item shortage at sup site

Line 1036: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

1032: if l_generate_complement then
1033: --dbms_output.put_line('In complement exception 29');
1034: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at your site
1035: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1036: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1037: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1038:
1039: l_obs_exception := 10; --outbound consignment item shortage at sup site
1040:

Line 1037: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

1033: --dbms_output.put_line('In complement exception 29');
1034: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30; --VMI item excess at your site
1035: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1036: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1037: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1038:
1039: l_obs_exception := 10; --outbound consignment item shortage at sup site
1040:
1041: print_debug_info ( ' vmi item excess at your site (complement exception)');

Line 1047: MSC_X_NETTING_PKG.update_exceptions_summary(l_customer_id,

1043: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----
1044:
1045: -- print_debug_info ( ' obsolete exception deleted');
1046:
1047: MSC_X_NETTING_PKG.update_exceptions_summary(l_customer_id,
1048: l_customer_site_id,
1049: l_item_id,
1050: l_exception_type,
1051: l_exception_group);

Line 1055: MSC_X_NETTING_PKG.add_exception_details(l_customer_id,

1051: l_exception_group);
1052:
1053: print_debug_info ( ' exception summary updated');
1054:
1055: MSC_X_NETTING_PKG.add_exception_details(l_customer_id,
1056: l_customer_name,
1057: l_customer_site_id,
1058: l_customer_site_name,
1059: l_item_id,

Line 1106: print_debug_info('Done: ' ||MSC_X_NETTING_PKG.get_message_type(9) || ',' || MSC_X_NETTING_PKG.get_message_type(29) || ':' || sysdate);

1102: end if;
1103: END IF; -- ( l_automatic_allowed_flag = 'N' or l_automatic_allowed_flag IS NULL)
1104: end loop;
1105: close exception_9_29;
1106: print_debug_info('Done: ' ||MSC_X_NETTING_PKG.get_message_type(9) || ',' || MSC_X_NETTING_PKG.get_message_type(29) || ':' || sysdate);
1107:
1108:
1109: --=================================================================================
1110:

Line 1196: , MSC_X_NETTING_PKG.G_PLAN_ID

1192: -- dbms_output.put_line('After Loop - exception_10_30');
1193:
1194:
1195: OPEN c_asl_attributes ( l_item_id
1196: , MSC_X_NETTING_PKG.G_PLAN_ID
1197: , l_sr_instance_id
1198: , l_aps_organization_id
1199: , l_aps_supplier_id
1200: , l_aps_supplier_site_id

Line 1232: , MSC_X_NETTING_PKG.G_PLAN_ID

1228: || l_vmi_refresh_flag
1229: );
1230:
1231: OPEN c_item_attributes_10_30 ( l_item_id
1232: , MSC_X_NETTING_PKG.G_PLAN_ID
1233: , l_publisher_site_id -- l_customer_site_id
1234: , l_supplier_id
1235: , l_supplier_site_id
1236: );

Line 1275: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_publisher_id,

1271: ----------------------------------------------------------
1272:
1273: print_debug_info ( ' delete obsolete exception');
1274:
1275: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_publisher_id,
1276: l_publisher_site_id, --owning org
1277: null, --l_customer_id,
1278: null, --l_customer_site_id,
1279: l_supplier_id,

Line 1281: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,

1277: null, --l_customer_id,
1278: null, --l_customer_site_id,
1279: l_supplier_id,
1280: l_supplier_site_id,
1281: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1282: MSC_X_NETTING_PKG.G_EXCEP10,
1283: MSC_X_NETTING_PKG.G_EXCEP30,
1284: l_item_id,
1285: null, --l_start_date,

Line 1282: MSC_X_NETTING_PKG.G_EXCEP10,

1278: null, --l_customer_site_id,
1279: l_supplier_id,
1280: l_supplier_site_id,
1281: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1282: MSC_X_NETTING_PKG.G_EXCEP10,
1283: MSC_X_NETTING_PKG.G_EXCEP30,
1284: l_item_id,
1285: null, --l_start_date,
1286: null,

Line 1283: MSC_X_NETTING_PKG.G_EXCEP30,

1279: l_supplier_id,
1280: l_supplier_site_id,
1281: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1282: MSC_X_NETTING_PKG.G_EXCEP10,
1283: MSC_X_NETTING_PKG.G_EXCEP30,
1284: l_item_id,
1285: null, --l_start_date,
1286: null,
1287: MSC_X_NETTING_PKG.VMI);

Line 1287: MSC_X_NETTING_PKG.VMI);

1283: MSC_X_NETTING_PKG.G_EXCEP30,
1284: l_item_id,
1285: null, --l_start_date,
1286: null,
1287: MSC_X_NETTING_PKG.VMI);
1288:
1289: print_debug_info ( ' Number of obsolete exceptions deleted = ' || SQL%ROWCOUNT);
1290:
1291: -- bug# 4501946 : added delete procedure for exception type 9, 29 ----

Line 1293: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_supplier_id,

1289: print_debug_info ( ' Number of obsolete exceptions deleted = ' || SQL%ROWCOUNT);
1290:
1291: -- bug# 4501946 : added delete procedure for exception type 9, 29 ----
1292:
1293: MSC_X_NETTING_PKG.delete_obsolete_exceptions(l_supplier_id,
1294: l_supplier_site_id,
1295: l_publisher_id, --customer_id
1296: l_publisher_site_id, --customer_site_id
1297: null, --supplier_id

Line 1299: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,

1295: l_publisher_id, --customer_id
1296: l_publisher_site_id, --customer_site_id
1297: null, --supplier_id
1298: null, --supplier_site_id
1299: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1300: MSC_X_NETTING_PKG.G_EXCEP9,
1301: MSC_X_NETTING_PKG.G_EXCEP29,
1302: l_item_id,
1303: null,

Line 1300: MSC_X_NETTING_PKG.G_EXCEP9,

1296: l_publisher_site_id, --customer_site_id
1297: null, --supplier_id
1298: null, --supplier_site_id
1299: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1300: MSC_X_NETTING_PKG.G_EXCEP9,
1301: MSC_X_NETTING_PKG.G_EXCEP29,
1302: l_item_id,
1303: null,
1304: null,

Line 1301: MSC_X_NETTING_PKG.G_EXCEP29,

1297: null, --supplier_id
1298: null, --supplier_site_id
1299: MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE,
1300: MSC_X_NETTING_PKG.G_EXCEP9,
1301: MSC_X_NETTING_PKG.G_EXCEP29,
1302: l_item_id,
1303: null,
1304: null,
1305: MSC_X_NETTING_PKG.VMI);

Line 1305: MSC_X_NETTING_PKG.VMI);

1301: MSC_X_NETTING_PKG.G_EXCEP29,
1302: l_item_id,
1303: null,
1304: null,
1305: MSC_X_NETTING_PKG.VMI);
1306: print_debug_info ( ' Number of obsolete exceptions deleted of type 9, 29 = ' || SQL%ROWCOUNT);
1307:
1308: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(l_supplier_id,
1309: l_supplier_site_id,

Line 1308: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(l_supplier_id,

1304: null,
1305: MSC_X_NETTING_PKG.VMI);
1306: print_debug_info ( ' Number of obsolete exceptions deleted of type 9, 29 = ' || SQL%ROWCOUNT);
1307:
1308: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(l_supplier_id,
1309: l_supplier_site_id,
1310: l_item_id,
1311: p_refresh_number,
1312: MSC_X_NETTING_PKG.VMI,

Line 1312: MSC_X_NETTING_PKG.VMI,

1308: l_generate_complement := MSC_X_NETTING_PKG.generate_complement_exception(l_supplier_id,
1309: l_supplier_site_id,
1310: l_item_id,
1311: p_refresh_number,
1312: MSC_X_NETTING_PKG.VMI,
1313: MSC_X_NETTING_PKG.SELLER);
1314:
1315: -- calculate the end date of the replenish time window
1316: l_time_fence_end_date := SYSDATE + NVL(p_replenish_time_fence * l_lead_time, 0);

Line 1313: MSC_X_NETTING_PKG.SELLER);

1309: l_supplier_site_id,
1310: l_item_id,
1311: p_refresh_number,
1312: MSC_X_NETTING_PKG.VMI,
1313: MSC_X_NETTING_PKG.SELLER);
1314:
1315: -- calculate the end date of the replenish time window
1316: l_time_fence_end_date := SYSDATE + NVL(p_replenish_time_fence * l_lead_time, 0);
1317:

Line 1322: , MSC_X_NETTING_PKG.G_PLAN_ID

1318: print_debug_info ( ' Time fence date = ' || l_time_fence_end_date);
1319:
1320: -- compute total supply
1321: OPEN c_asn_quantity( l_item_id
1322: , MSC_X_NETTING_PKG.G_PLAN_ID
1323: , l_publisher_id
1324: , l_publisher_site_id
1325: , l_supplier_id
1326: , l_supplier_site_id

Line 1334: , MSC_X_NETTING_PKG.G_PLAN_ID

1330: INTO l_asn_quantity;
1331: CLOSE c_asn_quantity;
1332:
1333: OPEN c_allocated_onhand_quantity ( l_item_id
1334: , MSC_X_NETTING_PKG.G_PLAN_ID
1335: , l_publisher_id
1336: , l_publisher_site_id
1337: , l_supplier_id
1338: , l_supplier_site_id

Line 1346: , MSC_X_NETTING_PKG.G_PLAN_ID

1342: INTO l_allocated_onhand_quantity;
1343: CLOSE c_allocated_onhand_quantity;
1344:
1345: OPEN c_shipment_receipt_quantity( l_item_id
1346: , MSC_X_NETTING_PKG.G_PLAN_ID
1347: , l_publisher_id
1348: , l_publisher_site_id
1349: , l_supplier_id
1350: , l_supplier_site_id

Line 1357: , MSC_X_NETTING_PKG.G_PLAN_ID

1353: FETCH c_shipment_receipt_quantity INTO l_shipment_receipt_quantity;
1354: CLOSE c_shipment_receipt_quantity;
1355:
1356: OPEN c_requisition_quantity( l_item_id
1357: , MSC_X_NETTING_PKG.G_PLAN_ID
1358: , l_publisher_id
1359: , l_publisher_site_id
1360: , l_supplier_id
1361: , l_supplier_site_id

Line 1368: , MSC_X_NETTING_PKG.G_PLAN_ID

1364: FETCH c_requisition_quantity INTO l_requisition_quantity;
1365: CLOSE c_requisition_quantity;
1366:
1367: OPEN c_po_quantity( l_item_id
1368: , MSC_X_NETTING_PKG.G_PLAN_ID
1369: , l_publisher_id
1370: , l_publisher_site_id
1371: , l_supplier_id
1372: , l_supplier_site_id

Line 1420: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --VMI item shortage at sup site

1416: || l_upper_limit_quantity
1417: );
1418:
1419: if l_total_supply < l_lower_limit_quantity then
1420: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --VMI item shortage at sup site
1421: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1422: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1424:

Line 1421: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;

1417: );
1418:
1419: if l_total_supply < l_lower_limit_quantity then
1420: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --VMI item shortage at sup site
1421: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1422: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1424:
1425: print_user_info ( ' VMI item shortage at customer site');

Line 1422: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

1418:
1419: if l_total_supply < l_lower_limit_quantity then
1420: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --VMI item shortage at sup site
1421: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1422: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1424:
1425: print_user_info ( ' VMI item shortage at customer site');
1426:

Line 1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

1419: if l_total_supply < l_lower_limit_quantity then
1420: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP10; --VMI item shortage at sup site
1421: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1422: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1424:
1425: print_user_info ( ' VMI item shortage at customer site');
1426:
1427: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

Line 1427: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

1423: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1424:
1425: print_user_info ( ' VMI item shortage at customer site');
1426:
1427: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
1428: l_publisher_site_id,
1429: l_item_id,
1430: l_exception_type,
1431: l_exception_group);

Line 1435: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,

1431: l_exception_group);
1432:
1433: print_debug_info ( ' exception summary updated');
1434:
1435: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,
1436: l_publisher_name,
1437: l_publisher_site_id,
1438: l_publisher_site_name,
1439: l_item_id,

Line 1483: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site

1479: print_debug_info ( ' exception detail added');
1480:
1481: if l_generate_complement then
1482: --dbms_output.put_line('In complement exception 10');
1483: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1487:

Line 1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;

1480:
1481: if l_generate_complement then
1482: --dbms_output.put_line('In complement exception 10');
1483: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1487:
1488: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at your site

Line 1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

1481: if l_generate_complement then
1482: --dbms_output.put_line('In complement exception 10');
1483: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1487:
1488: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at your site
1489:

Line 1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

1482: --dbms_output.put_line('In complement exception 10');
1483: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1487:
1488: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at your site
1489:
1490: print_user_info ( ' VMI item shortage at customer site');

Line 1488: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at your site

1484: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_SHORTAGE;
1485: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1486: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1487:
1488: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at your site
1489:
1490: print_user_info ( ' VMI item shortage at customer site');
1491:
1492: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----

Line 1494: MSC_X_NETTING_PKG.update_exceptions_summary(l_supplier_id,

1490: print_user_info ( ' VMI item shortage at customer site');
1491:
1492: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----
1493:
1494: MSC_X_NETTING_PKG.update_exceptions_summary(l_supplier_id,
1495: l_supplier_site_id,
1496: l_item_id,
1497: l_exception_type,
1498: l_exception_group);

Line 1499: MSC_X_NETTING_PKG.add_exception_details(l_supplier_id,

1495: l_supplier_site_id,
1496: l_item_id,
1497: l_exception_type,
1498: l_exception_group);
1499: MSC_X_NETTING_PKG.add_exception_details(l_supplier_id,
1500: l_supplier_name,
1501: l_supplier_site_id,
1502: l_supplier_site_name,
1503: l_item_id,

Line 1550: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30;

1546: elsif l_total_supply > l_upper_limit_quantity then
1547:
1548: print_user_info( ' VMI item excess at your site');
1549:
1550: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30;
1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1554:

Line 1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;

1547:
1548: print_user_info( ' VMI item excess at your site');
1549:
1550: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30;
1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1554:
1555: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

Line 1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

1548: print_user_info( ' VMI item excess at your site');
1549:
1550: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30;
1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1554:
1555: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
1556: l_publisher_site_id,

Line 1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

1549:
1550: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP30;
1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1554:
1555: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
1556: l_publisher_site_id,
1557: l_item_id,

Line 1555: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,

1551: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1552: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1553: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1554:
1555: MSC_X_NETTING_PKG.update_exceptions_summary(l_publisher_id,
1556: l_publisher_site_id,
1557: l_item_id,
1558: l_exception_type,
1559: l_exception_group);

Line 1563: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,

1559: l_exception_group);
1560:
1561: print_debug_info ( ' exception summary updated');
1562:
1563: MSC_X_NETTING_PKG.add_exception_details(l_publisher_id,
1564: l_publisher_name,
1565: l_publisher_site_id,
1566: l_publisher_site_name,
1567: l_item_id,

Line 1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site

1606: print_debug_info ( ' exception detail added');
1607:
1608: if l_generate_complement then
1609: --dbms_output.put_line('In complement exception 30');
1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site
1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site

Line 1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;

1607:
1608: if l_generate_complement then
1609: --dbms_output.put_line('In complement exception 30');
1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site
1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1615:

Line 1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);

1608: if l_generate_complement then
1609: --dbms_output.put_line('In complement exception 30');
1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site
1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1615:
1616: print_debug_info ( ' vmi item excess at customer site (complement exception)');

Line 1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);

1609: --dbms_output.put_line('In complement exception 30');
1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site
1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1615:
1616: print_debug_info ( ' vmi item excess at customer site (complement exception)');
1617:

Line 1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site

1610: l_exception_type := MSC_X_NETTING_PKG.G_EXCEP29; --VMI item excess at customer site
1611: l_exception_group := MSC_X_NETTING_PKG.G_MATERIAL_EXCESS;
1612: l_exception_type_name := MSC_X_NETTING_PKG.GET_MESSAGE_TYPE (l_exception_type);
1613: l_exception_group_name := MSC_X_NETTING_PKG.GET_MESSAGE_GROUP (l_exception_group);
1614: l_obs_exception := MSC_X_NETTING_PKG.G_EXCEP9; --VMI item shortage at customer site
1615:
1616: print_debug_info ( ' vmi item excess at customer site (complement exception)');
1617:
1618: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----

Line 1620: MSC_X_NETTING_PKG.update_exceptions_summary(l_supplier_id,

1616: print_debug_info ( ' vmi item excess at customer site (complement exception)');
1617:
1618: -- bug# 4501946 : removed delete procedure from here and called in the beginning ----
1619:
1620: MSC_X_NETTING_PKG.update_exceptions_summary(l_supplier_id,
1621: l_supplier_site_id,
1622: l_item_id,
1623: l_exception_type,
1624: l_exception_group);

Line 1628: MSC_X_NETTING_PKG.add_exception_details(l_supplier_id,

1624: l_exception_group);
1625:
1626: print_debug_info ( ' exception summary updated');
1627:
1628: MSC_X_NETTING_PKG.add_exception_details(l_supplier_id,
1629: l_supplier_name,
1630: l_supplier_site_id,
1631: l_supplier_site_name,
1632: l_item_id,

Line 1682: print_debug_info('Done: ' ||MSC_X_NETTING_PKG.get_message_type(10) || ',' || MSC_X_NETTING_PKG.get_message_type(30)

1678: close exception_10_30;
1679:
1680: commit;
1681:
1682: print_debug_info('Done: ' ||MSC_X_NETTING_PKG.get_message_type(10) || ',' || MSC_X_NETTING_PKG.get_message_type(30)
1683: || ':' || sysdate);
1684:
1685: -------------------------------------------------------------
1686: --launch workflow here

Line 1720: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

1716: --Reset the records for which the workflows have been
1717: --kicked off, to prevent the create duplicate wf items
1718: update msc_x_exception_details
1719: set last_update_login = null
1720: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1721: and exception_type in (9, 10, 29, 30)
1722: and nvl(last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;
1723:
1724: --Update the last_update_login back to null to ensure accurate archival

Line 1722: and nvl(last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;

1718: update msc_x_exception_details
1719: set last_update_login = null
1720: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1721: and exception_type in (9, 10, 29, 30)
1722: and nvl(last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;
1723:
1724: --Update the last_update_login back to null to ensure accurate archival
1725: --when exceptions are generated in the next round
1726:

Line 1730: where ex.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

1726:
1727: update msc_item_exceptions ex
1728: set ex.last_update_login = null,
1729: ex.last_update_date = sysdate
1730: where ex.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1731: and ex.version = 0
1732: and exception_type in (9, 10, 29, 30)
1733: and nvl(ex.last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;
1734:

Line 1733: and nvl(ex.last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;

1729: ex.last_update_date = sysdate
1730: where ex.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1731: and ex.version = 0
1732: and exception_type in (9, 10, 29, 30)
1733: and nvl(ex.last_update_login,-1) = MSC_X_NETTING_PKG.G_MAGIC_NUMBER;
1734:
1735: --update the if the count is 0 to older version
1736: update msc_item_exceptions ex
1737: set ex.version = version + 1,

Line 1739: where ex.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

1735: --update the if the count is 0 to older version
1736: update msc_item_exceptions ex
1737: set ex.version = version + 1,
1738: ex.last_update_date = sysdate
1739: where ex.plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1740: and ex.version = 0
1741: and exception_type in (9, 10, 29, 30)
1742: and ex.exception_count = 0;
1743:

Line 1755: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID

1751: -- the table is arhived based on the user defined profile option and only keep
1752: -- certain number of version. Default verion = 20
1753:
1754: delete msc_item_exceptions ex
1755: where plan_id = MSC_X_NETTING_PKG.G_PLAN_ID
1756: and exception_type in (9, 10, 29, 30)
1757: and version > 20;
1758:
1759: /***