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_PLAN_PKG dependencies on DBMS_UTILITY

Line 8308: l_calc_start_time := dbms_utility.get_time;

8304: * This api call is not required as it does the same as init_err_stack
8305: --pa_debug.set_curr_function( p_function => 'PA_FP_CALC_PLAN_PKG.calculate'
8306: --,p_debug_mode => p_pa_debug_mode);
8307: */
8308: l_calc_start_time := dbms_utility.get_time;
8309: print_plsql_time('Calculate API start Time:['||l_calc_start_time||']','Y');
8310: If P_PA_DEBUG_MODE = 'Y' Then
8311: l_stage := 10;
8312: print_msg(to_char(l_stage)||' Entered PA_FP_CALC_PLAN_PKG.calculate');

Line 8493: l_pls_start_time := dbms_utility.get_time;

8489: GOTO END_OF_PROCESS;
8490: End If;
8491:
8492: l_stage := 25;
8493: l_pls_start_time := dbms_utility.get_time;
8494: --print_plsql_time('Start of Validate Inputs:['||l_pls_start_time||']','Y');
8495: If P_PA_DEBUG_MODE = 'Y' Then
8496: print_msg(to_char(l_stage)||' Calling Validate Inputs');
8497: print_msg('Start of Validate Inputs:['||l_pls_start_time||']','Y');

Line 8559: l_pls_end_time := dbms_utility.get_time;

8555: ,p_fp_task_billable_flag_tab => p_fp_task_billable_flag_tab
8556: ,x_return_status => l_return_status
8557: ,x_msg_count => x_msg_count
8558: ,x_msg_data => x_msg_data);
8559: l_pls_end_time := dbms_utility.get_time;
8560: If P_PA_DEBUG_MODE = 'Y' Then
8561: print_msg('End of Validate Inputs:['||l_pls_end_time||']','Y');
8562: End If;
8563: print_plsql_time('End of Validate Inputs: Total time :['||(l_pls_end_time-l_pls_start_time)||']');

Line 8665: l_pls_start_time := dbms_utility.get_time;

8661: END IF;
8662:
8663: /* Bug fix: 3693097 The inparams contains G_MISS_NUM chars should be validated*/
8664: /*************************************************************************************
8665: l_pls_start_time := dbms_utility.get_time;
8666: --print_plsql_time('Start of MainLopp1:['||l_pls_start_time);
8667: *Bug:5309529: Performance improvement changes : the following loop and execution of cursors inside the loop
8668: *is removed and added a new api inside the PAFPCL1B.pls insert_spread_calctmp_records
8669: **************End of Bug fix:5309529 *****************************************/

Line 8671: l_pls_end_time := dbms_utility.get_time;

8667: *Bug:5309529: Performance improvement changes : the following loop and execution of cursors inside the loop
8668: *is removed and added a new api inside the PAFPCL1B.pls insert_spread_calctmp_records
8669: **************End of Bug fix:5309529 *****************************************/
8670:
8671: l_pls_end_time := dbms_utility.get_time;
8672: print_plsql_time('End of MainLopp1:Total time['||(l_pls_end_time - l_pls_start_time));
8673: l_stage := 133;
8674: IF l_return_status <> 'S' Then
8675: print_msg(l_stage||'Errors found in the params processing');

Line 8712: l_pls_start_time := dbms_utility.get_time;

8708: OR NVL(G_AGR_CONV_REQD_FLAG,'N') = 'Y' ) Then
8709: g_rollup_required_flag := 'N';
8710: End If;
8711: --print_msg('rollup required flag =>'||g_rollup_required_flag||']');
8712: l_pls_start_time := dbms_utility.get_time;
8713: --print_plsql_time('Start of populate_spreadCalc_tmp:['||l_pls_start_time);
8714:
8715: IF l_resource_assignment_tab.COUNT > 0 THEN --{
8716: If P_PA_DEBUG_MODE = 'Y' Then

Line 8800: l_pls_end_time := dbms_utility.get_time;

8796: ,x_neg_rev_Changflag_tab => l_neg_rev_Changflag_tab
8797: ,x_return_status => l_return_status
8798: ,x_msg_data => x_msg_data
8799: );
8800: l_pls_end_time := dbms_utility.get_time;
8801: print_plsql_time('End of populate_spreadCalc_tmp:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
8802: If P_PA_DEBUG_MODE = 'Y' Then
8803: print_msg('End of calling PA_FP_CALC_UTILS.populate_spreadCalc_Tmp retSts['||l_return_status||']');
8804: End If;

Line 8944: l_pls_start_time := dbms_utility.get_time;

8940: END IF; --}
8941:
8942: /* Bug fix:5203622 */
8943: IF l_entire_return_status = 'S' Then
8944: l_pls_start_time := dbms_utility.get_time;
8945: --print_plsql_time('Start of clear_etc_rev_other_rejectns :['||l_pls_start_time);
8946: clear_etc_rev_other_rejectns
8947: (p_budget_version_id => p_budget_version_id
8948: ,p_source_context => p_source_context

Line 8961: l_pls_end_time := dbms_utility.get_time;

8957: l_entire_return_status := l_return_status;
8958: GOTO END_OF_PROCESS;
8959: End If;
8960: END IF;
8961: l_pls_end_time := dbms_utility.get_time;
8962: print_plsql_time('End of clear_etc_rev_other_rejectns Total time :['||(l_pls_end_time-l_pls_start_time)||']');
8963:
8964: l_stage := 210;
8965: If P_PA_DEBUG_MODE = 'Y' Then

Line 8970: l_pls_start_time := dbms_utility.get_time;

8966: print_msg(to_char(l_stage)||' Entering loop using the l_resource_assignment_tab.resource_assignment_id');
8967: print_msg('l_resource_assignment_tab.first['||l_resource_assignment_tab.first||']Last['||l_resource_assignment_tab.last);
8968: print_msg(l_stage||':Count of Errors:MsgCtinErrStack['||fnd_msg_pub.count_msg||']');
8969: End If;
8970: l_pls_start_time := dbms_utility.get_time;
8971: --print_plsql_time('Start of MainLoop2:['||l_pls_start_time);
8972: --MAIN CODE STARTS HERE
8973: l_countr := 0;
8974: FOR i IN l_resource_assignment_tab.first..l_resource_assignment_tab.last LOOP

Line 10162: l_pls_end_time := dbms_utility.get_time;

10158: g_skip_record_tab(l_countr) := 'Y';
10159: END;
10160:
10161: END LOOP; --end loop from FOR i in l_resource_assignment_tab.first..l_resource_assignment_tab.last
10162: l_pls_end_time := dbms_utility.get_time;
10163: print_plsql_time('End of MainLoop2:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10164: If P_PA_DEBUG_MODE = 'Y' Then
10165: print_msg(to_char(l_stage)||'END RESOURCE_ASSIGNMENTS LOOP ');
10166: End If;

Line 10206: l_pls_start_time := dbms_utility.get_time;

10202: );
10203: If P_PA_DEBUG_MODE = 'Y' Then
10204: print_msg(to_char(l_stage)||' Spread is required call spread_amounts');
10205: End If;
10206: l_pls_start_time := dbms_utility.get_time;
10207: --print_plsql_time('Start of spread amounts:['||l_pls_start_time);
10208: PA_FP_SPREAD_AMTS_PKG.spread_amounts
10209: ( p_budget_version_id => g_budget_version_id
10210: ,x_return_status => l_return_status

Line 10214: l_pls_end_time := dbms_utility.get_time;

10210: ,x_return_status => l_return_status
10211: ,x_msg_count => x_msg_count
10212: ,x_msg_data => x_msg_data
10213: );
10214: l_pls_end_time := dbms_utility.get_time;
10215: print_plsql_time('End of spread amounts:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10216: If P_PA_DEBUG_MODE = 'Y' Then
10217: print_msg('After calling spread_amounts api retSts['||l_return_status||']msgdata['||x_msg_data||']');
10218: End If;

Line 10239: l_pls_start_time := dbms_utility.get_time;

10235: print_msg(to_char(l_stage)||' Spread is not required call populate_rollup_tmp');
10236: print_msg(to_char(l_stage)||' Populate global temporary tables :refresh_conv_rates_flag ['||g_refresh_conv_rates_flag||']');
10237: print_msg(']refresh_rates_flag['||g_refresh_rates_flag||']');
10238: End if;
10239: l_pls_start_time := dbms_utility.get_time;
10240: --print_plsql_time('Start of populate rollupTmp:['||l_pls_start_time);
10241: pa_fp_calc_plan_pkg.populate_rollup_tmp
10242: ( p_budget_version_id => g_budget_version_id
10243: ,x_return_status => l_return_status

Line 10247: l_pls_end_time := dbms_utility.get_time;

10243: ,x_return_status => l_return_status
10244: ,x_msg_count => x_msg_count
10245: ,x_msg_data => x_msg_data
10246: );
10247: l_pls_end_time := dbms_utility.get_time;
10248: print_plsql_time('End of populate rollupTmp:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10249: If P_PA_DEBUG_MODE = 'Y' Then
10250: print_msg('After Calling populate_rollup_tmp retSts['||l_return_status||']');
10251: End If;

Line 10266: l_pls_start_time := dbms_utility.get_time;

10262: If P_PA_DEBUG_MODE = 'Y' Then
10263: print_msg(l_stage||'Calling pa_fp_calc_plan_pkg.mass_adjust API');
10264: End If;
10265: /*bug fix:4657962 */
10266: l_pls_start_time := dbms_utility.get_time;
10267: --print_plsql_time('Start of MassAdjust:['||l_pls_start_time);
10268: pa_fp_calc_plan_pkg.mass_adjust_new
10269: ( p_budget_version_id => g_budget_version_id
10270: ,p_quantity_adj_pct => p_quantity_adj_pct

Line 10281: l_pls_end_time := dbms_utility.get_time;

10277: ,x_return_status => l_return_status
10278: ,x_msg_count => x_msg_count
10279: ,x_msg_data => x_msg_data
10280: );
10281: l_pls_end_time := dbms_utility.get_time;
10282: print_plsql_time('End of MassAdjust:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10283: If P_PA_DEBUG_MODE = 'Y' Then
10284: print_msg('End of pa_fp_calc_plan_pkg.mass_adjust API retSts['||l_return_status||']');
10285: End If;

Line 10303: l_pls_start_time := dbms_utility.get_time;

10299: AND g_applyProg_RaId_tab.COUNT > 0 ) Then
10300: If P_PA_DEBUG_MODE = 'Y' Then
10301: print_msg('Calling populate rollup tmp in apply progress mode to rederive the etc costs');
10302: End If;
10303: l_pls_start_time := dbms_utility.get_time;
10304: --print_plsql_time('Start of populaterollupTmp inApplyProgMode:['||l_pls_start_time);
10305: pa_fp_calc_plan_pkg.populate_rollup_tmp
10306: ( p_budget_version_id => g_budget_version_id
10307: ,x_return_status => l_return_status

Line 10311: l_pls_end_time := dbms_utility.get_time;

10307: ,x_return_status => l_return_status
10308: ,x_msg_count => x_msg_count
10309: ,x_msg_data => x_msg_data
10310: );
10311: l_pls_end_time := dbms_utility.get_time;
10312: print_plsql_time('End of populaterollupTmp inApplyProgMode:time :['||(l_pls_end_time-l_pls_start_time)||']');
10313: If P_PA_DEBUG_MODE = 'Y' Then
10314: print_msg('After Calling populate_rollup_tmp retSts['||l_return_status||']');
10315: End If;

Line 10407: l_pls_start_time := dbms_utility.get_time;

10403: l_stage := 543;
10404: If P_PA_DEBUG_MODE = 'Y' Then
10405: print_msg(l_stage||'Calling Update_rollupTmp_OvrRates API with genrationContext['||l_generation_context||']');
10406: End if;
10407: l_pls_start_time := dbms_utility.get_time;
10408: --print_plsql_time('Start of Update_rollupTmp_OvrRates:['||l_pls_start_time);
10409: Update_rollupTmp_OvrRates
10410: ( p_budget_version_id => g_budget_version_id
10411: ,p_calling_module => l_calling_module

Line 10417: l_pls_end_time := dbms_utility.get_time;

10413: ,x_return_status => l_return_status
10414: ,x_msg_count => x_msg_count
10415: ,x_msg_data => x_msg_data
10416: );
10417: l_pls_end_time := dbms_utility.get_time;
10418: print_plsql_time('End of Update_rollupTmp_OvrRates:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10419: If P_PA_DEBUG_MODE = 'Y' Then
10420: print_msg('After calling Update_rollupTmp_OvrRates api retSts['||l_return_status||']msgdata['||x_msg_data||']');
10421: End If;

Line 10435: l_pls_start_time := dbms_utility.get_time;

10431: AND CheckCacheRecExists(p_budget_version_id => g_budget_version_id) = 'Y') Then
10432: If P_PA_DEBUG_MODE = 'Y' Then
10433: print_msg('Calling PA_FP_CALC_UTILS.copy_BlAttributes api');
10434: End if;
10435: l_pls_start_time := dbms_utility.get_time;
10436: --print_plsql_time('Start of CopyBlAttributes:['||l_pls_start_time);
10437: PA_FP_CALC_UTILS.copy_BlAttributes(
10438: p_budget_verson_id => g_budget_version_id
10439: ,p_source_context => g_source_context

Line 10445: l_pls_end_time := dbms_utility.get_time;

10441: ,p_apply_progress_flag => p_apply_progress_flag
10442: ,x_return_status =>l_return_status
10443: ,x_msg_data => x_msg_data
10444: );
10445: l_pls_end_time := dbms_utility.get_time;
10446: print_plsql_time('End of CopyBlAttributes:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10447: If P_PA_DEBUG_MODE = 'Y' Then
10448: print_msg('returnSts of PA_FP_CALC_UTILS.copy_BlAttributes['||l_return_status||']');
10449: End If;

Line 10509: l_pls_start_time := dbms_utility.get_time;

10505:
10506: If P_PA_DEBUG_MODE = 'Y' Then
10507: print_msg('Calling Rate API');
10508: End if;
10509: l_pls_start_time := dbms_utility.get_time;
10510: --print_plsql_time('Start of Get_Res_RATEs:['||l_pls_start_time);
10511: Get_Res_RATEs
10512: (p_calling_module => l_calling_module
10513: ,p_activity_code => l_activity_code

Line 10522: l_pls_end_time := dbms_utility.get_time;

10518: ,x_return_status => l_return_status
10519: ,x_msg_data => x_msg_data
10520: ,x_msg_count => x_msg_count
10521: ) ;
10522: l_pls_end_time := dbms_utility.get_time;
10523: print_plsql_time('End of Get_Res_RATEs:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10524: If P_PA_DEBUG_MODE = 'Y' Then
10525: print_msg('After Calling Rate API retSTS['||l_return_status||']');
10526: End if;

Line 10547: l_pls_start_time := dbms_utility.get_time;

10543: *.as the fix is done for AMG rollup. Will ask Ranga to evaluate this for non-AMG flows and remove the if condition.
10544: *.This can then be put in FP M rollup with extensive QE testing */
10545: IF ( p_calling_module = 'AMG_API' )
10546: THEN
10547: l_pls_start_time := dbms_utility.get_time;
10548: --print_plsql_time('Start of update_diffcols: time :'||l_pls_start_time);
10549: PA_FP_CALC_UTILS.update_dffcols(
10550: p_budget_verson_id => g_budget_version_id
10551: ,p_source_context => g_source_context

Line 10558: l_pls_end_time := dbms_utility.get_time;

10554: ,x_return_status => l_return_status
10555: ,x_msg_count => x_msg_count
10556: ,x_msg_data => x_msg_data
10557: );
10558: l_pls_end_time := dbms_utility.get_time;
10559: print_plsql_time('End of update_diffcols:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10560: If P_PA_DEBUG_MODE = 'Y' Then
10561: print_msg('returnSts of PA_FP_CALC_UTILS.update_dff['||l_return_status||']');
10562: End if;

Line 10642: l_pls_start_time := dbms_utility.get_time;

10638: l_cl_raw_rejection_code_tab.delete;
10639: l_cl_burd_rejection_code_tab.delete;
10640: l_cl_rev_rejection_code_tab.delete;
10641: l_cl_cntr := 0;
10642: l_pls_start_time := dbms_utility.get_time;
10643: --print_plsql_time('Start of ClientExtnLoop:Start time :['||l_pls_end_time||']');
10644: FOR rec IN get_client_xtn_rollup_csr LOOP
10645: l_stage := 910;
10646: --print_msg(to_char(l_stage)||' INSIDE get_client_xtn_rollup_csr LOOP');

Line 10906: l_pls_end_time := dbms_utility.get_time;

10902: WHERE tmp.budget_line_id = l_cl_budget_line_id_tab(i);
10903: --print_msg('Number rows updated with ClientExtnUpd['||sql%rowcount||']');
10904: END IF;
10905: End If;
10906: l_pls_end_time := dbms_utility.get_time;
10907: print_plsql_time('End of ClientExtnLoop:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10908: End If; -- end of client extension calls
10909:
10910: /* Rounding Enhancements: Update the last rollup tmp line with the rounding discrepancy amounts */

Line 10912: l_pls_start_time := dbms_utility.get_time;

10908: End If; -- end of client extension calls
10909:
10910: /* Rounding Enhancements: Update the last rollup tmp line with the rounding discrepancy amounts */
10911: IF NVL(l_entire_return_status,'S') = 'S' AND NVL(g_track_wp_costs_flag,'Y') = 'Y' THEN
10912: l_pls_start_time := dbms_utility.get_time;
10913: --print_plsql_time('Start of Update_rounding_diff:['||l_pls_start_time);
10914: Update_rounding_diff(
10915: p_project_id => p_project_id
10916: ,p_budget_version_id => g_budget_version_id

Line 10925: l_pls_end_time := dbms_utility.get_time;

10921: ,x_return_status => l_return_status
10922: ,x_msg_count => x_msg_count
10923: ,x_msg_data => l_msg_data --5028631
10924: );
10925: l_pls_end_time := dbms_utility.get_time;
10926: print_plsql_time('End of Update_rounding_diff:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
10927: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10928: x_return_status := l_return_status;
10929: x_msg_data := l_msg_data; --5028631

Line 10977: l_pls_start_time := dbms_utility.get_time;

10973: l_stage := 1010;
10974: If P_PA_DEBUG_MODE = 'Y' Then
10975: print_msg(to_char(l_stage)||'Calling convert_txn_currency with the following parameters:');
10976: End if;
10977: l_pls_start_time := dbms_utility.get_time;
10978: --print_plsql_time('Start of Currency Conversion['||l_pls_start_time);
10979: pa_fp_multi_currency_pkg.convert_txn_currency
10980: ( p_budget_version_id => g_budget_version_id
10981: ,p_entire_version => 'N'

Line 10987: l_pls_end_time := dbms_utility.get_time;

10983: ,x_return_status => l_return_status
10984: ,x_msg_count => x_msg_count
10985: ,x_msg_data => l_msg_data --5028631
10986: );
10987: l_pls_end_time := dbms_utility.get_time;
10988: print_plsql_time('End of Currency ConversionTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
10989: If P_PA_DEBUG_MODE = 'Y' Then
10990: print_msg('AFter calling convert_txn_currency API returnSTS['||l_return_status||']');
10991: End if;

Line 11029: l_pls_start_time := dbms_utility.get_time;

11025: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp
11026: */
11027: l_stage := 1100;
11028: /* Bug fix: 4184159 moved to bulk update pa_fp_calc_plan_pkg.update_budget_lines */
11029: l_pls_start_time := dbms_utility.get_time;
11030: --print_plsql_time('Start of BLK UpdateBudget Lines:['||l_pls_start_time);
11031: PA_FP_CALC_UTILS.BLK_update_budget_lines
11032: ( p_budget_version_id => p_budget_version_id
11033: ,p_calling_module => l_calling_module -- Added for Bug#5395732

Line 11038: l_pls_end_time := dbms_utility.get_time;

11034: ,x_return_status => l_return_status
11035: ,x_msg_count => x_msg_count
11036: ,x_msg_data => l_msg_data --5028631
11037: );
11038: l_pls_end_time := dbms_utility.get_time;
11039: print_plsql_time('End of BLK UpdateBudget Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11040: If P_PA_DEBUG_MODE = 'Y' Then
11041: print_msg('AFter calling update_budget_lines retSTst['||l_return_status||']MsgData['||l_msg_data||']');
11042: End if;

Line 11054: l_pls_start_time := dbms_utility.get_time;

11050: IF NVL(p_raTxn_rollup_api_call_flag,'Y') = 'Y' AND nvl(l_entire_return_status,'S') = 'S' Then
11051: If P_PA_DEBUG_MODE = 'Y' Then
11052: print_msg('Calling populate_raTxn_Recs API');
11053: End if;
11054: l_pls_start_time := dbms_utility.get_time;
11055: --print_plsql_time('Start of populate_raTxn_Recs :['||l_pls_start_time);
11056: delete_raTxn_Tmp;
11057: populate_raTxn_Recs (
11058: p_budget_version_id => g_budget_version_id

Line 11070: l_pls_end_time := dbms_utility.get_time;

11066: ,x_return_status => l_return_status
11067: ,x_msg_count => x_msg_count
11068: ,x_msg_data => l_msg_data --5028631
11069: );
11070: l_pls_end_time := dbms_utility.get_time;
11071: print_plsql_time('End of populate_raTxn_RecsTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11072: If P_PA_DEBUG_MODE = 'Y' Then
11073: print_msg('AFter calling populate_raTxn_Recs retSTst['||l_return_status||']MsgData['||l_msg_data||']');
11074: End if;

Line 11101: l_pls_start_time := dbms_utility.get_time;

11097: END IF;
11098: If p_pa_debug_mode = 'Y' Then
11099: DbugPjiVals;
11100: End If;
11101: l_pls_start_time := dbms_utility.get_time;
11102: --print_plsql_time('Start of PJI reporting:['||l_pls_start_time);
11103:
11104: BEGIN
11105:

Line 11157: l_pls_end_time := dbms_utility.get_time;

11153: END IF;
11154: END IF;
11155: END;
11156:
11157: l_pls_end_time := dbms_utility.get_time;
11158: print_plsql_time('End of PJI reporting:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11159: If P_PA_DEBUG_MODE = 'Y' Then
11160: print_msg('AFter calling PA_FP_PJI_INTG_PKG retSTst['||l_return_status||']MsgData['||l_msg_data||']');
11161: End if;

Line 11182: l_pls_start_time := dbms_utility.get_time;

11178: l_stage := 1210;
11179: If P_PA_DEBUG_MODE = 'Y' Then
11180: print_msg('Rollup PC and PFC to RA ');
11181: End if;
11182: l_pls_start_time := dbms_utility.get_time;
11183: --print_plsql_time('Start of rollup_pf_pfc_to_ra :['||l_pls_start_time);
11184: pa_fp_calc_plan_pkg.rollup_pf_pfc_to_ra
11185: ( p_budget_version_id => g_budget_version_id
11186: ,x_return_status => l_return_status

Line 11190: l_pls_end_time := dbms_utility.get_time;

11186: ,x_return_status => l_return_status
11187: ,x_msg_count => x_msg_count
11188: ,x_msg_data => l_msg_data --5028631
11189: );
11190: l_pls_end_time := dbms_utility.get_time;
11191: print_plsql_time('End of rollup_pf_pfc_to_raTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11192: If P_PA_DEBUG_MODE = 'Y' Then
11193: print_msg('After calling pa_fp_calc_plan_pkg.rollup_pf_pfc_to_ra retSts['||l_return_status||']msgData['||l_msg_data||']');
11194: End if;

Line 11215: l_pls_start_time := dbms_utility.get_time;

11211: */
11212: If P_PA_DEBUG_MODE = 'Y' Then
11213: print_msg(l_stage||'Calling Delete_BL_Where_Nulls API');
11214: End if;
11215: l_pls_start_time := dbms_utility.get_time;
11216: --print_plsql_time('Start of Delete_BL_Where_Nulls :['||l_pls_start_time);
11217: Delete_BL_Where_Nulls
11218: ( p_budget_version_id => p_budget_version_id
11219: ,p_resource_assignment_tab => l_resource_assignment_tab

Line 11223: l_pls_end_time := dbms_utility.get_time;

11219: ,p_resource_assignment_tab => l_resource_assignment_tab
11220: ,x_return_status => l_return_status
11221: ,x_msg_data => l_msg_data --5028631
11222: );
11223: l_pls_end_time := dbms_utility.get_time;
11224: print_plsql_time('End of Delete_BL_Where_NullsTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11225: If P_PA_DEBUG_MODE = 'Y' Then
11226: print_msg('AFter calling Delete_BL_Where_Nulls retSTst['||l_return_status||']MsgData['||l_msg_data||']');
11227: End if;

Line 11246: l_pls_start_time := dbms_utility.get_time;

11242: IF (NVL(l_entire_return_status,'S') = 'S' AND NVL(g_wp_version_flag,'N') = 'N'
11243: AND NVL(g_mrc_installed_flag,'N') = 'Y'
11244: AND PA_MRC_FINPLAN.G_FINPLAN_MRC_OPTION_CODE = 'A'
11245: AND NVL(g_conv_rates_required_flag,'Y') = 'Y' ) Then
11246: l_pls_start_time := dbms_utility.get_time;
11247: --print_plsql_time('Start of MRC:['||l_pls_start_time);
11248:
11249: l_stage := 1280;
11250: IF (NVL(G_populate_mrc_tab_flag,'N') = 'Y' AND g_mrc_budget_line_id_tab.COUNT > 0 ) Then

Line 11292: l_pls_end_time := dbms_utility.get_time;

11288: x_msg_data := l_msg_data; --5028631
11289: print_msg('Failed Unexpected exception in MRC API['||sqlcode||sqlerrm);
11290: GOTO END_OF_PROCESS;
11291: END IF;
11292: l_pls_end_time := dbms_utility.get_time;
11293: print_plsql_time('End of MRC:Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11294: End If;
11295: **************END of MRC Elimination changes ***/
11296:

Line 11305: l_pls_start_time := dbms_utility.get_time;

11301: l_stage := 1300;
11302: If P_PA_DEBUG_MODE = 'Y' Then
11303: print_msg(to_char(l_stage)||' Calling rollup_pf_pfc_to_bv with following parameters:');
11304: End if;
11305: l_pls_start_time := dbms_utility.get_time;
11306: --print_plsql_time('Start of rollup_pf_pfc_to_bv:['||l_pls_start_time);
11307: pa_fp_calc_plan_pkg.rollup_pf_pfc_to_bv
11308: ( p_budget_version_id => g_budget_version_id
11309: ,x_return_status => l_return_status

Line 11313: l_pls_end_time := dbms_utility.get_time;

11309: ,x_return_status => l_return_status
11310: ,x_msg_count => x_msg_count
11311: ,x_msg_data => l_msg_data --5028631
11312: );
11313: l_pls_end_time := dbms_utility.get_time;
11314: print_plsql_time('End of rollup_pf_pfc_to_bvTotal time :['||(l_pls_end_time-l_pls_start_time)||']');
11315: If P_PA_DEBUG_MODE = 'Y' Then
11316: print_msg('After calling pa_fp_calc_plan_pkg.rollup_pf_pfc_to_bv retSts['||l_return_status||']msgData['||l_msg_data||']');
11317: End if;

Line 11375: l_pls_start_time := dbms_utility.get_time;

11371: END IF; -- g_fp_multi_curr_enabled = Y
11372:
11373: /* Bug fix:5203622 */
11374: IF l_entire_return_status = 'S' Then
11375: l_pls_start_time := dbms_utility.get_time;
11376: --print_plsql_time('Start of clear_etc_rev_other_rejectns['||l_pls_start_time);
11377: clear_etc_rev_other_rejectns
11378: (p_budget_version_id => p_budget_version_id
11379: ,p_source_context => p_source_context

Line 11386: l_pls_end_time := dbms_utility.get_time;

11382: ,x_return_status => l_return_status
11383: ,x_msg_count => x_msg_count
11384: ,x_msg_data => l_msg_data
11385: );
11386: l_pls_end_time := dbms_utility.get_time;
11387: print_plsql_time('end of clear_etc_rev_Total time :['||(l_pls_end_time-l_pls_start_time)||']');
11388: If l_return_status <> 'S' Then
11389: x_return_status := 'E';
11390: l_entire_return_status := l_return_status;

Line 11454: l_pls_end_time := dbms_utility.get_time;

11450:
11451: If cur_ra_txn_rates%isopen then
11452: close cur_ra_txn_rates;
11453: end if;
11454: l_pls_end_time := dbms_utility.get_time;
11455: /* End of bug fix:4343985 */
11456: If P_PA_DEBUG_MODE = 'Y' Then
11457: print_msg('LEAVING calculate bvid => '||g_budget_version_id||' ,pid => '||g_project_id||' ,sesstime => '||g_session_time);
11458: print_msg('x_return_status : '||x_return_status||']x_msg_count['||x_msg_count||']x_msg_data['||x_msg_data||']');