DBA Data[Home] [Help]

APPS.FII_UDD1_MAINTAIN_PKG dependencies on FND_CONCURRENT

Line 170: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(

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

Line 316: FND_CONCURRENT.Af_Rollback;

312: raise;
313:
314: When UDIM1_fatal_err then
315: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Initialize : '|| 'User defined error');
316: FND_CONCURRENT.Af_Rollback;
317: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Initialize');
318: raise;
319:
320: When others then

Line 465: FND_CONCURRENT.Af_Rollback;

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

Line 677: FND_CONCURRENT.Af_Commit; --commit

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

Line 1443: FND_CONCURRENT.Af_Commit;

1439: tabname => 'MLOG$_FII_UDD1_MAPPINGS');
1440:
1441: --=====================================================================
1442:
1443: FND_CONCURRENT.Af_Commit;
1444:
1445: IF (FIIDIM_Debug) THEN
1446: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1447: END IF;

Line 1458: FND_CONCURRENT.Af_Rollback;

1454:
1455: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||
1456: 'User defined error');
1457:
1458: FND_CONCURRENT.Af_Rollback;
1459: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1460: retcode := sqlcode;
1461: ret_val := FND_CONCURRENT.Set_Completion_Status
1462: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1461: ret_val := FND_CONCURRENT.Set_Completion_Status

1457:
1458: FND_CONCURRENT.Af_Rollback;
1459: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1460: retcode := sqlcode;
1461: ret_val := FND_CONCURRENT.Set_Completion_Status
1462: (status => 'ERROR', message => substr(sqlerrm,1,180));
1463:
1464: WHEN UDIM1_MULT_PAR_err THEN
1465: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||

Line 1468: FND_CONCURRENT.Af_Rollback;

1464: WHEN UDIM1_MULT_PAR_err THEN
1465: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Init_Load: '||
1466: 'Diamond Shape Detected');
1467:
1468: FND_CONCURRENT.Af_Rollback;
1469: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1470: retcode := sqlcode;
1471: ret_val := FND_CONCURRENT.Set_Completion_Status
1472: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1471: ret_val := FND_CONCURRENT.Set_Completion_Status

1467:
1468: FND_CONCURRENT.Af_Rollback;
1469: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1470: retcode := sqlcode;
1471: ret_val := FND_CONCURRENT.Set_Completion_Status
1472: (status => 'ERROR', message => substr(sqlerrm,1,180));
1473:
1474: WHEN UDIM1_NOT_ENABLED THEN
1475: FII_UTIL.Write_Log ('>>> UDD1 Dimension Not Enabled...');

Line 1480: --ret_val := FND_CONCURRENT.Set_Completion_Status

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

Line 1489: FND_CONCURRENT.Af_Rollback;

1485: FII_UTIL.Write_Log (
1486: 'Other error in FII_UDD1_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1487:
1488:
1489: FND_CONCURRENT.Af_Rollback;
1490: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1491: retcode := sqlcode;
1492: ret_val := FND_CONCURRENT.Set_Completion_Status
1493: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1492: ret_val := FND_CONCURRENT.Set_Completion_Status

1488:
1489: FND_CONCURRENT.Af_Rollback;
1490: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Init_Load');
1491: retcode := sqlcode;
1492: ret_val := FND_CONCURRENT.Set_Completion_Status
1493: (status => 'ERROR', message => substr(sqlerrm,1,180));
1494:
1495: END Init_Load;
1496:

Line 1773: FND_CONCURRENT.Af_Commit;

1769:
1770: --=====================================================================
1771:
1772:
1773: FND_CONCURRENT.Af_Commit;
1774:
1775: IF (FIIDIM_Debug) THEN
1776: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1777: END IF;

Line 1786: FND_CONCURRENT.Af_Rollback;

1782: WHEN UDIM1_fatal_err THEN
1783: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update'||
1784: 'User defined error');
1785:
1786: FND_CONCURRENT.Af_Rollback;
1787: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1788: retcode := sqlcode;
1789: ret_val := FND_CONCURRENT.Set_Completion_Status
1790: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1789: ret_val := FND_CONCURRENT.Set_Completion_Status

1785:
1786: FND_CONCURRENT.Af_Rollback;
1787: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1788: retcode := sqlcode;
1789: ret_val := FND_CONCURRENT.Set_Completion_Status
1790: (status => 'ERROR', message => substr(sqlerrm,1,180));
1791:
1792: WHEN UDIM1_MULT_PAR_err THEN
1793: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update: '||

Line 1796: FND_CONCURRENT.Af_Rollback;

1792: WHEN UDIM1_MULT_PAR_err THEN
1793: FII_UTIL.Write_Log ('FII_UDD1_MAINTAIN_PKG.Incre_Update: '||
1794: 'Diamond Shape Detected');
1795:
1796: FND_CONCURRENT.Af_Rollback;
1797: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1798: retcode := sqlcode;
1799: ret_val := FND_CONCURRENT.Set_Completion_Status
1800: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1799: ret_val := FND_CONCURRENT.Set_Completion_Status

1795:
1796: FND_CONCURRENT.Af_Rollback;
1797: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1798: retcode := sqlcode;
1799: ret_val := FND_CONCURRENT.Set_Completion_Status
1800: (status => 'ERROR', message => substr(sqlerrm,1,180));
1801:
1802: WHEN UDIM1_NOT_ENABLED THEN
1803: FII_UTIL.Write_Log ('>>> User Defined Dimension1 Not Enabled...');

Line 1808: --ret_val := FND_CONCURRENT.Set_Completion_Status

1804:
1805: Handle_Unenabled_DIM;
1806:
1807: retcode := sqlcode;
1808: --ret_val := FND_CONCURRENT.Set_Completion_Status
1809: -- (status => 'NORMAL', message => NULL);
1810:
1811: WHEN OTHERS THEN
1812: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 1817: FND_CONCURRENT.Af_Rollback;

1813: FII_UTIL.Write_Log (
1814: 'Other error in FII_UDD1_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
1815:
1816:
1817: FND_CONCURRENT.Af_Rollback;
1818: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1819: retcode := sqlcode;
1820: ret_val := FND_CONCURRENT.Set_Completion_Status
1821: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1820: ret_val := FND_CONCURRENT.Set_Completion_Status

1816:
1817: FND_CONCURRENT.Af_Rollback;
1818: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD1_MAINTAIN_PKG.Incre_Update');
1819: retcode := sqlcode;
1820: ret_val := FND_CONCURRENT.Set_Completion_Status
1821: (status => 'ERROR', message => substr(sqlerrm,1,180));
1822:
1823: END Incre_Update;
1824: