DBA Data[Home] [Help]

APPS.PA_FP_MAP_BV_PUB dependencies on PA_FP_MAP_BV_PUB

Line 1: PACKAGE body PA_FP_MAP_BV_PUB as

1: PACKAGE body PA_FP_MAP_BV_PUB as
2: /* $Header: PAFPMBTB.pls 120.0 2005/05/29 19:14:08 appldev noship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE GEN_MAP_BV_TO_TARGET_RL

Line 17: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.gen_map_bv_to_target_rl';

13: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14: X_MSG_COUNT OUT NOCOPY NUMBER,
15: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
16:
17: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.gen_map_bv_to_target_rl';
18:
19: CURSOR txn_sum_csr(c_project_currency_code PA_BUDGET_LINES.PROJECT_CURRENCY_CODE%TYPE,
20: c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE)IS
21: SELECT /*+ INDEX(t3,PA_FP_CALC_AMT_TMP3_N2)*/

Line 138: PA_DEBUG.init_err_stack('PA_FP_MAP_BV_PUB.GEN_MAP_BV_TO_TARGET_RL');

134: X_MSG_COUNT := 0;
135: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
136:
137: IF p_pa_debug_mode = 'Y' and p_init_msg_flag = 'Y' THEN
138: PA_DEBUG.init_err_stack('PA_FP_MAP_BV_PUB.GEN_MAP_BV_TO_TARGET_RL');
139: ELSIF p_pa_debug_mode = 'Y' and p_init_msg_flag = 'N' THEN
140: pa_debug.set_curr_function( p_function => 'GEN_MAP_BV_TO_TARGET_RL'
141: ,p_debug_mode => p_pa_debug_mode);
142: END IF;

Line 490: ( p_pkg_name => 'PA_FP_MAP_BV_PUB'

486: WHEN OTHERS THEN
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: x_msg_data := SUBSTR(SQLERRM,1,240);
489: FND_MSG_PUB.add_exc_msg
490: ( p_pkg_name => 'PA_FP_MAP_BV_PUB'
491: ,p_procedure_name => 'GEN_MAP_BV_TO_TARGET_RL');
492: IF P_PA_DEBUG_MODE = 'Y' THEN
493: pa_fp_gen_amount_utils.fp_debug
494: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 513: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.maintain_rbs_dtls';

509: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
510: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
511: X_MSG_COUNT OUT NOCOPY NUMBER,
512: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
513: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_map_bv_pub.maintain_rbs_dtls';
514:
515: l_res_list_member_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
516: l_rbs_element_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
517: l_txn_accum_header_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 610: ( p_pkg_name => 'PA_FP_MAP_BV_PUB'

606: WHEN OTHERS THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_msg_data := SUBSTR(SQLERRM,1,240);
609: FND_MSG_PUB.add_exc_msg
610: ( p_pkg_name => 'PA_FP_MAP_BV_PUB'
611: ,p_procedure_name => 'MAINTAIN_RBS_DTLS');
612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_fp_gen_amount_utils.fp_debug
614: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 622: END PA_FP_MAP_BV_PUB;

618: END IF;
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END MAINTAIN_RBS_DTLS;
621:
622: END PA_FP_MAP_BV_PUB;