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.HZ_DQM_SEARCH_UTIL dependencies on FND_MESSAGE

Line 152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

148: END IF;
149: END IF;
150: EXCEPTION
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
153: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_transformation');
154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
155: FND_MSG_PUB.ADD;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 153: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_transformation');

149: END IF;
150: EXCEPTION
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
153: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_transformation');
154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
155: FND_MSG_PUB.ADD;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END add_transformation;

Line 154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

150: EXCEPTION
151: WHEN OTHERS THEN
152: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
153: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_transformation');
154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
155: FND_MSG_PUB.ADD;
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END add_transformation;
158:

Line 173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

169: '{' || replace(p_tx_val,'_',' ') || '} within ' || check_misc(p_within);
170: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
174: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_filter');
175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 174: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_filter');

170: END IF;
171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
174: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_filter');
175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END add_filter;

Line 175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
174: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_filter');
175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
176: FND_MSG_PUB.ADD;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END add_filter;
179:

Line 194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

190: p_tx_str || ')';
191: END IF;
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
195: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute');
196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 195: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute');

191: END IF;
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
195: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute');
196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END add_attribute;

Line 196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
195: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute');
196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END add_attribute;
200:

Line 221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

217: END IF;
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
222: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm');
223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 222: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm');

218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
222: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm');
223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END add_attribute_with_denorm;

Line 223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

219: EXCEPTION
220: WHEN OTHERS THEN
221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
222: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm');
223: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END add_attribute_with_denorm;
227:

Line 248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

244: END IF;
245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN
248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
249: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_search_record');
250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 249: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_search_record');

245: END IF;
246: EXCEPTION
247: WHEN OTHERS THEN
248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
249: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_search_record');
250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END;

Line 250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

246: EXCEPTION
247: WHEN OTHERS THEN
248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
249: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.add_search_record');
250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END;
254:

Line 269: FND_MESSAGE.SET_NAME('AR', 'HZ_RESTRICT_SQL_ERROR');

265: p_subset_defn || ') AND SEARCH_CONTEXT_ID = :ctxid';
266: EXECUTE IMMEDIATE l_sqlstr USING p_search_ctx_id;
267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('AR', 'HZ_RESTRICT_SQL_ERROR');
270: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_matches_not_in_subset');
271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 270: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_matches_not_in_subset');

266: EXECUTE IMMEDIATE l_sqlstr USING p_search_ctx_id;
267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('AR', 'HZ_RESTRICT_SQL_ERROR');
270: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_matches_not_in_subset');
271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END remove_matches_not_in_subset;

Line 271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

267: EXCEPTION
268: WHEN OTHERS THEN
269: FND_MESSAGE.SET_NAME('AR', 'HZ_RESTRICT_SQL_ERROR');
270: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_matches_not_in_subset');
271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END remove_matches_not_in_subset;
275:

Line 454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

450: END IF;
451: END IF;
452: EXCEPTION
453: WHEN OTHERS THEN
454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.is_similar');
456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 455: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.is_similar');

451: END IF;
452: EXCEPTION
453: WHEN OTHERS THEN
454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.is_similar');
456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END;

Line 456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

452: EXCEPTION
453: WHEN OTHERS THEN
454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
455: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_DQM_SEARCH_UTIL.is_similar');
456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
457: FND_MSG_PUB.ADD;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END;
460:

Line 641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_QUAL_SCORE'); -- Error occured in obtaining a quality score. Please contact system adminsitrator or turn profile option off to run DQM without quality score.

637: END LOOP;
638: END IF;
639: END IF;
640: EXCEPTION WHEN OTHERS THEN
641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_QUAL_SCORE'); -- Error occured in obtaining a quality score. Please contact system adminsitrator or turn profile option off to run DQM without quality score.
642: FND_MSG_PUB.ADD;
643: RAISE;
644: END get_quality_score;
645: