DBA Data[Home] [Help]

APPS.PQH_DE_VLDVER_API dependencies on HR_UTILITY

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

40: L_Effective_Date Date;
41: l_Wrkplc_vldtn_Ver_id PQH_DE_WRKPLC_VLDTN_VERS.WRKPLC_VLDTN_VER_ID%TYPE;
42: l_version_Number PQH_DE_WRKPLC_VLDTN_VERS.VERSION_NUMBER%TYPE;
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Issue a savepoint
47: --
48: savepoint Insert_Vldtn_Vern;

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

154: p_wrkplc_vldtn_Ver_id := l_Wrkplc_vldtn_Ver_id;
155: p_object_version_number := l_object_version_number;
156:
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: exception
160: when hr_api.validate_enabled then
161: --
162: -- As the Validate_Enabled exception has been raised

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

169: -- when validation only mode is being used.)
170: --
171: p_wrkplc_vldtn_Ver_id := null;
172: p_object_version_number := null;
173: hr_utility.set_location(' Leaving:'||l_proc, 80);
174:
175: when others then
176: p_wrkplc_vldtn_Ver_id := null;
177: p_object_version_number := null;

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

178: --
179: -- A validation or unexpected error has occured
180: --
181: rollback to Insert_Vldtn_Vern;
182: hr_utility.set_location(' Leaving:'||l_proc, 90);
183: raise;
184: end Insert_Vldtn_Vern;
185:
186: --

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

213: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_VERS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
214: L_Effective_Date Date;
215:
216: Begin
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: --
219: -- Issue a savepoint
220: --
221: savepoint Update_Vldtn_Vern;

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

321:
322: p_object_version_number := l_object_version_number;
323:
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised

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

334: -- Only set output warning arguments
335: -- (Any key or derived arguments must be set to null
336: -- when validation only mode is being used.)
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 80);
339:
340: when others then
341: p_object_version_number := l_object_version_number;
342: --

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

342: --
343: -- A validation or unexpected error has occured
344: --
345: rollback to Update_Vldtn_Vern;
346: hr_utility.set_location(' Leaving:'||l_proc, 90);
347: raise;
348: end Update_Vldtn_Vern;
349:
350: --

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

360: --
361: l_proc varchar2(72) := g_package||'delete_Vldtn_Vern';
362: --
363: begin
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365: --
366: -- Issue a savepoint
367: --
368: savepoint delete_Vldtn_Vern;

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

408: end if;
409: --
410: -- Set all output arguments
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 70);
413: exception
414: when hr_api.validate_enabled then
415: --
416: -- As the Validate_Enabled exception has been raised

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

421: -- Only set output warning arguments
422: -- (Any key or derived arguments must be set to null
423: -- when validation only mode is being used.)
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 80);
426: when others then
427: --
428: -- A validation or unexpected error has occured
429: --

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

427: --
428: -- A validation or unexpected error has occured
429: --
430: rollback to delete_Vldtn_Vern;
431: hr_utility.set_location(' Leaving:'||l_proc, 90);
432: raise;
433: end delete_Vldtn_Vern;
434:
435: end PQH_DE_VLDVER_API;