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.GHR_PDC_BUS dependencies on HR_UTILITY

Line 28: hr_utility.set_location('Entering:'|| l_proc,10);

24: BEGIN
25:
26: --
27:
28: hr_utility.set_location('Entering:'|| l_proc,10);
29:
30: --
31: -- Only proceed with the validation if the row exists for
32: -- the current record in the HR schema.

Line 40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

36: (p_pd_classification_id => p_rec.pd_classification_id,
37: p_object_version_number => p_rec.object_version_number)
38: THEN
39:
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE',l_proc);
42: hr_utility.set_message_token('STEP','20');
43: END IF;
44:

Line 41: hr_utility.set_message_token('PROCEDURE',l_proc);

37: p_object_version_number => p_rec.object_version_number)
38: THEN
39:
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE',l_proc);
42: hr_utility.set_message_token('STEP','20');
43: END IF;
44:
45: --

Line 42: hr_utility.set_message_token('STEP','20');

38: THEN
39:
40: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.set_message_token('PROCEDURE',l_proc);
42: hr_utility.set_message_token('STEP','20');
43: END IF;
44:
45: --
46: hr_utility.set_location (l_proc, 30);

Line 46: hr_utility.set_location (l_proc, 30);

42: hr_utility.set_message_token('STEP','20');
43: END IF;
44:
45: --
46: hr_utility.set_location (l_proc, 30);
47: --
48:
49: IF NVL(p_rec.position_description_id, hr_api.g_number)
50: <> NVL(ghr_pdc_shd.g_old_rec.position_description_id, hr_api.g_number)

Line 111: hr_utility.set_location('Leaving :' || l_proc, 40);

107:
108: --
109:
110: --
111: hr_utility.set_location('Leaving :' || l_proc, 40);
112:
113: EXCEPTION
114:
115: WHEN l_error THEN

Line 146: hr_utility.set_location('Entering: '|| l_proc, 10);

142:
143:
144: BEGIN
145:
146: hr_utility.set_location('Entering: '|| l_proc, 10);
147:
148: -- Check Mandatory Parameters are set
149:
150: hr_api.mandatory_arg_error

Line 176: hr_utility.set_location(l_proc,20);

172: OR
173: NOT l_api_updating THEN
174:
175: --
176: hr_utility.set_location(l_proc,20);
177: --
178: -- If grade level is not null then
179: -- Check if the grade level value exists in fnd_lookups
180: -- Where the look up type is 'GHR_US_GRADE_OR_LEVEL'

Line 195: hr_utility.set_message(8301,'GHR_INVALID_GRADE_OR_LEVEL');

191: -- Error: Invalid Subject to IA Action
192:
193: -- New Message
194:
195: hr_utility.set_message(8301,'GHR_INVALID_GRADE_OR_LEVEL');
196: hr_utility.raise_error;
197: END IF;
198: hr_utility.set_location(l_proc,30);
199:

Line 196: hr_utility.raise_error;

192:
193: -- New Message
194:
195: hr_utility.set_message(8301,'GHR_INVALID_GRADE_OR_LEVEL');
196: hr_utility.raise_error;
197: END IF;
198: hr_utility.set_location(l_proc,30);
199:
200: END IF;

Line 198: hr_utility.set_location(l_proc,30);

194:
195: hr_utility.set_message(8301,'GHR_INVALID_GRADE_OR_LEVEL');
196: hr_utility.raise_error;
197: END IF;
198: hr_utility.set_location(l_proc,30);
199:
200: END IF;
201:
202: END IF;

Line 204: hr_utility.set_location('Leaving: '|| l_proc, 40);

200: END IF;
201:
202: END IF;
203:
204: hr_utility.set_location('Leaving: '|| l_proc, 40);
205:
206: END chk_grade_level;
207:
208: --

Line 234: hr_utility.set_location('Entering: '|| l_proc, 10);

230:
231:
232: BEGIN
233:
234: hr_utility.set_location('Entering: '|| l_proc, 10);
235:
236: -- Check Mandatory Parameters are set
237:
238: hr_api.mandatory_arg_error

Line 264: hr_utility.set_location(l_proc,20);

260: OR
261: NOT l_api_updating THEN
262:
263: --
264: hr_utility.set_location(l_proc,20);
265: --
266: -- If pay plan is not null then
267: -- Check if the pay plan is in GHR_PAY_PLANS
268: -- This is an extra check apart from the foreign key on the table.

Line 277: hr_utility.set_message(8301,'GHR_INVALID_PAY_PLAN');

273: OPEN c_pay_plan;
274: FETCH c_pay_plan INTO l_pay_plan;
275: IF c_pay_plan%NOTFOUND THEN
276:
277: hr_utility.set_message(8301,'GHR_INVALID_PAY_PLAN');
278: hr_utility.raise_error;
279: END IF;
280: CLOSE c_pay_plan;
281:

Line 278: hr_utility.raise_error;

274: FETCH c_pay_plan INTO l_pay_plan;
275: IF c_pay_plan%NOTFOUND THEN
276:
277: hr_utility.set_message(8301,'GHR_INVALID_PAY_PLAN');
278: hr_utility.raise_error;
279: END IF;
280: CLOSE c_pay_plan;
281:
282: hr_utility.set_location(l_proc,30);

Line 282: hr_utility.set_location(l_proc,30);

278: hr_utility.raise_error;
279: END IF;
280: CLOSE c_pay_plan;
281:
282: hr_utility.set_location(l_proc,30);
283:
284: END IF;
285:
286: END IF;

Line 288: hr_utility.set_location('Leaving: '|| l_proc, 40);

284: END IF;
285:
286: END IF;
287:
288: hr_utility.set_location('Leaving: '|| l_proc, 40);
289:
290: END chk_pay_plan;
291:
292: --

Line 313: hr_utility.set_location('Entering: '|| l_proc, 10);

309: BEGIN
310:
311:
312:
313: hr_utility.set_location('Entering: '|| l_proc, 10);
314:
315: -- Check Mandatory Parameters are set
316:
317: hr_api.mandatory_arg_error

Line 343: hr_utility.set_location(l_proc,20);

339: OR
340: NOT l_api_updating THEN
341:
342: --
343: hr_utility.set_location(l_proc,20);
344: --
345: -- If occupational code is not null then
346: -- Check if the occupational code value exists in fnd_lookups
347: -- Where the look up type is 'GHR_US_OCC_SERIES'

Line 360: hr_utility.set_message(8301,'GHR_OCCUPATIONAL_CODE_INVALID');

356: ) THEN
357:
358: -- Error: Invalid Occupational Code
359:
360: hr_utility.set_message(8301,'GHR_OCCUPATIONAL_CODE_INVALID');
361: hr_utility.raise_error;
362: END IF;
363: hr_utility.set_location(l_proc,30);
364:

Line 361: hr_utility.raise_error;

357:
358: -- Error: Invalid Occupational Code
359:
360: hr_utility.set_message(8301,'GHR_OCCUPATIONAL_CODE_INVALID');
361: hr_utility.raise_error;
362: END IF;
363: hr_utility.set_location(l_proc,30);
364:
365: END IF;

Line 363: hr_utility.set_location(l_proc,30);

359:
360: hr_utility.set_message(8301,'GHR_OCCUPATIONAL_CODE_INVALID');
361: hr_utility.raise_error;
362: END IF;
363: hr_utility.set_location(l_proc,30);
364:
365: END IF;
366:
367: END IF;

Line 369: hr_utility.set_location('Leaving: '|| l_proc, 40);

365: END IF;
366:
367: END IF;
368:
369: hr_utility.set_location('Leaving: '|| l_proc, 40);
370:
371:
372: END CHK_OCCUPATIONAL_CODE;
373:

Line 390: hr_utility.set_location('Entering: '|| l_proc, 10);

386:
387: BEGIN
388:
389:
390: hr_utility.set_location('Entering: '|| l_proc, 10);
391:
392: -- Check Mandatory Parameters are set
393:
394: hr_api.mandatory_arg_error

Line 422: hr_utility.set_location(l_proc,20);

418: OR
419: NOT l_api_updating THEN
420:
421:
422: hr_utility.set_location(l_proc,20);
423: --
424: -- If class_grade_by is not null then
425: -- Check if the grade level value exists in fnd_lookups
426: -- Where the look up type is 'GHR_CLASS_GRADE_BY'

Line 439: hr_utility.set_message(8301,'GHR_CLASS_GRADE_BY_INVALID');

435: p_lookup_code => p_class_grade_by
436: ) THEN
437:
438:
439: hr_utility.set_message(8301,'GHR_CLASS_GRADE_BY_INVALID');
440: hr_utility.raise_error;
441:
442: END IF;
443: hr_utility.set_location(l_proc,30);

Line 440: hr_utility.raise_error;

436: ) THEN
437:
438:
439: hr_utility.set_message(8301,'GHR_CLASS_GRADE_BY_INVALID');
440: hr_utility.raise_error;
441:
442: END IF;
443: hr_utility.set_location(l_proc,30);
444:

Line 443: hr_utility.set_location(l_proc,30);

439: hr_utility.set_message(8301,'GHR_CLASS_GRADE_BY_INVALID');
440: hr_utility.raise_error;
441:
442: END IF;
443: hr_utility.set_location(l_proc,30);
444:
445: END IF;
446:
447: END IF;

Line 449: hr_utility.set_location('Leaving: '|| l_proc, 40);

445: END IF;
446:
447: END IF;
448:
449: hr_utility.set_location('Leaving: '|| l_proc, 40);
450:
451:
452: END CHK_CLASS_GRADE_BY;
453:

Line 466: hr_utility.set_location('Entering:'||l_proc, 5);

462: --
463: Begin
464:
465:
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Set up the CLIENT_INFO
469: --
470: ghr_utility.set_client_info;

Line 470: ghr_utility.set_client_info;

466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Set up the CLIENT_INFO
469: --
470: ghr_utility.set_client_info;
471: --
472: -- Call all supporting business operations
473: --
474: --

Line 506: hr_utility.set_location(' Leaving:'||l_proc, 10);

502: p_effective_date => l_effective_date,
503: p_object_version_number => p_rec.object_version_number);
504:
505:
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: End insert_validate;
508: --
509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< update_validate >----------------------------|

Line 523: hr_utility.set_location('Entering:'||l_proc, 5);

519: select sysdate
520: into l_effective_date
521: from dual;
522:
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- Set up the CLIENT_INFO
526: --
527: ghr_utility.set_client_info;

Line 527: ghr_utility.set_client_info;

523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- Set up the CLIENT_INFO
526: --
527: ghr_utility.set_client_info;
528: --
529: -- Call all supporting business operations
530: --
531: --

Line 558: hr_utility.set_location(' Leaving:'||l_proc, 10);

554: p_grade_level => p_rec.grade_level,
555: p_effective_date => l_effective_date,
556: p_object_version_number => p_rec.object_version_number);
557:
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End update_validate;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< delete_validate >----------------------------|

Line 569: hr_utility.set_location('Entering:'||l_proc, 5);

565: --
566: l_proc varchar2(72) := g_package||'delete_validate';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 573: hr_utility.set_location(' Leaving:'||l_proc, 10);

569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: End delete_validate;
575: --
576: end ghr_pdc_bus;