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.JTF_RS_RES_AVAILABILITY_PVT dependencies on FND_API

Line 80: x_return_status := fnd_api.g_ret_sts_success;

76: BEGIN
77: --Standard Start of API SAVEPOINT
78: SAVEPOINT RESOURCE_AVAILABILITY_SP;
79:
80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN

Line 83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

79:
80: x_return_status := fnd_api.g_ret_sts_success;
81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:

Line 85: RAISE FND_API.G_EXC_ERROR;

81:
82: --Standard Call to check API compatibility
83: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 89: IF FND_API.To_boolean(P_INIT_MSG_LIST)

85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)
90: THEN
91: FND_MSG_PUB.Initialize;
92: END IF;
93:

Line 145: raise fnd_api.g_exc_error;

141: CLOSE c_dup_res_avail;
142: END IF;
143: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
144: FND_MSG_PUB.add;
145: raise fnd_api.g_exc_error;
146: END IF;
147: IF c_dup_res_avail%ISOPEN THEN
148: CLOSE c_dup_res_avail;
149: END IF;

Line 155: IF fnd_api.to_boolean (p_commit)

151: -- Return Availability ID
152: x_availability_id := l_availability_id;
153:
154: --standard commit
155: IF fnd_api.to_boolean (p_commit)
156: THEN
157: COMMIT WORK;
158: END IF;
159:

Line 163: WHEN fnd_api.g_exc_unexpected_error

159:
160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161:
162: EXCEPTION
163: WHEN fnd_api.g_exc_unexpected_error
164: THEN
165: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 166: x_return_status := fnd_api.g_ret_sts_unexp_error;

162: EXCEPTION
163: WHEN fnd_api.g_exc_unexpected_error
164: THEN
165: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
168: WHEN fnd_api.g_exc_error
169: THEN
170: ROLLBACK TO RESOURCE_AVAILABILITY_SP;

Line 168: WHEN fnd_api.g_exc_error

164: THEN
165: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
168: WHEN fnd_api.g_exc_error
169: THEN
170: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
171: x_return_status := fnd_api.g_ret_sts_error;
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 171: x_return_status := fnd_api.g_ret_sts_error;

167: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
168: WHEN fnd_api.g_exc_error
169: THEN
170: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
171: x_return_status := fnd_api.g_ret_sts_error;
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
173: WHEN OTHERS
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;

Line 181: x_return_status := fnd_api.g_ret_sts_unexp_error;

177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
183:
184: END create_res_availability;
185:

Line 309: x_return_status := fnd_api.g_ret_sts_success;

305: BEGIN
306: --Standard Start of API SAVEPOINT
307: SAVEPOINT RES_AVAILABILITY_SP;
308:
309: x_return_status := fnd_api.g_ret_sts_success;
310:
311: --Standard Call to check API compatibility
312: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
313: THEN

Line 312: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

308:
309: x_return_status := fnd_api.g_ret_sts_success;
310:
311: --Standard Call to check API compatibility
312: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
313: THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:

Line 314: RAISE FND_API.G_EXC_ERROR;

310:
311: --Standard Call to check API compatibility
312: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
313: THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:
317: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
318: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 318: IF FND_API.To_boolean(P_INIT_MSG_LIST)

314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:
317: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
318: IF FND_API.To_boolean(P_INIT_MSG_LIST)
319: THEN
320: FND_MSG_PUB.Initialize;
321: END IF;
322:

Line 334: IF (p_resource_id = FND_API.G_MISS_NUM)

330: FETCH resource_cur INTO resource_rec;
331:
332: IF (resource_cur%found) THEN
333:
334: IF (p_resource_id = FND_API.G_MISS_NUM)
335: THEN
336: l_resource_id := resource_rec.resource_id;
337: ELSE
338: l_resource_id := p_resource_id;

Line 341: IF (p_available_flag = FND_API.G_MISS_CHAR)

337: ELSE
338: l_resource_id := p_resource_id;
339: END IF;
340:
341: IF (p_available_flag = FND_API.G_MISS_CHAR)
342: THEN
343: l_available_flag := resource_rec.available_flag;
344: ELSE
345: l_available_flag := p_available_flag;

Line 348: IF (p_reason_code = FND_API.G_MISS_CHAR)

344: ELSE
345: l_available_flag := p_available_flag;
346: END IF;
347:
348: IF (p_reason_code = FND_API.G_MISS_CHAR)
349: THEN
350: l_reason_code := resource_rec.reason_code;
351: ELSE
352: l_reason_code := p_reason_code;

Line 355: IF (p_start_date = FND_API.G_MISS_DATE)

351: ELSE
352: l_reason_code := p_reason_code;
353: END IF;
354:
355: IF (p_start_date = FND_API.G_MISS_DATE)
356: THEN
357: l_start_date := resource_rec.start_date;
358: ELSE
359: l_start_date := p_start_date;

Line 362: IF (p_end_date = FND_API.G_MISS_DATE)

358: ELSE
359: l_start_date := p_start_date;
360: END IF;
361:
362: IF (p_end_date = FND_API.G_MISS_DATE)
363: THEN
364: l_end_date := resource_rec.end_date;
365: ELSE
366: l_end_date := p_end_date;

Line 369: IF (p_mode_of_availability = FND_API.G_MISS_CHAR)

365: ELSE
366: l_end_date := p_end_date;
367: END IF;
368:
369: IF (p_mode_of_availability = FND_API.G_MISS_CHAR)
370: THEN
371: l_mode_of_availability := resource_rec.mode_of_availability;
372: ELSE
373: l_mode_of_availability := p_mode_of_availability;

Line 376: IF(p_attribute1 = FND_API.G_MISS_CHAR)

372: ELSE
373: l_mode_of_availability := p_mode_of_availability;
374: END IF;
375:
376: IF(p_attribute1 = FND_API.G_MISS_CHAR)
377: THEN
378: l_attribute1 := resource_rec.attribute1;
379: ELSE
380: l_attribute1 := p_attribute1;

Line 383: IF(p_attribute2 = FND_API.G_MISS_CHAR)

379: ELSE
380: l_attribute1 := p_attribute1;
381: END IF;
382:
383: IF(p_attribute2 = FND_API.G_MISS_CHAR)
384: THEN
385: l_attribute2 := resource_rec.attribute2;
386: ELSE
387: l_attribute2 := p_attribute2;

Line 390: IF(p_attribute3 = FND_API.G_MISS_CHAR)

386: ELSE
387: l_attribute2 := p_attribute2;
388: END IF;
389:
390: IF(p_attribute3 = FND_API.G_MISS_CHAR)
391: THEN
392: l_attribute3 := resource_rec.attribute3;
393: ELSE
394: l_attribute3 := p_attribute3;

Line 397: IF(p_attribute4 = FND_API.G_MISS_CHAR)

393: ELSE
394: l_attribute3 := p_attribute3;
395: END IF;
396:
397: IF(p_attribute4 = FND_API.G_MISS_CHAR)
398: THEN
399: l_attribute4 := resource_rec.attribute4;
400: ELSE
401: l_attribute4 := p_attribute4;

Line 404: IF(p_attribute5 = FND_API.G_MISS_CHAR)

400: ELSE
401: l_attribute4 := p_attribute4;
402: END IF;
403:
404: IF(p_attribute5 = FND_API.G_MISS_CHAR)
405: THEN
406: l_attribute5 := resource_rec.attribute5;
407: ELSE
408: l_attribute5 := p_attribute5;

Line 411: IF(p_attribute6 = FND_API.G_MISS_CHAR)

407: ELSE
408: l_attribute5 := p_attribute5;
409: END IF;
410:
411: IF(p_attribute6 = FND_API.G_MISS_CHAR)
412: THEN
413: l_attribute6 := resource_rec.attribute6;
414: ELSE
415: l_attribute6 := p_attribute6;

Line 418: IF(p_attribute7 = FND_API.G_MISS_CHAR)

414: ELSE
415: l_attribute6 := p_attribute6;
416: END IF;
417:
418: IF(p_attribute7 = FND_API.G_MISS_CHAR)
419: THEN
420: l_attribute7 := resource_rec.attribute7;
421: ELSE
422: l_attribute7 := p_attribute7;

Line 425: IF(p_attribute8 = FND_API.G_MISS_CHAR)

421: ELSE
422: l_attribute7 := p_attribute7;
423: END IF;
424:
425: IF(p_attribute8 = FND_API.G_MISS_CHAR)
426: THEN
427: l_attribute8 := resource_rec.attribute8;
428: ELSE
429: l_attribute8 := p_attribute8;

Line 432: IF(p_attribute9 = FND_API.G_MISS_CHAR)

428: ELSE
429: l_attribute8 := p_attribute8;
430: END IF;
431:
432: IF(p_attribute9 = FND_API.G_MISS_CHAR)
433: THEN
434: l_attribute9 := resource_rec.attribute9;
435: ELSE
436: l_attribute9 := p_attribute9;

Line 439: IF(p_attribute10 = FND_API.G_MISS_CHAR)

435: ELSE
436: l_attribute9 := p_attribute9;
437: END IF;
438:
439: IF(p_attribute10 = FND_API.G_MISS_CHAR)
440: THEN
441: l_attribute10 := resource_rec.attribute10;
442: ELSE
443: l_attribute10 := p_attribute10;

Line 446: IF(p_attribute11 = FND_API.G_MISS_CHAR)

442: ELSE
443: l_attribute10 := p_attribute10;
444: END IF;
445:
446: IF(p_attribute11 = FND_API.G_MISS_CHAR)
447: THEN
448: l_attribute11 := resource_rec.attribute11;
449: ELSE
450: l_attribute11 := p_attribute11;

Line 453: IF(p_attribute12 = FND_API.G_MISS_CHAR)

449: ELSE
450: l_attribute11 := p_attribute11;
451: END IF;
452:
453: IF(p_attribute12 = FND_API.G_MISS_CHAR)
454: THEN
455: l_attribute12 := resource_rec.attribute12;
456: ELSE
457: l_attribute12 := p_attribute12;

Line 460: IF(p_attribute13 = FND_API.G_MISS_CHAR)

456: ELSE
457: l_attribute12 := p_attribute12;
458: END IF;
459:
460: IF(p_attribute13 = FND_API.G_MISS_CHAR)
461: THEN
462: l_attribute13 := resource_rec.attribute13;
463: ELSE
464: l_attribute13 := p_attribute13;

Line 467: IF(p_attribute14 = FND_API.G_MISS_CHAR)

463: ELSE
464: l_attribute13 := p_attribute13;
465: END IF;
466:
467: IF(p_attribute14 = FND_API.G_MISS_CHAR)
468: THEN
469: l_attribute14 := resource_rec.attribute14;
470: ELSE
471: l_attribute14 := p_attribute14;

Line 474: IF(p_attribute15 = FND_API.G_MISS_CHAR)

470: ELSE
471: l_attribute14 := p_attribute14;
472: END IF;
473:
474: IF(p_attribute15 = FND_API.G_MISS_CHAR)
475: THEN
476: l_attribute15 := resource_rec.attribute15;
477: ELSE
478: l_attribute15 := p_attribute15;

Line 481: IF(p_attribute_category = FND_API.G_MISS_CHAR)

477: ELSE
478: l_attribute15 := p_attribute15;
479: END IF;
480:
481: IF(p_attribute_category = FND_API.G_MISS_CHAR)
482: THEN
483: l_attribute_category := resource_rec.attribute_category;
484: ELSE
485: l_attribute_category := p_attribute_category;

Line 496: raise fnd_api.g_exc_error;

492: CLOSE c_dup_res_avail;
493: END IF;
494: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
495: FND_MSG_PUB.add;
496: raise fnd_api.g_exc_error;
497: END IF;
498: IF c_dup_res_avail%ISOPEN THEN
499: CLOSE c_dup_res_avail;
500: END IF;

Line 512: x_return_status := fnd_api.g_ret_sts_error;

508:
509: EXCEPTION
510:
511: WHEN OTHERS THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
514: fnd_msg_pub.add;
515: RAISE fnd_api.g_exc_error;
516:

Line 515: RAISE fnd_api.g_exc_error;

511: WHEN OTHERS THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
514: fnd_msg_pub.add;
515: RAISE fnd_api.g_exc_error;
516:
517: END;
518:
519:

Line 556: x_return_status := fnd_api.g_ret_sts_error;

552:
553: P_OBJECT_VERSION_NUM := l_object_version_number;
554:
555: ELSIF (resource_cur%notfound) THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
558: FND_MSG_PUB.add;
559: RAISE fnd_api.g_exc_error;
560:

Line 559: RAISE fnd_api.g_exc_error;

555: ELSIF (resource_cur%notfound) THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
558: FND_MSG_PUB.add;
559: RAISE fnd_api.g_exc_error;
560:
561: END IF;
562:
563: CLOSE resource_cur;

Line 565: IF fnd_api.to_boolean (p_commit)

561: END IF;
562:
563: CLOSE resource_cur;
564:
565: IF fnd_api.to_boolean (p_commit)
566: THEN
567: COMMIT WORK;
568: END IF;
569:

Line 573: WHEN fnd_api.g_exc_error

569:
570: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571:
572: EXCEPTION
573: WHEN fnd_api.g_exc_error
574: THEN
575: ROLLBACK TO RES_AVAILABILITY_SP;
576: x_return_status := fnd_api.g_ret_sts_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 576: x_return_status := fnd_api.g_ret_sts_error;

572: EXCEPTION
573: WHEN fnd_api.g_exc_error
574: THEN
575: ROLLBACK TO RES_AVAILABILITY_SP;
576: x_return_status := fnd_api.g_ret_sts_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: WHEN fnd_api.g_exc_unexpected_error
579: THEN
580: ROLLBACK TO RES_AVAILABILITY_SP;

Line 578: WHEN fnd_api.g_exc_unexpected_error

574: THEN
575: ROLLBACK TO RES_AVAILABILITY_SP;
576: x_return_status := fnd_api.g_ret_sts_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: WHEN fnd_api.g_exc_unexpected_error
579: THEN
580: ROLLBACK TO RES_AVAILABILITY_SP;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 581: x_return_status := fnd_api.g_ret_sts_unexp_error;

577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: WHEN fnd_api.g_exc_unexpected_error
579: THEN
580: ROLLBACK TO RES_AVAILABILITY_SP;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
583: WHEN OTHERS
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;

Line 591: x_return_status := fnd_api.g_ret_sts_unexp_error;

587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
593: END update_res_availability;
594:
595:

Line 635: x_return_status := fnd_api.g_ret_sts_success;

631: BEGIN
632: --Standard Start of API SAVEPOINT
633: SAVEPOINT RES_AVAILABILITY_SP;
634:
635: x_return_status := fnd_api.g_ret_sts_success;
636:
637: --Standard Call to check API compatibility
638: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
639: THEN

Line 638: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

634:
635: x_return_status := fnd_api.g_ret_sts_success;
636:
637: --Standard Call to check API compatibility
638: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
639: THEN
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642:

Line 640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

636:
637: --Standard Call to check API compatibility
638: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
639: THEN
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642:
643: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
644: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 644: IF FND_API.To_boolean(P_INIT_MSG_LIST)

640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642:
643: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
644: IF FND_API.To_boolean(P_INIT_MSG_LIST)
645: THEN
646: FND_MSG_PUB.Initialize;
647: END IF;
648:

Line 658: x_return_status := fnd_api.g_ret_sts_error;

654: JTF_RS_RES_AVAILABILITY_PKG.DELETE_ROW(
655: X_AVAILABILITY_ID => l_availability_id);
656:
657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;
659: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
660: FND_MSG_PUB.add;
661: RAISE fnd_api.g_exc_error;
662:

Line 661: RAISE fnd_api.g_exc_error;

657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;
659: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
660: FND_MSG_PUB.add;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
664:
665: CLOSE chk_res_exist_cur;

Line 667: IF fnd_api.to_boolean (p_commit)

663: END IF;
664:
665: CLOSE chk_res_exist_cur;
666:
667: IF fnd_api.to_boolean (p_commit)
668: THEN
669: COMMIT WORK;
670: END IF;
671:

Line 675: WHEN fnd_api.g_exc_unexpected_error

671:
672: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
673:
674: EXCEPTION
675: WHEN fnd_api.g_exc_unexpected_error
676: THEN
677: ROLLBACK TO RES_AVAILABILITY_SP;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 678: x_return_status := fnd_api.g_ret_sts_unexp_error;

674: EXCEPTION
675: WHEN fnd_api.g_exc_unexpected_error
676: THEN
677: ROLLBACK TO RES_AVAILABILITY_SP;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO RES_AVAILABILITY_SP;

Line 680: WHEN fnd_api.g_exc_error

676: THEN
677: ROLLBACK TO RES_AVAILABILITY_SP;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO RES_AVAILABILITY_SP;
683: x_return_status := fnd_api.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 683: x_return_status := fnd_api.g_ret_sts_error;

679: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO RES_AVAILABILITY_SP;
683: x_return_status := fnd_api.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685: WHEN OTHERS
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;

Line 693: x_return_status := fnd_api.g_ret_sts_unexp_error;

689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: END delete_res_availability;
697: