eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CNCL_VALIDATE_LINE_SCREDIT dependencies on OE_CNCL_VALIDATE

Line 1: PACKAGE BODY OE_CNCL_Validate_Line_Scredit AS

1: PACKAGE BODY OE_CNCL_Validate_Line_Scredit AS
2: /* $Header: OEXVCLCB.pls 120.0 2005/05/31 23:39:23 appldev noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Validate_Line_Scredit';

2: /* $Header: OEXVCLCB.pls 120.0 2005/05/31 23:39:23 appldev noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Validate_Line_Scredit';
7:
8: Function Duplicate_Salescredit
9: (p_salesrep_id IN Number
10: ,p_sales_credit_type_id IN NUMBER

Line 26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);

22: AND sales_credit_type_id = p_sales_credit_type_id
23: AND sales_credit_id <> nvl(p_sales_credit_id,-5);
24: l_dummy varchar2(30);
25: BEGIN
26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
27: OPEN C_Dup_Salescredit(p_salesrep_id
28: ,p_sales_credit_type_id
29: ,p_line_id
30: ,p_sales_credit_id);

Line 41: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);

37: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_LINE_CREDIT');
38: oe_msg_pub.add;
39:
40: END IF;
41: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
42: Return TRUE;
43: ELSE
44: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
45: Return FALSE;

Line 44: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);

40: END IF;
41: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
42: Return TRUE;
43: ELSE
44: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
45: Return FALSE;
46: END IF;
47: END Duplicate_Salescredit;
48:

Line 60: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Entity',1);

56:
57: IS
58: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
59: BEGIN
60: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Entity',1);
61:
62: -- Check required attributes.
63:
64: /* IF p_Line_Scredit_rec.sales_credit_id IS NULL

Line 189: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Entity',1);

185:
186: -- Done validating entity
187:
188: x_return_status := l_return_status;
189: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Entity',1);
190:
191: EXCEPTION
192:
193: WHEN FND_API.G_EXC_ERROR THEN

Line 223: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Attributes',1);

219: , p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
220: )
221: IS
222: BEGIN
223: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE_SCREDIT.Attributes',1);
224:
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226:
227: -- Validate Line_Scredit attributes

Line 231: IF NOT OE_CNCL_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN

227: -- Validate Line_Scredit attributes
228:
229: IF p_Line_Scredit_rec.created_by IS NOT NULL
230: THEN
231: IF NOT OE_CNCL_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: END IF;
234: END IF;
235:

Line 238: IF NOT OE_CNCL_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN

234: END IF;
235:
236: IF p_Line_Scredit_rec.creation_date IS NOT NULL
237: THEN
238: IF NOT OE_CNCL_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: END IF;
241: END IF;
242:

Line 245: IF NOT OE_CNCL_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN

241: END IF;
242:
243: IF p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL
244: THEN
245: IF NOT OE_CNCL_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: END IF;
248: END IF;
249:

Line 252: IF NOT OE_CNCL_Validate.Header(p_Line_Scredit_rec.header_id) THEN

248: END IF;
249:
250: /* IF p_Line_Scredit_rec.header_id IS NOT NULL
251: THEN
252: IF NOT OE_CNCL_Validate.Header(p_Line_Scredit_rec.header_id) THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: END IF;
255: END IF;
256: */

Line 260: IF NOT OE_CNCL_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN

256: */
257:
258: IF p_Line_Scredit_rec.last_updated_by IS NOT NULL
259: THEN
260: IF NOT OE_CNCL_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263: END IF;
264:

Line 267: IF NOT OE_CNCL_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN

263: END IF;
264:
265: IF p_Line_Scredit_rec.last_update_date IS NOT NULL
266: THEN
267: IF NOT OE_CNCL_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: END IF;
270: END IF;
271:

Line 274: IF NOT OE_CNCL_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN

270: END IF;
271:
272: IF p_Line_Scredit_rec.last_update_login IS NOT NULL
273: THEN
274: IF NOT OE_CNCL_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277: END IF;
278:

Line 281: IF NOT OE_CNCL_Validate.Line(p_Line_Scredit_rec.line_id) THEN

277: END IF;
278:
279: /* IF p_Line_Scredit_rec.line_id IS NOT NULL
280: THEN
281: IF NOT OE_CNCL_Validate.Line(p_Line_Scredit_rec.line_id) THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: END IF;
284: END IF;
285: */

Line 288: IF NOT OE_CNCL_Validate.Percent(p_Line_Scredit_rec.percent) THEN

284: END IF;
285: */
286: IF p_Line_Scredit_rec.percent IS NOT NULL
287: THEN
288: IF NOT OE_CNCL_Validate.Percent(p_Line_Scredit_rec.percent) THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: END IF;
292:

Line 296: IF NOT OE_CNCL_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN

292:
293:
294: IF p_Line_Scredit_rec.salesrep_id IS NOT NULL
295: THEN
296: IF NOT OE_CNCL_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: END IF;
299: END IF;
300:

Line 303: IF NOT OE_CNCL_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN

299: END IF;
300:
301: /* IF p_Line_Scredit_rec.sales_credit_id IS NOT NULL
302: THEN
303: IF NOT OE_CNCL_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END IF;
306: END IF;
307: */

Line 311: IF NOT OE_CNCL_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN

307: */
308:
309: IF p_Line_Scredit_rec.wh_update_date IS NOT NULL
310: THEN
311: IF NOT OE_CNCL_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: END IF;
314: END IF;
315:

Line 337: IF NOT OE_CNCL_VALIDATE.Sales_Credits_Desc_Flex

333: THEN
334:
335:
336: oe_debug_pub.add('Before calling Line Sales_Credits_Desc_Flex',2);
337: IF NOT OE_CNCL_VALIDATE.Sales_Credits_Desc_Flex
338: (p_context => p_Line_Scredit_rec.context
339: ,p_attribute1 => p_Line_Scredit_rec.attribute1
340: ,p_attribute2 => p_Line_Scredit_rec.attribute2
341: ,p_attribute3 => p_Line_Scredit_rec.attribute3

Line 362: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Attributes',1);

358: oe_debug_pub.add('After Line Sales_Credits_Desc_Flex ' || x_return_status,2);
359:
360: END IF;
361:
362: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE_SCREDIT.Attributes',1);
363: -- Done validating attributes
364:
365: EXCEPTION
366:

Line 390: END OE_CNCL_Validate_Line_Scredit;

386:
387: END Attributes;
388:
389:
390: END OE_CNCL_Validate_Line_Scredit;