DBA Data[Home] [Help]

APPS.PQH_FR_VALIDATION_PERIODS_API dependencies on HR_UTILITY

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

35: l_validation_period_id PQH_FR_VALIDATION_PERIODS.VALIDATION_PERIOD_ID%TYPE;
36:
37:
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint Insert_Validation_Period;

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

138: p_object_version_number := l_object_version_number;
139:
140:
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: exception
144: when hr_api.validate_enabled then
145: --
146: -- As the Validate_Enabled exception has been raised

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

151: -- Only set output warning arguments
152: -- (Any key or derived arguments must be set to null
153: -- when validation only mode is being used.)
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 80);
156:
157: when others then
158: p_validation_period_id := null;
159: p_object_version_number := null;

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

160: --
161: -- A validation or unexpected error has occured
162: --
163: rollback to Insert_Validation_Period;
164: hr_utility.set_location(' Leaving:'||l_proc, 90);
165: raise;
166: end Insert_Validation_Period;
167:
168: --

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

191: l_object_Version_Number PQH_FR_VALIDATION_PERIODS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
192: L_Effective_Date Date;
193:
194: Begin
195: hr_utility.set_location('Entering:'|| l_proc, 10);
196: --
197: -- Issue a savepoint
198: --
199: savepoint Update_Validation_Period;

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

291:
292: p_object_version_number := l_object_version_number;
293:
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised

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

304: -- Only set output warning arguments
305: -- (Any key or derived arguments must be set to null
306: -- when validation only mode is being used.)
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 80);
309:
310: when others then
311: p_object_version_number := l_object_version_number;
312: --

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

312: --
313: -- A validation or unexpected error has occured
314: --
315: rollback to Update_Validation_Period;
316: hr_utility.set_location(' Leaving:'||l_proc, 90);
317: raise;
318: end Update_Validation_Period;
319:
320: --

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

330: --
331: l_proc varchar2(72) := g_package||'delete_Validation_period';
332: --
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 10);
335: --
336: -- Issue a savepoint
337: --
338: savepoint delete_Validation_period;

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

383: -- end if;
384: --
385: -- Set all output arguments
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: exception
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised

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

396: -- Only set output warning arguments
397: -- (Any key or derived arguments must be set to null
398: -- when validation only mode is being used.)
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 80);
401: when others then
402: --
403: -- A validation or unexpected error has occured
404: --

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

402: --
403: -- A validation or unexpected error has occured
404: --
405: rollback to delete_Validation_period;
406: hr_utility.set_location(' Leaving:'||l_proc, 90);
407: raise;
408: end delete_Validation_period;
409:
410: end PQH_FR_VALIDATION_PERIODS_API;