APPS.RCV_ROI_HEADER dependencies on RCV_ERROR_PKG

Line 816: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message);

812: po_core_s.validate_lookup_info(lookup_record);
813:
814: IF lookup_record.error_record.error_status IN('E') THEN
815: lookup_record.error_record.error_message := 'PO_PDOI_INVALID_TYPE_LKUP_CD';
816: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message);
817: rcv_error_pkg.set_token('VALUE', lookup_record.lookup_code);
818: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
819: 'ASN_TYPE',
820: FALSE

Line 817: rcv_error_pkg.set_token('VALUE', lookup_record.lookup_code);

813:
814: IF lookup_record.error_record.error_status IN('E') THEN
815: lookup_record.error_record.error_message := 'PO_PDOI_INVALID_TYPE_LKUP_CD';
816: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message);
817: rcv_error_pkg.set_token('VALUE', lookup_record.lookup_code);
818: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
819: 'ASN_TYPE',
820: FALSE
821: );

Line 818: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

814: IF lookup_record.error_record.error_status IN('E') THEN
815: lookup_record.error_record.error_message := 'PO_PDOI_INVALID_TYPE_LKUP_CD';
816: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message);
817: rcv_error_pkg.set_token('VALUE', lookup_record.lookup_code);
818: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
819: 'ASN_TYPE',
820: FALSE
821: );
822: END IF;

Line 854: rcv_error_pkg.set_error_message(currency_record.error_record.error_message);

850:
851: IF currency_record.error_record.error_status = 'E' THEN
852: IF currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID') THEN
853: currency_record.error_record.error_message := 'PO_PDOI_INVALID_CURRENCY';
854: rcv_error_pkg.set_error_message(currency_record.error_record.error_message);
855: rcv_error_pkg.set_token('VALUE', currency_record.currency_code);
856: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
857: 'CURRECTYPE',
858: FALSE

Line 855: rcv_error_pkg.set_token('VALUE', currency_record.currency_code);

851: IF currency_record.error_record.error_status = 'E' THEN
852: IF currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID') THEN
853: currency_record.error_record.error_message := 'PO_PDOI_INVALID_CURRENCY';
854: rcv_error_pkg.set_error_message(currency_record.error_record.error_message);
855: rcv_error_pkg.set_token('VALUE', currency_record.currency_code);
856: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
857: 'CURRECTYPE',
858: FALSE
859: );

Line 856: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

852: IF currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID') THEN
853: currency_record.error_record.error_message := 'PO_PDOI_INVALID_CURRENCY';
854: rcv_error_pkg.set_error_message(currency_record.error_record.error_message);
855: rcv_error_pkg.set_token('VALUE', currency_record.currency_code);
856: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
857: 'CURRECTYPE',
858: FALSE
859: );
860: END IF;

Line 884: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

880: IF p_header_record.header_record.expected_receipt_date < /* nwang: allow expected_receipt_date to be the same as shipped_date */
881: p_header_record.header_record.shipped_date THEN
882: p_header_record.error_record.error_status := 'E';
883: p_header_record.error_record.error_message := 'RCV_DELIV_DATE_INVALID';
884: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
885: rcv_error_pkg.set_token('DELIVERY DATE', fnd_date.date_to_chardate(p_header_record.header_record.expected_receipt_date));
886: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
887: 'SHIPPED_DATE',
888: FALSE

Line 885: rcv_error_pkg.set_token('DELIVERY DATE', fnd_date.date_to_chardate(p_header_record.header_record.expected_receipt_date));

881: p_header_record.header_record.shipped_date THEN
882: p_header_record.error_record.error_status := 'E';
883: p_header_record.error_record.error_message := 'RCV_DELIV_DATE_INVALID';
884: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
885: rcv_error_pkg.set_token('DELIVERY DATE', fnd_date.date_to_chardate(p_header_record.header_record.expected_receipt_date));
886: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
887: 'SHIPPED_DATE',
888: FALSE
889: );

Line 886: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

882: p_header_record.error_record.error_status := 'E';
883: p_header_record.error_record.error_message := 'RCV_DELIV_DATE_INVALID';
884: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
885: rcv_error_pkg.set_token('DELIVERY DATE', fnd_date.date_to_chardate(p_header_record.header_record.expected_receipt_date));
886: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
887: 'SHIPPED_DATE',
888: FALSE
889: );
890: END IF;

Line 936: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);

932: vendor_record.error_record.error_message := NULL;
933: vendor_record.error_record.error_status := 'S';
934: ELSE
935: vendor_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR';
936: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
937: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
938: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
939: 'VENDOR_ID',
940: FALSE

Line 937: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);

933: vendor_record.error_record.error_status := 'S';
934: ELSE
935: vendor_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR';
936: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
937: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
938: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
939: 'VENDOR_ID',
940: FALSE
941: );

Line 938: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

934: ELSE
935: vendor_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR';
936: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
937: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
938: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
939: 'VENDOR_ID',
940: FALSE
941: );
942: END IF;

Line 947: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);

943: ELSIF vendor_record.error_record.error_message = 'VEN_HOLD' THEN
944: IF p_header_record.header_record.transaction_type <> 'CANCEL'
945: AND NVL(p_header_record.header_record.asn_type,'STD') <> 'STD' THEN -- Bug#15862352
946: vendor_record.error_record.error_message := 'PO_PO_VENDOR_ON_HOLD';
947: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
948: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
949: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
950: 'VENDOR_ID',
951: FALSE

Line 948: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);

944: IF p_header_record.header_record.transaction_type <> 'CANCEL'
945: AND NVL(p_header_record.header_record.asn_type,'STD') <> 'STD' THEN -- Bug#15862352
946: vendor_record.error_record.error_message := 'PO_PO_VENDOR_ON_HOLD';
947: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
948: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
949: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
950: 'VENDOR_ID',
951: FALSE
952: );

Line 949: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

945: AND NVL(p_header_record.header_record.asn_type,'STD') <> 'STD' THEN -- Bug#15862352
946: vendor_record.error_record.error_message := 'PO_PO_VENDOR_ON_HOLD';
947: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
948: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
949: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
950: 'VENDOR_ID',
951: FALSE
952: );
953: ELSE

Line 959: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);

955: vendor_record.error_record.error_status := 'S';
956: END IF;
957: ELSIF vendor_record.error_record.error_message = 'VEN_ID' THEN
958: vendor_record.error_record.error_message := 'RCV_VEN_ID';
959: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
960: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);
961: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
962: 'VENDOR_ID',
963: FALSE

Line 960: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);

956: END IF;
957: ELSIF vendor_record.error_record.error_message = 'VEN_ID' THEN
958: vendor_record.error_record.error_message := 'RCV_VEN_ID';
959: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
960: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);
961: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
962: 'VENDOR_ID',
963: FALSE
964: );

Line 961: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

957: ELSIF vendor_record.error_record.error_message = 'VEN_ID' THEN
958: vendor_record.error_record.error_message := 'RCV_VEN_ID';
959: rcv_error_pkg.set_error_message(vendor_record.error_record.error_message);
960: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);
961: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
962: 'VENDOR_ID',
963: FALSE
964: );
965: END IF;

Line 1037: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);

1033: IF p_header_record.header_record.asn_type = 'ASBN'
1034: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1035: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
1036: vendor_site_record.error_record.error_status := 'W';
1037: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1038: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
1039: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');
1040: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
1041: ELSE

Line 1038: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);

1034: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1035: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
1036: vendor_site_record.error_record.error_status := 'W';
1037: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1038: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
1039: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');
1040: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
1041: ELSE
1042: vendor_site_record.error_record.error_status := 'S';

Line 1039: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');

1035: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
1036: vendor_site_record.error_record.error_status := 'W';
1037: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1038: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
1039: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'VENDOR_SITE_ID');
1040: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
1041: ELSE
1042: vendor_site_record.error_record.error_status := 'S';
1043: vendor_site_record.error_record.error_message := NULL;

Line 1064: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);

1060: so as to continue normally.
1061: */
1062: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1063: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1064: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1065: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1066: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1067: 'VENDOR_SITE_ID',
1068: FALSE

Line 1065: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);

1061: */
1062: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1063: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1064: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1065: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1066: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1067: 'VENDOR_SITE_ID',
1068: FALSE
1069: );

Line 1066: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1062: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1063: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1064: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1065: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1066: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1067: 'VENDOR_SITE_ID',
1068: FALSE
1069: );
1070: ELSE

Line 1071: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1067: 'VENDOR_SITE_ID',
1068: FALSE
1069: );
1070: ELSE
1071: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1072: vendor_site_record.error_record.error_message := NULL;
1073: END IF;
1074:
1075: /*End of fix added for 5953480, while replicating fix by 2830103*/

Line 1132: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);

1128: **9475696
1129: **When this Supplier Site is not under the current OU, insert one error message in po_interface_errors.
1130: */
1131: vendor_site_record.error_record.error_message := 'PO_PDOI_VENDOR_SITE_NOTFOUND';
1132: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1133: rcv_error_pkg.set_token('SUPPLIER_SITE', vendor_site_record.vendor_site_id);
1134: rcv_error_pkg.set_token('OU', MO_GLOBAL.get_current_org_id());
1135: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1136: 'VENDOR_SITE_ID',

Line 1133: rcv_error_pkg.set_token('SUPPLIER_SITE', vendor_site_record.vendor_site_id);

1129: **When this Supplier Site is not under the current OU, insert one error message in po_interface_errors.
1130: */
1131: vendor_site_record.error_record.error_message := 'PO_PDOI_VENDOR_SITE_NOTFOUND';
1132: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1133: rcv_error_pkg.set_token('SUPPLIER_SITE', vendor_site_record.vendor_site_id);
1134: rcv_error_pkg.set_token('OU', MO_GLOBAL.get_current_org_id());
1135: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1136: 'VENDOR_SITE_ID',
1137: FALSE );

Line 1134: rcv_error_pkg.set_token('OU', MO_GLOBAL.get_current_org_id());

1130: */
1131: vendor_site_record.error_record.error_message := 'PO_PDOI_VENDOR_SITE_NOTFOUND';
1132: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1133: rcv_error_pkg.set_token('SUPPLIER_SITE', vendor_site_record.vendor_site_id);
1134: rcv_error_pkg.set_token('OU', MO_GLOBAL.get_current_org_id());
1135: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1136: 'VENDOR_SITE_ID',
1137: FALSE );
1138: /* end bug 9475696 */

Line 1135: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1131: vendor_site_record.error_record.error_message := 'PO_PDOI_VENDOR_SITE_NOTFOUND';
1132: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1133: rcv_error_pkg.set_token('SUPPLIER_SITE', vendor_site_record.vendor_site_id);
1134: rcv_error_pkg.set_token('OU', MO_GLOBAL.get_current_org_id());
1135: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1136: 'VENDOR_SITE_ID',
1137: FALSE );
1138: /* end bug 9475696 */
1139: END IF; -- x_in_this_op_unit = 0 --}

Line 1144: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);

1140: END;
1141: ELSE --}{
1142: /*End Bug#3359613 */
1143: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1144: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1145: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1146: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1147: 'VENDOR_SITE_ID',
1148: FALSE

Line 1145: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);

1141: ELSE --}{
1142: /*End Bug#3359613 */
1143: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1144: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1145: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1146: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1147: 'VENDOR_SITE_ID',
1148: FALSE
1149: );

Line 1146: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1142: /*End Bug#3359613 */
1143: vendor_site_record.error_record.error_message := 'PO_PDOI_INVALID_VENDOR_SITE';
1144: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message);
1145: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1146: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1147: 'VENDOR_SITE_ID',
1148: FALSE
1149: );
1150: END IF; -- Bug#3359613 NVL(p_header_record.header_record.asn_type,'STD') in ('ASN','ASBN')--}

Line 1188: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);

1184: rcv_headers_interface_sv.validate_invoice_amount(invoice_record);
1185:
1186: IF invoice_record.error_record.error_status = 'E' THEN --{
1187: IF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT' THEN --{
1188: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1189: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1190: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1191: 'TOTAL_INVOICE_AMOUNT',
1192: FALSE

Line 1189: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);

1185:
1186: IF invoice_record.error_record.error_status = 'E' THEN --{
1187: IF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT' THEN --{
1188: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1189: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1190: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1191: 'TOTAL_INVOICE_AMOUNT',
1192: FALSE
1193: );

Line 1190: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1186: IF invoice_record.error_record.error_status = 'E' THEN --{
1187: IF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT' THEN --{
1188: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1189: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1190: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1191: 'TOTAL_INVOICE_AMOUNT',
1192: FALSE
1193: );
1194: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {

Line 1195: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);

1191: 'TOTAL_INVOICE_AMOUNT',
1192: FALSE
1193: );
1194: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {
1195: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1196: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1197: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1198: 'TOTAL_INVOICE_AMOUNT',
1199: FALSE

Line 1196: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);

1192: FALSE
1193: );
1194: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {
1195: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1196: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1197: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1198: 'TOTAL_INVOICE_AMOUNT',
1199: FALSE
1200: );

Line 1197: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1193: );
1194: ELSIF invoice_record.error_record.error_message = 'RCV_ASBN_INVOICE_AMT_LIMIT' THEN --} {
1195: rcv_error_pkg.set_error_message(invoice_record.error_record.error_message);
1196: rcv_error_pkg.set_token('AMOUNT', invoice_record.total_invoice_amount);
1197: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1198: 'TOTAL_INVOICE_AMOUNT',
1199: FALSE
1200: );
1201: END IF; --} matches if invoice record error status E

Line 1221: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1217: AND -- Should we assign shipment_num to null.invoice_num
1218: p_header_record.header_record.invoice_num IS NULL THEN --{
1219: p_header_record.error_record.error_status := 'E';
1220: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_NUM';
1221: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1222: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1223: 'INVOICE_NUM',
1224: FALSE
1225: );

Line 1222: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1218: p_header_record.header_record.invoice_num IS NULL THEN --{
1219: p_header_record.error_record.error_status := 'E';
1220: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_NUM';
1221: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1222: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1223: 'INVOICE_NUM',
1224: FALSE
1225: );
1226: END IF; --}

Line 1241: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1237: AND p_header_record.header_record.asn_type = 'ASBN' THEN --{
1238: IF p_header_record.header_record.invoice_date IS NULL THEN --{
1239: p_header_record.error_record.error_status := 'E';
1240: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_DATE';
1241: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1242: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1243: 'INVOICE_DATE',
1244: FALSE
1245: );

Line 1242: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1238: IF p_header_record.header_record.invoice_date IS NULL THEN --{
1239: p_header_record.error_record.error_status := 'E';
1240: p_header_record.error_record.error_message := 'RCV_ASBN_INVOICE_DATE';
1241: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1242: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1243: 'INVOICE_DATE',
1244: FALSE
1245: );
1246: END IF; --}

Line 1267: rcv_error_pkg.set_error_message(tax_record.error_record.error_message);

1263:
1264: IF tax_record.error_record.error_status = 'E' THEN --{
1265: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN --{
1266: tax_record.error_record.error_message := 'PO_PDOI_INVALID_TAX_NAME';
1267: rcv_error_pkg.set_error_message(tax_record.error_record.error_message);
1268: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1269: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1270: 'TAX_NAME',
1271: FALSE

Line 1268: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);

1264: IF tax_record.error_record.error_status = 'E' THEN --{
1265: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN --{
1266: tax_record.error_record.error_message := 'PO_PDOI_INVALID_TAX_NAME';
1267: rcv_error_pkg.set_error_message(tax_record.error_record.error_message);
1268: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1269: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1270: 'TAX_NAME',
1271: FALSE
1272: );

Line 1269: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1265: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN --{
1266: tax_record.error_record.error_message := 'PO_PDOI_INVALID_TAX_NAME';
1267: rcv_error_pkg.set_error_message(tax_record.error_record.error_message);
1268: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1269: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1270: 'TAX_NAME',
1271: FALSE
1272: );
1273: END IF; --}

Line 1292: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1288: validate_shipment_number(p_header_record);
1289:
1290: IF p_header_record.error_record.error_status = 'E' THEN --{
1291: IF p_header_record.error_record.error_message IN('RCV_NO_MATCHING_ASN', 'RCV_ASN_MISMATCH_SHIP_ID', 'RCV_ASN_QTY_RECEIVED') THEN --{
1292: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1293: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1294: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1295: 'SHIPMENT_NUM',
1296: FALSE

Line 1293: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);

1289:
1290: IF p_header_record.error_record.error_status = 'E' THEN --{
1291: IF p_header_record.error_record.error_message IN('RCV_NO_MATCHING_ASN', 'RCV_ASN_MISMATCH_SHIP_ID', 'RCV_ASN_QTY_RECEIVED') THEN --{
1292: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1293: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1294: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1295: 'SHIPMENT_NUM',
1296: FALSE
1297: );

Line 1294: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1290: IF p_header_record.error_record.error_status = 'E' THEN --{
1291: IF p_header_record.error_record.error_message IN('RCV_NO_MATCHING_ASN', 'RCV_ASN_MISMATCH_SHIP_ID', 'RCV_ASN_QTY_RECEIVED') THEN --{
1292: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1293: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1294: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1295: 'SHIPMENT_NUM',
1296: FALSE
1297: );
1298: ELSIF p_header_record.error_record.error_message = 'RCV_NO_SHIPMENT_NUM' THEN --} {

Line 1299: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1295: 'SHIPMENT_NUM',
1296: FALSE
1297: );
1298: ELSIF p_header_record.error_record.error_message = 'RCV_NO_SHIPMENT_NUM' THEN --} {
1299: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1300: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1301: 'SHIPMENT_NUM',
1302: FALSE
1303: );

Line 1300: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1296: FALSE
1297: );
1298: ELSIF p_header_record.error_record.error_message = 'RCV_NO_SHIPMENT_NUM' THEN --} {
1299: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1300: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1301: 'SHIPMENT_NUM',
1302: FALSE
1303: );
1304: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {

Line 1305: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1301: 'SHIPMENT_NUM',
1302: FALSE
1303: );
1304: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {
1305: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1306: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1307: rcv_error_pkg.set_token('ITEM', '');
1308: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1309: 'SHIPMENT_NUM',

Line 1306: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);

1302: FALSE
1303: );
1304: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {
1305: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1306: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1307: rcv_error_pkg.set_token('ITEM', '');
1308: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1309: 'SHIPMENT_NUM',
1310: FALSE

Line 1307: rcv_error_pkg.set_token('ITEM', '');

1303: );
1304: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {
1305: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1306: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1307: rcv_error_pkg.set_token('ITEM', '');
1308: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1309: 'SHIPMENT_NUM',
1310: FALSE
1311: );

Line 1308: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',

1304: ELSIF p_header_record.error_record.error_message = 'RCV_RCV_BEFORE_ASN' THEN --} {
1305: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1306: rcv_error_pkg.set_token('SHIPMENT', p_header_record.header_record.shipment_num);
1307: rcv_error_pkg.set_token('ITEM', '');
1308: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE',
1309: 'SHIPMENT_NUM',
1310: FALSE
1311: );
1312: /* Bug# 1413880

Line 1320: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);

1316: -- END IF;
1317: -- ELSIF p_header_record.error_record.error_status = 'W' then
1318: ELSIF p_header_record.error_record.error_message = 'RCV_DUP_SHIPMENT_NUM' THEN --}{
1319: p_header_record.error_record.error_message := 'PO_PDOI_SHIPMENT_NUM_UNIQUE';
1320: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1321: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.shipment_num);
1322: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');
1323: END IF; --}
1324: END IF;

Line 1321: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.shipment_num);

1317: -- ELSIF p_header_record.error_record.error_status = 'W' then
1318: ELSIF p_header_record.error_record.error_message = 'RCV_DUP_SHIPMENT_NUM' THEN --}{
1319: p_header_record.error_record.error_message := 'PO_PDOI_SHIPMENT_NUM_UNIQUE';
1320: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1321: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.shipment_num);
1322: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');
1323: END IF; --}
1324: END IF;
1325:

Line 1322: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');

1318: ELSIF p_header_record.error_record.error_message = 'RCV_DUP_SHIPMENT_NUM' THEN --}{
1319: p_header_record.error_record.error_message := 'PO_PDOI_SHIPMENT_NUM_UNIQUE';
1320: rcv_error_pkg.set_error_message(p_header_record.error_record.error_message);
1321: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.shipment_num);
1322: rcv_error_pkg.log_interface_warning('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM');
1323: END IF; --}
1324: END IF;
1325:
1326: IF (g_asn_debug = 'Y') THEN