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_ERROR_PKG

Line 411: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

407: END IF;
408: END IF; -- v_rcv_type
409: EXCEPTION
410: WHEN OTHERS THEN
411: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
412: rcv_error_pkg.set_sql_error_message('default_shipment_header', '010');
413: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
414: END;
415: ELSE -- of v_count

Line 412: rcv_error_pkg.set_sql_error_message('default_shipment_header', '010');

408: END IF; -- v_rcv_type
409: EXCEPTION
410: WHEN OTHERS THEN
411: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
412: rcv_error_pkg.set_sql_error_message('default_shipment_header', '010');
413: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
414: END;
415: ELSE -- of v_count
416: IF (g_asn_debug = 'Y') THEN

Line 413: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

409: EXCEPTION
410: WHEN OTHERS THEN
411: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
412: rcv_error_pkg.set_sql_error_message('default_shipment_header', '010');
413: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
414: END;
415: ELSE -- of v_count
416: IF (g_asn_debug = 'Y') THEN
417: asn_debug.put_line('No need to generate a receipt_number');

Line 571: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);

567: lookup_record.error_record := p_header_record.error_record;
568: po_core_s.validate_lookup_info(lookup_record);
569: p_header_record.error_record.error_status := lookup_record.error_record.error_status;
570: /* po_core_s doesn't follow error paradigm */
571: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);
572:
573: IF (p_header_record.error_record.error_message = 'RCV_TRX_TYPE_INVALID') THEN
574: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
575: END IF;

Line 574: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);

570: /* po_core_s doesn't follow error paradigm */
571: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);
572:
573: IF (p_header_record.error_record.error_message = 'RCV_TRX_TYPE_INVALID') THEN
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',

Line 577: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

573: IF (p_header_record.error_record.error_message = 'RCV_TRX_TYPE_INVALID') THEN
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:

Line 595: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);

591: lookup_record.error_record := p_header_record.error_record;
592: po_core_s.validate_lookup_info(lookup_record);
593: p_header_record.error_record.error_status := lookup_record.error_record.error_status;
594: /* po_core_s doesn't follow error paradigm */
595: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);
596:
597: IF (p_header_record.error_record.error_message = 'PO_PDOI_INVALID_TYPE_LKUP_CD') THEN
598: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
599: END IF;

Line 598: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);

594: /* po_core_s doesn't follow error paradigm */
595: rcv_error_pkg.set_error_message(lookup_record.error_record.error_message, p_header_record.error_record.error_message);
596:
597: IF (p_header_record.error_record.error_message = 'PO_PDOI_INVALID_TYPE_LKUP_CD') THEN
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',

Line 601: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

597: IF (p_header_record.error_record.error_message = 'PO_PDOI_INVALID_TYPE_LKUP_CD') THEN
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:

Line 624: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_CURRENCY', p_header_record.error_record.error_message);

620: p_header_record.error_record.error_status := currency_record.error_record.error_status;
621:
622: /* po_currency_s doesn't follow error paradigm */
623: IF (currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID')) THEN
624: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_CURRENCY', p_header_record.error_record.error_message);
625: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.currency_code);
626: ELSE
627: rcv_error_pkg.set_error_message(currency_record.error_record.error_message, p_header_record.error_record.error_message);
628: END IF;

Line 625: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.currency_code);

621:
622: /* po_currency_s doesn't follow error paradigm */
623: IF (currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID')) THEN
624: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_CURRENCY', p_header_record.error_record.error_message);
625: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.currency_code);
626: ELSE
627: rcv_error_pkg.set_error_message(currency_record.error_record.error_message, p_header_record.error_record.error_message);
628: END IF;
629:

Line 627: rcv_error_pkg.set_error_message(currency_record.error_record.error_message, p_header_record.error_record.error_message);

623: IF (currency_record.error_record.error_message IN('CURRENCY_DISABLED', 'CURRENCY_INVALID')) THEN
624: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_CURRENCY', p_header_record.error_record.error_message);
625: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.currency_code);
626: ELSE
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',

Line 630: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

626: ELSE
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:

Line 648: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

644: IF (g_asn_debug = 'Y') THEN
645: asn_debug.put_line('Shipped date can be blank for STD');
646: END IF;
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;

Line 649: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);

645: asn_debug.put_line('Shipped date can be blank for STD');
646: END IF;
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;

Line 650: rcv_error_pkg.set_token('SHIP_DATE', p_header_record.header_record.shipped_date);

646: END IF;
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:

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 664: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

660: IF p_header_record.header_record.transaction_type <> 'CANCEL' THEN
661: IF p_header_record.header_record.expected_receipt_date IS NOT NULL THEN
662: IF p_header_record.header_record.expected_receipt_date < /* nwang: allow expected_receipt_date to be the same as shipped_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;

Line 665: rcv_error_pkg.set_error_message('RCV_DELIV_DATE_INVALID', p_header_record.error_record.error_message);

661: IF p_header_record.header_record.expected_receipt_date IS NOT NULL THEN
662: IF p_header_record.header_record.expected_receipt_date < /* nwang: allow expected_receipt_date to be the same as shipped_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;

Line 666: rcv_error_pkg.set_token('DELIVERY DATE', p_header_record.header_record.shipped_date);

662: IF p_header_record.header_record.expected_receipt_date < /* nwang: allow expected_receipt_date to be the same as shipped_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:

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 679: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

675:
676: /* Validation expected_receipt_date is not missing BUG 628316 */
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:

Line 680: rcv_error_pkg.set_error_message('RCV_ASN_EXPECTED_RECEIPT_DATE', p_header_record.error_record.error_message);

676: /* Validation expected_receipt_date is not missing BUG 628316 */
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

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 697: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('Receipt Number is mandatory for STD');
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:

Line 698: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);

694: asn_debug.put_line('Receipt Number is mandatory for STD');
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

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 711: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

707: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
708: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
709:
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;

Line 712: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);

708: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
709:
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:

Line 713: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);

709:
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

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 730: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

726: IF (g_asn_debug = 'Y') THEN
727: asn_debug.put_line('validated vendor info is all null');
728: END IF;
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;

Line 731: rcv_error_pkg.set_error_message('PO_PDOI_COLUMN_NOT_NULL', p_header_record.error_record.error_message);

727: asn_debug.put_line('validated vendor info is all null');
728: END IF;
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:

Line 732: rcv_error_pkg.set_token('COLUMN_NAME', 'VENDOR_ID');

728: END IF;
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;

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 751: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

747:
748: /* po_core_s doesn't follow error paradigm */
749: IF (vendor_record.error_record.error_message = 'VEN_DISABLED') THEN
750: IF NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
751: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
752: ELSE
753: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR', p_header_record.error_record.error_message);
754: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
755: END IF;

Line 753: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR', p_header_record.error_record.error_message);

749: IF (vendor_record.error_record.error_message = 'VEN_DISABLED') THEN
750: IF NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
751: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
752: ELSE
753: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR', p_header_record.error_record.error_message);
754: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
755: END IF;
756: ELSIF(vendor_record.error_record.error_message = 'VEN_HOLD') THEN
757: IF p_header_record.header_record.transaction_type = 'CANCEL'

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

750: IF NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
751: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
752: ELSE
753: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR', p_header_record.error_record.error_message);
754: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
755: END IF;
756: ELSIF(vendor_record.error_record.error_message = 'VEN_HOLD') THEN
757: IF p_header_record.header_record.transaction_type = 'CANCEL'
758: OR NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN

Line 759: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

755: END IF;
756: ELSIF(vendor_record.error_record.error_message = 'VEN_HOLD') THEN
757: IF p_header_record.header_record.transaction_type = 'CANCEL'
758: OR NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
759: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
760: ELSE
761: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD', p_header_record.error_record.error_message);
762: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
763: END IF;

Line 761: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD', p_header_record.error_record.error_message);

757: IF p_header_record.header_record.transaction_type = 'CANCEL'
758: OR NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
759: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
760: ELSE
761: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD', p_header_record.error_record.error_message);
762: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
763: END IF;
764: ELSIF(vendor_record.error_record.error_message = 'VEN_ID') THEN
765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);

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

758: OR NVL(p_header_record.header_record.asn_type,'STD') = 'STD' THEN
759: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
760: ELSE
761: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD', p_header_record.error_record.error_message);
762: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
763: END IF;
764: ELSIF(vendor_record.error_record.error_message = 'VEN_ID') THEN
765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);
766: rcv_error_pkg.set_token('SUPPLIER', vendor_record.vendor_id);

Line 765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);

761: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD', p_header_record.error_record.error_message);
762: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
763: END IF;
764: ELSIF(vendor_record.error_record.error_message = 'VEN_ID') THEN
765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);
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,

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

762: rcv_error_pkg.set_token('VALUE', vendor_record.vendor_id);
763: END IF;
764: ELSIF(vendor_record.error_record.error_message = 'VEN_ID') THEN
765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);
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',

Line 769: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

765: rcv_error_pkg.set_error_message('RCV_VEN_ID', p_header_record.error_record.error_message);
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:

Line 793: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);

789: p_header_record.error_record.error_status := ship_to_org_record.error_record.error_status;
790:
791: /* po_core_s doesn't follow error paradigm */
792: IF (ship_to_org_record.error_record.error_message = 'ORG_ID') THEN
793: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
794: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
795: ELSIF(ship_to_org_record.error_record.error_message = 'ORG_DISABLED') THEN
796: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

Line 794: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);

790:
791: /* po_core_s doesn't follow error paradigm */
792: IF (ship_to_org_record.error_record.error_message = 'ORG_ID') THEN
793: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
794: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
795: ELSIF(ship_to_org_record.error_record.error_message = 'ORG_DISABLED') THEN
796: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
798: ELSE

Line 797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

793: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
794: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
795: ELSIF(ship_to_org_record.error_record.error_message = 'ORG_DISABLED') THEN
796: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
798: ELSE
799: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
800: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
801: END IF;

Line 799: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);

795: ELSIF(ship_to_org_record.error_record.error_message = 'ORG_DISABLED') THEN
796: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
798: ELSE
799: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
800: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
801: END IF;
802: END IF;
803:

Line 800: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);

796: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
797: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
798: ELSE
799: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
800: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
801: END IF;
802: END IF;
803:
804: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

Line 804: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

800: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
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:

Line 849: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

845: IF (g_asn_debug = 'Y') THEN
846: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
847: END IF;
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

Line 850: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

846: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
847: END IF;
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

Line 851: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);

847: END IF;
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');

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 909: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

905: IF (g_asn_debug = 'Y') THEN
906: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
907: END IF;
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;

Line 910: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);

906: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
907: END IF;
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;

Line 911: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);

907: END IF;
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:

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 939: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);

935: p_header_record.error_record.error_status := from_org_record.error_record.error_status;
936:
937: /* po_core_s doesn't follow error paradigm */
938: IF (from_org_record.error_record.error_message = 'ORG_ID') THEN
939: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
940: rcv_error_pkg.set_token('VALUE', from_org_record.organization_id);
941: ELSIF(from_org_record.error_record.error_message = 'ORG_DISABLED') THEN
942: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

Line 940: rcv_error_pkg.set_token('VALUE', from_org_record.organization_id);

936:
937: /* po_core_s doesn't follow error paradigm */
938: IF (from_org_record.error_record.error_message = 'ORG_ID') THEN
939: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
940: rcv_error_pkg.set_token('VALUE', from_org_record.organization_id);
941: ELSIF(from_org_record.error_record.error_message = 'ORG_DISABLED') THEN
942: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
944: ELSE

Line 943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

939: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
940: rcv_error_pkg.set_token('VALUE', from_org_record.organization_id);
941: ELSIF(from_org_record.error_record.error_message = 'ORG_DISABLED') THEN
942: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
944: ELSE
945: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
946: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_id);
947: END IF;

Line 945: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);

941: ELSIF(from_org_record.error_record.error_message = 'ORG_DISABLED') THEN
942: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
944: ELSE
945: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
946: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_id);
947: END IF;
948: END IF;
949:

Line 946: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_id);

942: IF p_header_record.header_record.transaction_type = 'CANCEL' THEN
943: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
944: ELSE
945: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
946: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_id);
947: END IF;
948: END IF;
949:
950: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

Line 950: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

946: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_id);
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;

Line 993: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;

989: OR vendor_site_record.error_record.error_message = 'VEN_SITE_HOLD_PMT') THEN
990: IF p_header_record.header_record.asn_type = 'ASBN'
991: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
992: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
993: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
994: rcv_error_pkg.set_error_message('PO_INV_CR_INVALID_PAY_SITE', vendor_site_record.error_record.error_message);
995: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
996: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
997: ELSE

Line 994: rcv_error_pkg.set_error_message('PO_INV_CR_INVALID_PAY_SITE', vendor_site_record.error_record.error_message);

990: IF p_header_record.header_record.asn_type = 'ASBN'
991: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
992: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
993: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
994: rcv_error_pkg.set_error_message('PO_INV_CR_INVALID_PAY_SITE', vendor_site_record.error_record.error_message);
995: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
996: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
997: ELSE
998: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

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

991: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
992: vendor_site_record.error_record.error_message := 'PO_INV_CR_INVALID_PAY_SITE';
993: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_warning;
994: rcv_error_pkg.set_error_message('PO_INV_CR_INVALID_PAY_SITE', vendor_site_record.error_record.error_message);
995: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
996: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
997: ELSE
998: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
999: vendor_site_record.error_record.error_message := NULL;

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

994: rcv_error_pkg.set_error_message('PO_INV_CR_INVALID_PAY_SITE', vendor_site_record.error_record.error_message);
995: rcv_error_pkg.set_token('VENDOR_SITE_ID', vendor_site_record.vendor_site_id);
996: p_header_record.header_record.invoice_status_code := 'RCV_ASBN_NO_AUTO_INVOICE';
997: ELSE
998: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
999: vendor_site_record.error_record.error_message := NULL;
1000: END IF;
1001: ELSIF vendor_site_record.error_record.error_message = 'VEN_SITE_DISABLED' THEN
1002: /* Fix for bug 2830103.

Line 1008: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);

1004: ASNs and ASBNs. Hence adding the following IF condition
1005: below so that no validation happens for STD receipts.
1006: */
1007: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN') THEN
1008: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1009: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1010: ELSE
1011: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1012: vendor_site_record.error_record.error_message := NULL;

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

1005: below so that no validation happens for STD receipts.
1006: */
1007: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN') THEN
1008: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1009: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1010: ELSE
1011: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1012: vendor_site_record.error_record.error_message := NULL;
1013: END IF;

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

1007: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN') THEN
1008: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1009: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1010: ELSE
1011: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1012: vendor_site_record.error_record.error_message := NULL;
1013: END IF;
1014: ELSIF vendor_site_record.error_record.error_message IN('VEN_SITE_NOT_PURCH', 'VEN_SITE_ID') THEN
1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);

Line 1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);

1011: vendor_site_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1012: vendor_site_record.error_record.error_message := NULL;
1013: END IF;
1014: ELSIF vendor_site_record.error_record.error_message IN('VEN_SITE_NOT_PURCH', 'VEN_SITE_ID') THEN
1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1016: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1017: ELSIF vendor_site_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors
1019: END IF;

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

1012: vendor_site_record.error_record.error_message := NULL;
1013: END IF;
1014: ELSIF vendor_site_record.error_record.error_message IN('VEN_SITE_NOT_PURCH', 'VEN_SITE_ID') THEN
1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1016: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1017: ELSIF vendor_site_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors
1019: END IF;
1020:

Line 1017: ELSIF vendor_site_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1013: END IF;
1014: ELSIF vendor_site_record.error_record.error_message IN('VEN_SITE_NOT_PURCH', 'VEN_SITE_ID') THEN
1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1016: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1017: ELSIF vendor_site_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors
1019: END IF;
1020:
1021: p_header_record.error_record := vendor_site_record.error_record;

Line 1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors

1014: ELSIF vendor_site_record.error_record.error_message IN('VEN_SITE_NOT_PURCH', 'VEN_SITE_ID') THEN
1015: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR_SITE', vendor_site_record.error_record.error_message);
1016: rcv_error_pkg.set_token('VALUE', vendor_site_record.vendor_site_id);
1017: ELSIF vendor_site_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors
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,

Line 1022: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1018: rcv_error_pkg.set_error_message(vendor_site_record.error_record.error_message, vendor_site_record.error_record.error_message); -- to set any other errors
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:

Line 1049: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', loc_record.error_record.error_message);

1045:
1046: po_locations_s.validate_location_info(loc_record);
1047:
1048: IF loc_record.error_record.error_message IN('LOC_ID', 'LOC_DISABLED') THEN
1049: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', loc_record.error_record.error_message);
1050: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1051: ELSIF loc_record.error_record.error_message = 'LOC_NOT_RCV_SITE' THEN
1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);

Line 1050: rcv_error_pkg.set_token('VALUE', loc_record.location_id);

1046: po_locations_s.validate_location_info(loc_record);
1047:
1048: IF loc_record.error_record.error_message IN('LOC_ID', 'LOC_DISABLED') THEN
1049: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', loc_record.error_record.error_message);
1050: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1051: ELSIF loc_record.error_record.error_message = 'LOC_NOT_RCV_SITE' THEN
1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN

Line 1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);

1048: IF loc_record.error_record.error_message IN('LOC_ID', 'LOC_DISABLED') THEN
1049: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', loc_record.error_record.error_message);
1050: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1051: ELSIF loc_record.error_record.error_message = 'LOC_NOT_RCV_SITE' THEN
1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);

Line 1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);

1049: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', loc_record.error_record.error_message);
1050: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1051: ELSIF loc_record.error_record.error_message = 'LOC_NOT_RCV_SITE' THEN
1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);

Line 1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);

1051: ELSIF loc_record.error_record.error_message = 'LOC_NOT_RCV_SITE' THEN
1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors

Line 1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);

1052: rcv_error_pkg.set_error_message('RCV_LOC_NOT_RCV_SITE', loc_record.error_record.error_message);
1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors
1060: END IF;

Line 1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);

1053: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors
1060: END IF;
1061:

Line 1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1054: ELSIF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors
1060: END IF;
1061:
1062: p_header_record.error_record := loc_record.error_record;

Line 1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors

1055: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', loc_record.error_record.error_message);
1056: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1057: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1058: ELSIF loc_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors
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,

Line 1063: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1059: rcv_error_pkg.set_error_message(loc_record.error_record.error_message, loc_record.error_record.error_message); -- to set any other errors
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:

Line 1091: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);

1087: po_terms_sv.validate_payment_terms_info(pay_record);
1088:
1089: IF pay_record.error_record.error_message = 'PAY_TERMS_DISABLED' THEN
1090: IF p_header_record.header_record.asn_type = 'ASBN' THEN
1091: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1092: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1093: ELSE
1094: pay_record.error_record.error_message := NULL;
1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

Line 1092: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);

1088:
1089: IF pay_record.error_record.error_message = 'PAY_TERMS_DISABLED' THEN
1090: IF p_header_record.header_record.asn_type = 'ASBN' THEN
1091: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1092: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1093: ELSE
1094: pay_record.error_record.error_message := NULL;
1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1096: END IF;

Line 1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1091: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1092: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1093: ELSE
1094: pay_record.error_record.error_message := NULL;
1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1096: END IF;
1097: ELSIF pay_record.error_record.error_message = 'PAY_TERMS_ID' THEN
1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);

Line 1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);

1094: pay_record.error_record.error_message := NULL;
1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1096: END IF;
1097: ELSIF pay_record.error_record.error_message = 'PAY_TERMS_ID' THEN
1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1100: ELSIF pay_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors
1102: END IF;

Line 1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);

1095: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1096: END IF;
1097: ELSIF pay_record.error_record.error_message = 'PAY_TERMS_ID' THEN
1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1100: ELSIF pay_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors
1102: END IF;
1103:

Line 1100: ELSIF pay_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1096: END IF;
1097: ELSIF pay_record.error_record.error_message = 'PAY_TERMS_ID' THEN
1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1100: ELSIF pay_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors
1102: END IF;
1103:
1104: p_header_record.error_record := pay_record.error_record;

Line 1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors

1097: ELSIF pay_record.error_record.error_message = 'PAY_TERMS_ID' THEN
1098: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', pay_record.error_record.error_message);
1099: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1100: ELSIF pay_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors
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,

Line 1105: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1101: rcv_error_pkg.set_error_message(pay_record.error_record.error_message, pay_record.error_record.error_message); -- to set any other errors
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:

Line 1135: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', emp_record.error_record.error_message);

1131: asn_debug.put_line(emp_record.error_record.error_status);
1132: END IF;
1133:
1134: IF emp_record.error_record.error_message = 'RECEIVER_ID' THEN
1135: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', emp_record.error_record.error_message);
1136: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1137: ELSIF emp_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors
1139: END IF;

Line 1136: rcv_error_pkg.set_token('NAME', emp_record.employee_name);

1132: END IF;
1133:
1134: IF emp_record.error_record.error_message = 'RECEIVER_ID' THEN
1135: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', emp_record.error_record.error_message);
1136: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1137: ELSIF emp_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors
1139: END IF;
1140:

Line 1137: ELSIF emp_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1133:
1134: IF emp_record.error_record.error_message = 'RECEIVER_ID' THEN
1135: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', emp_record.error_record.error_message);
1136: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1137: ELSIF emp_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors
1139: END IF;
1140:
1141: p_header_record.error_record := emp_record.error_record;

Line 1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors

1134: IF emp_record.error_record.error_message = 'RECEIVER_ID' THEN
1135: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', emp_record.error_record.error_message);
1136: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1137: ELSIF emp_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors
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,

Line 1142: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1138: rcv_error_pkg.set_error_message(emp_record.error_record.error_message, emp_record.error_record.error_message); -- to set any other errors
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:

Line 1168: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', freight_record.error_record.error_message);

1164:
1165: po_terms_sv.validate_freight_carrier_info(freight_record);
1166:
1167: IF freight_record.error_record.error_message IN('CARRIER_DISABLED', 'CARRIER_INVALID') THEN
1168: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', freight_record.error_record.error_message);
1169: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1170: ELSIF freight_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors
1172: END IF;

Line 1169: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);

1165: po_terms_sv.validate_freight_carrier_info(freight_record);
1166:
1167: IF freight_record.error_record.error_message IN('CARRIER_DISABLED', 'CARRIER_INVALID') THEN
1168: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', freight_record.error_record.error_message);
1169: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1170: ELSIF freight_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors
1172: END IF;
1173:

Line 1170: ELSIF freight_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1166:
1167: IF freight_record.error_record.error_message IN('CARRIER_DISABLED', 'CARRIER_INVALID') THEN
1168: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', freight_record.error_record.error_message);
1169: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1170: ELSIF freight_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors
1172: END IF;
1173:
1174: p_header_record.error_record := freight_record.error_record;

Line 1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors

1167: IF freight_record.error_record.error_message IN('CARRIER_DISABLED', 'CARRIER_INVALID') THEN
1168: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', freight_record.error_record.error_message);
1169: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1170: ELSIF freight_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors
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,

Line 1175: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1171: rcv_error_pkg.set_error_message(freight_record.error_record.error_message, freight_record.error_record.error_message); -- to set any other errors
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:

Line 1195: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

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'
1198: );
1199:

Line 1212: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

1208: AND p_header_record.header_record.asn_type = 'ASBN' THEN
1209: IF p_header_record.header_record.shipment_num IS NULL
1210: AND -- Should we assign shipment_num to null.invoice_num
1211: p_header_record.header_record.invoice_num IS NULL THEN
1212: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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,

Line 1213: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_NUM', p_header_record.error_record.error_message);

1209: IF p_header_record.header_record.shipment_num IS NULL
1210: AND -- Should we assign shipment_num to null.invoice_num
1211: p_header_record.header_record.invoice_num IS NULL THEN
1212: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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',

Line 1216: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1212: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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:

Line 1232: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

1228: /* bug 628316 make sure invoice_date is not missing for ASBN */
1229: IF p_header_record.header_record.transaction_type <> 'CANCEL'
1230: AND p_header_record.header_record.asn_type = 'ASBN' THEN
1231: IF p_header_record.header_record.invoice_date IS NULL THEN
1232: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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,

Line 1233: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_DATE', p_header_record.error_record.error_message);

1229: IF p_header_record.header_record.transaction_type <> 'CANCEL'
1230: AND p_header_record.header_record.asn_type = 'ASBN' THEN
1231: IF p_header_record.header_record.invoice_date IS NULL THEN
1232: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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',

Line 1236: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1232: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
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:

Line 1256: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_TAX_NAME', tax_record.error_record.error_message);

1252: tax_record.error_record := p_header_record.error_record;
1253: po_locations_s.validate_tax_info(tax_record);
1254:
1255: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN
1256: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_TAX_NAME', tax_record.error_record.error_message);
1257: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1258: ELSIF tax_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors
1260: END IF;

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

1253: po_locations_s.validate_tax_info(tax_record);
1254:
1255: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN
1256: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_TAX_NAME', tax_record.error_record.error_message);
1257: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1258: ELSIF tax_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors
1260: END IF;
1261:

Line 1258: ELSIF tax_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN

1254:
1255: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN
1256: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_TAX_NAME', tax_record.error_record.error_message);
1257: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1258: ELSIF tax_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors
1260: END IF;
1261:
1262: p_header_record.error_record := tax_record.error_record;

Line 1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors

1255: IF tax_record.error_record.error_message IN('TAX_CODE_INVALID', 'TAX_CODE_DISABLED') THEN
1256: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_TAX_NAME', tax_record.error_record.error_message);
1257: rcv_error_pkg.set_token('VALUE', tax_record.tax_name);
1258: ELSIF tax_record.error_record.error_status <> rcv_error_pkg.g_ret_sts_success THEN
1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors
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,

Line 1263: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1259: rcv_error_pkg.set_error_message(tax_record.error_record.error_message, tax_record.error_record.error_message); -- to set any other errors
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;

Line 1276: rcv_error_pkg.log_interface_message(p_header_record.error_record.error_status,

1272: END IF;
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:

Line 1310: WHEN rcv_error_pkg.e_fatal_error THEN

1306: IF (g_asn_debug = 'Y') THEN
1307: asn_debug.put_line('Other Validations');
1308: END IF;
1309: EXCEPTION
1310: WHEN rcv_error_pkg.e_fatal_error THEN
1311: NULL;
1312: END validate_shipment_header;
1313:
1314: PROCEDURE validate_invoice_amount(

Line 1334: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

1330: FETCH c INTO x_inv_rec;
1331:
1332: IF NVL(x_inv_rec.invoice_amount_limit, 0) > 0 THEN
1333: IF x_inv_rec.invoice_amount_limit < p_inv_rec.total_invoice_amount THEN
1334: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1335: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_AMT_LIMIT', p_inv_rec.error_record.error_message);
1336: rcv_error_pkg.set_token('AMOUNT', p_inv_rec.total_invoice_amount);
1337: END IF;
1338: END IF;

Line 1335: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_AMT_LIMIT', p_inv_rec.error_record.error_message);

1331:
1332: IF NVL(x_inv_rec.invoice_amount_limit, 0) > 0 THEN
1333: IF x_inv_rec.invoice_amount_limit < p_inv_rec.total_invoice_amount THEN
1334: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1335: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_AMT_LIMIT', p_inv_rec.error_record.error_message);
1336: rcv_error_pkg.set_token('AMOUNT', p_inv_rec.total_invoice_amount);
1337: END IF;
1338: END IF;
1339: END IF;

Line 1336: rcv_error_pkg.set_token('AMOUNT', p_inv_rec.total_invoice_amount);

1332: IF NVL(x_inv_rec.invoice_amount_limit, 0) > 0 THEN
1333: IF x_inv_rec.invoice_amount_limit < p_inv_rec.total_invoice_amount THEN
1334: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1335: rcv_error_pkg.set_error_message('RCV_ASBN_INVOICE_AMT_LIMIT', p_inv_rec.error_record.error_message);
1336: rcv_error_pkg.set_token('AMOUNT', p_inv_rec.total_invoice_amount);
1337: END IF;
1338: END IF;
1339: END IF;
1340: EXCEPTION

Line 1342: rcv_error_pkg.set_sql_error_message('validate_invoice_amount', '000');

1338: END IF;
1339: END IF;
1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: rcv_error_pkg.set_sql_error_message('validate_invoice_amount', '000');
1343: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1344: p_inv_rec.error_record.error_message := rcv_error_pkg.get_last_message;
1345: END validate_invoice_amount;
1346:

Line 1343: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1339: END IF;
1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: rcv_error_pkg.set_sql_error_message('validate_invoice_amount', '000');
1343: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1344: p_inv_rec.error_record.error_message := rcv_error_pkg.get_last_message;
1345: END validate_invoice_amount;
1346:
1347: PROCEDURE insert_shipment_header(

Line 1344: p_inv_rec.error_record.error_message := rcv_error_pkg.get_last_message;

1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: rcv_error_pkg.set_sql_error_message('validate_invoice_amount', '000');
1343: p_inv_rec.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1344: p_inv_rec.error_record.error_message := rcv_error_pkg.get_last_message;
1345: END validate_invoice_amount;
1346:
1347: PROCEDURE insert_shipment_header(
1348: p_header_record IN OUT NOCOPY rcv_shipment_header_sv.headerrectype

Line 1522: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');

1518: p_header_record.header_record.ship_from_location_id
1519: );
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1523: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1524: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1525: END insert_shipment_header;
1526:

Line 1523: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1519: );
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1523: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1524: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1525: END insert_shipment_header;
1526:
1527: /*===========================================================================+

Line 1524: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1523: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1524: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1525: END insert_shipment_header;
1526:
1527: /*===========================================================================+
1528: | |

Line 1623: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');

1619: END IF;
1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1624: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1625: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1626: END derive_ship_to_org_from_rti;
1627:

Line 1624: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1620: END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1624: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1625: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1626: END derive_ship_to_org_from_rti;
1627:
1628: /* ksareddy - 2506961 - need to support automatic receipt in parallel processing

Line 1625: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: rcv_error_pkg.set_sql_error_message('insert_shipment_header', '000');
1624: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1625: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
1626: END derive_ship_to_org_from_rti;
1627:
1628: /* ksareddy - 2506961 - need to support automatic receipt in parallel processing
1629: lock and release the rcv_parameters table only to get the receipt number