DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE_SCREDIT dependencies on OE_DEBUG_PUB

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 66: oe_debug_pub.add('Validate Entity - 1',1);

62: -- Check required attributes.
63:
64: /* IF p_Line_Scredit_rec.sales_credit_id IS NULL
65: THEN
66: oe_debug_pub.add('Validate Entity - 1',1);
67:
68: l_return_status := FND_API.G_RET_STS_ERROR;
69:
70: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 84: oe_debug_pub.add('Validate Entity - 1',1);

80: */
81:
82: IF p_Line_Scredit_rec.sales_credit_type_id IS NULL
83: THEN
84: oe_debug_pub.add('Validate Entity - 1',1);
85:
86: l_return_status := FND_API.G_RET_STS_ERROR;
87:
88: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 103: oe_debug_pub.add('Validate Entity - 2',1);

99: -- Check rest of required attributes here.
100: --
101: /* IF p_line_Scredit_rec.HEADER_ID IS NULL
102: THEN
103: oe_debug_pub.add('Validate Entity - 2',1);
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 120: oe_debug_pub.add('Validate Entity - 3',1);

116: END IF;
117:
118: IF p_line_Scredit_rec.line_id IS NULL
119: THEN
120: oe_debug_pub.add('Validate Entity - 3',1);
121:
122: l_return_status := FND_API.G_RET_STS_ERROR;
123:
124: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 138: oe_debug_pub.add('Validate Entity - 5',1);

134: */
135:
136: IF p_line_Scredit_rec.PERCENT IS NULL
137: THEN
138: oe_debug_pub.add('Validate Entity - 5',1);
139:
140: l_return_status := FND_API.G_RET_STS_ERROR;
141:
142: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 177: oe_debug_pub.add('Validate Entity - 6',1);

173: ,p_sales_credit_type_id=>p_Line_Scredit_rec.sales_credit_type_id
174: ,p_line_id=>p_Line_Scredit_rec.line_id
175: ,p_sales_credit_id=>p_Line_Scredit_rec.sales_credit_id)
176: THEN
177: oe_debug_pub.add('Validate Entity - 6',1);
178: l_return_status := FND_API.G_RET_STS_ERROR;
179: END IF;
180:
181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

332: OR p_Line_Scredit_rec.context IS NOT NULL
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

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

354:
355: x_return_status := FND_API.G_RET_STS_ERROR;
356:
357: END IF;
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);

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: