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

Line 50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);

46: ----------------------------------------------------------
47: -- Truncate staging and base tables
48: ----------------------------------------------------------
49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);
54:

Line 53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);

49: g_phase := 'Truncate table FII_TOP_SPENDERS_STG';
50: FII_UTIL.truncate_table ('FII_TOP_SPENDERS_STG', 'FII', g_retcode);
51:
52: g_phase := 'Truncate table FII_TOP_SPNDR_SUM_B';
53: FII_UTIL.truncate_table ('FII_TOP_SPNDR_SUM_B', 'FII', g_retcode);
54:
55: Exception
56:
57: WHEN NO_DATA_FOUND THEN

Line 58: FII_UTIL.Write_Log ( 'Phase: ' || g_phase);

54:
55: Exception
56:
57: WHEN NO_DATA_FOUND THEN
58: FII_UTIL.Write_Log ( 'Phase: ' || g_phase);
59: FII_MESSAGE.write_log(msg_name => 'FII_GL_AP_BASE_EMPTY',
60: token_num => 0);
61: g_retcode := 1;
62: RAISE;

Line 67: FII_UTIL.write_log('

63:
64: WHEN OTHERS THEN
65: g_retcode := -1;
66:
67: FII_UTIL.write_log('
68: ---------------------------------
69: Error in Procedure: INIT
70: Phase: '||g_phase||'
71: Message: '||sqlerrm);

Line 83: fii_util.write_log('Populating month slices in fii_top_spenders_stg table');

79:
80: BEGIN
81:
82: if g_debug_flag = 'Y' then
83: fii_util.write_log('Populating month slices in fii_top_spenders_stg table');
84: end if;
85:
86: g_phase := 'Insert month slices into fii_top_spenders_stg table';
87:

Line 126: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

122: and b.COST_CENTER_ID = m.COST_CENTER_ID
123: GROUP BY m.COMPANY_COST_CENTER_ORG_ID, b.employee_id, t.ENT_YEAR_ID, t.ENT_QTR_ID, t.ENT_PERIOD_ID;
124:
125: if g_debug_flag = 'Y' then
126: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
127: end if;
128:
129: commit;
130:

Line 135: FII_UTIL.write_log('

131: EXCEPTION
132: WHEN OTHERS THEN
133: g_retcode := -1;
134:
135: FII_UTIL.write_log('
136: ----------------------------
137: Error in Function: POPULATE_STG_MONTHS
138: Phase: '||g_phase||'
139: Message: '||sqlerrm);

Line 150: fii_util.write_log('Populating quarter slices in fii_top_spenders_stg table');

146:
147: BEGIN
148:
149: if g_debug_flag = 'Y' then
150: fii_util.write_log('Populating quarter slices in fii_top_spenders_stg table');
151: end if;
152:
153: g_phase := 'Insert quarter slices into fii_top_spenders_stg table';
154:

Line 189: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

185: g_fii_login_id
186: FROM fii_top_spenders_stg t;
187:
188: if g_debug_flag = 'Y' then
189: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
190: end if;
191:
192: commit;
193:

Line 198: FII_UTIL.write_log('

194: EXCEPTION
195: WHEN OTHERS THEN
196: g_retcode := -1;
197:
198: FII_UTIL.write_log('
199: ----------------------------
200: Error in Function: POPULATE_STG_QUARTERS
201: Phase: '||g_phase||'
202: Message: '||sqlerrm);

Line 214: fii_util.write_log('Populating year slices in fii_top_spenders_stg table');

210:
211: BEGIN
212:
213: if g_debug_flag = 'Y' then
214: fii_util.write_log('Populating year slices in fii_top_spenders_stg table');
215: end if;
216:
217: g_phase := 'Insert year slices into fii_top_spenders_stg table';
218:

Line 253: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');

249: FROM fii_top_spenders_stg b
250: WHERE b.slice_type_flag = 'M';
251:
252: if g_debug_flag = 'Y' then
253: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPENDERS_STG');
254: end if;
255:
256: commit;
257:

Line 262: FII_UTIL.write_log('

258: EXCEPTION
259: WHEN OTHERS THEN
260: g_retcode := -1;
261:
262: FII_UTIL.write_log('
263: ----------------------------
264: Error in Function: POPULATE_STG_YEARS
265: Phase: '||g_phase||'
266: Message: '||sqlerrm);

Line 277: fii_util.write_log('Populating fii_top_spndr_sum_b table');

273:
274: BEGIN
275:
276: if g_debug_flag = 'Y' then
277: fii_util.write_log('Populating fii_top_spndr_sum_b table');
278: end if;
279:
280: g_phase := 'Insert rows into fii_top_spndr_sum_b table';
281:

Line 329: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPNDR_SUM_B');

325: help.manager_id ) x
326: WHERE x.RANK_WITHIN_MANAGER_ptd <= 10;
327:
328: if g_debug_flag = 'Y' then
329: fii_util.write_log('Inserted '||SQL%ROWCOUNT||' rows into FII_TOP_SPNDR_SUM_B');
330: end if;
331:
332: FND_STATS.gather_table_stats
333: (ownname => g_fii_schema,

Line 341: FII_UTIL.write_log('

337: EXCEPTION
338: WHEN OTHERS THEN
339: g_retcode := -1;
340:
341: FII_UTIL.write_log('
342: ----------------------------
343: Error in Function: POPULATE_SUMMARY
344: Phase: '||g_phase||'
345: Message: '||sqlerrm);

Line 359: l_dir:=FII_UTIL.get_utl_file_dir;

355: PROCEDURE Main ( ERRBUF IN OUT NOCOPY VARCHAR2,
356: RETCODE IN OUT NOCOPY VARCHAR2) IS
357: l_dir VARCHAR2(400);
358: BEGIN
359: l_dir:=FII_UTIL.get_utl_file_dir;
360: FII_UTIL.initialize('fii_gl_top_spenders_pkg.log','fii_gl_top_spenders_pkg.out',l_dir, 'fii_gl_top_spenders_pkg');
361:
362: INIT;
363: POPULATE_STG_MONTHS;

Line 360: FII_UTIL.initialize('fii_gl_top_spenders_pkg.log','fii_gl_top_spenders_pkg.out',l_dir, 'fii_gl_top_spenders_pkg');

356: RETCODE IN OUT NOCOPY VARCHAR2) IS
357: l_dir VARCHAR2(400);
358: BEGIN
359: l_dir:=FII_UTIL.get_utl_file_dir;
360: FII_UTIL.initialize('fii_gl_top_spenders_pkg.log','fii_gl_top_spenders_pkg.out',l_dir, 'fii_gl_top_spenders_pkg');
361:
362: INIT;
363: POPULATE_STG_MONTHS;
364: POPULATE_STG_QUARTERS;