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 FND_LOG

Line 495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

491: --
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

Line 499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
501: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> Start <<--- ');
502: END IF;
503: -- IF PG_DEBUG < 10 THEN

Line 504: 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
505: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
506: END IF;
507:
508: OPEN c_sel_bucket_data;

Line 518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

514: v_bucket_line_type_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:

Line 538: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

534: 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:

Line 561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

557: v_bucket_line_type_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:

Line 584: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

580: v_bucket_line_type_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:

Line 607: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

603: v_bucket_line_type_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:

Line 630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

626: v_bucket_line_type_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:

Line 653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

649: v_bucket_line_type_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:

Line 720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

716: END LOOP;
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

Line 724: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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)
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));

Line 731: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

727: p_bucket_titletop_0 || ' ' || p_bucket_titlebottom_0 || '] Amt [' ||
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

Line 736: 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
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));

Line 745: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

741: END IF;
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

Line 749: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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)
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));

Line 756: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

752: p_bucket_titletop_2 || ' ' || p_bucket_titlebottom_2 || '] Amt [' ||
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

Line 761: 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
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));

Line 768: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

764: p_bucket_titletop_3 || ' ' || p_bucket_titlebottom_3 || '] Amt [' ||
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

Line 773: 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
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));

Line 780: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

776: p_bucket_titletop_4 || ' ' || p_bucket_titlebottom_4 || '] Amt [' ||
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

Line 785: 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
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));

Line 792: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

788: p_bucket_titletop_5 || ' ' || p_bucket_titlebottom_5 || '] Amt [' ||
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

Line 797: 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
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));

Line 804: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

800: p_bucket_titletop_6 || ' ' || p_bucket_titlebottom_6 || '] Amt [' ||
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:

Line 810: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

806: END IF;
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

Line 814: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
816: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> End <<--- ');
817: END IF;
818: -- IF PG_DEBUG < 10 THEN

Line 819: 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
820: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
821: END IF;
822:
823: --

Line 827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

823: --
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: --

Line 944: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

940:
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

Line 948: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
950: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> Start <<--- ');
951: END IF;
952: -- IF PG_DEBUG < 10 THEN

Line 953: 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
954: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
955: END IF;
956:
957: p_credits := 0;

Line 980: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

976: Close cust_site_credits ;
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

Line 984: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
986: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End <<--- ');
987: END IF;
988: -- IF PG_DEBUG < 10 THEN

Line 989: 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
990: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
991: END IF;
992:
993: EXCEPTION

Line 996: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

992:
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

Line 1000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
1002: END IF;
1003: if cust_credits%ISOPEN then
1004: CLOSE cust_credits ;

Line 1011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1007: CLOSE party_credits ;
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

Line 1015: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1017: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End with Exception <<--- ');
1018: END IF;
1019: -- IF PG_DEBUG < 10 THEN

Line 1020: 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
1021: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1022: END IF;
1023:
1024: END calc_credits;

Line 1271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1267:
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

Line 1276: 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
1277: iex_debug_pub.logmessage('calc_receipts: ' || SQLCODE || ' ---> ' || SQLERRM);
1278: END IF;
1279: if cust_unapplied_cash%ISOPEN then
1280: CLOSE cust_unapplied_cash ;

Line 1287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1283: CLOSE party_unapplied_cash ;
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

Line 1291: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1293: ('IEX_AGING_BUCKETS_PKG.CALC_RECEIPTS --->> End with Exception <<---');
1294: END IF;
1295: -- IF PG_DEBUG < 10 THEN

Line 1296: 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
1297: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1298: END IF;
1299: END calc_receipts;
1300: --

Line 1453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1449:
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

Line 1457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1459: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> Start <<--- ');
1460: END IF;
1461: -- IF PG_DEBUG < 10 THEN

Line 1462: 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
1463: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1464: END IF;
1465:
1466: p_risk_receipts := 0;

Line 1489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1485: Close cust_site_risk_receipts ;
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

Line 1493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1495: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End <<--- ');
1496: END IF;
1497: -- IF PG_DEBUG < 10 THEN

Line 1498: 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
1499: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1500: END IF;
1501:
1502: EXCEPTION

Line 1505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1501:
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

Line 1509: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
1511: END IF;
1512: if cust_risk_receipts%ISOPEN then
1513: CLOSE cust_risk_receipts ;

Line 1520: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1516: CLOSE party_risk_receipts ;
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

Line 1524: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1526: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End with Exception <<--- ');
1527: END IF;
1528: -- IF PG_DEBUG < 10 THEN

Line 1529: 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
1530: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1531: END IF;
1532:
1533: END calc_risk_receipts;

Line 1641: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1637:
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

Line 1645: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1647: ('IEX_AGING_BUCKETS_PKG.CALC_DISPUTE --->> Start <<--- ');
1648: END IF;
1649: -- IF PG_DEBUG < 10 THEN

Line 1650: 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
1651: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1652: END IF;
1653:
1654: p_dispute := 0;

Line 1677: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1673: Close cust_site_dispute ;
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

Line 1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1683: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End <<--- ');
1684: END IF;
1685: -- IF PG_DEBUG < 10 THEN

Line 1686: 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
1687: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1688: END IF;
1689:
1690: EXCEPTION

Line 1693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1689:
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

Line 1697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
1699: END IF;
1700: if cust_dispute%ISOPEN then
1701: CLOSE cust_dispute ;

Line 1708: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1704: CLOSE party_dispute ;
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

Line 1712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1714: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End with Exception <<--- ');
1715: END IF;
1716: -- IF PG_DEBUG < 10 THEN

Line 1717: 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
1718: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1719: END IF;
1720: END calc_dispute;
1721: --

Line 1921: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1917:
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

Line 1925: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1927: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_PENDING_ADJ --->> Start <<--- ');
1928: END IF;
1929: -- IF PG_DEBUG < 10 THEN

Line 1930: 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
1931: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1932: END IF;
1933:
1934: p_pending_adj := 0;

Line 1987: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1983:
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

Line 1991: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
1993: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End <<--- ');
1994: END IF;
1995: -- IF PG_DEBUG < 10 THEN

Line 1996: 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
1997: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1998: END IF;
1999:
2000: EXCEPTION

Line 2003: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1999:
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

Line 2007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
2009: END IF;
2010:
2011: if cust_adj%ISOPEN then

Line 2028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2024:
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

Line 2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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
2034: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End with Exception <<--- ');
2035: END IF;
2036: -- IF PG_DEBUG < 10 THEN

Line 2037: 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
2038: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2039: END IF;
2040:
2041: END calc_adj_fin_charges;

Line 2226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2222: -- derived at this time. Will be implemented later, if required
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

Line 2230: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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 <<--- ');
2232: END IF;
2233: -- IF PG_DEBUG < 10 THEN
2234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
2236: END IF;
2237:
2238:

Line 2263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2259: from dual ;
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;

Line 2280: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2276: X_MSG_COUNT => v_msg_count,
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:

Line 2290: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2286:
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:

Line 2302: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2298: into v_billto_cust_account_id
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:

Line 2309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2305: END IF;
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

Line 2314: 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
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;

Line 2398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2394: FETCH AR_AGING_PARTY_CUR
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;

Line 2412: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2408: EXIT WHEN AR_AGING_PARTY_CUR%NOTFOUND ;
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:

Line 2420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2416:
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

Line 2425: 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
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;

Line 2485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2481: -- act as common output for both party and cust modes
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:

Line 2494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2490: l_outstanding_balance :=
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:

Line 2518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2514: l_bucket_seq_num_0 := lt_bucket_seq_num_0 ;
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;

Line 2541: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2537: if (l_bucket_seq_num_1) is NULL then
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;

Line 2583: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2579: if (l_bucket_seq_num_3) is NULL then
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;

Line 2655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2651: END IF;
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;

Line 2673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2669: End ;
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

Line 2693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2689: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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

Line 2697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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 ' ||
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) ||

Line 2724: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2720: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2746: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2772: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2803: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2799: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2829: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2825: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2855: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2851: x_bucket_lines_tbl(l_cnt).bucket_seq_num
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) ||

Line 2866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2862: l_cnt := l_cnt + 1 ;
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:

Line 2872: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

2868: END IF;
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

Line 3106: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3102: /*---------------------------------------------------------
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

Line 3130: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3126: End If ;
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;

Line 3157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3153: p_using_paying_rel => p_using_paying_rel,
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 +

Line 3270: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3266: -- Standard call to get message count and if count is 1, get message info
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

Line 3274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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 <<--- ');
3276: END IF;
3277: -- IF PG_DEBUG < 10 THEN
3278: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3278: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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: ' || '-----------------------------------------');
3280: END IF;
3281:
3282: EXCEPTION

Line 3338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3334:
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;

Line 3460: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3456: else
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

Line 3489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3485: Exception
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:

Line 3494: 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
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;

Line 3543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3539:
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') ;

Line 3630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3626: AND hzca.party_id = :party_id ' ;
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:

Line 3669: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3665: else
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

Line 3704: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

3700: Exception
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:

Line 3709: 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
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;

Line 3716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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
3717: IEX_DEBUG_PUB.LogMessage(' GET_CNSLD_INVOICE_COUNT - MAIN ' ||
3718: SQLCODE || ' ' || SQLERRM) ;
3719: END IF;
3720:

Line 3725: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3721: END GET_CNSLD_INVOICE_COUNT ;
3722:
3723: BEGIN
3724: l_line := '-----------------------------------------' ;
3725: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3726: END iex_aging_buckets_pkg ;
3727: --
3728: --
3729: --