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