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.7 2007/02/06 09:51:34 dthakker 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 2346: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB3.GEN_ETC_REMAIN_BDGT_AMTS_BLK';

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

Line 3711: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',

3707: x_msg_count := 1;
3708: x_msg_data := substr(sqlerrm,1,240);
3709: --dbms_output.put_line('error msg :'||x_msg_data);
3710: FND_MSG_PUB.add_exc_msg
3711: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB3',
3712: p_procedure_name => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
3713: p_error_text => substr(sqlerrm,1,240));
3714:
3715: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3726: END PA_FP_GEN_FCST_AMT_PUB3;

3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: END GET_ETC_REMAIN_BDGT_AMTS_BLK;
3724:
3725:
3726: END PA_FP_GEN_FCST_AMT_PUB3;