APPS.HZ_DQM_SEARCH_UTIL dependencies on HZ_DQM_SEARCH_UTIL

Line 1: PACKAGE BODY HZ_DQM_SEARCH_UTIL AS

1: PACKAGE BODY HZ_DQM_SEARCH_UTIL AS
2: /*$Header: ARHDQUTB.pls 120.29 2006/02/11 00:19:27 schitrap noship $ */
3: g_within_threshold NUMBER := 4;
4:
5: g_string VARCHAR2(2000);

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 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 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 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 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 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 540: X := hz_dqm_search_util.is_dqm_available;

536: and staged_flag <> 'Y'
537: and nvl(active_flag, 'Y') <> 'N' ;
538:
539: BEGIN
540: X := hz_dqm_search_util.is_dqm_available;
541: IF (X = FND_API.G_TRUE) THEN
542: OPEN c1;
543: FETCH c1 INTO l_comp_flag;
544: IF (l_comp_flag = 'C') THEN