APPS.AHL_UMP_SR_GRP dependencies on FND_MSG_PUB

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

68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
70: WHEN OTHERS THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
73: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
74: p_procedure_name => 'Create_SR_Unit_Effectivity',
75: p_error_text => SUBSTR(SQLERRM,1,240));
76: END IF;

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

69:
70: WHEN OTHERS THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
73: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
74: p_procedure_name => 'Create_SR_Unit_Effectivity',
75: p_error_text => SUBSTR(SQLERRM,1,240));
76: END IF;
77:

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

136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
141: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
142: p_procedure_name => 'Process_SR_Updates',
143: p_error_text => SUBSTR(SQLERRM,1,240));
144: END IF;

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

137:
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
141: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
142: p_procedure_name => 'Process_SR_Updates',
143: p_error_text => SUBSTR(SQLERRM,1,240));
144: END IF;
145:

Line 260: FND_MSG_PUB.Count_And_Get

256: COMMIT WORK;
257: END IF;
258:
259: -- Standard call to get message count and if count is 1, get message info
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data,
263: p_encoded => fnd_api.g_false
264: );

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

270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO Process_SR_MR_Associations_pvt;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
275: p_data => x_msg_data,
276: p_encoded => fnd_api.g_false);
277: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
278:

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

278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO Process_SR_MR_Associations_pvt;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
283: p_data => x_msg_data,
284: p_encoded => fnd_api.g_false);
285: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
286:

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

286:
287: WHEN OTHERS THEN
288: ROLLBACK TO Process_SR_MR_Associations_pvt;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
292: p_procedure_name => 'Process_SR_MR_Associations',
293: p_error_text => SUBSTR(SQLERRM,1,240));
294: END IF;

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

287: WHEN OTHERS THEN
288: ROLLBACK TO Process_SR_MR_Associations_pvt;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
292: p_procedure_name => 'Process_SR_MR_Associations',
293: p_error_text => SUBSTR(SQLERRM,1,240));
294: END IF;
295: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

291: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
292: p_procedure_name => 'Process_SR_MR_Associations',
293: p_error_text => SUBSTR(SQLERRM,1,240));
294: END IF;
295: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
296: p_data => x_msg_data,
297: p_encoded => fnd_api.g_false);
298: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
299: