DBA Data[Home] [Help]

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.6 2008/03/24 09:01:14 ptomar 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 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 59: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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

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

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

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 ;

Line 582: END CSM_TASK_ASSIGNMENTS_PKG; -- Package spec

578: WHEN OTHERS THEN
579: RETURN 'C';
580: END CONFLICT_RESOLUTION_METHOD;
581:
582: END CSM_TASK_ASSIGNMENTS_PKG; -- Package spec