eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS_SV2 dependencies on PO_LOG

Line 1335: IF (PO_LOG.d_proc) THEN

1331:
1332: BEGIN
1333:
1334: -- : Added logging
1335: IF (PO_LOG.d_proc) THEN
1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);

Line 1336: PO_LOG.proc_begin(d_module);

1332: BEGIN
1333:
1334: -- : Added logging
1335: IF (PO_LOG.d_proc) THEN
1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);

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

1333:
1334: -- : Added logging
1335: IF (PO_LOG.d_proc) THEN
1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);

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

1334: -- : Added logging
1335: IF (PO_LOG.d_proc) THEN
1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);

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

1335: IF (PO_LOG.d_proc) THEN
1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);

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

1336: PO_LOG.proc_begin(d_module);
1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1344: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);

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

1337: PO_LOG.proc_begin(d_module, 'x_from_entity_name', x_from_entity_name);
1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1344: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1345: END IF;

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

1338: PO_LOG.proc_begin(d_module, 'x_auction_header_id', x_auction_header_id);
1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1344: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1345: END IF;
1346: --

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

1339: PO_LOG.proc_begin(d_module, 'x_auction_line_number', x_auction_line_number);
1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1344: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1345: END IF;
1346: --
1347:

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

1340: PO_LOG.proc_begin(d_module, 'x_bid_number', x_bid_number);
1341: PO_LOG.proc_begin(d_module, 'x_bid_line_number', x_bid_line_number);
1342: PO_LOG.proc_begin(d_module, 'x_to_entity_name', x_to_entity_name);
1343: PO_LOG.proc_begin(d_module, 'x_to_pk1_value', x_to_pk1_value);
1344: PO_LOG.proc_begin(d_module, 'p_auction_payment_id', p_auction_payment_id);
1345: END IF;
1346: --
1347:
1348:

Line 1479: IF (PO_LOG.d_stmt) THEN

1475: AND paa.line_number = -1
1476: AND NVL(paa.display_only_flag, 'N') = 'Y'
1477: ORDER BY 3
1478: );
1479: IF (PO_LOG.d_stmt) THEN
1480: PO_LOG.stmt(d_module, 10, 'size of p_attachment is : ', l_size);
1481: END IF;
1482: /* If size of header attributes execeeds more than 30k(~MAX_SIZE(LONG),
1483: then we should use attachment type as CLOB

Line 1480: PO_LOG.stmt(d_module, 10, 'size of p_attachment is : ', l_size);

1476: AND NVL(paa.display_only_flag, 'N') = 'Y'
1477: ORDER BY 3
1478: );
1479: IF (PO_LOG.d_stmt) THEN
1480: PO_LOG.stmt(d_module, 10, 'size of p_attachment is : ', l_size);
1481: END IF;
1482: /* If size of header attributes execeeds more than 30k(~MAX_SIZE(LONG),
1483: then we should use attachment type as CLOB
1484: otherwise, we should still continue use attachment type as LONG

Line 1488: IF (PO_LOG.d_stmt) THEN

1484: otherwise, we should still continue use attachment type as LONG
1485: */
1486:
1487: IF l_size < l_max_size THEN
1488: IF (PO_LOG.d_stmt) THEN
1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');
1490: END IF;
1491: PON_AUCTION_PO_PKG.get_attachment ( pk1 => x_auction_header_id -- IN
1492: , pk2 => x_bid_number -- IN

Line 1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');

1485: */
1486:
1487: IF l_size < l_max_size THEN
1488: IF (PO_LOG.d_stmt) THEN
1489: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.get_attachment ');
1490: END IF;
1491: PON_AUCTION_PO_PKG.get_attachment ( pk1 => x_auction_header_id -- IN
1492: , pk2 => x_bid_number -- IN
1493: , pk3 => NULL -- IN

Line 1502: IF (PO_LOG.d_stmt) THEN

1498: , error_msg => x_errormessage -- OUT
1499: );
1500: c_text := NULL;
1501: ELSE
1502: IF (PO_LOG.d_stmt) THEN
1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');
1504: END IF;
1505: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ( p_auction_header_id => x_auction_header_id -- IN
1506: , p_bid_number => x_bid_number -- IN

Line 1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');

1499: );
1500: c_text := NULL;
1501: ELSE
1502: IF (PO_LOG.d_stmt) THEN
1503: PO_LOG.stmt(d_module, 10, 'CALLING PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ');
1504: END IF;
1505: PON_AUCTION_PO_PKG.GET_HDR_ATTRIBUTE_ATTACH_CLOB ( p_auction_header_id => x_auction_header_id -- IN
1506: , p_bid_number => x_bid_number -- IN
1507: , p_line_number => NULL -- IN

Line 1518: IF (PO_LOG.d_stmt) THEN

1514: END IF;
1515: end if;
1516:
1517: -- : Added logging
1518: IF (PO_LOG.d_stmt) THEN
1519: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1520: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1521: -- PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1522: END IF;

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

1515: end if;
1516:
1517: -- : Added logging
1518: IF (PO_LOG.d_stmt) THEN
1519: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1520: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1521: -- PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1522: END IF;
1523: --

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

1516:
1517: -- : Added logging
1518: IF (PO_LOG.d_stmt) THEN
1519: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1520: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1521: -- PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1522: END IF;
1523: --
1524:

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

1517: -- : Added logging
1518: IF (PO_LOG.d_stmt) THEN
1519: PO_LOG.stmt(d_module, 10, 'x_errorcode', x_errorcode);
1520: PO_LOG.stmt(d_module, 10, 'x_errormessage', x_errormessage);
1521: -- PO_LOG.stmt(d_module, 10, 'l_text', l_text);
1522: END IF;
1523: --
1524:
1525: -- added checks to verify if the api returns failure raise

Line 1546: IF (PO_LOG.d_stmt) THEN

1542: execeeds more than 30k(~MAX_SIZE(LONG), then we should use attachment type as FILE
1543: otherwise, we should still continue use attachment type as LONG_TEXT
1544: */
1545: IF (x_from_entity_name = 'PON_BID_HEADER_ATTRIBUTES' AND l_size > l_max_size AND c_text IS NOT NULL) THEN
1546: IF (PO_LOG.d_stmt) THEN
1547: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob ');
1548: END IF;
1549: PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob
1550: ( p_clob_text => c_text

Line 1547: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob ');

1543: otherwise, we should still continue use attachment type as LONG_TEXT
1544: */
1545: IF (x_from_entity_name = 'PON_BID_HEADER_ATTRIBUTES' AND l_size > l_max_size AND c_text IS NOT NULL) THEN
1546: IF (PO_LOG.d_stmt) THEN
1547: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob ');
1548: END IF;
1549: PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob
1550: ( p_clob_text => c_text
1551: , p_description => x_description_tmp

Line 1559: IF (PO_LOG.d_stmt) THEN

1555: , p_to_pk1_value => x_to_pk1_value
1556: , p_who_rec => l_who_rec
1557: );
1558: ELSE
1559: IF (PO_LOG.d_stmt) THEN
1560: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attachment ');
1561: END IF;
1562: PO_NEGOTIATIONS_SV2.convert_text_to_attachment
1563: ( p_long_text => l_text

Line 1560: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attachment ');

1556: , p_who_rec => l_who_rec
1557: );
1558: ELSE
1559: IF (PO_LOG.d_stmt) THEN
1560: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attachment ');
1561: END IF;
1562: PO_NEGOTIATIONS_SV2.convert_text_to_attachment
1563: ( p_long_text => l_text
1564: , p_description => x_description_tmp

Line 1901: IF (PO_LOG.d_proc) THEN

1897: BEGIN
1898:
1899: d_progress := 0;
1900:
1901: IF (PO_LOG.d_proc) THEN
1902: PO_LOG.proc_begin(d_module);
1903: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1904: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1905: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);

Line 1902: PO_LOG.proc_begin(d_module);

1898:
1899: d_progress := 0;
1900:
1901: IF (PO_LOG.d_proc) THEN
1902: PO_LOG.proc_begin(d_module);
1903: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1904: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1905: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1906: END IF;

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

1899: d_progress := 0;
1900:
1901: IF (PO_LOG.d_proc) THEN
1902: PO_LOG.proc_begin(d_module);
1903: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1904: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1905: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1906: END IF;
1907:

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

1900:
1901: IF (PO_LOG.d_proc) THEN
1902: PO_LOG.proc_begin(d_module);
1903: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1904: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1905: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1906: END IF;
1907:
1908: d_progress := 10;

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

1901: IF (PO_LOG.d_proc) THEN
1902: PO_LOG.proc_begin(d_module);
1903: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1904: PO_LOG.proc_begin(d_module, 'p_created_by', p_created_by);
1905: PO_LOG.proc_begin(d_module, 'p_last_update_login', p_last_update_login);
1906: END IF;
1907:
1908: d_progress := 10;
1909:

Line 1921: IF (PO_LOG.d_stmt) THEN

1917: IF (l_auction_payment_id IS NOT NULL)
1918: THEN
1919:
1920: d_progress := 30;
1921: IF (PO_LOG.d_stmt) THEN
1922: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for auction payment attachments');
1923: END IF;
1924:
1925: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments

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

1918: THEN
1919:
1920: d_progress := 30;
1921: IF (PO_LOG.d_stmt) THEN
1922: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for auction payment attachments');
1923: END IF;
1924:
1925: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1926: copy_attachments(

Line 1940: IF (PO_LOG.d_stmt) THEN

1936: , X_column1 => 'NEG'
1937: );
1938:
1939: d_progress := 40;
1940: IF (PO_LOG.d_stmt) THEN
1941: PO_LOG.stmt(d_module, d_progress, 'Calling add_attch_dynamic for auction payment attachments');
1942: END IF;
1943:
1944: add_attch_dynamic(

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

1937: );
1938:
1939: d_progress := 40;
1940: IF (PO_LOG.d_stmt) THEN
1941: PO_LOG.stmt(d_module, d_progress, 'Calling add_attch_dynamic for auction payment attachments');
1942: END IF;
1943:
1944: add_attch_dynamic(
1945: x_from_entity_name => 'PON_AUC_PYMNT_SHIP_SUPP_NOTES'

Line 1965: IF (PO_LOG.d_stmt) THEN

1961: IF (l_bid_payment_id IS NOT NULL)
1962: THEN
1963:
1964: d_progress := 50;
1965: IF (PO_LOG.d_stmt) THEN
1966: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment attachments');
1967: END IF;
1968:
1969: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments

Line 1966: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment attachments');

1962: THEN
1963:
1964: d_progress := 50;
1965: IF (PO_LOG.d_stmt) THEN
1966: PO_LOG.stmt(d_module, d_progress, 'Calling copy_attachments for bid payment attachments');
1967: END IF;
1968:
1969: -- Bug 4620207: pass new pk1/pk2/pk3 values to copy_attachments
1970: copy_attachments(

Line 1985: IF (PO_LOG.d_proc) THEN

1981: );
1982:
1983: END IF; -- if l_bid_payment_id IS NOT NULL
1984:
1985: IF (PO_LOG.d_proc) THEN
1986: PO_LOG.proc_end(d_module);
1987: END IF;
1988:
1989: EXCEPTION

Line 1986: PO_LOG.proc_end(d_module);

1982:
1983: END IF; -- if l_bid_payment_id IS NOT NULL
1984:
1985: IF (PO_LOG.d_proc) THEN
1986: PO_LOG.proc_end(d_module);
1987: END IF;
1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN

Line 1991: IF (PO_LOG.d_exc) THEN

1987: END IF;
1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: IF (PO_LOG.d_exc) THEN
1992: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1993: END IF;
1994: RAISE;
1995: END copy_sourcing_payitem_atts;

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

1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: IF (PO_LOG.d_exc) THEN
1992: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1993: END IF;
1994: RAISE;
1995: END copy_sourcing_payitem_atts;
1996: --