DBA Data[Home] [Help]

APPS.IGS_PE_DUP_PERSON dependencies on FND_MESSAGE

Line 76: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PROF_DUP_CRTRIA_MANUAL');

72: -- To check value of Profile : Duplicate Match Criteria and pass appropriate error message
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;

Line 83: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PROF_DUP_CRTRIA_MANUAL');

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
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;

Line 178: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

174: WHEN OTHERS THEN
175: IF DBMS_SQL.IS_OPEN(l_Ext_Cursor) THEN
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;

Line 179: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_dup_person.find_duplicates'||'-'||SQLERRM);

175: IF DBMS_SQL.IS_OPEN(l_Ext_Cursor) THEN
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:

Line 250: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

246: WHEN OTHERS THEN
247: IF DBMS_SQL.IS_OPEN(l_Ext_Cursor) THEN
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;

Line 251: FND_MESSAGE.SET_TOKEN('NAME','igs_pe_dup_person.find_duplicates'||'-'||SQLERRM);

247: IF DBMS_SQL.IS_OPEN(l_Ext_Cursor) THEN
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;