DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_FP_GEN_FCST_AMT_PVT

Line 1: PACKAGE body PA_FP_GEN_FCST_AMT_PVT as

1: PACKAGE body PA_FP_GEN_FCST_AMT_PVT as
2: /* $Header: PAFPFGVB.pls 120.7.12020000.2 2013/05/17 10:10:29 bpottipa ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /*=======================================================================================

Line 1264: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1260: WHEN OTHERS THEN
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: x_msg_data := SUBSTR(SQLERRM,1,240);
1263: FND_MSG_PUB.add_exc_msg
1264: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1265: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');
1266: IF P_PA_DEBUG_MODE = 'Y' THEN
1267: pa_fp_gen_amount_utils.fp_debug
1268: (p_called_mode => p_calling_context,

Line 1331: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1327: WHEN OTHERS THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: x_msg_data := SUBSTR(SQLERRM,1,240);
1330: FND_MSG_PUB.add_exc_msg
1331: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1332: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');
1333: IF P_PA_DEBUG_MODE = 'Y' THEN
1334: pa_fp_gen_amount_utils.fp_debug
1335: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 1968: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: x_msg_data := SUBSTR(SQLERRM,1,240);
1967: FND_MSG_PUB.add_exc_msg
1968: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1969: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');
1970: IF P_PA_DEBUG_MODE = 'Y' THEN
1971: pa_fp_gen_amount_utils.fp_debug
1972: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 2017: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';

2013: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
2014: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
2015: AND adjustment_period_flag = 'N';
2016:
2017: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
2018: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
2019: l_future_no_of_period NUMBER;
2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;

Line 2154: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'

2150: the sum of init qty,cost and rev for the given period */
2151: IF p_pa_debug_mode = 'Y' THEN
2152: pa_fp_gen_amount_utils.fp_debug
2153: (p_msg => 'Before calling
2154: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'
2155: ||'P_RES_ASG_ID:'||l_res_asg_id
2156: ||';P_ACTUAL_FROM_DATE:'||l_actual_from_date
2157: ||';P_ACTUAL_TO_DATE:'||l_actual_to_date
2158: ||';P_CURRENCY_FLAG:'||P_CURRENCY_FLAG,

Line 2162: PA_FP_GEN_FCST_AMT_PVT.GET_ACTUAL_TXN_AMOUNT

2158: ||';P_CURRENCY_FLAG:'||P_CURRENCY_FLAG,
2159: p_module_name => l_module_name,
2160: p_log_level => 5);
2161: END IF;
2162: PA_FP_GEN_FCST_AMT_PVT.GET_ACTUAL_TXN_AMOUNT
2163: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2164: P_TASK_ID => P_TASK_ID,
2165: P_RES_LIST_MEMBER_ID => P_RES_LIST_MEMBER_ID,
2166: P_CBS_ELEMENT_ID => P_CBS_ELEMENT_ID, --bug#16791711

Line 2183: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '

2179: END IF;
2180: IF p_pa_debug_mode = 'Y' THEN
2181: pa_fp_gen_amount_utils.fp_debug
2182: (p_msg => 'Status after calling
2183: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '
2184: ||x_return_status,
2185: p_module_name => l_module_name,
2186: p_log_level => 5);
2187: END IF;

Line 2367: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

2363: WHEN OTHERS THEN
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: x_msg_data := SUBSTR(SQLERRM,1,240);
2366: FND_MSG_PUB.add_exc_msg
2367: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2368: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');
2369: IF P_PA_DEBUG_MODE = 'Y' THEN
2370: pa_fp_gen_amount_utils.fp_debug
2371: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 2397: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';

2393: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2394: X_MSG_COUNT OUT NOCOPY NUMBER,
2395: X_MSG_DATA OUT NOCOPY VARCHAR2)
2396: IS
2397: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2398:
2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2588: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: x_msg_data := SUBSTR(SQLERRM,1,240);
2587: FND_MSG_PUB.add_exc_msg
2588: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2589: ,p_procedure_name => 'UPD_TGT_RATE_BASED_FLAG');
2590: IF P_PA_DEBUG_MODE = 'Y' THEN
2591: pa_debug.write_log(
2592: x_module => l_module_name,

Line 2600: END PA_FP_GEN_FCST_AMT_PVT;

2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END UPD_TGT_RATE_BASED_FLAG;
2599:
2600: END PA_FP_GEN_FCST_AMT_PVT;