DBA Data[Home] [Help]

APPS.OTA_BKNG_JUSTIFICATION_API dependencies on HR_UTILITY

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

28: l_object_version_number ota_bkng_justifications_b.object_version_number%TYPE;
29: l_effective_date date;
30: l_proc varchar2(72) := g_package||' create_booking_justification';
31: begin
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Issue a savepoint
35: --
36: savepoint CREATE_BOOKING_JUSTIFICATION;

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

109: if p_validate then
110: raise hr_api.validate_enabled;
111: end if;
112:
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: exception
115: when hr_api.validate_enabled then
116: --
117: -- As the Validate_Enabled exception has been raised

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

124: -- when validation only mode is being used.)
125: --
126: p_booking_justification_id := null;
127: p_object_version_number := null;
128: hr_utility.set_location(' Leaving:'||l_proc, 80);
129: when others then
130: --
131: -- A validation or unexpected error has occured
132: --

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

132: --
133: rollback to CREATE_BOOKING_JUSTIFICATION;
134: p_booking_justification_id := null;
135: p_object_version_number := null;
136: hr_utility.set_location(' Leaving:'||l_proc, 90);
137: raise;
138: end create_booking_justification;
139: -- ----------------------------------------------------------------------------
140: -- |-------------------------< UPDATE_BOOKING_JUSTIFICATION >-------------------------|

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

158: l_proc varchar2(72) := g_package||' Update Booking Justification';
159: l_object_version_number number := p_object_version_number;
160: l_effective_date date;
161: begin
162: hr_utility.set_location('Entering:'|| l_proc, 10);
163: --
164: -- Issue a savepoint
165: --
166: savepoint UPDATE_BOOKING_JUSTIFICATION;

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

240: end if;
241: --
242: -- Set all output arguments
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: exception
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised

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

254: -- (Any key or derived arguments must be set to null
255: -- when validation only mode is being used.)
256: --
257: p_object_version_number := null;
258: hr_utility.set_location(' Leaving:'||l_proc, 80);
259: when others then
260: --
261: -- A validation or unexpected error has occured
262: --

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

261: -- A validation or unexpected error has occured
262: --
263: rollback to UPDATE_BOOKING_JUSTIFICATION;
264: p_object_version_number := l_object_version_number;
265: hr_utility.set_location(' Leaving:'||l_proc, 90);
266: raise;
267: end update_booking_justification;
268: --
269: -- ----------------------------------------------------------------------------

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

282: l_proc varchar2(72) := g_package||' Delete Booking Justification';
283: --
284: --
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Issue a savepoint
289: --
290: savepoint DELETE_BOOKING_JUSTIFICATION;

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

342: --
343: -- Set all output arguments
344: --
345: --
346: hr_utility.set_location(' Leaving:'||l_proc, 170);
347: exception
348: when hr_api.validate_enabled then
349: --
350: -- As the Validate_Enabled exception has been raised

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

355: -- Only set output warning arguments
356: -- (Any key or derived arguments must be set to null
357: -- when validation only mode is being used.)
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 180);
360: when others then
361: --
362: -- A validation or unexpected error has occured
363: --

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

361: --
362: -- A validation or unexpected error has occured
363: --
364: rollback to DELETE_BOOKING_JUSTIFICATION;
365: hr_utility.set_location(' Leaving:'||l_proc, 190);
366: raise;
367: end delete_booking_justification;
368: --
369: end ota_bkng_justification_api;