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 HR_UTILITY

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 49: hr_utility.raise_error;

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:
53: --

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 89: hr_utility.raise_error;

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:
93: ELSE

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 124: hr_utility.raise_error;

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:
128: -- Check if structure version being deleted is the structure version

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 164: hr_utility.raise_error;

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
168: -- pass validation.

Line 211: -- hr_utility.trace_on(null, 'RMBUG');

207: AND ind.org_structure_version_id = ose.org_structure_version_id
208: AND ind.start_organization_id = ose.organization_id_child
209: ) ;
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: --

Line 212: -- hr_utility.trace('START - pa_ose_predel_validation');

208: AND ind.start_organization_id = ose.organization_id_child
209: ) ;
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

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 225: hr_utility.raise_error;

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:
229: -- Check if structure element is used by PA for burdening (10.7+):

Line 254: -- hr_utility.trace('before check');

250: );
251: */
252: /* Replacing the above SELECT with the below SELECT statement. */
253: /* Check if the organization being deleted is used in Burdening */
254: -- hr_utility.trace('before check');
255: -- hr_utility.trace('before check p_org_structure_element_id IS ' || p_org_structure_element_id);
256: SELECT 'X'
257: INTO dummy1
258: FROM sys.dual

Line 255: -- hr_utility.trace('before check p_org_structure_element_id IS ' || p_org_structure_element_id);

251: */
252: /* Replacing the above SELECT with the below SELECT statement. */
253: /* Check if the organization being deleted is used in Burdening */
254: -- hr_utility.trace('before check');
255: -- hr_utility.trace('before check p_org_structure_element_id IS ' || p_org_structure_element_id);
256: SELECT 'X'
257: INTO dummy1
258: FROM sys.dual
259: WHERE exists (

Line 268: -- hr_utility.trace('after check exception');

264: AND ose.organization_id_child = icm.organization_id);
265:
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: -- hr_utility.trace('after check exception');
269: NULL;
270: END;
271:
272: -- hr_utility.trace('after check');

Line 272: -- hr_utility.trace('after check');

268: -- hr_utility.trace('after check exception');
269: NULL;
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;

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 275: hr_utility.raise_error;

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
279: -- pass validation.

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 312: hr_utility.raise_error;

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: --
316: open nlr_org_exists;

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 320: hr_utility.raise_error;

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: --
324: open bill_rate_org_exists;

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 328: hr_utility.raise_error;

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:
332: End;