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_SNAP_TBL_REFRESH dependencies on FII_UTIL

Line 42: l_dir := FII_UTIL.get_utl_file_dir;

38: -- Set default directory in CASE if the profile option
39: -- BIS_DEBUG_LOG_DIRECTORY is not set up
40: ------------------------------------------------------
41: if l_dir is NULL THEN
42: l_dir := FII_UTIL.get_utl_file_dir;
43: end if;
44:
45: ----------------------------------------------------------------
46: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

Line 46: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

42: l_dir := FII_UTIL.get_utl_file_dir;
43: end if;
44:
45: ----------------------------------------------------------------
46: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
47: -- AND BIS_DEBUG_LOG_DIRECTORY AND set up the directory WHERE
48: -- the log files AND output files are written to
49: ----------------------------------------------------------------
50: FII_UTIL.initialize('FII_SNAP_TBL_REFRESH.log',

Line 50: FII_UTIL.initialize('FII_SNAP_TBL_REFRESH.log',

46: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
47: -- AND BIS_DEBUG_LOG_DIRECTORY AND set up the directory WHERE
48: -- the log files AND output files are written to
49: ----------------------------------------------------------------
50: FII_UTIL.initialize('FII_SNAP_TBL_REFRESH.log',
51: 'FII_SNAP_TBL_REFRESH.out',l_dir,
52: 'FII_SNAP_TBL_REFRESH');
53:
54: g_phase := 'Obtain FII schema name AND other info';

Line 57: g_schema_name := FII_UTIL.get_schema_name ('FII');

53:
54: g_phase := 'Obtain FII schema name AND other info';
55:
56: -- Obtain FII schema name
57: g_schema_name := FII_UTIL.get_schema_name ('FII');
58:
59: -- Obtain user ID, login ID AND sysdate
60: g_fii_user_id := FND_GLOBAL.USER_ID;
61: g_fii_login_id := FND_GLOBAL.LOGIN_ID;

Line 68: FII_UTIL.Write_Log ('>>> Failed Intialization (login info not available)');

64:
65: g_phase := 'Check FII schema name AND other info';
66: -- If any of the above values is not set, error out
67: IF (g_fii_user_id is NULL OR g_fii_login_id is NULL) THEN
68: FII_UTIL.Write_Log ('>>> Failed Intialization (login info not available)');
69: RAISE G_LOGIN_INFO_NOT_AVABLE;
70: END IF;
71:
72: -- Determine if process will be run in debug mode

Line 74: FII_UTIL.Write_Log ('Debug On');

70: END IF;
71:
72: -- Determine if process will be run in debug mode
73: IF g_debug_flag = 'Y' THEN
74: FII_UTIL.Write_Log ('Debug On');
75: ELSE
76: FII_UTIL.Write_Log ('Debug Off');
77: END IF;
78:

Line 76: FII_UTIL.Write_Log ('Debug Off');

72: -- Determine if process will be run in debug mode
73: IF g_debug_flag = 'Y' THEN
74: FII_UTIL.Write_Log ('Debug On');
75: ELSE
76: FII_UTIL.Write_Log ('Debug Off');
77: END IF;
78:
79: IF g_debug_flag = 'Y' THEN
80: FII_UTIL.Write_Log ('Initialize: Now start processing... ');

Line 80: FII_UTIL.Write_Log ('Initialize: Now start processing... ');

76: FII_UTIL.Write_Log ('Debug Off');
77: END IF;
78:
79: IF g_debug_flag = 'Y' THEN
80: FII_UTIL.Write_Log ('Initialize: Now start processing... ');
81: End If;
82:
83: Exception
84:

Line 86: FII_UTIL.Write_Log ('Unexpected error WHEN calling Initialize...');

82:
83: Exception
84:
85: When others THEN
86: FII_UTIL.Write_Log ('Unexpected error WHEN calling Initialize...');
87: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
88: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
89: RAISE;
90:

Line 87: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

83: Exception
84:
85: When others THEN
86: FII_UTIL.Write_Log ('Unexpected error WHEN calling Initialize...');
87: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
88: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
89: RAISE;
90:
91: END Initialize;

Line 88: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));

84:
85: When others THEN
86: FII_UTIL.Write_Log ('Unexpected error WHEN calling Initialize...');
87: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
88: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
89: RAISE;
90:
91: END Initialize;
92:

Line 114: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_F');

110: BEGIN
111:
112: g_phase := 'Entering REFRESH_GL_SNAP_F';
113: IF g_debug_flag = 'Y' THEN
114: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_F');
115: FII_UTIL.start_timer();
116: END IF;
117:
118: -- Find out if this is commercial or government install

Line 115: FII_UTIL.start_timer();

111:
112: g_phase := 'Entering REFRESH_GL_SNAP_F';
113: IF g_debug_flag = 'Y' THEN
114: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_F');
115: FII_UTIL.start_timer();
116: END IF;
117:
118: -- Find out if this is commercial or government install
119: g_phase := 'Find out if this is commercial or government install';

Line 160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);

156:
157: FROM DUAL;
158:
159: IF g_debug_flag = 'Y' THEN
160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);

Line 161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);

157: FROM DUAL;
158:
159: IF g_debug_flag = 'Y' THEN
160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);

Line 162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);

158:
159: IF g_debug_flag = 'Y' THEN
160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);
166: FII_UTIL.Write_Log (' ');

Line 163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);

159: IF g_debug_flag = 'Y' THEN
160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);
166: FII_UTIL.Write_Log (' ');
167: END IF;

Line 164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);

160: FII_UTIL.Write_Log ('>> l_this_date = ' || l_this_date);
161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);
166: FII_UTIL.Write_Log (' ');
167: END IF;
168:

Line 165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);

161: FII_UTIL.Write_Log ('>> l_pp_this_date = ' || l_pp_this_date);
162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);
166: FII_UTIL.Write_Log (' ');
167: END IF;
168:
169: --Always do a full refresh for snapshot tables

Line 166: FII_UTIL.Write_Log (' ');

162: FII_UTIL.Write_Log ('>> l_pq_this_date = ' || l_pq_this_date);
163: FII_UTIL.Write_Log ('>> l_ly_this_date = ' || l_ly_this_date);
164: FII_UTIL.Write_Log ('>> l_this_date_gov = ' || l_this_date_gov);
165: FII_UTIL.Write_Log ('>> l_industry_pf = ' || l_industry_pf);
166: FII_UTIL.Write_Log (' ');
167: END IF;
168:
169: --Always do a full refresh for snapshot tables
170: g_phase := 'Truncate table FII_GL_SNAP_F';

Line 171: FII_UTIL.truncate_table ('FII_GL_SNAP_F', 'FII', g_retcode);

167: END IF;
168:
169: --Always do a full refresh for snapshot tables
170: g_phase := 'Truncate table FII_GL_SNAP_F';
171: FII_UTIL.truncate_table ('FII_GL_SNAP_F', 'FII', g_retcode);
172:
173: g_phase := 'Starting to populate table FII_GL_SNAP_F';
174: IF g_debug_flag = 'Y' THEN
175: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_F');

Line 175: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_F');

171: FII_UTIL.truncate_table ('FII_GL_SNAP_F', 'FII', g_retcode);
172:
173: g_phase := 'Starting to populate table FII_GL_SNAP_F';
174: IF g_debug_flag = 'Y' THEN
175: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_F');
176: END IF;
177:
178:
179: --------------------------------------------------------------------------

Line 716: FII_UTIL.stop_timer();

712: GROUP BY b.company_dim_id, b.cost_center_dim_id, b.fin_category_id,
713: b.user_dim1_id, b.user_dim2_id, ledger_id, b.posted_date;
714:
715: IF g_debug_flag = 'Y' THEN
716: FII_UTIL.stop_timer();
717: FII_UTIL.Write_Log ('FII_GL_SNAP_F has been populated successfully');
718: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
719: FII_UTIL.print_timer();
720: END IF;

Line 717: FII_UTIL.Write_Log ('FII_GL_SNAP_F has been populated successfully');

713: b.user_dim1_id, b.user_dim2_id, ledger_id, b.posted_date;
714:
715: IF g_debug_flag = 'Y' THEN
716: FII_UTIL.stop_timer();
717: FII_UTIL.Write_Log ('FII_GL_SNAP_F has been populated successfully');
718: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
719: FII_UTIL.print_timer();
720: END IF;
721:

Line 718: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');

714:
715: IF g_debug_flag = 'Y' THEN
716: FII_UTIL.stop_timer();
717: FII_UTIL.Write_Log ('FII_GL_SNAP_F has been populated successfully');
718: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
719: FII_UTIL.print_timer();
720: END IF;
721:
722: g_phase := 'Gather table stats for FII_GL_SNAP_F';

Line 719: FII_UTIL.print_timer();

715: IF g_debug_flag = 'Y' THEN
716: FII_UTIL.stop_timer();
717: FII_UTIL.Write_Log ('FII_GL_SNAP_F has been populated successfully');
718: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
719: FII_UTIL.print_timer();
720: END IF;
721:
722: g_phase := 'Gather table stats for FII_GL_SNAP_F';
723: fnd_stats.gather_table_stats (ownname=>g_schema_name,

Line 730: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_F');

726: g_phase := 'Commit the change';
727: commit;
728:
729: IF g_debug_flag = 'Y' THEN
730: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_F');
731: FII_UTIL.Write_Log (' ');
732: END IF;
733:
734: EXCEPTION

Line 731: FII_UTIL.Write_Log (' ');

727: commit;
728:
729: IF g_debug_flag = 'Y' THEN
730: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_F');
731: FII_UTIL.Write_Log (' ');
732: END IF;
733:
734: EXCEPTION
735: -- Bug 4174859. Handled no data found exception.

Line 743: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_F ');

739: token_num => 0);
740: raise;
741:
742: WHEN OTHERS THEN
743: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_F ');
744: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
745: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
746: rollback;
747: raise;

Line 744: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

740: raise;
741:
742: WHEN OTHERS THEN
743: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_F ');
744: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
745: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
746: rollback;
747: raise;
748:

Line 745: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));

741:
742: WHEN OTHERS THEN
743: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_F ');
744: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
745: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
746: rollback;
747: raise;
748:
749: END REFRESH_GL_SNAP_F;

Line 766: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_SUM_F');

762: BEGIN
763:
764: g_phase := 'Entering REFRESH_GL_SNAP_SUM_F';
765: IF g_debug_flag = 'Y' THEN
766: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_SUM_F');
767: FII_UTIL.start_timer();
768: END IF;
769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';

Line 767: FII_UTIL.start_timer();

763:
764: g_phase := 'Entering REFRESH_GL_SNAP_SUM_F';
765: IF g_debug_flag = 'Y' THEN
766: FII_UTIL.Write_Log ('> Entering REFRESH_GL_SNAP_SUM_F');
767: FII_UTIL.start_timer();
768: END IF;
769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';
771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);

Line 771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);

767: FII_UTIL.start_timer();
768: END IF;
769:
770: g_phase := 'Truncate table FII_GL_SNAP_SUM_F';
771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');

Line 775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');

771: FII_UTIL.truncate_table ('FII_GL_SNAP_SUM_F', 'FII', g_retcode);
772:
773: g_phase := 'Starting to populate table FII_GL_SNAP_SUM_F';
774: IF g_debug_flag = 'Y' THEN
775: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_SNAP_SUM_F');
776: END IF;
777:
778: insert /*+ append */ INTO FII_GL_SNAP_SUM_F
779: (

Line 1049: FII_UTIL.stop_timer();

1045: b.USER_DIM2_ID,
1046: b.posted_date;
1047:
1048: IF g_debug_flag = 'Y' THEN
1049: FII_UTIL.stop_timer();
1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );
1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;

Line 1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );

1046: b.posted_date;
1047:
1048: IF g_debug_flag = 'Y' THEN
1049: FII_UTIL.stop_timer();
1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );
1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;
1054:

Line 1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');

1047:
1048: IF g_debug_flag = 'Y' THEN
1049: FII_UTIL.stop_timer();
1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );
1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;
1054:
1055: g_phase := 'Gather table stats for FII_GL_SNAP_SUM_F';

Line 1052: FII_UTIL.print_timer();

1048: IF g_debug_flag = 'Y' THEN
1049: FII_UTIL.stop_timer();
1050: FII_UTIL.Write_Log ( 'FII_GL_SNAP_SUM_F has been populated successfully' );
1051: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1052: FII_UTIL.print_timer();
1053: END IF;
1054:
1055: g_phase := 'Gather table stats for FII_GL_SNAP_SUM_F';
1056: fnd_stats.gather_table_stats (ownname=>g_schema_name,

Line 1063: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_SUM_F');

1059: g_phase := 'Commit the change';
1060: commit;
1061:
1062: IF g_debug_flag = 'Y' THEN
1063: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_SUM_F');
1064: FII_UTIL.Write_Log (' ');
1065: END IF;
1066:
1067: EXCEPTION

Line 1064: FII_UTIL.Write_Log (' ');

1060: commit;
1061:
1062: IF g_debug_flag = 'Y' THEN
1063: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_SNAP_SUM_F');
1064: FII_UTIL.Write_Log (' ');
1065: END IF;
1066:
1067: EXCEPTION
1068:

Line 1070: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_SUM_F ');

1066:
1067: EXCEPTION
1068:
1069: WHEN OTHERS THEN
1070: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_SUM_F ');
1071: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1072: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1073: rollback;
1074: raise;

Line 1071: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

1067: EXCEPTION
1068:
1069: WHEN OTHERS THEN
1070: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_SUM_F ');
1071: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1072: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1073: rollback;
1074: raise;
1075:

Line 1072: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));

1068:
1069: WHEN OTHERS THEN
1070: FII_UTIL.Write_Log ('Other error in REFRESH_GL_SNAP_SUM_F ');
1071: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1072: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1073: rollback;
1074: raise;
1075:
1076: END REFRESH_GL_SNAP_SUM_F;

Line 1095: FII_UTIL.Write_Log ('> Entering REFRESH_GL_LOCAL_SNAP_F');

1091: BEGIN
1092:
1093: g_phase := 'Entering REFRESH_GL_LOCAL_SNAP_F';
1094: IF g_debug_flag = 'Y' THEN
1095: FII_UTIL.Write_Log ('> Entering REFRESH_GL_LOCAL_SNAP_F');
1096: FII_UTIL.start_timer();
1097: END IF;
1098:
1099: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';

Line 1096: FII_UTIL.start_timer();

1092:
1093: g_phase := 'Entering REFRESH_GL_LOCAL_SNAP_F';
1094: IF g_debug_flag = 'Y' THEN
1095: FII_UTIL.Write_Log ('> Entering REFRESH_GL_LOCAL_SNAP_F');
1096: FII_UTIL.start_timer();
1097: END IF;
1098:
1099: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
1100:

Line 1118: FII_UTIL.Write_Log ('>> l_this_date = '|| l_this_date);

1114: FROM fii_time_ent_year
1115: WHERE l_this_date between start_date AND end_date;
1116:
1117: IF g_debug_flag = 'Y' THEN
1118: FII_UTIL.Write_Log ('>> l_this_date = '|| l_this_date);
1119: FII_UTIL.Write_Log ('>> l_year_id = ' || l_year_id);
1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:

Line 1119: FII_UTIL.Write_Log ('>> l_year_id = ' || l_year_id);

1115: WHERE l_this_date between start_date AND end_date;
1116:
1117: IF g_debug_flag = 'Y' THEN
1118: FII_UTIL.Write_Log ('>> l_this_date = '|| l_this_date);
1119: FII_UTIL.Write_Log ('>> l_year_id = ' || l_year_id);
1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';

Line 1120: FII_UTIL.Write_Log (' ');

1116:
1117: IF g_debug_flag = 'Y' THEN
1118: FII_UTIL.Write_Log ('>> l_this_date = '|| l_this_date);
1119: FII_UTIL.Write_Log ('>> l_year_id = ' || l_year_id);
1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';
1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);

Line 1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);

1120: FII_UTIL.Write_Log (' ');
1121: END IF;
1122:
1123: g_phase := 'Truncate table FII_GL_LOCAL_SNAP_F';
1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');

Line 1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');

1124: FII_UTIL.truncate_table ('FII_GL_LOCAL_SNAP_F', 'FII', g_retcode);
1125:
1126: g_phase := 'Starting to populate table FII_GL_LOCAL_SNAP_F';
1127: IF g_debug_flag = 'Y' THEN
1128: FII_UTIL.Write_Log ('>> Starting to populate table FII_GL_LOCAL_SNAP_F');
1129: END IF;
1130:
1131: l_profile := NVL(FND_PROFILE.VALUE('INDUSTRY'),'C');
1132:

Line 1949: FII_UTIL.stop_timer();

1945: END IF;
1946:
1947:
1948: IF g_debug_flag = 'Y' THEN
1949: FII_UTIL.stop_timer();
1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );
1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;

Line 1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );

1946:
1947:
1948: IF g_debug_flag = 'Y' THEN
1949: FII_UTIL.stop_timer();
1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );
1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;
1954:

Line 1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');

1947:
1948: IF g_debug_flag = 'Y' THEN
1949: FII_UTIL.stop_timer();
1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );
1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;
1954:
1955: g_phase := 'Gather table stats for FII_GL_LOCAL_SNAP_F';

Line 1952: FII_UTIL.print_timer();

1948: IF g_debug_flag = 'Y' THEN
1949: FII_UTIL.stop_timer();
1950: FII_UTIL.Write_Log ( 'FII_GL_LOCAL_SNAP_F has been populated successfully' );
1951: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
1952: FII_UTIL.print_timer();
1953: END IF;
1954:
1955: g_phase := 'Gather table stats for FII_GL_LOCAL_SNAP_F';
1956: fnd_stats.gather_table_stats (ownname=>g_schema_name,

Line 1963: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_LOCAL_SNAP_F');

1959: g_phase := 'Commit the change';
1960: commit;
1961:
1962: IF g_debug_flag = 'Y' THEN
1963: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_LOCAL_SNAP_F');
1964: FII_UTIL.Write_Log (' ');
1965: END IF;
1966:
1967: EXCEPTION

Line 1964: FII_UTIL.Write_Log (' ');

1960: commit;
1961:
1962: IF g_debug_flag = 'Y' THEN
1963: FII_UTIL.Write_Log ('< Leaving REFRESH_GL_LOCAL_SNAP_F');
1964: FII_UTIL.Write_Log (' ');
1965: END IF;
1966:
1967: EXCEPTION
1968:

Line 1970: FII_UTIL.Write_Log ('Other error in REFRESH_GL_LOCAL_SNAP_F ');

1966:
1967: EXCEPTION
1968:
1969: WHEN OTHERS THEN
1970: FII_UTIL.Write_Log ('Other error in REFRESH_GL_LOCAL_SNAP_F ');
1971: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1972: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1973: rollback;
1974: raise;

Line 1971: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

1967: EXCEPTION
1968:
1969: WHEN OTHERS THEN
1970: FII_UTIL.Write_Log ('Other error in REFRESH_GL_LOCAL_SNAP_F ');
1971: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1972: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1973: rollback;
1974: raise;
1975:

Line 1972: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));

1968:
1969: WHEN OTHERS THEN
1970: FII_UTIL.Write_Log ('Other error in REFRESH_GL_LOCAL_SNAP_F ');
1971: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1972: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
1973: rollback;
1974: raise;
1975:
1976: END REFRESH_GL_LOCAL_SNAP_F;

Line 1993: FII_UTIL.Write_Log ('Entering Main');

1989: Begin
1990:
1991: g_phase := 'Entering Main';
1992: IF g_debug_flag = 'Y' THEN
1993: FII_UTIL.Write_Log ('Entering Main');
1994: END IF;
1995:
1996: g_phase := 'Calling Initialize';
1997: IF g_debug_flag = 'Y' THEN

Line 1998: FII_UTIL.Write_Log ('Calling Initialize');

1994: END IF;
1995:
1996: g_phase := 'Calling Initialize';
1997: IF g_debug_flag = 'Y' THEN
1998: FII_UTIL.Write_Log ('Calling Initialize');
1999: END IF;
2000:
2001: Initialize;
2002:

Line 2005: FII_UTIL.Write_Log ('Populating FII_GL_LOCAL_SNAP_F');

2001: Initialize;
2002:
2003: g_phase := 'Populating FII_GL_LOCAL_SNAP_F';
2004: IF g_debug_flag = 'Y' THEN
2005: FII_UTIL.Write_Log ('Populating FII_GL_LOCAL_SNAP_F');
2006: END IF;
2007:
2008: REFRESH_GL_LOCAL_SNAP_F;
2009:

Line 2012: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_F');

2008: REFRESH_GL_LOCAL_SNAP_F;
2009:
2010: g_phase := 'Populating FII_GL_SNAP_F';
2011: IF g_debug_flag = 'Y' THEN
2012: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_F');
2013: END IF;
2014:
2015: REFRESH_GL_SNAP_F;
2016:

Line 2019: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_SUM_F');

2015: REFRESH_GL_SNAP_F;
2016:
2017: g_phase := 'Populating FII_GL_SNAP_SUM_F';
2018: IF g_debug_flag = 'Y' THEN
2019: FII_UTIL.Write_Log ('Populating FII_GL_SNAP_SUM_F');
2020: END IF;
2021:
2022: REFRESH_GL_SNAP_SUM_F;
2023:

Line 2026: FII_UTIL.Write_Log ('Exiting after successful completion');

2022: REFRESH_GL_SNAP_SUM_F;
2023:
2024: g_phase := 'Exiting after successful completion';
2025: IF g_debug_flag = 'Y' THEN
2026: FII_UTIL.Write_Log ('Exiting after successful completion');
2027: END IF;
2028:
2029:
2030: EXCEPTION

Line 2033: FII_UTIL.Write_Log ('Other error in Main ');

2029:
2030: EXCEPTION
2031:
2032: WHEN OTHERS THEN
2033: FII_UTIL.Write_Log ('Other error in Main ');
2034: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
2035: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
2036:
2037: FND_CONCURRENT.Af_Rollback;

Line 2034: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

2030: EXCEPTION
2031:
2032: WHEN OTHERS THEN
2033: FII_UTIL.Write_Log ('Other error in Main ');
2034: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
2035: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
2036:
2037: FND_CONCURRENT.Af_Rollback;
2038: retcode := sqlcode;

Line 2035: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));

2031:
2032: WHEN OTHERS THEN
2033: FII_UTIL.Write_Log ('Other error in Main ');
2034: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
2035: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
2036:
2037: FND_CONCURRENT.Af_Rollback;
2038: retcode := sqlcode;
2039: errbuf := sqlerrm;