82:
83: IF (p_parent_group_id = l_parent_group_id) OR
84: (p_parent_group_name = l_parent_group_name) OR
85: ( (l_parent_group_id IS NULL)
86: AND (p_parent_group_id IS NULL OR p_parent_group_id = FND_API.G_MISS_NUM)
87: AND (p_parent_group_name IS NULL OR p_parent_group_name = FND_API.G_MISS_CHAR)
88: ) THEN
89: RETURN false;
90: ELSE
83: IF (p_parent_group_id = l_parent_group_id) OR
84: (p_parent_group_name = l_parent_group_name) OR
85: ( (l_parent_group_id IS NULL)
86: AND (p_parent_group_id IS NULL OR p_parent_group_id = FND_API.G_MISS_NUM)
87: AND (p_parent_group_name IS NULL OR p_parent_group_name = FND_API.G_MISS_CHAR)
88: ) THEN
89: RETURN false;
90: ELSE
91: RETURN true;
175:
176: IF EGO_Globals.G_Catalog_Group_Rec.transaction_type = Ego_Globals.G_OPR_UPDATE THEN
177:
178: IF (EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NOT NULL OR
179: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name <> FND_API.G_MISS_CHAR) OR
180: (EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NOT NULL OR
181: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id <> FND_API.G_MISS_NUM) THEN
182:
183: IF is_parent_updated (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id,
177:
178: IF (EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name IS NOT NULL OR
179: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name <> FND_API.G_MISS_CHAR) OR
180: (EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id IS NOT NULL OR
181: EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id <> FND_API.G_MISS_NUM) THEN
182:
183: IF is_parent_updated (p_catalog_group_id => EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id,
184: p_parent_group_id => EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Id,
185: p_parent_group_name => EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name) THEN
185: p_parent_group_name => EGO_Globals.G_Catalog_Group_Rec.Parent_Catalog_Group_Name) THEN
186:
187: IF (NOT is_parent_update_allowed(EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id)) THEN
188:
189: l_return_status := FND_API.G_RET_STS_ERROR;
190: Error_Handler.Write_Debug('Raising exception as parent update is not allowed. . .QUIT_RECORD');
191: l_other_message := 'EGO_ICC_DIS_UPD';
192: RAISE EGO_Globals.G_EXC_SEV_QUIT_RECORD;
193:
245: /* Assign null to the segments that are not used */
246:
247: FOR i in 1..20
248: LOOP
249: IF EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) = FND_API.G_MISS_CHAR
250: THEN
251: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
252: END IF;
253: END LOOP;
270:
271: IF l_valid <> true
272: THEN
273: -- quit since the record does not have a valid transaction type.
274: l_return_status := FND_API.G_RET_STS_ERROR;
275: RAISE EGO_Globals.G_EXC_SEV_QUIT_RECORD;
276: END IF;
277:
278: