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 FND_API

Line 117: x_return_status := FND_API.G_RET_STS_ERROR;

113: then
114: l_valid_receiver := true;
115: else
116: l_valid_receiver := false;
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: p_error_msg := 'The receiver '||p_record.receiver ||' of your message does not exist.';
119:
120: /*
121: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: );
185:
186: CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION(l_notification_id,l_return_status); --return_status doesn't matter here
187: --success
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: end if;
190:
191: exception
192: when others then

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: p_api_error => TRUE
197: );
198: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
199: || ' for PK ' || p_record.NOTIFICATION_ID ,'CSM_MAIL_MESSAGES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END APPLY_INSERT;
202:
203:
204: /***

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: x_return_status IN OUT NOCOPY VARCHAR2
212: ) IS
213: BEGIN
214: /*** initialize return status and message list ***/
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: FND_MSG_PUB.INITIALIZE;
217:
218: IF p_record.dmltype$$='I' THEN
219: -- Process insert

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: , p_token_name1 => 'DML'
236: , p_token_value1 => p_record.dmltype$$
237: );
238:
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: END IF;
241:
242: EXCEPTION WHEN OTHERS THEN
243: /*** defer record when any process exception occurs ***/

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: (
251: p_api_error => TRUE
252: );
253:
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: END APPLY_RECORD;
256:
257: /***
258: This procedure is called by CSM_UTIL_PKG when publication item

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: l_process_status VARCHAR2(1);
272: l_error_msg VARCHAR2(4000);
273: BEGIN
274: g_debug_level := p_debug_level;
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277:
278:
279: /*** loop through debrief labor records in inqueue ***/

Line 293: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

289: , l_process_status
290: );
291:
292: /*** was record processed successfully? ***/
293: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
294:
295: /*** Yes -> reject record because of changed pk ***/
296: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '
297: || r_mail_messages.notification_id

Line 314: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

310: l_process_status
311: );
312:
313:
314: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
315: /*** Reject successfull than reject matching records in mail recipient ***/
316: CSM_UTIL_PKG.LOG
317: ( 'Mail message record rejected. Now rejecting records in mail recipient ' || ' for PK '
318: || r_mail_messages.notification_id

Line 354: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

350: l_process_status
351: );
352:
353: /*** was delete successful? ***/
354: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
355: /*** no -> rollback ***/
356: CSM_UTIL_PKG.LOG
357: ( 'Deleting from inqueue failed, rolling back to savepoint'
358: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: CSM_UTIL_PKG.LOG
357: ( 'Deleting from inqueue failed, rolling back to savepoint'
358: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
359: ROLLBACK TO save_rec;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: END IF;
362: END IF;
363:
364: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 364: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

360: x_return_status := FND_API.G_RET_STS_ERROR;
361: END IF;
362: END IF;
363:
364: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
365: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
366: CSM_UTIL_PKG.LOG
367: ( 'Record not processed successfully, deferring and rejecting record'
368: || ' for PK ' || r_mail_messages.notification_id ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 384: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

380: , r_mail_messages.dmltype$$
381: );
382:
383: /*** Was defer successful? ***/
384: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** no -> rollback ***/
386: CSM_UTIL_PKG.LOG
387: ( 'Defer record failed, rolling back to savepoint'
388: || ' for PK ' || r_mail_messages.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: CSM_UTIL_PKG.LOG
387: ( 'Defer record failed, rolling back to savepoint'
388: || ' for PK ' || r_mail_messages.notification_id,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
389: ROLLBACK TO save_rec;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: END IF;
392: END IF;
393:
394: END LOOP;

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397: /*** catch and log exceptions ***/
398: CSM_UTIL_PKG.LOG
399: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
400: ,'CSM_MAIL_MESSAGES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: END APPLY_CLIENT_CHANGES;
403:
404: END CSM_MAIL_MESSAGES_PKG;