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.PA_SWEEPER dependencies on PA_DEBUG

Line 619: pa_debug.g_err_stage := 'Log: Inside populate_hist_table';

615:
616: BEGIN
617:
618: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
619: pa_debug.g_err_stage := 'Log: Inside populate_hist_table';
620: pa_debug.write_file('LOG',pa_debug.g_err_stage);
621: END IF;
622:
623: OPEN c_bc_pkts_x;

Line 620: pa_debug.write_file('LOG',pa_debug.g_err_stage);

616: BEGIN
617:
618: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
619: pa_debug.g_err_stage := 'Log: Inside populate_hist_table';
620: pa_debug.write_file('LOG',pa_debug.g_err_stage);
621: END IF;
622:
623: OPEN c_bc_pkts_x;
624: LOOP

Line 632: pa_debug.g_err_stage := 'Log: No. of records to insert in pa_bc_packets_hist ' || l_pa_pkt_hist.count;

628: EXIT WHEN l_pa_pkt_hist.COUNT =0;
629:
630:
631: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
632: pa_debug.g_err_stage := 'Log: No. of records to insert in pa_bc_packets_hist ' || l_pa_pkt_hist.count;
633: pa_debug.write_file('LOG',pa_debug.g_err_stage);
634: END IF;
635:
636:

Line 633: pa_debug.write_file('LOG',pa_debug.g_err_stage);

629:
630:
631: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
632: pa_debug.g_err_stage := 'Log: No. of records to insert in pa_bc_packets_hist ' || l_pa_pkt_hist.count;
633: pa_debug.write_file('LOG',pa_debug.g_err_stage);
634: END IF;
635:
636:
637: FORALL i IN l_pa_pkt_hist.FIRST .. l_pa_pkt_hist.LAST

Line 644: pa_debug.g_err_stage := 'Log: Exiting populate_hist_table';

640: END LOOP;
641: CLOSE c_bc_pkts_x;
642:
643: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
644: pa_debug.g_err_stage := 'Log: Exiting populate_hist_table';
645: pa_debug.write_file('LOG',pa_debug.g_err_stage);
646: END IF;
647:
648: END populate_hist_table;

Line 645: pa_debug.write_file('LOG',pa_debug.g_err_stage);

641: CLOSE c_bc_pkts_x;
642:
643: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
644: pa_debug.g_err_stage := 'Log: Exiting populate_hist_table';
645: pa_debug.write_file('LOG',pa_debug.g_err_stage);
646: END IF;
647:
648: END populate_hist_table;
649:

Line 654: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');

650:
651: BEGIN
652:
653: --Initialize the error stack
654: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');
655:
656: --Initialize the message table for FND_MSG_PUB
657: fnd_msg_pub.initialize;
658:

Line 659: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

655:
656: --Initialize the message table for FND_MSG_PUB
657: fnd_msg_pub.initialize;
658:
659: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
660: l_debug_mode := NVL(l_debug_mode, 'N');
661:
662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
663:

Line 662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

658:
659: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
660: l_debug_mode := NVL(l_debug_mode, 'N');
661:
662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
663:
664: --Initialize the return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:

Line 668: pa_debug.g_err_stage := 'Log: Calling populate_hist_table';

664: --Initialize the return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
668: pa_debug.g_err_stage := 'Log: Calling populate_hist_table';
669: pa_debug.write_file('LOG',pa_debug.g_err_stage);
670: END IF;
671:
672: -- Bug 14364299 Added populate_hist_table procedure call

Line 669: pa_debug.write_file('LOG',pa_debug.g_err_stage);

665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
668: pa_debug.g_err_stage := 'Log: Calling populate_hist_table';
669: pa_debug.write_file('LOG',pa_debug.g_err_stage);
670: END IF;
671:
672: -- Bug 14364299 Added populate_hist_table procedure call
673:

Line 677: pa_debug.g_err_stage := 'Log: Start of Update_Act_Enc_Balance';

673:
674: populate_hist_table();
675:
676: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
677: pa_debug.g_err_stage := 'Log: Start of Update_Act_Enc_Balance';
678: pa_debug.write_file('LOG',pa_debug.g_err_stage);
679: END IF;
680:
681: pa_funds_control_utils.print_message('Entering Sweeper');

Line 678: pa_debug.write_file('LOG',pa_debug.g_err_stage);

674: populate_hist_table();
675:
676: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
677: pa_debug.g_err_stage := 'Log: Start of Update_Act_Enc_Balance';
678: pa_debug.write_file('LOG',pa_debug.g_err_stage);
679: END IF;
680:
681: pa_funds_control_utils.print_message('Entering Sweeper');
682: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */

Line 699: pa_debug.g_err_stage := 'Log: No. of records to delete ' || l_RowIdTab.count;

695: l_RowIdTab
696: limit rows;
697:
698: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
699: pa_debug.g_err_stage := 'Log: No. of records to delete ' || l_RowIdTab.count;
700: pa_debug.write_file('LOG',pa_debug.g_err_stage);
701: END IF;
702:
703: pa_funds_control_utils.print_message('No. of records to delete = ' || l_RowIdTab.count);

Line 700: pa_debug.write_file('LOG',pa_debug.g_err_stage);

696: limit rows;
697:
698: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
699: pa_debug.g_err_stage := 'Log: No. of records to delete ' || l_RowIdTab.count;
700: pa_debug.write_file('LOG',pa_debug.g_err_stage);
701: END IF;
702:
703: pa_funds_control_utils.print_message('No. of records to delete = ' || l_RowIdTab.count);
704:

Line 707: pa_debug.g_err_stage := 'Log: No records in c_delete_pkts, exit';

703: pa_funds_control_utils.print_message('No. of records to delete = ' || l_RowIdTab.count);
704:
705: if l_RowIdTab.count = 0 then
706: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
707: pa_debug.g_err_stage := 'Log: No records in c_delete_pkts, exit';
708: pa_debug.write_file('LOG',pa_debug.g_err_stage);
709: END IF;
710: pa_funds_control_utils.print_message('No records from c_delete_pkts, exit');
711: exit;

Line 708: pa_debug.write_file('LOG',pa_debug.g_err_stage);

704:
705: if l_RowIdTab.count = 0 then
706: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
707: pa_debug.g_err_stage := 'Log: No records in c_delete_pkts, exit';
708: pa_debug.write_file('LOG',pa_debug.g_err_stage);
709: END IF;
710: pa_funds_control_utils.print_message('No records from c_delete_pkts, exit');
711: exit;
712: end if;

Line 729: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';

725: pa_funds_control_utils.print_message('Close c_delete_pkts');
726:
727: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
728: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
729: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
730: pa_debug.write_file('LOG',pa_debug.g_err_stage);
731: END IF;
732: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
733: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));

Line 730: pa_debug.write_file('LOG',pa_debug.g_err_stage);

726:
727: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
728: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
729: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
730: pa_debug.write_file('LOG',pa_debug.g_err_stage);
731: END IF;
732: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
733: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));
734:

Line 749: pa_debug.g_err_stage := 'Log: Deleted ' || to_char(l_rowcount) || ' records from GL_BC_PACKETS older than ' || l_profile_value || ' days';

745: l_rowcount:=sql%rowcount;
746: /*Code Changes for Bug No.2984871 end */
747: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
748: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
749: pa_debug.g_err_stage := 'Log: Deleted ' || to_char(l_rowcount) || ' records from GL_BC_PACKETS older than ' || l_profile_value || ' days';
750: pa_debug.write_file('LOG',pa_debug.g_err_stage);
751: END IF;
752: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
753: pa_funds_control_utils.print_message('No of Deleted old packets in gl_bc_packets = '|| to_char(l_rowcount));

Line 750: pa_debug.write_file('LOG',pa_debug.g_err_stage);

746: /*Code Changes for Bug No.2984871 end */
747: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
748: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
749: pa_debug.g_err_stage := 'Log: Deleted ' || to_char(l_rowcount) || ' records from GL_BC_PACKETS older than ' || l_profile_value || ' days';
750: pa_debug.write_file('LOG',pa_debug.g_err_stage);
751: END IF;
752: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
753: pa_funds_control_utils.print_message('No of Deleted old packets in gl_bc_packets = '|| to_char(l_rowcount));
754:

Line 756: pa_debug.g_err_stage := 'Log: Entering Loop';

752: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
753: pa_funds_control_utils.print_message('No of Deleted old packets in gl_bc_packets = '|| to_char(l_rowcount));
754:
755: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
756: pa_debug.g_err_stage := 'Log: Entering Loop';
757: pa_debug.write_file('LOG',pa_debug.g_err_stage);
758: END IF;
759:
760: --Loop for distinct project in pa_bc_packets

Line 757: pa_debug.write_file('LOG',pa_debug.g_err_stage);

753: pa_funds_control_utils.print_message('No of Deleted old packets in gl_bc_packets = '|| to_char(l_rowcount));
754:
755: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
756: pa_debug.g_err_stage := 'Log: Entering Loop';
757: pa_debug.write_file('LOG',pa_debug.g_err_stage);
758: END IF;
759:
760: --Loop for distinct project in pa_bc_packets
761: FOR eRec in c_pkt_proj LOOP

Line 768: pa_debug.g_err_stage := '*******************************************************';

764: pa_funds_control_utils.print_message('*******************************************************');
765: pa_funds_control_utils.print_message('Inside Project loop ' || to_char(l_project_id));
766:
767: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
768: pa_debug.g_err_stage := '*******************************************************';
769: pa_debug.write_file('LOG',pa_debug.g_err_stage);
770:
771: pa_debug.g_err_stage := 'Log: Inside Loop for Project = ' || to_char(l_project_id);
772: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 769: pa_debug.write_file('LOG',pa_debug.g_err_stage);

765: pa_funds_control_utils.print_message('Inside Project loop ' || to_char(l_project_id));
766:
767: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
768: pa_debug.g_err_stage := '*******************************************************';
769: pa_debug.write_file('LOG',pa_debug.g_err_stage);
770:
771: pa_debug.g_err_stage := 'Log: Inside Loop for Project = ' || to_char(l_project_id);
772: pa_debug.write_file('LOG',pa_debug.g_err_stage);
773: END IF;

Line 771: pa_debug.g_err_stage := 'Log: Inside Loop for Project = ' || to_char(l_project_id);

767: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
768: pa_debug.g_err_stage := '*******************************************************';
769: pa_debug.write_file('LOG',pa_debug.g_err_stage);
770:
771: pa_debug.g_err_stage := 'Log: Inside Loop for Project = ' || to_char(l_project_id);
772: pa_debug.write_file('LOG',pa_debug.g_err_stage);
773: END IF;
774:
775: --Acquire lock on project

Line 772: pa_debug.write_file('LOG',pa_debug.g_err_stage);

768: pa_debug.g_err_stage := '*******************************************************';
769: pa_debug.write_file('LOG',pa_debug.g_err_stage);
770:
771: pa_debug.g_err_stage := 'Log: Inside Loop for Project = ' || to_char(l_project_id);
772: pa_debug.write_file('LOG',pa_debug.g_err_stage);
773: END IF;
774:
775: --Acquire lock on project
776: IF (pa_debug.acquire_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN

Line 776: IF (pa_debug.acquire_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN

772: pa_debug.write_file('LOG',pa_debug.g_err_stage);
773: END IF;
774:
775: --Acquire lock on project
776: IF (pa_debug.acquire_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN
777:
778: pa_funds_control_utils.print_message('Acquired Lock on project '||to_char(l_project_id));
779:
780: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */

Line 781: pa_debug.g_err_stage := 'Log: Lock Acquired for Project = ' || to_char(l_project_id) ;

777:
778: pa_funds_control_utils.print_message('Acquired Lock on project '||to_char(l_project_id));
779:
780: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
781: pa_debug.g_err_stage := 'Log: Lock Acquired for Project = ' || to_char(l_project_id) ;
782: pa_debug.write_file('LOG',pa_debug.g_err_stage);
783: END IF;
784:
785: pa_funds_control_utils.print_message('Open cursor c_bc_packets');

Line 782: pa_debug.write_file('LOG',pa_debug.g_err_stage);

778: pa_funds_control_utils.print_message('Acquired Lock on project '||to_char(l_project_id));
779:
780: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
781: pa_debug.g_err_stage := 'Log: Lock Acquired for Project = ' || to_char(l_project_id) ;
782: pa_debug.write_file('LOG',pa_debug.g_err_stage);
783: END IF;
784:
785: pa_funds_control_utils.print_message('Open cursor c_bc_packets');
786: --Open c_bc_packets cursor

Line 802: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';

798: --Call procedure to initialize the tables
799: InitPlSqlTabs;
800:
801: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
802: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';
803: pa_debug.write_file('LOG',pa_debug.g_err_stage);
804: END IF;
805:
806: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);

Line 803: pa_debug.write_file('LOG',pa_debug.g_err_stage);

799: InitPlSqlTabs;
800:
801: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
802: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';
803: pa_debug.write_file('LOG',pa_debug.g_err_stage);
804: END IF;
805:
806: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
807:

Line 809: pa_debug.g_err_stage := 'Log: Fetch cursor c_bc_packets';

805:
806: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
807:
808: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
809: pa_debug.g_err_stage := 'Log: Fetch cursor c_bc_packets';
810: pa_debug.write_file('LOG',pa_debug.g_err_stage);
811: END IF;
812:
813:

Line 810: pa_debug.write_file('LOG',pa_debug.g_err_stage);

806: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
807:
808: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
809: pa_debug.g_err_stage := 'Log: Fetch cursor c_bc_packets';
810: pa_debug.write_file('LOG',pa_debug.g_err_stage);
811: END IF;
812:
813:
814: pa_funds_control_utils.print_message('Fetch cursor c_bc_packets');

Line 883: pa_debug.g_err_stage := 'Log: No. of records fetched ' || l_PktIdTab.count;

879: ,l_PktDocDistTypeTab
880: LIMIT rows;
881:
882: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
883: pa_debug.g_err_stage := 'Log: No. of records fetched ' || l_PktIdTab.count;
884: pa_debug.write_file('LOG',pa_debug.g_err_stage);
885: END IF;
886:
887: pa_funds_control_utils.print_message('No. of records fetched = ' || l_PktIdTab.count);

Line 884: pa_debug.write_file('LOG',pa_debug.g_err_stage);

880: LIMIT rows;
881:
882: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
883: pa_debug.g_err_stage := 'Log: No. of records fetched ' || l_PktIdTab.count;
884: pa_debug.write_file('LOG',pa_debug.g_err_stage);
885: END IF;
886:
887: pa_funds_control_utils.print_message('No. of records fetched = ' || l_PktIdTab.count);
888:

Line 892: pa_debug.g_err_stage := 'Log: No records in c_bc_packets, exit';

888:
889: --If no rows fetched, exit
890: IF l_PktIdTab.count = 0 THEN
891: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
892: pa_debug.g_err_stage := 'Log: No records in c_bc_packets, exit';
893: pa_debug.write_file('LOG',pa_debug.g_err_stage);
894: END IF;
895: pa_funds_control_utils.print_message('No records from c_bc_packets, exit');
896: EXIT;

Line 893: pa_debug.write_file('LOG',pa_debug.g_err_stage);

889: --If no rows fetched, exit
890: IF l_PktIdTab.count = 0 THEN
891: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
892: pa_debug.g_err_stage := 'Log: No records in c_bc_packets, exit';
893: pa_debug.write_file('LOG',pa_debug.g_err_stage);
894: END IF;
895: pa_funds_control_utils.print_message('No records from c_bc_packets, exit');
896: EXIT;
897: END IF;

Line 902: pa_debug.g_err_stage := 'Log: Before update of balances';

898:
899: pa_funds_control_utils.print_message('In c_bc_packets loop');
900:
901: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
902: pa_debug.g_err_stage := 'Log: Before update of balances';
903: pa_debug.write_file('LOG',pa_debug.g_err_stage);
904: END IF;
905:
906: pa_funds_control_utils.print_message('Before update of balances');

Line 903: pa_debug.write_file('LOG',pa_debug.g_err_stage);

899: pa_funds_control_utils.print_message('In c_bc_packets loop');
900:
901: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
902: pa_debug.g_err_stage := 'Log: Before update of balances';
903: pa_debug.write_file('LOG',pa_debug.g_err_stage);
904: END IF;
905:
906: pa_funds_control_utils.print_message('Before update of balances');
907:

Line 940: pa_debug.g_err_stage := 'Log: Updating Balances , Index = '|| i || ' RowCount = ' || SQL%BULK_ROWCOUNT(i) ||' Pkt Id ' || l_PktBcPktTab(i);

936:
937: --Collect no of records updated and store the packet id in another table
938: for i in l_PktIdTab.FIRST..l_PktIdTab.LAST loop
939: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
940: pa_debug.g_err_stage := 'Log: Updating Balances , Index = '|| i || ' RowCount = ' || SQL%BULK_ROWCOUNT(i) ||' Pkt Id ' || l_PktBcPktTab(i);
941: pa_debug.write_file('LOG',pa_debug.g_err_stage);
942: END IF;
943: pa_funds_control_utils.print_message('Updating Balances ' || SQL%BULK_ROWCOUNT(i) ||' Pkt Id ' || l_PktBcPktTab(i));
944:

Line 941: pa_debug.write_file('LOG',pa_debug.g_err_stage);

937: --Collect no of records updated and store the packet id in another table
938: for i in l_PktIdTab.FIRST..l_PktIdTab.LAST loop
939: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
940: pa_debug.g_err_stage := 'Log: Updating Balances , Index = '|| i || ' RowCount = ' || SQL%BULK_ROWCOUNT(i) ||' Pkt Id ' || l_PktBcPktTab(i);
941: pa_debug.write_file('LOG',pa_debug.g_err_stage);
942: END IF;
943: pa_funds_control_utils.print_message('Updating Balances ' || SQL%BULK_ROWCOUNT(i) ||' Pkt Id ' || l_PktBcPktTab(i));
944:
945: --If no. of rec updated not = 0 then place packet id in another table.

Line 952: pa_debug.g_err_stage := 'Log: Num = ' || num || ' Status Pkt Id = ' || l_StsUpdPktIdTab(num) || ' Bc Pkt = ' || l_StsUpdBcPktIdTab(num);

948: num := num + 1;
949: l_StsUpdPktIdTab(num) := l_PktIdTab(i);
950: l_StsUpdBcPktIdTab(num) := l_PktBcPktTab(i);
951: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
952: pa_debug.g_err_stage := 'Log: Num = ' || num || ' Status Pkt Id = ' || l_StsUpdPktIdTab(num) || ' Bc Pkt = ' || l_StsUpdBcPktIdTab(num);
953: pa_debug.write_file('LOG',pa_debug.g_err_stage);
954: END IF;
955: pa_funds_control_utils.print_message('Status Packet Id = ' || l_StsUpdPktIdTab(num)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(num));
956: end if;

Line 953: pa_debug.write_file('LOG',pa_debug.g_err_stage);

949: l_StsUpdPktIdTab(num) := l_PktIdTab(i);
950: l_StsUpdBcPktIdTab(num) := l_PktBcPktTab(i);
951: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
952: pa_debug.g_err_stage := 'Log: Num = ' || num || ' Status Pkt Id = ' || l_StsUpdPktIdTab(num) || ' Bc Pkt = ' || l_StsUpdBcPktIdTab(num);
953: pa_debug.write_file('LOG',pa_debug.g_err_stage);
954: END IF;
955: pa_funds_control_utils.print_message('Status Packet Id = ' || l_StsUpdPktIdTab(num)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(num));
956: end if;
957: end loop;

Line 960: pa_debug.g_err_stage := 'Log: Updated Records = ' || l_StsUpdPktIdTab.count;

956: end if;
957: end loop;
958:
959: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
960: pa_debug.g_err_stage := 'Log: Updated Records = ' || l_StsUpdPktIdTab.count;
961: pa_debug.write_file('LOG',pa_debug.g_err_stage);
962: END IF;
963:
964: --The below loop is only for debugging. Can be removed, if log file is huge.

Line 961: pa_debug.write_file('LOG',pa_debug.g_err_stage);

957: end loop;
958:
959: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
960: pa_debug.g_err_stage := 'Log: Updated Records = ' || l_StsUpdPktIdTab.count;
961: pa_debug.write_file('LOG',pa_debug.g_err_stage);
962: END IF;
963:
964: --The below loop is only for debugging. Can be removed, if log file is huge.
965: if l_StsUpdPktIdTab.count<>0 then

Line 968: pa_debug.g_err_stage := 'Log: No of Status updates = ' || l_StsUpdPktIdTab(i)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(i);

964: --The below loop is only for debugging. Can be removed, if log file is huge.
965: if l_StsUpdPktIdTab.count<>0 then
966: for i in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST loop
967: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
968: pa_debug.g_err_stage := 'Log: No of Status updates = ' || l_StsUpdPktIdTab(i)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(i);
969: pa_debug.write_file('LOG',pa_debug.g_err_stage);
970: END IF;
971: pa_funds_control_utils.print_message('No of Status updates = ' || l_StsUpdPktIdTab(i)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(i));
972: end loop;

Line 969: pa_debug.write_file('LOG',pa_debug.g_err_stage);

965: if l_StsUpdPktIdTab.count<>0 then
966: for i in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST loop
967: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
968: pa_debug.g_err_stage := 'Log: No of Status updates = ' || l_StsUpdPktIdTab(i)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(i);
969: pa_debug.write_file('LOG',pa_debug.g_err_stage);
970: END IF;
971: pa_funds_control_utils.print_message('No of Status updates = ' || l_StsUpdPktIdTab(i)|| ' Bc Pkt = ' || l_StsUpdBcPktIdTab(i));
972: end loop;
973: end if;

Line 976: pa_debug.g_err_stage := 'Log: After Update of balances';

972: end loop;
973: end if;
974:
975: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
976: pa_debug.g_err_stage := 'Log: After Update of balances';
977: pa_debug.write_file('LOG',pa_debug.g_err_stage);
978:
979: pa_debug.g_err_stage := 'Log: Before Insert into commitments';
980: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 977: pa_debug.write_file('LOG',pa_debug.g_err_stage);

973: end if;
974:
975: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
976: pa_debug.g_err_stage := 'Log: After Update of balances';
977: pa_debug.write_file('LOG',pa_debug.g_err_stage);
978:
979: pa_debug.g_err_stage := 'Log: Before Insert into commitments';
980: pa_debug.write_file('LOG',pa_debug.g_err_stage);
981: END IF;

Line 979: pa_debug.g_err_stage := 'Log: Before Insert into commitments';

975: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
976: pa_debug.g_err_stage := 'Log: After Update of balances';
977: pa_debug.write_file('LOG',pa_debug.g_err_stage);
978:
979: pa_debug.g_err_stage := 'Log: Before Insert into commitments';
980: pa_debug.write_file('LOG',pa_debug.g_err_stage);
981: END IF;
982:
983: pa_funds_control_utils.print_message('Inserting Commitments');

Line 980: pa_debug.write_file('LOG',pa_debug.g_err_stage);

976: pa_debug.g_err_stage := 'Log: After Update of balances';
977: pa_debug.write_file('LOG',pa_debug.g_err_stage);
978:
979: pa_debug.g_err_stage := 'Log: Before Insert into commitments';
980: pa_debug.write_file('LOG',pa_debug.g_err_stage);
981: END IF;
982:
983: pa_funds_control_utils.print_message('Inserting Commitments');
984:

Line 1145: pa_debug.g_err_stage := 'Log: No of commitment inserts = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);

1141:
1142: --The below loop is only for debugging. Can be removed, if log file is huge.
1143: for i in l_PktIdTab.first..l_PktIdTab.last loop
1144: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1145: pa_debug.g_err_stage := 'Log: No of commitment inserts = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1146: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1147: END IF;
1148: pa_funds_control_utils.print_message('No. of commitment insert = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1149: end loop;

Line 1146: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1142: --The below loop is only for debugging. Can be removed, if log file is huge.
1143: for i in l_PktIdTab.first..l_PktIdTab.last loop
1144: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1145: pa_debug.g_err_stage := 'Log: No of commitment inserts = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1146: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1147: END IF;
1148: pa_funds_control_utils.print_message('No. of commitment insert = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1149: end loop;
1150:

Line 1152: pa_debug.g_err_stage := 'Log: After Insert into commitments';

1148: pa_funds_control_utils.print_message('No. of commitment insert = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1149: end loop;
1150:
1151: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1152: pa_debug.g_err_stage := 'Log: After Insert into commitments';
1153: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1154:
1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';
1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 1153: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1149: end loop;
1150:
1151: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1152: pa_debug.g_err_stage := 'Log: After Insert into commitments';
1153: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1154:
1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';
1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1157: END IF;

Line 1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';

1151: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1152: pa_debug.g_err_stage := 'Log: After Insert into commitments';
1153: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1154:
1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';
1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1157: END IF;
1158:
1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');

Line 1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1152: pa_debug.g_err_stage := 'Log: After Insert into commitments';
1153: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1154:
1155: pa_debug.g_err_stage := 'Log: Before Update of commitments';
1156: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1157: END IF;
1158:
1159: pa_funds_control_utils.print_message('Before update of pa_bc_commitments_all');
1160:

Line 1226: pa_debug.g_err_stage := 'Log: No of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);

1222:
1223: --The below loop is only for debugging. Can be removed, if log file is huge.
1224: for i in l_PktIdTab.first..l_PktIdTab.last loop
1225: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1226: pa_debug.g_err_stage := 'Log: No of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1227: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1228: END IF;
1229: pa_funds_control_utils.print_message('No. of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1230: end loop;

Line 1227: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1223: --The below loop is only for debugging. Can be removed, if log file is huge.
1224: for i in l_PktIdTab.first..l_PktIdTab.last loop
1225: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1226: pa_debug.g_err_stage := 'Log: No of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1227: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1228: END IF;
1229: pa_funds_control_utils.print_message('No. of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1230: end loop;
1231:

Line 1233: pa_debug.g_err_stage := 'Log: After Update of commitments';

1229: pa_funds_control_utils.print_message('No. of commitment updates = ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1230: end loop;
1231:
1232: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1233: pa_debug.g_err_stage := 'Log: After Update of commitments';
1234: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1235:
1236: pa_debug.g_err_stage := 'Log: Before update status_code, balance_posted_flag in c_bc_packets loop '||l_StsUpdPktIdTab.count;
1237: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 1234: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1230: end loop;
1231:
1232: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1233: pa_debug.g_err_stage := 'Log: After Update of commitments';
1234: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1235:
1236: pa_debug.g_err_stage := 'Log: Before update status_code, balance_posted_flag in c_bc_packets loop '||l_StsUpdPktIdTab.count;
1237: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1238: END IF;

Line 1236: pa_debug.g_err_stage := 'Log: Before update status_code, balance_posted_flag in c_bc_packets loop '||l_StsUpdPktIdTab.count;

1232: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1233: pa_debug.g_err_stage := 'Log: After Update of commitments';
1234: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1235:
1236: pa_debug.g_err_stage := 'Log: Before update status_code, balance_posted_flag in c_bc_packets loop '||l_StsUpdPktIdTab.count;
1237: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1238: END IF;
1239:
1240: pa_funds_control_utils.print_message('Before update of status_code');

Line 1237: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1233: pa_debug.g_err_stage := 'Log: After Update of commitments';
1234: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1235:
1236: pa_debug.g_err_stage := 'Log: Before update status_code, balance_posted_flag in c_bc_packets loop '||l_StsUpdPktIdTab.count;
1237: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1238: END IF;
1239:
1240: pa_funds_control_utils.print_message('Before update of status_code');
1241: pa_funds_control_utils.print_message('No. of status updates in c_bc_packets= '||l_StsUpdPktIdTab.count);

Line 1246: pa_debug.write_file('LOG', 'Pkt FIRST = ' || l_StsUpdPktIdTab.FIRST || ' LAST = '|| l_StsUpdPktIdTab.LAST );

1242:
1243: --Update status_code and balance_posted_flag
1244: IF (l_StsUpdPktIdTab.count <> 0) THEN
1245: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1246: pa_debug.write_file('LOG', 'Pkt FIRST = ' || l_StsUpdPktIdTab.FIRST || ' LAST = '|| l_StsUpdPktIdTab.LAST );
1247: pa_debug.write_file('LOG', 'Bc Pkt FIRST = ' || l_StsUpdBcPktIdTab.FIRST || ' LAST = '|| l_StsUpdBcPktIdTab.LAST );
1248: END IF;
1249: FORALL m in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST
1250: UPDATE pa_bc_packets pbc

Line 1247: pa_debug.write_file('LOG', 'Bc Pkt FIRST = ' || l_StsUpdBcPktIdTab.FIRST || ' LAST = '|| l_StsUpdBcPktIdTab.LAST );

1243: --Update status_code and balance_posted_flag
1244: IF (l_StsUpdPktIdTab.count <> 0) THEN
1245: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1246: pa_debug.write_file('LOG', 'Pkt FIRST = ' || l_StsUpdPktIdTab.FIRST || ' LAST = '|| l_StsUpdPktIdTab.LAST );
1247: pa_debug.write_file('LOG', 'Bc Pkt FIRST = ' || l_StsUpdBcPktIdTab.FIRST || ' LAST = '|| l_StsUpdBcPktIdTab.LAST );
1248: END IF;
1249: FORALL m in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST
1250: UPDATE pa_bc_packets pbc
1251: SET pbc.status_code = 'X',

Line 1268: pa_debug.g_err_stage := 'Log: No of status update ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);

1264: --The below loop is for debugging, can be removed if log file is huge
1265: if (l_StsUpdPktIdTab.count <> 0) then
1266: for i in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST loop
1267: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1268: pa_debug.g_err_stage := 'Log: No of status update ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1269: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1270: END IF;
1271: pa_funds_control_utils.print_message('No of status update ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1272: end loop;

Line 1269: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1265: if (l_StsUpdPktIdTab.count <> 0) then
1266: for i in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST loop
1267: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1268: pa_debug.g_err_stage := 'Log: No of status update ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i);
1269: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1270: END IF;
1271: pa_funds_control_utils.print_message('No of status update ' || SQL%BULK_ROWCOUNT(i)||' Pkt Id ' || l_PktBcPktTab(i));
1272: end loop;
1273: end if;

Line 1276: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_bc_packets loop';

1272: end loop;
1273: end if;
1274:
1275: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1276: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_bc_packets loop';
1277: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1278: END IF;
1279:
1280: --Commit in a batch i.e. 200 rows

Line 1277: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1273: end if;
1274:
1275: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1276: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_bc_packets loop';
1277: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1278: END IF;
1279:
1280: --Commit in a batch i.e. 200 rows
1281: commit;

Line 1291: pa_debug.g_err_stage := 'Log: Open cursor c_ins_packets';

1287: pa_funds_control_utils.print_message('Close c_bc_packets');
1288:
1289: CLOSE c_bc_packets;
1290: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1291: pa_debug.g_err_stage := 'Log: Open cursor c_ins_packets';
1292: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1293: END IF;
1294:
1295: pa_funds_control_utils.print_message('Open cursor c_ins_packets');

Line 1292: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1288:
1289: CLOSE c_bc_packets;
1290: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1291: pa_debug.g_err_stage := 'Log: Open cursor c_ins_packets';
1292: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1293: END IF;
1294:
1295: pa_funds_control_utils.print_message('Open cursor c_ins_packets');
1296:

Line 1309: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';

1305:
1306: l_count := l_count+1;
1307:
1308: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1309: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';
1310: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1311: END IF;
1312:
1313: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);

Line 1310: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1306: l_count := l_count+1;
1307:
1308: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1309: pa_debug.g_err_stage := 'Log: Fetched ' || l_count || ' batch';
1310: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1311: END IF;
1312:
1313: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
1314:

Line 1316: pa_debug.g_err_stage := 'Log: Fetch cursor c_ins_packets';

1312:
1313: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
1314:
1315: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1316: pa_debug.g_err_stage := 'Log: Fetch cursor c_ins_packets';
1317: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1318: END IF;
1319:
1320: pa_funds_control_utils.print_message('Fetch cursor c_ins_packets');

Line 1317: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1313: pa_funds_control_utils.print_message('No of cursor batch fetched = ' || l_count);
1314:
1315: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1316: pa_debug.g_err_stage := 'Log: Fetch cursor c_ins_packets';
1317: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1318: END IF;
1319:
1320: pa_funds_control_utils.print_message('Fetch cursor c_ins_packets');
1321:

Line 1345: pa_debug.g_err_stage := 'Log: No. of records fetched = '||l_InsProjectTab.count;

1341: /*,l_InsOrgIdTab*/
1342: LIMIT rows;
1343:
1344: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1345: pa_debug.g_err_stage := 'Log: No. of records fetched = '||l_InsProjectTab.count;
1346: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1347: END IF;
1348:
1349: pa_funds_control_utils.print_message('No. of records fetched = ' || l_InsProjectTab.count);

Line 1346: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1342: LIMIT rows;
1343:
1344: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1345: pa_debug.g_err_stage := 'Log: No. of records fetched = '||l_InsProjectTab.count;
1346: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1347: END IF;
1348:
1349: pa_funds_control_utils.print_message('No. of records fetched = ' || l_InsProjectTab.count);
1350:

Line 1354: pa_debug.g_err_stage := 'Log: No records from cursor c_ins_packets, exit';

1350:
1351: --If no. of records fetched = 0 then exit
1352: IF l_InsProjectTab.count = 0 THEN
1353: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1354: pa_debug.g_err_stage := 'Log: No records from cursor c_ins_packets, exit';
1355: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1356: END IF;
1357: pa_funds_control_utils.print_message('No records from cursor c_ins_packets, exit');
1358: EXIT;

Line 1355: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1351: --If no. of records fetched = 0 then exit
1352: IF l_InsProjectTab.count = 0 THEN
1353: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1354: pa_debug.g_err_stage := 'Log: No records from cursor c_ins_packets, exit';
1355: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1356: END IF;
1357: pa_funds_control_utils.print_message('No records from cursor c_ins_packets, exit');
1358: EXIT;
1359: END IF;

Line 1362: pa_debug.g_err_stage := 'Log: Before inserting balances';

1358: EXIT;
1359: END IF;
1360:
1361: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1362: pa_debug.g_err_stage := 'Log: Before inserting balances';
1363: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1364: END IF;
1365:
1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');

Line 1363: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1359: END IF;
1360:
1361: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1362: pa_debug.g_err_stage := 'Log: Before inserting balances';
1363: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1364: END IF;
1365:
1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1367:

Line 1422: pa_debug.g_err_stage := 'Log: After inserting balances';

1418: sysdate
1419: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1420:
1421: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1422: pa_debug.g_err_stage := 'Log: After inserting balances';
1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1424:
1425: pa_debug.g_err_stage := 'Log: Before update status_code and balance_posted_flag in c_ins_packets';
1426: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1419: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1420:
1421: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1422: pa_debug.g_err_stage := 'Log: After inserting balances';
1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1424:
1425: pa_debug.g_err_stage := 'Log: Before update status_code and balance_posted_flag in c_ins_packets';
1426: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1427: END IF;

Line 1425: pa_debug.g_err_stage := 'Log: Before update status_code and balance_posted_flag in c_ins_packets';

1421: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1422: pa_debug.g_err_stage := 'Log: After inserting balances';
1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1424:
1425: pa_debug.g_err_stage := 'Log: Before update status_code and balance_posted_flag in c_ins_packets';
1426: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1427: END IF;
1428:
1429: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');

Line 1426: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1422: pa_debug.g_err_stage := 'Log: After inserting balances';
1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1424:
1425: pa_debug.g_err_stage := 'Log: Before update status_code and balance_posted_flag in c_ins_packets';
1426: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1427: END IF;
1428:
1429: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');
1430:

Line 1449: pa_debug.g_err_stage := 'Log: No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i);

1445:
1446: --Below loop for debugging, can be removed if log file is huge
1447: for i in l_InsProjectTab.first..l_InsProjectTab.last loop
1448: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1449: pa_debug.g_err_stage := 'Log: No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i);
1450: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1451: END IF;
1452: pa_funds_control_utils.print_message('No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i));
1453: end loop;

Line 1450: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1446: --Below loop for debugging, can be removed if log file is huge
1447: for i in l_InsProjectTab.first..l_InsProjectTab.last loop
1448: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1449: pa_debug.g_err_stage := 'Log: No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i);
1450: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1451: END IF;
1452: pa_funds_control_utils.print_message('No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i));
1453: end loop;
1454:

Line 1456: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_ins_packets loop';

1452: pa_funds_control_utils.print_message('No. of status update in c_ins_packets = ' || SQL%BULK_ROWCOUNT(i));
1453: end loop;
1454:
1455: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1456: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_ins_packets loop';
1457: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1458: END IF;
1459:
1460: --Commit in a batch, i.e. 200 rows

Line 1457: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1453: end loop;
1454:
1455: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1456: pa_debug.g_err_stage := 'Log: After Update of status_code and balance_posted_flag in c_ins_packets loop';
1457: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1458: END IF;
1459:
1460: --Commit in a batch, i.e. 200 rows
1461: commit;

Line 1470: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN

1466: --Close c_ins_packets cursor
1467: CLOSE c_ins_packets;
1468:
1469: --Release lock on project
1470: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN
1471: pa_funds_control_utils.print_message('Releasing lock for '|| l_project_id);
1472: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1473: pa_debug.g_err_stage := 'Log: Finished processing, release lock on Project = ' || to_char(l_project_id);
1474: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 1473: pa_debug.g_err_stage := 'Log: Finished processing, release lock on Project = ' || to_char(l_project_id);

1469: --Release lock on project
1470: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN
1471: pa_funds_control_utils.print_message('Releasing lock for '|| l_project_id);
1472: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1473: pa_debug.g_err_stage := 'Log: Finished processing, release lock on Project = ' || to_char(l_project_id);
1474: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1475: END IF;
1476: null;
1477: END IF;

Line 1474: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1470: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN
1471: pa_funds_control_utils.print_message('Releasing lock for '|| l_project_id);
1472: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1473: pa_debug.g_err_stage := 'Log: Finished processing, release lock on Project = ' || to_char(l_project_id);
1474: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1475: END IF;
1476: null;
1477: END IF;
1478:

Line 1482: pa_debug.g_err_stage := 'Log: Could not acquire lock for Project = '||to_char(l_project_id);

1478:
1479: ELSE
1480: --Unable to acquire user lock
1481: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1482: pa_debug.g_err_stage := 'Log: Could not acquire lock for Project = '||to_char(l_project_id);
1483: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1484: END IF;
1485: END IF;
1486:

Line 1483: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1479: ELSE
1480: --Unable to acquire user lock
1481: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1482: pa_debug.g_err_stage := 'Log: Could not acquire lock for Project = '||to_char(l_project_id);
1483: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1484: END IF;
1485: END IF;
1486:
1487: END LOOP;

Line 1490: pa_debug.g_err_stage := '*******************************************************';

1486:
1487: END LOOP;
1488:
1489: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1490: pa_debug.g_err_stage := '*******************************************************';
1491: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1492:
1493: pa_debug.g_err_stage := 'Log: End of Update_Act_Enc_Balance';
1494: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 1491: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1487: END LOOP;
1488:
1489: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1490: pa_debug.g_err_stage := '*******************************************************';
1491: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1492:
1493: pa_debug.g_err_stage := 'Log: End of Update_Act_Enc_Balance';
1494: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1495: END IF;

Line 1493: pa_debug.g_err_stage := 'Log: End of Update_Act_Enc_Balance';

1489: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1490: pa_debug.g_err_stage := '*******************************************************';
1491: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1492:
1493: pa_debug.g_err_stage := 'Log: End of Update_Act_Enc_Balance';
1494: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1495: END IF;
1496:
1497: pa_fck_util.debug_msg('PB:Exiting Sweeper');

Line 1494: pa_debug.write_file('LOG',pa_debug.g_err_stage);

1490: pa_debug.g_err_stage := '*******************************************************';
1491: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1492:
1493: pa_debug.g_err_stage := 'Log: End of Update_Act_Enc_Balance';
1494: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1495: END IF;
1496:
1497: pa_fck_util.debug_msg('PB:Exiting Sweeper');
1498:

Line 1500: PA_DEBUG.Reset_Err_Stack;

1496:
1497: pa_fck_util.debug_msg('PB:Exiting Sweeper');
1498:
1499: --Reset the error stack when returning to the calling program
1500: PA_DEBUG.Reset_Err_Stack;
1501:
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: --Since release_user_lock always issues a commit, do a

Line 1511: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1507:
1508: x_return_status := fnd_api.g_ret_sts_unexp_error;
1509:
1510: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SWEEPER'
1511: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1512:
1513: x_error_message_code := (SQLCODE||' '||SQLERRM);
1514:
1515: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN

Line 1515: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN

1511: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1512:
1513: x_error_message_code := (SQLCODE||' '||SQLERRM);
1514:
1515: IF (pa_debug.release_user_lock('SWEEPLOCK:'||to_char(l_project_id)) = 0) THEN
1516: pa_funds_control_utils.print_message('In others Releasing lock for proj '|| l_project_id);
1517: null;
1518: END IF;
1519: