eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJP_SUM_MAIN dependencies on PA_DEBUG

Line 190: pa_debug.log_message('Current Program is submitting failed related Concurrent request with the request no: '||p_request_id, 1);

186: argument7 => NVL(to_char(l_e_plan_type_id),'') , -- p_plan_type_id
187: argument8 => NVL(to_char(l_e_rbs_header_id),''), -- p_rbs_header_id
188: argument9 => l_e_transaction_type, -- p_transaction_type_id
189: argument10 => l_e_plan_versions);
190: pa_debug.log_message('Current Program is submitting failed related Concurrent request with the request no: '||p_request_id, 1);
191: p_prog_name := l_e_program;
192: else
193: p_request_id := -1;
194: p_prog_name := NULL;

Line 3651: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);

3647: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP
3648:
3649: for i in 1..l_count loop
3650: if request_id_table(i) <> -1 then
3651: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3652: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3653:
3654: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3655: request_id_table(i),

Line 4365: pa_debug.set_process('PLSQL'); /* start 4893117 */

4361: execute immediate 'alter session enable parallel dml';
4362:
4363: g_retcode := 0;
4364:
4365: pa_debug.set_process('PLSQL'); /* start 4893117 */
4366: IF p_run_mode IN ('I','F') then
4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);

Line 4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

4363: g_retcode := 0;
4364:
4365: pa_debug.set_process('PLSQL'); /* start 4893117 */
4366: IF p_run_mode IN ('I','F') then
4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement

Line 4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);

4364:
4365: pa_debug.set_process('PLSQL'); /* start 4893117 */
4366: IF p_run_mode IN ('I','F') then
4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);

Line 4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);

4365: pa_debug.set_process('PLSQL'); /* start 4893117 */
4366: IF p_run_mode IN ('I','F') then
4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

Line 4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);

4366: IF p_run_mode IN ('I','F') then
4367: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

Line 4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);

4368: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then

Line 4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

4369: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

Line 4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

4370: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);

Line 4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

4371: --12.1.3 enhancement
4372: pa_debug.log_message('Argument => Project Status ['||p_project_status||']',1);
4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

Line 4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

4373: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);

Line 4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);

4374: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);

Line 4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

4375: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);

Line 4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

4376: ELSIF p_run_mode in ('P') then
4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

Line 4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);

4377: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then

Line 4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);

4378: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

Line 4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);

4379: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);

Line 4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

4380: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4381: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4388: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

Line 4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

4382: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4388: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4389: END IF; /* end 4893117 */
4390:

Line 4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);

4383: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4388: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4389: END IF; /* end 4893117 */
4390:
4391: INIT_PROCESS(l_worker_id,

Line 4388: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

4384: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4385: ELSIF p_run_mode in ('R') then
4386: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4387: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4388: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4389: END IF; /* end 4893117 */
4390:
4391: INIT_PROCESS(l_worker_id,
4392: p_run_mode,