DBA Data[Home] [Help]

APPS.PER_PJU_BUS dependencies on FND_MESSAGE

Line 79: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');

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;

Line 80: fnd_message.raise_error;

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;

Line 158: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');

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;

Line 159: fnd_message.raise_error;

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;

Line 236: fnd_message.set_name('PER','HR_289541_PJU_INV_ASG_ID');

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;

Line 237: fnd_message.raise_error;

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;

Line 310: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');

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;

Line 311: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);

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;

Line 312: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);

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;

Line 313: fnd_message.raise_error;

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: --

Line 378: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');

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;

Line 379: fnd_message.set_token('RANGE_START',0,true);

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;

Line 380: fnd_message.set_token('RANGE_END',99,true);

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;

Line 381: fnd_message.raise_error;

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: --

Line 446: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');

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;

Line 447: fnd_message.set_token('RANGE_START',0,true);

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;

Line 448: fnd_message.set_token('RANGE_END',11,true);

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;

Line 449: fnd_message.raise_error;

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: --

Line 514: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');

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;

Line 515: fnd_message.set_token('RANGE_START',0,true);

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;

Line 516: fnd_message.set_token('RANGE_END',365,true);

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;

Line 517: fnd_message.raise_error;

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: --

Line 608: fnd_message.set_name('PER','HR_289550_PJU_DATES');

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;

Line 609: fnd_message.raise_error;

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;

Line 695: fnd_message.set_name('PER','HR_289551_PJU_ASG_JOB_DUP');

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);

Line 696: fnd_message.raise_error;

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;

Line 783: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');

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);

Line 784: fnd_message.raise_error;

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;

Line 866: fnd_message.set_name('PER','HR_289543_ASG_PJO_START_DATE');

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;

Line 867: fnd_message.raise_error;

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;

Line 924: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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;

Line 925: fnd_message.raise_error;

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: --

Line 998: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 999: fnd_message.raise_error;

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

Line 1332: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1333: fnd_message.set_token('PROCEDURE ', l_proc);

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

Line 1334: fnd_message.set_token('STEP ', '5');

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

Line 1335: fnd_message.raise_error;

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