eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on FND_MESSAGE

Line 528: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_AWT_CALC_ERROR');

524: -- sets the error message on the stack to be retrieved
525: -- on the client side
526: -------------------------------------------------------
527: IF (P_AWT_Success <> AWT_SUCCESS) THEN
528: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_AWT_CALC_ERROR');
529: Fnd_Message.Set_Token ('ERROR_TEXT', P_AWT_Success);
530: END IF;
531:
532:

Line 529: Fnd_Message.Set_Token ('ERROR_TEXT', P_AWT_Success);

525: -- on the client side
526: -------------------------------------------------------
527: IF (P_AWT_Success <> AWT_SUCCESS) THEN
528: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_AWT_CALC_ERROR');
529: Fnd_Message.Set_Token ('ERROR_TEXT', P_AWT_Success);
530: END IF;
531:
532:
533: /********************************************************

Line 617: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

613: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Do_Withholding - Error:'||SQLERRM);
614: END IF;
615: -- End Debug
616:
617: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
618: Fnd_Message.Set_Token('ERROR', SQLERRM);
619: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
620: Fnd_Message.Set_Token('PARAMETERS',
621: ' Invoice Id= ' || to_char(P_Invoice_Id) ||

Line 618: Fnd_Message.Set_Token('ERROR', SQLERRM);

614: END IF;
615: -- End Debug
616:
617: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
618: Fnd_Message.Set_Token('ERROR', SQLERRM);
619: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
620: Fnd_Message.Set_Token('PARAMETERS',
621: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
622: ', Awt Date= ' || to_char(P_Awt_Date,'YYYY/MM/DD') ||

Line 619: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

615: -- End Debug
616:
617: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
618: Fnd_Message.Set_Token('ERROR', SQLERRM);
619: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
620: Fnd_Message.Set_Token('PARAMETERS',
621: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
622: ', Awt Date= ' || to_char(P_Awt_Date,'YYYY/MM/DD') ||
623: ', Calling Module= ' || P_Calling_Module ||

Line 620: Fnd_Message.Set_Token('PARAMETERS',

616:
617: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
618: Fnd_Message.Set_Token('ERROR', SQLERRM);
619: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
620: Fnd_Message.Set_Token('PARAMETERS',
621: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
622: ', Awt Date= ' || to_char(P_Awt_Date,'YYYY/MM/DD') ||
623: ', Calling Module= ' || P_Calling_Module ||
624: ', Amount= ' || to_char(P_Amount) ||

Line 629: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

625: ', Payment Num= ' || to_char(P_Payment_Num) ||
626: ', Checkrun Name= ' || P_Checkrun_Name ||
627: ', Invoice Payment Id= ' || to_char(P_Invoice_Payment_Id) ||
628: ', Check Id= ' || to_char(P_Check_Id));
629: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
630: END IF;
631:
632: P_AWT_Success := AWT_ERROR;
633:

Line 786: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

782: IF (DEBUG_Var = 'Y') THEN
783: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - Error:'||SQLERRM);
784: END IF;
785: -- End Debug
786: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
787: Fnd_Message.Set_Token('ERROR', SQLERRM);
788: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
789: Fnd_Message.Set_Token('PARAMETERS',
790: ' Parent_Id= ' || to_char(P_Parent_Id) ||

Line 787: Fnd_Message.Set_Token('ERROR', SQLERRM);

783: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - Jl_Ar_Ap_Undo_Withholding - Error:'||SQLERRM);
784: END IF;
785: -- End Debug
786: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
787: Fnd_Message.Set_Token('ERROR', SQLERRM);
788: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
789: Fnd_Message.Set_Token('PARAMETERS',
790: ' Parent_Id= ' || to_char(P_Parent_Id) ||
791: ', Calling_Module= ' || P_Calling_Module ||

Line 788: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

784: END IF;
785: -- End Debug
786: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
787: Fnd_Message.Set_Token('ERROR', SQLERRM);
788: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
789: Fnd_Message.Set_Token('PARAMETERS',
790: ' Parent_Id= ' || to_char(P_Parent_Id) ||
791: ', Calling_Module= ' || P_Calling_Module ||
792: ', Undo_Awt_Date= ' || to_char(P_Undo_Awt_Date,'YYYY/MM/DD'));

Line 789: Fnd_Message.Set_Token('PARAMETERS',

785: -- End Debug
786: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
787: Fnd_Message.Set_Token('ERROR', SQLERRM);
788: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
789: Fnd_Message.Set_Token('PARAMETERS',
790: ' Parent_Id= ' || to_char(P_Parent_Id) ||
791: ', Calling_Module= ' || P_Calling_Module ||
792: ', Undo_Awt_Date= ' || to_char(P_Undo_Awt_Date,'YYYY/MM/DD'));
793: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 793: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

789: Fnd_Message.Set_Token('PARAMETERS',
790: ' Parent_Id= ' || to_char(P_Parent_Id) ||
791: ', Calling_Module= ' || P_Calling_Module ||
792: ', Undo_Awt_Date= ' || to_char(P_Undo_Awt_Date,'YYYY/MM/DD'));
793: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
794: END IF;
795:
796: App_Exception.Raise_Exception;
797:

Line 868: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

864: IF (DEBUG_Var = 'Y') THEN
865: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - JL_AR_AP_VOID_SELEC_CERTIF - Error:'||SQLERRM);
866: END IF;
867: -- End Debug
868: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
869: Fnd_Message.Set_Token('ERROR', SQLERRM);
870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
871: Fnd_Message.Set_Token('PARAMETERS',
872: ', Checkrun Name = ' || P_Checkrun_name);

Line 869: Fnd_Message.Set_Token('ERROR', SQLERRM);

865: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('EXCEPTION - JL_AR_AP_VOID_SELEC_CERTIF - Error:'||SQLERRM);
866: END IF;
867: -- End Debug
868: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
869: Fnd_Message.Set_Token('ERROR', SQLERRM);
870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
871: Fnd_Message.Set_Token('PARAMETERS',
872: ', Checkrun Name = ' || P_Checkrun_name);
873: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

866: END IF;
867: -- End Debug
868: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
869: Fnd_Message.Set_Token('ERROR', SQLERRM);
870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
871: Fnd_Message.Set_Token('PARAMETERS',
872: ', Checkrun Name = ' || P_Checkrun_name);
873: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
874: END IF;

Line 871: Fnd_Message.Set_Token('PARAMETERS',

867: -- End Debug
868: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
869: Fnd_Message.Set_Token('ERROR', SQLERRM);
870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
871: Fnd_Message.Set_Token('PARAMETERS',
872: ', Checkrun Name = ' || P_Checkrun_name);
873: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
874: END IF;
875:

Line 873: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

869: Fnd_Message.Set_Token('ERROR', SQLERRM);
870: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
871: Fnd_Message.Set_Token('PARAMETERS',
872: ', Checkrun Name = ' || P_Checkrun_name);
873: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
874: END IF;
875:
876:
877: END JL_AR_AP_VOID_SELEC_CERTIF;

Line 1014: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

1010:
1011: EXCEPTION
1012: WHEN others THEN
1013: IF (SQLCODE <> -20001) THEN
1014: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1015: Fnd_Message.Set_Token('ERROR', SQLERRM);
1016: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1017: Fnd_Message.Set_Token('PARAMETERS',
1018: ' Invoice Id= ' || to_char(P_Invoice_Id) ||

Line 1015: Fnd_Message.Set_Token('ERROR', SQLERRM);

1011: EXCEPTION
1012: WHEN others THEN
1013: IF (SQLCODE <> -20001) THEN
1014: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1015: Fnd_Message.Set_Token('ERROR', SQLERRM);
1016: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1017: Fnd_Message.Set_Token('PARAMETERS',
1018: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
1019: ', Payment Num= ' || to_char(P_Payment_Num) ||

Line 1016: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

1012: WHEN others THEN
1013: IF (SQLCODE <> -20001) THEN
1014: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1015: Fnd_Message.Set_Token('ERROR', SQLERRM);
1016: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1017: Fnd_Message.Set_Token('PARAMETERS',
1018: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
1019: ', Payment Num= ' || to_char(P_Payment_Num) ||
1020: ', Checkrun Name= ' || P_Checkrun_Name ||

Line 1017: Fnd_Message.Set_Token('PARAMETERS',

1013: IF (SQLCODE <> -20001) THEN
1014: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1015: Fnd_Message.Set_Token('ERROR', SQLERRM);
1016: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1017: Fnd_Message.Set_Token('PARAMETERS',
1018: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
1019: ', Payment Num= ' || to_char(P_Payment_Num) ||
1020: ', Checkrun Name= ' || P_Checkrun_Name ||
1021: ', Undo Awt Date= ' || to_char(P_Undo_Awt_Date,'YYYY/MM/DD') ||

Line 1023: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

1019: ', Payment Num= ' || to_char(P_Payment_Num) ||
1020: ', Checkrun Name= ' || P_Checkrun_Name ||
1021: ', Undo Awt Date= ' || to_char(P_Undo_Awt_Date,'YYYY/MM/DD') ||
1022: ', Calling Module= ' || P_Calling_Module);
1023: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1024: END IF;
1025:
1026: App_Exception.Raise_Exception;
1027:

Line 1182: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

1178: EXCEPTION
1179:
1180: WHEN others THEN
1181: IF (SQLCODE <> -20001) THEN
1182: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1183: Fnd_Message.Set_Token('ERROR', SQLERRM);
1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);
1185: Fnd_Message.Set_Token('PARAMETERS',
1186: ' Payment Instruction ID ' || p_payment_instruction_id );

Line 1183: Fnd_Message.Set_Token('ERROR', SQLERRM);

1179:
1180: WHEN others THEN
1181: IF (SQLCODE <> -20001) THEN
1182: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1183: Fnd_Message.Set_Token('ERROR', SQLERRM);
1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);
1185: Fnd_Message.Set_Token('PARAMETERS',
1186: ' Payment Instruction ID ' || p_payment_instruction_id );
1187: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);

1180: WHEN others THEN
1181: IF (SQLCODE <> -20001) THEN
1182: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1183: Fnd_Message.Set_Token('ERROR', SQLERRM);
1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);
1185: Fnd_Message.Set_Token('PARAMETERS',
1186: ' Payment Instruction ID ' || p_payment_instruction_id );
1187: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1188: END IF;

Line 1185: Fnd_Message.Set_Token('PARAMETERS',

1181: IF (SQLCODE <> -20001) THEN
1182: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1183: Fnd_Message.Set_Token('ERROR', SQLERRM);
1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);
1185: Fnd_Message.Set_Token('PARAMETERS',
1186: ' Payment Instruction ID ' || p_payment_instruction_id );
1187: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1188: END IF;
1189: x_return_status := fnd_api.g_ret_sts_error;

Line 1187: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

1183: Fnd_Message.Set_Token('ERROR', SQLERRM);
1184: Fnd_Message.Set_Token('CALLING_MODULE', p_calling_module);
1185: Fnd_Message.Set_Token('PARAMETERS',
1186: ' Payment Instruction ID ' || p_payment_instruction_id );
1187: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1188: END IF;
1189: x_return_status := fnd_api.g_ret_sts_error;
1190: App_Exception.Raise_Exception;
1191:

Line 1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');

1491: -- End Debug
1492:
1493: EXCEPTION
1494: WHEN Not_Paid_In_Full THEN
1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');
1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);

Line 1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);

1492:
1493: EXCEPTION
1494: WHEN Not_Paid_In_Full THEN
1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');
1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1500: P_AWT_Success := Fnd_Message.Get;

Line 1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);

1493: EXCEPTION
1494: WHEN Not_Paid_In_Full THEN
1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');
1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1500: P_AWT_Success := Fnd_Message.Get;
1501:

Line 1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464

1494: WHEN Not_Paid_In_Full THEN
1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');
1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1500: P_AWT_Success := Fnd_Message.Get;
1501:
1502: WHEN others THEN

Line 1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);

1495: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_PAY_ERROR');
1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1500: P_AWT_Success := Fnd_Message.Get;
1501:
1502: WHEN others THEN
1503: IF (SQLCODE <> -20001) THEN

Line 1500: P_AWT_Success := Fnd_Message.Get;

1496: Fnd_Message.Set_Token('SUPPLIER', l_vendor_name);
1497: Fnd_Message.Set_Token('PAY_SITE', l_vendor_site_code);
1498: --Fnd_Message.Set_Token('PAY_AMOUNT', l_payment_amount); Bug# 2807464
1499: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1500: P_AWT_Success := Fnd_Message.Get;
1501:
1502: WHEN others THEN
1503: IF (SQLCODE <> -20001) THEN
1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

Line 1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

1500: P_AWT_Success := Fnd_Message.Get;
1501:
1502: WHEN others THEN
1503: IF (SQLCODE <> -20001) THEN
1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1505: Fnd_Message.Set_Token('ERROR', SQLERRM);
1506: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1507: Fnd_Message.Set_Token('PARAMETERS',
1508: ' Checkrun Name= ' || P_Checkrun_Name ||

Line 1505: Fnd_Message.Set_Token('ERROR', SQLERRM);

1501:
1502: WHEN others THEN
1503: IF (SQLCODE <> -20001) THEN
1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1505: Fnd_Message.Set_Token('ERROR', SQLERRM);
1506: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1507: Fnd_Message.Set_Token('PARAMETERS',
1508: ' Checkrun Name= ' || P_Checkrun_Name ||
1509: ', Check Id= ' || to_char(P_Check_Id) ||

Line 1506: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

1502: WHEN others THEN
1503: IF (SQLCODE <> -20001) THEN
1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1505: Fnd_Message.Set_Token('ERROR', SQLERRM);
1506: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1507: Fnd_Message.Set_Token('PARAMETERS',
1508: ' Checkrun Name= ' || P_Checkrun_Name ||
1509: ', Check Id= ' || to_char(P_Check_Id) ||
1510: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 1507: Fnd_Message.Set_Token('PARAMETERS',

1503: IF (SQLCODE <> -20001) THEN
1504: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1505: Fnd_Message.Set_Token('ERROR', SQLERRM);
1506: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1507: Fnd_Message.Set_Token('PARAMETERS',
1508: ' Checkrun Name= ' || P_Checkrun_Name ||
1509: ', Check Id= ' || to_char(P_Check_Id) ||
1510: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
1511: ', Calling Module= ' || P_Calling_Module);

Line 1512: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

1508: ' Checkrun Name= ' || P_Checkrun_Name ||
1509: ', Check Id= ' || to_char(P_Check_Id) ||
1510: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
1511: ', Calling Module= ' || P_Calling_Module);
1512: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1513: END IF;
1514:
1515: App_Exception.Raise_Exception;
1516:

Line 1720: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_BATCH_ERROR');

1716: -- End Debug
1717:
1718: ROLLBACK TO Before_Calc_Withholding;
1719:
1720: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_BATCH_ERROR');
1721: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1722: P_AWT_Success := Fnd_Message.Get;
1723:
1724: -- Debug Information

Line 1721: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);

1717:
1718: ROLLBACK TO Before_Calc_Withholding;
1719:
1720: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_BATCH_ERROR');
1721: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1722: P_AWT_Success := Fnd_Message.Get;
1723:
1724: -- Debug Information
1725: IF (DEBUG_Var = 'Y') THEN

Line 1722: P_AWT_Success := Fnd_Message.Get;

1718: ROLLBACK TO Before_Calc_Withholding;
1719:
1720: Fnd_Message.Set_Name ('JL', 'JL_AR_AP_PARTIAL_BATCH_ERROR');
1721: Fnd_Message.Set_Token('WH_AMOUNT', l_total_wh_amount);
1722: P_AWT_Success := Fnd_Message.Get;
1723:
1724: -- Debug Information
1725: IF (DEBUG_Var = 'Y') THEN
1726: JL_ZZ_AP_EXT_AWT_UTIL.Debug (' ==> Calling Reject_Payment_Batch - NOT Pay_in_Full');

Line 1789: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

1785: END IF;
1786: -- End Debug
1787:
1788: IF (SQLCODE <> -20001) THEN
1789: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1790: Fnd_Message.Set_Token('ERROR', SQLERRM);
1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1792: Fnd_Message.Set_Token('PARAMETERS',
1793: ' Checkrun Name= ' || P_Checkrun_Name ||

Line 1790: Fnd_Message.Set_Token('ERROR', SQLERRM);

1786: -- End Debug
1787:
1788: IF (SQLCODE <> -20001) THEN
1789: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1790: Fnd_Message.Set_Token('ERROR', SQLERRM);
1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1792: Fnd_Message.Set_Token('PARAMETERS',
1793: ' Checkrun Name= ' || P_Checkrun_Name ||
1794: ', Calling Module= ' || P_Calling_Module);

Line 1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

1787:
1788: IF (SQLCODE <> -20001) THEN
1789: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1790: Fnd_Message.Set_Token('ERROR', SQLERRM);
1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1792: Fnd_Message.Set_Token('PARAMETERS',
1793: ' Checkrun Name= ' || P_Checkrun_Name ||
1794: ', Calling Module= ' || P_Calling_Module);
1795: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 1792: Fnd_Message.Set_Token('PARAMETERS',

1788: IF (SQLCODE <> -20001) THEN
1789: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
1790: Fnd_Message.Set_Token('ERROR', SQLERRM);
1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1792: Fnd_Message.Set_Token('PARAMETERS',
1793: ' Checkrun Name= ' || P_Checkrun_Name ||
1794: ', Calling Module= ' || P_Calling_Module);
1795: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1796: END IF;

Line 1795: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

1791: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
1792: Fnd_Message.Set_Token('PARAMETERS',
1793: ' Checkrun Name= ' || P_Checkrun_Name ||
1794: ', Calling Module= ' || P_Calling_Module);
1795: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
1796: END IF;
1797: P_AWT_Success := AWT_ERROR;
1798: App_Exception.Raise_Exception;
1799:

Line 2071: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

2067: END IF;
2068: -- end debug
2069:
2070: IF (SQLCODE <> -20001) THEN
2071: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
2072: Fnd_Message.Set_Token('ERROR', SQLERRM);
2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
2074: Fnd_Message.Set_Token('PARAMETERS',
2075: ' Checkrun Name= ' || P_Checkrun_Name ||

Line 2072: Fnd_Message.Set_Token('ERROR', SQLERRM);

2068: -- end debug
2069:
2070: IF (SQLCODE <> -20001) THEN
2071: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
2072: Fnd_Message.Set_Token('ERROR', SQLERRM);
2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
2074: Fnd_Message.Set_Token('PARAMETERS',
2075: ' Checkrun Name= ' || P_Checkrun_Name ||
2076: ', Calling Module= ' || P_Calling_Module);

Line 2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

2069:
2070: IF (SQLCODE <> -20001) THEN
2071: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
2072: Fnd_Message.Set_Token('ERROR', SQLERRM);
2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
2074: Fnd_Message.Set_Token('PARAMETERS',
2075: ' Checkrun Name= ' || P_Checkrun_Name ||
2076: ', Calling Module= ' || P_Calling_Module);
2077: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 2074: Fnd_Message.Set_Token('PARAMETERS',

2070: IF (SQLCODE <> -20001) THEN
2071: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
2072: Fnd_Message.Set_Token('ERROR', SQLERRM);
2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
2074: Fnd_Message.Set_Token('PARAMETERS',
2075: ' Checkrun Name= ' || P_Checkrun_Name ||
2076: ', Calling Module= ' || P_Calling_Module);
2077: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
2078: END IF;

Line 2077: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

2073: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
2074: Fnd_Message.Set_Token('PARAMETERS',
2075: ' Checkrun Name= ' || P_Checkrun_Name ||
2076: ', Calling Module= ' || P_Calling_Module);
2077: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
2078: END IF;
2079:
2080: App_Exception.Raise_Exception;
2081:

Line 3034: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

3030:
3031: EXCEPTION
3032: WHEN others THEN
3033: IF (SQLCODE <> -20001) THEN
3034: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3035: Fnd_Message.Set_Token('ERROR', SQLERRM);
3036: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3037: Fnd_Message.Set_Token('PARAMETERS',
3038: ' Checkrun Name= ' || P_Checkrun_Name ||

Line 3035: Fnd_Message.Set_Token('ERROR', SQLERRM);

3031: EXCEPTION
3032: WHEN others THEN
3033: IF (SQLCODE <> -20001) THEN
3034: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3035: Fnd_Message.Set_Token('ERROR', SQLERRM);
3036: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3037: Fnd_Message.Set_Token('PARAMETERS',
3038: ' Checkrun Name= ' || P_Checkrun_Name ||
3039: ', Check Id= ' || to_char(P_Check_Id) ||

Line 3036: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

3032: WHEN others THEN
3033: IF (SQLCODE <> -20001) THEN
3034: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3035: Fnd_Message.Set_Token('ERROR', SQLERRM);
3036: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3037: Fnd_Message.Set_Token('PARAMETERS',
3038: ' Checkrun Name= ' || P_Checkrun_Name ||
3039: ', Check Id= ' || to_char(P_Check_Id) ||
3040: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||

Line 3037: Fnd_Message.Set_Token('PARAMETERS',

3033: IF (SQLCODE <> -20001) THEN
3034: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3035: Fnd_Message.Set_Token('ERROR', SQLERRM);
3036: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3037: Fnd_Message.Set_Token('PARAMETERS',
3038: ' Checkrun Name= ' || P_Checkrun_Name ||
3039: ', Check Id= ' || to_char(P_Check_Id) ||
3040: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
3041: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 3043: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

3039: ', Check Id= ' || to_char(P_Check_Id) ||
3040: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
3041: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
3042: ', Calling Module= ' || P_Calling_Module);
3043: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
3044: END IF;
3045: P_AWT_Success := AWT_ERROR;
3046: App_Exception.Raise_Exception;
3047:

Line 3120: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

3116:
3117: EXCEPTION
3118: WHEN others THEN
3119: IF (SQLCODE <> -20001) THEN
3120: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3121: Fnd_Message.Set_Token('ERROR', SQLERRM);
3122: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3123: Fnd_Message.Set_Token('PARAMETERS',
3124: ' Vendor Id= ' || to_char(P_Vendor_Id) ||

Line 3121: Fnd_Message.Set_Token('ERROR', SQLERRM);

3117: EXCEPTION
3118: WHEN others THEN
3119: IF (SQLCODE <> -20001) THEN
3120: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3121: Fnd_Message.Set_Token('ERROR', SQLERRM);
3122: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3123: Fnd_Message.Set_Token('PARAMETERS',
3124: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3125: ', AWT Type Code= ' || P_AWT_Type_Code ||

Line 3122: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

3118: WHEN others THEN
3119: IF (SQLCODE <> -20001) THEN
3120: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3121: Fnd_Message.Set_Token('ERROR', SQLERRM);
3122: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3123: Fnd_Message.Set_Token('PARAMETERS',
3124: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3125: ', AWT Type Code= ' || P_AWT_Type_Code ||
3126: ', Tax Id= ' || to_char(P_Tax_Id));

Line 3123: Fnd_Message.Set_Token('PARAMETERS',

3119: IF (SQLCODE <> -20001) THEN
3120: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3121: Fnd_Message.Set_Token('ERROR', SQLERRM);
3122: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3123: Fnd_Message.Set_Token('PARAMETERS',
3124: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3125: ', AWT Type Code= ' || P_AWT_Type_Code ||
3126: ', Tax Id= ' || to_char(P_Tax_Id));
3127: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 3127: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

3123: Fnd_Message.Set_Token('PARAMETERS',
3124: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3125: ', AWT Type Code= ' || P_AWT_Type_Code ||
3126: ', Tax Id= ' || to_char(P_Tax_Id));
3127: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
3128: END IF;
3129:
3130: App_Exception.Raise_Exception;
3131:

Line 3354: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

3350:
3351: EXCEPTION
3352: WHEN others THEN
3353: IF (SQLCODE <> -20001) THEN
3354: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3355: Fnd_Message.Set_Token('ERROR', SQLERRM);
3356: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3357: Fnd_Message.Set_Token('PARAMETERS',
3358: ' Vendor Id= ' || to_char(P_Vendor_Id) ||

Line 3355: Fnd_Message.Set_Token('ERROR', SQLERRM);

3351: EXCEPTION
3352: WHEN others THEN
3353: IF (SQLCODE <> -20001) THEN
3354: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3355: Fnd_Message.Set_Token('ERROR', SQLERRM);
3356: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3357: Fnd_Message.Set_Token('PARAMETERS',
3358: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3359: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 3356: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

3352: WHEN others THEN
3353: IF (SQLCODE <> -20001) THEN
3354: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3355: Fnd_Message.Set_Token('ERROR', SQLERRM);
3356: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3357: Fnd_Message.Set_Token('PARAMETERS',
3358: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3359: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
3360: ', GL Period Name= ' || P_GL_Period_Name ||

Line 3357: Fnd_Message.Set_Token('PARAMETERS',

3353: IF (SQLCODE <> -20001) THEN
3354: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3355: Fnd_Message.Set_Token('ERROR', SQLERRM);
3356: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3357: Fnd_Message.Set_Token('PARAMETERS',
3358: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
3359: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
3360: ', GL Period Name= ' || P_GL_Period_Name ||
3361: ', Base Currency Code= ' || P_Base_Currency_Code ||

Line 3367: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

3363: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
3364: ', Calling Module= ' || P_Calling_Module ||
3365: ', Checkrun Name= ' || P_Checkrun_Name ||
3366: ', Payment Num= ' || to_char(P_Payment_Num));
3367: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
3368: END IF;
3369:
3370: App_Exception.Raise_Exception;
3371:

Line 3889: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

3885:
3886: EXCEPTION
3887: WHEN others THEN
3888: IF (SQLCODE <> -20001) THEN
3889: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3890: Fnd_Message.Set_Token('ERROR', SQLERRM);
3891: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3892: Fnd_Message.Set_Token('PARAMETERS',
3893: ' Check Id= ' || to_char(P_Check_Id) ||

Line 3890: Fnd_Message.Set_Token('ERROR', SQLERRM);

3886: EXCEPTION
3887: WHEN others THEN
3888: IF (SQLCODE <> -20001) THEN
3889: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3890: Fnd_Message.Set_Token('ERROR', SQLERRM);
3891: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3892: Fnd_Message.Set_Token('PARAMETERS',
3893: ' Check Id= ' || to_char(P_Check_Id) ||
3894: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||

Line 3891: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

3887: WHEN others THEN
3888: IF (SQLCODE <> -20001) THEN
3889: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3890: Fnd_Message.Set_Token('ERROR', SQLERRM);
3891: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3892: Fnd_Message.Set_Token('PARAMETERS',
3893: ' Check Id= ' || to_char(P_Check_Id) ||
3894: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
3895: ', Currency Code= ' || P_Currency_Code ||

Line 3892: Fnd_Message.Set_Token('PARAMETERS',

3888: IF (SQLCODE <> -20001) THEN
3889: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
3890: Fnd_Message.Set_Token('ERROR', SQLERRM);
3891: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
3892: Fnd_Message.Set_Token('PARAMETERS',
3893: ' Check Id= ' || to_char(P_Check_Id) ||
3894: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
3895: ', Currency Code= ' || P_Currency_Code ||
3896: ', Calling Module= ' || P_Calling_Module);

Line 3897: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

3893: ' Check Id= ' || to_char(P_Check_Id) ||
3894: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
3895: ', Currency Code= ' || P_Currency_Code ||
3896: ', Calling Module= ' || P_Calling_Module);
3897: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
3898: END IF;
3899:
3900: App_Exception.Raise_Exception;
3901:

Line 4063: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4059:
4060: EXCEPTION
4061: WHEN others THEN
4062: IF (SQLCODE <> -20001) THEN
4063: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4064: Fnd_Message.Set_Token('ERROR', SQLERRM);
4065: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4066: Fnd_Message.Set_Token('PARAMETERS',
4067: ' Invoice Id= ' || to_char(P_Invoice_Id) ||

Line 4064: Fnd_Message.Set_Token('ERROR', SQLERRM);

4060: EXCEPTION
4061: WHEN others THEN
4062: IF (SQLCODE <> -20001) THEN
4063: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4064: Fnd_Message.Set_Token('ERROR', SQLERRM);
4065: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4066: Fnd_Message.Set_Token('PARAMETERS',
4067: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
4068: ', Distribution Line No= ' || to_char(P_Distribution_Line_No) ||

Line 4065: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4061: WHEN others THEN
4062: IF (SQLCODE <> -20001) THEN
4063: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4064: Fnd_Message.Set_Token('ERROR', SQLERRM);
4065: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4066: Fnd_Message.Set_Token('PARAMETERS',
4067: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
4068: ', Distribution Line No= ' || to_char(P_Distribution_Line_No) ||
4069: ', Tax Base Amount Basis= ' || P_Tax_Base_Amount_Basis ||

Line 4066: Fnd_Message.Set_Token('PARAMETERS',

4062: IF (SQLCODE <> -20001) THEN
4063: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4064: Fnd_Message.Set_Token('ERROR', SQLERRM);
4065: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4066: Fnd_Message.Set_Token('PARAMETERS',
4067: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
4068: ', Distribution Line No= ' || to_char(P_Distribution_Line_No) ||
4069: ', Tax Base Amount Basis= ' || P_Tax_Base_Amount_Basis ||
4070: ', Tax Inclusive Flag= ' || P_Tax_Inclusive_Flag);

Line 4071: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4067: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
4068: ', Distribution Line No= ' || to_char(P_Distribution_Line_No) ||
4069: ', Tax Base Amount Basis= ' || P_Tax_Base_Amount_Basis ||
4070: ', Tax Inclusive Flag= ' || P_Tax_Inclusive_Flag);
4071: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4072: END IF;
4073:
4074: App_Exception.Raise_Exception;
4075:

Line 4155: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4151: RETURN 0;
4152:
4153: WHEN others THEN
4154: IF (SQLCODE <> -20001) THEN
4155: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4156: Fnd_Message.Set_Token('ERROR', SQLERRM);
4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4158: Fnd_Message.Set_Token('PARAMETERS',
4159: ' Vendor Id= ' || to_char(P_Vendor_Id) ||

Line 4156: Fnd_Message.Set_Token('ERROR', SQLERRM);

4152:
4153: WHEN others THEN
4154: IF (SQLCODE <> -20001) THEN
4155: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4156: Fnd_Message.Set_Token('ERROR', SQLERRM);
4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4158: Fnd_Message.Set_Token('PARAMETERS',
4159: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4160: ', AWT Type Code= ' || P_AWT_Type_Code);

Line 4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4153: WHEN others THEN
4154: IF (SQLCODE <> -20001) THEN
4155: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4156: Fnd_Message.Set_Token('ERROR', SQLERRM);
4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4158: Fnd_Message.Set_Token('PARAMETERS',
4159: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4160: ', AWT Type Code= ' || P_AWT_Type_Code);
4161: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 4158: Fnd_Message.Set_Token('PARAMETERS',

4154: IF (SQLCODE <> -20001) THEN
4155: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4156: Fnd_Message.Set_Token('ERROR', SQLERRM);
4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4158: Fnd_Message.Set_Token('PARAMETERS',
4159: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4160: ', AWT Type Code= ' || P_AWT_Type_Code);
4161: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4162: END IF;

Line 4161: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4157: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4158: Fnd_Message.Set_Token('PARAMETERS',
4159: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4160: ', AWT Type Code= ' || P_AWT_Type_Code);
4161: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4162: END IF;
4163:
4164: App_Exception.Raise_Exception;
4165:

Line 4379: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4375:
4376: EXCEPTION
4377: WHEN others THEN
4378: IF (SQLCODE <> -20001) THEN
4379: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4380: Fnd_Message.Set_Token('ERROR', SQLERRM);
4381: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4382: Fnd_Message.Set_Token('PARAMETERS',
4383: ' Vendor_Id= ' || to_char(P_Vendor_Id) ||

Line 4380: Fnd_Message.Set_Token('ERROR', SQLERRM);

4376: EXCEPTION
4377: WHEN others THEN
4378: IF (SQLCODE <> -20001) THEN
4379: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4380: Fnd_Message.Set_Token('ERROR', SQLERRM);
4381: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4382: Fnd_Message.Set_Token('PARAMETERS',
4383: ' Vendor_Id= ' || to_char(P_Vendor_Id) ||
4384: ', AWT_Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 4381: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4377: WHEN others THEN
4378: IF (SQLCODE <> -20001) THEN
4379: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4380: Fnd_Message.Set_Token('ERROR', SQLERRM);
4381: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4382: Fnd_Message.Set_Token('PARAMETERS',
4383: ' Vendor_Id= ' || to_char(P_Vendor_Id) ||
4384: ', AWT_Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
4385: ', Payment_Num= ' || to_char(P_Payment_Num) ||

Line 4382: Fnd_Message.Set_Token('PARAMETERS',

4378: IF (SQLCODE <> -20001) THEN
4379: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4380: Fnd_Message.Set_Token('ERROR', SQLERRM);
4381: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4382: Fnd_Message.Set_Token('PARAMETERS',
4383: ' Vendor_Id= ' || to_char(P_Vendor_Id) ||
4384: ', AWT_Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
4385: ', Payment_Num= ' || to_char(P_Payment_Num) ||
4386: ', Check_Id= ' || to_char(P_Check_Id) ||

Line 4388: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4384: ', AWT_Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
4385: ', Payment_Num= ' || to_char(P_Payment_Num) ||
4386: ', Check_Id= ' || to_char(P_Check_Id) ||
4387: ', Selected_Check_Id= ' || to_char(P_Selected_Check_Id));
4388: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4389: END IF;
4390:
4391: App_Exception.Raise_Exception;
4392:

Line 4496: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4492:
4493: EXCEPTION
4494: WHEN others THEN
4495: IF (SQLCODE <> -20001) THEN
4496: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4497: Fnd_Message.Set_Token('ERROR', SQLERRM);
4498: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4499: Fnd_Message.Set_Token('PARAMETERS',
4500: ' Vendor Id= ' || to_char(P_Vendor_Id) ||

Line 4497: Fnd_Message.Set_Token('ERROR', SQLERRM);

4493: EXCEPTION
4494: WHEN others THEN
4495: IF (SQLCODE <> -20001) THEN
4496: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4497: Fnd_Message.Set_Token('ERROR', SQLERRM);
4498: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4499: Fnd_Message.Set_Token('PARAMETERS',
4500: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4501: ', AWT Type Code= ' || P_AWT_Type_Code ||

Line 4498: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4494: WHEN others THEN
4495: IF (SQLCODE <> -20001) THEN
4496: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4497: Fnd_Message.Set_Token('ERROR', SQLERRM);
4498: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4499: Fnd_Message.Set_Token('PARAMETERS',
4500: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4501: ', AWT Type Code= ' || P_AWT_Type_Code ||
4502: ', Tax Id= ' || to_char(P_Tax_Id) ||

Line 4499: Fnd_Message.Set_Token('PARAMETERS',

4495: IF (SQLCODE <> -20001) THEN
4496: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4497: Fnd_Message.Set_Token('ERROR', SQLERRM);
4498: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4499: Fnd_Message.Set_Token('PARAMETERS',
4500: ' Vendor Id= ' || to_char(P_Vendor_Id) ||
4501: ', AWT Type Code= ' || P_AWT_Type_Code ||
4502: ', Tax Id= ' || to_char(P_Tax_Id) ||
4503: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 4511: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4507: ', Status= ' || P_Status ||
4508: ', Payment Num= ' || to_char(P_Payment_Num) ||
4509: ', Check Id= ' || to_char(P_Check_Id) ||
4510: ', Selected Check Id= ' || to_char(P_Selected_Check_Id));
4511: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4512: END IF;
4513:
4514: App_Exception.Raise_Exception;
4515:

Line 4693: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4689:
4690: EXCEPTION
4691: WHEN others THEN
4692: IF (SQLCODE <> -20001) THEN
4693: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4694: Fnd_Message.Set_Token('ERROR', SQLERRM);
4695: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4696: Fnd_Message.Set_Token('PARAMETERS',
4697: ' Check Id= ' || to_char(P_Check_Id) ||

Line 4694: Fnd_Message.Set_Token('ERROR', SQLERRM);

4690: EXCEPTION
4691: WHEN others THEN
4692: IF (SQLCODE <> -20001) THEN
4693: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4694: Fnd_Message.Set_Token('ERROR', SQLERRM);
4695: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4696: Fnd_Message.Set_Token('PARAMETERS',
4697: ' Check Id= ' || to_char(P_Check_Id) ||
4698: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||

Line 4695: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4691: WHEN others THEN
4692: IF (SQLCODE <> -20001) THEN
4693: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4694: Fnd_Message.Set_Token('ERROR', SQLERRM);
4695: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4696: Fnd_Message.Set_Token('PARAMETERS',
4697: ' Check Id= ' || to_char(P_Check_Id) ||
4698: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
4699: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||

Line 4696: Fnd_Message.Set_Token('PARAMETERS',

4692: IF (SQLCODE <> -20001) THEN
4693: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4694: Fnd_Message.Set_Token('ERROR', SQLERRM);
4695: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4696: Fnd_Message.Set_Token('PARAMETERS',
4697: ' Check Id= ' || to_char(P_Check_Id) ||
4698: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
4699: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
4700: ', Payment Num= ' || to_char(P_Payment_Num));

Line 4701: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4697: ' Check Id= ' || to_char(P_Check_Id) ||
4698: ', Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
4699: ', AWT Date= ' || to_char(P_AWT_Date,'YYYY/MM/DD') ||
4700: ', Payment Num= ' || to_char(P_Payment_Num));
4701: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4702: END IF;
4703:
4704: App_Exception.Raise_Exception;
4705:

Line 4973: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

4969:
4970: EXCEPTION
4971: WHEN others THEN
4972: IF (SQLCODE <> -20001) THEN
4973: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4974: Fnd_Message.Set_Token('ERROR', SQLERRM);
4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4976: Fnd_Message.Set_Token('PARAMETERS',
4977: ' Check Id= ' || to_char(P_Check_Id));

Line 4974: Fnd_Message.Set_Token('ERROR', SQLERRM);

4970: EXCEPTION
4971: WHEN others THEN
4972: IF (SQLCODE <> -20001) THEN
4973: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4974: Fnd_Message.Set_Token('ERROR', SQLERRM);
4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4976: Fnd_Message.Set_Token('PARAMETERS',
4977: ' Check Id= ' || to_char(P_Check_Id));
4978: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

4971: WHEN others THEN
4972: IF (SQLCODE <> -20001) THEN
4973: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4974: Fnd_Message.Set_Token('ERROR', SQLERRM);
4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4976: Fnd_Message.Set_Token('PARAMETERS',
4977: ' Check Id= ' || to_char(P_Check_Id));
4978: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4979: END IF;

Line 4976: Fnd_Message.Set_Token('PARAMETERS',

4972: IF (SQLCODE <> -20001) THEN
4973: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
4974: Fnd_Message.Set_Token('ERROR', SQLERRM);
4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4976: Fnd_Message.Set_Token('PARAMETERS',
4977: ' Check Id= ' || to_char(P_Check_Id));
4978: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4979: END IF;
4980:

Line 4978: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

4974: Fnd_Message.Set_Token('ERROR', SQLERRM);
4975: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
4976: Fnd_Message.Set_Token('PARAMETERS',
4977: ' Check Id= ' || to_char(P_Check_Id));
4978: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
4979: END IF;
4980:
4981: App_Exception.Raise_Exception;
4982:

Line 5303: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5299:
5300: EXCEPTION
5301: WHEN others THEN
5302: IF (SQLCODE <> -20001) THEN
5303: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5304: Fnd_Message.Set_Token('ERROR', SQLERRM);
5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5306: Fnd_Message.Set_Token('PARAMETERS',
5307: ' Checkrun Name= ' || P_Checkrun_Name ||

Line 5304: Fnd_Message.Set_Token('ERROR', SQLERRM);

5300: EXCEPTION
5301: WHEN others THEN
5302: IF (SQLCODE <> -20001) THEN
5303: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5304: Fnd_Message.Set_Token('ERROR', SQLERRM);
5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5306: Fnd_Message.Set_Token('PARAMETERS',
5307: ' Checkrun Name= ' || P_Checkrun_Name ||
5308: ', Selected Check Id= ' || to_char(P_Selected_Check_Id));

Line 5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5301: WHEN others THEN
5302: IF (SQLCODE <> -20001) THEN
5303: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5304: Fnd_Message.Set_Token('ERROR', SQLERRM);
5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5306: Fnd_Message.Set_Token('PARAMETERS',
5307: ' Checkrun Name= ' || P_Checkrun_Name ||
5308: ', Selected Check Id= ' || to_char(P_Selected_Check_Id));
5309: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 5306: Fnd_Message.Set_Token('PARAMETERS',

5302: IF (SQLCODE <> -20001) THEN
5303: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5304: Fnd_Message.Set_Token('ERROR', SQLERRM);
5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5306: Fnd_Message.Set_Token('PARAMETERS',
5307: ' Checkrun Name= ' || P_Checkrun_Name ||
5308: ', Selected Check Id= ' || to_char(P_Selected_Check_Id));
5309: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5310: END IF;

Line 5309: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5305: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5306: Fnd_Message.Set_Token('PARAMETERS',
5307: ' Checkrun Name= ' || P_Checkrun_Name ||
5308: ', Selected Check Id= ' || to_char(P_Selected_Check_Id));
5309: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5310: END IF;
5311:
5312: App_Exception.Raise_Exception;
5313:

Line 5426: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5422:
5423: EXCEPTION
5424: WHEN others THEN
5425: IF (SQLCODE <> -20001) THEN
5426: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5427: Fnd_Message.Set_Token('ERROR', SQLERRM);
5428: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5429: Fnd_Message.Set_Token('PARAMETERS',
5430: ' Invoice Id= ' || to_char(P_Invoice_Id) ||

Line 5427: Fnd_Message.Set_Token('ERROR', SQLERRM);

5423: EXCEPTION
5424: WHEN others THEN
5425: IF (SQLCODE <> -20001) THEN
5426: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5427: Fnd_Message.Set_Token('ERROR', SQLERRM);
5428: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5429: Fnd_Message.Set_Token('PARAMETERS',
5430: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
5431: ', Tax Name= ' || P_Tax_Name ||

Line 5428: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5424: WHEN others THEN
5425: IF (SQLCODE <> -20001) THEN
5426: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5427: Fnd_Message.Set_Token('ERROR', SQLERRM);
5428: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5429: Fnd_Message.Set_Token('PARAMETERS',
5430: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
5431: ', Tax Name= ' || P_Tax_Name ||
5432: ', Taxable Base Amount Basis= ' || P_Taxable_Base_Amount_Basis);

Line 5429: Fnd_Message.Set_Token('PARAMETERS',

5425: IF (SQLCODE <> -20001) THEN
5426: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5427: Fnd_Message.Set_Token('ERROR', SQLERRM);
5428: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5429: Fnd_Message.Set_Token('PARAMETERS',
5430: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
5431: ', Tax Name= ' || P_Tax_Name ||
5432: ', Taxable Base Amount Basis= ' || P_Taxable_Base_Amount_Basis);
5433: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 5433: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5429: Fnd_Message.Set_Token('PARAMETERS',
5430: ' Invoice Id= ' || to_char(P_Invoice_Id) ||
5431: ', Tax Name= ' || P_Tax_Name ||
5432: ', Taxable Base Amount Basis= ' || P_Taxable_Base_Amount_Basis);
5433: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5434: END IF;
5435:
5436: App_Exception.Raise_Exception;
5437:

Line 5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5491:
5492: EXCEPTION
5493: WHEN others THEN
5494: IF (SQLCODE <> -20001) THEN
5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5496: Fnd_Message.Set_Token('ERROR', SQLERRM);
5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5498: Fnd_Message.Set_Token('PARAMETERS', null);
5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 5496: Fnd_Message.Set_Token('ERROR', SQLERRM);

5492: EXCEPTION
5493: WHEN others THEN
5494: IF (SQLCODE <> -20001) THEN
5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5496: Fnd_Message.Set_Token('ERROR', SQLERRM);
5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5498: Fnd_Message.Set_Token('PARAMETERS', null);
5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5500: END IF;

Line 5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5493: WHEN others THEN
5494: IF (SQLCODE <> -20001) THEN
5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5496: Fnd_Message.Set_Token('ERROR', SQLERRM);
5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5498: Fnd_Message.Set_Token('PARAMETERS', null);
5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5500: END IF;
5501:

Line 5498: Fnd_Message.Set_Token('PARAMETERS', null);

5494: IF (SQLCODE <> -20001) THEN
5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5496: Fnd_Message.Set_Token('ERROR', SQLERRM);
5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5498: Fnd_Message.Set_Token('PARAMETERS', null);
5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5500: END IF;
5501:
5502: App_Exception.Raise_Exception;

Line 5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5495: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5496: Fnd_Message.Set_Token('ERROR', SQLERRM);
5497: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5498: Fnd_Message.Set_Token('PARAMETERS', null);
5499: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5500: END IF;
5501:
5502: App_Exception.Raise_Exception;
5503:

Line 5628: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5624:
5625: EXCEPTION
5626: WHEN others THEN
5627: IF (SQLCODE <> -20001) THEN
5628: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5629: Fnd_Message.Set_Token('ERROR', SQLERRM);
5630: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5631: Fnd_Message.Set_Token('PARAMETERS',
5632: ' Check Id= ' || to_char(P_Check_Id) ||

Line 5629: Fnd_Message.Set_Token('ERROR', SQLERRM);

5625: EXCEPTION
5626: WHEN others THEN
5627: IF (SQLCODE <> -20001) THEN
5628: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5629: Fnd_Message.Set_Token('ERROR', SQLERRM);
5630: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5631: Fnd_Message.Set_Token('PARAMETERS',
5632: ' Check Id= ' || to_char(P_Check_Id) ||
5633: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||

Line 5630: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5626: WHEN others THEN
5627: IF (SQLCODE <> -20001) THEN
5628: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5629: Fnd_Message.Set_Token('ERROR', SQLERRM);
5630: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5631: Fnd_Message.Set_Token('PARAMETERS',
5632: ' Check Id= ' || to_char(P_Check_Id) ||
5633: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
5634: ', Calling Module= ' || P_Calling_Module ||

Line 5631: Fnd_Message.Set_Token('PARAMETERS',

5627: IF (SQLCODE <> -20001) THEN
5628: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5629: Fnd_Message.Set_Token('ERROR', SQLERRM);
5630: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5631: Fnd_Message.Set_Token('PARAMETERS',
5632: ' Check Id= ' || to_char(P_Check_Id) ||
5633: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
5634: ', Calling Module= ' || P_Calling_Module ||
5635: ', Total Wh Amount= ' || to_char(P_Total_Wh_Amount));

Line 5636: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5632: ' Check Id= ' || to_char(P_Check_Id) ||
5633: ', Selected Check_Id= ' || to_char(P_Selected_Check_Id) ||
5634: ', Calling Module= ' || P_Calling_Module ||
5635: ', Total Wh Amount= ' || to_char(P_Total_Wh_Amount));
5636: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5637: END IF;
5638:
5639: App_Exception.Raise_Exception;
5640:

Line 5744: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5740: END IF;
5741: -- end debug
5742:
5743: IF (SQLCODE <> -20001) THEN
5744: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5745: Fnd_Message.Set_Token('ERROR', SQLERRM);
5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5747: Fnd_Message.Set_Token('PARAMETERS',
5748: ' Checkrun Name= ' || P_Checkrun_Name);

Line 5745: Fnd_Message.Set_Token('ERROR', SQLERRM);

5741: -- end debug
5742:
5743: IF (SQLCODE <> -20001) THEN
5744: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5745: Fnd_Message.Set_Token('ERROR', SQLERRM);
5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5747: Fnd_Message.Set_Token('PARAMETERS',
5748: ' Checkrun Name= ' || P_Checkrun_Name);
5749: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5742:
5743: IF (SQLCODE <> -20001) THEN
5744: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5745: Fnd_Message.Set_Token('ERROR', SQLERRM);
5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5747: Fnd_Message.Set_Token('PARAMETERS',
5748: ' Checkrun Name= ' || P_Checkrun_Name);
5749: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5750: END IF;

Line 5747: Fnd_Message.Set_Token('PARAMETERS',

5743: IF (SQLCODE <> -20001) THEN
5744: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5745: Fnd_Message.Set_Token('ERROR', SQLERRM);
5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5747: Fnd_Message.Set_Token('PARAMETERS',
5748: ' Checkrun Name= ' || P_Checkrun_Name);
5749: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5750: END IF;
5751:

Line 5749: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5745: Fnd_Message.Set_Token('ERROR', SQLERRM);
5746: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5747: Fnd_Message.Set_Token('PARAMETERS',
5748: ' Checkrun Name= ' || P_Checkrun_Name);
5749: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5750: END IF;
5751:
5752: App_Exception.Raise_Exception;
5753:

Line 5859: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

5855:
5856: EXCEPTION
5857: WHEN others THEN
5858: IF (SQLCODE <> -20001) THEN
5859: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5860: Fnd_Message.Set_Token('ERROR', SQLERRM);
5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5862: Fnd_Message.Set_Token('PARAMETERS',
5863: ' Selected Check Id= ' || to_char(P_Selected_Check_Id) ||

Line 5860: Fnd_Message.Set_Token('ERROR', SQLERRM);

5856: EXCEPTION
5857: WHEN others THEN
5858: IF (SQLCODE <> -20001) THEN
5859: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5860: Fnd_Message.Set_Token('ERROR', SQLERRM);
5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5862: Fnd_Message.Set_Token('PARAMETERS',
5863: ' Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
5864: ', AWT Success= ' || P_AWT_Success);

Line 5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

5857: WHEN others THEN
5858: IF (SQLCODE <> -20001) THEN
5859: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5860: Fnd_Message.Set_Token('ERROR', SQLERRM);
5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5862: Fnd_Message.Set_Token('PARAMETERS',
5863: ' Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
5864: ', AWT Success= ' || P_AWT_Success);
5865: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 5862: Fnd_Message.Set_Token('PARAMETERS',

5858: IF (SQLCODE <> -20001) THEN
5859: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
5860: Fnd_Message.Set_Token('ERROR', SQLERRM);
5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5862: Fnd_Message.Set_Token('PARAMETERS',
5863: ' Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
5864: ', AWT Success= ' || P_AWT_Success);
5865: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5866: END IF;

Line 5865: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

5861: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
5862: Fnd_Message.Set_Token('PARAMETERS',
5863: ' Selected Check Id= ' || to_char(P_Selected_Check_Id) ||
5864: ', AWT Success= ' || P_AWT_Success);
5865: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
5866: END IF;
5867:
5868: App_Exception.Raise_Exception;
5869:

Line 6231: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');

6227:
6228: EXCEPTION
6229: WHEN others THEN
6230: IF (SQLCODE <> -20001) THEN
6231: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
6232: Fnd_Message.Set_Token('ERROR', SQLERRM);
6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
6234: Fnd_Message.Set_Token('PARAMETERS',
6235: ' Check Id= ' || to_char(P_Check_Id));

Line 6232: Fnd_Message.Set_Token('ERROR', SQLERRM);

6228: EXCEPTION
6229: WHEN others THEN
6230: IF (SQLCODE <> -20001) THEN
6231: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
6232: Fnd_Message.Set_Token('ERROR', SQLERRM);
6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
6234: Fnd_Message.Set_Token('PARAMETERS',
6235: ' Check Id= ' || to_char(P_Check_Id));
6236: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

Line 6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);

6229: WHEN others THEN
6230: IF (SQLCODE <> -20001) THEN
6231: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
6232: Fnd_Message.Set_Token('ERROR', SQLERRM);
6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
6234: Fnd_Message.Set_Token('PARAMETERS',
6235: ' Check Id= ' || to_char(P_Check_Id));
6236: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
6237: END IF;

Line 6234: Fnd_Message.Set_Token('PARAMETERS',

6230: IF (SQLCODE <> -20001) THEN
6231: Fnd_Message.Set_Name ('JL', 'JL_ZZ_AP_DEBUG');
6232: Fnd_Message.Set_Token('ERROR', SQLERRM);
6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
6234: Fnd_Message.Set_Token('PARAMETERS',
6235: ' Check Id= ' || to_char(P_Check_Id));
6236: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
6237: END IF;
6238: App_Exception.Raise_Exception;

Line 6236: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);

6232: Fnd_Message.Set_Token('ERROR', SQLERRM);
6233: Fnd_Message.Set_Token('CALLING_SEQUENCE', l_calling_sequence);
6234: Fnd_Message.Set_Token('PARAMETERS',
6235: ' Check Id= ' || to_char(P_Check_Id));
6236: Fnd_Message.Set_Token('DEBUG_INFO', l_debug_info);
6237: END IF;
6238: App_Exception.Raise_Exception;
6239:
6240: END Undo_Quick_Payment;