DBA Data[Home] [Help]

APPS.IGS_UC_MV_IMP_ERRCD dependencies on FND_MESSAGE

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

85: -- check for 'EC' lookup code exists in the lookups or not
86: OPEN refcode_types_cur;
87: FETCH refcode_types_cur INTO refcode_types_rec;
88: IF refcode_types_cur%NOTFOUND THEN
89: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
90: FND_MESSAGE.SET_TOKEN('CODE_TYPE','EC');
91: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
92: RETCODE := 2;
93: RETURN;

Line 90: FND_MESSAGE.SET_TOKEN('CODE_TYPE','EC');

86: OPEN refcode_types_cur;
87: FETCH refcode_types_cur INTO refcode_types_rec;
88: IF refcode_types_cur%NOTFOUND THEN
89: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
90: FND_MESSAGE.SET_TOKEN('CODE_TYPE','EC');
91: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
92: RETCODE := 2;
93: RETURN;
94: END IF;

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

87: FETCH refcode_types_cur INTO refcode_types_rec;
88: IF refcode_types_cur%NOTFOUND THEN
89: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_REFCODETYP_NOT_EXISTS');
90: FND_MESSAGE.SET_TOKEN('CODE_TYPE','EC');
91: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
92: RETCODE := 2;
93: RETURN;
94: END IF;
95: CLOSE refcode_types_cur;

Line 138: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_NON_NUMERIC_ERR_CD');

134: CLOSE refcodes_cur;
135:
136: EXCEPTION
137: WHEN VALUE_ERROR THEN
138: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_NON_NUMERIC_ERR_CD');
139: FND_MESSAGE.SET_TOKEN('ERR_CODE',err_proc_rec.error_code);
140: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
141: RETCODE := 2;
142: RETURN;

Line 139: FND_MESSAGE.SET_TOKEN('ERR_CODE',err_proc_rec.error_code);

135:
136: EXCEPTION
137: WHEN VALUE_ERROR THEN
138: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_NON_NUMERIC_ERR_CD');
139: FND_MESSAGE.SET_TOKEN('ERR_CODE',err_proc_rec.error_code);
140: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
141: RETCODE := 2;
142: RETURN;
143: END ;

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

136: EXCEPTION
137: WHEN VALUE_ERROR THEN
138: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_NON_NUMERIC_ERR_CD');
139: FND_MESSAGE.SET_TOKEN('ERR_CODE',err_proc_rec.error_code);
140: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
141: RETCODE := 2;
142: RETURN;
143: END ;
144:

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

147: END LOOP;
148:
149: -- Print Number of records successfully transferred
150: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
151: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
152: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
154:
155: -- commit the data;

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

148:
149: -- Print Number of records successfully transferred
150: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
151: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
152: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
154:
155: -- commit the data;
156: COMMIT;

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

149: -- Print Number of records successfully transferred
150: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
151: FND_MESSAGE.SET_NAME('IGS', 'IGS_UC_MV_LOAD_SUCCESS');
152: FND_MESSAGE.SET_TOKEN('CNT', l_success_cnt);
153: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
154:
155: -- commit the data;
156: COMMIT;
157: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

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

160:
161: WHEN app_exception.record_lock_exception THEN
162: ROLLBACK;
163: retcode := 2;
164: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
165: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
166:
167: WHEN OTHERS THEN
168: ROLLBACK;

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

166:
167: WHEN OTHERS THEN
168: ROLLBACK;
169: RETCODE := 2;
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
171: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_ERRCD.IMP_ERROR_CODES - '||SQLERRM);
172: ERRBUF := FND_MESSAGE.GET;
173: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
174: END imp_error_codes;

Line 171: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_ERRCD.IMP_ERROR_CODES - '||SQLERRM);

167: WHEN OTHERS THEN
168: ROLLBACK;
169: RETCODE := 2;
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
171: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_ERRCD.IMP_ERROR_CODES - '||SQLERRM);
172: ERRBUF := FND_MESSAGE.GET;
173: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
174: END imp_error_codes;
175:

Line 172: ERRBUF := FND_MESSAGE.GET;

168: ROLLBACK;
169: RETCODE := 2;
170: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
171: FND_MESSAGE.SET_TOKEN('NAME','IGS_UC_MV_IMP_ERRCD.IMP_ERROR_CODES - '||SQLERRM);
172: ERRBUF := FND_MESSAGE.GET;
173: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
174: END imp_error_codes;
175:
176: END igs_uc_mv_imp_errcd;