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_PG_PKG dependencies on PA_FP_GEN_FCST_PG_PKG

Line 1: PACKAGE body PA_FP_GEN_FCST_PG_PKG as

1: PACKAGE body PA_FP_GEN_FCST_PG_PKG as
2: /* $Header: PAFPGFPB.pls 120.13.12020000.2 2013/05/16 06:37:12 djambhek ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 11: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_REV_GEN_METHOD';

7: RETURN VARCHAR2 IS
8:
9: x_rev_gen_method VARCHAR2(3);
10: l_error_msg VARCHAR2(30);
11: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_REV_GEN_METHOD';
12:
13: BEGIN
14: IF p_pa_debug_mode = 'Y' THEN
15: pa_debug.set_curr_function( p_function => 'GET_REV_GEN_METHOD',

Line 75: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACTUALS_THRU_PERIOD_DTLS';

71: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
72: l_ret_status VARCHAR2(100);
73: l_msg_count NUMBER;
74: l_msg_data VARCHAR2(2000);
75: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACTUALS_THRU_PERIOD_DTLS';
76:
77: BEGIN
78: IF p_pa_debug_mode = 'Y' THEN
79: pa_debug.set_curr_function( p_function => 'GET_ACTUALS_THRU_PERIOD_DTLS',

Line 290: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_FRM_PERIOD';

286: END;
287:
288: FUNCTION GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
289: RETURN VARCHAR2 IS
290: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_FRM_PERIOD';
291:
292:
293: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
294: l_return_status VARCHAR2(10);

Line 382: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_TO_PERIOD';

378: END;
379:
380: FUNCTION GET_ACT_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
381: RETURN VARCHAR2 IS
382: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_TO_PERIOD';
383: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
384: l_return_status VARCHAR2(10);
385: l_msg_count NUMBER;
386: l_msg_data VARCHAR2(2000);

Line 499: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_FRM_PERIOD';

495: END;
496:
497: FUNCTION GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
498: RETURN VARCHAR2 IS
499: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_FRM_PERIOD';
500: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
501: l_return_status VARCHAR2(10);
502: l_msg_count NUMBER;
503: l_msg_data VARCHAR2(2000);

Line 618: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_TO_PERIOD';

614: END;
615:
616: FUNCTION GET_ETC_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
617: RETURN VARCHAR2 IS
618: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ETC_TO_PERIOD';
619:
620: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
621: l_return_status VARCHAR2(10);
622: l_msg_count NUMBER;

Line 723: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_UNSPENT_AMT_PERIOD';

719:
720:
721: FUNCTION GET_UNSPENT_AMT_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
722: RETURN VARCHAR2 IS
723: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_UNSPENT_AMT_PERIOD';
724: x_period_name PA_PERIODS_ALL.PERIOD_NAME%TYPE;
725: BEGIN
726: x_period_name := GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID);
727: RETURN x_period_name;

Line 738: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.get_version_details';

734: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
735: X_MSG_COUNT OUT NOCOPY NUMBER,
736: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
737:
738: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.get_version_details';
739: l_msg_count NUMBER;
740: l_msg_data VARCHAR2(2000);
741: l_data VARCHAR2(2000);
742: l_msg_index_out NUMBER:=0;

Line 797: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

793: WHEN OTHERS THEN
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: x_msg_data := SUBSTR(SQLERRM,1,240);
796: FND_MSG_PUB.add_exc_msg
797: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
798: ,p_procedure_name => 'GET_VERSION_DETAILS');
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_fp_gen_amount_utils.fp_debug
801: (p_msg => 'Unexpected Error'||SUBSTR(SQLERRM,1,240),

Line 823: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag';

819: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
820: X_MSG_COUNT OUT NOCOPY NUMBER,
821: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
822:
823: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag';
824: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
825: l_msg_count NUMBER;
826: l_msg_data VARCHAR2(2000);
827: l_data VARCHAR2(2000);

Line 980: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

976: WHEN OTHERS THEN
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_msg_data := SUBSTR(SQLERRM,1,240);
979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
981: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
982: IF P_PA_DEBUG_MODE = 'Y' THEN
983: pa_fp_gen_amount_utils.fp_debug
984: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 1027: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';

1023: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1024: X_MSG_COUNT OUT NOCOPY NUMBER,
1025: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1026:
1027: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
1028: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1029: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1030: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
1031: l_return_status VARCHAR2(10);

Line 1249: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',

1245:
1246: IF p_pa_debug_mode = 'Y' THEN
1247: pa_fp_gen_amount_utils.fp_debug
1248: (p_msg => 'Before calling
1249: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
1250: p_module_name => l_module_name,
1251: p_log_level => 5);
1252: END IF;
1253: -- Calling the following method to validate time phase and ETC source of

Line 1268: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '

1264: END IF;
1265: IF p_pa_debug_mode = 'Y' THEN
1266: pa_fp_gen_amount_utils.fp_debug
1267: (p_msg => 'Status after calling
1268: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
1269: ||x_return_status,
1270: p_module_name => l_module_name,
1271: p_log_level => 5);
1272: END IF;

Line 1285: pa_fp_gen_fcst_pg_pkg.validate_periods',

1281: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1282: IF p_pa_debug_mode = 'Y' THEN
1283: pa_fp_gen_amount_utils.fp_debug
1284: (p_msg => 'Before calling
1285: pa_fp_gen_fcst_pg_pkg.validate_periods',
1286: p_module_name => l_module_name,
1287: p_log_level => 5);
1288: END IF;
1289: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS

Line 1289: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS

1285: pa_fp_gen_fcst_pg_pkg.validate_periods',
1286: p_module_name => l_module_name,
1287: p_log_level => 5);
1288: END IF;
1289: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS
1290: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1291: P_FP_COLS_REC => l_fp_cols_rec,
1292: P_UNSPENT_AMT_FLAG => P_UNSPENT_AMT_FLAG,
1293: P_UNSPENT_AMT_PERIOD => P_UNSPENT_AMT_PERIOD,

Line 1308: pa_fp_gen_fcst_pg_pkg.validate_periods: '

1304: END IF;
1305: IF p_pa_debug_mode = 'Y' THEN
1306: pa_fp_gen_amount_utils.fp_debug
1307: (p_msg => 'Status after calling
1308: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1309: ||x_return_status,
1310: p_module_name => l_module_name,
1311: p_log_level => 5);
1312: END IF;

Line 1322: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',

1318: l_ETC_PLAN_VERSION_ID IS NULL THEN
1319: IF p_pa_debug_mode = 'Y' THEN
1320: pa_fp_gen_amount_utils.fp_debug
1321: (p_msg => 'Before calling
1322: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1323: p_module_name => l_module_name,
1324: p_log_level => 5);
1325: END IF;
1326: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION

Line 1326: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION

1322: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1323: p_module_name => l_module_name,
1324: p_log_level => 5);
1325: END IF;
1326: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION
1327: (P_PROJECT_ID => l_fp_cols_rec.X_PROJECT_ID,
1328: P_PLAN_TYPE_ID => P_ETC_PLAN_TYPE_ID,
1329: PX_PLAN_VERSION_ID => l_ETC_PLAN_VERSION_ID,
1330: P_PLAN_VERSION_NAME => P_ETC_PLAN_VERSION_NAME,

Line 1342: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '

1338: END IF;
1339: IF p_pa_debug_mode = 'Y' THEN
1340: pa_fp_gen_amount_utils.fp_debug
1341: ( p_msg => 'Status after calling
1342: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1343: ||x_return_status,
1344: p_module_name => l_module_name,
1345: p_log_level => 5);
1346: END IF;

Line 1735: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: x_msg_data := SUBSTR(SQLERRM,1,240);
1733:
1734: FND_MSG_PUB.add_exc_msg
1735: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1736: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1737: IF P_PA_DEBUG_MODE = 'Y' THEN
1738: pa_fp_gen_amount_utils.fp_debug
1739: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 1762: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_periods';

1758: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1759: X_MSG_COUNT OUT NOCOPY NUMBER,
1760: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1761:
1762: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_periods';
1763: l_return_status VARCHAR2(30);
1764: l_msg_count NUMBER;
1765: l_msg_data VARCHAR2(2000);
1766: l_data VARCHAR2(2000);

Line 1802: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api

1798: p_msg_name => 'PA_FP_NO_UNSPENT_PERIOD');
1799: END IF;
1800:
1801: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1802: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1803: IF p_pa_debug_mode = 'Y' THEN
1804: pa_fp_gen_amount_utils.fp_debug
1805: (p_msg => 'Before calling
1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',

Line 1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',

1802: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1803: IF p_pa_debug_mode = 'Y' THEN
1804: pa_fp_gen_amount_utils.fp_debug
1805: (p_msg => 'Before calling
1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1807: p_module_name => l_module_name,
1808: p_log_level => 5);
1809: END IF;
1810: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1810: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1806: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1807: p_module_name => l_module_name,
1808: p_log_level => 5);
1809: END IF;
1810: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1811: (P_PERIOD_NAME => P_UNSPENT_AMT_PERIOD,
1812: P_FP_COLS_REC => P_FP_COLS_REC,
1813: P_CONTEXT => 'UNSPENT_PERIOD',
1814: X_END_DATE => l_unspent_date ,

Line 1822: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '

1818: l_return_status := X_RETURN_STATUS;
1819: IF p_pa_debug_mode = 'Y' THEN
1820: pa_fp_gen_amount_utils.fp_debug
1821: (p_msg => 'Status after calling
1822: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1823: ||x_return_status,
1824: p_module_name => l_module_name,
1825: p_log_level => 5);
1826: END IF;

Line 1837: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api

1833: p_msg_name => 'PA_FP_NO_ACTUALS_FROM_PERIOD');
1834: ELSE*/
1835:
1836: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1837: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1838: IF p_pa_debug_mode = 'Y' THEN
1839: pa_fp_gen_amount_utils.fp_debug
1840: (p_msg => 'Before calling
1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',

Line 1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',

1837: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1838: IF p_pa_debug_mode = 'Y' THEN
1839: pa_fp_gen_amount_utils.fp_debug
1840: (p_msg => 'Before calling
1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1842: p_module_name => l_module_name,
1843: p_log_level => 5);
1844: END IF;
1845: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1845: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1841: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1842: p_module_name => l_module_name,
1843: p_log_level => 5);
1844: END IF;
1845: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1846: (P_PERIOD_NAME => P_ACTUALS_FROM_PERIOD,
1847: P_FP_COLS_REC => P_FP_COLS_REC,
1848: P_CONTEXT => 'ACTUALS_FROM_PERIOD',
1849: X_END_DATE => l_act_frm_date,

Line 1856: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '

1852: X_MSG_DATA => X_MSG_DATA);
1853: IF p_pa_debug_mode = 'Y' THEN
1854: pa_fp_gen_amount_utils.fp_debug
1855: (p_msg => 'Status after calling
1856: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1857: ||x_return_status,
1858: p_module_name => l_module_name,
1859: p_log_level => 5);
1860: END IF;

Line 1877: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api

1873: p_msg_name => 'PA_FP_NO_ACTUALS_TO_PERIOD');
1874: ELSE */
1875:
1876: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1877: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_fp_gen_amount_utils.fp_debug
1880: (p_msg => 'Before calling
1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',

Line 1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',

1877: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1878: IF p_pa_debug_mode = 'Y' THEN
1879: pa_fp_gen_amount_utils.fp_debug
1880: (p_msg => 'Before calling
1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1882: p_module_name => l_module_name,
1883: p_log_level => 5);
1884: END IF;
1885: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1885: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1881: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1882: p_module_name => l_module_name,
1883: p_log_level => 5);
1884: END IF;
1885: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1886: (P_PERIOD_NAME => P_ACTUALS_TO_PERIOD,
1887: P_FP_COLS_REC => P_FP_COLS_REC,
1888: P_CONTEXT => 'ACTUALS_TO_PERIOD',
1889: X_END_DATE => l_act_to_date,

Line 1896: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '

1892: X_MSG_DATA => X_MSG_DATA);
1893: IF p_pa_debug_mode = 'Y' THEN
1894: pa_fp_gen_amount_utils.fp_debug
1895: ( p_msg => 'Status after calling
1896: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1897: ||x_return_status,
1898: p_module_name => l_module_name,
1899: p_log_level => 5);
1900: END IF;

Line 1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api

1912: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1913: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1914: ELSE*/
1915: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1917: IF p_pa_debug_mode = 'Y' THEN
1918: pa_fp_gen_amount_utils.fp_debug
1919: (p_msg => 'Before calling
1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',

Line 1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',

1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1917: IF p_pa_debug_mode = 'Y' THEN
1918: pa_fp_gen_amount_utils.fp_debug
1919: (p_msg => 'Before calling
1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1921: p_module_name => l_module_name,
1922: p_log_level => 5);
1923: END IF;
1924: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1924: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1920: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1921: p_module_name => l_module_name,
1922: p_log_level => 5);
1923: END IF;
1924: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1925: (P_PERIOD_NAME => P_ETC_FROM_PERIOD,
1926: P_FP_COLS_REC => P_FP_COLS_REC,
1927: P_CONTEXT => 'ETC_FROM_PERIOD',
1928: X_END_DATE => l_etc_frm_date,

Line 1935: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '

1931: X_MSG_DATA => X_MSG_DATA);
1932: IF p_pa_debug_mode = 'Y' THEN
1933: pa_fp_gen_amount_utils.fp_debug
1934: (p_msg => 'Status after calling
1935: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1936: ||x_return_status,
1937: p_module_name => l_module_name,
1938: p_log_level => 5);
1939: END IF;

Line 1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api

1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1953: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1954: ELSE */
1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1956: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1957: IF p_pa_debug_mode = 'Y' THEN
1958: pa_fp_gen_amount_utils.fp_debug
1959: (p_msg => 'Before calling

Line 1960: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',

1956: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1957: IF p_pa_debug_mode = 'Y' THEN
1958: pa_fp_gen_amount_utils.fp_debug
1959: (p_msg => 'Before calling
1960: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1961: p_module_name => l_module_name,
1962: p_log_level => 5);
1963: END IF;
1964: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1964: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1960: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1961: p_module_name => l_module_name,
1962: p_log_level => 5);
1963: END IF;
1964: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1965: (P_PERIOD_NAME => P_ETC_TO_PERIOD,
1966: P_FP_COLS_REC => P_FP_COLS_REC,
1967: P_CONTEXT => 'ETC_TO_PERIOD',
1968: X_END_DATE => l_etc_to_date,

Line 1975: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '

1971: X_MSG_DATA => X_MSG_DATA);
1972: IF p_pa_debug_mode = 'Y' THEN
1973: pa_fp_gen_amount_utils.fp_debug
1974: (p_msg => 'Status after calling
1975: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1976: ||x_return_status,
1977: p_module_name => l_module_name,
1978: p_log_level => 5);
1979: END IF;

Line 2079: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

2075: WHEN OTHERS THEN
2076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2077: x_msg_data := SUBSTR(SQLERRM,1,240);
2078: FND_MSG_PUB.add_exc_msg
2079: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2080: ,p_procedure_name => 'VALIDATE_PERIODS');
2081: IF P_PA_DEBUG_MODE = 'Y' THEN
2082: pa_fp_gen_amount_utils.fp_debug
2083: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 2102: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods';

2098: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2099: X_MSG_COUNT OUT NOCOPY NUMBER,
2100: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2101:
2102: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods';
2103: l_return_status VARCHAR2(30);
2104: l_msg_count NUMBER;
2105: l_msg_data VARCHAR2(2000);
2106: l_data VARCHAR2(2000);

Line 2228: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: x_msg_data := SUBSTR(SQLERRM,1,240);
2227: FND_MSG_PUB.add_exc_msg
2228: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2229: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
2230: IF P_PA_DEBUG_MODE = 'Y' THEN
2231: pa_fp_gen_amount_utils.fp_debug
2232: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 2252: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version';

2248: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2249: X_MSG_COUNT OUT NOCOPY NUMBER,
2250: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2251:
2252: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version';
2253: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
2254: l_msg_count NUMBER;
2255: l_msg_data VARCHAR2(2000);
2256: l_data VARCHAR2(2000);

Line 2361: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

2357: WHEN OTHERS THEN
2358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2359: x_msg_data := SUBSTR(SQLERRM,1,240);
2360: FND_MSG_PUB.add_exc_msg
2361: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2362: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_fp_gen_amount_utils.fp_debug
2365: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 2374: END PA_FP_GEN_FCST_PG_PKG;

2370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2371:
2372: END VALIDATE_PLAN_TYPE_OR_VERSION;
2373:
2374: END PA_FP_GEN_FCST_PG_PKG;