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.GHR_RIF_PKG dependencies on HR_UTILITY

Line 45: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');

41: exit;
42: End loop;
43:
44: If l_id_flex_num is null then
45: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
46: hr_utility.raise_error;
47: End if;
48:
49:

Line 46: hr_utility.raise_error;

42: End loop;
43:
44: If l_id_flex_num is null then
45: hr_utility.set_message(8301,'GHR_38275_INV_SP_INFO_TYPE');
46: hr_utility.raise_error;
47: End if;
48:
49:
50: for cur_sit_rec in cur_sit loop

Line 309: hr_utility.set_location('Enter Rif' ,1);

305: l_perf_appraisal2 ghr_api.special_information_type;
306: l_perf_appraisal3 ghr_api.special_information_type;
307:
308: BEGIN
309: hr_utility.set_location('Enter Rif' ,1);
310:
311: if p_comp_area is null and
312: p_comp_level is null and
313: p_effective_date is null and

Line 328: hr_utility.set_message(8301,'GHR_38485_NULL_RIF_CRITERIA');

324: l_c_org_structure_id,
325: l_c_office_symbol,
326: l_c_agency_code_se;
327: if cur_criteria%NOTFOUND then
328: hr_utility.set_message(8301,'GHR_38485_NULL_RIF_CRITERIA');
329: hr_utility.raise_error;
330: end if;
331:
332: close cur_criteria;

Line 329: hr_utility.raise_error;

325: l_c_office_symbol,
326: l_c_agency_code_se;
327: if cur_criteria%NOTFOUND then
328: hr_utility.set_message(8301,'GHR_38485_NULL_RIF_CRITERIA');
329: hr_utility.raise_error;
330: end if;
331:
332: close cur_criteria;
333:

Line 347: hr_utility.set_message(8301,'GHR_38484_NO_COMP_AREA_LEVEL');

343:
344: /* Comp_area is used to be required field but with Bug 691379 it become optional */
345:
346: if l_c_comp_level is null then
347: hr_utility.set_message(8301,'GHR_38484_NO_COMP_AREA_LEVEL');
348: hr_utility.raise_error;
349: end if;
350:
351: l_effective_date := trunc(sysdate); -- In the future l_effective_date may set to p_effective_date

Line 348: hr_utility.raise_error;

344: /* Comp_area is used to be required field but with Bug 691379 it become optional */
345:
346: if l_c_comp_level is null then
347: hr_utility.set_message(8301,'GHR_38484_NO_COMP_AREA_LEVEL');
348: hr_utility.raise_error;
349: end if;
350:
351: l_effective_date := trunc(sysdate); -- In the future l_effective_date may set to p_effective_date
352:

Line 357: hr_utility.set_location('Purged rif_registers' ,2);

353: DELETE FROM ghr_rif_registers reg
354: WHERE reg.session_id = userenv('SESSIONID')
355: and rif_criteria_id = p_rif_criteria_id;
356:
357: hr_utility.set_location('Purged rif_registers' ,2);
358:
359: FOR per_rec IN cur_people (l_effective_date)
360:
361: LOOP

Line 365: hr_utility.set_location('Getting position EI',3);

361: LOOP
362:
363: --Get the Person Comp Area, Comp Level,Org Structure Id, Office Symbol
364:
365: hr_utility.set_location('Getting position EI',3);
366: ghr_history_fetch.fetch_positionei
367: (p_position_id => per_rec.position_id
368: ,p_information_type => 'GHR_US_POS_GRP1'
369: ,p_date_effective => l_effective_date

Line 379: hr_utility.set_location('Getting Agency Code',4);

375: l_rif_reg.org_structure_id := l_pos_ei_data1.poei_information5;
376: l_rif_reg.office_symbol := l_pos_ei_data1.poei_information4;
377:
378: -- Agency Code
379: hr_utility.set_location('Getting Agency Code',4);
380:
381: l_rif_reg.agency_code_subelement := ghr_api.get_position_agency_code_pos
382: (p_position_id => per_rec.position_id
383: ,p_business_group_id => per_rec.business_group_id

Line 388: hr_utility.set_location('Checking the Criteria',5);

384: ,p_effective_date => l_effective_date);
385:
386: --Check the Criteria
387:
388: hr_utility.set_location('Checking the Criteria',5);
389: if nvl(l_comp_area,hr_api.g_varchar2) = nvl(l_c_comp_area,nvl(l_comp_area,hr_api.g_varchar2)) and
390: nvl(l_comp_level,hr_api.g_varchar2) = l_c_comp_level and
391: nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 ) = nvl(l_c_org_structure_id,nvl(l_rif_reg.org_structure_id,hr_api.g_varchar2 )) and
392: nvl(l_rif_reg.office_symbol,hr_api.g_varchar2) = nvl(l_c_office_symbol,nvl(l_rif_reg.office_symbol,hr_api.g_varchar2)) and

Line 400: hr_utility.set_location('Getting Tenure and Ster_or_rate',5);

396:
397: -- Populate the details into ghr_rif_registers
398:
399: -- Tenure and Step_or_rate
400: hr_utility.set_location('Getting Tenure and Ster_or_rate',5);
401:
402: ghr_history_fetch.fetch_asgei
403: (p_assignment_id => per_rec.assignment_id
404: ,p_information_type => 'GHR_US_ASG_SF52'

Line 414: hr_utility.set_location('Getting the Tenure Description and Group',6);

410:
411: -- Tenure Description and Group
412:
413:
414: hr_utility.set_location('Getting the Tenure Description and Group',6);
415: get_lookup_meaning_desc (
416: p_application_id => '800',
417: p_lookup_type => 'GHR_US_TENURE',
418: p_lookup_code => l_rif_reg.tenure,

Line 432: hr_utility.set_location('Getting Vets Info',7);

428: p_lookup_meaning => l_rif_reg.tenure_group_desc,
429: p_lookup_desc => l_rif_reg.tenure_group_order);
430:
431: -- Vets info
432: hr_utility.set_location('Getting Vets Info',7);
433:
434: ghr_history_fetch.fetch_peopleei
435: (p_person_id => per_rec.person_id,
436: p_information_type => 'GHR_US_PER_SF52',

Line 487: hr_utility.set_location('Getting OCC Code' ,8);

483: l_rif_reg.service_comp_date_rif := fnd_date.canonical_to_date(l_people_ei_data2.pei_information5);
484: l_rif_reg.service_comp_date_civilian := fnd_date.canonical_to_date(l_people_ei_data2.pei_information4);
485:
486: -- Series (Occ_code)
487: hr_utility.set_location('Getting OCC Code' ,8);
488:
489: l_rif_reg.occ_code := ghr_api.get_job_occ_series_job
490: (p_job_id => per_rec.job_id,
491: p_business_group_id => per_rec.business_group_id

Line 527: hr_utility.set_location('Getting WGI Due Date',9);

523: get_entered_grade_date(p_asg_id => per_rec.assignment_id,
524: p_start_date => per_rec.effective_start_date);
525:
526: --WGI Due Date
527: hr_utility.set_location('Getting WGI Due Date',9);
528:
529: ghr_api.retrieve_element_entry_value
530: (p_element_name => 'Within Grade Increase',
531: p_input_value_name => 'Date Due',

Line 536: hr_utility.set_location('After Getting WGI Due Date',9);

532: p_assignment_id => per_rec.assignment_id, p_effective_date => l_effective_date,
533: p_value => l_value,
534: p_multiple_error_flag => l_multiple_error_flag
535: );
536: hr_utility.set_location('After Getting WGI Due Date',9);
537: l_rif_reg.wgi_due_date := fnd_date.canonical_to_date(l_value);
538:
539: -- Ratings 1
540:

Line 541: hr_utility.set_location('Getting return ratings',10);

537: l_rif_reg.wgi_due_date := fnd_date.canonical_to_date(l_value);
538:
539: -- Ratings 1
540:
541: hr_utility.set_location('Getting return ratings',10);
542:
543: return_ratings
544: (p_person_id => per_rec.person_id,
545: p_structure_name => 'US Fed Perf Appraisal',

Line 594: hr_utility.set_location('Getting Adjusterd SCD',11);

590:
591: l_rif_reg.performance_score := ceil(((nvl(to_number(l_rating1),12) + nvl(to_number(l_rating2),12) + nvl(to_number(l_rating3),12) ) / 3));
592:
593: -- Adjusted SCD
594: hr_utility.set_location('Getting Adjusterd SCD',11);
595:
596: if l_rif_reg.service_comp_date_rif is null then
597: l_rif_reg.adjusted_service_comp_date := null;
598: else

Line 625: hr_utility.set_location('Getting Position Title',12);

621: p_lookup_meaning => l_rif_reg.position_occupied_desc,
622: p_lookup_desc => l_dummy_parameter);
623:
624: -- Position Title
625: hr_utility.set_location('Getting Position Title',12);
626:
627: l_rif_reg.position_title := ghr_api.get_position_title_pos
628: (p_position_id => per_rec.position_id,
629: p_business_group_id => per_rec.business_group_id,

Line 684: hr_utility.set_location('Inserting into ghr_rif_registers',13);

680: fetch cur_rif_reg_seq into l_rif_reg.rif_register_id;
681: close cur_rif_reg_seq;
682:
683:
684: hr_utility.set_location('Inserting into ghr_rif_registers',13);
685: INSERT INTO ghr_rif_registers
686: (rif_register_id
687: ,session_id
688: ,rif_criteria_id

Line 810: hr_utility.set_location('Leaving run_register',50);

806: END IF;
807: -- Come here if person doesn't match all criteria and loop to get next person
808:
809: END LOOP;
810: hr_utility.set_location('Leaving run_register',50);
811:
812:
813: END run_register;
814:

Line 837: hr_utility.set_message(8301,'GHR_99999_RIF_NAME_NOT_UNIQUE');

833: AND rif.rif_criteria_id <> NVL(p_rif_criteria_id,-1);
834: --
835: BEGIN
836: FOR cur_rif_rec IN cur_rif LOOP
837: hr_utility.set_message(8301,'GHR_99999_RIF_NAME_NOT_UNIQUE');
838: hr_utility.raise_error;
839: END LOOP;
840: --
841: END check_unique_name;

Line 838: hr_utility.raise_error;

834: --
835: BEGIN
836: FOR cur_rif_rec IN cur_rif LOOP
837: hr_utility.set_message(8301,'GHR_99999_RIF_NAME_NOT_UNIQUE');
838: hr_utility.raise_error;
839: END LOOP;
840: --
841: END check_unique_name;
842: