DBA Data[Home] [Help]

APPS.PA_FP_CALC_UTILS dependencies on PA_FP_CALC_PLAN_PKG

Line 4497: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4493: AND i.pfc_cur_conv_rejection_code is NULL */
4494: ) Then
4495:
4496: /* before updating the existing budget line call the reporting API to pass -ve amts */
4497: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4498: (p_calling_module => 'CALCULATE_API'
4499: ,p_activity_code => 'UPDATE'
4500: ,p_budget_version_id => p_budget_version_id
4501: ,p_budget_line_id => i.budget_line_id

Line 4596: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4592: AND l_r_pfc_cur_rejection_code_tab(i) is NULL */
4593: ) Then
4594:
4595: /* After updating the budget line dates, pass the +ve values */
4596: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4597: (p_calling_module => 'CALCULATE_API'
4598: ,p_activity_code => 'UPDATE'
4599: ,p_budget_version_id => p_budget_version_id
4600: ,p_budget_line_id => l_r_budget_line_id_tab(i)

Line 4719: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');

4715: l_resAsgn_id_tab pa_plsql_datatypes.NumTabTyp;
4716: l_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
4717: l_start_date_tab pa_plsql_datatypes.dateTabTyp;
4718: l_rwCounter INTEGER;
4719: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
4720: BEGIN
4721: x_return_status := 'S';
4722: /* Initialize the error stack */
4723: If p_pa_debug_mode = 'Y' Then

Line 4754: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4750: AND i.pfc_cur_conv_rejection_code is NULL */
4751: ) Then
4752:
4753: /* before updating the existing budget line call the reporting API to pass -ve amts */
4754: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4755: (p_calling_module => 'CALCULATE_API'
4756: ,p_activity_code => 'UPDATE'
4757: ,p_budget_version_id => p_budget_version_id
4758: ,p_budget_line_id => i.budget_line_id

Line 4784: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs

4780: End If;
4781:
4782: /* Added for MRC enhancements */
4783: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then --{
4784: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs
4785: (p_calling_module => 'CALCULATE_API'
4786: ,p_budget_version_id => p_budget_version_id
4787: ,p_budget_line_id => i.budget_line_id
4788: ,p_resource_assignment_id => i.resource_assignment_id

Line 4934: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');

4930: l_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
4931: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
4932:
4933: l_rwCounter Number;
4934: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
4935:
4936: BEGIN
4937:
4938: x_return_status := 'S';

Line 4997: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4993: AND i.pfc_cur_conv_rejection_code is NULL */
4994: ) Then
4995:
4996: /* before updating the existing budget line call the reporting API to pass -ve amts */
4997: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4998: (p_calling_module => 'CALCULATE_API'
4999: ,p_activity_code => 'UPDATE'
5000: ,p_budget_version_id => p_budget_version_id
5001: ,p_budget_line_id => i.budget_line_id

Line 5078: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

5074: AND i.pfc_cur_conv_rejection_code is NULL */
5075: ) Then
5076:
5077: /* before updating the existing budget line call the reporting API to pass -ve amts */
5078: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
5079: (p_calling_module => 'CALCULATE_API'
5080: ,p_activity_code => 'UPDATE'
5081: ,p_budget_version_id => p_budget_version_id
5082: ,p_budget_line_id => i.budget_line_id

Line 5108: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs

5104: END IF;
5105:
5106: /* Added for MRC enhancements */
5107: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then --{
5108: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs
5109: (p_calling_module => 'CALCULATE_API'
5110: ,p_budget_version_id => p_budget_version_id
5111: ,p_budget_line_id => i.budget_line_id
5112: ,p_resource_assignment_id => i.resource_assignment_id

Line 5213: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

5209: If p_rollup_required_flag = 'Y' Then
5210: FOR i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST LOOP
5211: IF NVL(l_quantity_tab(i),0) <> 0 Then
5212: /* before updating the existing budget line call the reporting API to pass -ve amts */
5213: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
5214: (p_calling_module => 'CALCULATE_API'
5215: ,p_activity_code => 'UPDATE'
5216: ,p_budget_version_id => p_budget_version_id
5217: ,p_budget_line_id => l_budget_line_id_tab(i)

Line 8110: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');

8106: ,x_msg_data OUT NOCOPY VARCHAR2) IS
8107:
8108: l_debug_mode VARCHAR2(30);
8109: l_stage NUMBER;
8110: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
8111: l_existing_bl_id pa_budget_lines.budget_line_id%TYPE;
8112:
8113: l_bl_raId_tab pa_plsql_datatypes.NumTabTyp;
8114: l_bl_sDate_tab pa_plsql_datatypes.dateTabTyp;

Line 8840: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

8836: EXCEPTION
8837: WHEN OTHERS THEN
8838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8839: fnd_msg_pub.add_exc_msg
8840: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
8841: ,p_procedure_name => 'Populate_blkExcpRecs' );
8842: print_msg('Exception from Populate_blkExcpRecs ['||substr(SQLERRM,1,240));
8843: RAISE;
8844:

Line 8932: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

8928: EXCEPTION
8929: WHEN OTHERS THEN
8930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8931: fnd_msg_pub.add_exc_msg
8932: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
8933: ,p_procedure_name => 'Populate_ExistingBlRecs' );
8934: print_msg('Exception from Populate_ExistingBlRecs api['|| substr(SQLERRM,1,240));
8935: RAISE;
8936:

Line 8944: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');

8940:
8941: x_return_status := FND_API.G_RET_STS_SUCCESS;
8942: l_return_status := 'S';
8943: If p_pa_debug_mode = 'Y' Then
8944: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
8945: End If;
8946: IF P_PA_DEBUG_MODE = 'Y' Then
8947: print_msg('Entered PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
8948: End If;

Line 8947: print_msg('Entered PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');

8943: If p_pa_debug_mode = 'Y' Then
8944: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
8945: End If;
8946: IF P_PA_DEBUG_MODE = 'Y' Then
8947: print_msg('Entered PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
8948: End If;
8949: l_stage := 4000;
8950: InitPlsqlTabs;
8951: OPEN Cur_RollupLines;

Line 9078: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9074: IF blRec.budget_line_id is NOT NULL Then
9075: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9076: l_stage := 4028;
9077: --print_msg('Calling Add_Toreporting_Tabls api by old -ve amts of bl['||(blRec.quantity * -1)||']Cur['||blRec.txn_currency_code||']');
9078: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9079: (p_calling_module => 'CALCULATE_API'
9080: ,p_activity_code => 'UPDATE'
9081: ,p_budget_version_id => p_budget_version_id
9082: ,p_budget_line_id => blRec.budget_line_id

Line 9279: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9275: IF blRec.budget_line_id is NOT NULL Then
9276: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9277: l_stage := 4022;
9278: --print_msg('Calling Add_Toreporting_Tabls api by sending old +ve amts of bl['||(blRec.quantity)||']Cur['||blRec.txn_currency_code||']');
9279: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9280: (p_calling_module => 'CALCULATE_API'
9281: ,p_activity_code => 'UPDATE'
9282: ,p_budget_version_id => p_budget_version_id
9283: ,p_budget_line_id => blRec.budget_line_id

Line 9393: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9389: IF blRec.budget_line_id is NOT NULL Then
9390: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9391: l_stage := 4028;
9392: --print_msg('Calling Add_Toreporting_Tabls api by sending old +ve amts of bl['||(blRec.quantity)||']Cur['||blRec.txn_currency_code||']');
9393: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9394: (p_calling_module => 'CALCULATE_API'
9395: ,p_activity_code => 'UPDATE'
9396: ,p_budget_version_id => p_budget_version_id
9397: ,p_budget_line_id => blRec.budget_line_id

Line 9470: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9466: IF blRec.budget_line_id is NOT NULL Then
9467: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9468: l_stage := 4028;
9469: --print_msg('Calling Add_Toreporting_Tabls by old -ve amts of bl['||(blRec.quantity *-1)||']Cur['||blRec.txn_currency_code||']');
9470: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9471: (p_calling_module => 'CALCULATE_API'
9472: ,p_activity_code => 'UPDATE'
9473: ,p_budget_version_id => p_budget_version_id
9474: ,p_budget_line_id => blRec.budget_line_id

Line 9827: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9823: FOR blRec IN cur_ExistingblAmts LOOP
9824: IF blRec.budget_line_id is NOT NULL Then
9825: l_stage := 4028;
9826: --print_msg('Calling ExistAdd_Toreporting_Tabls api by New +ve amts of bl qty['||blRec.quantity||']cur['||blRec.txn_currency_code||']');
9827: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9828: (p_calling_module => 'CALCULATE_API'
9829: ,p_activity_code => 'UPDATE'
9830: ,p_budget_version_id => p_budget_version_id
9831: ,p_budget_line_id => blRec.budget_line_id

Line 9879: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

9875: WHEN OTHERS THEN
9876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9877: x_msg_data := SQLCODE||SQLERRM;
9878: fnd_msg_pub.add_exc_msg
9879: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
9880: ,p_procedure_name => 'BLK_update_budget_lines' );
9881: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
9882: l_stage := 4120;
9883: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));