93: CLOSE c_insert;
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: FND_MESSAGE.Set_Name('SQLAP','AP_DEBUG');
98: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
99: FND_MESSAGE.Set_Token('CALLING_SEQUENCE',p_calling_sequence);
100: FND_MESSAGE.Set_Token('DEBUG_INFO',l_debug_info);
101: IF ( l_unexp_level >= l_debug_level ) THEN
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: FND_MESSAGE.Set_Name('SQLAP','AP_DEBUG');
98: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
99: FND_MESSAGE.Set_Token('CALLING_SEQUENCE',p_calling_sequence);
100: FND_MESSAGE.Set_Token('DEBUG_INFO',l_debug_info);
101: IF ( l_unexp_level >= l_debug_level ) THEN
102: FND_LOG.MESSAGE ( l_unexp_level,l_path || 'Insert_Row', FALSE);
95: EXCEPTION
96: WHEN OTHERS THEN
97: FND_MESSAGE.Set_Name('SQLAP','AP_DEBUG');
98: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
99: FND_MESSAGE.Set_Token('CALLING_SEQUENCE',p_calling_sequence);
100: FND_MESSAGE.Set_Token('DEBUG_INFO',l_debug_info);
101: IF ( l_unexp_level >= l_debug_level ) THEN
102: FND_LOG.MESSAGE ( l_unexp_level,l_path || 'Insert_Row', FALSE);
103: END IF;
96: WHEN OTHERS THEN
97: FND_MESSAGE.Set_Name('SQLAP','AP_DEBUG');
98: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
99: FND_MESSAGE.Set_Token('CALLING_SEQUENCE',p_calling_sequence);
100: FND_MESSAGE.Set_Token('DEBUG_INFO',l_debug_info);
101: IF ( l_unexp_level >= l_debug_level ) THEN
102: FND_LOG.MESSAGE ( l_unexp_level,l_path || 'Insert_Row', FALSE);
103: END IF;
104: APP_EXCEPTION.Raise_Exception;