DBA Data[Home] [Help]

APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

5:
6: PROCEDURE GEN_COMMITMENT_AMOUNTS
7: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
8: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
9: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
10: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
11: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 287: l_fp_cols_rec_src_finplan PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

283: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;
284:
285: -- Variables added for Bug Fix 4582616
286: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
287: l_fp_cols_rec_src_finplan PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
288: l_fp_planning_options_flag VARCHAR2(1);
289:
290: -- pl/sql tables to store parameters for POPULATE_GEN_RATE API
291: l_sr_src_ra_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 441: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

437: l_TXN_RBS_ELEMENT_ID_tab(bb) := null;
438: END LOOP;
439: --dbms_output.put_line('b4 calling MAP_RLMI_RBS api');
440: IF P_PA_DEBUG_MODE = 'Y' THEN
441: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
442: P_MSG => 'Before calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS',
443: P_MODULE_NAME => l_module_name);
444: END IF;
445: pa_resource_mapping.g_called_process :='COMMITMENTS'; --Bug 9753875

Line 497: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

493: X_RETURN_STATUS => x_return_status,
494: X_MSG_COUNT => x_msg_count,
495: X_MSG_DATA => x_msg_data );
496: IF P_PA_DEBUG_MODE = 'Y' THEN
497: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
498: P_MSG => 'After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||
499: x_return_status,
500: P_MODULE_NAME => l_module_name);
501: END IF;

Line 522: pa_fp_gen_amount_utils.fp_debug

518: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
519: END IF;
520:
521: IF p_pa_debug_mode = 'Y' THEN
522: pa_fp_gen_amount_utils.fp_debug
523: (p_msg => 'Before calling pa_fp_gen_budget_amt_pub.create_res_asg',
524: p_module_name => l_module_name,
525: p_log_level => 5);
526: END IF;

Line 545: pa_fp_gen_amount_utils.fp_debug

541: END IF;
542:
543: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG');
544: IF p_pa_debug_mode = 'Y' THEN
545: pa_fp_gen_amount_utils.fp_debug
546: (p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.create_res_asg'
547: ||x_return_status,
548: p_module_name => l_module_name,
549: p_log_level => 5);

Line 553: pa_fp_gen_amount_utils.fp_debug

549: p_log_level => 5);
550: END IF;
551:
552: IF p_pa_debug_mode = 'Y' THEN
553: pa_fp_gen_amount_utils.fp_debug
554: (p_msg => 'Before calling pa_fp_gen_budget_amt_pub.update_res_asg',
555: p_module_name => l_module_name,
556: p_log_level => 5);
557: END IF;

Line 574: pa_fp_gen_amount_utils.fp_debug

570: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
571: END IF;
572: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG');
573: IF p_pa_debug_mode = 'Y' THEN
574: pa_fp_gen_amount_utils.fp_debug
575: (p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.update_res_asg'
576: ||x_return_status,
577: p_module_name => l_module_name,
578: p_log_level => 5);

Line 591: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(P_FP_COLS_REC.X_BUDGET_VERSION_ID);

587: IF ( P_FP_COLS_REC.X_PLAN_CLASS_CODE = 'FORECAST' )
588: THEN
589: -- hr_utility.trace('---inside forecast plan class---');
590: l_etc_start_date :=
591: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(P_FP_COLS_REC.X_BUDGET_VERSION_ID);
592: -- hr_utility.trace('---etc start dt --'||to_char(l_etc_start_date,'dd-mon-rrrr'));
593: END IF;
594:
595: --dbms_output.put_line('opening cursor SUM_COMM_CRSR');

Line 634: pa_fp_gen_amount_utils.fp_debug

630: -- UPDATE_RES_ASG API has been called. Thus, we have moved the call
631: -- to SYNC_UP_PLANNING_DATES from the end of the API to here.
632:
633: IF p_pa_debug_mode = 'Y' THEN
634: pa_fp_gen_amount_utils.fp_debug
635: (p_msg => 'Before calling
636: pa_fp_maintain_actual_pub.sync_up_planning_dates',
637: p_module_name => l_module_name,
638: p_log_level => 5);

Line 647: pa_fp_gen_amount_utils.fp_debug

643: X_RETURN_STATUS => x_return_Status,
644: X_MSG_COUNT => x_msg_count,
645: X_MSG_DATA => x_msg_data );
646: IF p_pa_debug_mode = 'Y' THEN
647: pa_fp_gen_amount_utils.fp_debug
648: (p_msg => 'Status after calling
649: pa_fp_maintain_actual_pub.sync_up_planning_dates'
650: ||x_return_status,
651: p_module_name => l_module_name,

Line 1643: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1639: l_gen_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
1640:
1641: -- Get Source Financial Plan Details
1642: IF P_PA_DEBUG_MODE = 'Y' THEN
1643: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1644: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1645: 'GET_PLAN_VERSION_DTL',
1646: P_MODULE_NAME => l_module_name,
1647: P_LOG_LEVEL => 5);

Line 1644: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||

1640:
1641: -- Get Source Financial Plan Details
1642: IF P_PA_DEBUG_MODE = 'Y' THEN
1643: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1644: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1645: 'GET_PLAN_VERSION_DTL',
1646: P_MODULE_NAME => l_module_name,
1647: P_LOG_LEVEL => 5);
1648: END IF;

Line 1649: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1645: 'GET_PLAN_VERSION_DTL',
1646: P_MODULE_NAME => l_module_name,
1647: P_LOG_LEVEL => 5);
1648: END IF;
1649: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1650: P_PROJECT_ID => P_PROJECT_ID,
1651: P_BUDGET_VERSION_ID => l_fp_src_plan_ver_id,
1652: X_FP_COLS_REC => l_fp_cols_rec_src_finplan,
1653: X_RETURN_STATUS => x_return_status,

Line 1657: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1653: X_RETURN_STATUS => x_return_status,
1654: X_MSG_COUNT => x_msg_count,
1655: X_MSG_DATA => x_msg_data);
1656: IF P_PA_DEBUG_MODE = 'Y' THEN
1657: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1658: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1659: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1660: P_MODULE_NAME => l_module_name,
1661: P_LOG_LEVEL => 5);

Line 1658: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||

1654: X_MSG_COUNT => x_msg_count,
1655: X_MSG_DATA => x_msg_data);
1656: IF P_PA_DEBUG_MODE = 'Y' THEN
1657: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1658: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1659: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1660: P_MODULE_NAME => l_module_name,
1661: P_LOG_LEVEL => 5);
1662: END IF;

Line 1676: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1672: IF l_fp_cols_rec_src_finplan.x_version_type = 'ALL' THEN
1673:
1674: -- Get Planning Options Flag for Source Financial Plan
1675: IF P_PA_DEBUG_MODE = 'Y' THEN
1676: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1677: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
1678: 'COMPARE_ETC_SRC_TARGET_FP_OPT',
1679: P_MODULE_NAME => l_module_name,
1680: P_LOG_LEVEL => 5);

Line 1692: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1688: X_RETURN_STATUS => X_RETURN_STATUS,
1689: X_MSG_COUNT => X_MSG_COUNT,
1690: X_MSG_DATA => X_MSG_DATA);
1691: IF P_PA_DEBUG_MODE = 'Y' THEN
1692: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1693: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
1694: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||
1695: l_fp_planning_options_flag,
1696: P_MODULE_NAME => l_module_name,

Line 1788: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1784:
1785: FOR i IN 1..l_sr_src_ra_id_tab.count LOOP
1786:
1787: IF P_PA_DEBUG_MODE = 'Y' THEN
1788: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1789: P_MSG =>
1790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
1791: P_MODULE_NAME => l_module_name,
1792: P_LOG_LEVEL => 5);

Line 1802: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1798: X_RETURN_STATUS => x_return_status,
1799: X_MSG_COUNT => x_msg_count,
1800: X_MSG_DATA => x_msg_data);
1801: IF P_PA_DEBUG_MODE = 'Y' THEN
1802: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1803: P_MSG =>
1804: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,
1805: P_MODULE_NAME => l_module_name,
1806: P_LOG_LEVEL => 5);

Line 1909: pa_fp_gen_amount_utils.fp_debug

1905:
1906: --hr_utility.trace('bef calling calculate api:'||x_return_status);
1907: --Calling the calculate API
1908: IF P_PA_DEBUG_MODE = 'Y' THEN
1909: pa_fp_gen_amount_utils.fp_debug
1910: (p_msg => 'Before calling
1911: PA_FP_CALC_PLAN_PKG.calculate',
1912: p_module_name => l_module_name,
1913: p_log_level => 5);

Line 1944: pa_fp_gen_amount_utils.fp_debug

1940: x_msg_count => x_msg_count,
1941: x_msg_data => x_msg_data);
1942: --hr_utility.trace('aft calling calculate api: '||x_return_status);
1943: IF P_PA_DEBUG_MODE = 'Y' THEN
1944: pa_fp_gen_amount_utils.fp_debug
1945: (p_msg => 'Status after calling
1946: PA_FP_CALC_PLAN_PKG.calculate: '
1947: ||x_return_status,
1948: p_module_name => l_module_name,