APPS.IGS_PE_DUP_PERSON dependencies on APP_EXCEPTION

Line 77: APP_EXCEPTION.RAISE_EXCEPTION;

73: l_profile_value := fnd_profile.VALUE('IGS_PE_DUP_MATCH_CRITERIA');
74:
75: IF l_profile_value IS NULL THEN
76: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PROF_DUP_CRTRIA_MANUAL');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: ELSE
79: OPEN c_match_set_criteria('MANUAL',TO_NUMBER(l_profile_value),'N');
80: FETCH c_match_set_criteria INTO l_match_set_id;
81: IF c_match_set_criteria%NOTFOUND THEN

Line 84: APP_EXCEPTION.RAISE_EXCEPTION;

80: FETCH c_match_set_criteria INTO l_match_set_id;
81: IF c_match_set_criteria%NOTFOUND THEN
82: CLOSE c_match_set_criteria;
83: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PROF_DUP_CRTRIA_MANUAL');
84: APP_EXCEPTION.RAISE_EXCEPTION;
85: END IF;
86: CLOSE c_match_set_criteria;
87: END IF;
88:

Line 180: APP_EXCEPTION.RAISE_EXCEPTION;

176: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);
177: END IF;
178: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
179: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_dup_person.find_duplicates'||'-'||SQLERRM);
180: APP_EXCEPTION.RAISE_EXCEPTION;
181: END;
182: END IF;
183:
184: -- If the exact selec statement does not return any rows, go for partial match.

Line 252: APP_EXCEPTION.RAISE_EXCEPTION;

248: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);
249: END IF;
250: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
251: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_dup_person.find_duplicates'||'-'||SQLERRM);
252: APP_EXCEPTION.RAISE_EXCEPTION;
253: END;
254: END IF;
255: END IF;
256: END FIND_DUPLICATES;