[Home] [Help]
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: );
238: else
239: close csr_system_person_type;
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
258: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
259: ) then
260: --
261: hr_utility.set_location(' Leaving:'||l_proc,60);
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
343: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
344: ) then
345: hr_utility.set_location(' Leaving:'||l_proc, 40);
346: raise;
415: or (NOT l_api_updating)) then
416: --
417: -- Check if the job_id exists in PER_JOBS
418: --
419: if hr_multi_message.no_exclusive_error
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;
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
439: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
440: ) then
441: hr_utility.set_location(' Leaving:'||l_proc, 50);
442: raise;
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
515: (p_check_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
516: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
517: ) then
518: open csr_job_id_job_group_id;
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
535: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.JOB_ID'
536: ) then
537: hr_utility.set_location(' Leaving:'||l_proc, 40);
538: raise;
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'
613: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.END_DATE'
614: ) then
615: hr_utility.set_location(' Leaving:'||l_proc, 50);
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'
696: ) then
697: hr_utility.set_location(' Leaving:'||l_proc, 50);
698: raise;
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
776: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.DELETE_ALLOWED'
777: ) then
778: hr_utility.set_location(' Leaving:'||l_proc, 50);
779: raise;
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'
833: ,p_check_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
834: ) then
835: open csr_rec_team_member;
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
852: (p_associated_column1 => 'IRC_REC_TEAM_MEMBERS.PERSON_ID'
853: ,p_associated_column2 => 'IRC_REC_TEAM_MEMBERS.VACANCY_ID'
854: ) then
855: --