1577: l_sum_refresh_fail varchar2(255) := 'The process has failed because process ''Update Project Intelligence Data'' has not yet been run.';
1578: l_rm_fm_running varchar2(255) := 'The process has failed because a Partial Refresh process is not complete.';
1579:
1580: begin
1581: pa_debug.set_process('PLSQL'); /* start 4893117*/
1582: IF p_run_mode IN ('I','F') then
1583: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1579:
1580: begin
1581: pa_debug.set_process('PLSQL'); /* start 4893117*/
1582: IF p_run_mode IN ('I','F') then
1583: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1580: begin
1581: pa_debug.set_process('PLSQL'); /* start 4893117*/
1582: IF p_run_mode IN ('I','F') then
1583: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1581: pa_debug.set_process('PLSQL'); /* start 4893117*/
1582: IF p_run_mode IN ('I','F') then
1583: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1583: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1584: pa_debug.log_message('Argument => Extract Commitments Data ['||p_extract_commitments||']', 1);
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1585: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1586: ELSIF p_run_mode in ('P') then
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1587: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1588: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1595: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1589: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1595: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1596: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1597: END IF; /* end 4893117*/
1590: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1595: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1596: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1597: END IF; /* end 4893117*/
1598:
1591: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1595: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1596: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1597: END IF; /* end 4893117*/
1598:
1599: PJI_FM_DEBUG.CONC_REQUEST_HOOK(g_process);
1592: ELSIF p_run_mode in ('R') then
1593: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
1594: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
1595: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
1596: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
1597: END IF; /* end 4893117*/
1598:
1599: PJI_FM_DEBUG.CONC_REQUEST_HOOK(g_process);
1600: