DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_CTFN_PRVDD_API dependencies on HR_UTILITY

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

43: l_proc varchar2(80) := g_package||'check_prtt_ctfn';
44: --
45: begin
46: --
47: hr_utility.set_location('Entering '||l_proc, 10);
48: --
49: open prtt_c;
50: fetch prtt_c into l_prtt;
51: close prtt_c;

Line 78: hr_utility.set_location('Leaving '||l_proc, 10);

74: ,p_rslt_object_version_number => l_prtt.rslt_ovn);
75: --
76: end if;
77: --
78: hr_utility.set_location('Leaving '||l_proc, 10);
79: --
80: end check_prtt_ctfn;
81: --
82: -- ----------------------------------------------------------------------------

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

146: l_sspndd_rslt varchar2(1) := null;
147: --
148: begin
149: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Check whether any required certification denied. If it is, then
153: -- the l_del_enrt flag is turned to 'Y'
154: --

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

191: l_datetrack_mode := hr_api.g_zap;
192: end if;
193: -- this will end date the enrollment, it's action items and it's
194: -- certifications (all the children).
195: hr_utility.set_location('Leaving:'|| l_proc, 40);
196: ben_prtt_enrt_result_api.delete_enrollment
197: (P_VALIDATE => p_validate
198: ,P_PRTT_ENRT_RSLT_ID => p_prtt_enrt_rslt_id
199: ,p_per_in_ler_id => l_per_in_ler_id -- 2386000

Line 209: hr_utility.set_location('Leaving:'|| l_proc, 45);

205: ,P_DATETRACK_MODE => l_datetrack_mode
206: ,P_MULTI_ROW_VALIDATE => TRUE
207: ,p_source => 'bepcsapi'
208: );
209: hr_utility.set_location('Leaving:'|| l_proc, 45);
210: end if;
211: close c_sspndd_rslt;
212: end if;
213: --

Line 214: hr_utility.set_location('Leaving:'|| l_proc, 50);

210: end if;
211: close c_sspndd_rslt;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'|| l_proc, 50);
215: --
216: end check_dnd_ctfns;
217: --
218: -- ----------------------------------------------------------------------------

Line 260: hr_utility.set_location('Entering:'|| l_proc, 50);

256: --
257: l_proc varchar2(72) := g_package||'.check_prtt_futur_lf_evnt';
258: begin
259: --
260: hr_utility.set_location('Entering:'|| l_proc, 50);
261: --
262: open c_pil(p_PRTT_ENRT_ACTN_ID);
263: fetch c_pil into l_pil;
264: close c_pil;

Line 279: hr_utility.set_location('Leaving:'|| l_proc, 50);

275: end if;
276: --
277: close c_future_pils;
278: --
279: hr_utility.set_location('Leaving:'|| l_proc, 50);
280: --
281: end check_prtt_futur_lf_evnt;
282:
283: -- ----------------------------------------------------------------------------

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

342: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
343: --
344: begin
345: --
346: hr_utility.set_location('Entering:'|| l_proc, 10);
347: --
348: -- Initialize environment
349: --
350: if fnd_global.conc_request_id = -1 then

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

363: -- Issue a savepoint if operating in validation only mode
364: --
365: savepoint create_PRTT_ENRT_CTFN_PRVDD;
366: --
367: hr_utility.set_location(l_proc, 20);
368: --
369: if p_prtt_enrt_actn_id is null then
370: --
371: ben_enrollment_action_items.process_new_ctfn_action

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

553: -- End of API User Hook for the after hook of create_PRTT_ENRT_CTFN_PRVDD
554: --
555: end;
556: --
557: hr_utility.set_location(l_proc, 60);
558: --
559: -- When in validation only mode raise the Validate_Enabled exception
560: --
561: if p_validate then

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

568: p_effective_start_date := l_effective_start_date;
569: p_effective_end_date := l_effective_end_date;
570: p_object_version_number := l_object_version_number;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573: --
574: exception
575: --
576: when hr_api.validate_enabled then

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

587: p_prtt_enrt_ctfn_prvdd_id := null;
588: p_effective_start_date := null;
589: p_effective_end_date := null;
590: p_object_version_number := null;
591: hr_utility.set_location(' Leaving:'||l_proc, 80);
592: --
593: when others then
594: --
595: -- A validation or unexpected error has occured

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

599: p_prtt_enrt_ctfn_prvdd_id := null;
600: p_effective_start_date := null;
601: p_effective_end_date := null;
602: p_object_version_number := null;
603: hr_utility.set_location(' Leaving:'||l_proc, 80);
604: --
605: raise;
606: --
607: end create_PRTT_ENRT_CTFN_PRVDD;

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

666: l_effective_end_date ben_prtt_enrt_ctfn_prvdd_f.effective_end_date%TYPE;
667: --
668: begin
669: --
670: hr_utility.set_location('Entering:'|| l_proc, 10);
671: --
672: -- Initialize environment
673: --
674: if fnd_global.conc_request_id = -1 then

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

697: (p_prtt_enrt_actn_id,
698: p_effective_date);
699: */
700: --
701: hr_utility.set_location(l_proc, 20);
702: --
703: -- Process Logic
704: --
705: l_object_version_number := p_object_version_number;

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

876: -- End of API User Hook for the after hook of update_PRTT_ENRT_CTFN_PRVDD
877: --
878: end;
879: --
880: hr_utility.set_location(l_proc, 60);
881: --
882: check_prtt_ctfn(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id,
883: p_effective_date => p_effective_date,
884: p_business_group_id => p_business_group_id,

Line 887: hr_utility.set_location(' Leaving:'||l_proc, 62);

883: p_effective_date => p_effective_date,
884: p_business_group_id => p_business_group_id,
885: p_datetrack_mode => p_datetrack_mode);
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 62);
888: --
889: if p_enrt_ctfn_dnd_dt IS NOT NULL then
890: check_dnd_ctfns(p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
891: p_effective_date => p_effective_date,

Line 897: hr_utility.set_location(' Leaving:'||l_proc, 64);

893: p_validate => p_validate,
894: p_datetrack_mode => p_datetrack_mode);
895: end if;
896: --
897: hr_utility.set_location(' Leaving:'||l_proc, 64);
898: --
899: -- When in validation only mode raise the Validate_Enabled exception
900: --
901: if p_validate then

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

908: p_effective_start_date := l_effective_start_date;
909: p_effective_end_date := l_effective_end_date;
910:
911: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: --
914: exception
915: --
916: when hr_api.validate_enabled then

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

925: -- when validation only mode is being used.)
926: --
927: p_effective_start_date := null;
928: p_effective_end_date := null;
929: hr_utility.set_location(' Leaving:'||l_proc, 80);
930: --
931: when others then
932: --
933: -- A validation or unexpected error has occured

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

936: --
937: p_effective_start_date := null;
938: p_effective_end_date := null;
939: p_object_version_number := l_object_version_number;
940: hr_utility.set_location(' Leaving:'||l_proc, 80);
941: --
942: raise;
943: --
944: end update_PRTT_ENRT_CTFN_PRVDD;

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

1005: and pen.effective_end_date;
1006: --
1007: begin
1008: --
1009: hr_utility.set_location('Entering:'|| l_proc, 10);
1010: --
1011: -- Get action item id and the business group id.
1012: --
1013: open get_actn_c;

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

1046: (l_prtt_enrt_actn_id,
1047: p_effective_date);
1048: */
1049: --
1050: hr_utility.set_location(l_proc, 20);
1051: --
1052: -- Process Logic
1053: --
1054: l_object_version_number := p_object_version_number;

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

1157: -- End of API User Hook for the after hook of delete_PRTT_ENRT_CTFN_PRVDD
1158: --
1159: end;
1160: --
1161: hr_utility.set_location(l_proc, 60);
1162: --
1163: -- When in validation only mode raise the Validate_Enabled exception
1164: --
1165: if p_validate then

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

1165: if p_validate then
1166: raise hr_api.validate_enabled;
1167: end if;
1168: --
1169: hr_utility.set_location(' Leaving:'||l_proc, 70);
1170: --
1171: exception
1172: --
1173: when hr_api.validate_enabled then

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

1190: --
1191: p_effective_start_date := null;
1192: p_effective_end_date := null;
1193: p_object_version_number := l_object_version_number;
1194: hr_utility.set_location(' Leaving:'||l_proc, 80);
1195: raise;
1196: --
1197: end delete_PRTT_ENRT_CTFN_PRVDD;
1198: --

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

1218: l_validation_end_date date;
1219: --
1220: begin
1221: --
1222: hr_utility.set_location('Entering:'|| l_proc, 10);
1223: --
1224: ben_pcs_shd.lck
1225: (
1226: p_prtt_enrt_ctfn_prvdd_id => p_prtt_enrt_ctfn_prvdd_id

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

1230: ,p_effective_date => p_effective_date
1231: ,p_datetrack_mode => p_datetrack_mode
1232: );
1233: --
1234: hr_utility.set_location(' Leaving:'||l_proc, 70);
1235: --
1236: end lck;
1237: --
1238: end ben_PRTT_ENRT_CTFN_PRVDD_api;