DBA Data[Home] [Help]

APPS.IGS_AV_GEN_001 dependencies on FND_FILE

Line 419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));

415: v_message_name) THEN
416: v_ret_false := v_ret_false + 1;
417:
418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);
419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));
420: END IF;
421: IF v_message_name IS NOT NULL AND v_message_name NOT IN ('IGS_AV_HAS_UNIT_ATT') THEN
422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));
423: END IF;

Line 422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));

418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);
419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));
420: END IF;
421: IF v_message_name IS NOT NULL AND v_message_name NOT IN ('IGS_AV_HAS_UNIT_ATT') THEN
422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));
423: END IF;
424: tot_rec_process := tot_rec_process + 1;
425: END LOOP;
426: IF tot_rec_process = 0 THEN

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));

423: END IF;
424: tot_rec_process := tot_rec_process + 1;
425: END LOOP;
426: IF tot_rec_process = 0 THEN
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;

Line 430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));

426: IF tot_rec_process = 0 THEN
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));

428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));
435: END;
436: EXCEPTION

Line 434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));

430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));
435: END;
436: EXCEPTION
437: WHEN OTHERS THEN
438: RETCODE:=2;

Line 920: fnd_file.put_line(fnd_file.log,fnd_message.get());

916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||
923: TO_CHAR(v_asu_rec.person_id) || '|' ||
924: v_asu_rec.as_course_cd || '|' ||

Line 921: fnd_file.put_line(FND_FILE.LOG,' ');

917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||
923: TO_CHAR(v_asu_rec.person_id) || '|' ||
924: v_asu_rec.as_course_cd || '|' ||
925: TO_CHAR(v_asu_rec.as_version_number) || '|' ||

Line 1730: fnd_file.put_line(fnd_file.log,fnd_message.get());

1726: p_message_name := 'IGS_AV_HAS_UNIT_ATT';
1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');
1732: -- End of new code. Added as per the bug# 2382566.
1733: ELSIF (gv_sua_rec.unit_attempt_status NOT IN (cst_duplicate)) THEN
1734: p_message_name := NULL;

Line 1731: fnd_file.put_line(FND_FILE.LOG,' ');

1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');
1732: -- End of new code. Added as per the bug# 2382566.
1733: ELSIF (gv_sua_rec.unit_attempt_status NOT IN (cst_duplicate)) THEN
1734: p_message_name := NULL;
1735: END IF;

Line 1854: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||

1850:
1851: IF (c_adv_stnd_unit%ISOPEN) THEN
1852: CLOSE c_adv_stnd_unit;
1853: END IF;
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||
1855: FND_MESSAGE.GET_STRING('IGS',
1856: 'IGS_AV_UNABLE_EXP_UNIT_UPD'));
1857: RAISE;
1858: WHEN OTHERS THEN

Line 1899: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||

1895: WHEN e_resource_busy THEN
1896: IF (c_adv_stnd_unit_level%ISOPEN) THEN
1897: CLOSE c_adv_stnd_unit_level;
1898: END IF;
1899: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||
1900: FND_MESSAGE.GET_STRING('IGS','IGS_AV_LVL_UPD_ANOTHER_PRC'));
1901: RAISE;
1902: WHEN OTHERS THEN
1903: RAISE;