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_AP_DISCOUNTS_SUM_C dependencies on EDW_LOG

Line 24: edw_log.put_line('Truncate table FII_AP_DISCOUNTS_SUMMARY');

20: l_state VARCHAR2(100);
21: Begin
22:
23: if g_debug_flag = 'Y' then
24: edw_log.put_line('Truncate table FII_AP_DISCOUNTS_SUMMARY');
25: end if;
26: l_state := 'Truncate FII_AP_DISCOUNTS_SUMMARY';
27: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_DISCOUNTS_SUMMARY';
28:

Line 30: edw_log.debug_line('');

26: l_state := 'Truncate FII_AP_DISCOUNTS_SUMMARY';
27: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_DISCOUNTS_SUMMARY';
28:
29: if g_debug_flag = 'Y' then
30: edw_log.debug_line('');
31: edw_log.debug_line(l_stmt);
32: end if;
33: execute immediate l_stmt;
34:

Line 31: edw_log.debug_line(l_stmt);

27: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_DISCOUNTS_SUMMARY';
28:
29: if g_debug_flag = 'Y' then
30: edw_log.debug_line('');
31: edw_log.debug_line(l_stmt);
32: end if;
33: execute immediate l_stmt;
34:
35: if g_debug_flag = 'Y' then

Line 36: edw_log.put_line('Populate table FII_AP_DISCOUNTS_SUMMARY');

32: end if;
33: execute immediate l_stmt;
34:
35: if g_debug_flag = 'Y' then
36: edw_log.put_line('Populate table FII_AP_DISCOUNTS_SUMMARY');
37: end if;
38: l_state := 'Insert into FII_AP_DISCOUNTS_SUMMARY';
39: l_stmt := 'insert into '||g_fii_schema||'.FII_AP_DISCOUNTS_SUMMARY (
40: OPERATING_UNIT_PK_KEY,

Line 114: edw_log.debug_line('');

110: schp.third_disc_date between to_date(''' ||to_char(g_today,'DD-MM-YYYY')|| ''',''DD-MM-YYYY'')
111: and to_date('''||to_char(g_cur_qtr_end_date,'DD-MM-YYYY')||''',''DD-MM-YYYY''))';
112:
113: if g_debug_flag = 'Y' then
114: edw_log.debug_line('');
115: edw_log.debug_line(l_stmt);
116: end if;
117: execute immediate l_stmt;
118:

Line 115: edw_log.debug_line(l_stmt);

111: and to_date('''||to_char(g_cur_qtr_end_date,'DD-MM-YYYY')||''',''DD-MM-YYYY''))';
112:
113: if g_debug_flag = 'Y' then
114: edw_log.debug_line('');
115: edw_log.debug_line(l_stmt);
116: end if;
117: execute immediate l_stmt;
118:
119: if g_debug_flag = 'Y' then

Line 120: edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_DISCOUNTS_SUMMARY');

116: end if;
117: execute immediate l_stmt;
118:
119: if g_debug_flag = 'Y' then
120: edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_DISCOUNTS_SUMMARY');
121: end if;
122:
123: EXCEPTION
124: WHEN OTHERS THEN

Line 129: edw_log.put_line('Error occured while ' || l_state);

125: g_errbuf:=sqlerrm;
126: g_retcode:=sqlcode;
127: g_exception_msg := g_retcode || ':' || g_errbuf;
128: if g_debug_flag = 'Y' then
129: edw_log.put_line('Error occured while ' || l_state);
130: edw_log.put_line(g_exception_msg);
131: end if;
132: raise;
133:

Line 130: edw_log.put_line(g_exception_msg);

126: g_retcode:=sqlcode;
127: g_exception_msg := g_retcode || ':' || g_errbuf;
128: if g_debug_flag = 'Y' then
129: edw_log.put_line('Error occured while ' || l_state);
130: edw_log.put_line(g_exception_msg);
131: end if;
132: raise;
133:
134: END POPULATE_FII_AP_DISC_SUMMARY;

Line 152: edw_log.g_debug := TRUE;

148: EXECUTE IMMEDIATE l_stmt;
149:
150: -- DEBUG
151: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
152: edw_log.g_debug := TRUE;
153: END IF;
154:
155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
156: if l_dir is null then

Line 155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

151: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
152: edw_log.g_debug := TRUE;
153: END IF;
154:
155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
156: if l_dir is null then
157: l_dir:='/sqlcom/log';
158: end if;
159: if g_debug_flag = 'Y' then

Line 160: edw_log.put_names('FII_AP_TR_BKLG_SUMMARY.log','FII_AP_TR_BKLG_SUMMARY.out',l_dir);

156: if l_dir is null then
157: l_dir:='/sqlcom/log';
158: end if;
159: if g_debug_flag = 'Y' then
160: edw_log.put_names('FII_AP_TR_BKLG_SUMMARY.log','FII_AP_TR_BKLG_SUMMARY.out',l_dir);
161:
162:
163: fii_util.put_timestamp;
164: end if;

Line 181: edw_log.put_line('Getting current quarter start date and end date');

177: WHERE table_name = 'FII_AP_DISCOUNTS_SUMMARY'
178: AND owner = g_fii_schema;
179:
180: if g_debug_flag = 'Y' then
181: edw_log.put_line('Getting current quarter start date and end date');
182: fii_util.start_timer;
183: end if;
184: g_cur_qtr_start_date := FII_TIME_WH_API.get_curr_eqtr_start;
185: g_cur_qtr_end_date := FII_TIME_WH_API.get_curr_eqtr_end;