eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_BOOKINGS_PUB dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2: /* $Header: cacpttbb.pls 120.3 2005/07/29 12:19:11 sbarat noship $ */
3:
4: PROCEDURE create_booking (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_booking_rec IN cac_bookings_pub.booking_type,
9: x_booking_id OUT NOCOPY NUMBER,
10: x_return_status OUT NOCOPY VARCHAR2,

Line 7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

3:
4: PROCEDURE create_booking (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_booking_rec IN cac_bookings_pub.booking_type,
9: x_booking_id OUT NOCOPY NUMBER,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,

Line 23: x_return_status := fnd_api.g_ret_sts_success;

19: l_booking_type_rec cac_bookings_pub.booking_type := p_booking_rec;
20:
21: BEGIN
22: SAVEPOINT create_bookings_pub;
23: x_return_status := fnd_api.g_ret_sts_success;
24:
25: IF fnd_api.to_boolean (p_init_msg_list)
26: THEN
27: fnd_msg_pub.initialize;

Line 25: IF fnd_api.to_boolean (p_init_msg_list)

21: BEGIN
22: SAVEPOINT create_bookings_pub;
23: x_return_status := fnd_api.g_ret_sts_success;
24:
25: IF fnd_api.to_boolean (p_init_msg_list)
26: THEN
27: fnd_msg_pub.initialize;
28: END IF;
29:

Line 30: IF NOT fnd_api.compatible_api_call (

26: THEN
27: fnd_msg_pub.initialize;
28: END IF;
29:
30: IF NOT fnd_api.compatible_api_call (
31: l_api_version,
32: p_api_version,
33: l_api_name,
34: g_pkg_name

Line 37: RAISE fnd_api.g_exc_unexpected_error;

33: l_api_name,
34: g_pkg_name
35: )
36: THEN
37: RAISE fnd_api.g_exc_unexpected_error;
38: END IF;
39:
40: -- Booking Rules...
41:

Line 51: p_init_msg_list => fnd_api.g_false,

47: );
48:
49: jtf_tasks_pvt.create_task (
50: p_api_version => 1.0,
51: p_init_msg_list => fnd_api.g_false,
52: p_commit => fnd_api.g_false,
53: p_task_name => l_booking_type_rec.booking_subject,
54: p_task_type_id => l_booking_type_rec.booking_type_id,
55: p_description => l_booking_type_rec.description,

Line 52: p_commit => fnd_api.g_false,

48:
49: jtf_tasks_pvt.create_task (
50: p_api_version => 1.0,
51: p_init_msg_list => fnd_api.g_false,
52: p_commit => fnd_api.g_false,
53: p_task_name => l_booking_type_rec.booking_subject,
54: p_task_type_id => l_booking_type_rec.booking_type_id,
55: p_description => l_booking_type_rec.description,
56: p_task_status_id => l_booking_type_rec.booking_status_id,

Line 79: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

75: x_msg_data => x_msg_data,
76: x_task_id => x_booking_id
77: );
78:
79: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
80: THEN
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:

Line 81: RAISE fnd_api.g_exc_unexpected_error;

77: );
78:
79: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
80: THEN
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:
84: IF fnd_api.to_boolean (p_commit)
85: THEN

Line 84: IF fnd_api.to_boolean (p_commit)

80: THEN
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:
84: IF fnd_api.to_boolean (p_commit)
85: THEN
86: COMMIT WORK;
87: END IF;
88:

Line 91: WHEN fnd_api.g_exc_unexpected_error

87: END IF;
88:
89: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
90: EXCEPTION
91: WHEN fnd_api.g_exc_unexpected_error
92: THEN
93: ROLLBACK TO create_bookings_pub;
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: fnd_msg_pub.count_and_get (

Line 94: x_return_status := fnd_api.g_ret_sts_unexp_error;

90: EXCEPTION
91: WHEN fnd_api.g_exc_unexpected_error
92: THEN
93: ROLLBACK TO create_bookings_pub;
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: fnd_msg_pub.count_and_get (
96: p_count => x_msg_count,
97: p_data => x_msg_data
98: );

Line 105: x_return_status := fnd_api.g_ret_sts_unexp_error;

101: ROLLBACK TO create_bookings_pub;
102: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106: fnd_msg_pub.count_and_get (
107: p_count => x_msg_count,
108: p_data => x_msg_data
109: );

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

110: END;
111:
112: PROCEDURE update_booking (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_booking_rec IN cac_bookings_pub.booking_type,
117: p_object_version_number IN NUMBER ,
118: x_return_status OUT NOCOPY VARCHAR2,

Line 115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

111:
112: PROCEDURE update_booking (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_booking_rec IN cac_bookings_pub.booking_type,
117: p_object_version_number IN NUMBER ,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,

Line 133: x_return_status := fnd_api.g_ret_sts_success;

129: l_booking_type_rec cac_bookings_pub.booking_type := p_booking_rec;
130:
131: BEGIN
132: SAVEPOINT update_bookings_pub;
133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: IF fnd_api.to_boolean (p_init_msg_list)
136: THEN
137: fnd_msg_pub.initialize;

Line 135: IF fnd_api.to_boolean (p_init_msg_list)

131: BEGIN
132: SAVEPOINT update_bookings_pub;
133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: IF fnd_api.to_boolean (p_init_msg_list)
136: THEN
137: fnd_msg_pub.initialize;
138: END IF;
139:

Line 140: IF NOT fnd_api.compatible_api_call (

136: THEN
137: fnd_msg_pub.initialize;
138: END IF;
139:
140: IF NOT fnd_api.compatible_api_call (
141: l_api_version,
142: p_api_version,
143: l_api_name,
144: g_pkg_name

Line 147: RAISE fnd_api.g_exc_unexpected_error;

143: l_api_name,
144: g_pkg_name
145: )
146: THEN
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: -- Booking Rules...
151: -- For booking scheduled dates are populated --'

Line 153: IF (l_booking_type_rec.booking_id = fnd_api.g_miss_num

149:
150: -- Booking Rules...
151: -- For booking scheduled dates are populated --'
152:
153: IF (l_booking_type_rec.booking_id = fnd_api.g_miss_num
154: OR l_booking_type_rec.booking_id IS NULL)
155: THEN
156: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
157: fnd_msg_pub.add;

Line 158: RAISE fnd_api.g_exc_unexpected_error;

154: OR l_booking_type_rec.booking_id IS NULL)
155: THEN
156: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
157: fnd_msg_pub.add;
158: RAISE fnd_api.g_exc_unexpected_error;
159: ELSE
160:
161: jtf_task_utl.validate_task (
162: p_task_id => l_booking_type_rec.booking_id,

Line 168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

164: x_task_id => l_booking_type_rec.booking_id,
165: x_return_status => x_return_status
166: );
167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;

Line 170: x_return_status := fnd_api.g_ret_sts_unexp_error;

166: );
167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: END IF;

Line 171: RAISE fnd_api.g_exc_unexpected_error;

167:
168: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
169: THEN
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: END IF;
175:

Line 188: p_init_msg_list => fnd_api.g_false,

184:
185:
186: jtf_tasks_pvt.update_task (
187: p_api_version => 1.0,
188: p_init_msg_list => fnd_api.g_false,
189: p_commit => fnd_api.g_false,
190: p_object_version_number => l_ovn,
191: p_task_id => l_booking_type_rec.booking_id,
192: p_task_name => l_booking_type_rec.booking_subject,

Line 189: p_commit => fnd_api.g_false,

185:
186: jtf_tasks_pvt.update_task (
187: p_api_version => 1.0,
188: p_init_msg_list => fnd_api.g_false,
189: p_commit => fnd_api.g_false,
190: p_object_version_number => l_ovn,
191: p_task_id => l_booking_type_rec.booking_id,
192: p_task_name => l_booking_type_rec.booking_subject,
193: p_task_type_id => l_booking_type_rec.booking_type_id,

Line 215: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

211: x_msg_count => x_msg_count,
212: x_msg_data => x_msg_data
213: );
214:
215: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
216: THEN
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219:

Line 217: RAISE fnd_api.g_exc_unexpected_error;

213: );
214:
215: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
216: THEN
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219:
220: IF fnd_api.to_boolean (p_commit)
221: THEN

Line 220: IF fnd_api.to_boolean (p_commit)

216: THEN
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219:
220: IF fnd_api.to_boolean (p_commit)
221: THEN
222: COMMIT WORK;
223: END IF;
224:

Line 227: WHEN fnd_api.g_exc_unexpected_error

223: END IF;
224:
225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
226: EXCEPTION
227: WHEN fnd_api.g_exc_unexpected_error
228: THEN
229: ROLLBACK TO update_bookings_pub;
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_msg_pub.count_and_get (

Line 230: x_return_status := fnd_api.g_ret_sts_unexp_error;

226: EXCEPTION
227: WHEN fnd_api.g_exc_unexpected_error
228: THEN
229: ROLLBACK TO update_bookings_pub;
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_msg_pub.count_and_get (
232: p_count => x_msg_count,
233: p_data => x_msg_data
234: );

Line 241: x_return_status := fnd_api.g_ret_sts_unexp_error;

237: ROLLBACK TO update_bookings_pub;
238: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
239: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
240: fnd_msg_pub.add;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );

Line 264: RAISE fnd_api.g_exc_unexpected_error;

260: IF (l_booking_type_rec.start_date IS NULL)
261: THEN
262: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_START_DATE');
263: fnd_msg_pub.add;
264: RAISE fnd_api.g_exc_unexpected_error;
265: END IF;
266:
267: IF (l_booking_type_rec.end_date IS NULL)
268: THEN

Line 271: RAISE fnd_api.g_exc_unexpected_error;

267: IF (l_booking_type_rec.end_date IS NULL)
268: THEN
269: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_END_DATE');
270: fnd_msg_pub.add;
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:
274: --Validations
275:

Line 283: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

279: x_return_status => x_return_status,
280: x_task_type_id => l_booking_type_rec.booking_type_id
281: );
282:
283: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
284: THEN
285: RAISE fnd_api.g_exc_unexpected_error;
286: END IF;
287:

Line 285: RAISE fnd_api.g_exc_unexpected_error;

281: );
282:
283: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
284: THEN
285: RAISE fnd_api.g_exc_unexpected_error;
286: END IF;
287:
288: IF l_booking_type_rec.booking_type_id IS NULL
289: THEN

Line 292: RAISE fnd_api.g_exc_unexpected_error;

288: IF l_booking_type_rec.booking_type_id IS NULL
289: THEN
290: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_TYPE');
291: fnd_msg_pub.add;
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294:
295: /* jtf_task_utl.validate_task_status (
296: p_task_status_id => l_booking_type_rec.booking_status_id,

Line 303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

299: x_return_status => x_return_status,
300: x_task_status_id => l_booking_type_rec.booking_status_id
301: );
302:
303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
304: THEN
305: RAISE fnd_api.g_exc_unexpected_error;
306: END IF;
307:

Line 305: RAISE fnd_api.g_exc_unexpected_error;

301: );
302:
303: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
304: THEN
305: RAISE fnd_api.g_exc_unexpected_error;
306: END IF;
307:
308: IF l_booking_type_rec.booking_status_id IS NULL
309: THEN

Line 312: RAISE fnd_api.g_exc_unexpected_error;

308: IF l_booking_type_rec.booking_status_id IS NULL
309: THEN
310: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_STATUS');
311: fnd_msg_pub.add;
312: RAISE fnd_api.g_exc_unexpected_error;
313: END IF; */
314:
315: jtf_task_utl.validate_dates (
316: p_date_tag => jtf_task_utl.get_translated_lookup (

Line 325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

321: p_end_date => l_booking_type_rec.end_date,
322: x_return_status => x_return_status
323: );
324:
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
326: THEN
327: RAISE fnd_api.g_exc_unexpected_error;
328: END IF;
329:

Line 327: RAISE fnd_api.g_exc_unexpected_error;

323: );
324:
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
326: THEN
327: RAISE fnd_api.g_exc_unexpected_error;
328: END IF;
329:
330: -- Validate Source Object Type Code --
331:

Line 349: RAISE fnd_api.g_exc_unexpected_error;

345: IF l_booking_type_rec.resource_id IS NULL
346: THEN
347: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_ID');
348: fnd_msg_pub.add;
349: RAISE fnd_api.g_exc_unexpected_error;
350: END IF;
351:
352: IF l_booking_type_rec.resource_type_code IS NULL
353: THEN

Line 356: RAISE fnd_api.g_exc_unexpected_error;

352: IF l_booking_type_rec.resource_type_code IS NULL
353: THEN
354: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_TYPE_CODE');
355: fnd_msg_pub.add;
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:
359: jtf_task_utl.validate_task_owner (
360: p_owner_type_code => l_booking_type_rec.resource_type_code,

Line 369: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

365: x_owner_type_code => l_booking_type_rec.resource_type_code
366: );
367:
368:
369: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
370: THEN
371: fnd_message.set_name ('JTF', 'BKG_INVALID_RESOURCE');
372: fnd_msg_pub.add;
373: RAISE fnd_api.g_exc_unexpected_error;

Line 373: RAISE fnd_api.g_exc_unexpected_error;

369: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
370: THEN
371: fnd_message.set_name ('JTF', 'BKG_INVALID_RESOURCE');
372: fnd_msg_pub.add;
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:
376: -- include booking usage here,,
377: /* jtf_task_utl.validate_source_object (

Line 384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

380: p_object_name => NULL,
381: x_return_status => x_return_status
382: );
383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: RAISE fnd_api.g_exc_unexpected_error;
387: END IF; */
388:

Line 386: RAISE fnd_api.g_exc_unexpected_error;

382: );
383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: RAISE fnd_api.g_exc_unexpected_error;
387: END IF; */
388:
389: -- Validate freebusytype ..
390: IF l_booking_type_rec.freebusytype NOT IN

Line 395: RAISE fnd_api.g_exc_unexpected_error;

391: ('FREE','BUSY','FREE_BUSY_TENTATIVE')
392: THEN
393: fnd_message.set_name ('CAC', 'CAC_BOOKING_INVALID_TYPE');
394: fnd_msg_pub.add;
395: RAISE fnd_api.g_exc_unexpected_error;
396: END IF;
397:
398:
399: END;

Line 403: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

399: END;
400:
401: PROCEDURE delete_booking (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
404: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
405: p_booking_id IN NUMBER,
406: p_object_version_number IN NUMBER ,
407: x_return_status OUT NOCOPY VARCHAR2,

Line 404: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

400:
401: PROCEDURE delete_booking (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
404: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
405: p_booking_id IN NUMBER,
406: p_object_version_number IN NUMBER ,
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,

Line 424: x_return_status := fnd_api.g_ret_sts_success;

420: := p_object_version_number;
421:
422: BEGIN
423: SAVEPOINT delete_bookings_pub;
424: x_return_status := fnd_api.g_ret_sts_success;
425:
426: IF fnd_api.to_boolean (p_init_msg_list)
427: THEN
428: fnd_msg_pub.initialize;

Line 426: IF fnd_api.to_boolean (p_init_msg_list)

422: BEGIN
423: SAVEPOINT delete_bookings_pub;
424: x_return_status := fnd_api.g_ret_sts_success;
425:
426: IF fnd_api.to_boolean (p_init_msg_list)
427: THEN
428: fnd_msg_pub.initialize;
429: END IF;
430:

Line 431: IF NOT fnd_api.compatible_api_call (

427: THEN
428: fnd_msg_pub.initialize;
429: END IF;
430:
431: IF NOT fnd_api.compatible_api_call (
432: l_api_version,
433: p_api_version,
434: l_api_name,
435: g_pkg_name

Line 438: RAISE fnd_api.g_exc_unexpected_error;

434: l_api_name,
435: g_pkg_name
436: )
437: THEN
438: RAISE fnd_api.g_exc_unexpected_error;
439: END IF;
440:
441: IF (l_task_id = fnd_api.g_miss_num)
442: OR (l_task_id IS NULL)

Line 441: IF (l_task_id = fnd_api.g_miss_num)

437: THEN
438: RAISE fnd_api.g_exc_unexpected_error;
439: END IF;
440:
441: IF (l_task_id = fnd_api.g_miss_num)
442: OR (l_task_id IS NULL)
443: THEN
444: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
445: fnd_msg_pub.add;

Line 446: RAISE fnd_api.g_exc_unexpected_error;

442: OR (l_task_id IS NULL)
443: THEN
444: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
445: fnd_msg_pub.add;
446: RAISE fnd_api.g_exc_unexpected_error;
447: END IF;
448:
449:
450: jtf_tasks_pvt.delete_task (

Line 452: p_init_msg_list => fnd_api.g_false,

448:
449:
450: jtf_tasks_pvt.delete_task (
451: p_api_version => 1.0,
452: p_init_msg_list => fnd_api.g_false,
453: p_commit => fnd_api.g_false,
454: p_object_version_number => l_ovn,
455: p_task_id => l_task_id,
456: x_return_status => x_return_status,

Line 453: p_commit => fnd_api.g_false,

449:
450: jtf_tasks_pvt.delete_task (
451: p_api_version => 1.0,
452: p_init_msg_list => fnd_api.g_false,
453: p_commit => fnd_api.g_false,
454: p_object_version_number => l_ovn,
455: p_task_id => l_task_id,
456: x_return_status => x_return_status,
457: x_msg_count => x_msg_count,

Line 461: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data
459: );
460:
461: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465:

Line 463: RAISE fnd_api.g_exc_unexpected_error;

459: );
460:
461: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465:
466: IF fnd_api.to_boolean (p_commit)
467: THEN

Line 466: IF fnd_api.to_boolean (p_commit)

462: THEN
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465:
466: IF fnd_api.to_boolean (p_commit)
467: THEN
468: COMMIT WORK;
469: END IF;
470:

Line 473: WHEN fnd_api.g_exc_unexpected_error

469: END IF;
470:
471: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
472: EXCEPTION
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: ROLLBACK TO delete_bookings_pub;
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: fnd_msg_pub.count_and_get (

Line 476: x_return_status := fnd_api.g_ret_sts_unexp_error;

472: EXCEPTION
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: ROLLBACK TO delete_bookings_pub;
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: fnd_msg_pub.count_and_get (
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );

Line 487: x_return_status := fnd_api.g_ret_sts_unexp_error;

483: ROLLBACK TO delete_bookings_pub;
484: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
485: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
486: fnd_msg_pub.add;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get (
489: p_count => x_msg_count,
490: p_data => x_msg_data
491: );