[Home] [Help]
141:
142: EXCEPTION WHEN OTHERS THEN
143: CSM_UTIL_PKG.LOG
144: ( module => g_object_name
145: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
146: , log_level => FND_LOG.LEVEL_ERROR);
147:
148: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
149: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
179:
180: EXCEPTION WHEN OTHERS THEN
181: CSM_UTIL_PKG.LOG
182: ( module => g_object_name
183: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
184: , log_level => FND_LOG.LEVEL_ERROR);
185:
186: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
187: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
207: FND_MSG_PUB.INITIALIZE;
208:
209: CSM_UTIL_PKG.LOG
210: ( module => g_object_name
211: , message => 'Entering ' || g_object_name || '.APPLY_RECORD and processing TRANSACTION_ID = ' || p_record.TRANSACTION_ID || fnd_global.local_chr(10) ||
212: 'DMLTYPE = ' || p_record.dmltype$$
213: , log_level => FND_LOG.LEVEL_STATEMENT);
214:
215: IF p_record.dmltype$$='I' THEN
245: EXCEPTION WHEN OTHERS THEN
246: /*** defer record when any process exception occurs ***/
247: CSM_UTIL_PKG.LOG
248: ( module => g_object_name
249: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
250: , log_level => FND_LOG.LEVEL_ERROR);
251:
252: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
253: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
535: EXCEPTION WHEN OTHERS THEN
536: /*** catch and log exceptions ***/
537: CSM_UTIL_PKG.LOG
538: ( module => g_object_name
539: , message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
540: , log_level => FND_LOG.LEVEL_ERROR);
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: END APPLY_CLIENT_CHANGES;