DBA Data[Home] [Help]

APPS.BEN_PRMRY_CARE_PRVDR_API dependencies on HR_UTILITY

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

25: l_delete_next_change boolean;
26: l_step number(9);
27: l_proc varchar2(80) := g_package||'determine_datetrack_mode';
28: begin
29: hr_utility.set_location ('Entering '||l_proc,10);
30:
31: if p_mini_mode = 'U' then -- update
32:
33: ben_ppr_shd.find_dt_upd_modes

Line 91: hr_utility.set_location ('Leaving '||l_proc,99);

87: end if;
88:
89: end if;
90:
91: hr_utility.set_location ('Leaving '||l_proc,99);
92: Exception
93: when others then
94: raise;
95: end determine_datetrack_mode;

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

157: l_object_version_number ben_prmry_care_prvdr_f.object_version_number%TYPE;
158: --
159: begin
160: --
161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: --
163: -- Issue a savepoint if operating in validation only mode
164: --
165: savepoint create_PRMRY_CARE_PRVDR;

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

163: -- Issue a savepoint if operating in validation only mode
164: --
165: savepoint create_PRMRY_CARE_PRVDR;
166: --
167: hr_utility.set_location(l_proc, 20);
168: --
169: -- Process Logic
170: --
171: begin

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

364: -- End of API User Hook for the after hook of create_PRMRY_CARE_PRVDR
365: --
366: end;
367: --
368: hr_utility.set_location(l_proc, 60);
369: --
370: -- When in validation only mode raise the Validate_Enabled exception
371: --
372: if p_validate then

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

379: p_effective_start_date := l_effective_start_date;
380: p_effective_end_date := l_effective_end_date;
381: p_object_version_number := l_object_version_number;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 70);
384: --
385: exception
386: --
387: when hr_api.validate_enabled then

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

398: p_prmry_care_prvdr_id := null;
399: p_effective_start_date := null;
400: p_effective_end_date := null;
401: p_object_version_number := null;
402: hr_utility.set_location(' Leaving:'||l_proc, 80);
403: --
404: when others then
405: --
406: -- A validation or unexpected error has occured

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

440: l_object_version_number ben_prmry_care_prvdr_f.object_version_number%TYPE;
441: --
442: begin
443: --
444: hr_utility.set_location('Entering:'|| l_proc, 10);
445: fnd_msg_pub.initialize;
446:
447: create_prmry_care_prvdr
448: (

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

467: p_effective_end_date := l_effective_end_date;
468: p_object_version_number := l_object_version_number;
469: p_return_status := 'S';
470:
471: hr_utility.set_location(' Leaving:'||l_proc, 40);
472: --
473: exception
474: --
475: when others then

Line 479: hr_utility.set_location('Exception:'|| l_proc, 100);

475: when others then
476: --
477: -- A validation or unexpected error has occured
478: --
479: hr_utility.set_location('Exception:'|| l_proc, 100);
480: p_prmry_care_prvdr_id := null;
481: p_effective_start_date := null;
482: p_effective_end_date := null;
483: p_object_version_number := null;

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

562: l_old_pcp_values c_old_pcp_values%rowtype;
563: l_datetrack_mode varchar2(80);
564:
565: begin
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567: --
568: -- Issue a savepoint if operating in validation only mode
569: --
570: savepoint update_PRMRY_CARE_PRVDR;

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

567: --
568: -- Issue a savepoint if operating in validation only mode
569: --
570: savepoint update_PRMRY_CARE_PRVDR;
571: hr_utility.set_location(l_proc, 20);
572:
573: -- added for logging change events for extract
574: open c_old_pcp_values;
575: fetch c_old_pcp_values into l_old_pcp_values;

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

778: -- End of API User Hook for the after hook of update_PRMRY_CARE_PRVDR
779: --
780: end;
781: --
782: hr_utility.set_location(l_proc, 60);
783: --
784: -- When in validation only mode raise the Validate_Enabled exception
785: --
786: if p_validate then

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

792: p_object_version_number := l_object_version_number;
793: p_effective_start_date := l_effective_start_date;
794: p_effective_end_date := l_effective_end_date;
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 70);
797: --
798: exception
799: --
800: when hr_api.validate_enabled then

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

807: -- Only set output warning arguments
808: -- (Any key or derived arguments must be set to null
809: -- when validation only mode is being used.)
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 80);
812: --
813: when others then
814: --
815: -- A validation or unexpected error has occured

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

847: l_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;
848: --
849: begin
850: --
851: hr_utility.set_location('Entering:'|| l_proc, 10);
852: fnd_msg_pub.initialize;
853:
854: l_object_version_number := p_object_version_number;
855: update_prmry_care_prvdr

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

872: p_effective_start_date := l_effective_start_date;
873: p_effective_end_date := l_effective_end_date;
874: p_return_status := 'S';
875: --
876: hr_utility.set_location('Leaving:'||l_proc, 40);
877: --
878: exception
879: --
880: when others then

Line 884: hr_utility.set_location('Exception:'||l_proc, 100);

880: when others then
881: --
882: -- A validation or unexpected error has occured
883: --
884: hr_utility.set_location('Exception:'||l_proc, 100);
885: p_effective_start_date := null;
886: p_effective_end_date := null;
887: p_return_status := 'E';
888: fnd_msg_pub.add;

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

928: l_old_pcp_values c_old_pcp_values%rowtype;
929: l_datetrack_mode varchar2(80);
930: l_desired_dt_mode varchar2(80);
931: begin
932: hr_utility.set_location('Entering:'|| l_proc, 10);
933: --
934: -- Issue a savepoint if operating in validation only mode
935: --
936: savepoint delete_PRMRY_CARE_PRVDR;

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

933: --
934: -- Issue a savepoint if operating in validation only mode
935: --
936: savepoint delete_PRMRY_CARE_PRVDR;
937: hr_utility.set_location(l_proc, 20);
938:
939: -- added for logging change events for extract
940: open c_old_pcp_values;
941: fetch c_old_pcp_values into l_old_pcp_values;

Line 1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);

1009: p_prtt_enrt_rslt_id => l_old_pcp_values.prtt_enrt_rslt_id,
1010: p_business_group_id => l_old_pcp_values.business_group_id,
1011: p_effective_date => l_effective_date);
1012: -- 4879576
1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);
1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);
1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);
1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);
1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);

Line 1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);

1010: p_business_group_id => l_old_pcp_values.business_group_id,
1011: p_effective_date => l_effective_date);
1012: -- 4879576
1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);
1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);
1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);
1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);
1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);
1018: */

Line 1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);

1011: p_effective_date => l_effective_date);
1012: -- 4879576
1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);
1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);
1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);
1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);
1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);
1018: */
1019: if p_called_from is null then

Line 1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);

1012: -- 4879576
1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);
1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);
1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);
1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);
1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);
1018: */
1019: if p_called_from is null then
1020: pcp_actn_items(

Line 1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);

1013: /*hr_utility.set_location('SSARKAR l_old_pcp_values.prtt_enrt_rslt_id '|| l_old_pcp_values.prtt_enrt_rslt_id,99099);
1014: hr_utility.set_location('SSARKAR l_old_pcp_values.elig_cvrd_dpnt_id '|| l_old_pcp_values.elig_cvrd_dpnt_id,99099);
1015: hr_utility.set_location('SSARKAR l_effective_date '|| l_effective_date,99099);
1016: hr_utility.set_location('SSARKAR l_old_pcp_values.business_group_id '|| l_old_pcp_values.business_group_id,99099);
1017: hr_utility.set_location('SSARKAR l_datetrack_mode '|| l_datetrack_mode,99099);
1018: */
1019: if p_called_from is null then
1020: pcp_actn_items(
1021: p_prtt_enrt_rslt_id => l_old_pcp_values.prtt_enrt_rslt_id

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

1050: -- End of API User Hook for the after hook of delete_PRMRY_CARE_PRVDR
1051: --
1052: end;
1053: --
1054: hr_utility.set_location(l_proc, 60);
1055: --
1056: -- When in validation only mode raise the Validate_Enabled exception
1057: --
1058: if p_validate then

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

1058: if p_validate then
1059: raise hr_api.validate_enabled;
1060: end if;
1061: --
1062: hr_utility.set_location(' Leaving:'||l_proc, 70);
1063: --
1064: exception
1065: --
1066: when hr_api.validate_enabled then

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

1107: l_effective_end_date ben_prmry_care_prvdr_f.effective_end_date%TYPE;
1108: --
1109: begin
1110: --
1111: hr_utility.set_location('Entering:'|| l_proc, 10);
1112: fnd_msg_pub.initialize;
1113: --
1114: l_object_version_number := p_object_version_number;
1115:

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

1127: p_effective_end_date := l_effective_end_date;
1128: p_object_version_number := l_object_version_number;
1129: p_return_status := 'S';
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 40);
1132: --
1133: exception
1134: --
1135: when others then

Line 1139: hr_utility.set_location('Exception:'||l_proc, 100);

1135: when others then
1136: --
1137: -- A validation or unexpected error has occured
1138: --
1139: hr_utility.set_location('Exception:'||l_proc, 100);
1140: p_effective_start_date := null;
1141: p_effective_end_date := null;
1142: p_return_status := 'E';
1143: fnd_msg_pub.add;

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

1166: l_validation_end_date date;
1167: --
1168: begin
1169: --
1170: hr_utility.set_location('Entering:'|| l_proc, 10);
1171: --
1172: ben_ppr_shd.lck
1173: (
1174: p_prmry_care_prvdr_id => p_prmry_care_prvdr_id

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

1178: ,p_effective_date => p_effective_date
1179: ,p_datetrack_mode => p_datetrack_mode
1180: );
1181: --
1182: hr_utility.set_location(' Leaving:'||l_proc, 70);
1183: --
1184: end lck;
1185: --
1186: -- ----------------------------------------------------------------------------

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

1224: between pen.effective_start_date and pen.effective_end_date;
1225: --
1226: begin
1227: --
1228: hr_utility.set_location('Entering:'|| l_proc, 10);
1229: --
1230: if p_prtt_enrt_rslt_id is null or
1231: p_business_group_id is null then
1232: open get_rslt_id_c;

Line 1274: hr_utility.set_location('Exiting:'|| l_proc, 40);

1270: );
1271: end if;
1272: --
1273: --
1274: hr_utility.set_location('Exiting:'|| l_proc, 40);
1275: --
1276: --
1277: end pcp_actn_items;
1278: --