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.16 2007/11/28 14:05:05 vgovvala 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 360: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||

356: ELSE
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
359: P_CALLED_MODE => P_CALLED_MODE,
360: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
361: 'gen_fcst_task_level_amt',
362: P_MODULE_NAME => l_module_name);
363: END IF;
364: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT

Line 364: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT

360: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
361: 'gen_fcst_task_level_amt',
362: P_MODULE_NAME => l_module_name);
363: END IF;
364: PA_FP_GEN_FCST_AMT_PUB.GEN_FCST_TASK_LEVEL_AMT
365: (P_PROJECT_ID => P_PROJECT_ID,
366: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
367: P_FP_COLS_REC => P_FP_COLS_REC,
368: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,

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

378:
379: IF p_pa_debug_mode = 'Y' THEN
380: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
381: P_CALLED_MODE => P_CALLED_MODE,
382: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
383: 'gen_fcst_task_level_amt: '||x_return_status,
384: P_MODULE_NAME => l_module_name);
385: END IF;
386: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

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

737: IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
738: IF p_pa_debug_mode = 'Y' THEN
739: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
740: P_CALLED_MODE => P_CALLED_MODE,
741: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
742: 'update_total_plan_amts',
743: P_MODULE_NAME => l_module_name);
744: END IF;
745: PA_FP_GEN_FCST_AMT_PVT.UPDATE_TOTAL_PLAN_AMTS

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

751: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
752: IF p_pa_debug_mode = 'Y' THEN
753: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
754: P_CALLED_MODE => P_CALLED_MODE,
755: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
756: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,
757: P_MODULE_NAME => l_module_name);
758: END IF;
759: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

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

767: -- with any ETC revenue amount calculation errors.
768: -- See bug 5203622 for more details.
769: IF p_pa_debug_mode = 'Y' THEN
770: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
771: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.' ||
772: 'UPD_REV_CALCULATION_ERR',
773: P_CALLED_MODE => p_called_mode,
774: P_MODULE_NAME => l_module_name);
775: END IF;

Line 776: PA_FP_GEN_FCST_AMT_PUB.UPD_REV_CALCULATION_ERR

772: 'UPD_REV_CALCULATION_ERR',
773: P_CALLED_MODE => p_called_mode,
774: P_MODULE_NAME => l_module_name);
775: END IF;
776: PA_FP_GEN_FCST_AMT_PUB.UPD_REV_CALCULATION_ERR
777: (P_PROJECT_ID => p_project_id,
778: P_BUDGET_VERSION_ID => p_budget_version_id,
779: P_FP_COLS_REC => p_fp_cols_rec,
780: P_ETC_START_DATE => p_actuals_thru_date + 1,

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

783: X_MSG_COUNT => X_MSG_COUNT,
784: X_MSG_DATA => X_MSG_DATA);
785: IF p_pa_debug_mode = 'Y' THEN
786: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
787: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.' ||
788: 'UPD_REV_CALCULATION_ERR: '||x_return_status,
789: P_CALLED_MODE => p_called_mode,
790: P_MODULE_NAME => l_module_name);
791: END IF;

Line 795: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl

791: END IF;
792:
793: --Start Bug 5726785
794:
795: PA_FP_GEN_FCST_AMT_PUB1.call_clnt_extn_and_update_bl
796: (p_project_id => p_project_id
797: ,p_budget_version_id => p_budget_version_id
798: ,x_call_maintain_data_api => l_call_maintain_data_api
799: ,x_return_status => x_return_status

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

802:
803: IF p_pa_debug_mode = 'Y' THEN
804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
805: P_CALLED_MODE => P_CALLED_MODE,
806: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
807: 'call_clnt_extn_and_update_bl '||x_return_status,
808: P_MODULE_NAME => l_module_name);
809: END IF;
810: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

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

818:
819: IF p_pa_debug_mode = 'Y' THEN
820: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
821: P_CALLED_MODE => P_CALLED_MODE,
822: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
823: 'MAINTAIN_BUDGET_VERSION',
824: P_MODULE_NAME => l_module_name);
825: END IF;
826: --dbms_output.put_line('++Before pub1.maintain_bv++');

Line 827: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION

823: 'MAINTAIN_BUDGET_VERSION',
824: P_MODULE_NAME => l_module_name);
825: END IF;
826: --dbms_output.put_line('++Before pub1.maintain_bv++');
827: PA_FP_GEN_FCST_AMT_PUB1.MAINTAIN_BUDGET_VERSION
828: (P_PROJECT_ID => P_PROJECT_ID,
829: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
830: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
831: P_CALL_MAINTAIN_DATA_API => L_CALL_MAINTAIN_DATA_API,

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

836: --dbms_output.put_line('??x_msg_count:'||x_msg_count);
837: IF p_pa_debug_mode = 'Y' THEN
838: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
839: P_CALLED_MODE => P_CALLED_MODE,
840: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
841: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
842: P_MODULE_NAME => l_module_name);
843: END IF;
844: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

Line 891: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889: x_msg_data := SUBSTR(SQLERRM,1,240);
890: FND_MSG_PUB.add_exc_msg
891: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
892: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');
893: IF P_PA_DEBUG_MODE = 'Y' THEN
894: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
895: P_CALLED_MODE => P_CALLED_MODE,

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

915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
916: X_MSG_COUNT OUT NOCOPY NUMBER,
917: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
918:
919: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.gen_fcst_task_level_amt';
920:
921: l_latest_published_fwbs_id NUMBER;
922: l_proj_struc_sharing_code VARCHAR2(30);
923:

Line 973: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;

969: l_curr_etc_method_code VARCHAR2(30);
970: l_curr_src_ra_id NUMBER;
971: l_curr_tgt_ra_id NUMBER;
972: l_curr_rlm_id NUMBER;
973: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
974: l_work_qty_cnt NUMBER:= 0;
975:
976: /* Indices for ETC method PL/SQL tables */
977: l_rb_index BINARY_INTEGER;

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

1662: IF l_fcst_gen_src_code = 'AVERAGE_ACTUALS' THEN
1663: IF p_pa_debug_mode = 'Y' THEN
1664: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1665: P_CALLED_MODE => P_CALLED_MODE,
1666: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
1667: 'GEN_AVERAGE_OF_ACTUALS_WRP for Revenue only version',
1668: P_MODULE_NAME => l_module_name);
1669: END IF;
1670:

Line 1684: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

1680: /* When the task id is passed as NULL, the wrapper API generates
1681: the ETC numbers for all the target version planning resources
1682: based on the average value of the actual txn data. */
1683:
1684: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
1685: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1686: P_TASK_ID => NULL,
1687: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
1688: P_FP_COLS_REC => P_FP_COLS_REC,

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

1697: -- ||x_return_status);
1698: IF p_pa_debug_mode = 'Y' THEN
1699: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1700: P_CALLED_MODE => P_CALLED_MODE,
1701: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
1702: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
1703: P_MODULE_NAME => l_module_name);
1704: END IF;
1705:

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

1826:
1827: IF P_PA_DEBUG_MODE = 'Y' THEN
1828: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1829: P_CALLED_MODE => P_CALLED_MODE,
1830: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1831: 'CALL_SUMM_POP_TMPS',
1832: P_MODULE_NAME => l_module_name);
1833: END IF;
1834:

Line 1841: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1837: hr_utility.trace('1.l_resource_list_id: '||l_resource_list_id);
1838: hr_utility.trace('1.l_struct_ver_id: '||l_struct_ver_id);
1839: hr_utility.trace('1.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1840:
1841: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1842: P_PROJECT_ID => P_PROJECT_ID,
1843: P_CALENDAR_TYPE => l_calendar_type,
1844: P_RECORD_TYPE => l_record_type,
1845: P_RESOURCE_LIST_ID => l_resource_list_id,

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

1852: -- hr_utility.trace('1.Status after calling call_summ_pop_tmps api: '||x_return_status);
1853: IF P_PA_DEBUG_MODE = 'Y' THEN
1854: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1855: P_CALLED_MODE => P_CALLED_MODE,
1856: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1857: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1858: P_MODULE_NAME => l_module_name);
1859: END IF;
1860: --dbms_output.put_line('After calling pji api: '||x_return_status);

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

1884:
1885: IF P_PA_DEBUG_MODE = 'Y' THEN
1886: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1887: P_CALLED_MODE => P_CALLED_MODE,
1888: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1889: 'CALL_SUMM_POP_TMPS',
1890: P_MODULE_NAME => l_module_name);
1891: END IF;
1892:

Line 1899: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1895: hr_utility.trace('2.l_resource_list_id: '||l_resource_list_id);
1896: hr_utility.trace('2.l_struct_ver_id: '||l_struct_ver_id);
1897: hr_utility.trace('2.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1898:
1899: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1900: P_PROJECT_ID => P_PROJECT_ID,
1901: P_CALENDAR_TYPE => l_calendar_type,
1902: P_RECORD_TYPE => l_record_type,
1903: P_RESOURCE_LIST_ID => l_resource_list_id,

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

1910: -- hr_utility.trace('2.Status after calling call_summ_pop_tmps api: '||x_return_status);
1911: IF P_PA_DEBUG_MODE = 'Y' THEN
1912: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1913: P_CALLED_MODE => P_CALLED_MODE,
1914: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1915: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1916: P_MODULE_NAME => l_module_name);
1917: END IF;
1918: --dbms_output.put_line('After calling pji api: '||x_return_status);

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

1938: END IF;*/
1939: IF P_PA_DEBUG_MODE = 'Y' THEN
1940: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1941: P_CALLED_MODE => P_CALLED_MODE,
1942: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB1.'||
1943: 'CALL_SUMM_POP_TMPS',
1944: P_MODULE_NAME => l_module_name);
1945: END IF;
1946: /* hr_utility.trace('3.l_calendar_type: '||l_calendar_type);

Line 1951: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(

1947: hr_utility.trace('3.l_record_type: '||l_record_type);
1948: hr_utility.trace('3.l_resource_list_id: '||l_resource_list_id);
1949: hr_utility.trace('3.l_struct_ver_id: '||l_struct_ver_id);
1950: hr_utility.trace('3.P_ACTUALS_THRU_DATE: '||P_ACTUALS_THRU_DATE); */
1951: PA_FP_GEN_FCST_AMT_PUB1.CALL_SUMM_POP_TMPS(
1952: P_PROJECT_ID => P_PROJECT_ID,
1953: P_CALENDAR_TYPE => l_calendar_type,
1954: P_RECORD_TYPE => l_record_type,
1955: P_RESOURCE_LIST_ID => l_resource_list_id,

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

1962: -- hr_utility.trace('3.Status after calling call_summ_pop_tmps api: '||x_return_status);
1963: IF P_PA_DEBUG_MODE = 'Y' THEN
1964: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1965: P_CALLED_MODE => P_CALLED_MODE,
1966: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
1967: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1968: P_MODULE_NAME => l_module_name);
1969: END IF;
1970: --dbms_output.put_line(' --After calling pji get_summarized api: '||x_return_status);

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

2090: *transaction amts for a given task**/
2091: IF P_PA_DEBUG_MODE = 'Y' THEN
2092: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2093: P_CALLED_MODE => P_CALLED_MODE,
2094: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub.'||
2095: 'get_total_plan_txn_amts',
2096: P_MODULE_NAME => l_module_name);
2097: END IF;
2098: --dbms_output.put_line('--Before GET_TOTAL--');

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

2136: END;
2137: IF p_pa_debug_mode = 'Y' THEN
2138: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2139: P_CALLED_MODE => P_CALLED_MODE,
2140: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2141: 'get_total_plan_txn_amts: '||x_return_status,
2142: P_MODULE_NAME => l_module_name);
2143: END IF;
2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2174: END IF;
2175: IF P_PA_DEBUG_MODE = 'Y' THEN
2176: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2177: P_CALLED_MODE => P_CALLED_MODE,
2178: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.'||
2179: 'GET_ETC_WORK_QTY_AMTS',
2180: P_MODULE_NAME => l_module_name);
2181: END IF;
2182: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and

Line 2184: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(

2180: P_MODULE_NAME => l_module_name);
2181: END IF;
2182: /*WORK_QTY_AMTS are generated at task level, so P_RESOURCE_ASSIGNMENT and
2183: P_RESOURCE_LIST_MEMBER_ID are not needed*/
2184: PA_FP_GEN_FCST_AMT_PUB1.GET_ETC_WORK_QTY_AMTS(
2185: P_PROJECT_ID => P_PROJECT_ID,
2186: P_PROJ_CURRENCY_CODE => P_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
2187: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2188: P_TASK_ID => l_curr_task_id,

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

2195: X_MSG_DATA => x_msg_data);
2196: IF p_pa_debug_mode = 'Y' THEN
2197: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2198: P_CALLED_MODE => P_CALLED_MODE,
2199: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2200: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,
2201: P_MODULE_NAME => l_module_name);
2202: END IF;
2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2207: ELSIF l_curr_etc_source = 'NONE' THEN
2208: IF P_PA_DEBUG_MODE = 'Y' THEN
2209: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2210: P_CALLED_MODE => P_CALLED_MODE,
2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2212: P_MODULE_NAME => l_module_name);
2213: END IF;
2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2215: P_PROJECT_ID => P_PROJECT_ID,

Line 2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(

2210: P_CALLED_MODE => P_CALLED_MODE,
2211: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub1.none_etc_src',
2212: P_MODULE_NAME => l_module_name);
2213: END IF;
2214: PA_FP_GEN_FCST_AMT_PUB1.NONE_ETC_SRC(
2215: P_PROJECT_ID => P_PROJECT_ID,
2216: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2217: P_RESOURCE_LIST_ID => l_fp_cols_rec_target.X_RESOURCE_LIST_ID,
2218: P_TASK_ID => l_curr_task_id,

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

2326: FOR i IN 1..l_avg_actuals_task_id_tab.count LOOP
2327: IF p_pa_debug_mode = 'Y' THEN
2328: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2329: P_CALLED_MODE => P_CALLED_MODE,
2330: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB.'||
2331: 'GEN_AVERAGE_OF_ACTUALS_WRP',
2332: P_MODULE_NAME => l_module_name);
2333: END IF;
2334: /* hr_utility.trace('Values passed to call GEN_AVERAGE_OF_ACTUALS_WRP api');

Line 2342: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP

2338: hr_utility.trace('P_ACTUALS_FROM_PERIOD: '||P_ACTUALS_FROM_PERIOD);
2339: hr_utility.trace('P_ACTUALS_TO_PERIOD: '||P_ACTUALS_TO_PERIOD);
2340: hr_utility.trace('P_ETC_FROM_PERIOD: '||P_ETC_FROM_PERIOD);
2341: hr_utility.trace('P_ETC_TO_PERIOD: '||P_ETC_TO_PERIOD); */
2342: PA_FP_GEN_FCST_AMT_PUB1.GEN_AVERAGE_OF_ACTUALS_WRP
2343: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2344: P_TASK_ID => l_avg_actuals_task_id_tab(i),
2345: P_ACTUALS_THRU_DATE => P_ACTUALS_THRU_DATE,
2346: P_FP_COLS_REC => P_FP_COLS_REC,

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

2355: -- ||x_return_status);
2356: IF p_pa_debug_mode = 'Y' THEN
2357: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2358: P_CALLED_MODE => P_CALLED_MODE,
2359: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2360: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2361: P_MODULE_NAME => l_module_name);
2362: END IF;
2363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2776: * is present in this API itself. */
2777: IF P_PA_DEBUG_MODE = 'Y' THEN
2778: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2779: P_CALLED_MODE => P_CALLED_MODE,
2780: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2781: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',
2782: P_MODULE_NAME => l_module_name);
2783: END IF;
2784: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(

Line 2784: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(

2780: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub3.'||
2781: 'GET_ETC_REMAIN_BDGT_AMTS_BLK',
2782: P_MODULE_NAME => l_module_name);
2783: END IF;
2784: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_REMAIN_BDGT_AMTS_BLK(
2785: P_SRC_RES_ASG_ID_TAB => l_rb_src_ra_id_tab,
2786: P_TGT_RES_ASG_ID_TAB => l_rb_tgt_ra_id_tab,
2787: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
2788: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

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

2798: X_MSG_DATA => x_msg_data);
2799: IF p_pa_debug_mode = 'Y' THEN
2800: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2801: P_CALLED_MODE => P_CALLED_MODE,
2802: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2803: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,
2804: P_MODULE_NAME => l_module_name);
2805: END IF;
2806: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2815: * is present in this API itself. */
2816: IF P_PA_DEBUG_MODE = 'Y' THEN
2817: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2818: P_CALLED_MODE => P_CALLED_MODE,
2819: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
2820: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',
2821: P_MODULE_NAME => l_module_name);
2822: END IF;
2823: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(

Line 2823: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(

2819: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub4.'||
2820: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK',
2821: P_MODULE_NAME => l_module_name);
2822: END IF;
2823: PA_FP_GEN_FCST_AMT_PUB4.GET_ETC_BDGT_COMPLETE_AMTS_BLK(
2824: P_SRC_RES_ASG_ID_TAB => l_bc_src_ra_id_tab,
2825: P_TGT_RES_ASG_ID_TAB => l_bc_tgt_ra_id_tab,
2826: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
2827: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

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

2837: X_MSG_DATA => x_msg_data);
2838: IF p_pa_debug_mode = 'Y' THEN
2839: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2840: P_CALLED_MODE => P_CALLED_MODE,
2841: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
2842: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,
2843: P_MODULE_NAME => l_module_name);
2844: END IF;
2845: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2854: * is present in this API itself. */
2855: IF P_PA_DEBUG_MODE = 'Y' THEN
2856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2857: P_CALLED_MODE => P_CALLED_MODE,
2858: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
2859: 'GET_ETC_EARNED_VALUE_AMTS_BLK',
2860: P_MODULE_NAME => l_module_name);
2861: END IF;
2862: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(

Line 2862: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(

2858: P_MSG => 'Before calling pa_fp_gen_fcst_amt_pub5.'||
2859: 'GET_ETC_EARNED_VALUE_AMTS_BLK',
2860: P_MODULE_NAME => l_module_name);
2861: END IF;
2862: PA_FP_GEN_FCST_AMT_PUB5.GET_ETC_EARNED_VALUE_AMTS_BLK(
2863: P_SRC_RES_ASG_ID_TAB => l_ev_src_ra_id_tab,
2864: P_TGT_RES_ASG_ID_TAB => l_ev_tgt_ra_id_tab,
2865: P_FP_COLS_SRC_REC_FP => l_fp_cols_rec_fp,
2866: P_FP_COLS_SRC_REC_WP => l_fp_cols_rec_wp,

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

2876: X_MSG_DATA => x_msg_data);
2877: IF p_pa_debug_mode = 'Y' THEN
2878: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2879: P_CALLED_MODE => P_CALLED_MODE,
2880: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
2881: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,
2882: P_MODULE_NAME => l_module_name);
2883: END IF;
2884: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

2895: -- hr_utility.trace('after for loop :');
2896: IF P_PA_DEBUG_MODE = 'Y' THEN
2897: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2898: P_CALLED_MODE => P_CALLED_MODE,
2899: P_MSG => 'Before calling PA_FP_GEN_FCST_AMT_PUB3.'||
2900: 'GET_ETC_COMMITMENT_AMTS',
2901: P_MODULE_NAME => l_module_name);
2902: END IF;
2903: -- hr_utility.trace('before pub3 cmt amts:');

Line 2904: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_COMMITMENT_AMTS

2900: 'GET_ETC_COMMITMENT_AMTS',
2901: P_MODULE_NAME => l_module_name);
2902: END IF;
2903: -- hr_utility.trace('before pub3 cmt amts:');
2904: PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_COMMITMENT_AMTS
2905: (P_FP_COLS_TGT_REC => p_fp_cols_rec,
2906: P_WP_PLANNING_OPTIONS_FLAG => l_wp_planning_options_flag, /* Bug 4369741 */
2907: P_FP_PLANNING_OPTIONS_FLAG => l_fp_planning_options_flag, /* Bug 4369741 */
2908: X_RETURN_STATUS => x_return_status,

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

2913:
2914: IF p_pa_debug_mode = 'Y' THEN
2915: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
2916: P_CALLED_MODE => P_CALLED_MODE,
2917: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
2918: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,
2919: P_MODULE_NAME => l_module_name);
2920: END IF;
2921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',

3786: IF P_PA_DEBUG_MODE = 'Y' THEN
3787: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3788: P_CALLED_MODE => P_CALLED_MODE,
3789: P_MSG =>
3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
3791: P_MODULE_NAME => l_module_name);
3792: END IF;
3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
3794: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),

Line 3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE

3789: P_MSG =>
3790: 'Before calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE',
3791: P_MODULE_NAME => l_module_name);
3792: END IF;
3793: PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE
3794: (P_SOURCE_RES_ASG_ID => l_cal_src_ra_id_tab(i),
3795: P_TARGET_RES_ASG_ID => l_cal_ra_id_tab(i),
3796: P_TXN_CURRENCY_CODE => l_cal_txn_currency_code_tab(i),
3797: X_RETURN_STATUS => x_return_status,

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

3803: IF P_PA_DEBUG_MODE = 'Y' THEN
3804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
3805: P_CALLED_MODE => P_CALLED_MODE,
3806: P_MSG =>
3807: 'After calling PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE: '||x_return_status,
3808: P_MODULE_NAME => l_module_name);
3809: END IF;
3810:
3811: /* Populate the period rates table for the Client Extension API */

Line 3920: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate

3916: END IF;
3917: /*For client_extn, many attributes are passed as NULL is because
3918: this API is still under developmen and some parameters are not
3919: available.Null values will be replaced later*/
3920: /* Call PA_FP_GEN_FCST_AMT_PUB1.POPULATE_GEN_RATE to populate
3921: pa_fp_gen_rate_tmp, which is used to populate input parameter
3922: P_PERIOD_RATES_TBL */
3923:
3924: -- hr_utility.trace('==before calling client extn api ');

Line 4679: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

4675: WHEN OTHERS THEN
4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: x_msg_data := SUBSTR(SQLERRM,1,240);
4678: FND_MSG_PUB.add_exc_msg
4679: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4680: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');
4681: IF P_PA_DEBUG_MODE = 'Y' THEN
4682: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4683: P_CALLED_MODE => P_CALLED_MODE,

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

4695: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4696: X_MSG_COUNT OUT NOCOPY NUMBER,
4697: X_MSG_DATA OUT NOCOPY VARCHAR2)
4698: IS
4699: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.maintain_res_asg';
4700:
4701: l_msg_count NUMBER;
4702: l_msg_data VARCHAR2(2000);
4703: l_data VARCHAR2(2000);

Line 4853: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'

4849: WHEN OTHERS THEN
4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4851: x_msg_data := SUBSTR(SQLERRM,1,240);
4852: FND_MSG_PUB.add_exc_msg
4853: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4854: ,p_procedure_name => 'MAINTAIN_RES_ASG');
4855: IF P_PA_DEBUG_MODE = 'Y' THEN
4856: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4857: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

4887: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4888: X_MSG_COUNT OUT NOCOPY NUMBER,
4889: X_MSG_DATA OUT NOCOPY VARCHAR2 )
4890: IS
4891: l_package_name VARCHAR2(30) := 'PA_FP_GEN_FCST_AMT_PUB';
4892: l_procedure_name VARCHAR2(30) := 'UPD_REV_CALCULATION_ERR';
4893: l_module_name VARCHAR2(100);
4894:
4895: l_log_level NUMBER := 5;

Line 5026: END PA_FP_GEN_FCST_AMT_PUB;

5022:
5023: END UPD_REV_CALCULATION_ERR;
5024:
5025:
5026: END PA_FP_GEN_FCST_AMT_PUB;