DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on FND_MESSAGE

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

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

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

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

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

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

Line 82: fnd_message.raise_error;

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

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

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

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

82: fnd_message.raise_error;
83:
84: /*hr_utility.set_location(l_proc, 35);
85: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');
86: fnd_message.raise_error;*/-- Error msg changed Commented for bug 5686794
87:
88: end if;
89: end if;
90: --

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

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

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

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

Line 214: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 630: fnd_message.raise_error;

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

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

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

Line 766: fnd_message.raise_error;

762: if csr_person_id%notfound then
763: hr_utility.set_location(l_proc, 20);
764: close csr_person_id;
765: fnd_message.set_name('PER','HR_289535_PEM_VALID_PERSON_ID');
766: fnd_message.raise_error;
767: end if;
768: if csr_person_id%isopen then
769: close csr_person_id;
770: end if;

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

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

Line 779: fnd_message.raise_error;

775: if csr_effective_person_id%notfound then
776: hr_utility.set_location(l_proc, 30);
777: close csr_effective_person_id;
778: fnd_message.set_name('PER','HR_289547_PEM_DATE_PERSON_ID');
779: fnd_message.raise_error;
780: end if;
781: if csr_effective_person_id%isopen then
782: close csr_effective_person_id;
783: end if;

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

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

Line 862: fnd_message.raise_error;

858: if csr_party_id%notfound then
859: hr_utility.set_location(l_proc, 20);
860: close csr_party_id;
861: fnd_message.set_name('PER','HR_289536_PEM_VALID_PARTY_ID');
862: fnd_message.raise_error;
863: end if;
864: if csr_party_id%isopen then
865: close csr_party_id;
866: end if;

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

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

Line 946: fnd_message.raise_error;

942: if csr_employer_country%notfound then
943: hr_utility.set_location(l_proc, 20);
944: close csr_employer_country;
945: fnd_message.set_name('PER','HR_289531_PEM_VALD_EMPR_CNTRY');
946: fnd_message.raise_error;
947: end if;
948: if csr_employer_country%isopen then
949: close csr_employer_country;
950: end if;

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

1026: ,p_lookup_code => l_lookup_code
1027: );
1028: if l_no_lookup = true then
1029: hr_utility.set_location(l_proc, 20);
1030: fnd_message.set_name('PER','HR_289532_PEM_VALID_EMPR_TYPE');
1031: fnd_message.raise_error;
1032: end if;
1033: end if;
1034: end if;

Line 1031: fnd_message.raise_error;

1027: );
1028: if l_no_lookup = true then
1029: hr_utility.set_location(l_proc, 20);
1030: fnd_message.set_name('PER','HR_289532_PEM_VALID_EMPR_TYPE');
1031: fnd_message.raise_error;
1032: end if;
1033: end if;
1034: end if;
1035: --

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

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

Line 1133: fnd_message.raise_error;

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

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

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

Line 1143: fnd_message.raise_error;

1139: if csr_employer_subtype%notfound then
1140: hr_utility.set_location(l_proc, 30);
1141: close csr_employer_subtype;
1142: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1143: fnd_message.raise_error;
1144: end if;
1145: if csr_employer_subtype%isopen then
1146: close csr_employer_subtype;
1147: end if;

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

1224: CLOSE leg_code;
1225:
1226: IF NOT (l_leg_code = 'PL' AND p_employer_type = 'PARALLEL') THEN
1227: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1228: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');
1229: fnd_message.raise_error;
1230: END IF ;
1231: END IF;
1232: -- Bug 14316052

Line 1229: fnd_message.raise_error;

1225:
1226: IF NOT (l_leg_code = 'PL' AND p_employer_type = 'PARALLEL') THEN
1227: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1228: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');
1229: fnd_message.raise_error;
1230: END IF ;
1231: END IF;
1232: -- Bug 14316052
1233: hr_utility.set_location('Entering:'||l_proc, 6);

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

1250: (not l_api_updating)) then
1251: hr_utility.set_location(l_proc, 15);
1252: if p_start_date > p_end_date then
1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1256: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1257: fnd_message.raise_error;
1258: end if;

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

1251: hr_utility.set_location(l_proc, 15);
1252: if p_start_date > p_end_date then
1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1256: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1257: fnd_message.raise_error;
1258: end if;
1259: end if;

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

1252: if p_start_date > p_end_date then
1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1256: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1257: fnd_message.raise_error;
1258: end if;
1259: end if;
1260: end if;

Line 1257: fnd_message.raise_error;

1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1256: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1257: fnd_message.raise_error;
1258: end if;
1259: end if;
1260: end if;
1261: --

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

1324: (not l_api_updating)) then
1325: hr_utility.set_location(l_proc, 15);
1326: if p_period_years not between 0 and 99 then
1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);
1330: fnd_message.set_token('RANGE_END','99',true);
1331: fnd_message.raise_error;
1332: end if;

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

1325: hr_utility.set_location(l_proc, 15);
1326: if p_period_years not between 0 and 99 then
1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);
1330: fnd_message.set_token('RANGE_END','99',true);
1331: fnd_message.raise_error;
1332: end if;
1333: end if;

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

1326: if p_period_years not between 0 and 99 then
1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);
1330: fnd_message.set_token('RANGE_END','99',true);
1331: fnd_message.raise_error;
1332: end if;
1333: end if;
1334: end if;

Line 1331: fnd_message.raise_error;

1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);
1330: fnd_message.set_token('RANGE_END','99',true);
1331: fnd_message.raise_error;
1332: end if;
1333: end if;
1334: end if;
1335: --

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

1397: (not l_api_updating)) then
1398: hr_utility.set_location(l_proc, 15);
1399: if p_period_months not between 0 and 11 then
1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);
1403: fnd_message.set_token('RANGE_END','11',true);
1404: fnd_message.raise_error;
1405: end if;

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

1398: hr_utility.set_location(l_proc, 15);
1399: if p_period_months not between 0 and 11 then
1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);
1403: fnd_message.set_token('RANGE_END','11',true);
1404: fnd_message.raise_error;
1405: end if;
1406: end if;

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

1399: if p_period_months not between 0 and 11 then
1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);
1403: fnd_message.set_token('RANGE_END','11',true);
1404: fnd_message.raise_error;
1405: end if;
1406: end if;
1407: end if;

Line 1404: fnd_message.raise_error;

1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);
1403: fnd_message.set_token('RANGE_END','11',true);
1404: fnd_message.raise_error;
1405: end if;
1406: end if;
1407: end if;
1408: --

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

1470: (not l_api_updating)) then
1471: hr_utility.set_location(l_proc, 15);
1472: if p_period_days not between 0 and 365 then
1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);
1476: fnd_message.set_token('RANGE_END','365',true);
1477: fnd_message.raise_error;
1478: end if;

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

1471: hr_utility.set_location(l_proc, 15);
1472: if p_period_days not between 0 and 365 then
1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);
1476: fnd_message.set_token('RANGE_END','365',true);
1477: fnd_message.raise_error;
1478: end if;
1479: end if;

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

1472: if p_period_days not between 0 and 365 then
1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);
1476: fnd_message.set_token('RANGE_END','365',true);
1477: fnd_message.raise_error;
1478: end if;
1479: end if;
1480: end if;

Line 1477: fnd_message.raise_error;

1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);
1476: fnd_message.set_token('RANGE_END','365',true);
1477: fnd_message.raise_error;
1478: end if;
1479: end if;
1480: end if;
1481: --

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

1561: fetch csr_pem_assignments into l_previous_job_usage_id;
1562: if csr_pem_assignments%found then
1563: hr_utility.set_location(l_proc, 30);
1564: close csr_pem_assignments;
1565: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1566: hr_multi_message.add
1567: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'
1568: );
1569: end if;

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

1572: end if;
1573: end if;
1574: else
1575: hr_utility.set_location(l_proc, 35);
1576: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1577: hr_multi_message.add
1578: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1579: );
1580: end if;