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.ISC_MAINT_REQ_WO_ETL_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 38: bis_collection_utilities.log( g_pkg_name || '.' || p_proc_name ||

34: , p_message varchar2
35: )
36: as
37: begin
38: bis_collection_utilities.log( g_pkg_name || '.' || p_proc_name ||
39: ' #' || p_stmt_id || ' ' ||
40: p_message
41: , 3 );
42: end logger;

Line 120: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));

116: l_refresh_date date;
117:
118: begin
119:
120: l_refresh_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period(g_object_name));
121: if l_refresh_date = g_global_start_date then
122: x_error_message := 'Incremental Load can only be run after a completed initial or incremental load';
123: return -1;
124: end if;

Line 163: bis_collection_utilities.log( 'Begin Initial Load' );

159: begin
160:
161: local_init;
162:
163: bis_collection_utilities.log( 'Begin Initial Load' );
164:
165: l_stmt_id := 0;
166: if not bis_collection_utilities.setup( g_object_name ) then
167: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';

Line 166: if not bis_collection_utilities.setup( g_object_name ) then

162:
163: bis_collection_utilities.log( 'Begin Initial Load' );
164:
165: l_stmt_id := 0;
166: if not bis_collection_utilities.setup( g_object_name ) then
167: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';
168: logger( l_proc_name, l_stmt_id, l_error_message );
169: raise g_bis_setup_exception;
170: end if;

Line 167: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';

163: bis_collection_utilities.log( 'Begin Initial Load' );
164:
165: l_stmt_id := 0;
166: if not bis_collection_utilities.setup( g_object_name ) then
167: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';
168: logger( l_proc_name, l_stmt_id, l_error_message );
169: raise g_bis_setup_exception;
170: end if;
171:

Line 183: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

179:
180: l_collect_from_date := g_global_start_date;
181: l_collect_to_date := sysdate;
182:
183: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
184: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
185:
186: -- get the isc schema name
187: l_stmt_id := 20;

Line 184: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

180: l_collect_from_date := g_global_start_date;
181: l_collect_to_date := sysdate;
182:
183: bis_collection_utilities.log( 'From ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
184: bis_collection_utilities.log( 'To ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
185:
186: -- get the isc schema name
187: l_stmt_id := 20;
188: if get_schema_name

Line 205: bis_collection_utilities.log( 'Base summary table truncated', 1 );

201: logger( l_proc_name, l_stmt_id, l_error_message );
202: raise l_exception;
203: end if;
204:
205: bis_collection_utilities.log( 'Base summary table truncated', 1 );
206:
207: -- insert into base fact from staging table
208: l_stmt_id := 40;
209: insert /*+ append parallel(f) */

Line 420: bis_collection_utilities.log( l_rowcount || ' rows inserted into base summary', 1 );

416: l_rowcount := sql%rowcount;
417:
418: commit;
419:
420: bis_collection_utilities.log( l_rowcount || ' rows inserted into base summary', 1 );
421:
422: l_stmt_id := 50;
423: bis_collection_utilities.wrapup( p_status => true
424: , p_period_from => l_collect_from_date

Line 423: bis_collection_utilities.wrapup( p_status => true

419:
420: bis_collection_utilities.log( l_rowcount || ' rows inserted into base summary', 1 );
421:
422: l_stmt_id := 50;
423: bis_collection_utilities.wrapup( p_status => true
424: , p_period_from => l_collect_from_date
425: , p_period_to => l_collect_to_date
426: , p_count => l_rowcount
427: );

Line 429: bis_collection_utilities.log('End Initial Load');

425: , p_period_to => l_collect_to_date
426: , p_count => l_rowcount
427: );
428:
429: bis_collection_utilities.log('End Initial Load');
430:
431: errbuf := null;
432: retcode := g_success;
433:

Line 445: bis_collection_utilities.wrapup( p_status => false

441: rollback;
442: if l_error_message is null then
443: l_error_message := substr(sqlerrm,1,4000);
444: end if;
445: bis_collection_utilities.wrapup( p_status => false
446: , p_message => l_error_message
447: , p_period_from => l_collect_from_date
448: , p_period_to => l_collect_to_date
449: );

Line 481: bis_collection_utilities.log( 'Begin Incremental Load' );

477: begin
478:
479: local_init;
480:
481: bis_collection_utilities.log( 'Begin Incremental Load' );
482:
483: l_stmt_id := 0;
484: if not bis_collection_utilities.setup( g_object_name ) then
485: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';

Line 484: if not bis_collection_utilities.setup( g_object_name ) then

480:
481: bis_collection_utilities.log( 'Begin Incremental Load' );
482:
483: l_stmt_id := 0;
484: if not bis_collection_utilities.setup( g_object_name ) then
485: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';
486: logger( l_proc_name, l_stmt_id, l_error_message );
487: raise g_bis_setup_exception;
488: end if;

Line 485: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';

481: bis_collection_utilities.log( 'Begin Incremental Load' );
482:
483: l_stmt_id := 0;
484: if not bis_collection_utilities.setup( g_object_name ) then
485: l_error_message := 'Error in BIS_COLLECTION_UTILITIES.Setup';
486: logger( l_proc_name, l_stmt_id, l_error_message );
487: raise g_bis_setup_exception;
488: end if;
489:

Line 499: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );

495: end if;
496: l_collect_from_date := l_collect_to_date + 1/86400;
497: l_collect_to_date := sysdate;
498:
499: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
500: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
501:
502: -- get the isc schema name
503: l_stmt_id := 20;

Line 500: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );

496: l_collect_from_date := l_collect_to_date + 1/86400;
497: l_collect_to_date := sysdate;
498:
499: bis_collection_utilities.log( 'From: ' || fnd_date.date_to_displaydt(l_collect_from_date), 1 );
500: bis_collection_utilities.log( 'To: ' || fnd_date.date_to_displaydt(l_collect_to_date), 1 );
501:
502: -- get the isc schema name
503: l_stmt_id := 20;
504: if get_schema_name

Line 521: bis_collection_utilities.log( 'Staging table truncated', 1 );

517: logger( l_proc_name, l_stmt_id, l_error_message );
518: raise l_exception;
519: end if;
520:
521: bis_collection_utilities.log( 'Staging table truncated', 1 );
522:
523: -- this detects all SR with changed associations
524: l_stmt_id := 40;
525: insert into

Line 556: bis_collection_utilities.log( l_rowcount || ' rows inserted staging table from association', 1 );

552: where a.last_update_date >= l_collect_from_date;
553:
554: l_rowcount := sql%rowcount;
555:
556: bis_collection_utilities.log( l_rowcount || ' rows inserted staging table from association', 1 );
557:
558: -- this detects all SR where associated WO is updated
559: l_stmt_id := 50;
560: merge into

Line 614: bis_collection_utilities.log( l_rowcount || ' rows merged into staging table from work orders', 1 );

610: );
611:
612: l_rowcount := sql%rowcount;
613:
614: bis_collection_utilities.log( l_rowcount || ' rows merged into staging table from work orders', 1 );
615:
616: -- this detects new or updated SR of type maintenance
617: /*
618: -- this is no longer performed, we will only track changes to dimension values

Line 687: bis_collection_utilities.log( l_rowcount || ' rows merged into staging table from incident audits', 1 );

683: );
684:
685: l_rowcount := sql%rowcount;
686:
687: bis_collection_utilities.log( l_rowcount || ' rows merged into staging table from incident audits', 1 );
688: */
689:
690: -- gather statistics on staging table
691: l_stmt_id := 70;

Line 700: bis_collection_utilities.log( 'Staging table analyzed', 1 );

696: logger( l_proc_name, l_stmt_id, l_error_message );
697: raise l_exception;
698: end if;
699:
700: bis_collection_utilities.log( 'Staging table analyzed', 1 );
701:
702: -- merge staging table into base fact
703: l_stmt_id := 80;
704: merge

Line 983: bis_collection_utilities.log( l_rowcount || ' rows merged into base summary', 1 );

979: l_rowcount := sql%rowcount;
980:
981: commit;
982:
983: bis_collection_utilities.log( l_rowcount || ' rows merged into base summary', 1 );
984:
985: -- housekeeping/cleanup truncate the staging table
986: l_stmt_id := 90;
987: if truncate_table

Line 995: bis_collection_utilities.log( 'Staging table truncated', 1 );

991: logger( l_proc_name, l_stmt_id, l_error_message );
992: raise l_exception;
993: end if;
994:
995: bis_collection_utilities.log( 'Staging table truncated', 1 );
996: l_stmt_id := 100;
997: bis_collection_utilities.wrapup( p_status => true
998: , p_period_from => l_collect_from_date
999: , p_period_to => l_collect_to_date

Line 997: bis_collection_utilities.wrapup( p_status => true

993: end if;
994:
995: bis_collection_utilities.log( 'Staging table truncated', 1 );
996: l_stmt_id := 100;
997: bis_collection_utilities.wrapup( p_status => true
998: , p_period_from => l_collect_from_date
999: , p_period_to => l_collect_to_date
1000: , p_count => l_rowcount
1001: );

Line 1003: bis_collection_utilities.log('End Incremental Load');

999: , p_period_to => l_collect_to_date
1000: , p_count => l_rowcount
1001: );
1002:
1003: bis_collection_utilities.log('End Incremental Load');
1004:
1005: errbuf := null;
1006: retcode := g_success;
1007:

Line 1019: bis_collection_utilities.wrapup( p_status => false

1015: rollback;
1016: if l_error_message is null then
1017: l_error_message := substr(sqlerrm,1,4000);
1018: end if;
1019: bis_collection_utilities.wrapup( p_status => false
1020: , p_message => l_error_message
1021: , p_period_from => l_collect_from_date
1022: , p_period_to => l_collect_to_date
1023: );