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.

[Home] [Help]

APPS.RCV_ROI_HEADER_COMMON dependencies on RCV_HEADERS_INTERFACE

Line 641: rcv_headers_interface */

637: FROM rcv_parameters
638: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
639:
640: /* assuming that the ship_to_organization_id is populated at the header level of
641: rcv_headers_interface */
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line(v_rcv_type || ' Generation ');
644: END IF;
645:

Line 812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');

808: IF (lookup_record.error_record.error_status <> 'S') THEN
809: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
810: rcv_error_pkg.set_error_message('RCV_TRX_TYPE_INVALID', p_header_record.error_record.error_message);
811: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;
814:
815: IF (g_asn_debug = 'Y') THEN
816: asn_debug.put_line('validated transaction type');

Line 842: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');

838: IF (p_header_record.header_record.expected_receipt_date IS NULL and
839: p_header_record.header_record.asn_type <> 'WC') THEN
840: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
841: rcv_error_pkg.set_error_message('RCV_ASN_EXPECTED_RECEIPT_DATE', p_header_record.error_record.error_message);
842: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
843: END IF;
844: END IF;
845:
846: IF (g_asn_debug = 'Y') THEN

Line 878: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');

874: * we need to set this error in po_interface_errors.
875: */
876: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
877: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
878: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
879: END IF;
880:
881: /* Bug 12719212
882: * get the value if the shipment is new shipment (has not been received),

Line 933: FROM rcv_headers_interface rhi

929: and throw an exception when there are Duplicate Records in RHI with the same combination.*/
930: IF x_count = 0 THEN
931: SELECT Count(*)
932: INTO x_rhi_count
933: FROM rcv_headers_interface rhi
934: WHERE rhi.receipt_num = p_header_record.header_record.receipt_num
935: AND (rhi.ship_to_organization_id = p_header_record.header_record.ship_to_organization_id
936: OR rhi.ship_to_organization_code = p_header_record.header_record.ship_to_organization_code)
937: AND rhi.processing_status_code IN ('PENDING','RUNNING');

Line 950: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');

946: IF (x_count > 0 OR x_rhi_count > 1) THEN
947: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
948: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
949: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
950: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
951: END IF;
952: /* End of fix for Bug 9126513 */
953:
954: IF (g_asn_debug = 'Y') THEN

Line 994: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');

990:
991: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
992: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
993: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
994: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
995: END IF;
996: ELSE
997: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
998: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);

Line 1000: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');

996: ELSE
997: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
998: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
999: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
1000: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
1001: END IF;
1002: END IF;
1003:
1004: IF (g_asn_debug = 'Y') THEN

Line 1031: rcv_headers_interface rhi

1027:
1028: SELECT COUNT(*)
1029: INTO x_count
1030: FROM rcv_transactions_interface rti,
1031: rcv_headers_interface rhi
1032: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1033: AND rhi.header_interface_id = rti.header_interface_id
1034: AND ( ( rti.to_organization_code IS NOT NULL
1035: AND rti.to_organization_code <> p_header_record.header_record.ship_to_organization_code)

Line 1158: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');

1154:
1155: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1156: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1157: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1158: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1159: END IF;
1160: ELSE
1161: IF (g_asn_debug = 'Y') THEN
1162: asn_debug.put_line('Error with from ORG_ID');

Line 1168: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');

1164:
1165: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1166: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1167: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1168: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1169: END IF;
1170: END IF;
1171:
1172: IF (g_asn_debug = 'Y') THEN

Line 1213: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');

1209: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1210: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1211: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1212: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1213: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1214: ELSE
1215: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1216: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1217: rcv_error_pkg.set_token('VALUE', loc_record.location_id);

Line 1218: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');

1214: ELSE
1215: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1216: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1217: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1218: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1219: END IF;
1220: END IF;
1221:
1222: IF (g_asn_debug = 'Y') THEN

Line 1287: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');

1283: END IF;
1284: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1285: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1286: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1287: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1288:
1289: END IF;*/
1290: --End Bug 5263268
1291:

Line 1312: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');

1308: IF (x_out_rec.is_valid = FALSE) THEN
1309: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1310: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1311: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1312: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1313: END IF;
1314:
1315: IF (g_asn_debug = 'Y') THEN
1316: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);

Line 1356: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');

1352: IF pay_record.error_record.error_status <> 'S' THEN
1353: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1354: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1355: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1356: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1357: END IF;
1358:
1359: IF (g_asn_debug = 'Y') THEN
1360: asn_debug.put_line(pay_record.error_record.error_status);

Line 1404: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');

1400: IF emp_record.error_record.error_status <> 'S' THEN
1401: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1402: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1403: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1404: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1405: END IF;
1406:
1407: IF (g_asn_debug = 'Y') THEN
1408: asn_debug.put_line('Validated receiver info');

Line 1473: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');

1469: IF freight_record.error_record.error_status <> 'S' THEN
1470: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1471: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1472: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1473: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1474: END IF;
1475:
1476: IF (g_asn_debug = 'Y') THEN
1477: asn_debug.put_line(freight_record.error_record.error_status);

Line 1514: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');

1510: ELSE
1511: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1512: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1513: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1514: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1515: END IF;
1516: END IF;
1517:
1518: IF (g_asn_debug = 'Y') THEN

Line 1981: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');

1977: /* LCM import is not supported in blackbox scenario */
1978: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1979: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1980: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1981: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1982: --
1983: ELSE
1984: --
1985: IF (g_asn_debug = 'Y') THEN

Line 1993: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');

1989: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1990: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1991: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1992: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1993: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1994: END IF;
1995: --
1996: END IF;
1997: ELSE

Line 2002: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');

1998: /* LCM import is not supported in a non-lcm org */
1999: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
2000: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
2001: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
2002: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
2003: END IF;
2004: END IF;
2005:
2006: IF (g_asn_debug = 'Y') THEN