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_QUA_BUS dependencies on HR_MULTI_MESSAGE

Line 59: hr_multi_message.add

55: --
56: -- The primary key is invalid therefore we must error
57: --
58: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
59: hr_multi_message.add
60: (p_associated_column1 => nvl(p_associated_column1, 'QUALIFICATION_ID')
61: );
62: else
63: close csr_sec_grp;

Line 370: hr_multi_message.add

366: --or ((p_person_id is not null or p_party_id is not null)
367: --and p_attendance_id is not null)) then
368: --
369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');
370: hr_multi_message.add
371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
374: );

Line 391: hr_multi_message.add

387: if c1%notfound then
388: --
389: close c1;
390: hr_utility.set_message(801,'HR_51834_QUA_PER_ID_INV');
391: hr_multi_message.add
392: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
393: );
394: --
395: else

Line 504: if hr_multi_message.no_all_inclusive_error

500: hr_utility.set_location('Entering:'|| l_proc, 1);
501: --
502: --
503: if p_rec.person_id is not null then
504: if hr_multi_message.no_all_inclusive_error
505: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
506: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
507: ) then
508: open csr_get_party_id;

Line 516: hr_multi_message.add

512: if p_rec.party_id is not null then
513: if p_rec.party_id <> nvl(l_party_id,-1) then
514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);
516: hr_multi_message.add
517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
519: );
520: end if;

Line 531: if hr_multi_message.no_all_inclusive_error

527: end if;
528: end if; --end if for no_all_inclusive_error
529: else
530: if p_rec.attendance_id is not null then
531: if hr_multi_message.no_all_inclusive_error
532: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
533: ,p_check_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
534: ) then
535: open csr_attendances;

Line 543: hr_multi_message.add

539: if p_rec.party_id is not null then
540: if p_rec.party_id <> l_party_id then
541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);
543: hr_multi_message.add
544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
546: );
547: end if;

Line 562: hr_multi_message.add

558: if p_rec.party_id is null then
559: /* chk_person_id ensures that this does not occur*/
560: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
566: );

Line 574: hr_multi_message.add

570: if csr_valid_party_id%notfound then
571: close csr_valid_party_id;
572: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
573: hr_utility.set_location(l_proc,100);
574: hr_multi_message.add
575: (p_associated_column1 => 'PER_QUALIFICATIONS.PARTY_ID'
576: );
577: else
578: close csr_valid_party_id;

Line 657: if hr_multi_message.exception_add

653: hr_utility.set_location('Leaving:'||l_proc,10);
654: --
655: exception
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_QUALIFICATIONS.STATUS'
659: ) then
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 844: if hr_multi_message.exception_add

840: hr_utility.set_location('Leaving:'||l_proc,10);
841: --
842: exception
843: when app_exception.application_exception then
844: if hr_multi_message.exception_add
845: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
846: ,p_associated_column2 => 'PER_QUALIFICATIONS.AWARDED_DATE'
847: ) then
848: --

Line 927: hr_multi_message.add

923: -- raise error as fee or fee currency has been set without the other
924: -- having been set.
925: --
926: hr_utility.set_message(801,'HR_51840_QUA_FEE_CURRENCY');
927: hr_multi_message.add
928: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE'
929: ,p_associated_column2 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
930: );
931: --

Line 949: hr_multi_message.add

945: --
946: close c1;
947: hr_utility.set_message(801,'HR_51855_QUA_CCY_INV');
948: --
949: hr_multi_message.add
950: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
951: );
952: else
953: --

Line 1110: if hr_multi_message.no_all_inclusive_error

1106: --
1107: if ((p_start_date is not null
1108: or p_end_date is not null)
1109: and p_attendance_id is not null) then
1110: if hr_multi_message.no_all_inclusive_error
1111: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1112: ) then
1113: --
1114: -- Only carry out test on establishment attendance dates if attendance_id

Line 1127: hr_multi_message.add

1123: -- the dates of the establishment attendance.
1124: --
1125: close c1;
1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');
1127: hr_multi_message.add
1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1131: );

Line 1139: end if; -- hr_multi_message.no_all_inc_error

1135: close c1;
1136: --
1137: end if; -- c1 not found
1138: --
1139: end if; -- hr_multi_message.no_all_inc_error
1140: --
1141: end if; -- start_date/end_date is not null and att_id is not null
1142: --
1143: -- WWBUG 2502284 drove this.

Line 1164: hr_multi_message.add

1160: -- not bounded by the qualification record.
1161: --
1162: close c2;
1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1164: hr_multi_message.add
1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1168: );

Line 1249: hr_multi_message.add

1245: --
1246: close c1;
1247:
1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1249: hr_multi_message.add
1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'
1253: );

Line 1304: if hr_multi_message.no_all_inclusive_error

1300: Begin
1301: --
1302: hr_utility.set_location('Entering:'||l_proc,5);
1303: --
1304: if hr_multi_message.no_all_inclusive_error
1305: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
1306: ) then
1307: l_api_updating := per_qua_shd.api_updating
1308: (p_qualification_id => p_qualification_id,

Line 1341: if hr_multi_message.exception_add

1337: hr_utility.set_location('Leaving:'||l_proc,10);
1338: --
1339: exception
1340: when app_exception.application_exception then
1341: if hr_multi_message.exception_add
1342: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
1343: ,p_associated_column2 => 'PER_QUALIFICATIONS.PROJECTED_COMPLETION_DATE'
1344: ) then
1345: --

Line 1424: if hr_multi_message.exception_add

1420: hr_utility.set_location('Leaving:'||l_proc,10);
1421: --
1422: exception
1423: when app_exception.application_exception then
1424: if hr_multi_message.exception_add
1425: (p_associated_column1 => 'PER_QUALIFICATIONS.TUITION_METHOD'
1426: ) then
1427: --
1428: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 1483: if hr_multi_message.no_all_inclusive_error

1479: Begin
1480: --
1481: hr_utility.set_location('Entering:'||l_proc,5);
1482: --
1483: if hr_multi_message.no_all_inclusive_error
1484: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1485: ) then
1486: --
1487: l_api_updating := per_qua_shd.api_updating

Line 1529: if hr_multi_message.exception_add

1525: hr_utility.set_location('Leaving:'||l_proc,10);
1526: --
1527: exception
1528: when app_exception.application_exception then
1529: if hr_multi_message.exception_add
1530: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1531: ) then
1532: --
1533: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 1594: if hr_multi_message.no_all_inclusive_error

1590: Begin
1591: --
1592: hr_utility.set_location('Entering:'||l_proc,5);
1593: --
1594: if hr_multi_message.no_all_inclusive_error
1595: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1596: ) then
1597: --
1598: l_api_updating := per_qua_shd.api_updating

Line 1651: if hr_multi_message.exception_add

1647: hr_utility.set_location('Leaving:'||l_proc,10);
1648: --
1649: exception
1650: when app_exception.application_exception then
1651: if hr_multi_message.exception_add
1652: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1653: ) then
1654: --
1655: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 1703: if hr_multi_message.no_all_inclusive_error

1699: Begin
1700: --
1701: hr_utility.set_location('Entering:'||l_proc,5);
1702: --
1703: if hr_multi_message.no_all_inclusive_error
1704: (p_check_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1705: ) then
1706: --
1707: -- check if referenced records exist in the PER_SUBJECTS_TAKEN table.

Line 1730: if hr_multi_message.exception_add

1726: hr_utility.set_location('Leaving:'||l_proc,10);
1727: --
1728: exception
1729: when app_exception.application_exception then
1730: if hr_multi_message.exception_add
1731: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1732: ) then
1733: --
1734: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 2114: hr_multi_message.end_validation_set;

2110: -- After validating the set of important attributes,
2111: -- if Multiple Message Detection is enabled and at least
2112: -- one error has been found then abort further validation.
2113: --
2114: hr_multi_message.end_validation_set;
2115: --
2116: --
2117: -- Business Rule Mapping
2118: -- =====================

Line 2292: hr_multi_message.end_validation_set;

2288: -- After validating the set of important attributes,
2289: -- if Multiple Message Detection is enabled and at least
2290: -- one error has been found then abort further validation.
2291: --
2292: hr_multi_message.end_validation_set;
2293: --
2294: --
2295: -- Business Rule Mapping
2296: -- =====================