DBA Data[Home] [Help]

APPS.IRC_ISC_BUS dependencies on HR_MULTI_MESSAGE

Line 567: if hr_multi_message.exception_add

563: close csr_person_id;
564: hr_utility.set_location(' Leaving:'||l_proc,40);
565: exception
566: when app_exception.application_exception then
567: if hr_multi_message.exception_add
568: (p_associated_column1 =>
569: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
570: ) then
571: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 627: if hr_multi_message.exception_add

623: end if;
624: hr_utility.set_location(' Leaving:'||l_proc,40);
625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add
628: (p_associated_column1 =>
629: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
630: ) then
631: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 709: if hr_multi_message.exception_add

705: end if;
706: hr_utility.set_location(' Leaving:'||l_proc,60);
707: exception
708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 =>
711: 'IRC_SEARCH_CRITERIA.SEARCH_NAME'
712: ) then
713: hr_utility.set_location(' Leaving:'||l_proc,70);

Line 777: hr_multi_message.add

773: -- Check that distance_to_location is a valid positive number.
774: hr_utility.set_location(l_proc,40);
775: if p_distance_to_location < 0 then
776: fnd_message.set_name('PER','IRC_412010_BAD_DISTANCE_TO_LOC');
777: hr_multi_message.add
778: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
779: );
780: else
781: -- Check that location is a valid.

Line 785: hr_multi_message.add

781: -- Check that location is a valid.
782: hr_utility.set_location(l_proc,50);
783: if p_geocode_location is null then
784: fnd_message.set_name('PER','IRC_412011_BAD_LOCATION');
785: hr_multi_message.add
786: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOCODE_LOCATION'
787: );
788: end if;
789: end if;

Line 796: hr_multi_message.add

792: -- the distance to location is null - check that the geocode location is too
793: hr_utility.set_location(l_proc,60);
794: if p_geocode_location is not null then
795: fnd_message.set_name('PER','IRC_412164_NO_DISTANCE');
796: hr_multi_message.add
797: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
798: );
799: end if;
800: end if;

Line 866: hr_multi_message.add

862: fetch chk_loc into l_dummy;
863: if chk_loc%notfound then
864: close chk_loc;
865: fnd_message.set_name('PER','IRC_412165_BAD_LOCATION_ID');
866: hr_multi_message.add
867: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.LOCATION_ID'
868: );
869: else
870: close chk_loc;

Line 921: hr_multi_message.add

917: or (p_longitude is null and p_latitude is not null) then
918: --
919: hr_utility.set_location(l_proc,20);
920: fnd_message.set_name('PER','IRC_412166_LONG_LAT');
921: hr_multi_message.add
922: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOMETRY'
923: );
924: end if;
925: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 989: if hr_multi_message.exception_add

985: end if;
986: hr_utility.set_location(' Leaving:'||l_proc,50);
987: exception
988: when app_exception.application_exception then
989: if hr_multi_message.exception_add
990: (p_associated_column1 =>
991: 'IRC_SEARCH_CRITERIA.USE_FOR_MATCHING'
992: ) then
993: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1059: if hr_multi_message.exception_add

1055: end if;
1056: hr_utility.set_location(' Leaving:'||l_proc,50);
1057: exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 =>
1061: 'IRC_SEARCH_CRITERIA.MATCH_COMPETENCE'
1062: ) then
1063: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1130: if hr_multi_message.exception_add

1126: end if;
1127: hr_utility.set_location(' Leaving:'||l_proc,50);
1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'IRC_SEARCH_CRITERIA.MATCH_QUALIFICATION'
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1198: if hr_multi_message.exception_add

1194: close csr_vacancy_id;
1195: hr_utility.set_location(' Leaving:'||l_proc,40);
1196: exception
1197: when app_exception.application_exception then
1198: if hr_multi_message.exception_add
1199: (p_associated_column1 =>
1200: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
1201: ) then
1202: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 1279: if hr_multi_message.exception_add

1275: end if;
1276: hr_utility.set_location(' Leaving:'||l_proc,60);
1277: exception
1278: when app_exception.application_exception then
1279: if hr_multi_message.exception_add
1280: (p_associated_column1 =>
1281: 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1282: ) then
1283: hr_utility.set_location(' Leaving:'||l_proc,70);

Line 1331: if hr_multi_message.no_all_inclusive_error

1327: -- Only proceed with rank validation when multiple message list does not
1328: -- already contain an error associated with the min_qual_level or max_qual_level
1329: -- columns.
1330: hr_utility.set_location(l_proc,15);
1331: if hr_multi_message.no_all_inclusive_error
1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1334: ) then
1335: --

Line 1355: if hr_multi_message.exception_add

1351: end if;
1352: hr_utility.set_location('Leaving:'||l_proc,40);
1353: exception
1354: when app_exception.application_exception then
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1358: ) then
1359: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 1429: if hr_multi_message.exception_add

1425: end if;
1426: hr_utility.set_location(' Leaving:'||l_proc,50);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1431: ) then
1432: hr_utility.set_location(' Leaving:'||l_proc,60);
1433: raise;

Line 1485: if hr_multi_message.no_exclusive_error(

1481: --
1482: -- Only proceed with max_salary validation when multiple message list does not
1483: -- already contain an error associated with the min_salary columns.
1484: hr_utility.set_location(l_proc,15);
1485: if hr_multi_message.no_exclusive_error(
1486: p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1487: ) then
1488: if p_max_salary is not null then
1489: --

Line 1519: if hr_multi_message.exception_add

1515: -- which have been raised by this procedure. Transfer the error to the
1516: -- Multiple message list and associate the error with max_salary and
1517: -- min_salary
1518: when app_exception.application_exception then
1519: if hr_multi_message.exception_add
1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
1522: ) then
1523: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 1584: if hr_multi_message.exception_add

1580: end if;
1581: hr_utility.set_location(' Leaving:'||l_proc,40);
1582: exception
1583: when app_exception.application_exception then
1584: if hr_multi_message.exception_add
1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
1586: ) then
1587: hr_utility.set_location(' Leaving:'||l_proc,50);
1588: raise;

Line 1646: if hr_multi_message.exception_add

1642: end if;
1643: hr_utility.set_location(' Leaving:'||l_proc,40);
1644: exception
1645: when app_exception.application_exception then
1646: if hr_multi_message.exception_add
1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'
1648: ) then
1649: hr_utility.set_location(' Leaving:'||l_proc,50);
1650: raise;

Line 1720: if hr_multi_message.exception_add

1716: end if;
1717: hr_utility.set_location(' Leaving:'||l_proc,50);
1718: exception
1719: when app_exception.application_exception then
1720: if hr_multi_message.exception_add
1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'
1722: ) then
1723: hr_utility.set_location(' Leaving:'||l_proc,60);
1724: raise;

Line 1797: if hr_multi_message.exception_add

1793: end if;
1794: hr_utility.set_location(' Leaving:'||l_proc,50);
1795: exception
1796: when app_exception.application_exception then
1797: if hr_multi_message.exception_add
1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'
1799: ) then
1800: hr_utility.set_location(' Leaving:'||l_proc,60);
1801: raise;

Line 1874: if hr_multi_message.exception_add

1870: end if;
1871: hr_utility.set_location(' Leaving:'||l_proc,50);
1872: exception
1873: when app_exception.application_exception then
1874: if hr_multi_message.exception_add
1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'
1876: ) then
1877: hr_utility.set_location(' Leaving:'||l_proc,60);
1878: raise;

Line 1951: if hr_multi_message.exception_add

1947: end if;
1948: hr_utility.set_location(' Leaving:'||l_proc,50);
1949: exception
1950: when app_exception.application_exception then
1951: if hr_multi_message.exception_add
1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'
1953: ) then
1954: hr_utility.set_location(' Leaving:'||l_proc,60);
1955: raise;

Line 2048: if hr_multi_message.exception_add

2044: end if;
2045: hr_utility.set_location(' Leaving:'||l_proc,50);
2046: exception
2047: when app_exception.application_exception then
2048: if hr_multi_message.exception_add
2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'
2050: ) then
2051: hr_utility.set_location(' Leaving:'||l_proc,60);
2052: raise;

Line 2112: if hr_multi_message.no_all_inclusive_error

2108: -- Only proceed with max_salary validation when multiple message list does not
2109: -- already contain an error associated with the min_salary or max_salary
2110: -- columns.
2111: hr_utility.set_location(l_proc,15);
2112: if hr_multi_message.no_all_inclusive_error
2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2115: ) then
2116: --

Line 2169: if hr_multi_message.exception_add

2165: -- which have been raised by this procedure. Transfer the error to the
2166: -- Multiple message list and associate the error with max_salary,
2167: -- min_salary and salary_currency columns.
2168: when app_exception.application_exception then
2169: if hr_multi_message.exception_add
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'
2173: ) then

Line 2248: if hr_multi_message.exception_add

2244: end if;
2245: hr_utility.set_location(' Leaving:'||l_proc,50);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'
2250: ) then
2251: hr_utility.set_location(' Leaving:'||l_proc,60);
2252: raise;

Line 2299: hr_multi_message.add

2295: if p_employee = 'N' and p_contractor = 'N' then
2296: --
2297: hr_utility.set_location(l_proc,20);
2298: fnd_message.set_name('PER', 'IRC_412152_VAC_EMP_CON_WARN');
2299: hr_multi_message.add
2300: (p_message_type => hr_multi_message.g_warning_msg
2301: );
2302: --
2303: end if;

Line 2300: (p_message_type => hr_multi_message.g_warning_msg

2296: --
2297: hr_utility.set_location(l_proc,20);
2298: fnd_message.set_name('PER', 'IRC_412152_VAC_EMP_CON_WARN');
2299: hr_multi_message.add
2300: (p_message_type => hr_multi_message.g_warning_msg
2301: );
2302: --
2303: end if;
2304: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 2375: if hr_multi_message.exception_add

2371: --
2372: hr_utility.set_location(' Leaving:'||l_proc,50);
2373: exception
2374: when app_exception.application_exception then
2375: if hr_multi_message.exception_add
2376: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2377: ) then
2378: hr_utility.set_location(' Leaving:'||l_proc,60);
2379: raise;