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_PVT dependencies on FND_API

Line 167: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

163: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
164: BEGIN
165: --Setting initial values
166: X_MSG_COUNT := 0;
167: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
168:
169: IF p_pa_debug_mode = 'Y' THEN
170: pa_debug.set_curr_function( p_function => 'GET_TOTAL_PLAN_TXN_AMTS'
171: ,p_debug_mode => p_pa_debug_mode);

Line 864: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

860: x_proj_fp_options_rec => l_proj_fp_options_rec,
861: x_return_status => x_return_status,
862: x_msg_count => x_msg_count,
863: x_msg_data => x_msg_data);
864: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
865: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
866: END IF;
867: IF p_pa_debug_mode = 'Y' THEN
868: pa_fp_gen_amount_utils.fp_debug

Line 1032: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1028: ,x_cost_ind_compiled_set_id => l_cost_ind_compiled_set_id
1029: ,x_return_status => x_return_status
1030: ,x_msg_data => x_msg_data
1031: ,x_msg_count => x_msg_count);
1032: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1033: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1034: END IF;
1035: IF p_pa_debug_mode = 'Y' THEN
1036: pa_fp_gen_amount_utils.fp_debug

Line 1144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1140: ,p_calling_module => 'FORECAST_GENERATION'-- Added for Bug#5395732
1141: ,x_return_status => x_return_status
1142: ,x_msg_count => x_msg_count
1143: ,x_msg_data => x_msg_data);
1144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1146: END IF;
1147: IF p_pa_debug_mode = 'Y' THEN
1148: pa_fp_gen_amount_utils.fp_debug

Line 1208: x_return_status := FND_API.G_RET_STS_ERROR;

1204: END IF;
1205:
1206: EXCEPTION
1207: WHEN NO_DATA_FOUND THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: IF P_PA_DEBUG_MODE = 'Y' THEN
1210: pa_fp_gen_amount_utils.fp_debug
1211: (p_called_mode => p_calling_context,
1212: p_msg => 'Invalid Resource assignment Id',

Line 1223: ( p_encoded => FND_API.G_TRUE,

1219: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1220: l_msg_count := FND_MSG_PUB.count_msg;
1221: IF l_msg_count = 1 THEN
1222: PA_INTERFACE_UTILS_PUB.get_messages
1223: ( p_encoded => FND_API.G_TRUE,
1224: p_msg_index => 1,
1225: p_msg_count => l_msg_count,
1226: p_msg_data => l_msg_data,
1227: p_data => l_data,

Line 1236: x_return_status := FND_API.G_RET_STS_ERROR;

1232: x_msg_count := l_msg_count;
1233: END IF;
1234: ROLLBACK;
1235:
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: IF P_PA_DEBUG_MODE = 'Y' THEN
1238: pa_fp_gen_amount_utils.fp_debug
1239: (p_called_mode => p_calling_context,
1240: p_msg => 'Invalid Arguments Passed',

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244: END IF;
1245: RAISE;
1246:
1247: WHEN OTHERS THEN
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: x_msg_data := SUBSTR(SQLERRM,1,240);
1250: FND_MSG_PUB.add_exc_msg
1251: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1252: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');

Line 1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1257: p_module_name => l_module_name,
1258: p_log_level => 5);
1259: PA_DEBUG.Reset_Curr_Function;
1260: END IF;
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262:
1263: END GET_TOTAL_PLAN_TXN_AMTS;
1264:
1265: PROCEDURE UPDATE_TOTAL_PLAN_AMTS

Line 1279: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1275: l_sysdate DATE := SYSDATE;
1276: BEGIN
1277: --Setting initial values
1278: X_MSG_COUNT := 0;
1279: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1280:
1281: IF p_pa_debug_mode = 'Y' THEN
1282: pa_debug.set_curr_function( p_function => 'UPDATE_TOTAL_PLAN_AMTS'
1283: ,p_debug_mode => p_pa_debug_mode);

Line 1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1311: END IF;
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: x_msg_data := SUBSTR(SQLERRM,1,240);
1317: FND_MSG_PUB.add_exc_msg
1318: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1319: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1323: p_module_name => l_module_name,
1324: p_log_level => 5);
1325: PA_DEBUG.Reset_Curr_Function;
1326: END IF;
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END UPDATE_TOTAL_PLAN_AMTS;
1329:
1330: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1331: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 1356: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1352:
1353: BEGIN
1354: --SETTING INITIAL VALUES
1355: X_MSG_COUNT := 0;
1356: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1357:
1358: IF P_PA_DEBUG_MODE = 'Y' THEN
1359: PA_DEBUG.SET_CURR_FUNCTION( P_FUNCTION => 'GET_ACTUAL_TXN_AMOUNT'
1360: ,P_DEBUG_MODE => P_PA_DEBUG_MODE);

Line 1924: x_return_status := FND_API.G_RET_STS_ERROR;

1920: END IF;
1921:
1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN
1924: x_return_status := FND_API.G_RET_STS_ERROR;
1925: IF P_PA_DEBUG_MODE = 'Y' THEN
1926: pa_fp_gen_amount_utils.fp_debug
1927: (p_msg => 'Invalid Resource assignment Id',
1928: p_module_name => l_module_name,

Line 1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1931: END IF;
1932: RAISE;
1933:
1934: WHEN OTHERS THEN
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: x_msg_data := SUBSTR(SQLERRM,1,240);
1937: FND_MSG_PUB.add_exc_msg
1938: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1939: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');

Line 1947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1943: p_module_name => l_module_name,
1944: p_log_level => 5);
1945: PA_DEBUG.Reset_Curr_Function;
1946: END IF;
1947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1948:
1949: END GET_ACTUAL_TXN_AMOUNT;
1950:
1951: PROCEDURE GEN_AVERAGE_OF_ACTUALS

Line 2019: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2015:
2016: BEGIN
2017: --Setting initial values
2018: X_MSG_COUNT := 0;
2019: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2020:
2021: IF p_pa_debug_mode = 'Y' THEN
2022: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS'
2023: ,p_debug_mode => p_pa_debug_mode);

Line 2144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2140: X_TXN_AMT_REC => l_txn_amt_rec,
2141: X_RETURN_STATUS => X_RETURN_STATUS,
2142: X_MSG_COUNT => X_MSG_COUNT,
2143: X_MSG_DATA => X_MSG_DATA);
2144: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2146: END IF;
2147: IF p_pa_debug_mode = 'Y' THEN
2148: pa_fp_gen_amount_utils.fp_debug

Line 2287: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2283: P_TXN_AMT_TYPE_CODE => 'PLANNING_TXN',
2284: X_RETURN_STATUS => X_RETURN_STATUS,
2285: X_MSG_COUNT => X_MSG_COUNT,
2286: X_MSG_DATA => X_MSG_DATA);
2287: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2288: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2289: END IF;
2290: IF p_pa_debug_mode = 'Y' THEN
2291: pa_fp_gen_amount_utils.fp_debug

Line 2308: ( p_encoded => FND_API.G_TRUE,

2304: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2305: l_msg_count := FND_MSG_PUB.count_msg;
2306: IF l_msg_count = 1 THEN
2307: PA_INTERFACE_UTILS_PUB.get_messages
2308: ( p_encoded => FND_API.G_TRUE,
2309: p_msg_index => 1,
2310: p_msg_count => l_msg_count,
2311: p_msg_data => l_msg_data,
2312: p_data => l_data,

Line 2321: x_return_status := FND_API.G_RET_STS_ERROR;

2317: x_msg_count := l_msg_count;
2318: END IF;
2319: ROLLBACK;
2320:
2321: x_return_status := FND_API.G_RET_STS_ERROR;
2322: IF P_PA_DEBUG_MODE = 'Y' THEN
2323: pa_fp_gen_amount_utils.fp_debug
2324: (p_msg => 'Invalid Arguments Passed',
2325: p_module_name => l_module_name,

Line 2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2327: PA_DEBUG.Reset_Curr_Function;
2328: END IF;
2329: RAISE;
2330: WHEN OTHERS THEN
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: x_msg_data := SUBSTR(SQLERRM,1,240);
2333: FND_MSG_PUB.add_exc_msg
2334: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2335: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');

Line 2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2339: p_module_name => l_module_name,
2340: p_log_level => 5);
2341: PA_DEBUG.Reset_Curr_Function;
2342: END IF;
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344:
2345: END GEN_AVERAGE_OF_ACTUALS;
2346:
2347: /**The following API is to address bug 4145383.

Line 2385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2381: IF p_pa_debug_mode = 'Y' THEN
2382: pa_debug.set_curr_function( p_function => 'UPD_TGT_RATE_BASED_FLAG',
2383: p_debug_mode => p_pa_debug_mode);
2384: END IF;
2385: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2386:
2387: -- Bug 4170419 : Start
2388: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2389: -- DISTINCT target_res_asg_id

Line 2528: (p_encoded => FND_API.G_TRUE

2524: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2525: l_msg_count := FND_MSG_PUB.count_msg;
2526: IF l_msg_count = 1 THEN
2527: PA_INTERFACE_UTILS_PUB.get_messages
2528: (p_encoded => FND_API.G_TRUE
2529: ,p_msg_index => 1
2530: ,p_msg_count => l_msg_count
2531: ,p_msg_data => l_msg_data
2532: ,p_data => l_data

Line 2541: x_return_status := FND_API.G_RET_STS_ERROR;

2537: x_msg_count := l_msg_count;
2538: END IF;
2539: ROLLBACK;
2540:
2541: x_return_status := FND_API.G_RET_STS_ERROR;
2542: IF P_PA_DEBUG_MODE = 'Y' THEN
2543: pa_debug.write_log(
2544: x_module => l_module_name,
2545: x_msg => 'Invalid Arguments Passed',

Line 2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2548: END IF;
2549: RAISE;
2550:
2551: WHEN OTHERS THEN
2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2553: x_msg_data := SUBSTR(SQLERRM,1,240);
2554: FND_MSG_PUB.add_exc_msg
2555: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2556: ,p_procedure_name => 'UPD_TGT_RATE_BASED_FLAG');

Line 2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2560: x_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2561: x_log_level => 5);
2562: PA_DEBUG.Reset_Curr_Function;
2563: END IF;
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END UPD_TGT_RATE_BASED_FLAG;
2566:
2567: END PA_FP_GEN_FCST_AMT_PVT;