664: -- API body
665:
666:
667: --Check for missing parameters
668: IF (cn_api.chk_miss_null_num_para
669: ( p_RuleAttribute_rec.ruleset_id,
670: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
671: x_loading_status,
672: x_loading_status) = FND_API.G_TRUE )
666:
667: --Check for missing parameters
668: IF (cn_api.chk_miss_null_num_para
669: ( p_RuleAttribute_rec.ruleset_id,
670: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
671: x_loading_status,
672: x_loading_status) = FND_API.G_TRUE )
673: THEN
674: RAISE fnd_api.g_exc_error;
673: THEN
674: RAISE fnd_api.g_exc_error;
675: END IF;
676:
677: IF (cn_api.chk_miss_null_num_para
678: ( p_RuleAttribute_rec.rule_id,
679: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
680: x_loading_status,
681: x_loading_status) = FND_API.G_TRUE )
675: END IF;
676:
677: IF (cn_api.chk_miss_null_num_para
678: ( p_RuleAttribute_rec.rule_id,
679: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
680: x_loading_status,
681: x_loading_status) = FND_API.G_TRUE )
682: THEN
683: RAISE fnd_api.g_exc_error;
683: RAISE fnd_api.g_exc_error;
684: END IF;
685:
686: /* This shouldn't be here. select from sequence
687: IF (cn_api.chk_miss_null_num_para
688: ( p_RuleAttribute_rec.attribute_rule_id,
689: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
690: x_loading_status,
691: x_loading_status) = FND_API.G_TRUE )
685:
686: /* This shouldn't be here. select from sequence
687: IF (cn_api.chk_miss_null_num_para
688: ( p_RuleAttribute_rec.attribute_rule_id,
689: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
690: x_loading_status,
691: x_loading_status) = FND_API.G_TRUE )
692: THEN
693: RAISE fnd_api.g_exc_error;
693: RAISE fnd_api.g_exc_error;
694: END IF;
695: */
696:
697: IF (cn_api.chk_null_char_para
698: ( p_RuleAttribute_rec.object_name,
699: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
700: x_loading_status,
701: x_loading_status) = FND_API.G_TRUE )
695: */
696:
697: IF (cn_api.chk_null_char_para
698: ( p_RuleAttribute_rec.object_name,
699: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
700: x_loading_status,
701: x_loading_status) = FND_API.G_TRUE )
702: THEN
703: RAISE fnd_api.g_exc_error;
702: THEN
703: RAISE fnd_api.g_exc_error;
704: END IF;
705:
706: IF (cn_api.chk_null_char_para
707: ( p_RuleAttribute_rec.data_flag,
708: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
709: x_loading_status,
710: x_loading_status) = FND_API.G_TRUE )
704: END IF;
705:
706: IF (cn_api.chk_null_char_para
707: ( p_RuleAttribute_rec.data_flag,
708: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
709: x_loading_status,
710: x_loading_status) = FND_API.G_TRUE )
711: THEN
712: RAISE fnd_api.g_exc_error;
991:
992: -- API body
993:
994: --Check for missing parameters in the p_rule_rec parameter
995: IF (cn_api.chk_miss_null_num_para
996: ( p_old_RuleAttribute_rec.ruleset_id,
997: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
998: x_loading_status,
999: x_loading_status) = FND_API.G_TRUE )
993:
994: --Check for missing parameters in the p_rule_rec parameter
995: IF (cn_api.chk_miss_null_num_para
996: ( p_old_RuleAttribute_rec.ruleset_id,
997: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
998: x_loading_status,
999: x_loading_status) = FND_API.G_TRUE )
1000: THEN
1001: RAISE fnd_api.g_exc_error;
1000: THEN
1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: IF (cn_api.chk_miss_null_num_para
1005: ( p_old_RuleAttribute_rec.rule_id,
1006: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
1007: x_loading_status,
1008: x_loading_status) = FND_API.G_TRUE )
1002: END IF;
1003:
1004: IF (cn_api.chk_miss_null_num_para
1005: ( p_old_RuleAttribute_rec.rule_id,
1006: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
1007: x_loading_status,
1008: x_loading_status) = FND_API.G_TRUE )
1009: THEN
1010: RAISE fnd_api.g_exc_error;
1009: THEN
1010: RAISE fnd_api.g_exc_error;
1011: END IF;
1012:
1013: IF (cn_api.chk_miss_null_num_para
1014: ( p_old_RuleAttribute_rec.attribute_rule_id,
1015: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
1016: x_loading_status,
1017: x_loading_status) = FND_API.G_TRUE )
1011: END IF;
1012:
1013: IF (cn_api.chk_miss_null_num_para
1014: ( p_old_RuleAttribute_rec.attribute_rule_id,
1015: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
1016: x_loading_status,
1017: x_loading_status) = FND_API.G_TRUE )
1018: THEN
1019: RAISE fnd_api.g_exc_error;
1018: THEN
1019: RAISE fnd_api.g_exc_error;
1020: END IF;
1021:
1022: IF (cn_api.chk_null_char_para
1023: ( p_old_RuleAttribute_rec.object_name,
1024: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1025: x_loading_status,
1026: x_loading_status) = FND_API.G_TRUE )
1020: END IF;
1021:
1022: IF (cn_api.chk_null_char_para
1023: ( p_old_RuleAttribute_rec.object_name,
1024: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1025: x_loading_status,
1026: x_loading_status) = FND_API.G_TRUE )
1027: THEN
1028: RAISE fnd_api.g_exc_error;
1027: THEN
1028: RAISE fnd_api.g_exc_error;
1029: END IF;
1030:
1031: IF (cn_api.chk_null_char_para
1032: ( p_old_RuleAttribute_rec.data_flag,
1033: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1034: x_loading_status,
1035: x_loading_status) = FND_API.G_TRUE )
1029: END IF;
1030:
1031: IF (cn_api.chk_null_char_para
1032: ( p_old_RuleAttribute_rec.data_flag,
1033: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1034: x_loading_status,
1035: x_loading_status) = FND_API.G_TRUE )
1036: THEN
1037: RAISE fnd_api.g_exc_error;
1037: RAISE fnd_api.g_exc_error;
1038: END IF;
1039:
1040: --New Parameter
1041: IF (cn_api.chk_miss_null_num_para
1042: ( p_RuleAttribute_rec.ruleset_id,
1043: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
1044: x_loading_status,
1045: x_loading_status) = FND_API.G_TRUE )
1039:
1040: --New Parameter
1041: IF (cn_api.chk_miss_null_num_para
1042: ( p_RuleAttribute_rec.ruleset_id,
1043: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
1044: x_loading_status,
1045: x_loading_status) = FND_API.G_TRUE )
1046: THEN
1047: RAISE fnd_api.g_exc_error;
1046: THEN
1047: RAISE fnd_api.g_exc_error;
1048: END IF;
1049:
1050: IF (cn_api.chk_miss_null_num_para
1051: ( p_RuleAttribute_rec.rule_id,
1052: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
1053: x_loading_status,
1054: x_loading_status) = FND_API.G_TRUE )
1048: END IF;
1049:
1050: IF (cn_api.chk_miss_null_num_para
1051: ( p_RuleAttribute_rec.rule_id,
1052: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
1053: x_loading_status,
1054: x_loading_status) = FND_API.G_TRUE )
1055: THEN
1056: RAISE fnd_api.g_exc_error;
1055: THEN
1056: RAISE fnd_api.g_exc_error;
1057: END IF;
1058:
1059: IF (cn_api.chk_miss_null_num_para
1060: ( p_RuleAttribute_rec.Attribute_rule_id,
1061: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
1062: x_loading_status,
1063: x_loading_status) = FND_API.G_TRUE )
1057: END IF;
1058:
1059: IF (cn_api.chk_miss_null_num_para
1060: ( p_RuleAttribute_rec.Attribute_rule_id,
1061: cn_api.get_lkup_meaning('RULE_ATTRIBUTE_ID', 'RULESET_TYPE'),
1062: x_loading_status,
1063: x_loading_status) = FND_API.G_TRUE )
1064: THEN
1065: RAISE fnd_api.g_exc_error;
1064: THEN
1065: RAISE fnd_api.g_exc_error;
1066: END IF;
1067:
1068: IF (cn_api.chk_null_char_para
1069: ( p_RuleAttribute_rec.object_name,
1070: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1071: x_loading_status,
1072: x_loading_status) = FND_API.G_TRUE )
1066: END IF;
1067:
1068: IF (cn_api.chk_null_char_para
1069: ( p_RuleAttribute_rec.object_name,
1070: cn_api.get_lkup_meaning('OBJECT_NAME', 'RULESET_TYPE'),
1071: x_loading_status,
1072: x_loading_status) = FND_API.G_TRUE )
1073: THEN
1074: RAISE fnd_api.g_exc_error;
1073: THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: IF (cn_api.chk_null_char_para
1078: ( p_RuleAttribute_rec.data_flag,
1079: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1080: x_loading_status,
1081: x_loading_status) = FND_API.G_TRUE )
1075: END IF;
1076:
1077: IF (cn_api.chk_null_char_para
1078: ( p_RuleAttribute_rec.data_flag,
1079: cn_api.get_lkup_meaning('DATA_FLAG', 'RULESET_TYPE'),
1080: x_loading_status,
1081: x_loading_status) = FND_API.G_TRUE )
1082: THEN
1083: RAISE fnd_api.g_exc_error;