DBA Data[Home] [Help]

APPS.FII_AR_COLLECTORS_PKG dependencies on FND_CONCURRENT

Line 71: FND_CONCURRENT.Af_Rollback;

67: EXCEPTION
68:
69: WHEN CODIM_fatal_err THEN
70: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Initialize : '|| 'User defined error');
71: FND_CONCURRENT.Af_Rollback;
72: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Initialize');
73: RAISE;
74:
75: WHEN OTHERS THEN

Line 252: FND_CONCURRENT.Af_Commit;

248: FND_STATS.gather_table_stats
249: (ownname => g_schema_name,
250: tabname => 'MLOG$_FII_COLLECTORS');
251:
252: FND_CONCURRENT.Af_Commit;
253:
254: IF (FIIDIM_Debug) THEN
255: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
256: END IF;

Line 275: FND_CONCURRENT.Af_Rollback;

271:
272: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Init_Load: '||
273: 'User defined error');
274:
275: FND_CONCURRENT.Af_Rollback;
276: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
277: retcode := sqlcode;
278: ret_val := FND_CONCURRENT.Set_Completion_Status
279: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 278: ret_val := FND_CONCURRENT.Set_Completion_Status

274:
275: FND_CONCURRENT.Af_Rollback;
276: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
277: retcode := sqlcode;
278: ret_val := FND_CONCURRENT.Set_Completion_Status
279: (status => 'ERROR', message => substr(sqlerrm,1,180));
280:
281: WHEN OTHERS THEN
282: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 287: FND_CONCURRENT.Af_Rollback;

283: FII_UTIL.Write_Log (
284: 'Other error IN FII_AR_COLLECTORS_PKG.Init_Load: ' || substr(sqlerrm,1,180));
285:
286:
287: FND_CONCURRENT.Af_Rollback;
288: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
289: retcode := sqlcode;
290: ret_val := FND_CONCURRENT.Set_Completion_Status
291: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 290: ret_val := FND_CONCURRENT.Set_Completion_Status

286:
287: FND_CONCURRENT.Af_Rollback;
288: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
289: retcode := sqlcode;
290: ret_val := FND_CONCURRENT.Set_Completion_Status
291: (status => 'ERROR', message => substr(sqlerrm,1,180));
292:
293: END Init_Load;
294:

Line 400: FND_CONCURRENT.Af_Commit;

396: last_updated_by = fii_user_id
397: WHERE log_item = 'COLL_MAX_BATCH_PARTY_ID';
398: END IF;
399:
400: FND_CONCURRENT.Af_Commit;
401:
402: IF (FIIDIM_Debug) THEN
403: FII_UTIL.Write_Log ('Now start processing Collector dimension');
404: END IF;

Line 564: FND_CONCURRENT.Af_Commit;

560:
561: -- From past experience, perf team has suggested not to analyze MLOG in incremental run.
562: -- So we will not be gathering stats for MLOG during incremental run.
563:
564: FND_CONCURRENT.Af_Commit;
565:
566: IF (FIIDIM_Debug) THEN
567: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
568: END IF;

Line 583: FND_CONCURRENT.Af_Rollback;

579: WHEN CODIM_fatal_err THEN
580: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Incre_Update'||
581: 'User defined error');
582:
583: FND_CONCURRENT.Af_Rollback;
584: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
585: retcode := sqlcode;
586: ret_val := FND_CONCURRENT.Set_Completion_Status
587: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 586: ret_val := FND_CONCURRENT.Set_Completion_Status

582:
583: FND_CONCURRENT.Af_Rollback;
584: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
585: retcode := sqlcode;
586: ret_val := FND_CONCURRENT.Set_Completion_Status
587: (status => 'ERROR', message => substr(sqlerrm,1,180));
588:
589: WHEN OTHERS THEN
590: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 594: FND_CONCURRENT.Af_Rollback;

590: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
591: FII_UTIL.Write_Log (
592: 'Other error IN FII_AR_COLLECTORS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
593:
594: FND_CONCURRENT.Af_Rollback;
595: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
596: retcode := sqlcode;
597: ret_val := FND_CONCURRENT.Set_Completion_Status
598: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 597: ret_val := FND_CONCURRENT.Set_Completion_Status

593:
594: FND_CONCURRENT.Af_Rollback;
595: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
596: retcode := sqlcode;
597: ret_val := FND_CONCURRENT.Set_Completion_Status
598: (status => 'ERROR', message => substr(sqlerrm,1,180));
599:
600: END Incre_Update;
601: