APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on FND_LOG

Line 85: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

81: g_module_name := 'fv.plsql.fv_receivables_activity_pkg.';
82:
83: l_module_name := g_module_name || 'Main';
84:
85: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
86: 'START OF RECEIVABLES ACTIVITY MAIN PROCESS ......');
87:
88: -- Load the parameter global variables
89: vp_sob_id := p_set_of_books_id ;

Line 102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

98: vp_org_id:=mo_global.get_current_org_id; -- Bug 4655467
99: fnd_request.set_org_id(vp_org_id); -- Bug 4655467
100: */
101:
102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
103: l_module_name,' SET OF BOOKS ID IS:'||TO_CHAR(vp_sob_id));
104:
105: -- Deriving the End Date for the period for which Report is being run
106: BEGIN

Line 120: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name

116: vp_errbuf := SQLERRM ||'Parameter Fiscal Year is not defined'
117: || 'for the Set of Books' ;
118: errbuf := vp_errbuf;
119: retcode := vp_retcode;
120: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name
121: ||'Undefined Fiscal Year',VP_ERRBUF) ;
122: RETURN ;
123: END;
124:

Line 143: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name

139: vp_retcode := SQLCODE ;
140: vp_errbuf := SQLERRM ||'Parameter Quarter is not defined.' ;
141: errbuf := vp_errbuf;
142: retcode := vp_retcode;
143: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name
144: ||'Undefined Quarter',VP_ERRBUF) ;
145: RETURN ;
146: END;
147: -- If the report_by is System Date then the SYSDATE is considered as As_of_date

Line 158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

154: ELSE
155: g_as_of_date := TRUNC(vg_end_date);
156: END IF;
157: -- purge the temp table
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
159: 'Purging Temporary Table...') ;
160: DELETE FROM fv_receivables_activity_temp;
161:
162: -- populate temp table for Part I section B and PartII SectionA and SectionB

Line 163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

159: 'Purging Temporary Table...') ;
160: DELETE FROM fv_receivables_activity_temp;
161:
162: -- populate temp table for Part I section B and PartII SectionA and SectionB
163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
164: 'Populating Temp Table with' ||
165: 'Part I Section B, Part II Section A, Section B Values...') ;
166: Populate_IB_IIAB ();
167:

Line 169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

165: 'Part I Section B, Part II Section A, Section B Values...') ;
166: Populate_IB_IIAB ();
167:
168: IF vp_retcode = 0 THEN
169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
170: 'Populating Temp Table with'||
171: 'Part I Section A and Part II Section C Values.....') ;
172: Populate_IA_IIC;
173: END IF;

Line 177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

173: END IF;
174:
175:
176: IF vp_retcode = 0 THEN
177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
178: 'SUBMITTING FUNDS AVAILABILITY REPORTS .....');
179: Submit_Report (p_set_of_books_id,
180: p_reporting_entity_code ,
181: p_fiscal_year ,

Line 211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

207: COMMIT;
208: END IF;
209:
210:
211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
212: 'END THE RECEIVABLES ACTIVITY MAIN PROCESS ......');
213:
214:
215: EXCEPTION

Line 221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

217: vp_retcode := SQLCODE ;
218: vp_errbuf := SQLERRM ||' -- Error in Main procedure' ;
219: errbuf := vp_errbuf;
220: retcode := vp_retcode;
221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
222: l_module_name||'.final_exception',VP_ERRBUF) ;
223: RETURN ;
224: END Main;
225:

Line 983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

979: WHEN OTHERS THEN
980:
981: vp_retcode := SQLCODE;
982: vp_errbuf := SQLERRM;
983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
984: '.final_exception',vp_errbuf) ;
985: RAISE;
986:
987: END Populate_IB_IIAB ;

Line 1742: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

1738: EXCEPTION
1739: WHEN OTHERS THEN
1740: vp_retcode := SQLCODE;
1741: vp_errbuf := SQLERRM;
1742: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1743: '.final_exception',vp_errbuf) ;
1744: RAISE;
1745:
1746: END Populate_IA_IIC ;

Line 1783: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

1779: vp_retcode := SQLCODE ;
1780: vp_errbuf := SQLERRM ||
1781: 'Error in Insert_Row procedure while inserting value for line:' ||
1782: p_line_num ;
1783: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1784: 'Final Exception',vp_errbuf) ;
1785: RETURN ;
1786: END insert_row;
1787: -- ------------------------------------------------------------------

Line 1831: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,vp_errbuf) ;

1827:
1828: IF vl_count = 0 THEN
1829: vp_retcode := 1 ;
1830: vp_errbuf := 'No Data Found ' ;
1831: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,vp_errbuf) ;
1832: RETURN ;
1833: END IF;
1834:
1835: -- MOAC Change

Line 1867: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,vp_errbuf) ;

1863: IF (vl_req_id = 0) THEN
1864: vp_retcode := 2 ;
1865: vp_errbuf := 'Error in Submit_Report procedure,' ||
1866: ' while submitting Receivables Activity Report .' ;
1867: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,vp_errbuf) ;
1868: RETURN ;
1869: END IF;
1870:
1871: EXCEPTION

Line 1875: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||

1871: EXCEPTION
1872: WHEN OTHERS THEN
1873: vp_retcode := SQLCODE ;
1874: vp_errbuf := SQLERRM ||' -- Error in Submit_Report procedure.' ;
1875: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1876: '.final_exception',vp_errbuf) ;
1877: RETURN ;
1878: END Submit_Report;
1879: ---------------------------------------------------------------------