[Home] [Help]
88: -- ***********************************************************************
89: PROCEDURE msg(p_msg IN VARCHAR2) IS
90: BEGIN
91: IF g_concurrent THEN
92: bis_collection_utilities.log(p_msg,0);
93: ELSE
94: hr_utility.trace(p_msg);
95: END IF;
96: END msg;
793: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
794: --
795: BEGIN
796: -- Do the BIS refresh framework setup
797: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN
798: dbg('Failed to setup bis collection utilities');
799: errbuf := g_setup_failure;
800: raise_application_error(g_appl_err,g_setup_failure);
801: END IF;
794: --
795: BEGIN
796: -- Do the BIS refresh framework setup
797: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN
798: dbg('Failed to setup bis collection utilities');
799: errbuf := g_setup_failure;
800: raise_application_error(g_appl_err,g_setup_failure);
801: END IF;
802: msg(g_start_full_msg);
814: dbg('Processed refresh table: '||l_tot_rec||' records');
815: --
816: -- Do the proper refresh framework wrapup
817: msg(g_success_message);
818: bis_collection_utilities.wrapup(
819: p_status => TRUE,
820: p_count => l_tot_rec,
821: p_message => g_success_message,
822: p_period_from => l_start_date,
829: ROLLBACK;
830: dbg('Run failed, logging errors');
831: msg(g_failure_message||SQLERRM);
832: errbuf := g_failure_message||SQLERRM;
833: bis_collection_utilities.wrapup(
834: p_status => FALSE,
835: p_count => l_tot_rec,
836: p_message => g_failure_message||SQLERRM,
837: p_period_from => l_start_date,
860: l_supv_tab pay_events_wrapper.t_summary_refresh_tab_type;
861: --
862: BEGIN
863: -- Do the BIS refresh framework setup
864: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN
865: dbg('Failed to set up bis collection utilities');
866: errbuf := g_setup_failure;
867: raise_application_error(g_appl_err,g_setup_failure);
868: END IF;
861: --
862: BEGIN
863: -- Do the BIS refresh framework setup
864: IF bis_collection_utilities.setup(p_object_name => object_name) = FALSE THEN
865: dbg('Failed to set up bis collection utilities');
866: errbuf := g_setup_failure;
867: raise_application_error(g_appl_err,g_setup_failure);
868: END IF;
869: msg(g_start_delta_msg);
868: END IF;
869: msg(g_start_delta_msg);
870: --
871: -- Get the dates of the last refresh of this program
872: bis_collection_utilities.get_last_refresh_dates(
873: object_name,
874: l_bis_start_date,
875: l_bis_end_date,
876: l_period_from,
889: '->'||
890: fnd_date.date_to_canonical(l_end_date)
891: );
892: IF l_start_date > l_end_date THEN
893: dbg('ERROR: BIS collection utilities reports last refresh period later than current date, trying to continue anyway');
894: END IF;
895: --
896: -- Get the list of all supervisors for which separations have potentially
897: -- occurred within the *real* dates specified by the input parameters
906: dbg('Processed refresh table: '||l_tot_rec||' records');
907: --
908: -- Do the proper refresh framework wrapup
909: msg(g_success_message);
910: bis_collection_utilities.wrapup(
911: p_status => TRUE,
912: p_count => l_tot_rec,
913: p_message => g_success_message,
914: p_period_from => l_start_date,
921: ROLLBACK;
922: dbg('Run failed, logging errors');
923: msg(g_failure_message||SQLERRM);
924: errbuf := g_failure_message||SQLERRM;
925: bis_collection_utilities.wrapup(
926: p_status => FALSE,
927: p_count => l_tot_rec,
928: p_message => g_failure_message||SQLERRM,
929: p_period_from => l_start_date,