eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_UTILITY dependencies on FND_LOG

Line 23: l_level := fnd_log.LEVEL_ERROR ;

19: l_level NUMBER ;
20: l_module VARCHAR2(2000) ;
21: BEGIN
22: IF p_level IS NULL THEN
23: l_level := fnd_log.LEVEL_ERROR ;
24: ELSE
25: l_level := p_level;
26: END IF;
27:

Line 35: fnd_log.message (l_level, l_module, p_pop);

31: l_module := p_module;
32: END IF;
33:
34: IF (l_level >= g_current_level) THEN
35: fnd_log.message (l_level, l_module, p_pop);
36: END IF;
37: END;
38:
39: PROCEDURE message

Line 50: l_level := fnd_log.LEVEL_ERROR ;

46: l_module VARCHAR2(2000) ;
47: BEGIN
48:
49: IF p_level IS NULL THEN
50: l_level := fnd_log.LEVEL_ERROR ;
51: ELSE
52: l_level := p_level;
53: END IF;
54:

Line 62: fnd_log.message (l_level, l_module, p_pop);

58: l_module := p_module;
59: END IF;
60:
61: IF (l_level >= g_current_level) THEN
62: fnd_log.message (l_level, l_module, p_pop);
63: END IF;
64: END;
65:
66: PROCEDURE log_mesg

Line 74: fnd_log.string (p_level, p_module, p_message);

70: p_message IN VARCHAR2
71: ) IS
72: BEGIN
73: IF (p_level >= g_current_level) THEN
74: fnd_log.string (p_level, p_module, p_message);
75: END IF;
76: END;
77:
78: PROCEDURE log_mesg

Line 90: l_level := fnd_log.LEVEL_STATEMENT;

86: l_module VARCHAR2(2000) ;
87: BEGIN
88:
89: IF p_level IS NULL THEN
90: l_level := fnd_log.LEVEL_STATEMENT;
91: ELSE
92: l_level := p_level;
93: END IF;
94:

Line 111: IF p_level >= fnd_log.LEVEL_STATEMENT THEN

107: p_module IN VARCHAR2,
108: p_message IN VARCHAR2
109: ) IS
110: BEGIN
111: IF p_level >= fnd_log.LEVEL_STATEMENT THEN
112: fnd_log.string (p_level, p_module, p_message);
113: END IF;
114: END;
115:

Line 112: fnd_log.string (p_level, p_module, p_message);

108: p_message IN VARCHAR2
109: ) IS
110: BEGIN
111: IF p_level >= fnd_log.LEVEL_STATEMENT THEN
112: fnd_log.string (p_level, p_module, p_message);
113: END IF;
114: END;
115:
116:

Line 129: l_level := fnd_log.LEVEL_STATEMENT;

125:
126:
127: BEGIN
128: IF p_level IS NULL THEN
129: l_level := fnd_log.LEVEL_STATEMENT;
130: ELSE
131: l_level := p_level;
132: END IF;
133:

Line 162: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);

158: RETURN (l_time);
159: EXCEPTION
160: WHEN OTHERS THEN
161: l_errbuf := SQLERRM;
162: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
163: RAISE;
164:
165: END;
166:

Line 249: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',error_message);

245: EXCEPTION
246: WHEN no_data_exception THEN
247: error_code := TRUE;
248: error_message := ('No data found for this FV Context Variable '||variable_type);
249: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',error_message);
250:
251: WHEN others THEN
252: error_code := TRUE;
253: error_message := 'Error in retrieving FV Context Variables for '||variable_type||' - '||sqlerrm;

Line 254: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);

250:
251: WHEN others THEN
252: error_code := TRUE;
253: error_message := 'Error in retrieving FV Context Variables for '||variable_type||' - '||sqlerrm;
254: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);
255:
256: END get_context;
257:
258: ---added GET REPORT INFO PROCEDURE

Line 382: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);

378: WHEN OTHERS THEN
379: l_errbuf := SQLERRM;
380: Fnd_Message.Set_Name('FV','FV_DC_GENERAL');
381: FND_MESSAGE.SET_TOKEN('MSG','UNHANDLED EXCEPTION IN GETTING REPORT INFORMATION');
382: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
383: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
384:
385: App_Exception.Raise_Exception;
386:

Line 383: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');

379: l_errbuf := SQLERRM;
380: Fnd_Message.Set_Name('FV','FV_DC_GENERAL');
381: FND_MESSAGE.SET_TOKEN('MSG','UNHANDLED EXCEPTION IN GETTING REPORT INFORMATION');
382: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
383: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
384:
385: App_Exception.Raise_Exception;
386:
387: END GET_REPORT_INFO;

Line 421: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);

417: EXCEPTION
418: when others then
419: error_code := TRUE;
420: error_message := 'Error in FV_UTILTIY.GET_ORG_INFO -'||sqlerrm;
421: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);
422:
423: END get_org_info;
424:
425: Procedure gl_get_first_period(tset_of_books_id IN NUMBER,

Line 463: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',errbuf);

459:
460: errbuf := gl_message.get_message('GL_PLL_INVALID_FIRST_PERIOD', 'Y',
461: 'PERIOD', tperiod_name,
462: 'SOBID', tset_of_books_id);
463: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',errbuf);
464:
465: WHEN OTHERS THEN
466:
467: errbuf := SQLERRM;

Line 468: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

464:
465: WHEN OTHERS THEN
466:
467: errbuf := SQLERRM;
468: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
469:
470: END;
471:
472: -------------------------------------------------------------------------------

Line 522: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);

518: WHEN invalid_acct_segment_error THEN
519: l_errbuf := SQLERRM;
520: error_code := TRUE;
521: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
522: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
524: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
525:
526: WHEN invalid_bal_segment_error THEN

Line 523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');

519: l_errbuf := SQLERRM;
520: error_code := TRUE;
521: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
522: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
524: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
525:
526: WHEN invalid_bal_segment_error THEN
527: l_errbuf := SQLERRM;

Line 530: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);

526: WHEN invalid_bal_segment_error THEN
527: l_errbuf := SQLERRM;
528: error_code := TRUE;
529: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
530: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');
532: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
533:
534: WHEN others THEN

Line 531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');

527: l_errbuf := SQLERRM;
528: error_code := TRUE;
529: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
530: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');
532: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
533:
534: WHEN others THEN
535: l_errbuf := SQLERRM;

Line 538: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception2',l_errbuf);

534: WHEN others THEN
535: l_errbuf := SQLERRM;
536: error_code := TRUE;
537: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
538: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception2',l_errbuf);
539: RAISE_APPLICATION_ERROR(-20003,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: '||l_errbuf);
540:
541: END get_segment_col_names;
542:

Line 584: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);

580: END LOOP;
581: EXCEPTION
582: WHEN OTHERS THEN
583: l_errbuf := SQLERRM;
584: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);
585: END calc_child_flex_value;
586:
587: FUNCTION calc_concat_accts(p_flex_value IN VARCHAR2,
588: p_coa_id IN NUMBER)

Line 636: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);

632:
633: EXCEPTION
634: WHEN OTHERS THEN
635: l_errbuf := SQLERRM;
636: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);
637: RETURN NULL;
638: END calc_concat_accts;
639: ----------------------------------------------------------------------------
640:

Line 661: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found',errbuf);

657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: retcode := 2;
660: errbuf := 'Period Set name not found for set of books '||to_char(sob_id);
661: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found',errbuf);
662: RETURN ;
663: WHEN OTHERS THEN
664: retcode := SQLCODE ;
665: errbuf := SQLERRM ||

Line 667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);

663: WHEN OTHERS THEN
664: retcode := SQLCODE ;
665: errbuf := SQLERRM ||
666: ' -- Error in Get_Period_Year procedure,while getting the period set name.' ;
667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
668: RETURN ;
669: END;
670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);

Line 670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

666: ' -- Error in Get_Period_Year procedure,while getting the period set name.' ;
667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
668: RETURN ;
669: END;
670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);
672: END IF;
673:
674: BEGIN

Line 671: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);

667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
668: RETURN ;
669: END;
670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);
672: END IF;
673:
674: BEGIN
675: SELECT period_year

Line 685: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found1',errbuf);

681: WHEN NO_DATA_FOUND THEN
682: retcode := 2;
683: errbuf := 'Period Year not found for the set of books '||to_char(sob_id) ||
684: ' and the period set name '||vl_period_set_name;
685: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found1',errbuf);
686: RETURN ;
687:
688: WHEN OTHERS THEN
689: retcode := SQLCODE ;

Line 692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);

688: WHEN OTHERS THEN
689: retcode := SQLCODE ;
690: errbuf := SQLERRM ||
691: ' -- Error in Get_Period_Year procedure,while getting the period year.' ;
692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);
693: RETURN ;
694: END;
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));

Line 695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

691: ' -- Error in Get_Period_Year procedure,while getting the period year.' ;
692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);
693: RETURN ;
694: END;
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));
697: END IF;
698:
699: BEGIN /* From Period Start Date */

Line 696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));

692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);
693: RETURN ;
694: END;
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));
697: END IF;
698:
699: BEGIN /* From Period Start Date */
700: SELECT start_date

Line 712: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found2',errbuf);

708: EXCEPTION
709: WHEN NO_DATA_FOUND THEN
710: retcode := 2;
711: errbuf := 'Start Date not defined for the period name '||period_from;
712: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found2',errbuf);
713: RETURN ;
714:
715: WHEN OTHERS THEN
716: retcode := SQLCODE ;

Line 719: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);

715: WHEN OTHERS THEN
716: retcode := SQLCODE ;
717: errbuf := SQLERRM ||
718: ' -- Error in Get_Period_Year procedure,while getting the start date for the from period '||period_from ;
719: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);
720: RETURN ;
721: END; /* From Period Start Date */
722: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
723: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));

Line 722: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

718: ' -- Error in Get_Period_Year procedure,while getting the start date for the from period '||period_from ;
719: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);
720: RETURN ;
721: END; /* From Period Start Date */
722: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
723: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));
724: END IF;
725:
726: BEGIN /* To Period End Date */

Line 723: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));

719: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);
720: RETURN ;
721: END; /* From Period Start Date */
722: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
723: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));
724: END IF;
725:
726: BEGIN /* To Period End Date */
727: SELECT end_date

Line 739: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found3',errbuf);

735: EXCEPTION
736: WHEN NO_DATA_FOUND THEN
737: retcode := 2;
738: errbuf := 'End Date not defined for the period name '||period_to;
739: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found3',errbuf);
740: RETURN ;
741:
742: WHEN OTHERS THEN
743: retcode := SQLCODE ;

Line 746: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);

742: WHEN OTHERS THEN
743: retcode := SQLCODE ;
744: errbuf := SQLERRM ||
745: ' -- Error in Get_Period_Year procedure,while getting the end date for the to period '||period_to ;
746: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);
747: RETURN ;
748: END; /* To Period End Date */
749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));

Line 749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

745: ' -- Error in Get_Period_Year procedure,while getting the end date for the to period '||period_to ;
746: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);
747: RETURN ;
748: END; /* To Period End Date */
749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));
751: END IF;
752:
753: -- Setting up the retcode

Line 750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));

746: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);
747: RETURN ;
748: END; /* To Period End Date */
749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));
751: END IF;
752:
753: -- Setting up the retcode
754: retcode := 0;

Line 759: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

755: EXCEPTION
756: WHEN OTHERS THEN
757: retcode := SQLCODE;
758: errbuf := SQLERRM;
759: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
760: RETURN;
761:
762: END Get_Period_Year;
763:

Line 803: log_mesg(fnd_log.level_unexpected, l_module_name||'.final_exception',l_errbuf);

799: RETURN l_tin;
800: EXCEPTION
801: WHEN OTHERS THEN
802: l_errbuf := SQLERRM;
803: log_mesg(fnd_log.level_unexpected, l_module_name||'.final_exception',l_errbuf);
804: RAISE;
805: END;
806:
807: ---------------------------------------------------------------

Line 832: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');

828:
829:
830: BEGIN
831:
832: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
833: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_type: '||p_wf_item_type);
834: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_key: '||p_wf_item_key);
835:
836: -- get the default accrual_account_ccid from po_system_parameters

Line 833: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_type: '||p_wf_item_type);

829:
830: BEGIN
831:
832: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
833: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_type: '||p_wf_item_type);
834: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_key: '||p_wf_item_key);
835:
836: -- get the default accrual_account_ccid from po_system_parameters
837: BEGIN

Line 834: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_key: '||p_wf_item_key);

830: BEGIN
831:
832: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
833: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_type: '||p_wf_item_type);
834: log_mesg(fnd_log.LEVEL_STATEMENT,l_module,'p_wf_item_key: '||p_wf_item_key);
835:
836: -- get the default accrual_account_ccid from po_system_parameters
837: BEGIN
838:

Line 843: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'l_default_accrual_acct_id: '

839: SELECT accrued_code_combination_id
840: INTO l_default_accrual_acct_id
841: FROM po_system_parameters;
842:
843: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'l_default_accrual_acct_id: '
844: ||l_default_accrual_acct_id);
845:
846: EXCEPTION
847: WHEN NO_DATA_FOUND THEN

Line 848: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'No default accrual account found in po system parameters!');

844: ||l_default_accrual_acct_id);
845:
846: EXCEPTION
847: WHEN NO_DATA_FOUND THEN
848: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'No default accrual account found in po system parameters!');
849: WHEN OTHERS THEN
850: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'When others error: '||sqlerrm);
851: END;
852:

Line 850: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'When others error: '||sqlerrm);

846: EXCEPTION
847: WHEN NO_DATA_FOUND THEN
848: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'No default accrual account found in po system parameters!');
849: WHEN OTHERS THEN
850: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'When others error: '||sqlerrm);
851: END;
852:
853: -- get the charge account ccid from workflow
854: l_charge_account_ccid := wf_engine.GetItemAttrNumber

Line 862: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is null!');

858: aname => 'CODE_COMBINATION_ID'
859: );
860:
861: IF l_charge_account_ccid IS NULL THEN
862: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is null!');
863: RETURN;
864: ELSE
865: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is: '||l_charge_account_ccid);
866: END IF;

Line 865: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is: '||l_charge_account_ccid);

861: IF l_charge_account_ccid IS NULL THEN
862: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is null!');
863: RETURN;
864: ELSE
865: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Charge account ccid is: '||l_charge_account_ccid);
866: END IF;
867:
868:
869: -- get the chard of accounts id from workflow

Line 878: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id is null!');

874: aname => 'CHART_OF_ACCOUNTS_ID'
875: );
876:
877: IF l_chart_of_accounts_id IS NULL THEN
878: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id is null!');
879: RETURN;
880: ELSE
881: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id: '||l_chart_of_accounts_id);
882: END IF;

Line 881: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id: '||l_chart_of_accounts_id);

877: IF l_chart_of_accounts_id IS NULL THEN
878: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id is null!');
879: RETURN;
880: ELSE
881: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Chart of accounts id: '||l_chart_of_accounts_id);
882: END IF;
883:
884: l_result := fnd_flex_apis.get_qualifier_segnum
885: (

Line 893: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Accounting segment number: '||l_account_segment_num);

889: flex_qual_name => 'GL_ACCOUNT',
890: segment_number => l_account_segment_num
891: );
892: IF l_result THEN
893: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Accounting segment number: '||l_account_segment_num);
894: ELSE
895: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get Accounting segment from coa id: '
896: ||l_chart_of_accounts_id);
897: RETURN;

Line 895: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get Accounting segment from coa id: '

891: );
892: IF l_result THEN
893: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Accounting segment number: '||l_account_segment_num);
894: ELSE
895: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get Accounting segment from coa id: '
896: ||l_chart_of_accounts_id);
897: RETURN;
898: END IF;
899:

Line 912: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get segments for po charge ccid: '||l_charge_account_ccid);

908: segments => l_charge_ccid_segs
909: );
910:
911: IF NOT l_result THEN
912: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get segments for po charge ccid: '||l_charge_account_ccid);
913: RETURN;
914: END IF;
915:
916: --Get the segments from the default accrual ccid

Line 928: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get segments for default accrual ccid: '||l_default_accrual_acct_id);

924: segments => l_def_accrual_ccid_segs
925: );
926:
927: IF NOT l_result THEN
928: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not get segments for default accrual ccid: '||l_default_accrual_acct_id);
929: RETURN;
930: END IF;
931:
932: --Set the accounting segment of default accrual to the charge account

Line 933: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Replacing charge account segment with that from default account');

929: RETURN;
930: END IF;
931:
932: --Set the accounting segment of default accrual to the charge account
933: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Replacing charge account segment with that from default account');
934: l_charge_ccid_segs(l_account_segment_num) := l_def_accrual_ccid_segs(l_account_segment_num);
935:
936: -- validate this segment combination and get ccid
937: -- flex API will create combination if it does not exist

Line 950: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'New accrual ccid: '||p_new_accrual_ccid);

946: combination_id => p_new_accrual_ccid
947: );
948:
949: IF l_result THEN
950: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'New accrual ccid: '||p_new_accrual_ccid);
951: ELSE
952: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not create new default charge account!');
953: RETURN;
954: END IF;

Line 952: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not create new default charge account!');

948:
949: IF l_result THEN
950: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'New accrual ccid: '||p_new_accrual_ccid);
951: ELSE
952: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not create new default charge account!');
953: RETURN;
954: END IF;
955:
956: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');

Line 956: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');

952: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Could not create new default charge account!');
953: RETURN;
954: END IF;
955:
956: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');
957: EXCEPTION WHEN OTHERS THEN
958: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);
959: END get_accrual_account;
960:

Line 958: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);

954: END IF;
955:
956: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');
957: EXCEPTION WHEN OTHERS THEN
958: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);
959: END get_accrual_account;
960:
961: ---------------------------------------------------------------
962: /*-------------------------------------------------------------

Line 1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');

1003: AND xla.application_id = xte.application_id
1004: AND xte.ledger_id = p_ledger_id;
1005:
1006: BEGIN
1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');
1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);
1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);
1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);

Line 1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');

1004: AND xte.ledger_id = p_ledger_id;
1005:
1006: BEGIN
1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');
1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);
1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);
1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);
1012:

Line 1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);

1005:
1006: BEGIN
1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');
1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);
1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);
1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);
1012:
1013: xla_security_pkg.set_security_context(8901);

Line 1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);

1006: BEGIN
1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');
1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);
1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);
1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);
1012:
1013: xla_security_pkg.set_security_context(8901);
1014:

Line 1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);

1007: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'BEGIN');
1008: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Parameters: ');
1009: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_ledger_id: '||p_ledger_id);
1010: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_start_date: '||p_start_date);
1011: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'p_end_date: '||p_end_date);
1012:
1013: xla_security_pkg.set_security_context(8901);
1014:
1015: DELETE FROM XLA_EVENTS_INT_GT;

Line 1016: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,

1012:
1013: xla_security_pkg.set_security_context(8901);
1014:
1015: DELETE FROM XLA_EVENTS_INT_GT;
1016: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,
1017: '# of rows deleted from xla_events_int_gt: '|| SQL%ROWCOUNT );
1018: fnd_file.put_line(fnd_file.log,
1019: '-------------------------------------------------------');
1020: fnd_file.put_line(fnd_file.log,'Deleting Federal events, if any.');

Line 1063: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,

1059:
1060: --Update the event id of the BE row to null if the row exists.
1061: --If the row does not exist, it means that the user has deleted it from
1062: --the form.
1063: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,
1064: 'Updating event id: '||l_events_tab(i).event_id||' to NULL for related distributions.');
1065: UPDATE fv_be_trx_dtls
1066: SET event_id = NULL
1067: WHERE event_id = l_events_tab(i).event_id;

Line 1069: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,

1065: UPDATE fv_be_trx_dtls
1066: SET event_id = NULL
1067: WHERE event_id = l_events_tab(i).event_id;
1068:
1069: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,
1070: '# distributions in fv_be_trx_dtls that have been updated to NULL: '||SQL%ROWCOUNT);
1071:
1072: END LOOP;
1073:

Line 1079: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');

1075: fnd_file.put_line(fnd_file.log,'**** No Federal events found to delete ****');
1076: END IF;
1077: p_status := 'S';
1078:
1079: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');
1080: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
1081: EXCEPTION WHEN OTHERS THEN
1082: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);
1083: p_status := 'E';

Line 1082: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);

1078:
1079: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'END');
1080: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
1081: EXCEPTION WHEN OTHERS THEN
1082: log_mesg(fnd_log.LEVEL_UNEXPECTED, l_module, 'When others error: '||SQLERRM);
1083: p_status := 'E';
1084: END delete_fv_bc_orphan;
1085: ----------------------------------------------------------------------------------------
1086: PROCEDURE fv_cleanup_xla_gt IS

Line 1092: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Begin - Cleaning up xla GT Tables');

1088: l_module VARCHAR2(200) := g_module_name||'fv_cleanup_xla_gt.';
1089:
1090: BEGIN
1091:
1092: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Begin - Cleaning up xla GT Tables');
1093: DELETE FROM XLA_AE_HEADERS_GT;
1094: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '1 XLA_AE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1095: DELETE FROM XLA_AE_LINES_GT;
1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1094: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '1 XLA_AE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1090: BEGIN
1091:
1092: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Begin - Cleaning up xla GT Tables');
1093: DELETE FROM XLA_AE_HEADERS_GT;
1094: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '1 XLA_AE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1095: DELETE FROM XLA_AE_LINES_GT;
1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_VALIDATION_HDRS_GT;
1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1092: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, 'Begin - Cleaning up xla GT Tables');
1093: DELETE FROM XLA_AE_HEADERS_GT;
1094: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '1 XLA_AE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1095: DELETE FROM XLA_AE_LINES_GT;
1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_VALIDATION_HDRS_GT;
1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1099: DELETE FROM XLA_VALIDATION_LINES_GT;
1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1094: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '1 XLA_AE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1095: DELETE FROM XLA_AE_LINES_GT;
1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_VALIDATION_HDRS_GT;
1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1099: DELETE FROM XLA_VALIDATION_LINES_GT;
1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1101: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1096: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '2 XLA_AE_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1097: DELETE FROM XLA_VALIDATION_HDRS_GT;
1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1099: DELETE FROM XLA_VALIDATION_LINES_GT;
1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1101: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1098: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '3 XLA_VALIDATION_HDRS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1099: DELETE FROM XLA_VALIDATION_LINES_GT;
1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1101: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1105: DELETE FROM XLA_BAL_RECREATE_GT;
1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1100: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '4 XLA_VALIDATION_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1101: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1105: DELETE FROM XLA_BAL_RECREATE_GT;
1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1107: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);

1102: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '5 XLA_BAL_CTRL_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1105: DELETE FROM XLA_BAL_RECREATE_GT;
1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1107: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1104: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '6 XLA_BAL_PERIOD_STATS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1105: DELETE FROM XLA_BAL_RECREATE_GT;
1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1107: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1111: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1106: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '7 XLA_BAL_RECREATE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1107: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1111: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1113: DELETE FROM XLA_BAL_STATUSES_GT;
1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);

1108: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '8 XLA_BAL_ANACRI_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1109: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1111: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1113: DELETE FROM XLA_BAL_STATUSES_GT;
1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1110: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '9 XLA_BAL_ANACRI_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1111: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1113: DELETE FROM XLA_BAL_STATUSES_GT;
1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1112: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '10 XLA_BAL_SYNCHRONIZE_GT: Deleted Row count :'||SQL%ROWCOUNT);
1113: DELETE FROM XLA_BAL_STATUSES_GT;
1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1114: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '11 XLA_BAL_STATUSES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1115: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1116: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '12 XLA_BAL_CTRL_LINES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1117: DELETE FROM XLA_EVENTS_GT;
1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1123: DELETE FROM XLA_TAB_ERRORS_GT;
1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1118: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1119: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1123: DELETE FROM XLA_TAB_ERRORS_GT;
1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1125: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1120: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1121: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1123: DELETE FROM XLA_TAB_ERRORS_GT;
1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1125: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1122: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '15 XLA_EVT_CLASS_ORDERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1123: DELETE FROM XLA_TAB_ERRORS_GT;
1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1125: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1129: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1124: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '16 XLA_TAB_ERRORS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1125: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1129: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1131: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1126: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '17 XLA_SEQ_JE_HEADERS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1127: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1129: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1131: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1128: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '18 XLA_TAB_NEW_CCIDS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1129: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1131: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1135: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1130: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '19 XLA_EXTRACT_OBJECTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1131: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1135: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1137: DELETE FROM XLA_TRIAL_BALANCES_GT;
1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);

1132: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1133: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1135: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1137: DELETE FROM XLA_TRIAL_BALANCES_GT;
1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1134: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1135: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1137: DELETE FROM XLA_TRIAL_BALANCES_GT;
1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1141: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1136: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1137: DELETE FROM XLA_TRIAL_BALANCES_GT;
1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1141: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1138: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1139: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1141: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1140: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '24 XLA_ACCT_PROG_EVENTS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1141: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);

1142: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '25 XLA_ACCT_PROG_DOCS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1143: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1144: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '26 XLA_MERGE_SEG_MAPS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1145: DELETE FROM XLA_EVENTS_INT_GT;
1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1152: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '30 XLA_BAL_AC_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

Line 1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);

1146: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '27 XLA_EVENTS_INT_GT: Deleted Row count :'||SQL%ROWCOUNT);
1147: DELETE FROM XLA_REPORT_BALANCES_GT;
1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1152: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '30 XLA_BAL_AC_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1153: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,'End - Cleaning up xla GT Tables');
1154:

Line 1152: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '30 XLA_BAL_AC_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);

1148: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '28 XLA_REPORT_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1152: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '30 XLA_BAL_AC_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1153: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,'End - Cleaning up xla GT Tables');
1154:
1155: END fv_cleanup_xla_gt;
1156:

Line 1153: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,'End - Cleaning up xla GT Tables');

1149: DELETE FROM XLA_TB_BALANCES_GT;
1150: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '29 XLA_TB_BALANCES_GT: Deleted Row count :'||SQL%ROWCOUNT);
1151: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1152: log_mesg(fnd_log.LEVEL_STATEMENT, l_module, '30 XLA_BAL_AC_CTRBS_GT: Deleted Row count :'||SQL%ROWCOUNT);
1153: log_mesg(fnd_log.LEVEL_STATEMENT, l_module,'End - Cleaning up xla GT Tables');
1154:
1155: END fv_cleanup_xla_gt;
1156:
1157: ----------------------------------------------------------------------------------------

Line 1191: g_current_level := fnd_log.g_current_runtime_level;

1187:
1188:
1189: BEGIN
1190: g_module_name := 'FV_UTILITY.';
1191: g_current_level := fnd_log.g_current_runtime_level;
1192:
1193: END; -- package body