DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OWNER dependencies on FND_MESSAGE

Line 60: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');

56: FETCH c_cm_exsist INTO l_cm_exsits;
57: -- Exit when the identifier uniqueness is established
58: IF c_cm_exsist%ROWCOUNT = 0 THEN
59: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
60: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');
61: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );
62: FND_MSG_PUB.add;
63: END IF;
64: CLOSE c_cm_exsist;

Line 61: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );

57: -- Exit when the identifier uniqueness is established
58: IF c_cm_exsist%ROWCOUNT = 0 THEN
59: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
60: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');
61: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );
62: FND_MSG_PUB.add;
63: END IF;
64: CLOSE c_cm_exsist;
65:

Line 76: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');

72: ) = FND_API.g_false
73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN
76: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');
77: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );
78: FND_MSG_PUB.add;
79: END IF;
80: */

Line 77: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );

73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN
76: FND_MESSAGE.set_name('PV', 'PV_BAD_CMM_RESOURCE_ID');
77: FND_MESSAGE.SET_TOKEN('ID', to_char(p_Lead_Owner_rec.CM_resource_id) );
78: FND_MSG_PUB.add;
79: END IF;
80: */
81: x_return_status := FND_API.g_ret_sts_error;

Line 110: FND_MESSAGE.set_name('PV', 'PV_NO_ENTITY');

106: ------------------------ entity --------------------------
107: IF p_Lead_Owner_rec.entity IS NULL THEN
108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
109: THEN
110: FND_MESSAGE.set_name('PV', 'PV_NO_ENTITY');
111: FND_MSG_PUB.add;
112: END IF;
113:
114: x_return_status := FND_API.g_ret_sts_error;

Line 120: FND_MESSAGE.set_name('PV', 'PV_NO_ATTR_ID');

116: ------------------------ attribute id -------------------------------
117: ELSIF p_Lead_Owner_rec.attribute_id IS NULL THEN
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
119: THEN
120: FND_MESSAGE.set_name('PV', 'PV_NO_ATTR_ID');
121: FND_MESSAGE.SET_TOKEN('ID',to_char(p_Lead_Owner_rec.attribute_id) );
122: FND_MSG_PUB.add;
123: END IF;
124:

Line 121: FND_MESSAGE.SET_TOKEN('ID',to_char(p_Lead_Owner_rec.attribute_id) );

117: ELSIF p_Lead_Owner_rec.attribute_id IS NULL THEN
118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
119: THEN
120: FND_MESSAGE.set_name('PV', 'PV_NO_ATTR_ID');
121: FND_MESSAGE.SET_TOKEN('ID',to_char(p_Lead_Owner_rec.attribute_id) );
122: FND_MSG_PUB.add;
123: END IF;
124:
125: x_return_status := FND_API.g_ret_sts_error;

Line 317: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');

313: FETCH c_Lead_Owner INTO l_Lead_Owner_rec;
314: IF c_Lead_Owner%NOTFOUND THEN
315: CLOSE c_Lead_Owner;
316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
317: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
318: FND_MSG_PUB.add;
319: END IF;
320: RAISE FND_API.g_exc_error;
321: END IF;

Line 619: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

615: END IF;
616:
617: IF (p_Lead_Owner_rec.country is null) THEN
618: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
619: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
620: FND_MSG_PUB.add;
621: END IF;
622: RAISE FND_API.g_exc_error;
623: END IF;

Line 785: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');

781:
782: IF (SQL%NOTFOUND) THEN
783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
784: THEN
785: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
786: FND_MSG_PUB.add;
787: END IF;
788: RAISE FND_API.g_exc_error;
789: END IF;

Line 902: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');

898: FETCH c_Lead_Owner INTO l_Lead_Owner_id;
899: IF (c_Lead_Owner%NOTFOUND) THEN
900: CLOSE c_Lead_Owner;
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
903: FND_MSG_PUB.add;
904: END IF;
905: RAISE FND_API.g_exc_error;
906: END IF;

Line 924: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');

920:
921: WHEN AS_Utility_PVT.resource_locked THEN
922: x_return_status := FND_API.g_ret_sts_error;
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
924: FND_MESSAGE.set_name('PV', 'PV_RESOURCE_LOCKED');
925: FND_MSG_PUB.add;
926: END IF;
927:
928: FND_MSG_PUB.count_and_get(

Line 1021: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

1017: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1018:
1019: IF (p_Lead_Owner_rec.country is null) THEN
1020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1021: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1022: FND_MSG_PUB.add;
1023: END IF;
1024: RAISE FND_API.g_exc_error;
1025: END IF;

Line 1084: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');

1080: AND object_version_number = l_Lead_Owner_rec.object_version_number;
1081:
1082: IF (SQL%NOTFOUND) THEN
1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1084: FND_MESSAGE.set_name('PV', 'PV_NO_RECORD_FOUND');
1085: FND_MSG_PUB.add;
1086: END IF;
1087: RAISE FND_API.g_exc_error;
1088: END IF;

Line 1223: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

1219: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1220:
1221: IF (p_sales_lead_id is null) THEN
1222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1223: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1224: FND_MSG_PUB.add;
1225: END IF;
1226: RAISE FND_API.g_exc_error;
1227: ELSE

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

1225: END IF;
1226: RAISE FND_API.g_exc_error;
1227: ELSE
1228: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1230: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);
1231: fnd_msg_pub.Add;
1232: END IF;
1233:

Line 1230: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);

1226: RAISE FND_API.g_exc_error;
1227: ELSE
1228: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1229: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1230: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);
1231: fnd_msg_pub.Add;
1232: END IF;
1233:
1234: END IF;

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

1238: fetch lc_lead_owners_postal into l_resource_id, l_owner_flag;
1239: exit when lc_lead_owners_postal%notfound;
1240:
1241: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1242: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1243: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1244: fnd_msg_pub.Add;
1245: END IF;
1246:

Line 1243: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);

1239: exit when lc_lead_owners_postal%notfound;
1240:
1241: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1242: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1243: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1244: fnd_msg_pub.Add;
1245: END IF;
1246:
1247: x_salesreps_tbl.extend;

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

1258: fetch lc_lead_owners_country into l_resource_id, l_owner_flag;
1259: exit when lc_lead_owners_country%notfound;
1260:
1261: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1262: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1263: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1264: fnd_msg_pub.Add;
1265: END IF;
1266:

Line 1263: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);

1259: exit when lc_lead_owners_country%notfound;
1260:
1261: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1262: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1263: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1264: fnd_msg_pub.Add;
1265: END IF;
1266:
1267: x_salesreps_tbl.extend;

Line 1409: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');

1405: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
1406:
1407: IF (p_sales_lead_id is null) THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('PV', 'PV_NO_COUNTRY_FOUND');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: RAISE FND_API.g_exc_error;
1413: ELSE

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

1411: END IF;
1412: RAISE FND_API.g_exc_error;
1413: ELSE
1414: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1415: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1416: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);
1417: fnd_msg_pub.Add;
1418: END IF;
1419:

Line 1416: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);

1412: RAISE FND_API.g_exc_error;
1413: ELSE
1414: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1415: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1416: fnd_message.Set_Token('TEXT', 'Sales lead id : ' || p_sales_lead_id);
1417: fnd_msg_pub.Add;
1418: END IF;
1419:
1420: END IF;

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

1424: fetch lc_lead_owners_postal into l_resource_id, l_owner_flag;
1425: exit when lc_lead_owners_postal%notfound;
1426:
1427: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1428: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1429: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1430: fnd_msg_pub.Add;
1431: END IF;
1432:

Line 1429: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);

1425: exit when lc_lead_owners_postal%notfound;
1426:
1427: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1428: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1429: fnd_message.Set_Token('TEXT', 'Postal : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1430: fnd_msg_pub.Add;
1431: END IF;
1432:
1433: l_salesreps_tbl.extend;

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

1444: fetch lc_lead_owners_country into l_resource_id, l_owner_flag;
1445: exit when lc_lead_owners_country%notfound;
1446:
1447: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1448: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1449: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1450: fnd_msg_pub.Add;
1451: END IF;
1452:

Line 1449: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);

1445: exit when lc_lead_owners_country%notfound;
1446:
1447: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1448: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1449: fnd_message.Set_Token('TEXT', 'Country : salesforce_id : ' || l_resource_id || ' owner : ' || l_owner_flag);
1450: fnd_msg_pub.Add;
1451: END IF;
1452:
1453: l_salesreps_tbl.extend;