[Home] [Help]
97: --
98: begin
99: --
100:
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102:
103: --
104: -- Issue a savepoint
105: --
104: -- Issue a savepoint
105: --
106: savepoint create_qualification_type;
107:
108: hr_utility.set_location(l_proc, 20);
109:
110: --
111: -- Truncate the time portion from all IN date parameters
112: --
198: --
199: end;
200:
201:
202: hr_utility.set_location(l_proc, 30);
203: --
204: -- Process Logic
205: --
206:
212: --
213: l_language_code := p_language_code;
214: hr_api.validate_language_code(p_language_code => l_language_code);
215:
216: hr_utility.set_location(l_proc, 40);
217:
218: --
219: --
220: -- Insert qualification type
290: ,p_qualification_type_id => l_qualification_type_id
291: ,p_object_version_number => l_object_version_number
292: );
293:
294: hr_utility.set_location(l_proc, 50);
295:
296: --
297: -- Insert translatable rows in per_qualification_types_tl table
298: --
301: ,p_language_code => l_language_code
302: ,p_name => p_name
303: );
304: --
305: hr_utility.set_location(l_proc, 60);
306:
307: --
308: -- Call After Process hook for create_qualification_type
309: --
390: -- End of after hook process (create_qualification_type)
391: --
392: end;
393:
394: hr_utility.set_location(l_proc, 70);
395:
396: --
397: -- When in validation only mode raise the Validate_Enabled exception
398: --
400: then
401: raise hr_api.validate_enabled;
402: end if;
403: --
404: hr_utility.set_location(l_proc, 80);
405: --
406: -- Set OUT parameters
407: --
408: p_qualification_type_id := l_qualification_type_id;
407: --
408: p_qualification_type_id := l_qualification_type_id;
409: p_object_version_number := l_object_version_number;
410: --
411: hr_utility.set_location(' Leaving:' ||l_proc, 90);
412: --
413:
414:
415: EXCEPTION
426: -- when validation only mode is being used.)
427: --
428: p_qualification_type_id := null;
429: p_object_version_number := null;
430: hr_utility.set_location(' Leaving:'||l_proc, 100);
431: WHEN OTHERS THEN
432: --
433: -- A validation or unexpected error has occurred
434: ROLLBACK TO create_qualification_type;
434: ROLLBACK TO create_qualification_type;
435: -- Set OUT parameters.
436: p_qualification_type_id := null;
437: p_object_version_number := null;
438: hr_utility.set_location(' Leaving:'||l_proc, 110);
439: RAISE;
440: --
441: end create_qualification_type;
442:
533:
534: --
535: begin
536: --
537: hr_utility.set_location('Entering:'|| l_proc, 10);
538: --
539: lv_object_version_number := p_object_version_number;
540:
541:
543: -- Issue a savepoint
544: --
545: savepoint update_qualification_type;
546:
547: hr_utility.set_location(l_proc, 20);
548:
549: --
550: -- Truncate the time portion from all IN date parameters
551: --
642: -- End of before hook process (update_qualification_type)
643: --
644: end;
645:
646: hr_utility.set_location(l_proc, 30);
647: --
648: -- Process Logic
649: --
650:
657: --
658: l_language_code := p_language_code;
659: hr_api.validate_language_code(p_language_code => l_language_code);
660:
661: hr_utility.set_location(l_proc, 40);
662: --
663: --
664: -- Update qualification type
665: --
734: ,p_qa_organization => p_qa_organization
735: ,p_object_version_number => l_object_version_number
736: );
737:
738: hr_utility.set_location(l_proc, 50);
739:
740: --
741: -- Update per_qualification_types_tl table
742: --
750: -- Assign the out parameters.
751: --
752: p_object_version_number := l_object_version_number;
753:
754: hr_utility.set_location(l_proc, 60);
755:
756: -- Call After Process User hook for update_qualification_type
757: --
758:
838: -- End of after hook process (update_qualification_type)
839: --
840: end;
841:
842: hr_utility.set_location(l_proc, 70);
843:
844: if p_validate
845: then
846: raise hr_api.validate_enabled;
845: then
846: raise hr_api.validate_enabled;
847: end if;
848: --
849: hr_utility.set_location(l_proc, 80);
850: --
851: -- Set OUT parameters
852: --
853: p_object_version_number := l_object_version_number;
851: -- Set OUT parameters
852: --
853: p_object_version_number := l_object_version_number;
854: --
855: hr_utility.set_location(' Leaving:' ||l_proc, 90);
856: --
857: exception
858: --
859: when hr_api.validate_enabled then
870: -- when validation only mode is being used.)
871: --
872: p_object_version_number := p_object_version_number;
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 100);
875: --
876: when others then
877: --
878: -- A validation or unexpected error has occurred
880: rollback to update_qualification_type;
881: --
882: p_object_version_number := lv_object_version_number;
883: --
884: hr_utility.set_location(' Leaving:'||l_proc, 110);
885: --
886: raise;
887: --
888: --
911:
912: --
913: begin
914: --
915: hr_utility.set_location('Entering:'|| l_proc, 10);
916:
917: lv_object_version_number := p_object_version_number;
918:
919: --
921: --
922: savepoint delete_qualification_type;
923:
924: l_object_version_number := p_object_version_number;
925: hr_utility.set_location(l_proc, 20);
926:
927: --
928: -- Call Before Process User Hook
929: --
940: ,p_hook_type => 'BP'
941: );
942: end;
943:
944: hr_utility.set_location(l_proc, 30);
945:
946: --
947: -- Remove all matching translation rows in per_qualification_types_tl
948: --
949: per_qtt_del.del_tl
950: (p_qualification_type_id => p_qualification_type_id
951: );
952:
953: hr_utility.set_location(l_proc, 40);
954:
955: --
956: -- Process Logic
957: --
960: ,p_object_version_number => l_object_version_number
961: ,p_validate => p_validate
962: );
963:
964: hr_utility.set_location(l_proc, 50);
965:
966: --
967: -- Call After Process User Hook
968: --
978: ,p_hook_type => 'AP'
979: );
980: end;
981:
982: hr_utility.set_location(l_proc, 60);
983:
984: p_object_version_number := l_object_version_number;
985: --
986: -- When in validation only mode raise the Validate_Enabled exception
993: -- Set all output arguments (returned by some dt modes only)
994: --
995: p_object_version_number := l_object_version_number;
996:
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998:
999: exception
1000: when hr_api.validate_enabled then
1001: hr_utility.set_location(' Leaving...:'||l_proc, 80);
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998:
999: exception
1000: when hr_api.validate_enabled then
1001: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1002: --
1003: -- As the Validate_Enabled exception has been raised
1004: -- we must rollback to the savepoint
1005: --
1011: --
1012: p_object_version_number := null;
1013: --
1014: when others then
1015: hr_utility.set_location(' Leaving...:'||l_proc, 90);
1016: --
1017: -- A validation or unexpected error has occured
1018: --
1019: rollback to delete_qualification_type;