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_FACTS1_GL_PKG dependencies on FV_UTILITY

Line 92: FV_UTILITY.LOG_MESG('In '||l_module_name);

88:
89: BEGIN
90:
91: l_module_name := g_module_name || 'MAIN';
92: FV_UTILITY.LOG_MESG('In '||l_module_name);
93:
94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);

Line 94: FV_UTILITY.LOG_MESG('Parameters:');

90:
91: l_module_name := g_module_name || 'MAIN';
92: FV_UTILITY.LOG_MESG('In '||l_module_name);
93:
94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);

Line 95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);

91: l_module_name := g_module_name || 'MAIN';
92: FV_UTILITY.LOG_MESG('In '||l_module_name);
93:
94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
99:

Line 96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);

92: FV_UTILITY.LOG_MESG('In '||l_module_name);
93:
94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
99:
100: gbl_trading_partner_att := upper(p_trading_partner_att);

Line 97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);

93:
94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
99:
100: gbl_trading_partner_att := upper(p_trading_partner_att);
101:

Line 98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);

94: FV_UTILITY.LOG_MESG('Parameters:');
95: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
96: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
97: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
98: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
99:
100: gbl_trading_partner_att := upper(p_trading_partner_att);
101:
102: gbl_called_from_main := p_called_from_main;

Line 179: FV_UTILITY.LOG_MESG('Facts I Journal Process completed successfully.');

175: END IF;
176:
177: COMMIT;
178:
179: FV_UTILITY.LOG_MESG('Facts I Journal Process completed successfully.');
180:
181: EXCEPTION WHEN OTHERS THEN
182: p_err_code := SQLCODE;
183: p_err_buff := 'When others exception in Main - '||SQLERRM;

Line 185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

181: EXCEPTION WHEN OTHERS THEN
182: p_err_code := SQLCODE;
183: p_err_buff := 'When others exception in Main - '||SQLERRM;
184: ROLLBACK;
185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
186:
187: END main;
188: --------------------------------------------------------------------------------
189: PROCEDURE CLEANUP

Line 197: FV_UTILITY.LOG_MESG('In '||l_module_name);

193:
194: BEGIN
195:
196: l_module_name := g_module_name || 'CLEANUP';
197: FV_UTILITY.LOG_MESG('In '||l_module_name);
198:
199: DELETE FROM fv_facts_report_t2
200: WHERE set_of_books_id = gbl_sob_id;
201:

Line 205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

201:
202: EXCEPTION WHEN OTHERS THEN
203: gbl_err_code := SQLCODE;
204: gbl_err_buff := l_module_name||' - When others exception - '||SQLERRM;
205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
206:
207: END CLEANUP;
208:
209: --------------------------------------------------------------------------------

Line 225: FV_UTILITY.LOG_MESG('In '||l_module_name);

221:
222: BEGIN
223:
224: l_module_name := g_module_name || 'GET_SEGMENT_NAMES';
225: FV_UTILITY.LOG_MESG('In '||l_module_name);
226:
227:
228: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
229:

Line 228: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);

224: l_module_name := g_module_name || 'GET_SEGMENT_NAMES';
225: FV_UTILITY.LOG_MESG('In '||l_module_name);
226:
227:
228: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
229:
230: -- Get Balancing Segment Name
231: -----------------------------
232: l_segment_found := FND_FLEX_APIS.get_segment_column

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

256: gbl_acc_segment IS NULL) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;
259:
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
261: 'Balancing Segment: '||gbl_bal_segment);
262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
263: 'Accounting Segment: '||gbl_acc_segment);
264:

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

258: END IF;
259:
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
261: 'Balancing Segment: '||gbl_bal_segment);
262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
263: 'Accounting Segment: '||gbl_acc_segment);
264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN

Line 269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: gbl_err_code := -1 ;
268: gbl_err_buff := 'Balancing or Accounting segment not found.';
269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
270: WHEN invalid_bal_segment THEN
271: gbl_err_code := -1 ;
272: gbl_err_buff := 'Error while fetching balancing segment.';
273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
270: WHEN invalid_bal_segment THEN
271: gbl_err_code := -1 ;
272: gbl_err_buff := 'Error while fetching balancing segment.';
273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
274: WHEN invalid_acc_segment THEN
275: gbl_err_code := -1 ;
276: gbl_err_buff := 'Error while fetching accounting segment.';
277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

273: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
274: WHEN invalid_acc_segment THEN
275: gbl_err_code := -1 ;
276: gbl_err_buff := 'Error while fetching accounting segment.';
277: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
278: WHEN OTHERS THEN
279: gbl_err_code := -1 ;
280: gbl_err_buff := 'When others error while getting
281: Balancing or Accounting segment - '||SQLERRM;

Line 282: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

278: WHEN OTHERS THEN
279: gbl_err_code := -1 ;
280: gbl_err_buff := 'When others error while getting
281: Balancing or Accounting segment - '||SQLERRM;
282: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
283: END get_segment_names;
284: --------------------------------------------------------------------------------
285: -- Get the period num for the parameter period and also the first period num
286: -- for the year.

Line 297: FV_UTILITY.LOG_MESG('In '||l_module_name);

293:
294: BEGIN
295:
296: l_module_name := g_module_name || 'GET_PROCESS_DATES';
297: FV_UTILITY.LOG_MESG('In '||l_module_name);
298:
299: -- Get the period year for the period parameter passed.
300: l_temp_mesg := 'getting period year.';
301: SELECT period_year

Line 335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

331: gbl_period_num_high = 0) THEN
332: gbl_err_code := 2 ;
333: gbl_err_buff := l_module_name||' Period number '||
334: 'found zero for the passed fiscal year.' ;
335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
336: RETURN;
337: END IF;
338:
339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);

Line 339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);

335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
336: RETURN;
337: END IF;
338:
339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
340: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
341: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
342:
343: EXCEPTION

Line 340: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);

336: RETURN;
337: END IF;
338:
339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
340: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
341: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
342:
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN

Line 341: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);

337: END IF;
338:
339: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
340: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
341: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
342:
343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: gbl_err_code := 2;

Line 347: FV_UTILITY.LOG_MESG(gbl_err_buff);

343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: gbl_err_code := 2;
346: gbl_err_buff := l_module_name||' - No data found when '||l_temp_mesg;
347: FV_UTILITY.LOG_MESG(gbl_err_buff);
348:
349: WHEN OTHERS THEN
350: gbl_err_code := 2;
351: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg;

Line 352: FV_UTILITY.LOG_MESG(gbl_err_buff);

348:
349: WHEN OTHERS THEN
350: gbl_err_code := 2;
351: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg;
352: FV_UTILITY.LOG_MESG(gbl_err_buff);
353: END get_process_dates;
354: --------------------------------------------------------------------------------
355: -- Get Facts I Journal, Vendor and Customer attributes
356: --------------------------------------------------------------------------------

Line 365: FV_UTILITY.LOG_MESG('In '||l_module_name);

361: l_temp_mesg VARCHAR2(50);
362: BEGIN
363:
364: l_module_name := g_module_name || 'GET_SYSTEM_ATTRIBUTES';
365: FV_UTILITY.LOG_MESG('In '||l_module_name);
366:
367: l_temp_mesg := 'getting Journal Attribute.';
368: SELECT factsI_journal_attribute
369: INTO gbl_jrnl_attribute

Line 390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);

386: FROM gl_ledgers_public_v
387: WHERE ledger_id = gbl_sob_id;
388:
389:
390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);

Line 391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);

387: WHERE ledger_id = gbl_sob_id;
388:
389:
390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
395:

Line 392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);

388:
389:
390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
395:
396: EXCEPTION

Line 393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);

389:
390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
395:
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN

Line 394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);

390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
391: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
392: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
393: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
394: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
395:
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN
398: gbl_err_code := 2;

Line 401: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);

397: WHEN NO_DATA_FOUND THEN
398: gbl_err_code := 2;
399: gbl_err_buff := l_module_name||' - Null values/No data found when '||
400: l_temp_mesg;
401: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);
402:
403: WHEN OTHERS THEN
404: gbl_err_code := SQLCODE;
405: gbl_err_buff := l_module_name||' - When others error '||l_temp_mesg||

Line 407: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);

403: WHEN OTHERS THEN
404: gbl_err_code := SQLCODE;
405: gbl_err_buff := l_module_name||' - When others error '||l_temp_mesg||
406: ' - '||SQLERRM;
407: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);
408:
409: END get_system_attributes;
410: --------------------------------------------------------------------------------
411: PROCEDURE log(module IN VARCHAR2,

Line 418: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

414: l_module_name VARCHAR2(1000);
415: BEGIN
416:
417: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
419: module, message_line);
420:
421: END IF;
422:

Line 425: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);

421: END IF;
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
426: END log;
427: --------------------------------------------------------------------------------
428: -- Select all journal lines from gl_je_lines from the beginning of the year upto
429: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and

Line 534: FV_UTILITY.LOG_MESG('In '||l_module_name);

530:
531: BEGIN
532:
533: l_module_name := g_module_name || 'PROCESS_GL_LINES';
534: FV_UTILITY.LOG_MESG('In '||l_module_name);
535:
536:
537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
538:

Line 537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');

533: l_module_name := g_module_name || 'PROCESS_GL_LINES';
534: FV_UTILITY.LOG_MESG('In '||l_module_name);
535:
536:
537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
538:
539: if gbl_called_from_main = 'N' then
540:
541: INSERT INTO fv_facts1_header_id_gt(je_header_id,set_of_books_id)

Line 560: FV_UTILITY.LOG_MESG('Inserted ' || SQL%ROWCOUNT);

556: where e.set_of_books_id = gjh.ledger_id
557: and e.je_header_id = gjh.je_header_id) ;
558:
559:
560: FV_UTILITY.LOG_MESG('Inserted ' || SQL%ROWCOUNT);
561:
562: COMMIT;
563: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');
564:

Line 632: fv_utility.log_mesg('Running in full mode');

628: OPEN l_gl_lines_cur FOR l_select_stmt using
629: gbl_sob_id,gbl_period_num_low ,gbl_period_num_high,gbl_period_year,
630: gbl_sob_id,gbl_period_year ,gbl_coa_id,gbl_sob_id,gbl_sob_id;
631:
632: fv_utility.log_mesg('Running in full mode');
633: fv_utility.log_mesg(l_select_stmt);
634:
635: else
636:

Line 633: fv_utility.log_mesg(l_select_stmt);

629: gbl_sob_id,gbl_period_num_low ,gbl_period_num_high,gbl_period_year,
630: gbl_sob_id,gbl_period_year ,gbl_coa_id,gbl_sob_id,gbl_sob_id;
631:
632: fv_utility.log_mesg('Running in full mode');
633: fv_utility.log_mesg(l_select_stmt);
634:
635: else
636:
637:

Line 670: fv_utility.log_mesg('Running in cumulative mode');

666: AND fff.set_of_books_id = :gbl_sob_id
667: AND fff.fiscal_year = :gbl_period_year' ;
668:
669:
670: fv_utility.log_mesg('Running in cumulative mode');
671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);

Line 671: fv_utility.log_mesg(l_select_stmt);

667: AND fff.fiscal_year = :gbl_period_year' ;
668:
669:
670: fv_utility.log_mesg('Running in cumulative mode');
671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);

Line 672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);

668:
669:
670: fv_utility.log_mesg('Running in cumulative mode');
671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);

Line 673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);

669:
670: fv_utility.log_mesg('Running in cumulative mode');
671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);

Line 674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);

670: fv_utility.log_mesg('Running in cumulative mode');
671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
678:

Line 675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);

671: fv_utility.log_mesg(l_select_stmt);
672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
678:
679:

Line 676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);

672: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
678:
679:
680: OPEN l_gl_lines_cur FOR l_select_stmt using

Line 677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);

673: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
674: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
675: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
676: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
677: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
678:
679:
680: OPEN l_gl_lines_cur FOR l_select_stmt using
681: gbl_sob_id,gbl_period_num_low ,gbl_period_num_high,gbl_period_year,

Line 833: fv_utility.log_mesg('je_header_id_list(i): '||je_header_id_list(i));

829: record_category_list_2(k) := l_party_info_tab(j).record_category;
830: recipient_name_list_2(k) := l_party_info_tab(j).recipient_name;
831: je_header_id_list_2(k) := je_header_id_list(i);
832:
833: fv_utility.log_mesg('je_header_id_list(i): '||je_header_id_list(i));
834:
835: je_line_num_list_2(k) := je_line_num_list(i);
836: je_category_list_2(k) := je_category_list(i);
837: je_source_list_2(k) := je_source_list(i);

Line 946: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

942: EXCEPTION
943: WHEN OTHERS THEN
944: gbl_err_code := SQLCODE;
945: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
946: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
947: END process_gl_lines;
948: --------------------------------------------------------------------------------
949: PROCEDURE GET_PARTY_INFO(p_category IN VARCHAR2,
950: p_source IN VARCHAR2,

Line 1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);

1031: ------------------------------------------------------------------
1032: IF (p_source = 'Payables' ) THEN
1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;

Line 1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1032: IF (p_source = 'Payables' ) THEN
1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;
1040:

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

1033: --AND p_category <> 'Treasury Confirmation') THEN
1034: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1037: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1038: 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1039: END IF;
1040:
1041: BEGIN

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

1077:
1078: ELSE
1079: l_recipient_name := 'Other';
1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1082: 'REFERENCE_2 I.E. INVOICE_ID IS NULL');
1083: END IF;
1084:
1085:

Line 1090: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,

1086: END IF;
1087:
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1091: 'NO DATA FOUND FOR SOURCE = PAYABLES !!');
1092: l_recipient_name := 'Other';
1093:
1094: END;

Line 1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1098: ------------------------------------------------------------------
1099: ELSIF (p_source in ('Purchasing' , 'Cost Management')) THEN
1100: IF (p_category = 'Receiving') THEN
1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1104: END IF;
1105: BEGIN
1106:

Line 1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);

1099: ELSIF (p_source in ('Purchasing' , 'Cost Management')) THEN
1100: IF (p_category = 'Receiving') THEN
1101: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1104: END IF;
1105: BEGIN
1106:
1107: IF p_je_from_sla_flag = 'Y' THEN

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

1147: ELSE
1148: IF (p_reference_2 IS NULL) THEN
1149: l_recipient_name := 'Other';
1150: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1152: 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');
1153: END IF;
1154: ELSE
1155: l_recipient_name := 'Other';

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

1153: END IF;
1154: ELSE
1155: l_recipient_name := 'Other';
1156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1158: 'REFERENCE_5 I.E. TRANSACTION_ID IS NULL');
1159: END IF;
1160: END IF;
1161:

Line 1165: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,

1161:
1162: END IF;
1163: EXCEPTION
1164: WHEN NO_DATA_FOUND THEN
1165: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1166: 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS RECEIVING!!');
1167:
1168: l_recipient_name := 'Other';
1169: END;

Line 1173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);

1169: END;
1170:
1171: ELSIF (p_category = 'Purchases') THEN
1172: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1174: END IF;
1175: BEGIN
1176: IF p_je_from_sla_flag = 'Y' THEN
1177: get_reference_column ('PURCHASE_ORDER',

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

1211: ELSE
1212: l_recipient_name := 'Other';
1213:
1214: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1216: 'REFERENCE_2 I.E. PO HEADER ID IS NULL');
1217: END IF;
1218:
1219: END IF;

Line 1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,

1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN NO_DATA_FOUND THEN
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1224: 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS PURCHASES!!');
1225:
1226: l_recipient_name := 'Other';
1227: END;

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

1265: l_cust_vend_type := 'C';
1266: ELSE
1267: l_recipient_name := 'Other';
1268: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1269: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1270: 'REFERENCE_7 I.E. CUSTOMER_ID IS NULL');
1271: END IF;
1272: END IF;
1273: EXCEPTION

Line 1276: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

1272: END IF;
1273: EXCEPTION
1274: WHEN NO_DATA_FOUND THEN
1275: l_recipient_name := 'Other';
1276: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
1277: l_module_name,'NO DATA FOUND WHEN SOURCE IS RECEIVABLES!!');
1278: END;
1279: --------------------------------------------------------------------
1280: -- Vendor id for TC transactions

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

1321:
1322: ELSE
1323: l_recipient_name := 'Other';
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1326: 'REFERENCE_3 I.E. CHECK_ID IS NULL');
1327: END IF;
1328: END IF;
1329:

Line 1389: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,

1385: l_recipient_name := 'Other';
1386: END IF;
1387: EXCEPTION
1388: WHEN NO_DATA_FOUND THEN
1389: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
1390: 'NO DATA FOUND WHEN SOURCE = BUDGETARY TRANSACTION');
1391: END;
1392:
1393: ELSIF (l_govt_non_govt_ind = 'Y') THEN

Line 1463: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1459: END IF;
1460:
1461: IF (party_info_tab(i).party_id IS NULL) THEN
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1464: l_module_name, 'VENDOR ID IS NULL');
1465: END IF;
1466: IF ((l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'Y') OR
1467: (l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'N'

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

1475: party_info_tab(i).record_category := 'REPORTED';
1476: END IF;
1477:
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1480: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1481: END IF;
1482:
1483: -- Govt Non Govt Indicator = Y

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

1494: party_info_tab(i).g_ng_indicator := 'F';
1495: END IF;
1496:
1497: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1499: 'Recipient Name: ' || party_info_tab(i).recipient_name);
1500: END IF;
1501:
1502: END IF; -- Govt Non Govt = F or Y

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

1516: party_info_tab(i).record_category := 'G_NONFED_VENDOR';
1517: END IF;
1518:
1519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1521: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1522: END IF;
1523:
1524: ELSIF (l_govt_non_govt_ind = 'F' and party_info_tab(i).elim_dept IS NULL) THEN

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

1529: party_info_tab(i).g_ng_indicator := 'F';
1530: party_info_tab(i).record_category := 'REPORTED';
1531:
1532: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1534: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1535: END IF;
1536:
1537: ELSIF (l_govt_non_govt_ind = 'F' and party_info_tab(i).elim_dept IS NOT NULL) THEN

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

1539: party_info_tab(i).record_category := 'REPORTED';
1540: --l_govt_non_govt_ind := 'F';
1541: party_info_tab(i).g_ng_indicator := 'F';
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: ' GNG: F');
1545: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1546: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1547: END IF;

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

1541: party_info_tab(i).g_ng_indicator := 'F';
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: ' GNG: F');
1545: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1546: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1547: END IF;
1548:
1549: ELSIF (l_govt_non_govt_ind = 'Y' AND

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

1555: party_info_tab(i).g_ng_indicator := 'N';
1556: party_info_tab(i).elim_dept := ' ';
1557:
1558: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1560: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1561: END IF;
1562:
1563: ELSIF (l_govt_non_govt_ind = 'Y' and party_info_tab(i).elim_dept IS NULL) THEN

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

1568: party_info_tab(i).g_ng_indicator := 'F';
1569: party_info_tab(i).elim_dept := '00';
1570:
1571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1573: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1574: END IF;
1575:
1576: ELSIF (l_govt_non_govt_ind = 'Y' and party_info_tab(i).elim_dept IS NOT NULL) THEN

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

1580: --l_govt_non_govt_ind := 'F';
1581: party_info_tab(i).g_ng_indicator := 'F';
1582:
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

1582:
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1589: ' ELIMINATIONS ID IS NOT NULL');
1590: END IF;

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

1584: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1585: ' IN VIEW');
1586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1587: ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1589: ' ELIMINATIONS ID IS NOT NULL');
1590: END IF;
1591:
1592: END IF; -- l_govt_non_govt_ind

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

1603: party_info_tab(i).g_ng_indicator := 'F';
1604: party_info_tab(i).record_category := 'REPORTED';
1605:
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

1605:
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1613: END IF;

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

1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1608: ' IN VIEW');
1609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1610: ' ELIMINATIONS ID IS NOT NULL');
1611: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1613: END IF;
1614:
1615: END IF; -- l_govt_non_govt_ind

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

1644: gbl_err_code := 2 ;
1645: gbl_err_buff := 'GET_PARTY_INFO - Exception (Others) - ' ||
1646: to_char(SQLCODE) || ' - ' || SQLERRM;
1647:
1648: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1649: '.final_exception',gbl_err_buff);
1650:
1651: END get_party_info;
1652: --------------------------------------------------------------------------------

Line 1661: FV_UTILITY.LOG_MESG('In '||l_module_name);

1657: l_stmt varchar2(5000);
1658: BEGIN
1659:
1660: l_module_name := g_module_name||'INSERT_EXCEPTION_RECS';
1661: FV_UTILITY.LOG_MESG('In '||l_module_name);
1662: gbl_exception_rec_count := 0;
1663:
1664: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1665:

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

1692: EXCEPTION WHEN OTHERS THEN
1693: gbl_err_code := 2 ;
1694: gbl_err_buff := l_module_name||' - When others exception - ' ||
1695: to_char(SQLCODE) || ' - ' || SQLERRM;
1696: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
1697: gbl_err_buff);
1698:
1699: END insert_exception_recs;
1700: --------------------------------------------------------------------------------

Line 1719: FV_UTILITY.LOG_MESG('In '||l_module_name);

1715:
1716: BEGIN
1717:
1718: l_module_name := g_module_name||'SUBMIT_EXCEPTION_REPORT';
1719: FV_UTILITY.LOG_MESG('In '||l_module_name);
1720:
1721: l_run_mode := 'Fiscal Year';
1722:
1723:

Line 1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');

1721: l_run_mode := 'Fiscal Year';
1722:
1723:
1724:
1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);

Line 1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);

1722:
1723:
1724:
1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1730:

Line 1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);

1723:
1724:
1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1730:
1731: l_req_id := FND_REQUEST.SUBMIT_REQUEST

Line 1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);

1724:
1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1730:
1731: l_req_id := FND_REQUEST.SUBMIT_REQUEST
1732: ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year,

Line 1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);

1725: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1726: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1727: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1728: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1729: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1730:
1731: l_req_id := FND_REQUEST.SUBMIT_REQUEST
1732: ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year,
1733: gbl_sob_id, gbl_period_name);

Line 1736: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));

1732: ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year,
1733: gbl_sob_id, gbl_period_name);
1734:
1735: -- If concurrent request submission failed, abort process
1736: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));
1737:
1738: IF (l_req_id = 0) THEN
1739: gbl_err_code := '2';
1740: gbl_err_buff := 'Cannot submit FACTS Exception report';

Line 1741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

1737:
1738: IF (l_req_id = 0) THEN
1739: gbl_err_code := '2';
1740: gbl_err_buff := 'Cannot submit FACTS Exception report';
1741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1742: RETURN;
1743: ELSE
1744: COMMIT;
1745: call_status := Fnd_concurrent.Wait_for_request(l_req_id, 20, 0,

Line 1751: FV_UTILITY.LOG_MESG(l_module_name||'.error4', gbl_err_buff) ;

1747: dphase, dstatus, message);
1748: IF call_status = FALSE THEN
1749: gbl_err_buff := 'Cannot wait for the status of FACTS Exception Report';
1750: gbl_err_code := -1;
1751: FV_UTILITY.LOG_MESG(l_module_name||'.error4', gbl_err_buff) ;
1752: RETURN;
1753: END IF;
1754: END IF;
1755:

Line 1766: FV_UTILITY.LOG_MESG('In '||l_module_name);

1762:
1763: BEGIN
1764:
1765: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
1766: FV_UTILITY.LOG_MESG('In '||l_module_name);
1767:
1768: fv_utility.log_mesg('Inserting processed headers ' );
1769:
1770: IF gbl_called_from_main = 'Y' THEN

Line 1768: fv_utility.log_mesg('Inserting processed headers ' );

1764:
1765: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
1766: FV_UTILITY.LOG_MESG('In '||l_module_name);
1767:
1768: fv_utility.log_mesg('Inserting processed headers ' );
1769:
1770: IF gbl_called_from_main = 'Y' THEN
1771: INSERT INTO fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1772: SELECT DISTINCT je_header_id,set_of_books_id

Line 1782: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);

1778: from fv_facts1_header_id_gt;
1779:
1780: END IF;
1781:
1782: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);
1783:
1784:
1785: fv_utility.log_mesg('Updating Facts1 run ' );
1786:

Line 1785: fv_utility.log_mesg('Updating Facts1 run ' );

1781:
1782: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);
1783:
1784:
1785: fv_utility.log_mesg('Updating Facts1 run ' );
1786:
1787: UPDATE fv_facts1_run
1788: SET process_date = sysdate,
1789: jc_run_month = gbl_period_num_high,

Line 1798: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );

1794:
1795:
1796: --Update the fv_facts1_fed_account as processed as of date.
1797:
1798: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1799: UPDATE fv_facts1_fed_accounts
1800: SET jc_flag = 'Y'
1801: WHERE set_of_books_id = gbl_sob_id
1802: AND fiscal_year = gbl_period_year;

Line 1813: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

1809: WHEN OTHERS THEN
1810: gbl_err_code := SQLCODE;
1811: gbl_err_buff := SQLERRM ||
1812: 'When others error in UPDATE_FACTS1_RUN - '||SQLERRM;
1813: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
1814:
1815: END UPDATE_FACTS1_RUN;
1816: --------------------------------------------------------------------------------
1817: PROCEDURE get_reference_column (p_entity_code IN VARCHAR2,

Line 1902: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '||

1898:
1899: p_party_info_tab(i).cust_vend_type := 'V';
1900:
1901: EXCEPTION WHEN NO_DATA_FOUND THEN
1902: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '||
1903: other_source_rec.party_id);
1904: p_party_info_tab(i).party_id := other_source_rec.party_id;
1905: p_party_info_tab(i).cust_vend_type := 'V';
1906: P_party_info_tab(i).party_line_amount := other_source_rec.amount;

Line 1931: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '||

1927: WHERE c.cust_account_id = other_source_rec.party_id;
1928:
1929: p_party_info_tab(i).cust_vend_type := 'C';
1930: EXCEPTION WHEN NO_DATA_FOUND THEN
1931: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '||
1932: other_source_rec.party_id);
1933: p_party_info_tab(i).party_id := other_source_rec.party_id;
1934: p_party_info_tab(i).cust_vend_type := 'C';
1935: P_party_info_tab(i).party_line_amount := other_source_rec.amount;

Line 2000: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,

1996: log(l_module_name,'line_amount: '||p_party_info_tab(i).party_line_amount);
1997: log(l_module_name,'vendor_type: '||p_party_info_tab(i).vendor_type);
1998:
1999: EXCEPTION WHEN NO_DATA_FOUND THEN
2000: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,
2001: 'NO DATA FOUND WHEN SOURCE = :'||p_entity_code);
2002: p_party_info_tab(i).party_line_amount := be_rec.amount;
2003: p_party_info_tab(i).recipient_name := 'Other';
2004: END;

Line 2013: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

2009: WHEN NO_DATA_FOUND THEN
2010: gbl_err_code := SQLCODE;
2011: gbl_err_buff :=
2012: 'No data found error in get_reference_column - '||SQLERRM;
2013: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2014: WHEN OTHERS THEN
2015: gbl_err_code := SQLCODE;
2016: gbl_err_buff :=
2017: 'When others error in get_reference_column - '||SQLERRM;

Line 2018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

2014: WHEN OTHERS THEN
2015: gbl_err_code := SQLCODE;
2016: gbl_err_buff :=
2017: 'When others error in get_reference_column - '||SQLERRM;
2018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2019: END get_reference_column;
2020: --------------------------------------------------------------------------------
2021: BEGIN
2022: g_module_name := 'fv.plsql.FV_FACTS1_GL_PKG.';