APPS.EGO_CATG_MAP_PKG dependencies on APP_EXCEPTION

Line 115: app_exception.raise_exception;

111: fetch c into recinfo;
112: if (c%notfound) then
113: close c;
114: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
115: app_exception.raise_exception;
116: end if;
117: close c;
118: if ( ((recinfo.SOURCE_CATG_SET_ID = X_SOURCE_CATG_SET_ID)
119: OR ((recinfo.SOURCE_CATG_SET_ID is null) AND (X_SOURCE_CATG_SET_ID is null)))

Line 128: app_exception.raise_exception;

124: ) then
125: null;
126: else
127: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
128: app_exception.raise_exception;
129: end if;
130:
131: for tlinfo in c1 loop
132: if (tlinfo.BASELANG = 'Y') then

Line 141: app_exception.raise_exception;

137: ) then
138: null;
139: else
140: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
141: app_exception.raise_exception;
142: end if;
143: end if;
144: end loop;
145: return;

Line 248: app_exception.raise_exception;

244: WHEN no_data_found THEN
245: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
246: fnd_message.set_token('ROUTINE','Category Mapping');
247: fnd_message.set_token('REASON','Source Category Set ' || X_SOURCE_CATG_SET_NAME || ' does not exist ' );
248: app_exception.raise_exception;
249: END;
250:
251: BEGIN
252: -- getting the target catg set id by passing the target category_set_name

Line 263: app_exception.raise_exception;

259: WHEN no_data_found THEN
260: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
261: fnd_message.set_token('ROUTINE','Category Mapping');
262: fnd_message.set_token('REASON','Target Category Set ' || X_TARGET_CATG_SET_NAME || ' does not exist ' );
263: app_exception.raise_exception;
264: END;
265:
266: -- trying to findout whether the catg_map id exists for the source and target category sets
267: OPEN get_catg_map_id(l_source_catg_set_id, l_target_catg_set_id);

Line 416: -- app_exception.raise_exception;

412: WHEN no_data_found THEN
413: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
414: fnd_message.set_token('ROUTINE','Category Mapping');
415: fnd_message.set_token('REASON','Source Category ' || X_SOURCE_CATG_NAME || ' does not exist under catalog ' || X_SOURCE_CATG_SET_NAME );
416: -- app_exception.raise_exception;
417: END;
418:
419: -- getting the target category id by passing the target category_name
420: BEGIN

Line 434: -- app_exception.raise_exception;

430: WHEN no_data_found THEN
431: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
432: fnd_message.set_token('ROUTINE','Category Mapping');
433: fnd_message.set_token('REASON','Target Category ' || X_TARGET_CATG_NAME || ' does not exist under catalog ' || X_TARGET_CATG_SET_NAME);
434: -- app_exception.raise_exception;
435: END;
436:
437:
438: -- Getting the category map id based on the source and the target catg sets