[Home] [Help]
186: --Importance Level(COVTYP_IMP).
187: --Default value: Resolution time (to be backward compatible)
188:
189:
190: px_inp_rec.sort_key := fnd_profile.value('CS_SR_CONTRACT_SORT_ORDER');
191: if px_inp_rec.sort_key is null then
192: px_inp_rec.sort_key := 'RSN';
193: end if;
194:
257: -- otherwise get it from profile
258: IF p_default_coverage_template_id is NOT NULL THEN
259: l_default_coverage_template_id := p_default_coverage_template_id;
260: ELSE
261: l_default_coverage_template_id := fnd_profile.value('CS_SR_DEFAULT_COVERAGE');
262: END IF;
263:
264: IF l_default_coverage_template_id is NOT NULL
265: THEN
402: l_log_module VARCHAR2(255) ;
403: l_contract_defaulted VARCHAR2(1);
404: l_msg_count NUMBER;
405: l_msg_data VARCHAR2(2000);
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
585: --12.1.2 siahmed changes for the
586: -- Provide option to start SLA calculations during default contract processing
587: --Bug 9905665 ,Profile name CS_SR_SLA_CALCULATE_DATE is incorrect.
588: -- The correct profile name is CS_SR_SLA_CAL_DATE
589: IF (fnd_profile.value('CS_SR_SLA_CAL_DATE') = 'CREATED_ON_DATE') THEN
590: l_request_date := p_sr_rec.creation_date;
591: ELSE
592: l_request_date := p_sr_rec.request_date;
593: END IF;
704: IF p_sr_rec.owner_id IS NULL AND
705: LOWER(p_auto_assign) = 'y' AND
706: NVL(p_sr_related_data.old_disallow_request_update,'N') = 'N'
707: THEN
708: l_auto_assign_level := fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
709: -- For bug 3702091 - AM API should not be called even if the Auto Assignment is ON
710: -- and the Assignment level is Group and Owner is passed
711: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR
712: (l_auto_assign_level = 'GROUP' AND p_sr_rec.owner_group_id is null))
1424: -- local variable for validate owner
1425: lx_owner_name VARCHAR2(240);
1426: lx_owner_id NUMBER;
1427: x_msg_index_out NUMBER;
1428: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
1429:
1430: -- Local variable to store the request_id, to be passed to IEU procedure.
1431: q_request_id NUMBER;
1432: l_note_status VARCHAR2(3);
1643:
1644: -- Initialize the value of the parameter from profile cs_sr_restrict_ib
1645: -- by shijain 4th dec 2002
1646:
1647: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');
1648:
1649: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1650: THEN
1651: FND_LOG.String
1812: *iii.If the profile Service: Default Operating Unit is set to an operating unit not available in the operating unit LOV at the service request header, leave the field blank so that user can select one from the LOV.
1813: *If the profile Service: Restrict Operating Unit by MOAC is set to No, then check the value in profile Service: Default Operating Unit.
1814: */
1815:
1816: --l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));
1817:
1818: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1819: if fnd_profile.value('DEFAULT_ORG_ID') is not null then
1820: l_org_id := to_number(fnd_profile.value('DEFAULT_ORG_ID'));
1814: */
1815:
1816: --l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));
1817:
1818: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1819: if fnd_profile.value('DEFAULT_ORG_ID') is not null then
1820: l_org_id := to_number(fnd_profile.value('DEFAULT_ORG_ID'));
1821: else
1822: l_org_id := to_number(fnd_profile.value('CS_SR_ORG_ID'));
1815:
1816: --l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));
1817:
1818: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1819: if fnd_profile.value('DEFAULT_ORG_ID') is not null then
1820: l_org_id := to_number(fnd_profile.value('DEFAULT_ORG_ID'));
1821: else
1822: l_org_id := to_number(fnd_profile.value('CS_SR_ORG_ID'));
1823: end if;
1816: --l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));
1817:
1818: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1819: if fnd_profile.value('DEFAULT_ORG_ID') is not null then
1820: l_org_id := to_number(fnd_profile.value('DEFAULT_ORG_ID'));
1821: else
1822: l_org_id := to_number(fnd_profile.value('CS_SR_ORG_ID'));
1823: end if;
1824: -- Fix for bug 10375745
1818: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1819: if fnd_profile.value('DEFAULT_ORG_ID') is not null then
1820: l_org_id := to_number(fnd_profile.value('DEFAULT_ORG_ID'));
1821: else
1822: l_org_id := to_number(fnd_profile.value('CS_SR_ORG_ID'));
1823: end if;
1824: -- Fix for bug 10375745
1825: -- Moving this logic below since mo_global.check_access has to be done in any case if the profile CS_SR_RESTRICT_OPERATING_UNIT is set to yes
1826: if l_org_id is not null then
1829: end if ;
1830: end if;
1831:
1832: Else -- CS_SR_RESTRICT_OPERATING_UNIT set to NO
1833: l_org_id := to_number(fnd_profile.value('CS_SR_ORG_ID'));
1834: End if;
1835:
1836: -- End of changes Charges Logistics 12.2
1837:
1844: END IF;
1845:
1846: ELSIF p_org_id is NOT NULL THEN -- p_org_id is NOT NULL
1847:
1848: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then
1849: --changed l_org_id to p_org_id for the bug 10317826
1850: if mo_global.check_access(p_org_id) ='Y' then
1851: l_org_id := p_org_id;
1852: else
2966: -- Call to Enqueuer API if it is in Maintenance Mode
2967: -- added b'coz l_req_num will always be null,when request_number is passed
2968: l_enqueue_number := NVL(l_request_number,l_req_num);
2969:
2970: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);
2971:
2972: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2973: THEN
2974: FND_LOG.String
4204:
4205: -- Initialize the value of the parameter from profile cs_sr_restrict_ib
4206: -- by shijain 4th dec 2002
4207:
4208: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');
4209:
4210: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4211: THEN
4212: FND_LOG.String
6107:
6108:
6109: ---- Call to Enqueue API if it is in maintenance Mode
6110:
6111: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);
6112:
6113: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
6114: THEN
6115: FND_LOG.String
6538: IF l_task_template_id <> -2 THEN
6539: l_task_template_group_rec.task_template_group_id := l_task_template_id;
6540: END IF;
6541:
6542: l_task_template_group_owner := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER');
6543: l_task_tmpl_group_owner_type := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE');
6544:
6545: l_task_owner_name := JTF_TASK_UTL.get_owner(l_task_tmpl_group_owner_type,l_task_template_group_owner);
6546:
6539: l_task_template_group_rec.task_template_group_id := l_task_template_id;
6540: END IF;
6541:
6542: l_task_template_group_owner := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER');
6543: l_task_tmpl_group_owner_type := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE');
6544:
6545: l_task_owner_name := JTF_TASK_UTL.get_owner(l_task_tmpl_group_owner_type,l_task_template_group_owner);
6546:
6547: IF l_task_owner_name IS NULL THEN
7783: l_sr_rec_for_task.platform_id := l_servicerequest_rec.platform_id;
7784: l_sr_rec_for_task.customer_site_id := l_servicerequest_rec.customer_site_id;
7785: l_sr_rec_for_task.sr_creation_channel := l_servicerequest_rec.sr_creation_channel;
7786:
7787: l_task_template_group_owner := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER');
7788: l_task_tmpl_group_owner_type := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE');
7789:
7790: l_task_owner_name := JTF_TASK_UTL.get_owner(l_task_tmpl_group_owner_type,l_task_template_group_owner);
7791:
7784: l_sr_rec_for_task.customer_site_id := l_servicerequest_rec.customer_site_id;
7785: l_sr_rec_for_task.sr_creation_channel := l_servicerequest_rec.sr_creation_channel;
7786:
7787: l_task_template_group_owner := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER');
7788: l_task_tmpl_group_owner_type := FND_PROFILE.value('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE');
7789:
7790: l_task_owner_name := JTF_TASK_UTL.get_owner(l_task_tmpl_group_owner_type,l_task_template_group_owner);
7791:
7792: IF l_task_owner_name IS NULL THEN
10283:
10284: IF (p_service_request_rec.publish_flag <> FND_API.G_MISS_CHAR) AND
10285: p_sr_mode <> 'CREATE' THEN
10286:
10287: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;
10288:
10289: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
10290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
11892: l_bill_to_site_id NUMBER;
11893: l_ship_to_site_id NUMBER;
11894: l_bill_to_site_use_id NUMBER;
11895: l_ship_to_site_use_id NUMBER;
11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
11897: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
11898: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;
12849: -- Added to fix issue in bug # 3288806.
12850: IF ((l_service_request_rec.category_id IS NOT NULL) AND (l_service_request_rec.category_id <> FND_API.G_MISS_NUM)) THEN
12851: l_service_request_val_rec.category_id := l_service_request_rec.category_id ;
12852: IF (l_service_request_rec.category_set_id = FND_API.G_MISS_NUM) THEN
12853: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
12854: END IF;
12855: l_service_request_val_rec.category_set_id := l_service_request_rec.category_set_id ;
12856: END IF ;
12857:
15567: l_ship_to_site_id NUMBER;
15568: l_bill_to_site_use_id NUMBER;
15569: l_ship_to_site_use_id NUMBER;
15570:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
15568: l_bill_to_site_use_id NUMBER;
15569: l_ship_to_site_use_id NUMBER;
15570:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
15576: l_territory_id number;
16550: --
16551: IF (l_service_request_rec.group_type = FND_API.G_MISS_CHAR AND
16552: l_old_servicerequest_rec.group_type is null AND
16553: l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM) THEN
16554: l_service_request_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');
16555: END IF;
16556: IF (l_service_request_rec.group_type = FND_API.G_MISS_CHAR) OR
16557: (nvl(l_service_request_rec.group_type,'-99') = nvl(l_old_ServiceRequest_rec.group_type,'-99')) THEN
16558: l_service_request_rec.group_type := l_old_ServiceRequest_rec.group_type;
17472: l_SR_Validation_rec.category_id := l_service_request_rec.category_id;
17473: IF (l_service_request_rec.category_id IS NOT NULL AND
17474: l_service_request_rec.category_set_id = FND_API.G_MISS_NUM AND
17475: l_old_servicerequest_rec.category_set_id IS NULL) THEN
17476: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
17477: END IF;
17478: END IF;
17479:
17480: IF (l_service_request_rec.category_set_id = FND_API.G_MISS_NUM) THEN
22546:
22547: --save point to be rolled back if one time address creation fails during location or site creation.
22548: SAVEPOINT create_onetime_address;
22549:
22550: IF (fnd_profile.value('CS_SR_VALIDATE_ONE_TIME_ADDRESS_AGAINST_TCA_GEOGRAPHY') = 'Y') THEN
22551: l_do_addr_val := 'Y';
22552: else
22553: l_do_addr_val := 'N';
22554: END IF;
22813: l_location_rec.postal_plus4_code := nvl(l_service_req_rec.incident_postal_plus4_code,FND_API.G_MISS_CHAR);
22814: l_location_rec.address_lines_phonetic := nvl(l_service_req_rec.incident_addr_lines_phonetic,FND_API.G_MISS_CHAR);
22815:
22816: SAVEPOINT UPDATE_LOCATION;
22817: IF (fnd_profile.value('CS_SR_VALIDATE_ONE_TIME_ADDRESS_AGAINST_TCA_GEOGRAPHY') = 'Y') THEN
22818: l_do_addr_val := 'Y';
22819: else
22820: l_do_addr_val := 'N';
22821: END IF;