APPS.BSC_UPDATE dependencies on BSC_UPDATE_LOG

Line 489: IF NOT BSC_UPDATE_LOG.Init_Log_File(h_log_file_name) THEN

485: -- Initiliaze log file
486: IF NOT BSC_APPS.APPS_ENV THEN
487: h_log_file_name := g_schema_name||g_process_id||'.log';
488:
489: IF NOT BSC_UPDATE_LOG.Init_Log_File(h_log_file_name) THEN
490: RAISE e_update_error;
491: END IF;
492: END IF;
493:

Line 495: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'PROCESS_ID')||

491: END IF;
492: END IF;
493:
494: -- Write process_id to log file
495: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'PROCESS_ID')||
496: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
497: ' '||TO_CHAR(g_process_id), BSC_UPDATE_LOG.LOG);
498:
499: BSC_UPDATE_LOG.Write_Line_Log(USERENV('SESSIONID'), BSC_UPDATE_LOG.LOG);

Line 497: ' '||TO_CHAR(g_process_id), BSC_UPDATE_LOG.LOG);

493:
494: -- Write process_id to log file
495: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'PROCESS_ID')||
496: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
497: ' '||TO_CHAR(g_process_id), BSC_UPDATE_LOG.LOG);
498:
499: BSC_UPDATE_LOG.Write_Line_Log(USERENV('SESSIONID'), BSC_UPDATE_LOG.LOG);
500:
501: -- Update the status of the pending process to running

Line 499: BSC_UPDATE_LOG.Write_Line_Log(USERENV('SESSIONID'), BSC_UPDATE_LOG.LOG);

495: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'PROCESS_ID')||
496: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
497: ' '||TO_CHAR(g_process_id), BSC_UPDATE_LOG.LOG);
498:
499: BSC_UPDATE_LOG.Write_Line_Log(USERENV('SESSIONID'), BSC_UPDATE_LOG.LOG);
500:
501: -- Update the status of the pending process to running
502: IF NOT Set_PStatus_Running() THEN
503: RAISE e_update_error;

Line 804: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

800:
801: COMMIT;
802:
803: -- Write Program completed to log file
804: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
805: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
806: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
807: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
808:

Line 806: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

802:
803: -- Write Program completed to log file
804: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
805: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
806: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
807: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
808:
809: -- Delete records in the temporal table used for big 'in' conditions
810: BSC_APPS.Init_Big_In_Cond_Table;

Line 807: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

803: -- Write Program completed to log file
804: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
805: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
806: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
807: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
808:
809: -- Delete records in the temporal table used for big 'in' conditions
810: BSC_APPS.Init_Big_In_Cond_Table;
811:

Line 841: BSC_UPDATE_LOG.Write_Errors_To_Log;

837: x_source => 'BSC_UPDATE.Execute_Update_Process',
838: x_mode => 'I');
839: COMMIT;
840:
841: BSC_UPDATE_LOG.Write_Errors_To_Log;
842:
843: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
844: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
845: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 843: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

839: COMMIT;
840:
841: BSC_UPDATE_LOG.Write_Errors_To_Log;
842:
843: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
844: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
845: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
846: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
847:

Line 845: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

841: BSC_UPDATE_LOG.Write_Errors_To_Log;
842:
843: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
844: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
845: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
846: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
847:
848: WHEN e_exists_prototype_indicators THEN
849: -- Delete records in the temporal table used for big 'in' conditions

Line 846: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

842:
843: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
844: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
845: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
846: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
847:
848: WHEN e_exists_prototype_indicators THEN
849: -- Delete records in the temporal table used for big 'in' conditions
850: BSC_APPS.Init_Big_In_Cond_Table;

Line 858: BSC_UPDATE_LOG.Write_Errors_To_Log;

854: x_source => 'BSC_UPDATE.Execute_Update_Process',
855: x_mode => 'I');
856: COMMIT;
857:
858: BSC_UPDATE_LOG.Write_Errors_To_Log;
859:
860: IF g_process_id <> -1 THEN
861: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
862: COMMIT;

Line 865: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

861: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
862: COMMIT;
863: END IF;
864:
865: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
866: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
867: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
868: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
869:

Line 867: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

863: END IF;
864:
865: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
866: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
867: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
868: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
869:
870: WHEN e_update_error THEN
871: ROLLBACK;

Line 868: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

864:
865: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
866: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
867: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
868: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
869:
870: WHEN e_update_error THEN
871: ROLLBACK;
872:

Line 882: BSC_UPDATE_LOG.Write_Errors_To_Log;

878: x_source => 'BSC_UPDATE.Execute_Update_Process',
879: x_mode => 'I');
880: COMMIT;
881:
882: BSC_UPDATE_LOG.Write_Errors_To_Log;
883:
884: IF g_process_id <> -1 THEN
885: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
886: COMMIT;

Line 889: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

885: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
886: COMMIT;
887: END IF;
888:
889: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
890: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
891: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
892: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
893:

Line 891: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

887: END IF;
888:
889: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
890: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
891: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
892: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
893:
894: --catching the error in creating table for bug 3899523
895: --added 3899523

Line 892: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

888:
889: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
890: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
891: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
892: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
893:
894: --catching the error in creating table for bug 3899523
895: --added 3899523
896: WHEN e_tmp_tbl_create_error THEN

Line 907: BSC_UPDATE_LOG.Write_Errors_To_Log;

903: x_source => 'BSC_UPDATE.Execute_Update_Process',
904: x_mode => 'I');
905: COMMIT;
906:
907: BSC_UPDATE_LOG.Write_Errors_To_Log;
908:
909: IF g_process_id <> -1 THEN
910: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
911: COMMIT;

Line 914: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

910: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
911: COMMIT;
912: END IF;
913:
914: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
915: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
916: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
917: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
918:

Line 916: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

912: END IF;
913:
914: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
915: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
916: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
917: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
918:
919: --Fix bug#3923207: import dbi plans into bsc benchmarks
920: WHEN e_import_dbi_plans THEN

Line 917: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

913:
914: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
915: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
916: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
917: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
918:
919: --Fix bug#3923207: import dbi plans into bsc benchmarks
920: WHEN e_import_dbi_plans THEN
921: ROLLBACK;

Line 932: BSC_UPDATE_LOG.Write_Errors_To_Log;

928: x_source => 'BSC_UPDATE.Execute_Update_Process',
929: x_mode => 'I');
930: COMMIT;
931:
932: BSC_UPDATE_LOG.Write_Errors_To_Log;
933:
934: IF g_process_id <> -1 THEN
935: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
936: COMMIT;

Line 939: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

935: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
936: COMMIT;
937: END IF;
938:
939: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
940: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
941: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
942: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
943:

Line 941: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

937: END IF;
938:
939: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
940: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
941: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
942: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
943:
944: --LOCKING
945: WHEN e_could_not_get_lock THEN

Line 942: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

938:
939: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
940: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
941: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
942: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
943:
944: --LOCKING
945: WHEN e_could_not_get_lock THEN
946: ROLLBACK;

Line 959: BSC_UPDATE_LOG.Write_Errors_To_Log;

955: x_source => 'BSC_UPDATE.Execute_Update_Process',
956: x_mode => 'I');
957: COMMIT;
958:
959: BSC_UPDATE_LOG.Write_Errors_To_Log;
960:
961: IF g_process_id <> -1 THEN
962: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
963: COMMIT;

Line 966: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

962: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
963: COMMIT;
964: END IF;
965:
966: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
967: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
968: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
969: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
970:

Line 968: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

964: END IF;
965:
966: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
967: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
968: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
969: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
970:
971: WHEN OTHERS THEN
972: ROLLBACK;

Line 969: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

965:
966: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
967: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
968: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
969: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
970:
971: WHEN OTHERS THEN
972: ROLLBACK;
973:

Line 983: BSC_UPDATE_LOG.Write_Errors_To_Log;

979: x_source => 'BSC_UPDATE.Execute_Update_Process',
980: x_mode => 'I');
981: COMMIT;
982:
983: BSC_UPDATE_LOG.Write_Errors_To_Log;
984:
985: IF g_process_id <> -1 THEN
986: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
987: COMMIT;

Line 990: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

986: h_b := Set_PStatus_Finished(PC_ERROR_STATUS);
987: COMMIT;
988: END IF;
989:
990: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
991: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
992: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
993: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
994:

Line 992: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

988: END IF;
989:
990: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
991: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
992: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
993: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
994:
995: END Execute_Update_Process;
996:

Line 993: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

989:
990: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
991: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
992: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
993: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
994:
995: END Execute_Update_Process;
996:
997:

Line 1146: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_PROCESS')||' ('||

1142: --LOCKING: review no commit between this point and the commit to release the locks
1143:
1144: h_calendar_name := BSC_UPDATE_UTIL.Get_Calendar_Name(x_calendar_id);
1145:
1146: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_PROCESS')||' ('||
1147: h_calendar_name||')', BSC_UPDATE_LOG.OUTPUT);
1148:
1149: -- Get the current fiscal year
1150: h_current_fy := BSC_UPDATE_UTIL.Get_Calendar_Fiscal_Year(x_calendar_id);

Line 1147: h_calendar_name||')', BSC_UPDATE_LOG.OUTPUT);

1143:
1144: h_calendar_name := BSC_UPDATE_UTIL.Get_Calendar_Name(x_calendar_id);
1145:
1146: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_PROCESS')||' ('||
1147: h_calendar_name||')', BSC_UPDATE_LOG.OUTPUT);
1148:
1149: -- Get the current fiscal year
1150: h_current_fy := BSC_UPDATE_UTIL.Get_Calendar_Fiscal_Year(x_calendar_id);
1151: h_new_fiscal_year := h_current_fy + 1;

Line 1169: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

1165: -- The new fiscal year is not available
1166: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_DBI_YEAR_NOT_AVAILABLE');
1167: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'YEAR', TO_CHAR(h_new_fiscal_year));
1168: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'CALENDAR_NAME', h_calendar_name);
1169: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
1170: --LOCKING: commit to release locks
1171: COMMIT;
1172: RETURN FALSE;
1173: END IF;

Line 1583: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

1579: --LOCKING: commit to release locks
1580: COMMIT;
1581: END IF;
1582:
1583: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
1584:
1585: RETURN TRUE;
1586:
1587: EXCEPTION

Line 2208: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2204: -- Stored procedure
2205:
2206: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_IMPORTING_TO_ITABLE');
2207: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'INPUT_TABLE', h_input_table);
2208: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2209:
2210: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SOURCE')||
2211: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||h_source_name;
2212: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

Line 2212: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2208: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2209:
2210: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SOURCE')||
2211: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||h_source_name;
2212: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2213:
2214: -- LOCKING: Lock required objects
2215: IF NOT BSC_UPDATE_LOCK.Lock_Import_ITable(h_input_table) THEN
2216: RAISE e_could_not_get_lock;

Line 2336: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2332:
2333: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'ERROR')||
2334: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
2335: BSC_UPDATE_UTIL.Get_Message('BSC_STOREDPROC_FAILED');
2336: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2337: BSC_UPDATE_LOG.Write_Line_Log(SQLERRM, BSC_UPDATE_LOG.OUTPUT);
2338: END;
2339: /*
2340: ELSE

Line 2337: BSC_UPDATE_LOG.Write_Line_Log(SQLERRM, BSC_UPDATE_LOG.OUTPUT);

2333: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'ERROR')||
2334: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
2335: BSC_UPDATE_UTIL.Get_Message('BSC_STOREDPROC_FAILED');
2336: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2337: BSC_UPDATE_LOG.Write_Line_Log(SQLERRM, BSC_UPDATE_LOG.OUTPUT);
2338: END;
2339: /*
2340: ELSE
2341: -- Stored procedure is invalid

Line 2349: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2345:
2346: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'ERROR')||
2347: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
2348: BSC_UPDATE_UTIL.Get_Message('BSC_STOREDPROC_IS_INVALID');
2349: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2350: END IF;
2351: ELSE
2352: -- Stored procedure does not exists
2353: IF NOT Update_Status_Input_Table(x_input_table, LC_ERROR_STATUS, LC_UPLOAD_SP_NOT_FOUND_ERR) THEN

Line 2360: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2356:
2357: h_message := BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'ERROR')||
2358: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
2359: BSC_UPDATE_UTIL.Get_Message('BSC_STOREDPROC_NOT_FOUND');
2360: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2361: END IF;
2362: CLOSE c_status;
2363: */
2364: COMMIT;

Line 2522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPD_PROCESS'), BSC_UPDATE_LOG.OUTPUT);

2518: h_num_dim_tables := 0;
2519: h_num_loaded_tables := 0;
2520: h_num_input_tables_err_status := 0;
2521:
2522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPD_PROCESS'), BSC_UPDATE_LOG.OUTPUT);
2523:
2524: -- Get input table with status error
2525: OPEN c_input_tables_err_status;
2526: LOOP

Line 2606: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2602:
2603: -- Validate input table
2604: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_VALIDATION');
2605: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
2606: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2607: --LOCKING: call the automous transaction function
2608: h_table_is_valid := BSC_UPDATE_DIM.Validate_Input_Table_AT(h_input_table, h_dim_table);
2609:
2610: IF h_table_is_valid IS NULL THEN

Line 2618: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2614: IF h_table_is_valid THEN
2615: -- Input table doesn't have invalid codes
2616: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_VALIDCONF');
2617: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
2618: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2619:
2620: -- Update the stage of the input table to VALIDATED
2621: IF NOT Update_Stage_Input_Table(h_input_table, LC_VALIDATED_STAGE) THEN
2622: RAISE e_unexpected_error;

Line 2626: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_DIM_TABLE')||

2622: RAISE e_unexpected_error;
2623: END IF;
2624:
2625: -- Load the dimension table
2626: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_DIM_TABLE')||
2627: ' '||h_dim_table, BSC_UPDATE_LOG.OUTPUT);
2628:
2629: --LOCKING: Call the autonomous trnsaction
2630: IF NOT BSC_UPDATE_DIM.Load_Dim_Table_AT(h_dim_table, h_input_table) THEN

Line 2627: ' '||h_dim_table, BSC_UPDATE_LOG.OUTPUT);

2623: END IF;
2624:
2625: -- Load the dimension table
2626: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_DIM_TABLE')||
2627: ' '||h_dim_table, BSC_UPDATE_LOG.OUTPUT);
2628:
2629: --LOCKING: Call the autonomous trnsaction
2630: IF NOT BSC_UPDATE_DIM.Load_Dim_Table_AT(h_dim_table, h_input_table) THEN
2631: RAISE e_unexpected_error;

Line 2644: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2640: END IF;
2641:
2642: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATED_DIM_TABLE');
2643: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_dim_table);
2644: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2645: ELSE
2646: -- Input table has invalid codes
2647: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_INVALID_CODES_ITABLE');
2648: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);

Line 2649: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2645: ELSE
2646: -- Input table has invalid codes
2647: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_INVALID_CODES_ITABLE');
2648: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
2649: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2650:
2651: -- Update the status of input table to ERROR
2652: IF NOT Update_Status_Input_Table(h_input_table, LC_ERROR_STATUS, LC_INVALID_CODES_ERR) THEN
2653: RAISE e_unexpected_error;

Line 2662: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

2658:
2659: -- The input table cannot be processed because is an empty table
2660: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_DATA_ITABLE');
2661: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
2662: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2663:
2664: -- Update the status of the input table to NO_DATA
2665: IF NOT Update_Status_Input_Table(h_input_table, LC_NO_DATA_STATUS, NULL) THEN
2666: RAISE e_unexpected_error;

Line 2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);

2672: IF NOT h_dim_was_loaded THEN
2673: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(h_dim_table);
2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN
2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);
2677: --LOCKING: Call the autonomous transaction procedure
2678: BSC_UPDATE_DIM.Load_Dim_Into_AW_AT(h_dim_table);
2679: END IF;
2680: END IF;

Line 2711: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATED'), BSC_UPDATE_LOG.OUTPUT);

2707: RAISE e_unexpected_error;
2708: END IF;
2709: COMMIT;
2710:
2711: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATED'), BSC_UPDATE_LOG.OUTPUT);
2712:
2713: -- Write indicator with unexisting default dimenision values
2714: IF NOT BSC_UPDATE_DIM.WriteRemovedKeyItems THEN
2715: NULL;

Line 2932: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPD_PROCESS'), BSC_UPDATE_LOG.OUTPUT);

2928: h_num_base_tables_aw := 0;
2929: h_num_system_tables_aw := 0;
2930: h_num_indicators_aw := 0;
2931:
2932: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPD_PROCESS'), BSC_UPDATE_LOG.OUTPUT);
2933:
2934: -- Create generic temporal tables for the process
2935: --LOCKING: lock the temporary tables
2936: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('DATA') THEN

Line 3016: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3012:
3013: -- Validate input table
3014: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_VALIDATION');
3015: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
3016: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3017: --LOCKING: Call the autonomous transaction function
3018: h_table_is_valid := BSC_UPDATE_VAL.Validate_Codes_AT(h_input_table);
3019:
3020: IF h_table_is_valid IS NULL THEN

Line 3028: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3024: IF h_table_is_valid THEN
3025: -- Input table doesn't have invalid codes
3026: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_VALIDCONF');
3027: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
3028: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3029:
3030: -- Update the stage of the input table to VALIDATED
3031: --LOCKING: there is no commit inside this function so we do not need AT
3032: IF NOT Update_Stage_Input_Table(h_input_table, LC_VALIDATED_STAGE) THEN

Line 3037: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||

3033: RAISE e_unexpected_error;
3034: END IF;
3035:
3036: -- Update the base table
3037: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||
3038: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);
3039:
3040: -- ENH_B_TABLES_PERF: If the base table has a projection table then this is a new strategy.
3041: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);

Line 3038: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);

3034: END IF;
3035:
3036: -- Update the base table
3037: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||
3038: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);
3039:
3040: -- ENH_B_TABLES_PERF: If the base table has a projection table then this is a new strategy.
3041: h_proj_tbl_name := BSC_UPDATE_BASE_V2.Get_Base_Proj_Tbl_Name(h_base_table);
3042: IF h_proj_tbl_name IS NULL THEN

Line 3088: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3084: h_base_tables_to_color(h_num_base_tables_to_color) := h_base_table;
3085:
3086: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATED_BASE_TABLE');
3087: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_base_table);
3088: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3089:
3090: --LOCKING: we do not need to call this here. base tables are not used by any kpi
3091: -- Update Time Stamp of the indicators using this table directly
3092: --BSC_UPDATE_UTIL.Update_Kpi_Table_Time_Stamp(h_base_table);

Line 3098: BSC_UPDATE_LOG.Write_Line_Log(h_message,

3094: ELSE
3095: -- Input table has invalid codes
3096: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_INVALID_CODES_ITABLE');
3097: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
3098: BSC_UPDATE_LOG.Write_Line_Log(h_message,
3099: BSC_UPDATE_LOG.OUTPUT);
3100:
3101: -- Update the status of input table to ERROR
3102: --LOCKING: there is no commit inside this function so we do not need AT

Line 3099: BSC_UPDATE_LOG.OUTPUT);

3095: -- Input table has invalid codes
3096: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_INVALID_CODES_ITABLE');
3097: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
3098: BSC_UPDATE_LOG.Write_Line_Log(h_message,
3099: BSC_UPDATE_LOG.OUTPUT);
3100:
3101: -- Update the status of input table to ERROR
3102: --LOCKING: there is no commit inside this function so we do not need AT
3103: IF NOT Update_Status_Input_Table(h_input_table, LC_ERROR_STATUS, LC_INVALID_CODES_ERR) THEN

Line 3150: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3146: END IF;
3147:
3148: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATED_BASE_TABLE');
3149: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_base_table);
3150: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3151: ELSE
3152: -- The input table cannot be processed because is an empty table
3153: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_DATA_ITABLE');
3154: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);

Line 3155: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3151: ELSE
3152: -- The input table cannot be processed because is an empty table
3153: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_DATA_ITABLE');
3154: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
3155: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3156:
3157: -- Update the status of the input table to NO_DATA
3158: --LOCKING: there is no commit inside this function so we do not need AT
3159: IF NOT Update_Status_Input_Table(h_input_table, LC_NO_DATA_STATUS, NULL) THEN

Line 3200: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||

3196: -- are calculated in the base tables and the user could have activated projection
3197: -- so it needs to be calculatated.
3198:
3199: -- Update the base table
3200: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||
3201: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);
3202:
3203: -- AW_INTEGRATION: Know if the base table belongs to an AW Kpi
3204: IF BSC_APPS.bsc_mv THEN

Line 3201: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);

3197: -- so it needs to be calculatated.
3198:
3199: -- Update the base table
3200: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_BASE_TABLE')||
3201: ' '||h_base_table, BSC_UPDATE_LOG.OUTPUT);
3202:
3203: -- AW_INTEGRATION: Know if the base table belongs to an AW Kpi
3204: IF BSC_APPS.bsc_mv THEN
3205: h_aw_flag := BSC_UPDATE_UTIL.Is_Table_For_AW_Kpi(h_base_table);

Line 3227: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

3223: END IF;
3224:
3225: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATED_BASE_TABLE');
3226: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_base_table);
3227: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
3228:
3229: h_num_base_tables := h_num_base_tables + 1;
3230: h_base_tables(h_num_base_tables) := h_base_table;
3231:

Line 3337: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_PROCESS')||

3333: END IF;
3334:
3335: IF h_calc_summary_table THEN
3336: -- Calculate the summary (system) table
3337: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_PROCESS')||
3338: ' '||h_system_tables(h_i),
3339: BSC_UPDATE_LOG.OUTPUT);
3340:
3341:

Line 3339: BSC_UPDATE_LOG.OUTPUT);

3335: IF h_calc_summary_table THEN
3336: -- Calculate the summary (system) table
3337: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_PROCESS')||
3338: ' '||h_system_tables(h_i),
3339: BSC_UPDATE_LOG.OUTPUT);
3340:
3341:
3342: -- BSC-MV Note: In new architecture, call Calculate_Sum_Table_MV()
3343: IF BSC_APPS.bsc_mv THEN

Line 3398: BSC_UPDATE_LOG.Write_Line_Log(h_message,

3394: COMMIT;
3395:
3396: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALCULATED');
3397: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_system_tables(h_i));
3398: BSC_UPDATE_LOG.Write_Line_Log(h_message,
3399: BSC_UPDATE_LOG.OUTPUT);
3400:
3401: --LOCKING: remove this call
3402: -- Update Time Stamp of the indicators using this table directly

Line 3399: BSC_UPDATE_LOG.OUTPUT);

3395:
3396: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALCULATED');
3397: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_system_tables(h_i));
3398: BSC_UPDATE_LOG.Write_Line_Log(h_message,
3399: BSC_UPDATE_LOG.OUTPUT);
3400:
3401: --LOCKING: remove this call
3402: -- Update Time Stamp of the indicators using this table directly
3403: --LOCKING: Lock the indicator period fo the indicators using this table

Line 3453: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||

3449: END IF;
3450: END IF;
3451:
3452: IF h_calc_aw_kpi THEN
3453: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||
3454: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
3455: ' '||h_indicators_aw(h_i),
3456: BSC_UPDATE_LOG.OUTPUT);
3457:

Line 3456: BSC_UPDATE_LOG.OUTPUT);

3452: IF h_calc_aw_kpi THEN
3453: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||
3454: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
3455: ' '||h_indicators_aw(h_i),
3456: BSC_UPDATE_LOG.OUTPUT);
3457:
3458: --LOCKING: Lock the objects required to refresh the AW indicator cubes
3459: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_AW_Indicator(h_indicators_aw(h_i)) THEN
3460: RAISE e_could_not_get_lock;

Line 3532: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||

3528: END IF;
3529: END IF;
3530:
3531: IF h_calc_color THEN
3532: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||
3533: ' '||h_color_indicators(h_i),
3534: BSC_UPDATE_LOG.OUTPUT);
3535:
3536: --LOCKING: Calculate indicator period here

Line 3534: BSC_UPDATE_LOG.OUTPUT);

3530:
3531: IF h_calc_color THEN
3532: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||
3533: ' '||h_color_indicators(h_i),
3534: BSC_UPDATE_LOG.OUTPUT);
3535:
3536: --LOCKING: Calculate indicator period here
3537: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN
3538: RAISE e_could_not_get_lock;

Line 3569: BSC_UPDATE_LOG.Write_Line_log(h_message,

3565: COMMIT;
3566:
3567: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC_COMPLETED');
3568: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'INDICATOR', TO_CHAR(h_color_indicators(h_i)));
3569: BSC_UPDATE_LOG.Write_Line_log(h_message,
3570: BSC_UPDATE_LOG.OUTPUT);
3571:
3572: --LOCKING: Lock the update period of the indicator
3573: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN

Line 3570: BSC_UPDATE_LOG.OUTPUT);

3566:
3567: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC_COMPLETED');
3568: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'INDICATOR', TO_CHAR(h_color_indicators(h_i)));
3569: BSC_UPDATE_LOG.Write_Line_log(h_message,
3570: BSC_UPDATE_LOG.OUTPUT);
3571:
3572: --LOCKING: Lock the update period of the indicator
3573: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN
3574: RAISE e_could_not_get_lock;

Line 3646: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATED'), BSC_UPDATE_LOG.OUTPUT);

3642: END IF;
3643: COMMIT;
3644: END IF;
3645:
3646: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATED'), BSC_UPDATE_LOG.OUTPUT);
3647:
3648: RETURN TRUE;
3649: EXCEPTION
3650: WHEN e_unexpected_error THEN

Line 4099: BSC_UPDATE_LOG.Write_Errors_To_Log;

4095: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4096: X_Mode => 'I'
4097: );
4098:
4099: BSC_UPDATE_LOG.Write_Errors_To_Log;
4100:
4101: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4102: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4101: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4097: );
4098:
4099: BSC_UPDATE_LOG.Write_Errors_To_Log;
4100:
4101: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4102: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4104: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4105:

Line 4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4099: BSC_UPDATE_LOG.Write_Errors_To_Log;
4100:
4101: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4102: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4104: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4105:
4106: -- LOCKING
4107: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4104: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4100:
4101: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4102: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4104: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4105:
4106: -- LOCKING
4107: BSC_LOCKS_PUB.Remove_System_Lock;
4108:

Line 4132: BSC_UPDATE_LOG.Write_Errors_To_Log;

4128: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4129: x_mode => 'I');
4130: COMMIT;
4131:
4132: BSC_UPDATE_LOG.Write_Errors_To_Log;
4133:
4134: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4135: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4134: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4130: COMMIT;
4131:
4132: BSC_UPDATE_LOG.Write_Errors_To_Log;
4133:
4134: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4135: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4137: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4138:

Line 4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4132: BSC_UPDATE_LOG.Write_Errors_To_Log;
4133:
4134: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4135: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4137: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4138:
4139: -- LOCKING
4140: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4137: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4133:
4134: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4135: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4137: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4138:
4139: -- LOCKING
4140: BSC_LOCKS_PUB.Remove_System_Lock;
4141:

Line 4164: BSC_UPDATE_LOG.Write_Errors_To_Log;

4160: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4161: x_mode => 'I');
4162: COMMIT;
4163:
4164: BSC_UPDATE_LOG.Write_Errors_To_Log;
4165:
4166: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4167: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4168: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4166: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4162: COMMIT;
4163:
4164: BSC_UPDATE_LOG.Write_Errors_To_Log;
4165:
4166: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4167: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4168: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4169: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4170:

Line 4168: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4164: BSC_UPDATE_LOG.Write_Errors_To_Log;
4165:
4166: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4167: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4168: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4169: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4170:
4171: ERRBUF := SQLERRM;
4172: RETCODE := 2; -- Request completed with errors

Line 4169: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4165:
4166: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4167: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4168: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4169: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4170:
4171: ERRBUF := SQLERRM;
4172: RETCODE := 2; -- Request completed with errors
4173: End;

Line 4345: BSC_UPDATE_LOG.Write_Errors_To_Log;

4341: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4342: X_Mode => 'I'
4343: );
4344:
4345: BSC_UPDATE_LOG.Write_Errors_To_Log;
4346:
4347: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4348: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4347: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4343: );
4344:
4345: BSC_UPDATE_LOG.Write_Errors_To_Log;
4346:
4347: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4348: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4350: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4351:

Line 4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4345: BSC_UPDATE_LOG.Write_Errors_To_Log;
4346:
4347: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4348: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4350: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4351:
4352: -- LOCKING
4353: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4350: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4346:
4347: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4348: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4350: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4351:
4352: -- LOCKING
4353: BSC_LOCKS_PUB.Remove_System_Lock;
4354:

Line 4378: BSC_UPDATE_LOG.Write_Errors_To_Log;

4374: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4375: x_mode => 'I');
4376: COMMIT;
4377:
4378: BSC_UPDATE_LOG.Write_Errors_To_Log;
4379:
4380: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4381: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4380: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4376: COMMIT;
4377:
4378: BSC_UPDATE_LOG.Write_Errors_To_Log;
4379:
4380: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4381: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4383: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4384:

Line 4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4378: BSC_UPDATE_LOG.Write_Errors_To_Log;
4379:
4380: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4381: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4383: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4384:
4385: -- LOCKING
4386: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4383: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4379:
4380: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4381: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4383: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4384:
4385: -- LOCKING
4386: BSC_LOCKS_PUB.Remove_System_Lock;
4387:

Line 4517: BSC_UPDATE_LOG.Write_Errors_To_Log;

4513: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4514: X_Mode => 'I'
4515: );
4516:
4517: BSC_UPDATE_LOG.Write_Errors_To_Log;
4518:
4519: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4520: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4519: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4515: );
4516:
4517: BSC_UPDATE_LOG.Write_Errors_To_Log;
4518:
4519: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4520: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4523:

Line 4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4517: BSC_UPDATE_LOG.Write_Errors_To_Log;
4518:
4519: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4520: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4523:
4524: -- LOCKING
4525: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4518:
4519: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4520: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4523:
4524: -- LOCKING
4525: BSC_LOCKS_PUB.Remove_System_Lock;
4526:

Line 4550: BSC_UPDATE_LOG.Write_Errors_To_Log;

4546: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Dim_Apps',
4547: x_mode => 'I');
4548: COMMIT;
4549:
4550: BSC_UPDATE_LOG.Write_Errors_To_Log;
4551:
4552: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4553: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4552: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4548: COMMIT;
4549:
4550: BSC_UPDATE_LOG.Write_Errors_To_Log;
4551:
4552: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4553: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4555: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4556:

Line 4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4550: BSC_UPDATE_LOG.Write_Errors_To_Log;
4551:
4552: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4553: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4555: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4556:
4557: -- LOCKING
4558: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4555: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4551:
4552: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4553: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4555: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4556:
4557: -- LOCKING
4558: BSC_LOCKS_PUB.Remove_System_Lock;
4559:

Line 4664: BSC_UPDATE_LOG.Write_Errors_To_Log;

4660: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4661: X_Mode => 'I'
4662: );
4663:
4664: BSC_UPDATE_LOG.Write_Errors_To_Log;
4665:
4666: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4667: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4666: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4662: );
4663:
4664: BSC_UPDATE_LOG.Write_Errors_To_Log;
4665:
4666: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4667: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4669: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4670:

Line 4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4664: BSC_UPDATE_LOG.Write_Errors_To_Log;
4665:
4666: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4667: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4669: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4670:
4671: -- LOCKING
4672: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4669: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4665:
4666: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4667: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4669: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4670:
4671: -- LOCKING
4672: BSC_LOCKS_PUB.Remove_System_Lock;
4673:

Line 4690: BSC_UPDATE_LOG.Write_Errors_To_Log;

4686: x_source => 'BSC_UPDATE.Run_change_current_year',
4687: x_mode => 'I');
4688: COMMIT;
4689:
4690: BSC_UPDATE_LOG.Write_Errors_To_Log;
4691:
4692: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4693: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4692: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4688: COMMIT;
4689:
4690: BSC_UPDATE_LOG.Write_Errors_To_Log;
4691:
4692: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4693: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4695: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4696:

Line 4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4690: BSC_UPDATE_LOG.Write_Errors_To_Log;
4691:
4692: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4693: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4695: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4696:
4697: -- LOCKING
4698: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4695: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4691:
4692: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4693: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4695: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4696:
4697: -- LOCKING
4698: BSC_LOCKS_PUB.Remove_System_Lock;
4699:

Line 4852: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT'),

4848: END IF;
4849: h_lst_prod_indicators := h_lst_prod_indicators||h_indicators(h_i);
4850: ELSE
4851: IF h_first_prot_indic THEN
4852: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT'),
4853: BSC_UPDATE_LOG.OUTPUT);
4854: h_first_prot_indic := FALSE;
4855: g_warning := TRUE;
4856: END IF;

Line 4853: BSC_UPDATE_LOG.OUTPUT);

4849: h_lst_prod_indicators := h_lst_prod_indicators||h_indicators(h_i);
4850: ELSE
4851: IF h_first_prot_indic THEN
4852: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT'),
4853: BSC_UPDATE_LOG.OUTPUT);
4854: h_first_prot_indic := FALSE;
4855: g_warning := TRUE;
4856: END IF;
4857: BSC_UPDATE_LOG.Write_Line_Log(h_indicators(h_i)||' '||h_indic_name, BSC_UPDATE_LOG.OUTPUT);

Line 4857: BSC_UPDATE_LOG.Write_Line_Log(h_indicators(h_i)||' '||h_indic_name, BSC_UPDATE_LOG.OUTPUT);

4853: BSC_UPDATE_LOG.OUTPUT);
4854: h_first_prot_indic := FALSE;
4855: g_warning := TRUE;
4856: END IF;
4857: BSC_UPDATE_LOG.Write_Line_Log(h_indicators(h_i)||' '||h_indic_name, BSC_UPDATE_LOG.OUTPUT);
4858: END IF;
4859: END LOOP;
4860:
4861: -- Get input tables used for the indicators

Line 4944: BSC_UPDATE_LOG.Write_Errors_To_Log;

4940: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4941: X_Mode => 'I'
4942: );
4943:
4944: BSC_UPDATE_LOG.Write_Errors_To_Log;
4945:
4946: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4947: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4946: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4942: );
4943:
4944: BSC_UPDATE_LOG.Write_Errors_To_Log;
4945:
4946: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4947: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4949: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4950:

Line 4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4944: BSC_UPDATE_LOG.Write_Errors_To_Log;
4945:
4946: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4947: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4949: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4950:
4951: -- LOCKING
4952: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4949: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4945:
4946: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4947: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4949: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4950:
4951: -- LOCKING
4952: BSC_LOCKS_PUB.Remove_System_Lock;
4953:

Line 4972: BSC_UPDATE_LOG.Write_Errors_To_Log;

4968: ERRBUF := '';
4969: RETCODE := 1; -- Request completed with warning
4970:
4971: WHEN e_unexpected_error THEN
4972: BSC_UPDATE_LOG.Write_Errors_To_Log;
4973:
4974: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4975: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4974: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4970:
4971: WHEN e_unexpected_error THEN
4972: BSC_UPDATE_LOG.Write_Errors_To_Log;
4973:
4974: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4975: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4977: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4978:

Line 4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4972: BSC_UPDATE_LOG.Write_Errors_To_Log;
4973:
4974: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4975: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4977: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4978:
4979: -- LOCKING
4980: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4977: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4973:
4974: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4975: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4977: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4978:
4979: -- LOCKING
4980: BSC_LOCKS_PUB.Remove_System_Lock;
4981:

Line 4994: BSC_UPDATE_LOG.Write_Errors_To_Log;

4990: x_source => 'BSC_UPDATE.Load_Indicators_Data',
4991: x_mode => 'I');
4992: COMMIT;
4993:
4994: BSC_UPDATE_LOG.Write_Errors_To_Log;
4995:
4996: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4997: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 4996: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

4992: COMMIT;
4993:
4994: BSC_UPDATE_LOG.Write_Errors_To_Log;
4995:
4996: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4997: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4999: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5000:

Line 4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

4994: BSC_UPDATE_LOG.Write_Errors_To_Log;
4995:
4996: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4997: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4999: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5000:
5001: -- LOCKING
5002: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4999: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

4995:
4996: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
4997: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4999: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5000:
5001: -- LOCKING
5002: BSC_LOCKS_PUB.Remove_System_Lock;
5003:

Line 5158: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||

5154: END IF;
5155:
5156: h_dbi_dim_requests.delete;
5157: FOR h_i IN 1..h_num_dbi_dimensions LOOP
5158: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||
5159: ' '||h_dbi_dimensions(h_i), BSC_UPDATE_LOG.OUTPUT);
5160:
5161: h_dbi_dim_requests(h_i) := FND_REQUEST.Submit_Request(application => BSC_APPS.bsc_apps_short_name,
5162: program => 'BSC_REFRESH_DBI_DIM',

Line 5159: ' '||h_dbi_dimensions(h_i), BSC_UPDATE_LOG.OUTPUT);

5155:
5156: h_dbi_dim_requests.delete;
5157: FOR h_i IN 1..h_num_dbi_dimensions LOOP
5158: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_IVIEWER', 'REFRESH')||
5159: ' '||h_dbi_dimensions(h_i), BSC_UPDATE_LOG.OUTPUT);
5160:
5161: h_dbi_dim_requests(h_i) := FND_REQUEST.Submit_Request(application => BSC_APPS.bsc_apps_short_name,
5162: program => 'BSC_REFRESH_DBI_DIM',
5163: argument1 => h_dbi_dimensions(h_i));

Line 5168: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUBMMITREQ_FAILED'), BSC_UPDATE_LOG.OUTPUT);

5164:
5165:
5166: IF h_dbi_dim_requests(h_i) = 0 THEN
5167: -- Request error;
5168: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUBMMITREQ_FAILED'), BSC_UPDATE_LOG.OUTPUT);
5169: ELSE
5170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LOADER_REQ_ID')||
5171: ' '||h_dbi_dim_requests(h_i), BSC_UPDATE_LOG.OUTPUT);
5172: END IF;

Line 5170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LOADER_REQ_ID')||

5166: IF h_dbi_dim_requests(h_i) = 0 THEN
5167: -- Request error;
5168: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUBMMITREQ_FAILED'), BSC_UPDATE_LOG.OUTPUT);
5169: ELSE
5170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LOADER_REQ_ID')||
5171: ' '||h_dbi_dim_requests(h_i), BSC_UPDATE_LOG.OUTPUT);
5172: END IF;
5173: COMMIT;
5174: END LOOP;

Line 5171: ' '||h_dbi_dim_requests(h_i), BSC_UPDATE_LOG.OUTPUT);

5167: -- Request error;
5168: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_SUBMMITREQ_FAILED'), BSC_UPDATE_LOG.OUTPUT);
5169: ELSE
5170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LOADER_REQ_ID')||
5171: ' '||h_dbi_dim_requests(h_i), BSC_UPDATE_LOG.OUTPUT);
5172: END IF;
5173: COMMIT;
5174: END LOOP;
5175: -- --------------------------------------------------------------------------------

Line 5261: BSC_UPDATE_LOG.Write_Errors_To_Log;

5257: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
5258: X_Mode => 'I'
5259: );
5260:
5261: BSC_UPDATE_LOG.Write_Errors_To_Log;
5262:
5263: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5264: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 5263: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

5259: );
5260:
5261: BSC_UPDATE_LOG.Write_Errors_To_Log;
5262:
5263: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5264: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5266: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5267:

Line 5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

5261: BSC_UPDATE_LOG.Write_Errors_To_Log;
5262:
5263: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5264: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5266: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5267:
5268: -- LOCKING
5269: BSC_LOCKS_PUB.Remove_System_Lock;

Line 5266: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

5262:
5263: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5264: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5266: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5267:
5268: -- LOCKING
5269: BSC_LOCKS_PUB.Remove_System_Lock;
5270:

Line 5287: BSC_UPDATE_LOG.Write_Errors_To_Log;

5283: ERRBUF := '';
5284: RETCODE := 1; -- Request completed with warning
5285:
5286: WHEN e_unexpected_error THEN
5287: BSC_UPDATE_LOG.Write_Errors_To_Log;
5288:
5289: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5290: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 5289: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

5285:
5286: WHEN e_unexpected_error THEN
5287: BSC_UPDATE_LOG.Write_Errors_To_Log;
5288:
5289: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5290: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5292: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5293:

Line 5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

5287: BSC_UPDATE_LOG.Write_Errors_To_Log;
5288:
5289: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5290: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5292: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5293:
5294: -- LOCKING
5295: BSC_LOCKS_PUB.Remove_System_Lock;

Line 5292: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

5288:
5289: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5290: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5292: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5293:
5294: -- LOCKING
5295: BSC_LOCKS_PUB.Remove_System_Lock;
5296: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');

Line 5305: BSC_UPDATE_LOG.Write_Errors_To_Log;

5301: x_source => 'BSC_UPDATE.Load_Indicators_Dims',
5302: x_mode => 'I');
5303: COMMIT;
5304:
5305: BSC_UPDATE_LOG.Write_Errors_To_Log;
5306:
5307: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5308: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 5307: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

5303: COMMIT;
5304:
5305: BSC_UPDATE_LOG.Write_Errors_To_Log;
5306:
5307: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5308: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5310: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5311:

Line 5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

5305: BSC_UPDATE_LOG.Write_Errors_To_Log;
5306:
5307: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5308: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5310: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5311:
5312: -- LOCKING
5313: BSC_LOCKS_PUB.Remove_System_Lock;

Line 5310: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

5306:
5307: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5308: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5310: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5311:
5312: -- LOCKING
5313: BSC_LOCKS_PUB.Remove_System_Lock;
5314: ERRBUF := SQLERRM;

Line 5466: BSC_UPDATE_LOG.Write_Errors_To_Log;

5462: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
5463: X_Mode => 'I'
5464: );
5465:
5466: BSC_UPDATE_LOG.Write_Errors_To_Log;
5467:
5468: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5469: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 5468: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

5464: );
5465:
5466: BSC_UPDATE_LOG.Write_Errors_To_Log;
5467:
5468: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5469: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5471: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5472:

Line 5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

5466: BSC_UPDATE_LOG.Write_Errors_To_Log;
5467:
5468: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5469: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5471: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5472:
5473: -- LOCKING
5474: BSC_LOCKS_PUB.Remove_System_Lock;

Line 5471: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

5467:
5468: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5469: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5471: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5472:
5473: -- LOCKING
5474: BSC_LOCKS_PUB.Remove_System_Lock;
5475:

Line 5491: BSC_UPDATE_LOG.Write_Errors_To_Log;

5487: x_source => 'BSC_UPDATE.Delete_Indicators_Data',
5488: x_mode => 'I');
5489: COMMIT;
5490:
5491: BSC_UPDATE_LOG.Write_Errors_To_Log;
5492:
5493: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5494: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

Line 5493: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||

5489: COMMIT;
5490:
5491: BSC_UPDATE_LOG.Write_Errors_To_Log;
5492:
5493: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5494: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5496: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5497:

Line 5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);

5491: BSC_UPDATE_LOG.Write_Errors_To_Log;
5492:
5493: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5494: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5496: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5497:
5498: -- LOCKING
5499: BSC_LOCKS_PUB.Remove_System_Lock;

Line 5496: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);

5492:
5493: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'TIME')||
5494: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||
5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5496: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5497:
5498: -- LOCKING
5499: BSC_LOCKS_PUB.Remove_System_Lock;
5500:

Line 5787: IF BSC_UPDATE_LOG.Log_File_Name IS NULL THEN

5783:
5784: h_complete_log_file_name VARCHAR2(500);
5785:
5786: BEGIN
5787: IF BSC_UPDATE_LOG.Log_File_Name IS NULL THEN
5788: h_complete_log_file_name := NULL;
5789: ELSE
5790: h_complete_log_file_name := BSC_UPDATE_LOG.Log_File_Dir||'/'||BSC_UPDATE_LOG.Log_File_Name;
5791: END IF;

Line 5790: h_complete_log_file_name := BSC_UPDATE_LOG.Log_File_Dir||'/'||BSC_UPDATE_LOG.Log_File_Name;

5786: BEGIN
5787: IF BSC_UPDATE_LOG.Log_File_Name IS NULL THEN
5788: h_complete_log_file_name := NULL;
5789: ELSE
5790: h_complete_log_file_name := BSC_UPDATE_LOG.Log_File_Dir||'/'||BSC_UPDATE_LOG.Log_File_Name;
5791: END IF;
5792:
5793: UPDATE
5794: bsc_db_process_control

Line 6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

6156: h_periodicity_type NUMBER;
6157:
6158: BEGIN
6159: -- Result
6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

Line 6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6157:
6158: BEGIN
6159: -- Result
6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6165: BSC_UPDATE_LOG.OUTPUT);

Line 6162: BSC_UPDATE_LOG.OUTPUT);

6158: BEGIN
6159: -- Result
6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6165: BSC_UPDATE_LOG.OUTPUT);
6166: -- Get update date

Line 6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);

6159: -- Result
6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6165: BSC_UPDATE_LOG.OUTPUT);
6166: -- Get update date
6167: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value('UPDATE_DATE', h_update_date) THEN

Line 6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6160: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6165: BSC_UPDATE_LOG.OUTPUT);
6166: -- Get update date
6167: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value('UPDATE_DATE', h_update_date) THEN
6168: RAISE e_unexpected_error;

Line 6165: BSC_UPDATE_LOG.OUTPUT);

6161: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6162: BSC_UPDATE_LOG.OUTPUT);
6163: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROCESS_RESULT'), BSC_UPDATE_LOG.OUTPUT);
6164: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6165: BSC_UPDATE_LOG.OUTPUT);
6166: -- Get update date
6167: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value('UPDATE_DATE', h_update_date) THEN
6168: RAISE e_unexpected_error;
6169: END IF;

Line 6170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LAST_UPDATE')||' '||h_update_date, BSC_UPDATE_LOG.OUTPUT);

6166: -- Get update date
6167: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value('UPDATE_DATE', h_update_date) THEN
6168: RAISE e_unexpected_error;
6169: END IF;
6170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LAST_UPDATE')||' '||h_update_date, BSC_UPDATE_LOG.OUTPUT);
6171: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6172:
6173: --OPEN c_status FOR c_status_sql USING g_process_id;
6174: OPEN c_status(g_process_id);

Line 6171: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

6167: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value('UPDATE_DATE', h_update_date) THEN
6168: RAISE e_unexpected_error;
6169: END IF;
6170: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_LAST_UPDATE')||' '||h_update_date, BSC_UPDATE_LOG.OUTPUT);
6171: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6172:
6173: --OPEN c_status FOR c_status_sql USING g_process_id;
6174: OPEN c_status(g_process_id);
6175: FETCH c_status INTO h_input_table_name, h_status, h_error_code;

Line 6178: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||

6174: OPEN c_status(g_process_id);
6175: FETCH c_status INTO h_input_table_name, h_status, h_error_code;
6176:
6177: IF c_status%FOUND THEN
6178: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6179: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'STATUS'), C_STATUS_W),
6180: BSC_UPDATE_LOG.OUTPUT);
6181: END IF;
6182:

Line 6180: BSC_UPDATE_LOG.OUTPUT);

6176:
6177: IF c_status%FOUND THEN
6178: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6179: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'STATUS'), C_STATUS_W),
6180: BSC_UPDATE_LOG.OUTPUT);
6181: END IF;
6182:
6183: WHILE c_status%FOUND LOOP
6184: h_line := RPAD(h_input_table_name, C_TABLE_W);

Line 6219: BSC_UPDATE_LOG.Write_Line_Log(h_line, BSC_UPDATE_LOG.OUTPUT);

6215: ELSIF h_status = LC_COMPLETED_STATUS THEN
6216: h_line := h_line||BSC_UPDATE_UTIL.Get_Message('BSC_UPDATED_STATUS');
6217: END IF;
6218:
6219: BSC_UPDATE_LOG.Write_Line_Log(h_line, BSC_UPDATE_LOG.OUTPUT);
6220:
6221: FETCH c_status INTO h_input_table_name, h_status, h_error_code;
6222: END LOOP;
6223: CLOSE c_status;

Line 6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

6225: -- Invalid codes
6226: OPEN c_invalid_codes(g_process_id);
6227: FETCH c_invalid_codes INTO h_input_table_name, h_column_name, h_invalid_code;
6228: IF c_invalid_codes%FOUND THEN
6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);

Line 6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6226: OPEN c_invalid_codes(g_process_id);
6227: FETCH c_invalid_codes INTO h_input_table_name, h_column_name, h_invalid_code;
6228: IF c_invalid_codes%FOUND THEN
6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

Line 6231: BSC_UPDATE_LOG.OUTPUT);

6227: FETCH c_invalid_codes INTO h_input_table_name, h_column_name, h_invalid_code;
6228: IF c_invalid_codes%FOUND THEN
6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);

Line 6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),

6228: IF c_invalid_codes%FOUND THEN
6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||

Line 6233: BSC_UPDATE_LOG.OUTPUT);

6229: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6237: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'COLUMN'), C_COLUMN_W)||

Line 6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6230: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6237: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'COLUMN'), C_COLUMN_W)||
6238: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_CODE'), C_INVALID_CODE_W),

Line 6235: BSC_UPDATE_LOG.OUTPUT);

6231: BSC_UPDATE_LOG.OUTPUT);
6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6237: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'COLUMN'), C_COLUMN_W)||
6238: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_CODE'), C_INVALID_CODE_W),
6239: BSC_UPDATE_LOG.OUTPUT);

Line 6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||

6232: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_RECORDS'),
6233: BSC_UPDATE_LOG.OUTPUT);
6234: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6237: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'COLUMN'), C_COLUMN_W)||
6238: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_CODE'), C_INVALID_CODE_W),
6239: BSC_UPDATE_LOG.OUTPUT);
6240: END IF;

Line 6239: BSC_UPDATE_LOG.OUTPUT);

6235: BSC_UPDATE_LOG.OUTPUT);
6236: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_W)||
6237: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'COLUMN'), C_COLUMN_W)||
6238: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INVALID_CODE'), C_INVALID_CODE_W),
6239: BSC_UPDATE_LOG.OUTPUT);
6240: END IF;
6241:
6242: WHILE c_invalid_codes%FOUND LOOP
6243: BSC_UPDATE_LOG.Write_Line_Log(RPAD(h_input_table_name, C_TABLE_W)||

Line 6243: BSC_UPDATE_LOG.Write_Line_Log(RPAD(h_input_table_name, C_TABLE_W)||

6239: BSC_UPDATE_LOG.OUTPUT);
6240: END IF;
6241:
6242: WHILE c_invalid_codes%FOUND LOOP
6243: BSC_UPDATE_LOG.Write_Line_Log(RPAD(h_input_table_name, C_TABLE_W)||
6244: RPAD(h_column_name, C_COLUMN_W)||
6245: RPAD(h_invalid_code, C_INVALID_CODE_W), BSC_UPDATE_LOG.OUTPUT);
6246: FETCH c_invalid_codes INTO h_input_table_name, h_column_name, h_invalid_code;
6247: END LOOP;

Line 6245: RPAD(h_invalid_code, C_INVALID_CODE_W), BSC_UPDATE_LOG.OUTPUT);

6241:
6242: WHILE c_invalid_codes%FOUND LOOP
6243: BSC_UPDATE_LOG.Write_Line_Log(RPAD(h_input_table_name, C_TABLE_W)||
6244: RPAD(h_column_name, C_COLUMN_W)||
6245: RPAD(h_invalid_code, C_INVALID_CODE_W), BSC_UPDATE_LOG.OUTPUT);
6246: FETCH c_invalid_codes INTO h_input_table_name, h_column_name, h_invalid_code;
6247: END LOOP;
6248: CLOSE c_invalid_codes;
6249:

Line 6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

6249:
6250:
6251: -- Update periods
6252: IF g_process_name = PC_LOADER_PROCESS THEN
6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);

Line 6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6250:
6251: -- Update periods
6252: IF g_process_name = PC_LOADER_PROCESS THEN
6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

Line 6255: BSC_UPDATE_LOG.OUTPUT);

6251: -- Update periods
6252: IF g_process_name = PC_LOADER_PROCESS THEN
6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);

Line 6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),

6252: IF g_process_name = PC_LOADER_PROCESS THEN
6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||

Line 6257: BSC_UPDATE_LOG.OUTPUT);

6253: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||
6261: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY'), C_PERIODICITY_W)||

Line 6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

6254: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||
6261: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY'), C_PERIODICITY_W)||
6262: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIOD'), C_PERIOD_W),

Line 6259: BSC_UPDATE_LOG.OUTPUT);

6255: BSC_UPDATE_LOG.OUTPUT);
6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||
6261: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY'), C_PERIODICITY_W)||
6262: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIOD'), C_PERIOD_W),
6263: BSC_UPDATE_LOG.OUTPUT);

Line 6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||

6256: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'TABLE_UPDATE_PERIOD'),
6257: BSC_UPDATE_LOG.OUTPUT);
6258: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||
6261: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY'), C_PERIODICITY_W)||
6262: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIOD'), C_PERIOD_W),
6263: BSC_UPDATE_LOG.OUTPUT);
6264:

Line 6263: BSC_UPDATE_LOG.OUTPUT);

6259: BSC_UPDATE_LOG.OUTPUT);
6260: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'INPUT_TABLE_NAME'), C_TABLE_NAME_W)||
6261: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY'), C_PERIODICITY_W)||
6262: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'PERIOD'), C_PERIOD_W),
6263: BSC_UPDATE_LOG.OUTPUT);
6264:
6265: --OPEN c_tables FOR c_tables_sql USING g_process_id;
6266: OPEN c_tables(g_process_id);
6267: FETCH c_tables INTO h_input_table_name, h_periodicity_id, h_periodicity_name, h_current_period, h_current_subperiod;

Line 6278: BSC_UPDATE_LOG.Write_Line_Log(h_line, BSC_UPDATE_LOG.OUTPUT);

6274: IF h_periodicity_type = 11 OR h_periodicity_type = 12 THEN
6275: h_line := h_line||', '||TO_CHAR(h_current_subperiod);
6276: END IF;
6277:
6278: BSC_UPDATE_LOG.Write_Line_Log(h_line, BSC_UPDATE_LOG.OUTPUT);
6279:
6280: FETCH c_tables INTO h_input_table_name, h_periodicity_id, h_periodicity_name, h_current_period, h_current_subperiod;
6281: END LOOP;
6282: CLOSE c_tables;

Line 6285: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

6281: END LOOP;
6282: CLOSE c_tables;
6283: END IF;
6284:
6285: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
6286:
6287: RETURN TRUE;
6288:
6289: EXCEPTION

Line 6364: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

6360: EXIT WHEN h_cursor%NOTFOUND;
6361:
6362: IF h_i = 0 THEN
6363: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT');
6364: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
6365: h_i := 1;
6366: END IF;
6367: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);
6368: g_warning := TRUE;

Line 6367: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);

6363: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT');
6364: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
6365: h_i := 1;
6366: END IF;
6367: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);
6368: g_warning := TRUE;
6369: END LOOP;
6370: CLOSE h_cursor;
6371: ELSE

Line 6392: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

6388: EXIT WHEN h_cursor%NOTFOUND;
6389:
6390: IF h_i = 0 THEN
6391: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT');
6392: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
6393: h_i := 1;
6394: END IF;
6395: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);
6396: g_warning := TRUE;

Line 6395: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);

6391: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_CANNOT_LOAD_OBJS_IN_PROT');
6392: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
6393: h_i := 1;
6394: END IF;
6395: BSC_UPDATE_LOG.Write_Line_Log(h_kpi||' '||h_name, BSC_UPDATE_LOG.OUTPUT);
6396: g_warning := TRUE;
6397: END LOOP;
6398: CLOSE h_cursor;
6399: END IF;