DBA Data[Home] [Help]

APPS.CAC_SR_OBJECT_CAPACITY_PUB dependencies on FND_MSG_PUB

Line 60: fnd_msg_pub.add;

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;

Line 166: fnd_msg_pub.initialize;

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:

Line 286: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

Line 294: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 301: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 308: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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: );

Line 310: fnd_msg_pub.add_exc_msg( g_pkg_name

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'

Line 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:

Line 370: fnd_msg_pub.initialize;

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:

Line 461: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

Line 469: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 476: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 483: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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: );

Line 485: fnd_msg_pub.add_exc_msg( g_pkg_name

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'

Line 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:

Line 562: fnd_msg_pub.initialize;

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:

Line 585: fnd_msg_pub.add;

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:

Line 595: fnd_msg_pub.add;

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

Line 668: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

Line 676: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 683: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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: );

Line 692: fnd_msg_pub.add_exc_msg( g_pkg_name

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'

Line 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:

Line 768: fnd_msg_pub.initialize;

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:

Line 780: fnd_msg_pub.add;

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:

Line 789: fnd_msg_pub.add;

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

Line 831: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

Line 839: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 846: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 853: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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: );

Line 855: fnd_msg_pub.add_exc_msg( g_pkg_name

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'

Line 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:

Line 907: fnd_msg_pub.initialize;

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:

Line 912: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

Line 920: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 927: fnd_msg_pub.count_and_get( p_encoded => 'F'

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:

Line 934: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

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: );

Line 936: fnd_msg_pub.add_exc_msg( g_pkg_name

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'

Line 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: