eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_ELEMENT_API dependencies on HR_UTILITY

Line 222: hr_utility.set_location('Entering:'||l_proc, 1);

218: ll_effective_Date DATE;
219: l_new_element_name VARCHAR2(80);
220: --
221: begin
222: hr_utility.set_location('Entering:'||l_proc, 1);
223: -- Initialization
224: ghr_history_api.get_g_session_var(l_session);
225: ll_effective_date := p_effective_date;
226:

Line 283: hr_utility.set_location(' New ELT in GHELEPKG'|| l_new_element_name,10);

279:
280: END IF;
281: END IF;
282:
283: hr_utility.set_location(' New ELT in GHELEPKG'|| l_new_element_name,10);
284: --
285: -- the p_element_name is replaced with l_new_element_name
286: -- in further calls.
287: --

Line 310: hr_utility.set_location('Find the uom ' ||l_proc, 2);

306: p_object_version_number => p_object_version_number
307: );
308: p_element_entry_id := l_element_entry_id;
309:
310: hr_utility.set_location('Find the uom ' ||l_proc, 2);
311: if p_processing_type = 'R' then -- Recurring element
312: hr_utility.set_location('Find the uom -- Recurring' ||l_proc, 3);
313: for c_rec_ele_info_rec in
314: c_rec_ele_info (l_new_element_name

Line 312: hr_utility.set_location('Find the uom -- Recurring' ||l_proc, 3);

308: p_element_entry_id := l_element_entry_id;
309:
310: hr_utility.set_location('Find the uom ' ||l_proc, 2);
311: if p_processing_type = 'R' then -- Recurring element
312: hr_utility.set_location('Find the uom -- Recurring' ||l_proc, 3);
313: for c_rec_ele_info_rec in
314: c_rec_ele_info (l_new_element_name
315: ,p_input_value_name
316: ,p_assignment_id

Line 326: hr_utility.set_location('Find the uom -- Non Recurring' ||l_proc, 4);

322: end if;
323: exit;
324: end loop;
325: elsif p_processing_type = 'N' then -- Recurring element
326: hr_utility.set_location('Find the uom -- Non Recurring' ||l_proc, 4);
327: for c_nonrec_ele_info_rec in
328: c_nonrec_ele_info (l_new_element_name
329: ,p_input_value_name
330: ,p_assignment_id

Line 343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);

339: end loop;
340: end if;
341:
342: Else
343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);
344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);

Line 344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);

340: end if;
341:
342: Else
343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);
344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);
348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);

Line 345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);

341:
342: Else
343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);
344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);
348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);
349:

Line 346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);

342: Else
343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);
344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);
348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);
349:
350: if p_processing_type = 'R' then -- Recurring element

Line 347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);

343: hr_utility.set_location(' NOT CORRECTION IN ELEPKG; PROCESS TYPE '||p_processing_type,15);
344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);
348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);
349:
350: if p_processing_type = 'R' then -- Recurring element
351: p_input_value_id := NULL;

Line 348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);

344: hr_utility.set_location(' Element Name ELEPKG ' ||l_new_element_name,1000);
345: hr_utility.set_location(' BG ID ELEPKG'|| nvl(to_char(ll_bg_id),'NULL'),2000);
346: hr_utility.set_location(' Eff date ELEPKG'|| p_effective_date ,3000);
347: hr_utility.set_location(' ASSGID IN ELEPKG ' || to_char(p_assignment_id),3500);
348: hr_utility.set_location(' INPUT VALUE name '|| p_input_value_name,4000);
349:
350: if p_processing_type = 'R' then -- Recurring element
351: p_input_value_id := NULL;
352: p_element_entry_id := NULL;

Line 362: hr_utility.set_location(' INSIDE ELE RECURRING ',20);

358: ,p_assignment_id
359: ,p_effective_date
360: ,ll_bg_id)
361: loop
362: hr_utility.set_location(' INSIDE ELE RECURRING ',20);
363: p_input_value_id := c_rec_ele_info_rec.input_value_id;
364: l_uom := c_rec_ele_info_rec.uom;
365: p_element_link_id := c_rec_ele_info_rec.element_link_id;
366: p_element_entry_id := c_rec_ele_info_rec.element_entry_id;

Line 380: hr_utility.set_location('Element Name : '||l_new_element_name,0);

376: p_input_value_id := NULL;
377: p_element_entry_id := NULL;
378: p_value := NULL;
379: p_object_version_number := NULL;
380: hr_utility.set_location('Element Name : '||l_new_element_name,0);
381: IF l_new_element_name like '%Incentive%' AND
382: l_new_element_name not like 'Separation Incentive%' THEN
383: hr_utility.set_location('Inside Incentive Element',10);
384: for c_nonrec_incntv_ele_info_rec in

Line 383: hr_utility.set_location('Inside Incentive Element',10);

379: p_object_version_number := NULL;
380: hr_utility.set_location('Element Name : '||l_new_element_name,0);
381: IF l_new_element_name like '%Incentive%' AND
382: l_new_element_name not like 'Separation Incentive%' THEN
383: hr_utility.set_location('Inside Incentive Element',10);
384: for c_nonrec_incntv_ele_info_rec in
385: c_nonrec_incntv_ele_info (l_new_element_name
386: ,p_input_value_name
387: ,p_assignment_id

Line 401: hr_utility.set_location('Inside Incentive Element, Value:'||p_Value,10);

397: p_multiple_error_flag := c_nonrec_incntv_ele_info_rec.multiple_entries_allowed_flag;
398: if l_uom = 'D' then
399: p_value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_value));
400: end if;
401: hr_utility.set_location('Inside Incentive Element, Value:'||p_Value,10);
402: exit;
403: end loop;
404: ELSE
405: for c_nonrec_ele_info_rec in

Line 426: hr_utility.set_message (8301, 'GHR_38035_API_INV_PROC_TYPE');

422: exit;
423: end loop;
424: END IF;
425: else -- Neither recurring nor nonrecurring element
426: hr_utility.set_message (8301, 'GHR_38035_API_INV_PROC_TYPE');
427: hr_utility.raise_error;
428: end if;
429: hr_utility.set_location(l_proc, 31);
430: End if;

Line 427: hr_utility.raise_error;

423: end loop;
424: END IF;
425: else -- Neither recurring nor nonrecurring element
426: hr_utility.set_message (8301, 'GHR_38035_API_INV_PROC_TYPE');
427: hr_utility.raise_error;
428: end if;
429: hr_utility.set_location(l_proc, 31);
430: End if;
431: --

Line 429: hr_utility.set_location(l_proc, 31);

425: else -- Neither recurring nor nonrecurring element
426: hr_utility.set_message (8301, 'GHR_38035_API_INV_PROC_TYPE');
427: hr_utility.raise_error;
428: end if;
429: hr_utility.set_location(l_proc, 31);
430: End if;
431: --
432: hr_utility.set_location(' Multiple Error Flag '||p_multiple_error_flag,3);
433: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 432: hr_utility.set_location(' Multiple Error Flag '||p_multiple_error_flag,3);

428: end if;
429: hr_utility.set_location(l_proc, 31);
430: End if;
431: --
432: hr_utility.set_location(' Multiple Error Flag '||p_multiple_error_flag,3);
433: hr_utility.set_location(' Leaving:'||l_proc, 4);
434: --
435: exception when others then
436: --

Line 433: hr_utility.set_location(' Leaving:'||l_proc, 4);

429: hr_utility.set_location(l_proc, 31);
430: End if;
431: --
432: hr_utility.set_location(' Multiple Error Flag '||p_multiple_error_flag,3);
433: hr_utility.set_location(' Leaving:'||l_proc, 4);
434: --
435: exception when others then
436: --
437: -- Reset IN OUT parameters and set OUT parameters

Line 480: hr_utility.set_location('Entering ' || l_proc,5);

476: order by 1 asc;
477:
478: Begin
479:
480: hr_utility.set_location('Entering ' || l_proc,5);
481: -- get session variables
482:
483: for update_mode in c_update_mode_e loop
484: hr_utility.set_location(l_proc,15);

Line 484: hr_utility.set_location(l_proc,15);

480: hr_utility.set_location('Entering ' || l_proc,5);
481: -- get session variables
482:
483: for update_mode in c_update_mode_e loop
484: hr_utility.set_location(l_proc,15);
485: l_esd := update_mode.effective_start_date;
486: l_eed := update_mode.effective_end_date;
487: end loop;
488: hr_utility.set_location(l_proc,20);

Line 488: hr_utility.set_location(l_proc,20);

484: hr_utility.set_location(l_proc,15);
485: l_esd := update_mode.effective_start_date;
486: l_eed := update_mode.effective_end_date;
487: end loop;
488: hr_utility.set_location(l_proc,20);
489: If l_esd = p_effective_date then
490: hr_utility.set_location(l_proc,25);
491: l_mode := 'CORRECTION';
492: Elsif l_esd < p_effective_date and

Line 490: hr_utility.set_location(l_proc,25);

486: l_eed := update_mode.effective_end_date;
487: end loop;
488: hr_utility.set_location(l_proc,20);
489: If l_esd = p_effective_date then
490: hr_utility.set_location(l_proc,25);
491: l_mode := 'CORRECTION';
492: Elsif l_esd < p_effective_date and
493: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
494: hr_utility.set_location(l_proc,30);

Line 494: hr_utility.set_location(l_proc,30);

490: hr_utility.set_location(l_proc,25);
491: l_mode := 'CORRECTION';
492: Elsif l_esd < p_effective_date and
493: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
494: hr_utility.set_location(l_proc,30);
495: l_mode := 'UPDATE';
496: Elsif l_esd < p_effective_date then
497: hr_utility.set_location(l_proc,35);
498: for update_mode1 in c_update_mode_e1 loop

Line 497: hr_utility.set_location(l_proc,35);

493: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
494: hr_utility.set_location(l_proc,30);
495: l_mode := 'UPDATE';
496: Elsif l_esd < p_effective_date then
497: hr_utility.set_location(l_proc,35);
498: for update_mode1 in c_update_mode_e1 loop
499: hr_utility.set_location(l_proc,40);
500: l_exists := true;
501: exit;

Line 499: hr_utility.set_location(l_proc,40);

495: l_mode := 'UPDATE';
496: Elsif l_esd < p_effective_date then
497: hr_utility.set_location(l_proc,35);
498: for update_mode1 in c_update_mode_e1 loop
499: hr_utility.set_location(l_proc,40);
500: l_exists := true;
501: exit;
502: end loop;
503: If l_exists then

Line 504: hr_utility.set_location(l_proc,45);

500: l_exists := true;
501: exit;
502: end loop;
503: If l_exists then
504: hr_utility.set_location(l_proc,45);
505: l_mode := 'UPDATE_CHANGE_INSERT';
506: Else
507: IF to_char(l_eed,'YYYY/MM/DD') <> '4712/12/31' then
508: -- This context comes when the separated employee has retro actions

Line 510: hr_utility.set_location(l_proc,48);

506: Else
507: IF to_char(l_eed,'YYYY/MM/DD') <> '4712/12/31' then
508: -- This context comes when the separated employee has retro actions
509: -- Separation action end dates the elements to the Separation effective date
510: hr_utility.set_location(l_proc,48);
511: l_mode := 'UPDATE';
512: ELSE
513: hr_utility.set_location(l_proc,50);
514: l_mode := 'CORRECTION';

Line 513: hr_utility.set_location(l_proc,50);

509: -- Separation action end dates the elements to the Separation effective date
510: hr_utility.set_location(l_proc,48);
511: l_mode := 'UPDATE';
512: ELSE
513: hr_utility.set_location(l_proc,50);
514: l_mode := 'CORRECTION';
515: END IF;
516: End if;
517: hr_utility.set_location(l_proc,55);

Line 517: hr_utility.set_location(l_proc,55);

513: hr_utility.set_location(l_proc,50);
514: l_mode := 'CORRECTION';
515: END IF;
516: End if;
517: hr_utility.set_location(l_proc,55);
518: End if;
519: If l_mode is null then
520: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
521: hr_utility.set_message_token('TABLE_NAME','pay_element_entries_f');

Line 520: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');

516: End if;
517: hr_utility.set_location(l_proc,55);
518: End if;
519: If l_mode is null then
520: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
521: hr_utility.set_message_token('TABLE_NAME','pay_element_entries_f');
522: hr_utility.raise_error;
523: End if;
524: return l_mode;

Line 521: hr_utility.set_message_token('TABLE_NAME','pay_element_entries_f');

517: hr_utility.set_location(l_proc,55);
518: End if;
519: If l_mode is null then
520: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
521: hr_utility.set_message_token('TABLE_NAME','pay_element_entries_f');
522: hr_utility.raise_error;
523: End if;
524: return l_mode;
525: end return_update_mode;

Line 522: hr_utility.raise_error;

518: End if;
519: If l_mode is null then
520: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
521: hr_utility.set_message_token('TABLE_NAME','pay_element_entries_f');
522: hr_utility.raise_error;
523: End if;
524: return l_mode;
525: end return_update_mode;
526:

Line 592: hr_utility.trace('Business Grp Id - Under get Inp val Id'||ll_bg_id);

588:
589: -- get the business_group_id from profile
590: --
591: fnd_profile.get('PER_BUSINESS_GROUP_ID',ll_bg_id);
592: hr_utility.trace('Business Grp Id - Under get Inp val Id'||ll_bg_id);
593: --
594: l_input_value_id := NULL;
595: for c_input_value_rec
596: in c_input_value (p_element_name, p_input_value_name, p_effective_date,ll_bg_id)

Line 879: hr_utility.set_location('Entering:'||l_proc, 1);

875: l_cnt NUMBER;
876: --
877: begin
878:
879: hr_utility.set_location('Entering:'||l_proc, 1);
880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);

Line 880: hr_utility.set_location('element '||p_element_name,0);

876: --
877: begin
878:
879: hr_utility.set_location('Entering:'||l_proc, 1);
880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);

Line 881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);

877: begin
878:
879: hr_utility.set_location('Entering:'||l_proc, 1);
880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);

Line 882: hr_utility.trace('VALUE1 :'||p_value1);

878:
879: hr_utility.set_location('Entering:'||l_proc, 1);
880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);

Line 883: hr_utility.trace('L_VALUE1 :'||l_value1);

879: hr_utility.set_location('Entering:'||l_proc, 1);
880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);
887: If p_element_name like '%Incentive Biweekly%' AND

Line 884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);

880: hr_utility.set_location('element '||p_element_name,0);
881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);
887: If p_element_name like '%Incentive Biweekly%' AND
888: p_element_name <> 'Separation Incentive Biweekly' THEN

Line 885: hr_utility.trace('Value2 :'||p_value2);

881: hr_utility.trace('Input Value Name1:'||p_input_value_name1);
882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);
887: If p_element_name like '%Incentive Biweekly%' AND
888: p_element_name <> 'Separation Incentive Biweekly' THEN
889: hr_utility.set_location('Inside biweekly element ',0);

Line 886: hr_utility.trace('L_Value2 :'||l_value2);

882: hr_utility.trace('VALUE1 :'||p_value1);
883: hr_utility.trace('L_VALUE1 :'||l_value1);
884: hr_utility.trace('Input Value Name2:'||p_input_value_name2);
885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);
887: If p_element_name like '%Incentive Biweekly%' AND
888: p_element_name <> 'Separation Incentive Biweekly' THEN
889: hr_utility.set_location('Inside biweekly element ',0);
890: l_biweekly_end_date := p_value15;

Line 889: hr_utility.set_location('Inside biweekly element ',0);

885: hr_utility.trace('Value2 :'||p_value2);
886: hr_utility.trace('L_Value2 :'||l_value2);
887: If p_element_name like '%Incentive Biweekly%' AND
888: p_element_name <> 'Separation Incentive Biweekly' THEN
889: hr_utility.set_location('Inside biweekly element ',0);
890: l_biweekly_end_date := p_value15;
891: l_p_value15 := NULL;
892: ELSE
893: l_p_value15 := p_value15;

Line 905: hr_utility.set_message(8301, 'GHR_38129_INCN_ELE_EXISTS');

901: LOOP
902: l_cnt := curr_incentive_rec.cnt;
903: END LOOP;
904: IF l_cnt > 0 and p_element_name <> 'Separation Incentive Lump Sum' THEN
905: hr_utility.set_message(8301, 'GHR_38129_INCN_ELE_EXISTS');
906: hr_utility.set_message_token('ELEMENT_NAME',p_element_name);
907: hr_utility.set_message_token('EFF_DATE',p_effective_date);
908: hr_utility.raise_error;
909: END IF;

Line 906: hr_utility.set_message_token('ELEMENT_NAME',p_element_name);

902: l_cnt := curr_incentive_rec.cnt;
903: END LOOP;
904: IF l_cnt > 0 and p_element_name <> 'Separation Incentive Lump Sum' THEN
905: hr_utility.set_message(8301, 'GHR_38129_INCN_ELE_EXISTS');
906: hr_utility.set_message_token('ELEMENT_NAME',p_element_name);
907: hr_utility.set_message_token('EFF_DATE',p_effective_date);
908: hr_utility.raise_error;
909: END IF;
910: END IF;

Line 907: hr_utility.set_message_token('EFF_DATE',p_effective_date);

903: END LOOP;
904: IF l_cnt > 0 and p_element_name <> 'Separation Incentive Lump Sum' THEN
905: hr_utility.set_message(8301, 'GHR_38129_INCN_ELE_EXISTS');
906: hr_utility.set_message_token('ELEMENT_NAME',p_element_name);
907: hr_utility.set_message_token('EFF_DATE',p_effective_date);
908: hr_utility.raise_error;
909: END IF;
910: END IF;
911: END IF;

Line 908: hr_utility.raise_error;

904: IF l_cnt > 0 and p_element_name <> 'Separation Incentive Lump Sum' THEN
905: hr_utility.set_message(8301, 'GHR_38129_INCN_ELE_EXISTS');
906: hr_utility.set_message_token('ELEMENT_NAME',p_element_name);
907: hr_utility.set_message_token('EFF_DATE',p_effective_date);
908: hr_utility.raise_error;
909: END IF;
910: END IF;
911: END IF;
912: -- End Bug#5045806

Line 922: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');

918: exit;
919: end loop;
920: --
921: if not l_business_group_found then
922: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
923: hr_utility.raise_error;
924: end if;
925: hr_utility.set_location(l_proc, 2);
926: -- Pick pay basis from PAR

Line 923: hr_utility.raise_error;

919: end loop;
920: --
921: if not l_business_group_found then
922: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
923: hr_utility.raise_error;
924: end if;
925: hr_utility.set_location(l_proc, 2);
926: -- Pick pay basis from PAR
927: ll_effective_date := p_effective_Date;

Line 925: hr_utility.set_location(l_proc, 2);

921: if not l_business_group_found then
922: hr_utility.set_message(8301, 'GHR_38023_API_INV_ASG');
923: hr_utility.raise_error;
924: end if;
925: hr_utility.set_location(l_proc, 2);
926: -- Pick pay basis from PAR
927: ll_effective_date := p_effective_Date;
928:
929: IF (l_session.pa_request_id is NOT NULL) THEN

Line 979: hr_utility.trace('old Element Name : ' ||p_element_name);

975: END IF;
976: END IF;
977: --
978: --
979: hr_utility.trace('old Element Name : ' ||p_element_name);
980: hr_utility.trace('New Element Name : ' ||l_new_element_name);
981: --
982: -- ONLY THIS CURSOR and GET_INPUT_VALUE_ID procedure USE NEW ELEMENT NAME
983: --

Line 980: hr_utility.trace('New Element Name : ' ||l_new_element_name);

976: END IF;
977: --
978: --
979: hr_utility.trace('old Element Name : ' ||p_element_name);
980: hr_utility.trace('New Element Name : ' ||l_new_element_name);
981: --
982: -- ONLY THIS CURSOR and GET_INPUT_VALUE_ID procedure USE NEW ELEMENT NAME
983: --
984: for c_ele_processing_type_rec in

Line 994: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');

990: l_processing_type := c_ele_processing_type_rec.processing_type;
991: exit;
992: end loop;
993: if not l_ele_proc_type_found then
994: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
995: hr_utility.raise_error;
996: end if;
997: hr_utility.set_location(l_proc, 2);
998: --

Line 995: hr_utility.raise_error;

991: exit;
992: end loop;
993: if not l_ele_proc_type_found then
994: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
995: hr_utility.raise_error;
996: end if;
997: hr_utility.set_location(l_proc, 2);
998: --
999:

Line 997: hr_utility.set_location(l_proc, 2);

993: if not l_ele_proc_type_found then
994: hr_utility.set_message(8301, 'GHR_38035_API_INV_PROC_TYPE');
995: hr_utility.raise_error;
996: end if;
997: hr_utility.set_location(l_proc, 2);
998: --
999:
1000: -- Retrieve element information if input value name is not null
1001: -- Using this p_element_name to pick old ele name under retrieve_element_info

Line 1003: hr_utility.set_location('l_value1: '||l_value1,10);

999:
1000: -- Retrieve element information if input value name is not null
1001: -- Using this p_element_name to pick old ele name under retrieve_element_info
1002: -- anyways. So passing old ele name than new ele name to avoid error.
1003: hr_utility.set_location('l_value1: '||l_value1,10);
1004: hr_utility.set_location('l_value2: '||l_value2,10);
1005: hr_utility.set_location('l_value3: '||l_value3,10);
1006: hr_utility.set_location('l_value4: '||l_value4,10);
1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);

Line 1004: hr_utility.set_location('l_value2: '||l_value2,10);

1000: -- Retrieve element information if input value name is not null
1001: -- Using this p_element_name to pick old ele name under retrieve_element_info
1002: -- anyways. So passing old ele name than new ele name to avoid error.
1003: hr_utility.set_location('l_value1: '||l_value1,10);
1004: hr_utility.set_location('l_value2: '||l_value2,10);
1005: hr_utility.set_location('l_value3: '||l_value3,10);
1006: hr_utility.set_location('l_value4: '||l_value4,10);
1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);
1008: if p_input_value_name1 is not NULL then

Line 1005: hr_utility.set_location('l_value3: '||l_value3,10);

1001: -- Using this p_element_name to pick old ele name under retrieve_element_info
1002: -- anyways. So passing old ele name than new ele name to avoid error.
1003: hr_utility.set_location('l_value1: '||l_value1,10);
1004: hr_utility.set_location('l_value2: '||l_value2,10);
1005: hr_utility.set_location('l_value3: '||l_value3,10);
1006: hr_utility.set_location('l_value4: '||l_value4,10);
1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);
1008: if p_input_value_name1 is not NULL then
1009: retrieve_element_info(p_element_name => p_element_name

Line 1006: hr_utility.set_location('l_value4: '||l_value4,10);

1002: -- anyways. So passing old ele name than new ele name to avoid error.
1003: hr_utility.set_location('l_value1: '||l_value1,10);
1004: hr_utility.set_location('l_value2: '||l_value2,10);
1005: hr_utility.set_location('l_value3: '||l_value3,10);
1006: hr_utility.set_location('l_value4: '||l_value4,10);
1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);
1008: if p_input_value_name1 is not NULL then
1009: retrieve_element_info(p_element_name => p_element_name
1010: ,p_input_value_name => p_input_value_name1

Line 1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);

1003: hr_utility.set_location('l_value1: '||l_value1,10);
1004: hr_utility.set_location('l_value2: '||l_value2,10);
1005: hr_utility.set_location('l_value3: '||l_value3,10);
1006: hr_utility.set_location('l_value4: '||l_value4,10);
1007: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,10);
1008: if p_input_value_name1 is not NULL then
1009: retrieve_element_info(p_element_name => p_element_name
1010: ,p_input_value_name => p_input_value_name1
1011: ,p_assignment_id => p_assignment_id

Line 1021: hr_utility.set_location('after fetch l_value1: '||l_value1,20);

1017: ,p_value => l_value1
1018: ,p_object_version_number => l_object_version_number
1019: ,p_multiple_error_flag => l_multiple_error_flag);
1020: end if;
1021: hr_utility.set_location('after fetch l_value1: '||l_value1,20);
1022: --
1023: if p_input_value_name2 is not NULL then
1024: IF p_input_value_name2 = 'Capped Other Pay' THEN
1025: retrieve_element_info(p_element_name => p_element_name

Line 1050: hr_utility.set_location('after fetch l_value2: '||l_value2,20);

1046: ,p_object_version_number => l_object_version_number
1047: ,p_multiple_error_flag => l_multiple_error_flag);
1048: END IF;
1049: end if;
1050: hr_utility.set_location('after fetch l_value2: '||l_value2,20);
1051: --
1052: if p_input_value_name3 is not NULL then
1053: retrieve_element_info(p_element_name => p_element_name
1054: ,p_input_value_name => p_input_value_name3

Line 1065: hr_utility.set_location('after fetch l_value3: '||l_value3,20);

1061: ,p_value => l_value3
1062: ,p_object_version_number => l_object_version_number
1063: ,p_multiple_error_flag => l_multiple_error_flag);
1064: end if;
1065: hr_utility.set_location('after fetch l_value3: '||l_value3,20);
1066: --
1067: if p_input_value_name4 is not NULL then
1068: retrieve_element_info(p_element_name => p_element_name
1069: ,p_input_value_name => p_input_value_name4

Line 1080: hr_utility.set_location('after fetch l_value4: '||l_value4,20);

1076: ,p_value => l_value4
1077: ,p_object_version_number => l_object_version_number
1078: ,p_multiple_error_flag => l_multiple_error_flag);
1079: end if;
1080: hr_utility.set_location('after fetch l_value4: '||l_value4,20);
1081: --
1082: if p_input_value_name5 is not NULL then
1083: retrieve_element_info(p_element_name => p_element_name
1084: ,p_input_value_name => p_input_value_name5

Line 1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);

1231: ,p_value => l_value15
1232: ,p_object_version_number => l_object_version_number
1233: ,p_multiple_error_flag => l_multiple_error_flag);
1234: end if;
1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);
1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);

Line 1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);

1232: ,p_object_version_number => l_object_version_number
1233: ,p_multiple_error_flag => l_multiple_error_flag);
1234: end if;
1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);
1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);

Line 1237: hr_utility.set_location('l_value1 '||l_value1,3);

1233: ,p_multiple_error_flag => l_multiple_error_flag);
1234: end if;
1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);
1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);

Line 1238: hr_utility.set_location('l_value2'||l_value2,4);

1234: end if;
1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);
1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);
1242: hr_utility.set_location(l_proc, 3);

Line 1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);

1235: hr_utility.set_location('l_element_entry_id after retrieve ' || to_char(l_element_entry_id),1);
1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);
1242: hr_utility.set_location(l_proc, 3);
1243: --

Line 1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);

1236: hr_utility.set_location('l_element_entry_id1 after retrieve ' || to_char(l_element_entry_id1),2);
1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);
1242: hr_utility.set_location(l_proc, 3);
1243: --
1244: -- if employee does not have the element entry

Line 1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);

1237: hr_utility.set_location('l_value1 '||l_value1,3);
1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);
1242: hr_utility.set_location(l_proc, 3);
1243: --
1244: -- if employee does not have the element entry
1245: --

Line 1242: hr_utility.set_location(l_proc, 3);

1238: hr_utility.set_location('l_value2'||l_value2,4);
1239: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id1),5);
1240: hr_utility.set_location('l_inp_val_id1'||to_char(l_input_value_id2),6);
1241: hr_utility.set_location('l_multiple_error_flag: '||l_multiple_error_flag,7);
1242: hr_utility.set_location(l_proc, 3);
1243: --
1244: -- if employee does not have the element entry
1245: --
1246: if (l_value1 is NULL and l_input_value_id1 is null and

Line 1378: hr_utility.set_location(l_proc, 4);

1374: (p_element_name => l_new_element_name
1375: ,p_input_value_name => p_input_value_name15
1376: ,p_effective_date => p_effective_date);
1377: end if;
1378: hr_utility.set_location(l_proc, 4);
1379: --
1380: begin
1381: savepoint cr_ent;
1382: py_element_entry_api.create_element_entry

Line 1465: hr_utility.set_location(l_proc||l_element_entry_id, 5);

1461: END;
1462: END IF;
1463: END IF;
1464: --End Bug# 6857127
1465: hr_utility.set_location(l_proc||l_element_entry_id, 5);
1466: Else
1467: --
1468: -- if one of the element entry values changed
1469: --

Line 1536: hr_utility.set_location('elt entry id : '||l_element_entry_id,10);

1532: ,p_effective_end_date => l_effective_end_date
1533: ,p_element_entry_id => l_element_entry_id
1534: ,p_object_version_number => l_object_version_number
1535: ,p_create_warning => l_create_warning);
1536: hr_utility.set_location('elt entry id : '||l_element_entry_id,10);
1537: Exception
1538: when others then
1539: rollback to cr_ent;
1540: raise;

Line 1567: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);

1563: -- Bug 3854447
1564: -- Get the NOA_FAMILCY_CODE by calling the function
1565: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);
1566: --
1567: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);
1568: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);
1569: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);
1570: If l_noa_code = '819' or l_noa_code = '818' or l_noa_code = '810' or
1571: l_noa_fam_code like 'GHR_SAL%' then

Line 1568: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);

1564: -- Get the NOA_FAMILCY_CODE by calling the function
1565: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);
1566: --
1567: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);
1568: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);
1569: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);
1570: If l_noa_code = '819' or l_noa_code = '818' or l_noa_code = '810' or
1571: l_noa_fam_code like 'GHR_SAL%' then
1572: l_value1 := p_value1;

Line 1569: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);

1565: l_noa_fam_code := ghr_pa_requests_pkg.get_noa_pm_family(l_noa_id);
1566: --
1567: hr_utility.set_location('l_noa_id is ' || l_noa_id,2);
1568: hr_utility.set_location('l_noa_code is ' || l_noa_code,2);
1569: hr_utility.set_location('l_noa_fam_code is ' || l_noa_fam_code,2);
1570: If l_noa_code = '819' or l_noa_code = '818' or l_noa_code = '810' or
1571: l_noa_fam_code like 'GHR_SAL%' then
1572: l_value1 := p_value1;
1573: l_value2 := p_value2;

Line 1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);

1617: IF p_element_name = 'Retention Allowance' AND p_value2 IS NULL AND p_value1 IS NOT NULL THEN
1618: l_value2 := p_value2;
1619: END IF;
1620:
1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);
1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);

Line 1622: hr_utility.set_location('p_value1 is ' || p_value1,2);

1618: l_value2 := p_value2;
1619: END IF;
1620:
1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);
1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);

Line 1623: hr_utility.set_location('l_value1 is ' || l_value1,2);

1619: END IF;
1620:
1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);
1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);

Line 1624: hr_utility.set_location('p_value2 is ' || p_value2,2);

1620:
1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);
1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);

Line 1625: hr_utility.set_location('l_value2 is ' || l_value2,2);

1621: hr_utility.set_location('l_element_entry_id' || to_char(l_element_entry_id),2);
1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);

Line 1626: hr_utility.set_location('p_value3 is ' || p_value3,2);

1622: hr_utility.set_location('p_value1 is ' || p_value1,2);
1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);

Line 1627: hr_utility.set_location('l_value3 is ' || l_value3,2);

1623: hr_utility.set_location('l_value1 is ' || l_value1,2);
1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);
1631: hr_utility.set_location('l_value5 is ' || l_value5,2);

Line 1628: hr_utility.set_location('p_value4 is ' || p_value4,2);

1624: hr_utility.set_location('p_value2 is ' || p_value2,2);
1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);
1631: hr_utility.set_location('l_value5 is ' || l_value5,2);
1632:

Line 1629: hr_utility.set_location('l_value4 is ' || l_value4,2);

1625: hr_utility.set_location('l_value2 is ' || l_value2,2);
1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);
1631: hr_utility.set_location('l_value5 is ' || l_value5,2);
1632:
1633: -- Bug#2759379 Added this condition to facilitate user to make Eligibility Expiration to NULL

Line 1630: hr_utility.set_location('p_value5 is ' || p_value5,2);

1626: hr_utility.set_location('p_value3 is ' || p_value3,2);
1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);
1631: hr_utility.set_location('l_value5 is ' || l_value5,2);
1632:
1633: -- Bug#2759379 Added this condition to facilitate user to make Eligibility Expiration to NULL
1634: IF p_element_name = 'FEGLI' and p_value2 is null then

Line 1631: hr_utility.set_location('l_value5 is ' || l_value5,2);

1627: hr_utility.set_location('l_value3 is ' || l_value3,2);
1628: hr_utility.set_location('p_value4 is ' || p_value4,2);
1629: hr_utility.set_location('l_value4 is ' || l_value4,2);
1630: hr_utility.set_location('p_value5 is ' || p_value5,2);
1631: hr_utility.set_location('l_value5 is ' || l_value5,2);
1632:
1633: -- Bug#2759379 Added this condition to facilitate user to make Eligibility Expiration to NULL
1634: IF p_element_name = 'FEGLI' and p_value2 is null then
1635: l_value2 := null;

Line 1713: hr_utility.set_location(' Leaving:'||l_proc, 20);

1709: --
1710: end if;
1711: End if;
1712:
1713: hr_utility.set_location(' Leaving:'||l_proc, 20);
1714: Exception when others then
1715: --
1716: -- Reset IN OUT parameters and set OUT parameters
1717: --