APPS.PQH_DE_VLDJOB_API dependencies on HR_UTILITY

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

27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_JOB_id PQH_DE_WRKPLC_VLDTN_JOBS.WRKPLC_VLDTN_JOB_ID%TYPE;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint Insert_Vldtn_Job;

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

102: p_wrkplc_vldtn_Job_id := l_Wrkplc_vldtn_Job_id;
103: p_object_version_number := l_object_version_number;
104:
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: exception
108: when hr_api.validate_enabled then
109: --
110: -- As the Validate_Enabled exception has been raised

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

117: -- when validation only mode is being used.)
118: --
119: p_wrkplc_vldtn_Job_id := null;
120: p_object_version_number := null;
121: hr_utility.set_location(' Leaving:'||l_proc, 80);
122:
123: when others then
124: p_wrkplc_vldtn_Job_id := null;
125: p_object_version_number := null;

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

126: --
127: -- A validation or unexpected error has occured
128: --
129: rollback to Insert_Vldtn_Job;
130: hr_utility.set_location(' Leaving:'||l_proc, 90);
131: raise;
132: end Insert_Vldtn_Job;
133:
134: --

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

150: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_JobS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
151: L_Effective_Date Date;
152:
153: Begin
154: hr_utility.set_location('Entering:'|| l_proc, 10);
155: --
156: -- Issue a savepoint
157: --
158: savepoint Update_Vldtn_Oprn;

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

225:
226: p_object_version_number := l_object_version_number;
227:
228: --
229: hr_utility.set_location(' Leaving:'||l_proc, 70);
230: exception
231: when hr_api.validate_enabled then
232: --
233: -- As the Validate_Enabled exception has been raised

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

238: -- Only set output warning arguments
239: -- (Any key or derived arguments must be set to null
240: -- when validation only mode is being used.)
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 80);
243:
244: when others then
245: p_object_version_number := l_object_version_number;
246: --

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

246: --
247: -- A validation or unexpected error has occured
248: --
249: rollback to Update_Vldtn_Job;
250: hr_utility.set_location(' Leaving:'||l_proc, 90);
251: raise;
252: end Update_Vldtn_Job;
253:
254: --

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

264: --
265: l_proc varchar2(72) := g_package||'delete_Vldtn_Job';
266: --
267: begin
268: hr_utility.set_location('Entering:'|| l_proc, 10);
269: --
270: -- Issue a savepoint
271: --
272: savepoint delete_Vldtn_Job;

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

312: end if;
313: --
314: -- Set all output arguments
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised

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

325: -- Only set output warning arguments
326: -- (Any key or derived arguments must be set to null
327: -- when validation only mode is being used.)
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 80);
330: when others then
331: --
332: -- A validation or unexpected error has occured
333: --

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

331: --
332: -- A validation or unexpected error has occured
333: --
334: rollback to delete_Vldtn_Job;
335: hr_utility.set_location(' Leaving:'||l_proc, 90);
336: raise;
337: end delete_Vldtn_Job;
338:
339: end PQH_DE_VLDJOB_API;