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

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

60: l_effective_date date;
61: --
62: begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint if operating in validation only mode
67: --
68: if p_validate then

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

68: if p_validate then
69: savepoint update_person_type_usage;
70: end if;
71: --
72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Process Logic
75: --
76: l_object_version_number := p_object_version_number;

Line 135: -- hr_utility.set_message(801, 'HR_52363_PTU_INV_DT_UPD_MODE');

131: --
132: -- For first release, datetrack update mode must be 'CORRECTION'
133: -- Commented as part of PTU changes
134: -- if ( p_datetrack_mode <> 'CORRECTION') then
135: -- hr_utility.set_message(801, 'HR_52363_PTU_INV_DT_UPD_MODE');
136: -- hr_utility.raise_error;
137: -- end if;
138: --
139: --

Line 136: -- hr_utility.raise_error;

132: -- For first release, datetrack update mode must be 'CORRECTION'
133: -- Commented as part of PTU changes
134: -- if ( p_datetrack_mode <> 'CORRECTION') then
135: -- hr_utility.set_message(801, 'HR_52363_PTU_INV_DT_UPD_MODE');
136: -- hr_utility.raise_error;
137: -- end if;
138: --
139: --
140: per_ptu_upd.upd

Line 237: hr_utility.set_location(l_proc, 60);

233: -- End of API User Hook for the after hook of update_person_type_usage
234: --
235: end;
236: --
237: hr_utility.set_location(l_proc, 60);
238: --
239: -- When in validation only mode raise the Validate_Enabled exception
240: --
241: if p_validate then

Line 251: hr_utility.set_location(' Leaving:'||l_proc, 70);

247: p_object_version_number := l_object_version_number;
248: p_effective_start_date := l_effective_start_date;
249: p_effective_end_date := l_effective_end_date;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 70);
252: --
253: exception
254: --
255: when hr_api.validate_enabled then

Line 266: hr_utility.set_location(' Leaving:'||l_proc, 80);

262: -- Only set output warning arguments
263: -- (Any key or derived arguments must be set to null
264: -- when validation only mode is being used.)
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 80);
267: --
268: end update_person_type_usage;
269: -- ----------------------------------------------------------------------------
270: -- |------------------------< check_person_type >-----------------------------|

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

304: and ppt.system_person_type = p_person_type;
305:
306: begin
307: --
308: hr_utility.set_location('Entering:'|| l_proc, 5);
309: --
310: -- Check that the person type is valid.
311: --
312: open check_person_type;

Line 316: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');

312: open check_person_type;
313: fetch check_person_type into l_temp_type;
314: if check_person_type%notfound then
315: close check_person_type;
316: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
317: hr_utility.raise_error;
318: end if;
319: --
320: close check_person_type;

Line 317: hr_utility.raise_error;

313: fetch check_person_type into l_temp_type;
314: if check_person_type%notfound then
315: close check_person_type;
316: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
317: hr_utility.raise_error;
318: end if;
319: --
320: close check_person_type;
321: --

Line 330: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');

326: p_person_type = 'EX_APL' or
327: p_person_type = 'EMP_APL' or
328: p_person_type = 'EX_EMP_APL' or
329: p_person_type = 'APL_EX_APL') then
330: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
331: hr_utility.raise_error;
332: end if;
333: --
334: --

Line 331: hr_utility.raise_error;

327: p_person_type = 'EMP_APL' or
328: p_person_type = 'EX_EMP_APL' or
329: p_person_type = 'APL_EX_APL') then
330: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
331: hr_utility.raise_error;
332: end if;
333: --
334: --
335: -- Check that the person id is valid.

Line 341: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');

337: open check_person_id;
338: fetch check_person_id into l_temp_id;
339: if check_person_id%notfound then
340: close check_person_id;
341: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');
342: hr_utility.raise_error;
343: end if;
344: --
345: close check_person_id;

Line 342: hr_utility.raise_error;

338: fetch check_person_id into l_temp_id;
339: if check_person_id%notfound then
340: close check_person_id;
341: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');
342: hr_utility.raise_error;
343: end if;
344: --
345: close check_person_id;
346: --

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

347: open current_person_type;
348: fetch current_person_type into l_result;
349: if current_person_type%found then
350: close current_person_type;
351: hr_utility.set_location('Leaving:'|| l_proc, 10);
352: return TRUE;
353: end if;
354: --
355: close current_person_type;

Line 357: hr_utility.set_location('Leaving:'|| l_proc, 20);

353: end if;
354: --
355: close current_person_type;
356: --
357: hr_utility.set_location('Leaving:'|| l_proc, 20);
358: --
359: return FALSE;
360: --
361: end check_person_type;

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

405: l_result varchar2(4);
406: --
407: begin
408: --
409: hr_utility.set_location('Entering:'|| l_proc, 5);
410: --
411: -- Check that the person type is valid.
412: --
413: open check_person_type;

Line 417: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');

413: open check_person_type;
414: fetch check_person_type into l_temp_type;
415: if check_person_type%notfound then
416: close check_person_type;
417: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
418: hr_utility.raise_error;
419: end if;
420: --
421: -- Check that the type passed in isn't an 'EX' type or a combination of

Line 418: hr_utility.raise_error;

414: fetch check_person_type into l_temp_type;
415: if check_person_type%notfound then
416: close check_person_type;
417: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
418: hr_utility.raise_error;
419: end if;
420: --
421: -- Check that the type passed in isn't an 'EX' type or a combination of
422: -- old types

Line 429: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');

425: p_person_type = 'EX_APL' or
426: p_person_type = 'EMP_APL' or
427: p_person_type = 'EX_EMP_APL' or
428: p_person_type = 'APL_EX_APL') then
429: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
430: hr_utility.raise_error;
431: end if;
432: --
433: close check_person_type;

Line 430: hr_utility.raise_error;

426: p_person_type = 'EMP_APL' or
427: p_person_type = 'EX_EMP_APL' or
428: p_person_type = 'APL_EX_APL') then
429: hr_utility.set_message(801, 'HR_52366_PTU_INV_PERSON_TYPE');
430: hr_utility.raise_error;
431: end if;
432: --
433: close check_person_type;
434: --

Line 441: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');

437: open check_person_id;
438: fetch check_person_id into l_temp_id;
439: if check_person_id%notfound then
440: close check_person_id;
441: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');
442: hr_utility.raise_error;
443: end if;
444: --
445: close check_person_id;

Line 442: hr_utility.raise_error;

438: fetch check_person_id into l_temp_id;
439: if check_person_id%notfound then
440: close check_person_id;
441: hr_utility.set_message(801, 'HR_52365_PTU_NO_PERSON_EXISTS');
442: hr_utility.raise_error;
443: end if;
444: --
445: close check_person_id;
446: --

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

450: open check_person_ex_type;
451: fetch check_person_ex_type into l_result;
452: if check_person_ex_type%found then
453: close check_person_ex_type;
454: hr_utility.set_location('Leaving:'|| l_proc, 10);
455: return TRUE;
456: end if;
457:
458: close check_person_ex_type;

Line 459: hr_utility.set_location('Leaving:'|| l_proc, 20);

455: return TRUE;
456: end if;
457:
458: close check_person_ex_type;
459: hr_utility.set_location('Leaving:'|| l_proc, 20);
460: return FALSE;
461: --
462: end check_person_ex_type;
463: --

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

522: where person_type_id = p_person_type_id;
523: --
524: begin
525: --
526: hr_utility.set_location('Entering:'|| l_proc, 10);
527: --
528: -- Issue a savepoint if operating in validation only mode
529: --
530: if p_validate then

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

530: if p_validate then
531: savepoint create_person_type_usage;
532: end if;
533: --
534: hr_utility.set_location(l_proc, 20);
535: --
536: -- Process Logic
537: --
538: --

Line 551: hr_utility.set_location('At: '||l_proc,15);

547: fnd_message.raise_error;
548: end if;
549: close csr_valid_person_type;
550:
551: hr_utility.set_location('At: '||l_proc,15);
552:
553: --
554: -- Must not exist in hr_standard_lookups where lookup_type is
555: -- HR_SYS_PTU

Line 566: hr_utility.set_location('At: '||l_proc,20);

562: fnd_message.set_name('PER', 'HR_52362_PTU_INV_PER_TYPE_ID');
563: fnd_message.raise_error;
564: end if;
565:
566: hr_utility.set_location('At: '||l_proc,20);
567:
568: begin
569: --
570: -- Start of API User Hook for the before hook of create_person_type_usage

Line 663: hr_utility.set_location(l_proc, 60);

659: ,p_effective_end_date => l_effective_end_date);
660:
661: --
662: --
663: hr_utility.set_location(l_proc, 60);
664: begin
665: --
666: -- Start of API User Hook for the after hook of create_person_type_usage
667: --

Line 736: hr_utility.set_location(' Leaving:'||l_proc, 70);

732: p_effective_start_date := l_effective_start_date;
733: p_effective_end_date := l_effective_end_date;
734: p_object_version_number := l_object_version_number;
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --
738: exception
739: --
740: when hr_api.validate_enabled then

Line 754: hr_utility.set_location(' Leaving:'||l_proc, 80);

750: p_person_type_usage_id := null;
751: p_effective_start_date := null;
752: p_effective_end_date := null;
753: p_object_version_number := null;
754: hr_utility.set_location(' Leaving:'||l_proc, 80);
755: --
756: end create_person_type_usage;
757: --
758: -- ----------------------------------------------------------------------------

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

784: ptu.effective_start_date and ptu.effective_end_date);
785:
786: begin
787: --
788: hr_utility.set_location('Entering:'|| l_proc, 10);
789: --
790: -- Issue a savepoint if operating in validation only mode
791: --
792: if p_validate then

Line 796: hr_utility.set_location('At:'||l_proc, 20);

792: if p_validate then
793: savepoint delete_person_type_usage;
794: end if;
795: --
796: hr_utility.set_location('At:'||l_proc, 20);
797: --
798: -- Process Logic
799: --
800: --

Line 811: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

807: --
808: -- The primary key is invalid therefore we must error
809: --
810: CLOSE csr_ptu;
811: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
812: hr_utility.raise_error;
813: END IF;
814: CLOSE csr_ptu;
815:

Line 812: hr_utility.raise_error;

808: -- The primary key is invalid therefore we must error
809: --
810: CLOSE csr_ptu;
811: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
812: hr_utility.raise_error;
813: END IF;
814: CLOSE csr_ptu;
815:
816: --

Line 834: hr_utility.set_location('At: '||l_proc,40);

830: --
831: -- End of PTU Changes
832: --
833: --
834: hr_utility.set_location('At: '||l_proc,40);
835: begin
836: --
837: -- Start of API User Hook for the before hook of delete_person_type_usage
838: --

Line 857: hr_utility.set_location('At: '||l_proc,30);

853: -- End of API User Hook for the before hook of delete_person_type_usage
854: --
855: end;
856:
857: hr_utility.set_location('At: '||l_proc,30);
858:
859: hr_per_type_usage_internal.delete_person_type_usage
860: (p_validate => FALSE
861: ,p_person_type_usage_id => p_person_type_usage_id

Line 871: hr_utility.set_location(l_proc, 60);

867: );
868:
869: --
870: --
871: hr_utility.set_location(l_proc, 60);
872: --
873: begin
874: --
875: -- Start of API User Hook for the after hook of delete_person_type_usage

Line 909: hr_utility.set_location(' Leaving:'||l_proc, 70);

905: p_effective_start_date := l_effective_start_date;
906: p_effective_end_date := l_effective_end_date;
907: p_object_version_number := l_object_version_number;
908: --
909: hr_utility.set_location(' Leaving:'||l_proc, 70);
910: --
911: exception
912: --
913: when hr_api.validate_enabled then