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

APPS.GHR_POSN_COPY dependencies on HR_UTILITY

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

19: WHERE ori.organization_id = p_business_group_id
20: AND ori.org_information_context = 'GHR_US_ORG_INFORMATION';
21: --
22: BEGIN
23: hr_utility.set_location('Entering get_seq_loation:'|| l_proc, 5);
24:
25: FOR c_ori_rec IN c_ori LOOP
26: RETURN (c_ori_rec.seq_location);
27: END LOOP;

Line 83: hr_utility.set_location('Entering Get Max Seq:'|| l_proc, 5);

79: --
80:
81: BEGIN
82:
83: hr_utility.set_location('Entering Get Max Seq:'|| l_proc, 5);
84:
85: FOR cur_org_id_flex_num_rec IN cur_org_id_flex_num LOOP
86: l_id_flex_num := cur_org_id_flex_num_rec.id_flex_num;
87: END LOOP;

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

434: FOR c_session_date_rec IN c_session_date LOOP
435: l_session_date := (c_session_date_rec.effective_date);
436: END LOOP;
437:
438: hr_utility.set_location('Entering Copy:'|| l_proc, 5);
439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);

Line 439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);

435: l_session_date := (c_session_date_rec.effective_date);
436: END LOOP;
437:
438: hr_utility.set_location('Entering Copy:'|| l_proc, 5);
439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);
443: hr_utility.set_location('Position id '||to_char(p_position_id),10);

Line 440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);

436: END LOOP;
437:
438: hr_utility.set_location('Entering Copy:'|| l_proc, 5);
439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);
443: hr_utility.set_location('Position id '||to_char(p_position_id),10);
444:

Line 441: hr_utility.set_location('Session Date:'|| l_session_date, 8);

437:
438: hr_utility.set_location('Entering Copy:'|| l_proc, 5);
439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);
443: hr_utility.set_location('Position id '||to_char(p_position_id),10);
444:
445: --

Line 442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);

438: hr_utility.set_location('Entering Copy:'|| l_proc, 5);
439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);
443: hr_utility.set_location('Position id '||to_char(p_position_id),10);
444:
445: --
446: l_seq_segment_name := ghr_posn_copy.get_seq_location(p_business_group_id);

Line 443: hr_utility.set_location('Position id '||to_char(p_position_id),10);

439: hr_utility.set_location('Effective Date:'|| p_effective_date, 6);
440: hr_utility.set_location('Date Effective:'|| p_date_effective, 7);
441: hr_utility.set_location('Session Date:'|| l_session_date, 8);
442: hr_utility.set_location('BG ID:'|| p_business_group_id, 9);
443: hr_utility.set_location('Position id '||to_char(p_position_id),10);
444:
445: --
446: l_seq_segment_name := ghr_posn_copy.get_seq_location(p_business_group_id);
447:

Line 480: hr_utility.set_location('l_segment1 :'||l_segment1, 9);

476: l_segment28 := p_segment28;
477: l_segment29 := p_segment29;
478: l_segment30 := p_segment30;
479:
480: hr_utility.set_location('l_segment1 :'||l_segment1, 9);
481: hr_utility.set_location('l_segment2 :'||l_segment2, 9);
482: hr_utility.set_location('l_segment3 :'||l_segment3, 9);
483: hr_utility.set_location('l_segment4 :'||l_segment4, 9);
484:

Line 481: hr_utility.set_location('l_segment2 :'||l_segment2, 9);

477: l_segment29 := p_segment29;
478: l_segment30 := p_segment30;
479:
480: hr_utility.set_location('l_segment1 :'||l_segment1, 9);
481: hr_utility.set_location('l_segment2 :'||l_segment2, 9);
482: hr_utility.set_location('l_segment3 :'||l_segment3, 9);
483: hr_utility.set_location('l_segment4 :'||l_segment4, 9);
484:
485: --

Line 482: hr_utility.set_location('l_segment3 :'||l_segment3, 9);

478: l_segment30 := p_segment30;
479:
480: hr_utility.set_location('l_segment1 :'||l_segment1, 9);
481: hr_utility.set_location('l_segment2 :'||l_segment2, 9);
482: hr_utility.set_location('l_segment3 :'||l_segment3, 9);
483: hr_utility.set_location('l_segment4 :'||l_segment4, 9);
484:
485: --
486: -- Get Agency Specified Max Seq

Line 483: hr_utility.set_location('l_segment4 :'||l_segment4, 9);

479:
480: hr_utility.set_location('l_segment1 :'||l_segment1, 9);
481: hr_utility.set_location('l_segment2 :'||l_segment2, 9);
482: hr_utility.set_location('l_segment3 :'||l_segment3, 9);
483: hr_utility.set_location('l_segment4 :'||l_segment4, 9);
484:
485: --
486: -- Get Agency Specified Max Seq
487: --

Line 488: hr_utility.set_location('Calling Agency Get Max:'|| l_proc, 10);

484:
485: --
486: -- Get Agency Specified Max Seq
487: --
488: hr_utility.set_location('Calling Agency Get Max:'|| l_proc, 10);
489: l_agency_seq := ghr_agency_position_copy.agency_get_max_seq(
490: l_seq_segment_name,
491: p_business_group_id,
492: p_segment1,

Line 523: hr_utility.set_location('Agency Get Max ='|| l_agency_seq, 11);

519: p_segment28,
520: p_segment29,
521: p_segment30);
522:
523: hr_utility.set_location('Agency Get Max ='|| l_agency_seq, 11);
524:
525:
526: -- Agency get should return sequence value to be used for copy.
527: -- This value will not be incremented by 1. So a nextval will work.

Line 529: hr_utility.set_location('Calling GHR get max seq:'|| l_proc, 12);

525:
526: -- Agency get should return sequence value to be used for copy.
527: -- This value will not be incremented by 1. So a nextval will work.
528:
529: hr_utility.set_location('Calling GHR get max seq:'|| l_proc, 12);
530: -- If Agency_get_max returns null then call GHR function
531:
532: If l_agency_seq is null then
533:

Line 534: hr_utility.set_location('l_agency_seq is null'|| l_proc, 13);

530: -- If Agency_get_max returns null then call GHR function
531:
532: If l_agency_seq is null then
533:
534: hr_utility.set_location('l_agency_seq is null'|| l_proc, 13);
535: hr_utility.set_location('Calling GHR Get Max'|| l_proc, 14);
536:
537: l_new_seq := ghr_posn_copy.get_max_seq(
538: l_seq_segment_name,

Line 535: hr_utility.set_location('Calling GHR Get Max'|| l_proc, 14);

531:
532: If l_agency_seq is null then
533:
534: hr_utility.set_location('l_agency_seq is null'|| l_proc, 13);
535: hr_utility.set_location('Calling GHR Get Max'|| l_proc, 14);
536:
537: l_new_seq := ghr_posn_copy.get_max_seq(
538: l_seq_segment_name,
539: p_business_group_id,

Line 571: hr_utility.set_location('GHR Get Max = '|| l_new_seq, 15);

567: p_segment28,
568: p_segment29,
569: p_segment30);
570:
571: hr_utility.set_location('GHR Get Max = '|| l_new_seq, 15);
572:
573: -- Add 1 to current max sequence returned if not null.
574: IF l_new_seq IS NULL THEN
575: l_new_seq := 1;

Line 885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);

881: -- Set Status to Invalid for all copies
882: l_pos_data.status := 'INVALID';
883: --
884:
885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);
886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);

Line 886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);

882: l_pos_data.status := 'INVALID';
883: --
884:
885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);
886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);

Line 887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);

883: --
884:
885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);
886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);

Line 888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);

884:
885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);
886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);

Line 889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);

885: hr_utility.set_location('Calling ghr_posndt.create_position:'|| l_proc, 20);
886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);

Line 890: hr_utility.set_location('l_position_id : '||l_position_id , 21);

886: hr_utility.set_location('l_segment1 :'||l_segment1, 21);
887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);

Line 891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);

887: hr_utility.set_location('l_segment2 :'||l_segment2, 21);
888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);

Line 892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);

888: hr_utility.set_location('l_segment3 :'||l_segment3, 21);
889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);

Line 893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);

889: hr_utility.set_location('l_segment4 :'||l_segment4, 21);
890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);

Line 894: hr_utility.set_location('l_name :'||l_name, 21);

890: hr_utility.set_location('l_position_id : '||l_position_id , 21);
891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);
898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);

Line 895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);

891: hr_utility.set_location('l_effective_start_date: '||l_effective_start_date, 21);
892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);
898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);
899:

Line 896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);

892: hr_utility.set_location('l_effective_end_date: '||l_effective_end_date, 21);
893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);
898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);
899:
900: ghr_posndt_api.create_position(

Line 897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);

893: hr_utility.set_location('l_position_definition_id: '||l_position_definition_id, 21);
894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);
898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);
899:
900: ghr_posndt_api.create_position(
901: p_position_id => l_position_id

Line 898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);

894: hr_utility.set_location('l_name :'||l_name, 21);
895: hr_utility.set_location('p_effective_date :'||p_effective_date, 21);
896: hr_utility.set_location('p_date_effective :'||p_date_effective, 21);
897: hr_utility.set_location('p_business_group_id :'||p_business_group_id, 21);
898: hr_utility.set_location('p_concat_segments :'||p_concat_segments, 21);
899:
900: ghr_posndt_api.create_position(
901: p_position_id => l_position_id
902: ,p_effective_start_date => l_effective_start_date

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

1062: ,p_program_id => p_program_id
1063: ,p_program_update_date => p_program_update_date
1064: );
1065:
1066: hr_utility.set_location(l_proc, 25);
1067:
1068: p_position_id := l_position_id;
1069: p_effective_start_date := l_effective_start_date;
1070: p_effective_end_date := l_effective_end_date;

Line 1075: hr_utility.set_location('Created '||p_position_id||' '||p_name, 20);

1071: p_position_definition_id := l_position_definition_id;
1072: p_name := l_name;
1073: p_object_version_number := l_object_version_number;
1074:
1075: hr_utility.set_location('Created '||p_position_id||' '||p_name, 20);
1076:
1077: -- Add Creation of Position Extra Info Here --
1078: --
1079: create_all_posn_ei(l_source_posn_id, p_effective_date, p_position_id, l_session_date);

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

1120: ,p_position_id
1121: ,p_date_effective
1122: ,cur_pit_rec.information_type);
1123: END LOOP;
1124: hr_utility.set_location(l_proc, 30);
1125:
1126: END create_all_posn_ei;
1127: --
1128: --

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

1156: ,p_date_effective => p_date_effective
1157: ,p_posei_data => l_pos_ei_data
1158: ,p_result_code => l_result_code);
1159: --
1160: hr_utility.set_location(l_proc, 35);
1161: --
1162: -- Now create it against the to position
1163: --
1164: /*

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

1240: ,p_poei_information30 => l_pos_ei_data.poei_information30
1241: ,p_position_extra_info_id => l_dummy_number
1242: ,p_object_version_number => l_dummy_number);
1243:
1244: hr_utility.set_location(l_proc, 40);
1245: --dbms_output.put_line('EI Created ');
1246:
1247: END LOOP;
1248:

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

1245: --dbms_output.put_line('EI Created ');
1246:
1247: END LOOP;
1248:
1249: hr_utility.set_location(l_proc, 50);
1250: --
1251: END create_posn_ei;
1252:
1253: END ghr_posn_copy;