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.2 2007/02/06 10:19:48 dthakker 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 214: -- hr_utility.set_location('PA_ORG.PA_OSE_PREDEL_VALIDATION',1);

210: BEGIN
211: -- hr_utility.trace_on(null, 'RMBUG');
212: -- hr_utility.trace('START - pa_ose_predel_validation');
213: --
214: -- hr_utility.set_location('PA_ORG.PA_OSE_PREDEL_VALIDATION',1);
215: --
216: IF (pa_imp.pa_implemented_all) THEN
217: --
218: -- Check if this Element is the starting org specified in

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

220:
221: open check_start_org_exists;
222: fetch check_start_org_exists into dummy1;
223: if check_start_org_exists%found then
224: hr_utility.set_message (275,'PA_ORG_CANT_DELETE_STARTORG'); /* Message_name changed for bug fix 1713199 */
225: hr_utility.raise_error;
226: end if;
227: close check_start_org_exists;
228:

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

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

Line 285: PROCEDURE pa_org_predel_validation (p_org_id number) IS

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

Line 292: cursor pa_org_exists is

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

Line 308: open pa_org_exists;

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

Line 309: fetch pa_org_exists into dummy1;

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

Line 310: if pa_org_exists%found then

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

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

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

Line 314: close pa_org_exists;

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

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

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

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

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

Line 334: END pa_org;

330: close bill_rate_org_exists;
331:
332: End;
333:
334: END pa_org;