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 501: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);

497: -- Get the aging buckets definition.
498: --
499: -- IF PG_DEBUG < 10 THEN
500: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
501: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
502: END IF;
503: -- IF PG_DEBUG < 10 THEN
504: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
505: IEX_DEBUG_PUB.LogMessage

Line 505: IEX_DEBUG_PUB.LogMessage

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

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

506: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> Start <<--- ');
507: END IF;
508: -- IF PG_DEBUG < 10 THEN
509: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
510: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
511: END IF;
512:
513: OPEN c_sel_bucket_data;
514: FETCH c_sel_bucket_data

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

520: p_bucket_line_id_0,
521: p_bucket_seq_num_0 ;
522: -- IF PG_DEBUG < 10 THEN
523: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
524: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 0 [' || to_char(p_bucket_line_id_0)
525: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_0));
526: END IF;
527:
528:

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

540: p_bucket_seq_num_1 ;
541:
542: -- IF PG_DEBUG < 10 THEN
543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
544: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 1 [' || to_char(p_bucket_line_id_1)
545: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_1));
546: END IF;
547:
548: ELSE

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

563: p_bucket_line_id_2,
564: p_bucket_seq_num_2 ;
565: -- IF PG_DEBUG < 10 THEN
566: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
567: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 2 [' || to_char(p_bucket_line_id_2)
568: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_2));
569: END IF;
570:
571: ELSE

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

586: p_bucket_line_id_3,
587: p_bucket_seq_num_3 ;
588: -- IF PG_DEBUG < 10 THEN
589: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
590: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 3 [' || to_char(p_bucket_line_id_3)
591: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_3));
592: END IF;
593:
594: ELSE

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

609: p_bucket_line_id_4,
610: p_bucket_seq_num_4 ;
611: -- IF PG_DEBUG < 10 THEN
612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
613: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 4 [' || to_char(p_bucket_line_id_4)
614: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_4));
615: END IF;
616:
617: ELSE

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

632: p_bucket_line_id_5,
633: p_bucket_seq_num_5 ;
634: -- IF PG_DEBUG < 10 THEN
635: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
636: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 5 [' || to_char(p_bucket_line_id_5)
637: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_5));
638: END IF;
639:
640: ELSE

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

655: p_bucket_line_id_6,
656: p_bucket_seq_num_6 ;
657: -- IF PG_DEBUG < 10 THEN
658: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
659: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' Bucket Line Id 6 [' || to_char(p_bucket_line_id_6)
660: || '] Bucket Seq Num [' || to_char(p_bucket_seq_num_6));
661: END IF;
662:
663: ELSE

Line 684: IEX_DEBUG_PUB.LogMessage('current_org_id-->'||l_org_id);--Added for Bug 9902108 03-Aug-2010 barathsr

680: CLOSE c_sel_bucket_data;
681:
682:
683: l_org_id:=mo_global.get_current_org_id;--Added for Bug 9902108 03-Aug-2010 barathsr
684: IEX_DEBUG_PUB.LogMessage('current_org_id-->'||l_org_id);--Added for Bug 9902108 03-Aug-2010 barathsr
685:
686: --
687: -- get the aging bucket balance. The v_bucket_ is either 1 or 0.
688: --

Line 696: IEX_DEBUG_PUB.LogMessage('v_amt_dure_remain-->'||v_amount_due_remaining||' '||'bucket 0-->'||v_bucket_0||' '||'bucket 1-->'||v_bucket_1);

692: FETCH c_buckets INTO v_amount_due_remaining,
693: v_bucket_0, v_bucket_1, v_bucket_2,
694: v_bucket_3, v_bucket_4, v_bucket_5, v_bucket_6;
695: EXIT WHEN c_buckets%NOTFOUND;
696: IEX_DEBUG_PUB.LogMessage('v_amt_dure_remain-->'||v_amount_due_remaining||' '||'bucket 0-->'||v_bucket_0||' '||'bucket 1-->'||v_bucket_1);
697: IEX_DEBUG_PUB.LogMessage('bucket 2-->'||v_bucket_2||' '||'bucket 3-->'||v_bucket_3||' '||'bucket 4-->'||v_bucket_4||' '||'bucket 5-->'||v_bucket_5||' '||'bucket 6-->'||v_bucket_6);
698: p_outstanding_balance := p_outstanding_balance + v_amount_due_remaining;
699: IEX_DEBUG_PUB.LogMessage('p_out_bal-->'||p_outstanding_balance);
700: IF p_bucket_amount_0 IS NOT NULL THEN

Line 697: IEX_DEBUG_PUB.LogMessage('bucket 2-->'||v_bucket_2||' '||'bucket 3-->'||v_bucket_3||' '||'bucket 4-->'||v_bucket_4||' '||'bucket 5-->'||v_bucket_5||' '||'bucket 6-->'||v_bucket_6);

693: v_bucket_0, v_bucket_1, v_bucket_2,
694: v_bucket_3, v_bucket_4, v_bucket_5, v_bucket_6;
695: EXIT WHEN c_buckets%NOTFOUND;
696: IEX_DEBUG_PUB.LogMessage('v_amt_dure_remain-->'||v_amount_due_remaining||' '||'bucket 0-->'||v_bucket_0||' '||'bucket 1-->'||v_bucket_1);
697: IEX_DEBUG_PUB.LogMessage('bucket 2-->'||v_bucket_2||' '||'bucket 3-->'||v_bucket_3||' '||'bucket 4-->'||v_bucket_4||' '||'bucket 5-->'||v_bucket_5||' '||'bucket 6-->'||v_bucket_6);
698: p_outstanding_balance := p_outstanding_balance + v_amount_due_remaining;
699: IEX_DEBUG_PUB.LogMessage('p_out_bal-->'||p_outstanding_balance);
700: IF p_bucket_amount_0 IS NOT NULL THEN
701: p_bucket_amount_0 := p_bucket_amount_0 +

Line 699: IEX_DEBUG_PUB.LogMessage('p_out_bal-->'||p_outstanding_balance);

695: EXIT WHEN c_buckets%NOTFOUND;
696: IEX_DEBUG_PUB.LogMessage('v_amt_dure_remain-->'||v_amount_due_remaining||' '||'bucket 0-->'||v_bucket_0||' '||'bucket 1-->'||v_bucket_1);
697: IEX_DEBUG_PUB.LogMessage('bucket 2-->'||v_bucket_2||' '||'bucket 3-->'||v_bucket_3||' '||'bucket 4-->'||v_bucket_4||' '||'bucket 5-->'||v_bucket_5||' '||'bucket 6-->'||v_bucket_6);
698: p_outstanding_balance := p_outstanding_balance + v_amount_due_remaining;
699: IEX_DEBUG_PUB.LogMessage('p_out_bal-->'||p_outstanding_balance);
700: IF p_bucket_amount_0 IS NOT NULL THEN
701: p_bucket_amount_0 := p_bucket_amount_0 +
702: (v_bucket_0 * v_amount_due_remaining);
703: IEX_DEBUG_PUB.LogMessage('bucket_0_amt-->'||p_bucket_amount_0);

Line 703: IEX_DEBUG_PUB.LogMessage('bucket_0_amt-->'||p_bucket_amount_0);

699: IEX_DEBUG_PUB.LogMessage('p_out_bal-->'||p_outstanding_balance);
700: IF p_bucket_amount_0 IS NOT NULL THEN
701: p_bucket_amount_0 := p_bucket_amount_0 +
702: (v_bucket_0 * v_amount_due_remaining);
703: IEX_DEBUG_PUB.LogMessage('bucket_0_amt-->'||p_bucket_amount_0);
704:
705: END IF;
706: IF p_bucket_amount_1 IS NOT NULL THEN
707: p_bucket_amount_1 := p_bucket_amount_1 +

Line 709: IEX_DEBUG_PUB.LogMessage('bucket_1_amt-->'||p_bucket_amount_1);

705: END IF;
706: IF p_bucket_amount_1 IS NOT NULL THEN
707: p_bucket_amount_1 := p_bucket_amount_1 +
708: (v_bucket_1 * v_amount_due_remaining);
709: IEX_DEBUG_PUB.LogMessage('bucket_1_amt-->'||p_bucket_amount_1);
710: END IF;
711: IF p_bucket_amount_2 IS NOT NULL THEN
712: p_bucket_amount_2 := p_bucket_amount_2 +
713: (v_bucket_2 * v_amount_due_remaining);

Line 714: IEX_DEBUG_PUB.LogMessage('bucket_2_amt-->'||p_bucket_amount_2);

710: END IF;
711: IF p_bucket_amount_2 IS NOT NULL THEN
712: p_bucket_amount_2 := p_bucket_amount_2 +
713: (v_bucket_2 * v_amount_due_remaining);
714: IEX_DEBUG_PUB.LogMessage('bucket_2_amt-->'||p_bucket_amount_2);
715: END IF;
716: IF p_bucket_amount_3 IS NOT NULL THEN
717: p_bucket_amount_3 := p_bucket_amount_3 +
718: (v_bucket_3 * v_amount_due_remaining);

Line 719: IEX_DEBUG_PUB.LogMessage('bucket_3_amt-->'||p_bucket_amount_3);

715: END IF;
716: IF p_bucket_amount_3 IS NOT NULL THEN
717: p_bucket_amount_3 := p_bucket_amount_3 +
718: (v_bucket_3 * v_amount_due_remaining);
719: IEX_DEBUG_PUB.LogMessage('bucket_3_amt-->'||p_bucket_amount_3);
720: END IF;
721: IF p_bucket_amount_4 IS NOT NULL THEN
722: p_bucket_amount_4 := p_bucket_amount_4 +
723: (v_bucket_4 * v_amount_due_remaining);

Line 724: IEX_DEBUG_PUB.LogMessage('bucket_4_amt-->'||p_bucket_amount_4);

720: END IF;
721: IF p_bucket_amount_4 IS NOT NULL THEN
722: p_bucket_amount_4 := p_bucket_amount_4 +
723: (v_bucket_4 * v_amount_due_remaining);
724: IEX_DEBUG_PUB.LogMessage('bucket_4_amt-->'||p_bucket_amount_4);
725: END IF;
726: IF p_bucket_amount_5 IS NOT NULL THEN
727: p_bucket_amount_5 := p_bucket_amount_5 +
728: (v_bucket_5 * v_amount_due_remaining);

Line 729: IEX_DEBUG_PUB.LogMessage('bucket_5_amt-->'||p_bucket_amount_5);

725: END IF;
726: IF p_bucket_amount_5 IS NOT NULL THEN
727: p_bucket_amount_5 := p_bucket_amount_5 +
728: (v_bucket_5 * v_amount_due_remaining);
729: IEX_DEBUG_PUB.LogMessage('bucket_5_amt-->'||p_bucket_amount_5);
730: END IF;
731: IF p_bucket_amount_6 IS NOT NULL THEN
732: p_bucket_amount_6 := p_bucket_amount_6 +
733: (v_bucket_6 * v_amount_due_remaining);

Line 734: IEX_DEBUG_PUB.LogMessage('bucket_6_amt-->'||p_bucket_amount_6);

730: END IF;
731: IF p_bucket_amount_6 IS NOT NULL THEN
732: p_bucket_amount_6 := p_bucket_amount_6 +
733: (v_bucket_6 * v_amount_due_remaining);
734: IEX_DEBUG_PUB.LogMessage('bucket_6_amt-->'||p_bucket_amount_6);
735: END IF;
736: END LOOP;
737: CLOSE c_buckets;
738:

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

737: CLOSE c_buckets;
738:
739: -- IF PG_DEBUG < 10 THEN
740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
742: END IF;
743: -- IF PG_DEBUG < 10 THEN
744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
745: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 0 - id [' || to_char(p_bucket_line_id_0)

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

741: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
742: END IF;
743: -- IF PG_DEBUG < 10 THEN
744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
745: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 0 - id [' || to_char(p_bucket_line_id_0)
746: || '] Seq [' || to_char(p_bucket_seq_num_0) || ' Desc [' ||
747: p_bucket_titletop_0 || ' ' || p_bucket_titlebottom_0 || '] Amt [' ||
748: to_char(p_bucket_amount_0));
749: END IF;

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

748: to_char(p_bucket_amount_0));
749: END IF;
750: -- IF PG_DEBUG < 10 THEN
751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
752: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
753: END IF;
754:
755: -- IF PG_DEBUG < 10 THEN
756: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

753: END IF;
754:
755: -- IF PG_DEBUG < 10 THEN
756: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
757: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 1 - id [' || to_char(p_bucket_line_id_1)
758: || '] Seq [' || to_char(p_bucket_seq_num_1) || ' Desc [' ||
759: p_bucket_titletop_1 || ' ' || p_bucket_titlebottom_1 || '] Amt [' ||
760: to_char(p_bucket_amount_1));
761: END IF;

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

762:
763:
764: -- IF PG_DEBUG < 10 THEN
765: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
766: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
767: END IF;
768: -- IF PG_DEBUG < 10 THEN
769: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
770: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 2 - id [' || to_char(p_bucket_line_id_2)

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

766: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
767: END IF;
768: -- IF PG_DEBUG < 10 THEN
769: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
770: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 2 - id [' || to_char(p_bucket_line_id_2)
771: || '] Seq [' || to_char(p_bucket_seq_num_2) || ' Desc [' ||
772: p_bucket_titletop_2 || ' ' || p_bucket_titlebottom_2 || '] Amt [' ||
773: to_char(p_bucket_amount_2));
774: END IF;

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

773: to_char(p_bucket_amount_2));
774: END IF;
775: -- IF PG_DEBUG < 10 THEN
776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
777: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
778: END IF;
779:
780: -- IF PG_DEBUG < 10 THEN
781: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

778: END IF;
779:
780: -- IF PG_DEBUG < 10 THEN
781: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
782: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 3 - id [' || to_char(p_bucket_line_id_3)
783: || '] Seq [' || to_char(p_bucket_seq_num_3) || ' Desc [' ||
784: p_bucket_titletop_3 || ' ' || p_bucket_titlebottom_3 || '] Amt [' ||
785: to_char(p_bucket_amount_3));
786: END IF;

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

785: to_char(p_bucket_amount_3));
786: END IF;
787: -- IF PG_DEBUG < 10 THEN
788: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
789: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
790: END IF;
791:
792: -- IF PG_DEBUG < 10 THEN
793: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

790: END IF;
791:
792: -- IF PG_DEBUG < 10 THEN
793: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
794: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 4 - id [' || to_char(p_bucket_line_id_4)
795: || '] Seq [' || to_char(p_bucket_seq_num_4) || ' Desc [' ||
796: p_bucket_titletop_4 || ' ' || p_bucket_titlebottom_4 || '] Amt [' ||
797: to_char(p_bucket_amount_4));
798: END IF;

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

797: to_char(p_bucket_amount_4));
798: END IF;
799: -- IF PG_DEBUG < 10 THEN
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
802: END IF;
803:
804: -- IF PG_DEBUG < 10 THEN
805: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

802: END IF;
803:
804: -- IF PG_DEBUG < 10 THEN
805: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
806: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 5 - id [' || to_char(p_bucket_line_id_5)
807: || '] Seq [' || to_char(p_bucket_seq_num_5) || ' Desc [' ||
808: p_bucket_titletop_5 || ' ' || p_bucket_titlebottom_5 || '] Amt [' ||
809: to_char(p_bucket_amount_5));
810: END IF;

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

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

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

814: END IF;
815:
816: -- IF PG_DEBUG < 10 THEN
817: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
818: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || ' 6 - id [' || to_char(p_bucket_line_id_6)
819: || '] Seq [' || to_char(p_bucket_seq_num_6) || ' Desc [' ||
820: p_bucket_titletop_6 || ' ' || p_bucket_titlebottom_6 || '] Amt [' ||
821: to_char(p_bucket_amount_6));
822: END IF;

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

821: to_char(p_bucket_amount_6));
822: END IF;
823: -- IF PG_DEBUG < 10 THEN
824: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
825: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
826: END IF;
827:
828:
829: -- IF PG_DEBUG < 10 THEN

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

827:
828:
829: -- IF PG_DEBUG < 10 THEN
830: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
831: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
832: END IF;
833: -- IF PG_DEBUG < 10 THEN
834: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
835: IEX_DEBUG_PUB.LogMessage

Line 835: IEX_DEBUG_PUB.LogMessage

831: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
832: END IF;
833: -- IF PG_DEBUG < 10 THEN
834: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
835: IEX_DEBUG_PUB.LogMessage
836: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> End <<--- ');
837: END IF;
838: -- IF PG_DEBUG < 10 THEN
839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

836: ('IEX_AGING_BUCKETS_PKG. CALC_AGING_BUCKETS --->> End <<--- ');
837: END IF;
838: -- IF PG_DEBUG < 10 THEN
839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
840: IEX_DEBUG_PUB.LogMessage('calc_aging_buckets: ' || v_line);
841: END IF;
842:
843: --
844: EXCEPTION

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

844: EXCEPTION
845: WHEN OTHERS THEN
846: -- IF PG_DEBUG < 10 THEN
847: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
848: iex_debug_pub.logmessage('EXCEPTION: IEX_PROFILE_AGING_PKG.calc_aging_buckets');
849: END IF;
850: END calc_aging_buckets;
851: --
852: --

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

961:
962: BEGIN
963: -- IF PG_DEBUG < 10 THEN
964: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
965: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
966: END IF;
967: -- IF PG_DEBUG < 10 THEN
968: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
969: IEX_DEBUG_PUB.LogMessage

Line 969: IEX_DEBUG_PUB.LogMessage

965: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
966: END IF;
967: -- IF PG_DEBUG < 10 THEN
968: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
969: IEX_DEBUG_PUB.LogMessage
970: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> Start <<--- ');
971: END IF;
972: -- IF PG_DEBUG < 10 THEN
973: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

970: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> Start <<--- ');
971: END IF;
972: -- IF PG_DEBUG < 10 THEN
973: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
974: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
975: END IF;
976:
977: p_credits := 0;
978:

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

997: End If ;
998: --
999: -- IF PG_DEBUG < 10 THEN
1000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1001: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1002: END IF;
1003: -- IF PG_DEBUG < 10 THEN
1004: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1005: IEX_DEBUG_PUB.LogMessage

Line 1005: IEX_DEBUG_PUB.LogMessage

1001: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1002: END IF;
1003: -- IF PG_DEBUG < 10 THEN
1004: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1005: IEX_DEBUG_PUB.LogMessage
1006: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End <<--- ');
1007: END IF;
1008: -- IF PG_DEBUG < 10 THEN
1009: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1006: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End <<--- ');
1007: END IF;
1008: -- IF PG_DEBUG < 10 THEN
1009: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1010: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1011: END IF;
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN

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

1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: -- IF PG_DEBUG < 10 THEN
1016: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1017: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_credits');
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: ' || SQLCODE || ' ---> ' || SQLERRM);

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

1017: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_credits');
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: ' || SQLCODE || ' ---> ' || SQLERRM);
1022: END IF;
1023: if cust_credits%ISOPEN then
1024: CLOSE cust_credits ;
1025: End If ;

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

1028: End If ;
1029:
1030: -- IF PG_DEBUG < 10 THEN
1031: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1032: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1033: END IF;
1034: -- IF PG_DEBUG < 10 THEN
1035: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1036: IEX_DEBUG_PUB.LogMessage

Line 1036: IEX_DEBUG_PUB.LogMessage

1032: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1033: END IF;
1034: -- IF PG_DEBUG < 10 THEN
1035: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1036: IEX_DEBUG_PUB.LogMessage
1037: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End with Exception <<--- ');
1038: END IF;
1039: -- IF PG_DEBUG < 10 THEN
1040: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1037: ('IEX_AGING_BUCKETS_PKG.CALC_CREDITS --->> End with Exception <<--- ');
1038: END IF;
1039: -- IF PG_DEBUG < 10 THEN
1040: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1041: IEX_DEBUG_PUB.LogMessage('calc_credits: ' || l_line);
1042: END IF;
1043:
1044: END calc_credits;
1045: --

Line 1292: iex_debug_pub.logmessage

1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: -- IF PG_DEBUG < 10 THEN
1291: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1292: iex_debug_pub.logmessage
1293: ('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_receipts');
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: ' || SQLCODE || ' ---> ' || SQLERRM);

1293: ('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_receipts');
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: ' || SQLCODE || ' ---> ' || SQLERRM);
1298: END IF;
1299: if cust_unapplied_cash%ISOPEN then
1300: CLOSE cust_unapplied_cash ;
1301: End If ;

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

1304: End If ;
1305:
1306: -- IF PG_DEBUG < 10 THEN
1307: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1308: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1309: END IF;
1310: -- IF PG_DEBUG < 10 THEN
1311: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1312: IEX_DEBUG_PUB.LogMessage

Line 1312: IEX_DEBUG_PUB.LogMessage

1308: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1309: END IF;
1310: -- IF PG_DEBUG < 10 THEN
1311: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1312: IEX_DEBUG_PUB.LogMessage
1313: ('IEX_AGING_BUCKETS_PKG.CALC_RECEIPTS --->> End with Exception <<---');
1314: END IF;
1315: -- IF PG_DEBUG < 10 THEN
1316: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1313: ('IEX_AGING_BUCKETS_PKG.CALC_RECEIPTS --->> End with Exception <<---');
1314: END IF;
1315: -- IF PG_DEBUG < 10 THEN
1316: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1317: IEX_DEBUG_PUB.LogMessage('calc_receipts: ' || l_line);
1318: END IF;
1319: END calc_receipts;
1320: --
1321: --

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

1470: BEGIN
1471:
1472: -- IF PG_DEBUG < 10 THEN
1473: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1474: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1475: END IF;
1476: -- IF PG_DEBUG < 10 THEN
1477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1478: IEX_DEBUG_PUB.LogMessage

Line 1478: IEX_DEBUG_PUB.LogMessage

1474: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1475: END IF;
1476: -- IF PG_DEBUG < 10 THEN
1477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1478: IEX_DEBUG_PUB.LogMessage
1479: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> Start <<--- ');
1480: END IF;
1481: -- IF PG_DEBUG < 10 THEN
1482: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1479: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> Start <<--- ');
1480: END IF;
1481: -- IF PG_DEBUG < 10 THEN
1482: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1483: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1484: END IF;
1485:
1486: p_risk_receipts := 0;
1487:

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

1506: End If ;
1507: --
1508: -- IF PG_DEBUG < 10 THEN
1509: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1510: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1511: END IF;
1512: -- IF PG_DEBUG < 10 THEN
1513: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1514: IEX_DEBUG_PUB.LogMessage

Line 1514: IEX_DEBUG_PUB.LogMessage

1510: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1511: END IF;
1512: -- IF PG_DEBUG < 10 THEN
1513: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1514: IEX_DEBUG_PUB.LogMessage
1515: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End <<--- ');
1516: END IF;
1517: -- IF PG_DEBUG < 10 THEN
1518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1515: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End <<--- ');
1516: END IF;
1517: -- IF PG_DEBUG < 10 THEN
1518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1519: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1520: END IF;
1521:
1522: EXCEPTION
1523: WHEN OTHERS THEN

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

1522: EXCEPTION
1523: WHEN OTHERS THEN
1524: -- IF PG_DEBUG < 10 THEN
1525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1526: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_risk_receipts');
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: ' || SQLCODE || ' ---> ' || SQLERRM);

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

1526: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_risk_receipts');
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: ' || SQLCODE || ' ---> ' || SQLERRM);
1531: END IF;
1532: if cust_risk_receipts%ISOPEN then
1533: CLOSE cust_risk_receipts ;
1534: End If ;

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

1537: End If ;
1538:
1539: -- IF PG_DEBUG < 10 THEN
1540: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1541: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1542: END IF;
1543: -- IF PG_DEBUG < 10 THEN
1544: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1545: IEX_DEBUG_PUB.LogMessage

Line 1545: IEX_DEBUG_PUB.LogMessage

1541: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1542: END IF;
1543: -- IF PG_DEBUG < 10 THEN
1544: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1545: IEX_DEBUG_PUB.LogMessage
1546: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End with Exception <<--- ');
1547: END IF;
1548: -- IF PG_DEBUG < 10 THEN
1549: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1546: ('IEX_AGING_BUCKETS_PKG.CALC_risk_receipts --->> End with Exception <<--- ');
1547: END IF;
1548: -- IF PG_DEBUG < 10 THEN
1549: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1550: IEX_DEBUG_PUB.LogMessage('calc_risk_receipts: ' || l_line);
1551: END IF;
1552:
1553: END calc_risk_receipts;
1554: --

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

1658:
1659: BEGIN
1660: -- IF PG_DEBUG < 10 THEN
1661: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1662: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1663: END IF;
1664: -- IF PG_DEBUG < 10 THEN
1665: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1666: IEX_DEBUG_PUB.LogMessage

Line 1666: IEX_DEBUG_PUB.LogMessage

1662: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1663: END IF;
1664: -- IF PG_DEBUG < 10 THEN
1665: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1666: IEX_DEBUG_PUB.LogMessage
1667: ('IEX_AGING_BUCKETS_PKG.CALC_DISPUTE --->> Start <<--- ');
1668: END IF;
1669: -- IF PG_DEBUG < 10 THEN
1670: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1667: ('IEX_AGING_BUCKETS_PKG.CALC_DISPUTE --->> Start <<--- ');
1668: END IF;
1669: -- IF PG_DEBUG < 10 THEN
1670: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1671: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1672: END IF;
1673:
1674: p_dispute := 0;
1675:

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

1694: End If ;
1695: --
1696: -- IF PG_DEBUG < 10 THEN
1697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1698: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1699: END IF;
1700: -- IF PG_DEBUG < 10 THEN
1701: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1702: IEX_DEBUG_PUB.LogMessage

Line 1702: IEX_DEBUG_PUB.LogMessage

1698: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1699: END IF;
1700: -- IF PG_DEBUG < 10 THEN
1701: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1702: IEX_DEBUG_PUB.LogMessage
1703: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End <<--- ');
1704: END IF;
1705: -- IF PG_DEBUG < 10 THEN
1706: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1703: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End <<--- ');
1704: END IF;
1705: -- IF PG_DEBUG < 10 THEN
1706: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1707: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1708: END IF;
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN

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

1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: -- IF PG_DEBUG < 10 THEN
1713: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1714: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_dispute');
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: ' || SQLCODE || ' ---> ' || SQLERRM);

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

1714: iex_debug_pub.logmessage('EXCEPTION: Iex_Aging_Buckets_Pkg.calc_dispute');
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: ' || SQLCODE || ' ---> ' || SQLERRM);
1719: END IF;
1720: if cust_dispute%ISOPEN then
1721: CLOSE cust_dispute ;
1722: End If ;

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

1725: End If ;
1726:
1727: -- IF PG_DEBUG < 10 THEN
1728: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1729: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1730: END IF;
1731: -- IF PG_DEBUG < 10 THEN
1732: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1733: IEX_DEBUG_PUB.LogMessage

Line 1733: IEX_DEBUG_PUB.LogMessage

1729: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1730: END IF;
1731: -- IF PG_DEBUG < 10 THEN
1732: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1733: IEX_DEBUG_PUB.LogMessage
1734: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End with Exception <<--- ');
1735: END IF;
1736: -- IF PG_DEBUG < 10 THEN
1737: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1734: ('IEX_AGING_BUCKETS_PKG.CALC_dispute --->> End with Exception <<--- ');
1735: END IF;
1736: -- IF PG_DEBUG < 10 THEN
1737: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1738: IEX_DEBUG_PUB.LogMessage('calc_dispute: ' || l_line);
1739: END IF;
1740: END calc_dispute;
1741: --
1742: --

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

1938: BEGIN
1939:
1940: -- IF PG_DEBUG < 10 THEN
1941: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1942: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1943: END IF;
1944: -- IF PG_DEBUG < 10 THEN
1945: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1946: IEX_DEBUG_PUB.LogMessage

Line 1946: IEX_DEBUG_PUB.LogMessage

1942: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1943: END IF;
1944: -- IF PG_DEBUG < 10 THEN
1945: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1946: IEX_DEBUG_PUB.LogMessage
1947: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_PENDING_ADJ --->> Start <<--- ');
1948: END IF;
1949: -- IF PG_DEBUG < 10 THEN
1950: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1947: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_PENDING_ADJ --->> Start <<--- ');
1948: END IF;
1949: -- IF PG_DEBUG < 10 THEN
1950: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1951: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
1952: END IF;
1953:
1954: p_pending_adj := 0;
1955:

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

2004: End If ;
2005: --
2006: -- IF PG_DEBUG < 10 THEN
2007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2008: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2009: END IF;
2010: -- IF PG_DEBUG < 10 THEN
2011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2012: IEX_DEBUG_PUB.LogMessage

Line 2012: IEX_DEBUG_PUB.LogMessage

2008: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2009: END IF;
2010: -- IF PG_DEBUG < 10 THEN
2011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2012: IEX_DEBUG_PUB.LogMessage
2013: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End <<--- ');
2014: END IF;
2015: -- IF PG_DEBUG < 10 THEN
2016: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2013: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End <<--- ');
2014: END IF;
2015: -- IF PG_DEBUG < 10 THEN
2016: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2017: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2018: END IF;
2019:
2020: EXCEPTION
2021: WHEN OTHERS THEN

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

2020: EXCEPTION
2021: WHEN OTHERS THEN
2022: -- IF PG_DEBUG < 10 THEN
2023: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2024: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || 'EXCEPTION: Iex_Aging_Buckets_Pkg.calc_pending_adj');
2025: END IF;
2026: -- IF PG_DEBUG < 10 THEN
2027: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2028: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || SQLCODE || ' ---> ' || SQLERRM);

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

2024: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || 'EXCEPTION: Iex_Aging_Buckets_Pkg.calc_pending_adj');
2025: END IF;
2026: -- IF PG_DEBUG < 10 THEN
2027: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2028: iex_debug_pub.logmessage('calc_adj_fin_charges: ' || SQLCODE || ' ---> ' || SQLERRM);
2029: END IF;
2030:
2031: if cust_adj%ISOPEN then
2032: CLOSE cust_adj ;

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

2045:
2046:
2047: -- IF PG_DEBUG < 10 THEN
2048: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2049: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2050: END IF;
2051: -- IF PG_DEBUG < 10 THEN
2052: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2053: IEX_DEBUG_PUB.LogMessage

Line 2053: IEX_DEBUG_PUB.LogMessage

2049: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2050: END IF;
2051: -- IF PG_DEBUG < 10 THEN
2052: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2053: IEX_DEBUG_PUB.LogMessage
2054: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End with Exception <<--- ');
2055: END IF;
2056: -- IF PG_DEBUG < 10 THEN
2057: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2054: ('calc_adj_fin_charges: ' || 'IEX_AGING_BUCKETS_PKG.CALC_pending_adj --->> End with Exception <<--- ');
2055: END IF;
2056: -- IF PG_DEBUG < 10 THEN
2057: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2058: IEX_DEBUG_PUB.LogMessage('calc_adj_fin_charges: ' || l_line);
2059: END IF;
2060:
2061: END calc_adj_fin_charges;
2062:

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

2243: l_cons_amount Number := 0 ;
2244: Begin
2245: -- IF PG_DEBUG < 10 THEN
2246: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2247: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2248: END IF;
2249: -- IF PG_DEBUG < 10 THEN
2250: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2251: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');

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

2247: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2248: END IF;
2249: -- IF PG_DEBUG < 10 THEN
2250: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2251: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');
2252: END IF;
2253: -- IF PG_DEBUG < 10 THEN
2254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2255: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);

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

2251: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> Start <<--- ');
2252: END IF;
2253: -- IF PG_DEBUG < 10 THEN
2254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2255: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2256: END IF;
2257:
2258:
2259: SAVEPOINT Query_Aging_lines;

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

2280:
2281:
2282: -- IF PG_DEBUG < 10 THEN
2283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2284: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Bucket Id >> ' || p_bucket_id );
2285: END IF;
2286:
2287: x_return_status := FND_API.G_RET_STS_SUCCESS;
2288:

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

2297: X_MSG_DATA => v_msg_data );
2298:
2299: -- IF PG_DEBUG < 10 THEN
2300: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2301: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Functional Currency >> '|| v_currency ||
2302: ' Filter Mode ' || p_filter_mode);
2303: END IF;
2304:
2305:

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

2307: if p_filter_mode IN ('CUST', 'BILLTO') then
2308:
2309: -- IF PG_DEBUG < 10 THEN
2310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2311: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Filter Mode >> '||
2312: p_filter_mode || ' Start');
2313: END IF;
2314:
2315: if p_filter_mode = 'BILLTO' then

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

2319: from ar_payment_schedules aps
2320: where aps.customer_site_use_id = p_filter_id ;
2321:
2322: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2323: iex_debug_pub.logmessage('Cust Account id for bill to >> '
2324: || v_billto_cust_account_id);
2325: END IF;
2326:
2327: Exception

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

2326:
2327: Exception
2328: WHEN NO_DATA_FOUND THEN
2329: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2330: iex_debug_pub.logmessage('ERROR >> No Customer Account
2331: for the Passed Bill to id >>' || p_filter_id);
2332: END IF;
2333: WHEN OTHERS then
2334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2331: for the Passed Bill to id >>' || p_filter_id);
2332: END IF;
2333: WHEN OTHERS then
2334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2335: iex_debug_pub.logmessage('ERROR >> When deriving customer
2336: account for the Passed Bill to id >>' || p_filter_id ||
2337: SQLCODE || SQLERRM);
2338: END IF;
2339: End ;

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

2415: INTO l_customer_id ;
2416: END IF;
2417: -- IF PG_DEBUG < 10 THEN
2418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2419: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Party Mode Fetch Iteration >> '
2420: || to_char(l_count) || ' Filter Id '||
2421: to_char(p_filter_id));
2422: END IF;
2423: l_count := l_count + 1 ;

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

2429: END IF;
2430:
2431: -- IF PG_DEBUG < 10 THEN
2432: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2433: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || 'Mode Party >> Customer >> '
2434: || l_customer_id );
2435: END IF;
2436:
2437: lt_outstanding_balance := 0 ;

Line 2441: IEX_DEBUG_PUB.LogMessage

2437: lt_outstanding_balance := 0 ;
2438: -- Call the Aging Procedure for each fetched customer_id
2439: -- IF PG_DEBUG < 10 THEN
2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2441: IEX_DEBUG_PUB.LogMessage
2442: ('QUERY_AGING_LINES: ' || 'Before Calling calc aging buckets >> Parameters >>');
2443: END IF;
2444: -- IF PG_DEBUG < 10 THEN
2445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2446: IEX_DEBUG_PUB.LogMessage

2442: ('QUERY_AGING_LINES: ' || 'Before Calling calc aging buckets >> Parameters >>');
2443: END IF;
2444: -- IF PG_DEBUG < 10 THEN
2445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2446: IEX_DEBUG_PUB.LogMessage
2447: ('QUERY_AGING_LINES: ' || ' Bucket Id > '|| p_bucket_id
2448: || 'Customer Id > ' || to_char(l_customer_id));
2449: END IF;
2450:

Line 2506: IEX_DEBUG_PUB.LogMessage

2502: -- when loading the final output table.
2503:
2504: -- IF PG_DEBUG < 10 THEN
2505: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2506: IEX_DEBUG_PUB.LogMessage
2507: ('QUERY_AGING_LINES: ' || 'Acct Balance >> '|| to_char(lt_outstanding_balance));
2508: END IF;
2509:
2510: l_outstanding_balance :=

Line 2515: IEX_DEBUG_PUB.LogMessage

2511: l_outstanding_balance + lt_outstanding_balance ;
2512:
2513: -- IF PG_DEBUG < 10 THEN
2514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2515: IEX_DEBUG_PUB.LogMessage
2516: ('QUERY_AGING_LINES: ' || 'Total Balance >> '|| to_char(l_outstanding_balance));
2517: END IF;
2518:
2519: -- Rolling Bucket 0

Line 2539: IEX_DEBUG_PUB.LogMessage

2535: End If ;
2536:
2537: -- IF PG_DEBUG < 10 THEN
2538: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2539: IEX_DEBUG_PUB.LogMessage
2540: ('QUERY_AGING_LINES: ' || 'Bucket 0 >> '||lt_bucket_titletop_0 || ' '
2541: || lt_bucket_titlebottom_0);
2542: END IF;
2543:

Line 2562: IEX_DEBUG_PUB.LogMessage

2558: l_bucket_seq_num_1 := lt_bucket_seq_num_1 ;
2559: End If ;
2560: -- IF PG_DEBUG < 10 THEN
2561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2562: IEX_DEBUG_PUB.LogMessage
2563: ('QUERY_AGING_LINES: ' || 'Bucket 1 >> '||lt_bucket_titletop_1 || ' '
2564: || lt_bucket_titlebottom_1);
2565: END IF;
2566:

Line 2604: IEX_DEBUG_PUB.LogMessage

2600: l_bucket_seq_num_3 := lt_bucket_seq_num_3 ;
2601: End If ;
2602: -- IF PG_DEBUG < 10 THEN
2603: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2604: IEX_DEBUG_PUB.LogMessage
2605: ('QUERY_AGING_LINES: ' || 'Bucket 3 >> '||lt_bucket_titletop_3 || ' '
2606: || lt_bucket_titlebottom_3);
2607: END IF;
2608:

Line 2676: IEX_DEBUG_PUB.LogMessage

2672: Exception
2673: WHEN OTHERS Then
2674: -- IF PG_DEBUG < 10 THEN
2675: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2676: IEX_DEBUG_PUB.LogMessage
2677: ('QUERY_AGING_LINES: ' || 'When Others Party Mode >> '||SQLCODE
2678: || ' ==> ' ||SQLERRM);
2679: END IF;
2680: IF NVL(p_using_paying_rel, 'N') = 'Y' THEN

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

2690: End If ;
2691:
2692: -- IF PG_DEBUG < 10 THEN
2693: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2694: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading Buckets into Table of Records');
2695: END IF;
2696:
2697: -- Load the Derived values into PL/SQL table
2698: /* ---------------------------------------------------------

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

2710: := l_bucket_seq_num_0 ;
2711:
2712: -- IF PG_DEBUG < 10 THEN
2713: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2714: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2715: END IF;
2716: -- IF PG_DEBUG < 10 THEN
2717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2718: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 1 Bucket Name ' ||

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

2714: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2715: END IF;
2716: -- IF PG_DEBUG < 10 THEN
2717: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2718: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 1 Bucket Name ' ||
2719: x_bucket_lines_tbl(l_cnt).bucket_line ||
2720: ' Amount = ' || to_char(l_bucket_amount_0) ||
2721: '] Line Id = ['|| to_char(l_bucket_line_id_0) ||
2722: '] Seq Num = ['|| to_char(l_bucket_seq_num_0));

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

2741: := l_bucket_seq_num_1 ;
2742:
2743: -- IF PG_DEBUG < 10 THEN
2744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2745: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 2 Bucket Name [' ||
2746: x_bucket_lines_tbl(l_cnt).bucket_line ||
2747: '] Amount = [' || to_char(l_bucket_amount_1) ||
2748: '] Line Id = ['|| to_char(l_bucket_line_id_1) ||
2749: '] Seq Num = ['|| to_char(l_bucket_seq_num_1));

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

2767: := l_bucket_seq_num_2 ;
2768:
2769: -- IF PG_DEBUG < 10 THEN
2770: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2771: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 3 Bucket Name ' ||
2772: x_bucket_lines_tbl(l_cnt).bucket_line ||
2773: ' Amount = ' || to_char(l_bucket_amount_2) ||
2774: '] Line Id = ['|| to_char(l_bucket_line_id_2) ||
2775: '] Seq Num = ['|| to_char(l_bucket_seq_num_2));

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

2793: := l_bucket_seq_num_3 ;
2794:
2795: -- IF PG_DEBUG < 10 THEN
2796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2797: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 4 Bucket Name ' ||
2798: x_bucket_lines_tbl(l_cnt).bucket_line ||
2799: ' Amount = ' || to_char(l_bucket_amount_3) ||
2800: '] Line Id = ['|| to_char(l_bucket_line_id_3) ||
2801: '] Seq Num = ['|| to_char(l_bucket_seq_num_3));

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

2820: := l_bucket_seq_num_4 ;
2821:
2822: -- IF PG_DEBUG < 10 THEN
2823: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2824: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 5 Bucket Name ' ||
2825: x_bucket_lines_tbl(l_cnt).bucket_line ||
2826: ' Amount = ' || to_char(l_bucket_amount_4) ||
2827: '] Line Id = ['|| to_char(l_bucket_line_id_4) ||
2828: '] Seq Num = ['|| to_char(l_bucket_seq_num_4));

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

2846: := l_bucket_seq_num_5 ;
2847:
2848: -- IF PG_DEBUG < 10 THEN
2849: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2850: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 6 Bucket Name ' ||
2851: x_bucket_lines_tbl(l_cnt).bucket_line ||
2852: ' Amount = ' || to_char(l_bucket_amount_5) ||
2853: '] Line Id = ['|| to_char(l_bucket_line_id_5) ||
2854: '] Seq Num = ['|| to_char(l_bucket_seq_num_5));

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

2872: := l_bucket_seq_num_6 ;
2873:
2874: -- IF PG_DEBUG < 10 THEN
2875: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2876: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row 7 Bucket Name ' ||
2877: x_bucket_lines_tbl(l_cnt).bucket_line ||
2878: ' Amount = ' || to_char(l_bucket_amount_6) ||
2879: '] Line Id = ['|| to_char(l_bucket_line_id_6) ||
2880: '] Seq Num = ['|| to_char(l_bucket_seq_num_6));

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

2883: -- End If ;
2884: End If ;
2885: -- IF PG_DEBUG < 10 THEN
2886: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2887: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || l_line);
2888: END IF;
2889:
2890:
2891:

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

2889:
2890:
2891:
2892: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2893: iex_debug_pub.logmessage('Filter Mode Before Collectible Amt ' || p_filter_mode || ' [ '||p_filter_id || ' ]') ;
2894: END IF;
2895:
2896: -- Derive Collectible Amounts
2897: if p_filter_mode = 'CUST' then

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

3123: Loading all the one time results
3124: ---------------------------------------------------------*/
3125: -- IF PG_DEBUG < 10 THEN
3126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3127: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Loading one time results ' );
3128: END IF;
3129: FOR cnt in 1..x_bucket_lines_tbl.COUNT
3130: LOOP
3131: x_bucket_lines_tbl(cnt).outstanding_balance

Line 3145: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: collectible_amount--> ' ||x_bucket_lines_tbl(cnt).collectible_amount);

3141: if l_collectible_bkt_id_tbl(bkt_cnt) =
3142: x_bucket_lines_tbl(cnt).bucket_line_id then
3143: x_bucket_lines_tbl(cnt).collectible_amount :=
3144: l_collectible_bkt_amt_tbl(bkt_cnt) ;
3145: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: collectible_amount--> ' ||x_bucket_lines_tbl(cnt).collectible_amount);
3146: End If ;
3147: End Loop ;
3148: End If ;
3149:

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

3149:
3150:
3151: -- IF PG_DEBUG < 10 THEN
3152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3153: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || ' Row >> ' || to_char(cnt) || ' Bal [' ||
3154: to_char(x_bucket_lines_tbl(cnt).outstanding_balance) ||
3155: 'Currency [' || x_bucket_lines_tbl(cnt).currency);
3156: END IF;
3157:

Line 3159: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_amt-->'|| x_bucket_lines_tbl(cnt).amount);

3155: 'Currency [' || x_bucket_lines_tbl(cnt).currency);
3156: END IF;
3157:
3158:
3159: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_amt-->'|| x_bucket_lines_tbl(cnt).amount);
3160: l_total_amount := l_total_amount + x_bucket_lines_tbl(cnt).amount;
3161:
3162: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_amt-->'||l_total_amount);
3163: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_coll_amt-->'|| x_bucket_lines_tbl(cnt).collectible_amount);

Line 3162: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_amt-->'||l_total_amount);

3158:
3159: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_amt-->'|| x_bucket_lines_tbl(cnt).amount);
3160: l_total_amount := l_total_amount + x_bucket_lines_tbl(cnt).amount;
3161:
3162: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_amt-->'||l_total_amount);
3163: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_coll_amt-->'|| x_bucket_lines_tbl(cnt).collectible_amount);
3164: l_total_coll_amount := l_total_coll_amount +
3165: x_bucket_lines_tbl(cnt).collectible_amount;
3166: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_coll_amount-->'|| l_total_coll_amount);

Line 3163: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_coll_amt-->'|| x_bucket_lines_tbl(cnt).collectible_amount);

3159: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_amt-->'|| x_bucket_lines_tbl(cnt).amount);
3160: l_total_amount := l_total_amount + x_bucket_lines_tbl(cnt).amount;
3161:
3162: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_amt-->'||l_total_amount);
3163: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_coll_amt-->'|| x_bucket_lines_tbl(cnt).collectible_amount);
3164: l_total_coll_amount := l_total_coll_amount +
3165: x_bucket_lines_tbl(cnt).collectible_amount;
3166: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_coll_amount-->'|| l_total_coll_amount);
3167:

Line 3166: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_coll_amount-->'|| l_total_coll_amount);

3162: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_amt-->'||l_total_amount);
3163: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: x_bucket_lines_tbl_coll_amt-->'|| x_bucket_lines_tbl(cnt).collectible_amount);
3164: l_total_coll_amount := l_total_coll_amount +
3165: x_bucket_lines_tbl(cnt).collectible_amount;
3166: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: l_total_coll_amount-->'|| l_total_coll_amount);
3167:
3168:
3169: GET_CNSLD_INVOICE_COUNT(
3170: p_api_version => p_api_version,

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

3182: x_count => x_bucket_lines_tbl(cnt).consolidated_invoices,
3183: x_amount => l_cons_amount) ;
3184:
3185: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3186: IEX_DEBUG_PUB.LogMessage('After Call CONS : ' || x_bucket_lines_tbl(cnt).consolidated_invoices) ;
3187: END IF;
3188:
3189: l_total_cnsld_invoices := l_total_cnsld_invoices +
3190: x_bucket_lines_tbl(cnt).consolidated_invoices ;

Line 3191: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cnsld_invoices-->'||l_total_cnsld_invoices);

3187: END IF;
3188:
3189: l_total_cnsld_invoices := l_total_cnsld_invoices +
3190: x_bucket_lines_tbl(cnt).consolidated_invoices ;
3191: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cnsld_invoices-->'||l_total_cnsld_invoices);
3192:
3193:
3194: -- Load all the Values from the Collections
3195: -- Load Invoice Count/Amount

Line 3216: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_cnt-->'||l_total_invoices);

3212:
3213:
3214: l_total_invoices := l_total_invoices +
3215: x_bucket_lines_tbl(cnt).Invoice_count ;
3216: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_cnt-->'||l_total_invoices);
3217: l_total_inv_amount := l_total_inv_amount +
3218: x_bucket_lines_tbl(cnt).Invoice_amount ;
3219: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_amt-->'||l_total_inv_amount);
3220:

Line 3219: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_amt-->'||l_total_inv_amount);

3215: x_bucket_lines_tbl(cnt).Invoice_count ;
3216: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_cnt-->'||l_total_invoices);
3217: l_total_inv_amount := l_total_inv_amount +
3218: x_bucket_lines_tbl(cnt).Invoice_amount ;
3219: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_inv_amt-->'||l_total_inv_amount);
3220:
3221:
3222: -- Load DM Count/Amount
3223: GET_BKT_INVOICE_CLASS_INFO

Line 3241: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dms-->'||l_total_debit_memos);

3237: x_class_count => x_bucket_lines_tbl(cnt).Dm_count,
3238: x_class_amount => x_bucket_lines_tbl(cnt).Dm_amount);
3239: l_total_debit_memos := l_total_debit_memos +
3240: x_bucket_lines_tbl(cnt).dm_count ;
3241: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dms-->'||l_total_debit_memos);
3242: l_total_dm_amount := l_total_dm_amount +
3243: x_bucket_lines_tbl(cnt).dm_amount ;
3244: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dm_amt-->'||l_total_dm_amount);
3245:

Line 3244: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dm_amt-->'||l_total_dm_amount);

3240: x_bucket_lines_tbl(cnt).dm_count ;
3241: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dms-->'||l_total_debit_memos);
3242: l_total_dm_amount := l_total_dm_amount +
3243: x_bucket_lines_tbl(cnt).dm_amount ;
3244: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_dm_amt-->'||l_total_dm_amount);
3245:
3246: -- Load Chargeback Count/Amount
3247: GET_BKT_INVOICE_CLASS_INFO
3248: (p_api_version => p_api_version,

Line 3265: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cbs-->'||l_total_chargebacks);

3261: x_class_count => x_bucket_lines_tbl(cnt).cb_count,
3262: x_class_amount => x_bucket_lines_tbl(cnt).cb_amount);
3263: l_total_chargebacks := l_total_chargebacks +
3264: x_bucket_lines_tbl(cnt).cb_count ;
3265: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cbs-->'||l_total_chargebacks);
3266: l_total_cb_amount := l_total_cb_amount +
3267: x_bucket_lines_tbl(cnt).cb_amount ;
3268: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cb_amt-->'||l_total_cb_amount);
3269: END LOOP ;

Line 3268: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cb_amt-->'||l_total_cb_amount);

3264: x_bucket_lines_tbl(cnt).cb_count ;
3265: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cbs-->'||l_total_chargebacks);
3266: l_total_cb_amount := l_total_cb_amount +
3267: x_bucket_lines_tbl(cnt).cb_amount ;
3268: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: '||'l_total_cb_amt-->'||l_total_cb_amount);
3269: END LOOP ;
3270:
3271: -- Adding Total Row to the Table
3272: /* TRANSLATE THIS */

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

3302: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3303:
3304: -- IF PG_DEBUG < 10 THEN
3305: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3306: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3307: END IF;
3308: -- IF PG_DEBUG < 10 THEN
3309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3310: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');

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

3306: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3307: END IF;
3308: -- IF PG_DEBUG < 10 THEN
3309: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3310: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');
3311: END IF;
3312: -- IF PG_DEBUG < 10 THEN
3313: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3314: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');

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

3310: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES --->> End <<--- ');
3311: END IF;
3312: -- IF PG_DEBUG < 10 THEN
3313: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3314: IEX_DEBUG_PUB.LogMessage('QUERY_AGING_LINES: ' || '-----------------------------------------');
3315: END IF;
3316:
3317: EXCEPTION
3318: WHEN FND_API.G_EXC_ERROR THEN

Line 3374: IEX_DEBUG_PUB.LogMessage(l_line) ;

3370: x_class_count := 0; -- added by ehuh for bill-to
3371: x_class_amount := 0; -- added by ehuh for bill-to
3372:
3373: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3374: IEX_DEBUG_PUB.LogMessage(l_line) ;
3375: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3376: IEX_DEBUG_PUB.LogMessage(l_line) ;
3377: END IF;
3378:

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

3371: x_class_amount := 0; -- added by ehuh for bill-to
3372:
3373: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3374: IEX_DEBUG_PUB.LogMessage(l_line) ;
3375: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3376: IEX_DEBUG_PUB.LogMessage(l_line) ;
3377: END IF;
3378:
3379:

Line 3376: IEX_DEBUG_PUB.LogMessage(l_line) ;

3372:
3373: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3374: IEX_DEBUG_PUB.LogMessage(l_line) ;
3375: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> Start <<--- ') ;
3376: IEX_DEBUG_PUB.LogMessage(l_line) ;
3377: END IF;
3378:
3379:
3380: --- Begin - Andre Araujo - 11/09/2004 - Performance fix we will select the aging separately

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

3492: v_sql := v_tran_sql ;
3493: End If ;
3494:
3495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3496: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;
3497: END IF;
3498:
3499: Begin
3500:

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

3521: WHEN NO_DATA_FOUND THEN
3522: x_class_count := 0; x_class_amount := 0;
3523: WHEN OTHERS THEN
3524: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3525: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;
3526: END IF;
3527: End ;
3528:
3529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3530: IEX_DEBUG_PUB.LogMessage(l_line) ;

3526: END IF;
3527: End ;
3528:
3529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3530: IEX_DEBUG_PUB.LogMessage(l_line) ;
3531: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3532: IEX_DEBUG_PUB.LogMessage(l_line) ;
3533: END IF;
3534:

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

3527: End ;
3528:
3529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3530: IEX_DEBUG_PUB.LogMessage(l_line) ;
3531: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3532: IEX_DEBUG_PUB.LogMessage(l_line) ;
3533: END IF;
3534:
3535: END ;

Line 3532: IEX_DEBUG_PUB.LogMessage(l_line) ;

3528:
3529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3530: IEX_DEBUG_PUB.LogMessage(l_line) ;
3531: IEX_DEBUG_PUB.LogMessage('GET_BKT_INVOICE_CLASS_INFO --->> End <<--- ') ;
3532: IEX_DEBUG_PUB.LogMessage(l_line) ;
3533: END IF;
3534:
3535: END ;
3536:

Line 3579: IEX_DEBUG_PUB.LogMessage(l_line) ;

3575: b_class := 'INV' ;
3576: b_status := 'OP' ;
3577:
3578: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3579: IEX_DEBUG_PUB.LogMessage(l_line) ;
3580: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3581: IEX_DEBUG_PUB.LogMessage(l_line) ;
3582: IEX_DEBUG_PUB.LogMessage('Hello') ;
3583: END IF;

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

3576: b_status := 'OP' ;
3577:
3578: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3579: IEX_DEBUG_PUB.LogMessage(l_line) ;
3580: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3581: IEX_DEBUG_PUB.LogMessage(l_line) ;
3582: IEX_DEBUG_PUB.LogMessage('Hello') ;
3583: END IF;
3584:

Line 3581: IEX_DEBUG_PUB.LogMessage(l_line) ;

3577:
3578: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3579: IEX_DEBUG_PUB.LogMessage(l_line) ;
3580: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3581: IEX_DEBUG_PUB.LogMessage(l_line) ;
3582: IEX_DEBUG_PUB.LogMessage('Hello') ;
3583: END IF;
3584:
3585: v_cust_cnsld_sql :=

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

3578: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3579: IEX_DEBUG_PUB.LogMessage(l_line) ;
3580: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> Start <<--- ') ;
3581: IEX_DEBUG_PUB.LogMessage(l_line) ;
3582: IEX_DEBUG_PUB.LogMessage('Hello') ;
3583: END IF;
3584:
3585: v_cust_cnsld_sql :=
3586: 'SELECT count(distinct ocahb.id)

Line 3666: IEX_DEBUG_PUB.LogMessage('') ;

3662:
3663: END IF;
3664:
3665: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3666: IEX_DEBUG_PUB.LogMessage('') ;
3667: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;
3668: END IF;
3669:
3670:

Line 3667: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;

3663: END IF;
3664:
3665: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3666: IEX_DEBUG_PUB.LogMessage('') ;
3667: IEX_DEBUG_PUB.LogMessage(v_party_cnsld_sql) ;
3668: END IF;
3669:
3670:
3671:

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

3701: v_sql := v_party_billto_cnsld_sql ;
3702: End If ;
3703:
3704: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3705: IEX_DEBUG_PUB.LogMessage('SQL Executed --> ' || v_sql) ;
3706: END IF;
3707:
3708: Begin
3709:

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

3736: WHEN NO_DATA_FOUND THEN
3737: x_count := 0; x_amount := 0;
3738: WHEN OTHERS THEN
3739: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3740: IEX_DEBUG_PUB.LogMessage(SQLCODE || ' ' || SQLERRM) ;
3741: END IF;
3742: End ;
3743:
3744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3745: IEX_DEBUG_PUB.LogMessage(l_line) ;

3741: END IF;
3742: End ;
3743:
3744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3745: IEX_DEBUG_PUB.LogMessage(l_line) ;
3746: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3747: IEX_DEBUG_PUB.LogMessage(l_line) ;
3748: END IF;
3749: EXCEPTION

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

3742: End ;
3743:
3744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3745: IEX_DEBUG_PUB.LogMessage(l_line) ;
3746: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3747: IEX_DEBUG_PUB.LogMessage(l_line) ;
3748: END IF;
3749: EXCEPTION
3750: WHEN OTHERS then

Line 3747: IEX_DEBUG_PUB.LogMessage(l_line) ;

3743:
3744: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3745: IEX_DEBUG_PUB.LogMessage(l_line) ;
3746: IEX_DEBUG_PUB.LogMessage('GET_CNSLD_INVOICE_COUNT --->> End <<--- ') ;
3747: IEX_DEBUG_PUB.LogMessage(l_line) ;
3748: END IF;
3749: EXCEPTION
3750: WHEN OTHERS then
3751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

3748: END IF;
3749: EXCEPTION
3750: WHEN OTHERS then
3751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3752: IEX_DEBUG_PUB.LogMessage(' GET_CNSLD_INVOICE_COUNT - MAIN ' ||
3753: SQLCODE || ' ' || SQLERRM) ;
3754: END IF;
3755:
3756: END GET_CNSLD_INVOICE_COUNT ;