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

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

Line 2731: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2727: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
2728: p_module_name => l_module_name,
2729: p_log_level => 5);
2730: END IF;
2731: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2732: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2733: END IF;
2734:
2735: IF l_rate_based_flag = 'Y' THEN

Line 3021: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3017: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3018: p_module_name => l_module_name,
3019: p_log_level => 5);
3020: END IF;
3021: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3022: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3023: END IF;
3024:
3025: l_act_currency_code_tab(1) := lx_act_txn_currency_code;

Line 3395: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3391: 'GET_WP_ACTUALS_FOR_RA in remain_bdgt:'||x_return_status,
3392: p_module_name => l_module_name,
3393: p_log_level => 5);
3394: END IF;
3395: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3396: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3397: END IF;
3398:
3399: l_act_quantity_pc_sum := lx_act_pc_raw_cost;

Line 3496: x_return_status := FND_API.G_RET_STS_ERROR;

3492: P_stage => x_msg_count);
3493:
3494:
3495: IF lx_project_exch_rate IS NULL OR l_status IS NOT NULL THEN
3496: x_return_status := FND_API.G_RET_STS_ERROR;
3497: g_project_name := NULL;
3498: BEGIN
3499: SELECT name INTO g_project_name from
3500: PA_PROJECTS_ALL WHERE

Line 3524: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3520: 'get_currency_amounts in remain_bdgt:'||x_return_status,
3521: p_module_name => l_module_name,
3522: p_log_level => 5);
3523: END IF;
3524: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3525: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3526: END IF;
3527: END IF;
3528: END LOOP;

Line 3695: ( p_encoded => FND_API.G_TRUE,

3691: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3692: l_msg_count := FND_MSG_PUB.count_msg;
3693: IF l_msg_count = 1 THEN
3694: PA_INTERFACE_UTILS_PUB.get_messages
3695: ( p_encoded => FND_API.G_TRUE,
3696: p_msg_index => 1,
3697: p_msg_count => l_msg_count,
3698: p_msg_data => l_msg_data,
3699: p_data => l_data,

Line 3708: x_return_status := FND_API.G_RET_STS_ERROR;

3704: x_msg_count := l_msg_count;
3705: END IF;
3706:
3707: ROLLBACK;
3708: x_return_status := FND_API.G_RET_STS_ERROR;
3709:
3710: IF P_PA_DEBUG_MODE = 'Y' THEN
3711: pa_fp_gen_amount_utils.fp_debug
3712: (p_msg => 'Invalid Arguments Passed',

Line 3720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3716: END IF;
3717: RAISE;
3718: WHEN OTHERS THEN
3719: rollback;
3720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3732: p_module_name => l_module_name,
3733: p_log_level => 5);
3734: PA_DEBUG.RESET_CURR_FUNCTION;
3735: END IF;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END GET_ETC_REMAIN_BDGT_AMTS_BLK;
3738:
3739: -- gboomina added for AAI Requirement bug 8318932 - start
3740: /* AAI Enhancement

Line 4248: x_return_status := FND_API.G_RET_STS_SUCCESS;

4244: pa_debug.set_curr_function( p_function => 'GET_ETC_FROM_SRC_BDGT',
4245: p_debug_mode => p_pa_debug_mode);
4246: END IF;
4247:
4248: x_return_status := FND_API.G_RET_STS_SUCCESS;
4249: x_msg_count := 0;
4250:
4251: IF P_FP_COLS_SRC_FP_REC.X_TIME_PHASED_CODE = P_FP_COLS_TGT_REC.X_TIME_PHASED_CODE AND
4252: P_FP_COLS_SRC_WP_REC.X_TIME_PHASED_CODE = P_FP_COLS_TGT_REC.X_TIME_PHASED_CODE THEN

Line 5074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5070: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
5071: 'MAINTAIN_DATA: '||x_return_status,
5072: P_MODULE_NAME => l_module_name);
5073: END IF;
5074: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5075: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5076: END IF;
5077:
5078: -- Bug 8346446 AAI QA

Line 5123: ( p_encoded => FND_API.G_TRUE,

5119: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5120: l_msg_count := FND_MSG_PUB.count_msg;
5121: IF l_msg_count = 1 THEN
5122: PA_INTERFACE_UTILS_PUB.get_messages
5123: ( p_encoded => FND_API.G_TRUE,
5124: p_msg_index => 1,
5125: p_msg_count => l_msg_count,
5126: p_msg_data => l_msg_data,
5127: p_data => l_data,

Line 5137: x_return_status := FND_API.G_RET_STS_ERROR;

5133: END IF;
5134:
5135: ROLLBACK;
5136:
5137: x_return_status := FND_API.G_RET_STS_ERROR;
5138: IF P_PA_DEBUG_MODE = 'Y' THEN
5139: pa_fp_gen_amount_utils.fp_debug
5140: ( p_msg => 'Invalid Arguments Passed',
5141: p_module_name => l_module_name,

Line 5149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5145: RAISE;
5146:
5147: WHEN OTHERS then
5148: ROLLBACK;
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',

Line 5164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5160: p_module_name => l_module_name,
5161: p_log_level => 5);
5162: PA_DEBUG.RESET_CURR_FUNCTION;
5163: END IF;
5164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5165: END GET_ETC_FROM_SRC_BDGT;
5166:
5167:
5168: -- skkoppul added for AAI Requirement - start

Line 5272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5268: END IF;
5269:
5270: EXCEPTION
5271: WHEN OTHERS THEN
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'

Line 5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5281: p_module_name => l_module_name,
5282: p_log_level => 5);
5283: PA_DEBUG.Reset_Curr_Function;
5284: END IF;
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;