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

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

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

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

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

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

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

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

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

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

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

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

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

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

35: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
36: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
37: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
38: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
39: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
40:
41: BEGIN
42:
43: IF l_plog THEN

Line 44: fnd_log.string(

40:
41: BEGIN
42:
43: IF l_plog THEN
44: fnd_log.string(
45: fnd_log.level_procedure,
46: l_module||'.'||l_stmt_num,
47: 'Entering CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
48: 'p_legal_entity_id = '||p_legal_entity_id||','||

Line 45: fnd_log.level_procedure,

41: BEGIN
42:
43: IF l_plog THEN
44: fnd_log.string(
45: fnd_log.level_procedure,
46: l_module||'.'||l_stmt_num,
47: 'Entering CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
48: 'p_legal_entity_id = '||p_legal_entity_id||','||
49: 'p_cost_group_id = '||p_cost_group_id||','||

Line 144: fnd_log.string(

140: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
141:
142:
143: IF l_plog THEN
144: fnd_log.string(
145: fnd_log.level_procedure,
146: l_module||'.'||l_stmt_num,
147: 'Exiting CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
148: 'errno = '||errno

Line 145: fnd_log.level_procedure,

141:
142:
143: IF l_plog THEN
144: fnd_log.string(
145: fnd_log.level_procedure,
146: l_module||'.'||l_stmt_num,
147: 'Exiting CST_eAM_WorkOrders_PVT.Generate_XMLData with '||
148: 'errno = '||errno
149: );

Line 164: fnd_log.string(

160: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
161: p_procedure_name => 'Generate_XMLData',
162: p_error_text => 'An exception has occurred.'
163: );
164: fnd_log.string(
165: fnd_log.level_exception,
166: l_module||'.'||l_stmt_num,
167: 'An exception has occurred.'
168: );

Line 165: fnd_log.level_exception,

161: p_procedure_name => 'Generate_XMLData',
162: p_error_text => 'An exception has occurred.'
163: );
164: fnd_log.string(
165: fnd_log.level_exception,
166: l_module||'.'||l_stmt_num,
167: 'An exception has occurred.'
168: );
169: END IF;

Line 179: fnd_log.message(

175: IF l_uLog THEN
176: fnd_message.set_name('BOM','CST_UNEXPECTED');
177: fnd_message.set_token('SQLERRM',SQLERRM);
178: fnd_msg_pub.add;
179: fnd_log.message(
180: fnd_log.level_unexpected,
181: l_module||'.'||l_stmt_num,
182: FALSE
183: );

Line 180: fnd_log.level_unexpected,

176: fnd_message.set_name('BOM','CST_UNEXPECTED');
177: fnd_message.set_token('SQLERRM',SQLERRM);
178: fnd_msg_pub.add;
179: fnd_log.message(
180: fnd_log.level_unexpected,
181: l_module||'.'||l_stmt_num,
182: FALSE
183: );
184: END IF;

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

212: l_cost_type VARCHAR2(10);
213: l_cost_group VARCHAR2(10);
214:
215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';
216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

213: l_cost_group VARCHAR2(10);
214:
215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';
216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

214:
215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';
216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

215: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.Display_Parameters';
216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
223: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

216: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
223: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
224: /*Bug 7305146*/

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

217: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
223: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
224: /*Bug 7305146*/
225: l_encoding VARCHAR2(20);

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

218: fnd_log.TEST(fnd_log.level_unexpected, l_module);
219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
223: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
224: /*Bug 7305146*/
225: l_encoding VARCHAR2(20);
226: l_xml_header VARCHAR2(100);

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

219: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
220: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
221: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
222: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
223: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
224: /*Bug 7305146*/
225: l_encoding VARCHAR2(20);
226: l_xml_header VARCHAR2(100);
227:

Line 230: fnd_log.string(

226: l_xml_header VARCHAR2(100);
227:
228: BEGIN
229: IF l_plog THEN
230: fnd_log.string(
231: fnd_log.level_procedure,
232: l_module||'.'||l_stmt_num,
233: 'Entering CST_eAM_WorkOrders_PVT.Display_Parameters with '||
234: 'p_init_msg_list = '||p_init_msg_list||','||

Line 231: fnd_log.level_procedure,

227:
228: BEGIN
229: IF l_plog THEN
230: fnd_log.string(
231: fnd_log.level_procedure,
232: l_module||'.'||l_stmt_num,
233: 'Entering CST_eAM_WorkOrders_PVT.Display_Parameters with '||
234: 'p_init_msg_list = '||p_init_msg_list||','||
235: 'p_validation_level = '||p_validation_level||','||

Line 358: fnd_log.string(

354: CLOSE l_ref_cur;
355: DBMS_LOB.FREETEMPORARY (l_xml_temp);
356:
357: IF l_plog THEN
358: fnd_log.string(
359: fnd_log.level_procedure,
360: l_module||'.'||l_stmt_num,
361: 'Exiting CST_eAM_WorkOrders_PVT.Display_Parameters with '||
362: 'x_return_status = '||x_return_status||','||

Line 359: fnd_log.level_procedure,

355: DBMS_LOB.FREETEMPORARY (l_xml_temp);
356:
357: IF l_plog THEN
358: fnd_log.string(
359: fnd_log.level_procedure,
360: l_module||'.'||l_stmt_num,
361: 'Exiting CST_eAM_WorkOrders_PVT.Display_Parameters with '||
362: 'x_return_status = '||x_return_status||','||
363: 'x_msg_count = '||x_msg_count||','||

Line 375: fnd_log.string(

371: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
372: p_procedure_name => 'Display_Parameters',
373: p_error_text => 'An exception has occurred.'
374: );
375: fnd_log.string(
376: fnd_log.level_exception,
377: l_module||'.'||l_stmt_num,
378: 'An exception has occurred.'
379: );

Line 376: fnd_log.level_exception,

372: p_procedure_name => 'Display_Parameters',
373: p_error_text => 'An exception has occurred.'
374: );
375: fnd_log.string(
376: fnd_log.level_exception,
377: l_module||'.'||l_stmt_num,
378: 'An exception has occurred.'
379: );
380: END IF;

Line 386: fnd_log.message(

382: IF l_uLog THEN
383: fnd_message.set_name('BOM','CST_UNEXPECTED');
384: fnd_message.set_token('SQLERRM',SQLERRM);
385: fnd_msg_pub.add;
386: fnd_log.message(
387: fnd_log.level_unexpected,
388: l_module||'.'||l_stmt_num,
389: FALSE
390: );

Line 387: fnd_log.level_unexpected,

383: fnd_message.set_name('BOM','CST_UNEXPECTED');
384: fnd_message.set_token('SQLERRM',SQLERRM);
385: fnd_msg_pub.add;
386: fnd_log.message(
387: fnd_log.level_unexpected,
388: l_module||'.'||l_stmt_num,
389: FALSE
390: );
391: END IF;

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

415: l_total_rows_processed NUMBER;
416: l_stmt_num NUMBER;
417:
418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';
419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

416: l_stmt_num NUMBER;
417:
418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';
419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

417:
418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';
419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

418: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details';
419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
426: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

419: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
426: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
427:

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

420: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
426: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
427:
428: BEGIN

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

421: fnd_log.TEST(fnd_log.level_unexpected, l_module);
422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
426: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
427:
428: BEGIN
429: l_stmt_num := 0;

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

422: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
423: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
424: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
425: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
426: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
427:
428: BEGIN
429: l_stmt_num := 0;
430: IF l_plog THEN

Line 431: fnd_log.string(

427:
428: BEGIN
429: l_stmt_num := 0;
430: IF l_plog THEN
431: fnd_log.string(
432: fnd_log.level_procedure,
433: l_module||'.'||l_stmt_num,
434: 'Entering CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
435: 'p_init_msg_list = '||p_init_msg_list||','||

Line 432: fnd_log.level_procedure,

428: BEGIN
429: l_stmt_num := 0;
430: IF l_plog THEN
431: fnd_log.string(
432: fnd_log.level_procedure,
433: l_module||'.'||l_stmt_num,
434: 'Entering CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
435: 'p_init_msg_list = '||p_init_msg_list||','||
436: 'p_validation_level = '||p_validation_level||','||

Line 633: fnd_log.string(

629: DBMS_LOB.writeappend (X_xml_doc, 12, '');
630:
631: l_stmt_num := 120;
632: IF l_plog THEN
633: fnd_log.string(
634: fnd_log.level_procedure,
635: l_module||'.'||l_stmt_num,
636: 'Exiting CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
637: 'x_return_status = '||x_return_status||','||

Line 634: fnd_log.level_procedure,

630:
631: l_stmt_num := 120;
632: IF l_plog THEN
633: fnd_log.string(
634: fnd_log.level_procedure,
635: l_module||'.'||l_stmt_num,
636: 'Exiting CST_eAM_WorkOrders_PVT.eAM_Est_Actual_details with '||
637: 'x_return_status = '||x_return_status||','||
638: 'x_msg_count = '||x_msg_count||','||

Line 651: fnd_log.string(

647: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
648: p_procedure_name => 'eAM_Est_Actual_details',
649: p_error_text => 'An exception has occurred.'
650: );
651: fnd_log.string(
652: fnd_log.level_exception,
653: l_module||'.'||l_stmt_num,
654: 'An exception has occurred.'
655: );

Line 652: fnd_log.level_exception,

648: p_procedure_name => 'eAM_Est_Actual_details',
649: p_error_text => 'An exception has occurred.'
650: );
651: fnd_log.string(
652: fnd_log.level_exception,
653: l_module||'.'||l_stmt_num,
654: 'An exception has occurred.'
655: );
656: END IF;

Line 662: fnd_log.message(

658: IF l_uLog THEN
659: fnd_message.set_name('BOM','CST_UNEXPECTED');
660: fnd_message.set_token('SQLERRM',SQLERRM);
661: fnd_msg_pub.add;
662: fnd_log.message(
663: fnd_log.level_unexpected,
664: l_module||'.'||l_stmt_num,
665: FALSE
666: );

Line 663: fnd_log.level_unexpected,

659: fnd_message.set_name('BOM','CST_UNEXPECTED');
660: fnd_message.set_token('SQLERRM',SQLERRM);
661: fnd_msg_pub.add;
662: fnd_log.message(
663: fnd_log.level_unexpected,
664: l_module||'.'||l_stmt_num,
665: FALSE
666: );
667: END IF;