DBA Data[Home] [Help]

APPS.RG_DSS_HIERARCHY_DETAILS_PKG dependencies on APP_EXCEPTION

Line 24: APP_EXCEPTION.raise_exception;

20: -- name already exists for a different hierarchy: ERROR
21: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
22: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEQUENCE', TRUE);
23: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_HIERARCHY', TRUE);
24: APP_EXCEPTION.raise_exception;
25:
26: EXCEPTION
27: WHEN NO_DATA_FOUND THEN
28: -- name doesn't exist, so do nothing

Line 49: APP_EXCEPTION.raise_exception;

45: -- name already exists for a different hierarchy: ERROR
46: FND_MESSAGE.set_name('RG', 'RG_FORMS_OBJECT_EXISTS_FOR');
47: FND_MESSAGE.set_token('OBJECT1', 'RG_DSS_SEGMENT', TRUE);
48: FND_MESSAGE.set_token('OBJECT2', 'RG_DSS_HIERARCHY', TRUE);
49: APP_EXCEPTION.raise_exception;
50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: -- name doesn't exist, so do nothing

Line 108: APP_EXCEPTION.raise_exception;

104: IF (RG_DSS_HIERARCHIES_PKG.used_in_frozen_system(X_Hierarchy_Id)) THEN
105: -- can't modify a frozen system
106: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
107: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
108: APP_EXCEPTION.raise_exception;
109: END IF;
110:
111: check_unique_sequence(X_Rowid, X_Hierarchy_Id, X_Sequence);
112: check_unique_segment(X_Rowid, X_Hierarchy_Id, X_Application_Column_Name);

Line 214: APP_EXCEPTION.RAISE_EXCEPTION;

210: FETCH C INTO Recinfo;
211: IF (C%NOTFOUND) THEN
212: CLOSE C;
213: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END IF;
216: CLOSE C;
217:
218: IF (

Line 283: APP_EXCEPTION.RAISE_EXCEPTION;

279: ) THEN
280: RETURN;
281: ELSE
282: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
283: APP_EXCEPTION.RAISE_EXCEPTION;
284: END IF;
285: END Lock_Row;
286:
287:

Line 318: APP_EXCEPTION.raise_exception;

314: IF (RG_DSS_HIERARCHIES_PKG.used_in_frozen_system(X_Hierarchy_Id)) THEN
315: -- can't modify a frozen system
316: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
317: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
318: APP_EXCEPTION.raise_exception;
319: END IF;
320:
321: UPDATE rg_dss_hierarchy_details
322: SET

Line 360: APP_EXCEPTION.raise_exception;

356: IF (RG_DSS_HIERARCHIES_PKG.used_in_frozen_system(X_Hierarchy_Id)) THEN
357: -- can't modify a frozen system
358: FND_MESSAGE.set_name('RG', 'RG_DSS_FROZEN_SYSTEM');
359: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
360: APP_EXCEPTION.raise_exception;
361: END IF;
362:
363: DELETE FROM rg_dss_hierarchy_details
364: WHERE rowid = X_Rowid;