DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on FND_API

Line 4366: x_return_status := FND_API.G_RET_STS_SUCCESS;

4362: -- customer in the order needs to be considered as per the RDD
4363:
4364: -- Bug 2328351 check for line ctg code as well
4365:
4366: x_return_status := FND_API.G_RET_STS_SUCCESS;
4367:
4368: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
4369:
4370: IF p_credit_check_rule_rec.credit_check_level_code = 'LINE'

Line 5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5256: WHEN OTHERS THEN
5257: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
5258: OE_DEBUG_PUB.ADD('EXCEPTION = '||
5259: SUBSTR(sqlerrm,1,200) );
5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261:
5262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5263: THEN
5264: FND_MSG_PUB.Add_Exc_Msg

Line 5305: x_return_status := FND_API.G_RET_STS_SUCCESS;

5301: OE_DEBUG_PUB.ADD('OEXUCRCB: In Get_Past_Due_Invoice');
5302: END IF;
5303:
5304: -- Initialize return status to success
5305: x_return_status := FND_API.G_RET_STS_SUCCESS;
5306:
5307: IF NVL(p_credit_check_rule_rec.quick_cr_check_flag,'N') = 'N'
5308: THEN
5309: -- Bug2408466

Line 5564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5560: END IF;
5561:
5562: EXCEPTION
5563: WHEN OTHERS THEN
5564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5566: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5567: END IF;
5568: RAISE;

Line 8548: x_return_status := FND_API.G_RET_STS_SUCCESS;

8544: THEN
8545: OE_DEBUG_PUB.ADD('OEXUCRCB: IN Get_order_exposure',1);
8546: END IF;
8547:
8548: x_return_status := FND_API.G_RET_STS_SUCCESS;
8549:
8550: IF G_debug_flag = 'Y'
8551: THEN
8552: OE_DEBUG_PUB.Add('exposure Input parameters ');

Line 10901: ELSIF x_return_status = FND_API.G_RET_STS_ERROR

10897: || NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
10898: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
10899: END IF;
10900: END LOOP;
10901: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
10902: THEN
10903: RAISE FND_API.G_EXC_ERROR;
10904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
10905: THEN

Line 10903: RAISE FND_API.G_EXC_ERROR;

10899: END IF;
10900: END LOOP;
10901: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
10902: THEN
10903: RAISE FND_API.G_EXC_ERROR;
10904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
10905: THEN
10906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10907: END IF;

Line 10904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

10900: END LOOP;
10901: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
10902: THEN
10903: RAISE FND_API.G_EXC_ERROR;
10904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
10905: THEN
10906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10907: END IF;
10908: --bug# 2714553

Line 10906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10902: THEN
10903: RAISE FND_API.G_EXC_ERROR;
10904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
10905: THEN
10906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10907: END IF;
10908: --bug# 2714553
10909:
10910: IF G_debug_flag = 'Y'

Line 10938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10934: IF site_external_exposure_csr%ISOPEN THEN
10935: CLOSE site_external_exposure_csr;
10936: END IF;
10937: WHEN OTHERS THEN
10938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
10941: Get_order_exposure');
10942: END IF;

Line 11171: x_return_status := FND_API.G_RET_STS_SUCCESS;

11167: oe_debug_pub.ADD('In OE_CREDIT_CHECK_UTIL.Send_Credit_Hold_NTF', 1);
11168: END IF;
11169:
11170: -- Initialize return status to success
11171: x_return_status := FND_API.G_RET_STS_SUCCESS;
11172:
11173: -- Get notification approver -- Created by
11174:
11175: BEGIN

Line 11304: x_return_status := FND_API.G_RET_STS_ERROR ;

11300:
11301: EXCEPTION
11302: WHEN OTHERS THEN
11303: BEGIN
11304: x_return_status := FND_API.G_RET_STS_ERROR ;
11305: IF G_debug_flag = 'Y'
11306: THEN
11307: oe_debug_pub.ADD(' EXCEPTION OTHERS IN SEND_NOTIFICATION');
11308: oe_debug_pub.ADD( ' Errm = '|| SUBSTR(sqlerrm,1,200) );

Line 11354: x_return_status := FND_API.G_RET_STS_SUCCESS;

11350: THEN
11351: OE_DEBUG_PUB.ADD('OEXUCRCB: IN GET_external_trx_amount');
11352: END IF;
11353:
11354: x_return_status := FND_API.G_RET_STS_SUCCESS;
11355: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
11356:
11357: IF G_debug_flag = 'Y'
11358: THEN

Line 11412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11408: OE_DEBUG_PUB.ADD('EXCEPTION: TOO_MANY_ROWS ');
11409: WHEN OTHERS THEN
11410: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11411: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11414: OE_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME
11416: , 'GET_external_trx_amount'

Line 11841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11837: ( G_PKG_NAME
11838: , 'Get_CC_Lookup_Meaning'
11839: );
11840: END IF;
11841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11842: END Get_CC_Lookup_Meaning;
11843:
11844:
11845: END OE_CREDIT_CHECK_UTIL;