DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on FND_API

Line 414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

410: p_module_name => l_module_name,
411: p_log_level => 5);
412: END IF;
413:
414: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
415: IF p_pa_debug_mode = 'Y' THEN
416: pa_fp_gen_amount_utils.fp_debug
417: (p_called_mode => l_called_mode,
418: p_msg =>'Raising invalid arg exc after create version api call',

Line 425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

421: END IF;
422: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
423: END IF;
424:
425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
426: l_generation_flag := 'N';
427: l_msg_count := FND_MSG_PUB.Count_Msg;
428: IF p_pa_debug_mode = 'Y' THEN
429: pa_fp_gen_amount_utils.fp_debug

Line 446: (p_encoded => FND_API.G_FALSE,

442: IF l_msg_count > 0 THEN
443: IF l_msg_count = 1 THEN
444: l_msg_data_in := l_msg_data;
445: PA_INTERFACE_UTILS_PUB.get_messages
446: (p_encoded => FND_API.G_FALSE,
447: p_msg_index => 1,
448: p_msg_count => 1,
449: p_msg_data => l_msg_data_in,
450: p_data => l_msg_data,

Line 465: (p_encoded => FND_API.G_FALSE,

461: FOR j in 1 .. l_msg_count LOOP
462: --dbms_output.put_line('inside the error loop ');
463: l_msg_data_in := l_msg_data;
464: pa_interface_utils_pub.get_messages
465: (p_encoded => FND_API.G_FALSE,
466: p_msg_index => j,
467: p_msg_count => l_msg_count ,
468: p_msg_data => l_msg_data_in ,
469: p_data => l_msg_data,

Line 520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

516: p_module_name => l_module_name,
517: p_log_level => 5);
518: END IF;
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: IF p_pa_debug_mode = 'Y' THEN
522: pa_fp_gen_amount_utils.fp_debug
523: (p_called_mode => l_called_mode,
524: p_msg =>'Raising invalid arg exc after Get Plan ver dtls api call',

Line 530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

526: p_log_level => 5);
527: END IF;
528: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
529: END IF;
530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
531: l_gen_api_call_flag := 'N';
532: END IF;
533:
534: l_unspent_amt_period :=

Line 710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

706: p_log_level => 5);
707: END IF;
708:
709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: IF p_pa_debug_mode = 'Y' THEN
712: pa_fp_gen_amount_utils.fp_debug
713: (p_called_mode => l_called_mode,
714: p_msg=>'Raising invalid arg exc aft Get Curr Original ver api call',

Line 720: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

716: p_log_level => 5);
717: END IF;
718: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
719: END IF;
720: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
721: l_gen_api_call_flag := 'N';
722: END IF;
723:
724:

Line 753: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

749: p_module_name => l_module_name,
750: p_log_level => 5);
751: END IF;
752:
753: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: IF p_pa_debug_mode = 'Y' THEN
755: pa_fp_gen_amount_utils.fp_debug
756: (p_called_mode => l_called_mode,
757: p_msg=>'Raising invalid arg exc aft Get Curr Wkg ver api call',

Line 763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

759: p_log_level => 5);
760: END IF;
761: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
762: END IF;
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: l_gen_api_call_flag := 'N';
765: END IF;
766: END IF;
767:

Line 937: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

933: ||l_return_status,
934: p_module_name => l_module_name,
935: p_log_level => 5 );
936: END IF;
937: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
938: IF p_pa_debug_mode = 'Y' THEN
939: pa_fp_gen_amount_utils.fp_debug
940: (p_called_mode => l_called_mode,
941: p_msg=>'Raising invalid arg exc aft validation api call',

Line 947: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

943: p_log_level => 5);
944: END IF;
945: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
946: END IF;
947: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
948: l_gen_api_call_flag := 'N';
949: END IF;
950: PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP
951: (P_PROJECT_ID => l_proj_id,

Line 992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

988: END IF;
989: -- hr_utility.trace('l_return_status after GENERATE_FCST_AMT_WRP '||l_return_status);
990: -- hr_utility.trace('l_version_generation GENERATE_FCST_AMT_WRP '||l_generation_flag);
991:
992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: IF p_pa_debug_mode = 'Y' THEN
994: pa_fp_gen_amount_utils.fp_debug
995: (p_called_mode => l_called_mode,
996: p_msg=>'Raising invalid arg exc aft Fcst Gen api call',

Line 1002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

998: p_log_level => 5);
999: END IF;
1000: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1001: END IF;
1002: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: -- hr_utility.trace('EXCEPTION ERROR FROM GENERATE_FCST_AMT_WRP');
1004: l_gen_api_call_flag := 'N';
1005: END IF;
1006: EXCEPTION

Line 1011: l_return_status := FND_API.G_RET_STS_ERROR;

1007: /*xxxxx*/
1008: WHEN OTHERS THEN
1009: -- hr_utility.trace('Inside Forecast Gen others Ex');
1010: rollback;
1011: l_return_status := FND_API.G_RET_STS_ERROR;
1012: l_msg_count := 1;
1013: l_msg_data := substr(sqlerrm,1,240);
1014: --dbms_output.put_line('error msg :'||x_msg_data);
1015: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1067: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);

1063: -- dbms_output.put_line('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1064: -- hr_utility.trace('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1065: -- dbms_output.put_line('after budget generation l_proj_id: '||l_proj_id);
1066: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1067: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1068: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1069: IF p_pa_debug_mode = 'Y' THEN
1070: pa_fp_gen_amount_utils.fp_debug
1071: (p_called_mode => l_called_mode,

Line 1068: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);

1064: -- hr_utility.trace('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1065: -- dbms_output.put_line('after budget generation l_proj_id: '||l_proj_id);
1066: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1067: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1068: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1069: IF p_pa_debug_mode = 'Y' THEN
1070: pa_fp_gen_amount_utils.fp_debug
1071: (p_called_mode => l_called_mode,
1072: p_msg => 'Status after calling

Line 1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1074: ||l_return_status,
1075: p_module_name => l_module_name,
1076: p_log_level => 5);
1077: END IF;
1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1079: IF p_pa_debug_mode = 'Y' THEN
1080: pa_fp_gen_amount_utils.fp_debug
1081: (p_called_mode => l_called_mode,
1082: p_msg=>'Raising invalid arg exc aft Bdgt Gen api call',

Line 1089: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1085: END IF;
1086: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1087: END IF;
1088: /*xxxxxx*/
1089: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: -- hr_utility.trace('EXCEPTION ERROR FROM GENERATE_BUDGET_AMT_WRP');
1091: l_gen_api_call_flag := 'N';
1092: END IF;
1093: EXCEPTION

Line 1097: l_return_status := FND_API.G_RET_STS_ERROR;

1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: -- hr_utility.trace('Inside others Ex');
1096: rollback;
1097: l_return_status := FND_API.G_RET_STS_ERROR;
1098: l_msg_count := 1;
1099: l_msg_data := substr(sqlerrm,1,240);
1100: --dbms_output.put_line('error msg :'||x_msg_data);
1101: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1110:
1111:
1112: END IF;--For IF condition for BUDGET
1113:
1114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: -- hr_utility.trace('INVALID EXCEPTION!!!');
1116: IF p_pa_debug_mode = 'Y' THEN
1117: pa_fp_gen_amount_utils.fp_debug
1118: (p_called_mode => l_called_mode,

Line 1125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1121: p_log_level => 5);
1122: END IF;
1123: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1124: END IF;
1125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1126: l_gen_api_call_flag := 'N';
1127: END IF;
1128:
1129: IF l_gen_api_call_flag = 'N' THEN

Line 1149: (p_encoded => FND_API.G_FALSE,

1145: p_write_mode => 1);
1146: IF l_msg_count = 1 THEN
1147: l_msg_data_in := l_msg_data;
1148: PA_INTERFACE_UTILS_PUB.get_messages
1149: (p_encoded => FND_API.G_FALSE,
1150: p_msg_index => 1,
1151: p_msg_count => 1,
1152: p_msg_data => l_msg_data_in ,
1153: p_data => l_msg_data,

Line 1168: (p_encoded => FND_API.G_FALSE,

1164: FOR j in 1 .. l_msg_count LOOP
1165: --dbms_output.put_line('inside the error loop ');
1166: l_msg_data_in := l_msg_data;
1167: pa_interface_utils_pub.get_messages
1168: (p_encoded => FND_API.G_FALSE,
1169: p_msg_index => j,
1170: p_msg_count => l_msg_count ,
1171: p_msg_data => l_msg_data_in ,
1172: p_data => l_msg_data,

Line 1200: ( p_encoded => FND_API.G_TRUE,

1196: -- hr_utility.trace('Inside invalid arg Ex');
1197: l_msg_count := FND_MSG_PUB.count_msg;
1198: IF l_msg_count = 1 THEN
1199: PA_INTERFACE_UTILS_PUB.get_messages
1200: ( p_encoded => FND_API.G_TRUE,
1201: p_msg_index => 1,
1202: p_msg_count => l_msg_count,
1203: p_msg_data => l_msg_data,
1204: p_data => l_data,

Line 1213: l_return_status := FND_API.G_RET_STS_ERROR;

1209: ROLLBACK;
1210:
1211: -- hr_utility.trace('Outside Ex');
1212: -- hr_utility.trace('Outside-l_return_status'||l_return_status);
1213: l_return_status := FND_API.G_RET_STS_ERROR;
1214: -- hr_utility.trace('Outside Error-l_return_status'||l_return_status);
1215:
1216: IF P_PA_DEBUG_MODE = 'Y' THEN
1217: pa_fp_gen_amount_utils.fp_debug

Line 1239: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1235:
1236: WHEN OTHERS THEN
1237: -- hr_utility.trace('Inside others Ex');
1238: rollback;
1239: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: l_msg_count := 1;
1241: l_msg_data := substr(sqlerrm,1,240);
1242: --dbms_output.put_line('error msg :'||x_msg_data);
1243: FND_MSG_PUB.add_exc_msg

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1261: END IF;
1262: /* End Bug 5715252 */
1263:
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265:
1266: END GEN_AMT_WRP;
1267:
1268: END PA_FP_GEN_AMT_WRP_PKG;