DBA Data[Home] [Help]

APPS.IGS_AD_PG_DATA_LOAD dependencies on FND_FILE

Line 118: FND_FILE.PUT_LINE( FND_FILE.LOG,vtac_id_num||'.'||RTRIM(G_pg_message_str));

114: basis_for_admission_type,
115: v_message_name) = FALSE) THEN
116:
117: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);
118: FND_FILE.PUT_LINE( FND_FILE.LOG,vtac_id_num||'.'||RTRIM(G_pg_message_str));
119: ROLLBACK;
120: RETCODE := 2;
121: RETURN;
122: END IF;

Line 185: FND_FILE.PUT_LINE( FND_FILE.LOG,

181: vtac_prev_gname2 := RTRIM(SUBSTR(G_vtac_pg_output_buffer,213,17));
182: vtac_residency := RTRIM(SUBSTR(G_vtac_pg_output_buffer,274,1));
183:
184: -- Log the student loaded
185: FND_FILE.PUT_LINE( FND_FILE.LOG,
186: G_pg_read_number||'-'||vtac_id_num||' '||vtac_surname||' '||vtac_DateOfBirth);
187:
188: -- Check to see if the person already exists on Callista.
189: -- Match on surname, birth date, sex and first initial of first name.

Line 206: FND_FILE.PUT_LINE( FND_FILE.LOG,vtac_id_num||'.'||RTRIM(G_pg_message_str));

202: IF (v_message_name IS NOT NULL) THEN
203:
204: -- vtac_DateOfBirth has wrong date format
205: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
206: FND_FILE.PUT_LINE( FND_FILE.LOG,vtac_id_num||'.'||RTRIM(G_pg_message_str));
207: END IF;
208:
209: IF G_pg_match_person_id = 0 THEN
210: OPEN c_api (vtac_id_num,

Line 245: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_pg_message_str));

241: G_pg_new_person_id, -- OUT NOCOPY
242: G_pg_message_str) = FALSE
243: THEN
244: ROLLBACK;
245: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_pg_message_str));
246: UTL_FILE.FCLOSE(vtac_pg_filehandle);
247: retcode := 2;
248: return;
249: END IF;

Line 254: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_pg_message_str));

250:
251:
252:
253: --Log the creating record message
254: FND_FILE.PUT_LINE( FND_FILE.LOG, RTRIM(G_pg_message_str));
255:
256:
257:
258: --Save the ID number we have used so far into a new variable. We can then use this

Line 297: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||

293: admp_vtac_pg_load_tert_edu;
294:
295: ELSE
296: IF G_pg_match_person_id = 0 THEN
297: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||
298: ' '||IGS_GE_GEN_004.GENP_GET_LOOKUP('REPORT','REJTD'));
299: END IF;
300:
301: END IF;

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

309: ELSE
310: COMMIT;
311: END IF;
312:
313: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NUM_OF_RECORD_READ')||' - '||G_pg_read_number);
314:
315: UTL_FILE.FCLOSE(vtac_pg_filehandle);
316:
317: EXCEPTION

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG,

419: v_message_name) = FALSE THEN
420:
421:
422: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
423: FND_FILE.PUT_LINE(FND_FILE.LOG,
424: FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_VALUE')||'-'||p_vtac_postcode);
425: FND_FILE.PUT_LINE( FND_FILE.LOG, G_pg_current_person_id||' '||RTRIM(G_pg_message_str));
426:
427: END IF;

Line 425: FND_FILE.PUT_LINE( FND_FILE.LOG, G_pg_current_person_id||' '||RTRIM(G_pg_message_str));

421:
422: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
423: FND_FILE.PUT_LINE(FND_FILE.LOG,
424: FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_VALUE')||'-'||p_vtac_postcode);
425: FND_FILE.PUT_LINE( FND_FILE.LOG, G_pg_current_person_id||' '||RTRIM(G_pg_message_str));
426:
427: END IF;
428:
429: ELSE

Line 447: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||' '||RTRIM(G_pg_message_str));

443: p_vtac_home_ph,
444: p_vtac_bus_ph,
445: v_message_name) = FALSE THEN
446: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
447: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||' '||RTRIM(G_pg_message_str));
448:
449: END IF;
450:
451:

Line 582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_WARNING_APPLICANT')||' '|| G_pg_current_person_id||'-'||course_cd||'-'||G_pg_message_str||'-'||

578: G_pg_message_str := RTRIM(G_pg_message_str);
579:
580: IF return_type = 'W' THEN
581:
582: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_WARNING_APPLICANT')||' '|| G_pg_current_person_id||'-'||course_cd||'-'||G_pg_message_str||'-'||
583: FND_MESSAGE.GET_STRING('IGS','IGS_AD_CREATE_PENDING_OC_STAT'));
584:
585: valid_pref := 'TRUE';
586:

Line 598: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_ERR_APPLICANT')||' '|| G_pg_current_person_id||' '||course_cd||'-'||G_pg_message_str);

594: END IF;
595:
596:
597: --There must have been an error inserting
598: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_ERR_APPLICANT')||' '|| G_pg_current_person_id||' '||course_cd||'-'||G_pg_message_str);
599:
600: RETURN FALSE;
601:
602: ROLLBACK;

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

615: END LOOP; -- End of while loop
616:
617:
618: IF valid_pref = 'FALSE' THEN
619: FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_NO_VALID_PREFERENCES')||' '||
620: G_pg_current_person_id);
621: END IF;
622:
623:

Line 733: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||'-'||RTRIM(G_pg_message_str));

729: v_message_name,
730: v_inserted_ind) = FALSE THEN
731:
732: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
733: FND_FILE.PUT_LINE( FND_FILE.LOG,G_pg_current_person_id||'-'||RTRIM(G_pg_message_str));
734:
735: END IF;
736:
737: