73: v_message_name VARCHAR2(30);
74: BEGIN
75: IF p_deleting
76: THEN
77: IGS_RU_VAL_RGI.rulp_set_rgi(old_references.rug_sequence_number,
78: old_references.description_number,
79: old_references.description_type);
80: ELSE
81: -- validate description and type
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: IGS_RU_VAL_RGI.rulp_set_rgi(new_references.rug_sequence_number,
92: new_references.description_number,
93: new_references.description_type);
94: END IF;
95:
107: ) as
108: v_message_name VARCHAR2(30);
109: BEGIN
110: -- validate for allowed group
111: IF IGS_RU_VAL_RGI.rulp_val_grp_rgi = FALSE
112: THEN
113: v_message_name := 'IGS_GE_GROUP_INSERT_NOT_ALLOW';
114: Fnd_Message.Set_Name('IGS',v_message_name);
115: IGS_GE_MSG_STACK.ADD;
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: -- populate IGS_RU_GROUP_SET, trigger ancestor groups in IGS_RU_GROUP_ITEM
119: IGS_RU_VAL_RGI.rulp_ins_rgi;
120:
121:
122: END AfterStmtInsertUpdateDelete2;
123: