189: end if;
190:
191: exception
192: when others then
193: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
194: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
195: (
196: p_api_error => TRUE
197: );
212: ) IS
213: BEGIN
214: /*** initialize return status and message list ***/
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: FND_MSG_PUB.INITIALIZE;
217:
218: IF p_record.dmltype$$='I' THEN
219: -- Process insert
220: APPLY_INSERT
244: CSM_UTIL_PKG.LOG
245: ( 'Exception occurred in CSM_mail_messages_PKG.APPLY_RECORD:' || ' ' || sqlerrm
246: || ' for PK ' || p_record.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
247:
248: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
249: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
250: (
251: p_api_error => TRUE
252: );