DBA Data[Home] [Help]

APPS.CSM_MAIL_MESSAGES_PKG dependencies on FND_LOG

Line 164: || ' for PK ' || p_record.NOTIFICATION_ID ,'CSM_MAIL_MESSAGES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

160: (
161: p_api_error => TRUE
162: );
163: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
164: || ' for PK ' || p_record.NOTIFICATION_ID ,'CSM_MAIL_MESSAGES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: END APPLY_INSERT;
167:
168:

Line 196: || ' for PK ' || p_record.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

192: ELSE
193: -- Process delete and update; not supported for this entity
194: CSM_UTIL_PKG.LOG
195: ( 'This Operation is not supported for this entity'
196: || ' for PK ' || p_record.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
197:
198: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
199: (
200: p_message => 'CSM_DML_OPERATION'

Line 212: || ' for PK ' || p_record.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

208: EXCEPTION WHEN OTHERS THEN
209: /*** defer record when any process exception occurs ***/
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: (

Line 267: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here

263: /*** Yes -> reject record because of changed pk ***/
264: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '
265: || r_mail_messages.notification_id
266: ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES'
267: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
268:
269: CSM_UTIL_PKG.REJECT_RECORD
270: (
271: p_user_name,

Line 302: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

298: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
299: /*** no -> rollback ***/
300: CSM_UTIL_PKG.LOG
301: ( 'Deleting from inqueue failed, rolling back to savepoint'
302: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
303: ROLLBACK TO save_rec;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END IF;
306: END IF; --dmltype <> 'I' or deferred

Line 311: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

307: ELSE -- l_process_Status <> FND_API.G_RET_STS_SUCCESS
308: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
309: CSM_UTIL_PKG.LOG
310: ( 'Record not processed successfully, deferring and rejecting record'
311: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
312:
313: CSM_UTIL_PKG.DEFER_RECORD
314: (
315: p_user_name

Line 331: || ' for PK ' || r_mail_messages.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

327: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
328: /*** no -> rollback ***/
329: CSM_UTIL_PKG.LOG
330: ( 'Defer record failed, rolling back to savepoint'
331: || ' for PK ' || r_mail_messages.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
332: ROLLBACK TO save_rec;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335: END IF;

Line 343: ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

339: EXCEPTION WHEN OTHERS THEN
340: /*** catch and log exceptions ***/
341: CSM_UTIL_PKG.LOG
342: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
343: ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: END APPLY_CLIENT_CHANGES;
346:
347: END CSM_MAIL_MESSAGES_PKG;