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

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

92: X_NEW_ESCALATION_LEVEL => NULL, X_OLD_ESCALATION_LEVEL => NULL,
93: X_OLD_DATE_SELECTED => NULL, X_NEW_DATE_SELECTED => NULL,
94: X_OLD_LOCATION_ID => NULL, X_NEW_LOCATION_ID => NULL);
95:
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: EXCEPTION WHEN OTHERS THEN
99: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DO_TASK_AUDIT', sqlerrm);
100: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DO_TASK_AUDIT: ' || sqlerrm

Line 102: x_return_status := FND_API.G_RET_STS_ERROR;

98: EXCEPTION WHEN OTHERS THEN
99: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DO_TASK_AUDIT', sqlerrm);
100: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DO_TASK_AUDIT: ' || sqlerrm
101: || ' for Task ID ' || p_record.TASK_ID ,'CSM_TA_AUDIT_PKG.DO_TASK_AUDIT',FND_LOG.LEVEL_EXCEPTION);
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: END DO_TASK_AUDIT;
104:
105:
106: /***

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119: l_msg_data VARCHAR2(4000);
120: l_t_id NUMBER;
121: BEGIN
122:
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
125: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
126:
127: SELECT JTF_TASK_ASSIGNMENTS_AUDIT_S.nextval INTO l_t_id FROM DUAL;

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
190:
191: DO_TASK_AUDIT(p_record,x_return_status);
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: EXCEPTION WHEN OTHERS THEN
195: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
196: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
197: (

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: );
200: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
201: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204: END APPLY_INSERT;
205:
206:
207: /***

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: l_rc BOOLEAN;
217: l_access_id NUMBER;
218: BEGIN
219: /*** initialize return status and message list ***/
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: FND_MSG_PUB.INITIALIZE;
222:
223: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_RECORD for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
224: 'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: , p_token_name1 => 'DML'
244: , p_token_value1 => p_record.dmltype$$
245: );
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: END IF;
249:
250: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_RECORD for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
251: 'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: );
258: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
259: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: END APPLY_RECORD;
264:
265: /***

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: BEGIN
284: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES ',
285: 'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
286: g_debug_level := p_debug_level;
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: /*** loop through all the records in inqueue ***/
290: FOR r_ta_audit_rec IN c_ta_audit( p_user_name, p_tranid, p_assignment_id) LOOP
291: --SAVEPOINT save_rec ;

Line 301: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

297: , l_process_status
298: );
299:
300: /*** was record processed successfully? ***/
301: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
302: /*** Yes -> Reject record from inqueue ***/
303: CSM_UTIL_PKG.DELETE_RECORD
304: (
305: p_user_name,

Line 315: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

311: l_error_msg,
312: l_process_status
313: );
314: /*** was delete successful? ***/
315: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
316: /*** no -> rollback ***/
317: CSM_UTIL_PKG.LOG
318: ( 'Deleting from inqueue failed, No rolling back to savepoint'
319: || ' for Task Assignment Audit ID ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 320: x_return_status := FND_API.G_RET_STS_SUCCESS;

316: /*** no -> rollback ***/
317: CSM_UTIL_PKG.LOG
318: ( 'Deleting from inqueue failed, No rolling back to savepoint'
319: || ' for Task Assignment Audit ID ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: END IF;
322: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
323: /*** Record was not applied successfully -> defer and reject records ***/
324: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

Line 322: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

318: ( 'Deleting from inqueue failed, No rolling back to savepoint'
319: || ' for Task Assignment Audit ID ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: END IF;
322: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
323: /*** Record was not applied successfully -> defer and reject records ***/
324: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
325: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
326:

Line 340: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

336: , l_process_status
337: );
338:
339: /*** Was defer successful? ***/
340: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
341: /*** no -> rollback ***/
342: CSM_UTIL_PKG.LOG
343: ( 'Reject record failed, No rolling back to savepoint'
344: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: CSM_UTIL_PKG.LOG
343: ( 'Reject record failed, No rolling back to savepoint'
344: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
345: --ROLLBACK TO save_rec;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: END IF;
348: END IF;
349:
350: END LOOP;

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: /*** catch and log exceptions ***/
357: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
358: ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
359:
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: END APPLY_CLIENT_CHANGES;
363:
364: /***

Line 386: x_return_status := FND_API.G_RET_STS_SUCCESS;

382: BEGIN
383: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES ',
384: 'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
385: g_debug_level := p_debug_level;
386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: /*** loop through all the records in inqueue to Defer ***/
389: FOR r_ta_audit_rec IN c_ta_audit( p_user_name, p_tranid, p_assignment_id) LOOP
390:

Line 409: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

405: , r_ta_audit_rec.dmltype$$
406: );
407:
408: /*** Was defer successful? ***/
409: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
410: /*** no -> rollback ***/
411: CSM_UTIL_PKG.LOG
412: ( 'Defer record failed, No rolling back to savepoint'
413: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: CSM_UTIL_PKG.LOG
412: ( 'Defer record failed, No rolling back to savepoint'
413: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
414: --ROLLBACK TO save_rec;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: EXIT;
417: END IF;
418: END LOOP;
419: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: /*** catch and log exceptions ***/
424: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DEFER_CLIENT_CHANGES: ' || sqlerrm
425: ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
426:
427: x_return_status := FND_API.G_RET_STS_ERROR;
428:
429: END DEFER_CLIENT_CHANGES;
430:
431: END CSM_TA_AUDIT_PKG;