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_LOG

Line 31: 'CSM_TA_AUDIT_PKG.DO_TASK_AUDIT',FND_LOG.LEVEL_PROCEDURE);

27:
28: SELECT JTF_TASK_AUDITS_S.nextval INTO l_t_id FROM DUAL;
29:
30: CSM_UTIL_PKG.LOG('Entered CSM_TA_AUDIT_PKG.DO_TASK_AUDIT for audit Id:'||l_t_id||' for Task ID ' || p_record.TASK_ID ,
31: 'CSM_TA_AUDIT_PKG.DO_TASK_AUDIT',FND_LOG.LEVEL_PROCEDURE);
32:
33: SELECT OBJECT_VERSION_NUMBER INTO l_ovn FROM JTF_TASKS_B WHERE TASK_ID=p_record.TASK_ID;
34:
35:

Line 101: || ' for Task ID ' || p_record.TASK_ID ,'CSM_TA_AUDIT_PKG.DO_TASK_AUDIT',FND_LOG.LEVEL_EXCEPTION);

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
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:

Line 125: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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;
128:
129: CSM_UTIL_PKG.LOG('Before calling JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW for Task Assignment Audit ID ' || l_t_id ,

Line 130: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

126:
127: SELECT JTF_TASK_ASSIGNMENTS_AUDIT_S.nextval INTO l_t_id FROM DUAL;
128:
129: CSM_UTIL_PKG.LOG('Before calling JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW for Task Assignment Audit ID ' || l_t_id ,
130: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
131: --We are calling this API as they do not support old values
132: --in create_task_assignment_audit procedure
133: JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW(
134: X_ASSIGNMENT_AUDIT_ID => l_t_id,

Line 189: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

185: X_SCHEDULED_FLAG_CHANGED => NULL
186: );
187:
188: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
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;

Line 201: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

197: (
198: p_api_error => TRUE
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:

Line 224: 'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
225:
226: IF p_record.dmltype$$='I' THEN
227: -- Process insert
228: APPLY_INSERT

Line 238: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

234: ELSE --Delete and update is not supported for this PI
235: -- invalid dml type
236: CSM_UTIL_PKG.LOG
237: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
238: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
239:
240: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
241: (
242: p_message => 'CSM_DML_OPERATION'

Line 251: 'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
252: EXCEPTION WHEN OTHERS THEN
253: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
254: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
255: (

Line 259: || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

255: (
256: p_api_error => TRUE
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;

Line 285: 'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

281: l_error_msg VARCHAR2(4000);
282:
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 ***/

Line 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

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
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 ***/

Line 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

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:
327: CSM_UTIL_PKG.REJECT_RECORD
328: (
329: p_user_name

Line 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

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
345: --ROLLBACK TO save_rec;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: END IF;
348: END IF;

Line 353: 'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

349:
350: END LOOP;
351:
352: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',
353: 'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
354:
355: EXCEPTION WHEN OTHERS THEN
356: /*** catch and log exceptions ***/
357: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

Line 358: ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

354:
355: EXCEPTION WHEN OTHERS THEN
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;

Line 384: 'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

380: l_error_msg VARCHAR2(4000);
381:
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 ***/

Line 393: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

389: FOR r_ta_audit_rec IN c_ta_audit( p_user_name, p_tranid, p_assignment_id) LOOP
390:
391: /*** Parent Task Assignment Defered and hence Defer the TA Audit records ***/
392: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
393: || ' for PK ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
394:
395: CSM_UTIL_PKG.DEFER_RECORD
396: (
397: p_user_name

Line 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

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
414: --ROLLBACK TO save_rec;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: EXIT;
417: END IF;

Line 420: 'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

416: EXIT;
417: END IF;
418: END LOOP;
419: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',
420: 'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
421: RETURN;
422: EXCEPTION WHEN OTHERS THEN
423: /*** catch and log exceptions ***/
424: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DEFER_CLIENT_CHANGES: ' || sqlerrm

Line 425: ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

421: RETURN;
422: EXCEPTION WHEN OTHERS THEN
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;