APPS.CSM_MAIL_MESSAGES_PKG dependencies on FND_API

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: then
110: l_valid_receiver := true;
111: else
112: l_valid_receiver := false;
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

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: WHEN OTHERS THEN
150: CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC(l_notification_id,asg_base.get_user_id(l_sender));
151: END;
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: end if;
155:
156: exception
157: when others then

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

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:
169: /***

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: )
178: IS
179: BEGIN
180: /*** initialize return status and message list ***/
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: FND_MSG_PUB.INITIALIZE;
183:
184: IF p_record.dmltype$$='I' THEN
185: -- Process insert

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: , p_token_name1 => 'DML'
202: , p_token_value1 => p_record.dmltype$$
203: );
204:
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: END IF;
207:
208: EXCEPTION WHEN OTHERS THEN
209: /*** defer record when any process exception occurs ***/

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: (
217: p_api_error => TRUE
218: );
219:
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

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: l_error_msg VARCHAR2(4000);
239:
240: BEGIN
241: g_debug_level := p_debug_level;
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:
244:
245:
246: /*** loop through debrief labor records in inqueue ***/

Line 260: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

256: , l_process_status
257: );
258:
259: /*** was record processed successfully? ***/
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 '

Line 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

279: );
280: END IF; --if r_mail_messages.dmltype$$='I'
281:
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: (

Line 298: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

294: l_error_msg,
295: l_process_status
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

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

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
307: ELSE -- l_process_Status <> FND_API.G_RET_STS_SUCCESS
308: /*** Record was not processed successfully or delete failed -> defer and reject record ***/

Line 307: ELSE -- l_process_Status <> FND_API.G_RET_STS_SUCCESS

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

Line 327: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

323: , r_mail_messages.dmltype$$
324: );
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

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

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;