146: and p_incident_severity5_id IS NULL));
147:
148:
149: BEGIN
150: -- l_load_balance_forms := fnd_profile.value('CS_LOAD_BALANCING_REQD_FORMS');
151: -- l_load_balance_html := fnd_profile.value('CS_LOAD_BALANCING_REQD_HTML');
152: OPEN cs_incident_id_csr ;
153: LOOP
154: FETCH cs_incident_id_csr INTO l_sr_number,l_incident_id,
147:
148:
149: BEGIN
150: -- l_load_balance_forms := fnd_profile.value('CS_LOAD_BALANCING_REQD_FORMS');
151: -- l_load_balance_html := fnd_profile.value('CS_LOAD_BALANCING_REQD_HTML');
152: OPEN cs_incident_id_csr ;
153: LOOP
154: FETCH cs_incident_id_csr INTO l_sr_number,l_incident_id,
155: l_object_version_number,l_type_id,l_severity_id,l_inv_item_id,
364: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: -- if default_group_type profile is null, set default to RS_GROUP for API always
367: IF (l_sr_rec.group_type IS NULL) THEN
368: FND_PROFILE.Get('CS_SR_DEFAULT_GROUP_TYPE', l_default_group_type);
369: IF (l_default_group_type IS NULL) THEN
370: l_default_group_type := 'RS_GROUP';
371: END IF;
372: ELSE
402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data
404: );
405: IF (l_grp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
406: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
407: x_owner_group_id := l_group_id;
408: IF (l_group_id IS NOT NULL) THEN
409: l_update_grp_flag := 'Y';
410: END IF;
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503: l_own_return_status := FND_API.G_RET_STS_SUCCESS;
504: l_group_id := p_service_request_rec.owner_group_id ;
505:
506: IF (FND_PROFILE.VALUE('CS_SR_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
507: x_owner_group_id := l_group_id;
508: RETURN;
509: ELSE
510: CS_ASSIGN_RESOURCE_CON_PKG.Assign_Owner
730: -- group type must have a value - default is RS_GROUP, passed by caller
731: IF (l_incident_id IS NOT NULL) AND (p_group_type IS NOT NULL) THEN
732: l_resource_type := p_group_type;
733:
734: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
735: SELECT business_process_id INTO l_business_process_id
736: FROM cs_incident_types
737: WHERE incident_type_id = l_sr_rec.type_id;
738: END IF;
878: -- If customer product id is not null, then set ib_preferred_resource_flag
879: -- to 'Y'.If contract line id is not null, then set
880: -- contract_preferred_resource flag to 'Y'.
881: IF (l_contract_service_id IS NOT NULL) THEN
882: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_GROUP')= 'Y') THEN --Added By Nic
883: l_contract_res_flag := 'Y';
884: ELSE
885: l_contract_res_flag := 'N';
886: END IF;
889: l_ib_resource_flag := 'Y';
890: ELSE
891: l_ib_resource_flag := 'N';
892: END IF;
893: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_GROUP') = 'Y') THEN -- Added by nic
894: l_territory_flag :='Y';
895: ELSE
896: L_TERRITORY_FLAG :='N';
897: END IF;
897: END IF;
898:
899:
900:
901: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added
902: If nvl(l_cs_sr_chk_res_cal_avl, 'N') <> 'N' Then
903: l_start_date := sysdate ;
904: l_end_date := sysdate ;
905: End If ;
1109: -- if incident_id is not null proceed, otherwise exit API
1110: IF ((l_incident_id IS NOT NULL) AND (p_group_id IS NOT NULL )) THEN
1111: l_group_id := p_group_id ;
1112:
1113: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_AUTO_ASSIGN') = 'YES') THEN
1114: SELECT business_process_id INTO l_business_process_id
1115: FROM cs_incident_types
1116: WHERE incident_type_id = l_sr_rec.type_id;
1117: END IF;
1243: -- If customer product id is not null, then set ib_preferred_resource_flag
1244: -- to 'Y'.If contract line id is not null, then set
1245: -- contract_preferred_resource flag to 'Y'.
1246: IF (l_contract_service_id IS NOT NULL) THEN
1247: IF (FND_PROFILE.VALUE('CS_SR_CONTRACT_INDIVIDUAL')= 'Y') THEN --Added By Nic
1248: l_contract_res_flag := 'Y';
1249: ELSE
1250: l_contract_res_flag := 'N';
1251: END IF;
1250: l_contract_res_flag := 'N';
1251: END IF;
1252: END IF;
1253: IF (L_CUST_PROD_ID IS NOT NULL) THEN
1254: IF (FND_PROFILE.VALUE ('CS_SR_IB_INDIVIDUAL') ='Y' ) THEN -- Added by Nic
1255: l_ib_resource_flag := 'Y';
1256: ELSE
1257: l_ib_resource_flag := 'N';
1258: END IF;
1256: ELSE
1257: l_ib_resource_flag := 'N';
1258: END IF;
1259: END IF;
1260: IF (FND_PROFILE.VALUE('CS_SR_TERRITORY_INDIVIDUAL') = 'Y') THEN -- Added by nic
1261: l_territory_flag :='Y';
1262: ELSE
1263: l_territory_flag :='N';
1264: END IF;
1262: ELSE
1263: l_territory_flag :='N';
1264: END IF;
1265:
1266: FND_PROFILE.Get('CS_SR_CHK_RES_CAL_AVL', l_cs_sr_chk_res_cal_avl); --gasankar Calendar check feature added
1267:
1268: If nvl(l_cs_sr_chk_res_cal_avl, 'N') <> 'N' Then
1269: l_start_date := sysdate ;
1270: l_end_date := sysdate ;