154: end if;
155:
156: exception
157: when others then
158: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
159: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
160: (
161: p_api_error => TRUE
162: );
178: IS
179: BEGIN
180: /*** initialize return status and message list ***/
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: FND_MSG_PUB.INITIALIZE;
183:
184: IF p_record.dmltype$$='I' THEN
185: -- Process insert
186: APPLY_INSERT
210: CSM_UTIL_PKG.LOG
211: ( 'Exception occurred in CSM_mail_messages_PKG.APPLY_RECORD:' || ' ' || sqlerrm
212: || ' for PK ' || p_record.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
213:
214: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
215: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
216: (
217: p_api_error => TRUE
218: );