DBA Data[Home] [Help]

APPS.IGS_AD_IMP_ACIDX_PKG dependencies on FND_MESSAGE

Line 86: -- FND_MESSAGE.SET_NAME('IGS',p_log_text);

82: error_code = p_error_code,
83: error_Text = p_log_text
84: WHERE acadindex_id = p_acadindex_id;
85:
86: -- FND_MESSAGE.SET_NAME('IGS',p_log_text);
87: FND_FILE.PUT_LINE(FND_FILE.LOG,p_log_text||' - '||p_acadindex_id);
88:
89: END update_int_table;
90:

Line 165: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_REC_DELETED');

161: FETCH c_purge INTO l_purge;
162: IF c_purge%NOTFOUND THEN
163: DELETE igs_ad_acidx_hdr_all
164: WHERE acadindex_batch_id = p_acadindex_batch_id;
165: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_REC_DELETED');
166: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET||' - '||p_acadindex_batch_id);
167: END IF;
168: --FND_FILE.PUT_LINE(FND_FILE.LOG, '9: After purging the parent record');
169: CLOSE c_purge;

Line 166: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET||' - '||p_acadindex_batch_id);

162: IF c_purge%NOTFOUND THEN
163: DELETE igs_ad_acidx_hdr_all
164: WHERE acadindex_batch_id = p_acadindex_batch_id;
165: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_REC_DELETED');
166: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET||' - '||p_acadindex_batch_id);
167: END IF;
168: --FND_FILE.PUT_LINE(FND_FILE.LOG, '9: After purging the parent record');
169: CLOSE c_purge;
170:

Line 178: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')|| sqlerrm;

174: EXCEPTION
175: WHEN OTHERS THEN
176: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '10: When any exception of program');
177: retcode:=2;
178: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION')|| sqlerrm;
179: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '11: Before Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL');
180: -- Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
181: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '12: After Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL');
182: ROLLBACK;