APPS.AHL_PRD_VISITS_PVT dependencies on FND_MSG_PUB

Line 252: Fnd_Msg_Pub.initialize;

248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF Fnd_Api.to_boolean(p_init_msg_list)
251: THEN
252: Fnd_Msg_Pub.initialize;
253: END IF;
254:
255: -- Initialize API return status to success
256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 367: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

363: IF visit_rec.project_template_id IS NOT NULL THEN
364: OPEN c_proj_template(visit_rec.project_template_id);
365: FETCH c_proj_template INTO l_visit_rec.proj_template_name;
366: IF c_proj_template%NOTFOUND THEN
367: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
368: Fnd_Message.SET_NAME('AHL','AHL_VWP_INVALID_PROTEM');
369: Fnd_Msg_Pub.ADD;
370: RAISE Fnd_Api.G_EXC_ERROR;
371: END IF;

Line 369: Fnd_Msg_Pub.ADD;

365: FETCH c_proj_template INTO l_visit_rec.proj_template_name;
366: IF c_proj_template%NOTFOUND THEN
367: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
368: Fnd_Message.SET_NAME('AHL','AHL_VWP_INVALID_PROTEM');
369: Fnd_Msg_Pub.ADD;
370: RAISE Fnd_Api.G_EXC_ERROR;
371: END IF;
372: END IF;
373: CLOSE c_proj_template;

Line 449: Fnd_Msg_Pub.Count_And_Get

445: END IF;
446:
447: ------------------------End of API Body------------------------------------
448: -- Standard call to get message count and if count is 1, get message info
449: Fnd_Msg_Pub.Count_And_Get
450: ( p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => Fnd_Api.g_false);
453:

Line 474: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

470: EXCEPTION
471: WHEN Fnd_Api.G_EXC_ERROR THEN
472: x_return_status := Fnd_Api.G_RET_STS_ERROR;
473: ROLLBACK TO Get_Visit_Details;
474: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
475: p_data => x_msg_data,
476: p_encoded => Fnd_Api.g_false);
477:
478:

Line 482: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

478:
479: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
481: ROLLBACK TO Get_Visit_Details;
482: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => Fnd_Api.g_false);
485:
486: WHEN OTHERS THEN

Line 489: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

485:
486: WHEN OTHERS THEN
487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
488: ROLLBACK TO Get_Visit_Details;
489: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
490: p_procedure_name => 'Get_Visit_Details',
491: p_error_text => SQLERRM);
492:
493: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

Line 493: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,

489: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
490: p_procedure_name => 'Get_Visit_Details',
491: p_error_text => SQLERRM);
492:
493: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
494: p_data => x_msg_data,
495: p_encoded => Fnd_Api.g_false);
496: END Get_Visit_Details;
497: