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.FII_AP_INV_SUM_INC dependencies on FII_UTIL

Line 246: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);

242: l_stmt VARCHAR2(100);
243: BEGIN
244: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
245: if g_debug_flag = 'Y' then
246: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
247: FII_UTIL.put_line('');
248: FII_UTIL.put_line(l_stmt);
249: end if;
250: EXECUTE IMMEDIATE l_stmt;

Line 247: FII_UTIL.put_line('');

243: BEGIN
244: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
245: if g_debug_flag = 'Y' then
246: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
247: FII_UTIL.put_line('');
248: FII_UTIL.put_line(l_stmt);
249: end if;
250: EXECUTE IMMEDIATE l_stmt;
251:

Line 248: FII_UTIL.put_line(l_stmt);

244: l_stmt := 'TRUNCATE table '||g_fii_schema||'.'||p_table_name;
245: if g_debug_flag = 'Y' then
246: FII_UTIL.put_line('g_fii_schema '||g_fii_schema);
247: FII_UTIL.put_line('');
248: FII_UTIL.put_line(l_stmt);
249: end if;
250: EXECUTE IMMEDIATE l_stmt;
251:
252: EXCEPTION

Line 284: FII_UTIL.put_line('g_fii_schema is '||g_fii_schema);

280:
281: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, g_fii_schema)) THEN
282: NULL;
283: if g_debug_flag = 'Y' then
284: FII_UTIL.put_line('g_fii_schema is '||g_fii_schema);
285: end if;
286: END IF;
287:
288: -- --------------------------------------------------------

Line 292: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');

288: -- --------------------------------------------------------
289: -- Find the schema owner (AP)
290: -- --------------------------------------------------------
291:
292: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');
293: if g_debug_flag = 'Y' then
294: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);
295: end if;
296:

Line 294: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);

290: -- --------------------------------------------------------
291:
292: g_ap_schema := FII_UTIL.get_schema_name('SQLAP');
293: if g_debug_flag = 'Y' then
294: FII_UTIL.put_line('g_ap_schema is '||g_ap_schema);
295: end if;
296:
297:
298: if g_debug_flag = 'Y' then

Line 299: FII_UTIL.put_line('Initializing the Global Currency Precision');

295: end if;
296:
297:
298: if g_debug_flag = 'Y' then
299: FII_UTIL.put_line('Initializing the Global Currency Precision');
300: end if;
301:
302: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
303: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);

Line 306: FII_UTIL.put_line('Initializing the Global Currencies');

302: g_primary_mau := nvl(fii_currency.get_mau_primary, 0.01 );
303: g_secondary_mau:= nvl(fii_currency.get_mau_secondary, 0.01);
304:
305: if g_debug_flag = 'Y' then
306: FII_UTIL.put_line('Initializing the Global Currencies');
307: end if;
308:
309: g_prim_currency := bis_common_parameters.get_currency_code;
310: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

Line 313: FII_UTIL.put_line('Initializing Global Currency Rate Types');

309: g_prim_currency := bis_common_parameters.get_currency_code;
310: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
311:
312: if g_debug_flag = 'Y' then
313: FII_UTIL.put_line('Initializing Global Currency Rate Types');
314: end if;
315:
316: g_prim_rate_type := bis_common_parameters.get_rate_type;
317: g_sec_rate_type := bis_common_parameters.get_secondary_rate_type;

Line 340: FII_UTIL.put_line('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);

336: RAISE G_LOGIN_INFO_NOT_AVABLE;
337: END IF;
338:
339: if g_debug_flag = 'Y' then
340: FII_UTIL.put_line('User ID: ' || g_fii_user_id || ' Login ID: ' || g_fii_login_id);
341: end if;
342:
343: EXCEPTION
344: WHEN G_LOGIN_INFO_NOT_AVABLE THEN

Line 413: fii_util.put_line(' ');

409: BEGIN
410: g_state := 'Checking to see which additional rates need to be defined, if any';
411:
412: if g_debug_flag = 'Y' then
413: fii_util.put_line(' ');
414: fii_util.put_line(g_state);
415: fii_util.start_timer;
416: fii_util.put_line('');
417: end if;

Line 414: fii_util.put_line(g_state);

410: g_state := 'Checking to see which additional rates need to be defined, if any';
411:
412: if g_debug_flag = 'Y' then
413: fii_util.put_line(' ');
414: fii_util.put_line(g_state);
415: fii_util.start_timer;
416: fii_util.put_line('');
417: end if;
418:

Line 415: fii_util.start_timer;

411:
412: if g_debug_flag = 'Y' then
413: fii_util.put_line(' ');
414: fii_util.put_line(g_state);
415: fii_util.start_timer;
416: fii_util.put_line('');
417: end if;
418:
419: SELECT COUNT(*)

Line 416: fii_util.put_line('');

412: if g_debug_flag = 'Y' then
413: fii_util.put_line(' ');
414: fii_util.put_line(g_state);
415: fii_util.start_timer;
416: fii_util.put_line('');
417: end if;
418:
419: SELECT COUNT(*)
420: INTO l_miss_rates_prim

Line 495: FII_UTIL.put_line('Error occured while ' || g_state);

491: WHEN OTHERS THEN
492: g_errbuf:=sqlerrm;
493: g_retcode:= -1;
494: g_exception_msg := g_retcode || ':' || g_errbuf;
495: FII_UTIL.put_line('Error occured while ' || g_state);
496: FII_UTIL.put_line(g_exception_msg);
497: RAISE;
498: END Verify_Missing_Rates;
499:

Line 496: FII_UTIL.put_line(g_exception_msg);

492: g_errbuf:=sqlerrm;
493: g_retcode:= -1;
494: g_exception_msg := g_retcode || ':' || g_errbuf;
495: FII_UTIL.put_line('Error occured while ' || g_state);
496: FII_UTIL.put_line(g_exception_msg);
497: RAISE;
498: END Verify_Missing_Rates;
499:
500:

Line 543: fii_util.put_line(' ');

539:
540: g_state := 'Loading data into rates table';
541:
542: if g_debug_flag = 'Y' then
543: fii_util.put_line(' ');
544: fii_util.put_line(g_state);
545: fii_util.start_timer;
546: fii_util.put_line('');
547: end if;

Line 544: fii_util.put_line(g_state);

540: g_state := 'Loading data into rates table';
541:
542: if g_debug_flag = 'Y' then
543: fii_util.put_line(' ');
544: fii_util.put_line(g_state);
545: fii_util.start_timer;
546: fii_util.put_line('');
547: end if;
548:

Line 545: fii_util.start_timer;

541:
542: if g_debug_flag = 'Y' then
543: fii_util.put_line(' ');
544: fii_util.put_line(g_state);
545: fii_util.start_timer;
546: fii_util.put_line('');
547: end if;
548:
549: INSERT INTO FII_AP_PS_RATES_TEMP

Line 546: fii_util.put_line('');

542: if g_debug_flag = 'Y' then
543: fii_util.put_line(' ');
544: fii_util.put_line(g_state);
545: fii_util.start_timer;
546: fii_util.put_line('');
547: end if;
548:
549: INSERT INTO FII_AP_PS_RATES_TEMP
550: (Functional_Currency,

Line 568: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

564: Invoice_Date Trx_Date
565: FROM FII_AP_RATES_GT);
566:
567: if g_debug_flag = 'Y' then
568: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
569: fii_util.stop_timer;
570: fii_util.print_timer('Duration');
571: end if;
572:

Line 569: fii_util.stop_timer;

565: FROM FII_AP_RATES_GT);
566:
567: if g_debug_flag = 'Y' then
568: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
569: fii_util.stop_timer;
570: fii_util.print_timer('Duration');
571: end if;
572:
573:

Line 570: fii_util.print_timer('Duration');

566:
567: if g_debug_flag = 'Y' then
568: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
569: fii_util.stop_timer;
570: fii_util.print_timer('Duration');
571: end if;
572:
573:
574: if g_debug_flag = 'Y' then

Line 575: fii_util.put_line(' ');

571: end if;
572:
573:
574: if g_debug_flag = 'Y' then
575: fii_util.put_line(' ');
576: fii_util.put_line('Loading data into functional rates table');
577: fii_util.start_timer;
578: fii_util.put_line('');
579: end if;

Line 576: fii_util.put_line('Loading data into functional rates table');

572:
573:
574: if g_debug_flag = 'Y' then
575: fii_util.put_line(' ');
576: fii_util.put_line('Loading data into functional rates table');
577: fii_util.start_timer;
578: fii_util.put_line('');
579: end if;
580:

Line 577: fii_util.start_timer;

573:
574: if g_debug_flag = 'Y' then
575: fii_util.put_line(' ');
576: fii_util.put_line('Loading data into functional rates table');
577: fii_util.start_timer;
578: fii_util.put_line('');
579: end if;
580:
581:

Line 578: fii_util.put_line('');

574: if g_debug_flag = 'Y' then
575: fii_util.put_line(' ');
576: fii_util.put_line('Loading data into functional rates table');
577: fii_util.start_timer;
578: fii_util.put_line('');
579: end if;
580:
581:
582: INSERT INTO FII_AP_FUNC_RATES_TEMP

Line 610: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

606: FROM FII_AP_RATES_GT);
607:
608:
609: if g_debug_flag = 'Y' then
610: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
611: fii_util.stop_timer;
612: fii_util.print_timer('Duration');
613: end if;
614:

Line 611: fii_util.stop_timer;

607:
608:
609: if g_debug_flag = 'Y' then
610: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
611: fii_util.stop_timer;
612: fii_util.print_timer('Duration');
613: end if;
614:
615: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PS_RATES_TEMP');

Line 612: fii_util.print_timer('Duration');

608:
609: if g_debug_flag = 'Y' then
610: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
611: fii_util.stop_timer;
612: fii_util.print_timer('Duration');
613: end if;
614:
615: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PS_RATES_TEMP');
616:

Line 625: FII_UTIL.put_line('Error occured while ' || g_state);

621: WHEN OTHERS THEN
622: g_errbuf:=sqlerrm;
623: g_retcode:= -1;
624: g_exception_msg := g_retcode || ':' || g_errbuf;
625: FII_UTIL.put_line('Error occured while ' || g_state);
626: FII_UTIL.put_line(g_exception_msg);
627: RAISE;
628:
629: END Insert_Rates;

Line 626: FII_UTIL.put_line(g_exception_msg);

622: g_errbuf:=sqlerrm;
623: g_retcode:= -1;
624: g_exception_msg := g_retcode || ':' || g_errbuf;
625: FII_UTIL.put_line('Error occured while ' || g_state);
626: FII_UTIL.put_line(g_exception_msg);
627: RAISE;
628:
629: END Insert_Rates;
630:

Line 645: FII_UTIL.put_line('');

641: BEGIN
642:
643: g_state := 'Inside the procedure DELETE_SUMMARY';
644: if g_debug_flag = 'Y' then
645: FII_UTIL.put_line('');
646: FII_UTIL.put_line(g_state);
647: end if;
648:
649: g_state := 'Deleting records from the FII_AP_AGING_BKTS_B table';

Line 646: FII_UTIL.put_line(g_state);

642:
643: g_state := 'Inside the procedure DELETE_SUMMARY';
644: if g_debug_flag = 'Y' then
645: FII_UTIL.put_line('');
646: FII_UTIL.put_line(g_state);
647: end if;
648:
649: g_state := 'Deleting records from the FII_AP_AGING_BKTS_B table';
650: if g_debug_flag = 'Y' then

Line 651: FII_UTIL.put_line('');

647: end if;
648:
649: g_state := 'Deleting records from the FII_AP_AGING_BKTS_B table';
650: if g_debug_flag = 'Y' then
651: FII_UTIL.put_line('');
652: FII_UTIL.put_line(g_state);
653: end if;
654:
655: DELETE FROM FII_AP_AGING_BKTS_B

Line 652: FII_UTIL.put_line(g_state);

648:
649: g_state := 'Deleting records from the FII_AP_AGING_BKTS_B table';
650: if g_debug_flag = 'Y' then
651: FII_UTIL.put_line('');
652: FII_UTIL.put_line(g_state);
653: end if;
654:
655: DELETE FROM FII_AP_AGING_BKTS_B
656: WHERE Invoice_ID IN (SELECT Key_Value1_Num

Line 662: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_AGING_BKTS_B');

658: WHERE Table_Name = 'AP_INVOICES'
659: AND Operation_Flag = 'D');
660:
661: if g_debug_flag = 'Y' then
662: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_AGING_BKTS_B');
663: FII_UTIL.put_line('');
664: end if;
665:
666:

Line 663: FII_UTIL.put_line('');

659: AND Operation_Flag = 'D');
660:
661: if g_debug_flag = 'Y' then
662: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_AGING_BKTS_B');
663: FII_UTIL.put_line('');
664: end if;
665:
666:
667: g_state := 'Deleting records from the FII_AP_DUE_COUNTS_B table';

Line 669: FII_UTIL.put_line('');

665:
666:
667: g_state := 'Deleting records from the FII_AP_DUE_COUNTS_B table';
668: if g_debug_flag = 'Y' then
669: FII_UTIL.put_line('');
670: FII_UTIL.put_line(g_state);
671: end if;
672:
673: DELETE FROM FII_AP_DUE_COUNTS_B

Line 670: FII_UTIL.put_line(g_state);

666:
667: g_state := 'Deleting records from the FII_AP_DUE_COUNTS_B table';
668: if g_debug_flag = 'Y' then
669: FII_UTIL.put_line('');
670: FII_UTIL.put_line(g_state);
671: end if;
672:
673: DELETE FROM FII_AP_DUE_COUNTS_B
674: WHERE Invoice_ID IN (SELECT Key_Value1_Num

Line 680: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_DUE_COUNTS_B');

676: WHERE Table_Name = 'AP_INVOICES'
677: AND Operation_Flag = 'D');
678:
679: if g_debug_flag = 'Y' then
680: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_DUE_COUNTS_B');
681: FII_UTIL.put_line('');
682: end if;
683:
684:

Line 681: FII_UTIL.put_line('');

677: AND Operation_Flag = 'D');
678:
679: if g_debug_flag = 'Y' then
680: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_DUE_COUNTS_B');
681: FII_UTIL.put_line('');
682: end if;
683:
684:
685: g_state := 'Deleting records from the FII_AP_INV_HOLDS_B table';

Line 687: FII_UTIL.put_line('');

683:
684:
685: g_state := 'Deleting records from the FII_AP_INV_HOLDS_B table';
686: if g_debug_flag = 'Y' then
687: FII_UTIL.put_line('');
688: FII_UTIL.put_line(g_state);
689: end if;
690:
691: DELETE FROM FII_AP_INV_HOLDS_B

Line 688: FII_UTIL.put_line(g_state);

684:
685: g_state := 'Deleting records from the FII_AP_INV_HOLDS_B table';
686: if g_debug_flag = 'Y' then
687: FII_UTIL.put_line('');
688: FII_UTIL.put_line(g_state);
689: end if;
690:
691: DELETE FROM FII_AP_INV_HOLDS_B
692: WHERE Invoice_ID IN (SELECT Key_Value1_Num

Line 698: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_INV_HOLDS_B');

694: WHERE Table_Name = 'AP_INVOICES'
695: AND Operation_Flag = 'D');
696:
697: if g_debug_flag = 'Y' then
698: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_INV_HOLDS_B');
699: FII_UTIL.put_line('');
700: end if;
701:
702:

Line 699: FII_UTIL.put_line('');

695: AND Operation_Flag = 'D');
696:
697: if g_debug_flag = 'Y' then
698: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_INV_HOLDS_B');
699: FII_UTIL.put_line('');
700: end if;
701:
702:
703: g_state := 'Deleting records from the FII_AP_HOLD_HIST_B table';

Line 705: FII_UTIL.put_line('');

701:
702:
703: g_state := 'Deleting records from the FII_AP_HOLD_HIST_B table';
704: if g_debug_flag = 'Y' then
705: FII_UTIL.put_line('');
706: FII_UTIL.put_line(g_state);
707: end if;
708:
709: DELETE FROM FII_AP_HOLD_HIST_B

Line 706: FII_UTIL.put_line(g_state);

702:
703: g_state := 'Deleting records from the FII_AP_HOLD_HIST_B table';
704: if g_debug_flag = 'Y' then
705: FII_UTIL.put_line('');
706: FII_UTIL.put_line(g_state);
707: end if;
708:
709: DELETE FROM FII_AP_HOLD_HIST_B
710: WHERE Invoice_ID IN (SELECT Key_Value1_Num

Line 716: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_HOLD_HIST_B');

712: WHERE Table_Name = 'AP_INVOICES'
713: AND Operation_Flag = 'D');
714:
715: if g_debug_flag = 'Y' then
716: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_HOLD_HIST_B');
717: FII_UTIL.put_line('');
718: end if;
719:
720:

Line 717: FII_UTIL.put_line('');

713: AND Operation_Flag = 'D');
714:
715: if g_debug_flag = 'Y' then
716: FII_UTIL.put_line('Deleted '|| SQL%ROWCOUNT ||' records from the FII_AP_HOLD_HIST_B');
717: FII_UTIL.put_line('');
718: end if;
719:
720:
721: EXCEPTION

Line 726: FII_UTIL.put_line('Error occured while ' || g_state);

722: WHEN OTHERS THEN
723: g_errbuf:=sqlerrm;
724: g_retcode:= -1;
725: g_exception_msg := g_retcode || ':' || g_errbuf;
726: FII_UTIL.put_line('Error occured while ' || g_state);
727: FII_UTIL.put_line(g_exception_msg);
728: RAISE;
729:
730: END DELETE_SUMMARY;

Line 727: FII_UTIL.put_line(g_exception_msg);

723: g_errbuf:=sqlerrm;
724: g_retcode:= -1;
725: g_exception_msg := g_retcode || ':' || g_errbuf;
726: FII_UTIL.put_line('Error occured while ' || g_state);
727: FII_UTIL.put_line(g_exception_msg);
728: RAISE;
729:
730: END DELETE_SUMMARY;
731:

Line 745: FII_UTIL.put_line('Inside the procedure POPULATE_HOLDS_SUM');

741:
742: BEGIN
743:
744: if g_debug_flag = 'Y' then
745: FII_UTIL.put_line('Inside the procedure POPULATE_HOLDS_SUM');
746: end if;
747:
748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';
749: if g_debug_flag = 'Y' then

Line 750: FII_UTIL.put_line('');

746: end if;
747:
748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';
749: if g_debug_flag = 'Y' then
750: FII_UTIL.put_line('');
751: FII_UTIL.put_line(g_state);
752: FII_UTIL.start_timer;
753: FII_UTIL.put_line('');
754: end if;

Line 751: FII_UTIL.put_line(g_state);

747:
748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';
749: if g_debug_flag = 'Y' then
750: FII_UTIL.put_line('');
751: FII_UTIL.put_line(g_state);
752: FII_UTIL.start_timer;
753: FII_UTIL.put_line('');
754: end if;
755:

Line 752: FII_UTIL.start_timer;

748: g_state := 'Deleting holds from FII_AP_INV_HOLDS_B';
749: if g_debug_flag = 'Y' then
750: FII_UTIL.put_line('');
751: FII_UTIL.put_line(g_state);
752: FII_UTIL.start_timer;
753: FII_UTIL.put_line('');
754: end if;
755:
756: DELETE FROM FII_AP_INV_HOLDS_B

Line 753: FII_UTIL.put_line('');

749: if g_debug_flag = 'Y' then
750: FII_UTIL.put_line('');
751: FII_UTIL.put_line(g_state);
752: FII_UTIL.start_timer;
753: FII_UTIL.put_line('');
754: end if;
755:
756: DELETE FROM FII_AP_INV_HOLDS_B
757: WHERE Invoice_ID IN (SELECT /*+ cardinality(T,100) */ Key_Value1_Num

Line 770: FII_UTIL.put_line(g_state);

766: AND Log.Table_Name = 'AP_INVOICES');
767:
768: g_state := 'Populating FII_AP_INV_HOLDS_B FROM AP_HOLDS_ALL table';
769: if g_debug_flag = 'Y' then
770: FII_UTIL.put_line(g_state);
771: end if;
772:
773: INSERT INTO FII_AP_INV_HOLDS_B
774: (Time_ID,

Line 839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');

835: AND AI.Invoice_Type NOT IN ('PREPAYMENT')
836: AND AH.Invoice_ID = T.Key_Value1_Num;
837:
838: if g_debug_flag = 'Y' then
839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');
840: FII_UTIL.put_line('');
841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;

Line 840: FII_UTIL.put_line('');

836: AND AH.Invoice_ID = T.Key_Value1_Num;
837:
838: if g_debug_flag = 'Y' then
839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');
840: FII_UTIL.put_line('');
841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;
844:

Line 841: FII_UTIL.stop_timer;

837:
838: if g_debug_flag = 'Y' then
839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');
840: FII_UTIL.put_line('');
841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;
844:
845: UPDATE FII_AP_INV_HOLDS_B HSUM

Line 842: FII_UTIL.print_timer('Duration');

838: if g_debug_flag = 'Y' then
839: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' records into FII_AP_INV_HOLDS_B');
840: FII_UTIL.put_line('');
841: FII_UTIL.stop_timer;
842: FII_UTIL.print_timer('Duration');
843: end if;
844:
845: UPDATE FII_AP_INV_HOLDS_B HSUM
846: SET Supplier_ID = (SELECT AI.Supplier_ID

Line 861: FII_UTIL.put_line('Error occured while ' || g_state);

857: WHEN OTHERS THEN
858: g_errbuf:=sqlerrm;
859: g_retcode:= -1;
860: g_exception_msg := g_retcode || ':' || g_errbuf;
861: FII_UTIL.put_line('Error occured while ' || g_state);
862: FII_UTIL.put_line(g_exception_msg);
863: RAISE;
864:
865: END;

Line 862: FII_UTIL.put_line(g_exception_msg);

858: g_errbuf:=sqlerrm;
859: g_retcode:= -1;
860: g_exception_msg := g_retcode || ':' || g_errbuf;
861: FII_UTIL.put_line('Error occured while ' || g_state);
862: FII_UTIL.put_line(g_exception_msg);
863: RAISE;
864:
865: END;
866:

Line 881: FII_UTIL.put_line('');

877: BEGIN
878:
879: g_state := 'Inside the procedure POPULATE_HOLD_HISTORY';
880: if g_debug_flag = 'Y' then
881: FII_UTIL.put_line('');
882: FII_UTIL.put_line(g_state);
883: end if;
884:
885: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';

Line 882: FII_UTIL.put_line(g_state);

878:
879: g_state := 'Inside the procedure POPULATE_HOLD_HISTORY';
880: if g_debug_flag = 'Y' then
881: FII_UTIL.put_line('');
882: FII_UTIL.put_line(g_state);
883: end if;
884:
885: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
886: if g_debug_flag = 'Y' then

Line 887: FII_UTIL.put_line('');

883: end if;
884:
885: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
886: if g_debug_flag = 'Y' then
887: FII_UTIL.put_line('');
888: FII_UTIL.put_line(g_state);
889: end if;
890:
891:

Line 888: FII_UTIL.put_line(g_state);

884:
885: g_state := 'Deleting records from FII_AP_HOLD_HIST_B that are already existing';
886: if g_debug_flag = 'Y' then
887: FII_UTIL.put_line('');
888: FII_UTIL.put_line(g_state);
889: end if;
890:
891:
892: /* Deleting the records from the Hold History table. This will ensure

Line 911: FII_UTIL.put_line(g_state);

907:
908:
909: g_state := 'Populating FII_AP_HOLD_HIST_B FROM AP_HOLDS_ALL table';
910: if g_debug_flag = 'Y' then
911: FII_UTIL.put_line(g_state);
912: end if;
913:
914: g_state := 'Populating Hold records';
915: if g_debug_flag = 'Y' then

Line 916: FII_UTIL.put_line(g_state);

912: end if;
913:
914: g_state := 'Populating Hold records';
915: if g_debug_flag = 'Y' then
916: FII_UTIL.put_line(g_state);
917: FII_UTIL.start_timer;
918: FII_UTIL.put_line('');
919: end if;
920:

Line 917: FII_UTIL.start_timer;

913:
914: g_state := 'Populating Hold records';
915: if g_debug_flag = 'Y' then
916: FII_UTIL.put_line(g_state);
917: FII_UTIL.start_timer;
918: FII_UTIL.put_line('');
919: end if;
920:
921: /* If in the AP_HOLDS_ALL table there are overlapping holds then we

Line 918: FII_UTIL.put_line('');

914: g_state := 'Populating Hold records';
915: if g_debug_flag = 'Y' then
916: FII_UTIL.put_line(g_state);
917: FII_UTIL.start_timer;
918: FII_UTIL.put_line('');
919: end if;
920:
921: /* If in the AP_HOLDS_ALL table there are overlapping holds then we
922: will only select the first hold and insert into the hold history table.

Line 995: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');

991: AND ah2.release_lookup_code IS NULL))));
992:
993:
994: if g_debug_flag = 'Y' then
995: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
996: FII_UTIL.put_line('');
997: FII_UTIL.stop_timer;
998: FII_UTIL.print_timer('Duration');
999: end if;

Line 996: FII_UTIL.put_line('');

992:
993:
994: if g_debug_flag = 'Y' then
995: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
996: FII_UTIL.put_line('');
997: FII_UTIL.stop_timer;
998: FII_UTIL.print_timer('Duration');
999: end if;
1000:

Line 997: FII_UTIL.stop_timer;

993:
994: if g_debug_flag = 'Y' then
995: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
996: FII_UTIL.put_line('');
997: FII_UTIL.stop_timer;
998: FII_UTIL.print_timer('Duration');
999: end if;
1000:
1001: g_state := 'Updating the Seq_ID on the Release records';

Line 998: FII_UTIL.print_timer('Duration');

994: if g_debug_flag = 'Y' then
995: FII_UTIL.put_line('Inserted '|| SQL%ROWCOUNT ||' Hold and Release records into FII_AP_HOLD_HIST_B');
996: FII_UTIL.put_line('');
997: FII_UTIL.stop_timer;
998: FII_UTIL.print_timer('Duration');
999: end if;
1000:
1001: g_state := 'Updating the Seq_ID on the Release records';
1002: if g_debug_flag = 'Y' then

Line 1003: FII_UTIL.put_line(g_state);

999: end if;
1000:
1001: g_state := 'Updating the Seq_ID on the Release records';
1002: if g_debug_flag = 'Y' then
1003: FII_UTIL.put_line(g_state);
1004: FII_UTIL.start_timer;
1005: FII_UTIL.put_line('');
1006: end if;
1007:

Line 1004: FII_UTIL.start_timer;

1000:
1001: g_state := 'Updating the Seq_ID on the Release records';
1002: if g_debug_flag = 'Y' then
1003: FII_UTIL.put_line(g_state);
1004: FII_UTIL.start_timer;
1005: FII_UTIL.put_line('');
1006: end if;
1007:
1008: UPDATE FII_AP_Hold_Hist_B HH

Line 1005: FII_UTIL.put_line('');

1001: g_state := 'Updating the Seq_ID on the Release records';
1002: if g_debug_flag = 'Y' then
1003: FII_UTIL.put_line(g_state);
1004: FII_UTIL.start_timer;
1005: FII_UTIL.put_line('');
1006: end if;
1007:
1008: UPDATE FII_AP_Hold_Hist_B HH
1009: SET Seq_ID = (SELECT HH1.Seq_ID

Line 1030: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');

1026: AND HH.Period_Type_ID = 1
1027: AND HH.Seq_ID IS NULL;
1028:
1029: if g_debug_flag = 'Y' then
1030: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
1031: FII_UTIL.put_line('');
1032: FII_UTIL.stop_timer;
1033: FII_UTIL.print_timer('Duration');
1034: end if;

Line 1031: FII_UTIL.put_line('');

1027: AND HH.Seq_ID IS NULL;
1028:
1029: if g_debug_flag = 'Y' then
1030: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
1031: FII_UTIL.put_line('');
1032: FII_UTIL.stop_timer;
1033: FII_UTIL.print_timer('Duration');
1034: end if;
1035:

Line 1032: FII_UTIL.stop_timer;

1028:
1029: if g_debug_flag = 'Y' then
1030: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
1031: FII_UTIL.put_line('');
1032: FII_UTIL.stop_timer;
1033: FII_UTIL.print_timer('Duration');
1034: end if;
1035:
1036:

Line 1033: FII_UTIL.print_timer('Duration');

1029: if g_debug_flag = 'Y' then
1030: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Release records in the FII_AP_HOLD_HIST_B');
1031: FII_UTIL.put_line('');
1032: FII_UTIL.stop_timer;
1033: FII_UTIL.print_timer('Duration');
1034: end if;
1035:
1036:
1037: g_state := 'Updating the Hold Count on the Hold and Release records';

Line 1039: FII_UTIL.put_line(g_state);

1035:
1036:
1037: g_state := 'Updating the Hold Count on the Hold and Release records';
1038: if g_debug_flag = 'Y' then
1039: FII_UTIL.put_line(g_state);
1040: FII_UTIL.start_timer;
1041: FII_UTIL.put_line('');
1042: end if;
1043: /*

Line 1040: FII_UTIL.start_timer;

1036:
1037: g_state := 'Updating the Hold Count on the Hold and Release records';
1038: if g_debug_flag = 'Y' then
1039: FII_UTIL.put_line(g_state);
1040: FII_UTIL.start_timer;
1041: FII_UTIL.put_line('');
1042: end if;
1043: /*
1044: UPDATE FII_AP_Hold_Hist_B HH

Line 1041: FII_UTIL.put_line('');

1037: g_state := 'Updating the Hold Count on the Hold and Release records';
1038: if g_debug_flag = 'Y' then
1039: FII_UTIL.put_line(g_state);
1040: FII_UTIL.start_timer;
1041: FII_UTIL.put_line('');
1042: end if;
1043: /*
1044: UPDATE FII_AP_Hold_Hist_B HH
1045: SET Hold_Count = (SELECT DECODE(HH.Action,'H', COUNT(*), -1 * COUNT(*))

Line 1081: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');

1077: AND Operation_Flag = 'U');
1078:
1079:
1080: if g_debug_flag = 'Y' then
1081: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
1082: FII_UTIL.put_line('');
1083: FII_UTIL.stop_timer;
1084: FII_UTIL.print_timer('Duration');
1085: end if;

Line 1082: FII_UTIL.put_line('');

1078:
1079:
1080: if g_debug_flag = 'Y' then
1081: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
1082: FII_UTIL.put_line('');
1083: FII_UTIL.stop_timer;
1084: FII_UTIL.print_timer('Duration');
1085: end if;
1086:

Line 1083: FII_UTIL.stop_timer;

1079:
1080: if g_debug_flag = 'Y' then
1081: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
1082: FII_UTIL.put_line('');
1083: FII_UTIL.stop_timer;
1084: FII_UTIL.print_timer('Duration');
1085: end if;
1086:
1087: /*

Line 1084: FII_UTIL.print_timer('Duration');

1080: if g_debug_flag = 'Y' then
1081: FII_UTIL.put_line('Updated '|| SQL%ROWCOUNT ||' Hold Counts in the FII_AP_HOLD_HIST_B');
1082: FII_UTIL.put_line('');
1083: FII_UTIL.stop_timer;
1084: FII_UTIL.print_timer('Duration');
1085: end if;
1086:
1087: /*
1088: if g_debug_flag = 'Y' then

Line 1089: FII_UTIL.put_line('Calling procedure ROLLUP_HOLD_HISTORY');

1085: end if;
1086:
1087: /*
1088: if g_debug_flag = 'Y' then
1089: FII_UTIL.put_line('Calling procedure ROLLUP_HOLD_HISTORY');
1090: FII_UTIL.put_line('');
1091: end if;
1092:
1093: ROLLUP_HOLD_HISTORY;

Line 1090: FII_UTIL.put_line('');

1086:
1087: /*
1088: if g_debug_flag = 'Y' then
1089: FII_UTIL.put_line('Calling procedure ROLLUP_HOLD_HISTORY');
1090: FII_UTIL.put_line('');
1091: end if;
1092:
1093: ROLLUP_HOLD_HISTORY;
1094: */

Line 1101: FII_UTIL.put_line('Error occured while ' || g_state);

1097: WHEN OTHERS THEN
1098: g_errbuf:=sqlerrm;
1099: g_retcode:= -1;
1100: g_exception_msg := g_retcode || ':' || g_errbuf;
1101: FII_UTIL.put_line('Error occured while ' || g_state);
1102: FII_UTIL.put_line(g_exception_msg);
1103: RAISE;
1104:
1105: END POPULATE_HOLD_HISTORY;

Line 1102: FII_UTIL.put_line(g_exception_msg);

1098: g_errbuf:=sqlerrm;
1099: g_retcode:= -1;
1100: g_exception_msg := g_retcode || ':' || g_errbuf;
1101: FII_UTIL.put_line('Error occured while ' || g_state);
1102: FII_UTIL.put_line(g_exception_msg);
1103: RAISE;
1104:
1105: END POPULATE_HOLD_HISTORY;
1106:

Line 1169: FII_UTIL.put_line('Error in procedure Insert_Deleted_Rec.');

1165: END IF;
1166:
1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: FII_UTIL.put_line('Error in procedure Insert_Deleted_Rec.');
1170: RAISE;
1171: END Insert_Deleted_Rec;
1172:
1173: ------------------------------------------------------------------

Line 1284: FII_UTIL.put_line('Error in procedure Insert_Pay_Sched_B_Rec.');

1280: END IF; --IF Update_Only_Flag = 'Y'
1281:
1282: EXCEPTION
1283: WHEN OTHERS THEN
1284: FII_UTIL.put_line('Error in procedure Insert_Pay_Sched_B_Rec.');
1285: RAISE;
1286:
1287: END Insert_Pay_Sched_B_Rec;
1288:

Line 1357: FII_UTIL.put_line('Error in procedure Insert_Invoice_B_Rec.');

1353: END IF;
1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: FII_UTIL.put_line('Error in procedure Insert_Invoice_B_Rec.');
1358: RAISE;
1359:
1360: END Insert_Invoice_B_Rec;
1361:

Line 1375: FII_UTIL.put_line(g_state);

1371: l_timestamp1_tmp BINARY_INTEGER;
1372: BEGIN
1373: g_state := 'Begin populating Memory Structures.';
1374: if g_debug_flag = 'Y' then
1375: FII_UTIL.put_line(g_state);
1376: end if;
1377:
1378: l_timestamp1 := DBMS_UTILITY.Get_Time;
1379: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1448: FII_UTIL.put_line('The Invoices Memory Structure has been populated with ' || FII_AP_Inv_MS.COUNT || ' Invoices.');

1444: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1445:
1446:
1447: if g_debug_flag = 'Y' then
1448: FII_UTIL.put_line('The Invoices Memory Structure has been populated with ' || FII_AP_Inv_MS.COUNT || ' Invoices.');
1449: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1450: end if;
1451:
1452: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1449: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1445:
1446:
1447: if g_debug_flag = 'Y' then
1448: FII_UTIL.put_line('The Invoices Memory Structure has been populated with ' || FII_AP_Inv_MS.COUNT || ' Invoices.');
1449: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1450: end if;
1451:
1452: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1453:

Line 1476: FII_UTIL.put_line('The Payment Schedules Memory Structure has been populated with ' || FII_AP_Pay_Sched_MS.COUNT || ' Payment Schedules.');

1472:
1473: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1474:
1475: if g_debug_flag = 'Y' then
1476: FII_UTIL.put_line('The Payment Schedules Memory Structure has been populated with ' || FII_AP_Pay_Sched_MS.COUNT || ' Payment Schedules.');
1477: FII_UTIL.put_line('The time taken to populate the Payment Schedules Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1478: end if;
1479:
1480: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1477: FII_UTIL.put_line('The time taken to populate the Payment Schedules Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1473: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1474:
1475: if g_debug_flag = 'Y' then
1476: FII_UTIL.put_line('The Payment Schedules Memory Structure has been populated with ' || FII_AP_Pay_Sched_MS.COUNT || ' Payment Schedules.');
1477: FII_UTIL.put_line('The time taken to populate the Payment Schedules Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1478: end if;
1479:
1480: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1481:

Line 1510: FII_UTIL.put_line('The Invoice Payments Memory Structure has been populated with ' || FII_AP_Inv_Pay_MS.COUNT || ' Invoice Payments.');

1506:
1507: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1508:
1509: if g_debug_flag = 'Y' then
1510: FII_UTIL.put_line('The Invoice Payments Memory Structure has been populated with ' || FII_AP_Inv_Pay_MS.COUNT || ' Invoice Payments.');
1511: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');
1512: end if;
1513:
1514:

Line 1511: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');

1507: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1508:
1509: if g_debug_flag = 'Y' then
1510: FII_UTIL.put_line('The Invoice Payments Memory Structure has been populated with ' || FII_AP_Inv_Pay_MS.COUNT || ' Invoice Payments.');
1511: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');
1512: end if;
1513:
1514:
1515:

Line 1542: FII_UTIL.put_line('The Withholding/Tax Memory Structure has been populated with ' || FII_AP_WH_Tax_MS.COUNT || ' Withholding/Tax Distributions.');

1538:
1539: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1540:
1541: if g_debug_flag = 'Y' then
1542: FII_UTIL.put_line('The Withholding/Tax Memory Structure has been populated with ' || FII_AP_WH_Tax_MS.COUNT || ' Withholding/Tax Distributions.');
1543: FII_UTIL.put_line('The time taken to populate the Withholding/Tax Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1544: end if;
1545:
1546: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1543: FII_UTIL.put_line('The time taken to populate the Withholding/Tax Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1539: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1540:
1541: if g_debug_flag = 'Y' then
1542: FII_UTIL.put_line('The Withholding/Tax Memory Structure has been populated with ' || FII_AP_WH_Tax_MS.COUNT || ' Withholding/Tax Distributions.');
1543: FII_UTIL.put_line('The time taken to populate the Withholding/Tax Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1544: end if;
1545:
1546: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1547:

Line 1600: FII_UTIL.put_line('The Prepayments Applied Memory Structure has been populated with ' || FII_AP_Prepay_Applied_MS.COUNT || ' Prepayments Applied .');

1596:
1597: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1598:
1599: if g_debug_flag = 'Y' then
1600: FII_UTIL.put_line('The Prepayments Applied Memory Structure has been populated with ' || FII_AP_Prepay_Applied_MS.COUNT || ' Prepayments Applied .');
1601: FII_UTIL.put_line('The time taken to populate the Prepayments Applied Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');
1602: end if;
1603:
1604:

Line 1601: FII_UTIL.put_line('The time taken to populate the Prepayments Applied Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');

1597: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1598:
1599: if g_debug_flag = 'Y' then
1600: FII_UTIL.put_line('The Prepayments Applied Memory Structure has been populated with ' || FII_AP_Prepay_Applied_MS.COUNT || ' Prepayments Applied .');
1601: FII_UTIL.put_line('The time taken to populate the Prepayments Applied Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');
1602: end if;
1603:
1604:
1605:

Line 1661: FII_UTIL.put_line('The Memory Structure FII_AP_Pay_Sched_B_MS has been populated with ' || FII_AP_Pay_Sched_B_MS.COUNT || ' records.');

1657:
1658: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1659:
1660: if g_debug_flag = 'Y' then
1661: FII_UTIL.put_line('The Memory Structure FII_AP_Pay_Sched_B_MS has been populated with ' || FII_AP_Pay_Sched_B_MS.COUNT || ' records.');
1662: FII_UTIL.put_line('The time taken to populate FII_AP_Pay_Sched_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1663: end if;
1664:
1665:

Line 1662: FII_UTIL.put_line('The time taken to populate FII_AP_Pay_Sched_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1658: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1659:
1660: if g_debug_flag = 'Y' then
1661: FII_UTIL.put_line('The Memory Structure FII_AP_Pay_Sched_B_MS has been populated with ' || FII_AP_Pay_Sched_B_MS.COUNT || ' records.');
1662: FII_UTIL.put_line('The time taken to populate FII_AP_Pay_Sched_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1663: end if;
1664:
1665:
1666: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');

1687:
1688: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1689:
1690: if g_debug_flag = 'Y' then
1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');
1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1693: end if;
1694:
1695:

Line 1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1688: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1689:
1690: if g_debug_flag = 'Y' then
1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');
1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1693: end if;
1694:
1695:
1696: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

Line 1699: FII_UTIL.put_line('The time taken to populate all Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');

1695:
1696: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
1697:
1698: if g_debug_flag = 'Y' then
1699: FII_UTIL.put_line('The time taken to populate all Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');
1700: end if;
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN

Line 1704: FII_UTIL.put_line('Error in procedure Populate_Memory_Structures.');

1700: end if;
1701:
1702: EXCEPTION
1703: WHEN OTHERS THEN
1704: FII_UTIL.put_line('Error in procedure Populate_Memory_Structures.');
1705: RAISE;
1706:
1707: END POPULATE_MEMORY_STRUCTURES;
1708:

Line 1734: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Invoice_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1730:
1731: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1732:
1733: if g_debug_flag = 'Y' then
1734: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Invoice_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1735: end if;
1736:
1737: g_state := 'Bulk inserting into FII_AP_Invoice_UI_GT from FII_AP_Invoice_UI_MS.';
1738: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1748: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Invoice_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1744:
1745: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1746:
1747: if g_debug_flag = 'Y' then
1748: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Invoice_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1749: end if;
1750:
1751: g_state := 'Bulk inserting into FII_AP_Pay_Sched_D_GT from FII_AP_Pay_Sched_D_MS.';
1752: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1758:
1759: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1760:
1761: if g_debug_flag = 'Y' then
1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1763: end if;
1764:
1765: g_state := 'Bulk inserting into FII_AP_Pay_Sched_UI_GT from FII_AP_Pay_Sched_UI_MS.';
1766: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1776: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Pay_Sched_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1772:
1773: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1774:
1775: if g_debug_flag = 'Y' then
1776: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Pay_Sched_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1777: end if;
1778:
1779:
1780: g_state := 'Bulk inserting into FII_AP_Aging_Bkts_B from FII_AP_Aging_Bkts_B_MS.';

Line 1791: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Aging_Bkts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1787:
1788: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1789:
1790: if g_debug_flag = 'Y' then
1791: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Aging_Bkts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1792: end if;
1793:
1794: g_state := 'Bulk inserting into FII_AP_Due_Counts_B from FII_AP_Due_Counts_B_MS.';
1795: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1805: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Due_Counts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1801:
1802: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1803:
1804: if g_debug_flag = 'Y' then
1805: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Due_Counts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1806: end if;
1807:
1808: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
1809: if g_debug_flag = 'Y' then

Line 1810: FII_UTIL.put_line('The time taken to populate all Tables from Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');

1806: end if;
1807:
1808: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
1809: if g_debug_flag = 'Y' then
1810: FII_UTIL.put_line('The time taken to populate all Tables from Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');
1811: end if;
1812:
1813: EXCEPTION
1814: WHEN OTHERS THEN

Line 1815: FII_UTIL.put_line('Error in procedure Populate_Tables_From_MS.');

1811: end if;
1812:
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: FII_UTIL.put_line('Error in procedure Populate_Tables_From_MS.');
1816: RAISE;
1817:
1818: END Populate_Tables_From_MS;
1819:

Line 1835: FII_UTIL.put_line(g_state);

1831: BEGIN
1832:
1833: g_state := 'Deleting records from FII_AP_Pay_Sched_B.';
1834: if g_debug_flag = 'Y' then
1835: FII_UTIL.put_line(g_state);
1836: end if;
1837:
1838: l_timestamp1 := DBMS_UTILITY.Get_Time;
1839: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 1855: FII_UTIL.put_line('The time taken to delete records from FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1851:
1852: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1853:
1854: if g_debug_flag = 'Y' then
1855: FII_UTIL.put_line('The time taken to delete records from FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1856: end if;
1857:
1858: g_state := 'Updating and Inserting records in FII_AP_Pay_Sched_B.';
1859: if g_debug_flag = 'Y' then

Line 1860: FII_UTIL.put_line(g_state);

1856: end if;
1857:
1858: g_state := 'Updating and Inserting records in FII_AP_Pay_Sched_B.';
1859: if g_debug_flag = 'Y' then
1860: FII_UTIL.put_line(g_state);
1861: end if;
1862:
1863: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1864:

Line 1997: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1993:
1994: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1995:
1996: if g_debug_flag = 'Y' then
1997: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1998: end if;
1999:
2000: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2001: if g_debug_flag = 'Y' then

Line 2002: FII_UTIL.put_line('The time taken to maintain FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1/100) || ' seconds.');

1998: end if;
1999:
2000: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2001: if g_debug_flag = 'Y' then
2002: FII_UTIL.put_line('The time taken to maintain FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1/100) || ' seconds.');
2003: end if;
2004:
2005:
2006: EXCEPTION

Line 2008: FII_UTIL.put_line('Error in procedure Maintain_Pay_Sched_B.');

2004:
2005:
2006: EXCEPTION
2007: WHEN OTHERS THEN
2008: FII_UTIL.put_line('Error in procedure Maintain_Pay_Sched_B.');
2009: RAISE;
2010:
2011: END Maintain_Pay_Sched_B;
2012:

Line 2028: FII_UTIL.put_line(g_state);

2024: BEGIN
2025:
2026: g_state := 'Deleting records from FII_AP_Invoice_B.';
2027: if g_debug_flag = 'Y' then
2028: FII_UTIL.put_line(g_state);
2029: end if;
2030:
2031: l_timestamp1 := DBMS_UTILITY.Get_Time;
2032: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 2043: FII_UTIL.put_line('The time taken to delete records from FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

2039:
2040: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
2041:
2042: if g_debug_flag = 'Y' then
2043: FII_UTIL.put_line('The time taken to delete records from FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
2044: end if;
2045:
2046: g_state := 'Updating and Inserting records in FII_Invoice_B.';
2047: if g_debug_flag = 'Y' then

Line 2048: FII_UTIL.put_line(g_state);

2044: end if;
2045:
2046: g_state := 'Updating and Inserting records in FII_Invoice_B.';
2047: if g_debug_flag = 'Y' then
2048: FII_UTIL.put_line(g_state);
2049: end if;
2050:
2051: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
2052:

Line 2121: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

2117:
2118: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
2119:
2120: if g_debug_flag = 'Y' then
2121: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
2122: end if;
2123:
2124: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2125: if g_debug_flag = 'Y' then

Line 2126: FII_UTIL.put_line('The time taken to maintain FII_AP_Invoice_B is: ' || to_char(l_timestamp1/100) || ' seconds.');

2122: end if;
2123:
2124: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2125: if g_debug_flag = 'Y' then
2126: FII_UTIL.put_line('The time taken to maintain FII_AP_Invoice_B is: ' || to_char(l_timestamp1/100) || ' seconds.');
2127: end if;
2128:
2129:
2130: EXCEPTION

Line 2132: FII_UTIL.put_line('Error in procedure Maintain_Invoice_B.');

2128:
2129:
2130: EXCEPTION
2131: WHEN OTHERS THEN
2132: FII_UTIL.put_line('Error in procedure Maintain_Invoice_B.');
2133: RAISE;
2134:
2135: END Maintain_Invoice_B;
2136:

Line 2162: FII_UTIL.put_line('');

2158: BEGIN
2159:
2160: g_state := 'Deleting existing records from FII_AP_AGING_BKTS_B';
2161: if g_debug_flag = 'Y' then
2162: FII_UTIL.put_line('');
2163: FII_UTIL.put_line(g_state);
2164: end if;
2165:
2166: DELETE /*+ index(A, FII_AP_AGING_BKTS_B_N1) */ FROM FII_AP_Aging_Bkts_B A

Line 2163: FII_UTIL.put_line(g_state);

2159:
2160: g_state := 'Deleting existing records from FII_AP_AGING_BKTS_B';
2161: if g_debug_flag = 'Y' then
2162: FII_UTIL.put_line('');
2163: FII_UTIL.put_line(g_state);
2164: end if;
2165:
2166: DELETE /*+ index(A, FII_AP_AGING_BKTS_B_N1) */ FROM FII_AP_Aging_Bkts_B A
2167: WHERE Invoice_ID IN (SELECT Invoice_ID

Line 2173: FII_UTIL.put_line('');

2169: WHERE Pay_Sched_B_Flag = 'Y');
2170:
2171: g_state := 'Deleting existing records from FII_AP_DUE_COUNTS_B';
2172: if g_debug_flag = 'Y' then
2173: FII_UTIL.put_line('');
2174: FII_UTIL.put_line(g_state);
2175: end if;
2176:
2177: DELETE /*+ index(A, FII_AP_DUE_COUNTS_B_N1) */ FROM FII_AP_Due_Counts_B A

Line 2174: FII_UTIL.put_line(g_state);

2170:
2171: g_state := 'Deleting existing records from FII_AP_DUE_COUNTS_B';
2172: if g_debug_flag = 'Y' then
2173: FII_UTIL.put_line('');
2174: FII_UTIL.put_line(g_state);
2175: end if;
2176:
2177: DELETE /*+ index(A, FII_AP_DUE_COUNTS_B_N1) */ FROM FII_AP_Due_Counts_B A
2178: WHERE Invoice_ID IN (SELECT Invoice_ID

Line 2221: FII_UTIL.put_line(g_state);

2217: l_prepay_applied_marker := FII_AP_Prepay_Applied_MS.First;
2218:
2219: g_state := 'Begin looping through Invoices Memory Structure.';
2220: if g_debug_flag = 'Y' then
2221: FII_UTIL.put_line(g_state);
2222: end if;
2223:
2224: FOR x in 1..FII_AP_Inv_MS.COUNT LOOP
2225: DECLARE

Line 2816: FII_UTIL.put_line('Error occured while inserting applied prepayment record into FII_AP_Aging_MS.');

2812: l_ps_aging.Past_Due_Bucket1 := l_ps_pdb1;
2813: FII_AP_PS_Aging_MS(to_char(l_ps_aging.Action_Date, 'RRRR/MM/DD')) := l_ps_aging;
2814:
2815: WHEN OTHERS THEN
2816: FII_UTIL.put_line('Error occured while inserting applied prepayment record into FII_AP_Aging_MS.');
2817: RAISE;
2818: END;
2819: END IF; --IF l_inv_has_mult_ps = 'N' THEN
2820:

Line 3029: FII_UTIL.put_line('Error occured while inserting creation record into FII_AP_Aging_MS.');

3025: l_ps_aging.Past_Due_Bucket1 := l_ps_pdb1;
3026: FII_AP_PS_Aging_MS(to_char(l_ps_aging.Action_Date, 'RRRR/MM/DD')) := l_ps_aging;
3027:
3028: WHEN OTHERS THEN
3029: FII_UTIL.put_line('Error occured while inserting creation record into FII_AP_Aging_MS.');
3030: RAISE;
3031: END;
3032: END IF;
3033:

Line 3365: FII_UTIL.put_line('Error occured while inserting due bucket/due/past bucket record into FII_AP_Aging_MS.');

3361: l_ps_aging.Past_Due_Bucket1 := l_ps_pdb1;
3362: FII_AP_PS_Aging_MS(to_char(l_ps_aging.Action_Date, 'RRRR/MM/DD')) := l_ps_aging;
3363:
3364: WHEN OTHERS THEN
3365: FII_UTIL.put_line('Error occured while inserting due bucket/due/past bucket record into FII_AP_Aging_MS.');
3366: RAISE;
3367: END;
3368: END IF;
3369:

Line 3614: FII_UTIL.put_line('Error occured while inserting invoice payment record into FII_AP_Aging_MS.');

3610: l_ps_aging.Past_Due_Bucket1 := l_ps_pdb1;
3611: FII_AP_PS_Aging_MS(to_char(l_ps_aging.Action_Date, 'RRRR/MM/DD')) := l_ps_aging;
3612:
3613: WHEN OTHERS THEN
3614: FII_UTIL.put_line('Error occured while inserting invoice payment record into FII_AP_Aging_MS.');
3615: RAISE;
3616: END;
3617: END IF; --IF l_inv_has_mult_ps = 'N' THEN
3618:

Line 3867: FII_UTIL.put_line('Error occured while inserting wh/tax record into FII_AP_Aging_MS.');

3863: l_ps_aging.Past_Due_Bucket1 := l_ps_pdb1;
3864: FII_AP_PS_Aging_MS(to_char(l_ps_aging.Action_Date, 'RRRR/MM/DD')) := l_ps_aging;
3865:
3866: WHEN OTHERS THEN
3867: FII_UTIL.put_line('Error occured while inserting wh/tax record into FII_AP_Aging_MS.');
3868: RAISE;
3869: END;
3870: END IF; --IF l_inv_has_mult_ps = 'N' THEN
3871:

Line 3923: fii_util.put_line('WARNING: Not all prepayment applied to invoice ' || l_invoice.Invoice_ID || ' have been allocated.');

3919:
3920: WHILE l_prepay_applied_marker IS NOT NULL
3921: AND FII_AP_Prepay_Applied_MS(l_prepay_applied_marker).Invoice_ID <= l_invoice.Invoice_ID LOOP
3922: if g_debug_flag = 'Y' then
3923: fii_util.put_line('WARNING: Not all prepayment applied to invoice ' || l_invoice.Invoice_ID || ' have been allocated.');
3924: end if;
3925: l_prepay_applied_marker := FII_AP_Prepay_Applied_MS.Next(l_prepay_applied_marker);
3926: END LOOP;
3927:

Line 4147: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp2/100) || ' seconds.');

4143: INSERT_DELETED_REC(NULL, NULL);
4144:
4145: --Print out time breakdown for each table.
4146: if g_debug_flag = 'Y' then
4147: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp2/100) || ' seconds.');
4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');
4149: FII_UTIL.put_line('The time taken to populate FII_AP_Aging_Bkts_B_MS and FII_AP_Due_Counts_B_MS is: ' || to_char(l_timestamp4/100) || ' seconds.');
4150: end if;
4151:

Line 4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');

4144:
4145: --Print out time breakdown for each table.
4146: if g_debug_flag = 'Y' then
4147: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp2/100) || ' seconds.');
4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');
4149: FII_UTIL.put_line('The time taken to populate FII_AP_Aging_Bkts_B_MS and FII_AP_Due_Counts_B_MS is: ' || to_char(l_timestamp4/100) || ' seconds.');
4150: end if;
4151:
4152:

Line 4149: FII_UTIL.put_line('The time taken to populate FII_AP_Aging_Bkts_B_MS and FII_AP_Due_Counts_B_MS is: ' || to_char(l_timestamp4/100) || ' seconds.');

4145: --Print out time breakdown for each table.
4146: if g_debug_flag = 'Y' then
4147: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp2/100) || ' seconds.');
4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');
4149: FII_UTIL.put_line('The time taken to populate FII_AP_Aging_Bkts_B_MS and FII_AP_Due_Counts_B_MS is: ' || to_char(l_timestamp4/100) || ' seconds.');
4150: end if;
4151:
4152:
4153: --Populate Tables from Memory Structures.

Line 4190: FII_UTIL.put_line('Error occured while ' || g_state);

4186: WHEN OTHERS THEN
4187: g_errbuf:=sqlerrm;
4188: g_retcode:= -1;
4189: g_exception_msg := g_retcode || ':' || g_errbuf;
4190: FII_UTIL.put_line('Error occured while ' || g_state);
4191: FII_UTIL.put_line(g_exception_msg);
4192: RAISE;
4193: END POPULATE_INV_PAY_SCHED_SUM;
4194:

Line 4191: FII_UTIL.put_line(g_exception_msg);

4187: g_errbuf:=sqlerrm;
4188: g_retcode:= -1;
4189: g_exception_msg := g_retcode || ':' || g_errbuf;
4190: FII_UTIL.put_line('Error occured while ' || g_state);
4191: FII_UTIL.put_line(g_exception_msg);
4192: RAISE;
4193: END POPULATE_INV_PAY_SCHED_SUM;
4194:
4195:

Line 4224: FII_UTIL.put_line(g_state);

4220:
4221: BEGIN
4222: g_state := 'Inside the procedure COLLECT';
4223: if g_debug_flag = 'Y' then
4224: FII_UTIL.put_line(g_state);
4225: end if;
4226:
4227: Retcode := 0;
4228:

Line 4236: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE

4232: ------------------------------------------------------
4233: l_dir:='/sqlcom/log';
4234:
4235: ----------------------------------------------------------------
4236: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
4237: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
4238: -- the log files and output files are written to
4239: ----------------------------------------------------------------
4240: FII_UTIL.initialize('FII_AP_INV_SUM_INC.log','FII_AP_INV_SUM_INC.out',l_dir, 'FII_AP_INV_SUM_INC');

Line 4240: FII_UTIL.initialize('FII_AP_INV_SUM_INC.log','FII_AP_INV_SUM_INC.out',l_dir, 'FII_AP_INV_SUM_INC');

4236: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
4237: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
4238: -- the log files and output files are written to
4239: ----------------------------------------------------------------
4240: FII_UTIL.initialize('FII_AP_INV_SUM_INC.log','FII_AP_INV_SUM_INC.out',l_dir, 'FII_AP_INV_SUM_INC');
4241:
4242: -------------------------------------------------------------
4243: -- Check if FII: DBI Payables Operations Implementation profile
4244: -- is turned on. If yes, continue, otherwise, error out. User

Line 4273: FII_UTIL.put_line('');

4269: --g_timestamp4 - last Payables Operation load.
4270: -------------------------------------------------------------
4271: g_state := 'Defining timestamps to maintain ap_dbi_log.';
4272: IF g_debug_flag = 'Y' then
4273: FII_UTIL.put_line('');
4274: FII_UTIL.put_line(g_state);
4275: fii_util.put_line('');
4276: END IF;
4277:

Line 4274: FII_UTIL.put_line(g_state);

4270: -------------------------------------------------------------
4271: g_state := 'Defining timestamps to maintain ap_dbi_log.';
4272: IF g_debug_flag = 'Y' then
4273: FII_UTIL.put_line('');
4274: FII_UTIL.put_line(g_state);
4275: fii_util.put_line('');
4276: END IF;
4277:
4278: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;

Line 4275: fii_util.put_line('');

4271: g_state := 'Defining timestamps to maintain ap_dbi_log.';
4272: IF g_debug_flag = 'Y' then
4273: FII_UTIL.put_line('');
4274: FII_UTIL.put_line(g_state);
4275: fii_util.put_line('');
4276: END IF;
4277:
4278: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
4279:

Line 4322: FII_UTIL.put_line('Start date is: ' || g_start_date);

4318: g_old_act_part1 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp2), 'J')), 32);
4319: g_old_act_part2 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp2+1), 'J')), 32);
4320:
4321: if g_debug_flag = 'Y' then
4322: FII_UTIL.put_line('Start date is: ' || g_start_date);
4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);
4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));

Line 4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);

4319: g_old_act_part2 := MOD(TO_NUMBER(TO_CHAR(TRUNC(g_timestamp2+1), 'J')), 32);
4320:
4321: if g_debug_flag = 'Y' then
4322: FII_UTIL.put_line('Start date is: ' || g_start_date);
4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);
4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));

Line 4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));

4321: if g_debug_flag = 'Y' then
4322: FII_UTIL.put_line('Start date is: ' || g_start_date);
4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);
4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
4328: FII_UTIL.put_line('Previous Payables Operations Load Timestamp is: ' || to_char(g_timestamp4, 'YYYY/MM/DD HH24:MI:SS'));
4329: end if;

Line 4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));

4322: FII_UTIL.put_line('Start date is: ' || g_start_date);
4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);
4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
4328: FII_UTIL.put_line('Previous Payables Operations Load Timestamp is: ' || to_char(g_timestamp4, 'YYYY/MM/DD HH24:MI:SS'));
4329: end if;
4330:

Line 4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));

4323: FII_UTIL.put_line('Last load included invoices to date ' || g_last_start_date);
4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
4328: FII_UTIL.put_line('Previous Payables Operations Load Timestamp is: ' || to_char(g_timestamp4, 'YYYY/MM/DD HH24:MI:SS'));
4329: end if;
4330:
4331: IF g_timestamp4 + 30 < g_timestamp1 THEN

Line 4328: FII_UTIL.put_line('Previous Payables Operations Load Timestamp is: ' || to_char(g_timestamp4, 'YYYY/MM/DD HH24:MI:SS'));

4324:
4325: FII_UTIL.put_line('Current Load Timestamp is: ' || to_char(g_timestamp1, 'YYYY/MM/DD HH24:MI:SS'));
4326: FII_UTIL.put_line('Previous Payables Load Timestamp is: ' || to_char(g_timestamp2, 'YYYY/MM/DD HH24:MI:SS'));
4327: FII_UTIL.put_line('Previous Payables Expenses Load Timestamp is: ' || to_char(g_timestamp3, 'YYYY/MM/DD HH24:MI:SS'));
4328: FII_UTIL.put_line('Previous Payables Operations Load Timestamp is: ' || to_char(g_timestamp4, 'YYYY/MM/DD HH24:MI:SS'));
4329: end if;
4330:
4331: IF g_timestamp4 + 30 < g_timestamp1 THEN
4332: g_errbuf := fnd_message.get_string('FII', 'FII_AP_RUN_INIT');

Line 4338: FII_UTIL.put_line('-------------------------------------------------');

4334: END IF;
4335:
4336:
4337: if g_debug_flag = 'Y' then
4338: FII_UTIL.put_line('-------------------------------------------------');
4339: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
4340: FII_UTIL.put_line('-------------------------------------------------');
4341: end if;
4342:

Line 4339: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');

4335:
4336:
4337: if g_debug_flag = 'Y' then
4338: FII_UTIL.put_line('-------------------------------------------------');
4339: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
4340: FII_UTIL.put_line('-------------------------------------------------');
4341: end if;
4342:
4343: INIT;

Line 4340: FII_UTIL.put_line('-------------------------------------------------');

4336:
4337: if g_debug_flag = 'Y' then
4338: FII_UTIL.put_line('-------------------------------------------------');
4339: FII_UTIL.put_line('Calling the Init procedure to initialize the global variables');
4340: FII_UTIL.put_line('-------------------------------------------------');
4341: end if;
4342:
4343: INIT;
4344:

Line 4397: FII_UTIL.put_line('');

4393:
4394:
4395: g_state := 'Inserting records into the FII_AP_INVOICE_IDS table';
4396: if g_debug_flag = 'Y' then
4397: FII_UTIL.put_line('');
4398: FII_UTIL.put_line(g_state);
4399: FII_UTIL.start_timer;
4400: FII_UTIL.put_line('');
4401: end if;

Line 4398: FII_UTIL.put_line(g_state);

4394:
4395: g_state := 'Inserting records into the FII_AP_INVOICE_IDS table';
4396: if g_debug_flag = 'Y' then
4397: FII_UTIL.put_line('');
4398: FII_UTIL.put_line(g_state);
4399: FII_UTIL.start_timer;
4400: FII_UTIL.put_line('');
4401: end if;
4402:

Line 4399: FII_UTIL.start_timer;

4395: g_state := 'Inserting records into the FII_AP_INVOICE_IDS table';
4396: if g_debug_flag = 'Y' then
4397: FII_UTIL.put_line('');
4398: FII_UTIL.put_line(g_state);
4399: FII_UTIL.start_timer;
4400: FII_UTIL.put_line('');
4401: end if;
4402:
4403: INSERT INTO FII_AP_Invoice_IDS

Line 4400: FII_UTIL.put_line('');

4396: if g_debug_flag = 'Y' then
4397: FII_UTIL.put_line('');
4398: FII_UTIL.put_line(g_state);
4399: FII_UTIL.start_timer;
4400: FII_UTIL.put_line('');
4401: end if;
4402:
4403: INSERT INTO FII_AP_Invoice_IDS
4404: (Invoice_ID,

Line 4505: FII_UTIL.put_line('-------------------------------------------------');

4501: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_INVOICE_IDS');
4502:
4503:
4504: if g_debug_flag = 'Y' then
4505: FII_UTIL.put_line('-------------------------------------------------');
4506: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
4507: FII_UTIL.put_line('-------------------------------------------------');
4508: end if;
4509:

Line 4506: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');

4502:
4503:
4504: if g_debug_flag = 'Y' then
4505: FII_UTIL.put_line('-------------------------------------------------');
4506: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
4507: FII_UTIL.put_line('-------------------------------------------------');
4508: end if;
4509:
4510: INSERT_RATES;

Line 4507: FII_UTIL.put_line('-------------------------------------------------');

4503:
4504: if g_debug_flag = 'Y' then
4505: FII_UTIL.put_line('-------------------------------------------------');
4506: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
4507: FII_UTIL.put_line('-------------------------------------------------');
4508: end if;
4509:
4510: INSERT_RATES;
4511:

Line 4513: FII_UTIL.put_line('-------------------------------------------------');

4509:
4510: INSERT_RATES;
4511:
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('-------------------------------------------------');
4514: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
4515: FII_UTIL.put_line('-------------------------------------------------');
4516: end if;
4517:

Line 4514: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');

4510: INSERT_RATES;
4511:
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('-------------------------------------------------');
4514: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
4515: FII_UTIL.put_line('-------------------------------------------------');
4516: end if;
4517:
4518: IF (VERIFY_MISSING_RATES = -1) THEN

Line 4515: FII_UTIL.put_line('-------------------------------------------------');

4511:
4512: if g_debug_flag = 'Y' then
4513: FII_UTIL.put_line('-------------------------------------------------');
4514: FII_UTIL.put_line('Calling the Verify_Missing_Rates procedure');
4515: FII_UTIL.put_line('-------------------------------------------------');
4516: end if;
4517:
4518: IF (VERIFY_MISSING_RATES = -1) THEN
4519: g_retcode := -1;

Line 4531: FII_UTIL.put_line('-------------------------------------------------');

4527: -----------------------------------------------------------------------
4528: ELSE
4529:
4530: if g_debug_flag = 'Y' then
4531: FII_UTIL.put_line('-------------------------------------------------');
4532: FII_UTIL.put_line('Calling procedure DELETE_SUMMARY');
4533: FII_UTIL.put_line('-------------------------------------------------');
4534: end if;
4535:

Line 4532: FII_UTIL.put_line('Calling procedure DELETE_SUMMARY');

4528: ELSE
4529:
4530: if g_debug_flag = 'Y' then
4531: FII_UTIL.put_line('-------------------------------------------------');
4532: FII_UTIL.put_line('Calling procedure DELETE_SUMMARY');
4533: FII_UTIL.put_line('-------------------------------------------------');
4534: end if;
4535:
4536: DELETE_SUMMARY;

Line 4533: FII_UTIL.put_line('-------------------------------------------------');

4529:
4530: if g_debug_flag = 'Y' then
4531: FII_UTIL.put_line('-------------------------------------------------');
4532: FII_UTIL.put_line('Calling procedure DELETE_SUMMARY');
4533: FII_UTIL.put_line('-------------------------------------------------');
4534: end if;
4535:
4536: DELETE_SUMMARY;
4537: g_retcode := 0;

Line 4541: FII_UTIL.put_line('-------------------------------------------------');

4537: g_retcode := 0;
4538:
4539:
4540: if g_debug_flag = 'Y' then
4541: FII_UTIL.put_line('-------------------------------------------------');
4542: FII_UTIL.put_line('Calling procedure POPULATE_INV_PAY_SCHED_SUM');
4543: FII_UTIL.put_line('-------------------------------------------------');
4544: end if;
4545:

Line 4542: FII_UTIL.put_line('Calling procedure POPULATE_INV_PAY_SCHED_SUM');

4538:
4539:
4540: if g_debug_flag = 'Y' then
4541: FII_UTIL.put_line('-------------------------------------------------');
4542: FII_UTIL.put_line('Calling procedure POPULATE_INV_PAY_SCHED_SUM');
4543: FII_UTIL.put_line('-------------------------------------------------');
4544: end if;
4545:
4546: POPULATE_INV_PAY_SCHED_SUM;

Line 4543: FII_UTIL.put_line('-------------------------------------------------');

4539:
4540: if g_debug_flag = 'Y' then
4541: FII_UTIL.put_line('-------------------------------------------------');
4542: FII_UTIL.put_line('Calling procedure POPULATE_INV_PAY_SCHED_SUM');
4543: FII_UTIL.put_line('-------------------------------------------------');
4544: end if;
4545:
4546: POPULATE_INV_PAY_SCHED_SUM;
4547: g_retcode := 0;

Line 4551: FII_UTIL.put_line('-------------------------------------------------');

4547: g_retcode := 0;
4548:
4549:
4550: if g_debug_flag = 'Y' then
4551: FII_UTIL.put_line('-------------------------------------------------');
4552: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
4553: FII_UTIL.put_line('-------------------------------------------------');
4554: end if;
4555:

Line 4552: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');

4548:
4549:
4550: if g_debug_flag = 'Y' then
4551: FII_UTIL.put_line('-------------------------------------------------');
4552: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
4553: FII_UTIL.put_line('-------------------------------------------------');
4554: end if;
4555:
4556: POPULATE_HOLDS_SUM;

Line 4553: FII_UTIL.put_line('-------------------------------------------------');

4549:
4550: if g_debug_flag = 'Y' then
4551: FII_UTIL.put_line('-------------------------------------------------');
4552: FII_UTIL.put_line('Calling procedure POPULATE_HOLDS_SUM');
4553: FII_UTIL.put_line('-------------------------------------------------');
4554: end if;
4555:
4556: POPULATE_HOLDS_SUM;
4557: g_retcode := 0;

Line 4561: FII_UTIL.put_line('-------------------------------------------------');

4557: g_retcode := 0;
4558:
4559:
4560: if g_debug_flag = 'Y' then
4561: FII_UTIL.put_line('-------------------------------------------------');
4562: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
4563: FII_UTIL.put_line('-------------------------------------------------');
4564: end if;
4565:

Line 4562: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');

4558:
4559:
4560: if g_debug_flag = 'Y' then
4561: FII_UTIL.put_line('-------------------------------------------------');
4562: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
4563: FII_UTIL.put_line('-------------------------------------------------');
4564: end if;
4565:
4566: POPULATE_HOLD_HISTORY;

Line 4563: FII_UTIL.put_line('-------------------------------------------------');

4559:
4560: if g_debug_flag = 'Y' then
4561: FII_UTIL.put_line('-------------------------------------------------');
4562: FII_UTIL.put_line('Calling procedure POPULATE_HOLD_HISTORY');
4563: FII_UTIL.put_line('-------------------------------------------------');
4564: end if;
4565:
4566: POPULATE_HOLD_HISTORY;
4567: g_retcode := 0;

Line 4575: fii_util.put_line(g_state);

4571: IF g_timestamp3 + 30 >= g_timestamp1 AND g_exp_imp_prof_flag = 'Y' THEN --Copy records into Expense log table.
4572:
4573: g_state := 'Copying records from partition ' || i || ' into FII_AP_DBI_LOG_EXP_T.';
4574: if g_debug_flag = 'Y' then
4575: fii_util.put_line(g_state);
4576: end if;
4577:
4578:
4579: INSERT INTO FII_AP_DBI_LOG_EXP_T(

Line 4624: FII_UTIL.put_line('return code is ' || retcode);

4620:
4621: COMMIT;
4622:
4623: if g_debug_flag = 'Y' then
4624: FII_UTIL.put_line('return code is ' || retcode);
4625: end if;
4626: Retcode := g_retcode;
4627:
4628: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';

Line 4641: FII_UTIL.put_line('Error occured while ' || g_state);

4637: g_errbuf:=g_errbuf;
4638: g_retcode:= -1;
4639: retcode:=g_retcode;
4640: g_exception_msg := g_retcode || ':' || g_errbuf;
4641: FII_UTIL.put_line('Error occured while ' || g_state);
4642: FII_UTIL.put_line(g_exception_msg);
4643:
4644: END;
4645:

Line 4642: FII_UTIL.put_line(g_exception_msg);

4638: g_retcode:= -1;
4639: retcode:=g_retcode;
4640: g_exception_msg := g_retcode || ':' || g_errbuf;
4641: FII_UTIL.put_line('Error occured while ' || g_state);
4642: FII_UTIL.put_line(g_exception_msg);
4643:
4644: END;
4645:
4646: END FII_AP_INV_SUM_INC;