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 FND_API

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
72: CLOSE C_LSC_Quota_Total;

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

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
89:

Line 90: WHEN FND_API.G_EXC_ERROR THEN

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:
92: x_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 92: x_return_status := FND_API.G_RET_STS_ERROR;

88: EXCEPTION
89:
90: WHEN FND_API.G_EXC_ERROR THEN
91:
92: x_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

90: WHEN FND_API.G_EXC_ERROR THEN
91:
92: x_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
98: WHEN OTHERS THEN

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: x_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
98: WHEN OTHERS THEN
99:
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
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

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

116: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
117: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
118: )
119: IS
120: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
121:
122: --bug 3275243
123: l_ar_decimal_limit CONSTANT NUMBER:=4;
124: BEGIN

Line 133: l_return_status := FND_API.G_RET_STS_ERROR;

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)
136: THEN
137:

Line 151: l_return_status := FND_API.G_RET_STS_ERROR;

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)
154: THEN
155: IF p_line_Scredit_rec.salesrep_id IS NULL THEN

Line 176: l_return_status := FND_API.G_RET_STS_ERROR;

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)
179: THEN
180:

Line 193: l_return_status := FND_API.G_RET_STS_ERROR;

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)
196: THEN
197:

Line 211: l_return_status := FND_API.G_RET_STS_ERROR;

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)
214: THEN
215:

Line 221: ElsIf p_line_Scredit_rec.PERCENT <> FND_API.G_MISS_NUM THEN

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
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:

Line 232: l_return_status := FND_API.G_RET_STS_ERROR;

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;
234: END IF;
235:
236:

Line 240: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

236:
237:
238: -- Return Error if a required attribute is missing.
239:
240: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
241:
242: RAISE FND_API.G_EXC_ERROR;
243:
244: END IF;

Line 242: RAISE FND_API.G_EXC_ERROR;

238: -- Return Error if a required attribute is missing.
239:
240: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
241:
242: RAISE FND_API.G_EXC_ERROR;
243:
244: END IF;
245:
246: --

Line 261: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 264: IF l_return_status = FND_API.G_RET_STS_ERROR 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
265: RAISE FND_API.G_EXC_ERROR;
266: end if;
267:
268:

Line 265: RAISE FND_API.G_EXC_ERROR;

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
265: RAISE FND_API.G_EXC_ERROR;
266: end if;
267:
268:
269: -- Done validating entity

Line 276: WHEN FND_API.G_EXC_ERROR THEN

272: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity',1);
273:
274: EXCEPTION
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: EXCEPTION
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281:
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

276: WHEN FND_API.G_EXC_ERROR THEN
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281:
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: WHEN OTHERS THEN

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281:
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: WHEN OTHERS THEN
285:
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
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

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
315:
316: IF p_Line_Scredit_rec.created_by IS NOT NULL AND

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: p_old_Line_Scredit_rec.created_by OR
319: p_old_Line_Scredit_rec.created_by IS NULL )
320: THEN
321: IF NOT OE_Validate.Created_By(p_Line_Scredit_rec.created_by) THEN
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: END IF;
324: END IF;
325:
326: IF p_Line_Scredit_rec.creation_date IS NOT NULL AND

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: p_old_Line_Scredit_rec.creation_date OR
329: p_old_Line_Scredit_rec.creation_date IS NULL )
330: THEN
331: IF NOT OE_Validate.Creation_Date(p_Line_Scredit_rec.creation_date) THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END IF;
334: END IF;
335:
336: IF p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL AND

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338: p_old_Line_Scredit_rec.dw_update_advice_flag OR
339: p_old_Line_Scredit_rec.dw_update_advice_flag IS NULL )
340: THEN
341: IF NOT OE_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: END IF;
344: END IF;
345:
346: IF p_Line_Scredit_rec.header_id IS NOT NULL AND

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348: p_old_Line_Scredit_rec.header_id OR
349: p_old_Line_Scredit_rec.header_id IS NULL )
350: THEN
351: IF NOT OE_Validate.Header(p_Line_Scredit_rec.header_id) THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: END IF;
354: END IF;
355:
356: IF p_Line_Scredit_rec.last_updated_by IS NOT NULL AND

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: p_old_Line_Scredit_rec.last_updated_by OR
359: p_old_Line_Scredit_rec.last_updated_by IS NULL )
360: THEN
361: IF NOT OE_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364: END IF;
365:
366: IF p_Line_Scredit_rec.last_update_date IS NOT NULL AND

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: p_old_Line_Scredit_rec.last_update_date OR
369: p_old_Line_Scredit_rec.last_update_date IS NULL )
370: THEN
371: IF NOT OE_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF;
375:
376: IF p_Line_Scredit_rec.last_update_login IS NOT NULL AND

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: p_old_Line_Scredit_rec.last_update_login OR
379: p_old_Line_Scredit_rec.last_update_login IS NULL )
380: THEN
381: IF NOT OE_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: END IF;
384: END IF;
385:
386: IF p_Line_Scredit_rec.line_id IS NOT NULL AND

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: p_old_Line_Scredit_rec.line_id OR
389: p_old_Line_Scredit_rec.line_id IS NULL )
390: THEN
391: IF NOT OE_Validate.Line(p_Line_Scredit_rec.line_id) THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: END IF;
394: END IF;
395:
396: IF p_Line_Scredit_rec.percent IS NOT NULL AND

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398: p_old_Line_Scredit_rec.percent OR
399: p_old_Line_Scredit_rec.percent IS NULL )
400: THEN
401: IF NOT OE_Validate.Percent(p_Line_Scredit_rec.percent) THEN
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: END IF;
404: END IF;
405:
406:

Line 413: x_return_status := FND_API.G_RET_STS_ERROR;

409: p_old_Line_Scredit_rec.salesrep_id OR
410: p_old_Line_Scredit_rec.salesrep_id IS NULL )
411: THEN
412: IF NOT OE_Validate.Salesrep(p_Line_Scredit_rec.salesrep_id) THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: END IF;
415: END IF;
416:
417: IF p_Line_Scredit_rec.sales_credit_id IS NOT NULL AND

Line 423: x_return_status := FND_API.G_RET_STS_ERROR;

419: p_old_Line_Scredit_rec.sales_credit_id OR
420: p_old_Line_Scredit_rec.sales_credit_id IS NULL )
421: THEN
422: IF NOT OE_Validate.Sales_Credit(p_Line_Scredit_rec.sales_credit_id) THEN
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: END IF;
425: END IF;
426:
427: IF p_Line_Scredit_rec.wh_update_date IS NOT NULL AND

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: p_old_Line_Scredit_rec.wh_update_date OR
430: p_old_Line_Scredit_rec.wh_update_date IS NULL )
431: THEN
432: IF NOT OE_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
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);

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: ,p_attribute13 => p_Line_Scredit_rec.attribute13
521: ,p_attribute14 => p_Line_Scredit_rec.attribute14
522: ,p_attribute15 => p_Line_Scredit_rec.attribute15) THEN
523:
524: x_return_status := FND_API.G_RET_STS_ERROR;
525:
526: /* Added the following code to fix the bug 3006018 */
527:
528: ELSE

Line 530: OR p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN

526: /* Added the following code to fix the bug 3006018 */
527:
528: ELSE
529: IF p_line_scredit_rec.context IS NULL
530: OR p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN
531: p_line_scredit_rec.context := oe_validate.g_context;
532: END IF;
533:
534: IF p_line_scredit_rec.attribute1 IS NULL

Line 535: OR p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN

531: p_line_scredit_rec.context := oe_validate.g_context;
532: END IF;
533:
534: IF p_line_scredit_rec.attribute1 IS NULL
535: OR p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
536: p_line_scredit_rec.attribute1 := oe_validate.g_attribute1;
537: END IF;
538:
539: IF p_line_scredit_rec.attribute2 IS NULL

Line 540: OR p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN

536: p_line_scredit_rec.attribute1 := oe_validate.g_attribute1;
537: END IF;
538:
539: IF p_line_scredit_rec.attribute2 IS NULL
540: OR p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
541: p_line_scredit_rec.attribute2 := oe_validate.g_attribute2;
542: END IF;
543:
544: IF p_line_scredit_rec.attribute3 IS NULL

Line 545: OR p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN

541: p_line_scredit_rec.attribute2 := oe_validate.g_attribute2;
542: END IF;
543:
544: IF p_line_scredit_rec.attribute3 IS NULL
545: OR p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
546: p_line_scredit_rec.attribute3 := oe_validate.g_attribute3;
547: END IF;
548:
549: IF p_line_scredit_rec.attribute4 IS NULL

Line 550: OR p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN

546: p_line_scredit_rec.attribute3 := oe_validate.g_attribute3;
547: END IF;
548:
549: IF p_line_scredit_rec.attribute4 IS NULL
550: OR p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
551: p_line_scredit_rec.attribute4 := oe_validate.g_attribute4;
552: END IF;
553:
554: IF p_line_scredit_rec.attribute5 IS NULL

Line 555: OR p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN

551: p_line_scredit_rec.attribute4 := oe_validate.g_attribute4;
552: END IF;
553:
554: IF p_line_scredit_rec.attribute5 IS NULL
555: OR p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
556: p_line_scredit_rec.attribute5 := oe_validate.g_attribute5;
557: END IF;
558:
559: IF p_line_scredit_rec.attribute6 IS NULL

Line 560: OR p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN

556: p_line_scredit_rec.attribute5 := oe_validate.g_attribute5;
557: END IF;
558:
559: IF p_line_scredit_rec.attribute6 IS NULL
560: OR p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
561: p_line_scredit_rec.attribute6 := oe_validate.g_attribute6;
562: END IF;
563:
564: IF p_line_scredit_rec.attribute7 IS NULL

Line 565: OR p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN

561: p_line_scredit_rec.attribute6 := oe_validate.g_attribute6;
562: END IF;
563:
564: IF p_line_scredit_rec.attribute7 IS NULL
565: OR p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
566: p_line_scredit_rec.attribute7 := oe_validate.g_attribute7;
567: END IF;
568:
569: IF p_line_scredit_rec.attribute8 IS NULL

Line 570: OR p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN

566: p_line_scredit_rec.attribute7 := oe_validate.g_attribute7;
567: END IF;
568:
569: IF p_line_scredit_rec.attribute8 IS NULL
570: OR p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
571: p_line_scredit_rec.attribute8 := oe_validate.g_attribute8;
572: END IF;
573:
574: IF p_line_scredit_rec.attribute9 IS NULL

Line 575: OR p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN

571: p_line_scredit_rec.attribute8 := oe_validate.g_attribute8;
572: END IF;
573:
574: IF p_line_scredit_rec.attribute9 IS NULL
575: OR p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
576: p_line_scredit_rec.attribute9 := oe_validate.g_attribute9;
577: END IF;
578:
579: IF p_line_scredit_rec.attribute10 IS NULL

Line 580: OR p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN

576: p_line_scredit_rec.attribute9 := oe_validate.g_attribute9;
577: END IF;
578:
579: IF p_line_scredit_rec.attribute10 IS NULL
580: OR p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
581: p_line_scredit_rec.attribute10 := oe_validate.g_attribute10;
582: END IF;
583:
584: IF p_line_scredit_rec.attribute11 IS NULL

Line 585: OR p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN

581: p_line_scredit_rec.attribute10 := oe_validate.g_attribute10;
582: END IF;
583:
584: IF p_line_scredit_rec.attribute11 IS NULL
585: OR p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
586: p_line_scredit_rec.attribute11 := oe_validate.g_attribute11;
587: END IF;
588:
589: IF p_line_scredit_rec.attribute12 IS NULL

Line 590: OR p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN

586: p_line_scredit_rec.attribute11 := oe_validate.g_attribute11;
587: END IF;
588:
589: IF p_line_scredit_rec.attribute12 IS NULL
590: OR p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
591: p_line_scredit_rec.attribute12 := oe_validate.g_attribute12;
592: END IF;
593:
594: IF p_line_scredit_rec.attribute13 IS NULL

Line 595: OR p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN

591: p_line_scredit_rec.attribute12 := oe_validate.g_attribute12;
592: END IF;
593:
594: IF p_line_scredit_rec.attribute13 IS NULL
595: OR p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
596: p_line_scredit_rec.attribute13 := oe_validate.g_attribute13;
597: END IF;
598:
599: IF p_line_scredit_rec.attribute14 IS NULL

Line 600: OR p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN

596: p_line_scredit_rec.attribute13 := oe_validate.g_attribute13;
597: END IF;
598:
599: IF p_line_scredit_rec.attribute14 IS NULL
600: OR p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
601: p_line_scredit_rec.attribute14 := oe_validate.g_attribute14;
602: END IF;
603:
604: IF p_line_scredit_rec.attribute15 IS NULL

Line 605: OR p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN

601: p_line_scredit_rec.attribute14 := oe_validate.g_attribute14;
602: END IF;
603:
604: IF p_line_scredit_rec.attribute15 IS NULL
605: OR p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
606: p_line_scredit_rec.attribute15 := oe_validate.g_attribute15;
607: END IF;
608:
609: /* End of the code added to fix the bug 3006018 */

Line 621: WHEN FND_API.G_EXC_ERROR THEN

617: -- Done validating attributes
618: end if ; /*if OE_GLOBALS.g_validate_desc_flex ='Y' then bug 4343612*/
619: EXCEPTION
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622:
623: x_return_status := FND_API.G_RET_STS_ERROR;
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 623: x_return_status := FND_API.G_RET_STS_ERROR;

619: EXCEPTION
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622:
623: x_return_status := FND_API.G_RET_STS_ERROR;
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626:
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

621: WHEN FND_API.G_EXC_ERROR THEN
622:
623: x_return_status := FND_API.G_RET_STS_ERROR;
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626:
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628:
629: WHEN OTHERS THEN

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: x_return_status := FND_API.G_RET_STS_ERROR;
624:
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626:
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628:
629: WHEN OTHERS THEN
630:
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628:
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

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

646: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
647: , p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
648: )
649: IS
650: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
651: l_request_rec OE_Order_PUB.request_rec_type;
652: BEGIN
653:
654: -- Validate entity delete.

Line 667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

663: ,p_request_type =>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
664: ,p_param1 => to_char(p_Line_Scredit_rec.Line_id)
665: ,x_return_status =>l_return_status);
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: ,p_param1 => to_char(p_Line_Scredit_rec.Line_id)
665: ,x_return_status =>l_return_status);
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:

Line 669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

665: ,x_return_status =>l_return_status);
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673:

Line 670: RAISE FND_API.G_EXC_ERROR;

666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673:
674: -- Adding service sales credit delayed request

Line 699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

695: ,p_request_rec =>l_request_rec);
696:
697: END IF;
698:
699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;

Line 700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

696:
697: END IF;
698:
699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:

Line 701: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

697: END IF;
698:
699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
705: -- Done.

Line 702: RAISE FND_API.G_EXC_ERROR;

698:
699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
705: -- Done.
706:

Line 712: WHEN FND_API.G_EXC_ERROR THEN

708: x_return_status := l_return_status;
709:
710: EXCEPTION
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713:
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710: EXCEPTION
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713:
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717:
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

712: WHEN FND_API.G_EXC_ERROR THEN
713:
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717:
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719:
720: WHEN OTHERS THEN

Line 718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717:
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719:
720: WHEN OTHERS THEN
721:
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719:
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