eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CALC_UTILS dependencies on PA_FP_CALC_PLAN_PKG

Line 4526: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4522: AND i.pfc_cur_conv_rejection_code is NULL */
4523: ) Then
4524:
4525: /* before updating the existing budget line call the reporting API to pass -ve amts */
4526: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4527: (p_calling_module => 'CALCULATE_API'
4528: ,p_activity_code => 'UPDATE'
4529: ,p_budget_version_id => p_budget_version_id
4530: ,p_budget_line_id => i.budget_line_id

Line 4625: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4621: AND l_r_pfc_cur_rejection_code_tab(i) is NULL */
4622: ) Then
4623:
4624: /* After updating the budget line dates, pass the +ve values */
4625: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4626: (p_calling_module => 'CALCULATE_API'
4627: ,p_activity_code => 'UPDATE'
4628: ,p_budget_version_id => p_budget_version_id
4629: ,p_budget_line_id => l_r_budget_line_id_tab(i)

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

4744: l_resAsgn_id_tab pa_plsql_datatypes.NumTabTyp;
4745: l_txn_curr_code_tab pa_plsql_datatypes.Char50TabTyp;
4746: l_start_date_tab pa_plsql_datatypes.dateTabTyp;
4747: l_rwCounter INTEGER;
4748: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
4749: BEGIN
4750: x_return_status := 'S';
4751: /* Initialize the error stack */
4752: If p_pa_debug_mode = 'Y' Then

Line 4783: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

4779: AND i.pfc_cur_conv_rejection_code is NULL */
4780: ) Then
4781:
4782: /* before updating the existing budget line call the reporting API to pass -ve amts */
4783: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
4784: (p_calling_module => 'CALCULATE_API'
4785: ,p_activity_code => 'UPDATE'
4786: ,p_budget_version_id => p_budget_version_id
4787: ,p_budget_line_id => i.budget_line_id

Line 4813: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs

4809: End If;
4810:
4811: /* Added for MRC enhancements */
4812: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then --{
4813: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs
4814: (p_calling_module => 'CALCULATE_API'
4815: ,p_budget_version_id => p_budget_version_id
4816: ,p_budget_line_id => i.budget_line_id
4817: ,p_resource_assignment_id => i.resource_assignment_id

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

4959: l_txn_burden_cost_tab pa_plsql_datatypes.NumTabTyp;
4960: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
4961:
4962: l_rwCounter Number;
4963: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
4964:
4965: BEGIN
4966:
4967: x_return_status := 'S';

Line 5026: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

5022: AND i.pfc_cur_conv_rejection_code is NULL */
5023: ) Then
5024:
5025: /* before updating the existing budget line call the reporting API to pass -ve amts */
5026: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
5027: (p_calling_module => 'CALCULATE_API'
5028: ,p_activity_code => 'UPDATE'
5029: ,p_budget_version_id => p_budget_version_id
5030: ,p_budget_line_id => i.budget_line_id

Line 5107: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

5103: AND i.pfc_cur_conv_rejection_code is NULL */
5104: ) Then
5105:
5106: /* before updating the existing budget line call the reporting API to pass -ve amts */
5107: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
5108: (p_calling_module => 'CALCULATE_API'
5109: ,p_activity_code => 'UPDATE'
5110: ,p_budget_version_id => p_budget_version_id
5111: ,p_budget_line_id => i.budget_line_id

Line 5137: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs

5133: END IF;
5134:
5135: /* Added for MRC enhancements */
5136: IF NVL(l_populate_mrc_tab_flag,'N') = 'Y' Then --{
5137: PA_FP_CALC_PLAN_PKG.populate_MRC_plsqltabs
5138: (p_calling_module => 'CALCULATE_API'
5139: ,p_budget_version_id => p_budget_version_id
5140: ,p_budget_line_id => i.budget_line_id
5141: ,p_resource_assignment_id => i.resource_assignment_id

Line 5242: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

5238: If p_rollup_required_flag = 'Y' Then
5239: FOR i IN l_budget_line_id_tab.FIRST .. l_budget_line_id_tab.LAST LOOP
5240: IF NVL(l_quantity_tab(i),0) <> 0 Then
5241: /* before updating the existing budget line call the reporting API to pass -ve amts */
5242: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
5243: (p_calling_module => 'CALCULATE_API'
5244: ,p_activity_code => 'UPDATE'
5245: ,p_budget_version_id => p_budget_version_id
5246: ,p_budget_line_id => l_budget_line_id_tab(i)

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

8137: ,x_msg_data OUT NOCOPY VARCHAR2) IS
8138:
8139: l_debug_mode VARCHAR2(30);
8140: l_stage NUMBER;
8141: l_populate_mrc_tab_flag Varchar2(10) := 'N'; --MRC Elimination Changes:NVL(PA_FP_CALC_PLAN_PKG.G_populate_mrc_tab_flag,'N');
8142: l_existing_bl_id pa_budget_lines.budget_line_id%TYPE;
8143:
8144: l_bl_raId_tab pa_plsql_datatypes.NumTabTyp;
8145: l_bl_sDate_tab pa_plsql_datatypes.dateTabTyp;

Line 9072: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

9068: EXCEPTION
9069: WHEN OTHERS THEN
9070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9071: fnd_msg_pub.add_exc_msg
9072: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
9073: ,p_procedure_name => 'Populate_blkExcpRecs' );
9074: print_msg('Exception from Populate_blkExcpRecs ['||substr(SQLERRM,1,240));
9075: RAISE;
9076:

Line 9164: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

9160: EXCEPTION
9161: WHEN OTHERS THEN
9162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9163: fnd_msg_pub.add_exc_msg
9164: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
9165: ,p_procedure_name => 'Populate_ExistingBlRecs' );
9166: print_msg('Exception from Populate_ExistingBlRecs api['|| substr(SQLERRM,1,240));
9167: RAISE;
9168:

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

9172:
9173: x_return_status := FND_API.G_RET_STS_SUCCESS;
9174: l_return_status := 'S';
9175: If p_pa_debug_mode = 'Y' Then
9176: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
9177: End If;
9178: IF P_PA_DEBUG_MODE = 'Y' Then
9179: print_msg('Entered PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
9180: End If;

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

9175: If p_pa_debug_mode = 'Y' Then
9176: pa_debug.init_err_stack('PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
9177: End If;
9178: IF P_PA_DEBUG_MODE = 'Y' Then
9179: print_msg('Entered PA_FP_CALC_PLAN_PKG.BLK_update_budget_lines');
9180: End If;
9181: l_stage := 4000;
9182: InitPlsqlTabs;
9183: OPEN Cur_RollupLines;

Line 9310: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9306: IF blRec.budget_line_id is NOT NULL Then
9307: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9308: l_stage := 4028;
9309: --print_msg('Calling Add_Toreporting_Tabls api by old -ve amts of bl['||(blRec.quantity * -1)||']Cur['||blRec.txn_currency_code||']');
9310: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9311: (p_calling_module => 'CALCULATE_API'
9312: ,p_activity_code => 'UPDATE'
9313: ,p_budget_version_id => p_budget_version_id
9314: ,p_budget_line_id => blRec.budget_line_id

Line 9513: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9509: IF blRec.budget_line_id is NOT NULL Then
9510: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9511: l_stage := 4022;
9512: --print_msg('Calling Add_Toreporting_Tabls api by sending old +ve amts of bl['||(blRec.quantity)||']Cur['||blRec.txn_currency_code||']');
9513: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9514: (p_calling_module => 'CALCULATE_API'
9515: ,p_activity_code => 'UPDATE'
9516: ,p_budget_version_id => p_budget_version_id
9517: ,p_budget_line_id => blRec.budget_line_id

Line 9627: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9623: IF blRec.budget_line_id is NOT NULL Then
9624: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9625: l_stage := 4028;
9626: --print_msg('Calling Add_Toreporting_Tabls api by sending old +ve amts of bl['||(blRec.quantity)||']Cur['||blRec.txn_currency_code||']');
9627: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9628: (p_calling_module => 'CALCULATE_API'
9629: ,p_activity_code => 'UPDATE'
9630: ,p_budget_version_id => p_budget_version_id
9631: ,p_budget_line_id => blRec.budget_line_id

Line 9704: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

9700: IF blRec.budget_line_id is NOT NULL Then
9701: --print_msg('Getting Budget line Amts for budget_line_id => '||to_char(blrec.budget_line_id));
9702: l_stage := 4028;
9703: --print_msg('Calling Add_Toreporting_Tabls by old -ve amts of bl['||(blRec.quantity *-1)||']Cur['||blRec.txn_currency_code||']');
9704: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
9705: (p_calling_module => 'CALCULATE_API'
9706: ,p_activity_code => 'UPDATE'
9707: ,p_budget_version_id => p_budget_version_id
9708: ,p_budget_line_id => blRec.budget_line_id

Line 10073: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls

10069: FOR blRec IN cur_ExistingblAmts LOOP
10070: IF blRec.budget_line_id is NOT NULL Then
10071: l_stage := 4028;
10072: --print_msg('Calling ExistAdd_Toreporting_Tabls api by New +ve amts of bl qty['||blRec.quantity||']cur['||blRec.txn_currency_code||']');
10073: PA_FP_CALC_PLAN_PKG.Add_Toreporting_Tabls
10074: (p_calling_module => 'CALCULATE_API'
10075: ,p_activity_code => 'UPDATE'
10076: ,p_budget_version_id => p_budget_version_id
10077: ,p_budget_line_id => blRec.budget_line_id

Line 10125: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'

10121: WHEN OTHERS THEN
10122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10123: x_msg_data := SQLCODE||SQLERRM;
10124: fnd_msg_pub.add_exc_msg
10125: ( p_pkg_name => 'PA_FP_CALC_PLAN_PKG'
10126: ,p_procedure_name => 'BLK_update_budget_lines' );
10127: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
10128: l_stage := 4120;
10129: print_msg(to_char(l_stage)||' substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));