eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PACEAMCOST_GRP dependencies on FND_LOG

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

1: PACKAGE BODY CST_PacEamCost_GRP AS
2: /* $Header: CSTPPEAB.pls 120.13 2011/05/12 19:40:27 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CST_PacEamCost_GRP';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: -- Start of comments
8: -- API name : Estimate_PAC_WipJobs
9: -- Type : Public.

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

72: /* 2- PROCEDURE */
73: /* 1- STATEMENT */
74:
75: /* In general, we should use the following:
76: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

73: /* 1- STATEMENT */
74:
75: /* In general, we should use the following:
76: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

74:
75: /* In general, we should use the following:
76: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

75: /* In general, we should use the following:
76: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */

Line 80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

76: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */
84:

Line 81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

77: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */
84:
85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

78: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
79: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
80: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */
84:
85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
86: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

81: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */
84:
85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
86: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
87: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
88:
89: l_dummy NUMBER;

Line 86: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

82: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
83: */
84:
85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
86: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
87: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
88:
89: l_dummy NUMBER;
90: l_count NUMBER;

Line 87: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

83: */
84:
85: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
86: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
87: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
88:
89: l_dummy NUMBER;
90: l_count NUMBER;
91: l_index NUMBER;

Line 127: FND_LOG.STRING(

123: BEGIN
124:
125: /* Procedure level log message for Entry point */
126: IF (l_pLog) THEN
127: FND_LOG.STRING(
128: FND_LOG.LEVEL_PROCEDURE,
129: l_module || '.begin',
130: 'Estimate_PAC_WipJobs <<');
131: END IF;

Line 128: FND_LOG.LEVEL_PROCEDURE,

124:
125: /* Procedure level log message for Entry point */
126: IF (l_pLog) THEN
127: FND_LOG.STRING(
128: FND_LOG.LEVEL_PROCEDURE,
129: l_module || '.begin',
130: 'Estimate_PAC_WipJobs <<');
131: END IF;
132:

Line 161: FND_LOG.STRING(

157: || ' p_wip_entity_id ' || to_char(p_wip_entity_id);
158:
159: -- statement level logging
160: IF (l_sLog) THEN
161: FND_LOG.STRING(
162: FND_LOG.LEVEL_STATEMENT,
163: l_module || '.' || l_stmt_num,
164: l_api_message);
165: END IF;

Line 162: FND_LOG.LEVEL_STATEMENT,

158:
159: -- statement level logging
160: IF (l_sLog) THEN
161: FND_LOG.STRING(
162: FND_LOG.LEVEL_STATEMENT,
163: l_module || '.' || l_stmt_num,
164: l_api_message);
165: END IF;
166:

Line 393: FND_LOG.STRING(

389: END IF;
390:
391: -- statement level logging
392: IF (l_sLog) THEN
393: FND_LOG.STRING(
394: FND_LOG.LEVEL_STATEMENT,
395: l_module || '.' || l_stmt_num,
396: TO_CHAR(SQL%ROWCOUNT) ||' Job Record(s) Updated with Group Id: '
397: ||TO_CHAR(l_estimation_group_id));

Line 394: FND_LOG.LEVEL_STATEMENT,

390:
391: -- statement level logging
392: IF (l_sLog) THEN
393: FND_LOG.STRING(
394: FND_LOG.LEVEL_STATEMENT,
395: l_module || '.' || l_stmt_num,
396: TO_CHAR(SQL%ROWCOUNT) ||' Job Record(s) Updated with Group Id: '
397: ||TO_CHAR(l_estimation_group_id));
398: END IF;

Line 440: FND_LOG.STRING(

436: IF (l_sLog) THEN
437: l_api_message := 'CST_PacEamCost_GRP.Estimate_PAC_WipJobs('
438: || to_char(l_stmt_num) || '): '
439: || 'Delete/Update successful in delete_eamperbal';
440: FND_LOG.STRING(
441: FND_LOG.LEVEL_STATEMENT,
442: l_module || '.' || l_stmt_num,
443: l_api_message);
444: END IF;

Line 441: FND_LOG.LEVEL_STATEMENT,

437: l_api_message := 'CST_PacEamCost_GRP.Estimate_PAC_WipJobs('
438: || to_char(l_stmt_num) || '): '
439: || 'Delete/Update successful in delete_eamperbal';
440: FND_LOG.STRING(
441: FND_LOG.LEVEL_STATEMENT,
442: l_module || '.' || l_stmt_num,
443: l_api_message);
444: END IF;
445:

Line 477: FND_LOG.STRING(

473: IF (l_sLog) THEN
474: l_api_message := 'CST_PacEamCost_GRP. delete_PAC_EamBalAcct ('
475: || to_char(l_stmt_num) || '): '
476: || 'Delete/Update successful in delete_pac_eambalacct';
477: FND_LOG.STRING(
478: FND_LOG.LEVEL_STATEMENT,
479: l_module || '.' || l_stmt_num,
480: l_api_message);
481: END IF;

Line 478: FND_LOG.LEVEL_STATEMENT,

474: l_api_message := 'CST_PacEamCost_GRP. delete_PAC_EamBalAcct ('
475: || to_char(l_stmt_num) || '): '
476: || 'Delete/Update successful in delete_pac_eambalacct';
477: FND_LOG.STRING(
478: FND_LOG.LEVEL_STATEMENT,
479: l_module || '.' || l_stmt_num,
480: l_api_message);
481: END IF;
482:

Line 522: FND_LOG.STRING(

518: IF (l_sLog) THEN
519: l_api_message := 'CST_eamCost_PUB.Insert_tempEstimateDetails ('
520: || to_char(l_stmt_num) || '): '
521: || 'Insert int CEDIV successful Insert_tempEstimateDetails';
522: FND_LOG.STRING(
523: FND_LOG.LEVEL_STATEMENT,
524: l_module || '.' || l_stmt_num,
525: l_api_message);
526: END IF;

Line 523: FND_LOG.LEVEL_STATEMENT,

519: l_api_message := 'CST_eamCost_PUB.Insert_tempEstimateDetails ('
520: || to_char(l_stmt_num) || '): '
521: || 'Insert int CEDIV successful Insert_tempEstimateDetails';
522: FND_LOG.STRING(
523: FND_LOG.LEVEL_STATEMENT,
524: l_module || '.' || l_stmt_num,
525: l_api_message);
526: END IF;
527:

Line 542: FND_LOG.STRING(

538: SAVEPOINT Estimate_PAC_WipJobs_PUB;
539:
540: -- statement level logging
541: IF (l_sLog) THEN
542: FND_LOG.STRING(
543: FND_LOG.LEVEL_STATEMENT,
544: l_module || '.' || l_stmt_num,
545: 'Processing Job:' || TO_CHAR(l_wip_entity_id_tab(l_index)));
546: END IF;

Line 543: FND_LOG.LEVEL_STATEMENT,

539:
540: -- statement level logging
541: IF (l_sLog) THEN
542: FND_LOG.STRING(
543: FND_LOG.LEVEL_STATEMENT,
544: l_module || '.' || l_stmt_num,
545: 'Processing Job:' || TO_CHAR(l_wip_entity_id_tab(l_index)));
546: END IF;
547:

Line 596: FND_LOG.STRING(

592: -- statement level logging
593: IF (l_sLog) THEN
594: l_api_message := 'Estimation complete for wip_entity_id = '
595: || to_char(l_wip_entity_id_tab(l_index));
596: FND_LOG.STRING(
597: FND_LOG.LEVEL_STATEMENT,
598: l_module || '.' || l_stmt_num,
599: l_api_message);
600: END IF;

Line 597: FND_LOG.LEVEL_STATEMENT,

593: IF (l_sLog) THEN
594: l_api_message := 'Estimation complete for wip_entity_id = '
595: || to_char(l_wip_entity_id_tab(l_index));
596: FND_LOG.STRING(
597: FND_LOG.LEVEL_STATEMENT,
598: l_module || '.' || l_stmt_num,
599: l_api_message);
600: END IF;
601:

Line 627: FND_LOG.STRING(

623: -- statement level logging
624: IF (l_sLog) THEN
625: l_api_message := 'Estimation failed for wip_entity_id = '
626: || to_char(l_wip_entity_id_tab(l_index));
627: FND_LOG.STRING(
628: FND_LOG.LEVEL_STATEMENT,
629: l_module || '.' || l_stmt_num,
630: l_api_message);
631: END IF;

Line 628: FND_LOG.LEVEL_STATEMENT,

624: IF (l_sLog) THEN
625: l_api_message := 'Estimation failed for wip_entity_id = '
626: || to_char(l_wip_entity_id_tab(l_index));
627: FND_LOG.STRING(
628: FND_LOG.LEVEL_STATEMENT,
629: l_module || '.' || l_stmt_num,
630: l_api_message);
631: END IF;
632:

Line 665: FND_LOG.STRING(

661: COMMIT;
662:
663: -- Procedure level log message for exit point
664: IF (l_pLog) THEN
665: FND_LOG.STRING(
666: FND_LOG.LEVEL_PROCEDURE,
667: l_module || '.end',
668: 'Estimate_PAC_WipJobs >>'
669: );

Line 666: FND_LOG.LEVEL_PROCEDURE,

662:
663: -- Procedure level log message for exit point
664: IF (l_pLog) THEN
665: FND_LOG.STRING(
666: FND_LOG.LEVEL_PROCEDURE,
667: l_module || '.end',
668: 'Estimate_PAC_WipJobs >>'
669: );
670: END IF;

Line 692: FND_LOG.STRING(

688: AND cost_type_id = p_cost_type_id
689: AND cost_group_id = p_cost_group_id;
690:
691: IF (l_uLog) THEN
692: FND_LOG.STRING(
693: FND_LOG.LEVEL_UNEXPECTED,
694: l_module || '.' || l_stmt_num ,
695: l_msg_data); -- show the message of where it failed.
696: END IF;

Line 693: FND_LOG.LEVEL_UNEXPECTED,

689: AND cost_group_id = p_cost_group_id;
690:
691: IF (l_uLog) THEN
692: FND_LOG.STRING(
693: FND_LOG.LEVEL_UNEXPECTED,
694: l_module || '.' || l_stmt_num ,
695: l_msg_data); -- show the message of where it failed.
696: END IF;
697:

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

795: /* 2- PROCEDURE */
796: /* 1- STATEMENT */
797:
798: /* In general, we should use the following:
799: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

796: /* 1- STATEMENT */
797:
798: /* In general, we should use the following:
799: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

797:
798: /* In general, we should use the following:
799: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

798: /* In general, we should use the following:
799: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */

Line 803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

799: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */
807:

Line 804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

800: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */
807:
808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

801: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
802: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
803: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */
807:
808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
809: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

804: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */
807:
808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
809: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
810: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
811:
812: CURSOR v_est_csr(c_organization_id NUMBER,

Line 809: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

805: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
806: */
807:
808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
809: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
810: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
811:
812: CURSOR v_est_csr(c_organization_id NUMBER,
813: c_wip_entity_id NUMBER) IS

Line 810: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

806: */
807:
808: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
809: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
810: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
811:
812: CURSOR v_est_csr(c_organization_id NUMBER,
813: c_wip_entity_id NUMBER) IS
814: SELECT period_set_name,

Line 834: FND_LOG.STRING(

830: BEGIN
831:
832: -- Procedure level log message for Entry point
833: IF (l_pLog) THEN
834: FND_LOG.STRING(
835: FND_LOG.LEVEL_PROCEDURE,
836: l_module || '.begin',
837: 'Delete_PAC_EamPerBal <<');
838: END IF;

Line 835: FND_LOG.LEVEL_PROCEDURE,

831:
832: -- Procedure level log message for Entry point
833: IF (l_pLog) THEN
834: FND_LOG.STRING(
835: FND_LOG.LEVEL_PROCEDURE,
836: l_module || '.begin',
837: 'Delete_PAC_EamPerBal <<');
838: END IF;
839:

Line 930: FND_LOG.STRING(

926: AND cost_type_id = p_cost_type_id ;
927:
928: -- statement level logging
929: IF (l_sLog) THEN
930: FND_LOG.STRING(
931: FND_LOG.LEVEL_STATEMENT,
932: l_module || '.' || l_stmt_num,
933: 'Delete/Update CPEAPB successful for ' || TO_CHAR(p_wip_entity_id_tab(l_index)));
934: END IF;

Line 931: FND_LOG.LEVEL_STATEMENT,

927:
928: -- statement level logging
929: IF (l_sLog) THEN
930: FND_LOG.STRING(
931: FND_LOG.LEVEL_STATEMENT,
932: l_module || '.' || l_stmt_num,
933: 'Delete/Update CPEAPB successful for ' || TO_CHAR(p_wip_entity_id_tab(l_index)));
934: END IF;
935:

Line 946: FND_LOG.STRING(

942: l_stmt_num := 130;
943:
944: -- statement level logging
945: IF (l_sLog) THEN
946: FND_LOG.STRING(
947: FND_LOG.LEVEL_STATEMENT,
948: l_module || '.' || l_stmt_num,
949: 'CPEAPB Updation completed successfully.');
950: END IF;

Line 947: FND_LOG.LEVEL_STATEMENT,

943:
944: -- statement level logging
945: IF (l_sLog) THEN
946: FND_LOG.STRING(
947: FND_LOG.LEVEL_STATEMENT,
948: l_module || '.' || l_stmt_num,
949: 'CPEAPB Updation completed successfully.');
950: END IF;
951:

Line 967: FND_LOG.STRING(

963: l_stmt_num := 140;
964:
965: -- statement level logging
966: IF (l_sLog) THEN
967: FND_LOG.STRING(
968: FND_LOG.LEVEL_STATEMENT,
969: l_module || '.' || l_stmt_num,
970: 'CPEPB Updation completed successfully.');
971: END IF;

Line 968: FND_LOG.LEVEL_STATEMENT,

964:
965: -- statement level logging
966: IF (l_sLog) THEN
967: FND_LOG.STRING(
968: FND_LOG.LEVEL_STATEMENT,
969: l_module || '.' || l_stmt_num,
970: 'CPEPB Updation completed successfully.');
971: END IF;
972:

Line 991: FND_LOG.STRING(

987: l_stmt_num := 150;
988:
989: -- statement level logging
990: IF (l_sLog) THEN
991: FND_LOG.STRING(
992: FND_LOG.LEVEL_STATEMENT,
993: l_module || '.' || l_stmt_num,
994: 'Delted from CPEPB successfully.');
995: END IF;

Line 992: FND_LOG.LEVEL_STATEMENT,

988:
989: -- statement level logging
990: IF (l_sLog) THEN
991: FND_LOG.STRING(
992: FND_LOG.LEVEL_STATEMENT,
993: l_module || '.' || l_stmt_num,
994: 'Delted from CPEPB successfully.');
995: END IF;
996:

Line 1001: FND_LOG.STRING(

997: END IF; -- end check count of records
998:
999: -- Procedure level log message for exit point
1000: IF (l_pLog) THEN
1001: FND_LOG.STRING(
1002: FND_LOG.LEVEL_PROCEDURE,
1003: l_module || '.end',
1004: 'Delete_PAC_EamPerBal >>'
1005: );

Line 1002: FND_LOG.LEVEL_PROCEDURE,

998:
999: -- Procedure level log message for exit point
1000: IF (l_pLog) THEN
1001: FND_LOG.STRING(
1002: FND_LOG.LEVEL_PROCEDURE,
1003: l_module || '.end',
1004: 'Delete_PAC_EamPerBal >>'
1005: );
1006: END IF;

Line 1030: FND_LOG.STRING(

1026: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028:
1029: IF (l_uLog) THEN
1030: FND_LOG.STRING(
1031: FND_LOG.LEVEL_UNEXPECTED,
1032: l_module || '.' || l_stmt_num ,
1033: SUBSTRB (SQLERRM , 1 , 240));
1034: END IF;

Line 1031: FND_LOG.LEVEL_UNEXPECTED,

1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028:
1029: IF (l_uLog) THEN
1030: FND_LOG.STRING(
1031: FND_LOG.LEVEL_UNEXPECTED,
1032: l_module || '.' || l_stmt_num ,
1033: SUBSTRB (SQLERRM , 1 , 240));
1034: END IF;
1035:

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

1199: /* 2- PROCEDURE */
1200: /* 1- STATEMENT */
1201:
1202: /* In general, we should use the following:
1203: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

1200: /* 1- STATEMENT */
1201:
1202: /* In general, we should use the following:
1203: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1201:
1202: /* In general, we should use the following:
1203: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1202: /* In general, we should use the following:
1203: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */

Line 1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1203: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */
1211:

Line 1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1204: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */
1211:
1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1205: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1206: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1207: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */
1211:
1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1213: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

1208: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */
1211:
1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1213: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1214: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1215:
1216:

Line 1213: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1209: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1210: */
1211:
1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1213: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1214: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1215:
1216:
1217: /* Cursor to fetch all resources and their rates for a wip entity */

Line 1214: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1210: */
1211:
1212: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1213: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1214: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1215:
1216:
1217: /* Cursor to fetch all resources and their rates for a wip entity */
1218:

Line 1539: FND_LOG.STRING(

1535: BEGIN
1536:
1537: -- Procedure level log message for Entry point
1538: IF (l_pLog) THEN
1539: FND_LOG.STRING(
1540: FND_LOG.LEVEL_PROCEDURE,
1541: l_module || '.begin',
1542: 'Compute_PAC_JobEstimates <<');
1543: END IF;

Line 1540: FND_LOG.LEVEL_PROCEDURE,

1536:
1537: -- Procedure level log message for Entry point
1538: IF (l_pLog) THEN
1539: FND_LOG.STRING(
1540: FND_LOG.LEVEL_PROCEDURE,
1541: l_module || '.begin',
1542: 'Compute_PAC_JobEstimates <<');
1543: END IF;
1544:

Line 1626: FND_LOG.STRING(

1622: END IF;
1623:
1624: -- statement level logging
1625: IF (l_sLog) THEN
1626: FND_LOG.STRING(
1627: FND_LOG.LEVEL_STATEMENT,
1628: l_module || '.' || l_stmt_num,
1629: l_api_message);
1630: END IF;

Line 1627: FND_LOG.LEVEL_STATEMENT,

1623:
1624: -- statement level logging
1625: IF (l_sLog) THEN
1626: FND_LOG.STRING(
1627: FND_LOG.LEVEL_STATEMENT,
1628: l_module || '.' || l_stmt_num,
1629: l_api_message);
1630: END IF;
1631:

Line 1694: FND_LOG.STRING(

1690: END IF; -- check for l_dummy
1691:
1692: -- statement level logging
1693: IF (l_sLog) THEN
1694: FND_LOG.STRING(
1695: FND_LOG.LEVEL_STATEMENT,
1696: l_module || '.' || l_stmt_num,
1697: 'Period Details- l_acct_period_id: ' || TO_CHAR(l_acct_period_id)
1698: || ' l_period_set_name: '|| TO_CHAR(l_period_set_name)

Line 1695: FND_LOG.LEVEL_STATEMENT,

1691:
1692: -- statement level logging
1693: IF (l_sLog) THEN
1694: FND_LOG.STRING(
1695: FND_LOG.LEVEL_STATEMENT,
1696: l_module || '.' || l_stmt_num,
1697: 'Period Details- l_acct_period_id: ' || TO_CHAR(l_acct_period_id)
1698: || ' l_period_set_name: '|| TO_CHAR(l_period_set_name)
1699: || ' l_period_name: ' || TO_CHAR(l_period_name));

Line 2015: FND_LOG.STRING(

2011: l_stmt_num := 285;
2012:
2013: -- statement level logging
2014: IF (l_sLog) THEN
2015: FND_LOG.STRING(
2016: FND_LOG.LEVEL_STATEMENT,
2017: l_module || '.' || l_stmt_num,
2018: 'Resource Cost Calc completed successfully');
2019: END IF;

Line 2016: FND_LOG.LEVEL_STATEMENT,

2012:
2013: -- statement level logging
2014: IF (l_sLog) THEN
2015: FND_LOG.STRING(
2016: FND_LOG.LEVEL_STATEMENT,
2017: l_module || '.' || l_stmt_num,
2018: 'Resource Cost Calc completed successfully');
2019: END IF;
2020:

Line 2119: FND_LOG.STRING(

2115: l_api_message :=' Calling Insert_eamBalAcct... ';
2116: l_api_message :=l_api_message|| ' mfg_cost_element_id = l_mfg_cost_element_id,' ;
2117: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_account) || ',';
2118: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
2119: FND_LOG.STRING(
2120: FND_LOG.LEVEL_STATEMENT,
2121: l_module || '.' || l_stmt_num,
2122: l_api_message);
2123: END IF;

Line 2120: FND_LOG.LEVEL_STATEMENT,

2116: l_api_message :=l_api_message|| ' mfg_cost_element_id = l_mfg_cost_element_id,' ;
2117: l_api_message :=l_api_message|| ' account_id = ' || TO_CHAR(l_account) || ',';
2118: l_api_message :=l_api_message|| ' eam_cost_element_id = '||TO_CHAR(l_eam_cost_element);
2119: FND_LOG.STRING(
2120: FND_LOG.LEVEL_STATEMENT,
2121: l_module || '.' || l_stmt_num,
2122: l_api_message);
2123: END IF;
2124:

Line 2227: FND_LOG.STRING(

2223: l_stmt_num := 310;
2224:
2225: -- statement level logging
2226: IF (l_sLog) THEN
2227: FND_LOG.STRING(
2228: FND_LOG.LEVEL_STATEMENT,
2229: l_module || '.' || l_stmt_num,
2230: 'WRO Cost Calc completed successfully');
2231: END IF;

Line 2228: FND_LOG.LEVEL_STATEMENT,

2224:
2225: -- statement level logging
2226: IF (l_sLog) THEN
2227: FND_LOG.STRING(
2228: FND_LOG.LEVEL_STATEMENT,
2229: l_module || '.' || l_stmt_num,
2230: 'WRO Cost Calc completed successfully');
2231: END IF;
2232:

Line 2396: FND_LOG.STRING(

2392: l_stmt_num := 340;
2393:
2394: -- statement level logging
2395: IF (l_sLog) THEN
2396: FND_LOG.STRING(
2397: FND_LOG.LEVEL_STATEMENT,
2398: l_module || '.' || l_stmt_num,
2399: 'WRODI Cost Calc completed successfully');
2400: END IF;

Line 2397: FND_LOG.LEVEL_STATEMENT,

2393:
2394: -- statement level logging
2395: IF (l_sLog) THEN
2396: FND_LOG.STRING(
2397: FND_LOG.LEVEL_STATEMENT,
2398: l_module || '.' || l_stmt_num,
2399: 'WRODI Cost Calc completed successfully');
2400: END IF;
2401:

Line 2550: FND_LOG.STRING(

2546: l_stmt_num := 365;
2547:
2548: -- statement level logging
2549: IF (l_sLog) THEN
2550: FND_LOG.STRING(
2551: FND_LOG.LEVEL_STATEMENT,
2552: l_module || '.' || l_stmt_num,
2553: 'CST_PacEamCost_GRP.Compute_PAC_JobEstimatess(' || to_char(l_stmt_num)
2554: || '): WEDI Cost Calc completed successfully');

Line 2551: FND_LOG.LEVEL_STATEMENT,

2547:
2548: -- statement level logging
2549: IF (l_sLog) THEN
2550: FND_LOG.STRING(
2551: FND_LOG.LEVEL_STATEMENT,
2552: l_module || '.' || l_stmt_num,
2553: 'CST_PacEamCost_GRP.Compute_PAC_JobEstimatess(' || to_char(l_stmt_num)
2554: || '): WEDI Cost Calc completed successfully');
2555: END IF;

Line 2714: FND_LOG.STRING(

2710: l_stmt_num := 395;
2711:
2712: -- statement level logging
2713: IF (l_sLog) THEN
2714: FND_LOG.STRING(
2715: FND_LOG.LEVEL_STATEMENT,
2716: l_module || '.' || l_stmt_num,
2717: 'CST_PacEamCost_GRP.Compute_PAC_JobEstimatess(' || to_char(l_stmt_num)
2718: || '): PO/REQ Cost Calc completed successfully');

Line 2715: FND_LOG.LEVEL_STATEMENT,

2711:
2712: -- statement level logging
2713: IF (l_sLog) THEN
2714: FND_LOG.STRING(
2715: FND_LOG.LEVEL_STATEMENT,
2716: l_module || '.' || l_stmt_num,
2717: 'CST_PacEamCost_GRP.Compute_PAC_JobEstimatess(' || to_char(l_stmt_num)
2718: || '): PO/REQ Cost Calc completed successfully');
2719: END IF;

Line 2732: FND_LOG.STRING(

2728: p_data => x_msg_data );
2729:
2730: -- Procedure level log message for exit point
2731: IF (l_pLog) THEN
2732: FND_LOG.STRING(
2733: FND_LOG.LEVEL_PROCEDURE,
2734: l_module || '.end',
2735: 'Compute_PAC_JobEstimates >>'
2736: );

Line 2733: FND_LOG.LEVEL_PROCEDURE,

2729:
2730: -- Procedure level log message for exit point
2731: IF (l_pLog) THEN
2732: FND_LOG.STRING(
2733: FND_LOG.LEVEL_PROCEDURE,
2734: l_module || '.end',
2735: 'Compute_PAC_JobEstimates >>'
2736: );
2737: END IF;

Line 2747: FND_LOG.STRING(

2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744:
2745: -- statement level logging
2746: IF (l_uLog) THEN
2747: FND_LOG.STRING(
2748: FND_LOG.LEVEL_UNEXPECTED,
2749: l_module || '.' || l_stmt_num ,
2750: l_msg_data);
2751: END IF;

Line 2748: FND_LOG.LEVEL_UNEXPECTED,

2744:
2745: -- statement level logging
2746: IF (l_uLog) THEN
2747: FND_LOG.STRING(
2748: FND_LOG.LEVEL_UNEXPECTED,
2749: l_module || '.' || l_stmt_num ,
2750: l_msg_data);
2751: END IF;
2752:

Line 2763: FND_LOG.STRING(

2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2760:
2761: -- statement level logging
2762: IF (l_uLog) THEN
2763: FND_LOG.STRING(
2764: FND_LOG.LEVEL_UNEXPECTED,
2765: l_module || '.' || l_stmt_num ,
2766: l_msg_data);
2767: END IF;

Line 2764: FND_LOG.LEVEL_UNEXPECTED,

2760:
2761: -- statement level logging
2762: IF (l_uLog) THEN
2763: FND_LOG.STRING(
2764: FND_LOG.LEVEL_UNEXPECTED,
2765: l_module || '.' || l_stmt_num ,
2766: l_msg_data);
2767: END IF;
2768:

Line 2785: FND_LOG.STRING(

2781: || SUBSTRB (SQLERRM , 1 , 240));
2782: END IF;
2783:
2784: IF (l_uLog) THEN
2785: FND_LOG.STRING(
2786: FND_LOG.LEVEL_UNEXPECTED,
2787: l_module || '.' || l_stmt_num ,
2788: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
2789: END IF;

Line 2786: FND_LOG.LEVEL_UNEXPECTED,

2782: END IF;
2783:
2784: IF (l_uLog) THEN
2785: FND_LOG.STRING(
2786: FND_LOG.LEVEL_UNEXPECTED,
2787: l_module || '.' || l_stmt_num ,
2788: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
2789: END IF;
2790:

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

2934: /* 2- PROCEDURE */
2935: /* 1- STATEMENT */
2936:
2937: /* In general, we should use the following:
2938: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

2935: /* 1- STATEMENT */
2936:
2937: /* In general, we should use the following:
2938: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2936:
2937: /* In general, we should use the following:
2938: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

2937: /* In general, we should use the following:
2938: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */

Line 2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2938: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */
2946:

Line 2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2939: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */
2946:
2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2940: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2941: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2942: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */
2946:
2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2948: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

2943: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */
2946:
2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2948: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2949: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2950:
2951: BEGIN

Line 2948: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2944: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2945: */
2946:
2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2948: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2949: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2950:
2951: BEGIN
2952:

Line 2949: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2945: */
2946:
2947: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2948: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2949: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2950:
2951: BEGIN
2952:
2953: -- Procedure level log message for Entry point

Line 2955: FND_LOG.STRING(

2951: BEGIN
2952:
2953: -- Procedure level log message for Entry point
2954: IF (l_pLog) THEN
2955: FND_LOG.STRING(
2956: FND_LOG.LEVEL_PROCEDURE,
2957: l_module || '.begin',
2958: 'InsertUpdate_PAC_eamPerBal <<');
2959: END IF;

Line 2956: FND_LOG.LEVEL_PROCEDURE,

2952:
2953: -- Procedure level log message for Entry point
2954: IF (l_pLog) THEN
2955: FND_LOG.STRING(
2956: FND_LOG.LEVEL_PROCEDURE,
2957: l_module || '.begin',
2958: 'InsertUpdate_PAC_eamPerBal <<');
2959: END IF;
2960:

Line 3117: FND_LOG.STRING(

3113: l_stmt_num := 425;
3114:
3115: -- statement level logging
3116: IF (l_sLog) THEN
3117: FND_LOG.STRING(
3118: FND_LOG.LEVEL_STATEMENT,
3119: l_module || '.' || l_stmt_num,
3120: 'Update Successful for Job id: ' || TO_CHAR(p_wip_entity_id));
3121: END IF;

Line 3118: FND_LOG.LEVEL_STATEMENT,

3114:
3115: -- statement level logging
3116: IF (l_sLog) THEN
3117: FND_LOG.STRING(
3118: FND_LOG.LEVEL_STATEMENT,
3119: l_module || '.' || l_stmt_num,
3120: 'Update Successful for Job id: ' || TO_CHAR(p_wip_entity_id));
3121: END IF;
3122:

Line 3190: FND_LOG.STRING(

3186: l_stmt_num := 435;
3187:
3188: -- statement level logging
3189: IF (l_sLog) THEN
3190: FND_LOG.STRING(
3191: FND_LOG.LEVEL_STATEMENT,
3192: l_module || '.' || l_stmt_num,
3193: 'Insert Successful for Job id: ' || TO_CHAR(p_wip_entity_id));
3194: END IF;

Line 3191: FND_LOG.LEVEL_STATEMENT,

3187:
3188: -- statement level logging
3189: IF (l_sLog) THEN
3190: FND_LOG.STRING(
3191: FND_LOG.LEVEL_STATEMENT,
3192: l_module || '.' || l_stmt_num,
3193: 'Insert Successful for Job id: ' || TO_CHAR(p_wip_entity_id));
3194: END IF;
3195:

Line 3261: FND_LOG.STRING(

3257: p_data => x_msg_data );
3258:
3259: -- Procedure level log message for exit point
3260: IF (l_pLog) THEN
3261: FND_LOG.STRING(
3262: FND_LOG.LEVEL_PROCEDURE,
3263: l_module || '.end',
3264: 'InsertUpdate_PAC_eamPerBal >>'
3265: );

Line 3262: FND_LOG.LEVEL_PROCEDURE,

3258:
3259: -- Procedure level log message for exit point
3260: IF (l_pLog) THEN
3261: FND_LOG.STRING(
3262: FND_LOG.LEVEL_PROCEDURE,
3263: l_module || '.end',
3264: 'InsertUpdate_PAC_eamPerBal >>'
3265: );
3266: END IF;

Line 3275: FND_LOG.STRING(

3271: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3272: x_return_status := FND_API.G_RET_STS_ERROR;
3273:
3274: IF (l_uLog) THEN
3275: FND_LOG.STRING(
3276: FND_LOG.LEVEL_UNEXPECTED,
3277: l_module || '.' || l_stmt_num ,
3278: l_msg_data);
3279: END IF;

Line 3276: FND_LOG.LEVEL_UNEXPECTED,

3272: x_return_status := FND_API.G_RET_STS_ERROR;
3273:
3274: IF (l_uLog) THEN
3275: FND_LOG.STRING(
3276: FND_LOG.LEVEL_UNEXPECTED,
3277: l_module || '.' || l_stmt_num ,
3278: l_msg_data);
3279: END IF;
3280:

Line 3290: FND_LOG.STRING(

3286: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3287: x_return_status := FND_API.g_ret_sts_unexp_error ;
3288:
3289: IF (l_uLog) THEN
3290: FND_LOG.STRING(
3291: FND_LOG.LEVEL_UNEXPECTED,
3292: l_module || '.' || l_stmt_num ,
3293: l_msg_data);
3294: END IF;

Line 3291: FND_LOG.LEVEL_UNEXPECTED,

3287: x_return_status := FND_API.g_ret_sts_unexp_error ;
3288:
3289: IF (l_uLog) THEN
3290: FND_LOG.STRING(
3291: FND_LOG.LEVEL_UNEXPECTED,
3292: l_module || '.' || l_stmt_num ,
3293: l_msg_data);
3294: END IF;
3295:

Line 3312: FND_LOG.STRING(

3308: || SUBSTRB (SQLERRM , 1 , 240));
3309: END IF;
3310:
3311: IF (l_uLog) THEN
3312: FND_LOG.STRING(
3313: FND_LOG.LEVEL_UNEXPECTED,
3314: l_module || '.' || l_stmt_num ,
3315: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3316: END IF;

Line 3313: FND_LOG.LEVEL_UNEXPECTED,

3309: END IF;
3310:
3311: IF (l_uLog) THEN
3312: FND_LOG.STRING(
3313: FND_LOG.LEVEL_UNEXPECTED,
3314: l_module || '.' || l_stmt_num ,
3315: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3316: END IF;
3317:

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

3423: /* 2- PROCEDURE */
3424: /* 1- STATEMENT */
3425:
3426: /* In general, we should use the following:
3427: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

3424: /* 1- STATEMENT */
3425:
3426: /* In general, we should use the following:
3427: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3425:
3426: /* In general, we should use the following:
3427: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

3426: /* In general, we should use the following:
3427: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */

Line 3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

3427: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */
3435:

Line 3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3428: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */
3435:
3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3429: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3430: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3431: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */
3435:
3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3437: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

3432: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */
3435:
3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3437: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3438: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3439:
3440: BEGIN

Line 3437: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3433: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3434: */
3435:
3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3437: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3438: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3439:
3440: BEGIN
3441:

Line 3438: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3434: */
3435:
3436: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3437: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3438: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3439:
3440: BEGIN
3441:
3442: -- Procedure level log message for Entry point

Line 3444: FND_LOG.STRING(

3440: BEGIN
3441:
3442: -- Procedure level log message for Entry point
3443: IF (l_pLog) THEN
3444: FND_LOG.STRING(
3445: FND_LOG.LEVEL_PROCEDURE,
3446: l_module || '.begin',
3447: 'InsertUpdate_PAC_assetPerBal <<');
3448: END IF;

Line 3445: FND_LOG.LEVEL_PROCEDURE,

3441:
3442: -- Procedure level log message for Entry point
3443: IF (l_pLog) THEN
3444: FND_LOG.STRING(
3445: FND_LOG.LEVEL_PROCEDURE,
3446: l_module || '.begin',
3447: 'InsertUpdate_PAC_assetPerBal <<');
3448: END IF;
3449:

Line 3512: FND_LOG.STRING(

3508: l_stmt_num := 510;
3509:
3510: -- statement level logging
3511: IF (l_sLog) THEN
3512: FND_LOG.STRING(
3513: FND_LOG.LEVEL_STATEMENT,
3514: l_module || '.' || l_stmt_num,
3515: 'Update Successful for Serial Number ' || TO_CHAR(p_asset_number));
3516: END IF;

Line 3513: FND_LOG.LEVEL_STATEMENT,

3509:
3510: -- statement level logging
3511: IF (l_sLog) THEN
3512: FND_LOG.STRING(
3513: FND_LOG.LEVEL_STATEMENT,
3514: l_module || '.' || l_stmt_num,
3515: 'Update Successful for Serial Number ' || TO_CHAR(p_asset_number));
3516: END IF;
3517:

Line 3581: FND_LOG.STRING(

3577: l_stmt_num := 520;
3578:
3579: -- statement level logging
3580: IF (l_sLog) THEN
3581: FND_LOG.STRING(
3582: FND_LOG.LEVEL_STATEMENT,
3583: l_module || '.' || l_stmt_num,
3584: 'Insert Successful for Serial Number ' || TO_CHAR(p_asset_number));
3585: END IF;

Line 3582: FND_LOG.LEVEL_STATEMENT,

3578:
3579: -- statement level logging
3580: IF (l_sLog) THEN
3581: FND_LOG.STRING(
3582: FND_LOG.LEVEL_STATEMENT,
3583: l_module || '.' || l_stmt_num,
3584: 'Insert Successful for Serial Number ' || TO_CHAR(p_asset_number));
3585: END IF;
3586:

Line 3602: FND_LOG.STRING(

3598: p_data => x_msg_data );
3599:
3600: -- Procedure level log message for exit point
3601: IF (l_pLog) THEN
3602: FND_LOG.STRING(
3603: FND_LOG.LEVEL_PROCEDURE,
3604: l_module || '.end',
3605: 'InsertUpdate_PAC_assetPerBal >>'
3606: );

Line 3603: FND_LOG.LEVEL_PROCEDURE,

3599:
3600: -- Procedure level log message for exit point
3601: IF (l_pLog) THEN
3602: FND_LOG.STRING(
3603: FND_LOG.LEVEL_PROCEDURE,
3604: l_module || '.end',
3605: 'InsertUpdate_PAC_assetPerBal >>'
3606: );
3607: END IF;

Line 3616: FND_LOG.STRING(

3612: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614:
3615: IF (l_uLog) THEN
3616: FND_LOG.STRING(
3617: FND_LOG.LEVEL_UNEXPECTED,
3618: l_module || '.' || l_stmt_num ,
3619: l_msg_data);
3620: END IF;

Line 3617: FND_LOG.LEVEL_UNEXPECTED,

3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614:
3615: IF (l_uLog) THEN
3616: FND_LOG.STRING(
3617: FND_LOG.LEVEL_UNEXPECTED,
3618: l_module || '.' || l_stmt_num ,
3619: l_msg_data);
3620: END IF;
3621:

Line 3631: FND_LOG.STRING(

3627: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3629:
3630: IF (l_uLog) THEN
3631: FND_LOG.STRING(
3632: FND_LOG.LEVEL_UNEXPECTED,
3633: l_module || '.' || l_stmt_num ,
3634: l_msg_data);
3635: END IF;

Line 3632: FND_LOG.LEVEL_UNEXPECTED,

3628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3629:
3630: IF (l_uLog) THEN
3631: FND_LOG.STRING(
3632: FND_LOG.LEVEL_UNEXPECTED,
3633: l_module || '.' || l_stmt_num ,
3634: l_msg_data);
3635: END IF;
3636:

Line 3654: FND_LOG.STRING(

3650:
3651: END IF;
3652:
3653: IF (l_uLog) THEN
3654: FND_LOG.STRING(
3655: FND_LOG.LEVEL_UNEXPECTED,
3656: l_module || '.' || l_stmt_num ,
3657: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3658: END IF;

Line 3655: FND_LOG.LEVEL_UNEXPECTED,

3651: END IF;
3652:
3653: IF (l_uLog) THEN
3654: FND_LOG.STRING(
3655: FND_LOG.LEVEL_UNEXPECTED,
3656: l_module || '.' || l_stmt_num ,
3657: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
3658: END IF;
3659:

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

3778: /* 2- PROCEDURE */
3779: /* 1- STATEMENT */
3780:
3781: /* In general, we should use the following:
3782: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

3779: /* 1- STATEMENT */
3780:
3781: /* In general, we should use the following:
3782: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3780:
3781: /* In general, we should use the following:
3782: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

3781: /* In general, we should use the following:
3782: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */

Line 3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

3782: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */
3790:

Line 3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3783: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */
3790:
3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3784: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3785: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3786: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */
3790:
3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

3787: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */
3790:
3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3793: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3794:
3795: BEGIN

Line 3792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3788: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3789: */
3790:
3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3793: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3794:
3795: BEGIN
3796:

Line 3793: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3789: */
3790:
3791: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3793: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3794:
3795: BEGIN
3796:
3797: -- Procedure level log message for Entry point

Line 3799: FND_LOG.STRING(

3795: BEGIN
3796:
3797: -- Procedure level log message for Entry point
3798: IF (l_pLog) THEN
3799: FND_LOG.STRING(
3800: FND_LOG.LEVEL_PROCEDURE,
3801: l_module || '.begin',
3802: 'Compute_PAC_JobActuals <<');
3803: END IF;

Line 3800: FND_LOG.LEVEL_PROCEDURE,

3796:
3797: -- Procedure level log message for Entry point
3798: IF (l_pLog) THEN
3799: FND_LOG.STRING(
3800: FND_LOG.LEVEL_PROCEDURE,
3801: l_module || '.begin',
3802: 'Compute_PAC_JobActuals <<');
3803: END IF;
3804:

Line 3837: FND_LOG.STRING(

3833: WHERE cpp.pac_period_id = p_pac_period_id;
3834:
3835: -- statement level logging
3836: IF (l_sLog) THEN
3837: FND_LOG.STRING(
3838: FND_LOG.LEVEL_STATEMENT,
3839: l_module || '.' || l_stmt_num,
3840: 'Period details retreived');
3841: END IF;

Line 3838: FND_LOG.LEVEL_STATEMENT,

3834:
3835: -- statement level logging
3836: IF (l_sLog) THEN
3837: FND_LOG.STRING(
3838: FND_LOG.LEVEL_STATEMENT,
3839: l_module || '.' || l_stmt_num,
3840: 'Period details retreived');
3841: END IF;
3842:

Line 3881: FND_LOG.STRING(

3877: END IF;
3878:
3879: -- statement level logging
3880: IF (l_sLog) THEN
3881: FND_LOG.STRING(
3882: FND_LOG.LEVEL_STATEMENT,
3883: l_module || '.' || l_stmt_num,
3884: 'Got associated Asset Item');
3885: END IF;

Line 3882: FND_LOG.LEVEL_STATEMENT,

3878:
3879: -- statement level logging
3880: IF (l_sLog) THEN
3881: FND_LOG.STRING(
3882: FND_LOG.LEVEL_STATEMENT,
3883: l_module || '.' || l_stmt_num,
3884: 'Got associated Asset Item');
3885: END IF;
3886:

Line 3900: FND_LOG.STRING(

3896: IF (p_txn_mode = 17 ) then -- For Direct Item txns
3897:
3898: -- statement level logging
3899: IF (l_sLog) THEN
3900: FND_LOG.STRING(
3901: FND_LOG.LEVEL_STATEMENT,
3902: l_module || '.' || l_stmt_num,
3903: 'Processing for Direct Item');
3904: END IF;

Line 3901: FND_LOG.LEVEL_STATEMENT,

3897:
3898: -- statement level logging
3899: IF (l_sLog) THEN
3900: FND_LOG.STRING(
3901: FND_LOG.LEVEL_STATEMENT,
3902: l_module || '.' || l_stmt_num,
3903: 'Processing for Direct Item');
3904: END IF;
3905:

Line 3958: FND_LOG.STRING(

3954: END IF;
3955:
3956: -- statement level logging
3957: IF (l_sLog) THEN
3958: FND_LOG.STRING(
3959: FND_LOG.LEVEL_STATEMENT,
3960: l_module || '.' || l_stmt_num,
3961: 'Maint cost cat and cost element got for Direct Item');
3962: END IF;

Line 3959: FND_LOG.LEVEL_STATEMENT,

3955:
3956: -- statement level logging
3957: IF (l_sLog) THEN
3958: FND_LOG.STRING(
3959: FND_LOG.LEVEL_STATEMENT,
3960: l_module || '.' || l_stmt_num,
3961: 'Maint cost cat and cost element got for Direct Item');
3962: END IF;
3963:

Line 3968: FND_LOG.STRING(

3964: ELSE -- Not a direct Item
3965:
3966: -- statement level logging
3967: IF (l_sLog) THEN
3968: FND_LOG.STRING(
3969: FND_LOG.LEVEL_STATEMENT,
3970: l_module || '.' || l_stmt_num,
3971: 'Not a Direct Item');
3972: END IF;

Line 3969: FND_LOG.LEVEL_STATEMENT,

3965:
3966: -- statement level logging
3967: IF (l_sLog) THEN
3968: FND_LOG.STRING(
3969: FND_LOG.LEVEL_STATEMENT,
3970: l_module || '.' || l_stmt_num,
3971: 'Not a Direct Item');
3972: END IF;
3973:

Line 4016: FND_LOG.STRING(

4012: END IF;
4013:
4014: -- statement level logging
4015: IF (l_sLog) THEN
4016: FND_LOG.STRING(
4017: FND_LOG.LEVEL_STATEMENT,
4018: l_module || '.' || l_stmt_num,
4019: 'Got Maint cost cat and cost element values');
4020: END IF;

Line 4017: FND_LOG.LEVEL_STATEMENT,

4013:
4014: -- statement level logging
4015: IF (l_sLog) THEN
4016: FND_LOG.STRING(
4017: FND_LOG.LEVEL_STATEMENT,
4018: l_module || '.' || l_stmt_num,
4019: 'Got Maint cost cat and cost element values');
4020: END IF;
4021:

Line 4068: FND_LOG.STRING(

4064: END IF;
4065:
4066: -- statement level logging
4067: IF (l_sLog) THEN
4068: FND_LOG.STRING(
4069: FND_LOG.LEVEL_STATEMENT,
4070: l_module || '.' || l_stmt_num,
4071: 'Insert/Update successful for Actuals');
4072: END IF;

Line 4069: FND_LOG.LEVEL_STATEMENT,

4065:
4066: -- statement level logging
4067: IF (l_sLog) THEN
4068: FND_LOG.STRING(
4069: FND_LOG.LEVEL_STATEMENT,
4070: l_module || '.' || l_stmt_num,
4071: 'Insert/Update successful for Actuals');
4072: END IF;
4073:

Line 4085: FND_LOG.STRING(

4081: p_data => x_msg_data );
4082:
4083: -- Procedure level log message for exit point
4084: IF (l_pLog) THEN
4085: FND_LOG.STRING(
4086: FND_LOG.LEVEL_PROCEDURE,
4087: l_module || '.end',
4088: 'Compute_PAC_JobActuals >>'
4089: );

Line 4086: FND_LOG.LEVEL_PROCEDURE,

4082:
4083: -- Procedure level log message for exit point
4084: IF (l_pLog) THEN
4085: FND_LOG.STRING(
4086: FND_LOG.LEVEL_PROCEDURE,
4087: l_module || '.end',
4088: 'Compute_PAC_JobActuals >>'
4089: );
4090: END IF;

Line 4099: FND_LOG.STRING(

4095: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4096: x_return_status := FND_API.G_RET_STS_ERROR;
4097:
4098: IF (l_uLog) THEN
4099: FND_LOG.STRING(
4100: FND_LOG.LEVEL_UNEXPECTED,
4101: l_module || '.' || l_stmt_num ,
4102: l_msg_data);
4103: END IF;

Line 4100: FND_LOG.LEVEL_UNEXPECTED,

4096: x_return_status := FND_API.G_RET_STS_ERROR;
4097:
4098: IF (l_uLog) THEN
4099: FND_LOG.STRING(
4100: FND_LOG.LEVEL_UNEXPECTED,
4101: l_module || '.' || l_stmt_num ,
4102: l_msg_data);
4103: END IF;
4104:

Line 4114: FND_LOG.STRING(

4110: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4112:
4113: IF (l_uLog) THEN
4114: FND_LOG.STRING(
4115: FND_LOG.LEVEL_UNEXPECTED,
4116: l_module || '.' || l_stmt_num ,
4117: l_msg_data);
4118: END IF;

Line 4115: FND_LOG.LEVEL_UNEXPECTED,

4111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4112:
4113: IF (l_uLog) THEN
4114: FND_LOG.STRING(
4115: FND_LOG.LEVEL_UNEXPECTED,
4116: l_module || '.' || l_stmt_num ,
4117: l_msg_data);
4118: END IF;
4119:

Line 4136: FND_LOG.STRING(

4132: || SUBSTRB (SQLERRM , 1 , 240));
4133: END IF;
4134:
4135: IF (l_uLog) THEN
4136: FND_LOG.STRING(
4137: FND_LOG.LEVEL_UNEXPECTED,
4138: l_module || '.' || l_stmt_num ,
4139: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
4140: END IF;

Line 4137: FND_LOG.LEVEL_UNEXPECTED,

4133: END IF;
4134:
4135: IF (l_uLog) THEN
4136: FND_LOG.STRING(
4137: FND_LOG.LEVEL_UNEXPECTED,
4138: l_module || '.' || l_stmt_num ,
4139: l_msg_data || SUBSTRB (SQLERRM , 1 , 240));
4140: END IF;
4141:

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

4244: /* 2- PROCEDURE */
4245: /* 1- STATEMENT */
4246:
4247: /* In general, we should use the following:
4248: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

4245: /* 1- STATEMENT */
4246:
4247: /* In general, we should use the following:
4248: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

4246:
4247: /* In general, we should use the following:
4248: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

4247: /* In general, we should use the following:
4248: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */

Line 4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

4248: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */
4256:

Line 4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4249: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */
4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND

Line 4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

4250: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
4251: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
4252: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */
4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

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

4253: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */
4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4259: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4260: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4261:

Line 4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

4254: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4255: */
4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4259: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4260: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4261:
4262: l_cnt_cebba NUMBER;

Line 4259: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4255: */
4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4259: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4260: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4261:
4262: l_cnt_cebba NUMBER;
4263: l_stmt_num NUMBER;

Line 4260: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

4256:
4257: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4258: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4259: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4260: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4261:
4262: l_cnt_cebba NUMBER;
4263: l_stmt_num NUMBER;
4264:

Line 4270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4266: -- Standard Start of API savepoint
4267: SAVEPOINT Insert_PAC_eamBalAcct_PUB;
4268:
4269: if( l_pLog ) then
4270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4271: l_module || '.begin',
4272: 'Start of ' || l_full_name || '(' ||
4273: 'p_user_id=' || p_user_id || ',' ||
4274: 'p_login_id=' || p_login_id ||',' ||

Line 4396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4392: p_login_id
4393: );
4394:
4395: if( l_sLog ) then
4396: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4397: l_module || '.' || to_char(l_stmt_num),
4398: '.updated/inserted the record for :' || to_char(p_wip_entity_id)
4399: );
4400: end if;

Line 4410: FND_LOG.STRING(

4406:
4407:
4408: /* Procedure level log message for Exit point */
4409: IF (l_pLog) THEN
4410: FND_LOG.STRING(
4411: FND_LOG.LEVEL_PROCEDURE,
4412: l_module || '.end',
4413: 'End of ' || l_full_name
4414: );

Line 4411: FND_LOG.LEVEL_PROCEDURE,

4407:
4408: /* Procedure level log message for Exit point */
4409: IF (l_pLog) THEN
4410: FND_LOG.STRING(
4411: FND_LOG.LEVEL_PROCEDURE,
4412: l_module || '.end',
4413: 'End of ' || l_full_name
4414: );
4415: END IF;

Line 4429: FND_LOG.STRING(

4425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4426: ROLLBACK TO Insert_PAC_eamBalAcct_PUB;
4427:
4428: IF (l_uLog) THEN
4429: FND_LOG.STRING(
4430: FND_LOG.LEVEL_UNEXPECTED,
4431: l_module || '.' || l_stmt_num,
4432: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4433: );

Line 4430: FND_LOG.LEVEL_UNEXPECTED,

4426: ROLLBACK TO Insert_PAC_eamBalAcct_PUB;
4427:
4428: IF (l_uLog) THEN
4429: FND_LOG.STRING(
4430: FND_LOG.LEVEL_UNEXPECTED,
4431: l_module || '.' || l_stmt_num,
4432: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4433: );
4434: END IF;

Line 4446: FND_LOG.STRING(

4442: ROLLBACK TO Insert_PAC_eamBalAcct_PUB;
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4444:
4445: IF (l_uLog) THEN
4446: FND_LOG.STRING(
4447: FND_LOG.LEVEL_UNEXPECTED,
4448: l_module || '.' || l_stmt_num,
4449: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4450: );

Line 4447: FND_LOG.LEVEL_UNEXPECTED,

4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4444:
4445: IF (l_uLog) THEN
4446: FND_LOG.STRING(
4447: FND_LOG.LEVEL_UNEXPECTED,
4448: l_module || '.' || l_stmt_num,
4449: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4450: );
4451: END IF;

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

4513:
4514: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4515: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
4516:
4517: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4518: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4519: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4520:
4521: l_stmt_num NUMBER;

Line 4518: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

4514: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
4515: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
4516:
4517: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4518: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4519: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4520:
4521: l_stmt_num NUMBER;
4522: BEGIN

Line 4519: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

4515: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
4516:
4517: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND
4518: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
4519: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4520:
4521: l_stmt_num NUMBER;
4522: BEGIN
4523: -- Standard Start of API savepoint

Line 4539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4535: FND_MSG_PUB.initialize;
4536: END IF;
4537:
4538: if( l_pLog ) then
4539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4540: l_module || '.begin',
4541: 'Start of ' || l_full_name);
4542: end if;
4543:

Line 4566: FND_LOG.STRING(

4562: END IF;
4563:
4564: /* Procedure level log message for Exit point */
4565: IF (l_pLog) THEN
4566: FND_LOG.STRING(
4567: FND_LOG.LEVEL_PROCEDURE,
4568: l_module || '.end',
4569: 'End of ' || l_full_name
4570: );

Line 4567: FND_LOG.LEVEL_PROCEDURE,

4563:
4564: /* Procedure level log message for Exit point */
4565: IF (l_pLog) THEN
4566: FND_LOG.STRING(
4567: FND_LOG.LEVEL_PROCEDURE,
4568: l_module || '.end',
4569: 'End of ' || l_full_name
4570: );
4571: END IF;

Line 4586: FND_LOG.STRING(

4582: ROLLBACK TO Delete_PAC_eamBalAcct_PUB;
4583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4584:
4585: IF (l_uLog) THEN
4586: FND_LOG.STRING(
4587: FND_LOG.LEVEL_UNEXPECTED,
4588: l_module || '.' || l_stmt_num,
4589: l_full_name ||'('|| l_stmt_num ||') :' ||
4590: SUBSTRB (SQLERRM , 1 , 240));

Line 4587: FND_LOG.LEVEL_UNEXPECTED,

4583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4584:
4585: IF (l_uLog) THEN
4586: FND_LOG.STRING(
4587: FND_LOG.LEVEL_UNEXPECTED,
4588: l_module || '.' || l_stmt_num,
4589: l_full_name ||'('|| l_stmt_num ||') :' ||
4590: SUBSTRB (SQLERRM , 1 , 240));
4591: END IF;

Line 4602: FND_LOG.STRING(

4598: ROLLBACK TO Delete_PAC_eamBalAcct_PUB;
4599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4600:
4601: IF (l_uLog) THEN
4602: FND_LOG.STRING(
4603: FND_LOG.LEVEL_UNEXPECTED,
4604: l_module || '.' || l_stmt_num,
4605: l_full_name ||'('|| l_stmt_num ||') :' ||
4606: SUBSTRB (SQLERRM , 1 , 240));

Line 4603: FND_LOG.LEVEL_UNEXPECTED,

4599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4600:
4601: IF (l_uLog) THEN
4602: FND_LOG.STRING(
4603: FND_LOG.LEVEL_UNEXPECTED,
4604: l_module || '.' || l_stmt_num,
4605: l_full_name ||'('|| l_stmt_num ||') :' ||
4606: SUBSTRB (SQLERRM , 1 , 240));
4607: END IF;