APPS.PJI_PJP_SUM_MAIN dependencies on DBMS_STANDARD

Line 2784: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);

2780:
2781:
2782: if (PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') = 'P') then
2783: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_FPM_UPG_RUN');
2784: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2785: end if;
2786: /*Check for from project and to project based on the run , idea is to recreate the same check which was done thru mandatory parameter*/
2787: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2788: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then

Line 2790: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);

2786: /*Check for from project and to project based on the run , idea is to recreate the same check which was done thru mandatory parameter*/
2787: if (p_operating_unit is null and p_project_type is null and p_project_organization_id is null and
2788: p_from_project is null and p_to_project is null and p_run_mode <> 'R') then
2789: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
2790: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
2791: end if;
2792:
2793: if p_from_project > p_to_project then
2794: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');

Line 2795: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);

2791: end if;
2792:
2793: if p_from_project > p_to_project then
2794: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
2795: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
2796: end if;
2797:
2798: IF p_from_project is not null
2799: or p_to_project is not null then

Line 2832: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);

2828: PJI_SYSTEM_SETTINGS;
2829:
2830: if (l_settings_proj_perf_flag = 'N') then
2831: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_NOT_ENABLED');
2832: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2833: end if;
2834:
2835: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
2836:

Line 2848: dbms_standard.raise_application_error(-20010, 'Invalid run type');

2844: elsif (p_run_mode = 'R') then
2845: l_extraction_type := 'RBS';
2846: else
2847: commit;
2848: dbms_standard.raise_application_error(-20010, 'Invalid run type');
2849: end if;
2850:
2851: p_worker_id := 0;
2852: l_type := 0;

Line 2957: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);

2953: if (p_worker_id = 0) then
2954: rollback;
2955: OUTPUT_FAILED_RUNS;
2956: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2957: dbms_standard.raise_application_error(-20030, FND_MESSAGE.GET);
2958: end if;
2959:
2960: l_process := g_process || p_worker_id;
2961:

Line 3293: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);

3289: p_from_project,
3290: p_to_project,
3291: l_extraction_type);
3292: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_WORK');
3293: dbms_standard.raise_application_error(-20041,FND_MESSAGE.GET);
3294:
3295: end if;
3296:
3297: elsif (l_extraction_type = 'RBS') then

Line 3466: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);

3462: -- We may want to add, to the error message, the request
3463: -- ID that is causing the program to fail
3464: OUTPUT_FAILED_RUNS;
3465: FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3466: dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3467:
3468: end if;
3469: end if;
3470: end loop;

Line 3473: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);

3469: end if;
3470: end loop;
3471: -- IF l_rbs_exists ='Y' THEN
3472: -- FND_MESSAGE.SET_NAME('PJI', 'PJI_OVERLAPPING_WORK');
3473: -- dbms_standard.raise_application_error(-20040, FND_MESSAGE.GET);
3474: -- END IF;
3475: INIT_PROCESS(p_worker_id,
3476: p_run_mode,
3477: p_operating_unit,