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.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790

1: PACKAGE BODY rcv_transactions_interface_sv1 AS
2: /* $Header: RCVTIS2B.pls 120.4.12020000.4 2012/11/22 10:20:22 liayang ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
6: e_validation_error EXCEPTION;
7:
8: /*===========================================================================
9:

Line 183: IF (g_asn_debug = 'Y') THEN

179: END IF;
180:
181: x_new_conversion := 0;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);

Line 184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));

180:
181: x_new_conversion := 0;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);
188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);

Line 185: asn_debug.put_line(x_uom_record.unit_of_measure);

181: x_new_conversion := 0;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);
188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);
189: END IF;

Line 186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));

182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);
188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);
189: END IF;
190:

Line 187: asn_debug.put_line(x_primary_unit_of_measure);

183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);
188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);
189: END IF;
190:
191: po_uom_s.uom_convert(x_uom_record.quantity_shipped,

Line 188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);

184: asn_debug.put_line(TO_CHAR(x_uom_record.quantity_shipped));
185: asn_debug.put_line(x_uom_record.unit_of_measure);
186: asn_debug.put_line(TO_CHAR(x_uom_record.item_id));
187: asn_debug.put_line(x_primary_unit_of_measure);
188: asn_debug.put_line(x_uom_record.primary_unit_of_measure);
189: END IF;
190:
191: po_uom_s.uom_convert(x_uom_record.quantity_shipped,
192: x_uom_record.unit_of_measure,

Line 377: IF (g_asn_debug = 'Y') THEN

373: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
374: RAISE e_validation_error;
375: END IF;
376:
377: IF (g_asn_debug = 'Y') THEN
378: asn_debug.put_line('Validating Item: ' || x_auto_transact_code);
379: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_lot);
380: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_serial);
381: END IF;

Line 378: asn_debug.put_line('Validating Item: ' || x_auto_transact_code);

374: RAISE e_validation_error;
375: END IF;
376:
377: IF (g_asn_debug = 'Y') THEN
378: asn_debug.put_line('Validating Item: ' || x_auto_transact_code);
379: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_lot);
380: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_serial);
381: END IF;
382: EXCEPTION

Line 379: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_lot);

375: END IF;
376:
377: IF (g_asn_debug = 'Y') THEN
378: asn_debug.put_line('Validating Item: ' || x_auto_transact_code);
379: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_lot);
380: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_serial);
381: END IF;
382: EXCEPTION
383: WHEN e_validation_error THEN

Line 380: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_serial);

376:
377: IF (g_asn_debug = 'Y') THEN
378: asn_debug.put_line('Validating Item: ' || x_auto_transact_code);
379: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_lot);
380: asn_debug.put_line('Validating Item: ' || x_item_id_record.use_mtl_serial);
381: END IF;
382: EXCEPTION
383: WHEN e_validation_error THEN
384: x_item_id_record.error_record.error_status := x_error_status;

Line 613: IF (g_asn_debug = 'Y') THEN

609: IF (x_inventory_item <> 0) THEN
610: RETURN;
611: END IF;
612:
613: IF (g_asn_debug = 'Y') THEN
614: asn_debug.put_line('Item is not under revision control');
615: END IF;
616:
617: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');

Line 614: asn_debug.put_line('Item is not under revision control');

610: RETURN;
611: END IF;
612:
613: IF (g_asn_debug = 'Y') THEN
614: asn_debug.put_line('Item is not under revision control');
615: END IF;
616:
617: rcv_error_pkg.set_error_message('RCV_ITEM_REV_NOT_ALLOWED');
618: RAISE e_validation_error;

Line 623: IF (g_asn_debug = 'Y') THEN

619: END IF;
620:
621: -- Check whether the revision number exists
622:
623: IF (g_asn_debug = 'Y') THEN
624: asn_debug.put_line('Revision number : ' || x_item_revision_record.item_revision);
625: END IF;
626:
627: SELECT NVL(MAX(inventory_item_id), 0)

Line 624: asn_debug.put_line('Revision number : ' || x_item_revision_record.item_revision);

620:
621: -- Check whether the revision number exists
622:
623: IF (g_asn_debug = 'Y') THEN
624: asn_debug.put_line('Revision number : ' || x_item_revision_record.item_revision);
625: END IF;
626:
627: SELECT NVL(MAX(inventory_item_id), 0)
628: INTO x_inventory_item

Line 711: IF (g_asn_debug = 'Y') THEN

707: RAISE e_validation_error;
708: END IF;
709: END IF;
710:
711: IF (g_asn_debug = 'Y') THEN
712: asn_debug.put_line('Validating vendor id in PO ' || TO_CHAR(x_ref_integrity_rec.vendor_id));
713: asn_debug.put_line('PO Header Id ' || TO_CHAR(x_ref_integrity_rec.po_header_id));
714: END IF;
715:

Line 712: asn_debug.put_line('Validating vendor id in PO ' || TO_CHAR(x_ref_integrity_rec.vendor_id));

708: END IF;
709: END IF;
710:
711: IF (g_asn_debug = 'Y') THEN
712: asn_debug.put_line('Validating vendor id in PO ' || TO_CHAR(x_ref_integrity_rec.vendor_id));
713: asn_debug.put_line('PO Header Id ' || TO_CHAR(x_ref_integrity_rec.po_header_id));
714: END IF;
715:
716: IF x_ref_integrity_rec.vendor_id IS NOT NULL THEN

Line 713: asn_debug.put_line('PO Header Id ' || TO_CHAR(x_ref_integrity_rec.po_header_id));

709: END IF;
710:
711: IF (g_asn_debug = 'Y') THEN
712: asn_debug.put_line('Validating vendor id in PO ' || TO_CHAR(x_ref_integrity_rec.vendor_id));
713: asn_debug.put_line('PO Header Id ' || TO_CHAR(x_ref_integrity_rec.po_header_id));
714: END IF;
715:
716: IF x_ref_integrity_rec.vendor_id IS NOT NULL THEN
717: SELECT NVL(MAX(vendor_id), 0)

Line 893: IF (g_asn_debug = 'Y') THEN

889: x_error_status := rcv_error_pkg.g_ret_sts_error;
890:
891: -- first check if the po from the shipment is a supply agreement blanket purchase
892:
893: IF (g_asn_debug = 'Y') THEN
894: asn_debug.put_line('In validate ASL');
895: END IF;
896:
897: SELECT NVL(MAX(supply_agreement_flag), 'N')

Line 894: asn_debug.put_line('In validate ASL');

890:
891: -- first check if the po from the shipment is a supply agreement blanket purchase
892:
893: IF (g_asn_debug = 'Y') THEN
894: asn_debug.put_line('In validate ASL');
895: END IF;
896:
897: SELECT NVL(MAX(supply_agreement_flag), 'N')
898: INTO x_supply_agreement_flag

Line 904: IF (g_asn_debug = 'Y') THEN

900: WHERE po_header_id = x_asl_record.po_header_id
901: AND type_lookup_code = 'BLANKET'
902: AND supply_agreement_flag = 'Y';
903:
904: IF (g_asn_debug = 'Y') THEN
905: asn_debug.put_line('Supply agreement Flag ' || x_supply_agreement_flag);
906: END IF;
907:
908: IF (x_supply_agreement_flag <> 'N') THEN

Line 905: asn_debug.put_line('Supply agreement Flag ' || x_supply_agreement_flag);

901: AND type_lookup_code = 'BLANKET'
902: AND supply_agreement_flag = 'Y';
903:
904: IF (g_asn_debug = 'Y') THEN
905: asn_debug.put_line('Supply agreement Flag ' || x_supply_agreement_flag);
906: END IF;
907:
908: IF (x_supply_agreement_flag <> 'N') THEN
909: SELECT NVL(MAX('found'), 'notfound')

Line 919: IF (g_asn_debug = 'Y') THEN

915: AND ( using_organization_id = NVL(x_asl_record.to_organization_id, using_organization_id)
916: OR using_organization_id = -1); -- per discussion with cindy
917: END IF;
918:
919: IF (g_asn_debug = 'Y') THEN
920: asn_debug.put_line('PO Approved supplier list ' || x_success);
921: END IF;
922:
923: IF (x_success = 'notfound') THEN

Line 920: asn_debug.put_line('PO Approved supplier list ' || x_success);

916: OR using_organization_id = -1); -- per discussion with cindy
917: END IF;
918:
919: IF (g_asn_debug = 'Y') THEN
920: asn_debug.put_line('PO Approved supplier list ' || x_success);
921: END IF;
922:
923: IF (x_success = 'notfound') THEN
924: rcv_error_pkg.set_error_message('RCV_ASL_NOT_FOUND');

Line 962: IF (g_asn_debug = 'Y') THEN

958: x_error_status := rcv_error_pkg.g_ret_sts_error;
959:
960: -- first check if the po from the shipment is a supply agreement blanket purchase
961:
962: IF (g_asn_debug = 'Y') THEN
963: asn_debug.put_line('Validating cum quantity ');
964: END IF;
965:
966: SELECT NVL(MAX(supply_agreement_flag), 'N')

Line 963: asn_debug.put_line('Validating cum quantity ');

959:
960: -- first check if the po from the shipment is a supply agreement blanket purchase
961:
962: IF (g_asn_debug = 'Y') THEN
963: asn_debug.put_line('Validating cum quantity ');
964: END IF;
965:
966: SELECT NVL(MAX(supply_agreement_flag), 'N')
967: INTO x_supply_agreement_flag

Line 973: IF (g_asn_debug = 'Y') THEN

969: WHERE po_header_id = x_cum_quantity_record.po_header_id
970: AND type_lookup_code = 'BLANKET'
971: AND supply_agreement_flag = 'Y';
972:
973: IF (g_asn_debug = 'Y') THEN
974: asn_debug.put_line('Check for supply agreement flag ' || x_supply_agreement_flag);
975: END IF;
976:
977: IF (x_supply_agreement_flag <> 'N') THEN

Line 974: asn_debug.put_line('Check for supply agreement flag ' || x_supply_agreement_flag);

970: AND type_lookup_code = 'BLANKET'
971: AND supply_agreement_flag = 'Y';
972:
973: IF (g_asn_debug = 'Y') THEN
974: asn_debug.put_line('Check for supply agreement flag ' || x_supply_agreement_flag);
975: END IF;
976:
977: IF (x_supply_agreement_flag <> 'N') THEN
978: SELECT MAX(enable_cum_flag)

Line 983: IF (g_asn_debug = 'Y') THEN

979: INTO x_success
980: FROM chv_org_options
981: WHERE organization_id = NVL(x_cum_quantity_record.to_organization_id, organization_id);
982:
983: IF (g_asn_debug = 'Y') THEN
984: asn_debug.put_line('Enable cum flag ' || x_success);
985: END IF;
986:
987: IF (x_success = 'Y') THEN

Line 984: asn_debug.put_line('Enable cum flag ' || x_success);

980: FROM chv_org_options
981: WHERE organization_id = NVL(x_cum_quantity_record.to_organization_id, organization_id);
982:
983: IF (g_asn_debug = 'Y') THEN
984: asn_debug.put_line('Enable cum flag ' || x_success);
985: END IF;
986:
987: IF (x_success = 'Y') THEN
988: IF (x_cum_quantity_record.vendor_cum_shipped_qty < 0) THEN

Line 1003: IF (g_asn_debug = 'Y') THEN

999: INTO x_rtv_update_cum_flag
1000: FROM chv_org_options
1001: WHERE organization_id = x_cum_quantity_record.to_organization_id;
1002:
1003: IF (g_asn_debug = 'Y') THEN
1004: asn_debug.put_line('RTV update cum flag ' || x_rtv_update_cum_flag);
1005: END IF;
1006:
1007: IF (x_rtv_update_cum_flag = 'Y') THEN

Line 1004: asn_debug.put_line('RTV update cum flag ' || x_rtv_update_cum_flag);

1000: FROM chv_org_options
1001: WHERE organization_id = x_cum_quantity_record.to_organization_id;
1002:
1003: IF (g_asn_debug = 'Y') THEN
1004: asn_debug.put_line('RTV update cum flag ' || x_rtv_update_cum_flag);
1005: END IF;
1006:
1007: IF (x_rtv_update_cum_flag = 'Y') THEN
1008: BEGIN

Line 1009: IF (g_asn_debug = 'Y') THEN

1005: END IF;
1006:
1007: IF (x_rtv_update_cum_flag = 'Y') THEN
1008: BEGIN
1009: IF (g_asn_debug = 'Y') THEN
1010: asn_debug.put_line('Org Id ' || TO_CHAR(x_cum_quantity_record.to_organization_id));
1011: asn_debug.put_line('Transaction date ' || TO_CHAR(x_cum_quantity_record.transaction_date, 'DDMONYY'));
1012: END IF;
1013:

Line 1010: asn_debug.put_line('Org Id ' || TO_CHAR(x_cum_quantity_record.to_organization_id));

1006:
1007: IF (x_rtv_update_cum_flag = 'Y') THEN
1008: BEGIN
1009: IF (g_asn_debug = 'Y') THEN
1010: asn_debug.put_line('Org Id ' || TO_CHAR(x_cum_quantity_record.to_organization_id));
1011: asn_debug.put_line('Transaction date ' || TO_CHAR(x_cum_quantity_record.transaction_date, 'DDMONYY'));
1012: END IF;
1013:
1014: SELECT cum_period_start_date,

Line 1011: asn_debug.put_line('Transaction date ' || TO_CHAR(x_cum_quantity_record.transaction_date, 'DDMONYY'));

1007: IF (x_rtv_update_cum_flag = 'Y') THEN
1008: BEGIN
1009: IF (g_asn_debug = 'Y') THEN
1010: asn_debug.put_line('Org Id ' || TO_CHAR(x_cum_quantity_record.to_organization_id));
1011: asn_debug.put_line('Transaction date ' || TO_CHAR(x_cum_quantity_record.transaction_date, 'DDMONYY'));
1012: END IF;
1013:
1014: SELECT cum_period_start_date,
1015: cum_period_end_date

Line 1022: IF (g_asn_debug = 'Y') THEN

1018: FROM chv_cum_periods
1019: WHERE organization_id = x_cum_quantity_record.to_organization_id
1020: AND x_cum_quantity_record.transaction_date BETWEEN cum_period_start_date AND cum_period_end_date;
1021:
1022: IF (g_asn_debug = 'Y') THEN
1023: asn_debug.put_line('Cum period start date ' || TO_CHAR(x_cum_period_start_date, 'DDMONYY'));
1024: asn_debug.put_line('Cum Period End date ' || TO_CHAR(x_cum_period_end_date, 'DDMONYY'));
1025: END IF;
1026: EXCEPTION

Line 1023: asn_debug.put_line('Cum period start date ' || TO_CHAR(x_cum_period_start_date, 'DDMONYY'));

1019: WHERE organization_id = x_cum_quantity_record.to_organization_id
1020: AND x_cum_quantity_record.transaction_date BETWEEN cum_period_start_date AND cum_period_end_date;
1021:
1022: IF (g_asn_debug = 'Y') THEN
1023: asn_debug.put_line('Cum period start date ' || TO_CHAR(x_cum_period_start_date, 'DDMONYY'));
1024: asn_debug.put_line('Cum Period End date ' || TO_CHAR(x_cum_period_end_date, 'DDMONYY'));
1025: END IF;
1026: EXCEPTION
1027: WHEN NO_DATA_FOUND THEN

Line 1024: asn_debug.put_line('Cum Period End date ' || TO_CHAR(x_cum_period_end_date, 'DDMONYY'));

1020: AND x_cum_quantity_record.transaction_date BETWEEN cum_period_start_date AND cum_period_end_date;
1021:
1022: IF (g_asn_debug = 'Y') THEN
1023: asn_debug.put_line('Cum period start date ' || TO_CHAR(x_cum_period_start_date, 'DDMONYY'));
1024: asn_debug.put_line('Cum Period End date ' || TO_CHAR(x_cum_period_end_date, 'DDMONYY'));
1025: END IF;
1026: EXCEPTION
1027: WHEN NO_DATA_FOUND THEN
1028: x_continue := FALSE;

Line 1038: IF (g_asn_debug = 'Y') THEN

1034: -- what if item_id is null ????
1035:
1036: IF (x_cum_quantity_record.item_id IS NOT NULL) THEN
1037: IF (x_continue) THEN
1038: IF (g_asn_debug = 'Y') THEN
1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');
1040: END IF;
1041:
1042: chv_cum_periods_s1.get_cum_qty_received(x_cum_quantity_record.vendor_id,

Line 1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');

1035:
1036: IF (x_cum_quantity_record.item_id IS NOT NULL) THEN
1037: IF (x_continue) THEN
1038: IF (g_asn_debug = 'Y') THEN
1039: asn_debug.put_line('Call to chv_cum_periods_s1.get_cum_qty_received');
1040: END IF;
1041:
1042: chv_cum_periods_s1.get_cum_qty_received(x_cum_quantity_record.vendor_id,
1043: x_cum_quantity_record.vendor_site_id,

Line 1054: IF (g_asn_debug = 'Y') THEN

1050: x_qty_received_primary,
1051: x_qty_received_purchasing
1052: );
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: asn_debug.put_line('Primary Quantity Received ' || TO_CHAR(NVL(x_qty_received_primary, 0)));
1056: asn_debug.put_line('Purchasing Quantity Received ' || TO_CHAR(NVL(x_qty_received_purchasing, 0)));
1057: END IF;
1058:

Line 1055: asn_debug.put_line('Primary Quantity Received ' || TO_CHAR(NVL(x_qty_received_primary, 0)));

1051: x_qty_received_purchasing
1052: );
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: asn_debug.put_line('Primary Quantity Received ' || TO_CHAR(NVL(x_qty_received_primary, 0)));
1056: asn_debug.put_line('Purchasing Quantity Received ' || TO_CHAR(NVL(x_qty_received_purchasing, 0)));
1057: END IF;
1058:
1059: po_uom_s.uom_convert(x_cum_quantity_record.quantity_shipped,

Line 1056: asn_debug.put_line('Purchasing Quantity Received ' || TO_CHAR(NVL(x_qty_received_purchasing, 0)));

1052: );
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: asn_debug.put_line('Primary Quantity Received ' || TO_CHAR(NVL(x_qty_received_primary, 0)));
1056: asn_debug.put_line('Purchasing Quantity Received ' || TO_CHAR(NVL(x_qty_received_purchasing, 0)));
1057: END IF;
1058:
1059: po_uom_s.uom_convert(x_cum_quantity_record.quantity_shipped,
1060: x_cum_quantity_record.unit_of_measure,

Line 1069: IF (g_asn_debug = 'Y') THEN

1065: x_total_cum_shipped := x_qty_received_primary + x_new_conversion;
1066:
1067: -- assumption: the vendor_cum_shipped_qty is in the primary uom
1068:
1069: IF (g_asn_debug = 'Y') THEN
1070: asn_debug.put_line('Check for quantity discrepancy ');
1071: END IF;
1072:
1073: IF (g_asn_debug = 'Y') THEN

Line 1070: asn_debug.put_line('Check for quantity discrepancy ');

1066:
1067: -- assumption: the vendor_cum_shipped_qty is in the primary uom
1068:
1069: IF (g_asn_debug = 'Y') THEN
1070: asn_debug.put_line('Check for quantity discrepancy ');
1071: END IF;
1072:
1073: IF (g_asn_debug = 'Y') THEN
1074: asn_debug.put_line('Vendor Cum quantity ' || TO_CHAR(NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)));

Line 1073: IF (g_asn_debug = 'Y') THEN

1069: IF (g_asn_debug = 'Y') THEN
1070: asn_debug.put_line('Check for quantity discrepancy ');
1071: END IF;
1072:
1073: IF (g_asn_debug = 'Y') THEN
1074: asn_debug.put_line('Vendor Cum quantity ' || TO_CHAR(NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)));
1075: asn_debug.put_line('Derived Cum Quantity ' || TO_CHAR(NVL(x_total_cum_shipped, -999)));
1076: END IF;
1077:

Line 1074: asn_debug.put_line('Vendor Cum quantity ' || TO_CHAR(NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)));

1070: asn_debug.put_line('Check for quantity discrepancy ');
1071: END IF;
1072:
1073: IF (g_asn_debug = 'Y') THEN
1074: asn_debug.put_line('Vendor Cum quantity ' || TO_CHAR(NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)));
1075: asn_debug.put_line('Derived Cum Quantity ' || TO_CHAR(NVL(x_total_cum_shipped, -999)));
1076: END IF;
1077:
1078: IF (x_total_cum_shipped <> NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)) THEN

Line 1075: asn_debug.put_line('Derived Cum Quantity ' || TO_CHAR(NVL(x_total_cum_shipped, -999)));

1071: END IF;
1072:
1073: IF (g_asn_debug = 'Y') THEN
1074: asn_debug.put_line('Vendor Cum quantity ' || TO_CHAR(NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)));
1075: asn_debug.put_line('Derived Cum Quantity ' || TO_CHAR(NVL(x_total_cum_shipped, -999)));
1076: END IF;
1077:
1078: IF (x_total_cum_shipped <> NVL(x_cum_quantity_record.vendor_cum_shipped_qty, 0)) THEN
1079: rcv_error_pkg.set_error_message('RCV_RCV_NO_MATCH_ASN_CUM');

Line 1381: IF (g_asn_debug = 'Y') THEN

1377: x_locator_record.locator_id := NULL;
1378: RETURN;
1379: END IF;
1380:
1381: IF (g_asn_debug = 'Y') THEN
1382: asn_debug.put_line('Before Get Locator');
1383: END IF;
1384:
1385: /*

Line 1382: asn_debug.put_line('Before Get Locator');

1378: RETURN;
1379: END IF;
1380:
1381: IF (g_asn_debug = 'Y') THEN
1382: asn_debug.put_line('Before Get Locator');
1383: END IF;
1384:
1385: /*
1386: ** Get the locator controls

Line 1402: IF (g_asn_debug = 'Y') THEN

1398: */
1399: IF (x_locator_record.subinventory_locator_control = 1) THEN
1400: /* begin changes for bug 7488437*/
1401: IF (x_locator_record.locator_id IS NOT NULL) THEN
1402: IF (g_asn_debug = 'Y') THEN
1403: asn_debug.put_line('Error: Subinventory is not locator controlled, but locator info is given');
1404: END IF;
1405: rcv_error_pkg.set_error_message('RCV_NO_LOCATOR_CONTROL');
1406: RAISE e_validation_error;

Line 1403: asn_debug.put_line('Error: Subinventory is not locator controlled, but locator info is given');

1399: IF (x_locator_record.subinventory_locator_control = 1) THEN
1400: /* begin changes for bug 7488437*/
1401: IF (x_locator_record.locator_id IS NOT NULL) THEN
1402: IF (g_asn_debug = 'Y') THEN
1403: asn_debug.put_line('Error: Subinventory is not locator controlled, but locator info is given');
1404: END IF;
1405: rcv_error_pkg.set_error_message('RCV_NO_LOCATOR_CONTROL');
1406: RAISE e_validation_error;
1407: END IF;

Line 1412: IF (g_asn_debug = 'Y') THEN

1408: return;
1409: /* end changes for bug 7488437*/
1410: END IF;
1411:
1412: IF (g_asn_debug = 'Y') THEN
1413: asn_debug.put_line('Loc Cont = ' || TO_CHAR(x_locator_record.subinventory_locator_control));
1414: asn_debug.put_line('Rest Cont = ' || x_locator_record.restrict_locator_control);
1415: END IF;
1416:

Line 1413: asn_debug.put_line('Loc Cont = ' || TO_CHAR(x_locator_record.subinventory_locator_control));

1409: /* end changes for bug 7488437*/
1410: END IF;
1411:
1412: IF (g_asn_debug = 'Y') THEN
1413: asn_debug.put_line('Loc Cont = ' || TO_CHAR(x_locator_record.subinventory_locator_control));
1414: asn_debug.put_line('Rest Cont = ' || x_locator_record.restrict_locator_control);
1415: END IF;
1416:
1417: /*

Line 1414: asn_debug.put_line('Rest Cont = ' || x_locator_record.restrict_locator_control);

1410: END IF;
1411:
1412: IF (g_asn_debug = 'Y') THEN
1413: asn_debug.put_line('Loc Cont = ' || TO_CHAR(x_locator_record.subinventory_locator_control));
1414: asn_debug.put_line('Rest Cont = ' || x_locator_record.restrict_locator_control);
1415: END IF;
1416:
1417: /*
1418: ** bug 724495, the else part now runs only if the

Line 1438: IF (g_asn_debug = 'Y') THEN

1434: IF (x_locator_record.subinventory_locator_control IN(2, 3)) THEN
1435: IF (NVL(x_locator_record.restrict_locator_control, 2) = 2) THEN
1436: /* 3017707 - We need to validate the locator in the receiving organization. Added the filter on
1437: organization id */
1438: IF (g_asn_debug = 'Y') THEN
1439: asn_debug.put_line('Sub is not under restricted locator control');
1440: END IF;
1441:
1442: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')

Line 1439: asn_debug.put_line('Sub is not under restricted locator control');

1435: IF (NVL(x_locator_record.restrict_locator_control, 2) = 2) THEN
1436: /* 3017707 - We need to validate the locator in the receiving organization. Added the filter on
1437: organization id */
1438: IF (g_asn_debug = 'Y') THEN
1439: asn_debug.put_line('Sub is not under restricted locator control');
1440: END IF;
1441:
1442: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1443: INTO x_locator

Line 1455: IF (g_asn_debug = 'Y') THEN

1451: ** ELSE If locator control is 2 or 3 and the item is under restricted locator
1452: ** control then do restricted check
1453: */
1454: ELSE
1455: IF (g_asn_debug = 'Y') THEN
1456: asn_debug.put_line('Sub is under restricted locator control');
1457: END IF;
1458:
1459: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')

Line 1456: asn_debug.put_line('Sub is under restricted locator control');

1452: ** control then do restricted check
1453: */
1454: ELSE
1455: IF (g_asn_debug = 'Y') THEN
1456: asn_debug.put_line('Sub is under restricted locator control');
1457: END IF;
1458:
1459: SELECT NVL(MAX(ml.concatenated_segments), 'notfound')
1460: INTO x_locator

Line 1475: IF (g_asn_debug = 'Y') THEN

1471: END IF;
1472: END IF;
1473:
1474: IF (x_locator = 'notfound') THEN
1475: IF (g_asn_debug = 'Y') THEN
1476: asn_debug.put_line('In locator Errors');
1477: END IF;
1478:
1479: rcv_error_pkg.set_error_message('RCV_ALL_REQUIRED_LOCATOR');

Line 1476: asn_debug.put_line('In locator Errors');

1472: END IF;
1473:
1474: IF (x_locator = 'notfound') THEN
1475: IF (g_asn_debug = 'Y') THEN
1476: asn_debug.put_line('In locator Errors');
1477: END IF;
1478:
1479: rcv_error_pkg.set_error_message('RCV_ALL_REQUIRED_LOCATOR');
1480: RAISE e_validation_error;

Line 1536: IF (G_ASN_DEBUG = 'Y') THEN

1532: X_LOCATOR_RECORD.LOCATOR_ID := NULL;
1533: RETURN;
1534: END IF;
1535:
1536: IF (G_ASN_DEBUG = 'Y') THEN
1537: ASN_DEBUG.PUT_LINE('BEFORE GET PROJECT TASK LOCATOR');
1538: END IF;
1539:
1540:

Line 1537: ASN_DEBUG.PUT_LINE('BEFORE GET PROJECT TASK LOCATOR');

1533: RETURN;
1534: END IF;
1535:
1536: IF (G_ASN_DEBUG = 'Y') THEN
1537: ASN_DEBUG.PUT_LINE('BEFORE GET PROJECT TASK LOCATOR');
1538: END IF;
1539:
1540:
1541: SELECT NVL(PROJECT_REFERENCE_ENABLED, 0)

Line 1558: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.PO_DISTRIBUTION_ID' ||

1554: X_LOCATOR_RECORD.RESTRICT_LOCATOR_CONTROL);
1555:
1556: IF NVL(X_LOCATOR_RECORD.LOCATOR_ID, '0') NOT IN (-1, 0) THEN
1557:
1558: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.PO_DISTRIBUTION_ID' ||
1559: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID);
1560: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE' ||
1561: X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE);
1562:

Line 1560: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE' ||

1556: IF NVL(X_LOCATOR_RECORD.LOCATOR_ID, '0') NOT IN (-1, 0) THEN
1557:
1558: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.PO_DISTRIBUTION_ID' ||
1559: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID);
1560: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE' ||
1561: X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE);
1562:
1563: IF (X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODE = 'PO' AND
1564: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID IS NOT NULL) THEN

Line 1571: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.PO_DISTRIBUTION_ID' ||

1567: INTO X_PROJECT_ID, X_TASK_ID, L_PJM_VALIDATION_OU_ID -- BUG 13709880
1568: FROM PO_DISTRIBUTIONS_ALL
1569: WHERE PO_DISTRIBUTION_ID = X_LOCATOR_RECORD.PO_DISTRIBUTION_ID;
1570:
1571: ASN_DEBUG.PUT_LINE('X_LOCATOR_RECORD.PO_DISTRIBUTION_ID' ||
1572: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID);
1573:
1574: END IF;
1575:

Line 1578: IF (G_ASN_DEBUG = 'Y') THEN

1574: END IF;
1575:
1576: BEGIN
1577:
1578: IF (G_ASN_DEBUG = 'Y') THEN
1579: ASN_DEBUG.PUT_LINE('BEFORE PROJECT ENABLED ');
1580: END IF;
1581:
1582:

Line 1579: ASN_DEBUG.PUT_LINE('BEFORE PROJECT ENABLED ');

1575:
1576: BEGIN
1577:
1578: IF (G_ASN_DEBUG = 'Y') THEN
1579: ASN_DEBUG.PUT_LINE('BEFORE PROJECT ENABLED ');
1580: END IF;
1581:
1582:
1583: --BUG 14538546

Line 1602: ASN_DEBUG.PUT_LINE('ROI PROJECT TASK ID <> POD PROJECT TASK ID');

1598: IF (NVL(X_LOCATOR_RECORD.PROJECT_ID, X_PROJECT_ID) <> X_PROJECT_ID OR
1599: NVL(X_LOCATOR_RECORD.TASK_ID, X_TASK_ID) <> X_TASK_ID) THEN
1600: RCV_ERROR_PKG.SET_ERROR_MESSAGE('RCV_ALL_INVALID_LOCATOR');
1601: RCV_ERROR_PKG.SET_TOKEN('LOCATOR',X_LOCATOR_RECORD.LOCATOR);
1602: ASN_DEBUG.PUT_LINE('ROI PROJECT TASK ID <> POD PROJECT TASK ID');
1603: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK ID FOR PROJECT ENABLED LOCATOR');
1604:
1605: RAISE E_VALIDATION_ERROR;
1606:

Line 1603: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK ID FOR PROJECT ENABLED LOCATOR');

1599: NVL(X_LOCATOR_RECORD.TASK_ID, X_TASK_ID) <> X_TASK_ID) THEN
1600: RCV_ERROR_PKG.SET_ERROR_MESSAGE('RCV_ALL_INVALID_LOCATOR');
1601: RCV_ERROR_PKG.SET_TOKEN('LOCATOR',X_LOCATOR_RECORD.LOCATOR);
1602: ASN_DEBUG.PUT_LINE('ROI PROJECT TASK ID <> POD PROJECT TASK ID');
1603: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK ID FOR PROJECT ENABLED LOCATOR');
1604:
1605: RAISE E_VALIDATION_ERROR;
1606:
1607: END IF;

Line 1612: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK LOCATOR FOR PROJECT ENABLED LOCATOR ');

1608:
1609: IF (NOT VALID_LOCATOR) THEN
1610: RCV_ERROR_PKG.SET_ERROR_MESSAGE('RCV_ALL_INVALID_LOCATOR');
1611: RCV_ERROR_PKG.SET_TOKEN('LOCATOR',X_LOCATOR_RECORD.LOCATOR);
1612: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK LOCATOR FOR PROJECT ENABLED LOCATOR ');
1613: RAISE E_VALIDATION_ERROR;
1614: ELSE
1615: ASN_DEBUG.PUT_LINE('VALID PROJECT TASK LOCATOR ');
1616: END IF;

Line 1615: ASN_DEBUG.PUT_LINE('VALID PROJECT TASK LOCATOR ');

1611: RCV_ERROR_PKG.SET_TOKEN('LOCATOR',X_LOCATOR_RECORD.LOCATOR);
1612: ASN_DEBUG.PUT_LINE('INVALID PROJECT TASK LOCATOR FOR PROJECT ENABLED LOCATOR ');
1613: RAISE E_VALIDATION_ERROR;
1614: ELSE
1615: ASN_DEBUG.PUT_LINE('VALID PROJECT TASK LOCATOR ');
1616: END IF;
1617:
1618: EXCEPTION
1619: WHEN E_VALIDATION_ERROR THEN

Line 1696: IF (g_asn_debug = 'Y') THEN

1692: FROM po_line_locations
1693: WHERE line_location_id = x_consigned_po_rec.po_line_location_id;
1694:
1695: IF (l_consigned_po_flag = 'Y') THEN
1696: IF (g_asn_debug = 'Y') THEN
1697: asn_debug.put_line('in RCVTIS2B.pls' || l_consigned_po_flag);
1698: END IF;
1699:
1700: rcv_error_pkg.set_error_message('RCV_REJECT_ASBN_CONSIGNED_PO');

Line 1697: asn_debug.put_line('in RCVTIS2B.pls' || l_consigned_po_flag);

1693: WHERE line_location_id = x_consigned_po_rec.po_line_location_id;
1694:
1695: IF (l_consigned_po_flag = 'Y') THEN
1696: IF (g_asn_debug = 'Y') THEN
1697: asn_debug.put_line('in RCVTIS2B.pls' || l_consigned_po_flag);
1698: END IF;
1699:
1700: rcv_error_pkg.set_error_message('RCV_REJECT_ASBN_CONSIGNED_PO');
1701: RAISE e_validation_error;

Line 1734: IF (g_asn_debug = 'Y') THEN

1730: FROM po_headers
1731: WHERE po_header_id = x_consumption_po_rec.po_header_id;
1732:
1733: IF (l_consumption_po_flag = 'Y') THEN
1734: IF (g_asn_debug = 'Y') THEN
1735: asn_debug.put_line('in RCVTIS2B.pls' || l_consumption_po_flag);
1736: END IF;
1737:
1738: rcv_error_pkg.set_error_message('RCV_REJECT_CONSUMPTION_PO');

Line 1735: asn_debug.put_line('in RCVTIS2B.pls' || l_consumption_po_flag);

1731: WHERE po_header_id = x_consumption_po_rec.po_header_id;
1732:
1733: IF (l_consumption_po_flag = 'Y') THEN
1734: IF (g_asn_debug = 'Y') THEN
1735: asn_debug.put_line('in RCVTIS2B.pls' || l_consumption_po_flag);
1736: END IF;
1737:
1738: rcv_error_pkg.set_error_message('RCV_REJECT_CONSUMPTION_PO');
1739: RAISE e_validation_error;

Line 1772: IF (g_asn_debug = 'Y') THEN

1768: FROM po_releases
1769: WHERE po_release_id = x_consumption_release_rec.po_release_id;
1770:
1771: IF (l_consumption_release_flag = 'Y') THEN
1772: IF (g_asn_debug = 'Y') THEN
1773: asn_debug.put_line('in RCVTIS2B.pls, consumption release' || l_consumption_release_flag);
1774: END IF;
1775:
1776: rcv_error_pkg.set_error_message('RCV_REJECT_CONSUMPTION_RELEASE');

Line 1773: asn_debug.put_line('in RCVTIS2B.pls, consumption release' || l_consumption_release_flag);

1769: WHERE po_release_id = x_consumption_release_rec.po_release_id;
1770:
1771: IF (l_consumption_release_flag = 'Y') THEN
1772: IF (g_asn_debug = 'Y') THEN
1773: asn_debug.put_line('in RCVTIS2B.pls, consumption release' || l_consumption_release_flag);
1774: END IF;
1775:
1776: rcv_error_pkg.set_error_message('RCV_REJECT_CONSUMPTION_RELEASE');
1777: RAISE e_validation_error;

Line 1876: IF (g_asn_debug = 'Y') THEN

1872: /*End Bug 13938193*/
1873:
1874: BEGIN
1875: l_progress :='0001';
1876: IF (g_asn_debug = 'Y') THEN
1877: asn_debug.put_line('VALIDATE_SECONDARY_PARAMETERS: Entering' || l_progress);
1878: END IF;
1879:
1880:

Line 1877: asn_debug.put_line('VALIDATE_SECONDARY_PARAMETERS: Entering' || l_progress);

1873:
1874: BEGIN
1875: l_progress :='0001';
1876: IF (g_asn_debug = 'Y') THEN
1877: asn_debug.put_line('VALIDATE_SECONDARY_PARAMETERS: Entering' || l_progress);
1878: END IF;
1879:
1880:
1881: -- Standard call to check for call compatibility.

Line 1889: IF (g_asn_debug = 'Y') THEN

1885: l_api_name,
1886: 'PO_VALIDATE_PARAMETERS'
1887: ) THEN
1888: l_progress :='0002';
1889: IF (g_asn_debug = 'Y') THEN
1890: asn_debug.put_line('FND_API not compatible rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS'||l_progress);
1891: END IF;
1892: END IF;
1893:

Line 1890: asn_debug.put_line('FND_API not compatible rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS'||l_progress);

1886: 'PO_VALIDATE_PARAMETERS'
1887: ) THEN
1888: l_progress :='0002';
1889: IF (g_asn_debug = 'Y') THEN
1890: asn_debug.put_line('FND_API not compatible rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS'||l_progress);
1891: END IF;
1892: END IF;
1893:
1894: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1926: IF (g_asn_debug = 'Y') THEN

1922: l_progress := '001';
1923:
1924: BEGIN
1925: l_progress :='0003';
1926: IF (g_asn_debug = 'Y') THEN
1927: asn_debug.put_line('Inside rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
1928: END IF;
1929:
1930: -------Checking if the item is dual UOM controlled. If not then Return .

Line 1927: asn_debug.put_line('Inside rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

1923:
1924: BEGIN
1925: l_progress :='0003';
1926: IF (g_asn_debug = 'Y') THEN
1927: asn_debug.put_line('Inside rcv_transactions_interface_sv1.VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
1928: END IF;
1929:
1930: -------Checking if the item is dual UOM controlled. If not then Return .
1931: SELECT tracking_quantity_ind , secondary_default_ind

Line 1938: IF (g_asn_debug = 'Y') THEN

1934: WHERE INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1935: AND ORGANIZATION_ID = x_att_rec.to_organization_id;
1936:
1937: l_progress :='0004';
1938: IF (g_asn_debug = 'Y') THEN
1939: asn_debug.put_line('Value of tracking_quantity_ind is ' ||l_TRACKING_QUANTITY_IND ||':'||l_progress);
1940: END IF;
1941:
1942:

Line 1939: asn_debug.put_line('Value of tracking_quantity_ind is ' ||l_TRACKING_QUANTITY_IND ||':'||l_progress);

1935: AND ORGANIZATION_ID = x_att_rec.to_organization_id;
1936:
1937: l_progress :='0004';
1938: IF (g_asn_debug = 'Y') THEN
1939: asn_debug.put_line('Value of tracking_quantity_ind is ' ||l_TRACKING_QUANTITY_IND ||':'||l_progress);
1940: END IF;
1941:
1942:
1943: EXCEPTION

Line 1946: IF g_asn_debug = 'Y' THEN

1942:
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: l_progress :='0005';
1946: IF g_asn_debug = 'Y' THEN
1947: asn_debug.put_line('Dual UOM check failed:' || l_progress);
1948: END IF;
1949:
1950: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;

Line 1947: asn_debug.put_line('Dual UOM check failed:' || l_progress);

1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: l_progress :='0005';
1946: IF g_asn_debug = 'Y' THEN
1947: asn_debug.put_line('Dual UOM check failed:' || l_progress);
1948: END IF;
1949:
1950: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
1951: rcv_error_pkg.set_sql_error_message('Unexpected Exception in validate_secondary_parameters', l_progress);

Line 1961: IF (g_asn_debug = 'Y') THEN

1957:
1958: /*For non dual items.*/
1959: IF l_TRACKING_QUANTITY_IND <> 'PS' THEN
1960: l_progress :='0006';
1961: IF (g_asn_debug = 'Y') THEN
1962: asn_debug.put_line('Item is not dual UOM controlled.:'|| l_progress);
1963: END IF;
1964:
1965: /*Error out if secondary parameters are specified and item is not dual uom controlled*/

Line 1962: asn_debug.put_line('Item is not dual UOM controlled.:'|| l_progress);

1958: /*For non dual items.*/
1959: IF l_TRACKING_QUANTITY_IND <> 'PS' THEN
1960: l_progress :='0006';
1961: IF (g_asn_debug = 'Y') THEN
1962: asn_debug.put_line('Item is not dual UOM controlled.:'|| l_progress);
1963: END IF;
1964:
1965: /*Error out if secondary parameters are specified and item is not dual uom controlled*/
1966: IF x_att_rec.secondary_uom_code IS NOT NULL THEN

Line 2024: IF g_asn_debug = 'Y' THEN

2020: FROM MTL_SYSTEM_ITEMS_B
2021: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
2022: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
2023:
2024: IF g_asn_debug = 'Y' THEN
2025: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2026: END IF;
2027:
2028: IF l_secondary_uom_code <> x_att_rec.secondary_uom_code THEN

Line 2025: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

2021: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
2022: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
2023:
2024: IF g_asn_debug = 'Y' THEN
2025: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2026: END IF;
2027:
2028: IF l_secondary_uom_code <> x_att_rec.secondary_uom_code THEN
2029: l_progress :='0008JN';

Line 2030: IF g_asn_debug = 'Y' THEN

2026: END IF;
2027:
2028: IF l_secondary_uom_code <> x_att_rec.secondary_uom_code THEN
2029: l_progress :='0008JN';
2030: IF g_asn_debug = 'Y' THEN
2031: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2032: END IF;
2033:
2034: /*Log error into po_interface_error*/

Line 2031: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2027:
2028: IF l_secondary_uom_code <> x_att_rec.secondary_uom_code THEN
2029: l_progress :='0008JN';
2030: IF g_asn_debug = 'Y' THEN
2031: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2032: END IF;
2033:
2034: /*Log error into po_interface_error*/
2035: /*

Line 2052: IF g_asn_debug = 'Y' THEN

2048: FROM mtl_units_of_measure
2049: WHERE uom_code = x_att_rec.secondary_uom_code;
2050:
2051: l_progress :='0009';
2052: IF g_asn_debug = 'Y' THEN
2053: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure||':'||l_progress );
2054: END IF;
2055: END IF;
2056:

Line 2053: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure||':'||l_progress );

2049: WHERE uom_code = x_att_rec.secondary_uom_code;
2050:
2051: l_progress :='0009';
2052: IF g_asn_debug = 'Y' THEN
2053: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure||':'||l_progress );
2054: END IF;
2055: END IF;
2056:
2057: EXCEPTION

Line 2059: IF g_asn_debug = 'Y' THEN

2055: END IF;
2056:
2057: EXCEPTION
2058: WHEN OTHERS THEN
2059: IF g_asn_debug = 'Y' THEN
2060: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2061: END IF;
2062: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2063: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);

Line 2060: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);

2056:
2057: EXCEPTION
2058: WHEN OTHERS THEN
2059: IF g_asn_debug = 'Y' THEN
2060: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2061: END IF;
2062: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2063: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);
2064: x_att_rec.error_record.error_message := rcv_error_pkg.get_last_message;

Line 2081: IF g_asn_debug = 'Y' THEN

2077: FROM MTL_SYSTEM_ITEMS_B
2078: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2079: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2080:
2081: IF g_asn_debug = 'Y' THEN
2082: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
2083: END IF;
2084:
2085: SELECT UNIT_OF_MEASURE

Line 2082: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);

2078: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2079: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2080:
2081: IF g_asn_debug = 'Y' THEN
2082: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
2083: END IF;
2084:
2085: SELECT UNIT_OF_MEASURE
2086: INTO l_secondary_unit_of_measure

Line 2091: IF g_asn_debug = 'Y' THEN

2087: FROM mtl_units_of_measure
2088: WHERE uom_code = x_att_rec.secondary_uom_code;
2089:
2090: l_progress :='0011';
2091: IF g_asn_debug = 'Y' THEN
2092: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );
2093: END IF;
2094:
2095: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN

Line 2092: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );

2088: WHERE uom_code = x_att_rec.secondary_uom_code;
2089:
2090: l_progress :='0011';
2091: IF g_asn_debug = 'Y' THEN
2092: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );
2093: END IF;
2094:
2095: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN
2096:

Line 2098: IF g_asn_debug = 'Y' THEN

2094:
2095: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN
2096:
2097: l_progress :='0012';
2098: IF g_asn_debug = 'Y' THEN
2099: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);
2100: END IF;
2101:
2102: /*Log error into po_interface_error*/

Line 2099: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);

2095: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN
2096:
2097: l_progress :='0012';
2098: IF g_asn_debug = 'Y' THEN
2099: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);
2100: END IF;
2101:
2102: /*Log error into po_interface_error*/
2103: /*

Line 2117: IF g_asn_debug = 'Y' THEN

2113: END IF;
2114:
2115: EXCEPTION
2116: WHEN OTHERS THEN
2117: IF g_asn_debug = 'Y' THEN
2118: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2119: END IF;
2120: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2121: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);

Line 2118: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);

2114:
2115: EXCEPTION
2116: WHEN OTHERS THEN
2117: IF g_asn_debug = 'Y' THEN
2118: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2119: END IF;
2120: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2121: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);
2122: x_att_rec.error_record.error_message := rcv_error_pkg.get_last_message;

Line 2139: IF g_asn_debug = 'Y' THEN

2135: FROM MTL_SYSTEM_ITEMS_B
2136: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2137: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2138:
2139: IF g_asn_debug = 'Y' THEN
2140: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
2141: END IF;
2142:
2143: Select UNIT_OF_MEASURE

Line 2140: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );

2136: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2137: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2138:
2139: IF g_asn_debug = 'Y' THEN
2140: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
2141: END IF;
2142:
2143: Select UNIT_OF_MEASURE
2144: INTO x_att_rec.secondary_unit_of_measure

Line 2149: IF g_asn_debug = 'Y' THEN

2145: FROM mtl_units_of_measure
2146: WHERE uom_code = x_att_rec.secondary_uom_code;
2147:
2148: l_progress :='0014';
2149: IF g_asn_debug = 'Y' THEN
2150: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure ||':'||l_progress);
2151: END IF;
2152:
2153: EXCEPTION

Line 2150: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure ||':'||l_progress);

2146: WHERE uom_code = x_att_rec.secondary_uom_code;
2147:
2148: l_progress :='0014';
2149: IF g_asn_debug = 'Y' THEN
2150: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_unit_of_measure ||':'||l_progress);
2151: END IF;
2152:
2153: EXCEPTION
2154: WHEN OTHERS THEN

Line 2155: IF g_asn_debug = 'Y' THEN

2151: END IF;
2152:
2153: EXCEPTION
2154: WHEN OTHERS THEN
2155: IF g_asn_debug = 'Y' THEN
2156: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2157: END IF;
2158: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2159: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);

Line 2156: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);

2152:
2153: EXCEPTION
2154: WHEN OTHERS THEN
2155: IF g_asn_debug = 'Y' THEN
2156: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2157: END IF;
2158: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2159: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);
2160: x_att_rec.error_record.error_message := rcv_error_pkg.get_last_message;

Line 2177: IF g_asn_debug = 'Y' THEN

2173: FROM MTL_SYSTEM_ITEMS_B
2174: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2175: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2176:
2177: IF g_asn_debug = 'Y' THEN
2178: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2179: END IF;
2180:
2181: IF l_secondary_uom_code <>x_att_rec.secondary_uom_code THEN

Line 2178: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );

2174: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2175: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2176:
2177: IF g_asn_debug = 'Y' THEN
2178: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2179: END IF;
2180:
2181: IF l_secondary_uom_code <>x_att_rec.secondary_uom_code THEN
2182: l_progress :='0016';

Line 2183: IF g_asn_debug = 'Y' THEN

2179: END IF;
2180:
2181: IF l_secondary_uom_code <>x_att_rec.secondary_uom_code THEN
2182: l_progress :='0016';
2183: IF g_asn_debug = 'Y' THEN
2184: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2185: END IF;
2186:
2187: /*Log error into po_interface_error*/

Line 2184: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);

2180:
2181: IF l_secondary_uom_code <>x_att_rec.secondary_uom_code THEN
2182: l_progress :='0016';
2183: IF g_asn_debug = 'Y' THEN
2184: asn_debug.put_line('Secondary uom code validation failed in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2185: END IF;
2186:
2187: /*Log error into po_interface_error*/
2188: /*

Line 2209: IF g_asn_debug = 'Y' THEN

2205: FROM mtl_units_of_measure
2206: WHERE uom_code = x_att_rec.secondary_uom_code;
2207:
2208: l_progress :='0171';
2209: IF g_asn_debug = 'Y' THEN
2210: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );
2211: END IF;
2212:
2213: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN

Line 2210: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );

2206: WHERE uom_code = x_att_rec.secondary_uom_code;
2207:
2208: l_progress :='0171';
2209: IF g_asn_debug = 'Y' THEN
2210: asn_debug.put_line('Secondary unit of measure derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_unit_of_measure||':'|| l_progress );
2211: END IF;
2212:
2213: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN
2214:

Line 2217: IF g_asn_debug = 'Y' THEN

2213: IF l_secondary_unit_of_measure <> x_att_rec.secondary_unit_of_measure THEN
2214:
2215: l_progress :='0172';
2216:
2217: IF g_asn_debug = 'Y' THEN
2218: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);
2219: END IF;
2220:
2221: /*Log error into po_interface_error*/

Line 2218: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);

2214:
2215: l_progress :='0172';
2216:
2217: IF g_asn_debug = 'Y' THEN
2218: asn_debug.put_line('Secondary unit of measure validation failed in VALIDATE_SECONDARY_PARAMETERS'||':'||l_progress);
2219: END IF;
2220:
2221: /*Log error into po_interface_error*/
2222: /*

Line 2239: IF g_asn_debug = 'Y' THEN

2235: END IF; ------------IF l_secondary_uom_code <>x_att_rec.secondary_uom_code THEN
2236:
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: IF g_asn_debug = 'Y' THEN
2240: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2241: END IF;
2242: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2243: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);

Line 2240: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);

2236:
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: IF g_asn_debug = 'Y' THEN
2240: asn_debug.put_line('SQL in validate_secondary_parameters failed:' || l_progress);
2241: END IF;
2242: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2243: rcv_error_pkg.set_sql_error_message('Unexpected Exception:validate_secondary_parameters', l_progress);
2244: x_att_rec.error_record.error_message := rcv_error_pkg.get_last_message;

Line 2257: IF g_asn_debug = 'Y' THEN

2253: --BUG#13401431 added the l_conv_exist to check lot specific conversion is existing or not.
2254: --if its existing then by pass this check. as already deviation is checked.
2255: IF x_att_rec.secondary_quantity IS NOT NULL AND l_secondary_default_ind IN ('D','N')AND l_conv_exist <>1 THEN
2256: l_progress :='0018';
2257: IF g_asn_debug = 'Y' THEN
2258: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);
2259: END IF;
2260:
2261: l_check_dev := INV_CONVERT.Within_deviation(

Line 2258: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);

2254: --if its existing then by pass this check. as already deviation is checked.
2255: IF x_att_rec.secondary_quantity IS NOT NULL AND l_secondary_default_ind IN ('D','N')AND l_conv_exist <>1 THEN
2256: l_progress :='0018';
2257: IF g_asn_debug = 'Y' THEN
2258: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);
2259: END IF;
2260:
2261: l_check_dev := INV_CONVERT.Within_deviation(
2262: p_organization_id => X_ATT_REC.to_organization_id ,

Line 2278: IF g_asn_debug = 'Y' THEN

2274: /* Returns 1 for True and 0 for False*/
2275:
2276: IF l_check_dev=0 THEN
2277: l_progress :='0019';
2278: IF g_asn_debug = 'Y' THEN
2279: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2280: END IF;
2281: /*Log error into po_interface_error */
2282: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_error;

Line 2279: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2275:
2276: IF l_check_dev=0 THEN
2277: l_progress :='0019';
2278: IF g_asn_debug = 'Y' THEN
2279: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2280: END IF;
2281: /*Log error into po_interface_error */
2282: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_error;
2283: rcv_error_pkg.set_error_message('PO_SRCE_ORG_OUT_OF_DEV');

Line 2290: IF g_asn_debug = 'Y' THEN

2286: RETURN;
2287: END IF;
2288:
2289: l_progress :='0020';
2290: IF g_asn_debug = 'Y' THEN
2291: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2292: END IF;
2293:
2294:

Line 2291: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2287: END IF;
2288:
2289: l_progress :='0020';
2290: IF g_asn_debug = 'Y' THEN
2291: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2292: END IF;
2293:
2294:
2295: ELSE -------- x_att_rec.secondary_quantity IS NULL OR l_secondary_default_ind = 'F' THEN

Line 2302: IF g_asn_debug = 'Y' THEN

2298: to be fixed according to a predefined conversion*/
2299:
2300: l_progress :='0021';
2301:
2302: IF g_asn_debug = 'Y' THEN
2303: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2304: END IF;
2305:
2306: x_att_rec.secondary_quantity:= INV_CONVERT.Inv_um_convert (

Line 2303: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);

2299:
2300: l_progress :='0021';
2301:
2302: IF g_asn_debug = 'Y' THEN
2303: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2304: END IF;
2305:
2306: x_att_rec.secondary_quantity:= INV_CONVERT.Inv_um_convert (
2307: item_id => x_att_rec.inventory_item_id ,

Line 2322: IF g_asn_debug = 'Y' THEN

2318:
2319:
2320: IF x_att_rec.secondary_quantity = -99999 THEN
2321: l_progress :='0022';
2322: IF g_asn_debug = 'Y' THEN
2323: asn_debug.put_line('fetch secondary quantity failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2324: END IF;
2325: /*Log error into po_interface_error */
2326: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;

Line 2323: asn_debug.put_line('fetch secondary quantity failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2319:
2320: IF x_att_rec.secondary_quantity = -99999 THEN
2321: l_progress :='0022';
2322: IF g_asn_debug = 'Y' THEN
2323: asn_debug.put_line('fetch secondary quantity failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2324: END IF;
2325: /*Log error into po_interface_error */
2326: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_unexp_error;
2327: rcv_error_pkg.set_sql_error_message('Unexpected exception :fetch secondary quantity failed in validate_secondary_parameters', l_progress);

Line 2334: IF g_asn_debug = 'Y' THEN

2330: RETURN;
2331: END IF;
2332:
2333: l_progress :='0023';
2334: IF g_asn_debug = 'Y' THEN
2335: asn_debug.put_line('After successfully calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2336: asn_debug.put_line('value of secondary quantity derived by INV_CONVERT.Inv_um_convert is:'|| x_att_rec.secondary_quantity);
2337: END IF;
2338:

Line 2335: asn_debug.put_line('After successfully calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2331: END IF;
2332:
2333: l_progress :='0023';
2334: IF g_asn_debug = 'Y' THEN
2335: asn_debug.put_line('After successfully calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2336: asn_debug.put_line('value of secondary quantity derived by INV_CONVERT.Inv_um_convert is:'|| x_att_rec.secondary_quantity);
2337: END IF;
2338:
2339:

Line 2336: asn_debug.put_line('value of secondary quantity derived by INV_CONVERT.Inv_um_convert is:'|| x_att_rec.secondary_quantity);

2332:
2333: l_progress :='0023';
2334: IF g_asn_debug = 'Y' THEN
2335: asn_debug.put_line('After successfully calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2336: asn_debug.put_line('value of secondary quantity derived by INV_CONVERT.Inv_um_convert is:'|| x_att_rec.secondary_quantity);
2337: END IF;
2338:
2339:
2340: END IF;-----IF x_att_rec.secondary_quantity IS NOT NULL AND l_secondary_default_ind IN ('D','N') THEN

Line 2361: IF g_asn_debug = 'Y' THEN

2357: END ;
2358:
2359: IF lot_rec1.secondary_transaction_quantity IS NOT NULL AND l_secondary_default_ind IN ('D','N')AND l_conv_exist <>1 THEN
2360: l_progress :='0018';
2361: IF g_asn_debug = 'Y' THEN
2362: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);
2363: END IF;
2364:
2365: l_check_dev := INV_CONVERT.Within_deviation(

Line 2362: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);

2358:
2359: IF lot_rec1.secondary_transaction_quantity IS NOT NULL AND l_secondary_default_ind IN ('D','N')AND l_conv_exist <>1 THEN
2360: l_progress :='0018';
2361: IF g_asn_debug = 'Y' THEN
2362: asn_debug.put_line('Before calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' ||l_progress);
2363: END IF;
2364:
2365: l_check_dev := INV_CONVERT.Within_deviation(
2366: p_organization_id => X_ATT_REC.to_organization_id ,

Line 2385: IF g_asn_debug = 'Y' THEN

2381: /* Returns 1 for True and 0 for False*/
2382:
2383: IF l_check_dev=0 THEN
2384: l_progress :='0019';
2385: IF g_asn_debug = 'Y' THEN
2386: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2387: END IF;
2388: /*Log error into po_interface_error */
2389: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_error;

Line 2386: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2382:
2383: IF l_check_dev=0 THEN
2384: l_progress :='0019';
2385: IF g_asn_debug = 'Y' THEN
2386: asn_debug.put_line('within deviation check failed in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2387: END IF;
2388: /*Log error into po_interface_error */
2389: x_att_rec.error_record.error_status := fnd_api.g_ret_sts_error;
2390: rcv_error_pkg.set_error_message('PO_SRCE_ORG_OUT_OF_DEV');

Line 2399: IF g_asn_debug = 'Y' THEN

2395:
2396: l_sec_lot_dev_tqty := lot_rec1.secondary_transaction_quantity + l_sec_lot_dev_tqty ;
2397:
2398: l_progress :='0020';
2399: IF g_asn_debug = 'Y' THEN
2400: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2401: END IF;
2402:
2403:

Line 2400: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2396: l_sec_lot_dev_tqty := lot_rec1.secondary_transaction_quantity + l_sec_lot_dev_tqty ;
2397:
2398: l_progress :='0020';
2399: IF g_asn_debug = 'Y' THEN
2400: asn_debug.put_line('After successfully calling within deviation check in VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2401: END IF;
2402:
2403:
2404: ELSE -------- x_att_rec.secondary_quantity IS NULL OR l_secondary_default_ind = 'F' THEN

Line 2411: IF g_asn_debug = 'Y' THEN

2407: to be fixed according to a predefined conversion*/
2408:
2409: l_progress :='0021';
2410:
2411: IF g_asn_debug = 'Y' THEN
2412: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2413: END IF;
2414:
2415:

Line 2412: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);

2408:
2409: l_progress :='0021';
2410:
2411: IF g_asn_debug = 'Y' THEN
2412: asn_debug.put_line('Befordesc inv_e calling INV_CONVERT.Inv_um_convert for fetching secondary quantity in VALIDATE_SECONDARY_PARAMETERS:'||l_progress);
2413: END IF;
2414:
2415:
2416: l_sec_lot_spe_qty := INV_CONVERT.Inv_um_convert (

Line 2446: IF g_asn_debug = 'Y' THEN

2442: END IF ;-- IF l_lot_number is null
2443:
2444:
2445: l_progress :='0024';
2446: IF g_asn_debug = 'Y' THEN
2447: asn_debug.put_line('End of VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2448: END IF;
2449:
2450:

Line 2447: asn_debug.put_line('End of VALIDATE_SECONDARY_PARAMETERS:' || l_progress);

2443:
2444:
2445: l_progress :='0024';
2446: IF g_asn_debug = 'Y' THEN
2447: asn_debug.put_line('End of VALIDATE_SECONDARY_PARAMETERS:' || l_progress);
2448: END IF;
2449:
2450:
2451: EXCEPTION