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.

[Home] [Help]

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 838: hr_utility.set_message(8301, 'GHR_38548_UNIQUE_CONSTRAINT');

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

Line 839: hr_utility.raise_error;

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

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

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

Line 1356: hr_utility.raise_error;

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

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

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

Line 1581: hr_utility.raise_error;

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

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

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

Line 1747: hr_utility.raise_error;

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

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

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

Line 1836: hr_utility.raise_error;

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

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

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

Line 2078: hr_utility.raise_error;

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

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

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

Line 2233: hr_utility.raise_error;

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

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

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

Line 2638: hr_utility.raise_error;

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

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

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

Line 2804: hr_utility.raise_error;

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

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

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

Line 2920: hr_utility.raise_error;

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

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

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

Line 3348: hr_utility.raise_error;

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

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

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

Line 3591: hr_utility.raise_error;

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

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

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

Line 3867: hr_utility.raise_error;

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

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

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

Line 3960: hr_utility.raise_error;

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

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

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

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

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

Line 4144: hr_utility.raise_error;

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

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

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

Line 4165: hr_utility.raise_error;

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

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

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

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

4435: 'for Employee: '|| l_people_row.full_name ||
4436: ' SSN: '|| l_people_row.national_identifier ||
4437: 'person_id:'|| p_person_id);
4438:
4439: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4440: hr_utility.raise_error;
4441: end if;
4442: close cur_assignments_f;
4443:

Line 4440: hr_utility.raise_error;

4436: ' SSN: '|| l_people_row.national_identifier ||
4437: 'person_id:'|| p_person_id);
4438:
4439: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4440: hr_utility.raise_error;
4441: end if;
4442: close cur_assignments_f;
4443:
4444: ghr_history_fetch.fetch_assignment (

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

4455: 'Could not get assignment data '||
4456: 'for Employee: '|| l_people_row.full_name ||
4457: ' SSN: '|| l_people_row.national_identifier ||
4458: 'person_id:'|| p_person_id);
4459: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4460: hr_utility.raise_error;
4461: end if;
4462:
4463: insert_assignment_f(p_transfer_name => l_transfer_name,

Line 4460: hr_utility.raise_error;

4456: 'for Employee: '|| l_people_row.full_name ||
4457: ' SSN: '|| l_people_row.national_identifier ||
4458: 'person_id:'|| p_person_id);
4459: hr_utility.set_message(8301, 'GHR_38537_MTO_NO_ASG');
4460: hr_utility.raise_error;
4461: end if;
4462:
4463: insert_assignment_f(p_transfer_name => l_transfer_name,
4464: p_effective_date => l_effdate,

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

4939: p_effective_date => l_effdate,
4940: p_value => l_misc.from_agency_code);
4941: */
4942:
4943: hr_utility.set_location('Leaving:'||l_proc, 60);
4944: -- Bug#4183516 Modified the Message Text.
4945: log_message(
4946: p_procedure => l_proc_name,
4947: p_message => 'Interface table updated Successfully for ' || l_people_row.full_name ||