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_MTO_PKG dependencies on HR_UTILITY

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

46: l_remark_id ghr_pa_remarks.remark_id%type;
47:
48: BEGIN
49: g_proc := 'create_lac_remarks';
50: hr_utility.set_location('Entering ' || l_proc,5);
51:
52: pr('Inside '||l_proc,to_char(p_pa_request_id),to_char(p_new_pa_request_id));
53: --hr_utility.trace_on(null,'sundar');
54: FOR l_rem_code IN cur_rem_code(p_effective_date) LOOP

Line 53: --hr_utility.trace_on(null,'sundar');

49: g_proc := 'create_lac_remarks';
50: hr_utility.set_location('Entering ' || l_proc,5);
51:
52: pr('Inside '||l_proc,to_char(p_pa_request_id),to_char(p_new_pa_request_id));
53: --hr_utility.trace_on(null,'sundar');
54: FOR l_rem_code IN cur_rem_code(p_effective_date) LOOP
55: l_remark_id := l_rem_code.remark_id;
56: END LOOP;
57:

Line 63: hr_utility.set_location('Remark id ' || l_remarks_rec.remark_id,10);

59: LOOP
60:
61: l_remarks_rec := cur_pa_rem_rec;
62: -- If the remarks is M67, Then need to populate the address lines
63: hr_utility.set_location('Remark id ' || l_remarks_rec.remark_id,10);
64: hr_utility.set_location('Remark id ' || l_remark_id,10);
65: IF (l_remarks_rec.remark_id = l_remark_id) THEN
66:
67: IF p_pa_request_rec.forwarding_address_line1 IS NOT NULL THEN

Line 64: hr_utility.set_location('Remark id ' || l_remark_id,10);

60:
61: l_remarks_rec := cur_pa_rem_rec;
62: -- If the remarks is M67, Then need to populate the address lines
63: hr_utility.set_location('Remark id ' || l_remarks_rec.remark_id,10);
64: hr_utility.set_location('Remark id ' || l_remark_id,10);
65: IF (l_remarks_rec.remark_id = l_remark_id) THEN
66:
67: IF p_pa_request_rec.forwarding_address_line1 IS NOT NULL THEN
68: l_remarks_rec.remark_code_information1 := p_pa_request_rec.forwarding_address_line1;

Line 70: --hr_utility.set_location('1.l_remark_code_information1' || l_remark_code_information1,10);

66:
67: IF p_pa_request_rec.forwarding_address_line1 IS NOT NULL THEN
68: l_remarks_rec.remark_code_information1 := p_pa_request_rec.forwarding_address_line1;
69: END IF;
70: --hr_utility.set_location('1.l_remark_code_information1' || l_remark_code_information1,10);
71:
72: IF p_pa_request_rec.forwarding_address_line2 IS NOT NULL THEN
73: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_address_line2;
74: END IF;

Line 75: --hr_utility.set_location('2.l_remark_code_information1' || l_remark_code_information1,11);

71:
72: IF p_pa_request_rec.forwarding_address_line2 IS NOT NULL THEN
73: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_address_line2;
74: END IF;
75: --hr_utility.set_location('2.l_remark_code_information1' || l_remark_code_information1,11);
76:
77: IF p_pa_request_rec.forwarding_address_line3 IS NOT NULL THEN
78: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_address_line3;
79: END IF;

Line 80: --hr_utility.set_location('3.l_remark_code_information1' || l_remark_code_information1,12);

76:
77: IF p_pa_request_rec.forwarding_address_line3 IS NOT NULL THEN
78: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_address_line3;
79: END IF;
80: --hr_utility.set_location('3.l_remark_code_information1' || l_remark_code_information1,12);
81:
82: IF p_pa_request_rec.forwarding_town_or_city IS NOT NULL THEN
83: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_town_or_city;
84: END IF;

Line 85: --hr_utility.set_location('4.l_remark_code_information1' || l_remark_code_information1,13);

81:
82: IF p_pa_request_rec.forwarding_town_or_city IS NOT NULL THEN
83: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_town_or_city;
84: END IF;
85: --hr_utility.set_location('4.l_remark_code_information1' || l_remark_code_information1,13);
86:
87: IF p_pa_request_rec.forwarding_region_2 IS NOT NULL THEN
88: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_region_2;
89: END IF;

Line 90: --hr_utility.set_location('5.l_remark_code_information1' || l_remark_code_information1,14);

86:
87: IF p_pa_request_rec.forwarding_region_2 IS NOT NULL THEN
88: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_region_2;
89: END IF;
90: --hr_utility.set_location('5.l_remark_code_information1' || l_remark_code_information1,14);
91:
92: IF p_pa_request_rec.forwarding_postal_code IS NOT NULL THEN
93: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_postal_code;
94: END IF;

Line 95: --hr_utility.set_location('6.l_remark_code_information1' || l_remark_code_information1,15);

91:
92: IF p_pa_request_rec.forwarding_postal_code IS NOT NULL THEN
93: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_postal_code;
94: END IF;
95: --hr_utility.set_location('6.l_remark_code_information1' || l_remark_code_information1,15);
96:
97: IF p_pa_request_rec.forwarding_country IS NOT NULL THEN
98: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_country;
99: END IF;

Line 100: --hr_utility.set_location('7.l_remark_code_information1' || l_remark_code_information1,16);

96:
97: IF p_pa_request_rec.forwarding_country IS NOT NULL THEN
98: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_country;
99: END IF;
100: --hr_utility.set_location('7.l_remark_code_information1' || l_remark_code_information1,16);
101:
102: IF p_pa_request_rec.forwarding_country_short_name IS NOT NULL THEN
103: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_country_short_name;
104: END IF;

Line 105: --hr_utility.set_location('8.l_remark_code_information1' || l_remark_code_information1,17);

101:
102: IF p_pa_request_rec.forwarding_country_short_name IS NOT NULL THEN
103: l_remarks_rec.remark_code_information1 := l_remarks_rec.remark_code_information1 || ', ' || p_pa_request_rec.forwarding_country_short_name;
104: END IF;
105: --hr_utility.set_location('8.l_remark_code_information1' || l_remark_code_information1,17);
106:
107: l_remarks_rec.remark_code_information2 := Null;
108: l_remarks_rec.remark_code_information3 := Null;
109: l_remarks_rec.remark_code_information4 := Null;

Line 112: hr_utility.set_location('description ' || l_remarks_rec.description,10);

108: l_remarks_rec.remark_code_information3 := Null;
109: l_remarks_rec.remark_code_information4 := Null;
110: l_remarks_rec.remark_code_information5 := Null;
111: l_remarks_rec.description := 'Forwarding address: ' || l_remarks_rec.remark_code_information1;
112: hr_utility.set_location('description ' || l_remarks_rec.description,10);
113: END IF;
114: hr_utility.set_location('l_remarks_rec.object_version_number ' ||l_remarks_rec.object_version_number,10);
115: pr('Rem id '||to_char(l_remarks_rec.remark_id));
116: ghr_pa_remarks_api.create_pa_remarks

Line 114: hr_utility.set_location('l_remarks_rec.object_version_number ' ||l_remarks_rec.object_version_number,10);

110: l_remarks_rec.remark_code_information5 := Null;
111: l_remarks_rec.description := 'Forwarding address: ' || l_remarks_rec.remark_code_information1;
112: hr_utility.set_location('description ' || l_remarks_rec.description,10);
113: END IF;
114: hr_utility.set_location('l_remarks_rec.object_version_number ' ||l_remarks_rec.object_version_number,10);
115: pr('Rem id '||to_char(l_remarks_rec.remark_id));
116: ghr_pa_remarks_api.create_pa_remarks
117: (p_validate => false
118: ,p_pa_request_id => p_new_pa_request_id

Line 131: --hr_utility.trace_off;

127: ,p_object_version_number => l_remarks_rec.object_version_number
128: );
129:
130: END LOOP;
131: --hr_utility.trace_off;
132: hr_utility.set_location('Exiting ' || l_proc,10);
133:
134: EXCEPTION
135: WHEN OTHERS THEN

Line 132: hr_utility.set_location('Exiting ' || l_proc,10);

128: );
129:
130: END LOOP;
131: --hr_utility.trace_off;
132: hr_utility.set_location('Exiting ' || l_proc,10);
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

Line 136: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

132: hr_utility.set_location('Exiting ' || l_proc,10);
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
137: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm;
138: raise mass_error;
139: END create_lac_remarks;
140:

Line 501: --hr_utility.trace_on(null,'sundar');

497:
498: BEGIN
499: p_retcode := 0;
500: g_proc := 'execute_mto';
501: --hr_utility.trace_on(null,'sundar');
502: pr('Inside execute mto');
503: pr('Mass Transfer id is '||p_mass_transfer_id,' Action is '|| p_action);
504: hr_utility.set_location('Entering ' || l_proc,5);
505: l_ind := 10;

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

500: g_proc := 'execute_mto';
501: --hr_utility.trace_on(null,'sundar');
502: pr('Inside execute mto');
503: pr('Mass Transfer id is '||p_mass_transfer_id,' Action is '|| p_action);
504: hr_utility.set_location('Entering ' || l_proc,5);
505: l_ind := 10;
506: pr('Before set log');
507: --ghr_mto_int.set_log_program_name('Mass Transfer OUT');
508: pr('After set log');

Line 537: hr_utility.set_location('Mass Transfer is in use',1);

533: END LOOP;
534:
535: EXCEPTION
536: when REC_BUSY then
537: hr_utility.set_location('Mass Transfer is in use',1);
538: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
539: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
540: hr_utility.raise_error;
541: when others then

Line 539: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');

535: EXCEPTION
536: when REC_BUSY then
537: hr_utility.set_location('Mass Transfer is in use',1);
538: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
539: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
540: hr_utility.raise_error;
541: when others then
542: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
543: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);

Line 540: hr_utility.raise_error;

536: when REC_BUSY then
537: hr_utility.set_location('Mass Transfer is in use',1);
538: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
539: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
540: hr_utility.raise_error;
541: when others then
542: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
543: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
544: raise mass_error;

Line 542: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);

538: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
539: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
540: hr_utility.raise_error;
541: when others then
542: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
543: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
544: raise mass_error;
545: END;
546:

Line 555: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');

551: END IF;
552:
553: IF upper(p_action) = 'CREATE' then
554: if l_pa_request_id is null then
555: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
556: hr_utility.raise_error;
557: END IF;
558: END IF;
559:

Line 556: hr_utility.raise_error;

552:
553: IF upper(p_action) = 'CREATE' then
554: if l_pa_request_id is null then
555: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
556: hr_utility.raise_error;
557: END IF;
558: END IF;
559:
560: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,

Line 594: hr_utility.set_location('Mass Transfer is in use',1);

590: exit;
591: END LOOP;
592: EXCEPTION
593: when REC_BUSY then
594: hr_utility.set_location('Mass Transfer is in use',1);
595: l_mass_errbuf := 'Error in '||l_proc||
596: ' This Mass Trasnfer is in use';
597: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
598: hr_utility.raise_error;

Line 597: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');

593: when REC_BUSY then
594: hr_utility.set_location('Mass Transfer is in use',1);
595: l_mass_errbuf := 'Error in '||l_proc||
596: ' This Mass Trasnfer is in use';
597: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
598: hr_utility.raise_error;
599: when others then
600: hr_utility.set_location('Error in '||l_proc||
601: ' at select from mass tfr'||

Line 598: hr_utility.raise_error;

594: hr_utility.set_location('Mass Transfer is in use',1);
595: l_mass_errbuf := 'Error in '||l_proc||
596: ' This Mass Trasnfer is in use';
597: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
598: hr_utility.raise_error;
599: when others then
600: hr_utility.set_location('Error in '||l_proc||
601: ' at select from mass tfr'||
602: ' Sql err is '||sqlerrm(sqlcode),1);

Line 600: hr_utility.set_location('Error in '||l_proc||

596: ' This Mass Trasnfer is in use';
597: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
598: hr_utility.raise_error;
599: when others then
600: hr_utility.set_location('Error in '||l_proc||
601: ' at select from mass tfr'||
602: ' Sql err is '||sqlerrm(sqlcode),1);
603: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '||
604: sqlerrm(sqlcode);

Line 611: hr_utility.set_location('Error in '||l_proc||

607: END IF;
608: EXCEPTION
609: when mass_error then raise;
610: when others then
611: hr_utility.set_location('Error in '||l_proc||
612: ' Sql err is '||sqlerrm(sqlcode),1);
613: l_mass_errbuf := 'Error in '||l_proc||' at call for dump proc'||
614: ' Sql Err is '|| sqlerrm(sqlcode);
615: raise mass_error;

Line 630: hr_utility.set_location('After fetch mto '||to_char(l_effective_date),1);

626: l_ind := 20;
627: --purge_old_data(p_mass_transfer_id);
628:
629: l_ind := 30;
630: hr_utility.set_location('After fetch mto '||to_char(l_effective_date),1);
631: pr('After sel mass transfers',to_char(l_effective_date));
632:
633: if p_position_id is not null then
634: l_check_org_pos := 'P';

Line 718: hr_utility.set_location

714: per.person_id);
715:
716: if l_errbuf is not null then
717: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
718: hr_utility.set_location
719: ('Error in ghr_mto_int.mass_transfer_out'||
720: 'Err is '||l_errbuf,20);
721: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
722: ' Err is '|| l_errbuf;

Line 756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then
755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
757: 'Err is '||sqlerrm(sqlcode),20);
758: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
759: sqlerrm(sqlcode);
760: raise mass_error;

Line 819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

815: l_part_time_hour);
816: EXCEPTION
817: when others then
818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
820: 'Err is '||sqlerrm(sqlcode),20);
821: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
822: sqlerrm(sqlcode);
823: raise mass_error;

Line 836: l_mass_errbuf := hr_utility.get_message;

832: l_pay_table_id,l_grade_or_level, l_step_or_rate,
833: l_pay_basis);
834: EXCEPTION
835: when ghr_msl_pkg.msl_error then
836: l_mass_errbuf := hr_utility.get_message;
837: raise mass_error;
838: END;
839:
840: get_pos_grp2_ddf(l_position_id,

Line 856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

852: ,p_duty_station_desc => l_duty_station_desc);
853: EXCEPTION
854: when others then
855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
857: 'Err is '||sqlerrm(sqlcode),20);
858: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
859: sqlerrm(sqlcode);
860: raise mass_error;

Line 926: hr_utility.set_location

922:
923: if l_errbuf is not null then
924: pr('Error in ghr_mto_int.mass_transfer_out'||
925: l_errbuf);
926: hr_utility.set_location
927: ('Error in ghr_mto_int.mass_transfer_out'||
928: 'Err is '||l_errbuf,20);
929: l_mass_errbuf :=
930: 'Error in ghr_mto_int.mass_transfer_out'||

Line 959: l_mass_errbuf := hr_utility.get_message;

955: l_grade_or_level, l_step_or_rate,
956: l_pay_basis);
957: EXCEPTION
958: when ghr_msl_pkg.msl_error then
959: l_mass_errbuf := hr_utility.get_message;
960: raise mass_error;
961: END;
962: l_ind := 200;
963:

Line 972: hr_utility.set_location('Agency Code in quick fix ' || l_agency_code,5);

968: get_to_agency (per.person_id,
969: l_effective_date,
970: l_agency_code);
971:
972: hr_utility.set_location('Agency Code in quick fix ' || l_agency_code,5);
973:
974: if l_agency_code is null then
975: l_agency_code := p_to_agency_code;
976: end if;

Line 978: hr_utility.set_location('Agency Code in Next ' || l_agency_code,6);

974: if l_agency_code is null then
975: l_agency_code := p_to_agency_code;
976: end if;
977:
978: hr_utility.set_location('Agency Code in Next ' || l_agency_code,6);
979:
980:
981: pr('Bef assign to sf52 rec');
982: assign_to_sf52_rec(

Line 1081: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||

1077: end if;
1078: ----- commit;
1079: exception
1080: when others then
1081: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
1082: ' Sql Err is '|| sqlerrm(sqlcode) || l_proc, 225);
1083: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req'||
1084: ' Sql Err is '|| sqlerrm(sqlcode);
1085: raise mass_error;

Line 1091: hr_utility.set_location('Before commiting',2);

1087: --------------------- Added AVR end
1088:
1089: if l_errbuf is null then
1090: pr('No error in create sf52 sel flg is '||l_sel_flg);
1091: hr_utility.set_location('Before commiting',2);
1092:
1093: ghr_mto_int.log_message(
1094: p_procedure => 'Successful Completion',
1095: p_message =>

Line 1109: hr_utility.set_location('Error in '||to_char(per.position_id),20);

1105:
1106: commit;
1107: else
1108: pr('Error in create sf52',l_errbuf);
1109: hr_utility.set_location('Error in '||to_char(per.position_id),20);
1110: --l_recs_failed := l_recs_failed + 1;
1111: raise mass_error;
1112: end if;
1113: exception

Line 1147: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

1143: end if;
1144: end if;
1145: EXCEPTION
1146: WHEN mass_ERROR THEN
1147: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1148: begin
1149: ROLLBACK TO EXECUTE_MTO_SP;
1150: exception
1151: when others then null;

Line 1159: hr_utility.set_location('before creating entry in log file',10);

1155: ' For Mass Transfer Name : '||p_mass_transfer_name||
1156: ' for Employee: '||per.full_name||
1157: ' SSN: '||per.national_identifier||
1158: l_mass_errbuf;
1159: hr_utility.set_location('before creating entry in log file',10);
1160: l_recs_failed := l_recs_failed + 1;
1161: begin
1162: ghr_mto_int.log_message(
1163: p_procedure => g_proc,

Line 1167: hr_utility.set_location('Error (Others) occurred in '||l_proc||

1163: p_procedure => g_proc,
1164: p_message => l_log_text);
1165: end;
1166: WHEN others then
1167: hr_utility.set_location('Error (Others) occurred in '||l_proc||
1168: ' Sql error '||sqlerrm(sqlcode),20);
1169: begin
1170: ROLLBACK TO EXECUTE_MTO_SP;
1171: exception

Line 1181: hr_utility.set_location('before creating entry in log file',20);

1177: ' For Mass Transfer Name : '||p_mass_transfer_name||
1178: ' for Employee: '||per.full_name||
1179: ' SSN: '||per.national_identifier||
1180: ' Sql Err is '||sqlerrm(sqlcode);
1181: hr_utility.set_location('before creating entry in log file',20);
1182: l_recs_failed := l_recs_failed + 1;
1183: begin
1184: ghr_mto_int.log_message(
1185: p_procedure => g_proc,

Line 1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);

1386: l_office_symbol,
1387: l_position_organization,
1388: l_pos_grp1_rec);
1389:
1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);

Line 1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);

1387: l_position_organization,
1388: l_pos_grp1_rec);
1389:
1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1395:

Line 1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);

1388: l_pos_grp1_rec);
1389:
1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1395:
1396: IF check_eligibility(

Line 1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);

1389:
1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1395:
1396: IF check_eligibility(
1397: p_org_structure_id,

Line 1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);

1390: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1391: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1392: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1393: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1394: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1395:
1396: IF check_eligibility(
1397: p_org_structure_id,
1398: p_office_symbol,

Line 1415: hr_utility.set_location('Vac Pos Selected ' || l_position_title,5);

1411: l_effective_date,
1412: null, ---- person_id
1413: null) then
1414:
1415: hr_utility.set_location('Vac Pos Selected ' || l_position_title,5);
1416: ---AVR end
1417: -- VSM- Bug # 758441
1418: -- Position history not created for Date end and org id
1419: -- Created wrapper procedure update_position_info for

Line 1465: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);

1461: interface_flag)
1462: where mass_transfer_id = p_mass_transfer_id;
1463: EXCEPTION
1464: when others then
1465: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1466: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1467: hr_utility.raise_error;
1468: END;
1469: end if;

Line 1466: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');

1462: where mass_transfer_id = p_mass_transfer_id;
1463: EXCEPTION
1464: when others then
1465: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1466: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1467: hr_utility.raise_error;
1468: END;
1469: end if;
1470: ELSE

Line 1467: hr_utility.raise_error;

1463: EXCEPTION
1464: when others then
1465: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1466: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1467: hr_utility.raise_error;
1468: END;
1469: end if;
1470: ELSE
1471: -- 4215268

Line 1523: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

1519: update ghr_mass_transfers
1520: set status = 'E'
1521: where mass_transfer_id = p_mass_transfer_id;
1522: END IF;
1523: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1524: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1525: p_retcode := 2;
1526: hr_utility.set_location('before creating entry in log file',10);
1527: --Bug#4183516 Skip this process log entry as one entry is already

Line 1526: hr_utility.set_location('before creating entry in log file',10);

1522: END IF;
1523: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1524: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1525: p_retcode := 2;
1526: hr_utility.set_location('before creating entry in log file',10);
1527: --Bug#4183516 Skip this process log entry as one entry is already
1528: -- written during DUMP OUT Process at l_recs_failed NOT NULL part .
1529: IF l_mass_errbuf NOT LIKE 'DUMP OUT Failed%' THEN
1530: l_log_text := 'Error in '||l_proc||' '||

Line 1548: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);

1544: update ghr_mass_transfers
1545: set status = 'E'
1546: where mass_transfer_id = p_mass_transfer_id;
1547: END IF;
1548: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
1549: l_log_text := 'Error in '||l_proc||
1550: ' For Mass Transfer Name : '||p_mass_transfer_name||
1551: ' Sql Err is '||sqlerrm(sqlcode);
1552: l_recs_failed := l_recs_failed + 1;

Line 1555: hr_utility.set_location('before creating entry in log file',30);

1551: ' Sql Err is '||sqlerrm(sqlcode);
1552: l_recs_failed := l_recs_failed + 1;
1553: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1554: p_retcode := 2;
1555: hr_utility.set_location('before creating entry in log file',30);
1556: begin
1557: ghr_mto_int.log_message(
1558: p_procedure => g_proc,
1559: p_message => l_log_text);

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

1621:
1622: l_proc varchar2(72)
1623: := g_package || '.pop_dtls_from_pa_req';
1624: begin
1625: hr_utility.set_location('Entering ' || l_proc,5);
1626: pr('Entering ' || l_proc,to_char(p_person_id),to_char(p_effective_date));
1627: g_proc := 'pop_dtls_from_pa_req';
1628: for pa_req_rec in ghr_pa_req_cur
1629: loop

Line 1663: hr_utility.set_location('Exiting ' || l_proc,10);

1659: 'REPORT',
1660: pa_req_rec.EMPLOYEE_ASSIGNMENT_ID);
1661: exit;
1662: END LOOP;
1663: hr_utility.set_location('Exiting ' || l_proc,10);
1664: exception
1665: when mass_error then raise;
1666: when others then
1667: pr('Error in '||l_proc);

Line 1668: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

1664: exception
1665: when mass_error then raise;
1666: when others then
1667: pr('Error in '||l_proc);
1668: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1669: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1670: raise mass_error;
1671: end pop_dtls_from_pa_req;
1672:

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

1686: l_proc varchar2(72) := g_package || '.check_select_flg';
1687: l_sel_flg varchar2(3);
1688: begin
1689: l_sel_flg := p_sel_flg;
1690: hr_utility.set_location('Entering ' || l_proc,5);
1691: g_proc := 'check_select_flg';
1692: get_extra_info_comments(p_position_id,p_effective_date,p_sel_flg,
1693: l_comments,l_mtfr_id);
1694: --p_sel_status := l_sel_status;

Line 1729: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

1725: when mass_error then raise;
1726: when others then
1727: p_sel_flg := l_sel_flg;
1728: pr('Error in '||l_proc);
1729: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1730: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1731: raise mass_error;
1732: end;
1733:

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

1738: procedure purge_old_data (p_mass_transfer_id in number) is
1739: l_proc varchar2(72)
1740: := g_package || '.purge_old_data';
1741: BEGIN
1742: hr_utility.set_location('Entering ' || l_proc,5);
1743: g_proc := 'purge_old_data';
1744: pr('Mass Transfer id is '||to_char(p_mass_transfer_id));
1745: delete from ghr_mass_actions_preview
1746: where mass_action_type = 'TRANSFER'

Line 1749: hr_utility.set_location('Exiting ' || l_proc,10);

1745: delete from ghr_mass_actions_preview
1746: where mass_action_type = 'TRANSFER'
1747: and session_id = p_mass_transfer_id;
1748: commit;
1749: hr_utility.set_location('Exiting ' || l_proc,10);
1750: exception
1751: when others then
1752: pr('Error in '||l_proc);
1753: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

Line 1753: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

1749: hr_utility.set_location('Exiting ' || l_proc,10);
1750: exception
1751: when others then
1752: pr('Error in '||l_proc);
1753: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1754: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1755: raise mass_error;
1756: END;
1757:

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

1774:
1775: l_proc varchar2(72)
1776: := g_package || '.ins_upd_pos_extra_info';
1777: begin
1778: hr_utility.set_location('Entering ' || l_proc,5);
1779: g_proc := 'ins_upd_pos_extra_info';
1780: if p_effective_date > sysdate then
1781: l_eff_date := sysdate;
1782: else

Line 1832: hr_utility.set_location('Exiting ' || l_proc,10);

1828: ,P_OBJECT_VERSION_NUMBER => l_object_version_number);
1829: --Bug#4215231 Reset the global variable
1830: ghr_api.g_api_dml := FALSE;
1831: end if;
1832: hr_utility.set_location('Exiting ' || l_proc,10);
1833:
1834: -- There is a trigger on Position extra Info. Whenever updated/created the
1835: -- main position associated with it becomes invalid.
1836: -- We shall call validate_perwsdpo procedure to set the status = VALID.

Line 1848: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

1844: exception
1845: when mass_error then raise;
1846: when others then
1847: pr('Error in '||l_proc);
1848: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1849: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1850: raise mass_error;
1851: end ins_upd_pos_extra_info;
1852:

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

1862: l_eff_date date;
1863: l_proc varchar2(72)
1864: := g_package || '.update_sel_flg';
1865: begin
1866: hr_utility.set_location('Entering ' || l_proc,5);
1867: g_proc := 'update_sel_flg';
1868:
1869: if p_effective_date > sysdate then
1870: l_eff_date := sysdate;

Line 1903: hr_utility.set_location('Exiting ' || l_proc,10);

1899: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);
1900: -- ghr_validate_perwsdpo.update_posn_status(p_position_id);
1901:
1902: end if;
1903: hr_utility.set_location('Exiting ' || l_proc,10);
1904: exception
1905: when mass_error then raise;
1906: when others then
1907: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

Line 1907: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

1903: hr_utility.set_location('Exiting ' || l_proc,10);
1904: exception
1905: when mass_error then raise;
1906: when others then
1907: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1908: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1909: raise mass_error;
1910: end update_sel_flg;
1911:

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

1946: l_occ_code varchar2(30) := null;
1947: l_proc varchar2(72)
1948: := g_package || '.check_eligibility';
1949: BEGIN
1950: hr_utility.set_location('Entering ' || l_proc,5);
1951: g_proc := 'check_eligibility';
1952:
1953: if p_org_structure_id is not null then
1954: if p_org_structure_id <> nvl(p_l_org_structure_id,'NULL!~') then

Line 2038: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2034: exception
2035: when mass_error then raise;
2036: when others then
2037: pr('Error in '||l_proc);
2038: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2039: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2040: raise mass_error;
2041: END check_eligibility;
2042:

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

2070: l_office_symbol := p_office_symbol;
2071: l_position_organization := p_position_organization;
2072: l_pos_ei_data := p_pos_ei_data;
2073:
2074: hr_utility.set_location('Entering ' || l_proc,5);
2075: g_proc := 'get_pos_grp1_ddf';
2076: ghr_history_fetch.fetch_positionei
2077: (p_position_id => p_position_id
2078: ,p_information_type => 'GHR_US_POS_GRP1'

Line 2094: hr_utility.set_location('Exiting ' || l_proc,10);

2090: p_office_symbol := l_office_symbol;
2091: p_org_structure_id := l_org_structure_id;
2092: p_position_organization := l_position_organization;
2093:
2094: hr_utility.set_location('Exiting ' || l_proc,10);
2095: exception
2096: when mass_error then raise;
2097: when others then
2098: -- NOCOPY Changes

Line 2106: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2102: p_org_structure_id := NULL;
2103: p_position_organization := NULL;
2104: -- NOCOPY changes end
2105: pr('Error in '||l_proc);
2106: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2107: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2108: raise mass_error;
2109: END get_pos_grp1_ddf;
2110:

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

2134: l_appropriation_code1 := p_appropriation_code1;
2135: l_appropriation_code2 := p_appropriation_code2;
2136: l_pos_ei_data := p_pos_ei_data;
2137:
2138: hr_utility.set_location('Entering ' || l_proc,5);
2139: g_proc := 'get_pos_grp2_ddf';
2140: ghr_history_fetch.fetch_positionei
2141: (p_position_id => p_position_id
2142: ,p_information_type => 'GHR_US_POS_GRP2'

Line 2157: hr_utility.set_location('Exiting ' || l_proc,10);

2153: p_appropriation_code1 := l_appropriation_code1;
2154: p_appropriation_code2 := l_appropriation_code2;
2155: --- NOCOPY changes
2156:
2157: hr_utility.set_location('Exiting ' || l_proc,10);
2158: exception
2159: when mass_error then raise;
2160: when others then
2161: ---NOCOPY Changes

Line 2169: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2165: p_appropriation_code2 := NULL;
2166: ---NOCOPY Changes END
2167:
2168: pr('Error in '||l_proc);
2169: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2170: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2171: raise mass_error;
2172: END get_pos_grp2_ddf;
2173:

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

2196: l_sel_flag := p_sel_flag;
2197: l_comments := p_comments;
2198: l_mtfr_id := p_mtfr_id;
2199: -- NOCOPY Changes
2200: hr_utility.set_location('Entering ' || l_proc,5);
2201:
2202: l_eff_date := p_effective_date;
2203: ghr_history_fetch.fetch_positionei
2204: (p_position_id => p_position_id

Line 2227: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2223: p_sel_flag := l_sel_flag;
2224: p_comments := l_comments;
2225: p_mtfr_id := l_mtfr_id;
2226: pr('Error in '||l_proc);
2227: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2228: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2229: raise mass_error;
2230: end;
2231:

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

2299: l_step_or_rate varchar2(30);
2300: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2301:
2302: begin
2303: hr_utility.set_location('Entering ' || l_proc,5);
2304: g_proc := 'create_mass_act_prev';
2305:
2306: pr('Inside ghr_cpdf_temp insert Transfer id ',to_char(p_mass_transfer_id),null);
2307: pr('t_pos_org is',t_position_organization);

Line 2369: hr_utility.set_location('Error in Mass Act Custom '||

2365: p_cust_rec => l_cust_rec);
2366:
2367: exception
2368: when others then
2369: hr_utility.set_location('Error in Mass Act Custom '||
2370: 'Err is '||sqlerrm(sqlcode),20);
2371: l_mass_errbuf := 'Error in Mass Act Custom '||
2372: 'Err is '|| sqlerrm(sqlcode);
2373: raise mass_error;

Line 2549: hr_utility.set_location('Exiting ' || l_proc,10);

2545: l_cust_rec.user_attribute19,
2546: l_cust_rec.user_attribute20
2547: );
2548:
2549: hr_utility.set_location('Exiting ' || l_proc,10);
2550: exception
2551: when mass_error then raise;
2552: when others then
2553: pr('Error in '||l_proc);

Line 2555: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2551: when mass_error then raise;
2552: when others then
2553: pr('Error in '||l_proc);
2554: pr('Position title is '||p_position_title||' Length is '||to_char(length(p_position_title)));
2555: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2556: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2557: raise mass_error;
2558: end create_mass_act_prev;
2559:

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

2570:
2571: l_mto_name varchar2(150);
2572: l_proc varchar2(72) := g_package || '.get_mre_name';
2573: begin
2574: hr_utility.set_location('Entering ' || l_proc,5);
2575: g_proc := 'get_mto_name';
2576: FOR mto_REC IN mto_cur
2577: LOOP
2578: l_mto_name := mto_rec.name;

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

2625: begin
2626:
2627: l_sf52_rec := p_sf52_rec;
2628:
2629: hr_utility.set_location('Entering ' || l_proc,5);
2630: g_proc := 'assign_to_sf52_rec';
2631:
2632: l_sf52_rec.person_id := p_person_id;
2633: l_sf52_rec.employee_first_name := p_first_name;

Line 2676: hr_utility.set_location('Exiting ' || l_proc,10);

2672: l_sf52_rec.FIRST_ACTION_LA_CODE2 := p_lac_sf52_rec.FIRST_ACTION_LA_CODE2;
2673: l_sf52_rec.FIRST_ACTION_LA_DESC1 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC1;
2674: l_sf52_rec.FIRST_ACTION_LA_DESC2 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC2;
2675:
2676: hr_utility.set_location('Exiting ' || l_proc,10);
2677:
2678: p_sf52_rec := l_sf52_rec;
2679:
2680: exception

Line 2687: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

2683: --NOCOPY changes
2684: p_sf52_rec := l_sf52_rec;
2685: -- NOCOPY Changes
2686: pr('Error in '||l_proc);
2687: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2688: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2689: raise mass_error;
2690: end assign_to_sf52_rec;
2691:

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

2752: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2753: l_eff_date date;
2754: l_agency_code varchar2(5);
2755: begin
2756: hr_utility.set_location('Entering ' || l_proc,5);
2757:
2758: -- NOCOPY changes
2759: l_agency_code := p_agency_code;
2760: -- NOCOPY changes

Line 2781: hr_utility.set_location('Agency Code ' || p_agency_code,10);

2777:
2778: -- NOCOPY changes
2779: p_agency_code := l_agency_code;
2780: -- NOCOPY changes
2781: hr_utility.set_location('Agency Code ' || p_agency_code,10);
2782: hr_utility.set_location('Leaving ' || l_proc,15);
2783: end;
2784:
2785: PROCEDURE upd_ext_info_api (p_person_id in number,

Line 2782: hr_utility.set_location('Leaving ' || l_proc,15);

2778: -- NOCOPY changes
2779: p_agency_code := l_agency_code;
2780: -- NOCOPY changes
2781: hr_utility.set_location('Agency Code ' || p_agency_code,10);
2782: hr_utility.set_location('Leaving ' || l_proc,15);
2783: end;
2784:
2785: PROCEDURE upd_ext_info_api (p_person_id in number,
2786: p_agency_code in varchar2,

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

2804: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2805: l_eff_date date;
2806:
2807: BEGIN
2808: hr_utility.set_location('Entering ' || l_proc,5);
2809: g_proc := 'upd_ext_info_api';
2810: if p_effective_date > sysdate then
2811: l_eff_date := sysdate;
2812: else

Line 2884: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);

2880: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
2881: exception
2882: when others then
2883: pr('Error in '||'pr');
2884: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
2885: l_mass_errbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);
2886: raise mass_error;
2887: end;
2888:

Line 2893: hr_utility.set_location('Entering ' || l_proc, 10);

2889: Procedure update_position_info
2890: (p_position_data_rec in ghr_sf52_pos_update.position_data_rec_type) is
2891: l_proc varchar2(30):='update_position_info';
2892: Begin
2893: hr_utility.set_location('Entering ' || l_proc, 10);
2894: g_proc := 'update_position_info';
2895: ghr_session.set_session_var_for_core( p_position_data_rec.effective_end_date );
2896: ghr_sf52_pos_update.update_position_info
2897: ( p_pos_data_rec => p_position_data_rec);

Line 2898: hr_utility.set_location('Calling Pust_update_process ' || l_proc, 50);

2894: g_proc := 'update_position_info';
2895: ghr_session.set_session_var_for_core( p_position_data_rec.effective_end_date );
2896: ghr_sf52_pos_update.update_position_info
2897: ( p_pos_data_rec => p_position_data_rec);
2898: hr_utility.set_location('Calling Pust_update_process ' || l_proc, 50);
2899: g_proc := 'post_update_process';
2900: ghr_history_api.post_update_process;
2901: hr_utility.set_location('Leaving ' || l_proc, 100);
2902:

Line 2901: hr_utility.set_location('Leaving ' || l_proc, 100);

2897: ( p_pos_data_rec => p_position_data_rec);
2898: hr_utility.set_location('Calling Pust_update_process ' || l_proc, 50);
2899: g_proc := 'post_update_process';
2900: ghr_history_api.post_update_process;
2901: hr_utility.set_location('Leaving ' || l_proc, 100);
2902:
2903: end;
2904:
2905: Procedure upd_per_extra_info_to_null(p_person_id in number) is