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_MSG_PUB

Line 34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

30: ,p_sales_credit_id);
31: fetch C_Dup_Salescredit into l_dummy;
32: close C_Dup_Salescredit;
33: IF l_dummy = 'DUPLICATE' THEN
34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
35: THEN
36:
37: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_ORDER_CREDIT');
38: oe_msg_pub.Add;

Line 38: oe_msg_pub.Add;

34: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
35: THEN
36:
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;

Line 84: OE_MSG_PUB.Add;

80:
81: IF l_percent_total <> 100 THEN
82: fnd_message.set_name('ONT','OE_VAL_ORDER_CREDIT');
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:
88: --End If;

Line 107: OE_MSG_PUB.Add;

103:
104: IF l_percent_total <> 100 THEN
105: fnd_message.set_name('ONT','OE_VAL_ORDER_CREDIT');
106: FND_MESSAGE.SET_TOKEN('TOTAL',to_char(l_percent_total));
107: OE_MSG_PUB.Add;
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: END IF;
110:
111: End If;

Line 132: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

128: WHEN OTHERS THEN
129:
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:
132: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: oe_msg_pub.Add_Exc_Msg
135: ( G_PKG_NAME
136: , 'Validate_HSC_QUOTA_TOTAL'

Line 134: oe_msg_pub.Add_Exc_Msg

130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:
132: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: oe_msg_pub.Add_Exc_Msg
135: ( G_PKG_NAME
136: , 'Validate_HSC_QUOTA_TOTAL'
137: );
138: END IF;

Line 164: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

160: THEN
161:
162: l_return_status := FND_API.G_RET_STS_ERROR;
163:
164: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
165: THEN
166:
167: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_ID'));

Line 169: oe_msg_pub.Add;

165: THEN
166:
167: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_ID'));
169: oe_msg_pub.Add;
170:
171: END IF;
172:
173: END IF;

Line 184: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

180: THEN
181:
182: l_return_status := FND_API.G_RET_STS_ERROR;
183:
184: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
185: THEN
186:
187: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');

Line 189: oe_msg_pub.Add;

185: THEN
186:
187: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','HEADER');
189: oe_msg_pub.Add;
190:
191: END IF;
192:
193: END IF;

Line 201: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

197: THEN
198:
199: l_return_status := FND_API.G_RET_STS_ERROR;
200:
201: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
202: THEN
203:
204: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('PERCENT'));

Line 206: oe_msg_pub.Add;

202: THEN
203:
204: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('PERCENT'));
206: oe_msg_pub.Add;
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

Line 214: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) 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');
217: oe_msg_pub.Add;
218: END IF;

Line 217: oe_msg_pub.Add;

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');
217: oe_msg_pub.Add;
218: END IF;
219:
220: l_return_status := FND_API.G_RET_STS_ERROR;
221: END IF;

Line 231: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

227: THEN
228:
229: l_return_status := FND_API.G_RET_STS_ERROR;
230:
231: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
232: THEN
233: IF p_Header_Scredit_rec.salesrep_id IS NULL THEN
234: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
235: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALESREP_ID'));

Line 236: oe_msg_pub.Add;

232: THEN
233: IF p_Header_Scredit_rec.salesrep_id IS NULL THEN
234: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
235: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALESREP_ID'));
236: oe_msg_pub.Add;
237: END IF;
238:
239: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_TYPE_ID'));

Line 241: oe_msg_pub.Add;

237: END IF;
238:
239: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_TYPE_ID'));
241: oe_msg_pub.Add;
242:
243: END IF;
244:
245: END IF;

Line 294: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

290: WHEN OTHERS THEN
291:
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293:
294: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: oe_msg_pub.Add_Exc_Msg
297: ( G_PKG_NAME
298: , 'Entity'

Line 296: oe_msg_pub.Add_Exc_Msg

292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293:
294: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: oe_msg_pub.Add_Exc_Msg
297: ( G_PKG_NAME
298: , 'Entity'
299: );
300: END IF;

Line 649: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

645: WHEN OTHERS THEN
646:
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: oe_msg_pub.Add_Exc_Msg
652: ( G_PKG_NAME
653: , 'Attributes'

Line 651: oe_msg_pub.Add_Exc_Msg

647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648:
649: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: oe_msg_pub.Add_Exc_Msg
652: ( G_PKG_NAME
653: , 'Attributes'
654: );
655: END IF;

Line 709: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

705: WHEN OTHERS THEN
706:
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708:
709: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: oe_msg_pub.Add_Exc_Msg
712: ( G_PKG_NAME
713: , 'Entity_Delete'

Line 711: oe_msg_pub.Add_Exc_Msg

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708:
709: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: oe_msg_pub.Add_Exc_Msg
712: ( G_PKG_NAME
713: , 'Entity_Delete'
714: );
715: END IF;

Line 747: oe_msg_pub.Add;

743:
744: IF nvl(l_percent_total,0) <> 100 THEN
745: FND_MESSAGE.SET_NAME('ONT','OE_VAL_ORDER_CREDIT');
746: FND_MESSAGE.SET_TOKEN('TOTAL',to_char(l_percent_total));
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);

Line 766: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

762: WHEN OTHERS THEN
763:
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765:
766: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: oe_msg_pub.Add_Exc_Msg
769: ( G_PKG_NAME
770: , 'Validate_HSC_QUOTA_TOTAL_FOR_BK'

Line 768: oe_msg_pub.Add_Exc_Msg

764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765:
766: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: oe_msg_pub.Add_Exc_Msg
769: ( G_PKG_NAME
770: , 'Validate_HSC_QUOTA_TOTAL_FOR_BK'
771: );
772: END IF;