DBA Data[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on FND_LOG

Line 52: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;

48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE
49: );
50:
51: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';
52: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
53: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
54: g_debug_devel INT;
55:
56: --==========================================================================

Line 53: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;

49: );
50:
51: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';
52: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
53: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
54: g_debug_devel INT;
55:
56: --==========================================================================
57: -- PROCEDURE NAME:

Line 103: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )

99: )
100: IS
101: BEGIN
102: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
103: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
104: THEN
105: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
106: , MODULE => p_module
107: , MESSAGE => p_message

Line 105: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT

101: BEGIN
102: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
103: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
104: THEN
105: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
106: , MODULE => p_module
107: , MESSAGE => p_message
108: );
109: END IF;

Line 221: FND_LOG.STRING(G_PROC_LEVEL

217: BEGIN
218:
219: IF( G_PROC_LEVEL >= g_debug_devel )
220: THEN
221: FND_LOG.STRING(G_PROC_LEVEL
222: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
223: ,'Enter procedure');
224: END IF; --( G_PROC_LEVEL >= g_debug_devel )
225:

Line 628: FND_LOG.STRING(G_PROC_LEVEL

624: END IF; --l_row_count = 0
625:
626: IF( G_PROC_LEVEL >= g_debug_devel )
627: THEN
628: FND_LOG.STRING(G_PROC_LEVEL
629: ,G_MODULE_PREFIX||l_procedure_name||'.end'
630: ,'End procedure');
631: END IF; --( G_PROC_LEVEL >= g_debug_devel)
632: EXCEPTION

Line 634: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)

630: ,'End procedure');
631: END IF; --( G_PROC_LEVEL >= g_debug_devel)
632: EXCEPTION
633: WHEN l_period_wrong THEN
634: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
635: THEN
636: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
637: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
638: , 'The input period is invalid.');

Line 636: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

632: EXCEPTION
633: WHEN l_period_wrong THEN
634: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
635: THEN
636: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
637: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
638: , 'The input period is invalid.');
639: END IF;
640: RAISE;

Line 643: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)

639: END IF;
640: RAISE;
641:
642: WHEN OTHERS THEN
643: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
644: THEN
645: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
646: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
647: , SQLCODE||SQLERRM);

Line 645: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

641:
642: WHEN OTHERS THEN
643: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
644: THEN
645: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
646: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
647: , SQLCODE||SQLERRM);
648: END IF;
649: RAISE;

Line 681: FND_LOG.STRING(G_PROC_LEVEL

677: l_procedure_name VARCHAR2(20):='update_balance';
678: BEGIN
679: IF( G_PROC_LEVEL >= g_debug_devel )
680: THEN
681: FND_LOG.STRING(G_PROC_LEVEL
682: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
683: ,'Begin procedure');
684: END IF; --( G_PROC_LEVEL >= g_debug_devel)
685:

Line 931: FND_LOG.STRING(G_PROC_LEVEL

927: END IF;--p_current_period_flag='Y'
928:
929: IF( G_PROC_LEVEL >= g_debug_devel )
930: THEN
931: FND_LOG.STRING(G_PROC_LEVEL
932: ,G_MODULE_PREFIX||l_procedure_name||'.end'
933: ,'End procedure');
934: END IF; --( G_PROC_LEVEL >= g_debug_devel)
935: EXCEPTION

Line 937: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)

933: ,'End procedure');
934: END IF; --( G_PROC_LEVEL >= g_debug_devel)
935: EXCEPTION
936: WHEN OTHERS THEN
937: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
938: THEN
939: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
940: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
941: , SQLCODE||SQLERRM);

Line 939: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

935: EXCEPTION
936: WHEN OTHERS THEN
937: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
938: THEN
939: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
940: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
941: , SQLCODE||SQLERRM);
942: END IF;
943: RAISE;

Line 993: FND_LOG.STRING(G_PROC_LEVEL

989:
990: BEGIN
991: IF( G_PROC_LEVEL >= g_debug_devel )
992: THEN
993: FND_LOG.STRING(G_PROC_LEVEL
994: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
995: ,'Begin procedure');
996: END IF; --( G_PROC_LEVEL >= g_debug_devel)
997:

Line 1744: FND_LOG.STRING(G_PROC_LEVEL

1740: WHERE jca.account_segment = ffvc.flex_value*/
1741:
1742: IF( G_PROC_LEVEL >= g_debug_devel )
1743: THEN
1744: FND_LOG.STRING(G_PROC_LEVEL
1745: ,G_MODULE_PREFIX||l_procedure_name||'.end'
1746: ,'End procedure');
1747: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1748: EXCEPTION

Line 1750: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)

1746: ,'End procedure');
1747: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
1751: THEN
1752: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1753: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1754: , SQLCODE||SQLERRM);

Line 1752: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
1751: THEN
1752: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1753: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1754: , SQLCODE||SQLERRM);
1755: END IF;
1756: RAISE;

Line 1889: FND_LOG.STRING(G_PROC_LEVEL

1885:
1886: BEGIN
1887: IF( G_PROC_LEVEL >= g_debug_devel )
1888: THEN
1889: FND_LOG.STRING(G_PROC_LEVEL
1890: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
1891: ,'Begin procedure');
1892: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1893:

Line 2066: FND_LOG.STRING(G_PROC_LEVEL

2062: );
2063:
2064: IF( G_PROC_LEVEL >= g_debug_devel )
2065: THEN
2066: FND_LOG.STRING(G_PROC_LEVEL
2067: ,G_MODULE_PREFIX||l_procedure_name||'.end'
2068: ,'End procedure');
2069: END IF; --( G_PROC_LEVEL >= g_debug_devel)
2070: EXCEPTION

Line 2072: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)

2068: ,'End procedure');
2069: END IF; --( G_PROC_LEVEL >= g_debug_devel)
2070: EXCEPTION
2071: WHEN OTHERS THEN
2072: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
2073: THEN
2074: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2075: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
2076: , SQLCODE||SQLERRM);

Line 2074: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2070: EXCEPTION
2071: WHEN OTHERS THEN
2072: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
2073: THEN
2074: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2075: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
2076: , SQLCODE||SQLERRM);
2077: END IF;
2078: RAISE;

Line 2082: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;

2078: RAISE;
2079: END post_journal_itemized;
2080:
2081: BEGIN
2082: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;
2083:
2084: END JA_CN_POST_UTILITY_PKG;