eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_UTIL dependencies on FND_API

Line 4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4384: WHEN OTHERS THEN
4385: IF G_debug_flag = 'Y' THEN
4386: oe_debug_pub.add('Error in Update_Released_Amount:'||SUBSTR(SQLERRM,1,250));
4387: END IF;
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4389: END Update_Released_Amount;
4390:
4391: --------------------------------------------------------------------------------------------
4392: -- Procedure Update_Credit_Profile_Level

Line 4447: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4443: END IF;
4444: EXCEPTION
4445: WHEN OTHERS THEN
4446: oe_debug_pub.ADD('OEXUCRCB: Exception raised!');
4447: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4448:
4449: END;
4450: IF G_debug_flag = 'Y' THEN
4451: oe_debug_pub.add('OEXUCRCB: Retrieved Hold Source Id: '|| l_hold_source_id);

Line 4470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4466: WHEN OTHERS THEN
4467: IF G_debug_flag = 'Y' THEN
4468: oe_debug_pub.add('Error in Update_Credit_Profile_Level:'||SUBSTR(SQLERRM,1,250));
4469: END IF;
4470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4471: END Update_Credit_Profile_Level;
4472: --ER 12363706 end
4473:
4474: -----------------------------------------------------------------------------

Line 4522: x_return_status := FND_API.G_RET_STS_SUCCESS;

4518: -- customer in the order needs to be considered as per the RDD
4519:
4520: -- Bug 2328351 check for line ctg code as well
4521:
4522: x_return_status := FND_API.G_RET_STS_SUCCESS;
4523:
4524: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
4525:
4526: IF p_credit_check_rule_rec.credit_check_level_code = 'LINE'

Line 5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5462: WHEN OTHERS THEN
5463: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
5464: OE_DEBUG_PUB.ADD('EXCEPTION = '||
5465: SUBSTR(sqlerrm,1,200) );
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467:
5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5469: THEN
5470: FND_MSG_PUB.Add_Exc_Msg

Line 5511: x_return_status := FND_API.G_RET_STS_SUCCESS;

5507: OE_DEBUG_PUB.ADD('OEXUCRCB: In Get_Past_Due_Invoice');
5508: END IF;
5509:
5510: -- Initialize return status to success
5511: x_return_status := FND_API.G_RET_STS_SUCCESS;
5512:
5513: IF NVL(p_credit_check_rule_rec.quick_cr_check_flag,'N') = 'N'
5514: THEN
5515: -- Bug2408466

Line 5770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5766: END IF;
5767:
5768: EXCEPTION
5769: WHEN OTHERS THEN
5770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5772: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5773: END IF;
5774: RAISE;

Line 8901: x_return_status := FND_API.G_RET_STS_SUCCESS;

8897: THEN
8898: OE_DEBUG_PUB.ADD('OEXUCRCB: IN Get_order_exposure',1);
8899: END IF;
8900:
8901: x_return_status := FND_API.G_RET_STS_SUCCESS;
8902:
8903: IF G_debug_flag = 'Y'
8904: THEN
8905: OE_DEBUG_PUB.Add('exposure Input parameters ');

Line 11254: ELSIF x_return_status = FND_API.G_RET_STS_ERROR

11250: || NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'),1);
11251: OE_DEBUG_PUB.ADD('!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!');
11252: END IF;
11253: END LOOP;
11254: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
11255: THEN
11256: RAISE FND_API.G_EXC_ERROR;
11257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
11258: THEN

Line 11256: RAISE FND_API.G_EXC_ERROR;

11252: END IF;
11253: END LOOP;
11254: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
11255: THEN
11256: RAISE FND_API.G_EXC_ERROR;
11257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
11258: THEN
11259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11260: END IF;

Line 11257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

11253: END LOOP;
11254: ELSIF x_return_status = FND_API.G_RET_STS_ERROR
11255: THEN
11256: RAISE FND_API.G_EXC_ERROR;
11257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
11258: THEN
11259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11260: END IF;
11261: --bug# 2714553

Line 11259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

11255: THEN
11256: RAISE FND_API.G_EXC_ERROR;
11257: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
11258: THEN
11259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11260: END IF;
11261: --bug# 2714553
11262:
11263: IF G_debug_flag = 'Y'

Line 11291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11287: IF site_external_exposure_csr%ISOPEN THEN
11288: CLOSE site_external_exposure_csr;
11289: END IF;
11290: WHEN OTHERS THEN
11291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11293: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
11294: Get_order_exposure');
11295: END IF;

Line 11524: x_return_status := FND_API.G_RET_STS_SUCCESS;

11520: oe_debug_pub.ADD('In OE_CREDIT_CHECK_UTIL.Send_Credit_Hold_NTF', 1);
11521: END IF;
11522:
11523: -- Initialize return status to success
11524: x_return_status := FND_API.G_RET_STS_SUCCESS;
11525:
11526: -- Get notification approver -- Created by
11527:
11528: BEGIN

Line 11663: x_return_status := FND_API.G_RET_STS_ERROR ;

11659:
11660: EXCEPTION
11661: WHEN OTHERS THEN
11662: BEGIN
11663: x_return_status := FND_API.G_RET_STS_ERROR ;
11664: IF G_debug_flag = 'Y'
11665: THEN
11666: oe_debug_pub.ADD(' EXCEPTION OTHERS IN SEND_NOTIFICATION');
11667: oe_debug_pub.ADD( ' Errm = '|| SUBSTR(sqlerrm,1,200) );

Line 11713: x_return_status := FND_API.G_RET_STS_SUCCESS;

11709: THEN
11710: OE_DEBUG_PUB.ADD('OEXUCRCB: IN GET_external_trx_amount');
11711: END IF;
11712:
11713: x_return_status := FND_API.G_RET_STS_SUCCESS;
11714: OE_CREDIT_CHECK_UTIL.g_current_order_value := NULL ;
11715:
11716: IF G_debug_flag = 'Y'
11717: THEN

Line 11771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11767: OE_DEBUG_PUB.ADD('EXCEPTION: TOO_MANY_ROWS ');
11768: WHEN OTHERS THEN
11769: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11770: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11773: OE_MSG_PUB.Add_Exc_Msg
11774: ( G_PKG_NAME
11775: , 'GET_external_trx_amount'

Line 12202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12198: ( G_PKG_NAME
12199: , 'Get_CC_Lookup_Meaning'
12200: );
12201: END IF;
12202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12203: END Get_CC_Lookup_Meaning;
12204:
12205:
12206: END OE_CREDIT_CHECK_UTIL;