DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_CURVES_PKG dependencies on PA_DEBUG

Line 111: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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 );

Line 114: pa_debug.set_curr_function( p_function => 'validate',

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)

Line 123: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_B'||to_char(l_spread_Curve_id);

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:

Line 124: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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

Line 178: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_TL'||to_char(l_spread_Curve_id);

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

Line 179: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);

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

Line 219: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for'||to_char(l_spread_Curve_id);

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:

Line 220: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

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;

Line 248: pa_debug.reset_curr_function;

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:

Line 265: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

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;

Line 266: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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:

Line 268: pa_debug.reset_curr_function;

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:

Line 314: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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 );

Line 317: pa_debug.set_curr_function( p_function => 'validate',

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

Line 322: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_B for'||to_char(X_spread_Curve_id);

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

Line 323: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

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,

Line 349: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_B'||to_char(X_spread_Curve_id);

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;

Line 350: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

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:

Line 356: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_TL for'||to_char(X_spread_Curve_id);

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

Line 357: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

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,

Line 372: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_T'||to_char(X_spread_Curve_id);

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;

Line 373: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

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:

Line 399: pa_debug.reset_curr_function;

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:

Line 416: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

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;

Line 417: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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:

Line 419: pa_debug.reset_curr_function;

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;

Line 535: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;

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;

Line 536: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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:

Line 538: pa_debug.reset_curr_function;

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;