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_DEPOT_MTTR_ETL_PKG dependencies on BIS_COLLECTION_UTILITIES

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

39: l_to_date date;
40:
41: begin
42:
43: bis_collection_utilities.log( 'Begin Initial Load' );
44:
45: l_stmt_id := 0;
46: if not bis_collection_utilities.setup( g_object_name ) then
47: l_message := isc_depot_backlog_etl_pkg.err_mesg

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

42:
43: bis_collection_utilities.log( 'Begin Initial Load' );
44:
45: l_stmt_id := 0;
46: if not bis_collection_utilities.setup( g_object_name ) then
47: l_message := isc_depot_backlog_etl_pkg.err_mesg
48: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
49: , l_proc_name
50: , l_stmt_id

Line 48: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'

44:
45: l_stmt_id := 0;
46: if not bis_collection_utilities.setup( g_object_name ) then
47: l_message := isc_depot_backlog_etl_pkg.err_mesg
48: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
49: , l_proc_name
50: , l_stmt_id
51: );
52: bis_collection_utilities.put_line( l_message );

Line 52: bis_collection_utilities.put_line( l_message );

48: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
49: , l_proc_name
50: , l_stmt_id
51: );
52: bis_collection_utilities.put_line( l_message );
53: raise l_exception;
54: end if;
55:
56: l_stmt_id := 10;

Line 65: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

61: ) <> c_ok then
62: raise l_exception;
63: end if;
64:
65: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
66:
67: l_stmt_id := 20;
68: delete
69: from isc_dr_inc

Line 72: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );

68: delete
69: from isc_dr_inc
70: where fact_name = 'ISC_DR_MTTR_F';
71:
72: bis_collection_utilities.log( 'Deleted from table ISC_DR_INC', 1 );
73:
74: l_stmt_id := 30;
75: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_MTTR_F';
76:

Line 77: bis_collection_utilities.log( 'Truncated table ISC_DR_MTTR_F', 1 );

73:
74: l_stmt_id := 30;
75: execute immediate 'TRUNCATE TABLE ' || g_isc_schema || '.ISC_DR_MTTR_F';
76:
77: bis_collection_utilities.log( 'Truncated table ISC_DR_MTTR_F', 1 );
78:
79: l_stmt_id := 40;
80: if isc_depot_backlog_etl_pkg.get_last_run_date
81: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

Line 93: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );

89: l_message := 'Please launch the Intial Load Request Set for the Depot Repair Management page.';
90: raise l_exception;
91: end if;
92:
93: bis_collection_utilities.log( 'Repair Order To Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );
94:
95: l_to_date := sysdate;
96:
97: l_stmt_id := 50;

Line 164: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

160: group by
161: bdr.repair_line_id;
162:
163: l_rowcount := sql%rowcount;
164: bis_collection_utilities.log( 'Inserted ' || l_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
165:
166: l_stmt_id := 60;
167: commit;
168:

Line 231: bis_collection_utilities.log( 'Inserted ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

227: group by
228: bdr.repair_line_id;
229:
230: l_temp_rowcount := sql%rowcount;
231: bis_collection_utilities.log( 'Inserted ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
232: l_rowcount := l_rowcount + l_temp_rowcount;
233:
234: l_stmt_id := 80;
235: commit;

Line 301: bis_collection_utilities.log( 'Inserted ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

297: and bdr.date_closed is not null
298: and bdr.ro_creation_date >= g_global_start_date;
299:
300: l_temp_rowcount := sql%rowcount;
301: bis_collection_utilities.log( 'Inserted ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
302: l_rowcount := l_rowcount + l_temp_rowcount;
303:
304: l_stmt_id := 100;
305: commit;

Line 338: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );

334: , l_program_application_id
335: , l_request_id
336: );
337:
338: bis_collection_utilities.log( 'Inserted into table ISC_DR_INC', 1 );
339:
340: l_stmt_id := 120;
341: commit;
342:

Line 344: bis_collection_utilities.wrapup( p_status => true

340: l_stmt_id := 120;
341: commit;
342:
343: l_stmt_id := 130;
344: bis_collection_utilities.wrapup( p_status => true
345: , p_period_from => g_global_start_date
346: , p_period_to => l_to_date
347: , p_count => l_rowcount
348: );

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

348: );
349:
350: retcode := c_ok;
351:
352: bis_collection_utilities.log( 'End Initial Load' );
353:
354: exception
355:
356: when l_exception then

Line 358: bis_collection_utilities.wrapup( p_status => false

354: exception
355:
356: when l_exception then
357: rollback;
358: bis_collection_utilities.wrapup( p_status => false
359: , p_period_from => g_global_start_date
360: , p_period_to => l_to_date
361: , p_message => l_message
362: );

Line 373: bis_collection_utilities.put_line( l_message );

369: ( sqlerrm
370: , l_proc_name
371: , l_stmt_id
372: );
373: bis_collection_utilities.put_line( l_message );
374: bis_collection_utilities.wrapup( p_status => false
375: , p_period_from => g_global_start_date
376: , p_period_to => l_to_date
377: , p_message => l_message

Line 374: bis_collection_utilities.wrapup( p_status => false

370: , l_proc_name
371: , l_stmt_id
372: );
373: bis_collection_utilities.put_line( l_message );
374: bis_collection_utilities.wrapup( p_status => false
375: , p_period_from => g_global_start_date
376: , p_period_to => l_to_date
377: , p_message => l_message
378: );

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

413: l_to_date date;
414:
415: begin
416:
417: bis_collection_utilities.log( 'Begin Incremental Load' );
418:
419: l_stmt_id := 0;
420: if not bis_collection_utilities.setup( g_object_name ) then
421: l_message := isc_depot_backlog_etl_pkg.err_mesg

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

416:
417: bis_collection_utilities.log( 'Begin Incremental Load' );
418:
419: l_stmt_id := 0;
420: if not bis_collection_utilities.setup( g_object_name ) then
421: l_message := isc_depot_backlog_etl_pkg.err_mesg
422: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
423: , l_proc_name
424: , l_stmt_id

Line 422: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'

418:
419: l_stmt_id := 0;
420: if not bis_collection_utilities.setup( g_object_name ) then
421: l_message := isc_depot_backlog_etl_pkg.err_mesg
422: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
423: , l_proc_name
424: , l_stmt_id
425: );
426: bis_collection_utilities.put_line( l_message );

Line 426: bis_collection_utilities.put_line( l_message );

422: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
423: , l_proc_name
424: , l_stmt_id
425: );
426: bis_collection_utilities.put_line( l_message );
427: raise l_exception;
428: end if;
429:
430: l_stmt_id := 10;

Line 439: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );

435: ) <> c_ok then
436: raise l_exception;
437: end if;
438:
439: bis_collection_utilities.log( 'Global Start Date: ' || fnd_date.date_to_displaydt(g_global_start_date), 1 );
440:
441: l_stmt_id := 20;
442: if isc_depot_backlog_etl_pkg.get_last_run_date
443: ( p_fact_name => 'ISC_DR_MTTR_F'

Line 455: bis_collection_utilities.log( 'MTTR From Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );

451: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
452: raise l_exception;
453: end if;
454:
455: bis_collection_utilities.log( 'MTTR From Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );
456:
457: l_stmt_id := 30;
458: if isc_depot_backlog_etl_pkg.get_last_run_date
459: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

Line 471: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_last_run_date), 1 );

467: l_message := 'Please run the Intial Load Request Set for the Depot Repair Management page.';
468: raise l_exception;
469: end if;
470:
471: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_last_run_date), 1 );
472:
473: l_to_date := sysdate;
474:
475: l_stmt_id := 40;

Line 564: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

560: , l_request_id
561: );
562:
563: l_rowcount := sql%rowcount;
564: bis_collection_utilities.log( 'Merged ' || l_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
565:
566: l_stmt_id := 50;
567: -- Insertion/Updation of repair orders with Refurbishment repair type
568: -- for Non-serialized items

Line 652: bis_collection_utilities.log( 'Merged ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

648: , l_request_id
649: );
650:
651: l_temp_rowcount := sql%rowcount;
652: bis_collection_utilities.log( 'Merged ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
653: l_rowcount := l_rowcount + l_temp_rowcount;
654:
655: l_stmt_id := 60;
656: -- Insertion/Updation of repair orders with Refurbishment repair type for

Line 743: bis_collection_utilities.log( 'Merged ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );

739: , l_request_id
740: );
741:
742: l_temp_rowcount := sql%rowcount;
743: bis_collection_utilities.log( 'Merged ' || l_temp_rowcount || ' rows into ISC_DR_MTTR_F' , 1 );
744: l_rowcount := l_rowcount + l_temp_rowcount;
745:
746: l_stmt_id := 70;
747: update isc_dr_inc

Line 758: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );

754: , program_application_id = l_program_application_id
755: , request_id = l_request_id
756: WHERE fact_name = 'ISC_DR_MTTR_F' ;
757:
758: bis_collection_utilities.log( 'Updated into table ISC_DR_INC', 1 );
759:
760: l_stmt_id := 80;
761: commit;
762:

Line 764: bis_collection_utilities.wrapup( p_status => true

760: l_stmt_id := 80;
761: commit;
762:
763: l_stmt_id := 90;
764: bis_collection_utilities.wrapup( p_status => true
765: , p_period_from => l_run_date
766: , p_period_to => l_to_date
767: , p_count => l_rowcount
768: );

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

768: );
769:
770: retcode := c_ok;
771:
772: bis_collection_utilities.log( 'End Incremental Load' );
773:
774: exception
775:
776: when l_exception then

Line 778: bis_collection_utilities.wrapup( p_status => false

774: exception
775:
776: when l_exception then
777: rollback;
778: bis_collection_utilities.wrapup( p_status => false
779: , p_period_from => l_run_date
780: , p_period_to => l_to_date
781: , p_message => l_message
782: );

Line 793: bis_collection_utilities.put_line( l_message );

789: ( sqlerrm
790: , l_proc_name
791: , l_stmt_id
792: );
793: bis_collection_utilities.put_line( l_message );
794: bis_collection_utilities.wrapup( p_status => false
795: , p_period_from => l_run_date
796: , p_period_to => l_to_date
797: , p_message => l_message

Line 794: bis_collection_utilities.wrapup( p_status => false

790: , l_proc_name
791: , l_stmt_id
792: );
793: bis_collection_utilities.put_line( l_message );
794: bis_collection_utilities.wrapup( p_status => false
795: , p_period_from => l_run_date
796: , p_period_to => l_to_date
797: , p_message => l_message
798: );