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

Line 34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

30: )
31: IS
32: l_api_name CONSTANT VARCHAR2(30) := 'Generate_XMLData';
33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';
34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;

31: IS
32: l_api_name CONSTANT VARCHAR2(30) := 'Generate_XMLData';
33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';
34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

32: l_api_name CONSTANT VARCHAR2(30) := 'Generate_XMLData';
33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';
34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

33: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Generate_XMLData';
34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
41:

Line 38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

34: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
41:
42: l_xml_doc CLOB;

Line 39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

35: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
41:
42: l_xml_doc CLOB;
43: l_amount NUMBER;

Line 40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

36: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
37: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
38: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
39: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
40: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
41:
42: l_xml_doc CLOB;
43: l_amount NUMBER;
44: l_offset NUMBER;

Line 62: fnd_log.string(

58:
59: BEGIN
60: l_stmt_num := 0;
61: IF l_plog THEN
62: fnd_log.string(
63: fnd_log.level_procedure,
64: l_module||'.'||l_stmt_num,
65: 'Entering CST_PAC_WIP_Value_Report_PVT.Generate_XMLData with << '||
66: 'p_report_type = '||p_report_type||','||

Line 63: fnd_log.level_procedure,

59: BEGIN
60: l_stmt_num := 0;
61: IF l_plog THEN
62: fnd_log.string(
63: fnd_log.level_procedure,
64: l_module||'.'||l_stmt_num,
65: 'Entering CST_PAC_WIP_Value_Report_PVT.Generate_XMLData with << '||
66: 'p_report_type = '||p_report_type||','||
67: 'p_legal_entity_id = '||p_legal_entity_id||','||

Line 201: fnd_log.string(

197:
198: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
199:
200: IF l_plog THEN
201: fnd_log.string(
202: fnd_log.level_procedure,
203: l_module||'.'||l_stmt_num,
204: 'Exiting CST_PAC_WIP_Value_Report_PVT.Generate_XMLData >> ');
205: END IF;

Line 202: fnd_log.level_procedure,

198: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
199:
200: IF l_plog THEN
201: fnd_log.string(
202: fnd_log.level_procedure,
203: l_module||'.'||l_stmt_num,
204: 'Exiting CST_PAC_WIP_Value_Report_PVT.Generate_XMLData >> ');
205: END IF;
206:

Line 216: fnd_log.string(

212: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',
213: p_procedure_name => 'Generate_XMLData',
214: p_error_text => 'An exception has occurred.'
215: );
216: fnd_log.string(
217: fnd_log.level_exception,
218: l_module||'.'||l_stmt_num,
219: 'An exception has occurred.'
220: );

Line 217: fnd_log.level_exception,

213: p_procedure_name => 'Generate_XMLData',
214: p_error_text => 'An exception has occurred.'
215: );
216: fnd_log.string(
217: fnd_log.level_exception,
218: l_module||'.'||l_stmt_num,
219: 'An exception has occurred.'
220: );
221: END IF;

Line 229: fnd_log.message(

225: IF l_uLog THEN
226: fnd_message.set_name('BOM','CST_UNEXPECTED');
227: fnd_message.set_token('SQLERRM',SQLERRM);
228: fnd_msg_pub.add;
229: fnd_log.message(
230: fnd_log.level_unexpected,
231: l_module||'.'||l_stmt_num,
232: FALSE
233: );

Line 230: fnd_log.level_unexpected,

226: fnd_message.set_name('BOM','CST_UNEXPECTED');
227: fnd_message.set_token('SQLERRM',SQLERRM);
228: fnd_msg_pub.add;
229: fnd_log.message(
230: fnd_log.level_unexpected,
231: l_module||'.'||l_stmt_num,
232: FALSE
233: );
234: END IF;

Line 268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

264: l_api_name CONSTANT VARCHAR2(30) := 'Display_Parameters';
265: l_api_version CONSTANT NUMBER := 1.0;
266:
267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';
268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND

265: l_api_version CONSTANT NUMBER := 1.0;
266:
267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';
268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 270: fnd_log.TEST(fnd_log.level_unexpected, l_module);

266:
267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';
268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

267: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Display_Parameters';
268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

268: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
276:

Line 273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

269: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
276:
277: l_ref_cur SYS_REFCURSOR;

Line 274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

270: fnd_log.TEST(fnd_log.level_unexpected, l_module);
271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
276:
277: l_ref_cur SYS_REFCURSOR;
278: l_ctx NUMBER;

Line 275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

271: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
272: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
273: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
274: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
275: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
276:
277: l_ref_cur SYS_REFCURSOR;
278: l_ctx NUMBER;
279: l_xml_temp CLOB;

Line 290: fnd_log.string(

286:
287: BEGIN
288: l_stmt_num := 0;
289: IF l_plog THEN
290: fnd_log.string(
291: fnd_log.level_procedure,
292: l_module||'.'||l_stmt_num,
293: 'Entering CST_PAC_WIP_Value_Report_PVT.Display_Parameters with << '||
294: 'p_init_msg_list = '||p_init_msg_list||','||

Line 291: fnd_log.level_procedure,

287: BEGIN
288: l_stmt_num := 0;
289: IF l_plog THEN
290: fnd_log.string(
291: fnd_log.level_procedure,
292: l_module||'.'||l_stmt_num,
293: 'Entering CST_PAC_WIP_Value_Report_PVT.Display_Parameters with << '||
294: 'p_init_msg_list = '||p_init_msg_list||','||
295: 'p_validation_level = '||p_validation_level||','||

Line 408: fnd_log.string(

404: CLOSE l_ref_cur;
405: DBMS_LOB.FREETEMPORARY (l_xml_temp);
406:
407: IF l_plog THEN
408: fnd_log.string(
409: fnd_log.level_procedure,
410: l_module||'.'||l_stmt_num,
411: 'Exiting CST_PAC_WIP_Value_Report_PVT.Display_Parameters >> ');
412: END IF;

Line 409: fnd_log.level_procedure,

405: DBMS_LOB.FREETEMPORARY (l_xml_temp);
406:
407: IF l_plog THEN
408: fnd_log.string(
409: fnd_log.level_procedure,
410: l_module||'.'||l_stmt_num,
411: 'Exiting CST_PAC_WIP_Value_Report_PVT.Display_Parameters >> ');
412: END IF;
413:

Line 425: fnd_log.string(

421: p_procedure_name => 'Display_Parameters',
422: p_error_text => 'An exception has occurred.'
423: );
424: IF l_uLog THEN
425: fnd_log.string(
426: fnd_log.level_exception,
427: l_module||'.'||l_stmt_num,
428: 'An exception has occurred.'
429: );

Line 426: fnd_log.level_exception,

422: p_error_text => 'An exception has occurred.'
423: );
424: IF l_uLog THEN
425: fnd_log.string(
426: fnd_log.level_exception,
427: l_module||'.'||l_stmt_num,
428: 'An exception has occurred.'
429: );
430: END IF;

Line 436: fnd_log.string(

432: WHEN OTHERS THEN
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: IF l_uLog THEN
436: fnd_log.string(
437: FND_LOG.LEVEL_UNEXPECTED,
438: l_module || '.' || l_stmt_num,
439: SUBSTRB (SQLERRM , 1 , 230)
440: );

Line 437: FND_LOG.LEVEL_UNEXPECTED,

433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: IF l_uLog THEN
436: fnd_log.string(
437: FND_LOG.LEVEL_UNEXPECTED,
438: l_module || '.' || l_stmt_num,
439: SUBSTRB (SQLERRM , 1 , 230)
440: );
441: END IF;

Line 464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

460: p_legal_entity_id IN NUMBER)
461: IS
462:
463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';
464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND

461: IS
462:
463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';
464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 466: fnd_log.TEST(fnd_log.level_unexpected, l_module);

462:
463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';
464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

463: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details';
464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

464: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
472:

Line 469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

465: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
472:
473:

Line 470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

466: fnd_log.TEST(fnd_log.level_unexpected, l_module);
467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
472:
473:
474: CURSOR wip_pac_bal is

Line 471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

467: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
468: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
469: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
470: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
471: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
472:
473:
474: CURSOR wip_pac_bal is
475: SELECT wip_entity_id,

Line 539: fnd_log.string(

535: l_stmt_num := 0;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF l_plog THEN
539: fnd_log.string(
540: fnd_log.level_procedure,
541: l_module||'.'||l_stmt_num,
542: 'Entering CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details with '||
543: 'p_init_msg_list = '||p_init_msg_list||','||

Line 540: fnd_log.level_procedure,

536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF l_plog THEN
539: fnd_log.string(
540: fnd_log.level_procedure,
541: l_module||'.'||l_stmt_num,
542: 'Entering CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details with '||
543: 'p_init_msg_list = '||p_init_msg_list||','||
544: 'p_validation_level = '||p_validation_level||','||

Line 730: fnd_log.string(

726: END LOOP;
727:
728: COMMIT;
729: IF l_plog THEN
730: fnd_log.string(
731: fnd_log.level_procedure,
732: l_module||'.'||l_stmt_num,
733: 'Inserted '||l_ctr|| ' rows into temp table.' ||
734: 'Exiting CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details >> ');

Line 731: fnd_log.level_procedure,

727:
728: COMMIT;
729: IF l_plog THEN
730: fnd_log.string(
731: fnd_log.level_procedure,
732: l_module||'.'||l_stmt_num,
733: 'Inserted '||l_ctr|| ' rows into temp table.' ||
734: 'Exiting CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details >> ');
735: END IF;

Line 748: fnd_log.string(

744: p_procedure_name => 'Periodic_WIP_Value_Rpt_Details',
745: p_error_text => 'An exception has occurred.'
746: );
747: IF l_uLog THEN
748: fnd_log.string(
749: fnd_log.level_exception,
750: l_module||'.'||l_stmt_num,
751: 'An exception has occurred.'
752: );

Line 749: fnd_log.level_exception,

745: p_error_text => 'An exception has occurred.'
746: );
747: IF l_uLog THEN
748: fnd_log.string(
749: fnd_log.level_exception,
750: l_module||'.'||l_stmt_num,
751: 'An exception has occurred.'
752: );
753: END IF;

Line 760: FND_LOG.STRING(

756: WHEN OTHERS THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758:
759: IF l_uLog THEN
760: FND_LOG.STRING(
761: FND_LOG.LEVEL_UNEXPECTED,
762: l_module || '.' || l_stmt_num,
763: SUBSTRB (SQLERRM , 1 , 230)
764: );

Line 761: FND_LOG.LEVEL_UNEXPECTED,

757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758:
759: IF l_uLog THEN
760: FND_LOG.STRING(
761: FND_LOG.LEVEL_UNEXPECTED,
762: l_module || '.' || l_stmt_num,
763: SUBSTRB (SQLERRM , 1 , 230)
764: );
765: END IF;

Line 797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

793: IS
794: l_api_name CONSTANT VARCHAR2(30) := 'Get_XMLData';
795: l_api_version CONSTANT NUMBER := 1.0;
796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';
797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;

794: l_api_name CONSTANT VARCHAR2(30) := 'Get_XMLData';
795: l_api_version CONSTANT NUMBER := 1.0;
796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';
797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

795: l_api_version CONSTANT NUMBER := 1.0;
796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';
797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

796: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_PAC_WIP_Value_Report_PVT.Get_XMLData';
797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
804:

Line 801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

797: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
804:
805: l_ref_cur SYS_REFCURSOR;

Line 802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

798: l_uLog CONSTANT BOOLEAN := fnd_log.TEST(fnd_log.level_unexpected, l_module) AND fnd_log.level_unexpected >= l_log_level;
799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
804:
805: l_ref_cur SYS_REFCURSOR;
806: l_ctx NUMBER;

Line 803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

799: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
800: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
801: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
802: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
803: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
804:
805: l_ref_cur SYS_REFCURSOR;
806: l_ctx NUMBER;
807: l_xml_temp CLOB;

Line 830: fnd_log.string(

826: l_stmt_num := 0;
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: IF l_plog THEN
830: fnd_log.string(
831: fnd_log.level_procedure,
832: l_module||'.'||l_stmt_num,
833: 'Entering CST_PAC_WIP_Value_Report_PVT.Get_XMLData with '||
834: 'p_init_msg_list = '||p_init_msg_list||','||

Line 831: fnd_log.level_procedure,

827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: IF l_plog THEN
830: fnd_log.string(
831: fnd_log.level_procedure,
832: l_module||'.'||l_stmt_num,
833: 'Entering CST_PAC_WIP_Value_Report_PVT.Get_XMLData with '||
834: 'p_init_msg_list = '||p_init_msg_list||','||
835: 'p_validation_level = '||p_validation_level||','||

Line 1060: fnd_log.string(

1056: CLOSE l_ref_cur;
1057: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1058:
1059: IF l_plog THEN
1060: fnd_log.string(
1061: fnd_log.level_procedure,
1062: l_module||'.'||l_stmt_num,
1063: 'Exiting CST_PAC_WIP_Value_Report_PVT.Get_XMLData >> ');
1064: END IF;

Line 1061: fnd_log.level_procedure,

1057: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1058:
1059: IF l_plog THEN
1060: fnd_log.string(
1061: fnd_log.level_procedure,
1062: l_module||'.'||l_stmt_num,
1063: 'Exiting CST_PAC_WIP_Value_Report_PVT.Get_XMLData >> ');
1064: END IF;
1065:

Line 1078: fnd_log.string(

1074: p_procedure_name => 'Get_XMLData',
1075: p_error_text => 'An exception has occurred.'
1076: );
1077: IF l_uLog THEN
1078: fnd_log.string(
1079: fnd_log.level_exception,
1080: l_module||'.'||l_stmt_num,
1081: 'An exception has occurred.'
1082: );

Line 1079: fnd_log.level_exception,

1075: p_error_text => 'An exception has occurred.'
1076: );
1077: IF l_uLog THEN
1078: fnd_log.string(
1079: fnd_log.level_exception,
1080: l_module||'.'||l_stmt_num,
1081: 'An exception has occurred.'
1082: );
1083: END IF;

Line 1090: FND_LOG.STRING(

1086: WHEN OTHERS THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088:
1089: IF l_uLog THEN
1090: FND_LOG.STRING(
1091: FND_LOG.LEVEL_UNEXPECTED,
1092: l_module || '.' || l_stmt_num,
1093: SUBSTRB (SQLERRM , 1 , 230)
1094: );

Line 1091: FND_LOG.LEVEL_UNEXPECTED,

1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088:
1089: IF l_uLog THEN
1090: FND_LOG.STRING(
1091: FND_LOG.LEVEL_UNEXPECTED,
1092: l_module || '.' || l_stmt_num,
1093: SUBSTRB (SQLERRM , 1 , 230)
1094: );
1095: END IF;