DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on FND_LOG

Line 830: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

826: xml_stmt varchar2(500);
827: l_printing_language VARCHAR2(3) := userenv('lang');
828: l_start_time DATE;
829: l_end_time DATE;
830: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
831: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
832: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_EMD_XML';
833:
834: BEGIN

Line 831: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

827: l_printing_language VARCHAR2(3) := userenv('lang');
828: l_start_time DATE;
829: l_end_time DATE;
830: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
831: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
832: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_EMD_XML';
833:
834: BEGIN
835:

Line 1010: FND_LOG.string(l_statement_log_level,

1006:
1007: CLOSE xml_query_cursor;
1008:
1009: IF l_statement_log_level >= l_current_log_level THEN
1010: FND_LOG.string(l_statement_log_level,
1011: l_module_name,
1012: 'PDF: generating XML time: ' ||
1013: (l_end_time - l_start_time) * 24 * 60 * 60);
1014: END IF;

Line 1035: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1031: xml_stmt varchar2(500);
1032: l_printing_language VARCHAR2(3) := userenv('lang');
1033: l_start_time DATE;
1034: l_end_time DATE;
1035: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1036: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1037: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_SUPPLIER_XML';
1038: l_emd_current_status varchar2(20);
1039: --Begin: Added by Chaoqun on 11-Jan_2009

Line 1036: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1032: l_printing_language VARCHAR2(3) := userenv('lang');
1033: l_start_time DATE;
1034: l_end_time DATE;
1035: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1036: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1037: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_SUPPLIER_XML';
1038: l_emd_current_status varchar2(20);
1039: --Begin: Added by Chaoqun on 11-Jan_2009
1040: l_cust_trx_id NUMBER;

Line 1457: FND_LOG.string(l_statement_log_level,

1453:
1454: CLOSE xml_query_cursor;
1455:
1456: IF l_statement_log_level >= l_current_log_level THEN
1457: FND_LOG.string(l_statement_log_level,
1458: l_module_name,
1459: 'PDF: generating XML time: ' ||
1460: (l_end_time - l_start_time) * 24 * 60 * 60);
1461: END IF;

Line 1481: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1477: xml_stmt varchar2(500);
1478: l_printing_language VARCHAR2(3) := userenv('lang');
1479: l_start_time DATE;
1480: l_end_time DATE;
1481: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1482: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1483: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_RECEIPT_XML';
1484: --p_supplier_id := 12438;
1485: --l_emd_current_status pon_emd_transactions.status_lookup_code%type;

Line 1482: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1478: l_printing_language VARCHAR2(3) := userenv('lang');
1479: l_start_time DATE;
1480: l_end_time DATE;
1481: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1482: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1483: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_RECEIPT_XML';
1484: --p_supplier_id := 12438;
1485: --l_emd_current_status pon_emd_transactions.status_lookup_code%type;
1486: TYPE emd_current_status_type is ref cursor;

Line 1677: FND_LOG.string(l_statement_log_level,

1673:
1674: CLOSE xml_query_cursor;
1675:
1676: IF l_statement_log_level >= l_current_log_level THEN
1677: FND_LOG.string(l_statement_log_level,
1678: l_module_name,
1679: 'PDF: generating XML time: ' ||
1680: (l_end_time - l_start_time) * 24 * 60 * 60);
1681: END IF;

Line 1799: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1795: l_neg_has_price_breaks VARCHAR2(1);
1796:
1797: l_start_time DATE;
1798: l_end_time DATE;
1799: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1800: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1801: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
1802:
1803:

Line 1800: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1796:
1797: l_start_time DATE;
1798: l_end_time DATE;
1799: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1800: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1801: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
1802:
1803:
1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;

Line 1962: FND_LOG.string(l_statement_log_level, l_module_name, 'Two-Part related variables: l_two_part_flag: ' || l_two_part_flag || '; l_commercial_lock_status: '||l_commercial_lock_status);

1958: END;
1959: END IF;
1960:
1961: IF l_statement_log_level >= l_current_log_level THEN
1962: FND_LOG.string(l_statement_log_level, l_module_name, 'Two-Part related variables: l_two_part_flag: ' || l_two_part_flag || '; l_commercial_lock_status: '||l_commercial_lock_status);
1963: END IF;
1964:
1965: l_printing_language := userenv('lang') ;
1966:

Line 2209: FND_LOG.string(l_statement_log_level, l_module_name, 'Two-Part related variables: l_hide_comm_part: '||l_hide_comm_part||'; l_attach_categ_option: '|| l_attach_categ_option);

2205: END IF; -- }
2206: END IF; -- }
2207:
2208: IF l_statement_log_level >= l_current_log_level THEN
2209: FND_LOG.string(l_statement_log_level, l_module_name, 'Two-Part related variables: l_hide_comm_part: '||l_hide_comm_part||'; l_attach_categ_option: '|| l_attach_categ_option);
2210: END IF;
2211:
2212: -- Two-Part project (adsahay): fetch messages into variables, this is much more efficient than getting them in the query.
2213: l_two_part_general_msg := pon_printing_pkg.get_messages('PON_TWO_PART_INFO','TECHNICAL',pon_auction_pkg.get_technical_meaning, 'COMMERCIAL',pon_auction_pkg.get_commercial_meaning);

Line 4832: FND_LOG.string(l_statement_log_level, l_module_name, 'PDF: generating XML time: ' || (l_end_time - l_start_time) * 24 * 60 * 60);

4828:
4829: SELECT CURRENT_DATE INTO l_end_time FROM DUAL;
4830:
4831: IF l_statement_log_level >= l_current_log_level THEN
4832: FND_LOG.string(l_statement_log_level, l_module_name, 'PDF: generating XML time: ' || (l_end_time - l_start_time) * 24 * 60 * 60);
4833: END IF;
4834:
4835: return result;
4836: