DBA Data[Home] [Help]

APPS.FII_COM_CC_DIM_MAPS_PKG dependencies on FND_CONCURRENT

Line 131: FND_CONCURRENT.Af_Rollback;

127:
128: When COMCCDIM_fatal_err then
129: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Initialize : '|| 'User defined error');
130: FII_UTIL.Write_Log ('G_PHASE : ' || g_phase);
131: FND_CONCURRENT.Af_Rollback;
132: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Initialize');
133: raise;
134:
135: When others then

Line 285: FND_CONCURRENT.Af_Commit;

281: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows from FII_COM_CC_DIM_MAPS');
282: END IF;
283:
284:
285: FND_CONCURRENT.Af_Commit;
286:
287: --Call FND_STATS to collect statistics after populating the tables.
288: -- This will be in RSG data.
289: g_phase := 'gather_table_stats for FII_COM_CC_DIM_MAPS';

Line 315: FND_CONCURRENT.Af_Rollback;

311: WHEN COMCCDIM_fatal_err THEN
312:
313: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Init_Load: '||
314: 'User defined error');
315: FND_CONCURRENT.Af_Rollback;
316: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
317: retcode := sqlcode;
318: ret_val := FND_CONCURRENT.Set_Completion_Status
319: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 318: ret_val := FND_CONCURRENT.Set_Completion_Status

314: 'User defined error');
315: FND_CONCURRENT.Af_Rollback;
316: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
317: retcode := sqlcode;
318: ret_val := FND_CONCURRENT.Set_Completion_Status
319: (status => 'ERROR', message => substr(sqlerrm,1,180));
320:
321: WHEN OTHERS THEN
322: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 325: FND_CONCURRENT.Af_Rollback;

321: WHEN OTHERS THEN
322: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
323: FII_UTIL.Write_Log (
324: 'Other error in FII_CC_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
325: FND_CONCURRENT.Af_Rollback;
326: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
327: retcode := sqlcode;
328: ret_val := FND_CONCURRENT.Set_Completion_Status
329: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 328: ret_val := FND_CONCURRENT.Set_Completion_Status

324: 'Other error in FII_CC_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
325: FND_CONCURRENT.Af_Rollback;
326: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Init_Load');
327: retcode := sqlcode;
328: ret_val := FND_CONCURRENT.Set_Completion_Status
329: (status => 'ERROR', message => substr(sqlerrm,1,180));
330:
331: END Init_Load;
332:

Line 429: FND_CONCURRENT.Af_Commit;

425: IF (FIIDIM_Debug) THEN
426: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_COM_CC_DIM_MAPS');
427: END IF;
428:
429: FND_CONCURRENT.Af_Commit;
430:
431: -- Call FND_STATS to collect statistics after populating the tables.
432: -- This will be in RSG data.
433: g_phase := 'gather_table_stats for FII_COM_CC_DIM_MAPS';

Line 458: FND_CONCURRENT.Af_Rollback;

454: WHEN COMCCDIM_fatal_err THEN
455: FII_UTIL.Write_Log ('FII_COM_CC_DIM_MAPS_PKG.Incre_Update'||
456: 'User defined error');
457:
458: FND_CONCURRENT.Af_Rollback;
459: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
460: retcode := sqlcode;
461: ret_val := FND_CONCURRENT.Set_Completion_Status
462: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 461: ret_val := FND_CONCURRENT.Set_Completion_Status

457:
458: FND_CONCURRENT.Af_Rollback;
459: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
460: retcode := sqlcode;
461: ret_val := FND_CONCURRENT.Set_Completion_Status
462: (status => 'ERROR', message => substr(sqlerrm,1,180));
463:
464: WHEN OTHERS THEN
465: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 470: FND_CONCURRENT.Af_Rollback;

466: FII_UTIL.Write_Log (
467: 'Other error in FII_COM_CC_DIM_MAPS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
468:
469:
470: FND_CONCURRENT.Af_Rollback;
471: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
472: retcode := sqlcode;
473: ret_val := FND_CONCURRENT.Set_Completion_Status
474: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 473: ret_val := FND_CONCURRENT.Set_Completion_Status

469:
470: FND_CONCURRENT.Af_Rollback;
471: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_CC_DIM_MAPS_PKG.Incre_Update');
472: retcode := sqlcode;
473: ret_val := FND_CONCURRENT.Set_Completion_Status
474: (status => 'ERROR', message => substr(sqlerrm,1,180));
475:
476: END Incre_Update;
477: