DBA Data[Home] [Help]

APPS.PER_PJO_BUS dependencies on FND_MESSAGE

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

61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'PREVIOUS_JOB_ID')
69: );

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

141: --
142: -- The primary key is invalid therefore we must error
143: --
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --

Line 146: fnd_message.raise_error;

142: -- The primary key is invalid therefore we must error
143: --
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are

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

554: IF NOT per_pjo_shd.api_updating
555: (p_previous_job_id => p_rec.previous_job_id
556: ,p_object_version_number => p_rec.object_version_number
557: ) THEN
558: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
559: fnd_message.set_token('PROCEDURE ', l_proc);
560: fnd_message.set_token('STEP ', '5');
561: fnd_message.raise_error;
562: END IF;

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

555: (p_previous_job_id => p_rec.previous_job_id
556: ,p_object_version_number => p_rec.object_version_number
557: ) THEN
558: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
559: fnd_message.set_token('PROCEDURE ', l_proc);
560: fnd_message.set_token('STEP ', '5');
561: fnd_message.raise_error;
562: END IF;
563: --

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

556: ,p_object_version_number => p_rec.object_version_number
557: ) THEN
558: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
559: fnd_message.set_token('PROCEDURE ', l_proc);
560: fnd_message.set_token('STEP ', '5');
561: fnd_message.raise_error;
562: END IF;
563: --
564: -- Add checks to ensure non-updateable args have

Line 561: fnd_message.raise_error;

557: ) THEN
558: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
559: fnd_message.set_token('PROCEDURE ', l_proc);
560: fnd_message.set_token('STEP ', '5');
561: fnd_message.raise_error;
562: END IF;
563: --
564: -- Add checks to ensure non-updateable args have
565: -- not been updated.

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

641: fetch csr_previous_employer_id into l_previous_employer_id;
642: if csr_previous_employer_id%notfound then
643: hr_utility.set_location(l_proc, 20);
644: close csr_previous_employer_id;
645: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
646: fnd_message.raise_error;
647: end if;
648: if csr_previous_employer_id%isopen then
649: close csr_previous_employer_id;

Line 646: fnd_message.raise_error;

642: if csr_previous_employer_id%notfound then
643: hr_utility.set_location(l_proc, 20);
644: close csr_previous_employer_id;
645: fnd_message.set_name('PER','HR_289537_PJO_VALID_PR_EMPR_ID');
646: fnd_message.raise_error;
647: end if;
648: if csr_previous_employer_id%isopen then
649: close csr_previous_employer_id;
650: end if;

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

719: (not l_api_updating) then
720: hr_utility.set_location(l_proc, 15);
721: if p_start_date > p_end_date then
722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
725: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),TRUE);
726: fnd_message.raise_error;
727: end if;

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

720: hr_utility.set_location(l_proc, 15);
721: if p_start_date > p_end_date then
722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
725: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),TRUE);
726: fnd_message.raise_error;
727: end if;
728: end if;

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

721: if p_start_date > p_end_date then
722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
725: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),TRUE);
726: fnd_message.raise_error;
727: end if;
728: end if;
729: end if;

Line 726: fnd_message.raise_error;

722: hr_utility.set_location(l_proc, 20);
723: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
724: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),TRUE);
725: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),TRUE);
726: fnd_message.raise_error;
727: end if;
728: end if;
729: end if;
730: --

Line 809: fnd_message.set_name('PER','HR_289538_PJO_EMPT_CAT');

805: );
806: hr_utility.set_location(l_proc, 20);
807: if l_no_lookup = true then
808: hr_utility.set_location(l_proc, 25);
809: fnd_message.set_name('PER','HR_289538_PJO_EMPT_CAT');
810: fnd_message.raise_error;
811: end if;
812: end if;
813: end if;

Line 810: fnd_message.raise_error;

806: hr_utility.set_location(l_proc, 20);
807: if l_no_lookup = true then
808: hr_utility.set_location(l_proc, 25);
809: fnd_message.set_name('PER','HR_289538_PJO_EMPT_CAT');
810: fnd_message.raise_error;
811: end if;
812: end if;
813: end if;
814: --

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

876: (not l_api_updating)) then
877: hr_utility.set_location(l_proc, 20);
878: if p_period_years not between 0 and 99 then
879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
882: fnd_message.set_token('RANGE_END','99',true);
883: fnd_message.raise_error;
884: end if;

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

877: hr_utility.set_location(l_proc, 20);
878: if p_period_years not between 0 and 99 then
879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
882: fnd_message.set_token('RANGE_END','99',true);
883: fnd_message.raise_error;
884: end if;
885: end if;

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

878: if p_period_years not between 0 and 99 then
879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
882: fnd_message.set_token('RANGE_END','99',true);
883: fnd_message.raise_error;
884: end if;
885: end if;
886: end if;

Line 883: fnd_message.raise_error;

879: hr_utility.set_location(l_proc, 25);
880: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
881: fnd_message.set_token('RANGE_START','0',true);
882: fnd_message.set_token('RANGE_END','99',true);
883: fnd_message.raise_error;
884: end if;
885: end if;
886: end if;
887: --

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

949: (not l_api_updating)) then
950: hr_utility.set_location(l_proc, 20);
951: if p_period_months not between 0 and 11 then
952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
955: fnd_message.set_token('RANGE_END','11',true);
956: fnd_message.raise_error;
957: end if;

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

950: hr_utility.set_location(l_proc, 20);
951: if p_period_months not between 0 and 11 then
952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
955: fnd_message.set_token('RANGE_END','11',true);
956: fnd_message.raise_error;
957: end if;
958: end if;

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

951: if p_period_months not between 0 and 11 then
952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
955: fnd_message.set_token('RANGE_END','11',true);
956: fnd_message.raise_error;
957: end if;
958: end if;
959: end if;

Line 956: fnd_message.raise_error;

952: hr_utility.set_location(l_proc, 25);
953: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
954: fnd_message.set_token('RANGE_START','0',true);
955: fnd_message.set_token('RANGE_END','11',true);
956: fnd_message.raise_error;
957: end if;
958: end if;
959: end if;
960: --

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

1022: (not l_api_updating)) then
1023: hr_utility.set_location(l_proc, 20);
1024: if p_period_days not between 0 and 365 then
1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1028: fnd_message.set_token('RANGE_END','365',true);
1029: fnd_message.raise_error;
1030: end if;

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

1023: hr_utility.set_location(l_proc, 20);
1024: if p_period_days not between 0 and 365 then
1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1028: fnd_message.set_token('RANGE_END','365',true);
1029: fnd_message.raise_error;
1030: end if;
1031: end if;

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

1024: if p_period_days not between 0 and 365 then
1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1028: fnd_message.set_token('RANGE_END','365',true);
1029: fnd_message.raise_error;
1030: end if;
1031: end if;
1032: end if;

Line 1029: fnd_message.raise_error;

1025: hr_utility.set_location(l_proc, 25);
1026: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1027: fnd_message.set_token('RANGE_START','0',true);
1028: fnd_message.set_token('RANGE_END','365',true);
1029: fnd_message.raise_error;
1030: end if;
1031: end if;
1032: end if;
1033: --

Line 1113: fnd_message.set_name('PER','HR_INVAL_ST_DT_PJO');

1109: ) THEN
1110: hr_utility.set_location('Entering:'||l_proc, 6);
1111: -- This if condition added for bug 7112425
1112: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1113: fnd_message.set_name('PER','HR_INVAL_ST_DT_PJO');
1114: fnd_message.raise_error;
1115: END IF ;
1116: hr_utility.set_location('Entering:'||l_proc, 7);
1117:

Line 1114: fnd_message.raise_error;

1110: hr_utility.set_location('Entering:'||l_proc, 6);
1111: -- This if condition added for bug 7112425
1112: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1113: fnd_message.set_name('PER','HR_INVAL_ST_DT_PJO');
1114: fnd_message.raise_error;
1115: END IF ;
1116: hr_utility.set_location('Entering:'||l_proc, 7);
1117:
1118: if p_start_date is not null or p_end_date is not null then

Line 1138: fnd_message.set_name('PER','HR_289542_PJO_START_END_DATES');

1134: fetch csr_pem_start_end_dates into l_previous_employer_id;
1135: if csr_pem_start_end_dates%found then
1136: hr_utility.set_location(l_proc, 20);
1137: close csr_pem_start_end_dates;
1138: fnd_message.set_name('PER','HR_289542_PJO_START_END_DATES');
1139: fnd_message.raise_error;
1140: end if;
1141: if csr_pem_start_end_dates%isopen then
1142: close csr_pem_start_end_dates;

Line 1139: fnd_message.raise_error;

1135: if csr_pem_start_end_dates%found then
1136: hr_utility.set_location(l_proc, 20);
1137: close csr_pem_start_end_dates;
1138: fnd_message.set_name('PER','HR_289542_PJO_START_END_DATES');
1139: fnd_message.raise_error;
1140: end if;
1141: if csr_pem_start_end_dates%isopen then
1142: close csr_pem_start_end_dates;
1143: end if;

Line 1233: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');

1229: fetch csr_pjo_assignments into l_previous_job_usage_id;
1230: if csr_pjo_assignments%found then
1231: hr_utility.set_location(l_proc, 30);
1232: close csr_pjo_assignments;
1233: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1234: hr_multi_message.add
1235: (p_associated_column1 => 'PER_PREVIOUS_JOBS.
1236: PREVIOUS_JOB_ID'
1237: );

Line 1245: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');

1241: end if;
1242: end if;
1243: else
1244: hr_utility.set_location(l_proc, 35);
1245: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1246: hr_multi_message.add
1247: (p_associated_column1 => 'PER_PREVIOUS_JOBS.PREVIOUS_JOB_ID'
1248: ,p_associated_column2 => 'PER_PREVIOUS_JOBS.ALL_ASSIGNMENTS'
1249: );