[Home] [Help]
121: fnd_message.set_token('COLUMN_NAME', cn_obj_recs.user_name);
122: fnd_msg_pub.add;
123: END IF;
124: x_loading_status := 'CN_DATATYPE_VALUE_MISMATCH';
125: RAISE FND_API.G_EXC_ERROR;
126: end ;
127:
128: ELSIF cn_obj_recs.column_datatype = 'DATE' THEN
129:
262: -- History
263: -- 10-AUG-98 Ram Kalyanasundaram Created
264: --=============================================================================
265: FUNCTION Check_AttributeRuleParameters
266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,
267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
263: -- 10-AUG-98 Ram Kalyanasundaram Created
264: --=============================================================================
265: FUNCTION Check_AttributeRuleParameters
266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,
267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
271: p_rule_id IN cn_rules.rule_id%TYPE,
264: --=============================================================================
265: FUNCTION Check_AttributeRuleParameters
266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,
267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
271: p_rule_id IN cn_rules.rule_id%TYPE,
272: p_org_id IN cn_attribute_rules.org_id%TYPE,
265: FUNCTION Check_AttributeRuleParameters
266: (p_not_flag IN cn_attribute_rules.not_flag%TYPE := FND_API.G_MISS_CHAR,
267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
271: p_rule_id IN cn_rules.rule_id%TYPE,
272: p_org_id IN cn_attribute_rules.org_id%TYPE,
273: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE := NULL,
286:
287: x_loading_status := p_loading_status;
288: l_not_flag := p_not_flag;
289:
290: IF p_data_flag = FND_API.G_MISS_CHAR
291: OR
292: p_data_flag IS NULL
293: THEN
294: --Error condition
297: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');
298: fnd_msg_pub.add;
299: END IF;
300: x_loading_status := 'CN_INVALID_RULE_ATTR_TYPE';
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: IF p_data_flag NOT IN ('O', 'H', 'R')
305: THEN
309: fnd_message.set_name('CN', 'CN_INVALID_RULE_ATTR_TYPE');
310: fnd_msg_pub.add;
311: END IF;
312: x_loading_status := 'CN_INVALID_RULE_ATTR_TYPE';
313: RAISE FND_API.G_EXC_ERROR;
314: ELSE
315: IF p_data_flag = 'O' AND
316: ((p_value_1 = FND_API.g_miss_char) OR (p_value_1 IS NULL)) OR
317: ((p_object_name = FND_API.g_miss_char) OR (p_object_name IS NULL))
312: x_loading_status := 'CN_INVALID_RULE_ATTR_TYPE';
313: RAISE FND_API.G_EXC_ERROR;
314: ELSE
315: IF p_data_flag = 'O' AND
316: ((p_value_1 = FND_API.g_miss_char) OR (p_value_1 IS NULL)) OR
317: ((p_object_name = FND_API.g_miss_char) OR (p_object_name IS NULL))
318: THEN
319: --Error condition
320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
313: RAISE FND_API.G_EXC_ERROR;
314: ELSE
315: IF p_data_flag = 'O' AND
316: ((p_value_1 = FND_API.g_miss_char) OR (p_value_1 IS NULL)) OR
317: ((p_object_name = FND_API.g_miss_char) OR (p_object_name IS NULL))
318: THEN
319: --Error condition
320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
321: THEN
322: fnd_message.set_name('CN', 'CN_INVALID_PARAM_ONE_VAL');
323: fnd_msg_pub.add;
324: END IF;
325: x_loading_status := 'CN_INVALID_PARAM_ONE_VAL';
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (p_data_flag IN ('R', 'H') AND
328: ((p_value_1 = FND_API.G_MISS_CHAR OR p_value_2 = FND_API.G_MISS_CHAR) OR
329: (p_value_1 IS NULL OR p_value_2 IS NULL)))
330: THEN
324: END IF;
325: x_loading_status := 'CN_INVALID_PARAM_ONE_VAL';
326: RAISE FND_API.G_EXC_ERROR;
327: ELSIF (p_data_flag IN ('R', 'H') AND
328: ((p_value_1 = FND_API.G_MISS_CHAR OR p_value_2 = FND_API.G_MISS_CHAR) OR
329: (p_value_1 IS NULL OR p_value_2 IS NULL)))
330: THEN
331: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
332: THEN
333: fnd_message.set_name('CN', 'CN_INVALID_PARAM_R_H');
334: fnd_msg_pub.add;
335: END IF;
336: x_loading_status := 'CN_INVALID_PARAM_R_H';
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339: END IF;
340:
341: IF l_not_flag = FND_API.G_MISS_CHAR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339: END IF;
340:
341: IF l_not_flag = FND_API.G_MISS_CHAR THEN
342:
343: l_not_flag := NULL;
344: END IF;
345:
357: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_NAME');
358: fnd_msg_pub.add;
359: END IF;
360: x_loading_status := 'CN_INVALID_OBJECT_NAME';
361: RAISE FND_API.G_EXC_ERROR;
362: END;
363:
364: IF p_data_flag = 'O'
365: THEN
410: fnd_message.set_name('CN', 'CN_HIGH_LOW');
411: fnd_msg_pub.add;
412: END IF;
413: x_loading_status := 'CN_HIGH_LOW';
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416: EXCEPTION
417: WHEN value_error THEN
418: null;
471: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
472: fnd_msg_pub.add;
473: END IF;
474: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
475: RAISE FND_API.G_EXC_ERROR;
476: END;
477:
478: BEGIN
479:
495: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
496: fnd_msg_pub.add;
497: END IF;
498: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
499: RAISE FND_API.G_EXC_ERROR;
500: END;
501:
502:
503: SELECT COUNT(*)
539: fnd_message.set_name('CN', 'CN_MULTIPLE_ATTRIBUTES');
540: fnd_msg_pub.add;
541: END IF;
542: x_loading_status := 'CN_MULTIPLE_ATTRIBUTES';
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545:
546: -- Added on 01/03/02
547: -- Kumar Sivasankaran
552:
553: END IF;
554:
555:
556: RETURN fnd_api.g_false;
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: RETURN fnd_api.g_true;
560:
554:
555:
556: RETURN fnd_api.g_false;
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: RETURN fnd_api.g_true;
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: x_loading_status := 'UNEXPECTED_ERR';
555:
556: RETURN fnd_api.g_false;
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: RETURN fnd_api.g_true;
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: x_loading_status := 'UNEXPECTED_ERR';
563: RETURN fnd_api.g_true;
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: RETURN fnd_api.g_true;
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: x_loading_status := 'UNEXPECTED_ERR';
563: RETURN fnd_api.g_true;
564:
565: WHEN OTHERS THEN
559: RETURN fnd_api.g_true;
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: x_loading_status := 'UNEXPECTED_ERR';
563: RETURN fnd_api.g_true;
564:
565: WHEN OTHERS THEN
566: x_loading_status := 'UNEXPECTED_ERR';
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
570: END IF;
571: RETURN fnd_api.g_true;
572: END Check_AttributeRuleParameters;
573:
574: --=============================================================================
575: -- Start of comments
580: -- Pre-reqs : None.
581: -- Parameters :
582: -- IN : p_api_version IN NUMBER Required
583: -- p_init_msg_list IN VARCHAR2 Optional
584: -- Default = FND_API.G_FALSE
585: -- p_commit IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_validation_level IN NUMBER Optional
588: -- Default = FND_API.G_VALID_LEVEL_FULL
582: -- IN : p_api_version IN NUMBER Required
583: -- p_init_msg_list IN VARCHAR2 Optional
584: -- Default = FND_API.G_FALSE
585: -- p_commit IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_validation_level IN NUMBER Optional
588: -- Default = FND_API.G_VALID_LEVEL_FULL
589: -- p_rule_rec IN
590: -- CN_RuleAttribute_PVT.rule_rec_type
584: -- Default = FND_API.G_FALSE
585: -- p_commit IN VARCHAR2 Optional
586: -- Default = FND_API.G_FALSE
587: -- p_validation_level IN NUMBER Optional
588: -- Default = FND_API.G_VALID_LEVEL_FULL
589: -- p_rule_rec IN
590: -- CN_RuleAttribute_PVT.rule_rec_type
591: -- p_RuleAttribute_rec IN
592: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
607: -- End of comments
608: --=============================================================================
609: PROCEDURE Create_RuleAttribute
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
608: --=============================================================================
609: PROCEDURE Create_RuleAttribute
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
609: PROCEDURE Create_RuleAttribute
610: ( p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
612: p_commit IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: x_loading_status OUT NOCOPY VARCHAR2,
642:
643: -- Standard Start of API savepoint
644: SAVEPOINT Create_RuleAttribute;
645: -- Standard call to check for call compatibility.
646: IF NOT FND_API.Compatible_API_Call ( l_api_version,
647: p_api_version,
648: l_api_name,
649: G_PKG_NAME )
650: THEN
647: p_api_version,
648: l_api_name,
649: G_PKG_NAME )
650: THEN
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:
654: -- Initialize message list if p_init_msg_list is set to TRUE.
655: IF FND_API.to_Boolean( p_init_msg_list )
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:
654: -- Initialize message list if p_init_msg_list is set to TRUE.
655: IF FND_API.to_Boolean( p_init_msg_list )
656: THEN
657: FND_MSG_PUB.initialize;
658: END IF;
659:
657: FND_MSG_PUB.initialize;
658: END IF;
659:
660: -- Initialize API return status to success
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662: x_loading_status := 'CN_INSERTED';
663:
664: -- API body
665:
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;
675: END IF;
676:
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;
675: END IF;
676:
677: IF (cn_api.chk_miss_null_num_para
678: ( p_RuleAttribute_rec.rule_id,
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;
684: END IF;
685:
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;
684: END IF;
685:
686: /* This shouldn't be here. select from sequence
687: IF (cn_api.chk_miss_null_num_para
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;
694: END IF;
695: */
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;
694: END IF;
695: */
696:
697: IF (cn_api.chk_null_char_para
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;
704: END IF;
705:
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;
704: END IF;
705:
706: IF (cn_api.chk_null_char_para
707: ( p_RuleAttribute_rec.data_flag,
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;
713: END IF;
714:
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;
713: END IF;
714:
715: IF Check_AttributeRuleParameters
716: (p_RuleAttribute_rec.not_flag,
722: p_RuleAttribute_rec.org_id,
723: null,
724: l_attribute_rule_id,
725: x_loading_status,
726: x_loading_status) = fnd_api.g_true
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
724: l_attribute_rule_id,
725: x_loading_status,
726: x_loading_status) = fnd_api.g_true
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
731: SELECT object_id
732: INTO l_object_id
751: p_loading_status => x_loading_status,
752: x_loading_status => x_loading_status) ;
753:
754: if x_loading_status = 'CN_DATATYPE_VALUE_MISMATCH' THEN
755: RAISE fnd_api.g_exc_error;
756: END IF;
757:
758: END IF;
759:
839: x_ruleset_status_in => l_ruleset_status,
840: x_org_id =>p_RuleAttribute_rec.org_id);
841:
842: -- Standard check of p_commit.
843: IF FND_API.To_Boolean( p_commit )
844: THEN
845: COMMIT WORK;
846: END IF;
847:
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count,
851: p_data => x_msg_data,
852: p_encoded => fnd_api.g_false
853: );
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO Create_RuleAttribute;
851: p_data => x_msg_data,
852: p_encoded => fnd_api.g_false
853: );
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO Create_RuleAttribute;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get
859: (p_count => x_msg_count,
853: );
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO Create_RuleAttribute;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get
859: (p_count => x_msg_count,
860: p_data => x_msg_data,
861: p_encoded => fnd_api.g_false
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get
859: (p_count => x_msg_count,
860: p_data => x_msg_data,
861: p_encoded => fnd_api.g_false
862: );
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO Create_RuleAttribute;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: (p_count => x_msg_count,
860: p_data => x_msg_data,
861: p_encoded => fnd_api.g_false
862: );
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO Create_RuleAttribute;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866: x_loading_status := 'UNEXPECTED_ERR';
867: FND_MSG_PUB.Count_And_Get
861: p_encoded => fnd_api.g_false
862: );
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: ROLLBACK TO Create_RuleAttribute;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
866: x_loading_status := 'UNEXPECTED_ERR';
867: FND_MSG_PUB.Count_And_Get
868: (p_count => x_msg_count,
869: p_data => x_msg_data,
866: x_loading_status := 'UNEXPECTED_ERR';
867: FND_MSG_PUB.Count_And_Get
868: (p_count => x_msg_count,
869: p_data => x_msg_data,
870: p_encoded => fnd_api.g_false
871: );
872: WHEN OTHERS THEN
873: ROLLBACK TO Create_RuleAttribute;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870: p_encoded => fnd_api.g_false
871: );
872: WHEN OTHERS THEN
873: ROLLBACK TO Create_RuleAttribute;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: x_loading_status := 'UNEXPECTED_ERR';
876: IF FND_MSG_PUB.Check_Msg_Level
877: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: THEN
881: END IF;
882: FND_MSG_PUB.Count_And_Get
883: (p_count => x_msg_count,
884: p_data => x_msg_data,
885: p_encoded => fnd_api.g_false
886: );
887: END Create_RuleAttribute;
888:
889:
897: -- Pre-reqs : None.
898: -- Parameters :
899: -- IN : p_api_version IN NUMBER Required
900: -- p_init_msg_list IN VARCHAR2 Optional
901: -- Default = FND_API.G_FALSE
902: -- p_commit IN VARCHAR2 Optional
903: -- Default = FND_API.G_FALSE
904: -- p_validation_level IN NUMBER Optional
905: -- Default = FND_API.G_VALID_LEVEL_FULL
899: -- IN : p_api_version IN NUMBER Required
900: -- p_init_msg_list IN VARCHAR2 Optional
901: -- Default = FND_API.G_FALSE
902: -- p_commit IN VARCHAR2 Optional
903: -- Default = FND_API.G_FALSE
904: -- p_validation_level IN NUMBER Optional
905: -- Default = FND_API.G_VALID_LEVEL_FULL
906: -- p_rule_rec_type IN
907: -- CN_RuleAttribute_PVT.rule_rec_type
901: -- Default = FND_API.G_FALSE
902: -- p_commit IN VARCHAR2 Optional
903: -- Default = FND_API.G_FALSE
904: -- p_validation_level IN NUMBER Optional
905: -- Default = FND_API.G_VALID_LEVEL_FULL
906: -- p_rule_rec_type IN
907: -- CN_RuleAttribute_PVT.rule_rec_type
908: -- p_RuleAttribute_rec_type IN
909: -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
925: --=============================================================================
926:
927: PROCEDURE Update_RuleAttribute
928: ( p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
926:
927: PROCEDURE Update_RuleAttribute
928: ( p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
927: PROCEDURE Update_RuleAttribute
928: ( p_api_version IN NUMBER,
929: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
930: p_commit IN VARCHAR2 := FND_API.G_FALSE,
931: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: x_loading_status OUT NOCOPY VARCHAR2,
970:
971: -- Standard Start of API savepoint
972: SAVEPOINT Update_RuleAttribute;
973: -- Standard call to check for call compatibility.
974: IF NOT FND_API.Compatible_API_Call ( l_api_version,
975: p_api_version,
976: l_api_name,
977: G_PKG_NAME )
978: THEN
975: p_api_version,
976: l_api_name,
977: G_PKG_NAME )
978: THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list )
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list )
984: THEN
985: FND_MSG_PUB.initialize;
986: END IF;
987:
985: FND_MSG_PUB.initialize;
986: END IF;
987:
988: -- Initialize API return status to success
989: x_return_status := FND_API.G_RET_STS_SUCCESS;
990: x_loading_status := 'CN_UPDATED';
991:
992: -- API body
993:
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;
1002: END IF;
1003:
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;
1002: END IF;
1003:
1004: IF (cn_api.chk_miss_null_num_para
1005: ( p_old_RuleAttribute_rec.rule_id,
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;
1011: END IF;
1012:
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;
1011: END IF;
1012:
1013: IF (cn_api.chk_miss_null_num_para
1014: ( p_old_RuleAttribute_rec.attribute_rule_id,
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;
1020: END IF;
1021:
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;
1020: END IF;
1021:
1022: IF (cn_api.chk_null_char_para
1023: ( p_old_RuleAttribute_rec.object_name,
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;
1029: END IF;
1030:
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;
1029: END IF;
1030:
1031: IF (cn_api.chk_null_char_para
1032: ( p_old_RuleAttribute_rec.data_flag,
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;
1038: END IF;
1039:
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;
1038: END IF;
1039:
1040: --New Parameter
1041: IF (cn_api.chk_miss_null_num_para
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;
1048: END IF;
1049:
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;
1048: END IF;
1049:
1050: IF (cn_api.chk_miss_null_num_para
1051: ( p_RuleAttribute_rec.rule_id,
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;
1057: END IF;
1058:
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;
1057: END IF;
1058:
1059: IF (cn_api.chk_miss_null_num_para
1060: ( p_RuleAttribute_rec.Attribute_rule_id,
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;
1066: END IF;
1067:
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;
1066: END IF;
1067:
1068: IF (cn_api.chk_null_char_para
1069: ( p_RuleAttribute_rec.object_name,
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;
1075: END IF;
1076:
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;
1075: END IF;
1076:
1077: IF (cn_api.chk_null_char_para
1078: ( p_RuleAttribute_rec.data_flag,
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;
1084: END IF;
1085:
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;
1084: END IF;
1085:
1086:
1087: -- check if the object version number is the same
1098: fnd_msg_pub.add;
1099: END IF;
1100:
1101: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
1102: RAISE FND_API.G_EXC_ERROR;
1103:
1104: end if;
1105:
1106:
1114: p_RuleAttribute_rec.org_id,
1115: p_RuleAttribute_rec.attribute_rule_id,
1116: l_attribute_rule_id,
1117: x_loading_status,
1118: x_loading_status) = fnd_api.g_true
1119: THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1116: l_attribute_rule_id,
1117: x_loading_status,
1118: x_loading_status) = fnd_api.g_true
1119: THEN
1120: RAISE fnd_api.g_exc_error;
1121: END IF;
1122:
1123: SELECT object_id
1124: INTO l_object_id
1138: p_loading_status => x_loading_status,
1139: x_loading_status => x_loading_status) ;
1140:
1141: if x_loading_status = 'CN_DATATYPE_VALUE_MISMATCH' THEN
1142: RAISE fnd_api.g_exc_error;
1143: END IF;
1144: END IF;
1145:
1146: IF p_RuleAttribute_rec.data_flag = 'O'
1194: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
1195: fnd_msg_pub.add;
1196: END IF;
1197: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
1198: RAISE FND_API.G_EXC_ERROR;
1199:
1200: END ;
1201:
1202: BEGIN
1219: fnd_message.set_name('CN', 'CN_HIERARCHY_NOT_FOUND');
1220: fnd_msg_pub.add;
1221: END IF;
1222: x_loading_status := 'CN_HIERARCHY_NOT_FOUND';
1223: RAISE FND_API.G_EXC_ERROR;
1224:
1225: END ;
1226:
1227: cn_syin_attr_rules_pkg.update_row
1241:
1242: -- End of API body.
1243:
1244: -- Standard check of p_commit.
1245: IF FND_API.To_Boolean( p_commit )
1246: THEN
1247: COMMIT WORK;
1248: END IF;
1249:
1260: -- Standard call to get message count and if count is 1, get message info.
1261: FND_MSG_PUB.Count_And_Get
1262: (p_count => x_msg_count,
1263: p_data => x_msg_data,
1264: p_encoded => fnd_api.g_false
1265: );
1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: ROLLBACK TO Update_RuleAttribute;
1263: p_data => x_msg_data,
1264: p_encoded => fnd_api.g_false
1265: );
1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: ROLLBACK TO Update_RuleAttribute;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,
1265: );
1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: ROLLBACK TO Update_RuleAttribute;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,
1272: p_data => x_msg_data,
1273: p_encoded => fnd_api.g_false
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,
1272: p_data => x_msg_data,
1273: p_encoded => fnd_api.g_false
1274: );
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: ROLLBACK TO Update_RuleAttribute;
1277: x_loading_status := 'UNEXPECTED_ERR';
1271: (p_count => x_msg_count,
1272: p_data => x_msg_data,
1273: p_encoded => fnd_api.g_false
1274: );
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: ROLLBACK TO Update_RuleAttribute;
1277: x_loading_status := 'UNEXPECTED_ERR';
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1274: );
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: ROLLBACK TO Update_RuleAttribute;
1277: x_loading_status := 'UNEXPECTED_ERR';
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1280: (p_count => x_msg_count,
1281: p_data => x_msg_data,
1282: p_encoded => fnd_api.g_false
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1280: (p_count => x_msg_count,
1281: p_data => x_msg_data,
1282: p_encoded => fnd_api.g_false
1283: );
1284: WHEN OTHERS THEN
1285: ROLLBACK TO Update_RuleAttribute;
1286: x_loading_status := 'UNEXPECTED_ERR';
1283: );
1284: WHEN OTHERS THEN
1285: ROLLBACK TO Update_RuleAttribute;
1286: x_loading_status := 'UNEXPECTED_ERR';
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: IF FND_MSG_PUB.Check_Msg_Level
1289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1290: THEN
1291: FND_MSG_PUB.Add_Exc_Msg
1295: END IF;
1296: FND_MSG_PUB.Count_And_Get
1297: (p_count => x_msg_count,
1298: p_data => x_msg_data,
1299: p_encoded => fnd_api.g_false
1300: );
1301:
1302: END;
1303: --=============================================================================
1309: -- Pre-reqs : None.
1310: -- Parameters :
1311: -- IN : p_api_version IN NUMBER Required
1312: -- p_init_msg_list IN VARCHAR2 Optional
1313: -- Default = FND_API.G_FALSE
1314: -- p_commit IN VARCHAR2 Optional
1315: -- Default = FND_API.G_FALSE
1316: -- p_validation_level IN NUMBER Optional
1317: -- Default = FND_API.G_VALID_LEVEL_FULL
1311: -- IN : p_api_version IN NUMBER Required
1312: -- p_init_msg_list IN VARCHAR2 Optional
1313: -- Default = FND_API.G_FALSE
1314: -- p_commit IN VARCHAR2 Optional
1315: -- Default = FND_API.G_FALSE
1316: -- p_validation_level IN NUMBER Optional
1317: -- Default = FND_API.G_VALID_LEVEL_FULL
1318: -- p_rule_rec_type IN
1319: -- CN_RuleAttribute_PVT.rule_rec_type
1313: -- Default = FND_API.G_FALSE
1314: -- p_commit IN VARCHAR2 Optional
1315: -- Default = FND_API.G_FALSE
1316: -- p_validation_level IN NUMBER Optional
1317: -- Default = FND_API.G_VALID_LEVEL_FULL
1318: -- p_rule_rec_type IN
1319: -- CN_RuleAttribute_PVT.rule_rec_type
1320: -- p_rule_attr_rec_type IN
1321: -- CN_RuleAttribute_PVT.rule_attr_rec_type
1340: --=============================================================================
1341:
1342: PROCEDURE Delete_RuleAttribute
1343: ( p_api_version IN NUMBER,
1344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1347: x_return_status OUT NOCOPY VARCHAR2,
1348: x_msg_count OUT NOCOPY NUMBER,
1341:
1342: PROCEDURE Delete_RuleAttribute
1343: ( p_api_version IN NUMBER,
1344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1347: x_return_status OUT NOCOPY VARCHAR2,
1348: x_msg_count OUT NOCOPY NUMBER,
1349: x_msg_data OUT NOCOPY VARCHAR2,
1342: PROCEDURE Delete_RuleAttribute
1343: ( p_api_version IN NUMBER,
1344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1347: x_return_status OUT NOCOPY VARCHAR2,
1348: x_msg_count OUT NOCOPY NUMBER,
1349: x_msg_data OUT NOCOPY VARCHAR2,
1350: x_loading_status OUT NOCOPY VARCHAR2,
1382:
1383: -- Standard Start of API savepoint
1384: SAVEPOINT Delete_RuleAttribute;
1385: -- Standard call to check for call compatibility.
1386: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1387: p_api_version,
1388: l_api_name,
1389: G_PKG_NAME )
1390: THEN
1387: p_api_version,
1388: l_api_name,
1389: G_PKG_NAME )
1390: THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400: -- Initialize API return status to success
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;
1402:
1403: -- API body
1404:
1405: --Validate that a rule attribute exists for the specified ruleset_id, rule_id
1424: fnd_msg_pub.add;
1425: END IF;
1426:
1427: x_loading_status := 'CN_EXPRESSION_EXISTS';
1428: RAISE FND_API.G_EXC_ERROR;
1429:
1430: END IF;
1431:
1432: SELECT COUNT(1)
1451: fnd_msg_pub.add;
1452: END IF;
1453:
1454: x_loading_status := 'CN_INVALID_ATTRIBUTE_RULE';
1455: RAISE FND_API.G_EXC_ERROR;
1456:
1457: END IF;
1458:
1459: -- check if the object version number is the same
1469: fnd_msg_pub.add;
1470: END IF;
1471:
1472: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
1473: RAISE FND_API.G_EXC_ERROR;
1474: end if;
1475:
1476: cn_syin_attr_rules_pkg.delete_row(p_attribute_rule_id);
1477:
1485:
1486: -- End of API body.
1487:
1488: -- Standard check of p_commit.
1489: IF FND_API.To_Boolean( p_commit )
1490: THEN
1491: COMMIT WORK;
1492: END IF;
1493:
1494: -- Standard call to get message count and if count is 1, get message info.
1495: FND_MSG_PUB.Count_And_Get
1496: (p_count => x_msg_count,
1497: p_data => x_msg_data,
1498: p_encoded => fnd_api.g_false
1499: );
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR THEN
1502: ROLLBACK TO Delete_RuleAttribute;
1497: p_data => x_msg_data,
1498: p_encoded => fnd_api.g_false
1499: );
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR THEN
1502: ROLLBACK TO Delete_RuleAttribute;
1503: x_return_status := FND_API.G_RET_STS_ERROR ;
1504: FND_MSG_PUB.Count_And_Get
1505: (p_count => x_msg_count,
1499: );
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR THEN
1502: ROLLBACK TO Delete_RuleAttribute;
1503: x_return_status := FND_API.G_RET_STS_ERROR ;
1504: FND_MSG_PUB.Count_And_Get
1505: (p_count => x_msg_count,
1506: p_data => x_msg_data,
1507: p_encoded => fnd_api.g_false
1503: x_return_status := FND_API.G_RET_STS_ERROR ;
1504: FND_MSG_PUB.Count_And_Get
1505: (p_count => x_msg_count,
1506: p_data => x_msg_data,
1507: p_encoded => fnd_api.g_false
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: ROLLBACK TO Delete_RuleAttribute;
1511: x_loading_status := 'UNEXPECTED_ERR';
1505: (p_count => x_msg_count,
1506: p_data => x_msg_data,
1507: p_encoded => fnd_api.g_false
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: ROLLBACK TO Delete_RuleAttribute;
1511: x_loading_status := 'UNEXPECTED_ERR';
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: FND_MSG_PUB.Count_And_Get
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: ROLLBACK TO Delete_RuleAttribute;
1511: x_loading_status := 'UNEXPECTED_ERR';
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: FND_MSG_PUB.Count_And_Get
1514: (p_count => x_msg_count,
1515: p_data => x_msg_data,
1516: p_encoded => fnd_api.g_false
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: FND_MSG_PUB.Count_And_Get
1514: (p_count => x_msg_count,
1515: p_data => x_msg_data,
1516: p_encoded => fnd_api.g_false
1517: );
1518: WHEN OTHERS THEN
1519: ROLLBACK TO Delete_RuleAttribute;
1520: x_loading_status := 'UNEXPECTED_ERR';
1517: );
1518: WHEN OTHERS THEN
1519: ROLLBACK TO Delete_RuleAttribute;
1520: x_loading_status := 'UNEXPECTED_ERR';
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Add_Exc_Msg
1529: END IF;
1530: FND_MSG_PUB.Count_And_Get
1531: (p_count => x_msg_count,
1532: p_data => x_msg_data,
1533: p_encoded => fnd_api.g_false
1534: );
1535: END;
1536:
1537: FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2 IS