eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_VAC_BUS dependencies on FND_MESSAGE

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

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1 => nvl(p_associated_column1,'VACANCY_ID'));
63: --
64: else

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

131: --
132: -- The primary key is invalid therefore we must error
133: --
134: close csr_leg_code;
135: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
136: fnd_message.raise_error;
137: end if;
138: hr_utility.set_location(l_proc,30);
139: --

Line 136: fnd_message.raise_error;

132: -- The primary key is invalid therefore we must error
133: --
134: close csr_leg_code;
135: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
136: fnd_message.raise_error;
137: end if;
138: hr_utility.set_location(l_proc,30);
139: --
140: -- Set the global variables so the values are

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

326: if not per_vac_shd.api_updating
327: (p_vacancy_id => p_rec.vacancy_id
328: ,p_object_version_number => p_rec.object_version_number
329: ) then
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE ', l_proc);
332: fnd_message.set_token('STEP ', '5');
333: fnd_message.raise_error;
334: end if;

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

327: (p_vacancy_id => p_rec.vacancy_id
328: ,p_object_version_number => p_rec.object_version_number
329: ) then
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE ', l_proc);
332: fnd_message.set_token('STEP ', '5');
333: fnd_message.raise_error;
334: end if;
335:

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

328: ,p_object_version_number => p_rec.object_version_number
329: ) then
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE ', l_proc);
332: fnd_message.set_token('STEP ', '5');
333: fnd_message.raise_error;
334: end if;
335:
336:

Line 333: fnd_message.raise_error;

329: ) then
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE ', l_proc);
332: fnd_message.set_token('STEP ', '5');
333: fnd_message.raise_error;
334: end if;
335:
336:
337: if per_vac_shd.g_old_rec.business_group_id <> p_rec.business_group_id

Line 419: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');

415: hr_utility.set_location(l_proc,20);
416: if (csr_name%found)
417: then
418: close csr_name;
419: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');
420: fnd_message.set_token('INFORMATION_TYPE','VACANCY');
421: fnd_message.raise_error;
422: end if;
423: close csr_name;

Line 420: fnd_message.set_token('INFORMATION_TYPE','VACANCY');

416: if (csr_name%found)
417: then
418: close csr_name;
419: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');
420: fnd_message.set_token('INFORMATION_TYPE','VACANCY');
421: fnd_message.raise_error;
422: end if;
423: close csr_name;
424: --

Line 421: fnd_message.raise_error;

417: then
418: close csr_name;
419: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');
420: fnd_message.set_token('INFORMATION_TYPE','VACANCY');
421: fnd_message.raise_error;
422: end if;
423: close csr_name;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 491: fnd_message.set_name('PER','PER_289443_VAC_DATE_FROM_MND');

487: --
488: hr_utility.set_location(l_proc,30);
489: if (p_date_from is null)
490: then
491: fnd_message.set_name('PER','PER_289443_VAC_DATE_FROM_MND');
492: hr_multi_message.add
493: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
494: );
495: hr_multi_message.end_validation_set();

Line 501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');

497: hr_utility.set_location(l_proc,40);
498: --
499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))
500: then
501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');
502: hr_multi_message.add
503: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
504: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_TO'
505: );

Line 570: fnd_message.set_name('PER','PER_289444_VAC_INV_STATUS_CODE');

566: ,p_status);
567: hr_utility.set_location(l_proc,30);
568: if (l_exists = true)
569: then
570: fnd_message.set_name('PER','PER_289444_VAC_INV_STATUS_CODE');
571: fnd_message.raise_error;
572: end if;
573: hr_utility.set_location(l_proc,30);
574: end if;

Line 571: fnd_message.raise_error;

567: hr_utility.set_location(l_proc,30);
568: if (l_exists = true)
569: then
570: fnd_message.set_name('PER','PER_289444_VAC_INV_STATUS_CODE');
571: fnd_message.raise_error;
572: end if;
573: hr_utility.set_location(l_proc,30);
574: end if;
575: end if;

Line 649: fnd_message.set_name('PER','PER_289445_VAC_INV_BUD_MST_TYP');

645: ,p_budget_measurement_type);
646: hr_utility.set_location(l_proc,30);
647: if (l_api_updating = true)
648: then
649: fnd_message.set_name('PER','PER_289445_VAC_INV_BUD_MST_TYP');
650: fnd_message.raise_error;
651: end if;
652: hr_utility.set_location(l_proc,40);
653: end if;

Line 650: fnd_message.raise_error;

646: hr_utility.set_location(l_proc,30);
647: if (l_api_updating = true)
648: then
649: fnd_message.set_name('PER','PER_289445_VAC_INV_BUD_MST_TYP');
650: fnd_message.raise_error;
651: end if;
652: hr_utility.set_location(l_proc,40);
653: end if;
654: end if;

Line 726: fnd_message.set_name('PER','PER_289446_VAC_INV_SEC_METHOD');

722: ,p_security_method);
723: hr_utility.set_location(l_proc,40);
724: if (l_api_updating = true)
725: then
726: fnd_message.set_name('PER','PER_289446_VAC_INV_SEC_METHOD');
727: fnd_message.raise_error;
728: end if;
729: hr_utility.set_location(l_proc,50);
730: end if;

Line 727: fnd_message.raise_error;

723: hr_utility.set_location(l_proc,40);
724: if (l_api_updating = true)
725: then
726: fnd_message.set_name('PER','PER_289446_VAC_INV_SEC_METHOD');
727: fnd_message.raise_error;
728: end if;
729: hr_utility.set_location(l_proc,50);
730: end if;
731: end if;

Line 789: fnd_message.set_name('PER','PER_289447_VAC_INV_REQ_ID');

785: open csr_requisition;
786: fetch csr_requisition into l_date_from,l_date_to;
787: if (csr_requisition%NOTFOUND) then
788: close csr_requisition;
789: fnd_message.set_name('PER','PER_289447_VAC_INV_REQ_ID');
790: hr_multi_message.add
791: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
792: );
793: else

Line 797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');

793: else
794: close csr_requisition;
795: hr_utility.set_location(l_proc,20);
796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then
797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
800: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
801: ,p_associated_column3 => 'PER_ALL_VACANCIES.DATE_TO'

Line 873: fnd_message.set_name('PER','PER_289449_VAC_INV_POS_ID');

869: open csr_valid_pos;
870: fetch csr_valid_pos into l_pos_bus_group_id;
871: if csr_valid_pos%notfound then
872: close csr_valid_pos;
873: fnd_message.set_name('PER','PER_289449_VAC_INV_POS_ID');
874: fnd_message.raise_error;
875: end if;
876: close csr_valid_pos;
877: hr_utility.set_location(l_proc, 40);

Line 874: fnd_message.raise_error;

870: fetch csr_valid_pos into l_pos_bus_group_id;
871: if csr_valid_pos%notfound then
872: close csr_valid_pos;
873: fnd_message.set_name('PER','PER_289449_VAC_INV_POS_ID');
874: fnd_message.raise_error;
875: end if;
876: close csr_valid_pos;
877: hr_utility.set_location(l_proc, 40);
878: --

Line 884: fnd_message.set_name('PAY', 'HR_51009_ASG_INVALID_BG_POS');

880: -- the business_group_id in HR_POSITIONS date effectively.
881: --
882: if l_pos_bus_group_id <> p_business_group_id then
883: --
884: fnd_message.set_name('PAY', 'HR_51009_ASG_INVALID_BG_POS');
885: fnd_message.raise_error;
886: --
887: end if;
888: hr_utility.set_location(l_proc, 50);

Line 885: fnd_message.raise_error;

881: --
882: if l_pos_bus_group_id <> p_business_group_id then
883: --
884: fnd_message.set_name('PAY', 'HR_51009_ASG_INVALID_BG_POS');
885: fnd_message.raise_error;
886: --
887: end if;
888: hr_utility.set_location(l_proc, 50);
889: --

Line 1053: fnd_message.set_name('PAY', 'HR_51055_ASG_INV_POS_ORG_COMB');

1049: open csr_valid_pos_org_comb;
1050: fetch csr_valid_pos_org_comb into l_exists;
1051: if csr_valid_pos_org_comb%notfound then
1052: close csr_valid_pos_org_comb;
1053: fnd_message.set_name('PAY', 'HR_51055_ASG_INV_POS_ORG_COMB');
1054: fnd_message.raise_error;
1055: end if;
1056: close csr_valid_pos_org_comb;
1057: --

Line 1054: fnd_message.raise_error;

1050: fetch csr_valid_pos_org_comb into l_exists;
1051: if csr_valid_pos_org_comb%notfound then
1052: close csr_valid_pos_org_comb;
1053: fnd_message.set_name('PAY', 'HR_51055_ASG_INV_POS_ORG_COMB');
1054: fnd_message.raise_error;
1055: end if;
1056: close csr_valid_pos_org_comb;
1057: --
1058: end if;

Line 1141: fnd_message.set_name('PAY', 'HR_51056_ASG_INV_POS_JOB_COMB');

1137: open csr_valid_pos_job_comb;
1138: fetch csr_valid_pos_job_comb into l_exists;
1139: if csr_valid_pos_job_comb%notfound then
1140: close csr_valid_pos_job_comb;
1141: fnd_message.set_name('PAY', 'HR_51056_ASG_INV_POS_JOB_COMB');
1142: fnd_message.raise_error;
1143: end if;
1144: close csr_valid_pos_job_comb;
1145: --

Line 1142: fnd_message.raise_error;

1138: fetch csr_valid_pos_job_comb into l_exists;
1139: if csr_valid_pos_job_comb%notfound then
1140: close csr_valid_pos_job_comb;
1141: fnd_message.set_name('PAY', 'HR_51056_ASG_INV_POS_JOB_COMB');
1142: fnd_message.raise_error;
1143: end if;
1144: close csr_valid_pos_job_comb;
1145: --
1146: elsif p_job_id is null and p_position_id is not null then

Line 1150: fnd_message.set_name('PAY', 'HR_51057_ASG_JOB_NULL_VALUE');

1146: elsif p_job_id is null and p_position_id is not null then
1147: --
1148: -- Position is not null but job is null
1149: --
1150: fnd_message.set_name('PAY', 'HR_51057_ASG_JOB_NULL_VALUE');
1151: fnd_message.raise_error;
1152: --
1153: end if;
1154: --

Line 1151: fnd_message.raise_error;

1147: --
1148: -- Position is not null but job is null
1149: --
1150: fnd_message.set_name('PAY', 'HR_51057_ASG_JOB_NULL_VALUE');
1151: fnd_message.raise_error;
1152: --
1153: end if;
1154: --
1155: end if;

Line 1238: fnd_message.set_name('PER','PER_289451_VAC_INV_JOB_ID');

1234: fetch csr_job into l_date_from,l_date_to;
1235: hr_utility.set_location(l_proc,30);
1236: if (csr_job%notfound) then
1237: close csr_job;
1238: fnd_message.set_name('PER','PER_289451_VAC_INV_JOB_ID');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1241: );
1242: else

Line 1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');

1243: close csr_job;
1244: hr_utility.set_location(l_proc,40);
1245: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1246: then
1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');
1248: hr_multi_message.add
1249: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1250: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1251: );

Line 1420: fnd_message.set_name('PER','PER_289453_VAC_INV_GRD_ID');

1416: hr_utility.set_location(l_proc,40);
1417: if (csr_grade%notfound)
1418: then
1419: close csr_grade;
1420: fnd_message.set_name('PER','PER_289453_VAC_INV_GRD_ID');
1421: hr_multi_message.add
1422: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1423: );
1424: else

Line 1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');

1425: close csr_grade;
1426: hr_utility.set_location(l_proc,50);
1427: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1428: then
1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');
1430: hr_multi_message.add
1431: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1432: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1433: );

Line 1509: fnd_message.set_name('PER','PER_289455_VAC_INV_ORG_ID');

1505: hr_utility.set_location(l_proc,30);
1506: if (csr_organization%notfound)
1507: then
1508: close csr_organization;
1509: fnd_message.set_name('PER','PER_289455_VAC_INV_ORG_ID');
1510: hr_multi_message.add
1511: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1512: );
1513: else

Line 1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');

1514: close csr_organization;
1515: hr_utility.set_location(l_proc,40);
1516: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1517: then
1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');
1519: hr_multi_message.add
1520: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1521: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1522: );

Line 1595: fnd_message.set_name('PER','PER_289457_VAC_INV_GRP_ID');

1591: hr_utility.set_location(l_proc,20);
1592: if (csr_peoplegrp%notfound)
1593: then
1594: close csr_peoplegrp;
1595: fnd_message.set_name('PER','PER_289457_VAC_INV_GRP_ID');
1596: hr_multi_message.add
1597: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1598: );
1599: else

Line 1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');

1600: close csr_peoplegrp;
1601: hr_utility.set_location(l_proc,30);
1602: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1603: then
1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');
1605: hr_multi_message.add
1606: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1607: ,p_associated_column2 => 'PER_ALL_VACANCIES.DATE_FROM'
1608: );

Line 1677: fnd_message.set_name('PER','PER_289459_VAC_INV_LOCATION_ID');

1673: hr_utility.set_location(l_proc,30);
1674: if (csr_location%notfound)
1675: then
1676: close csr_location;
1677: fnd_message.set_name('PER','PER_289459_VAC_INV_LOCATION_ID');
1678: fnd_message.raise_error;
1679: end if;
1680: close csr_location;
1681: end if;

Line 1678: fnd_message.raise_error;

1674: if (csr_location%notfound)
1675: then
1676: close csr_location;
1677: fnd_message.set_name('PER','PER_289459_VAC_INV_LOCATION_ID');
1678: fnd_message.raise_error;
1679: end if;
1680: close csr_location;
1681: end if;
1682: end if;

Line 1771: fnd_message.set_name('PER','PER_289460_VAC_INV_REC_ID');

1767: hr_utility.set_location(l_proc,30);
1768: if (csr_recruiter1%notfound)
1769: then
1770: close csr_recruiter1;
1771: fnd_message.set_name('PER','PER_289460_VAC_INV_REC_ID');
1772: hr_multi_message.add
1773: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'
1774: );
1775: else

Line 1785: fnd_message.set_name('PER','PER_289461_VAC_REC_ID_INV_DATE');

1781: hr_utility.set_location(l_proc,40);
1782: if (csr_recruiter2%notfound)
1783: then
1784: close csr_recruiter2;
1785: fnd_message.set_name('PER','PER_289461_VAC_REC_ID_INV_DATE');
1786: hr_multi_message.add
1787: (p_associated_column1 => 'PER_ALL_VACANCIES.RECRUITER_ID'
1788: );
1789: else

Line 1838: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');

1834: --
1835: hr_utility.set_location(l_proc,30);
1836: if (p_num_open <= 0)
1837: then
1838: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1839: fnd_message.raise_error;
1840: end if;
1841: --
1842: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 1839: fnd_message.raise_error;

1835: hr_utility.set_location(l_proc,30);
1836: if (p_num_open <= 0)
1837: then
1838: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1839: fnd_message.raise_error;
1840: end if;
1841: --
1842: hr_utility.set_location(' Leaving:'||l_proc,40);
1843: exception

Line 1896: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');

1892: --
1893: hr_utility.set_location(l_proc,20);
1894: if (p_bud_mea_val <= 0)
1895: then
1896: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1897: fnd_message.raise_error;
1898: end if;
1899: hr_utility.set_location(' Leaving:'||l_proc,30);
1900: exception

Line 1897: fnd_message.raise_error;

1893: hr_utility.set_location(l_proc,20);
1894: if (p_bud_mea_val <= 0)
1895: then
1896: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1897: fnd_message.raise_error;
1898: end if;
1899: hr_utility.set_location(' Leaving:'||l_proc,30);
1900: exception
1901: when app_exception.application_exception then

Line 1986: fnd_message.set_name('PER','PER_289464_VAC_INV_MGR_ID');

1982: hr_utility.set_location(l_proc,20);
1983: if (csr_manager1%notfound)
1984: then
1985: close csr_manager1;
1986: fnd_message.set_name('PER','PER_289464_VAC_INV_MGR_ID');
1987: hr_multi_message.add
1988: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
1989: );
1990: else

Line 1999: fnd_message.set_name('PER','PER_289465_VAC_MGR_ID_INV_DATE');

1995: hr_utility.set_location(l_proc,30);
1996: if (csr_manager2%notfound)
1997: then
1998: close csr_manager2;
1999: fnd_message.set_name('PER','PER_289465_VAC_MGR_ID_INV_DATE');
2000: hr_multi_message.add
2001: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
2002: );
2003: else

Line 2086: fnd_message.set_name('PER','IRC_VAC_MGR_EQUAL_APPL');

2082: hr_utility.set_location(l_proc,30);
2083: if (csr_manager%found)
2084: then
2085: close csr_manager;
2086: fnd_message.set_name('PER','IRC_VAC_MGR_EQUAL_APPL');
2087: hr_multi_message.add
2088: (p_associated_column1 => 'PER_ALL_VACANCIES.MANAGER_ID'
2089: );
2090: else

Line 2163: fnd_message.set_name('PER','PER_449565_VAC_INV_POSTING_ID');

2159: hr_utility.set_location(l_proc,30);
2160: if (csr_posting_contents%notfound)
2161: then
2162: close csr_posting_contents;
2163: fnd_message.set_name('PER','PER_449565_VAC_INV_POSTING_ID');
2164: hr_multi_message.add
2165: (p_associated_column1 => 'PER_ALL_VACANCIES.PRIMARY_POSTING_ID'
2166: );
2167: else

Line 2240: fnd_message.set_name('PER','PER_449566_VAC_INV_ASSESS_ID');

2236: hr_utility.set_location(l_proc,30);
2237: if (csr_assessments%notfound)
2238: then
2239: close csr_assessments;
2240: fnd_message.set_name('PER','PER_449566_VAC_INV_ASSESS_ID');
2241: hr_multi_message.add
2242: (p_associated_column1 => 'PER_ALL_VACANCIES.ASSESSMENT_ID'
2243: );
2244: else