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

Line 5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY CST_SLA_UPDATE_PKG AS
2: /* $Header: CSTPUPGB.pls 120.28 2008/05/16 22:10:30 anjha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_SLA_UPDATE_PKG';
5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
6: gUserId number := nvl(fnd_global.user_id, -888);
7: gLoginId number := nvl(fnd_global.login_id, -888);
8: gUpdateDate DATE := sysdate;
9:

Line 58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND

54: X_Argument10 in varchar2 default null)
55: IS
56:
57: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_MGR';
58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

Line 59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

55: IS
56:
57: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_MGR';
58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
63:

Line 60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

56:
57: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_MGR';
58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
63:
64: l_stmt_num number;

Line 61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

57: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_MGR';
58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
63:
64: l_stmt_num number;
65: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_MGR';

Line 62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

58: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
59: fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
63:
64: l_stmt_num number;
65: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_MGR';
66: l_api_version CONSTANT NUMBER := 1.0;

Line 101: fnd_log.string(

97: BEGIN
98:
99: l_stmt_num :=0;
100: IF l_plog THEN
101: fnd_log.string(
102: fnd_log.level_procedure,
103: l_module||'.begin',
104: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
105: 'X_batch_size = '||X_batch_size||','||

Line 102: fnd_log.level_procedure,

98:
99: l_stmt_num :=0;
100: IF l_plog THEN
101: fnd_log.string(
102: fnd_log.level_procedure,
103: l_module||'.begin',
104: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
105: 'X_batch_size = '||X_batch_size||','||
106: 'X_Num_Workers = '||X_Num_Workers||','||

Line 269: fnd_log.string(

265:
266: <>
267:
268: IF l_plog THEN
269: fnd_log.string(
270: fnd_log.level_procedure,
271: l_module||'.end',
272: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
273: 'X_errbuf = '||X_errbuf||','||

Line 270: fnd_log.level_procedure,

266: <>
267:
268: IF l_plog THEN
269: fnd_log.string(
270: fnd_log.level_procedure,
271: l_module||'.end',
272: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_MGR with '||
273: 'X_errbuf = '||X_errbuf||','||
274: 'X_retcode = '||X_retcode

Line 288: fnd_log.string(

284: p_pkg_name => 'CST_SLA_UPDATE_PKG',
285: p_procedure_name => 'Update_Proc_MGR',
286: p_error_text => 'Another Costing Upgrade Manager is running.'
287: );
288: fnd_log.string(
289: fnd_log.level_exception,
290: l_module||'.'||l_stmt_num,
291: 'Another Costing Upgrade Manager is running.'
292: );

Line 289: fnd_log.level_exception,

285: p_procedure_name => 'Update_Proc_MGR',
286: p_error_text => 'Another Costing Upgrade Manager is running.'
287: );
288: fnd_log.string(
289: fnd_log.level_exception,
290: l_module||'.'||l_stmt_num,
291: 'Another Costing Upgrade Manager is running.'
292: );
293: END IF;

Line 305: fnd_log.string(

301: p_pkg_name => 'CST_SLA_UPDATE_PKG',
302: p_procedure_name => 'Update_Proc_MGR',
303: p_error_text => 'Submit concurrent request failed.'
304: );
305: fnd_log.string(
306: fnd_log.level_exception,
307: l_module||'.'||l_stmt_num,
308: 'Submit concurrent request failed.'
309: );

Line 306: fnd_log.level_exception,

302: p_procedure_name => 'Update_Proc_MGR',
303: p_error_text => 'Submit concurrent request failed.'
304: );
305: fnd_log.string(
306: fnd_log.level_exception,
307: l_module||'.'||l_stmt_num,
308: 'Submit concurrent request failed.'
309: );
310: END IF;

Line 322: fnd_log.string(

318: p_pkg_name => 'CST_SLA_UPDATE_PKG',
319: p_procedure_name => 'Update_Proc_MGR',
320: p_error_text => 'An exception has occurred.'
321: );
322: fnd_log.string(
323: fnd_log.level_exception,
324: l_module||'.'||l_stmt_num,
325: 'An exception has occurred.'
326: );

Line 323: fnd_log.level_exception,

319: p_procedure_name => 'Update_Proc_MGR',
320: p_error_text => 'An exception has occurred.'
321: );
322: fnd_log.string(
323: fnd_log.level_exception,
324: l_module||'.'||l_stmt_num,
325: 'An exception has occurred.'
326: );
327: END IF;

Line 337: fnd_log.message(

333: IF l_errorLog THEN
334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);
336: fnd_msg_pub.add;
337: fnd_log.message(
338: fnd_log.level_error,
339: l_module||'.'||l_stmt_num,
340: FALSE
341: );

Line 338: fnd_log.level_error,

334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);
336: fnd_msg_pub.add;
337: fnd_log.message(
338: fnd_log.level_error,
339: l_module||'.'||l_stmt_num,
340: FALSE
341: );
342: END IF;

Line 348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

344: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
345:
346: WHEN OTHERS THEN
347: X_retcode := FND_API.g_ret_sts_unexp_error;
348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;
352: fnd_log.message(

Line 352: fnd_log.message(

348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;
352: fnd_log.message(
353: fnd_log.level_unexpected,
354: l_module||'.'||l_stmt_num,
355: FALSE
356: );

Line 353: fnd_log.level_unexpected,

349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;
352: fnd_log.message(
353: fnd_log.level_unexpected,
354: l_module||'.'||l_stmt_num,
355: FALSE
356: );
357: END IF;

Line 414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

410: l_retstatus boolean;
411: l_table_owner varchar2(30);
412:
413: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
415: fnd_log.TEST(fnd_log.level_unexpected, l_module);
416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

411: l_table_owner varchar2(30);
412:
413: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
415: fnd_log.TEST(fnd_log.level_unexpected, l_module);
416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
419:

Line 416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

412:
413: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
415: fnd_log.TEST(fnd_log.level_unexpected, l_module);
416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
419:
420: l_stmt_num number;

Line 417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

413: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
415: fnd_log.TEST(fnd_log.level_unexpected, l_module);
416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
419:
420: l_stmt_num number;
421: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_INV_MGR';

Line 418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

414: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
415: fnd_log.TEST(fnd_log.level_unexpected, l_module);
416: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
417: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
418: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
419:
420: l_stmt_num number;
421: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_INV_MGR';
422: l_api_version CONSTANT NUMBER := 1.0;

Line 428: fnd_log.string(

424:
425: BEGIN
426: l_stmt_num :=0;
427: IF l_plog THEN
428: fnd_log.string(
429: fnd_log.level_procedure,
430: l_module||'.begin',
431: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
432: 'X_batch_size = '||X_batch_size||','||

Line 429: fnd_log.level_procedure,

425: BEGIN
426: l_stmt_num :=0;
427: IF l_plog THEN
428: fnd_log.string(
429: fnd_log.level_procedure,
430: l_module||'.begin',
431: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
432: 'X_batch_size = '||X_batch_size||','||
433: 'X_Num_Workers = '||X_Num_Workers||','||

Line 502: fnd_log.string(

498: exception
499: when no_data_found then
500: fnd_file.put_line(FND_FILE.LOG, 'No Inventory Sub Ledger data needs to be upgraded.');
501: IF l_plog THEN
502: fnd_log.string(
503: fnd_log.level_procedure,
504: l_module||'.'||l_stmt_num,
505: 'No data found'||
506: 'X_errbuf = '||SQLERRM

Line 503: fnd_log.level_procedure,

499: when no_data_found then
500: fnd_file.put_line(FND_FILE.LOG, 'No Inventory Sub Ledger data needs to be upgraded.');
501: IF l_plog THEN
502: fnd_log.string(
503: fnd_log.level_procedure,
504: l_module||'.'||l_stmt_num,
505: 'No data found'||
506: 'X_errbuf = '||SQLERRM
507: );

Line 512: fnd_log.string(

508: END IF;
509: end;
510: else
511: IF l_plog THEN
512: fnd_log.string(
513: fnd_log.level_procedure,
514: l_module||'.'||l_stmt_num,
515: 'Cannot get schema name for product : '||l_product
516: );

Line 513: fnd_log.level_procedure,

509: end;
510: else
511: IF l_plog THEN
512: fnd_log.string(
513: fnd_log.level_procedure,
514: l_module||'.'||l_stmt_num,
515: 'Cannot get schema name for product : '||l_product
516: );
517: END IF;

Line 526: fnd_log.string(

522:
523: <>
524:
525: IF l_plog THEN
526: fnd_log.string(
527: fnd_log.level_procedure,
528: l_module||'.end',
529: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
530: 'X_errbuf = '||X_errbuf||','||

Line 527: fnd_log.level_procedure,

523: <>
524:
525: IF l_plog THEN
526: fnd_log.string(
527: fnd_log.level_procedure,
528: l_module||'.end',
529: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR with '||
530: 'X_errbuf = '||X_errbuf||','||
531: 'X_retcode = '||X_retcode

Line 545: fnd_log.string(

541: p_pkg_name => 'CST_SLA_UPDATE_PKG',
542: p_procedure_name => 'Update_Proc_INV_MGR',
543: p_error_text => 'An exception has occurred.'
544: );
545: fnd_log.string(
546: fnd_log.level_exception,
547: l_module||'.'||l_stmt_num,
548: 'An exception has occurred.'
549: );

Line 546: fnd_log.level_exception,

542: p_procedure_name => 'Update_Proc_INV_MGR',
543: p_error_text => 'An exception has occurred.'
544: );
545: fnd_log.string(
546: fnd_log.level_exception,
547: l_module||'.'||l_stmt_num,
548: 'An exception has occurred.'
549: );
550: END IF;

Line 560: fnd_log.message(

556: IF l_errorLog THEN
557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);
559: fnd_msg_pub.add;
560: fnd_log.message(
561: fnd_log.level_error,
562: l_module||'.'||l_stmt_num,
563: FALSE
564: );

Line 561: fnd_log.level_error,

557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);
559: fnd_msg_pub.add;
560: fnd_log.message(
561: fnd_log.level_error,
562: l_module||'.'||l_stmt_num,
563: FALSE
564: );
565: END IF;

Line 571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

567: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
568:
569: WHEN OTHERS THEN
570: X_retcode := FND_API.g_ret_sts_unexp_error;
571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;
575: fnd_log.message(

Line 575: fnd_log.message(

571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;
575: fnd_log.message(
576: fnd_log.level_unexpected,
577: l_module||'.'||l_stmt_num,
578: FALSE
579: );

Line 576: fnd_log.level_unexpected,

572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;
575: fnd_log.message(
576: fnd_log.level_unexpected,
577: l_module||'.'||l_stmt_num,
578: FALSE
579: );
580: END IF;

Line 637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

633: l_retstatus boolean;
634: l_table_owner varchar2(30);
635:
636: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
638: fnd_log.TEST(fnd_log.level_unexpected, l_module);
639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

634: l_table_owner varchar2(30);
635:
636: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
638: fnd_log.TEST(fnd_log.level_unexpected, l_module);
639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
642:

Line 639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

635:
636: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
638: fnd_log.TEST(fnd_log.level_unexpected, l_module);
639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
642:
643: l_stmt_num number;

Line 640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

636: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
638: fnd_log.TEST(fnd_log.level_unexpected, l_module);
639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
642:
643: l_stmt_num number;
644: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_WIP_MGR';

Line 641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

637: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
638: fnd_log.TEST(fnd_log.level_unexpected, l_module);
639: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
640: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
641: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
642:
643: l_stmt_num number;
644: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_WIP_MGR';
645: l_api_version CONSTANT NUMBER := 1.0;

Line 651: fnd_log.string(

647:
648: BEGIN
649: l_stmt_num :=0;
650: IF l_plog THEN
651: fnd_log.string(
652: fnd_log.level_procedure,
653: l_module||'.begin',
654: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
655: 'X_batch_size = '||X_batch_size||','||

Line 652: fnd_log.level_procedure,

648: BEGIN
649: l_stmt_num :=0;
650: IF l_plog THEN
651: fnd_log.string(
652: fnd_log.level_procedure,
653: l_module||'.begin',
654: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
655: 'X_batch_size = '||X_batch_size||','||
656: 'X_Num_Workers = '||X_Num_Workers||','||

Line 724: fnd_log.string(

720: exception
721: when no_data_found then
722: fnd_file.put_line(FND_FILE.LOG, 'No WIP Sub Ledger data needs to be upgraded.');
723: IF l_plog THEN
724: fnd_log.string(
725: fnd_log.level_procedure,
726: l_module||'.'||l_stmt_num,
727: 'No data found'||
728: 'X_errbuf = '||SQLERRM

Line 725: fnd_log.level_procedure,

721: when no_data_found then
722: fnd_file.put_line(FND_FILE.LOG, 'No WIP Sub Ledger data needs to be upgraded.');
723: IF l_plog THEN
724: fnd_log.string(
725: fnd_log.level_procedure,
726: l_module||'.'||l_stmt_num,
727: 'No data found'||
728: 'X_errbuf = '||SQLERRM
729: );

Line 734: fnd_log.string(

730: END IF;
731: end;
732: else
733: IF l_plog THEN
734: fnd_log.string(
735: fnd_log.level_procedure,
736: l_module||'.'||l_stmt_num,
737: 'Cannot get schema name for product : '||l_product
738: );

Line 735: fnd_log.level_procedure,

731: end;
732: else
733: IF l_plog THEN
734: fnd_log.string(
735: fnd_log.level_procedure,
736: l_module||'.'||l_stmt_num,
737: 'Cannot get schema name for product : '||l_product
738: );
739: END IF;

Line 748: fnd_log.string(

744:
745: <>
746:
747: IF l_plog THEN
748: fnd_log.string(
749: fnd_log.level_procedure,
750: l_module||'.end',
751: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
752: 'X_errbuf = '||X_errbuf||','||

Line 749: fnd_log.level_procedure,

745: <>
746:
747: IF l_plog THEN
748: fnd_log.string(
749: fnd_log.level_procedure,
750: l_module||'.end',
751: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR with '||
752: 'X_errbuf = '||X_errbuf||','||
753: 'X_retcode = '||X_retcode

Line 767: fnd_log.string(

763: p_pkg_name => 'CST_SLA_UPDATE_PKG',
764: p_procedure_name => 'Update_Proc_WIP_MGR',
765: p_error_text => 'An exception has occurred.'
766: );
767: fnd_log.string(
768: fnd_log.level_exception,
769: l_module||'.'||l_stmt_num,
770: 'An exception has occurred.'
771: );

Line 768: fnd_log.level_exception,

764: p_procedure_name => 'Update_Proc_WIP_MGR',
765: p_error_text => 'An exception has occurred.'
766: );
767: fnd_log.string(
768: fnd_log.level_exception,
769: l_module||'.'||l_stmt_num,
770: 'An exception has occurred.'
771: );
772: END IF;

Line 782: fnd_log.message(

778: IF l_errorLog THEN
779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);
781: fnd_msg_pub.add;
782: fnd_log.message(
783: fnd_log.level_error,
784: l_module||'.'||l_stmt_num,
785: FALSE
786: );

Line 783: fnd_log.level_error,

779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);
781: fnd_msg_pub.add;
782: fnd_log.message(
783: fnd_log.level_error,
784: l_module||'.'||l_stmt_num,
785: FALSE
786: );
787: END IF;

Line 793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

789: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
790:
791: WHEN OTHERS THEN
792: X_retcode := FND_API.g_ret_sts_unexp_error;
793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;
797: fnd_log.message(

Line 797: fnd_log.message(

793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;
797: fnd_log.message(
798: fnd_log.level_unexpected,
799: l_module||'.'||l_stmt_num,
800: FALSE
801: );

Line 798: fnd_log.level_unexpected,

794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;
797: fnd_log.message(
798: fnd_log.level_unexpected,
799: l_module||'.'||l_stmt_num,
800: FALSE
801: );
802: END IF;

Line 859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

855: l_retstatus boolean;
856: l_table_owner varchar2(30);
857:
858: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
860: fnd_log.TEST(fnd_log.level_unexpected, l_module);
861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

856: l_table_owner varchar2(30);
857:
858: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
860: fnd_log.TEST(fnd_log.level_unexpected, l_module);
861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
864:

Line 861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

857:
858: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
860: fnd_log.TEST(fnd_log.level_unexpected, l_module);
861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
864:
865: l_stmt_num number;

Line 862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

858: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
860: fnd_log.TEST(fnd_log.level_unexpected, l_module);
861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
864:
865: l_stmt_num number;
866: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_RCV_MGR';

Line 863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

859: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
860: fnd_log.TEST(fnd_log.level_unexpected, l_module);
861: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
862: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
863: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
864:
865: l_stmt_num number;
866: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_RCV_MGR';
867: l_api_version CONSTANT NUMBER := 1.0;

Line 873: fnd_log.string(

869:
870: BEGIN
871: l_stmt_num :=0;
872: IF l_plog THEN
873: fnd_log.string(
874: fnd_log.level_procedure,
875: l_module||'.begin',
876: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
877: 'X_batch_size = '||X_batch_size||','||

Line 874: fnd_log.level_procedure,

870: BEGIN
871: l_stmt_num :=0;
872: IF l_plog THEN
873: fnd_log.string(
874: fnd_log.level_procedure,
875: l_module||'.begin',
876: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
877: 'X_batch_size = '||X_batch_size||','||
878: 'X_Num_Workers = '||X_Num_Workers||','||

Line 946: fnd_log.string(

942: exception
943: when no_data_found then
944: fnd_file.put_line(FND_FILE.LOG, 'No Receiving Sub Ledger data needs to be upgraded.');
945: IF l_plog THEN
946: fnd_log.string(
947: fnd_log.level_procedure,
948: l_module||'.'||l_stmt_num,
949: 'No data found'||
950: 'X_errbuf = '||SQLERRM

Line 947: fnd_log.level_procedure,

943: when no_data_found then
944: fnd_file.put_line(FND_FILE.LOG, 'No Receiving Sub Ledger data needs to be upgraded.');
945: IF l_plog THEN
946: fnd_log.string(
947: fnd_log.level_procedure,
948: l_module||'.'||l_stmt_num,
949: 'No data found'||
950: 'X_errbuf = '||SQLERRM
951: );

Line 956: fnd_log.string(

952: END IF;
953: end;
954: else
955: IF l_plog THEN
956: fnd_log.string(
957: fnd_log.level_procedure,
958: l_module||'.'||l_stmt_num,
959: 'Cannot get schema name for product : '||l_product
960: );

Line 957: fnd_log.level_procedure,

953: end;
954: else
955: IF l_plog THEN
956: fnd_log.string(
957: fnd_log.level_procedure,
958: l_module||'.'||l_stmt_num,
959: 'Cannot get schema name for product : '||l_product
960: );
961: END IF;

Line 969: fnd_log.string(

965:
966: <>
967:
968: IF l_plog THEN
969: fnd_log.string(
970: fnd_log.level_procedure,
971: l_module||'.end',
972: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
973: 'X_errbuf = '||X_errbuf||','||

Line 970: fnd_log.level_procedure,

966: <>
967:
968: IF l_plog THEN
969: fnd_log.string(
970: fnd_log.level_procedure,
971: l_module||'.end',
972: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR with '||
973: 'X_errbuf = '||X_errbuf||','||
974: 'X_retcode = '||X_retcode

Line 988: fnd_log.string(

984: p_pkg_name => 'CST_SLA_UPDATE_PKG',
985: p_procedure_name => 'Update_Proc_RCV_MGR',
986: p_error_text => 'An exception has occurred.'
987: );
988: fnd_log.string(
989: fnd_log.level_exception,
990: l_module||'.'||l_stmt_num,
991: 'An exception has occurred.'
992: );

Line 989: fnd_log.level_exception,

985: p_procedure_name => 'Update_Proc_RCV_MGR',
986: p_error_text => 'An exception has occurred.'
987: );
988: fnd_log.string(
989: fnd_log.level_exception,
990: l_module||'.'||l_stmt_num,
991: 'An exception has occurred.'
992: );
993: END IF;

Line 1003: fnd_log.message(

999: IF l_errorLog THEN
1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);
1002: fnd_msg_pub.add;
1003: fnd_log.message(
1004: fnd_log.level_error,
1005: l_module||'.'||l_stmt_num,
1006: FALSE
1007: );

Line 1004: fnd_log.level_error,

1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);
1002: fnd_msg_pub.add;
1003: fnd_log.message(
1004: fnd_log.level_error,
1005: l_module||'.'||l_stmt_num,
1006: FALSE
1007: );
1008: END IF;

Line 1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

1010: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1011:
1012: WHEN OTHERS THEN
1013: X_retcode := FND_API.g_ret_sts_unexp_error;
1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;
1018: fnd_log.message(

Line 1018: fnd_log.message(

1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;
1018: fnd_log.message(
1019: fnd_log.level_unexpected,
1020: l_module||'.'||l_stmt_num,
1021: FALSE
1022: );

Line 1019: fnd_log.level_unexpected,

1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;
1018: fnd_log.message(
1019: fnd_log.level_unexpected,
1020: l_module||'.'||l_stmt_num,
1021: FALSE
1022: );
1023: END IF;

Line 1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

1091: l_rows_processed number;
1092:
1093: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR';
1094:
1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1096: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

1092:
1093: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR';
1094:
1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1096: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1100:

Line 1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

1093: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR';
1094:
1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1096: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1100:
1101: l_stmt_num number;

Line 1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

1094:
1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1096: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1100:
1101: l_stmt_num number;
1102: update_subledger_exception exception;

Line 1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

1095: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1096: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1097: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1098: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1099: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1100:
1101: l_stmt_num number;
1102: update_subledger_exception exception;
1103: l_conc_status BOOLEAN;

Line 1109: fnd_log.string(

1105: BEGIN
1106: l_stmt_num :=0;
1107:
1108: IF l_plog THEN
1109: fnd_log.string(
1110: fnd_log.level_procedure,
1111: l_module||'.begin',
1112: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1113: 'X_batch_size = '||X_batch_size||','||

Line 1110: fnd_log.level_procedure,

1106: l_stmt_num :=0;
1107:
1108: IF l_plog THEN
1109: fnd_log.string(
1110: fnd_log.level_procedure,
1111: l_module||'.begin',
1112: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1113: 'X_batch_size = '||X_batch_size||','||
1114: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1205: fnd_log.string(

1201:
1202: <>
1203:
1204: IF l_plog THEN
1205: fnd_log.string(
1206: fnd_log.level_procedure,
1207: l_module||'.end',
1208: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1209: 'X_errbuf = '||X_errbuf||','||

Line 1206: fnd_log.level_procedure,

1202: <>
1203:
1204: IF l_plog THEN
1205: fnd_log.string(
1206: fnd_log.level_procedure,
1207: l_module||'.end',
1208: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_INV_WKR with '||
1209: 'X_errbuf = '||X_errbuf||','||
1210: 'X_retcode = '||X_retcode

Line 1221: fnd_log.message(

1217: IF l_errorLog THEN
1218: fnd_message.set_name('BOM','CST_ERROR');
1219: fnd_message.set_token('SQLERRM',SQLERRM);
1220: fnd_msg_pub.add;
1221: fnd_log.message(
1222: fnd_log.level_error,
1223: l_module||'.'||l_stmt_num,
1224: FALSE
1225: );

Line 1222: fnd_log.level_error,

1218: fnd_message.set_name('BOM','CST_ERROR');
1219: fnd_message.set_token('SQLERRM',SQLERRM);
1220: fnd_msg_pub.add;
1221: fnd_log.message(
1222: fnd_log.level_error,
1223: l_module||'.'||l_stmt_num,
1224: FALSE
1225: );
1226: END IF;

Line 1239: fnd_log.string(

1235: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1236: p_procedure_name => 'Update_Proc_INV_WKR',
1237: p_error_text => 'An exception has occurred.'
1238: );
1239: fnd_log.string(
1240: fnd_log.level_exception,
1241: l_module||'.'||l_stmt_num,
1242: 'An exception has occurred.'
1243: );

Line 1240: fnd_log.level_exception,

1236: p_procedure_name => 'Update_Proc_INV_WKR',
1237: p_error_text => 'An exception has occurred.'
1238: );
1239: fnd_log.string(
1240: fnd_log.level_exception,
1241: l_module||'.'||l_stmt_num,
1242: 'An exception has occurred.'
1243: );
1244: END IF;

Line 1255: fnd_log.message(

1251: IF l_errorLog THEN
1252: fnd_message.set_name('BOM','CST_ERROR');
1253: fnd_message.set_token('SQLERRM',SQLERRM);
1254: fnd_msg_pub.add;
1255: fnd_log.message(
1256: fnd_log.level_error,
1257: l_module||'.'||l_stmt_num,
1258: FALSE
1259: );

Line 1256: fnd_log.level_error,

1252: fnd_message.set_name('BOM','CST_ERROR');
1253: fnd_message.set_token('SQLERRM',SQLERRM);
1254: fnd_msg_pub.add;
1255: fnd_log.message(
1256: fnd_log.level_error,
1257: l_module||'.'||l_stmt_num,
1258: FALSE
1259: );
1260: END IF;

Line 1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

1263:
1264: WHEN OTHERS THEN
1265: ROLLBACK;
1266: X_retcode := FND_API.g_ret_sts_unexp_error;
1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;
1271: fnd_log.message(

Line 1271: fnd_log.message(

1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;
1271: fnd_log.message(
1272: fnd_log.level_unexpected,
1273: l_module||'.'||l_stmt_num,
1274: FALSE
1275: );

Line 1272: fnd_log.level_unexpected,

1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;
1271: fnd_log.message(
1272: fnd_log.level_unexpected,
1273: l_module||'.'||l_stmt_num,
1274: FALSE
1275: );
1276: END IF;

Line 1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

1342: l_rows_processed number;
1343:
1344: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR';
1345:
1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1347: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

1343:
1344: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR';
1345:
1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1347: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1351:

Line 1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

1344: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR';
1345:
1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1347: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1351:
1352: l_stmt_num number;

Line 1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

1345:
1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1347: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1351:
1352: l_stmt_num number;
1353: update_subledger_exception exception;

Line 1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

1346: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1347: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1348: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1349: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1350: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1351:
1352: l_stmt_num number;
1353: update_subledger_exception exception;
1354: l_conc_status BOOLEAN;

Line 1360: fnd_log.string(

1356: BEGIN
1357: l_stmt_num :=0;
1358:
1359: IF l_plog THEN
1360: fnd_log.string(
1361: fnd_log.level_procedure,
1362: l_module||'.begin',
1363: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1364: 'X_batch_size = '||X_batch_size||','||

Line 1361: fnd_log.level_procedure,

1357: l_stmt_num :=0;
1358:
1359: IF l_plog THEN
1360: fnd_log.string(
1361: fnd_log.level_procedure,
1362: l_module||'.begin',
1363: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1364: 'X_batch_size = '||X_batch_size||','||
1365: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1455: fnd_log.string(

1451:
1452: <>
1453:
1454: IF l_plog THEN
1455: fnd_log.string(
1456: fnd_log.level_procedure,
1457: l_module||'.end',
1458: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1459: 'X_errbuf = '||X_errbuf||','||

Line 1456: fnd_log.level_procedure,

1452: <>
1453:
1454: IF l_plog THEN
1455: fnd_log.string(
1456: fnd_log.level_procedure,
1457: l_module||'.end',
1458: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_WIP_WKR with '||
1459: 'X_errbuf = '||X_errbuf||','||
1460: 'X_retcode = '||X_retcode

Line 1471: fnd_log.message(

1467: IF l_errorLog THEN
1468: fnd_message.set_name('BOM','CST_ERROR');
1469: fnd_message.set_token('SQLERRM',SQLERRM);
1470: fnd_msg_pub.add;
1471: fnd_log.message(
1472: fnd_log.level_error,
1473: l_module||'.'||l_stmt_num,
1474: FALSE
1475: );

Line 1472: fnd_log.level_error,

1468: fnd_message.set_name('BOM','CST_ERROR');
1469: fnd_message.set_token('SQLERRM',SQLERRM);
1470: fnd_msg_pub.add;
1471: fnd_log.message(
1472: fnd_log.level_error,
1473: l_module||'.'||l_stmt_num,
1474: FALSE
1475: );
1476: END IF;

Line 1489: fnd_log.string(

1485: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1486: p_procedure_name => 'Update_Proc_WIP_WKR',
1487: p_error_text => 'An exception has occurred.'
1488: );
1489: fnd_log.string(
1490: fnd_log.level_exception,
1491: l_module||'.'||l_stmt_num,
1492: 'An exception has occurred.'
1493: );

Line 1490: fnd_log.level_exception,

1486: p_procedure_name => 'Update_Proc_WIP_WKR',
1487: p_error_text => 'An exception has occurred.'
1488: );
1489: fnd_log.string(
1490: fnd_log.level_exception,
1491: l_module||'.'||l_stmt_num,
1492: 'An exception has occurred.'
1493: );
1494: END IF;

Line 1505: fnd_log.message(

1501: IF l_errorLog THEN
1502: fnd_message.set_name('BOM','CST_ERROR');
1503: fnd_message.set_token('SQLERRM',SQLERRM);
1504: fnd_msg_pub.add;
1505: fnd_log.message(
1506: fnd_log.level_error,
1507: l_module||'.'||l_stmt_num,
1508: FALSE
1509: );

Line 1506: fnd_log.level_error,

1502: fnd_message.set_name('BOM','CST_ERROR');
1503: fnd_message.set_token('SQLERRM',SQLERRM);
1504: fnd_msg_pub.add;
1505: fnd_log.message(
1506: fnd_log.level_error,
1507: l_module||'.'||l_stmt_num,
1508: FALSE
1509: );
1510: END IF;

Line 1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK;
1516: X_retcode := FND_API.g_ret_sts_unexp_error;
1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;
1521: fnd_log.message(

Line 1521: fnd_log.message(

1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;
1521: fnd_log.message(
1522: fnd_log.level_unexpected,
1523: l_module||'.'||l_stmt_num,
1524: FALSE
1525: );

Line 1522: fnd_log.level_unexpected,

1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;
1521: fnd_log.message(
1522: fnd_log.level_unexpected,
1523: l_module||'.'||l_stmt_num,
1524: FALSE
1525: );
1526: END IF;

Line 1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

1593: l_rows_processed number;
1594:
1595: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR';
1596:
1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1598: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

1594:
1595: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR';
1596:
1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1598: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1602:

Line 1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

1595: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR';
1596:
1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1598: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1602:
1603: l_stmt_num number;

Line 1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

1596:
1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1598: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1602:
1603: l_stmt_num number;
1604: update_subledger_exception exception;

Line 1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

1597: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1598: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1599: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1600: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1601: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1602:
1603: l_stmt_num number;
1604: update_subledger_exception exception;
1605: l_conc_status BOOLEAN;

Line 1612: fnd_log.string(

1608: BEGIN
1609: l_stmt_num :=0;
1610:
1611: IF l_plog THEN
1612: fnd_log.string(
1613: fnd_log.level_procedure,
1614: l_module||'.begin',
1615: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
1616: 'X_batch_size = '||X_batch_size||','||

Line 1613: fnd_log.level_procedure,

1609: l_stmt_num :=0;
1610:
1611: IF l_plog THEN
1612: fnd_log.string(
1613: fnd_log.level_procedure,
1614: l_module||'.begin',
1615: 'Entering CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
1616: 'X_batch_size = '||X_batch_size||','||
1617: 'X_Worker_Id = '||X_Worker_Id||','||

Line 1728: fnd_log.string(

1724:
1725: <>
1726:
1727: IF l_plog THEN
1728: fnd_log.string(
1729: fnd_log.level_procedure,
1730: l_module||'.end',
1731: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
1732: 'X_errbuf = '||X_errbuf||','||

Line 1729: fnd_log.level_procedure,

1725: <>
1726:
1727: IF l_plog THEN
1728: fnd_log.string(
1729: fnd_log.level_procedure,
1730: l_module||'.end',
1731: 'Exiting CST_SLA_UPDATE_PKG.Update_Proc_RCV_WKR with '||
1732: 'X_errbuf = '||X_errbuf||','||
1733: 'X_retcode = '||X_retcode

Line 1744: fnd_log.message(

1740: IF l_errorLog THEN
1741: fnd_message.set_name('BOM','CST_ERROR');
1742: fnd_message.set_token('SQLERRM',SQLERRM);
1743: fnd_msg_pub.add;
1744: fnd_log.message(
1745: fnd_log.level_error,
1746: l_module||'.'||l_stmt_num,
1747: FALSE
1748: );

Line 1745: fnd_log.level_error,

1741: fnd_message.set_name('BOM','CST_ERROR');
1742: fnd_message.set_token('SQLERRM',SQLERRM);
1743: fnd_msg_pub.add;
1744: fnd_log.message(
1745: fnd_log.level_error,
1746: l_module||'.'||l_stmt_num,
1747: FALSE
1748: );
1749: END IF;

Line 1762: fnd_log.string(

1758: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1759: p_procedure_name => 'Update_Proc_RCV_WKR',
1760: p_error_text => 'An exception has occurred.'
1761: );
1762: fnd_log.string(
1763: fnd_log.level_exception,
1764: l_module||'.'||l_stmt_num,
1765: 'An exception has occurred.'
1766: );

Line 1763: fnd_log.level_exception,

1759: p_procedure_name => 'Update_Proc_RCV_WKR',
1760: p_error_text => 'An exception has occurred.'
1761: );
1762: fnd_log.string(
1763: fnd_log.level_exception,
1764: l_module||'.'||l_stmt_num,
1765: 'An exception has occurred.'
1766: );
1767: END IF;

Line 1778: fnd_log.message(

1774: IF l_errorLog THEN
1775: fnd_message.set_name('BOM','CST_ERROR');
1776: fnd_message.set_token('SQLERRM',SQLERRM);
1777: fnd_msg_pub.add;
1778: fnd_log.message(
1779: fnd_log.level_error,
1780: l_module||'.'||l_stmt_num,
1781: FALSE
1782: );

Line 1779: fnd_log.level_error,

1775: fnd_message.set_name('BOM','CST_ERROR');
1776: fnd_message.set_token('SQLERRM',SQLERRM);
1777: fnd_msg_pub.add;
1778: fnd_log.message(
1779: fnd_log.level_error,
1780: l_module||'.'||l_stmt_num,
1781: FALSE
1782: );
1783: END IF;

Line 1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

1784: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: X_retcode := FND_API.g_ret_sts_unexp_error;
1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;
1792: fnd_log.message(

Line 1792: fnd_log.message(

1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;
1792: fnd_log.message(
1793: fnd_log.level_unexpected,
1794: l_module||'.'||l_stmt_num,
1795: FALSE
1796: );

Line 1793: fnd_log.level_unexpected,

1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;
1792: fnd_log.message(
1793: fnd_log.level_unexpected,
1794: l_module||'.'||l_stmt_num,
1795: FALSE
1796: );
1797: END IF;

Line 1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

1828: l_je_category_name varchar2(30);
1829:
1830: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Inventory_Subledger';
1831:
1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1833: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

1829:
1830: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Inventory_Subledger';
1831:
1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1833: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1837:

Line 1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

1830: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Inventory_Subledger';
1831:
1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1833: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1837:
1838: l_stmt_num number;

Line 1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

1831:
1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1833: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1837:
1838: l_stmt_num number;
1839: l_rows_processed number;

Line 1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

1832: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
1833: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1834: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
1835: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
1836: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
1837:
1838: l_stmt_num number;
1839: l_rows_processed number;
1840:

Line 1845: fnd_log.string(

1841: BEGIN
1842: l_stmt_num :=0;
1843:
1844: IF l_plog THEN
1845: fnd_log.string(
1846: fnd_log.level_procedure,
1847: l_module||'.begin',
1848: 'Entering CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
1849: 'X_min_id = '||X_min_id||','||

Line 1846: fnd_log.level_procedure,

1842: l_stmt_num :=0;
1843:
1844: IF l_plog THEN
1845: fnd_log.string(
1846: fnd_log.level_procedure,
1847: l_module||'.begin',
1848: 'Entering CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
1849: 'X_min_id = '||X_min_id||','||
1850: 'X_max_id = '||X_max_id

Line 2565: fnd_log.string(

2561:
2562: <>
2563:
2564: IF l_plog THEN
2565: fnd_log.string(
2566: fnd_log.level_procedure,
2567: l_module||'.end',
2568: 'Exiting CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
2569: 'X_errbuf = '||X_errbuf||','||

Line 2566: fnd_log.level_procedure,

2562: <>
2563:
2564: IF l_plog THEN
2565: fnd_log.string(
2566: fnd_log.level_procedure,
2567: l_module||'.end',
2568: 'Exiting CST_SLA_UPDATE_PKG.Update_Inventory_Subledger with '||
2569: 'X_errbuf = '||X_errbuf||','||
2570: 'X_retcode = '||X_retcode

Line 2585: fnd_log.string(

2581: p_pkg_name => 'CST_SLA_UPDATE_PKG',
2582: p_procedure_name => 'Update_Inventory_Subledger',
2583: p_error_text => 'An exception has occurred.'
2584: );
2585: fnd_log.string(
2586: fnd_log.level_exception,
2587: l_module||'.'||l_stmt_num,
2588: 'An exception has occurred.'
2589: );

Line 2586: fnd_log.level_exception,

2582: p_procedure_name => 'Update_Inventory_Subledger',
2583: p_error_text => 'An exception has occurred.'
2584: );
2585: fnd_log.string(
2586: fnd_log.level_exception,
2587: l_module||'.'||l_stmt_num,
2588: 'An exception has occurred.'
2589: );
2590: END IF;

Line 2599: fnd_log.message(

2595: IF l_errorLog THEN
2596: fnd_message.set_name('BOM','CST_ERROR');
2597: fnd_message.set_token('SQLERRM',SQLERRM);
2598: fnd_msg_pub.add;
2599: fnd_log.message(
2600: fnd_log.level_error,
2601: l_module||'.'||l_stmt_num,
2602: FALSE
2603: );

Line 2600: fnd_log.level_error,

2596: fnd_message.set_name('BOM','CST_ERROR');
2597: fnd_message.set_token('SQLERRM',SQLERRM);
2598: fnd_msg_pub.add;
2599: fnd_log.message(
2600: fnd_log.level_error,
2601: l_module||'.'||l_stmt_num,
2602: FALSE
2603: );
2604: END IF;

Line 2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

2605: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
2606: WHEN OTHERS THEN
2607: ROLLBACK;
2608: X_retcode := FND_API.g_ret_sts_unexp_error;
2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;
2613: fnd_log.message(

Line 2613: fnd_log.message(

2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;
2613: fnd_log.message(
2614: fnd_log.level_unexpected,
2615: l_module||'.'||l_stmt_num,
2616: FALSE
2617: );

Line 2614: fnd_log.level_unexpected,

2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;
2613: fnd_log.message(
2614: fnd_log.level_unexpected,
2615: l_module||'.'||l_stmt_num,
2616: FALSE
2617: );
2618: END IF;

Line 2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

2647: l_je_category_name varchar2(30);
2648:
2649: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_WIP_Subledger';
2650:
2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
2652: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

2648:
2649: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_WIP_Subledger';
2650:
2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
2652: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
2656:

Line 2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

2649: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_WIP_Subledger';
2650:
2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
2652: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
2656:
2657: l_stmt_num number;

Line 2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

2650:
2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
2652: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
2656:
2657: l_stmt_num number;
2658: l_rows_processed number;

Line 2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

2651: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
2652: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2653: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
2654: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
2655: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
2656:
2657: l_stmt_num number;
2658: l_rows_processed number;
2659: BEGIN

Line 2663: fnd_log.string(

2659: BEGIN
2660: l_stmt_num :=0;
2661:
2662: IF l_plog THEN
2663: fnd_log.string(
2664: fnd_log.level_procedure,
2665: l_module||'.begin',
2666: 'Entering CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
2667: 'X_min_id = '||X_min_id||','||

Line 2664: fnd_log.level_procedure,

2660: l_stmt_num :=0;
2661:
2662: IF l_plog THEN
2663: fnd_log.string(
2664: fnd_log.level_procedure,
2665: l_module||'.begin',
2666: 'Entering CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
2667: 'X_min_id = '||X_min_id||','||
2668: 'X_max_id = '||X_max_id

Line 3115: fnd_log.string(

3111:
3112: <>
3113:
3114: IF l_plog THEN
3115: fnd_log.string(
3116: fnd_log.level_procedure,
3117: l_module||'.end',
3118: 'Exiting CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
3119: 'X_errbuf = '||X_errbuf||','||

Line 3116: fnd_log.level_procedure,

3112: <>
3113:
3114: IF l_plog THEN
3115: fnd_log.string(
3116: fnd_log.level_procedure,
3117: l_module||'.end',
3118: 'Exiting CST_SLA_UPDATE_PKG.Update_WIP_Subledger with '||
3119: 'X_errbuf = '||X_errbuf||','||
3120: 'X_retcode = '||X_retcode

Line 3135: fnd_log.string(

3131: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3132: p_procedure_name => 'Update_WIP_Subledger',
3133: p_error_text => 'An exception has occurred.'
3134: );
3135: fnd_log.string(
3136: fnd_log.level_exception,
3137: l_module||'.'||l_stmt_num,
3138: 'An exception has occurred.'
3139: );

Line 3136: fnd_log.level_exception,

3132: p_procedure_name => 'Update_WIP_Subledger',
3133: p_error_text => 'An exception has occurred.'
3134: );
3135: fnd_log.string(
3136: fnd_log.level_exception,
3137: l_module||'.'||l_stmt_num,
3138: 'An exception has occurred.'
3139: );
3140: END IF;

Line 3149: fnd_log.message(

3145: IF l_errorLog THEN
3146: fnd_message.set_name('BOM','CST_ERROR');
3147: fnd_message.set_token('SQLERRM',SQLERRM);
3148: fnd_msg_pub.add;
3149: fnd_log.message(
3150: fnd_log.level_error,
3151: l_module||'.'||l_stmt_num,
3152: FALSE
3153: );

Line 3150: fnd_log.level_error,

3146: fnd_message.set_name('BOM','CST_ERROR');
3147: fnd_message.set_token('SQLERRM',SQLERRM);
3148: fnd_msg_pub.add;
3149: fnd_log.message(
3150: fnd_log.level_error,
3151: l_module||'.'||l_stmt_num,
3152: FALSE
3153: );
3154: END IF;

Line 3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

3155: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
3156: WHEN OTHERS THEN
3157: ROLLBACK;
3158: X_retcode := FND_API.g_ret_sts_unexp_error;
3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;
3163: fnd_log.message(

Line 3163: fnd_log.message(

3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;
3163: fnd_log.message(
3164: fnd_log.level_unexpected,
3165: l_module||'.'||l_stmt_num,
3166: FALSE
3167: );

Line 3164: fnd_log.level_unexpected,

3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;
3163: fnd_log.message(
3164: fnd_log.level_unexpected,
3165: l_module||'.'||l_stmt_num,
3166: FALSE
3167: );
3168: END IF;

Line 3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

3199: l_je_category_name varchar2(30);
3200:
3201: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Receiving_Subledger';
3202:
3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
3204: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

3200:
3201: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Receiving_Subledger';
3202:
3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
3204: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
3208:

Line 3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

3201: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Receiving_Subledger';
3202:
3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
3204: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
3208:
3209: l_stmt_num number;

Line 3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

3202:
3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
3204: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
3208:
3209: l_stmt_num number;
3210: l_multi_org_flag varchar2(1);

Line 3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

3203: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
3204: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3205: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
3206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
3207: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
3208:
3209: l_stmt_num number;
3210: l_multi_org_flag varchar2(1);
3211: l_rows_processed number;

Line 3218: fnd_log.string(

3214: BEGIN
3215: l_stmt_num :=0;
3216:
3217: IF l_plog THEN
3218: fnd_log.string(
3219: fnd_log.level_procedure,
3220: l_module||'.'||l_stmt_num,
3221: 'Entering CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3222: 'X_min_id = '||X_min_id||','||

Line 3219: fnd_log.level_procedure,

3215: l_stmt_num :=0;
3216:
3217: IF l_plog THEN
3218: fnd_log.string(
3219: fnd_log.level_procedure,
3220: l_module||'.'||l_stmt_num,
3221: 'Entering CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3222: 'X_min_id = '||X_min_id||','||
3223: 'X_max_id = '||X_max_id

Line 3664: fnd_log.string(

3660:
3661: <>
3662:
3663: IF l_plog THEN
3664: fnd_log.string(
3665: fnd_log.level_procedure,
3666: l_module||'.end',
3667: 'Exiting CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3668: 'X_errbuf = '||X_errbuf||','||

Line 3665: fnd_log.level_procedure,

3661: <>
3662:
3663: IF l_plog THEN
3664: fnd_log.string(
3665: fnd_log.level_procedure,
3666: l_module||'.end',
3667: 'Exiting CST_SLA_UPDATE_PKG.Update_Receiving_Subledger with '||
3668: 'X_errbuf = '||X_errbuf||','||
3669: 'X_retcode = '||X_retcode

Line 3684: fnd_log.string(

3680: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3681: p_procedure_name => 'Update_Receiving_Subledger',
3682: p_error_text => 'An exception has occurred in upgrade of receiving MRC table.'
3683: );
3684: fnd_log.string(
3685: fnd_log.level_exception,
3686: l_module||'.'||l_stmt_num,
3687: 'An exception has occurred in upgrade of receiving MRC table..'
3688: );

Line 3685: fnd_log.level_exception,

3681: p_procedure_name => 'Update_Receiving_Subledger',
3682: p_error_text => 'An exception has occurred in upgrade of receiving MRC table.'
3683: );
3684: fnd_log.string(
3685: fnd_log.level_exception,
3686: l_module||'.'||l_stmt_num,
3687: 'An exception has occurred in upgrade of receiving MRC table..'
3688: );
3689: END IF;

Line 3701: fnd_log.string(

3697: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3698: p_procedure_name => 'Update_Receiving_Subledger',
3699: p_error_text => 'An exception has occurred.'
3700: );
3701: fnd_log.string(
3702: fnd_log.level_exception,
3703: l_module||'.'||l_stmt_num,
3704: 'An exception has occurred.'
3705: );

Line 3702: fnd_log.level_exception,

3698: p_procedure_name => 'Update_Receiving_Subledger',
3699: p_error_text => 'An exception has occurred.'
3700: );
3701: fnd_log.string(
3702: fnd_log.level_exception,
3703: l_module||'.'||l_stmt_num,
3704: 'An exception has occurred.'
3705: );
3706: END IF;

Line 3715: fnd_log.message(

3711: IF l_errorLog THEN
3712: fnd_message.set_name('BOM','CST_ERROR');
3713: fnd_message.set_token('SQLERRM',SQLERRM);
3714: fnd_msg_pub.add;
3715: fnd_log.message(
3716: fnd_log.level_error,
3717: l_module||'.'||l_stmt_num,
3718: FALSE
3719: );

Line 3716: fnd_log.level_error,

3712: fnd_message.set_name('BOM','CST_ERROR');
3713: fnd_message.set_token('SQLERRM',SQLERRM);
3714: fnd_msg_pub.add;
3715: fnd_log.message(
3716: fnd_log.level_error,
3717: l_module||'.'||l_stmt_num,
3718: FALSE
3719: );
3720: END IF;

Line 3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

3721: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
3722: WHEN OTHERS THEN
3723: ROLLBACK;
3724: X_retcode := FND_API.g_ret_sts_unexp_error;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;
3729: fnd_log.message(

Line 3729: fnd_log.message(

3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;
3729: fnd_log.message(
3730: fnd_log.level_unexpected,
3731: l_module||'.'||l_stmt_num,
3732: FALSE
3733: );

Line 3730: fnd_log.level_unexpected,

3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;
3729: fnd_log.message(
3730: fnd_log.level_unexpected,
3731: l_module||'.'||l_stmt_num,
3732: FALSE
3733: );
3734: END IF;