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_UTILS

Line 1: PACKAGE BODY PA_FP_CALC_UTILS AS

1: PACKAGE BODY PA_FP_CALC_UTILS AS
2: --$Header: PAFPCL1B.pls 120.34.12020000.3 2012/07/30 12:33:54 tvala ship $
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_CALC_UTILS';
5: g_stage Varchar2(1000);

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_CALC_UTILS';

1: PACKAGE BODY PA_FP_CALC_UTILS AS
2: --$Header: PAFPCL1B.pls 120.34.12020000.3 2012/07/30 12:33:54 tvala ship $
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_CALC_UTILS';
5: g_stage Varchar2(1000);
6: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
7: g_LAST_UPDATE_DATE Date := SYSDATE;
8: g_LAST_UPDATED_BY Number:= fnd_global.user_id;

Line 382: ( p_pkg_name => 'PA_FP_CALC_UTILS'

378: WHEN OTHERS THEN
379: x_return_status := 'U';
380: print_msg('Failed in Check_ZeroQty_ActualBlsAPI'||sqlcode||sqlerrm);
381: fnd_msg_pub.add_exc_msg
382: ( p_pkg_name => 'PA_FP_CALC_UTILS'
383: ,p_procedure_name => 'Check_ZeroQty_Bls');
384: RAISE;
385: END Check_ZeroQty_Bls;
386:

Line 2149: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2145: x_return_status := 'U';
2146: x_msg_data := sqlcode||sqlerrm;
2147: print_msg('Failed in Compare_bdgtLine_Values API'||x_msg_data);
2148: fnd_msg_pub.add_exc_msg
2149: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2150: ,p_procedure_name => 'Compare_bdgtLine_Values');
2151: RAISE;
2152:
2153: END Compare_bdgtLine_Values;

Line 2316: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2312: WHEN OTHERS THEN
2313: x_return_status := 'U';
2314: print_msg('Failed in process_NonRtBsRec_forSprd'||sqlcode||sqlerrm);
2315: fnd_msg_pub.add_exc_msg
2316: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2317: ,p_procedure_name => 'process_NonRtBsRec_forSprd');
2318: RAISE;
2319: END process_NonRtBsRec_forSprd;
2320:

Line 2606: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2602: WHEN OTHERS THEN
2603: x_return_status := 'U';
2604: print_msg('Failed in pre_process_Revenue_Only_RecsAPI'||sqlcode||sqlerrm);
2605: fnd_msg_pub.add_exc_msg
2606: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2607: ,p_procedure_name => 'pre_process_Revenue_Only_Recs');
2608: RAISE;
2609: END pre_process_Revenue_Only_Recs;
2610:

Line 3490: ( p_pkg_name => 'PA_FP_CALC_UTILS'

3486: WHEN OTHERS THEN
3487: x_return_status := 'U';
3488: print_msg('Failed in Reset_ratebased_pltrxns API'||sqlcode||sqlerrm);
3489: fnd_msg_pub.add_exc_msg
3490: ( p_pkg_name => 'PA_FP_CALC_UTILS'
3491: ,p_procedure_name => 'Reset_ratebased_pltrxns');
3492: RAISE;
3493:
3494: END Reset_ratebased_pltrxns;

Line 4218: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4214: WHEN OTHERS THEN
4215: x_return_status := 'U';
4216: print_msg('Failed in Check_ratebased_pltrxns API'||sqlcode||sqlerrm);
4217: fnd_msg_pub.add_exc_msg
4218: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4219: ,p_procedure_name => 'Check_ratebased_pltrxns');
4220: RAISE;
4221: END Check_ratebased_pltrxns;
4222:

Line 4328: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4324: WHEN OTHERS THEN
4325: x_return_status := 'U';
4326: print_msg('Failed in Check_GLPA_periods_exists API'||sqlcode||sqlerrm);
4327: fnd_msg_pub.add_exc_msg
4328: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4329: ,p_procedure_name => 'Check_GLPA_periods_exists');
4330: RAISE;
4331:
4332: END Check_GLPA_periods_exists;

Line 4670: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4666: x_return_status := 'U';
4667: x_msg_data := sqlcode||sqlerrm;
4668: print_msg('Failed in process_NonTimePhase_Lines API'||x_msg_data);
4669: fnd_msg_pub.add_exc_msg
4670: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4671: ,p_procedure_name => 'process_NonTimePhase_Lines');
4672: RAISE;
4673: END process_NonTimePhase_Lines;
4674:

Line 4753: pa_debug.init_err_stack('PA_FP_CALC_UTILS.delete_budget_lines');

4749: BEGIN
4750: x_return_status := 'S';
4751: /* Initialize the error stack */
4752: If p_pa_debug_mode = 'Y' Then
4753: pa_debug.init_err_stack('PA_FP_CALC_UTILS.delete_budget_lines');
4754: End If;
4755:
4756: --print_msg('Entered delete_budget_lines api');
4757: /* Initialize the plsql tabs */

Line 4866: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4862: If p_pa_debug_mode = 'Y' Then
4863: pa_debug.reset_err_stack;
4864: End If;
4865: fnd_msg_pub.add_exc_msg
4866: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4867: ,p_procedure_name => 'delete_budget_lines');
4868: RAISE;
4869: END delete_budget_lines ;
4870:

Line 4970: pa_debug.init_err_stack('PA_FP_CALC_UTILS.insert_budget_lines');

4966:
4967: x_return_status := 'S';
4968: /* Initialize the error stack */
4969: If p_pa_debug_mode = 'Y' Then
4970: pa_debug.init_err_stack('PA_FP_CALC_UTILS.insert_budget_lines');
4971: End If;
4972: --print_msg('Entered insert_budget_lines api');
4973: /* Initialize the plsql tabs */
4974: l_budget_line_id_tab.delete;

Line 5289: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5285: If p_pa_debug_mode = 'Y' Then
5286: pa_debug.reset_err_stack;
5287: End If;
5288: fnd_msg_pub.add_exc_msg
5289: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5290: ,p_procedure_name => 'insert_budget_lines');
5291: RAISE;
5292: END insert_budget_lines;
5293:

Line 5367: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5363: If p_pa_debug_mode = 'Y' Then
5364: pa_debug.reset_err_stack;
5365: End If;
5366: fnd_msg_pub.add_exc_msg
5367: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5368: ,p_procedure_name => 'process_ResAttribs');
5369: RAISE;
5370:
5371: END process_ResAttribs;

Line 5419: pa_debug.init_err_stack('PA_FP_CALC_UTILS.process_planDates_change');

5415:
5416: BEGIN
5417: x_return_status := 'S';
5418: If p_pa_debug_mode = 'Y' Then
5419: pa_debug.init_err_stack('PA_FP_CALC_UTILS.process_planDates_change');
5420: --print_msg('Entered process_planDates_change api NumLinetoProcess['||g_Rspd_RaId_tab.COUNT||']');
5421: End If;
5422: IF perdRec.time_phased_code = 'P' Then
5423: l_period_type := perdRec.pa_period_type;

Line 5565: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5561: If p_pa_debug_mode = 'Y' Then
5562: pa_debug.reset_err_stack;
5563: End If;
5564: fnd_msg_pub.add_exc_msg
5565: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5566: ,p_procedure_name => 'process_planDates_change');
5567: RAISE;
5568: END process_planDates_change;
5569:

Line 5586: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_blTxnCurCombo');

5582: /* bulk select all the RA+Txn currency combo from budget lines and later insert these records into tmp table
5583: * for processing
5584: */
5585: If p_pa_debug_mode = 'Y' Then
5586: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_blTxnCurCombo');
5587: print_msg('Entered populate_blTxnCurCombo api');
5588: End If;
5589: SELECT /*+ INDEX(BL PA_BUDGET_LINES_U1) */
5590: bl.resource_assignment_id

Line 5726: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5722: If p_pa_debug_mode = 'Y' Then
5723: pa_debug.reset_err_stack;
5724: End if;
5725: fnd_msg_pub.add_exc_msg
5726: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5727: ,p_procedure_name => 'populate_blTxnCurCombo');
5728: RAISE;
5729:
5730: END populate_blTxnCurCombo;

Line 5873: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5869: l_return_status := 'U';
5870: l_msg_data := sqlcode||sqlerrm;
5871: print_msg('Failed in synch_resAttribs API'||l_msg_data);
5872: fnd_msg_pub.add_exc_msg
5873: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5874: ,p_procedure_name => 'synch_resAttribs ');
5875: RAISE;
5876:
5877: END synch_resAttribs;

Line 6003: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5999: l_return_status := 'U';
6000: l_msg_data := sqlcode||sqlerrm;
6001: print_msg('Failed in synch_ChangedFlags API'||l_msg_data);
6002: fnd_msg_pub.add_exc_msg
6003: ( p_pkg_name => 'PA_FP_CALC_UTILS'
6004: ,p_procedure_name => 'synch_ChangedFlags');
6005: RAISE;
6006:
6007: END synch_ChangedFlags;

Line 6172: /** Bug fix: ORA-00979: not a GROUP BY expression in Package PA_FP_CALC_UTILS

6168: ,pa_resource_assignments ra
6169: WHERE tmp.budget_version_id = p_budget_version_id
6170: AND ra.resource_assignment_id = tmp.resource_assignment_id
6171: AND rl.resource_list_member_id = ra.resource_list_member_id
6172: /** Bug fix: ORA-00979: not a GROUP BY expression in Package PA_FP_CALC_UTILS
6173: AND ((decode(tmp.OLD_PLAN_START_DATE,NULL,'N'
6174: ,decode(tmp.NEW_PLAN_START_DATE,NULL,'N'
6175: ,decode(tmp.OLD_PLAN_START_DATE,tmp.NEW_PLAN_START_DATE,'N','Y'))) ='Y')
6176: OR

Line 6249: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_spreadCalc_Tmp');

6245: x_msg_data := NULL;
6246:
6247: /* Initialize the error stack */
6248: If p_pa_debug_mode = 'Y' Then
6249: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_spreadCalc_Tmp');
6250: print_msg(' Entered populate_spreadCalc_Tmp API');
6251: End If;
6252: /* populate tmp table with the data */
6253: Init_plsqlTabs;

Line 7049: ( p_pkg_name => 'PA_FP_CALC_UTILS'

7045: x_return_status := 'U';
7046: x_msg_data := sqlcode||sqlerrm;
7047: print_msg('Failed in populate_spreadTmp_OvrRates API'||x_msg_data);
7048: fnd_msg_pub.add_exc_msg
7049: ( p_pkg_name => 'PA_FP_CALC_UTILS'
7050: ,p_procedure_name => 'populate_spreadCalc_Tmp ');
7051: If p_pa_debug_mode = 'Y' Then
7052: pa_debug.reset_err_stack;
7053: End If;

Line 7094: pa_debug.init_err_stack('PA_FP_CALC_UTILS.cache_rates');

7090: OR tmp.mfc_cost_change_flag = 'Y' );
7091: BEGIN
7092: /* Initialize the error stack */
7093: If p_pa_debug_mode = 'Y' Then
7094: pa_debug.init_err_stack('PA_FP_CALC_UTILS.cache_rates');
7095: End If;
7096: x_return_status := 'S';
7097: x_msg_data := NULL;
7098:

Line 7343: ( p_pkg_name => 'PA_FP_CALC_UTILS'

7339: x_return_status := 'U';
7340: x_msg_data := sqlcode||sqlerrm;
7341: print_msg('Failed in cache_rates API'||x_msg_data);
7342: fnd_msg_pub.add_exc_msg
7343: ( p_pkg_name => 'PA_FP_CALC_UTILS'
7344: ,p_procedure_name => 'cache_rates');
7345: If p_pa_debug_mode = 'Y' Then
7346: pa_debug.reset_err_stack;
7347: End If;

Line 7841: pa_debug.init_err_stack('PA_FP_CALC_UTILS.copy_BlAttributes');

7837: /* Initialize the out variables */
7838: x_return_status := 'S';
7839: x_msg_data := NULL;
7840: If p_pa_debug_mode = 'Y' Then
7841: pa_debug.init_err_stack('PA_FP_CALC_UTILS.copy_BlAttributes');
7842: End If;
7843: IF p_calling_module NOT IN ('BUDGET_GENERATION','FORECAST_GENERATION') Then --{
7844: IF P_PA_DEBUG_MODE = 'Y' Then
7845: print_msg('Entered copy_BlAttributes API');

Line 8023: ( p_pkg_name => 'PA_FP_CALC_UTILS'

8019: WHEN OTHERS THEN
8020: x_return_status := 'U';
8021: x_msg_data := SQLCODE||SQLERRM;
8022: fnd_msg_pub.add_exc_msg
8023: ( p_pkg_name => 'PA_FP_CALC_UTILS'
8024: ,p_procedure_name => 'copy_BlAttributes');
8025: If p_pa_debug_mode = 'Y' Then
8026: pa_debug.reset_err_stack;
8027: End If;

Line 8880: pa_debug.init_err_stack('PA_FP_CALC_UTILS.Update_rounding_diff_bl');

8876: l_return_status := 'S';
8877: l_msg_count := 0;
8878: l_msg_data := NULL;
8879: IF p_pa_debug_mode = 'Y' Then
8880: pa_debug.init_err_stack('PA_FP_CALC_UTILS.Update_rounding_diff_bl');
8881: End If;
8882:
8883: g_stage := 'Update_rounding_diff_bl:100';
8884: pa_debug.g_err_stage := 'Entered Update_rounding_diff_bl API';

Line 8981: ( p_pkg_name => 'PA_FP_CALC_UTILS'

8977: print_msg('Failed in Update_rounding_diff_bl API ['||sqlcode||sqlerrm);
8978: x_return_status := 'U';
8979: x_msg_data := sqlcode||sqlerrm;
8980: fnd_msg_pub.add_exc_msg
8981: ( p_pkg_name => 'PA_FP_CALC_UTILS'
8982: ,p_procedure_name => 'Update_rounding_diff_bl' );
8983: print_msg('Failed in Update_rounding_diff_bl substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
8984: IF p_pa_debug_mode = 'Y' Then
8985: pa_debug.reset_err_stack;

Line 10493: pa_debug.init_err_stack('PA_FP_CALC_UTILS.update_dffcols');

10489: x_return_status := 'S';
10490: x_msg_data := NULL;
10491: x_msg_count := fnd_msg_pub.count_msg;
10492: If p_pa_debug_mode = 'Y' Then
10493: pa_debug.init_err_stack('PA_FP_CALC_UTILS.update_dffcols');
10494: End If;
10495: IF p_calling_module NOT IN ('BUDGET_GENERATION','FORECAST_GENERATION') Then --{
10496: INIT_PLSQL_TABS;
10497: --print_msg('Fetching budget Line Attributes such as DFFs details from cache ');

Line 10838: ( p_pkg_name => 'PA_FP_CALC_UTILS'

10834: WHEN OTHERS THEN
10835: x_return_status := 'U';
10836: x_msg_data := SQLCODE||SQLERRM;
10837: fnd_msg_pub.add_exc_msg
10838: ( p_pkg_name => 'PA_FP_CALC_UTILS'
10839: ,p_procedure_name => 'update_dffcols');
10840: If p_pa_debug_mode = 'Y' Then
10841: pa_debug.reset_err_stack;
10842: End If;

Line 11156: ( p_pkg_name => 'PA_FP_CALC_UTILS'

11152: WHEN OTHERS THEN
11153: x_return_status := 'U';
11154: print_msg('Error occured in InsertFunding_ReqdLines['|| SQLCODE||SQLERRM);
11155: fnd_msg_pub.add_exc_msg
11156: ( p_pkg_name => 'PA_FP_CALC_UTILS'
11157: ,p_procedure_name => 'InsertFunding_ReqdLines');
11158: RAISE;
11159:
11160: END InsertFunding_ReqdLines;

Line 11163: END PA_FP_CALC_UTILS;

11159:
11160: END InsertFunding_ReqdLines;
11161:
11162:
11163: END PA_FP_CALC_UTILS;