APPS.PJI_FM_SUM_MAIN dependencies on DBMS_STANDARD

Line 56: dbms_standard.raise_application_error(-20044, l_no_setup_error);

52: FND_PROFILE.VALUE('BIS_ENTERPRISE_CALENDAR') is null or
53: FND_PROFILE.VALUE('BIS_PERIOD_TYPE') is null) then
54:
55: rollback;
56: dbms_standard.raise_application_error(-20044, l_no_setup_error);
57:
58: end if;
59:
60: l_settings_proj_perf_flag := nvl(l_settings_proj_perf_flag, 'N');

Line 92: dbms_standard.raise_application_error(-20040, l_setup_error);

88: (l_settings_profit_flag = 'N' and l_params_profit_flag = 'Y') or
89: (l_settings_util_flag = 'N' and l_params_util_flag = 'Y')) then
90: PJI_UTILS.WRITE2LOG('Error: ' || l_setup_error);
91: commit;
92: dbms_standard.raise_application_error(-20040, l_setup_error);
93: end if;
94:
95: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process, 'TRANSITION', 'N');
96: l_transition_flag := 'N';

Line 245: dbms_standard.raise_application_error(-20010, l_sum_fm_running);

241:
242: if (l_count > 0) then
243: pji_utils.write2log('Error: FM summarization is already running.');
244: commit;
245: dbms_standard.raise_application_error(-20010, l_sum_fm_running);
246: end if;
247:
248: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process,
249: 'PROCESS_RUNNING',

Line 303: dbms_standard.raise_application_error(-20092, l_invalid_parameter);

299: begin
300:
301: /* bug#4109940 Changes starts here */
302: IF p_extract_commitments = 'Y' and (p_cmt_from_project > p_cmt_to_project) then
303: dbms_standard.raise_application_error(-20092, l_invalid_parameter);
304: END IF;
305: IF p_from_project > p_to_project then
306: dbms_standard.raise_application_error(-20092, l_invalid_parameter);
307: END IF;

Line 306: dbms_standard.raise_application_error(-20092, l_invalid_parameter);

302: IF p_extract_commitments = 'Y' and (p_cmt_from_project > p_cmt_to_project) then
303: dbms_standard.raise_application_error(-20092, l_invalid_parameter);
304: END IF;
305: IF p_from_project > p_to_project then
306: dbms_standard.raise_application_error(-20092, l_invalid_parameter);
307: END IF;
308: IF p_from_project is not null
309: or p_to_project is not null then
310: select min(segment1) ,max(segment1)

Line 637: dbms_standard.raise_application_error(-20041, l_no_work);

633:
634: if (l_count = 0) then
635:
636: rollback;
637: dbms_standard.raise_application_error(-20041, l_no_work);
638:
639: end if;
640: -- Bug#5099574 ends
641:

Line 1474: dbms_standard.raise_application_error(-20000, fnd_message.get);

1470: end loop;
1471:
1472: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'A') then
1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1478: end if;

Line 1477: dbms_standard.raise_application_error(-20000, fnd_message.get);

1473: fnd_message.set_name('PJI', 'PJI_SUM_ABORT');
1474: dbms_standard.raise_application_error(-20000, fnd_message.get);
1475: elsif (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(g_process, 'PROCESS_RUNNING') = 'F') then
1476: fnd_message.set_name('PJI', 'PJI_SUM_FAIL');
1477: dbms_standard.raise_application_error(-20000, fnd_message.get);
1478: end if;
1479:
1480: DANGLING_REPORT;
1481:

Line 1616: dbms_standard.raise_application_error(-20010, l_sum_running);

1612: g_incr_disp_name
1613: ))) then
1614: pji_utils.write2log('Error: Summarization is already running.');
1615: commit;
1616: dbms_standard.raise_application_error(-20010, l_sum_running);
1617: end if;
1618:
1619: commit;
1620: execute immediate 'alter session enable parallel query';