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

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := irc_iav_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: irc_iav_bus.g_vacancy_id := p_vacancy_id;
154: irc_iav_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.agency_vacancy_id is not null) and (
198: nvl(irc_iav_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

331: ); */
332: null;
333: end if;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc,20);
336: end chk_df;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |-----------------------< chk_non_updateable_args >------------------------|

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

428: and vendor_type_lookup_code = 'IRC_JOB_AGENCY';
429: --
430: Begin
431: --
432: hr_utility.set_location(' Entering:'||l_proc,10);
433: --
434: open csr_agency_id;
435: fetch csr_agency_id into l_agency_id;
436: --

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

433: --
434: open csr_agency_id;
435: fetch csr_agency_id into l_agency_id;
436: --
437: hr_utility.set_location(l_proc,20);
438: --
439: if csr_agency_id%notfound then
440: close csr_agency_id;
441: fnd_message.set_name('PER','IRC_BAD_AGENCY_ID');

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

441: fnd_message.set_name('PER','IRC_BAD_AGENCY_ID');
442: fnd_message.raise_error;
443: end if;
444: --
445: hr_utility.set_location(l_proc,30);
446: --
447: close csr_agency_id;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc,50);

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

445: hr_utility.set_location(l_proc,30);
446: --
447: close csr_agency_id;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc,50);
450: --
451: exception
452: when app_exception.application_exception then
453: if hr_multi_message.exception_add

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

453: if hr_multi_message.exception_add
454: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
455: ) then
456: --
457: hr_utility.set_location(' Leaving:'||l_proc,60);
458: --
459: raise;
460: end if;
461: --

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

458: --
459: raise;
460: end if;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc,70);
463: --
464: End chk_agency_id;
465:
466: --

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

509: and p_start_date between date_from and nvl(date_to,hr_api.g_eot);
510: --
511: Begin
512: --
513: hr_utility.set_location(' Entering:'||l_proc,10);
514: --
515: hr_api.mandatory_arg_error
516: (p_api_name => l_proc
517: ,p_argument => 'vacancy_id'

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

522: -- and is current at the p_start_date.
523: --
524: open csr_vacancy_id;
525: fetch csr_vacancy_id into l_vacancy_id;
526: hr_utility.set_location(l_proc, 30);
527: if csr_vacancy_id%notfound then
528: close csr_vacancy_id;
529: fnd_message.set_name('PER','IRC_IAV_INV_VACANCY_ID');
530: fnd_message.raise_error;

Line 533: hr_utility.set_location(' Leaving:'||l_proc,35);

529: fnd_message.set_name('PER','IRC_IAV_INV_VACANCY_ID');
530: fnd_message.raise_error;
531: end if;
532: close csr_vacancy_id;
533: hr_utility.set_location(' Leaving:'||l_proc,35);
534: --
535: exception
536: when app_exception.application_exception then
537: if hr_multi_message.exception_add

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

536: when app_exception.application_exception then
537: if hr_multi_message.exception_add
538: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
539: ) then
540: hr_utility.set_location(' Leaving:'||l_proc, 40);
541: raise;
542: end if;
543: hr_utility.set_location(' Leaving:'||l_proc,50);
544: --

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

539: ) then
540: hr_utility.set_location(' Leaving:'||l_proc, 40);
541: raise;
542: end if;
543: hr_utility.set_location(' Leaving:'||l_proc,50);
544: --
545: End chk_vacancy_id;
546:
547:

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

581: l_api_updating boolean;
582: --
583: Begin
584: --
585: hr_utility.set_location(' Entering:'||l_proc,10);
586: if (p_start_date is not NULL or p_end_date is not NULL) then
587: --
588: l_api_updating := irc_iav_shd.api_updating(p_agency_vacancy_id
589: ,p_object_version_number);

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

589: ,p_object_version_number);
590: --
591: -- Check to see if start_date or end_date values have changed.
592: --
593: hr_utility.set_location(l_proc, 30);
594: if ((l_api_updating
595: and ((nvl(irc_iav_shd.g_old_rec.start_date,hr_api.g_sot)
596: <> p_start_date)
597: or (nvl(irc_iav_shd.g_old_rec.end_date,hr_api.g_eot) <> p_end_date)))

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

598: or (NOT l_api_updating)) then
599: --
600: -- Check that the end date is not before the start date.
601: --
602: hr_utility.set_location(l_proc, 40);
603: if(nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot)) then
604: fnd_message.set_name('PER','IRC_IAV_INV_ST_END_DATE');
605: fnd_message.raise_error;
606: end if;

Line 610: hr_utility.set_location(' Leaving:'||l_proc,45);

606: end if;
607: --
608: end if;
609: end if;
610: hr_utility.set_location(' Leaving:'||l_proc,45);
611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'

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

613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'
615: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.END_DATE'
616: ) then
617: hr_utility.set_location(' Leaving:'||l_proc, 50);
618: raise;
619: end if;
620: hr_utility.set_location(' Leaving:'||l_proc,60);
621: --

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

616: ) then
617: hr_utility.set_location(' Leaving:'||l_proc, 50);
618: raise;
619: end if;
620: hr_utility.set_location(' Leaving:'||l_proc,60);
621: --
622: End chk_end_date;
623:
624:

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

679: l_api_updating boolean;
680:
681: Begin
682: --
683: hr_utility.set_location(' Entering:'||l_proc,10);
684: --
685: hr_api.mandatory_arg_error
686: (p_api_name => l_proc
687: ,p_argument => 'agency_id'

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

703: --
704: if l_api_updating then
705: open csr_agency_vacancy_upd ;
706: fetch csr_agency_vacancy_upd into l_agency_vacancy_id;
707: hr_utility.set_location(l_proc, 30);
708: if csr_agency_vacancy_upd%found then
709: close csr_agency_vacancy_upd ;
710: fnd_message.set_name('PER','IRC_IAV_INV_AGENCY_VAC_COMB');
711: fnd_message.raise_error;

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

713: close csr_agency_vacancy_upd ;
714: else
715: open csr_agency_vacancy_id;
716: fetch csr_agency_vacancy_id into l_agency_vacancy_id;
717: hr_utility.set_location(l_proc, 40);
718: if csr_agency_vacancy_id%found then
719: close csr_agency_vacancy_id;
720: fnd_message.set_name('PER','IRC_IAV_INV_AGENCY_VAC_COMB');
721: fnd_message.raise_error;

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

723: close csr_agency_vacancy_id;
724: --
725: end if;
726: --
727: hr_utility.set_location(' Leaving:'||l_proc,50);
728: --
729: exception
730: when app_exception.application_exception then
731: if hr_multi_message.exception_add

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

731: if hr_multi_message.exception_add
732: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
733: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
734: ) then
735: hr_utility.set_location(' Leaving:'||l_proc, 60);
736: raise;
737: end if;
738: hr_utility.set_location(' Leaving:'||l_proc,70);
739: --

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

734: ) then
735: hr_utility.set_location(' Leaving:'||l_proc, 60);
736: raise;
737: end if;
738: hr_utility.set_location(' Leaving:'||l_proc,70);
739: --
740: End chk_agency_vac_comb_id;
741:
742:

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

779: l_api_updating boolean;
780: --
781: Begin
782: --
783: hr_utility.set_location(' Entering:'||l_proc,10);
784: if (p_manage_applicants_allowed is not NULL) then
785: --
786: l_api_updating := irc_iav_shd.api_updating(p_agency_vacancy_id
787: ,p_object_version_number);

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

787: ,p_object_version_number);
788: --
789: -- Check to see if the update_allowed value has changed.
790: --
791: hr_utility.set_location(l_proc, 30);
792: if ((l_api_updating
793: and (irc_iav_shd.g_old_rec.manage_applicants_allowed <> p_manage_applicants_allowed))
794: or (NOT l_api_updating)) then
795: --

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

799: (p_start_date
800: ,'YES_NO'
801: ,p_manage_applicants_allowed
802: );
803: hr_utility.set_location(l_proc, 40);
804: if (l_var = true) then
805: fnd_message.set_name('PER','IRC_IAV_INV_MNG_APL_ALLOWED');
806: fnd_message.raise_error;
807: end if;

Line 811: hr_utility.set_location(' Leaving:'||l_proc,45);

807: end if;
808: end if;
809: --
810: end if;
811: hr_utility.set_location(' Leaving:'||l_proc,45);
812: exception
813: when app_exception.application_exception then
814: if hr_multi_message.exception_add
815: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.MANAGE_APPLICANTS_ALLOWED'

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

813: when app_exception.application_exception then
814: if hr_multi_message.exception_add
815: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.MANAGE_APPLICANTS_ALLOWED'
816: ) then
817: hr_utility.set_location(' Leaving:'||l_proc, 50);
818: raise;
819: end if;
820: hr_utility.set_location(' Leaving:'||l_proc,60);
821: --

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

816: ) then
817: hr_utility.set_location(' Leaving:'||l_proc, 50);
818: raise;
819: end if;
820: hr_utility.set_location(' Leaving:'||l_proc,60);
821: --
822: End chk_manage_appl_allowed;
823: --
824: -- ----------------------------------------------------------------------------

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

830: --
831: l_proc varchar2(72) := g_package||'insert_validate';
832: --
833: Begin
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- Call all supporting business operations
837: --
838: hr_utility.set_location(l_proc, 10);

Line 838: hr_utility.set_location(l_proc, 10);

834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: -- Call all supporting business operations
837: --
838: hr_utility.set_location(l_proc, 10);
839: irc_iav_bus.set_security_group_id
840: (p_vacancy_id => p_rec.vacancy_id
841: ,p_associated_column1 => irc_iav_shd.g_tab_nam||'.VACANCY_ID'
842: );

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

875: ,p_agency_vacancy_id => p_rec.agency_vacancy_id
876: ,p_object_version_number => p_rec.object_version_number
877: );
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 20);
880: End insert_validate;
881: --
882: -- ----------------------------------------------------------------------------
883: -- |---------------------------< update_validate >----------------------------|

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

888: --
889: l_proc varchar2(72) := g_package||'update_validate';
890: --
891: Begin
892: hr_utility.set_location('Entering:'||l_proc, 5);
893: --
894: -- Call all supporting business operations
895: --
896: hr_utility.set_location(l_proc, 10);

Line 896: hr_utility.set_location(l_proc, 10);

892: hr_utility.set_location('Entering:'||l_proc, 5);
893: --
894: -- Call all supporting business operations
895: --
896: hr_utility.set_location(l_proc, 10);
897: irc_iav_bus.set_security_group_id
898: (p_vacancy_id => p_rec.vacancy_id
899: ,p_associated_column1 => irc_iav_shd.g_tab_nam||'.VACANCY_ID'
900: );

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

937: ,p_agency_vacancy_id => p_rec.agency_vacancy_id
938: ,p_object_version_number => p_rec.object_version_number
939: );
940: --
941: hr_utility.set_location(' Leaving:'||l_proc, 20);
942: End update_validate;
943: --
944: -- ----------------------------------------------------------------------------
945: -- |---------------------------< delete_validate >----------------------------|

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

950: --
951: l_proc varchar2(72) := g_package||'delete_validate';
952: --
953: Begin
954: hr_utility.set_location('Entering:'||l_proc, 5);
955: --
956: -- Call all supporting business operations
957: --
958: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

954: hr_utility.set_location('Entering:'||l_proc, 5);
955: --
956: -- Call all supporting business operations
957: --
958: hr_utility.set_location(' Leaving:'||l_proc, 10);
959: End delete_validate;
960: --
961: end irc_iav_bus;