DBA Data[Home] [Help]

APPS.CSM_MAIL_RECIPIENTS_PKG dependencies on FND_LOG

Line 151: || ' for PK ' || p_record.NOTIFICATION_ID,'CSM_MAIL_RECIPIENTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );

147: (
148: p_api_error => TRUE
149: );
150: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
151: || ' for PK ' || p_record.NOTIFICATION_ID,'CSM_MAIL_RECIPIENTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
152:
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: END APPLY_UPDATE;
155:

Line 190: || ' for PK ' || p_record.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR );

186: ELSE
187: -- Process delete; not supported for this entity
188: CSM_UTIL_PKG.LOG
189: ( 'Delete is not supported for this entity'
190: || ' for PK ' || p_record.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR );
191:
192: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
193: (
194: p_message => 'CSM_DML_OPERATION'

Line 206: || ' for PK ' || p_record.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

202: EXCEPTION WHEN OTHERS THEN
203: /*** defer record when any process exception occurs ***/
204: CSM_UTIL_PKG.LOG
205: ( 'Exception occurred in CSM_mail_recipients_PKG.APPLY_RECORD:' || ' ' || sqlerrm
206: || ' for PK ' || p_record.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
207:
208: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
209: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
210: (

Line 272: || ' for PK ' || r_mail_recipients.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

268: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
269: /*** no -> rollback ***/
270: CSM_UTIL_PKG.LOG
271: ( 'Deleting from inqueue failed, rolling back to savepoint'
272: || ' for PK ' || r_mail_recipients.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
273: ROLLBACK TO save_rec;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END IF;
276: END IF;

Line 282: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

278: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
279: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
280: CSM_UTIL_PKG.LOG
281: ( 'Record not processed successfully, deferring and rejecting record'
282: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
283:
284: CSM_UTIL_PKG.DEFER_RECORD
285: (
286: p_user_name

Line 302: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_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: ( 'Defer record failed, rolling back to savepoint'
302: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_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;

Line 314: ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

310: EXCEPTION WHEN OTHERS THEN
311: /*** catch and log exceptions ***/
312: CSM_UTIL_PKG.LOG
313: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
314: ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: END APPLY_CLIENT_CHANGES;
317:
318: END CSM_MAIL_RECIPIENTS_PKG;