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

Line 28: edw_log.debug_line('');

24:
25: l_stmt:='drop table '||g_fii_schema||'.'||p_table_name;
26:
27: if g_debug_flag = 'Y' then
28: edw_log.debug_line('');
29: edw_log.debug_line(l_stmt);
30: end if;
31: execute immediate l_stmt;
32:

Line 29: edw_log.debug_line(l_stmt);

25: l_stmt:='drop table '||g_fii_schema||'.'||p_table_name;
26:
27: if g_debug_flag = 'Y' then
28: edw_log.debug_line('');
29: edw_log.debug_line(l_stmt);
30: end if;
31: execute immediate l_stmt;
32:
33: Exception

Line 51: edw_log.put_line('Creating FII_AP_OP_IND_SUMMARY_TEMP tables');

47: drop_table('FII_AP_OP_IND_SUMMARY_TEMP1');
48: drop_table('FII_AP_OP_IND_SUMMARY_TEMP2');
49:
50: if g_debug_flag = 'Y' then
51: edw_log.put_line('Creating FII_AP_OP_IND_SUMMARY_TEMP tables');
52: end if;
53:
54: l_state := 'Create FII_AP_OP_IND_SUMMARY_TEMP1';
55: l_stmt := 'create table '||g_fii_schema||'.FII_AP_OP_IND_SUMMARY_TEMP1(

Line 68: edw_log.debug_line('');

64: PCTFREE 5
65: storage (INITIAL 4K NEXT 32K)';
66:
67: if g_debug_flag = 'Y' then
68: edw_log.debug_line('');
69: edw_log.debug_line(l_stmt);
70: end if;
71: execute immediate l_stmt;
72:

Line 69: edw_log.debug_line(l_stmt);

65: storage (INITIAL 4K NEXT 32K)';
66:
67: if g_debug_flag = 'Y' then
68: edw_log.debug_line('');
69: edw_log.debug_line(l_stmt);
70: end if;
71: execute immediate l_stmt;
72:
73: l_state := 'Create FII_AP_OP_IND_SUMMARY_TEMP2';

Line 86: edw_log.debug_line('');

82: PCTFREE 5
83: storage (INITIAL 4K NEXT 32K)';
84:
85: if g_debug_flag = 'Y' then
86: edw_log.debug_line('');
87: edw_log.debug_line(l_stmt);
88: end if;
89: execute immediate l_stmt;
90:

Line 87: edw_log.debug_line(l_stmt);

83: storage (INITIAL 4K NEXT 32K)';
84:
85: if g_debug_flag = 'Y' then
86: edw_log.debug_line('');
87: edw_log.debug_line(l_stmt);
88: end if;
89: execute immediate l_stmt;
90:
91: if g_debug_flag = 'Y' then

Line 92: edw_log.put_line('Populating FII_AP_OP_IND_SUMMARY_TEMP tables');

88: end if;
89: execute immediate l_stmt;
90:
91: if g_debug_flag = 'Y' then
92: edw_log.put_line('Populating FII_AP_OP_IND_SUMMARY_TEMP tables');
93: end if;
94:
95: -- --------------------------------------
96: -- Populate FII_AP_OP_IND_SUMMARY_TEMP tables

Line 131: edw_log.debug_line('');

127: partner.TPRT_TRADE_PARTNER_PK_KEY,
128: partner.tprt_name';
129:
130: if g_debug_flag = 'Y' then
131: edw_log.debug_line('');
132: edw_log.debug_line(l_stmt);
133: end if;
134: execute immediate l_stmt;
135:

Line 132: edw_log.debug_line(l_stmt);

128: partner.tprt_name';
129:
130: if g_debug_flag = 'Y' then
131: edw_log.debug_line('');
132: edw_log.debug_line(l_stmt);
133: end if;
134: execute immediate l_stmt;
135:
136: if g_debug_flag = 'Y' then

Line 137: edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP1');

133: end if;
134: execute immediate l_stmt;
135:
136: if g_debug_flag = 'Y' then
137: edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP1');
138: end if;
139:
140: l_state := 'Populate FII_AP_OP_IND_SUMMARY_TEMP2';
141: l_stmt := 'INSERT INTO '||g_fii_schema||'.FII_AP_OP_IND_SUMMARY_TEMP2 (

Line 171: edw_log.debug_line('');

167: partner.TPRT_TRADE_PARTNER_PK_KEY,
168: partner.tprt_name';
169:
170: if g_debug_flag = 'Y' then
171: edw_log.debug_line('');
172: edw_log.debug_line(l_stmt);
173: end if;
174: execute immediate l_stmt;
175:

Line 172: edw_log.debug_line(l_stmt);

168: partner.tprt_name';
169:
170: if g_debug_flag = 'Y' then
171: edw_log.debug_line('');
172: edw_log.debug_line(l_stmt);
173: end if;
174: execute immediate l_stmt;
175:
176: if g_debug_flag = 'Y' then

Line 177: edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP2');

173: end if;
174: execute immediate l_stmt;
175:
176: if g_debug_flag = 'Y' then
177: edw_log.debug_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_IND_SUMMARY_TEMP2');
178: end if;
179:
180: EXCEPTION
181: WHEN OTHERS THEN

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

182: g_errbuf:=sqlerrm;
183: g_retcode:=sqlcode;
184: g_exception_msg := g_retcode || ':' || g_errbuf;
185: if g_debug_flag = 'Y' then
186: edw_log.put_line('Error occured while ' || l_state);
187: edw_log.put_line(g_exception_msg);
188: end if;
189: raise;
190: END CREATE_FII_AP_OP_IND_SUM_TEMP;

Line 187: edw_log.put_line(g_exception_msg);

183: g_retcode:=sqlcode;
184: g_exception_msg := g_retcode || ':' || g_errbuf;
185: if g_debug_flag = 'Y' then
186: edw_log.put_line('Error occured while ' || l_state);
187: edw_log.put_line(g_exception_msg);
188: end if;
189: raise;
190: END CREATE_FII_AP_OP_IND_SUM_TEMP;
191:

Line 201: edw_log.put_line('Truncate table FII_AP_OP_INDICATOR_SUMMARY');

197: l_state VARCHAR2(100);
198: Begin
199:
200: if g_debug_flag = 'Y' then
201: edw_log.put_line('Truncate table FII_AP_OP_INDICATOR_SUMMARY');
202: end if;
203: l_state := 'Truncate FII_AP_OP_INDICATOR_SUMMARY';
204: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_OP_INDICATOR_SUMMARY';
205:

Line 207: edw_log.debug_line('');

203: l_state := 'Truncate FII_AP_OP_INDICATOR_SUMMARY';
204: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_OP_INDICATOR_SUMMARY';
205:
206: if g_debug_flag = 'Y' then
207: edw_log.debug_line('');
208: edw_log.debug_line(l_stmt);
209: end if;
210: execute immediate l_stmt;
211:

Line 208: edw_log.debug_line(l_stmt);

204: l_stmt := 'truncate table '||g_fii_schema||'.FII_AP_OP_INDICATOR_SUMMARY';
205:
206: if g_debug_flag = 'Y' then
207: edw_log.debug_line('');
208: edw_log.debug_line(l_stmt);
209: end if;
210: execute immediate l_stmt;
211:
212: if g_debug_flag = 'Y' then

Line 213: edw_log.put_line('Populate table FII_AP_OP_INDICATOR_SUMMARY');

209: end if;
210: execute immediate l_stmt;
211:
212: if g_debug_flag = 'Y' then
213: edw_log.put_line('Populate table FII_AP_OP_INDICATOR_SUMMARY');
214: end if;
215: l_state := 'Insert into FII_AP_OP_INDICATOR_SUMMARY';
216: l_stmt := 'insert into '||g_fii_schema||'.FII_AP_OP_INDICATOR_SUMMARY (
217: operating_unit_pk_key,

Line 262: edw_log.debug_line('');

258: f.trading_partner_pk_key,
259: f.trading_partner_name';
260:
261: if g_debug_flag = 'Y' then
262: edw_log.debug_line('');
263: edw_log.debug_line(l_stmt);
264: end if;
265: execute immediate l_stmt;
266:

Line 263: edw_log.debug_line(l_stmt);

259: f.trading_partner_name';
260:
261: if g_debug_flag = 'Y' then
262: edw_log.debug_line('');
263: edw_log.debug_line(l_stmt);
264: end if;
265: execute immediate l_stmt;
266:
267: if g_debug_flag = 'Y' then

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

264: end if;
265: execute immediate l_stmt;
266:
267: if g_debug_flag = 'Y' then
268: edw_log.put_line('Inserted ' || sql%rowcount || ' rows into FII_AP_OP_INDICATOR_SUMMARY');
269: end if;
270:
271: l_state := 'Drop FII_AP_OP_IND_SUMMARY_TEMP tables';
272: DROP_TABLE('FII_AP_OP_IND_SUMMARY_TEMP1');

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

276: g_errbuf:=sqlerrm;
277: g_retcode:=sqlcode;
278: g_exception_msg := g_retcode || ':' || g_errbuf;
279: if g_debug_flag = 'Y' then
280: edw_log.put_line('Error occured while ' || l_state);
281: edw_log.put_line(g_exception_msg);
282: end if;
283: raise;
284:

Line 281: edw_log.put_line(g_exception_msg);

277: g_retcode:=sqlcode;
278: g_exception_msg := g_retcode || ':' || g_errbuf;
279: if g_debug_flag = 'Y' then
280: edw_log.put_line('Error occured while ' || l_state);
281: edw_log.put_line(g_exception_msg);
282: end if;
283: raise;
284:
285: END POPULATE_FII_AP_OP_IND_SUMMARY;

Line 303: edw_log.g_debug := TRUE;

299: EXECUTE IMMEDIATE l_stmt;
300:
301: -- DEBUG
302: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
303: edw_log.g_debug := TRUE;
304: END IF;
305:
306: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
307: if l_dir is null then

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

302: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
303: edw_log.g_debug := TRUE;
304: END IF;
305:
306: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
307: if l_dir is null then
308: l_dir:='/sqlcom/log';
309: end if;
310: if g_debug_flag = 'Y' then

Line 311: edw_log.put_names('FII_AP_OP_IND_SMMARY.log','FII_AP_OP_IND_SUMMARY.out',l_dir);

307: if l_dir is null then
308: l_dir:='/sqlcom/log';
309: end if;
310: if g_debug_flag = 'Y' then
311: edw_log.put_names('FII_AP_OP_IND_SMMARY.log','FII_AP_OP_IND_SUMMARY.out',l_dir);
312: end if;
313:
314: if g_debug_flag = 'Y' then
315: fii_util.put_timestamp;

Line 333: edw_log.put_line('Getting current quarter start date');

329: WHERE table_name = 'FII_AP_OP_INDICATOR_SUMMARY'
330: AND owner = g_fii_schema;
331:
332: if g_debug_flag = 'Y' then
333: edw_log.put_line('Getting current quarter start date');
334: end if;
335: if g_debug_flag = 'Y' then
336: fii_util.start_timer;
337: end if;