eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_HEADER_ADJ dependencies on OE_VALIDATE

Line 1: PACKAGE BODY OE_Validate_Header_Adj AS

1: PACKAGE BODY OE_Validate_Header_Adj AS
2: /* $Header: OEXLHADB.pls 120.1 2005/12/29 04:24:29 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_Adj';

2: /* $Header: OEXLHADB.pls 120.1 2005/12/29 04:24:29 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header_Adj';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 30: oe_debug_pub.Add('Entering OE_VALIDATE_HEADER_ADJ.Entity',1);

26: /* l_organization_id NUMBER := To_number(FND_PROFILE.VALUE
27: ('SO_ORGANIZATION_ID'));*/
28: BEGIN
29:
30: oe_debug_pub.Add('Entering OE_VALIDATE_HEADER_ADJ.Entity',1);
31: -- Check required attributes.
32:
33: IF p_Header_Adj_rec.price_adjustment_id IS NULL
34: THEN

Line 324: oe_debug_pub.Add('Exiting OE_VALIDATE_HEADER_ADJ.Entity',1);

320:
321: -- Done validating entity
322:
323: x_return_status := l_return_status;
324: oe_debug_pub.Add('Exiting OE_VALIDATE_HEADER_ADJ.Entity',1);
325:
326: EXCEPTION
327:
328: WHEN FND_API.G_EXC_ERROR THEN

Line 361: oe_debug_pub.Add('Entering OE_VALIDATE_HEADER_ADJ.Attributes',1);

357: )
358: IS
359: BEGIN
360:
361: oe_debug_pub.Add('Entering OE_VALIDATE_HEADER_ADJ.Attributes',1);
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: -- Validate Header_Adj attributes
365:

Line 371: IF NOT oe_validate_adj.Price_Adjustment(p_Header_Adj_rec.price_adjustment_id) THEN

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

Line 381: IF NOT oe_validate_adj.Creation_Date(p_Header_Adj_rec.creation_date) THEN

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

Line 390: IF NOT oe_validate_adj.Pricing_Phase_id(p_Header_Adj_rec.pricing_phase_id)

386: ( p_Header_Adj_rec.pricing_phase_id <>
387: p_old_Header_Adj_rec.pricing_phase_id OR
388: p_old_Header_Adj_rec.pricing_phase_id IS NULL )
389: THEN
390: IF NOT oe_validate_adj.Pricing_Phase_id(p_Header_Adj_rec.pricing_phase_id)
391: THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: END IF;
394: END IF;

Line 402: IF NOT oe_validate_adj.Adjusted_Amount(p_Header_Adj_rec.adjusted_amount)

398: ( p_Header_Adj_rec.adjusted_amount <>
399: p_old_Header_Adj_rec.adjusted_amount OR
400: p_old_Header_Adj_rec.adjusted_amount IS NULL )
401: THEN
402: IF NOT oe_validate_adj.Adjusted_Amount(p_Header_Adj_rec.adjusted_amount)
403: THEN
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: END IF;
406: END IF;

Line 413: IF NOT oe_validate_adj.Created_By(p_Header_Adj_rec.created_by) THEN

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

Line 423: IF NOT oe_validate_adj.Last_Update_Date(p_Header_Adj_rec.last_update_date) THEN

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

Line 433: IF NOT oe_validate_adj.Last_Updated_By(p_Header_Adj_rec.last_updated_by) THEN

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

Line 443: IF NOT oe_validate_adj.Last_Update_Login(p_Header_Adj_rec.last_update_login) THEN

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

Line 453: IF NOT oe_validate_adj.Program_Application(p_Header_Adj_rec.program_application_id) THEN

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

Line 463: IF NOT oe_validate_adj.Program(p_Header_Adj_rec.program_id) THEN

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

Line 473: IF NOT oe_validate_adj.Program_Update_Date(p_Header_Adj_rec.program_update_date) THEN

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

Line 483: IF NOT oe_validate_adj.Request(p_Header_Adj_rec.request_id) THEN

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

Line 493: IF NOT oe_validate_adj.Header(p_Header_Adj_rec.header_id) THEN

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

Line 503: IF NOT oe_validate_adj.Discount(p_Header_Adj_rec.discount_id) THEN

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

Line 513: IF NOT oe_validate_adj.Discount_Line(p_Header_Adj_rec.discount_line_id) THEN

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

Line 523: IF NOT oe_validate_adj.Automatic(p_Header_Adj_rec.automatic_flag) THEN

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

Line 533: IF NOT oe_validate_adj.Percent(p_Header_Adj_rec.percent) THEN

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

Line 543: IF NOT oe_validate_adj.Line(p_Header_Adj_rec.line_id) THEN

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

Line 553: IF NOT oe_validate_adj.List_Line_No(p_Header_Adj_rec.list_line_no) THEN

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

Line 563: IF NOT oe_validate_adj.source_system_code(p_Header_Adj_rec.source_system_code) THEN

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

Line 573: IF NOT oe_validate_adj.benefit_qty(p_Header_Adj_rec.benefit_qty) THEN

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

Line 583: IF NOT oe_validate_adj.benefit_uom_code(p_Header_Adj_rec.benefit_uom_code) THEN

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

Line 593: IF NOT oe_validate_adj.print_on_invoice_flag(p_Header_Adj_rec.print_on_invoice_flag) THEN

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

Line 603: IF NOT oe_validate_adj.expiration_date(p_Header_Adj_rec.expiration_date) THEN

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

Line 613: IF NOT oe_validate_adj.rebate_transaction_type_code(p_Header_Adj_rec.rebate_transaction_type_code) THEN

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

Line 624: IF NOT oe_validate_adj.rebate_transaction_reference(p_Header_Adj_rec.rebate_transaction_reference) THEN

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

Line 634: IF NOT oe_validate_adj.rebate_payment_system_code(p_Header_Adj_rec.rebate_payment_system_code) THEN

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

Line 644: IF NOT oe_validate_adj.Redeemed_Date(p_Header_Adj_rec.Redeemed_Date) THEN

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

Line 654: IF NOT oe_validate_adj.Redeemed_Flag(p_Header_Adj_rec.redeemed_flag) THEN

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

Line 664: IF NOT oe_validate_adj.Accrual_Flag(p_Header_Adj_rec.accrual_flag) THEN

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

Line 674: IF NOT OE_Validate.credit_or_charge_flag(p_Header_Adj_rec.credit_or_charge_flag) THEN

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

Line 684: IF NOT OE_Validate.charge_type_code(p_Header_Adj_rec.charge_type_code) THEN

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

Line 694: IF NOT OE_Validate.charge_subtype_code(p_Header_Adj_rec.charge_subtype_code) THEN

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

Line 704: IF NOT OE_Validate.estimated(p_Header_Adj_rec.estimated_flag) THEN

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

Line 714: IF NOT OE_Validate.invoiced(p_Header_Adj_rec.invoiced_flag) THEN

710: ( p_Header_Adj_rec.invoiced_flag <>
711: p_old_Header_Adj_rec.invoiced_flag OR
712: p_old_Header_Adj_rec.invoiced_flag IS NULL )
713: THEN
714: IF NOT OE_Validate.invoiced(p_Header_Adj_rec.invoiced_flag) THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: END IF;
717: END IF;
718:

Line 720: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Adj.attributes ',1);

716: END IF;
717: END IF;
718:
719: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
720: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header_Adj.attributes ',1);
721: IF (p_Header_Adj_rec.context IS NOT NULL AND
722: ( p_Header_Adj_rec.context <>
723: p_old_Header_Adj_rec.context OR
724: p_old_Header_Adj_rec.context IS NULL ))

Line 791: IF NOT oe_validate_adj.Price_Adj_Desc_Flex

787: -- These calls are temporarily commented out
788:
789: oe_debug_pub.add('Before calling Header Adjustment Price_Adj_Desc_Flex',2);
790:
791: IF NOT oe_validate_adj.Price_Adj_Desc_Flex
792: (p_context => p_Header_Adj_rec.context
793: ,p_attribute1 => p_Header_Adj_rec.attribute1
794: ,p_attribute2 => p_Header_Adj_rec.attribute2
795: ,p_attribute3 => p_Header_Adj_rec.attribute3

Line 819: oe_debug_pub.Add('Exiting OE_VALIDATE_HEADER_ADJ.Attributes',1);

815:
816: END IF;
817:
818: -- Done validating attributes
819: oe_debug_pub.Add('Exiting OE_VALIDATE_HEADER_ADJ.Attributes',1);
820: end if ; /* if OE_GLOBALS.g_validate_desc_flex ='Y' then bug4343612*/
821:
822: EXCEPTION
823:

Line 889: END OE_Validate_Header_Adj;

885:
886: END Entity_Delete;
887:
888:
889: END OE_Validate_Header_Adj;