APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSM_TASK_ASSIGNMENTS_PKG

Line 1: PACKAGE BODY CSM_TASK_ASSIGNMENTS_PKG AS

1: PACKAGE BODY CSM_TASK_ASSIGNMENTS_PKG AS
2: /* $Header: csmutab.pls 120.11.12020000.5 2013/04/09 11:06:54 saradhak ship $ */
3:
4: /*
5: * The function to be called by CSM_SERVICEP_WRAPPER_PKG, for upward sync of

Line 19: g_object_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_PKG'; -- package name

15: -- --------- ------------------- ------------------------------------------
16: -- Enter package declarations as shown below
17:
18: /*** Globals ***/
19: g_object_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_PKG'; -- package name
20: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS'; -- publication item name
21: g_debug_level NUMBER; -- debug level
22:
23: CURSOR c_task_assignments_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS

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 61: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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 (
65: p_api_version => 1.0,

Line 425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '

421: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS AND
422: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE)
423: THEN
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',

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 ;

Line 896: END CSM_TASK_ASSIGNMENTS_PKG; -- Package spec

892: WHEN OTHERS THEN
893: RETURN 'C';
894: END CONFLICT_RESOLUTION_METHOD;
895:
896: END CSM_TASK_ASSIGNMENTS_PKG; -- Package spec