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.JA_CN_POST_UTILITY_PKG dependencies on FND_LOG

Line 89: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;

85: , segment30 ja_cn_account_balances.SEGMENT30 %TYPE
86: );
87:
88: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';
89: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
90: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
91: g_debug_devel INT;
92:
93: --==========================================================================

Line 90: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;

86: );
87:
88: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';
89: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;
90: G_STATEMENT_LEVEL INT :=fnd_log.LEVEL_STATEMENT;
91: g_debug_devel INT;
92:
93: --==========================================================================
94: -- PROCEDURE NAME:

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

136: )
137: IS
138: BEGIN
139: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
140: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
141: THEN
142: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
143: , MODULE => p_module
144: , MESSAGE => p_message

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

138: BEGIN
139: --fnd_file.PUT_LINE(fnd_file.LOG,p_module||':'||p_message);
140: IF( fnd_log.LEVEL_STATEMENT >= g_debug_devel )
141: THEN
142: fnd_log.STRING( LOG_LEVEL => fnd_log.LEVEL_STATEMENT
143: , MODULE => p_module
144: , MESSAGE => p_message
145: );
146: END IF;

Line 258: FND_LOG.STRING(G_PROC_LEVEL

254: BEGIN
255:
256: IF( G_PROC_LEVEL >= g_debug_devel )
257: THEN
258: FND_LOG.STRING(G_PROC_LEVEL
259: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
260: ,'Enter procedure');
261: END IF; --( G_PROC_LEVEL >= g_debug_devel )
262:

Line 725: FND_LOG.STRING(G_PROC_LEVEL

721: END IF; --l_row_count = 0
722:
723: IF( G_PROC_LEVEL >= g_debug_devel )
724: THEN
725: FND_LOG.STRING(G_PROC_LEVEL
726: ,G_MODULE_PREFIX||l_procedure_name||'.end'
727: ,'End procedure');
728: END IF; --( G_PROC_LEVEL >= g_debug_devel)
729: EXCEPTION

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

727: ,'End procedure');
728: END IF; --( G_PROC_LEVEL >= g_debug_devel)
729: EXCEPTION
730: WHEN l_period_wrong THEN
731: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
732: THEN
733: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
734: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
735: , 'The input period is invalid.');

Line 733: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

729: EXCEPTION
730: WHEN l_period_wrong THEN
731: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
732: THEN
733: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
734: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
735: , 'The input period is invalid.');
736: END IF;
737: RAISE;

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

736: END IF;
737: RAISE;
738:
739: WHEN OTHERS THEN
740: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
741: THEN
742: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
743: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
744: , SQLCODE||SQLERRM);

Line 742: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

738:
739: WHEN OTHERS THEN
740: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
741: THEN
742: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
743: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
744: , SQLCODE||SQLERRM);
745: END IF;
746: RAISE;

Line 781: FND_LOG.STRING(G_PROC_LEVEL

777: l_procedure_name VARCHAR2(20):='update_balance';
778: BEGIN
779: IF( G_PROC_LEVEL >= g_debug_devel )
780: THEN
781: FND_LOG.STRING(G_PROC_LEVEL
782: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
783: ,'Begin procedure');
784: END IF; --( G_PROC_LEVEL >= g_debug_devel)
785:

Line 1275: FND_LOG.STRING(G_PROC_LEVEL

1271: END IF;--p_current_period_flag='Y'
1272:
1273: IF( G_PROC_LEVEL >= g_debug_devel )
1274: THEN
1275: FND_LOG.STRING(G_PROC_LEVEL
1276: ,G_MODULE_PREFIX||l_procedure_name||'.end'
1277: ,'End procedure');
1278: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1279: EXCEPTION

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

1277: ,'End procedure');
1278: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
1282: THEN
1283: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1284: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1285: , SQLCODE||SQLERRM);

Line 1283: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
1282: THEN
1283: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1284: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1285: , SQLCODE||SQLERRM);
1286: END IF;
1287: RAISE;

Line 1341: FND_LOG.STRING(G_PROC_LEVEL

1337:
1338: BEGIN
1339: IF( G_PROC_LEVEL >= g_debug_devel )
1340: THEN
1341: FND_LOG.STRING(G_PROC_LEVEL
1342: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
1343: ,'Begin procedure');
1344: END IF; --( G_PROC_LEVEL >= g_debug_devel)
1345:

Line 2691: FND_LOG.STRING(G_PROC_LEVEL

2687: WHERE jca.account_segment = ffvc.flex_value*/
2688:
2689: IF( G_PROC_LEVEL >= g_debug_devel )
2690: THEN
2691: FND_LOG.STRING(G_PROC_LEVEL
2692: ,G_MODULE_PREFIX||l_procedure_name||'.end'
2693: ,'End procedure');
2694: END IF; --( G_PROC_LEVEL >= g_debug_devel)
2695: EXCEPTION

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

2693: ,'End procedure');
2694: END IF; --( G_PROC_LEVEL >= g_debug_devel)
2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
2698: THEN
2699: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2700: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
2701: , SQLCODE||SQLERRM);

Line 2699: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
2698: THEN
2699: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2700: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
2701: , SQLCODE||SQLERRM);
2702: END IF;
2703: RAISE;

Line 2733: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2729: )
2730: IS
2731:
2732: lv_procedure_name VARCHAR2(40) := 'Create_Dynamic_Index';
2733: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2734: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2735:
2736: lv_create_sql VARCHAR2(2000);
2737: lv_drop_sql VARCHAR2(200);

Line 2734: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2730: IS
2731:
2732: lv_procedure_name VARCHAR2(40) := 'Create_Dynamic_Index';
2733: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2734: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2735:
2736: lv_create_sql VARCHAR2(2000);
2737: lv_drop_sql VARCHAR2(200);
2738:

Line 2752: FND_LOG.STRING(ln_proc_level,

2748: BEGIN
2749: --logging for debug
2750: IF (ln_proc_level >= ln_dbg_level)
2751: THEN
2752: FND_LOG.STRING(ln_proc_level,
2753: G_MODULE_PREFIX || '.' || lv_procedure_name ||
2754: '.begin',
2755: 'Enter procedure');
2756: END IF; --l_proc_level>=l_dbg_level

Line 2789: FND_LOG.STRING(ln_proc_level,

2785:
2786: --logging for debug
2787: IF (ln_proc_level >= ln_dbg_level)
2788: THEN
2789: FND_LOG.STRING(ln_proc_level,
2790: G_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
2791: 'Exit procedure');
2792: END IF; -- (ln_proc_level>=ln_dbg_level)
2793:

Line 2796: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2792: END IF; -- (ln_proc_level>=ln_dbg_level)
2793:
2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2797: THEN
2798: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2799: G_MODULE_PREFIX || '.' || lv_procedure_name ||
2800: '.Other_Exception ',

Line 2798: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2794: EXCEPTION
2795: WHEN OTHERS THEN
2796: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2797: THEN
2798: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2799: G_MODULE_PREFIX || '.' || lv_procedure_name ||
2800: '.Other_Exception ',
2801: SQLCODE || SQLERRM);
2802: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2802: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2798: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2799: G_MODULE_PREFIX || '.' || lv_procedure_name ||
2800: '.Other_Exception ',
2801: SQLCODE || SQLERRM);
2802: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2803: EXECUTE IMMEDIATE lv_create_sql;
2804: END Create_Dynamic_Index;
2805:
2806: --==========================================================================

Line 3000: FND_LOG.STRING(G_PROC_LEVEL

2996:
2997: BEGIN
2998: IF( G_PROC_LEVEL >= g_debug_devel )
2999: THEN
3000: FND_LOG.STRING(G_PROC_LEVEL
3001: ,G_MODULE_PREFIX||l_procedure_name||'.begin'
3002: ,'Begin procedure');
3003: END IF; --( G_PROC_LEVEL >= g_debug_devel)
3004:

Line 3212: FND_LOG.STRING(G_PROC_LEVEL

3208: );
3209:
3210: IF( G_PROC_LEVEL >= g_debug_devel )
3211: THEN
3212: FND_LOG.STRING(G_PROC_LEVEL
3213: ,G_MODULE_PREFIX||l_procedure_name||'.end'
3214: ,'End procedure');
3215: END IF; --( G_PROC_LEVEL >= g_debug_devel)
3216: EXCEPTION

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

3214: ,'End procedure');
3215: END IF; --( G_PROC_LEVEL >= g_debug_devel)
3216: EXCEPTION
3217: WHEN OTHERS THEN
3218: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
3219: THEN
3220: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3221: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
3222: , SQLCODE||SQLERRM);

Line 3220: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3216: EXCEPTION
3217: WHEN OTHERS THEN
3218: IF(FND_LOG.LEVEL_UNEXPECTED >= g_debug_devel)
3219: THEN
3220: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3221: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
3222: , SQLCODE||SQLERRM);
3223: END IF;
3224: RAISE;

Line 3228: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;

3224: RAISE;
3225: END post_journal_itemized;
3226:
3227: BEGIN
3228: g_debug_devel:=fnd_log.G_CURRENT_RUNTIME_LEVEL;
3229:
3230: END JA_CN_POST_UTILITY_PKG;
3231: