DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER_SCREDIT dependencies on OE_DEBUG_PUB

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 212: oe_debug_pub.add(' Header id:'||p_header_scredit_rec.header_id);

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');
216: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PERCENT');

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 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 521: oe_debug_pub.add('Before calling Sales_Credits_Desc_Flex',2);

517: p_old_Header_Scredit_rec.context IS NULL ))
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

Line 628: oe_debug_pub.add('After Sales_Credits_Desc_Flex ' || x_return_status,2);

624:
625: /* End of the code added to fix the bug 3006018 */
626: END IF;
627:
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);

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: