APPS.CSM_MAIL_RECIPIENTS_PKG dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: BEGIN
39:
40: -- Insert in this table is not to be
41: -- transfered to CRM table. Therefore discard all inserts and report OK.
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:
44: END APPLY_INSERT;
45:
46:

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: wf_notification.SetAttrText( p_record.notification_id, 'READ_FLAG', NVL(substr(p_record.read_flag,1,1),'T'));
96: end if;
97:
98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: CSM_UTIL_PKG.LOG ( 'Leaving Update for '|| p_record.notification_id
102: ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
103:

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: );
111: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
112: || ' for PK ' || p_record.NOTIFICATION_ID,'CSM_MAIL_RECIPIENTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
113:
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: END APPLY_UPDATE;
116:
117: /***
118: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: x_return_status IN OUT NOCOPY VARCHAR2
125: ) IS
126: BEGIN
127: /*** initialize return status and message list ***/
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: FND_MSG_PUB.INITIALIZE;
130:
131: IF p_record.dmltype$$='I' THEN
132: -- Process insert

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: , p_token_name1 => 'DML'
157: , p_token_value1 => p_record.dmltype$$
158: );
159:
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162:
163: EXCEPTION WHEN OTHERS THEN
164: /*** defer record when any process exception occurs ***/

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: (
172: p_api_error => TRUE
173: );
174:
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: END APPLY_RECORD;
177:
178: /***
179: This procedure is called by CSM_UTIL_PKG when publication item

Line 196: x_return_status := FND_API.G_RET_STS_SUCCESS;

192: l_process_status VARCHAR2(1);
193: l_error_msg VARCHAR2(4000);
194: BEGIN
195: g_debug_level := p_debug_level;
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198:
199: /*** loop through debrief labor records in inqueue ***/
200: FOR r_mail_recipients IN c_mail_recipients( p_user_name, p_tranid) LOOP

Line 213: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

209: , l_process_status
210: );
211:
212: /*** was record processed successfully? ***/
213: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
214: /*** Yes -> delete record from inqueue ***/
215:
216: CSM_UTIL_PKG.DELETE_RECORD
217: (

Line 229: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

225: l_process_status
226: );
227:
228: /*** was delete successful? ***/
229: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
230: /*** no -> rollback ***/
231: CSM_UTIL_PKG.LOG
232: ( 'Deleting from inqueue failed, rolling back to savepoint'
233: || ' for PK ' || r_mail_recipients.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: CSM_UTIL_PKG.LOG
232: ( 'Deleting from inqueue failed, rolling back to savepoint'
233: || ' for PK ' || r_mail_recipients.notification_id ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
234: ROLLBACK TO save_rec;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: END IF;
237:
238: ELSE --l_process_Status <> FND_API.G_RET_STS_SUCCESS
239: /*** Record was not processed successfully or delete failed -> defer and reject record ***/

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

234: ROLLBACK TO save_rec;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: END IF;
237:
238: ELSE --l_process_Status <> FND_API.G_RET_STS_SUCCESS
239: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
240: CSM_UTIL_PKG.LOG
241: ( 'Record not processed successfully, deferring and rejecting record'
242: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 258: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

254: , r_mail_recipients.dmltype$$
255: );
256:
257: /*** Was defer successful? ***/
258: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
259: /*** no -> rollback ***/
260: CSM_UTIL_PKG.LOG
261: ( 'Defer record failed, rolling back to savepoint'
262: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: CSM_UTIL_PKG.LOG
261: ( 'Defer record failed, rolling back to savepoint'
262: || ' for PK ' || r_mail_recipients.notification_id,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
263: ROLLBACK TO save_rec;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END IF;
266: END IF;
267:
268: END LOOP;

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: /*** catch and log exceptions ***/
272: CSM_UTIL_PKG.LOG
273: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
274: ,'CSM_MAIL_RECIPIENTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END APPLY_CLIENT_CHANGES;
277:
278: END CSM_MAIL_RECIPIENTS_PKG;