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.IEX_AGING_BUCKETS_PKG dependencies on IEX_DEBUG_PUB

Line 496: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

492: -- Get the aging buckets definition.
493: --
494: -- IF PG_DEBUG < 10 THEN
495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
497: END IF;
498: -- IF PG_DEBUG < 10 THEN
499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
500: IEX_DEBUG_PUB.LogMessage

Line 500: IEX_DEBUG_PUB.LogMessage

496: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
497: END IF;
498: -- IF PG_DEBUG < 10 THEN
499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
500: IEX_DEBUG_PUB.LogMessage
501: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> Start <<--- ');
502: END IF;
503: -- IF PG_DEBUG < 10 THEN
504: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 505: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

501: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> Start <<--- ');
502: END IF;
503: -- IF PG_DEBUG < 10 THEN
504: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
505: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
506: END IF;
507:
508: OPEN c_sel_bucket_data;
509: FETCH c_sel_bucket_data

Line 519: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 0 [' || to_char(p_bucket_line_id_0)

515: p_bucket_line_id_0,
516: p_bucket_seq_num_0 ;
517: -- IF PG_DEBUG < 10 THEN
518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
519: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 0 [' || to_char(p_bucket_line_id_0)
520: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_0));
521: END IF;
522:
523:

Line 539: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 1 [' || to_char(p_bucket_line_id_1)

535: p_bucket_seq_num_1 ;
536:
537: -- IF PG_DEBUG < 10 THEN
538: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
539: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 1 [' || to_char(p_bucket_line_id_1)
540: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_1));
541: END IF;
542:
543: ELSE

Line 562: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 2 [' || to_char(p_bucket_line_id_2)

558: p_bucket_line_id_2,
559: p_bucket_seq_num_2 ;
560: -- IF PG_DEBUG < 10 THEN
561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
562: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 2 [' || to_char(p_bucket_line_id_2)
563: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_2));
564: END IF;
565:
566: ELSE

Line 585: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 3 [' || to_char(p_bucket_line_id_3)

581: p_bucket_line_id_3,
582: p_bucket_seq_num_3 ;
583: -- IF PG_DEBUG < 10 THEN
584: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
585: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 3 [' || to_char(p_bucket_line_id_3)
586: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_3));
587: END IF;
588:
589: ELSE

Line 608: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 4 [' || to_char(p_bucket_line_id_4)

604: p_bucket_line_id_4,
605: p_bucket_seq_num_4 ;
606: -- IF PG_DEBUG < 10 THEN
607: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
608: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 4 [' || to_char(p_bucket_line_id_4)
609: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_4));
610: END IF;
611:
612: ELSE

Line 631: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 5 [' || to_char(p_bucket_line_id_5)

627: p_bucket_line_id_5,
628: p_bucket_seq_num_5 ;
629: -- IF PG_DEBUG < 10 THEN
630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
631: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 5 [' || to_char(p_bucket_line_id_5)
632: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_5));
633: END IF;
634:
635: ELSE

Line 654: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 6 [' || to_char(p_bucket_line_id_6)

650: p_bucket_line_id_6,
651: p_bucket_seq_num_6 ;
652: -- IF PG_DEBUG < 10 THEN
653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
654: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 6 [' || to_char(p_bucket_line_id_6)
655: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_6));
656: END IF;
657:
658: ELSE

Line 721: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

717: CLOSE c_buckets;
718:
719: -- IF PG_DEBUG < 10 THEN
720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
721: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
722: END IF;
723: -- IF PG_DEBUG < 10 THEN
724: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
725: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 0 - id [' || to_char(p_bucket_line_id_0)

Line 725: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 0 - id [' || to_char(p_bucket_line_id_0)

721: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
722: END IF;
723: -- IF PG_DEBUG < 10 THEN
724: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
725: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 0 - id [' || to_char(p_bucket_line_id_0)
726: || '] Seq [' || to_char(p_bucket_seq_num_0) || ' Desc [' ||
727: p_bucket_titletop_0 || ' ' || p_bucket_titlebottom_0 || '] Amt [' ||
728: to_char(p_bucket_amount_0));
729: END IF;

Line 732: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

728: to_char(p_bucket_amount_0));
729: END IF;
730: -- IF PG_DEBUG < 10 THEN
731: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
732: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
733: END IF;
734:
735: -- IF PG_DEBUG < 10 THEN
736: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 737: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 1 - id [' || to_char(p_bucket_line_id_1)

733: END IF;
734:
735: -- IF PG_DEBUG < 10 THEN
736: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
737: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 1 - id [' || to_char(p_bucket_line_id_1)
738: || '] Seq [' || to_char(p_bucket_seq_num_1) || ' Desc [' ||
739: p_bucket_titletop_1 || ' ' || p_bucket_titlebottom_1 || '] Amt [' ||
740: to_char(p_bucket_amount_1));
741: END IF;

Line 746: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

742:
743:
744: -- IF PG_DEBUG < 10 THEN
745: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
746: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
747: END IF;
748: -- IF PG_DEBUG < 10 THEN
749: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
750: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 2 - id [' || to_char(p_bucket_line_id_2)

Line 750: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 2 - id [' || to_char(p_bucket_line_id_2)

746: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
747: END IF;
748: -- IF PG_DEBUG < 10 THEN
749: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
750: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 2 - id [' || to_char(p_bucket_line_id_2)
751: || '] Seq [' || to_char(p_bucket_seq_num_2) || ' Desc [' ||
752: p_bucket_titletop_2 || ' ' || p_bucket_titlebottom_2 || '] Amt [' ||
753: to_char(p_bucket_amount_2));
754: END IF;

Line 757: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

753: to_char(p_bucket_amount_2));
754: END IF;
755: -- IF PG_DEBUG < 10 THEN
756: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
757: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
758: END IF;
759:
760: -- IF PG_DEBUG < 10 THEN
761: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 762: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 3 - id [' || to_char(p_bucket_line_id_3)

758: END IF;
759:
760: -- IF PG_DEBUG < 10 THEN
761: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
762: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 3 - id [' || to_char(p_bucket_line_id_3)
763: || '] Seq [' || to_char(p_bucket_seq_num_3) || ' Desc [' ||
764: p_bucket_titletop_3 || ' ' || p_bucket_titlebottom_3 || '] Amt [' ||
765: to_char(p_bucket_amount_3));
766: END IF;

Line 769: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

765: to_char(p_bucket_amount_3));
766: END IF;
767: -- IF PG_DEBUG < 10 THEN
768: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
769: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
770: END IF;
771:
772: -- IF PG_DEBUG < 10 THEN
773: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 774: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 4 - id [' || to_char(p_bucket_line_id_4)

770: END IF;
771:
772: -- IF PG_DEBUG < 10 THEN
773: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
774: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 4 - id [' || to_char(p_bucket_line_id_4)
775: || '] Seq [' || to_char(p_bucket_seq_num_4) || ' Desc [' ||
776: p_bucket_titletop_4 || ' ' || p_bucket_titlebottom_4 || '] Amt [' ||
777: to_char(p_bucket_amount_4));
778: END IF;

Line 781: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

777: to_char(p_bucket_amount_4));
778: END IF;
779: -- IF PG_DEBUG < 10 THEN
780: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
781: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
782: END IF;
783:
784: -- IF PG_DEBUG < 10 THEN
785: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 786: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 5 - id [' || to_char(p_bucket_line_id_5)

782: END IF;
783:
784: -- IF PG_DEBUG < 10 THEN
785: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
786: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 5 - id [' || to_char(p_bucket_line_id_5)
787: || '] Seq [' || to_char(p_bucket_seq_num_5) || ' Desc [' ||
788: p_bucket_titletop_5 || ' ' || p_bucket_titlebottom_5 || '] Amt [' ||
789: to_char(p_bucket_amount_5));
790: END IF;

Line 793: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

789: to_char(p_bucket_amount_5));
790: END IF;
791: -- IF PG_DEBUG < 10 THEN
792: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
793: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
794: END IF;
795:
796: -- IF PG_DEBUG < 10 THEN
797: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 798: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 6 - id [' || to_char(p_bucket_line_id_6)

794: END IF;
795:
796: -- IF PG_DEBUG < 10 THEN
797: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
798: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 6 - id [' || to_char(p_bucket_line_id_6)
799: || '] Seq [' || to_char(p_bucket_seq_num_6) || ' Desc [' ||
800: p_bucket_titletop_6 || ' ' || p_bucket_titlebottom_6 || '] Amt [' ||
801: to_char(p_bucket_amount_6));
802: END IF;

Line 805: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

801: to_char(p_bucket_amount_6));
802: END IF;
803: -- IF PG_DEBUG < 10 THEN
804: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
805: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
806: END IF;
807:
808:
809: -- IF PG_DEBUG < 10 THEN

Line 811: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

807:
808:
809: -- IF PG_DEBUG < 10 THEN
810: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
811: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
812: END IF;
813: -- IF PG_DEBUG < 10 THEN
814: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
815: IEX_DEBUG_PUB.LogMessage

Line 815: IEX_DEBUG_PUB.LogMessage

811: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
812: END IF;
813: -- IF PG_DEBUG < 10 THEN
814: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
815: IEX_DEBUG_PUB.LogMessage
816: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> End <<--- ');
817: END IF;
818: -- IF PG_DEBUG < 10 THEN
819: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 820: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

816: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> End <<--- ');
817: END IF;
818: -- IF PG_DEBUG < 10 THEN
819: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
820: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
821: END IF;
822:
823: --
824: EXCEPTION

Line 828: iex_debug_pub.logmessage('EXCEPTION: IEX_PROFILE_AGING_PKG.calc_aging_buckets');

824: EXCEPTION
825: WHEN OTHERS THEN
826: -- IF PG_DEBUG < 10 THEN
827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
828: iex_debug_pub.logmessage('EXCEPTION: IEX_PROFILE_AGING_PKG.calc_aging_buckets');
829: END IF;
830: END calc_aging_buckets;
831: --
832: --

Line 945: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

941:
942: BEGIN
943: -- IF PG_DEBUG < 10 THEN
944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
945: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
946: END IF;
947: -- IF PG_DEBUG < 10 THEN
948: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
949: IEX_DEBUG_PUB.LogMessage

Line 949: IEX_DEBUG_PUB.LogMessage

945: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
946: END IF;
947: -- IF PG_DEBUG < 10 THEN
948: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
949: IEX_DEBUG_PUB.LogMessage
950: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> Start <<--- ');
951: END IF;
952: -- IF PG_DEBUG < 10 THEN
953: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 954: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

950: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> Start <<--- ');
951: END IF;
952: -- IF PG_DEBUG < 10 THEN
953: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
954: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
955: END IF;
956:
957: p_credits := 0;
958:

Line 981: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

977: End If ;
978: --
979: -- IF PG_DEBUG < 10 THEN
980: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
981: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
982: END IF;
983: -- IF PG_DEBUG < 10 THEN
984: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
985: IEX_DEBUG_PUB.LogMessage

Line 985: IEX_DEBUG_PUB.LogMessage

981: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
982: END IF;
983: -- IF PG_DEBUG < 10 THEN
984: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
985: IEX_DEBUG_PUB.LogMessage
986: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End <<--- ');
987: END IF;
988: -- IF PG_DEBUG < 10 THEN
989: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 990: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

986: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End <<--- ');
987: END IF;
988: -- IF PG_DEBUG < 10 THEN
989: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
990: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
991: END IF;
992:
993: EXCEPTION
994: WHEN OTHERS THEN

Line 997: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_credits');

993: EXCEPTION
994: WHEN OTHERS THEN
995: -- IF PG_DEBUG < 10 THEN
996: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
997: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_credits');
998: END IF;
999: -- IF PG_DEBUG < 10 THEN
1000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1001: iex_debug_pub.logmessage('calc_credits: ' || SQLCODE || ' ---> ' || SQLERRM);

Line 1001: iex_debug_pub.logmessage('calc_credits: ' || SQLCODE || ' ---> ' || SQLERRM);

997: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_credits');
998: END IF;
999: -- IF PG_DEBUG < 10 THEN
1000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1001: iex_debug_pub.logmessage('calc_credits: ' || SQLCODE || ' ---> ' || SQLERRM);
1002: END IF;
1003: if cust_credits%ISOPEN then
1004: CLOSE cust_credits ;
1005: End If ;

Line 1012: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

1008: End If ;
1009:
1010: -- IF PG_DEBUG < 10 THEN
1011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1012: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1013: END IF;
1014: -- IF PG_DEBUG < 10 THEN
1015: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1016: IEX_DEBUG_PUB.LogMessage

Line 1016: IEX_DEBUG_PUB.LogMessage

1012: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1013: END IF;
1014: -- IF PG_DEBUG < 10 THEN
1015: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1016: IEX_DEBUG_PUB.LogMessage
1017: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End with Exception <<--- ');
1018: END IF;
1019: -- IF PG_DEBUG < 10 THEN
1020: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1021: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);

1017: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End with Exception <<--- ');
1018: END IF;
1019: -- IF PG_DEBUG < 10 THEN
1020: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1021: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1022: END IF;
1023:
1024: END calc_credits;
1025: --

Line 1272: iex_debug_pub.logmessage

1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: -- IF PG_DEBUG < 10 THEN
1271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1272: iex_debug_pub.logmessage
1273: ('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_receipts');
1274: END IF;
1275: -- IF PG_DEBUG < 10 THEN
1276: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1277: iex_debug_pub.logmessage('calc_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);

1273: ('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_receipts');
1274: END IF;
1275: -- IF PG_DEBUG < 10 THEN
1276: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1277: iex_debug_pub.logmessage('calc_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);
1278: END IF;
1279: if cust_unapplied_cash%ISOPEN then
1280: CLOSE cust_unapplied_cash ;
1281: End If ;

Line 1288: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);

1284: End If ;
1285:
1286: -- IF PG_DEBUG < 10 THEN
1287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1288: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1289: END IF;
1290: -- IF PG_DEBUG < 10 THEN
1291: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1292: IEX_DEBUG_PUB.LogMessage

Line 1292: IEX_DEBUG_PUB.LogMessage

1288: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1289: END IF;
1290: -- IF PG_DEBUG < 10 THEN
1291: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1292: IEX_DEBUG_PUB.LogMessage
1293: ('IEX_AGING_BUCKETS_PKG.CALC_RECEIPTS --->> End with Exception <<---');
1294: END IF;
1295: -- IF PG_DEBUG < 10 THEN
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1297: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);

1293: ('IEX_AGING_BUCKETS_PKG.CALC_RECEIPTS --->> End with Exception <<---');
1294: END IF;
1295: -- IF PG_DEBUG < 10 THEN
1296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1297: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1298: END IF;
1299: END calc_receipts;
1300: --
1301: --

Line 1454: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1450: BEGIN
1451:
1452: -- IF PG_DEBUG < 10 THEN
1453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1454: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1455: END IF;
1456: -- IF PG_DEBUG < 10 THEN
1457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1458: IEX_DEBUG_PUB.LogMessage

Line 1458: IEX_DEBUG_PUB.LogMessage

1454: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1455: END IF;
1456: -- IF PG_DEBUG < 10 THEN
1457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1458: IEX_DEBUG_PUB.LogMessage
1459: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> Start <<--- ');
1460: END IF;
1461: -- IF PG_DEBUG < 10 THEN
1462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1463: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1459: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> Start <<--- ');
1460: END IF;
1461: -- IF PG_DEBUG < 10 THEN
1462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1463: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1464: END IF;
1465:
1466: p_risk_receipts := 0;
1467:

Line 1490: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1486: End If ;
1487: --
1488: -- IF PG_DEBUG < 10 THEN
1489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1490: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1491: END IF;
1492: -- IF PG_DEBUG < 10 THEN
1493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1494: IEX_DEBUG_PUB.LogMessage

Line 1494: IEX_DEBUG_PUB.LogMessage

1490: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1491: END IF;
1492: -- IF PG_DEBUG < 10 THEN
1493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1494: IEX_DEBUG_PUB.LogMessage
1495: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End <<--- ');
1496: END IF;
1497: -- IF PG_DEBUG < 10 THEN
1498: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1499: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1495: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End <<--- ');
1496: END IF;
1497: -- IF PG_DEBUG < 10 THEN
1498: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1499: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1500: END IF;
1501:
1502: EXCEPTION
1503: WHEN OTHERS THEN

Line 1506: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_risk_receipts');

1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: -- IF PG_DEBUG < 10 THEN
1505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1506: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_risk_receipts');
1507: END IF;
1508: -- IF PG_DEBUG < 10 THEN
1509: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1510: iex_debug_pub.logmessage('calc_risk_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);

Line 1510: iex_debug_pub.logmessage('calc_risk_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);

1506: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_risk_receipts');
1507: END IF;
1508: -- IF PG_DEBUG < 10 THEN
1509: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1510: iex_debug_pub.logmessage('calc_risk_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);
1511: END IF;
1512: if cust_risk_receipts%ISOPEN then
1513: CLOSE cust_risk_receipts ;
1514: End If ;

Line 1521: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1517: End If ;
1518:
1519: -- IF PG_DEBUG < 10 THEN
1520: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1521: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1522: END IF;
1523: -- IF PG_DEBUG < 10 THEN
1524: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1525: IEX_DEBUG_PUB.LogMessage

Line 1525: IEX_DEBUG_PUB.LogMessage

1521: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1522: END IF;
1523: -- IF PG_DEBUG < 10 THEN
1524: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1525: IEX_DEBUG_PUB.LogMessage
1526: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End with Exception <<--- ');
1527: END IF;
1528: -- IF PG_DEBUG < 10 THEN
1529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1530: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);

1526: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End with Exception <<--- ');
1527: END IF;
1528: -- IF PG_DEBUG < 10 THEN
1529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1530: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1531: END IF;
1532:
1533: END calc_risk_receipts;
1534: --

Line 1642: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1638:
1639: BEGIN
1640: -- IF PG_DEBUG < 10 THEN
1641: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1642: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1643: END IF;
1644: -- IF PG_DEBUG < 10 THEN
1645: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1646: IEX_DEBUG_PUB.LogMessage

Line 1646: IEX_DEBUG_PUB.LogMessage

1642: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1643: END IF;
1644: -- IF PG_DEBUG < 10 THEN
1645: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1646: IEX_DEBUG_PUB.LogMessage
1647: ('IEX_AGING_BUCKETS_PKG.CALC_DISPUTE --->> Start <<--- ');
1648: END IF;
1649: -- IF PG_DEBUG < 10 THEN
1650: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1651: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1647: ('IEX_AGING_BUCKETS_PKG.CALC_DISPUTE --->> Start <<--- ');
1648: END IF;
1649: -- IF PG_DEBUG < 10 THEN
1650: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1651: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1652: END IF;
1653:
1654: p_dispute := 0;
1655:

Line 1678: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1674: End If ;
1675: --
1676: -- IF PG_DEBUG < 10 THEN
1677: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1678: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1679: END IF;
1680: -- IF PG_DEBUG < 10 THEN
1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1682: IEX_DEBUG_PUB.LogMessage

Line 1682: IEX_DEBUG_PUB.LogMessage

1678: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1679: END IF;
1680: -- IF PG_DEBUG < 10 THEN
1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1682: IEX_DEBUG_PUB.LogMessage
1683: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End <<--- ');
1684: END IF;
1685: -- IF PG_DEBUG < 10 THEN
1686: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1687: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1683: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End <<--- ');
1684: END IF;
1685: -- IF PG_DEBUG < 10 THEN
1686: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1687: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1688: END IF;
1689:
1690: EXCEPTION
1691: WHEN OTHERS THEN

Line 1694: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_dispute');

1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: -- IF PG_DEBUG < 10 THEN
1693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1694: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_dispute');
1695: END IF;
1696: -- IF PG_DEBUG < 10 THEN
1697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1698: iex_debug_pub.logmessage('calc_dispute: ' || SQLCODE || ' ---> ' || SQLERRM);

Line 1698: iex_debug_pub.logmessage('calc_dispute: ' || SQLCODE || ' ---> ' || SQLERRM);

1694: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_dispute');
1695: END IF;
1696: -- IF PG_DEBUG < 10 THEN
1697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1698: iex_debug_pub.logmessage('calc_dispute: ' || SQLCODE || ' ---> ' || SQLERRM);
1699: END IF;
1700: if cust_dispute%ISOPEN then
1701: CLOSE cust_dispute ;
1702: End If ;

Line 1709: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1705: End If ;
1706:
1707: -- IF PG_DEBUG < 10 THEN
1708: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1709: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1710: END IF;
1711: -- IF PG_DEBUG < 10 THEN
1712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1713: IEX_DEBUG_PUB.LogMessage

Line 1713: IEX_DEBUG_PUB.LogMessage

1709: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1710: END IF;
1711: -- IF PG_DEBUG < 10 THEN
1712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1713: IEX_DEBUG_PUB.LogMessage
1714: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End with Exception <<--- ');
1715: END IF;
1716: -- IF PG_DEBUG < 10 THEN
1717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1718: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);

1714: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End with Exception <<--- ');
1715: END IF;
1716: -- IF PG_DEBUG < 10 THEN
1717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1718: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1719: END IF;
1720: END calc_dispute;
1721: --
1722: --

Line 1922: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

1918: BEGIN
1919:
1920: -- IF PG_DEBUG < 10 THEN
1921: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1922: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1923: END IF;
1924: -- IF PG_DEBUG < 10 THEN
1925: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1926: IEX_DEBUG_PUB.LogMessage

Line 1926: IEX_DEBUG_PUB.LogMessage

1922: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1923: END IF;
1924: -- IF PG_DEBUG < 10 THEN
1925: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1926: IEX_DEBUG_PUB.LogMessage
1927: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_PENDING_ADJ --->> Start <<--- ');
1928: END IF;
1929: -- IF PG_DEBUG < 10 THEN
1930: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1931: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

1927: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_PENDING_ADJ --->> Start <<--- ');
1928: END IF;
1929: -- IF PG_DEBUG < 10 THEN
1930: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1931: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1932: END IF;
1933:
1934: p_pending_adj := 0;
1935:

Line 1988: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

1984: End If ;
1985: --
1986: -- IF PG_DEBUG < 10 THEN
1987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1988: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1989: END IF;
1990: -- IF PG_DEBUG < 10 THEN
1991: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1992: IEX_DEBUG_PUB.LogMessage

Line 1992: IEX_DEBUG_PUB.LogMessage

1988: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1989: END IF;
1990: -- IF PG_DEBUG < 10 THEN
1991: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1992: IEX_DEBUG_PUB.LogMessage
1993: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End <<--- ');
1994: END IF;
1995: -- IF PG_DEBUG < 10 THEN
1996: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1997: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

1993: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End <<--- ');
1994: END IF;
1995: -- IF PG_DEBUG < 10 THEN
1996: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1997: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1998: END IF;
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN

Line 2004: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || 'EXCEPTION: Iex_Aging_Buckets_Pkg.calc_pending_adj');

2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: -- IF PG_DEBUG < 10 THEN
2003: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2004: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || 'EXCEPTION: Iex_Aging_Buckets_Pkg.calc_pending_adj');
2005: END IF;
2006: -- IF PG_DEBUG < 10 THEN
2007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2008: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || SQLCODE || ' ---> ' || SQLERRM);

Line 2008: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || SQLCODE || ' ---> ' || SQLERRM);

2004: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || 'EXCEPTION: Iex_Aging_Buckets_Pkg.calc_pending_adj');
2005: END IF;
2006: -- IF PG_DEBUG < 10 THEN
2007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2008: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || SQLCODE || ' ---> ' || SQLERRM);
2009: END IF;
2010:
2011: if cust_adj%ISOPEN then
2012: CLOSE cust_adj ;

Line 2029: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

2025:
2026:
2027: -- IF PG_DEBUG < 10 THEN
2028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2029: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2030: END IF;
2031: -- IF PG_DEBUG < 10 THEN
2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: IEX_DEBUG_PUB.LogMessage

Line 2033: IEX_DEBUG_PUB.LogMessage

2029: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2030: END IF;
2031: -- IF PG_DEBUG < 10 THEN
2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: IEX_DEBUG_PUB.LogMessage
2034: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End with Exception <<--- ');
2035: END IF;
2036: -- IF PG_DEBUG < 10 THEN
2037: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2038: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);

2034: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End with Exception <<--- ');
2035: END IF;
2036: -- IF PG_DEBUG < 10 THEN
2037: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2038: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2039: END IF;
2040:
2041: END calc_adj_fin_charges;
2042:

Line 2227: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

2223: l_cons_amount Number := 0 ;
2224: Begin
2225: -- IF PG_DEBUG < 10 THEN
2226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2227: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2228: END IF;
2229: -- IF PG_DEBUG < 10 THEN
2230: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2231: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');

Line 2231: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');

2227: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2228: END IF;
2229: -- IF PG_DEBUG < 10 THEN
2230: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2231: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');
2232: END IF;
2233: -- IF PG_DEBUG < 10 THEN
2234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2235: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

Line 2235: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

2231: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');
2232: END IF;
2233: -- IF PG_DEBUG < 10 THEN
2234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2235: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2236: END IF;
2237:
2238:
2239: SAVEPOINT Query_Aging_lines;

Line 2264: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Bucket Id >> ' || p_bucket_id );

2260:
2261:
2262: -- IF PG_DEBUG < 10 THEN
2263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2264: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Bucket Id >> ' || p_bucket_id );
2265: END IF;
2266:
2267: x_return_status := FND_API.G_RET_STS_SUCCESS;
2268:

Line 2281: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Functional Currency >> '|| v_currency ||

2277: X_MSG_DATA => v_msg_data );
2278:
2279: -- IF PG_DEBUG < 10 THEN
2280: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2281: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Functional Currency >> '|| v_currency ||
2282: ' Filter Mode ' || p_filter_mode);
2283: END IF;
2284:
2285:

Line 2291: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Filter Mode >> '||

2287: if p_filter_mode IN ('CUST', 'BILLTO') then
2288:
2289: -- IF PG_DEBUG < 10 THEN
2290: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2291: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Filter Mode >> '||
2292: p_filter_mode || ' Start');
2293: END IF;
2294:
2295: if p_filter_mode = 'BILLTO' then

Line 2303: iex_debug_pub.logmessage('Cust Account id for bill to >> '

2299: from ar_payment_schedules aps
2300: where aps.customer_site_use_id = p_filter_id ;
2301:
2302: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2303: iex_debug_pub.logmessage('Cust Account id for bill to >> '
2304: || v_billto_cust_account_id);
2305: END IF;
2306:
2307: Exception

Line 2310: iex_debug_pub.logmessage('ERROR >> No Customer Account

2306:
2307: Exception
2308: WHEN NO_DATA_FOUND THEN
2309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2310: iex_debug_pub.logmessage('ERROR >> No Customer Account
2311: for the Passed Bill to id >>' || p_filter_id);
2312: END IF;
2313: WHEN OTHERS then
2314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2315: iex_debug_pub.logmessage('ERROR >> When deriving customer

2311: for the Passed Bill to id >>' || p_filter_id);
2312: END IF;
2313: WHEN OTHERS then
2314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2315: iex_debug_pub.logmessage('ERROR >> When deriving customer
2316: account for the Passed Bill to id >>' || p_filter_id ||
2317: SQLCODE || SQLERRM);
2318: END IF;
2319: End ;

Line 2399: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Party Mode Fetch Iteration >> '

2395: INTO l_customer_id ;
2396: END IF;
2397: -- IF PG_DEBUG < 10 THEN
2398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2399: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Party Mode Fetch Iteration >> '
2400: || to_char(l_count) || ' Filter Id '||
2401: to_char(p_filter_id));
2402: END IF;
2403: l_count := l_count + 1 ;

Line 2413: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Mode Party >> Customer >> '

2409: END IF;
2410:
2411: -- IF PG_DEBUG < 10 THEN
2412: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2413: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Mode Party >> Customer >> '
2414: || l_customer_id );
2415: END IF;
2416:
2417: lt_outstanding_balance := 0 ;

Line 2421: IEX_DEBUG_PUB.LogMessage

2417: lt_outstanding_balance := 0 ;
2418: -- Call the Aging Procedure for each fetched customer_id
2419: -- IF PG_DEBUG < 10 THEN
2420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2421: IEX_DEBUG_PUB.LogMessage
2422: ('QUERY_AGING_LINES: ' || 'Before Calling calc aging buckets >> Parameters >>');
2423: END IF;
2424: -- IF PG_DEBUG < 10 THEN
2425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2426: IEX_DEBUG_PUB.LogMessage

2422: ('QUERY_AGING_LINES: ' || 'Before Calling calc aging buckets >> Parameters >>');
2423: END IF;
2424: -- IF PG_DEBUG < 10 THEN
2425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2426: IEX_DEBUG_PUB.LogMessage
2427: ('QUERY_AGING_LINES: ' || ' Bucket Id > '|| p_bucket_id
2428: || 'Customer Id > ' || to_char(l_customer_id));
2429: END IF;
2430:

Line 2486: IEX_DEBUG_PUB.LogMessage

2482: -- when loading the final output table.
2483:
2484: -- IF PG_DEBUG < 10 THEN
2485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2486: IEX_DEBUG_PUB.LogMessage
2487: ('QUERY_AGING_LINES: ' || 'Acct Balance >> '|| to_char(lt_outstanding_balance));
2488: END IF;
2489:
2490: l_outstanding_balance :=

Line 2495: IEX_DEBUG_PUB.LogMessage

2491: l_outstanding_balance + lt_outstanding_balance ;
2492:
2493: -- IF PG_DEBUG < 10 THEN
2494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2495: IEX_DEBUG_PUB.LogMessage
2496: ('QUERY_AGING_LINES: ' || 'Total Balance >> '|| to_char(l_outstanding_balance));
2497: END IF;
2498:
2499: -- Rolling Bucket 0

Line 2519: IEX_DEBUG_PUB.LogMessage

2515: End If ;
2516:
2517: -- IF PG_DEBUG < 10 THEN
2518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2519: IEX_DEBUG_PUB.LogMessage
2520: ('QUERY_AGING_LINES: ' || 'Bucket 0 >> '||lt_bucket_titletop_0 || ' '
2521: || lt_bucket_titlebottom_0);
2522: END IF;
2523:

Line 2542: IEX_DEBUG_PUB.LogMessage

2538: l_bucket_seq_num_1 := lt_bucket_seq_num_1 ;
2539: End If ;
2540: -- IF PG_DEBUG < 10 THEN
2541: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2542: IEX_DEBUG_PUB.LogMessage
2543: ('QUERY_AGING_LINES: ' || 'Bucket 1 >> '||lt_bucket_titletop_1 || ' '
2544: || lt_bucket_titlebottom_1);
2545: END IF;
2546:

Line 2584: IEX_DEBUG_PUB.LogMessage

2580: l_bucket_seq_num_3 := lt_bucket_seq_num_3 ;
2581: End If ;
2582: -- IF PG_DEBUG < 10 THEN
2583: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2584: IEX_DEBUG_PUB.LogMessage
2585: ('QUERY_AGING_LINES: ' || 'Bucket 3 >> '||lt_bucket_titletop_3 || ' '
2586: || lt_bucket_titlebottom_3);
2587: END IF;
2588:

Line 2656: IEX_DEBUG_PUB.LogMessage

2652: Exception
2653: WHEN OTHERS Then
2654: -- IF PG_DEBUG < 10 THEN
2655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2656: IEX_DEBUG_PUB.LogMessage
2657: ('QUERY_AGING_LINES: ' || 'When Others Party Mode >> '||SQLCODE
2658: || ' ==> ' ||SQLERRM);
2659: END IF;
2660: IF NVL(p_using_paying_rel, 'N') = 'Y' THEN

Line 2674: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading Buckets into Table of Records');

2670: End If ;
2671:
2672: -- IF PG_DEBUG < 10 THEN
2673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2674: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading Buckets into Table of Records');
2675: END IF;
2676:
2677: -- Load the Derived values into PL/SQL table
2678: /* ---------------------------------------------------------

Line 2694: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

2690: := l_bucket_seq_num_0 ;
2691:
2692: -- IF PG_DEBUG < 10 THEN
2693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2694: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2695: END IF;
2696: -- IF PG_DEBUG < 10 THEN
2697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2698: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 1 Bucket Name ' ||

Line 2698: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 1 Bucket Name ' ||

2694: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2695: END IF;
2696: -- IF PG_DEBUG < 10 THEN
2697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2698: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 1 Bucket Name ' ||
2699: x_bucket_lines_tbl(l_cnt).bucket_line ||
2700: ' Amount = ' || to_char(l_bucket_amount_0) ||
2701: '] Line Id = ['|| to_char(l_bucket_line_id_0) ||
2702: '] Seq Num = ['|| to_char(l_bucket_seq_num_0));

Line 2725: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 2 Bucket Name [' ||

2721: := l_bucket_seq_num_1 ;
2722:
2723: -- IF PG_DEBUG < 10 THEN
2724: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2725: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 2 Bucket Name [' ||
2726: x_bucket_lines_tbl(l_cnt).bucket_line ||
2727: '] Amount = [' || to_char(l_bucket_amount_1) ||
2728: '] Line Id = ['|| to_char(l_bucket_line_id_1) ||
2729: '] Seq Num = ['|| to_char(l_bucket_seq_num_1));

Line 2751: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 3 Bucket Name ' ||

2747: := l_bucket_seq_num_2 ;
2748:
2749: -- IF PG_DEBUG < 10 THEN
2750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2751: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 3 Bucket Name ' ||
2752: x_bucket_lines_tbl(l_cnt).bucket_line ||
2753: ' Amount = ' || to_char(l_bucket_amount_2) ||
2754: '] Line Id = ['|| to_char(l_bucket_line_id_2) ||
2755: '] Seq Num = ['|| to_char(l_bucket_seq_num_2));

Line 2777: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 4 Bucket Name ' ||

2773: := l_bucket_seq_num_3 ;
2774:
2775: -- IF PG_DEBUG < 10 THEN
2776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2777: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 4 Bucket Name ' ||
2778: x_bucket_lines_tbl(l_cnt).bucket_line ||
2779: ' Amount = ' || to_char(l_bucket_amount_3) ||
2780: '] Line Id = ['|| to_char(l_bucket_line_id_3) ||
2781: '] Seq Num = ['|| to_char(l_bucket_seq_num_3));

Line 2804: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 5 Bucket Name ' ||

2800: := l_bucket_seq_num_4 ;
2801:
2802: -- IF PG_DEBUG < 10 THEN
2803: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2804: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 5 Bucket Name ' ||
2805: x_bucket_lines_tbl(l_cnt).bucket_line ||
2806: ' Amount = ' || to_char(l_bucket_amount_4) ||
2807: '] Line Id = ['|| to_char(l_bucket_line_id_4) ||
2808: '] Seq Num = ['|| to_char(l_bucket_seq_num_4));

Line 2830: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 6 Bucket Name ' ||

2826: := l_bucket_seq_num_5 ;
2827:
2828: -- IF PG_DEBUG < 10 THEN
2829: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2830: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 6 Bucket Name ' ||
2831: x_bucket_lines_tbl(l_cnt).bucket_line ||
2832: ' Amount = ' || to_char(l_bucket_amount_5) ||
2833: '] Line Id = ['|| to_char(l_bucket_line_id_5) ||
2834: '] Seq Num = ['|| to_char(l_bucket_seq_num_5));

Line 2856: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 7 Bucket Name ' ||

2852: := l_bucket_seq_num_6 ;
2853:
2854: -- IF PG_DEBUG < 10 THEN
2855: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2856: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 7 Bucket Name ' ||
2857: x_bucket_lines_tbl(l_cnt).bucket_line ||
2858: ' Amount = ' || to_char(l_bucket_amount_6) ||
2859: '] Line Id = ['|| to_char(l_bucket_line_id_6) ||
2860: '] Seq Num = ['|| to_char(l_bucket_seq_num_6));

Line 2867: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

2863: -- End If ;
2864: End If ;
2865: -- IF PG_DEBUG < 10 THEN
2866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2867: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2868: END IF;
2869:
2870:
2871:

Line 2873: iex_debug_pub.logmessage('Filter Mode Before Collectible Amt ' || p_filter_mode || ' [ '||p_filter_id || ' ]') ;

2869:
2870:
2871:
2872: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2873: iex_debug_pub.logmessage('Filter Mode Before Collectible Amt ' || p_filter_mode || ' [ '||p_filter_id || ' ]') ;
2874: END IF;
2875:
2876: -- Derive Collectible Amounts
2877: if p_filter_mode = 'CUST' then

Line 3107: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading one time results ' );

3103: Loading all the one time results
3104: ---------------------------------------------------------*/
3105: -- IF PG_DEBUG < 10 THEN
3106: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3107: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading one time results ' );
3108: END IF;
3109: FOR cnt in 1..x_bucket_lines_tbl.COUNT
3110: LOOP
3111: x_bucket_lines_tbl(cnt).outstanding_balance

Line 3131: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row >> ' || to_char(cnt) || ' Bal [' ||

3127:
3128:
3129: -- IF PG_DEBUG < 10 THEN
3130: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3131: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row >> ' || to_char(cnt) || ' Bal [' ||
3132: to_char(x_bucket_lines_tbl(cnt).outstanding_balance) ||
3133: 'Currency [' || x_bucket_lines_tbl(cnt).currency);
3134: END IF;
3135:

Line 3158: IEX_DEBUG_PUB.LogMessage('After Call CONS : ' || x_bucket_lines_tbl(cnt).consolidated_invoices) ;

3154: x_count => x_bucket_lines_tbl(cnt).consolidated_invoices,
3155: x_amount => l_cons_amount) ;
3156:
3157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3158: IEX_DEBUG_PUB.LogMessage('After Call CONS : ' || x_bucket_lines_tbl(cnt).consolidated_invoices) ;
3159: END IF;
3160:
3161: l_total_cnsld_invoices := l_total_cnsld_invoices +
3162: x_bucket_lines_tbl(cnt).consolidated_invoices ;

Line 3271: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');

3267: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3268:
3269: -- IF PG_DEBUG < 10 THEN
3270: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3271: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3272: END IF;
3273: -- IF PG_DEBUG < 10 THEN
3274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3275: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');

Line 3275: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');

3271: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3272: END IF;
3273: -- IF PG_DEBUG < 10 THEN
3274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3275: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');
3276: END IF;
3277: -- IF PG_DEBUG < 10 THEN
3278: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3279: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');

Line 3279: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');

3275: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');
3276: END IF;
3277: -- IF PG_DEBUG < 10 THEN
3278: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3279: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3280: END IF;
3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN

Line 3339: IEX_DEBUG_PUB.LogMessage(l_line) ;

3335: x_class_count := 0; -- added by ehuh for bill-to
3336: x_class_amount := 0; -- added by ehuh for bill-to
3337:
3338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3339: IEX_DEBUG_PUB.LogMessage(l_line) ;
3340: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3341: IEX_DEBUG_PUB.LogMessage(l_line) ;
3342: END IF;
3343:

Line 3340: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;

3336: x_class_amount := 0; -- added by ehuh for bill-to
3337:
3338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3339: IEX_DEBUG_PUB.LogMessage(l_line) ;
3340: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3341: IEX_DEBUG_PUB.LogMessage(l_line) ;
3342: END IF;
3343:
3344:

Line 3341: IEX_DEBUG_PUB.LogMessage(l_line) ;

3337:
3338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3339: IEX_DEBUG_PUB.LogMessage(l_line) ;
3340: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3341: IEX_DEBUG_PUB.LogMessage(l_line) ;
3342: END IF;
3343:
3344:
3345: --- Begin - Andre Araujo - 11/09/2004 - Performance fix we will select the aging separately

Line 3461: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;

3457: v_sql := v_tran_sql ;
3458: End If ;
3459:
3460: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3461: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;
3462: END IF;
3463:
3464: Begin
3465:

Line 3490: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;

3486: WHEN NO_DATA_FOUND THEN
3487: x_class_count := 0; x_class_amount := 0;
3488: WHEN OTHERS THEN
3489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3490: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;
3491: END IF;
3492: End ;
3493:
3494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3495: IEX_DEBUG_PUB.LogMessage(l_line) ;

3491: END IF;
3492: End ;
3493:
3494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3495: IEX_DEBUG_PUB.LogMessage(l_line) ;
3496: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3497: IEX_DEBUG_PUB.LogMessage(l_line) ;
3498: END IF;
3499:

Line 3496: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;

3492: End ;
3493:
3494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3495: IEX_DEBUG_PUB.LogMessage(l_line) ;
3496: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3497: IEX_DEBUG_PUB.LogMessage(l_line) ;
3498: END IF;
3499:
3500: END ;

Line 3497: IEX_DEBUG_PUB.LogMessage(l_line) ;

3493:
3494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3495: IEX_DEBUG_PUB.LogMessage(l_line) ;
3496: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3497: IEX_DEBUG_PUB.LogMessage(l_line) ;
3498: END IF;
3499:
3500: END ;
3501:

Line 3544: IEX_DEBUG_PUB.LogMessage(l_line) ;

3540: b_class := 'INV' ;
3541: b_status := 'OP' ;
3542:
3543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3544: IEX_DEBUG_PUB.LogMessage(l_line) ;
3545: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3546: IEX_DEBUG_PUB.LogMessage(l_line) ;
3547: IEX_DEBUG_PUB.LogMessage('Hello') ;
3548: END IF;

Line 3545: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;

3541: b_status := 'OP' ;
3542:
3543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3544: IEX_DEBUG_PUB.LogMessage(l_line) ;
3545: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3546: IEX_DEBUG_PUB.LogMessage(l_line) ;
3547: IEX_DEBUG_PUB.LogMessage('Hello') ;
3548: END IF;
3549:

Line 3546: IEX_DEBUG_PUB.LogMessage(l_line) ;

3542:
3543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3544: IEX_DEBUG_PUB.LogMessage(l_line) ;
3545: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3546: IEX_DEBUG_PUB.LogMessage(l_line) ;
3547: IEX_DEBUG_PUB.LogMessage('Hello') ;
3548: END IF;
3549:
3550: v_cust_cnsld_sql :=

Line 3547: IEX_DEBUG_PUB.LogMessage('Hello') ;

3543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3544: IEX_DEBUG_PUB.LogMessage(l_line) ;
3545: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3546: IEX_DEBUG_PUB.LogMessage(l_line) ;
3547: IEX_DEBUG_PUB.LogMessage('Hello') ;
3548: END IF;
3549:
3550: v_cust_cnsld_sql :=
3551: 'SELECT count(distinct ocahb.id)

Line 3631: IEX_DEBUG_PUB.LogMessage('') ;

3627:
3628: END IF;
3629:
3630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3631: IEX_DEBUG_PUB.LogMessage('') ;
3632: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;
3633: END IF;
3634:
3635:

Line 3632: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;

3628: END IF;
3629:
3630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3631: IEX_DEBUG_PUB.LogMessage('') ;
3632: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;
3633: END IF;
3634:
3635:
3636:

Line 3670: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;

3666: v_sql := v_party_billto_cnsld_sql ;
3667: End If ;
3668:
3669: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3670: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;
3671: END IF;
3672:
3673: Begin
3674:

Line 3705: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;

3701: WHEN NO_DATA_FOUND THEN
3702: x_count := 0; x_amount := 0;
3703: WHEN OTHERS THEN
3704: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3705: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;
3706: END IF;
3707: End ;
3708:
3709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3710: IEX_DEBUG_PUB.LogMessage(l_line) ;

3706: END IF;
3707: End ;
3708:
3709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3710: IEX_DEBUG_PUB.LogMessage(l_line) ;
3711: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3712: IEX_DEBUG_PUB.LogMessage(l_line) ;
3713: END IF;
3714: EXCEPTION

Line 3711: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;

3707: End ;
3708:
3709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3710: IEX_DEBUG_PUB.LogMessage(l_line) ;
3711: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3712: IEX_DEBUG_PUB.LogMessage(l_line) ;
3713: END IF;
3714: EXCEPTION
3715: WHEN OTHERS then

Line 3712: IEX_DEBUG_PUB.LogMessage(l_line) ;

3708:
3709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3710: IEX_DEBUG_PUB.LogMessage(l_line) ;
3711: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3712: IEX_DEBUG_PUB.LogMessage(l_line) ;
3713: END IF;
3714: EXCEPTION
3715: WHEN OTHERS then
3716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3717: IEX_DEBUG_PUB.LogMessage(' GET_CNSLD_INVOICE_COUNT - MAIN ' ||

3713: END IF;
3714: EXCEPTION
3715: WHEN OTHERS then
3716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3717: IEX_DEBUG_PUB.LogMessage(' GET_CNSLD_INVOICE_COUNT - MAIN ' ||
3718: SQLCODE || ' ' || SQLERRM) ;
3719: END IF;
3720:
3721: END GET_CNSLD_INVOICE_COUNT ;