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 286: l_fp_cols_rec_src_finplan PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

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

Line 439: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 493: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

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

Line 516: pa_fp_gen_amount_utils.fp_debug

512: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
513: END IF;
514:
515: IF p_pa_debug_mode = 'Y' THEN
516: pa_fp_gen_amount_utils.fp_debug
517: (p_msg => 'Before calling pa_fp_gen_budget_amt_pub.create_res_asg',
518: p_module_name => l_module_name,
519: p_log_level => 5);
520: END IF;

Line 537: pa_fp_gen_amount_utils.fp_debug

533: END IF;
534:
535: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG');
536: IF p_pa_debug_mode = 'Y' THEN
537: pa_fp_gen_amount_utils.fp_debug
538: (p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.create_res_asg'
539: ||x_return_status,
540: p_module_name => l_module_name,
541: p_log_level => 5);

Line 545: pa_fp_gen_amount_utils.fp_debug

541: p_log_level => 5);
542: END IF;
543:
544: IF p_pa_debug_mode = 'Y' THEN
545: pa_fp_gen_amount_utils.fp_debug
546: (p_msg => 'Before calling pa_fp_gen_budget_amt_pub.update_res_asg',
547: p_module_name => l_module_name,
548: p_log_level => 5);
549: END IF;

Line 566: pa_fp_gen_amount_utils.fp_debug

562: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
563: END IF;
564: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG');
565: IF p_pa_debug_mode = 'Y' THEN
566: pa_fp_gen_amount_utils.fp_debug
567: (p_msg => 'Status after calling pa_fp_gen_budget_amt_pub.update_res_asg'
568: ||x_return_status,
569: p_module_name => l_module_name,
570: p_log_level => 5);

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

579: IF ( P_FP_COLS_REC.X_PLAN_CLASS_CODE = 'FORECAST' )
580: THEN
581: -- hr_utility.trace('---inside forecast plan class---');
582: l_etc_start_date :=
583: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(P_FP_COLS_REC.X_BUDGET_VERSION_ID);
584: -- hr_utility.trace('---etc start dt --'||to_char(l_etc_start_date,'dd-mon-rrrr'));
585: END IF;
586:
587: --dbms_output.put_line('opening cursor SUM_COMM_CRSR');

Line 626: pa_fp_gen_amount_utils.fp_debug

622: -- UPDATE_RES_ASG API has been called. Thus, we have moved the call
623: -- to SYNC_UP_PLANNING_DATES from the end of the API to here.
624:
625: IF p_pa_debug_mode = 'Y' THEN
626: pa_fp_gen_amount_utils.fp_debug
627: (p_msg => 'Before calling
628: pa_fp_maintain_actual_pub.sync_up_planning_dates',
629: p_module_name => l_module_name,
630: p_log_level => 5);

Line 639: pa_fp_gen_amount_utils.fp_debug

635: X_RETURN_STATUS => x_return_Status,
636: X_MSG_COUNT => x_msg_count,
637: X_MSG_DATA => x_msg_data );
638: IF p_pa_debug_mode = 'Y' THEN
639: pa_fp_gen_amount_utils.fp_debug
640: (p_msg => 'Status after calling
641: pa_fp_maintain_actual_pub.sync_up_planning_dates'
642: ||x_return_status,
643: p_module_name => l_module_name,

Line 1635: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1631: l_gen_src_code IN ('FINANCIAL_PLAN','TASK_LEVEL_SEL') THEN
1632:
1633: -- Get Source Financial Plan Details
1634: IF P_PA_DEBUG_MODE = 'Y' THEN
1635: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1636: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1637: 'GET_PLAN_VERSION_DTL',
1638: P_MODULE_NAME => l_module_name,
1639: P_LOG_LEVEL => 5);

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

1632:
1633: -- Get Source Financial Plan Details
1634: IF P_PA_DEBUG_MODE = 'Y' THEN
1635: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1636: P_MSG => 'Before calling PA_FP_GEN_AMOUNT_UTILS.'||
1637: 'GET_PLAN_VERSION_DTL',
1638: P_MODULE_NAME => l_module_name,
1639: P_LOG_LEVEL => 5);
1640: END IF;

Line 1641: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(

1637: 'GET_PLAN_VERSION_DTL',
1638: P_MODULE_NAME => l_module_name,
1639: P_LOG_LEVEL => 5);
1640: END IF;
1641: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS(
1642: P_PROJECT_ID => P_PROJECT_ID,
1643: P_BUDGET_VERSION_ID => l_fp_src_plan_ver_id,
1644: X_FP_COLS_REC => l_fp_cols_rec_src_finplan,
1645: X_RETURN_STATUS => x_return_status,

Line 1649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1645: X_RETURN_STATUS => x_return_status,
1646: X_MSG_COUNT => x_msg_count,
1647: X_MSG_DATA => x_msg_data);
1648: IF P_PA_DEBUG_MODE = 'Y' THEN
1649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1650: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1651: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1652: P_MODULE_NAME => l_module_name,
1653: P_LOG_LEVEL => 5);

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

1646: X_MSG_COUNT => x_msg_count,
1647: X_MSG_DATA => x_msg_data);
1648: IF P_PA_DEBUG_MODE = 'Y' THEN
1649: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1650: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1651: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1652: P_MODULE_NAME => l_module_name,
1653: P_LOG_LEVEL => 5);
1654: END IF;

Line 1668: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1664: IF l_fp_cols_rec_src_finplan.x_version_type = 'ALL' THEN
1665:
1666: -- Get Planning Options Flag for Source Financial Plan
1667: IF P_PA_DEBUG_MODE = 'Y' THEN
1668: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1669: P_MSG => 'Before calling PA_FP_FCST_GEN_AMT_UTILS.'||
1670: 'COMPARE_ETC_SRC_TARGET_FP_OPT',
1671: P_MODULE_NAME => l_module_name,
1672: P_LOG_LEVEL => 5);

Line 1684: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1680: X_RETURN_STATUS => X_RETURN_STATUS,
1681: X_MSG_COUNT => X_MSG_COUNT,
1682: X_MSG_DATA => X_MSG_DATA);
1683: IF P_PA_DEBUG_MODE = 'Y' THEN
1684: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1685: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
1686: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||
1687: l_fp_planning_options_flag,
1688: P_MODULE_NAME => l_module_name,

Line 1780: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1776:
1777: FOR i IN 1..l_sr_src_ra_id_tab.count LOOP
1778:
1779: IF P_PA_DEBUG_MODE = 'Y' THEN
1780: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1781: P_MSG =>
1782: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
1783: P_MODULE_NAME => l_module_name,
1784: P_LOG_LEVEL => 5);

Line 1794: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

1790: X_RETURN_STATUS => x_return_status,
1791: X_MSG_COUNT => x_msg_count,
1792: X_MSG_DATA => x_msg_data);
1793: IF P_PA_DEBUG_MODE = 'Y' THEN
1794: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1795: P_MSG =>
1796: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,
1797: P_MODULE_NAME => l_module_name,
1798: P_LOG_LEVEL => 5);

Line 1901: pa_fp_gen_amount_utils.fp_debug

1897:
1898: --hr_utility.trace('bef calling calculate api:'||x_return_status);
1899: --Calling the calculate API
1900: IF P_PA_DEBUG_MODE = 'Y' THEN
1901: pa_fp_gen_amount_utils.fp_debug
1902: (p_msg => 'Before calling
1903: PA_FP_CALC_PLAN_PKG.calculate',
1904: p_module_name => l_module_name,
1905: p_log_level => 5);

Line 1936: pa_fp_gen_amount_utils.fp_debug

1932: x_msg_count => x_msg_count,
1933: x_msg_data => x_msg_data);
1934: --hr_utility.trace('aft calling calculate api: '||x_return_status);
1935: IF P_PA_DEBUG_MODE = 'Y' THEN
1936: pa_fp_gen_amount_utils.fp_debug
1937: (p_msg => 'Status after calling
1938: PA_FP_CALC_PLAN_PKG.calculate: '
1939: ||x_return_status,
1940: p_module_name => l_module_name,