74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
80: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
81: FND_MESSAGE.SET_TOKEN('PARAMETERS',
82: 'Payment Terms = '|| p_terms_name
75: EXCEPTION
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
80: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
81: FND_MESSAGE.SET_TOKEN('PARAMETERS',
82: 'Payment Terms = '|| p_terms_name
83: ||' Terms date = '||to_char(p_terms_date));
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
80: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
81: FND_MESSAGE.SET_TOKEN('PARAMETERS',
82: 'Payment Terms = '|| p_terms_name
83: ||' Terms date = '||to_char(p_terms_date));
84: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
80: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
81: FND_MESSAGE.SET_TOKEN('PARAMETERS',
82: 'Payment Terms = '|| p_terms_name
83: ||' Terms date = '||to_char(p_terms_date));
84: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
85: END IF;
80: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
81: FND_MESSAGE.SET_TOKEN('PARAMETERS',
82: 'Payment Terms = '|| p_terms_name
83: ||' Terms date = '||to_char(p_terms_date));
84: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
85: END IF;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: End Check_For_Calendar;
88: