DBA Data[Home] [Help]

APPS.IGS_AD_GRD_DATA_LOAD dependencies on FND_FILE

Line 173: FND_FILE.PUT_LINE( FND_FILE.LOG,

169: vtac_sex := RTRIM(SUBSTR(G_vtac_output_buffer,171,1));
170:
171:
172: -- Log the student loaded
173: FND_FILE.PUT_LINE( FND_FILE.LOG,
174: G_read_number||'-'||vtac_id_num||' '||vtac_surname||' '||vtac_DateOfBirth);
175:
176:
177: -- Check to see if the person already exists on Callista.

Line 195: FND_FILE.PUT_LINE( FND_FILE.LOG, vtac_id_num||'.'||RTRIM(G_message_str));

191:
192: IF (v_message_name IS NOT NULL) THEN
193: -- vtac_DateOfBirth has wrong date format
194: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
195: FND_FILE.PUT_LINE( FND_FILE.LOG, vtac_id_num||'.'||RTRIM(G_message_str));
196: END IF;
197:
198:
199: IF G_match_person_id = 0 THEN

Line 234: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str));

230: G_message_str) = FALSE
231:
232: THEN
233: ROLLBACK;
234: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str));
235: UTL_FILE.FCLOSE(vtac_filehandle);
236: retcode := 2;
237: return;
238: END IF;

Line 243: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_message_str));

239:
240:
241: --Log the creating record message
242:
243: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_message_str));
244:
245: --Save the ID number we have used so far into a new variable. We can then use this
246: --variable from now on regardless of if the student was new or matched.
247: IF G_match_person_id <> 0 THEN

Line 283: FND_FILE.PUT_LINE(FND_FILE.LOG,G_current_person_id||' '||IGS_GE_GEN_004.GENP_GET_LOOKUP('REPORT','REJTD'));

279:
280: ELSE
281:
282: IF G_match_person_id = 0 THEN
283: FND_FILE.PUT_LINE(FND_FILE.LOG,G_current_person_id||' '||IGS_GE_GEN_004.GENP_GET_LOOKUP('REPORT','REJTD'));
284: END IF;
285:
286: END IF;
287:

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NUM_OF_RECORD_READ')||'-'||G_read_number);

293: ELSE
294: COMMIT;
295: END IF;
296:
297: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NUM_OF_RECORD_READ')||'-'||G_read_number);
298:
299: UTL_FILE.FCLOSE(vtac_filehandle);
300:
301: EXCEPTION

Line 392: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));

388: p_vtac_bus_ph,
389: v_message_name) = FALSE THEN
390:
391: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
392: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));
393: END IF;
394:
395: ELSE
396: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(

Line 411: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));

407: p_vtac_bus_ph,
408: v_message_name) = FALSE THEN
409:
410: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
411: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));
412: END IF;
413: END IF; --End of if aust_address
414:
415: EXCEPTION

Line 479: FND_FILE.PUT_LINE( FND_FILE.LOG,

475: basis_for_admission_type,
476: v_message_name) = FALSE) THEN
477:
478: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
479: FND_FILE.PUT_LINE( FND_FILE.LOG,
480: RTRIM (G_message_str)||' '||vtac_category);
481: RETURN FALSE;
482: ROLLBACK;
483: END IF;

Line 571: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_WARNING_APPLICANT')||' '||

567: G_message_str := RTRIM(G_message_str);
568:
569: IF return_type = 'W' THEN
570:
571: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_WARNING_APPLICANT')||' '||
572: G_current_person_id||'-'||course_cd||'-'||vtac_inco||'.'||
573: G_message_str||'-'||
574: FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADPS_APPL_INST_CREATIN'));
575: valid_pref := 'TRUE';

Line 588: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_ERR_APPLICANT')||' '||

584: END IF;
585:
586: --There must have been an error inserting
587:
588: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_ERR_APPLICANT')||' '||
589: G_current_person_id||'-'||course_cd||'-'||vtac_inco||'.'||
590: G_message_str||'-'||
591: FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADPS_APPL_INST_CREATIN'));
592:

Line 611: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_VALID_PREFERENCES')||' '||

607: END LOOP; --End of while loop
608:
609:
610: IF valid_pref = 'FALSE' THEN
611: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_VALID_PREFERENCES')||' '||
612: G_current_person_id);
613: END IF;
614:
615:

Line 699: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_SEC_QUALIFICATION')

695: SUBSTR(vtac_state_name,1,2) IN ('NT','WA','SA') THEN
696: G_aus_edu := 'TRUE';
697:
698: ELSE
699: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_SEC_QUALIFICATION')
700: ||'-'||G_current_person_id);
701: G_aus_edu := 'FALSE';
702: END IF;
703:

Line 749: FND_FILE.PUT_LINE( FND_FILE.LOG,

745: ase_sequence_number, -- OUT NOCOPY
746: v_message_name) = FALSE
747: THEN
748: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
749: FND_FILE.PUT_LINE( FND_FILE.LOG,
750: G_message_str||' '||G_current_person_id||
751: ' '||vtac_state_name);
752: END IF;
753:

Line 822: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str) ||' '||G_current_person_id

818: NULL,
819: v_message_name) = FALSE
820: THEN
821: G_message_str :=FND_MESSAGE.GET_STRING('IGS',v_message_name);
822: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str) ||' '||G_current_person_id
823: ||' '||vtac_state_name||' '||vtac_subject_code);
824: END IF;
825: ELSE
826: G_message_str := FND_MESSAGE.GET_STRING('IGS','IGS_GE_DUPLICATE_VALUE')||'-'

Line 828: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str) ||'-'||G_current_person_id

824: END IF;
825: ELSE
826: G_message_str := FND_MESSAGE.GET_STRING('IGS','IGS_GE_DUPLICATE_VALUE')||'-'
827: ||IGS_GE_NUMBER.TO_CANN(sub_result_yr) ;
828: FND_FILE.PUT_LINE( FND_FILE.LOG,RTRIM(G_message_str) ||'-'||G_current_person_id
829: ||'-'||vtac_state_name||'-'||vtac_subject_code);
830:
831: END IF; -- End of if c_dup_chk%NOTFOUND
832:

Line 986: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));

982: v_message_name,
983: v_inserted_ind) = FALSE THEN
984:
985: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
986: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));
987: END IF;
988:
989: << po_sec_loop >>
990: k := k + 1;

Line 1083: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));

1079: v_message_name,
1080: v_inserted_ind) = FALSE) THEN
1081:
1082: G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
1083: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));
1084:
1085: END IF;
1086: <>
1087: k := k + 1;