APPS.PA_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_FP_EXCLUDED_ELEMENTS_PKG

Line 384: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) := 'Pa_Fp_Excluded_Elements_Pkg.Delete_Excluded_Elements';

380: L_DEBUG_LEVEL2 CONSTANT NUMBER := 2;
381: L_DEBUG_LEVEL3 CONSTANT NUMBER := 3;
382: L_DEBUG_LEVEL4 CONSTANT NUMBER := 4;
383: L_DEBUG_LEVEL5 CONSTANT NUMBER := 5;
384: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) := 'Pa_Fp_Excluded_Elements_Pkg.Delete_Excluded_Elements';
385:
386: CURSOR cur_excl_elems IS
387: SELECT rowid
388: FROM pa_fp_excluded_elements

Line 444: pa_debug.g_err_stage:= 'Calling PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW...';

440:
441: IF cur_excl_elems%FOUND THEN
442:
443: IF l_debug_mode = 'Y' THEN
444: pa_debug.g_err_stage:= 'Calling PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW...';
445: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
446: L_DEBUG_LEVEL3);
447: END IF;
448:

Line 449: PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW(

445: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
446: L_DEBUG_LEVEL3);
447: END IF;
448:
449: PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW(
450: p_row_id => excl_elems_rec.rowid,
451: x_return_status => x_return_status);
452:
453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 455: pa_debug.g_err_stage:= 'Error returned by PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW';

451: x_return_status => x_return_status);
452:
453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
454: IF l_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Error returned by PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW';
456: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
457: L_DEBUG_LEVEL5);
458: END IF;
459: CLOSE cur_excl_elems;