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_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 998: rcv_transactions_interface_sv.get_location_id(location_id_record);

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

Line 1113: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1660: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,

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

Line 1666: + rcv_transactions_interface_sv.convert_into_correct_qty(txn_remaining_qty,

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

Line 2483: rcv_transactions_interface_sv1.validate_item_description(item_id_record);

2479: IF (g_asn_debug = 'Y') THEN
2480: asn_debug.put_line('Validating Item Description ' || item_id_record.item_description);
2481: END IF;
2482:
2483: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
2484: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
2485: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
2486: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_DESCRIPTION');
2487:

Line 2628: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);

2624: IF (g_asn_debug = 'Y') THEN
2625: asn_debug.put_line('Validating Freight Carrier');
2626: END IF;
2627:
2628: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
2629: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
2630: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
2631: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2632: 'FREIGHT_CARRIER_CODE',

Line 2660: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

2656: IF (g_asn_debug = 'Y') THEN
2657: asn_debug.put_line('Validating Destination Type Code');
2658: END IF;
2659:
2660: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
2661: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
2662: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
2663: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2664: 'DESTINATION_TYPE_CODE',

Line 2693: rcv_transactions_interface_sv1.validate_employee(employee_record);

2689: IF (g_asn_debug = 'Y') THEN
2690: asn_debug.put_line('Validating Deliver to Person');
2691: END IF;
2692:
2693: rcv_transactions_interface_sv1.validate_employee(employee_record);
2694: x_cascaded_table(n).error_status := employee_record.error_record.error_status;
2695: x_cascaded_table(n).error_message := employee_record.error_record.error_message;
2696: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2697: 'DELIVER_TO_PERSON_ID',

Line 2739: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);

2735: IF (g_asn_debug = 'Y') THEN
2736: asn_debug.put_line('Validating Country of Origin Code');
2737: END IF;
2738:
2739: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
2740: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
2741: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
2742: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
2743: 'COUNTRY_OF_ORIGIN_CODE',

Line 2753: Copied from rcv_transactions_interface_sv1 and modified for RMA use

2749: /*===========================================================================
2750:
2751: PROCEDURE NAME: validate_item()
2752:
2753: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2754:
2755: ===========================================================================*/
2756: PROCEDURE validate_item(
2757: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,

Line 2758: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE

2754:
2755: ===========================================================================*/
2756: PROCEDURE validate_item(
2757: x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
2758: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%TYPE
2759: ) IS -- bug 608353
2760: x_progress VARCHAR2(3);
2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2762: x_organization_id mtl_system_items.organization_id%TYPE;

Line 2879: Copied from rcv_transactions_interface_sv1 and modified for RMA use

2875: /*===========================================================================
2876:
2877: PROCEDURE NAME: validate_item_revision()
2878:
2879: Copied from rcv_transactions_interface_sv1 and modified for RMA use
2880:
2881: ===========================================================================*/
2882: PROCEDURE validate_item_revision(
2883: x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type

Line 2990: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;

2986: PROCEDURE validate_ref_integrity(
2987: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2988: n IN BINARY_INTEGER
2989: ) IS
2990: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
2991: x_customer_id rcv_transactions_interface.customer_id%TYPE;
2992: x_order_line_id oe_order_lines_all.line_id%TYPE;
2993: BEGIN
2994: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 2991: x_customer_id rcv_transactions_interface.customer_id%TYPE;

2987: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2988: n IN BINARY_INTEGER
2989: ) IS
2990: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
2991: x_customer_id rcv_transactions_interface.customer_id%TYPE;
2992: x_order_line_id oe_order_lines_all.line_id%TYPE;
2993: BEGIN
2994: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2995: RETURN;

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

3035: WHEN rcv_error_pkg.e_fatal_error THEN
3036: NULL;
3037: END validate_ref_integrity;
3038:
3039: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3040: PROCEDURE validate_uom(
3041: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3042: ) IS
3043: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;

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

3039: -- Copied from rcv_transactions_interface_sv1.validate_uom and modified for RMAs
3040: PROCEDURE validate_uom(
3041: x_uom_record IN OUT NOCOPY rcv_shipment_line_sv.quantity_shipped_record_type
3042: ) IS
3043: x_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE := NULL;
3044: x_unit_meas_lookup_code_lines po_lines_all.unit_meas_lookup_code%TYPE := NULL;
3045: x_progress VARCHAR2(3);
3046: x_new_conversion NUMBER := 0;
3047: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;