DBA Data[Home] [Help]

APPS.FII_CC_MGR_SUP_C dependencies on FII_CC_MGR_SUP_C

Line 1: PACKAGE BODY FII_CC_MGR_SUP_C AS

1: PACKAGE BODY FII_CC_MGR_SUP_C AS
2: /*$Header: FIICMSCB.pls 115.12 2004/05/21 21:05:56 juding noship $*/
3:
4: g_phase VARCHAR2 (240);
5: g_fii_schema VARCHAR2 (120);

Line 53: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');

49:
50: BEGIN
51:
52: if g_debug_flag = 'Y' then
53: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
54: end if;
55:
56: ----------------------------------------------
57: -- Do set up for log file

Line 75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',

71: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
72: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
73: -- the log files and output files are written to
74: ----------------------------------------------------------------
75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',
76: 'FII_CC_MGR_SUP_C.out',l_dir, 'FII_GL_COMCCH_C');
77:
78: ----------------------------------------------------------
79: -- Find the schema owner of FII

Line 76: 'FII_CC_MGR_SUP_C.out',l_dir, 'FII_GL_COMCCH_C');

72: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
73: -- the log files and output files are written to
74: ----------------------------------------------------------------
75: FII_UTIL.initialize ('FII_CC_MGR_SUP_C.log',
76: 'FII_CC_MGR_SUP_C.out',l_dir, 'FII_GL_COMCCH_C');
77:
78: ----------------------------------------------------------
79: -- Find the schema owner of FII
80: ----------------------------------------------------------

Line 95: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');

91: ' Login ID: ' || g_fii_login_id);
92: end if;
93:
94: if g_debug_flag = 'Y' then
95: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
96: end if;
97:
98: EXCEPTION
99: WHEN G_LOGIN_INFO_NOT_AVABLE THEN

Line 101: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');

97:
98: EXCEPTION
99: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
100: FII_UTIL.put_line('Can not get User ID and Login ID, program exit');
101: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
102: raise;
103:
104: WHEN OTHERS THEN
105: FII_UTIL.put_line('

Line 109: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');

105: FII_UTIL.put_line('
106: Error in Procedure: INIT
107: Phase: '||g_phase||'
108: Message: '||sqlerrm);
109: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.FII_CC_MGR_SUP_C.INIT');
110: raise;
111: END Init;
112:
113: --**********************************************************************

Line 123: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Populate_HIER_TMP');

119:
120: BEGIN
121:
122: if g_debug_flag = 'Y' then
123: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Populate_HIER_TMP');
124: end if;
125:
126: g_phase := 'Initialize setups';
127: ------------------------------------------------

Line 300: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Populate_HIER_TMP');

296: FII_UTIL.print_timer('Duration');
297: end if;
298:
299: if g_debug_flag = 'Y' then
300: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Populate_HIER_TMP');
301: end if;
302:
303: Exception
304:

Line 307: ' of running FII_CC_MGR_SUP_C.Populate_HIER_TMP; '

303: Exception
304:
305: WHEN OTHERS Then
306: FII_UTIL.put_line('Error in phase ' || g_phase ||
307: ' of running FII_CC_MGR_SUP_C.Populate_HIER_TMP; '
308: || 'Message: ' || sqlerrm);
309: ROLLBACK;
310: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Populate_HIER_TMP');
311: raise;

Line 310: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Populate_HIER_TMP');

306: FII_UTIL.put_line('Error in phase ' || g_phase ||
307: ' of running FII_CC_MGR_SUP_C.Populate_HIER_TMP; '
308: || 'Message: ' || sqlerrm);
309: ROLLBACK;
310: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Populate_HIER_TMP');
311: raise;
312:
313: END Populate_HIER_TMP;
314:

Line 324: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Incre_Update');

320:
321: BEGIN
322:
323: if g_debug_flag = 'Y' then
324: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Incre_Update');
325: end if;
326:
327: ----------------------------------------------------------
328: --call to populate the table FII_CC_MGR_HIER_GT

Line 435: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Incre_Update');

431: FII_UTIL.print_timer('Duration');
432: end if;
433:
434: if g_debug_flag = 'Y' then
435: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Incre_Update');
436: end if;
437:
438: ----------------------------------------------------------------
439:

Line 446: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Incre_Update; '

442: WHEN OTHERS Then
443: errbuf := SQLERRM;
444: retcode := SQLCODE;
445: FII_UTIL.put_line('
446: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Incre_Update; '
447: || 'Message: ' || sqlerrm);
448: ROLLBACK;
449: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Incre_Update');
450: raise;

Line 449: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Incre_Update');

445: FII_UTIL.put_line('
446: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Incre_Update; '
447: || 'Message: ' || sqlerrm);
448: ROLLBACK;
449: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Incre_Update');
450: raise;
451:
452: END Incre_Update;
453:

Line 466: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Init_Load');

462:
463: BEGIN
464:
465: if g_debug_flag = 'Y' then
466: FII_MESSAGE.Func_Ent('FII_CC_MGR_SUP_C.Init_Load');
467: end if;
468:
469: ----------------------------------------------------------
470: --call to populate the table FII_CC_MGR_HIER_GT

Line 543: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Init_Load');

539: FII_UTIL.print_timer('Duration');
540: end if;
541:
542: if g_debug_flag = 'Y' then
543: FII_MESSAGE.Func_Succ('FII_CC_MGR_SUP_C.Init_Load');
544: end if;
545:
546: ----------------------------------------------------------------
547:

Line 553: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Init_Load; '

549: WHEN OTHERS THEN
550: errbuf := SQLERRM;
551: retcode := SQLCODE;
552: FII_UTIL.put_line('
553: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Init_Load; '
554: || 'Message: ' || sqlerrm);
555: ROLLBACK;
556: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Init_Load');
557: raise;

Line 556: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Init_Load');

552: FII_UTIL.put_line('
553: Error in phase ' || g_phase || ' of running FII_CC_MGR_SUP_C.Init_Load; '
554: || 'Message: ' || sqlerrm);
555: ROLLBACK;
556: FII_MESSAGE.Func_Fail('FII_CC_MGR_SUP_C.Init_Load');
557: raise;
558:
559: END Init_Load;
560:

Line 561: END FII_CC_MGR_SUP_C;

557: raise;
558:
559: END Init_Load;
560:
561: END FII_CC_MGR_SUP_C;