DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE_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_LINE_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_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;

Line 79: oe_msg_pub.add;

75: IF l_percent_total = 0 THEN
76: l_line_no := OE_ORDER_MISC_PUB.Get_Concat_Line_Number(p_line_id);
77: FND_MESSAGE.SET_NAME('ONT','ONT_ZERO_PERCENT_LINE_CREDITS');
78: FND_MESSAGE.SET_TOKEN('LINE_NO',l_line_no);
79: oe_msg_pub.add;
80: --FP bug 3872166 end
81: ELSIF l_percent_total <> 100 THEN
82: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TTL_LINE_CREDIT');
83: FND_MESSAGE.SET_TOKEN('TOTAL',to_char(l_percent_total));

Line 84: oe_msg_pub.add;

80: --FP bug 3872166 end
81: ELSIF l_percent_total <> 100 THEN
82: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TTL_LINE_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: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Validate_LSC_QUOTA_TOTAL',1);
88: EXCEPTION

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

98: WHEN OTHERS THEN
99:
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101:
102: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: oe_msg_pub.add_Exc_Msg
105: ( G_PKG_NAME
106: , 'Validate_LSC_QUOTA_TOTAL'

Line 104: oe_msg_pub.add_Exc_Msg

100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101:
102: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: oe_msg_pub.add_Exc_Msg
105: ( G_PKG_NAME
106: , 'Validate_LSC_QUOTA_TOTAL'
107: );
108: END IF;

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

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)
136: THEN
137:
138: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_ID'));

Line 141: oe_msg_pub.add;

137:
138: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_ID'));
140:
141: oe_msg_pub.add;
142:
143: END IF;
144:
145: END IF;

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

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)
154: THEN
155: IF p_line_Scredit_rec.salesrep_id IS NULL THEN
156: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALESREP_ID'));

Line 158: oe_msg_pub.Add;

154: THEN
155: IF p_line_Scredit_rec.salesrep_id IS NULL THEN
156: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALESREP_ID'));
158: oe_msg_pub.Add;
159: END IF;
160:
161: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_TYPE_ID'));

Line 164: oe_msg_pub.add;

160:
161: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('SALES_CREDIT_TYPE_ID'));
163:
164: oe_msg_pub.add;
165:
166: END IF;
167:
168: END IF;

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

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)
179: THEN
180:
181: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('HEADER'));

Line 183: oe_msg_pub.add;

179: THEN
180:
181: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('HEADER'));
183: oe_msg_pub.add;
184:
185: END IF;
186:
187: END IF;

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

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)
196: THEN
197:
198: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('LINE'));

Line 200: oe_msg_pub.add;

196: THEN
197:
198: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('LINE'));
200: oe_msg_pub.add;
201:
202: END IF;
203:
204: END IF;

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

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)
214: THEN
215:
216: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
217: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('PERCENT'));

Line 218: oe_msg_pub.add;

214: THEN
215:
216: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
217: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('PERCENT'));
218: oe_msg_pub.add;
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

Line 226: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) 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');
229: oe_msg_pub.Add;
230: END IF;

Line 229: oe_msg_pub.Add;

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');
229: oe_msg_pub.Add;
230: END IF;
231:
232: l_return_status := FND_API.G_RET_STS_ERROR;
233: END IF;

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

284: WHEN OTHERS THEN
285:
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287:
288: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: oe_msg_pub.add_Exc_Msg
291: ( G_PKG_NAME
292: , 'Entity'

Line 290: oe_msg_pub.add_Exc_Msg

286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287:
288: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: oe_msg_pub.add_Exc_Msg
291: ( G_PKG_NAME
292: , 'Entity'
293: );
294: END IF;

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

629: WHEN OTHERS THEN
630:
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632:
633: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: oe_msg_pub.add_Exc_Msg
636: ( G_PKG_NAME
637: , 'Attributes'

Line 635: oe_msg_pub.add_Exc_Msg

631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632:
633: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: oe_msg_pub.add_Exc_Msg
636: ( G_PKG_NAME
637: , 'Attributes'
638: );
639: END IF;

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

720: WHEN OTHERS THEN
721:
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723:
724: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: oe_msg_pub.add_Exc_Msg
727: ( G_PKG_NAME
728: , 'Entity_Delete'

Line 726: oe_msg_pub.add_Exc_Msg

722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723:
724: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
725: THEN
726: oe_msg_pub.add_Exc_Msg
727: ( G_PKG_NAME
728: , 'Entity_Delete'
729: );
730: END IF;