DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on FND_API

Line 166: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

162: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS',
163: p_debug_mode => p_pa_debug_mode);
164: END IF;
165:
166: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
167: X_MSG_COUNT := 0;
168:
169: /*Currency usage should be determined at the beginning.
170: Default to use Transaction Currency (TC)

Line 306: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

302: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
303: p_module_name => l_module_name,
304: p_log_level => 5);
305: END IF;
306: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
307: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
308: END IF;
309:
310: IF l_rate_based_flag = 'Y' THEN

Line 541: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

537: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
538: p_module_name => l_module_name,
539: p_log_level => 5);
540: END IF;
541: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
542: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
543: END IF;
544:
545: l_act_currency_code_tab(1) := lx_act_txn_currency_code;

Line 835: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

831: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
832: p_module_name => l_module_name,
833: p_log_level => 5);
834: END IF;
835: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
836: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
837: END IF;
838:
839: l_act_quantity_pc_sum := lx_act_pc_raw_cost;

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: P_stage => x_msg_count);
920:
921:
922: IF lx_project_exch_rate IS NULL OR l_status IS NOT NULL THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: g_project_name := NULL;
925: BEGIN
926: SELECT name INTO g_project_name from
927: PA_PROJECTS_ALL WHERE

Line 951: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

947: 'get_currency_amounts in remain_bdgt:'||x_return_status,
948: p_module_name => l_module_name,
949: p_log_level => 5);
950: END IF;
951: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
952: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
953: END IF;
954: END IF;
955: END LOOP;

Line 1055: ( p_encoded => FND_API.G_TRUE,

1051: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1052: l_msg_count := FND_MSG_PUB.count_msg;
1053: IF l_msg_count = 1 THEN
1054: PA_INTERFACE_UTILS_PUB.get_messages
1055: ( p_encoded => FND_API.G_TRUE,
1056: p_msg_index => 1,
1057: p_msg_count => l_msg_count,
1058: p_msg_data => l_msg_data,
1059: p_data => l_data,

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064: x_msg_count := l_msg_count;
1065: END IF;
1066:
1067: ROLLBACK;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069:
1070: IF P_PA_DEBUG_MODE = 'Y' THEN
1071: pa_fp_gen_amount_utils.fp_debug
1072: (p_msg => 'Invalid Arguments Passed',

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1076: END IF;
1077: RAISE;
1078: WHEN OTHERS THEN
1079: rollback;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: p_module_name => l_module_name,
1093: p_log_level => 5);
1094: PA_DEBUG.RESET_CURR_FUNCTION;
1095: END IF;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END GET_ETC_REMAIN_BDGT_AMTS;
1098:
1099: PROCEDURE CHECK_SINGLE_CURRENCY
1100: (P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

Line 1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1117: pa_debug.set_curr_function( p_function => 'CHECK_SINGLE_CURRENCY',
1118: p_debug_mode => p_pa_debug_mode);
1119: END IF;
1120:
1121: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1122: X_MSG_COUNT := 0;
1123:
1124: IF P_PA_DEBUG_MODE = 'Y' THEN
1125: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1159: ( p_encoded => FND_API.G_TRUE,

1155: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1156: l_msg_count := FND_MSG_PUB.count_msg;
1157: IF l_msg_count = 1 THEN
1158: PA_INTERFACE_UTILS_PUB.get_messages
1159: ( p_encoded => FND_API.G_TRUE,
1160: p_msg_index => 1,
1161: p_msg_count => l_msg_count,
1162: p_msg_data => l_msg_data,
1163: p_data => l_data,

Line 1172: x_return_status := FND_API.G_RET_STS_ERROR;

1168: x_msg_count := l_msg_count;
1169: END IF;
1170:
1171: ROLLBACK;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173:
1174: IF P_PA_DEBUG_MODE = 'Y' THEN
1175: pa_fp_gen_amount_utils.fp_debug
1176: (p_msg => 'Invalid Arguments Passed',

Line 1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: END IF;
1181: RAISE;
1182: WHEN OTHERS THEN
1183: rollback;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1196: p_module_name => l_module_name,
1197: p_log_level => 5);
1198: PA_DEBUG.RESET_CURR_FUNCTION;
1199: END IF;
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1201: END CHECK_SINGLE_CURRENCY;
1202:
1203:
1204: /* Assumption:

Line 1421: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1417: pa_debug.set_curr_function( p_function => 'GET_ETC_COMMITMENT_AMTS',
1418: p_debug_mode => p_pa_debug_mode);
1419: END IF;
1420:
1421: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1422: X_MSG_COUNT := 0;
1423:
1424: /* Map the total ETC data from source resource assignments to
1425: target resource assignments */

Line 2160: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2156: 'get_currency_amounts in remain_bdgt:'||x_return_status,
2157: p_module_name => l_module_name,
2158: p_log_level => 5);
2159: END IF;
2160: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2161: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2162: END IF;
2163: END IF;
2164:

Line 2265: ( p_encoded => FND_API.G_TRUE,

2261: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2262: l_msg_count := FND_MSG_PUB.count_msg;
2263: IF l_msg_count = 1 THEN
2264: PA_INTERFACE_UTILS_PUB.get_messages
2265: ( p_encoded => FND_API.G_TRUE,
2266: p_msg_index => 1,
2267: p_msg_count => l_msg_count,
2268: p_msg_data => l_msg_data,
2269: p_data => l_data,

Line 2278: x_return_status := FND_API.G_RET_STS_ERROR;

2274: x_msg_count := l_msg_count;
2275: END IF;
2276:
2277: ROLLBACK;
2278: x_return_status := FND_API.G_RET_STS_ERROR;
2279:
2280: IF P_PA_DEBUG_MODE = 'Y' THEN
2281: pa_fp_gen_amount_utils.fp_debug
2282: (p_msg => 'Invalid Arguments Passed',

Line 2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2286: END IF;
2287: RAISE;
2288: WHEN OTHERS THEN
2289: rollback;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2302: p_module_name => l_module_name,
2303: p_log_level => 5);
2304: PA_DEBUG.RESET_CURR_FUNCTION;
2305: END IF;
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2307: END GET_ETC_COMMITMENT_AMTS;
2308:
2309:
2310: /* Assumption:

Line 2512: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2508: pa_debug.set_curr_function( p_function => 'GEN_ETC_REMAIN_BDGT_AMTS_BLK',
2509: p_debug_mode => p_pa_debug_mode);
2510: END IF;
2511:
2512: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2513: X_MSG_COUNT := 0;
2514:
2515: FOR main_loop IN 1..p_src_res_asg_id_tab.count LOOP
2516: BEGIN

Line 2726: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2722: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
2723: p_module_name => l_module_name,
2724: p_log_level => 5);
2725: END IF;
2726: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2727: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2728: END IF;
2729:
2730: IF l_rate_based_flag = 'Y' THEN

Line 3015: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3011: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3012: p_module_name => l_module_name,
3013: p_log_level => 5);
3014: END IF;
3015: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3016: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3017: END IF;
3018:
3019: l_act_currency_code_tab(1) := lx_act_txn_currency_code;

Line 3381: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3377: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3378: p_module_name => l_module_name,
3379: p_log_level => 5);
3380: END IF;
3381: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3382: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3383: END IF;
3384:
3385: l_act_quantity_pc_sum := lx_act_pc_raw_cost;

Line 3482: x_return_status := FND_API.G_RET_STS_ERROR;

3478: P_stage => x_msg_count);
3479:
3480:
3481: IF lx_project_exch_rate IS NULL OR l_status IS NOT NULL THEN
3482: x_return_status := FND_API.G_RET_STS_ERROR;
3483: g_project_name := NULL;
3484: BEGIN
3485: SELECT name INTO g_project_name from
3486: PA_PROJECTS_ALL WHERE

Line 3510: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3506: 'get_currency_amounts in remain_bdgt:'||x_return_status,
3507: p_module_name => l_module_name,
3508: p_log_level => 5);
3509: END IF;
3510: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3511: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3512: END IF;
3513: END IF;
3514: END LOOP;

Line 3681: ( p_encoded => FND_API.G_TRUE,

3677: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3678: l_msg_count := FND_MSG_PUB.count_msg;
3679: IF l_msg_count = 1 THEN
3680: PA_INTERFACE_UTILS_PUB.get_messages
3681: ( p_encoded => FND_API.G_TRUE,
3682: p_msg_index => 1,
3683: p_msg_count => l_msg_count,
3684: p_msg_data => l_msg_data,
3685: p_data => l_data,

Line 3694: x_return_status := FND_API.G_RET_STS_ERROR;

3690: x_msg_count := l_msg_count;
3691: END IF;
3692:
3693: ROLLBACK;
3694: x_return_status := FND_API.G_RET_STS_ERROR;
3695:
3696: IF P_PA_DEBUG_MODE = 'Y' THEN
3697: pa_fp_gen_amount_utils.fp_debug
3698: (p_msg => 'Invalid Arguments Passed',

Line 3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3702: END IF;
3703: RAISE;
3704: WHEN OTHERS THEN
3705: rollback;
3706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3718: p_module_name => l_module_name,
3719: p_log_level => 5);
3720: PA_DEBUG.RESET_CURR_FUNCTION;
3721: END IF;
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;