4813: okc_debug.log('2200: Entered UPDATE_CONTRACT_AMOUNT');
4814: END IF;
4815:
4816: IF ((p_from_ste_code is NULL) OR (p_to_ste_code is NULL) OR (p_id is null)) THEN
4817: raise FND_API.G_EXC_ERROR;
4818: END IF;
4819:
4820: IF (l_debug = 'Y') THEN
4821: okc_debug.log('2210: Parameter Values ' ||
5091: where id = p_id;
5092:
5093: ---
5094:
5095: x_return_status := FND_API.G_RET_STS_SUCCESS;
5096:
5097: ---
5098: Exception
5099:
5096:
5097: ---
5098: Exception
5099:
5100: WHEN FND_API.G_EXC_ERROR THEN
5101: x_return_status := FND_API.G_RET_STS_ERROR;
5102:
5103: IF (l_debug = 'Y') THEN
5104: okc_debug.log('2700: Leaving OKC_CONTRACT_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
5097: ---
5098: Exception
5099:
5100: WHEN FND_API.G_EXC_ERROR THEN
5101: x_return_status := FND_API.G_RET_STS_ERROR;
5102:
5103: IF (l_debug = 'Y') THEN
5104: okc_debug.log('2700: Leaving OKC_CONTRACT_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
5105: END IF;
5100: WHEN FND_API.G_EXC_ERROR THEN
5101: x_return_status := FND_API.G_RET_STS_ERROR;
5102:
5103: IF (l_debug = 'Y') THEN
5104: okc_debug.log('2700: Leaving OKC_CONTRACT_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
5105: END IF;
5106:
5107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5103: IF (l_debug = 'Y') THEN
5104: okc_debug.log('2700: Leaving OKC_CONTRACT_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
5105: END IF;
5106:
5107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5109:
5110: IF (l_debug = 'Y') THEN
5111: okc_debug.log('2710: Leaving OKC_CONTRACT_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
5104: okc_debug.log('2700: Leaving OKC_CONTRACT_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
5105: END IF;
5106:
5107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5109:
5110: IF (l_debug = 'Y') THEN
5111: okc_debug.log('2710: Leaving OKC_CONTRACT_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
5112: END IF;
5107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5109:
5110: IF (l_debug = 'Y') THEN
5111: okc_debug.log('2710: Leaving OKC_CONTRACT_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
5112: END IF;
5113:
5114: WHEN OTHERS THEN
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5111: okc_debug.log('2710: Leaving OKC_CONTRACT_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
5112: END IF;
5113:
5114: WHEN OTHERS THEN
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5116:
5117: IF (l_debug = 'Y') THEN
5118: okc_debug.log('2720: Leaving OKC_CONTRACT_PVT because of EXCEPTION: '||sqlerrm);
5119: END IF;