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.6 2007/02/06 09:54:11 dthakker ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /*=======================================================================================

Line 1251: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1247: WHEN OTHERS THEN
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: x_msg_data := SUBSTR(SQLERRM,1,240);
1250: FND_MSG_PUB.add_exc_msg
1251: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1252: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');
1253: IF P_PA_DEBUG_MODE = 'Y' THEN
1254: pa_fp_gen_amount_utils.fp_debug
1255: (p_called_mode => p_calling_context,

Line 1318: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1314: WHEN OTHERS THEN
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: x_msg_data := SUBSTR(SQLERRM,1,240);
1317: FND_MSG_PUB.add_exc_msg
1318: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1319: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');
1320: IF P_PA_DEBUG_MODE = 'Y' THEN
1321: pa_fp_gen_amount_utils.fp_debug
1322: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 1938: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

1934: WHEN OTHERS THEN
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: x_msg_data := SUBSTR(SQLERRM,1,240);
1937: FND_MSG_PUB.add_exc_msg
1938: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1939: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');
1940: IF P_PA_DEBUG_MODE = 'Y' THEN
1941: pa_fp_gen_amount_utils.fp_debug
1942: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

1982: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
1983: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1984: AND adjustment_period_flag = 'N';
1985:
1986: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
1987: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
1988: l_future_no_of_period NUMBER;
1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;

Line 2122: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'

2118: the sum of init qty,cost and rev for the given period */
2119: IF p_pa_debug_mode = 'Y' THEN
2120: pa_fp_gen_amount_utils.fp_debug
2121: (p_msg => 'Before calling
2122: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount:'
2123: ||'P_RES_ASG_ID:'||l_res_asg_id
2124: ||';P_ACTUAL_FROM_DATE:'||l_actual_from_date
2125: ||';P_ACTUAL_TO_DATE:'||l_actual_to_date
2126: ||';P_CURRENCY_FLAG:'||P_CURRENCY_FLAG,

Line 2130: PA_FP_GEN_FCST_AMT_PVT.GET_ACTUAL_TXN_AMOUNT

2126: ||';P_CURRENCY_FLAG:'||P_CURRENCY_FLAG,
2127: p_module_name => l_module_name,
2128: p_log_level => 5);
2129: END IF;
2130: PA_FP_GEN_FCST_AMT_PVT.GET_ACTUAL_TXN_AMOUNT
2131: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2132: P_TASK_ID => P_TASK_ID,
2133: P_RES_LIST_MEMBER_ID => P_RES_LIST_MEMBER_ID,
2134: P_RES_ASG_ID => l_res_asg_id,

Line 2150: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '

2146: END IF;
2147: IF p_pa_debug_mode = 'Y' THEN
2148: pa_fp_gen_amount_utils.fp_debug
2149: (p_msg => 'Status after calling
2150: pa_fp_gen_fcst_amt_pvt.get_actual_txn_amount: '
2151: ||x_return_status,
2152: p_module_name => l_module_name,
2153: p_log_level => 5);
2154: END IF;

Line 2334: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: x_msg_data := SUBSTR(SQLERRM,1,240);
2333: FND_MSG_PUB.add_exc_msg
2334: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2335: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');
2336: IF P_PA_DEBUG_MODE = 'Y' THEN
2337: pa_fp_gen_amount_utils.fp_debug
2338: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

2360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2361: X_MSG_COUNT OUT NOCOPY NUMBER,
2362: X_MSG_DATA OUT NOCOPY VARCHAR2)
2363: IS
2364: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2365:
2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 2555: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'

2551: WHEN OTHERS THEN
2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2553: x_msg_data := SUBSTR(SQLERRM,1,240);
2554: FND_MSG_PUB.add_exc_msg
2555: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2556: ,p_procedure_name => 'UPD_TGT_RATE_BASED_FLAG');
2557: IF P_PA_DEBUG_MODE = 'Y' THEN
2558: pa_debug.write_log(
2559: x_module => l_module_name,

Line 2567: END PA_FP_GEN_FCST_AMT_PVT;

2563: END IF;
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END UPD_TGT_RATE_BASED_FLAG;
2566:
2567: END PA_FP_GEN_FCST_AMT_PVT;