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: (
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: (
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:
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;
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
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:
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;
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,
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;
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:
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: