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
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;
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;
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:
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;
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
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;
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;
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,
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
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';
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:
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: */
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: */
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:
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 */
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,
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,
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
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;
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
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;
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
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)
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:
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.
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,
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
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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 : ' ||
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;
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:
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;
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:
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: /*===========================================================================