DBA Data[Home] [Help]

APPS.OE_COMMITMENT_PVT dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: BEGIN
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'ENTERING OE_COMMITMENT_PVT' ) ;
56: END IF;
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59:
60: If do_commitment_sequencing Then
61: --new behavior this old procedure should not even get called

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( ' COMMITMENT HAVE OVERDRAWN MORE THAN ONCE' ) ;
120: oe_debug_pub.add( ' EXPECTED ERROR IN EVALUATE_COMMITMENT' , 1 ) ;
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- move code to calculate_commitment
124: elsif l_total_balance <= 0 then
125: --not to raise error if balance - current line amount exceed
126: --balance, allowing to use up last available balance

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: oe_debug_pub.add( 'LEAVING COMMITMENT' ) ;
146: END IF;
147: EXCEPTION
148: WHEN OTHERS THEN
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
151: THEN
152: FND_MSG_PUB.Add_Exc_Msg
153: ( G_PKG_NAME

Line 240: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

236: FUNCTION Get_Line_Total
237: ( p_line_rec IN OE_ORDER_PUB.line_rec_type
238: ) RETURN NUMBER IS
239:
240: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
241: l_total NUMBER;
242: l_charge_amount NUMBER;
243: l_allocate_tax_freight VARCHAR2(1) := 'N';
244: l_msg_count NUMBER;

Line 266: p_init_msg_list => FND_API.G_FALSE ,

262: -- get line level charges
263: IF nvl(p_line_rec.ordered_quantity, 0) > 0 THEN
264: OE_CHARGE_PVT.Get_Charge_Amount(
265: p_api_version_number => 1.1 ,
266: p_init_msg_list => FND_API.G_FALSE ,
267: p_header_id => p_line_rec.header_id ,
268: p_line_id => p_line_rec.line_id ,
269: p_all_charges => FND_API.G_FALSE ,
270: x_return_status => l_return_status ,

Line 269: p_all_charges => FND_API.G_FALSE ,

265: p_api_version_number => 1.1 ,
266: p_init_msg_list => FND_API.G_FALSE ,
267: p_header_id => p_line_rec.header_id ,
268: p_line_id => p_line_rec.line_id ,
269: p_all_charges => FND_API.G_FALSE ,
270: x_return_status => l_return_status ,
271: x_msg_count => l_msg_count ,
272: x_msg_data => l_msg_data ,
273: x_charge_amount => l_charge_amount );

Line 275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

271: x_msg_count => l_msg_count ,
272: x_msg_data => l_msg_data ,
273: x_charge_amount => l_charge_amount );
274:
275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: x_msg_data => l_msg_data ,
273: x_charge_amount => l_charge_amount );
274:
275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;

Line 277: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

273: x_charge_amount => l_charge_amount );
274:
275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;
281:

Line 278: RAISE FND_API.G_EXC_ERROR;

274:
275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;
281:
282: -- to include tax only if the tax calculation flag is 'Y'

Line 306: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

302: l_line_id NUMBER := p_request_rec.entity_id;
303: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
304: l_payment_types_rec OE_PAYMENTS_UTIL.Payment_Types_Rec_Type;
305: l_payment_types_tbl OE_PAYMENTS_UTIL.Payment_Types_Tbl_Type;
306: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
307: l_header_id NUMBER;
308: l_commitment_id NUMBER;
309: l_new_commitment_id NUMBER;
310: l_commitment_applied_amount NUMBER;

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464: END IF;
465:
466: EXCEPTION
467: WHEN NO_DATA_FOUND THEN
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469: END;
470:
471:
472: -- commitment_applied should be the lesser of the l_total and l_commitment_bal

Line 948: IF G_Do_Commitment_Sequencing <> FND_API.G_MISS_NUM THEN

944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947:
948: IF G_Do_Commitment_Sequencing <> FND_API.G_MISS_NUM THEN
949: IF G_Do_Commitment_Sequencing = 0 THEN
950: RETURN FALSE;
951: ELSE
952: RETURN TRUE;

Line 1001: END IF; -- end of G_Do_Commitment_Sequencing is FND_API.G_MISS_NUM.

997:
998: END IF; -- end of column1 exists chck
999: END IF; -- end of profile option checking.
1000:
1001: END IF; -- end of G_Do_Commitment_Sequencing is FND_API.G_MISS_NUM.
1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)