645:
646: EXCEPTION
647: WHEN OTHERS THEN
648: IF (SQLCODE <> -20001) THEN
649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
652: FND_MESSAGE.SET_TOKEN('PARAMETERS',
653: ' OLD_CHECK_ID = ' ||TO_CHAR(P_Old_Check_Id)
646: EXCEPTION
647: WHEN OTHERS THEN
648: IF (SQLCODE <> -20001) THEN
649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
652: FND_MESSAGE.SET_TOKEN('PARAMETERS',
653: ' OLD_CHECK_ID = ' ||TO_CHAR(P_Old_Check_Id)
654: ||', REPLACE_CHECK_DATE = ' ||TO_CHAR(P_Replace_Check_Date)
647: WHEN OTHERS THEN
648: IF (SQLCODE <> -20001) THEN
649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
652: FND_MESSAGE.SET_TOKEN('PARAMETERS',
653: ' OLD_CHECK_ID = ' ||TO_CHAR(P_Old_Check_Id)
654: ||', REPLACE_CHECK_DATE = ' ||TO_CHAR(P_Replace_Check_Date)
655: ||', REPLACE_PERIOD_NAME = ' ||P_Replace_Period_Name
648: IF (SQLCODE <> -20001) THEN
649: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
650: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
651: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
652: FND_MESSAGE.SET_TOKEN('PARAMETERS',
653: ' OLD_CHECK_ID = ' ||TO_CHAR(P_Old_Check_Id)
654: ||', REPLACE_CHECK_DATE = ' ||TO_CHAR(P_Replace_Check_Date)
655: ||', REPLACE_PERIOD_NAME = ' ||P_Replace_Period_Name
656: ||', REPLACE_CHECK_NUM = ' ||TO_CHAR(P_Replace_Check_Num)
658: ||', ORIG_AMOUNT = ' ||TO_CHAR(P_Orig_Amount)
659: ||', ORIG_PAYMENT_DATE = ' ||TO_CHAR(P_Orig_Payment_Date)
660: ||', LAST_UPDATED_BY = ' ||TO_CHAR(P_Last_Updated_By)
661: ||', FUTURE_PAY_CCID = ' ||TO_CHAR(P_Future_Pay_Ccid));
662: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
663: END IF;
664: APP_EXCEPTION.RAISE_EXCEPTION;
665:
666: END Replace_Check;