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_API

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
159: PROCEDURE add_filter (
160: p_tx_val IN VARCHAR2,

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
180: PROCEDURE add_attribute (
181: p_tx_str IN VARCHAR2,

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
201: PROCEDURE add_attribute_with_denorm (
202: p_tx_str IN VARCHAR2,

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
228:
229: PROCEDURE add_search_record (

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
255: -- Remove records from HZ_DQM_PARTIES_GT which don't satisfy subset_defn
256: PROCEDURE remove_matches_not_in_subset (

Line 273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
276: FUNCTION strtok (
277: p_string VARCHAR2 DEFAULT NULL,

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
461: -- This Function tests if the DQM indexes have been created
462: -- and if they are valid

Line 477: RETURN FND_API.G_FALSE;

473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: NULL;
476: WHEN OTHERS THEN
477: RETURN FND_API.G_FALSE;
478: END;
479: BEGIN
480: SELECT 1 INTO T FROM HZ_STAGED_PARTY_SITES
481: WHERE ROWNUM=1

Line 487: RETURN FND_API.G_FALSE;

483: EXCEPTION
484: WHEN NO_DATA_FOUND THEN
485: NULL;
486: WHEN OTHERS THEN
487: RETURN FND_API.G_FALSE;
488: END;
489: BEGIN
490: SELECT 1 INTO T FROM HZ_STAGED_CONTACTS
491: WHERE ROWNUM=1

Line 497: RETURN FND_API.G_FALSE;

493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN
495: NULL;
496: WHEN OTHERS THEN
497: RETURN FND_API.G_FALSE;
498: END;
499: BEGIN
500: SELECT 1 INTO T FROM HZ_STAGED_CONTACT_POINTS
501: WHERE ROWNUM=1

Line 507: RETURN FND_API.G_FALSE;

503: EXCEPTION
504: WHEN NO_DATA_FOUND THEN
505: NULL;
506: WHEN OTHERS THEN
507: RETURN FND_API.G_FALSE;
508: END;
509: RETURN FND_API.G_TRUE;
510: END;
511:

Line 509: RETURN FND_API.G_TRUE;

505: NULL;
506: WHEN OTHERS THEN
507: RETURN FND_API.G_FALSE;
508: END;
509: RETURN FND_API.G_TRUE;
510: END;
511:
512:
513: FUNCTION is_dqm_available(

Line 541: IF (X = FND_API.G_TRUE) THEN

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
545: OPEN c2;

Line 548: X := FND_API.G_TRUE;

544: IF (l_comp_flag = 'C') THEN
545: OPEN c2;
546: FETCH c2 INTO l_count;
547: IF (l_count = 0) THEN
548: X := FND_API.G_TRUE;
549: ELSE
550: X := FND_API.G_FALSE;
551: END IF;
552: ELSE

Line 550: X := FND_API.G_FALSE;

546: FETCH c2 INTO l_count;
547: IF (l_count = 0) THEN
548: X := FND_API.G_TRUE;
549: ELSE
550: X := FND_API.G_FALSE;
551: END IF;
552: ELSE
553: X := FND_API.G_FALSE;
554: END IF;

Line 553: X := FND_API.G_FALSE;

549: ELSE
550: X := FND_API.G_FALSE;
551: END IF;
552: ELSE
553: X := FND_API.G_FALSE;
554: END IF;
555: ELSE
556: X := FND_API.G_FALSE;
557: END IF;

Line 556: X := FND_API.G_FALSE;

552: ELSE
553: X := FND_API.G_FALSE;
554: END IF;
555: ELSE
556: X := FND_API.G_FALSE;
557: END IF;
558: RETURN X;
559: END is_dqm_available;
560: