311: EXCEPTION
312: WHEN OTHERS then
313:
314: if (SQLCODE <> -20001 ) then
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
319: ||', Payment_num = '||TO_CHAR(P_payment_num)
312: WHEN OTHERS then
313:
314: if (SQLCODE <> -20001 ) then
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
319: ||', Payment_num = '||TO_CHAR(P_payment_num)
320: ||', Check_id = '||TO_CHAR(P_check_id)
313:
314: if (SQLCODE <> -20001 ) then
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
319: ||', Payment_num = '||TO_CHAR(P_payment_num)
320: ||', Check_id = '||TO_CHAR(P_check_id)
321: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)
314: if (SQLCODE <> -20001 ) then
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
319: ||', Payment_num = '||TO_CHAR(P_payment_num)
320: ||', Check_id = '||TO_CHAR(P_check_id)
321: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)
322: ||', Old Invoice_payment_id = '||TO_CHAR(P_old_invoice_payment_id)
369: ||', payment_dists_flag = '||P_payment_dists_flag
370: ||', payment_mode = '||P_payment_mode
371: ||', replace_flag = '||P_replace_flag);
372:
373: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
374: end if;
375:
376: APP_EXCEPTION.RAISE_EXCEPTION;
377:
417: Exception
418: WHEN OTHERS then
419:
420: if (SQLCODE <> -20001 ) then
421: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
422: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
423: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
424: FND_MESSAGE.SET_TOKEN('PARAMETERS'
425: ,' Invoice_Payment_Id = '||TO_CHAR(P_invoice_payment_id)
418: WHEN OTHERS then
419:
420: if (SQLCODE <> -20001 ) then
421: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
422: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
423: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
424: FND_MESSAGE.SET_TOKEN('PARAMETERS'
425: ,' Invoice_Payment_Id = '||TO_CHAR(P_invoice_payment_id)
426: ||', Amount = '||TO_CHAR(P_amount)
419:
420: if (SQLCODE <> -20001 ) then
421: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
422: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
423: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
424: FND_MESSAGE.SET_TOKEN('PARAMETERS'
425: ,' Invoice_Payment_Id = '||TO_CHAR(P_invoice_payment_id)
426: ||', Amount = '||TO_CHAR(P_amount)
427: ||', Invoice_Base_Amount = '||TO_CHAR(P_Invoice_Base_Amount)
420: if (SQLCODE <> -20001 ) then
421: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
422: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
423: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
424: FND_MESSAGE.SET_TOKEN('PARAMETERS'
425: ,' Invoice_Payment_Id = '||TO_CHAR(P_invoice_payment_id)
426: ||', Amount = '||TO_CHAR(P_amount)
427: ||', Invoice_Base_Amount = '||TO_CHAR(P_Invoice_Base_Amount)
428: ||', Payment_Base_Amount = '||TO_CHAR(P_Payment_Base_Amount));
426: ||', Amount = '||TO_CHAR(P_amount)
427: ||', Invoice_Base_Amount = '||TO_CHAR(P_Invoice_Base_Amount)
428: ||', Payment_Base_Amount = '||TO_CHAR(P_Payment_Base_Amount));
429:
430: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
431: end if;
432:
433: APP_EXCEPTION.RAISE_EXCEPTION;
434: