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_HEADERS_INTERFACE_SV dependencies on RCV_HEADERS_INTERFACE

Line 1: PACKAGE BODY rcv_headers_interface_sv AS

1: PACKAGE BODY rcv_headers_interface_sv AS
2: /* $Header: RCVHISVB.pls 120.1.12010000.2 2008/08/04 08:41:44 rramasam ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

Line 74: rcv_headers_interface_sv.derive_ship_to_org_from_rti(p_header_record);

70: ** the ship_to_location_code.
71: */
72: IF ( p_header_record.header_record.ship_to_organization_code IS NULL
73: AND p_header_record.header_record.ship_to_organization_id IS NULL) THEN
74: rcv_headers_interface_sv.derive_ship_to_org_from_rti(p_header_record);
75: END IF;
76:
77: ship_to_org_record.organization_code := p_header_record.header_record.ship_to_organization_code;
78: ship_to_org_record.organization_id := p_header_record.header_record.ship_to_organization_id;

Line 369: -- We cannot depend on the auto_transact_code from the rcv_headers_interface

365: -- null added to it.
366:
367: -- IF the transaction type is CANCEL then no need to generate a receipt num
368:
369: -- We cannot depend on the auto_transact_code from the rcv_headers_interface
370: -- to figure out whether we need to generate a receipt_num
371: -- We will look at the transactions_interface.auto_transact_code/transaction_type
372: -- to figure out whether we need to do the generation
373:

Line 391: rcv_headers_interface */

387: FROM rcv_parameters
388: WHERE organization_id = p_header_record.header_record.ship_to_organization_id;
389:
390: /* assuming that the ship_to_organization_id is populated at the header level of
391: rcv_headers_interface */
392: IF (g_asn_debug = 'Y') THEN
393: asn_debug.put_line(v_rcv_type || ' Generation ');
394: END IF;
395:

Line 398: rcv_headers_interface_sv.genreceiptnum(p_header_record);

394: END IF;
395:
396: IF v_rcv_type = 'AUTOMATIC' THEN
397: --bug 2506961
398: rcv_headers_interface_sv.genreceiptnum(p_header_record);
399: ELSE -- MANUAL
400: IF p_header_record.header_record.shipment_num IS NOT NULL THEN
401: p_header_record.header_record.receipt_num := p_header_record.header_record.shipment_num;
402: END IF;

Line 578: 'RCV_HEADERS_INTERFACE',

574: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
575: END IF;
576:
577: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
578: 'RCV_HEADERS_INTERFACE',
579: 'TRANSACTION_TYPE'
580: );
581:
582: IF (g_asn_debug = 'Y') THEN

Line 602: 'RCV_HEADERS_INTERFACE',

598: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
599: END IF;
600:
601: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
602: 'RCV_HEADERS_INTERFACE',
603: 'ASN_TYPE'
604: );
605:
606: IF (g_asn_debug = 'Y') THEN

Line 631: 'RCV_HEADERS_INTERFACE',

627: rcv_error_pkg.set_error_message(currency_record.error_record.error_message, p_header_record.error_record.error_message);
628: END IF;
629:
630: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
631: 'RCV_HEADERS_INTERFACE',
632: 'CURRENCY_CODE'
633: );
634:
635: IF (g_asn_debug = 'Y') THEN

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

647: ELSE
648: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
649: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
650: rcv_error_pkg.set_token('SHIP_DATE', p_header_record.header_record.shipped_date);
651: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
652: END IF;
653: END IF;
654:
655: IF (g_asn_debug = 'Y') THEN

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

663: p_header_record.header_record.shipped_date THEN
664: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
665: rcv_error_pkg.set_error_message('RCV_DELIV_DATE_INVALID', p_header_record.error_record.error_message);
666: rcv_error_pkg.set_token('DELIVERY DATE', p_header_record.header_record.shipped_date);
667: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
668: END IF;
669: END IF;
670:
671: IF (g_asn_debug = 'Y') THEN

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

677: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
678: IF p_header_record.header_record.expected_receipt_date IS NULL THEN
679: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
680: rcv_error_pkg.set_error_message('RCV_ASN_EXPECTED_RECEIPT_DATE', p_header_record.error_record.error_message);
681: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
682: END IF;
683:
684: IF (g_asn_debug = 'Y') THEN
685: asn_debug.put_line('validated expected_receipt_date is not missing');

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

695: END IF;
696:
697: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
698: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
699: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
700: END IF;
701:
702: IF p_header_record.header_record.receipt_num IS NOT NULL
703: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel

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

710: IF x_count > 0 THEN
711: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
712: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
713: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
714: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
715: END IF;
716:
717: IF (g_asn_debug = 'Y') THEN
718: asn_debug.put_line('validated receipt number');

Line 733: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'VENDOR_ID');

729:
730: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
731: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL', p_header_record.error_record.error_message);
732: rcv_error_pkg.set_token('COLUMN_NAME', 'VENDOR_ID');
733: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'VENDOR_ID');
734: END IF;
735:
736: vendor_record.vendor_name := p_header_record.header_record.vendor_name;
737: vendor_record.vendor_num := p_header_record.header_record.vendor_num;

Line 770: 'RCV_HEADERS_INTERFACE',

766: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);
767: END IF;
768:
769: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
770: 'RCV_HEADERS_INTERFACE',
771: 'VENDOR_ID'
772: );
773:
774: IF (g_asn_debug = 'Y') THEN

Line 805: 'RCV_HEADERS_INTERFACE',

801: END IF;
802: END IF;
803:
804: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
805: 'RCV_HEADERS_INTERFACE',
806: 'SHIP_TO_ORGANIZATION_ID'
807: );
808:
809: IF (g_asn_debug = 'Y') THEN

Line 835: rcv_headers_interface rhi

831:
832: SELECT COUNT(*)
833: INTO x_count
834: FROM rcv_transactions_interface rti,
835: rcv_headers_interface rhi
836: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
837: AND rhi.header_interface_id = rti.header_interface_id
838: AND ( ( rti.to_organization_code IS NOT NULL
839: AND rti.to_organization_code <> p_header_record.header_record.ship_to_organization_code)

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

848:
849: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
850: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
851: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
852: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
853: ELSE
854: IF (g_asn_debug = 'Y') THEN
855: asn_debug.put_line('In the ELSE part');
856: END IF;

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

908:
909: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
910: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
911: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
912: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
913: END IF;
914: END IF;
915:
916: IF (g_asn_debug = 'Y') THEN

Line 951: 'RCV_HEADERS_INTERFACE',

947: END IF;
948: END IF;
949:
950: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
951: 'RCV_HEADERS_INTERFACE',
952: 'SHIP_TO_ORGANIZATION_ID'
953: );
954: END IF;
955: END IF;

Line 1023: 'RCV_HEADERS_INTERFACE',

1019: END IF;
1020:
1021: p_header_record.error_record := vendor_site_record.error_record;
1022: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1023: 'RCV_HEADERS_INTERFACE',
1024: 'VENDOR_ID'
1025: );
1026:
1027: IF (g_asn_debug = 'Y') THEN

Line 1064: 'RCV_HEADERS_INTERFACE',

1060: END IF;
1061:
1062: p_header_record.error_record := loc_record.error_record;
1063: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1064: 'RCV_HEADERS_INTERFACE',
1065: 'LOCATION_ID'
1066: );
1067:
1068: IF (g_asn_debug = 'Y') THEN

Line 1106: 'RCV_HEADERS_INTERFACE',

1102: END IF;
1103:
1104: p_header_record.error_record := pay_record.error_record;
1105: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1106: 'RCV_HEADERS_INTERFACE',
1107: 'PAYMENT_TERM_ID'
1108: );
1109:
1110: IF (g_asn_debug = 'Y') THEN

Line 1143: 'RCV_HEADERS_INTERFACE',

1139: END IF;
1140:
1141: p_header_record.error_record := emp_record.error_record;
1142: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1143: 'RCV_HEADERS_INTERFACE',
1144: 'EMPLOYEE_ID'
1145: );
1146:
1147: IF (g_asn_debug = 'Y') THEN

Line 1176: 'RCV_HEADERS_INTERFACE',

1172: END IF;
1173:
1174: p_header_record.error_record := freight_record.error_record;
1175: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1176: 'RCV_HEADERS_INTERFACE',
1177: 'FREIGHT_CARRIER_CODE'
1178: );
1179:
1180: IF (g_asn_debug = 'Y') THEN

Line 1193: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);

1189: invoice_record.total_invoice_amount := p_header_record.header_record.total_invoice_amount;
1190: invoice_record.vendor_id := p_header_record.header_record.vendor_id;
1191: invoice_record.vendor_site_id := p_header_record.header_record.vendor_site_id;
1192: invoice_record.error_record := p_header_record.error_record;
1193: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);
1194: p_header_record.error_record := invoice_record.error_record;
1195: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1196: 'RCV_HEADERS_INTERFACE',
1197: 'TOTAL_INVOICE_AMOUNT'

Line 1196: 'RCV_HEADERS_INTERFACE',

1192: invoice_record.error_record := p_header_record.error_record;
1193: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);
1194: p_header_record.error_record := invoice_record.error_record;
1195: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1196: 'RCV_HEADERS_INTERFACE',
1197: 'TOTAL_INVOICE_AMOUNT'
1198: );
1199:
1200: IF (g_asn_debug = 'Y') THEN

Line 1217: 'RCV_HEADERS_INTERFACE',

1213: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_NUM', p_header_record.error_record.error_message);
1214: END IF;
1215:
1216: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1217: 'RCV_HEADERS_INTERFACE',
1218: 'SHIPMENT_NUM'
1219: );
1220:
1221: IF (g_asn_debug = 'Y') THEN

Line 1237: 'RCV_HEADERS_INTERFACE',

1233: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_DATE', p_header_record.error_record.error_message);
1234: END IF;
1235:
1236: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1237: 'RCV_HEADERS_INTERFACE',
1238: 'INVOICE_DATE'
1239: );
1240:
1241: IF (g_asn_debug = 'Y') THEN

Line 1264: 'RCV_HEADERS_INTERFACE',

1260: END IF;
1261:
1262: p_header_record.error_record := tax_record.error_record;
1263: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1264: 'RCV_HEADERS_INTERFACE',
1265: 'TAX_NAME'
1266: );
1267: END IF;
1268:

Line 1277: 'RCV_HEADERS_INTERFACE',

1273:
1274: /* Validations on shipment number */
1275: rcv_core_s.validate_shipment_number(p_header_record);
1276: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,
1277: 'RCV_HEADERS_INTERFACE',
1278: 'SHIPMENT_NUM'
1279: );
1280:
1281: IF (g_asn_debug = 'Y') THEN

Line 1668: END rcv_headers_interface_sv;

1664: WHEN OTHERS THEN
1665: ROLLBACK;
1666: END;
1667: END genreceiptnum;
1668: END rcv_headers_interface_sv;