327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: end if;
329:
330: EXCEPTION WHEN OTHERS THEN
331: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_EXECUTION_JSP.CHECK_ASSET_METER_ASSOCIATION',
332: p_procedure_name => EAM_DEBUG.G_err_stack);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: END check_asset_meter_association;
335:
471: END IF;
472:
473: IF FND_API.TO_BOOLEAN(p_init_msg_list)
474: THEN
475: FND_MSG_PUB.initialize;
476: END IF;
477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
561: end if;
562: END IF; -- if(x_return_status = fnd_api.g_ret_success)
563:
564: -- if validate not passed then raise error
565: l_msg_count := FND_MSG_PUB.count_msg;
566: IF l_msg_count = 1 THEN
567: eam_execution_jsp.Get_Messages
568: (p_encoded => FND_API.G_FALSE,
569: p_msg_index => 1,
604: IF p_commit = FND_API.G_TRUE THEN
605: ROLLBACK TO add_meter_reading;
606: END IF;
607:
608: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_EXECUTION_JSP.ADD_METER_READING',
609: p_procedure_name => EAM_DEBUG.G_err_stack);
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: WHEN FND_API.G_EXC_ERROR THEN
612: IF p_commit = FND_API.G_TRUE THEN
612: IF p_commit = FND_API.G_TRUE THEN
613: ROLLBACK TO add_meter_reading;
614: END IF;
615:
616: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_EXECUTION_JSP.ADD_METER_READING',
617: p_procedure_name => EAM_DEBUG.G_err_stack);
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: WHEN OTHERS THEN
620: IF p_commit = FND_API.G_TRUE THEN
620: IF p_commit = FND_API.G_TRUE THEN
621: ROLLBACK TO add_meter_reading;
622: END IF;
623:
624: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_EXECUTION_JSP.ADD_METER_READING',
625: p_procedure_name => EAM_DEBUG.G_err_stack);
626:
627: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_MRR_EXCEPTION'
628: ,p_token1 => 'MESSAGE', p_value1 => SQLERRM);