DBA Data[Home] [Help]

APPS.IGS_AD_PG_DATA_LOAD dependencies on FND_MESSAGE

Line 100: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_AD_CAL_DOES_NOT_EXIST');

96: p_adm_cal_type,
97: p_adm_seq_num,
98: 'N') = 'N') THEN
99:
100: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_AD_CAL_DOES_NOT_EXIST');
101: retcode := 2;
102: Return;
103: END IF;
104:

Line 117: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);

113: admission_cd,
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;

Line 205: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);

201:
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

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 320: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_PATH');

316:
317: EXCEPTION
318: WHEN UTL_FILE.INVALID_PATH THEN
319: UTL_FILE.FCLOSE(vtac_pg_filehandle);
320: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_PATH');
321: retcode := 2;
322:
323: WHEN UTL_FILE.INVALID_MODE THEN
324: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 325: ERRBUF:= FND_MESSAGE.GET_STRING('IGS', 'IGS_GE_INVALID_MODE');

321: retcode := 2;
322:
323: WHEN UTL_FILE.INVALID_MODE THEN
324: UTL_FILE.FCLOSE(vtac_pg_filehandle);
325: ERRBUF:= FND_MESSAGE.GET_STRING('IGS', 'IGS_GE_INVALID_MODE');
326: retcode := 2;
327:
328: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
329: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 330: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_FILE_HANDLE');

326: retcode := 2;
327:
328: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
329: UTL_FILE.FCLOSE(vtac_pg_filehandle);
330: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_FILE_HANDLE');
331: retcode := 2;
332:
333: WHEN UTL_FILE.INVALID_OPERATION THEN
334: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 335: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_OPER');

331: retcode := 2;
332:
333: WHEN UTL_FILE.INVALID_OPERATION THEN
334: UTL_FILE.FCLOSE(vtac_pg_filehandle);
335: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_OPER');
336: retcode := 2;
337:
338: WHEN UTL_FILE.READ_ERROR THEN
339: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 340: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_READ_ERR');

336: retcode := 2;
337:
338: WHEN UTL_FILE.READ_ERROR THEN
339: UTL_FILE.FCLOSE(vtac_pg_filehandle);
340: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_READ_ERR');
341: retcode := 2;
342:
343: WHEN UTL_FILE.WRITE_ERROR THEN
344: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 345: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_WRITE_ERR');

341: retcode := 2;
342:
343: WHEN UTL_FILE.WRITE_ERROR THEN
344: UTL_FILE.FCLOSE(vtac_pg_filehandle);
345: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_WRITE_ERR');
346: retcode := 2;
347:
348: WHEN UTL_FILE.INTERNAL_ERROR THEN
349: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 350: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INTERNAL_ERR');

346: retcode := 2;
347:
348: WHEN UTL_FILE.INTERNAL_ERROR THEN
349: UTL_FILE.FCLOSE(vtac_pg_filehandle);
350: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_INTERNAL_ERR');
351: retcode := 2;
352:
353: WHEN NO_DATA_FOUND THEN
354: UTL_FILE.FCLOSE(vtac_pg_filehandle);

Line 360: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

356: retcode := 2;
357:
358: WHEN OTHERS THEN
359: UTL_FILE.FCLOSE(vtac_pg_filehandle);
360: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
361: retcode := 2;
362: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
363: END admp_ins_vtac_pg_off;
364:

Line 422: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);

418: p_vtac_bus_ph,
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:

Line 424: FND_MESSAGE.GET_STRING('IGS','IGS_GE_INVALID_VALUE')||'-'||p_vtac_postcode);

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;
428:

Line 446: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);

442: p_vtac_postcode,
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:

Line 567: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);

563: tac_course_match_ind, -- OUT NOCOPY
564: return_type, -- OUT NOCOPY
565: v_message_name) = FALSE
566: THEN
567: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);
568: G_pg_ret_val := 1;
569: END IF;
570:
571: course_cd := RTRIM(course_cd);

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 583: FND_MESSAGE.GET_STRING('IGS','IGS_AD_CREATE_PENDING_OC_STAT'));

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:
587: ELSE

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 732: G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);

728: NULL, --notes
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: