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 CSM_UTIL_PKG

Line 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 ,

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

Line 100: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DO_TASK_AUDIT: ' || sqlerrm

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

Line 124: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,

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

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

Line 188: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,

184: X_SHOW_ON_CALENDAR_CHANGED => NULL,
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:

Line 196: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
198: p_api_error => TRUE
199: );
200: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

Line 200: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

196: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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;

Line 223: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_RECORD for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,

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

Line 236: CSM_UTIL_PKG.LOG

232: x_return_status
233: );
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

Line 240: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
243: , p_token_name1 => 'DML'
244: , p_token_value1 => p_record.dmltype$$

Line 250: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_RECORD for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,

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);
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

Line 254: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
256: p_api_error => TRUE
257: );
258: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

Line 258: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

254: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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:

Line 284: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES ',

280: l_process_status VARCHAR2(1);
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:

Line 303: CSM_UTIL_PKG.DELETE_RECORD

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,
306: p_tranid,
307: r_ta_audit_rec.seqno$$,

Line 317: CSM_UTIL_PKG.LOG

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
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: END IF;

Line 324: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

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

Line 327: CSM_UTIL_PKG.REJECT_RECORD

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
330: , p_tranid
331: , r_ta_audit_rec.seqno$$

Line 342: CSM_UTIL_PKG.LOG

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

Line 352: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',

348: END IF;
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 ***/

Line 357: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

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
358: ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
359:
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:

Line 383: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES ',

379: l_process_status VARCHAR2(10);
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:

Line 392: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

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

Line 395: CSM_UTIL_PKG.DEFER_RECORD

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
398: , p_tranid
399: , r_ta_audit_rec.seqno$$

Line 411: CSM_UTIL_PKG.LOG

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

Line 419: CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',

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',
420: 'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
421: RETURN;
422: EXCEPTION WHEN OTHERS THEN
423: /*** catch and log exceptions ***/

Line 424: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.DEFER_CLIENT_CHANGES: ' || sqlerrm

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
425: ,'CSM_TA_AUDIT_PKG.DEFER_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
426:
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: