DBA Data[Home] [Help]

APPS.PQH_DE_VLDOPR_API dependencies on HR_UTILITY

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

28: L_Effective_Date Date;
29: l_Wrkplc_vldtn_Op_id PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_OP_ID%TYPE;
30:
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Issue a savepoint
35: --
36: savepoint Insert_Vldtn_Oprn;

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

106: p_wrkplc_vldtn_Op_id := l_Wrkplc_vldtn_Op_id;
107: p_object_version_number := l_object_version_number;
108:
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: exception
112: when hr_api.validate_enabled then
113: --
114: -- As the Validate_Enabled exception has been raised

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

121: -- when validation only mode is being used.)
122: --
123: p_wrkplc_vldtn_Op_id := null;
124: p_object_version_number := null;
125: hr_utility.set_location(' Leaving:'||l_proc, 80);
126:
127: when others then
128: p_wrkplc_vldtn_Op_id := null;
129: p_object_version_number := null;

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

130: --
131: -- A validation or unexpected error has occured
132: --
133: rollback to Insert_Vldtn_oprn;
134: hr_utility.set_location(' Leaving:'||l_proc, 90);
135: raise;
136: end Insert_Vldtn_Oprn;
137:
138: --

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

155: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_OPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
156: L_Effective_Date Date;
157:
158: Begin
159: hr_utility.set_location('Entering:'|| l_proc, 10);
160: --
161: -- Issue a savepoint
162: --
163: savepoint Update_Vldtn_Oprn;

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

233:
234: p_object_version_number := l_object_version_number;
235:
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 70);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised

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

246: -- Only set output warning arguments
247: -- (Any key or derived arguments must be set to null
248: -- when validation only mode is being used.)
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 80);
251:
252: when others then
253: p_object_version_number := l_object_version_number;
254: --

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

254: --
255: -- A validation or unexpected error has occured
256: --
257: rollback to Update_Vldtn_oprn;
258: hr_utility.set_location(' Leaving:'||l_proc, 90);
259: raise;
260: end Update_Vldtn_Oprn;
261:
262: --

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

272: --
273: l_proc varchar2(72) := g_package||'delete_Vldtn_Oprn';
274: --
275: begin
276: hr_utility.set_location('Entering:'|| l_proc, 10);
277: --
278: -- Issue a savepoint
279: --
280: savepoint delete_Vldtn_Oprn;

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

320: end if;
321: --
322: -- Set all output arguments
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: exception
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised

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

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

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

339: --
340: -- A validation or unexpected error has occured
341: --
342: rollback to delete_Vldtn_Oprn;
343: hr_utility.set_location(' Leaving:'||l_proc, 90);
344: raise;
345: end delete_Vldtn_Oprn;
346:
347: end PQH_DE_VLDOPR_API;