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

Line 37: l_dir := FII_UTIL.get_utl_file_dir;

33: -- Set default directory in case if the profile option
34: -- BIS_DEBUG_LOG_DIRECTORY is not set up
35: ------------------------------------------------------
36: if l_dir is NULL then
37: l_dir := FII_UTIL.get_utl_file_dir;
38: end if;
39:
40: FII_UTIL.initialize('FII_USER_SEC_OPTIMIZER.log',
41: 'FII_USER_SEC_OPTIMIZER.out',l_dir,

Line 40: FII_UTIL.initialize('FII_USER_SEC_OPTIMIZER.log',

36: if l_dir is NULL then
37: l_dir := FII_UTIL.get_utl_file_dir;
38: end if;
39:
40: FII_UTIL.initialize('FII_USER_SEC_OPTIMIZER.log',
41: 'FII_USER_SEC_OPTIMIZER.out',l_dir,
42: 'FII_USER_SEC_OPTIMIZER');
43:
44:

Line 49: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');

45: g_fii_user_id := FND_GLOBAL.User_Id;
46: g_fii_login_id := FND_GLOBAL.Login_Id;
47:
48: IF g_debug_flag = 'Y' THEN
49: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
50: END IF;
51:
52:
53: -------------------------------------------------------------

Line 58: FII_UTIL.write_log(g_phase);

54: --- Truncate grants tables ---------------------------------
55: ------------------------------------------------------------
56: g_phase := 'Truncating grants tables FII_COMPANY_GRANTS and FII_COST_CENTER_GRANTS...';
57: if g_debug_flag = 'Y' then
58: FII_UTIL.write_log(g_phase);
59: end if;
60:
61: fii_util.truncate_table('FII_COMPANY_GRANTS', 'FII', l_retcode);
62: IF l_retcode = -1 then

Line 61: fii_util.truncate_table('FII_COMPANY_GRANTS', 'FII', l_retcode);

57: if g_debug_flag = 'Y' then
58: FII_UTIL.write_log(g_phase);
59: end if;
60:
61: fii_util.truncate_table('FII_COMPANY_GRANTS', 'FII', l_retcode);
62: IF l_retcode = -1 then
63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');
64: raise FIIUSECB_fatal_err;
65: END IF;

Line 63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');

59: end if;
60:
61: fii_util.truncate_table('FII_COMPANY_GRANTS', 'FII', l_retcode);
62: IF l_retcode = -1 then
63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');
64: raise FIIUSECB_fatal_err;
65: END IF;
66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);
67: IF l_retcode = -1 then

Line 66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);

62: IF l_retcode = -1 then
63: fii_util.write_log('Error in fii_util.truncate_table(''FII_COMPANY_GRANTS'', ''FII'', l_retcode)');
64: raise FIIUSECB_fatal_err;
65: END IF;
66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);
67: IF l_retcode = -1 then
68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');
69: raise FIIUSECB_fatal_err;
70: END IF;

Line 68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');

64: raise FIIUSECB_fatal_err;
65: END IF;
66: fii_util.truncate_table('FII_COST_CENTER_GRANTS', 'FII', l_retcode);
67: IF l_retcode = -1 then
68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');
69: raise FIIUSECB_fatal_err;
70: END IF;
71:
72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';

Line 78: fii_util.write_log('Error: Top node for the company or cost center dimension is not assigned.');

74: select dbi_hier_top_node_id into l_company_top_node_id from fii_financial_dimensions where dimension_short_name='FII_COMPANIES';
75: select dbi_hier_top_node_id into l_cost_ctr_top_node_id from fii_financial_dimensions where dimension_short_name='HRI_CL_ORGCC';
76:
77: IF (l_company_top_node_id is null) or (l_cost_ctr_top_node_id is null) THEN
78: fii_util.write_log('Error: Top node for the company or cost center dimension is not assigned.');
79: raise FIIUSECB_fatal_err;
80: END IF;
81:
82: g_phase := 'Inserting into fii_company_grants from bis_grants_v.';

Line 111: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');

107: AND (sysdate BETWEEN TRUNC(s.start_date) AND nvl(TRUNC(s.end_date),to_date('12-31-9999','MM-DD-YYYY')))
108: AND s.granted_to = u.employee_id);
109:
110: IF g_debug_flag = 'Y' THEN
111: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');
112: END IF;
113: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_company_grants.');
114:
115: g_phase := 'Inserting into fii_cost_center_grants from bis_grants_v.';

Line 143: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');

139: AND (sysdate BETWEEN TRUNC(s.start_date) AND nvl(TRUNC(s.end_date),to_date('12-31-9999','MM-DD-YYYY')))
140: AND s.granted_to = u.employee_id);
141:
142: IF g_debug_flag = 'Y' THEN
143: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('Inserted ' || SQL%ROWCOUNT || ' rows into fii_cost_center_grants.');
146:
147: g_phase := 'Filtering out child company assignments from fii_company_grants.';

Line 157: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');

153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)
154: AND h.parent_company_id <> h.child_company_id);
155:
156: IF g_debug_flag = 'Y' THEN
157: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');
158: END IF;
159: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_company_grants.');
160:
161: g_phase := 'Filtering out child cost center assignments from fii_cost_center_grants.';

Line 171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');

167: AND h.parent_cc_id IN (SELECT cost_center_id from fii_cost_center_grants where user_id=s.user_id and report_region_code=s.report_region_code)
168: AND h.parent_cc_id <> h.child_cc_id);
169:
170: IF g_debug_flag = 'Y' THEN
171: FII_UTIL.Write_Log ('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
172: END IF;
173: --DBMS_OUTPUT.PUT_LINE('Deleted ' || SQL%ROWCOUNT || ' rows from fii_cost_center_grants.');
174:
175: --Call FND_STATS to collect statistics after populating the table

Line 183: FII_UTIL.write_log('Fatal errors occured:');

179: tabname => 'fii_cost_center_grants');
180:
181: EXCEPTION
182: WHEN FIIUSECB_fatal_err THEN
183: FII_UTIL.write_log('Fatal errors occured:');
184: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
185:
186: FND_CONCURRENT.Af_Rollback;
187: retcode := sqlcode;

Line 184: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);

180:
181: EXCEPTION
182: WHEN FIIUSECB_fatal_err THEN
183: FII_UTIL.write_log('Fatal errors occured:');
184: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
185:
186: FND_CONCURRENT.Af_Rollback;
187: retcode := sqlcode;
188: errbuf := sqlerrm;

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

190: (status => 'ERROR', message => substr(errbuf,1,180));
191: /* DBMS_OUTPUT.put_line('Fatal errors occured during the upload process.'); */
192:
193: WHEN OTHERS THEN
194: FII_UTIL.Write_Log ('Other error in Main ');
195: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
196: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
197:
198: FND_CONCURRENT.Af_Rollback;

Line 195: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);

191: /* DBMS_OUTPUT.put_line('Fatal errors occured during the upload process.'); */
192:
193: WHEN OTHERS THEN
194: FII_UTIL.Write_Log ('Other error in Main ');
195: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
196: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
197:
198: FND_CONCURRENT.Af_Rollback;
199: retcode := sqlcode;

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

192:
193: WHEN OTHERS THEN
194: FII_UTIL.Write_Log ('Other error in Main ');
195: FII_UTIL.Write_Log ( 'G_PHASE: ' || g_phase);
196: FII_UTIL.Write_Log ('-->'|| sqlcode ||':'|| substr(sqlerrm,1,180));
197:
198: FND_CONCURRENT.Af_Rollback;
199: retcode := sqlcode;
200: errbuf := sqlerrm;