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_CLIENT_NFN_LOG_PKG dependencies on FND_API

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134:
135: /***************************************************************************
136: ** Initialize API return status to success
137: ***************************************************************************/
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: l_notification_id := p_record.notification_id;
140: l_user_name := p_record.CLID$$CS;
141: l_object_id := p_record.object_id;
142: l_object_name := p_record.object_name;

Line 181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

177: END IF;
178:
179:
180:
181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184:
185: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179:
180:
181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184:
185: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
186: || ' ROOT ERROR: create statement'
187: || ' for PK ' || p_record.NOTIFICATION_ID,

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: END IF;
192:
193: --delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
194: -- success
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196: COMMIT;
197:
198: EXCEPTION
199: WHEN others THEN

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: || ' for PK ' || p_record.notification_id,
202: g_object_name || '.APPLY_INSERT',
203: FND_LOG.LEVEL_EXCEPTION );
204:
205: x_return_status := FND_API.G_RET_STS_ERROR;
206:
207: END APPLY_INSERT;
208:
209:

Line 255: x_return_status := FND_API.G_RET_STS_SUCCESS;

251: FND_LOG.LEVEL_PROCEDURE );
252: /***************************************************************************
253: ** Initialize API return status to success
254: ***************************************************************************/
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256: l_notification_id := p_record.notification_id;
257: l_user_name := p_record.CLID$$CS;
258:
259: IF (c_client_nfn_log%ISOPEN) THEN

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: END IF;
310:
311: -- success
312: -- delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: EXCEPTION
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: EXCEPTION
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: IF (c_client_nfn_log%ISOPEN) THEN
319: CLOSE c_client_nfn_log;
320: END IF;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: IF (c_client_nfn_log%ISOPEN) THEN
319: CLOSE c_client_nfn_log;
320: END IF;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322:
323: WHEN others THEN
324: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
325: || ' for PK ' || p_record.notification_id,

Line 329: x_return_status := FND_API.G_RET_STS_ERROR;

325: || ' for PK ' || p_record.notification_id,
326: g_object_name || '.APPLY_UPDATE',
327: FND_LOG.LEVEL_EXCEPTION );
328:
329: x_return_status := FND_API.G_RET_STS_ERROR;
330:
331: END APPLY_UPDATE;
332:
333: PROCEDURE APPLY_RECORD

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: ) IS
340: BEGIN
341:
342: /*** initialize return status and message list ***/
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: FND_MSG_PUB.INITIALIZE;
345:
346:
347: IF p_record.dmltype$$='I' THEN

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: , p_token_name1 => 'DML'
377: , p_token_value1 => p_record.dmltype$$
378: );
379:
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: END IF;
382:
383: EXCEPTION
384: WHEN OTHERS THEN

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: (
395: p_api_error => TRUE
396: );
397:
398: x_return_status := FND_API.G_RET_STS_ERROR;
399:
400: END APPLY_RECORD;
401: ----------------------------------------------------------------------------------------------------------------------
402:

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
422: g_object_name || '.APPLY_CLIENT_CHANGES',
423: FND_LOG.LEVEL_PROCEDURE);
424: g_debug_level := p_debug_level;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: /*** loop through records in inqueue ***/
428: FOR r_client_nfn_log IN c_client_nfn_log_inq( p_user_name, p_tranid) LOOP
429:

Line 442: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

438: , l_reject_row
439: );
440:
441: /*** was record processed successfully? ***/
442: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
443: /*** If Yes -> delete record from inqueue ***/
444: IF l_reject_row THEN
445: CSM_UTIL_PKG.REJECT_RECORD
446: (

Line 471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

467: ); --process doesn't depend on this delete_record API
468: END IF;
469:
470: /*** was delete/reject successful? ***/
471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: /*** If No -> rollback ***/
473: CSM_UTIL_PKG.LOG
474: ( 'Deleting from inqueue failed, rolling back to savepoint'
475: || ' for PK ' || r_client_nfn_log.notification_id ,

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475: || ' for PK ' || r_client_nfn_log.notification_id ,
476: g_object_name || '.APPLY_CLIENT_CHANGES',
477: FND_LOG.LEVEL_ERROR); -- put PK column here
478: ROLLBACK TO save_rec;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
482:
483: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 481: END IF; /* end of IF l_process_status = FND_API.G_RET_STS_SUCCESS */

477: FND_LOG.LEVEL_ERROR); -- put PK column here
478: ROLLBACK TO save_rec;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
482:
483: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
484: /*** Record was not processed successfully or delete failed
485: -> defer and reject record ***/

Line 483: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
482:
483: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
484: /*** Record was not processed successfully or delete failed
485: -> defer and reject record ***/
486: CSM_UTIL_PKG.LOG
487: ( 'Record not processed successfully, deferring and rejecting record'

Line 505: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

501: , r_client_nfn_log.dmltype$$
502: );
503:
504: /*** Was defer successful? ***/
505: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
506: /*** no -> rollback ***/
507: CSM_UTIL_PKG.LOG
508: ( 'Defer record failed, rolling back to savepoint'
509: || ' for PK ' || r_client_nfn_log.notification_id ,

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: || ' for PK ' || r_client_nfn_log.notification_id ,
510: g_object_name || '.APPLY_CLIENT_CHANGES',
511: FND_LOG.LEVEL_ERROR); -- put PK column here
512: ROLLBACK TO save_rec;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;
516:
517: END LOOP;

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: CSM_UTIL_PKG.LOG
522: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
523: g_object_name || '.APPLY_CLIENT_CHANGES',
524: FND_LOG.LEVEL_EXCEPTION);
525: x_return_status := FND_API.G_RET_STS_ERROR;
526:
527: END APPLY_CLIENT_CHANGES;
528:
529: