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_CNCL_VALIDATE_LINE_SCREDIT dependencies on FND_API

Line 58: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

54: , p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
55: )
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.

Line 68: l_return_status := FND_API.G_RET_STS_ERROR;

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)
71: THEN
72:

Line 86: l_return_status := FND_API.G_RET_STS_ERROR;

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)
89: THEN
90:

Line 105: l_return_status := FND_API.G_RET_STS_ERROR;

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)
108: THEN
109:

Line 122: l_return_status := FND_API.G_RET_STS_ERROR;

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)
125: THEN
126:

Line 140: l_return_status := FND_API.G_RET_STS_ERROR;

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)
143: THEN
144:

Line 157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

153:
154:
155: -- Return Error if a required attribute is missing.
156:
157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
158:
159: RAISE FND_API.G_EXC_ERROR;
160:
161: END IF;

Line 159: RAISE FND_API.G_EXC_ERROR;

155: -- Return Error if a required attribute is missing.
156:
157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
158:
159: RAISE FND_API.G_EXC_ERROR;
160:
161: END IF;
162:
163: --

Line 178: l_return_status := FND_API.G_RET_STS_ERROR;

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
182: RAISE FND_API.G_EXC_ERROR;

Line 181: IF l_return_status = FND_API.G_RET_STS_ERROR 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
182: RAISE FND_API.G_EXC_ERROR;
183: end if;
184:
185:

Line 182: RAISE FND_API.G_EXC_ERROR;

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
182: RAISE FND_API.G_EXC_ERROR;
183: end if;
184:
185:
186: -- Done validating entity

Line 193: WHEN FND_API.G_EXC_ERROR THEN

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
194:
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: EXCEPTION
192:
193: WHEN FND_API.G_EXC_ERROR THEN
194:
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

193: WHEN FND_API.G_EXC_ERROR THEN
194:
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: WHEN OTHERS THEN

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: WHEN OTHERS THEN
202:
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200:
201: WHEN OTHERS THEN
202:
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204:
205: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: oe_msg_pub.add_Exc_Msg

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
228:
229: IF p_Line_Scredit_rec.created_by IS NOT NULL

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228:
229: IF p_Line_Scredit_rec.created_by IS NOT NULL
230: THEN
231: IF NOT OE_CNCL_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: END IF;
234: END IF;
235:
236: IF p_Line_Scredit_rec.creation_date IS NOT NULL

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235:
236: IF p_Line_Scredit_rec.creation_date IS NOT NULL
237: THEN
238: IF NOT OE_CNCL_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: END IF;
241: END IF;
242:
243: IF p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242:
243: IF p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL
244: THEN
245: IF NOT OE_CNCL_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: END IF;
248: END IF;
249:
250: /* IF p_Line_Scredit_rec.header_id IS NOT NULL

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249:
250: /* IF p_Line_Scredit_rec.header_id IS NOT NULL
251: THEN
252: IF NOT OE_CNCL_Validate.Header(p_Line_Scredit_rec.header_id) THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: END IF;
255: END IF;
256: */
257:

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257:
258: IF p_Line_Scredit_rec.last_updated_by IS NOT NULL
259: THEN
260: IF NOT OE_CNCL_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263: END IF;
264:
265: IF p_Line_Scredit_rec.last_update_date IS NOT NULL

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264:
265: IF p_Line_Scredit_rec.last_update_date IS NOT NULL
266: THEN
267: IF NOT OE_CNCL_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: END IF;
270: END IF;
271:
272: IF p_Line_Scredit_rec.last_update_login IS NOT NULL

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271:
272: IF p_Line_Scredit_rec.last_update_login IS NOT NULL
273: THEN
274: IF NOT OE_CNCL_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: END IF;
277: END IF;
278:
279: /* IF p_Line_Scredit_rec.line_id IS NOT NULL

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278:
279: /* IF p_Line_Scredit_rec.line_id IS NOT NULL
280: THEN
281: IF NOT OE_CNCL_Validate.Line(p_Line_Scredit_rec.line_id) THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: END IF;
284: END IF;
285: */
286: IF p_Line_Scredit_rec.percent IS NOT NULL

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: */
286: IF p_Line_Scredit_rec.percent IS NOT NULL
287: THEN
288: IF NOT OE_CNCL_Validate.Percent(p_Line_Scredit_rec.percent) THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: END IF;
292:
293:

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293:
294: IF p_Line_Scredit_rec.salesrep_id IS NOT NULL
295: THEN
296: IF NOT OE_CNCL_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: END IF;
299: END IF;
300:
301: /* IF p_Line_Scredit_rec.sales_credit_id IS NOT NULL

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300:
301: /* IF p_Line_Scredit_rec.sales_credit_id IS NOT NULL
302: THEN
303: IF NOT OE_CNCL_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END IF;
306: END IF;
307: */
308:

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308:
309: IF p_Line_Scredit_rec.wh_update_date IS NOT NULL
310: THEN
311: IF NOT OE_CNCL_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: END IF;
314: END IF;
315:
316: IF p_Line_Scredit_rec.attribute1 IS NOT NULL

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: ,p_attribute13 => p_Line_Scredit_rec.attribute13
352: ,p_attribute14 => p_Line_Scredit_rec.attribute14
353: ,p_attribute15 => p_Line_Scredit_rec.attribute15) THEN
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:

Line 367: WHEN FND_API.G_EXC_ERROR THEN

363: -- Done validating attributes
364:
365: EXCEPTION
366:
367: WHEN FND_API.G_EXC_ERROR THEN
368:
369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

365: EXCEPTION
366:
367: WHEN FND_API.G_EXC_ERROR THEN
368:
369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

367: WHEN FND_API.G_EXC_ERROR THEN
368:
369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374:
375: WHEN OTHERS THEN

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

369: x_return_status := FND_API.G_RET_STS_ERROR;
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372:
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374:
375: WHEN OTHERS THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374:
375: WHEN OTHERS THEN
376:
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: oe_msg_pub.add_Exc_Msg