APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on ISC_DEPOT_BACKLOG_ETL_PKG

Line 47: l_message := isc_depot_backlog_etl_pkg.err_mesg

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
51: );

Line 57: if isc_depot_backlog_etl_pkg.check_initial_load_setup

53: raise l_exception;
54: end if;
55:
56: l_stmt_id := 10;
57: if isc_depot_backlog_etl_pkg.check_initial_load_setup
58: ( x_global_start_date => g_global_start_date
59: , x_isc_schema => g_isc_schema
60: , x_message => l_message
61: ) <> c_ok then

Line 80: if isc_depot_backlog_etl_pkg.get_last_run_date

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'
82: , x_run_date => l_run_date
83: , x_message => l_message
84: ) <> c_ok then

Line 368: l_message := isc_depot_backlog_etl_pkg.err_mesg

364: errbuf := l_message;
365:
366: when others then
367: rollback;
368: l_message := isc_depot_backlog_etl_pkg.err_mesg
369: ( sqlerrm
370: , l_proc_name
371: , l_stmt_id
372: );

Line 421: l_message := isc_depot_backlog_etl_pkg.err_mesg

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
425: );

Line 431: if isc_depot_backlog_etl_pkg.check_initial_load_setup

427: raise l_exception;
428: end if;
429:
430: l_stmt_id := 10;
431: if isc_depot_backlog_etl_pkg.check_initial_load_setup
432: ( x_global_start_date => g_global_start_date
433: , x_isc_schema => g_isc_schema
434: , x_message => l_message
435: ) <> c_ok then

Line 442: if isc_depot_backlog_etl_pkg.get_last_run_date

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'
444: , x_run_date => l_run_date
445: , x_message => l_message
446: ) <> c_ok then

Line 458: if isc_depot_backlog_etl_pkg.get_last_run_date

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'
460: , x_run_date => l_last_run_date
461: , x_message => l_message
462: ) <> c_ok then

Line 788: l_message := isc_depot_backlog_etl_pkg.err_mesg

784: errbuf := l_message;
785:
786: when others then
787: rollback;
788: l_message := isc_depot_backlog_etl_pkg.err_mesg
789: ( sqlerrm
790: , l_proc_name
791: , l_stmt_id
792: );