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

Line 115: g_debug := hr_utility.debug_enabled;

111: l_future_date date;
112: l_proc varchar2(30);
113:
114: begin
115: g_debug := hr_utility.debug_enabled;
116: if g_debug then
117: l_proc := g_package||'position_wf_sync';
118: end if;
119:

Line 124: hr_utility.set_location('After my_synch_routine - ' ||l_proc, 16);

120: l_position_id := p_position_id;
121: --
122: hr_psf_shd.my_synch_routine(l_position_id);
123: if g_debug then
124: hr_utility.set_location('After my_synch_routine - ' ||l_proc, 16);
125: end if;
126: end;
127: --
128: --

Line 146: g_debug := hr_utility.debug_enabled;

142: l_name hr_all_positions_f_tl.name%type;
143: --
144: begin
145: --
146: g_debug := hr_utility.debug_enabled;
147: if g_debug then
148: l_proc := g_package||'MY_SYNC_ROUTINE';
149: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);
150: end if;

Line 149: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);

145: --
146: g_debug := hr_utility.debug_enabled;
147: if g_debug then
148: l_proc := g_package||'MY_SYNC_ROUTINE';
149: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);
150: end if;
151:
152: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
153: if cnt = 0 then

Line 195: hr_utility.set_location('l_start_date is '||l_start_date, 20);

191: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
192: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
193:
194: if g_debug then
195: hr_utility.set_location('l_start_date is '||l_start_date, 20);
196: end if;
197:
198: WF_LOCAL_SYNCH.propagate_role(
199: p_orig_system => 'POS',

Line 210: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 30);

206:
207: end if;
208:
209: if g_debug then
210: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 30);
211: end if;
212: --
213: end my_synch_routine;
214:

Line 225: g_debug := hr_utility.debug_enabled;

221: --
222: l_proc varchar2(72);
223: --
224: Begin
225: g_debug := hr_utility.debug_enabled;
226: if g_debug then
227: l_proc := g_package||'constraint_error';
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: end if;

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

224: Begin
225: g_debug := hr_utility.debug_enabled;
226: if g_debug then
227: l_proc := g_package||'constraint_error';
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: end if;
230: --
231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

228: hr_utility.set_location('Entering:'||l_proc, 5);
229: end if;
230: --
231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then

Line 233: hr_utility.set_message_token('PROCEDURE', l_proc);

229: end if;
230: --
231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 234: hr_utility.set_message_token('STEP','5');

230: --
231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 235: hr_utility.raise_error;

231: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
232: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');

Line 237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

233: hr_utility.set_message_token('PROCEDURE', l_proc);
234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then

Line 238: hr_utility.set_message_token('PROCEDURE', l_proc);

234: hr_utility.set_message_token('STEP','5');
235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 239: hr_utility.set_message_token('STEP','10');

235: hr_utility.raise_error;
236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 240: hr_utility.raise_error;

236: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
237: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');

Line 242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then

Line 243: hr_utility.set_message_token('PROCEDURE', l_proc);

239: hr_utility.set_message_token('STEP','10');
240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 244: hr_utility.set_message_token('STEP','15');

240: hr_utility.raise_error;
241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 245: hr_utility.raise_error;

241: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
242: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');

Line 247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then

Line 248: hr_utility.set_message_token('PROCEDURE', l_proc);

244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 249: hr_utility.set_message_token('STEP','20');

245: hr_utility.raise_error;
246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 250: hr_utility.raise_error;

246: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
247: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');

Line 252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

248: hr_utility.set_message_token('PROCEDURE', l_proc);
249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then

Line 253: hr_utility.set_message_token('PROCEDURE', l_proc);

249: hr_utility.set_message_token('STEP','20');
250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 254: hr_utility.set_message_token('STEP','25');

250: hr_utility.raise_error;
251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 255: hr_utility.raise_error;

251: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
252: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');

Line 257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

253: hr_utility.set_message_token('PROCEDURE', l_proc);
254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then

Line 258: hr_utility.set_message_token('PROCEDURE', l_proc);

254: hr_utility.set_message_token('STEP','25');
255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 259: hr_utility.set_message_token('STEP','30');

255: hr_utility.raise_error;
256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 260: hr_utility.raise_error;

256: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
257: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');

Line 262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

258: hr_utility.set_message_token('PROCEDURE', l_proc);
259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else

Line 263: hr_utility.set_message_token('PROCEDURE', l_proc);

259: hr_utility.set_message_token('STEP','30');
260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

Line 264: hr_utility.set_message_token('STEP','35');

260: hr_utility.raise_error;
261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 265: hr_utility.raise_error;

261: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
262: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);
269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

263: hr_utility.set_message_token('PROCEDURE', l_proc);
264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);
269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
270: hr_utility.raise_error;
271: End If;

Line 268: hr_utility.set_message_token('PROCEDURE', l_proc);

264: hr_utility.set_message_token('STEP','35');
265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);
269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
270: hr_utility.raise_error;
271: End If;
272: --

Line 269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

265: hr_utility.raise_error;
266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);
269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
270: hr_utility.raise_error;
271: End If;
272: --
273: if g_debug then

Line 270: hr_utility.raise_error;

266: Else
267: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
268: hr_utility.set_message_token('PROCEDURE', l_proc);
269: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
270: hr_utility.raise_error;
271: End If;
272: --
273: if g_debug then
274: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

270: hr_utility.raise_error;
271: End If;
272: --
273: if g_debug then
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: end if;
276: End constraint_error;
277: --
278: -- ----------------------------------------------------------------------------

Line 499: g_debug := hr_utility.debug_enabled;

495: l_proc varchar2(72);
496: l_fct_ret boolean;
497: --
498: Begin
499: g_debug := hr_utility.debug_enabled;
500: if g_debug then
501: l_proc := g_package||'api_updating';
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: end if;

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

498: Begin
499: g_debug := hr_utility.debug_enabled;
500: if g_debug then
501: l_proc := g_package||'api_updating';
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: end if;
504: --
505: If (p_effective_date is null or
506: p_position_id is null or

Line 517: hr_utility.set_location(l_proc, 10);

513: Else
514: If (p_position_id = g_old_rec.position_id and
515: p_object_version_number = g_old_rec.object_version_number) Then
516: if g_debug then
517: hr_utility.set_location(l_proc, 10);
518: end if;
519: --
520: -- The g_old_rec is current therefore we must
521: -- set the returning function to true

Line 535: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

531: Close C_Sel1;
532: --
533: -- The primary key is invalid therefore we must error
534: --
535: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
536: hr_utility.raise_error;
537: End If;
538: Close C_Sel1;
539: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 536: hr_utility.raise_error;

532: --
533: -- The primary key is invalid therefore we must error
534: --
535: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
536: hr_utility.raise_error;
537: End If;
538: Close C_Sel1;
539: If (p_object_version_number <> g_old_rec.object_version_number) Then
540: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

Line 540: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

536: hr_utility.raise_error;
537: End If;
538: Close C_Sel1;
539: If (p_object_version_number <> g_old_rec.object_version_number) Then
540: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
541: hr_utility.raise_error;
542: End If;
543: if g_debug then
544: hr_utility.set_location(l_proc, 15);

Line 541: hr_utility.raise_error;

537: End If;
538: Close C_Sel1;
539: If (p_object_version_number <> g_old_rec.object_version_number) Then
540: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
541: hr_utility.raise_error;
542: End If;
543: if g_debug then
544: hr_utility.set_location(l_proc, 15);
545: end if;

Line 544: hr_utility.set_location(l_proc, 15);

540: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
541: hr_utility.raise_error;
542: End If;
543: if g_debug then
544: hr_utility.set_location(l_proc, 15);
545: end if;
546: l_fct_ret := true;
547: End If;
548: End If;

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

546: l_fct_ret := true;
547: End If;
548: End If;
549: if g_debug then
550: hr_utility.set_location(' Leaving:'||l_proc, 20);
551: end if;
552: Return (l_fct_ret);
553: --
554: End api_updating;

Line 584: g_debug := hr_utility.debug_enabled;

580: and p_effective_date
581: between t.effective_start_date and t.effective_end_date;
582: --
583: Begin
584: g_debug := hr_utility.debug_enabled;
585: if g_debug then
586: l_proc := g_package||'find_dt_del_modes';
587: hr_utility.set_location('Entering:'||l_proc, 5);
588: end if;

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

583: Begin
584: g_debug := hr_utility.debug_enabled;
585: if g_debug then
586: l_proc := g_package||'find_dt_del_modes';
587: hr_utility.set_location('Entering:'||l_proc, 5);
588: end if;
589: Open C_Sel1;
590: Fetch C_Sel1 Into l_parent_key_value1,
591: l_parent_key_value2,

Line 595: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

591: l_parent_key_value2,
592: l_parent_key_value3;
593: If C_Sel1%notfound then
594: Close C_Sel1;
595: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE', l_proc);
597: hr_utility.set_message_token('STEP','10');
598: hr_utility.raise_error;
599: End If;

Line 596: hr_utility.set_message_token('PROCEDURE', l_proc);

592: l_parent_key_value3;
593: If C_Sel1%notfound then
594: Close C_Sel1;
595: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE', l_proc);
597: hr_utility.set_message_token('STEP','10');
598: hr_utility.raise_error;
599: End If;
600: Close C_Sel1;

Line 597: hr_utility.set_message_token('STEP','10');

593: If C_Sel1%notfound then
594: Close C_Sel1;
595: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE', l_proc);
597: hr_utility.set_message_token('STEP','10');
598: hr_utility.raise_error;
599: End If;
600: Close C_Sel1;
601: --

Line 598: hr_utility.raise_error;

594: Close C_Sel1;
595: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE', l_proc);
597: hr_utility.set_message_token('STEP','10');
598: hr_utility.raise_error;
599: End If;
600: Close C_Sel1;
601: --
602: -- Call the corresponding datetrack api

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

622: --
623: p_delete := false ;
624:
625: if g_debug then
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: end if;
628: End find_dt_del_modes;
629: --
630: -- ----------------------------------------------------------------------------

Line 644: g_debug := hr_utility.debug_enabled;

640: --
641: l_proc varchar2(72);
642: --
643: Begin
644: g_debug := hr_utility.debug_enabled;
645: if g_debug then
646: l_proc := g_package||'find_dt_upd_modes';
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: end if;

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

643: Begin
644: g_debug := hr_utility.debug_enabled;
645: if g_debug then
646: l_proc := g_package||'find_dt_upd_modes';
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: end if;
649: --
650: -- Call the corresponding datetrack api
651: --

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

659: p_update_override => p_update_override,
660: p_update_change_insert => p_update_change_insert);
661: --
662: if g_debug then
663: hr_utility.set_location(' Leaving:'||l_proc, 10);
664: end if;
665: End find_dt_upd_modes;
666: --
667: -- ----------------------------------------------------------------------------

Line 682: g_debug := hr_utility.debug_enabled;

678: l_proc varchar2(72);
679: l_object_version_number number;
680: --
681: Begin
682: g_debug := hr_utility.debug_enabled;
683: g_debug := hr_utility.debug_enabled;
684: if g_debug then
685: l_proc := g_package||'upd_effective_end_date';
686: hr_utility.set_location('Entering:'||l_proc, 5);

Line 683: g_debug := hr_utility.debug_enabled;

679: l_object_version_number number;
680: --
681: Begin
682: g_debug := hr_utility.debug_enabled;
683: g_debug := hr_utility.debug_enabled;
684: if g_debug then
685: l_proc := g_package||'upd_effective_end_date';
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: end if;

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

682: g_debug := hr_utility.debug_enabled;
683: g_debug := hr_utility.debug_enabled;
684: if g_debug then
685: l_proc := g_package||'upd_effective_end_date';
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: end if;
688: --
689: -- Because we are updating a row we must get the next object
690: -- version number.

Line 699: hr_utility.set_location(l_proc, 10);

695: p_base_key_column => 'position_id',
696: p_base_key_value => p_base_key_value);
697: --
698: if g_debug then
699: hr_utility.set_location(l_proc, 10);
700: end if;
701: --
702: -- Update the specified datetrack row setting the effective
703: -- end date to the specified new effective end date.

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

710: between t.effective_start_date and t.effective_end_date;
711: --
712: p_object_version_number := l_object_version_number;
713: if g_debug then
714: hr_utility.set_location(' Leaving:'||l_proc, 15);
715: end if;
716: --
717: Exception
718: When Others Then

Line 885: g_debug := hr_utility.debug_enabled;

881: --
882: --
883: --
884: Begin
885: g_debug := hr_utility.debug_enabled;
886: if g_debug then
887: l_proc := g_package||'lck';
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: end if;

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

884: Begin
885: g_debug := hr_utility.debug_enabled;
886: if g_debug then
887: l_proc := g_package||'lck';
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: end if;
890: --
891: -- Ensure that all the mandatory arguments are not null
892: --

Line 922: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

918: Close C_Sel1;
919: --
920: -- The primary key is invalid therefore we must error
921: --
922: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
923: hr_utility.raise_error;
924: End If;
925: Close C_Sel1;
926: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 923: hr_utility.raise_error;

919: --
920: -- The primary key is invalid therefore we must error
921: --
922: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
923: hr_utility.raise_error;
924: End If;
925: Close C_Sel1;
926: If (p_object_version_number <> g_old_rec.object_version_number) Then
927: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

Line 927: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

923: hr_utility.raise_error;
924: End If;
925: Close C_Sel1;
926: If (p_object_version_number <> g_old_rec.object_version_number) Then
927: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
928: hr_utility.raise_error;
929: End If;
930: if g_debug then
931: hr_utility.set_location(l_proc, 15);

Line 928: hr_utility.raise_error;

924: End If;
925: Close C_Sel1;
926: If (p_object_version_number <> g_old_rec.object_version_number) Then
927: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
928: hr_utility.raise_error;
929: End If;
930: if g_debug then
931: hr_utility.set_location(l_proc, 15);
932: end if;

Line 931: hr_utility.set_location(l_proc, 15);

927: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
928: hr_utility.raise_error;
929: End If;
930: if g_debug then
931: hr_utility.set_location(l_proc, 15);
932: end if;
933: --
934: --
935: -- Validate the datetrack mode mode getting the validation start

Line 939: hr_utility.set_location(' effective date ' || p_Effective_Date || l_proc, 12125);

935: -- Validate the datetrack mode mode getting the validation start
936: -- and end dates for the specified datetrack operation.
937: --
938: if g_debug then
939: hr_utility.set_location(' effective date ' || p_Effective_Date || l_proc, 12125);
940: end if;
941:
942: -- Bug 3199913
943: -- Removed refernce to 'per_all_assignments_f' since assignment and position

Line 979: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

975: -- We are doing a datetrack 'INSERT' which is illegal within this
976: -- procedure therefore we must error (note: to lck on insert the
977: -- private procedure ins_lck should be called).
978: --
979: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
980: hr_utility.set_message_token('PROCEDURE', l_proc);
981: hr_utility.set_message_token('STEP','20');
982: hr_utility.raise_error;
983: End If;

Line 980: hr_utility.set_message_token('PROCEDURE', l_proc);

976: -- procedure therefore we must error (note: to lck on insert the
977: -- private procedure ins_lck should be called).
978: --
979: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
980: hr_utility.set_message_token('PROCEDURE', l_proc);
981: hr_utility.set_message_token('STEP','20');
982: hr_utility.raise_error;
983: End If;
984: --

Line 981: hr_utility.set_message_token('STEP','20');

977: -- private procedure ins_lck should be called).
978: --
979: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
980: hr_utility.set_message_token('PROCEDURE', l_proc);
981: hr_utility.set_message_token('STEP','20');
982: hr_utility.raise_error;
983: End If;
984: --
985: -- Set the validation start and end date OUT arguments

Line 982: hr_utility.raise_error;

978: --
979: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
980: hr_utility.set_message_token('PROCEDURE', l_proc);
981: hr_utility.set_message_token('STEP','20');
982: hr_utility.raise_error;
983: End If;
984: --
985: -- Set the validation start and end date OUT arguments
986: --

Line 991: hr_utility.set_location(' Leaving:'||l_proc, 30);

987: p_validation_start_date := l_validation_start_date;
988: p_validation_end_date := l_validation_end_date;
989: --
990: if g_debug then
991: hr_utility.set_location(' Leaving:'||l_proc, 30);
992: end if;
993: --
994: -- We need to trap the ORA LOCK exception
995: --

Line 1002: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');

998: --
999: -- The object is locked therefore we need to supply a meaningful
1000: -- error message.
1001: --
1002: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1004: hr_utility.raise_error;
1005: When l_object_invalid then
1006: --

Line 1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');

999: -- The object is locked therefore we need to supply a meaningful
1000: -- error message.
1001: --
1002: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1004: hr_utility.raise_error;
1005: When l_object_invalid then
1006: --
1007: -- The object doesn't exist or is invalid

Line 1004: hr_utility.raise_error;

1000: -- error message.
1001: --
1002: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1003: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1004: hr_utility.raise_error;
1005: When l_object_invalid then
1006: --
1007: -- The object doesn't exist or is invalid
1008: --

Line 1009: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

1005: When l_object_invalid then
1006: --
1007: -- The object doesn't exist or is invalid
1008: --
1009: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1011: hr_utility.raise_error;
1012: End lck;
1013: --

Line 1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');

1006: --
1007: -- The object doesn't exist or is invalid
1008: --
1009: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1011: hr_utility.raise_error;
1012: End lck;
1013: --
1014: -- ----------------------------------------------------------------------------

Line 1011: hr_utility.raise_error;

1007: -- The object doesn't exist or is invalid
1008: --
1009: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1010: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1011: hr_utility.raise_error;
1012: End lck;
1013: --
1014: -- ----------------------------------------------------------------------------
1015: -- |-----------------------------< convert_args >-----------------------------|

Line 1159: g_debug := hr_utility.debug_enabled;

1155: l_proc varchar2(72);
1156: --
1157: Begin
1158: --
1159: g_debug := hr_utility.debug_enabled;
1160: if g_debug then
1161: l_proc := g_package||'convert_args';
1162: hr_utility.set_location('Entering:'||l_proc, 5);
1163: end if;

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

1158: --
1159: g_debug := hr_utility.debug_enabled;
1160: if g_debug then
1161: l_proc := g_package||'convert_args';
1162: hr_utility.set_location('Entering:'||l_proc, 5);
1163: end if;
1164: --
1165: -- Convert arguments into local l_rec structure.
1166: --

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

1299: --
1300: -- Return the plsql record structure.
1301: --
1302: if g_debug then
1303: hr_utility.set_location(' Leaving:'||l_proc, 10);
1304: end if;
1305: Return(l_rec);
1306: --
1307: End convert_args;