DBA Data[Home] [Help]

APPS.HZ_CREDIT_REQUEST_PVT dependencies on FND_API

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 190: IF l_return_status = FND_API.G_RET_STS_ERROR

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

Line 192: RAISE FND_API.G_EXC_ERROR;

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;

Line 193: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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:

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_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:
198: --check if the order_amount has been changed
199: --if amount has not been changed, release the hold

Line 232: IF l_return_status = FND_API.G_RET_STS_ERROR

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

Line 234: RAISE FND_API.G_EXC_ERROR;

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;

Line 235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_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
240: --if amount has not been changed, release holds for bill_to site
241: IF l_new_amount = l_trx_amount THEN

Line 270: IF l_return_status = FND_API.G_RET_STS_ERROR

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

Line 272: RAISE FND_API.G_EXC_ERROR;

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;

Line 273: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_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
278: --OPEN the cursor for all lines
279: FOR c_line IN lines_csr(p_header_id =>l_source_column1)