DBA Data[Home] [Help]

APPS.FII_COM_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_COMPANIES');
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 318: FND_CONCURRENT.Af_Rollback;

314: raise;
315:
316: When CODIM_fatal_err then
317: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Initialize : '|| 'User defined error');
318: FND_CONCURRENT.Af_Rollback;
319: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Initialize');
320: raise;
321:
322: When others then

Line 467: FND_CONCURRENT.Af_Rollback;

463: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
464:
465:
466: 'User defined error');
467: FND_CONCURRENT.Af_Rollback;
468: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
469: raise;
470:
471: When others then

Line 681: FND_CONCURRENT.Af_Commit; --commit

677: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
678:
679: g_index := g_index-1;
680:
681: FND_CONCURRENT.Af_Commit; --commit
682:
683: EXCEPTION
684: WHEN NO_DATA_FOUND Then
685: FII_UTIL.Write_Log ('Insert Immediate child: No Data Found');

Line 1367: FND_CONCURRENT.Af_Commit;

1363: tabname => 'MLOG$_FII_COMPANY_HIERARCH');
1364:
1365: --================================================================--
1366:
1367: FND_CONCURRENT.Af_Commit;
1368:
1369: IF (FIIDIM_Debug) THEN
1370: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1371: END IF;

Line 1382: FND_CONCURRENT.Af_Rollback;

1378:
1379: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||
1380: 'User defined error');
1381:
1382: FND_CONCURRENT.Af_Rollback;
1383: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1384: retcode := sqlcode;
1385: ret_val := FND_CONCURRENT.Set_Completion_Status
1386: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1385: ret_val := FND_CONCURRENT.Set_Completion_Status

1381:
1382: FND_CONCURRENT.Af_Rollback;
1383: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1384: retcode := sqlcode;
1385: ret_val := FND_CONCURRENT.Set_Completion_Status
1386: (status => 'ERROR', message => substr(sqlerrm,1,180));
1387:
1388: WHEN CODIM_MULT_PAR_err THEN
1389: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||

Line 1392: FND_CONCURRENT.Af_Rollback;

1388: WHEN CODIM_MULT_PAR_err THEN
1389: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Init_Load: '||
1390: 'Diamond Shape Detected');
1391:
1392: FND_CONCURRENT.Af_Rollback;
1393: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1394: retcode := sqlcode;
1395: ret_val := FND_CONCURRENT.Set_Completion_Status
1396: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1395: ret_val := FND_CONCURRENT.Set_Completion_Status

1391:
1392: FND_CONCURRENT.Af_Rollback;
1393: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1394: retcode := sqlcode;
1395: ret_val := FND_CONCURRENT.Set_Completion_Status
1396: (status => 'ERROR', message => substr(sqlerrm,1,180));
1397:
1398: WHEN CODIM_NOT_ENABLED THEN
1399: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');

Line 1404: --ret_val := FND_CONCURRENT.Set_Completion_Status

1400:
1401: Handle_Unenabled_DIM;
1402:
1403: retcode := sqlcode;
1404: --ret_val := FND_CONCURRENT.Set_Completion_Status
1405: -- (status => 'NORMAL', message => NULL);
1406:
1407: WHEN OTHERS THEN
1408: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1413: FND_CONCURRENT.Af_Rollback;

1409: FII_UTIL.Write_Log (
1410: 'Other error in FII_COM_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1411:
1412:
1413: FND_CONCURRENT.Af_Rollback;
1414: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1415: retcode := sqlcode;
1416: ret_val := FND_CONCURRENT.Set_Completion_Status
1417: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1416: ret_val := FND_CONCURRENT.Set_Completion_Status

1412:
1413: FND_CONCURRENT.Af_Rollback;
1414: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Init_Load');
1415: retcode := sqlcode;
1416: ret_val := FND_CONCURRENT.Set_Completion_Status
1417: (status => 'ERROR', message => substr(sqlerrm,1,180));
1418:
1419: END Init_Load;
1420:

Line 1640: FND_CONCURRENT.Af_Commit;

1636:
1637:
1638: --=============================================================--
1639:
1640: FND_CONCURRENT.Af_Commit;
1641:
1642: IF (FIIDIM_Debug) THEN
1643: FII_MESSAGE.Func_Succ(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1644: END IF;

Line 1653: FND_CONCURRENT.Af_Rollback;

1649: WHEN CODIM_fatal_err THEN
1650: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update'||
1651: 'User defined error');
1652:
1653: FND_CONCURRENT.Af_Rollback;
1654: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1655: retcode := sqlcode;
1656: ret_val := FND_CONCURRENT.Set_Completion_Status
1657: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1656: ret_val := FND_CONCURRENT.Set_Completion_Status

1652:
1653: FND_CONCURRENT.Af_Rollback;
1654: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1655: retcode := sqlcode;
1656: ret_val := FND_CONCURRENT.Set_Completion_Status
1657: (status => 'ERROR', message => substr(sqlerrm,1,180));
1658:
1659: WHEN CODIM_MULT_PAR_err THEN
1660: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update: '||

Line 1663: FND_CONCURRENT.Af_Rollback;

1659: WHEN CODIM_MULT_PAR_err THEN
1660: FII_UTIL.Write_Log ('FII_COM_MAINTAIN_PKG.Incre_Update: '||
1661: 'Diamond Shape Detected');
1662:
1663: FND_CONCURRENT.Af_Rollback;
1664: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1665: retcode := sqlcode;
1666: ret_val := FND_CONCURRENT.Set_Completion_Status
1667: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1666: ret_val := FND_CONCURRENT.Set_Completion_Status

1662:
1663: FND_CONCURRENT.Af_Rollback;
1664: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1665: retcode := sqlcode;
1666: ret_val := FND_CONCURRENT.Set_Completion_Status
1667: (status => 'ERROR', message => substr(sqlerrm,1,180));
1668:
1669: WHEN CODIM_NOT_ENABLED THEN
1670: FII_UTIL.Write_Log ('>>> COMPANY Dimension Not Enabled...');

Line 1675: --ret_val := FND_CONCURRENT.Set_Completion_Status

1671:
1672: Handle_Unenabled_DIM;
1673:
1674: retcode := sqlcode;
1675: --ret_val := FND_CONCURRENT.Set_Completion_Status
1676: -- (status => 'NORMAL', message => NULL);
1677:
1678: WHEN OTHERS THEN
1679: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 1684: FND_CONCURRENT.Af_Rollback;

1680: FII_UTIL.Write_Log (
1681: 'Other error in FII_COM_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1682:
1683:
1684: FND_CONCURRENT.Af_Rollback;
1685: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1686: retcode := sqlcode;
1687: ret_val := FND_CONCURRENT.Set_Completion_Status
1688: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1687: ret_val := FND_CONCURRENT.Set_Completion_Status

1683:
1684: FND_CONCURRENT.Af_Rollback;
1685: FII_MESSAGE.Func_Fail(func_name => 'FII_COM_MAINTAIN_PKG.Incre_Update');
1686: retcode := sqlcode;
1687: ret_val := FND_CONCURRENT.Set_Completion_Status
1688: (status => 'ERROR', message => substr(sqlerrm,1,180));
1689:
1690: END Incre_Update;
1691: