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 169: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

Line 877: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

873: x_proj_fp_options_rec => l_proj_fp_options_rec,
874: x_return_status => x_return_status,
875: x_msg_count => x_msg_count,
876: x_msg_data => x_msg_data);
877: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
878: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
879: END IF;
880: IF p_pa_debug_mode = 'Y' THEN
881: pa_fp_gen_amount_utils.fp_debug

Line 1045: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1041: ,x_cost_ind_compiled_set_id => l_cost_ind_compiled_set_id
1042: ,x_return_status => x_return_status
1043: ,x_msg_data => x_msg_data
1044: ,x_msg_count => x_msg_count);
1045: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1046: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1047: END IF;
1048: IF p_pa_debug_mode = 'Y' THEN
1049: pa_fp_gen_amount_utils.fp_debug

Line 1157: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1153: ,p_calling_module => 'FORECAST_GENERATION'-- Added for Bug#5395732
1154: ,x_return_status => x_return_status
1155: ,x_msg_count => x_msg_count
1156: ,x_msg_data => x_msg_data);
1157: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1158: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1159: END IF;
1160: IF p_pa_debug_mode = 'Y' THEN
1161: pa_fp_gen_amount_utils.fp_debug

Line 1221: x_return_status := FND_API.G_RET_STS_ERROR;

1217: END IF;
1218:
1219: EXCEPTION
1220: WHEN NO_DATA_FOUND THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: IF P_PA_DEBUG_MODE = 'Y' THEN
1223: pa_fp_gen_amount_utils.fp_debug
1224: (p_called_mode => p_calling_context,
1225: p_msg => 'Invalid Resource assignment Id',

Line 1236: ( p_encoded => FND_API.G_TRUE,

1232: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1233: l_msg_count := FND_MSG_PUB.count_msg;
1234: IF l_msg_count = 1 THEN
1235: PA_INTERFACE_UTILS_PUB.get_messages
1236: ( p_encoded => FND_API.G_TRUE,
1237: p_msg_index => 1,
1238: p_msg_count => l_msg_count,
1239: p_msg_data => l_msg_data,
1240: p_data => l_data,

Line 1249: x_return_status := FND_API.G_RET_STS_ERROR;

1245: x_msg_count := l_msg_count;
1246: END IF;
1247: ROLLBACK;
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: IF P_PA_DEBUG_MODE = 'Y' THEN
1251: pa_fp_gen_amount_utils.fp_debug
1252: (p_called_mode => p_calling_context,
1253: p_msg => 'Invalid Arguments Passed',

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1257: END IF;
1258: RAISE;
1259:
1260: WHEN OTHERS THEN
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: x_msg_data := SUBSTR(SQLERRM,1,240);
1263: FND_MSG_PUB.add_exc_msg
1264: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1265: ,p_procedure_name => 'GET_TOTAL_PLAN_TXN_AMTS');

Line 1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1270: p_module_name => l_module_name,
1271: p_log_level => 5);
1272: PA_DEBUG.Reset_Curr_Function;
1273: END IF;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275:
1276: END GET_TOTAL_PLAN_TXN_AMTS;
1277:
1278: PROCEDURE UPDATE_TOTAL_PLAN_AMTS

Line 1292: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1288: l_sysdate DATE := SYSDATE;
1289: BEGIN
1290: --Setting initial values
1291: X_MSG_COUNT := 0;
1292: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1293:
1294: IF p_pa_debug_mode = 'Y' THEN
1295: pa_debug.set_curr_function( p_function => 'UPDATE_TOTAL_PLAN_AMTS'
1296: ,p_debug_mode => p_pa_debug_mode);

Line 1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1324: END IF;
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: x_msg_data := SUBSTR(SQLERRM,1,240);
1330: FND_MSG_PUB.add_exc_msg
1331: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1332: ,p_procedure_name => 'UPDATE_TOTAL_PLAN_AMTS');

Line 1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1336: p_module_name => l_module_name,
1337: p_log_level => 5);
1338: PA_DEBUG.Reset_Curr_Function;
1339: END IF;
1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END UPDATE_TOTAL_PLAN_AMTS;
1342:
1343: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1344: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 1370: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1366:
1367: BEGIN
1368: --SETTING INITIAL VALUES
1369: X_MSG_COUNT := 0;
1370: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1371:
1372: IF P_PA_DEBUG_MODE = 'Y' THEN
1373: PA_DEBUG.SET_CURR_FUNCTION( P_FUNCTION => 'GET_ACTUAL_TXN_AMOUNT'
1374: ,P_DEBUG_MODE => P_PA_DEBUG_MODE);

Line 1954: x_return_status := FND_API.G_RET_STS_ERROR;

1950: END IF;
1951:
1952: EXCEPTION
1953: WHEN NO_DATA_FOUND THEN
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: IF P_PA_DEBUG_MODE = 'Y' THEN
1956: pa_fp_gen_amount_utils.fp_debug
1957: (p_msg => 'Invalid Resource assignment Id',
1958: p_module_name => l_module_name,

Line 1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1961: END IF;
1962: RAISE;
1963:
1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: x_msg_data := SUBSTR(SQLERRM,1,240);
1967: FND_MSG_PUB.add_exc_msg
1968: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
1969: ,p_procedure_name => 'GET_ACTUAL_TXN_AMOUNT');

Line 1977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1973: p_module_name => l_module_name,
1974: p_log_level => 5);
1975: PA_DEBUG.Reset_Curr_Function;
1976: END IF;
1977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1978:
1979: END GET_ACTUAL_TXN_AMOUNT;
1980:
1981: PROCEDURE GEN_AVERAGE_OF_ACTUALS

Line 2050: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2046:
2047: BEGIN
2048: --Setting initial values
2049: X_MSG_COUNT := 0;
2050: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2051:
2052: IF p_pa_debug_mode = 'Y' THEN
2053: pa_debug.set_curr_function( p_function => 'GEN_AVERAGE_OF_ACTUALS'
2054: ,p_debug_mode => p_pa_debug_mode);

Line 2177: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2173: X_TXN_AMT_REC => l_txn_amt_rec,
2174: X_RETURN_STATUS => X_RETURN_STATUS,
2175: X_MSG_COUNT => X_MSG_COUNT,
2176: X_MSG_DATA => X_MSG_DATA);
2177: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2178: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2179: END IF;
2180: IF p_pa_debug_mode = 'Y' THEN
2181: pa_fp_gen_amount_utils.fp_debug

Line 2320: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2316: P_TXN_AMT_TYPE_CODE => 'PLANNING_TXN',
2317: X_RETURN_STATUS => X_RETURN_STATUS,
2318: X_MSG_COUNT => X_MSG_COUNT,
2319: X_MSG_DATA => X_MSG_DATA);
2320: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2322: END IF;
2323: IF p_pa_debug_mode = 'Y' THEN
2324: pa_fp_gen_amount_utils.fp_debug

Line 2341: ( p_encoded => FND_API.G_TRUE,

2337: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2338: l_msg_count := FND_MSG_PUB.count_msg;
2339: IF l_msg_count = 1 THEN
2340: PA_INTERFACE_UTILS_PUB.get_messages
2341: ( p_encoded => FND_API.G_TRUE,
2342: p_msg_index => 1,
2343: p_msg_count => l_msg_count,
2344: p_msg_data => l_msg_data,
2345: p_data => l_data,

Line 2354: x_return_status := FND_API.G_RET_STS_ERROR;

2350: x_msg_count := l_msg_count;
2351: END IF;
2352: ROLLBACK;
2353:
2354: x_return_status := FND_API.G_RET_STS_ERROR;
2355: IF P_PA_DEBUG_MODE = 'Y' THEN
2356: pa_fp_gen_amount_utils.fp_debug
2357: (p_msg => 'Invalid Arguments Passed',
2358: p_module_name => l_module_name,

Line 2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2360: PA_DEBUG.Reset_Curr_Function;
2361: END IF;
2362: RAISE;
2363: WHEN OTHERS THEN
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: x_msg_data := SUBSTR(SQLERRM,1,240);
2366: FND_MSG_PUB.add_exc_msg
2367: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2368: ,p_procedure_name => 'GEN_AVERAGE_OF_ACTUALS');

Line 2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2372: p_module_name => l_module_name,
2373: p_log_level => 5);
2374: PA_DEBUG.Reset_Curr_Function;
2375: END IF;
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377:
2378: END GEN_AVERAGE_OF_ACTUALS;
2379:
2380: /**The following API is to address bug 4145383.

Line 2418: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2414: IF p_pa_debug_mode = 'Y' THEN
2415: pa_debug.set_curr_function( p_function => 'UPD_TGT_RATE_BASED_FLAG',
2416: p_debug_mode => p_pa_debug_mode);
2417: END IF;
2418: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2419:
2420: -- Bug 4170419 : Start
2421: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2422: -- DISTINCT target_res_asg_id

Line 2561: (p_encoded => FND_API.G_TRUE

2557: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2558: l_msg_count := FND_MSG_PUB.count_msg;
2559: IF l_msg_count = 1 THEN
2560: PA_INTERFACE_UTILS_PUB.get_messages
2561: (p_encoded => FND_API.G_TRUE
2562: ,p_msg_index => 1
2563: ,p_msg_count => l_msg_count
2564: ,p_msg_data => l_msg_data
2565: ,p_data => l_data

Line 2574: x_return_status := FND_API.G_RET_STS_ERROR;

2570: x_msg_count := l_msg_count;
2571: END IF;
2572: ROLLBACK;
2573:
2574: x_return_status := FND_API.G_RET_STS_ERROR;
2575: IF P_PA_DEBUG_MODE = 'Y' THEN
2576: pa_debug.write_log(
2577: x_module => l_module_name,
2578: x_msg => 'Invalid Arguments Passed',

Line 2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2581: END IF;
2582: RAISE;
2583:
2584: WHEN OTHERS THEN
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2586: x_msg_data := SUBSTR(SQLERRM,1,240);
2587: FND_MSG_PUB.add_exc_msg
2588: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PVT'
2589: ,p_procedure_name => 'UPD_TGT_RATE_BASED_FLAG');

Line 2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2593: x_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
2594: x_log_level => 5);
2595: PA_DEBUG.Reset_Curr_Function;
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END UPD_TGT_RATE_BASED_FLAG;
2599:
2600: END PA_FP_GEN_FCST_AMT_PVT;