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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 32: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

28: X_MSG_COUNT OUT NOCOPY NUMBER,
29: X_MSG_DATA OUT NOCOPY VARCHAR2)
30: IS
31: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT';
32: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
33: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
34: l_wp_ptype_id Number;
35: l_wp_status VARCHAR2(20);
36: l_wp_id Number := NULL;

Line 33: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

29: X_MSG_DATA OUT NOCOPY VARCHAR2)
30: IS
31: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT';
32: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
33: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
34: l_wp_ptype_id Number;
35: l_wp_status VARCHAR2(20);
36: l_wp_id Number := NULL;
37: l_source_id Number;

Line 527: pa_fp_gen_amount_utils.fp_debug

523: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
524: END IF;
525:
526: IF P_PA_DEBUG_MODE = 'Y' THEN
527: pa_fp_gen_amount_utils.fp_debug
528: ( p_called_mode => p_called_mode,
529: p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
530: p_module_name => l_module_name,
531: p_log_level => 5 );

Line 529: p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

525:
526: IF P_PA_DEBUG_MODE = 'Y' THEN
527: pa_fp_gen_amount_utils.fp_debug
528: ( p_called_mode => p_called_mode,
529: p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
530: p_module_name => l_module_name,
531: p_log_level => 5 );
532: END IF;
533: /*Calling the UTIL API to get the target financial plan info l_fp_cols_rec_target*/

Line 534: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

530: p_module_name => l_module_name,
531: p_log_level => 5 );
532: END IF;
533: /*Calling the UTIL API to get the target financial plan info l_fp_cols_rec_target*/
534: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
535: ( P_PROJECT_ID => P_PROJECT_ID,
536: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
537: X_FP_COLS_REC => l_fp_cols_rec_target,
538: X_RETURN_STATUS => x_return_status,

Line 542: pa_fp_gen_amount_utils.fp_debug

538: X_RETURN_STATUS => x_return_status,
539: X_MSG_COUNT => x_msg_count,
540: X_MSG_DATA => x_msg_data );
541: IF P_PA_DEBUG_MODE = 'Y' THEN
542: pa_fp_gen_amount_utils.fp_debug
543: ( p_called_mode => p_called_mode,
544: p_msg => 'Status after calling
545: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
546: ||x_return_status,

Line 545: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

541: IF P_PA_DEBUG_MODE = 'Y' THEN
542: pa_fp_gen_amount_utils.fp_debug
543: ( p_called_mode => p_called_mode,
544: p_msg => 'Status after calling
545: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
546: ||x_return_status,
547: p_module_name => l_module_name,
548: p_log_level => 5 );
549: END IF;

Line 708: pa_fp_gen_amount_utils.fp_debug

704: OR l_gen_src_plan_ver_code = 'CURRENT_APPROVED'
705: OR l_gen_src_plan_ver_code = 'ORIGINAL_APPROVED' THEN
706: /*Get the current baselined or original baselined version*/
707: IF P_PA_DEBUG_MODE = 'Y' THEN
708: pa_fp_gen_amount_utils.fp_debug
709: ( p_called_mode => p_called_mode,
710: p_msg => 'Before calling
711: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
712: p_module_name => l_module_name,

Line 711: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',

707: IF P_PA_DEBUG_MODE = 'Y' THEN
708: pa_fp_gen_amount_utils.fp_debug
709: ( p_called_mode => p_called_mode,
710: p_msg => 'Before calling
711: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
712: p_module_name => l_module_name,
713: p_log_level => 5 );
714: END IF;
715: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

Line 715: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

711: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
712: p_module_name => l_module_name,
713: p_log_level => 5 );
714: END IF;
715: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
716: p_project_id => P_PROJECT_ID,
717: p_fin_plan_type_id => l_fp_cols_rec_target.X_GEN_SRC_PLAN_TYPE_ID,
718: p_version_type => 'COST',
719: p_status_code => l_gen_src_plan_ver_code,

Line 726: pa_fp_gen_amount_utils.fp_debug

722: x_return_status => x_return_status,
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data );
725: IF P_PA_DEBUG_MODE = 'Y' THEN
726: pa_fp_gen_amount_utils.fp_debug
727: ( p_called_mode => p_called_mode,
728: p_msg => 'Status after calling
729: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'
730: ||x_return_status,

Line 729: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'

725: IF P_PA_DEBUG_MODE = 'Y' THEN
726: pa_fp_gen_amount_utils.fp_debug
727: ( p_called_mode => p_called_mode,
728: p_msg => 'Status after calling
729: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'
730: ||x_return_status,
731: p_module_name => l_module_name,
732: p_log_level => 5 );
733: END IF;

Line 741: pa_fp_gen_amount_utils.fp_debug

737:
738: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
739: /*Get the current working version*/
740: IF P_PA_DEBUG_MODE = 'Y' THEN
741: pa_fp_gen_amount_utils.fp_debug
742: ( p_called_mode => p_called_mode,
743: p_msg => 'Before calling
744: pa_fin_plan_utils.Get_Curr_Working_Version_Info',
745: p_module_name => l_module_name,

Line 758: pa_fp_gen_amount_utils.fp_debug

754: x_return_status => x_return_status,
755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data );
757: IF P_PA_DEBUG_MODE = 'Y' THEN
758: pa_fp_gen_amount_utils.fp_debug
759: ( p_called_mode => p_called_mode,
760: p_msg => 'Status after calling
761: pa_fin_plan_utils.Get_Curr_Working_Version_Info'
762: ||x_return_status,

Line 808: pa_fp_gen_amount_utils.fp_debug

804:
805:
806: /*Calling the UTIL API to get the source info l_fp_cols_rec_source*/
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_fp_gen_amount_utils.fp_debug
809: ( p_called_mode => p_called_mode,
810: p_msg => 'Before calling
811: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
812: p_module_name => l_module_name,

Line 811: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_fp_gen_amount_utils.fp_debug
809: ( p_called_mode => p_called_mode,
810: p_msg => 'Before calling
811: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
812: p_module_name => l_module_name,
813: p_log_level => 5 );
814: END IF;
815: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 815: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

811: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
812: p_module_name => l_module_name,
813: p_log_level => 5 );
814: END IF;
815: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
816: ( P_PROJECT_ID => P_PROJECT_ID,
817: P_BUDGET_VERSION_ID => l_source_id,
818: X_FP_COLS_REC => l_fp_cols_rec_source,
819: X_RETURN_STATUS => x_return_status,

Line 823: pa_fp_gen_amount_utils.fp_debug

819: X_RETURN_STATUS => x_return_status,
820: X_MSG_COUNT => x_msg_count,
821: X_MSG_DATA => x_msg_data );
822: IF P_PA_DEBUG_MODE = 'Y' THEN
823: pa_fp_gen_amount_utils.fp_debug
824: ( p_called_mode => p_called_mode,
825: p_msg => 'Status after calling
826: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
827: ||x_return_status,

Line 826: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

822: IF P_PA_DEBUG_MODE = 'Y' THEN
823: pa_fp_gen_amount_utils.fp_debug
824: ( p_called_mode => p_called_mode,
825: p_msg => 'Status after calling
826: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
827: ||x_return_status,
828: p_module_name => l_module_name,
829: p_log_level => 5 );
830: END IF;

Line 888: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

884: -- from the source are honored when possible, since resources created by
885: -- the Copy Actuals API use task/project-level default dates.
886: IF l_calling_context = lc_ForecastGeneration THEN
887: IF p_pa_debug_mode = 'Y' THEN
888: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
889: P_CALLED_MODE => P_CALLED_MODE,
890: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
891: P_MODULE_NAME => l_module_name);
892: END IF;

Line 904: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

900: X_RETURN_STATUS => X_RETURN_STATUS,
901: X_MSG_COUNT => X_MSG_COUNT,
902: X_MSG_DATA => X_MSG_DATA);
903: IF p_pa_debug_mode = 'Y' THEN
904: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
905: P_CALLED_MODE => P_CALLED_MODE,
906: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
907: ||x_return_status,
908: P_MODULE_NAME => l_module_name);

Line 999: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

995: l_SYS_LINK_FUNCTION_tab(j) := null;
996: END LOOP;
997:
998: IF P_PA_DEBUG_MODE = 'Y' THEN
999: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1000: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
1001: P_MODULE_NAME => l_module_name);
1002: END IF;
1003: -- Bug 3962468: Changed P_RESOURCE_LIST_ID parameter from

Line 1057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1053: X_RETURN_STATUS => x_return_status,
1054: X_MSG_COUNT => x_msg_count,
1055: X_MSG_DATA => x_msg_data );
1056: IF P_PA_DEBUG_MODE = 'Y' THEN
1057: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1058: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
1059: x_return_status,
1060: P_MODULE_NAME => l_module_name);
1061: END IF;

Line 1080: pa_fp_gen_amount_utils.fp_debug

1076: select distinct resource_list_member_id,txn_task_id
1077: bulk collect into tmp_rlm_tab, tmp_task_tab
1078: from PA_RES_LIST_MAP_TMP4;
1079: for i in 1..tmp_rlm_tab.count loop
1080: pa_fp_gen_amount_utils.fp_debug
1081: (p_called_mode => p_called_mode,
1082: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)
1083: ||'; @@task in tmp4:'||tmp_task_tab(i),
1084: p_module_name => l_module_name,

Line 1092: pa_fp_gen_amount_utils.fp_debug

1088: select 'Y' into tmp_flag from PA_RESource_list_members
1089: where resource_list_member_id = tmp_rlm_tab(i);
1090: --dbms_output.put_line('@@exist in rlm? '||tmp_flag);
1091: IF P_PA_DEBUG_MODE = 'Y' THEN
1092: pa_fp_gen_amount_utils.fp_debug
1093: (p_called_mode => p_called_mode,
1094: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)||
1095: '@@exist in rlm?'||tmp_flag,
1096: p_module_name => l_module_name,

Line 1103: pa_fp_gen_amount_utils.fp_debug

1099: exception
1100: when no_data_found then
1101: --dbms_output.put_line('@@exist in rlm? '||'N');
1102: IF P_PA_DEBUG_MODE = 'Y' THEN
1103: pa_fp_gen_amount_utils.fp_debug
1104: (p_called_mode => p_called_mode,
1105: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)||
1106: '@@exist in rlm?'||'N',
1107: p_module_name => l_module_name,

Line 1209: pa_fp_gen_amount_utils.fp_debug

1205: END IF;
1206: END IF;
1207:
1208: IF P_PA_DEBUG_MODE = 'Y' THEN
1209: pa_fp_gen_amount_utils.fp_debug
1210: ( p_called_mode => p_called_mode,
1211: p_msg => 'Before calling
1212: pa_fp_gen_budget_amt_pub.create_res_asg',
1213: p_module_name => l_module_name,

Line 1230: pa_fp_gen_amount_utils.fp_debug

1226:
1227: -- select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4;
1228: -- dbms_output.put_line('after calling cre res asg api, tmp4 has: '||l_count1);
1229: IF P_PA_DEBUG_MODE = 'Y' THEN
1230: pa_fp_gen_amount_utils.fp_debug
1231: ( p_called_mode => p_called_mode,
1232: p_msg => 'Status after calling
1233: pa_fp_gen_budget_amt_pub.create_res_asg: '
1234: ||x_return_status,

Line 1251: pa_fp_gen_amount_utils.fp_debug

1247: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1248: from PA_RESOURCE_ASSIGNMENTS
1249: where budget_version_id = P_BUDGET_VERSION_ID;
1250: for i in 1..tmp_ra_tab.count loop
1251: pa_fp_gen_amount_utils.fp_debug
1252: (p_called_mode => p_called_mode,
1253: p_msg => 'after create res asg, rlm in RA:'||tmp_rlm_tab(i)
1254: ||'; task in RA:'||tmp_task_tab(i)
1255: ||'; ra id in RA:'||tmp_ra_tab(i),

Line 1273: pa_fp_gen_amount_utils.fp_debug

1269: -- dbms_output.put_line('before calling upd res asg api: res assign has: '||l_count);
1270:
1271: /*Calling UPDATE_RES_ASG API to update resource_assignment_id in tmp4 for target budget version*/
1272: IF P_PA_DEBUG_MODE = 'Y' THEN
1273: pa_fp_gen_amount_utils.fp_debug
1274: ( p_called_mode => p_called_mode,
1275: p_msg => 'Before calling
1276: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG',
1277: p_module_name => l_module_name,

Line 1299: pa_fp_gen_amount_utils.fp_debug

1295: -- select count(*) into l_count from pa_resource_assignments where
1296: -- budget_version_id = p_budget_version_id;
1297: -- dbms_output.put_line('after calling upd res asg api: res assign has: '||l_count);
1298: IF P_PA_DEBUG_MODE = 'Y' THEN
1299: pa_fp_gen_amount_utils.fp_debug
1300: ( p_called_mode => p_called_mode,
1301: p_msg => 'Status after calling
1302: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG: '
1303: ||x_return_status,

Line 1345: pa_fp_gen_amount_utils.fp_debug

1341: select distinct resource_list_member_id,txn_task_id,txn_resource_assignment_id
1342: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1343: from PA_RES_LIST_MAP_TMP4;
1344: for i in 1..tmp_rlm_tab.count loop
1345: pa_fp_gen_amount_utils.fp_debug
1346: (p_called_mode => p_called_mode,
1347: p_msg => 'after update res asg, @@rlm in tmp4:'||tmp_rlm_tab(i)
1348: ||'; @@task in tmp4:'||tmp_task_tab(i)
1349: ||'; @@ra id in tmp4:'||tmp_ra_tab(i),

Line 1373: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

1369: FROM pa_res_list_map_tmp4 tmp
1370: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1371: AND rownum = 1 );
1372: ELSIF l_calling_context = lc_ForecastGeneration THEN
1373: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
1374: ( p_budget_version_id );
1375: IF l_fp_cols_rec_target.x_time_phased_code IN ('P','G') THEN
1376: DELETE FROM pa_budget_lines bl
1377: WHERE budget_version_id = p_budget_version_id

Line 1436: pa_fp_gen_amount_utils.fp_debug

1432: l_fp_cols_rec_target.X_TIME_PHASED_CODE
1433: THEN
1434: /*API to populating from Source budget lines table to Target budget lines table*/
1435: IF P_PA_DEBUG_MODE = 'Y' THEN
1436: pa_fp_gen_amount_utils.fp_debug
1437: ( p_called_mode => p_called_mode,
1438: p_msg => 'Before calling
1439: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES',
1440: p_module_name => l_module_name,

Line 1454: pa_fp_gen_amount_utils.fp_debug

1450: X_RETURN_STATUS => x_return_Status,
1451: X_MSG_COUNT => x_msg_count,
1452: X_MSG_DATA => x_msg_data );
1453: IF P_PA_DEBUG_MODE = 'Y' THEN
1454: pa_fp_gen_amount_utils.fp_debug
1455: ( p_called_mode => p_called_mode,
1456: p_msg => 'Status after calling
1457: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES: '
1458: ||x_return_status,

Line 1544: pa_fp_gen_amount_utils.fp_debug

1540: * before leaving this flow since it is not handled by the forecast
1541: * generation flow, and is normally handled by the Calculate API in
1542: * the budget generation flow. */
1543: IF p_pa_debug_mode = 'Y' THEN
1544: pa_fp_gen_amount_utils.fp_debug
1545: ( p_msg => 'Before calling
1546: pa_fp_maintain_actual_pub.sync_up_planning_dates',
1547: p_module_name => l_module_name,
1548: p_log_level => 5 );

Line 1556: pa_fp_gen_amount_utils.fp_debug

1552: X_RETURN_STATUS => x_return_Status,
1553: X_MSG_COUNT => x_msg_count,
1554: X_MSG_DATA => x_msg_data );
1555: IF p_pa_debug_mode = 'Y' THEN
1556: pa_fp_gen_amount_utils.fp_debug
1557: ( p_msg => 'Status after calling
1558: pa_fp_maintain_actual_pub.sync_up_planning_dates'
1559: ||x_return_status,
1560: p_module_name => l_module_name,

Line 1639: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1635: /* API to get pro-rated amounts for the first source period, which may
1636: * be passed by during source data collection if the target's actual through
1637: * date falls between the start and end dates of the first source period. */
1638: IF P_PA_DEBUG_MODE = 'Y' THEN
1639: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1640: ( p_called_mode => p_called_mode,
1641: p_msg => 'Before calling ' ||
1642: 'PA_FP_GEN_PUB.PRORATE_UNALIGNED_PERIOD_AMTS',
1643: p_module_name => l_module_name,

Line 1663: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1659: X_RETURN_STATUS => x_return_Status,
1660: X_MSG_COUNT => x_msg_count,
1661: X_MSG_DATA => x_msg_data );
1662: IF P_PA_DEBUG_MODE = 'Y' THEN
1663: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1664: ( p_called_mode => p_called_mode,
1665: p_msg => 'Status after calling ' ||
1666: 'PA_FP_GEN_PUB.PRORATE_UNALIGNED_PERIOD_AMTS: ' ||
1667: x_return_status,

Line 2582: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2578: END IF;
2579:
2580: /* Get the api code for the Calculate API call. */
2581: IF p_pa_debug_mode = 'Y' THEN
2582: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2583: ( p_called_mode => p_called_mode,
2584: p_msg => 'Before calling ' ||
2585: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS',
2586: p_module_name => l_module_name,

Line 2599: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2595: X_RETURN_STATUS => x_return_status,
2596: X_MSG_COUNT => x_msg_count,
2597: X_MSG_DATA => x_msg_data );
2598: IF p_pa_debug_mode = 'Y' THEN
2599: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2600: ( p_called_mode => p_called_mode,
2601: p_msg => 'Status after calling ' ||
2602: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS: ' ||
2603: x_return_status,

Line 2646: pa_fp_gen_amount_utils.fp_debug

2642:
2643: --hr_utility.trace('bef calling calculate api:'||x_return_status);
2644: /*Calling the calculate API*/
2645: IF P_PA_DEBUG_MODE = 'Y' THEN
2646: pa_fp_gen_amount_utils.fp_debug
2647: (p_called_mode => p_called_mode,
2648: p_msg => 'Before calling
2649: PA_FP_CALC_PLAN_PKG.calculate',
2650: p_module_name => l_module_name,

Line 2691: pa_fp_gen_amount_utils.fp_debug

2687: x_msg_data => x_msg_data);
2688: --hr_utility.trace('aft calling calculate api: '||x_return_status);
2689:
2690: IF P_PA_DEBUG_MODE = 'Y' THEN
2691: pa_fp_gen_amount_utils.fp_debug
2692: (p_called_mode => p_called_mode,
2693: p_msg => 'Status after calling
2694: PA_FP_CALC_PLAN_PKG.calculate: '
2695: ||x_return_status,

Line 2731: pa_fp_gen_amount_utils.fp_debug

2727:
2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729:
2730: IF P_PA_DEBUG_MODE = 'Y' THEN
2731: pa_fp_gen_amount_utils.fp_debug
2732: ( p_called_mode => p_called_mode,
2733: p_msg => 'Invalid Arguments Passed',
2734: p_module_name => l_module_name,
2735: p_log_level => 5 );

Line 2751: pa_fp_gen_amount_utils.fp_debug

2747: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',
2748: p_procedure_name => 'GENERATE_WP_BUDGET_AMT',
2749: p_error_text => substr(sqlerrm,1,240));
2750: IF P_PA_DEBUG_MODE = 'Y' THEN
2751: pa_fp_gen_amount_utils.fp_debug
2752: ( p_called_mode => p_called_mode,
2753: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2754: p_module_name => l_module_name,
2755: p_log_level => 5);

Line 3267: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

3263: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3264: l_b_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3265: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3266:
3267: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3268: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3269:
3270: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

Line 3268: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

3264: l_b_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3265: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3266:
3267: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3268: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3269:
3270: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3272: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 3476: pa_fp_gen_amount_utils.fp_debug

3472: l_calling_context := lc_BudgetGeneration;
3473: END IF;
3474:
3475: IF P_PA_DEBUG_MODE = 'Y' THEN
3476: pa_fp_gen_amount_utils.fp_debug
3477: ( p_msg => 'Before calling
3478: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3479: p_module_name => l_module_name,
3480: p_log_level => 5 );

Line 3478: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

3474:
3475: IF P_PA_DEBUG_MODE = 'Y' THEN
3476: pa_fp_gen_amount_utils.fp_debug
3477: ( p_msg => 'Before calling
3478: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3479: p_module_name => l_module_name,
3480: p_log_level => 5 );
3481: END IF;
3482: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (

Line 3482: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (

3478: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3479: p_module_name => l_module_name,
3480: p_log_level => 5 );
3481: END IF;
3482: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (
3483: P_PROJECT_ID => P_PROJECT_ID,
3484: P_BUDGET_VERSION_ID => P_SOURCE_BV_ID,
3485: X_FP_COLS_REC => l_fp_cols_rec_source,
3486: X_RETURN_STATUS => x_return_status,

Line 3490: pa_fp_gen_amount_utils.fp_debug

3486: X_RETURN_STATUS => x_return_status,
3487: X_MSG_COUNT => x_msg_count,
3488: X_MSG_DATA => x_msg_data );
3489: IF P_PA_DEBUG_MODE = 'Y' THEN
3490: pa_fp_gen_amount_utils.fp_debug
3491: ( p_msg => 'Status after calling
3492: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3493: ||x_return_status,
3494: p_module_name => l_module_name,

Line 3492: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

3488: X_MSG_DATA => x_msg_data );
3489: IF P_PA_DEBUG_MODE = 'Y' THEN
3490: pa_fp_gen_amount_utils.fp_debug
3491: ( p_msg => 'Status after calling
3492: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3493: ||x_return_status,
3494: p_module_name => l_module_name,
3495: p_log_level => 5 );
3496: END IF;

Line 3502: pa_fp_gen_amount_utils.fp_debug

3498: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3499: END IF;
3500:
3501: IF P_PA_DEBUG_MODE = 'Y' THEN
3502: pa_fp_gen_amount_utils.fp_debug
3503: ( p_msg => 'Before calling
3504: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3505: p_module_name => l_module_name,
3506: p_log_level => 5 );

Line 3504: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

3500:
3501: IF P_PA_DEBUG_MODE = 'Y' THEN
3502: pa_fp_gen_amount_utils.fp_debug
3503: ( p_msg => 'Before calling
3504: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3505: p_module_name => l_module_name,
3506: p_log_level => 5 );
3507: END IF;
3508: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 3508: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

3504: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3505: p_module_name => l_module_name,
3506: p_log_level => 5 );
3507: END IF;
3508: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
3509: ( P_PROJECT_ID => P_PROJECT_ID,
3510: P_BUDGET_VERSION_ID => P_TARGET_BV_ID,
3511: X_FP_COLS_REC => l_fp_cols_rec_target,
3512: X_RETURN_STATUS => x_return_status,

Line 3516: pa_fp_gen_amount_utils.fp_debug

3512: X_RETURN_STATUS => x_return_status,
3513: X_MSG_COUNT => x_msg_count,
3514: X_MSG_DATA => x_msg_data );
3515: IF P_PA_DEBUG_MODE = 'Y' THEN
3516: pa_fp_gen_amount_utils.fp_debug
3517: ( p_msg => 'Status after calling
3518: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3519: ||x_return_status,
3520: p_module_name => l_module_name,

Line 3518: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

3514: X_MSG_DATA => x_msg_data );
3515: IF P_PA_DEBUG_MODE = 'Y' THEN
3516: pa_fp_gen_amount_utils.fp_debug
3517: ( p_msg => 'Status after calling
3518: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3519: ||x_return_status,
3520: p_module_name => l_module_name,
3521: p_log_level => 5 );
3522: END IF;

Line 3543: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

3539: l_fp_src_plan_ver_id := p_source_bv_id;
3540: END IF;
3541:
3542: IF p_pa_debug_mode = 'Y' THEN
3543: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
3544: ( p_msg => 'Before calling ' ||
3545: 'PA_FP_FCST_GEN_AMT_UTILS.COMPARE_ETC_SRC_TARGET_FP_OPT',
3546: p_module_name => l_module_name,
3547: p_log_level => 5 );

Line 3559: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

3555: X_RETURN_STATUS => x_return_status,
3556: X_MSG_COUNT => x_msg_count,
3557: X_MSG_DATA => x_msg_data );
3558: IF p_pa_debug_mode = 'Y' THEN
3559: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
3560: ( p_msg => 'Status after calling ' ||
3561: 'PA_FP_FCST_GEN_AMT_UTILS.COMPARE_ETC_SRC_TARGET_FP_OPT: ' ||
3562: x_return_status,
3563: p_module_name => l_module_name,

Line 3709: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3705: IF l_fp_cols_rec_target.x_gen_ret_manual_line_flag = 'N' THEN
3706:
3707: -- Call the maintenance api in COPY mode
3708: IF p_pa_debug_mode = 'Y' THEN
3709: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3710: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3711: 'MAINTAIN_DATA',
3712: --P_CALLED_MODE => p_called_mode,
3713: P_MODULE_NAME => l_module_name);

Line 3727: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3723: X_RETURN_STATUS => x_return_status,
3724: X_MSG_COUNT => x_msg_count,
3725: X_MSG_DATA => x_msg_data );
3726: IF p_pa_debug_mode = 'Y' THEN
3727: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3728: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3729: 'MAINTAIN_DATA: '||x_return_status,
3730: --P_CALLED_MODE => p_called_mode,
3731: P_MODULE_NAME => l_module_name);

Line 3758: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3754: FROM pa_res_list_map_tmp4;
3755:
3756: -- Call the maintenance api in COPY mode
3757: IF p_pa_debug_mode = 'Y' THEN
3758: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3759: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3760: 'MAINTAIN_DATA',
3761: --P_CALLED_MODE => p_called_mode,
3762: P_MODULE_NAME => l_module_name);

Line 3776: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3772: X_RETURN_STATUS => x_return_status,
3773: X_MSG_COUNT => x_msg_count,
3774: X_MSG_DATA => x_msg_data );
3775: IF p_pa_debug_mode = 'Y' THEN
3776: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3777: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3778: 'MAINTAIN_DATA: '||x_return_status,
3779: --P_CALLED_MODE => p_called_mode,
3780: P_MODULE_NAME => l_module_name);

Line 3828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3824:
3825: IF l_count > 0 THEN
3826: -- CALL the maintenance api in INSERT mode
3827: IF p_pa_debug_mode = 'Y' THEN
3828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3829: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3830: 'MAINTAIN_DATA',
3831: --P_CALLED_MODE => p_called_mode,
3832: P_MODULE_NAME => l_module_name);

Line 3844: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3840: X_RETURN_STATUS => x_return_status,
3841: X_MSG_COUNT => x_msg_count,
3842: X_MSG_DATA => x_msg_data );
3843: IF p_pa_debug_mode = 'Y' THEN
3844: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3845: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3846: 'MAINTAIN_DATA: '||x_return_status,
3847: --P_CALLED_MODE => p_called_mode,
3848: P_MODULE_NAME => l_module_name);

Line 5160: pa_fp_gen_amount_utils.fp_debug

5156: l_source_context := 'BUDGET_LINE';
5157:
5158: --Calling the calculate API
5159: IF P_PA_DEBUG_MODE = 'Y' THEN
5160: pa_fp_gen_amount_utils.fp_debug
5161: (p_msg => 'Before calling
5162: PA_FP_CALC_PLAN_PKG.calculate',
5163: p_module_name => l_module_name,
5164: p_log_level => 5);

Line 5195: pa_fp_gen_amount_utils.fp_debug

5191: x_msg_count => x_msg_count,
5192: x_msg_data => x_msg_data);
5193: --hr_utility.trace('aft calling calculate api: '||x_return_status);
5194: IF P_PA_DEBUG_MODE = 'Y' THEN
5195: pa_fp_gen_amount_utils.fp_debug
5196: (p_msg => 'Status after calling
5197: PA_FP_CALC_PLAN_PKG.calculate: '
5198: ||x_return_status,
5199: p_module_name => l_module_name,

Line 5514: pa_fp_gen_amount_utils.fp_debug

5510: l_b_cost_rate_override_tab(i),
5511: '', /* bug 7693017 */
5512: l_markup_percent_tab(i)); /* Added for Bug 5166047 */
5513: IF P_PA_DEBUG_MODE = 'Y' THEN
5514: pa_fp_gen_amount_utils.fp_debug
5515: ( p_msg => 'After inserting into target budget lines',
5516: p_module_name => l_module_name,
5517: p_log_level => 5 );
5518: END IF;

Line 5563: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

5559: AND bl.txn_currency_code = rbc.txn_currency_code (+);
5560:
5561: -- Call the maintenance api in ROLLUP mode
5562: IF p_pa_debug_mode = 'Y' THEN
5563: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5564: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
5565: 'MAINTAIN_DATA',
5566: --P_CALLED_MODE => p_called_mode,
5567: P_MODULE_NAME => l_module_name);

Line 5579: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

5575: X_RETURN_STATUS => x_return_status,
5576: X_MSG_COUNT => x_msg_count,
5577: X_MSG_DATA => x_msg_data );
5578: IF p_pa_debug_mode = 'Y' THEN
5579: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5580: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
5581: 'MAINTAIN_DATA: '||x_return_status,
5582: --P_CALLED_MODE => p_called_mode,
5583: P_MODULE_NAME => l_module_name);

Line 5615: pa_fp_gen_amount_utils.fp_debug

5611: ROLLBACK;
5612:
5613: x_return_status := FND_API.G_RET_STS_ERROR;
5614: IF P_PA_DEBUG_MODE = 'Y' THEN
5615: pa_fp_gen_amount_utils.fp_debug
5616: ( p_msg => 'Invalid Arguments Passed',
5617: p_module_name => l_module_name,
5618: p_log_level => 5);
5619: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5633: pa_fp_gen_amount_utils.fp_debug

5629: p_procedure_name => 'MAINTAIN_BUDGET_LINES',
5630: p_error_text => substr(sqlerrm,1,240) );
5631:
5632: IF P_PA_DEBUG_MODE = 'Y' THEN
5633: pa_fp_gen_amount_utils.fp_debug
5634: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5635: p_module_name => l_module_name,
5636: p_log_level => 5 );
5637: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5664: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5660: * x_calculate_api_code is modified.
5661: */
5662: PROCEDURE GET_CALC_API_FLAG_PARAMS
5663: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5664: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5665: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5666: P_CALLING_CONTEXT IN VARCHAR2,
5667: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,
5668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5665: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5661: */
5662: PROCEDURE GET_CALC_API_FLAG_PARAMS
5663: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5664: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5665: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5666: P_CALLING_CONTEXT IN VARCHAR2,
5667: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,
5668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5669: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5876: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5872: ROLLBACK;
5873: x_return_status := FND_API.G_RET_STS_ERROR;
5874:
5875: IF p_pa_debug_mode = 'Y' THEN
5876: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5877: ( p_msg => 'Invalid Arguments Passed',
5878: p_module_name => l_module_name,
5879: p_log_level => 5 );
5880: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5890: p_procedure_name => 'GET_CALC_API_FLAG_PARAMS',
5891: p_error_text => substr(sqlerrm,1,240) );
5892:
5893: IF p_pa_debug_mode = 'Y' THEN
5894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5895: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5896: p_module_name => l_module_name,
5897: p_log_level => 5 );
5898: PA_DEBUG.RESET_CURR_FUNCTION;