DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on HTP

Line 433: --Bug#2869368.The error in htp call was causing error message not

429: */
430:
431: X_message_text := fnd_message.get_string('PO',x_message_name);
432:
433: --Bug#2869368.The error in htp call was causing error message not
434: --displayed on the browser for the receipt done through SSP.
435: --Added exception to handle this situation.
436: Begin
437: if (x_first_error) then

Line 439: htp.teletype(x_output_message);

435: --Added exception to handle this situation.
436: Begin
437: if (x_first_error) then
438: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
439: htp.teletype(x_output_message);
440: htp.nl;
441: htp.teletype('=============================================================================');
442: htp.nl;
443: x_first_error := FALSE;

Line 440: htp.nl;

436: Begin
437: if (x_first_error) then
438: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
439: htp.teletype(x_output_message);
440: htp.nl;
441: htp.teletype('=============================================================================');
442: htp.nl;
443: x_first_error := FALSE;
444: end if;

Line 441: htp.teletype('=============================================================================');

437: if (x_first_error) then
438: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
439: htp.teletype(x_output_message);
440: htp.nl;
441: htp.teletype('=============================================================================');
442: htp.nl;
443: x_first_error := FALSE;
444: end if;
445:

Line 442: htp.nl;

438: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
439: htp.teletype(x_output_message);
440: htp.nl;
441: htp.teletype('=============================================================================');
442: htp.nl;
443: x_first_error := FALSE;
444: end if;
445:
446: htp.teletype(x_column_name); htp.nl;

Line 446: htp.teletype(x_column_name); htp.nl;

442: htp.nl;
443: x_first_error := FALSE;
444: end if;
445:
446: htp.teletype(x_column_name); htp.nl;
447: htp.teletype(x_message_text); htp.nl;
448: htp.teletype('------------'); htp.nl;
449:
450: Exception

Line 447: htp.teletype(x_message_text); htp.nl;

443: x_first_error := FALSE;
444: end if;
445:
446: htp.teletype(x_column_name); htp.nl;
447: htp.teletype(x_message_text); htp.nl;
448: htp.teletype('------------'); htp.nl;
449:
450: Exception
451: When others then null;

Line 448: htp.teletype('------------'); htp.nl;

444: end if;
445:
446: htp.teletype(x_column_name); htp.nl;
447: htp.teletype(x_message_text); htp.nl;
448: htp.teletype('------------'); htp.nl;
449:
450: Exception
451: When others then null;
452: End;

Line 745: -- htp.p ('validating receiving controls'); -- htp.nl;

741: ** Check the receiving controls for this transaction.
742: */
743: X_progress := '100';
744:
745: -- htp.p ('validating receiving controls'); -- htp.nl;
746:
747: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (
748: rcv_trx.transaction_type,
749: rcv_trx.auto_transact_code,

Line 760: -- htp.p ('receiving controls validation failed'); -- htp.nl;

756: rcv_trx.to_organization_id);
757:
758: if valid_receiving_controls<> 0 THEN
759:
760: -- htp.p ('receiving controls validation failed'); -- htp.nl;
761:
762: /*
763: ** Push the failed Row into the interface_errors table
764: ** so we can provide feedback to the user.The variable valid

Line 793: -- htp.p ('validating item rev controls'); -- htp.nl;

789: RETURN (FALSE);
790:
791: END IF;
792:
793: -- htp.p ('validating item rev controls'); -- htp.nl;
794: /*
795: ** Check that the item rev control matches is satisfied
796: */
797: X_progress := '110';

Line 808: -- htp.p ('item rev controls validation'); -- htp.nl;

804: rcv_trx.destination_type_code,
805: rcv_trx.item_id,
806: rcv_trx.item_revision)) THEN
807:
808: -- htp.p ('item rev controls validation'); -- htp.nl;
809:
810: X_column_name := 'ITEM_REVISION';
811: X_err_message := 'RCV_ITEM_IN_REV_CONTROL';
812:

Line 872: -- htp.p ('validating ship to location id'); -- htp.nl;

868: /* End of Bug 3417961 */
869:
870: IF (rcv_trx.auto_transact_code = 'RECEIVE') THEN
871:
872: -- htp.p ('validating ship to location id'); -- htp.nl;
873: /*
874: ** If this is a express receipt then make sure
875: ** you have a ship_to_location_id
876: */

Line 897: -- htp.p ('validating destination info : '); -- htp.nl;

893:
894: IF (rcv_trx.auto_transact_code = 'DELIVER' OR
895: rcv_trx.transaction_type = 'DELIVER') THEN
896:
897: -- htp.p ('validating destination info : '); -- htp.nl;
898:
899: /*
900: ** Check that the destination information is valid
901: */

Line 910: -- htp.p ('The var Valid_Deliver_dest is :' || to_char(valid_deliver_dest)); -- htp.nl;

906: rcv_trx.destination_type_code,
907: rcv_trx.deliver_to_location_id,
908: rcv_trx.subinventory);
909:
910: -- htp.p ('The var Valid_Deliver_dest is :' || to_char(valid_deliver_dest)); -- htp.nl;
911: IF valid_deliver_dest <> 0 THEN
912:
913: -- htp.p ('destination info validation failed: '); -- htp.nl;
914:

Line 913: -- htp.p ('destination info validation failed: '); -- htp.nl;

909:
910: -- htp.p ('The var Valid_Deliver_dest is :' || to_char(valid_deliver_dest)); -- htp.nl;
911: IF valid_deliver_dest <> 0 THEN
912:
913: -- htp.p ('destination info validation failed: '); -- htp.nl;
914:
915: if valid_deliver_dest = 10 then
916:
917: /* The Destination Org is not defined */

Line 984: -- htp.p ('lot control validation failed: '); -- htp.nl;

980: IF (rcv_trx.destination_type_code <> 'EXPENSE') THEN
981:
982: IF rcv_trx.use_mtl_lot in (2, 5) THEN
983:
984: -- htp.p ('lot control validation failed: '); -- htp.nl;
985: X_column_name := 'USE_MTL_LOT';
986: X_err_message := 'RCV_MTL_LOT_CONTROL_FAIL';
987: rcv_express_sv.insert_interface_errors(rcv_trx,
988: X_column_name,

Line 1001: -- htp.p ('serial control validation failed: '); -- htp.nl;

997: IF (rcv_trx.destination_type_code <> 'EXPENSE') THEN
998:
999: IF rcv_trx.use_mtl_serial in (2, 5) THEN
1000:
1001: -- htp.p ('serial control validation failed: '); -- htp.nl;
1002: X_column_name := 'USE_MTL_SERIAL';
1003: X_err_message := 'RCV_MTL_SERIAL_CONTROL_FAIL';
1004: rcv_express_sv.insert_interface_errors(rcv_trx,
1005: X_column_name,

Line 1014: -- htp.p ('validating locator control : '); -- htp.nl;

1010: END IF;
1011:
1012: END IF;
1013:
1014: -- htp.p ('validating locator control : '); -- htp.nl;
1015:
1016: /*
1017: ** Check that a locator is not required for this transaction since a user
1018: ** would never have the opportunity to enter one. The only way a

Line 1037: -- htp.p ('locator control validation failed: '); -- htp.nl;

1033: rcv_express_sv.insert_interface_errors(rcv_trx,
1034: X_column_name,
1035: X_err_message);
1036:
1037: -- htp.p ('locator control validation failed: '); -- htp.nl;
1038:
1039: RETURN (FALSE);
1040:
1041: END IF;

Line 1052: -- htp.p ('validating wip info : '); -- htp.nl;

1048: rcv_trx.locator_id := NULL;
1049:
1050: END IF;
1051:
1052: -- htp.p ('validating wip info : '); -- htp.nl;
1053:
1054: /*
1055: ** if this is a shop floor destination then make sure that the job
1056: ** information is still valid

Line 1109: -- htp.p ('wip info validation failed : '); -- htp.nl;

1105: rcv_express_sv.insert_interface_errors(rcv_trx,
1106: X_column_name,
1107: X_err_message);
1108:
1109: -- htp.p ('wip info validation failed : '); -- htp.nl;
1110:
1111: RETURN (FALSE);
1112:
1113: END IF;

Line 1126: -- htp.p ('validating pending delivery transactions'); -- htp.nl;

1122: ** are no receipts that have not been delivered. Otherwise we
1123: ** won't be able to distribute them properly.
1124: */
1125:
1126: -- htp.p ('validating pending delivery transactions'); -- htp.nl;
1127:
1128: /*
1129: ** If this is a receipt transaction. Then check that there are is no
1130: ** receipt supply for this line location

Line 1147: -- htp.p ('pending delivery transactions validation failed'); -- htp.nl;

1143: X_err_message := 'RCV_PENDING_DELIVERY_TXN_FAILED';
1144: rcv_express_sv.insert_interface_errors(rcv_trx,
1145: X_column_name,
1146: X_err_message);
1147: -- htp.p ('pending delivery transactions validation failed'); -- htp.nl;
1148:
1149: RETURN (FALSE);
1150:
1151: END IF; -- (NOT rcv_transactions_sv.val_pending_transactions)

Line 1444: -- htp.p ('ERROR: Invalid transaction type' || rcv_trx.receipt_source_code); htp.nl;

1440: /* End bug 7040004 */
1441:
1442: ELSE
1443: null;
1444: -- htp.p ('ERROR: Invalid transaction type' || rcv_trx.receipt_source_code); htp.nl;
1445:
1446: END IF;
1447:
1448:

Line 1449: -- htp.p ('set_trx_defaults : available quantity = ' || TO_CHAR(X_available_quantity)); htp.nl;

1445:
1446: END IF;
1447:
1448:
1449: -- htp.p ('set_trx_defaults : available quantity = ' || TO_CHAR(X_available_quantity)); htp.nl;
1450: -- htp.p ('set_trx_defaults : transaction status code = ' || rcv_trx.transaction_status_code); htp.nl;
1451: /*
1452: ** Set the transactions quantity to the quantity available to transact
1453: ** only if the transaction_status_code is not CONFIRM.

Line 1450: -- htp.p ('set_trx_defaults : transaction status code = ' || rcv_trx.transaction_status_code); htp.nl;

1446: END IF;
1447:
1448:
1449: -- htp.p ('set_trx_defaults : available quantity = ' || TO_CHAR(X_available_quantity)); htp.nl;
1450: -- htp.p ('set_trx_defaults : transaction status code = ' || rcv_trx.transaction_status_code); htp.nl;
1451: /*
1452: ** Set the transactions quantity to the quantity available to transact
1453: ** only if the transaction_status_code is not CONFIRM.
1454: ** If the order is received via the Receive Orders Page on the Web,

Line 1556: -- htp.p ('set_trx_defaults : rcv_trx.quantity = ' || TO_CHAR(rcv_trx.quantity)); htp.nl;

1552:
1553: rcv_trx.uom_code := x_uom_code;
1554:
1555: end if;
1556: -- htp.p ('set_trx_defaults : rcv_trx.quantity = ' || TO_CHAR(rcv_trx.quantity)); htp.nl;
1557:
1558: IF (rcv_trx.destination_type_code = 'INVENTORY' AND
1559: (rcv_trx.auto_transact_code = 'DELIVER' OR
1560: rcv_trx.transaction_type = 'DELIVER')) THEN

Line 1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;

1748:
1749: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1750:
1751: BEGIN
1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;

Line 1753: htp.code('interface_transaction_id : ' ||

1749: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1750:
1751: BEGIN
1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||

Line 1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;

1750:
1751: BEGIN
1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;

Line 1755: htp.code('transaction_type : ' ||

1751: BEGIN
1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||

Line 1756: rcv_trx.transaction_type); htp.nl;

1752: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;

Line 1757: htp.code('auto_transact_code : ' ||

1753: htp.code('interface_transaction_id : ' ||
1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||

Line 1758: rcv_trx.auto_transact_code); htp.nl;

1754: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;

Line 1759: htp.code('transaction_date : ' ||

1755: htp.code('transaction_type : ' ||
1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||

Line 1760: to_char(rcv_trx.transaction_date)); htp.nl;

1756: rcv_trx.transaction_type); htp.nl;
1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;

Line 1761: htp.code('quantity : ' ||

1757: htp.code('auto_transact_code : ' ||
1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||

Line 1762: TO_CHAR(rcv_trx.quantity)); htp.nl;

1758: rcv_trx.auto_transact_code); htp.nl;
1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;

Line 1763: htp.code('unit_of_measure : ' ||

1759: htp.code('transaction_date : ' ||
1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||

Line 1764: rcv_trx.unit_of_measure); htp.nl;

1760: to_char(rcv_trx.transaction_date)); htp.nl;
1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;

Line 1765: htp.code('po_line_location_id : ' ||

1761: htp.code('quantity : ' ||
1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||

Line 1766: to_char(rcv_trx.po_line_location_id)); htp.nl;

1762: TO_CHAR(rcv_trx.quantity)); htp.nl;
1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;

Line 1767: htp.code('shipment_line_id : ' ||

1763: htp.code('unit_of_measure : ' ||
1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||

Line 1768: to_char(rcv_trx.shipment_line_id)); htp.nl;

1764: rcv_trx.unit_of_measure); htp.nl;
1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;

Line 1769: htp.code('item_id : ' ||

1765: htp.code('po_line_location_id : ' ||
1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||

Line 1770: to_char(rcv_trx.item_id)); htp.nl;

1766: to_char(rcv_trx.po_line_location_id)); htp.nl;
1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;

Line 1771: htp.code('item_revision : ' ||

1767: htp.code('shipment_line_id : ' ||
1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||

Line 1772: rcv_trx.item_revision); htp.nl;

1768: to_char(rcv_trx.shipment_line_id)); htp.nl;
1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;

Line 1773: htp.code('vendor_id : ' ||

1769: htp.code('item_id : ' ||
1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||

Line 1774: to_char(rcv_trx.vendor_id)); htp.nl;

1770: to_char(rcv_trx.item_id)); htp.nl;
1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;

Line 1775: htp.code('from_organization_id : ' ||

1771: htp.code('item_revision : ' ||
1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||

Line 1776: to_char(rcv_trx.from_organization_id)); htp.nl;

1772: rcv_trx.item_revision); htp.nl;
1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;

Line 1777: htp.code('to_organization_id : ' ||

1773: htp.code('vendor_id : ' ||
1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||

Line 1778: to_char(rcv_trx.to_organization_id)); htp.nl;

1774: to_char(rcv_trx.vendor_id)); htp.nl;
1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;

Line 1779: htp.code('expected_receipt_date : ' ||

1775: htp.code('from_organization_id : ' ||
1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||

Line 1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;

1776: to_char(rcv_trx.from_organization_id)); htp.nl;
1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;

Line 1781: htp.code('routing_header_id : ' ||

1777: htp.code('to_organization_id : ' ||
1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||

Line 1782: to_char(rcv_trx.routing_header_id)); htp.nl;

1778: to_char(rcv_trx.to_organization_id)); htp.nl;
1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;

Line 1783: htp.code('destination_type_code : ' ||

1779: htp.code('expected_receipt_date : ' ||
1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||

Line 1784: rcv_trx.destination_type_code); htp.nl;

1780: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;

Line 1785: htp.code('po_distribution_id : ' ||

1781: htp.code('routing_header_id : ' ||
1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||

Line 1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;

1782: to_char(rcv_trx.routing_header_id)); htp.nl;
1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;

Line 1787: htp.code('deliver_to_person_id : ' ||

1783: htp.code('destination_type_code : ' ||
1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||

Line 1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;

1784: rcv_trx.destination_type_code); htp.nl;
1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;

Line 1789: htp.code('deliver_to_location_id : ' ||

1785: htp.code('po_distribution_id : ' ||
1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||

Line 1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;

1786: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;

Line 1791: htp.code('subinventory : ' ||

1787: htp.code('deliver_to_person_id : ' ||
1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||

Line 1792: rcv_trx.subinventory); htp.nl;

1788: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;

Line 1793: htp.code('locator_id : ' ||

1789: htp.code('deliver_to_location_id : ' ||
1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||

Line 1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;

1790: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;

Line 1795: htp.code('wip_entity_id : ' ||

1791: htp.code('subinventory : ' ||
1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||

Line 1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;

1792: rcv_trx.subinventory); htp.nl;
1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;

Line 1797: htp.code('wip_line_id : ' ||

1793: htp.code('locator_id : ' ||
1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||

Line 1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;

1794: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;

Line 1799: htp.code('wip_repetitive_schedule_id : ' ||

1795: htp.code('wip_entity_id : ' ||
1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||

Line 1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;

1796: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;

Line 1801: htp.code('wip_operation_seq_num : ' ||

1797: htp.code('wip_line_id : ' ||
1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||

Line 1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;

1798: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||
1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;

Line 1803: htp.code('wip_resource_seq_num : ' ||

1799: htp.code('wip_repetitive_schedule_id : ' ||
1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||
1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1807:

Line 1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;

1800: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||
1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1807:
1808: END print_record;

Line 1805: htp.code('bom_resource_id : ' ||

1801: htp.code('wip_operation_seq_num : ' ||
1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||
1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1807:
1808: END print_record;
1809:

Line 1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;

1802: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1803: htp.code('wip_resource_seq_num : ' ||
1804: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1805: htp.code('bom_resource_id : ' ||
1806: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1807:
1808: END print_record;
1809:
1810: /*===========================================================================