DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_GEN_FCST_AMT_PUB1

Line 895: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl

891: END IF;
892:
893: --Start Bug 5726785
894:
895: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl
896: (p_project_id => p_project_id
897: ,p_budget_version_id => p_budget_version_id
898: ,x_call_maintain_data_api => l_call_maintain_data_api
899: ,x_return_status => x_return_status

Line 922: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

918:
919: IF p_pa_debug_mode = 'Y' THEN
920: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
921: P_CALLED_MODE => P_CALLED_MODE,
922: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
923: 'MAINTAIN_BUDGET_VERSION',
924: P_MODULE_NAME => l_module_name);
925: END IF;
926: --dbms_output.put_line('++Before pub1.maintain_bv++');

Line 927: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION

923: 'MAINTAIN_BUDGET_VERSION',
924: P_MODULE_NAME => l_module_name);
925: END IF;
926: --dbms_output.put_line('++Before pub1.maintain_bv++');
927: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION
928: (P_PROJECT_ID => P_PROJECT_ID,
929: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
930: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
931: P_CALL_MAINTAIN_DATA_API => L_CALL_MAINTAIN_DATA_API,

Line 940: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

936: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
937: IF p_pa_debug_mode = 'Y' THEN
938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
939: P_CALLED_MODE => P_CALLED_MODE,
940: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
941: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
942: P_MODULE_NAME => l_module_name);
943: END IF;
944: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 1853: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

1849: /* When the task id is passed as NULL, the wrapper API generates
1850: the ETC numbers for all the target version planning resources
1851: based on the average value of the actual txn data. */
1852:
1853: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
1854: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1855: P_TASK_ID => NULL,
1856: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
1857: P_FP_COLS_REC => P_FP_COLS_REC,

Line 1999: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

1995:
1996: IF P_PA_DEBUG_MODE = 'Y' THEN
1997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1998: P_CALLED_MODE => P_CALLED_MODE,
1999: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2000: 'CALL_SUMM_POP_TMPS',
2001: P_MODULE_NAME => l_module_name);
2002: END IF;
2003:

Line 2010: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

2006: hr_utility.trace('1.l_resource_list_id: '||l_resource_list_id);
2007: hr_utility.trace('1.l_struct_ver_id: '||l_struct_ver_id);
2008: hr_utility.trace('1.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
2009:
2010: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
2011: P_PROJECT_ID => P_PROJECT_ID,
2012: P_CALENDAR_TYPE => l_calendar_type,
2013: P_RECORD_TYPE => l_record_type,
2014: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 2025: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

2021: -- hr_utility.trace('1.Status after calling call_summ_pop_tmps api: '||x_return_status);
2022: IF P_PA_DEBUG_MODE = 'Y' THEN
2023: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2024: P_CALLED_MODE => P_CALLED_MODE,
2025: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2026: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2027: P_MODULE_NAME => l_module_name);
2028: END IF;
2029: --dbms_output.put_line('After calling pji api: '||x_return_status);

Line 2057: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

2053:
2054: IF P_PA_DEBUG_MODE = 'Y' THEN
2055: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2056: P_CALLED_MODE => P_CALLED_MODE,
2057: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2058: 'CALL_SUMM_POP_TMPS',
2059: P_MODULE_NAME => l_module_name);
2060: END IF;
2061:

Line 2068: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

2064: hr_utility.trace('2.l_resource_list_id: '||l_resource_list_id);
2065: hr_utility.trace('2.l_struct_ver_id: '||l_struct_ver_id);
2066: hr_utility.trace('2.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
2067:
2068: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
2069: P_PROJECT_ID => P_PROJECT_ID,
2070: P_CALENDAR_TYPE => l_calendar_type,
2071: P_RECORD_TYPE => l_record_type,
2072: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 2083: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

2079: -- hr_utility.trace('2.Status after calling call_summ_pop_tmps api: '||x_return_status);
2080: IF P_PA_DEBUG_MODE = 'Y' THEN
2081: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2082: P_CALLED_MODE => P_CALLED_MODE,
2083: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2084: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2085: P_MODULE_NAME => l_module_name);
2086: END IF;
2087: --dbms_output.put_line('After calling pji api: '||x_return_status);

Line 2111: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||

2107: END IF;*/
2108: IF P_PA_DEBUG_MODE = 'Y' THEN
2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2110: P_CALLED_MODE => P_CALLED_MODE,
2111: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
2112: 'CALL_SUMM_POP_TMPS',
2113: P_MODULE_NAME => l_module_name);
2114: END IF;
2115: /* hr_utility.trace('3.l_calendar_type: '||l_calendar_type);

Line 2120: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

2116: hr_utility.trace('3.l_record_type: '||l_record_type);
2117: hr_utility.trace('3.l_resource_list_id: '||l_resource_list_id);
2118: hr_utility.trace('3.l_struct_ver_id: '||l_struct_ver_id);
2119: hr_utility.trace('3.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
2120: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
2121: P_PROJECT_ID => P_PROJECT_ID,
2122: P_CALENDAR_TYPE => l_calendar_type,
2123: P_RECORD_TYPE => l_record_type,
2124: P_RESOURCE_LIST_ID => l_resource_list_id,

Line 2135: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||

2131: -- hr_utility.trace('3.Status after calling call_summ_pop_tmps api: '||x_return_status);
2132: IF P_PA_DEBUG_MODE = 'Y' THEN
2133: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2134: P_CALLED_MODE => P_CALLED_MODE,
2135: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
2136: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2137: P_MODULE_NAME => l_module_name);
2138: END IF;
2139: --dbms_output.put_line(' --After calling pji get_summarized api: '||x_return_status);

Line 2357: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||

2353: END IF;
2354: IF P_PA_DEBUG_MODE = 'Y' THEN
2355: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2356: P_CALLED_MODE => P_CALLED_MODE,
2357: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||
2358: 'GET_ETC_WORK_QTY_AMTS',
2359: P_MODULE_NAME => l_module_name);
2360: END IF;
2361: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and

Line 2363: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(

2359: P_MODULE_NAME => l_module_name);
2360: END IF;
2361: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and
2362: P_RESOURCE_LIST_MEMBER_ID are not needed*/
2363: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(
2364: P_PROJECT_ID => P_PROJECT_ID,
2365: P_PROJ_CURRENCY_CODE => P_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
2366: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2367: P_TASK_ID => l_curr_task_id,

Line 2378: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||

2374: X_MSG_DATA => x_msg_data);
2375: IF p_pa_debug_mode = 'Y' THEN
2376: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2377: P_CALLED_MODE => P_CALLED_MODE,
2378: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2379: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,
2380: P_MODULE_NAME => l_module_name);
2381: END IF;
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2390: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',

2386: ELSIF l_curr_etc_source = 'NONE' THEN
2387: IF P_PA_DEBUG_MODE = 'Y' THEN
2388: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2389: P_CALLED_MODE => P_CALLED_MODE,
2390: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2391: P_MODULE_NAME => l_module_name);
2392: END IF;
2393: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2394: P_PROJECT_ID => P_PROJECT_ID,

Line 2393: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(

2389: P_CALLED_MODE => P_CALLED_MODE,
2390: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2391: P_MODULE_NAME => l_module_name);
2392: END IF;
2393: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2394: P_PROJECT_ID => P_PROJECT_ID,
2395: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2396: P_RESOURCE_LIST_ID => l_fp_cols_rec_target.X_RESOURCE_LIST_ID,
2397: P_TASK_ID => l_curr_task_id,

Line 2524: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

2520: hr_utility.trace('P_ACTUALS_FROM_PERIOD: '||P_ACTUALS_FROM_PERIOD);
2521: hr_utility.trace('P_ACTUALS_TO_PERIOD: '||P_ACTUALS_TO_PERIOD);
2522: hr_utility.trace('P_ETC_FROM_PERIOD: '||P_ETC_FROM_PERIOD);
2523: hr_utility.trace('P_ETC_TO_PERIOD: '||P_ETC_TO_PERIOD); */
2524: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
2525: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2526: P_TASK_ID => l_avg_actuals_task_id_tab(i),
2527: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
2528: P_FP_COLS_REC => P_FP_COLS_REC,

Line 4034: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',

4030: IF P_PA_DEBUG_MODE = 'Y' THEN
4031: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4032: P_CALLED_MODE => P_CALLED_MODE,
4033: P_MSG =>
4034: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
4035: P_MODULE_NAME => l_module_name);
4036: END IF;
4037: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
4038: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),

Line 4037: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE

4033: P_MSG =>
4034: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
4035: P_MODULE_NAME => l_module_name);
4036: END IF;
4037: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
4038: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),
4039: P_TARGET_RES_ASG_ID => l_cal_ra_id_tab(i),
4040: P_TXN_CURRENCY_CODE => l_cal_txn_currency_code_tab(i),
4041: X_RETURN_STATUS => x_return_status,

Line 4051: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,

4047: IF P_PA_DEBUG_MODE = 'Y' THEN
4048: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4049: P_CALLED_MODE => P_CALLED_MODE,
4050: P_MSG =>
4051: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,
4052: P_MODULE_NAME => l_module_name);
4053: END IF;
4054:
4055: /* Populate the period rates table for the Client Extension API */

Line 4164: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate

4160: END IF;
4161: /*For client_extn, many attributes are passed as NULL is because
4162: this API is still under developmen and some parameters are not
4163: available.Null values will be replaced later*/
4164: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate
4165: pa_fp_gen_rate_tmp, which is used to populate input parameter
4166: P_PERIOD_RATES_TBL */
4167:
4168: -- hr_utility.trace('==before calling client extn api ');