APPS.OE_PARTY_TOTALS dependencies on FND_API

Line 119: RAISE FND_API.G_EXC_ERROR;

115: l_cust_currency_code := fnd_profile.value('OM_CUST_TOTAL_CURRENCY');
116:
117: IF l_cust_currency_code IS NULL THEN
118: oe_debug_pub.ADD('Profile OM: Party Total Currency is not set', 2);
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121: oe_debug_pub.ADD('The Party Total Currency is '||l_cust_currency_code, 2);
122: FOR C1 IN C_PARTIES LOOP
123: BEGIN

Line 150: RAISE FND_API.G_EXC_ERROR;

146: l_sob_currency_code := OE_Upgrade_Misc.GET_SOB_CURRENCY(c2.org_id);
147:
148: IF l_sob_currency_code IS NULL THEN
149: oe_debug_pub.ADD('Set Of Books currency does not exist for order '||to_char(c2.order_number), 2);
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: l_converted_total := NVL(l_line_total,0) +
154: NVL(l_charge_total,0);

Line 262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

258: , p_order_count => l_order_count
259: , p_last_order_date => l_last_order_date
260: , x_return_status => l_return_status
261: );
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: oe_debug_pub.ADD('Error in updating the Party record for party '||to_char(c1.party_id), 2);
264: END IF;
265: END IF;
266:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: l_date DATE := p_last_update_date;
313:
314: BEGIN
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: IF p_party_type = 'PERSON' OR
319: p_party_type = 'GROUP' OR
320: p_party_type = 'PARTY_RELATIONSHIP' OR

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

327: WHERE party_id = p_party_id;
328:
329: ELSE
330: oe_debug_pub.ADD('Invalid Party type for PARTY '||to_char(p_party_id), 2);
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;
333:
334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335:

Line 334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

330: oe_debug_pub.ADD('Invalid Party type for PARTY '||to_char(p_party_id), 2);
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;
333:
334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335:
336: If l_msg_count > 0 THEN
337:
338: FOR k in 1 .. l_msg_count LOOP

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

350: WHEN OTHERS THEN
351: v_errcode := SQLCODE;
352: v_errmsg := SQLERRM;
353: oe_debug_pub.ADD('Error in updating the Party '||to_char(p_party_id) || ' SQL error is '|| to_char(v_errcode) || v_errmsg, 2);
354: x_return_status := FND_API.G_RET_STS_ERROR;
355:
356: END Update_HZ_Parties;
357:
358: END OE_Party_TOTALS;