DBA Data[Home] [Help]

APPS.PJI_PA_DEL_MAIN dependencies on DBMS_STANDARD

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

53:
54: /*Check for minimum imput parameters */
55: if (p_operating_unit is null and p_from_project is null and p_to_project is null) then
56: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
57: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
58: end if;
59:
60: /* User should not be able to run for entire operating unit without specifying some
61: project range */

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

60: /* User should not be able to run for entire operating unit without specifying some
61: project range */
62: if (p_operating_unit is not null and p_from_project is null and p_to_project is null) then
63: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PARAMETER');
64: dbms_standard.raise_application_error(-20090, FND_MESSAGE.GET);
65: end if;
66:
67: if p_from_project > p_to_project then
68: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');

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

65: end if;
66:
67: if p_from_project > p_to_project then
68: FND_MESSAGE.SET_NAME('PJI', 'PJI_INVALID_RANGE');
69: dbms_standard.raise_application_error(-20091, FND_MESSAGE.GET);
70: end if;
71:
72: IF p_from_project is not null or p_to_project is not null then
73: select min(segment1) ,max(segment1)