1693: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.BEGIN',
1694: 'Enter - Write to conc output');
1695: End if;
1696:
1697: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
1698: l_serial_label := fnd_message.get;
1699:
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1694: 'Enter - Write to conc output');
1695: End if;
1696:
1697: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
1698: l_serial_label := fnd_message.get;
1699:
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1702:
1696:
1697: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
1698: l_serial_label := fnd_message.get;
1699:
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1702:
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1697: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
1698: l_serial_label := fnd_message.get;
1699:
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1702:
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1705:
1699:
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1702:
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1705:
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1700: fnd_message.set_name('CSD','CSD_BULK_RCV_TXN_CONC_LABEL');
1701: l_txn_label := fnd_message.get;
1702:
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1705:
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1708:
1702:
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1705:
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1708:
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1703: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');
1704: l_item_label := fnd_message.get;
1705:
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1708:
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1711:
1705:
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1708:
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1711:
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1706: fnd_message.set_name('CSD','CSD_BULK_RCV_QTY_CONC_LABEL');
1707: l_qty_label := fnd_message.get;
1708:
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1711:
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1714:
1708:
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1711:
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1714:
1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1709: fnd_message.set_name('CSD','CSD_BULK_RCV_SR_CONC_LABEL');
1710: l_sr_label := fnd_message.get;
1711:
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1714:
1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1717:
1711:
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1714:
1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1712: fnd_message.set_name('CSD','CSD_BULK_RCV_RO_CONC_LABEL');
1713: l_ro_label := fnd_message.get;
1714:
1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1756:
1757:
1758: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then
1759:
1760: fnd_message.set_name('CSD','CSD_BULK_RCV_ERROR_STATUS');
1761: l_status := fnd_message.get;
1762:
1763: Elsif ( c_get_bulk_receive_rec.status = 'PROCESSED' ) then
1764:
1757:
1758: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then
1759:
1760: fnd_message.set_name('CSD','CSD_BULK_RCV_ERROR_STATUS');
1761: l_status := fnd_message.get;
1762:
1763: Elsif ( c_get_bulk_receive_rec.status = 'PROCESSED' ) then
1764:
1765: If ( c_get_bulk_receive_rec.internal_sr_flag = 'Y') then
1762:
1763: Elsif ( c_get_bulk_receive_rec.status = 'PROCESSED' ) then
1764:
1765: If ( c_get_bulk_receive_rec.internal_sr_flag = 'Y') then
1766: fnd_message.set_name('CSD','CSD_BULK_RCV_INTR_SR_STATUS');
1767: l_status := fnd_message.get;
1768: Elsif (l_ro_status = 'D' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1763: Elsif ( c_get_bulk_receive_rec.status = 'PROCESSED' ) then
1764:
1765: If ( c_get_bulk_receive_rec.internal_sr_flag = 'Y') then
1766: fnd_message.set_name('CSD','CSD_BULK_RCV_INTR_SR_STATUS');
1767: l_status := fnd_message.get;
1768: Elsif (l_ro_status = 'D' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1771: Else
1765: If ( c_get_bulk_receive_rec.internal_sr_flag = 'Y') then
1766: fnd_message.set_name('CSD','CSD_BULK_RCV_INTR_SR_STATUS');
1767: l_status := fnd_message.get;
1768: Elsif (l_ro_status = 'D' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1771: Else
1772: fnd_message.set_name('CSD','CSD_BULK_RCV_RECEIVED_STATUS');
1773: l_status := fnd_message.get;
1766: fnd_message.set_name('CSD','CSD_BULK_RCV_INTR_SR_STATUS');
1767: l_status := fnd_message.get;
1768: Elsif (l_ro_status = 'D' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1771: Else
1772: fnd_message.set_name('CSD','CSD_BULK_RCV_RECEIVED_STATUS');
1773: l_status := fnd_message.get;
1774: End if;
1768: Elsif (l_ro_status = 'D' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1771: Else
1772: fnd_message.set_name('CSD','CSD_BULK_RCV_RECEIVED_STATUS');
1773: l_status := fnd_message.get;
1774: End if;
1775:
1776: Elsif ( c_get_bulk_receive_rec.status = 'NEW' ) then
1769: fnd_message.set_name('CSD','CSD_BULK_RCV_DRAFT_RO_STATUS');
1770: l_status := fnd_message.get;
1771: Else
1772: fnd_message.set_name('CSD','CSD_BULK_RCV_RECEIVED_STATUS');
1773: l_status := fnd_message.get;
1774: End if;
1775:
1776: Elsif ( c_get_bulk_receive_rec.status = 'NEW' ) then
1777:
1774: End if;
1775:
1776: Elsif ( c_get_bulk_receive_rec.status = 'NEW' ) then
1777:
1778: fnd_message.set_name('CSD','CSD_BULK_RCV_NEW_STATUS');
1779: l_status := fnd_message.get;
1780:
1781: End if;
1782:
1775:
1776: Elsif ( c_get_bulk_receive_rec.status = 'NEW' ) then
1777:
1778: fnd_message.set_name('CSD','CSD_BULK_RCV_NEW_STATUS');
1779: l_status := fnd_message.get;
1780:
1781: End if;
1782:
1783: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status),28,' '));