DBA Data[Home] [Help]

APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on FND_MESSAGE

Line 368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');

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;

Line 369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);

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;

Line 370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);

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:

Line 380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');

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;

Line 381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);

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:

Line 382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);

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;

Line 443: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_RULE');

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:

Line 444: FND_MESSAGE.Set_Token('LEAD_NAME', l_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:
448: result := 'COMPLETE';

Line 461: FND_MESSAGE.Set_Name('PV', 'PV_OPP_NOT_MATCH_PARTNER');

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;

Line 462: FND_MESSAGE.Set_Token('LEAD_NAME', l_lead_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;
466:

Line 463: FND_MESSAGE.Set_Token('RULE_NAME', l_process_rule_name);

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';

Line 971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');

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;

Line 972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);

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;

Line 973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);

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:

Line 983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');

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;

Line 984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);

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:

Line 985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);

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;