DBA Data[Home] [Help]

APPS.HR_TEMPLATE_CANVASES_API dependencies on HR_UTILITY

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

53: l_language_code fnd_languages.language_code%TYPE;
54:
55: l_proc varchar2(72) := g_package||'copy_template_canvas';
56: begin
57: hr_utility.set_location('Entering:'|| l_proc, 10);
58: --
59: -- Issue a savepoint
60: --
61: savepoint copy_template_canvas;

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

70: --
71: l_language_code := p_language_code;
72: hr_api.validate_language_code(p_language_code => l_language_code);
73: --
74: hr_utility.set_location(l_proc, 20);
75: --
76: --
77: -- Call Before Process User Hook
78: --

Line 96: hr_utility.set_location('At:'|| l_proc, 15);

92: end;
93: --
94: -- Validation in addition to Row Handlers
95: --
96: hr_utility.set_location('At:'|| l_proc, 15);
97:
98: OPEN cur_api_val;
99: FETCH cur_api_val INTO l_temp;
100: IF (cur_api_val%NOTFOUND AND

Line 114: hr_utility.set_location('At:'|| l_proc, 20);

110: --
111: -- Process Logic
112: --
113:
114: hr_utility.set_location('At:'|| l_proc, 20);
115:
116: OPEN cur_form_canvas;
117: FETCH cur_form_canvas INTO l_form_canvas_id;
118: CLOSE cur_form_canvas;

Line 120: hr_utility.set_location('At:'|| l_proc, 25);

116: OPEN cur_form_canvas;
117: FETCH cur_form_canvas INTO l_form_canvas_id;
118: CLOSE cur_form_canvas;
119:
120: hr_utility.set_location('At:'|| l_proc, 25);
121:
122: hr_tcn_ins.ins(p_template_window_id => p_template_window_id
123: ,p_form_canvas_id => l_form_canvas_id
124: ,p_template_canvas_id => l_template_canvas_id_to

Line 127: hr_utility.set_location('At:'|| l_proc, 30);

123: ,p_form_canvas_id => l_form_canvas_id
124: ,p_template_canvas_id => l_template_canvas_id_to
125: ,p_object_version_number => l_object_version_number);
126:
127: hr_utility.set_location('At:'|| l_proc, 30);
128:
129: hr_canvas_properties_bsi.copy_canvas_property(
130: p_effective_date => TRUNC(p_effective_date)
131: ,p_template_canvas_id_from => p_template_canvas_id_from

Line 136: hr_utility.set_location('At:'|| l_proc, 35);

132: ,p_template_canvas_id_to => l_template_canvas_id_to
133: ,p_canvas_property_id => l_canvas_property_id
134: ,p_object_version_number => l_object_version_number);
135:
136: hr_utility.set_location('At:'|| l_proc, 35);
137:
138: FOR cur_rec IN cur_tmplt_tab LOOP
139: hr_template_tab_pages_api.copy_template_tab_page(
140: p_effective_date => TRUNC(p_effective_date)

Line 148: hr_utility.set_location('At:'|| l_proc, 40);

144: ,p_object_version_number => l_ovn_tab);
145: --,p_override_value_warning => l_override_value_warning);
146: END LOOP;
147:
148: hr_utility.set_location('At:'|| l_proc, 40);
149:
150: --
151: -- Call After Process User Hook
152: --

Line 170: hr_utility.set_location('At:'|| l_proc, 45);

166: end;
167: --
168: -- When in validation only mode raise the Validate_Enabled exception
169: --
170: hr_utility.set_location('At:'|| l_proc, 45);
171:
172: if p_validate then
173: raise hr_api.validate_enabled;
174: end if;

Line 181: hr_utility.set_location(' Leaving:'||l_proc, 70);

177: --
178: p_template_canvas_id_to := l_template_canvas_id_to;
179: p_object_version_number := l_object_version_number;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 70);
182: exception
183: when hr_api.validate_enabled then
184: --
185: -- As the Validate_Enabled exception has been raised

Line 196: hr_utility.set_location(' Leaving:'||l_proc, 80);

192: -- when validation only mode is being used.)
193: --
194: p_template_canvas_id_to := null;
195: p_object_version_number := null;
196: hr_utility.set_location(' Leaving:'||l_proc, 80);
197: when others then
198: --
199: -- A validation or unexpected error has occured
200: --

Line 205: hr_utility.set_location(' Leaving:'||l_proc, 90);

201: p_template_canvas_id_to := null;
202: p_object_version_number := null;
203:
204: rollback to copy_template_canvas;
205: hr_utility.set_location(' Leaving:'||l_proc, 90);
206: raise;
207: end copy_template_canvas;
208: --
209: -- ----------------------------------------------------------------------------

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

290: l_proc varchar2(72) := g_package||'create_template_canvas';
291: l_template_canvas_id number;
292: l_object_version_number number;
293: begin
294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: -- Issue a savepoint
297: --
298: savepoint create_template_canvas;

Line 357: hr_utility.set_location('At:'|| l_proc, 15);

353: end;
354: --
355: -- Validation in addition to Row Handlers
356: --
357: hr_utility.set_location('At:'|| l_proc, 15);
358:
359: OPEN cur_api_val;
360: FETCH cur_api_val INTO l_temp;
361: IF (cur_api_val%NOTFOUND AND

Line 376: hr_utility.set_location('At:'|| l_proc, 20);

372: --
373: -- Process Logic
374: --
375:
376: hr_utility.set_location('At:'|| l_proc, 20);
377:
378: hr_tcn_ins.ins(p_template_window_id => p_template_window_id
379: ,p_form_canvas_id => p_form_canvas_id
380: ,p_template_canvas_id => l_template_canvas_id

Line 383: hr_utility.set_location('At:'|| l_proc, 25);

379: ,p_form_canvas_id => p_form_canvas_id
380: ,p_template_canvas_id => l_template_canvas_id
381: ,p_object_version_number => l_object_version_number);
382:
383: hr_utility.set_location('At:'|| l_proc, 25);
384:
385: OPEN cur_canvas_type;
386: FETCH cur_canvas_type INTO l_canvas_type;
387: CLOSE cur_canvas_type;

Line 389: hr_utility.set_location('At:'|| l_proc, 30);

385: OPEN cur_canvas_type;
386: FETCH cur_canvas_type INTO l_canvas_type;
387: CLOSE cur_canvas_type;
388:
389: hr_utility.set_location('At:'|| l_proc, 30);
390:
391: IF l_canvas_type = 'CONTENT' THEN
392: OPEN cur_tmplt_window;
393: FETCH cur_tmplt_window INTO l_height , l_width;

Line 400: hr_utility.set_location('At:'|| l_proc, 35);

396: l_height := p_height;
397: l_width := p_width;
398: END IF;
399:
400: hr_utility.set_location('At:'|| l_proc, 35);
401:
402: hr_canvas_properties_bsi.copy_canvas_property(
403: p_effective_date => TRUNC(p_effective_date)
404: ,p_form_canvas_id => p_form_canvas_id

Line 445: hr_utility.set_location('At:'|| l_proc, 40);

441: ,p_information30 => p_information30
442: ,p_canvas_property_id => l_canvas_property_id
443: ,p_object_version_number => l_object_version_number);
444:
445: hr_utility.set_location('At:'|| l_proc, 40);
446:
447: --
448: -- Call After Process User Hook
449: --

Line 503: hr_utility.set_location('At:'|| l_proc, 45);

499: end;
500: --
501: -- When in validation only mode raise the Validate_Enabled exception
502: --
503: hr_utility.set_location('At:'|| l_proc, 45);
504:
505: if p_validate then
506: raise hr_api.validate_enabled;
507: end if;

Line 514: hr_utility.set_location(' Leaving:'||l_proc, 70);

510: --
511: p_template_canvas_id := l_template_canvas_id;
512: p_object_version_number := l_object_version_number;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 70);
515: exception
516: when hr_api.validate_enabled then
517: --
518: -- As the Validate_Enabled exception has been raised

Line 529: hr_utility.set_location(' Leaving:'||l_proc, 80);

525: -- when validation only mode is being used.)
526: --
527: p_template_canvas_id := null;
528: p_object_version_number := null;
529: hr_utility.set_location(' Leaving:'||l_proc, 80);
530: when others then
531: --
532: -- A validation or unexpected error has occured
533: --

Line 538: hr_utility.set_location(' Leaving:'||l_proc, 90);

534: p_template_canvas_id := null;
535: p_object_version_number := null;
536:
537: rollback to create_template_canvas;
538: hr_utility.set_location(' Leaving:'||l_proc, 90);
539: raise;
540: end create_template_canvas;
541: --
542: -- ----------------------------------------------------------------------------

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

572: AND htc.template_canvas_id = p_template_canvas_id;
573:
574: l_proc varchar2(72) := g_package||'delete_template_canvas';
575: begin
576: hr_utility.set_location('Entering:'|| l_proc, 10);
577: --
578: -- Issue a savepoint
579: --
580: savepoint delete_template_canvas;

Line 600: hr_utility.set_location('At:'|| l_proc, 15);

596: end;
597: --
598: -- Validation in addition to Row Handlers
599: --
600: hr_utility.set_location('At:'|| l_proc, 15);
601:
602: OPEN cur_api_val;
603: FETCH cur_api_val INTO l_temp;
604: IF (cur_api_val%NOTFOUND AND

Line 618: hr_utility.set_location('At:'|| l_proc, 20);

614: --
615: --
616: -- Process Logic
617: --
618: hr_utility.set_location('At:'|| l_proc, 20);
619:
620: hr_utility.set_location('At:'|| l_proc, 25);
621:
622: IF p_delete_children_flag = 'Y' THEN

Line 620: hr_utility.set_location('At:'|| l_proc, 25);

616: -- Process Logic
617: --
618: hr_utility.set_location('At:'|| l_proc, 20);
619:
620: hr_utility.set_location('At:'|| l_proc, 25);
621:
622: IF p_delete_children_flag = 'Y' THEN
623:
624: FOR cur_rec IN cur_tmplt_tab LOOP

Line 633: hr_utility.set_location('At:'|| l_proc, 30);

629: ,p_delete_children_flag => p_delete_children_flag);
630: END LOOP;
631: END IF;
632:
633: hr_utility.set_location('At:'|| l_proc, 30);
634:
635: hr_canvas_properties_bsi.delete_canvas_property(
636: p_template_canvas_id => p_template_canvas_id
637: ,p_object_version_number => p_object_version_number);

Line 639: hr_utility.set_location('At:'|| l_proc, 35);

635: hr_canvas_properties_bsi.delete_canvas_property(
636: p_template_canvas_id => p_template_canvas_id
637: ,p_object_version_number => p_object_version_number);
638:
639: hr_utility.set_location('At:'|| l_proc, 35);
640:
641: hr_tcn_del.del(
642: p_template_canvas_id => p_template_canvas_id
643: ,p_object_version_number => p_object_version_number);

Line 645: hr_utility.set_location('At:'|| l_proc, 40);

641: hr_tcn_del.del(
642: p_template_canvas_id => p_template_canvas_id
643: ,p_object_version_number => p_object_version_number);
644:
645: hr_utility.set_location('At:'|| l_proc, 40);
646:
647: --
648: -- Call After Process User Hook
649: --

Line 666: hr_utility.set_location('At:'|| l_proc, 45);

662: end;
663: --
664: -- When in validation only mode raise the Validate_Enabled exception
665: --
666: hr_utility.set_location('At:'|| l_proc, 45);
667:
668: if p_validate then
669: raise hr_api.validate_enabled;
670: end if;

Line 672: hr_utility.set_location(' Leaving:'||l_proc, 70);

668: if p_validate then
669: raise hr_api.validate_enabled;
670: end if;
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 70);
673: exception
674: when hr_api.validate_enabled then
675: --
676: -- As the Validate_Enabled exception has been raised

Line 685: hr_utility.set_location(' Leaving:'||l_proc, 80);

681: -- Only set output warning arguments
682: -- (Any key or derived arguments must be set to null
683: -- when validation only mode is being used.)
684: --
685: hr_utility.set_location(' Leaving:'||l_proc, 80);
686: when others then
687: --
688: -- A validation or unexpected error has occured
689: --

Line 691: hr_utility.set_location(' Leaving:'||l_proc, 90);

687: --
688: -- A validation or unexpected error has occured
689: --
690: rollback to delete_template_canvas;
691: hr_utility.set_location(' Leaving:'||l_proc, 90);
692: raise;
693: end delete_template_canvas;
694: --
695: -- ----------------------------------------------------------------------------

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

758:
759: l_proc varchar2(72) := g_package||'update_template_canvas';
760: l_object_version_number number;
761: begin
762: hr_utility.set_location('Entering:'|| l_proc, 10);
763: --
764: -- Issue a savepoint
765: --
766: savepoint update_template_canvas;

Line 826: hr_utility.set_location('At:'|| l_proc, 15);

822: end;
823: --
824: -- Validation in addition to Row Handlers
825: --
826: hr_utility.set_location('At:'|| l_proc, 15);
827:
828: OPEN cur_api_val;
829: FETCH cur_api_val INTO l_temp;
830: IF (cur_api_val%NOTFOUND AND

Line 844: hr_utility.set_location('At:'|| l_proc, 20);

840: --
841: --
842: -- Process Logic
843: --
844: hr_utility.set_location('At:'|| l_proc, 20);
845:
846: hr_canvas_properties_bsi.update_canvas_property(
847: p_effective_date => TRUNC(p_effective_date)
848: ,p_object_version_number => l_object_version_number

Line 887: hr_utility.set_location('At:'|| l_proc, 30);

883: ,p_information28 => p_information28
884: ,p_information29 => p_information29
885: ,p_information30 => p_information30);
886:
887: hr_utility.set_location('At:'|| l_proc, 30);
888:
889: --
890: -- Call After Process User Hook
891: --

Line 943: hr_utility.set_location('At:'|| l_proc, 35);

939: end;
940: --
941: -- When in validation only mode raise the Validate_Enabled exception
942: --
943: hr_utility.set_location('At:'|| l_proc, 35);
944:
945: if p_validate then
946: raise hr_api.validate_enabled;
947: end if;

Line 953: hr_utility.set_location(' Leaving:'||l_proc, 70);

949: -- Set all output arguments
950: --
951: p_object_version_number := l_object_version_number;
952: --
953: hr_utility.set_location(' Leaving:'||l_proc, 70);
954: exception
955: when hr_api.validate_enabled then
956: --
957: -- As the Validate_Enabled exception has been raised

Line 966: hr_utility.set_location(' Leaving:'||l_proc, 80);

962: -- Only set output warning arguments
963: -- (Any key or derived arguments must be set to null
964: -- when validation only mode is being used.)
965: --
966: hr_utility.set_location(' Leaving:'||l_proc, 80);
967: when others then
968: --
969: -- A validation or unexpected error has occured
970: --

Line 972: hr_utility.set_location(' Leaving:'||l_proc, 90);

968: --
969: -- A validation or unexpected error has occured
970: --
971: rollback to update_template_canvas;
972: hr_utility.set_location(' Leaving:'||l_proc, 90);
973: raise;
974: end update_template_canvas;
975: --
976: end hr_template_canvases_api;