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 60: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,

56: WHERE jta.task_assignment_id = b_task_assignment_id;
57:
58:
59: BEGIN
60: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,
61: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
62:
63: -- Create a Task Assignment
64: csf_task_assignments_pub.create_task_assignment (

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

109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
110: THEN
111:
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
114: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
115: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
116: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
117: RETURN ;

Line 136: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,

132: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
133: USING FND_API.G_FALSE;
134: EXCEPTION
135: WHEN OTHERS THEN
136: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
137: 'CSM_TASK_ASSIGNMENT_PKG.apply_insert', FND_LOG.LEVEL_PROCEDURE);
138: END;
139:
140: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);

Line 140: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);

136: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
137: 'CSM_TASK_ASSIGNMENT_PKG.apply_insert', FND_LOG.LEVEL_PROCEDURE);
138: END;
139:
140: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
141:
142: csf_task_assignments_pub.update_assignment_status
143: ( p_api_version => 1.0
144: , p_init_msg_list => FND_API.G_TRUE

Line 158: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);

154: , x_task_object_version_number => l_task_object_version_number
155: , x_task_status_id => l_task_status_id
156: );
157:
158: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);
159:
160: END IF;
161:
162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
163: THEN
164:
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
167: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
168: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
169: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
170: RETURN ;

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

174: -- success
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: EXCEPTION WHEN OTHERS THEN
178: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
179: FND_LOG.LEVEL_EXCEPTION );
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END APPLY_INSERT;

Line 372: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',

368:
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: EXCEPTION WHEN OTHERS THEN
372: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
373: FND_LOG.LEVEL_EXCEPTION );
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: END APPLY_UNDO;
376:

Line 428: csm_util_pkg.log(p_error_msg,

424: 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
425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
426: || p_record.task_assignment_id;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: csm_util_pkg.log(p_error_msg,
429: g_object_name || '.APPLY_UPDATE',
430: FND_LOG.LEVEL_ERROR);
431: RETURN;
432: END IF;

Line 450: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,

446: EXECUTE IMMEDIATE 'BEGIN CSF_DEBRIEF_PUB.SET_AUTO_DEBRIEF(FND_API.TO_BOOLEAN(:1)); END;'
447: USING FND_API.G_FALSE;
448: EXCEPTION
449: WHEN OTHERS THEN
450: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
451: 'CSM_TASK_ASSIGNMENT_PKG.apply_update', FND_LOG.LEVEL_PROCEDURE);
452: END;
453:
454: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);

Line 454: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);

450: CSM_UTIL_PKG.LOG('Exception raised when calling csf_debrief_pub.set_auto_debrief(FALSE): ' || SQLERRM,
451: 'CSM_TASK_ASSIGNMENT_PKG.apply_update', FND_LOG.LEVEL_PROCEDURE);
452: END;
453:
454: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'N' ,p_old_val=> NULL);
455:
456: csf_task_assignments_pub.update_assignment_status
457: ( p_api_version => 1.0
458: , p_init_msg_list => FND_API.G_TRUE

Line 472: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);

468: , x_task_object_version_number => l_task_object_version_number
469: , x_task_status_id => l_task_status_id
470: );
471:
472: l_audit_curr_prf:=CSM_UTIL_PKG.set_task_audit(p_new_val=>'Y' ,p_old_val=> l_audit_curr_prf);
473:
474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
475: THEN
476:

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

474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
475: THEN
476:
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
479: || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
480: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
481: g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
482: RETURN ;

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

531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: x_return_status := FND_API.G_RET_STS_ERROR;
534:
535: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
536: || ' ROOT ERROR: csf_tasks_pub.Update_Task_Assignment'
537: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
538: g_object_name || '.APPLY_UPDATE',
539: FND_LOG.LEVEL_ERROR );

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

544: x_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: EXCEPTION
547: WHEN others THEN
548: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
549: || ' for PK ' || p_record.task_assignment_id,
550: g_object_name || '.APPLY_UPDATE',
551: FND_LOG.LEVEL_EXCEPTION );
552:

Line 598: CSM_UTIL_PKG.LOG('Task is about to be closed. So Processing debriefs first ' ,'CSM_TASK_ASSIGNMENT_PKG.apply_record', FND_LOG.LEVEL_PROCEDURE);

594: FETCH c_new_status_closed INTO l_is_closed;
595: CLOSE c_new_status_closed;
596:
597: IF l_is_closed='Y' THEN
598: CSM_UTIL_PKG.LOG('Task is about to be closed. So Processing debriefs first ' ,'CSM_TASK_ASSIGNMENT_PKG.apply_record', FND_LOG.LEVEL_PROCEDURE);
599: CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
600: CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
601: CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);
602: CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES(p_record.clid$$cs, p_record.tranid$$, g_debug_level, x_return_status,p_record.task_assignment_id);

Line 615: CSM_UTIL_PKG.LOG

611: );
612: ELSE
613: -- Process delete and insert;
614: -- Not supported for this entity
615: CSM_UTIL_PKG.LOG
616: ( 'Delete and Insert is not supported for this entity'
617: || ' for PK ' || p_record.task_assignment_id ,
618: g_object_name || '.APPLY_RECORD',
619: FND_LOG.LEVEL_ERROR);

Line 621: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

617: || ' for PK ' || p_record.task_assignment_id ,
618: g_object_name || '.APPLY_RECORD',
619: FND_LOG.LEVEL_ERROR);
620:
621: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
622: (
623: p_message => 'CSM_DML_OPERATION'
624: , p_token_name1 => 'DML'
625: , p_token_value1 => p_record.dmltype$$

Line 633: CSM_UTIL_PKG.LOG

629: END IF;
630:
631: EXCEPTION WHEN OTHERS THEN
632: /*** defer record when any process exception occurs ***/
633: CSM_UTIL_PKG.LOG
634: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
635: || ' for PK ' || p_record.task_assignment_id ,
636: g_object_name || '.APPLY_RECORD',
637: FND_LOG.LEVEL_EXCEPTION);

Line 639: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

635: || ' for PK ' || p_record.task_assignment_id ,
636: g_object_name || '.APPLY_RECORD',
637: FND_LOG.LEVEL_EXCEPTION);
638: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
639: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
640: (
641: p_api_error => TRUE
642: );
643:

Line 695: csm_util_pkg.log

691: l_err_message VARCHAR2(4000);
692: l_return_status VARCHAR2(100);
693: l_user_id NUMBER; l_resp_id NUMBER;l_app_id NUMBER;
694: BEGIN
695: csm_util_pkg.log
696: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
697: g_object_name || '.APPLY_CLIENT_CHANGES',
698: FND_LOG.LEVEL_PROCEDURE);
699: g_debug_level := p_debug_level;

Line 745: CSM_UTIL_PKG.DELETE_RECORD

741: NULL;
742: END;
743:
744: /*** If Yes -> delete record from inqueue ***/
745: CSM_UTIL_PKG.DELETE_RECORD
746: (
747: p_user_name,
748: p_tranid,
749: r_task_assignments.seqno$$,

Line 775: CSM_UTIL_PKG.LOG

771:
772: /*** was TA AUDIT UPLOAD successful? ***/
773: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
774: /*** If No -> rollback ***/
775: CSM_UTIL_PKG.LOG
776: ( 'Inserting Task Assignment Audit Failed, Task Assignment Audit Failed for '
777: || ' for PK ' || r_task_assignments.task_assignment_id ,
778: g_object_name || '.APPLY_CLIENT_CHANGES',
779: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 784: CSM_UTIL_PKG.LOG

780: END IF;
781:
782: ELSE
783: /*** If No -> rollback ***/
784: CSM_UTIL_PKG.LOG
785: ( 'Deleting from inqueue failed, rolling back to savepoint'
786: || ' for PK ' || r_task_assignments.task_assignment_id ,
787: g_object_name || '.APPLY_CLIENT_CHANGES',
788: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 795: CSM_UTIL_PKG.LOG

791: END IF;
792: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
793: /*** Record was not processed successfully or delete failed
794: -> defer and reject record ***/
795: CSM_UTIL_PKG.LOG
796: ( 'Record not processed successfully, deferring and rejecting record'
797: || ' for PK ' || r_task_assignments.task_assignment_id ,
798: g_object_name || '.APPLY_CLIENT_CHANGES',
799: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 801: CSM_UTIL_PKG.DEFER_RECORD

797: || ' for PK ' || r_task_assignments.task_assignment_id ,
798: g_object_name || '.APPLY_CLIENT_CHANGES',
799: FND_LOG.LEVEL_ERROR); -- put PK column here
800:
801: CSM_UTIL_PKG.DEFER_RECORD
802: ( p_user_name
803: , p_tranid
804: , r_task_assignments.seqno$$
805: , r_task_assignments.task_assignment_id

Line 815: CSM_UTIL_PKG.LOG

811: );
812:
813: /*** Was defer successful? ***/
814: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
815: CSM_UTIL_PKG.LOG
816: ( 'Inserting Task Assignment Audit , Task Assignment Audit for '
817: || ' for PK ' || r_task_assignments.task_assignment_id ,
818: g_object_name || '.APPLY_CLIENT_CHANGES',
819: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 834: CSM_UTIL_PKG.LOG

830: END IF;
831:
832: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
833: /*** no -> rollback ***/
834: CSM_UTIL_PKG.LOG
835: ( 'Defer record failed, rolling back to savepoint'
836: || ' for PK ' || r_task_assignments.task_assignment_id ,
837: g_object_name || '.APPLY_CLIENT_CHANGES',
838: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 852: CSM_UTIL_PKG.LOG

848: CLOSE c_chk_task_status;
849: END IF;
850:
851: /*** catch and log exceptions ***/
852: CSM_UTIL_PKG.LOG
853: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
854: g_object_name || '.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
855: x_return_status := FND_API.G_RET_STS_ERROR;
856:

Line 878: 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);

874: AND seqno$$ = l_sequence
875: AND a.task_assignment_id = b.task_assignment_id ;
876:
877: BEGIN
878: 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);
879: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
880: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
881: FETCH get_user_id
882: INTO l_user_id ;