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.20.12010000.11 2009/01/28 07:39:38 amehrotr 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.20.12010000.11 2009/01/28 07:39:38 amehrotr 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 375: ( p_pkg_name => 'PA_FP_CALC_UTILS'

371: WHEN OTHERS THEN
372: x_return_status := 'U';
373: print_msg('Failed in Check_ZeroQty_ActualBlsAPI'||sqlcode||sqlerrm);
374: fnd_msg_pub.add_exc_msg
375: ( p_pkg_name => 'PA_FP_CALC_UTILS'
376: ,p_procedure_name => 'Check_ZeroQty_Bls');
377: RAISE;
378: END Check_ZeroQty_Bls;
379:

Line 2140: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2136: x_return_status := 'U';
2137: x_msg_data := sqlcode||sqlerrm;
2138: print_msg('Failed in Compare_bdgtLine_Values API'||x_msg_data);
2139: fnd_msg_pub.add_exc_msg
2140: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2141: ,p_procedure_name => 'Compare_bdgtLine_Values');
2142: RAISE;
2143:
2144: END Compare_bdgtLine_Values;

Line 2307: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2303: WHEN OTHERS THEN
2304: x_return_status := 'U';
2305: print_msg('Failed in process_NonRtBsRec_forSprd'||sqlcode||sqlerrm);
2306: fnd_msg_pub.add_exc_msg
2307: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2308: ,p_procedure_name => 'process_NonRtBsRec_forSprd');
2309: RAISE;
2310: END process_NonRtBsRec_forSprd;
2311:

Line 2597: ( p_pkg_name => 'PA_FP_CALC_UTILS'

2593: WHEN OTHERS THEN
2594: x_return_status := 'U';
2595: print_msg('Failed in pre_process_Revenue_Only_RecsAPI'||sqlcode||sqlerrm);
2596: fnd_msg_pub.add_exc_msg
2597: ( p_pkg_name => 'PA_FP_CALC_UTILS'
2598: ,p_procedure_name => 'pre_process_Revenue_Only_Recs');
2599: RAISE;
2600: END pre_process_Revenue_Only_Recs;
2601:

Line 3462: ( p_pkg_name => 'PA_FP_CALC_UTILS'

3458: WHEN OTHERS THEN
3459: x_return_status := 'U';
3460: print_msg('Failed in Reset_ratebased_pltrxns API'||sqlcode||sqlerrm);
3461: fnd_msg_pub.add_exc_msg
3462: ( p_pkg_name => 'PA_FP_CALC_UTILS'
3463: ,p_procedure_name => 'Reset_ratebased_pltrxns');
3464: RAISE;
3465:
3466: END Reset_ratebased_pltrxns;

Line 4190: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4186: WHEN OTHERS THEN
4187: x_return_status := 'U';
4188: print_msg('Failed in Check_ratebased_pltrxns API'||sqlcode||sqlerrm);
4189: fnd_msg_pub.add_exc_msg
4190: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4191: ,p_procedure_name => 'Check_ratebased_pltrxns');
4192: RAISE;
4193: END Check_ratebased_pltrxns;
4194:

Line 4299: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4295: WHEN OTHERS THEN
4296: x_return_status := 'U';
4297: print_msg('Failed in Check_GLPA_periods_exists API'||sqlcode||sqlerrm);
4298: fnd_msg_pub.add_exc_msg
4299: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4300: ,p_procedure_name => 'Check_GLPA_periods_exists');
4301: RAISE;
4302:
4303: END Check_GLPA_periods_exists;

Line 4641: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4637: x_return_status := 'U';
4638: x_msg_data := sqlcode||sqlerrm;
4639: print_msg('Failed in process_NonTimePhase_Lines API'||x_msg_data);
4640: fnd_msg_pub.add_exc_msg
4641: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4642: ,p_procedure_name => 'process_NonTimePhase_Lines');
4643: RAISE;
4644: END process_NonTimePhase_Lines;
4645:

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

4720: BEGIN
4721: x_return_status := 'S';
4722: /* Initialize the error stack */
4723: If p_pa_debug_mode = 'Y' Then
4724: pa_debug.init_err_stack('PA_FP_CALC_UTILS.delete_budget_lines');
4725: End If;
4726:
4727: --print_msg('Entered delete_budget_lines api');
4728: /* Initialize the plsql tabs */

Line 4837: ( p_pkg_name => 'PA_FP_CALC_UTILS'

4833: If p_pa_debug_mode = 'Y' Then
4834: pa_debug.reset_err_stack;
4835: End If;
4836: fnd_msg_pub.add_exc_msg
4837: ( p_pkg_name => 'PA_FP_CALC_UTILS'
4838: ,p_procedure_name => 'delete_budget_lines');
4839: RAISE;
4840: END delete_budget_lines ;
4841:

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

4937:
4938: x_return_status := 'S';
4939: /* Initialize the error stack */
4940: If p_pa_debug_mode = 'Y' Then
4941: pa_debug.init_err_stack('PA_FP_CALC_UTILS.insert_budget_lines');
4942: End If;
4943: --print_msg('Entered insert_budget_lines api');
4944: /* Initialize the plsql tabs */
4945: l_budget_line_id_tab.delete;

Line 5260: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5256: If p_pa_debug_mode = 'Y' Then
5257: pa_debug.reset_err_stack;
5258: End If;
5259: fnd_msg_pub.add_exc_msg
5260: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5261: ,p_procedure_name => 'insert_budget_lines');
5262: RAISE;
5263: END insert_budget_lines;
5264:

Line 5338: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5334: If p_pa_debug_mode = 'Y' Then
5335: pa_debug.reset_err_stack;
5336: End If;
5337: fnd_msg_pub.add_exc_msg
5338: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5339: ,p_procedure_name => 'process_ResAttribs');
5340: RAISE;
5341:
5342: END process_ResAttribs;

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

5386:
5387: BEGIN
5388: x_return_status := 'S';
5389: If p_pa_debug_mode = 'Y' Then
5390: pa_debug.init_err_stack('PA_FP_CALC_UTILS.process_planDates_change');
5391: --print_msg('Entered process_planDates_change api NumLinetoProcess['||g_Rspd_RaId_tab.COUNT||']');
5392: End If;
5393: IF perdRec.time_phased_code = 'P' Then
5394: l_period_type := perdRec.pa_period_type;

Line 5536: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5532: If p_pa_debug_mode = 'Y' Then
5533: pa_debug.reset_err_stack;
5534: End If;
5535: fnd_msg_pub.add_exc_msg
5536: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5537: ,p_procedure_name => 'process_planDates_change');
5538: RAISE;
5539: END process_planDates_change;
5540:

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

5553: /* bulk select all the RA+Txn currency combo from budget lines and later insert these records into tmp table
5554: * for processing
5555: */
5556: If p_pa_debug_mode = 'Y' Then
5557: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_blTxnCurCombo');
5558: print_msg('Entered populate_blTxnCurCombo api');
5559: End If;
5560: SELECT /*+ INDEX(BL PA_BUDGET_LINES_U1) */
5561: bl.resource_assignment_id

Line 5697: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5693: If p_pa_debug_mode = 'Y' Then
5694: pa_debug.reset_err_stack;
5695: End if;
5696: fnd_msg_pub.add_exc_msg
5697: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5698: ,p_procedure_name => 'populate_blTxnCurCombo');
5699: RAISE;
5700:
5701: END populate_blTxnCurCombo;

Line 5844: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5840: l_return_status := 'U';
5841: l_msg_data := sqlcode||sqlerrm;
5842: print_msg('Failed in synch_resAttribs API'||l_msg_data);
5843: fnd_msg_pub.add_exc_msg
5844: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5845: ,p_procedure_name => 'synch_resAttribs ');
5846: RAISE;
5847:
5848: END synch_resAttribs;

Line 5974: ( p_pkg_name => 'PA_FP_CALC_UTILS'

5970: l_return_status := 'U';
5971: l_msg_data := sqlcode||sqlerrm;
5972: print_msg('Failed in synch_ChangedFlags API'||l_msg_data);
5973: fnd_msg_pub.add_exc_msg
5974: ( p_pkg_name => 'PA_FP_CALC_UTILS'
5975: ,p_procedure_name => 'synch_ChangedFlags');
5976: RAISE;
5977:
5978: END synch_ChangedFlags;

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

6139: ,pa_resource_assignments ra
6140: WHERE tmp.budget_version_id = p_budget_version_id
6141: AND ra.resource_assignment_id = tmp.resource_assignment_id
6142: AND rl.resource_list_member_id = ra.resource_list_member_id
6143: /** Bug fix: ORA-00979: not a GROUP BY expression in Package PA_FP_CALC_UTILS
6144: AND ((decode(tmp.OLD_PLAN_START_DATE,NULL,'N'
6145: ,decode(tmp.NEW_PLAN_START_DATE,NULL,'N'
6146: ,decode(tmp.OLD_PLAN_START_DATE,tmp.NEW_PLAN_START_DATE,'N','Y'))) ='Y')
6147: OR

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

6216: x_msg_data := NULL;
6217:
6218: /* Initialize the error stack */
6219: If p_pa_debug_mode = 'Y' Then
6220: pa_debug.init_err_stack('PA_FP_CALC_UTILS.populate_spreadCalc_Tmp');
6221: print_msg(' Entered populate_spreadCalc_Tmp API');
6222: End If;
6223: /* populate tmp table with the data */
6224: Init_plsqlTabs;

Line 7018: ( p_pkg_name => 'PA_FP_CALC_UTILS'

7014: x_return_status := 'U';
7015: x_msg_data := sqlcode||sqlerrm;
7016: print_msg('Failed in populate_spreadTmp_OvrRates API'||x_msg_data);
7017: fnd_msg_pub.add_exc_msg
7018: ( p_pkg_name => 'PA_FP_CALC_UTILS'
7019: ,p_procedure_name => 'populate_spreadCalc_Tmp ');
7020: If p_pa_debug_mode = 'Y' Then
7021: pa_debug.reset_err_stack;
7022: End If;

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

7059: OR tmp.mfc_cost_change_flag = 'Y' );
7060: BEGIN
7061: /* Initialize the error stack */
7062: If p_pa_debug_mode = 'Y' Then
7063: pa_debug.init_err_stack('PA_FP_CALC_UTILS.cache_rates');
7064: End If;
7065: x_return_status := 'S';
7066: x_msg_data := NULL;
7067:

Line 7312: ( p_pkg_name => 'PA_FP_CALC_UTILS'

7308: x_return_status := 'U';
7309: x_msg_data := sqlcode||sqlerrm;
7310: print_msg('Failed in cache_rates API'||x_msg_data);
7311: fnd_msg_pub.add_exc_msg
7312: ( p_pkg_name => 'PA_FP_CALC_UTILS'
7313: ,p_procedure_name => 'cache_rates');
7314: If p_pa_debug_mode = 'Y' Then
7315: pa_debug.reset_err_stack;
7316: End If;

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

7806: /* Initialize the out variables */
7807: x_return_status := 'S';
7808: x_msg_data := NULL;
7809: If p_pa_debug_mode = 'Y' Then
7810: pa_debug.init_err_stack('PA_FP_CALC_UTILS.copy_BlAttributes');
7811: End If;
7812: IF p_calling_module NOT IN ('BUDGET_GENERATION','FORECAST_GENERATION') Then --{
7813: IF P_PA_DEBUG_MODE = 'Y' Then
7814: print_msg('Entered copy_BlAttributes API');

Line 7992: ( p_pkg_name => 'PA_FP_CALC_UTILS'

7988: WHEN OTHERS THEN
7989: x_return_status := 'U';
7990: x_msg_data := SQLCODE||SQLERRM;
7991: fnd_msg_pub.add_exc_msg
7992: ( p_pkg_name => 'PA_FP_CALC_UTILS'
7993: ,p_procedure_name => 'copy_BlAttributes');
7994: If p_pa_debug_mode = 'Y' Then
7995: pa_debug.reset_err_stack;
7996: End If;

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

10243: x_return_status := 'S';
10244: x_msg_data := NULL;
10245: x_msg_count := fnd_msg_pub.count_msg;
10246: If p_pa_debug_mode = 'Y' Then
10247: pa_debug.init_err_stack('PA_FP_CALC_UTILS.update_dffcols');
10248: End If;
10249: IF p_calling_module NOT IN ('BUDGET_GENERATION','FORECAST_GENERATION') Then --{
10250: INIT_PLSQL_TABS;
10251: --print_msg('Fetching budget Line Attributes such as DFFs details from cache ');

Line 10592: ( p_pkg_name => 'PA_FP_CALC_UTILS'

10588: WHEN OTHERS THEN
10589: x_return_status := 'U';
10590: x_msg_data := SQLCODE||SQLERRM;
10591: fnd_msg_pub.add_exc_msg
10592: ( p_pkg_name => 'PA_FP_CALC_UTILS'
10593: ,p_procedure_name => 'update_dffcols');
10594: If p_pa_debug_mode = 'Y' Then
10595: pa_debug.reset_err_stack;
10596: End If;

Line 10910: ( p_pkg_name => 'PA_FP_CALC_UTILS'

10906: WHEN OTHERS THEN
10907: x_return_status := 'U';
10908: print_msg('Error occured in InsertFunding_ReqdLines['|| SQLCODE||SQLERRM);
10909: fnd_msg_pub.add_exc_msg
10910: ( p_pkg_name => 'PA_FP_CALC_UTILS'
10911: ,p_procedure_name => 'InsertFunding_ReqdLines');
10912: RAISE;
10913:
10914: END InsertFunding_ReqdLines;

Line 10917: END PA_FP_CALC_UTILS;

10913:
10914: END InsertFunding_ReqdLines;
10915:
10916:
10917: END PA_FP_CALC_UTILS;