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

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132:
133: /***************************************************************************
134: ** Initialize API return status to success
135: ***************************************************************************/
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: /*
139: insert into csm_auto_sync(ID,FLAG,AUTO_SYNC_NUM,DOWNLOAD_ONLY,CREATION_DATE ,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY)
140: values (p_record.id,p_record.flag,p_record.auto_sync_num,p_record.download_only,p_record.creation_date ,p_record.created_by,p_record.last_update_date,p_record.last_updated_by)

Line 166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

162: END IF;
163:
164:
165:
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
167: THEN
168: x_return_status := FND_API.G_RET_STS_ERROR;
169:
170: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

164:
165:
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
167: THEN
168: x_return_status := FND_API.G_RET_STS_ERROR;
169:
170: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
171: || ' ROOT ERROR: create statement'
172: || ' for PK ' || p_record.ID,

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175: RETURN ;
176: END IF;
177:
178: -- success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: EXCEPTION
182: WHEN others THEN
183: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

184: || ' for PK ' || p_record.id,
185: g_object_name || '.APPLY_INSERT',
186: FND_LOG.LEVEL_EXCEPTION );
187:
188: x_return_status := FND_API.G_RET_STS_ERROR;
189:
190: END APPLY_INSERT;
191:
192:

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: FND_LOG.LEVEL_PROCEDURE );
220: /***************************************************************************
221: ** Initialize API return status to success
222: ***************************************************************************/
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: l_user_id := asg_base.get_user_id(p_record.clid$$cs);
226: l_auto_sync_num := p_record.auto_sync_num;
227: l_id := p_record.id;

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: RAISE NO_DATA_FOUND;
249: END IF;
250:
251: -- success
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: EXCEPTION
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: EXCEPTION
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258:
259: WHEN others THEN
260: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253:
254: EXCEPTION
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258:
259: WHEN others THEN
260: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
261: || ' for PK ' || p_record.id,

Line 265: x_return_status := FND_API.G_RET_STS_ERROR;

261: || ' for PK ' || p_record.id,
262: g_object_name || '.APPLY_UPDATE',
263: FND_LOG.LEVEL_EXCEPTION );
264:
265: x_return_status := FND_API.G_RET_STS_ERROR;
266:
267: END APPLY_UPDATE;
268:
269:

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: ) IS
282: BEGIN
283:
284: /*** initialize return status and message list ***/
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: FND_MSG_PUB.INITIALIZE;
288:
289:

Line 323: x_return_status := FND_API.G_RET_STS_ERROR;

319: , p_token_name1 => 'DML'
320: , p_token_value1 => p_record.dmltype$$
321: );
322:
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: END IF;
325:
326: EXCEPTION
327: WHEN OTHERS THEN

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: (
338: p_api_error => TRUE
339: );
340:
341: x_return_status := FND_API.G_RET_STS_ERROR;
342:
343: END APPLY_RECORD;
344: ----------------------------------------------------------------------------------------------------------------------
345:

Line 366: x_return_status := FND_API.G_RET_STS_SUCCESS;

362: BEGIN
363: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
364: FND_LOG.LEVEL_PROCEDURE);
365: g_debug_level := p_debug_level;
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: /*** loop through records in inqueue ***/
369: FOR r_auto_sync IN c_auto_sync_inq( p_user_name, p_tranid) LOOP
370:

Line 383: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

379: , l_reject_row
380: );
381: /***--------------------------------------------------------------**/
382: /*** was record processed successfully? ***/
383: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
384: /*** If Yes -> delete record from inqueue ***/
385: IF l_reject_row THEN
386: CSM_UTIL_PKG.REJECT_RECORD
387: (

Line 412: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

408: ); --process doesn't depend on this delete_record API
409: END IF;
410:
411: /*** was delete/reject successful? ***/
412: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: /*** If No -> rollback ***/
414: CSM_UTIL_PKG.LOG
415: ( 'Deleting from inqueue failed, rolling back to savepoint'
416: || ' for PK ' || r_auto_sync.id ,

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

416: || ' for PK ' || r_auto_sync.id ,
417: g_object_name || '.APPLY_CLIENT_CHANGES',
418: FND_LOG.LEVEL_ERROR); -- put PK column here
419: ROLLBACK TO save_rec;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
423:
424: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

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

418: FND_LOG.LEVEL_ERROR); -- put PK column here
419: ROLLBACK TO save_rec;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
423:
424: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
425: /*** Record was not processed successfully or delete failed
426: -> defer and reject record ***/

Line 424: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/
423:
424: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
425: /*** Record was not processed successfully or delete failed
426: -> defer and reject record ***/
427: CSM_UTIL_PKG.LOG
428: ( 'Record not processed successfully, deferring and rejecting record'

Line 446: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

442: , r_auto_sync.dmltype$$
443: );
444:
445: /*** Was defer successful? ***/
446: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
447: /*** no -> rollback ***/
448: CSM_UTIL_PKG.LOG
449: ( 'Defer record failed, rolling back to savepoint'
450: || ' for PK ' || r_auto_sync.id ,

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: || ' for PK ' || r_auto_sync.id ,
451: g_object_name || '.APPLY_CLIENT_CHANGES',
452: FND_LOG.LEVEL_ERROR); -- put PK column here
453: ROLLBACK TO save_rec;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: END IF;
456: END IF;
457:
458: END LOOP;

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: CSM_UTIL_PKG.LOG
463: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
464: g_object_name || '.APPLY_CLIENT_CHANGES',
465: FND_LOG.LEVEL_EXCEPTION);
466: x_return_status := FND_API.G_RET_STS_ERROR;
467:
468: END APPLY_CLIENT_CHANGES;
469:
470: