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_GEN_FCST_AMT_PUB dependencies on PA_FP_GEN_FCST_AMT_PUB

Line 1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB as

1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB as
2: /* $Header: PAFPFGPB.pls 120.25.12020000.3 2013/06/07 10:43:38 bpottipa ship $ */
3:
4:
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';

55: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56: X_MSG_COUNT OUT NOCOPY NUMBER,
57: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
58:
59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';
60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 379: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||

375: ELSE
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
378: P_CALLED_MODE => P_CALLED_MODE,
379: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
380: 'gen_fcst_task_level_amt',
381: P_MODULE_NAME => l_module_name);
382: END IF;
383: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT

Line 383: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT

379: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
380: 'gen_fcst_task_level_amt',
381: P_MODULE_NAME => l_module_name);
382: END IF;
383: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT
384: (P_PROJECT_ID => P_PROJECT_ID,
385: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
386: P_FP_COLS_REC => P_FP_COLS_REC,
387: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,

Line 401: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||

397:
398: IF p_pa_debug_mode = 'Y' THEN
399: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
400: P_CALLED_MODE => P_CALLED_MODE,
401: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
402: 'gen_fcst_task_level_amt: '||x_return_status,
403: P_MODULE_NAME => l_module_name);
404: END IF;
405: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 841: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||

837: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
838: IF p_pa_debug_mode = 'Y' THEN
839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
840: P_CALLED_MODE => P_CALLED_MODE,
841: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
842: 'update_total_plan_amts',
843: P_MODULE_NAME => l_module_name);
844: END IF;
845: PA_FP_GEN_FCST_AMT_PVT.UPDATE_TOTAL_PLAN_AMTS

Line 855: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||

851: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
852: IF p_pa_debug_mode = 'Y' THEN
853: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
854: P_CALLED_MODE => P_CALLED_MODE,
855: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
856: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,
857: P_MODULE_NAME => l_module_name);
858: END IF;
859: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 871: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.' ||

867: -- with any ETC revenue amount calculation errors.
868: -- See bug 5203622 for more details.
869: IF p_pa_debug_mode = 'Y' THEN
870: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
871: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.' ||
872: 'UPD_REV_CALCULATION_ERR',
873: P_CALLED_MODE => p_called_mode,
874: P_MODULE_NAME => l_module_name);
875: END IF;

Line 876: PA_FP_GEN_FCST_AMT_PUB.UPD_REV_CALCULATION_ERR

872: 'UPD_REV_CALCULATION_ERR',
873: P_CALLED_MODE => p_called_mode,
874: P_MODULE_NAME => l_module_name);
875: END IF;
876: PA_FP_GEN_FCST_AMT_PUB.UPD_REV_CALCULATION_ERR
877: (P_PROJECT_ID => p_project_id,
878: P_BUDGET_VERSION_ID => p_budget_version_id,
879: P_FP_COLS_REC => p_fp_cols_rec,
880: P_ETC_START_DATE => p_actuals_thru_date + 1,

Line 887: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.' ||

883: X_MSG_COUNT => X_MSG_COUNT,
884: X_MSG_DATA => X_MSG_DATA);
885: IF p_pa_debug_mode = 'Y' THEN
886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
887: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.' ||
888: 'UPD_REV_CALCULATION_ERR: '||x_return_status,
889: P_CALLED_MODE => p_called_mode,
890: P_MODULE_NAME => l_module_name);
891: END IF;

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 906: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||

902:
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_gen_fcst_amt_pub.'||
907: 'call_clnt_extn_and_update_bl '||x_return_status,
908: P_MODULE_NAME => l_module_name);
909: END IF;
910: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

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 1029: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_msg_data := SUBSTR(SQLERRM,1,240);
1028: FND_MSG_PUB.add_exc_msg
1029: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
1030: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');
1031: IF P_PA_DEBUG_MODE = 'Y' THEN
1032: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1033: P_CALLED_MODE => P_CALLED_MODE,

Line 1057: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.gen_fcst_task_level_amt';

1053: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1054: X_MSG_COUNT OUT NOCOPY NUMBER,
1055: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1056:
1057: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.gen_fcst_task_level_amt';
1058:
1059: l_latest_published_fwbs_id NUMBER;
1060: l_proj_struc_sharing_code VARCHAR2(30);
1061:

Line 1112: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;

1108: l_curr_src_ra_id NUMBER;
1109: l_curr_tgt_ra_id NUMBER;
1110: l_curr_rlm_id NUMBER;
1111: l_curr_cbs_id NUMBER;--bug#16791711
1112: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
1113: l_work_qty_cnt NUMBER:= 0;
1114:
1115: /* Indices for ETC method PL/SQL tables */
1116: l_rb_index BINARY_INTEGER;

Line 1835: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||

1831: IF l_fcst_gen_src_code = 'AVERAGE_ACTUALS' THEN
1832: IF p_pa_debug_mode = 'Y' THEN
1833: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1834: P_CALLED_MODE => P_CALLED_MODE,
1835: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
1836: 'GEN_AVERAGE_OF_ACTUALS_WRP for Revenue only version',
1837: P_MODULE_NAME => l_module_name);
1838: END IF;
1839:

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 1870: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||

1866: -- ||x_return_status);
1867: IF p_pa_debug_mode = 'Y' THEN
1868: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1869: P_CALLED_MODE => P_CALLED_MODE,
1870: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
1871: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
1872: P_MODULE_NAME => l_module_name);
1873: END IF;
1874:

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 2272: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||

2268: *transaction amts for a given task**/
2269: IF P_PA_DEBUG_MODE = 'Y' THEN
2270: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2271: P_CALLED_MODE => P_CALLED_MODE,
2272: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
2273: 'get_total_plan_txn_amts',
2274: P_MODULE_NAME => l_module_name);
2275: END IF;
2276: --dbms_output.put_line('--Before GET_TOTAL--');

Line 2319: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||

2315: END;
2316: IF p_pa_debug_mode = 'Y' THEN
2317: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2318: P_CALLED_MODE => P_CALLED_MODE,
2319: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2320: 'get_total_plan_txn_amts: '||x_return_status,
2321: P_MODULE_NAME => l_module_name);
2322: END IF;
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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 2512: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||

2508: FOR i IN 1..l_avg_actuals_task_id_tab.count LOOP
2509: IF p_pa_debug_mode = 'Y' THEN
2510: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2511: P_CALLED_MODE => P_CALLED_MODE,
2512: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
2513: 'GEN_AVERAGE_OF_ACTUALS_WRP',
2514: P_MODULE_NAME => l_module_name);
2515: END IF;
2516: /* hr_utility.trace('Values passed to call GEN_AVERAGE_OF_ACTUALS_WRP api');

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 2541: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||

2537: -- ||x_return_status);
2538: IF p_pa_debug_mode = 'Y' THEN
2539: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2540: P_CALLED_MODE => P_CALLED_MODE,
2541: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2542: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2543: P_MODULE_NAME => l_module_name);
2544: END IF;
2545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2975: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||

2971: * is present in this API itself. */
2972: IF P_PA_DEBUG_MODE = 'Y' THEN
2973: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2974: P_CALLED_MODE => P_CALLED_MODE,
2975: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2976: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',
2977: P_MODULE_NAME => l_module_name);
2978: END IF;
2979: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(

Line 2979: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(

2975: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2976: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',
2977: P_MODULE_NAME => l_module_name);
2978: END IF;
2979: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(
2980: P_SRC_RES_ASG_ID_TAB => l_rb_src_ra_id_tab,
2981: P_TGT_RES_ASG_ID_TAB => l_rb_tgt_ra_id_tab,
2982: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
2983: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

Line 2998: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||

2994: X_MSG_DATA => x_msg_data);
2995: IF p_pa_debug_mode = 'Y' THEN
2996: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2997: P_CALLED_MODE => P_CALLED_MODE,
2998: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2999: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,
3000: P_MODULE_NAME => l_module_name);
3001: END IF;
3002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3015: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||

3011: * is present in this API itself. */
3012: IF P_PA_DEBUG_MODE = 'Y' THEN
3013: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3014: P_CALLED_MODE => P_CALLED_MODE,
3015: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
3016: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',
3017: P_MODULE_NAME => l_module_name);
3018: END IF;
3019: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(

Line 3019: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(

3015: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
3016: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',
3017: P_MODULE_NAME => l_module_name);
3018: END IF;
3019: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(
3020: P_SRC_RES_ASG_ID_TAB => l_bc_src_ra_id_tab,
3021: P_TGT_RES_ASG_ID_TAB => l_bc_tgt_ra_id_tab,
3022: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
3023: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

Line 3037: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||

3033: X_MSG_DATA => x_msg_data);
3034: IF p_pa_debug_mode = 'Y' THEN
3035: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3036: P_CALLED_MODE => P_CALLED_MODE,
3037: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
3038: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,
3039: P_MODULE_NAME => l_module_name);
3040: END IF;
3041: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3054: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||

3050: * is present in this API itself. */
3051: IF P_PA_DEBUG_MODE = 'Y' THEN
3052: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3053: P_CALLED_MODE => P_CALLED_MODE,
3054: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
3055: 'GET_ETC_EARNED_VALUE_AMTS_BLK',
3056: P_MODULE_NAME => l_module_name);
3057: END IF;
3058: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(

Line 3058: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(

3054: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
3055: 'GET_ETC_EARNED_VALUE_AMTS_BLK',
3056: P_MODULE_NAME => l_module_name);
3057: END IF;
3058: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(
3059: P_SRC_RES_ASG_ID_TAB => l_ev_src_ra_id_tab,
3060: P_TGT_RES_ASG_ID_TAB => l_ev_tgt_ra_id_tab,
3061: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
3062: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

Line 3077: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||

3073: X_MSG_DATA => x_msg_data);
3074: IF p_pa_debug_mode = 'Y' THEN
3075: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3076: P_CALLED_MODE => P_CALLED_MODE,
3077: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
3078: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,
3079: P_MODULE_NAME => l_module_name);
3080: END IF;
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3096: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB3.'||

3092: -- hr_utility.trace('after for loop :');
3093: IF P_PA_DEBUG_MODE = 'Y' THEN
3094: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3095: P_CALLED_MODE => P_CALLED_MODE,
3096: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB3.'||
3097: 'GET_ETC_COMMITMENT_AMTS',
3098: P_MODULE_NAME => l_module_name);
3099: END IF;
3100: -- hr_utility.trace('before pub3 cmt amts:');

Line 3101: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_COMMITMENT_AMTS

3097: 'GET_ETC_COMMITMENT_AMTS',
3098: P_MODULE_NAME => l_module_name);
3099: END IF;
3100: -- hr_utility.trace('before pub3 cmt amts:');
3101: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_COMMITMENT_AMTS
3102: (P_FP_COLS_TGT_REC => p_fp_cols_rec,
3103: P_WP_PLANNING_OPTIONS_FLAG => l_wp_planning_options_flag, /* Bug 4369741 */
3104: P_FP_PLANNING_OPTIONS_FLAG => l_fp_planning_options_flag, /* Bug 4369741 */
3105: X_RETURN_STATUS => x_return_status,

Line 3114: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||

3110:
3111: IF p_pa_debug_mode = 'Y' THEN
3112: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3113: P_CALLED_MODE => P_CALLED_MODE,
3114: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
3115: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,
3116: P_MODULE_NAME => l_module_name);
3117: END IF;
3118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3127: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||

3123: ELSE
3124: IF P_PA_DEBUG_MODE = 'Y' THEN
3125: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3126: P_CALLED_MODE => P_CALLED_MODE,
3127: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
3128: 'GET_ETC_FROM_SRC_BDGT',
3129: P_MODULE_NAME => l_module_name);
3130: END IF;
3131: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_FROM_SRC_BDGT(

Line 3131: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_FROM_SRC_BDGT(

3127: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
3128: 'GET_ETC_FROM_SRC_BDGT',
3129: P_MODULE_NAME => l_module_name);
3130: END IF;
3131: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_FROM_SRC_BDGT(
3132: P_FP_COLS_SRC_FP_REC => l_fp_cols_rec_fp,
3133: P_FP_COLS_SRC_WP_REC => l_fp_cols_rec_wp,
3134: P_FP_COLS_TGT_REC => l_fp_cols_rec_target,
3135: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,

Line 3142: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||

3138: X_MSG_DATA => x_msg_data);
3139: IF p_pa_debug_mode = 'Y' THEN
3140: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3141: P_CALLED_MODE => P_CALLED_MODE,
3142: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
3143: 'GET_ETC_FROM_SRC_BDGT: '||x_return_status,
3144: P_MODULE_NAME => l_module_name);
3145: END IF;
3146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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 ');

Line 4935: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

4931: WHEN OTHERS THEN
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4933: x_msg_data := SUBSTR(SQLERRM,1,240);
4934: FND_MSG_PUB.add_exc_msg
4935: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4936: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');
4937: IF P_PA_DEBUG_MODE = 'Y' THEN
4938: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4939: P_CALLED_MODE => P_CALLED_MODE,

Line 4955: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.maintain_res_asg';

4951: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4952: X_MSG_COUNT OUT NOCOPY NUMBER,
4953: X_MSG_DATA OUT NOCOPY VARCHAR2)
4954: IS
4955: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.maintain_res_asg';
4956:
4957: l_msg_count NUMBER;
4958: l_msg_data VARCHAR2(2000);
4959: l_data VARCHAR2(2000);

Line 5115: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

5111: WHEN OTHERS THEN
5112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5113: x_msg_data := SUBSTR(SQLERRM,1,240);
5114: FND_MSG_PUB.add_exc_msg
5115: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
5116: ,p_procedure_name => 'MAINTAIN_RES_ASG');
5117: IF P_PA_DEBUG_MODE = 'Y' THEN
5118: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5119: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 5153: l_package_name VARCHAR2(30) := 'PA_FP_GEN_FCST_AMT_PUB';

5149: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5150: X_MSG_COUNT OUT NOCOPY NUMBER,
5151: X_MSG_DATA OUT NOCOPY VARCHAR2 )
5152: IS
5153: l_package_name VARCHAR2(30) := 'PA_FP_GEN_FCST_AMT_PUB';
5154: l_procedure_name VARCHAR2(30) := 'UPD_REV_CALCULATION_ERR';
5155: l_module_name VARCHAR2(100);
5156:
5157: l_log_level NUMBER := 5;

Line 5288: END PA_FP_GEN_FCST_AMT_PUB;

5284:
5285: END UPD_REV_CALCULATION_ERR;
5286:
5287:
5288: END PA_FP_GEN_FCST_AMT_PUB;