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

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

64:
65: , p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
66: )
67: IS
68: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
69: --
70: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
71: --
72: BEGIN

Line 82: l_return_status := FND_API.G_RET_STS_ERROR;

78:
79: /* IF p_Header_Scredit_rec.sales_credit_id IS NULL
80: THEN
81:
82: l_return_status := FND_API.G_RET_STS_ERROR;
83:
84: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
85: THEN
86:

Line 102: l_return_status := FND_API.G_RET_STS_ERROR;

98:
99: IF p_Header_Scredit_rec.HEADER_ID IS NULL
100: THEN
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
105: THEN
106:

Line 119: l_return_status := FND_API.G_RET_STS_ERROR;

115:
116: IF p_Header_Scredit_rec.PERCENT IS NULL
117: THEN
118:
119: l_return_status := FND_API.G_RET_STS_ERROR;
120:
121: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
122: THEN
123:

Line 135: l_return_status := FND_API.G_RET_STS_ERROR;

131:
132: IF p_Header_Scredit_rec.sales_credit_type_id IS NULL
133: THEN
134:
135: l_return_status := FND_API.G_RET_STS_ERROR;
136:
137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
138: THEN
139:

Line 151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

147:
148:
149: -- Return Error if a required attribute is missing.
150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152:
153: RAISE FND_API.G_EXC_ERROR;
154:
155: END IF;

Line 153: RAISE FND_API.G_EXC_ERROR;

149: -- Return Error if a required attribute is missing.
150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152:
153: RAISE FND_API.G_EXC_ERROR;
154:
155: END IF;
156:
157: --

Line 172: l_return_status := FND_API.G_RET_STS_ERROR;

168: ,p_sales_credit_type_id=>p_Header_Scredit_rec.sales_credit_type_id
169: ,p_header_id=>p_Header_Scredit_rec.header_id
170: ,p_sales_credit_id=>p_Header_Scredit_rec.sales_credit_id)
171: THEN
172: l_return_status := FND_API.G_RET_STS_ERROR;
173: END IF;
174:
175:
176: -- Done validating entity

Line 185: WHEN FND_API.G_EXC_ERROR THEN

181: oe_debug_pub.add( 'EXITING OE_CNCL_VAL_HEADER_SCREDITS.ENTITY' , 1 ) ;
182: END IF;
183: EXCEPTION
184:
185: WHEN FND_API.G_EXC_ERROR THEN
186:
187: x_return_status := FND_API.G_RET_STS_ERROR;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: EXCEPTION
184:
185: WHEN FND_API.G_EXC_ERROR THEN
186:
187: x_return_status := FND_API.G_RET_STS_ERROR;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: WHEN FND_API.G_EXC_ERROR THEN
186:
187: x_return_status := FND_API.G_RET_STS_ERROR;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192:
193: WHEN OTHERS THEN

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: x_return_status := FND_API.G_RET_STS_ERROR;
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190:
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192:
193: WHEN OTHERS THEN
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192:
193: WHEN OTHERS THEN
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: oe_msg_pub.Add_Exc_Msg

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219:
220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add( 'ENTERING OE_CNCL_VAL_HEADER_SCREDITS.ATTRIBUTES' , 1 ) ;
222: END IF;
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: -- Validate Header_Scredit attributes
226:
227: IF p_Header_Scredit_rec.created_by IS NOT NULL

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269:
270: IF p_Header_Scredit_rec.last_update_login IS NOT NULL
271: THEN
272: IF NOT OE_CNCL_Validate.Last_Update_Login(p_Header_Scredit_rec.last_update_login) THEN
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: END IF;
275: END IF;
276:
277: IF p_Header_Scredit_rec.line_id IS NOT NULL

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276:
277: IF p_Header_Scredit_rec.line_id IS NOT NULL
278: THEN
279: IF NOT OE_CNCL_Validate.Line(p_Header_Scredit_rec.line_id) THEN
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: END IF;
282: END IF;
283:
284: IF p_Header_Scredit_rec.percent IS NOT NULL

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283:
284: IF p_Header_Scredit_rec.percent IS NOT NULL
285: THEN
286: IF NOT OE_CNCL_Validate.Percent(p_Header_Scredit_rec.percent) THEN
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: END IF;
289: END IF;
290:
291:

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291:
292: IF p_Header_Scredit_rec.salesrep_id IS NOT NULL
293: THEN
294: IF NOT OE_CNCL_Validate.Salesrep(p_Header_Scredit_rec.salesrep_id) THEN
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: END IF;
297: END IF;
298:
299: IF p_Header_Scredit_rec.sales_credit_type_id IS NOT NULL

Line 302: x_return_status := FND_API.G_RET_STS_ERROR;

298:
299: IF p_Header_Scredit_rec.sales_credit_type_id IS NOT NULL
300: THEN
301: IF NOT OE_CNCL_Validate.sales_credit_type(p_Header_Scredit_rec.sales_credit_type_id) THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: END IF;
304: END IF;
305:
306: /* IF p_Header_Scredit_rec.sales_credit_id IS NOT NULL

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305:
306: /* IF p_Header_Scredit_rec.sales_credit_id IS NOT NULL
307: THEN
308: IF NOT OE_CNCL_Validate.Sales_Credit(p_Header_Scredit_rec.sales_credit_id) THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: END IF;
311: END IF;
312: */
313:

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313:
314: IF p_Header_Scredit_rec.wh_update_date IS NOT NULL
315: THEN
316: IF NOT OE_CNCL_Validate.Wh_Update_Date(p_Header_Scredit_rec.wh_update_date) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
319: END IF;
320:
321: IF p_Header_Scredit_rec.attribute1 IS NOT NULL

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: ,p_attribute13 => p_Header_Scredit_rec.attribute13
358: ,p_attribute14 => p_Header_Scredit_rec.attribute14
359: ,p_attribute15 => p_Header_Scredit_rec.attribute15) THEN
360:
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: END IF;
363:
364: IF l_debug_level > 0 THEN
365: oe_debug_pub.add( 'AFTER SALES_CREDITS_DESC_FLEX ' || X_RETURN_STATUS , 2 ) ;

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: -- Done validating attributes
376:
377: EXCEPTION
378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377: EXCEPTION
378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: WHEN OTHERS THEN

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384:
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: WHEN OTHERS THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386:
387: WHEN OTHERS THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: oe_msg_pub.Add_Exc_Msg