DBA Data[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on FND_FILE

Line 70: Fnd_File.Put_Line(Fnd_File.Log, p_message);

66: Who When What
67: ***************************************************************** */
68: BEGIN
69:
70: Fnd_File.Put_Line(Fnd_File.Log, p_message);
71:
72: END write_to_log;
73:
74:

Line 177: fnd_file.put_line(fnd_file.Log, fnd_message.get);

173: BEGIN
174: -- log message that this view is being loaded
175: fnd_message.set_name('IGS','IGS_UC_VW_PROCESSING' );
176: fnd_message.set_token('VIEW_NAME', p_view_name ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
177: fnd_file.put_line(fnd_file.Log, fnd_message.get);
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: ROLLBACK;

Line 204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;

200: BEGIN
201: -- log message that this view has been succesfully loaded
202: fnd_message.set_name('IGS','IGS_UC_VW_SYNC_COMPLETE' );
203: fnd_message.set_token('VIEW_NAME', p_view_name );
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );

Line 209: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;

205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );
209: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
210:
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 237: fnd_file.put_line(fnd_file.Log, fnd_message.get) ;

233: BEGIN
234: -- log message that this view has been succesfully loaded
235: fnd_message.set_name('IGS','IGS_UC_VW_ALREADY_IN_SYNC' );
236: fnd_message.set_token('VIEW_NAME', p_view_name );
237: fnd_file.put_line(fnd_file.Log, fnd_message.get) ;
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: ROLLBACK;

Line 325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;

321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
326:
327: return_value := FALSE;
328: END;
329:

Line 12071: fnd_file.put_line(fnd_file.log, errbuf);

12067: CLOSE c_cyc_info ;
12068: IF g_cyc_info_rec.configured_cycle IS NULL OR g_cyc_info_rec.current_cycle IS NULL THEN
12069: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
12070: errbuf := fnd_message.get;
12071: fnd_file.put_line(fnd_file.log, errbuf);
12072: retcode := 2 ;
12073: RETURN ;
12074: END IF;
12075:

Line 12089: fnd_file.put_line(fnd_file.log,errbuf );

12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12089: fnd_file.put_line(fnd_file.log,errbuf );
12090: validate_cycle := FALSE;
12091: END IF ;
12092: END IF;
12093:

Line 12107: fnd_file.put_line(fnd_file.log,errbuf );

12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12107: fnd_file.put_line(fnd_file.log,errbuf );
12108: validate_cycle := FALSE;
12109: END IF ;
12110: END IF;
12111:

Line 12125: fnd_file.put_line(fnd_file.log,errbuf );

12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12125: fnd_file.put_line(fnd_file.log,errbuf );
12126: validate_cycle := FALSE;
12127: END IF ;
12128: END IF;
12129:

Line 12145: fnd_file.put_line(fnd_file.log, errbuf);

12141: IF c_refamend_timestamp%NOTFOUND THEN
12142: CLOSE c_refamend_timestamp ;
12143: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12144: errbuf := fnd_message.get;
12145: fnd_file.put_line(fnd_file.log, errbuf);
12146: retcode := 2 ;
12147: RETURN ;
12148: ELSE
12149: CLOSE c_refamend_timestamp ;

Line 12158: fnd_file.put_line(fnd_file.log, errbuf);

12154: IF c_refamend_timestamp_2007%NOTFOUND THEN
12155: CLOSE c_refamend_timestamp_2007 ;
12156: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12157: errbuf := fnd_message.get;
12158: fnd_file.put_line(fnd_file.log, errbuf);
12159: retcode := 2 ;
12160: RETURN ;
12161: ELSE
12162: CLOSE c_refamend_timestamp_2007 ;

Line 12181: fnd_file.put_line(fnd_file.log, errbuf);

12177: CLOSE c_grefamend_timestamp ;
12178: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12179: fnd_message.set_token('VIEW_NAME','CvGRefAmendments');
12180: errbuf := fnd_message.get;
12181: fnd_file.put_line(fnd_file.log, errbuf);
12182: retcode := 2 ;
12183: RETURN ;
12184: ELSE
12185: CLOSE c_grefamend_timestamp ;

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

12492: -- UCAS interface is MARVIN so log warning.
12493: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12494: fnd_message.set_token('SYSTEM_CODE','UCAS');
12495: fnd_message.set_token('PROCESS','load');
12496: fnd_file.put_line(fnd_file.log,fnd_message.get );
12497: retcode := 1;
12498:
12499: END IF;
12500:

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

12547: -- GTTR interface is MARVIN so log warning.
12548: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12549: fnd_message.set_token('SYSTEM_CODE','GTTR');
12550: fnd_message.set_token('PROCESS','load');
12551: fnd_file.put_line(fnd_file.log,fnd_message.get );
12552: retcode := 1;
12553:
12554: END IF;
12555:

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

12602: -- NMAS interface is MARVIN so log warning.
12603: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12604: fnd_message.set_token('SYSTEM_CODE','NMAS');
12605: fnd_message.set_token('PROCESS','load');
12606: fnd_file.put_line(fnd_file.log,fnd_message.get );
12607: retcode := 1;
12608:
12609: END IF;
12610: