5239: WHEN GL_CURRENCY_API.NO_RATE
5240: THEN
5241: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE ');
5242: x_conversion_status(1).usage_curr_code := p_transaction_curr_code;
5243: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
5244: OE_DEBUG_PUB.ADD('Exception table added ');
5245:
5246: WHEN NO_DATA_FOUND
5247: THEN
10925: OE_DEBUG_PUB.ADD('l_current_usage_cur = '||
10926: l_current_usage_cur );
10927: x_conversion_status(1).usage_curr_code := l_current_usage_cur ;
10928:
10929: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
10930: OE_DEBUG_PUB.ADD('Exception table added ');
10931: IF cust_external_exposure_csr%ISOPEN THEN
10932: CLOSE cust_external_exposure_csr;
10933: END IF;
11215: l_order_hold_comment := p_cc_hold_comment;
11216: l_line_hold_count := NULL;
11217: ELSIF p_credit_hold_level = 'LINE'
11218: THEN
11219: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
11220: l_order_hold_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
11221: l_line_hold_count := OE_CREDIT_CHECK_LINES_PVT.G_line_hold_count;
11222: END IF;
11223:
11216: l_line_hold_count := NULL;
11217: ELSIF p_credit_hold_level = 'LINE'
11218: THEN
11219: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
11220: l_order_hold_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
11221: l_line_hold_count := OE_CREDIT_CHECK_LINES_PVT.G_line_hold_count;
11222: END IF;
11223:
11224: IF G_debug_flag = 'Y'
11397: EXCEPTION
11398: WHEN GL_CURRENCY_API.NO_RATE THEN
11399: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE ');
11400: x_conversion_status(1).usage_curr_code := p_transaction_curr_code;
11401: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
11402: OE_DEBUG_PUB.ADD('Exception table added ');
11403: WHEN NO_DATA_FOUND THEN
11404: x_amount := 0 ;
11405: OE_DEBUG_PUB.ADD('EXCEPTION: NO_DATA_FOUND ');