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_ES_ABSENCE dependencies on HR_UTILITY

Line 58: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

54: BEGIN
55: --
56: -- Added for GSI Bug 5472781
57: --
58: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
59: --
60: --
61: hr_utility.set_location('Entering hook Person_entry_Create',10);
62: --

Line 61: hr_utility.set_location('Entering hook Person_entry_Create',10);

57: --
58: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
59: --
60: --
61: hr_utility.set_location('Entering hook Person_entry_Create',10);
62: --
63: IF p_date_start IS NOT NULL THEN
64: --
65: IF p_abs_information_category IN ('ES_TD','ES_M','ES_IE_AL','ES_PAR','ES_PTM') THEN

Line 68: hr_utility.set_location(' IN Create User hook ',20);

64: --
65: IF p_abs_information_category IN ('ES_TD','ES_M','ES_IE_AL','ES_PAR','ES_PTM') THEN
66: --
67:
68: hr_utility.set_location(' IN Create User hook ',20);
69: --
70: hr_person_absence_api.get_absence_element
71: (p_absence_attendance_id => p_absence_attendance_id
72: ,p_element_entry_id => l_element_entry_id

Line 78: hr_utility.set_location(' Updating dates for entry_id='||l_element_entry_id,30);

74: ,p_effective_end_date => l_effective_end_date);
75: --
76: IF l_element_entry_id IS NOT NULL THEN
77: --
78: hr_utility.set_location(' Updating dates for entry_id='||l_element_entry_id,30);
79: hr_utility.set_location('-- Date='|| to_char(l_effective_end_date,'dd-mm-yyyy'),35);
80: IF p_date_end = to_date('31-12-4712','DD-MM-YYYY') OR
81: p_date_end IS NULL THEN
82: l_effective_end_date := NULL;

Line 79: hr_utility.set_location('-- Date='|| to_char(l_effective_end_date,'dd-mm-yyyy'),35);

75: --
76: IF l_element_entry_id IS NOT NULL THEN
77: --
78: hr_utility.set_location(' Updating dates for entry_id='||l_element_entry_id,30);
79: hr_utility.set_location('-- Date='|| to_char(l_effective_end_date,'dd-mm-yyyy'),35);
80: IF p_date_end = to_date('31-12-4712','DD-MM-YYYY') OR
81: p_date_end IS NULL THEN
82: l_effective_end_date := NULL;
83: END IF;

Line 85: hr_utility.set_location('-- Date='|| to_char(l_effective_end_date,'dd-mm-yyyy'),35);

81: p_date_end IS NULL THEN
82: l_effective_end_date := NULL;
83: END IF;
84: --
85: hr_utility.set_location('-- Date='|| to_char(l_effective_end_date,'dd-mm-yyyy'),35);
86:
87: OPEN csr_get_input_value_info(l_element_entry_id
88: ,'Start Date'
89: ,l_effective_start_date);

Line 117: hr_utility.set_location('~~ Before updating ',30);

113: SELECT max(object_version_number) INTO l_ovn
114: FROM pay_element_entries_f
115: WHERE element_entry_id = l_element_entry_id;
116: --
117: hr_utility.set_location('~~ Before updating ',30);
118: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);
119: IF p_abs_information_category = 'ES_PTM' THEN
120: --
121: pay_element_entry_api.update_element_entry

Line 118: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);

114: FROM pay_element_entries_f
115: WHERE element_entry_id = l_element_entry_id;
116: --
117: hr_utility.set_location('~~ Before updating ',30);
118: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);
119: IF p_abs_information_category = 'ES_PTM' THEN
120: --
121: pay_element_entry_api.update_element_entry
122: (p_validate => FALSE

Line 158: hr_utility.set_location('~~ After updating ',30);

154: ,p_effective_start_date => l_o_start_dt
155: ,p_effective_end_date => l_o_end_dt
156: ,p_update_warning => l_o_warning);
157: END IF;
158: hr_utility.set_location('~~ After updating ',30);
159: END IF;
160: END IF;
161: END IF;
162: --

Line 165: hr_utility.set_location('Leaving hook Person_entry_Create',90);

161: END IF;
162: --
163: END IF;
164: --
165: hr_utility.set_location('Leaving hook Person_entry_Create',90);
166: --
167: END person_entry_create;
168: --
169: -------------------------------------------------------------------------------

Line 225: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

221: BEGIN
222: --
223: -- Added for GSI Bug 5472781
224: --
225: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
226: --
227: --
228: hr_utility.set_location('Entering hook Person_entry_Create',10);
229: --

Line 228: hr_utility.set_location('Entering hook Person_entry_Create',10);

224: --
225: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
226: --
227: --
228: hr_utility.set_location('Entering hook Person_entry_Create',10);
229: --
230: IF p_date_start IS NOT NULL THEN
231: --
232: IF p_abs_information_category IN ('ES_TD','ES_M','ES_IE_AL','ES_PAR','ES_PTM') THEN

Line 234: hr_utility.set_location(' IN Update User hook ',20);

230: IF p_date_start IS NOT NULL THEN
231: --
232: IF p_abs_information_category IN ('ES_TD','ES_M','ES_IE_AL','ES_PAR','ES_PTM') THEN
233: --
234: hr_utility.set_location(' IN Update User hook ',20);
235: --
236: hr_person_absence_api.get_absence_element
237: (p_absence_attendance_id => p_absence_attendance_id
238: ,p_element_entry_id => l_element_entry_id

Line 244: hr_utility.set_location(' Updating dates for entry_id='||l_element_entry_id,30);

240: ,p_effective_end_date => l_effective_end_date);
241: --
242: IF l_element_entry_id IS NOT NULL THEN
243:
244: hr_utility.set_location(' Updating dates for entry_id='||l_element_entry_id,30);
245: --
246: IF p_date_end = to_date('31-12-4712','DD-MM-YYYY') OR
247: p_date_end IS NULL THEN
248: l_effective_end_date := NULL;

Line 285: hr_utility.set_location('~~ Before updating ',30);

281: SELECT business_group_id INTO l_bus_grp_id
282: FROM per_absence_attendances
283: WHERE absence_attendance_id = p_absence_attendance_id;
284: --
285: hr_utility.set_location('~~ Before updating ',30);
286: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);
287: --
288: IF p_abs_information_category = 'ES_PTM' THEN
289: --

Line 286: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);

282: FROM per_absence_attendances
283: WHERE absence_attendance_id = p_absence_attendance_id;
284: --
285: hr_utility.set_location('~~ Before updating ',30);
286: hr_utility.set_location('~~ Absence Att ID ' || to_char(p_absence_attendance_id),10);
287: --
288: IF p_abs_information_category = 'ES_PTM' THEN
289: --
290: pay_element_entry_api.update_element_entry

Line 327: hr_utility.set_location('~~ After updating ',30);

323: ,p_effective_end_date => l_o_end_dt
324: ,p_update_warning => l_o_warning);
325: END IF;
326: --
327: hr_utility.set_location('~~ After updating ',30);
328: END IF;
329: END IF;
330: END IF;
331: --

Line 334: hr_utility.set_location('Leaving hook Person_entry_Update',90);

330: END IF;
331: --
332: END IF;
333: --
334: hr_utility.set_location('Leaving hook Person_entry_Update',90);
335: --
336: END person_entry_update;
337: -------------------------------------------------------------------------------
338: -- VALIDATE_ABS_CREATE

Line 403: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

399: BEGIN
400: --
401: -- Added for GSI Bug 5472781
402: --
403: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
404: --
405: --
406: -- get the values of the person_id profile
407: fnd_profile.put('HR_FR_PERSON_ID',p_person_id);

Line 422: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

418: FOR i IN csr_get_other_absences(p_person_id
419: ,p_date_start
420: ,p_date_end) LOOP
421: IF i.absence_category IN ('TD') THEN
422: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
423: hr_utility.raise_error;
424: END IF;
425: IF i.absence_category IN ('V') THEN
426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

Line 423: hr_utility.raise_error;

419: ,p_date_start
420: ,p_date_end) LOOP
421: IF i.absence_category IN ('TD') THEN
422: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
423: hr_utility.raise_error;
424: END IF;
425: IF i.absence_category IN ('V') THEN
426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
427: hr_utility.raise_error;

Line 426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

422: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
423: hr_utility.raise_error;
424: END IF;
425: IF i.absence_category IN ('V') THEN
426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
427: hr_utility.raise_error;
428: END IF;
429: IF i.absence_category IN ('ZZB') THEN
430: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

Line 427: hr_utility.raise_error;

423: hr_utility.raise_error;
424: END IF;
425: IF i.absence_category IN ('V') THEN
426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
427: hr_utility.raise_error;
428: END IF;
429: IF i.absence_category IN ('ZZB') THEN
430: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
431: hr_utility.raise_error;

Line 430: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

426: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
427: hr_utility.raise_error;
428: END IF;
429: IF i.absence_category IN ('ZZB') THEN
430: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
431: hr_utility.raise_error;
432: END IF;
433: END LOOP;
434: -- BU Gross Pay Daily Rate Formula validation

Line 431: hr_utility.raise_error;

427: hr_utility.raise_error;
428: END IF;
429: IF i.absence_category IN ('ZZB') THEN
430: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
431: hr_utility.raise_error;
432: END IF;
433: END LOOP;
434: -- BU Gross Pay Daily Rate Formula validation
435: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN

Line 436: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

432: END IF;
433: END LOOP;
434: -- BU Gross Pay Daily Rate Formula validation
435: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN
436: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
437: hr_utility.raise_error;
438: END IF;
439: --
440: END IF;

Line 437: hr_utility.raise_error;

433: END LOOP;
434: -- BU Gross Pay Daily Rate Formula validation
435: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN
436: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
437: hr_utility.raise_error;
438: END IF;
439: --
440: END IF;
441: --

Line 447: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

443: FOR i IN csr_get_other_absences(p_person_id
444: ,p_date_start
445: ,p_date_end) LOOP
446: IF i.absence_category IN ('TD') THEN
447: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
448: hr_utility.raise_error;
449: END IF;
450: IF i.absence_category IN ('V') THEN
451: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

Line 448: hr_utility.raise_error;

444: ,p_date_start
445: ,p_date_end) LOOP
446: IF i.absence_category IN ('TD') THEN
447: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
448: hr_utility.raise_error;
449: END IF;
450: IF i.absence_category IN ('V') THEN
451: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
452: hr_utility.raise_error;

Line 451: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

447: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
448: hr_utility.raise_error;
449: END IF;
450: IF i.absence_category IN ('V') THEN
451: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
452: hr_utility.raise_error;
453: END IF;
454: END LOOP;
455: END IF;

Line 452: hr_utility.raise_error;

448: hr_utility.raise_error;
449: END IF;
450: IF i.absence_category IN ('V') THEN
451: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
452: hr_utility.raise_error;
453: END IF;
454: END LOOP;
455: END IF;
456: --

Line 462: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

458: FOR i IN csr_get_other_absences(p_person_id
459: ,p_date_start
460: ,p_date_end) LOOP
461: IF i.absence_category IN ('TD') THEN
462: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
463: hr_utility.raise_error;
464: END IF;
465: IF i.absence_category IN ('ZZB') THEN
466: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

Line 463: hr_utility.raise_error;

459: ,p_date_start
460: ,p_date_end) LOOP
461: IF i.absence_category IN ('TD') THEN
462: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
463: hr_utility.raise_error;
464: END IF;
465: IF i.absence_category IN ('ZZB') THEN
466: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
467: hr_utility.raise_error;

Line 466: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

462: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
463: hr_utility.raise_error;
464: END IF;
465: IF i.absence_category IN ('ZZB') THEN
466: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
467: hr_utility.raise_error;
468: END IF;
469: END LOOP;
470: END IF;

Line 467: hr_utility.raise_error;

463: hr_utility.raise_error;
464: END IF;
465: IF i.absence_category IN ('ZZB') THEN
466: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
467: hr_utility.raise_error;
468: END IF;
469: END LOOP;
470: END IF;
471: --

Line 477: hr_utility.set_message(800,'HR_ES_M_OVERLAP');

473: FOR i IN csr_get_other_absences(p_person_id
474: ,p_date_start
475: ,p_date_end) LOOP
476: IF i.absence_category IN ('M') THEN
477: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
478: hr_utility.raise_error;
479: END IF;
480: IF i.absence_category IN ('PAR') THEN
481: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

Line 478: hr_utility.raise_error;

474: ,p_date_start
475: ,p_date_end) LOOP
476: IF i.absence_category IN ('M') THEN
477: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
478: hr_utility.raise_error;
479: END IF;
480: IF i.absence_category IN ('PAR') THEN
481: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
482: hr_utility.raise_error;

Line 481: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

477: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
478: hr_utility.raise_error;
479: END IF;
480: IF i.absence_category IN ('PAR') THEN
481: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
482: hr_utility.raise_error;
483: END IF;
484: END LOOP;
485: -- BU Gross Pay Daily Rate Formula validation

Line 482: hr_utility.raise_error;

478: hr_utility.raise_error;
479: END IF;
480: IF i.absence_category IN ('PAR') THEN
481: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
482: hr_utility.raise_error;
483: END IF;
484: END LOOP;
485: -- BU Gross Pay Daily Rate Formula validation
486: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN

Line 487: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

483: END IF;
484: END LOOP;
485: -- BU Gross Pay Daily Rate Formula validation
486: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN
487: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
488: hr_utility.raise_error;
489: END IF;
490: --
491: END IF;

Line 488: hr_utility.raise_error;

484: END LOOP;
485: -- BU Gross Pay Daily Rate Formula validation
486: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN
487: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
488: hr_utility.raise_error;
489: END IF;
490: --
491: END IF;
492: --

Line 499: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');

495: OPEN csr_validate_sex_par (p_person_id);
496: FETCH csr_validate_sex_par INTO l_sex ;
497: CLOSE csr_validate_sex_par;
498: IF l_sex = 'M' THEN
499: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');
500: hr_utility.raise_error;
501: END IF;
502:
503: FOR i IN csr_get_other_absences(p_person_id

Line 500: hr_utility.raise_error;

496: FETCH csr_validate_sex_par INTO l_sex ;
497: CLOSE csr_validate_sex_par;
498: IF l_sex = 'M' THEN
499: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');
500: hr_utility.raise_error;
501: END IF;
502:
503: FOR i IN csr_get_other_absences(p_person_id
504: ,p_date_start

Line 507: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

503: FOR i IN csr_get_other_absences(p_person_id
504: ,p_date_start
505: ,p_date_end) LOOP
506: IF i.absence_category IN ('PAR') THEN
507: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
508: hr_utility.raise_error;
509: END IF;
510: END LOOP;
511: -- BU Gross Pay Daily Rate Formula validation

Line 508: hr_utility.raise_error;

504: ,p_date_start
505: ,p_date_end) LOOP
506: IF i.absence_category IN ('PAR') THEN
507: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
508: hr_utility.raise_error;
509: END IF;
510: END LOOP;
511: -- BU Gross Pay Daily Rate Formula validation
512: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN

Line 513: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

509: END IF;
510: END LOOP;
511: -- BU Gross Pay Daily Rate Formula validation
512: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
513: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
514: hr_utility.raise_error;
515: END IF;
516: --
517: END IF;

Line 514: hr_utility.raise_error;

510: END LOOP;
511: -- BU Gross Pay Daily Rate Formula validation
512: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
513: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
514: hr_utility.raise_error;
515: END IF;
516: --
517: END IF;
518: --

Line 524: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');

520: FOR i IN csr_get_other_absences(p_person_id
521: ,p_date_start
522: ,p_date_end) LOOP
523: IF i.absence_category IN ('IE_AL') THEN
524: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');
525: hr_utility.raise_error;
526: END IF;
527: END LOOP;
528: -- BU Gross Pay Daily Rate Formula validation

Line 525: hr_utility.raise_error;

521: ,p_date_start
522: ,p_date_end) LOOP
523: IF i.absence_category IN ('IE_AL') THEN
524: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');
525: hr_utility.raise_error;
526: END IF;
527: END LOOP;
528: -- BU Gross Pay Daily Rate Formula validation
529: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN

Line 530: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

526: END IF;
527: END LOOP;
528: -- BU Gross Pay Daily Rate Formula validation
529: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
530: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
531: hr_utility.raise_error;
532: END IF;
533: --
534: END IF;

Line 531: hr_utility.raise_error;

527: END LOOP;
528: -- BU Gross Pay Daily Rate Formula validation
529: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
530: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
531: hr_utility.raise_error;
532: END IF;
533: --
534: END IF;
535: --

Line 541: hr_utility.set_message(800,'HR_ES_M_OVERLAP');

537: FOR i IN csr_get_other_absences(p_person_id
538: ,p_date_start
539: ,p_date_end) LOOP
540: IF i.absence_category IN ('M') THEN
541: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
542: hr_utility.raise_error;
543: END IF;
544: IF i.absence_category IN ('PTM') THEN
545: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');

Line 542: hr_utility.raise_error;

538: ,p_date_start
539: ,p_date_end) LOOP
540: IF i.absence_category IN ('M') THEN
541: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
542: hr_utility.raise_error;
543: END IF;
544: IF i.absence_category IN ('PTM') THEN
545: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
546: hr_utility.raise_error;

Line 545: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');

541: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
542: hr_utility.raise_error;
543: END IF;
544: IF i.absence_category IN ('PTM') THEN
545: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
546: hr_utility.raise_error;
547: END IF;
548: END LOOP;
549: --

Line 546: hr_utility.raise_error;

542: hr_utility.raise_error;
543: END IF;
544: IF i.absence_category IN ('PTM') THEN
545: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
546: hr_utility.raise_error;
547: END IF;
548: END LOOP;
549: --
550: OPEN csr_validate_ptm (p_person_id

Line 556: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');

552: FETCH csr_validate_ptm INTO l_maternity_benefit_days ;
553: CLOSE csr_validate_ptm;
554: --
555: IF l_maternity_benefit_days = 0 THEN
556: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');
557: hr_utility.raise_error;
558: END IF;
559: --
560: IF l_maternity_benefit_days < 42 THEN

Line 557: hr_utility.raise_error;

553: CLOSE csr_validate_ptm;
554: --
555: IF l_maternity_benefit_days = 0 THEN
556: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');
557: hr_utility.raise_error;
558: END IF;
559: --
560: IF l_maternity_benefit_days < 42 THEN
561: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');

Line 561: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');

557: hr_utility.raise_error;
558: END IF;
559: --
560: IF l_maternity_benefit_days < 42 THEN
561: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');
562: hr_utility.raise_error;
563: END IF;
564: --
565: -- BU Gross Pay Daily Rate Formula validation

Line 562: hr_utility.raise_error;

558: END IF;
559: --
560: IF l_maternity_benefit_days < 42 THEN
561: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');
562: hr_utility.raise_error;
563: END IF;
564: --
565: -- BU Gross Pay Daily Rate Formula validation
566: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN

Line 567: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

563: END IF;
564: --
565: -- BU Gross Pay Daily Rate Formula validation
566: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN
567: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
568: hr_utility.raise_error;
569: END IF;
570: --
571: END IF;

Line 568: hr_utility.raise_error;

564: --
565: -- BU Gross Pay Daily Rate Formula validation
566: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN
567: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
568: hr_utility.raise_error;
569: END IF;
570: --
571: END IF;
572: --

Line 655: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN

651: BEGIN
652: --
653: -- Added for GSI Bug 5472781
654: --
655: IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
656: --
657: --
658: OPEN get_person_id(p_absence_attendance_id);
659: FETCH get_person_id into l_person_id;

Line 678: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

674: FOR i IN csr_get_other_absences(p_absence_attendance_id
675: ,p_date_start
676: ,p_date_end) LOOP
677: IF i.absence_category IN ('TD') THEN
678: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
679: hr_utility.raise_error;
680: END IF;
681: IF i.absence_category IN ('V') THEN
682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

Line 679: hr_utility.raise_error;

675: ,p_date_start
676: ,p_date_end) LOOP
677: IF i.absence_category IN ('TD') THEN
678: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
679: hr_utility.raise_error;
680: END IF;
681: IF i.absence_category IN ('V') THEN
682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
683: hr_utility.raise_error;

Line 682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

678: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
679: hr_utility.raise_error;
680: END IF;
681: IF i.absence_category IN ('V') THEN
682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
683: hr_utility.raise_error;
684: END IF;
685: IF i.absence_category IN ('ZZB') THEN
686: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

Line 683: hr_utility.raise_error;

679: hr_utility.raise_error;
680: END IF;
681: IF i.absence_category IN ('V') THEN
682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
683: hr_utility.raise_error;
684: END IF;
685: IF i.absence_category IN ('ZZB') THEN
686: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
687: hr_utility.raise_error;

Line 686: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

682: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
683: hr_utility.raise_error;
684: END IF;
685: IF i.absence_category IN ('ZZB') THEN
686: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
687: hr_utility.raise_error;
688: END IF;
689: END LOOP;
690: -- BU Gross Pay Daily Rate Formula validation

Line 687: hr_utility.raise_error;

683: hr_utility.raise_error;
684: END IF;
685: IF i.absence_category IN ('ZZB') THEN
686: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
687: hr_utility.raise_error;
688: END IF;
689: END LOOP;
690: -- BU Gross Pay Daily Rate Formula validation
691: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN

Line 692: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

688: END IF;
689: END LOOP;
690: -- BU Gross Pay Daily Rate Formula validation
691: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN
692: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
693: hr_utility.raise_error;
694: END IF;
695: --
696: END IF;

Line 693: hr_utility.raise_error;

689: END LOOP;
690: -- BU Gross Pay Daily Rate Formula validation
691: IF (p_abs_information3 = 'GROSS_PAY' ) AND (p_abs_information4 IS NULL) THEN
692: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
693: hr_utility.raise_error;
694: END IF;
695: --
696: END IF;
697: --

Line 703: hr_utility.set_message(800,'HR_ES_V_OVERLAP');

699: FOR i IN csr_get_other_absences(p_absence_attendance_id
700: ,p_date_start
701: ,p_date_end) LOOP
702: IF i.absence_category IN ('V') THEN
703: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
704: hr_utility.raise_error;
705: END IF;
706: IF i.absence_category IN ('TD') THEN
707: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

Line 704: hr_utility.raise_error;

700: ,p_date_start
701: ,p_date_end) LOOP
702: IF i.absence_category IN ('V') THEN
703: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
704: hr_utility.raise_error;
705: END IF;
706: IF i.absence_category IN ('TD') THEN
707: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
708: hr_utility.raise_error;

Line 707: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

703: hr_utility.set_message(800,'HR_ES_V_OVERLAP');
704: hr_utility.raise_error;
705: END IF;
706: IF i.absence_category IN ('TD') THEN
707: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
708: hr_utility.raise_error;
709: END IF;
710: END LOOP;
711: END IF;

Line 708: hr_utility.raise_error;

704: hr_utility.raise_error;
705: END IF;
706: IF i.absence_category IN ('TD') THEN
707: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
708: hr_utility.raise_error;
709: END IF;
710: END LOOP;
711: END IF;
712: --

Line 718: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');

714: FOR i IN csr_get_other_absences(p_absence_attendance_id
715: ,p_date_start
716: ,p_date_end) LOOP
717: IF i.absence_category IN ('TD') THEN
718: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
719: hr_utility.raise_error;
720: END IF;
721: IF i.absence_category IN ('ZZB') THEN
722: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

Line 719: hr_utility.raise_error;

715: ,p_date_start
716: ,p_date_end) LOOP
717: IF i.absence_category IN ('TD') THEN
718: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
719: hr_utility.raise_error;
720: END IF;
721: IF i.absence_category IN ('ZZB') THEN
722: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
723: hr_utility.raise_error;

Line 722: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');

718: hr_utility.set_message(800,'HR_ES_TD_OVERLAP');
719: hr_utility.raise_error;
720: END IF;
721: IF i.absence_category IN ('ZZB') THEN
722: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
723: hr_utility.raise_error;
724: END IF;
725: END LOOP;
726: END IF;

Line 723: hr_utility.raise_error;

719: hr_utility.raise_error;
720: END IF;
721: IF i.absence_category IN ('ZZB') THEN
722: hr_utility.set_message(800,'HR_ES_STRIKE_OVERLAP');
723: hr_utility.raise_error;
724: END IF;
725: END LOOP;
726: END IF;
727: --

Line 733: hr_utility.set_message(800,'HR_ES_M_OVERLAP');

729: FOR i IN csr_get_other_absences(p_absence_attendance_id
730: ,p_date_start
731: ,p_date_end) LOOP
732: IF i.absence_category IN ('M') THEN
733: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
734: hr_utility.raise_error;
735: END IF;
736: IF i.absence_category IN ('PAR') THEN
737: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

Line 734: hr_utility.raise_error;

730: ,p_date_start
731: ,p_date_end) LOOP
732: IF i.absence_category IN ('M') THEN
733: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
734: hr_utility.raise_error;
735: END IF;
736: IF i.absence_category IN ('PAR') THEN
737: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
738: hr_utility.raise_error;

Line 737: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

733: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
734: hr_utility.raise_error;
735: END IF;
736: IF i.absence_category IN ('PAR') THEN
737: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
738: hr_utility.raise_error;
739: END IF;
740: END LOOP;
741: -- BU Gross Pay Daily Rate Formula validation

Line 738: hr_utility.raise_error;

734: hr_utility.raise_error;
735: END IF;
736: IF i.absence_category IN ('PAR') THEN
737: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
738: hr_utility.raise_error;
739: END IF;
740: END LOOP;
741: -- BU Gross Pay Daily Rate Formula validation
742: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN

Line 743: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

739: END IF;
740: END LOOP;
741: -- BU Gross Pay Daily Rate Formula validation
742: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN
743: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
744: hr_utility.raise_error;
745: END IF;
746: --
747: END IF;

Line 744: hr_utility.raise_error;

740: END LOOP;
741: -- BU Gross Pay Daily Rate Formula validation
742: IF (p_abs_information5 = 'GROSS_PAY' ) AND (p_abs_information6 IS NULL) THEN
743: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
744: hr_utility.raise_error;
745: END IF;
746: --
747: END IF;
748: --

Line 755: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');

751: OPEN csr_validate_sex_par (l_person_id);
752: FETCH csr_validate_sex_par INTO l_sex ;
753: CLOSE csr_validate_sex_par;
754: IF l_sex = 'M' THEN
755: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');
756: hr_utility.raise_error;
757: END IF;
758:
759:

Line 756: hr_utility.raise_error;

752: FETCH csr_validate_sex_par INTO l_sex ;
753: CLOSE csr_validate_sex_par;
754: IF l_sex = 'M' THEN
755: hr_utility.set_message(800,'HR_ES_PAR_CHK_SEX');
756: hr_utility.raise_error;
757: END IF;
758:
759:
760: FOR i IN csr_get_other_absences(p_absence_attendance_id

Line 764: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');

760: FOR i IN csr_get_other_absences(p_absence_attendance_id
761: ,p_date_start
762: ,p_date_end) LOOP
763: IF i.absence_category IN ('PAR') THEN
764: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
765: hr_utility.raise_error;
766: END IF;
767: END LOOP;
768: -- BU Gross Pay Daily Rate Formula validation

Line 765: hr_utility.raise_error;

761: ,p_date_start
762: ,p_date_end) LOOP
763: IF i.absence_category IN ('PAR') THEN
764: hr_utility.set_message(800,'HR_ES_PAR_OVERLAP');
765: hr_utility.raise_error;
766: END IF;
767: END LOOP;
768: -- BU Gross Pay Daily Rate Formula validation
769: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN

Line 770: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

766: END IF;
767: END LOOP;
768: -- BU Gross Pay Daily Rate Formula validation
769: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
770: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
771: hr_utility.raise_error;
772: END IF;
773: --
774: END IF;

Line 771: hr_utility.raise_error;

767: END LOOP;
768: -- BU Gross Pay Daily Rate Formula validation
769: IF (p_abs_information2= 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
770: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
771: hr_utility.raise_error;
772: END IF;
773: --
774: END IF;
775: --

Line 781: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');

777: FOR i IN csr_get_other_absences(p_absence_attendance_id
778: ,p_date_start
779: ,p_date_end) LOOP
780: IF i.absence_category IN ('IE_AL') THEN
781: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');
782: hr_utility.raise_error;
783: END IF;
784: END LOOP;
785: -- BU Gross Pay Daily Rate Formula validation

Line 782: hr_utility.raise_error;

778: ,p_date_start
779: ,p_date_end) LOOP
780: IF i.absence_category IN ('IE_AL') THEN
781: hr_utility.set_message(800,'HR_ES_ADOPTION_OVERLAP');
782: hr_utility.raise_error;
783: END IF;
784: END LOOP;
785: -- BU Gross Pay Daily Rate Formula validation
786: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN

Line 787: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

783: END IF;
784: END LOOP;
785: -- BU Gross Pay Daily Rate Formula validation
786: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
787: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
788: hr_utility.raise_error;
789: END IF;
790: --
791: END IF;

Line 788: hr_utility.raise_error;

784: END LOOP;
785: -- BU Gross Pay Daily Rate Formula validation
786: IF (p_abs_information2 = 'GROSS_PAY' ) AND (p_abs_information3 IS NULL) THEN
787: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
788: hr_utility.raise_error;
789: END IF;
790: --
791: END IF;
792: --

Line 798: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');

794: FOR i IN csr_get_other_absences(p_absence_attendance_id
795: ,p_date_start
796: ,p_date_end) LOOP
797: IF i.absence_category IN ('PTM') THEN
798: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
799: hr_utility.raise_error;
800: END IF;
801: IF i.absence_category IN ('M') THEN
802: hr_utility.set_message(800,'HR_ES_M_OVERLAP');

Line 799: hr_utility.raise_error;

795: ,p_date_start
796: ,p_date_end) LOOP
797: IF i.absence_category IN ('PTM') THEN
798: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
799: hr_utility.raise_error;
800: END IF;
801: IF i.absence_category IN ('M') THEN
802: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
803: hr_utility.raise_error;

Line 802: hr_utility.set_message(800,'HR_ES_M_OVERLAP');

798: hr_utility.set_message(800,'HR_ES_PTM_OVERLAP');
799: hr_utility.raise_error;
800: END IF;
801: IF i.absence_category IN ('M') THEN
802: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
803: hr_utility.raise_error;
804: END IF;
805: END LOOP;
806: --

Line 803: hr_utility.raise_error;

799: hr_utility.raise_error;
800: END IF;
801: IF i.absence_category IN ('M') THEN
802: hr_utility.set_message(800,'HR_ES_M_OVERLAP');
803: hr_utility.raise_error;
804: END IF;
805: END LOOP;
806: --
807: OPEN csr_validate_ptm (p_absence_attendance_id

Line 813: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');

809: FETCH csr_validate_ptm INTO l_maternity_benefit_days ;
810: CLOSE csr_validate_ptm;
811: --
812: IF l_maternity_benefit_days = 0 THEN
813: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');
814: hr_utility.raise_error;
815: END IF;
816: --
817: IF l_maternity_benefit_days < 42 THEN

Line 814: hr_utility.raise_error;

810: CLOSE csr_validate_ptm;
811: --
812: IF l_maternity_benefit_days = 0 THEN
813: hr_utility.set_message(800,'HR_ES_M_NOT_FOUND');
814: hr_utility.raise_error;
815: END IF;
816: --
817: IF l_maternity_benefit_days < 42 THEN
818: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');

Line 818: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');

814: hr_utility.raise_error;
815: END IF;
816: --
817: IF l_maternity_benefit_days < 42 THEN
818: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');
819: hr_utility.raise_error;
820: END IF;
821: -- BU Gross Pay Daily Rate Formula validation
822: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN

Line 819: hr_utility.raise_error;

815: END IF;
816: --
817: IF l_maternity_benefit_days < 42 THEN
818: hr_utility.set_message(800,'HR_ES_PTM_CANT_COMMENCE');
819: hr_utility.raise_error;
820: END IF;
821: -- BU Gross Pay Daily Rate Formula validation
822: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN
823: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

Line 823: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');

819: hr_utility.raise_error;
820: END IF;
821: -- BU Gross Pay Daily Rate Formula validation
822: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN
823: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
824: hr_utility.raise_error;
825: END IF;
826: --
827: END IF;

Line 824: hr_utility.raise_error;

820: END IF;
821: -- BU Gross Pay Daily Rate Formula validation
822: IF (p_abs_information4 = 'GROSS_PAY' ) AND (p_abs_information5 IS NULL) THEN
823: hr_utility.set_message(800, 'HR_ES_BU_RATE_FORMULA_MISSING');
824: hr_utility.raise_error;
825: END IF;
826: --
827: END IF;
828: --