148: FROM ar_cmgt_credit_requests
149: WHERE credit_request_id = l_credit_request_id;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END;
154:
155: -- set security context
156: FND_GLOBAL.apps_initialize
186: , x_conversion_status => l_conversion_status
187: , x_return_status => l_return_status
188: );
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR
191: THEN
192: RAISE FND_API.G_EXC_ERROR;
193: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
194: THEN
188: );
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR
191: THEN
192: RAISE FND_API.G_EXC_ERROR;
193: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR
191: THEN
192: RAISE FND_API.G_EXC_ERROR;
193: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
191: THEN
192: RAISE FND_API.G_EXC_ERROR;
193: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: --check if the order_amount has been changed
199: --if amount has not been changed, release the hold
228: , x_amount => l_new_amount
229: , x_conversion_status => l_conversion_status
230: , x_return_status => l_return_status
231: );
232: IF l_return_status = FND_API.G_RET_STS_ERROR
233: THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
236: THEN
230: , x_return_status => l_return_status
231: );
232: IF l_return_status = FND_API.G_RET_STS_ERROR
233: THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
236: THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
231: );
232: IF l_return_status = FND_API.G_RET_STS_ERROR
233: THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
236: THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: --Check if amount per bill-to site has been changed
233: THEN
234: RAISE FND_API.G_EXC_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
236: THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: --Check if amount per bill-to site has been changed
240: --if amount has not been changed, release holds for bill_to site
241: IF l_new_amount = l_trx_amount THEN
266: , x_amount => l_new_amount
267: , x_conversion_status => l_conversion_status
268: , x_return_status => l_return_status
269: );
270: IF l_return_status = FND_API.G_RET_STS_ERROR
271: THEN
272: RAISE FND_API.G_EXC_ERROR;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
274: THEN
268: , x_return_status => l_return_status
269: );
270: IF l_return_status = FND_API.G_RET_STS_ERROR
271: THEN
272: RAISE FND_API.G_EXC_ERROR;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
269: );
270: IF l_return_status = FND_API.G_RET_STS_ERROR
271: THEN
272: RAISE FND_API.G_EXC_ERROR;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: IF l_new_amount = l_trx_amount THEN
271: THEN
272: RAISE FND_API.G_EXC_ERROR;
273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: IF l_new_amount = l_trx_amount THEN
278: --OPEN the cursor for all lines
279: FOR c_line IN lines_csr(p_header_id =>l_source_column1)