DBA Data[Home] [Help]

APPS.PQH_DE_RESULT_SETS_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

268: --
269: l_proc varchar2(72) := g_package||'delete_RESULT_SETS';
270: --
271: begin
272: hr_utility.set_location('Entering:'|| l_proc, 10);
273: --
274: -- Issue a savepoint
275: --
276: savepoint delete_RESULT_SETS;

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

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

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

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

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

336: --
337: -- A validation or unexpected error has occured
338: --
339: rollback to delete_RESULT_SETS;
340: hr_utility.set_location(' Leaving:'||l_proc, 90);
341: raise;
342: end delete_RESULT_SETS;
343:
344: end PQH_DE_RESULT_SETS_API;