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

Line 110: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');

106:
107: ln_daily_rate number;
108: ln_no_of_days number;
109: BEGIN
110: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
111:
112: -- Initialization Code
113: ln_daily_rate := 0;
114:

Line 119: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);

115: -- Get the number of days between Start Date and End Date
116: ln_no_of_days := p_end_date - p_start_date + 1;
117: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
118:
119: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
120: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
121: return ln_daily_rate ;
122:
123: EXCEPTION

Line 120: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');

116: ln_no_of_days := p_end_date - p_start_date + 1;
117: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
118:
119: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
120: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
121: return ln_daily_rate ;
122:
123: EXCEPTION
124: WHEN OTHERS THEN

Line 211: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');

207: ld_rec_ele_start_date DATE;
208: ld_rec_ele_end_date DATE;
209:
210: BEGIN
211: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');
212:
213: ln_count := 0;
214: ld_rec_ele_end_date := NULL;
215: ld_rec_ele_start_date := NULL;

Line 225: hr_utility.trace('Element Name = ' || p_element_name);

221: ,lv_inp_val_name
222: ,lv_screen_entry_value;
223: exit when c_check_aug_entry%NOTFOUND;
224:
225: hr_utility.trace('Element Name = ' || p_element_name);
226: hr_utility.trace('Business Group ID = ' || p_business_group_id);
227: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
228:
229: ln_count := ln_count + 1;

Line 226: hr_utility.trace('Business Group ID = ' || p_business_group_id);

222: ,lv_screen_entry_value;
223: exit when c_check_aug_entry%NOTFOUND;
224:
225: hr_utility.trace('Element Name = ' || p_element_name);
226: hr_utility.trace('Business Group ID = ' || p_business_group_id);
227: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
228:
229: ln_count := ln_count + 1;
230:

Line 227: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);

223: exit when c_check_aug_entry%NOTFOUND;
224:
225: hr_utility.trace('Element Name = ' || p_element_name);
226: hr_utility.trace('Business Group ID = ' || p_business_group_id);
227: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
228:
229: ln_count := ln_count + 1;
230:
231: if (upper(lv_inp_val_name) = 'EARNED START DATE'

Line 254: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

250: if lb_aug_flag then
251: -- Checking for all ERROR conditions for the Augment element
252: if (ld_rec_ele_start_date IS NULL
253: AND ld_rec_ele_end_date IS NOT NULL) then
254: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
255: hr_utility.set_message_token('FORMULA_TEXT',
256: 'Please specify Earned Start Date');
257: hr_utility.raise_error;
258: elsif (ld_rec_ele_start_date IS NOT NULL

Line 255: hr_utility.set_message_token('FORMULA_TEXT',

251: -- Checking for all ERROR conditions for the Augment element
252: if (ld_rec_ele_start_date IS NULL
253: AND ld_rec_ele_end_date IS NOT NULL) then
254: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
255: hr_utility.set_message_token('FORMULA_TEXT',
256: 'Please specify Earned Start Date');
257: hr_utility.raise_error;
258: elsif (ld_rec_ele_start_date IS NOT NULL
259: AND ld_rec_ele_end_date IS NULL) then

Line 257: hr_utility.raise_error;

253: AND ld_rec_ele_end_date IS NOT NULL) then
254: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
255: hr_utility.set_message_token('FORMULA_TEXT',
256: 'Please specify Earned Start Date');
257: hr_utility.raise_error;
258: elsif (ld_rec_ele_start_date IS NOT NULL
259: AND ld_rec_ele_end_date IS NULL) then
260: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
261: hr_utility.set_message_token('FORMULA_TEXT',

Line 260: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

256: 'Please specify Earned Start Date');
257: hr_utility.raise_error;
258: elsif (ld_rec_ele_start_date IS NOT NULL
259: AND ld_rec_ele_end_date IS NULL) then
260: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
261: hr_utility.set_message_token('FORMULA_TEXT',
262: 'Please specify Earned End Date');
263: hr_utility.raise_error;
264: elsif (ld_rec_ele_start_date IS NOT NULL

Line 261: hr_utility.set_message_token('FORMULA_TEXT',

257: hr_utility.raise_error;
258: elsif (ld_rec_ele_start_date IS NOT NULL
259: AND ld_rec_ele_end_date IS NULL) then
260: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
261: hr_utility.set_message_token('FORMULA_TEXT',
262: 'Please specify Earned End Date');
263: hr_utility.raise_error;
264: elsif (ld_rec_ele_start_date IS NOT NULL
265: AND ld_rec_ele_end_date IS NOT NULL) then

Line 263: hr_utility.raise_error;

259: AND ld_rec_ele_end_date IS NULL) then
260: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
261: hr_utility.set_message_token('FORMULA_TEXT',
262: 'Please specify Earned End Date');
263: hr_utility.raise_error;
264: elsif (ld_rec_ele_start_date IS NOT NULL
265: AND ld_rec_ele_end_date IS NOT NULL) then
266: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

Line 267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

263: hr_utility.raise_error;
264: elsif (ld_rec_ele_start_date IS NOT NULL
265: AND ld_rec_ele_end_date IS NOT NULL) then
266: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
268: hr_utility.set_message_token('FORMULA_TEXT',
269: 'Please specify Earned End Date greater than Earned Start Date');
270: hr_utility.raise_error;
271: end if;

Line 268: hr_utility.set_message_token('FORMULA_TEXT',

264: elsif (ld_rec_ele_start_date IS NOT NULL
265: AND ld_rec_ele_end_date IS NOT NULL) then
266: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
268: hr_utility.set_message_token('FORMULA_TEXT',
269: 'Please specify Earned End Date greater than Earned Start Date');
270: hr_utility.raise_error;
271: end if;
272: else

Line 270: hr_utility.raise_error;

266: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
267: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
268: hr_utility.set_message_token('FORMULA_TEXT',
269: 'Please specify Earned End Date greater than Earned Start Date');
270: hr_utility.raise_error;
271: end if;
272: else
273: -- Both the Start Date and End Date are NULL
274: open c_get_period_dates(p_assignment_id

Line 279: hr_utility.trace('Updating the Element Entry values for the NR Element');

275: ,p_effective_start_date);
276: fetch c_get_period_dates into ld_rec_ele_start_date
277: ,ld_rec_ele_end_date;
278: close c_get_period_dates;
279: hr_utility.trace('Updating the Element Entry values for the NR Element');
280: -- Updating the Start Date to the Payroll Start Date
281: update pay_element_entry_values_f peev
282: set screen_entry_value = fnd_date.date_to_canonical
283: (ld_rec_ele_start_date)

Line 317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

313: ,ld_rec_ele_start_date);
314: fetch c_check_assignment_validity into ln_dummy_var;
315: if c_check_assignment_validity%NOTFOUND then
316: close c_check_assignment_validity;
317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
318: hr_utility.set_message_token('FORMULA_TEXT',
319: 'Assignment is not valid as of Earned Start Date');
320: hr_utility.raise_error;
321: end if;

Line 318: hr_utility.set_message_token('FORMULA_TEXT',

314: fetch c_check_assignment_validity into ln_dummy_var;
315: if c_check_assignment_validity%NOTFOUND then
316: close c_check_assignment_validity;
317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
318: hr_utility.set_message_token('FORMULA_TEXT',
319: 'Assignment is not valid as of Earned Start Date');
320: hr_utility.raise_error;
321: end if;
322: close c_check_assignment_validity;

Line 320: hr_utility.raise_error;

316: close c_check_assignment_validity;
317: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
318: hr_utility.set_message_token('FORMULA_TEXT',
319: 'Assignment is not valid as of Earned Start Date');
320: hr_utility.raise_error;
321: end if;
322: close c_check_assignment_validity;
323:
324: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);

Line 324: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);

320: hr_utility.raise_error;
321: end if;
322: close c_check_assignment_validity;
323:
324: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);
325: hr_utility.trace('BUSINESS GROUP ID = ' || p_business_group_id);
326: end if; -- if lb_aug_flag
327:
328: return lb_aug_flag;

Line 325: hr_utility.trace('BUSINESS GROUP ID = ' || p_business_group_id);

321: end if;
322: close c_check_assignment_validity;
323:
324: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);
325: hr_utility.trace('BUSINESS GROUP ID = ' || p_business_group_id);
326: end if; -- if lb_aug_flag
327:
328: return lb_aug_flag;
329: END CHECK_AUGMENT_ELEM;

Line 373: hr_utility.trace('Inside CHECK_PREMIUM_ELEM');

369: lb_prem_flag boolean;
370:
371: BEGIN
372:
373: hr_utility.trace('Inside CHECK_PREMIUM_ELEM');
374: lb_prem_flag := FALSE;
375: p_element_name := NULL;
376: p_processing_type := NULL;
377: p_business_group_id := NULL;

Line 386: hr_utility.trace('Premium Element');

382: fetch c_check_prem_elem into lv_element_name
383: ,ln_business_group_id
384: ,lv_processing_type;
385: if c_check_prem_elem%FOUND THEN
386: hr_utility.trace('Premium Element');
387: lb_prem_flag := TRUE;
388: p_element_name := lv_element_name;
389: p_processing_type := lv_processing_type;
390: p_business_group_id := ln_business_group_id;

Line 424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');

420: ln_ele_entry_id NUMBER;
421: ld_del_start_date DATE;
422:
423: BEGIN
424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
425: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
426: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
427:
428: open c_get_ele_entry_id(p_element_entry_id

Line 425: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);

421: ld_del_start_date DATE;
422:
423: BEGIN
424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
425: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
426: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
427:
428: open c_get_ele_entry_id(p_element_entry_id
429: ,p_assignment_id);

Line 426: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);

422:
423: BEGIN
424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
425: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
426: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
427:
428: open c_get_ele_entry_id(p_element_entry_id
429: ,p_assignment_id);
430: loop

Line 436: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);

432: fetch c_get_ele_entry_id into ln_ele_entry_id
433: ,ld_del_start_date;
434: exit when c_get_ele_entry_id%NOTFOUND;
435:
436: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);
437: hr_utility.trace('Deletion Date = ' || ld_del_start_date);
438: hr_entry_api.delete_element_entry (
439: p_dt_delete_mode => 'ZAP',
440: p_session_date => ld_del_start_date,

Line 437: hr_utility.trace('Deletion Date = ' || ld_del_start_date);

433: ,ld_del_start_date;
434: exit when c_get_ele_entry_id%NOTFOUND;
435:
436: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);
437: hr_utility.trace('Deletion Date = ' || ld_del_start_date);
438: hr_entry_api.delete_element_entry (
439: p_dt_delete_mode => 'ZAP',
440: p_session_date => ld_del_start_date,
441: p_element_entry_id => ln_ele_entry_id);

Line 444: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');

440: p_session_date => ld_del_start_date,
441: p_element_entry_id => ln_ele_entry_id);
442: end loop;
443: close c_get_ele_entry_id;
444: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
445: return;
446:
447: EXCEPTION
448: --

Line 583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');

579: ld_link_eff_end_date date;
580: ld_dummy_start_date date;
581:
582: BEGIN
583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

Line 584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);

580: ld_dummy_start_date date;
581:
582: BEGIN
583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);

Line 585: hr_utility.trace('p_start_date = ' || p_start_date);

581:
582: BEGIN
583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);

Line 586: hr_utility.trace('p_end_date = ' || p_end_date);

582: BEGIN
583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);
590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);

Line 587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);
590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
591:

Line 588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);

584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);
590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
591:
592: ld_dummy_start_date := p_start_date;

Line 589: hr_utility.trace('p_inp_value = ' || p_inp_value);

585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);
590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
591:
592: ld_dummy_start_date := p_start_date;
593: gn_ele_ent_num := 0;

Line 590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);

586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
588: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
589: hr_utility.trace('p_inp_value = ' || p_inp_value);
590: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
591:
592: ld_dummy_start_date := p_start_date;
593: gn_ele_ent_num := 0;
594: ln_element_link_id := -9999;

Line 622: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

618: -- If the assignment itself is not valid on the Start date
619: -- then throw an error saying Assignment is not valid on Start Date
620: if (gn_ele_ent_num = 0 AND ld_asgt_eff_start_date > p_start_date) then
621: close c_get_link_details;
622: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
623: hr_utility.set_message_token('FORMULA_TEXT',
624: 'Assignment is not Valid as of Earned Start Date');
625: hr_utility.raise_error;
626: end if; -- if (gn_ele_ent_num = 0 AND ....

Line 623: hr_utility.set_message_token('FORMULA_TEXT',

619: -- then throw an error saying Assignment is not valid on Start Date
620: if (gn_ele_ent_num = 0 AND ld_asgt_eff_start_date > p_start_date) then
621: close c_get_link_details;
622: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
623: hr_utility.set_message_token('FORMULA_TEXT',
624: 'Assignment is not Valid as of Earned Start Date');
625: hr_utility.raise_error;
626: end if; -- if (gn_ele_ent_num = 0 AND ....
627:

Line 625: hr_utility.raise_error;

621: close c_get_link_details;
622: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
623: hr_utility.set_message_token('FORMULA_TEXT',
624: 'Assignment is not Valid as of Earned Start Date');
625: hr_utility.raise_error;
626: end if; -- if (gn_ele_ent_num = 0 AND ....
627:
628: if ln_element_link_id <> gn_link_id_tbl(gn_ele_ent_num) then
629: gn_ele_ent_num := gn_ele_ent_num + 1;

Line 644: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);

640: gd_end_date_tbl(gn_ele_ent_num) := p_end_date;
641: else
642: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
643: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
644: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));

Line 645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);

641: else
642: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
643: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
644: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));
649: hr_utility.trace('Global End Date = ' ||

Line 646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);

642: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
643: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
644: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));
649: hr_utility.trace('Global End Date = ' ||
650: gd_end_date_tbl(gn_ele_ent_num));

Line 647: hr_utility.trace('Global Start Date = ' ||

643: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
644: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));
649: hr_utility.trace('Global End Date = ' ||
650: gd_end_date_tbl(gn_ele_ent_num));
651: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

Line 649: hr_utility.trace('Global End Date = ' ||

645: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
646: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));
649: hr_utility.trace('Global End Date = ' ||
650: gd_end_date_tbl(gn_ele_ent_num));
651: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
652: else
653: if ld_asgt_eff_end_date > ld_link_eff_end_date then

Line 651: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

647: hr_utility.trace('Global Start Date = ' ||
648: gd_start_date_tbl(gn_ele_ent_num));
649: hr_utility.trace('Global End Date = ' ||
650: gd_end_date_tbl(gn_ele_ent_num));
651: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
652: else
653: if ld_asgt_eff_end_date > ld_link_eff_end_date then
654: gd_end_date_tbl(gn_ele_ent_num) := ld_link_eff_end_date;
655: else

Line 665: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);

661: else
662: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
663: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
664:
665: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
666: hr_utility.trace('Global Start Date = ' ||
667: gd_start_date_tbl(gn_ele_ent_num));
668: hr_utility.trace('Global End Date = ' ||
669: gd_end_date_tbl(gn_ele_ent_num));

Line 666: hr_utility.trace('Global Start Date = ' ||

662: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
663: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
664:
665: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
666: hr_utility.trace('Global Start Date = ' ||
667: gd_start_date_tbl(gn_ele_ent_num));
668: hr_utility.trace('Global End Date = ' ||
669: gd_end_date_tbl(gn_ele_ent_num));
670: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

Line 668: hr_utility.trace('Global End Date = ' ||

664:
665: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
666: hr_utility.trace('Global Start Date = ' ||
667: gd_start_date_tbl(gn_ele_ent_num));
668: hr_utility.trace('Global End Date = ' ||
669: gd_end_date_tbl(gn_ele_ent_num));
670: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
671: end if; -- if ln_element_link_id <> ....
672:

Line 670: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

666: hr_utility.trace('Global Start Date = ' ||
667: gd_start_date_tbl(gn_ele_ent_num));
668: hr_utility.trace('Global End Date = ' ||
669: gd_end_date_tbl(gn_ele_ent_num));
670: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
671: end if; -- if ln_element_link_id <> ....
672:
673: end loop;
674: close c_get_link_details;

Line 677: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

673: end loop;
674: close c_get_link_details;
675:
676: if gn_ele_ent_num = 0 then
677: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
678: hr_utility.set_message_token('FORMULA_TEXT',
679: 'The assignment is not eligible for ' ||
680: p_augment_elem_name || ' for FLSA Calc.' ||
681: ' Please link the element to make it eligible to the assignment.');

Line 678: hr_utility.set_message_token('FORMULA_TEXT',

674: close c_get_link_details;
675:
676: if gn_ele_ent_num = 0 then
677: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
678: hr_utility.set_message_token('FORMULA_TEXT',
679: 'The assignment is not eligible for ' ||
680: p_augment_elem_name || ' for FLSA Calc.' ||
681: ' Please link the element to make it eligible to the assignment.');
682: hr_utility.raise_error;

Line 682: hr_utility.raise_error;

678: hr_utility.set_message_token('FORMULA_TEXT',
679: 'The assignment is not eligible for ' ||
680: p_augment_elem_name || ' for FLSA Calc.' ||
681: ' Please link the element to make it eligible to the assignment.');
682: hr_utility.raise_error;
683: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
684: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
685: hr_utility.set_message_token('FORMULA_TEXT',
686: 'The assignment is not eligible for ' ||

Line 684: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

680: p_augment_elem_name || ' for FLSA Calc.' ||
681: ' Please link the element to make it eligible to the assignment.');
682: hr_utility.raise_error;
683: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
684: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
685: hr_utility.set_message_token('FORMULA_TEXT',
686: 'The assignment is not eligible for ' ||
687: p_augment_elem_name || ' for FLSA Calc.' ||
688: ' Please link the element to make it eligible to the assignment.');

Line 685: hr_utility.set_message_token('FORMULA_TEXT',

681: ' Please link the element to make it eligible to the assignment.');
682: hr_utility.raise_error;
683: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
684: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
685: hr_utility.set_message_token('FORMULA_TEXT',
686: 'The assignment is not eligible for ' ||
687: p_augment_elem_name || ' for FLSA Calc.' ||
688: ' Please link the element to make it eligible to the assignment.');
689: hr_utility.raise_error;

Line 689: hr_utility.raise_error;

685: hr_utility.set_message_token('FORMULA_TEXT',
686: 'The assignment is not eligible for ' ||
687: p_augment_elem_name || ' for FLSA Calc.' ||
688: ' Please link the element to make it eligible to the assignment.');
689: hr_utility.raise_error;
690: end if; -- if gn_ele_ent_num = 0
691: return;
692: END POPULATE_ELE_LINK;
693:

Line 798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');

794:
795:
796: BEGIN
797:
798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);

Line 799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);

795:
796: BEGIN
797:
798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);

Line 800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);

796: BEGIN
797:
798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);

Line 801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);

797:
798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);

Line 802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);

798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);

Line 803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);

799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);

Line 804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);

800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
808:

Line 805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);

801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
808:
809: -- Initialization Code

Line 806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);

802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
808:
809: -- Initialization Code
810: ln_business_grp_id := NULL;

Line 807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);

803: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
804: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
805: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
806: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
807: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
808:
809: -- Initialization Code
810: ln_business_grp_id := NULL;
811: ld_rec_ele_start_date := NULL;

Line 843: hr_utility.trace('Rec Input Value Name = ' || l_input_value_name_tbl(lvr));

839: fetch c_get_rec_elem_inp_val_det into ln_rec_element_type_id
840: ,l_input_value_id_tbl(lvr)
841: ,l_input_value_name_tbl(lvr);
842: exit when c_get_rec_elem_inp_val_det%NOTFOUND;
843: hr_utility.trace('Rec Input Value Name = ' || l_input_value_name_tbl(lvr));
844: if upper(l_input_value_name_tbl(lvr)) = 'DAILY AMOUNT' then
845: ln_daily_amt_index := lvr;
846: end if;
847: l_entry_value_tbl(lvr) := NULL;

Line 860: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);

856: fetch c_get_elem_inp_value_details into lv_inp_value_name
857: ,lv_screen_entry_value
858: ,lv_lookup_type;
859: exit when c_get_elem_inp_value_details%NOTFOUND;
860: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
861: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
862: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
863:
864: if upper(lv_inp_value_name) = 'EARNED START DATE' then

Line 861: hr_utility.trace('Input Value = ' || lv_screen_entry_value);

857: ,lv_screen_entry_value
858: ,lv_lookup_type;
859: exit when c_get_elem_inp_value_details%NOTFOUND;
860: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
861: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
862: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
863:
864: if upper(lv_inp_value_name) = 'EARNED START DATE' then
865: if lv_screen_entry_value is null then

Line 862: hr_utility.trace('Look Up Type = ' || lv_lookup_type);

858: ,lv_lookup_type;
859: exit when c_get_elem_inp_value_details%NOTFOUND;
860: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
861: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
862: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
863:
864: if upper(lv_inp_value_name) = 'EARNED START DATE' then
865: if lv_screen_entry_value is null then
866: ld_rec_ele_start_date := NULL;

Line 871: hr_utility.trace('Start Date = ' || to_char(ld_rec_ele_start_date,'DD-MON-YYYY'));

867: exit;
868: else
869: ld_rec_ele_start_date :=
870: fnd_date.canonical_to_date(lv_screen_entry_value);
871: hr_utility.trace('Start Date = ' || to_char(ld_rec_ele_start_date,'DD-MON-YYYY'));
872: end if; -- if lv_screen_entry_value is null
873: elsif upper(lv_inp_value_name) = 'EARNED END DATE' then
874: if lv_screen_entry_value is null then
875: ld_rec_ele_end_date := NULL;

Line 880: hr_utility.trace('End Date = ' || to_char(ld_rec_ele_end_date,'DD-MON-YYYY'));

876: exit;
877: else
878: ld_rec_ele_end_date :=
879: fnd_date.canonical_to_date(lv_screen_entry_value);
880: hr_utility.trace('End Date = ' || to_char(ld_rec_ele_end_date,'DD-MON-YYYY'));
881: end if; -- if lv_screen_entry_value is null
882: elsif (upper(lv_inp_value_name) in ('AMOUNT')) THEN
883: lv_inp_value_to_divide := lv_inp_value_name;
884: ln_total_value := to_number(nvl(lv_screen_entry_value, '0'));

Line 892: hr_utility.trace('Commented Else part as not required');

888: -- for Augment which needs to be specified.
889: -- This code can be reused if we have to copy over values
890: -- from the Non recurrning element to Recurring element
891: -- in future.
892: hr_utility.trace('Commented Else part as not required');
893: /*
894: for i in l_input_value_name_tbl.first..l_input_value_name_tbl.last
895: loop
896: if l_input_value_name_tbl(i) = lv_inp_value_name then

Line 897: hr_utility.trace('Input Value Found');

893: /*
894: for i in l_input_value_name_tbl.first..l_input_value_name_tbl.last
895: loop
896: if l_input_value_name_tbl(i) = lv_inp_value_name then
897: hr_utility.trace('Input Value Found');
898: if lv_lookup_type is NOT NULL then
899: open c_get_lookup_value(lv_lookup_type
900: ,lv_screen_entry_value);
901: fetch c_get_lookup_value into lv_lookup_meaning;

Line 903: hr_utility.trace('Lookup Meaning = ' || lv_lookup_meaning);

899: open c_get_lookup_value(lv_lookup_type
900: ,lv_screen_entry_value);
901: fetch c_get_lookup_value into lv_lookup_meaning;
902: close c_get_lookup_value;
903: hr_utility.trace('Lookup Meaning = ' || lv_lookup_meaning);
904: l_entry_value_tbl(i) := lv_lookup_meaning;
905: lv_lookup_type := NULL;
906: else
907: l_entry_value_tbl(i) := lv_screen_entry_value;

Line 929: hr_utility.trace('Job is NOT FLSA Eligible');

925: ,ld_rec_ele_start_date
926: ,ld_rec_ele_end_date);
927: fetch c_check_flsa_elig_job into ln_dummy_var;
928: if c_check_flsa_elig_job%NOTFOUND then
929: hr_utility.trace('Job is NOT FLSA Eligible');
930: close c_check_flsa_elig_job;
931: return;
932: end if;
933: close c_check_flsa_elig_job;

Line 948: hr_utility.trace('Creating Recurring Element Entries');

944:
945:
946: -- Create Recurrin Element Entry
947: for lvr in 1..gn_ele_ent_num loop
948: hr_utility.trace('Creating Recurring Element Entries');
949: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
950: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
951: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
952:

Line 949: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));

945:
946: -- Create Recurrin Element Entry
947: for lvr in 1..gn_ele_ent_num loop
948: hr_utility.trace('Creating Recurring Element Entries');
949: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
950: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
951: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
952:
953: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;

Line 950: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));

946: -- Create Recurrin Element Entry
947: for lvr in 1..gn_ele_ent_num loop
948: hr_utility.trace('Creating Recurring Element Entries');
949: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
950: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
951: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
952:
953: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;
954: ld_dummy_end_date := gd_end_date_tbl(lvr);

Line 951: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);

947: for lvr in 1..gn_ele_ent_num loop
948: hr_utility.trace('Creating Recurring Element Entries');
949: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
950: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
951: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
952:
953: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;
954: ld_dummy_end_date := gd_end_date_tbl(lvr);
955:

Line 1020: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');

1016: gd_end_date_tbl.delete;
1017: gn_link_id_tbl.delete;
1018: gn_ele_ent_num := NULL;
1019: gn_daily_amount := NULL;
1020: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
1021: return;
1022:
1023: EXCEPTION
1024: --

Line 1125: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1121: l_fed_effective_start_date DATE;
1122: l_fed_effective_end_date DATE;
1123:
1124: BEGIN
1125: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1126:
1127: IF hr_general.chk_maintain_tax_records = 'Y' THEN
1128:
1129: -- Initialization Code

Line 1170: hr_utility.trace('Default Tax Rules not created for Employee.So creating them now');

1166: --Create the Default Tax Records
1167: open c_default_tax_rule(p_assignment_id);
1168: fetch c_default_tax_rule into ln_dummy;
1169: if c_default_tax_rule%NOTFOUND then
1170: hr_utility.trace('Default Tax Rules not created for Employee.So creating them now');
1171: pay_us_tax_internal.create_default_tax_rules
1172: (p_effective_date => p_effective_start_date
1173: ,p_assignment_id => p_assignment_id
1174: ,p_emp_fed_tax_rule_id => l_emp_fed_tax_rule_id

Line 1191: hr_utility.trace('Creating Tax Rule for State ' || lv_state_code);

1187: open c_state_tax_rule(p_assignment_id
1188: ,lv_state_code);
1189: fetch c_state_tax_rule into ln_dummy;
1190: if c_state_tax_rule%NOTFOUND then
1191: hr_utility.trace('Creating Tax Rule for State ' || lv_state_code);
1192: -- Create State Tax Records
1193: pay_state_tax_rule_api.create_state_tax_rule (
1194: p_effective_date => p_effective_start_date
1195: ,p_default_flag => 'Y'

Line 1215: hr_utility.trace('Creating Tax Rule for County '

1211: ,lv_state_code
1212: ,lv_county_code);
1213: fetch c_county_tax_rule into ln_dummy;
1214: if c_county_tax_rule%NOTFOUND then
1215: hr_utility.trace('Creating Tax Rule for County '
1216: || lv_county_code);
1217: -- Create County Tax Records
1218: pay_county_tax_rule_api.create_county_tax_rule (
1219: p_effective_date => p_effective_start_date

Line 1248: hr_utility.trace('Creating Tax Rule for City ' ||

1244: ,lv_county_code
1245: ,lv_city_code);
1246: fetch c_city_tax_rule into ln_dummy;
1247: if c_city_tax_rule%NOTFOUND then
1248: hr_utility.trace('Creating Tax Rule for City ' ||
1249: lv_city_code);
1250: -- Create City Tax Records
1251: pay_city_tax_rule_api.create_city_tax_rule (
1252: p_effective_date => p_effective_start_date

Line 1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1271: end if; -- if lv_city_code <> '0000'
1272: end if; -- if lv_county_code <> '000'
1273: end if; -- if lv_state_code <> '00'
1274: end if; -- if lv_jurisdiction_code
1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1276: ELSE
1277: /* hr_general.chk_maintain_tax_records = 'N' */
1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');
1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

Line 1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');

1274: end if; -- if lv_jurisdiction_code
1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1276: ELSE
1277: /* hr_general.chk_maintain_tax_records = 'N' */
1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');
1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1280: NULL;
1281: END IF;
1282: return;

Line 1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1276: ELSE
1277: /* hr_general.chk_maintain_tax_records = 'N' */
1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');
1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1280: NULL;
1281: END IF;
1282: return;
1283: END CREATE_TAX_RECORDS;

Line 1575: hr_utility.trace('Entering CREATE_PREMIUM_MOP_UP_ELEMENT');

1571: ln_link_id_tbl(0) := 0;
1572: ln_count := 0;
1573:
1574: -- Check For Premium Element
1575: hr_utility.trace('Entering CREATE_PREMIUM_MOP_UP_ELEMENT');
1576: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id
1577: ,p_effective_start_date
1578: ,lv_element_name
1579: ,lv_processing_type

Line 1583: hr_utility.trace('Getting Time Definition ID');

1579: ,lv_processing_type
1580: ,ln_business_group_id);
1581:
1582: if lb_prem_flag then
1583: hr_utility.trace('Getting Time Definition ID');
1584: -- Get the Default Time Definition ID
1585: open c_get_def_time_def_id('Non Allocated Time Definition'
1586: ,'US');
1587: fetch c_get_def_time_def_id into ln_def_time_definition_id;

Line 1590: hr_utility.trace('Element Entry ID ' || p_element_entry_id);

1586: ,'US');
1587: fetch c_get_def_time_def_id into ln_def_time_definition_id;
1588: close c_get_def_time_def_id;
1589:
1590: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1591: hr_utility.trace('Assignment ID ' || p_assignment_id);
1592: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1593: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1594:

Line 1591: hr_utility.trace('Assignment ID ' || p_assignment_id);

1587: fetch c_get_def_time_def_id into ln_def_time_definition_id;
1588: close c_get_def_time_def_id;
1589:
1590: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1591: hr_utility.trace('Assignment ID ' || p_assignment_id);
1592: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1593: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1594:
1595: -- Get the Time Definition associated with the Assignment as of

Line 1592: hr_utility.trace('Business Group ID ' || ln_business_group_id);

1588: close c_get_def_time_def_id;
1589:
1590: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1591: hr_utility.trace('Assignment ID ' || p_assignment_id);
1592: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1593: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1594:
1595: -- Get the Time Definition associated with the Assignment as of
1596: -- Premium Element Entry Start Date

Line 1593: hr_utility.trace('Eff Start Date ' || p_effective_start_date);

1589:
1590: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1591: hr_utility.trace('Assignment ID ' || p_assignment_id);
1592: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1593: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1594:
1595: -- Get the Time Definition associated with the Assignment as of
1596: -- Premium Element Entry Start Date
1597: ln_time_definition_id :=

Line 1606: hr_utility.trace('Default Time Definition ID');

1602: ,p_business_group_id => ln_business_group_id
1603: ,p_time_def_date => p_effective_start_date);
1604:
1605: if ln_time_definition_id = ln_def_time_definition_id then
1606: hr_utility.trace('Default Time Definition ID');
1607: lb_prem_flag := FALSE;
1608: end if;
1609: end if;
1610:

Line 1617: hr_utility.trace('Non Recurring Premium Element');

1613: -- we have to create a MOP UP element.
1614: if lb_prem_flag then
1615: -- Check whether it is a Non Recurring Premium or Recurring
1616: if upper(lv_processing_type) = 'N' then
1617: hr_utility.trace('Non Recurring Premium Element');
1618:
1619: open c_get_rate_entry_count(p_element_entry_id
1620: ,p_effective_start_date);
1621: fetch c_get_rate_entry_count into ln_count;

Line 1647: hr_utility.trace('Recurring Premium Element');

1643: end if;
1644: close c_get_nrec_mop_up_dates;
1645: end if; -- if ln_count > 0
1646: else
1647: hr_utility.trace('Recurring Premium Element');
1648: open c_get_rec_mop_up_dates(p_assignment_id
1649: ,p_element_entry_id
1650: ,ln_time_definition_id);
1651: fetch c_get_rec_mop_up_dates into ld_mop_up_start_date

Line 1689: hr_utility.trace('Getting Mop UP ID');

1685: close c_get_scr_entry_value;
1686: end if; -- if ln_inp_value_id is NOT NULL
1687:
1688:
1689: hr_utility.trace('Getting Mop UP ID');
1690: open c_get_elem_type_id(lv_element_name || ' for FLSA Period Adjustment'
1691: ,ln_business_group_id);
1692: fetch c_get_elem_type_id into ln_mop_up_ele_type_id;
1693: close c_get_elem_type_id;

Line 1694: hr_utility.trace('Mop Up ID : ' || ln_mop_up_ele_type_id);

1690: open c_get_elem_type_id(lv_element_name || ' for FLSA Period Adjustment'
1691: ,ln_business_group_id);
1692: fetch c_get_elem_type_id into ln_mop_up_ele_type_id;
1693: close c_get_elem_type_id;
1694: hr_utility.trace('Mop Up ID : ' || ln_mop_up_ele_type_id);
1695:
1696: ld_dummy_start_date := ld_mop_up_start_date;
1697:
1698: open c_get_link_details(ln_mop_up_ele_type_id

Line 1727: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);

1723: else
1724: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1725: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1726:
1727: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1728: hr_utility.trace('Asgt Eff End Date = ' ||
1729: ld_asgt_eff_end_date);
1730: hr_utility.trace('Link Eff End Date = ' ||
1731: ld_link_eff_end_date);

Line 1728: hr_utility.trace('Asgt Eff End Date = ' ||

1724: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1725: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1726:
1727: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1728: hr_utility.trace('Asgt Eff End Date = ' ||
1729: ld_asgt_eff_end_date);
1730: hr_utility.trace('Link Eff End Date = ' ||
1731: ld_link_eff_end_date);
1732: hr_utility.trace('Global Start Date = ' ||

Line 1730: hr_utility.trace('Link Eff End Date = ' ||

1726:
1727: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1728: hr_utility.trace('Asgt Eff End Date = ' ||
1729: ld_asgt_eff_end_date);
1730: hr_utility.trace('Link Eff End Date = ' ||
1731: ld_link_eff_end_date);
1732: hr_utility.trace('Global Start Date = ' ||
1733: ld_start_date_tbl(ln_ele_ent_num));
1734: hr_utility.trace('Global End Date = ' ||

Line 1732: hr_utility.trace('Global Start Date = ' ||

1728: hr_utility.trace('Asgt Eff End Date = ' ||
1729: ld_asgt_eff_end_date);
1730: hr_utility.trace('Link Eff End Date = ' ||
1731: ld_link_eff_end_date);
1732: hr_utility.trace('Global Start Date = ' ||
1733: ld_start_date_tbl(ln_ele_ent_num));
1734: hr_utility.trace('Global End Date = ' ||
1735: ld_end_date_tbl(ln_ele_ent_num));
1736: hr_utility.trace('Link ID = ' ||

Line 1734: hr_utility.trace('Global End Date = ' ||

1730: hr_utility.trace('Link Eff End Date = ' ||
1731: ld_link_eff_end_date);
1732: hr_utility.trace('Global Start Date = ' ||
1733: ld_start_date_tbl(ln_ele_ent_num));
1734: hr_utility.trace('Global End Date = ' ||
1735: ld_end_date_tbl(ln_ele_ent_num));
1736: hr_utility.trace('Link ID = ' ||
1737: ln_link_id_tbl(ln_ele_ent_num));
1738: else

Line 1736: hr_utility.trace('Link ID = ' ||

1732: hr_utility.trace('Global Start Date = ' ||
1733: ld_start_date_tbl(ln_ele_ent_num));
1734: hr_utility.trace('Global End Date = ' ||
1735: ld_end_date_tbl(ln_ele_ent_num));
1736: hr_utility.trace('Link ID = ' ||
1737: ln_link_id_tbl(ln_ele_ent_num));
1738: else
1739: if ld_asgt_eff_end_date > ld_link_eff_end_date then
1740: ld_end_date_tbl(ln_ele_ent_num) := ld_link_eff_end_date;

Line 1751: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);

1747: else
1748: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1749: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1750:
1751: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1752: hr_utility.trace('Global Start Date = ' ||
1753: ld_start_date_tbl(ln_ele_ent_num));
1754: hr_utility.trace('Global End Date = ' ||
1755: ld_end_date_tbl(ln_ele_ent_num));

Line 1752: hr_utility.trace('Global Start Date = ' ||

1748: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1749: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1750:
1751: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1752: hr_utility.trace('Global Start Date = ' ||
1753: ld_start_date_tbl(ln_ele_ent_num));
1754: hr_utility.trace('Global End Date = ' ||
1755: ld_end_date_tbl(ln_ele_ent_num));
1756: hr_utility.trace('Link ID = ' ||

Line 1754: hr_utility.trace('Global End Date = ' ||

1750:
1751: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1752: hr_utility.trace('Global Start Date = ' ||
1753: ld_start_date_tbl(ln_ele_ent_num));
1754: hr_utility.trace('Global End Date = ' ||
1755: ld_end_date_tbl(ln_ele_ent_num));
1756: hr_utility.trace('Link ID = ' ||
1757: ln_link_id_tbl(ln_ele_ent_num));
1758: end if; -- if ln_ele_link_id <> ....

Line 1756: hr_utility.trace('Link ID = ' ||

1752: hr_utility.trace('Global Start Date = ' ||
1753: ld_start_date_tbl(ln_ele_ent_num));
1754: hr_utility.trace('Global End Date = ' ||
1755: ld_end_date_tbl(ln_ele_ent_num));
1756: hr_utility.trace('Link ID = ' ||
1757: ln_link_id_tbl(ln_ele_ent_num));
1758: end if; -- if ln_ele_link_id <> ....
1759: end loop;
1760: close c_get_link_details;

Line 1763: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1759: end loop;
1760: close c_get_link_details;
1761:
1762: if ln_ele_ent_num = 0 then
1763: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1764: hr_utility.set_message_token('FORMULA_TEXT',
1765: 'The assignment is not eligible for ' ||
1766: lv_element_name || ' for FLSA Period Adjustment. ' ||
1767: 'Please link the element to make it eligible ' ||

Line 1764: hr_utility.set_message_token('FORMULA_TEXT',

1760: close c_get_link_details;
1761:
1762: if ln_ele_ent_num = 0 then
1763: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1764: hr_utility.set_message_token('FORMULA_TEXT',
1765: 'The assignment is not eligible for ' ||
1766: lv_element_name || ' for FLSA Period Adjustment. ' ||
1767: 'Please link the element to make it eligible ' ||
1768: 'for the assignment.');

Line 1769: hr_utility.raise_error;

1765: 'The assignment is not eligible for ' ||
1766: lv_element_name || ' for FLSA Period Adjustment. ' ||
1767: 'Please link the element to make it eligible ' ||
1768: 'for the assignment.');
1769: hr_utility.raise_error;
1770: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1771: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1772: hr_utility.set_message_token('FORMULA_TEXT',
1773: 'The assignment is not eligible for ' ||

Line 1771: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

1767: 'Please link the element to make it eligible ' ||
1768: 'for the assignment.');
1769: hr_utility.raise_error;
1770: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1771: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1772: hr_utility.set_message_token('FORMULA_TEXT',
1773: 'The assignment is not eligible for ' ||
1774: lv_element_name || ' for FLSA Period Adjustment. ' ||
1775: 'Please link the element to make it eligible ' ||

Line 1772: hr_utility.set_message_token('FORMULA_TEXT',

1768: 'for the assignment.');
1769: hr_utility.raise_error;
1770: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1771: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1772: hr_utility.set_message_token('FORMULA_TEXT',
1773: 'The assignment is not eligible for ' ||
1774: lv_element_name || ' for FLSA Period Adjustment. ' ||
1775: 'Please link the element to make it eligible ' ||
1776: 'for the assignment.');

Line 1777: hr_utility.raise_error;

1773: 'The assignment is not eligible for ' ||
1774: lv_element_name || ' for FLSA Period Adjustment. ' ||
1775: 'Please link the element to make it eligible ' ||
1776: 'for the assignment.');
1777: hr_utility.raise_error;
1778: end if; -- if gn_ele_ent_num = 0
1779:
1780: for lvr in 1..ln_ele_ent_num loop
1781: hr_utility.trace('Creating Recurring Element Entries');

Line 1781: hr_utility.trace('Creating Recurring Element Entries');

1777: hr_utility.raise_error;
1778: end if; -- if gn_ele_ent_num = 0
1779:
1780: for lvr in 1..ln_ele_ent_num loop
1781: hr_utility.trace('Creating Recurring Element Entries');
1782: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1783: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1784:
1785: ld_dummy_end_date := ld_end_date_tbl(lvr);

Line 1782: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));

1778: end if; -- if gn_ele_ent_num = 0
1779:
1780: for lvr in 1..ln_ele_ent_num loop
1781: hr_utility.trace('Creating Recurring Element Entries');
1782: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1783: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1784:
1785: ld_dummy_end_date := ld_end_date_tbl(lvr);
1786:

Line 1783: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));

1779:
1780: for lvr in 1..ln_ele_ent_num loop
1781: hr_utility.trace('Creating Recurring Element Entries');
1782: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1783: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1784:
1785: ld_dummy_end_date := ld_end_date_tbl(lvr);
1786:
1787: hr_entry_api.insert_element_entry (

Line 1810: hr_utility.trace('End dating the Element Entry Created');

1806: -- End dating the element using ld_end_date_tbl(lvr)
1807: -- as ld_dummy_end_date gets overwritten by the
1808: -- previous call
1809: if ld_dummy_end_date <> ld_end_date_tbl(lvr) then
1810: hr_utility.trace('End dating the Element Entry Created');
1811: hr_entry_api.delete_element_entry (
1812: p_dt_delete_mode => 'DELETE',
1813: p_session_date => ld_end_date_tbl(lvr),
1814: p_element_entry_id => ln_element_entry_id);

Line 1852: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');

1848: ,p_entry_type in varchar2
1849: ,p_entry_information_category in varchar2) IS
1850: BEGIN
1851:
1852: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1853: -- Call CREATE_RECUR_ELEM_ENTRY
1854: -- The package has the check built in for identifying Augment Elements
1855: CREATE_RECUR_ELEM_ENTRY(p_element_entry_id
1856: ,p_effective_start_date

Line 1887: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');

1883: ,p_original_entry_id
1884: ,p_creator_type
1885: ,p_entry_type
1886: ,p_entry_information_category);
1887: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1888: return;
1889: END INSERT_USER_HOOK;
1890:
1891: -----------------------------INSERT SECTION ENDS HERE--------------------------

Line 1993: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');

1989: l_entry_value_tbl hr_entry.varchar2_table;
1990:
1991: BEGIN
1992:
1993: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
1994:
1995: -- Initialization
1996: ld_rec_ele_start_date := hr_api.g_date;
1997: ld_rec_ele_end_date := hr_api.g_date;

Line 2048: hr_utility.trace('Previous Start Date = ' || ld_rec_ele_start_date);

2044: ld_rec_ele_end_date := ld_eff_end_date;
2045: end loop;
2046: close c_get_rec_elem_details;
2047:
2048: hr_utility.trace('Previous Start Date = ' || ld_rec_ele_start_date);
2049: hr_utility.trace('Previous End Date = ' || ld_rec_ele_end_date);
2050:
2051: -- Get the Start Date, End Date and Amount specified in the
2052: -- Non-recurring augment element

Line 2049: hr_utility.trace('Previous End Date = ' || ld_rec_ele_end_date);

2045: end loop;
2046: close c_get_rec_elem_details;
2047:
2048: hr_utility.trace('Previous Start Date = ' || ld_rec_ele_start_date);
2049: hr_utility.trace('Previous End Date = ' || ld_rec_ele_end_date);
2050:
2051: -- Get the Start Date, End Date and Amount specified in the
2052: -- Non-recurring augment element
2053: open c_get_aug_entry_details(p_element_entry_id

Line 2063: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);

2059:
2060: if upper(lv_inp_val_name) = 'EARNED START DATE' then
2061: ld_new_rec_ele_start_date :=
2062: fnd_date.canonical_to_date(lv_screen_entry_value);
2063: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
2064: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
2065: ld_new_rec_ele_end_date :=
2066: fnd_date.canonical_to_date(lv_screen_entry_value);
2067: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);

Line 2067: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);

2063: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
2064: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
2065: ld_new_rec_ele_end_date :=
2066: fnd_date.canonical_to_date(lv_screen_entry_value);
2067: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
2068: elsif upper(lv_inp_val_name) = 'AMOUNT' then
2069: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
2070: hr_utility.trace('New Amount = ' || ln_total_amount);
2071: end if; -- if upper(lv_inp_val_name) = 'START DATE'

Line 2070: hr_utility.trace('New Amount = ' || ln_total_amount);

2066: fnd_date.canonical_to_date(lv_screen_entry_value);
2067: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
2068: elsif upper(lv_inp_val_name) = 'AMOUNT' then
2069: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
2070: hr_utility.trace('New Amount = ' || ln_total_amount);
2071: end if; -- if upper(lv_inp_val_name) = 'START DATE'
2072: end loop;
2073: close c_get_aug_entry_details;
2074:

Line 2101: hr_utility.trace('Deleting Old Recurring Element Entries');

2097: if (ld_rec_ele_start_date <> ld_new_rec_ele_start_date OR
2098: ld_rec_ele_end_date <> ld_new_rec_ele_end_date OR
2099: lv_penny_issue_au <> lv_penny_issue_bu) then
2100: -- Deleting the Recurring element entries previously created
2101: hr_utility.trace('Deleting Old Recurring Element Entries');
2102: if l_elem_entry_id_tbl.count() > 0 then
2103: for lvar in l_elem_entry_id_tbl.first..l_elem_entry_id_tbl.last loop
2104: hr_entry_api.delete_element_entry (
2105: p_dt_delete_mode => 'ZAP',

Line 2112: hr_utility.trace('Creating New Recurring Element Entries');

2108: end loop; -- for lvar in l_elem_entry_id_tbl
2109: end if; -- if l_elem_entry_id_tbl.count()
2110:
2111: -- Recreating New recurring element entries
2112: hr_utility.trace('Creating New Recurring Element Entries');
2113: PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY(
2114: p_element_entry_id
2115: ,p_effective_start_date
2116: ,p_effective_end_date

Line 2124: hr_utility.trace('Updating Recurring Amount Values');

2120: ,p_creator_type_o
2121: ,p_entry_type_o
2122: ,p_entry_information_category_o);
2123: else
2124: hr_utility.trace('Updating Recurring Amount Values');
2125: -- No changes have been made to Start Date and End Date
2126: hr_utility.trace('New Daily Amount = ' || ln_daily_amount);
2127:
2128: -- Get the Input Value ID to be changed

Line 2126: hr_utility.trace('New Daily Amount = ' || ln_daily_amount);

2122: ,p_entry_information_category_o);
2123: else
2124: hr_utility.trace('Updating Recurring Amount Values');
2125: -- No changes have been made to Start Date and End Date
2126: hr_utility.trace('New Daily Amount = ' || ln_daily_amount);
2127:
2128: -- Get the Input Value ID to be changed
2129: open c_get_inp_value_id(lv_element_name
2130: ,ln_business_grp_id);

Line 2133: hr_utility.trace('No Input Value to be modified');

2129: open c_get_inp_value_id(lv_element_name
2130: ,ln_business_grp_id);
2131: fetch c_get_inp_value_id into l_input_value_id_tbl(1);
2132: if c_get_inp_value_id%NOTFOUND then
2133: hr_utility.trace('No Input Value to be modified');
2134: return;
2135: end if;
2136: close c_get_inp_value_id;
2137:

Line 2160: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');

2156: end loop; -- for lvar in l_elem_entry_id_tb
2157: end if; -- if l_elem_entry_id_tbl.count()
2158: end if; -- if (ld_rec_ele_start_date <>
2159:
2160: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
2161: return;
2162: EXCEPTION
2163: --
2164: WHEN others THEN

Line 2329: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');

2325: l_entry_value_tbl hr_entry.varchar2_table;
2326:
2327: BEGIN
2328:
2329: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2330:
2331: ln_count := 0;
2332: lvar := 0;
2333: lb_mop_up_flag := FALSE;

Line 2358: hr_utility.trace('Element End Date = ' || ld_entry_end_date);

2354: open c_get_entry_end_date(p_element_entry_id
2355: ,p_assignment_id);
2356: fetch c_get_entry_end_date into ld_entry_end_date;
2357: close c_get_entry_end_date;
2358: hr_utility.trace('Element End Date = ' || ld_entry_end_date);
2359:
2360: if lv_processing_type = 'N' then
2361: hr_utility.trace('Non Recurring Element');
2362: open c_get_rate_entry_count(p_element_entry_id

Line 2361: hr_utility.trace('Non Recurring Element');

2357: close c_get_entry_end_date;
2358: hr_utility.trace('Element End Date = ' || ld_entry_end_date);
2359:
2360: if lv_processing_type = 'N' then
2361: hr_utility.trace('Non Recurring Element');
2362: open c_get_rate_entry_count(p_element_entry_id
2363: ,p_effective_start_date);
2364: fetch c_get_rate_entry_count into ln_count;
2365: close c_get_rate_entry_count;

Line 2390: hr_utility.trace('Recurring Element');

2386: close c_get_nrec_mop_up_dates;
2387: /*End of Code to see if date earned demands a mopup to exist or not*/
2388:
2389: else
2390: hr_utility.trace('Recurring Element');
2391: open c_get_rate_entry_count(p_element_entry_id
2392: ,ld_entry_end_date);
2393: fetch c_get_rate_entry_count into ln_count;
2394: close c_get_rate_entry_count;

Line 2403: hr_utility.trace('Deleting Mop Up Element');

2399: fetch c_check_mop_up_exists into lv_exist;
2400: if c_check_mop_up_exists%FOUND then
2401: if ((ln_count > 0) OR (lb_delete_mopup)) then
2402: -- Delete the Mop up as we do not require it now
2403: hr_utility.trace('Deleting Mop Up Element');
2404: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2405: ,p_assignment_id);
2406: else
2407: -- Get the input value id 'Multiple' for the Adjustment element

Line 2462: hr_utility.trace('Creating Mop Up Element');

2458: end if; -- if ln_count > 0
2459: else
2460: if ln_count = 0 then
2461: -- Create the Mop up as it does not exist
2462: hr_utility.trace('Creating Mop Up Element');
2463: CREATE_PREMIUM_MOP_UP_ELEMENT(
2464: p_element_entry_id
2465: ,p_effective_start_date
2466: ,p_effective_end_date

Line 2478: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');

2474: end if; -- if c_check_mop_up_exists%FOUND
2475:
2476: end if;
2477:
2478: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2479: return;
2480:
2481: END UPDATE_PREMIUM_MOP_UP_ELEMENT;
2482:

Line 2501: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');

2497: ,p_creator_type_o in varchar2
2498: ,p_entry_type_o in varchar2
2499: ,p_entry_information_category_o in varchar2) IS
2500: BEGIN
2501: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2502:
2503: -- Update the Recurring Element Entry associated with
2504: -- the Augment element
2505: UPDATE_RECUR_ELEM_ENTRY(p_element_entry_id

Line 2541: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');

2537: ,p_creator_type_o
2538: ,p_entry_type_o
2539: ,p_entry_information_category_o);
2540:
2541: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2542: return;
2543: END UPDATE_USER_HOOK;
2544:
2545: -----------------------------UPDATE SECTION ENDS HERE--------------------------

Line 2582: hr_utility.trace

2578: ld_end_of_time date;
2579: lb_prem_flag boolean;
2580:
2581: BEGIN
2582: hr_utility.trace
2583: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2584:
2585: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2586:

Line 2598: hr_utility.trace('Deleting Mop Up Element Entry');

2594: open c_get_entry_end_date(p_element_entry_id
2595: ,p_assignment_id);
2596: fetch c_get_entry_end_date into ld_entry_end_date;
2597: if c_get_entry_end_date%NOTFOUND then
2598: hr_utility.trace('Deleting Mop Up Element Entry');
2599: -- Delete the Recurring Element Entry associated with
2600: -- the Augment element
2601: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2602: ,p_assignment_id);

Line 2605: hr_utility.trace('Creating Mop Up Element');

2601: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2602: ,p_assignment_id);
2603: elsif ld_entry_end_date <> ld_end_of_time then
2604: -- Create the Mop up as it does not exist
2605: hr_utility.trace('Creating Mop Up Element');
2606: CREATE_PREMIUM_MOP_UP_ELEMENT(
2607: p_element_entry_id
2608: ,p_effective_start_date
2609: ,p_effective_end_date

Line 2620: hr_utility.trace

2616: end if; -- if c_get_entry_end_date
2617: close c_get_entry_end_date;
2618: end if; -- if lb_prem_flag
2619:
2620: hr_utility.trace
2621: ('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2622: return;
2623: END DELETE_PREM_MOP_UP_ELE_ENTRY;
2624:

Line 2651: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');

2647:
2648: lv_exists varchar2(10);
2649:
2650: BEGIN
2651: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2652:
2653: -- Check if the Element Entry was Purged. If yes delete the associated
2654: -- 'FL' creator type elements.
2655: -- We do not have any way to check the type of element once it is deleted

Line 2678: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');

2674:
2675: end if; -- if c_chk_elem_entry_exists%NOTFOUND
2676: close c_chk_elem_entry_exists;
2677:
2678: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2679: return;
2680: END DELETE_USER_HOOK;
2681:
2682: -----------------------------DELETE SECTION ENDS HERE--------------------------