APPS.BIL_OBI_GROUPS_DENORM_PKG dependencies on FND_LOG

Line 20: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

16: g_pkg := 'bil.patch.115.sql.bil_obi_groups_denorm_pkg.';
17: l_proc := 'load';
18: p_table_name := 'BIL_OBI_RS_GROUPS_DENORM';
19:
20: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
21: bil_bi_util_collection_pkg.writeLog(
22: p_log_level => fnd_log.LEVEL_PROCEDURE,
23: p_module => g_pkg || l_proc || ' begin',
24: p_msg => 'Start of Procedure '|| l_proc);

Line 22: p_log_level => fnd_log.LEVEL_PROCEDURE,

18: p_table_name := 'BIL_OBI_RS_GROUPS_DENORM';
19:
20: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
21: bil_bi_util_collection_pkg.writeLog(
22: p_log_level => fnd_log.LEVEL_PROCEDURE,
23: p_module => g_pkg || l_proc || ' begin',
24: p_msg => 'Start of Procedure '|| l_proc);
25: END IF;
26:

Line 91: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

87: g_row_num := sql%rowcount;
88:
89: COMMIT;
90:
91: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
92: bil_bi_util_collection_pkg.writeLog(
93: p_log_level => fnd_log.LEVEL_EVENT,
94: p_module => g_pkg || l_proc ,
95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');

Line 93: p_log_level => fnd_log.LEVEL_EVENT,

89: COMMIT;
90:
91: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
92: bil_bi_util_collection_pkg.writeLog(
93: p_log_level => fnd_log.LEVEL_EVENT,
94: p_module => g_pkg || l_proc ,
95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');
96: END IF;
97:

Line 98: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

94: p_module => g_pkg || l_proc ,
95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');
96: END IF;
97:
98: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
99: bil_bi_util_collection_pkg.writeLog(
100: p_log_level => fnd_log.LEVEL_PROCEDURE,
101: p_module => g_pkg || l_proc || ' end ',
102: p_msg => 'End of Procedure '|| l_proc);

Line 100: p_log_level => fnd_log.LEVEL_PROCEDURE,

96: END IF;
97:
98: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
99: bil_bi_util_collection_pkg.writeLog(
100: p_log_level => fnd_log.LEVEL_PROCEDURE,
101: p_module => g_pkg || l_proc || ' end ',
102: p_msg => 'End of Procedure '|| l_proc);
103: END IF;
104:

Line 111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

107: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
108: fnd_message.set_token('ERRNO' ,SQLCODE);
109: fnd_message.set_token('REASON' ,SQLERRM);
110: fnd_message.set_token('ROUTINE' , l_proc);
111: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
112: p_module => g_pkg || l_proc || ' proc_error',
113: p_msg => fnd_message.get,
114: p_force_log => TRUE);
115: