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.PA_ORG dependencies on PA_ORG

Line 1: PACKAGE BODY pa_org AS

1: PACKAGE BODY pa_org AS
2: /* $Header: PAORGB.pls 120.6 2011/01/21 12:24:03 vikarora ship $ */
3: --
4: /*
5: NAME

Line 38: -- hr_utility.set_location('PA_ORG.PA_OS_PREDEL_VALIDATION', 1);

34: OR (p_org_structure_id = pai.exp_org_structure_id)
35: );
36: BEGIN
37: --
38: -- hr_utility.set_location('PA_ORG.PA_OS_PREDEL_VALIDATION', 1);
39: --
40: IF (pa_imp.pa_implemented_all) THEN
41:
42: -- Check if the Org Structure being deleted

Line 48: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');

44: --
45: open check_org_structure_exists;
46: fetch check_org_structure_exists into dummy1;
47: if check_org_structure_exists%found then
48: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');
49: hr_utility.raise_error;
50: end if;
51: close check_org_structure_exists;
52:

Line 88: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');

84: NULL;
85: END;
86:
87: IF ( dummy1 IS NOT NULL ) THEN
88: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');
89: hr_utility.raise_error;
90: END IF;
91:
92:

Line 113: -- hr_utility.set_location('PA_ORG.PA_OSV_PREDEL_VALIDATION', 1);

109: OR (p_org_structure_version_id = pai.exp_org_structure_version_id)
110: );
111: BEGIN
112: --
113: -- hr_utility.set_location('PA_ORG.PA_OSV_PREDEL_VALIDATION', 1);
114: --
115: IF (pa_imp.pa_implemented_all) THEN
116: --
117: -- Check if this Org Struct Version is not in the OSV

Line 123: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');

119: --
120: open check_org_structure_ver_exists;
121: fetch check_org_structure_ver_exists into dummy1;
122: if check_org_structure_ver_exists%found then
123: hr_utility.set_message (275,'PA_ORG_CANT_DEL_HIER');
124: hr_utility.raise_error;
125: end if;
126: close check_org_structure_ver_exists;
127:

Line 163: hr_utility.set_message (275,'PA_ORG_CANT_DEL_OSV');

159: NULL;
160: END;
161:
162: IF ( dummy1 IS NOT NULL ) THEN
163: hr_utility.set_message (275,'PA_ORG_CANT_DEL_OSV');
164: hr_utility.raise_error;
165: END IF;
166:
167: ELSE

Line 205: -- hr_utility.set_location('PA_ORG.PA_OSE_PREDEL_VALIDATION',1);

201: BEGIN
202: -- hr_utility.trace_on(null, 'RMBUG');
203: -- hr_utility.trace('START - pa_ose_predel_validation');
204: --
205: -- hr_utility.set_location('PA_ORG.PA_OSE_PREDEL_VALIDATION',1);
206: --
207: IF (pa_imp.pa_implemented_all) THEN
208: --
209: -- Check if this Element is the starting org specified in

Line 215: hr_utility.set_message (275,'PA_ORG_CANT_DELETE_STARTORG'); /* Message_name changed for bug fix 1713199 */

211:
212: open check_start_org_exists;
213: fetch check_start_org_exists into dummy1;
214: if check_start_org_exists%found then
215: hr_utility.set_message (275,'PA_ORG_CANT_DELETE_STARTORG'); /* Message_name changed for bug fix 1713199 */
216: hr_utility.raise_error;
217: end if;
218: close check_start_org_exists;
219:

Line 271: hr_utility.set_message (275,'PA_ORG_DEL_LINK');

267: END;
268:
269: -- hr_utility.trace('after check');
270: IF ( dummy1 IS NOT NULL ) THEN
271: hr_utility.set_message (275,'PA_ORG_DEL_LINK');
272: hr_utility.raise_error;
273: END IF;
274:
275: ELSE

Line 282: PROCEDURE pa_org_predel_validation (p_org_id number) IS

278: END IF;
279: --
280: END;
281:
282: PROCEDURE pa_org_predel_validation (p_org_id number) IS
283: -- This procedure will check if the org being deleted
284: -- has been specified for PA use.
285: -- This procedure will be called from the Define Org form.
286:

Line 289: cursor pa_org_exists is

285: -- This procedure will be called from the Define Org form.
286:
287: dummy1 VARCHAR2(4); -- into arg for main SELECT
288: --
289: cursor pa_org_exists is
290: select 'X'
291: from pa_all_organizations
292: where organization_id = p_org_id;
293:

Line 305: open pa_org_exists;

301: from pa_std_bill_rate_schedules
302: where organization_id = p_org_id;
303:
304: Begin
305: open pa_org_exists;
306: fetch pa_org_exists into dummy1;
307: if pa_org_exists%found then
308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');
309: hr_utility.raise_error;

Line 306: fetch pa_org_exists into dummy1;

302: where organization_id = p_org_id;
303:
304: Begin
305: open pa_org_exists;
306: fetch pa_org_exists into dummy1;
307: if pa_org_exists%found then
308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');
309: hr_utility.raise_error;
310: end if;

Line 307: if pa_org_exists%found then

303:
304: Begin
305: open pa_org_exists;
306: fetch pa_org_exists into dummy1;
307: if pa_org_exists%found then
308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');
309: hr_utility.raise_error;
310: end if;
311: close pa_org_exists;

Line 308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');

304: Begin
305: open pa_org_exists;
306: fetch pa_org_exists into dummy1;
307: if pa_org_exists%found then
308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');
309: hr_utility.raise_error;
310: end if;
311: close pa_org_exists;
312: --

Line 311: close pa_org_exists;

307: if pa_org_exists%found then
308: hr_utility.set_message (275,'PA_ORG_CANT_DEL_PAORG');
309: hr_utility.raise_error;
310: end if;
311: close pa_org_exists;
312: --
313: open nlr_org_exists;
314: fetch nlr_org_exists into dummy1;
315: if nlr_org_exists%found then

Line 316: hr_utility.set_message (275,'PA_ORG_CANT_DEL_NLRORG');

312: --
313: open nlr_org_exists;
314: fetch nlr_org_exists into dummy1;
315: if nlr_org_exists%found then
316: hr_utility.set_message (275,'PA_ORG_CANT_DEL_NLRORG');
317: hr_utility.raise_error;
318: end if;
319: close nlr_org_exists;
320: --

Line 324: hr_utility.set_message (275,'PA_ORG_CANT_DEL_BRORG');

320: --
321: open bill_rate_org_exists;
322: fetch bill_rate_org_exists into dummy1;
323: if bill_rate_org_exists%found then
324: hr_utility.set_message (275,'PA_ORG_CANT_DEL_BRORG');
325: hr_utility.raise_error;
326: end if;
327: close bill_rate_org_exists;
328:

Line 331: END pa_org;

327: close bill_rate_org_exists;
328:
329: End;
330:
331: END pa_org;