APPS.FV_1219_TRANSACTIONS dependencies on FND_LOG

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

192: p_delete_corrections := delete_corrections;
193: p_error_code := 0;
194: p_error_msg := '** FORM 1219 PROCESS COMPLETED SUCCESSFULLY **';
195:
196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
198: 'INPUT PARAMETERS: ');
199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
200: ' SET OF BOOKS ID: '||P_SET_BKS_ID);

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

193: p_error_code := 0;
194: p_error_msg := '** FORM 1219 PROCESS COMPLETED SUCCESSFULLY **';
195:
196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
198: 'INPUT PARAMETERS: ');
199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
200: ' SET OF BOOKS ID: '||P_SET_BKS_ID);
201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

195:
196: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
198: 'INPUT PARAMETERS: ');
199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
200: ' SET OF BOOKS ID: '||P_SET_BKS_ID);
201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
202: ' GL PERIOD: '||P_GL_PERIOD);
203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
198: 'INPUT PARAMETERS: ');
199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
200: ' SET OF BOOKS ID: '||P_SET_BKS_ID);
201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
202: ' GL PERIOD: '||P_GL_PERIOD);
203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
204: ' ALC CODE : '||P_ALC_CODE);
205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
200: ' SET OF BOOKS ID: '||P_SET_BKS_ID);
201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
202: ' GL PERIOD: '||P_GL_PERIOD);
203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
204: ' ALC CODE : '||P_ALC_CODE);
205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
206: ' DELETE CORRECTIONS: '||P_DELETE_CORRECTIONS);
207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

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

201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
202: ' GL PERIOD: '||P_GL_PERIOD);
203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
204: ' ALC CODE : '||P_ALC_CODE);
205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
206: ' DELETE CORRECTIONS: '||P_DELETE_CORRECTIONS);
207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
208: END IF;
209:

Line 207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
204: ' ALC CODE : '||P_ALC_CODE);
205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
206: ' DELETE CORRECTIONS: '||P_DELETE_CORRECTIONS);
207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
208: END IF;
209:
210: -- Check whether alc_code has been defined for all records
211: -- in the fv_1219_definitions_accts table. If not, the abort process.

Line 225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

221: error_msg := 'Agency Location Code is not defined for all the '||
222: 'records FMS Form 1219/1220 Report Definitions. '||
223: 'Please provide Agency Location Code '||
224: 'for all records and re-submit the process.';
225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
226: l_module_name||'.error1',error_msg);
227: RETURN;
228: END IF;
229:

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

231: INTO l_currency_code
232: FROM gl_ledgers_public_v
233: WHERE ledger_id = p_set_bks_id;
234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
237: ' CURRENCY CODE: '|| L_CURRENCY_CODE);
238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
239: 'PURGING TEMP TABLE ...');

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

232: FROM gl_ledgers_public_v
233: WHERE ledger_id = p_set_bks_id;
234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
237: ' CURRENCY CODE: '|| L_CURRENCY_CODE);
238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
239: 'PURGING TEMP TABLE ...');
240: END IF;

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

234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
237: ' CURRENCY CODE: '|| L_CURRENCY_CODE);
238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
239: 'PURGING TEMP TABLE ...');
240: END IF;
241: purge_temp_transactions;
242:

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

240: END IF;
241: purge_temp_transactions;
242:
243: IF p_error_code = 0 THEN
244: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
246: 'GETTING SEGMENT NAMES ...');
247: END IF;
248: get_balance_account_segments;

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

241: purge_temp_transactions;
242:
243: IF p_error_code = 0 THEN
244: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
246: 'GETTING SEGMENT NAMES ...');
247: END IF;
248: get_balance_account_segments;
249: ELSE

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

252: RETURN;
253: END IF;
254:
255: IF p_error_code = 0 THEN
256: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
258: 'GETTING PERIOD INFO ...');
259: END IF;
260: get_period_info;

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

253: END IF;
254:
255: IF p_error_code = 0 THEN
256: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
258: 'GETTING PERIOD INFO ...');
259: END IF;
260: get_period_info;
261: ELSE

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

264: RETURN;
265: END IF;
266:
267: IF p_error_code = 0 THEN
268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
269: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
270: 'INSERTING JOURNAL LINES ...');
271: END IF;
272: insert_batches;

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

265: END IF;
266:
267: IF p_error_code = 0 THEN
268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
269: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
270: 'INSERTING JOURNAL LINES ...');
271: END IF;
272: insert_batches;
273: ELSE

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

276: RETURN;
277: END IF;
278:
279: IF p_error_code = 0 THEN
280: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
282: 'PROCESSING 1219 TRANSACTIONS ...');
283: END IF;
284: process_1219_transactions;

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

277: END IF;
278:
279: IF p_error_code = 0 THEN
280: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
281: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
282: 'PROCESSING 1219 TRANSACTIONS ...');
283: END IF;
284: process_1219_transactions;
285: ELSE

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

288: RETURN;
289: END IF;
290:
291: IF p_error_code = 0 THEN
292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
293: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
294: 'PROCESSING VOID TRANSACTIONS ...');
295: END IF;
296: process_void_transactions ;

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

289: END IF;
290:
291: IF p_error_code = 0 THEN
292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
293: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
294: 'PROCESSING VOID TRANSACTIONS ...');
295: END IF;
296: process_void_transactions ;
297: ELSE

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

299: error_msg := p_error_msg;
300: RETURN;
301: END IF;
302:
303: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
305: 'ENDING MAIN_1219 ...');
306: END IF;
307: EXCEPTION

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

300: RETURN;
301: END IF;
302:
303: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
305: 'ENDING MAIN_1219 ...');
306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN

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

307: EXCEPTION
308: WHEN OTHERS THEN
309: p_error_code := 2;
310: p_error_msg := SQLERRM || ' -- Error in MAIN procedure.';
311: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
312: '.final_exception',p_error_msg);
313: IF TEMP_CURSOR%ISOPEN THEN
314: CLOSE TEMP_CURSOR;
315: END IF;

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

356: NULL ;
357: WHEN OTHERS THEN
358: p_error_code := 2;
359: p_error_msg := SQLERRM || ' -- Error in MAIN procedure.';
360: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
361: '.final_exception',p_error_msg);
362: RAISE;
363:
364: END PURGE_TEMP_TRANSACTIONS;

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

390: RETURN;
391: END IF;
392:
393:
394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
396: 'ACCOUNTING SEGMENT: '||GL_SEG_NAME);
397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
398: 'BALANCING SEGMENT: '||BL_SEG_NAME);

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

391: END IF;
392:
393:
394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
396: 'ACCOUNTING SEGMENT: '||GL_SEG_NAME);
397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
398: 'BALANCING SEGMENT: '||BL_SEG_NAME);
399: END IF;

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

393:
394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
396: 'ACCOUNTING SEGMENT: '||GL_SEG_NAME);
397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
398: 'BALANCING SEGMENT: '||BL_SEG_NAME);
399: END IF;
400:
401: EXCEPTION

Line 406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

402: WHEN OTHERS THEN
403: p_error_code := sqlcode ;
404: p_error_msg := SQLERRM || ' -- Error in '||
405: 'GET_BALANCE_ACCOUNT_SEGMENTS procedure.';
406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
407: l_module_name||'.final_exception',p_error_msg);
408: ROLLBACK ;
409: RETURN ;
410: END GET_BALANCE_ACCOUNT_SEGMENTS;

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

460: WHERE glp.period_year = l_period_year
461: AND gsob.ledger_id = p_set_bks_id
462: AND glp.period_set_name = gsob.period_set_name;
463:
464: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
466: 'YEAR START DATE: '||L_YR_START_DATE);
467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
468: 'YEAR END DATE: '||L_YR_END_DATE);

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

461: AND gsob.ledger_id = p_set_bks_id
462: AND glp.period_set_name = gsob.period_set_name;
463:
464: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
466: 'YEAR START DATE: '||L_YR_START_DATE);
467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
468: 'YEAR END DATE: '||L_YR_END_DATE);
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

463:
464: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
466: 'YEAR START DATE: '||L_YR_START_DATE);
467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
468: 'YEAR END DATE: '||L_YR_END_DATE);
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
470: 'PERIOD START DATE: '||L_START_DATE1);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
466: 'YEAR START DATE: '||L_YR_START_DATE);
467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
468: 'YEAR END DATE: '||L_YR_END_DATE);
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
470: 'PERIOD START DATE: '||L_START_DATE1);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
472: 'PERIOD END DATE: '||L_END_DATE1);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
468: 'YEAR END DATE: '||L_YR_END_DATE);
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
470: 'PERIOD START DATE: '||L_START_DATE1);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
472: 'PERIOD END DATE: '||L_END_DATE1);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
474: 'PERIOD YEAR: '||L_PERIOD_YEAR);
475: END IF;

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

469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
470: 'PERIOD START DATE: '||L_START_DATE1);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
472: 'PERIOD END DATE: '||L_END_DATE1);
473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
474: 'PERIOD YEAR: '||L_PERIOD_YEAR);
475: END IF;
476: EXCEPTION
477: WHEN OTHERS THEN

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

476: EXCEPTION
477: WHEN OTHERS THEN
478: p_error_code := 2;
479: p_error_msg := SQLERRM || ' -- Error in GET_PERIOD_INFO procedure.';
480: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
481: '.final_exception',p_error_msg);
482: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
483: 'ERROR STAGE: '||L_ERROR_STAGE);
484: RETURN;

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

478: p_error_code := 2;
479: p_error_msg := SQLERRM || ' -- Error in GET_PERIOD_INFO procedure.';
480: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||
481: '.final_exception',p_error_msg);
482: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
483: 'ERROR STAGE: '||L_ERROR_STAGE);
484: RETURN;
485: END GET_PERIOD_INFO;
486:

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

708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
714: l_module_name,'1. l_end_date1 : '||l_end_date1);
715: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
716: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
714: l_module_name,'1. l_end_date1 : '||l_end_date1);
715: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
716: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
717: END IF;

Line 715: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
714: l_module_name,'1. l_end_date1 : '||l_end_date1);
715: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
716: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
717: END IF;
718:
719: /* END for non-sla, upgraded 11i data */

Line 721: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

717: END IF;
718:
719: /* END for non-sla, upgraded 11i data */
720:
721: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
722: for upgraded 11i data ');
723:
724: /* Start for je_source is payables and je_category is non treasury */
725:

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

890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
896: l_module_name,'1. l_end_date1 : '||l_end_date1);
897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
898: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
896: l_module_name,'1. l_end_date1 : '||l_end_date1);
897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
898: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
899: END IF;

Line 897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
896: l_module_name,'1. l_end_date1 : '||l_end_date1);
897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
898: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
899: END IF;
900:
901: /* END for je_source is payables and je_category is non treasury*/

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

1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1072: l_module_name,'1. l_end_date1 : '||l_end_date1);
1073: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1074: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1072: l_module_name,'1. l_end_date1 : '||l_end_date1);
1073: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1074: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1075: END IF;

Line 1073: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1072: l_module_name,'1. l_end_date1 : '||l_end_date1);
1073: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1074: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1075: END IF;
1076:
1077: /* END for je_source is payables and je_category is non treasury*/

Line 1079: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1075: END IF;
1076:
1077: /* END for je_source is payables and je_category is non treasury*/
1078:
1079: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1080: for je_source is payables and je_category is non treasury');
1081:
1082:
1083: /* Start for je_source is payables and je_category is treasury confirmation */

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

1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1250: l_module_name,'1. l_end_date1 : '||l_end_date1);
1251: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1252: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1250: l_module_name,'1. l_end_date1 : '||l_end_date1);
1251: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1252: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1253: END IF;

Line 1251: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1250: l_module_name,'1. l_end_date1 : '||l_end_date1);
1251: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1252: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1253: END IF;
1254:
1255: /* END for je_source is payables and je_category is treasury confirmation */

Line 1256: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1252: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1253: END IF;
1254:
1255: /* END for je_source is payables and je_category is treasury confirmation */
1256: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1257: for je_source is payables and je_category is treasury confirmation');
1258:
1259: /* Start for je_source is project and je_category is labour_cost */
1260:

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

1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1426: l_module_name,'1. l_end_date1 : '||l_end_date1);
1427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1428: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1426: l_module_name,'1. l_end_date1 : '||l_end_date1);
1427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1428: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1429: END IF;

Line 1427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1426: l_module_name,'1. l_end_date1 : '||l_end_date1);
1427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1428: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1429: END IF;
1430:
1431: /* END for je_source is project and je_category is labour_cost */

Line 1433: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1429: END IF;
1430:
1431: /* END for je_source is project and je_category is labour_cost */
1432:
1433: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1434: for je_source is project and je_category is labour_cost');
1435:
1436: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
1437:

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

1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1606: l_module_name,'1. l_end_date1 : '||l_end_date1);
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1608: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1606: l_module_name,'1. l_end_date1 : '||l_end_date1);
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1608: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1609: END IF;

Line 1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1606: l_module_name,'1. l_end_date1 : '||l_end_date1);
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1608: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1609: END IF;
1610:
1611: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/

Line 1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1609: END IF;
1610:
1611: /* END for je_source is Receivables, based on ar_cash_receipt_history_all*/
1612:
1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1614: for je_source is Receivables, based on ar_cash_receipt_history_all');
1615:
1616: /* Start for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL*/
1617:

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

1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1787: l_module_name,'1. l_end_date1 : '||l_end_date1);
1788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1789: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1787: l_module_name,'1. l_end_date1 : '||l_end_date1);
1788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1789: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1790: END IF;

Line 1788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1787: l_module_name,'1. l_end_date1 : '||l_end_date1);
1788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1789: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1790: END IF;
1791:
1792: /* END for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL */

Line 1794: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1790: END IF;
1791:
1792: /* END for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL */
1793:
1794: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1795: for je_source is Receivables , based on AR_RECEIVABLE_APPLICATIONS_ALL ');
1796:
1797: /* Start for je_source is Receivables, based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
1798:

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

1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1967: l_module_name,'1. l_end_date1 : '||l_end_date1);
1968: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1969: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);

Line 1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1967: l_module_name,'1. l_end_date1 : '||l_end_date1);
1968: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1969: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1970: END IF;

Line 1968: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1967: l_module_name,'1. l_end_date1 : '||l_end_date1);
1968: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1969: l_module_name,'1. NUMBER OF ROWS INSERTED: '||l_row);
1970: END IF;
1971:
1972: /* END for je_source is Receivables, based on AR_MISC_CASH_DISTRIBUTIONS_ALL */

Line 1974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert

1970: END IF;
1971:
1972: /* END for je_source is Receivables, based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
1973:
1974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'End of Insert
1975: for je_source is Receivables , based on AR_MISC_CASH_DISTRIBUTIONS_ALL ');
1976:
1977:
1978: no_of_tran := 0;

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

1982: INTO no_of_tran
1983: FROM fv_sf1219_temp
1984: WHERE set_of_books_id = p_set_bks_id ;
1985:
1986: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1988: '2. l_end_date1 : '||l_end_date1);
1989: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1990: '2. NUMBER OF ROWS INSERTED: '||no_of_tran);

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

1983: FROM fv_sf1219_temp
1984: WHERE set_of_books_id = p_set_bks_id ;
1985:
1986: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1988: '2. l_end_date1 : '||l_end_date1);
1989: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1990: '2. NUMBER OF ROWS INSERTED: '||no_of_tran);
1991: END IF;

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

1985:
1986: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1988: '2. l_end_date1 : '||l_end_date1);
1989: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1990: '2. NUMBER OF ROWS INSERTED: '||no_of_tran);
1991: END IF;
1992:
1993: EXCEPTION

Line 1997: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1993: EXCEPTION
1994: WHEN OTHERS THEN
1995: p_error_code := 2;
1996: p_error_msg := SQLERRM || ' -- Error in INSERT_BATCHES procedure.';
1997: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1998: l_module_name||'.final_exception',p_error_msg);
1999: END INSERT_BATCHES;
2000:
2001:

Line 2091: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

2087: IF transaction_count = 0
2088: THEN
2089: p_error_code := 0;
2090: p_error_msg := 'No transaction activity for this period';
2091: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
2092: l_module_name||'.error1',p_error_msg);
2093: RETURN;
2094: ELSE
2095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2091: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
2092: l_module_name||'.error1',p_error_msg);
2093: RETURN;
2094: ELSE
2095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2097: 'FOUND '||TRANSACTION_COUNT||' RECORD(S).');
2098: END IF;
2099: END IF;

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

2092: l_module_name||'.error1',p_error_msg);
2093: RETURN;
2094: ELSE
2095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2097: 'FOUND '||TRANSACTION_COUNT||' RECORD(S).');
2098: END IF;
2099: END IF;
2100:

Line 2109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||

2105: FROM FV_Operating_units_all
2106: WHERE org_id = p_def_org_id;
2107: EXCEPTION
2108: WHEN No_Data_Found THEN
2109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||
2110: '.error2','PAYABLES IA PAYGROUP NOT FOUND, BASED ON THE ORG_ID '
2111: ||TO_CHAR(P_DEF_ORG_ID));
2112:
2113: WHEN OTHERS THEN

Line 2118: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

2114: p_error_code := 2;
2115: p_error_msg := SQLERRM || '-- Error in '||
2116: 'Process_1219_Transactions procedure '||
2117: 'while determining the payables ia paygroup.';
2118: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
2119: l_module_name||'.error3',p_error_msg);
2120: END ;
2121:
2122: OPEN TEMP_CURSOR;

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

2166: THEN
2167: EXIT;
2168: END IF;
2169:
2170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2172: l_module_name,'');
2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2174: l_module_name,'-------------------------------------------');

Line 2171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2167: EXIT;
2168: END IF;
2169:
2170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2172: l_module_name,'');
2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2174: l_module_name,'-------------------------------------------');
2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2169:
2170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2172: l_module_name,'');
2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2174: l_module_name,'-------------------------------------------');
2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2176: l_module_name,'L_BATCH_ID: '||L_BATCH_ID);
2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2172: l_module_name,'');
2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2174: l_module_name,'-------------------------------------------');
2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2176: l_module_name,'L_BATCH_ID: '||L_BATCH_ID);
2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2178: l_module_name,'L_FUND_CODE: '||L_FUND_CODE);
2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2174: l_module_name,'-------------------------------------------');
2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2176: l_module_name,'L_BATCH_ID: '||L_BATCH_ID);
2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2178: l_module_name,'L_FUND_CODE: '||L_FUND_CODE);
2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2180: l_module_name,'L_NAME: '||L_NAME);
2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2176: l_module_name,'L_BATCH_ID: '||L_BATCH_ID);
2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2178: l_module_name,'L_FUND_CODE: '||L_FUND_CODE);
2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2180: l_module_name,'L_NAME: '||L_NAME);
2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2182: l_module_name,'L_POSTED_DATE: '||L_POSTED_DATE);
2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2178: l_module_name,'L_FUND_CODE: '||L_FUND_CODE);
2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2180: l_module_name,'L_NAME: '||L_NAME);
2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2182: l_module_name,'L_POSTED_DATE: '||L_POSTED_DATE);
2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2184: l_module_name,'L_GL_PERIOD: '||L_GL_PERIOD);
2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2180: l_module_name,'L_NAME: '||L_NAME);
2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2182: l_module_name,'L_POSTED_DATE: '||L_POSTED_DATE);
2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2184: l_module_name,'L_GL_PERIOD: '||L_GL_PERIOD);
2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2186: l_module_name,'L_AMOUNT: '||L_AMOUNT);
2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2181: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2182: l_module_name,'L_POSTED_DATE: '||L_POSTED_DATE);
2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2184: l_module_name,'L_GL_PERIOD: '||L_GL_PERIOD);
2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2186: l_module_name,'L_AMOUNT: '||L_AMOUNT);
2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2188: l_module_name,'L_SF1219_TYPE_CODE: '||L_SF1219_TYPE_CODE);
2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2184: l_module_name,'L_GL_PERIOD: '||L_GL_PERIOD);
2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2186: l_module_name,'L_AMOUNT: '||L_AMOUNT);
2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2188: l_module_name,'L_SF1219_TYPE_CODE: '||L_SF1219_TYPE_CODE);
2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2190: l_module_name,'L_REFERENCE_1: '||L_REFERENCE_1);
2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2185: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2186: l_module_name,'L_AMOUNT: '||L_AMOUNT);
2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2188: l_module_name,'L_SF1219_TYPE_CODE: '||L_SF1219_TYPE_CODE);
2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2190: l_module_name,'L_REFERENCE_1: '||L_REFERENCE_1);
2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2192: l_module_name,'L_REFERENCE_2: '||L_REFERENCE_2);
2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2188: l_module_name,'L_SF1219_TYPE_CODE: '||L_SF1219_TYPE_CODE);
2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2190: l_module_name,'L_REFERENCE_1: '||L_REFERENCE_1);
2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2192: l_module_name,'L_REFERENCE_2: '||L_REFERENCE_2);
2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2194: l_module_name,'L_REFERENCE_3: '||L_REFERENCE_3);
2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2189: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2190: l_module_name,'L_REFERENCE_1: '||L_REFERENCE_1);
2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2192: l_module_name,'L_REFERENCE_2: '||L_REFERENCE_2);
2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2194: l_module_name,'L_REFERENCE_3: '||L_REFERENCE_3);
2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2196: l_module_name,'L_REFERENCE_4: '||L_REFERENCE_4);
2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2191: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2192: l_module_name,'L_REFERENCE_2: '||L_REFERENCE_2);
2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2194: l_module_name,'L_REFERENCE_3: '||L_REFERENCE_3);
2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2196: l_module_name,'L_REFERENCE_4: '||L_REFERENCE_4);
2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2198: l_module_name,'L_REFERENCE_5: '||L_REFERENCE_5);
2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2194: l_module_name,'L_REFERENCE_3: '||L_REFERENCE_3);
2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2196: l_module_name,'L_REFERENCE_4: '||L_REFERENCE_4);
2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2198: l_module_name,'L_REFERENCE_5: '||L_REFERENCE_5);
2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2200: l_module_name,'L_REFERENCE_6: '||L_REFERENCE_6);
2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2196: l_module_name,'L_REFERENCE_4: '||L_REFERENCE_4);
2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2198: l_module_name,'L_REFERENCE_5: '||L_REFERENCE_5);
2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2200: l_module_name,'L_REFERENCE_6: '||L_REFERENCE_6);
2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2202: l_module_name,'L_REFERENCE_9: '||L_REFERENCE_9);
2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2197: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2198: l_module_name,'L_REFERENCE_5: '||L_REFERENCE_5);
2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2200: l_module_name,'L_REFERENCE_6: '||L_REFERENCE_6);
2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2202: l_module_name,'L_REFERENCE_9: '||L_REFERENCE_9);
2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2204: l_module_name,'L_REPORTED_MONTH: '||L_REPORTED_MONTH);
2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2199: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2200: l_module_name,'L_REFERENCE_6: '||L_REFERENCE_6);
2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2202: l_module_name,'L_REFERENCE_9: '||L_REFERENCE_9);
2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2204: l_module_name,'L_REPORTED_MONTH: '||L_REPORTED_MONTH);
2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2206: l_module_name,'L_EXCEPTION_CATEGORY: '||L_EXCEPTION_CATEGORY);
2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2201: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2202: l_module_name,'L_REFERENCE_9: '||L_REFERENCE_9);
2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2204: l_module_name,'L_REPORTED_MONTH: '||L_REPORTED_MONTH);
2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2206: l_module_name,'L_EXCEPTION_CATEGORY: '||L_EXCEPTION_CATEGORY);
2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2208: l_module_name,'L_ACCOMPLISH_MONTH: '||L_ACCOMPLISH_MONTH);
2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2204: l_module_name,'L_REPORTED_MONTH: '||L_REPORTED_MONTH);
2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2206: l_module_name,'L_EXCEPTION_CATEGORY: '||L_EXCEPTION_CATEGORY);
2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2208: l_module_name,'L_ACCOMPLISH_MONTH: '||L_ACCOMPLISH_MONTH);
2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2210: l_module_name,'L_ACCOMPLISH_DATE: '||L_ACCOMPLISH_DATE);
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2205: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2206: l_module_name,'L_EXCEPTION_CATEGORY: '||L_EXCEPTION_CATEGORY);
2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2208: l_module_name,'L_ACCOMPLISH_MONTH: '||L_ACCOMPLISH_MONTH);
2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2210: l_module_name,'L_ACCOMPLISH_DATE: '||L_ACCOMPLISH_DATE);
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2212: l_module_name,'L_OBLIGATION_DATE: '||L_OBLIGATION_DATE);
2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2207: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2208: l_module_name,'L_ACCOMPLISH_MONTH: '||L_ACCOMPLISH_MONTH);
2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2210: l_module_name,'L_ACCOMPLISH_DATE: '||L_ACCOMPLISH_DATE);
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2212: l_module_name,'L_OBLIGATION_DATE: '||L_OBLIGATION_DATE);
2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2214: l_module_name,'L_INTER_AGENCY_FLAG: '||L_INTER_AGENCY_FLAG);
2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2209: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2210: l_module_name,'L_ACCOMPLISH_DATE: '||L_ACCOMPLISH_DATE);
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2212: l_module_name,'L_OBLIGATION_DATE: '||L_OBLIGATION_DATE);
2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2214: l_module_name,'L_INTER_AGENCY_FLAG: '||L_INTER_AGENCY_FLAG);
2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2216: l_module_name,'L_TREASURY_SYMBOL_ID: '||L_TREASURY_SYMBOL_ID);
2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2212: l_module_name,'L_OBLIGATION_DATE: '||L_OBLIGATION_DATE);
2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2214: l_module_name,'L_INTER_AGENCY_FLAG: '||L_INTER_AGENCY_FLAG);
2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2216: l_module_name,'L_TREASURY_SYMBOL_ID: '||L_TREASURY_SYMBOL_ID);
2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2218: l_module_name,'L_RECORD_TYPE: '||L_RECORD_TYPE);
2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2213: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2214: l_module_name,'L_INTER_AGENCY_FLAG: '||L_INTER_AGENCY_FLAG);
2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2216: l_module_name,'L_TREASURY_SYMBOL_ID: '||L_TREASURY_SYMBOL_ID);
2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2218: l_module_name,'L_RECORD_TYPE: '||L_RECORD_TYPE);
2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2220: l_module_name,'L_LINES_EXIST: '||L_LINES_EXIST);
2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2215: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2216: l_module_name,'L_TREASURY_SYMBOL_ID: '||L_TREASURY_SYMBOL_ID);
2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2218: l_module_name,'L_RECORD_TYPE: '||L_RECORD_TYPE);
2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2220: l_module_name,'L_LINES_EXIST: '||L_LINES_EXIST);
2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2222: l_module_name,'L_ALC_CODE: '||L_ALC_CODE);
2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2217: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2218: l_module_name,'L_RECORD_TYPE: '||L_RECORD_TYPE);
2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2220: l_module_name,'L_LINES_EXIST: '||L_LINES_EXIST);
2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2222: l_module_name,'L_ALC_CODE: '||L_ALC_CODE);
2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2224: l_module_name,'L_ORG_ID: '||L_ORG_ID);
2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2220: l_module_name,'L_LINES_EXIST: '||L_LINES_EXIST);
2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2222: l_module_name,'L_ALC_CODE: '||L_ALC_CODE);
2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2224: l_module_name,'L_ORG_ID: '||L_ORG_ID);
2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2226: l_module_name,'L_UPDATE_TYPE: '||L_UPDATE_TYPE);
2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2222: l_module_name,'L_ALC_CODE: '||L_ALC_CODE);
2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2224: l_module_name,'L_ORG_ID: '||L_ORG_ID);
2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2226: l_module_name,'L_UPDATE_TYPE: '||L_UPDATE_TYPE);
2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2228: l_module_name,'L_TYPE: '||L_TYPE);
2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2224: l_module_name,'L_ORG_ID: '||L_ORG_ID);
2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2226: l_module_name,'L_UPDATE_TYPE: '||L_UPDATE_TYPE);
2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2228: l_module_name,'L_TYPE: '||L_TYPE);
2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2230: l_module_name,'L_GL_PERIOD_NAME: '||L_GL_PERIOD_NAME);
2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2226: l_module_name,'L_UPDATE_TYPE: '||L_UPDATE_TYPE);
2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2228: l_module_name,'L_TYPE: '||L_TYPE);
2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2230: l_module_name,'L_GL_PERIOD_NAME: '||L_GL_PERIOD_NAME);
2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2232: l_module_name,'L_PROCESSED_FLAG: '||L_PROCESSED_FLAG);
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2228: l_module_name,'L_TYPE: '||L_TYPE);
2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2230: l_module_name,'L_GL_PERIOD_NAME: '||L_GL_PERIOD_NAME);
2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2232: l_module_name,'L_PROCESSED_FLAG: '||L_PROCESSED_FLAG);
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2234: l_module_name,'L_JE_HEADER_ID: '||L_JE_HEADER_ID);
2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2230: l_module_name,'L_GL_PERIOD_NAME: '||L_GL_PERIOD_NAME);
2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2232: l_module_name,'L_PROCESSED_FLAG: '||L_PROCESSED_FLAG);
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2234: l_module_name,'L_JE_HEADER_ID: '||L_JE_HEADER_ID);
2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2236: l_module_name,'L_JE_LINE_NUM: '||L_JE_LINE_NUM);
2237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2231: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2232: l_module_name,'L_PROCESSED_FLAG: '||L_PROCESSED_FLAG);
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2234: l_module_name,'L_JE_HEADER_ID: '||L_JE_HEADER_ID);
2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2236: l_module_name,'L_JE_LINE_NUM: '||L_JE_LINE_NUM);
2237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2238: l_module_name,'L_JE_FROM_SLA_FLAG: '||L_JE_FROM_SLA_FLAG);
2239: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

Line 2237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2234: l_module_name,'L_JE_HEADER_ID: '||L_JE_HEADER_ID);
2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2236: l_module_name,'L_JE_LINE_NUM: '||L_JE_LINE_NUM);
2237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2238: l_module_name,'L_JE_FROM_SLA_FLAG: '||L_JE_FROM_SLA_FLAG);
2239: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
2240: END IF;
2241:

Line 2239: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

2235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2236: l_module_name,'L_JE_LINE_NUM: '||L_JE_LINE_NUM);
2237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2238: l_module_name,'L_JE_FROM_SLA_FLAG: '||L_JE_FROM_SLA_FLAG);
2239: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
2240: END IF;
2241:
2242: -----------------------------------------------------------------------
2243: -- Initializing Variables

Line 2269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

2265: WHEN OTHERS THEN
2266: p_error_code := -1;
2267: p_error_msg := SUBSTR(sqlerrm,1,50||
2268: ': while fetching journal source');
2269: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
2270: l_module_name||'.error10',p_error_msg);
2271: RETURN;
2272: END;
2273:

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

2270: l_module_name||'.error10',p_error_msg);
2271: RETURN;
2272: END;
2273:
2274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2275: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2276: l_module_name,'SOURCE: '||V_JE_SOURCE);
2277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2278: l_module_name,'CATEGORY: '||V_JE_CATEGORY);

Line 2275: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2271: RETURN;
2272: END;
2273:
2274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2275: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2276: l_module_name,'SOURCE: '||V_JE_SOURCE);
2277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2278: l_module_name,'CATEGORY: '||V_JE_CATEGORY);
2279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

Line 2277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2273:
2274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2275: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2276: l_module_name,'SOURCE: '||V_JE_SOURCE);
2277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2278: l_module_name,'CATEGORY: '||V_JE_CATEGORY);
2279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
2280: END IF;
2281:

Line 2279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');

2275: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2276: l_module_name,'SOURCE: '||V_JE_SOURCE);
2277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2278: l_module_name,'CATEGORY: '||V_JE_CATEGORY);
2279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'');
2280: END IF;
2281:
2282: -----------------------------------------------------------------------------------
2283: -- Determine if the reference values for each row are not null and valid. Otherwise

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

2282: -----------------------------------------------------------------------------------
2283: -- Determine if the reference values for each row are not null and valid. Otherwise
2284: -- assign a value of MANUAL to l_name.
2285: -----------------------------------------------------------------------------------
2286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2288: l_module_name,'-> CHECK FOR MANUAL ...');
2289: END IF;
2290:

Line 2287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2283: -- Determine if the reference values for each row are not null and valid. Otherwise
2284: -- assign a value of MANUAL to l_name.
2285: -----------------------------------------------------------------------------------
2286: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2288: l_module_name,'-> CHECK FOR MANUAL ...');
2289: END IF;
2290:
2291: -- Accomplish date is obtained for records with batch name like TREASURY

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

2301: IF l_je_from_sla_flag IN ('N', 'U') THEN
2302: IF (v_je_source = 'Budgetary Transaction' AND
2303: v_je_category = 'Treasury Confirmation') -- Budgetary Transaction, = TC
2304: THEN
2305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2306: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2307: ' PROCESSING SOURCE = Budgetary Transaction, CATEGORY = TREASURY CONFIRMATION');
2308: END IF;
2309:

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

2302: IF (v_je_source = 'Budgetary Transaction' AND
2303: v_je_category = 'Treasury Confirmation') -- Budgetary Transaction, = TC
2304: THEN
2305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2306: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2307: ' PROCESSING SOURCE = Budgetary Transaction, CATEGORY = TREASURY CONFIRMATION');
2308: END IF;
2309:
2310: IF l_reference_1 IS NULL AND l_reference_6 IS NULL -- ref1

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

2309:
2310: IF l_reference_1 IS NULL AND l_reference_6 IS NULL -- ref1
2311: THEN
2312: l_name := 'MANUAL';
2313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2314: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2315: l_module_name,' REF_1 AND REF_6 ARE BOTH NULL, HENCE MANUAL');
2316: END IF;
2317: ELSIF l_reference_1 IS NOT NULL THEN

Line 2314: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2310: IF l_reference_1 IS NULL AND l_reference_6 IS NULL -- ref1
2311: THEN
2312: l_name := 'MANUAL';
2313: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2314: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2315: l_module_name,' REF_1 AND REF_6 ARE BOTH NULL, HENCE MANUAL');
2316: END IF;
2317: ELSIF l_reference_1 IS NOT NULL THEN
2318: BEGIN

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

2324:
2325: EXCEPTION
2326: WHEN NO_DATA_FOUND THEN
2327: l_name := 'MANUAL';
2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2330: l_module_name,
2331: ' NO_DATA_FOUND WHEN SELECTING FROM '||
2332: 'FV_TREASURY_CONFIRMATIONS_ALL WITH REF_1, HENCE MANUAL');

Line 2329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2325: EXCEPTION
2326: WHEN NO_DATA_FOUND THEN
2327: l_name := 'MANUAL';
2328: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2330: l_module_name,
2331: ' NO_DATA_FOUND WHEN SELECTING FROM '||
2332: 'FV_TREASURY_CONFIRMATIONS_ALL WITH REF_1, HENCE MANUAL');
2333: END IF;

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

2333: END IF;
2334:
2335: When INVALID_NUMBER OR VALUE_ERROR THEN
2336: l_name := 'MANUAL';
2337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2338: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2339: ' INVALID NUMBER ERROR, HENCE MANUAL');
2340: END IF;
2341: END ;

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

2334:
2335: When INVALID_NUMBER OR VALUE_ERROR THEN
2336: l_name := 'MANUAL';
2337: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2338: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2339: ' INVALID NUMBER ERROR, HENCE MANUAL');
2340: END IF;
2341: END ;
2342: ELSE

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

2353:
2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356: l_name := 'MANUAL';
2357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2358: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2359: ' NO_DATA_FOUND WHEN SELECTING '||
2360: 'FROM AP_CHECKS_ALL WITH REF_3, HENCE MANUAL');
2361: END IF;

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

2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356: l_name := 'MANUAL';
2357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2358: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2359: ' NO_DATA_FOUND WHEN SELECTING '||
2360: 'FROM AP_CHECKS_ALL WITH REF_3, HENCE MANUAL');
2361: END IF;
2362:

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

2361: END IF;
2362:
2363: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2364: l_name := 'MANUAL';
2365: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2366: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2367: l_module_name,
2368: ' INVALID NUMBER ERROR, HENCE MANUAL');
2369: END IF;

Line 2366: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2362:
2363: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2364: l_name := 'MANUAL';
2365: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2366: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2367: l_module_name,
2368: ' INVALID NUMBER ERROR, HENCE MANUAL');
2369: END IF;
2370: END;

Line 2385: IF (FND_LOG.LEVEL_STATEMENT >=

2381: l_ref6_date_check := l_reference_6;
2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: l_name := 'MANUAL';
2385: IF (FND_LOG.LEVEL_STATEMENT >=
2386: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2388: l_module_name,
2389: ' INVALID VALUE '||

Line 2386: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: l_name := 'MANUAL';
2385: IF (FND_LOG.LEVEL_STATEMENT >=
2386: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2388: l_module_name,
2389: ' INVALID VALUE '||
2390: ' FOR REF_6, ' ||

Line 2387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2383: WHEN OTHERS THEN
2384: l_name := 'MANUAL';
2385: IF (FND_LOG.LEVEL_STATEMENT >=
2386: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2388: l_module_name,
2389: ' INVALID VALUE '||
2390: ' FOR REF_6, ' ||
2391: ' HENCE MANUAL');

Line 2403: IF (FND_LOG.LEVEL_STATEMENT

2399: AND v_je_category <> 'Treasury Confirmation') -- Payables, <> TC
2400: THEN
2401: -- Check if ref_2/3/9 is NULL. If not, does it have a valid value.
2402: -- Else l_name is Manual.
2403: IF (FND_LOG.LEVEL_STATEMENT
2404: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2406: l_module_name,
2407: ' PROCESSING SOURCE = PAYABLES, '||

Line 2404: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2400: THEN
2401: -- Check if ref_2/3/9 is NULL. If not, does it have a valid value.
2402: -- Else l_name is Manual.
2403: IF (FND_LOG.LEVEL_STATEMENT
2404: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2406: l_module_name,
2407: ' PROCESSING SOURCE = PAYABLES, '||
2408: ' CATEGORY <> TREASURY CONFIRMATION');

Line 2405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2401: -- Check if ref_2/3/9 is NULL. If not, does it have a valid value.
2402: -- Else l_name is Manual.
2403: IF (FND_LOG.LEVEL_STATEMENT
2404: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2405: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2406: l_module_name,
2407: ' PROCESSING SOURCE = PAYABLES, '||
2408: ' CATEGORY <> TREASURY CONFIRMATION');
2409: END IF;

Line 2414: IF (FND_LOG.LEVEL_STATEMENT >=

2410:
2411: IF (l_reference_2 IS NULL) -- ref2
2412: THEN
2413: l_name := 'MANUAL';
2414: IF (FND_LOG.LEVEL_STATEMENT >=
2415: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2417: l_module_name,' REF_2 IS NULL');
2418: END IF;

Line 2415: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2411: IF (l_reference_2 IS NULL) -- ref2
2412: THEN
2413: l_name := 'MANUAL';
2414: IF (FND_LOG.LEVEL_STATEMENT >=
2415: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2417: l_module_name,' REF_2 IS NULL');
2418: END IF;
2419: ELSE

Line 2416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2412: THEN
2413: l_name := 'MANUAL';
2414: IF (FND_LOG.LEVEL_STATEMENT >=
2415: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2417: l_module_name,' REF_2 IS NULL');
2418: END IF;
2419: ELSE
2420: BEGIN

Line 2430: IF (FND_LOG.LEVEL_STATEMENT >=

2426:
2427: EXCEPTION
2428: WHEN NO_DATA_FOUND THEN
2429: l_name := 'MANUAL';
2430: IF (FND_LOG.LEVEL_STATEMENT >=
2431: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2433: l_module_name,
2434: ' NO_DATA_FOUND WHEN SELECTING' ||

Line 2431: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2427: EXCEPTION
2428: WHEN NO_DATA_FOUND THEN
2429: l_name := 'MANUAL';
2430: IF (FND_LOG.LEVEL_STATEMENT >=
2431: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2433: l_module_name,
2434: ' NO_DATA_FOUND WHEN SELECTING' ||
2435: ' FROM AP_INVOICES_ALL WITH REF_2, '||

Line 2432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2428: WHEN NO_DATA_FOUND THEN
2429: l_name := 'MANUAL';
2430: IF (FND_LOG.LEVEL_STATEMENT >=
2431: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2433: l_module_name,
2434: ' NO_DATA_FOUND WHEN SELECTING' ||
2435: ' FROM AP_INVOICES_ALL WITH REF_2, '||
2436: ' HENCE MANUAL');

Line 2441: IF (FND_LOG.LEVEL_STATEMENT >=

2437: END IF;
2438:
2439: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2440: l_name := 'MANUAL';
2441: IF (FND_LOG.LEVEL_STATEMENT >=
2442: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2444: l_module_name,
2445: ' INVALID NUMBER ERROR, '||

Line 2442: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2438:
2439: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2440: l_name := 'MANUAL';
2441: IF (FND_LOG.LEVEL_STATEMENT >=
2442: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2444: l_module_name,
2445: ' INVALID NUMBER ERROR, '||
2446: ' HENCE MANUAL');

Line 2443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2439: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2440: l_name := 'MANUAL';
2441: IF (FND_LOG.LEVEL_STATEMENT >=
2442: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2444: l_module_name,
2445: ' INVALID NUMBER ERROR, '||
2446: ' HENCE MANUAL');
2447: END IF;

Line 2454: IF (FND_LOG.LEVEL_STATEMENT >=

2450:
2451: IF (l_reference_3 IS NULL) -- ref3
2452: THEN
2453: l_name := 'MANUAL';
2454: IF (FND_LOG.LEVEL_STATEMENT >=
2455: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2456: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2457: l_module_name,' REF_3 IS NULL');
2458: END IF;

Line 2455: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2451: IF (l_reference_3 IS NULL) -- ref3
2452: THEN
2453: l_name := 'MANUAL';
2454: IF (FND_LOG.LEVEL_STATEMENT >=
2455: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2456: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2457: l_module_name,' REF_3 IS NULL');
2458: END IF;
2459: ELSE

Line 2456: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2452: THEN
2453: l_name := 'MANUAL';
2454: IF (FND_LOG.LEVEL_STATEMENT >=
2455: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2456: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2457: l_module_name,' REF_3 IS NULL');
2458: END IF;
2459: ELSE
2460: BEGIN

Line 2470: IF (FND_LOG.LEVEL_STATEMENT >=

2466:
2467: EXCEPTION
2468: WHEN NO_DATA_FOUND THEN
2469: l_name := 'MANUAL';
2470: IF (FND_LOG.LEVEL_STATEMENT >=
2471: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2473: l_module_name,
2474: ' NO_DATA_FOUND WHEN '||

Line 2471: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2467: EXCEPTION
2468: WHEN NO_DATA_FOUND THEN
2469: l_name := 'MANUAL';
2470: IF (FND_LOG.LEVEL_STATEMENT >=
2471: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2473: l_module_name,
2474: ' NO_DATA_FOUND WHEN '||
2475: ' SELECTING FROM AP_CHECKS_ALL '||

Line 2472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2468: WHEN NO_DATA_FOUND THEN
2469: l_name := 'MANUAL';
2470: IF (FND_LOG.LEVEL_STATEMENT >=
2471: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2473: l_module_name,
2474: ' NO_DATA_FOUND WHEN '||
2475: ' SELECTING FROM AP_CHECKS_ALL '||
2476: ' WITH REF_3, HENCE MANUAL');

Line 2481: IF (FND_LOG.LEVEL_STATEMENT >=

2477: END IF;
2478:
2479: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2480: l_name := 'MANUAL';
2481: IF (FND_LOG.LEVEL_STATEMENT >=
2482: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2483: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2484: l_module_name,' INVALID '||
2485: 'NUMBER ERROR, HENCE MANUAL');

Line 2482: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2478:
2479: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2480: l_name := 'MANUAL';
2481: IF (FND_LOG.LEVEL_STATEMENT >=
2482: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2483: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2484: l_module_name,' INVALID '||
2485: 'NUMBER ERROR, HENCE MANUAL');
2486: END IF;

Line 2483: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2479: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2480: l_name := 'MANUAL';
2481: IF (FND_LOG.LEVEL_STATEMENT >=
2482: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2483: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2484: l_module_name,' INVALID '||
2485: 'NUMBER ERROR, HENCE MANUAL');
2486: END IF;
2487: END;

Line 2493: IF (FND_LOG.LEVEL_STATEMENT >=

2489:
2490: IF (l_reference_9 IS NULL) -- ref9
2491: THEN
2492: l_name := 'MANUAL';
2493: IF (FND_LOG.LEVEL_STATEMENT >=
2494: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2496: l_module_name,' REF_9 IS NULL');
2497: END IF;

Line 2494: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2490: IF (l_reference_9 IS NULL) -- ref9
2491: THEN
2492: l_name := 'MANUAL';
2493: IF (FND_LOG.LEVEL_STATEMENT >=
2494: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2496: l_module_name,' REF_9 IS NULL');
2497: END IF;
2498: ELSE

Line 2495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2491: THEN
2492: l_name := 'MANUAL';
2493: IF (FND_LOG.LEVEL_STATEMENT >=
2494: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2496: l_module_name,' REF_9 IS NULL');
2497: END IF;
2498: ELSE
2499: BEGIN

Line 2508: IF (FND_LOG.LEVEL_STATEMENT

2504: AND org_id = p_def_org_id;
2505: EXCEPTION
2506: WHEN NO_DATA_FOUND THEN
2507: l_name := 'MANUAL';
2508: IF (FND_LOG.LEVEL_STATEMENT
2509: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2511: l_module_name,' NO_DATA_FOUND ' ||
2512: ' WHEN SELECTING FROM ' ||

Line 2509: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2505: EXCEPTION
2506: WHEN NO_DATA_FOUND THEN
2507: l_name := 'MANUAL';
2508: IF (FND_LOG.LEVEL_STATEMENT
2509: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2511: l_module_name,' NO_DATA_FOUND ' ||
2512: ' WHEN SELECTING FROM ' ||
2513: ' AP_INVOICE_PAYMENTS_ALL ' ||

Line 2510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2506: WHEN NO_DATA_FOUND THEN
2507: l_name := 'MANUAL';
2508: IF (FND_LOG.LEVEL_STATEMENT
2509: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2511: l_module_name,' NO_DATA_FOUND ' ||
2512: ' WHEN SELECTING FROM ' ||
2513: ' AP_INVOICE_PAYMENTS_ALL ' ||
2514: ' WITH REF_9, HENCE MANUAL');

Line 2519: IF (FND_LOG.LEVEL_STATEMENT >=

2515: END IF;
2516:
2517: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2518: l_name := 'MANUAL';
2519: IF (FND_LOG.LEVEL_STATEMENT >=
2520: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2522: l_module_name,
2523: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2520: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2516:
2517: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2518: l_name := 'MANUAL';
2519: IF (FND_LOG.LEVEL_STATEMENT >=
2520: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2522: l_module_name,
2523: ' INVALID NUMBER ERROR, HENCE MANUAL');
2524: END IF;

Line 2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2517: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2518: l_name := 'MANUAL';
2519: IF (FND_LOG.LEVEL_STATEMENT >=
2520: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2522: l_module_name,
2523: ' INVALID NUMBER ERROR, HENCE MANUAL');
2524: END IF;
2525: END;

Line 2534: IF (FND_LOG.LEVEL_STATEMENT >=

2530: vl_misc_cd_flag := 'N';
2531:
2532: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2533: THEN
2534: IF (FND_LOG.LEVEL_STATEMENT >=
2535: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2537: l_module_name,' PROCESSING A MISC RECEIPT');
2538: END IF;

Line 2535: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2531:
2532: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2533: THEN
2534: IF (FND_LOG.LEVEL_STATEMENT >=
2535: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2537: l_module_name,' PROCESSING A MISC RECEIPT');
2538: END IF;
2539:

Line 2536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2532: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2533: THEN
2534: IF (FND_LOG.LEVEL_STATEMENT >=
2535: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2537: l_module_name,' PROCESSING A MISC RECEIPT');
2538: END IF;
2539:
2540: BEGIN

Line 2547: IF (FND_LOG.LEVEL_STATEMENT >=

2543: EXCEPTION
2544: WHEN INVALID_NUMBER OR VALUE_ERROR
2545: THEN
2546: l_name := 'MANUAL';
2547: IF (FND_LOG.LEVEL_STATEMENT >=
2548: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2550: l_module_name,
2551: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2548: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2544: WHEN INVALID_NUMBER OR VALUE_ERROR
2545: THEN
2546: l_name := 'MANUAL';
2547: IF (FND_LOG.LEVEL_STATEMENT >=
2548: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2550: l_module_name,
2551: ' INVALID NUMBER ERROR, HENCE MANUAL');
2552: END IF;

Line 2549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2545: THEN
2546: l_name := 'MANUAL';
2547: IF (FND_LOG.LEVEL_STATEMENT >=
2548: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2549: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2550: l_module_name,
2551: ' INVALID NUMBER ERROR, HENCE MANUAL');
2552: END IF;
2553: END;

Line 2556: IF (FND_LOG.LEVEL_STATEMENT >=

2552: END IF;
2553: END;
2554:
2555: ELSE
2556: IF (FND_LOG.LEVEL_STATEMENT >=
2557: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2558: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2559: l_module_name,
2560: ' PROCESSING A TRADE RECEIPT OR OTHER');

Line 2557: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2553: END;
2554:
2555: ELSE
2556: IF (FND_LOG.LEVEL_STATEMENT >=
2557: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2558: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2559: l_module_name,
2560: ' PROCESSING A TRADE RECEIPT OR OTHER');
2561: END IF;

Line 2558: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2554:
2555: ELSE
2556: IF (FND_LOG.LEVEL_STATEMENT >=
2557: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2558: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2559: l_module_name,
2560: ' PROCESSING A TRADE RECEIPT OR OTHER');
2561: END IF;
2562:

Line 2573: IF (FND_LOG.LEVEL_STATEMENT >=

2569: EXCEPTION
2570: WHEN INVALID_NUMBER OR VALUE_ERROR
2571: THEN
2572: l_name := 'MANUAL';
2573: IF (FND_LOG.LEVEL_STATEMENT >=
2574: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2576: l_module_name,
2577: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2574: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2570: WHEN INVALID_NUMBER OR VALUE_ERROR
2571: THEN
2572: l_name := 'MANUAL';
2573: IF (FND_LOG.LEVEL_STATEMENT >=
2574: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2576: l_module_name,
2577: ' INVALID NUMBER ERROR, HENCE MANUAL');
2578: END IF;

Line 2575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2571: THEN
2572: l_name := 'MANUAL';
2573: IF (FND_LOG.LEVEL_STATEMENT >=
2574: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2576: l_module_name,
2577: ' INVALID NUMBER ERROR, HENCE MANUAL');
2578: END IF;
2579: END;

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

2578: END IF;
2579: END;
2580: END IF; -- Misc Receipts
2581:
2582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2584: l_module_name,' REFERENCE_2 = '||L_REFERENCE_2);
2585: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2586: l_module_name,' CASH RECEIPT ID = '||

Line 2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2579: END;
2580: END IF; -- Misc Receipts
2581:
2582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2584: l_module_name,' REFERENCE_2 = '||L_REFERENCE_2);
2585: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2586: l_module_name,' CASH RECEIPT ID = '||
2587: TO_NUMBER(L_CASH_RECEIPT_ID));

Line 2585: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2581:
2582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2584: l_module_name,' REFERENCE_2 = '||L_REFERENCE_2);
2585: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2586: l_module_name,' CASH RECEIPT ID = '||
2587: TO_NUMBER(L_CASH_RECEIPT_ID));
2588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2589: l_module_name,' CASH RECEIPT HISTORY ID = '

Line 2588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2584: l_module_name,' REFERENCE_2 = '||L_REFERENCE_2);
2585: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2586: l_module_name,' CASH RECEIPT ID = '||
2587: TO_NUMBER(L_CASH_RECEIPT_ID));
2588: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2589: l_module_name,' CASH RECEIPT HISTORY ID = '
2590: ||TO_NUMBER(L_CASH_RECEIPT_HIST_ID));
2591: END IF;
2592:

Line 2607: IF (FND_LOG.LEVEL_STATEMENT >=

2603: FROM Ar_Cash_Receipts_All
2604: WHERE cash_receipt_id = to_number(l_cash_receipt_id)
2605: AND org_id = p_def_org_id;
2606:
2607: IF (FND_LOG.LEVEL_STATEMENT >=
2608: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2610: l_module_name,' CASH RECEIPT ID ' ||
2611: ' EXISTS IN AR_CASH_RECEIPTS_ALL.');

Line 2608: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2604: WHERE cash_receipt_id = to_number(l_cash_receipt_id)
2605: AND org_id = p_def_org_id;
2606:
2607: IF (FND_LOG.LEVEL_STATEMENT >=
2608: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2610: l_module_name,' CASH RECEIPT ID ' ||
2611: ' EXISTS IN AR_CASH_RECEIPTS_ALL.');
2612: END IF;

Line 2609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2605: AND org_id = p_def_org_id;
2606:
2607: IF (FND_LOG.LEVEL_STATEMENT >=
2608: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2609: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2610: l_module_name,' CASH RECEIPT ID ' ||
2611: ' EXISTS IN AR_CASH_RECEIPTS_ALL.');
2612: END IF;
2613: EXCEPTION

Line 2616: IF (FND_LOG.LEVEL_STATEMENT >=

2612: END IF;
2613: EXCEPTION
2614: WHEN NO_DATA_FOUND THEN
2615: l_name := 'MANUAL';
2616: IF (FND_LOG.LEVEL_STATEMENT >=
2617: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2618: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2619: l_module_name,' NO_DATA_FOUND'
2620: || 'WHEN SELECTING FROM '||

Line 2617: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2613: EXCEPTION
2614: WHEN NO_DATA_FOUND THEN
2615: l_name := 'MANUAL';
2616: IF (FND_LOG.LEVEL_STATEMENT >=
2617: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2618: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2619: l_module_name,' NO_DATA_FOUND'
2620: || 'WHEN SELECTING FROM '||
2621: 'AR_CASH_RECEIPTS_ALL, ' ||

Line 2618: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2614: WHEN NO_DATA_FOUND THEN
2615: l_name := 'MANUAL';
2616: IF (FND_LOG.LEVEL_STATEMENT >=
2617: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2618: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2619: l_module_name,' NO_DATA_FOUND'
2620: || 'WHEN SELECTING FROM '||
2621: 'AR_CASH_RECEIPTS_ALL, ' ||
2622: ' HENCE MANUAL');

Line 2627: IF (FND_LOG.LEVEL_STATEMENT >=

2623: END IF;
2624:
2625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2626: l_name := 'MANUAL';
2627: IF (FND_LOG.LEVEL_STATEMENT >=
2628: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2629: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2630: l_module_name,
2631: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2628: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2624:
2625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2626: l_name := 'MANUAL';
2627: IF (FND_LOG.LEVEL_STATEMENT >=
2628: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2629: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2630: l_module_name,
2631: ' INVALID NUMBER ERROR, HENCE MANUAL');
2632: END IF;

Line 2629: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2625: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2626: l_name := 'MANUAL';
2627: IF (FND_LOG.LEVEL_STATEMENT >=
2628: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2629: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2630: l_module_name,
2631: ' INVALID NUMBER ERROR, HENCE MANUAL');
2632: END IF;
2633: END;

Line 2643: IF (FND_LOG.LEVEL_STATEMENT >=

2639: WHERE cash_receipt_history_id =
2640: to_number(l_cash_receipt_hist_id)
2641: AND org_id = p_def_org_id;
2642:
2643: IF (FND_LOG.LEVEL_STATEMENT >=
2644: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2646: l_module_name,' CASH RECEIPT HIST '||
2647: 'ID EXISTS IN AR_CASH_RECEIPT_HISTORY_ALL.');

Line 2644: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2640: to_number(l_cash_receipt_hist_id)
2641: AND org_id = p_def_org_id;
2642:
2643: IF (FND_LOG.LEVEL_STATEMENT >=
2644: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2646: l_module_name,' CASH RECEIPT HIST '||
2647: 'ID EXISTS IN AR_CASH_RECEIPT_HISTORY_ALL.');
2648: END IF;

Line 2645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2641: AND org_id = p_def_org_id;
2642:
2643: IF (FND_LOG.LEVEL_STATEMENT >=
2644: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2646: l_module_name,' CASH RECEIPT HIST '||
2647: 'ID EXISTS IN AR_CASH_RECEIPT_HISTORY_ALL.');
2648: END IF;
2649: EXCEPTION

Line 2653: IF (FND_LOG.LEVEL_STATEMENT >=

2649: EXCEPTION
2650: WHEN NO_DATA_FOUND THEN
2651: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2652: THEN
2653: IF (FND_LOG.LEVEL_STATEMENT >=
2654: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2655: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2656: l_module_name,' FOR MISC RECEIPT: ' ||
2657: 'CASH RECEIPT HIST ID DOES NOT '||

Line 2654: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2650: WHEN NO_DATA_FOUND THEN
2651: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2652: THEN
2653: IF (FND_LOG.LEVEL_STATEMENT >=
2654: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2655: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2656: l_module_name,' FOR MISC RECEIPT: ' ||
2657: 'CASH RECEIPT HIST ID DOES NOT '||
2658: 'exist in Ar_Cash_Receipt_History_All table. ' ||

Line 2655: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2651: IF (v_je_category = 'Misc Receipts') -- Misc Receipts
2652: THEN
2653: IF (FND_LOG.LEVEL_STATEMENT >=
2654: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2655: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2656: l_module_name,' FOR MISC RECEIPT: ' ||
2657: 'CASH RECEIPT HIST ID DOES NOT '||
2658: 'exist in Ar_Cash_Receipt_History_All table. ' ||
2659: 'Checking in Ar_Misc_Cash_Distributions_All table.');

Line 2664: IF (FND_LOG.LEVEL_STATEMENT >=

2660: END IF;
2661: l_exists := 'M';
2662:
2663: ELSE
2664: IF (FND_LOG.LEVEL_STATEMENT >=
2665: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2667: l_module_name,' FOR TRADE RECEIPT: ' ||
2668: 'CASH RECEIPT HIST ID DOES NOT '||

Line 2665: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2661: l_exists := 'M';
2662:
2663: ELSE
2664: IF (FND_LOG.LEVEL_STATEMENT >=
2665: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2667: l_module_name,' FOR TRADE RECEIPT: ' ||
2668: 'CASH RECEIPT HIST ID DOES NOT '||
2669: 'exist in Ar_Cash_Receipt_History_All table. ' ||

Line 2666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2662:
2663: ELSE
2664: IF (FND_LOG.LEVEL_STATEMENT >=
2665: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2667: l_module_name,' FOR TRADE RECEIPT: ' ||
2668: 'CASH RECEIPT HIST ID DOES NOT '||
2669: 'exist in Ar_Cash_Receipt_History_All table. ' ||
2670: ' Checking in Ar_Receivable_Applications_All table.');

Line 2677: IF (FND_LOG.LEVEL_STATEMENT >=

2673: END IF; -- Misc Receipts
2674:
2675: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2676: l_name := 'MANUAL';
2677: IF (FND_LOG.LEVEL_STATEMENT >=
2678: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2680: l_module_name,' INVALID NUMBER ' ||
2681: 'ERROR, HENCE MANUAL');

Line 2678: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2674:
2675: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2676: l_name := 'MANUAL';
2677: IF (FND_LOG.LEVEL_STATEMENT >=
2678: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2680: l_module_name,' INVALID NUMBER ' ||
2681: 'ERROR, HENCE MANUAL');
2682: END IF;

Line 2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2675: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2676: l_name := 'MANUAL';
2677: IF (FND_LOG.LEVEL_STATEMENT >=
2678: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2680: l_module_name,' INVALID NUMBER ' ||
2681: 'ERROR, HENCE MANUAL');
2682: END IF;
2683: END;

Line 2698: IF (FND_LOG.LEVEL_STATEMENT >=

2694: AND org_id = p_def_org_id;
2695:
2696: l_cash_receipt_hist_id := l_temp_cr_hist_id;
2697:
2698: IF (FND_LOG.LEVEL_STATEMENT >=
2699: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2700: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2701: l_module_name,' CASH RECEIPT HIST ID '||
2702: L_CASH_RECEIPT_HIST_ID ||', EXISTS IN '||

Line 2699: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2695:
2696: l_cash_receipt_hist_id := l_temp_cr_hist_id;
2697:
2698: IF (FND_LOG.LEVEL_STATEMENT >=
2699: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2700: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2701: l_module_name,' CASH RECEIPT HIST ID '||
2702: L_CASH_RECEIPT_HIST_ID ||', EXISTS IN '||
2703: 'Ar_Receivable_Applications_All. Checking in ' ||

Line 2700: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2696: l_cash_receipt_hist_id := l_temp_cr_hist_id;
2697:
2698: IF (FND_LOG.LEVEL_STATEMENT >=
2699: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2700: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2701: l_module_name,' CASH RECEIPT HIST ID '||
2702: L_CASH_RECEIPT_HIST_ID ||', EXISTS IN '||
2703: 'Ar_Receivable_Applications_All. Checking in ' ||
2704: ' Ar_Cash_Receipt_History_All to see' ||

Line 2716: IF (FND_LOG.LEVEL_STATEMENT >=

2712: WHERE cash_receipt_history_id =
2713: TO_NUMBER(l_cash_receipt_hist_id)
2714: AND org_id = p_def_org_id;
2715:
2716: IF (FND_LOG.LEVEL_STATEMENT >=
2717: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name,' CASH RECEIPT HIST ID ' ||
2720: ' EXISTS IN THE AR_CASH_RECEIPT_HISTORY_ALL '

Line 2717: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2713: TO_NUMBER(l_cash_receipt_hist_id)
2714: AND org_id = p_def_org_id;
2715:
2716: IF (FND_LOG.LEVEL_STATEMENT >=
2717: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name,' CASH RECEIPT HIST ID ' ||
2720: ' EXISTS IN THE AR_CASH_RECEIPT_HISTORY_ALL '
2721: ||' TABLE.');

Line 2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2714: AND org_id = p_def_org_id;
2715:
2716: IF (FND_LOG.LEVEL_STATEMENT >=
2717: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name,' CASH RECEIPT HIST ID ' ||
2720: ' EXISTS IN THE AR_CASH_RECEIPT_HISTORY_ALL '
2721: ||' TABLE.');
2722: END IF;

Line 2726: IF (FND_LOG.LEVEL_STATEMENT >=

2722: END IF;
2723: EXCEPTION
2724: WHEN NO_DATA_FOUND THEN
2725: l_name := 'MANUAL';
2726: IF (FND_LOG.LEVEL_STATEMENT >=
2727: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2728: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2729: l_module_name,' NO_DATA_FOUND ' ||
2730: ' WHEN SELECTING FROM '||

Line 2727: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2723: EXCEPTION
2724: WHEN NO_DATA_FOUND THEN
2725: l_name := 'MANUAL';
2726: IF (FND_LOG.LEVEL_STATEMENT >=
2727: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2728: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2729: l_module_name,' NO_DATA_FOUND ' ||
2730: ' WHEN SELECTING FROM '||
2731: ' AR_CASH_RECEIPT_HISTORY_ALL, ' ||

Line 2728: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2724: WHEN NO_DATA_FOUND THEN
2725: l_name := 'MANUAL';
2726: IF (FND_LOG.LEVEL_STATEMENT >=
2727: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2728: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2729: l_module_name,' NO_DATA_FOUND ' ||
2730: ' WHEN SELECTING FROM '||
2731: ' AR_CASH_RECEIPT_HISTORY_ALL, ' ||
2732: 'HENCE MANUAL');

Line 2737: IF (FND_LOG.LEVEL_STATEMENT >=

2733: END IF;
2734:
2735: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2736: l_name := 'MANUAL';
2737: IF (FND_LOG.LEVEL_STATEMENT >=
2738: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2740: l_module_name,
2741: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2738: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2734:
2735: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2736: l_name := 'MANUAL';
2737: IF (FND_LOG.LEVEL_STATEMENT >=
2738: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2740: l_module_name,
2741: ' INVALID NUMBER ERROR, HENCE MANUAL');
2742: END IF;

Line 2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2735: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2736: l_name := 'MANUAL';
2737: IF (FND_LOG.LEVEL_STATEMENT >=
2738: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2740: l_module_name,
2741: ' INVALID NUMBER ERROR, HENCE MANUAL');
2742: END IF;
2743: END;

Line 2747: IF (FND_LOG.LEVEL_STATEMENT >=

2743: END;
2744: EXCEPTION
2745: WHEN NO_DATA_FOUND THEN
2746: l_name := 'MANUAL';
2747: IF (FND_LOG.LEVEL_STATEMENT >=
2748: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2750: l_module_name,
2751: ' NO_DATA_FOUND WHEN '||

Line 2748: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2744: EXCEPTION
2745: WHEN NO_DATA_FOUND THEN
2746: l_name := 'MANUAL';
2747: IF (FND_LOG.LEVEL_STATEMENT >=
2748: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2750: l_module_name,
2751: ' NO_DATA_FOUND WHEN '||
2752: ' SELECTING FROM AR_RECEIVABLE' ||

Line 2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2745: WHEN NO_DATA_FOUND THEN
2746: l_name := 'MANUAL';
2747: IF (FND_LOG.LEVEL_STATEMENT >=
2748: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2750: l_module_name,
2751: ' NO_DATA_FOUND WHEN '||
2752: ' SELECTING FROM AR_RECEIVABLE' ||
2753: '_APPLICATIONS_ALL, HENCE MANUAL');

Line 2758: IF (FND_LOG.LEVEL_STATEMENT

2754: END IF;
2755:
2756: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2757: l_name := 'MANUAL';
2758: IF (FND_LOG.LEVEL_STATEMENT
2759: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2761: l_module_name,
2762: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2759: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2755:
2756: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2757: l_name := 'MANUAL';
2758: IF (FND_LOG.LEVEL_STATEMENT
2759: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2761: l_module_name,
2762: ' INVALID NUMBER ERROR, HENCE MANUAL');
2763: END IF;

Line 2760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2756: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2757: l_name := 'MANUAL';
2758: IF (FND_LOG.LEVEL_STATEMENT
2759: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2761: l_module_name,
2762: ' INVALID NUMBER ERROR, HENCE MANUAL');
2763: END IF;
2764:

Line 2776: IF (FND_LOG.LEVEL_STATEMENT >=

2772: WHERE misc_cash_distribution_id =
2773: TO_NUMBER(l_cash_receipt_hist_id)
2774: AND org_id = p_def_org_id;
2775:
2776: IF (FND_LOG.LEVEL_STATEMENT >=
2777: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2779: l_module_name,
2780: ' MISC CASH DISTRIBUTION ID EXISTS IN '||

Line 2777: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2773: TO_NUMBER(l_cash_receipt_hist_id)
2774: AND org_id = p_def_org_id;
2775:
2776: IF (FND_LOG.LEVEL_STATEMENT >=
2777: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2779: l_module_name,
2780: ' MISC CASH DISTRIBUTION ID EXISTS IN '||
2781: 'Ar_Misc_Cash_Distributions_All table and is '||

Line 2778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2774: AND org_id = p_def_org_id;
2775:
2776: IF (FND_LOG.LEVEL_STATEMENT >=
2777: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2778: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2779: l_module_name,
2780: ' MISC CASH DISTRIBUTION ID EXISTS IN '||
2781: 'Ar_Misc_Cash_Distributions_All table and is '||
2782: TO_NUMBER(l_cash_receipt_hist_id));

Line 2789: IF (FND_LOG.LEVEL_STATEMENT >=

2785: vl_misc_cd_flag := 'Y';
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: l_name := 'MANUAL';
2789: IF (FND_LOG.LEVEL_STATEMENT >=
2790: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2792: l_module_name,
2793: ' NO_DATA_FOUND WHEN '||

Line 2790: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: l_name := 'MANUAL';
2789: IF (FND_LOG.LEVEL_STATEMENT >=
2790: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2792: l_module_name,
2793: ' NO_DATA_FOUND WHEN '||
2794: ' SELECTING FROM AR_MISC_CASH_' ||

Line 2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2787: WHEN NO_DATA_FOUND THEN
2788: l_name := 'MANUAL';
2789: IF (FND_LOG.LEVEL_STATEMENT >=
2790: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2792: l_module_name,
2793: ' NO_DATA_FOUND WHEN '||
2794: ' SELECTING FROM AR_MISC_CASH_' ||
2795: 'DISTRIBUTIONS_ALL, HENCE MANUAL');

Line 2800: IF (FND_LOG.LEVEL_STATEMENT >=

2796: END IF;
2797:
2798: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2799: l_name := 'MANUAL';
2800: IF (FND_LOG.LEVEL_STATEMENT >=
2801: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2803: l_module_name,
2804: ' INVALID NUMBER ERROR, HENCE MANUAL');

Line 2801: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2797:
2798: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2799: l_name := 'MANUAL';
2800: IF (FND_LOG.LEVEL_STATEMENT >=
2801: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2803: l_module_name,
2804: ' INVALID NUMBER ERROR, HENCE MANUAL');
2805: END IF;

Line 2802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2798: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2799: l_name := 'MANUAL';
2800: IF (FND_LOG.LEVEL_STATEMENT >=
2801: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2803: l_module_name,
2804: ' INVALID NUMBER ERROR, HENCE MANUAL');
2805: END IF;
2806: END;

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

2810: -- Reference Validity Check
2811: END IF; -- l_je_from_sla_flag
2812:
2813:
2814: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2816: ' L_NAME: '||L_NAME);
2817: END IF;
2818:

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

2811: END IF; -- l_je_from_sla_flag
2812:
2813:
2814: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2816: ' L_NAME: '||L_NAME);
2817: END IF;
2818:
2819: -------------------------------------------

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

2821: -------------------------------------------
2822: IF (l_name <> 'MANUAL')
2823: THEN -- <> Manual
2824:
2825: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2826: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2827: l_module_name,'-> FIND ALC ...');
2828: END IF;
2829:

Line 2826: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2822: IF (l_name <> 'MANUAL')
2823: THEN -- <> Manual
2824:
2825: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2826: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2827: l_module_name,'-> FIND ALC ...');
2828: END IF;
2829:
2830: IF (v_je_source = 'Receivables')

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

2829:
2830: IF (v_je_source = 'Receivables')
2831: THEN -- Source Check to find ALC
2832:
2833: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2834: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2835: l_module_name,
2836: ' GETTING ALC FOR SOURCE = ' ||
2837: ' RECEIVABLES ...');

Line 2834: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2830: IF (v_je_source = 'Receivables')
2831: THEN -- Source Check to find ALC
2832:
2833: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2834: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2835: l_module_name,
2836: ' GETTING ALC FOR SOURCE = ' ||
2837: ' RECEIVABLES ...');
2838: END IF;

Line 2880: IF (FND_LOG.LEVEL_STATEMENT

2876: END IF;
2877:
2878: EXCEPTION
2879: WHEN NO_DATA_FOUND THEN
2880: IF (FND_LOG.LEVEL_STATEMENT
2881: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2883: l_module_name,' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
2884: END IF;

Line 2881: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2877:
2878: EXCEPTION
2879: WHEN NO_DATA_FOUND THEN
2880: IF (FND_LOG.LEVEL_STATEMENT
2881: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2883: l_module_name,' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
2884: END IF;
2885: END;

Line 2882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2878: EXCEPTION
2879: WHEN NO_DATA_FOUND THEN
2880: IF (FND_LOG.LEVEL_STATEMENT
2881: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2883: l_module_name,' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
2884: END IF;
2885: END;
2886:

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

2886:
2887: ELSIF v_je_source = 'Budgetary Transaction'
2888: AND v_je_category = 'Treasury Confirmation' THEN
2889:
2890: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2892: l_module_name,
2893: ' GETTING ALC FOR SOURCE = '||
2894: ' Budgetary Transaction, CATEGORY = TREASURY ' ||

Line 2891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2887: ELSIF v_je_source = 'Budgetary Transaction'
2888: AND v_je_category = 'Treasury Confirmation' THEN
2889:
2890: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2892: l_module_name,
2893: ' GETTING ALC FOR SOURCE = '||
2894: ' Budgetary Transaction, CATEGORY = TREASURY ' ||
2895: 'CONFIRMATION ...');

Line 2962: IF (FND_LOG.LEVEL_STATEMENT >=

2958: END IF;
2959:
2960: EXCEPTION
2961: WHEN NO_DATA_FOUND THEN
2962: IF (FND_LOG.LEVEL_STATEMENT >=
2963: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2964: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2965: l_module_name,
2966: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');

Line 2963: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2959:
2960: EXCEPTION
2961: WHEN NO_DATA_FOUND THEN
2962: IF (FND_LOG.LEVEL_STATEMENT >=
2963: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2964: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2965: l_module_name,
2966: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
2967: END IF;

Line 2964: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2960: EXCEPTION
2961: WHEN NO_DATA_FOUND THEN
2962: IF (FND_LOG.LEVEL_STATEMENT >=
2963: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2964: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2965: l_module_name,
2966: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
2967: END IF;
2968: END;

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

2970:
2971: ELSIF (v_je_source = 'Payables'
2972: AND v_je_category <> 'Treasury Confirmation') THEN
2973:
2974: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2975: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2976: l_module_name,' GETTING ALC FOR SOURCE = ' ||
2977: ' PAYABLES, CATEGORY <> TREASURY CONFIRMATION ...');
2978: END IF;

Line 2975: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2971: ELSIF (v_je_source = 'Payables'
2972: AND v_je_category <> 'Treasury Confirmation') THEN
2973:
2974: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2975: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2976: l_module_name,' GETTING ALC FOR SOURCE = ' ||
2977: ' PAYABLES, CATEGORY <> TREASURY CONFIRMATION ...');
2978: END IF;
2979:

Line 3010: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3006: p_error_code := 2;
3007: p_error_msg := SQLERRM||'--Error while deriving ' ||
3008: 'the org_id, in the '||
3009: 'procedure Process_1219_Transactions.';
3010: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3011: l_module_name||'.error20',p_error_msg);
3012: END;
3013:
3014:

Line 3015: IF (FND_LOG.LEVEL_STATEMENT

3011: l_module_name||'.error20',p_error_msg);
3012: END;
3013:
3014:
3015: IF (FND_LOG.LEVEL_STATEMENT
3016: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3018: ' ORG ID OF THE TXN IS '||TO_CHAR(L_ORG_ID));
3019: END IF;

Line 3016: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3012: END;
3013:
3014:
3015: IF (FND_LOG.LEVEL_STATEMENT
3016: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3018: ' ORG ID OF THE TXN IS '||TO_CHAR(L_ORG_ID));
3019: END IF;
3020:

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

3013:
3014:
3015: IF (FND_LOG.LEVEL_STATEMENT
3016: >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3018: ' ORG ID OF THE TXN IS '||TO_CHAR(L_ORG_ID));
3019: END IF;
3020:
3021: IF l_org_id IS NULL THEN

Line 3035: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3031: p_error_code := 2;
3032: p_error_msg := SQLERRM ||'--Error while deriving the '||
3033: 'payables_ia_paygroup in the procedure '||
3034: ' Process_1219_Transactions';
3035: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3036: l_module_name||'.error21',p_error_msg);
3037: END;
3038: END IF;
3039:

Line 3040: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3036: l_module_name||'.error21',p_error_msg);
3037: END;
3038: END IF;
3039:
3040: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3041: then
3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3043: l_module_name,
3044: ' PAYBLES PAY GROUP IS '||L_PAYABLES_IA_PAYGROUP);

Line 3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3038: END IF;
3039:
3040: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3041: then
3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3043: l_module_name,
3044: ' PAYBLES PAY GROUP IS '||L_PAYABLES_IA_PAYGROUP);
3045: END IF;
3046:

Line 3076: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3072: when too_many_rows THEN
3073: p_error_msg := 'Too many rows in invoice ' ||
3074: 'info,dit select';
3075: p_error_code := -1;
3076: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3077: l_module_name||'.error22', p_error_msg) ;
3078: return;
3079:
3080: when No_Data_Found THEN

Line 3084: IF ( FND_LOG.LEVEL_STATEMENT >=

3080: when No_Data_Found THEN
3081: l_inter_agency_flag := 'N' ;
3082: END;
3083:
3084: IF ( FND_LOG.LEVEL_STATEMENT >=
3085: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3087: l_module_name,'VENDOR ID,INVOICE AMT,CHECK DATE ARE: '||
3088: TO_CHAR(l_vendor_id)||' '||TO_CHAR(l_inv_amount)||' '||

Line 3085: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3081: l_inter_agency_flag := 'N' ;
3082: END;
3083:
3084: IF ( FND_LOG.LEVEL_STATEMENT >=
3085: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3087: l_module_name,'VENDOR ID,INVOICE AMT,CHECK DATE ARE: '||
3088: TO_CHAR(l_vendor_id)||' '||TO_CHAR(l_inv_amount)||' '||
3089: TO_CHAR(l_check_date, 'MM/DD/YYYY'));

Line 3086: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3082: END;
3083:
3084: IF ( FND_LOG.LEVEL_STATEMENT >=
3085: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3087: l_module_name,'VENDOR ID,INVOICE AMT,CHECK DATE ARE: '||
3088: TO_CHAR(l_vendor_id)||' '||TO_CHAR(l_inv_amount)||' '||
3089: TO_CHAR(l_check_date, 'MM/DD/YYYY'));
3090: END IF;

Line 3092: IF ( FND_LOG.LEVEL_STATEMENT >=

3088: TO_CHAR(l_vendor_id)||' '||TO_CHAR(l_inv_amount)||' '||
3089: TO_CHAR(l_check_date, 'MM/DD/YYYY'));
3090: END IF;
3091:
3092: IF ( FND_LOG.LEVEL_STATEMENT >=
3093: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3094: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3095: l_module_name,'INTERAGENCY FLAG IS '
3096: ||l_inter_agency_flag);

Line 3093: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3089: TO_CHAR(l_check_date, 'MM/DD/YYYY'));
3090: END IF;
3091:
3092: IF ( FND_LOG.LEVEL_STATEMENT >=
3093: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3094: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3095: l_module_name,'INTERAGENCY FLAG IS '
3096: ||l_inter_agency_flag);
3097: END IF;

Line 3094: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3090: END IF;
3091:
3092: IF ( FND_LOG.LEVEL_STATEMENT >=
3093: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3094: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3095: l_module_name,'INTERAGENCY FLAG IS '
3096: ||l_inter_agency_flag);
3097: END IF;
3098:

Line 3129: IF (FND_LOG.LEVEL_STATEMENT >=

3125: END IF;
3126:
3127: EXCEPTION
3128: WHEN NO_DATA_FOUND THEN
3129: IF (FND_LOG.LEVEL_STATEMENT >=
3130: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3132: l_module_name,
3133: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');

Line 3130: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3126:
3127: EXCEPTION
3128: WHEN NO_DATA_FOUND THEN
3129: IF (FND_LOG.LEVEL_STATEMENT >=
3130: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3132: l_module_name,
3133: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
3134: END IF;

Line 3131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3127: EXCEPTION
3128: WHEN NO_DATA_FOUND THEN
3129: IF (FND_LOG.LEVEL_STATEMENT >=
3130: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3132: l_module_name,
3133: ' SINCE NO_DATA_FOUND, USE DEFAULT ALC.');
3134: END IF;
3135: END;

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

3135: END;
3136: END;
3137: END IF; -- Source Check to find ALC
3138:
3139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3140: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3141: l_module_name,' ALC: '||L_ALC_CODE);
3142: END IF;
3143: END IF; -- <> Manual

Line 3140: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3136: END;
3137: END IF; -- Source Check to find ALC
3138:
3139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3140: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3141: l_module_name,' ALC: '||L_ALC_CODE);
3142: END IF;
3143: END IF; -- <> Manual
3144:

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

3149: IF ((UPPER(p_alc_code) = 'ALL' OR l_alc_code = p_alc_code)
3150: AND l_name <> 'MANUAL')
3151: THEN -- Non-Manual Lines for ALL/any ALC
3152:
3153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3155: '-> GET ACCOMPLISH_DATE ...');
3156: END IF;
3157:

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

3150: AND l_name <> 'MANUAL')
3151: THEN -- Non-Manual Lines for ALL/any ALC
3152:
3153: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3155: '-> GET ACCOMPLISH_DATE ...');
3156: END IF;
3157:
3158: -- Following code derives Accomplish date,

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

3159: -- Inter Agency flag and Obligation date
3160:
3161: -- Source Check to find Accomplish Date
3162: IF (v_je_source = 'Receivables') THEN
3163: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3165: ' GETTING ACCOMPLISH_DATE FOR SOURCE = RECEIVABLES ...');
3166: END IF;
3167:

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

3160:
3161: -- Source Check to find Accomplish Date
3162: IF (v_je_source = 'Receivables') THEN
3163: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3165: ' GETTING ACCOMPLISH_DATE FOR SOURCE = RECEIVABLES ...');
3166: END IF;
3167:
3168:

Line 3188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3184:
3185: EXCEPTION
3186: WHEN NO_DATA_FOUND THEN
3187: l_inter_agency_flag := 'N';
3188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3189: then
3190: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3191: l_module_name, ' NO_DATA_FOUND: '||
3192: ' SETTING L_INTER_AGENCY_FLAG = N ... ');

Line 3190: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3186: WHEN NO_DATA_FOUND THEN
3187: l_inter_agency_flag := 'N';
3188: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3189: then
3190: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3191: l_module_name, ' NO_DATA_FOUND: '||
3192: ' SETTING L_INTER_AGENCY_FLAG = N ... ');
3193: END IF;
3194:

Line 3201: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3197: p_error_msg :=
3198: 'Too many rows in interagnecy select' ||
3199: ' for cash receipt '|| to_char(l_cash_receipt_id)||
3200: ' for Batch id '|| to_char(l_batch_id);
3201: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3202: l_module_name||'.error22',p_error_msg);
3203: RETURN;
3204: END;
3205:

Line 3216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3212:
3213: EXCEPTION
3214: WHEN NO_DATA_FOUND THEN
3215: NULL;
3216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3217: then
3218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3219: l_module_name,
3220: 'NO_DATA_FOUND: AR_CASH_RECEIPT_HISTORY_ALL '||

Line 3218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3214: WHEN NO_DATA_FOUND THEN
3215: NULL;
3216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3217: then
3218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3219: l_module_name,
3220: 'NO_DATA_FOUND: AR_CASH_RECEIPT_HISTORY_ALL '||
3221: 'DOES NOT HAVE DATA FOR REVERSAL_CASH_RECEIPT_HIST_ID'
3222: || ' = '|| L_CASH_RECEIPT_HIST_ID);

Line 3239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3235: p_error_msg := SQLERRM||
3236: '- Error while deriving the accomplish date'
3237: ||' for the cash receipt id '||l_cash_receipt_id;
3238: p_error_code := 1 ;
3239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3240: l_module_name||'.error22',p_error_msg);
3241: RETURN;
3242: END;
3243:

Line 3379: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3375: COMMIT;
3376: EXCEPTION WHEN OTHERS THEN
3377: p_error_code := sqlcode ;
3378: p_error_msg := sqlerrm ;
3379: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3380: l_module_name||'.error25',p_error_msg);
3381: ROLLBACK ;
3382: RETURN;
3383: END;

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

3398: ELSIF (l_name like '%TREASURY%' AND
3399: v_je_source = 'Budgetary Transaction' AND
3400: v_je_category = 'Treasury Confirmation')
3401: THEN
3402: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3403: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3404: ' GETTING ACCOMPLISH_DATE FOR NAME LIKE %TREASURY%, '||
3405: ' SOURCE = Budgetary Transaction, CATEGORY = TREASURY CONFIRMATION ...');
3406: END IF;

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

3399: v_je_source = 'Budgetary Transaction' AND
3400: v_je_category = 'Treasury Confirmation')
3401: THEN
3402: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3403: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3404: ' GETTING ACCOMPLISH_DATE FOR NAME LIKE %TREASURY%, '||
3405: ' SOURCE = Budgetary Transaction, CATEGORY = TREASURY CONFIRMATION ...');
3406: END IF;
3407:

Line 3424: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3420: p_error_msg :=
3421: 'Too many rows in treasury_doc_date select for ' ||
3422: 'treasury confirmation id '||substr(l_reference_6,1,20)||
3423: ' for Batch id '|| to_char(l_batch_id) ;
3424: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3425: l_module_name||'.error26',p_error_msg);
3426: RETURN ;
3427:
3428: WHEN OTHERS THEN

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

3438:
3439: ELSIF (v_je_source = 'Payables' AND
3440: v_je_category <> 'Treasury Confirmation')
3441: THEN
3442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3444: ' GETTING ACCOMPLISH_DATE FOR SOURCE = PAYABLES, ' ||
3445: ' CATEGORY <> TREASURY CONFIRMATION ...');
3446: END IF;

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

3439: ELSIF (v_je_source = 'Payables' AND
3440: v_je_category <> 'Treasury Confirmation')
3441: THEN
3442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3444: ' GETTING ACCOMPLISH_DATE FOR SOURCE = PAYABLES, ' ||
3445: ' CATEGORY <> TREASURY CONFIRMATION ...');
3446: END IF;
3447:

Line 3482: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3478: when too_many_rows THEN
3479: p_error_msg := 'Too many rows in chargeback
3480: flag Prelim select';
3481: p_error_code := -1;
3482: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3483: l_module_name||'.error23', p_error_msg) ;
3484: return;
3485: END;
3486:

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

3485: END;
3486:
3487: End If ; --l_inter_agency_flag = 'Y'
3488:
3489: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3491: l_module_name,'CHARGEBACK FLAG AND BILLING AGENCY ' ||
3492: ' FUND ARE :' || L_CB_FLAG ||' '||
3493: L_BILLING_AGENCY_FUND);

Line 3490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3486:
3487: End If ; --l_inter_agency_flag = 'Y'
3488:
3489: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3491: l_module_name,'CHARGEBACK FLAG AND BILLING AGENCY ' ||
3492: ' FUND ARE :' || L_CB_FLAG ||' '||
3493: L_BILLING_AGENCY_FUND);
3494: END IF;

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

3504: AND apc.check_id = nvl(l_reference_3,0)
3505: AND apc.org_id = p_def_org_id
3506: AND api.org_id = p_def_org_id;
3507:
3508: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3510: l_module_name,'CHECK DATE/ACCOM DATE AND VOID DATE ARE '||
3511: TO_CHAR(l_accomplish_date, 'MM/DD/YYYY')||' '||
3512: TO_CHAR(l_void_date, 'MM/DD/YYYY'));

Line 3509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3505: AND apc.org_id = p_def_org_id
3506: AND api.org_id = p_def_org_id;
3507:
3508: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3510: l_module_name,'CHECK DATE/ACCOM DATE AND VOID DATE ARE '||
3511: TO_CHAR(l_accomplish_date, 'MM/DD/YYYY')||' '||
3512: TO_CHAR(l_void_date, 'MM/DD/YYYY'));
3513: END IF;

Line 3527: IF ( FND_LOG.LEVEL_STATEMENT >=

3523: WHERE invoice_id = NVL(l_reference, 0)
3524: AND check_id = NVL(l_reference_3,0)
3525: AND invoice_payment_id >l_reference_9;
3526:
3527: IF ( FND_LOG.LEVEL_STATEMENT >=
3528: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3530: l_module_name,'VOID DATE IS NOT ' ||
3531: 'NULL AND INVOICE '||

Line 3528: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3524: AND check_id = NVL(l_reference_3,0)
3525: AND invoice_payment_id >l_reference_9;
3526:
3527: IF ( FND_LOG.LEVEL_STATEMENT >=
3528: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3530: l_module_name,'VOID DATE IS NOT ' ||
3531: 'NULL AND INVOICE '||
3532: 'payment id is '||TO_CHAR(l_inv_pay_id));

Line 3529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3525: AND invoice_payment_id >l_reference_9;
3526:
3527: IF ( FND_LOG.LEVEL_STATEMENT >=
3528: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3530: l_module_name,'VOID DATE IS NOT ' ||
3531: 'NULL AND INVOICE '||
3532: 'payment id is '||TO_CHAR(l_inv_pay_id));
3533: END IF;

Line 3555: IF ( FND_LOG.LEVEL_STATEMENT >=

3551: l_type := 'VOID';
3552: l_sf1219_type_code := 'VOID';
3553: l_record_type := 'A';
3554:
3555: IF ( FND_LOG.LEVEL_STATEMENT >=
3556: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3558: l_module_name,'OBLIGATION DATE IS '||
3559: TO_CHAR(l_obligation_date, 'MM/DD/YYYY'));

Line 3556: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3552: l_sf1219_type_code := 'VOID';
3553: l_record_type := 'A';
3554:
3555: IF ( FND_LOG.LEVEL_STATEMENT >=
3556: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3558: l_module_name,'OBLIGATION DATE IS '||
3559: TO_CHAR(l_obligation_date, 'MM/DD/YYYY'));
3560: END IF;

Line 3557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3553: l_record_type := 'A';
3554:
3555: IF ( FND_LOG.LEVEL_STATEMENT >=
3556: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3558: l_module_name,'OBLIGATION DATE IS '||
3559: TO_CHAR(l_obligation_date, 'MM/DD/YYYY'));
3560: END IF;
3561:

Line 3571: IF ( FND_LOG.LEVEL_STATEMENT >=

3567: l_treasury_symbol := 'UNDEFINED';
3568: l_accomplish_date := NULL;
3569: l_record_type := 'E';
3570:
3571: IF ( FND_LOG.LEVEL_STATEMENT >=
3572: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3574: l_module_name,'RITA GERA 1');
3575: END IF;

Line 3572: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3568: l_accomplish_date := NULL;
3569: l_record_type := 'E';
3570:
3571: IF ( FND_LOG.LEVEL_STATEMENT >=
3572: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3574: l_module_name,'RITA GERA 1');
3575: END IF;
3576:

Line 3573: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3569: l_record_type := 'E';
3570:
3571: IF ( FND_LOG.LEVEL_STATEMENT >=
3572: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3573: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3574: l_module_name,'RITA GERA 1');
3575: END IF;
3576:
3577: -- Insert the exception transaction

Line 3586: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3582: WHEN TOO_MANY_ROWS THEN
3583: p_error_msg := 'Too many rows in' ||
3584: ' obligation_date select';
3585: p_error_code := -1;
3586: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3587: l_module_name||'.error25', p_error_msg) ;
3588: return;
3589: END ; /* V1 */
3590:

Line 3599: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3595: WHEN TOO_MANY_ROWS THEN
3596: p_error_msg := 'Too many rows in void_date' ||
3597: ' disbursement select';
3598: p_error_code := -1;
3599: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3600: l_module_name||'.error26', p_error_msg) ;
3601: return;
3602:
3603: WHEN NO_DATA_FOUND THEN

Line 3609: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3605:
3606: WHEN OTHERS THEN
3607: p_error_msg := sqlerrm ;
3608: p_Error_Code := -1 ;
3609: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3610: l_module_name||'.error27', p_error_msg) ;
3611: RollBack ;
3612: Return ;
3613: END ; /* Void Date */

Line 3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3617: l_sf1219_type_code := 'RECEIPT';
3618: End if; -- charge back flag = 'Y'
3619: End If ;
3620:
3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3624: l_module_name,'RECORD TYPE IS '||L_RECORD_TYPE);
3625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 3623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3619: End If ;
3620:
3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3624: l_module_name,'RECORD TYPE IS '||L_RECORD_TYPE);
3625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3626: l_module_name,'1219 TYPE CODE IS '||L_SF1219_TYPE_CODE);
3627: END IF;

Line 3625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3621: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3624: l_module_name,'RECORD TYPE IS '||L_RECORD_TYPE);
3625: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3626: l_module_name,'1219 TYPE CODE IS '||L_SF1219_TYPE_CODE);
3627: END IF;
3628:
3629: EXCEPTION

Line 3649: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3645: End if;
3646: WHEN others then
3647: p_error_msg := sqlerrm;
3648: p_error_code := -1;
3649: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3650: l_module_name||'.error28', p_error_msg) ;
3651: rollback;
3652: return;
3653: END ; /* End proces DIT */

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

3656: ELSIF (l_name LIKE '%VOID%'
3657: AND v_je_source = 'Budgetary Transaction'
3658: AND v_je_category = 'Treasury Confirmation')
3659: THEN
3660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3661: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3662: ' GETTING ACCOMPLISH_DATE FOR NAME LIKE %VOID%, '||
3663: 'SOURCE = Budgetary Transaction, CATEGORY = '||
3664: ' TREASURY CONFIRMATION ...');

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

3657: AND v_je_source = 'Budgetary Transaction'
3658: AND v_je_category = 'Treasury Confirmation')
3659: THEN
3660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3661: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3662: ' GETTING ACCOMPLISH_DATE FOR NAME LIKE %VOID%, '||
3663: 'SOURCE = Budgetary Transaction, CATEGORY = '||
3664: ' TREASURY CONFIRMATION ...');
3665: END IF;

Line 3745: IF ( FND_LOG.LEVEL_STATEMENT >=

3741: l_treasury_symbol := 'UNDEFINED' ;
3742: l_accomplish_date := null ;
3743: l_record_type := 'E' ;
3744:
3745: IF ( FND_LOG.LEVEL_STATEMENT >=
3746: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3747: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3748: l_module_name,'RITA GERA 2');
3749: END IF;

Line 3746: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3742: l_accomplish_date := null ;
3743: l_record_type := 'E' ;
3744:
3745: IF ( FND_LOG.LEVEL_STATEMENT >=
3746: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3747: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3748: l_module_name,'RITA GERA 2');
3749: END IF;
3750:

Line 3747: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

3743: l_record_type := 'E' ;
3744:
3745: IF ( FND_LOG.LEVEL_STATEMENT >=
3746: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3747: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
3748: l_module_name,'RITA GERA 2');
3749: END IF;
3750:
3751:

Line 3775: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3771: WHEN TOO_MANY_ROWS THEN
3772: p_error_code := -1;
3773: p_error_msg := 'Too many rows in obligation_date select '||
3774: 'For JE batch id '||to_char(l_batch_id);
3775: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3776: l_module_name||'.error32',p_error_msg);
3777: RETURN;
3778: END ;
3779: ELSE

Line 3797: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3793: EXCEPTION WHEN OTHERS THEN
3794: p_error_code := 2;
3795: p_error_msg := substr(sqlerrm,1,50) ||
3796: ' while fetching txn end date into accomplish_date';
3797: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3798: l_module_name||'.error5', p_error_msg) ;
3799: END;
3800: END IF; -- Source Check to find Accomplish Date
3801: END IF; -- Non-Manual Lines for ALL/any ALC

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

3800: END IF; -- Source Check to find Accomplish Date
3801: END IF; -- Non-Manual Lines for ALL/any ALC
3802:
3803:
3804: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3805: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3806: ' ACCOMPLISH DATE: '||L_ACCOMPLISH_DATE);
3807: END IF;
3808:

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

3801: END IF; -- Non-Manual Lines for ALL/any ALC
3802:
3803:
3804: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3805: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3806: ' ACCOMPLISH DATE: '||L_ACCOMPLISH_DATE);
3807: END IF;
3808:
3809: IF l_accomplish_date IS NOT NULL

Line 3876: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3872:
3873: IF sqlcode < 0 THEN
3874: p_error_code := -1;
3875: p_error_msg := 'fv_sf1219_temp update failed' ;
3876: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3877: l_module_name||'.error33',p_error_msg);
3878: RETURN ;
3879: END IF;
3880:

Line 3915: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3911:
3912: p_error_code := SQLCODE;
3913: p_error_msg := SQLERRM || ' -- Error in ' ||
3914: 'PROCESS_1219_TRANSACTIONS procedure.';
3915: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3916: l_module_name||'.final_exception',p_error_msg);
3917: ROLLBACK;
3918: RETURN;
3919: END PROCESS_1219_TRANSACTIONS;

Line 3949: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

3945: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
3946: p_error_code := -1 ;
3947: p_error_msg := 'No such period ('||l_gl_period||')
3948: of TEMP exists in GL_PERIODS' ;
3949: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
3950: l_module_name||'.error1',p_error_msg);
3951: ROLLBACK ;
3952: RETURN ;
3953: END ;

Line 3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

3987: WHEN OTHERS THEN
3988: p_error_code := SQLCODE;
3989: p_error_msg := SQLERRM || ' -- Error in ' ||
3990: 'SET_EXCEPTION_CATEGORY procedure.';
3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
3992: l_module_name||'.final_exception',p_error_msg);
3993: ROLLBACK;
3994: RETURN;
3995: END SET_EXCEPTION_CATEGORY;

Line 4107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4103: WHEN OTHERS THEN
4104: p_error_code := SQLCODE;
4105: p_error_msg := SQLERRM || ' -- Error in ' ||
4106: 'INSERT_EXCEPTIONS procedure.';
4107: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4108: l_module_name||'.final_exception',p_error_msg);
4109: ROLLBACK;
4110: RETURN;
4111: END INSERT_EXCEPTIONS;

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

4122:
4123: PROCEDURE ASSIGN_GROUP_NAME IS
4124: l_module_name VARCHAR2(200) := g_module_name || 'ASSIGN_GROUP_NAME';
4125: BEGIN
4126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4127: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4128: ' Inside Assign_Group_Name ...');
4129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4130: ' l_sf1219_type_code : '||l_sf1219_type_code);

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

4123: PROCEDURE ASSIGN_GROUP_NAME IS
4124: l_module_name VARCHAR2(200) := g_module_name || 'ASSIGN_GROUP_NAME';
4125: BEGIN
4126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4127: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4128: ' Inside Assign_Group_Name ...');
4129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4130: ' l_sf1219_type_code : '||l_sf1219_type_code);
4131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

4125: BEGIN
4126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4127: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4128: ' Inside Assign_Group_Name ...');
4129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4130: ' l_sf1219_type_code : '||l_sf1219_type_code);
4131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4132: ' l_inter_agency_flag: '||l_inter_agency_flag);
4133: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

4127: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4128: ' Inside Assign_Group_Name ...');
4129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4130: ' l_sf1219_type_code : '||l_sf1219_type_code);
4131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4132: ' l_inter_agency_flag: '||l_inter_agency_flag);
4133: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4134: ' l_obligation_date : '||l_obligation_date);
4135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

4129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4130: ' l_sf1219_type_code : '||l_sf1219_type_code);
4131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4132: ' l_inter_agency_flag: '||l_inter_agency_flag);
4133: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4134: ' l_obligation_date : '||l_obligation_date);
4135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4136: ' l_yr_start_date : '||l_yr_start_date);
4137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

4131: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4132: ' l_inter_agency_flag: '||l_inter_agency_flag);
4133: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4134: ' l_obligation_date : '||l_obligation_date);
4135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4136: ' l_yr_start_date : '||l_yr_start_date);
4137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4138: ' l_yr_end_date : '||l_yr_end_date);
4139: END IF;

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

4133: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4134: ' l_obligation_date : '||l_obligation_date);
4135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4136: ' l_yr_start_date : '||l_yr_start_date);
4137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4138: ' l_yr_end_date : '||l_yr_end_date);
4139: END IF;
4140:
4141: IF l_sf1219_type_code = 'DISBURSEMENT' AND l_inter_agency_flag = 'N'

Line 4224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

4220: l_group_name := null;
4221: ELSE -- group name could not be assigned
4222: p_error_msg := 'Group Name could not be assigned ' ;
4223: p_error_code := -1 ;
4224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4225: l_module_name||'.error1',p_error_msg);
4226: RETURN ;
4227: END IF ;
4228: EXCEPTION

Line 4233: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4229: WHEN OTHERS THEN
4230: p_error_code := SQLCODE;
4231: p_error_msg := SQLERRM || ' -- Error in ' ||
4232: 'ASSIGN_GROUP_NAME procedure.';
4233: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4234: l_module_name||'.final_exception',p_error_msg);
4235: ROLLBACK;
4236: RETURN;
4237: END ASSIGN_GROUP_NAME;

Line 4356: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

4352:
4353: WHEN TOO_MANY_ROWS THEN
4354: p_error_code := -1 ;
4355: p_error_msg := 'Too many rows in obligation_date select' ;
4356: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4357: l_module_name||'.error1',p_error_msg);
4358: END ;
4359:
4360: END LOOP ;

Line 4367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4363: WHEN OTHERS THEN
4364: p_error_code := SQLCODE;
4365: p_error_msg := SQLERRM || ' -- Error in ' ||
4366: 'PROCESS_VOID_TRANSACTIONS procedure.';
4367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4368: l_module_name||'.final_exception',p_error_msg);
4369: ROLLBACK;
4370: RETURN;
4371: END PROCESS_VOID_TRANSACTIONS;

Line 4501: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4497: WHEN OTHERS THEN
4498: p_error_code := SQLCODE;
4499: p_error_msg := SQLERRM || ' -- Error in ' ||
4500: ' GROUP_REPORT_LINES procedure.';
4501: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4502: l_module_name||'.final_exception',p_error_msg);
4503: ROLLBACK;
4504: RETURN;
4505: END GROUP_REPORT_LINES;

Line 4567: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4563: WHEN OTHERS THEN
4564: p_error_code := SQLCODE;
4565: p_error_msg := SQLERRM || ' -- Error in ' ||
4566: ' INSERT_AUDIT_TABLE procedure while finding GL period.';
4567: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4568: l_module_name||'.final_exception',p_error_msg);
4569: ROLLBACK;
4570: RETURN;
4571: END;

Line 4600: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4596: p_error_code := SQLCODE;
4597: p_error_msg := SQLERRM || ' -- Error in ' ||
4598: ' INSERT_AUDIT_TABLE procedure while ' ||
4599: ' finding SoB, CoA and period end date.';
4600: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4601: l_module_name||'.final_exception',p_error_msg);
4602: ROLLBACK;
4603: RETURN;
4604: END;

Line 4618: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,

4614: AND reported_gl_period = l_reported_period;
4615:
4616: IF v_supp_number > 3
4617: THEN
4618: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_EXCEPTION,
4619: l_module_name||'.error211','Supplement number for
4620: Agency Location Code: '||v_alc_code||' has exceeded 3');
4621: v_supp_number := 3;
4622: END IF;

Line 4738: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

4734:
4735: IF (sqlcode < 0) THEN
4736: p_error_msg := 'fv_Sf1219_temp table update failed ' ;
4737: p_error_code := -1 ;
4738: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4739: l_module_name||'.error1',p_error_msg);
4740: RETURN ;
4741: END IF;
4742:

Line 4767: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: p_error_code := SQLCODE;
4766: p_error_msg := SQLERRM || ' -- Error in INSERT_AUDIT_TABLE procedure.';
4767: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4768: l_module_name||'.final_exception',p_error_msg);
4769: ROLLBACK;
4770: RETURN;
4771: END INSERT_AUDIT_TABLE;

Line 4841: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4837: WHEN OTHERS THEN
4838: p_error_code := SQLCODE;
4839: p_error_msg := SQLERRM || ' -- Error in ' ||
4840: 'INSERT_ACCOUNTABILITY_BALANCE procedure.';
4841: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4842: l_module_name||'.final_exception',p_error_msg);
4843: ROLLBACK;
4844: RETURN;
4845: END INSERT_ACCOUNTABILITY_BALANCE;

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

5039: p_error_code := SQLCODE;
5040: p_error_msg := SQLERRM || ' -- Error in GEN_FLAT_FILE ' ||
5041: ' procedure while finding Acct Date ' ||
5042: '(End_Date of the period).';
5043: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name
5044: ||'.final_exception',p_error_msg);
5045: ROLLBACK;
5046: RETURN;
5047: END;

Line 5061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5057: WHEN OTHERS THEN
5058: p_error_code := SQLCODE;
5059: p_error_msg := SQLERRM || ' -- Error in GEN_FLAT_FILE procedure ' ||
5060: 'while finding max_supplement_number.';
5061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5062: l_module_name||'.final_exception',p_error_msg);
5063: ROLLBACK;
5064: RETURN;
5065: END;

Line 5341: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5337: EXCEPTION
5338: WHEN OTHERS THEN
5339: p_error_code := SQLCODE;
5340: p_error_msg := SQLERRM || ' -- Error in GEN_FLAT_FILE procedure.';
5341: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5342: l_module_name||'.final_exception',p_error_msg);
5343: ROLLBACK;
5344: RETURN;
5345: END GEN_FLAT_FILE;