361: BEGIN
362:
363: -- dbms_output.put_line('Checking for items during delete');
364:
365: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_system_items_b
366: WHERE item_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
367:
368: Error_Handler.Add_Error_Token
369: ( p_message_name => 'EGO_CATALOG_HAS_ITEMS'
393:
394: BEGIN
395: -- dbms_output.put_line('Checking for parent catalog group during delete');
396:
397: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (SELECT null FROM mtl_item_catalog_groups_b
398: WHERE parent_catalog_group_id = EGO_Globals.G_Catalog_Group_Rec.Catalog_group_id);
399:
400: -- dbms_output.put_line('Found parent catalog group during delete');
401: