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

Line 32: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

28: begin
29:
30: --
31: /* Added for GSI Bug 5472781 */
32: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
33: hr_utility.set_location('Leaving : '||l_proc , 10);
34: return;
35: END IF;
36: --

Line 33: hr_utility.set_location('Leaving : '||l_proc , 10);

29:
30: --
31: /* Added for GSI Bug 5472781 */
32: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
33: hr_utility.set_location('Leaving : '||l_proc , 10);
34: return;
35: END IF;
36: --
37: -- get the values of the person_id profile

Line 55: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');

51: IF (p_abs_information9 IS NOT NULL
52: OR p_abs_information10 IS NOT NULL
53: OR p_abs_information11 IS NOT NULL
54: OR p_abs_information12 IS NOT NULL) THEN
55: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');
56: hr_utility.raise_error;
57: END IF;
58: -- #3040003
59: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt

Line 56: hr_utility.raise_error;

52: OR p_abs_information10 IS NOT NULL
53: OR p_abs_information11 IS NOT NULL
54: OR p_abs_information12 IS NOT NULL) THEN
55: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');
56: hr_utility.raise_error;
57: END IF;
58: -- #3040003
59: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
60: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');

Line 60: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');

56: hr_utility.raise_error;
57: END IF;
58: -- #3040003
59: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
60: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');
61: hr_utility.raise_error;
62: END IF;
63:
64: --

Line 61: hr_utility.raise_error;

57: END IF;
58: -- #3040003
59: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
60: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');
61: hr_utility.raise_error;
62: END IF;
63:
64: --
65: END IF;

Line 79: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');

75: Or p_abs_information7 Is Not Null
76: Or p_abs_information8 Is Not Null
77: Or p_abs_information9 Is Not Null) Then
78:
79: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');
80: hr_utility.raise_error;
81: End If;
82: --
83: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or

Line 80: hr_utility.raise_error;

76: Or p_abs_information8 Is Not Null
77: Or p_abs_information9 Is Not Null) Then
78:
79: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');
80: hr_utility.raise_error;
81: End If;
82: --
83: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or
84: fnd_date.canonical_to_date(p_abs_information4) > p_date_end ) Then

Line 85: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');

81: End If;
82: --
83: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or
84: fnd_date.canonical_to_date(p_abs_information4) > p_date_end ) Then
85: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');
86: hr_utility.raise_error;
87: End If;
88: --
89:

Line 86: hr_utility.raise_error;

82: --
83: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or
84: fnd_date.canonical_to_date(p_abs_information4) > p_date_end ) Then
85: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');
86: hr_utility.raise_error;
87: End If;
88: --
89:
90: ElsIf p_abs_information_category = 'FR_FR_ADOPTION' Then

Line 100: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');

96: and legislation_code = 'FR'
97: and business_group_id is null;
98: --
99: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
100: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
101: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
102: hr_utility.raise_error;
103: End If;
104: --

Line 101: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);

97: and business_group_id is null;
98: --
99: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
100: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
101: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
102: hr_utility.raise_error;
103: End If;
104: --
105:

Line 102: hr_utility.raise_error;

98: --
99: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
100: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
101: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
102: hr_utility.raise_error;
103: End If;
104: --
105:
106: End If;

Line 141: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

137: --
138: begin
139: --
140: /* Added for GSI Bug 5472781 */
141: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
142: hr_utility.set_location('Leaving : '||l_proc , 10);
143: return;
144: END IF;
145: --

Line 142: hr_utility.set_location('Leaving : '||l_proc , 10);

138: begin
139: --
140: /* Added for GSI Bug 5472781 */
141: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
142: hr_utility.set_location('Leaving : '||l_proc , 10);
143: return;
144: END IF;
145: --
146: open get_person_id(p_absence_attendance_id);

Line 165: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');

161: IF (p_abs_information9 IS NOT NULL
162: OR p_abs_information10 IS NOT NULL
163: OR p_abs_information11 IS NOT NULL
164: OR p_abs_information12 IS NOT NULL) THEN
165: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');
166: hr_utility.raise_error;
167: END IF;
168: -- #3040003
169: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt

Line 166: hr_utility.raise_error;

162: OR p_abs_information10 IS NOT NULL
163: OR p_abs_information11 IS NOT NULL
164: OR p_abs_information12 IS NOT NULL) THEN
165: hr_utility.set_message(801,'PAY_75030_INV_ELIGIBILITY_SEG');
166: hr_utility.raise_error;
167: END IF;
168: -- #3040003
169: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
170: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');

Line 170: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');

166: hr_utility.raise_error;
167: END IF;
168: -- #3040003
169: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
170: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');
171: hr_utility.raise_error;
172: END IF;
173:
174: --

Line 171: hr_utility.raise_error;

167: END IF;
168: -- #3040003
169: IF (p_abs_information7 IS NOT NULL) THEN --IJSS Inelig dt
170: hr_utility.set_message(801,'PAY_75079_INV_IJSS_INELIG_DT');
171: hr_utility.raise_error;
172: END IF;
173:
174: --
175: END IF;

Line 189: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');

185: Or p_abs_information7 Is Not Null
186: Or p_abs_information8 Is Not Null
187: Or p_abs_information9 Is Not Null) Then
188:
189: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');
190: hr_utility.raise_error;
191:
192: End If;
193:

Line 190: hr_utility.raise_error;

186: Or p_abs_information8 Is Not Null
187: Or p_abs_information9 Is Not Null) Then
188:
189: hr_utility.set_message(801,'PAY_75044_INV_MATERNITY_SEG');
190: hr_utility.raise_error;
191:
192: End If;
193:
194: --

Line 198: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');

194: --
195: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or
196: fnd_date.canonical_to_date(p_abs_information4) > p_date_end ) Then
197:
198: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');
199: hr_utility.raise_error;
200:
201: End If;
202: --

Line 199: hr_utility.raise_error;

195: If (fnd_date.canonical_to_date(p_abs_information4) < p_date_start or
196: fnd_date.canonical_to_date(p_abs_information4) > p_date_end ) Then
197:
198: hr_utility.set_message(801,'PAY_75045_INV_MAT_CONFINE_DATE');
199: hr_utility.raise_error;
200:
201: End If;
202: --
203:

Line 214: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');

210: and legislation_code = 'FR'
211: and business_group_id is null;
212: --
213: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
214: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
215: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
216: hr_utility.raise_error;
217: End If;
218: --

Line 215: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);

211: and business_group_id is null;
212: --
213: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
214: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
215: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
216: hr_utility.raise_error;
217: End If;
218: --
219:

Line 216: hr_utility.raise_error;

212: --
213: If p_abs_information7 < l_adoption_spouse_min_leave And p_abs_information7 <> 0 Then
214: hr_utility.set_message(801,'PAY_75046_ADPT_MIN_SPOUSE_LVE');
215: hr_utility.set_message_token(801,'GLOBAL_VAL',l_adoption_spouse_min_leave);
216: hr_utility.raise_error;
217: End If;
218: --
219:
220: End If;

Line 246: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

242:
243: BEGIN
244: --
245: /* Added for GSI Bug 5472781 */
246: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
247: hr_utility.set_location('Leaving : '||l_proc , 10);
248: return;
249: END IF;
250: --

Line 247: hr_utility.set_location('Leaving : '||l_proc , 10);

243: BEGIN
244: --
245: /* Added for GSI Bug 5472781 */
246: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
247: hr_utility.set_location('Leaving : '||l_proc , 10);
248: return;
249: END IF;
250: --
251: hr_utility.set_location('Entering hook Person_entry_Create',10);

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

247: hr_utility.set_location('Leaving : '||l_proc , 10);
248: return;
249: END IF;
250: --
251: hr_utility.set_location('Entering hook Person_entry_Create',10);
252: If p_abs_information_category = 'FR_S' then
253: hr_utility.set_location(' IN Create User hook ',20);
254: HR_PERSON_ABSENCE_API.get_absence_element
255: (p_absence_attendance_id => p_absence_attendance_id

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

249: END IF;
250: --
251: hr_utility.set_location('Entering hook Person_entry_Create',10);
252: If p_abs_information_category = 'FR_S' then
253: hr_utility.set_location(' IN Create User hook ',20);
254: HR_PERSON_ABSENCE_API.get_absence_element
255: (p_absence_attendance_id => p_absence_attendance_id
256: ,p_element_entry_id => l_element_entry_id
257: ,p_effective_start_date => l_effective_start_date

Line 259: hr_utility.set_location(' IN Create, setting subpriority for entry_id='||l_element_entry_id,30);

255: (p_absence_attendance_id => p_absence_attendance_id
256: ,p_element_entry_id => l_element_entry_id
257: ,p_effective_start_date => l_effective_start_date
258: ,p_effective_end_date => l_effective_end_date);
259: hr_utility.set_location(' IN Create, setting subpriority for entry_id='||l_element_entry_id,30);
260:
261: SELECT max(object_version_number) INTO l_ovn
262: FROM pay_element_entries_f
263: WHERE element_entry_id = l_element_entry_id;

Line 268: hr_utility.set_location(' IN Create, sub='||l_sub||' ovn='||l_ovn,30);

264:
265: SELECT to_number(substr(to_char(p_date_start,'J'),4,4)) INTO l_sub
266: FROM dual;
267:
268: hr_utility.set_location(' IN Create, sub='||l_sub||' ovn='||l_ovn,30);
269:
270: PAY_ELEMENT_ENTRY_API.update_element_entry
271: (p_validate => FALSE
272: ,p_datetrack_update_mode => 'CORRECTION'

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

280: ,p_update_warning => l_o_warning);
281:
282:
283: END IF;
284: hr_utility.set_location('Leaving hook Person_entry_Create',90);
285: END PERSON_ENTRY_CREATE;
286: --
287: procedure PERSON_ENTRY_UPDATE(
288: p_absence_attendance_id IN Number

Line 306: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

302:
303: BEGIN
304: --
305: /* Added for GSI Bug 5472781 */
306: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
307: hr_utility.set_location('Leaving : '||l_proc , 10);
308: return;
309: END IF;
310: --

Line 307: hr_utility.set_location('Leaving : '||l_proc , 10);

303: BEGIN
304: --
305: /* Added for GSI Bug 5472781 */
306: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
307: hr_utility.set_location('Leaving : '||l_proc , 10);
308: return;
309: END IF;
310: --
311: hr_utility.set_location('Entering hook Person_entry_Update',10);

Line 311: hr_utility.set_location('Entering hook Person_entry_Update',10);

307: hr_utility.set_location('Leaving : '||l_proc , 10);
308: return;
309: END IF;
310: --
311: hr_utility.set_location('Entering hook Person_entry_Update',10);
312: If p_abs_information_category = 'FR_S' then
313: hr_utility.set_location(' IN Update User hook ',20);
314: HR_PERSON_ABSENCE_API.get_absence_element
315: (p_absence_attendance_id => p_absence_attendance_id

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

309: END IF;
310: --
311: hr_utility.set_location('Entering hook Person_entry_Update',10);
312: If p_abs_information_category = 'FR_S' then
313: hr_utility.set_location(' IN Update User hook ',20);
314: HR_PERSON_ABSENCE_API.get_absence_element
315: (p_absence_attendance_id => p_absence_attendance_id
316: ,p_element_entry_id => l_element_entry_id
317: ,p_effective_start_date => l_effective_start_date

Line 319: hr_utility.set_location(' IN Update, setting subpriority for entry_id='||l_element_entry_id,30);

315: (p_absence_attendance_id => p_absence_attendance_id
316: ,p_element_entry_id => l_element_entry_id
317: ,p_effective_start_date => l_effective_start_date
318: ,p_effective_end_date => l_effective_end_date);
319: hr_utility.set_location(' IN Update, setting subpriority for entry_id='||l_element_entry_id,30);
320:
321: SELECT max(object_version_number) INTO l_ovn
322: FROM pay_element_entries_f
323: WHERE element_entry_id = l_element_entry_id;

Line 332: hr_utility.set_location(' IN Update, sub='||l_sub||' ovn='||l_ovn,30);

328:
329: SELECT to_number(substr(to_char(p_date_start,'J'),4,4)) INTO l_sub
330: FROM dual;
331:
332: hr_utility.set_location(' IN Update, sub='||l_sub||' ovn='||l_ovn,30);
333:
334: PAY_ELEMENT_ENTRY_API.update_element_entry
335: (p_validate => FALSE
336: ,p_datetrack_update_mode => 'CORRECTION'

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

345:
346:
347:
348: END IF;
349: hr_utility.set_location('Leaving hook Person_entry_Update',90);
350: END PERSON_ENTRY_UPDATE;
351: --
352: -- procedure added for checking additional holiday entitlements
353: PROCEDURE CHECK_ADD_ABS_ENT_CREATE(p_absence_days in number,

Line 414: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

410: --
411: begin
412: --
413: /* Added for GSI Bug 5472781 */
414: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
415: hr_utility.set_location('Leaving : '|| l_proc , 22);
416: return;
417: END IF;
418: --

Line 415: hr_utility.set_location('Leaving : '|| l_proc , 22);

411: begin
412: --
413: /* Added for GSI Bug 5472781 */
414: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
415: hr_utility.set_location('Leaving : '|| l_proc , 22);
416: return;
417: END IF;
418: --
419:

Line 420: hr_utility.set_location('Entering entilement check user hook', 22);

416: return;
417: END IF;
418: --
419:
420: hr_utility.set_location('Entering entilement check user hook', 22);
421: -- Get accrual plan details
422: open csr_get_accrual_plan;
423: fetch csr_get_accrual_plan into l_accrual_plan_id,l_absence_type;
424: close csr_get_accrual_plan;

Line 425: hr_utility.set_location('Absence type is : '||l_absence_type,22);

421: -- Get accrual plan details
422: open csr_get_accrual_plan;
423: fetch csr_get_accrual_plan into l_accrual_plan_id,l_absence_type;
424: close csr_get_accrual_plan;
425: hr_utility.set_location('Absence type is : '||l_absence_type,22);
426: --
427: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
428: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
429: p_accrual_plan_id => l_accrual_plan_id

Line 444: hr_utility.set_location('total entitlements are :'||l_ent_m, 22);

440: l_hiredate,
441: p_date_start);
442: fetch csr_get_ent into l_ent_m;
443: close csr_get_ent;
444: hr_utility.set_location('total entitlements are :'||l_ent_m, 22);
445: -- Check for sum of existing absences against additional entitlements
446: open csr_exist_abs(l_hiredate);
447: fetch csr_exist_abs into l_exist_absence;
448: close csr_exist_abs;

Line 452: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);

448: close csr_exist_abs;
449: IF l_exist_absence IS NULL THEN
450: l_exist_absence := 0;
451: END IF;
452: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);
453: --
454: l_net_entitlement := l_ent_m - l_exist_absence - p_absence_days;
455: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
456: IF l_net_entitlement <0 THEN

Line 455: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);

451: END IF;
452: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);
453: --
454: l_net_entitlement := l_ent_m - l_exist_absence - p_absence_days;
455: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
456: IF l_net_entitlement <0 THEN
457: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
458: -- replaced by a different function and message
459: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');

Line 459: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');

455: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
456: IF l_net_entitlement <0 THEN
457: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
458: -- replaced by a different function and message
459: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');
460: hr_utility.raise_error;
461: --
462: END IF;
463: --

Line 460: hr_utility.raise_error;

456: IF l_net_entitlement <0 THEN
457: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
458: -- replaced by a different function and message
459: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');
460: hr_utility.raise_error;
461: --
462: END IF;
463: --
464: END IF;-- check for absence type

Line 465: hr_utility.set_location('Leaving entilement check user hook', 22);

461: --
462: END IF;
463: --
464: END IF;-- check for absence type
465: hr_utility.set_location('Leaving entilement check user hook', 22);
466: END CHECK_ADD_ABS_ENT_CREATE;
467: --
468: PROCEDURE CHECK_ADD_ABS_ENT_UPDATE(p_absence_days in number,
469: p_absence_attendance_id in number,

Line 539: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

535: --
536: begin
537: --
538: /* Added for GSI Bug 5472781 */
539: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
540: hr_utility.set_location('Leaving : '|| l_proc , 22);
541: return;
542: END IF;
543: --

Line 540: hr_utility.set_location('Leaving : '|| l_proc , 22);

536: begin
537: --
538: /* Added for GSI Bug 5472781 */
539: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
540: hr_utility.set_location('Leaving : '|| l_proc , 22);
541: return;
542: END IF;
543: --
544: hr_utility.set_location('Entering entilement update user hook', 22);

Line 544: hr_utility.set_location('Entering entilement update user hook', 22);

540: hr_utility.set_location('Leaving : '|| l_proc , 22);
541: return;
542: END IF;
543: --
544: hr_utility.set_location('Entering entilement update user hook', 22);
545: -- Get accrual plan details
546: open csr_get_accrual_plan;
547: fetch csr_get_accrual_plan into l_accrual_plan_id,l_absence_type, l_person_id, l_absence_attendance_type_id;
548: close csr_get_accrual_plan;

Line 549: hr_utility.set_location('Absence type is : '||l_absence_type, 22);

545: -- Get accrual plan details
546: open csr_get_accrual_plan;
547: fetch csr_get_accrual_plan into l_accrual_plan_id,l_absence_type, l_person_id, l_absence_attendance_type_id;
548: close csr_get_accrual_plan;
549: hr_utility.set_location('Absence type is : '||l_absence_type, 22);
550: --
551: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
552: hr_utility.set_location('Absence is additional type', 22);
553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);

Line 552: hr_utility.set_location('Absence is additional type', 22);

548: close csr_get_accrual_plan;
549: hr_utility.set_location('Absence type is : '||l_absence_type, 22);
550: --
551: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
552: hr_utility.set_location('Absence is additional type', 22);
553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);
554: hr_utility.set_location('Accrual Date is : '||to_char(p_date_start),22);
555: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
556: p_accrual_plan_id => l_accrual_plan_id

Line 553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);

549: hr_utility.set_location('Absence type is : '||l_absence_type, 22);
550: --
551: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
552: hr_utility.set_location('Absence is additional type', 22);
553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);
554: hr_utility.set_location('Accrual Date is : '||to_char(p_date_start),22);
555: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
556: p_accrual_plan_id => l_accrual_plan_id
557: ,p_accrual_date => p_date_start );

Line 554: hr_utility.set_location('Accrual Date is : '||to_char(p_date_start),22);

550: --
551: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
552: hr_utility.set_location('Absence is additional type', 22);
553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);
554: hr_utility.set_location('Accrual Date is : '||to_char(p_date_start),22);
555: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
556: p_accrual_plan_id => l_accrual_plan_id
557: ,p_accrual_date => p_date_start );
558: -- Get the hire date

Line 563: hr_utility.set_location('Hiredate is : '||to_char(l_hiredate),22);

559: -- to get the date range for checking absence
560: open csr_assg_hiredate(l_person_id);
561: fetch csr_assg_hiredate into l_hiredate;
562: close csr_assg_hiredate;
563: hr_utility.set_location('Hiredate is : '||to_char(l_hiredate),22);
564: -- Calculate the sum of total entitlements created for this accrual plan
565: -- within the hire date and absence start date
566: hr_utility.set_location('Entilements input id is : '||to_char(l_fr_plan_info.ent_m_iv_id),22);
567: hr_utility.set_location('Accrual date input id is : '||to_char(l_fr_plan_info.ent_accrual_date_iv_id), 22);

Line 566: hr_utility.set_location('Entilements input id is : '||to_char(l_fr_plan_info.ent_m_iv_id),22);

562: close csr_assg_hiredate;
563: hr_utility.set_location('Hiredate is : '||to_char(l_hiredate),22);
564: -- Calculate the sum of total entitlements created for this accrual plan
565: -- within the hire date and absence start date
566: hr_utility.set_location('Entilements input id is : '||to_char(l_fr_plan_info.ent_m_iv_id),22);
567: hr_utility.set_location('Accrual date input id is : '||to_char(l_fr_plan_info.ent_accrual_date_iv_id), 22);
568: -- modified cursor call
569: open csr_get_ent(l_fr_plan_info.ent_m_iv_id,
570: l_hiredate,

Line 567: hr_utility.set_location('Accrual date input id is : '||to_char(l_fr_plan_info.ent_accrual_date_iv_id), 22);

563: hr_utility.set_location('Hiredate is : '||to_char(l_hiredate),22);
564: -- Calculate the sum of total entitlements created for this accrual plan
565: -- within the hire date and absence start date
566: hr_utility.set_location('Entilements input id is : '||to_char(l_fr_plan_info.ent_m_iv_id),22);
567: hr_utility.set_location('Accrual date input id is : '||to_char(l_fr_plan_info.ent_accrual_date_iv_id), 22);
568: -- modified cursor call
569: open csr_get_ent(l_fr_plan_info.ent_m_iv_id,
570: l_hiredate,
571: p_date_start,

Line 575: hr_utility.set_location('total entitlements are :'||l_ent_m, 22);

571: p_date_start,
572: l_person_id);
573: fetch csr_get_ent into l_ent_m;
574: close csr_get_ent;
575: hr_utility.set_location('total entitlements are :'||l_ent_m, 22);
576: -- Check for sum of existing absences against additional entitlements
577: open csr_exist_abs(l_person_id,l_absence_attendance_type_id,l_hiredate);
578: fetch csr_exist_abs into l_exist_absence;
579: close csr_exist_abs;

Line 583: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);

579: close csr_exist_abs;
580: IF l_exist_absence IS NULL THEN
581: l_exist_absence := 0;
582: END IF;
583: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);
584: --
585: l_net_entitlement := l_ent_m - l_exist_absence - p_absence_days;
586: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
587: IF l_net_entitlement <0 THEN

Line 586: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);

582: END IF;
583: hr_utility.set_location('Total absences are : '||l_exist_absence, 22);
584: --
585: l_net_entitlement := l_ent_m - l_exist_absence - p_absence_days;
586: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
587: IF l_net_entitlement <0 THEN
588: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
589: -- replaced by a different function and message
590: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');

Line 590: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');

586: hr_utility.set_location('Net entitlements are : '||l_net_entitlement, 22);
587: IF l_net_entitlement <0 THEN
588: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
589: -- replaced by a different function and message
590: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');
591: hr_utility.raise_error;
592: --
593: END IF;
594: --

Line 591: hr_utility.raise_error;

587: IF l_net_entitlement <0 THEN
588: -- fnd_message.set_name('PER','HR_EMP_NOT_ENTITLED');
589: -- replaced by a different function and message
590: hr_utility.set_message(801,'PAY_75197_ADD_ENT_EXCEED');
591: hr_utility.raise_error;
592: --
593: END IF;
594: --
595: END IF;-- check for absence type

Line 596: hr_utility.set_location('Leaving entilement update user hook', 22);

592: --
593: END IF;
594: --
595: END IF;-- check for absence type
596: hr_utility.set_location('Leaving entilement update user hook', 22);
597: --
598: END CHECK_ADD_ABS_ENT_UPDATE;
599:
600:

Line 640: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

636: --
637: BEGIN
638: --
639: /* Added for GSI Bug 5472781 */
640: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
641: hr_utility.set_location('Leaving : '|| l_proc , 10);
642: return;
643: END IF;
644: --

Line 641: hr_utility.set_location('Leaving : '|| l_proc , 10);

637: BEGIN
638: --
639: /* Added for GSI Bug 5472781 */
640: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
641: hr_utility.set_location('Leaving : '|| l_proc , 10);
642: return;
643: END IF;
644: --
645: IF p_abs_information_category = 'FR_TRAINING_ABSENCE' THEN

Line 649: hr_utility.set_message(800,'PER_75093_TRG_CATG_OUT_HRS');

645: IF p_abs_information_category = 'FR_TRAINING_ABSENCE' THEN
646: IF p_abs_information1 NOT IN ('OTHER', 'PP')
647: AND p_abs_information20 IS NOT NULL THEN
648: -- raise error
649: hr_utility.set_message(800,'PER_75093_TRG_CATG_OUT_HRS');
650: hr_utility.raise_error;
651: END IF;
652: -- added for bug#4104220
653: IF p_abs_information18 = 'Y' THEN

Line 650: hr_utility.raise_error;

646: IF p_abs_information1 NOT IN ('OTHER', 'PP')
647: AND p_abs_information20 IS NOT NULL THEN
648: -- raise error
649: hr_utility.set_message(800,'PER_75093_TRG_CATG_OUT_HRS');
650: hr_utility.raise_error;
651: END IF;
652: -- added for bug#4104220
653: IF p_abs_information18 = 'Y' THEN
654: IF p_abs_information19 IS NOT NULL

Line 683: hr_utility.set_message(800,'PER_75097_DIF_TRG_PLAN');

679: OR (p_abs_information22 IS NOT NULL
680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)
681: THEN
682: -- raise an error
683: hr_utility.set_message(800,'PER_75097_DIF_TRG_PLAN');
684: hr_utility.raise_error;
685: END IF;
686: END IF;
687: -- added for validating leave category

Line 684: hr_utility.raise_error;

680: AND fnd_number.canonical_to_number(p_abs_information22)<>0)
681: THEN
682: -- raise an error
683: hr_utility.set_message(800,'PER_75097_DIF_TRG_PLAN');
684: hr_utility.raise_error;
685: END IF;
686: END IF;
687: -- added for validating leave category
688: IF p_abs_information1 = 'TRAINING_CREDIT' THEN

Line 696: hr_utility.set_message(800,'PER_75098_TRG_CATG_END_DATE');

692: --
693: IF p_date_start is not null
694: AND p_date_start > l_value_end_date THEN
695: -- raise error
696: hr_utility.set_message(800,'PER_75098_TRG_CATG_END_DATE');
697: hr_utility.raise_error;
698: --
699: END IF;
700: END IF;

Line 697: hr_utility.raise_error;

693: IF p_date_start is not null
694: AND p_date_start > l_value_end_date THEN
695: -- raise error
696: hr_utility.set_message(800,'PER_75098_TRG_CATG_END_DATE');
697: hr_utility.raise_error;
698: --
699: END IF;
700: END IF;
701: END IF;