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 364: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

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

Line 366: Fnd_Msg_Pub.ADD;

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

Line 446: Fnd_Msg_Pub.Count_And_Get

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

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

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

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

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

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

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

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

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