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_RTM_BUS dependencies on HR_UTILITY

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

29: l_proc varchar2(72) := g_package||'set_security_group_id';
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error

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

39: ,p_argument => 'rec_team_member_id'
40: ,p_argument_value => p_rec_team_member_id
41: );
42: --
43: hr_utility.set_location(' Leaving:'|| l_proc, 20);
44: --
45: end set_security_group_id;
46: --
47: -- ---------------------------------------------------------------------------

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

62: l_proc varchar2(72) := g_package||'return_legislation_code';
63: --
64: Begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Ensure that all the mandatory parameter are not null
69: --
70: hr_api.mandatory_arg_error

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

73: ,p_argument_value => p_rec_team_member_id
74: );
75: --
76:
77: hr_utility.set_location(' Leaving:'|| l_proc, 40);
78: return l_legislation_code;
79: end return_legislation_code;
80: --
81: -- ----------------------------------------------------------------------------

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

111: --
112: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
113: --
114: Begin
115: hr_utility.set_location(' Entering:'||l_proc,10);
116: --
117: -- Only proceed with the validation if a row exists for the current
118: -- record in the HR Schema.
119: --

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

147: ,p_base_table => irc_rtm_shd.g_tab_name
148: );
149: end if;
150: --
151: hr_utility.set_location(' Leaving:'||l_proc,20);
152: --
153: End chk_non_updateable_args;
154: --
155: -- ----------------------------------------------------------------------------

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

212: --
213: --
214: Begin
215: --
216: hr_utility.set_location(' Entering:'||l_proc,10);
217: --
218: open l_person;
219: fetch l_person into l_party_id;
220: if l_person%notfound

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

226: close l_person;
227: --check if the person is an employee
228: open csr_system_person_type;
229: fetch csr_system_person_type into l_var;
230: hr_utility.set_location(l_proc, 20);
231: if csr_system_person_type%notfound then
232: close csr_system_person_type;
233: hr_utility.set_location(l_proc, 30);
234: fnd_message.set_name('PER','IRC_412034_RTM_INV_EMP');

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

229: fetch csr_system_person_type into l_var;
230: hr_utility.set_location(l_proc, 20);
231: if csr_system_person_type%notfound then
232: close csr_system_person_type;
233: hr_utility.set_location(l_proc, 30);
234: fnd_message.set_name('PER','IRC_412034_RTM_INV_EMP');
235: hr_multi_message.add
236: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
237: );

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

249: p_party_id:=l_party_id;
250: end if;
251: --
252: --
253: hr_utility.set_location(' Leaving:'||l_proc,50);
254: --
255: exception
256: when app_exception.application_exception then
257: if hr_multi_message.exception_add

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

257: if hr_multi_message.exception_add
258: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
259: ) then
260: --
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: --
263: raise;
264: end if;
265: --

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

262: --
263: raise;
264: end if;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc,70);
267: --
268: End chk_person_id;
269: --
270: --

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

314: where vacancy_id = p_vacancy_id;
315: --
316: Begin
317: --
318: hr_utility.set_location(' Entering:'||l_proc,10);
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'vacancy_id'

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

327: -- and is current at the p_start_date.
328: --
329: open csr_vacancy_id;
330: fetch csr_vacancy_id into l_vacancy_id;
331: hr_utility.set_location(l_proc, 30);
332: if csr_vacancy_id%notfound then
333: close csr_vacancy_id;
334: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
335: fnd_message.raise_error;

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

334: fnd_message.set_name('PER','IRC_412032_RTM_INV_VACANCY_ID');
335: fnd_message.raise_error;
336: end if;
337: close csr_vacancy_id;
338: hr_utility.set_location(' Leaving:'||l_proc,35);
339: --
340: exception
341: when app_exception.application_exception then
342: if hr_multi_message.exception_add

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

341: when app_exception.application_exception then
342: if hr_multi_message.exception_add
343: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
344: ) then
345: hr_utility.set_location(' Leaving:'||l_proc, 40);
346: raise;
347: end if;
348: hr_utility.set_location(' Leaving:'||l_proc,50);
349: --

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

344: ) then
345: hr_utility.set_location(' Leaving:'||l_proc, 40);
346: raise;
347: end if;
348: hr_utility.set_location(' Leaving:'||l_proc,50);
349: --
350: End chk_vacancy_id;
351: --
352: --

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

402: and p_start_date between job.date_from and nvl(job.date_to,hr_api.g_eot);
403: --
404: Begin
405: --
406: hr_utility.set_location(' Entering:'||l_proc,10);
407: --
408: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
409: ,p_object_version_number);
410: --

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

407: --
408: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
409: ,p_object_version_number);
410: --
411: hr_utility.set_location(l_proc, 30);
412: if(p_job_id IS NOT NULL) then
413: if ((l_api_updating
414: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
415: or (NOT l_api_updating)) then

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

420: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
421: ) then
422: open csr_job_id;
423: fetch csr_job_id into l_job_id;
424: hr_utility.set_location(l_proc, 40);
425: if csr_job_id%notfound then
426: close csr_job_id;
427: fnd_message.set_name('PER','IRC_412037_RTM_INV_JOB_ID');
428: fnd_message.raise_error;

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

430: close csr_job_id;
431: end if;
432: end if;
433: end if;
434: hr_utility.set_location(' Leaving:'||l_proc,45);
435: --
436: exception
437: when app_exception.application_exception then
438: if hr_multi_message.exception_add

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

437: when app_exception.application_exception then
438: if hr_multi_message.exception_add
439: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
440: ) then
441: hr_utility.set_location(' Leaving:'||l_proc, 50);
442: raise;
443: end if;
444: hr_utility.set_location(' Leaving:'||l_proc,60);
445: --

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

440: ) then
441: hr_utility.set_location(' Leaving:'||l_proc, 50);
442: raise;
443: end if;
444: hr_utility.set_location(' Leaving:'||l_proc,60);
445: --
446: End chk_job_id;
447: --
448: -- ----------------------------------------------------------------------------

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

497: and jgr.internal_name <> 'HR_'||to_char(jgr.business_group_id);
498: --
499: Begin
500: --
501: hr_utility.set_location(' Entering:'||l_proc,10);
502: --
503: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
504: ,p_object_version_number);
505: --

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

506: if(p_job_id IS NOT NULL) then
507: if ((l_api_updating
508: and (irc_rtm_shd.g_old_rec.job_id <> p_job_id))
509: or (NOT l_api_updating)) then
510: hr_utility.set_location(l_proc, 20);
511: --
512: -- Check if the job_group_id exists in PER_JOB_GROUPS and is valid.
513: --
514: if hr_multi_message.no_exclusive_error

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

516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
517: ) then
518: open csr_job_id_job_group_id;
519: fetch csr_job_id_job_group_id into l_job_id_job_group_id;
520: hr_utility.set_location(l_proc, 30);
521: if csr_job_id_job_group_id%notfound then
522: close csr_job_id_job_group_id;
523: fnd_message.set_name('PER','IRC_412041_RTM_INV_JOB_GRP_ID');
524: fnd_message.raise_error;

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

526: close csr_job_id_job_group_id;
527: end if;
528: end if;
529: end if;
530: hr_utility.set_location(' Leaving:'||l_proc,35);
531: --
532: exception
533: when app_exception.application_exception then
534: if hr_multi_message.exception_add

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

533: when app_exception.application_exception then
534: if hr_multi_message.exception_add
535: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
536: ) then
537: hr_utility.set_location(' Leaving:'||l_proc, 40);
538: raise;
539: end if;
540: hr_utility.set_location(' Leaving:'||l_proc,50);
541: --

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

536: ) then
537: hr_utility.set_location(' Leaving:'||l_proc, 40);
538: raise;
539: end if;
540: hr_utility.set_location(' Leaving:'||l_proc,50);
541: --
542: End chk_job_id_job_group_id;
543: --
544: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

659: l_api_updating boolean;
660: --
661: Begin
662: --
663: hr_utility.set_location(' Entering:'||l_proc,10);
664: if (p_update_allowed is not NULL) then
665: --
666: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id
667: ,p_object_version_number);

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

667: ,p_object_version_number);
668: --
669: -- Check to see if the update_allowed value has changed.
670: --
671: hr_utility.set_location(l_proc, 30);
672: if ((l_api_updating
673: and (irc_rtm_shd.g_old_rec.update_allowed <> p_update_allowed))
674: or (NOT l_api_updating)) then
675: --

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

679: (p_start_date
680: ,'YES_NO'
681: ,p_update_allowed
682: );
683: hr_utility.set_location(l_proc, 40);
684: if (l_var = true) then
685: fnd_message.set_name('PER','IRC_412039_RTM_INV_UPD_ALLOWED');
686: fnd_message.raise_error;
687: end if;

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

687: end if;
688: end if;
689: --
690: end if;
691: hr_utility.set_location(' Leaving:'||l_proc,45);
692: exception
693: when app_exception.application_exception then
694: if hr_multi_message.exception_add
695: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.UPDATE_ALLOWED'

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

693: when app_exception.application_exception then
694: if hr_multi_message.exception_add
695: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.UPDATE_ALLOWED'
696: ) then
697: hr_utility.set_location(' Leaving:'||l_proc, 50);
698: raise;
699: end if;
700: hr_utility.set_location(' Leaving:'||l_proc,60);
701: --

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

696: ) then
697: hr_utility.set_location(' Leaving:'||l_proc, 50);
698: raise;
699: end if;
700: hr_utility.set_location(' Leaving:'||l_proc,60);
701: --
702: End chk_update_allowed;
703: --
704: -- ----------------------------------------------------------------------------

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

741: l_api_updating boolean;
742: --
743: Begin
744: --
745: hr_utility.set_location(' Entering:'||l_proc,10);
746: if (p_delete_allowed is not NULL) then
747: --
748: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id,p_object_version_number);
749: --

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

748: l_api_updating := irc_rtm_shd.api_updating(p_rec_team_member_id,p_object_version_number);
749: --
750: -- Check to see if the delete_allowed value has changed.
751: --
752: hr_utility.set_location(l_proc, 30);
753: if ((l_api_updating
754: and (irc_rtm_shd.g_old_rec.delete_allowed <> p_delete_allowed))
755: or (NOT l_api_updating)) then
756: --

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

760: (p_start_date
761: ,'YES_NO'
762: ,p_delete_allowed
763: );
764: hr_utility.set_location(l_proc, 40);
765: if (l_var = true) then
766: fnd_message.set_name('PER','IRC_412040_RTM_INV_DEL_ALLOWED');
767: fnd_message.raise_error;
768: end if;

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

767: fnd_message.raise_error;
768: end if;
769: end if;
770: end if;
771: hr_utility.set_location(' Leaving:'||l_proc,45);
772: --
773: exception
774: when app_exception.application_exception then
775: if hr_multi_message.exception_add

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

774: when app_exception.application_exception then
775: if hr_multi_message.exception_add
776: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.DELETE_ALLOWED'
777: ) then
778: hr_utility.set_location(' Leaving:'||l_proc, 50);
779: raise;
780: end if;
781: hr_utility.set_location(' Leaving:'||l_proc,60);
782: --

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

777: ) then
778: hr_utility.set_location(' Leaving:'||l_proc, 50);
779: raise;
780: end if;
781: hr_utility.set_location(' Leaving:'||l_proc,60);
782: --
783: End chk_delete_allowed;
784: --
785: -- ----------------------------------------------------------------------------

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

824: and vacancy_id = p_vacancy_id;
825: --
826: Begin
827: --
828: hr_utility.set_location(' Entering:'||l_proc,10);
829: --
830:
831: if hr_multi_message.no_exclusive_error
832: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'

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

833: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
834: ) then
835: open csr_rec_team_member;
836: fetch csr_rec_team_member into l_var;
837: hr_utility.set_location(l_proc, 20);
838: if csr_rec_team_member%found then
839: close csr_rec_team_member;
840: hr_utility.set_location(l_proc, 30);
841: fnd_message.set_name('PER','IRC_412120_DUP_REC_TEAM_MEMBER');

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

836: fetch csr_rec_team_member into l_var;
837: hr_utility.set_location(l_proc, 20);
838: if csr_rec_team_member%found then
839: close csr_rec_team_member;
840: hr_utility.set_location(l_proc, 30);
841: fnd_message.set_name('PER','IRC_412120_DUP_REC_TEAM_MEMBER');
842: fnd_message.raise_error;
843: end if;
844: close csr_rec_team_member;

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

843: end if;
844: close csr_rec_team_member;
845: end if;
846: --
847: hr_utility.set_location(' Leaving:'||l_proc,40);
848: --
849: exception
850: when app_exception.application_exception then
851: if hr_multi_message.exception_add

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

852: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
853: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
854: ) then
855: --
856: hr_utility.set_location(' Leaving:'||l_proc,50);
857: --
858: raise;
859: end if;
860: --

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

857: --
858: raise;
859: end if;
860: --
861: hr_utility.set_location(' Leaving:'||l_proc,60);
862: --
863: End chk_rec_team_member;
864: --
865: --

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

872: --
873: l_proc varchar2(72) := g_package||'insert_validate';
874: --
875: Begin
876: hr_utility.set_location('Entering:'||l_proc, 5);
877: --
878: -- Call all supporting business operations
879: --
880: -- Validate Dependent Attributes

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

877: --
878: -- Call all supporting business operations
879: --
880: -- Validate Dependent Attributes
881: hr_utility.set_location(l_proc, 10);
882: --
883: chk_person_id
884: (p_person_id =>p_rec.person_id
885: ,p_party_id => p_rec.party_id

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

885: ,p_party_id => p_rec.party_id
886: ,p_effective_date=>p_rec.start_date
887: );
888: --
889: hr_utility.set_location(l_proc, 20);
890: chk_vacancy_id
891: (p_vacancy_id => p_rec.vacancy_id
892: ,p_start_date => p_rec.start_date
893: );

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

891: (p_vacancy_id => p_rec.vacancy_id
892: ,p_start_date => p_rec.start_date
893: );
894: --
895: hr_utility.set_location(l_proc, 30);
896: chk_rec_team_member
897: (p_person_id =>p_rec.person_id
898: ,p_vacancy_id => p_rec.vacancy_id
899: );

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

897: (p_person_id =>p_rec.person_id
898: ,p_vacancy_id => p_rec.vacancy_id
899: );
900: --
901: hr_utility.set_location(l_proc, 40);
902: chk_job_id
903: (p_job_id => p_rec.job_id
904: ,p_rec_team_member_id => p_rec.rec_team_member_id
905: ,p_vacancy_id => p_rec.vacancy_id

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

906: ,p_object_version_number => p_rec.object_version_number
907: ,p_start_date => p_rec.start_date
908: );
909: --
910: hr_utility.set_location(l_proc, 50);
911: chk_job_id_job_group_id
912: (p_rec_team_member_id => p_rec.rec_team_member_id
913: ,p_job_id => p_rec.job_id
914: ,p_object_version_number => p_rec.object_version_number

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

913: ,p_job_id => p_rec.job_id
914: ,p_object_version_number => p_rec.object_version_number
915: );
916: --
917: hr_utility.set_location(l_proc, 60);
918: chk_team_dates
919: (p_start_date => p_rec.start_date
920: ,p_end_date => p_rec.end_date
921: ,p_rec_team_member_id => p_rec.rec_team_member_id

Line 925: hr_utility.set_location(l_proc, 70);

921: ,p_rec_team_member_id => p_rec.rec_team_member_id
922: ,p_object_version_number => p_rec.object_version_number
923: );
924: --
925: hr_utility.set_location(l_proc, 70);
926: chk_update_allowed
927: (p_update_allowed => p_rec.update_allowed
928: ,p_start_date => p_rec.start_date
929: ,p_rec_team_member_id => p_rec.rec_team_member_id

Line 933: hr_utility.set_location(l_proc, 80);

929: ,p_rec_team_member_id => p_rec.rec_team_member_id
930: ,p_object_version_number => p_rec.object_version_number
931: );
932: --
933: hr_utility.set_location(l_proc, 80);
934: chk_delete_allowed
935: (p_delete_allowed => p_rec.delete_allowed
936: ,p_start_date => p_rec.start_date
937: ,p_rec_team_member_id => p_rec.rec_team_member_id

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

937: ,p_rec_team_member_id => p_rec.rec_team_member_id
938: ,p_object_version_number => p_rec.object_version_number
939: );
940: --
941: hr_utility.set_location(' Leaving:'||l_proc, 100);
942: End insert_validate;
943: --
944: -- ----------------------------------------------------------------------------
945: -- |---------------------------< update_validate >----------------------------|

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

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

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

955: --
956: -- Call all supporting business operations
957: --
958: -- Validate Dependent Attributes
959: hr_utility.set_location(l_proc, 10);
960: --
961: chk_person_id
962: (p_person_id =>p_rec.person_id
963: ,p_party_id => p_rec.party_id

Line 967: hr_utility.set_location(l_proc, 15);

963: ,p_party_id => p_rec.party_id
964: ,p_effective_date=>p_rec.start_date
965: );
966: --
967: hr_utility.set_location(l_proc, 15);
968: chk_job_id
969: (p_job_id => p_rec.job_id
970: ,p_rec_team_member_id => p_rec.rec_team_member_id
971: ,p_vacancy_id => p_rec.vacancy_id

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

972: ,p_object_version_number => p_rec.object_version_number
973: ,p_start_date => p_rec.start_date
974: );
975: --
976: hr_utility.set_location(l_proc, 20);
977: chk_job_id_job_group_id
978: (p_rec_team_member_id => p_rec.rec_team_member_id
979: ,p_job_id => p_rec.job_id
980: ,p_object_version_number => p_rec.object_version_number

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

979: ,p_job_id => p_rec.job_id
980: ,p_object_version_number => p_rec.object_version_number
981: );
982: --
983: hr_utility.set_location(l_proc, 30);
984: chk_team_dates
985: (p_start_date => p_rec.start_date
986: ,p_end_date => p_rec.end_date
987: ,p_rec_team_member_id => p_rec.rec_team_member_id

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

987: ,p_rec_team_member_id => p_rec.rec_team_member_id
988: ,p_object_version_number => p_rec.object_version_number
989: );
990: --
991: hr_utility.set_location(l_proc, 40);
992: chk_update_allowed
993: (p_update_allowed => p_rec.update_allowed
994: ,p_start_date => p_rec.start_date
995: ,p_rec_team_member_id => p_rec.rec_team_member_id

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

995: ,p_rec_team_member_id => p_rec.rec_team_member_id
996: ,p_object_version_number => p_rec.object_version_number
997: );
998: --
999: hr_utility.set_location(l_proc, 50);
1000: chk_delete_allowed
1001: (p_delete_allowed => p_rec.delete_allowed
1002: ,p_start_date => p_rec.start_date
1003: ,p_rec_team_member_id => p_rec.rec_team_member_id

Line 1008: hr_utility.set_location(l_proc, 70);

1004: ,p_object_version_number => p_rec.object_version_number
1005: );
1006: --
1007: --
1008: hr_utility.set_location(l_proc, 70);
1009: chk_non_updateable_args
1010: (p_rec => p_rec
1011: );
1012: --

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

1010: (p_rec => p_rec
1011: );
1012: --
1013: --
1014: hr_utility.set_location(' Leaving:'||l_proc, 80);
1015: End update_validate;
1016: --
1017: -- ----------------------------------------------------------------------------
1018: -- |---------------------------< delete_validate >----------------------------|

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

1023: --
1024: l_proc varchar2(72) := g_package||'delete_validate';
1025: --
1026: Begin
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: -- Call all supporting business operations
1030: --
1031: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: -- Call all supporting business operations
1030: --
1031: hr_utility.set_location(' Leaving:'||l_proc, 10);
1032: End delete_validate;
1033: --
1034: end irc_rtm_bus;