107: BEGIN
108:
109: x_msg_count := 0;
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
112:
113: IF l_debug_mode = 'Y' THEN
114: pa_debug.set_curr_function( p_function => 'validate',
115: p_debug_mode => l_debug_mode );
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
112:
113: IF l_debug_mode = 'Y' THEN
114: pa_debug.set_curr_function( p_function => 'validate',
115: p_debug_mode => l_debug_mode );
116: END IF;
117:
118: select nvl(X_SPREAD_CURVE_ID,PA_SPREAD_CURVES_S.nextval)
119: into l_spread_curve_id
120: from dual;
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:
120: from dual;
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
174: X_Last_Update_Login
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
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: (
215: IF (C%NOTFOUND) THEN
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:
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;
244: x_msg_count := l_msg_count;
245: END IF;
246:
247: IF l_debug_mode = 'Y' THEN
248: pa_debug.reset_curr_function;
249: END IF;
250:
251: RETURN;
252:
261: ,p_procedure_name => 'Insert Row'
262: ,p_error_text => x_msg_data);
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;
262: ,p_error_text => x_msg_data);
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:
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;
272:
310: BEGIN
311:
312: x_msg_count := 0;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
315:
316: IF l_debug_mode = 'Y' THEN
317: pa_debug.set_curr_function( p_function => 'validate',
318: p_debug_mode => l_debug_mode );
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
315:
316: IF l_debug_mode = 'Y' THEN
317: pa_debug.set_curr_function( p_function => 'validate',
318: p_debug_mode => l_debug_mode );
319: END IF;
320:
321: IF l_debug_mode = 'Y' THEN
318: p_debug_mode => l_debug_mode );
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
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,
345: Where Spread_Curve_Id = X_Spread_Curve_Id;
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;
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:
352: RAISE NO_DATA_FOUND;
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
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,
368: AND Userenv('Lang') In (Language, Source_Lang);
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;
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:
395: x_msg_count := l_msg_count;
396: END IF;
397:
398: IF l_debug_mode = 'Y' THEN
399: pa_debug.reset_curr_function;
400: END IF;
401:
402: RAISE NO_DATA_FOUND;
403:
412: ,p_procedure_name => 'UPDATE_ROW'
413: ,p_error_text => x_msg_data);
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;
413: ,p_error_text => x_msg_data);
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:
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;
423: END Update_Row;
531: ,p_procedure_name => 'UPDATE_ROW'
532: ,p_error_text => l_msg_data);
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;
532: ,p_error_text => l_msg_data);
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:
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;
542: END Load_Row;