DBA Data[Home] [Help]

APPS.HR_TEMPLATE_WINDOWS_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

108: --
109: --
110: -- Process Logic
111:
112: hr_utility.set_location('At:'|| l_proc, 20);
113:
114: OPEN cur_form_window;
115: FETCH cur_form_window INTO l_form_window_id;
116: CLOSE cur_form_window;

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

114: OPEN cur_form_window;
115: FETCH cur_form_window INTO l_form_window_id;
116: CLOSE cur_form_window;
117:
118: hr_utility.set_location('At:'|| l_proc, 25);
119:
120: hr_twn_ins.ins( p_form_template_id => p_form_template_id
121: ,p_form_window_id => l_form_window_id
122: ,p_template_window_id => l_template_window_id_to

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

121: ,p_form_window_id => l_form_window_id
122: ,p_template_window_id => l_template_window_id_to
123: ,p_object_version_number => l_object_version_number);
124:
125: hr_utility.set_location('At:'|| l_proc, 30);
126:
127: hr_window_properties_bsi.copy_window_property(
128: p_effective_date => TRUNC(p_effective_date)
129: ,p_language_code => l_language_code

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

130: ,p_template_window_id_from => p_template_window_id_from
131: ,p_template_window_id_to => l_template_window_id_to
132: ,p_window_property_id => l_window_property_id);
133:
134: hr_utility.set_location('At:'|| l_proc, 35);
135:
136: FOR cur_rec in cur_tmplt_canvas LOOP
137:
138: hr_template_canvases_api.copy_template_canvas(

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

145: END LOOP;
146: --
147: -- Call After Process User Hook
148: --
149: hr_utility.set_location('At:'|| l_proc, 40);
150:
151: begin
152: hr_template_windows_api_bk1.copy_template_window_a
153: (p_effective_date => TRUNC(p_effective_date)

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

174: --
175: p_template_window_id_to := l_template_window_id_to;
176: p_object_version_number := l_object_version_number;
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised

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

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

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

198: p_template_window_id_to := null;
199: p_object_version_number := null;
200:
201: rollback to copy_template_window;
202: hr_utility.set_location(' Leaving:'||l_proc, 90);
203: raise;
204: end copy_template_window;
205: --
206: -- ----------------------------------------------------------------------------

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

284: l_template_canvas_id number;
285: l_tcn_object_version_number number;
286:
287: begin
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint create_template_window;

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

301: --
302: l_language_code := p_language_code;
303: hr_api.validate_language_code(p_language_code => l_language_code);
304: --
305: hr_utility.set_location(l_proc, 20);
306: --
307: --
308: -- Call Before Process User Hook
309: --

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

359: end;
360: --
361: -- Validation in addition to Row Handlers
362: --
363: hr_utility.set_location('At:'|| l_proc, 15);
364:
365: OPEN cur_api_val;
366: FETCH cur_api_val INTO l_temp;
367: IF (cur_api_val%NOTFOUND AND

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

377: --
378: --
379: -- Process Logic
380: --
381: hr_utility.set_location('At:'|| l_proc, 20);
382:
383: hr_twn_ins.ins( p_form_template_id => p_form_template_id
384: ,p_form_window_id => p_form_window_id
385: ,p_template_window_id => l_template_window_id

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

384: ,p_form_window_id => p_form_window_id
385: ,p_template_window_id => l_template_window_id
386: ,p_object_version_number => l_object_version_number);
387:
388: hr_utility.set_location('At:'|| l_proc, 25);
389:
390: hr_window_properties_bsi.copy_window_property(
391: p_effective_date => TRUNC(p_effective_date)
392: ,p_language_code => l_language_code

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

447: END LOOP;
448: --
449: -- Call After Process User Hook
450: --
451: hr_utility.set_location('At:'|| l_proc, 30);
452:
453: begin
454: hr_template_windows_api_bk2.create_template_window_a
455: (p_effective_date => TRUNC(p_effective_date)

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

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

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

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

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

536: p_template_window_id := null;
537: p_object_version_number := null;
538:
539: rollback to create_template_window;
540: hr_utility.set_location(' Leaving:'||l_proc, 90);
541: raise;
542: end create_template_window;
543: --
544: -- ----------------------------------------------------------------------------

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

584: AND htw.template_window_id = p_template_window_id);
585:
586: l_proc varchar2(72) := g_package||'delete_template_window';
587: begin
588: hr_utility.set_location('Entering:'|| l_proc, 10);
589: --
590: -- Issue a savepoint
591: --
592: savepoint delete_template_window;

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

607: end;
608: --
609: -- Validation in addition to Row Handlers
610: --
611: hr_utility.set_location('At:'|| l_proc, 35);
612:
613: OPEN cur_api_val;
614: FETCH cur_api_val INTO l_temp;
615: IF (cur_api_val%NOTFOUND AND

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

625: --
626: --
627: -- Process Logic
628: --
629: hr_utility.set_location('At:'|| l_proc, 40);
630:
631: hr_twn_shd.lck( p_template_window_id => p_template_window_id
632: ,p_object_version_number => p_object_version_number);
633:

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

630:
631: hr_twn_shd.lck( p_template_window_id => p_template_window_id
632: ,p_object_version_number => p_object_version_number);
633:
634: hr_utility.set_location('At:'|| l_proc, 45);
635:
636: --
637: -- Delete content canvases
638: --

Line 656: hr_utility.set_location('At:'|| l_proc, 50);

652: ,p_object_version_number => cur_rec.object_version_number
653: ,p_delete_children_flag => p_delete_children_flag);
654: END LOOP;
655: END IF;
656: hr_utility.set_location('At:'|| l_proc, 50);
657:
658: hr_window_properties_bsi.delete_window_property(
659: p_template_window_id => p_template_window_id);
660:

Line 661: hr_utility.set_location('At:'|| l_proc, 55);

657:
658: hr_window_properties_bsi.delete_window_property(
659: p_template_window_id => p_template_window_id);
660:
661: hr_utility.set_location('At:'|| l_proc, 55);
662:
663: hr_twn_del.del( p_template_window_id => p_template_window_id
664: ,p_object_version_number => p_object_version_number);
665:

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

662:
663: hr_twn_del.del( p_template_window_id => p_template_window_id
664: ,p_object_version_number => p_object_version_number);
665:
666: hr_utility.set_location('At:'|| l_proc, 60);
667:
668: --
669: -- Call After Process User Hook
670: --

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

686: if p_validate then
687: raise hr_api.validate_enabled;
688: end if;
689: --
690: hr_utility.set_location(' Leaving:'||l_proc, 70);
691: exception
692: when hr_api.validate_enabled then
693: --
694: -- As the Validate_Enabled exception has been raised

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

699: -- Only set output warning arguments
700: -- (Any key or derived arguments must be set to null
701: -- when validation only mode is being used.)
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 80);
704: when others then
705: --
706: -- A validation or unexpected error has occured
707: --

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

705: --
706: -- A validation or unexpected error has occured
707: --
708: rollback to delete_template_window;
709: hr_utility.set_location(' Leaving:'||l_proc, 90);
710: raise;
711: end delete_template_window;
712: --
713: -- ----------------------------------------------------------------------------

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

792: l_object_version_number number;
793: l_language_code fnd_languages.language_code%TYPE;
794:
795: begin
796: hr_utility.set_location('Entering:'|| l_proc, 10);
797: --
798: -- Issue a savepoint
799: --
800: savepoint update_template_window;

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

810: --
811: l_language_code := p_language_code;
812: hr_api.validate_language_code(p_language_code => l_language_code);
813: --
814: hr_utility.set_location(l_proc, 20);
815: --
816: --
817: -- Call Before Process User Hook
818: --

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

867: end;
868: --
869: -- Validation in addition to Row Handlers
870: --
871: hr_utility.set_location('At:'|| l_proc, 15);
872:
873: OPEN cur_api_val;
874: FETCH cur_api_val INTO l_temp;
875: IF (cur_api_val%NOTFOUND AND

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

885: --
886: --
887: -- Process Logic
888: --
889: hr_utility.set_location('At:'|| l_proc, 20);
890:
891: hr_twn_shd.lck( p_template_window_id => p_template_window_id
892: ,p_object_version_number => p_object_version_number);
893:

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

890:
891: hr_twn_shd.lck( p_template_window_id => p_template_window_id
892: ,p_object_version_number => p_object_version_number);
893:
894: hr_utility.set_location('At:'|| l_proc, 25);
895:
896: hr_window_properties_bsi.update_window_property(
897: p_effective_date => TRUNC(p_effective_date)
898: ,p_language_code => l_language_code

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

933: ,p_information28 => p_information28
934: ,p_information29 => p_information29
935: ,p_information30 => p_information30);
936:
937: hr_utility.set_location('At:'|| l_proc, 30);
938:
939: FOR cur_rec IN cur_tmplt_canvas LOOP
940:
941: hr_template_canvases_api.update_template_canvas(

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

946: ,p_object_version_number => cur_rec.object_version_number);
947:
948: END LOOP;
949:
950: hr_utility.set_location('At:'|| l_proc, 35);
951:
952: --
953: -- Call After Process User Hook
954: --

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

1011: -- Set all output arguments
1012: --
1013: p_object_version_number := l_object_version_number;
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: exception
1017: when hr_api.validate_enabled then
1018: --
1019: -- As the Validate_Enabled exception has been raised

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

1024: -- Only set output warning arguments
1025: -- (Any key or derived arguments must be set to null
1026: -- when validation only mode is being used.)
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 80);
1029: when others then
1030: --
1031: -- A validation or unexpected error has occured
1032: --

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

1030: --
1031: -- A validation or unexpected error has occured
1032: --
1033: rollback to update_template_window;
1034: hr_utility.set_location(' Leaving:'||l_proc, 90);
1035: raise;
1036: end update_template_window;
1037: --
1038: end hr_template_windows_api;