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_INT_ORDER_PP_PVT dependencies on RCV_ROI_TRANSACTION

Line 278: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

274: asn_debug.put_line('enter internal order receiving line');
275: END IF;
276:
277: -- 1) derive ship to org info
278: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
279: n,
280: x_header_record
281: );
282: x_progress := '002';

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

286: END IF;
287:
288: x_progress := '010';
289: -- 5) derive item info
290: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);
291: x_progress := '015';
292: rcv_roi_header_common.derive_uom_info(x_cascaded_table, n);
293: -- 6) derive substitute item info
294: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);

Line 294: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);

290: rcv_roi_transaction.derive_item_info(x_cascaded_table, n);
291: x_progress := '015';
292: rcv_roi_header_common.derive_uom_info(x_cascaded_table, n);
293: -- 6) derive substitute item info
294: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);
295: x_progress := '020';
296: -- 8) derive from org info
297: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
298: x_progress := '035';

Line 297: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);

293: -- 6) derive substitute item info
294: rcv_roi_transaction.derive_substitute_item_info(x_cascaded_table, n);
295: x_progress := '020';
296: -- 8) derive from org info
297: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
298: x_progress := '035';
299: -- 12) derive routing header info
300: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
301: x_progress := '070';

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

296: -- 8) derive from org info
297: rcv_roi_transaction.derive_from_org_info(x_cascaded_table, n);
298: x_progress := '035';
299: -- 12) derive routing header info
300: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
301: x_progress := '070';
302: asn_debug.put_line('progress in Internal Orders rcv : x progress = ' || x_progress);
303: -- derive auto transact code
304: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);

Line 304: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);

300: rcv_roi_transaction.derive_routing_header_info(x_cascaded_table, n);
301: x_progress := '070';
302: asn_debug.put_line('progress in Internal Orders rcv : x progress = ' || x_progress);
303: -- derive auto transact code
304: rcv_roi_transaction.derive_auto_transact_code(x_cascaded_table, n);
305: -- 13) bug 3379550
306: x_progress := '071';
307: asn_debug.put_line('progress in Internal Orders rcv : x progress = ' || x_progress);
308: /* Bug 3684984.

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

322: ** then corresponding error message needs to be populated in the
323: ** interface errors table
324: */
325: /* Bug3591830 - START */
326: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);
327: temp_cascaded_table(n).locator_id := x_cascaded_table(n).locator_id;
328: asn_debug.put_line('progress in Internal Orders rcv : after derive_to_locator_id -> locator_id = ' || temp_cascaded_table(n).locator_id);
329: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
330: 'LOCATOR_ID',

Line 347: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);

343: IF (g_asn_debug = 'Y') THEN
344: asn_debug.put_line('enter derive_io_trans_line ');
345: END IF;
346:
347: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
348: /* Derive the to_org_id */
349: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
350: n,
351: x_header_record

Line 349: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

345: END IF;
346:
347: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
348: /* Derive the to_org_id */
349: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
350: n,
351: x_header_record
352: );
353:

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

376: /* Derive the locator_id even in case of deliver transactions */
377: IF (x_cascaded_table(n).transaction_type IN ('TRANSFER','DELIVER')) THEN
378: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
379: asn_debug.put_line('doing ship to location /locator derivations ');
380: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
381: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
382: END IF;
383: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
384: END IF;

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

377: IF (x_cascaded_table(n).transaction_type IN ('TRANSFER','DELIVER')) THEN
378: IF (x_cascaded_table(n).transaction_type = 'TRANSFER') THEN
379: asn_debug.put_line('doing ship to location /locator derivations ');
380: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
381: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
382: END IF;
383: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
384: END IF;
385: /* Bug#4037821 - END */

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

379: asn_debug.put_line('doing ship to location /locator derivations ');
380: rcv_roi_transaction.derive_location_info(x_cascaded_table, n);
381: rcv_roi_transaction.derive_from_locator_id(x_cascaded_table, n); -- WMS Change
382: END IF;
383: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n); -- WMS Change
384: END IF;
385: /* Bug#4037821 - END */
386:
387: x_progress := '071';

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

387: x_progress := '071';
388: asn_debug.put_line('progress in Internal Orders rcv : x progress = ' || x_progress);
389: derive_io_shipment_info(x_cascaded_table, n);
390: x_progress := '091';
391: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
392: /* Auto_transact_code is null for all these transaction types */
393: x_cascaded_table(n).auto_transact_code := NULL;
394: derive_trans_del_line_quantity(x_cascaded_table,
395: n,

Line 411: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);

407: IF (g_asn_debug = 'Y') THEN
408: asn_debug.put_line('enter derive_correction_line ');
409: END IF;
410:
411: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
412: /* Derive the to_org_id */
413: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
414: n,
415: x_header_record

Line 413: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,

409: END IF;
410:
411: rcv_roi_transaction.derive_parent_id(x_cascaded_table, n);
412: /* Derive the to_org_id */
413: rcv_roi_transaction.derive_ship_to_org_info(x_cascaded_table,
414: n,
415: x_header_record
416: );
417:

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

433: x_progress := '071';
434: asn_debug.put_line('progress in Internal Orders rcv : x progress = ' || x_progress);
435: derive_io_shipment_info(x_cascaded_table, n);
436: x_progress := '091';
437: rcv_roi_transaction.derive_reason_info(x_cascaded_table, n);
438: /* Auto_transact_code is null for all these transaction types */
439: x_cascaded_table(n).auto_transact_code := NULL;
440: derive_io_correct_line_qty(x_cascaded_table,
441: n,

Line 536: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */

532: asn_debug.put_line('Enter validate_io_receive_line');
533: END IF;
534:
535: x_progress := '000';
536: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
537: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
538: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
539: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
540:

Line 537: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);

533: END IF;
534:
535: x_progress := '000';
536: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
537: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
538: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
539: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
540:
541: /*Bug 7836753

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

534:
535: x_progress := '000';
536: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
537: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
538: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
539: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
540:
541: /*Bug 7836753
542: Adding IF condition to ensure that the validation call for freight carriers is not made for

Line 539: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);

535: x_progress := '000';
536: rcv_roi_transaction.validate_shipment_source(x_cascaded_table, n); /* bug9705269 */
537: rcv_roi_transaction.validate_transaction_date(x_cascaded_table, n);
538: rcv_roi_transaction.validate_transaction_uom(x_cascaded_table, n);
539: rcv_roi_transaction.validate_item_info(x_cascaded_table, n);
540:
541: /*Bug 7836753
542: Adding IF condition to ensure that the validation call for freight carriers is not made for
543: Internal Orders and Inter-org transfers when the values are same at the header and transaction levels.

Line 548: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);

544: */
545: IF (x_cascaded_table(n).freight_carrier_code = x_header_record.header_record.freight_carrier_code) THEN
546: NULL;
547: ELSE
548: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
549: END IF;
550: /* End of fix for Bug 7836753 */
551:
552: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);

Line 552: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);

548: rcv_roi_transaction.validate_freight_carrier_code(x_cascaded_table, n);
549: END IF;
550: /* End of fix for Bug 7836753 */
551:
552: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
553:
554: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
555: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
556: END IF;

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

551:
552: rcv_roi_transaction.validate_dest_type(x_cascaded_table, n);
553:
554: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
555: rcv_roi_transaction.validate_ship_to_loc(x_cascaded_table, n);
556: END IF;
557: /* Bug:6375015
558: There is no defaulting done for the deliver_to_person_id or validation against the parent_txn's
559: deliver_to_person_id in case of ROI transaction. But in case of forms we are defaluting the

Line 689: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);

685: IF l_skip_validation = 0 THEN
686: IF (g_asn_debug = 'Y') THEN
687: asn_debug.put_line('validate_deliver_to_person is called');
688: END IF;
689: rcv_roi_transaction.validate_deliver_to_person(x_cascaded_table, n);
690: IF (g_asn_debug = 'Y') THEN
691: asn_debug.put_line('After validate_deliver_to_person: ' || x_cascaded_table(n).error_status);
692: END IF;
693: ELSE

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

695: asn_debug.put_line('call to validate_deliver_to_person is skipped');
696: END IF;
697: END IF;/* code fix for the Bug:6375015 ends */
698:
699: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
701: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

Line 700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);

696: END IF;
697: END IF;/* code fix for the Bug:6375015 ends */
698:
699: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
701: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
704: n,

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

697: END IF;/* code fix for the Bug:6375015 ends */
698:
699: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
701: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
704: n,
705: x_header_record.header_record.asn_type

Line 702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);

698:
699: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
701: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
704: n,
705: x_header_record.header_record.asn_type
706: ); /* Bug3454491 */

Line 703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,

699: rcv_roi_transaction.validate_routing_record(x_cascaded_table, n);
700: rcv_roi_transaction.validate_deliver_to_loc(x_cascaded_table, n);
701: rcv_roi_transaction.validate_subinventory(x_cascaded_table, n);
702: rcv_roi_transaction.validate_locator(x_cascaded_table, n);
703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
704: n,
705: x_header_record.header_record.asn_type
706: ); /* Bug3454491 */
707: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);

Line 707: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);

703: rcv_roi_transaction.validate_tax_code(x_cascaded_table,
704: n,
705: x_header_record.header_record.asn_type
706: ); /* Bug3454491 */
707: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
708: /* Bug 3735972.
709: * We used to call rcv_roi_transaction.validate_ref_integrity that had
710: * code only for PO.
711: * We now have a similar one to validate internal orders and

Line 709: * We used to call rcv_roi_transaction.validate_ref_integrity that had

705: x_header_record.header_record.asn_type
706: ); /* Bug3454491 */
707: rcv_roi_transaction.validate_country_of_origin(x_cascaded_table, n);
708: /* Bug 3735972.
709: * We used to call rcv_roi_transaction.validate_ref_integrity that had
710: * code only for PO.
711: * We now have a similar one to validate internal orders and
712: * inter-org shipments in rcv_int_org_transfer package.
713: */

Line 719: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);

715: n,
716: x_header_record
717: );
718:
719: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
720: /** OPM change Bug# 3061052**/
721: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
722:
723: /* If destination_type_code is inventory then we need to make

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

717: );
718:
719: rcv_roi_transaction.exchange_sub_items(x_cascaded_table, n);
720: /** OPM change Bug# 3061052**/
721: rcv_roi_transaction.validate_opm_attributes(x_cascaded_table, n);
722:
723: /* If destination_type_code is inventory then we need to make
724: * sure that we can correct this qty since it might have been
725: * already reserved in inventory.

Line 1250: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,

1246:
1247: IF n > 1 THEN -- we will do this for all rows except the 1st
1248: FOR i IN 1 ..(n - 1) LOOP
1249: IF x_cascaded_table(i).item_id = x_shipmentrec.item_id THEN
1250: x_temp_already_allocated_qty := rcv_roi_transaction.convert_into_correct_qty(x_cascaded_table(i).quantity,
1251: x_cascaded_table(i).unit_of_measure,
1252: x_cascaded_table(i).item_id,
1253: x_shipmentrec.unit_of_measure
1254: );

Line 1300: x_remaining_qty_rsl_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,

1296: -- po -> primary uom
1297: -- if any of the conversions fail then we cannot use that record
1298:
1299: x_remaining_qty_rsl_uom := 0; -- initialize
1300: x_remaining_qty_rsl_uom := rcv_roi_transaction.convert_into_correct_qty(x_remaining_quantity,
1301: temp_cascaded_table(1).unit_of_measure,
1302: temp_cascaded_table(1).item_id,
1303: x_shipmentrec.unit_of_measure
1304: );

Line 1327: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_rsl_uom,

1323: END IF;
1324:
1325: x_remaining_qty_rsl_uom := x_remaining_qty_rsl_uom - x_converted_trx_qty;
1326: -- change rsl uom qty to uom of first line in cascaded table so both qtys are in sync
1327: x_remaining_quantity := rcv_roi_transaction.convert_into_correct_qty(x_remaining_qty_rsl_uom,
1328: x_shipmentrec.unit_of_measure,
1329: temp_cascaded_table(1).item_id,
1330: temp_cascaded_table(1).unit_of_measure
1331: );

Line 1397: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

1393: temp_cascaded_table(current_n).source_doc_quantity := x_converted_trx_qty; -- in rsl uom
1394: temp_cascaded_table(current_n).source_doc_unit_of_measure := x_shipmentrec.unit_of_measure;
1395:
1396: IF (temp_cascaded_table(current_n).unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
1397: temp_cascaded_table(current_n).quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
1398: x_shipmentrec.unit_of_measure,
1399: temp_cascaded_table(current_n).item_id,
1400: temp_cascaded_table(current_n).unit_of_measure
1401: ); -- in asn uom

Line 1413: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,

1409: END IF;
1410:
1411: -- primary qty in primary uom
1412: IF (temp_cascaded_table(current_n).primary_unit_of_measure <> x_shipmentrec.unit_of_measure) THEN
1413: temp_cascaded_table(current_n).primary_quantity := rcv_roi_transaction.convert_into_correct_qty(x_converted_trx_qty,
1414: x_shipmentrec.unit_of_measure,
1415: temp_cascaded_table(current_n).item_id,
1416: temp_cascaded_table(current_n).primary_unit_of_measure
1417: );