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
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;
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'
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'
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;