DBA Data[Home] [Help]

APPS.PER_CHECKLIST_ITEMS_API dependencies on HR_UTILITY

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

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;

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

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

Line 235: hr_utility.set_location(l_proc, 60);

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

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

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

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

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

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

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: -- ----------------------------------------------------------------------------

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

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;

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

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;

Line 509: hr_utility.set_location(l_proc, 60);

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

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

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

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

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

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

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;

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

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: --

Line 624: hr_utility.set_location(l_proc, 60);

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

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

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

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

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

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

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: -- ----------------------------------------------------------------------------

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

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;

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

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

Line 805: hr_utility.set_location(l_proc, 30);

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);

Line 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: --

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

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)

Line 858: hr_utility.set_location(l_proc, 60);

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: --

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

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: --

Line 870: hr_utility.set_location(l_proc, 80);

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: --

Line 875: hr_utility.set_location(l_proc, 90);

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)

Line 920: hr_utility.set_location(l_proc, 100);

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

Line 928: hr_utility.set_location(l_proc, 110);

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: --

Line 933: hr_utility.set_location(' Leaving:'||l_proc, 120);

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;

Line 940: hr_utility.set_location('Leaving:'||l_proc, 130);

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

Line 948: hr_utility.set_location('Leaving:'||l_proc, 140);

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: --