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.PER_RU_PREVIOUS_EMPLOYER dependencies on HR_UTILITY

Line 44: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

40: BEGIN
41: --
42: -- Added for GSI Bug 5472781
43: --
44: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
45: --
46: --IF P_PEM_INFORMATION_CATEGORY='RU' THEN
47: OPEN c_prev_employer_list;
48: FETCH c_prev_employer_list INTO v_dummy;

Line 50: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

46: --IF P_PEM_INFORMATION_CATEGORY='RU' THEN
47: OPEN c_prev_employer_list;
48: FETCH c_prev_employer_list INTO v_dummy;
49: IF c_prev_employer_list%FOUND THEN
50: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
51: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
52: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
53: hr_utility.raise_error;
54: END IF;

Line 51: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

47: OPEN c_prev_employer_list;
48: FETCH c_prev_employer_list INTO v_dummy;
49: IF c_prev_employer_list%FOUND THEN
50: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
51: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
52: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
53: hr_utility.raise_error;
54: END IF;
55: CLOSE c_prev_employer_list;

Line 52: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

48: FETCH c_prev_employer_list INTO v_dummy;
49: IF c_prev_employer_list%FOUND THEN
50: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
51: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
52: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
53: hr_utility.raise_error;
54: END IF;
55: CLOSE c_prev_employer_list;
56:

Line 53: hr_utility.raise_error;

49: IF c_prev_employer_list%FOUND THEN
50: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
51: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
52: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
53: hr_utility.raise_error;
54: END IF;
55: CLOSE c_prev_employer_list;
56:
57: OPEN c_prev_job_list;

Line 60: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

56:
57: OPEN c_prev_job_list;
58: FETCH c_prev_job_list INTO v_dummy;
59: IF c_prev_job_list%FOUND THEN
60: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
61: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
62: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
63: hr_utility.raise_error;
64: END IF;

Line 61: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

57: OPEN c_prev_job_list;
58: FETCH c_prev_job_list INTO v_dummy;
59: IF c_prev_job_list%FOUND THEN
60: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
61: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
62: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
63: hr_utility.raise_error;
64: END IF;
65: CLOSE c_prev_job_list;

Line 62: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

58: FETCH c_prev_job_list INTO v_dummy;
59: IF c_prev_job_list%FOUND THEN
60: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
61: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
62: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
63: hr_utility.raise_error;
64: END IF;
65: CLOSE c_prev_job_list;
66:

Line 63: hr_utility.raise_error;

59: IF c_prev_job_list%FOUND THEN
60: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
61: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
62: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
63: hr_utility.raise_error;
64: END IF;
65: CLOSE c_prev_job_list;
66:
67: OPEN c_current_employer;

Line 70: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

66:
67: OPEN c_current_employer;
68: FETCH c_current_employer INTO v_dummy;
69: IF c_current_employer%FOUND THEN
70: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
71: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
72: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
73: hr_utility.raise_error;
74: END IF;

Line 71: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

67: OPEN c_current_employer;
68: FETCH c_current_employer INTO v_dummy;
69: IF c_current_employer%FOUND THEN
70: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
71: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
72: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
73: hr_utility.raise_error;
74: END IF;
75: CLOSE c_current_employer;

Line 72: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

68: FETCH c_current_employer INTO v_dummy;
69: IF c_current_employer%FOUND THEN
70: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
71: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
72: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
73: hr_utility.raise_error;
74: END IF;
75: CLOSE c_current_employer;
76:

Line 73: hr_utility.raise_error;

69: IF c_current_employer%FOUND THEN
70: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
71: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
72: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
73: hr_utility.raise_error;
74: END IF;
75: CLOSE c_current_employer;
76:
77: END IF;

Line 119: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

115: BEGIN
116: --
117: -- Added for GSI Bug 5472781
118: --
119: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
120: --
121: OPEN c_prev_employer_details;
122: FETCH c_prev_employer_details INTO v_dummy;
123: IF c_prev_employer_details%FOUND THEN

Line 124: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

120: --
121: OPEN c_prev_employer_details;
122: FETCH c_prev_employer_details INTO v_dummy;
123: IF c_prev_employer_details%FOUND THEN
124: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
125: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
126: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
127: hr_utility.raise_error;
128: END IF;

Line 125: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

121: OPEN c_prev_employer_details;
122: FETCH c_prev_employer_details INTO v_dummy;
123: IF c_prev_employer_details%FOUND THEN
124: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
125: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
126: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
127: hr_utility.raise_error;
128: END IF;
129: CLOSE c_prev_employer_details;

Line 126: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

122: FETCH c_prev_employer_details INTO v_dummy;
123: IF c_prev_employer_details%FOUND THEN
124: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
125: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
126: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
127: hr_utility.raise_error;
128: END IF;
129: CLOSE c_prev_employer_details;
130:

Line 127: hr_utility.raise_error;

123: IF c_prev_employer_details%FOUND THEN
124: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
125: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
126: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
127: hr_utility.raise_error;
128: END IF;
129: CLOSE c_prev_employer_details;
130:
131: OPEN c_prev_job_details;

Line 134: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

130:
131: OPEN c_prev_job_details;
132: FETCH c_prev_job_details INTO v_dummy;
133: IF c_prev_job_details%FOUND THEN
134: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
135: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
136: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
137: hr_utility.raise_error;
138: END IF;

Line 135: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

131: OPEN c_prev_job_details;
132: FETCH c_prev_job_details INTO v_dummy;
133: IF c_prev_job_details%FOUND THEN
134: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
135: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
136: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
137: hr_utility.raise_error;
138: END IF;
139: CLOSE c_prev_job_details;

Line 136: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

132: FETCH c_prev_job_details INTO v_dummy;
133: IF c_prev_job_details%FOUND THEN
134: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
135: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
136: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
137: hr_utility.raise_error;
138: END IF;
139: CLOSE c_prev_job_details;
140:

Line 137: hr_utility.raise_error;

133: IF c_prev_job_details%FOUND THEN
134: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
135: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
136: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
137: hr_utility.raise_error;
138: END IF;
139: CLOSE c_prev_job_details;
140:
141: OPEN c_current_employer;

Line 144: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

140:
141: OPEN c_current_employer;
142: FETCH c_current_employer INTO v_dummy;
143: IF c_current_employer%FOUND THEN
144: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
145: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
146: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
147: hr_utility.raise_error;
148: END IF;

Line 145: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

141: OPEN c_current_employer;
142: FETCH c_current_employer INTO v_dummy;
143: IF c_current_employer%FOUND THEN
144: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
145: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
146: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
147: hr_utility.raise_error;
148: END IF;
149: CLOSE c_current_employer;

Line 146: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

142: FETCH c_current_employer INTO v_dummy;
143: IF c_current_employer%FOUND THEN
144: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
145: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
146: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
147: hr_utility.raise_error;
148: END IF;
149: CLOSE c_current_employer;
150: --

Line 147: hr_utility.raise_error;

143: IF c_current_employer%FOUND THEN
144: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
145: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
146: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
147: hr_utility.raise_error;
148: END IF;
149: CLOSE c_current_employer;
150: --
151: END IF;

Line 189: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

185: BEGIN
186: --
187: -- Added for GSI Bug 5472781
188: --
189: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
190: --
191: -- hr_utility.trace_on('Y','Russia');
192:
193: -- hr_utility.trace('St Date : ' || p_start_date);

Line 191: -- hr_utility.trace_on('Y','Russia');

187: -- Added for GSI Bug 5472781
188: --
189: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
190: --
191: -- hr_utility.trace_on('Y','Russia');
192:
193: -- hr_utility.trace('St Date : ' || p_start_date);
194: -- hr_utility.trace('End Date : ' || p_end_date);
195:

Line 193: -- hr_utility.trace('St Date : ' || p_start_date);

189: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
190: --
191: -- hr_utility.trace_on('Y','Russia');
192:
193: -- hr_utility.trace('St Date : ' || p_start_date);
194: -- hr_utility.trace('End Date : ' || p_end_date);
195:
196: open c_get_job;
197: FETCH c_get_job into v_dummy;

Line 194: -- hr_utility.trace('End Date : ' || p_end_date);

190: --
191: -- hr_utility.trace_on('Y','Russia');
192:
193: -- hr_utility.trace('St Date : ' || p_start_date);
194: -- hr_utility.trace('End Date : ' || p_end_date);
195:
196: open c_get_job;
197: FETCH c_get_job into v_dummy;
198: -- hr_utility.trace('v_dummy : ' || v_dummy);

Line 198: -- hr_utility.trace('v_dummy : ' || v_dummy);

194: -- hr_utility.trace('End Date : ' || p_end_date);
195:
196: open c_get_job;
197: FETCH c_get_job into v_dummy;
198: -- hr_utility.trace('v_dummy : ' || v_dummy);
199: IF c_get_job%FOUND then
200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

Line 200: -- hr_utility.trace('Inside IF');

196: open c_get_job;
197: FETCH c_get_job into v_dummy;
198: -- hr_utility.trace('v_dummy : ' || v_dummy);
199: IF c_get_job%FOUND then
200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
204: hr_utility.raise_error;

Line 201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

197: FETCH c_get_job into v_dummy;
198: -- hr_utility.trace('v_dummy : ' || v_dummy);
199: IF c_get_job%FOUND then
200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
204: hr_utility.raise_error;
205: END IF;

Line 202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

198: -- hr_utility.trace('v_dummy : ' || v_dummy);
199: IF c_get_job%FOUND then
200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
204: hr_utility.raise_error;
205: END IF;
206: CLOSE c_get_job;

Line 203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

199: IF c_get_job%FOUND then
200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
204: hr_utility.raise_error;
205: END IF;
206: CLOSE c_get_job;
207:

Line 204: hr_utility.raise_error;

200: -- hr_utility.trace('Inside IF');
201: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
202: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
203: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
204: hr_utility.raise_error;
205: END IF;
206: CLOSE c_get_job;
207:
208: OPEN c_current_employer;

Line 211: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

207:
208: OPEN c_current_employer;
209: FETCH c_current_employer INTO v_dummy;
210: IF c_current_employer%FOUND THEN
211: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
212: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
213: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
214: hr_utility.raise_error;
215: END IF;

Line 212: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

208: OPEN c_current_employer;
209: FETCH c_current_employer INTO v_dummy;
210: IF c_current_employer%FOUND THEN
211: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
212: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
213: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
214: hr_utility.raise_error;
215: END IF;
216: CLOSE c_current_employer;

Line 213: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

209: FETCH c_current_employer INTO v_dummy;
210: IF c_current_employer%FOUND THEN
211: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
212: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
213: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
214: hr_utility.raise_error;
215: END IF;
216: CLOSE c_current_employer;
217: END IF;

Line 214: hr_utility.raise_error;

210: IF c_current_employer%FOUND THEN
211: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
212: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
213: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
214: hr_utility.raise_error;
215: END IF;
216: CLOSE c_current_employer;
217: END IF;
218: END CREATE_RU_PREVIOUS_JOB;

Line 256: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN

252: BEGIN
253: --
254: -- Added for GSI Bug 5472781
255: --
256: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
257: --
258: OPEN c_job_details;
259: FETCH c_job_details into v_dummy;
260: IF c_job_details%FOUND THEN

Line 261: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

257: --
258: OPEN c_job_details;
259: FETCH c_job_details into v_dummy;
260: IF c_job_details%FOUND THEN
261: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
262: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
263: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
264: hr_utility.raise_error;
265: END IF;

Line 262: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

258: OPEN c_job_details;
259: FETCH c_job_details into v_dummy;
260: IF c_job_details%FOUND THEN
261: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
262: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
263: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
264: hr_utility.raise_error;
265: END IF;
266: CLOSE c_job_details;

Line 263: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

259: FETCH c_job_details into v_dummy;
260: IF c_job_details%FOUND THEN
261: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
262: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
263: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
264: hr_utility.raise_error;
265: END IF;
266: CLOSE c_job_details;
267: OPEN c_current_employer;

Line 264: hr_utility.raise_error;

260: IF c_job_details%FOUND THEN
261: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
262: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
263: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
264: hr_utility.raise_error;
265: END IF;
266: CLOSE c_job_details;
267: OPEN c_current_employer;
268: FETCH c_current_employer INTO v_dummy;

Line 270: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');

266: CLOSE c_job_details;
267: OPEN c_current_employer;
268: FETCH c_current_employer INTO v_dummy;
269: IF c_current_employer%FOUND THEN
270: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
271: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
272: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
273: hr_utility.raise_error;
274: END IF;

Line 271: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));

267: OPEN c_current_employer;
268: FETCH c_current_employer INTO v_dummy;
269: IF c_current_employer%FOUND THEN
270: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
271: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
272: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
273: hr_utility.raise_error;
274: END IF;
275: CLOSE c_current_employer;

Line 272: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));

268: FETCH c_current_employer INTO v_dummy;
269: IF c_current_employer%FOUND THEN
270: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
271: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
272: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
273: hr_utility.raise_error;
274: END IF;
275: CLOSE c_current_employer;
276: END IF;

Line 273: hr_utility.raise_error;

269: IF c_current_employer%FOUND THEN
270: hr_utility.set_message(800,'HR_RU_OVERLAPPING_DATES');
271: hr_utility.set_message_token('STARTDATE', to_char(p_start_date, 'DD-MON-YYYY'));
272: hr_utility.set_message_token('ENDDATE', to_char(p_end_date, 'DD-MON-YYYY'));
273: hr_utility.raise_error;
274: END IF;
275: CLOSE c_current_employer;
276: END IF;
277: END UPDATE_RU_PREVIOUS_JOB;