DBA Data[Home] [Help]

APPS.FII_UDD2_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_2');
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 UDIM2_fatal_err then
315: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Initialize : '|| 'User defined error');
316: FND_CONCURRENT.Af_Rollback;
317: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Initialize');
318: raise;
319:
320: When others then

Line 465: FND_CONCURRENT.Af_Rollback;

461: FII_UTIL.Write_Log ('FII_UDD2_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_UDD2_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
467: raise;
468:
469: When others then

Line 678: FND_CONCURRENT.Af_Commit; --commit

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

Line 1434: FND_CONCURRENT.Af_Commit;

1430: tabname => 'MLOG$_FII_UDD2_MAPPINGS');
1431:
1432: --=====================================================================
1433:
1434: FND_CONCURRENT.Af_Commit;
1435:
1436: IF (FIIDIM_Debug) THEN
1437: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1438: END IF;

Line 1449: FND_CONCURRENT.Af_Rollback;

1445:
1446: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||
1447: 'User defined error');
1448:
1449: FND_CONCURRENT.Af_Rollback;
1450: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1451: retcode := sqlcode;
1452: ret_val := FND_CONCURRENT.Set_Completion_Status
1453: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1452: ret_val := FND_CONCURRENT.Set_Completion_Status

1448:
1449: FND_CONCURRENT.Af_Rollback;
1450: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1451: retcode := sqlcode;
1452: ret_val := FND_CONCURRENT.Set_Completion_Status
1453: (status => 'ERROR', message => substr(sqlerrm,1,180));
1454:
1455: WHEN UDIM2_MULT_PAR_err THEN
1456: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||

Line 1459: FND_CONCURRENT.Af_Rollback;

1455: WHEN UDIM2_MULT_PAR_err THEN
1456: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Init_Load: '||
1457: 'Diamond Shape Detected');
1458:
1459: FND_CONCURRENT.Af_Rollback;
1460: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1461: retcode := sqlcode;
1462: ret_val := FND_CONCURRENT.Set_Completion_Status
1463: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1462: ret_val := FND_CONCURRENT.Set_Completion_Status

1458:
1459: FND_CONCURRENT.Af_Rollback;
1460: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1461: retcode := sqlcode;
1462: ret_val := FND_CONCURRENT.Set_Completion_Status
1463: (status => 'ERROR', message => substr(sqlerrm,1,180));
1464:
1465: WHEN UDIM2_NOT_ENABLED THEN
1466: FII_UTIL.Write_Log ('>>> UDD2 Dimension Not Enabled...');

Line 1471: --ret_val := FND_CONCURRENT.Set_Completion_Status

1467:
1468: Handle_Unenabled_DIM;
1469:
1470: retcode := sqlcode;
1471: --ret_val := FND_CONCURRENT.Set_Completion_Status
1472: -- (status => 'NORMAL', message => NULL);
1473:
1474: WHEN OTHERS THEN
1475: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1480: FND_CONCURRENT.Af_Rollback;

1476: FII_UTIL.Write_Log (
1477: 'Other error in FII_UDD2_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
1478:
1479:
1480: FND_CONCURRENT.Af_Rollback;
1481: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1482: retcode := sqlcode;
1483: ret_val := FND_CONCURRENT.Set_Completion_Status
1484: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1483: ret_val := FND_CONCURRENT.Set_Completion_Status

1479:
1480: FND_CONCURRENT.Af_Rollback;
1481: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Init_Load');
1482: retcode := sqlcode;
1483: ret_val := FND_CONCURRENT.Set_Completion_Status
1484: (status => 'ERROR', message => substr(sqlerrm,1,180));
1485:
1486: END Init_Load;
1487:

Line 1757: FND_CONCURRENT.Af_Commit;

1753:
1754: --=====================================================================
1755:
1756:
1757: FND_CONCURRENT.Af_Commit;
1758:
1759: IF (FIIDIM_Debug) THEN
1760: FII_MESSAGE.Func_Succ(func_name => 'FII_UDD2_MAINTAIN_PKG.Incre_Load');
1761: END IF;

Line 1770: FND_CONCURRENT.Af_Rollback;

1766: WHEN UDIM2_fatal_err THEN
1767: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update'||
1768: 'User defined error');
1769:
1770: FND_CONCURRENT.Af_Rollback;
1771: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_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:
1770: FND_CONCURRENT.Af_Rollback;
1771: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_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 UDIM2_MULT_PAR_err THEN
1777: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update: '||

Line 1780: FND_CONCURRENT.Af_Rollback;

1776: WHEN UDIM2_MULT_PAR_err THEN
1777: FII_UTIL.Write_Log ('FII_UDD2_MAINTAIN_PKG.Incre_Update: '||
1778: 'Diamond Shape Detected');
1779:
1780: FND_CONCURRENT.Af_Rollback;
1781: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Incre_Update');
1782: retcode := sqlcode;
1783: ret_val := FND_CONCURRENT.Set_Completion_Status
1784: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1783: ret_val := FND_CONCURRENT.Set_Completion_Status

1779:
1780: FND_CONCURRENT.Af_Rollback;
1781: FII_MESSAGE.Func_Fail(func_name => 'FII_UDD2_MAINTAIN_PKG.Incre_Update');
1782: retcode := sqlcode;
1783: ret_val := FND_CONCURRENT.Set_Completion_Status
1784: (status => 'ERROR', message => substr(sqlerrm,1,180));
1785:
1786: WHEN UDIM2_NOT_ENABLED THEN
1787: FII_UTIL.Write_Log ('>>> User Defined Dimension2 Not Enabled...');

Line 1792: --ret_val := FND_CONCURRENT.Set_Completion_Status

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

Line 1801: FND_CONCURRENT.Af_Rollback;

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

Line 1804: ret_val := FND_CONCURRENT.Set_Completion_Status

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