DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on FND_MESSAGE

Line 29: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');

25: PRAGMA EXCEPTION_INIT(g_e_buffer_too_small, -6502);
26:
27: PROCEDURE debug(p_msg_string IN VARCHAR2) IS
28: BEGIN
29: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
30: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
31: FND_MSG_PUB.Add;
32: END debug;
33:

Line 30: FND_MESSAGE.Set_Token('TEXT', p_msg_string);

26:
27: PROCEDURE debug(p_msg_string IN VARCHAR2) IS
28: BEGIN
29: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
30: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
31: FND_MSG_PUB.Add;
32: END debug;
33:
34:

Line 2213: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2209:
2210: BEGIN
2211:
2212: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2213: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2214: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2215: fnd_msg_pub.Add;
2216: END IF;
2217:

Line 2214: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

2210: BEGIN
2211:
2212: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2213: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2214: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2215: fnd_msg_pub.Add;
2216: END IF;
2217:
2218: -- Standard call to check for call compatibility.

Line 2269: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2265: OPEN lc_get_incumbent_pt (p_lead_id);
2266: FETCH lc_get_incumbent_pt INTO l_incumbent_pt_party_id;
2267: IF l_incumbent_pt_party_id IS NULL THEN
2268: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2269: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2270: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');
2271: fnd_msg_pub.Add;
2272: END IF;
2273: l_incumbent_pt_party_id := 0;

Line 2270: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');

2266: FETCH lc_get_incumbent_pt INTO l_incumbent_pt_party_id;
2267: IF l_incumbent_pt_party_id IS NULL THEN
2268: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2269: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2270: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');
2271: fnd_msg_pub.Add;
2272: END IF;
2273: l_incumbent_pt_party_id := 0;
2274: END IF;

Line 2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2284: debug('Value of index '||j);
2285: END IF;
2286:
2287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2289: fnd_message.Set_Token('TEXT', 'Checking if preferred Partner: ' || l_incumbent_pt_party_id );
2290: fnd_msg_pub.Add;
2291: END IF;
2292:

Line 2289: fnd_message.Set_Token('TEXT', 'Checking if preferred Partner: ' || l_incumbent_pt_party_id );

2285: END IF;
2286:
2287: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2288: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2289: fnd_message.Set_Token('TEXT', 'Checking if preferred Partner: ' || l_incumbent_pt_party_id );
2290: fnd_msg_pub.Add;
2291: END IF;
2292:
2293: IF l_partner_id_tbl(j) = l_incumbent_pt_party_id THEN

Line 2313: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2309: -- All these attributes have the same SQL_TEXT for the Partner entity
2310: -- So we are using it to query diff attr values and popluating it into
2311: -- the temp table.
2312: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2313: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2314: fnd_message.Set_Token('TEXT', 'Getting Personalized columns for : ' || l_partner_id_tbl(j));
2315: fnd_msg_pub.Add;
2316: END IF;
2317:

Line 2314: fnd_message.Set_Token('TEXT', 'Getting Personalized columns for : ' || l_partner_id_tbl(j));

2310: -- So we are using it to query diff attr values and popluating it into
2311: -- the temp table.
2312: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2313: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2314: fnd_message.Set_Token('TEXT', 'Getting Personalized columns for : ' || l_partner_id_tbl(j));
2315: fnd_msg_pub.Add;
2316: END IF;
2317:
2318: l_industry_table(j) := get_attribute_value(5, l_partner_id_tbl(j));

Line 2324: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2320: l_geography_table(j) := get_attribute_value(8, l_partner_id_tbl(j));
2321: l_capacityrating_table(j) := get_attribute_value(18, l_partner_id_tbl(j));
2322:
2323: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2324: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2325: fnd_message.Set_Token('TEXT', 'Values for Attrs :5 ' ||l_industry_table(j)||
2326: 'Values for Attrs :6 ' ||l_membertype_table(j)||
2327: 'Values for Attrs :8 ' || l_geography_table(j)||
2328: 'Values for Attrs :18 ' || l_capacityrating_table(j) );

Line 2325: fnd_message.Set_Token('TEXT', 'Values for Attrs :5 ' ||l_industry_table(j)||

2321: l_capacityrating_table(j) := get_attribute_value(18, l_partner_id_tbl(j));
2322:
2323: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2324: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2325: fnd_message.Set_Token('TEXT', 'Values for Attrs :5 ' ||l_industry_table(j)||
2326: 'Values for Attrs :6 ' ||l_membertype_table(j)||
2327: 'Values for Attrs :8 ' || l_geography_table(j)||
2328: 'Values for Attrs :18 ' || l_capacityrating_table(j) );
2329: fnd_msg_pub.Add;

Line 2334: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

2330: END IF;
2331:
2332:
2333: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2334: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2335: fnd_message.Set_Token('TEXT', 'Looking for recycled flag for Partner Id : ' || l_partner_id_tbl(j));
2336: fnd_msg_pub.Add;
2337: END IF;
2338:

Line 2335: fnd_message.Set_Token('TEXT', 'Looking for recycled flag for Partner Id : ' || l_partner_id_tbl(j));

2331:
2332:
2333: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2334: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2335: fnd_message.Set_Token('TEXT', 'Looking for recycled flag for Partner Id : ' || l_partner_id_tbl(j));
2336: fnd_msg_pub.Add;
2337: END IF;
2338:
2339: -- Check if this lead has been recycled by this partner before.

Line 2899: FND_MESSAGE.Set_Name('PV', p_msg_name);

2895: )
2896: IS
2897: BEGIN
2898: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
2899: FND_MESSAGE.Set_Name('PV', p_msg_name);
2900: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
2901:
2902: IF (p_token2 IS NOT NULL) THEN
2903: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 2900: FND_MESSAGE.Set_Token(p_token1, p_token1_value);

2896: IS
2897: BEGIN
2898: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
2899: FND_MESSAGE.Set_Name('PV', p_msg_name);
2900: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
2901:
2902: IF (p_token2 IS NOT NULL) THEN
2903: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
2904: END IF;

Line 2903: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

2899: FND_MESSAGE.Set_Name('PV', p_msg_name);
2900: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
2901:
2902: IF (p_token2 IS NOT NULL) THEN
2903: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
2904: END IF;
2905:
2906: IF (p_token3 IS NOT NULL) THEN
2907: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

Line 2907: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

2903: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
2904: END IF;
2905:
2906: IF (p_token3 IS NOT NULL) THEN
2907: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
2908: END IF;
2909:
2910: FND_MSG_PUB.Add;
2911: END IF;