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_DEBUG_PUB

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

127: -- Check required attributes.
128:
129: IF p_Line_Scredit_rec.sales_credit_id IS NULL
130: THEN
131: oe_debug_pub.add('Validate Entity - 1',1);
132:
133: l_return_status := FND_API.G_RET_STS_ERROR;
134:
135: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

145: END IF;
146:
147: IF p_Line_Scredit_rec.sales_credit_type_id IS NULL
148: THEN
149: oe_debug_pub.add('Validate Entity - 1',1);
150:
151: l_return_status := FND_API.G_RET_STS_ERROR;
152:
153: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

170: -- Check rest of required attributes here.
171: --
172: IF p_line_Scredit_rec.HEADER_ID IS NULL
173: THEN
174: oe_debug_pub.add('Validate Entity - 2',1);
175:
176: l_return_status := FND_API.G_RET_STS_ERROR;
177:
178: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

187: END IF;
188:
189: IF p_line_Scredit_rec.line_id IS NULL
190: THEN
191: oe_debug_pub.add('Validate Entity - 3',1);
192:
193: l_return_status := FND_API.G_RET_STS_ERROR;
194:
195: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

205:
206:
207: IF p_line_Scredit_rec.PERCENT IS NULL
208: THEN
209: oe_debug_pub.add('Validate Entity - 5',1);
210:
211: l_return_status := FND_API.G_RET_STS_ERROR;
212:
213: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

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

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

256: ,p_sales_credit_type_id=>p_Line_Scredit_rec.sales_credit_type_id
257: ,p_line_id=>p_Line_Scredit_rec.line_id
258: ,p_sales_credit_id=>p_Line_Scredit_rec.sales_credit_id)
259: THEN
260: oe_debug_pub.add('Validate Entity - 6',1);
261: l_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263:
264: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

501: p_old_Line_Scredit_rec.context IS NULL ))
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

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

608:
609: /* End of the code added to fix the bug 3006018 */
610:
611: END IF;
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);

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: