APPS.AHL_LTP_REQST_MATRL_PUB dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.Initialize;

78: -- Standard start of API savepoint
79: SAVEPOINT Update_Planned_Materials;
80: -- Initialize message list if p_init_msg_list is set to TRUE
81: IF FND_API.To_Boolean( p_init_msg_list) THEN
82: FND_MSG_PUB.Initialize;
83: END IF;
84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --

Line 130: l_msg_count := FND_MSG_PUB.count_msg;

126: );
127: END IF;
128: -- Check Error Message stack.
129: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
130: l_msg_count := FND_MSG_PUB.count_msg;
131: IF l_msg_count > 0 THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134: END IF;

Line 153: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: ROLLBACK TO Update_Planned_Materials;
153: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
154: p_data => x_msg_data,
155: p_encoded => fnd_api.g_false);
156:
157:

Line 161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

157:
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: ROLLBACK TO Update_Planned_Materials;
161: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => fnd_api.g_false);
164:
165:

Line 169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

165:
166: WHEN OTHERS THEN
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: ROLLBACK TO Update_Planned_Materials;
169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
171: p_procedure_name => 'Update_Planned_Materials',
172: p_error_text => SUBSTR(SQLERRM,1,500));
173: END IF;

Line 170: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

166: WHEN OTHERS THEN
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: ROLLBACK TO Update_Planned_Materials;
169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
171: p_procedure_name => 'Update_Planned_Materials',
172: p_error_text => SUBSTR(SQLERRM,1,500));
173: END IF;
174: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 174: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

170: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
171: p_procedure_name => 'Update_Planned_Materials',
172: p_error_text => SUBSTR(SQLERRM,1,500));
173: END IF;
174: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
175: p_data => x_msg_data,
176: p_encoded => fnd_api.g_false);
177:
178: END Update_Planned_Materials;