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 540: --hr_utility.trace_on(null,'sundar');

536:
537: BEGIN
538: p_retcode := 0;
539: g_proc := 'execute_mto';
540: --hr_utility.trace_on(null,'sundar');
541: pr('Inside execute mto');
542: pr('Mass Transfer id is '||p_mass_transfer_id,' Action is '|| p_action);
543: hr_utility.set_location('Entering ' || l_proc,5);
544: l_ind := 10;

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

539: g_proc := 'execute_mto';
540: --hr_utility.trace_on(null,'sundar');
541: pr('Inside execute mto');
542: pr('Mass Transfer id is '||p_mass_transfer_id,' Action is '|| p_action);
543: hr_utility.set_location('Entering ' || l_proc,5);
544: l_ind := 10;
545: --7186094
546: l_insert_log := 'Y';
547: pr('Before set log');

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

574: END LOOP;
575:
576: EXCEPTION
577: when REC_BUSY then
578: hr_utility.set_location('Mass Transfer is in use',1);
579: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
580: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
581: hr_utility.raise_error;
582: when others then

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

576: EXCEPTION
577: when REC_BUSY then
578: hr_utility.set_location('Mass Transfer is in use',1);
579: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
580: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
581: hr_utility.raise_error;
582: when others then
583: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
584: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);

Line 581: hr_utility.raise_error;

577: when REC_BUSY then
578: hr_utility.set_location('Mass Transfer is in use',1);
579: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
580: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
581: hr_utility.raise_error;
582: when others then
583: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
584: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
585: raise mass_error;

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

579: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
580: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
581: hr_utility.raise_error;
582: when others then
583: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
584: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
585: raise mass_error;
586: END;
587:

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

592: END IF;
593:
594: IF upper(p_action) = 'CREATE' then
595: if l_pa_request_id is null then
596: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
597: hr_utility.raise_error;
598: END IF;
599: END IF;
600:

Line 597: hr_utility.raise_error;

593:
594: IF upper(p_action) = 'CREATE' then
595: if l_pa_request_id is null then
596: hr_utility.set_message(8301, 'GHR_38567_SELECT_LAC_REMARKS');
597: hr_utility.raise_error;
598: END IF;
599: END IF;
600:
601: ghr_msl_pkg.get_lac_dtls(l_pa_request_id,

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

631: exit;
632: END LOOP;
633: EXCEPTION
634: when REC_BUSY then
635: hr_utility.set_location('Mass Transfer is in use',1);
636: l_mass_errbuf := 'Error in '||l_proc||
637: ' This Mass Trasnfer is in use';
638: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
639: hr_utility.raise_error;

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

634: when REC_BUSY then
635: hr_utility.set_location('Mass Transfer is in use',1);
636: l_mass_errbuf := 'Error in '||l_proc||
637: ' This Mass Trasnfer is in use';
638: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
639: hr_utility.raise_error;
640: when others then
641: hr_utility.set_location('Error in '||l_proc||
642: ' at select from mass tfr'||

Line 639: hr_utility.raise_error;

635: hr_utility.set_location('Mass Transfer is in use',1);
636: l_mass_errbuf := 'Error in '||l_proc||
637: ' This Mass Trasnfer is in use';
638: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
639: hr_utility.raise_error;
640: when others then
641: hr_utility.set_location('Error in '||l_proc||
642: ' at select from mass tfr'||
643: ' Sql err is '||sqlerrm(sqlcode),1);

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

637: ' This Mass Trasnfer is in use';
638: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MTO');
639: hr_utility.raise_error;
640: when others then
641: hr_utility.set_location('Error in '||l_proc||
642: ' at select from mass tfr'||
643: ' Sql err is '||sqlerrm(sqlcode),1);
644: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '||
645: sqlerrm(sqlcode);

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

648: END IF;
649: EXCEPTION
650: when mass_error then raise;
651: when others then
652: hr_utility.set_location('Error in '||l_proc||
653: ' Sql err is '||sqlerrm(sqlcode),1);
654: l_mass_errbuf := 'Error in '||l_proc||' at call for dump proc'||
655: ' Sql Err is '|| sqlerrm(sqlcode);
656: raise mass_error;

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

667: l_ind := 20;
668: --purge_old_data(p_mass_transfer_id);
669:
670: l_ind := 30;
671: hr_utility.set_location('After fetch mto '||to_char(l_effective_date),1);
672: pr('After sel mass transfers',to_char(l_effective_date));
673:
674: if p_position_id is not null then
675: l_check_org_pos := 'P';

Line 766: hr_utility.set_location

762: per.person_id);
763:
764: if l_errbuf is not null then
765: pr('Error in ghr_mto_int.mass_transfer_out'||l_errbuf);
766: hr_utility.set_location
767: ('Error in ghr_mto_int.mass_transfer_out'||
768: 'Err is '||l_errbuf,20);
769: l_mass_errbuf := 'Error in ghr_mto_int.mass_transfer_out'||
770: ' Err is '|| l_errbuf;

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

800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then
803: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
804: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
805: 'Err is '||sqlerrm(sqlcode),20);
806: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
807: sqlerrm(sqlcode);
808: raise mass_error;

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

863: l_part_time_hour);
864: EXCEPTION
865: when others then
866: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
867: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
868: 'Err is '||sqlerrm(sqlcode),20);
869: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
870: sqlerrm(sqlcode);
871: raise mass_error;

Line 888: hr_utility.get_message_details (msg_name => l_last_msg_set,

884: --7186094 added to insert the log for this expired retained details
885: -- message only for show and preview and not for create and dump
886: -- when the selection flag is not available
887: l_appl_name := 'GHR';
888: hr_utility.get_message_details (msg_name => l_last_msg_set,
889: msg_appl => l_appl_name);
890: if l_last_msg_set = 'GHR_38927_MISSING_MA_RET_DET' then
891: get_extra_info_comments(l_position_id,
892: l_effective_date,

Line 901: l_mass_errbuf := hr_utility.get_message;

897: IF l_ret_sel_flag is NULL and upper(p_action) IN ('CREATE','DUMP OUT') THEN
898: l_insert_log := 'N';
899: end if;
900: end if;
901: l_mass_errbuf := hr_utility.get_message;
902: raise mass_error;
903: END;
904:
905: get_pos_grp2_ddf(l_position_id,

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

917: ,p_duty_station_desc => l_duty_station_desc);
918: EXCEPTION
919: when others then
920: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
921: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
922: 'Err is '||sqlerrm(sqlcode),20);
923: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
924: sqlerrm(sqlcode);
925: raise mass_error;

Line 993: hr_utility.set_location

989:
990: if l_errbuf is not null then
991: pr('Error in ghr_mto_int.mass_transfer_out'||
992: l_errbuf);
993: hr_utility.set_location
994: ('Error in ghr_mto_int.mass_transfer_out'||
995: 'Err is '||l_errbuf,20);
996: l_mass_errbuf :=
997: 'Error in ghr_mto_int.mass_transfer_out'||

Line 1026: l_mass_errbuf := hr_utility.get_message;

1022: l_grade_or_level, l_step_or_rate,
1023: l_pay_basis);
1024: EXCEPTION
1025: when ghr_msl_pkg.msl_error then
1026: l_mass_errbuf := hr_utility.get_message;
1027: raise mass_error;
1028: END;
1029: l_ind := 200;
1030:

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

1035: get_to_agency (per.person_id,
1036: l_effective_date,
1037: l_agency_code);
1038:
1039: hr_utility.set_location('Agency Code in quick fix ' || l_agency_code,5);
1040:
1041: if l_agency_code is null then
1042: l_agency_code := p_to_agency_code;
1043: end if;

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

1041: if l_agency_code is null then
1042: l_agency_code := p_to_agency_code;
1043: end if;
1044:
1045: hr_utility.set_location('Agency Code in Next ' || l_agency_code,6);
1046:
1047:
1048: pr('Bef assign to sf52 rec');
1049: assign_to_sf52_rec(

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

1144: end if;
1145: ----- commit;
1146: exception
1147: when others then
1148: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
1149: ' Sql Err is '|| sqlerrm(sqlcode) || l_proc, 225);
1150: l_mass_errbuf := 'Error in ghr_par_extra info.create pa req'||
1151: ' Sql Err is '|| sqlerrm(sqlcode);
1152: raise mass_error;

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

1154: --------------------- Added AVR end
1155:
1156: if l_errbuf is null then
1157: pr('No error in create sf52 sel flg is '||l_sel_flg);
1158: hr_utility.set_location('Before commiting',2);
1159:
1160: --Bug # 9329643 Modified SSN to Emp No
1161: ghr_mto_int.log_message(
1162: p_procedure => 'Successful Completion',

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

1173:
1174: commit;
1175: else
1176: pr('Error in create sf52',l_errbuf);
1177: hr_utility.set_location('Error in '||to_char(per.position_id),20);
1178: --l_recs_failed := l_recs_failed + 1;
1179: raise mass_error;
1180: end if;
1181: exception

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

1211: end if;
1212: end if;
1213: EXCEPTION
1214: WHEN mass_ERROR THEN
1215: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1216: begin
1217: ROLLBACK TO EXECUTE_MTO_SP;
1218: exception
1219: when others then null;

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

1227: ' For Mass Transfer Name : '||p_mass_transfer_name||
1228: ' for Employee: '||per.full_name||
1229: ' Emp No: ' ||per.employee_number||
1230: l_mass_errbuf;
1231: hr_utility.set_location('before creating entry in log file',10);
1232: l_recs_failed := l_recs_failed + 1;
1233: begin
1234: ghr_mto_int.log_message(
1235: p_procedure => g_proc,

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

1236: p_message => l_log_text);
1237: end;
1238: end if;
1239: WHEN others then
1240: hr_utility.set_location('Error (Others) occurred in '||l_proc||
1241: ' Sql error '||sqlerrm(sqlcode),20);
1242: begin
1243: ROLLBACK TO EXECUTE_MTO_SP;
1244: exception

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

1251: ' For Mass Transfer Name : '||p_mass_transfer_name||
1252: ' for Employee: '||per.full_name||
1253: ' Emp No: ' || per.employee_number||
1254: ' Sql Err is '||sqlerrm(sqlcode);
1255: hr_utility.set_location('before creating entry in log file',20);
1256: l_recs_failed := l_recs_failed + 1;
1257: begin
1258: ghr_mto_int.log_message(
1259: p_procedure => g_proc,

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

1491: l_office_symbol,
1492: l_position_organization,
1493: l_pos_grp1_rec);
1494:
1495: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1496: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1497: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1498: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1499: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);

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

1492: l_position_organization,
1493: l_pos_grp1_rec);
1494:
1495: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1496: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1497: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1498: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1499: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1500:

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

1493: l_pos_grp1_rec);
1494:
1495: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1496: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1497: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1498: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1499: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1500:
1501: IF check_eligibility(

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

1494:
1495: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1496: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1497: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1498: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1499: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1500:
1501: IF check_eligibility(
1502: p_org_structure_id,

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

1495: hr_utility.set_location('Vac.POS-l_position_title ' || l_position_title,5);
1496: hr_utility.set_location('Vac.POS-l_personnel_office_id ' || l_personnel_office_id,5);
1497: hr_utility.set_location('Vac.POS-l_org_structure_id ' || l_org_structure_id,5);
1498: hr_utility.set_location('Vac.POS-l_office_symbol ' || l_office_symbol,5);
1499: hr_utility.set_location('Vac.POS-l_sub_element_code ' || l_sub_element_code,5);
1500:
1501: IF check_eligibility(
1502: p_org_structure_id,
1503: p_office_symbol,

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

1516: l_effective_date,
1517: null, ---- person_id
1518: null) then
1519:
1520: hr_utility.set_location('Vac Pos Selected ' || l_position_title,5);
1521: ---AVR end
1522: -- VSM- Bug # 758441
1523: -- Position history not created for Date end and org id
1524: -- Created wrapper procedure update_position_info for

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

1566: interface_flag)
1567: where mass_transfer_id = p_mass_transfer_id;
1568: EXCEPTION
1569: when others then
1570: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1571: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1572: hr_utility.raise_error;
1573: END;
1574: end if;

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

1567: where mass_transfer_id = p_mass_transfer_id;
1568: EXCEPTION
1569: when others then
1570: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1571: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1572: hr_utility.raise_error;
1573: END;
1574: end if;
1575: ELSE

Line 1572: hr_utility.raise_error;

1568: EXCEPTION
1569: when others then
1570: HR_UTILITY.SET_LOCATION('Error in Update ghr_mto Sql error '||sqlerrm(sqlcode),30);
1571: hr_utility.set_message(8301, 'GHR_38571_UPD_GHR_MTO_FAILURE');
1572: hr_utility.raise_error;
1573: END;
1574: end if;
1575: ELSE
1576: -- 4215268

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

1624: update ghr_mass_transfers
1625: set status = 'E'
1626: where mass_transfer_id = p_mass_transfer_id;
1627: END IF;
1628: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1629: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1630: p_retcode := 2;
1631: hr_utility.set_location('before creating entry in log file',10);
1632: --Bug#4183516 Skip this process log entry as one entry is already

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

1627: END IF;
1628: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1629: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1630: p_retcode := 2;
1631: hr_utility.set_location('before creating entry in log file',10);
1632: --Bug#4183516 Skip this process log entry as one entry is already
1633: -- written during DUMP OUT Process at l_recs_failed NOT NULL part .
1634: IF l_mass_errbuf NOT LIKE 'DUMP OUT Failed%' THEN
1635: l_log_text := 'Error in '||l_proc||' '||

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

1649: update ghr_mass_transfers
1650: set status = 'E'
1651: where mass_transfer_id = p_mass_transfer_id;
1652: END IF;
1653: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
1654: l_log_text := 'Error in '||l_proc||
1655: ' For Mass Transfer Name : '||p_mass_transfer_name||
1656: ' Sql Err is '||sqlerrm(sqlcode);
1657: l_recs_failed := l_recs_failed + 1;

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

1656: ' Sql Err is '||sqlerrm(sqlcode);
1657: l_recs_failed := l_recs_failed + 1;
1658: p_errbuf := 'Error in '||l_proc || 'Details in GHR_PROCESS_LOG';
1659: p_retcode := 2;
1660: hr_utility.set_location('before creating entry in log file',30);
1661: begin
1662: ghr_mto_int.log_message(
1663: p_procedure => g_proc,
1664: p_message => l_log_text);

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

1726:
1727: l_proc varchar2(72)
1728: := g_package || '.pop_dtls_from_pa_req';
1729: begin
1730: hr_utility.set_location('Entering ' || l_proc,5);
1731: pr('Entering ' || l_proc,to_char(p_person_id),to_char(p_effective_date));
1732: g_proc := 'pop_dtls_from_pa_req';
1733: for pa_req_rec in ghr_pa_req_cur
1734: loop

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

1766: 'REPORT',
1767: pa_req_rec.EMPLOYEE_ASSIGNMENT_ID);
1768: exit;
1769: END LOOP;
1770: hr_utility.set_location('Exiting ' || l_proc,10);
1771: exception
1772: when mass_error then raise;
1773: when others then
1774: pr('Error in '||l_proc);

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

1771: exception
1772: when mass_error then raise;
1773: when others then
1774: pr('Error in '||l_proc);
1775: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1776: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1777: raise mass_error;
1778: end pop_dtls_from_pa_req;
1779:

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

1793: l_proc varchar2(72) := g_package || '.check_select_flg';
1794: l_sel_flg varchar2(3);
1795: begin
1796: l_sel_flg := p_sel_flg;
1797: hr_utility.set_location('Entering ' || l_proc,5);
1798: g_proc := 'check_select_flg';
1799: get_extra_info_comments(p_position_id,p_effective_date,p_sel_flg,
1800: l_comments,l_mtfr_id);
1801: --p_sel_status := l_sel_status;

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

1832: when mass_error then raise;
1833: when others then
1834: p_sel_flg := l_sel_flg;
1835: pr('Error in '||l_proc);
1836: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1837: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1838: raise mass_error;
1839: end;
1840:

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

1845: procedure purge_old_data (p_mass_transfer_id in number) is
1846: l_proc varchar2(72)
1847: := g_package || '.purge_old_data';
1848: BEGIN
1849: hr_utility.set_location('Entering ' || l_proc,5);
1850: g_proc := 'purge_old_data';
1851: pr('Mass Transfer id is '||to_char(p_mass_transfer_id));
1852: delete from ghr_mass_actions_preview
1853: where mass_action_type = 'TRANSFER'

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

1852: delete from ghr_mass_actions_preview
1853: where mass_action_type = 'TRANSFER'
1854: and session_id = p_mass_transfer_id;
1855: commit;
1856: hr_utility.set_location('Exiting ' || l_proc,10);
1857: exception
1858: when others then
1859: pr('Error in '||l_proc);
1860: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

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

1856: hr_utility.set_location('Exiting ' || l_proc,10);
1857: exception
1858: when others then
1859: pr('Error in '||l_proc);
1860: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1861: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1862: raise mass_error;
1863: END;
1864:

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

1881:
1882: l_proc varchar2(72)
1883: := g_package || '.ins_upd_pos_extra_info';
1884: begin
1885: hr_utility.set_location('Entering ' || l_proc,5);
1886: g_proc := 'ins_upd_pos_extra_info';
1887: if p_effective_date > sysdate then
1888: l_eff_date := sysdate;
1889: else

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

1935: ,P_OBJECT_VERSION_NUMBER => l_object_version_number);
1936: --Bug#4215231 Reset the global variable
1937: ghr_api.g_api_dml := FALSE;
1938: end if;
1939: hr_utility.set_location('Exiting ' || l_proc,10);
1940:
1941: -- There is a trigger on Position extra Info. Whenever updated/created the
1942: -- main position associated with it becomes invalid.
1943: -- We shall call validate_perwsdpo procedure to set the status = VALID.

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

1951: exception
1952: when mass_error then raise;
1953: when others then
1954: pr('Error in '||l_proc);
1955: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1956: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1957: raise mass_error;
1958: end ins_upd_pos_extra_info;
1959:

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

1969: l_eff_date date;
1970: l_proc varchar2(72)
1971: := g_package || '.update_sel_flg';
1972: begin
1973: hr_utility.set_location('Entering ' || l_proc,5);
1974: g_proc := 'update_sel_flg';
1975:
1976: if p_effective_date > sysdate then
1977: l_eff_date := sysdate;

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

2006: -- ghr_validate_perwsdpo.validate_perwsdpo(p_position_id);
2007: -- ghr_validate_perwsdpo.update_posn_status(p_position_id);
2008:
2009: end if;
2010: hr_utility.set_location('Exiting ' || l_proc,10);
2011: exception
2012: when mass_error then raise;
2013: when others then
2014: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);

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

2010: hr_utility.set_location('Exiting ' || l_proc,10);
2011: exception
2012: when mass_error then raise;
2013: when others then
2014: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2015: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2016: raise mass_error;
2017: end update_sel_flg;
2018:

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

2053: l_occ_code varchar2(30) := null;
2054: l_proc varchar2(72)
2055: := g_package || '.check_eligibility';
2056: BEGIN
2057: hr_utility.set_location('Entering ' || l_proc,5);
2058: g_proc := 'check_eligibility';
2059:
2060: if p_org_structure_id is not null then
2061: if p_org_structure_id <> nvl(p_l_org_structure_id,'NULL!~') then

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

2141: exception
2142: when mass_error then raise;
2143: when others then
2144: pr('Error in '||l_proc);
2145: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2146: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2147: raise mass_error;
2148: END check_eligibility;
2149:

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

2177: l_office_symbol := p_office_symbol;
2178: l_position_organization := p_position_organization;
2179: l_pos_ei_data := p_pos_ei_data;
2180:
2181: hr_utility.set_location('Entering ' || l_proc,5);
2182: g_proc := 'get_pos_grp1_ddf';
2183: ghr_history_fetch.fetch_positionei
2184: (p_position_id => p_position_id
2185: ,p_information_type => 'GHR_US_POS_GRP1'

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

2197: p_office_symbol := l_office_symbol;
2198: p_org_structure_id := l_org_structure_id;
2199: p_position_organization := l_position_organization;
2200:
2201: hr_utility.set_location('Exiting ' || l_proc,10);
2202: exception
2203: when mass_error then raise;
2204: when others then
2205: -- NOCOPY Changes

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

2209: p_org_structure_id := NULL;
2210: p_position_organization := NULL;
2211: -- NOCOPY changes end
2212: pr('Error in '||l_proc);
2213: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2214: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2215: raise mass_error;
2216: END get_pos_grp1_ddf;
2217:

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

2241: l_appropriation_code1 := p_appropriation_code1;
2242: l_appropriation_code2 := p_appropriation_code2;
2243: l_pos_ei_data := p_pos_ei_data;
2244:
2245: hr_utility.set_location('Entering ' || l_proc,5);
2246: g_proc := 'get_pos_grp2_ddf';
2247: ghr_history_fetch.fetch_positionei
2248: (p_position_id => p_position_id
2249: ,p_information_type => 'GHR_US_POS_GRP2'

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

2260: p_appropriation_code1 := l_appropriation_code1;
2261: p_appropriation_code2 := l_appropriation_code2;
2262: --- NOCOPY changes
2263:
2264: hr_utility.set_location('Exiting ' || l_proc,10);
2265: exception
2266: when mass_error then raise;
2267: when others then
2268: ---NOCOPY Changes

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

2272: p_appropriation_code2 := NULL;
2273: ---NOCOPY Changes END
2274:
2275: pr('Error in '||l_proc);
2276: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2277: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2278: raise mass_error;
2279: END get_pos_grp2_ddf;
2280:

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

2303: l_sel_flag := p_sel_flag;
2304: l_comments := p_comments;
2305: l_mtfr_id := p_mtfr_id;
2306: -- NOCOPY Changes
2307: hr_utility.set_location('Entering ' || l_proc,5);
2308:
2309: l_eff_date := p_effective_date;
2310: ghr_history_fetch.fetch_positionei
2311: (p_position_id => p_position_id

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

2330: p_sel_flag := l_sel_flag;
2331: p_comments := l_comments;
2332: p_mtfr_id := l_mtfr_id;
2333: pr('Error in '||l_proc);
2334: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2335: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2336: raise mass_error;
2337: end;
2338:

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

2408: l_step_or_rate varchar2(30);
2409: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2410:
2411: begin
2412: hr_utility.set_location('Entering ' || l_proc,5);
2413: g_proc := 'create_mass_act_prev';
2414:
2415: pr('Inside ghr_cpdf_temp insert Transfer id ',to_char(p_mass_transfer_id),null);
2416: pr('t_pos_org is',t_position_organization);

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

2474: p_cust_rec => l_cust_rec);
2475:
2476: exception
2477: when others then
2478: hr_utility.set_location('Error in Mass Act Custom '||
2479: 'Err is '||sqlerrm(sqlcode),20);
2480: l_mass_errbuf := 'Error in Mass Act Custom '||
2481: 'Err is '|| sqlerrm(sqlcode);
2482: raise mass_error;

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

2658: l_cust_rec.user_attribute19,
2659: l_cust_rec.user_attribute20
2660: );
2661:
2662: hr_utility.set_location('Exiting ' || l_proc,10);
2663: exception
2664: when mass_error then raise;
2665: when others then
2666: pr('Error in '||l_proc);

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

2664: when mass_error then raise;
2665: when others then
2666: pr('Error in '||l_proc);
2667: pr('Position title is '||p_position_title||' Length is '||to_char(length(p_position_title)));
2668: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2669: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2670: raise mass_error;
2671: end create_mass_act_prev;
2672:

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

2683:
2684: l_mto_name varchar2(150);
2685: l_proc varchar2(72) := g_package || '.get_mre_name';
2686: begin
2687: hr_utility.set_location('Entering ' || l_proc,5);
2688: g_proc := 'get_mto_name';
2689: FOR mto_REC IN mto_cur
2690: LOOP
2691: l_mto_name := mto_rec.name;

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

2738: begin
2739:
2740: l_sf52_rec := p_sf52_rec;
2741:
2742: hr_utility.set_location('Entering ' || l_proc,5);
2743: g_proc := 'assign_to_sf52_rec';
2744:
2745: l_sf52_rec.person_id := p_person_id;
2746: l_sf52_rec.employee_first_name := p_first_name;

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

2785: l_sf52_rec.FIRST_ACTION_LA_CODE2 := p_lac_sf52_rec.FIRST_ACTION_LA_CODE2;
2786: l_sf52_rec.FIRST_ACTION_LA_DESC1 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC1;
2787: l_sf52_rec.FIRST_ACTION_LA_DESC2 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC2;
2788:
2789: hr_utility.set_location('Exiting ' || l_proc,10);
2790:
2791: p_sf52_rec := l_sf52_rec;
2792:
2793: exception

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

2796: --NOCOPY changes
2797: p_sf52_rec := l_sf52_rec;
2798: -- NOCOPY Changes
2799: pr('Error in '||l_proc);
2800: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2801: l_mass_errbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2802: raise mass_error;
2803: end assign_to_sf52_rec;
2804:

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

2865: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2866: l_eff_date date;
2867: l_agency_code varchar2(5);
2868: begin
2869: hr_utility.set_location('Entering ' || l_proc,5);
2870:
2871: -- NOCOPY changes
2872: l_agency_code := p_agency_code;
2873: -- NOCOPY changes

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

2890:
2891: -- NOCOPY changes
2892: p_agency_code := l_agency_code;
2893: -- NOCOPY changes
2894: hr_utility.set_location('Agency Code ' || p_agency_code,10);
2895: hr_utility.set_location('Leaving ' || l_proc,15);
2896: end;
2897:
2898: PROCEDURE upd_ext_info_api (p_person_id in number,

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

2891: -- NOCOPY changes
2892: p_agency_code := l_agency_code;
2893: -- NOCOPY changes
2894: hr_utility.set_location('Agency Code ' || p_agency_code,10);
2895: hr_utility.set_location('Leaving ' || l_proc,15);
2896: end;
2897:
2898: PROCEDURE upd_ext_info_api (p_person_id in number,
2899: p_agency_code in varchar2,

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

2917: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2918: l_eff_date date;
2919:
2920: BEGIN
2921: hr_utility.set_location('Entering ' || l_proc,5);
2922: g_proc := 'upd_ext_info_api';
2923: if p_effective_date > sysdate then
2924: l_eff_date := sysdate;
2925: else

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

2993: -- DBMS_OUTPUT.PUT_LINE(msg||'-'||par1||' -'||par2||'-');
2994: exception
2995: when others then
2996: pr('Error in '||'pr');
2997: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
2998: l_mass_errbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);
2999: raise mass_error;
3000: end;
3001:

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

3002: Procedure update_position_info
3003: (p_position_data_rec in ghr_sf52_pos_update.position_data_rec_type) is
3004: l_proc varchar2(30):='update_position_info';
3005: Begin
3006: hr_utility.set_location('Entering ' || l_proc, 10);
3007: g_proc := 'update_position_info';
3008: ghr_session.set_session_var_for_core( p_position_data_rec.effective_end_date );
3009: ghr_sf52_pos_update.update_position_info
3010: ( p_pos_data_rec => p_position_data_rec);

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

3007: g_proc := 'update_position_info';
3008: ghr_session.set_session_var_for_core( p_position_data_rec.effective_end_date );
3009: ghr_sf52_pos_update.update_position_info
3010: ( p_pos_data_rec => p_position_data_rec);
3011: hr_utility.set_location('Calling Pust_update_process ' || l_proc, 50);
3012: g_proc := 'post_update_process';
3013: ghr_history_api.post_update_process;
3014: hr_utility.set_location('Leaving ' || l_proc, 100);
3015:

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

3010: ( p_pos_data_rec => p_position_data_rec);
3011: hr_utility.set_location('Calling Pust_update_process ' || l_proc, 50);
3012: g_proc := 'post_update_process';
3013: ghr_history_api.post_update_process;
3014: hr_utility.set_location('Leaving ' || l_proc, 100);
3015:
3016: end;
3017:
3018: Procedure upd_per_extra_info_to_null(p_person_id in number) is