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 120: g_debug := hr_utility.debug_enabled;

116: l_eff_end_date date;
117:
118:
119: begin
120: g_debug := hr_utility.debug_enabled;
121: if g_debug then
122: l_proc := g_package||'position_wf_sync';
123: end if;
124:

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

128: l_eff_end_date := p_eff_end_date;
129: --
130: hr_psf_shd.my_synch_routine(l_position_id,l_action,l_eff_start_date,l_eff_end_date);
131: if g_debug then
132: hr_utility.set_location('After my_synch_routine - ' ||l_proc, 16);
133: end if;
134: end;
135: --
136: --

Line 161: g_debug := hr_utility.debug_enabled;

157: l_position_id_canonical varchar2(20);
158:
159: begin
160: --
161: g_debug := hr_utility.debug_enabled;
162: if g_debug then
163: l_proc := g_package||'MY_SYNC_ROUTINE';
164: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);
165: end if;

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

160: --
161: g_debug := hr_utility.debug_enabled;
162: if g_debug then
163: l_proc := g_package||'MY_SYNC_ROUTINE';
164: hr_utility.set_location('Before calling WF_SYNC package:'||l_proc, 30);
165: end if;
166:
167: l_position_id_canonical := FND_NUMBER.number_to_canonical(l_position_id);
168: l_start_date_canonical := FND_DATE.date_to_canonical(p_effective_start_date);

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

216: wf_event.AddParameterToList( 'WFSYNCH_OVERWRITE','TRUE',l_plist);
217: -- wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
218:
219: if g_debug then
220: hr_utility.set_location('l_start_date is '||l_start_date, 20);
221: end if;
222:
223: WF_LOCAL_SYNCH.propagate_role(
224: p_orig_system => 'POS',

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

254: p_parameters => l_plist);
255:
256: end if;
257: if g_debug then
258: hr_utility.set_location('After calling WF_SYNC package:'||l_proc, 30);
259: end if;
260: --
261: end my_synch_routine;
262:

Line 273: g_debug := hr_utility.debug_enabled;

269: --
270: l_proc varchar2(72);
271: --
272: Begin
273: g_debug := hr_utility.debug_enabled;
274: if g_debug then
275: l_proc := g_package||'constraint_error';
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: end if;

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

272: Begin
273: g_debug := hr_utility.debug_enabled;
274: if g_debug then
275: l_proc := g_package||'constraint_error';
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: end if;
278: --
279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

276: hr_utility.set_location('Entering:'||l_proc, 5);
277: end if;
278: --
279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then

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

277: end if;
278: --
279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

278: --
279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 283: hr_utility.raise_error;

279: If (p_constraint_name = 'HR_ALL_POSITIONS_F_FK11') Then
280: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');

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

281: hr_utility.set_message_token('PROCEDURE', l_proc);
282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then

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

282: hr_utility.set_message_token('STEP','5');
283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

283: hr_utility.raise_error;
284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 288: hr_utility.raise_error;

284: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK12') Then
285: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');

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

286: hr_utility.set_message_token('PROCEDURE', l_proc);
287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then

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

287: hr_utility.set_message_token('STEP','10');
288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

288: hr_utility.raise_error;
289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 293: hr_utility.raise_error;

289: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK4') Then
290: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');

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

291: hr_utility.set_message_token('PROCEDURE', l_proc);
292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then

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

292: hr_utility.set_message_token('STEP','15');
293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

293: hr_utility.raise_error;
294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 298: hr_utility.raise_error;

294: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK5') Then
295: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');

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

296: hr_utility.set_message_token('PROCEDURE', l_proc);
297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then

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

297: hr_utility.set_message_token('STEP','20');
298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

298: hr_utility.raise_error;
299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 303: hr_utility.raise_error;

299: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK6') Then
300: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');

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

301: hr_utility.set_message_token('PROCEDURE', l_proc);
302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then

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

302: hr_utility.set_message_token('STEP','25');
303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

303: hr_utility.raise_error;
304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 308: hr_utility.raise_error;

304: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_FK7') Then
305: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');

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

306: hr_utility.set_message_token('PROCEDURE', l_proc);
307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else

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

307: hr_utility.set_message_token('STEP','30');
308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

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

308: hr_utility.raise_error;
309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 313: hr_utility.raise_error;

309: ElsIf (p_constraint_name = 'HR_ALL_POSITIONS_F_PK') Then
310: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
318: hr_utility.raise_error;
319: End If;

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

312: hr_utility.set_message_token('STEP','35');
313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
318: hr_utility.raise_error;
319: End If;
320: --

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

313: hr_utility.raise_error;
314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
318: hr_utility.raise_error;
319: End If;
320: --
321: if g_debug then

Line 318: hr_utility.raise_error;

314: Else
315: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
318: hr_utility.raise_error;
319: End If;
320: --
321: if g_debug then
322: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

318: hr_utility.raise_error;
319: End If;
320: --
321: if g_debug then
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: end if;
324: End constraint_error;
325: --
326: -- ----------------------------------------------------------------------------

Line 547: g_debug := hr_utility.debug_enabled;

543: l_proc varchar2(72);
544: l_fct_ret boolean;
545: --
546: Begin
547: g_debug := hr_utility.debug_enabled;
548: if g_debug then
549: l_proc := g_package||'api_updating';
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: end if;

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

546: Begin
547: g_debug := hr_utility.debug_enabled;
548: if g_debug then
549: l_proc := g_package||'api_updating';
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: end if;
552: --
553: If (p_effective_date is null or
554: p_position_id is null or

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

561: Else
562: If (p_position_id = g_old_rec.position_id and
563: p_object_version_number = g_old_rec.object_version_number) Then
564: if g_debug then
565: hr_utility.set_location(l_proc, 10);
566: end if;
567: --
568: -- The g_old_rec is current therefore we must
569: -- set the returning function to true

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

579: Close C_Sel1;
580: --
581: -- The primary key is invalid therefore we must error
582: --
583: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
584: hr_utility.raise_error;
585: End If;
586: Close C_Sel1;
587: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 584: hr_utility.raise_error;

580: --
581: -- The primary key is invalid therefore we must error
582: --
583: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
584: hr_utility.raise_error;
585: End If;
586: Close C_Sel1;
587: If (p_object_version_number <> g_old_rec.object_version_number) Then
588: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

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

584: hr_utility.raise_error;
585: End If;
586: Close C_Sel1;
587: If (p_object_version_number <> g_old_rec.object_version_number) Then
588: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
589: hr_utility.raise_error;
590: End If;
591: if g_debug then
592: hr_utility.set_location(l_proc, 15);

Line 589: hr_utility.raise_error;

585: End If;
586: Close C_Sel1;
587: If (p_object_version_number <> g_old_rec.object_version_number) Then
588: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
589: hr_utility.raise_error;
590: End If;
591: if g_debug then
592: hr_utility.set_location(l_proc, 15);
593: end if;

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

588: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
589: hr_utility.raise_error;
590: End If;
591: if g_debug then
592: hr_utility.set_location(l_proc, 15);
593: end if;
594: l_fct_ret := true;
595: End If;
596: End If;

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

594: l_fct_ret := true;
595: End If;
596: End If;
597: if g_debug then
598: hr_utility.set_location(' Leaving:'||l_proc, 20);
599: end if;
600: Return (l_fct_ret);
601: --
602: End api_updating;

Line 632: g_debug := hr_utility.debug_enabled;

628: and p_effective_date
629: between t.effective_start_date and t.effective_end_date;
630: --
631: Begin
632: g_debug := hr_utility.debug_enabled;
633: if g_debug then
634: l_proc := g_package||'find_dt_del_modes';
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: end if;

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

631: Begin
632: g_debug := hr_utility.debug_enabled;
633: if g_debug then
634: l_proc := g_package||'find_dt_del_modes';
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: end if;
637: Open C_Sel1;
638: Fetch C_Sel1 Into l_parent_key_value1,
639: l_parent_key_value2,

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

639: l_parent_key_value2,
640: l_parent_key_value3;
641: If C_Sel1%notfound then
642: Close C_Sel1;
643: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP','10');
646: hr_utility.raise_error;
647: End If;

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

640: l_parent_key_value3;
641: If C_Sel1%notfound then
642: Close C_Sel1;
643: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP','10');
646: hr_utility.raise_error;
647: End If;
648: Close C_Sel1;

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

641: If C_Sel1%notfound then
642: Close C_Sel1;
643: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP','10');
646: hr_utility.raise_error;
647: End If;
648: Close C_Sel1;
649: --

Line 646: hr_utility.raise_error;

642: Close C_Sel1;
643: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
644: hr_utility.set_message_token('PROCEDURE', l_proc);
645: hr_utility.set_message_token('STEP','10');
646: hr_utility.raise_error;
647: End If;
648: Close C_Sel1;
649: --
650: -- Call the corresponding datetrack api

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

670: --
671: p_delete := false ;
672:
673: if g_debug then
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: end if;
676: End find_dt_del_modes;
677: --
678: -- ----------------------------------------------------------------------------

Line 692: g_debug := hr_utility.debug_enabled;

688: --
689: l_proc varchar2(72);
690: --
691: Begin
692: g_debug := hr_utility.debug_enabled;
693: if g_debug then
694: l_proc := g_package||'find_dt_upd_modes';
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: end if;

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

691: Begin
692: g_debug := hr_utility.debug_enabled;
693: if g_debug then
694: l_proc := g_package||'find_dt_upd_modes';
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: end if;
697: --
698: -- Call the corresponding datetrack api
699: --

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

707: p_update_override => p_update_override,
708: p_update_change_insert => p_update_change_insert);
709: --
710: if g_debug then
711: hr_utility.set_location(' Leaving:'||l_proc, 10);
712: end if;
713: End find_dt_upd_modes;
714: --
715: -- ----------------------------------------------------------------------------

Line 730: g_debug := hr_utility.debug_enabled;

726: l_proc varchar2(72);
727: l_object_version_number number;
728: --
729: Begin
730: g_debug := hr_utility.debug_enabled;
731: g_debug := hr_utility.debug_enabled;
732: if g_debug then
733: l_proc := g_package||'upd_effective_end_date';
734: hr_utility.set_location('Entering:'||l_proc, 5);

Line 731: g_debug := hr_utility.debug_enabled;

727: l_object_version_number number;
728: --
729: Begin
730: g_debug := hr_utility.debug_enabled;
731: g_debug := hr_utility.debug_enabled;
732: if g_debug then
733: l_proc := g_package||'upd_effective_end_date';
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: end if;

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

730: g_debug := hr_utility.debug_enabled;
731: g_debug := hr_utility.debug_enabled;
732: if g_debug then
733: l_proc := g_package||'upd_effective_end_date';
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: end if;
736: --
737: -- Because we are updating a row we must get the next object
738: -- version number.

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

743: p_base_key_column => 'position_id',
744: p_base_key_value => p_base_key_value);
745: --
746: if g_debug then
747: hr_utility.set_location(l_proc, 10);
748: end if;
749: --
750: -- Update the specified datetrack row setting the effective
751: -- end date to the specified new effective end date.

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

758: between t.effective_start_date and t.effective_end_date;
759: --
760: p_object_version_number := l_object_version_number;
761: if g_debug then
762: hr_utility.set_location(' Leaving:'||l_proc, 15);
763: end if;
764: --
765: Exception
766: When Others Then

Line 933: g_debug := hr_utility.debug_enabled;

929: --
930: --
931: --
932: Begin
933: g_debug := hr_utility.debug_enabled;
934: if g_debug then
935: l_proc := g_package||'lck';
936: hr_utility.set_location('Entering:'||l_proc, 5);
937: end if;

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

932: Begin
933: g_debug := hr_utility.debug_enabled;
934: if g_debug then
935: l_proc := g_package||'lck';
936: hr_utility.set_location('Entering:'||l_proc, 5);
937: end if;
938: --
939: -- Ensure that all the mandatory arguments are not null
940: --

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

966: Close C_Sel1;
967: --
968: -- The primary key is invalid therefore we must error
969: --
970: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
971: hr_utility.raise_error;
972: End If;
973: Close C_Sel1;
974: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 971: hr_utility.raise_error;

967: --
968: -- The primary key is invalid therefore we must error
969: --
970: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
971: hr_utility.raise_error;
972: End If;
973: Close C_Sel1;
974: If (p_object_version_number <> g_old_rec.object_version_number) Then
975: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');

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

971: hr_utility.raise_error;
972: End If;
973: Close C_Sel1;
974: If (p_object_version_number <> g_old_rec.object_version_number) Then
975: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
976: hr_utility.raise_error;
977: End If;
978: if g_debug then
979: hr_utility.set_location(l_proc, 15);

Line 976: hr_utility.raise_error;

972: End If;
973: Close C_Sel1;
974: If (p_object_version_number <> g_old_rec.object_version_number) Then
975: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
976: hr_utility.raise_error;
977: End If;
978: if g_debug then
979: hr_utility.set_location(l_proc, 15);
980: end if;

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

975: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
976: hr_utility.raise_error;
977: End If;
978: if g_debug then
979: hr_utility.set_location(l_proc, 15);
980: end if;
981: --
982: --
983: -- Validate the datetrack mode mode getting the validation start

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

983: -- Validate the datetrack mode mode getting the validation start
984: -- and end dates for the specified datetrack operation.
985: --
986: if g_debug then
987: hr_utility.set_location(' effective date ' || p_Effective_Date || l_proc, 12125);
988: end if;
989:
990: -- Bug 3199913
991: -- Removed refernce to 'per_all_assignments_f' since assignment and position

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

1023: -- We are doing a datetrack 'INSERT' which is illegal within this
1024: -- procedure therefore we must error (note: to lck on insert the
1025: -- private procedure ins_lck should be called).
1026: --
1027: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1028: hr_utility.set_message_token('PROCEDURE', l_proc);
1029: hr_utility.set_message_token('STEP','20');
1030: hr_utility.raise_error;
1031: End If;

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

1024: -- procedure therefore we must error (note: to lck on insert the
1025: -- private procedure ins_lck should be called).
1026: --
1027: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1028: hr_utility.set_message_token('PROCEDURE', l_proc);
1029: hr_utility.set_message_token('STEP','20');
1030: hr_utility.raise_error;
1031: End If;
1032: --

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

1025: -- private procedure ins_lck should be called).
1026: --
1027: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1028: hr_utility.set_message_token('PROCEDURE', l_proc);
1029: hr_utility.set_message_token('STEP','20');
1030: hr_utility.raise_error;
1031: End If;
1032: --
1033: -- Set the validation start and end date OUT arguments

Line 1030: hr_utility.raise_error;

1026: --
1027: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
1028: hr_utility.set_message_token('PROCEDURE', l_proc);
1029: hr_utility.set_message_token('STEP','20');
1030: hr_utility.raise_error;
1031: End If;
1032: --
1033: -- Set the validation start and end date OUT arguments
1034: --

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

1035: p_validation_start_date := l_validation_start_date;
1036: p_validation_end_date := l_validation_end_date;
1037: --
1038: if g_debug then
1039: hr_utility.set_location(' Leaving:'||l_proc, 30);
1040: end if;
1041: --
1042: -- We need to trap the ORA LOCK exception
1043: --

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

1046: --
1047: -- The object is locked therefore we need to supply a meaningful
1048: -- error message.
1049: --
1050: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1051: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1052: hr_utility.raise_error;
1053: When l_object_invalid then
1054: --

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

1047: -- The object is locked therefore we need to supply a meaningful
1048: -- error message.
1049: --
1050: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1051: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1052: hr_utility.raise_error;
1053: When l_object_invalid then
1054: --
1055: -- The object doesn't exist or is invalid

Line 1052: hr_utility.raise_error;

1048: -- error message.
1049: --
1050: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
1051: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1052: hr_utility.raise_error;
1053: When l_object_invalid then
1054: --
1055: -- The object doesn't exist or is invalid
1056: --

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

1053: When l_object_invalid then
1054: --
1055: -- The object doesn't exist or is invalid
1056: --
1057: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1058: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1059: hr_utility.raise_error;
1060: End lck;
1061: --

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

1054: --
1055: -- The object doesn't exist or is invalid
1056: --
1057: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1058: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1059: hr_utility.raise_error;
1060: End lck;
1061: --
1062: -- ----------------------------------------------------------------------------

Line 1059: hr_utility.raise_error;

1055: -- The object doesn't exist or is invalid
1056: --
1057: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
1058: hr_utility.set_message_token('TABLE_NAME', 'hr_all_positions_f');
1059: hr_utility.raise_error;
1060: End lck;
1061: --
1062: -- ----------------------------------------------------------------------------
1063: -- |-----------------------------< convert_args >-----------------------------|

Line 1207: g_debug := hr_utility.debug_enabled;

1203: l_proc varchar2(72);
1204: --
1205: Begin
1206: --
1207: g_debug := hr_utility.debug_enabled;
1208: if g_debug then
1209: l_proc := g_package||'convert_args';
1210: hr_utility.set_location('Entering:'||l_proc, 5);
1211: end if;

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

1206: --
1207: g_debug := hr_utility.debug_enabled;
1208: if g_debug then
1209: l_proc := g_package||'convert_args';
1210: hr_utility.set_location('Entering:'||l_proc, 5);
1211: end if;
1212: --
1213: -- Convert arguments into local l_rec structure.
1214: --

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

1347: --
1348: -- Return the plsql record structure.
1349: --
1350: if g_debug then
1351: hr_utility.set_location(' Leaving:'||l_proc, 10);
1352: end if;
1353: Return(l_rec);
1354: --
1355: End convert_args;

Line 1375: hr_utility.set_location('Entering hr_psf_shd.call_back',10);

1371:
1372:
1373:
1374: Begin
1375: hr_utility.set_location('Entering hr_psf_shd.call_back',10);
1376: l_entity := wf_event.getvalueforparameter(p_name => 'CONTEXT',
1377: p_parameterlist => p_parameters);
1378:
1379: l_position_id_canonical := wf_event.getvalueforparameter(p_name => 'POSITIONID',

Line 1391: hr_utility.set_location('About to call my_synch_routine in hr_psf_shd.call_back',20);

1387:
1388: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);
1389: l_end_date := FND_DATE.canonical_to_date(l_end_date_canonical);
1390: l_position_id := FND_NUMBER.canonical_to_number(l_position_id_canonical);
1391: hr_utility.set_location('About to call my_synch_routine in hr_psf_shd.call_back',20);
1392: hr_psf_shd.my_synch_routine(mykey => l_position_id,
1393: p_action => null,
1394: p_effective_start_date => l_start_date,
1395: p_effective_end_date => l_end_date);

Line 1397: hr_utility.set_location('Leaving hr_psf_shd.call_back',30);

1393: p_action => null,
1394: p_effective_start_date => l_start_date,
1395: p_effective_end_date => l_end_date);
1396:
1397: hr_utility.set_location('Leaving hr_psf_shd.call_back',30);
1398:
1399: End call_back;
1400: --
1401: end hr_psf_shd;