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

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_UTILITY_PKG

Line 264: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN or START_DATE',1);

260: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
261: fetch l_dyn_csr into p_ovn, l_start_date;
262: close l_dyn_csr;
263: if l_start_date is null or p_ovn is null then
264: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN or START_DATE',1);
265: else
266: hr_utility.set_location(l_proc, 20);
267: p_mode := 'UPDATE'; -- default to this mode
268: if p_effective_date = l_start_date then

Line 293: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN',1);

289: fetch l_dyn_csr into p_ovn;
290: close l_dyn_csr;
291: hr_utility.set_location(l_proc, 50);
292: if p_ovn is null then
293: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN',1);
294: end if;
295: end if;
296:
297: hr_utility.set_location('Leaving:'||l_proc, 50);

Line 362: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);

358: for v_api_details in csr_api(p_ASG_results(1).cagr_api_id) loop
359: l_count := l_count+1;
360: l_api_details(l_count) := v_api_details;
361: end loop;
362: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);
363:
364: -- loop thru each ent result and create mapping record(s)
365: for i in p_ASG_results.first..p_ASG_results.last loop
366: l_map_count := l_map_count+1;

Line 372: per_cagr_utility_pkg.put_log(' created mapping record: '||

368: -- get the PARAMETER_NAME and UOM column from the API details structure
369: for j in l_api_details.first..l_api_details.last loop
370: if l_api_details(j).cagr_api_param_id = p_ASG_results(i).cagr_api_param_id then
371: l_mapping_table(l_map_count).parameter_name := l_api_details(j).parameter_name;
372: per_cagr_utility_pkg.put_log(' created mapping record: '||
373: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
374: -- also create a mapping table record, if there is a uom col
375: if l_api_details(j).uom_parameter is not null then
376: l_map_count := l_map_count+1;

Line 379: per_cagr_utility_pkg.put_log(' created mapping record: '||

375: if l_api_details(j).uom_parameter is not null then
376: l_map_count := l_map_count+1;
377: l_mapping_table(l_map_count).parameter_name := l_api_details(j).uom_parameter;
378: l_mapping_table(l_map_count).value := p_ASG_results(i).units_of_measure;
379: per_cagr_utility_pkg.put_log(' created mapping record: '||
380: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
381: end if;
382: exit;
383: end if;

Line 387: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);

383: end if;
384: end loop;
385: end loop;
386:
387: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
388: if l_mapping_table.count > 0 then
389: if l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG' then
390:
391: -- Bug 14489891

Line 406: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG in mode: '||l_dt_mode||' , OVN: '||l_ovn,1);

402: ,p_effective_date => p_params.effective_date
403: ,p_mode => l_dt_mode
404: ,p_ovn => l_ovn);
405:
406: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG in mode: '||l_dt_mode||' , OVN: '||l_ovn,1);
407: BEGIN
408:
409: hr_assignment_api.update_emp_asg
410: (p_effective_date => p_params.effective_date

Line 499: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);

495: ,p_other_manager_warning => l_other_manager_warning);
496:
497: -- log any warnings
498: if l_no_managers_warning then
499: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
500: elsif l_other_manager_warning then
501: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
502: end if;
503: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);

Line 501: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);

497: -- log any warnings
498: if l_no_managers_warning then
499: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
500: elsif l_other_manager_warning then
501: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
502: end if;
503: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
504: EXCEPTION
505: when others then -- log unexpected API error, and continue

Line 503: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);

499: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
500: elsif l_other_manager_warning then
501: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
502: end if;
503: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
504: EXCEPTION
505: when others then -- log unexpected API error, and continue
506: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
507: --

Line 506: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

502: end if;
503: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
504: EXCEPTION
505: when others then -- log unexpected API error, and continue
506: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
507: --
508: -- To show the Dictionary message in the log file
509: --
510: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

Line 510: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

506: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
507: --
508: -- To show the Dictionary message in the log file
509: --
510: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
511: --
512: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
513: END;
514:

Line 512: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

508: -- To show the Dictionary message in the log file
509: --
510: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
511: --
512: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
513: END;
514:
515: elsif l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA' then
516:

Line 525: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA in mode: '||l_dt_mode||', OVN: '||l_ovn,1);

521: ,p_effective_date => p_params.effective_date
522: ,p_mode => l_dt_mode
523: ,p_ovn => l_ovn);
524:
525: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA in mode: '||l_dt_mode||', OVN: '||l_ovn,1);
526: BEGIN
527: hr_assignment_api.update_emp_asg_criteria
528: (p_effective_date => p_params.effective_date
529: ,p_datetrack_update_mode => l_dt_mode

Line 551: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);

547: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
548:
549: -- log any warnings
550: if l_no_managers_warning then
551: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
552: elsif l_other_manager_warning then
553: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
554: elsif l_spp_delete_warning then
555: l_warn_message := fnd_message.get_string(

Line 553: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);

549: -- log any warnings
550: if l_no_managers_warning then
551: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
552: elsif l_other_manager_warning then
553: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
554: elsif l_spp_delete_warning then
555: l_warn_message := fnd_message.get_string(
556: APPIN => 'PER'
557: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');

Line 558: per_cagr_utility_pkg.put_log(' WARNING: '||l_warn_message,1);

554: elsif l_spp_delete_warning then
555: l_warn_message := fnd_message.get_string(
556: APPIN => 'PER'
557: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');
558: per_cagr_utility_pkg.put_log(' WARNING: '||l_warn_message,1);
559: end if;
560: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
561: EXCEPTION
562: when others then -- log unexpected API error, and continue

Line 560: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);

556: APPIN => 'PER'
557: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');
558: per_cagr_utility_pkg.put_log(' WARNING: '||l_warn_message,1);
559: end if;
560: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
561: EXCEPTION
562: when others then -- log unexpected API error, and continue
563: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
564: --

Line 563: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

559: end if;
560: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
561: EXCEPTION
562: when others then -- log unexpected API error, and continue
563: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
564: --
565: -- To show the Dictionary message in the log file
566: --
567: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

Line 567: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

563: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
564: --
565: -- To show the Dictionary message in the log file
566: --
567: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
568: --
569: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
570: END;
571:

Line 569: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

565: -- To show the Dictionary message in the log file
566: --
567: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
568: --
569: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
570: END;
571:
572: end if;
573: end if;

Line 665: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);

661: for v_api_details in csr_api('HR_SP_PLACEMENT_API.UPDATE_SPP') loop
662: l_count := l_count+1;
663: l_api_details(l_count) := v_api_details;
664: end loop;
665: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);
666:
667: -- loop thru each ent result and create mapping record(s)
668: for i in p_PYS_results.first..p_PYS_results.last loop
669: l_map_count := l_map_count+1;

Line 678: per_cagr_utility_pkg.put_log(' created mapping record: '||

674: -- the cagr_api_param_id does not necessarily match between results reference update api
675: -- but we have identified that we actually need to use create, so use parameter name instead...
676: if l_api_details(j).cagr_api_param_id = p_PYS_results(i).cagr_api_param_id then
677: l_mapping_table(l_map_count).parameter_name := l_api_details(j).parameter_name;
678: per_cagr_utility_pkg.put_log(' created mapping record: '||
679: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
680: -- also create a mapping table record, if there is a uom col
681: if l_api_details(j).uom_parameter is not null then
682: l_map_count := l_map_count+1;

Line 685: per_cagr_utility_pkg.put_log(' created mapping record: '||

681: if l_api_details(j).uom_parameter is not null then
682: l_map_count := l_map_count+1;
683: l_mapping_table(l_map_count).parameter_name := l_api_details(j).uom_parameter;
684: l_mapping_table(l_map_count).value := p_PYS_results(i).units_of_measure;
685: per_cagr_utility_pkg.put_log(' created mapping record: '||
686: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
687: end if;
688: exit;
689: end if;

Line 693: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);

689: end if;
690: end loop;
691: end loop;
692:
693: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
694:
695: if l_map_count > 0 then
696: BEGIN
697: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then

Line 699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);

695: if l_map_count > 0 then
696: BEGIN
697: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
698:
699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
700: l_step_id := get_num_val('STEP_ID',l_mapping_table);
701: if l_step_id is null then
702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

Line 703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
700: l_step_id := get_num_val('STEP_ID',l_mapping_table);
701: if l_step_id is null then
702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);

Line 705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);

701: if l_step_id is null then
702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
709: hr_sp_placement_api.create_spp

Line 706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);

702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
709: hr_sp_placement_api.create_spp
710: (p_effective_date => p_params.effective_date

Line 707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);

703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
709: hr_sp_placement_api.create_spp
710: (p_effective_date => p_params.effective_date
711: ,p_business_group_id => p_params.business_group_id

Line 708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);

704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
709: hr_sp_placement_api.create_spp
710: (p_effective_date => p_params.effective_date
711: ,p_business_group_id => p_params.business_group_id
712: ,p_assignment_id => p_params.assignment_id -- current assignment

Line 718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);

714: ,p_object_version_number => l_ovn
715: ,p_placement_id => l_placement_id
716: ,p_effective_start_date => l_effective_start_date
717: ,p_effective_end_date => l_effective_end_date);
718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;

Line 719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);

715: ,p_placement_id => l_placement_id
716: ,p_effective_start_date => l_effective_start_date
717: ,p_effective_end_date => l_effective_end_date);
718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then

Line 720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);

716: ,p_effective_start_date => l_effective_start_date
717: ,p_effective_end_date => l_effective_end_date);
718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:

Line 721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);

717: ,p_effective_end_date => l_effective_end_date);
718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:
725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);

Line 725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);

721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:
725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
726: hr_sp_placement_api.update_spp
727: (p_effective_date => p_params.effective_date
728: ,p_datetrack_mode => l_dt_mode
729: ,p_placement_id => l_placement_id

Line 735: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);

731: ,p_object_version_number => l_ovn
732: ,p_effective_start_date => l_effective_start_date
733: ,p_effective_end_date => l_effective_end_date);
734:
735: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
736: end if;
737: EXCEPTION
738: when others then -- log unexpected API error, and continue
739: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

Line 739: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

735: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
736: end if;
737: EXCEPTION
738: when others then -- log unexpected API error, and continue
739: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
740: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
741: END;
742:
743: end if;

Line 740: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

736: end if;
737: EXCEPTION
738: when others then -- log unexpected API error, and continue
739: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
740: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
741: END;
742:
743: end if;
744:

Line 914: per_cagr_utility_pkg.put_log('Override entry exists - only this will be updated: '||v_entries.element_entry_id);

910: fetch csr_entries into v_entries;
911: exit when csr_entries%notfound;
912: if v_entries.entry_type = 'S' then
913: -- store the override entry id
914: per_cagr_utility_pkg.put_log('Override entry exists - only this will be updated: '||v_entries.element_entry_id);
915: l_entry_id := v_entries.element_entry_id;
916: end if;
917: end loop;
918: else

Line 937: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);

933:
934: if l_too_many_entries = 'Y' and p_PAY_results(i).multiple_entries_allowed_flag = 'N'
935: and l_entry_id is null then
936: -- not an override GB element entry so show message
937: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
938: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
939: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
940: ||'effective_date and updating multiple entries is not allowed.',1);
941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);

Line 938: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);

934: if l_too_many_entries = 'Y' and p_PAY_results(i).multiple_entries_allowed_flag = 'N'
935: and l_entry_id is null then
936: -- not an override GB element entry so show message
937: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
938: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
939: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
940: ||'effective_date and updating multiple entries is not allowed.',1);
941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
942: else

Line 939: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '

935: and l_entry_id is null then
936: -- not an override GB element entry so show message
937: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
938: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
939: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
940: ||'effective_date and updating multiple entries is not allowed.',1);
941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
942: else
943: -- build the mapping table for the results

Line 941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);

937: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
938: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
939: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
940: ||'effective_date and updating multiple entries is not allowed.',1);
941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
942: else
943: -- build the mapping table for the results
944: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
945: l_map_count := l_map_count+1;

Line 944: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);

940: ||'effective_date and updating multiple entries is not allowed.',1);
941: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
942: else
943: -- build the mapping table for the results
944: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
945: l_map_count := l_map_count+1;
946: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
947: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
948: l_map_count := l_map_count+1;

Line 951: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);

947: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
948: l_map_count := l_map_count+1;
949: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
950: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
951: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
952: end if;
953:
954: end loop;
955:

Line 956: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);

952: end if;
953:
954: end loop;
955:
956: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
957:
958: if l_mapping_table.count > 0 then
959:
960: -- get all entry recs for the element type on the effective_date

Line 982: per_cagr_utility_pkg.put_log(' calling PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);

978:
979: -- if the element entry is non recurring then api should be called in CORRECTION mode only.
980: -- check here, or modify get_ovn_and_mode
981:
982: per_cagr_utility_pkg.put_log(' calling PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
983: BEGIN
984: py_element_entry_api.update_element_entry(
985: p_datetrack_update_mode => l_dt_mode,
986: p_effective_date => p_params.effective_date,

Line 1026: per_cagr_utility_pkg.put_log(' WARNING: p_update_warning',1);

1022: p_update_warning => l_warning);
1023:
1024: -- log any warnings
1025: if l_warning then
1026: per_cagr_utility_pkg.put_log(' WARNING: p_update_warning',1);
1027: end if;
1028: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1029: EXCEPTION
1030: when others then -- log unexpected API error, and continue

Line 1028: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);

1024: -- log any warnings
1025: if l_warning then
1026: per_cagr_utility_pkg.put_log(' WARNING: p_update_warning',1);
1027: end if;
1028: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1029: EXCEPTION
1030: when others then -- log unexpected API error, and continue
1031: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1032: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

Line 1031: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

1027: end if;
1028: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1029: EXCEPTION
1030: when others then -- log unexpected API error, and continue
1031: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1032: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1033: END;
1034: end loop;
1035: if csr_entries%rowcount = 0 then

Line 1032: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1028: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1029: EXCEPTION
1030: when others then -- log unexpected API error, and continue
1031: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1032: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1033: END;
1034: end loop;
1035: if csr_entries%rowcount = 0 then
1036: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||

Line 1036: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||

1032: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1033: END;
1034: end loop;
1035: if csr_entries%rowcount = 0 then
1036: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||
1037: p_pay_results(1).element_type_id||' on assignment '||
1038: p_pay_results(1).assignment_id,1);
1039: end if;
1040: close csr_entries;

Line 1055: per_cagr_utility_pkg.put_log('New EE Entries ',5);

1051:
1052: l_map_count := 0;
1053: l_warning := FALSE;
1054:
1055: per_cagr_utility_pkg.put_log('New EE Entries ',5);
1056: -- build and populate mapping table with iv_ids and entry values
1057: -- from the table of entitlement result records
1058: for i in p_PAY_results.first..p_PAY_results.last loop
1059:

Line 1062: per_cagr_utility_pkg.put_log('map count = '||l_map_count,5);

1058: for i in p_PAY_results.first..p_PAY_results.last loop
1059:
1060: -- build the mapping table for the results
1061: l_map_count := l_map_count+1;
1062: per_cagr_utility_pkg.put_log('map count = '||l_map_count,5);
1063: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1064: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1065: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1066: l_map_count := l_map_count+1;

Line 1064: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);

1060: -- build the mapping table for the results
1061: l_map_count := l_map_count+1;
1062: per_cagr_utility_pkg.put_log('map count = '||l_map_count,5);
1063: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1064: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1065: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1066: l_map_count := l_map_count+1;
1067: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1068: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;

Line 1067: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);

1063: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1064: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1065: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1066: l_map_count := l_map_count+1;
1067: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1068: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
1069: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
1070: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1071:

Line 1070: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);

1066: l_map_count := l_map_count+1;
1067: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1068: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
1069: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
1070: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1071:
1072: end loop;
1073:
1074: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count,5);

Line 1074: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count,5);

1070: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1071:
1072: end loop;
1073:
1074: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count,5);
1075:
1076: if l_mapping_table.count > 0 then
1077:
1078: -- get all entry recs for the assignment on the effective_date

Line 1099: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);

1095: (p_assignment_id => p_params.assignment_id,
1096: p_element_type_id => v_entries_not_exists.element_type_id,
1097: p_session_date => p_params.effective_date);
1098:
1099: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1100: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1101: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1102: pay_element_entry_api.create_element_entry(
1103: p_validate => FALSE,

Line 1100: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);

1096: p_element_type_id => v_entries_not_exists.element_type_id,
1097: p_session_date => p_params.effective_date);
1098:
1099: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1100: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1101: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1102: pay_element_entry_api.create_element_entry(
1103: p_validate => FALSE,
1104: p_effective_date => p_params.effective_date,

Line 1101: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);

1097: p_session_date => p_params.effective_date);
1098:
1099: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1100: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1101: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1102: pay_element_entry_api.create_element_entry(
1103: p_validate => FALSE,
1104: p_effective_date => p_params.effective_date,
1105: p_business_group_id => p_params.business_group_id,

Line 1144: per_cagr_utility_pkg.put_log(' End of create element entry.');

1140: p_effective_end_date => l_effective_end_date,
1141: p_element_entry_id => l_element_entry_id,
1142: p_object_version_number => l_ovn,
1143: p_create_warning => l_warning);
1144: per_cagr_utility_pkg.put_log(' End of create element entry.');
1145: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1146:
1147: -- log any warnings
1148: if l_warning then

Line 1145: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);

1141: p_element_entry_id => l_element_entry_id,
1142: p_object_version_number => l_ovn,
1143: p_create_warning => l_warning);
1144: per_cagr_utility_pkg.put_log(' End of create element entry.');
1145: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1146:
1147: -- log any warnings
1148: if l_warning then
1149: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);

Line 1149: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);

1145: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1146:
1147: -- log any warnings
1148: if l_warning then
1149: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);
1150: end if;
1151: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1152: EXCEPTION
1153: when others then -- log unexpected API error, and continue

Line 1151: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);

1147: -- log any warnings
1148: if l_warning then
1149: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);
1150: end if;
1151: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1152: EXCEPTION
1153: when others then -- log unexpected API error, and continue
1154: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1155: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

Line 1154: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

1150: end if;
1151: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1152: EXCEPTION
1153: when others then -- log unexpected API error, and continue
1154: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1155: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1156: END;
1157:
1158: else

Line 1155: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1151: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1152: EXCEPTION
1153: when others then -- log unexpected API error, and continue
1154: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1155: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1156: END;
1157:
1158: else
1159:

Line 1162: per_cagr_utility_pkg.put_log(' WARNING: Auto Entry flag for Entitlement Item is not checked');

1158: else
1159:
1160: close csr_entitlement_items;
1161:
1162: per_cagr_utility_pkg.put_log(' WARNING: Auto Entry flag for Entitlement Item is not checked');
1163:
1164: end if;
1165:
1166: end loop;

Line 1168: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||

1164: end if;
1165:
1166: end loop;
1167: if csr_entries_not_exists%rowcount = 0 then
1168: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||
1169: p_pay_results(1).element_type_id||' on assignment '||
1170: p_pay_results(1).assignment_id,1);
1171: end if;
1172: close csr_entries_not_exists;

Line 1327: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);

1323:
1324: hr_utility.set_location('Entering:'||l_proc, 5);
1325:
1326: if p_params.category is null or p_params.category = 'ASG' then
1327: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1328:
1329: -- open cursor for ASG results for denormalisation, and collect pl/sql table
1330: for v_ASG_results in csr_ASG_denorm_results loop
1331: per_cagr_utility_pkg.put_log(' found result record for item: '||v_ASG_results.cagr_entitlement_item_id);

Line 1331: per_cagr_utility_pkg.put_log(' found result record for item: '||v_ASG_results.cagr_entitlement_item_id);

1327: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1328:
1329: -- open cursor for ASG results for denormalisation, and collect pl/sql table
1330: for v_ASG_results in csr_ASG_denorm_results loop
1331: per_cagr_utility_pkg.put_log(' found result record for item: '||v_ASG_results.cagr_entitlement_item_id);
1332:
1333: if (l_old_cagr_api_id <> 0 and l_old_cagr_api_id <> v_ASG_results.cagr_api_id) then
1334: -- the cagr_api_id has changed so call_the relevant API to denormalise
1335: call_ASG_api(p_params,l_ASG_results);

Line 1354: per_cagr_utility_pkg.put_log(' Completed ASSIGNMENT category items.',1);

1350:
1351: -- bug 2289200 reset variable to 0;
1352: l_old_cagr_api_id := 0;
1353:
1354: per_cagr_utility_pkg.put_log(' Completed ASSIGNMENT category items.',1);
1355: per_cagr_utility_pkg.put_log(' ');
1356: end if;
1357:
1358: if p_params.category is null or p_params.category = 'PYS' then

Line 1355: per_cagr_utility_pkg.put_log(' ');

1351: -- bug 2289200 reset variable to 0;
1352: l_old_cagr_api_id := 0;
1353:
1354: per_cagr_utility_pkg.put_log(' Completed ASSIGNMENT category items.',1);
1355: per_cagr_utility_pkg.put_log(' ');
1356: end if;
1357:
1358: if p_params.category is null or p_params.category = 'PYS' then
1359: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);

Line 1359: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);

1355: per_cagr_utility_pkg.put_log(' ');
1356: end if;
1357:
1358: if p_params.category is null or p_params.category = 'PYS' then
1359: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);
1360:
1361: for v_PYS_results in csr_PYS_denorm_results loop
1362: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PYS_results.cagr_entitlement_item_id);
1363:

Line 1362: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PYS_results.cagr_entitlement_item_id);

1358: if p_params.category is null or p_params.category = 'PYS' then
1359: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);
1360:
1361: for v_PYS_results in csr_PYS_denorm_results loop
1362: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PYS_results.cagr_entitlement_item_id);
1363:
1364: if (l_old_cagr_api_id <> 0 and l_old_cagr_api_id <> v_PYS_results.cagr_api_id) then
1365: -- the cagr_api_id has changed so call_the relevant API to denormalise
1366: call_PYS_api(p_params,l_PYS_results);

Line 1385: per_cagr_utility_pkg.put_log(' Completed PAY SCALE category items.',1);

1381:
1382: -- bug 2289200 reset variable to 0;
1383: l_old_cagr_api_id := 0;
1384:
1385: per_cagr_utility_pkg.put_log(' Completed PAY SCALE category items.',1);
1386: per_cagr_utility_pkg.put_log(' ');
1387: end if;
1388:
1389: if p_params.category is null or p_params.category = 'PAY' then

Line 1386: per_cagr_utility_pkg.put_log(' ');

1382: -- bug 2289200 reset variable to 0;
1383: l_old_cagr_api_id := 0;
1384:
1385: per_cagr_utility_pkg.put_log(' Completed PAY SCALE category items.',1);
1386: per_cagr_utility_pkg.put_log(' ');
1387: end if;
1388:
1389: if p_params.category is null or p_params.category = 'PAY' then
1390: per_cagr_utility_pkg.put_log(' Starting PAYROLL category items...',1);

Line 1390: per_cagr_utility_pkg.put_log(' Starting PAYROLL category items...',1);

1386: per_cagr_utility_pkg.put_log(' ');
1387: end if;
1388:
1389: if p_params.category is null or p_params.category = 'PAY' then
1390: per_cagr_utility_pkg.put_log(' Starting PAYROLL category items...',1);
1391:
1392: -- loop through all element results, populating pl/sql table with values
1393: -- and calling denormalise routine for each element type in the cursor.
1394: for v_PAY_results in csr_PAY_denorm_results loop

Line 1395: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PAY_results.cagr_entitlement_item_id);

1391:
1392: -- loop through all element results, populating pl/sql table with values
1393: -- and calling denormalise routine for each element type in the cursor.
1394: for v_PAY_results in csr_PAY_denorm_results loop
1395: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PAY_results.cagr_entitlement_item_id);
1396:
1397: if (l_old_element_type_id <> 0 and l_old_element_type_id <> v_PAY_results.element_type_id) then
1398: -- the element_type has changed so call element entry API to denormalise
1399: -- entry values for the element_type

Line 1402: per_cagr_utility_pkg.put_log(' ERROR: > 15 results for this element_type means data lost, skipping element');

1398: -- the element_type has changed so call element entry API to denormalise
1399: -- entry values for the element_type
1400: if l_PAY_results.count > 15 then
1401: -- error as too many results for the update api call for the element
1402: per_cagr_utility_pkg.put_log(' ERROR: > 15 results for this element_type means data lost, skipping element');
1403: else
1404: call_PAY_api(p_params,l_PAY_results);
1405: l_PAY_results.delete;
1406: l_table_counter := 0;

Line 1424: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);

1420:
1421: -- bug 2289200 reset variable to 0;
1422: l_old_cagr_api_id := 0;
1423:
1424: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1425: per_cagr_utility_pkg.put_log(' ');
1426: end if;
1427:
1428: hr_utility.set_location('Leaving:'||l_proc, 100);

Line 1425: per_cagr_utility_pkg.put_log(' ');

1421: -- bug 2289200 reset variable to 0;
1422: l_old_cagr_api_id := 0;
1423:
1424: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1425: per_cagr_utility_pkg.put_log(' ');
1426: end if;
1427:
1428: hr_utility.set_location('Leaving:'||l_proc, 100);
1429:

Line 1434: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1430:
1431: EXCEPTION
1432: when others then
1433: -- write the log contents
1434: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1435: raise;
1436:
1437: END do_apply_for_assignment;
1438:

Line 1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1444:
1445: hr_utility.set_location('Entering:'||l_proc, 5);
1446: --
1447: if not(g_done_header) then
1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1450: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1452: ||fnd_date.date_to_canonical(sysdate)||')',1);

Line 1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);

1445: hr_utility.set_location('Entering:'||l_proc, 5);
1446: --
1447: if not(g_done_header) then
1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1450: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1452: ||fnd_date.date_to_canonical(sysdate)||')',1);
1453:

Line 1450: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1446: --
1447: if not(g_done_header) then
1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1450: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1452: ||fnd_date.date_to_canonical(sysdate)||')',1);
1453:
1454: If p_params.operation_mode = 'SA' then

Line 1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('

1447: if not(g_done_header) then
1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1450: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1452: ||fnd_date.date_to_canonical(sysdate)||')',1);
1453:
1454: If p_params.operation_mode = 'SA' then
1455: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);

Line 1455: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);

1451: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1452: ||fnd_date.date_to_canonical(sysdate)||')',1);
1453:
1454: If p_params.operation_mode = 'SA' then
1455: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);
1456: elsif p_params.operation_mode = 'SC' then
1457: per_cagr_utility_pkg.put_log(' Mode: Single Collective Agreement',1);
1458: end if;
1459:

Line 1457: per_cagr_utility_pkg.put_log(' Mode: Single Collective Agreement',1);

1453:
1454: If p_params.operation_mode = 'SA' then
1455: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);
1456: elsif p_params.operation_mode = 'SC' then
1457: per_cagr_utility_pkg.put_log(' Mode: Single Collective Agreement',1);
1458: end if;
1459:
1460: /* redundant
1461: If p_select_flag = 'B' then

Line 1462: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);

1458: end if;
1459:
1460: /* redundant
1461: If p_select_flag = 'B' then
1462: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1463: elsif p_select_flag = 'C' then
1464: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1465: end if;
1466: */

Line 1464: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);

1460: /* redundant
1461: If p_select_flag = 'B' then
1462: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1463: elsif p_select_flag = 'C' then
1464: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1465: end if;
1466: */
1467: end if;
1468: g_done_header := FALSE;

Line 1473: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_CATEGORY',p_params.cagr_request_id);

1469: --
1470: --
1471: if p_params.category is not null then
1472: if p_params.category not in ('ASG','PAY','PYS','ABS') then
1473: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_CATEGORY',p_params.cagr_request_id);
1474: end if;
1475: end if;
1476:
1477:

Line 1483: per_cagr_utility_pkg.put_log(' ',1);

1479: --
1480: -- ********* single assignment *********
1481: --
1482:
1483: per_cagr_utility_pkg.put_log(' ',1);
1484: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1485: ' during Single Assignment Agreement mode.',1);
1486: do_apply_for_assignment(p_params, p_select_flag);
1487:

Line 1484: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||

1480: -- ********* single assignment *********
1481: --
1482:
1483: per_cagr_utility_pkg.put_log(' ',1);
1484: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1485: ' during Single Assignment Agreement mode.',1);
1486: do_apply_for_assignment(p_params, p_select_flag);
1487:
1488: --

Line 1492: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);

1488: --
1489: -- Commit, if required.
1490: --
1491: if p_params.commit_flag = 'Y' then
1492: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1493: commit;
1494: elsif p_params.commit_flag = 'N' then
1495: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1496: rollback;

Line 1495: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);

1491: if p_params.commit_flag = 'Y' then
1492: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1493: commit;
1494: elsif p_params.commit_flag = 'N' then
1495: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1496: rollback;
1497: end if;
1498:
1499: elsif p_params.operation_mode = 'SC' then

Line 1516: per_cagr_utility_pkg.put_log(' Identified the following assignments on the collective agreement:',1);

1512: -- when the results were evaluated, and are visible from PERWSCAR), but a
1513: -- file of combined parent request and asg denorm log entries is also
1514: -- created when we are running under CM.
1515: --
1516: per_cagr_utility_pkg.put_log(' Identified the following assignments on the collective agreement:',1);
1517: --
1518: -- first load all the assignment ids to be processed into pl/sql table.
1519: --
1520: open csr_assignments_to_process;

Line 1525: per_cagr_utility_pkg.put_log(' '||t_assignment_list(l_counter).assignment_id,1);

1521: loop
1522: l_counter := l_counter+1;
1523: fetch csr_assignments_to_process into t_assignment_list(l_counter);
1524: exit when csr_assignments_to_process%notfound;
1525: per_cagr_utility_pkg.put_log(' '||t_assignment_list(l_counter).assignment_id,1);
1526: end loop;
1527: close csr_assignments_to_process;
1528:
1529:

Line 1531: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1527: close csr_assignments_to_process;
1528:
1529:
1530: -- write the log out and save the request_id
1531: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1532: l_parent_request_id := p_params.cagr_request_id;
1533:
1534: -- could now break pl/sql table into varray subsets, ready for multiple threads
1535:

Line 1545: per_cagr_utility_pkg.put_log(' ',1);

1541: p_params.assignment_id := t_assignment_list(k).assignment_id;
1542: p_params.cagr_request_id := get_request_id(t_assignment_list(k).assignment_id
1543: ,p_params.effective_date);
1544:
1545: per_cagr_utility_pkg.put_log(' ',1);
1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1549:

Line 1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1542: p_params.cagr_request_id := get_request_id(t_assignment_list(k).assignment_id
1543: ,p_params.effective_date);
1544:
1545: per_cagr_utility_pkg.put_log(' ',1);
1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1549:
1550: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||

Line 1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);

1543: ,p_params.effective_date);
1544:
1545: per_cagr_utility_pkg.put_log(' ',1);
1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1549:
1550: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1551: ' during Single Collective Agreement mode.',1);

Line 1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1544:
1545: per_cagr_utility_pkg.put_log(' ',1);
1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1549:
1550: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1551: ' during Single Collective Agreement mode.',1);
1552:

Line 1550: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||

1546: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1547: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1548: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1549:
1550: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1551: ' during Single Collective Agreement mode.',1);
1552:
1553:
1554: if p_params.cagr_request_id is null then

Line 1565: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);

1561: --
1562: -- Commit, if required.
1563: --
1564: if p_params.commit_flag = 'Y' then
1565: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1566: commit;
1567: elsif p_params.commit_flag = 'N' then
1568: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1569: rollback;

Line 1568: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);

1564: if p_params.commit_flag = 'Y' then
1565: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1566: commit;
1567: elsif p_params.commit_flag = 'N' then
1568: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1569: rollback;
1570: end if;
1571:
1572: -- complete the logging for this asg

Line 1573: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1569: rollback;
1570: end if;
1571:
1572: -- complete the logging for this asg
1573: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1574:
1575: Exception
1576: when others then
1577: -- complete the logging for this asg

Line 1578: per_cagr_utility_pkg.put_log('ERROR: '||sqlerrm);

1574:
1575: Exception
1576: when others then
1577: -- complete the logging for this asg
1578: per_cagr_utility_pkg.put_log('ERROR: '||sqlerrm);
1579: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1580: End;
1581: END LOOP;
1582:

Line 1579: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1575: Exception
1576: when others then
1577: -- complete the logging for this asg
1578: per_cagr_utility_pkg.put_log('ERROR: '||sqlerrm);
1579: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1580: End;
1581: END LOOP;
1582:
1583: -- restore the original request id, now all asgs have completed

Line 1590: per_cagr_utility_pkg.put_log('Completed Result Population Process ('

1586: else
1587: null; -- do processing for other modes...
1588: end if;
1589:
1590: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1591: ||fnd_date.date_to_canonical(sysdate)||')',1);
1592: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1593: hr_utility.set_location('Leaving:'||l_proc, 100);
1594:

Line 1592: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1588: end if;
1589:
1590: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1591: ||fnd_date.date_to_canonical(sysdate)||')',1);
1592: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1593: hr_utility.set_location('Leaving:'||l_proc, 100);
1594:
1595:
1596: EXCEPTION

Line 1599: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

1595:
1596: EXCEPTION
1597: when others then
1598: -- write the log contents
1599: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1600: raise;
1601: END initialise;
1602:
1603: --

Line 1655: per_cagr_utility_pkg.create_cagr_request(p_process_date => p_process_date

1651: -- (if called from PERWSCAR.fmb or evaluation process we use the request_id
1652: -- that gave rise to the results which we are about to denormalise, so evaluation log records
1653: -- are appended with entitlement population process entries)
1654: --
1655: per_cagr_utility_pkg.create_cagr_request(p_process_date => p_process_date
1656: ,p_operation_mode => p_operation_mode
1657: ,p_business_group_id => p_business_group_id
1658: ,p_assignment_id => p_assignment_id
1659: ,p_assignment_set_id => p_assignment_set_id

Line 1685: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1681:
1682: --
1683: -- Output denormalization log header
1684: --
1685: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1686: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1687: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1688: g_done_header := TRUE;
1689:

Line 1686: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);

1682: --
1683: -- Output denormalization log header
1684: --
1685: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1686: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1687: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1688: g_done_header := TRUE;
1689:
1690: --

Line 1687: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);

1683: -- Output denormalization log header
1684: --
1685: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1686: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1687: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1688: g_done_header := TRUE;
1689:
1690: --
1691: -- validate parameters

Line 1694: per_cagr_utility_pkg.log_and_raise_error('HR_289419_CAGR_INV_CFLAG'

1690: --
1691: -- validate parameters
1692: --
1693: if not (p_commit_flag in ('N','Y')) then
1694: per_cagr_utility_pkg.log_and_raise_error('HR_289419_CAGR_INV_CFLAG'
1695: ,p_cagr_request_id);
1696: end if;
1697:
1698: /* select_flag is redundant

Line 1700: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_SFLAG'

1696: end if;
1697:
1698: /* select_flag is redundant
1699: if not (p_select_flag in ('B','C')) then
1700: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_SFLAG'
1701: ,p_cagr_request_id);
1702: end if;
1703: */
1704:

Line 1707: per_cagr_utility_pkg.log_and_raise_error('HR_289420_CAGR_INV_MODE'

1703: */
1704:
1705: if not(p_operation_mode in ('SA','SC')) then -- just phase 1 denorm modes
1706: -- if not(p_operation_mode in ('SA','SE','SC','SP','BC','BA','BR')) then
1707: per_cagr_utility_pkg.log_and_raise_error('HR_289420_CAGR_INV_MODE'
1708: ,p_cagr_request_id);
1709: end if;
1710:
1711: if p_operation_mode = 'SA' and p_assignment_id is null then -- SINGLE ASSIGNMENT

Line 1712: per_cagr_utility_pkg.log_and_raise_error('HR_289421_CAGR_INV_SA_PARAM'

1708: ,p_cagr_request_id);
1709: end if;
1710:
1711: if p_operation_mode = 'SA' and p_assignment_id is null then -- SINGLE ASSIGNMENT
1712: per_cagr_utility_pkg.log_and_raise_error('HR_289421_CAGR_INV_SA_PARAM'
1713: ,p_cagr_request_id);
1714: end if;
1715:
1716: if p_operation_mode = 'SC'

Line 1720: per_cagr_utility_pkg.log_and_raise_error('HR_289597_INV_SC_PARAM'

1716: if p_operation_mode = 'SC'
1717: and (p_collective_agreement_id is null
1718: or p_assignment_id is not null
1719: or p_collective_agreement_set_id is not null) then -- SINGLE CAGR
1720: per_cagr_utility_pkg.log_and_raise_error('HR_289597_INV_SC_PARAM'
1721: ,p_cagr_request_id);
1722: end if;
1723:
1724: --

Line 1741: per_cagr_utility_pkg.put_log(' ',1);

1737: l_params.entitlement_item_id := p_entitlement_item_id;
1738: l_params.commit_flag := p_commit_flag;
1739: l_params.denormalise_flag := 'Y';
1740:
1741: per_cagr_utility_pkg.put_log(' ',1);
1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);

Line 1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);

1738: l_params.commit_flag := p_commit_flag;
1739: l_params.denormalise_flag := 'Y';
1740:
1741: per_cagr_utility_pkg.put_log(' ',1);
1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);

Line 1743: per_cagr_utility_pkg.put_log(' ',1);

1739: l_params.denormalise_flag := 'Y';
1740:
1741: per_cagr_utility_pkg.put_log(' ',1);
1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);

Line 1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);

1740:
1741: per_cagr_utility_pkg.put_log(' ',1);
1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);

Line 1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);

1741: per_cagr_utility_pkg.put_log(' ',1);
1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);

Line 1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);

1742: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);

Line 1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);

1743: per_cagr_utility_pkg.put_log(' ',1);
1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);

Line 1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);

1744: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);

Line 1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);

1745: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);

Line 1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);

1746: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);

Line 1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);

1747: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1755:

Line 1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);

1748: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1755:
1756: /* redundant now chosen values are stored after refresh

Line 1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);

1749: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1755:
1756: /* redundant now chosen values are stored after refresh
1757: If p_select_flag = 'B' then

Line 1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);

1750: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1751: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1752: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1753: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1755:
1756: /* redundant now chosen values are stored after refresh
1757: If p_select_flag = 'B' then
1758: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);

Line 1758: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);

1754: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1755:
1756: /* redundant now chosen values are stored after refresh
1757: If p_select_flag = 'B' then
1758: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1759: elsif p_select_flag = 'C' then
1760: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1761: end if;
1762: */

Line 1760: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);

1756: /* redundant now chosen values are stored after refresh
1757: If p_select_flag = 'B' then
1758: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1759: elsif p_select_flag = 'C' then
1760: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1761: end if;
1762: */
1763:
1764: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);

Line 1764: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);

1760: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1761: end if;
1762: */
1763:
1764: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);
1765: per_cagr_utility_pkg.put_log(' ',1);
1766:
1767: --
1768: -- ****** This needs to be converted to a parameter passed to create_request,

Line 1765: per_cagr_utility_pkg.put_log(' ',1);

1761: end if;
1762: */
1763:
1764: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);
1765: per_cagr_utility_pkg.put_log(' ',1);
1766:
1767: --
1768: -- ****** This needs to be converted to a parameter passed to create_request,
1769: -- rather than relying on a public package variable *******

Line 1772: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');

1768: -- ****** This needs to be converted to a parameter passed to create_request,
1769: -- rather than relying on a public package variable *******
1770: --
1771: if fnd_global.conc_request_id <> -1 then
1772: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1773: else
1774: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1775: end if;
1776: per_cagr_utility_pkg.put_log(' ',1);

Line 1774: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');

1770: --
1771: if fnd_global.conc_request_id <> -1 then
1772: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1773: else
1774: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1775: end if;
1776: per_cagr_utility_pkg.put_log(' ',1);
1777: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1778:

Line 1776: per_cagr_utility_pkg.put_log(' ',1);

1772: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1773: else
1774: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1775: end if;
1776: per_cagr_utility_pkg.put_log(' ',1);
1777: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1778:
1779: --
1780: -- invoke denormalization processing;

Line 1777: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);

1773: else
1774: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1775: end if;
1776: per_cagr_utility_pkg.put_log(' ',1);
1777: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1778:
1779: --
1780: -- invoke denormalization processing;
1781: --

Line 1786: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);

1782: initialise (p_params => l_params
1783: ,p_select_flag => p_select_flag);
1784:
1785: -- complete logging
1786: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1787: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1788:
1789: hr_utility.set_location('Leaving:'||l_proc, 50);
1790:

Line 1787: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);

1783: ,p_select_flag => p_select_flag);
1784:
1785: -- complete logging
1786: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1787: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1788:
1789: hr_utility.set_location('Leaving:'||l_proc, 50);
1790:
1791: END;