APPS.AMS_THRESHOLD_NOTIFY dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.Add;

45: FETCH c_resource INTO l_person_id ;
46: IF c_resource%NOTFOUND THEN
47: x_return_status := FND_API.G_RET_STS_ERROR;
48: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
49: FND_MSG_PUB.Add;
50: END IF;
51: CLOSE c_resource ;
52:
53: -- Pass the Employee ID to get the Role

Line 62: FND_MSG_PUB.Add;

58:
59: IF x_role_name is NULL THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
62: FND_MSG_PUB.Add;
63: END IF;
64: END Get_User_Role;
65:
66:

Line 178: FND_MSG_PUB.Count_And_Get (

174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: -- Standard call to get message count and if count=1, get the message
178: FND_MSG_PUB.Count_And_Get (
179: p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );

Line 187: FND_MSG_PUB.Count_And_Get (

183:
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );

Line 195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

191: );
192:
193: WHEN OTHERS THEN
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
198: END IF;
199: -- Standard call to get message count and if count=1, get the message

Line 197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

193: WHEN OTHERS THEN
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
196: THEN
197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
198: END IF;
199: -- Standard call to get message count and if count=1, get the message
200: FND_MSG_PUB.Count_And_Get (
201: p_encoded => FND_API.G_FALSE,

Line 200: FND_MSG_PUB.Count_And_Get (

196: THEN
197: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
198: END IF;
199: -- Standard call to get message count and if count=1, get the message
200: FND_MSG_PUB.Count_And_Get (
201: p_encoded => FND_API.G_FALSE,
202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );