DBA Data[Home] [Help]

APPS.FII_PMV_HELPER_TABLES_C dependencies on FND_CONCURRENT

Line 226: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(

222: END IF;
223:
224: IF(G_CO_DBI_ENABLED_FLAG = 'N') THEN
225: l_count := l_count - 1;
226: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(
227: status => 'WARNING',
228: message => 'Company Dimension is not enabled.'
229: );
230: END IF;

Line 265: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(

261: END IF;
262:
263: IF(G_CC_DBI_ENABLED_FLAG = 'N') THEN
264: l_count := l_count - 1;
265: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(
266: status => 'WARNING',
267: message => 'Cost Center Dimension is not enabled.'
268: );
269: END IF;

Line 323: FND_CONCURRENT.Af_Rollback;

319:
320: Exception
321: When PMVH_fatal_err then
322: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Initialize : '|| 'User defined error');
323: FND_CONCURRENT.Af_Rollback;
324: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Initialize');
325: raise;
326:
327: When others then

Line 328: FND_CONCURRENT.Af_Rollback;

324: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Initialize');
325: raise;
326:
327: When others then
328: FND_CONCURRENT.Af_Rollback;
329: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
330: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
331: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
332: RAISE;

Line 562: --FND_CONCURRENT.Af_Commit;

558:
559: IF (FIIDIM_Debug) THEN
560: FII_MESSAGE.Func_Succ ('FII_PMV_HELPER_TABLES_C.populate_temp');
561: END IF;
562: --FND_CONCURRENT.Af_Commit;
563:
564: EXCEPTION
565: When others then
566: FND_CONCURRENT.Af_Rollback;

Line 566: FND_CONCURRENT.Af_Rollback;

562: --FND_CONCURRENT.Af_Commit;
563:
564: EXCEPTION
565: When others then
566: FND_CONCURRENT.Af_Rollback;
567: FII_UTIL.Write_Log ('Unexpected error when calling populate_temp...');
568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
569: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
570: raise;

Line 1027: FND_CONCURRENT.Af_Rollback;

1023: END IF;
1024:
1025: EXCEPTION
1026: When others then
1027: FND_CONCURRENT.Af_Rollback;
1028: FII_UTIL.Write_Log ('Unexpected error when calling Update_pruned_table...');
1029: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1030: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1031: raise;

Line 1130: FND_CONCURRENT.Af_Rollback;

1126: END IF;
1127:
1128: EXCEPTION
1129: When others then
1130: FND_CONCURRENT.Af_Rollback;
1131: FII_UTIL.Write_Log ('Unexpected error when calling update_viewby_flag...');
1132: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1133: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1134: raise;

Line 1586: FND_CONCURRENT.Af_Rollback;

1582: END If;
1583:
1584: EXCEPTION
1585: When others then
1586: FND_CONCURRENT.Af_Rollback;
1587: FII_UTIL.Write_Log ('Unexpected error when calling Populate_PMV_Helper_GT...');
1588: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1589: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
1590: raise;

Line 1822: FND_CONCURRENT.Af_Commit;

1818: tabname => 'FII_UDD1_PMV_AGRT_NODES');
1819:
1820: --==============================================================--
1821:
1822: FND_CONCURRENT.Af_Commit;
1823:
1824: IF (FIIDIM_Debug) THEN
1825: FII_MESSAGE.Func_Succ(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1826: END IF;

Line 1837: FND_CONCURRENT.Af_Rollback;

1833:
1834: FII_UTIL.Write_Log ('FII_PMV_HELPER_TABLES_C.Load_Main: '||
1835: 'User defined error');
1836:
1837: FND_CONCURRENT.Af_Rollback;
1838: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1839: retcode := sqlcode;
1840: ret_val := FND_CONCURRENT.Set_Completion_Status
1841: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1840: ret_val := FND_CONCURRENT.Set_Completion_Status

1836:
1837: FND_CONCURRENT.Af_Rollback;
1838: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1839: retcode := sqlcode;
1840: ret_val := FND_CONCURRENT.Set_Completion_Status
1841: (status => 'ERROR', message => substr(sqlerrm,1,180));
1842:
1843: WHEN OTHERS THEN
1844: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 1848: FND_CONCURRENT.Af_Rollback;

1844: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1845: FII_UTIL.Write_Log (
1846: 'Other error in FII_PMV_HELPER_TABLES_C.Load_Main: ' || substr(sqlerrm,1,180));
1847:
1848: FND_CONCURRENT.Af_Rollback;
1849: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1850: retcode := sqlcode;
1851: ret_val := FND_CONCURRENT.Set_Completion_Status
1852: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1851: ret_val := FND_CONCURRENT.Set_Completion_Status

1847:
1848: FND_CONCURRENT.Af_Rollback;
1849: FII_MESSAGE.Func_Fail(func_name => 'FII_PMV_HELPER_TABLES_C.Load_Main');
1850: retcode := sqlcode;
1851: ret_val := FND_CONCURRENT.Set_Completion_Status
1852: (status => 'ERROR', message => substr(sqlerrm,1,180));
1853:
1854: END Load_Main;
1855: