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_SV1

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 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 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;