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.10 2007/11/27 11:34:27 vgovvala 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 289: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.GET_ACT_FRM_PERIOD';

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

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

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

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

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

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

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

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

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

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

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

Line 796: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

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

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

838: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
839: X_MSG_COUNT OUT NOCOPY NUMBER,
840: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
841:
842: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.upd_ver_dtls_and_gen_amt';
843: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
844: l_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
845: l_ETC_PLAN_VERSION_ID PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
846: l_return_status VARCHAR2(10);

Line 1012: pa_fp_gen_fcst_pg_pkg.validate_periods',

1008: IF L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'RESOURCE_SCHEDULE' THEN
1009: IF p_pa_debug_mode = 'Y' THEN
1010: pa_fp_gen_amount_utils.fp_debug
1011: (p_msg => 'Before calling
1012: pa_fp_gen_fcst_pg_pkg.validate_periods',
1013: p_module_name => l_module_name,
1014: p_log_level => 5);
1015: END IF;
1016: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS

Line 1016: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS

1012: pa_fp_gen_fcst_pg_pkg.validate_periods',
1013: p_module_name => l_module_name,
1014: p_log_level => 5);
1015: END IF;
1016: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PERIODS
1017: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
1018: P_FP_COLS_REC => l_fp_cols_rec,
1019: P_UNSPENT_AMT_FLAG => P_UNSPENT_AMT_FLAG,
1020: P_UNSPENT_AMT_PERIOD => P_UNSPENT_AMT_PERIOD,

Line 1035: pa_fp_gen_fcst_pg_pkg.validate_periods: '

1031: END IF;
1032: IF p_pa_debug_mode = 'Y' THEN
1033: pa_fp_gen_amount_utils.fp_debug
1034: (p_msg => 'Status after calling
1035: pa_fp_gen_fcst_pg_pkg.validate_periods: '
1036: ||x_return_status,
1037: p_module_name => l_module_name,
1038: p_log_level => 5);
1039: END IF;

Line 1049: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',

1045: l_ETC_PLAN_VERSION_ID IS NULL THEN
1046: IF p_pa_debug_mode = 'Y' THEN
1047: pa_fp_gen_amount_utils.fp_debug
1048: (p_msg => 'Before calling
1049: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1050: p_module_name => l_module_name,
1051: p_log_level => 5);
1052: END IF;
1053: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION

Line 1053: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION

1049: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version',
1050: p_module_name => l_module_name,
1051: p_log_level => 5);
1052: END IF;
1053: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PLAN_TYPE_OR_VERSION
1054: (P_PROJECT_ID => l_fp_cols_rec.X_PROJECT_ID,
1055: P_PLAN_TYPE_ID => P_ETC_PLAN_TYPE_ID,
1056: PX_PLAN_VERSION_ID => l_ETC_PLAN_VERSION_ID,
1057: P_PLAN_VERSION_NAME => P_ETC_PLAN_VERSION_NAME,

Line 1069: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '

1065: END IF;
1066: IF p_pa_debug_mode = 'Y' THEN
1067: pa_fp_gen_amount_utils.fp_debug
1068: ( p_msg => 'Status after calling
1069: pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version for etc_generation_source: '
1070: ||x_return_status,
1071: p_module_name => l_module_name,
1072: p_log_level => 5);
1073: END IF;

Line 1454: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: x_msg_data := SUBSTR(SQLERRM,1,240);
1452:
1453: FND_MSG_PUB.add_exc_msg
1454: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1455: ,p_procedure_name => 'UPD_VER_DTLS_AND_GEN_AMT');
1456: IF P_PA_DEBUG_MODE = 'Y' THEN
1457: pa_fp_gen_amount_utils.fp_debug
1458: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

1477: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1478: X_MSG_COUNT OUT NOCOPY NUMBER,
1479: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1480:
1481: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_periods';
1482: l_return_status VARCHAR2(30);
1483: l_msg_count NUMBER;
1484: l_msg_data VARCHAR2(2000);
1485: l_data VARCHAR2(2000);

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

1517: p_msg_name => 'PA_FP_NO_UNSPENT_PERIOD');
1518: END IF;
1519:
1520: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN
1521: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1522: IF p_pa_debug_mode = 'Y' THEN
1523: pa_fp_gen_amount_utils.fp_debug
1524: (p_msg => 'Before calling
1525: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',

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

1521: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date) api
1522: IF p_pa_debug_mode = 'Y' THEN
1523: pa_fp_gen_amount_utils.fp_debug
1524: (p_msg => 'Before calling
1525: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1526: p_module_name => l_module_name,
1527: p_log_level => 5);
1528: END IF;
1529: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1529: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1525: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date)',
1526: p_module_name => l_module_name,
1527: p_log_level => 5);
1528: END IF;
1529: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1530: (P_PERIOD_NAME => P_UNSPENT_AMT_PERIOD,
1531: P_FP_COLS_REC => P_FP_COLS_REC,
1532: P_CONTEXT => 'UNSPENT_PERIOD',
1533: X_END_DATE => l_unspent_date ,

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

1537: l_return_status := X_RETURN_STATUS;
1538: IF p_pa_debug_mode = 'Y' THEN
1539: pa_fp_gen_amount_utils.fp_debug
1540: (p_msg => 'Status after calling
1541: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(unspent date): '
1542: ||x_return_status,
1543: p_module_name => l_module_name,
1544: p_log_level => 5);
1545: END IF;

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

1552: p_msg_name => 'PA_FP_NO_ACTUALS_FROM_PERIOD');
1553: ELSE*/
1554:
1555: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN
1556: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1557: IF p_pa_debug_mode = 'Y' THEN
1558: pa_fp_gen_amount_utils.fp_debug
1559: (p_msg => 'Before calling
1560: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',

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

1556: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from) api
1557: IF p_pa_debug_mode = 'Y' THEN
1558: pa_fp_gen_amount_utils.fp_debug
1559: (p_msg => 'Before calling
1560: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1561: p_module_name => l_module_name,
1562: p_log_level => 5);
1563: END IF;
1564: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1564: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1560: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from)',
1561: p_module_name => l_module_name,
1562: p_log_level => 5);
1563: END IF;
1564: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1565: (P_PERIOD_NAME => P_ACTUALS_FROM_PERIOD,
1566: P_FP_COLS_REC => P_FP_COLS_REC,
1567: P_CONTEXT => 'ACTUALS_FROM_PERIOD',
1568: X_END_DATE => l_act_frm_date,

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

1571: X_MSG_DATA => X_MSG_DATA);
1572: IF p_pa_debug_mode = 'Y' THEN
1573: pa_fp_gen_amount_utils.fp_debug
1574: (p_msg => 'Status after calling
1575: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals from): '
1576: ||x_return_status,
1577: p_module_name => l_module_name,
1578: p_log_level => 5);
1579: END IF;

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

1592: p_msg_name => 'PA_FP_NO_ACTUALS_TO_PERIOD');
1593: ELSE */
1594:
1595: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN
1596: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1597: IF p_pa_debug_mode = 'Y' THEN
1598: pa_fp_gen_amount_utils.fp_debug
1599: (p_msg => 'Before calling
1600: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',

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

1596: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to) api
1597: IF p_pa_debug_mode = 'Y' THEN
1598: pa_fp_gen_amount_utils.fp_debug
1599: (p_msg => 'Before calling
1600: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1601: p_module_name => l_module_name,
1602: p_log_level => 5);
1603: END IF;
1604: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1604: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1600: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to)',
1601: p_module_name => l_module_name,
1602: p_log_level => 5);
1603: END IF;
1604: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1605: (P_PERIOD_NAME => P_ACTUALS_TO_PERIOD,
1606: P_FP_COLS_REC => P_FP_COLS_REC,
1607: P_CONTEXT => 'ACTUALS_TO_PERIOD',
1608: X_END_DATE => l_act_to_date,

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

1611: X_MSG_DATA => X_MSG_DATA);
1612: IF p_pa_debug_mode = 'Y' THEN
1613: pa_fp_gen_amount_utils.fp_debug
1614: ( p_msg => 'Status after calling
1615: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(actuals to): '
1616: ||x_return_status,
1617: p_module_name => l_module_name,
1618: p_log_level => 5);
1619: END IF;

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

1631: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1632: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1633: ELSE*/
1634: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1635: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1636: IF p_pa_debug_mode = 'Y' THEN
1637: pa_fp_gen_amount_utils.fp_debug
1638: (p_msg => 'Before calling
1639: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',

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

1635: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api
1636: IF p_pa_debug_mode = 'Y' THEN
1637: pa_fp_gen_amount_utils.fp_debug
1638: (p_msg => 'Before calling
1639: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1640: p_module_name => l_module_name,
1641: p_log_level => 5);
1642: END IF;
1643: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1643: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1639: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from)',
1640: p_module_name => l_module_name,
1641: p_log_level => 5);
1642: END IF;
1643: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1644: (P_PERIOD_NAME => P_ETC_FROM_PERIOD,
1645: P_FP_COLS_REC => P_FP_COLS_REC,
1646: P_CONTEXT => 'ETC_FROM_PERIOD',
1647: X_END_DATE => l_etc_frm_date,

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

1650: X_MSG_DATA => X_MSG_DATA);
1651: IF p_pa_debug_mode = 'Y' THEN
1652: pa_fp_gen_amount_utils.fp_debug
1653: (p_msg => 'Status after calling
1654: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from): '
1655: ||x_return_status,
1656: p_module_name => l_module_name,
1657: p_log_level => 5);
1658: END IF;

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

1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1672: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1673: ELSE */
1674: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1675: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1676: IF p_pa_debug_mode = 'Y' THEN
1677: pa_fp_gen_amount_utils.fp_debug
1678: (p_msg => 'Before calling

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

1675: IF P_ETC_TO_PERIOD IS NOT NULL THEN
1676: IF p_pa_debug_mode = 'Y' THEN
1677: pa_fp_gen_amount_utils.fp_debug
1678: (p_msg => 'Before calling
1679: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1680: p_module_name => l_module_name,
1681: p_log_level => 5);
1682: END IF;
1683: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

Line 1683: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS

1679: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to)',
1680: p_module_name => l_module_name,
1681: p_log_level => 5);
1682: END IF;
1683: PA_FP_GEN_FCST_PG_PKG.VALIDATE_PA_GL_PERIODS
1684: (P_PERIOD_NAME => P_ETC_TO_PERIOD,
1685: P_FP_COLS_REC => P_FP_COLS_REC,
1686: P_CONTEXT => 'ETC_TO_PERIOD',
1687: X_END_DATE => l_etc_to_date,

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

1690: X_MSG_DATA => X_MSG_DATA);
1691: IF p_pa_debug_mode = 'Y' THEN
1692: pa_fp_gen_amount_utils.fp_debug
1693: (p_msg => 'Status after calling
1694: pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to): '
1695: ||x_return_status,
1696: p_module_name => l_module_name,
1697: p_log_level => 5);
1698: END IF;

Line 1798: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: x_msg_data := SUBSTR(SQLERRM,1,240);
1797: FND_MSG_PUB.add_exc_msg
1798: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1799: ,p_procedure_name => 'VALIDATE_PERIODS');
1800: IF P_PA_DEBUG_MODE = 'Y' THEN
1801: pa_fp_gen_amount_utils.fp_debug
1802: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

1817: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1818: X_MSG_COUNT OUT NOCOPY NUMBER,
1819: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1820:
1821: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods';
1822: l_return_status VARCHAR2(30);
1823: l_msg_count NUMBER;
1824: l_msg_data VARCHAR2(2000);
1825: l_data VARCHAR2(2000);

Line 1947: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

1943: WHEN OTHERS THEN
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: x_msg_data := SUBSTR(SQLERRM,1,240);
1946: FND_MSG_PUB.add_exc_msg
1947: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1948: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');
1949: IF P_PA_DEBUG_MODE = 'Y' THEN
1950: pa_fp_gen_amount_utils.fp_debug
1951: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

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

1967: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1968: X_MSG_COUNT OUT NOCOPY NUMBER,
1969: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1970:
1971: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_pg_pkg.validate_plan_type_or_version';
1972: l_plan_version_id PA_BUDGET_VERSIONS.VERSION_NAME%TYPE;
1973: l_msg_count NUMBER;
1974: l_msg_data VARCHAR2(2000);
1975: l_data VARCHAR2(2000);

Line 2080: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

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

Line 2093: END PA_FP_GEN_FCST_PG_PKG;

2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090:
2091: END VALIDATE_PLAN_TYPE_OR_VERSION;
2092:
2093: END PA_FP_GEN_FCST_PG_PKG;