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.28.12010000.6 2008/11/29 02:36:19 anjha 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 3268: fnd_log.string(

3264: /* --- start of auto log --- */
3265: <>
3266:
3267: IF l_plog THEN
3268: fnd_log.string(
3269: fnd_log.level_procedure,
3270: l_module||'.'||l_stmt_num,
3271: 'Exiting CSTPPWAC.periodic_cost_update with '||
3272: 'O_Err_Num = '||O_Err_Num||','||

Line 3269: fnd_log.level_procedure,

3265: <>
3266:
3267: IF l_plog THEN
3268: fnd_log.string(
3269: fnd_log.level_procedure,
3270: l_module||'.'||l_stmt_num,
3271: 'Exiting CSTPPWAC.periodic_cost_update with '||
3272: 'O_Err_Num = '||O_Err_Num||','||
3273: 'O_Err_Code = '||O_Err_Code||','||

Line 3285: fnd_log.message(

3281: IF l_uLog THEN
3282: fnd_message.set_name('BOM','CST_UNEXPECTED');
3283: fnd_message.set_token('SQLERRM',SQLERRM);
3284: fnd_msg_pub.add;
3285: fnd_log.message(
3286: fnd_log.level_unexpected,
3287: l_module||'.'||l_stmt_num,
3288: FALSE
3289: );

Line 3286: fnd_log.level_unexpected,

3282: fnd_message.set_name('BOM','CST_UNEXPECTED');
3283: fnd_message.set_token('SQLERRM',SQLERRM);
3284: fnd_msg_pub.add;
3285: fnd_log.message(
3286: fnd_log.level_unexpected,
3287: l_module||'.'||l_stmt_num,
3288: FALSE
3289: );
3290: END IF;

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

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

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

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

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

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

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

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

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

3323: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3324: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3325: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3326: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3327: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3328: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3329: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3330: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3331:

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

3324: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3325: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3326: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3327: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3328: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3329: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3330: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3331:
3332: -- end of auto log ---

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

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

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

3326: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3327: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3328: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3329: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3330: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3331:
3332: -- end of auto log ---
3333: BEGIN
3334: --- start of auto log ---

Line 3336: fnd_log.string(

3332: -- end of auto log ---
3333: BEGIN
3334: --- start of auto log ---
3335: IF l_plog THEN
3336: fnd_log.string(
3337: fnd_log.level_procedure,
3338: l_module||'.'||l_stmt_num,
3339: 'Entering CSTPPWAC.insert_txn_history with '||
3340: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 3337: fnd_log.level_procedure,

3333: BEGIN
3334: --- start of auto log ---
3335: IF l_plog THEN
3336: fnd_log.string(
3337: fnd_log.level_procedure,
3338: l_module||'.'||l_stmt_num,
3339: 'Entering CSTPPWAC.insert_txn_history with '||
3340: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3341: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 3404: fnd_log.string(

3400: --- start of auto log ---
3401: <>
3402:
3403: IF l_plog THEN
3404: fnd_log.string(
3405: fnd_log.level_procedure,
3406: l_module||'.'||l_stmt_num,
3407: 'Exiting CSTPPWAC.insert_txn_history with '||
3408: 'O_Err_Num = '||O_Err_Num||','||

Line 3405: fnd_log.level_procedure,

3401: <>
3402:
3403: IF l_plog THEN
3404: fnd_log.string(
3405: fnd_log.level_procedure,
3406: l_module||'.'||l_stmt_num,
3407: 'Exiting CSTPPWAC.insert_txn_history with '||
3408: 'O_Err_Num = '||O_Err_Num||','||
3409: 'O_Err_Code = '||O_Err_Code||','||

Line 3421: fnd_log.message(

3417: IF l_uLog THEN
3418: fnd_message.set_name('BOM','CST_UNEXPECTED');
3419: fnd_message.set_token('SQLERRM',SQLERRM);
3420: fnd_msg_pub.add;
3421: fnd_log.message(
3422: fnd_log.level_unexpected,
3423: l_module||'.'||l_stmt_num,
3424: FALSE
3425: );

Line 3422: fnd_log.level_unexpected,

3418: fnd_message.set_name('BOM','CST_UNEXPECTED');
3419: fnd_message.set_token('SQLERRM',SQLERRM);
3420: fnd_msg_pub.add;
3421: fnd_log.message(
3422: fnd_log.level_unexpected,
3423: l_module||'.'||l_stmt_num,
3424: FALSE
3425: );
3426: END IF;

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

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

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

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

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

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

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

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

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

3457: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3458: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3459: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3460: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3461: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3462: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3463: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3464: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3465:

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

3458: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3459: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3460: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3461: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3462: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3463: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3464: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3465:
3466: --- end of auto log ---

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

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

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

3460: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3461: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3462: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3463: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3464: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3465:
3466: --- end of auto log ---
3467: BEGIN
3468: --- start of auto log ---

Line 3470: fnd_log.string(

3466: --- end of auto log ---
3467: BEGIN
3468: --- start of auto log ---
3469: IF l_plog THEN
3470: fnd_log.string(
3471: fnd_log.level_procedure,
3472: l_module||'.'||l_stmt_num,
3473: 'Entering CSTPPWAC.update_txn_history with '||
3474: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||

Line 3471: fnd_log.level_procedure,

3467: BEGIN
3468: --- start of auto log ---
3469: IF l_plog THEN
3470: fnd_log.string(
3471: fnd_log.level_procedure,
3472: l_module||'.'||l_stmt_num,
3473: 'Entering CSTPPWAC.update_txn_history with '||
3474: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3475: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 3508: fnd_log.string(

3504: --- start of auto log ---
3505: <>
3506:
3507: IF l_plog THEN
3508: fnd_log.string(
3509: fnd_log.level_procedure,
3510: l_module||'.'||l_stmt_num,
3511: 'Exiting CSTPPWAC.update_txn_history with '||
3512: 'O_Err_Num = '||O_Err_Num||','||

Line 3509: fnd_log.level_procedure,

3505: <>
3506:
3507: IF l_plog THEN
3508: fnd_log.string(
3509: fnd_log.level_procedure,
3510: l_module||'.'||l_stmt_num,
3511: 'Exiting CSTPPWAC.update_txn_history with '||
3512: 'O_Err_Num = '||O_Err_Num||','||
3513: 'O_Err_Code = '||O_Err_Code||','||

Line 3525: fnd_log.message(

3521: IF l_uLog THEN
3522: fnd_message.set_name('BOM','CST_UNEXPECTED');
3523: fnd_message.set_token('SQLERRM',SQLERRM);
3524: fnd_msg_pub.add;
3525: fnd_log.message(
3526: fnd_log.level_unexpected,
3527: l_module||'.'||l_stmt_num,
3528: FALSE
3529: );

Line 3526: fnd_log.level_unexpected,

3522: fnd_message.set_name('BOM','CST_UNEXPECTED');
3523: fnd_message.set_token('SQLERRM',SQLERRM);
3524: fnd_msg_pub.add;
3525: fnd_log.message(
3526: fnd_log.level_unexpected,
3527: l_module||'.'||l_stmt_num,
3528: FALSE
3529: );
3530: END IF;

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

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

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

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

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

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

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

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

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

3561: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3562: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3563: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3564: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3565: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3566: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3567: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3568: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3569:

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

3562: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3563: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3564: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3565: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3566: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3567: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3568: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3569:
3570: /* --- end of auto log --- */

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

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

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

3564: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3565: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3566: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3567: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3568: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3569:
3570: /* --- end of auto log --- */
3571: BEGIN
3572: /* --- start of auto log --- */

Line 3574: fnd_log.string(

3570: /* --- end of auto log --- */
3571: BEGIN
3572: /* --- start of auto log --- */
3573: IF l_plog THEN
3574: fnd_log.string(
3575: fnd_log.level_procedure,
3576: l_module||'.'||l_stmt_num,
3577: 'Entering CSTPPWAC.insert_into_cppb with '||
3578: 'i_cost_group_id = '||i_cost_group_id||','||

Line 3575: fnd_log.level_procedure,

3571: BEGIN
3572: /* --- start of auto log --- */
3573: IF l_plog THEN
3574: fnd_log.string(
3575: fnd_log.level_procedure,
3576: l_module||'.'||l_stmt_num,
3577: 'Entering CSTPPWAC.insert_into_cppb with '||
3578: 'i_cost_group_id = '||i_cost_group_id||','||
3579: 'i_txn_category = '||i_txn_category||','||

Line 3831: fnd_log.string(

3827: /* --- start of auto log --- */
3828: <>
3829:
3830: IF l_plog THEN
3831: fnd_log.string(
3832: fnd_log.level_procedure,
3833: l_module||'.'||l_stmt_num,
3834: 'Exiting CSTPPWAC.insert_into_cppb with '||
3835: 'o_err_num = '||o_err_num||','||

Line 3832: fnd_log.level_procedure,

3828: <>
3829:
3830: IF l_plog THEN
3831: fnd_log.string(
3832: fnd_log.level_procedure,
3833: l_module||'.'||l_stmt_num,
3834: 'Exiting CSTPPWAC.insert_into_cppb with '||
3835: 'o_err_num = '||o_err_num||','||
3836: 'o_err_code = '||o_err_code||','||

Line 3848: fnd_log.message(

3844: IF l_uLog THEN
3845: fnd_message.set_name('BOM','CST_UNEXPECTED');
3846: fnd_message.set_token('SQLERRM',SQLERRM);
3847: fnd_msg_pub.add;
3848: fnd_log.message(
3849: fnd_log.level_unexpected,
3850: l_module||'.'||l_stmt_num,
3851: FALSE
3852: );

Line 3849: fnd_log.level_unexpected,

3845: fnd_message.set_name('BOM','CST_UNEXPECTED');
3846: fnd_message.set_token('SQLERRM',SQLERRM);
3847: fnd_msg_pub.add;
3848: fnd_log.message(
3849: fnd_log.level_unexpected,
3850: l_module||'.'||l_stmt_num,
3851: FALSE
3852: );
3853: END IF;

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

3886: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
3887:
3888: /* --- start of auto log --- */
3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

3887:
3888: /* --- start of auto log --- */
3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

3888: /* --- start of auto log --- */
3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3897: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3897: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3898:

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

3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3897: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3898:
3899: /* --- end of auto log --- */

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

3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3897: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3898:
3899: /* --- end of auto log --- */
3900: BEGIN

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

3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
3894: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
3895: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
3896: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
3897: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
3898:
3899: /* --- end of auto log --- */
3900: BEGIN
3901: /* --- start of auto log --- */

Line 3903: fnd_log.string(

3899: /* --- end of auto log --- */
3900: BEGIN
3901: /* --- start of auto log --- */
3902: IF l_plog THEN
3903: fnd_log.string(
3904: fnd_log.level_procedure,
3905: l_module||'.'||l_stmt_num,
3906: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3907: 'i_cost_group_id = '||i_cost_group_id||','||

Line 3904: fnd_log.level_procedure,

3900: BEGIN
3901: /* --- start of auto log --- */
3902: IF l_plog THEN
3903: fnd_log.string(
3904: fnd_log.level_procedure,
3905: l_module||'.'||l_stmt_num,
3906: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3907: 'i_cost_group_id = '||i_cost_group_id||','||
3908: 'i_cost_type_id = '||i_cost_type_id||','||

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

3963: AND cpllc.inventory_item_id = mpacd.inventory_item_id
3964: AND cpllc.low_level_code = i_low_level_code);
3965:
3966: IF l_sLog THEN
3967: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);
3968: END IF;
3969:
3970: IF (l_max_txn_category = 7) THEN
3971: -- Rework completions. Pick only items having records with transaction

Line 4443: fnd_log.string(

4439: /* --- start of auto log --- */
4440: <>
4441:
4442: IF l_plog THEN
4443: fnd_log.string(
4444: fnd_log.level_procedure,
4445: l_module||'.'||l_stmt_num,
4446: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4447: 'o_err_num = '||o_err_num||','||

Line 4444: fnd_log.level_procedure,

4440: <>
4441:
4442: IF l_plog THEN
4443: fnd_log.string(
4444: fnd_log.level_procedure,
4445: l_module||'.'||l_stmt_num,
4446: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4447: 'o_err_num = '||o_err_num||','||
4448: 'o_err_code = '||o_err_code||','||

Line 4460: fnd_log.message(

4456: IF l_uLog THEN
4457: fnd_message.set_name('BOM','CST_UNEXPECTED');
4458: fnd_message.set_token('SQLERRM',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_log.message(
4461: fnd_log.level_unexpected,
4462: l_module||'.'||l_stmt_num,
4463: FALSE
4464: );

Line 4461: fnd_log.level_unexpected,

4457: fnd_message.set_name('BOM','CST_UNEXPECTED');
4458: fnd_message.set_token('SQLERRM',SQLERRM);
4459: fnd_msg_pub.add;
4460: fnd_log.message(
4461: fnd_log.level_unexpected,
4462: l_module||'.'||l_stmt_num,
4463: FALSE
4464: );
4465: END IF;

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

4495: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
4496:
4497: /* --- start of auto log --- */
4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

4496:
4497: /* --- start of auto log --- */
4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

4497: /* --- start of auto log --- */
4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4507:

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

4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4507:
4508: /* --- end of auto log --- */

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

4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4507:
4508: /* --- end of auto log --- */
4509: BEGIN

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

4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
4503: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
4504: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
4505: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
4506: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
4507:
4508: /* --- end of auto log --- */
4509: BEGIN
4510: /* --- start of auto log --- */

Line 4512: fnd_log.string(

4508: /* --- end of auto log --- */
4509: BEGIN
4510: /* --- start of auto log --- */
4511: IF l_plog THEN
4512: fnd_log.string(
4513: fnd_log.level_procedure,
4514: l_module||'.'||l_stmt_num,
4515: 'Entering CSTPPWAC.calc_periodic_cost with '||
4516: 'i_cost_group_id = '||i_cost_group_id||','||

Line 4513: fnd_log.level_procedure,

4509: BEGIN
4510: /* --- start of auto log --- */
4511: IF l_plog THEN
4512: fnd_log.string(
4513: fnd_log.level_procedure,
4514: l_module||'.'||l_stmt_num,
4515: 'Entering CSTPPWAC.calc_periodic_cost with '||
4516: 'i_cost_group_id = '||i_cost_group_id||','||
4517: 'i_cost_type_id = '||i_cost_type_id||','||

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

4569: AND cpllc.inventory_item_id = mpacd.inventory_item_id
4570: AND cpllc.low_level_code = i_low_level_code);
4571:
4572: IF l_sLog THEN
4573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,l_module||'.'||l_stmt_num,'l_max_txn_category = '||l_max_txn_category);
4574: END IF;
4575:
4576: IF (l_max_txn_category = 7) THEN
4577: -- Rework completions. Pick only items having records with transaction

Line 5045: fnd_log.string(

5041: /* --- start of auto log --- */
5042: <>
5043:
5044: IF l_plog THEN
5045: fnd_log.string(
5046: fnd_log.level_procedure,
5047: l_module||'.'||l_stmt_num,
5048: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5049: 'o_err_num = '||o_err_num||','||

Line 5046: fnd_log.level_procedure,

5042: <>
5043:
5044: IF l_plog THEN
5045: fnd_log.string(
5046: fnd_log.level_procedure,
5047: l_module||'.'||l_stmt_num,
5048: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5049: 'o_err_num = '||o_err_num||','||
5050: 'o_err_code = '||o_err_code||','||

Line 5062: fnd_log.message(

5058: IF l_uLog THEN
5059: fnd_message.set_name('BOM','CST_UNEXPECTED');
5060: fnd_message.set_token('SQLERRM',SQLERRM);
5061: fnd_msg_pub.add;
5062: fnd_log.message(
5063: fnd_log.level_unexpected,
5064: l_module||'.'||l_stmt_num,
5065: FALSE
5066: );

Line 5063: fnd_log.level_unexpected,

5059: fnd_message.set_name('BOM','CST_UNEXPECTED');
5060: fnd_message.set_token('SQLERRM',SQLERRM);
5061: fnd_msg_pub.add;
5062: fnd_log.message(
5063: fnd_log.level_unexpected,
5064: l_module||'.'||l_stmt_num,
5065: FALSE
5066: );
5067: END IF;

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

5089: IS
5090: l_stmt_num NUMBER;
5091: /* --- start of auto log --- */
5092: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5090: l_stmt_num NUMBER;
5091: /* --- start of auto log --- */
5092: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5091: /* --- start of auto log --- */
5092: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5092: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5100: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5100: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5101:

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

5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5100: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5101:
5102: /* --- end of auto log --- */

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

5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5100: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5101:
5102: /* --- end of auto log --- */
5103: BEGIN

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

5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5097: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5098: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5099: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5100: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5101:
5102: /* --- end of auto log --- */
5103: BEGIN
5104: l_stmt_num := 10;

Line 5107: fnd_log.string(

5103: BEGIN
5104: l_stmt_num := 10;
5105: /* --- start of auto log --- */
5106: IF l_plog THEN
5107: fnd_log.string(
5108: fnd_log.level_procedure,
5109: l_module||'.'||l_stmt_num,
5110: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5111: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5108: fnd_log.level_procedure,

5104: l_stmt_num := 10;
5105: /* --- start of auto log --- */
5106: IF l_plog THEN
5107: fnd_log.string(
5108: fnd_log.level_procedure,
5109: l_module||'.'||l_stmt_num,
5110: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5111: 'i_cost_group_id = '||i_cost_group_id||','||
5112: 'i_cost_type_id = '||i_cost_type_id||','||

Line 5162: fnd_log.string(

5158: /* --- start of auto log --- */
5159: <>
5160:
5161: IF l_plog THEN
5162: fnd_log.string(
5163: fnd_log.level_procedure,
5164: l_module||'.'||l_stmt_num,
5165: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5166: 'o_err_num = '||o_err_num||','||

Line 5163: fnd_log.level_procedure,

5159: <>
5160:
5161: IF l_plog THEN
5162: fnd_log.string(
5163: fnd_log.level_procedure,
5164: l_module||'.'||l_stmt_num,
5165: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5166: 'o_err_num = '||o_err_num||','||
5167: 'o_err_code = '||o_err_code||','||

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

5190: l_stmt_num NUMBER;
5191:
5192: /* --- start of auto log --- */
5193: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5191:
5192: /* --- start of auto log --- */
5193: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5192: /* --- start of auto log --- */
5193: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5193: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5201: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5201: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5202:

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

5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5201: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5202:
5203: /* --- end of auto log --- */

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

5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5201: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5202:
5203: /* --- end of auto log --- */
5204: BEGIN

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

5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5198: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5199: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5200: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5201: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5202:
5203: /* --- end of auto log --- */
5204: BEGIN
5205: /* --- start of auto log --- */

Line 5207: fnd_log.string(

5203: /* --- end of auto log --- */
5204: BEGIN
5205: /* --- start of auto log --- */
5206: IF l_plog THEN
5207: fnd_log.string(
5208: fnd_log.level_procedure,
5209: l_module||'.'||l_stmt_num,
5210: 'Entering CSTPPWAC.update_cppb with '||
5211: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5208: fnd_log.level_procedure,

5204: BEGIN
5205: /* --- start of auto log --- */
5206: IF l_plog THEN
5207: fnd_log.string(
5208: fnd_log.level_procedure,
5209: l_module||'.'||l_stmt_num,
5210: 'Entering CSTPPWAC.update_cppb with '||
5211: 'i_cost_group_id = '||i_cost_group_id||','||
5212: 'i_txn_category = '||i_txn_category||','||

Line 5409: fnd_log.string(

5405: /* --- start of auto log --- */
5406: <>
5407:
5408: IF l_plog THEN
5409: fnd_log.string(
5410: fnd_log.level_procedure,
5411: l_module||'.'||l_stmt_num,
5412: 'Exiting CSTPPWAC.update_cppb with '||
5413: 'o_err_num = '||o_err_num||','||

Line 5410: fnd_log.level_procedure,

5406: <>
5407:
5408: IF l_plog THEN
5409: fnd_log.string(
5410: fnd_log.level_procedure,
5411: l_module||'.'||l_stmt_num,
5412: 'Exiting CSTPPWAC.update_cppb with '||
5413: 'o_err_num = '||o_err_num||','||
5414: 'o_err_code = '||o_err_code||','||

Line 5426: fnd_log.message(

5422: IF l_uLog THEN
5423: fnd_message.set_name('BOM','CST_UNEXPECTED');
5424: fnd_message.set_token('SQLERRM',SQLERRM);
5425: fnd_msg_pub.add;
5426: fnd_log.message(
5427: fnd_log.level_unexpected,
5428: l_module||'.'||l_stmt_num,
5429: FALSE
5430: );

Line 5427: fnd_log.level_unexpected,

5423: fnd_message.set_name('BOM','CST_UNEXPECTED');
5424: fnd_message.set_token('SQLERRM',SQLERRM);
5425: fnd_msg_pub.add;
5426: fnd_log.message(
5427: fnd_log.level_unexpected,
5428: l_module||'.'||l_stmt_num,
5429: FALSE
5430: );
5431: END IF;

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

5454: l_stmt_num NUMBER;
5455:
5456: /* --- start of auto log --- */
5457: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5455:
5456: /* --- start of auto log --- */
5457: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5456: /* --- start of auto log --- */
5457: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5457: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5465: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5465: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5466:

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

5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5465: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5466:
5467: /* --- end of auto log --- */

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

5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5465: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5466:
5467: /* --- end of auto log --- */
5468: BEGIN

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

5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5462: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5463: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5464: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5465: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5466:
5467: /* --- end of auto log --- */
5468: BEGIN
5469: /* --- start of auto log --- */

Line 5471: fnd_log.string(

5467: /* --- end of auto log --- */
5468: BEGIN
5469: /* --- start of auto log --- */
5470: IF l_plog THEN
5471: fnd_log.string(
5472: fnd_log.level_procedure,
5473: l_module||'.'||l_stmt_num,
5474: 'Entering CSTPPWAC.update_item_cppb with '||
5475: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5472: fnd_log.level_procedure,

5468: BEGIN
5469: /* --- start of auto log --- */
5470: IF l_plog THEN
5471: fnd_log.string(
5472: fnd_log.level_procedure,
5473: l_module||'.'||l_stmt_num,
5474: 'Entering CSTPPWAC.update_item_cppb with '||
5475: 'i_cost_group_id = '||i_cost_group_id||','||
5476: 'i_txn_category = '||i_txn_category||','||

Line 5544: fnd_log.string(

5540: /* --- start of auto log --- */
5541: <>
5542:
5543: IF l_plog THEN
5544: fnd_log.string(
5545: fnd_log.level_procedure,
5546: l_module||'.'||l_stmt_num,
5547: 'Exiting CSTPPWAC.update_item_cppb with '||
5548: 'o_err_num = '||o_err_num||','||

Line 5545: fnd_log.level_procedure,

5541: <>
5542:
5543: IF l_plog THEN
5544: fnd_log.string(
5545: fnd_log.level_procedure,
5546: l_module||'.'||l_stmt_num,
5547: 'Exiting CSTPPWAC.update_item_cppb with '||
5548: 'o_err_num = '||o_err_num||','||
5549: 'o_err_code = '||o_err_code||','||

Line 5561: fnd_log.message(

5557: IF l_uLog THEN
5558: fnd_message.set_name('BOM','CST_UNEXPECTED');
5559: fnd_message.set_token('SQLERRM',SQLERRM);
5560: fnd_msg_pub.add;
5561: fnd_log.message(
5562: fnd_log.level_unexpected,
5563: l_module||'.'||l_stmt_num,
5564: FALSE
5565: );

Line 5562: fnd_log.level_unexpected,

5558: fnd_message.set_name('BOM','CST_UNEXPECTED');
5559: fnd_message.set_token('SQLERRM',SQLERRM);
5560: fnd_msg_pub.add;
5561: fnd_log.message(
5562: fnd_log.level_unexpected,
5563: l_module||'.'||l_stmt_num,
5564: FALSE
5565: );
5566: END IF;

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

5586: l_stmt_num NUMBER;
5587:
5588: /* --- start of auto log --- */
5589: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

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

5587:
5588: /* --- start of auto log --- */
5589: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

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

5588: /* --- start of auto log --- */
5589: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

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

5589: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5597: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5597: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5598:

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

5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5597: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5598:
5599: /* --- end of auto log --- */

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

5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5597: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5598:
5599: /* --- end of auto log --- */
5600: BEGIN

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

5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
5594: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
5595: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
5596: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
5597: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
5598:
5599: /* --- end of auto log --- */
5600: BEGIN
5601: /* --- start of auto log --- */

Line 5603: fnd_log.string(

5599: /* --- end of auto log --- */
5600: BEGIN
5601: /* --- start of auto log --- */
5602: IF l_plog THEN
5603: fnd_log.string(
5604: fnd_log.level_procedure,
5605: l_module||'.'||l_stmt_num,
5606: 'Entering CSTPPWAC.insert_ending_balance with '||
5607: 'i_cost_group_id = '||i_cost_group_id||','||

Line 5604: fnd_log.level_procedure,

5600: BEGIN
5601: /* --- start of auto log --- */
5602: IF l_plog THEN
5603: fnd_log.string(
5604: fnd_log.level_procedure,
5605: l_module||'.'||l_stmt_num,
5606: 'Entering CSTPPWAC.insert_ending_balance with '||
5607: 'i_cost_group_id = '||i_cost_group_id||','||
5608: 'i_user_id = '||i_user_id||','||

Line 5684: fnd_log.string(

5680: /* --- start of auto log --- */
5681: <>
5682:
5683: IF l_plog THEN
5684: fnd_log.string(
5685: fnd_log.level_procedure,
5686: l_module||'.'||l_stmt_num,
5687: 'Exiting CSTPPWAC.insert_ending_balance with '||
5688: 'o_err_num = '||o_err_num||','||

Line 5685: fnd_log.level_procedure,

5681: <>
5682:
5683: IF l_plog THEN
5684: fnd_log.string(
5685: fnd_log.level_procedure,
5686: l_module||'.'||l_stmt_num,
5687: 'Exiting CSTPPWAC.insert_ending_balance with '||
5688: 'o_err_num = '||o_err_num||','||
5689: 'o_err_code = '||o_err_code||','||

Line 5701: fnd_log.message(

5697: IF l_uLog THEN
5698: fnd_message.set_name('BOM','CST_UNEXPECTED');
5699: fnd_message.set_token('SQLERRM',SQLERRM);
5700: fnd_msg_pub.add;
5701: fnd_log.message(
5702: fnd_log.level_unexpected,
5703: l_module||'.'||l_stmt_num,
5704: FALSE
5705: );

Line 5702: fnd_log.level_unexpected,

5698: fnd_message.set_name('BOM','CST_UNEXPECTED');
5699: fnd_message.set_token('SQLERRM',SQLERRM);
5700: fnd_msg_pub.add;
5701: fnd_log.message(
5702: fnd_log.level_unexpected,
5703: l_module||'.'||l_stmt_num,
5704: FALSE
5705: );
5706: END IF;