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.

[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on DBMS_UTILITY

Line 8201: l_calc_start_time := dbms_utility.get_time;

8197: * This api call is not required as it does the same as init_err_stack
8198: --pa_debug.set_curr_function( p_function => 'PA_FP_CALC_PLAN_PKG.calculate'
8199: --,p_debug_mode => p_pa_debug_mode);
8200: */
8201: l_calc_start_time := dbms_utility.get_time;
8202: print_plsql_time('Calculate API start Time:['||l_calc_start_time||']','Y');
8203: If P_PA_DEBUG_MODE = 'Y' Then
8204: l_stage := 10;
8205: print_msg(to_char(l_stage)||' Entered PA_FP_CALC_PLAN_PKG.calculate');

Line 8386: l_pls_start_time := dbms_utility.get_time;

8382: GOTO END_OF_PROCESS;
8383: End If;
8384:
8385: l_stage := 25;
8386: l_pls_start_time := dbms_utility.get_time;
8387: --print_plsql_time('Start of Validate Inputs:['||l_pls_start_time||']','Y');
8388: If P_PA_DEBUG_MODE = 'Y' Then
8389: print_msg(to_char(l_stage)||' Calling Validate Inputs');
8390: print_msg('Start of Validate Inputs:['||l_pls_start_time||']','Y');

Line 8452: l_pls_end_time := dbms_utility.get_time;

8448: ,p_fp_task_billable_flag_tab => p_fp_task_billable_flag_tab
8449: ,x_return_status => l_return_status
8450: ,x_msg_count => x_msg_count
8451: ,x_msg_data => x_msg_data);
8452: l_pls_end_time := dbms_utility.get_time;
8453: If P_PA_DEBUG_MODE = 'Y' Then
8454: print_msg('End of Validate Inputs:['||l_pls_end_time||']','Y');
8455: End If;
8456: print_plsql_time('End of Validate Inputs: Total time :['||(l_pls_end_time-l_pls_start_time)||']');

Line 8558: l_pls_start_time := dbms_utility.get_time;

8554: END IF;
8555:
8556: /* Bug fix: 3693097 The inparams contains G_MISS_NUM chars should be validated*/
8557: /*************************************************************************************
8558: l_pls_start_time := dbms_utility.get_time;
8559: --print_plsql_time('Start of MainLopp1:['||l_pls_start_time);
8560: *Bug:5309529: Performance improvement changes : the following loop and execution of cursors inside the loop
8561: *is removed and added a new api inside the PAFPCL1B.pls insert_spread_calctmp_records
8562: **************End of Bug fix:5309529 *****************************************/

Line 8564: l_pls_end_time := dbms_utility.get_time;

8560: *Bug:5309529: Performance improvement changes : the following loop and execution of cursors inside the loop
8561: *is removed and added a new api inside the PAFPCL1B.pls insert_spread_calctmp_records
8562: **************End of Bug fix:5309529 *****************************************/
8563:
8564: l_pls_end_time := dbms_utility.get_time;
8565: print_plsql_time('End of MainLopp1:Total time['||(l_pls_end_time - l_pls_start_time));
8566: l_stage := 133;
8567: IF l_return_status <> 'S' Then
8568: print_msg(l_stage||'Errors found in the params processing');

Line 8605: l_pls_start_time := dbms_utility.get_time;

8601: OR NVL(G_AGR_CONV_REQD_FLAG,'N') = 'Y' ) Then
8602: g_rollup_required_flag := 'N';
8603: End If;
8604: --print_msg('rollup required flag =>'||g_rollup_required_flag||']');
8605: l_pls_start_time := dbms_utility.get_time;
8606: --print_plsql_time('Start of populate_spreadCalc_tmp:['||l_pls_start_time);
8607:
8608: IF l_resource_assignment_tab.COUNT > 0 THEN --{
8609: If P_PA_DEBUG_MODE = 'Y' Then

Line 8693: l_pls_end_time := dbms_utility.get_time;

8689: ,x_neg_rev_Changflag_tab => l_neg_rev_Changflag_tab
8690: ,x_return_status => l_return_status
8691: ,x_msg_data => x_msg_data
8692: );
8693: l_pls_end_time := dbms_utility.get_time;
8694: print_plsql_time('End of populate_spreadCalc_tmp:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
8695: If P_PA_DEBUG_MODE = 'Y' Then
8696: print_msg('End of calling PA_FP_CALC_UTILS.populate_spreadCalc_Tmp retSts['||l_return_status||']');
8697: End If;

Line 8837: l_pls_start_time := dbms_utility.get_time;

8833: END IF; --}
8834:
8835: /* Bug fix:5203622 */
8836: IF l_entire_return_status = 'S' Then
8837: l_pls_start_time := dbms_utility.get_time;
8838: --print_plsql_time('Start of clear_etc_rev_other_rejectns :['||l_pls_start_time);
8839: clear_etc_rev_other_rejectns
8840: (p_budget_version_id => p_budget_version_id
8841: ,p_source_context => p_source_context

Line 8854: l_pls_end_time := dbms_utility.get_time;

8850: l_entire_return_status := l_return_status;
8851: GOTO END_OF_PROCESS;
8852: End If;
8853: END IF;
8854: l_pls_end_time := dbms_utility.get_time;
8855: print_plsql_time('End of clear_etc_rev_other_rejectns Total time :['||(l_pls_end_time-l_pls_start_time)||']');
8856:
8857: l_stage := 210;
8858: If P_PA_DEBUG_MODE = 'Y' Then

Line 8863: l_pls_start_time := dbms_utility.get_time;

8859: print_msg(to_char(l_stage)||' Entering loop using the l_resource_assignment_tab.resource_assignment_id');
8860: print_msg('l_resource_assignment_tab.first['||l_resource_assignment_tab.first||']Last['||l_resource_assignment_tab.last);
8861: print_msg(l_stage||':Count of Errors:MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
8862: End If;
8863: l_pls_start_time := dbms_utility.get_time;
8864: --print_plsql_time('Start of MainLoop2:['||l_pls_start_time);
8865: --MAIN CODE STARTS HERE
8866: l_countr := 0;
8867: FOR i IN l_resource_assignment_tab.first..l_resource_assignment_tab.last LOOP

Line 10055: l_pls_end_time := dbms_utility.get_time;

10051: g_skip_record_tab(l_countr) := 'Y';
10052: END;
10053:
10054: END LOOP; --end loop from FOR i in l_resource_assignment_tab.first..l_resource_assignment_tab.last
10055: l_pls_end_time := dbms_utility.get_time;
10056: print_plsql_time('End of MainLoop2:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10057: If P_PA_DEBUG_MODE = 'Y' Then
10058: print_msg(to_char(l_stage)||'END RESOURCE_ASSIGNMENTS LOOP ');
10059: End If;

Line 10099: l_pls_start_time := dbms_utility.get_time;

10095: );
10096: If P_PA_DEBUG_MODE = 'Y' Then
10097: print_msg(to_char(l_stage)||' Spread is required call spread_amounts');
10098: End If;
10099: l_pls_start_time := dbms_utility.get_time;
10100: --print_plsql_time('Start of spread amounts:['||l_pls_start_time);
10101: PA_FP_SPREAD_AMTS_PKG.spread_amounts
10102: ( p_budget_version_id => g_budget_version_id
10103: ,x_return_status => l_return_status

Line 10107: l_pls_end_time := dbms_utility.get_time;

10103: ,x_return_status => l_return_status
10104: ,x_msg_count => x_msg_count
10105: ,x_msg_data => x_msg_data
10106: );
10107: l_pls_end_time := dbms_utility.get_time;
10108: print_plsql_time('End of spread amounts:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10109: If P_PA_DEBUG_MODE = 'Y' Then
10110: print_msg('After calling spread_amounts api retSts['||l_return_status||']msgdata['||x_msg_data||']');
10111: End If;

Line 10132: l_pls_start_time := dbms_utility.get_time;

10128: print_msg(to_char(l_stage)||' Spread is not required call populate_rollup_tmp');
10129: print_msg(to_char(l_stage)||' Populate global temporary tables :refresh_conv_rates_flag ['||g_refresh_conv_rates_flag||']');
10130: print_msg(']refresh_rates_flag['||g_refresh_rates_flag||']');
10131: End if;
10132: l_pls_start_time := dbms_utility.get_time;
10133: --print_plsql_time('Start of populate rollupTmp:['||l_pls_start_time);
10134: pa_fp_calc_plan_pkg.populate_rollup_tmp
10135: ( p_budget_version_id => g_budget_version_id
10136: ,x_return_status => l_return_status

Line 10140: l_pls_end_time := dbms_utility.get_time;

10136: ,x_return_status => l_return_status
10137: ,x_msg_count => x_msg_count
10138: ,x_msg_data => x_msg_data
10139: );
10140: l_pls_end_time := dbms_utility.get_time;
10141: print_plsql_time('End of populate rollupTmp:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10142: If P_PA_DEBUG_MODE = 'Y' Then
10143: print_msg('After Calling populate_rollup_tmp retSts['||l_return_status||']');
10144: End If;

Line 10159: l_pls_start_time := dbms_utility.get_time;

10155: If P_PA_DEBUG_MODE = 'Y' Then
10156: print_msg(l_stage||'Calling pa_fp_calc_plan_pkg.mass_adjust API');
10157: End If;
10158: /*bug fix:4657962 */
10159: l_pls_start_time := dbms_utility.get_time;
10160: --print_plsql_time('Start of MassAdjust:['||l_pls_start_time);
10161: pa_fp_calc_plan_pkg.mass_adjust_new
10162: ( p_budget_version_id => g_budget_version_id
10163: ,p_quantity_adj_pct => p_quantity_adj_pct

Line 10174: l_pls_end_time := dbms_utility.get_time;

10170: ,x_return_status => l_return_status
10171: ,x_msg_count => x_msg_count
10172: ,x_msg_data => x_msg_data
10173: );
10174: l_pls_end_time := dbms_utility.get_time;
10175: print_plsql_time('End of MassAdjust:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10176: If P_PA_DEBUG_MODE = 'Y' Then
10177: print_msg('End of pa_fp_calc_plan_pkg.mass_adjust API retSts['||l_return_status||']');
10178: End If;

Line 10196: l_pls_start_time := dbms_utility.get_time;

10192: AND g_applyProg_RaId_tab.COUNT > 0 ) Then
10193: If P_PA_DEBUG_MODE = 'Y' Then
10194: print_msg('Calling populate rollup tmp in apply progress mode to rederive the etc costs');
10195: End If;
10196: l_pls_start_time := dbms_utility.get_time;
10197: --print_plsql_time('Start of populaterollupTmp inApplyProgMode:['||l_pls_start_time);
10198: pa_fp_calc_plan_pkg.populate_rollup_tmp
10199: ( p_budget_version_id => g_budget_version_id
10200: ,x_return_status => l_return_status

Line 10204: l_pls_end_time := dbms_utility.get_time;

10200: ,x_return_status => l_return_status
10201: ,x_msg_count => x_msg_count
10202: ,x_msg_data => x_msg_data
10203: );
10204: l_pls_end_time := dbms_utility.get_time;
10205: print_plsql_time('End of populaterollupTmp inApplyProgMode:time :['||(l_pls_end_time-l_pls_start_time)||']');
10206: If P_PA_DEBUG_MODE = 'Y' Then
10207: print_msg('After Calling populate_rollup_tmp retSts['||l_return_status||']');
10208: End If;

Line 10300: l_pls_start_time := dbms_utility.get_time;

10296: l_stage := 543;
10297: If P_PA_DEBUG_MODE = 'Y' Then
10298: print_msg(l_stage||'Calling Update_rollupTmp_OvrRates API with genrationContext['||l_generation_context||']');
10299: End if;
10300: l_pls_start_time := dbms_utility.get_time;
10301: --print_plsql_time('Start of Update_rollupTmp_OvrRates:['||l_pls_start_time);
10302: Update_rollupTmp_OvrRates
10303: ( p_budget_version_id => g_budget_version_id
10304: ,p_calling_module => l_calling_module

Line 10310: l_pls_end_time := dbms_utility.get_time;

10306: ,x_return_status => l_return_status
10307: ,x_msg_count => x_msg_count
10308: ,x_msg_data => x_msg_data
10309: );
10310: l_pls_end_time := dbms_utility.get_time;
10311: print_plsql_time('End of Update_rollupTmp_OvrRates:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10312: If P_PA_DEBUG_MODE = 'Y' Then
10313: print_msg('After calling Update_rollupTmp_OvrRates api retSts['||l_return_status||']msgdata['||x_msg_data||']');
10314: End If;

Line 10328: l_pls_start_time := dbms_utility.get_time;

10324: AND CheckCacheRecExists(p_budget_version_id => g_budget_version_id) = 'Y') Then
10325: If P_PA_DEBUG_MODE = 'Y' Then
10326: print_msg('Calling PA_FP_CALC_UTILS.copy_BlAttributes api');
10327: End if;
10328: l_pls_start_time := dbms_utility.get_time;
10329: --print_plsql_time('Start of CopyBlAttributes:['||l_pls_start_time);
10330: PA_FP_CALC_UTILS.copy_BlAttributes(
10331: p_budget_verson_id => g_budget_version_id
10332: ,p_source_context => g_source_context

Line 10338: l_pls_end_time := dbms_utility.get_time;

10334: ,p_apply_progress_flag => p_apply_progress_flag
10335: ,x_return_status =>l_return_status
10336: ,x_msg_data => x_msg_data
10337: );
10338: l_pls_end_time := dbms_utility.get_time;
10339: print_plsql_time('End of CopyBlAttributes:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10340: If P_PA_DEBUG_MODE = 'Y' Then
10341: print_msg('returnSts of PA_FP_CALC_UTILS.copy_BlAttributes['||l_return_status||']');
10342: End If;

Line 10402: l_pls_start_time := dbms_utility.get_time;

10398:
10399: If P_PA_DEBUG_MODE = 'Y' Then
10400: print_msg('Calling Rate API');
10401: End if;
10402: l_pls_start_time := dbms_utility.get_time;
10403: --print_plsql_time('Start of Get_Res_RATEs:['||l_pls_start_time);
10404: Get_Res_RATEs
10405: (p_calling_module => l_calling_module
10406: ,p_activity_code => l_activity_code

Line 10415: l_pls_end_time := dbms_utility.get_time;

10411: ,x_return_status => l_return_status
10412: ,x_msg_data => x_msg_data
10413: ,x_msg_count => x_msg_count
10414: ) ;
10415: l_pls_end_time := dbms_utility.get_time;
10416: print_plsql_time('End of Get_Res_RATEs:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10417: If P_PA_DEBUG_MODE = 'Y' Then
10418: print_msg('After Calling Rate API retSTS['||l_return_status||']');
10419: End if;

Line 10440: l_pls_start_time := dbms_utility.get_time;

10436: *.as the fix is done for AMG rollup. Will ask Ranga to evaluate this for non-AMG flows and remove the if condition.
10437: *.This can then be put in FP M rollup with extensive QE testing */
10438: IF ( p_calling_module = 'AMG_API' )
10439: THEN
10440: l_pls_start_time := dbms_utility.get_time;
10441: --print_plsql_time('Start of update_diffcols: time :'||l_pls_start_time);
10442: PA_FP_CALC_UTILS.update_dffcols(
10443: p_budget_verson_id => g_budget_version_id
10444: ,p_source_context => g_source_context

Line 10451: l_pls_end_time := dbms_utility.get_time;

10447: ,x_return_status => l_return_status
10448: ,x_msg_count => x_msg_count
10449: ,x_msg_data => x_msg_data
10450: );
10451: l_pls_end_time := dbms_utility.get_time;
10452: print_plsql_time('End of update_diffcols:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10453: If P_PA_DEBUG_MODE = 'Y' Then
10454: print_msg('returnSts of PA_FP_CALC_UTILS.update_dff['||l_return_status||']');
10455: End if;

Line 10535: l_pls_start_time := dbms_utility.get_time;

10531: l_cl_raw_rejection_code_tab.delete;
10532: l_cl_burd_rejection_code_tab.delete;
10533: l_cl_rev_rejection_code_tab.delete;
10534: l_cl_cntr := 0;
10535: l_pls_start_time := dbms_utility.get_time;
10536: --print_plsql_time('Start of ClientExtnLoop:Start time :['||l_pls_end_time||']');
10537: FOR rec IN get_client_xtn_rollup_csr LOOP
10538: l_stage := 910;
10539: --print_msg(to_char(l_stage)||' INSIDE get_client_xtn_rollup_csr LOOP');

Line 10783: l_pls_end_time := dbms_utility.get_time;

10779: WHERE tmp.budget_line_id = l_cl_budget_line_id_tab(i);
10780: --print_msg('Number rows updated with ClientExtnUpd['||sql%rowcount||']');
10781: END IF;
10782: End If;
10783: l_pls_end_time := dbms_utility.get_time;
10784: print_plsql_time('End of ClientExtnLoop:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10785: End If; -- end of client extension calls
10786:
10787: /* Rounding Enhancements: Update the last rollup tmp line with the rounding discrepancy amounts */

Line 10789: l_pls_start_time := dbms_utility.get_time;

10785: End If; -- end of client extension calls
10786:
10787: /* Rounding Enhancements: Update the last rollup tmp line with the rounding discrepancy amounts */
10788: IF NVL(l_entire_return_status,'S') = 'S' AND NVL(g_track_wp_costs_flag,'Y') = 'Y' THEN
10789: l_pls_start_time := dbms_utility.get_time;
10790: --print_plsql_time('Start of Update_rounding_diff:['||l_pls_start_time);
10791: Update_rounding_diff(
10792: p_project_id => p_project_id
10793: ,p_budget_version_id => g_budget_version_id

Line 10802: l_pls_end_time := dbms_utility.get_time;

10798: ,x_return_status => l_return_status
10799: ,x_msg_count => x_msg_count
10800: ,x_msg_data => l_msg_data --5028631
10801: );
10802: l_pls_end_time := dbms_utility.get_time;
10803: print_plsql_time('End of Update_rounding_diff:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10805: x_return_status := l_return_status;
10806: x_msg_data := l_msg_data; --5028631

Line 10823: l_pls_start_time := dbms_utility.get_time;

10819: l_stage := 1010;
10820: If P_PA_DEBUG_MODE = 'Y' Then
10821: print_msg(to_char(l_stage)||'Calling convert_txn_currency with the following parameters:');
10822: End if;
10823: l_pls_start_time := dbms_utility.get_time;
10824: --print_plsql_time('Start of Currency Conversion['||l_pls_start_time);
10825: pa_fp_multi_currency_pkg.convert_txn_currency
10826: ( p_budget_version_id => g_budget_version_id
10827: ,p_entire_version => 'N'

Line 10833: l_pls_end_time := dbms_utility.get_time;

10829: ,x_return_status => l_return_status
10830: ,x_msg_count => x_msg_count
10831: ,x_msg_data => l_msg_data --5028631
10832: );
10833: l_pls_end_time := dbms_utility.get_time;
10834: print_plsql_time('End of Currency ConversionTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
10835: If P_PA_DEBUG_MODE = 'Y' Then
10836: print_msg('AFter calling convert_txn_currency API returnSTS['||l_return_status||']');
10837: End if;

Line 10875: l_pls_start_time := dbms_utility.get_time;

10871: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp
10872: */
10873: l_stage := 1100;
10874: /* Bug fix: 4184159 moved to bulk update pa_fp_calc_plan_pkg.update_budget_lines */
10875: l_pls_start_time := dbms_utility.get_time;
10876: --print_plsql_time('Start of BLK UpdateBudget Lines:['||l_pls_start_time);
10877: PA_FP_CALC_UTILS.BLK_update_budget_lines
10878: ( p_budget_version_id => p_budget_version_id
10879: ,p_calling_module => l_calling_module -- Added for Bug#5395732

Line 10884: l_pls_end_time := dbms_utility.get_time;

10880: ,x_return_status => l_return_status
10881: ,x_msg_count => x_msg_count
10882: ,x_msg_data => l_msg_data --5028631
10883: );
10884: l_pls_end_time := dbms_utility.get_time;
10885: print_plsql_time('End of BLK UpdateBudget Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10886: If P_PA_DEBUG_MODE = 'Y' Then
10887: print_msg('AFter calling update_budget_lines retSTst['||l_return_status||']MsgData['||l_msg_data||']');
10888: End if;

Line 10900: l_pls_start_time := dbms_utility.get_time;

10896: IF NVL(p_raTxn_rollup_api_call_flag,'Y') = 'Y' AND nvl(l_entire_return_status,'S') = 'S' Then
10897: If P_PA_DEBUG_MODE = 'Y' Then
10898: print_msg('Calling populate_raTxn_Recs API');
10899: End if;
10900: l_pls_start_time := dbms_utility.get_time;
10901: --print_plsql_time('Start of populate_raTxn_Recs :['||l_pls_start_time);
10902: delete_raTxn_Tmp;
10903: populate_raTxn_Recs (
10904: p_budget_version_id => g_budget_version_id

Line 10916: l_pls_end_time := dbms_utility.get_time;

10912: ,x_return_status => l_return_status
10913: ,x_msg_count => x_msg_count
10914: ,x_msg_data => l_msg_data --5028631
10915: );
10916: l_pls_end_time := dbms_utility.get_time;
10917: print_plsql_time('End of populate_raTxn_RecsTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
10918: If P_PA_DEBUG_MODE = 'Y' Then
10919: print_msg('AFter calling populate_raTxn_Recs retSTst['||l_return_status||']MsgData['||l_msg_data||']');
10920: End if;

Line 10947: l_pls_start_time := dbms_utility.get_time;

10943: END IF;
10944: If p_pa_debug_mode = 'Y' Then
10945: DbugPjiVals;
10946: End If;
10947: l_pls_start_time := dbms_utility.get_time;
10948: --print_plsql_time('Start of PJI reporting:['||l_pls_start_time);
10949: PA_FP_PJI_INTG_PKG.blk_update_reporting_lines
10950: (p_calling_module => 'CALCULATE_API'
10951: ,p_activity_code => 'UPDATE'

Line 10977: l_pls_end_time := dbms_utility.get_time;

10973: ,x_msg_data => l_msg_data --5028631
10974: ,x_msg_count => x_msg_count
10975: ,x_return_status => l_return_status
10976: );
10977: l_pls_end_time := dbms_utility.get_time;
10978: print_plsql_time('End of PJI reporting:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10979: If P_PA_DEBUG_MODE = 'Y' Then
10980: print_msg('AFter calling PA_FP_PJI_INTG_PKG retSTst['||l_return_status||']MsgData['||l_msg_data||']');
10981: End if;

Line 11002: l_pls_start_time := dbms_utility.get_time;

10998: l_stage := 1210;
10999: If P_PA_DEBUG_MODE = 'Y' Then
11000: print_msg('Rollup PC and PFC to RA ');
11001: End if;
11002: l_pls_start_time := dbms_utility.get_time;
11003: --print_plsql_time('Start of rollup_pf_pfc_to_ra :['||l_pls_start_time);
11004: pa_fp_calc_plan_pkg.rollup_pf_pfc_to_ra
11005: ( p_budget_version_id => g_budget_version_id
11006: ,x_return_status => l_return_status

Line 11010: l_pls_end_time := dbms_utility.get_time;

11006: ,x_return_status => l_return_status
11007: ,x_msg_count => x_msg_count
11008: ,x_msg_data => l_msg_data --5028631
11009: );
11010: l_pls_end_time := dbms_utility.get_time;
11011: print_plsql_time('End of rollup_pf_pfc_to_raTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11012: If P_PA_DEBUG_MODE = 'Y' Then
11013: print_msg('After calling pa_fp_calc_plan_pkg.rollup_pf_pfc_to_ra retSts['||l_return_status||']msgData['||l_msg_data||']');
11014: End if;

Line 11035: l_pls_start_time := dbms_utility.get_time;

11031: */
11032: If P_PA_DEBUG_MODE = 'Y' Then
11033: print_msg(l_stage||'Calling Delete_BL_Where_Nulls API');
11034: End if;
11035: l_pls_start_time := dbms_utility.get_time;
11036: --print_plsql_time('Start of Delete_BL_Where_Nulls :['||l_pls_start_time);
11037: Delete_BL_Where_Nulls
11038: ( p_budget_version_id => p_budget_version_id
11039: ,p_resource_assignment_tab => l_resource_assignment_tab

Line 11043: l_pls_end_time := dbms_utility.get_time;

11039: ,p_resource_assignment_tab => l_resource_assignment_tab
11040: ,x_return_status => l_return_status
11041: ,x_msg_data => l_msg_data --5028631
11042: );
11043: l_pls_end_time := dbms_utility.get_time;
11044: print_plsql_time('End of Delete_BL_Where_NullsTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11045: If P_PA_DEBUG_MODE = 'Y' Then
11046: print_msg('AFter calling Delete_BL_Where_Nulls retSTst['||l_return_status||']MsgData['||l_msg_data||']');
11047: End if;

Line 11066: l_pls_start_time := dbms_utility.get_time;

11062: IF (NVL(l_entire_return_status,'S') = 'S' AND NVL(g_wp_version_flag,'N') = 'N'
11063: AND NVL(g_mrc_installed_flag,'N') = 'Y'
11064: AND PA_MRC_FINPLAN.G_FINPLAN_MRC_OPTION_CODE = 'A'
11065: AND NVL(g_conv_rates_required_flag,'Y') = 'Y' ) Then
11066: l_pls_start_time := dbms_utility.get_time;
11067: --print_plsql_time('Start of MRC:['||l_pls_start_time);
11068:
11069: l_stage := 1280;
11070: IF (NVL(G_populate_mrc_tab_flag,'N') = 'Y' AND g_mrc_budget_line_id_tab.COUNT > 0 ) Then

Line 11112: l_pls_end_time := dbms_utility.get_time;

11108: x_msg_data := l_msg_data; --5028631
11109: print_msg('Failed Unexpected exception in MRC API['||sqlcode||sqlerrm);
11110: GOTO END_OF_PROCESS;
11111: END IF;
11112: l_pls_end_time := dbms_utility.get_time;
11113: print_plsql_time('End of MRC:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11114: End If;
11115: **************END of MRC Elimination changes ***/
11116:

Line 11125: l_pls_start_time := dbms_utility.get_time;

11121: l_stage := 1300;
11122: If P_PA_DEBUG_MODE = 'Y' Then
11123: print_msg(to_char(l_stage)||' Calling rollup_pf_pfc_to_bv with following parameters:');
11124: End if;
11125: l_pls_start_time := dbms_utility.get_time;
11126: --print_plsql_time('Start of rollup_pf_pfc_to_bv:['||l_pls_start_time);
11127: pa_fp_calc_plan_pkg.rollup_pf_pfc_to_bv
11128: ( p_budget_version_id => g_budget_version_id
11129: ,x_return_status => l_return_status

Line 11133: l_pls_end_time := dbms_utility.get_time;

11129: ,x_return_status => l_return_status
11130: ,x_msg_count => x_msg_count
11131: ,x_msg_data => l_msg_data --5028631
11132: );
11133: l_pls_end_time := dbms_utility.get_time;
11134: print_plsql_time('End of rollup_pf_pfc_to_bvTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11135: If P_PA_DEBUG_MODE = 'Y' Then
11136: print_msg('After calling pa_fp_calc_plan_pkg.rollup_pf_pfc_to_bv retSts['||l_return_status||']msgData['||l_msg_data||']');
11137: End if;

Line 11195: l_pls_start_time := dbms_utility.get_time;

11191: END IF; -- g_fp_multi_curr_enabled = Y
11192:
11193: /* Bug fix:5203622 */
11194: IF l_entire_return_status = 'S' Then
11195: l_pls_start_time := dbms_utility.get_time;
11196: --print_plsql_time('Start of clear_etc_rev_other_rejectns['||l_pls_start_time);
11197: clear_etc_rev_other_rejectns
11198: (p_budget_version_id => p_budget_version_id
11199: ,p_source_context => p_source_context

Line 11206: l_pls_end_time := dbms_utility.get_time;

11202: ,x_return_status => l_return_status
11203: ,x_msg_count => x_msg_count
11204: ,x_msg_data => l_msg_data
11205: );
11206: l_pls_end_time := dbms_utility.get_time;
11207: print_plsql_time('end of clear_etc_rev_Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11208: If l_return_status <> 'S' Then
11209: x_return_status := 'E';
11210: l_entire_return_status := l_return_status;

Line 11274: l_pls_end_time := dbms_utility.get_time;

11270:
11271: If cur_ra_txn_rates%isopen then
11272: close cur_ra_txn_rates;
11273: end if;
11274: l_pls_end_time := dbms_utility.get_time;
11275: /* End of bug fix:4343985 */
11276: If P_PA_DEBUG_MODE = 'Y' Then
11277: print_msg('LEAVING calculate bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
11278: print_msg('x_return_status : '||x_return_status||']x_msg_count['||x_msg_count||']x_msg_data['||x_msg_data||']');