56: (p_object_capacity_rec.AVAILABLE_HOURS IS NULL))
57: THEN
58: fnd_message.set_name('JTF', 'JTF_CAL_REQUIRED_PARAMETERS');
59: fnd_message.set_token('P_PARAMETER','OBJECT_TYPE, OBJECT_ID, START_DATE_TIME, END_DATE_TIME, and AVAILABLE_HOURS');
60: fnd_msg_pub.add;
61: RETURN FALSE;
62: END IF;
63:
64: RETURN TRUE;
162: END IF;
163: -- initialize message stack if required
164: IF fnd_api.to_boolean(p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168: -- initialize return status
169: x_return_status := fnd_api.g_ret_sts_success;
170:
282: END IF;
283: END LOOP;
284: END IF;
285:
286: fnd_msg_pub.count_and_get( p_encoded => 'F'
287: , p_count => x_msg_count
288: , p_data => x_msg_data
289: );
290: EXCEPTION
290: EXCEPTION
291:
292: WHEN fnd_api.g_exc_error THEN
293: x_return_status := fnd_api.g_ret_sts_error;
294: fnd_msg_pub.count_and_get( p_encoded => 'F'
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298:
297: );
298:
299: WHEN fnd_api.g_exc_unexpected_error THEN
300: x_return_status := fnd_api.g_ret_sts_unexp_error;
301: fnd_msg_pub.count_and_get( p_encoded => 'F'
302: , p_count => x_msg_count
303: , p_data => x_msg_data
304: );
305:
304: );
305:
306: WHEN OTHERS THEN
307: x_return_status := fnd_api.g_ret_sts_unexp_error;
308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
309: THEN
310: fnd_msg_pub.add_exc_msg( g_pkg_name
311: , l_api_name
312: );
306: WHEN OTHERS THEN
307: x_return_status := fnd_api.g_ret_sts_unexp_error;
308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
309: THEN
310: fnd_msg_pub.add_exc_msg( g_pkg_name
311: , l_api_name
312: );
313: END IF;
314: fnd_msg_pub.count_and_get( p_encoded => 'F'
310: fnd_msg_pub.add_exc_msg( g_pkg_name
311: , l_api_name
312: );
313: END IF;
314: fnd_msg_pub.count_and_get( p_encoded => 'F'
315: , p_count => x_msg_count
316: , p_data => x_msg_data
317: );
318:
366: END IF;
367: -- initialize message stack if required
368: IF fnd_api.to_boolean(p_init_msg_list)
369: THEN
370: fnd_msg_pub.initialize;
371: END IF;
372: -- initialize return status
373: x_return_status := fnd_api.g_ret_sts_success;
374:
457: l_idx := p_Object_Tasks.NEXT(l_idx);
458: END LOOP;
459: END IF;
460:
461: fnd_msg_pub.count_and_get( p_encoded => 'F'
462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: EXCEPTION
465: EXCEPTION
466:
467: WHEN fnd_api.g_exc_error THEN
468: x_return_status := fnd_api.g_ret_sts_error;
469: fnd_msg_pub.count_and_get( p_encoded => 'F'
470: , p_count => x_msg_count
471: , p_data => x_msg_data
472: );
473:
472: );
473:
474: WHEN fnd_api.g_exc_unexpected_error THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: fnd_msg_pub.count_and_get( p_encoded => 'F'
477: , p_count => x_msg_count
478: , p_data => x_msg_data
479: );
480:
479: );
480:
481: WHEN OTHERS THEN
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
484: THEN
485: fnd_msg_pub.add_exc_msg( g_pkg_name
486: , l_api_name
487: );
481: WHEN OTHERS THEN
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
484: THEN
485: fnd_msg_pub.add_exc_msg( g_pkg_name
486: , l_api_name
487: );
488: END IF;
489: fnd_msg_pub.count_and_get( p_encoded => 'F'
485: fnd_msg_pub.add_exc_msg( g_pkg_name
486: , l_api_name
487: );
488: END IF;
489: fnd_msg_pub.count_and_get( p_encoded => 'F'
490: , p_count => x_msg_count
491: , p_data => x_msg_data
492: );
493:
558: END IF;
559: -- initialize message stack if required
560: IF fnd_api.to_boolean(p_init_msg_list)
561: THEN
562: fnd_msg_pub.initialize;
563: END IF;
564: -- initialize return status
565: x_return_status := fnd_api.g_ret_sts_success;
566:
581: IF C_ObjCap%NOTFOUND
582: THEN
583: CLOSE C_ObjCap;
584: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
585: fnd_msg_pub.add;
586: RAISE fnd_api.g_exc_unexpected_error;
587: END IF;
588: CLOSE C_ObjCap;
589:
591: IF (NVL(p_object_version_number, -1) <>
592: l_Object_Capacity.OBJECT_VERSION_NUMBER)
593: THEN
594: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
595: fnd_msg_pub.add;
596: RAISE fnd_api.g_exc_unexpected_error;
597: END IF;
598:
599: -- Copy the changed values
664: X_LAST_UPDATED_BY => l_user,
665: X_LAST_UPDATE_LOGIN => l_login
666: );
667:
668: fnd_msg_pub.count_and_get( p_encoded => 'F'
669: , p_count => x_msg_count
670: , p_data => x_msg_data
671: );
672: EXCEPTION
672: EXCEPTION
673:
674: WHEN fnd_api.g_exc_error THEN
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get( p_encoded => 'F'
677: , p_count => x_msg_count
678: , p_data => x_msg_data
679: );
680:
679: );
680:
681: WHEN fnd_api.g_exc_unexpected_error THEN
682: x_return_status := fnd_api.g_ret_sts_unexp_error;
683: fnd_msg_pub.count_and_get( p_encoded => 'F'
684: , p_count => x_msg_count
685: , p_data => x_msg_data
686: );
687:
686: );
687:
688: WHEN OTHERS THEN
689: x_return_status := fnd_api.g_ret_sts_unexp_error;
690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
691: THEN
692: fnd_msg_pub.add_exc_msg( g_pkg_name
693: , l_api_name
694: );
688: WHEN OTHERS THEN
689: x_return_status := fnd_api.g_ret_sts_unexp_error;
690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
691: THEN
692: fnd_msg_pub.add_exc_msg( g_pkg_name
693: , l_api_name
694: );
695: END IF;
696: fnd_msg_pub.count_and_get( p_encoded => 'F'
692: fnd_msg_pub.add_exc_msg( g_pkg_name
693: , l_api_name
694: );
695: END IF;
696: fnd_msg_pub.count_and_get( p_encoded => 'F'
697: , p_count => x_msg_count
698: , p_data => x_msg_data
699: );
700:
764: END IF;
765: -- initialize message stack if required
766: IF fnd_api.to_boolean(p_init_msg_list)
767: THEN
768: fnd_msg_pub.initialize;
769: END IF;
770: -- initialize return status
771: x_return_status := fnd_api.g_ret_sts_success;
772:
776: IF C_ObjCap%NOTFOUND
777: THEN
778: CLOSE C_ObjCap;
779: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
780: fnd_msg_pub.add;
781: RAISE fnd_api.g_exc_unexpected_error;
782: END IF;
783: CLOSE C_ObjCap;
784:
785: -- check if record updated by another user
786: IF (NVL(p_object_version_number, -1) <> l_object_version_number)
787: THEN
788: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
789: fnd_msg_pub.add;
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: -- check if task assignments need to be updated
827: (
828: X_OBJECT_CAPACITY_ID => p_object_capacity_id
829: );
830:
831: fnd_msg_pub.count_and_get( p_encoded => 'F'
832: , p_count => x_msg_count
833: , p_data => x_msg_data
834: );
835: EXCEPTION
835: EXCEPTION
836:
837: WHEN fnd_api.g_exc_error THEN
838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_msg_pub.count_and_get( p_encoded => 'F'
840: , p_count => x_msg_count
841: , p_data => x_msg_data
842: );
843:
842: );
843:
844: WHEN fnd_api.g_exc_unexpected_error THEN
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get( p_encoded => 'F'
847: , p_count => x_msg_count
848: , p_data => x_msg_data
849: );
850:
849: );
850:
851: WHEN OTHERS THEN
852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
854: THEN
855: fnd_msg_pub.add_exc_msg( g_pkg_name
856: , l_api_name
857: );
851: WHEN OTHERS THEN
852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
854: THEN
855: fnd_msg_pub.add_exc_msg( g_pkg_name
856: , l_api_name
857: );
858: END IF;
859: fnd_msg_pub.count_and_get( p_encoded => 'F'
855: fnd_msg_pub.add_exc_msg( g_pkg_name
856: , l_api_name
857: );
858: END IF;
859: fnd_msg_pub.count_and_get( p_encoded => 'F'
860: , p_count => x_msg_count
861: , p_data => x_msg_data
862: );
863:
903: END IF;
904: -- initialize message stack if required
905: IF fnd_api.to_boolean(p_init_msg_list)
906: THEN
907: fnd_msg_pub.initialize;
908: END IF;
909: -- initialize return status
910: x_return_status := fnd_api.g_ret_sts_success;
911:
908: END IF;
909: -- initialize return status
910: x_return_status := fnd_api.g_ret_sts_success;
911:
912: fnd_msg_pub.count_and_get( p_encoded => 'F'
913: , p_count => x_msg_count
914: , p_data => x_msg_data
915: );
916: EXCEPTION
916: EXCEPTION
917:
918: WHEN fnd_api.g_exc_error THEN
919: x_return_status := fnd_api.g_ret_sts_error;
920: fnd_msg_pub.count_and_get( p_encoded => 'F'
921: , p_count => x_msg_count
922: , p_data => x_msg_data
923: );
924:
923: );
924:
925: WHEN fnd_api.g_exc_unexpected_error THEN
926: x_return_status := fnd_api.g_ret_sts_unexp_error;
927: fnd_msg_pub.count_and_get( p_encoded => 'F'
928: , p_count => x_msg_count
929: , p_data => x_msg_data
930: );
931:
930: );
931:
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
935: THEN
936: fnd_msg_pub.add_exc_msg( g_pkg_name
937: , l_api_name
938: );
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
935: THEN
936: fnd_msg_pub.add_exc_msg( g_pkg_name
937: , l_api_name
938: );
939: END IF;
940: fnd_msg_pub.count_and_get( p_encoded => 'F'
936: fnd_msg_pub.add_exc_msg( g_pkg_name
937: , l_api_name
938: );
939: END IF;
940: fnd_msg_pub.count_and_get( p_encoded => 'F'
941: , p_count => x_msg_count
942: , p_data => x_msg_data
943: );
944: