APPS.HR_SECURITY_USER_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'hr_security_user_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |---------------------< create_security_user >-----------------------------|
11: -- ----------------------------------------------------------------------------

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

27: BEGIN
28:
29: IF g_debug THEN
30:
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Pipe the main IN / IN OUT parameters for ease of debugging.
34: --
35: hr_utility.trace(' ');

Line 35: hr_utility.trace(' ');

31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Pipe the main IN / IN OUT parameters for ease of debugging.
34: --
35: hr_utility.trace(' ');
36: hr_utility.trace(' --------------------------------'||
37: '---------------------------------');
38: hr_utility.trace(' IN / IN OUT PARAMETER '||
39: ' VALUE');

Line 36: hr_utility.trace(' --------------------------------'||

32: --
33: -- Pipe the main IN / IN OUT parameters for ease of debugging.
34: --
35: hr_utility.trace(' ');
36: hr_utility.trace(' --------------------------------'||
37: '---------------------------------');
38: hr_utility.trace(' IN / IN OUT PARAMETER '||
39: ' VALUE');
40: hr_utility.trace(' --------------------------------'||

Line 38: hr_utility.trace(' IN / IN OUT PARAMETER '||

34: --
35: hr_utility.trace(' ');
36: hr_utility.trace(' --------------------------------'||
37: '---------------------------------');
38: hr_utility.trace(' IN / IN OUT PARAMETER '||
39: ' VALUE');
40: hr_utility.trace(' --------------------------------'||
41: '+--------------------------------');
42: IF p_validate THEN

Line 40: hr_utility.trace(' --------------------------------'||

36: hr_utility.trace(' --------------------------------'||
37: '---------------------------------');
38: hr_utility.trace(' IN / IN OUT PARAMETER '||
39: ' VALUE');
40: hr_utility.trace(' --------------------------------'||
41: '+--------------------------------');
42: IF p_validate THEN
43: hr_utility.trace(' p_validate '||
44: 'TRUE');

Line 43: hr_utility.trace(' p_validate '||

39: ' VALUE');
40: hr_utility.trace(' --------------------------------'||
41: '+--------------------------------');
42: IF p_validate THEN
43: hr_utility.trace(' p_validate '||
44: 'TRUE');
45: ELSE
46: hr_utility.trace(' p_validate '||
47: 'FALSE');

Line 46: hr_utility.trace(' p_validate '||

42: IF p_validate THEN
43: hr_utility.trace(' p_validate '||
44: 'TRUE');
45: ELSE
46: hr_utility.trace(' p_validate '||
47: 'FALSE');
48: END IF;
49: hr_utility.trace(' p_effective_date '||
50: to_char(p_effective_date));

Line 49: hr_utility.trace(' p_effective_date '||

45: ELSE
46: hr_utility.trace(' p_validate '||
47: 'FALSE');
48: END IF;
49: hr_utility.trace(' p_effective_date '||
50: to_char(p_effective_date));
51: hr_utility.trace(' p_user_id '||
52: to_char(p_user_id));
53: hr_utility.trace(' p_security_profile_id '||

Line 51: hr_utility.trace(' p_user_id '||

47: 'FALSE');
48: END IF;
49: hr_utility.trace(' p_effective_date '||
50: to_char(p_effective_date));
51: hr_utility.trace(' p_user_id '||
52: to_char(p_user_id));
53: hr_utility.trace(' p_security_profile_id '||
54: to_char(p_security_profile_id));
55: hr_utility.trace(' p_process_in_next_run_flag '||

Line 53: hr_utility.trace(' p_security_profile_id '||

49: hr_utility.trace(' p_effective_date '||
50: to_char(p_effective_date));
51: hr_utility.trace(' p_user_id '||
52: to_char(p_user_id));
53: hr_utility.trace(' p_security_profile_id '||
54: to_char(p_security_profile_id));
55: hr_utility.trace(' p_process_in_next_run_flag '||
56: p_process_in_next_run_flag);
57: hr_utility.trace(' --------------------------------'||

Line 55: hr_utility.trace(' p_process_in_next_run_flag '||

51: hr_utility.trace(' p_user_id '||
52: to_char(p_user_id));
53: hr_utility.trace(' p_security_profile_id '||
54: to_char(p_security_profile_id));
55: hr_utility.trace(' p_process_in_next_run_flag '||
56: p_process_in_next_run_flag);
57: hr_utility.trace(' --------------------------------'||
58: '---------------------------------');
59: hr_utility.trace(' ');

Line 57: hr_utility.trace(' --------------------------------'||

53: hr_utility.trace(' p_security_profile_id '||
54: to_char(p_security_profile_id));
55: hr_utility.trace(' p_process_in_next_run_flag '||
56: p_process_in_next_run_flag);
57: hr_utility.trace(' --------------------------------'||
58: '---------------------------------');
59: hr_utility.trace(' ');
60:
61: END IF;

Line 59: hr_utility.trace(' ');

55: hr_utility.trace(' p_process_in_next_run_flag '||
56: p_process_in_next_run_flag);
57: hr_utility.trace(' --------------------------------'||
58: '---------------------------------');
59: hr_utility.trace(' ');
60:
61: END IF;
62:
63: --

Line 69: hr_utility.set_location(l_proc, 20);

65: --
66: SAVEPOINT create_security_user;
67:
68: IF g_debug THEN
69: hr_utility.set_location(l_proc, 20);
70: END IF;
71:
72: --
73: -- Call Before Process User Hook

Line 90: hr_utility.set_location(l_proc, 30);

86: );
87: end;
88:
89: IF g_debug THEN
90: hr_utility.set_location(l_proc, 30);
91: END IF;
92:
93: --
94: -- Now call the insert row handler.

Line 106: hr_utility.set_location(l_proc, 40);

102: ,p_object_version_number => l_object_version_number
103: );
104:
105: IF g_debug THEN
106: hr_utility.set_location(l_proc, 40);
107: END IF;
108:
109: --
110: -- Call After Process User Hook

Line 129: hr_utility.set_location(l_proc, 50);

125: );
126: end;
127:
128: IF g_debug THEN
129: hr_utility.set_location(l_proc, 50);
130: END IF;
131:
132: --
133: -- When in validation only mode raise the Validate_Enabled exception

Line 149: hr_utility.trace(' ');

145: IF g_debug THEN
146: --
147: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
148: --
149: hr_utility.trace(' ');
150: hr_utility.trace(' --------------------------------'||
151: '---------------------------------');
152: hr_utility.trace(' IN OUT / OUT PARAMETER '||
153: ' VALUE');

Line 150: hr_utility.trace(' --------------------------------'||

146: --
147: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
148: --
149: hr_utility.trace(' ');
150: hr_utility.trace(' --------------------------------'||
151: '---------------------------------');
152: hr_utility.trace(' IN OUT / OUT PARAMETER '||
153: ' VALUE');
154: hr_utility.trace(' --------------------------------'||

Line 152: hr_utility.trace(' IN OUT / OUT PARAMETER '||

148: --
149: hr_utility.trace(' ');
150: hr_utility.trace(' --------------------------------'||
151: '---------------------------------');
152: hr_utility.trace(' IN OUT / OUT PARAMETER '||
153: ' VALUE');
154: hr_utility.trace(' --------------------------------'||
155: '+--------------------------------');
156: hr_utility.trace(' p_security_user_id '||

Line 154: hr_utility.trace(' --------------------------------'||

150: hr_utility.trace(' --------------------------------'||
151: '---------------------------------');
152: hr_utility.trace(' IN OUT / OUT PARAMETER '||
153: ' VALUE');
154: hr_utility.trace(' --------------------------------'||
155: '+--------------------------------');
156: hr_utility.trace(' p_security_user_id '||
157: to_char(p_security_user_id));
158: hr_utility.trace(' p_object_version_number '||

Line 156: hr_utility.trace(' p_security_user_id '||

152: hr_utility.trace(' IN OUT / OUT PARAMETER '||
153: ' VALUE');
154: hr_utility.trace(' --------------------------------'||
155: '+--------------------------------');
156: hr_utility.trace(' p_security_user_id '||
157: to_char(p_security_user_id));
158: hr_utility.trace(' p_object_version_number '||
159: to_char(p_object_version_number));
160: hr_utility.trace(' p_process_in_next_run_flag '||

Line 158: hr_utility.trace(' p_object_version_number '||

154: hr_utility.trace(' --------------------------------'||
155: '+--------------------------------');
156: hr_utility.trace(' p_security_user_id '||
157: to_char(p_security_user_id));
158: hr_utility.trace(' p_object_version_number '||
159: to_char(p_object_version_number));
160: hr_utility.trace(' p_process_in_next_run_flag '||
161: p_process_in_next_run_flag);
162: hr_utility.trace(' --------------------------------'||

Line 160: hr_utility.trace(' p_process_in_next_run_flag '||

156: hr_utility.trace(' p_security_user_id '||
157: to_char(p_security_user_id));
158: hr_utility.trace(' p_object_version_number '||
159: to_char(p_object_version_number));
160: hr_utility.trace(' p_process_in_next_run_flag '||
161: p_process_in_next_run_flag);
162: hr_utility.trace(' --------------------------------'||
163: '---------------------------------');
164: hr_utility.trace(' ');

Line 162: hr_utility.trace(' --------------------------------'||

158: hr_utility.trace(' p_object_version_number '||
159: to_char(p_object_version_number));
160: hr_utility.trace(' p_process_in_next_run_flag '||
161: p_process_in_next_run_flag);
162: hr_utility.trace(' --------------------------------'||
163: '---------------------------------');
164: hr_utility.trace(' ');
165:
166: hr_utility.set_location('Leaving: '||l_proc, 60);

Line 164: hr_utility.trace(' ');

160: hr_utility.trace(' p_process_in_next_run_flag '||
161: p_process_in_next_run_flag);
162: hr_utility.trace(' --------------------------------'||
163: '---------------------------------');
164: hr_utility.trace(' ');
165:
166: hr_utility.set_location('Leaving: '||l_proc, 60);
167:
168: END IF;

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

162: hr_utility.trace(' --------------------------------'||
163: '---------------------------------');
164: hr_utility.trace(' ');
165:
166: hr_utility.set_location('Leaving: '||l_proc, 60);
167:
168: END IF;
169:
170: EXCEPTION

Line 187: hr_utility.set_location(' Leaving:'||l_proc, 980);

183: p_security_user_id := null;
184: p_object_version_number := null;
185:
186: IF g_debug THEN
187: hr_utility.set_location(' Leaving:'||l_proc, 980);
188: END IF;
189:
190: WHEN OTHERS THEN
191: --

Line 200: hr_utility.set_location(' Leaving:'||l_proc, 999);

196: p_security_user_id := null;
197: p_object_version_number := null;
198:
199: IF g_debug THEN
200: hr_utility.set_location(' Leaving:'||l_proc, 999);
201: END IF;
202:
203: RAISE;
204:

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

226: BEGIN
227:
228: IF g_debug THEN
229:
230: hr_utility.set_location('Entering:'|| l_proc, 10);
231: --
232: -- Pipe the main IN / IN OUT parameters for ease of debugging.
233: --
234: hr_utility.trace(' ');

Line 234: hr_utility.trace(' ');

230: hr_utility.set_location('Entering:'|| l_proc, 10);
231: --
232: -- Pipe the main IN / IN OUT parameters for ease of debugging.
233: --
234: hr_utility.trace(' ');
235: hr_utility.trace(' --------------------------------'||
236: '---------------------------------');
237: hr_utility.trace(' IN / IN OUT PARAMETER '||
238: ' VALUE');

Line 235: hr_utility.trace(' --------------------------------'||

231: --
232: -- Pipe the main IN / IN OUT parameters for ease of debugging.
233: --
234: hr_utility.trace(' ');
235: hr_utility.trace(' --------------------------------'||
236: '---------------------------------');
237: hr_utility.trace(' IN / IN OUT PARAMETER '||
238: ' VALUE');
239: hr_utility.trace(' --------------------------------'||

Line 237: hr_utility.trace(' IN / IN OUT PARAMETER '||

233: --
234: hr_utility.trace(' ');
235: hr_utility.trace(' --------------------------------'||
236: '---------------------------------');
237: hr_utility.trace(' IN / IN OUT PARAMETER '||
238: ' VALUE');
239: hr_utility.trace(' --------------------------------'||
240: '+--------------------------------');
241: IF p_validate THEN

Line 239: hr_utility.trace(' --------------------------------'||

235: hr_utility.trace(' --------------------------------'||
236: '---------------------------------');
237: hr_utility.trace(' IN / IN OUT PARAMETER '||
238: ' VALUE');
239: hr_utility.trace(' --------------------------------'||
240: '+--------------------------------');
241: IF p_validate THEN
242: hr_utility.trace(' p_validate '||
243: 'TRUE');

Line 242: hr_utility.trace(' p_validate '||

238: ' VALUE');
239: hr_utility.trace(' --------------------------------'||
240: '+--------------------------------');
241: IF p_validate THEN
242: hr_utility.trace(' p_validate '||
243: 'TRUE');
244: ELSE
245: hr_utility.trace(' p_validate '||
246: 'FALSE');

Line 245: hr_utility.trace(' p_validate '||

241: IF p_validate THEN
242: hr_utility.trace(' p_validate '||
243: 'TRUE');
244: ELSE
245: hr_utility.trace(' p_validate '||
246: 'FALSE');
247: END IF;
248: hr_utility.trace(' p_effective_date '||
249: to_char(p_effective_date));

Line 248: hr_utility.trace(' p_effective_date '||

244: ELSE
245: hr_utility.trace(' p_validate '||
246: 'FALSE');
247: END IF;
248: hr_utility.trace(' p_effective_date '||
249: to_char(p_effective_date));
250: hr_utility.trace(' p_security_user_id '||
251: to_char(p_security_user_id));
252: hr_utility.trace(' p_user_id '||

Line 250: hr_utility.trace(' p_security_user_id '||

246: 'FALSE');
247: END IF;
248: hr_utility.trace(' p_effective_date '||
249: to_char(p_effective_date));
250: hr_utility.trace(' p_security_user_id '||
251: to_char(p_security_user_id));
252: hr_utility.trace(' p_user_id '||
253: to_char(p_user_id));
254: hr_utility.trace(' p_security_profile_id '||

Line 252: hr_utility.trace(' p_user_id '||

248: hr_utility.trace(' p_effective_date '||
249: to_char(p_effective_date));
250: hr_utility.trace(' p_security_user_id '||
251: to_char(p_security_user_id));
252: hr_utility.trace(' p_user_id '||
253: to_char(p_user_id));
254: hr_utility.trace(' p_security_profile_id '||
255: to_char(p_security_profile_id));
256: hr_utility.trace(' p_process_in_next_run_flag '||

Line 254: hr_utility.trace(' p_security_profile_id '||

250: hr_utility.trace(' p_security_user_id '||
251: to_char(p_security_user_id));
252: hr_utility.trace(' p_user_id '||
253: to_char(p_user_id));
254: hr_utility.trace(' p_security_profile_id '||
255: to_char(p_security_profile_id));
256: hr_utility.trace(' p_process_in_next_run_flag '||
257: p_process_in_next_run_flag);
258: hr_utility.trace(' l_object_version_number '||

Line 256: hr_utility.trace(' p_process_in_next_run_flag '||

252: hr_utility.trace(' p_user_id '||
253: to_char(p_user_id));
254: hr_utility.trace(' p_security_profile_id '||
255: to_char(p_security_profile_id));
256: hr_utility.trace(' p_process_in_next_run_flag '||
257: p_process_in_next_run_flag);
258: hr_utility.trace(' l_object_version_number '||
259: to_char(l_object_version_number));
260: hr_utility.trace(' --------------------------------'||

Line 258: hr_utility.trace(' l_object_version_number '||

254: hr_utility.trace(' p_security_profile_id '||
255: to_char(p_security_profile_id));
256: hr_utility.trace(' p_process_in_next_run_flag '||
257: p_process_in_next_run_flag);
258: hr_utility.trace(' l_object_version_number '||
259: to_char(l_object_version_number));
260: hr_utility.trace(' --------------------------------'||
261: '---------------------------------');
262: hr_utility.trace(' ');

Line 260: hr_utility.trace(' --------------------------------'||

256: hr_utility.trace(' p_process_in_next_run_flag '||
257: p_process_in_next_run_flag);
258: hr_utility.trace(' l_object_version_number '||
259: to_char(l_object_version_number));
260: hr_utility.trace(' --------------------------------'||
261: '---------------------------------');
262: hr_utility.trace(' ');
263:
264: END IF;

Line 262: hr_utility.trace(' ');

258: hr_utility.trace(' l_object_version_number '||
259: to_char(l_object_version_number));
260: hr_utility.trace(' --------------------------------'||
261: '---------------------------------');
262: hr_utility.trace(' ');
263:
264: END IF;
265:
266: --

Line 272: hr_utility.set_location(l_proc, 20);

268: --
269: SAVEPOINT update_security_user;
270:
271: IF g_debug THEN
272: hr_utility.set_location(l_proc, 20);
273: END IF;
274:
275: --
276: -- Call Before Process User Hook

Line 295: hr_utility.set_location(l_proc, 30);

291: );
292: end;
293:
294: IF g_debug THEN
295: hr_utility.set_location(l_proc, 30);
296: END IF;
297:
298: --
299: -- Now call the update row handler.

Line 312: hr_utility.set_location(l_proc, 40);

308: ,p_del_static_lists_warning => l_del_static_lists_warning
309: );
310:
311: IF g_debug THEN
312: hr_utility.set_location(l_proc, 40);
313: END IF;
314:
315: --
316: -- Call After Process User Hook

Line 336: hr_utility.set_location(l_proc, 50);

332: );
333: end;
334:
335: IF g_debug THEN
336: hr_utility.set_location(l_proc, 50);
337: END IF;
338:
339: --
340: -- When in validation only mode raise the Validate_Enabled exception

Line 356: hr_utility.trace(' ');

352: IF g_debug THEN
353: --
354: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
355: --
356: hr_utility.trace(' ');
357: hr_utility.trace(' --------------------------------'||
358: '---------------------------------');
359: hr_utility.trace(' IN OUT / OUT PARAMETER '||
360: ' VALUE');

Line 357: hr_utility.trace(' --------------------------------'||

353: --
354: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
355: --
356: hr_utility.trace(' ');
357: hr_utility.trace(' --------------------------------'||
358: '---------------------------------');
359: hr_utility.trace(' IN OUT / OUT PARAMETER '||
360: ' VALUE');
361: hr_utility.trace(' --------------------------------'||

Line 359: hr_utility.trace(' IN OUT / OUT PARAMETER '||

355: --
356: hr_utility.trace(' ');
357: hr_utility.trace(' --------------------------------'||
358: '---------------------------------');
359: hr_utility.trace(' IN OUT / OUT PARAMETER '||
360: ' VALUE');
361: hr_utility.trace(' --------------------------------'||
362: '+--------------------------------');
363: hr_utility.trace(' p_object_version_number '||

Line 361: hr_utility.trace(' --------------------------------'||

357: hr_utility.trace(' --------------------------------'||
358: '---------------------------------');
359: hr_utility.trace(' IN OUT / OUT PARAMETER '||
360: ' VALUE');
361: hr_utility.trace(' --------------------------------'||
362: '+--------------------------------');
363: hr_utility.trace(' p_object_version_number '||
364: to_char(p_object_version_number));
365: hr_utility.trace(' p_process_in_next_run_flag '||

Line 363: hr_utility.trace(' p_object_version_number '||

359: hr_utility.trace(' IN OUT / OUT PARAMETER '||
360: ' VALUE');
361: hr_utility.trace(' --------------------------------'||
362: '+--------------------------------');
363: hr_utility.trace(' p_object_version_number '||
364: to_char(p_object_version_number));
365: hr_utility.trace(' p_process_in_next_run_flag '||
366: p_process_in_next_run_flag);
367: IF p_del_static_lists_warning THEN

Line 365: hr_utility.trace(' p_process_in_next_run_flag '||

361: hr_utility.trace(' --------------------------------'||
362: '+--------------------------------');
363: hr_utility.trace(' p_object_version_number '||
364: to_char(p_object_version_number));
365: hr_utility.trace(' p_process_in_next_run_flag '||
366: p_process_in_next_run_flag);
367: IF p_del_static_lists_warning THEN
368: hr_utility.trace(' p_del_static_lists_warning '||
369: 'TRUE');

Line 368: hr_utility.trace(' p_del_static_lists_warning '||

364: to_char(p_object_version_number));
365: hr_utility.trace(' p_process_in_next_run_flag '||
366: p_process_in_next_run_flag);
367: IF p_del_static_lists_warning THEN
368: hr_utility.trace(' p_del_static_lists_warning '||
369: 'TRUE');
370: ELSE
371: hr_utility.trace(' p_del_static_lists_warning '||
372: 'FALSE');

Line 371: hr_utility.trace(' p_del_static_lists_warning '||

367: IF p_del_static_lists_warning THEN
368: hr_utility.trace(' p_del_static_lists_warning '||
369: 'TRUE');
370: ELSE
371: hr_utility.trace(' p_del_static_lists_warning '||
372: 'FALSE');
373: END IF;
374: hr_utility.trace(' --------------------------------'||
375: '---------------------------------');

Line 374: hr_utility.trace(' --------------------------------'||

370: ELSE
371: hr_utility.trace(' p_del_static_lists_warning '||
372: 'FALSE');
373: END IF;
374: hr_utility.trace(' --------------------------------'||
375: '---------------------------------');
376: hr_utility.trace(' ');
377:
378: hr_utility.set_location('Leaving: '||l_proc, 60);

Line 376: hr_utility.trace(' ');

372: 'FALSE');
373: END IF;
374: hr_utility.trace(' --------------------------------'||
375: '---------------------------------');
376: hr_utility.trace(' ');
377:
378: hr_utility.set_location('Leaving: '||l_proc, 60);
379:
380: END IF;

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

374: hr_utility.trace(' --------------------------------'||
375: '---------------------------------');
376: hr_utility.trace(' ');
377:
378: hr_utility.set_location('Leaving: '||l_proc, 60);
379:
380: END IF;
381:
382: EXCEPTION

Line 399: hr_utility.set_location(' Leaving:'||l_proc, 980);

395: p_object_version_number := null;
396: p_del_static_lists_warning := l_del_static_lists_warning;
397:
398: IF g_debug THEN
399: hr_utility.set_location(' Leaving:'||l_proc, 980);
400: END IF;
401:
402: WHEN OTHERS THEN
403: --

Line 412: hr_utility.set_location(' Leaving:'||l_proc, 999);

408: p_object_version_number := null;
409: p_del_static_lists_warning := null;
410:
411: IF g_debug THEN
412: hr_utility.set_location(' Leaving:'||l_proc, 999);
413: END IF;
414:
415: RAISE;
416:

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

433: BEGIN
434:
435: IF g_debug THEN
436:
437: hr_utility.set_location('Entering:'|| l_proc, 10);
438: --
439: -- Pipe the main IN / IN OUT parameters for ease of debugging.
440: --
441: hr_utility.trace(' ');

Line 441: hr_utility.trace(' ');

437: hr_utility.set_location('Entering:'|| l_proc, 10);
438: --
439: -- Pipe the main IN / IN OUT parameters for ease of debugging.
440: --
441: hr_utility.trace(' ');
442: hr_utility.trace(' --------------------------------'||
443: '---------------------------------');
444: hr_utility.trace(' IN / IN OUT PARAMETER '||
445: ' VALUE');

Line 442: hr_utility.trace(' --------------------------------'||

438: --
439: -- Pipe the main IN / IN OUT parameters for ease of debugging.
440: --
441: hr_utility.trace(' ');
442: hr_utility.trace(' --------------------------------'||
443: '---------------------------------');
444: hr_utility.trace(' IN / IN OUT PARAMETER '||
445: ' VALUE');
446: hr_utility.trace(' --------------------------------'||

Line 444: hr_utility.trace(' IN / IN OUT PARAMETER '||

440: --
441: hr_utility.trace(' ');
442: hr_utility.trace(' --------------------------------'||
443: '---------------------------------');
444: hr_utility.trace(' IN / IN OUT PARAMETER '||
445: ' VALUE');
446: hr_utility.trace(' --------------------------------'||
447: '+--------------------------------');
448: IF p_validate THEN

Line 446: hr_utility.trace(' --------------------------------'||

442: hr_utility.trace(' --------------------------------'||
443: '---------------------------------');
444: hr_utility.trace(' IN / IN OUT PARAMETER '||
445: ' VALUE');
446: hr_utility.trace(' --------------------------------'||
447: '+--------------------------------');
448: IF p_validate THEN
449: hr_utility.trace(' p_validate '||
450: 'TRUE');

Line 449: hr_utility.trace(' p_validate '||

445: ' VALUE');
446: hr_utility.trace(' --------------------------------'||
447: '+--------------------------------');
448: IF p_validate THEN
449: hr_utility.trace(' p_validate '||
450: 'TRUE');
451: ELSE
452: hr_utility.trace(' p_validate '||
453: 'FALSE');

Line 452: hr_utility.trace(' p_validate '||

448: IF p_validate THEN
449: hr_utility.trace(' p_validate '||
450: 'TRUE');
451: ELSE
452: hr_utility.trace(' p_validate '||
453: 'FALSE');
454: END IF;
455: hr_utility.trace(' p_security_user_id '||
456: to_char(p_security_user_id));

Line 455: hr_utility.trace(' p_security_user_id '||

451: ELSE
452: hr_utility.trace(' p_validate '||
453: 'FALSE');
454: END IF;
455: hr_utility.trace(' p_security_user_id '||
456: to_char(p_security_user_id));
457: hr_utility.trace(' p_object_version_number '||
458: to_char(p_object_version_number));
459: hr_utility.trace(' --------------------------------'||

Line 457: hr_utility.trace(' p_object_version_number '||

453: 'FALSE');
454: END IF;
455: hr_utility.trace(' p_security_user_id '||
456: to_char(p_security_user_id));
457: hr_utility.trace(' p_object_version_number '||
458: to_char(p_object_version_number));
459: hr_utility.trace(' --------------------------------'||
460: '---------------------------------');
461: hr_utility.trace(' ');

Line 459: hr_utility.trace(' --------------------------------'||

455: hr_utility.trace(' p_security_user_id '||
456: to_char(p_security_user_id));
457: hr_utility.trace(' p_object_version_number '||
458: to_char(p_object_version_number));
459: hr_utility.trace(' --------------------------------'||
460: '---------------------------------');
461: hr_utility.trace(' ');
462:
463: END IF;

Line 461: hr_utility.trace(' ');

457: hr_utility.trace(' p_object_version_number '||
458: to_char(p_object_version_number));
459: hr_utility.trace(' --------------------------------'||
460: '---------------------------------');
461: hr_utility.trace(' ');
462:
463: END IF;
464:
465: --

Line 471: hr_utility.set_location(l_proc, 20);

467: --
468: SAVEPOINT delete_security_user;
469:
470: IF g_debug THEN
471: hr_utility.set_location(l_proc, 20);
472: END IF;
473:
474: --
475: -- Call Before Process User Hook

Line 490: hr_utility.set_location(l_proc, 30);

486: );
487: end;
488:
489: IF g_debug THEN
490: hr_utility.set_location(l_proc, 30);
491: END IF;
492:
493: --
494: -- Now call the delete row handler.

Line 503: hr_utility.set_location(l_proc, 40);

499: ,p_del_static_lists_warning => l_del_static_lists_warning
500: );
501:
502: IF g_debug THEN
503: hr_utility.set_location(l_proc, 40);
504: END IF;
505:
506: --
507: -- Call After Process User Hook

Line 523: hr_utility.set_location(l_proc, 50);

519: );
520: end;
521:
522: IF g_debug THEN
523: hr_utility.set_location(l_proc, 50);
524: END IF;
525:
526: --
527: -- When in validation only mode raise the Validate_Enabled exception

Line 542: hr_utility.trace(' ');

538: IF g_debug THEN
539: --
540: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
541: --
542: hr_utility.trace(' ');
543: hr_utility.trace(' --------------------------------'||
544: '---------------------------------');
545: hr_utility.trace(' IN OUT / OUT PARAMETER '||
546: ' VALUE');

Line 543: hr_utility.trace(' --------------------------------'||

539: --
540: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
541: --
542: hr_utility.trace(' ');
543: hr_utility.trace(' --------------------------------'||
544: '---------------------------------');
545: hr_utility.trace(' IN OUT / OUT PARAMETER '||
546: ' VALUE');
547: hr_utility.trace(' --------------------------------'||

Line 545: hr_utility.trace(' IN OUT / OUT PARAMETER '||

541: --
542: hr_utility.trace(' ');
543: hr_utility.trace(' --------------------------------'||
544: '---------------------------------');
545: hr_utility.trace(' IN OUT / OUT PARAMETER '||
546: ' VALUE');
547: hr_utility.trace(' --------------------------------'||
548: '+--------------------------------');
549: IF p_del_static_lists_warning THEN

Line 547: hr_utility.trace(' --------------------------------'||

543: hr_utility.trace(' --------------------------------'||
544: '---------------------------------');
545: hr_utility.trace(' IN OUT / OUT PARAMETER '||
546: ' VALUE');
547: hr_utility.trace(' --------------------------------'||
548: '+--------------------------------');
549: IF p_del_static_lists_warning THEN
550: hr_utility.trace(' p_del_static_lists_warning '||
551: 'TRUE');

Line 550: hr_utility.trace(' p_del_static_lists_warning '||

546: ' VALUE');
547: hr_utility.trace(' --------------------------------'||
548: '+--------------------------------');
549: IF p_del_static_lists_warning THEN
550: hr_utility.trace(' p_del_static_lists_warning '||
551: 'TRUE');
552: ELSE
553: hr_utility.trace(' p_del_static_lists_warning '||
554: 'FALSE');

Line 553: hr_utility.trace(' p_del_static_lists_warning '||

549: IF p_del_static_lists_warning THEN
550: hr_utility.trace(' p_del_static_lists_warning '||
551: 'TRUE');
552: ELSE
553: hr_utility.trace(' p_del_static_lists_warning '||
554: 'FALSE');
555: END IF;
556: hr_utility.trace(' --------------------------------'||
557: '---------------------------------');

Line 556: hr_utility.trace(' --------------------------------'||

552: ELSE
553: hr_utility.trace(' p_del_static_lists_warning '||
554: 'FALSE');
555: END IF;
556: hr_utility.trace(' --------------------------------'||
557: '---------------------------------');
558: hr_utility.trace(' ');
559:
560: hr_utility.set_location('Leaving: '||l_proc, 60);

Line 558: hr_utility.trace(' ');

554: 'FALSE');
555: END IF;
556: hr_utility.trace(' --------------------------------'||
557: '---------------------------------');
558: hr_utility.trace(' ');
559:
560: hr_utility.set_location('Leaving: '||l_proc, 60);
561:
562: END IF;

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

556: hr_utility.trace(' --------------------------------'||
557: '---------------------------------');
558: hr_utility.trace(' ');
559:
560: hr_utility.set_location('Leaving: '||l_proc, 60);
561:
562: END IF;
563:
564: EXCEPTION

Line 580: hr_utility.set_location(' Leaving:'||l_proc, 980);

576: --
577: p_del_static_lists_warning := l_del_static_lists_warning;
578:
579: IF g_debug THEN
580: hr_utility.set_location(' Leaving:'||l_proc, 980);
581: END IF;
582:
583: WHEN OTHERS THEN
584: --

Line 592: hr_utility.set_location(' Leaving:'||l_proc, 999);

588: ROLLBACK to delete_security_user;
589: p_del_static_lists_warning := null;
590:
591: IF g_debug THEN
592: hr_utility.set_location(' Leaving:'||l_proc, 999);
593: END IF;
594:
595: RAISE;
596: