DBA Data[Home] [Help]

APPS.PER_VAC_BUS dependencies on HR_MULTI_MESSAGE

Line 61: hr_multi_message.add

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
65: close csr_sec_grp;

Line 428: if hr_multi_message.exception_add

424: --
425: hr_utility.set_location(' Leaving:'||l_proc,30);
426: exception
427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PER_ALL_VACANCIES.NAME'
430: ) then
431: hr_utility.set_location(' Leaving:'|| l_proc, 40);
432: raise;

Line 492: hr_multi_message.add

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();
496: end if;

Line 495: hr_multi_message.end_validation_set();

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();
496: end if;
497: hr_utility.set_location(l_proc,40);
498: --
499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))

Line 502: hr_multi_message.add

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: );
506: end if;

Line 580: if hr_multi_message.exception_add

576: --
577: hr_utility.set_location(' Leaving:'||l_proc,40);
578: exception
579: when app_exception.application_exception then
580: if hr_multi_message.exception_add
581: (p_associated_column1 => 'PER_ALL_VACANCIES.STATUS'
582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;

Line 659: if hr_multi_message.exception_add

655: --
656: hr_utility.set_location(' Leaving:'||l_proc,50);
657: exception
658: when app_exception.application_exception then
659: if hr_multi_message.exception_add
660: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_TYPE'
661: ) then
662: hr_utility.set_location(' Leaving:'|| l_proc, 60);
663: raise;

Line 735: if hr_multi_message.exception_add

731: end if;
732: hr_utility.set_location(' Leaving:'||l_proc,60);
733: exception
734: when app_exception.application_exception then
735: if hr_multi_message.exception_add
736: (p_associated_column1 => 'PER_ALL_VACANCIES.SECURITY_METHOD'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 70);
739: raise;

Line 790: hr_multi_message.add

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
794: close csr_requisition;

Line 798: hr_multi_message.add

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'
802: );

Line 897: if hr_multi_message.exception_add

893: --
894: hr_utility.set_location('Leaving'||l_proc, 80);
895: exception
896: when app_exception.application_exception then
897: if hr_multi_message.exception_add
898: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
899: ) then
900: hr_utility.set_location(' Leaving:'|| l_proc, 40);
901: raise;

Line 935: if hr_multi_message.no_exclusive_error

931: --
932: begin
933: --
934: hr_utility.set_location('Entering:'|| l_proc, 1);
935: if hr_multi_message.no_exclusive_error
936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
939: ) then

Line 1015: if hr_multi_message.no_exclusive_error

1011: --
1012: begin
1013: --
1014: hr_utility.set_location('Entering:'|| l_proc, 1);
1015: if hr_multi_message.no_exclusive_error
1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1019: ) then

Line 1065: if hr_multi_message.exception_add

1061: end if;
1062: hr_utility.set_location('Leaving'||l_proc, 4);
1063: exception
1064: when app_exception.application_exception then
1065: if hr_multi_message.exception_add
1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1067: ,p_associated_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1068: ) then
1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 1103: if hr_multi_message.no_exclusive_error

1099: and hp.job_id = p_job_id;
1100: --
1101: begin
1102: hr_utility.set_location('Entering:'|| l_proc, 10);
1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'
1107: ) then

Line 1161: if hr_multi_message.exception_add

1157: --
1158: hr_utility.set_location('Leaving'||l_proc, 3);
1159: exception
1160: when app_exception.application_exception then
1161: if hr_multi_message.exception_add
1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1163: ,p_associated_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1164: ) then
1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 1239: hr_multi_message.add

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
1243: close csr_job;

Line 1248: hr_multi_message.add

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: );
1252: end if;

Line 1290: if hr_multi_message.no_exclusive_error

1286: and nvl(date_to, hr_api.g_eot);
1287: --
1288: begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1292: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1293: ) then
1294: --

Line 1342: if hr_multi_message.exception_add

1338: --
1339: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1340: exception
1341: when app_exception.application_exception then
1342: if hr_multi_message.exception_add
1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1344: ,p_associated_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1345: ) then
1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);

Line 1421: hr_multi_message.add

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
1425: close csr_grade;

Line 1430: hr_multi_message.add

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: );
1434: end if;

Line 1510: hr_multi_message.add

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
1514: close csr_organization;

Line 1519: hr_multi_message.add

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: );
1523: end if;

Line 1596: hr_multi_message.add

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
1600: close csr_peoplegrp;

Line 1605: hr_multi_message.add

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: );
1609: end if;

Line 1686: if hr_multi_message.exception_add

1682: end if;
1683: hr_utility.set_location(' Leaving:'||l_proc,40);
1684: exception
1685: when app_exception.application_exception then
1686: if hr_multi_message.exception_add
1687: (p_associated_column1 => 'PER_ALL_VACANCIES.LOCATION_ID'
1688: ) then
1689: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1690: raise;

Line 1772: hr_multi_message.add

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
1776: close csr_recruiter1;

Line 1786: hr_multi_message.add

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
1790: close csr_recruiter2;

Line 1845: if hr_multi_message.exception_add

1841: --
1842: hr_utility.set_location(' Leaving:'||l_proc,40);
1843: exception
1844: when app_exception.application_exception then
1845: if hr_multi_message.exception_add
1846: (p_associated_column1 => 'PER_ALL_VACANCIES.NUMBER_OF_OPENINGS'
1847: ) then
1848: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1849: raise;

Line 1902: if hr_multi_message.exception_add

1898: end if;
1899: hr_utility.set_location(' Leaving:'||l_proc,30);
1900: exception
1901: when app_exception.application_exception then
1902: if hr_multi_message.exception_add
1903: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_VALUE'
1904: ) then
1905: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1906: raise;

Line 1987: hr_multi_message.add

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
1991: close csr_manager1;

Line 2000: hr_multi_message.add

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
2004: close csr_manager2;

Line 2087: hr_multi_message.add

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
2091: close csr_manager;

Line 2164: hr_multi_message.add

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
2168: close csr_posting_contents;

Line 2241: hr_multi_message.add

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
2245: close csr_assessments;

Line 2284: hr_multi_message.end_validation_set();

2280: ,p_date_from => p_rec.date_from
2281: ,p_date_to => p_rec.date_to
2282: );
2283: --
2284: hr_multi_message.end_validation_set();
2285: --
2286: hr_utility.set_location(l_proc, 20);
2287: --
2288: chk_name