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_TRANSACTIONS_INTERFACE_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1: PACKAGE BODY rcv_transactions_interface_sv AS

1: PACKAGE BODY rcv_transactions_interface_sv AS
2: /* $Header: RCVTISVB.pls 120.3 2007/12/12 19:47:04 vthevark ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

Line 325: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;

321: x_progress VARCHAR2(3);
322: x_to_organization_code VARCHAR2(5);
323: x_converted_trx_qty NUMBER := 0;
324: transaction_ok BOOLEAN := FALSE;
325: x_expected_date rcv_transactions_interface.expected_receipt_date%TYPE;
326: high_range_date DATE;
327: low_range_date DATE;
328: rows_fetched NUMBER := 0;
329: x_tolerable_qty NUMBER := 0;

Line 559: rcv_transactions_interface_sv.get_po_header_id(document_num_record);

555: IF (g_asn_debug = 'Y') THEN
556: asn_debug.put_line('Derive po_header_id');
557: END IF;
558:
559: rcv_transactions_interface_sv.get_po_header_id(document_num_record);
560: x_cascaded_table(n).po_header_id := document_num_record.po_header_id;
561: x_cascaded_table(n).error_status := document_num_record.error_record.error_status;
562: rcv_error_pkg.set_error_message(document_num_record.error_record.error_message, x_cascaded_table(n).error_message);
563:

Line 593: rcv_transactions_interface_sv.get_item_id(item_id_record);

589: IF (g_asn_debug = 'Y') THEN
590: asn_debug.put_line('Derive item_id');
591: END IF;
592:
593: rcv_transactions_interface_sv.get_item_id(item_id_record);
594: x_cascaded_table(n).item_id := item_id_record.item_id;
595: x_cascaded_table(n).primary_unit_of_measure := item_id_record.primary_unit_of_measure;
596: x_cascaded_table(n).use_mtl_lot := item_id_record.use_mtl_lot; -- bug 608353
597: x_cascaded_table(n).use_mtl_serial := item_id_record.use_mtl_serial; -- bug 608353

Line 632: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);

628: IF (g_asn_debug = 'Y') THEN
629: asn_debug.put_line('Derive Substitute Item Id');
630: END IF;
631:
632: rcv_transactions_interface_sv.get_sub_item_id(sub_item_id_record);
633: x_cascaded_table(n).substitute_item_id := sub_item_id_record.substitute_item_id;
634: x_cascaded_table(n).error_status := sub_item_id_record.error_record.error_status;
635: rcv_error_pkg.set_error_message(sub_item_id_record.error_record.error_message, x_cascaded_table(n).error_message);
636: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 667: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);

663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('Derive po_line_id');
665: END IF;
666:
667: rcv_transactions_interface_sv.get_po_line_id(po_line_id_record);
668:
669: IF x_cascaded_table(n).item_id IS NULL THEN
670: x_cascaded_table(n).item_id := po_line_id_record.item_id;
671: END IF;

Line 728: entered in rcv_transactions_interface.

724: * this block. Removed the condition x_cascaded_table(n).po_line_id is not null
725: */
726:
727: /* Bug 2020269 : uom_code needs to be derived from unit_of_measure
728: entered in rcv_transactions_interface.
729: */
730: IF (x_cascaded_table(n).unit_of_measure IS NOT NULL) THEN
731: IF (g_asn_debug = 'Y') THEN
732: asn_debug.put_line('X_progress ' || x_progress);

Line 907: rcv_transactions_interface_sv.get_location_id(location_id_record);

903: IF (g_asn_debug = 'Y') THEN
904: asn_debug.put_line('Derive location_id');
905: END IF;
906:
907: rcv_transactions_interface_sv.get_location_id(location_id_record);
908: x_cascaded_table(n).location_id := location_id_record.location_id;
909: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
910: rcv_error_pkg.set_error_message(location_id_record.error_record.error_message, x_cascaded_table(n).error_message);
911: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 936: rcv_transactions_interface_sv.get_location_id(location_id_record);

932: IF (g_asn_debug = 'Y') THEN
933: asn_debug.put_line('Derive ship to location_id');
934: END IF;
935:
936: rcv_transactions_interface_sv.get_location_id(location_id_record);
937: x_cascaded_table(n).ship_to_location_id := location_id_record.location_id;
938: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
939: rcv_error_pkg.set_error_message(location_id_record.error_record.error_message, x_cascaded_table(n).error_message);
940: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 963: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);

959: IF (g_asn_debug = 'Y') THEN
960: asn_debug.put_line('Derive routing_header_id');
961: END IF;
962:
963: rcv_transactions_interface_sv.get_routing_header_id(routing_header_id_record);
964: x_cascaded_table(n).routing_header_id := routing_header_id_record.routing_header_id;
965: x_cascaded_table(n).error_status := routing_header_id_record.error_record.error_status;
966: rcv_error_pkg.set_error_message(routing_header_id_record.error_record.error_message, x_cascaded_table(n).error_message);
967: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 990: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);

986: IF (g_asn_debug = 'Y') THEN
987: asn_debug.put_line('Derive routing Step Id');
988: END IF;
989:
990: rcv_transactions_interface_sv.get_routing_step_id(routing_step_id_record);
991: x_cascaded_table(n).routing_step_id := routing_step_id_record.routing_step_id;
992: x_cascaded_table(n).error_status := routing_step_id_record.error_record.error_status;
993: rcv_error_pkg.set_error_message(routing_step_id_record.error_record.error_message, x_cascaded_table(n).error_message);
994: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1053: rcv_transactions_interface_sv.get_location_id(location_id_record);

1049: IF (g_asn_debug = 'Y') THEN
1050: asn_debug.put_line('Derive deliver_to_location_id');
1051: END IF;
1052:
1053: rcv_transactions_interface_sv.get_location_id(location_id_record);
1054: x_cascaded_table(n).deliver_to_location_id := location_id_record.location_id;
1055: x_cascaded_table(n).error_status := location_id_record.error_record.error_status;
1056: rcv_error_pkg.set_error_message(location_id_record.error_record.error_message, x_cascaded_table(n).error_message);
1057: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1086: rcv_transactions_interface_sv.get_locator_id(locator_id_record);

1082:
1083: /*
1084: * bug 724495 add derivation of locator in the preprocessor
1085: */
1086: rcv_transactions_interface_sv.get_locator_id(locator_id_record);
1087: x_cascaded_table(n).locator_id := locator_id_record.locator_id;
1088: x_cascaded_table(n).error_status := locator_id_record.error_record.error_status;
1089: rcv_error_pkg.set_error_message(locator_id_record.error_record.error_message, x_cascaded_table(n).error_message);
1090: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1113: rcv_transactions_interface_sv.get_reason_id(reason_id_record);

1109: IF (g_asn_debug = 'Y') THEN
1110: asn_debug.put_line('Derive Reason_id');
1111: END IF;
1112:
1113: rcv_transactions_interface_sv.get_reason_id(reason_id_record);
1114: x_cascaded_table(n).reason_id := reason_id_record.reason_id;
1115: x_cascaded_table(n).error_status := reason_id_record.error_record.error_status;
1116: rcv_error_pkg.set_error_message(reason_id_record.error_record.error_message, x_cascaded_table(n).error_message);
1117: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

Line 1181: /* 2119137 : If the user populates rcv_transactions_interface

1177: -- the following steps will create a set of rows linking the line_record with
1178: -- its corresponding po_line_location rows until the quantity value from
1179: -- the asn is consumed. (Cascade)
1180:
1181: /* 2119137 : If the user populates rcv_transactions_interface
1182: with po_line_id, then ROI errors out with
1183: RCV_ASN_NO_PO_LINE_LOCATION_ID when the docment_line_num
1184: is not provided for one time items. Modified the "if" criteria in
1185: such a way that the ROI validation does'nt error out when

Line 1230: asn_debug.put_line('wrong po_line_id entered in rcv_transactions_interface');

1226: WHERE po_line_id = temp_cascaded_table(current_n).po_line_id;
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: IF (g_asn_debug = 'Y') THEN
1230: asn_debug.put_line('wrong po_line_id entered in rcv_transactions_interface');
1231: END IF;
1232: END;
1233: END IF;
1234:

Line 1245: asn_debug.put_line('wrong po_line_location_id entered in rcv_transactions_interface');

1241: WHERE line_location_id = temp_cascaded_table(current_n).po_line_location_id;
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: IF (g_asn_debug = 'Y') THEN
1245: asn_debug.put_line('wrong po_line_location_id entered in rcv_transactions_interface');
1246: END IF;
1247: END;
1248: END IF;
1249:

Line 1260: asn_debug.put_line('wrong po_distribution_id entered in rcv_transactions_interface');

1256: WHERE po_distribution_id = temp_cascaded_table(current_n).po_distribution_id;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: IF (g_asn_debug = 'Y') THEN
1260: asn_debug.put_line('wrong po_distribution_id entered in rcv_transactions_interface');
1261: END IF;
1262: END;
1263: END IF;
1264:

Line 2311: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN

2307: */
2308: fnd_profile.get('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE', x_allow_rate_override);
2309:
2310: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
2311: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
2312: SELECT set_of_books_id
2313: INTO rcv_transactions_interface_sv.x_set_of_books_id
2314: FROM financials_system_parameters;
2315: END IF;

Line 2313: INTO rcv_transactions_interface_sv.x_set_of_books_id

2309:
2310: /* ksareddy - 2329928 Ported changes by bao in branch to cache set_of_books_id */
2311: IF (rcv_transactions_interface_sv.x_set_of_books_id IS NULL) THEN
2312: SELECT set_of_books_id
2313: INTO rcv_transactions_interface_sv.x_set_of_books_id
2314: FROM financials_system_parameters;
2315: END IF;
2316:
2317: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

Line 2317: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;

2313: INTO rcv_transactions_interface_sv.x_set_of_books_id
2314: FROM financials_system_parameters;
2315: END IF;
2316:
2317: x_sob_id := rcv_transactions_interface_sv.x_set_of_books_id;
2318:
2319: /*
2320: SELECT set_of_books_id
2321: INTO x_sob_id

Line 2691: using the po_header_id of rcv_transactions_interface for each

2687: /* Fix for bug 2296720.
2688: If both vendor_site_id and vendor_site_code are not populated
2689: in interface tables, and if there are multiple vendor sites
2690: associated to a particular vendor then we default them from PO
2691: using the po_header_id of rcv_transactions_interface for each
2692: line.
2693: */
2694: IF x_cascaded_table(n).vendor_site_id IS NULL
2695: AND x_cascaded_table(n).vendor_site_code IS NULL THEN

Line 3284: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);

3280: IF (x_asn_type = 'ASBN') THEN
3281: quantity_invoiced_record.quantity_invoiced := x_cascaded_table(n).quantity_invoiced;
3282: quantity_invoiced_record.error_record.error_status := 'S';
3283: quantity_invoiced_record.error_record.error_message := NULL;
3284: rcv_transactions_interface_sv1.validate_quantity_invoiced(quantity_invoiced_record);
3285: x_cascaded_table(n).error_status := quantity_invoiced_record.error_record.error_status;
3286: rcv_error_pkg.set_error_message(quantity_invoiced_record.error_record.error_message, x_cascaded_table(n).error_message);
3287: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'QUANTITY_INVOICED');
3288: END IF;

Line 3309: rcv_transactions_interface_sv1.validate_uom(uom_record);

3305: IF (g_asn_debug = 'Y') THEN
3306: asn_debug.put_line('Validating UOM');
3307: END IF;
3308:
3309: rcv_transactions_interface_sv1.validate_uom(uom_record);
3310: x_cascaded_table(n).error_status := uom_record.error_record.error_status;
3311: rcv_error_pkg.set_error_message(uom_record.error_record.error_message, x_cascaded_table(n).error_message);
3312: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'UNIT_OF_MEASURE');
3313: item_id_record.item_id := x_cascaded_table(n).item_id;

Line 3340: rcv_transactions_interface_sv1.validate_item(item_id_record, x_cascaded_table(n).auto_transact_code); -- bug 608353

3336: AND x_cascaded_table(n).po_line_id IS NOT NULL) THEN
3337: item_id_record.error_record.error_status := x_cascaded_table(n).error_status;
3338: item_id_record.error_record.error_message := x_cascaded_table(n).error_message;
3339: ELSE
3340: rcv_transactions_interface_sv1.validate_item(item_id_record, x_cascaded_table(n).auto_transact_code); -- bug 608353
3341: END IF;
3342:
3343: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
3344: rcv_error_pkg.set_error_message(item_id_record.error_record.error_message, x_cascaded_table(n).error_message);

Line 3354: rcv_transactions_interface_sv1.validate_item_description(item_id_record);

3350: IF (g_asn_debug = 'Y') THEN
3351: asn_debug.put_line('Validating Item Description ' || x_cascaded_table(n).item_description);
3352: END IF;
3353:
3354: rcv_transactions_interface_sv1.validate_item_description(item_id_record);
3355: x_cascaded_table(n).error_status := item_id_record.error_record.error_status;
3356: rcv_error_pkg.set_error_message(item_id_record.error_record.error_message, x_cascaded_table(n).error_message);
3357:
3358: IF (g_asn_debug = 'Y') THEN

Line 3401: rcv_transactions_interface_sv1.validate_substitute_item(sub_item_id_record);

3397: asn_debug.put_line('Allow substitute receipts flag in PO shipments ' || x_allow_substitute_receipts);
3398: END IF;
3399:
3400: IF (x_allow_substitute_receipts = 'Y') THEN
3401: rcv_transactions_interface_sv1.validate_substitute_item(sub_item_id_record);
3402: x_cascaded_table(n).error_status := sub_item_id_record.error_record.error_status;
3403: rcv_error_pkg.set_error_message(sub_item_id_record.error_record.error_message, x_cascaded_table(n).error_message);
3404: ELSE
3405: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

Line 3425: rcv_transactions_interface_sv1.validate_item_revision(item_revision_record);

3421: IF (g_asn_debug = 'Y') THEN
3422: asn_debug.put_line('Validating Item Revision');
3423: END IF;
3424:
3425: rcv_transactions_interface_sv1.validate_item_revision(item_revision_record);
3426: x_cascaded_table(n).error_status := item_revision_record.error_record.error_status;
3427: rcv_error_pkg.set_error_message(item_revision_record.error_record.error_message, x_cascaded_table(n).error_message);
3428: x_cascaded_table(n).item_revision := item_revision_record.item_revision;
3429: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'ITEM_REVISION');

Line 3443: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);

3439: IF (g_asn_debug = 'Y') THEN
3440: asn_debug.put_line('Validating Freight Carrier');
3441: END IF;
3442:
3443: rcv_transactions_interface_sv1.validate_freight_carrier(freight_carrier_record);
3444: x_cascaded_table(n).error_status := freight_carrier_record.error_record.error_status;
3445: rcv_error_pkg.set_error_message(freight_carrier_record.error_record.error_message, x_cascaded_table(n).error_message);
3446: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'FREIGHT_CARRIER_CODE');
3447: END IF;

Line 3461: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);

3457: IF (g_asn_debug = 'Y') THEN
3458: asn_debug.put_line('Validating Destination Type Code');
3459: END IF;
3460:
3461: rcv_transactions_interface_sv1.validate_po_lookup_code(po_lookup_code_record);
3462: x_cascaded_table(n).error_status := po_lookup_code_record.error_record.error_status;
3463: rcv_error_pkg.set_error_message(po_lookup_code_record.error_record.error_message, x_cascaded_table(n).error_message);
3464: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'DESTINATION_TYPE_CODE');
3465: /*

Line 3480: rcv_transactions_interface_sv1.validate_location(location_record);

3476: IF (g_asn_debug = 'Y') THEN
3477: asn_debug.put_line('Validating Ship To Location');
3478: END IF;
3479:
3480: rcv_transactions_interface_sv1.validate_location(location_record);
3481: x_cascaded_table(n).error_status := location_record.error_record.error_status;
3482: rcv_error_pkg.set_error_message(location_record.error_record.error_message, x_cascaded_table(n).error_message);
3483: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'SHIP_TO_LOCATION_ID');
3484: /*

Line 3498: rcv_transactions_interface_sv1.validate_employee(employee_record);

3494: IF (g_asn_debug = 'Y') THEN
3495: asn_debug.put_line('Validating Deliver to Person');
3496: END IF;
3497:
3498: rcv_transactions_interface_sv1.validate_employee(employee_record);
3499: x_cascaded_table(n).error_status := employee_record.error_record.error_status;
3500: rcv_error_pkg.set_error_message(employee_record.error_record.error_message, x_cascaded_table(n).error_message);
3501: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'DELIVER_TO_PERSON_ID');
3502:

Line 3547: rcv_transactions_interface_sv1.validate_location(location_record);

3543: IF (g_asn_debug = 'Y') THEN
3544: asn_debug.put_line('Validating Deliver To Location');
3545: END IF;
3546:
3547: rcv_transactions_interface_sv1.validate_location(location_record);
3548: x_cascaded_table(n).error_status := location_record.error_record.error_status;
3549: rcv_error_pkg.set_error_message(location_record.error_record.error_message, x_cascaded_table(n).error_message);
3550: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'DELIVER_TO_LOCATION_ID');
3551: END IF;

Line 3572: rcv_transactions_interface_sv1.validate_subinventory(subinventory_record);

3568: IF (g_asn_debug = 'Y') THEN
3569: asn_debug.put_line('Validating Subinventory');
3570: END IF;
3571:
3572: rcv_transactions_interface_sv1.validate_subinventory(subinventory_record);
3573: x_cascaded_table(n).error_status := subinventory_record.error_record.error_status;
3574: rcv_error_pkg.set_error_message(subinventory_record.error_record.error_message, x_cascaded_table(n).error_message);
3575: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'SUBINVENTORY');
3576: ELSE

Line 3618: rcv_transactions_interface_sv1.validate_locator(locator_record);

3614: IF (g_asn_debug = 'Y') THEN
3615: asn_debug.put_line('Validating Locator');
3616: END IF;
3617:
3618: rcv_transactions_interface_sv1.validate_locator(locator_record);
3619: x_cascaded_table(n).error_status := locator_record.error_record.error_status;
3620: rcv_error_pkg.set_error_message(locator_record.error_record.error_message, x_cascaded_table(n).error_message);
3621:
3622: IF (g_asn_debug = 'Y') THEN

Line 3644: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);

3640: IF (g_asn_debug = 'Y') THEN
3641: asn_debug.put_line('Validating Tax Code');
3642: END IF;
3643:
3644: rcv_transactions_interface_sv1.validate_tax_code(tax_name_record);
3645: x_cascaded_table(n).error_status := tax_name_record.error_record.error_status;
3646: rcv_error_pkg.set_error_message(tax_name_record.error_record.error_message, x_cascaded_table(n).error_message);
3647: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'TAX_NAME');
3648: END IF;

Line 3661: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);

3657: IF (g_asn_debug = 'Y') THEN
3658: asn_debug.put_line('Validating Country of Origin Code');
3659: END IF;
3660:
3661: rcv_transactions_interface_sv1.validate_country_of_origin(country_of_origin_record);
3662: x_cascaded_table(n).error_status := country_of_origin_record.error_record.error_status;
3663: rcv_error_pkg.set_error_message(country_of_origin_record.error_record.error_message, x_cascaded_table(n).error_message);
3664: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'COUNTRY_OF_ORIGIN_CODE');
3665: END IF;

Line 3679: rcv_transactions_interface_sv1.validate_asl(asl_record);

3675: IF (g_asn_debug = 'Y') THEN
3676: asn_debug.put_line('Validating ASL');
3677: END IF;
3678:
3679: rcv_transactions_interface_sv1.validate_asl(asl_record);
3680: x_cascaded_table(n).error_status := asl_record.error_record.error_status;
3681: rcv_error_pkg.set_error_message(asl_record.error_record.error_message, x_cascaded_table(n).error_message);
3682: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'SUPPLY_AGREEMENT_FLAG');
3683:

Line 3702: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);

3698: IF (g_asn_debug = 'Y') THEN
3699: asn_debug.put_line('Validating Cum Qty Shipped');
3700: END IF;
3701:
3702: rcv_transactions_interface_sv1.validate_cum_quantity_shipped(cum_quantity_record);
3703: x_cascaded_table(n).error_status := cum_quantity_record.error_record.error_status;
3704: rcv_error_pkg.set_error_message(cum_quantity_record.error_record.error_message, x_cascaded_table(n).error_message);
3705:
3706: /* WDK - hack, errors are downgraded to warning */

Line 3733: rcv_transactions_interface_sv1.validate_ref_integ(ref_integrity_record, x_header_record);

3729: IF (g_asn_debug = 'Y') THEN
3730: asn_debug.put_line('Validating Ref Integ');
3731: END IF;
3732:
3733: rcv_transactions_interface_sv1.validate_ref_integ(ref_integrity_record, x_header_record);
3734: x_cascaded_table(n).error_status := ref_integrity_record.error_record.error_status;
3735: rcv_error_pkg.set_error_message(ref_integrity_record.error_record.error_message, x_cascaded_table(n).error_message);
3736: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status, 'DOCUMENT_NUM');
3737:

Line 3768: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);

3764: IF (g_asn_debug = 'Y') THEN
3765: asn_debug.put_line('Validating ASBN for Consigned PO');
3766: END IF;
3767:
3768: rcv_transactions_interface_sv1.validate_consigned_po(l_consigned_po_rec);
3769:
3770: IF (g_asn_debug = 'Y') THEN
3771: asn_debug.put_line('After Validating ASBN for Consigned PO');
3772: END IF;

Line 3798: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);

3794: IF (g_asn_debug = 'Y') THEN
3795: asn_debug.put_line('Validating Consumption PO');
3796: END IF;
3797:
3798: rcv_transactions_interface_sv1.validate_consumption_po(l_consumption_po_rec);
3799:
3800: IF (g_asn_debug = 'Y') THEN
3801: asn_debug.put_line('After Validating Consumption PO');
3802: END IF;

Line 3827: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);

3823: IF (g_asn_debug = 'Y') THEN
3824: asn_debug.put_line('Validating Consumption Release');
3825: END IF;
3826:
3827: rcv_transactions_interface_sv1.validate_consumption_release(l_consumption_release_rec);
3828:
3829: IF (g_asn_debug = 'Y') THEN
3830: asn_debug.put_line('After Validating Consumption Release');
3831: END IF;

Line 4443: END rcv_transactions_interface_sv;

4439: EXCEPTION
4440: WHEN OTHERS THEN
4441: x_organization_id := NULL;
4442: END get_org_id_from_hr_loc_id;
4443: END rcv_transactions_interface_sv;