5445: WHEN GL_CURRENCY_API.NO_RATE
5446: THEN
5447: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE ');
5448: x_conversion_status(1).usage_curr_code := p_transaction_curr_code;
5449: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
5450: OE_DEBUG_PUB.ADD('Exception table added ');
5451:
5452: WHEN NO_DATA_FOUND
5453: THEN
11278: OE_DEBUG_PUB.ADD('l_current_usage_cur = '||
11279: l_current_usage_cur );
11280: x_conversion_status(1).usage_curr_code := l_current_usage_cur ;
11281:
11282: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
11283: OE_DEBUG_PUB.ADD('Exception table added ');
11284: IF cust_external_exposure_csr%ISOPEN THEN
11285: CLOSE cust_external_exposure_csr;
11286: END IF;
11574: l_order_hold_comment := p_cc_hold_comment;
11575: l_line_hold_count := NULL;
11576: ELSIF p_credit_hold_level = 'LINE'
11577: THEN
11578: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
11579: l_order_hold_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
11580: l_line_hold_count := OE_CREDIT_CHECK_LINES_PVT.G_line_hold_count;
11581: END IF;
11582:
11575: l_line_hold_count := NULL;
11576: ELSIF p_credit_hold_level = 'LINE'
11577: THEN
11578: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
11579: l_order_hold_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
11580: l_line_hold_count := OE_CREDIT_CHECK_LINES_PVT.G_line_hold_count;
11581: END IF;
11582:
11583: IF G_debug_flag = 'Y'
11756: EXCEPTION
11757: WHEN GL_CURRENCY_API.NO_RATE THEN
11758: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE ');
11759: x_conversion_status(1).usage_curr_code := p_transaction_curr_code;
11760: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
11761: OE_DEBUG_PUB.ADD('Exception table added ');
11762: WHEN NO_DATA_FOUND THEN
11763: x_amount := 0 ;
11764: OE_DEBUG_PUB.ADD('EXCEPTION: NO_DATA_FOUND ');