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_UTIL_PKG

Line 117: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

113: x_return_status := FND_API.G_RET_STS_ERROR;
114: p_error_msg := 'The receiver '||p_record.receiver ||' of your message does not exist.';
115:
116: /*
117: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
118: (
119: p_message => 'CSL_MAIL_RECEIVER_UNKNOWN'
120: , p_token_name1 => 'MAIL_RECEIVER'
121: , p_token_value1 => p_record.receiver

Line 159: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: );
163: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

Line 163: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

159: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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:

Line 194: CSM_UTIL_PKG.LOG

190: x_return_status
191: );
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

Line 198: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
201: , p_token_name1 => 'DML'
202: , p_token_value1 => p_record.dmltype$$

Line 210: CSM_UTIL_PKG.LOG

206: END IF;
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);

Line 215: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: );
219:

Line 224: This procedure is called by CSM_UTIL_PKG when publication item

220: x_return_status := FND_API.G_RET_STS_ERROR;
221: END APPLY_RECORD;
222:
223: /***
224: This procedure is called by CSM_UTIL_PKG when publication item
225: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
226: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
227: public APIs.
228: ***/

Line 264: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '

260: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
261:
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:

Line 269: CSM_UTIL_PKG.REJECT_RECORD

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,
272: p_tranid,
273: r_mail_messages.seqno$$,

Line 286: CSM_UTIL_PKG.DELETE_RECORD

282: --if deferred and reapplied - reject won't delete applied record from inq
283: IF (r_mail_messages.dmltype$$<>'I') OR ( ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_mail_messages.seqno$$)=FND_API.G_TRUE) THEN
284: /*** Yes -> delete record from inqueue ***/
285:
286: CSM_UTIL_PKG.DELETE_RECORD
287: (
288: p_user_name,
289: p_tranid,
290: r_mail_messages.seqno$$,

Line 300: CSM_UTIL_PKG.LOG

296: );
297: /*** was delete successful? ***/
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;

Line 309: CSM_UTIL_PKG.LOG

305: END IF;
306: END IF; --dmltype <> 'I' or deferred
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

Line 313: CSM_UTIL_PKG.DEFER_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
316: , p_tranid
317: , r_mail_messages.seqno$$

Line 329: CSM_UTIL_PKG.LOG

325:
326: /*** Was defer successful? ***/
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;

Line 341: CSM_UTIL_PKG.LOG

337: END LOOP;
338:
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;