15:
16: PROCEDURE create_cust_setup
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,
16: PROCEDURE create_cust_setup
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
48: BEGIN
49: -- initialize
50: SAVEPOINT create_cust_setup;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: IF (AMS_DEBUG_HIGH_ON) THEN
60: AMS_Utility_PVT.debug_message(l_full_name || ': start');
61:
62: END IF;
63:
64: IF NOT FND_API.compatible_api_call
65: (
66: l_api_version,
67: p_api_version,
68: l_api_name,
68: l_api_name,
69: g_pkg_name
70: )
71: THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.g_ret_sts_success;
76:
71: THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: -- validate
78: IF (AMS_DEBUG_HIGH_ON) THEN
79:
90: x_msg_data => x_msg_data,
91: p_cust_setup_rec => l_cust_setup_rec
92: );
93:
94: IF l_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
97: RAISE FND_API.g_exc_unexpected_error;
98: END IF;
91: p_cust_setup_rec => l_cust_setup_rec
92: );
93:
94: IF l_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
97: RAISE FND_API.g_exc_unexpected_error;
98: END IF;
99:
92: );
93:
94: IF l_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
97: RAISE FND_API.g_exc_unexpected_error;
98: END IF;
99:
100: -- generate an unique ID if it is not parsed in
93:
94: IF l_return_status = FND_API.g_ret_sts_error THEN
95: RAISE FND_API.g_exc_error;
96: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
97: RAISE FND_API.g_exc_unexpected_error;
98: END IF;
99:
100: -- generate an unique ID if it is not parsed in
101: IF l_cust_setup_rec.custom_setup_id IS NULL THEN
528:
529:
530:
531:
532: IF FND_API.to_boolean(p_commit) THEN
533: COMMIT;
534: END IF;
535:
536: FND_MSG_PUB.count_and_get
534: END IF;
535:
536: FND_MSG_PUB.count_and_get
537: (
538: p_encoded => FND_API.g_false,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );
542:
549: END IF;
550:
551: EXCEPTION
552:
553: WHEN FND_API.g_exc_error THEN
554: ROLLBACK TO create_cust_setup;
555: x_return_status := FND_API.g_ret_sts_error;
556: FND_MSG_PUB.count_and_get
557: (
551: EXCEPTION
552:
553: WHEN FND_API.g_exc_error THEN
554: ROLLBACK TO create_cust_setup;
555: x_return_status := FND_API.g_ret_sts_error;
556: FND_MSG_PUB.count_and_get
557: (
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,
554: ROLLBACK TO create_cust_setup;
555: x_return_status := FND_API.g_ret_sts_error;
556: FND_MSG_PUB.count_and_get
557: (
558: p_encoded => FND_API.g_false,
559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562:
559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562:
563: WHEN FND_API.g_exc_unexpected_error THEN
564: ROLLBACK TO create_cust_setup;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: FND_MSG_PUB.count_and_get
567: (
561: );
562:
563: WHEN FND_API.g_exc_unexpected_error THEN
564: ROLLBACK TO create_cust_setup;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: FND_MSG_PUB.count_and_get
567: (
568: p_encoded => FND_API.g_false,
569: p_count => x_msg_count,
564: ROLLBACK TO create_cust_setup;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: FND_MSG_PUB.count_and_get
567: (
568: p_encoded => FND_API.g_false,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572:
571: );
572:
573: WHEN OTHERS THEN
574: ROLLBACK TO create_cust_setup;
575: x_return_status :=FND_API.g_ret_sts_unexp_error;
576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
577: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
578: END IF;
579: FND_MSG_PUB.count_and_get
577: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
578: END IF;
579: FND_MSG_PUB.count_and_get
580: (
581: p_encoded => FND_API.g_false,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585:
594: -------------------------------------------------------------------------------
595: PROCEDURE update_cust_setup
596: (
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
599: p_commit IN VARCHAR2 := FND_API.g_false,
600: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
595: PROCEDURE update_cust_setup
596: (
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
599: p_commit IN VARCHAR2 := FND_API.g_false,
600: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2,
596: (
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
599: p_commit IN VARCHAR2 := FND_API.g_false,
600: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2,
604:
616:
617: -- initialize
618: SAVEPOINT update_cust_setup;
619:
620: IF FND_API.to_boolean(p_init_msg_list) THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: IF (AMS_DEBUG_HIGH_ON) THEN
628: AMS_Utility_PVT.debug_message(l_full_name || ': start');
629:
630: END IF;
631:
632: IF NOT FND_API.compatible_api_call
633: (
634: l_api_version,
635: p_api_version,
636: l_api_name,
636: l_api_name,
637: g_pkg_name
638: )
639: THEN
640: RAISE FND_API.g_exc_unexpected_error;
641: END IF;
642:
643: x_return_status := FND_API.g_ret_sts_success;
644:
639: THEN
640: RAISE FND_API.g_exc_unexpected_error;
641: END IF;
642:
643: x_return_status := FND_API.g_ret_sts_success;
644:
645: -- check custom_setup_id, dont update setups if id < 10000 as they are seed data
646: /**
647: IF l_cust_setup_rec.custom_setup_id < 10000 THEN
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');
650: FND_MSG_PUB.add;
651: END IF;
652: RAISE FND_API.g_exc_error;
653: END IF;
654: **/
655: -- complete the record
656: complete_cust_setup_rec
675: x_return_status => l_return_status,
676: p_cust_setup_rec => l_cust_setup_rec
677: );
678:
679: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
680: RAISE FND_API.g_exc_unexpected_error;
681: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
682: RAISE FND_API.g_exc_error;
683: END IF;
676: p_cust_setup_rec => l_cust_setup_rec
677: );
678:
679: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
680: RAISE FND_API.g_exc_unexpected_error;
681: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
682: RAISE FND_API.g_exc_error;
683: END IF;
684: END IF;
677: );
678:
679: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
680: RAISE FND_API.g_exc_unexpected_error;
681: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
682: RAISE FND_API.g_exc_error;
683: END IF;
684: END IF;
685:
678:
679: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
680: RAISE FND_API.g_exc_unexpected_error;
681: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
682: RAISE FND_API.g_exc_error;
683: END IF;
684: END IF;
685:
686:
709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
710: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
711: FND_MSG_PUB.add;
712: END IF;
713: RAISE FND_API.g_exc_error;
714: END IF;
715:
716: UPDATE AMS_CUSTOM_SETUPS_TL SET
717: last_update_date = SYSDATE,
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
729: FND_MSG_PUB.add;
730: END IF;
731: RAISE FND_API.g_exc_error;
732: END IF;
733:
734: -- finish
735: IF FND_API.to_boolean(p_commit) THEN
731: RAISE FND_API.g_exc_error;
732: END IF;
733:
734: -- finish
735: IF FND_API.to_boolean(p_commit) THEN
736: COMMIT;
737: END IF;
738:
739: FND_MSG_PUB.count_and_get
737: END IF;
738:
739: FND_MSG_PUB.count_and_get
740: (
741: P_ENCODED => FND_API.g_false,
742: p_count => x_msg_count,
743: p_data => x_msg_data
744: );
745:
752: END IF;
753:
754: EXCEPTION
755:
756: WHEN FND_API.g_exc_error THEN
757: ROLLBACK TO update_cust_setup;
758: x_return_status := FND_API.g_ret_sts_error;
759: FND_MSG_PUB.count_and_get
760: (
754: EXCEPTION
755:
756: WHEN FND_API.g_exc_error THEN
757: ROLLBACK TO update_cust_setup;
758: x_return_status := FND_API.g_ret_sts_error;
759: FND_MSG_PUB.count_and_get
760: (
761: p_encoded => FND_API.g_false,
762: p_count => x_msg_count,
757: ROLLBACK TO update_cust_setup;
758: x_return_status := FND_API.g_ret_sts_error;
759: FND_MSG_PUB.count_and_get
760: (
761: p_encoded => FND_API.g_false,
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );
765:
762: p_count => x_msg_count,
763: p_data => x_msg_data
764: );
765:
766: WHEN FND_API.g_exc_unexpected_error THEN
767: ROLLBACK TO update_cust_setup;
768: x_return_status := FND_API.g_ret_sts_unexp_error;
769: FND_MSG_PUB.count_and_get
770: (
764: );
765:
766: WHEN FND_API.g_exc_unexpected_error THEN
767: ROLLBACK TO update_cust_setup;
768: x_return_status := FND_API.g_ret_sts_unexp_error;
769: FND_MSG_PUB.count_and_get
770: (
771: p_encoded => FND_API.g_false,
772: p_count => x_msg_count,
767: ROLLBACK TO update_cust_setup;
768: x_return_status := FND_API.g_ret_sts_unexp_error;
769: FND_MSG_PUB.count_and_get
770: (
771: p_encoded => FND_API.g_false,
772: p_count => x_msg_count,
773: p_data => x_msg_data
774: );
775:
774: );
775:
776: WHEN OTHERS THEN
777: ROLLBACK TO update_cust_setup;
778: x_return_status :=FND_API.g_ret_sts_unexp_error;
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
780: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: FND_MSG_PUB.count_and_get
780: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: FND_MSG_PUB.count_and_get
783: (
784: p_encoded => FND_API.g_false,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
788:
797: -------------------------------------------------------------------------------
798: PROCEDURE delete_cust_setup
799: (
800: p_api_version IN NUMBER,
801: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
802: p_commit IN VARCHAR2 := FND_API.g_false,
803:
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
798: PROCEDURE delete_cust_setup
799: (
800: p_api_version IN NUMBER,
801: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
802: p_commit IN VARCHAR2 := FND_API.g_false,
803:
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2,
829: BEGIN
830: -- initialize
831: SAVEPOINT delete_cust_setup;
832:
833: IF FND_API.to_boolean(p_init_msg_list) THEN
834: FND_MSG_PUB.initialize;
835: END IF;
836:
837: IF (AMS_DEBUG_HIGH_ON) THEN
841: AMS_Utility_PVT.debug_message(l_full_name || ': start');
842:
843: END IF;
844:
845: IF NOT FND_API.compatible_api_call
846: (
847: l_api_version,
848: p_api_version,
849: l_api_name,
849: l_api_name,
850: g_pkg_name
851: )
852: THEN
853: RAISE FND_API.g_exc_unexpected_error;
854: END IF;
855:
856: x_return_status := FND_API.g_ret_sts_success;
857:
852: THEN
853: RAISE FND_API.g_exc_unexpected_error;
854: END IF;
855:
856: x_return_status := FND_API.g_ret_sts_success;
857:
858: -- check custom_setup_id, dont delete setups if id < 10000 as they are seed data
859: IF p_cust_setup_id < 10000 THEN
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
861: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_SEED_DATA');
862: FND_MSG_PUB.add;
863: END IF;
864: RAISE FND_API.g_exc_error;
865: END IF;
866:
867: -- delete
868: IF (AMS_DEBUG_HIGH_ON) THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
892: FND_MSG_PUB.add;
893: END IF;
894: RAISE FND_API.g_exc_error;
895: END IF;
896:
897: DELETE FROM AMS_CUSTOM_SETUPS_B
898: WHERE custom_setup_id = p_cust_setup_id
902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
903: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
904: FND_MSG_PUB.add;
905: END IF;
906: RAISE FND_API.g_exc_error;
907: END IF;
908: ELSE
909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
910: FND_MESSAGE.set_name('AMS', 'AMS_API_VERS_DONT_MATCH');
909: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
910: FND_MESSAGE.set_name('AMS', 'AMS_API_VERS_DONT_MATCH');
911: FND_MSG_PUB.add;
912: END IF;
913: RAISE FND_API.g_exc_error;
914: END IF;
915: ELSE
916: UPDATE AMS_CUSTOM_SETUPS_B SET -- IS USED
917: object_version_number = l_object_version +1,
922: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
923: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_IN_USE');
924: FND_MSG_PUB.add;
925: END IF;
926: RAISE FND_API.g_exc_error;
927: */
928: END IF;
929:
930: -- finish
927: */
928: END IF;
929:
930: -- finish
931: IF FND_API.to_boolean(p_commit) THEN
932: COMMIT;
933: END IF;
934:
935: FND_MSG_PUB.count_and_get
933: END IF;
934:
935: FND_MSG_PUB.count_and_get
936: (
937: P_ENCODED => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:
948: END IF;
949:
950: EXCEPTION
951:
952: WHEN FND_API.g_exc_error THEN
953: ROLLBACK TO delete_cust_setup;
954: x_return_status := FND_API.g_ret_sts_error;
955: FND_MSG_PUB.count_and_get
956: (
950: EXCEPTION
951:
952: WHEN FND_API.g_exc_error THEN
953: ROLLBACK TO delete_cust_setup;
954: x_return_status := FND_API.g_ret_sts_error;
955: FND_MSG_PUB.count_and_get
956: (
957: p_encoded => FND_API.g_false,
958: p_count => x_msg_count,
953: ROLLBACK TO delete_cust_setup;
954: x_return_status := FND_API.g_ret_sts_error;
955: FND_MSG_PUB.count_and_get
956: (
957: p_encoded => FND_API.g_false,
958: p_count => x_msg_count,
959: p_data => x_msg_data
960: );
961:
958: p_count => x_msg_count,
959: p_data => x_msg_data
960: );
961:
962: WHEN FND_API.g_exc_unexpected_error THEN
963: ROLLBACK TO delete_cust_setup;
964: x_return_status := FND_API.g_ret_sts_unexp_error;
965: FND_MSG_PUB.count_and_get
966: (
960: );
961:
962: WHEN FND_API.g_exc_unexpected_error THEN
963: ROLLBACK TO delete_cust_setup;
964: x_return_status := FND_API.g_ret_sts_unexp_error;
965: FND_MSG_PUB.count_and_get
966: (
967: p_encoded => FND_API.g_false,
968: p_count => x_msg_count,
963: ROLLBACK TO delete_cust_setup;
964: x_return_status := FND_API.g_ret_sts_unexp_error;
965: FND_MSG_PUB.count_and_get
966: (
967: p_encoded => FND_API.g_false,
968: p_count => x_msg_count,
969: p_data => x_msg_data
970: );
971:
970: );
971:
972: WHEN OTHERS THEN
973: ROLLBACK TO delete_cust_setup;
974: x_return_status :=FND_API.g_ret_sts_unexp_error;
975: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
976: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
977: END IF;
978: FND_MSG_PUB.count_and_get
976: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
977: END IF;
978: FND_MSG_PUB.count_and_get
979: (
980: p_encoded => FND_API.g_false,
981: p_count => x_msg_count,
982: p_data => x_msg_data
983: );
984:
993: -------------------------------------------------------------------------------
994: PROCEDURE lock_cust_setup
995: (
996: p_api_version IN NUMBER,
997: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
998:
999: x_return_status OUT NOCOPY VARCHAR2,
1000: x_msg_count OUT NOCOPY NUMBER,
1001: x_msg_data OUT NOCOPY VARCHAR2,
1030:
1031: AMS_Utility_PVT.debug_message(l_full_name || ': start');
1032: END IF;
1033:
1034: IF FND_API.to_boolean(p_init_msg_list) THEN
1035: FND_MSG_PUB.initialize;
1036: END IF;
1037:
1038: IF NOT FND_API.compatible_api_call
1034: IF FND_API.to_boolean(p_init_msg_list) THEN
1035: FND_MSG_PUB.initialize;
1036: END IF;
1037:
1038: IF NOT FND_API.compatible_api_call
1039: (
1040: l_api_version,
1041: p_api_version,
1042: l_api_name,
1042: l_api_name,
1043: g_pkg_name
1044: )
1045: THEN
1046: RAISE FND_API.g_exc_unexpected_error;
1047: END IF;
1048:
1049: x_return_status := FND_API.g_ret_sts_success;
1050:
1045: THEN
1046: RAISE FND_API.g_exc_unexpected_error;
1047: END IF;
1048:
1049: x_return_status := FND_API.g_ret_sts_success;
1050:
1051: -- lock
1052: IF (AMS_DEBUG_HIGH_ON) THEN
1053:
1061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1062: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1063: FND_MSG_PUB.add;
1064: END IF;
1065: RAISE FND_API.g_exc_error;
1066: END IF;
1067: CLOSE c_cust_setup_b;
1068:
1069: OPEN c_cust_setup_tl;
1073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1074: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1075: FND_MSG_PUB.add;
1076: END IF;
1077: RAISE FND_API.g_exc_error;
1078: END IF;
1079: CLOSE c_cust_setup_tl;
1080:
1081: -- finish
1080:
1081: -- finish
1082: FND_MSG_PUB.count_and_get
1083: (
1084: p_encoded => FND_API.g_false,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data
1087: );
1088:
1096:
1097: EXCEPTION
1098:
1099: WHEN AMS_Utility_PVT.resource_locked THEN
1100: x_return_status := FND_API.g_ret_sts_error;
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1103: FND_MSG_PUB.add;
1104: END IF;
1103: FND_MSG_PUB.add;
1104: END IF;
1105: FND_MSG_PUB.count_and_get
1106: (
1107: p_encoded => FND_API.g_false,
1108: p_count => x_msg_count,
1109: p_data => x_msg_data
1110: );
1111:
1108: p_count => x_msg_count,
1109: p_data => x_msg_data
1110: );
1111:
1112: WHEN FND_API.g_exc_error THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: FND_MSG_PUB.count_and_get
1115: (
1116: p_encoded => FND_API.g_false,
1109: p_data => x_msg_data
1110: );
1111:
1112: WHEN FND_API.g_exc_error THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: FND_MSG_PUB.count_and_get
1115: (
1116: p_encoded => FND_API.g_false,
1117: p_count => x_msg_count,
1112: WHEN FND_API.g_exc_error THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: FND_MSG_PUB.count_and_get
1115: (
1116: p_encoded => FND_API.g_false,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );
1120:
1117: p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );
1120:
1121: WHEN FND_API.g_exc_unexpected_error THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: FND_MSG_PUB.count_and_get
1124: (
1125: p_encoded => FND_API.g_false,
1118: p_data => x_msg_data
1119: );
1120:
1121: WHEN FND_API.g_exc_unexpected_error THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: FND_MSG_PUB.count_and_get
1124: (
1125: p_encoded => FND_API.g_false,
1126: p_count => x_msg_count,
1121: WHEN FND_API.g_exc_unexpected_error THEN
1122: x_return_status := FND_API.g_ret_sts_unexp_error;
1123: FND_MSG_PUB.count_and_get
1124: (
1125: p_encoded => FND_API.g_false,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );
1129:
1127: p_data => x_msg_data
1128: );
1129:
1130: WHEN OTHERS THEN
1131: x_return_status :=FND_API.g_ret_sts_unexp_error;
1132: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135: FND_MSG_PUB.count_and_get
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135: FND_MSG_PUB.count_and_get
1136: (
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141:
1151: --------------------------------------------------------------------
1152: PROCEDURE validate_cust_setup
1153: (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1156: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1157:
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_msg_count OUT NOCOPY NUMBER,
1152: PROCEDURE validate_cust_setup
1153: (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1156: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1157:
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_msg_count OUT NOCOPY NUMBER,
1160: x_msg_data OUT NOCOPY VARCHAR2,
1176:
1177: AMS_Utility_PVT.debug_message(l_full_name||': start');
1178: END IF;
1179:
1180: -- IF FND_API.to_boolean(p_init_msg_list) THEN
1181: -- FND_MSG_PUB.initialize;
1182: -- END IF;
1183:
1184: IF NOT FND_API.compatible_api_call
1180: -- IF FND_API.to_boolean(p_init_msg_list) THEN
1181: -- FND_MSG_PUB.initialize;
1182: -- END IF;
1183:
1184: IF NOT FND_API.compatible_api_call
1185: (
1186: l_api_version,
1187: p_api_version,
1188: l_api_name,
1188: l_api_name,
1189: g_pkg_name
1190: )
1191: THEN
1192: RAISE FND_API.g_exc_unexpected_error;
1193: END IF;
1194:
1195: x_return_status := FND_API.g_ret_sts_success;
1196:
1191: THEN
1192: RAISE FND_API.g_exc_unexpected_error;
1193: END IF;
1194:
1195: x_return_status := FND_API.g_ret_sts_success;
1196:
1197: ---------------------- validate ------------------------
1198: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1199: IF (AMS_DEBUG_HIGH_ON) THEN
1206: x_return_status => l_return_status,
1207: p_cust_setup_rec => p_cust_setup_rec
1208: );
1209:
1210: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1211: RAISE FND_API.g_exc_unexpected_error;
1212: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1213: RAISE FND_API.g_exc_error;
1214: END IF;
1207: p_cust_setup_rec => p_cust_setup_rec
1208: );
1209:
1210: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1211: RAISE FND_API.g_exc_unexpected_error;
1212: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1213: RAISE FND_API.g_exc_error;
1214: END IF;
1215: END IF;
1208: );
1209:
1210: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1211: RAISE FND_API.g_exc_unexpected_error;
1212: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1213: RAISE FND_API.g_exc_error;
1214: END IF;
1215: END IF;
1216:
1209:
1210: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1211: RAISE FND_API.g_exc_unexpected_error;
1212: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1213: RAISE FND_API.g_exc_error;
1214: END IF;
1215: END IF;
1216:
1217: -------------------- finish --------------------------
1216:
1217: -------------------- finish --------------------------
1218: FND_MSG_PUB.count_and_get
1219: (
1220: p_encoded => FND_API.g_false,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data
1223: );
1224:
1230:
1231: END IF;
1232:
1233: EXCEPTION
1234: WHEN FND_API.g_exc_error THEN
1235: x_return_status := FND_API.g_ret_sts_error;
1236: FND_MSG_PUB.count_and_get
1237: (
1238: p_encoded => FND_API.g_false,
1231: END IF;
1232:
1233: EXCEPTION
1234: WHEN FND_API.g_exc_error THEN
1235: x_return_status := FND_API.g_ret_sts_error;
1236: FND_MSG_PUB.count_and_get
1237: (
1238: p_encoded => FND_API.g_false,
1239: p_count => x_msg_count,
1234: WHEN FND_API.g_exc_error THEN
1235: x_return_status := FND_API.g_ret_sts_error;
1236: FND_MSG_PUB.count_and_get
1237: (
1238: p_encoded => FND_API.g_false,
1239: p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );
1242:
1239: p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );
1242:
1243: WHEN FND_API.g_exc_unexpected_error THEN
1244: x_return_status := FND_API.g_ret_sts_unexp_error ;
1245: FND_MSG_PUB.count_and_get
1246: (
1247: p_encoded => FND_API.g_false,
1240: p_data => x_msg_data
1241: );
1242:
1243: WHEN FND_API.g_exc_unexpected_error THEN
1244: x_return_status := FND_API.g_ret_sts_unexp_error ;
1245: FND_MSG_PUB.count_and_get
1246: (
1247: p_encoded => FND_API.g_false,
1248: p_count => x_msg_count,
1243: WHEN FND_API.g_exc_unexpected_error THEN
1244: x_return_status := FND_API.g_ret_sts_unexp_error ;
1245: FND_MSG_PUB.count_and_get
1246: (
1247: p_encoded => FND_API.g_false,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data
1250: );
1251:
1249: p_data => x_msg_data
1250: );
1251:
1252: WHEN OTHERS THEN
1253: x_return_status := FND_API.g_ret_sts_unexp_error;
1254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1255: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1256: END IF;
1257:
1256: END IF;
1257:
1258: FND_MSG_PUB.count_and_get
1259: (
1260: p_encoded => FND_API.g_false,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );
1264:
1289:
1290: AMS_Utility_PVT.debug_message(l_full_name || ': start');
1291: END IF;
1292:
1293: x_return_status := FND_API.g_ret_sts_success;
1294:
1295: -- check required items
1296: IF (AMS_DEBUG_HIGH_ON) THEN
1297:
1303: p_cust_setup_rec => p_cust_setup_rec,
1304: x_return_status => x_return_status
1305: );
1306:
1307: IF x_return_status <> FND_API.g_ret_sts_success THEN
1308: RETURN;
1309: END IF;
1310:
1311: -- check unique key items
1319: p_cust_setup_rec => p_cust_setup_rec,
1320: x_return_status => x_return_status
1321: );
1322:
1323: IF x_return_status <> FND_API.g_ret_sts_success THEN
1324: RETURN;
1325: END IF;
1326:
1327: -- check foreign key items
1334: p_cust_setup_rec => p_cust_setup_rec,
1335: x_return_status => x_return_status
1336: );
1337:
1338: IF x_return_status <> FND_API.g_ret_sts_success THEN
1339: RETURN;
1340: END IF;
1341:
1342: -- check flags
1349: p_cust_setup_rec => p_cust_setup_rec,
1350: x_return_status => x_return_status
1351: );
1352:
1353: IF x_return_status <> FND_API.g_ret_sts_success THEN
1354: RETURN;
1355: END IF;
1356:
1357: END check_items;
1374: IS
1375:
1376: BEGIN
1377:
1378: x_return_status := FND_API.g_ret_sts_success;
1379:
1380: -- check custom_setup_id
1381: IF p_cust_setup_rec.custom_setup_id IS NULL
1382: AND p_validation_mode = JTF_PLSQL_API.g_update
1385: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_CUS_SETUP_ID');
1386: FND_MSG_PUB.add;
1387: END IF;
1388:
1389: x_return_status := FND_API.g_ret_sts_error;
1390: RETURN;
1391: END IF;
1392:
1393: -- check object_version_number
1398: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1399: FND_MSG_PUB.add;
1400: END IF;
1401:
1402: x_return_status := FND_API.g_ret_sts_error;
1403: RETURN;
1404: END IF;
1405:
1406: -- check object_type
1409: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_OBJ_TYPE');
1410: FND_MSG_PUB.add;
1411: END IF;
1412:
1413: x_return_status := FND_API.g_ret_sts_error;
1414: RETURN;
1415: END IF;
1416:
1417: -- check activity_type_code
1425: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_ACT_TP_CODE');
1426: FND_MSG_PUB.add;
1427: END IF;
1428:
1429: x_return_status := FND_API.g_ret_sts_error;
1430: RETURN;
1431: END IF;
1432:
1433: IF p_cust_setup_rec.object_type = 'EVEH'
1440: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ACT_TP_CODE');
1441: FND_MSG_PUB.add;
1442: END IF;
1443:
1444: x_return_status := FND_API.g_ret_sts_error;
1445: RETURN;
1446: END IF;
1447: END IF; */
1448:
1452: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_SETUP_NAME');
1453: FND_MSG_PUB.add;
1454: END IF;
1455:
1456: x_return_status := FND_API.g_ret_sts_error;
1457: RETURN;
1458: END IF;
1459:
1460:
1494: l_dummy VARCHAR2(1);
1495:
1496: BEGIN
1497:
1498: x_return_status := FND_API.g_ret_sts_success;
1499:
1500: -- check PK, if custom_setup_id is passed in, must check if it is duplicATE
1501: IF p_validation_mode = JTF_PLSQL_API.g_create
1502: AND p_cust_setup_rec.custom_setup_id IS NOT NULL
1507: 'custom_setup_id = ' || p_cust_setup_rec.custom_setup_id
1508: );
1509: END IF;
1510:
1511: IF l_uk_flag = FND_API.g_false THEN
1512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_CUSTOM_SETUP_DUPLICATE_ID');
1514: FND_MSG_PUB.add;
1515: END IF;
1513: FND_MESSAGE.set_name('AMS', 'AMS_CUSTOM_SETUP_DUPLICATE_ID');
1514: FND_MSG_PUB.add;
1515: END IF;
1516:
1517: x_return_status := FND_API.g_ret_sts_error;
1518: RETURN;
1519: END IF;
1520:
1521: -- check custom_setup_id
1536: || ''' AND language = ''' || USERENV('LANG') ||''''
1537: );
1538: END IF;
1539:
1540: IF l_uk_flag = FND_API.g_false THEN
1541: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1542: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');
1543: FND_MSG_PUB.add;
1544: END IF;
1542: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');
1543: FND_MSG_PUB.add;
1544: END IF;
1545:
1546: x_return_status := FND_API.g_ret_sts_error;
1547: RETURN;
1548: END IF;
1549: ************* end abhola **************/
1550: --
1576: FND_MESSAGE.set_name('AMS', 'AMS_CUST_SETUP_DUP_NAME_LANG');
1577: FND_MSG_PUB.add;
1578: END IF;
1579:
1580: x_return_status := FND_API.g_ret_sts_error;
1581: RETURN;
1582: END IF;
1583: -- end abhola
1584:
1601: l_fk_flag VARCHAR2(1);
1602:
1603: BEGIN
1604:
1605: x_return_status := FND_API.g_ret_sts_success;
1606: IF p_cust_setup_rec.media_id IS NOT NULL THEN
1607: -- DELV condition added by rrajesh on 07/21/01
1608: -- And moved ams_media_b check in else condition
1609: IF p_cust_setup_rec.object_type = 'DELV' THEN
1621: p_cust_setup_rec.media_id
1622: );
1623: END IF;
1624: -- end change. 07/21/01
1625: IF l_fk_flag = FND_API.g_false THEN
1626: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1627: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_MEDIA_ID');
1628: FND_MSG_PUB.add;
1629: END IF;
1627: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_MEDIA_ID');
1628: FND_MSG_PUB.add;
1629: END IF;
1630:
1631: x_return_status := FND_API.g_ret_sts_error;
1632: RETURN;
1633: END IF;
1634: END IF;
1635:
1651: l_mand_flag VARCHAR2(1);
1652:
1653: BEGIN
1654:
1655: x_return_status := FND_API.g_ret_sts_success;
1656:
1657: -- enabled_flag
1658: IF p_cust_setup_rec.enabled_flag NOT IN ('Y','N',FND_API.g_miss_char)
1659: AND p_cust_setup_rec.enabled_flag IS NOT NULL
1654:
1655: x_return_status := FND_API.g_ret_sts_success;
1656:
1657: -- enabled_flag
1658: IF p_cust_setup_rec.enabled_flag NOT IN ('Y','N',FND_API.g_miss_char)
1659: AND p_cust_setup_rec.enabled_flag IS NOT NULL
1660: THEN
1661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1662: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ENBL_FLAG');
1662: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_BAD_ENBL_FLAG');
1663: FND_MSG_PUB.add;
1664: END IF;
1665:
1666: x_return_status := FND_API.g_ret_sts_error;
1667: RETURN;
1668: END IF;
1669:
1670: END check_cust_setup_flag_items;
1700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1701: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1702: FND_MSG_PUB.add;
1703: END IF;
1704: RAISE FND_API.g_exc_error;
1705: END IF;
1706: CLOSE c_cust_setup;
1707:
1708: IF p_cust_setup_rec.object_type = FND_API.g_miss_char THEN
1704: RAISE FND_API.g_exc_error;
1705: END IF;
1706: CLOSE c_cust_setup;
1707:
1708: IF p_cust_setup_rec.object_type = FND_API.g_miss_char THEN
1709: x_complete_rec.object_type := l_cust_setup_rec.object_type;
1710: END IF;
1711:
1712: IF p_cust_setup_rec.enabled_flag = FND_API.g_miss_char THEN
1708: IF p_cust_setup_rec.object_type = FND_API.g_miss_char THEN
1709: x_complete_rec.object_type := l_cust_setup_rec.object_type;
1710: END IF;
1711:
1712: IF p_cust_setup_rec.enabled_flag = FND_API.g_miss_char THEN
1713: x_complete_rec.enabled_flag := l_cust_setup_rec.enabled_flag;
1714: END IF;
1715:
1716: IF p_cust_setup_rec.allow_essential_grouping = FND_API.g_miss_char THEN
1712: IF p_cust_setup_rec.enabled_flag = FND_API.g_miss_char THEN
1713: x_complete_rec.enabled_flag := l_cust_setup_rec.enabled_flag;
1714: END IF;
1715:
1716: IF p_cust_setup_rec.allow_essential_grouping = FND_API.g_miss_char THEN
1717: x_complete_rec.allow_essential_grouping := l_cust_setup_rec.allow_essential_grouping;
1718: END IF;
1719:
1720: IF p_cust_setup_rec.usage = FND_API.g_miss_char THEN
1716: IF p_cust_setup_rec.allow_essential_grouping = FND_API.g_miss_char THEN
1717: x_complete_rec.allow_essential_grouping := l_cust_setup_rec.allow_essential_grouping;
1718: END IF;
1719:
1720: IF p_cust_setup_rec.usage = FND_API.g_miss_char THEN
1721: x_complete_rec.usage := l_cust_setup_rec.usage;
1722: END IF;
1723:
1724: -- IF p_cust_setup_rec.object_type NOT IN ('CAMP','ECAM','RCAM') THEN
1724: -- IF p_cust_setup_rec.object_type NOT IN ('CAMP','ECAM','RCAM') THEN
1725: -- x_complete_rec.activity_type_code := NULL;
1726: -- x_complete_rec.media_id := NULL;
1727: -- ELSE
1728: IF p_cust_setup_rec.activity_type_code = FND_API.g_miss_char THEN
1729: x_complete_rec.activity_type_code := l_cust_setup_rec.activity_type_code;
1730: END IF;
1731:
1732: IF p_cust_setup_rec.source_code_suffix = FND_API.g_miss_char THEN
1728: IF p_cust_setup_rec.activity_type_code = FND_API.g_miss_char THEN
1729: x_complete_rec.activity_type_code := l_cust_setup_rec.activity_type_code;
1730: END IF;
1731:
1732: IF p_cust_setup_rec.source_code_suffix = FND_API.g_miss_char THEN
1733: x_complete_rec.source_code_suffix := l_cust_setup_rec.source_code_suffix;
1734: END IF;
1735:
1736: IF p_cust_setup_rec.media_id = FND_API.g_miss_num THEN
1732: IF p_cust_setup_rec.source_code_suffix = FND_API.g_miss_char THEN
1733: x_complete_rec.source_code_suffix := l_cust_setup_rec.source_code_suffix;
1734: END IF;
1735:
1736: IF p_cust_setup_rec.media_id = FND_API.g_miss_num THEN
1737: x_complete_rec.media_id := l_cust_setup_rec.media_id;
1738: END IF;
1739: -- END IF;
1740:
1737: x_complete_rec.media_id := l_cust_setup_rec.media_id;
1738: END IF;
1739: -- END IF;
1740:
1741: IF p_cust_setup_rec.setup_name = FND_API.g_miss_char THEN
1742: x_complete_rec.setup_name := l_cust_setup_rec.setup_name;
1743: END IF;
1744:
1745: IF p_cust_setup_rec.description = FND_API.g_miss_char THEN
1741: IF p_cust_setup_rec.setup_name = FND_API.g_miss_char THEN
1742: x_complete_rec.setup_name := l_cust_setup_rec.setup_name;
1743: END IF;
1744:
1745: IF p_cust_setup_rec.description = FND_API.g_miss_char THEN
1746: x_complete_rec.description := l_cust_setup_rec.description;
1747: END IF;
1748:
1749: END complete_cust_setup_rec;
1763: IS
1764:
1765: BEGIN
1766:
1767: x_cust_setup_rec.custom_setup_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1764:
1765: BEGIN
1766:
1767: x_cust_setup_rec.custom_setup_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1765: BEGIN
1766:
1767: x_cust_setup_rec.custom_setup_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1766:
1767: x_cust_setup_rec.custom_setup_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1767: x_cust_setup_rec.custom_setup_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1768: x_cust_setup_rec.last_update_date := FND_API.g_miss_date;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1769: x_cust_setup_rec.last_updated_by := FND_API.g_miss_num;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1770: x_cust_setup_rec.creation_date := FND_API.g_miss_date;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1771: x_cust_setup_rec.created_by := FND_API.g_miss_num;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1772: x_cust_setup_rec.last_update_login := FND_API.g_miss_num;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1773: x_cust_setup_rec.object_version_number := FND_API.g_miss_num;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1774: x_cust_setup_rec.activity_type_code := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1782: x_cust_setup_rec.usage := FND_API.g_miss_char;
1775: x_cust_setup_rec.media_id := FND_API.g_miss_num;
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1782: x_cust_setup_rec.usage := FND_API.g_miss_char;
1783:
1776: x_cust_setup_rec.enabled_flag := FND_API.g_miss_char;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1782: x_cust_setup_rec.usage := FND_API.g_miss_char;
1783:
1784: END init_rec;
1777: x_cust_setup_rec.object_type := FND_API.g_miss_char;
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1782: x_cust_setup_rec.usage := FND_API.g_miss_char;
1783:
1784: END init_rec;
1785:
1778: x_cust_setup_rec.source_code_suffix := FND_API.g_miss_char;
1779: x_cust_setup_rec.setup_name := FND_API.g_miss_char;
1780: x_cust_setup_rec.description := FND_API.g_miss_char;
1781: x_cust_setup_rec.allow_essential_grouping := FND_API.g_miss_char;
1782: x_cust_setup_rec.usage := FND_API.g_miss_char;
1783:
1784: END init_rec;
1785:
1786: END AMS_Cust_Setup_PVT;