75: fetch csr_previous_employer_id into l_previous_employer_id;
76: if csr_previous_employer_id%notfound then
77: hr_utility.set_location(l_proc, 20);
78: close csr_previous_employer_id;
79: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
80: fnd_message.raise_error;
81: end if;
82: if csr_previous_employer_id%isopen then
83: close csr_previous_employer_id;
76: if csr_previous_employer_id%notfound then
77: hr_utility.set_location(l_proc, 20);
78: close csr_previous_employer_id;
79: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
80: fnd_message.raise_error;
81: end if;
82: if csr_previous_employer_id%isopen then
83: close csr_previous_employer_id;
84: end if;
154: fetch csr_previous_job_id into l_previous_job_id;
155: if csr_previous_job_id%notfound then
156: hr_utility.set_location(l_proc, 20);
157: close csr_previous_job_id;
158: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
159: fnd_message.raise_error;
160: end if;
161: if csr_previous_job_id%isopen then
162: close csr_previous_job_id;
155: if csr_previous_job_id%notfound then
156: hr_utility.set_location(l_proc, 20);
157: close csr_previous_job_id;
158: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
159: fnd_message.raise_error;
160: end if;
161: if csr_previous_job_id%isopen then
162: close csr_previous_job_id;
163: end if;
232: fetch csr_assignment_id into l_assignment_id;
233: if csr_assignment_id%notfound then
234: hr_utility.set_location(l_proc, 20);
235: close csr_assignment_id;
236: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
237: fnd_message.raise_error;
238: end if;
239: if csr_assignment_id%isopen then
240: close csr_assignment_id;
233: if csr_assignment_id%notfound then
234: hr_utility.set_location(l_proc, 20);
235: close csr_assignment_id;
236: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');
237: fnd_message.raise_error;
238: end if;
239: if csr_assignment_id%isopen then
240: close csr_assignment_id;
241: end if;
306: (not l_api_updating)) then
307: hr_utility.set_location(l_proc, 15);
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
313: fnd_message.raise_error;
314: end if;
307: hr_utility.set_location(l_proc, 15);
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
313: fnd_message.raise_error;
314: end if;
315: end if;
308: if nvl(p_start_date,hr_api.g_sot) > nvl(p_end_date,hr_api.g_eot) then
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
313: fnd_message.raise_error;
314: end if;
315: end if;
316: end if;
309: hr_utility.set_location(l_proc, 20);
310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
313: fnd_message.raise_error;
314: end if;
315: end if;
316: end if;
317: --
374: (not l_api_updating)) then
375: hr_utility.set_location(l_proc, 20);
376: if p_period_years not between 0 and 99 then
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);
380: fnd_message.set_token('RANGE_END',99,true);
381: fnd_message.raise_error;
382: end if;
375: hr_utility.set_location(l_proc, 20);
376: if p_period_years not between 0 and 99 then
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);
380: fnd_message.set_token('RANGE_END',99,true);
381: fnd_message.raise_error;
382: end if;
383: end if;
376: if p_period_years not between 0 and 99 then
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);
380: fnd_message.set_token('RANGE_END',99,true);
381: fnd_message.raise_error;
382: end if;
383: end if;
384: end if;
377: hr_utility.set_location(l_proc, 25);
378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
379: fnd_message.set_token('RANGE_START',0,true);
380: fnd_message.set_token('RANGE_END',99,true);
381: fnd_message.raise_error;
382: end if;
383: end if;
384: end if;
385: --
442: (not l_api_updating)) then
443: hr_utility.set_location(l_proc, 20);
444: if p_period_months not between 0 and 11 then
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);
448: fnd_message.set_token('RANGE_END',11,true);
449: fnd_message.raise_error;
450: end if;
443: hr_utility.set_location(l_proc, 20);
444: if p_period_months not between 0 and 11 then
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);
448: fnd_message.set_token('RANGE_END',11,true);
449: fnd_message.raise_error;
450: end if;
451: end if;
444: if p_period_months not between 0 and 11 then
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);
448: fnd_message.set_token('RANGE_END',11,true);
449: fnd_message.raise_error;
450: end if;
451: end if;
452: end if;
445: hr_utility.set_location(l_proc, 25);
446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
447: fnd_message.set_token('RANGE_START',0,true);
448: fnd_message.set_token('RANGE_END',11,true);
449: fnd_message.raise_error;
450: end if;
451: end if;
452: end if;
453: --
510: (not l_api_updating)) then
511: hr_utility.set_location(l_proc, 20);
512: if p_period_days not between 0 and 365 then
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);
516: fnd_message.set_token('RANGE_END',365,true);
517: fnd_message.raise_error;
518: end if;
511: hr_utility.set_location(l_proc, 20);
512: if p_period_days not between 0 and 365 then
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);
516: fnd_message.set_token('RANGE_END',365,true);
517: fnd_message.raise_error;
518: end if;
519: end if;
512: if p_period_days not between 0 and 365 then
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);
516: fnd_message.set_token('RANGE_END',365,true);
517: fnd_message.raise_error;
518: end if;
519: end if;
520: end if;
513: hr_utility.set_location(l_proc, 25);
514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
515: fnd_message.set_token('RANGE_START',0,true);
516: fnd_message.set_token('RANGE_END',365,true);
517: fnd_message.raise_error;
518: end if;
519: end if;
520: end if;
521: --
604: fetch csr_pem_start_end_dates into l_previous_employer_id;
605: if csr_pem_start_end_dates%found then
606: hr_utility.set_location(l_proc, 20);
607: close csr_pem_start_end_dates;
608: fnd_message.set_name('PER','HR_289550_PJU_DATES');
609: fnd_message.raise_error;
610: end if;
611: if csr_pem_start_end_dates%isopen then
612: close csr_pem_start_end_dates;
605: if csr_pem_start_end_dates%found then
606: hr_utility.set_location(l_proc, 20);
607: close csr_pem_start_end_dates;
608: fnd_message.set_name('PER','HR_289550_PJU_DATES');
609: fnd_message.raise_error;
610: end if;
611: if csr_pem_start_end_dates%isopen then
612: close csr_pem_start_end_dates;
613: end if;
691: fetch csr_asg_job into l_previous_job_usage_id;
692: if not csr_asg_job%notfound then
693: hr_utility.set_location(l_proc, 10);
694: close csr_asg_job;
695: fnd_message.set_name('PER','HR_289551_PJU_ASG_JOB_DUP');
696: fnd_message.raise_error;
697: end if;
698: if csr_asg_job%isopen then
699: hr_utility.set_location(l_proc, 15);
692: if not csr_asg_job%notfound then
693: hr_utility.set_location(l_proc, 10);
694: close csr_asg_job;
695: fnd_message.set_name('PER','HR_289551_PJU_ASG_JOB_DUP');
696: fnd_message.raise_error;
697: end if;
698: if csr_asg_job%isopen then
699: hr_utility.set_location(l_proc, 15);
700: close csr_asg_job;
779: hr_utility.set_location(l_proc, 15);
780: if csr_previous_job_dates%notfound then
781: hr_utility.set_location(l_proc, 20);
782: close csr_previous_job_dates;
783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
784: fnd_message.raise_error;
785: end if;
786: if csr_previous_job_dates%isopen then
787: hr_utility.set_location(l_proc, 25);
780: if csr_previous_job_dates%notfound then
781: hr_utility.set_location(l_proc, 20);
782: close csr_previous_job_dates;
783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
784: fnd_message.raise_error;
785: end if;
786: if csr_previous_job_dates%isopen then
787: hr_utility.set_location(l_proc, 25);
788: close csr_previous_job_dates;
862: open csr_asg_job_start_date;
863: fetch csr_asg_job_start_date into l_x;
864: if csr_asg_job_start_date%found then
865: close csr_asg_job_start_date;
866: fnd_message.set_name('PER','HR_289543_ASG_PJO_START_DATE');
867: fnd_message.raise_error;
868: end if;
869: if csr_asg_job_start_date%isopen then
870: close csr_asg_job_start_date;
863: fetch csr_asg_job_start_date into l_x;
864: if csr_asg_job_start_date%found then
865: close csr_asg_job_start_date;
866: fnd_message.set_name('PER','HR_289543_ASG_PJO_START_DATE');
867: fnd_message.raise_error;
868: end if;
869: if csr_asg_job_start_date%isopen then
870: close csr_asg_job_start_date;
871: end if;
920: close csr_sec_grp;
921: --
922: -- The primary key is invalid therefore we must error
923: --
924: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
925: fnd_message.raise_error;
926: --
927: end if;
928: close csr_sec_grp;
921: --
922: -- The primary key is invalid therefore we must error
923: --
924: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
925: fnd_message.raise_error;
926: --
927: end if;
928: close csr_sec_grp;
929: --
994: --
995: -- The primary key is invalid therefore we must error
996: --
997: close csr_leg_code;
998: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
999: fnd_message.raise_error;
1000: end if;
1001: hr_utility.set_location(l_proc,30);
1002: --
995: -- The primary key is invalid therefore we must error
996: --
997: close csr_leg_code;
998: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
999: fnd_message.raise_error;
1000: end if;
1001: hr_utility.set_location(l_proc,30);
1002: --
1003: -- Set the global variables so the values are
1328: IF NOT per_pju_shd.api_updating
1329: (p_previous_job_usage_id => p_rec.previous_job_usage_id
1330: ,p_object_version_number => p_rec.object_version_number
1331: ) THEN
1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1333: fnd_message.set_token('PROCEDURE ', l_proc);
1334: fnd_message.set_token('STEP ', '5');
1335: fnd_message.raise_error;
1336: END IF;
1329: (p_previous_job_usage_id => p_rec.previous_job_usage_id
1330: ,p_object_version_number => p_rec.object_version_number
1331: ) THEN
1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1333: fnd_message.set_token('PROCEDURE ', l_proc);
1334: fnd_message.set_token('STEP ', '5');
1335: fnd_message.raise_error;
1336: END IF;
1337: -- Check for non updateable args
1330: ,p_object_version_number => p_rec.object_version_number
1331: ) THEN
1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1333: fnd_message.set_token('PROCEDURE ', l_proc);
1334: fnd_message.set_token('STEP ', '5');
1335: fnd_message.raise_error;
1336: END IF;
1337: -- Check for non updateable args
1338: if per_pju_shd.g_old_rec.previous_job_usage_id <> p_rec.previous_job_usage_id
1331: ) THEN
1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1333: fnd_message.set_token('PROCEDURE ', l_proc);
1334: fnd_message.set_token('STEP ', '5');
1335: fnd_message.raise_error;
1336: END IF;
1337: -- Check for non updateable args
1338: if per_pju_shd.g_old_rec.previous_job_usage_id <> p_rec.previous_job_usage_id
1339: then