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

Line 1: PACKAGE BODY OE_Validate_Header_Scredit AS

1: PACKAGE BODY OE_Validate_Header_Scredit AS
2: /* $Header: OEXLHSCB.pls 120.2 2007/12/18 09:15:01 vybhatia ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXLHSCB.pls 120.2 2007/12/18 09:15:01 vybhatia ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_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_Header_Scredits.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_Header_Scredits.Duplicate_salescredit',1);
27: open C_Dup_Salescredit(p_salesrep_id
28: ,p_sales_credit_type_id
29: ,p_header_id
30: ,p_sales_credit_id);

Line 41: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Duplicate_salescredit',1);

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

Line 44: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Duplicate_salescredit',1);

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

Line 68: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Validate_HSC_QUOTA_TOTAL',1);

64: AND sct.quota_flag = 'Y';
65: -- l_orcl_customization Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_ACTIVATE_ORACLE_CUSTOMIZATION'),'N');
66: l_booked_flag Varchar2(15);
67: BEGIN
68: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Validate_HSC_QUOTA_TOTAL',1);
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --Order import or it is not oracle specific customization than validate 100% when saving
72: --Do not enforce 100% when saving for Oracle customization. enforce 100% only when booking

Line 117: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Validate_HSC_QUOTA_TOTAL',1);

113: null;
114: End;
115: End If;*/
116:
117: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Validate_HSC_QUOTA_TOTAL',1);
118: EXCEPTION
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121:

Line 156: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Entity',1);

152: --bug 3275243
153: l_ar_decimal_limit CONSTANT NUMBER:=4;
154: BEGIN
155:
156: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Entity',1);
157: -- Check required attributes.
158:
159: IF p_Header_Scredit_rec.sales_credit_id IS NULL
160: THEN

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

207:
208: END IF;
209: ElsIf p_Header_Scredit_rec.PERCENT <> FND_API.G_MISS_NUM THEN
210: IF length(p_header_scredit_rec.percent- trunc(p_Header_Scredit_rec.PERCENT))- 1 > l_ar_decimal_limit THEN
211: oe_debug_pub.add('In OE_Validate_Header_Scredit.entity:Error:percentage more than 4, AR allowes max 4');
212: oe_debug_pub.add(' Header id:'||p_header_scredit_rec.header_id);
213:
214: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
215: FND_MESSAGE.SET_NAME('ONT','ONT_PERCENTAGE_FORMAT');

Line 279: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Entity',1);

275: -- Done validating entity
276:
277: x_return_status := l_return_status;
278:
279: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Entity',1);
280: EXCEPTION
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283:

Line 317: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Attributes',1);

313: )
314: IS
315: BEGIN
316:
317: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Attributes',1);
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: -- Validate Header_Scredit attributes
321:

Line 327: IF NOT OE_Validate.Created_By(p_Header_Scredit_rec.created_by) THEN

323: ( p_Header_Scredit_rec.created_by <>
324: p_old_Header_Scredit_rec.created_by OR
325: p_old_Header_Scredit_rec.created_by IS NULL )
326: THEN
327: IF NOT OE_Validate.Created_By(p_Header_Scredit_rec.created_by) THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: END IF;
330: END IF;
331:

Line 337: IF NOT OE_Validate.Creation_Date(p_Header_Scredit_rec.creation_date) THEN

333: ( p_Header_Scredit_rec.creation_date <>
334: p_old_Header_Scredit_rec.creation_date OR
335: p_old_Header_Scredit_rec.creation_date IS NULL )
336: THEN
337: IF NOT OE_Validate.Creation_Date(p_Header_Scredit_rec.creation_date) THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: END IF;
340: END IF;
341:

Line 347: IF NOT OE_Validate.Dw_Update_Advice(p_Header_Scredit_rec.dw_update_advice_flag) THEN

343: ( p_Header_Scredit_rec.dw_update_advice_flag <>
344: p_old_Header_Scredit_rec.dw_update_advice_flag OR
345: p_old_Header_Scredit_rec.dw_update_advice_flag IS NULL )
346: THEN
347: IF NOT OE_Validate.Dw_Update_Advice(p_Header_Scredit_rec.dw_update_advice_flag) THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: END IF;
350: END IF;
351:

Line 357: IF NOT OE_Validate.Header(p_Header_Scredit_rec.header_id) THEN

353: ( p_Header_Scredit_rec.header_id <>
354: p_old_Header_Scredit_rec.header_id OR
355: p_old_Header_Scredit_rec.header_id IS NULL )
356: THEN
357: IF NOT OE_Validate.Header(p_Header_Scredit_rec.header_id) THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: END IF;
360: END IF;
361:

Line 367: IF NOT OE_Validate.Last_Updated_By(p_Header_Scredit_rec.last_updated_by) THEN

363: ( p_Header_Scredit_rec.last_updated_by <>
364: p_old_Header_Scredit_rec.last_updated_by OR
365: p_old_Header_Scredit_rec.last_updated_by IS NULL )
366: THEN
367: IF NOT OE_Validate.Last_Updated_By(p_Header_Scredit_rec.last_updated_by) THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: END IF;
370: END IF;
371:

Line 377: IF NOT OE_Validate.Last_Update_Date(p_Header_Scredit_rec.last_update_date) THEN

373: ( p_Header_Scredit_rec.last_update_date <>
374: p_old_Header_Scredit_rec.last_update_date OR
375: p_old_Header_Scredit_rec.last_update_date IS NULL )
376: THEN
377: IF NOT OE_Validate.Last_Update_Date(p_Header_Scredit_rec.last_update_date) THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380: END IF;
381:

Line 387: IF NOT OE_Validate.Last_Update_Login(p_Header_Scredit_rec.last_update_login) THEN

383: ( p_Header_Scredit_rec.last_update_login <>
384: p_old_Header_Scredit_rec.last_update_login OR
385: p_old_Header_Scredit_rec.last_update_login IS NULL )
386: THEN
387: IF NOT OE_Validate.Last_Update_Login(p_Header_Scredit_rec.last_update_login) THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: END IF;
390: END IF;
391:

Line 397: IF NOT OE_Validate.Line(p_Header_Scredit_rec.line_id) THEN

393: ( p_Header_Scredit_rec.line_id <>
394: p_old_Header_Scredit_rec.line_id OR
395: p_old_Header_Scredit_rec.line_id IS NULL )
396: THEN
397: IF NOT OE_Validate.Line(p_Header_Scredit_rec.line_id) THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: END IF;
400: END IF;
401:

Line 407: IF NOT OE_Validate.Percent(p_Header_Scredit_rec.percent) THEN

403: ( p_Header_Scredit_rec.percent <>
404: p_old_Header_Scredit_rec.percent OR
405: p_old_Header_Scredit_rec.percent IS NULL )
406: THEN
407: IF NOT OE_Validate.Percent(p_Header_Scredit_rec.percent) THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: END IF;
410: END IF;
411:

Line 418: IF NOT OE_Validate.Salesrep(p_Header_Scredit_rec.salesrep_id) THEN

414: ( p_Header_Scredit_rec.salesrep_id <>
415: p_old_Header_Scredit_rec.salesrep_id OR
416: p_old_Header_Scredit_rec.salesrep_id IS NULL )
417: THEN
418: IF NOT OE_Validate.Salesrep(p_Header_Scredit_rec.salesrep_id) THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: END IF;
421: END IF;
422:

Line 428: IF NOT OE_Validate.sales_credit_type(p_Header_Scredit_rec.sales_credit_type_id) THEN

424: ( p_Header_Scredit_rec.sales_credit_type_id <>
425: p_old_Header_Scredit_rec.sales_credit_type_id OR
426: p_old_Header_Scredit_rec.sales_credit_type_id IS NULL )
427: THEN
428: IF NOT OE_Validate.sales_credit_type(p_Header_Scredit_rec.sales_credit_type_id) THEN
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: END IF;
431: END IF;
432:

Line 438: IF NOT OE_Validate.Sales_Credit(p_Header_Scredit_rec.sales_credit_id) THEN

434: ( p_Header_Scredit_rec.sales_credit_id <>
435: p_old_Header_Scredit_rec.sales_credit_id OR
436: p_old_Header_Scredit_rec.sales_credit_id IS NULL )
437: THEN
438: IF NOT OE_Validate.Sales_Credit(p_Header_Scredit_rec.sales_credit_id) THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END IF;
441: END IF;
442:

Line 448: IF NOT OE_Validate.Wh_Update_Date(p_Header_Scredit_rec.wh_update_date) THEN

444: ( p_Header_Scredit_rec.wh_update_date <>
445: p_old_Header_Scredit_rec.wh_update_date OR
446: p_old_Header_Scredit_rec.wh_update_date IS NULL )
447: THEN
448: IF NOT OE_Validate.Wh_Update_Date(p_Header_Scredit_rec.wh_update_date) THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: END IF;
451: END IF;
452: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612

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

449: x_return_status := FND_API.G_RET_STS_ERROR;
450: END IF;
451: END IF;
452: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
453: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Scredit.attributes ',1);
454: IF (p_Header_Scredit_rec.attribute1 IS NOT NULL AND
455: ( p_Header_Scredit_rec.attribute1 <>
456: p_old_Header_Scredit_rec.attribute1 OR
457: p_old_Header_Scredit_rec.attribute1 IS NULL ))

Line 522: IF NOT OE_VALIDATE.Sales_Credits_Desc_Flex

518: THEN
519:
520:
521: oe_debug_pub.add('Before calling Sales_Credits_Desc_Flex',2);
522: IF NOT OE_VALIDATE.Sales_Credits_Desc_Flex
523: (p_context => p_Header_Scredit_rec.context
524: ,p_attribute1 => p_Header_Scredit_rec.attribute1
525: ,p_attribute2 => p_Header_Scredit_rec.attribute2
526: ,p_attribute3 => p_Header_Scredit_rec.attribute3

Line 547: p_header_scredit_rec.context := oe_validate.g_context;

543:
544: ELSE
545: IF p_header_scredit_rec.context IS NULL
546: OR p_header_scredit_rec.context = FND_API.G_MISS_CHAR THEN
547: p_header_scredit_rec.context := oe_validate.g_context;
548: END IF;
549:
550: IF p_header_scredit_rec.attribute1 IS NULL
551: OR p_header_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 552: p_header_scredit_rec.attribute1 := oe_validate.g_attribute1;

548: END IF;
549:
550: IF p_header_scredit_rec.attribute1 IS NULL
551: OR p_header_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
552: p_header_scredit_rec.attribute1 := oe_validate.g_attribute1;
553: END IF;
554:
555: IF p_header_scredit_rec.attribute2 IS NULL
556: OR p_header_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 557: p_header_scredit_rec.attribute2 := oe_validate.g_attribute2;

553: END IF;
554:
555: IF p_header_scredit_rec.attribute2 IS NULL
556: OR p_header_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
557: p_header_scredit_rec.attribute2 := oe_validate.g_attribute2;
558: END IF;
559:
560: IF p_header_scredit_rec.attribute3 IS NULL
561: OR p_header_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 562: p_header_scredit_rec.attribute3 := oe_validate.g_attribute3;

558: END IF;
559:
560: IF p_header_scredit_rec.attribute3 IS NULL
561: OR p_header_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
562: p_header_scredit_rec.attribute3 := oe_validate.g_attribute3;
563: END IF;
564:
565: IF p_header_scredit_rec.attribute4 IS NULL
566: OR p_header_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 567: p_header_scredit_rec.attribute4 := oe_validate.g_attribute4;

563: END IF;
564:
565: IF p_header_scredit_rec.attribute4 IS NULL
566: OR p_header_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
567: p_header_scredit_rec.attribute4 := oe_validate.g_attribute4;
568: END IF;
569:
570: IF p_header_scredit_rec.attribute5 IS NULL
571: OR p_header_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 572: p_header_scredit_rec.attribute5 := oe_validate.g_attribute5;

568: END IF;
569:
570: IF p_header_scredit_rec.attribute5 IS NULL
571: OR p_header_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
572: p_header_scredit_rec.attribute5 := oe_validate.g_attribute5;
573: END IF;
574:
575: IF p_header_scredit_rec.attribute6 IS NULL
576: OR p_header_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 577: p_header_scredit_rec.attribute6 := oe_validate.g_attribute6;

573: END IF;
574:
575: IF p_header_scredit_rec.attribute6 IS NULL
576: OR p_header_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
577: p_header_scredit_rec.attribute6 := oe_validate.g_attribute6;
578: END IF;
579:
580: IF p_header_scredit_rec.attribute7 IS NULL
581: OR p_header_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 582: p_header_scredit_rec.attribute7 := oe_validate.g_attribute7;

578: END IF;
579:
580: IF p_header_scredit_rec.attribute7 IS NULL
581: OR p_header_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
582: p_header_scredit_rec.attribute7 := oe_validate.g_attribute7;
583: END IF;
584:
585: IF p_header_scredit_rec.attribute8 IS NULL
586: OR p_header_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 587: p_header_scredit_rec.attribute8 := oe_validate.g_attribute8;

583: END IF;
584:
585: IF p_header_scredit_rec.attribute8 IS NULL
586: OR p_header_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
587: p_header_scredit_rec.attribute8 := oe_validate.g_attribute8;
588: END IF;
589:
590: IF p_header_scredit_rec.attribute9 IS NULL
591: OR p_header_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 592: p_header_scredit_rec.attribute9 := oe_validate.g_attribute9;

588: END IF;
589:
590: IF p_header_scredit_rec.attribute9 IS NULL
591: OR p_header_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
592: p_header_scredit_rec.attribute9 := oe_validate.g_attribute9;
593: END IF;
594:
595: IF p_header_scredit_rec.attribute10 IS NULL
596: OR p_header_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 597: p_header_scredit_rec.attribute10 := oe_validate.g_attribute10;

593: END IF;
594:
595: IF p_header_scredit_rec.attribute10 IS NULL
596: OR p_header_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
597: p_header_scredit_rec.attribute10 := oe_validate.g_attribute10;
598: END IF;
599:
600: IF p_header_scredit_rec.attribute11 IS NULL
601: OR p_header_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 602: p_header_scredit_rec.attribute11 := oe_validate.g_attribute11;

598: END IF;
599:
600: IF p_header_scredit_rec.attribute11 IS NULL
601: OR p_header_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
602: p_header_scredit_rec.attribute11 := oe_validate.g_attribute11;
603: END IF;
604:
605: IF p_header_scredit_rec.attribute12 IS NULL
606: OR p_header_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 607: p_header_scredit_rec.attribute12 := oe_validate.g_attribute12;

603: END IF;
604:
605: IF p_header_scredit_rec.attribute12 IS NULL
606: OR p_header_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
607: p_header_scredit_rec.attribute12 := oe_validate.g_attribute12;
608: END IF;
609:
610: IF p_header_scredit_rec.attribute13 IS NULL
611: OR p_header_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 612: p_header_scredit_rec.attribute13 := oe_validate.g_attribute13;

608: END IF;
609:
610: IF p_header_scredit_rec.attribute13 IS NULL
611: OR p_header_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
612: p_header_scredit_rec.attribute13 := oe_validate.g_attribute13;
613: END IF;
614:
615: IF p_header_scredit_rec.attribute14 IS NULL
616: OR p_header_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 617: p_header_scredit_rec.attribute14 := oe_validate.g_attribute14;

613: END IF;
614:
615: IF p_header_scredit_rec.attribute14 IS NULL
616: OR p_header_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
617: p_header_scredit_rec.attribute14 := oe_validate.g_attribute14;
618: END IF;
619:
620: IF p_header_scredit_rec.attribute15 IS NULL
621: OR p_header_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 622: p_header_scredit_rec.attribute15 := oe_validate.g_attribute15;

618: END IF;
619:
620: IF p_header_scredit_rec.attribute15 IS NULL
621: OR p_header_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
622: p_header_scredit_rec.attribute15 := oe_validate.g_attribute15;
623: END IF;
624:
625: /* End of the code added to fix the bug 3006018 */
626: END IF;

Line 632: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Attributes',1);

628: oe_debug_pub.add('After Sales_Credits_Desc_Flex ' || x_return_status,2);
629:
630: END IF;
631: end if; /* OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612*/
632: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Attributes',1);
633: -- Done validating attributes
634:
635: EXCEPTION
636:

Line 669: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Entity_Delete',1);

665: IS
666: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
667: BEGIN
668:
669: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Entity_Delete',1);
670: -- Validate entity delete.
671:
672: /* Modified the following request to fix the bug 5746190 */
673:

Line 693: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Entity_Delete',1);

689:
690: -- Done.
691:
692: x_return_status := l_return_status;
693: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Entity_Delete',1);
694:
695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN

Line 736: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Validate_HSC_TOTAL_FOR_BK',1);

732: And line_id is null
733: And sct.quota_flag = 'Y';
734:
735: BEGIN
736: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Header_Scredits.Validate_HSC_TOTAL_FOR_BK',1);
737: x_return_status := FND_API.G_RET_STS_SUCCESS;
738:
739: Open C_HSC_Quota_Total(p_header_id);
740: Fetch C_HSC_Quota_Total

Line 751: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Validate_HSC_TOTAL_FOR_BK',1);

747: oe_msg_pub.Add;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: END IF;
750:
751: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Header_Scredits.Validate_HSC_TOTAL_FOR_BK',1);
752: EXCEPTION
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755:

Line 776: END OE_Validate_Header_Scredit;

772: END IF;
773: END Validate_HSC_TOTAL_FOR_BK;
774:
775:
776: END OE_Validate_Header_Scredit;