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 95: FV_UTILITY.LOG_MESG('In '||l_module_name);

91: l_no_fed_account NUMBER(15);
92: l_module_name VARCHAR2(200);
93: BEGIN
94: l_module_name := g_module_name || 'MAIN';
95: FV_UTILITY.LOG_MESG('In '||l_module_name);
96: FV_UTILITY.LOG_MESG('Parameters:');
97: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
98: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
99: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);

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

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

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

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

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

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

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

95: FV_UTILITY.LOG_MESG('In '||l_module_name);
96: FV_UTILITY.LOG_MESG('Parameters:');
97: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
98: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
99: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
100: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
101: gbl_trading_partner_att := upper(p_trading_partner_att);
102: gbl_called_from_main := p_called_from_main;
103: IF (gbl_called_from_main = 'I') THEN

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

96: FV_UTILITY.LOG_MESG('Parameters:');
97: FV_UTILITY.LOG_MESG('p_sob_id: '||p_sob_id);
98: FV_UTILITY.LOG_MESG('p_period_name: '||p_period_name);
99: FV_UTILITY.LOG_MESG('p_called_from_main: '||p_called_from_main);
100: FV_UTILITY.LOG_MESG('p_trading_partner_att: '||p_trading_partner_att);
101: gbl_trading_partner_att := upper(p_trading_partner_att);
102: gbl_called_from_main := p_called_from_main;
103: IF (gbl_called_from_main = 'I') THEN
104: gbl_called_from_main := 'N';

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

155: ROLLBACK;
156: RETURN;
157: END IF;
158: COMMIT;
159: FV_UTILITY.LOG_MESG('Facts I Journal Process completed successfully.');
160: EXCEPTION
161: WHEN OTHERS THEN
162: p_err_code := SQLCODE;
163: p_err_buff := 'When others exception in Main - '||SQLERRM;

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

161: WHEN OTHERS THEN
162: p_err_code := SQLCODE;
163: p_err_buff := 'When others exception in Main - '||SQLERRM;
164: ROLLBACK;
165: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
166: END main;
167: --------------------------------------------------------------------------------
168: PROCEDURE CLEANUP
169: IS

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

169: IS
170: l_module_name VARCHAR2(200);
171: BEGIN
172: l_module_name := g_module_name || 'CLEANUP';
173: FV_UTILITY.LOG_MESG('In '||l_module_name);
174: DELETE FROM fv_facts_report_t2 WHERE set_of_books_id = gbl_sob_id;
175: EXCEPTION
176: WHEN OTHERS THEN
177: gbl_err_code := SQLCODE;

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

175: EXCEPTION
176: WHEN OTHERS THEN
177: gbl_err_code := SQLCODE;
178: gbl_err_buff := l_module_name||' - When others exception - '||SQLERRM;
179: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
180: END CLEANUP;
181: --------------------------------------------------------------------------------
182: -- Get balancing and accounting segments
183: --------------------------------------------------------------------------------

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

190: invalid_bal_segment EXCEPTION;
191: invalid_acc_segment EXCEPTION;
192: BEGIN
193: l_module_name := g_module_name || 'GET_SEGMENT_NAMES';
194: FV_UTILITY.LOG_MESG('In '||l_module_name);
195: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
196: -- Get Balancing Segment Name
197: -----------------------------
198: l_segment_found := FND_FLEX_APIS.get_segment_column (l_app_id, l_flex_code, gbl_coa_id, 'GL_BALANCING', gbl_bal_segment) ;

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

191: invalid_acc_segment EXCEPTION;
192: BEGIN
193: l_module_name := g_module_name || 'GET_SEGMENT_NAMES';
194: FV_UTILITY.LOG_MESG('In '||l_module_name);
195: FV_UTILITY.LOG_MESG('COA ID: '||gbl_coa_id);
196: -- Get Balancing Segment Name
197: -----------------------------
198: l_segment_found := FND_FLEX_APIS.get_segment_column (l_app_id, l_flex_code, gbl_coa_id, 'GL_BALANCING', gbl_bal_segment) ;
199: IF NOT l_segment_found THEN

Line 211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Balancing Segment: '||gbl_bal_segment);

207: END IF;
208: IF (gbl_bal_segment IS NULL OR gbl_acc_segment IS NULL) THEN
209: RAISE NO_DATA_FOUND;
210: END IF;
211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Balancing Segment: '||gbl_bal_segment);
212: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Accounting Segment: '||gbl_acc_segment);
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: gbl_err_code := -1 ;

Line 212: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Accounting Segment: '||gbl_acc_segment);

208: IF (gbl_bal_segment IS NULL OR gbl_acc_segment IS NULL) THEN
209: RAISE NO_DATA_FOUND;
210: END IF;
211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Balancing Segment: '||gbl_bal_segment);
212: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Accounting Segment: '||gbl_acc_segment);
213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: gbl_err_code := -1 ;
216: gbl_err_buff := 'Balancing or Accounting segment not found.';

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

213: EXCEPTION
214: WHEN NO_DATA_FOUND THEN
215: gbl_err_code := -1 ;
216: gbl_err_buff := 'Balancing or Accounting segment not found.';
217: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
218: WHEN invalid_bal_segment THEN
219: gbl_err_code := -1 ;
220: gbl_err_buff := 'Error while fetching balancing segment.';
221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

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

217: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
218: WHEN invalid_bal_segment THEN
219: gbl_err_code := -1 ;
220: gbl_err_buff := 'Error while fetching balancing segment.';
221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
222: WHEN invalid_acc_segment THEN
223: gbl_err_code := -1 ;
224: gbl_err_buff := 'Error while fetching accounting segment.';
225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

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

221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
222: WHEN invalid_acc_segment THEN
223: gbl_err_code := -1 ;
224: gbl_err_buff := 'Error while fetching accounting segment.';
225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
226: WHEN OTHERS THEN
227: gbl_err_code := -1 ;
228: gbl_err_buff := 'When others error while getting
229: Balancing or Accounting segment - '||SQLERRM;

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

226: WHEN OTHERS THEN
227: gbl_err_code := -1 ;
228: gbl_err_buff := 'When others error while getting
229: Balancing or Accounting segment - '||SQLERRM;
230: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
231: END get_segment_names;
232: --------------------------------------------------------------------------------
233: -- Get the period num for the parameter period and also the first period num
234: -- for the year.

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

238: l_module_name VARCHAR2(200);
239: l_temp_mesg VARCHAR2(250);
240: BEGIN
241: l_module_name := g_module_name || 'GET_PROCESS_DATES';
242: FV_UTILITY.LOG_MESG('In '||l_module_name);
243: -- Get the period year for the period parameter passed.
244: l_temp_mesg := 'getting period year.';
245: SELECT period_year
246: INTO gbl_period_year

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

270: AND p.period_year = gbl_period_year;
271: IF (gbl_period_num_low = 0 OR gbl_period_num_high = 0) THEN
272: gbl_err_code := 2 ;
273: gbl_err_buff := l_module_name||' Period number '|| 'found zero for the passed fiscal year.' ;
274: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
275: RETURN;
276: END IF;
277: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
278: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);

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

273: gbl_err_buff := l_module_name||' Period number '|| 'found zero for the passed fiscal year.' ;
274: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
275: RETURN;
276: END IF;
277: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
278: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
279: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN

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

274: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
275: RETURN;
276: END IF;
277: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
278: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
279: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: gbl_err_code := 2;

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

275: RETURN;
276: END IF;
277: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
278: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);
279: FV_UTILITY.LOG_MESG('Period Number High: '||gbl_period_num_high);
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: gbl_err_code := 2;
283: gbl_err_buff := l_module_name||' - No data found when '||l_temp_mesg;

Line 284: FV_UTILITY.LOG_MESG(gbl_err_buff);

280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: gbl_err_code := 2;
283: gbl_err_buff := l_module_name||' - No data found when '||l_temp_mesg;
284: FV_UTILITY.LOG_MESG(gbl_err_buff);
285: WHEN OTHERS THEN
286: gbl_err_code := 2;
287: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg;
288: FV_UTILITY.LOG_MESG(gbl_err_buff);

Line 288: FV_UTILITY.LOG_MESG(gbl_err_buff);

284: FV_UTILITY.LOG_MESG(gbl_err_buff);
285: WHEN OTHERS THEN
286: gbl_err_code := 2;
287: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg;
288: FV_UTILITY.LOG_MESG(gbl_err_buff);
289: END get_process_dates;
290: --------------------------------------------------------------------------------
291: -- Get Facts I Journal, Vendor and Customer attributes
292: --------------------------------------------------------------------------------

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

295: l_module_name VARCHAR2(200);
296: l_temp_mesg VARCHAR2(50);
297: BEGIN
298: l_module_name := g_module_name || 'GET_SYSTEM_ATTRIBUTES';
299: FV_UTILITY.LOG_MESG('In '||l_module_name);
300: l_temp_mesg := 'getting Journal Attribute.';
301: SELECT factsI_journal_attribute
302: INTO gbl_jrnl_attribute
303: FROM fv_system_parameters;

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

318: gbl_coa_id
319: FROM gl_ledgers_public_v
320: WHERE ledger_id = gbl_sob_id;
321:
322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
324: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
325: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
326: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);

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

319: FROM gl_ledgers_public_v
320: WHERE ledger_id = gbl_sob_id;
321:
322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
324: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
325: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
326: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
327: EXCEPTION

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

320: WHERE ledger_id = gbl_sob_id;
321:
322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
324: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
325: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
326: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN

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

321:
322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
324: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
325: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
326: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: gbl_err_code := 2;

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

322: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);
323: FV_UTILITY.LOG_MESG('Vendor Attribute: '||gbl_vend_attribute);
324: FV_UTILITY.LOG_MESG('Customer Attribute: '||gbl_cust_attribute);
325: FV_UTILITY.LOG_MESG('Currency: '||gbl_currency_code);
326: FV_UTILITY.LOG_MESG('Chart of Accounts Id: '||gbl_coa_id);
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: gbl_err_code := 2;
330: gbl_err_buff := l_module_name||' - Null values/No data found when '|| l_temp_mesg;

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

327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: gbl_err_code := 2;
330: gbl_err_buff := l_module_name||' - Null values/No data found when '|| l_temp_mesg;
331: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);
332: WHEN OTHERS THEN
333: gbl_err_code := SQLCODE;
334: gbl_err_buff := l_module_name||' - When others error '||l_temp_mesg|| ' - '||SQLERRM;
335: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);

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

331: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);
332: WHEN OTHERS THEN
333: gbl_err_code := SQLCODE;
334: gbl_err_buff := l_module_name||' - When others error '||l_temp_mesg|| ' - '||SQLERRM;
335: FV_UTILITY.LOG_MESG(l_module_name,gbl_err_buff);
336: END get_system_attributes;
337: --------------------------------------------------------------------------------
338: PROCEDURE log
339: (

Line 347: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);

343: --------------------------------------------------------------------------------
344: l_module_name VARCHAR2(1000);
345: BEGIN
346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
347: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
348: END IF;
349: EXCEPTION
350: WHEN OTHERS THEN
351: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);

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

347: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
348: END IF;
349: EXCEPTION
350: WHEN OTHERS THEN
351: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
352: END log;
353: --------------------------------------------------------------------------------
354: -- Select all journal lines from gl_je_lines from the beginning of the year upto
355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and

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

498: flg BOOLEAN;
499: k BINARY_INTEGER := 1;
500: BEGIN
501: l_module_name := g_module_name || 'PROCESS_GL_LINES';
502: FV_UTILITY.LOG_MESG('In '||l_module_name);
503: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
504: IF gbl_called_from_main = 'N' THEN
505: INSERT INTO fv_facts1_header_id_gt
506: (je_header_id,set_of_books_id

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

499: k BINARY_INTEGER := 1;
500: BEGIN
501: l_module_name := g_module_name || 'PROCESS_GL_LINES';
502: FV_UTILITY.LOG_MESG('In '||l_module_name);
503: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
504: IF gbl_called_from_main = 'N' THEN
505: INSERT INTO fv_facts1_header_id_gt
506: (je_header_id,set_of_books_id
507: )

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

527: WHERE e.set_of_books_id = gjh.ledger_id
528: AND e.je_header_id = gjh.je_header_id
529: ) ;
530:
531: FV_UTILITY.LOG_MESG('Inserted ' || SQL%ROWCOUNT);
532: COMMIT;
533: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');
534: END IF;
535: l_select_stmt := ' gjl.code_combination_id,

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

597: gbl_period_year ,
598: gbl_coa_id,
599: gbl_sob_id,
600: gbl_sob_id;
601: fv_utility.log_mesg('Running in full mode');
602: fv_utility.log_mesg(l_select_stmt);
603: ELSE
604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

Line 602: fv_utility.log_mesg(l_select_stmt);

598: gbl_coa_id,
599: gbl_sob_id,
600: gbl_sob_id;
601: fv_utility.log_mesg('Running in full mode');
602: fv_utility.log_mesg(l_select_stmt);
603: ELSE
604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,

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

633: AND fff.set_of_books_id = :gbl_sob_id
634: AND fff.fiscal_year = :gbl_period_year';
635:
636:
637: fv_utility.log_mesg('Running in cumulative mode');
638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);

Line 638: fv_utility.log_mesg(l_select_stmt);

634: AND fff.fiscal_year = :gbl_period_year';
635:
636:
637: fv_utility.log_mesg('Running in cumulative mode');
638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);

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

635:
636:
637: fv_utility.log_mesg('Running in cumulative mode');
638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);

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

636:
637: fv_utility.log_mesg('Running in cumulative mode');
638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
644: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);

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

637: fv_utility.log_mesg('Running in cumulative mode');
638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
644: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
645:

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

638: fv_utility.log_mesg(l_select_stmt);
639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
644: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
645:
646:

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

639: fv_utility.log_mesg('gbl_sob_id: '||gbl_sob_id);
640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
644: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
645:
646:
647: OPEN l_gl_lines_cur FOR l_select_stmt USING gbl_sob_id,

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

640: fv_utility.log_mesg('gbl_coa_id: '||gbl_coa_id);
641: fv_utility.log_mesg('gbl_period_num_low: '||gbl_period_num_low);
642: fv_utility.log_mesg('gbl_period_num_high: '||gbl_period_num_high);
643: fv_utility.log_mesg('gbl_period_year: '||gbl_period_year);
644: fv_utility.log_mesg('gbl_currency_code: '||gbl_currency_code);
645:
646:
647: OPEN l_gl_lines_cur FOR l_select_stmt USING gbl_sob_id,
648: gbl_period_num_low ,

Line 740: fv_utility.log_mesg('Before get_party_info-> gbl_run_process : gbl_err_code-> '|| gbl_run_process||'::'||gbl_err_code);

736: IF gbl_header_id < je_header_id_list(i) THEN
737: gbl_header_id := je_header_id_list(i);
738: END IF;
739: gbl_run_process:='Y';
740: fv_utility.log_mesg('Before get_party_info-> gbl_run_process : gbl_err_code-> '|| gbl_run_process||'::'||gbl_err_code);
741: get_party_info( je_category_list(i), je_source_list(i), reference_1_list(i), reference_2_list(i), reference_3_list(i), reference_5_list(i), reference_7_list(i), SUBSTR(attribute_value_list(i),1,6), -- bug 5505974
742: fed_nonfed_list(i), je_from_sla_flag_list(i), je_batch_id_list(i), je_header_id_list(i), je_line_num_list(i), d_c_indicator_list(i), l_party_info_tab);
743: fv_utility.log_mesg('After get_party_info ->gbl_run_process: gbl_err_code ->'||gbl_run_process||'::'||gbl_err_code);
744: if gbl_run_process = 'Y' then

Line 743: fv_utility.log_mesg('After get_party_info ->gbl_run_process: gbl_err_code ->'||gbl_run_process||'::'||gbl_err_code);

739: gbl_run_process:='Y';
740: fv_utility.log_mesg('Before get_party_info-> gbl_run_process : gbl_err_code-> '|| gbl_run_process||'::'||gbl_err_code);
741: get_party_info( je_category_list(i), je_source_list(i), reference_1_list(i), reference_2_list(i), reference_3_list(i), reference_5_list(i), reference_7_list(i), SUBSTR(attribute_value_list(i),1,6), -- bug 5505974
742: fed_nonfed_list(i), je_from_sla_flag_list(i), je_batch_id_list(i), je_header_id_list(i), je_line_num_list(i), d_c_indicator_list(i), l_party_info_tab);
743: fv_utility.log_mesg('After get_party_info ->gbl_run_process: gbl_err_code ->'||gbl_run_process||'::'||gbl_err_code);
744: if gbl_run_process = 'Y' then
745: ccid_list_2.extend(l_party_info_tab.COUNT);
746: period_num_list_2.extend(l_party_info_tab.COUNT);
747: account_number_list_2.extend(l_party_info_tab.COUNT);

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

783: eliminations_dept_list_2(k) := l_party_info_tab(j).elim_dept;
784: record_category_list_2(k) := l_party_info_tab(j).record_category;
785: recipient_name_list_2(k) := l_party_info_tab(j).recipient_name;
786: je_header_id_list_2(k) := je_header_id_list(i);
787: fv_utility.log_mesg('je_header_id_list(i): '||je_header_id_list(i));
788: je_line_num_list_2(k) := je_line_num_list(i);
789: je_category_list_2(k) := je_category_list(i);
790: je_source_list_2(k) := je_source_list(i);
791: party_id_list_2(k) := l_party_info_tab(j).party_id;

Line 928: FV_UTILITY.LOG_MESG

924: EXCEPTION
925: WHEN OTHERS THEN
926: gbl_err_code := SQLCODE;
927: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
928: FV_UTILITY.LOG_MESG
929: (
930: FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff
931: )
932: ;

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

1050: ------------------------------------------------------------------
1051: IF (p_source = 'Payables' ) THEN
1052: --AND p_category <> 'Treasury Confirmation') THEN
1053: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1056: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1057: END IF;
1058: BEGIN

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

1051: IF (p_source = 'Payables' ) THEN
1052: --AND p_category <> 'Treasury Confirmation') THEN
1053: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1056: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1057: END IF;
1058: BEGIN
1059: IF p_je_from_sla_flag = 'Y' THEN

Line 1056: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);

1052: --AND p_category <> 'Treasury Confirmation') THEN
1053: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,P_SOURCE);
1055: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1056: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1057: END IF;
1058: BEGIN
1059: IF p_je_from_sla_flag = 'Y' THEN
1060: get_reference_column ('AP_PAYMENTS', p_je_batch_id , p_je_header_id , p_je_line_num , 200, p_jrnl_dc_ind, party_info_tab);

Line 1088: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. INVOICE_ID IS NULL');

1084: l_cust_vend_type := 'V';
1085: ELSE
1086: l_recipient_name := 'Other';
1087: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1088: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. INVOICE_ID IS NULL');
1089: END IF;
1090: END IF;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN

Line 1093: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND FOR SOURCE = PAYABLES !!');

1089: END IF;
1090: END IF;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND FOR SOURCE = PAYABLES !!');
1094: l_recipient_name := 'Other';
1095: END;
1096: -------------------------------------------------------------------
1097: -- Get the Vendor ID for Purchasing Inventory Records

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

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

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

1100: -- IF (p_category = 'Receiving') THEN
1101: IF (p_category IN ('Receiving','Inventory')) THEN
1102: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 5: '|| P_REFERENCE_5);
1105: END IF;
1106: BEGIN
1107: IF p_je_from_sla_flag = 'Y' THEN
1108: l_appl_id := 201;

Line 1145: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');

1141: ELSE
1142: IF (p_reference_2 IS NULL) THEN
1143: l_recipient_name := 'Other';
1144: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. PO_HEADER_ID IS NULL');
1146: END IF;
1147: ELSE
1148: l_recipient_name := 'Other';
1149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_5 I.E. TRANSACTION_ID IS NULL');

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

Line 1156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS RECEIVING!!');

1152: END IF;
1153: END IF;
1154: EXCEPTION
1155: WHEN NO_DATA_FOUND THEN
1156: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS RECEIVING!!');
1157: l_recipient_name := 'Other';
1158: END;
1159: ELSIF (p_category IN ('Purchases', 'Release')) THEN
1160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1157: l_recipient_name := 'Other';
1158: END;
1159: ELSIF (p_category IN ('Purchases', 'Release')) THEN
1160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 2: '|| P_REFERENCE_2);
1162: END IF;
1163: BEGIN
1164: IF p_je_from_sla_flag = 'Y' THEN
1165: get_reference_column ('PURCHASE_ORDER', p_je_batch_id , p_je_header_id , p_je_line_num , 201, p_jrnl_dc_ind, party_info_tab);

Line 1193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. PO HEADER ID IS NULL');

1189: l_cust_vend_type := 'V';
1190: ELSE
1191: l_recipient_name := 'Other';
1192: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_2 I.E. PO HEADER ID IS NULL');
1194: END IF;
1195: END IF;
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN

Line 1198: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS PURCHASES!!');

1194: END IF;
1195: END IF;
1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
1198: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE IS PURCHASING AND CATEGORY IS PURCHASES!!');
1199: l_recipient_name := 'Other';
1200: END;
1201: END IF;
1202: -----------------------------------------------------------

Line 1234: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_7 I.E. CUSTOMER_ID IS NULL');

1230: l_cust_vend_type := 'C';
1231: ELSE
1232: l_recipient_name := 'Other';
1233: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1234: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_7 I.E. CUSTOMER_ID IS NULL');
1235: END IF;
1236: END IF;
1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN

Line 1240: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'NO DATA FOUND WHEN SOURCE IS RECEIVABLES!!');

1236: END IF;
1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN
1239: l_recipient_name := 'Other';
1240: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'NO DATA FOUND WHEN SOURCE IS RECEIVABLES!!');
1241: END;
1242: --------------------------------------------------------------------
1243: -- Vendor id for Project Accounting Transactions
1244: --------------------------------------------------------------------

Line 1247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'P_SOURCE:' ||p_source);

1243: -- Vendor id for Project Accounting Transactions
1244: --------------------------------------------------------------------
1245: ELSIF (p_source = 'Project Accounting') THEN
1246: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'P_SOURCE:' ||p_source);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 1: '|| p_reference_1);
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1250: END IF;
1251: BEGIN

Line 1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 1: '|| p_reference_1);

1244: --------------------------------------------------------------------
1245: ELSIF (p_source = 'Project Accounting') THEN
1246: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'P_SOURCE:' ||p_source);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 1: '|| p_reference_1);
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1250: END IF;
1251: BEGIN
1252: IF p_je_from_sla_flag = 'Y' THEN

Line 1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);

1245: ELSIF (p_source = 'Project Accounting') THEN
1246: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'P_SOURCE:' ||p_source);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'REFERENCE 1: '|| p_reference_1);
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1250: END IF;
1251: BEGIN
1252: IF p_je_from_sla_flag = 'Y' THEN
1253: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Before get_reference_column for projects : gbl_run_process :->'||gbl_run_process);

Line 1253: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Before get_reference_column for projects : gbl_run_process :->'||gbl_run_process);

1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_je_from_sla_flag: '||p_je_from_sla_flag);
1250: END IF;
1251: BEGIN
1252: IF p_je_from_sla_flag = 'Y' THEN
1253: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Before get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1254: get_reference_column ('PROJECTS', p_je_batch_id , p_je_header_id , p_je_line_num , 275, p_jrnl_dc_ind, party_info_tab);
1255: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR SOURCE = PROJECTS WITH p_je_header_id: '||p_je_header_id);
1256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'After get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1257:

Line 1255: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR SOURCE = PROJECTS WITH p_je_header_id: '||p_je_header_id);

1251: BEGIN
1252: IF p_je_from_sla_flag = 'Y' THEN
1253: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Before get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1254: get_reference_column ('PROJECTS', p_je_batch_id , p_je_header_id , p_je_line_num , 275, p_jrnl_dc_ind, party_info_tab);
1255: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR SOURCE = PROJECTS WITH p_je_header_id: '||p_je_header_id);
1256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'After get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1257:
1258: IF (gbl_err_code <> 0) OR (gbl_run_process='N') THEN
1259: return;

Line 1256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'After get_reference_column for projects : gbl_run_process :->'||gbl_run_process);

1252: IF p_je_from_sla_flag = 'Y' THEN
1253: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Before get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1254: get_reference_column ('PROJECTS', p_je_batch_id , p_je_header_id , p_je_line_num , 275, p_jrnl_dc_ind, party_info_tab);
1255: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR SOURCE = PROJECTS WITH p_je_header_id: '||p_je_header_id);
1256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'After get_reference_column for projects : gbl_run_process :->'||gbl_run_process);
1257:
1258: IF (gbl_err_code <> 0) OR (gbl_run_process='N') THEN
1259: return;
1260: END IF;

Line 1262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_reference_1 ->'||p_reference_1);

1258: IF (gbl_err_code <> 0) OR (gbl_run_process='N') THEN
1259: return;
1260: END IF;
1261: ELSIF (p_reference_1 IS NOT NULL) THEN
1262: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'p_reference_1 ->'||p_reference_1);
1263: BEGIN
1264: OPEN ven_rec(p_reference_1);
1265: FETCH ven_rec INTO l_vendor_id;
1266:

Line 1270: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'ERROR while retreiving vendor id for projects with reference_1:'||p_reference_1);

1266:
1267: CLOSE ven_rec;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'ERROR while retreiving vendor id for projects with reference_1:'||p_reference_1);
1271: END;
1272: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_vendor_id ->'||l_vendor_id);
1273: IF l_vendor_id IS NOT NULL THEN
1274: SELECT v.vendor_id,

Line 1272: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_vendor_id ->'||l_vendor_id);

1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'ERROR while retreiving vendor id for projects with reference_1:'||p_reference_1);
1271: END;
1272: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_vendor_id ->'||l_vendor_id);
1273: IF l_vendor_id IS NOT NULL THEN
1274: SELECT v.vendor_id,
1275: v.vendor_type_lookup_code,
1276: DECODE(gbl_vend_attribute, 'ATTRIBUTE1',

Line 1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_1 I.E. IS NULL');

1296: END IF;
1297: ELSE
1298: l_recipient_name := 'Other';
1299: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_1 I.E. IS NULL');
1301: END IF;
1302: END IF;
1303: EXCEPTION
1304: WHEN NO_DATA_FOUND THEN

Line 1305: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR RAISE - NO DATA FOUND FOR SOURCE = PROJECTS !!');

1301: END IF;
1302: END IF;
1303: EXCEPTION
1304: WHEN NO_DATA_FOUND THEN
1305: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'FOR RAISE - NO DATA FOUND FOR SOURCE = PROJECTS !!');
1306: l_recipient_name := 'Other';
1307: END;
1308: --------------------------------------------------------------------
1309: -- Vendor id for TC transactions

Line 1345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_3 I.E. CHECK_ID IS NULL');

1341: l_cust_vend_type := 'V';
1342: ELSE
1343: l_recipient_name := 'Other';
1344: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'REFERENCE_3 I.E. CHECK_ID IS NULL');
1346: END IF;
1347: END IF;
1348: EXCEPTION
1349: WHEN NO_DATA_FOUND THEN

Line 1385: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE = BUDGETARY TRANSACTION');

1381: l_recipient_name := 'Other';
1382: END IF;
1383: EXCEPTION
1384: WHEN NO_DATA_FOUND THEN
1385: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE = BUDGETARY TRANSACTION');
1386: END;
1387: ELSIF (l_govt_non_govt_ind = 'Y') THEN
1388: log(l_module_name , 'Falls on Manual source as govt non govt = Y');
1389: IF (ln_jrnl_att IS NOT NULL) THEN

Line 1453: FV_UTILITY.LOG_MESG('l_govt_non_govt_ind:: l_feeder_flag::elim_dept::party_id::Vendor_type -> '||l_govt_non_govt_ind||'::'||l_feeder_flag||'::'||party_info_tab(i).elim_dept||'::'||party_info_tab(i).party_id||'::'||party_info_tab(i).vendor_type);

1449: END IF;
1450: END IF;
1451: END IF;
1452: begin
1453: FV_UTILITY.LOG_MESG('l_govt_non_govt_ind:: l_feeder_flag::elim_dept::party_id::Vendor_type -> '||l_govt_non_govt_ind||'::'||l_feeder_flag||'::'||party_info_tab(i).elim_dept||'::'||party_info_tab(i).party_id||'::'||party_info_tab(i).vendor_type);
1454: exception
1455: when others then
1456: null;
1457: end;

Line 1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'VENDOR ID IS NULL');

1456: null;
1457: end;
1458: IF (party_info_tab(i).party_id IS NULL) THEN
1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'VENDOR ID IS NULL');
1461: END IF;
1462: IF ((l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'Y') OR (l_govt_non_govt_ind = 'F' AND l_feeder_flag = 'N' AND party_info_tab(i).elim_dept = '00')) THEN
1463: IF (party_info_tab(i).elim_dept IS NULL OR party_info_tab(i).elim_dept = '00') THEN
1464: party_info_tab(i).reported_status := 'W';

Line 1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Recipient Name: ' || party_info_tab(i).recipient_name);

1467: ELSE
1468: party_info_tab(i).record_category := 'REPORTED';
1469: END IF;
1470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Recipient Name: ' || party_info_tab(i).recipient_name);
1472: END IF;
1473: -- Govt Non Govt Indicator = Y
1474: ELSIF ((l_govt_non_govt_ind = 'Y' AND l_feeder_flag = 'Y') OR (l_govt_non_govt_ind = 'Y' AND l_feeder_flag = 'N')) THEN
1475: IF (party_info_tab(i).elim_dept IS NULL) THEN

Line 1476: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> elim_dept is null-> ');

1472: END IF;
1473: -- Govt Non Govt Indicator = Y
1474: ELSIF ((l_govt_non_govt_ind = 'Y' AND l_feeder_flag = 'Y') OR (l_govt_non_govt_ind = 'Y' AND l_feeder_flag = 'N')) THEN
1475: IF (party_info_tab(i).elim_dept IS NULL) THEN
1476: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> elim_dept is null-> ');
1477: party_info_tab(i).reported_status := 'W';
1478: party_info_tab(i).record_category := 'NO_VENDOR';
1479: party_info_tab(i).elim_dept := ' ';
1480: party_info_tab(i).g_ng_indicator := 'N';

Line 1487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Recipient Name: ' || party_info_tab(i).recipient_name);

1483: party_info_tab(i).record_category := 'REPORTED';
1484: party_info_tab(i).g_ng_indicator := 'F';
1485: END IF;
1486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Recipient Name: ' || party_info_tab(i).recipient_name);
1488: END IF;
1489: END IF; -- Govt Non Govt = F or Y
1490: ELSE -- l_vendor_id IS NOT NULL
1491: IF (l_feeder_flag = 'Y') THEN

Line 1502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1498: party_info_tab(i).reported_status := 'W';
1499: party_info_tab(i).record_category := 'G_NONFED_VENDOR';
1500: END IF;
1501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1503: END IF;
1504: ELSIF (l_govt_non_govt_ind = 'F' AND party_info_tab(i).elim_dept IS NULL) THEN
1505: party_info_tab(i).reported_status := 'R';
1506: party_info_tab(i).elim_dept := '00';

Line 1511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1507: --l_govt_non_govt_ind := 'F';
1508: party_info_tab(i).g_ng_indicator := 'F';
1509: party_info_tab(i).record_category := 'REPORTED';
1510: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1512: END IF;
1513: ELSIF (l_govt_non_govt_ind = 'F' AND party_info_tab(i).elim_dept IS NOT NULL) THEN
1514: party_info_tab(i).reported_status := 'R';
1515: party_info_tab(i).record_category := 'REPORTED';

Line 1519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' GNG: F');

1515: party_info_tab(i).record_category := 'REPORTED';
1516: --l_govt_non_govt_ind := 'F';
1517: party_info_tab(i).g_ng_indicator := 'F';
1518: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' GNG: F');
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1521: END IF;
1522: ELSIF (l_govt_non_govt_ind = 'Y' AND (UPPER(party_info_tab(i).vendor_type) <> 'FEDERAL' OR party_info_tab(i).vendor_type IS NULL)) THEN
1523: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> ');

Line 1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1516: --l_govt_non_govt_ind := 'F';
1517: party_info_tab(i).g_ng_indicator := 'F';
1518: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' GNG: F');
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1521: END IF;
1522: ELSIF (l_govt_non_govt_ind = 'Y' AND (UPPER(party_info_tab(i).vendor_type) <> 'FEDERAL' OR party_info_tab(i).vendor_type IS NULL)) THEN
1523: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> ');
1524: party_info_tab(i).reported_status := 'R';

Line 1523: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> ');

1519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' GNG: F');
1520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1521: END IF;
1522: ELSIF (l_govt_non_govt_ind = 'Y' AND (UPPER(party_info_tab(i).vendor_type) <> 'FEDERAL' OR party_info_tab(i).vendor_type IS NULL)) THEN
1523: FV_UTILITY.LOG_MESG('NOT A FEDERAL VENDOR -> ');
1524: party_info_tab(i).reported_status := 'R';
1525: party_info_tab(i).record_category := 'REPORTED';
1526: --l_govt_non_govt_ind := 'N';
1527: party_info_tab(i).g_ng_indicator := 'N';

Line 1530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1526: --l_govt_non_govt_ind := 'N';
1527: party_info_tab(i).g_ng_indicator := 'N';
1528: party_info_tab(i).elim_dept := ' ';
1529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1531: END IF;
1532: ELSIF (l_govt_non_govt_ind = 'Y' AND party_info_tab(i).elim_dept IS NULL) THEN
1533: party_info_tab(i).reported_status := 'R';
1534: party_info_tab(i).record_category := 'REPORTED';

Line 1539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1535: --l_govt_non_govt_ind := 'F';
1536: party_info_tab(i).g_ng_indicator := 'F';
1537: party_info_tab(i).elim_dept := '00';
1538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1540: END IF;
1541: ELSIF (l_govt_non_govt_ind = 'Y' AND party_info_tab(i).elim_dept IS NOT NULL) THEN
1542: party_info_tab(i).reported_status := 'R';
1543: party_info_tab(i).record_category := 'REPORTED';

Line 1547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');

1543: party_info_tab(i).record_category := 'REPORTED';
1544: --l_govt_non_govt_ind := 'F';
1545: party_info_tab(i).g_ng_indicator := 'F';
1546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1548: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1550: END IF;
1551: END IF; -- l_govt_non_govt_ind

Line 1548: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');

1544: --l_govt_non_govt_ind := 'F';
1545: party_info_tab(i).g_ng_indicator := 'F';
1546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1548: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1550: END IF;
1551: END IF; -- l_govt_non_govt_ind
1552: END IF; -- l_feeder_flag

Line 1549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');

1545: party_info_tab(i).g_ng_indicator := 'F';
1546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1548: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' VENDOR ID IS NOT NULL (' || party_info_tab(i).party_ID || ')');
1549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1550: END IF;
1551: END IF; -- l_govt_non_govt_ind
1552: END IF; -- l_feeder_flag
1553: END IF; -- l_vendor_id

Line 1561: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');

1557: --l_govt_non_govt_ind := 'F';
1558: party_info_tab(i).g_ng_indicator := 'F';
1559: party_info_tab(i).record_category := 'REPORTED';
1560: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1564: END IF;
1565: END IF; -- l_govt_non_govt_ind

Line 1562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');

1558: party_info_tab(i).g_ng_indicator := 'F';
1559: party_info_tab(i).record_category := 'REPORTED';
1560: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1564: END IF;
1565: END IF; -- l_govt_non_govt_ind
1566: END IF; -- l_feeder_system

Line 1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);

1559: party_info_tab(i).record_category := 'REPORTED';
1560: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' IN VIEW');
1562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' ELIMINATIONS ID IS NOT NULL');
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, ' RECIPIENT NAME: ' || party_info_tab(i).RECIPIENT_NAME);
1564: END IF;
1565: END IF; -- l_govt_non_govt_ind
1566: END IF; -- l_feeder_system
1567: log(l_module_name, 'Ending get_party_info with....');

Line 1592: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name|| '.final_exception',gbl_err_buff);

1588: EXCEPTION
1589: WHEN OTHERS THEN
1590: gbl_err_code := 2 ;
1591: gbl_err_buff := 'GET_PARTY_INFO - Exception (Others) - ' || TO_CHAR(SQLCODE) || ' - ' || SQLERRM;
1592: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name|| '.final_exception',gbl_err_buff);
1593: END get_party_info;
1594: --------------------------------------------------------------------------------
1595: PROCEDURE INSERT_EXCEPTION_RECS
1596: IS

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

1597: l_module_name VARCHAR2(100);
1598: l_stmt VARCHAR2(5000);
1599: BEGIN
1600: l_module_name := g_module_name||'INSERT_EXCEPTION_RECS';
1601: FV_UTILITY.LOG_MESG('In '||l_module_name);
1602: gbl_exception_rec_count := 0;
1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');

Line 1629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name|| gbl_err_buff);

1625: EXCEPTION
1626: WHEN OTHERS THEN
1627: gbl_err_code := 2 ;
1628: gbl_err_buff := l_module_name||' - When others exception - ' || TO_CHAR(SQLCODE) || ' - ' || SQLERRM;
1629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name|| gbl_err_buff);
1630: END insert_exception_recs;
1631: --------------------------------------------------------------------------------
1632: PROCEDURE SUBMIT_EXCEPTION_REPORT
1633: IS

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

1641: l_module_name VARCHAR2(80) ;
1642: l_run_mode VARCHAR2(80) ;
1643: BEGIN
1644: l_module_name := g_module_name||'SUBMIT_EXCEPTION_REPORT';
1645: FV_UTILITY.LOG_MESG('In '||l_module_name);
1646: l_run_mode := 'Fiscal Year';
1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);

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

1643: BEGIN
1644: l_module_name := g_module_name||'SUBMIT_EXCEPTION_REPORT';
1645: FV_UTILITY.LOG_MESG('In '||l_module_name);
1646: l_run_mode := 'Fiscal Year';
1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);

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

1644: l_module_name := g_module_name||'SUBMIT_EXCEPTION_REPORT';
1645: FV_UTILITY.LOG_MESG('In '||l_module_name);
1646: l_run_mode := 'Fiscal Year';
1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1652: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year, gbl_sob_id, gbl_period_name);

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

1645: FV_UTILITY.LOG_MESG('In '||l_module_name);
1646: l_run_mode := 'Fiscal Year';
1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1652: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year, gbl_sob_id, gbl_period_name);
1653: -- If concurrent request submission failed, abort process

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

1646: l_run_mode := 'Fiscal Year';
1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1652: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year, gbl_sob_id, gbl_period_name);
1653: -- If concurrent request submission failed, abort process
1654: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));

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

1647: FV_UTILITY.LOG_MESG(l_module_name|| ' Launching FACTS I exception report ...');
1648: FV_UTILITY.LOG_MESG(l_module_name|| ' l_run_mode: '||l_run_mode);
1649: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_year: '||gbl_period_year);
1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1652: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year, gbl_sob_id, gbl_period_name);
1653: -- If concurrent request submission failed, abort process
1654: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));
1655: IF (l_req_id = 0) THEN

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

1650: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_sob_id: '||gbl_sob_id);
1651: FV_UTILITY.LOG_MESG(l_module_name|| ' gbl_period_name: '||gbl_period_name);
1652: l_req_id := FND_REQUEST.SUBMIT_REQUEST ('FV','FVFACTSE','','',FALSE, l_run_mode, gbl_period_year, gbl_sob_id, gbl_period_name);
1653: -- If concurrent request submission failed, abort process
1654: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));
1655: IF (l_req_id = 0) THEN
1656: gbl_err_code := '2';
1657: gbl_err_buff := 'Cannot submit FACTS Exception report';
1658: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

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

1654: FV_UTILITY.LOG_MESG(l_module_name|| ' Request ID for exception report = '|| TO_CHAR(L_REQ_ID));
1655: IF (l_req_id = 0) THEN
1656: gbl_err_code := '2';
1657: gbl_err_buff := 'Cannot submit FACTS Exception report';
1658: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1659: RETURN;
1660: ELSE
1661: COMMIT;
1662: call_status := Fnd_concurrent.Wait_for_request(l_req_id, 20, 0, rphase, rstatus, dphase, dstatus, MESSAGE);

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

1662: call_status := Fnd_concurrent.Wait_for_request(l_req_id, 20, 0, rphase, rstatus, dphase, dstatus, MESSAGE);
1663: IF call_status = FALSE THEN
1664: gbl_err_buff := 'Cannot wait for the status of FACTS Exception Report';
1665: gbl_err_code := -1;
1666: FV_UTILITY.LOG_MESG(l_module_name||'.error4', gbl_err_buff) ;
1667: RETURN;
1668: END IF;
1669: END IF;
1670: END submit_exception_report;

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

1673: IS
1674: l_module_name VARCHAR2(200);
1675: BEGIN
1676: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
1677: FV_UTILITY.LOG_MESG('In '||l_module_name);
1678: fv_utility.log_mesg('Inserting processed headers ' );
1679: IF gbl_called_from_main = 'Y' THEN
1680: INSERT INTO fv_facts1_processed_je_hdrs
1681: (je_header_id,set_of_books_id

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

1674: l_module_name VARCHAR2(200);
1675: BEGIN
1676: l_module_name := g_module_name || 'UPDATE_FACTS1_RUN';
1677: FV_UTILITY.LOG_MESG('In '||l_module_name);
1678: fv_utility.log_mesg('Inserting processed headers ' );
1679: IF gbl_called_from_main = 'Y' THEN
1680: INSERT INTO fv_facts1_processed_je_hdrs
1681: (je_header_id,set_of_books_id
1682: )

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

1686: (je_header_id,set_of_books_id
1687: )
1688: SELECT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1689: END IF;
1690: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);
1691: fv_utility.log_mesg('Updating Facts1 run ' );
1692: UPDATE fv_facts1_run
1693: SET process_date = sysdate ,
1694: jc_run_month = gbl_period_num_high,

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

1687: )
1688: SELECT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1689: END IF;
1690: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);
1691: fv_utility.log_mesg('Updating Facts1 run ' );
1692: UPDATE fv_facts1_run
1693: SET process_date = sysdate ,
1694: jc_run_month = gbl_period_num_high,
1695: run_fed_flag = 'J'

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

1696: WHERE set_of_books_id = gbl_sob_id
1697: AND fiscal_year = gbl_period_year
1698: AND table_indicator = 'N';
1699: --Update the fv_facts1_fed_account as processed as of date.
1700: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1701: UPDATE fv_facts1_fed_accounts
1702: SET jc_flag = 'Y'
1703: WHERE set_of_books_id = gbl_sob_id
1704: AND fiscal_year = gbl_period_year;

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

1707: NULL;
1708: WHEN OTHERS THEN
1709: gbl_err_code := SQLCODE;
1710: gbl_err_buff := SQLERRM || 'When others error in UPDATE_FACTS1_RUN - '||SQLERRM;
1711: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
1712: END UPDATE_FACTS1_RUN;
1713: --------------------------------------------------------------------------------
1714: PROCEDURE get_reference_column
1715: (

Line 1797: FV_UTILITY.LOG_MESG('p_entity_code-> '||p_entity_code);

1793: LOOP
1794: log(l_module_name,'p_party_id: '||other_source_rec.party_id);
1795:
1796: p_party_info_tab(i).feeder_flag := 'Y';
1797: FV_UTILITY.LOG_MESG('p_entity_code-> '||p_entity_code);
1798: FV_UTILITY.LOG_MESG('other_source_rec.party_id -> '||other_source_rec.party_id);
1799:
1800: IF other_source_rec.party_id IS NOT NULL THEN
1801: IF p_entity_code IN ('PURCHASE_ORDER', 'AP_PAYMENTS', 'TR_CONFIRM') THEN

Line 1798: FV_UTILITY.LOG_MESG('other_source_rec.party_id -> '||other_source_rec.party_id);

1794: log(l_module_name,'p_party_id: '||other_source_rec.party_id);
1795:
1796: p_party_info_tab(i).feeder_flag := 'Y';
1797: FV_UTILITY.LOG_MESG('p_entity_code-> '||p_entity_code);
1798: FV_UTILITY.LOG_MESG('other_source_rec.party_id -> '||other_source_rec.party_id);
1799:
1800: IF other_source_rec.party_id IS NOT NULL THEN
1801: IF p_entity_code IN ('PURCHASE_ORDER', 'AP_PAYMENTS', 'TR_CONFIRM') THEN
1802: BEGIN

Line 1826: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);

1822:
1823: p_party_info_tab(i).cust_vend_type := 'V';
1824: EXCEPTION
1825: WHEN NO_DATA_FOUND THEN
1826: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);
1827: p_party_info_tab(i).party_id := other_source_rec.party_id;
1828: p_party_info_tab(i).cust_vend_type := 'V';
1829: P_party_info_tab(i).party_line_amount := other_source_rec.amount;
1830: p_party_info_tab(i).recipient_name := 'Other';

Line 1857: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| other_source_rec.party_id);

1853:
1854: p_party_info_tab(i).cust_vend_type := 'C';
1855: EXCEPTION
1856: WHEN NO_DATA_FOUND THEN
1857: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| other_source_rec.party_id);
1858: p_party_info_tab(i).party_id := other_source_rec.party_id;
1859: p_party_info_tab(i).cust_vend_type := 'C';
1860: P_party_info_tab(i).party_line_amount := other_source_rec.amount;
1861: p_party_info_tab(i).recipient_name := 'Other';

Line 1877: FV_UTILITY.LOG_MESG('p_entity_code -> '||p_entity_code);

1873: i := i + 1;
1874: END LOOP;
1875: ELSIF p_entity_code = 'BE_TRANSACTIONS' THEN
1876: -- using party_id for storing transaction id
1877: FV_UTILITY.LOG_MESG('p_entity_code -> '||p_entity_code);
1878: FOR be_rec IN be_cursor
1879: LOOP
1880: p_party_info_tab(i).feeder_flag := 'Y';
1881: FV_UTILITY.LOG_MESG('be_rec.transaction_id -> '||be_rec.transaction_id);

Line 1881: FV_UTILITY.LOG_MESG('be_rec.transaction_id -> '||be_rec.transaction_id);

1877: FV_UTILITY.LOG_MESG('p_entity_code -> '||p_entity_code);
1878: FOR be_rec IN be_cursor
1879: LOOP
1880: p_party_info_tab(i).feeder_flag := 'Y';
1881: FV_UTILITY.LOG_MESG('be_rec.transaction_id -> '||be_rec.transaction_id);
1882: BEGIN
1883: SELECT DECODE(gbl_trading_partner_att, NULL, dept_id || main_account,
1884: SUBSTR(DECODE(UPPER(gbl_trading_partner_att), 'ATTRIBUTE1', attribute1,
1885: 'ATTRIBUTE2', attribute2, 'ATTRIBUTE3', attribute3, 'ATTRIBUTE4', attribute4,

Line 1908: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE = :'||p_entity_code);

1904: log(l_module_name,'line_amount: '||p_party_info_tab(i).party_line_amount);
1905: log(l_module_name,'vendor_type: '||p_party_info_tab(i).vendor_type);
1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, 'NO DATA FOUND WHEN SOURCE = :'||p_entity_code);
1909: p_party_info_tab(i).party_line_amount := be_rec.amount;
1910: p_party_info_tab(i).recipient_name := 'Other';
1911: END;
1912: i := i + 1;

Line 1916: FV_UTILITY.LOG_MESG('p_entity_code 1 -> '|| p_entity_code);

1912: i := i + 1;
1913: END LOOP;
1914: ELSIF p_entity_code = 'PROJECTS' THEN
1915: --- Added block for projects.
1916: FV_UTILITY.LOG_MESG('p_entity_code 1 -> '|| p_entity_code);
1917: FOR project_source_rec IN project_source_cur
1918: LOOP
1919: log(l_module_name,'p_party_id: ' || project_source_rec.party_id);
1920: p_party_info_tab(i).feeder_flag := 'Y';

Line 1921: FV_UTILITY.LOG_MESG('p_entity_code -> '|| p_entity_code);

1917: FOR project_source_rec IN project_source_cur
1918: LOOP
1919: log(l_module_name,'p_party_id: ' || project_source_rec.party_id);
1920: p_party_info_tab(i).feeder_flag := 'Y';
1921: FV_UTILITY.LOG_MESG('p_entity_code -> '|| p_entity_code);
1922: FV_UTILITY.LOG_MESG('project_source_rec.party_id -> '|| project_source_rec.party_id);
1923:
1924: IF project_source_rec.party_id IS NOT NULL THEN
1925: /*IF p_entity_code ='RECEIPTS' THEN

Line 1922: FV_UTILITY.LOG_MESG('project_source_rec.party_id -> '|| project_source_rec.party_id);

1918: LOOP
1919: log(l_module_name,'p_party_id: ' || project_source_rec.party_id);
1920: p_party_info_tab(i).feeder_flag := 'Y';
1921: FV_UTILITY.LOG_MESG('p_entity_code -> '|| p_entity_code);
1922: FV_UTILITY.LOG_MESG('project_source_rec.party_id -> '|| project_source_rec.party_id);
1923:
1924: IF project_source_rec.party_id IS NOT NULL THEN
1925: /*IF p_entity_code ='RECEIPTS' THEN
1926: BEGIN

Line 1950: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| project_source_rec.party_id);

1946:
1947: p_party_info_tab(i).cust_vend_type := 'V';
1948: EXCEPTION
1949: WHEN NO_DATA_FOUND THEN
1950: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| project_source_rec.party_id);
1951: p_party_info_tab(i).party_id := project_source_rec.party_id;
1952: p_party_info_tab(i).cust_vend_type := 'V';
1953: P_party_info_tab(i).party_line_amount := project_source_rec.amount;
1954: p_party_info_tab(i).recipient_name := 'Other';

Line 1959: FV_UTILITY.LOG_MESG('Query hz_cust_accounts_all-> '||gbl_cust_attribute);

1955: END;
1956: ELS*/
1957: IF p_entity_code = 'PROJECTS' THEN
1958: BEGIN
1959: FV_UTILITY.LOG_MESG('Query hz_cust_accounts_all-> '||gbl_cust_attribute);
1960:
1961: SELECT c.party_id ,
1962: c.customer_class_code,
1963: DECODE(gbl_cust_attribute, 'ATTRIBUTE1', C.ATTRIBUTE1, 'ATTRIBUTE2',

Line 1983: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| project_source_rec.party_id);

1979:
1980: p_party_info_tab(i).cust_vend_type := 'C';
1981: EXCEPTION
1982: WHEN NO_DATA_FOUND THEN
1983: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '|| project_source_rec.party_id);
1984: p_party_info_tab(i).party_id := project_source_rec.party_id;
1985: p_party_info_tab(i).cust_vend_type := 'C';
1986: P_party_info_tab(i).party_line_amount := project_source_rec.amount;
1987: p_party_info_tab(i).recipient_name := 'Other';

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

2000: END LOOP;
2001: if i<=1 then
2002: gbl_run_process:='N';
2003: gbl_err_buff :='No data found error for PROJECTS get_reference_column- '||SQLERRM;
2004: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2005: RETURN;
2006: end if;
2007: END IF;
2008:

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

2010: IF i <=1 THEN
2011: gbl_err_code := SQLCODE;
2012: --gbl_err_code :=2;
2013: gbl_err_buff :='No data found error in get_reference_column - '||SQLERRM;
2014: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2015: RETURN;
2016: END IF ;
2017: EXCEPTION
2018: WHEN NO_DATA_FOUND THEN

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

2018: WHEN NO_DATA_FOUND THEN
2019: gbl_err_code := SQLCODE;
2020: --gbl_err_code :=0;
2021: gbl_err_buff := 'No data found error in get_reference_column - '||SQLERRM;
2022: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2023: WHEN OTHERS THEN
2024: gbl_err_code := SQLCODE;
2025: gbl_err_buff := 'When others error in get_reference_column - '||SQLERRM;
2026: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);

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

2022: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2023: WHEN OTHERS THEN
2024: gbl_err_code := SQLCODE;
2025: gbl_err_buff := 'When others error in get_reference_column - '||SQLERRM;
2026: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_err_buff);
2027: END get_reference_column;
2028: --------------------------------------------------------------------------------
2029: BEGIN
2030: g_module_name := 'fv.plsql.FV_FACTS1_GL_PKG.';