DBA Data[Home] [Help]

APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on FND_MESSAGE

Line 220: fnd_message.set_Name('FV', 'Deriving Treasury Symbol...') ;

216: v_pagebreak3_high := p_pagebreak3_high ;
217:
218:
219: -- Get the Treasury Symbol Id for the passed Treasury Symbol
220: fnd_message.set_Name('FV', 'Deriving Treasury Symbol...') ;
221:
222: Begin --TS
223:
224: Select Treasury_Symbol_id

Line 244: fnd_message.set_Name('FV', 'Purging FACTS Temp....') ;

240:
241:
242: If vp_retcode = 0 Then
243: -- fv_utility.debug_mesg('PURGING TEMP TABLE');
244: fnd_message.set_Name('FV', 'Purging FACTS Temp....') ;
245: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
246: PURGE_FACTS_TRANSACTIONS ;
247: End If ;
248:

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

241:
242: If vp_retcode = 0 Then
243: -- fv_utility.debug_mesg('PURGING TEMP TABLE');
244: fnd_message.set_Name('FV', 'Purging FACTS Temp....') ;
245: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
246: PURGE_FACTS_TRANSACTIONS ;
247: End If ;
248:
249: If vp_retcode = 0 Then

Line 251: fnd_message.set_Name('FV', 'Deriving Qualifier Seg....') ;

247: End If ;
248:
249: If vp_retcode = 0 Then
250: -- fv_utility.debug_mesg('DERVING QUALIFIER');
251: fnd_message.set_Name('FV', 'Deriving Qualifier Seg....') ;
252: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
253: GET_QUALIFIER_SEGMENTS ;
254: End If ;
255:

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

248:
249: If vp_retcode = 0 Then
250: -- fv_utility.debug_mesg('DERVING QUALIFIER');
251: fnd_message.set_Name('FV', 'Deriving Qualifier Seg....') ;
252: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
253: GET_QUALIFIER_SEGMENTS ;
254: End If ;
255:
256: If vp_retcode = 0 Then

Line 258: fnd_message.set_Name('FV','Deriving Treasury Sym Info');

254: End If ;
255:
256: If vp_retcode = 0 Then
257: -- fv_utility.debug_mesg('GET COHORT INFO');
258: fnd_message.set_Name('FV','Deriving Treasury Sym Info');
259: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
260: GET_COHORT_INFO ;
261: End If ;
262:

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

255:
256: If vp_retcode = 0 Then
257: -- fv_utility.debug_mesg('GET COHORT INFO');
258: fnd_message.set_Name('FV','Deriving Treasury Sym Info');
259: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
260: GET_COHORT_INFO ;
261: End If ;
262:
263:

Line 266: fnd_message.set_Name('FV', 'Deriving Period Info') ;

262:
263:
264: If vp_retcode = 0 Then
265: -- fv_utility.debug_mesg('GET PERIOD INFO');
266: fnd_message.set_Name('FV', 'Deriving Period Info') ;
267: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
268: GET_PERIOD_INFO ;
269: End If ;
270:

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

263:
264: If vp_retcode = 0 Then
265: -- fv_utility.debug_mesg('GET PERIOD INFO');
266: fnd_message.set_Name('FV', 'Deriving Period Info') ;
267: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
268: GET_PERIOD_INFO ;
269: End If ;
270:
271: If vp_retcode = 0 Then

Line 273: fnd_message.set_Name('FV', 'FACTS Main Process.....') ;

269: End If ;
270:
271: If vp_retcode = 0 Then
272: -- fv_utility.debug_mesg('START MAIN PROCESS');
273: fnd_message.set_Name('FV', 'FACTS Main Process.....') ;
274: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
275: PROCESS_TBAL_TRANSACTIONS ;
276: COMMIT;
277: Else

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

270:
271: If vp_retcode = 0 Then
272: -- fv_utility.debug_mesg('START MAIN PROCESS');
273: fnd_message.set_Name('FV', 'FACTS Main Process.....') ;
274: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
275: PROCESS_TBAL_TRANSACTIONS ;
276: COMMIT;
277: Else
278: ROLLBACK;

Line 667: fnd_message.set_Name('FV', 'Selecting FACTS Trans...') ;

663: vl_seg_value_set_name);
664: END IF;
665:
666:
667: fnd_message.set_Name('FV', 'Selecting FACTS Trans...') ;
668: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
669: -- fv_utility.debug_mesg('**** START MAIN PROCESS ****');
670:
671: Begin

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

664: END IF;
665:
666:
667: fnd_message.set_Name('FV', 'Selecting FACTS Trans...') ;
668: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
669: -- fv_utility.debug_mesg('**** START MAIN PROCESS ****');
670:
671: Begin
672: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;

Line 761: fnd_message.set_Name('FV', 'Processing starts.') ;

757: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN MAIN CURSOR EXECUTE:'||SQLERRM);
758: Return ;
759: End ;
760:
761: fnd_message.set_Name('FV', 'Processing starts.') ;
762: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
763:
764: LOOP --Main Select Loop
765:

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

758: Return ;
759: End ;
760:
761: fnd_message.set_Name('FV', 'Processing starts.') ;
762: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
763:
764: LOOP --Main Select Loop
765:
766: -- Reset the Cursor Variable