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

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

177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
178: THEN
179: x_return_status := FND_API.G_RET_STS_ERROR;
180:
181: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
182: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
183: || ' for PK ' || p_record.TASK_ID || l_msg_data,
184: g_object_name || '.APPLY_INSERT',
185: FND_LOG.LEVEL_ERROR );

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

255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258:
259: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
260: || ' ROOT ERROR: jtf_tasks_pub.Create_Task'
261: || ' for PK ' || p_record.TASK_ID,
262: g_object_name || '.APPLY_INSERT',
263: FND_LOG.LEVEL_ERROR );

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

268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: EXCEPTION
271: WHEN others THEN
272: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
273: || ' for PK ' || p_record.task_id,
274: g_object_name || '.APPLY_INSERT',
275: FND_LOG.LEVEL_EXCEPTION );
276:

Line 331: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_INSERT:'

327:
328: IF c_last_update_date%FOUND THEN
329: IF (r_last_update_date.last_update_date <> p_record.server_last_update_date AND r_last_update_date.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
330: CLOSE c_last_update_date;
331: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_INSERT:'
332: || ' for PK ' || p_record.task_id,
333: g_object_name || '.APPLY_INSERT',
334: FND_LOG.LEVEL_PROCEDURE );
335: fnd_message.set_name

Line 344: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_INSERT:',

340: x_return_status := FND_API.G_RET_STS_ERROR;
341: RETURN;
342: END IF;
343: ELSE
344: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_INSERT:',
345: g_object_name || '.APPLY_INSERT',
346: FND_LOG.LEVEL_PROCEDURE );
347: END IF;
348: CLOSE c_last_update_date;

Line 367: l_planned_effort := csm_util_pkg.Get_Datediff_For_Req_UOM(

363:
364: l_uom_class := CSM_PROFILE_PKG.VALUE_SPECIFIC('JTF_TIME_UOM_CLASS',l_user_id,NULL,NULL);
365: l_min_uom := CSM_PROFILE_PKG.VALUE_SPECIFIC('CSF_UOM_MINUTES',l_user_id,NULL,NULL);
366: --Get planned effort for the required UOM
367: l_planned_effort := csm_util_pkg.Get_Datediff_For_Req_UOM(
368: p_record.scheduled_start_date,
369: p_record.scheduled_end_date,
370: l_uom_class,
371: l_plan_eff_uom,

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

415: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
416: THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418:
419: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
420: || ' ROOT ERROR: jtf_tasks_pub.UPDATE_TASK'
421: || ' for PK ' || p_record.TASK_ID,
422: g_object_name || '.APPLY_UPDATE',
423: FND_LOG.LEVEL_ERROR );

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

428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:
430: EXCEPTION
431: WHEN others THEN
432: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
433: || ' for PK ' || p_record.task_id,
434: g_object_name || '.APPLY_UPDATE',
435: FND_LOG.LEVEL_EXCEPTION );
436:

Line 480: CSM_UTIL_PKG.LOG

476: );
477: ELSE
478: -- Process delete and insert;
479: -- Not supported for this entity
480: CSM_UTIL_PKG.LOG
481: ( 'Delete and Update is not supported for this entity'
482: || ' for PK ' || p_record.task_id ,
483: g_object_name || '.APPLY_RECORD',
484: FND_LOG.LEVEL_ERROR);

Line 486: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

482: || ' for PK ' || p_record.task_id ,
483: g_object_name || '.APPLY_RECORD',
484: FND_LOG.LEVEL_ERROR);
485:
486: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
487: (
488: p_message => 'CSM_DML_OPERATION'
489: , p_token_name1 => 'DML'
490: , p_token_value1 => p_record.dmltype$$

Line 499: CSM_UTIL_PKG.LOG

495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: /*** defer record when any process exception occurs ***/
499: CSM_UTIL_PKG.LOG
500: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
501: || ' for PK ' || p_record.task_id ,
502: g_object_name || '.APPLY_RECORD',
503: FND_LOG.LEVEL_EXCEPTION);

Line 506: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

502: g_object_name || '.APPLY_RECORD',
503: FND_LOG.LEVEL_EXCEPTION);
504: -- temp -- find more detail --remove comment
505: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
506: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
507: (
508: p_api_error => TRUE
509: );
510:

Line 533: csm_util_pkg.log

529: l_return_status VARCHAR2(1);
530: l_error_msg VARCHAR2(4000);
531: l_reject_row boolean;
532: BEGIN
533: csm_util_pkg.log
534: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
535: g_object_name || '.APPLY_CLIENT_CHANGES',
536: FND_LOG.LEVEL_PROCEDURE);
537: g_debug_level := p_debug_level;

Line 559: CSM_UTIL_PKG.REJECT_RECORD

555: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
556: /*** If Yes -> delete record from inqueue ***/
557: --Bug 5288413
558: IF l_reject_row THEN
559: CSM_UTIL_PKG.REJECT_RECORD
560: (
561: p_user_name,
562: p_tranid,
563: r_tasks.seqno$$,

Line 571: CSM_UTIL_PKG.DELETE_RECORD

567: l_error_msg,
568: l_return_status
569: );
570: ELSE
571: CSM_UTIL_PKG.DELETE_RECORD
572: (
573: p_user_name,
574: p_tranid,
575: r_tasks.seqno$$,

Line 586: CSM_UTIL_PKG.LOG

582: END IF;
583: /*** was delete/reject successful? ***/
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: /*** If No -> rollback ***/
586: CSM_UTIL_PKG.LOG
587: ( 'Deleting from inqueue failed, rolling back to savepoint'
588: || ' for PK ' || r_tasks.task_id ,
589: g_object_name || '.APPLY_CLIENT_CHANGES',
590: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 599: CSM_UTIL_PKG.LOG

595:
596: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
597: /*** Record was not processed successfully or delete failed
598: -> defer and reject record ***/
599: CSM_UTIL_PKG.LOG
600: ( 'Record not processed successfully, deferring and rejecting record'
601: || ' for PK ' || r_tasks.task_id ,
602: g_object_name || '.APPLY_CLIENT_CHANGES',
603: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 605: CSM_UTIL_PKG.DEFER_RECORD

601: || ' for PK ' || r_tasks.task_id ,
602: g_object_name || '.APPLY_CLIENT_CHANGES',
603: FND_LOG.LEVEL_ERROR); -- put PK column here
604:
605: CSM_UTIL_PKG.DEFER_RECORD
606: ( p_user_name
607: , p_tranid
608: , r_tasks.seqno$$
609: , r_tasks.task_id

Line 620: CSM_UTIL_PKG.LOG

616:
617: /*** Was defer successful? ***/
618: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
619: /*** no -> rollback ***/
620: CSM_UTIL_PKG.LOG
621: ( 'Defer record failed, rolling back to savepoint'
622: || ' for PK ' || r_tasks.task_id ,
623: g_object_name || '.APPLY_CLIENT_CHANGES',
624: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 634: CSM_UTIL_PKG.LOG

630: END LOOP;
631:
632: EXCEPTION WHEN OTHERS THEN
633: /*** catch and log exceptions ***/
634: CSM_UTIL_PKG.LOG
635: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
636: g_object_name || '.APPLY_CLIENT_CHANGES',
637: FND_LOG.LEVEL_EXCEPTION);
638: x_return_status := FND_API.G_RET_STS_ERROR;