APPS.AS_INT_TYP_COD_MIGRATION dependencies on FND_API

Line 186: RETCODE := FND_API.G_RET_STS_SUCCESS;

182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
183: end if;
184:
185: -- Initialize retcode to success
186: RETCODE := FND_API.G_RET_STS_SUCCESS;
187:
188: for scr in C_Get_Query_Ids(G_APPLICATION_ID)
189: loop
190: Process_Perz_Query_Params(scr.query_id, scr.query_name,l_debug,l_ret_sts_warning);

Line 213: RETCODE := FND_API.G_RET_STS_ERROR;

209: end if;
210: EXCEPTION
211: WHEN OTHERS THEN
212: Rollback;
213: RETCODE := FND_API.G_RET_STS_ERROR;
214: ERRBUF := 'Error in perz data migration '||SQLERRM;
215: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
216: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
217: IF l_status = TRUE THEN

Line 641: RETCODE := FND_API.G_RET_STS_ERROR;

637: end if;
638: EXCEPTION
639: WHEN OTHERS THEN
640: Rollback;
641: RETCODE := FND_API.G_RET_STS_ERROR;
642: ERRBUF := 'Error in opportunity lines data migration '||SQLERRM;
643: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
644: -- Enable All the triggers (even in case of exception)
645: Enable_Triggers(l_lead_lines_biud,l_lead_lines_after_biud,l_sales_credits_biud,l_sales_credits_after_biud);

Line 746: RETCODE := FND_API.G_RET_STS_ERROR;

742: end if;
743: EXCEPTION
744: WHEN OTHERS THEN
745: Rollback;
746: RETCODE := FND_API.G_RET_STS_ERROR;
747: ERRBUF := 'Error in forecast category data migration '||SQLERRM;
748: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
749: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
750: IF l_status = TRUE THEN

Line 872: RETCODE := FND_API.G_RET_STS_ERROR;

868: end if;
869: EXCEPTION
870: WHEN OTHERS THEN
871: Rollback;
872: RETCODE := FND_API.G_RET_STS_ERROR;
873: ERRBUF := 'Error in product interests data migration '||SQLERRM;
874: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
875: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
876: IF l_status = TRUE THEN

Line 998: RETCODE := FND_API.G_RET_STS_ERROR;

994: end if;
995: EXCEPTION
996: WHEN OTHERS THEN
997: Rollback;
998: RETCODE := FND_API.G_RET_STS_ERROR;
999: ERRBUF := 'Error in opportunity logs data migration '||SQLERRM;
1000: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1001: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1002: IF l_status = TRUE THEN

Line 1124: RETCODE := FND_API.G_RET_STS_ERROR;

1120: end if;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: Rollback;
1124: RETCODE := FND_API.G_RET_STS_ERROR;
1125: ERRBUF := 'Error in sales credits data migration '||SQLERRM;
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1127: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1128: IF l_status = TRUE THEN

Line 1229: RETCODE := FND_API.G_RET_STS_ERROR;

1225: end if;
1226: EXCEPTION
1227: WHEN OTHERS THEN
1228: Rollback;
1229: RETCODE := FND_API.G_RET_STS_ERROR;
1230: ERRBUF := 'Error in forecast product worksheet data migration '||SQLERRM;
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1232: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1233: IF l_status = TRUE THEN

Line 1302: RETCODE := FND_API.G_RET_STS_ERROR;

1298: end if;
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: Rollback;
1302: RETCODE := FND_API.G_RET_STS_ERROR;
1303: ERRBUF := 'Error in plan element categories '||SQLERRM;
1304: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1305: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1306: IF l_status = TRUE THEN