eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_FIN_CAT_MAINTAIN_PKG dependencies on FND_CONCURRENT

Line 203: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(

199: l_check :=
200: FII_EXCEPTION_CHECK_PKG.detect_unmapped_local_vs(g_dimension_name);
201:
202: if l_check > 0 then
203: l_bool_ret := FND_CONCURRENT.Set_Completion_Status(
204: status => 'WARNING',
205: message => 'Detected unmapped local value set.'
206: );
207: elsif l_check < 0 then

Line 326: FND_CONCURRENT.Af_Rollback;

322: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Initialize : '||
323: 'User defined error');
324: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
325: -- Rollback
326: FND_CONCURRENT.Af_Rollback;
327: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Initialize');
328: raise;
329:
330: When others then

Line 482: FND_CONCURRENT.Af_Rollback;

478: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||
479: 'User defined error');
480: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
481: -- Rollback
482: FND_CONCURRENT.Af_Rollback;
483: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
484: raise;
485:
486: When others then

Line 697: FND_CONCURRENT.Af_Commit;

693: /* Deleting parent from the gt table */
694: delete from FII_DIM_HIER_HELP_GT where idx = g_index;
695: g_index := g_index - 1;
696:
697: FND_CONCURRENT.Af_Commit;
698:
699: EXCEPTION
700: WHEN NO_DATA_FOUND Then
701: FII_UTIL.WRITE_LOG ('Insert Immediate child: No Data Found');

Line 1973: commit; --FND_CONCURRENT.Af_Commit;

1969: FND_STATS.gather_table_stats
1970: (ownname => g_schema_name,
1971: tabname => 'MLOG$_FII_FIN_ITEM_LEAF_HI');
1972:
1973: commit; --FND_CONCURRENT.Af_Commit;
1974:
1975: IF (FIIDIM_Debug) THEN
1976: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1977: END IF;

Line 1979: -- ret_val := FND_CONCURRENT.Set_Completion_Status

1975: IF (FIIDIM_Debug) THEN
1976: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1977: END IF;
1978:
1979: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1980: -- (status => 'NORMAL', message => NULL);
1981:
1982: -- Exception handling
1983: EXCEPTION

Line 1990: rollback; --FND_CONCURRENT.Af_Rollback;

1986: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1988: 'User defined error');
1989: -- Rollback
1990: rollback; --FND_CONCURRENT.Af_Rollback;
1991: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1992: retcode := sqlcode;
1993: ret_val := FND_CONCURRENT.Set_Completion_Status
1994: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 1993: ret_val := FND_CONCURRENT.Set_Completion_Status

1989: -- Rollback
1990: rollback; --FND_CONCURRENT.Af_Rollback;
1991: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1992: retcode := sqlcode;
1993: ret_val := FND_CONCURRENT.Set_Completion_Status
1994: (status => 'ERROR', message => substr(sqlerrm,1,180));
1995:
1996: WHEN FINDIM_MULT_PAR_err THEN
1997: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 2001: rollback; --FND_CONCURRENT.Af_Rollback;

1997: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1999: 'Diamond Shape Detected');
2000: -- Rollback
2001: rollback; --FND_CONCURRENT.Af_Rollback;
2002: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2003: retcode := sqlcode;
2004: ret_val := FND_CONCURRENT.Set_Completion_Status
2005: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2004: ret_val := FND_CONCURRENT.Set_Completion_Status

2000: -- Rollback
2001: rollback; --FND_CONCURRENT.Af_Rollback;
2002: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2003: retcode := sqlcode;
2004: ret_val := FND_CONCURRENT.Set_Completion_Status
2005: (status => 'ERROR', message => substr(sqlerrm,1,180));
2006:
2007: WHEN FINDIM_Invalid_FC_ASG_err then
2008: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 2012: rollback; --FND_CONCURRENT.Af_Rollback;

2008: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
2010: 'Invalid FC Type Assignment Detected');
2011: -- Rollback
2012: rollback; --FND_CONCURRENT.Af_Rollback;
2013: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2014: retcode := sqlcode;
2015: ret_val := FND_CONCURRENT.Set_Completion_Status
2016: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2015: ret_val := FND_CONCURRENT.Set_Completion_Status

2011: -- Rollback
2012: rollback; --FND_CONCURRENT.Af_Rollback;
2013: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2014: retcode := sqlcode;
2015: ret_val := FND_CONCURRENT.Set_Completion_Status
2016: (status => 'ERROR', message => substr(sqlerrm,1,180));
2017:
2018: WHEN FINDIM_NOT_ENABLED THEN
2019: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 2025: -- ret_val := FND_CONCURRENT.Set_Completion_Status

2021:
2022: Handle_Unenabled_DIM;
2023:
2024: retcode := sqlcode;
2025: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2026: -- (status => 'NORMAL', message => NULL);
2027:
2028: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2029: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

Line 2032: rollback; --FND_CONCURRENT.Af_Rollback;

2028: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2029: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2030: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2031: -- Rollback
2032: rollback; --FND_CONCURRENT.Af_Rollback;
2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2034: retcode := sqlcode;
2035: ret_val := FND_CONCURRENT.Set_Completion_Status
2036: (status => 'ERROR',

Line 2035: ret_val := FND_CONCURRENT.Set_Completion_Status

2031: -- Rollback
2032: rollback; --FND_CONCURRENT.Af_Rollback;
2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2034: retcode := sqlcode;
2035: ret_val := FND_CONCURRENT.Set_Completion_Status
2036: (status => 'ERROR',
2037: message => 'No Financial Category Type assignment is done.');
2038:
2039: WHEN OTHERS THEN

Line 2044: rollback; --FND_CONCURRENT.Af_Rollback;

2040: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2041: FII_UTIL.Write_Log(
2042: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
2043: -- Rollback
2044: rollback; --FND_CONCURRENT.Af_Rollback;
2045: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2046: retcode := sqlcode;
2047: ret_val := FND_CONCURRENT.Set_Completion_Status
2048: (status => 'ERROR', message => NULL);

Line 2047: ret_val := FND_CONCURRENT.Set_Completion_Status

2043: -- Rollback
2044: rollback; --FND_CONCURRENT.Af_Rollback;
2045: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2046: retcode := sqlcode;
2047: ret_val := FND_CONCURRENT.Set_Completion_Status
2048: (status => 'ERROR', message => NULL);
2049:
2050: END Init_Load;
2051:

Line 2605: commit; --FND_CONCURRENT.Af_Commit;

2601: -- FND_STATS.gather_table_stats
2602: -- (ownname => g_schema_name,
2603: -- tabname => 'MLOG$_FII_FIN_ITEM_LEAF_HI');
2604:
2605: commit; --FND_CONCURRENT.Af_Commit;
2606:
2607: IF (FIIDIM_Debug) THEN
2608: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');
2609: END IF;

Line 2611: -- ret_val := FND_CONCURRENT.Set_Completion_Status

2607: IF (FIIDIM_Debug) THEN
2608: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');
2609: END IF;
2610:
2611: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2612: -- (status => 'NORMAL', message => NULL);
2613:
2614: -- Exception handling
2615: EXCEPTION

Line 2621: rollback; --FND_CONCURRENT.Af_Rollback;

2617: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||
2619: 'User defined error');
2620: -- Rollback
2621: rollback; --FND_CONCURRENT.Af_Rollback;
2622: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2623: retcode := sqlcode;
2624: ret_val := FND_CONCURRENT.Set_Completion_Status
2625: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2624: ret_val := FND_CONCURRENT.Set_Completion_Status

2620: -- Rollback
2621: rollback; --FND_CONCURRENT.Af_Rollback;
2622: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2623: retcode := sqlcode;
2624: ret_val := FND_CONCURRENT.Set_Completion_Status
2625: (status => 'ERROR', message => substr(sqlerrm,1,180));
2626:
2627: WHEN FINDIM_MULT_PAR_err THEN
2628: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 2632: rollback; --FND_CONCURRENT.Af_Rollback;

2628: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2630: 'Diamond Shape Detected');
2631: -- Rollback
2632: rollback; --FND_CONCURRENT.Af_Rollback;
2633: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2634: retcode := sqlcode;
2635: ret_val := FND_CONCURRENT.Set_Completion_Status
2636: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2635: ret_val := FND_CONCURRENT.Set_Completion_Status

2631: -- Rollback
2632: rollback; --FND_CONCURRENT.Af_Rollback;
2633: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2634: retcode := sqlcode;
2635: ret_val := FND_CONCURRENT.Set_Completion_Status
2636: (status => 'ERROR', message => substr(sqlerrm,1,180));
2637:
2638: WHEN FINDIM_Invalid_FC_ASG_err then
2639: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 2643: rollback; --FND_CONCURRENT.Af_Rollback;

2639: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2641: 'Invalid FC Type Assignment Detected');
2642: -- Rollback
2643: rollback; --FND_CONCURRENT.Af_Rollback;
2644: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2645: retcode := sqlcode;
2646: ret_val := FND_CONCURRENT.Set_Completion_Status
2647: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2646: ret_val := FND_CONCURRENT.Set_Completion_Status

2642: -- Rollback
2643: rollback; --FND_CONCURRENT.Af_Rollback;
2644: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2645: retcode := sqlcode;
2646: ret_val := FND_CONCURRENT.Set_Completion_Status
2647: (status => 'ERROR', message => substr(sqlerrm,1,180));
2648:
2649: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2650: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 2653: rollback; --FND_CONCURRENT.Af_Rollback;

2649: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
2650: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2651: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2652: -- Rollback
2653: rollback; --FND_CONCURRENT.Af_Rollback;
2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2655: retcode := sqlcode;
2656: ret_val := FND_CONCURRENT.Set_Completion_Status
2657: (status => 'ERROR',

Line 2656: ret_val := FND_CONCURRENT.Set_Completion_Status

2652: -- Rollback
2653: rollback; --FND_CONCURRENT.Af_Rollback;
2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2655: retcode := sqlcode;
2656: ret_val := FND_CONCURRENT.Set_Completion_Status
2657: (status => 'ERROR',
2658: message => 'No Financial Category Type assignment is done.');
2659:
2660: WHEN FINDIM_NOT_ENABLED THEN

Line 2667: -- ret_val := FND_CONCURRENT.Set_Completion_Status

2663:
2664: Handle_Unenabled_DIM;
2665:
2666: retcode := sqlcode;
2667: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2668: -- (status => 'NORMAL', message => NULL);
2669:
2670: WHEN OTHERS THEN
2671: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

Line 2675: rollback; --FND_CONCURRENT.Af_Rollback;

2671: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2672: FII_UTIL.Write_Log(
2673: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
2674: -- Rollback
2675: rollback; --FND_CONCURRENT.Af_Rollback;
2676: FII_MESSAGE.Func_Fail(func_name => 'II_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2677: retcode := sqlcode;
2678: ret_val := FND_CONCURRENT.Set_Completion_Status
2679: (status => 'ERROR', message => substr(sqlerrm,1,180));

Line 2678: ret_val := FND_CONCURRENT.Set_Completion_Status

2674: -- Rollback
2675: rollback; --FND_CONCURRENT.Af_Rollback;
2676: FII_MESSAGE.Func_Fail(func_name => 'II_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2677: retcode := sqlcode;
2678: ret_val := FND_CONCURRENT.Set_Completion_Status
2679: (status => 'ERROR', message => substr(sqlerrm,1,180));
2680:
2681: END Incre_Update;
2682: