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 529: rcv_transactions_interface_sv.default_item_revision(item_id_record);

525: item_id_record.to_organization_id := x_cascaded_table(n).to_organization_id;
526: item_id_record.item_revision := x_cascaded_table(n).item_revision;
527: item_id_record.error_record.error_status := 'S';
528: item_id_record.error_record.error_message := NULL;
529: rcv_transactions_interface_sv.default_item_revision(item_id_record);
530: x_cascaded_table(n).item_revision := item_id_record.item_revision;
531:
532: IF (g_asn_debug = 'Y') THEN
533: asn_debug.put_line(NVL(item_id_record.item_revision, 'Item Revision is null'));

Line 1317: rcv_transactions_interface_sv.get_po_header_id(document_num_record);

1313: IF (g_asn_debug = 'Y') THEN
1314: asn_debug.put_line('Derive po_header_id');
1315: END IF;
1316:
1317: rcv_transactions_interface_sv.get_po_header_id(document_num_record);
1318: x_cascaded_table(n).po_header_id := document_num_record.po_header_id;
1319: x_cascaded_table(n).error_status := document_num_record.error_record.error_status;
1320: x_cascaded_table(n).error_message := document_num_record.error_record.error_message;
1321: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1398: rcv_transactions_interface_sv.get_item_id(item_id_record);

1394: IF (g_asn_debug = 'Y') THEN
1395: asn_debug.put_line('Derive item_id');
1396: END IF;
1397:
1398: rcv_transactions_interface_sv.get_item_id(item_id_record);
1399: x_cascaded_table(n).item_id := item_id_record.item_id;
1400: x_cascaded_table(n).primary_unit_of_measure := item_id_record.primary_unit_of_measure;
1401: x_cascaded_table(n).use_mtl_lot := item_id_record.use_mtl_lot; -- bug 608353
1402: x_cascaded_table(n).use_mtl_serial := item_id_record.use_mtl_serial; -- bug 608353

Line 1441: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);

1437: IF (g_asn_debug = 'Y') THEN
1438: asn_debug.put_line('Derive Substitute Item Id');
1439: END IF;
1440:
1441: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);
1442: x_cascaded_table(n).substitute_item_id := sub_item_id_record.substitute_item_id;
1443: x_cascaded_table(n).error_status := sub_item_id_record.error_record.error_status;
1444: x_cascaded_table(n).error_message := sub_item_id_record.error_record.error_message;
1445:

Line 1489: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);

1485: IF (g_asn_debug = 'Y') THEN
1486: asn_debug.put_line('Derive po_line_id');
1487: END IF;
1488:
1489: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);
1490:
1491: IF x_cascaded_table(n).item_id IS NULL THEN
1492: x_cascaded_table(n).item_id := po_line_id_record.item_id;
1493: END IF;

Line 1871: rcv_transactions_interface_sv.get_location_id(location_id_record);

1867: IF (g_asn_debug = 'Y') THEN
1868: asn_debug.put_line('Derive location_id');
1869: END IF;
1870:
1871: rcv_transactions_interface_sv.get_location_id(location_id_record);
1872: x_cascaded_table(n).location_id := location_id_record.location_id;
1873: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
1874: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
1875: END IF;

Line 1899: rcv_transactions_interface_sv.get_location_id(location_id_record);

1895: IF (g_asn_debug = 'Y') THEN
1896: asn_debug.put_line('Derive ship to location_id');
1897: END IF;
1898:
1899: rcv_transactions_interface_sv.get_location_id(location_id_record);
1900: x_cascaded_table(n).ship_to_location_id := location_id_record.location_id;
1901: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
1902: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
1903: END IF;

Line 1927: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);

1923: IF (g_asn_debug = 'Y') THEN
1924: asn_debug.put_line('Derive routing_header_id');
1925: END IF;
1926:
1927: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);
1928: x_cascaded_table(n).routing_header_id := routing_header_id_record.routing_header_id;
1929: x_cascaded_table(n).error_status := routing_header_id_record.error_record.error_status;
1930: x_cascaded_table(n).error_message := routing_header_id_record.error_record.error_message;
1931: END IF;

Line 1955: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);

1951: IF (g_asn_debug = 'Y') THEN
1952: asn_debug.put_line('Derive routing Step Id');
1953: END IF;
1954:
1955: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);
1956: x_cascaded_table(n).routing_step_id := routing_step_id_record.routing_step_id;
1957: x_cascaded_table(n).error_status := routing_step_id_record.error_record.error_status;
1958: x_cascaded_table(n).error_message := routing_step_id_record.error_record.error_message;
1959: END IF;

Line 2027: rcv_transactions_interface_sv.get_location_id(location_id_record);

2023: IF (g_asn_debug = 'Y') THEN
2024: asn_debug.put_line('Derive deliver_to_location_id');
2025: END IF;
2026:
2027: rcv_transactions_interface_sv.get_location_id(location_id_record);
2028: x_cascaded_table(n).deliver_to_location_id := location_id_record.location_id;
2029: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
2030: x_cascaded_table(n).error_message := location_id_record.error_record.error_message;
2031: END IF;

Line 2546: rcv_transactions_interface_sv.get_reason_id(reason_id_record);

2542: IF (g_asn_debug = 'Y') THEN
2543: asn_debug.put_line('Derive Reason_id');
2544: END IF;
2545:
2546: rcv_transactions_interface_sv.get_reason_id(reason_id_record);
2547: x_cascaded_table(n).reason_id := reason_id_record.reason_id;
2548: x_cascaded_table(n).error_status := reason_id_record.error_record.error_status;
2549: x_cascaded_table(n).error_message := reason_id_record.error_record.error_message;
2550: END IF;

Line 3592: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

3588: temp_cascaded_table(current_n).quantity := temp_cascaded_table(current_n).quantity + x_remaining_quantity;
3589: temp_cascaded_table(current_n).quantity_shipped := temp_cascaded_table(current_n).quantity_shipped + x_remaining_quantity;
3590: temp_cascaded_table(current_n).source_doc_quantity := temp_cascaded_table(current_n).source_doc_quantity + x_remaining_qty_po_uom;
3591: temp_cascaded_table(current_n).primary_quantity := temp_cascaded_table(current_n).primary_quantity
3592: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
3593: temp_cascaded_table(1).unit_of_measure,
3594: temp_cascaded_table(1).item_id,
3595: temp_cascaded_table(1).primary_unit_of_measure
3596: );

Line 4154: 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

4150: asn_debug.put_line('Cursor record ' || TO_CHAR(rows_fetched));
4151: asn_debug.put_line('Check date tolerance');
4152: END IF;
4153:
4154: 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
4155: x_shipmentdistributionrec.promised_date,
4156: x_shipmentdistributionrec.days_early_receipt_allowed,
4157: x_shipmentdistributionrec.days_late_receipt_allowed,
4158: x_shipmentdistributionrec.receipt_days_exception_code

Line 4259: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,

4255: END IF;
4256:
4257: -- Check shipto_location enforcement
4258:
4259: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,
4260: NVL(temp_cascaded_table(1).ship_to_location_id, x_header_record.header_record.location_id),
4261: x_shipmentdistributionrec.enforce_ship_to_location_code
4262: );
4263:

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

4532: END IF;
4533: END IF;
4534:
4535: if ( l_complex_flag = 'Y' ) then --{
4536: x_remaining_qty_po_uom := rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
4537:
4538: temp_cascaded_table(1).unit_of_measure,
4539:
4540: temp_cascaded_table(1).item_id,

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

4543:
4544: );
4545: -- using arbit qty for PO->ASN, PO->PRIMARY UOM conversion as this is just a check
4546:
4547: po_asn_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
4548:
4549: x_shipmentdistributionrec.unit_meas_lookup_code,
4550:
4551: temp_cascaded_table(1).item_id,

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

4552:
4553: temp_cascaded_table(1).unit_of_measure
4554:
4555: );
4556: po_primary_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(1000,
4557:
4558: x_shipmentdistributionrec.unit_meas_lookup_code,
4559:
4560: temp_cascaded_table(1).item_id,

Line 4663: rcv_transactions_interface_sv.convert_into_correct_qty(

4659: * errors out. Reverting to old code for complex work POs.
4660: */
4661: if ( l_complex_flag = 'Y' ) then --{
4662: x_remaining_quantity :=
4663: rcv_transactions_interface_sv.convert_into_correct_qty(
4664: x_remaining_qty_po_uom,
4665: x_shipmentdistributionrec.unit_meas_lookup_code,
4666: temp_cascaded_table(1).item_id,
4667: temp_cascaded_table(1).unit_of_measure);

Line 4742: - rcv_transactions_interface_sv.convert_into_correct_qty

4738: */
4739: if ( l_complex_flag = 'Y' ) then --{
4740: temp_cascaded_table(current_n).vendor_cum_shipped_qty :=
4741: temp_cascaded_table(current_n).vendor_cum_shipped_qty
4742: - rcv_transactions_interface_sv.convert_into_correct_qty
4743: (x_bkp_qty,
4744: temp_cascaded_table(current_n).unit_of_measure,
4745: temp_cascaded_table(current_n).item_id,
4746: temp_cascaded_table(current_n).primary_unit_of_measure);

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

4787: * return the original quantity whereas the new one
4788: * errors out. Reverting to old code for complex work POs.
4789: */
4790: if ( l_complex_flag = 'Y' ) then --{
4791: temp_cascaded_table(current_n).quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,
4792:
4793: x_shipmentdistributionrec.unit_meas_lookup_code,
4794:
4795: temp_cascaded_table(current_n).item_id,

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

4818: * return the original quantity whereas the new one
4819: * errors out. Reverting to old code for complex work POs.
4820: */
4821: if ( l_complex_flag = 'Y' ) then --{
4822: temp_cascaded_table(current_n).primary_quantity := rcv_transactions_interface_sv.convert_into_correct_qty(x_converted_trx_qty,
4823: x_shipmentdistributionrec.unit_meas_lookup_code,
4824:
4825: temp_cascaded_table(current_n).item_id,
4826:

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

4878: END IF;
4879: END IF; --}
4880:
4881: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
4882: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
4883: SELECT set_of_books_id
4884: INTO rcv_transactions_interface_sv.x_set_of_books_id
4885: FROM financials_system_parameters;
4886: END IF;

Line 4884: INTO rcv_transactions_interface_sv.x_set_of_books_id

4880:
4881: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
4882: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
4883: SELECT set_of_books_id
4884: INTO rcv_transactions_interface_sv.x_set_of_books_id
4885: FROM financials_system_parameters;
4886: END IF;
4887:
4888: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

Line 4888: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

4884: INTO rcv_transactions_interface_sv.x_set_of_books_id
4885: FROM financials_system_parameters;
4886: END IF;
4887:
4888: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;
4889: /* Bug 1845702
4890: * Currency rate and date can be changed at the time of receipt
4891: * depending on the profile ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE.
4892: * This was not handled in the open interface. Introduced code

Line 6171: 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

6167: IF (g_asn_debug = 'Y') THEN
6168: asn_debug.put_line('Check date tolerance for a Fixed Price services line');
6169: END IF;
6170:
6171: 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
6172: x_shipmentdistributionrec.promised_date,
6173: x_shipmentdistributionrec.days_early_receipt_allowed,
6174: x_shipmentdistributionrec.days_late_receipt_allowed,
6175: x_shipmentdistributionrec.receipt_days_exception_code

Line 6203: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,

6199: END IF;
6200:
6201: -- Check shipto_location enforcement
6202:
6203: rcv_transactions_interface_sv.check_shipto_enforcement(x_shipmentdistributionrec.ship_to_location_id,
6204: NVL(temp_cascaded_table(1).ship_to_location_id, x_header_record.header_record.location_id),
6205: x_shipmentdistributionrec.enforce_ship_to_location_code
6206: );
6207:

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

6436: END IF;
6437: END IF; --}
6438:
6439: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
6440: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
6441: SELECT set_of_books_id
6442: INTO rcv_transactions_interface_sv.x_set_of_books_id
6443: FROM financials_system_parameters;
6444: END IF;

Line 6442: INTO rcv_transactions_interface_sv.x_set_of_books_id

6438:
6439: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
6440: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
6441: SELECT set_of_books_id
6442: INTO rcv_transactions_interface_sv.x_set_of_books_id
6443: FROM financials_system_parameters;
6444: END IF;
6445:
6446: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

Line 6446: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

6442: INTO rcv_transactions_interface_sv.x_set_of_books_id
6443: FROM financials_system_parameters;
6444: END IF;
6445:
6446: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;
6447: /* Bug 1845702
6448: * Currency rate and date can be changed at the time of receipt
6449: * depending on the profile ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE.
6450: * This was not handled in the open interface. Introduced code

Line 6794: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);

6790:
6791: quantity_invoiced_record.quantity_invoiced := x_cascaded_table(n).quantity_invoiced;
6792: quantity_invoiced_record.error_record.error_status := 'S';
6793: quantity_invoiced_record.error_record.error_message := NULL;
6794: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);
6795: x_cascaded_table(n).error_status := quantity_invoiced_record.error_record.error_status;
6796: x_cascaded_table(n).error_message := quantity_invoiced_record.error_record.error_message;
6797: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
6798: 'UNIT_OF_MEASURE',

Line 6833: rcv_transactions_interface_sv1.validate_uom(uom_record);

6829: IF (g_asn_debug = 'Y') THEN
6830: asn_debug.put_line('Validating UOM');
6831: END IF;
6832:
6833: rcv_transactions_interface_sv1.validate_uom(uom_record);
6834: x_cascaded_table(n).error_status := uom_record.error_record.error_status;
6835: x_cascaded_table(n).error_message := uom_record.error_record.error_message;
6836: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
6837: 'UNIT_OF_MEASURE',

Line 6910: rcv_transactions_interface_sv1.validate_item_description(item_id_record);

6906: IF (g_asn_debug = 'Y') THEN
6907: asn_debug.put_line('Validating Item Description ' || x_cascaded_table(n).item_description);
6908: END IF;
6909:
6910: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
6911: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
6912: x_cascaded_table(n).error_message := item_id_record.error_record.error_message;
6913:
6914: IF (g_asn_debug = 'Y') THEN

Line 6960: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);

6956: IF (g_asn_debug = 'Y') THEN
6957: asn_debug.put_line('Validating Freight Carrier');
6958: END IF;
6959:
6960: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
6961: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
6962: x_cascaded_table(n).error_message := freight_carrier_record.error_record.error_message;
6963: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
6964: 'FREIGHT_CARRIER_CODE',

Line 6992: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

6988: IF (g_asn_debug = 'Y') THEN
6989: asn_debug.put_line('Validating Destination Type Code');
6990: END IF;
6991:
6992: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
6993: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
6994: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
6995: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
6996: 'DESTINATION_TYPE_CODE',

Line 7026: rcv_transactions_interface_sv1.validate_location(location_record);

7022: IF (g_asn_debug = 'Y') THEN
7023: asn_debug.put_line('Validating Ship To Location');
7024: END IF;
7025:
7026: rcv_transactions_interface_sv1.validate_location(location_record);
7027: x_cascaded_table(n).error_status := location_record.error_record.error_status;
7028: x_cascaded_table(n).error_message := location_record.error_record.error_message;
7029: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7030: 'SHIP_TO_LOCATION_ID',

Line 7059: rcv_transactions_interface_sv1.validate_employee(employee_record);

7055: IF (g_asn_debug = 'Y') THEN
7056: asn_debug.put_line('Validating Deliver to Person');
7057: END IF;
7058:
7059: rcv_transactions_interface_sv1.validate_employee(employee_record);
7060:
7061: /* Bug:6375015
7062: If the deliver_to_person_id provided is invalid/terminated employee no need
7063: to fail the transaction, as deliver_to_person_id is not the mandatory field.

Line 7177: rcv_transactions_interface_sv1.validate_location(location_record);

7173: IF (g_asn_debug = 'Y') THEN
7174: asn_debug.put_line('Validating Deliver To Location');
7175: END IF;
7176:
7177: rcv_transactions_interface_sv1.validate_location(location_record);
7178: x_cascaded_table(n).error_status := location_record.error_record.error_status;
7179: x_cascaded_table(n).error_message := location_record.error_record.error_message;
7180: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7181: 'DELIVER_TO_LOCATION_ID',

Line 7373: rcv_transactions_interface_sv1.validate_locator(locator_record);

7369: IF (g_asn_debug = 'Y') THEN
7370: asn_debug.put_line('Validating Locator');
7371: END IF;
7372:
7373: rcv_transactions_interface_sv1.validate_locator(locator_record);
7374: x_cascaded_table(n).error_status := locator_record.error_record.error_status;
7375: x_cascaded_table(n).error_message := locator_record.error_record.error_message;
7376:
7377: /* Bug 5468345.

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

7375: x_cascaded_table(n).error_message := locator_record.error_record.error_message;
7376:
7377: /* Bug 5468345.
7378: * If the user has specified locator_id or locator_num and org/sub/item is not under locator control,
7379: * then the rcv_transactions_interface_sv1.validate_locator procedure nulls out the locator_id.
7380: * We need to copy this back to the x_cascaded_table. This used to cause data corruption.
7381: * Changed the code to null it.
7382: */
7383:

Line 7434: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);

7430: IF (g_asn_debug = 'Y') THEN
7431: asn_debug.put_line('Validating Tax Code');
7432: END IF;
7433:
7434: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);
7435: x_cascaded_table(n).error_status := tax_name_record.error_record.error_status;
7436: x_cascaded_table(n).error_message := tax_name_record.error_record.error_message;
7437: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7438: 'TAX_NAME',

Line 7465: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);

7461: IF (g_asn_debug = 'Y') THEN
7462: asn_debug.put_line('Validating Country of Origin Code');
7463: END IF;
7464:
7465: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
7466: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
7467: x_cascaded_table(n).error_message := country_of_origin_record.error_record.error_message;
7468: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7469: 'COUNTRY_OF_ORIGIN_CODE',

Line 7497: rcv_transactions_interface_sv1.validate_asl(asl_record);

7493: IF (g_asn_debug = 'Y') THEN
7494: asn_debug.put_line('Validating ASL');
7495: END IF;
7496:
7497: rcv_transactions_interface_sv1.validate_asl(asl_record);
7498: x_cascaded_table(n).error_status := asl_record.error_record.error_status;
7499: x_cascaded_table(n).error_message := asl_record.error_record.error_message;
7500: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7501: 'SUPPLY_AGREEMENT_FLAG',

Line 7534: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);

7530: IF (g_asn_debug = 'Y') THEN
7531: asn_debug.put_line('Validating Cum Qty Shipped');
7532: END IF;
7533:
7534: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);
7535: x_cascaded_table(n).error_status := cum_quantity_record.error_record.error_status;
7536: x_cascaded_table(n).error_message := cum_quantity_record.error_record.error_message;
7537: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
7538: 'VENDOR_CUM_SHIPPED_QTY',

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

7605: /* End of 3210821. */
7606: ref_integrity_record.error_record.error_status := 'S';
7607: ref_integrity_record.error_record.error_message := NULL;
7608: --replacing call with a validate_ref_integ call with the method in thid package
7609: -- rcv_transactions_interface_sv1.validate_ref_integ (ref_integrity_record,X_header_record);
7610: validate_ref_integ(ref_integrity_record, x_header_record);
7611:
7612: IF (g_asn_debug = 'Y') THEN
7613: asn_debug.put_line('After Validating Ref Integ: ' || ref_integrity_record.error_record.error_status);

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

7825: asn_debug.put_line('Primary UOM for substitute item is ' || x_primary_uom);
7826: END IF;
7827:
7828: IF x_primary_uom <> x_cascaded_table(n).primary_unit_of_measure THEN --{
7829: prim_uom_qty := rcv_transactions_interface_sv.convert_into_correct_qty(x_cascaded_table(n).quantity,
7830: x_cascaded_table(n).unit_of_measure,
7831: x_cascaded_table(n).item_id,
7832: x_primary_uom
7833: );

Line 7908: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);

7904: IF (g_asn_debug = 'Y') THEN
7905: asn_debug.put_line('Validating ASBN for Consigned PO');
7906: END IF;
7907:
7908: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);
7909:
7910: IF (g_asn_debug = 'Y') THEN
7911: asn_debug.put_line('After Validating ASBN for Consigned PO');
7912: END IF;

Line 7938: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);

7934: IF (g_asn_debug = 'Y') THEN
7935: asn_debug.put_line('Validating Consumption PO');
7936: END IF;
7937:
7938: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);
7939:
7940: IF (g_asn_debug = 'Y') THEN
7941: asn_debug.put_line('After Validating Consumption PO');
7942: END IF;

Line 7967: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);

7963: IF (g_asn_debug = 'Y') THEN
7964: asn_debug.put_line('Validating Consumption Release');
7965: END IF;
7966:
7967: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);
7968:
7969: IF (g_asn_debug = 'Y') THEN
7970: asn_debug.put_line('After Validating Consumption Release');
7971: END IF;

Line 12513: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,

12509: END IF;
12510:
12511: temp_cascaded_table(current_n).quantity := temp_cascaded_table(current_n).quantity + x_remaining_quantity;
12512: temp_cascaded_table(current_n).primary_quantity := temp_cascaded_table(current_n).primary_quantity
12513: + rcv_transactions_interface_sv.convert_into_correct_qty(x_remaining_quantity,
12514: temp_cascaded_table(1).unit_of_measure,
12515: temp_cascaded_table(1).item_id,
12516: temp_cascaded_table(1).primary_unit_of_measure
12517: );

Line 14584: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

14580: IF (g_asn_debug = 'Y') THEN
14581: asn_debug.put_line('Validating Source Type Code');
14582: END IF;
14583:
14584: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
14585: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
14586: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
14587: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
14588: 'SOURCE_TYPE_CODE',

Line 14620: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

14616: IF (g_asn_debug = 'Y') THEN
14617: asn_debug.put_line('Validating Destination Type Code');
14618: END IF;
14619:
14620: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
14621: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
14622: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
14623: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
14624: 'TRANSACTION_TYPE_CODE',

Line 14656: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

14652: IF (g_asn_debug = 'Y') THEN
14653: asn_debug.put_line('Validating INSPECTION STATUS ');
14654: END IF;
14655:
14656: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
14657: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
14658: x_cascaded_table(n).error_message := po_lookup_code_record.error_record.error_message;
14659: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
14660: 'INSPECTION_STATUS_CODE',

Line 14682: l_att_rec RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type;

14678: ) IS
14679: /*INVCONV, gml_opm_roi_grp.opm_record_type to be removed , Punit Kumar */
14680: --l_opm_record_type gml_opm_roi_grp.opm_record_type;
14681:
14682: l_att_rec RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type;
14683: l_column_name VARCHAR2(50);
14684: l_tokenname1 VARCHAR2(30);
14685: l_tokenvalue1 VARCHAR2(1800);
14686: l_quantity_shipped NUMBER;

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

14823: l_att_rec.error_record.error_message := NULL;
14824:
14825:
14826: IF (g_asn_debug = 'Y') THEN
14827: asn_debug.put_line('printing the values before calling RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14828: asn_debug.put_line('unit_of_measure = ' || l_att_rec.transaction_unit_of_measure);
14829: asn_debug.put_line('secondary unit_of_measure = ' || l_att_rec.secondary_unit_of_measure);
14830: asn_debug.put_line('Quantity = ' || l_att_rec.transaction_quantity);
14831: asn_debug.put_line('Secondary Quantity = ' || l_att_rec.secondary_quantity);

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

14852:
14853: IF x_cascaded_table(n).item_id IS NOT NULL THEN
14854:
14855: IF (g_asn_debug = 'Y') THEN
14856: asn_debug.put_line('Before calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14857: END IF;
14858:
14859:
14860: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (

Line 14860: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (

14856: asn_debug.put_line('Before calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14857: END IF;
14858:
14859:
14860: RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS (
14861: 1.0,
14862: 'F',
14863: x_att_rec =>l_att_rec,
14864: x_return_status =>l_return_status,

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

14884: x_cascaded_table(n).error_status := l_att_rec.error_record.error_status;
14885: x_cascaded_table(n).error_message := l_att_rec.error_record.error_message;
14886:
14887: IF (g_asn_debug = 'Y') THEN
14888: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14889: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
14890: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
14891: END IF;
14892:

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

14885: x_cascaded_table(n).error_message := l_att_rec.error_record.error_message;
14886:
14887: IF (g_asn_debug = 'Y') THEN
14888: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14889: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
14890: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
14891: END IF;
14892:
14893:

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

14886:
14887: IF (g_asn_debug = 'Y') THEN
14888: asn_debug.put_line('After calling new API RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14889: asn_debug.put_line('return status of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_status);
14890: asn_debug.put_line('return message of RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS = ' || x_cascaded_table(n).error_message);
14891: END IF;
14892:
14893:
14894: /*If call fails*/

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

14893:
14894: /*If call fails*/
14895: IF x_cascaded_table(n).error_status IN ('U' ,'E') THEN
14896: IF (g_asn_debug = 'Y') THEN
14897: asn_debug.put_line('RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS call failed');
14898: END IF;
14899:
14900: /*log error in po_interface_errors*/
14901: rcv_error_pkg.log_interface_message(

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

14911: x_cascaded_table(n).secondary_uom_code := l_att_rec.secondary_uom_code;
14912: x_cascaded_table(n).secondary_quantity := l_att_rec.secondary_quantity;
14913:
14914: IF (g_asn_debug = 'Y') THEN
14915: asn_debug.put_line('populating the return values from RCV_TRANSACTIONS_INTERFACE_SV1.VALIDATE_SECONDARY_PARAMETERS');
14916: asn_debug.put_line('secondary unit_of_measure = ' || x_cascaded_table(n).secondary_unit_of_measure);
14917: asn_debug.put_line('Secondary Quantity = ' ||x_cascaded_table(n).secondary_quantity );
14918: asn_debug.put_line('Secondary_uom_code = ' ||x_cascaded_table(n).secondary_uom_code);
14919: END IF;