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

Line 281: hr_multi_message.add

277: ) then
278: -- Error: Invalid certification_method
279: hr_utility.set_location(l_proc, 10);
280: hr_utility.set_message(801,'HR_51635_CEL_MANDATORY_INVL');
281: hr_multi_message.add
282: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.MANDATORY');
283:
284: hr_utility.raise_error;
285: end if;

Line 294: if hr_multi_message.exception_add

290: --
291: hr_utility.set_location(' Leaving:'|| l_proc, 15);
292: exception
293: when app_exception.application_exception then
294: if hr_multi_message.exception_add
295: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.MANDATORY'
296: ) then
297: hr_utility.set_location(' Leaving:'||l_proc,20);
298: raise;

Line 386: hr_multi_message.add

382: ) then
383: -- Error: Invalid certification_method
384: hr_utility.set_location(l_proc, 10);
385: hr_utility.set_message(801,'HR_51636_CEL_CERTIF_INVL');
386: hr_multi_message.add
387: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD');
388: hr_utility.raise_error;
389: end if;
390: --

Line 398: if hr_multi_message.exception_add

394: --
395: hr_utility.set_location(' Leaving:'|| l_proc, 15);
396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add
399: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
400: ) then
401: hr_utility.set_location(' Leaving:'||l_proc,20);
402: raise;

Line 459: if hr_multi_message.no_exclusive_error

455: hr_utility.set_location('Entering:'|| l_proc, 1);
456: -- Only proceed with certification method/certification_date validation
457: -- when the multi message list does not already contain an error
458: -- associated with the certification_method.
459: if hr_multi_message.no_exclusive_error
460: ( p_check_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
461: ) then
462: --
463: -- Only proceed with validation if :

Line 489: hr_multi_message.add

485: hr_utility.set_location(l_proc,10);
486: hr_utility.set_message(801,'HR_51637_CEL_CERF_DATE_METHOD');
487:
488: -- Issue with Error not coming up
489: hr_multi_message.add
490: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE'
491: -- ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
492: );
493:

Line 504: hr_multi_message.add

500: then
501: hr_utility.set_location(l_proc, 20);
502: hr_utility.set_message(801,'HR_51629_CEL_CERF_METHOD_DATE');
503: -- Issue with Error not coming up
504: hr_multi_message.add
505: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
506: -- ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE'
507: );
508:

Line 517: if hr_multi_message.exception_add

513: end if;
514: end if;
515: exception
516: when app_exception.application_exception then
517: if hr_multi_message.exception_add
518: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
519: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE'
520: ) then
521: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 579: if hr_multi_message.no_all_inclusive_error

575:
576: begin
577: hr_utility.set_location('Entering:'||l_proc, 1);
578: --
579: if hr_multi_message.no_all_inclusive_error
580: ( p_check_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE' ) then
581: --
582: -- Only Proceed if the value for g_old_rec is current
583: -- and the value for the certification method has changed

Line 609: hr_multi_message.add

605: p_next_certification_date <= p_certification_date)) THEN
606: --
607: hr_utility.set_location(l_proc,10);
608: hr_utility.set_message(800,'PER_52861_CHK_NEXT_CERT_DATE');
609: hr_multi_message.add
610: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.NEXT_CERTIFICATION_DATE');
611: hr_utility.raise_error;
612: end if;
613: -- Added the code for fix of #731089

Line 618: hr_multi_message.add

614: if p_next_certification_date is not null then
615: if p_next_certification_date < p_effective_date_from THEN
616: hr_utility.set_location(l_proc,12);
617: hr_utility.set_message(800,'PER_289487_CEL_CERT_REV_DATE');
618: hr_multi_message.add
619: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.NEXT_CERTIFICATION_DATE');
620: hr_utility.raise_error;
621: end if;
622: end if;

Line 632: if hr_multi_message.exception_add

628: --
629: hr_utility.set_location('Leaving:'||l_proc,15);
630: exception
631: when app_exception.application_exception then
632: if hr_multi_message.exception_add
633: (p_associated_column1 =>
634: 'PER_COMPETENCE_ELEMENTS.NEXT_CERTIFICATION_DATE'
635: ,p_associated_column2 =>
636: 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE'

Line 727: hr_multi_message.add

723: ) then
724: -- Error: Invalid competence_type
725: hr_utility.set_location(l_proc, 10);
726: hr_utility.set_message(801,'HR_51638_CEL_COMP_TYPE_INVL');
727: hr_multi_message.add
728: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_TYPE');
729:
730: hr_utility.raise_error;
731: end if;

Line 740: if hr_multi_message.exception_add

736: --
737: hr_utility.set_location(' Leaving:'|| l_proc, 15);
738: exception
739: when app_exception.application_exception then
740: if hr_multi_message.exception_add
741: (p_associated_column1 =>
742: 'PER_COMPETENCE_ELEMENTS.COMPETENCE_TYPE'
743: ) then
744: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 837: hr_multi_message.add

833: -- Error: Invalid source_of_proficiency
834:
835: hr_utility.set_location(l_proc, 10);
836: hr_utility.set_message(801,'HR_51639_CEL_SOURCE_PROF_INVL');
837: hr_multi_message.add
838: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.SOURCE_OF_PROFICIENCY_LEVEL');
839:
840: hr_utility.raise_error;
841: end if;

Line 850: if hr_multi_message.exception_add

846: --
847: hr_utility.set_location(' Leaving:'|| l_proc, 15);
848: exception
849: when app_exception.application_exception then
850: if hr_multi_message.exception_add
851: (p_associated_column1 =>
852: 'PER_COMPETENCE_ELEMENTS.SOURCE_OF_PROFICIENCY_LEVEL'
853: ) then
854: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 946: hr_multi_message.add

942:
943: -- Error: Invalid competence_type
944: hr_utility.set_location(l_proc, 10);
945: hr_utility.set_message(801,'HR_51641_CEL_COMP_ELTP_INVL');
946: hr_multi_message.add
947: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_TYPE');
948: hr_utility.raise_error;
949:
950: end if;

Line 959: if hr_multi_message.exception_add

955: --
956: hr_utility.set_location(' Leaving:'|| l_proc, 15);
957: exception
958: when app_exception.application_exception then
959: if hr_multi_message.exception_add
960: (p_associated_column1 =>
961: 'PER_COMPETENCE_ELEMENTS.TYPE'
962: ) then
963: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1369: hr_multi_message.add

1365:
1366: if csr_valid_activity_id%notfound then
1367: hr_utility.set_location(l_proc, 45);
1368: hr_utility.set_message(801,'HR_51701_CEL_ACTIVE_ID_INVL');
1369: hr_multi_message.add
1370: (p_associated_column1 =>
1371: 'PER_COMPETENCE_ELEMENTS.ACTIVITY_VERSION_ID'
1372: );
1373: close csr_valid_activity_id;

Line 1389: hr_multi_message.add

1385: --
1386: -- The activity_version is not date valid
1387: --
1388: hr_utility.set_message(810,'OTA_13673_TAV_COMPETENCY_DATES');
1389: hr_multi_message.add
1390: (p_associated_column1 =>
1391: 'PER_COMPETENCE_ELEMENTS.ACTIVITY_VERSION_ID'
1392: ,p_associated_column2 =>
1393: 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'

Line 1448: hr_multi_message.add

1444: hr_utility.set_location(l_proc, 82);
1445: close csr_valid_grade_id;
1446: hr_utility.set_message(800, 'HR_52372_CEL_INVL_GRD_ID');
1447: hr_utility.set_location(l_proc,83);
1448: hr_multi_message.add
1449: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID'
1450: );
1451: else
1452: close csr_valid_grade_id;

Line 1905: hr_multi_message.add

1901: --
1902: -- The activity_version is not date valid
1903: --
1904: hr_utility.set_message(810,'OTA_13673_TAV_COMPETENCY_DATES');
1905: hr_multi_message.add
1906: (p_associated_column1 =>
1907: 'PER_COMPETENCE_ELEMENTS.ACTIVITY_VERSION_ID'
1908: ,p_associated_column2 =>
1909: 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'

Line 2109: hr_multi_message.add

2105: if p_rec.party_id is not null then
2106: if p_rec.party_id <> nvl(l_party_id,-1) then
2107: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
2108: hr_utility.set_location(l_proc,30);
2109: hr_multi_message.add
2110: (p_associated_column1 =>
2111: 'PER_COMPETENCE_ELEMENTS.PARTY_ID'
2112: ,p_associated_column2 =>
2113: 'PER_COMPETENCE_ELEMENTS.PERSON_ID'

Line 2134: hr_multi_message.add

2130: if csr_valid_party_id%notfound then
2131: close csr_valid_party_id;
2132: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
2133: hr_utility.set_location(l_proc,70);
2134: hr_multi_message.add
2135: (p_associated_column1 =>
2136: 'PER_COMPETENCE_ELEMENTS.PARTY_ID'
2137: );
2138: else

Line 2280: hr_multi_message.add

2276: close csr_get_rating_scale;
2277: if p_error = 'HIGH_PROF' then
2278: hr_utility.set_message(801,'HR_51616_CEL_HG_PROF_ID_INVL');
2279: hr_utility.set_location(l_proc,15);
2280: hr_multi_message.add
2281: (p_associated_column1 =>
2282: 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID'
2283: ,p_associated_column2 =>
2284: 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID'

Line 2289: hr_multi_message.add

2285: );
2286: else
2287: hr_utility.set_message(801,'HR_51615_CEL_PROF_ID_INVL');
2288: hr_utility.set_location(l_proc,20);
2289: hr_multi_message.add
2290: (p_associated_column1 =>
2291: 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID'
2292: ,p_associated_column2 =>
2293: 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID'

Line 2347: hr_multi_message.add

2343: elsif (p_proficiency_level_id is null AND
2344: p_high_proficiency_level_id is not null) then
2345: hr_utility.set_location(l_proc,6);
2346: hr_utility.set_message(801,'HR_51726_CEL_PROF_HG_PROF');
2347: hr_multi_message.add
2348: (p_associated_column1 =>
2349: 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID'
2350: ,p_associated_column2 =>
2351: 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID'

Line 2364: hr_multi_message.add

2360: -- issue an error message if the competence_id is null
2361: --
2362: hr_utility.set_location(l_proc,10);
2363: hr_utility.set_message(801,'HR_51642_COMP_ID_MANDATORY');
2364: hr_multi_message.add
2365: (p_associated_column1 =>
2366: 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID'
2367: );
2368: --

Line 2396: hr_multi_message.add

2392: is not null) then
2393: if(l_step_value1 > l_step_value2) then
2394: hr_utility.set_location(l_proc,25);
2395: hr_utility.set_message(801,'HR_51644_CEL_PROF_VAL_ERROR');
2396: hr_multi_message.add
2397: (p_associated_column1 =>
2398: 'PER_COMPETENCE_ELEMENTS.HIGH_PROFICIENCY_LEVEL_ID'
2399: ,p_associated_column2 =>
2400: 'PER_COMPETENCE_ELEMENTS.PROFICIENCY_LEVEL_ID'

Line 2515: if hr_multi_message.no_exclusive_error

2511: ,p_argument_value => p_business_group_id
2512: );
2513: end if;
2514: --
2515: if hr_multi_message.no_exclusive_error
2516: ( p_check_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE'
2517: ) then
2518: --
2519: -- Only proceed with validation if :

Line 2546: hr_multi_message.add

2542: else
2543: if (p_assessment_id is null) then
2544: hr_utility.set_location(l_proc,10);
2545: hr_utility.set_message(801,'HR_51645_CEL_ASS_ASS_TP_NULL');
2546: hr_multi_message.add
2547: (p_associated_column1 =>
2548: 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID'
2549: ,p_associated_column2 =>
2550: 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID'

Line 2580: hr_multi_message.add

2576: hr_utility.set_message(801,'HR_51727_CEL_RATE_ASS_ID_INVL');
2577: --
2578: if p_rating_level_id is not null then
2579: --
2580: hr_multi_message.add
2581: (p_associated_column1 =>
2582: 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID'
2583: ,p_associated_column2 =>
2584: 'PER_COMPETENCE_ELEMENTS.RATING_LEVEL_ID'

Line 2590: hr_multi_message.add

2586: 'PER_COMPETENCE_ELEMENTS.TYPE'
2587: );
2588: else
2589: --
2590: hr_multi_message.add
2591: (p_associated_column1 =>
2592: 'PER_COMPETENCE_ELEMENTS.ASSESSMENT_ID'
2593: ,p_associated_column2 =>
2594: 'PER_COMPETENCE_ELEMENTS.WEIGHTING_LEVEL_ID'

Line 2742: hr_multi_message.add

2738: elsif p_check_type = 'ORGANIZATION' then
2739: l_associate_attribute := 'PER_COMPETENCE_ELEMENTS.ORGANIZATION_ID';
2740: end if;
2741: if p_valid_grade_null is null then
2742: hr_multi_message.add
2743: (
2744: p_associated_column1 => l_associate_attribute
2745: -- p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
2746: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID'

Line 2751: hr_multi_message.add

2747: ,p_associated_column3 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
2748: ,p_associated_column4 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_TO'
2749: );
2750: else
2751: hr_multi_message.add
2752: (
2753: p_associated_column1 => l_associate_attribute
2754: -- p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM'
2755: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ID'

Line 2807: hr_multi_message.add

2803: then
2804: hr_utility.set_location(l_proc,10);
2805: hr_utility.set_message(801,'HR_51647_CEL_DATES_INVL');
2806: --
2807: hr_multi_message.add
2808: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM');
2809:
2810: elsif (p_enterprise_id is not null) then
2811: --

Line 2978: hr_multi_message.add

2974: --
2975: hr_utility.set_location(l_proc,10);
2976:
2977: hr_utility.set_message(801,'HR_51653_CEL_NOR_ELPS_COMB');
2978: hr_multi_message.add
2979: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.NORMAL_ELAPSE_DURATION'
2980: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.NORMAL_ELAPSE_DURATION_UNIT'
2981: );
2982: elsif (p_normal_elapse_duration IS NOT NULL AND

Line 2997: hr_multi_message.add

2993:
2994: -- Error: Invalid normal_elapse_duration_unit
2995: hr_utility.set_location(l_proc, 15);
2996: hr_utility.set_message(801,'HR_51654_CEL_NOR_ELPS_INVL');
2997: hr_multi_message.add
2998: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.NORMAL_ELAPSE_DURATION_UNIT'
2999: );
3000: end if;
3001: end if;

Line 3393: if hr_multi_message.no_exclusive_error

3389: --
3390: begin
3391: hr_utility.set_location('Entering:'|| l_proc, 1);
3392: --
3393: if hr_multi_message.no_exclusive_error
3394: (p_check_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE') then
3395: --
3396: -- Check mandatory parameters have being set.
3397: --

Line 3497: hr_multi_message.add

3493: elsif ((p_organization_id is not null OR p_enterprise_id is not NULL)
3494: AND (p_valid_grade_id is not null) ) then
3495: hr_utility.set_location(l_proc, 8);
3496: hr_utility.set_message(800,'HR_52373_CEL_GRD_ID_MST_NULL');
3497: hr_multi_message.add
3498: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID');
3499:
3500: hr_utility.raise_error;
3501: --

Line 3867: hr_multi_message.add

3863: then
3864: --
3865: hr_utility.set_location(l_proc, 75);
3866: hr_utility.set_message(801,'HR_51670_CEL_PER_TYPE_ERROR');
3867: hr_multi_message.add
3868: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.EFFECTIVE_DATE_FROM');
3869: hr_utility.raise_error;
3870: --
3871: end if;

Line 3996: if hr_multi_message.exception_add

3992: end if;
3993: end if; -- check for no_exclusive_error for TYPE.
3994: exception
3995: when app_exception.application_exception then
3996: if hr_multi_message.exception_add
3997: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE'
3998: ) then
3999: hr_utility.set_location(' Leaving:'||l_proc,110);
4000: raise;

Line 4099: if hr_multi_message.no_exclusive_error

4095: l_exists varchar2(1);
4096: --
4097: begin
4098: hr_utility.set_location('Entering:'|| l_proc, 1);
4099: if hr_multi_message.no_exclusive_error
4100: (p_check_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE') then
4101: --
4102: -- Check mandatory parameters have being set.
4103: --

Line 4336: hr_multi_message.add;

4332: end if; -- no_exclusive_check for TYPE
4333: hr_utility.set_location('Leaving: ' || l_proc, 10);
4334: exception
4335: when app_exception.application_exception then
4336: hr_multi_message.add;
4337: hr_utility.set_location(' Leaving:'||l_proc,105);
4338: end chk_unique_competence_element;
4339: /*
4340: --

Line 4955: hr_multi_message.end_validation_set;

4951: -- After validating the set of important attributes,
4952: -- if Mulitple message detection is enabled and at least
4953: -- one error has been found then abort further validation.
4954: --
4955: hr_multi_message.end_validation_set;
4956: --
4957: per_cel_shd.g_bus_grp := true;
4958: else
4959: per_cel_shd.g_bus_grp := false;

Line 5351: hr_multi_message.end_validation_set;

5347: -- After validating the set of important attributes,
5348: -- if Mulitple message detection is enabled and at least
5349: -- one error has been found then abort further validation.
5350: --
5351: hr_multi_message.end_validation_set;
5352: --
5353: per_cel_shd.g_bus_grp := true;
5354: else
5355: per_cel_shd.g_bus_grp := false;

Line 5791: hr_multi_message.add

5787: --
5788: -- The primary key is invalid therefore we must error out
5789: --
5790: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5791: hr_multi_message.add
5792: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.COMPETENCE_ELEMENT_ID');
5793: hr_utility.raise_error;
5794: end if;
5795: --