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 491: pa_fp_gen_amount_utils.fp_debug

487: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
488: END IF;
489:
490: IF P_PA_DEBUG_MODE = 'Y' THEN
491: pa_fp_gen_amount_utils.fp_debug
492: ( p_called_mode => p_called_mode,
493: p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
494: p_module_name => l_module_name,
495: p_log_level => 5 );

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

489:
490: IF P_PA_DEBUG_MODE = 'Y' THEN
491: pa_fp_gen_amount_utils.fp_debug
492: ( p_called_mode => p_called_mode,
493: p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
494: p_module_name => l_module_name,
495: p_log_level => 5 );
496: END IF;
497: /*Calling the UTIL API to get the target financial plan info l_fp_cols_rec_target*/

Line 498: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

494: p_module_name => l_module_name,
495: p_log_level => 5 );
496: END IF;
497: /*Calling the UTIL API to get the target financial plan info l_fp_cols_rec_target*/
498: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
499: ( P_PROJECT_ID => P_PROJECT_ID,
500: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
501: X_FP_COLS_REC => l_fp_cols_rec_target,
502: X_RETURN_STATUS => x_return_status,

Line 506: pa_fp_gen_amount_utils.fp_debug

502: X_RETURN_STATUS => x_return_status,
503: X_MSG_COUNT => x_msg_count,
504: X_MSG_DATA => x_msg_data );
505: IF P_PA_DEBUG_MODE = 'Y' THEN
506: pa_fp_gen_amount_utils.fp_debug
507: ( p_called_mode => p_called_mode,
508: p_msg => 'Status after calling
509: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
510: ||x_return_status,

Line 509: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

505: IF P_PA_DEBUG_MODE = 'Y' THEN
506: pa_fp_gen_amount_utils.fp_debug
507: ( p_called_mode => p_called_mode,
508: p_msg => 'Status after calling
509: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
510: ||x_return_status,
511: p_module_name => l_module_name,
512: p_log_level => 5 );
513: END IF;

Line 672: pa_fp_gen_amount_utils.fp_debug

668: OR l_gen_src_plan_ver_code = 'CURRENT_APPROVED'
669: OR l_gen_src_plan_ver_code = 'ORIGINAL_APPROVED' THEN
670: /*Get the current baselined or original baselined version*/
671: IF P_PA_DEBUG_MODE = 'Y' THEN
672: pa_fp_gen_amount_utils.fp_debug
673: ( p_called_mode => p_called_mode,
674: p_msg => 'Before calling
675: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
676: p_module_name => l_module_name,

Line 675: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',

671: IF P_PA_DEBUG_MODE = 'Y' THEN
672: pa_fp_gen_amount_utils.fp_debug
673: ( p_called_mode => p_called_mode,
674: p_msg => 'Before calling
675: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
676: p_module_name => l_module_name,
677: p_log_level => 5 );
678: END IF;
679: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

Line 679: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(

675: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
676: p_module_name => l_module_name,
677: p_log_level => 5 );
678: END IF;
679: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info(
680: p_project_id => P_PROJECT_ID,
681: p_fin_plan_type_id => l_fp_cols_rec_target.X_GEN_SRC_PLAN_TYPE_ID,
682: p_version_type => 'COST',
683: p_status_code => l_gen_src_plan_ver_code,

Line 690: pa_fp_gen_amount_utils.fp_debug

686: x_return_status => x_return_status,
687: x_msg_count => x_msg_count,
688: x_msg_data => x_msg_data );
689: IF P_PA_DEBUG_MODE = 'Y' THEN
690: pa_fp_gen_amount_utils.fp_debug
691: ( p_called_mode => p_called_mode,
692: p_msg => 'Status after calling
693: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'
694: ||x_return_status,

Line 693: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'

689: IF P_PA_DEBUG_MODE = 'Y' THEN
690: pa_fp_gen_amount_utils.fp_debug
691: ( p_called_mode => p_called_mode,
692: p_msg => 'Status after calling
693: pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info'
694: ||x_return_status,
695: p_module_name => l_module_name,
696: p_log_level => 5 );
697: END IF;

Line 705: pa_fp_gen_amount_utils.fp_debug

701:
702: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
703: /*Get the current working version*/
704: IF P_PA_DEBUG_MODE = 'Y' THEN
705: pa_fp_gen_amount_utils.fp_debug
706: ( p_called_mode => p_called_mode,
707: p_msg => 'Before calling
708: pa_fin_plan_utils.Get_Curr_Working_Version_Info',
709: p_module_name => l_module_name,

Line 722: pa_fp_gen_amount_utils.fp_debug

718: x_return_status => x_return_status,
719: x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data );
721: IF P_PA_DEBUG_MODE = 'Y' THEN
722: pa_fp_gen_amount_utils.fp_debug
723: ( p_called_mode => p_called_mode,
724: p_msg => 'Status after calling
725: pa_fin_plan_utils.Get_Curr_Working_Version_Info'
726: ||x_return_status,

Line 772: pa_fp_gen_amount_utils.fp_debug

768:
769:
770: /*Calling the UTIL API to get the source info l_fp_cols_rec_source*/
771: IF P_PA_DEBUG_MODE = 'Y' THEN
772: pa_fp_gen_amount_utils.fp_debug
773: ( p_called_mode => p_called_mode,
774: p_msg => 'Before calling
775: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
776: p_module_name => l_module_name,

Line 775: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

771: IF P_PA_DEBUG_MODE = 'Y' THEN
772: pa_fp_gen_amount_utils.fp_debug
773: ( p_called_mode => p_called_mode,
774: p_msg => 'Before calling
775: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
776: p_module_name => l_module_name,
777: p_log_level => 5 );
778: END IF;
779: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 779: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

775: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
776: p_module_name => l_module_name,
777: p_log_level => 5 );
778: END IF;
779: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
780: ( P_PROJECT_ID => P_PROJECT_ID,
781: P_BUDGET_VERSION_ID => l_source_id,
782: X_FP_COLS_REC => l_fp_cols_rec_source,
783: X_RETURN_STATUS => x_return_status,

Line 787: pa_fp_gen_amount_utils.fp_debug

783: X_RETURN_STATUS => x_return_status,
784: X_MSG_COUNT => x_msg_count,
785: X_MSG_DATA => x_msg_data );
786: IF P_PA_DEBUG_MODE = 'Y' THEN
787: pa_fp_gen_amount_utils.fp_debug
788: ( p_called_mode => p_called_mode,
789: p_msg => 'Status after calling
790: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
791: ||x_return_status,

Line 790: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

786: IF P_PA_DEBUG_MODE = 'Y' THEN
787: pa_fp_gen_amount_utils.fp_debug
788: ( p_called_mode => p_called_mode,
789: p_msg => 'Status after calling
790: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
791: ||x_return_status,
792: p_module_name => l_module_name,
793: p_log_level => 5 );
794: END IF;

Line 852: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

848: -- from the source are honored when possible, since resources created by
849: -- the Copy Actuals API use task/project-level default dates.
850: IF l_calling_context = lc_ForecastGeneration THEN
851: IF p_pa_debug_mode = 'Y' THEN
852: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
853: P_CALLED_MODE => P_CALLED_MODE,
854: P_MSG => 'Before calling pa_fp_copy_actuals_pub.copy_actuals',
855: P_MODULE_NAME => l_module_name);
856: END IF;

Line 868: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

864: X_RETURN_STATUS => X_RETURN_STATUS,
865: X_MSG_COUNT => X_MSG_COUNT,
866: X_MSG_DATA => X_MSG_DATA);
867: IF p_pa_debug_mode = 'Y' THEN
868: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
869: P_CALLED_MODE => P_CALLED_MODE,
870: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
871: ||x_return_status,
872: P_MODULE_NAME => l_module_name);

Line 961: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

957: l_SYS_LINK_FUNCTION_tab(j) := null;
958: END LOOP;
959:
960: IF P_PA_DEBUG_MODE = 'Y' THEN
961: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
962: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
963: P_MODULE_NAME => l_module_name);
964: END IF;
965: -- Bug 3962468: Changed P_RESOURCE_LIST_ID parameter from

Line 1018: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1014: X_RETURN_STATUS => x_return_status,
1015: X_MSG_COUNT => x_msg_count,
1016: X_MSG_DATA => x_msg_data );
1017: IF P_PA_DEBUG_MODE = 'Y' THEN
1018: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1019: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
1020: x_return_status,
1021: P_MODULE_NAME => l_module_name);
1022: END IF;

Line 1041: pa_fp_gen_amount_utils.fp_debug

1037: select distinct resource_list_member_id,txn_task_id
1038: bulk collect into tmp_rlm_tab, tmp_task_tab
1039: from PA_RES_LIST_MAP_TMP4;
1040: for i in 1..tmp_rlm_tab.count loop
1041: pa_fp_gen_amount_utils.fp_debug
1042: (p_called_mode => p_called_mode,
1043: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)
1044: ||'; @@task in tmp4:'||tmp_task_tab(i),
1045: p_module_name => l_module_name,

Line 1053: pa_fp_gen_amount_utils.fp_debug

1049: select 'Y' into tmp_flag from PA_RESource_list_members
1050: where resource_list_member_id = tmp_rlm_tab(i);
1051: --dbms_output.put_line('@@exist in rlm? '||tmp_flag);
1052: IF P_PA_DEBUG_MODE = 'Y' THEN
1053: pa_fp_gen_amount_utils.fp_debug
1054: (p_called_mode => p_called_mode,
1055: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)||
1056: '@@exist in rlm?'||tmp_flag,
1057: p_module_name => l_module_name,

Line 1064: pa_fp_gen_amount_utils.fp_debug

1060: exception
1061: when no_data_found then
1062: --dbms_output.put_line('@@exist in rlm? '||'N');
1063: IF P_PA_DEBUG_MODE = 'Y' THEN
1064: pa_fp_gen_amount_utils.fp_debug
1065: (p_called_mode => p_called_mode,
1066: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)||
1067: '@@exist in rlm?'||'N',
1068: p_module_name => l_module_name,

Line 1167: pa_fp_gen_amount_utils.fp_debug

1163: END IF;
1164: END IF;
1165:
1166: IF P_PA_DEBUG_MODE = 'Y' THEN
1167: pa_fp_gen_amount_utils.fp_debug
1168: ( p_called_mode => p_called_mode,
1169: p_msg => 'Before calling
1170: pa_fp_gen_budget_amt_pub.create_res_asg',
1171: p_module_name => l_module_name,

Line 1188: pa_fp_gen_amount_utils.fp_debug

1184:
1185: -- select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4;
1186: -- dbms_output.put_line('after calling cre res asg api, tmp4 has: '||l_count1);
1187: IF P_PA_DEBUG_MODE = 'Y' THEN
1188: pa_fp_gen_amount_utils.fp_debug
1189: ( p_called_mode => p_called_mode,
1190: p_msg => 'Status after calling
1191: pa_fp_gen_budget_amt_pub.create_res_asg: '
1192: ||x_return_status,

Line 1209: pa_fp_gen_amount_utils.fp_debug

1205: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1206: from PA_RESOURCE_ASSIGNMENTS
1207: where budget_version_id = P_BUDGET_VERSION_ID;
1208: for i in 1..tmp_ra_tab.count loop
1209: pa_fp_gen_amount_utils.fp_debug
1210: (p_called_mode => p_called_mode,
1211: p_msg => 'after create res asg, rlm in RA:'||tmp_rlm_tab(i)
1212: ||'; task in RA:'||tmp_task_tab(i)
1213: ||'; ra id in RA:'||tmp_ra_tab(i),

Line 1231: pa_fp_gen_amount_utils.fp_debug

1227: -- dbms_output.put_line('before calling upd res asg api: res assign has: '||l_count);
1228:
1229: /*Calling UPDATE_RES_ASG API to update resource_assignment_id in tmp4 for target budget version*/
1230: IF P_PA_DEBUG_MODE = 'Y' THEN
1231: pa_fp_gen_amount_utils.fp_debug
1232: ( p_called_mode => p_called_mode,
1233: p_msg => 'Before calling
1234: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG',
1235: p_module_name => l_module_name,

Line 1257: pa_fp_gen_amount_utils.fp_debug

1253: -- select count(*) into l_count from pa_resource_assignments where
1254: -- budget_version_id = p_budget_version_id;
1255: -- dbms_output.put_line('after calling upd res asg api: res assign has: '||l_count);
1256: IF P_PA_DEBUG_MODE = 'Y' THEN
1257: pa_fp_gen_amount_utils.fp_debug
1258: ( p_called_mode => p_called_mode,
1259: p_msg => 'Status after calling
1260: PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG: '
1261: ||x_return_status,

Line 1303: pa_fp_gen_amount_utils.fp_debug

1299: select distinct resource_list_member_id,txn_task_id,txn_resource_assignment_id
1300: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1301: from PA_RES_LIST_MAP_TMP4;
1302: for i in 1..tmp_rlm_tab.count loop
1303: pa_fp_gen_amount_utils.fp_debug
1304: (p_called_mode => p_called_mode,
1305: p_msg => 'after update res asg, @@rlm in tmp4:'||tmp_rlm_tab(i)
1306: ||'; @@task in tmp4:'||tmp_task_tab(i)
1307: ||'; @@ra id in tmp4:'||tmp_ra_tab(i),

Line 1331: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

1327: FROM pa_res_list_map_tmp4 tmp
1328: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1329: AND rownum = 1 );
1330: ELSIF l_calling_context = lc_ForecastGeneration THEN
1331: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
1332: ( p_budget_version_id );
1333: IF l_fp_cols_rec_target.x_time_phased_code IN ('P','G') THEN
1334: DELETE FROM pa_budget_lines bl
1335: WHERE budget_version_id = p_budget_version_id

Line 1394: pa_fp_gen_amount_utils.fp_debug

1390: l_fp_cols_rec_target.X_TIME_PHASED_CODE
1391: THEN
1392: /*API to populating from Source budget lines table to Target budget lines table*/
1393: IF P_PA_DEBUG_MODE = 'Y' THEN
1394: pa_fp_gen_amount_utils.fp_debug
1395: ( p_called_mode => p_called_mode,
1396: p_msg => 'Before calling
1397: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES',
1398: p_module_name => l_module_name,

Line 1412: pa_fp_gen_amount_utils.fp_debug

1408: X_RETURN_STATUS => x_return_Status,
1409: X_MSG_COUNT => x_msg_count,
1410: X_MSG_DATA => x_msg_data );
1411: IF P_PA_DEBUG_MODE = 'Y' THEN
1412: pa_fp_gen_amount_utils.fp_debug
1413: ( p_called_mode => p_called_mode,
1414: p_msg => 'Status after calling
1415: PA_FP_WP_GEN_BUDGET_AMT_PUB.MAINTAIN_BUDGET_LINES: '
1416: ||x_return_status,

Line 1502: pa_fp_gen_amount_utils.fp_debug

1498: * before leaving this flow since it is not handled by the forecast
1499: * generation flow, and is normally handled by the Calculate API in
1500: * the budget generation flow. */
1501: IF p_pa_debug_mode = 'Y' THEN
1502: pa_fp_gen_amount_utils.fp_debug
1503: ( p_msg => 'Before calling
1504: pa_fp_maintain_actual_pub.sync_up_planning_dates',
1505: p_module_name => l_module_name,
1506: p_log_level => 5 );

Line 1514: pa_fp_gen_amount_utils.fp_debug

1510: X_RETURN_STATUS => x_return_Status,
1511: X_MSG_COUNT => x_msg_count,
1512: X_MSG_DATA => x_msg_data );
1513: IF p_pa_debug_mode = 'Y' THEN
1514: pa_fp_gen_amount_utils.fp_debug
1515: ( p_msg => 'Status after calling
1516: pa_fp_maintain_actual_pub.sync_up_planning_dates'
1517: ||x_return_status,
1518: p_module_name => l_module_name,

Line 1597: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1593: /* API to get pro-rated amounts for the first source period, which may
1594: * be passed by during source data collection if the target's actual through
1595: * date falls between the start and end dates of the first source period. */
1596: IF P_PA_DEBUG_MODE = 'Y' THEN
1597: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1598: ( p_called_mode => p_called_mode,
1599: p_msg => 'Before calling ' ||
1600: 'PA_FP_GEN_PUB.PRORATE_UNALIGNED_PERIOD_AMTS',
1601: p_module_name => l_module_name,

Line 1621: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

1617: X_RETURN_STATUS => x_return_Status,
1618: X_MSG_COUNT => x_msg_count,
1619: X_MSG_DATA => x_msg_data );
1620: IF P_PA_DEBUG_MODE = 'Y' THEN
1621: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1622: ( p_called_mode => p_called_mode,
1623: p_msg => 'Status after calling ' ||
1624: 'PA_FP_GEN_PUB.PRORATE_UNALIGNED_PERIOD_AMTS: ' ||
1625: x_return_status,

Line 2540: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2536: END IF;
2537:
2538: /* Get the api code for the Calculate API call. */
2539: IF p_pa_debug_mode = 'Y' THEN
2540: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2541: ( p_called_mode => p_called_mode,
2542: p_msg => 'Before calling ' ||
2543: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS',
2544: p_module_name => l_module_name,

Line 2557: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

2553: X_RETURN_STATUS => x_return_status,
2554: X_MSG_COUNT => x_msg_count,
2555: X_MSG_DATA => x_msg_data );
2556: IF p_pa_debug_mode = 'Y' THEN
2557: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2558: ( p_called_mode => p_called_mode,
2559: p_msg => 'Status after calling ' ||
2560: 'PA_FP_WP_GEN_BUDGET_AMT_PUB.GET_CALC_API_FLAG_PARAMS: ' ||
2561: x_return_status,

Line 2604: pa_fp_gen_amount_utils.fp_debug

2600:
2601: --hr_utility.trace('bef calling calculate api:'||x_return_status);
2602: /*Calling the calculate API*/
2603: IF P_PA_DEBUG_MODE = 'Y' THEN
2604: pa_fp_gen_amount_utils.fp_debug
2605: (p_called_mode => p_called_mode,
2606: p_msg => 'Before calling
2607: PA_FP_CALC_PLAN_PKG.calculate',
2608: p_module_name => l_module_name,

Line 2649: pa_fp_gen_amount_utils.fp_debug

2645: x_msg_data => x_msg_data);
2646: --hr_utility.trace('aft calling calculate api: '||x_return_status);
2647:
2648: IF P_PA_DEBUG_MODE = 'Y' THEN
2649: pa_fp_gen_amount_utils.fp_debug
2650: (p_called_mode => p_called_mode,
2651: p_msg => 'Status after calling
2652: PA_FP_CALC_PLAN_PKG.calculate: '
2653: ||x_return_status,

Line 2689: pa_fp_gen_amount_utils.fp_debug

2685:
2686: x_return_status := FND_API.G_RET_STS_ERROR;
2687:
2688: IF P_PA_DEBUG_MODE = 'Y' THEN
2689: pa_fp_gen_amount_utils.fp_debug
2690: ( p_called_mode => p_called_mode,
2691: p_msg => 'Invalid Arguments Passed',
2692: p_module_name => l_module_name,
2693: p_log_level => 5 );

Line 2709: pa_fp_gen_amount_utils.fp_debug

2705: ( p_pkg_name => 'PA_FP_WP_GEN_BUDGET_AMT_PUB',
2706: p_procedure_name => 'GENERATE_WP_BUDGET_AMT',
2707: p_error_text => substr(sqlerrm,1,240));
2708: IF P_PA_DEBUG_MODE = 'Y' THEN
2709: pa_fp_gen_amount_utils.fp_debug
2710: ( p_called_mode => p_called_mode,
2711: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2712: p_module_name => l_module_name,
2713: p_log_level => 5);

Line 3189: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

3185: l_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3186: l_b_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3187: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3188:
3189: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3190: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3191:
3192: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3193: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

Line 3190: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

3186: l_b_cost_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3187: l_bill_rate_override_tab pa_plsql_datatypes.NumTabTyp;
3188:
3189: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3190: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3191:
3192: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3193: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3194: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

Line 3398: pa_fp_gen_amount_utils.fp_debug

3394: l_calling_context := lc_BudgetGeneration;
3395: END IF;
3396:
3397: IF P_PA_DEBUG_MODE = 'Y' THEN
3398: pa_fp_gen_amount_utils.fp_debug
3399: ( p_msg => 'Before calling
3400: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3401: p_module_name => l_module_name,
3402: p_log_level => 5 );

Line 3400: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

3396:
3397: IF P_PA_DEBUG_MODE = 'Y' THEN
3398: pa_fp_gen_amount_utils.fp_debug
3399: ( p_msg => 'Before calling
3400: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3401: p_module_name => l_module_name,
3402: p_log_level => 5 );
3403: END IF;
3404: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (

Line 3404: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (

3400: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3401: p_module_name => l_module_name,
3402: p_log_level => 5 );
3403: END IF;
3404: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS (
3405: P_PROJECT_ID => P_PROJECT_ID,
3406: P_BUDGET_VERSION_ID => P_SOURCE_BV_ID,
3407: X_FP_COLS_REC => l_fp_cols_rec_source,
3408: X_RETURN_STATUS => x_return_status,

Line 3412: pa_fp_gen_amount_utils.fp_debug

3408: X_RETURN_STATUS => x_return_status,
3409: X_MSG_COUNT => x_msg_count,
3410: X_MSG_DATA => x_msg_data );
3411: IF P_PA_DEBUG_MODE = 'Y' THEN
3412: pa_fp_gen_amount_utils.fp_debug
3413: ( p_msg => 'Status after calling
3414: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3415: ||x_return_status,
3416: p_module_name => l_module_name,

Line 3414: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

3410: X_MSG_DATA => x_msg_data );
3411: IF P_PA_DEBUG_MODE = 'Y' THEN
3412: pa_fp_gen_amount_utils.fp_debug
3413: ( p_msg => 'Status after calling
3414: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3415: ||x_return_status,
3416: p_module_name => l_module_name,
3417: p_log_level => 5 );
3418: END IF;

Line 3424: pa_fp_gen_amount_utils.fp_debug

3420: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3421: END IF;
3422:
3423: IF P_PA_DEBUG_MODE = 'Y' THEN
3424: pa_fp_gen_amount_utils.fp_debug
3425: ( p_msg => 'Before calling
3426: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3427: p_module_name => l_module_name,
3428: p_log_level => 5 );

Line 3426: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

3422:
3423: IF P_PA_DEBUG_MODE = 'Y' THEN
3424: pa_fp_gen_amount_utils.fp_debug
3425: ( p_msg => 'Before calling
3426: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3427: p_module_name => l_module_name,
3428: p_log_level => 5 );
3429: END IF;
3430: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

Line 3430: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS

3426: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
3427: p_module_name => l_module_name,
3428: p_log_level => 5 );
3429: END IF;
3430: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS
3431: ( P_PROJECT_ID => P_PROJECT_ID,
3432: P_BUDGET_VERSION_ID => P_TARGET_BV_ID,
3433: X_FP_COLS_REC => l_fp_cols_rec_target,
3434: X_RETURN_STATUS => x_return_status,

Line 3438: pa_fp_gen_amount_utils.fp_debug

3434: X_RETURN_STATUS => x_return_status,
3435: X_MSG_COUNT => x_msg_count,
3436: X_MSG_DATA => x_msg_data );
3437: IF P_PA_DEBUG_MODE = 'Y' THEN
3438: pa_fp_gen_amount_utils.fp_debug
3439: ( p_msg => 'Status after calling
3440: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3441: ||x_return_status,
3442: p_module_name => l_module_name,

Line 3440: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

3436: X_MSG_DATA => x_msg_data );
3437: IF P_PA_DEBUG_MODE = 'Y' THEN
3438: pa_fp_gen_amount_utils.fp_debug
3439: ( p_msg => 'Status after calling
3440: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
3441: ||x_return_status,
3442: p_module_name => l_module_name,
3443: p_log_level => 5 );
3444: END IF;

Line 3465: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

3461: l_fp_src_plan_ver_id := p_source_bv_id;
3462: END IF;
3463:
3464: IF p_pa_debug_mode = 'Y' THEN
3465: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
3466: ( p_msg => 'Before calling ' ||
3467: 'PA_FP_FCST_GEN_AMT_UTILS.COMPARE_ETC_SRC_TARGET_FP_OPT',
3468: p_module_name => l_module_name,
3469: p_log_level => 5 );

Line 3481: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

3477: X_RETURN_STATUS => x_return_status,
3478: X_MSG_COUNT => x_msg_count,
3479: X_MSG_DATA => x_msg_data );
3480: IF p_pa_debug_mode = 'Y' THEN
3481: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
3482: ( p_msg => 'Status after calling ' ||
3483: 'PA_FP_FCST_GEN_AMT_UTILS.COMPARE_ETC_SRC_TARGET_FP_OPT: ' ||
3484: x_return_status,
3485: p_module_name => l_module_name,

Line 3631: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3627: IF l_fp_cols_rec_target.x_gen_ret_manual_line_flag = 'N' THEN
3628:
3629: -- Call the maintenance api in COPY mode
3630: IF p_pa_debug_mode = 'Y' THEN
3631: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3632: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3633: 'MAINTAIN_DATA',
3634: --P_CALLED_MODE => p_called_mode,
3635: P_MODULE_NAME => l_module_name);

Line 3649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3645: X_RETURN_STATUS => x_return_status,
3646: X_MSG_COUNT => x_msg_count,
3647: X_MSG_DATA => x_msg_data );
3648: IF p_pa_debug_mode = 'Y' THEN
3649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3650: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3651: 'MAINTAIN_DATA: '||x_return_status,
3652: --P_CALLED_MODE => p_called_mode,
3653: P_MODULE_NAME => l_module_name);

Line 3680: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3676: FROM pa_res_list_map_tmp4;
3677:
3678: -- Call the maintenance api in COPY mode
3679: IF p_pa_debug_mode = 'Y' THEN
3680: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3681: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3682: 'MAINTAIN_DATA',
3683: --P_CALLED_MODE => p_called_mode,
3684: P_MODULE_NAME => l_module_name);

Line 3698: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3694: X_RETURN_STATUS => x_return_status,
3695: X_MSG_COUNT => x_msg_count,
3696: X_MSG_DATA => x_msg_data );
3697: IF p_pa_debug_mode = 'Y' THEN
3698: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3699: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3700: 'MAINTAIN_DATA: '||x_return_status,
3701: --P_CALLED_MODE => p_called_mode,
3702: P_MODULE_NAME => l_module_name);

Line 3750: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3746:
3747: IF l_count > 0 THEN
3748: -- CALL the maintenance api in INSERT mode
3749: IF p_pa_debug_mode = 'Y' THEN
3750: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3751: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
3752: 'MAINTAIN_DATA',
3753: --P_CALLED_MODE => p_called_mode,
3754: P_MODULE_NAME => l_module_name);

Line 3766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

3762: X_RETURN_STATUS => x_return_status,
3763: X_MSG_COUNT => x_msg_count,
3764: X_MSG_DATA => x_msg_data );
3765: IF p_pa_debug_mode = 'Y' THEN
3766: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3767: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
3768: 'MAINTAIN_DATA: '||x_return_status,
3769: --P_CALLED_MODE => p_called_mode,
3770: P_MODULE_NAME => l_module_name);

Line 5081: pa_fp_gen_amount_utils.fp_debug

5077: l_source_context := 'BUDGET_LINE';
5078:
5079: --Calling the calculate API
5080: IF P_PA_DEBUG_MODE = 'Y' THEN
5081: pa_fp_gen_amount_utils.fp_debug
5082: (p_msg => 'Before calling
5083: PA_FP_CALC_PLAN_PKG.calculate',
5084: p_module_name => l_module_name,
5085: p_log_level => 5);

Line 5116: pa_fp_gen_amount_utils.fp_debug

5112: x_msg_count => x_msg_count,
5113: x_msg_data => x_msg_data);
5114: --hr_utility.trace('aft calling calculate api: '||x_return_status);
5115: IF P_PA_DEBUG_MODE = 'Y' THEN
5116: pa_fp_gen_amount_utils.fp_debug
5117: (p_msg => 'Status after calling
5118: PA_FP_CALC_PLAN_PKG.calculate: '
5119: ||x_return_status,
5120: p_module_name => l_module_name,

Line 5435: pa_fp_gen_amount_utils.fp_debug

5431: l_b_cost_rate_override_tab(i),
5432: '', /* bug 7693017 */
5433: l_markup_percent_tab(i)); /* Added for Bug 5166047 */
5434: IF P_PA_DEBUG_MODE = 'Y' THEN
5435: pa_fp_gen_amount_utils.fp_debug
5436: ( p_msg => 'After inserting into target budget lines',
5437: p_module_name => l_module_name,
5438: p_log_level => 5 );
5439: END IF;

Line 5484: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

5480: AND bl.txn_currency_code = rbc.txn_currency_code (+);
5481:
5482: -- Call the maintenance api in ROLLUP mode
5483: IF p_pa_debug_mode = 'Y' THEN
5484: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5485: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
5486: 'MAINTAIN_DATA',
5487: --P_CALLED_MODE => p_called_mode,
5488: P_MODULE_NAME => l_module_name);

Line 5500: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

5496: X_RETURN_STATUS => x_return_status,
5497: X_MSG_COUNT => x_msg_count,
5498: X_MSG_DATA => x_msg_data );
5499: IF p_pa_debug_mode = 'Y' THEN
5500: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5501: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
5502: 'MAINTAIN_DATA: '||x_return_status,
5503: --P_CALLED_MODE => p_called_mode,
5504: P_MODULE_NAME => l_module_name);

Line 5536: pa_fp_gen_amount_utils.fp_debug

5532: ROLLBACK;
5533:
5534: x_return_status := FND_API.G_RET_STS_ERROR;
5535: IF P_PA_DEBUG_MODE = 'Y' THEN
5536: pa_fp_gen_amount_utils.fp_debug
5537: ( p_msg => 'Invalid Arguments Passed',
5538: p_module_name => l_module_name,
5539: p_log_level => 5);
5540: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5554: pa_fp_gen_amount_utils.fp_debug

5550: p_procedure_name => 'MAINTAIN_BUDGET_LINES',
5551: p_error_text => substr(sqlerrm,1,240) );
5552:
5553: IF P_PA_DEBUG_MODE = 'Y' THEN
5554: pa_fp_gen_amount_utils.fp_debug
5555: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5556: p_module_name => l_module_name,
5557: p_log_level => 5 );
5558: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5585: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5581: * x_calculate_api_code is modified.
5582: */
5583: PROCEDURE GET_CALC_API_FLAG_PARAMS
5584: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5585: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5586: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5587: P_CALLING_CONTEXT IN VARCHAR2,
5588: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,
5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 5586: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5582: */
5583: PROCEDURE GET_CALC_API_FLAG_PARAMS
5584: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5585: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5586: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5587: P_CALLING_CONTEXT IN VARCHAR2,
5588: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,
5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5590: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5797: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5793: ROLLBACK;
5794: x_return_status := FND_API.G_RET_STS_ERROR;
5795:
5796: IF p_pa_debug_mode = 'Y' THEN
5797: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5798: ( p_msg => 'Invalid Arguments Passed',
5799: p_module_name => l_module_name,
5800: p_log_level => 5 );
5801: PA_DEBUG.RESET_CURR_FUNCTION;

Line 5815: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

5811: p_procedure_name => 'GET_CALC_API_FLAG_PARAMS',
5812: p_error_text => substr(sqlerrm,1,240) );
5813:
5814: IF p_pa_debug_mode = 'Y' THEN
5815: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5816: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
5817: p_module_name => l_module_name,
5818: p_log_level => 5 );
5819: PA_DEBUG.RESET_CURR_FUNCTION;