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_ROI_TRANSACTION dependencies on RCV_TRANSACTIONS_INTERFACE_SV

Line 946: rcv_transactions_interface_sv.default_item_revision(item_id_record);

942: item_id_record.to_organization_id := x_cascaded_table(n).to_organization_id;
943: item_id_record.item_revision := x_cascaded_table(n).item_revision;
944: item_id_record.error_record.error_status := 'S';
945: item_id_record.error_record.error_message := NULL;
946: rcv_transactions_interface_sv.default_item_revision(item_id_record);
947: x_cascaded_table(n).item_revision := item_id_record.item_revision;
948:
949: IF (g_asn_debug = 'Y') THEN
950: asn_debug.put_line(NVL(item_id_record.item_revision, 'Item Revision is null'));

Line 1744: rcv_transactions_interface_sv.get_po_header_id(document_num_record);

1740: IF (g_asn_debug = 'Y') THEN
1741: asn_debug.put_line('Derive po_header_id');
1742: END IF;
1743:
1744: rcv_transactions_interface_sv.get_po_header_id(document_num_record);
1745: x_cascaded_table(n).po_header_id := document_num_record.po_header_id;
1746: x_cascaded_table(n).error_status := document_num_record.error_record.error_status;
1747: x_cascaded_table(n).error_message := document_num_record.error_record.error_message;
1748: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1825: rcv_transactions_interface_sv.get_item_id(item_id_record);

1821: IF (g_asn_debug = 'Y') THEN
1822: asn_debug.put_line('Derive item_id');
1823: END IF;
1824:
1825: rcv_transactions_interface_sv.get_item_id(item_id_record);
1826: x_cascaded_table(n).item_id := item_id_record.item_id;
1827: x_cascaded_table(n).primary_unit_of_measure := item_id_record.primary_unit_of_measure;
1828: x_cascaded_table(n).use_mtl_lot := item_id_record.use_mtl_lot; -- bug 608353
1829: x_cascaded_table(n).use_mtl_serial := item_id_record.use_mtl_serial; -- bug 608353

Line 1868: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);

1864: IF (g_asn_debug = 'Y') THEN
1865: asn_debug.put_line('Derive Substitute Item Id');
1866: END IF;
1867:
1868: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);
1869: x_cascaded_table(n).substitute_item_id := sub_item_id_record.substitute_item_id;
1870: x_cascaded_table(n).error_status := sub_item_id_record.error_record.error_status;
1871: x_cascaded_table(n).error_message := sub_item_id_record.error_record.error_message;
1872:

Line 1917: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);

1913: IF (g_asn_debug = 'Y') THEN
1914: asn_debug.put_line('Derive po_line_id');
1915: END IF;
1916:
1917: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);
1918:
1919: IF x_cascaded_table(n).item_id IS NULL THEN
1920: x_cascaded_table(n).item_id := po_line_id_record.item_id;
1921: END IF;

Line 2353: rcv_transactions_interface_sv.get_location_id(location_id_record);

2349: IF (g_asn_debug = 'Y') THEN
2350: asn_debug.put_line('Derive location_id');
2351: END IF;
2352:
2353: rcv_transactions_interface_sv.get_location_id(location_id_record);
2354: x_cascaded_table(n).location_id := location_id_record.location_id;
2355: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
2356: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
2357: END IF;

Line 2381: rcv_transactions_interface_sv.get_location_id(location_id_record);

2377: IF (g_asn_debug = 'Y') THEN
2378: asn_debug.put_line('Derive ship to location_id');
2379: END IF;
2380:
2381: rcv_transactions_interface_sv.get_location_id(location_id_record);
2382: x_cascaded_table(n).ship_to_location_id := location_id_record.location_id;
2383: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
2384: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
2385: END IF;

Line 2409: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);

2405: IF (g_asn_debug = 'Y') THEN
2406: asn_debug.put_line('Derive routing_header_id');
2407: END IF;
2408:
2409: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);
2410: x_cascaded_table(n).routing_header_id := routing_header_id_record.routing_header_id;
2411: x_cascaded_table(n).error_status := routing_header_id_record.error_record.error_status;
2412: x_cascaded_table(n).error_message := routing_header_id_record.error_record.error_message;
2413: END IF;

Line 2437: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);

2433: IF (g_asn_debug = 'Y') THEN
2434: asn_debug.put_line('Derive routing Step Id');
2435: END IF;
2436:
2437: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);
2438: x_cascaded_table(n).routing_step_id := routing_step_id_record.routing_step_id;
2439: x_cascaded_table(n).error_status := routing_step_id_record.error_record.error_status;
2440: x_cascaded_table(n).error_message := routing_step_id_record.error_record.error_message;
2441: END IF;

Line 2509: rcv_transactions_interface_sv.get_location_id(location_id_record);

2505: IF (g_asn_debug = 'Y') THEN
2506: asn_debug.put_line('Derive deliver_to_location_id');
2507: END IF;
2508:
2509: rcv_transactions_interface_sv.get_location_id(location_id_record);
2510: x_cascaded_table(n).deliver_to_location_id := location_id_record.location_id;
2511: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
2512: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
2513: END IF;

Line 3028: rcv_transactions_interface_sv.get_reason_id(reason_id_record);

3024: IF (g_asn_debug = 'Y') THEN
3025: asn_debug.put_line('Derive Reason_id');
3026: END IF;
3027:
3028: rcv_transactions_interface_sv.get_reason_id(reason_id_record);
3029: x_cascaded_table(n).reason_id := reason_id_record.reason_id;
3030: x_cascaded_table(n).error_status := reason_id_record.error_record.error_status;
3031: x_cascaded_table(n).error_message := reason_id_record.error_record.error_message;
3032: END IF;

Line 4086: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

4082: temp_cascaded_table(current_n).quantity := temp_cascaded_table(current_n).quantity + x_remaining_quantity;
4083: temp_cascaded_table(current_n).quantity_shipped := temp_cascaded_table(current_n).quantity_shipped + x_remaining_quantity;
4084: temp_cascaded_table(current_n).source_doc_quantity := temp_cascaded_table(current_n).source_doc_quantity + x_remaining_qty_po_uom;
4085: temp_cascaded_table(current_n).primary_quantity := temp_cascaded_table(current_n).primary_quantity
4086: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
4087: temp_cascaded_table(1).unit_of_measure,
4088: temp_cascaded_table(1).item_id,
4089: temp_cascaded_table(1).primary_unit_of_measure
4090: );

Line 4684: rcv_transactions_interface_sv.check_date_tolerance(NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date), -- Bug 487222

4680: asn_debug.put_line('Cursor record ' || TO_CHAR(rows_fetched));
4681: asn_debug.put_line('Check date tolerance');
4682: END IF;
4683:
4684: rcv_transactions_interface_sv.check_date_tolerance(NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date), -- Bug 487222
4685: x_shipmentdistributionrec.promised_date,
4686: x_shipmentdistributionrec.days_early_receipt_allowed,
4687: x_shipmentdistributionrec.days_late_receipt_allowed,
4688: x_shipmentdistributionrec.receipt_days_exception_code

Line 4819: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,

4815: END IF;
4816:
4817: -- Check shipto_location enforcement
4818:
4819: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,
4820: NVL(temp_cascaded_table(1).ship_to_location_id, x_header_record.header_record.location_id),
4821: x_shipmentdistributionrec.enforce_ship_to_location_code
4822: );
4823:

Line 5096: x_remaining_qty_po_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

5092: END IF;
5093: END IF;
5094:
5095: if ( l_complex_flag = 'Y' ) then --{
5096: x_remaining_qty_po_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
5097:
5098: temp_cascaded_table(1).unit_of_measure,
5099:
5100: temp_cascaded_table(1).item_id,

Line 5107: po_asn_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,

5103:
5104: );
5105: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
5106:
5107: po_asn_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
5108:
5109: x_shipmentdistributionrec.unit_meas_lookup_code,
5110:
5111: temp_cascaded_table(1).item_id,

Line 5116: po_primary_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,

5112:
5113: temp_cascaded_table(1).unit_of_measure
5114:
5115: );
5116: po_primary_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
5117:
5118: x_shipmentdistributionrec.unit_meas_lookup_code,
5119:
5120: temp_cascaded_table(1).item_id,

Line 5275: rcv_transactions_interface_sv.convert_into_correct_qty(

5271: * errors out. Reverting to old code for complex work POs.
5272: */
5273: if ( l_complex_flag = 'Y' ) then --{
5274: x_remaining_quantity :=
5275: rcv_transactions_interface_sv.convert_into_correct_qty(
5276: x_remaining_qty_po_uom,
5277: x_shipmentdistributionrec.unit_meas_lookup_code,
5278: temp_cascaded_table(1).item_id,
5279: temp_cascaded_table(1).unit_of_measure);

Line 5354: - rcv_transactions_interface_sv.convert_into_correct_qty

5350: */
5351: if ( l_complex_flag = 'Y' ) then --{
5352: temp_cascaded_table(current_n).vendor_cum_shipped_qty :=
5353: temp_cascaded_table(current_n).vendor_cum_shipped_qty
5354: - rcv_transactions_interface_sv.convert_into_correct_qty
5355: (x_bkp_qty,
5356: temp_cascaded_table(current_n).unit_of_measure,
5357: temp_cascaded_table(current_n).item_id,
5358: temp_cascaded_table(current_n).primary_unit_of_measure);

Line 5403: temp_cascaded_table(current_n).quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,

5399: * return the original quantity whereas the new one
5400: * errors out. Reverting to old code for complex work POs.
5401: */
5402: if ( l_complex_flag = 'Y' ) then --{
5403: temp_cascaded_table(current_n).quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,
5404:
5405: x_shipmentdistributionrec.unit_meas_lookup_code,
5406:
5407: temp_cascaded_table(current_n).item_id,

Line 5436: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,

5432: * return the original quantity whereas the new one
5433: * errors out. Reverting to old code for complex work POs.
5434: */
5435: if ( l_complex_flag = 'Y' ) then --{
5436: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,
5437: x_shipmentdistributionrec.unit_meas_lookup_code,
5438:
5439: temp_cascaded_table(current_n).item_id,
5440:

Line 5498: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN

5494: END IF;
5495: END IF; --}
5496:
5497: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
5498: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
5499: SELECT set_of_books_id
5500: INTO rcv_transactions_interface_sv.x_set_of_books_id
5501: FROM financials_system_parameters;
5502: END IF;

Line 5500: INTO rcv_transactions_interface_sv.x_set_of_books_id

5496:
5497: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
5498: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
5499: SELECT set_of_books_id
5500: INTO rcv_transactions_interface_sv.x_set_of_books_id
5501: FROM financials_system_parameters;
5502: END IF;
5503:
5504: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

Line 5504: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

5500: INTO rcv_transactions_interface_sv.x_set_of_books_id
5501: FROM financials_system_parameters;
5502: END IF;
5503:
5504: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;
5505: /* Bug 1845702
5506: * Currency rate and date can be changed at the time of receipt
5507: * depending on the profile ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE.
5508: * This was not handled in the open interface. Introduced code

Line 6849: rcv_transactions_interface_sv.check_date_tolerance(NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date), -- Bug 487222

6845: IF (g_asn_debug = 'Y') THEN
6846: asn_debug.put_line('Check date tolerance for a Fixed Price services line');
6847: END IF;
6848:
6849: rcv_transactions_interface_sv.check_date_tolerance(NVL(temp_cascaded_table(1).expected_receipt_date, x_header_record.header_record.expected_receipt_date), -- Bug 487222
6850: x_shipmentdistributionrec.promised_date,
6851: x_shipmentdistributionrec.days_early_receipt_allowed,
6852: x_shipmentdistributionrec.days_late_receipt_allowed,
6853: x_shipmentdistributionrec.receipt_days_exception_code

Line 6881: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,

6877: END IF;
6878:
6879: -- Check shipto_location enforcement
6880:
6881: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,
6882: NVL(temp_cascaded_table(1).ship_to_location_id, x_header_record.header_record.location_id),
6883: x_shipmentdistributionrec.enforce_ship_to_location_code
6884: );
6885:

Line 7118: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN

7114: END IF;
7115: END IF; --}
7116:
7117: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
7118: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
7119: SELECT set_of_books_id
7120: INTO rcv_transactions_interface_sv.x_set_of_books_id
7121: FROM financials_system_parameters;
7122: END IF;

Line 7120: INTO rcv_transactions_interface_sv.x_set_of_books_id

7116:
7117: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
7118: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
7119: SELECT set_of_books_id
7120: INTO rcv_transactions_interface_sv.x_set_of_books_id
7121: FROM financials_system_parameters;
7122: END IF;
7123:
7124: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

Line 7124: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

7120: INTO rcv_transactions_interface_sv.x_set_of_books_id
7121: FROM financials_system_parameters;
7122: END IF;
7123:
7124: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;
7125: /* Bug 1845702
7126: * Currency rate and date can be changed at the time of receipt
7127: * depending on the profile ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE.
7128: * This was not handled in the open interface. Introduced code

Line 7547: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);

7543:
7544: quantity_invoiced_record.quantity_invoiced := x_cascaded_table(n).quantity_invoiced;
7545: quantity_invoiced_record.error_record.error_status := 'S';
7546: quantity_invoiced_record.error_record.error_message := NULL;
7547: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);
7548: x_cascaded_table(n).error_status := quantity_invoiced_record.error_record.error_status;
7549: x_cascaded_table(n).error_message := quantity_invoiced_record.error_record.error_message;
7550: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7551: 'UNIT_OF_MEASURE',

Line 7586: rcv_transactions_interface_sv1.validate_uom(uom_record);

7582: IF (g_asn_debug = 'Y') THEN
7583: asn_debug.put_line('Validating UOM');
7584: END IF;
7585:
7586: rcv_transactions_interface_sv1.validate_uom(uom_record);
7587: x_cascaded_table(n).error_status := uom_record.error_record.error_status;
7588: x_cascaded_table(n).error_message := uom_record.error_record.error_message;
7589: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7590: 'UNIT_OF_MEASURE',

Line 7663: rcv_transactions_interface_sv1.validate_item_description(item_id_record);

7659: IF (g_asn_debug = 'Y') THEN
7660: asn_debug.put_line('Validating Item Description ' || x_cascaded_table(n).item_description);
7661: END IF;
7662:
7663: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
7664: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
7665: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
7666:
7667: IF (g_asn_debug = 'Y') THEN

Line 7742: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);

7738: IF (g_asn_debug = 'Y') THEN
7739: asn_debug.put_line('Validating Freight Carrier');
7740: END IF;
7741:
7742: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
7743: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
7744: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
7745: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7746: 'FREIGHT_CARRIER_CODE',

Line 7774: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

7770: IF (g_asn_debug = 'Y') THEN
7771: asn_debug.put_line('Validating Destination Type Code');
7772: END IF;
7773:
7774: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
7775: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
7776: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
7777: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7778: 'DESTINATION_TYPE_CODE',

Line 7823: rcv_transactions_interface_sv1.validate_location(location_record);

7819: IF (g_asn_debug = 'Y') THEN
7820: asn_debug.put_line('Validating Ship To Location');
7821: END IF;
7822:
7823: rcv_transactions_interface_sv1.validate_location(location_record);
7824: x_cascaded_table(n).error_status := location_record.error_record.error_status;
7825: x_cascaded_table(n).error_message := location_record.error_record.error_message;
7826: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7827: 'SHIP_TO_LOCATION_ID',

Line 7856: rcv_transactions_interface_sv1.validate_employee(employee_record);

7852: IF (g_asn_debug = 'Y') THEN
7853: asn_debug.put_line('Validating Deliver to Person');
7854: END IF;
7855:
7856: rcv_transactions_interface_sv1.validate_employee(employee_record);
7857:
7858: /* Bug:6375015
7859: If the deliver_to_person_id provided is invalid/terminated employee no need
7860: to fail the transaction, as deliver_to_person_id is not the mandatory field.

Line 8019: rcv_transactions_interface_sv1.validate_location(location_record);

8015: IF (g_asn_debug = 'Y') THEN
8016: asn_debug.put_line('Validating Deliver To Location');
8017: END IF;
8018:
8019: rcv_transactions_interface_sv1.validate_location(location_record);
8020: x_cascaded_table(n).error_status := location_record.error_record.error_status;
8021: x_cascaded_table(n).error_message := location_record.error_record.error_message;
8022: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
8023: 'DELIVER_TO_LOCATION_ID',

Line 8269: rcv_transactions_interface_sv1.validate_locator(locator_record);

8265: IF (g_asn_debug = 'Y') THEN
8266: asn_debug.put_line('Validating Locator');
8267: END IF;
8268:
8269: rcv_transactions_interface_sv1.validate_locator(locator_record);
8270: rcv_transactions_interface_sv1.validate_project_locator(locator_record); --Bug13844195
8271: x_cascaded_table(n).error_status := locator_record.error_record.error_status;
8272: x_cascaded_table(n).error_message := locator_record.error_record.error_message;
8273:

Line 8270: rcv_transactions_interface_sv1.validate_project_locator(locator_record); --Bug13844195

8266: asn_debug.put_line('Validating Locator');
8267: END IF;
8268:
8269: rcv_transactions_interface_sv1.validate_locator(locator_record);
8270: rcv_transactions_interface_sv1.validate_project_locator(locator_record); --Bug13844195
8271: x_cascaded_table(n).error_status := locator_record.error_record.error_status;
8272: x_cascaded_table(n).error_message := locator_record.error_record.error_message;
8273:
8274: -- Bug 13817635 added

Line 8283: * then the rcv_transactions_interface_sv1.validate_locator procedure nulls out the locator_id.

8279: -- Bug 13817635 ended
8280:
8281: /* Bug 5468345.
8282: * If the user has specified locator_id or locator_num and org/sub/item is not under locator control,
8283: * then the rcv_transactions_interface_sv1.validate_locator procedure nulls out the locator_id.
8284: * We need to copy this back to the x_cascaded_table. This used to cause data corruption.
8285: * Changed the code to null it.
8286: */
8287:

Line 8377: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);

8373: IF (g_asn_debug = 'Y') THEN
8374: asn_debug.put_line('Validating Tax Code');
8375: END IF;
8376:
8377: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);
8378: x_cascaded_table(n).error_status := tax_name_record.error_record.error_status;
8379: x_cascaded_table(n).error_message := tax_name_record.error_record.error_message;
8380: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
8381: 'TAX_NAME',

Line 8408: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);

8404: IF (g_asn_debug = 'Y') THEN
8405: asn_debug.put_line('Validating Country of Origin Code');
8406: END IF;
8407:
8408: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
8409: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
8410: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
8411: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
8412: 'COUNTRY_OF_ORIGIN_CODE',

Line 8440: rcv_transactions_interface_sv1.validate_asl(asl_record);

8436: IF (g_asn_debug = 'Y') THEN
8437: asn_debug.put_line('Validating ASL');
8438: END IF;
8439:
8440: rcv_transactions_interface_sv1.validate_asl(asl_record);
8441: x_cascaded_table(n).error_status := asl_record.error_record.error_status;
8442: x_cascaded_table(n).error_message := asl_record.error_record.error_message;
8443: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
8444: 'SUPPLY_AGREEMENT_FLAG',

Line 8477: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);

8473: IF (g_asn_debug = 'Y') THEN
8474: asn_debug.put_line('Validating Cum Qty Shipped');
8475: END IF;
8476:
8477: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);
8478: x_cascaded_table(n).error_status := cum_quantity_record.error_record.error_status;
8479: x_cascaded_table(n).error_message := cum_quantity_record.error_record.error_message;
8480: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
8481: 'VENDOR_CUM_SHIPPED_QTY',

Line 8552: -- rcv_transactions_interface_sv1.validate_ref_integ (ref_integrity_record,X_header_record);

8548: /* End of 3210821. */
8549: ref_integrity_record.error_record.error_status := 'S';
8550: ref_integrity_record.error_record.error_message := NULL;
8551: --replacing call with a validate_ref_integ call with the method in thid package
8552: -- rcv_transactions_interface_sv1.validate_ref_integ (ref_integrity_record,X_header_record);
8553: validate_ref_integ(ref_integrity_record, x_header_record);
8554:
8555: IF (g_asn_debug = 'Y') THEN
8556: asn_debug.put_line('After Validating Ref Integ: ' || ref_integrity_record.error_record.error_status);

Line 8772: prim_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(x_cascaded_table(n).quantity,

8768: asn_debug.put_line('Primary UOM for substitute item is ' || x_primary_uom);
8769: END IF;
8770:
8771: IF x_primary_uom <> x_cascaded_table(n).primary_unit_of_measure THEN --{
8772: prim_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(x_cascaded_table(n).quantity,
8773: x_cascaded_table(n).unit_of_measure,
8774: x_cascaded_table(n).item_id,
8775: x_primary_uom
8776: );

Line 8851: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);

8847: IF (g_asn_debug = 'Y') THEN
8848: asn_debug.put_line('Validating ASBN for Consigned PO');
8849: END IF;
8850:
8851: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);
8852:
8853: IF (g_asn_debug = 'Y') THEN
8854: asn_debug.put_line('After Validating ASBN for Consigned PO');
8855: END IF;

Line 8881: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);

8877: IF (g_asn_debug = 'Y') THEN
8878: asn_debug.put_line('Validating Consumption PO');
8879: END IF;
8880:
8881: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);
8882:
8883: IF (g_asn_debug = 'Y') THEN
8884: asn_debug.put_line('After Validating Consumption PO');
8885: END IF;

Line 8910: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);

8906: IF (g_asn_debug = 'Y') THEN
8907: asn_debug.put_line('Validating Consumption Release');
8908: END IF;
8909:
8910: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);
8911:
8912: IF (g_asn_debug = 'Y') THEN
8913: asn_debug.put_line('After Validating Consumption Release');
8914: END IF;

Line 13853: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

13849: END IF;
13850:
13851: temp_cascaded_table(current_n).quantity := temp_cascaded_table(current_n).quantity + x_remaining_quantity;
13852: temp_cascaded_table(current_n).primary_quantity := temp_cascaded_table(current_n).primary_quantity
13853: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
13854: temp_cascaded_table(1).unit_of_measure,
13855: temp_cascaded_table(1).item_id,
13856: temp_cascaded_table(1).primary_unit_of_measure
13857: );

Line 15999: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

15995: IF (g_asn_debug = 'Y') THEN
15996: asn_debug.put_line('Validating Source Type Code');
15997: END IF;
15998:
15999: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
16000: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
16001: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
16002: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
16003: 'SOURCE_TYPE_CODE',

Line 16035: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

16031: IF (g_asn_debug = 'Y') THEN
16032: asn_debug.put_line('Validating Destination Type Code');
16033: END IF;
16034:
16035: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
16036: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
16037: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
16038: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
16039: 'TRANSACTION_TYPE_CODE',

Line 16071: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

16067: IF (g_asn_debug = 'Y') THEN
16068: asn_debug.put_line('Validating INSPECTION STATUS ');
16069: END IF;
16070:
16071: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
16072: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
16073: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
16074: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
16075: 'INSPECTION_STATUS_CODE',

Line 16097: l_att_rec RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type;

16093: ) IS
16094: /*INVCONV, gml_opm_roi_grp.opm_record_type to be removed , Punit Kumar */
16095: --l_opm_record_type gml_opm_roi_grp.opm_record_type;
16096:
16097: l_att_rec RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type;
16098: l_column_name VARCHAR2(50);
16099: l_tokenname1 VARCHAR2(30);
16100: l_tokenvalue1 VARCHAR2(1800);
16101: l_quantity_shipped NUMBER;

Line 16244: asn_debug.put_line('printing the values before calling RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');

16240: l_transaction_id :=x_cascaded_table(n).interface_transaction_id; /*BUG#10380635 */
16241:
16242:
16243: IF (g_asn_debug = 'Y') THEN
16244: asn_debug.put_line('printing the values before calling RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16245: asn_debug.put_line('unit_of_measure = ' || l_att_rec.transaction_unit_of_measure);
16246: asn_debug.put_line('secondary unit_of_measure = ' || l_att_rec.secondary_unit_of_measure);
16247: asn_debug.put_line('Quantity = ' || l_att_rec.transaction_quantity);
16248: asn_debug.put_line('Secondary Quantity = ' || l_att_rec.secondary_quantity);

Line 16274: asn_debug.put_line('Before calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');

16270:
16271: IF x_cascaded_table(n).item_id IS NOT NULL THEN
16272:
16273: IF (g_asn_debug = 'Y') THEN
16274: asn_debug.put_line('Before calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16275: END IF;
16276:
16277:
16278: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (

Line 16278: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (

16274: asn_debug.put_line('Before calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16275: END IF;
16276:
16277:
16278: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (
16279: 1.0,
16280: 'F',
16281: x_att_rec =>l_att_rec,
16282: x_return_status =>l_return_status,

Line 16307: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');

16303: x_cascaded_table(n).error_status := l_att_rec.error_record.error_status;
16304: x_cascaded_table(n).error_message := l_att_rec.error_record.error_message;
16305:
16306: IF (g_asn_debug = 'Y') THEN
16307: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16308: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
16309: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
16310: END IF;
16311:

Line 16308: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);

16304: x_cascaded_table(n).error_message := l_att_rec.error_record.error_message;
16305:
16306: IF (g_asn_debug = 'Y') THEN
16307: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16308: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
16309: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
16310: END IF;
16311:
16312:

Line 16309: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);

16305:
16306: IF (g_asn_debug = 'Y') THEN
16307: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16308: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
16309: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
16310: END IF;
16311:
16312:
16313: /*If call fails*/

Line 16316: asn_debug.put_line('RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS call failed');

16312:
16313: /*If call fails*/
16314: IF x_cascaded_table(n).error_status IN ('U' ,'E') THEN
16315: IF (g_asn_debug = 'Y') THEN
16316: asn_debug.put_line('RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS call failed');
16317: END IF;
16318:
16319: /*log error in po_interface_errors*/
16320: rcv_error_pkg.log_interface_message(

Line 16334: asn_debug.put_line('populating the return values from RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');

16330: x_cascaded_table(n).secondary_uom_code := l_att_rec.secondary_uom_code;
16331: x_cascaded_table(n).secondary_quantity := l_att_rec.secondary_quantity;
16332:
16333: IF (g_asn_debug = 'Y') THEN
16334: asn_debug.put_line('populating the return values from RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
16335: asn_debug.put_line('secondary unit_of_measure = ' || x_cascaded_table(n).secondary_unit_of_measure);
16336: asn_debug.put_line('Secondary Quantity = ' ||x_cascaded_table(n).secondary_quantity );
16337: asn_debug.put_line('Secondary_uom_code = ' ||x_cascaded_table(n).secondary_uom_code);
16338: END IF;