APPS.IGS_AD_GEN_012 dependencies on FND_FILE

Line 461: fnd_file.put_line(fnd_file.log, 'Failed to update Offer Response Status to LAPSED for Person ID: '|| Rec_IGS_AD_PS_APPL_Inst.PERSON_ID || '; Admission Application Number: ' ||

457: EXCEPTION
458: WHEN e_resource_busy THEN
459: RAISE;
460: WHEN OTHERS THEN
461: fnd_file.put_line(fnd_file.log, 'Failed to update Offer Response Status to LAPSED for Person ID: '|| Rec_IGS_AD_PS_APPL_Inst.PERSON_ID || '; Admission Application Number: ' ||
462: Rec_IGS_AD_PS_APPL_Inst.ADMISSION_APPL_NUMBER || '; Course Code: ' || Rec_IGS_AD_PS_APPL_Inst.NOMINATED_COURSE_CD || '; Sequence Number: '||
463: Rec_IGS_AD_PS_APPL_Inst.SEQUENCE_NUMBER );
464: l_msg_data := FND_MESSAGE.GET;
465: IF l_msg_data is not null THEN

Line 466: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Reason: ' || l_msg_data);

462: Rec_IGS_AD_PS_APPL_Inst.ADMISSION_APPL_NUMBER || '; Course Code: ' || Rec_IGS_AD_PS_APPL_Inst.NOMINATED_COURSE_CD || '; Sequence Number: '||
463: Rec_IGS_AD_PS_APPL_Inst.SEQUENCE_NUMBER );
464: l_msg_data := FND_MESSAGE.GET;
465: IF l_msg_data is not null THEN
466: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Reason: ' || l_msg_data);
467: END IF;
468: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
469: l_msg_data := null;
470: END;

Line 468: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

464: l_msg_data := FND_MESSAGE.GET;
465: IF l_msg_data is not null THEN
466: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Reason: ' || l_msg_data);
467: END IF;
468: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
469: l_msg_data := null;
470: END;
471:
472: END LOOP;

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

479:
480: EXCEPTION
481: WHEN e_resource_busy THEN
482: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRGAPPL_NOT_LAPSED');
483: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
484: WHEN OTHERS THEN
485: IF c_update_acai%ISOPEN THEN
486: CLOSE c_update_acai;
487: END IF;