eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_HEADER_COMMON dependencies on RCV_ERROR_PKG

Line 667: rcv_error_pkg.set_error_message('RCV_NO_OPTION', p_header_record.error_record.error_message);

663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('NO_DATA_FOUND exception occured. Receiving options are not defined for organization = ' || p_header_record.header_record.ship_to_organization_id);
665: END IF;
666: p_header_record.error_record.error_status := 'E';
667: rcv_error_pkg.set_error_message('RCV_NO_OPTION', p_header_record.error_record.error_message);
668: rcv_error_pkg.set_token('ORG', p_header_record.header_record.ship_to_organization_id);
669: -- End of code for bugfix #4070516
670: WHEN OTHERS THEN
671: p_header_record.error_record.error_status := 'E';

Line 668: rcv_error_pkg.set_token('ORG', p_header_record.header_record.ship_to_organization_id);

664: asn_debug.put_line('NO_DATA_FOUND exception occured. Receiving options are not defined for organization = ' || p_header_record.header_record.ship_to_organization_id);
665: END IF;
666: p_header_record.error_record.error_status := 'E';
667: rcv_error_pkg.set_error_message('RCV_NO_OPTION', p_header_record.error_record.error_message);
668: rcv_error_pkg.set_token('ORG', p_header_record.header_record.ship_to_organization_id);
669: -- End of code for bugfix #4070516
670: WHEN OTHERS THEN
671: p_header_record.error_record.error_status := 'E';
672: p_header_record.error_record.error_message := SQLERRM;

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

805: lookup_record.error_record.error_message := NULL; --p_header_record.error_record.error_message;
806: po_core_s.validate_lookup_info(lookup_record);
807:
808: IF (lookup_record.error_record.error_status <> 'S') THEN
809: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
810: rcv_error_pkg.set_error_message('RCV_TRX_TYPE_INVALID', p_header_record.error_record.error_message);
811: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;

Line 810: rcv_error_pkg.set_error_message('RCV_TRX_TYPE_INVALID', p_header_record.error_record.error_message);

806: po_core_s.validate_lookup_info(lookup_record);
807:
808: IF (lookup_record.error_record.error_status <> 'S') THEN
809: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
810: rcv_error_pkg.set_error_message('RCV_TRX_TYPE_INVALID', p_header_record.error_record.error_message);
811: rcv_error_pkg.set_token('TYPE', lookup_record.lookup_code);
812: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
813: END IF;
814:

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

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

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

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

Line 819: WHEN rcv_error_pkg.e_fatal_error THEN

815: IF (g_asn_debug = 'Y') THEN
816: asn_debug.put_line('validated transaction type');
817: END IF;
818: EXCEPTION
819: WHEN rcv_error_pkg.e_fatal_error THEN
820: NULL;
821: END validate_trx_type;
822:
823: PROCEDURE validate_expected_receipt_date(

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

836: */
837: IF (p_header_record.header_record.transaction_type <> 'CANCEL') THEN
838: IF (p_header_record.header_record.expected_receipt_date IS NULL and
839: p_header_record.header_record.asn_type <> 'WC') THEN
840: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
841: rcv_error_pkg.set_error_message('RCV_ASN_EXPECTED_RECEIPT_DATE', p_header_record.error_record.error_message);
842: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EXPECTED_RECEIPT_DATE');
843: END IF;
844: END IF;

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

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

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

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

Line 850: WHEN rcv_error_pkg.e_fatal_error THEN

846: IF (g_asn_debug = 'Y') THEN
847: asn_debug.put_line('validated expected_receipt_date is not missing');
848: END IF;
849: EXCEPTION
850: WHEN rcv_error_pkg.e_fatal_error THEN
851: NULL;
852: END validate_expected_receipt_date;
853:
854: PROCEDURE validate_receipt_num(

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

870: /* Bug 3590735.
871: * When we error out with receipt number mandatory error,
872: * we need to set this error in po_interface_errors.
873: */
874: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
875: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
876: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
877: END IF;
878:

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

871: * When we error out with receipt number mandatory error,
872: * we need to set this error in po_interface_errors.
873: */
874: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
875: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
876: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
877: END IF;
878:
879: IF p_header_record.header_record.receipt_header_id IS NULL

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

872: * we need to set this error in po_interface_errors.
873: */
874: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
875: rcv_error_pkg.set_error_message('RCV_RECEIPT_NUM_REQ', p_header_record.error_record.error_message);
876: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
877: END IF;
878:
879: IF p_header_record.header_record.receipt_header_id IS NULL
880: AND -- bug 3508507: only check receipt_num uniqueness for new reciepts

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

887: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
888: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
889:
890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
892: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;

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

888: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
889:
890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
892: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:

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

889:
890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
892: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:
897: IF (g_asn_debug = 'Y') THEN

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

890: IF x_count > 0 THEN
891: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
892: rcv_error_pkg.set_error_message('PO_PDOI_RECEIPT_NUM_UNIQUE', p_header_record.error_record.error_message);
893: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.receipt_num);
894: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'RECEIPT_NUM');
895: END IF;
896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('validated receipt number');

Line 902: WHEN rcv_error_pkg.e_fatal_error THEN

898: asn_debug.put_line('validated receipt number');
899: END IF;
900: END IF;
901: EXCEPTION
902: WHEN rcv_error_pkg.e_fatal_error THEN
903: NULL;
904: END validate_receipt_num;
905:
906: PROCEDURE validate_ship_to_org_info(

Line 918: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

914:
915: IF p_header_record.header_record.asn_type IN('ASN', 'ASBN', 'STD', 'LCM') THEN /* lcm changes */
916: ship_to_org_record.organization_code := p_header_record.header_record.ship_to_organization_code;
917: ship_to_org_record.organization_id := p_header_record.header_record.ship_to_organization_id;
918: ship_to_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
919: ship_to_org_record.error_record.error_message := NULL;
920:
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('In Validate Ship to Organization Procedure');

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

930: IF (g_asn_debug = 'Y') THEN
931: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
932: END IF;
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;

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

931: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
932: END IF;
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE

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

932: END IF;
933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

933:
934: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_SHIPTO_ORG_DISABLED', p_header_record.error_record.error_message);
936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);

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

936: rcv_error_pkg.set_token('ORGANIZATION', ship_to_org_record.organization_id);
937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
942: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;

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

937: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
942: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;
945: END IF;

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

938: END IF;
939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
942: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;
945: END IF;
946:

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

939: ELSE
940: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
941: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_ORG_ID', p_header_record.error_record.error_message);
942: rcv_error_pkg.set_token('VALUE', ship_to_org_record.organization_id);
943: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_TO_ORGANIZATION_ID');
944: END IF;
945: END IF;
946:
947: IF (g_asn_debug = 'Y') THEN

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

984: IF (g_asn_debug = 'Y') THEN
985: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
986: END IF;
987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE

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

985: asn_debug.put_line('Atleast one of the RTIs has a different org id/code than that of the header');
986: END IF;
987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE
993: IF (g_asn_debug = 'Y') THEN

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

986: END IF;
987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE
993: IF (g_asn_debug = 'Y') THEN
994: asn_debug.put_line('In the ELSE part');

Line 991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');

987:
988: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
989: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
990: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
991: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
992: ELSE
993: IF (g_asn_debug = 'Y') THEN
994: asn_debug.put_line('In the ELSE part');
995: END IF;

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

1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1048: END IF;
1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1051: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
1052: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1054: END IF;

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

1047: asn_debug.put_line('For one of the RTI records a different org id/code is derived');
1048: END IF;
1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1051: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
1052: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1054: END IF;
1055: END IF;

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

1048: END IF;
1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1051: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
1052: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1054: END IF;
1055: END IF;
1056:

Line 1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');

1049:
1050: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1051: rcv_error_pkg.set_error_message('RCV_MUL_DESTN_ORGS_FOR_LINES', p_header_record.error_record.error_message);
1052: rcv_error_pkg.set_token('VALUE', p_header_record.header_record.ship_to_organization_id);
1053: rcv_error_pkg.log_interface_error('SHIP_TO_ORGANIZATION_ID');
1054: END IF;
1055: END IF;
1056:
1057: IF (g_asn_debug = 'Y') THEN

Line 1064: WHEN rcv_error_pkg.e_fatal_error THEN

1060: END IF;
1061: END IF; --End of bug# 3662698.
1062:
1063: EXCEPTION
1064: WHEN rcv_error_pkg.e_fatal_error THEN
1065: NULL;
1066: END validate_ship_to_org_info;
1067:
1068: PROCEDURE validate_from_org_info(

Line 1082: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1078: IF from_org_record.organization_code IS NOT NULL
1079: OR from_org_record.organization_id IS NOT NULL THEN
1080: from_org_record.organization_code := p_header_record.header_record.from_organization_code;
1081: from_org_record.organization_id := p_header_record.header_record.from_organization_id;
1082: from_org_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1083: from_org_record.error_record.error_message := NULL;
1084:
1085: IF (g_asn_debug = 'Y') THEN
1086: asn_debug.put_line('In Validate From Organization Procedure');

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

1094: IF (g_asn_debug = 'Y') THEN
1095: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1096: END IF;
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;

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

1095: asn_debug.put_line('Error with RCV_SHIPTO_ORG_DISABLED');
1096: END IF;
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE

Line 1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);

1096: END IF;
1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE
1104: IF (g_asn_debug = 'Y') THEN

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

1097:
1098: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1099: rcv_error_pkg.set_error_message('RCV_FROM_ORG_DISABLED', p_header_record.error_record.error_message);
1100: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1101: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1102: END IF;
1103: ELSE
1104: IF (g_asn_debug = 'Y') THEN
1105: asn_debug.put_line('Error with from ORG_ID');

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

1104: IF (g_asn_debug = 'Y') THEN
1105: asn_debug.put_line('Error with from ORG_ID');
1106: END IF;
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;

Line 1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);

1105: asn_debug.put_line('Error with from ORG_ID');
1106: END IF;
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;
1113: END IF;

Line 1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);

1106: END IF;
1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;
1113: END IF;
1114:

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

1107:
1108: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1109: rcv_error_pkg.set_error_message('RCV_FROM_ORG_ID', p_header_record.error_record.error_message);
1110: rcv_error_pkg.set_token('ORGANIZATION', from_org_record.organization_code);
1111: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FROM_ORGANIZATION_ID');
1112: END IF;
1113: END IF;
1114:
1115: IF (g_asn_debug = 'Y') THEN

Line 1121: WHEN rcv_error_pkg.e_fatal_error THEN

1117: END IF;
1118: END IF;
1119: END IF;
1120: EXCEPTION
1121: WHEN rcv_error_pkg.e_fatal_error THEN
1122: NULL;
1123: END validate_from_org_info;
1124:
1125: PROCEDURE validate_location_info(

Line 1141: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1137: OR p_header_record.header_record.location_id IS NOT NULL) THEN
1138: loc_record.location_code := p_header_record.header_record.location_code;
1139: loc_record.location_id := p_header_record.header_record.location_id;
1140: loc_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1141: loc_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1142: loc_record.error_record.error_message := NULL;
1143:
1144: IF (g_asn_debug = 'Y') THEN
1145: asn_debug.put_line('In Validate Location Code Procedure');

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

1148: po_locations_s.validate_location_info(loc_record);
1149:
1150: IF loc_record.error_record.error_status <> 'S' THEN
1151: IF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');

Line 1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);

1149:
1150: IF loc_record.error_record.error_status <> 'S' THEN
1151: IF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE

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

1150: IF loc_record.error_record.error_status <> 'S' THEN
1151: IF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

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

1151: IF loc_record.error_record.error_message = 'LOC_NOT_IN_ORG' THEN
1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);

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

1152: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1153: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);

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

1154: rcv_error_pkg.set_token('LOCATION', loc_record.location_id);
1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;

Line 1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);

1155: rcv_error_pkg.set_token('ORGANIZATION', loc_record.organization_id);
1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;
1163: END IF;

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

1156: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;
1163: END IF;
1164:

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

1157: ELSE
1158: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1159: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_SHIP_TO_LOC_ID', p_header_record.error_record.error_message);
1160: rcv_error_pkg.set_token('VALUE', loc_record.location_id);
1161: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'LOCATION_ID');
1162: END IF;
1163: END IF;
1164:
1165: IF (g_asn_debug = 'Y') THEN

Line 1172: WHEN rcv_error_pkg.e_fatal_error THEN

1168: asn_debug.put_line('Validated location info');
1169: END IF;
1170: END IF;
1171: EXCEPTION
1172: WHEN rcv_error_pkg.e_fatal_error THEN
1173: NULL;
1174: END validate_location_info;
1175:
1176: PROCEDURE validate_ship_from_loc_info(

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

1219: IF (nvl(l_shipping_control,'@@@') = 'BUYER' AND p_header_record.header_record.ship_from_location_id IS NULL) THEN
1220: IF (g_asn_debug = 'Y') THEN
1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1226: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1227:

Line 1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');

1220: IF (g_asn_debug = 'Y') THEN
1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1226: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1227:
1228: END IF;

Line 1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);

1221: asn_debug.put_line('Ship from location id cannot be null if shipping_control is BUYER');
1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1226: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1227:
1228: END IF;
1229: --End Bug 5263268

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

1222: END IF;
1223: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1224: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE');
1225: rcv_error_pkg.set_token('ROI_VALUE',p_header_record.header_record.ship_from_location_id);
1226: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1227:
1228: END IF;
1229: --End Bug 5263268
1230:

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

1244: x_msg_data
1245: );
1246:
1247: IF (x_out_rec.is_valid = FALSE) THEN
1248: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;

Line 1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);

1245: );
1246:
1247: IF (x_out_rec.is_valid = FALSE) THEN
1248: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:

Line 1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);

1246:
1247: IF (x_out_rec.is_valid = FALSE) THEN
1248: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:
1254: IF (g_asn_debug = 'Y') THEN

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

1247: IF (x_out_rec.is_valid = FALSE) THEN
1248: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1249: rcv_error_pkg.set_error_message('RCV_LOC_NOT_IN_ORG', p_header_record.error_record.error_message);
1250: rcv_error_pkg.set_token('LOCATION', p_header_record.header_record.ship_from_location_id);
1251: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIP_FROM_LOCATION_ID');
1252: END IF;
1253:
1254: IF (g_asn_debug = 'Y') THEN
1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);

Line 1259: WHEN rcv_error_pkg.e_fatal_error THEN

1255: asn_debug.put_line('Validated location info with status=' || p_header_record.error_record.error_status);
1256: END IF;
1257: END IF;
1258: EXCEPTION
1259: WHEN rcv_error_pkg.e_fatal_error THEN
1260: NULL;
1261: END validate_ship_from_loc_info;
1262:
1263: PROCEDURE validate_payment_terms_info(

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

1273: OR p_header_record.header_record.payment_terms_id IS NOT NULL)
1274: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN
1275: pay_record.payment_term_id := p_header_record.header_record.payment_terms_id;
1276: pay_record.payment_term_name := p_header_record.header_record.payment_terms_name;
1277: pay_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1278: pay_record.error_record.error_message := NULL;
1279:
1280: IF (g_asn_debug = 'Y') THEN
1281: asn_debug.put_line('In Validate Payment Terms ');

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

1288: pay_record.error_record.error_status := 'S';
1289: END IF;
1290:
1291: IF pay_record.error_record.error_status <> 'S' THEN
1292: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;

Line 1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);

1289: END IF;
1290:
1291: IF pay_record.error_record.error_status <> 'S' THEN
1292: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:

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

1290:
1291: IF pay_record.error_record.error_status <> 'S' THEN
1292: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:
1298: IF (g_asn_debug = 'Y') THEN

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

1291: IF pay_record.error_record.error_status <> 'S' THEN
1292: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1293: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_PAY_TERMS', p_header_record.error_record.error_message);
1294: rcv_error_pkg.set_token('VALUE', pay_record.payment_term_id);
1295: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'PAYMENT_TERMS_ID');
1296: END IF;
1297:
1298: IF (g_asn_debug = 'Y') THEN
1299: asn_debug.put_line(pay_record.error_record.error_status);

Line 1307: WHEN rcv_error_pkg.e_fatal_error THEN

1303: asn_debug.put_line('Validated payment info');
1304: END IF;
1305: END IF;
1306: EXCEPTION
1307: WHEN rcv_error_pkg.e_fatal_error THEN
1308: NULL;
1309: END validate_payment_terms_info;
1310:
1311: PROCEDURE validate_receiver_info(

Line 1326: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1322: AND ( p_header_record.header_record.employee_name IS NOT NULL
1323: OR p_header_record.header_record.employee_id IS NOT NULL) THEN
1324: emp_record.employee_name := p_header_record.header_record.employee_name;
1325: emp_record.employee_id := p_header_record.header_record.employee_id;
1326: emp_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1327: emp_record.error_record.error_message := NULL;
1328:
1329: IF (g_asn_debug = 'Y') THEN
1330: asn_debug.put_line('In Validate Receiver Information');

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

1336: asn_debug.put_line(emp_record.error_record.error_status);
1337: END IF;
1338:
1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;

Line 1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);

1337: END IF;
1338:
1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:

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

1338:
1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:
1346: IF (g_asn_debug = 'Y') THEN

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

1339: IF emp_record.error_record.error_status <> 'S' THEN
1340: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1341: rcv_error_pkg.set_error_message('RCV_RECEIVER_ID', p_header_record.error_record.error_message);
1342: rcv_error_pkg.set_token('NAME', emp_record.employee_name);
1343: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'EMPLOYEE_ID');
1344: END IF;
1345:
1346: IF (g_asn_debug = 'Y') THEN
1347: asn_debug.put_line('Validated receiver info');

Line 1351: WHEN rcv_error_pkg.e_fatal_error THEN

1347: asn_debug.put_line('Validated receiver info');
1348: END IF;
1349: END IF;
1350: EXCEPTION
1351: WHEN rcv_error_pkg.e_fatal_error THEN
1352: NULL;
1353: END validate_receiver_info;
1354:
1355: PROCEDURE validate_freight_carrier_info(

Line 1370: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;

1366: IF p_header_record.header_record.transaction_type <> 'CANCEL'
1367: AND p_header_record.header_record.freight_carrier_code IS NOT NULL THEN
1368: freight_record.freight_carrier_code := p_header_record.header_record.freight_carrier_code;
1369: freight_record.organization_id := p_header_record.header_record.ship_to_organization_id;
1370: freight_record.error_record.error_status := rcv_error_pkg.g_ret_sts_success;
1371: freight_record.error_record.error_message := NULL;
1372:
1373: IF (g_asn_debug = 'Y') THEN
1374: asn_debug.put_line('In Validate Freight Carrier Information');

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

1376:
1377: po_terms_sv.validate_freight_carrier_info(freight_record);
1378:
1379: IF freight_record.error_record.error_status <> 'S' THEN
1380: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;

Line 1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);

1377: po_terms_sv.validate_freight_carrier_info(freight_record);
1378:
1379: IF freight_record.error_record.error_status <> 'S' THEN
1380: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:

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

1378:
1379: IF freight_record.error_record.error_status <> 'S' THEN
1380: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN

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

1379: IF freight_record.error_record.error_status <> 'S' THEN
1380: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1381: rcv_error_pkg.set_error_message('RCV_CARRIER_DISABLED', p_header_record.error_record.error_message);
1382: rcv_error_pkg.set_token('CARRIER', freight_record.freight_carrier_code);
1383: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'FREIGHT_CARRIER_CODE');
1384: END IF;
1385:
1386: IF (g_asn_debug = 'Y') THEN
1387: asn_debug.put_line(freight_record.error_record.error_status);

Line 1392: WHEN rcv_error_pkg.e_fatal_error THEN

1388: asn_debug.put_line('Validated freight carrier info');
1389: END IF;
1390: END IF;
1391: EXCEPTION
1392: WHEN rcv_error_pkg.e_fatal_error THEN
1393: NULL;
1394: END validate_freight_carrier_info;
1395:
1396: PROCEDURE validate_shipment_date(

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

1417: asn_debug.put_line('Shipped date can be blank for STD '||
1418: 'or Work Confirmations ');
1419: END IF;
1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1422: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;

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

1418: 'or Work Confirmations ');
1419: END IF;
1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1422: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;
1426: END IF;

Line 1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));

1419: END IF;
1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1422: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;
1426: END IF;
1427:

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

1420: ELSE
1421: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1422: rcv_error_pkg.set_error_message('RCV_SHIP_DATE_INVALID', p_header_record.error_record.error_message);
1423: rcv_error_pkg.set_token('SHIP_DATE', fnd_date.date_to_chardate(p_header_record.header_record.shipped_date));
1424: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPPED_DATE');
1425: END IF;
1426: END IF;
1427:
1428: IF (g_asn_debug = 'Y') THEN

Line 1432: WHEN rcv_error_pkg.e_fatal_error THEN

1428: IF (g_asn_debug = 'Y') THEN
1429: asn_debug.put_line('validated for shipment_date > system date');
1430: END IF;
1431: EXCEPTION
1432: WHEN rcv_error_pkg.e_fatal_error THEN
1433: NULL;
1434: END validate_shipment_date;
1435:
1436: PROCEDURE validate_item(

Line 1449: x_error_status := rcv_error_pkg.g_ret_sts_error;

1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);
1447: BEGIN
1448: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);
1449: x_error_status := rcv_error_pkg.g_ret_sts_error;
1450:
1451: SELECT NVL(MAX(inventory_item_id), -9999)
1452: INTO x_inventory_item
1453: FROM mtl_system_items

Line 1457: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

1453: FROM mtl_system_items
1454: WHERE inventory_item_id = x_cascaded_table(n).item_id;
1455:
1456: IF (x_inventory_item = -9999) THEN
1457: rcv_error_pkg.set_error_message('RCV_ITEM_ID');
1458: RAISE e_validation_error;
1459: END IF;
1460:
1461: SELECT NVL(MAX(inventory_item_id), -9999)

Line 1468: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');

1464: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
1465: AND inventory_item_id = x_cascaded_table(n).item_id;
1466:
1467: IF (x_inventory_item = -9999) THEN
1468: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
1469: RAISE e_validation_error;
1470: END IF;
1471:
1472: -- Bugfix 5735599

Line 1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1494: IF (g_asn_debug = 'Y') THEN
1495: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1496: END IF;
1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');
1500: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1501: rcv_error_pkg.log_interface_error('ITEM', TRUE);
1502:

Line 1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');

1495: asn_debug.put_line('Error occured while checking inactive item in rcv_roi_header_common procedure. Error :: ' || SQLERRM );
1496: END IF;
1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');
1500: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1501: rcv_error_pkg.log_interface_error('ITEM', TRUE);
1502:
1503: RETURN;

Line 1500: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1496: END IF;
1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');
1500: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1501: rcv_error_pkg.log_interface_error('ITEM', TRUE);
1502:
1503: RETURN;
1504: END;

Line 1501: rcv_error_pkg.log_interface_error('ITEM', TRUE);

1497:
1498: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1499: rcv_error_pkg.set_sql_error_message('rcv_roi_header_common.validate_item', '000');
1500: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1501: rcv_error_pkg.log_interface_error('ITEM', TRUE);
1502:
1503: RETURN;
1504: END;
1505:

Line 1511: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');

1507:
1508: IF l_inventory_item_flag = 'Y' AND l_stock_enabled_flag = 'N' AND
1509: (x_cascaded_table(n).auto_transact_code = 'DELIVER' OR x_cascaded_table(n).transaction_type = 'DELIVER')
1510: THEN
1511: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ACTIVE');
1512: RAISE e_validation_error;
1513: END IF;
1514:
1515: -- End of code for Bugfix 5735599

Line 1532: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');

1528: WHERE inventory_item_id = x_cascaded_table(n).item_id
1529: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1530:
1531: IF (x_organization_id = -9999) THEN
1532: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_IN_ORG');
1533: RAISE e_validation_error;
1534: END IF;
1535:
1536: -- do these checks only for PO based transactions

Line 1545: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');

1541: WHERE po_line_id = x_cascaded_table(n).po_line_id
1542: AND item_id = x_cascaded_table(n).item_id;
1543:
1544: IF (x_item_id_po = -9999) THEN
1545: rcv_error_pkg.set_error_message('RCV_ITEM_NOT_ON_PO');
1546: RAISE e_validation_error;
1547: END IF;
1548:
1549: SELECT NVL(MAX(item_id), -9999)

Line 1556: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');

1552: WHERE po_line_id = x_cascaded_table(n).po_line_id
1553: AND item_id = x_cascaded_table(n).item_id;
1554:
1555: IF (x_item_id_po <> x_cascaded_table(n).item_id) THEN
1556: rcv_error_pkg.set_error_message('RCV_NOT_PO_LINE_NUM');
1557: RAISE e_validation_error;
1558: END IF;
1559: END IF; --}
1560:

Line 1570: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1566: END IF;
1567: EXCEPTION
1568: WHEN e_validation_error THEN
1569: x_cascaded_table(n).error_status := x_error_status;
1570: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1571:
1572: IF x_cascaded_table(n).error_message = 'RCV_ITEM_ID' THEN
1573: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1574: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ACTIVE' THEN

Line 1573: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);

1569: x_cascaded_table(n).error_status := x_error_status;
1570: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1571:
1572: IF x_cascaded_table(n).error_message = 'RCV_ITEM_ID' THEN
1573: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1574: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ACTIVE' THEN
1575: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1576: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_IN_ORG' THEN
1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);

Line 1575: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);

1571:
1572: IF x_cascaded_table(n).error_message = 'RCV_ITEM_ID' THEN
1573: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1574: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ACTIVE' THEN
1575: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1576: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_IN_ORG' THEN
1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN

Line 1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);

1573: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1574: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ACTIVE' THEN
1575: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1576: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_IN_ORG' THEN
1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN
1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);

Line 1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);

1574: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ACTIVE' THEN
1575: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1576: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_IN_ORG' THEN
1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN
1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1582: ELSIF x_cascaded_table(n).error_message = 'RCV_NOT_PO_LINE_NUM' THEN

Line 1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);

1576: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_IN_ORG' THEN
1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN
1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1582: ELSIF x_cascaded_table(n).error_message = 'RCV_NOT_PO_LINE_NUM' THEN
1583: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
1584: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_cascaded_table(n).item_id);

Line 1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);

1577: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1578: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN
1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1582: ELSIF x_cascaded_table(n).error_message = 'RCV_NOT_PO_LINE_NUM' THEN
1583: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
1584: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_cascaded_table(n).item_id);
1585: END IF;

Line 1583: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);

1579: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_NOT_ON_PO' THEN
1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1582: ELSIF x_cascaded_table(n).error_message = 'RCV_NOT_PO_LINE_NUM' THEN
1583: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
1584: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_cascaded_table(n).item_id);
1585: END IF;
1586: END validate_item;
1587:

Line 1584: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_cascaded_table(n).item_id);

1580: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_id);
1581: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1582: ELSIF x_cascaded_table(n).error_message = 'RCV_NOT_PO_LINE_NUM' THEN
1583: rcv_error_pkg.set_token('PO_ITEM', x_item_id_po);
1584: rcv_error_pkg.set_token('SHIPMENT_ITEM', x_cascaded_table(n).item_id);
1585: END IF;
1586: END validate_item;
1587:
1588: PROCEDURE validate_substitute_item(

Line 1598: x_error_status := rcv_error_pkg.g_ret_sts_error;

1594: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
1595: x_error_status VARCHAR2(1);
1596: x_allow_sub_flag VARCHAR2(1);
1597: BEGIN
1598: x_error_status := rcv_error_pkg.g_ret_sts_error;
1599:
1600: SELECT NVL(MAX(inventory_item_id), 0)
1601: INTO x_inventory_item
1602: FROM mtl_system_items

Line 1607: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_ID');

1603: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1604: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1605:
1606: IF (x_inventory_item = 0) THEN
1607: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_ID');
1608: RAISE e_validation_error;
1609: END IF;
1610:
1611: SELECT NVL(MAX(inventory_item_id), 0)

Line 1619: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ACTIVE');

1615: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1616: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1617:
1618: IF (x_inventory_item = 0) THEN
1619: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ACTIVE');
1620: RAISE e_validation_error;
1621: END IF;
1622:
1623: -- do these checks only for PO based transactions

Line 1656: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ALLOWED');

1652: SELECT allow_substitute_receipts_flag
1653: FROM po_line_locations
1654: WHERE line_location_id = x_cascaded_table(n).po_line_location_id);
1655: IF (x_allow_sub_flag = 'N') THEN
1656: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_ALLOWED');
1657: RAISE e_validation_error;
1658: END IF;
1659:
1660: SELECT NVL(MAX(inventory_item_id), 0)

Line 1667: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_IN_ORG');

1663: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1664: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1665:
1666: IF (x_inventory_item = 0) THEN
1667: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_IN_ORG');
1668: RAISE e_validation_error;
1669: END IF;
1670:
1671: SELECT NVL(MAX(vendor_id), 0)

Line 1678: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_VEN_NOT_ALLOWED');

1674: WHERE vendor_id = x_cascaded_table(n).vendor_id
1675: AND allow_substitute_receipts_flag = 'Y';
1676:
1677: IF (x_vendor_id = 0) THEN
1678: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_VEN_NOT_ALLOWED');
1679: RAISE e_validation_error;
1680: END IF;
1681:
1682: -- Need to check for related items if reciprocal_flag is set

Line 1742: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_RELATED');

1738:
1739: END IF;
1740:
1741: IF (x_inventory_item = 0) THEN
1742: rcv_error_pkg.set_error_message('RCV_ITEM_SUB_NOT_RELATED');
1743: RAISE e_validation_error;
1744: END IF;
1745: END IF; --}
1746: EXCEPTION

Line 1749: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1745: END IF; --}
1746: EXCEPTION
1747: WHEN e_validation_error THEN
1748: x_cascaded_table(n).error_status := x_error_status;
1749: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1750:
1751: IF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_ID' THEN
1752: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1753: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ACTIVE' THEN

Line 1752: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

1748: x_cascaded_table(n).error_status := x_error_status;
1749: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1750:
1751: IF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_ID' THEN
1752: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1753: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ACTIVE' THEN
1754: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1755: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ALLOWED' THEN
1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

Line 1754: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

1750:
1751: IF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_ID' THEN
1752: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1753: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ACTIVE' THEN
1754: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1755: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ALLOWED' THEN
1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1757: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_IN_ORG' THEN
1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

Line 1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

1752: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1753: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ACTIVE' THEN
1754: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1755: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ALLOWED' THEN
1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1757: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_IN_ORG' THEN
1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN

Line 1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

1754: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1755: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ALLOWED' THEN
1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1757: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_IN_ORG' THEN
1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN
1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);

Line 1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);

1755: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_ALLOWED' THEN
1756: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1757: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_IN_ORG' THEN
1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN
1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);
1763: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_RELATED' THEN

Line 1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);

1757: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_IN_ORG' THEN
1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN
1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);
1763: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_RELATED' THEN
1764: rcv_error_pkg.set_token('SUB_ITEM', x_cascaded_table(n).substitute_item_id);
1765: rcv_error_pkg.set_token('ITEM', x_inventory_item);

Line 1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);

1758: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1759: rcv_error_pkg.set_token('ORGANIZATION', x_cascaded_table(n).to_organization_id);
1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN
1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);
1763: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_RELATED' THEN
1764: rcv_error_pkg.set_token('SUB_ITEM', x_cascaded_table(n).substitute_item_id);
1765: rcv_error_pkg.set_token('ITEM', x_inventory_item);
1766: END IF;

Line 1764: rcv_error_pkg.set_token('SUB_ITEM', x_cascaded_table(n).substitute_item_id);

1760: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_VEN_NOT_ALLOWED' THEN
1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);
1763: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_RELATED' THEN
1764: rcv_error_pkg.set_token('SUB_ITEM', x_cascaded_table(n).substitute_item_id);
1765: rcv_error_pkg.set_token('ITEM', x_inventory_item);
1766: END IF;
1767: END validate_substitute_item;
1768:

Line 1765: rcv_error_pkg.set_token('ITEM', x_inventory_item);

1761: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).substitute_item_id);
1762: rcv_error_pkg.set_token('SUPPLIER', x_cascaded_table(n).vendor_id);
1763: ELSIF x_cascaded_table(n).error_message = 'RCV_ITEM_SUB_NOT_RELATED' THEN
1764: rcv_error_pkg.set_token('SUB_ITEM', x_cascaded_table(n).substitute_item_id);
1765: rcv_error_pkg.set_token('ITEM', x_inventory_item);
1766: END IF;
1767: END validate_substitute_item;
1768:
1769: PROCEDURE validate_item_revision(

Line 1796: x_error_status := rcv_error_pkg.g_ret_sts_error;

1792: * 2) Removed all the commented piece of codes, as the code looks clumsy.
1793: * 3) Removed the unnecessary error code part from the 'WHEN e_validation_error'
1794: * exception handler block.
1795: */
1796: x_error_status := rcv_error_pkg.g_ret_sts_error;
1797:
1798: IF x_cascaded_table(n).substitute_item_id IS NOT NULL THEN
1799: l_substitute_item := TRUE;
1800: l_active_item_id := x_cascaded_table(n).substitute_item_id;

Line 1836: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');

1832: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)
1833: AND revision = x_cascaded_table(n).item_revision;
1834:
1835: IF (x_inventory_item = 0) THEN
1836: rcv_error_pkg.set_error_message('PO_RI_INVALID_ITEM_REVISION');
1837: RAISE e_validation_error;
1838: END IF;
1839:
1840: EXCEPTION

Line 1843: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1839:
1840: EXCEPTION
1841: WHEN e_validation_error THEN --Bug 6055435
1842: x_cascaded_table(n).error_status := x_error_status;
1843: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1844:
1845: IF x_cascaded_table(n).error_message = 'PO_RI_INVALID_ITEM_REVISION' THEN
1846: NULL;
1847: END IF;

Line 1854: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1850: asn_debug.put_line('exception in valid_item_revision');
1851: asn_debug.put_line(SQLERRM);
1852: END IF;
1853: x_cascaded_table(n).error_status := 'E';
1854: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1855:
1856: END validate_item_revision;
1857:
1858: /* lcm changes */

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

1885: IF (l_lcm_org_flag = 'Y') THEN
1886: IF ( l_pre_rcv_flag = 'N') THEN
1887: --
1888: /* LCM import is not supported in blackbox scenario */
1889: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --

Line 1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);

1886: IF ( l_pre_rcv_flag = 'N') THEN
1887: --
1888: /* LCM import is not supported in blackbox scenario */
1889: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --
1894: ELSE

Line 1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);

1887: --
1888: /* LCM import is not supported in blackbox scenario */
1889: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --
1894: ELSE
1895: --

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

1888: /* LCM import is not supported in blackbox scenario */
1889: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1890: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1891: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1892: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1893: --
1894: ELSE
1895: --
1896: IF (g_asn_debug = 'Y') THEN

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

1896: IF (g_asn_debug = 'Y') THEN
1897: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1898: END IF;
1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');

Line 1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);

1897: asn_debug.put_line('p_header_record.header_record.transaction_type ' || p_header_record.header_record.transaction_type , NULL, 11);
1898: END IF;
1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1905: END IF;

Line 1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');

1898: END IF;
1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1905: END IF;
1906: --

Line 1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);

1899: IF (p_header_record.header_record.transaction_type <> 'NEW') THEN
1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1905: END IF;
1906: --
1907: END IF;

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

1900: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1901: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE_NE', p_header_record.error_record.error_message);
1902: rcv_error_pkg.set_token('COLUMN', 'TRANSACTION_TYPE');
1903: rcv_error_pkg.set_token('ROI_VALUE', p_header_record.header_record.transaction_type);
1904: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'TRANSACTION_TYPE');
1905: END IF;
1906: --
1907: END IF;
1908: ELSE

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

1906: --
1907: END IF;
1908: ELSE
1909: /* LCM import is not supported in a non-lcm org */
1910: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;

Line 1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);

1907: END IF;
1908: ELSE
1909: /* LCM import is not supported in a non-lcm org */
1910: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;
1915: END IF;

Line 1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);

1908: ELSE
1909: /* LCM import is not supported in a non-lcm org */
1910: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;
1915: END IF;
1916:

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

1909: /* LCM import is not supported in a non-lcm org */
1910: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
1911: rcv_error_pkg.set_error_message('RCV_LCM_IMPORT_NOT_ALLOWED', p_header_record.error_record.error_message);
1912: rcv_error_pkg.set_token('ORG_ID', p_header_record.header_record.ship_to_organization_id);
1913: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'ASN_TYPE');
1914: END IF;
1915: END IF;
1916:
1917: IF (g_asn_debug = 'Y') THEN

Line 1923: WHEN rcv_error_pkg.e_fatal_error THEN

1919: asn_debug.put_line('Exitting validate_lcm_info');
1920: END IF;
1921:
1922: EXCEPTION
1923: WHEN rcv_error_pkg.e_fatal_error THEN
1924: NULL;
1925: END validate_lcm_info;
1926:
1927: END rcv_roi_header_common;