121:
122: IF l_debug_mode = 'Y' THEN
123: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_B'||to_char(l_spread_Curve_id);
124: pa_debug.write(g_module_name,pa_debug.g_err_stage,
125: pa_fp_constants_pkg.g_debug_level3);
126: END IF;
127:
128: INSERT INTO Pa_Spread_Curves_B
129: (
175: );
176:
177: IF l_debug_mode = 'Y' THEN
178: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_TL'||to_char(l_spread_Curve_id);
179: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
180: END IF;
181:
182: INSERT INTO Pa_Spread_Curves_TL
183: (
216:
217: CLOSE C;
218: IF l_debug_mode = 'Y' THEN
219: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for'||to_char(l_spread_Curve_id);
220: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
221: END IF;
222: RAISE NO_DATA_FOUND;
223:
224: END IF;
263:
264: IF l_debug_mode = 'Y' THEN
265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
266: pa_debug.write(g_module_name,pa_debug.g_err_stage,
267: pa_fp_constants_pkg.g_debug_level5);
268: pa_debug.reset_curr_function;
269: END IF;
270:
271: RAISE;
319: END IF;
320:
321: IF l_debug_mode = 'Y' THEN
322: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_B for'||to_char(X_spread_Curve_id);
323: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
324: END IF;
325:
326: UPDATE Pa_Spread_Curves_B
327: SET Spread_Curve_Code = X_Spread_Curve_Code,
346:
347: IF (SQL%NOTFOUND) THEN
348: IF l_debug_mode = 'Y' THEN
349: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_B'||to_char(X_spread_Curve_id);
350: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
351: END IF;
352: RAISE NO_DATA_FOUND;
353: END IF;
354:
353: END IF;
354:
355: IF l_debug_mode = 'Y' THEN
356: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_TL for'||to_char(X_spread_Curve_id);
357: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
358: END IF;
359:
360: UPDATE Pa_Spread_Curves_TL
361: SET Name = X_Name,
369:
370: IF (SQL%NOTFOUND) THEN
371: IF l_debug_mode = 'Y' THEN
372: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_T'||to_char(X_spread_Curve_id);
373: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
374: END IF;
375: RAISE NO_DATA_FOUND;
376: END IF;
377:
414:
415: IF l_debug_mode = 'Y' THEN
416: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
417: pa_debug.write(g_module_name,pa_debug.g_err_stage,
418: pa_fp_constants_pkg.g_debug_level5);
419: pa_debug.reset_curr_function;
420: END IF;
421:
422: RAISE;
533:
534: IF l_debug_mode = 'Y' THEN
535: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
536: pa_debug.write(g_module_name,pa_debug.g_err_stage,
537: pa_fp_constants_pkg.g_debug_level5);
538: pa_debug.reset_curr_function;
539: END IF;
540:
541: RAISE;