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.

[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on HR_UTILITY

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

90:
91: ln_daily_rate number;
92: ln_no_of_days number;
93: BEGIN
94: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
95:
96: -- Initialization Code
97: ln_daily_rate := 0;
98:

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

99: -- Get the number of days between Start Date and End Date
100: ln_no_of_days := p_end_date - p_start_date + 1;
101: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
102:
103: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
104: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
105: return ln_daily_rate ;
106:
107: EXCEPTION

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

100: ln_no_of_days := p_end_date - p_start_date + 1;
101: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
102:
103: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
104: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
105: return ln_daily_rate ;
106:
107: EXCEPTION
108: WHEN OTHERS THEN

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

191: ld_rec_ele_start_date DATE;
192: ld_rec_ele_end_date DATE;
193:
194: BEGIN
195: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');
196:
197: ln_count := 0;
198: ld_rec_ele_end_date := NULL;
199: ld_rec_ele_start_date := NULL;

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

205: ,lv_inp_val_name
206: ,lv_screen_entry_value;
207: exit when c_check_aug_entry%NOTFOUND;
208:
209: hr_utility.trace('Element Name = ' || p_element_name);
210: hr_utility.trace('Business Group ID = ' || p_business_group_id);
211: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
212:
213: ln_count := ln_count + 1;

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

206: ,lv_screen_entry_value;
207: exit when c_check_aug_entry%NOTFOUND;
208:
209: hr_utility.trace('Element Name = ' || p_element_name);
210: hr_utility.trace('Business Group ID = ' || p_business_group_id);
211: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
212:
213: ln_count := ln_count + 1;
214:

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

207: exit when c_check_aug_entry%NOTFOUND;
208:
209: hr_utility.trace('Element Name = ' || p_element_name);
210: hr_utility.trace('Business Group ID = ' || p_business_group_id);
211: hr_utility.trace(lv_inp_val_name || ' = ' || lv_screen_entry_value);
212:
213: ln_count := ln_count + 1;
214:
215: if (upper(lv_inp_val_name) = 'EARNED START DATE'

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

234: if lb_aug_flag then
235: -- Checking for all ERROR conditions for the Augment element
236: if (ld_rec_ele_start_date IS NULL
237: AND ld_rec_ele_end_date IS NOT NULL) then
238: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
239: hr_utility.set_message_token('FORMULA_TEXT',
240: 'Please specify Earned Start Date');
241: hr_utility.raise_error;
242: elsif (ld_rec_ele_start_date IS NOT NULL

Line 239: hr_utility.set_message_token('FORMULA_TEXT',

235: -- Checking for all ERROR conditions for the Augment element
236: if (ld_rec_ele_start_date IS NULL
237: AND ld_rec_ele_end_date IS NOT NULL) then
238: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
239: hr_utility.set_message_token('FORMULA_TEXT',
240: 'Please specify Earned Start Date');
241: hr_utility.raise_error;
242: elsif (ld_rec_ele_start_date IS NOT NULL
243: AND ld_rec_ele_end_date IS NULL) then

Line 241: hr_utility.raise_error;

237: AND ld_rec_ele_end_date IS NOT NULL) then
238: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
239: hr_utility.set_message_token('FORMULA_TEXT',
240: 'Please specify Earned Start Date');
241: hr_utility.raise_error;
242: elsif (ld_rec_ele_start_date IS NOT NULL
243: AND ld_rec_ele_end_date IS NULL) then
244: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
245: hr_utility.set_message_token('FORMULA_TEXT',

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

240: 'Please specify Earned Start Date');
241: hr_utility.raise_error;
242: elsif (ld_rec_ele_start_date IS NOT NULL
243: AND ld_rec_ele_end_date IS NULL) then
244: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
245: hr_utility.set_message_token('FORMULA_TEXT',
246: 'Please specify Earned End Date');
247: hr_utility.raise_error;
248: elsif (ld_rec_ele_start_date IS NOT NULL

Line 245: hr_utility.set_message_token('FORMULA_TEXT',

241: hr_utility.raise_error;
242: elsif (ld_rec_ele_start_date IS NOT NULL
243: AND ld_rec_ele_end_date IS NULL) then
244: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
245: hr_utility.set_message_token('FORMULA_TEXT',
246: 'Please specify Earned End Date');
247: hr_utility.raise_error;
248: elsif (ld_rec_ele_start_date IS NOT NULL
249: AND ld_rec_ele_end_date IS NOT NULL) then

Line 247: hr_utility.raise_error;

243: AND ld_rec_ele_end_date IS NULL) then
244: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
245: hr_utility.set_message_token('FORMULA_TEXT',
246: 'Please specify Earned End Date');
247: hr_utility.raise_error;
248: elsif (ld_rec_ele_start_date IS NOT NULL
249: AND ld_rec_ele_end_date IS NOT NULL) then
250: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
251: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

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

247: hr_utility.raise_error;
248: elsif (ld_rec_ele_start_date IS NOT NULL
249: AND ld_rec_ele_end_date IS NOT NULL) then
250: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
251: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
252: hr_utility.set_message_token('FORMULA_TEXT',
253: 'Please specify Earned End Date greater than Earned Start Date');
254: hr_utility.raise_error;
255: end if;

Line 252: hr_utility.set_message_token('FORMULA_TEXT',

248: elsif (ld_rec_ele_start_date IS NOT NULL
249: AND ld_rec_ele_end_date IS NOT NULL) then
250: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
251: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
252: hr_utility.set_message_token('FORMULA_TEXT',
253: 'Please specify Earned End Date greater than Earned Start Date');
254: hr_utility.raise_error;
255: end if;
256: else

Line 254: hr_utility.raise_error;

250: if (ld_rec_ele_end_date < ld_rec_ele_start_date) then
251: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
252: hr_utility.set_message_token('FORMULA_TEXT',
253: 'Please specify Earned End Date greater than Earned Start Date');
254: hr_utility.raise_error;
255: end if;
256: else
257: -- Both the Start Date and End Date are NULL
258: open c_get_period_dates(p_assignment_id

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

259: ,p_effective_start_date);
260: fetch c_get_period_dates into ld_rec_ele_start_date
261: ,ld_rec_ele_end_date;
262: close c_get_period_dates;
263: hr_utility.trace('Updating the Element Entry values for the NR Element');
264: -- Updating the Start Date to the Payroll Start Date
265: update pay_element_entry_values_f peev
266: set screen_entry_value = fnd_date.date_to_canonical
267: (ld_rec_ele_start_date)

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

297: ,ld_rec_ele_start_date);
298: fetch c_check_assignment_validity into ln_dummy_var;
299: if c_check_assignment_validity%NOTFOUND then
300: close c_check_assignment_validity;
301: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
302: hr_utility.set_message_token('FORMULA_TEXT',
303: 'Assignment is not valid as of Earned Start Date');
304: hr_utility.raise_error;
305: end if;

Line 302: hr_utility.set_message_token('FORMULA_TEXT',

298: fetch c_check_assignment_validity into ln_dummy_var;
299: if c_check_assignment_validity%NOTFOUND then
300: close c_check_assignment_validity;
301: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
302: hr_utility.set_message_token('FORMULA_TEXT',
303: 'Assignment is not valid as of Earned Start Date');
304: hr_utility.raise_error;
305: end if;
306: close c_check_assignment_validity;

Line 304: hr_utility.raise_error;

300: close c_check_assignment_validity;
301: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
302: hr_utility.set_message_token('FORMULA_TEXT',
303: 'Assignment is not valid as of Earned Start Date');
304: hr_utility.raise_error;
305: end if;
306: close c_check_assignment_validity;
307:
308: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);

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

304: hr_utility.raise_error;
305: end if;
306: close c_check_assignment_validity;
307:
308: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);
309: hr_utility.trace('BUSINESS GROUP ID = ' || p_business_group_id);
310: end if; -- if lb_aug_flag
311:
312: return lb_aug_flag;

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

305: end if;
306: close c_check_assignment_validity;
307:
308: hr_utility.trace('BASE ELEMENT NAME = ' || p_element_name);
309: hr_utility.trace('BUSINESS GROUP ID = ' || p_business_group_id);
310: end if; -- if lb_aug_flag
311:
312: return lb_aug_flag;
313: END CHECK_AUGMENT_ELEM;

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

353: lb_prem_flag boolean;
354:
355: BEGIN
356:
357: hr_utility.trace('Inside CHECK_PREMIUM_ELEM');
358: lb_prem_flag := FALSE;
359: p_element_name := NULL;
360: p_processing_type := NULL;
361: p_business_group_id := NULL;

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

366: fetch c_check_prem_elem into lv_element_name
367: ,ln_business_group_id
368: ,lv_processing_type;
369: if c_check_prem_elem%FOUND THEN
370: hr_utility.trace('Premium Element');
371: lb_prem_flag := TRUE;
372: p_element_name := lv_element_name;
373: p_processing_type := lv_processing_type;
374: p_business_group_id := ln_business_group_id;

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

404: ln_ele_entry_id NUMBER;
405: ld_del_start_date DATE;
406:
407: BEGIN
408: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
409: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
410: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
411:
412: open c_get_ele_entry_id(p_element_entry_id

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

405: ld_del_start_date DATE;
406:
407: BEGIN
408: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
409: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
410: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
411:
412: open c_get_ele_entry_id(p_element_entry_id
413: ,p_assignment_id);

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

406:
407: BEGIN
408: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
409: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
410: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
411:
412: open c_get_ele_entry_id(p_element_entry_id
413: ,p_assignment_id);
414: loop

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

416: fetch c_get_ele_entry_id into ln_ele_entry_id
417: ,ld_del_start_date;
418: exit when c_get_ele_entry_id%NOTFOUND;
419:
420: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);
421: hr_utility.trace('Deletion Date = ' || ld_del_start_date);
422: hr_entry_api.delete_element_entry (
423: p_dt_delete_mode => 'ZAP',
424: p_session_date => ld_del_start_date,

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

417: ,ld_del_start_date;
418: exit when c_get_ele_entry_id%NOTFOUND;
419:
420: hr_utility.trace('Deleting Element Entry = ' || ln_ele_entry_id);
421: hr_utility.trace('Deletion Date = ' || ld_del_start_date);
422: hr_entry_api.delete_element_entry (
423: p_dt_delete_mode => 'ZAP',
424: p_session_date => ld_del_start_date,
425: p_element_entry_id => ln_ele_entry_id);

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

424: p_session_date => ld_del_start_date,
425: p_element_entry_id => ln_ele_entry_id);
426: end loop;
427: close c_get_ele_entry_id;
428: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
429: return;
430:
431: EXCEPTION
432: --

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

551: ld_link_eff_end_date date;
552: ld_dummy_start_date date;
553:
554: BEGIN
555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

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

552: ld_dummy_start_date date;
553:
554: BEGIN
555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);

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

553:
554: BEGIN
555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);

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

554: BEGIN
555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);
562: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);

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

555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);
562: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
563:

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

556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);
562: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
563:
564: ld_dummy_start_date := p_start_date;

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

557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);
562: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
563:
564: ld_dummy_start_date := p_start_date;
565: gn_ele_ent_num := 0;

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

558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
560: hr_utility.trace('p_inp_value_name = ' || p_inp_value_name);
561: hr_utility.trace('p_inp_value = ' || p_inp_value);
562: hr_utility.trace('p_rec_element_type_id = ' || p_rec_element_type_id);
563:
564: ld_dummy_start_date := p_start_date;
565: gn_ele_ent_num := 0;
566: ln_element_link_id := -9999;

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

590: -- If the assignment itself is not valid on the Start date
591: -- then throw an error saying Assignment is not valid on Start Date
592: if (gn_ele_ent_num = 0 AND ld_asgt_eff_start_date > p_start_date) then
593: close c_get_link_details;
594: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
595: hr_utility.set_message_token('FORMULA_TEXT',
596: 'Assignment is not Valid as of Earned Start Date');
597: hr_utility.raise_error;
598: end if; -- if (gn_ele_ent_num = 0 AND ....

Line 595: hr_utility.set_message_token('FORMULA_TEXT',

591: -- then throw an error saying Assignment is not valid on Start Date
592: if (gn_ele_ent_num = 0 AND ld_asgt_eff_start_date > p_start_date) then
593: close c_get_link_details;
594: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
595: hr_utility.set_message_token('FORMULA_TEXT',
596: 'Assignment is not Valid as of Earned Start Date');
597: hr_utility.raise_error;
598: end if; -- if (gn_ele_ent_num = 0 AND ....
599:

Line 597: hr_utility.raise_error;

593: close c_get_link_details;
594: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
595: hr_utility.set_message_token('FORMULA_TEXT',
596: 'Assignment is not Valid as of Earned Start Date');
597: hr_utility.raise_error;
598: end if; -- if (gn_ele_ent_num = 0 AND ....
599:
600: if ln_element_link_id <> gn_link_id_tbl(gn_ele_ent_num) then
601: gn_ele_ent_num := gn_ele_ent_num + 1;

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

612: gd_end_date_tbl(gn_ele_ent_num) := p_end_date;
613: else
614: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
615: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
616: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
617: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
618: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));

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

613: else
614: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
615: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
616: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
617: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
618: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));
621: hr_utility.trace('Global End Date = ' ||

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

614: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
615: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
616: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
617: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
618: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));
621: hr_utility.trace('Global End Date = ' ||
622: gd_end_date_tbl(gn_ele_ent_num));

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

615: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
616: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
617: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
618: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));
621: hr_utility.trace('Global End Date = ' ||
622: gd_end_date_tbl(gn_ele_ent_num));
623: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

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

617: hr_utility.trace('Asgt Eff End Date = ' || ld_asgt_eff_end_date);
618: hr_utility.trace('Link Eff End Date = ' || ld_link_eff_end_date);
619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));
621: hr_utility.trace('Global End Date = ' ||
622: gd_end_date_tbl(gn_ele_ent_num));
623: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
624: else
625: if ld_asgt_eff_end_date > ld_link_eff_end_date then

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

619: hr_utility.trace('Global Start Date = ' ||
620: gd_start_date_tbl(gn_ele_ent_num));
621: hr_utility.trace('Global End Date = ' ||
622: gd_end_date_tbl(gn_ele_ent_num));
623: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
624: else
625: if ld_asgt_eff_end_date > ld_link_eff_end_date then
626: gd_end_date_tbl(gn_ele_ent_num) := ld_link_eff_end_date;
627: else

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

633: else
634: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
635: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
636:
637: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
638: hr_utility.trace('Global Start Date = ' ||
639: gd_start_date_tbl(gn_ele_ent_num));
640: hr_utility.trace('Global End Date = ' ||
641: gd_end_date_tbl(gn_ele_ent_num));

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

634: ld_dummy_start_date := gd_end_date_tbl(gn_ele_ent_num) + 1;
635: end if; -- if gd_end_date_tbl(gn_ele_ent_num) ....
636:
637: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
638: hr_utility.trace('Global Start Date = ' ||
639: gd_start_date_tbl(gn_ele_ent_num));
640: hr_utility.trace('Global End Date = ' ||
641: gd_end_date_tbl(gn_ele_ent_num));
642: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));

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

636:
637: hr_utility.trace('gn_ele_ent_num = ' || gn_ele_ent_num);
638: hr_utility.trace('Global Start Date = ' ||
639: gd_start_date_tbl(gn_ele_ent_num));
640: hr_utility.trace('Global End Date = ' ||
641: gd_end_date_tbl(gn_ele_ent_num));
642: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
643: end if; -- if ln_element_link_id <> ....
644:

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

638: hr_utility.trace('Global Start Date = ' ||
639: gd_start_date_tbl(gn_ele_ent_num));
640: hr_utility.trace('Global End Date = ' ||
641: gd_end_date_tbl(gn_ele_ent_num));
642: hr_utility.trace('Link ID = ' || gn_link_id_tbl(gn_ele_ent_num));
643: end if; -- if ln_element_link_id <> ....
644:
645: end loop;
646: close c_get_link_details;

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

645: end loop;
646: close c_get_link_details;
647:
648: if gn_ele_ent_num = 0 then
649: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
650: hr_utility.set_message_token('FORMULA_TEXT',
651: 'The assignment is not eligible for ' ||
652: p_augment_elem_name || ' for FLSA Calc.' ||
653: ' Please link the element to make it eligible to the assignment.');

Line 650: hr_utility.set_message_token('FORMULA_TEXT',

646: close c_get_link_details;
647:
648: if gn_ele_ent_num = 0 then
649: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
650: hr_utility.set_message_token('FORMULA_TEXT',
651: 'The assignment is not eligible for ' ||
652: p_augment_elem_name || ' for FLSA Calc.' ||
653: ' Please link the element to make it eligible to the assignment.');
654: hr_utility.raise_error;

Line 654: hr_utility.raise_error;

650: hr_utility.set_message_token('FORMULA_TEXT',
651: 'The assignment is not eligible for ' ||
652: p_augment_elem_name || ' for FLSA Calc.' ||
653: ' Please link the element to make it eligible to the assignment.');
654: hr_utility.raise_error;
655: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
656: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
657: hr_utility.set_message_token('FORMULA_TEXT',
658: 'The assignment is not eligible for ' ||

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

652: p_augment_elem_name || ' for FLSA Calc.' ||
653: ' Please link the element to make it eligible to the assignment.');
654: hr_utility.raise_error;
655: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
656: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
657: hr_utility.set_message_token('FORMULA_TEXT',
658: 'The assignment is not eligible for ' ||
659: p_augment_elem_name || ' for FLSA Calc.' ||
660: ' Please link the element to make it eligible to the assignment.');

Line 657: hr_utility.set_message_token('FORMULA_TEXT',

653: ' Please link the element to make it eligible to the assignment.');
654: hr_utility.raise_error;
655: elsif (gd_end_date_tbl(gn_ele_ent_num) < p_end_date) then
656: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
657: hr_utility.set_message_token('FORMULA_TEXT',
658: 'The assignment is not eligible for ' ||
659: p_augment_elem_name || ' for FLSA Calc.' ||
660: ' Please link the element to make it eligible to the assignment.');
661: hr_utility.raise_error;

Line 661: hr_utility.raise_error;

657: hr_utility.set_message_token('FORMULA_TEXT',
658: 'The assignment is not eligible for ' ||
659: p_augment_elem_name || ' for FLSA Calc.' ||
660: ' Please link the element to make it eligible to the assignment.');
661: hr_utility.raise_error;
662: end if; -- if gn_ele_ent_num = 0
663: return;
664: END POPULATE_ELE_LINK;
665:

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

766:
767:
768: BEGIN
769:
770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);

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

767:
768: BEGIN
769:
770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);

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

768: BEGIN
769:
770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);

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

769:
770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);

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

770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);

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

771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
779: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);

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

772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
779: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
780:

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

773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
779: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
780:
781: -- Initialization Code

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

774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
779: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
780:
781: -- Initialization Code
782: ln_business_grp_id := NULL;

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

775: hr_utility.trace('P_ELEMENT_LINK_ID = ' || p_element_link_id);
776: hr_utility.trace('P_ORIGINAL_ENTRY_ID = ' || p_original_entry_id);
777: hr_utility.trace('P_CREATOR_TYPE = ' || p_creator_type);
778: hr_utility.trace('P_ENTRY_TYPE = ' || p_entry_type);
779: hr_utility.trace('P_ENTRY_INFORMATION_CATEGORY = ' || p_entry_information_category);
780:
781: -- Initialization Code
782: ln_business_grp_id := NULL;
783: ld_rec_ele_start_date := NULL;

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

811: fetch c_get_rec_elem_inp_val_det into ln_rec_element_type_id
812: ,l_input_value_id_tbl(lvr)
813: ,l_input_value_name_tbl(lvr);
814: exit when c_get_rec_elem_inp_val_det%NOTFOUND;
815: hr_utility.trace('Rec Input Value Name = ' || l_input_value_name_tbl(lvr));
816: if upper(l_input_value_name_tbl(lvr)) = 'DAILY AMOUNT' then
817: ln_daily_amt_index := lvr;
818: end if;
819: l_entry_value_tbl(lvr) := NULL;

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

828: fetch c_get_elem_inp_value_details into lv_inp_value_name
829: ,lv_screen_entry_value
830: ,lv_lookup_type;
831: exit when c_get_elem_inp_value_details%NOTFOUND;
832: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
833: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
834: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
835:
836: if upper(lv_inp_value_name) = 'EARNED START DATE' then

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

829: ,lv_screen_entry_value
830: ,lv_lookup_type;
831: exit when c_get_elem_inp_value_details%NOTFOUND;
832: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
833: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
834: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
835:
836: if upper(lv_inp_value_name) = 'EARNED START DATE' then
837: if lv_screen_entry_value is null then

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

830: ,lv_lookup_type;
831: exit when c_get_elem_inp_value_details%NOTFOUND;
832: hr_utility.trace('Input Value Name = ' || lv_inp_value_name);
833: hr_utility.trace('Input Value = ' || lv_screen_entry_value);
834: hr_utility.trace('Look Up Type = ' || lv_lookup_type);
835:
836: if upper(lv_inp_value_name) = 'EARNED START DATE' then
837: if lv_screen_entry_value is null then
838: ld_rec_ele_start_date := NULL;

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

839: exit;
840: else
841: ld_rec_ele_start_date :=
842: fnd_date.canonical_to_date(lv_screen_entry_value);
843: hr_utility.trace('Start Date = ' || to_char(ld_rec_ele_start_date,'DD-MON-YYYY'));
844: end if; -- if lv_screen_entry_value is null
845: elsif upper(lv_inp_value_name) = 'EARNED END DATE' then
846: if lv_screen_entry_value is null then
847: ld_rec_ele_end_date := NULL;

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

848: exit;
849: else
850: ld_rec_ele_end_date :=
851: fnd_date.canonical_to_date(lv_screen_entry_value);
852: hr_utility.trace('End Date = ' || to_char(ld_rec_ele_end_date,'DD-MON-YYYY'));
853: end if; -- if lv_screen_entry_value is null
854: elsif (upper(lv_inp_value_name) in ('AMOUNT')) THEN
855: lv_inp_value_to_divide := lv_inp_value_name;
856: ln_total_value := to_number(nvl(lv_screen_entry_value, '0'));

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

860: -- for Augment which needs to be specified.
861: -- This code can be reused if we have to copy over values
862: -- from the Non recurrning element to Recurring element
863: -- in future.
864: hr_utility.trace('Commented Else part as not required');
865: /*
866: for i in l_input_value_name_tbl.first..l_input_value_name_tbl.last
867: loop
868: if l_input_value_name_tbl(i) = lv_inp_value_name then

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

865: /*
866: for i in l_input_value_name_tbl.first..l_input_value_name_tbl.last
867: loop
868: if l_input_value_name_tbl(i) = lv_inp_value_name then
869: hr_utility.trace('Input Value Found');
870: if lv_lookup_type is NOT NULL then
871: open c_get_lookup_value(lv_lookup_type
872: ,lv_screen_entry_value);
873: fetch c_get_lookup_value into lv_lookup_meaning;

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

871: open c_get_lookup_value(lv_lookup_type
872: ,lv_screen_entry_value);
873: fetch c_get_lookup_value into lv_lookup_meaning;
874: close c_get_lookup_value;
875: hr_utility.trace('Lookup Meaning = ' || lv_lookup_meaning);
876: l_entry_value_tbl(i) := lv_lookup_meaning;
877: lv_lookup_type := NULL;
878: else
879: l_entry_value_tbl(i) := lv_screen_entry_value;

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

897: ,ld_rec_ele_start_date
898: ,ld_rec_ele_end_date);
899: fetch c_check_flsa_elig_job into ln_dummy_var;
900: if c_check_flsa_elig_job%NOTFOUND then
901: hr_utility.trace('Job is NOT FLSA Eligible');
902: close c_check_flsa_elig_job;
903: return;
904: end if;
905: close c_check_flsa_elig_job;

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

916:
917:
918: -- Create Recurrin Element Entry
919: for lvr in 1..gn_ele_ent_num loop
920: hr_utility.trace('Creating Recurring Element Entries');
921: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
922: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
923: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
924:

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

917:
918: -- Create Recurrin Element Entry
919: for lvr in 1..gn_ele_ent_num loop
920: hr_utility.trace('Creating Recurring Element Entries');
921: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
922: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
923: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
924:
925: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;

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

918: -- Create Recurrin Element Entry
919: for lvr in 1..gn_ele_ent_num loop
920: hr_utility.trace('Creating Recurring Element Entries');
921: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
922: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
923: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
924:
925: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;
926: ld_dummy_end_date := gd_end_date_tbl(lvr);

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

919: for lvr in 1..gn_ele_ent_num loop
920: hr_utility.trace('Creating Recurring Element Entries');
921: hr_utility.trace('Element Start Date = ' || gd_start_date_tbl(lvr));
922: hr_utility.trace('Element End Date = ' || gd_end_date_tbl(lvr));
923: hr_utility.trace('Entry Daily Amount = ' || gn_daily_amount);
924:
925: l_entry_value_tbl(ln_daily_amt_index) := gn_daily_amount;
926: ld_dummy_end_date := gd_end_date_tbl(lvr);
927:

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

988: gd_end_date_tbl.delete;
989: gn_link_id_tbl.delete;
990: gn_ele_ent_num := NULL;
991: gn_daily_amount := NULL;
992: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
993: return;
994:
995: EXCEPTION
996: --

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

1080: ld_eff_start_date DATE;
1081: ld_eff_end_date DATE;
1082:
1083: BEGIN
1084: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1085:
1086: -- Initialization Code
1087: lv_state_code := NULL;
1088: lv_county_code := NULL;

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

1107: open c_state_tax_rule(p_assignment_id
1108: ,lv_state_code);
1109: fetch c_state_tax_rule into ln_dummy;
1110: if c_state_tax_rule%NOTFOUND then
1111: hr_utility.trace('Creating Tax Rule for State ' || lv_state_code);
1112: -- Create State Tax Records
1113: pay_state_tax_rule_api.create_state_tax_rule (
1114: p_effective_date => p_effective_start_date
1115: ,p_default_flag => 'Y'

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

1131: ,lv_state_code
1132: ,lv_county_code);
1133: fetch c_county_tax_rule into ln_dummy;
1134: if c_county_tax_rule%NOTFOUND then
1135: hr_utility.trace('Creating Tax Rule for County '
1136: || lv_county_code);
1137: -- Create County Tax Records
1138: pay_county_tax_rule_api.create_county_tax_rule (
1139: p_effective_date => p_effective_start_date

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

1164: ,lv_county_code
1165: ,lv_city_code);
1166: fetch c_city_tax_rule into ln_dummy;
1167: if c_city_tax_rule%NOTFOUND then
1168: hr_utility.trace('Creating Tax Rule for City ' ||
1169: lv_city_code);
1170: -- Create City Tax Records
1171: pay_city_tax_rule_api.create_city_tax_rule (
1172: p_effective_date => p_effective_start_date

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

1191: end if; -- if lv_city_code <> '0000'
1192: end if; -- if lv_county_code <> '000'
1193: end if; -- if lv_state_code <> '00'
1194: end if; -- if lv_jurisdiction_code
1195: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1196: return;
1197: END CREATE_TAX_RECORDS;
1198:
1199: /******************************************************************************

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

1473: ln_link_id_tbl(0) := 0;
1474: ln_count := 0;
1475:
1476: -- Check For Premium Element
1477: hr_utility.trace('Entering CREATE_PREMIUM_MOP_UP_ELEMENT');
1478: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id
1479: ,p_effective_start_date
1480: ,lv_element_name
1481: ,lv_processing_type

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

1481: ,lv_processing_type
1482: ,ln_business_group_id);
1483:
1484: if lb_prem_flag then
1485: hr_utility.trace('Getting Time Definition ID');
1486: -- Get the Default Time Definition ID
1487: open c_get_def_time_def_id('Non Allocated Time Definition'
1488: ,'US');
1489: fetch c_get_def_time_def_id into ln_def_time_definition_id;

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

1488: ,'US');
1489: fetch c_get_def_time_def_id into ln_def_time_definition_id;
1490: close c_get_def_time_def_id;
1491:
1492: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1493: hr_utility.trace('Assignment ID ' || p_assignment_id);
1494: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1495: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1496:

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

1489: fetch c_get_def_time_def_id into ln_def_time_definition_id;
1490: close c_get_def_time_def_id;
1491:
1492: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1493: hr_utility.trace('Assignment ID ' || p_assignment_id);
1494: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1495: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1496:
1497: -- Get the Time Definition associated with the Assignment as of

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

1490: close c_get_def_time_def_id;
1491:
1492: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1493: hr_utility.trace('Assignment ID ' || p_assignment_id);
1494: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1495: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1496:
1497: -- Get the Time Definition associated with the Assignment as of
1498: -- Premium Element Entry Start Date

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

1491:
1492: hr_utility.trace('Element Entry ID ' || p_element_entry_id);
1493: hr_utility.trace('Assignment ID ' || p_assignment_id);
1494: hr_utility.trace('Business Group ID ' || ln_business_group_id);
1495: hr_utility.trace('Eff Start Date ' || p_effective_start_date);
1496:
1497: -- Get the Time Definition associated with the Assignment as of
1498: -- Premium Element Entry Start Date
1499: ln_time_definition_id :=

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

1504: ,p_business_group_id => ln_business_group_id
1505: ,p_time_def_date => p_effective_start_date);
1506:
1507: if ln_time_definition_id = ln_def_time_definition_id then
1508: hr_utility.trace('Default Time Definition ID');
1509: lb_prem_flag := FALSE;
1510: end if;
1511: end if;
1512:

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

1515: -- we have to create a MOP UP element.
1516: if lb_prem_flag then
1517: -- Check whether it is a Non Recurring Premium or Recurring
1518: if upper(lv_processing_type) = 'N' then
1519: hr_utility.trace('Non Recurring Premium Element');
1520:
1521: open c_get_rate_entry_count(p_element_entry_id
1522: ,p_effective_start_date);
1523: fetch c_get_rate_entry_count into ln_count;

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

1545: end if;
1546: close c_get_nrec_mop_up_dates;
1547: end if; -- if ln_count > 0
1548: else
1549: hr_utility.trace('Recurring Premium Element');
1550: open c_get_rec_mop_up_dates(p_assignment_id
1551: ,p_element_entry_id
1552: ,ln_time_definition_id);
1553: fetch c_get_rec_mop_up_dates into ld_mop_up_start_date

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

1587: close c_get_scr_entry_value;
1588: end if; -- if ln_inp_value_id is NOT NULL
1589:
1590:
1591: hr_utility.trace('Getting Mop UP ID');
1592: open c_get_elem_type_id(lv_element_name || ' for FLSA Period Adjustment'
1593: ,ln_business_group_id);
1594: fetch c_get_elem_type_id into ln_mop_up_ele_type_id;
1595: close c_get_elem_type_id;

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

1592: open c_get_elem_type_id(lv_element_name || ' for FLSA Period Adjustment'
1593: ,ln_business_group_id);
1594: fetch c_get_elem_type_id into ln_mop_up_ele_type_id;
1595: close c_get_elem_type_id;
1596: hr_utility.trace('Mop Up ID : ' || ln_mop_up_ele_type_id);
1597:
1598: ld_dummy_start_date := ld_mop_up_start_date;
1599:
1600: open c_get_link_details(ln_mop_up_ele_type_id

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

1625: else
1626: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1627: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1628:
1629: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1630: hr_utility.trace('Asgt Eff End Date = ' ||
1631: ld_asgt_eff_end_date);
1632: hr_utility.trace('Link Eff End Date = ' ||
1633: ld_link_eff_end_date);

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

1626: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1627: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1628:
1629: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1630: hr_utility.trace('Asgt Eff End Date = ' ||
1631: ld_asgt_eff_end_date);
1632: hr_utility.trace('Link Eff End Date = ' ||
1633: ld_link_eff_end_date);
1634: hr_utility.trace('Global Start Date = ' ||

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

1628:
1629: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1630: hr_utility.trace('Asgt Eff End Date = ' ||
1631: ld_asgt_eff_end_date);
1632: hr_utility.trace('Link Eff End Date = ' ||
1633: ld_link_eff_end_date);
1634: hr_utility.trace('Global Start Date = ' ||
1635: ld_start_date_tbl(ln_ele_ent_num));
1636: hr_utility.trace('Global End Date = ' ||

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

1630: hr_utility.trace('Asgt Eff End Date = ' ||
1631: ld_asgt_eff_end_date);
1632: hr_utility.trace('Link Eff End Date = ' ||
1633: ld_link_eff_end_date);
1634: hr_utility.trace('Global Start Date = ' ||
1635: ld_start_date_tbl(ln_ele_ent_num));
1636: hr_utility.trace('Global End Date = ' ||
1637: ld_end_date_tbl(ln_ele_ent_num));
1638: hr_utility.trace('Link ID = ' ||

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

1632: hr_utility.trace('Link Eff End Date = ' ||
1633: ld_link_eff_end_date);
1634: hr_utility.trace('Global Start Date = ' ||
1635: ld_start_date_tbl(ln_ele_ent_num));
1636: hr_utility.trace('Global End Date = ' ||
1637: ld_end_date_tbl(ln_ele_ent_num));
1638: hr_utility.trace('Link ID = ' ||
1639: ln_link_id_tbl(ln_ele_ent_num));
1640: else

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

1634: hr_utility.trace('Global Start Date = ' ||
1635: ld_start_date_tbl(ln_ele_ent_num));
1636: hr_utility.trace('Global End Date = ' ||
1637: ld_end_date_tbl(ln_ele_ent_num));
1638: hr_utility.trace('Link ID = ' ||
1639: ln_link_id_tbl(ln_ele_ent_num));
1640: else
1641: if ld_asgt_eff_end_date > ld_link_eff_end_date then
1642: ld_end_date_tbl(ln_ele_ent_num) := ld_link_eff_end_date;

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

1649: else
1650: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1651: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1652:
1653: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1654: hr_utility.trace('Global Start Date = ' ||
1655: ld_start_date_tbl(ln_ele_ent_num));
1656: hr_utility.trace('Global End Date = ' ||
1657: ld_end_date_tbl(ln_ele_ent_num));

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

1650: ld_dummy_start_date := ld_end_date_tbl(ln_ele_ent_num) + 1;
1651: end if; -- if ld_end_date_tbl(ln_ele_ent_num) ....
1652:
1653: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1654: hr_utility.trace('Global Start Date = ' ||
1655: ld_start_date_tbl(ln_ele_ent_num));
1656: hr_utility.trace('Global End Date = ' ||
1657: ld_end_date_tbl(ln_ele_ent_num));
1658: hr_utility.trace('Link ID = ' ||

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

1652:
1653: hr_utility.trace('ln_ele_ent_num = ' || ln_ele_ent_num);
1654: hr_utility.trace('Global Start Date = ' ||
1655: ld_start_date_tbl(ln_ele_ent_num));
1656: hr_utility.trace('Global End Date = ' ||
1657: ld_end_date_tbl(ln_ele_ent_num));
1658: hr_utility.trace('Link ID = ' ||
1659: ln_link_id_tbl(ln_ele_ent_num));
1660: end if; -- if ln_ele_link_id <> ....

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

1654: hr_utility.trace('Global Start Date = ' ||
1655: ld_start_date_tbl(ln_ele_ent_num));
1656: hr_utility.trace('Global End Date = ' ||
1657: ld_end_date_tbl(ln_ele_ent_num));
1658: hr_utility.trace('Link ID = ' ||
1659: ln_link_id_tbl(ln_ele_ent_num));
1660: end if; -- if ln_ele_link_id <> ....
1661: end loop;
1662: close c_get_link_details;

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

1661: end loop;
1662: close c_get_link_details;
1663:
1664: if ln_ele_ent_num = 0 then
1665: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1666: hr_utility.set_message_token('FORMULA_TEXT',
1667: 'The assignment is not eligible for ' ||
1668: lv_element_name || ' for FLSA Period Adjustment. ' ||
1669: 'Please link the element to make it eligible ' ||

Line 1666: hr_utility.set_message_token('FORMULA_TEXT',

1662: close c_get_link_details;
1663:
1664: if ln_ele_ent_num = 0 then
1665: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1666: hr_utility.set_message_token('FORMULA_TEXT',
1667: 'The assignment is not eligible for ' ||
1668: lv_element_name || ' for FLSA Period Adjustment. ' ||
1669: 'Please link the element to make it eligible ' ||
1670: 'for the assignment.');

Line 1671: hr_utility.raise_error;

1667: 'The assignment is not eligible for ' ||
1668: lv_element_name || ' for FLSA Period Adjustment. ' ||
1669: 'Please link the element to make it eligible ' ||
1670: 'for the assignment.');
1671: hr_utility.raise_error;
1672: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1674: hr_utility.set_message_token('FORMULA_TEXT',
1675: 'The assignment is not eligible for ' ||

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

1669: 'Please link the element to make it eligible ' ||
1670: 'for the assignment.');
1671: hr_utility.raise_error;
1672: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1674: hr_utility.set_message_token('FORMULA_TEXT',
1675: 'The assignment is not eligible for ' ||
1676: lv_element_name || ' for FLSA Period Adjustment. ' ||
1677: 'Please link the element to make it eligible ' ||

Line 1674: hr_utility.set_message_token('FORMULA_TEXT',

1670: 'for the assignment.');
1671: hr_utility.raise_error;
1672: elsif (ld_end_date_tbl(ln_ele_ent_num) < ld_mop_up_end_date) then
1673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1674: hr_utility.set_message_token('FORMULA_TEXT',
1675: 'The assignment is not eligible for ' ||
1676: lv_element_name || ' for FLSA Period Adjustment. ' ||
1677: 'Please link the element to make it eligible ' ||
1678: 'for the assignment.');

Line 1679: hr_utility.raise_error;

1675: 'The assignment is not eligible for ' ||
1676: lv_element_name || ' for FLSA Period Adjustment. ' ||
1677: 'Please link the element to make it eligible ' ||
1678: 'for the assignment.');
1679: hr_utility.raise_error;
1680: end if; -- if gn_ele_ent_num = 0
1681:
1682: for lvr in 1..ln_ele_ent_num loop
1683: hr_utility.trace('Creating Recurring Element Entries');

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

1679: hr_utility.raise_error;
1680: end if; -- if gn_ele_ent_num = 0
1681:
1682: for lvr in 1..ln_ele_ent_num loop
1683: hr_utility.trace('Creating Recurring Element Entries');
1684: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1685: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1686:
1687: ld_dummy_end_date := ld_end_date_tbl(lvr);

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

1680: end if; -- if gn_ele_ent_num = 0
1681:
1682: for lvr in 1..ln_ele_ent_num loop
1683: hr_utility.trace('Creating Recurring Element Entries');
1684: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1685: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1686:
1687: ld_dummy_end_date := ld_end_date_tbl(lvr);
1688:

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

1681:
1682: for lvr in 1..ln_ele_ent_num loop
1683: hr_utility.trace('Creating Recurring Element Entries');
1684: hr_utility.trace('Element Start Date = ' || ld_start_date_tbl(lvr));
1685: hr_utility.trace('Element End Date = ' || ld_end_date_tbl(lvr));
1686:
1687: ld_dummy_end_date := ld_end_date_tbl(lvr);
1688:
1689: hr_entry_api.insert_element_entry (

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

1708: -- End dating the element using ld_end_date_tbl(lvr)
1709: -- as ld_dummy_end_date gets overwritten by the
1710: -- previous call
1711: if ld_dummy_end_date <> ld_end_date_tbl(lvr) then
1712: hr_utility.trace('End dating the Element Entry Created');
1713: hr_entry_api.delete_element_entry (
1714: p_dt_delete_mode => 'DELETE',
1715: p_session_date => ld_end_date_tbl(lvr),
1716: p_element_entry_id => ln_element_entry_id);

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

1750: ,p_entry_type in varchar2
1751: ,p_entry_information_category in varchar2) IS
1752: BEGIN
1753:
1754: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1755: -- Call CREATE_RECUR_ELEM_ENTRY
1756: -- The package has the check built in for identifying Augment Elements
1757: CREATE_RECUR_ELEM_ENTRY(p_element_entry_id
1758: ,p_effective_start_date

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

1785: ,p_original_entry_id
1786: ,p_creator_type
1787: ,p_entry_type
1788: ,p_entry_information_category);
1789: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1790: return;
1791: END INSERT_USER_HOOK;
1792:
1793: -----------------------------INSERT SECTION ENDS HERE--------------------------

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

1891: l_entry_value_tbl hr_entry.varchar2_table;
1892:
1893: BEGIN
1894:
1895: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
1896:
1897: -- Initialization
1898: ld_rec_ele_start_date := hr_api.g_date;
1899: ld_rec_ele_end_date := hr_api.g_date;

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

1946: ld_rec_ele_end_date := ld_eff_end_date;
1947: end loop;
1948: close c_get_rec_elem_details;
1949:
1950: hr_utility.trace('Previous Start Date = ' || ld_rec_ele_start_date);
1951: hr_utility.trace('Previous End Date = ' || ld_rec_ele_end_date);
1952:
1953: -- Get the Start Date, End Date and Amount specified in the
1954: -- Non-recurring augment element

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

1947: end loop;
1948: close c_get_rec_elem_details;
1949:
1950: hr_utility.trace('Previous Start Date = ' || ld_rec_ele_start_date);
1951: hr_utility.trace('Previous End Date = ' || ld_rec_ele_end_date);
1952:
1953: -- Get the Start Date, End Date and Amount specified in the
1954: -- Non-recurring augment element
1955: open c_get_aug_entry_details(p_element_entry_id

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

1961:
1962: if upper(lv_inp_val_name) = 'EARNED START DATE' then
1963: ld_new_rec_ele_start_date :=
1964: fnd_date.canonical_to_date(lv_screen_entry_value);
1965: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
1966: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
1967: ld_new_rec_ele_end_date :=
1968: fnd_date.canonical_to_date(lv_screen_entry_value);
1969: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);

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

1965: hr_utility.trace('New Start Date = ' || ld_new_rec_ele_start_date);
1966: elsif upper(lv_inp_val_name) = 'EARNED END DATE' then
1967: ld_new_rec_ele_end_date :=
1968: fnd_date.canonical_to_date(lv_screen_entry_value);
1969: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
1970: elsif upper(lv_inp_val_name) = 'AMOUNT' then
1971: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
1972: hr_utility.trace('New Amount = ' || ln_total_amount);
1973: end if; -- if upper(lv_inp_val_name) = 'START DATE'

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

1968: fnd_date.canonical_to_date(lv_screen_entry_value);
1969: hr_utility.trace('New End Date = ' || ld_new_rec_ele_end_date);
1970: elsif upper(lv_inp_val_name) = 'AMOUNT' then
1971: ln_total_amount := to_number(nvl(lv_screen_entry_value,0));
1972: hr_utility.trace('New Amount = ' || ln_total_amount);
1973: end if; -- if upper(lv_inp_val_name) = 'START DATE'
1974: end loop;
1975: close c_get_aug_entry_details;
1976:

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

1999: if (ld_rec_ele_start_date <> ld_new_rec_ele_start_date OR
2000: ld_rec_ele_end_date <> ld_new_rec_ele_end_date OR
2001: lv_penny_issue_au <> lv_penny_issue_bu) then
2002: -- Deleting the Recurring element entries previously created
2003: hr_utility.trace('Deleting Old Recurring Element Entries');
2004: if l_elem_entry_id_tbl.count() > 0 then
2005: for lvar in l_elem_entry_id_tbl.first..l_elem_entry_id_tbl.last loop
2006: hr_entry_api.delete_element_entry (
2007: p_dt_delete_mode => 'ZAP',

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

2010: end loop; -- for lvar in l_elem_entry_id_tbl
2011: end if; -- if l_elem_entry_id_tbl.count()
2012:
2013: -- Recreating New recurring element entries
2014: hr_utility.trace('Creating New Recurring Element Entries');
2015: PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY(
2016: p_element_entry_id
2017: ,p_effective_start_date
2018: ,p_effective_end_date

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

2022: ,p_creator_type_o
2023: ,p_entry_type_o
2024: ,p_entry_information_category_o);
2025: else
2026: hr_utility.trace('Updating Recurring Amount Values');
2027: -- No changes have been made to Start Date and End Date
2028: hr_utility.trace('New Daily Amount = ' || ln_daily_amount);
2029:
2030: -- Get the Input Value ID to be changed

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

2024: ,p_entry_information_category_o);
2025: else
2026: hr_utility.trace('Updating Recurring Amount Values');
2027: -- No changes have been made to Start Date and End Date
2028: hr_utility.trace('New Daily Amount = ' || ln_daily_amount);
2029:
2030: -- Get the Input Value ID to be changed
2031: open c_get_inp_value_id(lv_element_name
2032: ,ln_business_grp_id);

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

2031: open c_get_inp_value_id(lv_element_name
2032: ,ln_business_grp_id);
2033: fetch c_get_inp_value_id into l_input_value_id_tbl(1);
2034: if c_get_inp_value_id%NOTFOUND then
2035: hr_utility.trace('No Input Value to be modified');
2036: return;
2037: end if;
2038: close c_get_inp_value_id;
2039:

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

2058: end loop; -- for lvar in l_elem_entry_id_tb
2059: end if; -- if l_elem_entry_id_tbl.count()
2060: end if; -- if (ld_rec_ele_start_date <>
2061:
2062: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
2063: return;
2064: EXCEPTION
2065: --
2066: WHEN others THEN

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

2227: l_entry_value_tbl hr_entry.varchar2_table;
2228:
2229: BEGIN
2230:
2231: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2232:
2233: ln_count := 0;
2234: lvar := 0;
2235: lb_mop_up_flag := FALSE;

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

2256: open c_get_entry_end_date(p_element_entry_id
2257: ,p_assignment_id);
2258: fetch c_get_entry_end_date into ld_entry_end_date;
2259: close c_get_entry_end_date;
2260: hr_utility.trace('Element End Date = ' || ld_entry_end_date);
2261:
2262: if lv_processing_type = 'N' then
2263: hr_utility.trace('Non Recurring Element');
2264: open c_get_rate_entry_count(p_element_entry_id

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

2259: close c_get_entry_end_date;
2260: hr_utility.trace('Element End Date = ' || ld_entry_end_date);
2261:
2262: if lv_processing_type = 'N' then
2263: hr_utility.trace('Non Recurring Element');
2264: open c_get_rate_entry_count(p_element_entry_id
2265: ,p_effective_start_date);
2266: fetch c_get_rate_entry_count into ln_count;
2267: close c_get_rate_entry_count;

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

2288: close c_get_nrec_mop_up_dates;
2289: /*End of Code to see if date earned demands a mopup to exist or not*/
2290:
2291: else
2292: hr_utility.trace('Recurring Element');
2293: open c_get_rate_entry_count(p_element_entry_id
2294: ,ld_entry_end_date);
2295: fetch c_get_rate_entry_count into ln_count;
2296: close c_get_rate_entry_count;

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

2301: fetch c_check_mop_up_exists into lv_exist;
2302: if c_check_mop_up_exists%FOUND then
2303: if ((ln_count > 0) OR (lb_delete_mopup)) then
2304: -- Delete the Mop up as we do not require it now
2305: hr_utility.trace('Deleting Mop Up Element');
2306: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2307: ,p_assignment_id);
2308: else
2309: -- Get the input value id 'Multiple' for the Adjustment element

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

2360: end if; -- if ln_count > 0
2361: else
2362: if ln_count = 0 then
2363: -- Create the Mop up as it does not exist
2364: hr_utility.trace('Creating Mop Up Element');
2365: CREATE_PREMIUM_MOP_UP_ELEMENT(
2366: p_element_entry_id
2367: ,p_effective_start_date
2368: ,p_effective_end_date

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

2376: end if; -- if c_check_mop_up_exists%FOUND
2377:
2378: end if;
2379:
2380: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2381: return;
2382:
2383: END UPDATE_PREMIUM_MOP_UP_ELEMENT;
2384:

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

2399: ,p_creator_type_o in varchar2
2400: ,p_entry_type_o in varchar2
2401: ,p_entry_information_category_o in varchar2) IS
2402: BEGIN
2403: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2404:
2405: -- Update the Recurring Element Entry associated with
2406: -- the Augment element
2407: UPDATE_RECUR_ELEM_ENTRY(p_element_entry_id

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

2439: ,p_creator_type_o
2440: ,p_entry_type_o
2441: ,p_entry_information_category_o);
2442:
2443: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2444: return;
2445: END UPDATE_USER_HOOK;
2446:
2447: -----------------------------UPDATE SECTION ENDS HERE--------------------------

Line 2484: hr_utility.trace

2480: ld_end_of_time date;
2481: lb_prem_flag boolean;
2482:
2483: BEGIN
2484: hr_utility.trace
2485: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2486:
2487: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2488:

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

2496: open c_get_entry_end_date(p_element_entry_id
2497: ,p_assignment_id);
2498: fetch c_get_entry_end_date into ld_entry_end_date;
2499: if c_get_entry_end_date%NOTFOUND then
2500: hr_utility.trace('Deleting Mop Up Element Entry');
2501: -- Delete the Recurring Element Entry associated with
2502: -- the Augment element
2503: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2504: ,p_assignment_id);

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

2503: DELETE_DEPENDENT_ENTRIES(p_element_entry_id
2504: ,p_assignment_id);
2505: elsif ld_entry_end_date <> ld_end_of_time then
2506: -- Create the Mop up as it does not exist
2507: hr_utility.trace('Creating Mop Up Element');
2508: CREATE_PREMIUM_MOP_UP_ELEMENT(
2509: p_element_entry_id
2510: ,p_effective_start_date
2511: ,p_effective_end_date

Line 2522: hr_utility.trace

2518: end if; -- if c_get_entry_end_date
2519: close c_get_entry_end_date;
2520: end if; -- if lb_prem_flag
2521:
2522: hr_utility.trace
2523: ('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2524: return;
2525: END DELETE_PREM_MOP_UP_ELE_ENTRY;
2526:

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

2549:
2550: lv_exists varchar2(10);
2551:
2552: BEGIN
2553: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2554:
2555: -- Check if the Element Entry was Purged. If yes delete the associated
2556: -- 'FL' creator type elements.
2557: -- We do not have any way to check the type of element once it is deleted

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

2576:
2577: end if; -- if c_chk_elem_entry_exists%NOTFOUND
2578: close c_chk_elem_entry_exists;
2579:
2580: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2581: return;
2582: END DELETE_USER_HOOK;
2583:
2584: -----------------------------DELETE SECTION ENDS HERE--------------------------