APPS.CSTPPWAC dependencies on FND_LOG

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

1: PACKAGE BODY CSTPPWAC AS
2: /* $Header: CSTPWACB.pls 120.42 2011/12/18 00:42:04 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAC';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: -- PROCEDURE
8: -- cost_processor Costs inventory transactions
9: --

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

53: l_stmt_num NUMBER;
54:
55: /* --- start of auto log --- */
56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';
57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

54:
55: /* --- start of auto log --- */
56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';
57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

55: /* --- start of auto log --- */
56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';
57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';
57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
64: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
64: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
65:

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

58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_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 >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
64: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
65:
66: /* --- end of auto log --- */

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

59: fnd_log.TEST(fnd_log.level_unexpected, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
64: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
65:
66: /* --- end of auto log --- */
67: BEGIN

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

60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
61: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
62: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
63: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
64: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
65:
66: /* --- end of auto log --- */
67: BEGIN
68: /* --- start of auto log --- */

Line 70: fnd_log.string(

66: /* --- end of auto log --- */
67: BEGIN
68: /* --- start of auto log --- */
69: IF l_plog THEN
70: fnd_log.string(
71: fnd_log.level_procedure,
72: l_module||'.'||l_stmt_num,
73: 'Entering CSTPPWAC.cost_processor with '||
74: 'I_LEGAL_ENTITY = '||I_LEGAL_ENTITY||','||

Line 71: fnd_log.level_procedure,

67: BEGIN
68: /* --- start of auto log --- */
69: IF l_plog THEN
70: fnd_log.string(
71: fnd_log.level_procedure,
72: l_module||'.'||l_stmt_num,
73: 'Entering CSTPPWAC.cost_processor with '||
74: 'I_LEGAL_ENTITY = '||I_LEGAL_ENTITY||','||
75: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 527: fnd_log.string(

523: /* --- start of auto log --- */
524: <>
525:
526: IF l_plog THEN
527: fnd_log.string(
528: fnd_log.level_procedure,
529: l_module||'.'||l_stmt_num,
530: 'Exiting CSTPPWAC.cost_processor with '||
531: 'O_Err_Num = '||O_Err_Num||','||

Line 528: fnd_log.level_procedure,

524: <>
525:
526: IF l_plog THEN
527: fnd_log.string(
528: fnd_log.level_procedure,
529: l_module||'.'||l_stmt_num,
530: 'Exiting CSTPPWAC.cost_processor with '||
531: 'O_Err_Num = '||O_Err_Num||','||
532: 'O_Err_Code = '||O_Err_Code||','||

Line 546: fnd_log.string(

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

Line 547: fnd_log.level_exception,

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

Line 561: fnd_log.message(

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

Line 562: fnd_log.level_unexpected,

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

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

604: l_stmt_num NUMBER;
605:
606: /* --- start of auto log --- */
607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';
608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

605:
606: /* --- start of auto log --- */
607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';
608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

606: /* --- start of auto log --- */
607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';
608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';
608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
615: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
615: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
616:

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

609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
615: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
616:
617: /* --- end of auto log --- */

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

610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
615: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
616:
617: /* --- end of auto log --- */
618: BEGIN

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

611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
612: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
613: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
614: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
615: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
616:
617: /* --- end of auto log --- */
618: BEGIN
619: /* --- start of auto log --- */

Line 621: fnd_log.string(

617: /* --- end of auto log --- */
618: BEGIN
619: /* --- start of auto log --- */
620: IF l_plog THEN
621: fnd_log.string(
622: fnd_log.level_procedure,
623: l_module||'.'||l_stmt_num,
624: 'Entering CSTPPWAC.cost_owned_txns with '||
625: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 622: fnd_log.level_procedure,

618: BEGIN
619: /* --- start of auto log --- */
620: IF l_plog THEN
621: fnd_log.string(
622: fnd_log.level_procedure,
623: l_module||'.'||l_stmt_num,
624: 'Entering CSTPPWAC.cost_owned_txns with '||
625: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
626: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 712: fnd_log.string(

708: /* --- start of auto log --- */
709: <>
710:
711: IF l_plog THEN
712: fnd_log.string(
713: fnd_log.level_procedure,
714: l_module||'.'||l_stmt_num,
715: 'Exiting CSTPPWAC.cost_owned_txns with '||
716: 'O_Err_Num = '||O_Err_Num||','||

Line 713: fnd_log.level_procedure,

709: <>
710:
711: IF l_plog THEN
712: fnd_log.string(
713: fnd_log.level_procedure,
714: l_module||'.'||l_stmt_num,
715: 'Exiting CSTPPWAC.cost_owned_txns with '||
716: 'O_Err_Num = '||O_Err_Num||','||
717: 'O_Err_Code = '||O_Err_Code||','||

Line 731: fnd_log.string(

727: p_pkg_name => 'CSTPPWAC',
728: p_procedure_name => 'cost_owned_txns',
729: p_error_text => 'An exception has occurred.'
730: );
731: fnd_log.string(
732: fnd_log.level_exception,
733: l_module||'.'||l_stmt_num,
734: 'An exception has occurred.'
735: );

Line 732: fnd_log.level_exception,

728: p_procedure_name => 'cost_owned_txns',
729: p_error_text => 'An exception has occurred.'
730: );
731: fnd_log.string(
732: fnd_log.level_exception,
733: l_module||'.'||l_stmt_num,
734: 'An exception has occurred.'
735: );
736: END IF;

Line 746: fnd_log.message(

742: IF l_uLog THEN
743: fnd_message.set_name('BOM','CST_UNEXPECTED');
744: fnd_message.set_token('SQLERRM',SQLERRM);
745: fnd_msg_pub.add;
746: fnd_log.message(
747: fnd_log.level_unexpected,
748: l_module||'.'||l_stmt_num,
749: FALSE
750: );

Line 747: fnd_log.level_unexpected,

743: fnd_message.set_name('BOM','CST_UNEXPECTED');
744: fnd_message.set_token('SQLERRM',SQLERRM);
745: fnd_msg_pub.add;
746: fnd_log.message(
747: fnd_log.level_unexpected,
748: l_module||'.'||l_stmt_num,
749: FALSE
750: );
751: END IF;

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

790: l_stmt_num NUMBER;
791:
792: /* --- start of auto log --- */
793: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_derived_txns';
794: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
795: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

791:
792: /* --- start of auto log --- */
793: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_derived_txns';
794: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
795: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
799: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

792: /* --- start of auto log --- */
793: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_derived_txns';
794: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
795: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
799: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
800: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

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

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

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

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

795: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
799: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
800: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
801: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
802:
803: /* --- end of auto log --- */

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

796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
799: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
800: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
801: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
802:
803: /* --- end of auto log --- */
804: BEGIN

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

797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
798: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
799: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
800: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
801: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
802:
803: /* --- end of auto log --- */
804: BEGIN
805: /* --- start of auto log --- */

Line 807: fnd_log.string(

803: /* --- end of auto log --- */
804: BEGIN
805: /* --- start of auto log --- */
806: IF l_plog THEN
807: fnd_log.string(
808: fnd_log.level_procedure,
809: l_module||'.'||l_stmt_num,
810: 'Entering CSTPPWAC.cost_derived_txns with '||
811: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 808: fnd_log.level_procedure,

804: BEGIN
805: /* --- start of auto log --- */
806: IF l_plog THEN
807: fnd_log.string(
808: fnd_log.level_procedure,
809: l_module||'.'||l_stmt_num,
810: 'Entering CSTPPWAC.cost_derived_txns with '||
811: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
812: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 897: fnd_log.string(

893: /* --- start of auto log --- */
894: <>
895:
896: IF l_plog THEN
897: fnd_log.string(
898: fnd_log.level_procedure,
899: l_module||'.'||l_stmt_num,
900: 'Exiting CSTPPWAC.cost_derived_txns with '||
901: 'O_Err_Num = '||O_Err_Num||','||

Line 898: fnd_log.level_procedure,

894: <>
895:
896: IF l_plog THEN
897: fnd_log.string(
898: fnd_log.level_procedure,
899: l_module||'.'||l_stmt_num,
900: 'Exiting CSTPPWAC.cost_derived_txns with '||
901: 'O_Err_Num = '||O_Err_Num||','||
902: 'O_Err_Code = '||O_Err_Code||','||

Line 916: fnd_log.string(

912: p_pkg_name => 'CSTPPWAC',
913: p_procedure_name => 'cost_derived_txns',
914: p_error_text => 'An exception has occurred.'
915: );
916: fnd_log.string(
917: fnd_log.level_exception,
918: l_module||'.'||l_stmt_num,
919: 'An exception has occurred.'
920: );

Line 917: fnd_log.level_exception,

913: p_procedure_name => 'cost_derived_txns',
914: p_error_text => 'An exception has occurred.'
915: );
916: fnd_log.string(
917: fnd_log.level_exception,
918: l_module||'.'||l_stmt_num,
919: 'An exception has occurred.'
920: );
921: END IF;

Line 931: fnd_log.message(

927: IF l_uLog THEN
928: fnd_message.set_name('BOM','CST_UNEXPECTED');
929: fnd_message.set_token('SQLERRM',SQLERRM);
930: fnd_msg_pub.add;
931: fnd_log.message(
932: fnd_log.level_unexpected,
933: l_module||'.'||l_stmt_num,
934: FALSE
935: );

Line 932: fnd_log.level_unexpected,

928: fnd_message.set_name('BOM','CST_UNEXPECTED');
929: fnd_message.set_token('SQLERRM',SQLERRM);
930: fnd_msg_pub.add;
931: fnd_log.message(
932: fnd_log.level_unexpected,
933: l_module||'.'||l_stmt_num,
934: FALSE
935: );
936: END IF;

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

982: l_stmt_num NUMBER;
983:
984: /* --- start of auto log --- */
985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';
986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

983:
984: /* --- start of auto log --- */
985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';
986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

984: /* --- start of auto log --- */
985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';
986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';
986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
993: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
993: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
994:

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

987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
993: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
994:
995: /* --- end of auto log --- */

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

988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
993: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
994:
995: /* --- end of auto log --- */
996: BEGIN

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

989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
990: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
991: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
992: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
993: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
994:
995: /* --- end of auto log --- */
996: BEGIN
997: /* --- start of auto log --- */

Line 999: fnd_log.string(

995: /* --- end of auto log --- */
996: BEGIN
997: /* --- start of auto log --- */
998: IF l_plog THEN
999: fnd_log.string(
1000: fnd_log.level_procedure,
1001: l_module||'.'||l_stmt_num,
1002: 'Entering CSTPPWAC.sub_transfer with '||
1003: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 1000: fnd_log.level_procedure,

996: BEGIN
997: /* --- start of auto log --- */
998: IF l_plog THEN
999: fnd_log.string(
1000: fnd_log.level_procedure,
1001: l_module||'.'||l_stmt_num,
1002: 'Entering CSTPPWAC.sub_transfer with '||
1003: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1004: 'I_ORG_ID = '||I_ORG_ID||','||

Line 1134: fnd_log.string(

1130: /* --- start of auto log --- */
1131: <>
1132:
1133: IF l_plog THEN
1134: fnd_log.string(
1135: fnd_log.level_procedure,
1136: l_module||'.'||l_stmt_num,
1137: 'Exiting CSTPPWAC.sub_transfer with '||
1138: 'O_Err_Num = '||O_Err_Num||','||

Line 1135: fnd_log.level_procedure,

1131: <>
1132:
1133: IF l_plog THEN
1134: fnd_log.string(
1135: fnd_log.level_procedure,
1136: l_module||'.'||l_stmt_num,
1137: 'Exiting CSTPPWAC.sub_transfer with '||
1138: 'O_Err_Num = '||O_Err_Num||','||
1139: 'O_Err_Code = '||O_Err_Code||','||

Line 1153: fnd_log.string(

1149: p_pkg_name => 'CSTPPWAC',
1150: p_procedure_name => 'sub_transfer',
1151: p_error_text => 'An exception has occurred.'
1152: );
1153: fnd_log.string(
1154: fnd_log.level_exception,
1155: l_module||'.'||l_stmt_num,
1156: 'An exception has occurred.'
1157: );

Line 1154: fnd_log.level_exception,

1150: p_procedure_name => 'sub_transfer',
1151: p_error_text => 'An exception has occurred.'
1152: );
1153: fnd_log.string(
1154: fnd_log.level_exception,
1155: l_module||'.'||l_stmt_num,
1156: 'An exception has occurred.'
1157: );
1158: END IF;

Line 1168: fnd_log.message(

1164: IF l_uLog THEN
1165: fnd_message.set_name('BOM','CST_UNEXPECTED');
1166: fnd_message.set_token('SQLERRM',SQLERRM);
1167: fnd_msg_pub.add;
1168: fnd_log.message(
1169: fnd_log.level_unexpected,
1170: l_module||'.'||l_stmt_num,
1171: FALSE
1172: );

Line 1169: fnd_log.level_unexpected,

1165: fnd_message.set_name('BOM','CST_UNEXPECTED');
1166: fnd_message.set_token('SQLERRM',SQLERRM);
1167: fnd_msg_pub.add;
1168: fnd_log.message(
1169: fnd_log.level_unexpected,
1170: l_module||'.'||l_stmt_num,
1171: FALSE
1172: );
1173: END IF;

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

1220: l_stmt_num NUMBER;
1221:
1222: /* --- start of auto log --- */
1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';
1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

1221:
1222: /* --- start of auto log --- */
1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';
1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

1222: /* --- start of auto log --- */
1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';
1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';
1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1231: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1231: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1232:

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

1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1231: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1232:
1233: /* --- end of auto log --- */

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

1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1231: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1232:
1233: /* --- end of auto log --- */
1234: BEGIN

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

1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1228: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1229: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1230: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1231: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1232:
1233: /* --- end of auto log --- */
1234: BEGIN
1235: /* --- start of auto log --- */

Line 1237: fnd_log.string(

1233: /* --- end of auto log --- */
1234: BEGIN
1235: /* --- start of auto log --- */
1236: IF l_plog THEN
1237: fnd_log.string(
1238: fnd_log.level_procedure,
1239: l_module||'.'||l_stmt_num,
1240: 'Entering CSTPPWAC.interorg with '||
1241: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 1238: fnd_log.level_procedure,

1234: BEGIN
1235: /* --- start of auto log --- */
1236: IF l_plog THEN
1237: fnd_log.string(
1238: fnd_log.level_procedure,
1239: l_module||'.'||l_stmt_num,
1240: 'Entering CSTPPWAC.interorg with '||
1241: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1242: 'I_ORG_ID = '||I_ORG_ID||','||

Line 1402: fnd_log.string(

1398: /* --- start of auto log --- */
1399: <>
1400:
1401: IF l_plog THEN
1402: fnd_log.string(
1403: fnd_log.level_procedure,
1404: l_module||'.'||l_stmt_num,
1405: 'Exiting CSTPPWAC.interorg with '||
1406: 'O_Err_Num = '||O_Err_Num||','||

Line 1403: fnd_log.level_procedure,

1399: <>
1400:
1401: IF l_plog THEN
1402: fnd_log.string(
1403: fnd_log.level_procedure,
1404: l_module||'.'||l_stmt_num,
1405: 'Exiting CSTPPWAC.interorg with '||
1406: 'O_Err_Num = '||O_Err_Num||','||
1407: 'O_Err_Code = '||O_Err_Code||','||

Line 1421: fnd_log.string(

1417: p_pkg_name => 'CSTPPWAC',
1418: p_procedure_name => 'interorg',
1419: p_error_text => 'An exception has occurred.'
1420: );
1421: fnd_log.string(
1422: fnd_log.level_exception,
1423: l_module||'.'||l_stmt_num,
1424: 'An exception has occurred.'
1425: );

Line 1422: fnd_log.level_exception,

1418: p_procedure_name => 'interorg',
1419: p_error_text => 'An exception has occurred.'
1420: );
1421: fnd_log.string(
1422: fnd_log.level_exception,
1423: l_module||'.'||l_stmt_num,
1424: 'An exception has occurred.'
1425: );
1426: END IF;

Line 1436: fnd_log.message(

1432: IF l_uLog THEN
1433: fnd_message.set_name('BOM','CST_UNEXPECTED');
1434: fnd_message.set_token('SQLERRM',SQLERRM);
1435: fnd_msg_pub.add;
1436: fnd_log.message(
1437: fnd_log.level_unexpected,
1438: l_module||'.'||l_stmt_num,
1439: FALSE
1440: );

Line 1437: fnd_log.level_unexpected,

1433: fnd_message.set_name('BOM','CST_UNEXPECTED');
1434: fnd_message.set_token('SQLERRM',SQLERRM);
1435: fnd_msg_pub.add;
1436: fnd_log.message(
1437: fnd_log.level_unexpected,
1438: l_module||'.'||l_stmt_num,
1439: FALSE
1440: );
1441: END IF;

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

1496: l_api_message VARCHAR2(1000) := '';
1497:
1498: /* --- start of auto log --- */
1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';
1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

1497:
1498: /* --- start of auto log --- */
1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';
1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

1498: /* --- start of auto log --- */
1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';
1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';
1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1507: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1507: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1508:

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

1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1507: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1508:
1509: /* --- end of auto log --- */

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

1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1507: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1508:
1509: /* --- end of auto log --- */
1510: BEGIN

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

1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1504: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1505: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1506: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1507: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1508:
1509: /* --- end of auto log --- */
1510: BEGIN
1511: /* --- start of auto log --- */

Line 1513: fnd_log.string(

1509: /* --- end of auto log --- */
1510: BEGIN
1511: /* --- start of auto log --- */
1512: IF l_plog THEN
1513: fnd_log.string(
1514: fnd_log.level_procedure,
1515: l_module||'.'||l_stmt_num,
1516: 'Entering CSTPPWAC.compute_pwac_cost with '||
1517: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 1514: fnd_log.level_procedure,

1510: BEGIN
1511: /* --- start of auto log --- */
1512: IF l_plog THEN
1513: fnd_log.string(
1514: fnd_log.level_procedure,
1515: l_module||'.'||l_stmt_num,
1516: 'Entering CSTPPWAC.compute_pwac_cost with '||
1517: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1518: 'I_ORG_ID = '||I_ORG_ID||','||

Line 1865: fnd_log.string(

1861: /* --- start of auto log --- */
1862: <>
1863:
1864: IF l_plog THEN
1865: fnd_log.string(
1866: fnd_log.level_procedure,
1867: l_module||'.'||l_stmt_num,
1868: 'Exiting CSTPPWAC.compute_pwac_cost with '||
1869: 'O_Err_Num = '||O_Err_Num||','||

Line 1866: fnd_log.level_procedure,

1862: <>
1863:
1864: IF l_plog THEN
1865: fnd_log.string(
1866: fnd_log.level_procedure,
1867: l_module||'.'||l_stmt_num,
1868: 'Exiting CSTPPWAC.compute_pwac_cost with '||
1869: 'O_Err_Num = '||O_Err_Num||','||
1870: 'O_Err_Code = '||O_Err_Code||','||

Line 1887: fnd_log.string(

1883: p_pkg_name => 'CSTPPWAC',
1884: p_procedure_name => 'compute_pwac_cost',
1885: p_error_text => 'An exception has occurred.'
1886: );
1887: fnd_log.string(
1888: fnd_log.level_exception,
1889: l_module||'.'||l_stmt_num,
1890: 'An exception has occurred.'
1891: );

Line 1888: fnd_log.level_exception,

1884: p_procedure_name => 'compute_pwac_cost',
1885: p_error_text => 'An exception has occurred.'
1886: );
1887: fnd_log.string(
1888: fnd_log.level_exception,
1889: l_module||'.'||l_stmt_num,
1890: 'An exception has occurred.'
1891: );
1892: END IF;

Line 1903: fnd_log.message(

1899: IF l_uLog THEN
1900: fnd_message.set_name('BOM','CST_UNEXPECTED');
1901: fnd_message.set_token('SQLERRM',SQLERRM);
1902: fnd_msg_pub.add;
1903: fnd_log.message(
1904: fnd_log.level_unexpected,
1905: l_module||'.'||l_stmt_num,
1906: FALSE
1907: );

Line 1904: fnd_log.level_unexpected,

1900: fnd_message.set_name('BOM','CST_UNEXPECTED');
1901: fnd_message.set_token('SQLERRM',SQLERRM);
1902: fnd_msg_pub.add;
1903: fnd_log.message(
1904: fnd_log.level_unexpected,
1905: l_module||'.'||l_stmt_num,
1906: FALSE
1907: );
1908: END IF;

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

1948: l_stmt_num NUMBER;
1949:
1950: /* --- start of auto log --- */
1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';
1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

1949:
1950: /* --- start of auto log --- */
1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';
1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

1950: /* --- start of auto log --- */
1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';
1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';
1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1959: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1959: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1960:

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

1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1959: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1960:
1961: /* --- end of auto log --- */

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

1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1959: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1960:
1961: /* --- end of auto log --- */
1962: BEGIN

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

1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
1956: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
1957: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
1958: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
1959: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1960:
1961: /* --- end of auto log --- */
1962: BEGIN
1963: /* --- start of auto log --- */

Line 1965: fnd_log.string(

1961: /* --- end of auto log --- */
1962: BEGIN
1963: /* --- start of auto log --- */
1964: IF l_plog THEN
1965: fnd_log.string(
1966: fnd_log.level_procedure,
1967: l_module||'.'||l_stmt_num,
1968: 'Entering CSTPPWAC.apply_material_ovhd with '||
1969: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 1966: fnd_log.level_procedure,

1962: BEGIN
1963: /* --- start of auto log --- */
1964: IF l_plog THEN
1965: fnd_log.string(
1966: fnd_log.level_procedure,
1967: l_module||'.'||l_stmt_num,
1968: 'Entering CSTPPWAC.apply_material_ovhd with '||
1969: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1970: 'I_ORG_ID = '||I_ORG_ID||','||

Line 2182: fnd_log.string(

2178: /* --- start of auto log --- */
2179: <>
2180:
2181: IF l_plog THEN
2182: fnd_log.string(
2183: fnd_log.level_procedure,
2184: l_module||'.'||l_stmt_num,
2185: 'Exiting CSTPPWAC.apply_material_ovhd with '||
2186: 'O_Err_Num = '||O_Err_Num||','||

Line 2183: fnd_log.level_procedure,

2179: <>
2180:
2181: IF l_plog THEN
2182: fnd_log.string(
2183: fnd_log.level_procedure,
2184: l_module||'.'||l_stmt_num,
2185: 'Exiting CSTPPWAC.apply_material_ovhd with '||
2186: 'O_Err_Num = '||O_Err_Num||','||
2187: 'O_Err_Code = '||O_Err_Code||','||

Line 2199: fnd_log.message(

2195: IF l_uLog THEN
2196: fnd_message.set_name('BOM','CST_UNEXPECTED');
2197: fnd_message.set_token('SQLERRM',SQLERRM);
2198: fnd_msg_pub.add;
2199: fnd_log.message(
2200: fnd_log.level_unexpected,
2201: l_module||'.'||l_stmt_num,
2202: FALSE
2203: );

Line 2200: fnd_log.level_unexpected,

2196: fnd_message.set_name('BOM','CST_UNEXPECTED');
2197: fnd_message.set_token('SQLERRM',SQLERRM);
2198: fnd_msg_pub.add;
2199: fnd_log.message(
2200: fnd_log.level_unexpected,
2201: l_module||'.'||l_stmt_num,
2202: FALSE
2203: );
2204: END IF;

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

2238: l_stmt_num NUMBER;
2239:
2240: /* --- start of auto log --- */
2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';
2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

2239:
2240: /* --- start of auto log --- */
2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';
2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

2240: /* --- start of auto log --- */
2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';
2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';
2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2249: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2249: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2250:

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

2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2249: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2250:
2251: /* --- end of auto log --- */

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

2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2249: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2250:
2251: /* --- end of auto log --- */
2252: BEGIN

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

2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2246: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2247: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2248: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2249: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2250:
2251: /* --- end of auto log --- */
2252: BEGIN
2253: /* --- start of auto log --- */

Line 2255: fnd_log.string(

2251: /* --- end of auto log --- */
2252: BEGIN
2253: /* --- start of auto log --- */
2254: IF l_plog THEN
2255: fnd_log.string(
2256: fnd_log.level_procedure,
2257: l_module||'.'||l_stmt_num,
2258: 'Entering CSTPPWAC.current_pwac_cost with '||
2259: 'I_COST_LAYER_ID = '||I_COST_LAYER_ID||','||

Line 2256: fnd_log.level_procedure,

2252: BEGIN
2253: /* --- start of auto log --- */
2254: IF l_plog THEN
2255: fnd_log.string(
2256: fnd_log.level_procedure,
2257: l_module||'.'||l_stmt_num,
2258: 'Entering CSTPPWAC.current_pwac_cost with '||
2259: 'I_COST_LAYER_ID = '||I_COST_LAYER_ID||','||
2260: 'I_QTY_LAYER_ID = '||I_QTY_LAYER_ID||','||

Line 2375: fnd_log.string(

2371: /* --- start of auto log --- */
2372: <>
2373:
2374: IF l_plog THEN
2375: fnd_log.string(
2376: fnd_log.level_procedure,
2377: l_module||'.'||l_stmt_num,
2378: 'Exiting CSTPPWAC.current_pwac_cost with '||
2379: 'O_Err_Num = '||O_Err_Num||','||

Line 2376: fnd_log.level_procedure,

2372: <>
2373:
2374: IF l_plog THEN
2375: fnd_log.string(
2376: fnd_log.level_procedure,
2377: l_module||'.'||l_stmt_num,
2378: 'Exiting CSTPPWAC.current_pwac_cost with '||
2379: 'O_Err_Num = '||O_Err_Num||','||
2380: 'O_Err_Code = '||O_Err_Code||','||

Line 2394: fnd_log.string(

2390: p_pkg_name => 'CSTPPWAC',
2391: p_procedure_name => 'current_pwac_cost',
2392: p_error_text => 'An exception has occurred.'
2393: );
2394: fnd_log.string(
2395: fnd_log.level_exception,
2396: l_module||'.'||l_stmt_num,
2397: 'An exception has occurred.'
2398: );

Line 2395: fnd_log.level_exception,

2391: p_procedure_name => 'current_pwac_cost',
2392: p_error_text => 'An exception has occurred.'
2393: );
2394: fnd_log.string(
2395: fnd_log.level_exception,
2396: l_module||'.'||l_stmt_num,
2397: 'An exception has occurred.'
2398: );
2399: END IF;

Line 2409: fnd_log.message(

2405: IF l_uLog THEN
2406: fnd_message.set_name('BOM','CST_UNEXPECTED');
2407: fnd_message.set_token('SQLERRM',SQLERRM);
2408: fnd_msg_pub.add;
2409: fnd_log.message(
2410: fnd_log.level_unexpected,
2411: l_module||'.'||l_stmt_num,
2412: FALSE
2413: );

Line 2410: fnd_log.level_unexpected,

2406: fnd_message.set_name('BOM','CST_UNEXPECTED');
2407: fnd_message.set_token('SQLERRM',SQLERRM);
2408: fnd_msg_pub.add;
2409: fnd_log.message(
2410: fnd_log.level_unexpected,
2411: l_module||'.'||l_stmt_num,
2412: FALSE
2413: );
2414: END IF;

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

2455: l_stmt_num NUMBER;
2456:
2457: /* --- start of auto log --- */
2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';
2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

2456:
2457: /* --- start of auto log --- */
2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';
2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

2457: /* --- start of auto log --- */
2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';
2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';
2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2466: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2466: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2467:

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

2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2466: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2467:
2468: /* --- end of auto log --- */

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

2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2466: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2467:
2468: /* --- end of auto log --- */
2469: BEGIN

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

2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2463: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2464: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2465: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2466: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2467:
2468: /* --- end of auto log --- */
2469: BEGIN
2470: /* --- start of auto log --- */

Line 2472: fnd_log.string(

2468: /* --- end of auto log --- */
2469: BEGIN
2470: /* --- start of auto log --- */
2471: IF l_plog THEN
2472: fnd_log.string(
2473: fnd_log.level_procedure,
2474: l_module||'.'||l_stmt_num,
2475: 'Entering CSTPPWAC.calc_pwac_cost with '||
2476: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 2473: fnd_log.level_procedure,

2469: BEGIN
2470: /* --- start of auto log --- */
2471: IF l_plog THEN
2472: fnd_log.string(
2473: fnd_log.level_procedure,
2474: l_module||'.'||l_stmt_num,
2475: 'Entering CSTPPWAC.calc_pwac_cost with '||
2476: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
2477: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 2661: fnd_log.string(

2657: /* --- start of auto log --- */
2658: <>
2659:
2660: IF l_plog THEN
2661: fnd_log.string(
2662: fnd_log.level_procedure,
2663: l_module||'.'||l_stmt_num,
2664: 'Exiting CSTPPWAC.calc_pwac_cost with '||
2665: 'O_Err_Num = '||O_Err_Num||','||

Line 2662: fnd_log.level_procedure,

2658: <>
2659:
2660: IF l_plog THEN
2661: fnd_log.string(
2662: fnd_log.level_procedure,
2663: l_module||'.'||l_stmt_num,
2664: 'Exiting CSTPPWAC.calc_pwac_cost with '||
2665: 'O_Err_Num = '||O_Err_Num||','||
2666: 'O_Err_Code = '||O_Err_Code||','||

Line 2680: fnd_log.string(

2676: p_pkg_name => 'CSTPPWAC',
2677: p_procedure_name => 'calc_pwac_cost',
2678: p_error_text => 'An exception has occurred.'
2679: );
2680: fnd_log.string(
2681: fnd_log.level_exception,
2682: l_module||'.'||l_stmt_num,
2683: 'An exception has occurred.'
2684: );

Line 2681: fnd_log.level_exception,

2677: p_procedure_name => 'calc_pwac_cost',
2678: p_error_text => 'An exception has occurred.'
2679: );
2680: fnd_log.string(
2681: fnd_log.level_exception,
2682: l_module||'.'||l_stmt_num,
2683: 'An exception has occurred.'
2684: );
2685: END IF;

Line 2695: fnd_log.message(

2691: IF l_uLog THEN
2692: fnd_message.set_name('BOM','CST_UNEXPECTED');
2693: fnd_message.set_token('SQLERRM',SQLERRM);
2694: fnd_msg_pub.add;
2695: fnd_log.message(
2696: fnd_log.level_unexpected,
2697: l_module||'.'||l_stmt_num,
2698: FALSE
2699: );

Line 2696: fnd_log.level_unexpected,

2692: fnd_message.set_name('BOM','CST_UNEXPECTED');
2693: fnd_message.set_token('SQLERRM',SQLERRM);
2694: fnd_msg_pub.add;
2695: fnd_log.message(
2696: fnd_log.level_unexpected,
2697: l_module||'.'||l_stmt_num,
2698: FALSE
2699: );
2700: END IF;

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

2732: l_buy_qty NUMBER;
2733:
2734: /* --- start of auto log --- */
2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';
2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

2733:
2734: /* --- start of auto log --- */
2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';
2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

2734: /* --- start of auto log --- */
2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';
2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';
2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2743: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2743: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2744:

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

2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2743: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2744:
2745: /* --- end of auto log --- */

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

2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2743: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2744:
2745: /* --- end of auto log --- */
2746: BEGIN

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

2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
2740: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
2741: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
2742: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
2743: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
2744:
2745: /* --- end of auto log --- */
2746: BEGIN
2747: /* --- start of auto log --- */

Line 2749: fnd_log.string(

2745: /* --- end of auto log --- */
2746: BEGIN
2747: /* --- start of auto log --- */
2748: IF l_plog THEN
2749: fnd_log.string(
2750: fnd_log.level_procedure,
2751: l_module||'.'||l_stmt_num,
2752: 'Entering CSTPPWAC.periodic_cost_update with '||
2753: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 2750: fnd_log.level_procedure,

2746: BEGIN
2747: /* --- start of auto log --- */
2748: IF l_plog THEN
2749: fnd_log.string(
2750: fnd_log.level_procedure,
2751: l_module||'.'||l_stmt_num,
2752: 'Entering CSTPPWAC.periodic_cost_update with '||
2753: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
2754: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 3273: fnd_log.string(

3269: /* --- start of auto log --- */
3270: <>
3271:
3272: IF l_plog THEN
3273: fnd_log.string(
3274: fnd_log.level_procedure,
3275: l_module||'.'||l_stmt_num,
3276: 'Exiting CSTPPWAC.periodic_cost_update with '||
3277: 'O_Err_Num = '||O_Err_Num||','||

Line 3274: fnd_log.level_procedure,

3270: <>
3271:
3272: IF l_plog THEN
3273: fnd_log.string(
3274: fnd_log.level_procedure,
3275: l_module||'.'||l_stmt_num,
3276: 'Exiting CSTPPWAC.periodic_cost_update with '||
3277: 'O_Err_Num = '||O_Err_Num||','||
3278: 'O_Err_Code = '||O_Err_Code||','||

Line 3290: fnd_log.message(

3286: IF l_uLog THEN
3287: fnd_message.set_name('BOM','CST_UNEXPECTED');
3288: fnd_message.set_token('SQLERRM',SQLERRM);
3289: fnd_msg_pub.add;
3290: fnd_log.message(
3291: fnd_log.level_unexpected,
3292: l_module||'.'||l_stmt_num,
3293: FALSE
3294: );

Line 3291: fnd_log.level_unexpected,

3287: fnd_message.set_name('BOM','CST_UNEXPECTED');
3288: fnd_message.set_token('SQLERRM',SQLERRM);
3289: fnd_msg_pub.add;
3290: fnd_log.message(
3291: fnd_log.level_unexpected,
3292: l_module||'.'||l_stmt_num,
3293: FALSE
3294: );
3295: END IF;

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

3324: l_stmt_num NUMBER;
3325:
3326: -- start of auto log ---
3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

3325:
3326: -- start of auto log ---
3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

3326: -- start of auto log ---
3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3335: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3335: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3336:

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

3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3335: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3336:
3337: -- end of auto log ---

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

3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3335: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3336:
3337: -- end of auto log ---
3338: BEGIN

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

3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3332: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3333: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3334: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3335: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3336:
3337: -- end of auto log ---
3338: BEGIN
3339: --- start of auto log ---

Line 3341: fnd_log.string(

3337: -- end of auto log ---
3338: BEGIN
3339: --- start of auto log ---
3340: IF l_plog THEN
3341: fnd_log.string(
3342: fnd_log.level_procedure,
3343: l_module||'.'||l_stmt_num,
3344: 'Entering CSTPPWAC.insert_txn_history with '||
3345: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 3342: fnd_log.level_procedure,

3338: BEGIN
3339: --- start of auto log ---
3340: IF l_plog THEN
3341: fnd_log.string(
3342: fnd_log.level_procedure,
3343: l_module||'.'||l_stmt_num,
3344: 'Entering CSTPPWAC.insert_txn_history with '||
3345: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3346: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 3409: fnd_log.string(

3405: --- start of auto log ---
3406: <>
3407:
3408: IF l_plog THEN
3409: fnd_log.string(
3410: fnd_log.level_procedure,
3411: l_module||'.'||l_stmt_num,
3412: 'Exiting CSTPPWAC.insert_txn_history with '||
3413: 'O_Err_Num = '||O_Err_Num||','||

Line 3410: fnd_log.level_procedure,

3406: <>
3407:
3408: IF l_plog THEN
3409: fnd_log.string(
3410: fnd_log.level_procedure,
3411: l_module||'.'||l_stmt_num,
3412: 'Exiting CSTPPWAC.insert_txn_history with '||
3413: 'O_Err_Num = '||O_Err_Num||','||
3414: 'O_Err_Code = '||O_Err_Code||','||

Line 3426: fnd_log.message(

3422: IF l_uLog THEN
3423: fnd_message.set_name('BOM','CST_UNEXPECTED');
3424: fnd_message.set_token('SQLERRM',SQLERRM);
3425: fnd_msg_pub.add;
3426: fnd_log.message(
3427: fnd_log.level_unexpected,
3428: l_module||'.'||l_stmt_num,
3429: FALSE
3430: );

Line 3427: fnd_log.level_unexpected,

3423: fnd_message.set_name('BOM','CST_UNEXPECTED');
3424: fnd_message.set_token('SQLERRM',SQLERRM);
3425: fnd_msg_pub.add;
3426: fnd_log.message(
3427: fnd_log.level_unexpected,
3428: l_module||'.'||l_stmt_num,
3429: FALSE
3430: );
3431: END IF;

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

3458: l_stmt_num NUMBER;
3459:
3460: --- start of auto log ---
3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

3459:
3460: --- start of auto log ---
3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

3460: --- start of auto log ---
3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3469: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3469: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3470:

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

3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3469: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3470:
3471: --- end of auto log ---

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

3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3469: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3470:
3471: --- end of auto log ---
3472: BEGIN

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

3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3466: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3467: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3468: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3469: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3470:
3471: --- end of auto log ---
3472: BEGIN
3473: --- start of auto log ---

Line 3475: fnd_log.string(

3471: --- end of auto log ---
3472: BEGIN
3473: --- start of auto log ---
3474: IF l_plog THEN
3475: fnd_log.string(
3476: fnd_log.level_procedure,
3477: l_module||'.'||l_stmt_num,
3478: 'Entering CSTPPWAC.update_txn_history with '||
3479: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 3476: fnd_log.level_procedure,

3472: BEGIN
3473: --- start of auto log ---
3474: IF l_plog THEN
3475: fnd_log.string(
3476: fnd_log.level_procedure,
3477: l_module||'.'||l_stmt_num,
3478: 'Entering CSTPPWAC.update_txn_history with '||
3479: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3480: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 3513: fnd_log.string(

3509: --- start of auto log ---
3510: <>
3511:
3512: IF l_plog THEN
3513: fnd_log.string(
3514: fnd_log.level_procedure,
3515: l_module||'.'||l_stmt_num,
3516: 'Exiting CSTPPWAC.update_txn_history with '||
3517: 'O_Err_Num = '||O_Err_Num||','||

Line 3514: fnd_log.level_procedure,

3510: <>
3511:
3512: IF l_plog THEN
3513: fnd_log.string(
3514: fnd_log.level_procedure,
3515: l_module||'.'||l_stmt_num,
3516: 'Exiting CSTPPWAC.update_txn_history with '||
3517: 'O_Err_Num = '||O_Err_Num||','||
3518: 'O_Err_Code = '||O_Err_Code||','||

Line 3530: fnd_log.message(

3526: IF l_uLog THEN
3527: fnd_message.set_name('BOM','CST_UNEXPECTED');
3528: fnd_message.set_token('SQLERRM',SQLERRM);
3529: fnd_msg_pub.add;
3530: fnd_log.message(
3531: fnd_log.level_unexpected,
3532: l_module||'.'||l_stmt_num,
3533: FALSE
3534: );

Line 3531: fnd_log.level_unexpected,

3527: fnd_message.set_name('BOM','CST_UNEXPECTED');
3528: fnd_message.set_token('SQLERRM',SQLERRM);
3529: fnd_msg_pub.add;
3530: fnd_log.message(
3531: fnd_log.level_unexpected,
3532: l_module||'.'||l_stmt_num,
3533: FALSE
3534: );
3535: END IF;

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

3562: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3563:
3564: /* --- start of auto log --- */
3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

3563:
3564: /* --- start of auto log --- */
3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

3564: /* --- start of auto log --- */
3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3574:

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

3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3574:
3575: /* --- end of auto log --- */

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

3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3574:
3575: /* --- end of auto log --- */
3576: BEGIN

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

3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3570: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3571: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3572: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3574:
3575: /* --- end of auto log --- */
3576: BEGIN
3577: /* --- start of auto log --- */

Line 3579: fnd_log.string(

3575: /* --- end of auto log --- */
3576: BEGIN
3577: /* --- start of auto log --- */
3578: IF l_plog THEN
3579: fnd_log.string(
3580: fnd_log.level_procedure,
3581: l_module||'.'||l_stmt_num,
3582: 'Entering CSTPPWAC.insert_into_cppb with '||
3583: 'i_cost_group_id = '||i_cost_group_id||','||

Line 3580: fnd_log.level_procedure,

3576: BEGIN
3577: /* --- start of auto log --- */
3578: IF l_plog THEN
3579: fnd_log.string(
3580: fnd_log.level_procedure,
3581: l_module||'.'||l_stmt_num,
3582: 'Entering CSTPPWAC.insert_into_cppb with '||
3583: 'i_cost_group_id = '||i_cost_group_id||','||
3584: 'i_txn_category = '||i_txn_category||','||

Line 3862: fnd_log.string(

3858: /* --- start of auto log --- */
3859: <>
3860:
3861: IF l_plog THEN
3862: fnd_log.string(
3863: fnd_log.level_procedure,
3864: l_module||'.'||l_stmt_num,
3865: 'Exiting CSTPPWAC.insert_into_cppb with '||
3866: 'o_err_num = '||o_err_num||','||

Line 3863: fnd_log.level_procedure,

3859: <>
3860:
3861: IF l_plog THEN
3862: fnd_log.string(
3863: fnd_log.level_procedure,
3864: l_module||'.'||l_stmt_num,
3865: 'Exiting CSTPPWAC.insert_into_cppb with '||
3866: 'o_err_num = '||o_err_num||','||
3867: 'o_err_code = '||o_err_code||','||

Line 3879: fnd_log.message(

3875: IF l_uLog THEN
3876: fnd_message.set_name('BOM','CST_UNEXPECTED');
3877: fnd_message.set_token('SQLERRM',SQLERRM);
3878: fnd_msg_pub.add;
3879: fnd_log.message(
3880: fnd_log.level_unexpected,
3881: l_module||'.'||l_stmt_num,
3882: FALSE
3883: );

Line 3880: fnd_log.level_unexpected,

3876: fnd_message.set_name('BOM','CST_UNEXPECTED');
3877: fnd_message.set_token('SQLERRM',SQLERRM);
3878: fnd_msg_pub.add;
3879: fnd_log.message(
3880: fnd_log.level_unexpected,
3881: l_module||'.'||l_stmt_num,
3882: FALSE
3883: );
3884: END IF;

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

3917: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
3918:
3919: /* --- start of auto log --- */
3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

3918:
3919: /* --- start of auto log --- */
3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

3919: /* --- start of auto log --- */
3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3928: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3928: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3929:

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

3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3928: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3929:
3930: /* --- end of auto log --- */

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

3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3928: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3929:
3930: /* --- end of auto log --- */
3931: BEGIN

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

3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3925: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3926: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3927: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3928: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3929:
3930: /* --- end of auto log --- */
3931: BEGIN
3932: /* --- start of auto log --- */

Line 3934: fnd_log.string(

3930: /* --- end of auto log --- */
3931: BEGIN
3932: /* --- start of auto log --- */
3933: IF l_plog THEN
3934: fnd_log.string(
3935: fnd_log.level_procedure,
3936: l_module||'.'||l_stmt_num,
3937: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3938: 'i_cost_group_id = '||i_cost_group_id||','||

Line 3935: fnd_log.level_procedure,

3931: BEGIN
3932: /* --- start of auto log --- */
3933: IF l_plog THEN
3934: fnd_log.string(
3935: fnd_log.level_procedure,
3936: l_module||'.'||l_stmt_num,
3937: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3938: 'i_cost_group_id = '||i_cost_group_id||','||
3939: 'i_cost_type_id = '||i_cost_type_id||','||

Line 3998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);

3994: AND cpllc.inventory_item_id = mpacd.inventory_item_id
3995: AND cpllc.low_level_code = i_low_level_code);
3996:
3997: IF l_sLog THEN
3998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);
3999: END IF;
4000:
4001: IF (l_max_txn_category = 7) THEN
4002: -- Rework completions. Pick only items having records with transaction

Line 4474: fnd_log.string(

4470: /* --- start of auto log --- */
4471: <>
4472:
4473: IF l_plog THEN
4474: fnd_log.string(
4475: fnd_log.level_procedure,
4476: l_module||'.'||l_stmt_num,
4477: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4478: 'o_err_num = '||o_err_num||','||

Line 4475: fnd_log.level_procedure,

4471: <>
4472:
4473: IF l_plog THEN
4474: fnd_log.string(
4475: fnd_log.level_procedure,
4476: l_module||'.'||l_stmt_num,
4477: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4478: 'o_err_num = '||o_err_num||','||
4479: 'o_err_code = '||o_err_code||','||

Line 4491: fnd_log.message(

4487: IF l_uLog THEN
4488: fnd_message.set_name('BOM','CST_UNEXPECTED');
4489: fnd_message.set_token('SQLERRM',SQLERRM);
4490: fnd_msg_pub.add;
4491: fnd_log.message(
4492: fnd_log.level_unexpected,
4493: l_module||'.'||l_stmt_num,
4494: FALSE
4495: );

Line 4492: fnd_log.level_unexpected,

4488: fnd_message.set_name('BOM','CST_UNEXPECTED');
4489: fnd_message.set_token('SQLERRM',SQLERRM);
4490: fnd_msg_pub.add;
4491: fnd_log.message(
4492: fnd_log.level_unexpected,
4493: l_module||'.'||l_stmt_num,
4494: FALSE
4495: );
4496: END IF;

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

4526: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
4527:
4528: /* --- start of auto log --- */
4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

4527:
4528: /* --- start of auto log --- */
4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

4528: /* --- start of auto log --- */
4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4537: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4537: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4538:

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

4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4537: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4538:
4539: /* --- end of auto log --- */

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

4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4537: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4538:
4539: /* --- end of auto log --- */
4540: BEGIN

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

4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4534: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4535: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4536: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4537: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4538:
4539: /* --- end of auto log --- */
4540: BEGIN
4541: /* --- start of auto log --- */

Line 4543: fnd_log.string(

4539: /* --- end of auto log --- */
4540: BEGIN
4541: /* --- start of auto log --- */
4542: IF l_plog THEN
4543: fnd_log.string(
4544: fnd_log.level_procedure,
4545: l_module||'.'||l_stmt_num,
4546: 'Entering CSTPPWAC.calc_periodic_cost with '||
4547: 'i_cost_group_id = '||i_cost_group_id||','||

Line 4544: fnd_log.level_procedure,

4540: BEGIN
4541: /* --- start of auto log --- */
4542: IF l_plog THEN
4543: fnd_log.string(
4544: fnd_log.level_procedure,
4545: l_module||'.'||l_stmt_num,
4546: 'Entering CSTPPWAC.calc_periodic_cost with '||
4547: 'i_cost_group_id = '||i_cost_group_id||','||
4548: 'i_cost_type_id = '||i_cost_type_id||','||

Line 4604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);

4600: AND cpllc.inventory_item_id = mpacd.inventory_item_id
4601: AND cpllc.low_level_code = i_low_level_code);
4602:
4603: IF l_sLog THEN
4604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);
4605: END IF;
4606:
4607: IF (l_max_txn_category = 7) THEN
4608: -- Rework completions. Pick only items having records with transaction

Line 5076: fnd_log.string(

5072: /* --- start of auto log --- */
5073: <>
5074:
5075: IF l_plog THEN
5076: fnd_log.string(
5077: fnd_log.level_procedure,
5078: l_module||'.'||l_stmt_num,
5079: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5080: 'o_err_num = '||o_err_num||','||

Line 5077: fnd_log.level_procedure,

5073: <>
5074:
5075: IF l_plog THEN
5076: fnd_log.string(
5077: fnd_log.level_procedure,
5078: l_module||'.'||l_stmt_num,
5079: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5080: 'o_err_num = '||o_err_num||','||
5081: 'o_err_code = '||o_err_code||','||

Line 5093: fnd_log.message(

5089: IF l_uLog THEN
5090: fnd_message.set_name('BOM','CST_UNEXPECTED');
5091: fnd_message.set_token('SQLERRM',SQLERRM);
5092: fnd_msg_pub.add;
5093: fnd_log.message(
5094: fnd_log.level_unexpected,
5095: l_module||'.'||l_stmt_num,
5096: FALSE
5097: );

Line 5094: fnd_log.level_unexpected,

5090: fnd_message.set_name('BOM','CST_UNEXPECTED');
5091: fnd_message.set_token('SQLERRM',SQLERRM);
5092: fnd_msg_pub.add;
5093: fnd_log.message(
5094: fnd_log.level_unexpected,
5095: l_module||'.'||l_stmt_num,
5096: FALSE
5097: );
5098: END IF;

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

5120: IS
5121: l_stmt_num NUMBER;
5122: /* --- start of auto log --- */
5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5121: l_stmt_num NUMBER;
5122: /* --- start of auto log --- */
5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5122: /* --- start of auto log --- */
5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5131: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5131: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5132:

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

5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5131: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5132:
5133: /* --- end of auto log --- */

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

5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5131: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5132:
5133: /* --- end of auto log --- */
5134: BEGIN

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

5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5128: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5129: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5130: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5131: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5132:
5133: /* --- end of auto log --- */
5134: BEGIN
5135: l_stmt_num := 10;

Line 5138: fnd_log.string(

5134: BEGIN
5135: l_stmt_num := 10;
5136: /* --- start of auto log --- */
5137: IF l_plog THEN
5138: fnd_log.string(
5139: fnd_log.level_procedure,
5140: l_module||'.'||l_stmt_num,
5141: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5142: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5139: fnd_log.level_procedure,

5135: l_stmt_num := 10;
5136: /* --- start of auto log --- */
5137: IF l_plog THEN
5138: fnd_log.string(
5139: fnd_log.level_procedure,
5140: l_module||'.'||l_stmt_num,
5141: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5142: 'i_cost_group_id = '||i_cost_group_id||','||
5143: 'i_cost_type_id = '||i_cost_type_id||','||

Line 5193: fnd_log.string(

5189: /* --- start of auto log --- */
5190: <>
5191:
5192: IF l_plog THEN
5193: fnd_log.string(
5194: fnd_log.level_procedure,
5195: l_module||'.'||l_stmt_num,
5196: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5197: 'o_err_num = '||o_err_num||','||

Line 5194: fnd_log.level_procedure,

5190: <>
5191:
5192: IF l_plog THEN
5193: fnd_log.string(
5194: fnd_log.level_procedure,
5195: l_module||'.'||l_stmt_num,
5196: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5197: 'o_err_num = '||o_err_num||','||
5198: 'o_err_code = '||o_err_code||','||

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

5221: l_stmt_num NUMBER;
5222:
5223: /* --- start of auto log --- */
5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5222:
5223: /* --- start of auto log --- */
5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5223: /* --- start of auto log --- */
5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5232: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5232: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5233:

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

5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5232: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5233:
5234: /* --- end of auto log --- */

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

5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5232: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5233:
5234: /* --- end of auto log --- */
5235: BEGIN

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

5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5229: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5230: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5231: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5232: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5233:
5234: /* --- end of auto log --- */
5235: BEGIN
5236: /* --- start of auto log --- */

Line 5238: fnd_log.string(

5234: /* --- end of auto log --- */
5235: BEGIN
5236: /* --- start of auto log --- */
5237: IF l_plog THEN
5238: fnd_log.string(
5239: fnd_log.level_procedure,
5240: l_module||'.'||l_stmt_num,
5241: 'Entering CSTPPWAC.update_cppb with '||
5242: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5239: fnd_log.level_procedure,

5235: BEGIN
5236: /* --- start of auto log --- */
5237: IF l_plog THEN
5238: fnd_log.string(
5239: fnd_log.level_procedure,
5240: l_module||'.'||l_stmt_num,
5241: 'Entering CSTPPWAC.update_cppb with '||
5242: 'i_cost_group_id = '||i_cost_group_id||','||
5243: 'i_txn_category = '||i_txn_category||','||

Line 5450: fnd_log.string(

5446: /* --- start of auto log --- */
5447: <>
5448:
5449: IF l_plog THEN
5450: fnd_log.string(
5451: fnd_log.level_procedure,
5452: l_module||'.'||l_stmt_num,
5453: 'Exiting CSTPPWAC.update_cppb with '||
5454: 'o_err_num = '||o_err_num||','||

Line 5451: fnd_log.level_procedure,

5447: <>
5448:
5449: IF l_plog THEN
5450: fnd_log.string(
5451: fnd_log.level_procedure,
5452: l_module||'.'||l_stmt_num,
5453: 'Exiting CSTPPWAC.update_cppb with '||
5454: 'o_err_num = '||o_err_num||','||
5455: 'o_err_code = '||o_err_code||','||

Line 5467: fnd_log.message(

5463: IF l_uLog THEN
5464: fnd_message.set_name('BOM','CST_UNEXPECTED');
5465: fnd_message.set_token('SQLERRM',SQLERRM);
5466: fnd_msg_pub.add;
5467: fnd_log.message(
5468: fnd_log.level_unexpected,
5469: l_module||'.'||l_stmt_num,
5470: FALSE
5471: );

Line 5468: fnd_log.level_unexpected,

5464: fnd_message.set_name('BOM','CST_UNEXPECTED');
5465: fnd_message.set_token('SQLERRM',SQLERRM);
5466: fnd_msg_pub.add;
5467: fnd_log.message(
5468: fnd_log.level_unexpected,
5469: l_module||'.'||l_stmt_num,
5470: FALSE
5471: );
5472: END IF;

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

5495: l_stmt_num NUMBER;
5496:
5497: /* --- start of auto log --- */
5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5496:
5497: /* --- start of auto log --- */
5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5497: /* --- start of auto log --- */
5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5507:

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

5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5507:
5508: /* --- end of auto log --- */

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

5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5507:
5508: /* --- end of auto log --- */
5509: BEGIN

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

5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5507:
5508: /* --- end of auto log --- */
5509: BEGIN
5510: /* --- start of auto log --- */

Line 5512: fnd_log.string(

5508: /* --- end of auto log --- */
5509: BEGIN
5510: /* --- start of auto log --- */
5511: IF l_plog THEN
5512: fnd_log.string(
5513: fnd_log.level_procedure,
5514: l_module||'.'||l_stmt_num,
5515: 'Entering CSTPPWAC.update_item_cppb with '||
5516: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5513: fnd_log.level_procedure,

5509: BEGIN
5510: /* --- start of auto log --- */
5511: IF l_plog THEN
5512: fnd_log.string(
5513: fnd_log.level_procedure,
5514: l_module||'.'||l_stmt_num,
5515: 'Entering CSTPPWAC.update_item_cppb with '||
5516: 'i_cost_group_id = '||i_cost_group_id||','||
5517: 'i_txn_category = '||i_txn_category||','||

Line 5585: fnd_log.string(

5581: /* --- start of auto log --- */
5582: <>
5583:
5584: IF l_plog THEN
5585: fnd_log.string(
5586: fnd_log.level_procedure,
5587: l_module||'.'||l_stmt_num,
5588: 'Exiting CSTPPWAC.update_item_cppb with '||
5589: 'o_err_num = '||o_err_num||','||

Line 5586: fnd_log.level_procedure,

5582: <>
5583:
5584: IF l_plog THEN
5585: fnd_log.string(
5586: fnd_log.level_procedure,
5587: l_module||'.'||l_stmt_num,
5588: 'Exiting CSTPPWAC.update_item_cppb with '||
5589: 'o_err_num = '||o_err_num||','||
5590: 'o_err_code = '||o_err_code||','||

Line 5602: fnd_log.message(

5598: IF l_uLog THEN
5599: fnd_message.set_name('BOM','CST_UNEXPECTED');
5600: fnd_message.set_token('SQLERRM',SQLERRM);
5601: fnd_msg_pub.add;
5602: fnd_log.message(
5603: fnd_log.level_unexpected,
5604: l_module||'.'||l_stmt_num,
5605: FALSE
5606: );

Line 5603: fnd_log.level_unexpected,

5599: fnd_message.set_name('BOM','CST_UNEXPECTED');
5600: fnd_message.set_token('SQLERRM',SQLERRM);
5601: fnd_msg_pub.add;
5602: fnd_log.message(
5603: fnd_log.level_unexpected,
5604: l_module||'.'||l_stmt_num,
5605: FALSE
5606: );
5607: END IF;

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

5627: l_stmt_num NUMBER;
5628:
5629: /* --- start of auto log --- */
5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5628:
5629: /* --- start of auto log --- */
5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5629: /* --- start of auto log --- */
5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5638: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5638: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5639:

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

5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5638: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5639:
5640: /* --- end of auto log --- */

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

5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5638: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5639:
5640: /* --- end of auto log --- */
5641: BEGIN

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

5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5635: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5636: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5637: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5638: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5639:
5640: /* --- end of auto log --- */
5641: BEGIN
5642: /* --- start of auto log --- */

Line 5644: fnd_log.string(

5640: /* --- end of auto log --- */
5641: BEGIN
5642: /* --- start of auto log --- */
5643: IF l_plog THEN
5644: fnd_log.string(
5645: fnd_log.level_procedure,
5646: l_module||'.'||l_stmt_num,
5647: 'Entering CSTPPWAC.insert_ending_balance with '||
5648: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5645: fnd_log.level_procedure,

5641: BEGIN
5642: /* --- start of auto log --- */
5643: IF l_plog THEN
5644: fnd_log.string(
5645: fnd_log.level_procedure,
5646: l_module||'.'||l_stmt_num,
5647: 'Entering CSTPPWAC.insert_ending_balance with '||
5648: 'i_cost_group_id = '||i_cost_group_id||','||
5649: 'i_user_id = '||i_user_id||','||

Line 5725: fnd_log.string(

5721: /* --- start of auto log --- */
5722: <>
5723:
5724: IF l_plog THEN
5725: fnd_log.string(
5726: fnd_log.level_procedure,
5727: l_module||'.'||l_stmt_num,
5728: 'Exiting CSTPPWAC.insert_ending_balance with '||
5729: 'o_err_num = '||o_err_num||','||

Line 5726: fnd_log.level_procedure,

5722: <>
5723:
5724: IF l_plog THEN
5725: fnd_log.string(
5726: fnd_log.level_procedure,
5727: l_module||'.'||l_stmt_num,
5728: 'Exiting CSTPPWAC.insert_ending_balance with '||
5729: 'o_err_num = '||o_err_num||','||
5730: 'o_err_code = '||o_err_code||','||

Line 5742: fnd_log.message(

5738: IF l_uLog THEN
5739: fnd_message.set_name('BOM','CST_UNEXPECTED');
5740: fnd_message.set_token('SQLERRM',SQLERRM);
5741: fnd_msg_pub.add;
5742: fnd_log.message(
5743: fnd_log.level_unexpected,
5744: l_module||'.'||l_stmt_num,
5745: FALSE
5746: );

Line 5743: fnd_log.level_unexpected,

5739: fnd_message.set_name('BOM','CST_UNEXPECTED');
5740: fnd_message.set_token('SQLERRM',SQLERRM);
5741: fnd_msg_pub.add;
5742: fnd_log.message(
5743: fnd_log.level_unexpected,
5744: l_module||'.'||l_stmt_num,
5745: FALSE
5746: );
5747: END IF;