DBA Data[Home] [Help]

APPS.AS_ACCESS_PVT dependencies on FND_MESSAGE

Line 35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

31: is NULL)
32: then
33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);
37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;

Line 36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);

32: then
33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);
37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;
40: return false;

Line 37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);

33: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
34: THEN
35: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
36: FND_MESSAGE.Set_Token('COLUMN', 'FREEZE_FLAG', FALSE);
37: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.freeze_flag, FALSE);
38: FND_MSG_PUB.ADD;
39: END IF;
40: return false;
41: end if;

Line 53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

49: is NULL)
50: then
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);
55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);
56: FND_MSG_PUB.ADD;
57: END IF;

Line 54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);

50: then
51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);
55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);
56: FND_MSG_PUB.ADD;
57: END IF;
58: return false;

Line 55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);

51: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
53: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
54: FND_MESSAGE.Set_Token('COLUMN', 'REASSIGN_FLAG', FALSE);
55: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.reassign_flag, FALSE);
56: FND_MSG_PUB.ADD;
57: END IF;
58: return false;
59: end if;

Line 71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

67: is NULL)
68: then
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
70: THEN
71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);
73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;

Line 72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);

68: then
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
70: THEN
71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);
73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: return false;

Line 73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);

69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
70: THEN
71: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
72: FND_MESSAGE.Set_Token('COLUMN', 'TEAM_LEADER_FLAG', FALSE);
73: FND_MESSAGE.Set_Token('VALUE', p_sales_team_rec.team_leader_flag, FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: return false;
77: end if;

Line 100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

96: if (get_person_id_csr%NOTFOUND)
97: then
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
99: THEN
100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;

Line 101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);

97: then
98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
99: THEN
100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;
105: raise FND_API.G_EXC_ERROR;

Line 102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);

98: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
99: THEN
100: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
101: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
102: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);
103: FND_MSG_PUB.ADD;
104: END IF;
105: raise FND_API.G_EXC_ERROR;
106: end if;

Line 1034: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');

1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1031: 'Private API: SALES_GROUP_ID is not valid');
1032: END IF;
1033: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1034: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1035: FND_MSG_PUB.ADD;
1036: ELSE
1037: AS_UTILITY_PVT.Set_Message(
1038: p_module => l_module,

Line 1058: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');

1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1055: 'Private API: SALES_GROUP_ID,SALESFORCE_ID is not valid');
1056: END IF;
1057: IF FND_PROFILE.value('ASF_BYPASS_GRP_VALIDATION') = 'Y' THEN
1058: FND_MESSAGE.Set_Name('AS', 'AS_UNSET_BYP_GRP_VALIDN_PROF');
1059: FND_MSG_PUB.ADD;
1060: ELSE
1061: AS_UTILITY_PVT.Set_Message(
1062: p_module => l_module,

Line 1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

1118: IF C_Sales_Lead_Id_Exists%NOTFOUND
1119: THEN
1120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1121: THEN
1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);
1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);
1125: FND_MSG_PUB.ADD;
1126: END IF;

Line 1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);

1119: THEN
1120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1121: THEN
1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);
1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);
1125: FND_MSG_PUB.ADD;
1126: END IF;
1127:

Line 1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);

1120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1121: THEN
1122: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1123: FND_MESSAGE.Set_Token('COLUMN', 'SALES_LEAD_ID', FALSE);
1124: FND_MESSAGE.Set_Token('VALUE', p_Sales_Lead_Id, FALSE);
1125: FND_MSG_PUB.ADD;
1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

1176: IF C_Lead_Id_Exists%NOTFOUND
1177: THEN
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);
1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;

Line 1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);

1177: THEN
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);
1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;
1185:

Line 1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);

1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1181: FND_MESSAGE.Set_Token('COLUMN', 'LEAD_ID', FALSE);
1182: FND_MESSAGE.Set_Token('VALUE', p_Lead_Id, FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;
1185:
1186: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

1224: IF (C_Party_Exists%NOTFOUND) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1227: THEN
1228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1229: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1230: FND_MSG_PUB.ADD;
1231: END IF;
1232: END IF;

Line 1229: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);

1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1227: THEN
1228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1229: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1230: FND_MSG_PUB.ADD;
1231: END IF;
1232: END IF;
1233: close C_Party_Exists;

Line 1295: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

1291:
1292: IF (C_Party_Site_Exists_Partner%NOTFOUND) THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1296: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_ADDRESS_ID', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: END IF;

Line 1296: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_ADDRESS_ID', FALSE);

1292: IF (C_Party_Site_Exists_Partner%NOTFOUND) THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
1296: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_ADDRESS_ID', FALSE);
1297: FND_MSG_PUB.ADD;
1298: END IF;
1299: END IF;
1300:

Line 1363: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1359: then
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1364: FND_MESSAGE.Set_Token('COLUMN', 'PERSON_ID', FALSE);
1365: FND_MSG_PUB.ADD;
1366: END IF;
1367: raise FND_API.G_EXC_ERROR;

Line 1364: FND_MESSAGE.Set_Token('COLUMN', 'PERSON_ID', FALSE);

1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1364: FND_MESSAGE.Set_Token('COLUMN', 'PERSON_ID', FALSE);
1365: FND_MSG_PUB.ADD;
1366: END IF;
1367: raise FND_API.G_EXC_ERROR;
1368: end if;

Line 1406: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1402: then
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1405: THEN
1406: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1407: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID, SALESFORCE_ID', FALSE);
1408: FND_MSG_PUB.ADD;
1409: END IF;
1410: raise FND_API.G_EXC_ERROR;

Line 1407: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID, SALESFORCE_ID', FALSE);

1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1405: THEN
1406: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1407: FND_MESSAGE.Set_Token('COLUMN', 'CUSTOMER_ID, SALESFORCE_ID', FALSE);
1408: FND_MSG_PUB.ADD;
1409: END IF;
1410: raise FND_API.G_EXC_ERROR;
1411: end if;

Line 1422: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1418: then
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1421: THEN
1422: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1423: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1424: FND_MSG_PUB.ADD;
1425: END IF;
1426: raise FND_API.G_EXC_ERROR;

Line 1423: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);

1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1421: THEN
1422: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1423: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1424: FND_MSG_PUB.ADD;
1425: END IF;
1426: raise FND_API.G_EXC_ERROR;
1427: end if;

Line 1439: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1435: then
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1438: THEN
1439: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1440: FND_MESSAGE.Set_Token('COLUMN', 'SALES_GROUP_ID', FALSE);
1441: FND_MSG_PUB.ADD;
1442: END IF;
1443: raise FND_API.G_EXC_ERROR;

Line 1440: FND_MESSAGE.Set_Token('COLUMN', 'SALES_GROUP_ID', FALSE);

1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1438: THEN
1439: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1440: FND_MESSAGE.Set_Token('COLUMN', 'SALES_GROUP_ID', FALSE);
1441: FND_MSG_PUB.ADD;
1442: END IF;
1443: raise FND_API.G_EXC_ERROR;
1444: end if;

Line 1456: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1452: then
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1457: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1458: FND_MSG_PUB.ADD;
1459: END IF;
1460: end if;

Line 1457: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);

1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1455: THEN
1456: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1457: FND_MESSAGE.Set_Token('COLUMN', 'PARTNER_CUSTOMER_ID', FALSE);
1458: FND_MSG_PUB.ADD;
1459: END IF;
1460: end if;
1461: close partner_exist_csr;

Line 1579: FND_MESSAGE.Set_Name('AS', 'API_INVALID_INFO');

1575: then
1576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1577: THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.Set_Name('AS', 'API_INVALID_INFO');
1580: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
1581: FND_MSG_PUB.ADD;
1582: END IF;
1583: end if;

Line 1580: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);

1576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1577: THEN
1578: x_return_status := fnd_api.g_ret_sts_error;
1579: FND_MESSAGE.Set_Name('AS', 'API_INVALID_INFO');
1580: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
1581: FND_MSG_PUB.ADD;
1582: END IF;
1583: end if;
1584:

Line 1612: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');

1608: if (get_dup_salesTeam_csr%FOUND)
1609: then
1610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1611: THEN
1612: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
1613: FND_MSG_PUB.ADD;
1614: END IF;
1615: return TRUE;
1616: else

Line 1733: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

1729: IF FND_GLOBAL.User_Id IS NULL
1730: THEN
1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1732: THEN
1733: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
1734: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;
1737: RAISE FND_API.G_EXC_ERROR;

Line 1734: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

1730: THEN
1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1732: THEN
1733: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
1734: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF;

Line 1814: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

1810: END IF;
1811:
1812: IF (l_update_access_flag <> 'Y') THEN
1813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1814: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1815: FND_MSG_PUB.ADD;
1816: END IF;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;

Line 1849: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

1845: END IF;
1846:
1847: IF (l_update_access_flag <> 'Y') THEN
1848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1849: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1850: FND_MSG_PUB.ADD;
1851: END IF;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;

Line 1883: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

1879: END IF;
1880:
1881: IF (l_update_access_flag <> 'Y') THEN
1882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1883: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1884: FND_MSG_PUB.ADD;
1885: END IF;
1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;

Line 1928: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1924: and l_sales_team_rec.reassign_reason is null
1925: then
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1929: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
1930: FND_MSG_PUB.ADD;
1931: END IF;
1932: raise fnd_api.g_exc_error;

Line 1929: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);

1925: then
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1929: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
1930: FND_MSG_PUB.ADD;
1931: END IF;
1932: raise fnd_api.g_exc_error;
1933: end if;

Line 1973: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');

1969: END IF;
1970:
1971: IF (l_update_access_flag <> 'Y') THEN
1972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1973: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
1974: FND_MSG_PUB.ADD;
1975: END IF;
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;

Line 2012: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');

2008: END IF;
2009:
2010: IF (l_update_access_flag <> 'Y') THEN
2011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2012: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2013: FND_MSG_PUB.ADD;
2014: END IF;
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;

Line 2037: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');

2033:
2034: then
2035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2036: THEN
2037: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
2038: FND_MSG_PUB.ADD;
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR;
2041: end if;

Line 2205: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');

2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202: open get_dup_access_id_csr(l_sales_team_rec);
2203: fetch get_dup_access_id_csr into x_access_id;
2204: close get_dup_access_id_csr;
2205: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
2206: FND_MSG_PUB.ADD;
2207:
2208: END IF;
2209:

Line 2318: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

2314: IF FND_GLOBAL.User_Id IS NULL
2315: THEN
2316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2317: THEN
2318: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2319: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2320: FND_MSG_PUB.ADD;
2321: END IF;
2322: RAISE FND_API.G_EXC_ERROR;

Line 2319: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

2315: THEN
2316: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2317: THEN
2318: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2319: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2320: FND_MSG_PUB.ADD;
2321: END IF;
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;

Line 2349: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

2345: if (p_sales_team_rec.access_id is NULL)
2346: then
2347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2348: THEN
2349: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2350: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2351: FND_MSG_PUB.ADD;
2352: END IF;
2353: end if;

Line 2350: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);

2346: then
2347: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2348: THEN
2349: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2350: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2351: FND_MSG_PUB.ADD;
2352: END IF;
2353: end if;
2354:

Line 2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

2358: if (get_access_info_csr%NOTFOUND)
2359: then
2360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);
2365: FND_MSG_PUB.ADD;
2366: END IF;

Line 2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);

2359: then
2360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);
2365: FND_MSG_PUB.ADD;
2366: END IF;
2367: close get_access_info_csr;

Line 2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);

2360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2363: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2364: fnd_message.set_token('VALUE', p_sales_team_rec.access_id, FALSE);
2365: FND_MSG_PUB.ADD;
2366: END IF;
2367: close get_access_info_csr;
2368: raise FND_API.G_EXC_ERROR;

Line 2400: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');

2396: END IF;
2397:
2398: IF (l_update_access_flag <> 'Y') THEN
2399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2400: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2401: FND_MSG_PUB.ADD;
2402: END IF;
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;

Line 2435: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');

2431: END IF;
2432:
2433: IF (l_update_access_flag <> 'Y') THEN
2434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2435: FND_MESSAGE.Set_Name('AS', 'API_NO_DELETE_PRIVILEGE');
2436: FND_MSG_PUB.ADD;
2437: END IF;
2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;

Line 2470: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

2466: END IF;
2467:
2468: IF (l_update_access_flag <> 'Y') THEN
2469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2470: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2471: FND_MSG_PUB.ADD;
2472: END IF;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;

Line 2510: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');

2506: END IF;
2507:
2508: IF (l_update_access_flag <> 'Y') THEN
2509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2510: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2511: FND_MSG_PUB.ADD;
2512: END IF;
2513: RAISE FND_API.G_EXC_ERROR;
2514: END IF;

Line 2549: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');

2545: END IF;
2546:
2547: IF (l_update_access_flag <> 'Y') THEN
2548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
2550: FND_MSG_PUB.ADD;
2551: END IF;
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;

Line 2709: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

2705: IF FND_GLOBAL.User_Id IS NULL
2706: THEN
2707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2708: THEN
2709: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2710: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2711: FND_MSG_PUB.ADD;
2712: END IF;
2713: RAISE FND_API.G_EXC_ERROR;

Line 2710: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

2706: THEN
2707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2708: THEN
2709: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
2710: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2711: FND_MSG_PUB.ADD;
2712: END IF;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;

Line 2742: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

2738: if (l_sales_team_rec.access_id is NULL)
2739: then
2740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2741: THEN
2742: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2743: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2744: FND_MSG_PUB.ADD;
2745: END IF;
2746: end if;

Line 2743: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);

2739: then
2740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2741: THEN
2742: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2743: FND_MESSAGE.Set_Token('COLUMN', 'ACCESS_ID', FALSE);
2744: FND_MSG_PUB.ADD;
2745: END IF;
2746: end if;
2747:

Line 2795: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

2791: END IF;
2792:
2793: IF (l_update_access_flag <> 'Y') THEN
2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2795: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2796: FND_MSG_PUB.ADD;
2797: END IF;
2798: RAISE FND_API.G_EXC_ERROR;
2799: END IF;

Line 2829: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

2825: END IF;
2826:
2827: IF (l_update_access_flag <> 'Y') THEN
2828: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2830: FND_MSG_PUB.ADD;
2831: END IF;
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;

Line 2863: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

2859: END IF;
2860:
2861: IF (l_update_access_flag <> 'Y') THEN
2862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2864: FND_MSG_PUB.ADD;
2865: END IF;
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;

Line 2913: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');

2909: END IF;
2910:
2911: IF (l_update_access_flag <> 'Y') THEN
2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('AS', 'API_NO_OPP_OWNER_PRIVILEGE');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;

Line 2933: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

2929: or l_sales_team_rec.last_update_date = FND_API.G_MISS_DATE)
2930: then
2931: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2934: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2935: FND_MSG_PUB.ADD;
2936: END IF;
2937: RAISE FND_API.G_EXC_ERROR;

Line 2934: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

2930: then
2931: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2934: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2935: FND_MSG_PUB.ADD;
2936: END IF;
2937: RAISE FND_API.G_EXC_ERROR;
2938: end if;

Line 2943: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');

2939: if (l_last_update_date <> l_sales_team_rec.last_update_date)
2940: then
2941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2942: THEN
2943: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2944: FND_MESSAGE.Set_Token('INFO', 'AS_ACCESSES', FALSE);
2945: FND_MSG_PUB.ADD;
2946: END IF;
2947: RAISE FND_API.G_EXC_ERROR;

Line 2944: FND_MESSAGE.Set_Token('INFO', 'AS_ACCESSES', FALSE);

2940: then
2941: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2942: THEN
2943: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
2944: FND_MESSAGE.Set_Token('INFO', 'AS_ACCESSES', FALSE);
2945: FND_MSG_PUB.ADD;
2946: END IF;
2947: RAISE FND_API.G_EXC_ERROR;
2948: end if;

Line 3012: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');

3008: END IF;
3009:
3010: IF (l_update_access_flag <> 'Y') THEN
3011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3012: FND_MESSAGE.Set_Name('AS', 'API_NO_OWNER_PRIVILEGE');
3013: FND_MSG_PUB.ADD;
3014: END IF;
3015: RAISE FND_API.G_EXC_ERROR;
3016: END IF;

Line 3041: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');

3037:
3038: then
3039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN
3041: FND_MESSAGE.Set_Name('AS','API_NO_ACC_MGR_PRIVILEGE');
3042: FND_MSG_PUB.ADD;
3043: END IF;
3044: RAISE FND_API.G_EXC_ERROR;
3045: end if;

Line 3054: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

3050: or l_sales_team_rec.reassign_reason = fnd_api.g_miss_char)
3051: then
3052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3055: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
3056: FND_MSG_PUB.ADD;
3057: END IF;
3058: raise fnd_api.g_exc_error;

Line 3055: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);

3051: then
3052: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3053: THEN
3054: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3055: FND_MESSAGE.Set_Token('COLUMN', 'reassign_reason', FALSE);
3056: FND_MSG_PUB.ADD;
3057: END IF;
3058: raise fnd_api.g_exc_error;
3059: end if;

Line 3181: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');

3177:
3178: WHEN DUP_VAL_ON_INDEX THEN
3179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3180: THEN
3181: FND_MESSAGE.Set_Name('AS', 'API_DUP_SALESTEAM');
3182: FND_MSG_PUB.ADD;
3183: x_return_status := FND_API.G_RET_STS_ERROR ;
3184: END IF;
3185:

Line 3193: FND_MESSAGE.Set_Name('AS', 'API_CANNOT_RESERVE_RECORD');

3189: x_return_status := FND_API.G_RET_STS_ERROR ;
3190:
3191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3192: THEN
3193: FND_MESSAGE.Set_Name('AS', 'API_CANNOT_RESERVE_RECORD');
3194: FND_MESSAGE.Set_Token('INFO', 'UPDATE_SALESTEAM', FALSE);
3195: FND_MSG_PUB.Add;
3196: END IF;
3197:

Line 3194: FND_MESSAGE.Set_Token('INFO', 'UPDATE_SALESTEAM', FALSE);

3190:
3191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3192: THEN
3193: FND_MESSAGE.Set_Name('AS', 'API_CANNOT_RESERVE_RECORD');
3194: FND_MESSAGE.Set_Token('INFO', 'UPDATE_SALESTEAM', FALSE);
3195: FND_MSG_PUB.Add;
3196: END IF;
3197:
3198: WHEN FND_API.G_EXC_ERROR THEN