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 888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

884: l_success_flag BOOLEAN;
885: l_source_type_out VARCHAR2(50);
886: l_idList ame_util.idList;
887:
888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
892: BEGIN

Line 889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

885: l_source_type_out VARCHAR2(50);
886: l_idList ame_util.idList;
887:
888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
892: BEGIN
893:

Line 890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

886: l_idList ame_util.idList;
887:
888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
892: BEGIN
893:
894: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1191: l_error_date DATE;
1192: l_oam_admin_user_name VARCHAR2(100);
1193: l_admin_approver ame_util.approverRecord2;
1194:
1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1198: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1199: BEGIN

Line 1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1192: l_oam_admin_user_name VARCHAR2(100);
1193: l_admin_approver ame_util.approverRecord2;
1194:
1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1198: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1199: BEGIN
1200:

Line 1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1193: l_admin_approver ame_util.approverRecord2;
1194:
1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1198: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1199: BEGIN
1200:
1201: BEGIN

Line 1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1381: l_success_flag BOOLEAN;
1382: l_source_type_out VARCHAR2(50);
1383: l_idList ame_util.idList;
1384:
1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1388: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1389: BEGIN

Line 1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1382: l_source_type_out VARCHAR2(50);
1383: l_idList ame_util.idList;
1384:
1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1388: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1389: BEGIN
1390:

Line 1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1383: l_idList ame_util.idList;
1384:
1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1388: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1389: BEGIN
1390:
1391: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1780: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1776: l_process_out varchar2(2);
1777:
1778: l_error_code NUMBER;
1779:
1780: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1781: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1782: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1783: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1784: BEGIN

Line 1781: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1777:
1778: l_error_code NUMBER;
1779:
1780: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1781: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1782: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1783: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1784: BEGIN
1785:

Line 1782: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1778: l_error_code NUMBER;
1779:
1780: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1781: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1782: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1783: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1784: BEGIN
1785:
1786: 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 1897: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1893: l_process_out varchar2(2);
1894:
1895: l_error_code NUMBER;
1896:
1897: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1898: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1899: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1900: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1901: BEGIN

Line 1898: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1894:
1895: l_error_code NUMBER;
1896:
1897: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1898: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1899: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1900: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1901: BEGIN
1902:

Line 1899: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1895: l_error_code NUMBER;
1896:
1897: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1898: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1899: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1900: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1901: BEGIN
1902:
1903: 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 1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1966: l_current_first_approver ame_util.approverRecord2;
1967:
1968: l_error_code NUMBER;
1969:
1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1972: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1973: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
1974: BEGIN

Line 1971: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

1967:
1968: l_error_code NUMBER;
1969:
1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1972: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1973: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
1974: BEGIN
1975:

Line 1972: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1968: l_error_code NUMBER;
1969:
1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1972: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1973: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
1974: BEGIN
1975:
1976: 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 2112: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2108: l_process_out VARCHAR2(10);
2109:
2110: l_error_code NUMBER;
2111:
2112: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2113: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2114: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2115: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2116: BEGIN

Line 2113: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2109:
2110: l_error_code NUMBER;
2111:
2112: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2113: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2114: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2115: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2116: BEGIN
2117:

Line 2114: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2110: l_error_code NUMBER;
2111:
2112: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2113: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2114: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2115: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2116: BEGIN
2117:
2118: 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 2207: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2203: x_return_status VARCHAR2(20);
2204: x_msg_count NUMBER;
2205: x_msg_data VARCHAR2(2000);
2206:
2207: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2209: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2210: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2211: BEGIN

Line 2208: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2204: x_msg_count NUMBER;
2205: x_msg_data VARCHAR2(2000);
2206:
2207: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2209: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2210: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2211: BEGIN
2212:

Line 2209: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2205: x_msg_data VARCHAR2(2000);
2206:
2207: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2209: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2210: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2211: BEGIN
2212:
2213: -- reject all active responses without an award decision

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

2226: IF (p_scoring_lock_tpc_id = -1) THEN
2227: NULL;
2228: ELSE
2229: -- call pvt API to lock scoring
2230: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2231: fnd_log.string(log_level => fnd_log.level_unexpected
2232: ,module => 'pon_award_approval_pkg.submit_for_approval'
2233: ,message => 'before calling private API to lock team scoring');
2234: END IF;

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

2227: NULL;
2228: ELSE
2229: -- call pvt API to lock scoring
2230: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2231: fnd_log.string(log_level => fnd_log.level_unexpected
2232: ,module => 'pon_award_approval_pkg.submit_for_approval'
2233: ,message => 'before calling private API to lock team scoring');
2234: END IF;
2235:

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

2240: ,x_msg_data => x_msg_data
2241: ,x_msg_count => x_msg_count);
2242:
2243: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2244: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2245: fnd_log.string(log_level => fnd_log.level_unexpected
2246: ,module => 'pon_award_approval_pkg.submit_for_approval'
2247: ,message => 'Error while locking team scoring');
2248: END IF;

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

2241: ,x_msg_count => x_msg_count);
2242:
2243: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2244: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2245: fnd_log.string(log_level => fnd_log.level_unexpected
2246: ,module => 'pon_award_approval_pkg.submit_for_approval'
2247: ,message => 'Error while locking team scoring');
2248: END IF;
2249: END IF;

Line 2341: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2337: l_notification_found BOOLEAN;
2338:
2339: l_error_code NUMBER;
2340:
2341: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2342: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2343: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2344: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2345: BEGIN

Line 2342: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

2338:
2339: l_error_code NUMBER;
2340:
2341: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2342: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2343: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2344: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2345: BEGIN
2346:

Line 2343: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;

2339: l_error_code NUMBER;
2340:
2341: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2342: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2343: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2344: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2345: BEGIN
2346:
2347: SELECT wf_award_approval_item_key

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

3093:
3094: /*
3095: Logs a string for a module using the Logging Framework.
3096:
3097: The logging level used is FND_LOG.LEVEL_STATEMENT.
3098: */
3099: PROCEDURE log_string(p_module IN VARCHAR2,
3100: p_string IN VARCHAR2) IS
3101: BEGIN

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

3099: PROCEDURE log_string(p_module IN VARCHAR2,
3100: p_string IN VARCHAR2) IS
3101: BEGIN
3102:
3103: log_string(FND_LOG.LEVEL_STATEMENT, FND_LOG.G_CURRENT_RUNTIME_LEVEL, p_module, p_string);
3104:
3105: END log_string;
3106:
3107: /*

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

3113: p_string IN VARCHAR2) IS
3114: BEGIN
3115:
3116: IF p_level >= p_current_level THEN
3117: FND_LOG.string(p_level, p_module, p_string);
3118: END IF;
3119:
3120: END log_string;
3121: