APPS.PJI_FM_SUM_MAIN dependencies on DBMS_STANDARD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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