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_VALIDATE_LINE_SCREDIT dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Line_Scredit AS

1: PACKAGE BODY OE_Validate_Line_Scredit AS
2: /* $Header: OEXLLSCB.pls 120.1 2005/12/29 04:32:41 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXLLSCB.pls 120.1 2005/12/29 04:32:41 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_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_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_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_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_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
42: Return TRUE;
43: ELSE
44: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Duplicate_Salescredit',1);
45: Return FALSE;

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

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

Line 67: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Validate_LSC_QUOTA_TOTAL',1);

63: AND sc.sales_credit_type_id = sct.sales_credit_type_id
64: AND sct.quota_flag = 'Y';
65:
66: BEGIN
67: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Validate_LSC_QUOTA_TOTAL',1);
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69: OPEN C_LSC_Quota_Total(p_line_id);
70: FETCH C_LSC_Quota_Total
71: INTO l_percent_total;

Line 87: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Validate_LSC_QUOTA_TOTAL',1);

83: FND_MESSAGE.SET_TOKEN('TOTAL',to_char(l_percent_total));
84: oe_msg_pub.add;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: END IF;
87: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Validate_LSC_QUOTA_TOTAL',1);
88: EXCEPTION
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91:

Line 125: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Entity',1);

121:
122: --bug 3275243
123: l_ar_decimal_limit CONSTANT NUMBER:=4;
124: BEGIN
125: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Entity',1);
126:
127: -- Check required attributes.
128:
129: IF p_Line_Scredit_rec.sales_credit_id IS NULL

Line 223: oe_debug_pub.add('In OE_Validate_Header_Scredit.entity:Error:percentage more than 4, AR allowes max 4');

219:
220: END IF;
221: ElsIf p_line_Scredit_rec.PERCENT <> FND_API.G_MISS_NUM THEN
222: IF length(p_line_scredit_rec.percent- trunc(p_line_Scredit_rec.PERCENT))- 1 > l_ar_decimal_limit THEN
223: oe_debug_pub.add('In OE_Validate_Header_Scredit.entity:Error:percentage more than 4, AR allowes max 4');
224: oe_debug_pub.add(' Header id:'||p_line_scredit_rec.header_id);
225:
226: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.SET_NAME('ONT','ONT_PERCENTAGE_FORMAT');

Line 272: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity',1);

268:
269: -- Done validating entity
270:
271: x_return_status := l_return_status;
272: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity',1);
273:
274: EXCEPTION
275:
276: WHEN FND_API.G_EXC_ERROR THEN

Line 310: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Attributes',1);

306: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
307: )
308: IS
309: BEGIN
310: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Attributes',1);
311:
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313:
314: -- Validate Line_Scredit attributes

Line 321: IF NOT OE_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN

317: ( p_Line_Scredit_rec.created_by <>
318: p_old_Line_Scredit_rec.created_by OR
319: p_old_Line_Scredit_rec.created_by IS NULL )
320: THEN
321: IF NOT OE_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: END IF;
324: END IF;
325:

Line 331: IF NOT OE_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN

327: ( p_Line_Scredit_rec.creation_date <>
328: p_old_Line_Scredit_rec.creation_date OR
329: p_old_Line_Scredit_rec.creation_date IS NULL )
330: THEN
331: IF NOT OE_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END IF;
334: END IF;
335:

Line 341: IF NOT OE_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN

337: ( p_Line_Scredit_rec.dw_update_advice_flag <>
338: p_old_Line_Scredit_rec.dw_update_advice_flag OR
339: p_old_Line_Scredit_rec.dw_update_advice_flag IS NULL )
340: THEN
341: IF NOT OE_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: END IF;
344: END IF;
345:

Line 351: IF NOT OE_Validate.Header(p_Line_Scredit_rec.header_id) THEN

347: ( p_Line_Scredit_rec.header_id <>
348: p_old_Line_Scredit_rec.header_id OR
349: p_old_Line_Scredit_rec.header_id IS NULL )
350: THEN
351: IF NOT OE_Validate.Header(p_Line_Scredit_rec.header_id) THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: END IF;
354: END IF;
355:

Line 361: IF NOT OE_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN

357: ( p_Line_Scredit_rec.last_updated_by <>
358: p_old_Line_Scredit_rec.last_updated_by OR
359: p_old_Line_Scredit_rec.last_updated_by IS NULL )
360: THEN
361: IF NOT OE_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364: END IF;
365:

Line 371: IF NOT OE_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN

367: ( p_Line_Scredit_rec.last_update_date <>
368: p_old_Line_Scredit_rec.last_update_date OR
369: p_old_Line_Scredit_rec.last_update_date IS NULL )
370: THEN
371: IF NOT OE_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF;
375:

Line 381: IF NOT OE_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN

377: ( p_Line_Scredit_rec.last_update_login <>
378: p_old_Line_Scredit_rec.last_update_login OR
379: p_old_Line_Scredit_rec.last_update_login IS NULL )
380: THEN
381: IF NOT OE_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: END IF;
384: END IF;
385:

Line 391: IF NOT OE_Validate.Line(p_Line_Scredit_rec.line_id) THEN

387: ( p_Line_Scredit_rec.line_id <>
388: p_old_Line_Scredit_rec.line_id OR
389: p_old_Line_Scredit_rec.line_id IS NULL )
390: THEN
391: IF NOT OE_Validate.Line(p_Line_Scredit_rec.line_id) THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: END IF;
394: END IF;
395:

Line 401: IF NOT OE_Validate.Percent(p_Line_Scredit_rec.percent) THEN

397: ( p_Line_Scredit_rec.percent <>
398: p_old_Line_Scredit_rec.percent OR
399: p_old_Line_Scredit_rec.percent IS NULL )
400: THEN
401: IF NOT OE_Validate.Percent(p_Line_Scredit_rec.percent) THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: END IF;
404: END IF;
405:

Line 412: IF NOT OE_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN

408: ( p_Line_Scredit_rec.salesrep_id <>
409: p_old_Line_Scredit_rec.salesrep_id OR
410: p_old_Line_Scredit_rec.salesrep_id IS NULL )
411: THEN
412: IF NOT OE_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: END IF;
415: END IF;
416:

Line 422: IF NOT OE_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN

418: ( p_Line_Scredit_rec.sales_credit_id <>
419: p_old_Line_Scredit_rec.sales_credit_id OR
420: p_old_Line_Scredit_rec.sales_credit_id IS NULL )
421: THEN
422: IF NOT OE_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: END IF;
425: END IF;
426:

Line 432: IF NOT OE_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN

428: ( p_Line_Scredit_rec.wh_update_date <>
429: p_old_Line_Scredit_rec.wh_update_date OR
430: p_old_Line_Scredit_rec.wh_update_date IS NULL )
431: THEN
432: IF NOT OE_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: END IF;
435: END IF;
436: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612

Line 437: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_Scredit.attributes ',1);

433: x_return_status := FND_API.G_RET_STS_ERROR;
434: END IF;
435: END IF;
436: if OE_GLOBALS.g_validate_desc_flex ='Y' then --bug 4343612
437: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Line_Scredit.attributes ',1);
438: IF (p_Line_Scredit_rec.attribute1 IS NOT NULL AND
439: ( p_Line_Scredit_rec.attribute1 <>
440: p_old_Line_Scredit_rec.attribute1 OR
441: p_old_Line_Scredit_rec.attribute1 IS NULL ))

Line 506: IF NOT OE_VALIDATE.Sales_Credits_Desc_Flex

502: THEN
503:
504:
505: oe_debug_pub.add('Before calling Line Sales_Credits_Desc_Flex',2);
506: IF NOT OE_VALIDATE.Sales_Credits_Desc_Flex
507: (p_context => p_Line_Scredit_rec.context
508: ,p_attribute1 => p_Line_Scredit_rec.attribute1
509: ,p_attribute2 => p_Line_Scredit_rec.attribute2
510: ,p_attribute3 => p_Line_Scredit_rec.attribute3

Line 531: p_line_scredit_rec.context := oe_validate.g_context;

527:
528: ELSE
529: IF p_line_scredit_rec.context IS NULL
530: OR p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN
531: p_line_scredit_rec.context := oe_validate.g_context;
532: END IF;
533:
534: IF p_line_scredit_rec.attribute1 IS NULL
535: OR p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 536: p_line_scredit_rec.attribute1 := oe_validate.g_attribute1;

532: END IF;
533:
534: IF p_line_scredit_rec.attribute1 IS NULL
535: OR p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
536: p_line_scredit_rec.attribute1 := oe_validate.g_attribute1;
537: END IF;
538:
539: IF p_line_scredit_rec.attribute2 IS NULL
540: OR p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 541: p_line_scredit_rec.attribute2 := oe_validate.g_attribute2;

537: END IF;
538:
539: IF p_line_scredit_rec.attribute2 IS NULL
540: OR p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
541: p_line_scredit_rec.attribute2 := oe_validate.g_attribute2;
542: END IF;
543:
544: IF p_line_scredit_rec.attribute3 IS NULL
545: OR p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 546: p_line_scredit_rec.attribute3 := oe_validate.g_attribute3;

542: END IF;
543:
544: IF p_line_scredit_rec.attribute3 IS NULL
545: OR p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
546: p_line_scredit_rec.attribute3 := oe_validate.g_attribute3;
547: END IF;
548:
549: IF p_line_scredit_rec.attribute4 IS NULL
550: OR p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 551: p_line_scredit_rec.attribute4 := oe_validate.g_attribute4;

547: END IF;
548:
549: IF p_line_scredit_rec.attribute4 IS NULL
550: OR p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
551: p_line_scredit_rec.attribute4 := oe_validate.g_attribute4;
552: END IF;
553:
554: IF p_line_scredit_rec.attribute5 IS NULL
555: OR p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 556: p_line_scredit_rec.attribute5 := oe_validate.g_attribute5;

552: END IF;
553:
554: IF p_line_scredit_rec.attribute5 IS NULL
555: OR p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
556: p_line_scredit_rec.attribute5 := oe_validate.g_attribute5;
557: END IF;
558:
559: IF p_line_scredit_rec.attribute6 IS NULL
560: OR p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 561: p_line_scredit_rec.attribute6 := oe_validate.g_attribute6;

557: END IF;
558:
559: IF p_line_scredit_rec.attribute6 IS NULL
560: OR p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
561: p_line_scredit_rec.attribute6 := oe_validate.g_attribute6;
562: END IF;
563:
564: IF p_line_scredit_rec.attribute7 IS NULL
565: OR p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 566: p_line_scredit_rec.attribute7 := oe_validate.g_attribute7;

562: END IF;
563:
564: IF p_line_scredit_rec.attribute7 IS NULL
565: OR p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
566: p_line_scredit_rec.attribute7 := oe_validate.g_attribute7;
567: END IF;
568:
569: IF p_line_scredit_rec.attribute8 IS NULL
570: OR p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 571: p_line_scredit_rec.attribute8 := oe_validate.g_attribute8;

567: END IF;
568:
569: IF p_line_scredit_rec.attribute8 IS NULL
570: OR p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
571: p_line_scredit_rec.attribute8 := oe_validate.g_attribute8;
572: END IF;
573:
574: IF p_line_scredit_rec.attribute9 IS NULL
575: OR p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 576: p_line_scredit_rec.attribute9 := oe_validate.g_attribute9;

572: END IF;
573:
574: IF p_line_scredit_rec.attribute9 IS NULL
575: OR p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
576: p_line_scredit_rec.attribute9 := oe_validate.g_attribute9;
577: END IF;
578:
579: IF p_line_scredit_rec.attribute10 IS NULL
580: OR p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 581: p_line_scredit_rec.attribute10 := oe_validate.g_attribute10;

577: END IF;
578:
579: IF p_line_scredit_rec.attribute10 IS NULL
580: OR p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
581: p_line_scredit_rec.attribute10 := oe_validate.g_attribute10;
582: END IF;
583:
584: IF p_line_scredit_rec.attribute11 IS NULL
585: OR p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 586: p_line_scredit_rec.attribute11 := oe_validate.g_attribute11;

582: END IF;
583:
584: IF p_line_scredit_rec.attribute11 IS NULL
585: OR p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
586: p_line_scredit_rec.attribute11 := oe_validate.g_attribute11;
587: END IF;
588:
589: IF p_line_scredit_rec.attribute12 IS NULL
590: OR p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 591: p_line_scredit_rec.attribute12 := oe_validate.g_attribute12;

587: END IF;
588:
589: IF p_line_scredit_rec.attribute12 IS NULL
590: OR p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
591: p_line_scredit_rec.attribute12 := oe_validate.g_attribute12;
592: END IF;
593:
594: IF p_line_scredit_rec.attribute13 IS NULL
595: OR p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 596: p_line_scredit_rec.attribute13 := oe_validate.g_attribute13;

592: END IF;
593:
594: IF p_line_scredit_rec.attribute13 IS NULL
595: OR p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
596: p_line_scredit_rec.attribute13 := oe_validate.g_attribute13;
597: END IF;
598:
599: IF p_line_scredit_rec.attribute14 IS NULL
600: OR p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 601: p_line_scredit_rec.attribute14 := oe_validate.g_attribute14;

597: END IF;
598:
599: IF p_line_scredit_rec.attribute14 IS NULL
600: OR p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
601: p_line_scredit_rec.attribute14 := oe_validate.g_attribute14;
602: END IF;
603:
604: IF p_line_scredit_rec.attribute15 IS NULL
605: OR p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 606: p_line_scredit_rec.attribute15 := oe_validate.g_attribute15;

602: END IF;
603:
604: IF p_line_scredit_rec.attribute15 IS NULL
605: OR p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
606: p_line_scredit_rec.attribute15 := oe_validate.g_attribute15;
607: END IF;
608:
609: /* End of the code added to fix the bug 3006018 */
610:

Line 616: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Attributes',1);

612: oe_debug_pub.add('After Line Sales_Credits_Desc_Flex ' || x_return_status,2);
613:
614: END IF;
615:
616: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Attributes',1);
617: -- Done validating attributes
618: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then bug 4343612*/
619: EXCEPTION
620:

Line 656: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);

652: BEGIN
653:
654: -- Validate entity delete.
655:
656: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);
657: NULL;
658: OE_Delayed_Requests_Pvt.Log_Request
659: (p_entity_code =>OE_GLOBALS.G_ENTITY_Line_Scredit
660: ,p_entity_id =>p_Line_Scredit_rec.sales_credit_id

Line 707: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);

703: END IF;
704:
705: -- Done.
706:
707: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);
708: x_return_status := l_return_status;
709:
710: EXCEPTION
711:

Line 734: END OE_Validate_Line_Scredit;

730: END IF;
731:
732: END Entity_Delete;
733:
734: END OE_Validate_Line_Scredit;