DBA Data[Home] [Help]

APPS.BEN_PTNL_LER_FOR_PER_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_ptnl_ler_for_per_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< derive_PPL_statcd_dates >-----------------------|
11: -- ----------------------------------------------------------------------------

Line 125: g_debug := hr_utility.debug_enabled;

121: --
122:
123: begin
124: --
125: g_debug := hr_utility.debug_enabled;
126: if g_debug then
127: l_proc := g_package||'create_ptnl_ler_for_per';
128: hr_utility.set_location('Entering:'|| l_proc, 10);
129: end if;

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

124: --
125: g_debug := hr_utility.debug_enabled;
126: if g_debug then
127: l_proc := g_package||'create_ptnl_ler_for_per';
128: hr_utility.set_location('Entering:'|| l_proc, 10);
129: end if;
130: --
131: -- Issue a savepoint if operating in validation only mode
132: --

Line 133: hr_utility.set_location('p_ler_id '|| p_ler_id, 10);

129: end if;
130: --
131: -- Issue a savepoint if operating in validation only mode
132: --
133: hr_utility.set_location('p_ler_id '|| p_ler_id, 10);
134: hr_utility.set_location('p_effective_date '|| p_effective_date, 10);
135: hr_utility.set_location('p_person_id '|| p_person_id, 10);
136: hr_utility.set_location('p_business_group_id '|| p_business_group_id, 10);
137: l_continue_eval := true;

Line 134: hr_utility.set_location('p_effective_date '|| p_effective_date, 10);

130: --
131: -- Issue a savepoint if operating in validation only mode
132: --
133: hr_utility.set_location('p_ler_id '|| p_ler_id, 10);
134: hr_utility.set_location('p_effective_date '|| p_effective_date, 10);
135: hr_utility.set_location('p_person_id '|| p_person_id, 10);
136: hr_utility.set_location('p_business_group_id '|| p_business_group_id, 10);
137: l_continue_eval := true;
138: if( nvl(p_called_from_form,'N') = 'N') then

Line 135: hr_utility.set_location('p_person_id '|| p_person_id, 10);

131: -- Issue a savepoint if operating in validation only mode
132: --
133: hr_utility.set_location('p_ler_id '|| p_ler_id, 10);
134: hr_utility.set_location('p_effective_date '|| p_effective_date, 10);
135: hr_utility.set_location('p_person_id '|| p_person_id, 10);
136: hr_utility.set_location('p_business_group_id '|| p_business_group_id, 10);
137: l_continue_eval := true;
138: if( nvl(p_called_from_form,'N') = 'N') then
139: open c_chk_elig_crit(p_ler_id, nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;

Line 136: hr_utility.set_location('p_business_group_id '|| p_business_group_id, 10);

132: --
133: hr_utility.set_location('p_ler_id '|| p_ler_id, 10);
134: hr_utility.set_location('p_effective_date '|| p_effective_date, 10);
135: hr_utility.set_location('p_person_id '|| p_person_id, 10);
136: hr_utility.set_location('p_business_group_id '|| p_business_group_id, 10);
137: l_continue_eval := true;
138: if( nvl(p_called_from_form,'N') = 'N') then
139: open c_chk_elig_crit(p_ler_id, nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
140: fetch c_chk_elig_crit into l_dummy;

Line 142: hr_utility.set_location('No elig criteria', 10);

138: if( nvl(p_called_from_form,'N') = 'N') then
139: open c_chk_elig_crit(p_ler_id, nvl(p_lf_evt_ocrd_dt,p_effective_date)) ;
140: fetch c_chk_elig_crit into l_dummy;
141: if(c_chk_elig_crit%notfound) then
142: hr_utility.set_location('No elig criteria', 10);
143: close c_chk_elig_crit;
144: l_continue_eval := true;
145: else
146: close c_chk_elig_crit;

Line 147: hr_utility.set_location('Evaluate elig profiles', 10);

143: close c_chk_elig_crit;
144: l_continue_eval := true;
145: else
146: close c_chk_elig_crit;
147: hr_utility.set_location('Evaluate elig profiles', 10);
148: --Bug 16218328 commented the below If condition
149: -- if fnd_global.conc_request_id in (0,-1) then
150: ben_env_object.init
151: (p_business_group_id => p_business_group_id,

Line 170: hr_utility.set_location('criteria satisfied', 10);

166: ,p_col_value => p_ler_id
167: ,p_elig_flag => l_elig_return_status);
168:
169: if(l_elig_return_status = 'Y') then
170: hr_utility.set_location('criteria satisfied', 10);
171: l_continue_eval := true;
172: else
173: hr_utility.set_location('criteria not satisfied ', 10);
174: l_continue_eval := false;

Line 173: hr_utility.set_location('criteria not satisfied ', 10);

169: if(l_elig_return_status = 'Y') then
170: hr_utility.set_location('criteria satisfied', 10);
171: l_continue_eval := true;
172: else
173: hr_utility.set_location('criteria not satisfied ', 10);
174: l_continue_eval := false;
175: end if;
176: end if;
177: else

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

295: --
296: end;
297: --
298: if g_debug then
299: hr_utility.set_location(l_proc, 60);
300: end if;
301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --

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

312:
313: end if;
314: --
315: if g_debug then
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: end if;
318: --
319: exception
320: --

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

332: p_ptnl_ler_for_per_id := null;
333: p_object_version_number := null;
334: --
335: if g_debug then
336: hr_utility.set_location(' Leaving:'||l_proc, 80);
337: end if;
338: --
339: when others then
340: --

Line 554: -- DEBUG : hr_utility.set_location(' Leaving:'||l_proc, 80);

550: -- when validation only mode is being used.)
551: --
552: p_ptnl_ler_for_per_id := null;
553: p_object_version_number := null;
554: -- DEBUG : hr_utility.set_location(' Leaving:'||l_proc, 80);
555: --
556: when others then
557: --
558: -- A validation or unexpected error has occured

Line 603: g_debug := hr_utility.debug_enabled;

599: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
600: --
601: begin
602: --
603: g_debug := hr_utility.debug_enabled;
604: if g_debug then
605: l_proc := g_package||'update_ptnl_ler_for_per';
606: hr_utility.set_location('Entering:'|| l_proc, 10);
607: end if;

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

602: --
603: g_debug := hr_utility.debug_enabled;
604: if g_debug then
605: l_proc := g_package||'update_ptnl_ler_for_per';
606: hr_utility.set_location('Entering:'|| l_proc, 10);
607: end if;
608: --
609: -- Issue a savepoint if operating in validation only mode
610: --

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

725: --
726: end;
727: --
728: if g_debug then
729: hr_utility.set_location(l_proc, 60);
730: end if;
731: --
732: -- When in validation only mode raise the Validate_Enabled exception
733: --

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

739: --
740: p_object_version_number := l_object_version_number;
741: --
742: if g_debug then
743: hr_utility.set_location(' Leaving:'||l_proc, 70);
744: end if;
745: --
746: exception
747: --

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

756: -- (Any key or derived arguments must be set to null
757: -- when validation only mode is being used.)
758: --
759: if g_debug then
760: hr_utility.set_location(' Leaving:'||l_proc, 80);
761: end if;
762: --
763: when others then
764: --

Line 1109: g_debug := hr_utility.debug_enabled;

1105: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
1106: --
1107: begin
1108: --
1109: g_debug := hr_utility.debug_enabled;
1110: if g_debug then
1111: l_proc := g_package||'update_ptnl_ler_for_per';
1112: hr_utility.set_location('Entering:'|| l_proc, 10);
1113: end if;

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

1108: --
1109: g_debug := hr_utility.debug_enabled;
1110: if g_debug then
1111: l_proc := g_package||'update_ptnl_ler_for_per';
1112: hr_utility.set_location('Entering:'|| l_proc, 10);
1113: end if;
1114: --
1115: -- Issue a savepoint if operating in validation only mode
1116: --

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

1171: --
1172: end;
1173: --
1174: if g_debug then
1175: hr_utility.set_location(l_proc, 60);
1176: end if;
1177: --
1178: -- When in validation only mode raise the Validate_Enabled exception
1179: --

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

1181: raise hr_api.validate_enabled;
1182: end if;
1183: --
1184: if g_debug then
1185: hr_utility.set_location(' Leaving:'||l_proc, 70);
1186: end if;
1187: --
1188: exception
1189: --

Line 1227: g_debug := hr_utility.debug_enabled;

1223: l_proc varchar2(72);
1224: --
1225: begin
1226: --
1227: g_debug := hr_utility.debug_enabled;
1228: if g_debug then
1229: l_proc := g_package||'lck';
1230: hr_utility.set_location('Entering:'|| l_proc, 10);
1231: end if;

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

1226: --
1227: g_debug := hr_utility.debug_enabled;
1228: if g_debug then
1229: l_proc := g_package||'lck';
1230: hr_utility.set_location('Entering:'|| l_proc, 10);
1231: end if;
1232: --
1233: ben_ppl_shd.lck
1234: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id

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

1234: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1235: ,p_object_version_number => p_object_version_number);
1236: --
1237: if g_debug then
1238: hr_utility.set_location(' Leaving:'||l_proc, 70);
1239: end if;
1240: --
1241: end lck;
1242: --