DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on HTP

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

439: */
440:
441: X_message_text := fnd_message.get_string('PO',x_message_name);
442:
443: --Bug#2869368.The error in htp call was causing error message not
444: --displayed on the browser for the receipt done through SSP.
445: --Added exception to handle this situation.
446: Begin
447: if (x_first_error) then

Line 449: htp.teletype(x_output_message);

445: --Added exception to handle this situation.
446: Begin
447: if (x_first_error) then
448: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
449: htp.teletype(x_output_message);
450: htp.nl;
451: htp.teletype('=============================================================================');
452: htp.nl;
453: x_first_error := FALSE;

Line 450: htp.nl;

446: Begin
447: if (x_first_error) then
448: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
449: htp.teletype(x_output_message);
450: htp.nl;
451: htp.teletype('=============================================================================');
452: htp.nl;
453: x_first_error := FALSE;
454: end if;

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

447: if (x_first_error) then
448: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
449: htp.teletype(x_output_message);
450: htp.nl;
451: htp.teletype('=============================================================================');
452: htp.nl;
453: x_first_error := FALSE;
454: end if;
455:

Line 452: htp.nl;

448: x_output_message := fnd_message.get_string('PO','RCV_CONFIRM_ERRORS');
449: htp.teletype(x_output_message);
450: htp.nl;
451: htp.teletype('=============================================================================');
452: htp.nl;
453: x_first_error := FALSE;
454: end if;
455:
456: htp.teletype(x_column_name); htp.nl;

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

452: htp.nl;
453: x_first_error := FALSE;
454: end if;
455:
456: htp.teletype(x_column_name); htp.nl;
457: htp.teletype(x_message_text); htp.nl;
458: htp.teletype('------------'); htp.nl;
459:
460: Exception

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

453: x_first_error := FALSE;
454: end if;
455:
456: htp.teletype(x_column_name); htp.nl;
457: htp.teletype(x_message_text); htp.nl;
458: htp.teletype('------------'); htp.nl;
459:
460: Exception
461: When others then null;

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

454: end if;
455:
456: htp.teletype(x_column_name); htp.nl;
457: htp.teletype(x_message_text); htp.nl;
458: htp.teletype('------------'); htp.nl;
459:
460: Exception
461: When others then null;
462: End;

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

752: ** Check the receiving controls for this transaction.
753: */
754: X_progress := '100';
755:
756: -- htp.p ('validating receiving controls'); -- htp.nl;
757:
758: valid_receiving_controls := rcv_transactions_sv.val_receiving_controls (
759: rcv_trx.transaction_type,
760: rcv_trx.auto_transact_code,

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

767: rcv_trx.to_organization_id);
768:
769: if valid_receiving_controls<> 0 THEN
770:
771: -- htp.p ('receiving controls validation failed'); -- htp.nl;
772:
773: /*
774: ** Push the failed Row into the interface_errors table
775: ** so we can provide feedback to the user.The variable valid

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

800: RETURN (FALSE);
801:
802: END IF;
803:
804: -- htp.p ('validating item rev controls'); -- htp.nl;
805: /*
806: ** Check that the item rev control matches is satisfied
807: */
808: X_progress := '110';

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

815: rcv_trx.destination_type_code,
816: rcv_trx.item_id,
817: rcv_trx.item_revision)) THEN
818:
819: -- htp.p ('item rev controls validation'); -- htp.nl;
820:
821: X_column_name := 'ITEM_REVISION';
822: X_err_message := 'RCV_ITEM_IN_REV_CONTROL';
823:

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

879: /* End of Bug 3417961 */
880:
881: IF (rcv_trx.auto_transact_code = 'RECEIVE') THEN
882:
883: -- htp.p ('validating ship to location id'); -- htp.nl;
884: /*
885: ** If this is a express receipt then make sure
886: ** you have a ship_to_location_id
887: */

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

904:
905: IF (rcv_trx.auto_transact_code = 'DELIVER' OR
906: rcv_trx.transaction_type = 'DELIVER') THEN
907:
908: -- htp.p ('validating destination info : '); -- htp.nl;
909:
910: /*
911: ** Check that the destination information is valid
912: */

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

917: rcv_trx.destination_type_code,
918: rcv_trx.deliver_to_location_id,
919: rcv_trx.subinventory);
920:
921: -- htp.p ('The var Valid_Deliver_dest is :' || to_char(valid_deliver_dest)); -- htp.nl;
922: IF valid_deliver_dest <> 0 THEN
923:
924: -- htp.p ('destination info validation failed: '); -- htp.nl;
925:

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

920:
921: -- htp.p ('The var Valid_Deliver_dest is :' || to_char(valid_deliver_dest)); -- htp.nl;
922: IF valid_deliver_dest <> 0 THEN
923:
924: -- htp.p ('destination info validation failed: '); -- htp.nl;
925:
926: if valid_deliver_dest = 10 then
927:
928: /* The Destination Org is not defined */

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

991: IF (rcv_trx.destination_type_code <> 'EXPENSE') THEN
992:
993: IF rcv_trx.use_mtl_lot in (2, 5) THEN
994:
995: -- htp.p ('lot control validation failed: '); -- htp.nl;
996: X_column_name := 'USE_MTL_LOT';
997: X_err_message := 'RCV_MTL_LOT_CONTROL_FAIL';
998: rcv_express_sv.insert_interface_errors(rcv_trx,
999: X_column_name,

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

1008: IF (rcv_trx.destination_type_code <> 'EXPENSE') THEN
1009:
1010: IF rcv_trx.use_mtl_serial in (2, 5) THEN
1011:
1012: -- htp.p ('serial control validation failed: '); -- htp.nl;
1013: X_column_name := 'USE_MTL_SERIAL';
1014: X_err_message := 'RCV_MTL_SERIAL_CONTROL_FAIL';
1015: rcv_express_sv.insert_interface_errors(rcv_trx,
1016: X_column_name,

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

1021: END IF;
1022:
1023: END IF;
1024:
1025: -- htp.p ('validating locator control : '); -- htp.nl;
1026:
1027: /*
1028: ** Check that a locator is not required for this transaction since a user
1029: ** would never have the opportunity to enter one. The only way a

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

1044: rcv_express_sv.insert_interface_errors(rcv_trx,
1045: X_column_name,
1046: X_err_message);
1047:
1048: -- htp.p ('locator control validation failed: '); -- htp.nl;
1049:
1050: RETURN (FALSE);
1051:
1052: END IF;

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

1059: rcv_trx.locator_id := NULL;
1060:
1061: END IF;
1062:
1063: -- htp.p ('validating wip info : '); -- htp.nl;
1064:
1065: /*
1066: ** if this is a shop floor destination then make sure that the job
1067: ** information is still valid

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

1116: rcv_express_sv.insert_interface_errors(rcv_trx,
1117: X_column_name,
1118: X_err_message);
1119:
1120: -- htp.p ('wip info validation failed : '); -- htp.nl;
1121:
1122: RETURN (FALSE);
1123:
1124: END IF;

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

1133: ** are no receipts that have not been delivered. Otherwise we
1134: ** won't be able to distribute them properly.
1135: */
1136:
1137: -- htp.p ('validating pending delivery transactions'); -- htp.nl;
1138:
1139: /*
1140: ** If this is a receipt transaction. Then check that there are is no
1141: ** receipt supply for this line location

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

1154: X_err_message := 'RCV_PENDING_DELIVERY_FAILED';--bug8663187
1155: rcv_express_sv.insert_interface_errors(rcv_trx,
1156: X_column_name,
1157: X_err_message);
1158: -- htp.p ('pending delivery transactions validation failed'); -- htp.nl;
1159:
1160: RETURN (FALSE);
1161:
1162: END IF; -- (NOT rcv_transactions_sv.val_pending_transactions)

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

1564: /* End bug 7040004 */
1565:
1566: ELSE
1567: null;
1568: -- htp.p ('ERROR: Invalid transaction type' || rcv_trx.receipt_source_code); htp.nl;
1569:
1570: END IF;
1571:
1572:

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

1569:
1570: END IF;
1571:
1572:
1573: -- htp.p ('set_trx_defaults : available quantity = ' || TO_CHAR(X_available_quantity)); htp.nl;
1574: -- htp.p ('set_trx_defaults : transaction status code = ' || rcv_trx.transaction_status_code); htp.nl;
1575: /*
1576: ** Set the transactions quantity to the quantity available to transact
1577: ** only if the transaction_status_code is not CONFIRM.

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

1570: END IF;
1571:
1572:
1573: -- htp.p ('set_trx_defaults : available quantity = ' || TO_CHAR(X_available_quantity)); htp.nl;
1574: -- htp.p ('set_trx_defaults : transaction status code = ' || rcv_trx.transaction_status_code); htp.nl;
1575: /*
1576: ** Set the transactions quantity to the quantity available to transact
1577: ** only if the transaction_status_code is not CONFIRM.
1578: ** If the order is received via the Receive Orders Page on the Web,

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

1676:
1677: rcv_trx.uom_code := x_uom_code;
1678:
1679: end if;
1680: -- htp.p ('set_trx_defaults : rcv_trx.quantity = ' || TO_CHAR(rcv_trx.quantity)); htp.nl;
1681:
1682: IF (rcv_trx.destination_type_code = 'INVENTORY' AND
1683: (rcv_trx.auto_transact_code = 'DELIVER' OR
1684: rcv_trx.transaction_type = 'DELIVER')) THEN

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

1890:
1891: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1892:
1893: BEGIN
1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;

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

1891: PROCEDURE print_record (rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
1892:
1893: BEGIN
1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||

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

1892:
1893: BEGIN
1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;

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

1893: BEGIN
1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||

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

1894: htp.code('-------------- Transactions Definition ------------------'); htp.nl;
1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;

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

1895: htp.code('interface_transaction_id : ' ||
1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||

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

1896: to_char(rcv_trx.interface_transaction_id)); htp.nl;
1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;

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

1897: htp.code('transaction_type : ' ||
1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||

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

1898: rcv_trx.transaction_type); htp.nl;
1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;

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

1899: htp.code('auto_transact_code : ' ||
1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||

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

1900: rcv_trx.auto_transact_code); htp.nl;
1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;

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

1901: htp.code('transaction_date : ' ||
1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||

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

1902: to_char(rcv_trx.transaction_date)); htp.nl;
1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;

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

1903: htp.code('quantity : ' ||
1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||

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

1904: TO_CHAR(rcv_trx.quantity)); htp.nl;
1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;

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

1905: htp.code('unit_of_measure : ' ||
1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||

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

1906: rcv_trx.unit_of_measure); htp.nl;
1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;

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

1907: htp.code('po_line_location_id : ' ||
1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||

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

1908: to_char(rcv_trx.po_line_location_id)); htp.nl;
1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;

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

1909: htp.code('shipment_line_id : ' ||
1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||

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

1910: to_char(rcv_trx.shipment_line_id)); htp.nl;
1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;

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

1911: htp.code('item_id : ' ||
1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||

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

1912: to_char(rcv_trx.item_id)); htp.nl;
1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;

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

1913: htp.code('item_revision : ' ||
1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||

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

1914: rcv_trx.item_revision); htp.nl;
1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;

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

1915: htp.code('vendor_id : ' ||
1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||

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

1916: to_char(rcv_trx.vendor_id)); htp.nl;
1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;

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

1917: htp.code('from_organization_id : ' ||
1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||

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

1918: to_char(rcv_trx.from_organization_id)); htp.nl;
1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;

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

1919: htp.code('to_organization_id : ' ||
1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||

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

1920: to_char(rcv_trx.to_organization_id)); htp.nl;
1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;

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

1921: htp.code('expected_receipt_date : ' ||
1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||

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

1922: to_char(rcv_trx.expected_receipt_date)); htp.nl;
1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;

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

1923: htp.code('routing_header_id : ' ||
1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||

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

1924: to_char(rcv_trx.routing_header_id)); htp.nl;
1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;

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

1925: htp.code('destination_type_code : ' ||
1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||

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

1926: rcv_trx.destination_type_code); htp.nl;
1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;

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

1927: htp.code('po_distribution_id : ' ||
1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||

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

1928: TO_CHAR(rcv_trx.po_distribution_id)); htp.nl;
1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;

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

1929: htp.code('deliver_to_person_id : ' ||
1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||

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

1930: TO_CHAR(rcv_trx.deliver_to_person_id)); htp.nl;
1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;

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

1931: htp.code('deliver_to_location_id : ' ||
1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||

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

1932: TO_CHAR(rcv_trx.deliver_to_location_id)); htp.nl;
1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;

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

1933: htp.code('subinventory : ' ||
1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||

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

1934: rcv_trx.subinventory); htp.nl;
1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;

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

1935: htp.code('locator_id : ' ||
1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||

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

1936: TO_CHAR(rcv_trx.locator_id)); htp.nl;
1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;

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

1937: htp.code('wip_entity_id : ' ||
1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||

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

1938: TO_CHAR(rcv_trx.wip_entity_id)); htp.nl;
1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;

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

1939: htp.code('wip_line_id : ' ||
1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||

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

1940: TO_CHAR(rcv_trx.wip_line_id)); htp.nl;
1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||
1948: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;

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

1941: htp.code('wip_repetitive_schedule_id : ' ||
1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||
1948: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1949:

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

1942: TO_CHAR(rcv_trx.wip_repetitive_schedule_id)); htp.nl;
1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||
1948: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1949:
1950: END print_record;

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

1943: htp.code('wip_operation_seq_num : ' ||
1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||
1948: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1949:
1950: END print_record;
1951:

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

1944: TO_CHAR(rcv_trx.wip_operation_seq_num)); htp.nl;
1945: htp.code('wip_resource_seq_num : ' ||
1946: TO_CHAR(rcv_trx.wip_resource_seq_num)); htp.nl;
1947: htp.code('bom_resource_id : ' ||
1948: TO_CHAR(rcv_trx.bom_resource_id)); htp.nl; htp.nl;
1949:
1950: END print_record;
1951:
1952: /*===========================================================================