DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV2 dependencies on PO_LOG

Line 1333: IF (PO_LOG.d_proc) THEN

1329:
1330: BEGIN
1331:
1332: -- : Added logging
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);

Line 1334: PO_LOG.proc_begin(d_module);

1330: BEGIN
1331:
1332: -- : Added logging
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);

Line 1335: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);

1331:
1332: -- : Added logging
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);

Line 1336: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);

1332: -- : Added logging
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);

Line 1337: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);

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);

Line 1338: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);

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);

Line 1339: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);

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;

Line 1340: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_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;
1344: --

Line 1341: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);

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:

Line 1342: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);

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:

Line 1461: IF (PO_LOG.d_stmt) THEN

1457: );
1458: end if;
1459:
1460: -- : Added logging
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;

Line 1462: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);

1458: end if;
1459:
1460: -- : Added logging
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: --

Line 1463: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);

1459:
1460: -- : Added logging
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:

Line 1464: PO_LOG.stmt(d_module, 10, 'l_text', l_text);

1460: -- : Added logging
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: -- added checks to verify if the api returns failure raise

Line 1658: IF (PO_LOG.d_proc) THEN

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);

Line 1659: PO_LOG.proc_begin(d_module);

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;

Line 1660: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);

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:

Line 1661: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);

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;

Line 1662: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);

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:

Line 1678: IF (PO_LOG.d_stmt) THEN

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

Line 1679: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for auction payment 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(

Line 1696: IF (PO_LOG.d_stmt) THEN

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(

Line 1697: PO_LOG.stmt(d_module, d_progress, 'Calling add_attch_dynamic for auction payment attachments');

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'

Line 1721: IF (PO_LOG.d_stmt) THEN

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

Line 1722: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment 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(

Line 1740: IF (PO_LOG.d_proc) THEN

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

Line 1741: PO_LOG.proc_end(d_module);

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

Line 1746: IF (PO_LOG.d_exc) 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;

Line 1747: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

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: --