5506:
5507: p_return_status := FND_API.G_RET_STS_ERROR;
5508:
5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5507: p_return_status := FND_API.G_RET_STS_ERROR;
5508:
5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5515: END IF;
5508:
5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5515: END IF;
5516:
5509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5510: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_AS_AMG');
5511: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
5512: FND_MESSAGE.SET_TOKEN('ASSET', l_amg_pa_asset_name);
5513: FND_MESSAGE.SET_TOKEN('ENTITY', G_ASSET_CODE);
5514: FND_MSG_PUB.ADD;
5515: END IF;
5516:
5517: FND_MSG_PUB.Count_And_Get
5692: IF l_asset_csr%NOTFOUND THEN
5693: CLOSE l_asset_csr;
5694:
5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5696: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
5697: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Asset Reference');
5698: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_asset_reference);
5699: FND_MSG_PUB.add;
5700:
5693: CLOSE l_asset_csr;
5694:
5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5696: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
5697: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Asset Reference');
5698: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_asset_reference);
5699: FND_MSG_PUB.add;
5700:
5701: RAISE FND_API.G_EXC_ERROR;
5694:
5695: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5696: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
5697: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Asset Reference');
5698: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_asset_reference);
5699: FND_MSG_PUB.add;
5700:
5701: RAISE FND_API.G_EXC_ERROR;
5702: END IF;