APPS.CSM_MAIL_RECIPIENTS_PKG dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: BEGIN
34:
35: -- Insert in this table is not to be
36: -- transfered to CRM table. Therefore discard all inserts and report OK.
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: END APPLY_INSERT;
40:
41:

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137: close c_notification_attributes;
138: end if;
139:
140: --success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143: exception
144: when others then
145: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

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:
156: /***
157: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: x_return_status IN OUT NOCOPY VARCHAR2
164: ) IS
165: BEGIN
166: /*** initialize return status and message list ***/
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168: FND_MSG_PUB.INITIALIZE;
169:
170: IF p_record.dmltype$$='I' THEN
171: -- Process insert

Line 199: x_return_status := FND_API.G_RET_STS_ERROR;

195: , p_token_name1 => 'DML'
196: , p_token_value1 => p_record.dmltype$$
197: );
198:
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: END IF;
201:
202: EXCEPTION WHEN OTHERS THEN
203: /*** defer record when any process exception occurs ***/

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: (
211: p_api_error => TRUE
212: );
213:
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: END APPLY_RECORD;
216:
217: /***
218: This procedure is called by CSM_UTIL_PKG when publication item

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: l_process_status VARCHAR2(1);
232: l_error_msg VARCHAR2(4000);
233: BEGIN
234: g_debug_level := p_debug_level;
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237:
238: /*** loop through debrief labor records in inqueue ***/
239: FOR r_mail_recipients IN c_mail_recipients( p_user_name, p_tranid) LOOP

Line 252: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

248: , l_process_status
249: );
250:
251: /*** was record processed successfully? ***/
252: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
253: /*** Yes -> delete record from inqueue ***/
254:
255: CSM_UTIL_PKG.DELETE_RECORD
256: (

Line 268: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

264: l_process_status
265: );
266:
267: /*** was delete successful? ***/
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

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

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;
277:
278: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 278: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END IF;
276: END IF;
277:
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

Line 298: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

294: , r_mail_recipients.dmltype$$
295: );
296:
297: /*** Was defer successful? ***/
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

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

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;
307:
308: END LOOP;

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

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;