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

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_req_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: per_req_bus.g_requisition_id := p_requisition_id;
142: per_req_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

179: --
180: l_proc varchar2(72) := g_package || 'chk_df';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.requisition_id is not null) and (
186: nvl(per_req_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
187: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

278: ,p_attribute20_value => p_rec.attribute20
279: );
280: end if;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc,20);
283: end chk_df;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |-----------------------< chk_non_updateable_args >------------------------|

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

317: l_error EXCEPTION;
318: l_argument varchar2(30);
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc,10);
322: --
323: -- Only proceed with the validation if a row exists for the current
324: -- record in the HR Schema.
325: --

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

353: ,p_argument => l_argument);
354: WHEN OTHERS THEN
355: RAISE;
356:
357: hr_utility.set_location(' Leaving:'||l_proc,20);
358: End chk_non_updateable_args;
359: --
360: -- ----------------------------------------------------------------------------
361: -- |-----------------------< chk_name >---------------------------------------|

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

398: from per_requisitions
399: where name = p_name;
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc,10);
403: --
404: -- Check to ensure that the Requisition Name is not null.
405: --
406: hr_utility.set_location(l_proc, 20);

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

402: hr_utility.set_location('Entering:'||l_proc,10);
403: --
404: -- Check to ensure that the Requisition Name is not null.
405: --
406: hr_utility.set_location(l_proc, 20);
407: if p_name is null then
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'NAME'

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

415: -- Check that the requisition name does not exist already.
416: --
417: open csr_name;
418: fetch csr_name into l_name;
419: hr_utility.set_location(l_proc, 30);
420: if csr_name%found then
421: close csr_name;
422: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');
423: fnd_message.raise_error;

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

422: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');
423: fnd_message.raise_error;
424: end if;
425: close csr_name;
426: hr_utility.set_location(' Leaving:'||l_proc,40);
427: exception
428: when app_exception.application_exception then
429: if hr_multi_message.exception_add
430: (p_associated_column1 => 'PER_REQUISITIONS.NAME'

Line 432: hr_utility.set_location(' Leaving:'|| l_proc, 50);

428: when app_exception.application_exception then
429: if hr_multi_message.exception_add
430: (p_associated_column1 => 'PER_REQUISITIONS.NAME'
431: ) then
432: hr_utility.set_location(' Leaving:'|| l_proc, 50);
433: raise;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 436: hr_utility.set_location(' Leaving:'||l_proc,60);

432: hr_utility.set_location(' Leaving:'|| l_proc, 50);
433: raise;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc,60);
437: end chk_name;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |-----------------------< chk_requisition_dates >--------------------------|

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

472: l_proc varchar2(72) := g_package || 'chk_requisition_dates';
473: l_api_updating boolean;
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc,10);
477: --
478: l_api_updating := per_req_shd.api_updating(p_requisition_id,p_object_version_number);
479: --
480: -- Check to see if date_from or date_to values have changed.

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

478: l_api_updating := per_req_shd.api_updating(p_requisition_id,p_object_version_number);
479: --
480: -- Check to see if date_from or date_to values have changed.
481: --
482: hr_utility.set_location(l_proc, 20);
483: if ((l_api_updating
484: and ((nvl(per_req_shd.g_old_rec.date_from,hr_api.g_date) <> p_date_from)
485: or (nvl(per_req_shd.g_old_rec.date_to,hr_api.g_date) <> p_date_to)))
486: or (NOT l_api_updating)) then

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

486: or (NOT l_api_updating)) then
487: --
488: -- Check that the start date has been entered.
489: --
490: hr_utility.set_location(l_proc, 30);
491: if(p_date_from is NULL) then
492: fnd_message.set_name('PER','PER_289466_REQ_DATE_FROM_MAND');
493: hr_multi_message.add
494: (p_associated_column1 => 'PER_REQUISITIONS.DATE_FROM'

Line 501: hr_utility.set_location(l_proc, 40);

497: end if;
498: --
499: -- Check that the start date is before the end date.
500: --
501: hr_utility.set_location(l_proc, 40);
502: if(p_date_from > nvl(p_date_to,hr_api.g_eot)) then
503: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
504: hr_multi_message.add
505: (p_associated_column1 => 'PER_REQUISITIONS.DATE_FROM'

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

507: );
508: end if;
509: end if;
510: --
511: hr_utility.set_location(' Leaving:'||l_proc,20);
512: --
513: end chk_requisition_dates;
514: --
515: -- ----------------------------------------------------------------------------

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

560: where person_id = p_person_id
561: and p_date_from between effective_start_date and effective_end_date;
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc,10);
565: --
566: l_api_updating := per_req_shd.api_updating(p_requisition_id
567: ,p_object_version_number);
568: --

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

567: ,p_object_version_number);
568: --
569: -- Check to see if person_id value has changed.
570: --
571: hr_utility.set_location(l_proc, 20);
572: if ((l_api_updating
573: and (nvl(per_req_shd.g_old_rec.person_id,hr_api.g_number) <> p_person_id))
574: or (NOT l_api_updating)) then
575: --

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

579: -- and if the person is valid at this effective date
580: --
581: open csr_person_id;
582: fetch csr_person_id into l_person_id;
583: hr_utility.set_location(l_proc, 30);
584: if csr_person_id%notfound then
585: close csr_person_id;
586: fnd_message.set_name('PER','PER_289467_REQ_INV_PERSON_ID');
587: fnd_message.raise_error;

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

588: end if;
589: close csr_person_id;
590: end if;
591: end if;
592: hr_utility.set_location(' Leaving:'||l_proc,40);
593: exception
594: when app_exception.application_exception then
595: if hr_multi_message.exception_add
596: (p_associated_column1 => 'PER_REQUISITIONS.PERSON_ID'

Line 598: hr_utility.set_location(' Leaving:'|| l_proc, 60);

594: when app_exception.application_exception then
595: if hr_multi_message.exception_add
596: (p_associated_column1 => 'PER_REQUISITIONS.PERSON_ID'
597: ) then
598: hr_utility.set_location(' Leaving:'|| l_proc, 60);
599: raise;
600: end if;
601: hr_utility.set_location(' Leaving:'|| l_proc, 70);
602: --

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

597: ) then
598: hr_utility.set_location(' Leaving:'|| l_proc, 60);
599: raise;
600: end if;
601: hr_utility.set_location(' Leaving:'|| l_proc, 70);
602: --
603: end chk_person_id;
604: --
605: -- ----------------------------------------------------------------------------

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

611: --
612: l_proc varchar2(72) := g_package||'insert_validate';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc,10);
616: --
617: -- Call all supporting business operations
618: --
619: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

616: --
617: -- Call all supporting business operations
618: --
619: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
620: hr_utility.set_location(l_proc, 20);
621: --
622: per_req_bus.chk_name
623: (p_name => p_rec.name
624: );

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

621: --
622: per_req_bus.chk_name
623: (p_name => p_rec.name
624: );
625: hr_utility.set_location(l_proc, 30);
626: --
627: per_req_bus.chk_requisition_dates
628: (p_date_from => p_rec.date_from
629: ,p_date_to => p_rec.date_to

Line 633: hr_utility.set_location(l_proc, 40);

629: ,p_date_to => p_rec.date_to
630: ,p_requisition_id => p_rec.requisition_id
631: ,p_object_version_number => p_rec.object_version_number
632: );
633: hr_utility.set_location(l_proc, 40);
634: --
635: per_req_bus.chk_person_id
636: (p_person_id => p_rec.person_id
637: ,p_requisition_id => p_rec.requisition_id

Line 642: hr_utility.set_location(l_proc, 50);

638: ,p_object_version_number => p_rec.object_version_number
639: ,p_date_from => p_rec.date_from
640: ,p_date_to => p_rec.date_to
641: );
642: hr_utility.set_location(l_proc, 50);
643: --
644: per_req_bus.chk_df
645: (p_rec => p_rec
646: );

Line 649: hr_utility.set_location(' Leaving:'||l_proc, 60);

645: (p_rec => p_rec
646: );
647: hr_multi_message.end_validation_set();
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 60);
650: End insert_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< update_validate >----------------------------|

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

658: --
659: l_proc varchar2(72) := g_package||'update_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 10);
663: --
664: -- Call all supporting business operations
665: --
666: hr_utility.set_location(l_proc, 20);

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

662: hr_utility.set_location('Entering:'||l_proc, 10);
663: --
664: -- Call all supporting business operations
665: --
666: hr_utility.set_location(l_proc, 20);
667: --
668: chk_non_updateable_args
669: (p_rec => p_rec
670: );

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

668: chk_non_updateable_args
669: (p_rec => p_rec
670: );
671: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
672: hr_utility.set_location(l_proc, 30);
673: --
674: per_req_bus.chk_requisition_dates
675: (p_date_from => p_rec.date_from
676: ,p_date_to => p_rec.date_to

Line 680: hr_utility.set_location(l_proc, 40);

676: ,p_date_to => p_rec.date_to
677: ,p_requisition_id => p_rec.requisition_id
678: ,p_object_version_number => p_rec.object_version_number
679: );
680: hr_utility.set_location(l_proc, 40);
681: --
682: per_req_bus.chk_person_id
683: (p_person_id => p_rec.person_id
684: ,p_requisition_id => p_rec.requisition_id

Line 689: hr_utility.set_location(l_proc, 50);

685: ,p_object_version_number => p_rec.object_version_number
686: ,p_date_from => p_rec.date_from
687: ,p_date_to => p_rec.date_to
688: );
689: hr_utility.set_location(l_proc, 50);
690: --
691: per_req_bus.chk_df
692: (p_rec => p_rec
693: );

Line 696: hr_utility.set_location(' Leaving:'||l_proc, 60);

692: (p_rec => p_rec
693: );
694: hr_multi_message.end_validation_set();
695: --
696: hr_utility.set_location(' Leaving:'||l_proc, 60);
697: End update_validate;
698: --
699: -- ----------------------------------------------------------------------------
700: -- |---------------------------< delete_validate >----------------------------|

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

705: --
706: l_proc varchar2(72) := g_package||'delete_validate';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call all supporting business operations
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call all supporting business operations
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: End delete_validate;
715: --
716: end per_req_bus;