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

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

13: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
14: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_price_adj_error VARCHAR2(30):= NULL;
19: l_attribute_name VARCHAR2(50):= NULL;
20: l_tmp_string VARCHAR2(30):= NULL;
21: l_agr_type_code VARCHAR2(30):= NULL;

Line 36: l_return_status := FND_API.G_RET_STS_ERROR;

32:
33: IF p_Header_Adj_rec.price_adjustment_id IS NULL
34: THEN
35:
36: l_return_status := FND_API.G_RET_STS_ERROR;
37:
38: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
39: THEN
40:

Line 54: l_return_status := FND_API.G_RET_STS_ERROR;

50:
51: IF p_Header_Adj_rec.header_id IS NULL
52: THEN
53:
54: l_return_status := FND_API.G_RET_STS_ERROR;
55:
56: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58:

Line 73: l_return_status := FND_API.G_RET_STS_ERROR;

69: IF p_Header_adj_rec.list_header_id is null
70: and p_Header_adj_rec.list_line_type_code not in ('COST','TAX')
71: THEN
72:
73: l_return_status := FND_API.G_RET_STS_ERROR;
74:
75: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
76: THEN
77:

Line 90: l_return_status := FND_API.G_RET_STS_ERROR;

86:
87: IF p_Header_adj_rec.list_header_id is not null and
88: p_Header_adj_rec.list_line_id IS NULL THEN
89:
90: l_return_status := FND_API.G_RET_STS_ERROR;
91:
92: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94:

Line 106: l_return_status := FND_API.G_RET_STS_ERROR;

102:
103:
104: IF p_Header_adj_rec.list_line_type_code IS NULL THEN
105:
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110:

Line 127: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

123:
124:
125: -- Return Error if a required attribute is missing.
126:
127: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
128:
129: RAISE FND_API.G_EXC_ERROR;
130:
131: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 129: RAISE FND_API.G_EXC_ERROR;

125: -- Return Error if a required attribute is missing.
126:
127: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
128:
129: RAISE FND_API.G_EXC_ERROR;
130:
131: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
132:
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 131: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

127: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
128:
129: RAISE FND_API.G_EXC_ERROR;
130:
131: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
132:
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: END IF;

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: RAISE FND_API.G_EXC_ERROR;
130:
131: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
132:
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: END IF;
136:
137: --

Line 146: l_return_status := FND_API.G_RET_STS_ERROR;

142: /* IF upper(p_Header_adj_rec.updated_flag) ='Y' and
143: upper(p_Header_adj_rec.applied_flag) ='Y' and
144: p_Header_adj_rec.change_reason_code is null THEN
145:
146: l_return_status := FND_API.G_RET_STS_ERROR;
147:
148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
149: THEN
150:

Line 162: l_return_status := FND_API.G_RET_STS_ERROR;

158:
159: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
160: p_Header_adj_rec.charge_type_code IS NULL THEN
161:
162: l_return_status := FND_API.G_RET_STS_ERROR;
163:
164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
165: THEN
166:

Line 180: l_return_status := FND_API.G_RET_STS_ERROR;

176: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' AND
177: p_Header_adj_rec.adjusted_amount IS NULL
178: THEN
179:
180: l_return_status := FND_API.G_RET_STS_ERROR;
181:
182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
183: THEN
184:

Line 197: l_return_status := FND_API.G_RET_STS_ERROR;

193: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' AND
194: p_Header_adj_rec.operand IS NULL
195: THEN
196:
197: l_return_status := FND_API.G_RET_STS_ERROR;
198:
199: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
200: THEN
201:

Line 230: l_return_status := FND_API.G_RET_STS_ERROR;

226: IF p_Header_adj_rec.ac_attribute6 IS NULL THEN
227: l_attribute_name := 'AETC Reason Code';
228: END IF;
229: IF l_attribute_name IS NOT NULL THEN
230: l_return_status := FND_API.G_RET_STS_ERROR;
231:
232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
233: THEN
234:

Line 268: l_return_status := FND_API.G_RET_STS_ERROR;

264: AND ENABLED_FLAG = 'Y';
265: EXCEPTION
266:
267: WHEN NO_DATA_FOUND THEN
268: l_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
271: OE_Order_Util.Get_Attribute_Name('CHARGE_SUBTYPE_CODE'));
272: OE_MSG_PUB.Add;

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278: ( G_PKG_NAME ,
279: 'Record - Charge Type/Subtype validation'
280: );
281: END IF;
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END;
284: END IF;
285:
286: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and

Line 290: l_return_status := FND_API.G_RET_STS_ERROR;

286: IF p_Header_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
287: p_Header_adj_rec.arithmetic_operator <> 'LUMPSUM'
288: THEN
289:
290: l_return_status := FND_API.G_RET_STS_ERROR;
291:
292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
293: THEN
294:

Line 328: WHEN FND_API.G_EXC_ERROR THEN

324: oe_debug_pub.Add('Exiting OE_VALIDATE_HEADER_ADJ.Entity',1);
325:
326: EXCEPTION
327:
328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_ERROR;
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: EXCEPTION
327:
328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_ERROR;
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333:
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: x_return_status := FND_API.G_RET_STS_ERROR;
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333:
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335:
336: WHEN OTHERS THEN

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: x_return_status := FND_API.G_RET_STS_ERROR;
331:
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333:
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335:
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335:
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: OE_MSG_PUB.Add_Exc_Msg

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358: IS
359: BEGIN
360:
361: oe_debug_pub.Add('Entering OE_VALIDATE_HEADER_ADJ.Attributes',1);
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: -- Validate Header_Adj attributes
365:
366: IF p_Header_Adj_rec.price_adjustment_id IS NOT NULL AND

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: p_old_Header_Adj_rec.price_adjustment_id OR
369: p_old_Header_Adj_rec.price_adjustment_id IS NULL )
370: THEN
371: IF NOT oe_validate_adj.Price_Adjustment(p_Header_Adj_rec.price_adjustment_id) THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: END IF;
374: END IF;
375:
376: IF p_Header_Adj_rec.creation_date IS NOT NULL AND

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: p_old_Header_Adj_rec.creation_date OR
379: p_old_Header_Adj_rec.creation_date IS NULL )
380: THEN
381: IF NOT oe_validate_adj.Creation_Date(p_Header_Adj_rec.creation_date) THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: END IF;
384: END IF;
385: IF p_Header_Adj_rec.pricing_phase_id IS NOT NULL AND
386: ( p_Header_Adj_rec.pricing_phase_id <>

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: p_old_Header_Adj_rec.pricing_phase_id IS NULL )
389: THEN
390: IF NOT oe_validate_adj.Pricing_Phase_id(p_Header_Adj_rec.pricing_phase_id)
391: THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: END IF;
394: END IF;
395:
396:

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400: p_old_Header_Adj_rec.adjusted_amount IS NULL )
401: THEN
402: IF NOT oe_validate_adj.Adjusted_Amount(p_Header_Adj_rec.adjusted_amount)
403: THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: END IF;
406: END IF;
407:
408: IF p_Header_Adj_rec.created_by IS NOT NULL AND

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: p_old_Header_Adj_rec.created_by OR
411: p_old_Header_Adj_rec.created_by IS NULL )
412: THEN
413: IF NOT oe_validate_adj.Created_By(p_Header_Adj_rec.created_by) THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: END IF;
416: END IF;
417:
418: IF p_Header_Adj_rec.last_update_date IS NOT NULL AND

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

420: p_old_Header_Adj_rec.last_update_date OR
421: p_old_Header_Adj_rec.last_update_date IS NULL )
422: THEN
423: IF NOT oe_validate_adj.Last_Update_Date(p_Header_Adj_rec.last_update_date) THEN
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: END IF;
426: END IF;
427:
428: IF p_Header_Adj_rec.last_updated_by IS NOT NULL AND

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: p_old_Header_Adj_rec.last_updated_by OR
431: p_old_Header_Adj_rec.last_updated_by IS NULL )
432: THEN
433: IF NOT oe_validate_adj.Last_Updated_By(p_Header_Adj_rec.last_updated_by) THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: END IF;
436: END IF;
437:
438: IF p_Header_Adj_rec.last_update_login IS NOT NULL AND

Line 444: x_return_status := FND_API.G_RET_STS_ERROR;

440: p_old_Header_Adj_rec.last_update_login OR
441: p_old_Header_Adj_rec.last_update_login IS NULL )
442: THEN
443: IF NOT oe_validate_adj.Last_Update_Login(p_Header_Adj_rec.last_update_login) THEN
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: END IF;
446: END IF;
447:
448: IF p_Header_Adj_rec.program_application_id IS NOT NULL AND

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: p_old_Header_Adj_rec.program_application_id OR
451: p_old_Header_Adj_rec.program_application_id IS NULL )
452: THEN
453: IF NOT oe_validate_adj.Program_Application(p_Header_Adj_rec.program_application_id) THEN
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: END IF;
456: END IF;
457:
458: IF p_Header_Adj_rec.program_id IS NOT NULL AND

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

460: p_old_Header_Adj_rec.program_id OR
461: p_old_Header_Adj_rec.program_id IS NULL )
462: THEN
463: IF NOT oe_validate_adj.Program(p_Header_Adj_rec.program_id) THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: END IF;
466: END IF;
467:
468: IF p_Header_Adj_rec.program_update_date IS NOT NULL AND

Line 474: x_return_status := FND_API.G_RET_STS_ERROR;

470: p_old_Header_Adj_rec.program_update_date OR
471: p_old_Header_Adj_rec.program_update_date IS NULL )
472: THEN
473: IF NOT oe_validate_adj.Program_Update_Date(p_Header_Adj_rec.program_update_date) THEN
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: END IF;
476: END IF;
477:
478: IF p_Header_Adj_rec.request_id IS NOT NULL AND

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: p_old_Header_Adj_rec.request_id OR
481: p_old_Header_Adj_rec.request_id IS NULL )
482: THEN
483: IF NOT oe_validate_adj.Request(p_Header_Adj_rec.request_id) THEN
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: END IF;
486: END IF;
487:
488: IF p_Header_Adj_rec.header_id IS NOT NULL AND

Line 494: x_return_status := FND_API.G_RET_STS_ERROR;

490: p_old_Header_Adj_rec.header_id OR
491: p_old_Header_Adj_rec.header_id IS NULL )
492: THEN
493: IF NOT oe_validate_adj.Header(p_Header_Adj_rec.header_id) THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: END IF;
496: END IF;
497:
498: IF p_Header_Adj_rec.discount_id IS NOT NULL AND

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: p_old_Header_Adj_rec.discount_id OR
501: p_old_Header_Adj_rec.discount_id IS NULL )
502: THEN
503: IF NOT oe_validate_adj.Discount(p_Header_Adj_rec.discount_id) THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506: END IF;
507:
508: IF p_Header_Adj_rec.discount_line_id IS NOT NULL AND

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510: p_old_Header_Adj_rec.discount_line_id OR
511: p_old_Header_Adj_rec.discount_line_id IS NULL )
512: THEN
513: IF NOT oe_validate_adj.Discount_Line(p_Header_Adj_rec.discount_line_id) THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: END IF;
516: END IF;
517:
518: IF p_Header_Adj_rec.automatic_flag IS NOT NULL AND

Line 524: x_return_status := FND_API.G_RET_STS_ERROR;

520: p_old_Header_Adj_rec.automatic_flag OR
521: p_old_Header_Adj_rec.automatic_flag IS NULL )
522: THEN
523: IF NOT oe_validate_adj.Automatic(p_Header_Adj_rec.automatic_flag) THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526: END IF;
527:
528: IF p_Header_Adj_rec.percent IS NOT NULL AND

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: p_old_Header_Adj_rec.percent OR
531: p_old_Header_Adj_rec.percent IS NULL )
532: THEN
533: IF NOT oe_validate_adj.Percent(p_Header_Adj_rec.percent) THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: END IF;
536: END IF;
537:
538: IF p_Header_Adj_rec.line_id IS NOT NULL AND

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: p_old_Header_Adj_rec.line_id OR
541: p_old_Header_Adj_rec.line_id IS NULL )
542: THEN
543: IF NOT oe_validate_adj.Line(p_Header_Adj_rec.line_id) THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: END IF;
546: END IF;
547:
548: IF p_Header_Adj_rec.list_line_no IS NOT NULL AND

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: p_old_Header_Adj_rec.list_line_no OR
551: p_old_Header_Adj_rec.list_line_no IS NULL )
552: THEN
553: IF NOT oe_validate_adj.List_Line_No(p_Header_Adj_rec.list_line_no) THEN
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END IF;
556: END IF;
557:
558: IF p_Header_Adj_rec.source_system_code IS NOT NULL AND

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: p_old_Header_Adj_rec.source_system_code OR
561: p_old_Header_Adj_rec.source_system_code IS NULL )
562: THEN
563: IF NOT oe_validate_adj.source_system_code(p_Header_Adj_rec.source_system_code) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566: END IF;
567:
568: IF p_Header_Adj_rec.benefit_qty IS NOT NULL AND

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570: p_old_Header_Adj_rec.benefit_qty OR
571: p_old_Header_Adj_rec.benefit_qty IS NULL )
572: THEN
573: IF NOT oe_validate_adj.benefit_qty(p_Header_Adj_rec.benefit_qty) THEN
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: END IF;
576: END IF;
577:
578: IF p_Header_Adj_rec.benefit_uom_code IS NOT NULL AND

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

580: p_old_Header_Adj_rec.benefit_uom_code OR
581: p_old_Header_Adj_rec.benefit_uom_code IS NULL )
582: THEN
583: IF NOT oe_validate_adj.benefit_uom_code(p_Header_Adj_rec.benefit_uom_code) THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: END IF;
586: END IF;
587:
588: IF p_Header_Adj_rec.print_on_invoice_flag IS NOT NULL AND

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590: p_old_Header_Adj_rec.print_on_invoice_flag OR
591: p_old_Header_Adj_rec.print_on_invoice_flag IS NULL )
592: THEN
593: IF NOT oe_validate_adj.print_on_invoice_flag(p_Header_Adj_rec.print_on_invoice_flag) THEN
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: END IF;
596: END IF;
597:
598: IF p_Header_Adj_rec.expiration_date IS NOT NULL AND

Line 604: x_return_status := FND_API.G_RET_STS_ERROR;

600: p_old_Header_Adj_rec.expiration_date OR
601: p_old_Header_Adj_rec.expiration_date IS NULL )
602: THEN
603: IF NOT oe_validate_adj.expiration_date(p_Header_Adj_rec.expiration_date) THEN
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: END IF;
606: END IF;
607:
608: IF p_Header_Adj_rec.rebate_transaction_type_code IS NOT NULL AND

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: p_old_Header_Adj_rec.rebate_transaction_type_code OR
611: p_old_Header_Adj_rec.rebate_transaction_type_code IS NULL )
612: THEN
613: IF NOT oe_validate_adj.rebate_transaction_type_code(p_Header_Adj_rec.rebate_transaction_type_code) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF;
617:
618:

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: p_old_Header_Adj_rec.rebate_transaction_reference OR
622: p_old_Header_Adj_rec.rebate_transaction_reference IS NULL )
623: THEN
624: IF NOT oe_validate_adj.rebate_transaction_reference(p_Header_Adj_rec.rebate_transaction_reference) THEN
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF;
627: END IF;
628:
629: IF p_Header_Adj_rec.rebate_payment_system_code IS NOT NULL AND

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: p_old_Header_Adj_rec.rebate_payment_system_code OR
632: p_old_Header_Adj_rec.rebate_payment_system_code IS NULL )
633: THEN
634: IF NOT oe_validate_adj.rebate_payment_system_code(p_Header_Adj_rec.rebate_payment_system_code) THEN
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF;
637: END IF;
638:
639: IF p_Header_Adj_rec.Redeemed_Date IS NOT NULL AND

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641: p_old_Header_Adj_rec.Redeemed_Date OR
642: p_old_Header_Adj_rec.Redeemed_Date IS NULL )
643: THEN
644: IF NOT oe_validate_adj.Redeemed_Date(p_Header_Adj_rec.Redeemed_Date) THEN
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647: END IF;
648:
649: IF p_Header_Adj_rec.redeemed_flag IS NOT NULL AND

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: p_old_Header_Adj_rec.redeemed_flag OR
652: p_old_Header_Adj_rec.redeemed_flag IS NULL )
653: THEN
654: IF NOT oe_validate_adj.Redeemed_Flag(p_Header_Adj_rec.redeemed_flag) THEN
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: END IF;
657: END IF;
658:
659: IF p_Header_Adj_rec.accrual_flag IS NOT NULL AND

Line 665: x_return_status := FND_API.G_RET_STS_ERROR;

661: p_old_Header_Adj_rec.accrual_flag OR
662: p_old_Header_Adj_rec.accrual_flag IS NULL )
663: THEN
664: IF NOT oe_validate_adj.Accrual_Flag(p_Header_Adj_rec.accrual_flag) THEN
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: END IF;
667: END IF;
668:
669: IF p_Header_Adj_rec.credit_or_charge_flag IS NOT NULL AND

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: p_old_Header_Adj_rec.credit_or_charge_flag OR
672: p_old_Header_Adj_rec.credit_or_charge_flag IS NULL )
673: THEN
674: IF NOT OE_Validate.credit_or_charge_flag(p_Header_Adj_rec.credit_or_charge_flag) THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: END IF;
678:
679: IF p_Header_Adj_rec.charge_type_code IS NOT NULL AND

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: p_old_Header_Adj_rec.charge_type_code OR
682: p_old_Header_Adj_rec.charge_type_code IS NULL )
683: THEN
684: IF NOT OE_Validate.charge_type_code(p_Header_Adj_rec.charge_type_code) THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: END IF;
688:
689: IF p_Header_Adj_rec.charge_subtype_code IS NOT NULL AND

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: p_old_Header_Adj_rec.charge_subtype_code OR
692: p_old_Header_Adj_rec.charge_subtype_code IS NULL )
693: THEN
694: IF NOT OE_Validate.charge_subtype_code(p_Header_Adj_rec.charge_subtype_code) THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: END IF;
697: END IF;
698:
699: IF p_Header_Adj_rec.estimated_flag IS NOT NULL AND

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: p_old_Header_Adj_rec.estimated_flag OR
702: p_old_Header_Adj_rec.estimated_flag IS NULL )
703: THEN
704: IF NOT OE_Validate.estimated(p_Header_Adj_rec.estimated_flag) THEN
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END IF;
707: END IF;
708:
709: IF p_Header_Adj_rec.invoiced_flag IS NOT NULL AND

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: p_old_Header_Adj_rec.invoiced_flag OR
712: p_old_Header_Adj_rec.invoiced_flag IS NULL )
713: THEN
714: IF NOT OE_Validate.invoiced(p_Header_Adj_rec.invoiced_flag) THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: END IF;
717: END IF;
718:
719: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: ,p_attribute14 => p_Header_Adj_rec.attribute14
807: ,p_attribute15 => p_Header_Adj_rec.attribute15) THEN
808:
809:
810: x_return_status := FND_API.G_RET_STS_ERROR;
811:
812: oe_debug_pub.add('After Header Adjustment desc_flex ' || x_return_status,2);
813:
814: END IF;

Line 824: WHEN FND_API.G_EXC_ERROR THEN

820: end if ; /* if OE_GLOBALS.g_validate_desc_flex ='Y' then bug4343612*/
821:
822: EXCEPTION
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825:
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: EXCEPTION
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825:
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829:
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

824: WHEN FND_API.G_EXC_ERROR THEN
825:
826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829:
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

826: x_return_status := FND_API.G_RET_STS_ERROR;
827:
828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
829:
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN
833:
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831:
832: WHEN OTHERS THEN
833:
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: OE_MSG_PUB.Add_Exc_Msg

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

849: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
850: , p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
851: )
852: IS
853: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
854: BEGIN
855:
856: -- Validate entity delete.
857:

Line 866: WHEN FND_API.G_EXC_ERROR THEN

862: x_return_status := l_return_status;
863:
864: EXCEPTION
865:
866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: EXCEPTION
865:
866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: WHEN FND_API.G_EXC_ERROR THEN
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: WHEN OTHERS THEN

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: WHEN OTHERS THEN
875:
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: WHEN OTHERS THEN
875:
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg