DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_CODES_API dependencies on HR_UTILITY

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

29: L_Effective_Date Date;
30: l_level_code_id PQH_DE_LEVEL_CODES.LEVEL_CODE_ID%TYPE;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint Insert_LEVEL_CODES;

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

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

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

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

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

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

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

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

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

238:
239: p_object_version_number := l_object_version_number;
240:
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 70);
243: exception
244: when hr_api.validate_enabled then
245: --
246: -- As the Validate_Enabled exception has been raised

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

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

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

259: --
260: -- A validation or unexpected error has occured
261: --
262: rollback to Update_LEVEL_CODES;
263: hr_utility.set_location(' Leaving:'||l_proc, 90);
264: raise;
265: end Update_LEVEL_CODES;
266:
267: --

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

277: --
278: l_proc varchar2(72) := g_package||'delete_LEVEL_CODES';
279: --
280: begin
281: hr_utility.set_location('Entering:'|| l_proc, 10);
282: --
283: -- Issue a savepoint
284: --
285: savepoint delete_LEVEL_CODES;

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

326: end if;
327: --
328: -- Set all output arguments
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: exception
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised

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

339: -- Only set output warning arguments
340: -- (Any key or derived arguments must be set to null
341: -- when validation only mode is being used.)
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 80);
344: when others then
345: --
346: -- A validation or unexpected error has occured
347: --

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

345: --
346: -- A validation or unexpected error has occured
347: --
348: rollback to delete_LEVEL_CODES;
349: hr_utility.set_location(' Leaving:'||l_proc, 90);
350: raise;
351: end delete_LEVEL_CODES;
352:
353: end PQH_DE_LEVEL_CODES_API;