APPS.OE_CNCL_VALIDATE_LINE_SCREDIT dependencies on OE_CNCL_VALIDATE_LINE_SCREDIT

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 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;