DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PUB dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.Initialize;

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

Line 131: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

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

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

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

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

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

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

Line 248: FND_MSG_PUB.Initialize;

244: -- Standard start of API savepoint
245: SAVEPOINT Process_Planned_Materials;
246: -- Initialize message list if p_init_msg_list is set to TRUE
247: IF FND_API.To_Boolean( p_init_msg_list) THEN
248: FND_MSG_PUB.Initialize;
249: END IF;
250: -- Initialize API return status to success
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: --

Line 300: l_msg_count := FND_MSG_PUB.count_msg;

296: );
297: END IF;
298: -- Check Error Message stack.
299: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
300: l_msg_count := FND_MSG_PUB.count_msg;
301: IF l_msg_count > 0 THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: END IF;

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

319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: ROLLBACK TO Process_Planned_Materials;
323: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
324: p_data => x_msg_data,
325: p_encoded => fnd_api.g_false);
326:
327:

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

327:
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: ROLLBACK TO Process_Planned_Materials;
331: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
332: p_data => x_msg_data,
333: p_encoded => fnd_api.g_false);
334:
335:

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

335:
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: ROLLBACK TO Process_Planned_Materials;
339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
340: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
341: p_procedure_name => 'Process_Planned_Materials',
342: p_error_text => SUBSTR(SQLERRM,1,500));
343: END IF;

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

336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: ROLLBACK TO Process_Planned_Materials;
339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
340: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
341: p_procedure_name => 'Process_Planned_Materials',
342: p_error_text => SUBSTR(SQLERRM,1,500));
343: END IF;
344: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

340: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
341: p_procedure_name => 'Process_Planned_Materials',
342: p_error_text => SUBSTR(SQLERRM,1,500));
343: END IF;
344: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
345: p_data => x_msg_data,
346: p_encoded => fnd_api.g_false);
347: END Process_Planned_Materials;
348: