DBA Data[Home] [Help]

APPS.HR_SCORECARD_SHARING_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_scorecard_sharing_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_sharing_instance >---------------------|

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

59: begin
60:
61: IF g_debug THEN
62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');

Line 65: hr_utility.trace(' ');

61: IF g_debug THEN
62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');

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

62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||

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

64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||

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

66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||

Line 72: hr_utility.trace(' p_scorecard_id '||

68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||

Line 74: hr_utility.trace(' p_person_id '||

70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');

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

72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');
79:
80: END IF;

Line 78: hr_utility.trace(' ');

74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');
79:
80: END IF;
81:
82: --

Line 137: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

133:
134: --
135: -- Process Logic
136: --
137: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
138:
139: per_psh_ins.ins
140: (p_scorecard_id => p_scorecard_id
141: ,p_person_id => p_person_id

Line 226: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

222: ,p_hook_type => 'AP'
223: );
224: end;
225:
226: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
227: --
228: -- When in validation only mode raise the Validate_Enabled exception
229: --
230: if p_validate then

Line 244: hr_utility.trace(' ');

240: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
241: --
242: IF g_debug THEN
243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');

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

241: --
242: IF g_debug THEN
243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||

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

243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||

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

245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||

Line 251: hr_utility.trace(' p_sharing_instance_id '||

247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||

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

249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');

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

251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:

Line 257: hr_utility.trace(' ');

253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:
260: END IF;
261:

Line 258: hr_utility.set_location(' Leaving:'||l_proc, 970);

254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:
260: END IF;
261:
262: exception

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

272: -- when validation only mode is being used.)
273: --
274: p_sharing_instance_id := null;
275: p_object_version_number := null;
276: hr_utility.set_location(' Leaving:'||l_proc, 980);
277: when others then
278: --
279: -- A validation or unexpected error has occured
280: --

Line 288: hr_utility.set_location(' Leaving:'||l_proc, 990);

284: -- OUT parameters, including warnings, to null
285: --
286: p_sharing_instance_id := null;
287: p_object_version_number := null;
288: hr_utility.set_location(' Leaving:'||l_proc, 990);
289: raise;
290: end create_sharing_instance;
291: --
292: -- ----------------------------------------------------------------------------

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

306: begin
307:
308: IF g_debug THEN
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');

Line 312: hr_utility.trace(' ');

308: IF g_debug THEN
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');

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

309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||

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

311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||

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

313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||

Line 319: hr_utility.trace(' p_sharing_instance_id '||

315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||

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

317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');

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

319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');
326:
327: END IF;

Line 325: hr_utility.trace(' ');

321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');
326:
327: END IF;
328:
329: --

Line 353: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;

349:
350: --
351: -- Process Logic
352: --
353: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
354:
355: per_psh_del.del
356: (p_sharing_instance_id => p_sharing_instance_id
357: ,p_object_version_number => p_object_version_number

Line 376: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;

372: ,p_hook_type => 'AP'
373: );
374: end;
375:
376: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then

Line 389: hr_utility.trace(' ');

385: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
386: --
387: IF g_debug THEN
388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');

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

386: --
387: IF g_debug THEN
388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||

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

388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');

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

390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:

Line 396: hr_utility.trace(' ');

392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:
399: END IF;
400:

Line 397: hr_utility.set_location(' Leaving:'||l_proc, 970);

393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:
399: END IF;
400:
401: exception

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

404: -- As the Validate_Enabled exception has been raised
405: -- we must rollback to the savepoint
406: --
407: rollback to delete_sharing_instance;
408: hr_utility.set_location(' Leaving:'||l_proc, 980);
409: when others then
410: --
411: -- A validation or unexpected error has occured
412: --

Line 414: hr_utility.set_location(' Leaving:'||l_proc, 990);

410: --
411: -- A validation or unexpected error has occured
412: --
413: rollback to delete_sharing_instance;
414: hr_utility.set_location(' Leaving:'||l_proc, 990);
415: raise;
416: end delete_sharing_instance;
417: --
418: end hr_scorecard_sharing_api;