eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_MAIL_MESSAGES_PKG dependencies on CSM_MAIL_MESSAGES_PKG

Line 1: PACKAGE BODY CSM_MAIL_MESSAGES_PKG AS

1: PACKAGE BODY CSM_MAIL_MESSAGES_PKG AS
2: /* $Header: csmummsb.pls 120.5.12020000.2 2012/08/10 09:43:57 pramosin ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_MAIL_MESSAGES_PKG'; -- package name

8: -- Enter procedure, function bodies as shown below
9:
10:
11: /*** Globals ***/
12: g_object_name CONSTANT VARCHAR2(30) := 'CSM_MAIL_MESSAGES_PKG'; -- package name
13: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_M_MAIL_MESSAGES'; -- publication item name
14: g_pub_name2 CONSTANT VARCHAR2(30) := 'CSF_M_MAIL_RECIPIENTS'; -- publication item name
15: g_debug_level NUMBER; -- debug level
16:

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 211: ( 'Exception occurred in CSM_mail_messages_PKG.APPLY_RECORD:' || ' ' || sqlerrm

207:
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

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 266: ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES'

262: IF r_mail_messages.dmltype$$='I' THEN
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: (

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;

Line 347: END CSM_MAIL_MESSAGES_PKG;

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;