DBA Data[Home] [Help]

APPS.HR_TEMPLATE_TAB_PAGES_API dependencies on HR_UTILITY

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

49: l_override_value_warning boolean;
50: l_language_code fnd_languages.language_code%TYPE;
51:
52: begin
53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: --
55: -- Issue a savepoint
56: --
57: savepoint copy_template_tab_page;

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

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

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

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

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

106: --
107: --
108: -- Process Logic
109: --
110: hr_utility.set_location('At:'|| l_proc, 20);
111:
112: OPEN cur_form_tab;
113: FETCH cur_form_tab INTO l_form_tab_page_id;
114: CLOSE cur_form_tab;

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

112: OPEN cur_form_tab;
113: FETCH cur_form_tab INTO l_form_tab_page_id;
114: CLOSE cur_form_tab;
115:
116: hr_utility.set_location('At:'|| l_proc, 25);
117:
118: hr_ttp_ins.ins(p_template_canvas_id => p_template_canvas_id
119: ,p_form_tab_page_id => l_form_tab_page_id
120: ,p_template_tab_page_id => l_template_tab_page_id_to

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

119: ,p_form_tab_page_id => l_form_tab_page_id
120: ,p_template_tab_page_id => l_template_tab_page_id_to
121: ,p_object_version_number => l_object_version_number);
122:
123: hr_utility.set_location('At:'|| l_proc, 30);
124:
125: hr_tab_page_properties_bsi.copy_tab_page_property(
126: p_effective_date => TRUNC(p_effective_date)
127: ,p_language_code => l_language_code

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

133:
134: --
135: -- Call After Process User Hook
136: --
137: hr_utility.set_location('At:'|| l_proc, 35);
138:
139: begin
140: hr_template_tab_pages_api_bk1.copy_template_tab_page_a
141: (p_effective_date => TRUNC(p_effective_date)

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

166: p_template_tab_page_id_to := l_template_tab_page_id_to;
167: p_object_version_number := l_object_version_number;
168: --p_override_value_warning := l_override_value_warning;
169:
170: hr_utility.set_location(' Leaving:'||l_proc, 70);
171: exception
172: when hr_api.validate_enabled then
173: --
174: -- As the Validate_Enabled exception has been raised

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

182: --
183: --p_override_value_warning := null;
184: p_template_tab_page_id_to := null;
185: p_object_version_number := null;
186: hr_utility.set_location(' Leaving:'||l_proc, 80);
187: when others then
188: --
189: -- A validation or unexpected error has occured
190: --

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

191: p_template_tab_page_id_to := null;
192: p_object_version_number := null;
193:
194: rollback to copy_template_tab_page;
195: hr_utility.set_location(' Leaving:'||l_proc, 90);
196: raise;
197: end copy_template_tab_page;
198: --
199: --

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

276: l_language_code fnd_languages.language_code%TYPE;
277:
278: l_proc varchar2(72) := g_package||'create_template_tab_page';
279: begin
280: hr_utility.set_location('Entering:'|| l_proc, 10);
281: --
282: -- Issue a savepoint
283: --
284: savepoint create_template_tab_page;

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

293: --
294: l_language_code := p_language_code;
295: hr_api.validate_language_code(p_language_code => l_language_code);
296: --
297: hr_utility.set_location(l_proc, 20);
298: --
299: --
300: -- Call Before Process User Hook
301: --

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

348: end;
349: --
350: -- Validation in addition to Row Handlers
351: --
352: hr_utility.set_location('At:'|| l_proc, 15);
353:
354: OPEN cur_override;
355: FETCH cur_override INTO l_visible_override;
356: CLOSE cur_override;

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

354: OPEN cur_override;
355: FETCH cur_override INTO l_visible_override;
356: CLOSE cur_override;
357:
358: hr_utility.set_location('At:'|| l_proc, 20);
359:
360: IF ( p_visible <> hr_api.g_number ) AND
361: ( p_visible is not null and l_visible_override is not null ) THEN
362: l_override_value_warning := TRUE;

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

361: ( p_visible is not null and l_visible_override is not null ) THEN
362: l_override_value_warning := TRUE;
363: END IF;
364:
365: hr_utility.set_location('At:'|| l_proc, 25);
366:
367: OPEN cur_api_val;
368: FETCH cur_api_val INTO l_temp;
369: IF (cur_api_val%NOTFOUND AND

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

379: --
380: --
381: -- Process Logic
382: --
383: hr_utility.set_location('At:'|| l_proc, 30);
384:
385: hr_ttp_ins.ins(p_template_canvas_id => p_template_canvas_id
386: ,p_form_tab_page_id => p_form_tab_page_id
387: ,p_template_tab_page_id => l_template_tab_page_id

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

386: ,p_form_tab_page_id => p_form_tab_page_id
387: ,p_template_tab_page_id => l_template_tab_page_id
388: ,p_object_version_number => l_object_version_number);
389:
390: hr_utility.set_location('At:'|| l_proc, 35);
391:
392: hr_tab_page_properties_bsi.copy_tab_page_property(
393: p_effective_date => TRUNC(p_effective_date)
394: ,p_language_code => l_language_code

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

431: ,p_tab_page_property_id => l_tab_page_property_id
432: ,p_object_version_number => l_object_version_number);
433: --,p_override_value_warning => l_override_value_warning);
434:
435: hr_utility.set_location('At:'|| l_proc, 40);
436:
437: --
438: -- Call After Process User Hook
439: --

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

500: p_template_tab_page_id := l_template_tab_page_id;
501: p_object_version_number := l_object_version_number;
502: p_override_value_warning := l_override_value_warning;
503: --
504: hr_utility.set_location(' Leaving:'||l_proc, 70);
505: exception
506: when hr_api.validate_enabled then
507: --
508: -- As the Validate_Enabled exception has been raised

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

516: --
517: p_template_tab_page_id := null;
518: p_object_version_number := null;
519: p_override_value_warning := l_override_value_warning;
520: hr_utility.set_location(' Leaving:'||l_proc, 80);
521: when others then
522: --
523: -- A validation or unexpected error has occured
524: --

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

526: p_object_version_number := null;
527: p_override_value_warning := null;
528:
529: rollback to create_template_tab_page;
530: hr_utility.set_location(' Leaving:'||l_proc, 90);
531: raise;
532: end create_template_tab_page;
533: --
534: -- ----------------------------------------------------------------------------

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

574: AND http.template_tab_page_id = p_template_tab_page_id;
575:
576: l_proc varchar2(72) := g_package||'delete_template_tab_page';
577: begin
578: hr_utility.set_location('Entering:'|| l_proc, 10);
579: --
580: -- Issue a savepoint
581: --
582: savepoint delete_template_tab_page;

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

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

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

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

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

618: -- Process Logic
619: --
620: hr_utility.set_location('At:'|| l_proc, 20);
621:
622: hr_utility.set_location('At:'|| l_proc, 25);
623:
624: IF p_delete_children_flag = 'Y' THEN
625: hr_utility.set_location('At:'|| l_proc, 30);
626:

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

621:
622: hr_utility.set_location('At:'|| l_proc, 25);
623:
624: IF p_delete_children_flag = 'Y' THEN
625: hr_utility.set_location('At:'|| l_proc, 30);
626:
627: FOR cur_rec IN cur_tmplt_tab LOOP
628: hr_template_item_tab_pages_api.delete_template_item_tab_page(
629: p_template_item_tab_page_id => cur_rec.template_item_tab_page_id

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

629: p_template_item_tab_page_id => cur_rec.template_item_tab_page_id
630: ,p_object_version_number => cur_rec.object_version_number);
631: END LOOP;
632:
633: hr_utility.set_location('At:'|| l_proc, 35);
634:
635: FOR cur_rec IN cur_tmplt_context LOOP
636: hr_tcp_api.delete_tcp(
637: p_template_item_context_page_i => cur_rec.template_item_context_page_id

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

638: ,p_object_version_number => cur_rec.object_version_number);
639: END LOOP;
640: END IF;
641:
642: hr_utility.set_location('At:'|| l_proc, 40);
643:
644: hr_tab_page_properties_bsi.delete_tab_page_property(
645: p_template_tab_page_id => p_template_tab_page_id
646: ,p_object_version_number => p_object_version_number);

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

644: hr_tab_page_properties_bsi.delete_tab_page_property(
645: p_template_tab_page_id => p_template_tab_page_id
646: ,p_object_version_number => p_object_version_number);
647:
648: hr_utility.set_location('At:'|| l_proc, 45);
649:
650: hr_ttp_del.del( p_template_tab_page_id => p_template_tab_page_id
651: ,p_object_version_number => p_object_version_number);
652: --

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

651: ,p_object_version_number => p_object_version_number);
652: --
653: -- Call After Process User Hook
654: --
655: hr_utility.set_location('At:'|| l_proc, 50);
656:
657: begin
658: hr_template_tab_pages_api_bk3.delete_template_tab_page_a
659: (p_template_tab_page_id => p_template_tab_page_id

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

673: if p_validate then
674: raise hr_api.validate_enabled;
675: end if;
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 70);
678: exception
679: when hr_api.validate_enabled then
680: --
681: -- As the Validate_Enabled exception has been raised

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

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

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

692: --
693: -- A validation or unexpected error has occured
694: --
695: rollback to delete_template_tab_page;
696: hr_utility.set_location(' Leaving:'||l_proc, 90);
697: raise;
698: end delete_template_tab_page;
699: --
700: -- ----------------------------------------------------------------------------

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

777: l_language_code fnd_languages.language_code%TYPE;
778:
779:
780: begin
781: hr_utility.set_location('Entering:'|| l_proc, 10);
782: --
783: -- Issue a savepoint
784: --
785: savepoint update_template_tab_page;

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

795: --
796: l_language_code := p_language_code;
797: hr_api.validate_language_code(p_language_code => l_language_code);
798: --
799: hr_utility.set_location(l_proc, 20);
800: --
801: --
802: -- Call Before Process User Hook
803: --

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

850: end;
851: --
852: -- Validation in addition to Row Handlers
853: --
854: hr_utility.set_location('At:'|| l_proc, 15);
855:
856: OPEN cur_override;
857: FETCH cur_override INTO l_visible_override;
858: CLOSE cur_override;

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

856: OPEN cur_override;
857: FETCH cur_override INTO l_visible_override;
858: CLOSE cur_override;
859:
860: hr_utility.set_location('At:'|| l_proc, 20);
861:
862: IF ( p_visible <> hr_api.g_number ) AND
863: ( p_visible is not null and l_visible_override is not null ) THEN
864: l_override_value_warning := TRUE;

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

863: ( p_visible is not null and l_visible_override is not null ) THEN
864: l_override_value_warning := TRUE;
865: END IF;
866:
867: hr_utility.set_location('At:'|| l_proc, 25);
868:
869: OPEN cur_api_val;
870: FETCH cur_api_val INTO l_temp;
871: IF (cur_api_val%NOTFOUND AND

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

881: --
882: --
883: -- Process Logic
884: --
885: hr_utility.set_location('At:'|| l_proc, 30);
886:
887: hr_tab_page_properties_bsi.update_tab_page_property(
888: p_effective_date => TRUNC(p_effective_date)
889: ,p_object_version_number => l_object_version_number

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

924: ,p_information29 => p_information29
925: ,p_information30 => p_information30);
926: --,p_override_value_warning => l_override_value_warning);
927:
928: hr_utility.set_location('At:'|| l_proc, 40);
929:
930: --
931: -- Call After Process User Hook
932: --

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

990: --
991: p_object_version_number := l_object_version_number;
992: p_override_value_warning := l_override_value_warning;
993: --
994: hr_utility.set_location(' Leaving:'||l_proc, 70);
995: exception
996: when hr_api.validate_enabled then
997: --
998: -- As the Validate_Enabled exception has been raised

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

1004: -- (Any key or derived arguments must be set to null
1005: -- when validation only mode is being used.)
1006: --
1007: p_override_value_warning := l_override_value_warning;
1008: hr_utility.set_location(' Leaving:'||l_proc, 80);
1009: when others then
1010: --
1011: -- A validation or unexpected error has occured
1012: --

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

1010: --
1011: -- A validation or unexpected error has occured
1012: --
1013: rollback to update_template_tab_page;
1014: hr_utility.set_location(' Leaving:'||l_proc, 90);
1015: raise;
1016: end update_template_tab_page;
1017: --
1018: end hr_template_tab_pages_api;