756:
757: --------------------------------------------------------------------------
758: -- get the shipping control
759: ---------------------------------------------------------------------------
760: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_customer_name(j),
761: b_customer_site_name(j),
762: b_publisher_name(j),
763: b_publisher_site_name(j));
764:
761: b_customer_site_name(j),
762: b_publisher_name(j),
763: b_publisher_site_name(j));
764:
765: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
766: nvl(l_shipping_control,1));
767:
768: l_exception_type := msc_x_netting_pkg.G_EXCEP1; -- replenishment to cust after need date
769: l_exception_group := msc_x_netting_pkg.G_LATE_ORDER;
1173:
1174: --------------------------------------------------------------------------
1175: -- get the shipping control
1176: ---------------------------------------------------------------------------
1177: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_publisher_name(j),
1178: b_publisher_site_name(j),
1179: b_supplier_name(j),
1180: b_supplier_site_name(j));
1181:
1178: b_publisher_site_name(j),
1179: b_supplier_name(j),
1180: b_supplier_site_name(j));
1181:
1182: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
1183: nvl(l_shipping_control,1));
1184:
1185: --dbms_output.put_line('Exception2');
1186: l_exception_type := msc_x_netting_pkg.G_EXCEP2; -- replenishment from sup after need date
1462:
1463: --------------------------------------------------------------------------
1464: -- get the shipping control
1465: ---------------------------------------------------------------------------
1466: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_publisher_name(j),
1467: b_publisher_site_name(j),
1468: b_supplier_name(j),
1469: b_supplier_site_name(j));
1470:
1467: b_publisher_site_name(j),
1468: b_supplier_name(j),
1469: b_supplier_site_name(j));
1470:
1471: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
1472: nvl(l_shipping_control,1));
1473:
1474:
1475: IF (trunc(sysdate) > trunc(b_po_key_date(j)) + b_threshold1(j)) THEN
2192:
2193: --------------------------------------------------------------------------
2194: -- get the shipping control
2195: ---------------------------------------------------------------------------
2196: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_customer_name(j),
2197: b_customer_site_name(j),
2198: b_publisher_name(j),
2199: b_publisher_site_name(j));
2200:
2197: b_customer_site_name(j),
2198: b_publisher_name(j),
2199: b_publisher_site_name(j));
2200:
2201: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
2202: nvl(l_shipping_control,1));
2203:
2204:
2205: l_exception_type := msc_x_netting_pkg.G_EXCEP23; --Replenishment to cust before need date
2603:
2604: --------------------------------------------------------------------------
2605: -- get the shipping control
2606: ---------------------------------------------------------------------------
2607: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_publisher_name(j),
2608: b_publisher_site_name(j),
2609: b_supplier_name(j),
2610: b_supplier_site_name(j));
2611:
2608: b_publisher_site_name(j),
2609: b_supplier_name(j),
2610: b_supplier_site_name(j));
2611:
2612: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
2613: nvl(l_shipping_control,1));
2614:
2615: l_exception_type := msc_x_netting_pkg.G_EXCEP24; --Replenishment from supplier before need date
2616: l_exception_group := msc_x_netting_pkg.G_EARLY_ORDER;
3124:
3125: --------------------------------------------------------------------------
3126: -- get the shipping control
3127: ---------------------------------------------------------------------------
3128: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_customer_name(j),
3129: b_customer_site_name(j),
3130: b_publisher_name(j),
3131: b_publisher_site_name(j));
3132:
3129: b_customer_site_name(j),
3130: b_publisher_name(j),
3131: b_publisher_site_name(j));
3132:
3133: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3134: nvl(l_shipping_control,1));
3135:
3136:
3137: open time_bkts;
3896:
3897: --------------------------------------------------------------------------
3898: -- get the shipping control
3899: ---------------------------------------------------------------------------
3900: l_shipping_control := MSC_X_UTIL.GET_SHIPPING_CONTROL(b_publisher_name(j),
3901: b_publisher_site_name(j),
3902: b_supplier_name(j),
3903: b_supplier_site_name(j));
3904:
3901: b_publisher_site_name(j),
3902: b_supplier_name(j),
3903: b_supplier_site_name(j));
3904:
3905: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3906: nvl(l_shipping_control,1));
3907:
3908:
3909: open time_bkts;