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_PUB3 dependencies on PA_FP_GEN_FCST_AMT_PUB3

Line 1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB3 as

1: PACKAGE body PA_FP_GEN_FCST_AMT_PUB3 as
2: /* $Header: PAFPFG3B.pls 120.8.12020000.3 2013/05/17 09:43:33 bpottipa ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 42: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_REMAIN_BDGT_AMTS';

38: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39: X_MSG_COUNT OUT NOCOPY NUMBER,
40: X_MSG_DATA OUT NOCOPY VARCHAR2)
41: IS
42: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_REMAIN_BDGT_AMTS';
43:
44: l_currency_flag VARCHAR2(30);
45: l_rate_based_flag VARCHAR2(1);
46: l_currency_count_for_flag NUMBER;

Line 1085: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

1081: x_msg_count := 1;
1082: x_msg_data := substr(sqlerrm,1,240);
1083: --dbms_output.put_line('error msg :'||x_msg_data);
1084: FND_MSG_PUB.add_exc_msg
1085: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
1086: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS',
1087: p_error_text => substr(sqlerrm,1,240));
1088:
1089: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1106: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.CHECK_SINGLE_CURRENCY';

1102: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1103: X_MSG_COUNT OUT NOCOPY NUMBER,
1104: X_MSG_DATA OUT NOCOPY VARCHAR2)
1105: IS
1106: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.CHECK_SINGLE_CURRENCY';
1107:
1108: l_currency_count_for_flag VARCHAR2(1);
1109:
1110: l_msg_count NUMBER;

Line 1189: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

1185: x_msg_count := 1;
1186: x_msg_data := substr(sqlerrm,1,240);
1187: --dbms_output.put_line('error msg :'||x_msg_data);
1188: FND_MSG_PUB.add_exc_msg
1189: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
1190: p_procedure_name => 'CHECK_SINGLE_CURRENCY',
1191: p_error_text => substr(sqlerrm,1,240));
1192:
1193: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1224: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_COMMITMENT_AMTS';

1220: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1221: X_MSG_COUNT OUT NOCOPY NUMBER,
1222: X_MSG_DATA OUT NOCOPY VARCHAR2)
1223: IS
1224: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_COMMITMENT_AMTS';
1225:
1226: l_currency_flag VARCHAR2(30);
1227: l_rate_based_flag VARCHAR2(1);
1228: l_currency_count_for_flag NUMBER;

Line 2295: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

2291: x_msg_count := 1;
2292: x_msg_data := substr(sqlerrm,1,240);
2293: --dbms_output.put_line('error msg :'||x_msg_data);
2294: FND_MSG_PUB.add_exc_msg
2295: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
2296: p_procedure_name => 'GEN_ETC_COMMITMENT_AMTS',
2297: p_error_text => substr(sqlerrm,1,240));
2298:
2299: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2347: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_REMAIN_BDGT_AMTS_BLK';

2343: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2344: X_MSG_COUNT OUT NOCOPY NUMBER,
2345: X_MSG_DATA OUT NOCOPY VARCHAR2)
2346: IS
2347: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_REMAIN_BDGT_AMTS_BLK';
2348:
2349: l_currency_flag VARCHAR2(30);
2350: l_rate_based_flag VARCHAR2(1);
2351: l_currency_count_for_flag NUMBER;

Line 3725: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

3721: x_msg_count := 1;
3722: x_msg_data := substr(sqlerrm,1,240);
3723: --dbms_output.put_line('error msg :'||x_msg_data);
3724: FND_MSG_PUB.add_exc_msg
3725: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
3726: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
3727: p_error_text => substr(sqlerrm,1,240));
3728:
3729: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3760: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_FROM_SRC_BDGT';

3756: X_MSG_DATA OUT NOCOPY VARCHAR2)
3757: IS
3758:
3759:
3760: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GET_ETC_FROM_SRC_BDGT';
3761: l_txn_currency_flag varchar2(1) := 'Y';
3762:
3763: -- Cursor For fully coping budget lines from source.
3764: CURSOR fcst_budget_line_src_tgt_all

Line 5153: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

5149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5150: x_msg_count := 1;
5151: x_msg_data := substr(sqlerrm,1,240);
5152: FND_MSG_PUB.add_exc_msg
5153: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
5154: p_procedure_name => 'GEN_ETC_FROM_SRC_BDGT',
5155: p_error_text => substr(sqlerrm,1,240));
5156:
5157: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5189: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.PROCESS_PA_GL_DATES';

5185: X_MSG_DATA OUT NOCOPY VARCHAR2
5186: )
5187: IS
5188: l_is_gl_greater VARCHAR2(1) := 'N';
5189: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.PROCESS_PA_GL_DATES';
5190:
5191: BEGIN
5192:
5193: -- Get PA to GL mapping periods along with their period names and dates

Line 5276: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3'

5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5273: rollback;
5274: x_msg_data := SUBSTR(SQLERRM,1,240);
5275: FND_MSG_PUB.add_exc_msg
5276: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3'
5277: ,p_procedure_name => 'PROCESS_PA_GL_DATES');
5278: IF P_PA_DEBUG_MODE = 'Y' THEN
5279: pa_fp_gen_amount_utils.fp_debug
5280: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 5289: END PA_FP_GEN_FCST_AMT_PUB3;

5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: END PROCESS_PA_GL_DATES;
5287: -- gboomina added for AAI Requirement bug 8318932 - end
5288:
5289: END PA_FP_GEN_FCST_AMT_PUB3;