239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
241: WHEN OTHERS THEN
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
242: IF (SQLCODE <> -20001) THEN
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
250: ||', Key_Value1 = '||to_char(p_key_value1));
243: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
244: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
245: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
246: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
248: 'Table_Name = '||p_table_name
249: ||', Operation = '||p_operation
250: ||', Key_Value1 = '||to_char(p_key_value1));
251: END IF;
405:
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (SQLCODE <> -20001) THEN
409: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
410: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
411: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
413: END IF;
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (SQLCODE <> -20001) THEN
409: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
410: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
411: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
413: END IF;
414: APP_EXCEPTION.RAISE_EXCEPTION;
407: WHEN OTHERS THEN
408: IF (SQLCODE <> -20001) THEN
409: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
410: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
411: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
413: END IF;
414: APP_EXCEPTION.RAISE_EXCEPTION;
415:
408: IF (SQLCODE <> -20001) THEN
409: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
410: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
411: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
413: END IF;
414: APP_EXCEPTION.RAISE_EXCEPTION;
415:
416: