DBA Data[Home] [Help]

APPS.AS_INT_TYP_COD_MIGRATION dependencies on FND_CONCURRENT

Line 98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));

94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
96:
97: if (l_warning = 'Y') then
98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));
99: end if;
100: EXCEPTION
101: WHEN OTHERS THEN
102: Rollback;

Line 104: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

100: EXCEPTION
101: WHEN OTHERS THEN
102: Rollback;
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in migration '||SQLERRM);
104: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
105: IF l_status = TRUE THEN
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
107: END IF ;
108: END Migrate_All;

Line 208: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));

204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
205: end if;
206:
207: if (RETCODE = G_RET_STS_WARNING) then
208: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));
209: end if;
210: EXCEPTION
211: WHEN OTHERS THEN
212: Rollback;

Line 216: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
219: END IF ;
220: END Migrate_Perz_Data;

Line 646: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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);
646: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
647: IF l_status = TRUE THEN
648: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
649: END IF ;
650: END Migrate_AS_LEAD_LINES_ALL;

Line 749: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
751: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
752: END IF ;
753: END Migrate_FST_SALES_CATEGORIES;

Line 875: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
878: END IF ;
879: END Migrate_AS_INTERESTS_ALL;

Line 1001: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
1003: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1004: END IF ;
1005: END Migrate_AS_LEAD_LINES_LOG;

Line 1127: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1130: END IF ;
1131: END Migrate_AS_SALES_C_DENORM;

Line 1232: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1235: END IF ;
1236: END Migrate_AS_PRODWKS_LINES;

Line 1305: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

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
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1308: END IF ;
1309: END Migrate_AS_PE_INT_CATEGORIES;