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.PON_AWARD_APPROVAL_PKG dependencies on FND_LOG

Line 106: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

102: l_last_update_date DATE;
103:
104: l_error_code NUMBER;
105:
106: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
108: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
109: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SETUP_OAM_TRANSACTION';
110: BEGIN

Line 107: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

103:
104: l_error_code NUMBER;
105:
106: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
108: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
109: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SETUP_OAM_TRANSACTION';
110: BEGIN
111:

Line 108: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

104: l_error_code NUMBER;
105:
106: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
108: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
109: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SETUP_OAM_TRANSACTION';
110: BEGIN
111:
112: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'marking award ' || p_auction_header_id || ' as OAM transaction ' || p_transaction_id);

Line 200: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

196: already_in_approval EXCEPTION;
197:
198: PRAGMA EXCEPTION_INIT(lock_not_acquired, -54);
199:
200: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
201: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
202: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
203: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.VALIDATE_TRANSACTION';
204: BEGIN

Line 201: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

197:
198: PRAGMA EXCEPTION_INIT(lock_not_acquired, -54);
199:
200: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
201: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
202: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
203: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.VALIDATE_TRANSACTION';
204: BEGIN
205:

Line 202: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

198: PRAGMA EXCEPTION_INIT(lock_not_acquired, -54);
199:
200: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
201: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
202: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
203: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.VALIDATE_TRANSACTION';
204: BEGIN
205:
206: -- lock the transaction based on the p_lock_transaction parameter

Line 902: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

898: l_success_flag BOOLEAN;
899: l_source_type_out VARCHAR2(50);
900: l_idList ame_util.idList;
901:
902: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
903: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
906: BEGIN

Line 903: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

899: l_source_type_out VARCHAR2(50);
900: l_idList ame_util.idList;
901:
902: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
903: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
906: BEGIN
907:

Line 904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

900: l_idList ame_util.idList;
901:
902: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
903: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
906: BEGIN
907:
908: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1209: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1205: l_error_date DATE;
1206: l_oam_admin_user_name VARCHAR2(100);
1207: l_admin_approver ame_util.approverRecord2;
1208:
1209: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1210: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1211: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1212: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1213: BEGIN

Line 1210: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1206: l_oam_admin_user_name VARCHAR2(100);
1207: l_admin_approver ame_util.approverRecord2;
1208:
1209: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1210: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1211: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1212: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1213: BEGIN
1214:

Line 1211: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1207: l_admin_approver ame_util.approverRecord2;
1208:
1209: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1210: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1211: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1212: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1213: BEGIN
1214:
1215: BEGIN

Line 1399: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1395: l_success_flag BOOLEAN;
1396: l_source_type_out VARCHAR2(50);
1397: l_idList ame_util.idList;
1398:
1399: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1400: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1401: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1402: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1403:

Line 1400: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1396: l_source_type_out VARCHAR2(50);
1397: l_idList ame_util.idList;
1398:
1399: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1400: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1401: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1402: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1403:
1404: l_preparer_resp_id NUMBER;

Line 1401: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1397: l_idList ame_util.idList;
1398:
1399: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1400: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1401: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1402: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1403:
1404: l_preparer_resp_id NUMBER;
1405: l_preparer_appl_id NUMBER;

Line 1815: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1811: l_process_out varchar2(2);
1812:
1813: l_error_code NUMBER;
1814:
1815: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1816: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1817: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1818: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1819: BEGIN

Line 1816: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1812:
1813: l_error_code NUMBER;
1814:
1815: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1816: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1817: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1818: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1819: BEGIN
1820:

Line 1817: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1813: l_error_code NUMBER;
1814:
1815: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1816: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1817: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1818: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1819: BEGIN
1820:
1821: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'adding to approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);

Line 1932: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1928: l_process_out varchar2(2);
1929:
1930: l_error_code NUMBER;
1931:
1932: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1933: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1934: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1935: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1936: BEGIN

Line 1933: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1929:
1930: l_error_code NUMBER;
1931:
1932: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1933: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1934: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1935: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1936: BEGIN
1937:

Line 1934: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1930: l_error_code NUMBER;
1931:
1932: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1933: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1934: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1935: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1936: BEGIN
1937:
1938: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'deleting from approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);

Line 2005: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2001: l_current_first_approver ame_util.approverRecord2;
2002:
2003: l_error_code NUMBER;
2004:
2005: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2006: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2007: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2008: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
2009: BEGIN

Line 2006: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2002:
2003: l_error_code NUMBER;
2004:
2005: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2006: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2007: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2008: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
2009: BEGIN
2010:

Line 2007: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2003: l_error_code NUMBER;
2004:
2005: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2006: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2007: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2008: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
2009: BEGIN
2010:
2011: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'changing first authority approver for award transaction ' || p_auction_header_id || '-' || p_transaction_id);

Line 2147: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2143: l_process_out VARCHAR2(10);
2144:
2145: l_error_code NUMBER;
2146:
2147: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2148: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2149: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2150: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2151: BEGIN

Line 2148: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2144:
2145: l_error_code NUMBER;
2146:
2147: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2148: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2149: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2150: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2151: BEGIN
2152:

Line 2149: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2145: l_error_code NUMBER;
2146:
2147: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2148: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2149: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2150: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2151: BEGIN
2152:
2153: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'resetting approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);

Line 2242: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2238: x_return_status VARCHAR2(20);
2239: x_msg_count NUMBER;
2240: x_msg_data VARCHAR2(2000);
2241:
2242: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2243: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2244: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2245: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2246:

Line 2243: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2239: x_msg_count NUMBER;
2240: x_msg_data VARCHAR2(2000);
2241:
2242: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2243: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2244: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2245: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2246:
2247: -- Unsolicited Lines Project

Line 2244: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2240: x_msg_data VARCHAR2(2000);
2241:
2242: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2243: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2244: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2245: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2246:
2247: -- Unsolicited Lines Project
2248: l_allow_unsol_lines VARCHAR2(1);

Line 2288: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2284: IF (p_scoring_lock_tpc_id = -1) THEN
2285: NULL;
2286: ELSE
2287: -- call pvt API to lock scoring
2288: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2289: fnd_log.string(log_level => fnd_log.level_unexpected
2290: ,module => 'pon_award_approval_pkg.submit_for_approval'
2291: ,message => 'before calling private API to lock team scoring');
2292: END IF;

Line 2289: fnd_log.string(log_level => fnd_log.level_unexpected

2285: NULL;
2286: ELSE
2287: -- call pvt API to lock scoring
2288: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2289: fnd_log.string(log_level => fnd_log.level_unexpected
2290: ,module => 'pon_award_approval_pkg.submit_for_approval'
2291: ,message => 'before calling private API to lock team scoring');
2292: END IF;
2293:

Line 2302: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2298: ,x_msg_data => x_msg_data
2299: ,x_msg_count => x_msg_count);
2300:
2301: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2302: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2303: fnd_log.string(log_level => fnd_log.level_unexpected
2304: ,module => 'pon_award_approval_pkg.submit_for_approval'
2305: ,message => 'Error while locking team scoring');
2306: END IF;

Line 2303: fnd_log.string(log_level => fnd_log.level_unexpected

2299: ,x_msg_count => x_msg_count);
2300:
2301: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2302: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2303: fnd_log.string(log_level => fnd_log.level_unexpected
2304: ,module => 'pon_award_approval_pkg.submit_for_approval'
2305: ,message => 'Error while locking team scoring');
2306: END IF;
2307: END IF;

Line 2398: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2394: l_notification_found BOOLEAN;
2395:
2396: l_error_code NUMBER;
2397:
2398: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2399: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2400: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2401: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2402: BEGIN

Line 2399: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2395:
2396: l_error_code NUMBER;
2397:
2398: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2399: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2400: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2401: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2402: BEGIN
2403:

Line 2400: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2396: l_error_code NUMBER;
2397:
2398: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2399: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2400: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2401: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2402: BEGIN
2403:
2404: SELECT wf_award_approval_item_key

Line 3157: The logging level used is FND_LOG.LEVEL_STATEMENT.

3153:
3154: /*
3155: Logs a string for a module using the Logging Framework.
3156:
3157: The logging level used is FND_LOG.LEVEL_STATEMENT.
3158: */
3159: PROCEDURE log_string(p_module IN VARCHAR2,
3160: p_string IN VARCHAR2) IS
3161: BEGIN

Line 3163: log_string(FND_LOG.LEVEL_STATEMENT, FND_LOG.G_CURRENT_RUNTIME_LEVEL, p_module, p_string);

3159: PROCEDURE log_string(p_module IN VARCHAR2,
3160: p_string IN VARCHAR2) IS
3161: BEGIN
3162:
3163: log_string(FND_LOG.LEVEL_STATEMENT, FND_LOG.G_CURRENT_RUNTIME_LEVEL, p_module, p_string);
3164:
3165: END log_string;
3166:
3167: /*

Line 3177: FND_LOG.string(p_level, p_module, p_string);

3173: p_string IN VARCHAR2) IS
3174: BEGIN
3175:
3176: IF p_level >= p_current_level THEN
3177: FND_LOG.string(p_level, p_module, p_string);
3178: END IF;
3179:
3180: END log_string;
3181: