62: -- l_language_code hr_locations_all_tl.language%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint if operating in validation only mode
69: --
70: savepoint create_checklist_items;
68: -- Issue a savepoint if operating in validation only mode
69: --
70: savepoint create_checklist_items;
71: --
72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Process Logic
75: --
76: begin
231: -- End of API User Hook for the after hook of create_checklist_items
232: --
233: end;
234: --
235: hr_utility.set_location(l_proc, 60);
236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then
244: --
245: p_checklist_item_id := l_checklist_item_id;
246: p_object_version_number := l_object_version_number;
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 70);
249: --
250: exception
251: --
252: when hr_api.validate_enabled then
261: -- when validation only mode is being used.)
262: --
263: p_checklist_item_id := null;
264: p_object_version_number := null;
265: hr_utility.set_location(' Leaving:'||l_proc, 80);
266: --
267: when others then
268: --
269: -- A validation or unexpected error has occured
271: ROLLBACK TO create_checklist_items;
272: -- Reset IN OUT parameters and set OUT parameters
273: p_checklist_item_id := null;
274: p_object_version_number := null;
275: hr_utility.set_location(' Leaving:'||l_proc, 90);
276: raise;
277: --
278: end create_checklist_items;
279: -- ----------------------------------------------------------------------------
332: l_temp_object_version_number per_checklist_items.object_version_number%TYPE;
333: --
334: begin
335: --
336: hr_utility.set_location('Entering:'|| l_proc, 10);
337: --
338: -- Issue a savepoint if operating in validation only mode
339: --
340: savepoint update_checklist_items;
338: -- Issue a savepoint if operating in validation only mode
339: --
340: savepoint update_checklist_items;
341: --
342: hr_utility.set_location(l_proc, 20);
343: --
344: -- Process Logic
345: --
346: l_temp_object_version_number := p_object_version_number;
505: -- End of API User Hook for the after hook of update_checklist_items
506: --
507: end;
508: --
509: hr_utility.set_location(l_proc, 60);
510: --
511: -- When in validation only mode raise the Validate_Enabled exception
512: --
513: if p_validate then
517: -- Set all output arguments
518: --
519: p_object_version_number := l_object_version_number;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 70);
522: --
523: exception
524: --
525: when hr_api.validate_enabled then
532: -- Only set output warning arguments
533: -- (Any key or derived arguments must be set to null
534: -- when validation only mode is being used.)
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 80);
537: --
538: when others then
539: --
540: -- A validation or unexpected error has occured
562: l_proc varchar2(72) := g_package||'update_checklist_items';
563: --
564: begin
565: --
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567: --
568: -- Issue a savepoint if operating in validation only mode
569: --
570: savepoint delete_checklist_items;
568: -- Issue a savepoint if operating in validation only mode
569: --
570: savepoint delete_checklist_items;
571: --
572: hr_utility.set_location(l_proc, 20);
573: --
574: -- Process Logic
575: --
576: --
620: -- End of API User Hook for the after hook of delete_checklist_items
621: --
622: end;
623: --
624: hr_utility.set_location(l_proc, 60);
625: --
626: -- When in validation only mode raise the Validate_Enabled exception
627: --
628: if p_validate then
628: if p_validate then
629: raise hr_api.validate_enabled;
630: end if;
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 70);
633: --
634: exception
635: --
636: when hr_api.validate_enabled then
670: l_proc varchar2(72) := g_package||'lck';
671: --
672: begin
673: --
674: hr_utility.set_location('Entering:'|| l_proc, 10);
675: --
676: per_chk_shd.lck
677: (
678: p_checklist_item_id => p_checklist_item_id
678: p_checklist_item_id => p_checklist_item_id
679: ,p_object_version_number => p_object_version_number
680: );
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 70);
683: --
684: end lck;
685: --
686: -- ----------------------------------------------------------------------------
740: l_object_version_number number;
741: --
742: begin
743: --
744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: savepoint cre_or_upd_checklist_items;
747: --
748: l_checklist_item_id := p_checklist_item_id;
750: l_api_updating:=per_chk_shd.api_updating
751: (p_checklist_item_id => p_checklist_item_id
752: ,p_object_version_number => p_object_version_number);
753: --
754: hr_utility.set_location(l_proc, 20);
755: --
756: l_chk_rec :=
757: per_chk_shd.convert_args
758: (p_checklist_item_id
801: -- set g_old_rec to null;
802: --
803: per_chk_shd.g_old_rec:=l_null_chk_rec;
804: --
805: hr_utility.set_location(l_proc, 30);
806: --
807: -- convert the null values
808: --
809: hr_utility.set_location(l_proc, 40);
805: hr_utility.set_location(l_proc, 30);
806: --
807: -- convert the null values
808: --
809: hr_utility.set_location(l_proc, 40);
810: per_chk_upd.convert_defs(l_chk_rec);
811: --
812: -- insert the data
813: --
810: per_chk_upd.convert_defs(l_chk_rec);
811: --
812: -- insert the data
813: --
814: hr_utility.set_location(l_proc, 50);
815: --
816: per_checklist_items_api.create_checklist_items
817: (p_validate => FALSE
818: ,p_effective_date => TRUNC(p_effective_date)
854: ,p_attribute29 => l_chk_rec.attribute29
855: ,p_attribute30 => l_chk_rec.attribute30
856: ,p_checklist_item_id => l_chk_rec.checklist_item_id
857: ,p_object_version_number => l_chk_rec.object_version_number);
858: hr_utility.set_location(l_proc, 60);
859: else
860: --
861: -- updating not inserting
862: --
859: else
860: --
861: -- updating not inserting
862: --
863: hr_utility.set_location(l_proc, 70);
864: per_chk_shd.lck
865: (p_checklist_item_id => p_checklist_item_id
866: ,p_object_version_number => p_object_version_number);
867: --
866: ,p_object_version_number => p_object_version_number);
867: --
868: -- convert the null values
869: --
870: hr_utility.set_location(l_proc, 80);
871: per_chk_upd.convert_defs(l_chk_rec);
872: --
873: -- update the data
874: --
871: per_chk_upd.convert_defs(l_chk_rec);
872: --
873: -- update the data
874: --
875: hr_utility.set_location(l_proc, 90);
876: --
877: per_checklist_items_api.update_checklist_items
878: (p_validate => FALSE
879: ,p_effective_date => TRUNC(p_effective_date)
916: ,p_attribute29 => l_chk_rec.attribute29
917: ,p_attribute30 => l_chk_rec.attribute30
918: ,p_object_version_number => l_chk_rec.object_version_number);
919: --
920: hr_utility.set_location(l_proc, 100);
921: --
922: end if;
923: --
924: if p_validate then
924: if p_validate then
925: raise hr_api.validate_enabled;
926: end if;
927: --
928: hr_utility.set_location(l_proc, 110);
929: --
930: p_checklist_item_id := l_chk_rec.checklist_item_id;
931: p_object_version_number := l_chk_rec.object_version_number;
932: --
929: --
930: p_checklist_item_id := l_chk_rec.checklist_item_id;
931: p_object_version_number := l_chk_rec.object_version_number;
932: --
933: hr_utility.set_location(' Leaving:'||l_proc, 120);
934: --
935: exception
936: when hr_api.validate_enabled then
937: rollback to cre_or_upd_checklist_items;
936: when hr_api.validate_enabled then
937: rollback to cre_or_upd_checklist_items;
938: p_checklist_item_id := null;
939: p_object_version_number:=null;
940: hr_utility.set_location('Leaving:'||l_proc, 130);
941: when others then
942: rollback to cre_or_upd_checklist_items;
943: --
944: -- set in out parameters and set out parameters
944: -- set in out parameters and set out parameters
945: --
946: p_checklist_item_id := l_checklist_item_id;
947: p_object_version_number := l_object_version_number;
948: hr_utility.set_location('Leaving:'||l_proc, 140);
949: raise;
950: --
951: end cre_or_upd_checklist_items;
952: --