[Home] [Help]
PACKAGE BODY: APPS.OE_VALIDATE_ADJ
Source
1 PACKAGE BODY OE_Validate_adj AS
2 /* $Header: OEXSVADB.pls 120.1 2006/01/24 14:24:19 aycui noship $ */
3
4 -- Global constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_adj';
7
8 -- Procedure Get_Attr_Tbl.
9 --
10 -- Used by generator to avoid overriding or duplicating existing
11 -- validation functions.
12 --
13 -- DO NOT REMOVE
14
15 PROCEDURE Get_Attr_Tbl
16 IS
17 I NUMBER:=0;
18 BEGIN
19
20 FND_API.g_attr_tbl.DELETE;
21
22 -- START GEN attributes
23
24 -- Generator will append new attributes before end generate comment.
25
26 I := I + 1;
27 FND_API.g_attr_tbl(I).name := 'created_by';
28 I := I + 1;
29 FND_API.g_attr_tbl(I).name := 'creation_date';
30 I := I + 1;
31 FND_API.g_attr_tbl(I).name := 'desc_flex';
32 I := I + 1;
33 FND_API.g_attr_tbl(I).name := 'header';
34 I := I + 1;
35 FND_API.g_attr_tbl(I).name := 'last_updated_by';
36 I := I + 1;
37 FND_API.g_attr_tbl(I).name := 'last_update_date';
38 I := I + 1;
39 FND_API.g_attr_tbl(I).name := 'last_update_login';
40 I := I + 1;
41 FND_API.g_attr_tbl(I).name := 'program_application';
42 I := I + 1;
43 FND_API.g_attr_tbl(I).name := 'program';
44 I := I + 1;
45 FND_API.g_attr_tbl(I).name := 'program_update_date';
46 I := I + 1;
47 FND_API.g_attr_tbl(I).name := 'request_date';
48 I := I + 1;
49 FND_API.g_attr_tbl(I).name := 'request';
50 I := I + 1;
51 FND_API.g_attr_tbl(I).name := 'applied_flag';
52 I := I + 1;
53 FND_API.g_attr_tbl(I).name := 'automatic';
54 I := I + 1;
55 FND_API.g_attr_tbl(I).name := 'change_reason_code';
56 I := I + 1;
57 FND_API.g_attr_tbl(I).name := 'change_reason_text';
58 I := I + 1;
59 FND_API.g_attr_tbl(I).name := 'discount';
60 I := I + 1;
61 FND_API.g_attr_tbl(I).name := 'discount_line';
62 I := I + 1;
63 FND_API.g_attr_tbl(I).name := 'line';
64 I := I + 1;
65 FND_API.g_attr_tbl(I).name := 'list_header_id';
66 I := I + 1;
67 FND_API.g_attr_tbl(I).name := 'list_line_id';
68 I := I + 1;
69 FND_API.g_attr_tbl(I).name := 'list_line_type_code';
70 I := I + 1;
71 FND_API.g_attr_tbl(I).name := 'modified_from';
72 I := I + 1;
73 FND_API.g_attr_tbl(I).name := 'modified_to';
74 I := I + 1;
75 FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';
76 I := I + 1;
77 FND_API.g_attr_tbl(I).name := 'percent';
78 I := I + 1;
79 FND_API.g_attr_tbl(I).name := 'price_adjustment';
80 I := I + 1;
81 FND_API.g_attr_tbl(I).name := 'updated_flag';
82 I := I + 1;
83 FND_API.g_attr_tbl(I).name := 'update_allowed';
84 I := I + 1;
85 FND_API.g_attr_tbl(I).name := 'adjusted_amount';
86 I := I + 1;
87 FND_API.g_attr_tbl(I).name := 'pricing_phase_id';
88 I := I + 1;
89 FND_API.g_attr_tbl(I).name := 'operand';
90 I := I + 1;
91 FND_API.g_attr_tbl(I).name := 'arithmetic_operator';
92 I := I + 1;
93 FND_API.g_attr_tbl(I).name := 'list_line_no';
94 I := I + 1;
95 FND_API.g_attr_tbl(I).name := 'source_system_code';
96 I := I + 1;
97 FND_API.g_attr_tbl(I).name := 'benefit_qty';
98 I := I + 1;
99 FND_API.g_attr_tbl(I).name := 'benefit_uom_code';
100 I := I + 1;
101 FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';
102 I := I + 1;
103 FND_API.g_attr_tbl(I).name := 'expiration_date';
104 I := I + 1;
105 FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';
106 I := I + 1;
107 FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';
108 I := I + 1;
109 FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';
110 I := I + 1;
111 FND_API.g_attr_tbl(I).name := 'redeemed_date';
112 I := I + 1;
113 FND_API.g_attr_tbl(I).name := 'redeemed_flag';
114 I := I + 1;
115 FND_API.g_attr_tbl(I).name := 'accrual_flag';
116 I := I + 1;
117 FND_API.g_attr_tbl(I).name := 'range_break_quantity';
118 I := I + 1;
119 FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';
120 I := I + 1;
121 FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';
122 I := I + 1;
123 FND_API.g_attr_tbl(I).name := 'modifier_level_code';
124 I := I + 1;
125 FND_API.g_attr_tbl(I).name := 'price_break_type_code';
126 I := I + 1;
127 FND_API.g_attr_tbl(I).name := 'substitution_attribute';
128 I := I + 1;
129 FND_API.g_attr_tbl(I).name := 'proration_type_code';
130
131 -- END GEN attributes
132
133 END Get_Attr_Tbl;
134
135 -- Prototypes for validate functions.
136
137 -- START GEN validate
138
139 -- Generator will append new prototypes before end generate comment.
140
141 --/old/
142
143
144 FUNCTION Desc_Flex ( p_appl_short_name varchar2,p_flex_name IN VARCHAR2 )
145 RETURN BOOLEAN
146 IS
147 BEGIN
148
149 -- Call FND validate API.
150
151
152 -- This call is temporarily commented out
153
154 IF FND_FLEX_DESCVAL.Validate_Desccols
155 ( appl_short_name => p_appl_short_name
156 , desc_flex_name => p_flex_name
157 )
158 THEN
159 RETURN TRUE;
160 ELSE
161
162 -- Prepare the encoded message by setting it on the message
163 -- dictionary stack. Then, add it to the API message list.
164
165 FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
166
167 OE_MSG_PUB.Add;
168
169 -- Derive return status.
170
171 IF FND_FLEX_DESCVAL.value_error OR
172 FND_FLEX_DESCVAL.unsupported_error
173 THEN
174
175 -- In case of an expected error return FALSE
176
177 RETURN FALSE;
178
179 ELSE
180
181 -- In case of an unexpected error raise an exception.
182
183 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184
185 END IF;
186
187 END IF;
188
189
190 RETURN TRUE;
191
192 EXCEPTION
193
194 WHEN NO_DATA_FOUND THEN
195
196
197 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
198 THEN
199
200 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESC_FLEX');
201
202 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
203 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
204 OE_Order_Util.Get_Attribute_Name('DESC_FLEX'));
205 OE_MSG_PUB.Add;
206 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
207
208 END IF;
209
210
211 RETURN FALSE;
212
213 WHEN OTHERS THEN
214
215 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216 THEN
217 OE_MSG_PUB.Add_Exc_Msg
218 ( G_PKG_NAME
219 , 'Desc_Flex'
220 );
221 END IF;
222
223 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224
225 END Desc_Flex;
226
227 FUNCTION Header ( p_header_id IN NUMBER )
228 RETURN BOOLEAN
229 IS
230 l_dummy VARCHAR2(10);
231 BEGIN
232
233
234 IF p_header_id IS NULL OR
235 p_header_id = FND_API.G_MISS_NUM
236 THEN
237 RETURN TRUE;
238 END IF;
239
240 -- SELECT 'VALID'
241 -- INTO l_dummy
242 -- FROM DB_TABLE
243 -- WHERE DB_COLUMN = p_header_id;
244
245
246 RETURN TRUE;
247
248 EXCEPTION
249
250 WHEN NO_DATA_FOUND THEN
251
252
253 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
254 THEN
255
256 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
257
258 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
259 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260 OE_Order_Util.Get_Attribute_Name('HEADER_ID'));
261 OE_MSG_PUB.Add;
262 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
263
264 END IF;
265
266
267 RETURN FALSE;
268
269 WHEN OTHERS THEN
270
271 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272 THEN
273 OE_MSG_PUB.Add_Exc_Msg
274 ( G_PKG_NAME
275 , 'Header'
276 );
277 END IF;
278
279 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280
281 END Header;
282
283
284 FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
285 RETURN BOOLEAN
286 IS
287 l_dummy VARCHAR2(10);
288 BEGIN
289
290
291 IF p_last_updated_by IS NULL OR
292 p_last_updated_by = FND_API.G_MISS_NUM
293 THEN
294
295 RETURN TRUE;
296 END IF;
297
298 -- SELECT 'VALID'
299 -- INTO l_dummy
300 -- FROM DB_TABLE
301 -- WHERE DB_COLUMN = p_last_updated_by;
302
303
304 RETURN TRUE;
305
306 EXCEPTION
307
308 WHEN NO_DATA_FOUND THEN
309
310 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
311 THEN
312
313 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
314
315 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
316 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
317 OE_Order_Util.Get_Attribute_Name('last_updated_by'));
318 OE_MSG_PUB.Add;
319 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
320
321 END IF;
322
323
324 RETURN FALSE;
325
326 WHEN OTHERS THEN
327
328 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329 THEN
330 OE_MSG_PUB.Add_Exc_Msg
331 ( G_PKG_NAME
332 , 'Last_Updated_By'
333 );
334 END IF;
335
336
337 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338
339 END Last_Updated_By;
340
341 FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
342 RETURN BOOLEAN
343 IS
344 l_dummy VARCHAR2(10);
345 BEGIN
346
347
348 IF p_last_update_date IS NULL OR
349 p_last_update_date = FND_API.G_MISS_DATE
350 THEN
351
352 RETURN TRUE;
353 END IF;
354
355 -- SELECT 'VALID'
356 -- INTO l_dummy
357 -- FROM DB_TABLE
358 -- WHERE DB_COLUMN = p_last_update_date;
359
360
361 RETURN TRUE;
362
363 EXCEPTION
364
365 WHEN NO_DATA_FOUND THEN
366
367 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
368 THEN
369
370 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
371
372 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
373 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
374 OE_Order_Util.Get_Attribute_Name('last_update_date'));
375 OE_MSG_PUB.Add;
376 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
377
378 END IF;
379
380
381 RETURN FALSE;
382
383 WHEN OTHERS THEN
384
385 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386 THEN
387 OE_MSG_PUB.Add_Exc_Msg
388 ( G_PKG_NAME
389 , 'Last_Update_Date'
390 );
391 END IF;
392
393
394 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395
396 END Last_Update_Date;
397
398 FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
399 RETURN BOOLEAN
400 IS
401 l_dummy VARCHAR2(10);
402 BEGIN
403
404
405 IF p_last_update_login IS NULL OR
406 p_last_update_login = FND_API.G_MISS_NUM
407 THEN
408
409 RETURN TRUE;
410 END IF;
411
412 -- SELECT 'VALID'
413 -- INTO l_dummy
414 -- FROM DB_TABLE
415 -- WHERE DB_COLUMN = p_last_update_login;
416
417
418 RETURN TRUE;
419
420 EXCEPTION
421
422 WHEN NO_DATA_FOUND THEN
423
424 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
425 THEN
426
427 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
428
429 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
430 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
431 OE_Order_Util.Get_Attribute_Name('last_update_login'));
432 OE_MSG_PUB.Add;
433 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
434
435 END IF;
436
437
438 RETURN FALSE;
439
440 WHEN OTHERS THEN
441
442 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443 THEN
444 OE_MSG_PUB.Add_Exc_Msg
445 ( G_PKG_NAME
446 , 'Last_Update_Login'
447 );
448 END IF;
449
450
451 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452
453 END Last_Update_Login;
454
455 FUNCTION Program_Application ( p_program_application_id IN NUMBER )
456 RETURN BOOLEAN
457 IS
458 l_dummy VARCHAR2(10);
459 BEGIN
460
461
462 IF p_program_application_id IS NULL OR
463 p_program_application_id = FND_API.G_MISS_NUM
464 THEN
465
466 RETURN TRUE;
467 END IF;
468
469 -- SELECT 'VALID'
470 -- INTO l_dummy
471 -- FROM DB_TABLE
472 -- WHERE DB_COLUMN = p_program_application_id;
473
474
475 RETURN TRUE;
476
477 EXCEPTION
478
479 WHEN NO_DATA_FOUND THEN
480
481 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482 THEN
483
484 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
485
486 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
487 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
488 OE_Order_Util.Get_Attribute_Name('program_application_id'));
489 OE_MSG_PUB.Add;
490 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
491
492 END IF;
493
494
495 RETURN FALSE;
496
497 WHEN OTHERS THEN
498
499 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500 THEN
501 OE_MSG_PUB.Add_Exc_Msg
502 ( G_PKG_NAME
503 , 'Program_Application'
504 );
505 END IF;
506
507
508 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509
510 END Program_Application;
511
512 FUNCTION Program ( p_program_id IN NUMBER )
513 RETURN BOOLEAN
514 IS
515 l_dummy VARCHAR2(10);
516 BEGIN
517
518
519 IF p_program_id IS NULL OR
520 p_program_id = FND_API.G_MISS_NUM
521 THEN
522
523 RETURN TRUE;
524 END IF;
525
526 -- SELECT 'VALID'
527 -- INTO l_dummy
528 -- FROM DB_TABLE
529 -- WHERE DB_COLUMN = p_program_id;
530
531
532 RETURN TRUE;
533
534 EXCEPTION
535
536 WHEN NO_DATA_FOUND THEN
537
538 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
539 THEN
540
541 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
542
543 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
544 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
545 OE_Order_Util.Get_Attribute_Name('program_id'));
546 OE_MSG_PUB.Add;
547 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
548
549 END IF;
550
551
552 RETURN FALSE;
553
554 WHEN OTHERS THEN
555
556 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557 THEN
558 OE_MSG_PUB.Add_Exc_Msg
559 ( G_PKG_NAME
560 , 'Program'
561 );
562 END IF;
563
564
565 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566
567 END Program;
568
569 FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
570 RETURN BOOLEAN
571 IS
572 l_dummy VARCHAR2(10);
573 BEGIN
574
575
576 IF p_program_update_date IS NULL OR
577 p_program_update_date = FND_API.G_MISS_DATE
578 THEN
579
580 RETURN TRUE;
581 END IF;
582
583 -- SELECT 'VALID'
584 -- INTO l_dummy
585 -- FROM DB_TABLE
586 -- WHERE DB_COLUMN = p_program_update_date;
587
588
589 RETURN TRUE;
590
591 EXCEPTION
592
593 WHEN NO_DATA_FOUND THEN
594
595 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
596 THEN
597
598 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
599
600 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
601 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
602 OE_Order_Util.Get_Attribute_Name('program_update_date'));
603 OE_MSG_PUB.Add;
604 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
605
606 END IF;
607
608
609 RETURN FALSE;
610
611 WHEN OTHERS THEN
612
613 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614 THEN
615 OE_MSG_PUB.Add_Exc_Msg
616 ( G_PKG_NAME
617 , 'Program_Update_Date'
618 );
619 END IF;
620
621
622 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623
624 END Program_Update_Date;
625
626 FUNCTION Request ( p_request_id IN NUMBER )
627 RETURN BOOLEAN
628 IS
629 l_dummy VARCHAR2(10);
630 BEGIN
631
632
633 IF p_request_id IS NULL OR
634 p_request_id = FND_API.G_MISS_NUM
635 THEN
636
637 RETURN TRUE;
638 END IF;
639
640 -- SELECT 'VALID'
641 -- INTO l_dummy
642 -- FROM DB_TABLE
643 -- WHERE DB_COLUMN = p_request_id;
644
645
646 RETURN TRUE;
647
648 EXCEPTION
649
650 WHEN NO_DATA_FOUND THEN
651
652 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
653 THEN
654
655 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
656
657 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
658 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
659 OE_Order_Util.Get_Attribute_Name('request_id'));
660 OE_MSG_PUB.Add;
661 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
662
663 END IF;
664
665
666 RETURN FALSE;
667
668 WHEN OTHERS THEN
669
670 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671 THEN
672 OE_MSG_PUB.Add_Exc_Msg
673 ( G_PKG_NAME
674 , 'Request'
675 );
676 END IF;
677
678
679 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680
681 END Request;
682
683 FUNCTION Price_Adjustment ( p_price_adjustment_id IN NUMBER )
684 RETURN BOOLEAN
685 IS
686 l_dummy VARCHAR2(10);
687 BEGIN
688
689
690 IF p_price_adjustment_id IS NULL OR
691 p_price_adjustment_id = FND_API.G_MISS_NUM
692 THEN
693
694 RETURN TRUE;
695 END IF;
696
697 -- SELECT 'VALID'
698 -- INTO l_dummy
699 -- FROM DB_TABLE
700 -- WHERE DB_COLUMN = p_price_adjustment_id;
701
702
703 RETURN TRUE;
704
705 EXCEPTION
706
707 WHEN NO_DATA_FOUND THEN
708
709 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
710 THEN
711
712 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
713
714 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
715 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
716 OE_Order_Util.Get_Attribute_Name('price_adjustment_id'));
717 OE_MSG_PUB.Add;
718 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
719
720 END IF;
721
722
723 RETURN FALSE;
724
725 WHEN OTHERS THEN
726
727 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
728 THEN
729 OE_MSG_PUB.Add_Exc_Msg
730 ( G_PKG_NAME
731 , 'Price_Adjustment'
732 );
733 END IF;
734
735
736 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737
738 END Price_Adjustment;
739
740 FUNCTION Discount ( p_discount_id IN NUMBER )
741 RETURN BOOLEAN
742 IS
743 l_dummy VARCHAR2(10);
744 BEGIN
745
746
747 IF p_discount_id IS NULL OR
748 p_discount_id = FND_API.G_MISS_NUM
749 THEN
750
751 RETURN TRUE;
752 END IF;
753
754 -- SELECT 'VALID'
755 -- INTO l_dummy
756 -- FROM DB_TABLE
757 -- WHERE DB_COLUMN = p_discount_id;
758
759
760 RETURN TRUE;
761
762 EXCEPTION
763
764 WHEN NO_DATA_FOUND THEN
765
766 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
767 THEN
768
769 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
770
771 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
773 OE_Order_Util.Get_Attribute_Name('discount_id'));
774 OE_MSG_PUB.Add;
775 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
776
777 END IF;
778
779
780 RETURN FALSE;
781
782 WHEN OTHERS THEN
783
784 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785 THEN
786 OE_MSG_PUB.Add_Exc_Msg
787 ( G_PKG_NAME
788 , 'Discount'
789 );
790 END IF;
791
792
793 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794
795 END Discount;
796
797 FUNCTION Discount_Line ( p_discount_line_id IN NUMBER )
798 RETURN BOOLEAN
799 IS
800 l_dummy VARCHAR2(10);
801 BEGIN
802
803
804 IF p_discount_line_id <> -1 OR
805 p_discount_line_id = FND_API.G_MISS_NUM
806 THEN
807
808 RETURN TRUE;
809 END IF;
810
811
812 -- SELECT 'VALID'
813 -- INTO l_dummy
814 -- FROM DB_TABLE
815 -- WHERE DB_COLUMN = p_discount_line_id;
816
817
818 RETURN TRUE;
819
820 EXCEPTION
821
822 WHEN NO_DATA_FOUND THEN
823
824 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
825 THEN
826
827 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
828
829 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
830 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
831 OE_Order_Util.Get_Attribute_Name('discount_line_id'));
832 OE_MSG_PUB.Add;
833 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
834
835 END IF;
836
837
838 RETURN FALSE;
839
840 WHEN OTHERS THEN
841
842 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843 THEN
844 OE_MSG_PUB.Add_Exc_Msg
845 ( G_PKG_NAME
846 , 'Discount_Line'
847 );
848 END IF;
849
850
851 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852
853 END Discount_Line;
854
855 FUNCTION Automatic ( p_automatic_flag IN VARCHAR2 )
856 RETURN BOOLEAN
857 IS
858 l_dummy VARCHAR2(10);
859 BEGIN
860
861
862 IF p_automatic_flag IS NULL OR
863 p_automatic_flag = FND_API.G_MISS_CHAR
864 THEN
865
866 RETURN TRUE;
867 END IF;
868
869 -- SELECT 'VALID'
870 -- INTO l_dummy
871 -- FROM DB_TABLE
872 -- WHERE DB_COLUMN = p_automatic_flag;
873
874
875 RETURN TRUE;
876
877 EXCEPTION
878
879 WHEN NO_DATA_FOUND THEN
880
881 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
882 THEN
883
884 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
885
886 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
887 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
888 OE_Order_Util.Get_Attribute_Name('automatic_flag'));
889 OE_MSG_PUB.Add;
890 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
891
892 END IF;
893
894
895 RETURN FALSE;
896
897 WHEN OTHERS THEN
898
899 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900 THEN
901 OE_MSG_PUB.Add_Exc_Msg
902 ( G_PKG_NAME
903 , 'Automatic'
904 );
905 END IF;
906
907
908 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909
910 END Automatic;
911
912 FUNCTION Percent ( p_percent IN NUMBER )
913 RETURN BOOLEAN
914 IS
915 l_dummy VARCHAR2(10);
916 BEGIN
917
918
919 -- All attribute validation being turned on
920 -- IF p_percent IS NULL OR
921 -- p_percent = FND_API.g_miss_num
922 -- THEN
923 -- RETURN TRUE;
924 -- ELSIF p_percent = 0
925 -- THEN
926 -- RETURN FALSE;
927 -- END IF;
928
929
930 RETURN TRUE;
931
932 /*
933 IF p_percent IS NULL OR
934 p_percent = FND_API.G_MISS_NUM
935 THEN
936 RETURN TRUE;
937 END IF;
938
939 -- SELECT 'VALID'
940 -- INTO l_dummy
941 -- FROM DB_TABLE
942 -- WHERE DB_COLUMN = p_percent;
943
944 RETURN TRUE;
945 */
946 EXCEPTION
947
948 WHEN NO_DATA_FOUND THEN
949
950 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
951 THEN
952
953 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
954
955 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
956 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
957 OE_Order_Util.Get_Attribute_Name('percent'));
958 OE_MSG_PUB.Add;
959 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
960
961 END IF;
962
963
964 RETURN FALSE;
965
966 WHEN OTHERS THEN
967
968 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969 THEN
970 OE_MSG_PUB.Add_Exc_Msg
971 ( G_PKG_NAME
972 , 'Percent'
973 );
974 END IF;
975
976
977 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978
979 END Percent;
980
981 FUNCTION Line ( p_line_id IN NUMBER )
982 RETURN BOOLEAN
983 IS
984 l_dummy VARCHAR2(10);
985 BEGIN
986
987
988 IF p_line_id IS NULL OR
989 p_line_id = FND_API.G_MISS_NUM
990 THEN
991
992 RETURN TRUE;
993 END IF;
994
995 -- SELECT 'VALID'
996 -- INTO l_dummy
997 -- FROM DB_TABLE
998 -- WHERE DB_COLUMN = p_line_id;
999
1000
1001 RETURN TRUE;
1002
1003 EXCEPTION
1004
1005 WHEN NO_DATA_FOUND THEN
1006
1007 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1008 THEN
1009
1010 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
1011
1012 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1013 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014 OE_Order_Util.Get_Attribute_Name('line_id'));
1015 OE_MSG_PUB.Add;
1016 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1017
1018 END IF;
1019
1020
1021 RETURN FALSE;
1022
1023 WHEN OTHERS THEN
1024
1025 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026 THEN
1027 OE_MSG_PUB.Add_Exc_Msg
1028 ( G_PKG_NAME
1029 , 'Line'
1030 );
1031 END IF;
1032
1033
1034 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035
1036 END Line;
1037
1038
1039 FUNCTION Applied_Flag ( p_Applied_Flag IN VARCHAR2 )
1040 RETURN BOOLEAN
1041 IS
1042 l_dummy VARCHAR2(10);
1043 BEGIN
1044
1045
1046 IF p_Applied_Flag IS NULL OR
1047 p_Applied_Flag = FND_API.G_MISS_CHAR
1048 THEN
1049
1050 RETURN TRUE;
1051 END IF;
1052
1053 if p_applied_flag not in ('Y','N') then
1054
1055 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1056 THEN
1057
1058 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1059
1060 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1061 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1062 OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1063 OE_MSG_PUB.Add;
1064 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1065
1066 END IF;
1067 RETURN FALSE;
1068 End if;
1069
1070 RETURN TRUE;
1071
1072 EXCEPTION
1073
1074 WHEN NO_DATA_FOUND THEN
1075
1076 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1077 THEN
1078
1079 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1080
1081 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1082 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1083 OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1084 OE_MSG_PUB.Add;
1085 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1086
1087 END IF;
1088
1089
1090 RETURN FALSE;
1091
1092 WHEN OTHERS THEN
1093
1094 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095 THEN
1096 OE_MSG_PUB.Add_Exc_Msg
1097 ( G_PKG_NAME
1098 , 'Applied_Flag'
1099 );
1100 END IF;
1101
1102
1103 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104
1105 END Applied_Flag;
1106
1107
1108
1109 FUNCTION Change_Reason_Code(p_Change_Reason_Code IN VARCHAR2)
1110 RETURN BOOLEAN
1111 IS
1112 l_dummy VARCHAR2(10);
1113 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1114 l_lookup_type VARCHAR2(80) :='CHANGE_CODE';
1115 BEGIN
1116
1117
1118 IF p_Change_Reason_Code IS NULL OR
1119 p_Change_Reason_Code = FND_API.G_MISS_CHAR OR
1120 upper(p_Change_Reason_Code)='MANUAL' OR
1121 upper(p_Change_Reason_Code)='SYSTEM' OR
1122 upper(p_Change_Reason_Code)='CONFIGURATOR'
1123 THEN
1124 RETURN TRUE;
1125 END IF;
1126
1127 SELECT 'VALID'
1128 INTO l_dummy
1129 FROM OE_LOOKUPS
1130 WHERE LOOKUP_CODE = p_change_reason_code
1131 AND LOOKUP_TYPE = l_lookup_type
1132 AND ENABLED_FLAG = 'Y'
1133 AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);
1134
1135
1136 RETURN TRUE;
1137
1138 EXCEPTION
1139
1140 WHEN NO_DATA_FOUND THEN
1141
1142 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1143 THEN
1144
1145 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
1146
1147 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1148 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1149 OE_Order_Util.Get_Attribute_Name('Change_Reason_Code'));
1150 OE_MSG_PUB.Add;
1151 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1152
1153 END IF;
1154
1155
1156 RETURN FALSE;
1157
1158 WHEN OTHERS THEN
1159
1160 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1161 THEN
1162 OE_MSG_PUB.Add_Exc_Msg
1163 ( G_PKG_NAME
1164 , 'Change_Reason_Code'
1165 );
1166 END IF;
1167
1168
1169 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170
1171 END Change_Reason_Code;
1172
1173
1174 FUNCTION Change_Reason_Text(p_Change_Reason_Text IN VARCHAR2)
1175 RETURN BOOLEAN
1176 IS
1177 l_dummy VARCHAR2(10);
1178 BEGIN
1179
1180
1181 IF p_Change_Reason_Text IS NULL OR
1182 p_Change_Reason_Text = FND_API.G_MISS_CHAR
1183 THEN
1184
1185 RETURN TRUE;
1186 END IF;
1187
1188
1189 RETURN TRUE;
1190
1191 EXCEPTION
1192
1193 WHEN NO_DATA_FOUND THEN
1194
1195 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196 THEN
1197
1198 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
1199
1200 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1201 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1202 OE_Order_Util.Get_Attribute_Name('Change_Reason_Text'));
1203 OE_MSG_PUB.Add;
1204 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1205
1206 END IF;
1207
1208
1209 RETURN FALSE;
1210
1211 WHEN OTHERS THEN
1212
1213 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214 THEN
1215 OE_MSG_PUB.Add_Exc_Msg
1216 ( G_PKG_NAME
1217 , 'Change_Reason_Text'
1218 );
1219 END IF;
1220
1221
1222 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223
1224 END Change_Reason_Text;
1225
1226
1227 FUNCTION List_Header_id(p_List_Header_id IN NUMBER)
1228 RETURN BOOLEAN
1229 IS
1230 l_dummy VARCHAR2(10);
1231 BEGIN
1232
1233
1234 IF p_List_Header_id IS NULL OR
1235 p_List_Header_id = FND_API.G_MISS_NUM
1236 THEN
1237
1238 RETURN TRUE;
1239 END IF;
1240
1241 SELECT 'VALID'
1242 INTO l_dummy
1243 FROM qp_list_headers_vl
1244 WHERE list_header_id = p_List_Header_id;
1245
1246
1247 RETURN TRUE;
1248
1249 EXCEPTION
1250
1251 WHEN NO_DATA_FOUND THEN
1252
1253 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1254 THEN
1255
1256 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
1257
1258 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1259 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1260 OE_Order_Util.Get_Attribute_Name('List_Header_id'));
1261 OE_MSG_PUB.Add;
1262 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1263
1264 END IF;
1265
1266
1267 RETURN FALSE;
1268
1269 WHEN OTHERS THEN
1270
1271 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272 THEN
1273 OE_MSG_PUB.Add_Exc_Msg
1274 ( G_PKG_NAME
1275 , 'List_Header_id'
1276 );
1277 END IF;
1278
1279
1280 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281
1282 END List_Header_id;
1283
1284
1285 FUNCTION List_Line_id(p_List_Line_id IN NUMBER)
1286 RETURN BOOLEAN
1287 IS
1288 l_dummy VARCHAR2(10);
1289 BEGIN
1290
1291
1292 IF p_List_Line_id IS NULL OR
1293 p_List_Line_id = FND_API.G_MISS_NUM
1294 THEN
1295
1296 RETURN TRUE;
1297 END IF;
1298
1299 SELECT 'VALID'
1300 INTO l_dummy
1301 FROM qp_list_lines
1302 WHERE list_line_id = p_List_Line_id;
1303
1304
1305 RETURN TRUE;
1306
1307 EXCEPTION
1308
1309 WHEN NO_DATA_FOUND THEN
1310
1311 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1312 THEN
1313
1314 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
1315
1316 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1317 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1318 OE_Order_Util.Get_Attribute_Name('List_Line_id'));
1319 OE_MSG_PUB.Add;
1320 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1321
1322 END IF;
1323
1324
1325 RETURN FALSE;
1326
1327 WHEN OTHERS THEN
1328
1329 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330 THEN
1331 OE_MSG_PUB.Add_Exc_Msg
1332 ( G_PKG_NAME
1333 , 'List_Line_id'
1334 );
1335 END IF;
1336
1337 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338
1339 END List_Line_id;
1340
1341
1342 FUNCTION List_Line_Type_code(p_List_Line_Type_code IN VARCHAR2)
1343 RETURN BOOLEAN
1344 IS
1345 l_dummy VARCHAR2(10);
1346 BEGIN
1347
1348
1349 IF p_List_Line_Type_code IS NULL OR
1350 p_List_Line_Type_code = FND_API.G_MISS_CHAR
1351 THEN
1352
1353 RETURN TRUE;
1354 END IF;
1355
1356 -- SELECT 'VALID'
1357 -- INTO l_dummy
1358 -- FROM DB_TABLE
1359 -- WHERE DB_COLUMN = p_price_adjustment_id;
1360
1361
1362 RETURN TRUE;
1363
1364 EXCEPTION
1365
1366 WHEN NO_DATA_FOUND THEN
1367
1368 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1369 THEN
1370
1371 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
1372
1373 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1374 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1375 OE_Order_Util.Get_Attribute_Name('List_Line_Type_code'));
1376 OE_MSG_PUB.Add;
1377 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1378
1379 END IF;
1380
1381
1382 RETURN FALSE;
1383
1384 WHEN OTHERS THEN
1385
1386 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387 THEN
1388 OE_MSG_PUB.Add_Exc_Msg
1389 ( G_PKG_NAME
1390 , 'List_Line_Type_code'
1391 );
1392 END IF;
1393
1394
1395 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396
1397 END List_Line_Type_code;
1398
1399
1400
1401 FUNCTION Pricing_Phase_id(p_Pricing_Phase_id IN NUMBER)
1402 RETURN BOOLEAN
1403 IS
1404 l_dummy VARCHAR2(10);
1405 BEGIN
1406
1407
1408 IF p_Pricing_Phase_id IS NULL OR
1409 p_Pricing_Phase_id = FND_API.G_MISS_NUM
1410 THEN
1411
1412 RETURN TRUE;
1413 END IF;
1414
1415 -- SELECT 'VALID'
1416 -- INTO l_dummy
1417 -- FROM DB_TABLE
1418 -- WHERE DB_COLUMN = p_price_adjustment_id;
1419
1420
1421 RETURN TRUE;
1422
1423 EXCEPTION
1424
1425 WHEN NO_DATA_FOUND THEN
1426
1427 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1428 THEN
1429
1430 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Pricing_Phase_id');
1431
1432 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1433 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1434 OE_Order_Util.Get_Attribute_Name('Pricing_Phase_id'));
1435 OE_MSG_PUB.Add;
1436 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1437
1438 END IF;
1439
1440
1441 RETURN FALSE;
1442
1443 WHEN OTHERS THEN
1444
1445 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446 THEN
1447 OE_MSG_PUB.Add_Exc_Msg
1448 ( G_PKG_NAME
1449 , 'Pricing_Phase_id'
1450 );
1451 END IF;
1452
1453
1454 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455
1456 END Pricing_Phase_id;
1457
1458
1459 FUNCTION Adjusted_Amount(p_Adjusted_Amount IN NUMBER)
1460 RETURN BOOLEAN
1461 IS
1462 l_dummy VARCHAR2(10);
1463 BEGIN
1464
1465
1466 IF p_Adjusted_Amount IS NULL OR
1467 p_Adjusted_Amount = FND_API.G_MISS_NUM
1468 THEN
1469
1470 RETURN TRUE;
1471 END IF;
1472
1473 -- SELECT 'VALID'
1474 -- INTO l_dummy
1475 -- FROM DB_TABLE
1476 -- WHERE DB_COLUMN = p_price_adjustment_id;
1477
1478
1479 RETURN TRUE;
1480
1481 EXCEPTION
1482
1483 WHEN NO_DATA_FOUND THEN
1484
1485 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1486 THEN
1487
1488 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ADJUSTED_AMOUNT');
1489
1490 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1491 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1492 OE_Order_Util.Get_Attribute_Name('ADJUSTED_AMOUNT'));
1493 OE_MSG_PUB.Add;
1494 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1495
1496 END IF;
1497
1498
1499 RETURN FALSE;
1500
1501 WHEN OTHERS THEN
1502
1503 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504 THEN
1505 OE_MSG_PUB.Add_Exc_Msg
1506 ( G_PKG_NAME
1507 , 'Adjusted_Amount'
1508 );
1509 END IF;
1510
1511
1512 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513
1514 END Adjusted_Amount;
1515
1516
1517
1518 FUNCTION Modified_From(p_Modified_From IN VARCHAR2)
1519 RETURN BOOLEAN
1520 IS
1521 l_dummy VARCHAR2(10);
1522 BEGIN
1523
1524
1525 IF p_Modified_From IS NULL OR
1526 p_Modified_From = FND_API.G_MISS_CHAR
1527 THEN
1528
1529 RETURN TRUE;
1530 END IF;
1531
1532 -- SELECT 'VALID'
1533 -- INTO l_dummy
1534 -- FROM DB_TABLE
1535 -- WHERE DB_COLUMN = p_price_adjustment_id;
1536
1537
1538 RETURN TRUE;
1539
1540 EXCEPTION
1541
1542 WHEN NO_DATA_FOUND THEN
1543
1544 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1545 THEN
1546
1547 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
1548
1549 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1550 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1551 OE_Order_Util.Get_Attribute_Name('Modified_From'));
1552 OE_MSG_PUB.Add;
1553 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1554
1555 END IF;
1556
1557
1558 RETURN FALSE;
1559
1560 WHEN OTHERS THEN
1561
1562 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563 THEN
1564 OE_MSG_PUB.Add_Exc_Msg
1565 ( G_PKG_NAME
1566 , 'Modified_From'
1567 );
1568 END IF;
1569
1570
1571 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1572
1573 END Modified_From;
1574
1575 FUNCTION Modified_To(p_Modified_To IN VARCHAR2)
1576 RETURN BOOLEAN
1577 IS
1578 l_dummy VARCHAR2(10);
1579 BEGIN
1580
1581
1582 IF p_Modified_To IS NULL OR
1583 p_Modified_To = FND_API.G_MISS_CHAR
1584 THEN
1585
1586 RETURN TRUE;
1587 END IF;
1588
1589 -- SELECT 'VALID'
1590 -- INTO l_dummy
1591 -- FROM DB_TABLE
1592 -- WHERE DB_COLUMN = p_price_adjustment_id;
1593
1594
1595 RETURN TRUE;
1596
1597 EXCEPTION
1598
1599 WHEN NO_DATA_FOUND THEN
1600
1601 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1602 THEN
1603
1604 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
1605
1606 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1607 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1608 OE_Order_Util.Get_Attribute_Name('Modified_To'));
1609 OE_MSG_PUB.Add;
1610 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1611
1612 END IF;
1613
1614
1615 RETURN FALSE;
1616
1617 WHEN OTHERS THEN
1618
1619 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620 THEN
1621 OE_MSG_PUB.Add_Exc_Msg
1622 ( G_PKG_NAME
1623 , 'Modified_To'
1624 );
1625 END IF;
1626
1627
1628 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629
1630 END Modified_To;
1631
1632
1633 FUNCTION Modifier_mechanism_type_code(p_Modifier_mechanism_type_code IN VARCHAR2)
1634 RETURN BOOLEAN
1635 IS
1636 l_dummy VARCHAR2(10);
1637 BEGIN
1638
1639
1640 IF p_Modifier_mechanism_type_code IS NULL OR
1641 p_Modifier_mechanism_type_code = FND_API.G_MISS_CHAR
1642 THEN
1643
1644 RETURN TRUE;
1645 END IF;
1646
1647 -- SELECT 'VALID'
1648 -- INTO l_dummy
1649 -- FROM DB_TABLE
1650 -- WHERE DB_COLUMN = p_price_adjustment_id;
1651
1652
1653 RETURN TRUE;
1654
1655 EXCEPTION
1656
1657 WHEN NO_DATA_FOUND THEN
1658
1659 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1660 THEN
1661
1662 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
1663
1664 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1665 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1666 OE_Order_Util.Get_Attribute_Name('Modifier_mechanism_type_code'));
1667 OE_MSG_PUB.Add;
1668 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1669
1670 END IF;
1671
1672
1673 RETURN FALSE;
1674
1675 WHEN OTHERS THEN
1676
1677 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678 THEN
1679 OE_MSG_PUB.Add_Exc_Msg
1680 ( G_PKG_NAME
1681 , 'Modifier_mechanism_type_code'
1682 );
1683 END IF;
1684
1685
1686 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687
1688 END Modifier_mechanism_type_code;
1689
1690
1691
1692 FUNCTION operand(p_operand IN number)
1693 RETURN BOOLEAN
1694 IS
1695 l_dummy VARCHAR2(10);
1696 BEGIN
1697
1698
1699 IF p_Operand IS NULL OR
1700 p_Operand = FND_API.G_MISS_NUM
1701 THEN
1702
1703 RETURN TRUE;
1704 END IF;
1705
1706 -- SELECT 'VALID'
1707 -- INTO l_dummy
1708 -- FROM DB_TABLE
1709 -- WHERE DB_COLUMN = p_price_adjustment_id;
1710
1711
1712 RETURN TRUE;
1713
1714 EXCEPTION
1715
1716 WHEN NO_DATA_FOUND THEN
1717
1718 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1719 THEN
1720
1721 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPERAND');
1722
1723 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1724 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1725 OE_Order_Util.Get_Attribute_Name('Operand'));
1726 OE_MSG_PUB.Add;
1727 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1728
1729 END IF;
1730
1731
1732 RETURN FALSE;
1733
1734 WHEN OTHERS THEN
1735
1736 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1737 THEN
1738 OE_MSG_PUB.Add_Exc_Msg
1739 ( G_PKG_NAME
1740 , 'Operand'
1741 );
1742 END IF;
1743
1744
1745 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746
1747 END operand;
1748
1749
1750 FUNCTION arithmetic_operator(p_arithmetic_operator IN varchar2)
1751 RETURN BOOLEAN
1752 IS
1753 l_dummy VARCHAR2(10);
1754 BEGIN
1755
1756
1757 IF p_arithmetic_operator IS NULL OR
1758 p_arithmetic_operator = FND_API.G_MISS_CHAR
1759 THEN
1760
1761 RETURN TRUE;
1762 END IF;
1763
1764 -- SELECT 'VALID'
1765 -- INTO l_dummy
1766 -- FROM DB_TABLE
1767 -- WHERE DB_COLUMN = p_price_adjustment_id;
1768
1769
1770 RETURN TRUE;
1771
1772 EXCEPTION
1773
1774 WHEN NO_DATA_FOUND THEN
1775
1776 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1777 THEN
1778
1779 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARITHMETIC_OPERATOR');
1780
1781 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1782 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1783 OE_Order_Util.Get_Attribute_Name('Arithmetic_Operator'));
1784 OE_MSG_PUB.Add;
1785 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1786
1787 END IF;
1788
1789
1790 RETURN FALSE;
1791
1792 WHEN OTHERS THEN
1793
1794 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1795 THEN
1796 OE_MSG_PUB.Add_Exc_Msg
1797 ( G_PKG_NAME
1798 , 'Arithmetic_operator'
1799 );
1800 END IF;
1801
1802
1803 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804
1805 END Arithmetic_Operator;
1806
1807 FUNCTION List_Line_NO ( p_List_Line_NO IN VARCHAR2 )
1808 RETURN BOOLEAN
1809 IS
1810 l_dummy VARCHAR2(10);
1811 BEGIN
1812
1813 IF p_List_Line_NO IS NULL OR
1814 p_List_Line_NO = FND_API.G_MISS_CHAR
1815 THEN
1816 RETURN TRUE;
1817 END IF;
1818
1819 -- SELECT 'VALID'
1820 -- INTO l_dummy
1821 -- FROM DB_TABLE
1822 -- WHERE DB_COLUMN = p_List_Line_NO;
1823
1824
1825 RETURN TRUE;
1826
1827 EXCEPTION
1828
1829 WHEN NO_DATA_FOUND THEN
1830
1831
1832 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1833 THEN
1834
1835 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'List_Line_NO');
1836
1837 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1838 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1839 OE_Order_Util.Get_Attribute_Name('List_Line_NO'));
1840 OE_MSG_PUB.Add;
1841 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1842
1843 END IF;
1844
1845
1846 RETURN FALSE;
1847
1848 WHEN OTHERS THEN
1849
1850 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1851 THEN
1852 OE_MSG_PUB.Add_Exc_Msg
1853 ( G_PKG_NAME
1854 , 'List Line NO'
1855 );
1856 END IF;
1857
1858 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859
1860 END List_Line_NO;
1861
1862 FUNCTION Source_System_Code ( p_Source_System_Code IN VARCHAR2 )
1863 RETURN BOOLEAN
1864 IS
1865 l_dummy VARCHAR2(10);
1866 BEGIN
1867
1868 IF p_Source_System_Code IS NULL OR
1869 p_Source_System_Code = FND_API.G_MISS_CHAR
1870 THEN
1871 RETURN TRUE;
1872 END IF;
1873
1874 -- SELECT 'VALID'
1875 -- INTO l_dummy
1876 -- FROM DB_TABLE
1877 -- WHERE DB_COLUMN = p_Source_System_Code;
1878
1879
1880 RETURN TRUE;
1881
1882 EXCEPTION
1883
1884 WHEN NO_DATA_FOUND THEN
1885
1886
1887 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1888 THEN
1889
1890 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Source_System_Code');
1891
1892 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1893 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1894 OE_Order_Util.Get_Attribute_Name('Source_System_Code'));
1895 OE_MSG_PUB.Add;
1896 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1897
1898 END IF;
1899
1900
1901 RETURN FALSE;
1902
1903 WHEN OTHERS THEN
1904
1905 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1906 THEN
1907 OE_MSG_PUB.Add_Exc_Msg
1908 ( G_PKG_NAME
1909 , 'Source System Code'
1910 );
1911 END IF;
1912
1913 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914
1915 END Source_System_Code;
1916
1917 FUNCTION Benefit_Qty ( p_Benefit_Qty IN NUMBER )
1918 RETURN BOOLEAN
1919 IS
1920 l_dummy VARCHAR2(10);
1921 BEGIN
1922
1923 IF p_Benefit_Qty IS NULL OR
1924 p_Benefit_Qty = FND_API.G_MISS_NUM
1925 THEN
1926 RETURN TRUE;
1927 END IF;
1928
1929 -- SELECT 'VALID'
1930 -- INTO l_dummy
1931 -- FROM DB_TABLE
1932 -- WHERE DB_COLUMN = p_Benefit_Qty;
1933
1934
1935 RETURN TRUE;
1936
1937 EXCEPTION
1938
1939 WHEN NO_DATA_FOUND THEN
1940
1941
1942 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1943 THEN
1944
1945 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_Qty');
1946
1947 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1948 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949 OE_Order_Util.Get_Attribute_Name('Benefit_Qty'));
1950 OE_MSG_PUB.Add;
1951 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952
1953 END IF;
1954
1955
1956 RETURN FALSE;
1957
1958 WHEN OTHERS THEN
1959
1960 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1961 THEN
1962 OE_MSG_PUB.Add_Exc_Msg
1963 ( G_PKG_NAME
1964 , 'Benefit Qty'
1965 );
1966 END IF;
1967
1968 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969
1970 END Benefit_Qty;
1971
1972 FUNCTION Benefit_UOM_Code ( p_Benefit_UOM_Code IN VARCHAR2 )
1973 RETURN BOOLEAN
1974 IS
1975 l_dummy VARCHAR2(10);
1976 BEGIN
1977
1978 IF p_Benefit_UOM_Code IS NULL OR
1979 p_Benefit_UOM_Code = FND_API.G_MISS_CHAR
1980 THEN
1981 RETURN TRUE;
1982 END IF;
1983
1984 -- SELECT 'VALID'
1985 -- INTO l_dummy
1986 -- FROM DB_TABLE
1987 -- WHERE DB_COLUMN = p_Benefit_UOM_Code;
1988
1989
1990 RETURN TRUE;
1991
1992 EXCEPTION
1993
1994 WHEN NO_DATA_FOUND THEN
1995
1996
1997 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1998 THEN
1999
2000 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_UOM_Code');
2001
2002 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2003 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2004 OE_Order_Util.Get_Attribute_Name('Benefit_UOM_Code'));
2005 OE_MSG_PUB.Add;
2006 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2007
2008 END IF;
2009
2010
2011 RETURN FALSE;
2012
2013 WHEN OTHERS THEN
2014
2015 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2016 THEN
2017 OE_MSG_PUB.Add_Exc_Msg
2018 ( G_PKG_NAME
2019 , 'Benefit UOM Code '
2020 );
2021 END IF;
2022
2023 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024
2025 END Benefit_UOM_Code;
2026
2027 FUNCTION Print_On_Invoice_Flag ( p_Print_On_Invoice_Flag IN VARCHAR2 )
2028 RETURN BOOLEAN
2029 IS
2030 l_dummy VARCHAR2(10);
2031 BEGIN
2032
2033 IF p_Print_On_Invoice_Flag IS NULL OR
2034 p_Print_On_Invoice_Flag = FND_API.G_MISS_CHAR
2035 THEN
2036 RETURN TRUE;
2037 END IF;
2038
2039 -- SELECT 'VALID'
2040 -- INTO l_dummy
2041 -- FROM DB_TABLE
2042 -- WHERE DB_COLUMN = p_Print_On_Invoice_Flag;
2043
2044
2045 RETURN TRUE;
2046
2047 EXCEPTION
2048
2049 WHEN NO_DATA_FOUND THEN
2050
2051
2052 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2053 THEN
2054
2055 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Print_On_Invoice_Flag');
2056
2057 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2058 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2059 OE_Order_Util.Get_Attribute_Name('Print_On_Invoice_Flag'));
2060 OE_MSG_PUB.Add;
2061 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2062
2063 END IF;
2064
2065
2066 RETURN FALSE;
2067
2068 WHEN OTHERS THEN
2069
2070 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071 THEN
2072 OE_MSG_PUB.Add_Exc_Msg
2073 ( G_PKG_NAME
2074 , 'Print On Invoice Flag'
2075 );
2076 END IF;
2077
2078 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2079
2080 END Print_On_Invoice_Flag;
2081
2082 FUNCTION Expiration_Date ( p_Expiration_Date IN DATE )
2083 RETURN BOOLEAN
2084 IS
2085 l_dummy VARCHAR2(10);
2086 BEGIN
2087
2088 IF p_Expiration_Date IS NULL OR
2089 p_Expiration_Date = FND_API.G_MISS_DATE
2090 THEN
2091 RETURN TRUE;
2092 END IF;
2093
2094 -- SELECT 'VALID'
2095 -- INTO l_dummy
2096 -- FROM DB_TABLE
2097 -- WHERE DB_COLUMN = p_Expiration_Date;
2098
2099
2100 RETURN TRUE;
2101
2102 EXCEPTION
2103
2104 WHEN NO_DATA_FOUND THEN
2105
2106
2107 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2108 THEN
2109
2110 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Expiration_Date');
2111
2112 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2113 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2114 OE_Order_Util.Get_Attribute_Name('Expiration_Date'));
2115 OE_MSG_PUB.Add;
2116 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2117
2118 END IF;
2119
2120
2121 RETURN FALSE;
2122
2123 WHEN OTHERS THEN
2124
2125 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2126 THEN
2127 OE_MSG_PUB.Add_Exc_Msg
2128 ( G_PKG_NAME
2129 , 'Expiration Date'
2130 );
2131 END IF;
2132
2133 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2134
2135 END Expiration_Date;
2136
2137 FUNCTION Rebate_Transaction_Type_Code ( p_Rebate_Transaction_Type_Code IN VARCHAR2 )
2138 RETURN BOOLEAN
2139 IS
2140 l_dummy VARCHAR2(10);
2141 BEGIN
2142
2143 IF p_Rebate_Transaction_Type_Code IS NULL OR
2144 p_Rebate_Transaction_Type_Code = FND_API.G_MISS_CHAR
2145 THEN
2146 RETURN TRUE;
2147 END IF;
2148
2149 -- SELECT 'VALID'
2150 -- INTO l_dummy
2151 -- FROM DB_TABLE
2152 -- WHERE DB_COLUMN = p_Rebate_Transaction_Type_Code;
2153
2154
2155 RETURN TRUE;
2156
2157 EXCEPTION
2158
2159 WHEN NO_DATA_FOUND THEN
2160
2161
2162 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2163 THEN
2164
2165 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Type_Code');
2166
2167 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2168 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2169 OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Type_Code'));
2170 OE_MSG_PUB.Add;
2171 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2172
2173 END IF;
2174
2175
2176 RETURN FALSE;
2177
2178 WHEN OTHERS THEN
2179
2180 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181 THEN
2182 OE_MSG_PUB.Add_Exc_Msg
2183 ( G_PKG_NAME
2184 , 'Rebate Transaction Type Code'
2185 );
2186 END IF;
2187
2188 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189
2190 END Rebate_Transaction_Type_Code;
2191
2192 FUNCTION Rebate_Transaction_Reference ( p_Rebate_Transaction_Reference IN VARCHAR2 )
2193 RETURN BOOLEAN
2194 IS
2195 l_dummy VARCHAR2(10);
2196 BEGIN
2197
2198 IF p_Rebate_Transaction_Reference IS NULL OR
2199 p_Rebate_Transaction_Reference = FND_API.G_MISS_CHAR
2200 THEN
2201 RETURN TRUE;
2202 END IF;
2203
2204 -- SELECT 'VALID'
2205 -- INTO l_dummy
2206 -- FROM DB_TABLE
2207 -- WHERE DB_COLUMN = p_Rebate_Transaction_Reference;
2208
2209
2210 RETURN TRUE;
2211
2212 EXCEPTION
2213
2214 WHEN NO_DATA_FOUND THEN
2215
2216
2217 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2218 THEN
2219
2220 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Reference');
2221
2222 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2223 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2224 OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Reference'));
2225 OE_MSG_PUB.Add;
2226 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2227
2228 END IF;
2229
2230
2231 RETURN FALSE;
2232
2233 WHEN OTHERS THEN
2234
2235 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2236 THEN
2237 OE_MSG_PUB.Add_Exc_Msg
2238 ( G_PKG_NAME
2239 , 'Rebate_Transaction_Reference'
2240 );
2241 END IF;
2242
2243 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244
2245 END Rebate_Transaction_Reference;
2246
2247 FUNCTION Rebate_Payment_System_Code ( p_Rebate_Payment_System_Code IN VARCHAR2 )
2248 RETURN BOOLEAN
2249 IS
2250 l_dummy VARCHAR2(10);
2251 BEGIN
2252
2253 IF p_Rebate_Payment_System_Code IS NULL OR
2254 p_Rebate_Payment_System_Code = FND_API.G_MISS_CHAR
2255 THEN
2256 RETURN TRUE;
2257 END IF;
2258
2259 -- SELECT 'VALID'
2260 -- INTO l_dummy
2261 -- FROM DB_TABLE
2262 -- WHERE DB_COLUMN = p_Rebate_Payment_System_Code;
2263
2264
2265 RETURN TRUE;
2266
2267 EXCEPTION
2268
2269 WHEN NO_DATA_FOUND THEN
2270
2271
2272 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2273 THEN
2274
2275 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Payment_System_Code');
2276
2277 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2278 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2279 OE_Order_Util.Get_Attribute_Name('Rebate_Payment_System_Code'));
2280 OE_MSG_PUB.Add;
2281 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2282
2283 END IF;
2284
2285
2286 RETURN FALSE;
2287
2288 WHEN OTHERS THEN
2289
2290 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291 THEN
2292 OE_MSG_PUB.Add_Exc_Msg
2293 ( G_PKG_NAME
2294 , 'Rebate Payment System Code'
2295 );
2296 END IF;
2297
2298 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2299
2300 END Rebate_Payment_System_Code;
2301
2302 FUNCTION Redeemed_Date ( p_Redeemed_Date IN DATE )
2303 RETURN BOOLEAN
2304 IS
2305 l_dummy VARCHAR2(10);
2306 BEGIN
2307
2308 IF p_Redeemed_Date IS NULL OR
2309 p_Redeemed_Date = FND_API.G_MISS_DATE
2310 THEN
2311 RETURN TRUE;
2312 END IF;
2313
2314 -- SELECT 'VALID'
2315 -- INTO l_dummy
2316 -- FROM DB_TABLE
2317 -- WHERE DB_COLUMN = p_Redeemed_Date;
2318
2319
2320 RETURN TRUE;
2321
2322 EXCEPTION
2323
2324 WHEN NO_DATA_FOUND THEN
2325
2326
2327 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2328 THEN
2329
2330 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Date');
2331
2332 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2333 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2334 OE_Order_Util.Get_Attribute_Name('Redeemed_Date'));
2335 OE_MSG_PUB.Add;
2336 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2337
2338 END IF;
2339
2340
2341 RETURN FALSE;
2342
2343 WHEN OTHERS THEN
2344
2345 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346 THEN
2347 OE_MSG_PUB.Add_Exc_Msg
2348 ( G_PKG_NAME
2349 , 'Redeemed Date'
2350 );
2351 END IF;
2352
2353 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354
2355 END Redeemed_Date;
2356
2357 FUNCTION Redeemed_Flag ( p_Redeemed_Flag IN VARCHAR2 )
2358 RETURN BOOLEAN
2359 IS
2360 l_dummy VARCHAR2(10);
2361 BEGIN
2362
2363 IF p_Redeemed_Flag IS NULL OR
2364 p_Redeemed_Flag = FND_API.G_MISS_CHAR
2365 THEN
2366 RETURN TRUE;
2367 END IF;
2368
2369 -- SELECT 'VALID'
2370 -- INTO l_dummy
2371 -- FROM DB_TABLE
2372 -- WHERE DB_COLUMN = p_Redeemed_Flag;
2373
2374
2375 RETURN TRUE;
2376
2377 EXCEPTION
2378
2379 WHEN NO_DATA_FOUND THEN
2380
2381
2382 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2383 THEN
2384
2385 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Flag');
2386
2387 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2388 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2389 OE_Order_Util.Get_Attribute_Name('Redeemed_Flag'));
2390 OE_MSG_PUB.Add;
2391 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2392
2393 END IF;
2394
2395
2396 RETURN FALSE;
2397
2398 WHEN OTHERS THEN
2399
2400 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2401 THEN
2402 OE_MSG_PUB.Add_Exc_Msg
2403 ( G_PKG_NAME
2404 , 'Redeemed Flag'
2405 );
2406 END IF;
2407
2408 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409
2410 END Redeemed_Flag;
2411
2412 FUNCTION Accrual_Flag ( p_Accrual_Flag IN VARCHAR2 )
2413 RETURN BOOLEAN
2414 IS
2415 l_dummy VARCHAR2(10);
2416 BEGIN
2417
2418 IF p_Accrual_Flag IS NULL OR
2419 p_Accrual_Flag = FND_API.G_MISS_CHAR
2420 THEN
2421 RETURN TRUE;
2422 END IF;
2423
2424 -- SELECT 'VALID'
2425 -- INTO l_dummy
2426 -- FROM DB_TABLE
2427 -- WHERE DB_COLUMN = p_Accrual_Flag;
2428
2429
2430 RETURN TRUE;
2431
2432 EXCEPTION
2433
2434 WHEN NO_DATA_FOUND THEN
2435
2436
2437 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2438 THEN
2439
2440 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Accrual_Flag');
2441
2442 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2443 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2444 OE_Order_Util.Get_Attribute_Name('Accrual_Flag'));
2445 OE_MSG_PUB.Add;
2446 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2447
2448 END IF;
2449
2450
2451 RETURN FALSE;
2452
2453 WHEN OTHERS THEN
2454
2455 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2456 THEN
2457 OE_MSG_PUB.Add_Exc_Msg
2458 ( G_PKG_NAME
2459 , 'Accrual Flag'
2460 );
2461 END IF;
2462
2463 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464
2465 END Accrual_Flag;
2466
2467 FUNCTION range_break_quantity ( p_range_break_quantity IN NUMBER )
2468 RETURN BOOLEAN
2469 IS
2470 l_dummy VARCHAR2(10);
2471 BEGIN
2472
2473 IF p_range_break_quantity IS NULL OR
2474 p_range_break_quantity = FND_API.G_MISS_NUM
2475 THEN
2476 RETURN TRUE;
2477 END IF;
2478
2479 -- SELECT 'VALID'
2480 -- INTO l_dummy
2481 -- FROM DB_TABLE
2482 -- WHERE DB_COLUMN = p_range_break_quantity;
2483
2484
2485 RETURN TRUE;
2486
2487 EXCEPTION
2488
2489 WHEN NO_DATA_FOUND THEN
2490
2491
2492 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2493 THEN
2494
2495 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'range_break_quantity');
2496
2497 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2498 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2499 OE_Order_Util.Get_Attribute_Name('range_break_quantity'));
2500 OE_MSG_PUB.Add;
2501 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2502
2503 END IF;
2504
2505
2506 RETURN FALSE;
2507
2508 WHEN OTHERS THEN
2509
2510 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511 THEN
2512 OE_MSG_PUB.Add_Exc_Msg
2513 ( G_PKG_NAME
2514 , 'range_break_quantity'
2515 );
2516 END IF;
2517
2518 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2519
2520 END range_break_quantity;
2521
2522 FUNCTION accrual_conversion_rate ( p_accrual_conversion_rate IN NUMBER )
2523 RETURN BOOLEAN
2524 IS
2525 l_dummy VARCHAR2(10);
2526 BEGIN
2527
2528 IF p_accrual_conversion_rate IS NULL OR
2529 p_accrual_conversion_rate = FND_API.G_MISS_NUM
2530 THEN
2531 RETURN TRUE;
2532 END IF;
2533
2534 -- SELECT 'VALID'
2535 -- INTO l_dummy
2536 -- FROM DB_TABLE
2537 -- WHERE DB_COLUMN = p_accrual_conversion_rate;
2538
2539
2540 RETURN TRUE;
2541
2542 EXCEPTION
2543
2544 WHEN NO_DATA_FOUND THEN
2545
2546
2547 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2548 THEN
2549
2550 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'accrual_conversion_rate');
2551
2552 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2553 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2554 OE_Order_Util.Get_Attribute_Name('accrual_conversion_rate'));
2555 OE_MSG_PUB.Add;
2556 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2557
2558 END IF;
2559
2560
2561 RETURN FALSE;
2562
2563 WHEN OTHERS THEN
2564
2565 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2566 THEN
2567 OE_MSG_PUB.Add_Exc_Msg
2568 ( G_PKG_NAME
2569 , 'accrual_conversion_rate'
2570 );
2571 END IF;
2572
2573 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574
2575 END accrual_conversion_rate;
2576
2577 FUNCTION pricing_group_sequence ( p_pricing_group_sequence IN NUMBER )
2578 RETURN BOOLEAN
2579 IS
2580 l_dummy VARCHAR2(10);
2581 BEGIN
2582
2583 IF p_pricing_group_sequence IS NULL OR
2584 p_pricing_group_sequence = FND_API.G_MISS_NUM
2585 THEN
2586 RETURN TRUE;
2587 END IF;
2588
2589 -- SELECT 'VALID'
2590 -- INTO l_dummy
2591 -- FROM DB_TABLE
2592 -- WHERE DB_COLUMN = p_pricing_group_sequence;
2593
2594
2595 RETURN TRUE;
2596
2597 EXCEPTION
2598
2599 WHEN NO_DATA_FOUND THEN
2600
2601
2602 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2603 THEN
2604
2605 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'pricing_group_sequence');
2606
2607 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2609 OE_Order_Util.Get_Attribute_Name('pricing_group_sequence'));
2610 OE_MSG_PUB.Add;
2611 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2612
2613 END IF;
2614
2615
2616 RETURN FALSE;
2617
2618 WHEN OTHERS THEN
2619
2620 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2621 THEN
2622 OE_MSG_PUB.Add_Exc_Msg
2623 ( G_PKG_NAME
2624 , 'pricing_group_sequence'
2625 );
2626 END IF;
2627
2628 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2629
2630 END pricing_group_sequence;
2631
2632 FUNCTION modifier_level_code ( p_modifier_level_code IN VARCHAR2 )
2633 RETURN BOOLEAN
2634 IS
2635 l_dummy VARCHAR2(10);
2636 BEGIN
2637
2638 IF p_modifier_level_code IS NULL OR
2639 p_modifier_level_code = FND_API.G_MISS_CHAR
2640 THEN
2641 RETURN TRUE;
2642 END IF;
2643
2644 -- SELECT 'VALID'
2645 -- INTO l_dummy
2646 -- FROM DB_TABLE
2647 -- WHERE DB_COLUMN = p_modifier_level_code;
2648
2649
2650 RETURN TRUE;
2651
2652 EXCEPTION
2653
2654 WHEN NO_DATA_FOUND THEN
2655
2656
2657 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2658 THEN
2659
2660 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'modifier_level_code');
2661
2662 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2664 OE_Order_Util.Get_Attribute_Name('modifier_level_code'));
2665 OE_MSG_PUB.Add;
2666 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2667
2668 END IF;
2669
2670
2671 RETURN FALSE;
2672
2673 WHEN OTHERS THEN
2674
2675 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2676 THEN
2677 OE_MSG_PUB.Add_Exc_Msg
2678 ( G_PKG_NAME
2679 , 'modifier_level_code'
2680 );
2681 END IF;
2682
2683 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2684
2685 END modifier_level_code;
2686
2687 FUNCTION price_break_type_code ( p_price_break_type_code IN VARCHAR2 )
2688 RETURN BOOLEAN
2689 IS
2690 l_dummy VARCHAR2(10);
2691 BEGIN
2692
2693 IF p_price_break_type_code IS NULL OR
2694 p_price_break_type_code = FND_API.G_MISS_CHAR
2695 THEN
2696 RETURN TRUE;
2697 END IF;
2698
2699 -- SELECT 'VALID'
2700 -- INTO l_dummy
2701 -- FROM DB_TABLE
2702 -- WHERE DB_COLUMN = p_price_break_type_code;
2703
2704
2705 RETURN TRUE;
2706
2707 EXCEPTION
2708
2709 WHEN NO_DATA_FOUND THEN
2710
2711
2712 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2713 THEN
2714
2715 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'price_break_type_code');
2716
2717 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2718 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2719 OE_Order_Util.Get_Attribute_Name('price_break_type_code'));
2720 OE_MSG_PUB.Add;
2721 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2722
2723 END IF;
2724
2725
2726 RETURN FALSE;
2727
2728 WHEN OTHERS THEN
2729
2730 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2731 THEN
2732 OE_MSG_PUB.Add_Exc_Msg
2733 ( G_PKG_NAME
2734 , 'price_break_type_code'
2735 );
2736 END IF;
2737
2738 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739
2740 END price_break_type_code;
2741
2742 FUNCTION substitution_attribute ( p_substitution_attribute IN VARCHAR2 )
2743 RETURN BOOLEAN
2744 IS
2745 l_dummy VARCHAR2(10);
2746 BEGIN
2747
2748 IF p_substitution_attribute IS NULL OR
2749 p_substitution_attribute = FND_API.G_MISS_CHAR
2750 THEN
2751 RETURN TRUE;
2752 END IF;
2753
2754 -- SELECT 'VALID'
2755 -- INTO l_dummy
2756 -- FROM DB_TABLE
2757 -- WHERE DB_COLUMN = p_substitution_attribute;
2758
2759
2760 RETURN TRUE;
2761
2762 EXCEPTION
2763
2764 WHEN NO_DATA_FOUND THEN
2765
2766
2767 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2768 THEN
2769
2770 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'substitution_attribute');
2771
2772 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2773 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2774 OE_Order_Util.Get_Attribute_Name('substitution_attribute'));
2775 OE_MSG_PUB.Add;
2776 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2777
2778 END IF;
2779
2780
2781 RETURN FALSE;
2782
2783 WHEN OTHERS THEN
2784
2785 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2786 THEN
2787 OE_MSG_PUB.Add_Exc_Msg
2788 ( G_PKG_NAME
2789 , 'substitution_attribute'
2790 );
2791 END IF;
2792
2793 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2794
2795 END substitution_attribute;
2796
2797 FUNCTION proration_type_code ( p_proration_type_code IN VARCHAR2 )
2798 RETURN BOOLEAN
2799 IS
2800 l_dummy VARCHAR2(10);
2801 BEGIN
2802
2803 IF p_proration_type_code IS NULL OR
2804 p_proration_type_code = FND_API.G_MISS_CHAR
2805 THEN
2806 RETURN TRUE;
2807 END IF;
2808
2809 -- SELECT 'VALID'
2810 -- INTO l_dummy
2811 -- FROM DB_TABLE
2812 -- WHERE DB_COLUMN = p_proration_type_code;
2813
2814
2815 RETURN TRUE;
2816
2817 EXCEPTION
2818
2819 WHEN NO_DATA_FOUND THEN
2820
2821
2822 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2823 THEN
2824
2825 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'proration_type_code');
2826
2827 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2828 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2829 OE_Order_Util.Get_Attribute_Name('proration_type_code'));
2830 OE_MSG_PUB.Add;
2831 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2832
2833 END IF;
2834
2835
2836 RETURN FALSE;
2837
2838 WHEN OTHERS THEN
2839
2840 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2841 THEN
2842 OE_MSG_PUB.Add_Exc_Msg
2843 ( G_PKG_NAME
2844 , 'proration_type_code'
2845 );
2846 END IF;
2847
2848 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2849
2850 END proration_type_code;
2851
2852 FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)
2853 RETURN BOOLEAN
2854 IS
2855 l_dummy VARCHAR2(10);
2856 BEGIN
2857
2858
2859 IF p_Updated_Flag IS NULL OR
2860 p_Updated_Flag = FND_API.G_MISS_CHAR
2861 THEN
2862
2863 RETURN TRUE;
2864 END IF;
2865
2866 -- SELECT 'VALID'
2867 -- INTO l_dummy
2868 -- FROM DB_TABLE
2869 -- WHERE DB_COLUMN = p_price_adjustment_id;
2870
2871
2872 RETURN TRUE;
2873
2874 EXCEPTION
2875
2876 WHEN NO_DATA_FOUND THEN
2877
2878 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2879 THEN
2880
2881 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
2882
2883 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2884 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2885 OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
2886 OE_MSG_PUB.Add;
2887 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2888
2889 END IF;
2890
2891
2892 RETURN FALSE;
2893
2894 WHEN OTHERS THEN
2895
2896 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2897 THEN
2898 OE_MSG_PUB.Add_Exc_Msg
2899 ( G_PKG_NAME
2900 , 'Updated_Flag'
2901 );
2902 END IF;
2903
2904
2905 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906
2907 END Updated_Flag;
2908
2909
2910 FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)
2911 RETURN BOOLEAN
2912 IS
2913 l_dummy VARCHAR2(10);
2914 BEGIN
2915
2916
2917 IF p_Update_Allowed IS NULL OR
2918 p_Update_Allowed = FND_API.G_MISS_CHAR
2919 THEN
2920
2921 RETURN TRUE;
2922 END IF;
2923
2924 -- SELECT 'VALID'
2925 -- INTO l_dummy
2926 -- FROM DB_TABLE
2927 -- WHERE DB_COLUMN = p_price_adjustment_id;
2928
2929
2930 RETURN TRUE;
2931
2932 EXCEPTION
2933
2934 WHEN NO_DATA_FOUND THEN
2935
2936 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2937 THEN
2938
2939 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
2940
2941 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2942 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2943 OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
2944 OE_MSG_PUB.Add;
2945 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2946
2947 END IF;
2948
2949
2950 RETURN FALSE;
2951
2952 WHEN OTHERS THEN
2953
2954 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2955 THEN
2956 OE_MSG_PUB.Add_Exc_Msg
2957 ( G_PKG_NAME
2958 , 'Update_Allowed'
2959 );
2960 END IF;
2961
2962
2963 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2964
2965 END Update_Allowed;
2966
2967
2968 FUNCTION Created_By ( p_created_by IN NUMBER )
2969 RETURN BOOLEAN
2970 IS
2971 l_dummy VARCHAR2(10);
2972 BEGIN
2973
2974
2975 IF p_created_by IS NULL OR
2976 p_created_by = FND_API.G_MISS_NUM
2977 THEN
2978
2979 RETURN TRUE;
2980 END IF;
2981
2982 -- SELECT 'VALID'
2983 -- INTO l_dummy
2984 -- FROM DB_TABLE
2985 -- WHERE DB_COLUMN = p_created_by;
2986
2987
2988 RETURN TRUE;
2989
2990 EXCEPTION
2991
2992 WHEN NO_DATA_FOUND THEN
2993
2994 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2995 THEN
2996
2997 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
2998
2999 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3000 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3001 OE_Order_Util.Get_Attribute_Name('created_by'));
3002 OE_MSG_PUB.Add;
3003 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3004
3005 END IF;
3006
3007
3008 RETURN FALSE;
3009
3010 WHEN OTHERS THEN
3011
3012 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013 THEN
3014 OE_MSG_PUB.Add_Exc_Msg
3015 ( G_PKG_NAME
3016 , 'Created_By'
3017 );
3018 END IF;
3019
3020
3021 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022
3023 END Created_By;
3024
3025 FUNCTION Creation_Date ( p_creation_date IN DATE )
3026 RETURN BOOLEAN
3027 IS
3028 l_dummy VARCHAR2(10);
3029 BEGIN
3030
3031
3032 IF p_creation_date IS NULL OR
3033 p_creation_date = FND_API.G_MISS_DATE
3034 THEN
3035
3036 RETURN TRUE;
3037 END IF;
3038
3039 -- SELECT 'VALID'
3040 -- INTO l_dummy
3041 -- FROM DB_TABLE
3042 -- WHERE DB_COLUMN = p_creation_date;
3043
3044
3045 RETURN TRUE;
3046
3047 EXCEPTION
3048
3049 WHEN NO_DATA_FOUND THEN
3050
3051 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3052 THEN
3053
3054 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
3055
3056 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3057 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3058 OE_Order_Util.Get_Attribute_Name('creation_date'));
3059 OE_MSG_PUB.Add;
3060 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3061
3062 END IF;
3063
3064
3065 RETURN FALSE;
3066
3067 WHEN OTHERS THEN
3068
3069 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3070 THEN
3071 OE_MSG_PUB.Add_Exc_Msg
3072 ( G_PKG_NAME
3073 , 'Creation_Date'
3074 );
3075 END IF;
3076
3077
3078 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079
3080 END Creation_Date;
3081
3082 --
3083
3084 FUNCTION Override_Flag ( p_override_flag IN VARCHAR2 )
3085 RETURN BOOLEAN
3086 IS
3087 l_dummy VARCHAR2(10);
3088 BEGIN
3089
3090
3091 IF p_override_flag IS NULL OR
3092 p_override_flag = FND_API.G_MISS_CHAR
3093 THEN
3094
3095 RETURN TRUE;
3096 END IF;
3097
3098 -- SELECT 'VALID'
3099 -- INTO l_dummy
3100 -- FROM DB_TABLE
3101 -- WHERE DB_COLUMN = p_request_date;
3102
3103
3104 RETURN TRUE;
3105
3106 EXCEPTION
3107
3108 WHEN NO_DATA_FOUND THEN
3109
3110 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3111 THEN
3112
3113 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVERRIDE_FLAG');
3114
3115 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3116 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3117 OE_Order_Util.Get_Attribute_Name('override_flag'));
3118 OE_MSG_PUB.Add;
3119 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3120
3121 END IF;
3122
3123
3124 RETURN FALSE;
3125
3126 WHEN OTHERS THEN
3127
3128 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3129 THEN
3130 OE_MSG_PUB.Add_Exc_Msg
3131 ( G_PKG_NAME
3132 , 'override_flag'
3133 );
3134 END IF;
3135
3136
3137 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138
3139 END Override_Flag;
3140
3141 --
3142 FUNCTION Request_Date ( p_request_date IN DATE )
3143 RETURN BOOLEAN
3144 IS
3145 l_dummy VARCHAR2(10);
3146 BEGIN
3147
3148
3149 IF p_request_date IS NULL OR
3150 p_request_date = FND_API.G_MISS_DATE
3151 THEN
3152
3153 RETURN TRUE;
3154 END IF;
3155
3156 -- SELECT 'VALID'
3157 -- INTO l_dummy
3158 -- FROM DB_TABLE
3159 -- WHERE DB_COLUMN = p_request_date;
3160
3161
3162 RETURN TRUE;
3163
3164 EXCEPTION
3165
3166 WHEN NO_DATA_FOUND THEN
3167
3168 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3169 THEN
3170
3171 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
3172
3173 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3174 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3175 OE_Order_Util.Get_Attribute_Name('request_date'));
3176 OE_MSG_PUB.Add;
3177 OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3178
3179 END IF;
3180
3181
3182 RETURN FALSE;
3183
3184 WHEN OTHERS THEN
3185
3186 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3187 THEN
3188 OE_MSG_PUB.Add_Exc_Msg
3189 ( G_PKG_NAME
3190 , 'Request_Date'
3191 );
3192 END IF;
3193
3194
3195 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196
3197 END Request_Date;
3198
3199 FUNCTION Price_Adj_Desc_Flex (p_context IN VARCHAR2,
3200 p_attribute1 IN VARCHAR2,
3201 p_attribute2 IN VARCHAR2,
3202 p_attribute3 IN VARCHAR2,
3203 p_attribute4 IN VARCHAR2,
3204 p_attribute5 IN VARCHAR2,
3205 p_attribute6 IN VARCHAR2,
3206 p_attribute7 IN VARCHAR2,
3207 p_attribute8 IN VARCHAR2,
3208 p_attribute9 IN VARCHAR2,
3209 p_attribute10 IN VARCHAR2,
3210 p_attribute11 IN VARCHAR2,
3211 p_attribute12 IN VARCHAR2,
3212 p_attribute13 IN VARCHAR2,
3213 p_attribute14 IN VARCHAR2,
3214 p_attribute15 IN VARCHAR2)
3215
3216 RETURN BOOLEAN
3217 IS
3218 l_column_value VARCHAR2(240) := null;
3219 BEGIN
3220
3221 -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3222
3223 IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224 AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225 AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226 AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227 AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228 AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229 AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230 AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231 AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232 AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233 AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234 AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235 AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236 AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237 AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238 AND (p_context = FND_API.G_MISS_CHAR) THEN
3239
3240
3241 RETURN TRUE;
3242
3243 ELSE
3244
3245
3246 IF p_attribute1 = FND_API.G_MISS_CHAR THEN
3247
3248 l_column_value := null;
3249
3250 ELSE
3251
3252 l_column_value := p_attribute1;
3253
3254 END IF;
3255
3256 FND_FLEX_DESCVAL.Set_Column_Value
3257 ( column_name => 'ATTRIBUTE1'
3258 , column_value => l_column_value);
3259
3260
3261 IF p_attribute2 = FND_API.G_MISS_CHAR THEN
3262
3263 l_column_value := null;
3264
3265 ELSE
3266
3267 l_column_value := p_attribute2;
3268
3269 END IF;
3270 FND_FLEX_DESCVAL.Set_Column_Value
3271 ( column_name => 'ATTRIBUTE2'
3272 , column_value => l_column_value);
3273
3274 IF p_attribute3 = FND_API.G_MISS_CHAR THEN
3275
3276 l_column_value := null;
3277
3278 ELSE
3279
3280 l_column_value := p_attribute3;
3281
3282 END IF;
3283 FND_FLEX_DESCVAL.Set_Column_Value
3284 ( column_name => 'ATTRIBUTE3'
3285 , column_value => l_column_value);
3286
3287 IF p_attribute4 = FND_API.G_MISS_CHAR THEN
3288
3289 l_column_value := null;
3290
3291 ELSE
3292
3293 l_column_value := p_attribute4;
3294
3295 END IF;
3296 FND_FLEX_DESCVAL.Set_Column_Value
3297 ( column_name => 'ATTRIBUTE4'
3298 , column_value => l_column_value);
3299
3300 IF p_attribute5 = FND_API.G_MISS_CHAR THEN
3301
3302 l_column_value := null;
3303
3304 ELSE
3305
3306 l_column_value := p_attribute5;
3307
3308 END IF;
3309 FND_FLEX_DESCVAL.Set_Column_Value
3310 ( column_name => 'ATTRIBUTE5'
3311 , column_value => l_column_value);
3312
3313 IF p_attribute6 = FND_API.G_MISS_CHAR THEN
3314
3315 l_column_value := null;
3316
3317 ELSE
3318
3319 l_column_value := p_attribute6;
3320
3321 END IF;
3322 FND_FLEX_DESCVAL.Set_Column_Value
3323 ( column_name => 'ATTRIBUTE6'
3324 , column_value => l_column_value);
3325
3326 IF p_attribute7 = FND_API.G_MISS_CHAR THEN
3327
3328 l_column_value := null;
3329
3330 ELSE
3331
3332 l_column_value := p_attribute7;
3333
3334 END IF;
3335 FND_FLEX_DESCVAL.Set_Column_Value
3336 ( column_name => 'ATTRIBUTE7'
3337 , column_value => l_column_value);
3338
3339 IF p_attribute8 = FND_API.G_MISS_CHAR THEN
3340
3341 l_column_value := null;
3342
3343 ELSE
3344
3345 l_column_value := p_attribute8;
3346
3347 END IF;
3348 FND_FLEX_DESCVAL.Set_Column_Value
3349 ( column_name => 'ATTRIBUTE8'
3350 , column_value => l_column_value);
3351
3352 IF p_attribute9 = FND_API.G_MISS_CHAR THEN
3353
3354 l_column_value := null;
3355
3356 ELSE
3357
3358 l_column_value := p_attribute9;
3359
3360 END IF;
3361 FND_FLEX_DESCVAL.Set_Column_Value
3362 ( column_name => 'ATTRIBUTE9'
3363 , column_value => l_column_value);
3364
3365 IF p_attribute10 = FND_API.G_MISS_CHAR THEN
3366
3367 l_column_value := null;
3368
3369 ELSE
3370
3371 l_column_value := p_attribute10;
3372
3373 END IF;
3374 FND_FLEX_DESCVAL.Set_Column_Value
3375 ( column_name => 'ATTRIBUTE10'
3376 , column_value => l_column_value);
3377
3378 IF p_attribute11 = FND_API.G_MISS_CHAR THEN
3379
3380 l_column_value := null;
3381
3382 ELSE
3383
3384 l_column_value := p_attribute11;
3385
3386 END IF;
3387 FND_FLEX_DESCVAL.Set_Column_Value
3388 ( column_name => 'ATTRIBUTE11'
3389 , column_value => l_column_value);
3390
3391 IF p_attribute12 = FND_API.G_MISS_CHAR THEN
3392
3393 l_column_value := null;
3394
3395 ELSE
3396
3397 l_column_value := p_attribute12;
3398
3399 END IF;
3400 FND_FLEX_DESCVAL.Set_Column_Value
3401 ( column_name => 'ATTRIBUTE12'
3402 , column_value => l_column_value);
3403
3404 IF p_attribute13 = FND_API.G_MISS_CHAR THEN
3405
3406 l_column_value := null;
3407
3408 ELSE
3409
3410 l_column_value := p_attribute13;
3411
3412 END IF;
3413 FND_FLEX_DESCVAL.Set_Column_Value
3414 ( column_name => 'ATTRIBUTE13'
3415 , column_value => l_column_value);
3416
3417 IF p_attribute14 = FND_API.G_MISS_CHAR THEN
3418
3419 l_column_value := null;
3420
3421 ELSE
3422
3423 l_column_value := p_attribute14;
3424
3425 END IF;
3426 FND_FLEX_DESCVAL.Set_Column_Value
3427 ( column_name => 'ATTRIBUTE14'
3428 , column_value => l_column_value);
3429
3430 IF p_attribute15 = FND_API.G_MISS_CHAR THEN
3431
3432 l_column_value := null;
3433
3434 ELSE
3435
3436 l_column_value := p_attribute15;
3437
3438 END IF;
3439 FND_FLEX_DESCVAL.Set_Column_Value
3440 ( column_name => 'ATTRIBUTE15'
3441 , column_value => l_column_value);
3442
3443 IF p_context = FND_API.G_MISS_CHAR THEN
3444
3445 l_column_value := null;
3446
3447 ELSE
3448
3449 l_column_value := p_context;
3450
3451 END IF;
3452 FND_FLEX_DESCVAL.Set_Context_Value
3453 ( context_value => l_column_value);
3454
3455 /*IF NOT Desc_Flex('ONT','OE_PRICE_ADJUSTMENTS') THEN
3456 RETURN FALSE;
3457 END IF;*/
3458
3459
3460 END IF;
3461
3462 RETURN TRUE;
3463
3464 EXCEPTION
3465
3466 WHEN OTHERS THEN
3467
3468
3469 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470 THEN
3471
3472 OE_MSG_PUB.Add_Exc_Msg
3473 ( G_PKG_NAME
3474 , 'Price_Adj_Desc_Flex');
3475 END IF;
3476
3477
3478 RETURN FALSE;
3479
3480
3481 END Price_Adj_Desc_Flex;
3482
3483
3484
3485 FUNCTION Flex_Title ( p_flex_title IN VARCHAR2 )
3486 RETURN BOOLEAN
3487 IS
3488 l_dummy VARCHAR2(10);
3489 BEGIN
3490
3491 IF p_flex_title IS NULL OR
3492 p_flex_title = FND_API.G_MISS_CHAR
3493 THEN
3494 RETURN TRUE;
3495 END IF;
3496
3497 -- SELECT 'VALID'
3498 -- INTO l_dummy
3499 -- FROM DB_TABLE
3500 -- WHERE DB_COLUMN = p_flex_title;
3501
3502 RETURN TRUE;
3503
3504 EXCEPTION
3505
3506 WHEN NO_DATA_FOUND THEN
3507
3508 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3509 THEN
3510
3511 FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
3512 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','flex_title');
3513 FND_MSG_PUB.Add;
3514
3515 END IF;
3516
3517 RETURN FALSE;
3518
3519 WHEN OTHERS THEN
3520
3521 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3522 THEN
3523 FND_MSG_PUB.Add_Exc_Msg
3524 ( G_PKG_NAME
3525 , 'Flex_Title'
3526 );
3527 END IF;
3528
3529 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3530
3531 END Flex_Title;
3532
3533 FUNCTION Order_Price_Attrib ( p_order_price_attrib_id IN NUMBER )
3534 RETURN BOOLEAN
3535 IS
3536 l_dummy VARCHAR2(10);
3537 BEGIN
3538
3539 IF p_order_price_attrib_id IS NULL OR
3540 p_order_price_attrib_id = FND_API.G_MISS_NUM
3541 THEN
3542 RETURN TRUE;
3543 END IF;
3544
3545 -- SELECT 'VALID'
3546 -- INTO l_dummy
3547 -- FROM DB_TABLE
3548 -- WHERE DB_COLUMN = p_order_price_attrib_id;
3549
3550 RETURN TRUE;
3551
3552 EXCEPTION
3553
3554 WHEN NO_DATA_FOUND THEN
3555
3556 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3557 THEN
3558
3559 FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
3560 FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_price_attrib');
3561 FND_MSG_PUB.Add;
3562
3563 END IF;
3564
3565 RETURN FALSE;
3566
3567 WHEN OTHERS THEN
3568
3569 IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3570 THEN
3571 FND_MSG_PUB.Add_Exc_Msg
3572 ( G_PKG_NAME
3573 , 'Order_Price_Attrib'
3574 );
3575 END IF;
3576
3577 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578
3579 END Order_Price_Attrib;
3580
3581 -- END GEN validate
3582
3583
3584 END OE_Validate_adj;