DBA Data[Home] [Help]

APPS.HR_OBJECTIVE_LIBRARY_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_objective_library_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-----------------------< Create_Library_Objective >-----------------------|
11: -- ----------------------------------------------------------------------------

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

111: begin
112:
113: IF g_debug THEN
114:
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116:
117: hr_utility.trace(' ');
118: hr_utility.trace(' --------------------------------'||
119: '---------------------------------');

Line 117: hr_utility.trace(' ');

113: IF g_debug THEN
114:
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116:
117: hr_utility.trace(' ');
118: hr_utility.trace(' --------------------------------'||
119: '---------------------------------');
120: hr_utility.trace(' IN / IN OUT PARAMETER '||
121: ' VALUE');

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

114:
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116:
117: hr_utility.trace(' ');
118: hr_utility.trace(' --------------------------------'||
119: '---------------------------------');
120: hr_utility.trace(' IN / IN OUT PARAMETER '||
121: ' VALUE');
122: hr_utility.trace(' --------------------------------'||

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

116:
117: hr_utility.trace(' ');
118: hr_utility.trace(' --------------------------------'||
119: '---------------------------------');
120: hr_utility.trace(' IN / IN OUT PARAMETER '||
121: ' VALUE');
122: hr_utility.trace(' --------------------------------'||
123: '+--------------------------------');
124: hr_utility.trace(' p_effective_date '||

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

118: hr_utility.trace(' --------------------------------'||
119: '---------------------------------');
120: hr_utility.trace(' IN / IN OUT PARAMETER '||
121: ' VALUE');
122: hr_utility.trace(' --------------------------------'||
123: '+--------------------------------');
124: hr_utility.trace(' p_effective_date '||
125: to_char(p_effective_date));
126: hr_utility.trace(' p_objective_name '||

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

120: hr_utility.trace(' IN / IN OUT PARAMETER '||
121: ' VALUE');
122: hr_utility.trace(' --------------------------------'||
123: '+--------------------------------');
124: hr_utility.trace(' p_effective_date '||
125: to_char(p_effective_date));
126: hr_utility.trace(' p_objective_name '||
127: p_objective_name);
128: hr_utility.trace(' p_valid_from '||

Line 126: hr_utility.trace(' p_objective_name '||

122: hr_utility.trace(' --------------------------------'||
123: '+--------------------------------');
124: hr_utility.trace(' p_effective_date '||
125: to_char(p_effective_date));
126: hr_utility.trace(' p_objective_name '||
127: p_objective_name);
128: hr_utility.trace(' p_valid_from '||
129: to_char(p_valid_from));
130: hr_utility.trace(' p_valid_to '||

Line 128: hr_utility.trace(' p_valid_from '||

124: hr_utility.trace(' p_effective_date '||
125: to_char(p_effective_date));
126: hr_utility.trace(' p_objective_name '||
127: p_objective_name);
128: hr_utility.trace(' p_valid_from '||
129: to_char(p_valid_from));
130: hr_utility.trace(' p_valid_to '||
131: to_char(p_valid_to));
132: hr_utility.trace(' p_target_date '||

Line 130: hr_utility.trace(' p_valid_to '||

126: hr_utility.trace(' p_objective_name '||
127: p_objective_name);
128: hr_utility.trace(' p_valid_from '||
129: to_char(p_valid_from));
130: hr_utility.trace(' p_valid_to '||
131: to_char(p_valid_to));
132: hr_utility.trace(' p_target_date '||
133: to_char(p_target_date));
134: hr_utility.trace(' p_next_review_date '||

Line 132: hr_utility.trace(' p_target_date '||

128: hr_utility.trace(' p_valid_from '||
129: to_char(p_valid_from));
130: hr_utility.trace(' p_valid_to '||
131: to_char(p_valid_to));
132: hr_utility.trace(' p_target_date '||
133: to_char(p_target_date));
134: hr_utility.trace(' p_next_review_date '||
135: to_char(p_next_review_date));
136: hr_utility.trace(' p_group_code '||

Line 134: hr_utility.trace(' p_next_review_date '||

130: hr_utility.trace(' p_valid_to '||
131: to_char(p_valid_to));
132: hr_utility.trace(' p_target_date '||
133: to_char(p_target_date));
134: hr_utility.trace(' p_next_review_date '||
135: to_char(p_next_review_date));
136: hr_utility.trace(' p_group_code '||
137: p_group_code);
138: hr_utility.trace(' p_priority_code '||

Line 136: hr_utility.trace(' p_group_code '||

132: hr_utility.trace(' p_target_date '||
133: to_char(p_target_date));
134: hr_utility.trace(' p_next_review_date '||
135: to_char(p_next_review_date));
136: hr_utility.trace(' p_group_code '||
137: p_group_code);
138: hr_utility.trace(' p_priority_code '||
139: p_priority_code);
140: hr_utility.trace(' p_appraise_flag '||

Line 138: hr_utility.trace(' p_priority_code '||

134: hr_utility.trace(' p_next_review_date '||
135: to_char(p_next_review_date));
136: hr_utility.trace(' p_group_code '||
137: p_group_code);
138: hr_utility.trace(' p_priority_code '||
139: p_priority_code);
140: hr_utility.trace(' p_appraise_flag '||
141: p_appraise_flag);
142: hr_utility.trace(' p_weighting_percent '||

Line 140: hr_utility.trace(' p_appraise_flag '||

136: hr_utility.trace(' p_group_code '||
137: p_group_code);
138: hr_utility.trace(' p_priority_code '||
139: p_priority_code);
140: hr_utility.trace(' p_appraise_flag '||
141: p_appraise_flag);
142: hr_utility.trace(' p_weighting_percent '||
143: to_char(p_weighting_percent));
144: hr_utility.trace(' p_measurement_style_code '||

Line 142: hr_utility.trace(' p_weighting_percent '||

138: hr_utility.trace(' p_priority_code '||
139: p_priority_code);
140: hr_utility.trace(' p_appraise_flag '||
141: p_appraise_flag);
142: hr_utility.trace(' p_weighting_percent '||
143: to_char(p_weighting_percent));
144: hr_utility.trace(' p_measurement_style_code '||
145: p_measurement_style_code);
146: hr_utility.trace(' p_measure_name '||

Line 144: hr_utility.trace(' p_measurement_style_code '||

140: hr_utility.trace(' p_appraise_flag '||
141: p_appraise_flag);
142: hr_utility.trace(' p_weighting_percent '||
143: to_char(p_weighting_percent));
144: hr_utility.trace(' p_measurement_style_code '||
145: p_measurement_style_code);
146: hr_utility.trace(' p_measure_name '||
147: p_measure_name);
148: hr_utility.trace(' p_target_value '||

Line 146: hr_utility.trace(' p_measure_name '||

142: hr_utility.trace(' p_weighting_percent '||
143: to_char(p_weighting_percent));
144: hr_utility.trace(' p_measurement_style_code '||
145: p_measurement_style_code);
146: hr_utility.trace(' p_measure_name '||
147: p_measure_name);
148: hr_utility.trace(' p_target_value '||
149: to_char(p_target_value));
150: hr_utility.trace(' p_uom_code '||

Line 148: hr_utility.trace(' p_target_value '||

144: hr_utility.trace(' p_measurement_style_code '||
145: p_measurement_style_code);
146: hr_utility.trace(' p_measure_name '||
147: p_measure_name);
148: hr_utility.trace(' p_target_value '||
149: to_char(p_target_value));
150: hr_utility.trace(' p_uom_code '||
151: p_uom_code);
152: hr_utility.trace(' p_measure_type_code '||

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

146: hr_utility.trace(' p_measure_name '||
147: p_measure_name);
148: hr_utility.trace(' p_target_value '||
149: to_char(p_target_value));
150: hr_utility.trace(' p_uom_code '||
151: p_uom_code);
152: hr_utility.trace(' p_measure_type_code '||
153: p_measure_type_code);
154: hr_utility.trace(' p_measure_comments '||

Line 152: hr_utility.trace(' p_measure_type_code '||

148: hr_utility.trace(' p_target_value '||
149: to_char(p_target_value));
150: hr_utility.trace(' p_uom_code '||
151: p_uom_code);
152: hr_utility.trace(' p_measure_type_code '||
153: p_measure_type_code);
154: hr_utility.trace(' p_measure_comments '||
155: p_measure_comments);
156: hr_utility.trace(' p_eligibility_type_code '||

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

150: hr_utility.trace(' p_uom_code '||
151: p_uom_code);
152: hr_utility.trace(' p_measure_type_code '||
153: p_measure_type_code);
154: hr_utility.trace(' p_measure_comments '||
155: p_measure_comments);
156: hr_utility.trace(' p_eligibility_type_code '||
157: p_eligibility_type_code);
158: hr_utility.trace(' p_details '||

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

152: hr_utility.trace(' p_measure_type_code '||
153: p_measure_type_code);
154: hr_utility.trace(' p_measure_comments '||
155: p_measure_comments);
156: hr_utility.trace(' p_eligibility_type_code '||
157: p_eligibility_type_code);
158: hr_utility.trace(' p_details '||
159: p_details);
160: hr_utility.trace(' p_success_criteria '||

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

154: hr_utility.trace(' p_measure_comments '||
155: p_measure_comments);
156: hr_utility.trace(' p_eligibility_type_code '||
157: p_eligibility_type_code);
158: hr_utility.trace(' p_details '||
159: p_details);
160: hr_utility.trace(' p_success_criteria '||
161: p_success_criteria);
162: hr_utility.trace(' p_comments '||

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

156: hr_utility.trace(' p_eligibility_type_code '||
157: p_eligibility_type_code);
158: hr_utility.trace(' p_details '||
159: p_details);
160: hr_utility.trace(' p_success_criteria '||
161: p_success_criteria);
162: hr_utility.trace(' p_comments '||
163: p_comments);
164: hr_utility.trace(' --------------------------------'||

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

158: hr_utility.trace(' p_details '||
159: p_details);
160: hr_utility.trace(' p_success_criteria '||
161: p_success_criteria);
162: hr_utility.trace(' p_comments '||
163: p_comments);
164: hr_utility.trace(' --------------------------------'||
165: '---------------------------------');
166: hr_utility.trace(' ');

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

160: hr_utility.trace(' p_success_criteria '||
161: p_success_criteria);
162: hr_utility.trace(' p_comments '||
163: p_comments);
164: hr_utility.trace(' --------------------------------'||
165: '---------------------------------');
166: hr_utility.trace(' ');
167:
168: END IF;

Line 166: hr_utility.trace(' ');

162: hr_utility.trace(' p_comments '||
163: p_comments);
164: hr_utility.trace(' --------------------------------'||
165: '---------------------------------');
166: hr_utility.trace(' ');
167:
168: END IF;
169:
170: --

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

249: end;
250: --
251: -- End of Before Process User Hook call
252: --
253: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
254:
255: --
256: -- Call the row handler insert
257: --

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

313: ,p_weighting_over_100_warning => l_weighting_over_100_warning
314: ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
315: );
316:
317: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
318:
319: --
320: -- Call After Process User Hook
321: --

Line 393: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;

389: );
390:
391: end;
392:
393: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
394:
395: --
396: -- End of After Process User Hook call
397: --

Line 416: hr_utility.trace(' ');

412:
413:
414: IF g_debug THEN
415:
416: hr_utility.trace(' ');
417: hr_utility.trace(' --------------------------------'||
418: '---------------------------------');
419: hr_utility.trace(' IN OUT / OUT PARAMETER '||
420: ' VALUE');

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

413:
414: IF g_debug THEN
415:
416: hr_utility.trace(' ');
417: hr_utility.trace(' --------------------------------'||
418: '---------------------------------');
419: hr_utility.trace(' IN OUT / OUT PARAMETER '||
420: ' VALUE');
421: hr_utility.trace(' --------------------------------'||

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

415:
416: hr_utility.trace(' ');
417: hr_utility.trace(' --------------------------------'||
418: '---------------------------------');
419: hr_utility.trace(' IN OUT / OUT PARAMETER '||
420: ' VALUE');
421: hr_utility.trace(' --------------------------------'||
422: '+--------------------------------');
423: hr_utility.trace(' p_objective_id '||

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

417: hr_utility.trace(' --------------------------------'||
418: '---------------------------------');
419: hr_utility.trace(' IN OUT / OUT PARAMETER '||
420: ' VALUE');
421: hr_utility.trace(' --------------------------------'||
422: '+--------------------------------');
423: hr_utility.trace(' p_objective_id '||
424: to_char(p_objective_id));
425: hr_utility.trace(' p_object_version_number '||

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

419: hr_utility.trace(' IN OUT / OUT PARAMETER '||
420: ' VALUE');
421: hr_utility.trace(' --------------------------------'||
422: '+--------------------------------');
423: hr_utility.trace(' p_objective_id '||
424: to_char(p_objective_id));
425: hr_utility.trace(' p_object_version_number '||
426: to_char(p_object_version_number));
427: IF p_duplicate_name_warning THEN

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

421: hr_utility.trace(' --------------------------------'||
422: '+--------------------------------');
423: hr_utility.trace(' p_objective_id '||
424: to_char(p_objective_id));
425: hr_utility.trace(' p_object_version_number '||
426: to_char(p_object_version_number));
427: IF p_duplicate_name_warning THEN
428: hr_utility.trace(' p_duplicate_name_warning '||
429: 'TRUE');

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

424: to_char(p_objective_id));
425: hr_utility.trace(' p_object_version_number '||
426: to_char(p_object_version_number));
427: IF p_duplicate_name_warning THEN
428: hr_utility.trace(' p_duplicate_name_warning '||
429: 'TRUE');
430: ELSE
431: hr_utility.trace(' p_duplicate_name_warning '||
432: 'FALSE');

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

427: IF p_duplicate_name_warning THEN
428: hr_utility.trace(' p_duplicate_name_warning '||
429: 'TRUE');
430: ELSE
431: hr_utility.trace(' p_duplicate_name_warning '||
432: 'FALSE');
433: END IF;
434: IF p_weighting_over_100_warning THEN
435: hr_utility.trace(' p_weighting_over_100_warning '||

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

431: hr_utility.trace(' p_duplicate_name_warning '||
432: 'FALSE');
433: END IF;
434: IF p_weighting_over_100_warning THEN
435: hr_utility.trace(' p_weighting_over_100_warning '||
436: 'TRUE');
437: ELSE
438: hr_utility.trace(' p_weighting_over_100_warning '||
439: 'FALSE');

Line 438: hr_utility.trace(' p_weighting_over_100_warning '||

434: IF p_weighting_over_100_warning THEN
435: hr_utility.trace(' p_weighting_over_100_warning '||
436: 'TRUE');
437: ELSE
438: hr_utility.trace(' p_weighting_over_100_warning '||
439: 'FALSE');
440: END IF;
441: IF p_weighting_appraisal_warning THEN
442: hr_utility.trace(' p_weighting_appraisal_warning '||

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

438: hr_utility.trace(' p_weighting_over_100_warning '||
439: 'FALSE');
440: END IF;
441: IF p_weighting_appraisal_warning THEN
442: hr_utility.trace(' p_weighting_appraisal_warning '||
443: 'TRUE');
444: ELSE
445: hr_utility.trace(' p_weighting_appraisal_warning '||
446: 'FALSE');

Line 445: hr_utility.trace(' p_weighting_appraisal_warning '||

441: IF p_weighting_appraisal_warning THEN
442: hr_utility.trace(' p_weighting_appraisal_warning '||
443: 'TRUE');
444: ELSE
445: hr_utility.trace(' p_weighting_appraisal_warning '||
446: 'FALSE');
447: END IF;
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');

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

444: ELSE
445: hr_utility.trace(' p_weighting_appraisal_warning '||
446: 'FALSE');
447: END IF;
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' ');
451: hr_utility.set_location(' Leaving:'||l_proc, 970);
452:

Line 450: hr_utility.trace(' ');

446: 'FALSE');
447: END IF;
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' ');
451: hr_utility.set_location(' Leaving:'||l_proc, 970);
452:
453: END IF;
454:

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

447: END IF;
448: hr_utility.trace(' --------------------------------'||
449: '---------------------------------');
450: hr_utility.trace(' ');
451: hr_utility.set_location(' Leaving:'||l_proc, 970);
452:
453: END IF;
454:
455: exception

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

470: p_weighting_over_100_warning := l_weighting_over_100_warning;
471: p_weighting_appraisal_warning := l_weighting_appraisal_warning;
472:
473: --
474: hr_utility.set_location(' Leaving:'||l_proc, 980);
475: --
476: when others then
477: --
478: -- A validation or unexpected error has occured

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

487: p_duplicate_name_warning := null;
488: p_weighting_over_100_warning := null;
489: p_weighting_appraisal_warning := null;
490:
491: hr_utility.set_location(' Leaving:'||l_proc, 990);
492: raise;
493:
494: end create_library_objective;
495: --

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

599: begin
600:
601: IF g_debug THEN
602:
603: hr_utility.set_location('Entering:'|| l_proc, 10);
604:
605: hr_utility.trace(' ');
606: hr_utility.trace(' --------------------------------'||
607: '---------------------------------');

Line 605: hr_utility.trace(' ');

601: IF g_debug THEN
602:
603: hr_utility.set_location('Entering:'|| l_proc, 10);
604:
605: hr_utility.trace(' ');
606: hr_utility.trace(' --------------------------------'||
607: '---------------------------------');
608: hr_utility.trace(' IN / IN OUT PARAMETER '||
609: ' VALUE');

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

602:
603: hr_utility.set_location('Entering:'|| l_proc, 10);
604:
605: hr_utility.trace(' ');
606: hr_utility.trace(' --------------------------------'||
607: '---------------------------------');
608: hr_utility.trace(' IN / IN OUT PARAMETER '||
609: ' VALUE');
610: hr_utility.trace(' --------------------------------'||

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

604:
605: hr_utility.trace(' ');
606: hr_utility.trace(' --------------------------------'||
607: '---------------------------------');
608: hr_utility.trace(' IN / IN OUT PARAMETER '||
609: ' VALUE');
610: hr_utility.trace(' --------------------------------'||
611: '+--------------------------------');
612: hr_utility.trace(' p_effective_date '||

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

606: hr_utility.trace(' --------------------------------'||
607: '---------------------------------');
608: hr_utility.trace(' IN / IN OUT PARAMETER '||
609: ' VALUE');
610: hr_utility.trace(' --------------------------------'||
611: '+--------------------------------');
612: hr_utility.trace(' p_effective_date '||
613: to_char(p_effective_date));
614: hr_utility.trace(' p_objective_id '||

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

608: hr_utility.trace(' IN / IN OUT PARAMETER '||
609: ' VALUE');
610: hr_utility.trace(' --------------------------------'||
611: '+--------------------------------');
612: hr_utility.trace(' p_effective_date '||
613: to_char(p_effective_date));
614: hr_utility.trace(' p_objective_id '||
615: to_char(p_objective_id));
616: hr_utility.trace(' p_object_version_number '||

Line 614: hr_utility.trace(' p_objective_id '||

610: hr_utility.trace(' --------------------------------'||
611: '+--------------------------------');
612: hr_utility.trace(' p_effective_date '||
613: to_char(p_effective_date));
614: hr_utility.trace(' p_objective_id '||
615: to_char(p_objective_id));
616: hr_utility.trace(' p_object_version_number '||
617: to_char(p_object_version_number));
618: hr_utility.trace(' p_objective_name '||

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

612: hr_utility.trace(' p_effective_date '||
613: to_char(p_effective_date));
614: hr_utility.trace(' p_objective_id '||
615: to_char(p_objective_id));
616: hr_utility.trace(' p_object_version_number '||
617: to_char(p_object_version_number));
618: hr_utility.trace(' p_objective_name '||
619: p_objective_name);
620: hr_utility.trace(' p_valid_from '||

Line 618: hr_utility.trace(' p_objective_name '||

614: hr_utility.trace(' p_objective_id '||
615: to_char(p_objective_id));
616: hr_utility.trace(' p_object_version_number '||
617: to_char(p_object_version_number));
618: hr_utility.trace(' p_objective_name '||
619: p_objective_name);
620: hr_utility.trace(' p_valid_from '||
621: to_char(p_valid_from));
622: hr_utility.trace(' p_valid_to '||

Line 620: hr_utility.trace(' p_valid_from '||

616: hr_utility.trace(' p_object_version_number '||
617: to_char(p_object_version_number));
618: hr_utility.trace(' p_objective_name '||
619: p_objective_name);
620: hr_utility.trace(' p_valid_from '||
621: to_char(p_valid_from));
622: hr_utility.trace(' p_valid_to '||
623: to_char(p_valid_to));
624: hr_utility.trace(' p_target_date '||

Line 622: hr_utility.trace(' p_valid_to '||

618: hr_utility.trace(' p_objective_name '||
619: p_objective_name);
620: hr_utility.trace(' p_valid_from '||
621: to_char(p_valid_from));
622: hr_utility.trace(' p_valid_to '||
623: to_char(p_valid_to));
624: hr_utility.trace(' p_target_date '||
625: to_char(p_target_date));
626: hr_utility.trace(' p_next_review_date '||

Line 624: hr_utility.trace(' p_target_date '||

620: hr_utility.trace(' p_valid_from '||
621: to_char(p_valid_from));
622: hr_utility.trace(' p_valid_to '||
623: to_char(p_valid_to));
624: hr_utility.trace(' p_target_date '||
625: to_char(p_target_date));
626: hr_utility.trace(' p_next_review_date '||
627: to_char(p_next_review_date));
628: hr_utility.trace(' p_group_code '||

Line 626: hr_utility.trace(' p_next_review_date '||

622: hr_utility.trace(' p_valid_to '||
623: to_char(p_valid_to));
624: hr_utility.trace(' p_target_date '||
625: to_char(p_target_date));
626: hr_utility.trace(' p_next_review_date '||
627: to_char(p_next_review_date));
628: hr_utility.trace(' p_group_code '||
629: p_group_code);
630: hr_utility.trace(' p_priority_code '||

Line 628: hr_utility.trace(' p_group_code '||

624: hr_utility.trace(' p_target_date '||
625: to_char(p_target_date));
626: hr_utility.trace(' p_next_review_date '||
627: to_char(p_next_review_date));
628: hr_utility.trace(' p_group_code '||
629: p_group_code);
630: hr_utility.trace(' p_priority_code '||
631: p_priority_code);
632: hr_utility.trace(' p_appraise_flag '||

Line 630: hr_utility.trace(' p_priority_code '||

626: hr_utility.trace(' p_next_review_date '||
627: to_char(p_next_review_date));
628: hr_utility.trace(' p_group_code '||
629: p_group_code);
630: hr_utility.trace(' p_priority_code '||
631: p_priority_code);
632: hr_utility.trace(' p_appraise_flag '||
633: p_appraise_flag);
634: hr_utility.trace(' p_weighting_percent '||

Line 632: hr_utility.trace(' p_appraise_flag '||

628: hr_utility.trace(' p_group_code '||
629: p_group_code);
630: hr_utility.trace(' p_priority_code '||
631: p_priority_code);
632: hr_utility.trace(' p_appraise_flag '||
633: p_appraise_flag);
634: hr_utility.trace(' p_weighting_percent '||
635: to_char(p_weighting_percent));
636: hr_utility.trace(' p_measurement_style_code '||

Line 634: hr_utility.trace(' p_weighting_percent '||

630: hr_utility.trace(' p_priority_code '||
631: p_priority_code);
632: hr_utility.trace(' p_appraise_flag '||
633: p_appraise_flag);
634: hr_utility.trace(' p_weighting_percent '||
635: to_char(p_weighting_percent));
636: hr_utility.trace(' p_measurement_style_code '||
637: p_measurement_style_code);
638: hr_utility.trace(' p_measure_name '||

Line 636: hr_utility.trace(' p_measurement_style_code '||

632: hr_utility.trace(' p_appraise_flag '||
633: p_appraise_flag);
634: hr_utility.trace(' p_weighting_percent '||
635: to_char(p_weighting_percent));
636: hr_utility.trace(' p_measurement_style_code '||
637: p_measurement_style_code);
638: hr_utility.trace(' p_measure_name '||
639: p_measure_name);
640: hr_utility.trace(' p_target_value '||

Line 638: hr_utility.trace(' p_measure_name '||

634: hr_utility.trace(' p_weighting_percent '||
635: to_char(p_weighting_percent));
636: hr_utility.trace(' p_measurement_style_code '||
637: p_measurement_style_code);
638: hr_utility.trace(' p_measure_name '||
639: p_measure_name);
640: hr_utility.trace(' p_target_value '||
641: to_char(p_target_value));
642: hr_utility.trace(' p_uom_code '||

Line 640: hr_utility.trace(' p_target_value '||

636: hr_utility.trace(' p_measurement_style_code '||
637: p_measurement_style_code);
638: hr_utility.trace(' p_measure_name '||
639: p_measure_name);
640: hr_utility.trace(' p_target_value '||
641: to_char(p_target_value));
642: hr_utility.trace(' p_uom_code '||
643: p_uom_code);
644: hr_utility.trace(' p_measure_type_code '||

Line 642: hr_utility.trace(' p_uom_code '||

638: hr_utility.trace(' p_measure_name '||
639: p_measure_name);
640: hr_utility.trace(' p_target_value '||
641: to_char(p_target_value));
642: hr_utility.trace(' p_uom_code '||
643: p_uom_code);
644: hr_utility.trace(' p_measure_type_code '||
645: p_measure_type_code);
646: hr_utility.trace(' p_measure_comments '||

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

640: hr_utility.trace(' p_target_value '||
641: to_char(p_target_value));
642: hr_utility.trace(' p_uom_code '||
643: p_uom_code);
644: hr_utility.trace(' p_measure_type_code '||
645: p_measure_type_code);
646: hr_utility.trace(' p_measure_comments '||
647: p_measure_comments);
648: hr_utility.trace(' p_eligibility_type_code '||

Line 646: hr_utility.trace(' p_measure_comments '||

642: hr_utility.trace(' p_uom_code '||
643: p_uom_code);
644: hr_utility.trace(' p_measure_type_code '||
645: p_measure_type_code);
646: hr_utility.trace(' p_measure_comments '||
647: p_measure_comments);
648: hr_utility.trace(' p_eligibility_type_code '||
649: p_eligibility_type_code);
650: hr_utility.trace(' p_details '||

Line 648: hr_utility.trace(' p_eligibility_type_code '||

644: hr_utility.trace(' p_measure_type_code '||
645: p_measure_type_code);
646: hr_utility.trace(' p_measure_comments '||
647: p_measure_comments);
648: hr_utility.trace(' p_eligibility_type_code '||
649: p_eligibility_type_code);
650: hr_utility.trace(' p_details '||
651: p_details);
652: hr_utility.trace(' p_success_criteria '||

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

646: hr_utility.trace(' p_measure_comments '||
647: p_measure_comments);
648: hr_utility.trace(' p_eligibility_type_code '||
649: p_eligibility_type_code);
650: hr_utility.trace(' p_details '||
651: p_details);
652: hr_utility.trace(' p_success_criteria '||
653: p_success_criteria);
654: hr_utility.trace(' p_comments '||

Line 652: hr_utility.trace(' p_success_criteria '||

648: hr_utility.trace(' p_eligibility_type_code '||
649: p_eligibility_type_code);
650: hr_utility.trace(' p_details '||
651: p_details);
652: hr_utility.trace(' p_success_criteria '||
653: p_success_criteria);
654: hr_utility.trace(' p_comments '||
655: p_comments);
656: hr_utility.trace(' --------------------------------'||

Line 654: hr_utility.trace(' p_comments '||

650: hr_utility.trace(' p_details '||
651: p_details);
652: hr_utility.trace(' p_success_criteria '||
653: p_success_criteria);
654: hr_utility.trace(' p_comments '||
655: p_comments);
656: hr_utility.trace(' --------------------------------'||
657: '---------------------------------');
658: hr_utility.trace(' ');

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

652: hr_utility.trace(' p_success_criteria '||
653: p_success_criteria);
654: hr_utility.trace(' p_comments '||
655: p_comments);
656: hr_utility.trace(' --------------------------------'||
657: '---------------------------------');
658: hr_utility.trace(' ');
659:
660: END IF;

Line 658: hr_utility.trace(' ');

654: hr_utility.trace(' p_comments '||
655: p_comments);
656: hr_utility.trace(' --------------------------------'||
657: '---------------------------------');
658: hr_utility.trace(' ');
659:
660: END IF;
661:
662: --

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

749:
750: --
751: -- Process Logic
752: --
753: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
754:
755: --
756: -- Call the row handler update
757: --

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

813: ,p_weighting_over_100_warning => l_weighting_over_100_warning
814: ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
815: );
816:
817: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
818: --
819: -- Call After Process User Hook
820: --
821: begin

Line 888: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;

884: p_hook_type => 'AP'
885: );
886: end;
887:
888: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
889:
890: --
891: -- End of After Process User Hook call
892: --

Line 909: hr_utility.trace(' ');

905: p_weighting_appraisal_warning := l_weighting_appraisal_warning;
906:
907: IF g_debug THEN
908:
909: hr_utility.trace(' ');
910: hr_utility.trace(' --------------------------------'||
911: '---------------------------------');
912: hr_utility.trace(' IN OUT / OUT PARAMETER '||
913: ' VALUE');

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

906:
907: IF g_debug THEN
908:
909: hr_utility.trace(' ');
910: hr_utility.trace(' --------------------------------'||
911: '---------------------------------');
912: hr_utility.trace(' IN OUT / OUT PARAMETER '||
913: ' VALUE');
914: hr_utility.trace(' --------------------------------'||

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

908:
909: hr_utility.trace(' ');
910: hr_utility.trace(' --------------------------------'||
911: '---------------------------------');
912: hr_utility.trace(' IN OUT / OUT PARAMETER '||
913: ' VALUE');
914: hr_utility.trace(' --------------------------------'||
915: '+--------------------------------');
916: hr_utility.trace(' p_object_version_number '||

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

910: hr_utility.trace(' --------------------------------'||
911: '---------------------------------');
912: hr_utility.trace(' IN OUT / OUT PARAMETER '||
913: ' VALUE');
914: hr_utility.trace(' --------------------------------'||
915: '+--------------------------------');
916: hr_utility.trace(' p_object_version_number '||
917: to_char(p_object_version_number));
918: IF p_duplicate_name_warning THEN

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

912: hr_utility.trace(' IN OUT / OUT PARAMETER '||
913: ' VALUE');
914: hr_utility.trace(' --------------------------------'||
915: '+--------------------------------');
916: hr_utility.trace(' p_object_version_number '||
917: to_char(p_object_version_number));
918: IF p_duplicate_name_warning THEN
919: hr_utility.trace(' p_duplicate_name_warning '||
920: 'TRUE');

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

915: '+--------------------------------');
916: hr_utility.trace(' p_object_version_number '||
917: to_char(p_object_version_number));
918: IF p_duplicate_name_warning THEN
919: hr_utility.trace(' p_duplicate_name_warning '||
920: 'TRUE');
921: ELSE
922: hr_utility.trace(' p_duplicate_name_warning '||
923: 'FALSE');

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

918: IF p_duplicate_name_warning THEN
919: hr_utility.trace(' p_duplicate_name_warning '||
920: 'TRUE');
921: ELSE
922: hr_utility.trace(' p_duplicate_name_warning '||
923: 'FALSE');
924: END IF;
925: IF p_weighting_over_100_warning THEN
926: hr_utility.trace(' p_weighting_over_100_warning '||

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

922: hr_utility.trace(' p_duplicate_name_warning '||
923: 'FALSE');
924: END IF;
925: IF p_weighting_over_100_warning THEN
926: hr_utility.trace(' p_weighting_over_100_warning '||
927: 'TRUE');
928: ELSE
929: hr_utility.trace(' p_weighting_over_100_warning '||
930: 'FALSE');

Line 929: hr_utility.trace(' p_weighting_over_100_warning '||

925: IF p_weighting_over_100_warning THEN
926: hr_utility.trace(' p_weighting_over_100_warning '||
927: 'TRUE');
928: ELSE
929: hr_utility.trace(' p_weighting_over_100_warning '||
930: 'FALSE');
931: END IF;
932: IF p_weighting_appraisal_warning THEN
933: hr_utility.trace(' p_weighting_appraisal_warning '||

Line 933: hr_utility.trace(' p_weighting_appraisal_warning '||

929: hr_utility.trace(' p_weighting_over_100_warning '||
930: 'FALSE');
931: END IF;
932: IF p_weighting_appraisal_warning THEN
933: hr_utility.trace(' p_weighting_appraisal_warning '||
934: 'TRUE');
935: ELSE
936: hr_utility.trace(' p_weighting_appraisal_warning '||
937: 'FALSE');

Line 936: hr_utility.trace(' p_weighting_appraisal_warning '||

932: IF p_weighting_appraisal_warning THEN
933: hr_utility.trace(' p_weighting_appraisal_warning '||
934: 'TRUE');
935: ELSE
936: hr_utility.trace(' p_weighting_appraisal_warning '||
937: 'FALSE');
938: END IF;
939: hr_utility.trace(' --------------------------------'||
940: '---------------------------------');

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

935: ELSE
936: hr_utility.trace(' p_weighting_appraisal_warning '||
937: 'FALSE');
938: END IF;
939: hr_utility.trace(' --------------------------------'||
940: '---------------------------------');
941: hr_utility.trace(' ');
942: hr_utility.set_location(' Leaving:'||l_proc, 970);
943:

Line 941: hr_utility.trace(' ');

937: 'FALSE');
938: END IF;
939: hr_utility.trace(' --------------------------------'||
940: '---------------------------------');
941: hr_utility.trace(' ');
942: hr_utility.set_location(' Leaving:'||l_proc, 970);
943:
944: END IF;
945:

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

938: END IF;
939: hr_utility.trace(' --------------------------------'||
940: '---------------------------------');
941: hr_utility.trace(' ');
942: hr_utility.set_location(' Leaving:'||l_proc, 970);
943:
944: END IF;
945:
946: exception

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

959: p_duplicate_name_warning := l_duplicate_name_warning;
960: p_weighting_over_100_warning := l_weighting_over_100_warning;
961: p_weighting_appraisal_warning := l_weighting_appraisal_warning;
962: --
963: hr_utility.set_location(' Leaving:'||l_proc, 980);
964: --
965: when others then
966: --
967: -- A validation or unexpected error has occured

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

975: p_duplicate_name_warning := null;
976: p_weighting_over_100_warning := null;
977: p_weighting_appraisal_warning := null;
978:
979: hr_utility.set_location(' Leaving:'||l_proc, 990);
980: raise;
981:
982: end update_library_objective;
983: --

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

1024: begin
1025:
1026: IF g_debug THEN
1027:
1028: hr_utility.set_location('Entering:'|| l_proc, 10);
1029:
1030: hr_utility.trace(' ');
1031: hr_utility.trace(' --------------------------------'||
1032: '---------------------------------');

Line 1030: hr_utility.trace(' ');

1026: IF g_debug THEN
1027:
1028: hr_utility.set_location('Entering:'|| l_proc, 10);
1029:
1030: hr_utility.trace(' ');
1031: hr_utility.trace(' --------------------------------'||
1032: '---------------------------------');
1033: hr_utility.trace(' IN / IN OUT PARAMETER '||
1034: ' VALUE');

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

1027:
1028: hr_utility.set_location('Entering:'|| l_proc, 10);
1029:
1030: hr_utility.trace(' ');
1031: hr_utility.trace(' --------------------------------'||
1032: '---------------------------------');
1033: hr_utility.trace(' IN / IN OUT PARAMETER '||
1034: ' VALUE');
1035: hr_utility.trace(' --------------------------------'||

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

1029:
1030: hr_utility.trace(' ');
1031: hr_utility.trace(' --------------------------------'||
1032: '---------------------------------');
1033: hr_utility.trace(' IN / IN OUT PARAMETER '||
1034: ' VALUE');
1035: hr_utility.trace(' --------------------------------'||
1036: '+--------------------------------');
1037: hr_utility.trace(' p_objective_id '||

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

1031: hr_utility.trace(' --------------------------------'||
1032: '---------------------------------');
1033: hr_utility.trace(' IN / IN OUT PARAMETER '||
1034: ' VALUE');
1035: hr_utility.trace(' --------------------------------'||
1036: '+--------------------------------');
1037: hr_utility.trace(' p_objective_id '||
1038: to_char(p_objective_id));
1039: hr_utility.trace(' p_object_version_number '||

Line 1037: hr_utility.trace(' p_objective_id '||

1033: hr_utility.trace(' IN / IN OUT PARAMETER '||
1034: ' VALUE');
1035: hr_utility.trace(' --------------------------------'||
1036: '+--------------------------------');
1037: hr_utility.trace(' p_objective_id '||
1038: to_char(p_objective_id));
1039: hr_utility.trace(' p_object_version_number '||
1040: to_char(p_object_version_number));
1041: hr_utility.trace(' --------------------------------'||

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

1035: hr_utility.trace(' --------------------------------'||
1036: '+--------------------------------');
1037: hr_utility.trace(' p_objective_id '||
1038: to_char(p_objective_id));
1039: hr_utility.trace(' p_object_version_number '||
1040: to_char(p_object_version_number));
1041: hr_utility.trace(' --------------------------------'||
1042: '---------------------------------');
1043: hr_utility.trace(' ');

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

1037: hr_utility.trace(' p_objective_id '||
1038: to_char(p_objective_id));
1039: hr_utility.trace(' p_object_version_number '||
1040: to_char(p_object_version_number));
1041: hr_utility.trace(' --------------------------------'||
1042: '---------------------------------');
1043: hr_utility.trace(' ');
1044:
1045: END IF;

Line 1043: hr_utility.trace(' ');

1039: hr_utility.trace(' p_object_version_number '||
1040: to_char(p_object_version_number));
1041: hr_utility.trace(' --------------------------------'||
1042: '---------------------------------');
1043: hr_utility.trace(' ');
1044:
1045: END IF;
1046:
1047: --

Line 1071: hr_utility.set_location(l_proc, 7);

1067:
1068: --
1069: -- End of Before Process User Hook call
1070: --
1071: hr_utility.set_location(l_proc, 7);
1072: --
1073: -- Process Logic - Delete Objective
1074: --
1075:

Line 1081: hr_utility.set_location(l_proc, 8);

1077: (p_objective_id => p_objective_id
1078: ,p_object_version_number => p_object_version_number
1079: );
1080:
1081: hr_utility.set_location(l_proc, 8);
1082: --
1083: -- Call After Process User Hook
1084: --
1085: begin

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

1094: p_hook_type => 'AP'
1095: );
1096: end;
1097:
1098: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
1099: --
1100: -- When in validation only mode raise the Validate_Enabled exception
1101: --
1102: if p_validate then

Line 1109: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;

1105:
1106: --
1107: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1108: --
1109: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1110:
1111: exception
1112: when hr_api.validate_enabled then
1113: --

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

1119: -- Reset IN OUT parameters and set OUT parameters
1120: -- (Any key or derived arguments must be set to null
1121: -- when validation only mode is being used.)
1122: --
1123: hr_utility.set_location(' Leaving:'||l_proc, 980);
1124:
1125: when others then
1126: --
1127: -- A validation or unexpected error has occured

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

1130: --
1131: -- Reset IN OUT parameters and set all
1132: -- OUT parameters, including warnings, to null
1133: --
1134: hr_utility.set_location(' Leaving:'||l_proc, 990);
1135: raise;
1136:
1137: end delete_library_objective;
1138: --