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

APPS.FV_GOALS_224 dependencies on FND_LOG

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

298: AND gsob.chart_of_accounts_id = flex_num
299: AND glp.period_set_name = gsob.period_set_name;
300:
301:
302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE REPORTING DATE IS ' || V_REPORTING_DATE);
304: END IF;
305:
306: DELETE FROM FV_GOALS_224_TEMP;

Line 303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE REPORTING DATE IS ' || V_REPORTING_DATE);

299: AND glp.period_set_name = gsob.period_set_name;
300:
301:
302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE REPORTING DATE IS ' || V_REPORTING_DATE);
304: END IF;
305:
306: DELETE FROM FV_GOALS_224_TEMP;
307:

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

310: OPEN get_alc_cur;
311: LOOP
312: FETCH get_alc_cur INTO v_alc_code;
313: EXIT WHEN get_alc_cur%NOTFOUND;
314: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||
316: ' from the Fv_Sf224_Temp table');
317: END IF;
318:

Line 315: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||

311: LOOP
312: FETCH get_alc_cur INTO v_alc_code;
313: EXIT WHEN get_alc_cur%NOTFOUND;
314: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||
316: ' from the Fv_Sf224_Temp table');
317: END IF;
318:
319: SELECT count(*)

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

324: AND fst.sf224_processed_flag = 'Y'
325: AND fst.end_period_date < v_end_date
326: AND fst.record_category = 'GLRECORD';
327:
328: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'VAR_COUNT IS ' || VAR_COUNT);
330: END IF;
331:
332: if var_count > 0 THEN

Line 329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'VAR_COUNT IS ' || VAR_COUNT);

325: AND fst.end_period_date < v_end_date
326: AND fst.record_category = 'GLRECORD';
327:
328: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'VAR_COUNT IS ' || VAR_COUNT);
330: END IF;
331:
332: if var_count > 0 THEN
333: process_record_type_01;

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

350: LOOP
351: FETCH get_zeroalc_cur INTO v_alc_code;
352: EXIT WHEN get_zeroalc_cur%NOTFOUND;
353:
354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||
356: ' for the zero activity, for record types 3, 26 and 98.');
357: END IF;
358:

Line 355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||

351: FETCH get_zeroalc_cur INTO v_alc_code;
352: EXIT WHEN get_zeroalc_cur%NOTFOUND;
353:
354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING GOALS FOR ALC = ' ||V_ALC_CODE ||
356: ' for the zero activity, for record types 3, 26 and 98.');
357: END IF;
358:
359: process_record_type_03;

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

379: end if;
380: When OTHERS then
381: errbuf:=sqlerrm;
382: retcode:= -1;
383: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
384: if cur_receipts%ISOPEN then
385: close cur_receipts;
386: end if;
387: if cur_disbursements%ISOPEN then

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

430: v_receipt_amt_goals ||
431: v_transaction_date ||
432: v_reporting_date;
433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);

Line 435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

431: v_transaction_date ||
432: v_reporting_date;
433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);

Line 436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

432: v_reporting_date;
433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;

Line 437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);

433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;
441:

Line 438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);

434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;
441:
442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);

435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
437: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' || V_TREASURY_SYMBOL);
438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;
441:
442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 01 IS '|| V_RECORD_01);

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

438: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE RECEIPT AMOUNT IS ' || V_RECEIPT_AMT_GOALS);
439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;
441:
442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 01 IS '|| V_RECORD_01);
444: END IF;
445:
446: IF (v_alc_code IS NOT NULL) AND (v_receipt_amt <> 0)THEN

Line 443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 01 IS '|| V_RECORD_01);

439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR RECEIPT 01 IS '|| V_ENTRY_NUMBER);
440: END IF;
441:
442: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 01 IS '|| V_RECORD_01);
444: END IF;
445:
446: IF (v_alc_code IS NOT NULL) AND (v_receipt_amt <> 0)THEN
447: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

455: EXCEPTION
456: WHEN OTHERS THEN
457: errbuf := SQLERRM;
458: retcode := -1;
459: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
460: RAISE;
461: END process_record_type_01;
462: ------------------------------------------------------------------------------------------------
463: PROCEDURE process_record_type_02 IS

Line 506: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);

502: null;
503: WHEN OTHERS THEN
504: errbuf := SQLERRM;
505: retcode := -1;
506: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);
507: return;
508: END;
509:
510: v_record_02 := v_record_type ||

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

515: v_disbursement_amt_goals ||
516: v_transaction_date ||
517: v_reporting_date;
518:
519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);

Line 520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

516: v_transaction_date ||
517: v_reporting_date;
518:
519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);

Line 521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

517: v_reporting_date;
518:
519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;

Line 522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);

518:
519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;
526:

Line 523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);

519: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;
526:
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);

520: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TREASURY SYMBOL IS ' ||V_TREASURY_SYMBOL);
523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;
526:
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 02 IS '|| V_RECORD_02);

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

523: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DISBURSEMENT AMOUNT IS ' || V_DISBURSEMENT_AMT_GOALS);
524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;
526:
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 02 IS '|| V_RECORD_02);
529: END IF;
530:
531: IF v_alc_code IS NOT NULL THEN

Line 528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 02 IS '|| V_RECORD_02);

524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE ENTRY NUMBER FOR DISBURSEMENT 02 IS '|| V_ENTRY_NUMBER);
525: END IF;
526:
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 02 IS '|| V_RECORD_02);
529: END IF;
530:
531: IF v_alc_code IS NOT NULL THEN
532: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

538: EXCEPTION
539: WHEN OTHERS THEN
540: errbuf := SQLERRM;
541: retcode := -1;
542: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
543: RAISE;
544: END process_record_type_02;
545: ------------------------------------------------------------------------------------------------
546: PROCEDURE process_record_type_03 IS

Line 571: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);

567: v_orig_suppl_ind := 0;
568: WHEN OTHERS THEN
569: errbuf := SQLERRM;
570: retcode := -1;
571: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);
572: return;
573: END;
574:
575: IF v_pmt_tran_current_amt >= 0 THEN

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

592: v_pmt_tran_current_amt_goals ||
593: v_transaction_date ||
594: v_reporting_date;
595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;

Line 597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

593: v_transaction_date ||
594: v_reporting_date;
595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;
601:

Line 598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

594: v_reporting_date;
595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;
601:
602: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);

595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;
601:
602: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 03 IS '|| V_RECORD_03);

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

598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;
601:
602: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 03 IS '|| V_RECORD_03);
604: END IF;
605:
606: IF ((v_alc_code IS NOT NULL) AND (TO_NUMBER(v_pmt_tran_current_amt) <> 0)) THEN

Line 603: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 03 IS '|| V_RECORD_03);

599: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PMT TRAN CURRENT AMOUNT IS ' || V_PMT_TRAN_CURRENT_AMT_GOALS);
600: END IF;
601:
602: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
603: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 03 IS '|| V_RECORD_03);
604: END IF;
605:
606: IF ((v_alc_code IS NOT NULL) AND (TO_NUMBER(v_pmt_tran_current_amt) <> 0)) THEN
607: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

610: EXCEPTION
611: WHEN OTHERS THEN
612: errbuf := SQLERRM;
613: retcode := -1;
614: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
615: RAISE;
616: END process_record_type_03;
617: -----------------------------------------------------------------------------------------------
618: PROCEDURE process_record_type_04_13 IS

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

646: v_pmt_tran_prior_amt_goals ||
647: v_transaction_date ||
648: v_reporting_date;
649:
650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);

Line 651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

647: v_transaction_date ||
648: v_reporting_date;
649:
650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;

Line 652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

648: v_reporting_date;
649:
650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;
656:

Line 653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);

649:
650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);

650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
652: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);

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

653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
659: END IF;
660:
661: IF (v_alc_code IS NOT NULL) AND (v_pmt_tran_prior_amt <> 0)THEN

Line 658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);

654: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE PAYMENT TRANSACTION PRIOR AMOUNT IS ' || V_PMT_TRAN_PRIOR_AMT_GOALS);
655: END IF;
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
659: END IF;
660:
661: IF (v_alc_code IS NOT NULL) AND (v_pmt_tran_prior_amt <> 0)THEN
662: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

681: EXCEPTION
682: WHEN OTHERS THEN
683: errbuf := SQLERRM;
684: retcode := -1;
685: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
686: RAISE;
687: END process_record_type_04_13;
688: ------------------------------------------------------------------------------------------------
689: PROCEDURE process_record_type_14 IS

Line 713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);

709: v_collection_rcvd_amt := '00000000000000';
710: WHEN OTHERS THEN
711: errbuf := SQLERRM;
712: retcode := -1;
713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.message1',errbuf);
714: return;
715: END;
716:
717: IF v_collection_rcvd_amt >= 0 THEN

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

733: v_collection_rcvd_amt_goals ||
734: v_transaction_date ||
735: v_reporting_date;
736:
737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);
741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);

Line 738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

734: v_transaction_date ||
735: v_reporting_date;
736:
737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);
741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);
742: END IF;

Line 739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

735: v_reporting_date;
736:
737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);
741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);
742: END IF;
743:

Line 740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);

736:
737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);
741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);
742: END IF;
743:
744: IF v_alc_code IS NOT NULL AND v_collection_rcvd_amt_goals <> 0 THEN

Line 741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);

737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE COLLECTIONS RECEIVED AMOUNT IS ' || V_COLLECTION_RCVD_AMT_GOALS);
741: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 14 IS '|| V_RECORD_14);
742: END IF;
743:
744: IF v_alc_code IS NOT NULL AND v_collection_rcvd_amt_goals <> 0 THEN
745: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

748: EXCEPTION
749: WHEN OTHERS THEN
750: errbuf := SQLERRM;
751: retcode := -1;
752: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
753: RAISE;
754: END process_record_type_14;
755: ------------------------------------------------------------------------------------------------
756: PROCEDURE process_record_type_15 IS

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

796: v_deposit_current_amt_goals ||
797: v_transaction_date ||
798: v_reporting_date;
799:
800: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);
804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);

Line 801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

797: v_transaction_date ||
798: v_reporting_date;
799:
800: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);
804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);
805: END IF;

Line 802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

798: v_reporting_date;
799:
800: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);
804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);
805: END IF;
806:

Line 803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);

799:
800: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);
804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);
805: END IF;
806:
807: IF v_alc_code IS NOT NULL AND v_deposit_current_amt <> 0 THEN

Line 804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);

800: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
802: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
803: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT CURRENT AMOUNT IS ' || V_DEPOSIT_CURRENT_AMT_GOALS);
804: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 15 IS '|| V_RECORD_15);
805: END IF;
806:
807: IF v_alc_code IS NOT NULL AND v_deposit_current_amt <> 0 THEN
808: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

811: EXCEPTION
812: WHEN OTHERS THEN
813: errbuf := SQLERRM;
814: retcode := -1;
815: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
816: RAISE;
817: END process_record_type_15;
818: ------------------------------------------------------------------------------------------------
819: PROCEDURE process_record_type_16_25 IS

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

859: v_deposit_prior_amt_goals ||
860: v_transaction_date ||
861: v_reporting_date;
862:
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);

Line 864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

860: v_transaction_date ||
861: v_reporting_date;
862:
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);
868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);

Line 865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

861: v_reporting_date;
862:
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);
868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
869: END IF;

Line 866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);

862:
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);
868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
869: END IF;
870:

Line 867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);

863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);
868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
869: END IF;
870:
871: IF v_alc_code IS NOT NULL AND v_deposit_prior_amt <> 0 THEN

Line 868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);

864: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE TRANSACTION DATE IS ' || V_TRANSACTION_DATE);
867: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'THE DEPOSIT PRIOR AMOUNT IS ' || V_DEPOSIT_PRIOR_AMT_GOALS);
868: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD XX IS '|| V_RECORD);
869: END IF;
870:
871: IF v_alc_code IS NOT NULL AND v_deposit_prior_amt <> 0 THEN
872: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

881: EXCEPTION
882: WHEN OTHERS THEN
883: errbuf := SQLERRM;
884: retcode := -1;
885: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
886: RAISE;
887: END process_record_type_16_25;
888: ------------------------------------------------------------------------------------------------
889: PROCEDURE process_record_type_26 IS

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

928: v_net_total_amt_goals ||
929: v_transaction_date ||
930: v_reporting_date;
931:
932: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');
934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);
935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);

Line 933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');

929: v_transaction_date ||
930: v_reporting_date;
931:
932: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');
934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);
935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;

Line 934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);

930: v_reporting_date;
931:
932: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');
934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);
935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;
938:

Line 935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);

931:
932: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');
934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);
935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;
938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);

932: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 ************ ');
934: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_PRIOR_AMT IS ' || V_DEPOSIT_PRIOR_AMT);
935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;
938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

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

935: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_DEPOSIT_CURRENT_AMT IS ' || V_DEPOSIT_CURRENT_AMT);
936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;
938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);
943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);

Line 940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

936: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_COLLECTION_RCVD_AMT IS ' || V_COLLECTION_RCVD_AMT);
937: END IF;
938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);
943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);
944: END IF;

Line 941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

937: END IF;
938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);
943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);
944: END IF;
945:

Line 942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);

938:
939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);
943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);
944: END IF;
945:
946: IF ((v_alc_code IS NOT NULL) AND ((v_net_total_amt <> 0) OR ((v_net_total_amt = 0) AND (l_count_non_reclass > 0)))) THEN

Line 943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);

939: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
941: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
942: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NET TOTAL IS ' || V_NET_TOTAL_AMT);
943: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 26 IS '|| V_RECORD_26);
944: END IF;
945:
946: IF ((v_alc_code IS NOT NULL) AND ((v_net_total_amt <> 0) OR ((v_net_total_amt = 0) AND (l_count_non_reclass > 0)))) THEN
947: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

950: EXCEPTION
951: WHEN OTHERS THEN
952: errbuf := SQLERRM;
953: retcode := -1;
954: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
955: RAISE;
956:
957: END process_record_type_26;
958: ------------------------------------------------------------------------------------------------

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

968: WHERE alc_code = v_alc_code;
969:
970: v_record_type := '98';
971:
972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
973: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V COUNT PER ALC IS ' || V_COUNT_PER_ALC);
975: END IF;
976:

Line 973: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

969:
970: v_record_type := '98';
971:
972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
973: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V COUNT PER ALC IS ' || V_COUNT_PER_ALC);
975: END IF;
976:
977: v_treasury_symbol := ' ';

Line 974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V COUNT PER ALC IS ' || V_COUNT_PER_ALC);

970: v_record_type := '98';
971:
972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
973: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V COUNT PER ALC IS ' || V_COUNT_PER_ALC);
975: END IF;
976:
977: v_treasury_symbol := ' ';
978: v_entry_number := ' ';

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

986: v_count_per_alc ||
987: v_transaction_date ||
988: v_reporting_date;
989:
990: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 98 IS '|| V_RECORD_98);
992: END IF;
993:
994: IF ((v_alc_code IS NOT NULL) AND (v_count_per_alc <> 0)) THEN

Line 991: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 98 IS '|| V_RECORD_98);

987: v_transaction_date ||
988: v_reporting_date;
989:
990: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 98 IS '|| V_RECORD_98);
992: END IF;
993:
994: IF ((v_alc_code IS NOT NULL) AND (v_count_per_alc <> 0)) THEN
995: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)

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

995: insert into fv_goals_224_temp(goals_224_temp_id, goals_224_record_type, alc_code, goals_224_record, supplemental_flag)
996: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_98, v_orig_suppl_ind);
997: END IF;
998:
999: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
1001: END IF;
1002: EXCEPTION
1003: WHEN OTHERS THEN

Line 1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);

996: values(fv_goals_224_temp_id_s.nextval, v_record_type, v_alc_code, v_record_98, v_orig_suppl_ind);
997: END IF;
998:
999: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V ORIG_SUPPL_IND IS ' || V_ORIG_SUPPL_IND);
1001: END IF;
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: errbuf := SQLERRM;

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

1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: errbuf := SQLERRM;
1005: retcode := -1;
1006: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
1007: RAISE;
1008:
1009: END process_record_type_98;
1010: ------------------------------------------------------------------------------------------------

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

1019: FROM fv_goals_224_temp
1020: WHERE goals_224_record_type not in ('98','99');
1021:
1022: v_record_type := '99';
1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
1025: END IF;
1026: v_orig_suppl_ind := ' ';
1027: v_alc_code := ' ';

Line 1024: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);

1020: WHERE goals_224_record_type not in ('98','99');
1021:
1022: v_record_type := '99';
1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V RECORD TYPE IS ' || V_RECORD_TYPE);
1025: END IF;
1026: v_orig_suppl_ind := ' ';
1027: v_alc_code := ' ';
1028: v_treasury_symbol := ' ';

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

1037: v_count ||
1038: v_transaction_date ||
1039: v_reporting_date;
1040:
1041: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 99 IS '|| V_RECORD_99);
1043: END IF;
1044:
1045: --if the only value that gets inserted into the temp table with amount of 0, it is a

Line 1042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 99 IS '|| V_RECORD_99);

1038: v_transaction_date ||
1039: v_reporting_date;
1040:
1041: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECORD 99 IS '|| V_RECORD_99);
1043: END IF;
1044:
1045: --if the only value that gets inserted into the temp table with amount of 0, it is a
1046: -- zero activity 224

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

1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: errbuf := SQLERRM;
1054: retcode := -1;
1055: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
1056: RAISE;
1057:
1058: END process_record_type_99;
1059: ------------------------------------------------------------------------------------------------