eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_CATG_MAP_PKG dependencies on FND_MESSAGE

Line 114: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

110: open c;
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)

Line 127: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

123: OR ((recinfo.ENABLED_FLAG is null) AND (X_ENABLED_FLAG is null)))
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

Line 140: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

136: OR ((tlinfo.CATG_MAP_DESC is null) AND (X_CATG_MAP_DESC is null)))
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;

Line 245: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

241: WHERE CATEGORY_SET_NAME = X_SOURCE_CATG_SET_NAME;
242:
243: 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;

Line 246: fnd_message.set_token('ROUTINE','Category Mapping');

242:
243: 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:

Line 247: fnd_message.set_token('REASON','Source Category Set ' || X_SOURCE_CATG_SET_NAME || ' does not exist ' );

243: 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

Line 260: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

256: WHERE CATEGORY_SET_NAME = X_TARGET_CATG_SET_NAME;
257:
258: 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;

Line 261: fnd_message.set_token('ROUTINE','Category Mapping');

257:
258: 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:

Line 262: fnd_message.set_token('REASON','Target Category Set ' || X_TARGET_CATG_SET_NAME || ' does not exist ' );

258: 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

Line 413: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

409: AND A.STRUCTURE_ID = B.STRUCTURE_ID
410: AND A.CONCATENATED_SEGMENTS = X_SOURCE_CATG_NAME;
411: 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;

Line 414: fnd_message.set_token('ROUTINE','Category Mapping');

410: AND A.CONCATENATED_SEGMENTS = X_SOURCE_CATG_NAME;
411: 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:

Line 415: fnd_message.set_token('REASON','Source Category ' || X_SOURCE_CATG_NAME || ' does not exist under catalog ' || X_SOURCE_CATG_SET_NAME );

411: 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

Line 431: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');

427: AND A.STRUCTURE_ID = B.STRUCTURE_ID
428: AND A.CONCATENATED_SEGMENTS = X_TARGET_CATG_NAME;
429: 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;

Line 432: fnd_message.set_token('ROUTINE','Category Mapping');

428: AND A.CONCATENATED_SEGMENTS = X_TARGET_CATG_NAME;
429: 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:

Line 433: fnd_message.set_token('REASON','Target Category ' || X_TARGET_CATG_NAME || ' does not exist under catalog ' || X_TARGET_CATG_SET_NAME);

429: 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: