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.BIL_BI_PURGE_OBJ_PKG dependencies on BIL_BI_UTIL_COLLECTION_PKG

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

49: BEGIN
50: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
51: l_proc := 'TRUNC_OBJ.';
52:
53: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
54: bil_bi_util_collection_pkg.writeLog
55: (
56: p_log_level => fnd_log.LEVEL_PROCEDURE,
57: p_module => g_pkg || l_proc || 'begin',

Line 54: bil_bi_util_collection_pkg.writeLog

50: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
51: l_proc := 'TRUNC_OBJ.';
52:
53: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
54: bil_bi_util_collection_pkg.writeLog
55: (
56: p_log_level => fnd_log.LEVEL_PROCEDURE,
57: p_module => g_pkg || l_proc || 'begin',
58: p_msg => 'Start of Procedure '|| l_proc

Line 64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

60: END IF;
61: errbuf := NULL;
62: retcode := 0;
63:
64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
65: bil_bi_util_collection_pkg.writeLog
66: (p_log_level => fnd_log.LEVEL_STATEMENT,
67: p_module => g_pkg || l_proc || 'End',
68: p_msg => 'p_obj_name =>'||p_obj_name);

Line 65: bil_bi_util_collection_pkg.writeLog

61: errbuf := NULL;
62: retcode := 0;
63:
64: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
65: bil_bi_util_collection_pkg.writeLog
66: (p_log_level => fnd_log.LEVEL_STATEMENT,
67: p_module => g_pkg || l_proc || 'End',
68: p_msg => 'p_obj_name =>'||p_obj_name);
69: END IF;

Line 74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');

70:
71: CASE p_obj_name
72: WHEN 'OPDTL_F' THEN
73: -- Truncate Opportunity Detail Summary Objects
74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
77:
78: -- Delete references from BIS_REFRESH_LOG table

Line 75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');

71: CASE p_obj_name
72: WHEN 'OPDTL_F' THEN
73: -- Truncate Opportunity Detail Summary Objects
74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
77:
78: -- Delete references from BIS_REFRESH_LOG table
79: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line 76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

72: WHEN 'OPDTL_F' THEN
73: -- Truncate Opportunity Detail Summary Objects
74: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
75: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
76: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
77:
78: -- Delete references from BIS_REFRESH_LOG table
79: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );
80:

Line 84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');

80:
81: WHEN 'FST_DTL_F' THEN
82:
83: -- Truncate Forecast Summary Objects
84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

Line 85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');

81: WHEN 'FST_DTL_F' THEN
82:
83: -- Truncate Forecast Summary Objects
84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
89:

Line 86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');

82:
83: -- Truncate Forecast Summary Objects
84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
89:
90: -- Delete references from BIS_REFRESH_LOG table

Line 87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');

83: -- Truncate Forecast Summary Objects
84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
89:
90: -- Delete references from BIS_REFRESH_LOG table
91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );

Line 88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

84: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
85: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
86: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
87: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
88: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
89:
90: -- Delete references from BIS_REFRESH_LOG table
91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );
92:

Line 94: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

90: -- Delete references from BIS_REFRESH_LOG table
91: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || p_obj_name );
92:
93: WHEN 'CURRENCY' THEN
94: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
95:
96: WHEN 'PIPELINE_F' THEN
97: -- Truncate Pipeline Summary Objects
98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');

Line 98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');

94: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
95:
96: WHEN 'PIPELINE_F' THEN
97: -- Truncate Pipeline Summary Objects
98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');

Line 99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');

95:
96: WHEN 'PIPELINE_F' THEN
97: -- Truncate Pipeline Summary Objects
98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

Line 101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');

97: -- Truncate Pipeline Summary Objects
98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
104:
105: -- Delete references from BIS_REFRESH_LOG table

Line 102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');

98: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
104:
105: -- Delete references from BIS_REFRESH_LOG table
106: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

Line 103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

99: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
100: -- asolaiy added for 8.0.
101: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
102: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
103: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
104:
105: -- Delete references from BIS_REFRESH_LOG table
106: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
107: -- asolaiy added for 8.0. New current fact table.

Line 113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');

109:
110: WHEN 'ALL' THEN
111:
112: -- Truncate Opportunity Detail Summary Objects
113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
115: -- Delete references from BIS_REFRESH_LOG table
116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:

Line 114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');

110: WHEN 'ALL' THEN
111:
112: -- Truncate Opportunity Detail Summary Objects
113: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_F');
114: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_STG');
115: -- Delete references from BIS_REFRESH_LOG table
116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:
118: -- Truncate Forecast Summary Objects

Line 119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');

115: -- Delete references from BIS_REFRESH_LOG table
116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:
118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:

Line 120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');

116: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'OPDTL_F');
117:
118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:
124: -- Delete references from BIS_REFRESH_LOG table

Line 121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');

117:
118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:
124: -- Delete references from BIS_REFRESH_LOG table
125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');

Line 122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');

118: -- Truncate Forecast Summary Objects
119: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_F');
120: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
121: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_NEW_FST_ID');
122: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PROCESSED_FST_ID');
123:
124: -- Delete references from BIS_REFRESH_LOG table
125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:

Line 128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');

124: -- Delete references from BIS_REFRESH_LOG table
125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:
127: -- Truncate Pipeline Summary Objects
128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');

Line 129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');

125: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_' || 'FST_DTL_F');
126:
127: -- Truncate Pipeline Summary Objects
128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

Line 131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');

127: -- Truncate Pipeline Summary Objects
128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
134:
135: -- Delete references from BIS_REFRESH_LOG table

Line 132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');

128: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_F');
129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
134:
135: -- Delete references from BIS_REFRESH_LOG table
136: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');

Line 133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');

129: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPELINE_STG');
130: -- asolaiy added for 8.0.
131: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_PIPEC_F');
132: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_OPDTL_DENLOG_TMP');
133: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_DENLOG_STG');
134:
135: -- Delete references from BIS_REFRESH_LOG table
136: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPELINE_F');
137: -- asolaiy added for 8.0. New current fact table.

Line 141: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

137: -- asolaiy added for 8.0. New current fact table.
138: BIS_COLLECTION_UTILITIES.deleteLogForObject(p_object_name => 'BIL_BI_PIPEC_F');
139:
140: -- Truncate Currency Table
141: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
142:
143:
144: ELSE
145: NULL;

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

149: retcode := 0;
150: errbuf := 'Truncated ' || p_obj_name ||
151: ' Object(s) successfully' ;
152:
153: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
155: p_module => g_pkg || l_proc || 'End',
156: p_msg => 'End of Procedure '||l_proc
157: );

Line 154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

150: errbuf := 'Truncated ' || p_obj_name ||
151: ' Object(s) successfully' ;
152:
153: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
154: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
155: p_module => g_pkg || l_proc || 'End',
156: p_msg => 'End of Procedure '||l_proc
157: );
158: END IF;

Line 165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

161: g_retcode := -2;
162: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
163: fnd_message.set_token('Error is : ' ,SQLCODE);
164: fnd_message.set_token('Reason is : ', SQLERRM);
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
166: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
167: p_module => g_pkg || l_proc || 'proc_error',
168: p_msg => fnd_message.get,
169: p_force_log => TRUE

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

162: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
163: fnd_message.set_token('Error is : ' ,SQLCODE);
164: fnd_message.set_token('Reason is : ', SQLERRM);
165: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
166: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
167: p_module => g_pkg || l_proc || 'proc_error',
168: p_msg => fnd_message.get,
169: p_force_log => TRUE
170: );

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

197:
198: BEGIN
199: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
200: l_proc := 'PURGE_OBJ.';
201: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
203: p_module => g_pkg || l_proc || 'begin',
204: p_msg => 'Start of Procedure '|| l_proc
205: );

Line 202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

198: BEGIN
199: g_pkg := 'bil.patch.115.sql.BIL_BI_PURGE_OBJ_PKG.';
200: l_proc := 'PURGE_OBJ.';
201: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
202: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
203: p_module => g_pkg || l_proc || 'begin',
204: p_msg => 'Start of Procedure '|| l_proc
205: );
206: END IF;

Line 211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

207:
208: errbuf := NULL;
209: retcode := 0;
210:
211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
213: p_module => g_pkg || l_proc ,
214: p_msg => 'p_obj_name =>'||p_obj_name||' p_end_date => '||p_end_date);
215: END IF;

Line 212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

208: errbuf := NULL;
209: retcode := 0;
210:
211: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
212: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
213: p_module => g_pkg || l_proc ,
214: p_msg => 'p_obj_name =>'||p_obj_name||' p_end_date => '||p_end_date);
215: END IF;
216:

Line 219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

215: END IF;
216:
217: g_end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
218:
219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
221: p_module => g_pkg || l_proc ,
222: p_msg => ' g_end_date => '||g_end_date);
223: END IF;

Line 220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

216:
217: g_end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
218:
219: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
220: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
221: p_module => g_pkg || l_proc ,
222: p_msg => ' g_end_date => '||g_end_date);
223: END IF;
224:

Line 227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

223: END IF;
224:
225: g_end_date_timeid := TO_NUMBER(TO_CHAR(TRUNC(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS')),'J'));
226:
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
229: p_module => g_pkg || l_proc ,
230: p_msg => ' g_end_date_timid => '||g_end_date_timeid);
231: END IF;

Line 228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

224:
225: g_end_date_timeid := TO_NUMBER(TO_CHAR(TRUNC(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS')),'J'));
226:
227: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
228: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
229: p_module => g_pkg || l_proc ,
230: p_msg => ' g_end_date_timid => '||g_end_date_timeid);
231: END IF;
232:

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

258: g_status := TRUE;
259: errbuf := 'Purged ' || p_obj_name ||
260: ' Object(s) successfully upto date ' || g_end_date;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
264: p_module => g_pkg || l_proc || 'End',
265: p_msg => 'End of Procedure '||l_proc
266: );

Line 263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

259: errbuf := 'Purged ' || p_obj_name ||
260: ' Object(s) successfully upto date ' || g_end_date;
261:
262: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
263: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
264: p_module => g_pkg || l_proc || 'End',
265: p_msg => 'End of Procedure '||l_proc
266: );
267: END IF;

Line 280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

276: errbuf := g_errbuf;
277: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
278: fnd_message.set_token('Error is : ' ,SQLCODE);
279: fnd_message.set_token('Reason is : ', SQLERRM);
280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
281: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
282: p_module => g_pkg || l_proc || 'proc_error',
283: p_msg => fnd_message.get,
284: p_force_log => TRUE

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

277: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
278: fnd_message.set_token('Error is : ' ,SQLCODE);
279: fnd_message.set_token('Reason is : ', SQLERRM);
280: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
281: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
282: p_module => g_pkg || l_proc || 'proc_error',
283: p_msg => fnd_message.get,
284: p_force_log => TRUE
285: );

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

302:
303: BEGIN
304: l_proc := 'OPDTL_F_PURGE.';
305: l_cnt := 0;
306: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
308: p_module => g_pkg || l_proc || 'begin',
309: p_msg => 'Start of Procedure '|| l_proc
310: );

Line 307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

303: BEGIN
304: l_proc := 'OPDTL_F_PURGE.';
305: l_cnt := 0;
306: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
307: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
308: p_module => g_pkg || l_proc || 'begin',
309: p_msg => 'Start of Procedure '|| l_proc
310: );
311: END IF;

Line 330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

326: OR opty_ld_conversion_date IS NULL)
327: AND close_date <= g_end_date; -- added asolaiy after forecast date changes.
328: END IF;
329:
330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
332: p_module => g_pkg || l_proc ,
333: p_msg => ' Opdtl Stg Tbl records Deleted :'||SQL%ROWCOUNT);
334: END IF;

Line 331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

327: AND close_date <= g_end_date; -- added asolaiy after forecast date changes.
328: END IF;
329:
330: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
331: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
332: p_module => g_pkg || l_proc ,
333: p_msg => ' Opdtl Stg Tbl records Deleted :'||SQL%ROWCOUNT);
334: END IF;
335:

Line 346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

342: AND (opty_ld_conversion_time_id <= g_end_date_timeid
343: OR opty_ld_conversion_time_id IS NULL)
344: AND opty_effective_time_id <= g_end_date_timeid; -- added asolaiy for forecast date changes.
345:
346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
348: p_module => g_pkg || l_proc ,
349: p_msg => ' Opdtl_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
350: END IF;

Line 347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

343: OR opty_ld_conversion_time_id IS NULL)
344: AND opty_effective_time_id <= g_end_date_timeid; -- added asolaiy for forecast date changes.
345:
346: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
347: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
348: p_module => g_pkg || l_proc ,
349: p_msg => ' Opdtl_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
350: END IF;
351:

Line 357: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_OPDTL_F',

353:
354: COMMIT;
355:
356: -- Analyze the Tables
357: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_OPDTL_F',
358: p_cascade => TRUE,
359: p_est_pct => 10 ,
360: p_granularity => 'GLOBAL');
361: g_status := TRUE;

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

362: g_retcode := 0;
363: -- Call BIS wrap up and clean up
364: clean_up;
365:
366: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
368: p_module => g_pkg || l_proc || 'End',
369: p_msg => 'End of Procedure '||l_proc
370: );

Line 367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

363: -- Call BIS wrap up and clean up
364: clean_up;
365:
366: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
367: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
368: p_module => g_pkg || l_proc || 'End',
369: p_msg => 'End of Procedure '||l_proc
370: );
371: END IF;

Line 381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

377: g_errbuf := sqlerrm ;
378: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
379: fnd_message.set_token('Error is : ' ,SQLCODE);
380: fnd_message.set_token('Reason is : ', SQLERRM);
381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
382: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
383: p_module => g_pkg || l_proc || 'proc_error',
384: p_msg => fnd_message.get,
385: p_force_log => TRUE

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

378: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
379: fnd_message.set_token('Error is : ' ,SQLCODE);
380: fnd_message.set_token('Reason is : ', SQLERRM);
381: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
382: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
383: p_module => g_pkg || l_proc || 'proc_error',
384: p_msg => fnd_message.get,
385: p_force_log => TRUE
386: );

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

405: BEGIN
406: l_proc := 'PIPELINE_F_PURGE.';
407: l_cnt := 0;
408:
409: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
410: bil_bi_util_collection_pkg.writeLog
411: (
412: p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',

Line 410: bil_bi_util_collection_pkg.writeLog

406: l_proc := 'PIPELINE_F_PURGE.';
407: l_cnt := 0;
408:
409: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
410: bil_bi_util_collection_pkg.writeLog
411: (
412: p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc

Line 435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

431: DELETE FROM bil_bi_pipeline_stg
432: WHERE snap_date <= g_end_date;
433: END IF;
434:
435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
437: p_module => g_pkg || l_proc ,
438: p_msg => ' Pipeline Stg Tbl records Deleted :'||SQL%ROWCOUNT);
439: END IF;

Line 436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

432: WHERE snap_date <= g_end_date;
433: END IF;
434:
435: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
436: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
437: p_module => g_pkg || l_proc ,
438: p_msg => ' Pipeline Stg Tbl records Deleted :'||SQL%ROWCOUNT);
439: END IF;
440:

Line 447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

443: DELETE FROM bil_bi_pipeline_f
444: WHERE snap_date <= g_end_date;
445:
446:
447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
449: p_module => g_pkg || l_proc ,
450: p_msg => ' Pipeline_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
451: END IF;

Line 448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

444: WHERE snap_date <= g_end_date;
445:
446:
447: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
448: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
449: p_module => g_pkg || l_proc ,
450: p_msg => ' Pipeline_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
451: END IF;
452:

Line 460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

456: DELETE FROM bil_bi_pipec_f
457: WHERE snap_date <= g_end_date;
458:
459:
460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
462: p_module => g_pkg || l_proc ,
463: p_msg => ' Pipec_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
464: END IF;

Line 461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

457: WHERE snap_date <= g_end_date;
458:
459:
460: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
461: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
462: p_module => g_pkg || l_proc ,
463: p_msg => ' Pipec_f Summary Tbl records Deleted :'||SQL%ROWCOUNT);
464: END IF;
465:

Line 472: bil_bi_util_collection_pkg.analyze_table

468:
469: COMMIT;
470:
471: -- Analyze the Tables
472: bil_bi_util_collection_pkg.analyze_table
473: (
474: p_tbl_name => 'BIL_BI_PIPELINE_F',
475: p_cascade => TRUE,
476: p_est_pct => 10 ,

Line 481: bil_bi_util_collection_pkg.analyze_table

477: p_granularity => 'GLOBAL'
478: );
479:
480: -- asolaiy added for 8.0. Analyze the Table
481: bil_bi_util_collection_pkg.analyze_table
482: (
483: p_tbl_name => 'BIL_BI_PIPEC_F',
484: p_cascade => TRUE,
485: p_est_pct => 10 ,

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

491:
492: -- Call BIS wrap up and clean up
493: clean_up;
494:
495: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
497: p_module => g_pkg || l_proc || 'End',
498: p_msg => 'End of Procedure '||l_proc
499: );

Line 496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

492: -- Call BIS wrap up and clean up
493: clean_up;
494:
495: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
496: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
497: p_module => g_pkg || l_proc || 'End',
498: p_msg => 'End of Procedure '||l_proc
499: );
500: END IF;

Line 511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

507: g_errbuf := sqlerrm ;
508: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
509: fnd_message.set_token('Error is : ' ,SQLCODE);
510: fnd_message.set_token('Reason is : ', SQLERRM);
511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
512: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
513: p_module => g_pkg || l_proc || 'proc_error',
514: p_msg => fnd_message.get,
515: p_force_log => TRUE);

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

508: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
509: fnd_message.set_token('Error is : ' ,SQLCODE);
510: fnd_message.set_token('Reason is : ', SQLERRM);
511: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
512: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
513: p_module => g_pkg || l_proc || 'proc_error',
514: p_msg => fnd_message.get,
515: p_force_log => TRUE);
516: END IF;

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

539: l_proc VARCHAR2(100);
540:
541: BEGIN
542: l_proc := 'FST_DTL_F_PURGE.';
543: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
545: p_module => g_pkg || l_proc || 'begin',
546: p_msg => 'Start of Procedure '|| l_proc
547: );

Line 544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

540:
541: BEGIN
542: l_proc := 'FST_DTL_F_PURGE.';
543: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
544: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
545: p_module => g_pkg || l_proc || 'begin',
546: p_msg => 'Start of Procedure '|| l_proc
547: );
548: END IF;

Line 551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

547: );
548: END IF;
549:
550: -- Initialize the WHO Variables
551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc ,
554: p_msg => ' Initialize the WHO Variables ');
555: END IF;

Line 552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

548: END IF;
549:
550: -- Initialize the WHO Variables
551: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc ,
554: p_msg => ' Initialize the WHO Variables ');
555: END IF;
556:

Line 570: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

566:
567: IF (NOT bis_common_parameters.check_global_parameters(l_list)) THEN -- Check Parameters
568: bis_common_parameters.get_global_parameters(l_list, l_val);
569: fnd_message.set_name('BIL','BIL_BI_SETUP_INCOMPLETE');
570: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
571: p_module => g_pkg || l_proc || 'proc_error',
572: p_msg => fnd_message.get,
573: p_force_log => TRUE);
574: FOR v_counter IN 1..3 LOOP

Line 578: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));

574: FOR v_counter IN 1..3 LOOP
575: IF (l_val(v_counter) IS NULL) THEN
576: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
577: fnd_message.set_token('PROFILE_USER_NAME' ,
578: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
579: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
580: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
581: p_module => g_pkg || l_proc || 'proc_error',
582: p_msg => fnd_message.get,

Line 580: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,

576: fnd_message.set_name('BIL','BIL_BI_PROFILE_MISSING');
577: fnd_message.set_token('PROFILE_USER_NAME' ,
578: bil_bi_util_collection_pkg.get_user_profile_name(l_list(v_counter)));
579: fnd_message.set_token('PROFILE_INTERNAL_NAME' ,l_list(v_counter));
580: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_ERROR,
581: p_module => g_pkg || l_proc || 'proc_error',
582: p_msg => fnd_message.get,
583: p_force_log => TRUE);
584: END IF;

Line 591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

587: ELSE
588: bis_common_parameters.get_global_parameters(l_list, l_val);
589: END IF; -- Check Parameters Ends Here
590:
591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'l_val(1) = ' || l_val(1) || ' l_val(2)= ' || l_val(2) ||
595: ' l_val(3)= ' || l_val(3));

Line 592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

588: bis_common_parameters.get_global_parameters(l_list, l_val);
589: END IF; -- Check Parameters Ends Here
590:
591: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
592: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
593: p_module => g_pkg || l_proc ,
594: p_msg => 'l_val(1) = ' || l_val(1) || ' l_val(2)= ' || l_val(2) ||
595: ' l_val(3)= ' || l_val(3));
596: END IF;

Line 682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

678: ' l_end_dt_ent_qtr_id =>'||l_end_dt_ent_qtr_id||' '||
679: ' l_end_dt_ent_period_id =>'||l_end_dt_ent_per_id||' '||
680: ' l_end_dt_ent_week_id =>'||l_end_dt_week_id ;
681:
682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
684: p_module => g_pkg || l_proc ,
685: p_msg => 'Parameters '||l_stmt);
686: END IF;

Line 683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

679: ' l_end_dt_ent_period_id =>'||l_end_dt_ent_per_id||' '||
680: ' l_end_dt_ent_week_id =>'||l_end_dt_week_id ;
681:
682: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
683: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
684: p_module => g_pkg || l_proc ,
685: p_msg => 'Parameters '||l_stmt);
686: END IF;
687:

Line 701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

697: OR (forecast_time_id <= l_end_dt_ent_year_id
698: AND forecast_period_type_id = 128));
699:
700: l_stmt := ' Summary Tbl records Eff Dt < End Dt Deleted';
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
703: p_module => g_pkg || l_proc ,
704: p_msg => l_stmt|| ' '||SQL%ROWCOUNT);
705: END IF;

Line 702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

698: AND forecast_period_type_id = 128));
699:
700: l_stmt := ' Summary Tbl records Eff Dt < End Dt Deleted';
701: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
702: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
703: p_module => g_pkg || l_proc ,
704: p_msg => l_stmt|| ' '||SQL%ROWCOUNT);
705: END IF;
706:

Line 715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

711: WHEN OTHERS THEN
712: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
713: fnd_message.set_token('Error is : ' ,SQLCODE);
714: fnd_message.set_token('Reason is : ', SQLERRM);
715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
716: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
717: p_module => g_pkg || l_proc || 'proc_error',
718: p_msg => fnd_message.get,
719: p_force_log => TRUE);

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

712: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
713: fnd_message.set_token('Error is : ' ,SQLCODE);
714: fnd_message.set_token('Reason is : ', SQLERRM);
715: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
716: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
717: p_module => g_pkg || l_proc || 'proc_error',
718: p_msg => fnd_message.get,
719: p_force_log => TRUE);
720: END IF;

Line 734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

730: AND gl.period_set_name = l_val(3)
731: AND gl.end_date <= g_end_date
732: );
733: l_stmt := ' Rows deleted from processed_fst_id table ';
734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;

Line 735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

731: AND gl.end_date <= g_end_date
732: );
733: l_stmt := ' Rows deleted from processed_fst_id table ';
734: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

Line 739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');

735: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
740: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
741: -- Analyze the Tables
742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',
743: p_cascade => TRUE,

Line 740: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');

736: p_module => g_pkg || l_proc ,
737: p_msg => l_stmt|| ''||SQL%ROWCOUNT);
738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
740: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
741: -- Analyze the Tables
742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',
743: p_cascade => TRUE,
744: p_est_pct => 10 ,

Line 742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',

738: END IF;
739: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_CURRENCY_RATE');
740: bil_bi_util_collection_pkg.truncate_table(p_table_name => 'BIL_BI_FST_DTL_STG');
741: -- Analyze the Tables
742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',
743: p_cascade => TRUE,
744: p_est_pct => 10 ,
745: p_granularity => 'GLOBAL');
746: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_STG',

Line 746: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_STG',

742: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_F',
743: p_cascade => TRUE,
744: p_est_pct => 10 ,
745: p_granularity => 'GLOBAL');
746: bil_bi_util_collection_pkg.analyze_table(p_tbl_name => 'BIL_BI_FST_DTL_STG',
747: p_cascade => TRUE,
748: p_est_pct => 10 ,
749: p_granularity => 'GLOBAL');
750: g_status := TRUE;

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

750: g_status := TRUE;
751: g_retcode := 0;
752: -- Call BIS wrap up and clean up
753: clean_up;
754: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
756: p_module => g_pkg || l_proc || 'End',
757: p_msg => 'End of Procedure '||l_proc
758: );

Line 755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

751: g_retcode := 0;
752: -- Call BIS wrap up and clean up
753: clean_up;
754: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
755: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
756: p_module => g_pkg || l_proc || 'End',
757: p_msg => 'End of Procedure '||l_proc
758: );
759: END IF;

Line 774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

770: g_errbuf := sqlerrm ;
771: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
772: fnd_message.set_token('Error is : ' ,SQLCODE);
773: fnd_message.set_token('Reason is : ', SQLERRM);
774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
775: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
776: p_module => g_pkg || l_proc || 'proc_error',
777: p_msg => fnd_message.get,
778: p_force_log => TRUE

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

771: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
772: fnd_message.set_token('Error is : ' ,SQLCODE);
773: fnd_message.set_token('Reason is : ', SQLERRM);
774: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
775: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
776: p_module => g_pkg || l_proc || 'proc_error',
777: p_msg => fnd_message.get,
778: p_force_log => TRUE
779: );

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

795: l_proc VARCHAR2(100);
796: BEGIN
797: l_valid_setup := FALSE;
798: l_proc := 'INIT.';
799: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
801: p_module => g_pkg || l_proc || 'begin',
802: p_msg => 'Start of Procedure '||l_proc
803: );

Line 800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

796: BEGIN
797: l_valid_setup := FALSE;
798: l_proc := 'INIT.';
799: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
800: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
801: p_module => g_pkg || l_proc || 'begin',
802: p_msg => 'Start of Procedure '||l_proc
803: );
804: END IF;

Line 820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

816: -- Call generic Setup procedure
817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');
818:
819: IF l_valid_setup THEN
820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
821: bil_bi_util_collection_pkg.writeLog
822: (
823: p_log_level => fnd_log.LEVEL_STATEMENT,
824: p_module => g_pkg || l_proc ||' BIS Setup ',

Line 821: bil_bi_util_collection_pkg.writeLog

817: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'BIL_BI_'|| p_obj_name ||'_PURGE');
818:
819: IF l_valid_setup THEN
820: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
821: bil_bi_util_collection_pkg.writeLog
822: (
823: p_log_level => fnd_log.LEVEL_STATEMENT,
824: p_module => g_pkg || l_proc ||' BIS Setup ',
825: p_msg => 'BIS Setup successful'

Line 829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

825: p_msg => 'BIS Setup successful'
826: );
827: END IF;
828: ELSE
829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
830: bil_bi_util_collection_pkg.writeLog
831: (
832: p_log_level => fnd_log.LEVEL_STATEMENT,
833: p_module => g_pkg || l_proc ||' BIS Setup ',

Line 830: bil_bi_util_collection_pkg.writeLog

826: );
827: END IF;
828: ELSE
829: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
830: bil_bi_util_collection_pkg.writeLog
831: (
832: p_log_level => fnd_log.LEVEL_STATEMENT,
833: p_module => g_pkg || l_proc ||' BIS Setup ',
834: p_msg => 'BIS Setup Failed'

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

837: g_retcode := 2;
838: RETURN;
839: END IF;
840:
841: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
843: p_module => g_pkg || l_proc || 'End',
844: p_msg => 'End of Procedure '||l_proc);
845: END IF;

Line 842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

838: RETURN;
839: END IF;
840:
841: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
842: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
843: p_module => g_pkg || l_proc || 'End',
844: p_msg => 'End of Procedure '||l_proc);
845: END IF;
846:

Line 854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

850: g_errbuf := sqlerrm ;
851: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
852: fnd_message.set_token('Error is : ' ,SQLCODE);
853: fnd_message.set_token('Reason is : ', SQLERRM);
854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
855: bil_bi_util_collection_pkg.writeLog
856: (
857: p_log_level => fnd_log.LEVEL_UNEXPECTED,
858: p_module => g_pkg || l_proc || 'proc_error',

Line 855: bil_bi_util_collection_pkg.writeLog

851: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
852: fnd_message.set_token('Error is : ' ,SQLCODE);
853: fnd_message.set_token('Reason is : ', SQLERRM);
854: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
855: bil_bi_util_collection_pkg.writeLog
856: (
857: p_log_level => fnd_log.LEVEL_UNEXPECTED,
858: p_module => g_pkg || l_proc || 'proc_error',
859: p_msg => fnd_message.get,

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

875: PROCEDURE clean_up IS
876: l_proc VARCHAR2(100);
877: BEGIN
878: l_proc := 'CLEAN_UP.';
879: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
881: p_module => g_pkg || l_proc || 'begin',
882: p_msg => 'Start of Procedure '||l_proc
883: );

Line 880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

876: l_proc VARCHAR2(100);
877: BEGIN
878: l_proc := 'CLEAN_UP.';
879: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
880: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
881: p_module => g_pkg || l_proc || 'begin',
882: p_msg => 'Start of Procedure '||l_proc
883: );
884: END IF;

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

895: p_message => NULL,
896: p_period_from => NULL,
897: p_period_to => g_end_date);
898: END IF;
899: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
901: p_module => g_pkg || l_proc || 'End',
902: p_msg => 'End of Procedure '||l_proc);
903: END IF;

Line 900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

896: p_period_from => NULL,
897: p_period_to => g_end_date);
898: END IF;
899: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
900: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
901: p_module => g_pkg || l_proc || 'End',
902: p_msg => 'End of Procedure '||l_proc);
903: END IF;
904: EXCEPTION

Line 911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

907: g_errbuf := sqlerrm;
908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
909: fnd_message.set_token('Error is : ' ,SQLCODE);
910: fnd_message.set_token('Reason is : ', SQLERRM);
911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
913: p_module => g_pkg || l_proc || 'proc_error',
914: p_msg => fnd_message.get,
915: p_force_log => TRUE

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

908: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
909: fnd_message.set_token('Error is : ' ,SQLCODE);
910: fnd_message.set_token('Reason is : ', SQLERRM);
911: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
912: bil_bi_util_collection_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
913: p_module => g_pkg || l_proc || 'proc_error',
914: p_msg => fnd_message.get,
915: p_force_log => TRUE
916: );