DBA Data[Home] [Help]

APPS.HR_FORM_ITEMS_API dependencies on HR_UTILITY

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

111: l_item_property_id number;
112: l_override_value_warning boolean := FALSE;
113:
114: begin
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Issue a savepoint
118: --
119: savepoint create_form_item;

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

128: --
129: l_language_code := p_language_code;
130: hr_api.validate_language_code(p_language_code => l_language_code);
131: --
132: hr_utility.set_location(l_proc, 20);
133: --
134: --
135: -- Call Before Process User Hook
136: --

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

232: --
233: -- Process Logic
234: --
235:
236: hr_utility.set_location('At:'|| l_proc, 15);
237:
238: IF ( p_required_override is not null AND p_required is not null ) OR
239: ( p_form_tab_page_id_override is not null
240: AND p_form_tab_page_id is not null ) OR

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

241: ( p_visible_override is not null AND p_visible is not null ) THEN
242: l_override_value_warning := TRUE;
243: END IF;
244:
245: hr_utility.set_location('At:'|| l_proc, 20);
246:
247: hr_fim_ins.ins(p_effective_date => TRUNC(p_effective_date)
248: ,p_application_id => p_application_id
249: ,p_form_id => p_form_id

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

257: ,p_visible_override => p_visible_override
258: ,p_form_item_id => l_form_item_id
259: ,p_object_version_number => l_object_version_number);
260:
261: hr_utility.set_location('At:'|| l_proc, 25);
262:
263: hr_fit_ins.ins_tl(p_language_code => l_language_code
264: ,p_form_item_id => l_form_item_id
265: ,p_user_item_name => p_user_item_name

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

264: ,p_form_item_id => l_form_item_id
265: ,p_user_item_name => p_user_item_name
266: ,p_description => p_description);
267:
268: hr_utility.set_location('At:'|| l_proc, 30);
269:
270: hr_item_properties_bsi.create_item_property(
271: p_effective_date => TRUNC(p_effective_date)
272: ,p_language_code => l_language_code

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

347:
348: --
349: -- Call After Process User Hook
350: --
351: hr_utility.set_location('At:'|| l_proc, 40);
352:
353: begin
354: hr_form_items_api_bk1.create_form_item_a
355: (p_effective_date => TRUNC(p_effective_date)

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

447: ,p_hook_type => 'AP'
448: );
449: end;
450:
451: hr_utility.set_location('At:'|| l_proc, 50);
452:
453: --
454: -- When in validation only mode raise the Validate_Enabled exception
455: --

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

462: p_form_item_id := l_form_item_id;
463: p_object_version_number := l_object_version_number;
464: p_override_value_warning := l_override_value_warning;
465: --
466: hr_utility.set_location(' Leaving:'||l_proc, 70);
467: exception
468: when hr_api.validate_enabled then
469: --
470: -- As the Validate_Enabled exception has been raised

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

478: --
479: p_form_item_id := null;
480: p_object_version_number := null;
481: p_override_value_warning := l_override_value_warning;
482: hr_utility.set_location(' Leaving:'||l_proc, 80);
483: when others then
484: --
485: -- A validation or unexpected error has occured
486: --

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

488: -- Reset out parameters.
489: p_form_item_id := null;
490: p_object_version_number := null;
491: p_override_value_warning := null;
492: hr_utility.set_location(' Leaving:'||l_proc, 90);
493: raise;
494: end create_form_item;
495: --
496: -- ----------------------------------------------------------------------------

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

507: --
508:
509: l_proc varchar2(72) := g_package||'delete_form_item';
510: begin
511: hr_utility.set_location('Entering:'|| l_proc, 10);
512: --
513: -- Issue a savepoint
514: --
515: savepoint delete_form_item;

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

532:
533: --
534: -- Process Logic
535: --
536: hr_utility.set_location('At:'|| l_proc, 15);
537:
538: hr_fim_shd.lck( p_form_item_id => p_form_item_id
539: ,p_object_version_number => p_object_version_number);
540:

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

537:
538: hr_fim_shd.lck( p_form_item_id => p_form_item_id
539: ,p_object_version_number => p_object_version_number);
540:
541: hr_utility.set_location('At:'|| l_proc, 20);
542:
543: hr_item_properties_bsi.delete_item_property
544: (p_form_item_id => p_form_item_id
545: ,p_object_version_number => p_object_version_number);

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

543: hr_item_properties_bsi.delete_item_property
544: (p_form_item_id => p_form_item_id
545: ,p_object_version_number => p_object_version_number);
546:
547: hr_utility.set_location('At:'|| l_proc, 25);
548:
549: hr_fit_del.del_tl( p_form_item_id => p_form_item_id);
550:
551: hr_utility.set_location('At:'|| l_proc, 30);

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

547: hr_utility.set_location('At:'|| l_proc, 25);
548:
549: hr_fit_del.del_tl( p_form_item_id => p_form_item_id);
550:
551: hr_utility.set_location('At:'|| l_proc, 30);
552:
553: hr_fim_del.del( p_form_item_id => p_form_item_id
554: ,p_object_version_number => p_object_version_number);
555:

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

552:
553: hr_fim_del.del( p_form_item_id => p_form_item_id
554: ,p_object_version_number => p_object_version_number);
555:
556: hr_utility.set_location('At:'|| l_proc, 35);
557:
558: --
559: -- Call After Process User Hook
560: --

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

572: end;
573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: hr_utility.set_location('At:'|| l_proc, 40);
577:
578: if p_validate then
579: raise hr_api.validate_enabled;
580: end if;

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

578: if p_validate then
579: raise hr_api.validate_enabled;
580: end if;
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: exception
584: when hr_api.validate_enabled then
585: --
586: -- As the Validate_Enabled exception has been raised

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

591: -- Only set output warning arguments
592: -- (Any key or derived arguments must be set to null
593: -- when validation only mode is being used.)
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 80);
596: when others then
597: --
598: -- A validation or unexpected error has occured
599: --

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

597: --
598: -- A validation or unexpected error has occured
599: --
600: rollback to delete_form_item;
601: hr_utility.set_location(' Leaving:'||l_proc, 90);
602: raise;
603: end delete_form_item;
604: --
605: -- ----------------------------------------------------------------------------

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

719: l_override_value_warning boolean := FALSE;
720:
721: l_temp_ovn number := p_object_version_number;
722: begin
723: hr_utility.set_location('Entering:'|| l_proc, 10);
724: --
725: -- Issue a savepoint
726: --
727: savepoint update_form_item;

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

737: --
738: l_language_code := p_language_code;
739: hr_api.validate_language_code(p_language_code => l_language_code);
740: --
741: hr_utility.set_location(l_proc, 20);
742: --
743: --
744: -- Call Before Process User Hook
745: --

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

838: --
839: -- Process Logic
840: --
841:
842: hr_utility.set_location('At:'|| l_proc, 15);
843:
844: OPEN cur_override;
845: FETCH cur_override INTO l_required,l_required_override,l_form_tab_page_id,
846: l_form_tab_page_id_override,l_visible,l_visible_override;

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

851: ( l_visible_override is not null AND l_visible is not null ) THEN
852: l_override_value_warning := TRUE;
853: END IF;
854:
855: hr_utility.set_location('At:'|| l_proc, 20);
856:
857: hr_fim_upd.upd(p_effective_date => TRUNC(p_effective_date)
858: ,p_form_item_id => p_form_item_id
859: ,p_full_item_name => p_full_item_name

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

863: ,p_form_tab_page_id_override => p_form_tab_page_id_override
864: ,p_visible_override => p_visible_override
865: ,p_object_version_number => l_object_version_number);
866:
867: hr_utility.set_location('At:'|| l_proc, 25);
868:
869: hr_fit_upd.upd_tl( p_language_code => l_language_code
870: ,p_form_item_id => p_form_item_id
871: ,p_user_item_name => p_user_item_name

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

870: ,p_form_item_id => p_form_item_id
871: ,p_user_item_name => p_user_item_name
872: ,p_description => p_description);
873:
874: hr_utility.set_location('At:'|| l_proc, 30);
875:
876: hr_item_properties_bsi.update_item_property(
877: p_effective_date => TRUNC(p_effective_date)
878: ,p_language_code => l_language_code

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

949: ,p_next_navigation_item_id => p_next_navigation_item_id
950: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
951: -- ,p_override_value_warning => l_override_value_warning);
952:
953: hr_utility.set_location('At:'|| l_proc, 35);
954:
955: --
956: -- Call After Process User Hook
957: --

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

1047: ,p_hook_type => 'AP'
1048: );
1049: end;
1050:
1051: hr_utility.set_location('At:'|| l_proc, 40);
1052:
1053: --
1054: -- When in validation only mode raise the Validate_Enabled exception
1055: --

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

1061: --
1062: p_object_version_number := l_object_version_number;
1063: p_override_value_warning := l_override_value_warning;
1064: --
1065: hr_utility.set_location(' Leaving:'||l_proc, 70);
1066: exception
1067: when hr_api.validate_enabled then
1068: --
1069: -- As the Validate_Enabled exception has been raised

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

1076: -- when validation only mode is being used.)
1077: --
1078: p_object_version_number := l_temp_ovn;
1079: p_override_value_warning := l_override_value_warning;
1080: hr_utility.set_location(' Leaving:'||l_proc, 80);
1081: when others then
1082: --
1083: -- A validation or unexpected error has occured
1084: --

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

1085: rollback to update_form_item;
1086: -- Reset IN OUT and set OUT parameters.
1087: p_object_version_number := l_temp_ovn;
1088: p_override_value_warning := null;
1089: hr_utility.set_location(' Leaving:'||l_proc, 90);
1090: raise;
1091: end update_form_item;
1092: --
1093: end hr_form_items_api;