1329:
1330: BEGIN
1331:
1332: --
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1330: BEGIN
1331:
1332: --
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1331:
1332: --
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1332: --
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1334: PO_LOG.proc_begin(d_module);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1343: END IF;
1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1343: END IF;
1344: --
1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1343: END IF;
1344: --
1345:
1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1343: END IF;
1344: --
1345:
1346:
1457: );
1458: end if;
1459:
1460: --
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1463: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1464: PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1465: END IF;
1458: end if;
1459:
1460: --
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1463: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1464: PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1465: END IF;
1466: --
1459:
1460: --
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1463: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1464: PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1465: END IF;
1466: --
1467:
1460: --
1461: IF (PO_LOG.d_stmt) THEN
1462: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1463: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1464: PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1465: END IF;
1466: --
1467:
1468: --
1654: BEGIN
1655:
1656: d_progress := 0;
1657:
1658: IF (PO_LOG.d_proc) THEN
1659: PO_LOG.proc_begin(d_module);
1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1655:
1656: d_progress := 0;
1657:
1658: IF (PO_LOG.d_proc) THEN
1659: PO_LOG.proc_begin(d_module);
1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1663: END IF;
1656: d_progress := 0;
1657:
1658: IF (PO_LOG.d_proc) THEN
1659: PO_LOG.proc_begin(d_module);
1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1663: END IF;
1664:
1657:
1658: IF (PO_LOG.d_proc) THEN
1659: PO_LOG.proc_begin(d_module);
1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1663: END IF;
1664:
1665: d_progress := 10;
1658: IF (PO_LOG.d_proc) THEN
1659: PO_LOG.proc_begin(d_module);
1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1663: END IF;
1664:
1665: d_progress := 10;
1666:
1674: IF (l_auction_payment_id IS NOT NULL)
1675: THEN
1676:
1677: d_progress := 30;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for auction payment attachments');
1680: END IF;
1681:
1682: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1675: THEN
1676:
1677: d_progress := 30;
1678: IF (PO_LOG.d_stmt) THEN
1679: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for auction payment attachments');
1680: END IF;
1681:
1682: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1683: copy_attachments(
1692: , X_column1 => 'NEG'
1693: );
1694:
1695: d_progress := 40;
1696: IF (PO_LOG.d_stmt) THEN
1697: PO_LOG.stmt(d_module, d_progress, 'Calling add_attch_dynamic for auction payment attachments');
1698: END IF;
1699:
1700: add_attch_dynamic(
1693: );
1694:
1695: d_progress := 40;
1696: IF (PO_LOG.d_stmt) THEN
1697: PO_LOG.stmt(d_module, d_progress, 'Calling add_attch_dynamic for auction payment attachments');
1698: END IF;
1699:
1700: add_attch_dynamic(
1701: x_from_entity_name => 'PON_AUC_PYMNT_SHIP_SUPP_NOTES'
1717: IF (l_bid_payment_id IS NOT NULL)
1718: THEN
1719:
1720: d_progress := 50;
1721: IF (PO_LOG.d_stmt) THEN
1722: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment attachments');
1723: END IF;
1724:
1725: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1718: THEN
1719:
1720: d_progress := 50;
1721: IF (PO_LOG.d_stmt) THEN
1722: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment attachments');
1723: END IF;
1724:
1725: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1726: copy_attachments(
1736: );
1737:
1738: END IF; -- if l_bid_payment_id IS NOT NULL
1739:
1740: IF (PO_LOG.d_proc) THEN
1741: PO_LOG.proc_end(d_module);
1742: END IF;
1743:
1744: EXCEPTION
1737:
1738: END IF; -- if l_bid_payment_id IS NOT NULL
1739:
1740: IF (PO_LOG.d_proc) THEN
1741: PO_LOG.proc_end(d_module);
1742: END IF;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1742: END IF;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: IF (PO_LOG.d_exc) THEN
1747: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1748: END IF;
1749: RAISE;
1750: END copy_sourcing_payitem_atts;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: IF (PO_LOG.d_exc) THEN
1747: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1748: END IF;
1749: RAISE;
1750: END copy_sourcing_payitem_atts;
1751: --