APPS.CSM_SERVICE_REQUESTS_PKG dependencies on FND_PROFILE

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

149: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
150:
151: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
152: l_created_by := p_record.CREATED_BY;
153: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));
154:
155: --get responsiblity from asg_user
156: OPEN c_csm_resp(l_user_id);
157: FETCH c_csm_resp INTO l_responsibility_id;

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

166: l_resp_id := l_responsibility_id;
167: END IF;
168:
169: --Get the value for Auto Create Task
170: l_auto_generate_task := fnd_profile.value_specific('CS_SR_AUTO_TASK_CREATE'
171: , p_record.created_by
172: , l_responsibility_id
173: , l_csm_appl_id);
174:

Line 208: l_sr_rec.inventory_org_id := NVL(p_record.inv_organization_id, TO_NUMBER(fnd_profile.value('CS_INV_VALIDATION_ORG'))) ;

204: l_sr_rec.owner_group_id := NULL;
205: l_sr_rec.CUSTOMER_PRODUCT_ID := p_record.CUSTOMER_PRODUCT_ID;
206: l_sr_rec.INVENTORY_ITEM_ID := p_record.INVENTORY_ITEM_ID;
207: l_sr_rec.current_serial_number := p_record.current_serial_number ;
208: l_sr_rec.inventory_org_id := NVL(p_record.inv_organization_id, TO_NUMBER(fnd_profile.value('CS_INV_VALIDATION_ORG'))) ;
209: l_sr_rec.PROBLEM_CODE := p_record.PROBLEM_CODE;
210: l_sr_rec.RESOLUTION_CODE := p_record.RESOLUTION_CODE;
211: l_sr_rec.INV_ITEM_REVISION := p_record.INV_ITEM_REVISION;
212: l_sr_rec.CUST_PO_NUMBER := p_record.CUSTOMER_PO_NUMBER;

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

248: l_sr_rec.external_context := p_record.EXTERNAL_CONTEXT;
249: l_sr_rec.creation_program_code := 'CSM_UPSYNC_WRAPPER';
250: l_sr_rec.incident_location_id := p_record.incident_location_id;
251: l_sr_rec.incident_location_type := nvl(p_record.incident_location_type, 'HZ_PARTY_SITE');
252: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',
253: USER_ID => l_user_id ,
254: RESPONSIBILITY_ID => l_resp_id ,
255: APPLICATION_ID => l_csm_appl_id ));
256:

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

454:
455: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
456: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
457: -- Check for Stale data
458: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
459: if l_profile_value = 'SERVER_WINS' AND
460: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then
461: open c_last_update_date(b_incident_id => p_record.incident_id);
462: fetch c_last_update_date into r_last_update_date;

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

484:
485: -- Lookup the user_id
486: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
487: l_last_updated_by := p_record.LAST_UPDATED_BY;
488: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));
489:
490: IF l_resp_id IS NULL THEN
491: OPEN c_csm_resp(l_user_id);
492: FETCH c_csm_resp INTO l_resp_id;

Line 564: l_sr_rec.inventory_org_id := NVL(p_record.inv_organization_id, TO_NUMBER(fnd_profile.value('CS_INV_VALIDATION_ORG'))) ;

560: l_sr_rec.CUSTOMER_PRODUCT_ID := p_record.CUSTOMER_PRODUCT_ID;
561: l_sr_rec.INVENTORY_ITEM_ID := p_record.INVENTORY_ITEM_ID;
562: l_sr_rec.current_serial_number := p_record.current_serial_number ;
563: -- l_sr_rec.inventory_org_id := p_record.inv_organization_id ;
564: l_sr_rec.inventory_org_id := NVL(p_record.inv_organization_id, TO_NUMBER(fnd_profile.value('CS_INV_VALIDATION_ORG'))) ;
565:
566: -- Bug 4024541 deferred transactions due to invalid inventory_item_id
567: -- validate item/org; if invalid get org from master organization
568: OPEN c_validate_item_org(p_inventory_item_id => l_sr_rec.INVENTORY_ITEM_ID,

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

590: l_sr_rec.OWNER_GROUP_ID := p_record.OWNER_GROUP_ID;
591: l_sr_rec.OWNER_ID := p_record.INCIDENT_OWNER_ID;
592:
593: IF p_record.OWNER_GROUP_ID IS NOT NULL THEN
594: l_sr_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');
595: END IF;
596:
597: --ANURAG
598: --credit card number received from client side is in base 64 encoding.

Line 602: l_profile_value := fnd_profile.value('JTM_CREDIT_CARD_ENABLED');

598: --credit card number received from client side is in base 64 encoding.
599: --We need to decode this, before passing to SR API
600: --CREDIT CARD FUNCTIONALITY DISABLED IN R12
601: /*
602: l_profile_value := fnd_profile.value('JTM_CREDIT_CARD_ENABLED');
603: IF l_profile_value = 'Y' THEN
604: IF p_record.CREDIT_CARD_NUMBER IS NOT NULL THEN
605: l_sr_rec.cc_number := p_record.credit_card_number;
606: l_sr_rec.cc_type_code := p_record.CREDIT_CARD_TYPE_CODE ;

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

646: l_sr_rec.external_attribute_15 := p_record.EXTERNAL_ATTRIBUTE_15;
647: l_sr_rec.external_context := p_record.EXTERNAL_CONTEXT;
648:
649: --ER 4105956
650: l_sr_rec.time_zone_id := TO_NUMBER(FND_PROFILE.VALUE_SPECIFIC(NAME => 'CLIENT_TIMEZONE_ID',
651: USER_ID => l_user_id ,
652: RESPONSIBILITY_ID => l_resp_id ,
653: APPLICATION_ID => l_csm_appl_id ));
654:

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

952: AND a.incident_id = b.incident_id ;
953:
954: BEGIN
955: 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);
956: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
957: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
958: FETCH get_user_id
959: INTO l_user_id ;
960: CLOSE get_user_id ;