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_TASK_ASSIGNMENTS_PKG dependencies on CSM_UTIL_PKG

Line 58: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,

54: l_task_status_name varchar2(240);
55: l_task_type_id number;
56:
57: BEGIN
58: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,
59: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
60:
61: -- Create a Task Assignment
62: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (

Line 97: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

93: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
94: THEN
95:
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
98: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
99: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
100: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
101: RETURN ;

Line 134: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
131: THEN
132:
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
135: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
136: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
137: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
138: RETURN ;

Line 146: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',

142: -- success
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: EXCEPTION WHEN OTHERS THEN
146: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
147: FND_LOG.LEVEL_EXCEPTION );
148:
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END APPLY_INSERT;

Line 206: csm_util_pkg.log(p_error_msg,

202: IF(r_task_assignment.last_update_date <> p_record.server_last_update_date AND r_task_assignment.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
203: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
204: || p_record.task_assignment_id;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: csm_util_pkg.log(p_error_msg,
207: g_object_name || '.APPLY_UPDATE',
208: FND_LOG.LEVEL_ERROR);
209: RETURN;
210: END IF;

Line 240: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

236: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
237: THEN
238:
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
241: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
242: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
243: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
244: RETURN ;

Line 297: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
294: THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296:
297: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
298: || ' ROOT ERROR: csf_tasks_pub.Update_Task_Assignment'
299: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
300: g_object_name || '.APPLY_UPDATE',
301: FND_LOG.LEVEL_ERROR );

Line 310: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: EXCEPTION
309: WHEN others THEN
310: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
311: || ' for PK ' || p_record.task_assignment_id,
312: g_object_name || '.APPLY_UPDATE',
313: FND_LOG.LEVEL_EXCEPTION );
314:

Line 356: CSM_UTIL_PKG.LOG

352: );
353: ELSE
354: -- Process delete and insert;
355: -- Not supported for this entity
356: CSM_UTIL_PKG.LOG
357: ( 'Delete and Insert is not supported for this entity'
358: || ' for PK ' || p_record.task_assignment_id ,
359: g_object_name || '.APPLY_RECORD',
360: FND_LOG.LEVEL_ERROR);

Line 362: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

358: || ' for PK ' || p_record.task_assignment_id ,
359: g_object_name || '.APPLY_RECORD',
360: FND_LOG.LEVEL_ERROR);
361:
362: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
363: (
364: p_message => 'CSM_DML_OPERATION'
365: , p_token_name1 => 'DML'
366: , p_token_value1 => p_record.dmltype$$

Line 374: CSM_UTIL_PKG.LOG

370: END IF;
371:
372: EXCEPTION WHEN OTHERS THEN
373: /*** defer record when any process exception occurs ***/
374: CSM_UTIL_PKG.LOG
375: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
376: || ' for PK ' || p_record.task_assignment_id ,
377: g_object_name || '.APPLY_RECORD',
378: FND_LOG.LEVEL_EXCEPTION);

Line 380: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

376: || ' for PK ' || p_record.task_assignment_id ,
377: g_object_name || '.APPLY_RECORD',
378: FND_LOG.LEVEL_EXCEPTION);
379: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
380: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
381: (
382: p_api_error => TRUE
383: );
384:

Line 427: csm_util_pkg.log

423: l_dbl_count NUMBER := NULL;
424: l_header_id NUMBER := NULL;
425:
426: BEGIN
427: csm_util_pkg.log
428: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
429: g_object_name || '.APPLY_CLIENT_CHANGES',
430: FND_LOG.LEVEL_PROCEDURE);
431: g_debug_level := p_debug_level;

Line 471: CSM_UTIL_PKG.DELETE_RECORD

467: NULL;
468: END;
469:
470: /*** If Yes -> delete record from inqueue ***/
471: CSM_UTIL_PKG.DELETE_RECORD
472: (
473: p_user_name,
474: p_tranid,
475: r_task_assignments.seqno$$,

Line 486: CSM_UTIL_PKG.LOG

482:
483: /*** was delete successful? ***/
484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
485: /*** If No -> rollback ***/
486: CSM_UTIL_PKG.LOG
487: ( 'Deleting from inqueue failed, rolling back to savepoint'
488: || ' for PK ' || r_task_assignments.task_assignment_id ,
489: g_object_name || '.APPLY_CLIENT_CHANGES',
490: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 499: CSM_UTIL_PKG.LOG

495:
496: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
497: /*** Record was not processed successfully or delete failed
498: -> defer and reject record ***/
499: CSM_UTIL_PKG.LOG
500: ( 'Record not processed successfully, deferring and rejecting record'
501: || ' for PK ' || r_task_assignments.task_assignment_id ,
502: g_object_name || '.APPLY_CLIENT_CHANGES',
503: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 505: CSM_UTIL_PKG.DEFER_RECORD

501: || ' for PK ' || r_task_assignments.task_assignment_id ,
502: g_object_name || '.APPLY_CLIENT_CHANGES',
503: FND_LOG.LEVEL_ERROR); -- put PK column here
504:
505: CSM_UTIL_PKG.DEFER_RECORD
506: ( p_user_name
507: , p_tranid
508: , r_task_assignments.seqno$$
509: , r_task_assignments.task_assignment_id

Line 520: CSM_UTIL_PKG.LOG

516:
517: /*** Was defer successful? ***/
518: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
519: /*** no -> rollback ***/
520: CSM_UTIL_PKG.LOG
521: ( 'Defer record failed, rolling back to savepoint'
522: || ' for PK ' || r_task_assignments.task_assignment_id ,
523: g_object_name || '.APPLY_CLIENT_CHANGES',
524: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 538: CSM_UTIL_PKG.LOG

534: CLOSE c_chk_task_status;
535: END IF;
536:
537: /*** catch and log exceptions ***/
538: CSM_UTIL_PKG.LOG
539: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
540: g_object_name || '.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
541: x_return_status := FND_API.G_RET_STS_ERROR;
542:

Line 564: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

560: AND seqno$$ = l_sequence
561: AND a.task_assignment_id = b.task_assignment_id ;
562:
563: BEGIN
564: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_TASK_ASSIGNMENTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
565: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
566: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
567: FETCH get_user_id
568: INTO l_user_id ;