DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on FND_MESSAGE

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

71: hr_utility.set_location(l_proc, 30);
72: else
73: /*Error message changed for the bug 5686794*/
74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:

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

72: else
73: /*Error message changed for the bug 5686794*/
74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);

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

73: /*Error message changed for the bug 5686794*/
74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);
81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');

Line 78: fnd_message.raise_error;

74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);
81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');
82: fnd_message.raise_error;*/-- Error msg changed & Commented for bug 5686794

Line 81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');

77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);
81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');
82: fnd_message.raise_error;*/-- Error msg changed & Commented for bug 5686794
83:
84: end if;
85: end if;

Line 82: fnd_message.raise_error;*/-- Error msg changed & Commented for bug 5686794

78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);
81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');
82: fnd_message.raise_error;*/-- Error msg changed & Commented for bug 5686794
83:
84: end if;
85: end if;
86: --

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

130: close csr_sec_grp;
131: --
132: -- The primary key is invalid therefore we must error
133: --
134: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
135: hr_multi_message.add
136: (p_associated_column1 => nvl(p_associated_column1,'PREVIOUS_EMPLOYER_ID')
137: );
138: else

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

205: --
206: -- The primary key is invalid therefore we must error
207: --
208: close csr_leg_code;
209: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
210: fnd_message.raise_error;
211: end if;
212: hr_utility.set_location(l_proc,30);
213: --

Line 210: fnd_message.raise_error;

206: -- The primary key is invalid therefore we must error
207: --
208: close csr_leg_code;
209: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
210: fnd_message.raise_error;
211: end if;
212: hr_utility.set_location(l_proc,30);
213: --
214: -- Set the global variables so the values are

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

619: IF NOT per_pem_shd.api_updating
620: (p_previous_employer_id => p_rec.previous_employer_id
621: ,p_object_version_number => p_rec.object_version_number
622: ) THEN
623: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE ', l_proc);
625: fnd_message.set_token('STEP ', '5');
626: fnd_message.raise_error;
627: END IF;

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

620: (p_previous_employer_id => p_rec.previous_employer_id
621: ,p_object_version_number => p_rec.object_version_number
622: ) THEN
623: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE ', l_proc);
625: fnd_message.set_token('STEP ', '5');
626: fnd_message.raise_error;
627: END IF;
628: --

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

621: ,p_object_version_number => p_rec.object_version_number
622: ) THEN
623: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE ', l_proc);
625: fnd_message.set_token('STEP ', '5');
626: fnd_message.raise_error;
627: END IF;
628: --
629: -- Add checks to ensure non-updateable args have

Line 626: fnd_message.raise_error;

622: ) THEN
623: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
624: fnd_message.set_token('PROCEDURE ', l_proc);
625: fnd_message.set_token('STEP ', '5');
626: fnd_message.raise_error;
627: END IF;
628: --
629: -- Add checks to ensure non-updateable args have
630: -- not been updated.

Line 761: fnd_message.set_name('PER','HR_289535_PEM_VALID_PERSON_ID');

757: fetch csr_person_id into l_person_id;
758: if csr_person_id%notfound then
759: hr_utility.set_location(l_proc, 20);
760: close csr_person_id;
761: fnd_message.set_name('PER','HR_289535_PEM_VALID_PERSON_ID');
762: fnd_message.raise_error;
763: end if;
764: if csr_person_id%isopen then
765: close csr_person_id;

Line 762: fnd_message.raise_error;

758: if csr_person_id%notfound then
759: hr_utility.set_location(l_proc, 20);
760: close csr_person_id;
761: fnd_message.set_name('PER','HR_289535_PEM_VALID_PERSON_ID');
762: fnd_message.raise_error;
763: end if;
764: if csr_person_id%isopen then
765: close csr_person_id;
766: end if;

Line 774: fnd_message.set_name('PER','HR_289547_PEM_DATE_PERSON_ID');

770: fetch csr_effective_person_id into l_person_id;
771: if csr_effective_person_id%notfound then
772: hr_utility.set_location(l_proc, 30);
773: close csr_effective_person_id;
774: fnd_message.set_name('PER','HR_289547_PEM_DATE_PERSON_ID');
775: fnd_message.raise_error;
776: end if;
777: if csr_effective_person_id%isopen then
778: close csr_effective_person_id;

Line 775: fnd_message.raise_error;

771: if csr_effective_person_id%notfound then
772: hr_utility.set_location(l_proc, 30);
773: close csr_effective_person_id;
774: fnd_message.set_name('PER','HR_289547_PEM_DATE_PERSON_ID');
775: fnd_message.raise_error;
776: end if;
777: if csr_effective_person_id%isopen then
778: close csr_effective_person_id;
779: end if;

Line 857: fnd_message.set_name('PER','HR_289536_PEM_VALID_PARTY_ID');

853: fetch csr_party_id into l_party_id;
854: if csr_party_id%notfound then
855: hr_utility.set_location(l_proc, 20);
856: close csr_party_id;
857: fnd_message.set_name('PER','HR_289536_PEM_VALID_PARTY_ID');
858: fnd_message.raise_error;
859: end if;
860: if csr_party_id%isopen then
861: close csr_party_id;

Line 858: fnd_message.raise_error;

854: if csr_party_id%notfound then
855: hr_utility.set_location(l_proc, 20);
856: close csr_party_id;
857: fnd_message.set_name('PER','HR_289536_PEM_VALID_PARTY_ID');
858: fnd_message.raise_error;
859: end if;
860: if csr_party_id%isopen then
861: close csr_party_id;
862: end if;

Line 941: fnd_message.set_name('PER','HR_289531_PEM_VALD_EMPR_CNTRY');

937: fetch csr_employer_country into l_employer_country;
938: if csr_employer_country%notfound then
939: hr_utility.set_location(l_proc, 20);
940: close csr_employer_country;
941: fnd_message.set_name('PER','HR_289531_PEM_VALD_EMPR_CNTRY');
942: fnd_message.raise_error;
943: end if;
944: if csr_employer_country%isopen then
945: close csr_employer_country;

Line 942: fnd_message.raise_error;

938: if csr_employer_country%notfound then
939: hr_utility.set_location(l_proc, 20);
940: close csr_employer_country;
941: fnd_message.set_name('PER','HR_289531_PEM_VALD_EMPR_CNTRY');
942: fnd_message.raise_error;
943: end if;
944: if csr_employer_country%isopen then
945: close csr_employer_country;
946: end if;

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

1022: ,p_lookup_code => l_lookup_code
1023: );
1024: if l_no_lookup = true then
1025: hr_utility.set_location(l_proc, 20);
1026: fnd_message.set_name('PER','HR_289532_PEM_VALID_EMPR_TYPE');
1027: fnd_message.raise_error;
1028: end if;
1029: end if;
1030: end if;

Line 1027: fnd_message.raise_error;

1023: );
1024: if l_no_lookup = true then
1025: hr_utility.set_location(l_proc, 20);
1026: fnd_message.set_name('PER','HR_289532_PEM_VALID_EMPR_TYPE');
1027: fnd_message.raise_error;
1028: end if;
1029: end if;
1030: end if;
1031: --

Line 1128: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');

1124: ,p_lookup_code => l_lookup_code
1125: );
1126: if l_no_lookup = true then
1127: hr_utility.set_location(l_proc, 20);
1128: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1129: fnd_message.raise_error;
1130: end if;
1131: -- Check for the dependency on employer type
1132: hr_utility.set_location(l_proc, 25);

Line 1129: fnd_message.raise_error;

1125: );
1126: if l_no_lookup = true then
1127: hr_utility.set_location(l_proc, 20);
1128: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1129: fnd_message.raise_error;
1130: end if;
1131: -- Check for the dependency on employer type
1132: hr_utility.set_location(l_proc, 25);
1133: open csr_employer_subtype;

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

1134: fetch csr_employer_subtype into l_employer_subtype;
1135: if csr_employer_subtype%notfound then
1136: hr_utility.set_location(l_proc, 30);
1137: close csr_employer_subtype;
1138: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1139: fnd_message.raise_error;
1140: end if;
1141: if csr_employer_subtype%isopen then
1142: close csr_employer_subtype;

Line 1139: fnd_message.raise_error;

1135: if csr_employer_subtype%notfound then
1136: hr_utility.set_location(l_proc, 30);
1137: close csr_employer_subtype;
1138: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1139: fnd_message.raise_error;
1140: end if;
1141: if csr_employer_subtype%isopen then
1142: close csr_employer_subtype;
1143: end if;

Line 1206: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');

1202: --
1203: -- This If condition added for bug 7112425
1204:
1205: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1206: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');
1207: fnd_message.raise_error;
1208: END IF ;
1209: hr_utility.set_location('Entering:'||l_proc, 6);
1210:

Line 1207: fnd_message.raise_error;

1203: -- This If condition added for bug 7112425
1204:
1205: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1206: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');
1207: fnd_message.raise_error;
1208: END IF ;
1209: hr_utility.set_location('Entering:'||l_proc, 6);
1210:
1211: if p_start_date is not null and p_end_date is not null then

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

1226: (not l_api_updating)) then
1227: hr_utility.set_location(l_proc, 15);
1228: if p_start_date > p_end_date then
1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1232: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1233: fnd_message.raise_error;
1234: end if;

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

1227: hr_utility.set_location(l_proc, 15);
1228: if p_start_date > p_end_date then
1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1232: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1233: fnd_message.raise_error;
1234: end if;
1235: end if;

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

1228: if p_start_date > p_end_date then
1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1232: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1233: fnd_message.raise_error;
1234: end if;
1235: end if;
1236: end if;

Line 1233: fnd_message.raise_error;

1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1232: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1233: fnd_message.raise_error;
1234: end if;
1235: end if;
1236: end if;
1237: --

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

1300: (not l_api_updating)) then
1301: hr_utility.set_location(l_proc, 15);
1302: if p_period_years not between 0 and 99 then
1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);
1306: fnd_message.set_token('RANGE_END','99',true);
1307: fnd_message.raise_error;
1308: end if;

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

1301: hr_utility.set_location(l_proc, 15);
1302: if p_period_years not between 0 and 99 then
1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);
1306: fnd_message.set_token('RANGE_END','99',true);
1307: fnd_message.raise_error;
1308: end if;
1309: end if;

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

1302: if p_period_years not between 0 and 99 then
1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);
1306: fnd_message.set_token('RANGE_END','99',true);
1307: fnd_message.raise_error;
1308: end if;
1309: end if;
1310: end if;

Line 1307: fnd_message.raise_error;

1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);
1306: fnd_message.set_token('RANGE_END','99',true);
1307: fnd_message.raise_error;
1308: end if;
1309: end if;
1310: end if;
1311: --

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

1373: (not l_api_updating)) then
1374: hr_utility.set_location(l_proc, 15);
1375: if p_period_months not between 0 and 11 then
1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);
1379: fnd_message.set_token('RANGE_END','11',true);
1380: fnd_message.raise_error;
1381: end if;

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

1374: hr_utility.set_location(l_proc, 15);
1375: if p_period_months not between 0 and 11 then
1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);
1379: fnd_message.set_token('RANGE_END','11',true);
1380: fnd_message.raise_error;
1381: end if;
1382: end if;

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

1375: if p_period_months not between 0 and 11 then
1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);
1379: fnd_message.set_token('RANGE_END','11',true);
1380: fnd_message.raise_error;
1381: end if;
1382: end if;
1383: end if;

Line 1380: fnd_message.raise_error;

1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);
1379: fnd_message.set_token('RANGE_END','11',true);
1380: fnd_message.raise_error;
1381: end if;
1382: end if;
1383: end if;
1384: --

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

1446: (not l_api_updating)) then
1447: hr_utility.set_location(l_proc, 15);
1448: if p_period_days not between 0 and 365 then
1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);
1452: fnd_message.set_token('RANGE_END','365',true);
1453: fnd_message.raise_error;
1454: end if;

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

1447: hr_utility.set_location(l_proc, 15);
1448: if p_period_days not between 0 and 365 then
1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);
1452: fnd_message.set_token('RANGE_END','365',true);
1453: fnd_message.raise_error;
1454: end if;
1455: end if;

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

1448: if p_period_days not between 0 and 365 then
1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);
1452: fnd_message.set_token('RANGE_END','365',true);
1453: fnd_message.raise_error;
1454: end if;
1455: end if;
1456: end if;

Line 1453: fnd_message.raise_error;

1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);
1452: fnd_message.set_token('RANGE_END','365',true);
1453: fnd_message.raise_error;
1454: end if;
1455: end if;
1456: end if;
1457: --

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

1537: fetch csr_pem_assignments into l_previous_job_usage_id;
1538: if csr_pem_assignments%found then
1539: hr_utility.set_location(l_proc, 30);
1540: close csr_pem_assignments;
1541: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1542: hr_multi_message.add
1543: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'
1544: );
1545: end if;

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

1548: end if;
1549: end if;
1550: else
1551: hr_utility.set_location(l_proc, 35);
1552: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1553: hr_multi_message.add
1554: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1555: );
1556: end if;