DBA Data[Home] [Help]

APPS.IGS_UC_MV_IMP_DEGSUBJ dependencies on FND_MESSAGE

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

79: -- check for 'DS' lookup code type exists in lookups or not.
80: OPEN refcode_types_cur;
81: FETCH refcode_types_cur INTO refcode_types_rec;
82: IF refcode_types_cur%NOTFOUND THEN
83: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
84: FND_MESSAGE.SET_TOKEN('CODE_TYPE','DS');
85: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
86: RETCODE := 2;
87: RETURN;

Line 84: FND_MESSAGE.SET_TOKEN('CODE_TYPE','DS');

80: OPEN refcode_types_cur;
81: FETCH refcode_types_cur INTO refcode_types_rec;
82: IF refcode_types_cur%NOTFOUND THEN
83: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
84: FND_MESSAGE.SET_TOKEN('CODE_TYPE','DS');
85: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
86: RETCODE := 2;
87: RETURN;
88: END IF;

Line 85: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

81: FETCH refcode_types_cur INTO refcode_types_rec;
82: IF refcode_types_cur%NOTFOUND THEN
83: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
84: FND_MESSAGE.SET_TOKEN('CODE_TYPE','DS');
85: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
86: RETCODE := 2;
87: RETURN;
88: END IF;
89: CLOSE refcode_types_cur;

Line 136: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');

132: END LOOP;
133:
134: -- Print Number of records successfully transferred
135: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
136: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
137: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
138: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
139:
140: -- commit the data;

Line 137: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);

133:
134: -- Print Number of records successfully transferred
135: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
136: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
137: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
138: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
139:
140: -- commit the data;
141: COMMIT;

Line 138: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

134: -- Print Number of records successfully transferred
135: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
136: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
137: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
138: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
139:
140: -- commit the data;
141: COMMIT;
142: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 148: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

144: EXCEPTION
145: WHEN app_exception.record_lock_exception THEN
146: ROLLBACK;
147: retcode := 2;
148: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
149: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
150:
151: WHEN OTHERS THEN
152: ROLLBACK;

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

150:
151: WHEN OTHERS THEN
152: ROLLBACK;
153: RETCODE := 2;
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
155: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_DEGSUBJ.IMP_DEGSUBJECT_CODES - '||SQLERRM);
156: ERRBUF := FND_MESSAGE.GET;
157: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
158: END Imp_Degsubject_codes;

Line 155: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_DEGSUBJ.IMP_DEGSUBJECT_CODES - '||SQLERRM);

151: WHEN OTHERS THEN
152: ROLLBACK;
153: RETCODE := 2;
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
155: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_DEGSUBJ.IMP_DEGSUBJECT_CODES - '||SQLERRM);
156: ERRBUF := FND_MESSAGE.GET;
157: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
158: END Imp_Degsubject_codes;
159: END igs_uc_mv_imp_degsubj;

Line 156: ERRBUF := FND_MESSAGE.GET;

152: ROLLBACK;
153: RETCODE := 2;
154: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
155: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_DEGSUBJ.IMP_DEGSUBJECT_CODES - '||SQLERRM);
156: ERRBUF := FND_MESSAGE.GET;
157: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
158: END Imp_Degsubject_codes;
159: END igs_uc_mv_imp_degsubj;