102: AND nvl(p_check_rec.check_date, sysdate) BETWEEN SA.START_DATE
103: AND nvl(SA.END_DATE, TO_DATE('31/12/4712','DD/MM/YYYY'));
104: EXCEPTION
105: WHEN NO_DATA_FOUND THEN
106: FND_Message.set_name('SQLAP', 'AP_SEQ_DOC_CAT_NO_FOUND');
107: APP_EXCEPTION.RAISE_EXCEPTION;
108: END;
109:
110: -------------------------------------------------------------------------
119: l_dbseqid,
120: 'N',
121: 'N');
122: IF ((l_doc_sequence_value IS NULL) OR (l_return_code <> 0)) THEN
123: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_CREATE_ERROR');
124: APP_EXCEPTION.RAISE_EXCEPTION;
125: END IF;
126: END IF;
127:
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: IF (SQLCODE <> -20001) THEN
377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
381: END IF;
374: EXCEPTION
375: WHEN OTHERS THEN
376: IF (SQLCODE <> -20001) THEN
377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
381: END IF;
382: APP_EXCEPTION.RAISE_EXCEPTION;
375: WHEN OTHERS THEN
376: IF (SQLCODE <> -20001) THEN
377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
381: END IF;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383: END Create_Netting_Payment;
376: IF (SQLCODE <> -20001) THEN
377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
381: END IF;
382: APP_EXCEPTION.RAISE_EXCEPTION;
383: END Create_Netting_Payment;
384:
605:
606: EXCEPTION
607: WHEN OTHERS THEN
608: IF (SQLCODE <> -20001) THEN
609: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
610: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
611: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
612: FND_MESSAGE.SET_TOKEN('PARAMETERS',
613: ' P_check_id = ' || P_check_id ||
606: EXCEPTION
607: WHEN OTHERS THEN
608: IF (SQLCODE <> -20001) THEN
609: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
610: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
611: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
612: FND_MESSAGE.SET_TOKEN('PARAMETERS',
613: ' P_check_id = ' || P_check_id ||
614: ' P_payment_type_flag = ' || P_payment_type_flag ||
607: WHEN OTHERS THEN
608: IF (SQLCODE <> -20001) THEN
609: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
610: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
611: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
612: FND_MESSAGE.SET_TOKEN('PARAMETERS',
613: ' P_check_id = ' || P_check_id ||
614: ' P_payment_type_flag = ' || P_payment_type_flag ||
615: ' P_payment_method = ' || P_payment_method ||
608: IF (SQLCODE <> -20001) THEN
609: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
610: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
611: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
612: FND_MESSAGE.SET_TOKEN('PARAMETERS',
613: ' P_check_id = ' || P_check_id ||
614: ' P_payment_type_flag = ' || P_payment_type_flag ||
615: ' P_payment_method = ' || P_payment_method ||
616: ' P_bank_account_id = ' || P_ce_bank_acct_use_id ||
628: ' P_set_of_books_id = ' || P_set_of_books_id ||
629: ' P_last_updated_by = ' || P_last_updated_by ||
630: ' P_last_update_login = ' || P_last_update_login
631: );
632: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
633: END IF;
634: APP_EXCEPTION.RAISE_EXCEPTION;
635: END Create_Netting_Inv_Payment;
636: