DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on RCV_ROI_TRANSACTION

Line 295: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);

291:
292: x_progress := '000';
293: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
294: -- derive_location_info(x_cascaded_table, n);
295: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
296: rcv_roi_transaction.derive_ship_to_location_info(x_cascaded_table, n);
297: x_progress := '010';
298: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
299: --derive_org_info(x_cascaded_table, n, x_header_record);

Line 296: rcv_roi_transaction.derive_ship_to_location_info(x_cascaded_table, n);

292: x_progress := '000';
293: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
294: -- derive_location_info(x_cascaded_table, n);
295: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
296: rcv_roi_transaction.derive_ship_to_location_info(x_cascaded_table, n);
297: x_progress := '010';
298: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
299: --derive_org_info(x_cascaded_table, n, x_header_record);
300: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

Line 300: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

296: rcv_roi_transaction.derive_ship_to_location_info(x_cascaded_table, n);
297: x_progress := '010';
298: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
299: --derive_org_info(x_cascaded_table, n, x_header_record);
300: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
301: n,
302: x_header_record
303: );
304: x_progress := '020';

Line 313: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);

309: derive_order_header_info(x_cascaded_table, n);
310: x_progress := '040';
311: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
312: -- derive_item_info(x_cascaded_table, n);
313: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);
314: x_progress := '050';
315: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
316: derive_order_line_info(x_cascaded_table, n);
317: x_progress := '060';

Line 329: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);

325: derive_transit_org_info(x_cascaded_table, n);
326: x_progress := '090';
327: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
328: -- derive_routing_info(x_cascaded_table, n);
329: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
330: rcv_roi_transaction.derive_routing_step_info(x_cascaded_table, n);
331: x_progress := '100';
332: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
333: derive_deliver_to_info(x_cascaded_table, n);

Line 330: rcv_roi_transaction.derive_routing_step_info(x_cascaded_table, n);

326: x_progress := '090';
327: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
328: -- derive_routing_info(x_cascaded_table, n);
329: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
330: rcv_roi_transaction.derive_routing_step_info(x_cascaded_table, n);
331: x_progress := '100';
332: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
333: derive_deliver_to_info(x_cascaded_table, n);
334: x_progress := '120';

Line 337: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);

333: derive_deliver_to_info(x_cascaded_table, n);
334: x_progress := '120';
335: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
336: -- derive_locator_info(x_cascaded_table, n);
337: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);
338: x_progress := '130';
339: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
340: -- derive_reason_info(x_cascaded_table, n);
341: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

Line 341: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

337: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);
338: x_progress := '130';
339: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
340: -- derive_reason_info(x_cascaded_table, n);
341: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
342: x_progress := '140';
343: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
344: derive_auto_transact_info(x_cascaded_table, n);
345: x_progress := '150';

Line 395: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);

391: * project. Need to verify this with karun to see whether this is
392: * needed for Transfer also.
393: */
394: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
395: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
396: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
397: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
398: END IF;
399:

Line 396: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change

392: * needed for Transfer also.
393: */
394: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
395: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
396: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
397: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
398: END IF;
399:
400: x_progress := '091';

Line 397: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change

393: */
394: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
395: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
396: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
397: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
398: END IF;
399:
400: x_progress := '091';
401: -- derive_reason_info(x_cascaded_table, n);

Line 402: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

398: END IF;
399:
400: x_progress := '091';
401: -- derive_reason_info(x_cascaded_table, n);
402: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
403: /* Auto_transact_code is null for all these transaction types */
404: x_cascaded_table(n).auto_transact_code := NULL;
405: /* quantity derivation is the same as interorg transfers */
406: rcv_int_org_transfer.derive_trans_del_line_quantity(x_cascaded_table,

Line 445: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);

441: END IF;
442: END IF;
443:
444: x_progress := '091';
445: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
446: /* Auto_transact_code is null for all these transaction types */
447: x_cascaded_table(n).auto_transact_code := NULL;
448: /* Quantity calculation is the same as for interorg transfer */
449: rcv_int_org_transfer.derive_int_org_cor_line_qty(x_cascaded_table,

Line 493: * This is needed for direct deliver since rcv_roi_transaction.

489: n,
490: x_header_record
491: );
492: /** bug 3609664, default subinventory and locator info.
493: * This is needed for direct deliver since rcv_roi_transaction.
494: * default_vendor_tran_del() will not be called.
495: */
496: IF x_cascaded_table(n).auto_transact_code = 'DELIVER' THEN
497: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);

Line 497: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);

493: * This is needed for direct deliver since rcv_roi_transaction.
494: * default_vendor_tran_del() will not be called.
495: */
496: IF x_cascaded_table(n).auto_transact_code = 'DELIVER' THEN
497: rcv_roi_transaction.default_to_subloc_info(x_cascaded_table, n);
498: END IF;
499:
500: x_progress := '010';
501:

Line 527: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);

523:
524: -- Bug 3219200: don't require ship_to_location_id for direct delivery
525: IF x_cascaded_table(n).transaction_type = 'RECEIVE'
526: AND x_cascaded_table(n).auto_transact_code <> 'DELIVER' THEN
527: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
528: END IF;
529:
530: validate_txn_date(x_cascaded_table, n);
531: validate_qty_invoiced(x_cascaded_table, n);

Line 535: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);

531: validate_qty_invoiced(x_cascaded_table, n);
532: validate_uom_info(x_cascaded_table, n);
533: validate_item_info(x_cascaded_table, n);
534: validate_freight_carrier_info(x_cascaded_table, n);
535: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
536: rcv_roi_transaction.validate_locator(x_cascaded_table, n); -- Bug 10021661
537: validate_destination_type(x_cascaded_table, n);
538: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
539: validate_tax_name(x_cascaded_table, n);

Line 536: rcv_roi_transaction.validate_locator(x_cascaded_table, n); -- Bug 10021661

532: validate_uom_info(x_cascaded_table, n);
533: validate_item_info(x_cascaded_table, n);
534: validate_freight_carrier_info(x_cascaded_table, n);
535: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
536: rcv_roi_transaction.validate_locator(x_cascaded_table, n); -- Bug 10021661
537: validate_destination_type(x_cascaded_table, n);
538: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
539: validate_tax_name(x_cascaded_table, n);
540: validate_country_of_origin(x_cascaded_table, n);

Line 538: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);

534: validate_freight_carrier_info(x_cascaded_table, n);
535: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
536: rcv_roi_transaction.validate_locator(x_cascaded_table, n); -- Bug 10021661
537: validate_destination_type(x_cascaded_table, n);
538: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
539: validate_tax_name(x_cascaded_table, n);
540: validate_country_of_origin(x_cascaded_table, n);
541: validate_ref_integrity(x_cascaded_table, n);
542: /** OPM change Bug# 3061052**/

Line 543: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);

539: validate_tax_name(x_cascaded_table, n);
540: validate_country_of_origin(x_cascaded_table, n);
541: validate_ref_integrity(x_cascaded_table, n);
542: /** OPM change Bug# 3061052**/
543: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
544:
545: /* If destination_type_code is inventory then we need to make
546: * sure that we can correct this qty since it might have been
547: * already reserved in inventory.