[Home] [Help]
308: l_party_name := NULL;
309: END IF;
310: CLOSE c_cust_det;
311:
312: IF (NVL(FND_PROFILE.VALUE('CS_SR_TASK_OWNER_AUTO_ASSIGN_LEVEL'),'INDIVIDUAL') = 'INDIVIDUAL') THEN
313: Assign_Owner
314: ( p_init_msg_list => p_init_msg_list,
315: p_commit => p_commit,
316: p_incident_id => p_incident_id,
327: x_msg_data => x_msg_data
328: );
329: END IF; -- Profile value is INDIVIDUAL
330: IF (l_owner_id IS NULL OR
331: FND_PROFILE.VALUE('CS_SR_TASK_OWNER_AUTO_ASSIGN_LEVEL') = 'GROUP') THEN
332: -- Call the Assign Group Procedure to return the Group and Group Type
333: Assign_Group
334: ( p_init_msg_list => p_init_msg_list,
335: p_commit => p_commit,
469:
470: -- Proceed even if the group_type is null
471: l_incident_id := p_incident_id;
472:
473: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_TASK_AUTO_ASSIGN') = 'YES') THEN
474: SELECT business_process_id INTO l_business_process_id
475: FROM cs_incident_types
476: WHERE incident_type_id = p_service_request_rec.type_id;
477: END IF;
571: -- If customer product id is not null, then set ib_preferred_resource_flag
572: -- to 'Y'.If contract line id is not null, then set
573: -- contract_preferred_resource flag to 'Y'.
574: IF (l_contract_service_id IS NOT NULL) THEN
575: IF (FND_PROFILE.VALUE('CS_TASK_CONTRACT_OWNER')= 'Y') THEN --Added By Nic
576: l_contract_res_flag := 'Y';
577: ELSE
578: l_contract_res_flag := 'N';
579: END IF;
578: l_contract_res_flag := 'N';
579: END IF;
580: END IF;
581: IF (l_cust_prod_id IS NOT NULL) THEN
582: IF (FND_PROFILE.VALUE('CS_TASK_IB_OWNER')= 'Y') THEN --Added By Nic
583: l_ib_res_flag := 'Y';
584: ELSE
585: l_ib_res_flag := 'N';
586: END IF;
584: ELSE
585: l_ib_res_flag := 'N';
586: END IF;
587: END IF;
588: IF (FND_PROFILE.VALUE('CS_TASK_TERRITORY_OWNER')= 'Y') THEN --Added By Nic
589: l_territory_flag :='Y';
590: ELSE
591: l_territory_flag :='N';
592: END IF;
590: ELSE
591: l_territory_flag :='N';
592: END IF;
593:
594: FND_PROFILE.Get('CS_SR_TSK_CHK_RES_CAL_AVL', l_cs_sr_tsk_chk_res_cal_avl); --gasankar Calendar check feature added
595:
596: If nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') <> 'N' Then
597: l_start_date := sysdate ;
598: l_end_date := sysdate ;
734: -- Proceed even if the group_id is null
735: -- l_group_id := p_group_id ;
736:
737: --
738: IF (FND_PROFILE.VALUE('CS_SR_USE_BUS_PROC_TASK_AUTO_ASSIGN') = 'YES') THEN
739: SELECT business_process_id INTO l_business_process_id
740: FROM cs_incident_types
741: WHERE incident_type_id = p_service_request_rec.type_id;
742: END IF;
841: -- If customer product id is not null, then set ib_preferred_resource_flag
842: -- to 'Y'.If contract line id is not null, then set
843: -- contract_preferred_resource flag to 'Y'.
844: IF (l_contract_service_id IS NOT NULL) THEN
845: IF (FND_PROFILE.VALUE('CS_TASK_CONTRACT_OWNER')= 'Y') THEN --Added By Nic
846: l_contract_res_flag := 'Y';
847: ELSE
848: l_contract_res_flag := 'N';
849: END IF;
848: l_contract_res_flag := 'N';
849: END IF;
850: END IF;
851: IF (l_cust_prod_id IS NOT NULL) THEN
852: IF (FND_PROFILE.VALUE('CS_TASK_IB_OWNER')= 'Y') THEN --Added By Nic
853: l_ib_res_flag := 'Y';
854: ELSE
855: l_ib_res_flag := 'N';
856: END IF;
854: ELSE
855: l_ib_res_flag := 'N';
856: END IF;
857: END IF;
858: IF (FND_PROFILE.VALUE('CS_TASK_TERRITORY_OWNER')= 'Y') THEN --Added By Nic
859: l_territory_flag :='Y';
860: ELSE
861: l_territory_flag :='N';
862: END IF;
860: ELSE
861: l_territory_flag :='N';
862: END IF;
863:
864: FND_PROFILE.Get('CS_SR_TSK_CHK_RES_CAL_AVL', l_cs_sr_tsk_chk_res_cal_avl); --gasankar Calendar check feature added
865:
866: If nvl(l_cs_sr_tsk_chk_res_cal_avl, 'N') <> 'N' Then
867: l_start_date := sysdate ;
868: l_end_date := sysdate ;