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

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128:
129: /***************************************************************************
130: ** Initialize API return status to success
131: **************************************************************************/
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133: l_notification_id := p_record.notification_id;
134: l_user_name := p_record.CLID$$CS;
135: l_object_id := p_record.object_id;
136: l_object_name := p_record.object_name;

Line 184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

180: IF (c_record_exists%ISOPEN) THEN
181: CLOSE c_record_exists;
182: END IF;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
185: THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: RETURN ;
194: END IF;
195:
196: -- success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: EXCEPTION
200: WHEN others THEN
201: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: FND_LOG.LEVEL_PROCEDURE );
255: /***************************************************************************
256: ** Initialize API return status to success
257: ***************************************************************************/
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: l_notification_id := p_record.notification_id;
260: l_user_name := p_record.CLID$$CS;
261: l_user_id := p_record.user_id;
262:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: END IF;
316:
317: -- success
318: -- delete csm_auto_sync_nfn_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: EXCEPTION
322:
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: EXCEPTION
322:
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: IF (c_auto_sync_nfn%ISOPEN) THEN
325: CLOSE c_auto_sync_nfn;
326: END IF;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: IF (c_auto_sync_nfn%ISOPEN) THEN
325: CLOSE c_auto_sync_nfn;
326: END IF;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
329: WHEN others THEN
330: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
331: || ' for PK ' || p_record.notification_id,

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: || ' for PK ' || p_record.notification_id,
332: g_object_name || '.APPLY_UPDATE',
333: FND_LOG.LEVEL_EXCEPTION );
334:
335: x_return_status := FND_API.G_RET_STS_ERROR;
336:
337: END APPLY_UPDATE;
338:
339:

Line 355: x_return_status := FND_API.G_RET_STS_SUCCESS;

351: ) IS
352: BEGIN
353:
354: /*** initialize return status and message list ***/
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356: FND_MSG_PUB.INITIALIZE;
357:
358:
359: IF p_record.dmltype$$='I' THEN

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: , p_token_name1 => 'DML'
389: , p_token_value1 => p_record.dmltype$$
390: );
391:
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: END IF;
394:
395: EXCEPTION
396: WHEN OTHERS THEN

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

406: (
407: p_api_error => TRUE
408: );
409:
410: x_return_status := FND_API.G_RET_STS_ERROR;
411:
412: END APPLY_RECORD;
413: ----------------------------------------------------------------------------------------------------------------------
414:

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432:
433: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
434: FND_LOG.LEVEL_PROCEDURE);
435: g_debug_level := p_debug_level;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: /*** loop through records in inqueue ***/
439: FOR r_auto_sync_nfn IN c_auto_sync_nfn_inq( p_user_name, p_tranid) LOOP
440: SAVEPOINT save_rec;

Line 452: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

448: , l_reject_row
449: );
450: /***--------------------------------------------------------------**/
451: /*** was record processed successfully? ***/
452: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
453: /*** If Yes -> delete record from inqueue ***/
454: CSM_UTIL_PKG.DELETE_RECORD
455: (
456: p_user_name,

Line 498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

494:
495:
496:
497: /*** was delete/reject successful? ***/
498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
499: /*** If No -> rollback ***/
500: CSM_UTIL_PKG.LOG
501: ( 'Deleting from inqueue failed, rolling back to savepoint'
502: || ' for PK ' || r_auto_sync_nfn.notification_id ,

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: || ' for PK ' || r_auto_sync_nfn.notification_id ,
503: g_object_name || '.APPLY_CLIENT_CHANGES',
504: FND_LOG.LEVEL_ERROR); -- put PK column here
505: ROLLBACK TO save_rec;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: END IF;
508: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
509:
510: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

504: FND_LOG.LEVEL_ERROR); -- put PK column here
505: ROLLBACK TO save_rec;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: END IF;
508: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
509:
510: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
511: /*** Record was not processed successfully or delete failed
512: -> defer and reject record ***/

Line 510: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

506: x_return_status := FND_API.G_RET_STS_ERROR;
507: END IF;
508: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
509:
510: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
511: /*** Record was not processed successfully or delete failed
512: -> defer and reject record ***/
513: CSM_UTIL_PKG.LOG
514: ( 'Record not processed successfully, deferring and rejecting record'

Line 532: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

528: , r_auto_sync_nfn.dmltype$$
529: );
530:
531: /*** Was defer successful? ***/
532: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
533: /*** no -> rollback ***/
534: CSM_UTIL_PKG.LOG
535: ( 'Defer record failed, rolling back to savepoint'
536: || ' for PK ' || r_auto_sync_nfn.notification_id ,

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: || ' for PK ' || r_auto_sync_nfn.notification_id ,
537: g_object_name || '.APPLY_CLIENT_CHANGES',
538: FND_LOG.LEVEL_ERROR); -- put PK column here
539: ROLLBACK TO save_rec;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END IF;
542: END IF;
543:
544: END LOOP;

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: CSM_UTIL_PKG.LOG
549: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
550: g_object_name || '.APPLY_CLIENT_CHANGES',
551: FND_LOG.LEVEL_EXCEPTION);
552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: END APPLY_CLIENT_CHANGES;
555:
556: