DBA Data[Home] [Help]

APPS.IGP_VW_PORT_ACTIVITIES_PKG dependencies on FND_MSG_PUB

Line 167: FND_MSG_PUB.initialize;

163:
164: SAVEPOINT Insert_comments_Main;
165:
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167: FND_MSG_PUB.initialize;
168:
169: IF x_pincode IS NULL THEN
170: OPEN c_org_party_id(x_party_id,x_portfolio_id);
171: FETCH c_org_party_id INTO l_org_party_id;

Line 231: FND_MSG_PUB.Count_And_Get

227: x_mode => x_mode
228: );
229: END IF;
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: (
233: p_count => x_msg_count ,
234: p_data => x_msg_data
235: );

Line 241: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

237: EXCEPTION
238: WHEN apps_exception THEN
239: ROLLBACK TO Insert_comments_Main;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
242: p_data => x_msg_data );
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO Insert_comments_Main;
245: x_return_status := FND_API.G_RET_STS_ERROR;

Line 246: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

242: p_data => x_msg_data );
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO Insert_comments_Main;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
247: p_data => x_msg_data );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: ROLLBACK TO Insert_comments_Main;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 251: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

247: p_data => x_msg_data );
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: ROLLBACK TO Insert_comments_Main;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
252: p_data => x_msg_data );
253: WHEN OTHERS THEN
254: ROLLBACK TO Insert_comments_Main;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 256: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

252: p_data => x_msg_data );
253: WHEN OTHERS THEN
254: ROLLBACK TO Insert_comments_Main;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
258: END IF;
259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
260: p_data => x_msg_data );

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

253: WHEN OTHERS THEN
254: ROLLBACK TO Insert_comments_Main;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
258: END IF;
259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
260: p_data => x_msg_data );
261:

Line 259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
258: END IF;
259: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: END Insert_Row_Pub;
263: