47: WHEN OTHERS THEN
48: IF (c_us%ISOPEN) THEN
49: CLOSE c_us;
50: END IF;
51: App_Exception.Raise_Exception;
52: END;
53: END crsp_val_iud_us_dtl;
54: --
55: -- Validate COUSR hierarchy for duplicate ancestors/descendants
131: WHEN OTHERS THEN
132: IF c_cousr%ISOPEN THEN
133: CLOSE c_cousr;
134: END IF;
135: App_Exception.Raise_Exception;
136: END;
137: END crspl_val_tree_circle;
138: BEGIN
139: -- set default vaule
181: WHEN OTHERS THEN
182: IF c_cous%ISOPEN THEN
183: CLOSE c_cous;
184: END IF;
185: App_Exception.Raise_Exception;
186: END;
187: END crsp_val_cousr_tree;
188: --
189: -- Validate COUSR can only be created with US as superior if appropriate
256: WHEN OTHERS THEN
257: IF (c_cacus%ISOPEN) THEN
258: CLOSE c_cacus;
259: END IF;
260: App_Exception.Raise_Exception;
261: END;
262: END crsp_val_cousr_cacus;
263: --
264: END IGS_PS_VAL_COusr;