APPS.PJI_MT_ROWSET_DET_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 105: pa_fp_constants_pkg.g_debug_level3);

101:
102: IF g_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_det, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;
104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:
108: INSERT INTO pji_mt_rowset_det
109: (

Line 134: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);

130: );
131:
132: IF g_debug_mode = 'Y' THEN
133: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_det '||X_measure_set_code;
134: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
137: OPEN C;
138: FETCH C INTO X_ROWID;

Line 144: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

140:
141: CLOSE C;
142: IF g_debug_mode = 'Y' THEN
143: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_measure_set_code;
144: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
145: END IF;
146: RAISE NO_DATA_FOUND;
147:
148: END IF;

Line 191: pa_fp_constants_pkg.g_debug_level5);

187:
188: IF g_debug_mode = 'Y' THEN
189: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
190: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
191: pa_fp_constants_pkg.g_debug_level5);
192: pa_debug.reset_curr_function;
193: END IF;
194:
195: RAISE;

Line 233: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

229: END IF;
230:
231: IF g_debug_mode = 'Y' THEN
232: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for'||X_measure_set_code;
233: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
234: END IF;
235:
236: UPDATE pji_mt_rowset_det
237: SET

Line 249: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

245:
246: IF (SQL%NOTFOUND) THEN
247: IF g_debug_mode = 'Y' THEN
248: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_det, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;
249: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
250: END IF;
251: RAISE NO_DATA_FOUND;
252: END IF;
253:

Line 256: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

252: END IF;
253:
254: IF g_debug_mode = 'Y' THEN
255: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;
256: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
257: END IF;
258:
259: EXCEPTION
260: WHEN NO_DATA_FOUND THEN

Line 299: pa_fp_constants_pkg.g_debug_level5);

295:
296: IF g_debug_mode = 'Y' THEN
297: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
298: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
299: pa_fp_constants_pkg.g_debug_level5);
300: pa_debug.reset_curr_function;
301: END IF;
302:
303: RAISE;

Line 378: pa_fp_constants_pkg.g_debug_level5);

374:
375: IF g_debug_mode = 'Y' THEN
376: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
377: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
378: pa_fp_constants_pkg.g_debug_level5);
379: pa_debug.reset_curr_function;
380: END IF;
381:
382: RAISE;