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

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

12: ( x_return_status OUT NOCOPY VARCHAR2 /* file.sql.39 change */
13: , p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
14: )
15: IS
16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: l_price_adj_error VARCHAR2(30):= NULL;
18: l_tmp_string VARCHAR2(30):= NULL;
19: l_agr_type_code VARCHAR2(30):= NULL;
20: l_attribute_name VARCHAR2(50):= NULL;

Line 34: l_return_status := FND_API.G_RET_STS_ERROR;

30:
31: /* IF p_Line_Adj_rec.price_adjustment_id IS NULL
32: THEN
33:
34: l_return_status := FND_API.G_RET_STS_ERROR;
35:
36: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
37: THEN
38:

Line 52: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 71: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 87: l_return_status := FND_API.G_RET_STS_ERROR;

83:
84: IF p_Line_adj_rec.list_header_id is not null and
85: p_Line_adj_rec.list_line_id IS NULL THEN
86:
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91:

Line 104: l_return_status := FND_API.G_RET_STS_ERROR;

100:
101: IF p_Line_adj_rec.list_header_id is not null and
102: p_Line_adj_rec.list_line_type_code IS NULL THEN
103:
104: l_return_status := FND_API.G_RET_STS_ERROR;
105:
106: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
107: THEN
108:

Line 121: l_return_status := FND_API.G_RET_STS_ERROR;

117: IF p_Line_adj_rec.list_line_type_code in ('COST','TAX')
118: --and p_Line_adj_rec.line_id is null
119: THEN
120:
121: l_return_status := FND_API.G_RET_STS_ERROR;
122:
123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
124: THEN
125:

Line 141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

137: --
138:
139: -- Return Error if a required attribute is missing.
140:
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142:
143: RAISE FND_API.G_EXC_ERROR;
144:
145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 143: RAISE FND_API.G_EXC_ERROR;

139: -- Return Error if a required attribute is missing.
140:
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142:
143: RAISE FND_API.G_EXC_ERROR;
144:
145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146:
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142:
143: RAISE FND_API.G_EXC_ERROR;
144:
145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146:
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148:
149: END IF;

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: RAISE FND_API.G_EXC_ERROR;
144:
145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146:
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148:
149: END IF;
150:
151:

Line 177: l_return_status := FND_API.G_RET_STS_ERROR;

173: IF p_Line_adj_rec.ac_attribute6 IS NULL THEN
174: l_attribute_name := 'AETC Reason Code';
175: END IF;
176: IF l_attribute_name IS NOT NULL THEN
177: l_return_status := FND_API.G_RET_STS_ERROR;
178:
179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
180: THEN
181:

Line 195: l_return_status := FND_API.G_RET_STS_ERROR;

191:
192: IF upper(p_Line_adj_rec.updated_flag) ='Y' and
193: p_Line_adj_rec.change_reason_code is null THEN
194:
195: l_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199:

Line 211: l_return_status := FND_API.G_RET_STS_ERROR;

207:
208: IF p_Line_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
209: p_Line_adj_rec.charge_type_code IS NULL THEN
210:
211: l_return_status := FND_API.G_RET_STS_ERROR;
212:
213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
214: THEN
215:

Line 228: l_return_status := FND_API.G_RET_STS_ERROR;

224:
225: IF p_Line_adj_rec.list_line_type_code = 'TAX' and
226: p_Line_adj_rec.tax_code IS NULL THEN
227:
228: l_return_status := FND_API.G_RET_STS_ERROR;
229:
230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
231: THEN
232:

Line 245: l_return_status := FND_API.G_RET_STS_ERROR;

241:
242: IF p_Line_adj_rec.list_line_type_code = 'COST' and
243: p_Line_adj_rec.cost_id IS NULL THEN
244:
245: l_return_status := FND_API.G_RET_STS_ERROR;
246:
247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
248: THEN
249:

Line 263: l_return_status := FND_API.G_RET_STS_ERROR;

259: IF p_Line_adj_rec.list_line_type_code in ('COST','TAX','FREIGHT_CHARGE') AND
260: p_Line_adj_rec.adjusted_amount IS NULL
261: THEN
262:
263: l_return_status := FND_API.G_RET_STS_ERROR;
264:
265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
266: THEN
267:

Line 280: l_return_status := FND_API.G_RET_STS_ERROR;

276: IF p_Line_adj_rec.list_line_type_code in ('TAX','FREIGHT_CHARGE') AND
277: p_Line_adj_rec.operand IS NULL
278: THEN
279:
280: l_return_status := FND_API.G_RET_STS_ERROR;
281:
282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
283: THEN
284:

Line 450: l_return_status := FND_API.G_RET_STS_ERROR;

446:
447: IF l_price_adj_error = 'IMP_DISCOUNT'
448: THEN
449:
450: l_return_status := FND_API.G_RET_STS_ERROR;
451:
452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454:

Line 460: RAISE FND_API.G_EXC_ERROR;

456: OE_MSG_PUB.Add;
457:
458: END IF;
459:
460: RAISE FND_API.G_EXC_ERROR;
461:
462: END IF;
463: */
464:

Line 491: l_return_status := FND_API.G_RET_STS_ERROR;

487: AND ROWNUM =1;
488: EXCEPTION
489:
490: WHEN NO_DATA_FOUND THEN
491: l_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
494: OE_Order_Util.Get_Attribute_Name('CHARGE_SUBTYPE_CODE'));
495: OE_MSG_PUB.Add;

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501: ( G_PKG_NAME ,
502: 'Record - Charge Type/Subtype validation'
503: );
504: END IF;
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END;
507: END IF;
508:
509: IF (p_Line_adj_rec.list_line_type_code in ('COST','TAX')and

Line 515: l_return_status := FND_API.G_RET_STS_ERROR;

511: (p_Line_adj_rec.list_line_type_code = 'FREIGHT_CHARGE' and
512: p_Line_adj_rec.arithmetic_operator NOT IN ('AMT','LUMPSUM','%'))
513: THEN
514:
515: l_return_status := FND_API.G_RET_STS_ERROR;
516:
517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
518: THEN
519:

Line 550: WHEN FND_API.G_EXC_ERROR THEN

546: x_return_status := l_return_status;
547:
548: EXCEPTION
549:
550: WHEN FND_API.G_EXC_ERROR THEN
551:
552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: EXCEPTION
549:
550: WHEN FND_API.G_EXC_ERROR THEN
551:
552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555:
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

550: WHEN FND_API.G_EXC_ERROR THEN
551:
552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555:
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557:
558: WHEN OTHERS THEN

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555:
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557:
558: WHEN OTHERS THEN
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557:
558: WHEN OTHERS THEN
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561:
562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: OE_MSG_PUB.Add_Exc_Msg

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: )
578: IS
579: BEGIN
580: oe_debug_pub.add('Entering OE_CNCL_Validate_Line_Adjs');
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: -- Validate Line_Adj attributes
584:
585: /* IF p_Line_Adj_rec.price_adjustment_id IS NOT NULL

Line 588: x_return_status := FND_API.G_RET_STS_ERROR;

584:
585: /* IF p_Line_Adj_rec.price_adjustment_id IS NOT NULL
586: THEN
587: IF NOT OE_CNCL_Validate_Adj.Price_Adjustment(p_Line_Adj_rec.price_adjustment_id) THEN
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: END IF;
590: END IF;
591: */
592:

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592:
593: IF p_Line_Adj_rec.creation_date IS NOT NULL
594: THEN
595: IF NOT OE_CNCL_Validate_Adj.Creation_Date(p_Line_Adj_rec.creation_date) THEN
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: END IF;
598: END IF;
599:
600: IF p_Line_Adj_rec.created_by IS NOT NULL

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599:
600: IF p_Line_Adj_rec.created_by IS NOT NULL
601: THEN
602: IF NOT OE_CNCL_Validate_Adj.Created_By(p_Line_Adj_rec.created_by) THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: END IF;
605: END IF;
606:
607: IF p_Line_Adj_rec.last_update_date IS NOT NULL

Line 610: x_return_status := FND_API.G_RET_STS_ERROR;

606:
607: IF p_Line_Adj_rec.last_update_date IS NOT NULL
608: THEN
609: IF NOT OE_CNCL_Validate_Adj.Last_Update_Date(p_Line_Adj_rec.last_update_date) THEN
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: END IF;
612: END IF;
613:
614: IF p_Line_Adj_rec.last_updated_by IS NOT NULL

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613:
614: IF p_Line_Adj_rec.last_updated_by IS NOT NULL
615: THEN
616: IF NOT OE_CNCL_Validate_Adj.Last_Updated_By(p_Line_Adj_rec.last_updated_by) THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619: END IF;
620:
621: IF p_Line_Adj_rec.last_update_login IS NOT NULL

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620:
621: IF p_Line_Adj_rec.last_update_login IS NOT NULL
622: THEN
623: IF NOT OE_CNCL_Validate_Adj.Last_Update_Login(p_Line_Adj_rec.last_update_login) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626: END IF;
627:
628: IF p_Line_Adj_rec.program_application_id IS NOT NULL

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627:
628: IF p_Line_Adj_rec.program_application_id IS NOT NULL
629: THEN
630: IF NOT OE_CNCL_Validate_Adj.Program_Application(p_Line_Adj_rec.program_application_id) THEN
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: END IF;
633: END IF;
634:
635: IF p_Line_Adj_rec.program_id IS NOT NULL

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634:
635: IF p_Line_Adj_rec.program_id IS NOT NULL
636: THEN
637: IF NOT OE_CNCL_Validate_Adj.Program(p_Line_Adj_rec.program_id) THEN
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640: END IF;
641:
642: IF p_Line_Adj_rec.program_update_date IS NOT NULL

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641:
642: IF p_Line_Adj_rec.program_update_date IS NOT NULL
643: THEN
644: IF NOT OE_CNCL_Validate_Adj.Program_Update_Date(p_Line_Adj_rec.program_update_date) THEN
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647: END IF;
648:
649: IF p_Line_Adj_rec.request_id IS NOT NULL

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648:
649: IF p_Line_Adj_rec.request_id IS NOT NULL
650: THEN
651: IF NOT OE_CNCL_Validate_Adj.Request(p_Line_Adj_rec.request_id) THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: END IF;
654: END IF;
655:
656: /* IF p_Line_Adj_rec.header_id IS NOT NULL

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655:
656: /* IF p_Line_Adj_rec.header_id IS NOT NULL
657: THEN
658: IF NOT OE_CNCL_Validate_Adj.Header(p_Line_Adj_rec.header_id) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END IF;
661: END IF;
662: */
663:

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663:
664: IF p_Line_Adj_rec.discount_id IS NOT NULL
665: THEN
666: IF NOT OE_CNCL_Validate_Adj.Discount(p_Line_Adj_rec.discount_id) THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: END IF;
669: END IF;
670:
671: IF p_Line_Adj_rec.discount_line_id IS NOT NULL

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670:
671: IF p_Line_Adj_rec.discount_line_id IS NOT NULL
672: THEN
673: IF NOT OE_CNCL_Validate_Adj.Discount_Line(p_Line_Adj_rec.discount_line_id) THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: END IF;
676: END IF;
677:
678: IF p_Line_Adj_rec.automatic_flag IS NOT NULL

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677:
678: IF p_Line_Adj_rec.automatic_flag IS NOT NULL
679: THEN
680: IF NOT OE_CNCL_Validate_Adj.Automatic(p_Line_Adj_rec.automatic_flag) THEN
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END IF;
683: END IF;
684:
685: IF p_Line_Adj_rec.percent IS NOT NULL

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684:
685: IF p_Line_Adj_rec.percent IS NOT NULL
686: THEN
687: IF NOT OE_CNCL_Validate_Adj.Percent(p_Line_Adj_rec.percent) THEN
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: END IF;
690: END IF;
691:
692: /* IF p_Line_Adj_rec.line_id IS NOT NULL

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691:
692: /* IF p_Line_Adj_rec.line_id IS NOT NULL
693: THEN
694: IF NOT OE_CNCL_Validate_Adj.Line(p_Line_Adj_rec.line_id) THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: END IF;
697: END IF;
698: */
699:

Line 703: x_return_status := FND_API.G_RET_STS_ERROR;

699:
700: IF p_Line_Adj_rec.list_line_no IS NOT NULL
701: THEN
702: IF NOT OE_CNCL_Validate_Adj.List_Line_No(p_Line_Adj_rec.list_line_no) THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: END IF;
705: END IF;
706:
707: IF p_Line_Adj_rec.source_system_code IS NOT NULL

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

706:
707: IF p_Line_Adj_rec.source_system_code IS NOT NULL
708: THEN
709: IF NOT OE_CNCL_Validate_Adj.source_system_code(p_Line_Adj_rec.source_system_code) THEN
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: END IF;
712: END IF;
713:
714: IF p_Line_Adj_rec.benefit_qty IS NOT NULL

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713:
714: IF p_Line_Adj_rec.benefit_qty IS NOT NULL
715: THEN
716: IF NOT OE_CNCL_Validate_Adj.benefit_qty(p_Line_Adj_rec.benefit_qty) THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: END IF;
719: END IF;
720:
721: IF p_Line_Adj_rec.benefit_uom_code IS NOT NULL

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720:
721: IF p_Line_Adj_rec.benefit_uom_code IS NOT NULL
722: THEN
723: IF NOT OE_CNCL_Validate_Adj.benefit_uom_code(p_Line_Adj_rec.benefit_uom_code) THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: END IF;
726: END IF;
727:
728: IF p_Line_Adj_rec.print_on_invoice_flag IS NOT NULL

Line 731: x_return_status := FND_API.G_RET_STS_ERROR;

727:
728: IF p_Line_Adj_rec.print_on_invoice_flag IS NOT NULL
729: THEN
730: IF NOT OE_CNCL_Validate_Adj.print_on_invoice_flag(p_Line_Adj_rec.print_on_invoice_flag) THEN
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: END IF;
733: END IF;
734:
735: IF p_Line_Adj_rec.expiration_date IS NOT NULL

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

734:
735: IF p_Line_Adj_rec.expiration_date IS NOT NULL
736: THEN
737: IF NOT OE_CNCL_Validate_Adj.expiration_date(p_Line_Adj_rec.expiration_date) THEN
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: END IF;
740: END IF;
741:
742: IF p_Line_Adj_rec.rebate_transaction_type_code IS NOT NULL

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741:
742: IF p_Line_Adj_rec.rebate_transaction_type_code IS NOT NULL
743: THEN
744: IF NOT OE_CNCL_Validate_Adj.rebate_transaction_type_code(p_Line_Adj_rec.rebate_transaction_type_code) THEN
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: END IF;
747: END IF;
748:
749:

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

749:
750: IF p_Line_Adj_rec.rebate_transaction_reference IS NOT NULL
751: THEN
752: IF NOT OE_CNCL_Validate_Adj.rebate_transaction_reference(p_Line_Adj_rec.rebate_transaction_reference) THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: END IF;
755: END IF;
756:
757: IF p_Line_Adj_rec.rebate_payment_system_code IS NOT NULL

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756:
757: IF p_Line_Adj_rec.rebate_payment_system_code IS NOT NULL
758: THEN
759: IF NOT OE_CNCL_Validate_Adj.rebate_payment_system_code(p_Line_Adj_rec.rebate_payment_system_code) THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: END IF;
762: END IF;
763:
764: IF p_Line_Adj_rec.Redeemed_Date IS NOT NULL

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763:
764: IF p_Line_Adj_rec.Redeemed_Date IS NOT NULL
765: THEN
766: IF NOT OE_CNCL_Validate_Adj.Redeemed_Date(p_Line_Adj_rec.Redeemed_Date) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: END IF;
769: END IF;
770:
771: IF p_Line_Adj_rec.redeemed_flag IS NOT NULL

Line 774: x_return_status := FND_API.G_RET_STS_ERROR;

770:
771: IF p_Line_Adj_rec.redeemed_flag IS NOT NULL
772: THEN
773: IF NOT OE_CNCL_Validate_Adj.Redeemed_Flag(p_Line_Adj_rec.redeemed_flag) THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;
776: END IF;
777:
778: IF p_Line_Adj_rec.accrual_flag IS NOT NULL

Line 781: x_return_status := FND_API.G_RET_STS_ERROR;

777:
778: IF p_Line_Adj_rec.accrual_flag IS NOT NULL
779: THEN
780: IF NOT OE_CNCL_Validate_Adj.Accrual_Flag(p_Line_Adj_rec.accrual_flag) THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: END IF;
783: END IF;
784:
785: IF p_Line_Adj_rec.list_header_id IS NOT NULL

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784:
785: IF p_Line_Adj_rec.list_header_id IS NOT NULL
786: THEN
787: IF NOT OE_CNCL_Validate_Adj.list_header_id(p_Line_Adj_rec.list_header_id) THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: END IF;
790: END IF;
791:
792: IF p_Line_Adj_rec.list_line_id IS NOT NULL

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791:
792: IF p_Line_Adj_rec.list_line_id IS NOT NULL
793: THEN
794: IF NOT OE_CNCL_Validate_Adj.list_line_id(p_Line_Adj_rec.list_line_id) THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: END IF;
797: END IF;
798:
799: IF p_Line_Adj_rec.list_line_type_code IS NOT NULL

Line 802: x_return_status := FND_API.G_RET_STS_ERROR;

798:
799: IF p_Line_Adj_rec.list_line_type_code IS NOT NULL
800: THEN
801: IF NOT OE_CNCL_Validate_Adj.list_line_type_code(p_Line_Adj_rec.list_line_type_code) THEN
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: END IF;
804: END IF;
805:
806: IF p_Line_Adj_rec.modified_from IS NOT NULL

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

805:
806: IF p_Line_Adj_rec.modified_from IS NOT NULL
807: THEN
808: IF NOT OE_CNCL_Validate_Adj.modified_from(p_Line_Adj_rec.modified_from) THEN
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: END IF;
811: END IF;
812:
813: IF p_Line_Adj_rec.modified_to IS NOT NULL

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812:
813: IF p_Line_Adj_rec.modified_to IS NOT NULL
814: THEN
815: IF NOT OE_CNCL_Validate_Adj.modified_to(p_Line_Adj_rec.modified_to) THEN
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: END IF;
818: END IF;
819:
820: IF p_Line_Adj_rec.updated_flag IS NOT NULL

Line 823: x_return_status := FND_API.G_RET_STS_ERROR;

819:
820: IF p_Line_Adj_rec.updated_flag IS NOT NULL
821: THEN
822: IF NOT OE_CNCL_Validate_Adj.updated_flag(p_Line_Adj_rec.updated_flag) THEN
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: END IF;
825: END IF;
826:
827: IF p_Line_Adj_rec.update_allowed IS NOT NULL

Line 830: x_return_status := FND_API.G_RET_STS_ERROR;

826:
827: IF p_Line_Adj_rec.update_allowed IS NOT NULL
828: THEN
829: IF NOT OE_CNCL_Validate_Adj.update_allowed(p_Line_Adj_rec.update_allowed) THEN
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: END IF;
832: END IF;
833:
834: IF p_Line_Adj_rec.applied_flag IS NOT NULL

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833:
834: IF p_Line_Adj_rec.applied_flag IS NOT NULL
835: THEN
836: IF NOT OE_CNCL_Validate_Adj.applied_flag(p_Line_Adj_rec.applied_flag) THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: END IF;
839: END IF;
840:
841: IF p_Line_Adj_rec.change_reason_code IS NOT NULL

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840:
841: IF p_Line_Adj_rec.change_reason_code IS NOT NULL
842: THEN
843: IF NOT OE_CNCL_Validate_Adj.change_reason_code(p_Line_Adj_rec.change_reason_code) THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846: END IF;
847:
848: IF p_Line_Adj_rec.change_reason_text IS NOT NULL

Line 851: x_return_status := FND_API.G_RET_STS_ERROR;

847:
848: IF p_Line_Adj_rec.change_reason_text IS NOT NULL
849: THEN
850: IF NOT OE_CNCL_Validate_Adj.change_reason_text(p_Line_Adj_rec.change_reason_text) THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: END IF;
853: END IF;
854:
855: IF p_Line_Adj_rec.adjusted_amount IS NOT NULL

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: IF p_Line_Adj_rec.adjusted_amount IS NOT NULL
856: THEN
857: IF NOT OE_CNCL_Validate_Adj.Adjusted_Amount(p_Line_Adj_rec.adjusted_amount)
858: THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: END IF;
861: END IF;
862:
863: IF p_Line_Adj_rec.pricing_phase_id IS NOT NULL

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

862:
863: IF p_Line_Adj_rec.pricing_phase_id IS NOT NULL
864: THEN
865: IF NOT OE_CNCL_Validate_Adj.Pricing_Phase_id(p_Line_Adj_rec.pricing_phase_id) THEN
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: END IF;
868: END IF;
869:
870: IF p_Line_Adj_rec.operand IS NOT NULL

Line 873: x_return_status := FND_API.G_RET_STS_ERROR;

869:
870: IF p_Line_Adj_rec.operand IS NOT NULL
871: THEN
872: IF NOT OE_CNCL_Validate_Adj.operand(p_Line_Adj_rec.operand) THEN
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875: END IF;
876:
877: IF p_Line_Adj_rec.arithmetic_operator IS NOT NULL

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876:
877: IF p_Line_Adj_rec.arithmetic_operator IS NOT NULL
878: THEN
879: IF NOT OE_CNCL_Validate_Adj.arithmetic_operator(p_Line_Adj_rec.arithmetic_operator) THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: END IF;
882: END IF;
883:
884: IF p_Line_Adj_rec.range_break_quantity IS NOT NULL

Line 887: x_return_status := FND_API.G_RET_STS_ERROR;

883:
884: IF p_Line_Adj_rec.range_break_quantity IS NOT NULL
885: THEN
886: IF NOT OE_CNCL_Validate_Adj.range_break_quantity(p_Line_Adj_rec.range_break_quantity) THEN
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: END IF;
889: END IF;
890:
891: IF p_Line_Adj_rec.accrual_conversion_rate IS NOT NULL

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

890:
891: IF p_Line_Adj_rec.accrual_conversion_rate IS NOT NULL
892: THEN
893: IF NOT OE_CNCL_Validate_Adj.accrual_conversion_rate(p_Line_Adj_rec.accrual_conversion_rate) THEN
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: END IF;
896: END IF;
897:
898: IF p_Line_Adj_rec.pricing_group_sequence IS NOT NULL

Line 901: x_return_status := FND_API.G_RET_STS_ERROR;

897:
898: IF p_Line_Adj_rec.pricing_group_sequence IS NOT NULL
899: THEN
900: IF NOT OE_CNCL_Validate_Adj.pricing_group_sequence(p_Line_Adj_rec.pricing_group_sequence) THEN
901: x_return_status := FND_API.G_RET_STS_ERROR;
902: END IF;
903: END IF;
904:
905: IF p_Line_Adj_rec.modifier_level_code IS NOT NULL

Line 908: x_return_status := FND_API.G_RET_STS_ERROR;

904:
905: IF p_Line_Adj_rec.modifier_level_code IS NOT NULL
906: THEN
907: IF NOT OE_CNCL_Validate_Adj.modifier_level_code(p_Line_Adj_rec.modifier_level_code) THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: END IF;
910: END IF;
911:
912: IF p_Line_Adj_rec.price_break_type_code IS NOT NULL

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911:
912: IF p_Line_Adj_rec.price_break_type_code IS NOT NULL
913: THEN
914: IF NOT OE_CNCL_Validate_Adj.price_break_type_code(p_Line_Adj_rec.price_break_type_code) THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END IF;
917: END IF;
918:
919: IF p_Line_Adj_rec.substitution_attribute IS NOT NULL

Line 922: x_return_status := FND_API.G_RET_STS_ERROR;

918:
919: IF p_Line_Adj_rec.substitution_attribute IS NOT NULL
920: THEN
921: IF NOT OE_CNCL_Validate_Adj.substitution_attribute(p_Line_Adj_rec.substitution_attribute) THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: END IF;
924: END IF;
925:
926: IF p_Line_Adj_rec.proration_type_code IS NOT NULL

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925:
926: IF p_Line_Adj_rec.proration_type_code IS NOT NULL
927: THEN
928: IF NOT OE_CNCL_Validate_Adj.proration_type_code(p_Line_Adj_rec.proration_type_code) THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: END IF;
931: END IF;
932:
933: IF p_Line_Adj_rec.credit_or_charge_flag IS NOT NULL

Line 936: x_return_status := FND_API.G_RET_STS_ERROR;

932:
933: IF p_Line_Adj_rec.credit_or_charge_flag IS NOT NULL
934: THEN
935: IF NOT OE_CNCL_Validate.credit_or_charge_flag(p_Line_Adj_rec.credit_or_charge_flag) THEN
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: END IF;
938: END IF;
939:
940: IF p_Line_Adj_rec.cost_id IS NOT NULL

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939:
940: IF p_Line_Adj_rec.cost_id IS NOT NULL
941: THEN
942: IF NOT OE_CNCL_Validate.cost_id(p_Line_Adj_rec.cost_id) THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: END IF;
945: END IF;
946:
947: IF p_Line_Adj_rec.charge_type_code IS NOT NULL

Line 950: x_return_status := FND_API.G_RET_STS_ERROR;

946:
947: IF p_Line_Adj_rec.charge_type_code IS NOT NULL
948: THEN
949: IF NOT OE_CNCL_Validate.charge_type_code(p_Line_Adj_rec.charge_type_code) THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: END IF;
952: END IF;
953:
954: IF p_Line_Adj_rec.charge_subtype_code IS NOT NULL

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953:
954: IF p_Line_Adj_rec.charge_subtype_code IS NOT NULL
955: THEN
956: IF NOT OE_CNCL_Validate.charge_subtype_code(p_Line_Adj_rec.charge_subtype_code) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: END IF;
960:
961: IF p_Line_Adj_rec.estimated_flag IS NOT NULL

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960:
961: IF p_Line_Adj_rec.estimated_flag IS NOT NULL
962: THEN
963: IF NOT OE_CNCL_Validate.estimated(p_Line_Adj_rec.estimated_flag) THEN
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: END IF;
966: END IF;
967:
968: IF p_Line_Adj_rec.invoiced_flag IS NOT NULL

Line 971: x_return_status := FND_API.G_RET_STS_ERROR;

967:
968: IF p_Line_Adj_rec.invoiced_flag IS NOT NULL
969: THEN
970: IF NOT OE_CNCL_Validate.invoiced(p_Line_Adj_rec.invoiced_flag) THEN
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: END IF;
973: END IF;
974:
975: IF p_Line_Adj_rec.context IS NOT NULL

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR;

1009: ,p_attribute14 => p_Line_Adj_rec.attribute14
1010: ,p_attribute15 => p_Line_Adj_rec.attribute15) THEN
1011:
1012:
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014:
1015: END IF;
1016:
1017: oe_debug_pub.add('After Line Adjustment desc_flex ' || x_return_status);

Line 1027: WHEN FND_API.G_EXC_ERROR THEN

1023: -- Done validating attributes
1024: oe_debug_pub.add('Exiting OE_CNCL_Validate_Line_Adjs');
1025: EXCEPTION
1026:
1027: WHEN FND_API.G_EXC_ERROR THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1029: x_return_status := FND_API.G_RET_STS_ERROR;

1025: EXCEPTION
1026:
1027: WHEN FND_API.G_EXC_ERROR THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1027: WHEN FND_API.G_EXC_ERROR THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034:
1035: WHEN OTHERS THEN

Line 1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:
1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034:
1035: WHEN OTHERS THEN
1036:
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034:
1035: WHEN OTHERS THEN
1036:
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038:
1039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: OE_MSG_PUB.Add_Exc_Msg