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 361: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);

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

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

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

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

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

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

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

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

394: ,p_effective_date => p_params.effective_date
395: ,p_mode => l_dt_mode
396: ,p_ovn => l_ovn);
397:
398: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG in mode: '||l_dt_mode||' , OVN: '||l_ovn,1);
399: BEGIN
400:
401: hr_assignment_api.update_emp_asg
402: (p_effective_date => p_params.effective_date

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

487: ,p_other_manager_warning => l_other_manager_warning);
488:
489: -- log any warnings
490: if l_no_managers_warning then
491: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
492: elsif l_other_manager_warning then
493: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
494: end if;
495: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);

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

489: -- log any warnings
490: if l_no_managers_warning then
491: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
492: elsif l_other_manager_warning then
493: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
494: end if;
495: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
496: EXCEPTION
497: when others then -- log unexpected API error, and continue

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

491: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
492: elsif l_other_manager_warning then
493: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
494: end if;
495: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
496: EXCEPTION
497: when others then -- log unexpected API error, and continue
498: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
499: --

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

494: end if;
495: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG, OVN: '||l_ovn,1);
496: EXCEPTION
497: when others then -- log unexpected API error, and continue
498: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
499: --
500: -- To show the Dictionary message in the log file
501: --
502: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

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

498: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
499: --
500: -- To show the Dictionary message in the log file
501: --
502: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
503: --
504: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
505: END;
506:

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

500: -- To show the Dictionary message in the log file
501: --
502: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
503: --
504: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
505: END;
506:
507: elsif l_api_details(1).api_name = 'HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA' then
508:

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

513: ,p_effective_date => p_params.effective_date
514: ,p_mode => l_dt_mode
515: ,p_ovn => l_ovn);
516:
517: per_cagr_utility_pkg.put_log(' calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA in mode: '||l_dt_mode||', OVN: '||l_ovn,1);
518: BEGIN
519: hr_assignment_api.update_emp_asg_criteria
520: (p_effective_date => p_params.effective_date
521: ,p_datetrack_update_mode => l_dt_mode

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

539: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
540:
541: -- log any warnings
542: if l_no_managers_warning then
543: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
544: elsif l_other_manager_warning then
545: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
546: elsif l_spp_delete_warning then
547: l_warn_message := fnd_message.get_string(

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

541: -- log any warnings
542: if l_no_managers_warning then
543: per_cagr_utility_pkg.put_log(' WARNING: p_no_managers_warning',1);
544: elsif l_other_manager_warning then
545: per_cagr_utility_pkg.put_log(' WARNING: p_other_manager_warning',1);
546: elsif l_spp_delete_warning then
547: l_warn_message := fnd_message.get_string(
548: APPIN => 'PER'
549: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');

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

546: elsif l_spp_delete_warning then
547: l_warn_message := fnd_message.get_string(
548: APPIN => 'PER'
549: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');
550: per_cagr_utility_pkg.put_log(' WARNING: '||l_warn_message,1);
551: end if;
552: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
553: EXCEPTION
554: when others then -- log unexpected API error, and continue

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

548: APPIN => 'PER'
549: , NAMEIN => 'HR_289826_SPP_DELETE_WARN_API');
550: per_cagr_utility_pkg.put_log(' WARNING: '||l_warn_message,1);
551: end if;
552: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
553: EXCEPTION
554: when others then -- log unexpected API error, and continue
555: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
556: --

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

551: end if;
552: per_cagr_utility_pkg.put_log(' done HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA, OVN: '||l_ovn,1);
553: EXCEPTION
554: when others then -- log unexpected API error, and continue
555: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
556: --
557: -- To show the Dictionary message in the log file
558: --
559: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);

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

555: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
556: --
557: -- To show the Dictionary message in the log file
558: --
559: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
560: --
561: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
562: END;
563:

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

557: -- To show the Dictionary message in the log file
558: --
559: per_cagr_utility_pkg.put_log(' Dictionary Message: '||fnd_message.get,1);
560: --
561: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
562: END;
563:
564: end if;
565: end if;

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

653: for v_api_details in csr_api('HR_SP_PLACEMENT_API.UPDATE_SPP') loop
654: l_count := l_count+1;
655: l_api_details(l_count) := v_api_details;
656: end loop;
657: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);
658:
659: -- loop thru each ent result and create mapping record(s)
660: for i in p_PYS_results.first..p_PYS_results.last loop
661: l_map_count := l_map_count+1;

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

666: -- the cagr_api_param_id does not necessarily match between results reference update api
667: -- but we have identified that we actually need to use create, so use parameter name instead...
668: if l_api_details(j).cagr_api_param_id = p_PYS_results(i).cagr_api_param_id then
669: l_mapping_table(l_map_count).parameter_name := l_api_details(j).parameter_name;
670: per_cagr_utility_pkg.put_log(' created mapping record: '||
671: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
672: -- also create a mapping table record, if there is a uom col
673: if l_api_details(j).uom_parameter is not null then
674: l_map_count := l_map_count+1;

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

673: if l_api_details(j).uom_parameter is not null then
674: l_map_count := l_map_count+1;
675: l_mapping_table(l_map_count).parameter_name := l_api_details(j).uom_parameter;
676: l_mapping_table(l_map_count).value := p_PYS_results(i).units_of_measure;
677: per_cagr_utility_pkg.put_log(' created mapping record: '||
678: l_mapping_table(l_map_count).parameter_name||'='||l_mapping_table(l_map_count).value);
679: end if;
680: exit;
681: end if;

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

681: end if;
682: end loop;
683: end loop;
684:
685: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
686:
687: if l_map_count > 0 then
688: BEGIN
689: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then

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

687: if l_map_count > 0 then
688: BEGIN
689: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
690:
691: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
692: l_step_id := get_num_val('STEP_ID',l_mapping_table);
693: if l_step_id is null then
694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

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

691: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
692: l_step_id := get_num_val('STEP_ID',l_mapping_table);
693: if l_step_id is null then
694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);

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

693: if l_step_id is null then
694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
700: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
701: hr_sp_placement_api.create_spp

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

694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
700: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
701: hr_sp_placement_api.create_spp
702: (p_effective_date => p_params.effective_date

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

695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
700: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
701: hr_sp_placement_api.create_spp
702: (p_effective_date => p_params.effective_date
703: ,p_business_group_id => p_params.business_group_id

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

696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
700: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
701: hr_sp_placement_api.create_spp
702: (p_effective_date => p_params.effective_date
703: ,p_business_group_id => p_params.business_group_id
704: ,p_assignment_id => p_params.assignment_id -- current assignment

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

706: ,p_object_version_number => l_ovn
707: ,p_placement_id => l_placement_id
708: ,p_effective_start_date => l_effective_start_date
709: ,p_effective_end_date => l_effective_end_date);
710: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;

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

707: ,p_placement_id => l_placement_id
708: ,p_effective_start_date => l_effective_start_date
709: ,p_effective_end_date => l_effective_end_date);
710: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then

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

708: ,p_effective_start_date => l_effective_start_date
709: ,p_effective_end_date => l_effective_end_date);
710: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:

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

709: ,p_effective_end_date => l_effective_end_date);
710: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:
717: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);

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

713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:
717: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
718: hr_sp_placement_api.update_spp
719: (p_effective_date => p_params.effective_date
720: ,p_datetrack_mode => l_dt_mode
721: ,p_placement_id => l_placement_id

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

723: ,p_object_version_number => l_ovn
724: ,p_effective_start_date => l_effective_start_date
725: ,p_effective_end_date => l_effective_end_date);
726:
727: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
728: end if;
729: EXCEPTION
730: when others then -- log unexpected API error, and continue
731: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);

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

727: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
728: end if;
729: EXCEPTION
730: when others then -- log unexpected API error, and continue
731: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
732: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
733: END;
734:
735: end if;

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

728: end if;
729: EXCEPTION
730: when others then -- log unexpected API error, and continue
731: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
732: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
733: END;
734:
735: end if;
736:

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

900: fetch csr_entries into v_entries;
901: exit when csr_entries%notfound;
902: if v_entries.entry_type = 'S' then
903: -- store the override entry id
904: per_cagr_utility_pkg.put_log('Override entry exists - only this will be updated: '||v_entries.element_entry_id);
905: l_entry_id := v_entries.element_entry_id;
906: end if;
907: end loop;
908: else

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

923:
924: if l_too_many_entries = 'Y' and p_PAY_results(i).multiple_entries_allowed_flag = 'N'
925: and l_entry_id is null then
926: -- not an override GB element entry so show message
927: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
928: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
929: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
930: ||'effective_date and updating multiple entries is not allowed.',1);
931: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);

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

924: if l_too_many_entries = 'Y' and p_PAY_results(i).multiple_entries_allowed_flag = 'N'
925: and l_entry_id is null then
926: -- not an override GB element entry so show message
927: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
928: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
929: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
930: ||'effective_date and updating multiple entries is not allowed.',1);
931: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
932: else

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

925: and l_entry_id is null then
926: -- not an override GB element entry so show message
927: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
928: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
929: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
930: ||'effective_date and updating multiple entries is not allowed.',1);
931: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
932: else
933: -- build the mapping table for the results

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

927: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
928: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
929: per_cagr_utility_pkg.put_log(' Error: More than 1 entry found for payroll item on the '
930: ||'effective_date and updating multiple entries is not allowed.',1);
931: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
932: else
933: -- build the mapping table for the results
934: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
935: l_map_count := l_map_count+1;

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

930: ||'effective_date and updating multiple entries is not allowed.',1);
931: per_cagr_utility_pkg.put_log(' Item value will not be applied to element_entry records.',1);
932: else
933: -- build the mapping table for the results
934: per_cagr_utility_pkg.put_log(' iv: '||p_PAY_results(i).input_value_id);
935: l_map_count := l_map_count+1;
936: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
937: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
938: l_map_count := l_map_count+1;

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

937: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
938: l_map_count := l_map_count+1;
939: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
940: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
941: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value);
942: end if;
943:
944: end loop;
945:

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

942: end if;
943:
944: end loop;
945:
946: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
947:
948: if l_mapping_table.count > 0 then
949:
950: -- get all entry recs for the element type on the effective_date

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

968:
969: -- if the element entry is non recurring then api should be called in CORRECTION mode only.
970: -- check here, or modify get_ovn_and_mode
971:
972: per_cagr_utility_pkg.put_log(' calling PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
973: BEGIN
974: py_element_entry_api.update_element_entry(
975: p_datetrack_update_mode => l_dt_mode,
976: p_effective_date => p_params.effective_date,

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

1012: p_update_warning => l_warning);
1013:
1014: -- log any warnings
1015: if l_warning then
1016: per_cagr_utility_pkg.put_log(' WARNING: p_update_warning',1);
1017: end if;
1018: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1019: EXCEPTION
1020: when others then -- log unexpected API error, and continue

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

1014: -- log any warnings
1015: if l_warning then
1016: per_cagr_utility_pkg.put_log(' WARNING: p_update_warning',1);
1017: end if;
1018: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1019: EXCEPTION
1020: when others then -- log unexpected API error, and continue
1021: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1022: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

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

1017: end if;
1018: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1019: EXCEPTION
1020: when others then -- log unexpected API error, and continue
1021: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1022: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1023: END;
1024: end loop;
1025: if csr_entries%rowcount = 0 then

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

1018: per_cagr_utility_pkg.put_log(' done PY_ELEMENT_ENTRY_API.UPDATE_ELEMENT_ENTRY in mode: '||l_dt_mode,1);
1019: EXCEPTION
1020: when others then -- log unexpected API error, and continue
1021: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1022: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1023: END;
1024: end loop;
1025: if csr_entries%rowcount = 0 then
1026: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||

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

1022: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1023: END;
1024: end loop;
1025: if csr_entries%rowcount = 0 then
1026: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||
1027: p_pay_results(1).element_type_id||' on assignment '||
1028: p_pay_results(1).assignment_id,1);
1029: end if;
1030: close csr_entries;

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

1041:
1042: l_map_count := 0;
1043: l_warning := FALSE;
1044:
1045: per_cagr_utility_pkg.put_log('New EE Entries ',5);
1046: -- build and populate mapping table with iv_ids and entry values
1047: -- from the table of entitlement result records
1048: for i in p_PAY_results.first..p_PAY_results.last loop
1049:

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

1048: for i in p_PAY_results.first..p_PAY_results.last loop
1049:
1050: -- build the mapping table for the results
1051: l_map_count := l_map_count+1;
1052: per_cagr_utility_pkg.put_log('map count = '||l_map_count,5);
1053: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1054: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1055: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1056: l_map_count := l_map_count+1;

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

1050: -- build the mapping table for the results
1051: l_map_count := l_map_count+1;
1052: per_cagr_utility_pkg.put_log('map count = '||l_map_count,5);
1053: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1054: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1055: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1056: l_map_count := l_map_count+1;
1057: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1058: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;

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

1053: l_mapping_table(l_map_count).parameter_name := 'INPUT_VALUE_ID'||i;
1054: per_cagr_utility_pkg.put_log('input_value_id : '||p_PAY_results(i).input_value_id,5);
1055: l_mapping_table(l_map_count).value := p_PAY_results(i).input_value_id;
1056: l_map_count := l_map_count+1;
1057: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1058: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
1059: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
1060: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1061:

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

1056: l_map_count := l_map_count+1;
1057: per_cagr_utility_pkg.put_log('entry_value : '||p_PAY_results(i).value,5);
1058: l_mapping_table(l_map_count).parameter_name := 'ENTRY_VALUE'||i;
1059: l_mapping_table(l_map_count).value := p_PAY_results(i).value;
1060: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1061:
1062: end loop;
1063:
1064: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count,5);

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

1060: per_cagr_utility_pkg.put_log(' ev: '||p_PAY_results(i).value,5);
1061:
1062: end loop;
1063:
1064: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count,5);
1065:
1066: if l_mapping_table.count > 0 then
1067:
1068: -- get all entry recs for the assignment on the effective_date

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

1085: (p_assignment_id => p_params.assignment_id,
1086: p_element_type_id => v_entries_not_exists.element_type_id,
1087: p_session_date => p_params.effective_date);
1088:
1089: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1090: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1091: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1092: pay_element_entry_api.create_element_entry(
1093: p_validate => FALSE,

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

1086: p_element_type_id => v_entries_not_exists.element_type_id,
1087: p_session_date => p_params.effective_date);
1088:
1089: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1090: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1091: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1092: pay_element_entry_api.create_element_entry(
1093: p_validate => FALSE,
1094: p_effective_date => p_params.effective_date,

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

1087: p_session_date => p_params.effective_date);
1088:
1089: per_cagr_utility_pkg.put_log(' Assignment ID = '||p_params.assignment_id);
1090: per_cagr_utility_pkg.put_log(' Element TypeID = '||v_entries_not_exists.element_type_id);
1091: per_cagr_utility_pkg.put_log(' Element LinkID = '||l_element_link_id);
1092: pay_element_entry_api.create_element_entry(
1093: p_validate => FALSE,
1094: p_effective_date => p_params.effective_date,
1095: p_business_group_id => p_params.business_group_id,

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

1130: p_effective_end_date => l_effective_end_date,
1131: p_element_entry_id => l_element_entry_id,
1132: p_object_version_number => l_ovn,
1133: p_create_warning => l_warning);
1134: per_cagr_utility_pkg.put_log(' End of create element entry.');
1135: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1136:
1137: -- log any warnings
1138: if l_warning then

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

1131: p_element_entry_id => l_element_entry_id,
1132: p_object_version_number => l_ovn,
1133: p_create_warning => l_warning);
1134: per_cagr_utility_pkg.put_log(' End of create element entry.');
1135: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1136:
1137: -- log any warnings
1138: if l_warning then
1139: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);

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

1135: per_cagr_utility_pkg.put_log(' Element EntryID = '||l_element_entry_id);
1136:
1137: -- log any warnings
1138: if l_warning then
1139: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);
1140: end if;
1141: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1142: EXCEPTION
1143: when others then -- log unexpected API error, and continue

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

1137: -- log any warnings
1138: if l_warning then
1139: per_cagr_utility_pkg.put_log(' WARNING: p_create_warning',1);
1140: end if;
1141: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1142: EXCEPTION
1143: when others then -- log unexpected API error, and continue
1144: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1145: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);

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

1140: end if;
1141: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1142: EXCEPTION
1143: when others then -- log unexpected API error, and continue
1144: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1145: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1146: END;
1147:
1148: else

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

1141: per_cagr_utility_pkg.put_log(' Done PAY_ELEMENT_ENTRY_API.CREATE_ELEMENT_ENTRY '||l_element_entry_id,1);
1142: EXCEPTION
1143: when others then -- log unexpected API error, and continue
1144: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);
1145: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1146: END;
1147:
1148: else
1149:

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

1148: else
1149:
1150: close csr_entitlement_items;
1151:
1152: per_cagr_utility_pkg.put_log(' WARNING: Auto Entry flag for Entitlement Item is not checked');
1153:
1154: end if;
1155:
1156: end loop;

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

1154: end if;
1155:
1156: end loop;
1157: if csr_entries_not_exists%rowcount = 0 then
1158: per_cagr_utility_pkg.put_log(' Warning: 0 element entries found for element_type_id '||
1159: p_pay_results(1).element_type_id||' on assignment '||
1160: p_pay_results(1).assignment_id,1);
1161: end if;
1162: close csr_entries_not_exists;

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

1312:
1313: hr_utility.set_location('Entering:'||l_proc, 5);
1314:
1315: if p_params.category is null or p_params.category = 'ASG' then
1316: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1317:
1318: -- open cursor for ASG results for denormalisation, and collect pl/sql table
1319: for v_ASG_results in csr_ASG_denorm_results loop
1320: per_cagr_utility_pkg.put_log(' found result record for item: '||v_ASG_results.cagr_entitlement_item_id);

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

1316: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1317:
1318: -- open cursor for ASG results for denormalisation, and collect pl/sql table
1319: for v_ASG_results in csr_ASG_denorm_results loop
1320: per_cagr_utility_pkg.put_log(' found result record for item: '||v_ASG_results.cagr_entitlement_item_id);
1321:
1322: if (l_old_cagr_api_id <> 0 and l_old_cagr_api_id <> v_ASG_results.cagr_api_id) then
1323: -- the cagr_api_id has changed so call_the relevant API to denormalise
1324: call_ASG_api(p_params,l_ASG_results);

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

1339:
1340: -- bug 2289200 reset variable to 0;
1341: l_old_cagr_api_id := 0;
1342:
1343: per_cagr_utility_pkg.put_log(' Completed ASSIGNMENT category items.',1);
1344: per_cagr_utility_pkg.put_log(' ');
1345: end if;
1346:
1347: if p_params.category is null or p_params.category = 'PYS' then

Line 1344: per_cagr_utility_pkg.put_log(' ');

1340: -- bug 2289200 reset variable to 0;
1341: l_old_cagr_api_id := 0;
1342:
1343: per_cagr_utility_pkg.put_log(' Completed ASSIGNMENT category items.',1);
1344: per_cagr_utility_pkg.put_log(' ');
1345: end if;
1346:
1347: if p_params.category is null or p_params.category = 'PYS' then
1348: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);

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

1344: per_cagr_utility_pkg.put_log(' ');
1345: end if;
1346:
1347: if p_params.category is null or p_params.category = 'PYS' then
1348: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);
1349:
1350: for v_PYS_results in csr_PYS_denorm_results loop
1351: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PYS_results.cagr_entitlement_item_id);
1352:

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

1347: if p_params.category is null or p_params.category = 'PYS' then
1348: per_cagr_utility_pkg.put_log(' Starting PAY SCALE category items...',1);
1349:
1350: for v_PYS_results in csr_PYS_denorm_results loop
1351: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PYS_results.cagr_entitlement_item_id);
1352:
1353: if (l_old_cagr_api_id <> 0 and l_old_cagr_api_id <> v_PYS_results.cagr_api_id) then
1354: -- the cagr_api_id has changed so call_the relevant API to denormalise
1355: call_PYS_api(p_params,l_PYS_results);

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

1370:
1371: -- bug 2289200 reset variable to 0;
1372: l_old_cagr_api_id := 0;
1373:
1374: per_cagr_utility_pkg.put_log(' Completed PAY SCALE category items.',1);
1375: per_cagr_utility_pkg.put_log(' ');
1376: end if;
1377:
1378: if p_params.category is null or p_params.category = 'PAY' then

Line 1375: per_cagr_utility_pkg.put_log(' ');

1371: -- bug 2289200 reset variable to 0;
1372: l_old_cagr_api_id := 0;
1373:
1374: per_cagr_utility_pkg.put_log(' Completed PAY SCALE category items.',1);
1375: per_cagr_utility_pkg.put_log(' ');
1376: end if;
1377:
1378: if p_params.category is null or p_params.category = 'PAY' then
1379: per_cagr_utility_pkg.put_log(' Starting PAYROLL category items...',1);

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

1375: per_cagr_utility_pkg.put_log(' ');
1376: end if;
1377:
1378: if p_params.category is null or p_params.category = 'PAY' then
1379: per_cagr_utility_pkg.put_log(' Starting PAYROLL category items...',1);
1380:
1381: -- loop through all element results, populating pl/sql table with values
1382: -- and calling denormalise routine for each element type in the cursor.
1383: for v_PAY_results in csr_PAY_denorm_results loop

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

1380:
1381: -- loop through all element results, populating pl/sql table with values
1382: -- and calling denormalise routine for each element type in the cursor.
1383: for v_PAY_results in csr_PAY_denorm_results loop
1384: per_cagr_utility_pkg.put_log(' found result record for item: '||v_PAY_results.cagr_entitlement_item_id);
1385:
1386: if (l_old_element_type_id <> 0 and l_old_element_type_id <> v_PAY_results.element_type_id) then
1387: -- the element_type has changed so call element entry API to denormalise
1388: -- entry values for the element_type

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

1387: -- the element_type has changed so call element entry API to denormalise
1388: -- entry values for the element_type
1389: if l_PAY_results.count > 15 then
1390: -- error as too many results for the update api call for the element
1391: per_cagr_utility_pkg.put_log(' ERROR: > 15 results for this element_type means data lost, skipping element');
1392: else
1393: call_PAY_api(p_params,l_PAY_results);
1394: l_PAY_results.delete;
1395: l_table_counter := 0;

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

1409:
1410: -- bug 2289200 reset variable to 0;
1411: l_old_cagr_api_id := 0;
1412:
1413: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1414: per_cagr_utility_pkg.put_log(' ');
1415: end if;
1416:
1417: hr_utility.set_location('Leaving:'||l_proc, 100);

Line 1414: per_cagr_utility_pkg.put_log(' ');

1410: -- bug 2289200 reset variable to 0;
1411: l_old_cagr_api_id := 0;
1412:
1413: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1414: per_cagr_utility_pkg.put_log(' ');
1415: end if;
1416:
1417: hr_utility.set_location('Leaving:'||l_proc, 100);
1418:

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

1419:
1420: EXCEPTION
1421: when others then
1422: -- write the log contents
1423: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1424: raise;
1425:
1426: END do_apply_for_assignment;
1427:

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

1433:
1434: hr_utility.set_location('Entering:'||l_proc, 5);
1435: --
1436: if not(g_done_header) then
1437: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1438: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1439: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1440: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1441: ||fnd_date.date_to_canonical(sysdate)||')',1);

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

1434: hr_utility.set_location('Entering:'||l_proc, 5);
1435: --
1436: if not(g_done_header) then
1437: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1438: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1439: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1440: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1441: ||fnd_date.date_to_canonical(sysdate)||')',1);
1442:

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

1435: --
1436: if not(g_done_header) then
1437: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1438: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1439: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1440: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1441: ||fnd_date.date_to_canonical(sysdate)||')',1);
1442:
1443: If p_params.operation_mode = 'SA' then

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

1436: if not(g_done_header) then
1437: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1438: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1439: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1440: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1441: ||fnd_date.date_to_canonical(sysdate)||')',1);
1442:
1443: If p_params.operation_mode = 'SA' then
1444: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);

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

1440: per_cagr_utility_pkg.put_log('Starting Result Population Process: ('
1441: ||fnd_date.date_to_canonical(sysdate)||')',1);
1442:
1443: If p_params.operation_mode = 'SA' then
1444: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);
1445: elsif p_params.operation_mode = 'SC' then
1446: per_cagr_utility_pkg.put_log(' Mode: Single Collective Agreement',1);
1447: end if;
1448:

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

1442:
1443: If p_params.operation_mode = 'SA' then
1444: per_cagr_utility_pkg.put_log(' Mode: Single Assignment',1);
1445: elsif p_params.operation_mode = 'SC' then
1446: per_cagr_utility_pkg.put_log(' Mode: Single Collective Agreement',1);
1447: end if;
1448:
1449: /* redundant
1450: If p_select_flag = 'B' then

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

1447: end if;
1448:
1449: /* redundant
1450: If p_select_flag = 'B' then
1451: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1452: elsif p_select_flag = 'C' then
1453: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1454: end if;
1455: */

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

1449: /* redundant
1450: If p_select_flag = 'B' then
1451: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1452: elsif p_select_flag = 'C' then
1453: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1454: end if;
1455: */
1456: end if;
1457: g_done_header := FALSE;

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

1458: --
1459: --
1460: if p_params.category is not null then
1461: if p_params.category not in ('ASG','PAY','PYS','ABS') then
1462: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_CATEGORY',p_params.cagr_request_id);
1463: end if;
1464: end if;
1465:
1466:

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

1468: --
1469: -- ********* single assignment *********
1470: --
1471:
1472: per_cagr_utility_pkg.put_log(' ',1);
1473: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1474: ' during Single Assignment Agreement mode.',1);
1475: do_apply_for_assignment(p_params, p_select_flag);
1476:

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

1469: -- ********* single assignment *********
1470: --
1471:
1472: per_cagr_utility_pkg.put_log(' ',1);
1473: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1474: ' during Single Assignment Agreement mode.',1);
1475: do_apply_for_assignment(p_params, p_select_flag);
1476:
1477: --

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

1477: --
1478: -- Commit, if required.
1479: --
1480: if p_params.commit_flag = 'Y' then
1481: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1482: commit;
1483: elsif p_params.commit_flag = 'N' then
1484: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1485: rollback;

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

1480: if p_params.commit_flag = 'Y' then
1481: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1482: commit;
1483: elsif p_params.commit_flag = 'N' then
1484: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1485: rollback;
1486: end if;
1487:
1488: elsif p_params.operation_mode = 'SC' then

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

1501: -- when the results were evaluated, and are visible from PERWSCAR), but a
1502: -- file of combined parent request and asg denorm log entries is also
1503: -- created when we are running under CM.
1504: --
1505: per_cagr_utility_pkg.put_log(' Identified the following assignments on the collective agreement:',1);
1506: --
1507: -- first load all the assignment ids to be processed into pl/sql table.
1508: --
1509: open csr_assignments_to_process;

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

1510: loop
1511: l_counter := l_counter+1;
1512: fetch csr_assignments_to_process into t_assignment_list(l_counter);
1513: exit when csr_assignments_to_process%notfound;
1514: per_cagr_utility_pkg.put_log(' '||t_assignment_list(l_counter).assignment_id,1);
1515: end loop;
1516: close csr_assignments_to_process;
1517:
1518:

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

1516: close csr_assignments_to_process;
1517:
1518:
1519: -- write the log out and save the request_id
1520: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1521: l_parent_request_id := p_params.cagr_request_id;
1522:
1523: -- could now break pl/sql table into varray subsets, ready for multiple threads
1524:

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

1530: p_params.assignment_id := t_assignment_list(k).assignment_id;
1531: p_params.cagr_request_id := get_request_id(t_assignment_list(k).assignment_id
1532: ,p_params.effective_date);
1533:
1534: per_cagr_utility_pkg.put_log(' ',1);
1535: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1536: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1537: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1538:

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

1531: p_params.cagr_request_id := get_request_id(t_assignment_list(k).assignment_id
1532: ,p_params.effective_date);
1533:
1534: per_cagr_utility_pkg.put_log(' ',1);
1535: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1536: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1537: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1538:
1539: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||

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

1532: ,p_params.effective_date);
1533:
1534: per_cagr_utility_pkg.put_log(' ',1);
1535: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1536: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1537: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1538:
1539: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1540: ' during Single Collective Agreement mode.',1);

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

1533:
1534: per_cagr_utility_pkg.put_log(' ',1);
1535: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1536: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1537: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1538:
1539: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1540: ' during Single Collective Agreement mode.',1);
1541:

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

1535: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1536: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1537: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1538:
1539: per_cagr_utility_pkg.put_log(' Processing Assignment ID '|| p_params.assignment_id ||
1540: ' during Single Collective Agreement mode.',1);
1541:
1542:
1543: if p_params.cagr_request_id is null then

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

1550: --
1551: -- Commit, if required.
1552: --
1553: if p_params.commit_flag = 'Y' then
1554: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1555: commit;
1556: elsif p_params.commit_flag = 'N' then
1557: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1558: rollback;

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

1553: if p_params.commit_flag = 'Y' then
1554: per_cagr_utility_pkg.put_log(' Any changes have been saved.',1);
1555: commit;
1556: elsif p_params.commit_flag = 'N' then
1557: per_cagr_utility_pkg.put_log(' Any changes have been discarded.',1);
1558: rollback;
1559: end if;
1560:
1561: -- complete the logging for this asg

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

1558: rollback;
1559: end if;
1560:
1561: -- complete the logging for this asg
1562: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1563:
1564: Exception
1565: when others then
1566: -- complete the logging for this asg

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

1563:
1564: Exception
1565: when others then
1566: -- complete the logging for this asg
1567: per_cagr_utility_pkg.put_log('ERROR: '||sqlerrm);
1568: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1569: End;
1570: END LOOP;
1571:

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

1564: Exception
1565: when others then
1566: -- complete the logging for this asg
1567: per_cagr_utility_pkg.put_log('ERROR: '||sqlerrm);
1568: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1569: End;
1570: END LOOP;
1571:
1572: -- restore the original request id, now all asgs have completed

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

1575: else
1576: null; -- do processing for other modes...
1577: end if;
1578:
1579: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1580: ||fnd_date.date_to_canonical(sysdate)||')',1);
1581: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1582: hr_utility.set_location('Leaving:'||l_proc, 100);
1583:

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

1577: end if;
1578:
1579: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1580: ||fnd_date.date_to_canonical(sysdate)||')',1);
1581: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1582: hr_utility.set_location('Leaving:'||l_proc, 100);
1583:
1584:
1585: EXCEPTION

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

1584:
1585: EXCEPTION
1586: when others then
1587: -- write the log contents
1588: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1589: raise;
1590: END initialise;
1591:
1592: --

Line 1644: per_cagr_utility_pkg.create_cagr_request(p_process_date => p_process_date

1640: -- (if called from PERWSCAR.fmb or evaluation process we use the request_id
1641: -- that gave rise to the results which we are about to denormalise, so evaluation log records
1642: -- are appended with entitlement population process entries)
1643: --
1644: per_cagr_utility_pkg.create_cagr_request(p_process_date => p_process_date
1645: ,p_operation_mode => p_operation_mode
1646: ,p_business_group_id => p_business_group_id
1647: ,p_assignment_id => p_assignment_id
1648: ,p_assignment_set_id => p_assignment_set_id

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

1670:
1671: --
1672: -- Output denormalization log header
1673: --
1674: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1675: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1676: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1677: g_done_header := TRUE;
1678:

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

1671: --
1672: -- Output denormalization log header
1673: --
1674: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1675: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1676: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1677: g_done_header := TRUE;
1678:
1679: --

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

1672: -- Output denormalization log header
1673: --
1674: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1675: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);
1676: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1677: g_done_header := TRUE;
1678:
1679: --
1680: -- validate parameters

Line 1683: per_cagr_utility_pkg.log_and_raise_error('HR_289419_CAGR_INV_CFLAG'

1679: --
1680: -- validate parameters
1681: --
1682: if not (p_commit_flag in ('N','Y')) then
1683: per_cagr_utility_pkg.log_and_raise_error('HR_289419_CAGR_INV_CFLAG'
1684: ,p_cagr_request_id);
1685: end if;
1686:
1687: /* select_flag is redundant

Line 1689: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_SFLAG'

1685: end if;
1686:
1687: /* select_flag is redundant
1688: if not (p_select_flag in ('B','C')) then
1689: per_cagr_utility_pkg.log_and_raise_error('HR_XXXXX_CAGR_INV_SFLAG'
1690: ,p_cagr_request_id);
1691: end if;
1692: */
1693:

Line 1696: per_cagr_utility_pkg.log_and_raise_error('HR_289420_CAGR_INV_MODE'

1692: */
1693:
1694: if not(p_operation_mode in ('SA','SC')) then -- just phase 1 denorm modes
1695: -- if not(p_operation_mode in ('SA','SE','SC','SP','BC','BA','BR')) then
1696: per_cagr_utility_pkg.log_and_raise_error('HR_289420_CAGR_INV_MODE'
1697: ,p_cagr_request_id);
1698: end if;
1699:
1700: if p_operation_mode = 'SA' and p_assignment_id is null then -- SINGLE ASSIGNMENT

Line 1701: per_cagr_utility_pkg.log_and_raise_error('HR_289421_CAGR_INV_SA_PARAM'

1697: ,p_cagr_request_id);
1698: end if;
1699:
1700: if p_operation_mode = 'SA' and p_assignment_id is null then -- SINGLE ASSIGNMENT
1701: per_cagr_utility_pkg.log_and_raise_error('HR_289421_CAGR_INV_SA_PARAM'
1702: ,p_cagr_request_id);
1703: end if;
1704:
1705: if p_operation_mode = 'SC'

Line 1709: per_cagr_utility_pkg.log_and_raise_error('HR_289597_INV_SC_PARAM'

1705: if p_operation_mode = 'SC'
1706: and (p_collective_agreement_id is null
1707: or p_assignment_id is not null
1708: or p_collective_agreement_set_id is not null) then -- SINGLE CAGR
1709: per_cagr_utility_pkg.log_and_raise_error('HR_289597_INV_SC_PARAM'
1710: ,p_cagr_request_id);
1711: end if;
1712:
1713: --

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

1726: l_params.entitlement_item_id := p_entitlement_item_id;
1727: l_params.commit_flag := p_commit_flag;
1728: l_params.denormalise_flag := 'Y';
1729:
1730: per_cagr_utility_pkg.put_log(' ',1);
1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);

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

1727: l_params.commit_flag := p_commit_flag;
1728: l_params.denormalise_flag := 'Y';
1729:
1730: per_cagr_utility_pkg.put_log(' ',1);
1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);

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

1728: l_params.denormalise_flag := 'Y';
1729:
1730: per_cagr_utility_pkg.put_log(' ',1);
1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);

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

1729:
1730: per_cagr_utility_pkg.put_log(' ',1);
1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);

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

1730: per_cagr_utility_pkg.put_log(' ',1);
1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);

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

1731: per_cagr_utility_pkg.put_log(' * Execution Parameter List * ',1);
1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);

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

1732: per_cagr_utility_pkg.put_log(' ',1);
1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);

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

1733: per_cagr_utility_pkg.put_log(' Mode: '||l_params.operation_mode,1);
1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);

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

1734: per_cagr_utility_pkg.put_log(' CAGR Request ID: '||l_params.cagr_request_id,1);
1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);

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

1735: per_cagr_utility_pkg.put_log(' Effective Date: '||l_params.effective_date,1);
1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);

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

1736: per_cagr_utility_pkg.put_log(' Business Group ID: '||l_params.business_group_id,1);
1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1744:

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

1737: per_cagr_utility_pkg.put_log(' Assignment ID: '||l_params.assignment_id,1);
1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1744:
1745: /* redundant now chosen values are stored after refresh

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

1738: per_cagr_utility_pkg.put_log(' Assignment Set ID: '||l_params.assignment_set_id,1);
1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1744:
1745: /* redundant now chosen values are stored after refresh
1746: If p_select_flag = 'B' then

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

1739: per_cagr_utility_pkg.put_log(' Collective Agreement ID: '||l_params.collective_agreement_id,1);
1740: per_cagr_utility_pkg.put_log(' Collective Agreement Set ID: '||l_params.cagr_set_id,1);
1741: per_cagr_utility_pkg.put_log(' Person ID: '||l_params.person_id,1);
1742: per_cagr_utility_pkg.put_log(' Entitlement Item ID: '||l_params.entitlement_item_id,1);
1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1744:
1745: /* redundant now chosen values are stored after refresh
1746: If p_select_flag = 'B' then
1747: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);

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

1743: per_cagr_utility_pkg.put_log(' Category: '||l_params.category,1);
1744:
1745: /* redundant now chosen values are stored after refresh
1746: If p_select_flag = 'B' then
1747: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1748: elsif p_select_flag = 'C' then
1749: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1750: end if;
1751: */

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

1745: /* redundant now chosen values are stored after refresh
1746: If p_select_flag = 'B' then
1747: per_cagr_utility_pkg.put_log(' Beneficial values to be applied.',1);
1748: elsif p_select_flag = 'C' then
1749: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1750: end if;
1751: */
1752:
1753: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);

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

1749: per_cagr_utility_pkg.put_log(' Chosen values to be applied.',1);
1750: end if;
1751: */
1752:
1753: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);
1754: per_cagr_utility_pkg.put_log(' ',1);
1755:
1756: --
1757: -- ****** This needs to be converted to a parameter passed to create_request,

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

1750: end if;
1751: */
1752:
1753: per_cagr_utility_pkg.put_log(' Commit values flag: '||l_params.commit_flag,1);
1754: per_cagr_utility_pkg.put_log(' ',1);
1755:
1756: --
1757: -- ****** This needs to be converted to a parameter passed to create_request,
1758: -- rather than relying on a public package variable *******

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

1757: -- ****** This needs to be converted to a parameter passed to create_request,
1758: -- rather than relying on a public package variable *******
1759: --
1760: if fnd_global.conc_request_id <> -1 then
1761: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1762: else
1763: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1764: end if;
1765: per_cagr_utility_pkg.put_log(' ',1);

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

1759: --
1760: if fnd_global.conc_request_id <> -1 then
1761: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1762: else
1763: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1764: end if;
1765: per_cagr_utility_pkg.put_log(' ',1);
1766: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1767:

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

1761: per_cagr_utility_pkg.put_log(' Executed from concurrent manager');
1762: else
1763: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1764: end if;
1765: per_cagr_utility_pkg.put_log(' ',1);
1766: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1767:
1768: --
1769: -- invoke denormalization processing;

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

1762: else
1763: per_cagr_utility_pkg.put_log(' Executed from SQLPLUS session');
1764: end if;
1765: per_cagr_utility_pkg.put_log(' ',1);
1766: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1767:
1768: --
1769: -- invoke denormalization processing;
1770: --

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

1771: initialise (p_params => l_params
1772: ,p_select_flag => p_select_flag);
1773:
1774: -- complete logging
1775: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1776: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1777:
1778: hr_utility.set_location('Leaving:'||l_proc, 50);
1779:

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

1772: ,p_select_flag => p_select_flag);
1773:
1774: -- complete logging
1775: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1776: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1777:
1778: hr_utility.set_location('Leaving:'||l_proc, 50);
1779:
1780: END;