APPS.PRP_IH_EMAIL_PVT dependencies on FND_MSG_PUB

Line 108: FND_MSG_PUB.initialize;

104: END IF;
105:
106: -- Initialize message list if p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean(p_init_msg_list) THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: -- Log Debug Messages.
112: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

362: COMMIT WORK;
363: END IF;
364:
365: -- Standard call to get message count and if count is 1, get message info.
366: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
367: p_data => x_msg_data,
368: p_encoded => 'F');
369:
370: EXCEPTION

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

371:
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO CREATE_EMAIL_IH_PVT;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
376: p_data => x_msg_data,
377: p_encoded => 'F');
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO CREATE_EMAIL_IH_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
383: p_data => x_msg_data,
384: p_encoded => 'F');
385:
386: WHEN OTHERS THEN

Line 392: FND_MSG_PUB.Add;

388: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
389: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
390: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
391: FND_MESSAGE.Set_Token('REASON', SQLERRM);
392: FND_MSG_PUB.Add;
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

392: FND_MSG_PUB.Add;
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
399: END IF;
400:

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

394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
399: END IF;
400:
401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
402: p_data => x_msg_data,

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

397: THEN
398: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
399: END IF;
400:
401: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
402: p_data => x_msg_data,
403: p_encoded => 'F');
404:
405: END Create_Email_IH;