APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DEPOT_BACKLOG_ETL_PKG

Line 469: l_message := isc_depot_backlog_etl_pkg.err_mesg

465: bis_collection_utilities.log( 'Begin Initial Load' );
466:
467: l_stmnt_id := 0;
468: if not bis_collection_utilities.setup( g_charges_object_name ) then
469: l_message := isc_depot_backlog_etl_pkg.err_mesg
470: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
471: , l_proc_name
472: , l_stmnt_id
473: );

Line 504: if isc_depot_backlog_etl_pkg.get_last_run_date

500:
501: bis_collection_utilities.log( 'Truncated table ISC_DR_CHARGES_F', 1 );
502:
503: l_stmnt_id := 40;
504: if isc_depot_backlog_etl_pkg.get_last_run_date
505: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
506: , x_run_date => l_ro_last_run_date
507: , x_message => l_message
508: ) <> c_ok then

Line 711: l_message := isc_depot_backlog_etl_pkg.err_mesg

707: bis_collection_utilities.log( 'Begin Initial Load' );
708:
709: l_stmnt_id := 0;
710: if not bis_collection_utilities.setup( g_costs_object_name ) then
711: l_message := isc_depot_backlog_etl_pkg.err_mesg
712: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
713: , l_proc_name
714: , l_stmnt_id
715: );

Line 756: if isc_depot_backlog_etl_pkg.get_last_run_date

752:
753: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_F', 1 );
754:
755: l_stmnt_id := 60;
756: if isc_depot_backlog_etl_pkg.get_last_run_date
757: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
758: , x_run_date => l_ro_last_run_date
759: , x_message => l_message
760: ) <> c_ok then

Line 938: l_message := isc_depot_backlog_etl_pkg.err_mesg

934: bis_collection_utilities.log( 'Begin Incremental Load' );
935:
936: l_stmnt_id := 0;
937: if not bis_collection_utilities.setup( g_charges_object_name ) then
938: l_message := isc_depot_backlog_etl_pkg.err_mesg
939: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
940: , l_proc_name
941: , l_stmnt_id
942: );

Line 961: if isc_depot_backlog_etl_pkg.get_last_run_date

957: bis_collection_utilities.log( 'Secondary Global Currency: ' || g_global_sec_curr_code, 1 );
958: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );
959:
960: l_stmnt_id := 20;
961: if isc_depot_backlog_etl_pkg.get_last_run_date
962: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
963: , x_run_date => l_ro_last_run_date
964: , x_message => l_message
965: ) <> c_ok then

Line 977: if isc_depot_backlog_etl_pkg.get_last_run_date

973:
974: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
975:
976: l_stmnt_id := 30;
977: if isc_depot_backlog_etl_pkg.get_last_run_date
978: ( p_fact_name => 'ISC_DR_CHARGES_F'
979: , x_run_date => l_charges_last_run_date
980: , x_message => l_message
981: ) <> c_ok then

Line 1203: l_message := isc_depot_backlog_etl_pkg.err_mesg

1199: bis_collection_utilities.log( 'Begin Incremental Load' );
1200:
1201: l_stmnt_id := 0;
1202: if not bis_collection_utilities.setup( g_costs_object_name ) then
1203: l_message := isc_depot_backlog_etl_pkg.err_mesg
1204: ( 'Error in BIS_COLLECTION_UTILITIES.Setup'
1205: , l_proc_name
1206: , l_stmnt_id
1207: );

Line 1236: if isc_depot_backlog_etl_pkg.get_last_run_date

1232:
1233: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
1234:
1235: l_stmnt_id := 40;
1236: if isc_depot_backlog_etl_pkg.get_last_run_date
1237: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
1238: , x_run_date => l_ro_last_run_date
1239: , x_message => l_message
1240: ) <> c_ok then

Line 1252: if isc_depot_backlog_etl_pkg.get_last_run_date

1248:
1249: bis_collection_utilities.log( 'Repair Order From Date: ' || fnd_date.date_to_displaydt(l_ro_last_run_date), 1 );
1250:
1251: l_stmnt_id := 50;
1252: if isc_depot_backlog_etl_pkg.get_last_run_date
1253: ( p_fact_name => 'ISC_DR_COSTS_F'
1254: , x_run_date => l_costs_last_run_date
1255: , x_message => l_message
1256: ) <> c_ok then