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

Line 93: edw_log.debug_line('');

89: l_stmt := 'select sob_id from fii_ar_oltp_open_inv_v@'||
90: g_rec(i).db_link||' where rownum < 2';
91:
92: if g_debug_flag = 'Y' then
93: edw_log.debug_line('');
94: edw_log.debug_line(l_stmt);
95: end if;
96: execute immediate l_stmt into l_dummy;
97:

Line 94: edw_log.debug_line(l_stmt);

90: g_rec(i).db_link||' where rownum < 2';
91:
92: if g_debug_flag = 'Y' then
93: edw_log.debug_line('');
94: edw_log.debug_line(l_stmt);
95: end if;
96: execute immediate l_stmt into l_dummy;
97:
98: IF l_dummy IS NOT NULL THEN

Line 118: edw_log.debug_line('');

114: l_stmt := 'select name '||
115: 'from v$database@'||g_rec(i).db_link;
116:
117: if g_debug_flag = 'Y' then
118: edw_log.debug_line('');
119: edw_log.debug_line(l_stmt);
120: end if;
121: execute immediate l_stmt into l_db_name2;
122:

Line 119: edw_log.debug_line(l_stmt);

115: 'from v$database@'||g_rec(i).db_link;
116:
117: if g_debug_flag = 'Y' then
118: edw_log.debug_line('');
119: edw_log.debug_line(l_stmt);
120: end if;
121: execute immediate l_stmt into l_db_name2;
122:
123: IF (l_db_name1 = l_db_name2) THEN

Line 146: edw_log.debug_line('');

142:
143: l_stmt:='drop table '||g_fii_schema||'.'||p_table_name;
144:
145: if g_debug_flag = 'Y' then
146: edw_log.debug_line('');
147: edw_log.debug_line(l_stmt);
148: end if;
149: execute immediate l_stmt;
150:

Line 147: edw_log.debug_line(l_stmt);

143: l_stmt:='drop table '||g_fii_schema||'.'||p_table_name;
144:
145: if g_debug_flag = 'Y' then
146: edw_log.debug_line('');
147: edw_log.debug_line(l_stmt);
148: end if;
149: execute immediate l_stmt;
150:
151: l_stmt:='drop synonym '||p_table_name;

Line 154: edw_log.debug_line('');

150:
151: l_stmt:='drop synonym '||p_table_name;
152:
153: if g_debug_flag = 'Y' then
154: edw_log.debug_line('');
155: edw_log.debug_line(l_stmt);
156: end if;
157: execute immediate l_stmt;
158:

Line 155: edw_log.debug_line(l_stmt);

151: l_stmt:='drop synonym '||p_table_name;
152:
153: if g_debug_flag = 'Y' then
154: edw_log.debug_line('');
155: edw_log.debug_line(l_stmt);
156: end if;
157: execute immediate l_stmt;
158:
159:

Line 204: edw_log.debug_line('');

200: NOLOGGING PCTFREE 5
201: storage (INITIAL 4K NEXT 32K)';
202:
203: if g_debug_flag = 'Y' then
204: edw_log.debug_line('');
205: edw_log.debug_line(l_stmt);
206: end if;
207: execute immediate l_stmt;
208:

Line 205: edw_log.debug_line(l_stmt);

201: storage (INITIAL 4K NEXT 32K)';
202:
203: if g_debug_flag = 'Y' then
204: edw_log.debug_line('');
205: edw_log.debug_line(l_stmt);
206: end if;
207: execute immediate l_stmt;
208:
209:

Line 264: edw_log.debug_line('');

260: l_stmt := l_stmt||'@'||g_rec(i).db_link||' INV ';
261: END IF;
262:
263: if g_debug_flag = 'Y' then
264: edw_log.debug_line('');
265: edw_log.debug_line(l_stmt);
266: end if;
267:
268: execute immediate l_stmt;

Line 265: edw_log.debug_line(l_stmt);

261: END IF;
262:
263: if g_debug_flag = 'Y' then
264: edw_log.debug_line('');
265: edw_log.debug_line(l_stmt);
266: end if;
267:
268: execute immediate l_stmt;
269:

Line 294: edw_log.debug_line('');

290: -- --------------------------------------
291: l_stmt := 'truncate table '||g_fii_schema||'.fii_ar_open_installment_f';
292:
293: if g_debug_flag = 'Y' then
294: edw_log.debug_line('');
295: edw_log.debug_line(l_stmt);
296: end if;
297: execute immediate l_stmt;
298:

Line 295: edw_log.debug_line(l_stmt);

291: l_stmt := 'truncate table '||g_fii_schema||'.fii_ar_open_installment_f';
292:
293: if g_debug_flag = 'Y' then
294: edw_log.debug_line('');
295: edw_log.debug_line(l_stmt);
296: end if;
297: execute immediate l_stmt;
298:
299:

Line 365: edw_log.debug_line('');

361: and org.orga_organization_pk = to_char(f.org_id)||''-''||f.instance_code
362: and curr.crnc_currency_pk = f.functional_currency' ;
363:
364: if g_debug_flag = 'Y' then
365: edw_log.debug_line('');
366: edw_log.debug_line(l_stmt);
367: end if;
368: execute immediate l_stmt;
369:

Line 366: edw_log.debug_line(l_stmt);

362: and curr.crnc_currency_pk = f.functional_currency' ;
363:
364: if g_debug_flag = 'Y' then
365: edw_log.debug_line('');
366: edw_log.debug_line(l_stmt);
367: end if;
368: execute immediate l_stmt;
369:
370: -- --------------------------------

Line 375: edw_log.debug_line('');

371: -- Populate org level summary
372: -- --------------------------------
373: l_stmt := 'truncate table '||g_fii_schema||'.fii_ar_risk_indicator_f';
374: if g_debug_flag = 'Y' then
375: edw_log.debug_line('');
376: edw_log.debug_line(l_stmt);
377: end if;
378: execute immediate l_stmt;
379:

Line 376: edw_log.debug_line(l_stmt);

372: -- --------------------------------
373: l_stmt := 'truncate table '||g_fii_schema||'.fii_ar_risk_indicator_f';
374: if g_debug_flag = 'Y' then
375: edw_log.debug_line('');
376: edw_log.debug_line(l_stmt);
377: end if;
378: execute immediate l_stmt;
379:
380: l_stmt := '

Line 457: edw_log.debug_line('');

453: a.operating_unit_fk_key';
454:
455:
456: if g_debug_flag = 'Y' then
457: edw_log.debug_line('');
458: edw_log.debug_line(l_stmt);
459: end if;
460: execute immediate l_stmt;
461:

Line 458: edw_log.debug_line(l_stmt);

454:
455:
456: if g_debug_flag = 'Y' then
457: edw_log.debug_line('');
458: edw_log.debug_line(l_stmt);
459: end if;
460: execute immediate l_stmt;
461:
462:

Line 489: edw_log.g_debug := TRUE;

485: EXECUTE IMMEDIATE l_stmt;
486:
487: -- DEBUG
488: -- IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
489: edw_log.g_debug := TRUE;
490: -- END IF;
491:
492: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
493: if l_dir is null then

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

488: -- IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
489: edw_log.g_debug := TRUE;
490: -- END IF;
491:
492: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
493: if l_dir is null then
494: l_dir:='/sqlcom/log';
495: end if;
496: if g_debug_flag = 'Y' then

Line 497: edw_log.put_names('FII_AR_RISK_INDICATOR_F.log','FII_AR_RISK_INDICATOR_F.out',l_dir);

493: if l_dir is null then
494: l_dir:='/sqlcom/log';
495: end if;
496: if g_debug_flag = 'Y' then
497: edw_log.put_names('FII_AR_RISK_INDICATOR_F.log','FII_AR_RISK_INDICATOR_F.out',l_dir);
498:
499:
500: fii_util.put_timestamp;
501: edw_log.put_line('Initialization');

Line 501: edw_log.put_line('Initialization');

497: edw_log.put_names('FII_AR_RISK_INDICATOR_F.log','FII_AR_RISK_INDICATOR_F.out',l_dir);
498:
499:
500: fii_util.put_timestamp;
501: edw_log.put_line('Initialization');
502: fii_util.start_timer;
503: end if;
504: Init;
505: Drop_table('FII_AR_OLTP_OPEN_INV');

Line 511: edw_log.put_line('Summarzing OE backlog information');

507: fii_util.stop_timer;
508: fii_util.print_timer('Duration');
509:
510: fii_util.put_timestamp;
511: edw_log.put_line('Summarzing OE backlog information');
512: fii_util.start_timer;
513: end if;
514: -- DEBUG
515: isc_edw_backlog_sum1_f_c.Populate(l_errbuf, l_retcode);

Line 521: edw_log.put_line('');

517: fii_util.stop_timer;
518: fii_util.print_timer('Duration');
519:
520:
521: edw_log.put_line('');
522: edw_log.put_line('Extracting Open Invoice Installments');
523: fii_util.start_timer;
524: end if;
525: Extract_OLTP_OPEN_INV;

Line 522: edw_log.put_line('Extracting Open Invoice Installments');

518: fii_util.print_timer('Duration');
519:
520:
521: edw_log.put_line('');
522: edw_log.put_line('Extracting Open Invoice Installments');
523: fii_util.start_timer;
524: end if;
525: Extract_OLTP_OPEN_INV;
526: if g_debug_flag = 'Y' then

Line 530: edw_log.put_line('');

526: if g_debug_flag = 'Y' then
527: fii_util.stop_timer;
528: fii_util.print_timer('Duration');
529:
530: edw_log.put_line('');
531: edw_log.put_line('Summarizing into AR Risk Summary Table');
532: fii_util.start_timer;
533: end if;
534: Populate_RISK_INDICATOR;

Line 531: edw_log.put_line('Summarizing into AR Risk Summary Table');

527: fii_util.stop_timer;
528: fii_util.print_timer('Duration');
529:
530: edw_log.put_line('');
531: edw_log.put_line('Summarizing into AR Risk Summary Table');
532: fii_util.start_timer;
533: end if;
534: Populate_RISK_INDICATOR;
535: if g_debug_flag = 'Y' then