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