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 3455: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);

3451: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP
3452:
3453: for i in 1..l_count loop
3454: if request_id_table(i) <> -1 then
3455: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3456: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3457:
3458: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3459: request_id_table(i),

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

4120: execute immediate 'alter session enable parallel dml';
4121:
4122: g_retcode := 0;
4123:
4124: pa_debug.set_process('PLSQL'); /* start 4893117 */
4125: IF p_run_mode IN ('I','F') then
4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);

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

4122: g_retcode := 0;
4123:
4124: pa_debug.set_process('PLSQL'); /* start 4893117 */
4125: IF p_run_mode IN ('I','F') then
4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

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

4123:
4124: pa_debug.set_process('PLSQL'); /* start 4893117 */
4125: IF p_run_mode IN ('I','F') then
4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);

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

4124: pa_debug.set_process('PLSQL'); /* start 4893117 */
4125: IF p_run_mode IN ('I','F') then
4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

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

4125: IF p_run_mode IN ('I','F') then
4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then

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

4126: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

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

4127: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);

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

4128: pa_debug.log_message('Argument => Project Organization ['||p_project_organization_id||']', 1);
4129: pa_debug.log_message('Argument => Project Type ['||p_project_type||']', 1);
4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);

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

4130: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);

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

4131: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);

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

4132: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);

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

4133: ELSIF p_run_mode in ('P') then
4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

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

4134: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then

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

4135: pa_debug.log_message('Argument => Operating Unit ['||p_operating_unit||']', 1);
4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);

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

4136: pa_debug.log_message('Argument => From Project Number ['||p_from_project||']', 1);
4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4144: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);

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

4137: pa_debug.log_message('Argument => To Project Number ['||p_to_project||']', 1);
4138: pa_debug.log_message('Argument => Plan Type ['||p_plan_type_id||']', 1);
4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4144: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4145: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);

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

4139: pa_debug.log_message('Argument => Transaction Type ['||p_transaction_type||']', 1);
4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4144: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4145: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4146: END IF; /* end 4893117 */
4147:

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

4140: pa_debug.log_message('Argument => Plan Version ['||p_plan_versions||']', 1);
4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4144: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4145: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4146: END IF; /* end 4893117 */
4147:
4148: INIT_PROCESS(l_worker_id,

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

4141: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4142: ELSIF p_run_mode in ('R') then
4143: pa_debug.log_message('=======Concurrent Program Parameters Start =======', 1);
4144: pa_debug.log_message('Argument => RBS Header Name ['||p_rbs_header_id||']', 1);
4145: pa_debug.log_message('=======Concurrent Program Parameters End =======', 1);
4146: END IF; /* end 4893117 */
4147:
4148: INIT_PROCESS(l_worker_id,
4149: p_run_mode,