APPS.OE_ADJ_PRIVILEGE dependencies on FND_API

Line 58: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

54:
55:
56: PROCEDURE Check_Manual_Discount_Priv
57: ( p_api_version_number IN NUMBER
58: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
59: , x_return_status OUT NOCOPY VARCHAR2
60:
61: , x_msg_count OUT NOCOPY NUMBER
62:

Line 65: , p_order_type_id IN NUMBER := FND_API.G_MISS_NUM

61: , x_msg_count OUT NOCOPY NUMBER
62:
63: , x_msg_data OUT NOCOPY VARCHAR2
64:
65: , p_order_type_id IN NUMBER := FND_API.G_MISS_NUM
66: , p_header_id IN NUMBER
67: , p_line_id IN NUMBER
68: , p_list_price IN NUMBER
69: , p_discounting_privilege IN VARCHAR2

Line 91: IF NOT FND_API.Compatible_API_Call

87: --
88: BEGIN
89:
90: -- Standard call to check for call compatibility
91: IF NOT FND_API.Compatible_API_Call
92: (l_api_version_number,
93: p_api_version_number,
94: l_api_name,
95: G_PKG_NAME

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: l_api_name,
95: G_PKG_NAME
96: )
97: THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101:
102: -- Initialize message list.

Line 103: IF FND_API.to_Boolean(p_init_msg_list) THEN

99: END IF;
100:
101:
102: -- Initialize message list.
103: IF FND_API.to_Boolean(p_init_msg_list) THEN
104: OE_MSG_PUB.initialize;
105: END IF;
106:
107:

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: OE_MSG_PUB.initialize;
105: END IF;
106:
107:
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: /********************************************************
111: IF p_discounting_privilege = 'NONE' THEN
112:

Line 117: RAISE FND_API.G_EXC_ERROR;

113: fnd_message.set_name('QP', 'OE_MANDIS_DISALLOWED');
114: fnd_message.set_token('REASON', 'OE_MANDIS_NO_PRIVILEGE', TRUE);
115: OE_MSG_PUB.Add;
116:
117: RAISE FND_API.G_EXC_ERROR;
118:
119: ELSIF (p_list_price IS NULL
120: OR
121: p_list_price = 0)

Line 130: RAISE FND_API.G_EXC_ERROR;

126: 'OE_MANDIS_NO_LIST_PRICE',
127: TRUE);
128: OE_MSG_PUB.Add;
129:
130: RAISE FND_API.G_EXC_ERROR;
131:
132:
133: -- Check to make sure that the list price field is set
134: -- otherwise you cannot apply manual discounts

Line 145: IF p_order_type_id <> FND_API.G_MISS_NUM THEN

141: -- list prices: if it does not or if it does and you
142: -- have 'UNLIMITED' discounting ability then you can
143: -- apply manual discounts
144:
145: IF p_order_type_id <> FND_API.G_MISS_NUM THEN
146:
147: BEGIN
148: SELECT NULL
149: INTO L_Dummy

Line 165: RAISE FND_API.G_EXC_ERROR;

161: fnd_message.set_token('REASON',
162: 'OE_MANDIS_PRICES_ENFORCED',
163: TRUE);
164: OE_MSG_PUB.Add;
165: RAISE FND_API.G_EXC_ERROR;
166: END;
167: END IF;
168:
169: -- Select the price adjustment id of the single manual discount

Line 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

186: x_price_adjustment_id := l_price_adjustment_id;
187: IF l_debug_level > 0 THEN
188: oe_debug_pub.add( 'OEXSADJB. ADJ_ID = '|| TO_CHAR ( L_PRICE_ADJUSTMENT_ID ) ) ;
189: END IF;
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: -- now calculate the total percentage on this
193: -- order line, excluding manual discounts
194: SELECT NVL( SUM( NVL( Adjusted_amount, 0) ), 0)

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204: x_adjustment_total := l_adjustment_total;
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: END;
210:
211: END IF;
212: END IF;

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212: END IF;
213:
214: EXCEPTION
215:
216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: x_return_status := FND_API.G_RET_STS_ERROR;
219:
220: -- Get message count and data

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214: EXCEPTION
215:
216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: x_return_status := FND_API.G_RET_STS_ERROR;
219:
220: -- Get message count and data
221: OE_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: , p_data => x_msg_data
224: );
225:
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228:
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230:
231: -- Get message count and data

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225:
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228:
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230:
231: -- Get message count and data
232: OE_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

236:
237:
238: WHEN OTHERS THEN
239:
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241:
242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: OE_MSG_PUB.Add_Exc_Msg