DBA Data[Home] [Help]

APPS.OTA_COURSE_PREREQUISITE_API dependencies on HR_UTILITY

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

27: l_object_version_number number;
28: l_effective_date date;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_course_prerequisite;

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

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

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

118: -- (Any key or derived arguments must be set to null
119: -- when validation only mode is being used.)
120: --
121: p_object_version_number := null;
122: hr_utility.set_location(' Leaving:'||l_proc, 80);
123: when others then
124: --
125: -- A validation or unexpected error has occured
126: --

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

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

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

151: l_object_version_number number := p_object_version_number;
152: l_effective_date date;
153:
154: begin
155: hr_utility.set_location('Entering:'|| l_proc, 10);
156: --
157: -- Issue a savepoint
158: --
159: savepoint update_course_prerequisite ;

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

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

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

243: -- (Any key or derived arguments must be set to null
244: -- when validation only mode is being used.)
245: --
246: p_object_version_number := null;
247: hr_utility.set_location(' Leaving:'||l_proc, 80);
248: when others then
249: --
250: -- A validation or unexpected error has occured
251: --

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

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

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

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

Line 331: hr_utility.set_location(' Leaving:'||l_proc, 170);

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

Line 344: hr_utility.set_location(' Leaving:'||l_proc, 180);

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

Line 350: hr_utility.set_location(' Leaving:'||l_proc, 190);

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