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

Line 7: g_message varchar2(128); -- 128 max for hr_utility.set_location

3:
4: g_datefmt constant varchar2(12) := 'DD-MON-YYYY';
5: g_name constant varchar2(12) := 'GHR_MTO_INT';
6: g_log_name varchar2(30);
7: g_message varchar2(128); -- 128 max for hr_utility.set_location
8:
9: -- Created g_new_line to use instead of CHR(10)
10: g_new_line varchar2(1) := substr('
11: ',1,1);

Line 14: -- Directs logging messages to hr_utility.set_location unless the global

10: g_new_line varchar2(1) := substr('
11: ',1,1);
12:
13: --
14: -- Directs logging messages to hr_utility.set_location unless the global
15: -- variable, g_dbms_output, is TRUE, then output goes to dbms_output
16: --
17: -- g_dbms_output is FALSE by default
18: --

Line 26: hr_utility.set_location(substr(g_message||p_message,128),33);

22: if g_dbms_output = TRUE then
23: null;
24: --dbms_output.put_line(g_message||p_message);
25: else
26: hr_utility.set_location(substr(g_message||p_message,128),33);
27: end if;
28:
29: g_message := null;
30:

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

99: select to_char(ghr_process_log_s.nextval)
100: from sys.dual;
101:
102: begin
103: hr_utility.set_location('Entering:'||l_proc, 10);
104:
105: l_prog_name := Fnd_profile.value('CONC_REQUEST_ID');
106:
107: hr_utility.set_location('l_prog_name conc_request_id :' || l_prog_name ,11);

Line 107: hr_utility.set_location('l_prog_name conc_request_id :' || l_prog_name ,11);

103: hr_utility.set_location('Entering:'||l_proc, 10);
104:
105: l_prog_name := Fnd_profile.value('CONC_REQUEST_ID');
106:
107: hr_utility.set_location('l_prog_name conc_request_id :' || l_prog_name ,11);
108: if l_prog_name = '-1' then
109: l_prog_name := NULL;
110: end if;
111:

Line 116: hr_utility.set_location('l_prog_name in if condn :' || l_prog_name ,12);

112: if l_prog_name is null then -- we're not called by concurrent mgr
113: open cur_get_seq;
114: fetch cur_get_seq into l_prog_name;
115: close cur_get_seq;
116: hr_utility.set_location('l_prog_name in if condn :' || l_prog_name ,12);
117: end if;
118:
119:
120: l_id_len := length(l_prog_name);

Line 132: hr_utility.set_location('l_prog_name Final :' || l_prog_name ,13);

128: end if;
129:
130: put_line('Log Program Name: '|| l_prog_name);
131:
132: hr_utility.set_location('l_prog_name Final :' || l_prog_name ,13);
133:
134: g_log_name := l_prog_name;
135:
136: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 136: hr_utility.set_location('Leaving:'||l_proc, 20);

132: hr_utility.set_location('l_prog_name Final :' || l_prog_name ,13);
133:
134: g_log_name := l_prog_name;
135:
136: hr_utility.set_location('Leaving:'||l_proc, 20);
137:
138: end;
139:
140: procedure log_message(p_procedure varchar2, p_message varchar2)

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

142:
143: l_proc varchar2(72) := g_package||'log_message';
144:
145: begin
146: hr_utility.set_location('Entering:'||l_proc, 10);
147:
148: if g_log_enabled = FALSE then
149: return;
150: end if;

Line 154: hr_utility.set_message(8301, 'GHR_38546_LOG_NAME_NOT_SET');

150: end if;
151:
152: -- call set_log_program_name to set g_log_name before first call
153: if g_log_name is null then
154: hr_utility.set_message(8301, 'GHR_38546_LOG_NAME_NOT_SET');
155: hr_utility.raise_error;
156: end if;
157:
158: -- p_procedure must contain 30 or fewer characters

Line 155: hr_utility.raise_error;

151:
152: -- call set_log_program_name to set g_log_name before first call
153: if g_log_name is null then
154: hr_utility.set_message(8301, 'GHR_38546_LOG_NAME_NOT_SET');
155: hr_utility.raise_error;
156: end if;
157:
158: -- p_procedure must contain 30 or fewer characters
159: if length(p_procedure) > 30 then

Line 160: hr_utility.set_message(8301, 'GHR_38547_NAME_TOO_LONG');

156: end if;
157:
158: -- p_procedure must contain 30 or fewer characters
159: if length(p_procedure) > 30 then
160: hr_utility.set_message(8301, 'GHR_38547_NAME_TOO_LONG');
161: hr_utility.raise_error;
162: end if;
163: hr_utility.set_location('g_log_name :'||g_log_name, 11);
164: hr_utility.set_location('p_procedure :'||p_procedure, 11);

Line 161: hr_utility.raise_error;

157:
158: -- p_procedure must contain 30 or fewer characters
159: if length(p_procedure) > 30 then
160: hr_utility.set_message(8301, 'GHR_38547_NAME_TOO_LONG');
161: hr_utility.raise_error;
162: end if;
163: hr_utility.set_location('g_log_name :'||g_log_name, 11);
164: hr_utility.set_location('p_procedure :'||p_procedure, 11);
165:

Line 163: hr_utility.set_location('g_log_name :'||g_log_name, 11);

159: if length(p_procedure) > 30 then
160: hr_utility.set_message(8301, 'GHR_38547_NAME_TOO_LONG');
161: hr_utility.raise_error;
162: end if;
163: hr_utility.set_location('g_log_name :'||g_log_name, 11);
164: hr_utility.set_location('p_procedure :'||p_procedure, 11);
165:
166: ghr_wgi_pkg.create_ghr_errorlog(
167: p_program_name => g_log_name,

Line 164: hr_utility.set_location('p_procedure :'||p_procedure, 11);

160: hr_utility.set_message(8301, 'GHR_38547_NAME_TOO_LONG');
161: hr_utility.raise_error;
162: end if;
163: hr_utility.set_location('g_log_name :'||g_log_name, 11);
164: hr_utility.set_location('p_procedure :'||p_procedure, 11);
165:
166: ghr_wgi_pkg.create_ghr_errorlog(
167: p_program_name => g_log_name,
168: p_message_name => p_procedure,

Line 173: hr_utility.set_location('Leaving:'||l_proc, 10);

169: p_log_text => p_message,
170: p_log_date => sysdate
171: );
172:
173: hr_utility.set_location('Leaving:'||l_proc, 10);
174: exception
175: when others then
176: put_line(l_proc||' - raised exception');
177: raise;

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

281: l_proc varchar2(72) := g_package||'update_agency_transfer_from';
282:
283: begin
284:
285: hr_utility.set_location('Entering:'||l_proc, 10);
286:
287: open cur_pei_id;
288: fetch cur_pei_id into l_person_extra_info_id, l_object_version_number;
289:

Line 319: hr_utility.set_location('Leaving:'||l_proc, 10);

315: -- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
316: -- ghr_validate_perwsepi.update_person_user_type(p_person_id);
317:
318: close cur_pei_id;
319: hr_utility.set_location('Leaving:'||l_proc, 10);
320:
321: exception
322: when others then
323: put_line(l_proc||' - raised exception');

Line 367: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

363: p_transfer_name => p_transfer_name
364: ,p_person_id => ppf.person_id
365: ,p_table_name => l_table_name) then
366:
367: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
368: hr_utility.raise_error;
369: end if;
370: else
371: put_line(' - called locally');

Line 368: hr_utility.raise_error;

364: ,p_person_id => ppf.person_id
365: ,p_table_name => l_table_name) then
366:
367: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
368: hr_utility.raise_error;
369: end if;
370: else
371: put_line(' - called locally');
372: end if;

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

592: fetch cur_get_person into l_x;
593:
594: if cur_get_person%notfound then
595: close cur_get_person;
596: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
597: hr_utility.raise_error;
598: end if;
599:
600: update ghr_mt_people_f_v

Line 597: hr_utility.raise_error;

593:
594: if cur_get_person%notfound then
595: close cur_get_person;
596: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
597: hr_utility.raise_error;
598: end if;
599:
600: update ghr_mt_people_f_v
601: set

Line 839: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

835: ,p_person_id => pp_ei.person_id
836: ,p_table_name => l_table_name
837: ,p_info_type => pp_ei.information_type) then
838:
839: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
840: hr_utility.raise_error;
841: end if;
842: else
843: put_line('Called locally');

Line 840: hr_utility.raise_error;

836: ,p_table_name => l_table_name
837: ,p_info_type => pp_ei.information_type) then
838:
839: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
840: hr_utility.raise_error;
841: end if;
842: else
843: put_line('Called locally');
844: end if;

Line 1356: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

1352: ,p_person_id => p_person_id
1353: ,p_table_name => l_table_name
1354: ,p_info_type => p_flex_name) then
1355:
1356: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1357: hr_utility.raise_error;
1358: end if;
1359: else
1360: put_line('Called locally');

Line 1357: hr_utility.raise_error;

1353: ,p_table_name => l_table_name
1354: ,p_info_type => p_flex_name) then
1355:
1356: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1357: hr_utility.raise_error;
1358: end if;
1359: else
1360: put_line('Called locally');
1361: end if;

Line 1581: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

1577: ,p_person_id => p_a.person_id
1578: ,p_table_name => l_table_name
1579: ,p_contact_name => p_contact_name) then
1580:
1581: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1582: hr_utility.raise_error;
1583: end if;
1584: else
1585: put_line(' - called locally');

Line 1582: hr_utility.raise_error;

1578: ,p_table_name => l_table_name
1579: ,p_contact_name => p_contact_name) then
1580:
1581: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1582: hr_utility.raise_error;
1583: end if;
1584: else
1585: put_line(' - called locally');
1586: end if;

Line 1747: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');

1743: fetch cur_address into l_x;
1744:
1745: if cur_address%notfound then
1746: close cur_address;
1747: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
1748: hr_utility.raise_error;
1749: end if;
1750:
1751: update ghr_mt_addresses_v

Line 1748: hr_utility.raise_error;

1744:
1745: if cur_address%notfound then
1746: close cur_address;
1747: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
1748: hr_utility.raise_error;
1749: end if;
1750:
1751: update ghr_mt_addresses_v
1752: set

Line 1836: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

1832: p_transfer_name => p_transfer_name
1833: ,p_person_id => p_a.person_id
1834: ,p_table_name => l_table_name) then
1835:
1836: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1837: hr_utility.raise_error;
1838: end if;
1839: else
1840: put_line(' - called locally');

Line 1837: hr_utility.raise_error;

1833: ,p_person_id => p_a.person_id
1834: ,p_table_name => l_table_name) then
1835:
1836: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
1837: hr_utility.raise_error;
1838: end if;
1839: else
1840: put_line(' - called locally');
1841: end if;

Line 2078: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');

2074: fetch cur_assignment into l_x;
2075:
2076: if cur_assignment%notfound then
2077: close cur_assignment;
2078: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2079: hr_utility.raise_error;
2080: end if;
2081:
2082: update ghr_mt_assignments_f_v

Line 2079: hr_utility.raise_error;

2075:
2076: if cur_assignment%notfound then
2077: close cur_assignment;
2078: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2079: hr_utility.raise_error;
2080: end if;
2081:
2082: update ghr_mt_assignments_f_v
2083: set

Line 2233: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

2229: ,p_person_id => p_person_id
2230: ,p_table_name => l_table_name
2231: ,p_info_type => p_a_ei.information_type) then
2232:
2233: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2234: hr_utility.raise_error;
2235: end if;
2236: else
2237: put_line('Called locally');

Line 2234: hr_utility.raise_error;

2230: ,p_table_name => l_table_name
2231: ,p_info_type => p_a_ei.information_type) then
2232:
2233: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2234: hr_utility.raise_error;
2235: end if;
2236: else
2237: put_line('Called locally');
2238: end if;

Line 2638: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

2634: p_transfer_name => p_transfer_name
2635: ,p_person_id => p_person_id
2636: ,p_table_name => l_table_name) then
2637:
2638: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2639: hr_utility.raise_error;
2640: end if;
2641: else
2642: put_line(' - called locally');

Line 2639: hr_utility.raise_error;

2635: ,p_person_id => p_person_id
2636: ,p_table_name => l_table_name) then
2637:
2638: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2639: hr_utility.raise_error;
2640: end if;
2641: else
2642: put_line(' - called locally');
2643: end if;

Line 2804: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');

2800: fetch cur_position into l_x;
2801:
2802: if cur_position%notfound then
2803: close cur_position;
2804: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2805: hr_utility.raise_error;
2806: end if;
2807:
2808: update ghr_mt_positions_v

Line 2805: hr_utility.raise_error;

2801:
2802: if cur_position%notfound then
2803: close cur_position;
2804: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2805: hr_utility.raise_error;
2806: end if;
2807:
2808: update ghr_mt_positions_v
2809: set

Line 2920: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

2916: ,p_person_id => p_person_id
2917: ,p_table_name => l_table_name
2918: ,p_info_type => p_pos_ei.information_type) then
2919:
2920: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2921: hr_utility.raise_error;
2922: end if;
2923: else
2924: put_line('Called locally');

Line 2921: hr_utility.raise_error;

2917: ,p_table_name => l_table_name
2918: ,p_info_type => p_pos_ei.information_type) then
2919:
2920: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
2921: hr_utility.raise_error;
2922: end if;
2923: else
2924: put_line('Called locally');
2925: end if;

Line 3348: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

3344: ,p_person_id => p_person_id
3345: ,p_table_name => l_table_name
3346: ,p_info_type => p_flex_name) then
3347:
3348: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3349: hr_utility.raise_error;
3350: end if;
3351: else
3352: put_line('Called locally');

Line 3349: hr_utility.raise_error;

3345: ,p_table_name => l_table_name
3346: ,p_info_type => p_flex_name) then
3347:
3348: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3349: hr_utility.raise_error;
3350: end if;
3351: else
3352: put_line('Called locally');
3353: end if;

Line 3591: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

3587: p_transfer_name => p_transfer_name
3588: ,p_person_id => p_person_id
3589: ,p_table_name => l_table_name) then
3590:
3591: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3592: hr_utility.raise_error;
3593: end if;
3594: else
3595: put_line(' - called locally');

Line 3592: hr_utility.raise_error;

3588: ,p_person_id => p_person_id
3589: ,p_table_name => l_table_name) then
3590:
3591: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3592: hr_utility.raise_error;
3593: end if;
3594: else
3595: put_line(' - called locally');
3596: end if;

Line 3867: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

3863: p_transfer_name => p_transfer_name
3864: ,p_person_id => p_person_id
3865: ,p_table_name => l_table_name) then
3866:
3867: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3868: hr_utility.raise_error;
3869: end if;
3870: else
3871: put_line(' - called locally');

Line 3868: hr_utility.raise_error;

3864: ,p_person_id => p_person_id
3865: ,p_table_name => l_table_name) then
3866:
3867: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');
3868: hr_utility.raise_error;
3869: end if;
3870: else
3871: put_line(' - called locally');
3872: end if;

Line 3960: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');

3956: fetch cur_misc into l_x;
3957:
3958: if cur_misc%notfound then
3959: close cur_misc;
3960: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
3961: hr_utility.raise_error;
3962: end if;
3963:
3964: l_from_agency_code_desc := get_code_meaning (

Line 3961: hr_utility.raise_error;

3957:
3958: if cur_misc%notfound then
3959: close cur_misc;
3960: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
3961: hr_utility.raise_error;
3962: end if;
3963:
3964: l_from_agency_code_desc := get_code_meaning (
3965: p_lookup_type => 'GHR_US_AGENCY_CODE',

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

4123: AND grd.grade_definition_id = gdf.grade_definition_id;
4124:
4125: begin
4126:
4127: hr_utility.set_location('Entering:'||l_proc, 10);
4128: put_line(l_proc||' transfer_id: '||p_transfer_id ||
4129: ', person_id: '||p_person_id);
4130:
4131: get_transfer_parameters(p_transfer_id,

Line 4144: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');

4140: p_message => 'Failed to get Transfer Out information from'||
4141: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||
4142: p_transfer_id);
4143: commit;
4144: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');
4145: hr_utility.raise_error;
4146:
4147: end if;
4148:

Line 4145: hr_utility.raise_error;

4141: 'GHR_MASS_TRANSFERS for mass_transfer_id:'||
4142: p_transfer_id);
4143: commit;
4144: hr_utility.set_message(8301, 'GHR_38534_MT_ID_ERR');
4145: hr_utility.raise_error;
4146:
4147: end if;
4148:
4149: ghr_history_fetch.fetch_people (

Line 4165: hr_utility.set_message(8301, 'GHR_38536_MTO_NO_PERSON');

4161: 'Could not query data from PER_PEOPLE_F for person_id:'||
4162: p_person_id);
4163:
4164: commit;
4165: hr_utility.set_message(8301, 'GHR_38536_MTO_NO_PERSON');
4166: hr_utility.raise_error;
4167: end if;
4168:
4169: -- if person and p_transfer_name exits in the interface table

Line 4166: hr_utility.raise_error;

4162: p_person_id);
4163:
4164: commit;
4165: hr_utility.set_message(8301, 'GHR_38536_MTO_NO_PERSON');
4166: hr_utility.raise_error;
4167: end if;
4168:
4169: -- if person and p_transfer_name exits in the interface table
4170: -- refresh the information by deleting the current data before

Line 4193: hr_utility.set_location('Gathering Data:'||l_proc, 20);

4189: p_inter_bg_transfer => l_inter_bg_transfer,
4190: p_effective_date => l_effdate,
4191: ppf => l_people_row);
4192:
4193: hr_utility.set_location('Gathering Data:'||l_proc, 20);
4194:
4195: -- procedure insert_people_ei tests if informaton_type is null and
4196: -- if it is the row in not inserted into the interface table
4197:

Line 4441: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');

4437: 'for Employee: '|| l_people_row.full_name ||
4438: ' Emp No: '|| l_people_row.employee_number ||
4439: 'person_id:'|| p_person_id);
4440:
4441: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4442: hr_utility.raise_error;
4443: end if;
4444: close cur_assignments_f;
4445:

Line 4442: hr_utility.raise_error;

4438: ' Emp No: '|| l_people_row.employee_number ||
4439: 'person_id:'|| p_person_id);
4440:
4441: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4442: hr_utility.raise_error;
4443: end if;
4444: close cur_assignments_f;
4445:
4446: ghr_history_fetch.fetch_assignment (

Line 4462: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');

4458: 'Could not get assignment data '||
4459: 'for Employee: '|| l_people_row.full_name ||
4460: ' Emp No: '|| l_people_row.employee_number ||
4461: 'person_id:'|| p_person_id);
4462: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4463: hr_utility.raise_error;
4464: end if;
4465:
4466: insert_assignment_f(p_transfer_name => l_transfer_name,

Line 4463: hr_utility.raise_error;

4459: 'for Employee: '|| l_people_row.full_name ||
4460: ' Emp No: '|| l_people_row.employee_number ||
4461: 'person_id:'|| p_person_id);
4462: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4463: hr_utility.raise_error;
4464: end if;
4465:
4466: insert_assignment_f(p_transfer_name => l_transfer_name,
4467: p_effective_date => l_effdate,

Line 4946: hr_utility.set_location('Leaving:'||l_proc, 60);

4942: p_effective_date => l_effdate,
4943: p_value => l_misc.from_agency_code);
4944: */
4945:
4946: hr_utility.set_location('Leaving:'||l_proc, 60);
4947: -- Bug#4183516 Modified the Message Text.
4948: --Bug # 9329643 Modified SSN to Emp No
4949: log_message(
4950: p_procedure => l_proc_name,