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 287: fnd_msg_pub.count_and_get( p_encoded => 'F'

283: END IF;
284: END LOOP;
285: END IF;
286:
287: fnd_msg_pub.count_and_get( p_encoded => 'F'
288: , p_count => x_msg_count
289: , p_data => x_msg_data
290: );
291: EXCEPTION

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

291: EXCEPTION
292:
293: WHEN fnd_api.g_exc_error THEN
294: x_return_status := fnd_api.g_ret_sts_error;
295: fnd_msg_pub.count_and_get( p_encoded => 'F'
296: , p_count => x_msg_count
297: , p_data => x_msg_data
298: );
299:

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

298: );
299:
300: WHEN fnd_api.g_exc_unexpected_error THEN
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: fnd_msg_pub.count_and_get( p_encoded => 'F'
303: , p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306:

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

305: );
306:
307: WHEN OTHERS THEN
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
310: THEN
311: fnd_msg_pub.add_exc_msg( g_pkg_name
312: , l_api_name
313: );

Line 311: fnd_msg_pub.add_exc_msg( g_pkg_name

307: WHEN OTHERS THEN
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
310: THEN
311: fnd_msg_pub.add_exc_msg( g_pkg_name
312: , l_api_name
313: );
314: END IF;
315: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

311: fnd_msg_pub.add_exc_msg( g_pkg_name
312: , l_api_name
313: );
314: END IF;
315: fnd_msg_pub.count_and_get( p_encoded => 'F'
316: , p_count => x_msg_count
317: , p_data => x_msg_data
318: );
319:

Line 371: fnd_msg_pub.initialize;

367: END IF;
368: -- initialize message stack if required
369: IF fnd_api.to_boolean(p_init_msg_list)
370: THEN
371: fnd_msg_pub.initialize;
372: END IF;
373: -- initialize return status
374: x_return_status := fnd_api.g_ret_sts_success;
375:

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

467: l_idx := p_Object_Tasks.NEXT(l_idx);
468: END LOOP;
469: END IF;
470:
471: fnd_msg_pub.count_and_get( p_encoded => 'F'
472: , p_count => x_msg_count
473: , p_data => x_msg_data
474: );
475: EXCEPTION

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

475: EXCEPTION
476:
477: WHEN fnd_api.g_exc_error THEN
478: x_return_status := fnd_api.g_ret_sts_error;
479: fnd_msg_pub.count_and_get( p_encoded => 'F'
480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483:

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

482: );
483:
484: WHEN fnd_api.g_exc_unexpected_error THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get( p_encoded => 'F'
487: , p_count => x_msg_count
488: , p_data => x_msg_data
489: );
490:

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

489: );
490:
491: WHEN OTHERS THEN
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
494: THEN
495: fnd_msg_pub.add_exc_msg( g_pkg_name
496: , l_api_name
497: );

Line 495: fnd_msg_pub.add_exc_msg( g_pkg_name

491: WHEN OTHERS THEN
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
494: THEN
495: fnd_msg_pub.add_exc_msg( g_pkg_name
496: , l_api_name
497: );
498: END IF;
499: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

495: fnd_msg_pub.add_exc_msg( g_pkg_name
496: , l_api_name
497: );
498: END IF;
499: fnd_msg_pub.count_and_get( p_encoded => 'F'
500: , p_count => x_msg_count
501: , p_data => x_msg_data
502: );
503:

Line 585: fnd_msg_pub.initialize;

581: END IF;
582: -- initialize message stack if required
583: IF fnd_api.to_boolean(p_init_msg_list)
584: THEN
585: fnd_msg_pub.initialize;
586: END IF;
587: -- initialize return status
588: x_return_status := fnd_api.g_ret_sts_success;
589:

Line 610: fnd_msg_pub.add;

606: IF C_ObjCap%NOTFOUND
607: THEN
608: CLOSE C_ObjCap;
609: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_unexpected_error;
612: END IF;
613: CLOSE C_ObjCap;
614:

Line 620: fnd_msg_pub.add;

616: IF (NVL(p_object_version_number, -1) <>
617: l_Object_Capacity.OBJECT_VERSION_NUMBER)
618: THEN
619: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
620: fnd_msg_pub.add;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
623:
624: -- Copy the changed values

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

723: X_LAST_UPDATED_BY => l_user,
724: X_LAST_UPDATE_LOGIN => l_login
725: );
726:
727: fnd_msg_pub.count_and_get( p_encoded => 'F'
728: , p_count => x_msg_count
729: , p_data => x_msg_data
730: );
731: EXCEPTION

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

731: EXCEPTION
732:
733: WHEN fnd_api.g_exc_error THEN
734: x_return_status := fnd_api.g_ret_sts_error;
735: fnd_msg_pub.count_and_get( p_encoded => 'F'
736: , p_count => x_msg_count
737: , p_data => x_msg_data
738: );
739:

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

738: );
739:
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get( p_encoded => 'F'
743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746:

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

745: );
746:
747: WHEN OTHERS THEN
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
750: THEN
751: fnd_msg_pub.add_exc_msg( g_pkg_name
752: , l_api_name
753: );

Line 751: fnd_msg_pub.add_exc_msg( g_pkg_name

747: WHEN OTHERS THEN
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
750: THEN
751: fnd_msg_pub.add_exc_msg( g_pkg_name
752: , l_api_name
753: );
754: END IF;
755: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

751: fnd_msg_pub.add_exc_msg( g_pkg_name
752: , l_api_name
753: );
754: END IF;
755: fnd_msg_pub.count_and_get( p_encoded => 'F'
756: , p_count => x_msg_count
757: , p_data => x_msg_data
758: );
759:

Line 827: fnd_msg_pub.initialize;

823: END IF;
824: -- initialize message stack if required
825: IF fnd_api.to_boolean(p_init_msg_list)
826: THEN
827: fnd_msg_pub.initialize;
828: END IF;
829: -- initialize return status
830: x_return_status := fnd_api.g_ret_sts_success;
831:

Line 839: fnd_msg_pub.add;

835: IF C_ObjCap%NOTFOUND
836: THEN
837: CLOSE C_ObjCap;
838: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
839: fnd_msg_pub.add;
840: RAISE fnd_api.g_exc_unexpected_error;
841: END IF;
842: CLOSE C_ObjCap;
843:

Line 848: fnd_msg_pub.add;

844: -- check if record updated by another user
845: IF (NVL(p_object_version_number, -1) <> l_object_version_number)
846: THEN
847: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
848: fnd_msg_pub.add;
849: RAISE fnd_api.g_exc_unexpected_error;
850: END IF;
851:
852: -- check if task assignments need to be updated

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

886: (
887: X_OBJECT_CAPACITY_ID => p_object_capacity_id
888: );
889:
890: fnd_msg_pub.count_and_get( p_encoded => 'F'
891: , p_count => x_msg_count
892: , p_data => x_msg_data
893: );
894: EXCEPTION

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

894: EXCEPTION
895:
896: WHEN fnd_api.g_exc_error THEN
897: x_return_status := fnd_api.g_ret_sts_error;
898: fnd_msg_pub.count_and_get( p_encoded => 'F'
899: , p_count => x_msg_count
900: , p_data => x_msg_data
901: );
902:

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

901: );
902:
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: x_return_status := fnd_api.g_ret_sts_unexp_error;
905: fnd_msg_pub.count_and_get( p_encoded => 'F'
906: , p_count => x_msg_count
907: , p_data => x_msg_data
908: );
909:

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

908: );
909:
910: WHEN OTHERS THEN
911: x_return_status := fnd_api.g_ret_sts_unexp_error;
912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
913: THEN
914: fnd_msg_pub.add_exc_msg( g_pkg_name
915: , l_api_name
916: );

Line 914: fnd_msg_pub.add_exc_msg( g_pkg_name

910: WHEN OTHERS THEN
911: x_return_status := fnd_api.g_ret_sts_unexp_error;
912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
913: THEN
914: fnd_msg_pub.add_exc_msg( g_pkg_name
915: , l_api_name
916: );
917: END IF;
918: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

914: fnd_msg_pub.add_exc_msg( g_pkg_name
915: , l_api_name
916: );
917: END IF;
918: fnd_msg_pub.count_and_get( p_encoded => 'F'
919: , p_count => x_msg_count
920: , p_data => x_msg_data
921: );
922:

Line 966: fnd_msg_pub.initialize;

962: END IF;
963: -- initialize message stack if required
964: IF fnd_api.to_boolean(p_init_msg_list)
965: THEN
966: fnd_msg_pub.initialize;
967: END IF;
968: -- initialize return status
969: x_return_status := fnd_api.g_ret_sts_success;
970:

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

967: END IF;
968: -- initialize return status
969: x_return_status := fnd_api.g_ret_sts_success;
970:
971: fnd_msg_pub.count_and_get( p_encoded => 'F'
972: , p_count => x_msg_count
973: , p_data => x_msg_data
974: );
975: EXCEPTION

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

975: EXCEPTION
976:
977: WHEN fnd_api.g_exc_error THEN
978: x_return_status := fnd_api.g_ret_sts_error;
979: fnd_msg_pub.count_and_get( p_encoded => 'F'
980: , p_count => x_msg_count
981: , p_data => x_msg_data
982: );
983:

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

982: );
983:
984: WHEN fnd_api.g_exc_unexpected_error THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986: fnd_msg_pub.count_and_get( p_encoded => 'F'
987: , p_count => x_msg_count
988: , p_data => x_msg_data
989: );
990:

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

989: );
990:
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
994: THEN
995: fnd_msg_pub.add_exc_msg( g_pkg_name
996: , l_api_name
997: );

Line 995: fnd_msg_pub.add_exc_msg( g_pkg_name

991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
994: THEN
995: fnd_msg_pub.add_exc_msg( g_pkg_name
996: , l_api_name
997: );
998: END IF;
999: fnd_msg_pub.count_and_get( p_encoded => 'F'

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

995: fnd_msg_pub.add_exc_msg( g_pkg_name
996: , l_api_name
997: );
998: END IF;
999: fnd_msg_pub.count_and_get( p_encoded => 'F'
1000: , p_count => x_msg_count
1001: , p_data => x_msg_data
1002: );
1003: