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 187: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

183: END IF;
184: ELSE
185: x_return_status := FND_API.G_RET_STS_ERROR;
186:
187: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
188: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
189: || ' for PK ' || p_record.TASK_ID || l_msg_data,
190: g_object_name || '.APPLY_INSERT',
191: FND_LOG.LEVEL_ERROR );

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

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

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

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

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

329:
330: IF c_last_update_date%FOUND THEN
331: 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
332: CLOSE c_last_update_date;
333: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_INSERT:'
334: || ' for PK ' || p_record.task_id,
335: g_object_name || '.APPLY_INSERT',
336: FND_LOG.LEVEL_PROCEDURE );
337: fnd_message.set_name

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

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

Line 369: l_planned_effort := csm_util_pkg.Get_Datediff_For_Req_UOM(

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

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

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

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

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

Line 483: CSM_UTIL_PKG.LOG

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

Line 489: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 502: CSM_UTIL_PKG.LOG

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

Line 509: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 536: csm_util_pkg.log

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

Line 562: CSM_UTIL_PKG.REJECT_RECORD

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

Line 577: CSM_UTIL_PKG.DELETE_RECORD

573:
574: --Bug 8931803 - Asg REJECT_ROW doesn't call delete_row on reapply as the record was deferred.
575: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
576: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_tasks.seqno$$)=FND_API.G_TRUE) THEN
577: CSM_UTIL_PKG.DELETE_RECORD
578: (
579: p_user_name,
580: p_tranid,
581: r_tasks.seqno$$,

Line 590: CSM_UTIL_PKG.DELETE_RECORD

586: l_return_status
587: );
588: END IF;
589: ELSE
590: CSM_UTIL_PKG.DELETE_RECORD
591: (
592: p_user_name,
593: p_tranid,
594: r_tasks.seqno$$,

Line 605: CSM_UTIL_PKG.LOG

601: END IF;
602: /*** was delete/reject successful? ***/
603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: /*** If No -> rollback ***/
605: CSM_UTIL_PKG.LOG
606: ( 'Deleting from inqueue failed, rolling back to savepoint'
607: || ' for PK ' || r_tasks.task_id ,
608: g_object_name || '.APPLY_CLIENT_CHANGES',
609: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 618: CSM_UTIL_PKG.LOG

614:
615: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
616: /*** Record was not processed successfully or delete failed
617: -> defer and reject record ***/
618: CSM_UTIL_PKG.LOG
619: ( 'Record not processed successfully, deferring and rejecting record'
620: || ' for PK ' || r_tasks.task_id ,
621: g_object_name || '.APPLY_CLIENT_CHANGES',
622: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 624: CSM_UTIL_PKG.DEFER_RECORD

620: || ' for PK ' || r_tasks.task_id ,
621: g_object_name || '.APPLY_CLIENT_CHANGES',
622: FND_LOG.LEVEL_ERROR); -- put PK column here
623:
624: CSM_UTIL_PKG.DEFER_RECORD
625: ( p_user_name
626: , p_tranid
627: , r_tasks.seqno$$
628: , r_tasks.task_id

Line 639: CSM_UTIL_PKG.LOG

635:
636: /*** Was defer successful? ***/
637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
638: /*** no -> rollback ***/
639: CSM_UTIL_PKG.LOG
640: ( 'Defer record failed, rolling back to savepoint'
641: || ' for PK ' || r_tasks.task_id ,
642: g_object_name || '.APPLY_CLIENT_CHANGES',
643: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 653: CSM_UTIL_PKG.LOG

649: END LOOP;
650:
651: EXCEPTION WHEN OTHERS THEN
652: /*** catch and log exceptions ***/
653: CSM_UTIL_PKG.LOG
654: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
655: g_object_name || '.APPLY_CLIENT_CHANGES',
656: FND_LOG.LEVEL_EXCEPTION);
657: x_return_status := FND_API.G_RET_STS_ERROR;