364: IF (x.opp_open_status_flag <> 'Y') THEN
365: l_open_opportunity_flag := FALSE;
366:
367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
371: fnd_msg_pub.ADD;
372: END LOOP;
365: l_open_opportunity_flag := FALSE;
366:
367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
371: fnd_msg_pub.ADD;
372: END LOOP;
373: END IF;
366:
367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
371: fnd_msg_pub.ADD;
372: END LOOP;
373: END IF;
374:
376: -- This opportunity has already been routed.
377: -- -----------------------------------------------------------------------
378: IF (x.lead_id IS NOT NULL) THEN
379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
383: fnd_msg_pub.ADD;
384: END LOOP;
377: -- -----------------------------------------------------------------------
378: IF (x.lead_id IS NOT NULL) THEN
379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
383: fnd_msg_pub.ADD;
384: END LOOP;
385:
378: IF (x.lead_id IS NOT NULL) THEN
379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
383: fnd_msg_pub.ADD;
384: END LOOP;
385:
386: l_routing_exist_flag := TRUE;
439: CLOSE c_get_lead_name;
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
442: THEN
443: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_RULE');
444: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
445: FND_MSG_PUB.Add;
446: END IF;
447:
440:
441: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
442: THEN
443: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_RULE');
444: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
445: FND_MSG_PUB.Add;
446: END IF;
447:
448: result := 'COMPLETE';
457: CLOSE c_get_lead_rule_name;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');
462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);
464: FND_MSG_PUB.Add;
465: END IF;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');
462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);
464: FND_MSG_PUB.Add;
465: END IF;
466:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');
462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_name);
463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);
464: FND_MSG_PUB.Add;
465: END IF;
466:
467: result := 'COMPLETE';
967: IF (x.opp_open_status_flag <> 'Y') THEN
968: l_open_opportunity_flag := FALSE;
969:
970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
974: fnd_msg_pub.ADD;
975: END LOOP;
968: l_open_opportunity_flag := FALSE;
969:
970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
974: fnd_msg_pub.ADD;
975: END LOOP;
976: END IF;
969:
970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
974: fnd_msg_pub.ADD;
975: END LOOP;
976: END IF;
977:
979: -- This opportunity has already been routed.
980: -- -----------------------------------------------------------------------
981: IF (x.lead_id IS NOT NULL AND x.routing_status IN ('ACTIVE','MATCHED','OFFERED')) THEN
982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
986: fnd_msg_pub.ADD;
987: END LOOP;
980: -- -----------------------------------------------------------------------
981: IF (x.lead_id IS NOT NULL AND x.routing_status IN ('ACTIVE','MATCHED','OFFERED')) THEN
982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
986: fnd_msg_pub.ADD;
987: END LOOP;
988:
981: IF (x.lead_id IS NOT NULL AND x.routing_status IN ('ACTIVE','MATCHED','OFFERED')) THEN
982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
986: fnd_msg_pub.ADD;
987: END LOOP;
988:
989: l_routing_exist_flag := TRUE;