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 80: hr_utility.set_location('Entering:'|| l_proc, 10);

76: begin
77:
78: IF g_debug THEN
79:
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81:
82: hr_utility.trace(' ');
83: hr_utility.trace(' --------------------------------'||
84: '---------------------------------');

Line 82: hr_utility.trace(' ');

78: IF g_debug THEN
79:
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81:
82: hr_utility.trace(' ');
83: hr_utility.trace(' --------------------------------'||
84: '---------------------------------');
85: hr_utility.trace(' IN / IN OUT PARAMETER '||
86: ' VALUE');

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

79:
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81:
82: hr_utility.trace(' ');
83: hr_utility.trace(' --------------------------------'||
84: '---------------------------------');
85: hr_utility.trace(' IN / IN OUT PARAMETER '||
86: ' VALUE');
87: hr_utility.trace(' --------------------------------'||

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

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

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

83: hr_utility.trace(' --------------------------------'||
84: '---------------------------------');
85: hr_utility.trace(' IN / IN OUT PARAMETER '||
86: ' VALUE');
87: hr_utility.trace(' --------------------------------'||
88: '+--------------------------------');
89: hr_utility.trace(' p_effective_date '||
90: to_char(p_effective_date));
91: hr_utility.trace(' p_scorecard_name '||

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

85: hr_utility.trace(' IN / IN OUT PARAMETER '||
86: ' VALUE');
87: hr_utility.trace(' --------------------------------'||
88: '+--------------------------------');
89: hr_utility.trace(' p_effective_date '||
90: to_char(p_effective_date));
91: hr_utility.trace(' p_scorecard_name '||
92: p_scorecard_name);
93: hr_utility.trace(' p_assignment_id '||

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

87: hr_utility.trace(' --------------------------------'||
88: '+--------------------------------');
89: hr_utility.trace(' p_effective_date '||
90: to_char(p_effective_date));
91: hr_utility.trace(' p_scorecard_name '||
92: p_scorecard_name);
93: hr_utility.trace(' p_assignment_id '||
94: to_char(p_assignment_id));
95: hr_utility.trace(' p_start_date '||

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

89: hr_utility.trace(' p_effective_date '||
90: to_char(p_effective_date));
91: hr_utility.trace(' p_scorecard_name '||
92: p_scorecard_name);
93: hr_utility.trace(' p_assignment_id '||
94: to_char(p_assignment_id));
95: hr_utility.trace(' p_start_date '||
96: to_char(p_start_date));
97: hr_utility.trace(' p_end_date '||

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

91: hr_utility.trace(' p_scorecard_name '||
92: p_scorecard_name);
93: hr_utility.trace(' p_assignment_id '||
94: to_char(p_assignment_id));
95: hr_utility.trace(' p_start_date '||
96: to_char(p_start_date));
97: hr_utility.trace(' p_end_date '||
98: to_char(p_end_date));
99: hr_utility.trace(' p_plan_id '||

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

93: hr_utility.trace(' p_assignment_id '||
94: to_char(p_assignment_id));
95: hr_utility.trace(' p_start_date '||
96: to_char(p_start_date));
97: hr_utility.trace(' p_end_date '||
98: to_char(p_end_date));
99: hr_utility.trace(' p_plan_id '||
100: to_char(p_plan_id));
101: hr_utility.trace(' p_creator_type '||

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

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

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

97: hr_utility.trace(' p_end_date '||
98: to_char(p_end_date));
99: hr_utility.trace(' p_plan_id '||
100: to_char(p_plan_id));
101: hr_utility.trace(' p_creator_type '||
102: p_creator_type);
103: hr_utility.trace(' p_status_code '||
104: p_status_code);
105: hr_utility.trace(' --------------------------------'||

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

99: hr_utility.trace(' p_plan_id '||
100: to_char(p_plan_id));
101: hr_utility.trace(' p_creator_type '||
102: p_creator_type);
103: hr_utility.trace(' p_status_code '||
104: p_status_code);
105: hr_utility.trace(' --------------------------------'||
106: '---------------------------------');
107: hr_utility.trace(' ');

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

101: hr_utility.trace(' p_creator_type '||
102: p_creator_type);
103: hr_utility.trace(' p_status_code '||
104: p_status_code);
105: hr_utility.trace(' --------------------------------'||
106: '---------------------------------');
107: hr_utility.trace(' ');
108:
109: END IF;

Line 107: hr_utility.trace(' ');

103: hr_utility.trace(' p_status_code '||
104: p_status_code);
105: hr_utility.trace(' --------------------------------'||
106: '---------------------------------');
107: hr_utility.trace(' ');
108:
109: END IF;
110:
111: --

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

180:
181: --
182: -- Process Logic
183: --
184: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
185:
186: per_pms_ins.ins
187: (p_effective_date => l_effective_date
188: ,p_scorecard_name => p_scorecard_name

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

294: ,p_hook_type => 'AP'
295: );
296: end;
297:
298: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
299: --
300: -- When in validation only mode raise the Validate_Enabled exception
301: --
302: if p_validate then

Line 318: hr_utility.trace(' ');

314: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
315: --
316: IF g_debug THEN
317:
318: hr_utility.trace(' ');
319: hr_utility.trace(' --------------------------------'||
320: '---------------------------------');
321: hr_utility.trace(' IN OUT / OUT PARAMETER '||
322: ' VALUE');

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

315: --
316: IF g_debug THEN
317:
318: hr_utility.trace(' ');
319: hr_utility.trace(' --------------------------------'||
320: '---------------------------------');
321: hr_utility.trace(' IN OUT / OUT PARAMETER '||
322: ' VALUE');
323: hr_utility.trace(' --------------------------------'||

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

317:
318: hr_utility.trace(' ');
319: hr_utility.trace(' --------------------------------'||
320: '---------------------------------');
321: hr_utility.trace(' IN OUT / OUT PARAMETER '||
322: ' VALUE');
323: hr_utility.trace(' --------------------------------'||
324: '+--------------------------------');
325: hr_utility.trace(' p_scorecard_id '||

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

319: hr_utility.trace(' --------------------------------'||
320: '---------------------------------');
321: hr_utility.trace(' IN OUT / OUT PARAMETER '||
322: ' VALUE');
323: hr_utility.trace(' --------------------------------'||
324: '+--------------------------------');
325: hr_utility.trace(' p_scorecard_id '||
326: to_char(p_scorecard_id));
327: hr_utility.trace(' p_object_version_number '||

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

321: hr_utility.trace(' IN OUT / OUT PARAMETER '||
322: ' VALUE');
323: hr_utility.trace(' --------------------------------'||
324: '+--------------------------------');
325: hr_utility.trace(' p_scorecard_id '||
326: to_char(p_scorecard_id));
327: hr_utility.trace(' p_object_version_number '||
328: to_char(p_object_version_number));
329: hr_utility.trace(' p_status_code '||

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

323: hr_utility.trace(' --------------------------------'||
324: '+--------------------------------');
325: hr_utility.trace(' p_scorecard_id '||
326: to_char(p_scorecard_id));
327: hr_utility.trace(' p_object_version_number '||
328: to_char(p_object_version_number));
329: hr_utility.trace(' p_status_code '||
330: p_status_code);
331: IF p_duplicate_name_warning THEN

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

325: hr_utility.trace(' p_scorecard_id '||
326: to_char(p_scorecard_id));
327: hr_utility.trace(' p_object_version_number '||
328: to_char(p_object_version_number));
329: hr_utility.trace(' p_status_code '||
330: p_status_code);
331: IF p_duplicate_name_warning THEN
332: hr_utility.trace(' p_duplicate_name_warning '||
333: 'TRUE');

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

328: to_char(p_object_version_number));
329: hr_utility.trace(' p_status_code '||
330: p_status_code);
331: IF p_duplicate_name_warning THEN
332: hr_utility.trace(' p_duplicate_name_warning '||
333: 'TRUE');
334: ELSE
335: hr_utility.trace(' p_duplicate_name_warning '||
336: 'FALSE');

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

331: IF p_duplicate_name_warning THEN
332: hr_utility.trace(' p_duplicate_name_warning '||
333: 'TRUE');
334: ELSE
335: hr_utility.trace(' p_duplicate_name_warning '||
336: 'FALSE');
337: END IF;
338: hr_utility.trace(' --------------------------------'||
339: '---------------------------------');

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

334: ELSE
335: hr_utility.trace(' p_duplicate_name_warning '||
336: 'FALSE');
337: END IF;
338: hr_utility.trace(' --------------------------------'||
339: '---------------------------------');
340: hr_utility.trace(' ');
341: hr_utility.set_location(' Leaving:'||l_proc, 970);
342:

Line 340: hr_utility.trace(' ');

336: 'FALSE');
337: END IF;
338: hr_utility.trace(' --------------------------------'||
339: '---------------------------------');
340: hr_utility.trace(' ');
341: hr_utility.set_location(' Leaving:'||l_proc, 970);
342:
343: END IF;
344:

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

337: END IF;
338: hr_utility.trace(' --------------------------------'||
339: '---------------------------------');
340: hr_utility.trace(' ');
341: hr_utility.set_location(' Leaving:'||l_proc, 970);
342:
343: END IF;
344:
345: exception

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

357: p_scorecard_id := null;
358: p_object_version_number := null;
359: --p_status_code := l_status_code;
360: p_duplicate_name_warning := l_duplicate_name_warning;
361: hr_utility.set_location(' Leaving:'||l_proc, 980);
362: when others then
363: --
364: -- A validation or unexpected error has occured
365: --

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

371: p_scorecard_id := null;
372: p_object_version_number := null;
373: --p_status_code := null;
374: p_duplicate_name_warning := null;
375: hr_utility.set_location(' Leaving:'||l_proc, 990);
376: raise;
377: end create_scorecard;
378: --
379: -- ----------------------------------------------------------------------------

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

441: begin
442:
443: IF g_debug THEN
444:
445: hr_utility.set_location('Entering:'|| l_proc, 10);
446:
447: hr_utility.trace(' ');
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');

Line 447: hr_utility.trace(' ');

443: IF g_debug THEN
444:
445: hr_utility.set_location('Entering:'|| l_proc, 10);
446:
447: hr_utility.trace(' ');
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' IN / IN OUT PARAMETER '||
451: ' VALUE');

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

444:
445: hr_utility.set_location('Entering:'|| l_proc, 10);
446:
447: hr_utility.trace(' ');
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' IN / IN OUT PARAMETER '||
451: ' VALUE');
452: hr_utility.trace(' --------------------------------'||

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

446:
447: hr_utility.trace(' ');
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' IN / IN OUT PARAMETER '||
451: ' VALUE');
452: hr_utility.trace(' --------------------------------'||
453: '+--------------------------------');
454: hr_utility.trace(' p_effective_date '||

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

448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' IN / IN OUT PARAMETER '||
451: ' VALUE');
452: hr_utility.trace(' --------------------------------'||
453: '+--------------------------------');
454: hr_utility.trace(' p_effective_date '||
455: to_char(p_effective_date));
456: hr_utility.trace(' p_scorecard_id '||

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

450: hr_utility.trace(' IN / IN OUT PARAMETER '||
451: ' VALUE');
452: hr_utility.trace(' --------------------------------'||
453: '+--------------------------------');
454: hr_utility.trace(' p_effective_date '||
455: to_char(p_effective_date));
456: hr_utility.trace(' p_scorecard_id '||
457: to_char(p_scorecard_id));
458: hr_utility.trace(' p_object_version_number '||

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

452: hr_utility.trace(' --------------------------------'||
453: '+--------------------------------');
454: hr_utility.trace(' p_effective_date '||
455: to_char(p_effective_date));
456: hr_utility.trace(' p_scorecard_id '||
457: to_char(p_scorecard_id));
458: hr_utility.trace(' p_object_version_number '||
459: to_char(p_object_version_number));
460: hr_utility.trace(' p_scorecard_name '||

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

454: hr_utility.trace(' p_effective_date '||
455: to_char(p_effective_date));
456: hr_utility.trace(' p_scorecard_id '||
457: to_char(p_scorecard_id));
458: hr_utility.trace(' p_object_version_number '||
459: to_char(p_object_version_number));
460: hr_utility.trace(' p_scorecard_name '||
461: p_scorecard_name);
462: hr_utility.trace(' p_plan_id '||

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

456: hr_utility.trace(' p_scorecard_id '||
457: to_char(p_scorecard_id));
458: hr_utility.trace(' p_object_version_number '||
459: to_char(p_object_version_number));
460: hr_utility.trace(' p_scorecard_name '||
461: p_scorecard_name);
462: hr_utility.trace(' p_plan_id '||
463: to_char(p_plan_id));
464: hr_utility.trace(' p_start_date '||

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

458: hr_utility.trace(' p_object_version_number '||
459: to_char(p_object_version_number));
460: hr_utility.trace(' p_scorecard_name '||
461: p_scorecard_name);
462: hr_utility.trace(' p_plan_id '||
463: to_char(p_plan_id));
464: hr_utility.trace(' p_start_date '||
465: to_char(p_start_date));
466: hr_utility.trace(' p_end_date '||

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

460: hr_utility.trace(' p_scorecard_name '||
461: p_scorecard_name);
462: hr_utility.trace(' p_plan_id '||
463: to_char(p_plan_id));
464: hr_utility.trace(' p_start_date '||
465: to_char(p_start_date));
466: hr_utility.trace(' p_end_date '||
467: to_char(p_end_date));
468: hr_utility.trace(' --------------------------------'||

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

462: hr_utility.trace(' p_plan_id '||
463: to_char(p_plan_id));
464: hr_utility.trace(' p_start_date '||
465: to_char(p_start_date));
466: hr_utility.trace(' p_end_date '||
467: to_char(p_end_date));
468: hr_utility.trace(' --------------------------------'||
469: '---------------------------------');
470: hr_utility.trace(' ');

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

464: hr_utility.trace(' p_start_date '||
465: to_char(p_start_date));
466: hr_utility.trace(' p_end_date '||
467: to_char(p_end_date));
468: hr_utility.trace(' --------------------------------'||
469: '---------------------------------');
470: hr_utility.trace(' ');
471:
472: END IF;

Line 470: hr_utility.trace(' ');

466: hr_utility.trace(' p_end_date '||
467: to_char(p_end_date));
468: hr_utility.trace(' --------------------------------'||
469: '---------------------------------');
470: hr_utility.trace(' ');
471:
472: END IF;
473:
474: --

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

543:
544: --
545: -- Process Logic
546: --
547: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
548:
549: per_pms_upd.upd
550: (p_effective_date => l_effective_date
551: ,p_scorecard_id => p_scorecard_id

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

652: ,p_hook_type => 'AP'
653: );
654: end;
655:
656: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
657: --
658: -- When in validation only mode raise the Validate_Enabled exception
659: --
660: if p_validate then

Line 674: hr_utility.trace(' ');

670: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
671: --
672: IF g_debug THEN
673:
674: hr_utility.trace(' ');
675: hr_utility.trace(' --------------------------------'||
676: '---------------------------------');
677: hr_utility.trace(' IN OUT / OUT PARAMETER '||
678: ' VALUE');

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

671: --
672: IF g_debug THEN
673:
674: hr_utility.trace(' ');
675: hr_utility.trace(' --------------------------------'||
676: '---------------------------------');
677: hr_utility.trace(' IN OUT / OUT PARAMETER '||
678: ' VALUE');
679: hr_utility.trace(' --------------------------------'||

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

673:
674: hr_utility.trace(' ');
675: hr_utility.trace(' --------------------------------'||
676: '---------------------------------');
677: hr_utility.trace(' IN OUT / OUT PARAMETER '||
678: ' VALUE');
679: hr_utility.trace(' --------------------------------'||
680: '+--------------------------------');
681: hr_utility.trace(' p_object_version_number '||

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

675: hr_utility.trace(' --------------------------------'||
676: '---------------------------------');
677: hr_utility.trace(' IN OUT / OUT PARAMETER '||
678: ' VALUE');
679: hr_utility.trace(' --------------------------------'||
680: '+--------------------------------');
681: hr_utility.trace(' p_object_version_number '||
682: to_char(p_object_version_number));
683: IF p_duplicate_name_warning THEN

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

677: hr_utility.trace(' IN OUT / OUT PARAMETER '||
678: ' VALUE');
679: hr_utility.trace(' --------------------------------'||
680: '+--------------------------------');
681: hr_utility.trace(' p_object_version_number '||
682: to_char(p_object_version_number));
683: IF p_duplicate_name_warning THEN
684: hr_utility.trace(' p_duplicate_name_warning '||
685: 'TRUE');

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

680: '+--------------------------------');
681: hr_utility.trace(' p_object_version_number '||
682: to_char(p_object_version_number));
683: IF p_duplicate_name_warning THEN
684: hr_utility.trace(' p_duplicate_name_warning '||
685: 'TRUE');
686: ELSE
687: hr_utility.trace(' p_duplicate_name_warning '||
688: 'FALSE');

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

683: IF p_duplicate_name_warning THEN
684: hr_utility.trace(' p_duplicate_name_warning '||
685: 'TRUE');
686: ELSE
687: hr_utility.trace(' p_duplicate_name_warning '||
688: 'FALSE');
689: END IF;
690: hr_utility.trace(' --------------------------------'||
691: '---------------------------------');

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

686: ELSE
687: hr_utility.trace(' p_duplicate_name_warning '||
688: 'FALSE');
689: END IF;
690: hr_utility.trace(' --------------------------------'||
691: '---------------------------------');
692: hr_utility.trace(' ');
693: hr_utility.set_location(' Leaving:'||l_proc, 970);
694:

Line 692: hr_utility.trace(' ');

688: 'FALSE');
689: END IF;
690: hr_utility.trace(' --------------------------------'||
691: '---------------------------------');
692: hr_utility.trace(' ');
693: hr_utility.set_location(' Leaving:'||l_proc, 970);
694:
695: END IF;
696:

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

689: END IF;
690: hr_utility.trace(' --------------------------------'||
691: '---------------------------------');
692: hr_utility.trace(' ');
693: hr_utility.set_location(' Leaving:'||l_proc, 970);
694:
695: END IF;
696:
697: exception

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

707: -- when validation only mode is being used.)
708: --
709: p_object_version_number := null;
710: p_duplicate_name_warning := l_duplicate_name_warning;
711: hr_utility.set_location(' Leaving:'||l_proc, 980);
712: when others then
713: --
714: -- A validation or unexpected error has occured
715: --

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

719: -- OUT parameters, including warnings, to null
720: --
721: p_object_version_number := null;
722: p_duplicate_name_warning := null;
723: hr_utility.set_location(' Leaving:'||l_proc, 990);
724: raise;
725: end update_scorecard;
726: --
727: -- ----------------------------------------------------------------------------

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

746: begin
747:
748: IF g_debug THEN
749:
750: hr_utility.set_location('Entering:'|| l_proc, 10);
751:
752: hr_utility.trace(' ');
753: hr_utility.trace(' --------------------------------'||
754: '---------------------------------');

Line 752: hr_utility.trace(' ');

748: IF g_debug THEN
749:
750: hr_utility.set_location('Entering:'|| l_proc, 10);
751:
752: hr_utility.trace(' ');
753: hr_utility.trace(' --------------------------------'||
754: '---------------------------------');
755: hr_utility.trace(' IN / IN OUT PARAMETER '||
756: ' VALUE');

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

749:
750: hr_utility.set_location('Entering:'|| l_proc, 10);
751:
752: hr_utility.trace(' ');
753: hr_utility.trace(' --------------------------------'||
754: '---------------------------------');
755: hr_utility.trace(' IN / IN OUT PARAMETER '||
756: ' VALUE');
757: hr_utility.trace(' --------------------------------'||

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

751:
752: hr_utility.trace(' ');
753: hr_utility.trace(' --------------------------------'||
754: '---------------------------------');
755: hr_utility.trace(' IN / IN OUT PARAMETER '||
756: ' VALUE');
757: hr_utility.trace(' --------------------------------'||
758: '+--------------------------------');
759: hr_utility.trace(' p_effective_date '||

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

753: hr_utility.trace(' --------------------------------'||
754: '---------------------------------');
755: hr_utility.trace(' IN / IN OUT PARAMETER '||
756: ' VALUE');
757: hr_utility.trace(' --------------------------------'||
758: '+--------------------------------');
759: hr_utility.trace(' p_effective_date '||
760: to_char(p_effective_date));
761: hr_utility.trace(' p_scorecard_id '||

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

755: hr_utility.trace(' IN / IN OUT PARAMETER '||
756: ' VALUE');
757: hr_utility.trace(' --------------------------------'||
758: '+--------------------------------');
759: hr_utility.trace(' p_effective_date '||
760: to_char(p_effective_date));
761: hr_utility.trace(' p_scorecard_id '||
762: to_char(p_scorecard_id));
763: hr_utility.trace(' p_object_version_number '||

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

757: hr_utility.trace(' --------------------------------'||
758: '+--------------------------------');
759: hr_utility.trace(' p_effective_date '||
760: to_char(p_effective_date));
761: hr_utility.trace(' p_scorecard_id '||
762: to_char(p_scorecard_id));
763: hr_utility.trace(' p_object_version_number '||
764: to_char(p_object_version_number));
765: hr_utility.trace(' p_status_code '||

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

759: hr_utility.trace(' p_effective_date '||
760: to_char(p_effective_date));
761: hr_utility.trace(' p_scorecard_id '||
762: to_char(p_scorecard_id));
763: hr_utility.trace(' p_object_version_number '||
764: to_char(p_object_version_number));
765: hr_utility.trace(' p_status_code '||
766: p_status_code);
767: hr_utility.trace(' --------------------------------'||

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

761: hr_utility.trace(' p_scorecard_id '||
762: to_char(p_scorecard_id));
763: hr_utility.trace(' p_object_version_number '||
764: to_char(p_object_version_number));
765: hr_utility.trace(' p_status_code '||
766: p_status_code);
767: hr_utility.trace(' --------------------------------'||
768: '---------------------------------');
769: hr_utility.trace(' ');

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

763: hr_utility.trace(' p_object_version_number '||
764: to_char(p_object_version_number));
765: hr_utility.trace(' p_status_code '||
766: p_status_code);
767: hr_utility.trace(' --------------------------------'||
768: '---------------------------------');
769: hr_utility.trace(' ');
770:
771: END IF;

Line 769: hr_utility.trace(' ');

765: hr_utility.trace(' p_status_code '||
766: p_status_code);
767: hr_utility.trace(' --------------------------------'||
768: '---------------------------------');
769: hr_utility.trace(' ');
770:
771: END IF;
772:
773: --

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

800:
801: --
802: -- Process Logic
803: --
804: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
805:
806: per_pms_upd.upd
807: (p_effective_date => l_effective_date
808: ,p_scorecard_id => p_scorecard_id

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

828: ,p_hook_type => 'AP'
829: );
830: end;
831:
832: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
833: --
834: -- When in validation only mode raise the Validate_Enabled exception
835: --
836: if p_validate then

Line 849: hr_utility.trace(' ');

845: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
846: --
847: IF g_debug THEN
848:
849: hr_utility.trace(' ');
850: hr_utility.trace(' --------------------------------'||
851: '---------------------------------');
852: hr_utility.trace(' IN OUT / OUT PARAMETER '||
853: ' VALUE');

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

846: --
847: IF g_debug THEN
848:
849: hr_utility.trace(' ');
850: hr_utility.trace(' --------------------------------'||
851: '---------------------------------');
852: hr_utility.trace(' IN OUT / OUT PARAMETER '||
853: ' VALUE');
854: hr_utility.trace(' --------------------------------'||

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

848:
849: hr_utility.trace(' ');
850: hr_utility.trace(' --------------------------------'||
851: '---------------------------------');
852: hr_utility.trace(' IN OUT / OUT PARAMETER '||
853: ' VALUE');
854: hr_utility.trace(' --------------------------------'||
855: '+--------------------------------');
856: hr_utility.trace(' p_object_version_number '||

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

850: hr_utility.trace(' --------------------------------'||
851: '---------------------------------');
852: hr_utility.trace(' IN OUT / OUT PARAMETER '||
853: ' VALUE');
854: hr_utility.trace(' --------------------------------'||
855: '+--------------------------------');
856: hr_utility.trace(' p_object_version_number '||
857: to_char(p_object_version_number));
858: hr_utility.trace(' --------------------------------'||

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

852: hr_utility.trace(' IN OUT / OUT PARAMETER '||
853: ' VALUE');
854: hr_utility.trace(' --------------------------------'||
855: '+--------------------------------');
856: hr_utility.trace(' p_object_version_number '||
857: to_char(p_object_version_number));
858: hr_utility.trace(' --------------------------------'||
859: '---------------------------------');
860: hr_utility.trace(' ');

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

854: hr_utility.trace(' --------------------------------'||
855: '+--------------------------------');
856: hr_utility.trace(' p_object_version_number '||
857: to_char(p_object_version_number));
858: hr_utility.trace(' --------------------------------'||
859: '---------------------------------');
860: hr_utility.trace(' ');
861:
862: END IF;

Line 860: hr_utility.trace(' ');

856: hr_utility.trace(' p_object_version_number '||
857: to_char(p_object_version_number));
858: hr_utility.trace(' --------------------------------'||
859: '---------------------------------');
860: hr_utility.trace(' ');
861:
862: END IF;
863:
864: exception

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

876: -- (Any key or derived arguments must be set to null
877: -- when validation only mode is being used.)
878: --
879: p_object_version_number := null;
880: hr_utility.set_location(' Leaving:'||l_proc, 980);
881: when others then
882: --
883: -- A validation or unexpected error has occured
884: --

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

887: -- Reset IN OUT parameters and set all
888: -- OUT parameters, including warnings, to null
889: --
890: p_object_version_number := null;
891: hr_utility.set_location(' Leaving:'||l_proc, 990);
892: raise;
893: end update_scorecard_status;
894: --
895: -- ----------------------------------------------------------------------------

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

911: begin
912:
913: IF g_debug THEN
914:
915: hr_utility.set_location('Entering:'|| l_proc, 10);
916:
917: hr_utility.trace(' ');
918: hr_utility.trace(' --------------------------------'||
919: '---------------------------------');

Line 917: hr_utility.trace(' ');

913: IF g_debug THEN
914:
915: hr_utility.set_location('Entering:'|| l_proc, 10);
916:
917: hr_utility.trace(' ');
918: hr_utility.trace(' --------------------------------'||
919: '---------------------------------');
920: hr_utility.trace(' IN / IN OUT PARAMETER '||
921: ' VALUE');

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

914:
915: hr_utility.set_location('Entering:'|| l_proc, 10);
916:
917: hr_utility.trace(' ');
918: hr_utility.trace(' --------------------------------'||
919: '---------------------------------');
920: hr_utility.trace(' IN / IN OUT PARAMETER '||
921: ' VALUE');
922: hr_utility.trace(' --------------------------------'||

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

916:
917: hr_utility.trace(' ');
918: hr_utility.trace(' --------------------------------'||
919: '---------------------------------');
920: hr_utility.trace(' IN / IN OUT PARAMETER '||
921: ' VALUE');
922: hr_utility.trace(' --------------------------------'||
923: '+--------------------------------');
924: hr_utility.trace(' p_scorecard_id '||

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

918: hr_utility.trace(' --------------------------------'||
919: '---------------------------------');
920: hr_utility.trace(' IN / IN OUT PARAMETER '||
921: ' VALUE');
922: hr_utility.trace(' --------------------------------'||
923: '+--------------------------------');
924: hr_utility.trace(' p_scorecard_id '||
925: to_char(p_scorecard_id));
926: hr_utility.trace(' p_object_version_number '||

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

920: hr_utility.trace(' IN / IN OUT PARAMETER '||
921: ' VALUE');
922: hr_utility.trace(' --------------------------------'||
923: '+--------------------------------');
924: hr_utility.trace(' p_scorecard_id '||
925: to_char(p_scorecard_id));
926: hr_utility.trace(' p_object_version_number '||
927: to_char(p_object_version_number));
928: hr_utility.trace(' --------------------------------'||

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

922: hr_utility.trace(' --------------------------------'||
923: '+--------------------------------');
924: hr_utility.trace(' p_scorecard_id '||
925: to_char(p_scorecard_id));
926: hr_utility.trace(' p_object_version_number '||
927: to_char(p_object_version_number));
928: hr_utility.trace(' --------------------------------'||
929: '---------------------------------');
930: hr_utility.trace(' ');

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

924: hr_utility.trace(' p_scorecard_id '||
925: to_char(p_scorecard_id));
926: hr_utility.trace(' p_object_version_number '||
927: to_char(p_object_version_number));
928: hr_utility.trace(' --------------------------------'||
929: '---------------------------------');
930: hr_utility.trace(' ');
931:
932: END IF;

Line 930: hr_utility.trace(' ');

926: hr_utility.trace(' p_object_version_number '||
927: to_char(p_object_version_number));
928: hr_utility.trace(' --------------------------------'||
929: '---------------------------------');
930: hr_utility.trace(' ');
931:
932: END IF;
933:
934: --

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

954:
955: --
956: -- Process Logic
957: --
958: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
959:
960: per_pms_del.del
961: (p_scorecard_id => p_scorecard_id
962: ,p_object_version_number => p_object_version_number

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

979: ,p_hook_type => 'AP'
980: );
981: end;
982:
983: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
984: --
985: -- When in validation only mode raise the Validate_Enabled exception
986: --
987: if p_validate then

Line 1000: hr_utility.trace(' ');

996: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
997: --
998: IF g_debug THEN
999:
1000: hr_utility.trace(' ');
1001: hr_utility.trace(' --------------------------------'||
1002: '---------------------------------');
1003: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1004: ' VALUE');

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

997: --
998: IF g_debug THEN
999:
1000: hr_utility.trace(' ');
1001: hr_utility.trace(' --------------------------------'||
1002: '---------------------------------');
1003: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1004: ' VALUE');
1005: hr_utility.trace(' --------------------------------'||

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

999:
1000: hr_utility.trace(' ');
1001: hr_utility.trace(' --------------------------------'||
1002: '---------------------------------');
1003: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1004: ' VALUE');
1005: hr_utility.trace(' --------------------------------'||
1006: '+--------------------------------');
1007: hr_utility.trace(' p_object_version_number '||

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

1001: hr_utility.trace(' --------------------------------'||
1002: '---------------------------------');
1003: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1004: ' VALUE');
1005: hr_utility.trace(' --------------------------------'||
1006: '+--------------------------------');
1007: hr_utility.trace(' p_object_version_number '||
1008: to_char(p_object_version_number));
1009: IF p_created_by_plan_warning THEN

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

1003: hr_utility.trace(' IN OUT / OUT PARAMETER '||
1004: ' VALUE');
1005: hr_utility.trace(' --------------------------------'||
1006: '+--------------------------------');
1007: hr_utility.trace(' p_object_version_number '||
1008: to_char(p_object_version_number));
1009: IF p_created_by_plan_warning THEN
1010: hr_utility.trace(' p_created_by_plan_warning '||
1011: 'TRUE');

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

1006: '+--------------------------------');
1007: hr_utility.trace(' p_object_version_number '||
1008: to_char(p_object_version_number));
1009: IF p_created_by_plan_warning THEN
1010: hr_utility.trace(' p_created_by_plan_warning '||
1011: 'TRUE');
1012: ELSE
1013: hr_utility.trace(' p_created_by_plan_warning '||
1014: 'FALSE');

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

1009: IF p_created_by_plan_warning THEN
1010: hr_utility.trace(' p_created_by_plan_warning '||
1011: 'TRUE');
1012: ELSE
1013: hr_utility.trace(' p_created_by_plan_warning '||
1014: 'FALSE');
1015: END IF;
1016: hr_utility.trace(' --------------------------------'||
1017: '---------------------------------');

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

1012: ELSE
1013: hr_utility.trace(' p_created_by_plan_warning '||
1014: 'FALSE');
1015: END IF;
1016: hr_utility.trace(' --------------------------------'||
1017: '---------------------------------');
1018: hr_utility.trace(' ');
1019: hr_utility.set_location(' Leaving:'||l_proc, 970);
1020:

Line 1018: hr_utility.trace(' ');

1014: 'FALSE');
1015: END IF;
1016: hr_utility.trace(' --------------------------------'||
1017: '---------------------------------');
1018: hr_utility.trace(' ');
1019: hr_utility.set_location(' Leaving:'||l_proc, 970);
1020:
1021: END IF;
1022:

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

1015: END IF;
1016: hr_utility.trace(' --------------------------------'||
1017: '---------------------------------');
1018: hr_utility.trace(' ');
1019: hr_utility.set_location(' Leaving:'||l_proc, 970);
1020:
1021: END IF;
1022:
1023: exception

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

1032: -- (Any key or derived arguments must be set to null
1033: -- when validation only mode is being used.)
1034: --
1035: p_created_by_plan_warning := l_created_by_plan_warning;
1036: hr_utility.set_location(' Leaving:'||l_proc, 980);
1037: when others then
1038: --
1039: -- A validation or unexpected error has occured
1040: --

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

1043: -- Reset IN OUT parameters and set all
1044: -- OUT parameters, including warnings, to null
1045: --
1046: p_created_by_plan_warning := null;
1047: hr_utility.set_location(' Leaving:'||l_proc, 990);
1048: raise;
1049: end delete_scorecard;
1050: --
1051: end hr_personal_scorecard_api;