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_CLM_UTIL_PKG dependencies on FND_LOG

Line 86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

82: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_HEADER_STYLE_ID';
83: l_api_version CONSTANT NUMBER := 1.0;
84:
85: BEGIN
86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
87: FND_LOG.string(log_level => FND_LOG.level_statement,
88: module => l_api_name,
89: message => 'BEGIN ::' || p_auction_header_id || ':::'
90: || p_style_id);

Line 87: FND_LOG.string(log_level => FND_LOG.level_statement,

83: l_api_version CONSTANT NUMBER := 1.0;
84:
85: BEGIN
86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
87: FND_LOG.string(log_level => FND_LOG.level_statement,
88: module => l_api_name,
89: message => 'BEGIN ::' || p_auction_header_id || ':::'
90: || p_style_id);
91: END IF;

Line 98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

94: set po_style_id = p_style_id
95: where
96: auction_header_id = p_auction_header_id;
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(log_level => FND_LOG.level_statement,
100: module => l_api_name,
101: message => 'Updated style id successfully.');
102: END IF;

Line 99: FND_LOG.string(log_level => FND_LOG.level_statement,

95: where
96: auction_header_id = p_auction_header_id;
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(log_level => FND_LOG.level_statement,
100: module => l_api_name,
101: message => 'Updated style id successfully.');
102: END IF;
103:

Line 106: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

102: END IF;
103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
107: FND_LOG.string(log_level => FND_LOG.level_statement,
108: module => l_api_name,
109: message => 'Error Occured while updating style id.');
110: END IF;

Line 107: FND_LOG.string(log_level => FND_LOG.level_statement,

103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
107: FND_LOG.string(log_level => FND_LOG.level_statement,
108: module => l_api_name,
109: message => 'Error Occured while updating style id.');
110: END IF;
111:

Line 173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

169: p_resp_id := fnd_global.resp_id;
170: p_appl_id := fnd_global.resp_appl_id;
171: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
172:
173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);

Line 174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');

170: p_appl_id := fnd_global.resp_appl_id;
171: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
172:
173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);

Line 175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);

171: SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;
172:
173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);
179: END IF;

Line 176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);

172:
173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);
179: END IF;
180:

Line 177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);

173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);
179: END IF;
180:
181: IF p_emp_id <> -999 THEN

Line 178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);

174: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter clm_pon_auc_hdr_vpd_fun Procedure');
175: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
176: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
177: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
178: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_emp_id : ' || p_emp_id);
179: END IF;
180:
181: IF p_emp_id <> -999 THEN
182: ProfileValue := PON_CLM_UTIL_PKG.getCLMStatus(p_user_id, p_resp_id, p_appl_id);

Line 184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

180:
181: IF p_emp_id <> -999 THEN
182: ProfileValue := PON_CLM_UTIL_PKG.getCLMStatus(p_user_id, p_resp_id, p_appl_id);
183:
184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
186: END IF;
187:
188: IF ProfileValue <> 'N' THEN

Line 185: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);

181: IF p_emp_id <> -999 THEN
182: ProfileValue := PON_CLM_UTIL_PKG.getCLMStatus(p_user_id, p_resp_id, p_appl_id);
183:
184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
186: END IF;
187:
188: IF ProfileValue <> 'N' THEN
189: return ' exists ( SELECT PADR.DEFAULT_VALUE FROM PON_AUC_DOCTYPE_RULES PADR, PON_AUC_BIZRULES PAB WHERE

Line 201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

197: ELSE
198: return ' 1=1 ';
199: END IF;
200: EXCEPTION WHEN OTHERS THEN
201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);
203: END IF;
204: END clm_pon_auc_hdr_vpd_fun;
205:

Line 202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);

198: return ' 1=1 ';
199: END IF;
200: EXCEPTION WHEN OTHERS THEN
201: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
202: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);
203: END IF;
204: END clm_pon_auc_hdr_vpd_fun;
205:
206:

Line 287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

283:
284: RETURN docNumber;
285:
286: EXCEPTION WHEN OTHERS THEN
287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'get_document_number.invoked', 'Error : '||SQLERRM);
289: END IF;
290: RETURN p_auction_header_id;
291: END GET_DOCUMENT_NUMBER;

Line 288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'get_document_number.invoked', 'Error : '||SQLERRM);

284: RETURN docNumber;
285:
286: EXCEPTION WHEN OTHERS THEN
287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'get_document_number.invoked', 'Error : '||SQLERRM);
289: END IF;
290: RETURN p_auction_header_id;
291: END GET_DOCUMENT_NUMBER;
292: -- Bug:9954903-start

Line 361: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

357: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_UMBRELLA_PROG';
358: l_api_version CONSTANT NUMBER := 1.0;
359:
360: BEGIN
361: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
362: FND_LOG.string(log_level => FND_LOG.level_statement,
363: module => l_api_name,
364: message => 'BEGIN ::' || p_auction_header_id || ':::'
365: || p_program_id);

Line 362: FND_LOG.string(log_level => FND_LOG.level_statement,

358: l_api_version CONSTANT NUMBER := 1.0;
359:
360: BEGIN
361: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
362: FND_LOG.string(log_level => FND_LOG.level_statement,
363: module => l_api_name,
364: message => 'BEGIN ::' || p_auction_header_id || ':::'
365: || p_program_id);
366: END IF;

Line 371: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

367: update pon_auction_headers_all
368: set umbrella_program_id = p_program_id
369: where
370: auction_header_id = p_auction_header_id;
371: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
372: FND_LOG.string(log_level => FND_LOG.level_statement,
373: module => l_api_name,
374: message => 'Updated program id successfully.');
375: END IF;

Line 372: FND_LOG.string(log_level => FND_LOG.level_statement,

368: set umbrella_program_id = p_program_id
369: where
370: auction_header_id = p_auction_header_id;
371: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
372: FND_LOG.string(log_level => FND_LOG.level_statement,
373: module => l_api_name,
374: message => 'Updated program id successfully.');
375: END IF;
376: EXCEPTION

Line 378: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

374: message => 'Updated program id successfully.');
375: END IF;
376: EXCEPTION
377: WHEN OTHERS THEN
378: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
379: FND_LOG.string(log_level => FND_LOG.level_statement,
380: module => l_api_name,
381: message => 'Error Occured while updating program id.');
382: END IF;

Line 379: FND_LOG.string(log_level => FND_LOG.level_statement,

375: END IF;
376: EXCEPTION
377: WHEN OTHERS THEN
378: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
379: FND_LOG.string(log_level => FND_LOG.level_statement,
380: module => l_api_name,
381: message => 'Error Occured while updating program id.');
382: END IF;
383: END UPDATE_UMBRELLA_PROG;

Line 396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

392: l_api_name VARCHAR2(30) := 'get_line_structure_enabled';
393:
394: BEGIN
395:
396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
397: FND_LOG.string(log_level => FND_LOG.level_statement,
398: module => l_api_name,
399: message => 'BEGIN ::' || p_auction_header_id );
400: END IF;

Line 397: FND_LOG.string(log_level => FND_LOG.level_statement,

393:
394: BEGIN
395:
396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
397: FND_LOG.string(log_level => FND_LOG.level_statement,
398: module => l_api_name,
399: message => 'BEGIN ::' || p_auction_header_id );
400: END IF;
401:

Line 408: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

404: FROM financials_system_params_all fsp, pon_auction_headers_all pah
405: where pah.auction_header_id = p_auction_header_id
406: and fsp.org_id = pah.org_id ;
407:
408: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
409: FND_LOG.string(log_level => FND_LOG.level_statement,
410: module => l_api_name,
411: message => 'l_encumberence_flag: '||l_encumberence_flag ||
412: 'l_outcome_document_type: '||l_outcome_document_type);

Line 409: FND_LOG.string(log_level => FND_LOG.level_statement,

405: where pah.auction_header_id = p_auction_header_id
406: and fsp.org_id = pah.org_id ;
407:
408: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
409: FND_LOG.string(log_level => FND_LOG.level_statement,
410: module => l_api_name,
411: message => 'l_encumberence_flag: '||l_encumberence_flag ||
412: 'l_outcome_document_type: '||l_outcome_document_type);
413: END IF;

Line 421: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

417:
418: RETURN 'Y';
419: END IF;
420:
421: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
422: FND_LOG.string(log_level => FND_LOG.level_statement,
423: module => l_api_name,
424: message => 'END');
425: END IF;

Line 422: FND_LOG.string(log_level => FND_LOG.level_statement,

418: RETURN 'Y';
419: END IF;
420:
421: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
422: FND_LOG.string(log_level => FND_LOG.level_statement,
423: module => l_api_name,
424: message => 'END');
425: END IF;
426: RETURN 'N';

Line 430: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

426: RETURN 'N';
427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
431: FND_LOG.string(log_level => FND_LOG.level_statement,
432: module => l_api_name,
433: message => 'Error Occured in IF statement');
434: END IF;

Line 431: FND_LOG.string(log_level => FND_LOG.level_statement,

427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
431: FND_LOG.string(log_level => FND_LOG.level_statement,
432: module => l_api_name,
433: message => 'Error Occured in IF statement');
434: END IF;
435: RETURN('N');