DBA Data[Home] [Help]

APPS.AHL_PRD_MATERIAL_TXN_PUB dependencies on FND_MSG_PUB

Line 54: FND_MSG_PUB.Initialize;

50: SAVEPOINT Perform_Material_Txn_pub;
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE
53: IF FND_API.To_Boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.Initialize;
55: END IF;
56:
57: -- Initialize API return status to success
58: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 297: FND_MSG_PUB.Count_And_Get

293: COMMIT;
294: END IF;
295:
296: -- Standard call to get message count and if count is 1, get message
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => fnd_api.g_false);
301:

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

312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: ROLLBACK TO Perform_Material_Txn_pub;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
317: p_data => x_msg_data,
318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO Perform_Material_Txn_pub;

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

318: p_encoded => fnd_api.g_false);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO Perform_Material_Txn_pub;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false);
325: WHEN OTHERS THEN
326: ROLLBACK TO Perform_Material_Txn_pub;

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

325: WHEN OTHERS THEN
326: ROLLBACK TO Perform_Material_Txn_pub;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
331: p_procedure_name => l_api_name,
332: p_error_text => SUBSTR(SQLERRM,1,240));
333: END IF;

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

326: ROLLBACK TO Perform_Material_Txn_pub;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
331: p_procedure_name => l_api_name,
332: p_error_text => SUBSTR(SQLERRM,1,240));
333: END IF;
334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

330: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
331: p_procedure_name => l_api_name,
332: p_error_text => SUBSTR(SQLERRM,1,240));
333: END IF;
334: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
335: p_data => x_msg_data,
336: p_encoded => fnd_api.g_false);
337: END Perform_Material_Txn;
338: