APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_EXT_AWT_UTIL

Line 469: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Do_Withholding');

465: 'Jl_Ar_Ap_Do_Withholding';
466:
467: -- Debug
468: IF (DEBUG_Var = 'Y') THEN
469: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Do_Withholding');
470: END IF;
471: -- End Debug
472:
473: -----------------------------------

Line 493: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);

489: IF (P_Calling_Module = 'QUICKCHECK') THEN
490: l_debug_info := 'Calculating Withholding for Quick Payment';
491: -- Debug Information
492: IF (DEBUG_Var = 'Y') THEN
493: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);
494: END IF;
495: -- End Debug
496: Do_AWT_Quick_Payment (P_Checkrun_Name,
497: P_Checkrun_ID,

Line 511: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Calculating Withholding for Quick Payment');

507: P_Request_Id);
508:
509: -- Debug Information
510: IF (DEBUG_Var = 'Y') THEN
511: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Calculating Withholding for Quick Payment');
512: END IF;
513: -- End Debug
514: -------------------------------------------------------
515: -- If the calculation did not complete successfully,

Line 538: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);

534: ELSIF (P_Calling_Module = 'AUTOSELECT') THEN
535: l_debug_info := 'Calculating Withholding for Payment Batch (Build)';
536: -- Debug Information
537: IF (DEBUG_Var = 'Y') THEN
538: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);
539: END IF;
540: -- End Debug
541: Do_AWT_Build_Payment_Batch
542: (P_Checkrun_Name,

Line 555: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Calculating Withholding for Payment Batch (Build)');

551: P_Request_Id);
552:
553: -- Debug Information
554: IF (DEBUG_Var = 'Y') THEN
555: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Calculating Withholding for Payment Batch (Build)');
556: END IF;
557: -- End Debug
558:
559: /********************************************************

Line 573: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);

569: ELSIF (P_Calling_Module = 'CONFIRM') THEN
570: l_debug_info := 'Calculating Withholding for Payment Batch (Confirm)';
571: -- Debug Information
572: IF (DEBUG_Var = 'Y') THEN
573: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);
574: END IF;
575: -- End Debug
576: Do_AWT_Confirm_Payment_Batch
577: (P_Checkrun_Name,

Line 589: JL_ZZ_AP_EXT_AWT_UTIL.Debug

585: P_Program_Id,
586: P_Request_Id);
587: -- Debug Information
588: IF (DEBUG_Var = 'Y') THEN
589: JL_ZZ_AP_EXT_AWT_UTIL.Debug
590: ('P_AWT_Success: '||P_AWT_Success);
591: JL_ZZ_AP_EXT_AWT_UTIL.Debug
592: ('After Calculating Withholding for Payment Batch (Confirm)');
593: END IF;

Line 591: JL_ZZ_AP_EXT_AWT_UTIL.Debug

587: -- Debug Information
588: IF (DEBUG_Var = 'Y') THEN
589: JL_ZZ_AP_EXT_AWT_UTIL.Debug
590: ('P_AWT_Success: '||P_AWT_Success);
591: JL_ZZ_AP_EXT_AWT_UTIL.Debug
592: ('After Calculating Withholding for Payment Batch (Confirm)');
593: END IF;
594: -- End Debug
595: END IF;

Line 602: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Do_Withholding - Error:'||SQLERRM);

598: WHEN others THEN
599: IF (SQLCODE <> -20001) THEN
600: -- Debug Information
601: IF (DEBUG_Var = 'Y') THEN
602: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Do_Withholding - Error:'||SQLERRM);
603: END IF;
604: -- End Debug
605:
606: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

Line 670: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Withholding');

666: l_calling_sequence := 'JL_AR_AP_WITHHOLDING_PKG' || '.' ||
667: 'Jl_Ar_Ap_Undo_Withholding';
668: -- Debug Information
669: IF (DEBUG_Var = 'Y') THEN
670: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Withholding');
671: END IF;
672: -- End Debug
673:
674: -----------------------------------------------------

Line 703: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Undo Credit Letter');

699: -- Reverses credit letter amounts
700: ----------------------------------
701: -- Debug Information
702: IF (DEBUG_Var = 'Y') THEN
703: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Undo Credit Letter');
704: END IF;
705: -- End Debug
706:
707: Undo_Credit_Letter (l_check_id,

Line 720: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Undo Credit Letter');

716: P_Request_Id);
717:
718: -- Debug Information
719: IF (DEBUG_Var = 'Y') THEN
720: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Undo Credit Letter');
721: END IF;
722: -- End Debug
723: ----------------------------------
724: -- Voids Withholding Certificates

Line 728: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Calling Jl_Ar_Ap_Void_Certificates');

724: -- Voids Withholding Certificates
725: ----------------------------------
726: -- Debug Information
727: IF (DEBUG_Var = 'Y') THEN
728: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Calling Jl_Ar_Ap_Void_Certificates');
729: END IF;
730: -- End Debug
731:
732: Jl_Ar_Ap_Awt_Reports_Pkg.Jl_Ar_Ap_Void_Certificates (l_payment_id,

Line 736: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Jl_Ar_Ap_Void_Certificates');

732: Jl_Ar_Ap_Awt_Reports_Pkg.Jl_Ar_Ap_Void_Certificates (l_payment_id,
733: l_calling_sequence);
734: -- Debug Information
735: IF (DEBUG_Var = 'Y') THEN
736: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Jl_Ar_Ap_Void_Certificates');
737: END IF;
738: -- End Debug
739: -----------------------------------------------
740: -- Reverse Exemption_Amount (Global Attribute5)

Line 750: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Reverse Exemption Complete');

746: and nvl(to_number(Global_Attribute5),0) > 0;
747:
748: -- Debug Information
749: IF (DEBUG_Var = 'Y') THEN
750: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Reverse Exemption Complete');
751: END IF;
752: -- End Debug
753:
754:

Line 759: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - No data Found');

755: EXCEPTION
756: When NO_DATA_FOUND THEN
757: -- Debug Information
758: IF (DEBUG_Var = 'Y') THEN
759: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - No data Found');
760: END IF;
761: WHEN others THEN
762: IF (SQLCODE <> -20001) THEN
763:

Line 766: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - Error:'||SQLERRM);

762: IF (SQLCODE <> -20001) THEN
763:
764: -- Debug Information
765: IF (DEBUG_Var = 'Y') THEN
766: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - Error:'||SQLERRM);
767: END IF;
768: -- End Debug
769: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
770: Fnd_Message.Set_Token('ERROR', SQLERRM);

Line 822: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

818: l_calling_sequence := 'JL_AR_AP_WITHHOLDING_PKG' || '.' ||
819: 'JL_AR_AP_VOID_SELEC_CERTIF<--' || P_Calling_Sequence;
820: -- Debug Information
821: IF (DEBUG_Var = 'Y') THEN
822: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
823: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - JL_AR_AP_VOID_SELEC_CERTIF');
824: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_checkrun_name='||p_checkrun_Name);
825: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_selected_check_id='||to_char(p_selected_check_id));
826: END IF;

Line 823: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - JL_AR_AP_VOID_SELEC_CERTIF');

819: 'JL_AR_AP_VOID_SELEC_CERTIF<--' || P_Calling_Sequence;
820: -- Debug Information
821: IF (DEBUG_Var = 'Y') THEN
822: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
823: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - JL_AR_AP_VOID_SELEC_CERTIF');
824: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_checkrun_name='||p_checkrun_Name);
825: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_selected_check_id='||to_char(p_selected_check_id));
826: END IF;
827: -- End Debug

Line 824: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_checkrun_name='||p_checkrun_Name);

820: -- Debug Information
821: IF (DEBUG_Var = 'Y') THEN
822: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
823: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - JL_AR_AP_VOID_SELEC_CERTIF');
824: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_checkrun_name='||p_checkrun_Name);
825: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_selected_check_id='||to_char(p_selected_check_id));
826: END IF;
827: -- End Debug
828:

Line 825: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_selected_check_id='||to_char(p_selected_check_id));

821: IF (DEBUG_Var = 'Y') THEN
822: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
823: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - JL_AR_AP_VOID_SELEC_CERTIF');
824: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_checkrun_name='||p_checkrun_Name);
825: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_selected_check_id='||to_char(p_selected_check_id));
826: END IF;
827: -- End Debug
828:
829: UPDATE jl_ar_ap_awt_certif

Line 848: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - JL_AR_AP_VOID_SELEC_CERTIF - Error:'||SQLERRM);

844: WHEN others THEN
845: IF (SQLCODE <> -20001) THEN
846: -- Debug Information
847: IF (DEBUG_Var = 'Y') THEN
848: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - JL_AR_AP_VOID_SELEC_CERTIF - Error:'||SQLERRM);
849: END IF;
850: -- End Debug
851: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
852: Fnd_Message.Set_Token('ERROR', SQLERRM);

Line 918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

914: l_calling_sequence := 'JL_AR_AP_WITHHOLDING_PKG' || '.' ||
915: 'Jl_Ar_Ap_Undo_Temp_Withholding';
916: -- Debug Information
917: IF (DEBUG_Var = 'Y') THEN
918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));

Line 919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');

915: 'Jl_Ar_Ap_Undo_Temp_Withholding';
916: -- Debug Information
917: IF (DEBUG_Var = 'Y') THEN
918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));
923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);

Line 920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);

916: -- Debug Information
917: IF (DEBUG_Var = 'Y') THEN
918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));
923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
924: END IF;

Line 921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));

917: IF (DEBUG_Var = 'Y') THEN
918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));
923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
924: END IF;
925: -- End Debug

Line 922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));

918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));
923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
924: END IF;
925: -- End Debug
926:

Line 923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);

919: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Procedure - Jl_Ar_Ap_Undo_Temp_Withholding');
920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
921: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Invoice_Id = '||to_char(P_Invoice_Id));
922: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Payment_Num = '||to_char(P_Payment_Num));
923: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
924: END IF;
925: -- End Debug
926:
927: ----------------------------------

Line 963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calling JL_AR_AP_VOID_SELEC_CERTIF');

959: -- Voids Withholding Certificates
960: ----------------------------------
961: -- Debug Information
962: IF (DEBUG_Var = 'Y') THEN
963: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Calling JL_AR_AP_VOID_SELEC_CERTIF');
964: END IF;
965: -- End Debug
966:
967:

Line 975: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called JL_AR_AP_VOID_SELEC_CERTIF');

971: l_calling_sequence);
972:
973: -- Debug Information
974: IF (DEBUG_Var = 'Y') THEN
975: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called JL_AR_AP_VOID_SELEC_CERTIF');
976: END IF;
977: -- End Debug
978: end if;
979: */

Line 1061: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Jl_Ar_Ap_certificates');

1057: 'Jl_Ar_Ap_Gen_Certificates';
1058:
1059: -- Debug Information
1060: IF (DEBUG_Var = 'Y') THEN
1061: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Jl_Ar_Ap_certificates');
1062: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_payment_instruction_id = '||p_payment_instruction_id);
1063: END IF;
1064: -- End Debug
1065:

Line 1062: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_payment_instruction_id = '||p_payment_instruction_id);

1058:
1059: -- Debug Information
1060: IF (DEBUG_Var = 'Y') THEN
1061: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Jl_Ar_Ap_certificates');
1062: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: p_payment_instruction_id = '||p_payment_instruction_id);
1063: END IF;
1064: -- End Debug
1065:
1066:

Line 1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);

1069: ------------------------------
1070: l_debug_info := 'Generating Withholding Certificates';
1071: -- Debug Information
1072: IF (DEBUG_Var = 'Y') THEN
1073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (l_debug_info);
1074: END IF;
1075: -- End Debug
1076:
1077: IF p_CALLING_MODULE = 'GENERATE' THEN

Line 1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Generating Withholding Certificates');

1109: END IF;
1110:
1111: -- Debug Information
1112: IF (DEBUG_Var = 'Y') THEN
1113: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Generating Withholding Certificates');
1114: END IF;
1115: -- End Debug
1116: IF l_status then
1117: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1212: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Quick_Payment');

1208: 'Do_AWT_Quick_Payment<--' || P_Calling_Sequence;
1209:
1210: -- Debug Information
1211: IF (DEBUG_Var = 'Y') THEN
1212: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Quick_Payment');
1213: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1214: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Check_Id = '||P_Check_Id);
1215: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
1216: END IF;

Line 1213: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);

1209:
1210: -- Debug Information
1211: IF (DEBUG_Var = 'Y') THEN
1212: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Quick_Payment');
1213: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1214: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Check_Id = '||P_Check_Id);
1215: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
1216: END IF;
1217: -- End Debug

Line 1214: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Check_Id = '||P_Check_Id);

1210: -- Debug Information
1211: IF (DEBUG_Var = 'Y') THEN
1212: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Quick_Payment');
1213: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1214: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Check_Id = '||P_Check_Id);
1215: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
1216: END IF;
1217: -- End Debug
1218:

Line 1215: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);

1211: IF (DEBUG_Var = 'Y') THEN
1212: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Quick_Payment');
1213: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1214: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Check_Id = '||P_Check_Id);
1215: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module = '||P_Calling_Module);
1216: END IF;
1217: -- End Debug
1218:
1219: -----------------------------------

Line 1235: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Getting Payment Type Flag - '||l_payment_type);

1231: where check_id = P_Check_id;
1232:
1233: -- Debug Information
1234: IF (DEBUG_Var = 'Y') THEN
1235: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Getting Payment Type Flag - '||l_payment_type);
1236: END IF;
1237: -- End Debug
1238:
1239:

Line 1249: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');

1245: -- Gets Withholding Options
1246: ----------------------------
1247: -- Debug Information
1248: IF (DEBUG_Var = 'Y') THEN
1249: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1250: END IF;
1251: -- End Debug
1252:
1253: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

Line 1269: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_AWT_Amounts');

1265: SAVEPOINT Before_Calc_Withholding;
1266:
1267: -- Debug Information
1268: IF (DEBUG_Var = 'Y') THEN
1269: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_AWT_Amounts');
1270: END IF;
1271: -- End Debug
1272:
1273: Calculate_AWT_Amounts (P_Checkrun_Name,

Line 1289: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Calculate_AWT_Amounts');

1285: P_Request_Id);
1286:
1287: -- Debug Information
1288: IF (DEBUG_Var = 'Y') THEN
1289: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Calculate_AWT_Amounts');
1290: END IF;
1291: -- End Debug
1292: --------------------------------------------------------
1293: -- Checks whether the calculation finishes successfully

Line 1314: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('IF (NOT Partial_Payment_Paid_In_Full) - Function');

1310: -- l_payment_amount)) THEN Bug# 2807464
1311:
1312: -- Debug Information
1313: IF (DEBUG_Var = 'Y') THEN
1314: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('IF (NOT Partial_Payment_Paid_In_Full) - Function');
1315: END IF;
1316: -- End Debug
1317:
1318: ROLLBACK TO Before_Calc_Withholding;

Line 1329: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping thru the cursor c_invoice_payment');

1325: OPEN c_invoice_payment(P_Check_Id);
1326:
1327: -- Debug Information
1328: IF (DEBUG_Var = 'Y') THEN
1329: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping thru the cursor c_invoice_payment');
1330: END IF;
1331: -- End Debug
1332:
1333: LOOP

Line 1341: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id'||to_char(l_invoice_id));

1337: EXIT WHEN c_invoice_payment%NOTFOUND;
1338:
1339: -- Debug Information
1340: IF (DEBUG_Var = 'Y') THEN
1341: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id'||to_char(l_invoice_id));
1342: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_inv_curr_code'||l_inv_curr_code);
1343: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num'||to_char(l_payment_num));
1344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');
1345: END IF;

Line 1342: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_inv_curr_code'||l_inv_curr_code);

1338:
1339: -- Debug Information
1340: IF (DEBUG_Var = 'Y') THEN
1341: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id'||to_char(l_invoice_id));
1342: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_inv_curr_code'||l_inv_curr_code);
1343: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num'||to_char(l_payment_num));
1344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');
1345: END IF;
1346: -- End Debug

Line 1343: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num'||to_char(l_payment_num));

1339: -- Debug Information
1340: IF (DEBUG_Var = 'Y') THEN
1341: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id'||to_char(l_invoice_id));
1342: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_inv_curr_code'||l_inv_curr_code);
1343: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num'||to_char(l_payment_num));
1344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');
1345: END IF;
1346: -- End Debug
1347:

Line 1344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');

1340: IF (DEBUG_Var = 'Y') THEN
1341: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id'||to_char(l_invoice_id));
1342: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_inv_curr_code'||l_inv_curr_code);
1343: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num'||to_char(l_payment_num));
1344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');
1345: END IF;
1346: -- End Debug
1347:
1348: -----------------------------------------

Line 1367: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Ap_Withholding_Pkg.Create_AWT_Distributions');

1363: l_calling_sequence);
1364:
1365: -- Debug Information
1366: IF (DEBUG_Var = 'Y') THEN
1367: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Ap_Withholding_Pkg.Create_AWT_Distributions');
1368: END IF;
1369: -- End Debug
1370:
1371:

Line 1380: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Invoices');

1376: IF (l_create_invoices = 'PAYMENT') THEN
1377:
1378: -- Debug Information
1379: IF (DEBUG_Var = 'Y') THEN
1380: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Invoices');
1381: END IF;
1382: -- End Debug
1383:
1384: Ap_Withholding_Pkg.Create_AWT_Invoices

Line 1397: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Ap_Withholding_Pkg.Create_AWT_Invoices');

1393: P_Calling_Module);
1394:
1395: -- Debug Information
1396: IF (DEBUG_Var = 'Y') THEN
1397: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Ap_Withholding_Pkg.Create_AWT_Invoices');
1398: END IF;
1399: -- End Debug
1400:
1401:

Line 1408: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close c_invoice_payment');

1404: END LOOP;
1405:
1406: -- Debug Information
1407: IF (DEBUG_Var = 'Y') THEN
1408: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close c_invoice_payment');
1409: END IF;
1410: -- End Debug
1411:
1412: CLOSE c_invoice_payment;

Line 1420: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Update_Quick_Payment');

1416: -- Quick Payment
1417: ---------------------------------------------
1418: -- Debug Information
1419: IF (DEBUG_Var = 'Y') THEN
1420: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Update_Quick_Payment');
1421: END IF;
1422: -- End Debug
1423:
1424: Update_Quick_Payment (P_Check_Id,

Line 1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

1511: 'Do_AWT_Build_Payment_Batch<--' || P_Calling_Sequence;
1512:
1513: -- Debug Information
1514: IF (DEBUG_Var = 'Y') THEN
1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');
1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);
1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));
1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);

Line 1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');

1512:
1513: -- Debug Information
1514: IF (DEBUG_Var = 'Y') THEN
1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');
1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);
1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));
1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);
1520: END IF;

Line 1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);

1513: -- Debug Information
1514: IF (DEBUG_Var = 'Y') THEN
1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');
1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);
1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));
1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);
1520: END IF;
1521: -- End Debug

Line 1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));

1514: IF (DEBUG_Var = 'Y') THEN
1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');
1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);
1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));
1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);
1520: END IF;
1521: -- End Debug
1522:

Line 1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);

1515: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
1516: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE - Do_AWT_Build_Payment_Batch');
1517: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name '||P_Checkrun_Name);
1518: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_ID '||to_number(P_Checkrun_ID));
1519: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Calling_Module '||P_Calling_Module);
1520: END IF;
1521: -- End Debug
1522:
1523: -----------------------------------

Line 1534: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');

1530: ----------------------------
1531:
1532: -- Debug Information
1533: IF (DEBUG_Var = 'Y') THEN
1534: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1535: END IF;
1536: -- End Debug
1537:
1538: Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

Line 1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Withh Options: create_dist and create_invoices: '||l_create_distr||', '||l_create_invoices);

1539: l_create_invoices);
1540:
1541: -- Debug Information
1542: IF (DEBUG_Var = 'Y') THEN
1543: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Withh Options: create_dist and create_invoices: '||l_create_distr||', '||l_create_invoices);
1544: END IF;
1545: -- End Debug
1546:
1547: IF (l_create_distr <> 'PAYMENT') THEN

Line 1576: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping thru c_selected_checks');

1572: OPEN c_selected_checks (P_Checkrun_Name);
1573:
1574: -- Debug Information
1575: IF (DEBUG_Var = 'Y') THEN
1576: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping thru c_selected_checks');
1577: END IF;
1578: -- End Debug
1579:
1580: LOOP

Line 1592: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_AWT_Amounts');

1588: SAVEPOINT Before_Calc_Withholding;
1589:
1590: -- Debug Information
1591: IF (DEBUG_Var = 'Y') THEN
1592: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_AWT_Amounts');
1593: END IF;
1594: -- End Debug
1595:
1596: Calculate_AWT_Amounts (P_Checkrun_Name,

Line 1612: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Calculate_AWT_Amounts');

1608: P_Request_Id);
1609:
1610: -- Debug Information
1611: IF (DEBUG_Var = 'Y') THEN
1612: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('After Called Calculate_AWT_Amounts');
1613: END IF;
1614: -- End Debug
1615:
1616: --------------------------------------------------------

Line 1622: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Reject_Payment_Batch - P_AWT_Success <> AWT_SUCCESS ');

1618: --------------------------------------------------------
1619: IF (P_AWT_Success <> AWT_SUCCESS) THEN
1620: -- Debug Information
1621: IF (DEBUG_Var = 'Y') THEN
1622: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Reject_Payment_Batch - P_AWT_Success <> AWT_SUCCESS ');
1623: END IF;
1624: -- End Debug
1625:
1626: Reject_Payment_Batch (rec_selected_checks.payment_id,

Line 1646: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling - NOT Partial_Payment_Paid_In_Full');

1642: -- AND l_payment_amount > 0 THEN --- Bug 2157401 Bug# 2807464
1643:
1644: -- Debug Information
1645: IF (DEBUG_Var = 'Y') THEN
1646: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling - NOT Partial_Payment_Paid_In_Full');
1647: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ROLLBACK TO Before_Calc_Withholding');
1648: END IF;
1649: -- End Debug
1650:

Line 1647: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ROLLBACK TO Before_Calc_Withholding');

1643:
1644: -- Debug Information
1645: IF (DEBUG_Var = 'Y') THEN
1646: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling - NOT Partial_Payment_Paid_In_Full');
1647: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ROLLBACK TO Before_Calc_Withholding');
1648: END IF;
1649: -- End Debug
1650:
1651: ROLLBACK TO Before_Calc_Withholding;

Line 1659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Reject_Payment_Batch - NOT Pay_in_Full');

1655: P_AWT_Success := Fnd_Message.Get;
1656:
1657: -- Debug Information
1658: IF (DEBUG_Var = 'Y') THEN
1659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Reject_Payment_Batch - NOT Pay_in_Full');
1660: END IF;
1661: -- End Debug
1662:
1663: Reject_Payment_Batch (rec_selected_checks.payment_id,

Line 1675: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Payment_Batch');

1671: ELSE
1672:
1673: -- Debug Information
1674: IF (DEBUG_Var = 'Y') THEN
1675: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Payment_Batch');
1676: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: rec_selected_checks.selected_check_id = '||
1678: to_char(rec_selected_checks.payment_id));
1679: END IF;

Line 1676: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);

1672:
1673: -- Debug Information
1674: IF (DEBUG_Var = 'Y') THEN
1675: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Payment_Batch');
1676: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: rec_selected_checks.selected_check_id = '||
1678: to_char(rec_selected_checks.payment_id));
1679: END IF;
1680: -- End Debug

Line 1677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: rec_selected_checks.selected_check_id = '||

1673: -- Debug Information
1674: IF (DEBUG_Var = 'Y') THEN
1675: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Payment_Batch');
1676: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: P_Checkrun_Name = '||P_Checkrun_Name);
1677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter: rec_selected_checks.selected_check_id = '||
1678: to_char(rec_selected_checks.payment_id));
1679: END IF;
1680: -- End Debug
1681:

Line 1693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Close Cursor c_selected_checks');

1689: END LOOP;
1690:
1691: -- Debug Information
1692: IF (DEBUG_Var = 'Y') THEN
1693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Close Cursor c_selected_checks');
1694: END IF;
1695: -- End Debug
1696:
1697: CLOSE c_selected_checks;

Line 1701: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_AWT_Success ='||P_AWT_Success);

1697: CLOSE c_selected_checks;
1698:
1699: -- Debug Information
1700: IF (DEBUG_Var = 'Y') THEN
1701: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' P_AWT_Success ='||P_AWT_Success);
1702: END IF;
1703: -- End Debug
1704:
1705: P_AWT_Success := AWT_SUCCESS;

Line 1711: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Error Do_AWT_Build_Payment_Batch= '||SQLERRM);

1707: EXCEPTION
1708: WHEN others THEN
1709: -- Debug Information
1710: IF (DEBUG_Var = 'Y') THEN
1711: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Error Do_AWT_Build_Payment_Batch= '||SQLERRM);
1712: END IF;
1713: -- End Debug
1714:
1715: IF (SQLCODE <> -20001) THEN

Line 1822: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Do_AWT_Confirm_Payment_Batch'||

1818: P_Calling_Sequence;
1819:
1820: -- Debug Information
1821: IF (DEBUG_Var = 'Y') THEN
1822: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Do_AWT_Confirm_Payment_Batch'||
1823: 'Parameter: P_Checkrun_Name = '||P_Checkrun_Name||
1824: 'Parameter: P_Calling_Module = '||P_Calling_Module||
1825: 'Parameter: P_Calling_Sequence = '||P_Calling_Sequence||
1826: 'Parameter: P_Checkrun_ID = '||to_char(P_Checkrun_ID));

Line 1842: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping Thru c_selected_invoices');

1838: OPEN c_selected_invoices (P_Checkrun_ID);
1839:
1840: -- Debug Information
1841: IF (DEBUG_Var = 'Y') THEN
1842: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Looping Thru c_selected_invoices');
1843: END IF;
1844: -- End Debug
1845:
1846: LOOP

Line 1852: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1848: EXIT WHEN c_selected_invoices%NOTFOUND;
1849:
1850: -- Debug Information
1851: IF (DEBUG_Var = 'Y') THEN
1852: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1853: (' Fetched Values: rec_sel_inv.invoice_id: '||to_char(rec_sel_inv.invoice_id));
1854: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1855: (' Fetched Values: rec_sel_inv.payment_num: '||to_char(rec_sel_inv.payment_num));
1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug

Line 1854: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1850: -- Debug Information
1851: IF (DEBUG_Var = 'Y') THEN
1852: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1853: (' Fetched Values: rec_sel_inv.invoice_id: '||to_char(rec_sel_inv.invoice_id));
1854: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1855: (' Fetched Values: rec_sel_inv.payment_num: '||to_char(rec_sel_inv.payment_num));
1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1857: (' Fetched Values: rec_sel_inv.invoice_curr_code: '||rec_sel_inv.invoice_curr_code);
1858: JL_ZZ_AP_EXT_AWT_UTIL.Debug

Line 1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1852: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1853: (' Fetched Values: rec_sel_inv.invoice_id: '||to_char(rec_sel_inv.invoice_id));
1854: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1855: (' Fetched Values: rec_sel_inv.payment_num: '||to_char(rec_sel_inv.payment_num));
1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1857: (' Fetched Values: rec_sel_inv.invoice_curr_code: '||rec_sel_inv.invoice_curr_code);
1858: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1859: (' Fetched Values: rec_sel_inv.payment_date: '||rec_sel_inv.payment_date);
1860: JL_ZZ_AP_EXT_AWT_UTIL.Debug

Line 1858: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1854: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1855: (' Fetched Values: rec_sel_inv.payment_num: '||to_char(rec_sel_inv.payment_num));
1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1857: (' Fetched Values: rec_sel_inv.invoice_curr_code: '||rec_sel_inv.invoice_curr_code);
1858: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1859: (' Fetched Values: rec_sel_inv.payment_date: '||rec_sel_inv.payment_date);
1860: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1861: (' Fetched Values: rec_sel_inv.org_id: '||to_char(rec_sel_inv.org_id));
1862: END IF;

Line 1860: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1856: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1857: (' Fetched Values: rec_sel_inv.invoice_curr_code: '||rec_sel_inv.invoice_curr_code);
1858: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1859: (' Fetched Values: rec_sel_inv.payment_date: '||rec_sel_inv.payment_date);
1860: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1861: (' Fetched Values: rec_sel_inv.org_id: '||to_char(rec_sel_inv.org_id));
1862: END IF;
1863: -- End Debug
1864:

Line 1871: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');

1867: ----------------------------
1868:
1869: -- Debug Information
1870: IF (DEBUG_Var = 'Y') THEN
1871: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Get_Withholding_Options ');
1872: END IF;
1873: -- End Debug
1874:
1875: --Jl_Zz_Ap_Withholding_Pkg.Get_Withholding_Options (l_create_distr,

Line 1887: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1883: WHERE org_id = rec_sel_inv.org_id;
1884:
1885: -- Debug Information
1886: IF (DEBUG_Var = 'Y') THEN
1887: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1888: ('Withholding Opt: l_crte_dst and l_crte_inv: '||l_create_distr||', '||l_create_invoices);
1889: END IF;
1890: -- End Debug
1891:

Line 1912: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1908: -----------------------------------------
1909:
1910: -- Debug Information
1911: IF (DEBUG_Var = 'Y') THEN
1912: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1913: ('==> Calling Ap_Withholding_Pkg.Create_AWT_Distributions');
1914: END IF;
1915: -- End Debug
1916:

Line 1932: JL_ZZ_AP_EXT_AWT_UTIL.Debug

1928: l_calling_sequence);
1929:
1930: -- Debug Information
1931: IF (DEBUG_Var = 'Y') THEN
1932: JL_ZZ_AP_EXT_AWT_UTIL.Debug
1933: ('After Called Ap_Withholding_Pkg.Create_AWT_Distributions');
1934: END IF;
1935: -- End Debug
1936:

Line 1944: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Invoices');

1940: IF (l_create_invoices = 'PAYMENT') THEN
1941:
1942: -- Debug Information
1943: IF (DEBUG_Var = 'Y') THEN
1944: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Ap_Withholding_Pkg.Create_AWT_Invoices');
1945: END IF;
1946: -- End Debug
1947:
1948: Ap_Withholding_Pkg.Create_AWT_Invoices

Line 1964: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_selected_invoices');

1960: END LOOP;
1961:
1962: -- Debug Information
1963: IF (DEBUG_Var = 'Y') THEN
1964: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_selected_invoices');
1965: END IF;
1966: -- End Debug
1967:
1968: CLOSE c_selected_invoices;

Line 1975: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Confirm_Credit_Letters');

1971: -- Confirms credit letters
1972: ---------------------------
1973: -- Debug Information
1974: IF (DEBUG_Var = 'Y') THEN
1975: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Confirm_Credit_Letters');
1976: END IF;
1977: -- End Debug
1978:
1979: Confirm_Credit_Letters (P_Checkrun_Name,P_Checkrun_ID, l_calling_sequence);

Line 1983: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Do_AWT_Confirm_Payment_Batch (-)');

1979: Confirm_Credit_Letters (P_Checkrun_Name,P_Checkrun_ID, l_calling_sequence);
1980:
1981: -- Debug Information
1982: IF (DEBUG_Var = 'Y') THEN
1983: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Do_AWT_Confirm_Payment_Batch (-)');
1984: END IF;
1985: -- End Debug
1986:
1987: EXCEPTION

Line 1991: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Confirm ERROR: '||SQLERRM);

1987: EXCEPTION
1988: WHEN others THEN
1989: -- Debug Information
1990: IF (DEBUG_Var = 'Y') THEN
1991: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Confirm ERROR: '||SQLERRM);
1992: END IF;
1993: -- end debug
1994:
1995: IF (SQLCODE <> -20001) THEN

Line 2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2232: 'Calculate_AWT_Amounts<--' || P_Calling_Sequence;
2233:
2234: -- Debug Information
2235: IF (DEBUG_Var = 'Y') THEN
2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));

Line 2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');

2233:
2234: -- Debug Information
2235: IF (DEBUG_Var = 'Y') THEN
2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));

Line 2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);

2234: -- Debug Information
2235: IF (DEBUG_Var = 'Y') THEN
2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);

Line 2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));

2235: IF (DEBUG_Var = 'Y') THEN
2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);
2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));

2236: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);
2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2244: END IF;

Line 2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));

2237: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_AWT_Amounts');
2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);
2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2244: END IF;
2245: -- End Debug

Line 2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);

2238: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Name : '||P_Checkrun_Name);
2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);
2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2244: END IF;
2245: -- End Debug
2246:

Line 2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2239: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id : '||to_char(P_Check_Id));
2240: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id : '||to_char(P_Selected_Check_Id));
2241: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date : '||to_char(P_AWT_Date,'YYYY/MM/DD'));
2242: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module : '||P_Calling_Module);
2243: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2244: END IF;
2245: -- End Debug
2246:
2247:

Line 2267: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_base_currency_code: '||l_base_currency_code);

2263: (P_AWT_Date);
2264:
2265: -- Debug Information
2266: IF (DEBUG_Var = 'Y') THEN
2267: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_base_currency_code: '||l_base_currency_code);
2268: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_gl_period_name: '||l_gl_period_name);
2269: END IF;
2270: -- End Debug
2271:

Line 2268: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_gl_period_name: '||l_gl_period_name);

2264:
2265: -- Debug Information
2266: IF (DEBUG_Var = 'Y') THEN
2267: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_base_currency_code: '||l_base_currency_code);
2268: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Generic Parameters: l_gl_period_name: '||l_gl_period_name);
2269: END IF;
2270: -- End Debug
2271:
2272:

Line 2280: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_Taxable_Base_Amounts');

2276: -------------------------------------------------------------
2277:
2278: -- Debug Information
2279: IF (DEBUG_Var = 'Y') THEN
2280: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Calculate_Taxable_Base_Amounts');
2281: END IF;
2282: -- End Debug
2283:
2284: Calculate_Taxable_Base_Amounts (P_Check_Id,

Line 2293: JL_ZZ_AP_EXT_AWT_UTIL.Debug('After Called Calculate_Taxable_Base_Amounts');

2289: l_calling_sequence);
2290:
2291: -- Debug Information
2292: IF (DEBUG_Var = 'Y') THEN
2293: JL_ZZ_AP_EXT_AWT_UTIL.Debug('After Called Calculate_Taxable_Base_Amounts');
2294: END IF;
2295: -- End Debug
2296:
2297: -------------------------------------------------------

Line 2312: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_payment_withholdings for Quick Payments');

2308: OPEN c_payment_withholdings (P_Check_Id);
2309:
2310: -- Debug Information
2311: IF (DEBUG_Var = 'Y') THEN
2312: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_payment_withholdings for Quick Payments');
2313: END IF;
2314: -- End Debug
2315:
2316:

Line 2323: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('No rows in the cursor c_payment_withholdings');

2319: IF (c_payment_withholdings%NOTFOUND) THEN
2320:
2321: -- Debug Information
2322: IF (DEBUG_Var = 'Y') THEN
2323: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('No rows in the cursor c_payment_withholdings');
2324: END IF;
2325: -- End Debug
2326: RETURN;
2327: END IF;

Line 2334: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_payment_batch_withholdings for AutoSelect');

2330: OPEN c_payment_batch_withholdings (P_Selected_Check_Id);
2331:
2332: -- Debug Information
2333: IF (DEBUG_Var = 'Y') THEN
2334: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_payment_batch_withholdings for AutoSelect');
2335: END IF;
2336: -- End Debug
2337:
2338: FETCH c_payment_batch_withholdings INTO rec_payment_wh;

Line 2344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('No rows in the cursor c_payment_batch_withholdings');

2340: IF (c_payment_batch_withholdings%NOTFOUND) THEN
2341:
2342: -- Debug Information
2343: IF (DEBUG_Var = 'Y') THEN
2344: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('No rows in the cursor c_payment_batch_withholdings');
2345: END IF;
2346: -- End Debug
2347: RETURN;
2348: END IF;

Line 2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);

2351: END IF; -- End if (P_Calling_Module = 'QUICKCHECK')
2352:
2353: -- Debug Information
2354: IF (DEBUG_Var = 'Y') THEN
2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||

Line 2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));

2352:
2353: -- Debug Information
2354: IF (DEBUG_Var = 'Y') THEN
2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));

Line 2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));

2353: -- Debug Information
2354: IF (DEBUG_Var = 'Y') THEN
2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));

Line 2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));

2354: IF (DEBUG_Var = 'Y') THEN
2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));

Line 2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||

2355: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2356: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));

Line 2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));

2357: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));

Line 2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));

2358: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);

Line 2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));

2359: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));

2360: to_char(rec_payment_wh.invoice_distribution_id ));
2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2368: END IF;

Line 2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));

2361: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2368: END IF;
2369: -- End Debug

Line 2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);

2362: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2368: END IF;
2369: -- End Debug
2370:

Line 2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2363: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2364: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2365: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2366: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2367: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2368: END IF;
2369: -- End Debug
2370:
2371: ---------------------------------------

Line 2387: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Initialize_Withholdings');

2383: -------------------------------------------
2384:
2385: -- Debug Information
2386: IF (DEBUG_Var = 'Y') THEN
2387: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('==> Calling Initialize_Withholdings');
2388: END IF;
2389: -- End Debug
2390:
2391: Initialize_Withholdings (rec_payment_wh.vendor_id,

Line 2403: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Initialize_Withholdings');

2399: tab_payment_wh);
2400:
2401: -- Debug Information
2402: IF (DEBUG_Var = 'Y') THEN
2403: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Initialize_Withholdings');
2404: END IF;
2405: -- End Debug
2406:
2407: l_current_awt := 0;

Line 2416: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Loop for each withholding tax type and tax name associated to the payment');

2412: -- tax name associated to the payment
2413: --------------------------------------------
2414: -- Debug Information
2415: IF (DEBUG_Var = 'Y') THEN
2416: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Loop for each withholding tax type and tax name associated to the payment');
2417: END IF;
2418: -- End Debug
2419:
2420: LOOP

Line 2438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');

2434: -----------------------------------------------------
2435:
2436: -- Debug Information
2437: IF (DEBUG_Var = 'Y') THEN
2438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');
2439: END IF;
2440: -- End Debug
2441:
2442: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

Line 2457: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');

2453: P_AWT_Success);
2454:
2455: -- Debug Information
2456: IF (DEBUG_Var = 'Y') THEN
2457: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when l_not_found');
2458: END IF;
2459: -- End Debug
2460:
2461: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2473: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Process_Withholdings when l_not_found');

2469: -- inserts temporary distribution lines
2470: ------------------------------------------------------
2471: -- Debug Information
2472: IF (DEBUG_Var = 'Y') THEN
2473: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Process_Withholdings when l_not_found');
2474: END IF;
2475: -- End Debug
2476:
2477: Process_Withholdings (l_current_vendor_id,

Line 2502: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Process_Withholdings when l_not_found');

2498:
2499:
2500: -- Debug Information
2501: IF (DEBUG_Var = 'Y') THEN
2502: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Process_Withholdings when l_not_found');
2503: END IF;
2504: -- End Debug
2505:
2506: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2528: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ');

2524: ------------------------------------------------
2525:
2526: -- Debug Information
2527: IF (DEBUG_Var = 'Y') THEN
2528: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ');
2529: END IF;
2530: -- End Debug
2531:
2532: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name

Line 2547: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ELSIF');

2543: P_AWT_Success);
2544:
2545: -- Debug Information
2546: IF (DEBUG_Var = 'Y') THEN
2547: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name IN ELSIF');
2548: END IF;
2549: -- End Debug
2550:
2551: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2564: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Process_Withholdings IN ELSIF');

2560: ------------------------------------------------------
2561:
2562: -- Debug Information
2563: IF (DEBUG_Var = 'Y') THEN
2564: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Process_Withholdings IN ELSIF');
2565: END IF;
2566: -- End Debug
2567:
2568: Process_Withholdings (l_current_vendor_id,

Line 2592: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Process_Withholdings IN ELSIF');

2588: rec_payment_wh.payment_num);
2589:
2590: -- Debug Information
2591: IF (DEBUG_Var = 'Y') THEN
2592: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Process_Withholdings IN ELSIF');
2593: END IF;
2594: -- End Debug
2595:
2596:

Line 2610: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Initialize_Withholdings IN ELSIF');

2606: -------------------------------------------
2607:
2608: -- Debug Information
2609: IF (DEBUG_Var = 'Y') THEN
2610: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Initialize_Withholdings IN ELSIF');
2611: END IF;
2612: -- End Debug
2613:
2614: Initialize_Withholdings (rec_payment_wh.vendor_id,

Line 2626: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Initialize_Withholdings IN ELSIF');

2622: tab_payment_wh);
2623:
2624: -- Debug Information
2625: IF (DEBUG_Var = 'Y') THEN
2626: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Initialize_Withholdings IN ELSIF');
2627: END IF;
2628: -- End Debug
2629:
2630: ----------------------------------

Line 2641: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_awt_type_code = '||l_previous_awt_type_code);

2637: l_previous_invoice_id := rec_payment_wh.invoice_id;
2638:
2639: -- Debug Information
2640: IF (DEBUG_Var = 'Y') THEN
2641: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_awt_type_code = '||l_previous_awt_type_code);
2642: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_tax_id = '||to_char(l_previous_tax_id));
2643: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
2644: END IF;
2645: -- End Debug

Line 2642: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_tax_id = '||to_char(l_previous_tax_id));

2638:
2639: -- Debug Information
2640: IF (DEBUG_Var = 'Y') THEN
2641: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_awt_type_code = '||l_previous_awt_type_code);
2642: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_tax_id = '||to_char(l_previous_tax_id));
2643: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
2644: END IF;
2645: -- End Debug
2646:

Line 2643: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));

2639: -- Debug Information
2640: IF (DEBUG_Var = 'Y') THEN
2641: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_awt_type_code = '||l_previous_awt_type_code);
2642: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_tax_id = '||to_char(l_previous_tax_id));
2643: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Aux Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
2644: END IF;
2645: -- End Debug
2646:
2647:

Line 2659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when <> Tax Name');

2655: ------------------------------------------------
2656:
2657: -- Debug Information
2658: IF (DEBUG_Var = 'Y') THEN
2659: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when <> Tax Name');
2660: END IF;
2661: -- End Debug
2662: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name
2663: (l_current_vendor_id,

Line 2677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when Tax Name Changed');

2673: P_AWT_Success);
2674:
2675: -- Debug Information
2676: IF (DEBUG_Var = 'Y') THEN
2677: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Name when Tax Name Changed');
2678: END IF;
2679: -- End Debug
2680:
2681: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 2693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name. Getting Tax Code Info');

2689: ---------------------------------------------
2690:
2691: -- Debug Information
2692: IF (DEBUG_Var = 'Y') THEN
2693: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name. Getting Tax Code Info');
2694: END IF;
2695: -- End Debug
2696:
2697: Jl_Zz_Ap_Withholding_Pkg.Initialize_Withholding_Name

Line 2710: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_previous_tax_id = '||to_char(l_previous_tax_id));

2706: -----------------------------------
2707:
2708: -- Debug Information
2709: IF (DEBUG_Var = 'Y') THEN
2710: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_previous_tax_id = '||to_char(l_previous_tax_id));
2711: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_initial_awt = '||to_char(l_initial_awt));
2712: END IF;
2713: -- End Debug
2714:

Line 2711: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_initial_awt = '||to_char(l_initial_awt));

2707:
2708: -- Debug Information
2709: IF (DEBUG_Var = 'Y') THEN
2710: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_previous_tax_id = '||to_char(l_previous_tax_id));
2711: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Initializes auxiliary variables: l_initial_awt = '||to_char(l_initial_awt));
2712: END IF;
2713: -- End Debug
2714:
2715: l_previous_tax_id := rec_payment_wh.tax_id;

Line 2726: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exit if there are NO more taxes');

2722: ---------------------------------------
2723:
2724: -- Debug Information
2725: IF (DEBUG_Var = 'Y') THEN
2726: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Exit if there are NO more taxes');
2727: END IF;
2728: -- End Debug
2729:
2730: EXIT WHEN l_not_found;

Line 2747: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' IF(NOT Withholding_Already_Calculated - rec_awt_name.name: '||rec_awt_name.name);

2743: l_calling_sequence)) THEN
2744:
2745: -- Debug Information
2746: IF (DEBUG_Var = 'Y') THEN
2747: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' IF(NOT Withholding_Already_Calculated - rec_awt_name.name: '||rec_awt_name.name);
2748: END IF;
2749: -- End Debug
2750:
2751: -------------------------------------

Line 2768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Got Taxable Base Amount for invoice_id = '||

2764: l_calling_sequence);
2765:
2766: -- Debug Information
2767: IF (DEBUG_Var = 'Y') THEN
2768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Got Taxable Base Amount for invoice_id = '||
2769: to_char(rec_payment_wh.invoice_id)||' = '||to_char(l_tax_base_amt));
2770: END IF;
2771: -- End Debug
2772:

Line 2782: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Increate l_current_awt = '||to_char(l_current_awt));

2778: l_current_awt := l_current_awt + 1;
2779:
2780: -- Debug Information
2781: IF (DEBUG_Var = 'Y') THEN
2782: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Increate l_current_awt = '||to_char(l_current_awt));
2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2784: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Invoice_id = '||to_char(rec_payment_wh.invoice_id)||' - '||
2785: 'Tax_id = '||to_char(rec_payment_wh.tax_id)||' - '||
2786: 'Tax Name = '||rec_awt_name.name);

Line 2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');

2779:
2780: -- Debug Information
2781: IF (DEBUG_Var = 'Y') THEN
2782: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Increate l_current_awt = '||to_char(l_current_awt));
2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2784: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Invoice_id = '||to_char(rec_payment_wh.invoice_id)||' - '||
2785: 'Tax_id = '||to_char(rec_payment_wh.tax_id)||' - '||
2786: 'Tax Name = '||rec_awt_name.name);
2787: END IF;

Line 2784: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Invoice_id = '||to_char(rec_payment_wh.invoice_id)||' - '||

2780: -- Debug Information
2781: IF (DEBUG_Var = 'Y') THEN
2782: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Increate l_current_awt = '||to_char(l_current_awt));
2783: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==>Calling Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2784: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Invoice_id = '||to_char(rec_payment_wh.invoice_id)||' - '||
2785: 'Tax_id = '||to_char(rec_payment_wh.tax_id)||' - '||
2786: 'Tax Name = '||rec_awt_name.name);
2787: END IF;
2788: -- End Debug

Line 2809: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');

2805: rec_payment_wh.payment_num);
2806:
2807: -- Debug Information
2808: IF (DEBUG_Var = 'Y') THEN
2809: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Tax_Name');
2810: END IF;
2811: -- End Debug
2812:
2813: END IF; -- NOT Withholding_Already_Calculated

Line 2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);

2822: END IF;
2823:
2824: -- Debug Information
2825: IF (DEBUG_Var = 'Y') THEN
2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||

Line 2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));

2823:
2824: -- Debug Information
2825: IF (DEBUG_Var = 'Y') THEN
2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));

Line 2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));

2824: -- Debug Information
2825: IF (DEBUG_Var = 'Y') THEN
2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));

Line 2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));

2825: IF (DEBUG_Var = 'Y') THEN
2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));

Line 2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||

2826: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: awt_type_code= '||rec_payment_wh.awt_type_code);
2827: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_id= '||to_char(rec_payment_wh.tax_id));
2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));

Line 2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));

2828: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_id= '||to_char(rec_payment_wh.invoice_id));
2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));

Line 2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));

2829: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: vendor_id= '||to_char(rec_payment_wh.vendor_id));
2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);

Line 2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));

2830: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_distribution_id = '||
2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));

2831: to_char(rec_payment_wh.invoice_distribution_id ));
2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2839: END IF;

Line 2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));

2832: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_amount= '||to_char(rec_payment_wh.invoice_amount));
2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2839: END IF;
2840: -- End Debug

Line 2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);

2833: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: line_amount= '||to_char(rec_payment_wh.line_amount));
2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2839: END IF;
2840: -- End Debug
2841:

Line 2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2834: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_payment_wh.payment_amount));
2835: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: invoice_payment_id= '||to_char(rec_payment_wh.invoice_payment_id));
2836: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_payment_wh.payment_num));
2837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: tax_base_amount_basis= '||rec_payment_wh.tax_base_amount_basis);
2838: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2839: END IF;
2840: -- End Debug
2841:
2842: END LOOP;

Line 2851: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_payment_withholdings');

2847: IF (P_Calling_Module = 'QUICKCHECK') THEN
2848:
2849: -- Debug Information
2850: IF (DEBUG_Var = 'Y') THEN
2851: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_payment_withholdings');
2852: END IF;
2853: -- End Debug
2854: CLOSE c_payment_withholdings;
2855:

Line 2860: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_payment_batch_withholdings');

2856: ELSIF (P_Calling_Module = 'AUTOSELECT') THEN
2857:
2858: -- Debug Information
2859: IF (DEBUG_Var = 'Y') THEN
2860: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Close Cursor c_payment_batch_withholdings');
2861: END IF;
2862: -- End Debug
2863: CLOSE c_payment_batch_withholdings;
2864:

Line 2873: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('P_Total_Wh_Amount: '||l_total_wh_amount);

2869: ------------------------
2870:
2871: -- Debug Information
2872: IF (DEBUG_Var = 'Y') THEN
2873: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('P_Total_Wh_Amount: '||l_total_wh_amount);
2874: END IF;
2875: -- End Debug
2876:
2877: P_Total_Wh_Amount := l_total_wh_amount;

Line 2881: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(tab_payment_wh);

2877: P_Total_Wh_Amount := l_total_wh_amount;
2878:
2879: -- Debug Information
2880: IF (DEBUG_Var = 'Y') THEN
2881: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(tab_payment_wh);
2882: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_all_wh(tab_all_wh);
2883: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procudure Calculate_AWT_Amounts ');
2884: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2885: END IF;

Line 2882: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_all_wh(tab_all_wh);

2878:
2879: -- Debug Information
2880: IF (DEBUG_Var = 'Y') THEN
2881: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(tab_payment_wh);
2882: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_all_wh(tab_all_wh);
2883: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procudure Calculate_AWT_Amounts ');
2884: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2885: END IF;
2886: -- End Debug

Line 2883: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procudure Calculate_AWT_Amounts ');

2879: -- Debug Information
2880: IF (DEBUG_Var = 'Y') THEN
2881: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(tab_payment_wh);
2882: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_all_wh(tab_all_wh);
2883: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procudure Calculate_AWT_Amounts ');
2884: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2885: END IF;
2886: -- End Debug
2887:

Line 2884: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

2880: IF (DEBUG_Var = 'Y') THEN
2881: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(tab_payment_wh);
2882: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_all_wh(tab_all_wh);
2883: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procudure Calculate_AWT_Amounts ');
2884: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
2885: END IF;
2886: -- End Debug
2887:
2888: EXCEPTION

Line 3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3016: 'Process_Withholdings<--' || P_Calling_Sequence;
3017:
3018: -- Debug Information
3019: IF (DEBUG_Var = 'Y') THEN
3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);

Line 3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');

3017:
3018: -- Debug Information
3019: IF (DEBUG_Var = 'Y') THEN
3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));

Line 3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));

3018: -- Debug Information
3019: IF (DEBUG_Var = 'Y') THEN
3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);

Line 3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);

3019: IF (DEBUG_Var = 'Y') THEN
3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);

Line 3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);

3020: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));

Line 3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));

3021: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Process_Withholdings');
3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));

Line 3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);

3022: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Vendor_Id= '||to_char(P_Vendor_Id));
3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));
3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

Line 3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);

3023: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_AWT_Type.AWT_TYPE_CODE= '||P_Rec_AWT_Type.AWT_TYPE_CODE);
3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));
3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3031: END IF;

Line 3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));

3024: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE= '||P_Rec_Suppl_AWT_Type.AWT_TYPE_CODE);
3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));
3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3031: END IF;
3032: -- End Debug

Line 3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));

3025: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_AWT_Date= '||to_char(P_AWT_Date,'YYYY/MM/DD'));
3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));
3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3031: END IF;
3032: -- End Debug
3033:

Line 3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

3026: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_GL_Period_Name= '||P_GL_Period_Name);
3027: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Base_Currency_Code= '||P_Base_Currency_Code);
3028: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3029: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Checkrun_Id= '||to_char(P_Checkrun_Id));
3030: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3031: END IF;
3032: -- End Debug
3033:
3034:

Line 3060: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');

3056: ------------------------------------------------
3057:
3058: -- Debug Information
3059: IF (DEBUG_Var = 'Y') THEN
3060: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3061: END IF;
3062: -- End Debug
3063:
3064: Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type

Line 3073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');

3069: P_Tab_Withhold);
3070:
3071: -- Debug Information
3072: IF (DEBUG_Var = 'Y') THEN
3073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3074: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3075: END IF;
3076: -- End Debug
3077:

Line 3074: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

3070:
3071: -- Debug Information
3072: IF (DEBUG_Var = 'Y') THEN
3073: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Process_Withholding_Type');
3074: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3075: END IF;
3076: -- End Debug
3077:
3078:

Line 3085: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Credit_Letter');

3081: --------------------------------------
3082:
3083: -- Debug Information
3084: IF (DEBUG_Var = 'Y') THEN
3085: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Update_Credit_Letter');
3086: END IF;
3087: -- End Debug
3088:
3089: Update_Credit_Letter (P_Vendor_Id,

Line 3105: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Update_Credit_Letter');

3101: P_Request_Id);
3102:
3103: -- Debug Information
3104: IF (DEBUG_Var = 'Y') THEN
3105: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Update_Credit_Letter');
3106: END IF;
3107: -- End Debug
3108:
3109: ------------------------------------------------

Line 3115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');

3111: -------------------------------------------------
3112:
3113: -- Debug Information
3114: IF (DEBUG_Var = 'Y') THEN
3115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3116: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3117: END IF;
3118: -- End Debug
3119:

Line 3116: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

3112:
3113: -- Debug Information
3114: IF (DEBUG_Var = 'Y') THEN
3115: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3116: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3117: END IF;
3118: -- End Debug
3119:
3120: Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings (P_Tab_Withhold,

Line 3125: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');

3121: P_Base_Currency_Code);
3122:
3123: -- Debug Information
3124: IF (DEBUG_Var = 'Y') THEN
3125: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3126: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3127: END IF;
3128: -- End Debug
3129:

Line 3126: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

3122:
3123: -- Debug Information
3124: IF (DEBUG_Var = 'Y') THEN
3125: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Prorate_Withholdings');
3126: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3127: END IF;
3128: -- End Debug
3129:
3130:

Line 3136: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');

3132: -- Insert Temporary Distributions Lines
3133: ----------------------------------------
3134: -- Debug Information
3135: IF (DEBUG_Var = 'Y') THEN
3136: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');
3137: END IF;
3138: -- End Debug
3139:
3140: Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table

Line 3163: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');

3159: P_Payment_Num);
3160:
3161: -- Debug Information
3162: IF (DEBUG_Var = 'Y') THEN
3163: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' After Called Jl_Zz_Ap_Withholding_Pkg.Store_Into_Temporary_Table');
3164: END IF;
3165: -- End Debug
3166:
3167: IF (P_AWT_Success <> AWT_SUCCESS) THEN

Line 3183: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Total withheld amount for current tax type: '||to_char(P_Total_Wh_Amount));

3179:
3180:
3181: -- Debug Information
3182: IF (DEBUG_Var = 'Y') THEN
3183: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Total withheld amount for current tax type: '||to_char(P_Total_Wh_Amount));
3184: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3185: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Process_Withholdings');
3186: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3187: END IF;

Line 3184: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);

3180:
3181: -- Debug Information
3182: IF (DEBUG_Var = 'Y') THEN
3183: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Total withheld amount for current tax type: '||to_char(P_Total_Wh_Amount));
3184: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3185: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Process_Withholdings');
3186: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3187: END IF;
3188: -- End Debug

Line 3185: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Process_Withholdings');

3181: -- Debug Information
3182: IF (DEBUG_Var = 'Y') THEN
3183: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Total withheld amount for current tax type: '||to_char(P_Total_Wh_Amount));
3184: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3185: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Process_Withholdings');
3186: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3187: END IF;
3188: -- End Debug
3189:

Line 3186: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3182: IF (DEBUG_Var = 'Y') THEN
3183: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Total withheld amount for current tax type: '||to_char(P_Total_Wh_Amount));
3184: JL_ZZ_AP_EXT_AWT_UTIL.Print_Tax_Names(P_Tab_Withhold);
3185: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Process_Withholdings');
3186: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3187: END IF;
3188: -- End Debug
3189:
3190: EXCEPTION

Line 3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3343: P_Calling_Sequence;
3344:
3345: -- Debug Information
3346: IF (DEBUG_Var = 'Y') THEN
3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);

Line 3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');

3344:
3345: -- Debug Information
3346: IF (DEBUG_Var = 'Y') THEN
3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);

Line 3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));

3345: -- Debug Information
3346: IF (DEBUG_Var = 'Y') THEN
3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);

Line 3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));

3346: IF (DEBUG_Var = 'Y') THEN
3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3354: END IF;

Line 3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);

3347: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3354: END IF;
3355: -- End Debug

Line 3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);

3348: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Calculate_Taxable_Base_Amounts');
3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3354: END IF;
3355: -- End Debug
3356:

Line 3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);

3349: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Check_Id= '||to_char(P_Check_Id));
3350: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Selected_Check_Id= '||to_char(P_Selected_Check_Id));
3351: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Currency_Code= '||P_Currency_Code);
3352: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3353: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3354: END IF;
3355: -- End Debug
3356:
3357: --------------------

Line 3365: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_invoice_amounts');

3361: OPEN c_invoice_amounts (P_Check_Id);
3362:
3363: -- Debug Information
3364: IF (DEBUG_Var = 'Y') THEN
3365: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_invoice_amounts');
3366: END IF;
3367: -- End Debug
3368:
3369: ELSIF (P_Calling_Module = 'AUTOSELECT') THEN

Line 3374: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_batch_invoice_amounts');

3370: OPEN c_batch_invoice_amounts (P_Selected_Check_Id);
3371:
3372: -- Debug Information
3373: IF (DEBUG_Var = 'Y') THEN
3374: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Open Cursor c_batch_invoice_amounts');
3375: END IF;
3376: -- End Debug
3377:
3378: END IF;

Line 3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));

3389: l_previous_inv_pay_num := null;
3390:
3391: -- Debug Information
3392: IF (DEBUG_Var = 'Y') THEN
3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));

Line 3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));

3390:
3391: -- Debug Information
3392: IF (DEBUG_Var = 'Y') THEN
3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));

3391: -- Debug Information
3392: IF (DEBUG_Var = 'Y') THEN
3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3399: END IF;

Line 3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));

3392: IF (DEBUG_Var = 'Y') THEN
3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3399: END IF;
3400: -- End Debug

Line 3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));

3393: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3399: END IF;
3400: -- End Debug
3401:

Line 3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3394: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3395: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3396: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3397: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3398: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3399: END IF;
3400: -- End Debug
3401:
3402: LOOP

Line 3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3422: EXIT WHEN l_not_found;
3423:
3424: -- Debug Information
3425: IF (DEBUG_Var = 'Y') THEN
3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));

Line 3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');

3423:
3424: -- Debug Information
3425: IF (DEBUG_Var = 'Y') THEN
3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);

Line 3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));

3424: -- Debug Information
3425: IF (DEBUG_Var = 'Y') THEN
3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));

Line 3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));

3425: IF (DEBUG_Var = 'Y') THEN
3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));

Line 3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));

3426: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));

Line 3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);

3427: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' STARTING THE LOOP');
3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));

3428: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID = '||to_char(l_invoice_id));
3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));

Line 3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));

3429: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_dist_line_no = '||to_char(l_dist_line_no));
3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));

Line 3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));

3430: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_amount = '||to_char(l_amount));
3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));

Line 3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3431: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_tax_inclusive_amount = '||l_tax_inclusive_amount);
3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));

Line 3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));

3432: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_amount = '||to_char(l_payment_amount));
3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));

Line 3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));

3433: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_id = '||to_char(l_invo_payment_id));
3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));

Line 3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));

3434: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invo_payment_num = '||to_char(l_invo_payment_num));
3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));
3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));

3435: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));
3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3443: END IF;

Line 3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));

3436: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_invoice_amount = '||to_char(l_invoice_amount));
3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));
3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3443: END IF;
3444: -- End Debug

Line 3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));

3437: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_position = '||to_char(l_position));
3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));
3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3443: END IF;
3444: -- End Debug
3445:

Line 3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3438: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_initial_position = '||to_char(l_initial_position));
3439: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_invoice_id = '||to_char(l_previous_invoice_id));
3440: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_id = '||to_char(l_previous_inv_pay_id));
3441: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Auxiliary Variables: l_previous_inv_pay_num = '||to_char(l_previous_inv_pay_num));
3442: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3443: END IF;
3444: -- End Debug
3445:
3446: ---------------------------------

Line 3464: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' QUICKCHECK and l_previous_invoice_id <> l_invoice_id');

3460: END LOOP;
3461:
3462: -- Debug Information
3463: IF (DEBUG_Var = 'Y') THEN
3464: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' QUICKCHECK and l_previous_invoice_id <> l_invoice_id');
3465: END IF;
3466: -- End Debug
3467:
3468: l_invoice_amount := 0;

Line 3487: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AUTOSELECT and l_previous_invoice_id <> l_invoice_id');

3483: END LOOP;
3484:
3485: -- Debug Information
3486: IF (DEBUG_Var = 'Y') THEN
3487: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' AUTOSELECT and l_previous_invoice_id <> l_invoice_id');
3488: END IF;
3489: -- End Debug
3490:
3491:

Line 3522: JL_ZZ_AP_EXT_AWT_UTIL.Debug('After lOOP');

3518: END LOOP;
3519:
3520: -- Debug Information
3521: IF (DEBUG_Var = 'Y') THEN
3522: JL_ZZ_AP_EXT_AWT_UTIL.Debug('After lOOP');
3523: END IF;
3524: -- End Debug
3525:
3526: ---------------------------------

Line 3535: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Sets the total invoice amount');

3531: END LOOP;
3532:
3533: -- Debug Information
3534: IF (DEBUG_Var = 'Y') THEN
3535: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Sets the total invoice amount');
3536: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3537: END IF;
3538: -- End Debug
3539:

Line 3536: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);

3532:
3533: -- Debug Information
3534: IF (DEBUG_Var = 'Y') THEN
3535: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Sets the total invoice amount');
3536: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3537: END IF;
3538: -- End Debug
3539:
3540: ----------------

Line 3547: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Close Cursor c_invoice_amounts');

3543: IF (P_Calling_Module = 'QUICKCHECK') THEN
3544:
3545: -- Debug Information
3546: IF (DEBUG_Var = 'Y') THEN
3547: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Close Cursor c_invoice_amounts');
3548: END IF;
3549: -- End Debug
3550: CLOSE c_invoice_amounts;
3551:

Line 3556: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Close Cursor c_invoice_amounts');

3552: ELSIF (P_Calling_Module = 'AUTOSELECT') THEN
3553:
3554: -- Debug Information
3555: IF (DEBUG_Var = 'Y') THEN
3556: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Close Cursor c_invoice_amounts');
3557: END IF;
3558: -- End Debug
3559: CLOSE c_batch_invoice_amounts;
3560:

Line 3592: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' TBA = tax base amts - l_cumulative_amount');

3588: l_previous_invoice_id := P_Tab_Inv_Amounts(i).invoice_id;
3589:
3590: -- Debug Information
3591: IF (DEBUG_Var = 'Y') THEN
3592: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' TBA = tax base amts - l_cumulative_amount');
3593: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i-1).invoice_id)||' '||
3594: 'Taxable Base Amount = '||to_char(P_Tab_Inv_Amounts(i-1).taxable_base_amount));
3595: END IF;
3596: -- End Debug

Line 3593: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i-1).invoice_id)||' '||

3589:
3590: -- Debug Information
3591: IF (DEBUG_Var = 'Y') THEN
3592: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' TBA = tax base amts - l_cumulative_amount');
3593: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i-1).invoice_id)||' '||
3594: 'Taxable Base Amount = '||to_char(P_Tab_Inv_Amounts(i-1).taxable_base_amount));
3595: END IF;
3596: -- End Debug
3597:

Line 3617: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Calculates tax base amts prorating payment amt for each different inv');

3613: P_Tab_Inv_Amounts(i).invoice_amount;
3614:
3615: -- Debug Information
3616: IF (DEBUG_Var = 'Y') THEN
3617: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Calculates tax base amts prorating payment amt for each different inv');
3618: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i).invoice_id)||' '||
3619: 'Taxable Base Amount = '||to_char(P_Tab_Inv_Amounts(i).taxable_base_amount));
3620: END IF;
3621: -- End Debug

Line 3618: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i).invoice_id)||' '||

3614:
3615: -- Debug Information
3616: IF (DEBUG_Var = 'Y') THEN
3617: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Calculates tax base amts prorating payment amt for each different inv');
3618: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Invoice_id = '||to_char(P_Tab_Inv_Amounts(i).invoice_id)||' '||
3619: 'Taxable Base Amount = '||to_char(P_Tab_Inv_Amounts(i).taxable_base_amount));
3620: END IF;
3621: -- End Debug
3622:

Line 3657: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Calculates prorated tax inclusive amount');

3653: P_Currency_Code);
3654:
3655: -- Debug Information
3656: IF (DEBUG_Var = 'Y') THEN
3657: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Calculates prorated tax inclusive amount');
3658: END IF;
3659: -- End Debug
3660:
3661: IF (i > 1) THEN

Line 3669: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Cumulative Amount = '||to_char(l_cumulative_amount));

3665: P_Tab_Inv_Amounts(i-1).taxable_base_amount;
3666:
3667: -- Debug Information
3668: IF (DEBUG_Var = 'Y') THEN
3669: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Cumulative Amount = '||to_char(l_cumulative_amount));
3670: END IF;
3671: -- End Debug
3672:
3673: END IF;

Line 3680: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' END Loop thru Tax Invoice Amounts');

3676: END LOOP;
3677:
3678: -- Debug Information
3679: IF (DEBUG_Var = 'Y') THEN
3680: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' END Loop thru Tax Invoice Amounts');
3681: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3682: END IF;
3683: -- End Debug
3684:

Line 3681: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);

3677:
3678: -- Debug Information
3679: IF (DEBUG_Var = 'Y') THEN
3680: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' END Loop thru Tax Invoice Amounts');
3681: JL_ZZ_AP_EXT_AWT_UTIL.Print_tab_amounts(P_Tab_Inv_Amounts);
3682: END IF;
3683: -- End Debug
3684:
3685: /*

Line 3697: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Last Row for AUTOSELECT - Payment Amount');

3693: l_cumulative_amount;
3694:
3695: -- Debug Information
3696: IF (DEBUG_Var = 'Y') THEN
3697: JL_ZZ_AP_EXT_AWT_UTIL.Debug(' Last Row for AUTOSELECT - Payment Amount');
3698: END IF;
3699: -- End Debug
3700:
3701: END IF;

Line 3706: JL_ZZ_AP_EXT_AWT_UTIL.Debug('END Procedure Calculate_Taxable_Base_Amounts');

3702: */
3703:
3704: -- Debug Information
3705: IF (DEBUG_Var = 'Y') THEN
3706: JL_ZZ_AP_EXT_AWT_UTIL.Debug('END Procedure Calculate_Taxable_Base_Amounts');
3707: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3708: END IF;
3709: -- End Debug
3710:

Line 3707: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3703:
3704: -- Debug Information
3705: IF (DEBUG_Var = 'Y') THEN
3706: JL_ZZ_AP_EXT_AWT_UTIL.Debug('END Procedure Calculate_Taxable_Base_Amounts');
3707: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3708: END IF;
3709: -- End Debug
3710:
3711:

Line 3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3759: 'Get_Taxable_Base_Amount<--' || P_Calling_Sequence;
3760:
3761: -- Debug Information
3762: IF (DEBUG_Var = 'Y') THEN
3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));

Line 3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');

3760:
3761: -- Debug Information
3762: IF (DEBUG_Var = 'Y') THEN
3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);

Line 3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));

3761: -- Debug Information
3762: IF (DEBUG_Var = 'Y') THEN
3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);

Line 3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));

3762: IF (DEBUG_Var = 'Y') THEN
3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);

Line 3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));

3763: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);

3764: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount');
3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3772: END IF;

Line 3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);

3765: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Id= '||to_char(P_Invoice_Id));
3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3772: END IF;
3773: -- End Debug

Line 3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);

3766: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Distribution_Line_No= '||to_char(P_Distribution_Line_No));
3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3772: END IF;
3773: -- End Debug
3774:

Line 3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

3767: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Invoice_Payment_ID= '||to_char(P_Invoice_Payment_ID));
3768: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Base_Amount_Basis= '||P_Tax_Base_Amount_Basis);
3769: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Tax_Inclusive_Flag= '||P_Tax_Inclusive_Flag);
3770: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameters: P_Calling_Module= '||P_Calling_Module);
3771: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
3772: END IF;
3773: -- End Debug
3774:
3775: -----------------------------------

Line 3804: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount for invoice '||

3800: IF (nvl(P_Tax_Inclusive_Flag, 'N') = 'Y') THEN
3801:
3802: -- Debug Information
3803: IF (DEBUG_Var = 'Y') THEN
3804: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('FUNCTION Get_Taxable_Base_Amount for invoice '||
3805: to_char(P_Tab_Inv_Amounts(i).invoice_id));
3806: END IF;
3807: -- End Debug
3808:

Line 4041: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withholding Type Code = '||P_Rec_AWT_Type.awt_type_code);

4037: END IF;
4038:
4039: -- Debug Information
4040: IF (DEBUG_Var = 'Y') THEN
4041: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withholding Type Code = '||P_Rec_AWT_Type.awt_type_code);
4042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Credit Letter Amount = '||to_char(l_credit_letter_amount));
4043: END IF;
4044: -- End Debug
4045:

Line 4042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Credit Letter Amount = '||to_char(l_credit_letter_amount));

4038:
4039: -- Debug Information
4040: IF (DEBUG_Var = 'Y') THEN
4041: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Withholding Type Code = '||P_Rec_AWT_Type.awt_type_code);
4042: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Credit Letter Amount = '||to_char(l_credit_letter_amount));
4043: END IF;
4044: -- End Debug
4045:
4046:

Line 4549: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4545:
4546:
4547: -- Debug Information
4548: IF (DEBUG_Var = 'Y') THEN
4549: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4550: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Quick_Payment');
4551: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
4552: END IF;
4553: -- End Debug

Line 4550: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Quick_Payment');

4546:
4547: -- Debug Information
4548: IF (DEBUG_Var = 'Y') THEN
4549: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4550: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Quick_Payment');
4551: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
4552: END IF;
4553: -- End Debug
4554:

Line 4551: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));

4547: -- Debug Information
4548: IF (DEBUG_Var = 'Y') THEN
4549: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4550: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Quick_Payment');
4551: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
4552: END IF;
4553: -- End Debug
4554:
4555:

Line 4562: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' OPEN c_invoice_payment');

4558: --------------------------------------------
4559:
4560: -- Debug Information
4561: IF (DEBUG_Var = 'Y') THEN
4562: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' OPEN c_invoice_payment');
4563: END IF;
4564: -- End Debug
4565:
4566: OPEN c_invoice_payment(P_Check_Id);

Line 4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));

4575: EXIT WHEN c_invoice_payment%NOTFOUND;
4576:
4577: -- Debug Information
4578: IF (DEBUG_Var = 'Y') THEN
4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));

Line 4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));

4576:
4577: -- Debug Information
4578: IF (DEBUG_Var = 'Y') THEN
4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));

Line 4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));

4577: -- Debug Information
4578: IF (DEBUG_Var = 'Y') THEN
4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));

Line 4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));

4578: IF (DEBUG_Var = 'Y') THEN
4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));

4579: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4587: END IF;

Line 4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));

4580: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4587: END IF;
4588: -- End Debug

Line 4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));

4581: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4587: END IF;
4588: -- End Debug
4589:

Line 4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4582: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
4583: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
4584: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
4585: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
4586: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4587: END IF;
4588: -- End Debug
4589:
4590: -------------------------------------------

Line 4603: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains withheld amount for the invoice : '||to_char(l_withhold_amount));

4599: AND NVL(apid.REVERSAL_FLAG,'N') <> 'Y';
4600:
4601: -- Debug Information
4602: IF (DEBUG_Var = 'Y') THEN
4603: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains withheld amount for the invoice : '||to_char(l_withhold_amount));
4604: END IF;
4605: -- End Debug
4606:
4607: IF (l_withhold_amount <> 0) THEN

Line 4626: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains currency information: exch rate, pay cross rate, pay curr code'||

4622: AND apps.payment_num = l_payment_num;
4623:
4624: -- Debug Information
4625: IF (DEBUG_Var = 'Y') THEN
4626: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains currency information: exch rate, pay cross rate, pay curr code'||
4627: to_char(l_inv_exchange_rate)||', '||to_char(l_payment_cross_rate)||
4628: ','||l_payment_currency_code);
4629: END IF;
4630: -- End Debug

Line 4728: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Update_Quick_Payment');

4724: END IF;
4725:
4726: -- Debug Information
4727: IF (DEBUG_Var = 'Y') THEN
4728: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Update_Quick_Payment');
4729: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4730: END IF;
4731: -- End Debug
4732:

Line 4729: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4725:
4726: -- Debug Information
4727: IF (DEBUG_Var = 'Y') THEN
4728: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Update_Quick_Payment');
4729: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4730: END IF;
4731: -- End Debug
4732:
4733: EXCEPTION

Line 4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4833: 'Update_Payment_Batch<--' || P_Calling_Sequence;
4834:
4835: -- Debug Information
4836: IF (DEBUG_Var = 'Y') THEN
4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');
4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);
4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');

4834:
4835: -- Debug Information
4836: IF (DEBUG_Var = 'Y') THEN
4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');
4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);
4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4842: END IF;

Line 4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);

4835: -- Debug Information
4836: IF (DEBUG_Var = 'Y') THEN
4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');
4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);
4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4842: END IF;
4843: -- End Debug

Line 4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));

4836: IF (DEBUG_Var = 'Y') THEN
4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');
4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);
4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4842: END IF;
4843: -- End Debug
4844:

Line 4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4837: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4838: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Update_Payment_Batch');
4839: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Checkrun_Name: '||P_Checkrun_Name);
4840: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
4841: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4842: END IF;
4843: -- End Debug
4844:
4845:

Line 4866: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Just update the invoices in the same payment check: '||to_char(l_count_inv));

4862:
4863:
4864: -- Debug Information
4865: IF (DEBUG_Var = 'Y') THEN
4866: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Just update the invoices in the same payment check: '||to_char(l_count_inv));
4867: END IF;
4868: -- End Debug
4869:
4870: IF (l_count_inv = 0 ) Then

Line 4893: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Proposed Payment Amount : '||to_char(l_prop_payment_amount));

4889: -- AND apsi.original_invoice_id IS NULL;
4890:
4891: -- Debug Information
4892: IF (DEBUG_Var = 'Y') THEN
4893: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Proposed Payment Amount : '||to_char(l_prop_payment_amount));
4894: END IF;
4895: -- End Debug
4896:
4897: --------------------------------------

Line 4903: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('OPEN Cursor c_selected_invoices');

4899: --------------------------------------
4900:
4901: -- Debug Information
4902: IF (DEBUG_Var = 'Y') THEN
4903: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('OPEN Cursor c_selected_invoices');
4904: END IF;
4905: -- End Debug
4906:
4907: OPEN c_selected_invoices (P_Selected_Check_Id);

Line 4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));

4911: EXIT WHEN c_selected_invoices%NOTFOUND;
4912:
4913: -- Debug Information
4914: IF (DEBUG_Var = 'Y') THEN
4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));
4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));

Line 4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));

4912:
4913: -- Debug Information
4914: IF (DEBUG_Var = 'Y') THEN
4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));
4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));
4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));

4913: -- Debug Information
4914: IF (DEBUG_Var = 'Y') THEN
4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));
4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));
4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4921: END IF;

Line 4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));

4914: IF (DEBUG_Var = 'Y') THEN
4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));
4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));
4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4921: END IF;
4922: -- End Debug

Line 4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));

4915: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: Invoice_ID= '||to_char(rec_sel_inv.invoice_id));
4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));
4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4921: END IF;
4922: -- End Debug
4923:

Line 4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

4916: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_num= '||to_char(rec_sel_inv.payment_num));
4917: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: payment_amount= '||to_char(rec_sel_inv.payment_amount));
4918: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: inv exch rate= '||to_char(rec_sel_inv.invoice_exchange_rate));
4919: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: pay cross rate= '||to_char(rec_sel_inv.payment_cross_rate));
4920: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
4921: END IF;
4922: -- End Debug
4923:
4924: ------------------------------------

Line 4967: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Withheld amount for the invoice= '||to_char(l_withholding_amount));

4963:
4964:
4965: -- Debug Information
4966: IF (DEBUG_Var = 'Y') THEN
4967: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Withheld amount for the invoice= '||to_char(l_withholding_amount));
4968: END IF;
4969: -- End Debug
4970:
4971: -------------------------------------------------------

Line 5428: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Confirm Credit Letters: '||SQLERRM);

5424: null;
5425: WHEN others THEN
5426: -- Debug Information
5427: IF (DEBUG_Var = 'Y') THEN
5428: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Confirm Credit Letters: '||SQLERRM);
5429: END IF;
5430: -- end debug
5431:
5432: IF (SQLCODE <> -20001) THEN

Line 5502: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Reject_Payment_Batch');

5498: P_Calling_Sequence;
5499:
5500: -- Debug Information
5501: IF (DEBUG_Var = 'Y') THEN
5502: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Reject_Payment_Batch');
5503: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
5504: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_AWT_Success: '||P_AWT_Success);
5505: END IF;
5506: -- End Debug

Line 5503: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));

5499:
5500: -- Debug Information
5501: IF (DEBUG_Var = 'Y') THEN
5502: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Reject_Payment_Batch');
5503: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
5504: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_AWT_Success: '||P_AWT_Success);
5505: END IF;
5506: -- End Debug
5507:

Line 5504: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_AWT_Success: '||P_AWT_Success);

5500: -- Debug Information
5501: IF (DEBUG_Var = 'Y') THEN
5502: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Reject_Payment_Batch');
5503: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Selected_Check_Id: '||to_char(P_Selected_Check_Id));
5504: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_AWT_Success: '||P_AWT_Success);
5505: END IF;
5506: -- End Debug
5507:
5508: -------------------------------------

Line 5722: -- JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

5718:
5719:
5720: -- Debug Information
5721: IF (DEBUG_Var = 'Y') THEN
5722: -- JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5723: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Undo_Quick_Payment');
5724: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
5725: END IF;
5726: -- End Debug

Line 5723: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Undo_Quick_Payment');

5719:
5720: -- Debug Information
5721: IF (DEBUG_Var = 'Y') THEN
5722: -- JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5723: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Undo_Quick_Payment');
5724: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
5725: END IF;
5726: -- End Debug
5727:

Line 5724: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));

5720: -- Debug Information
5721: IF (DEBUG_Var = 'Y') THEN
5722: -- JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5723: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('PROCEDURE Undo_Quick_Payment');
5724: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Parameter P_Check_Id: '||to_char(P_Check_Id));
5725: END IF;
5726: -- End Debug
5727:
5728: --------------------------------------------

Line 5734: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' OPEN c_invoice_payment');

5730: --------------------------------------------
5731:
5732: -- Debug Information
5733: IF (DEBUG_Var = 'Y') THEN
5734: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' OPEN c_invoice_payment');
5735: END IF;
5736: -- End Debug
5737:
5738: OPEN c_invoice_payment(P_Check_Id);

Line 5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));

5747: EXIT WHEN c_invoice_payment%NOTFOUND;
5748:
5749: -- Debug Information
5750: IF (DEBUG_Var = 'Y') THEN
5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));

Line 5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));

5748:
5749: -- Debug Information
5750: IF (DEBUG_Var = 'Y') THEN
5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));

Line 5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));

5749: -- Debug Information
5750: IF (DEBUG_Var = 'Y') THEN
5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));

Line 5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));

5750: IF (DEBUG_Var = 'Y') THEN
5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

Line 5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));

5751: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_payment_id= '||to_char(l_invoice_payment_id));
5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5759: END IF;

Line 5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));

5752: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_id= '||to_char(l_invoice_id));
5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5759: END IF;
5760: -- End Debug

Line 5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));

5753: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_exchange_rate= '||to_char(l_pay_exchange_rate));
5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5759: END IF;
5760: -- End Debug
5761: -------------------------------------------

Line 5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

5754: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_num= '||to_char(l_payment_num));
5755: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_pay_amount= '||to_char(l_pay_amount));
5756: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_payment_base_amount= '||to_char(l_payment_base_amount));
5757: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' Fetched Values: l_invoice_base_amount= '||to_char(l_invoice_base_amount));
5758: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5759: END IF;
5760: -- End Debug
5761: -------------------------------------------
5762: -- Obtains withheld amount for the invoice

Line 5771: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains withheld amount for the invoice : '||to_char(l_withhold_amount));

5767: EXIT WHEN c_withheld_amount%NOTFOUND;
5768:
5769: -- Debug Information
5770: IF (DEBUG_Var = 'Y') THEN
5771: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains withheld amount for the invoice : '||to_char(l_withhold_amount));
5772: END IF;
5773: -- End Debug
5774: IF (l_withhold_amount <> 0) THEN
5775:

Line 5791: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains currency information: exch rate, pay cross rate '||

5787: AND apps.payment_num = l_payment_num;
5788:
5789: -- Debug Information
5790: IF (DEBUG_Var = 'Y') THEN
5791: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('Obtains currency information: exch rate, pay cross rate '||
5792: to_char(l_inv_exchange_rate)||', '||to_char(l_payment_cross_rate));
5793: END IF;
5794: -- End Debug
5795:

Line 5838: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Payment Amt =' || to_char(l_pay_amount) || 'Inv BaseAmt :'

5834: (l_withhold_amount * nvl(l_payment_cross_rate, 1) *
5835: nvl(l_pay_exchange_rate, 1));
5836:
5837: IF (Debug_var = 'Y' ) Then
5838: JL_ZZ_AP_EXT_AWT_UTIL.Debug('Payment Amt =' || to_char(l_pay_amount) || 'Inv BaseAmt :'
5839: || to_char(l_withhold_amount));
5840: END IF;
5841:
5842: AP_AIP_TABLE_HANDLER_PKG.Update_Amounts(

Line 5892: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Undo_Quick_Payment');

5888: END IF;
5889:
5890: -- Debug Information
5891: IF (DEBUG_Var = 'Y') THEN
5892: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Undo_Quick_Payment');
5893: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5894: END IF;
5895: -- End Debug
5896:

Line 5893: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');

5889:
5890: -- Debug Information
5891: IF (DEBUG_Var = 'Y') THEN
5892: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('End Procedure Undo_Quick_Payment');
5893: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ');
5894: END IF;
5895: -- End Debug
5896:
5897: EXCEPTION