DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 273: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE

269: );
270:
271: PROCEDURE validate_item(
272: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
273: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
274: );
275:
276: -- main public procedures
277: PROCEDURE derive_rma_line(

Line 999: rcv_transactions_interface_sv.get_location_id(location_id_record);

995: IF (g_asn_debug = 'Y') THEN
996: asn_debug.put_line('Derive deliver_to_location_id');
997: END IF;
998:
999: rcv_transactions_interface_sv.get_location_id(location_id_record);
1000: x_cascaded_table(n).deliver_to_location_id := location_id_record.location_id;
1001: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
1002: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
1003: END IF;

Line 1114: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;

1110: x_days_early_receipt NUMBER;
1111: x_days_late_receipt NUMBER;
1112: x_enforce_ship_to_loc VARCHAR2(25) := 'N';
1113: x_line_category_code VARCHAR2(30);
1114: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
1115: x_ship_to_organization_id NUMBER;
1116: x_ship_to_location_id NUMBER;
1117: x_full_name VARCHAR2(240);
1118: x_sob_id NUMBER;

Line 1361: txn_remaining_qty_rma_uom := rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,

1357: rma_uom_qty := 0; -- initialize
1358: primary_uom_qty := 0; -- initialize
1359:
1360: IF insert_into_table THEN
1361: txn_remaining_qty_rma_uom := rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,
1362: temp_cascaded_table(1).unit_of_measure,
1363: temp_cascaded_table(1).item_id,
1364: x_rma_line_record.unit_of_measure
1365: );

Line 1367: rma_receipt_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,

1363: temp_cascaded_table(1).item_id,
1364: x_rma_line_record.unit_of_measure
1365: );
1366: -- using arbit qty for RMA->Receipt UOM, RMA->Primary UOM conversion as this is just a check
1367: rma_receipt_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
1368: x_rma_line_record.unit_of_measure,
1369: temp_cascaded_table(1).item_id,
1370: temp_cascaded_table(1).unit_of_measure
1371: );

Line 1372: rma_primary_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,

1368: x_rma_line_record.unit_of_measure,
1369: temp_cascaded_table(1).item_id,
1370: temp_cascaded_table(1).unit_of_measure
1371: );
1372: rma_primary_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
1373: x_rma_line_record.unit_of_measure,
1374: temp_cascaded_table(1).item_id,
1375: temp_cascaded_table(1).primary_unit_of_measure
1376: );

Line 1441: temp_cascaded_table(temp_cascaded_table.LAST).quantity := rcv_transactions_interface_sv.convert_into_correct_qty(allocate_qty,

1437: -- for a corresponding record in the interface, as the quantity is already in asn uom.
1438: -- If the cursor fetches more than one row then the quantity in the interface will be
1439: -- distributed accross the fetched rows and hence need to do the following conversion.
1440: IF rma_lines%ROWCOUNT > 1 THEN
1441: temp_cascaded_table(temp_cascaded_table.LAST).quantity := rcv_transactions_interface_sv.convert_into_correct_qty(allocate_qty,
1442: x_rma_line_record.unit_of_measure,
1443: temp_cascaded_table(temp_cascaded_table.LAST).item_id,
1444: temp_cascaded_table(temp_cascaded_table.LAST).unit_of_measure
1445: );

Line 1449: temp_cascaded_table(temp_cascaded_table.LAST).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(allocate_qty,

1445: );
1446: END IF;
1447:
1448: -- Primary qty in Primary UOM
1449: temp_cascaded_table(temp_cascaded_table.LAST).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(allocate_qty,
1450: x_rma_line_record.unit_of_measure,
1451: temp_cascaded_table(temp_cascaded_table.LAST).item_id,
1452: temp_cascaded_table(temp_cascaded_table.LAST).primary_unit_of_measure
1453: );

Line 1462: txn_remaining_qty := rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty_rma_uom,

1458: END IF;
1459:
1460: -- update the remaining quantity
1461: txn_remaining_qty_rma_uom := txn_remaining_qty_rma_uom - allocate_qty;
1462: txn_remaining_qty := rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty_rma_uom,
1463: x_rma_line_record.unit_of_measure,
1464: temp_cascaded_table(1).item_id,
1465: temp_cascaded_table(1).unit_of_measure
1466: );

Line 1663: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,

1659: IF rma_lines_fetched > 1 THEN
1660: temp_cascaded_table(temp_cascaded_table.LAST).quantity := temp_cascaded_table(temp_cascaded_table.LAST).quantity + txn_remaining_qty;
1661: END IF;
1662: temp_cascaded_table(temp_cascaded_table.LAST).primary_quantity := temp_cascaded_table(temp_cascaded_table.LAST).primary_quantity
1663: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,
1664: temp_cascaded_table(temp_cascaded_table.LAST).unit_of_measure,
1665: temp_cascaded_table(temp_cascaded_table.LAST).item_id,
1666: temp_cascaded_table(temp_cascaded_table.LAST).primary_unit_of_measure
1667: );

Line 1669: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,

1665: temp_cascaded_table(temp_cascaded_table.LAST).item_id,
1666: temp_cascaded_table(temp_cascaded_table.LAST).primary_unit_of_measure
1667: );
1668: temp_cascaded_table(temp_cascaded_table.LAST).source_doc_quantity := temp_cascaded_table(temp_cascaded_table.LAST).source_doc_quantity
1669: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,
1670: temp_cascaded_table(temp_cascaded_table.LAST).unit_of_measure,
1671: temp_cascaded_table(temp_cascaded_table.LAST).item_id,
1672: temp_cascaded_table(temp_cascaded_table.LAST).source_doc_unit_of_measure
1673: );

Line 2517: rcv_transactions_interface_sv1.validate_item_description(item_id_record);

2513: IF (g_asn_debug = 'Y') THEN
2514: asn_debug.put_line('Validating Item Description ' || item_id_record.item_description);
2515: END IF;
2516:
2517: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
2518: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2519: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2520: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_DESCRIPTION');
2521:

Line 2676: from rcv_transactions_interface rti

2672: x_parent_txn_id := x_cascaded_table(n).parent_interface_txn_id;
2673: if (x_parent_txn_id is not null) then
2674: BEGIN
2675: SELECT transaction_date into x_parent_txn_date
2676: from rcv_transactions_interface rti
2677: where rti.interface_transaction_id = x_parent_txn_id;
2678: Exception
2679: WHEN OTHERS THEN
2680: x_parent_txn_date := null;

Line 2767: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);

2763: IF (g_asn_debug = 'Y') THEN
2764: asn_debug.put_line('Validating Freight Carrier');
2765: END IF;
2766:
2767: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
2768: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
2769: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
2770: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2771: 'FREIGHT_CARRIER_CODE',

Line 2799: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

2795: IF (g_asn_debug = 'Y') THEN
2796: asn_debug.put_line('Validating Destination Type Code');
2797: END IF;
2798:
2799: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
2800: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
2801: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
2802: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2803: 'DESTINATION_TYPE_CODE',

Line 2832: rcv_transactions_interface_sv1.validate_employee(employee_record);

2828: IF (g_asn_debug = 'Y') THEN
2829: asn_debug.put_line('Validating Deliver to Person');
2830: END IF;
2831:
2832: rcv_transactions_interface_sv1.validate_employee(employee_record);
2833: x_cascaded_table(n).error_status := employee_record.error_record.error_status;
2834: x_cascaded_table(n).error_message := employee_record.error_record.error_message;
2835: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2836: 'DELIVER_TO_PERSON_ID',

Line 2878: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);

2874: IF (g_asn_debug = 'Y') THEN
2875: asn_debug.put_line('Validating Country of Origin Code');
2876: END IF;
2877:
2878: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
2879: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
2880: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
2881: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2882: 'COUNTRY_OF_ORIGIN_CODE',

Line 2892: Copied from rcv_transactions_interface_sv1 and modified for RMA use

2888: /*===========================================================================
2889:
2890: PROCEDURE NAME: validate_item()
2891:
2892: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2893:
2894: ===========================================================================*/
2895: PROCEDURE validate_item(
2896: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

Line 2897: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE

2893:
2894: ===========================================================================*/
2895: PROCEDURE validate_item(
2896: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2897: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2898: ) IS -- bug 608353
2899: x_progress VARCHAR2(3);
2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2901: x_organization_id mtl_system_items.organization_id%TYPE;

Line 3019: Copied from rcv_transactions_interface_sv1 and modified for RMA use

3015: /*===========================================================================
3016:
3017: PROCEDURE NAME: validate_item_revision()
3018:
3019: Copied from rcv_transactions_interface_sv1 and modified for RMA use
3020:
3021: ===========================================================================*/
3022: PROCEDURE validate_item_revision(
3023: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

Line 3130: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;

3126: PROCEDURE validate_ref_integrity(
3127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3128: n IN BINARY_INTEGER
3129: ) IS
3130: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
3131: x_customer_id rcv_transactions_interface.customer_id%TYPE;
3132: x_order_line_id oe_order_lines_all.line_id%TYPE;
3133: BEGIN
3134: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 3131: x_customer_id rcv_transactions_interface.customer_id%TYPE;

3127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3128: n IN BINARY_INTEGER
3129: ) IS
3130: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
3131: x_customer_id rcv_transactions_interface.customer_id%TYPE;
3132: x_order_line_id oe_order_lines_all.line_id%TYPE;
3133: BEGIN
3134: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
3135: RETURN;

Line 3179: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs

3175: WHEN rcv_error_pkg.e_fatal_error THEN
3176: NULL;
3177: END validate_ref_integrity;
3178:
3179: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3180: PROCEDURE validate_uom(
3181: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3182: ) IS
3183: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;

Line 3183: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;

3179: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3180: PROCEDURE validate_uom(
3181: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3182: ) IS
3183: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3184: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3185: x_progress VARCHAR2(3);
3186: x_new_conversion NUMBER := 0;
3187: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;