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.

[Home] [Help]

APPS.CSM_SERVICE_REQUESTS_PKG dependencies on FND_PROFILE

Line 184: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));

180: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
181:
182: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
183: l_created_by := p_record.CREATED_BY;
184: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));
185:
186: --get responsiblity from asg_user
187: OPEN c_csm_resp(l_user_id);
188: FETCH c_csm_resp INTO l_responsibility_id;

Line 201: l_freeform := fnd_profile.value_specific('CSM_ALLOW_FREE_FORM_IB'

197: l_resp_id := l_responsibility_id;
198: END IF;
199: --get all Profile Values
200: --Get the value for Free Form IB profile
201: l_freeform := fnd_profile.value_specific('CSM_ALLOW_FREE_FORM_IB'
202: , p_record.created_by
203: , l_responsibility_id
204: , l_csm_appl_id);
205: l_auto_generate_task := fnd_profile.value_specific('CS_SR_AUTO_TASK_CREATE'

Line 205: l_auto_generate_task := fnd_profile.value_specific('CS_SR_AUTO_TASK_CREATE'

201: l_freeform := fnd_profile.value_specific('CSM_ALLOW_FREE_FORM_IB'
202: , p_record.created_by
203: , l_responsibility_id
204: , l_csm_appl_id);
205: l_auto_generate_task := fnd_profile.value_specific('CS_SR_AUTO_TASK_CREATE'
206: , p_record.created_by
207: , l_responsibility_id
208: , l_csm_appl_id);
209:

Line 210: l_CS_INV_ORG_ID := fnd_profile.value_specific('CS_INV_VALIDATION_ORG'

206: , p_record.created_by
207: , l_responsibility_id
208: , l_csm_appl_id);
209:
210: l_CS_INV_ORG_ID := fnd_profile.value_specific('CS_INV_VALIDATION_ORG'
211: , p_record.created_by
212: , l_responsibility_id
213: , l_csm_appl_id);
214:

Line 215: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',

211: , p_record.created_by
212: , l_responsibility_id
213: , l_csm_appl_id);
214:
215: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',
216: USER_ID => p_record.created_by ,
217: RESPONSIBILITY_ID => l_responsibility_id ,
218: APPLICATION_ID => l_csm_appl_id ));
219:

Line 556: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);

552:
553: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
554: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
555: -- Check for Stale data
556: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
557: if l_profile_value = 'SERVER_WINS' AND
558: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then
559: open c_last_update_date(b_incident_id => p_record.incident_id);
560: fetch c_last_update_date into r_last_update_date;

Line 586: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));

582:
583: -- Lookup the user_id
584: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
585: l_last_updated_by := p_record.LAST_UPDATED_BY;
586: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));
587: --Get Mobile responsibility
588: OPEN c_csm_resp(l_user_id);
589: FETCH c_csm_resp INTO l_responsibility_id;
590: CLOSE c_csm_resp;

Line 601: l_freeform := fnd_profile.value_specific('CSM_ALLOW_FREE_FORM_IB'

597: l_resp_id := l_responsibility_id;
598: END IF;
599: --Get all profile Values
600: --Get the value for Free Form IB profile
601: l_freeform := fnd_profile.value_specific('CSM_ALLOW_FREE_FORM_IB'
602: , p_record.created_by
603: , l_responsibility_id
604: , l_csm_appl_id);
605:

Line 606: l_CS_INV_ORG_ID := fnd_profile.value_specific('CS_INV_VALIDATION_ORG'

602: , p_record.created_by
603: , l_responsibility_id
604: , l_csm_appl_id);
605:
606: l_CS_INV_ORG_ID := fnd_profile.value_specific('CS_INV_VALIDATION_ORG'
607: , p_record.created_by
608: , l_responsibility_id
609: , l_csm_appl_id);
610:

Line 611: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',

607: , p_record.created_by
608: , l_responsibility_id
609: , l_csm_appl_id);
610:
611: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',
612: USER_ID => p_record.created_by ,
613: RESPONSIBILITY_ID => l_responsibility_id ,
614: APPLICATION_ID => l_csm_appl_id ));
615: IF l_freeform IS NULL THEN

Line 647: l_sr_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');

643: l_sr_rec.OWNER_ID := p_record.INCIDENT_OWNER_ID;
644: l_sr_rec.last_update_program_code := 'CSM_UPSYNC_WRAPPER';
645:
646: IF p_record.OWNER_GROUP_ID IS NOT NULL THEN
647: l_sr_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');
648: END IF;
649:
650: IF l_freeform = 'Y' AND (p_record.FREE_FORM_INSTANCE IS NOT NULL OR p_record.FREE_FORM_SERIAL IS NOT NULL)THEN
651:

Line 1095: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);

1091: AND a.incident_id = b.incident_id ;
1092:
1093: BEGIN
1094: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
1095: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
1096: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
1097: FETCH get_user_id
1098: INTO l_user_id ;
1099: CLOSE get_user_id ;