DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on FND_API

Line 480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

476: p_module_name => l_module_name,
477: p_log_level => 5);
478: END IF;
479:
480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
481: IF p_pa_debug_mode = 'Y' THEN
482: pa_fp_gen_amount_utils.fp_debug
483: (p_called_mode => l_called_mode,
484: p_msg =>'Raising invalid arg exc after create version api call',

Line 491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

487: END IF;
488: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
489: END IF;
490:
491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: l_generation_flag := 'N';
493: l_msg_count := FND_MSG_PUB.Count_Msg;
494: IF p_pa_debug_mode = 'Y' THEN
495: pa_fp_gen_amount_utils.fp_debug

Line 512: (p_encoded => FND_API.G_FALSE,

508: IF l_msg_count > 0 THEN
509: IF l_msg_count = 1 THEN
510: l_msg_data_in := l_msg_data;
511: PA_INTERFACE_UTILS_PUB.get_messages
512: (p_encoded => FND_API.G_FALSE,
513: p_msg_index => 1,
514: p_msg_count => 1,
515: p_msg_data => l_msg_data_in,
516: p_data => l_msg_data,

Line 531: (p_encoded => FND_API.G_FALSE,

527: FOR j in 1 .. l_msg_count LOOP
528: --dbms_output.put_line('inside the error loop ');
529: l_msg_data_in := l_msg_data;
530: pa_interface_utils_pub.get_messages
531: (p_encoded => FND_API.G_FALSE,
532: p_msg_index => j,
533: p_msg_count => l_msg_count ,
534: p_msg_data => l_msg_data_in ,
535: p_data => l_msg_data,

Line 586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

582: p_module_name => l_module_name,
583: p_log_level => 5);
584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: IF p_pa_debug_mode = 'Y' THEN
588: pa_fp_gen_amount_utils.fp_debug
589: (p_called_mode => l_called_mode,
590: p_msg =>'Raising invalid arg exc after Get Plan ver dtls api call',

Line 596: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

592: p_log_level => 5);
593: END IF;
594: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
595: END IF;
596: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
597: l_gen_api_call_flag := 'N';
598: END IF;
599:
600: l_unspent_amt_period :=

Line 800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

796: p_log_level => 5);
797: END IF;
798:
799:
800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
801: IF p_pa_debug_mode = 'Y' THEN
802: pa_fp_gen_amount_utils.fp_debug
803: (p_called_mode => l_called_mode,
804: p_msg=>'Raising invalid arg exc aft Get Curr Original ver api call',

Line 810: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

806: p_log_level => 5);
807: END IF;
808: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
809: END IF;
810: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: l_gen_api_call_flag := 'N';
812: END IF;
813:
814:

Line 843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

839: p_module_name => l_module_name,
840: p_log_level => 5);
841: END IF;
842:
843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: IF p_pa_debug_mode = 'Y' THEN
845: pa_fp_gen_amount_utils.fp_debug
846: (p_called_mode => l_called_mode,
847: p_msg=>'Raising invalid arg exc aft Get Curr Wkg ver api call',

Line 853: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

849: p_log_level => 5);
850: END IF;
851: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
852: END IF;
853: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
854: l_gen_api_call_flag := 'N';
855: END IF;
856: END IF;
857:

Line 907: l_return_status := FND_API.G_RET_STS_ERROR;

903: EXCEPTION
904: WHEN OTHERS THEN
905: rollback;
906: l_gen_api_call_flag := 'N';
907: l_return_status := FND_API.G_RET_STS_ERROR;
908: l_msg_count := 1;
909: l_msg_data := substr(sqlerrm,1,240);
910: IF P_PA_DEBUG_MODE = 'Y' THEN
911: pa_fp_gen_amount_utils.fp_debug

Line 1081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1087: p_log_level => 5);
1088: END IF;
1089: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1090: END IF;
1091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: l_gen_api_call_flag := 'N';
1093: END IF;
1094: PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP
1095: (P_PROJECT_ID => l_proj_id,

Line 1136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1132: END IF;
1133: -- hr_utility.trace('l_return_status after GENERATE_FCST_AMT_WRP '||l_return_status);
1134: -- hr_utility.trace('l_version_generation GENERATE_FCST_AMT_WRP '||l_generation_flag);
1135:
1136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: IF p_pa_debug_mode = 'Y' THEN
1138: pa_fp_gen_amount_utils.fp_debug
1139: (p_called_mode => l_called_mode,
1140: p_msg=>'Raising invalid arg exc aft Fcst Gen api call',

Line 1146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1142: p_log_level => 5);
1143: END IF;
1144: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1145: END IF;
1146: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1147: -- hr_utility.trace('EXCEPTION ERROR FROM GENERATE_FCST_AMT_WRP');
1148: l_gen_api_call_flag := 'N';
1149: END IF;
1150: EXCEPTION

Line 1155: l_return_status := FND_API.G_RET_STS_ERROR;

1151: /*xxxxx*/
1152: WHEN OTHERS THEN
1153: -- hr_utility.trace('Inside Forecast Gen others Ex');
1154: rollback;
1155: l_return_status := FND_API.G_RET_STS_ERROR;
1156: l_msg_count := 1;
1157: l_msg_data := substr(sqlerrm,1,240);
1158: --dbms_output.put_line('error msg :'||x_msg_data);
1159: IF P_PA_DEBUG_MODE = 'Y' THEN

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

1207: -- dbms_output.put_line('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1208: -- hr_utility.trace('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1209: -- dbms_output.put_line('after budget generation l_proj_id: '||l_proj_id);
1210: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1211: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1212: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1213: IF p_pa_debug_mode = 'Y' THEN
1214: pa_fp_gen_amount_utils.fp_debug
1215: (p_called_mode => l_called_mode,

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

1208: -- hr_utility.trace('after budget generation lx_budget_version_id: '||lx_budget_version_id);
1209: -- dbms_output.put_line('after budget generation l_proj_id: '||l_proj_id);
1210: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1211: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1212: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1213: IF p_pa_debug_mode = 'Y' THEN
1214: pa_fp_gen_amount_utils.fp_debug
1215: (p_called_mode => l_called_mode,
1216: p_msg => 'Status after calling

Line 1222: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1218: ||l_return_status,
1219: p_module_name => l_module_name,
1220: p_log_level => 5);
1221: END IF;
1222: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: IF p_pa_debug_mode = 'Y' THEN
1224: pa_fp_gen_amount_utils.fp_debug
1225: (p_called_mode => l_called_mode,
1226: p_msg=>'Raising invalid arg exc aft Bdgt Gen api call',

Line 1233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1229: END IF;
1230: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1231: END IF;
1232: /*xxxxxx*/
1233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1234: -- hr_utility.trace('EXCEPTION ERROR FROM GENERATE_BUDGET_AMT_WRP');
1235: l_gen_api_call_flag := 'N';
1236: END IF;
1237: EXCEPTION

Line 1241: l_return_status := FND_API.G_RET_STS_ERROR;

1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: -- hr_utility.trace('Inside others Ex');
1240: rollback;
1241: l_return_status := FND_API.G_RET_STS_ERROR;
1242: l_msg_count := 1;
1243: l_msg_data := substr(sqlerrm,1,240);
1244: --dbms_output.put_line('error msg :'||x_msg_data);
1245: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1254:
1255:
1256: END IF;--For IF condition for BUDGET
1257:
1258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: -- hr_utility.trace('INVALID EXCEPTION!!!');
1260: IF p_pa_debug_mode = 'Y' THEN
1261: pa_fp_gen_amount_utils.fp_debug
1262: (p_called_mode => l_called_mode,

Line 1269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1265: p_log_level => 5);
1266: END IF;
1267: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1268: END IF;
1269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1270: l_gen_api_call_flag := 'N';
1271: END IF;
1272:
1273: IF l_gen_api_call_flag = 'N' THEN

Line 1293: (p_encoded => FND_API.G_FALSE,

1289: p_write_mode => 1);
1290: IF l_msg_count = 1 THEN
1291: l_msg_data_in := l_msg_data;
1292: PA_INTERFACE_UTILS_PUB.get_messages
1293: (p_encoded => FND_API.G_FALSE,
1294: p_msg_index => 1,
1295: p_msg_count => 1,
1296: p_msg_data => l_msg_data_in ,
1297: p_data => l_msg_data,

Line 1312: (p_encoded => FND_API.G_FALSE,

1308: FOR j in 1 .. l_msg_count LOOP
1309: --dbms_output.put_line('inside the error loop ');
1310: l_msg_data_in := l_msg_data;
1311: pa_interface_utils_pub.get_messages
1312: (p_encoded => FND_API.G_FALSE,
1313: p_msg_index => j,
1314: p_msg_count => l_msg_count ,
1315: p_msg_data => l_msg_data_in ,
1316: p_data => l_msg_data,

Line 1353: (p_encoded => FND_API.G_FALSE,

1349: p_write_file => 'OUT',
1350: p_write_mode => 1);
1351: IF l_msg_count = 1 THEN
1352: PA_INTERFACE_UTILS_PUB.get_messages
1353: (p_encoded => FND_API.G_FALSE,
1354: p_msg_index => 1,
1355: p_msg_count => 1,
1356: p_msg_data => l_msg_data ,
1357: p_data => l_msg_data,

Line 1367: (p_encoded => FND_API.G_FALSE,

1363: p_write_mode => 1);
1364: ELSE
1365: FOR j in 1 .. l_msg_count LOOP
1366: pa_interface_utils_pub.get_messages
1367: (p_encoded => FND_API.G_FALSE,
1368: p_msg_index => j,
1369: p_msg_count => l_msg_count ,
1370: p_msg_data => l_msg_data ,
1371: p_data => l_msg_data,

Line 1396: ( p_encoded => FND_API.G_TRUE,

1392: -- hr_utility.trace('Inside invalid arg Ex');
1393: l_msg_count := FND_MSG_PUB.count_msg;
1394: IF l_msg_count = 1 THEN
1395: PA_INTERFACE_UTILS_PUB.get_messages
1396: ( p_encoded => FND_API.G_TRUE,
1397: p_msg_index => 1,
1398: p_msg_count => l_msg_count,
1399: p_msg_data => l_msg_data,
1400: p_data => l_data,

Line 1409: l_return_status := FND_API.G_RET_STS_ERROR;

1405: ROLLBACK;
1406:
1407: -- hr_utility.trace('Outside Ex');
1408: -- hr_utility.trace('Outside-l_return_status'||l_return_status);
1409: l_return_status := FND_API.G_RET_STS_ERROR;
1410: -- hr_utility.trace('Outside Error-l_return_status'||l_return_status);
1411:
1412: IF P_PA_DEBUG_MODE = 'Y' THEN
1413: pa_fp_gen_amount_utils.fp_debug

Line 1435: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1431:
1432: WHEN OTHERS THEN
1433: -- hr_utility.trace('Inside others Ex');
1434: rollback;
1435: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: l_msg_count := 1;
1437: l_msg_data := substr(sqlerrm,1,240);
1438: --dbms_output.put_line('error msg :'||x_msg_data);
1439: FND_MSG_PUB.add_exc_msg

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456: DBMS_SQL.CLOSE_CURSOR(sql_cursor);
1457: END IF;
1458: /* End Bug 5715252 */
1459:
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461:
1462: END GEN_AMT_WRP;
1463:
1464: END PA_FP_GEN_AMT_WRP_PKG;