APPS.HR_PERSONAL_SCORECARD_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_personal_scorecard_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_scorecard >----------------------------|

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

71: begin
72:
73: IF g_debug THEN
74:
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76:
77: hr_utility.trace(' ');
78: hr_utility.trace(' --------------------------------'||
79: '---------------------------------');

Line 77: hr_utility.trace(' ');

73: IF g_debug THEN
74:
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76:
77: hr_utility.trace(' ');
78: hr_utility.trace(' --------------------------------'||
79: '---------------------------------');
80: hr_utility.trace(' IN / IN OUT PARAMETER '||
81: ' VALUE');

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

74:
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76:
77: hr_utility.trace(' ');
78: hr_utility.trace(' --------------------------------'||
79: '---------------------------------');
80: hr_utility.trace(' IN / IN OUT PARAMETER '||
81: ' VALUE');
82: hr_utility.trace(' --------------------------------'||

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

76:
77: hr_utility.trace(' ');
78: hr_utility.trace(' --------------------------------'||
79: '---------------------------------');
80: hr_utility.trace(' IN / IN OUT PARAMETER '||
81: ' VALUE');
82: hr_utility.trace(' --------------------------------'||
83: '+--------------------------------');
84: hr_utility.trace(' p_effective_date '||

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

78: hr_utility.trace(' --------------------------------'||
79: '---------------------------------');
80: hr_utility.trace(' IN / IN OUT PARAMETER '||
81: ' VALUE');
82: hr_utility.trace(' --------------------------------'||
83: '+--------------------------------');
84: hr_utility.trace(' p_effective_date '||
85: to_char(p_effective_date));
86: hr_utility.trace(' p_scorecard_name '||

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

80: hr_utility.trace(' IN / IN OUT PARAMETER '||
81: ' VALUE');
82: hr_utility.trace(' --------------------------------'||
83: '+--------------------------------');
84: hr_utility.trace(' p_effective_date '||
85: to_char(p_effective_date));
86: hr_utility.trace(' p_scorecard_name '||
87: p_scorecard_name);
88: hr_utility.trace(' p_assignment_id '||

Line 86: hr_utility.trace(' p_scorecard_name '||

82: hr_utility.trace(' --------------------------------'||
83: '+--------------------------------');
84: hr_utility.trace(' p_effective_date '||
85: to_char(p_effective_date));
86: hr_utility.trace(' p_scorecard_name '||
87: p_scorecard_name);
88: hr_utility.trace(' p_assignment_id '||
89: to_char(p_assignment_id));
90: hr_utility.trace(' p_start_date '||

Line 88: hr_utility.trace(' p_assignment_id '||

84: hr_utility.trace(' p_effective_date '||
85: to_char(p_effective_date));
86: hr_utility.trace(' p_scorecard_name '||
87: p_scorecard_name);
88: hr_utility.trace(' p_assignment_id '||
89: to_char(p_assignment_id));
90: hr_utility.trace(' p_start_date '||
91: to_char(p_start_date));
92: hr_utility.trace(' p_end_date '||

Line 90: hr_utility.trace(' p_start_date '||

86: hr_utility.trace(' p_scorecard_name '||
87: p_scorecard_name);
88: hr_utility.trace(' p_assignment_id '||
89: to_char(p_assignment_id));
90: hr_utility.trace(' p_start_date '||
91: to_char(p_start_date));
92: hr_utility.trace(' p_end_date '||
93: to_char(p_end_date));
94: hr_utility.trace(' p_plan_id '||

Line 92: hr_utility.trace(' p_end_date '||

88: hr_utility.trace(' p_assignment_id '||
89: to_char(p_assignment_id));
90: hr_utility.trace(' p_start_date '||
91: to_char(p_start_date));
92: hr_utility.trace(' p_end_date '||
93: to_char(p_end_date));
94: hr_utility.trace(' p_plan_id '||
95: to_char(p_plan_id));
96: hr_utility.trace(' p_creator_type '||

Line 94: hr_utility.trace(' p_plan_id '||

90: hr_utility.trace(' p_start_date '||
91: to_char(p_start_date));
92: hr_utility.trace(' p_end_date '||
93: to_char(p_end_date));
94: hr_utility.trace(' p_plan_id '||
95: to_char(p_plan_id));
96: hr_utility.trace(' p_creator_type '||
97: p_creator_type);
98: hr_utility.trace(' p_status_code '||

Line 96: hr_utility.trace(' p_creator_type '||

92: hr_utility.trace(' p_end_date '||
93: to_char(p_end_date));
94: hr_utility.trace(' p_plan_id '||
95: to_char(p_plan_id));
96: hr_utility.trace(' p_creator_type '||
97: p_creator_type);
98: hr_utility.trace(' p_status_code '||
99: p_status_code);
100: hr_utility.trace(' --------------------------------'||

Line 98: hr_utility.trace(' p_status_code '||

94: hr_utility.trace(' p_plan_id '||
95: to_char(p_plan_id));
96: hr_utility.trace(' p_creator_type '||
97: p_creator_type);
98: hr_utility.trace(' p_status_code '||
99: p_status_code);
100: hr_utility.trace(' --------------------------------'||
101: '---------------------------------');
102: hr_utility.trace(' ');

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

96: hr_utility.trace(' p_creator_type '||
97: p_creator_type);
98: hr_utility.trace(' p_status_code '||
99: p_status_code);
100: hr_utility.trace(' --------------------------------'||
101: '---------------------------------');
102: hr_utility.trace(' ');
103:
104: END IF;

Line 102: hr_utility.trace(' ');

98: hr_utility.trace(' p_status_code '||
99: p_status_code);
100: hr_utility.trace(' --------------------------------'||
101: '---------------------------------');
102: hr_utility.trace(' ');
103:
104: END IF;
105:
106: --

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

170:
171: --
172: -- Process Logic
173: --
174: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
175:
176: per_pms_ins.ins
177: (p_effective_date => l_effective_date
178: ,p_scorecard_name => p_scorecard_name

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

274: ,p_hook_type => 'AP'
275: );
276: end;
277:
278: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
279: --
280: -- When in validation only mode raise the Validate_Enabled exception
281: --
282: if p_validate then

Line 298: hr_utility.trace(' ');

294: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
295: --
296: IF g_debug THEN
297:
298: hr_utility.trace(' ');
299: hr_utility.trace(' --------------------------------'||
300: '---------------------------------');
301: hr_utility.trace(' IN OUT / OUT PARAMETER '||
302: ' VALUE');

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

295: --
296: IF g_debug THEN
297:
298: hr_utility.trace(' ');
299: hr_utility.trace(' --------------------------------'||
300: '---------------------------------');
301: hr_utility.trace(' IN OUT / OUT PARAMETER '||
302: ' VALUE');
303: hr_utility.trace(' --------------------------------'||

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

297:
298: hr_utility.trace(' ');
299: hr_utility.trace(' --------------------------------'||
300: '---------------------------------');
301: hr_utility.trace(' IN OUT / OUT PARAMETER '||
302: ' VALUE');
303: hr_utility.trace(' --------------------------------'||
304: '+--------------------------------');
305: hr_utility.trace(' p_scorecard_id '||

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

299: hr_utility.trace(' --------------------------------'||
300: '---------------------------------');
301: hr_utility.trace(' IN OUT / OUT PARAMETER '||
302: ' VALUE');
303: hr_utility.trace(' --------------------------------'||
304: '+--------------------------------');
305: hr_utility.trace(' p_scorecard_id '||
306: to_char(p_scorecard_id));
307: hr_utility.trace(' p_object_version_number '||

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

301: hr_utility.trace(' IN OUT / OUT PARAMETER '||
302: ' VALUE');
303: hr_utility.trace(' --------------------------------'||
304: '+--------------------------------');
305: hr_utility.trace(' p_scorecard_id '||
306: to_char(p_scorecard_id));
307: hr_utility.trace(' p_object_version_number '||
308: to_char(p_object_version_number));
309: hr_utility.trace(' p_status_code '||

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

303: hr_utility.trace(' --------------------------------'||
304: '+--------------------------------');
305: hr_utility.trace(' p_scorecard_id '||
306: to_char(p_scorecard_id));
307: hr_utility.trace(' p_object_version_number '||
308: to_char(p_object_version_number));
309: hr_utility.trace(' p_status_code '||
310: p_status_code);
311: IF p_duplicate_name_warning THEN

Line 309: hr_utility.trace(' p_status_code '||

305: hr_utility.trace(' p_scorecard_id '||
306: to_char(p_scorecard_id));
307: hr_utility.trace(' p_object_version_number '||
308: to_char(p_object_version_number));
309: hr_utility.trace(' p_status_code '||
310: p_status_code);
311: IF p_duplicate_name_warning THEN
312: hr_utility.trace(' p_duplicate_name_warning '||
313: 'TRUE');

Line 312: hr_utility.trace(' p_duplicate_name_warning '||

308: to_char(p_object_version_number));
309: hr_utility.trace(' p_status_code '||
310: p_status_code);
311: IF p_duplicate_name_warning THEN
312: hr_utility.trace(' p_duplicate_name_warning '||
313: 'TRUE');
314: ELSE
315: hr_utility.trace(' p_duplicate_name_warning '||
316: 'FALSE');

Line 315: hr_utility.trace(' p_duplicate_name_warning '||

311: IF p_duplicate_name_warning THEN
312: hr_utility.trace(' p_duplicate_name_warning '||
313: 'TRUE');
314: ELSE
315: hr_utility.trace(' p_duplicate_name_warning '||
316: 'FALSE');
317: END IF;
318: hr_utility.trace(' --------------------------------'||
319: '---------------------------------');

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

314: ELSE
315: hr_utility.trace(' p_duplicate_name_warning '||
316: 'FALSE');
317: END IF;
318: hr_utility.trace(' --------------------------------'||
319: '---------------------------------');
320: hr_utility.trace(' ');
321: hr_utility.set_location(' Leaving:'||l_proc, 970);
322:

Line 320: hr_utility.trace(' ');

316: 'FALSE');
317: END IF;
318: hr_utility.trace(' --------------------------------'||
319: '---------------------------------');
320: hr_utility.trace(' ');
321: hr_utility.set_location(' Leaving:'||l_proc, 970);
322:
323: END IF;
324:

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

317: END IF;
318: hr_utility.trace(' --------------------------------'||
319: '---------------------------------');
320: hr_utility.trace(' ');
321: hr_utility.set_location(' Leaving:'||l_proc, 970);
322:
323: END IF;
324:
325: exception

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

337: p_scorecard_id := null;
338: p_object_version_number := null;
339: --p_status_code := l_status_code;
340: p_duplicate_name_warning := l_duplicate_name_warning;
341: hr_utility.set_location(' Leaving:'||l_proc, 980);
342: when others then
343: --
344: -- A validation or unexpected error has occured
345: --

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

351: p_scorecard_id := null;
352: p_object_version_number := null;
353: --p_status_code := null;
354: p_duplicate_name_warning := null;
355: hr_utility.set_location(' Leaving:'||l_proc, 990);
356: raise;
357: end create_scorecard;
358: --
359: -- ----------------------------------------------------------------------------

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

416: begin
417:
418: IF g_debug THEN
419:
420: hr_utility.set_location('Entering:'|| l_proc, 10);
421:
422: hr_utility.trace(' ');
423: hr_utility.trace(' --------------------------------'||
424: '---------------------------------');

Line 422: hr_utility.trace(' ');

418: IF g_debug THEN
419:
420: hr_utility.set_location('Entering:'|| l_proc, 10);
421:
422: hr_utility.trace(' ');
423: hr_utility.trace(' --------------------------------'||
424: '---------------------------------');
425: hr_utility.trace(' IN / IN OUT PARAMETER '||
426: ' VALUE');

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

419:
420: hr_utility.set_location('Entering:'|| l_proc, 10);
421:
422: hr_utility.trace(' ');
423: hr_utility.trace(' --------------------------------'||
424: '---------------------------------');
425: hr_utility.trace(' IN / IN OUT PARAMETER '||
426: ' VALUE');
427: hr_utility.trace(' --------------------------------'||

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

421:
422: hr_utility.trace(' ');
423: hr_utility.trace(' --------------------------------'||
424: '---------------------------------');
425: hr_utility.trace(' IN / IN OUT PARAMETER '||
426: ' VALUE');
427: hr_utility.trace(' --------------------------------'||
428: '+--------------------------------');
429: hr_utility.trace(' p_effective_date '||

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

423: hr_utility.trace(' --------------------------------'||
424: '---------------------------------');
425: hr_utility.trace(' IN / IN OUT PARAMETER '||
426: ' VALUE');
427: hr_utility.trace(' --------------------------------'||
428: '+--------------------------------');
429: hr_utility.trace(' p_effective_date '||
430: to_char(p_effective_date));
431: hr_utility.trace(' p_scorecard_id '||

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

425: hr_utility.trace(' IN / IN OUT PARAMETER '||
426: ' VALUE');
427: hr_utility.trace(' --------------------------------'||
428: '+--------------------------------');
429: hr_utility.trace(' p_effective_date '||
430: to_char(p_effective_date));
431: hr_utility.trace(' p_scorecard_id '||
432: to_char(p_scorecard_id));
433: hr_utility.trace(' p_object_version_number '||

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

427: hr_utility.trace(' --------------------------------'||
428: '+--------------------------------');
429: hr_utility.trace(' p_effective_date '||
430: to_char(p_effective_date));
431: hr_utility.trace(' p_scorecard_id '||
432: to_char(p_scorecard_id));
433: hr_utility.trace(' p_object_version_number '||
434: to_char(p_object_version_number));
435: hr_utility.trace(' p_scorecard_name '||

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

429: hr_utility.trace(' p_effective_date '||
430: to_char(p_effective_date));
431: hr_utility.trace(' p_scorecard_id '||
432: to_char(p_scorecard_id));
433: hr_utility.trace(' p_object_version_number '||
434: to_char(p_object_version_number));
435: hr_utility.trace(' p_scorecard_name '||
436: p_scorecard_name);
437: hr_utility.trace(' p_plan_id '||

Line 435: hr_utility.trace(' p_scorecard_name '||

431: hr_utility.trace(' p_scorecard_id '||
432: to_char(p_scorecard_id));
433: hr_utility.trace(' p_object_version_number '||
434: to_char(p_object_version_number));
435: hr_utility.trace(' p_scorecard_name '||
436: p_scorecard_name);
437: hr_utility.trace(' p_plan_id '||
438: to_char(p_plan_id));
439: hr_utility.trace(' p_start_date '||

Line 437: hr_utility.trace(' p_plan_id '||

433: hr_utility.trace(' p_object_version_number '||
434: to_char(p_object_version_number));
435: hr_utility.trace(' p_scorecard_name '||
436: p_scorecard_name);
437: hr_utility.trace(' p_plan_id '||
438: to_char(p_plan_id));
439: hr_utility.trace(' p_start_date '||
440: to_char(p_start_date));
441: hr_utility.trace(' p_end_date '||

Line 439: hr_utility.trace(' p_start_date '||

435: hr_utility.trace(' p_scorecard_name '||
436: p_scorecard_name);
437: hr_utility.trace(' p_plan_id '||
438: to_char(p_plan_id));
439: hr_utility.trace(' p_start_date '||
440: to_char(p_start_date));
441: hr_utility.trace(' p_end_date '||
442: to_char(p_end_date));
443: hr_utility.trace(' --------------------------------'||

Line 441: hr_utility.trace(' p_end_date '||

437: hr_utility.trace(' p_plan_id '||
438: to_char(p_plan_id));
439: hr_utility.trace(' p_start_date '||
440: to_char(p_start_date));
441: hr_utility.trace(' p_end_date '||
442: to_char(p_end_date));
443: hr_utility.trace(' --------------------------------'||
444: '---------------------------------');
445: hr_utility.trace(' ');

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

439: hr_utility.trace(' p_start_date '||
440: to_char(p_start_date));
441: hr_utility.trace(' p_end_date '||
442: to_char(p_end_date));
443: hr_utility.trace(' --------------------------------'||
444: '---------------------------------');
445: hr_utility.trace(' ');
446:
447: END IF;

Line 445: hr_utility.trace(' ');

441: hr_utility.trace(' p_end_date '||
442: to_char(p_end_date));
443: hr_utility.trace(' --------------------------------'||
444: '---------------------------------');
445: hr_utility.trace(' ');
446:
447: END IF;
448:
449: --

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

513:
514: --
515: -- Process Logic
516: --
517: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
518:
519: per_pms_upd.upd
520: (p_effective_date => l_effective_date
521: ,p_scorecard_id => p_scorecard_id

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

612: ,p_hook_type => 'AP'
613: );
614: end;
615:
616: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
617: --
618: -- When in validation only mode raise the Validate_Enabled exception
619: --
620: if p_validate then

Line 634: hr_utility.trace(' ');

630: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
631: --
632: IF g_debug THEN
633:
634: hr_utility.trace(' ');
635: hr_utility.trace(' --------------------------------'||
636: '---------------------------------');
637: hr_utility.trace(' IN OUT / OUT PARAMETER '||
638: ' VALUE');

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

631: --
632: IF g_debug THEN
633:
634: hr_utility.trace(' ');
635: hr_utility.trace(' --------------------------------'||
636: '---------------------------------');
637: hr_utility.trace(' IN OUT / OUT PARAMETER '||
638: ' VALUE');
639: hr_utility.trace(' --------------------------------'||

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

633:
634: hr_utility.trace(' ');
635: hr_utility.trace(' --------------------------------'||
636: '---------------------------------');
637: hr_utility.trace(' IN OUT / OUT PARAMETER '||
638: ' VALUE');
639: hr_utility.trace(' --------------------------------'||
640: '+--------------------------------');
641: hr_utility.trace(' p_object_version_number '||

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

635: hr_utility.trace(' --------------------------------'||
636: '---------------------------------');
637: hr_utility.trace(' IN OUT / OUT PARAMETER '||
638: ' VALUE');
639: hr_utility.trace(' --------------------------------'||
640: '+--------------------------------');
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: IF p_duplicate_name_warning THEN

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

637: hr_utility.trace(' IN OUT / OUT PARAMETER '||
638: ' VALUE');
639: hr_utility.trace(' --------------------------------'||
640: '+--------------------------------');
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: IF p_duplicate_name_warning THEN
644: hr_utility.trace(' p_duplicate_name_warning '||
645: 'TRUE');

Line 644: hr_utility.trace(' p_duplicate_name_warning '||

640: '+--------------------------------');
641: hr_utility.trace(' p_object_version_number '||
642: to_char(p_object_version_number));
643: IF p_duplicate_name_warning THEN
644: hr_utility.trace(' p_duplicate_name_warning '||
645: 'TRUE');
646: ELSE
647: hr_utility.trace(' p_duplicate_name_warning '||
648: 'FALSE');

Line 647: hr_utility.trace(' p_duplicate_name_warning '||

643: IF p_duplicate_name_warning THEN
644: hr_utility.trace(' p_duplicate_name_warning '||
645: 'TRUE');
646: ELSE
647: hr_utility.trace(' p_duplicate_name_warning '||
648: 'FALSE');
649: END IF;
650: hr_utility.trace(' --------------------------------'||
651: '---------------------------------');

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

646: ELSE
647: hr_utility.trace(' p_duplicate_name_warning '||
648: 'FALSE');
649: END IF;
650: hr_utility.trace(' --------------------------------'||
651: '---------------------------------');
652: hr_utility.trace(' ');
653: hr_utility.set_location(' Leaving:'||l_proc, 970);
654:

Line 652: hr_utility.trace(' ');

648: 'FALSE');
649: END IF;
650: hr_utility.trace(' --------------------------------'||
651: '---------------------------------');
652: hr_utility.trace(' ');
653: hr_utility.set_location(' Leaving:'||l_proc, 970);
654:
655: END IF;
656:

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

649: END IF;
650: hr_utility.trace(' --------------------------------'||
651: '---------------------------------');
652: hr_utility.trace(' ');
653: hr_utility.set_location(' Leaving:'||l_proc, 970);
654:
655: END IF;
656:
657: exception

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

667: -- when validation only mode is being used.)
668: --
669: p_object_version_number := null;
670: p_duplicate_name_warning := l_duplicate_name_warning;
671: hr_utility.set_location(' Leaving:'||l_proc, 980);
672: when others then
673: --
674: -- A validation or unexpected error has occured
675: --

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

679: -- OUT parameters, including warnings, to null
680: --
681: p_object_version_number := null;
682: p_duplicate_name_warning := null;
683: hr_utility.set_location(' Leaving:'||l_proc, 990);
684: raise;
685: end update_scorecard;
686: --
687: -- ----------------------------------------------------------------------------

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

706: begin
707:
708: IF g_debug THEN
709:
710: hr_utility.set_location('Entering:'|| l_proc, 10);
711:
712: hr_utility.trace(' ');
713: hr_utility.trace(' --------------------------------'||
714: '---------------------------------');

Line 712: hr_utility.trace(' ');

708: IF g_debug THEN
709:
710: hr_utility.set_location('Entering:'|| l_proc, 10);
711:
712: hr_utility.trace(' ');
713: hr_utility.trace(' --------------------------------'||
714: '---------------------------------');
715: hr_utility.trace(' IN / IN OUT PARAMETER '||
716: ' VALUE');

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

709:
710: hr_utility.set_location('Entering:'|| l_proc, 10);
711:
712: hr_utility.trace(' ');
713: hr_utility.trace(' --------------------------------'||
714: '---------------------------------');
715: hr_utility.trace(' IN / IN OUT PARAMETER '||
716: ' VALUE');
717: hr_utility.trace(' --------------------------------'||

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

711:
712: hr_utility.trace(' ');
713: hr_utility.trace(' --------------------------------'||
714: '---------------------------------');
715: hr_utility.trace(' IN / IN OUT PARAMETER '||
716: ' VALUE');
717: hr_utility.trace(' --------------------------------'||
718: '+--------------------------------');
719: hr_utility.trace(' p_effective_date '||

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

713: hr_utility.trace(' --------------------------------'||
714: '---------------------------------');
715: hr_utility.trace(' IN / IN OUT PARAMETER '||
716: ' VALUE');
717: hr_utility.trace(' --------------------------------'||
718: '+--------------------------------');
719: hr_utility.trace(' p_effective_date '||
720: to_char(p_effective_date));
721: hr_utility.trace(' p_scorecard_id '||

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

715: hr_utility.trace(' IN / IN OUT PARAMETER '||
716: ' VALUE');
717: hr_utility.trace(' --------------------------------'||
718: '+--------------------------------');
719: hr_utility.trace(' p_effective_date '||
720: to_char(p_effective_date));
721: hr_utility.trace(' p_scorecard_id '||
722: to_char(p_scorecard_id));
723: hr_utility.trace(' p_object_version_number '||

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

717: hr_utility.trace(' --------------------------------'||
718: '+--------------------------------');
719: hr_utility.trace(' p_effective_date '||
720: to_char(p_effective_date));
721: hr_utility.trace(' p_scorecard_id '||
722: to_char(p_scorecard_id));
723: hr_utility.trace(' p_object_version_number '||
724: to_char(p_object_version_number));
725: hr_utility.trace(' p_status_code '||

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

719: hr_utility.trace(' p_effective_date '||
720: to_char(p_effective_date));
721: hr_utility.trace(' p_scorecard_id '||
722: to_char(p_scorecard_id));
723: hr_utility.trace(' p_object_version_number '||
724: to_char(p_object_version_number));
725: hr_utility.trace(' p_status_code '||
726: p_status_code);
727: hr_utility.trace(' --------------------------------'||

Line 725: hr_utility.trace(' p_status_code '||

721: hr_utility.trace(' p_scorecard_id '||
722: to_char(p_scorecard_id));
723: hr_utility.trace(' p_object_version_number '||
724: to_char(p_object_version_number));
725: hr_utility.trace(' p_status_code '||
726: p_status_code);
727: hr_utility.trace(' --------------------------------'||
728: '---------------------------------');
729: hr_utility.trace(' ');

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

723: hr_utility.trace(' p_object_version_number '||
724: to_char(p_object_version_number));
725: hr_utility.trace(' p_status_code '||
726: p_status_code);
727: hr_utility.trace(' --------------------------------'||
728: '---------------------------------');
729: hr_utility.trace(' ');
730:
731: END IF;

Line 729: hr_utility.trace(' ');

725: hr_utility.trace(' p_status_code '||
726: p_status_code);
727: hr_utility.trace(' --------------------------------'||
728: '---------------------------------');
729: hr_utility.trace(' ');
730:
731: END IF;
732:
733: --

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

760:
761: --
762: -- Process Logic
763: --
764: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
765:
766: per_pms_upd.upd
767: (p_effective_date => l_effective_date
768: ,p_scorecard_id => p_scorecard_id

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

788: ,p_hook_type => 'AP'
789: );
790: end;
791:
792: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
793: --
794: -- When in validation only mode raise the Validate_Enabled exception
795: --
796: if p_validate then

Line 809: hr_utility.trace(' ');

805: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
806: --
807: IF g_debug THEN
808:
809: hr_utility.trace(' ');
810: hr_utility.trace(' --------------------------------'||
811: '---------------------------------');
812: hr_utility.trace(' IN OUT / OUT PARAMETER '||
813: ' VALUE');

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

806: --
807: IF g_debug THEN
808:
809: hr_utility.trace(' ');
810: hr_utility.trace(' --------------------------------'||
811: '---------------------------------');
812: hr_utility.trace(' IN OUT / OUT PARAMETER '||
813: ' VALUE');
814: hr_utility.trace(' --------------------------------'||

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

808:
809: hr_utility.trace(' ');
810: hr_utility.trace(' --------------------------------'||
811: '---------------------------------');
812: hr_utility.trace(' IN OUT / OUT PARAMETER '||
813: ' VALUE');
814: hr_utility.trace(' --------------------------------'||
815: '+--------------------------------');
816: hr_utility.trace(' p_object_version_number '||

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

810: hr_utility.trace(' --------------------------------'||
811: '---------------------------------');
812: hr_utility.trace(' IN OUT / OUT PARAMETER '||
813: ' VALUE');
814: hr_utility.trace(' --------------------------------'||
815: '+--------------------------------');
816: hr_utility.trace(' p_object_version_number '||
817: to_char(p_object_version_number));
818: hr_utility.trace(' --------------------------------'||

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

812: hr_utility.trace(' IN OUT / OUT PARAMETER '||
813: ' VALUE');
814: hr_utility.trace(' --------------------------------'||
815: '+--------------------------------');
816: hr_utility.trace(' p_object_version_number '||
817: to_char(p_object_version_number));
818: hr_utility.trace(' --------------------------------'||
819: '---------------------------------');
820: hr_utility.trace(' ');

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

814: hr_utility.trace(' --------------------------------'||
815: '+--------------------------------');
816: hr_utility.trace(' p_object_version_number '||
817: to_char(p_object_version_number));
818: hr_utility.trace(' --------------------------------'||
819: '---------------------------------');
820: hr_utility.trace(' ');
821:
822: END IF;

Line 820: hr_utility.trace(' ');

816: hr_utility.trace(' p_object_version_number '||
817: to_char(p_object_version_number));
818: hr_utility.trace(' --------------------------------'||
819: '---------------------------------');
820: hr_utility.trace(' ');
821:
822: END IF;
823:
824: exception

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

836: -- (Any key or derived arguments must be set to null
837: -- when validation only mode is being used.)
838: --
839: p_object_version_number := null;
840: hr_utility.set_location(' Leaving:'||l_proc, 980);
841: when others then
842: --
843: -- A validation or unexpected error has occured
844: --

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

847: -- Reset IN OUT parameters and set all
848: -- OUT parameters, including warnings, to null
849: --
850: p_object_version_number := null;
851: hr_utility.set_location(' Leaving:'||l_proc, 990);
852: raise;
853: end update_scorecard_status;
854: --
855: -- ----------------------------------------------------------------------------

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

871: begin
872:
873: IF g_debug THEN
874:
875: hr_utility.set_location('Entering:'|| l_proc, 10);
876:
877: hr_utility.trace(' ');
878: hr_utility.trace(' --------------------------------'||
879: '---------------------------------');

Line 877: hr_utility.trace(' ');

873: IF g_debug THEN
874:
875: hr_utility.set_location('Entering:'|| l_proc, 10);
876:
877: hr_utility.trace(' ');
878: hr_utility.trace(' --------------------------------'||
879: '---------------------------------');
880: hr_utility.trace(' IN / IN OUT PARAMETER '||
881: ' VALUE');

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

874:
875: hr_utility.set_location('Entering:'|| l_proc, 10);
876:
877: hr_utility.trace(' ');
878: hr_utility.trace(' --------------------------------'||
879: '---------------------------------');
880: hr_utility.trace(' IN / IN OUT PARAMETER '||
881: ' VALUE');
882: hr_utility.trace(' --------------------------------'||

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

876:
877: hr_utility.trace(' ');
878: hr_utility.trace(' --------------------------------'||
879: '---------------------------------');
880: hr_utility.trace(' IN / IN OUT PARAMETER '||
881: ' VALUE');
882: hr_utility.trace(' --------------------------------'||
883: '+--------------------------------');
884: hr_utility.trace(' p_scorecard_id '||

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

878: hr_utility.trace(' --------------------------------'||
879: '---------------------------------');
880: hr_utility.trace(' IN / IN OUT PARAMETER '||
881: ' VALUE');
882: hr_utility.trace(' --------------------------------'||
883: '+--------------------------------');
884: hr_utility.trace(' p_scorecard_id '||
885: to_char(p_scorecard_id));
886: hr_utility.trace(' p_object_version_number '||

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

880: hr_utility.trace(' IN / IN OUT PARAMETER '||
881: ' VALUE');
882: hr_utility.trace(' --------------------------------'||
883: '+--------------------------------');
884: hr_utility.trace(' p_scorecard_id '||
885: to_char(p_scorecard_id));
886: hr_utility.trace(' p_object_version_number '||
887: to_char(p_object_version_number));
888: hr_utility.trace(' --------------------------------'||

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

882: hr_utility.trace(' --------------------------------'||
883: '+--------------------------------');
884: hr_utility.trace(' p_scorecard_id '||
885: to_char(p_scorecard_id));
886: hr_utility.trace(' p_object_version_number '||
887: to_char(p_object_version_number));
888: hr_utility.trace(' --------------------------------'||
889: '---------------------------------');
890: hr_utility.trace(' ');

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

884: hr_utility.trace(' p_scorecard_id '||
885: to_char(p_scorecard_id));
886: hr_utility.trace(' p_object_version_number '||
887: to_char(p_object_version_number));
888: hr_utility.trace(' --------------------------------'||
889: '---------------------------------');
890: hr_utility.trace(' ');
891:
892: END IF;

Line 890: hr_utility.trace(' ');

886: hr_utility.trace(' p_object_version_number '||
887: to_char(p_object_version_number));
888: hr_utility.trace(' --------------------------------'||
889: '---------------------------------');
890: hr_utility.trace(' ');
891:
892: END IF;
893:
894: --

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

914:
915: --
916: -- Process Logic
917: --
918: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
919:
920: per_pms_del.del
921: (p_scorecard_id => p_scorecard_id
922: ,p_object_version_number => p_object_version_number

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

939: ,p_hook_type => 'AP'
940: );
941: end;
942:
943: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
944: --
945: -- When in validation only mode raise the Validate_Enabled exception
946: --
947: if p_validate then

Line 960: hr_utility.trace(' ');

956: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
957: --
958: IF g_debug THEN
959:
960: hr_utility.trace(' ');
961: hr_utility.trace(' --------------------------------'||
962: '---------------------------------');
963: hr_utility.trace(' IN OUT / OUT PARAMETER '||
964: ' VALUE');

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

957: --
958: IF g_debug THEN
959:
960: hr_utility.trace(' ');
961: hr_utility.trace(' --------------------------------'||
962: '---------------------------------');
963: hr_utility.trace(' IN OUT / OUT PARAMETER '||
964: ' VALUE');
965: hr_utility.trace(' --------------------------------'||

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

959:
960: hr_utility.trace(' ');
961: hr_utility.trace(' --------------------------------'||
962: '---------------------------------');
963: hr_utility.trace(' IN OUT / OUT PARAMETER '||
964: ' VALUE');
965: hr_utility.trace(' --------------------------------'||
966: '+--------------------------------');
967: hr_utility.trace(' p_object_version_number '||

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

961: hr_utility.trace(' --------------------------------'||
962: '---------------------------------');
963: hr_utility.trace(' IN OUT / OUT PARAMETER '||
964: ' VALUE');
965: hr_utility.trace(' --------------------------------'||
966: '+--------------------------------');
967: hr_utility.trace(' p_object_version_number '||
968: to_char(p_object_version_number));
969: IF p_created_by_plan_warning THEN

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

963: hr_utility.trace(' IN OUT / OUT PARAMETER '||
964: ' VALUE');
965: hr_utility.trace(' --------------------------------'||
966: '+--------------------------------');
967: hr_utility.trace(' p_object_version_number '||
968: to_char(p_object_version_number));
969: IF p_created_by_plan_warning THEN
970: hr_utility.trace(' p_created_by_plan_warning '||
971: 'TRUE');

Line 970: hr_utility.trace(' p_created_by_plan_warning '||

966: '+--------------------------------');
967: hr_utility.trace(' p_object_version_number '||
968: to_char(p_object_version_number));
969: IF p_created_by_plan_warning THEN
970: hr_utility.trace(' p_created_by_plan_warning '||
971: 'TRUE');
972: ELSE
973: hr_utility.trace(' p_created_by_plan_warning '||
974: 'FALSE');

Line 973: hr_utility.trace(' p_created_by_plan_warning '||

969: IF p_created_by_plan_warning THEN
970: hr_utility.trace(' p_created_by_plan_warning '||
971: 'TRUE');
972: ELSE
973: hr_utility.trace(' p_created_by_plan_warning '||
974: 'FALSE');
975: END IF;
976: hr_utility.trace(' --------------------------------'||
977: '---------------------------------');

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

972: ELSE
973: hr_utility.trace(' p_created_by_plan_warning '||
974: 'FALSE');
975: END IF;
976: hr_utility.trace(' --------------------------------'||
977: '---------------------------------');
978: hr_utility.trace(' ');
979: hr_utility.set_location(' Leaving:'||l_proc, 970);
980:

Line 978: hr_utility.trace(' ');

974: 'FALSE');
975: END IF;
976: hr_utility.trace(' --------------------------------'||
977: '---------------------------------');
978: hr_utility.trace(' ');
979: hr_utility.set_location(' Leaving:'||l_proc, 970);
980:
981: END IF;
982:

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

975: END IF;
976: hr_utility.trace(' --------------------------------'||
977: '---------------------------------');
978: hr_utility.trace(' ');
979: hr_utility.set_location(' Leaving:'||l_proc, 970);
980:
981: END IF;
982:
983: exception

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

992: -- (Any key or derived arguments must be set to null
993: -- when validation only mode is being used.)
994: --
995: p_created_by_plan_warning := l_created_by_plan_warning;
996: hr_utility.set_location(' Leaving:'||l_proc, 980);
997: when others then
998: --
999: -- A validation or unexpected error has occured
1000: --

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

1003: -- Reset IN OUT parameters and set all
1004: -- OUT parameters, including warnings, to null
1005: --
1006: p_created_by_plan_warning := null;
1007: hr_utility.set_location(' Leaving:'||l_proc, 990);
1008: raise;
1009: end delete_scorecard;
1010: --
1011: end hr_personal_scorecard_api;