DBA Data[Home] [Help]

APPS.PJI_MT_MEASURE_SETS_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 110: Pa_Fp_Constants_Pkg.g_debug_level3);

106:
107: IF g_debug_mode = 'Y' THEN
108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;
109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
110: Pa_Fp_Constants_Pkg.g_debug_level3);
111: END IF;
112:
113: INSERT INTO pji_mt_measure_sets_B
114: (

Line 145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);

141: );
142:
143: IF g_debug_mode = 'Y' THEN
144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;
145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);
146: END IF;
147:
148: INSERT INTO pji_mt_measure_sets_tl
149: (

Line 190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

186: CLOSE C;
187:
188: IF g_debug_mode = 'Y' THEN
189: Pa_Debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Measure_Set_Code;
190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
191: END IF;
192:
193: RAISE NO_DATA_FOUND;
194:

Line 238: Pa_Fp_Constants_Pkg.g_debug_level5);

234:
235: IF g_debug_mode = 'Y' THEN
236: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
237: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
238: Pa_Fp_Constants_Pkg.g_debug_level5);
239: Pa_Debug.reset_curr_function;
240: END IF;
241:
242: RAISE;

Line 284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);

280: END IF;
281:
282: IF g_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
285: END IF;
286:
287: BEGIN
288: SELECT object_version_number

Line 296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

292: EXCEPTION
293: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
294: IF g_debug_mode = 'Y' THEN
295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;
296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
297: END IF;
298: RAISE;
299: END;
300:

Line 328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

324:
325: IF (SQL%NOTFOUND) THEN
326: IF g_debug_mode = 'Y' THEN
327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;
328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
329: END IF;
330:
331: RAISE NO_DATA_FOUND;
332: END IF;

Line 336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);

332: END IF;
333:
334: IF g_debug_mode = 'Y' THEN
335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;
336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
337: END IF;
338:
339: UPDATE pji_mt_measure_sets_tl
340: SET Name = X_Name,

Line 352: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);

348:
349: IF (SQL%NOTFOUND) THEN
350: IF g_debug_mode = 'Y' THEN
351: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_T '||X_measure_set_code;
352: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
353: END IF;
354:
355: RAISE NO_DATA_FOUND;
356: END IF;

Line 398: Pa_Fp_Constants_Pkg.g_debug_level5);

394:
395: IF g_debug_mode = 'Y' THEN
396: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
397: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
398: Pa_Fp_Constants_Pkg.g_debug_level5);
399: Pa_Debug.reset_curr_function;
400: END IF;
401:
402:

Line 492: Pa_Fp_Constants_Pkg.g_debug_level5);

488:
489: IF g_debug_mode = 'Y' THEN
490: Pa_Debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
492: Pa_Fp_Constants_Pkg.g_debug_level5);
493: Pa_Debug.reset_curr_function;
494: END IF;
495:
496: