DBA Data[Home] [Help]

APPS.FII_LOB_MAINTAIN_PKG dependencies on FND_CONCURRENT

Line 171: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(

167:
168: l_check := FII_EXCEPTION_CHECK_PKG.detect_unmapped_local_vs('FII_LOB');
169:
170: if l_check > 0 then
171: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(
172: status => 'WARNING',
173: message => 'Detected unmapped local value set.'
174: );
175: elsif l_check < 0 then

Line 340: FND_CONCURRENT.Af_Rollback;

336:
337: When LOBDIM_fatal_err then
338: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Initialize : '|| 'User defined error');
339: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
340: FND_CONCURRENT.Af_Rollback;
341: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Initialize');
342: raise;
343:
344: When others then

Line 496: FND_CONCURRENT.Af_Rollback;

492: When LOBDIM_fatal_err then
493: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
494: 'User defined error');
495: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
496: FND_CONCURRENT.Af_Rollback;
497: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
498: raise;
499:
500: When others then

Line 701: FND_CONCURRENT.Af_Commit; --commit

697: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
698: g_index := g_index - 1;
699:
700:
701: FND_CONCURRENT.Af_Commit; --commit
702:
703: EXCEPTION
704: WHEN NO_DATA_FOUND Then
705: FII_UTIL.Write_Log ('Insert Immediate child: No Data Found');

Line 1442: FND_CONCURRENT.Af_Commit;

1438: -- tabname => 'FII_LOB_HIERARCHIES');
1439:
1440: --================================================================--
1441:
1442: FND_CONCURRENT.Af_Commit;
1443:
1444: IF (FIIDIM_Debug) THEN
1445: FII_MESSAGE.Func_Succ(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1446: END IF;

Line 1448: -- ret_val := FND_CONCURRENT.Set_Completion_Status

1444: IF (FIIDIM_Debug) THEN
1445: FII_MESSAGE.Func_Succ(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1446: END IF;
1447:
1448: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1449: -- (status => 'NORMAL', message => NULL);
1450:
1451: -- Exception handling
1452:

Line 1460: FND_CONCURRENT.Af_Rollback;

1456: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1457: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Init_Load: '||
1458: 'User defined error');
1459: -- Rollback
1460: FND_CONCURRENT.Af_Rollback;
1461: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1462: retcode := sqlcode;
1463: ret_val := FND_CONCURRENT.Set_Completion_Status
1464: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1463: ret_val := FND_CONCURRENT.Set_Completion_Status

1459: -- Rollback
1460: FND_CONCURRENT.Af_Rollback;
1461: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1462: retcode := sqlcode;
1463: ret_val := FND_CONCURRENT.Set_Completion_Status
1464: (status => 'ERROR', message => substr(sqlerrm,1,180));
1465:
1466: WHEN LOBDIM_MULT_PAR_err THEN
1467: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1471: FND_CONCURRENT.Af_Rollback;

1467: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1468: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Init_Load: '||
1469: 'Diamond Shape Detected');
1470: -- Rollback
1471: FND_CONCURRENT.Af_Rollback;
1472: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1473: retcode := sqlcode;
1474: ret_val := FND_CONCURRENT.Set_Completion_Status
1475: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1474: ret_val := FND_CONCURRENT.Set_Completion_Status

1470: -- Rollback
1471: FND_CONCURRENT.Af_Rollback;
1472: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Init_Load');
1473: retcode := sqlcode;
1474: ret_val := FND_CONCURRENT.Set_Completion_Status
1475: (status => 'ERROR', message => substr(sqlerrm,1,180));
1476:
1477: WHEN LOBDIM_NOT_ENABLED THEN
1478: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1484: -- ret_val := FND_CONCURRENT.Set_Completion_Status

1480:
1481: Handle_Unenabled_DIM;
1482:
1483: retcode := sqlcode;
1484: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1485: -- (status => 'NORMAL', message => NULL);
1486:
1487: WHEN OTHERS THEN
1488: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1493: FND_CONCURRENT.Af_Rollback;

1489: FII_UTIL.Write_Log (
1490: 'Other error in FII_LOB_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1491:
1492: -- Rollback
1493: FND_CONCURRENT.Af_Rollback;
1494: FII_MESSAGE.Func_Fail(func_name => 'II_LOB_MAINTAIN_PKG.Init_Load');
1495: retcode := sqlcode;
1496: ret_val := FND_CONCURRENT.Set_Completion_Status
1497: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1496: ret_val := FND_CONCURRENT.Set_Completion_Status

1492: -- Rollback
1493: FND_CONCURRENT.Af_Rollback;
1494: FII_MESSAGE.Func_Fail(func_name => 'II_LOB_MAINTAIN_PKG.Init_Load');
1495: retcode := sqlcode;
1496: ret_val := FND_CONCURRENT.Set_Completion_Status
1497: (status => 'ERROR', message => substr(sqlerrm,1,180));
1498:
1499: END Init_Load;
1500:

Line 1753: FND_CONCURRENT.Af_Commit;

1749: -- tabname => 'FII_LOB_HIERARCHIES');
1750:
1751: --=============================================================--
1752:
1753: FND_CONCURRENT.Af_Commit;
1754:
1755: IF (FIIDIM_Debug) THEN
1756: FII_MESSAGE.Func_Succ(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Load');
1757: END IF;

Line 1759: -- ret_val := FND_CONCURRENT.Set_Completion_Status

1755: IF (FIIDIM_Debug) THEN
1756: FII_MESSAGE.Func_Succ(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Load');
1757: END IF;
1758:
1759: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1760: -- (status => 'COMPLETE', message => NULL);
1761:
1762: -- Exception handling
1763:

Line 1770: FND_CONCURRENT.Af_Rollback;

1766: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1767: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Incre_Update'||
1768: 'User defined error');
1769: -- Rollback
1770: FND_CONCURRENT.Af_Rollback;
1771: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Update');
1772: retcode := sqlcode;
1773: ret_val := FND_CONCURRENT.Set_Completion_Status
1774: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1773: ret_val := FND_CONCURRENT.Set_Completion_Status

1769: -- Rollback
1770: FND_CONCURRENT.Af_Rollback;
1771: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Update');
1772: retcode := sqlcode;
1773: ret_val := FND_CONCURRENT.Set_Completion_Status
1774: (status => 'ERROR', message => substr(sqlerrm,1,180));
1775:
1776: WHEN LOBDIM_MULT_PAR_err THEN
1777: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 1781: FND_CONCURRENT.Af_Rollback;

1777: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
1778: FII_UTIL.Write_Log ('FII_LOB_MAINTAIN_PKG.Incre_Update: '||
1779: 'Diamond Shape Detected');
1780: -- Rollback
1781: FND_CONCURRENT.Af_Rollback;
1782: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Update');
1783: retcode := sqlcode;
1784: ret_val := FND_CONCURRENT.Set_Completion_Status
1785: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1784: ret_val := FND_CONCURRENT.Set_Completion_Status

1780: -- Rollback
1781: FND_CONCURRENT.Af_Rollback;
1782: FII_MESSAGE.Func_Fail(func_name => 'FII_LOB_MAINTAIN_PKG.Incre_Update');
1783: retcode := sqlcode;
1784: ret_val := FND_CONCURRENT.Set_Completion_Status
1785: (status => 'ERROR', message => substr(sqlerrm,1,180));
1786:
1787: WHEN LOBDIM_NOT_ENABLED THEN
1788: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 1794: -- ret_val := FND_CONCURRENT.Set_Completion_Status

1790:
1791: Handle_Unenabled_DIM;
1792:
1793: retcode := sqlcode;
1794: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1795: -- (status => 'NORMAL', message => NULL);
1796:
1797: WHEN OTHERS THEN
1798: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 1803: FND_CONCURRENT.Af_Rollback;

1799: FII_UTIL.Write_Log (
1800: 'Other error in FII_LOB_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1801:
1802: -- Rollback
1803: FND_CONCURRENT.Af_Rollback;
1804: FII_MESSAGE.Func_Fail(func_name => 'II_LOB_MAINTAIN_PKG.Incre_Update');
1805: retcode := sqlcode;
1806: ret_val := FND_CONCURRENT.Set_Completion_Status
1807: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1806: ret_val := FND_CONCURRENT.Set_Completion_Status

1802: -- Rollback
1803: FND_CONCURRENT.Af_Rollback;
1804: FII_MESSAGE.Func_Fail(func_name => 'II_LOB_MAINTAIN_PKG.Incre_Update');
1805: retcode := sqlcode;
1806: ret_val := FND_CONCURRENT.Set_Completion_Status
1807: (status => 'ERROR', message => substr(sqlerrm,1,180));
1808:
1809: END Incre_Update;
1810: