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

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
15: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type

Line 27: IF p_attr_id = FND_API.G_MISS_NUM THEN

23:
24: -- If attr_id is missing compare old and new records and for
25: -- every changed attribute clear its dependent fields.
26:
27: IF p_attr_id = FND_API.G_MISS_NUM THEN
28:
29: IF NOT OE_GLOBALS.Equal(p_Price_Break_rec.amount,p_old_Price_Break_rec.amount)
30: THEN
31: NULL;

Line 480: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN

476: IS
477: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
478: BEGIN
479:
480: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
481: l_Price_Break_rec.amount := p_old_Price_Break_rec.amount;
482: END IF;
483:
484: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 484: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN

480: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
481: l_Price_Break_rec.amount := p_old_Price_Break_rec.amount;
482: END IF;
483:
484: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN
485: l_Price_Break_rec.attribute1 := p_old_Price_Break_rec.attribute1;
486: END IF;
487:
488: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 488: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN

484: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN
485: l_Price_Break_rec.attribute1 := p_old_Price_Break_rec.attribute1;
486: END IF;
487:
488: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN
489: l_Price_Break_rec.attribute10 := p_old_Price_Break_rec.attribute10;
490: END IF;
491:
492: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 492: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN

488: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN
489: l_Price_Break_rec.attribute10 := p_old_Price_Break_rec.attribute10;
490: END IF;
491:
492: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN
493: l_Price_Break_rec.attribute11 := p_old_Price_Break_rec.attribute11;
494: END IF;
495:
496: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 496: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN

492: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN
493: l_Price_Break_rec.attribute11 := p_old_Price_Break_rec.attribute11;
494: END IF;
495:
496: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN
497: l_Price_Break_rec.attribute12 := p_old_Price_Break_rec.attribute12;
498: END IF;
499:
500: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 500: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN

496: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN
497: l_Price_Break_rec.attribute12 := p_old_Price_Break_rec.attribute12;
498: END IF;
499:
500: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN
501: l_Price_Break_rec.attribute13 := p_old_Price_Break_rec.attribute13;
502: END IF;
503:
504: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 504: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN

500: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN
501: l_Price_Break_rec.attribute13 := p_old_Price_Break_rec.attribute13;
502: END IF;
503:
504: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN
505: l_Price_Break_rec.attribute14 := p_old_Price_Break_rec.attribute14;
506: END IF;
507:
508: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 508: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN

504: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN
505: l_Price_Break_rec.attribute14 := p_old_Price_Break_rec.attribute14;
506: END IF;
507:
508: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN
509: l_Price_Break_rec.attribute15 := p_old_Price_Break_rec.attribute15;
510: END IF;
511:
512: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 512: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN

508: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN
509: l_Price_Break_rec.attribute15 := p_old_Price_Break_rec.attribute15;
510: END IF;
511:
512: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN
513: l_Price_Break_rec.attribute2 := p_old_Price_Break_rec.attribute2;
514: END IF;
515:
516: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 516: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN

512: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN
513: l_Price_Break_rec.attribute2 := p_old_Price_Break_rec.attribute2;
514: END IF;
515:
516: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN
517: l_Price_Break_rec.attribute3 := p_old_Price_Break_rec.attribute3;
518: END IF;
519:
520: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 520: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN

516: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN
517: l_Price_Break_rec.attribute3 := p_old_Price_Break_rec.attribute3;
518: END IF;
519:
520: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN
521: l_Price_Break_rec.attribute4 := p_old_Price_Break_rec.attribute4;
522: END IF;
523:
524: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 524: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN

520: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN
521: l_Price_Break_rec.attribute4 := p_old_Price_Break_rec.attribute4;
522: END IF;
523:
524: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN
525: l_Price_Break_rec.attribute5 := p_old_Price_Break_rec.attribute5;
526: END IF;
527:
528: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 528: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN

524: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN
525: l_Price_Break_rec.attribute5 := p_old_Price_Break_rec.attribute5;
526: END IF;
527:
528: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN
529: l_Price_Break_rec.attribute6 := p_old_Price_Break_rec.attribute6;
530: END IF;
531:
532: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 532: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN

528: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN
529: l_Price_Break_rec.attribute6 := p_old_Price_Break_rec.attribute6;
530: END IF;
531:
532: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN
533: l_Price_Break_rec.attribute7 := p_old_Price_Break_rec.attribute7;
534: END IF;
535:
536: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 536: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN

532: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN
533: l_Price_Break_rec.attribute7 := p_old_Price_Break_rec.attribute7;
534: END IF;
535:
536: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN
537: l_Price_Break_rec.attribute8 := p_old_Price_Break_rec.attribute8;
538: END IF;
539:
540: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 540: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN

536: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN
537: l_Price_Break_rec.attribute8 := p_old_Price_Break_rec.attribute8;
538: END IF;
539:
540: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN
541: l_Price_Break_rec.attribute9 := p_old_Price_Break_rec.attribute9;
542: END IF;
543:
544: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN

Line 544: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN

540: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN
541: l_Price_Break_rec.attribute9 := p_old_Price_Break_rec.attribute9;
542: END IF;
543:
544: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN
545: l_Price_Break_rec.context := p_old_Price_Break_rec.context;
546: END IF;
547:
548: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN

Line 548: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN

544: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN
545: l_Price_Break_rec.context := p_old_Price_Break_rec.context;
546: END IF;
547:
548: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN
549: l_Price_Break_rec.created_by := p_old_Price_Break_rec.created_by;
550: END IF;
551:
552: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 552: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN

548: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN
549: l_Price_Break_rec.created_by := p_old_Price_Break_rec.created_by;
550: END IF;
551:
552: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN
553: l_Price_Break_rec.creation_date := p_old_Price_Break_rec.creation_date;
554: END IF;
555:
556: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN

Line 556: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN

552: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN
553: l_Price_Break_rec.creation_date := p_old_Price_Break_rec.creation_date;
554: END IF;
555:
556: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
557: l_Price_Break_rec.discount_line_id := p_old_Price_Break_rec.discount_line_id;
558: END IF;
559:
560: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 560: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN

556: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
557: l_Price_Break_rec.discount_line_id := p_old_Price_Break_rec.discount_line_id;
558: END IF;
559:
560: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN
561: l_Price_Break_rec.end_date_active := p_old_Price_Break_rec.end_date_active;
562: END IF;
563:
564: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 564: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN

560: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN
561: l_Price_Break_rec.end_date_active := p_old_Price_Break_rec.end_date_active;
562: END IF;
563:
564: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN
565: l_Price_Break_rec.last_updated_by := p_old_Price_Break_rec.last_updated_by;
566: END IF;
567:
568: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 568: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN

564: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN
565: l_Price_Break_rec.last_updated_by := p_old_Price_Break_rec.last_updated_by;
566: END IF;
567:
568: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN
569: l_Price_Break_rec.last_update_date := p_old_Price_Break_rec.last_update_date;
570: END IF;
571:
572: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 572: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN

568: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN
569: l_Price_Break_rec.last_update_date := p_old_Price_Break_rec.last_update_date;
570: END IF;
571:
572: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN
573: l_Price_Break_rec.last_update_login := p_old_Price_Break_rec.last_update_login;
574: END IF;
575:
576: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN

Line 576: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN

572: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN
573: l_Price_Break_rec.last_update_login := p_old_Price_Break_rec.last_update_login;
574: END IF;
575:
576: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
577: l_Price_Break_rec.method_type_code := p_old_Price_Break_rec.method_type_code;
578: END IF;
579:
580: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN

Line 580: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN

576: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
577: l_Price_Break_rec.method_type_code := p_old_Price_Break_rec.method_type_code;
578: END IF;
579:
580: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN
581: l_Price_Break_rec.percent := p_old_Price_Break_rec.percent;
582: END IF;
583:
584: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN

Line 584: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN

580: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN
581: l_Price_Break_rec.percent := p_old_Price_Break_rec.percent;
582: END IF;
583:
584: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN
585: l_Price_Break_rec.price := p_old_Price_Break_rec.price;
586: END IF;
587:
588: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN

Line 588: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN

584: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN
585: l_Price_Break_rec.price := p_old_Price_Break_rec.price;
586: END IF;
587:
588: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN
589: l_Price_Break_rec.price_break_high := p_old_Price_Break_rec.price_break_high;
590: END IF;
591:
592: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN

Line 592: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN

588: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN
589: l_Price_Break_rec.price_break_high := p_old_Price_Break_rec.price_break_high;
590: END IF;
591:
592: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN
593: l_Price_Break_rec.price_break_low := p_old_Price_Break_rec.price_break_low;
594: END IF;
595:
596: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 596: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN

592: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN
593: l_Price_Break_rec.price_break_low := p_old_Price_Break_rec.price_break_low;
594: END IF;
595:
596: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN
597: l_Price_Break_rec.program_application_id := p_old_Price_Break_rec.program_application_id;
598: END IF;
599:
600: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN

Line 600: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN

596: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN
597: l_Price_Break_rec.program_application_id := p_old_Price_Break_rec.program_application_id;
598: END IF;
599:
600: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN
601: l_Price_Break_rec.program_id := p_old_Price_Break_rec.program_id;
602: END IF;
603:
604: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 604: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN

600: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN
601: l_Price_Break_rec.program_id := p_old_Price_Break_rec.program_id;
602: END IF;
603:
604: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
605: l_Price_Break_rec.program_update_date := p_old_Price_Break_rec.program_update_date;
606: END IF;
607:
608: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN

Line 608: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN

604: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
605: l_Price_Break_rec.program_update_date := p_old_Price_Break_rec.program_update_date;
606: END IF;
607:
608: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN
609: l_Price_Break_rec.request_id := p_old_Price_Break_rec.request_id;
610: END IF;
611:
612: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 612: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN

608: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN
609: l_Price_Break_rec.request_id := p_old_Price_Break_rec.request_id;
610: END IF;
611:
612: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN
613: l_Price_Break_rec.start_date_active := p_old_Price_Break_rec.start_date_active;
614: END IF;
615:
616: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN

Line 616: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN

612: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN
613: l_Price_Break_rec.start_date_active := p_old_Price_Break_rec.start_date_active;
614: END IF;
615:
616: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN
617: l_Price_Break_rec.unit_code := p_old_Price_Break_rec.unit_code;
618: END IF;
619:
620: RETURN l_Price_Break_rec;

Line 633: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN

629: IS
630: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type := p_Price_Break_rec;
631: BEGIN
632:
633: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
634: l_Price_Break_rec.amount := NULL;
635: END IF;
636:
637: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 637: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN

633: IF l_Price_Break_rec.amount = FND_API.G_MISS_NUM THEN
634: l_Price_Break_rec.amount := NULL;
635: END IF;
636:
637: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN
638: l_Price_Break_rec.attribute1 := NULL;
639: END IF;
640:
641: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 641: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN

637: IF l_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR THEN
638: l_Price_Break_rec.attribute1 := NULL;
639: END IF;
640:
641: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN
642: l_Price_Break_rec.attribute10 := NULL;
643: END IF;
644:
645: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 645: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN

641: IF l_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR THEN
642: l_Price_Break_rec.attribute10 := NULL;
643: END IF;
644:
645: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN
646: l_Price_Break_rec.attribute11 := NULL;
647: END IF;
648:
649: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 649: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN

645: IF l_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR THEN
646: l_Price_Break_rec.attribute11 := NULL;
647: END IF;
648:
649: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN
650: l_Price_Break_rec.attribute12 := NULL;
651: END IF;
652:
653: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 653: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN

649: IF l_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR THEN
650: l_Price_Break_rec.attribute12 := NULL;
651: END IF;
652:
653: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN
654: l_Price_Break_rec.attribute13 := NULL;
655: END IF;
656:
657: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 657: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN

653: IF l_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR THEN
654: l_Price_Break_rec.attribute13 := NULL;
655: END IF;
656:
657: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN
658: l_Price_Break_rec.attribute14 := NULL;
659: END IF;
660:
661: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 661: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN

657: IF l_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR THEN
658: l_Price_Break_rec.attribute14 := NULL;
659: END IF;
660:
661: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN
662: l_Price_Break_rec.attribute15 := NULL;
663: END IF;
664:
665: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 665: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN

661: IF l_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR THEN
662: l_Price_Break_rec.attribute15 := NULL;
663: END IF;
664:
665: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN
666: l_Price_Break_rec.attribute2 := NULL;
667: END IF;
668:
669: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 669: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN

665: IF l_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR THEN
666: l_Price_Break_rec.attribute2 := NULL;
667: END IF;
668:
669: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN
670: l_Price_Break_rec.attribute3 := NULL;
671: END IF;
672:
673: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 673: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN

669: IF l_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR THEN
670: l_Price_Break_rec.attribute3 := NULL;
671: END IF;
672:
673: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN
674: l_Price_Break_rec.attribute4 := NULL;
675: END IF;
676:
677: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 677: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN

673: IF l_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR THEN
674: l_Price_Break_rec.attribute4 := NULL;
675: END IF;
676:
677: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN
678: l_Price_Break_rec.attribute5 := NULL;
679: END IF;
680:
681: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 681: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN

677: IF l_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR THEN
678: l_Price_Break_rec.attribute5 := NULL;
679: END IF;
680:
681: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN
682: l_Price_Break_rec.attribute6 := NULL;
683: END IF;
684:
685: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 685: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN

681: IF l_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR THEN
682: l_Price_Break_rec.attribute6 := NULL;
683: END IF;
684:
685: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN
686: l_Price_Break_rec.attribute7 := NULL;
687: END IF;
688:
689: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 689: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN

685: IF l_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR THEN
686: l_Price_Break_rec.attribute7 := NULL;
687: END IF;
688:
689: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN
690: l_Price_Break_rec.attribute8 := NULL;
691: END IF;
692:
693: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 693: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN

689: IF l_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR THEN
690: l_Price_Break_rec.attribute8 := NULL;
691: END IF;
692:
693: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN
694: l_Price_Break_rec.attribute9 := NULL;
695: END IF;
696:
697: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN

Line 697: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN

693: IF l_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR THEN
694: l_Price_Break_rec.attribute9 := NULL;
695: END IF;
696:
697: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN
698: l_Price_Break_rec.context := NULL;
699: END IF;
700:
701: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN

Line 701: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN

697: IF l_Price_Break_rec.context = FND_API.G_MISS_CHAR THEN
698: l_Price_Break_rec.context := NULL;
699: END IF;
700:
701: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN
702: l_Price_Break_rec.created_by := NULL;
703: END IF;
704:
705: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 705: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN

701: IF l_Price_Break_rec.created_by = FND_API.G_MISS_NUM THEN
702: l_Price_Break_rec.created_by := NULL;
703: END IF;
704:
705: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN
706: l_Price_Break_rec.creation_date := NULL;
707: END IF;
708:
709: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN

Line 709: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN

705: IF l_Price_Break_rec.creation_date = FND_API.G_MISS_DATE THEN
706: l_Price_Break_rec.creation_date := NULL;
707: END IF;
708:
709: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
710: l_Price_Break_rec.discount_line_id := NULL;
711: END IF;
712:
713: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 713: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN

709: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
710: l_Price_Break_rec.discount_line_id := NULL;
711: END IF;
712:
713: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN
714: l_Price_Break_rec.end_date_active := NULL;
715: END IF;
716:
717: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 717: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN

713: IF l_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE THEN
714: l_Price_Break_rec.end_date_active := NULL;
715: END IF;
716:
717: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN
718: l_Price_Break_rec.last_updated_by := NULL;
719: END IF;
720:
721: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 721: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN

717: IF l_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN
718: l_Price_Break_rec.last_updated_by := NULL;
719: END IF;
720:
721: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN
722: l_Price_Break_rec.last_update_date := NULL;
723: END IF;
724:
725: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 725: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN

721: IF l_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN
722: l_Price_Break_rec.last_update_date := NULL;
723: END IF;
724:
725: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN
726: l_Price_Break_rec.last_update_login := NULL;
727: END IF;
728:
729: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN

Line 729: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN

725: IF l_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN
726: l_Price_Break_rec.last_update_login := NULL;
727: END IF;
728:
729: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
730: l_Price_Break_rec.method_type_code := NULL;
731: END IF;
732:
733: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN

Line 733: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN

729: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
730: l_Price_Break_rec.method_type_code := NULL;
731: END IF;
732:
733: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN
734: l_Price_Break_rec.percent := NULL;
735: END IF;
736:
737: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN

Line 737: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN

733: IF l_Price_Break_rec.percent = FND_API.G_MISS_NUM THEN
734: l_Price_Break_rec.percent := NULL;
735: END IF;
736:
737: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN
738: l_Price_Break_rec.price := NULL;
739: END IF;
740:
741: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN

Line 741: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN

737: IF l_Price_Break_rec.price = FND_API.G_MISS_NUM THEN
738: l_Price_Break_rec.price := NULL;
739: END IF;
740:
741: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN
742: l_Price_Break_rec.price_break_high := NULL;
743: END IF;
744:
745: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN

Line 745: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN

741: IF l_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM THEN
742: l_Price_Break_rec.price_break_high := NULL;
743: END IF;
744:
745: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN
746: l_Price_Break_rec.price_break_low := NULL;
747: END IF;
748:
749: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 749: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN

745: IF l_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM THEN
746: l_Price_Break_rec.price_break_low := NULL;
747: END IF;
748:
749: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN
750: l_Price_Break_rec.program_application_id := NULL;
751: END IF;
752:
753: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN

Line 753: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN

749: IF l_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM THEN
750: l_Price_Break_rec.program_application_id := NULL;
751: END IF;
752:
753: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN
754: l_Price_Break_rec.program_id := NULL;
755: END IF;
756:
757: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 757: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN

753: IF l_Price_Break_rec.program_id = FND_API.G_MISS_NUM THEN
754: l_Price_Break_rec.program_id := NULL;
755: END IF;
756:
757: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
758: l_Price_Break_rec.program_update_date := NULL;
759: END IF;
760:
761: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN

Line 761: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN

757: IF l_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN
758: l_Price_Break_rec.program_update_date := NULL;
759: END IF;
760:
761: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN
762: l_Price_Break_rec.request_id := NULL;
763: END IF;
764:
765: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 765: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN

761: IF l_Price_Break_rec.request_id = FND_API.G_MISS_NUM THEN
762: l_Price_Break_rec.request_id := NULL;
763: END IF;
764:
765: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN
766: l_Price_Break_rec.start_date_active := NULL;
767: END IF;
768:
769: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN

Line 769: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN

765: IF l_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE THEN
766: l_Price_Break_rec.start_date_active := NULL;
767: END IF;
768:
769: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN
770: l_Price_Break_rec.unit_code := NULL;
771: END IF;
772:
773: RETURN l_Price_Break_rec;

Line 839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

835: , 'Update_Row'
836: );
837: END IF;
838:
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840:
841: END Update_Row;
842:
843: -- Procedure Insert_Row

Line 938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

934: , 'Insert_Row'
935: );
936: END IF;
937:
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939:
940: END Insert_Row;
941:
942: -- Procedure Delete_Row

Line 972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

968: , 'Delete_Row'
969: );
970: END IF;
971:
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973:
974: END Delete_Row;
975:
976: -- Function Query_Row

Line 1002: FND_API.G_MISS_NUM

998: --
999:
1000: FUNCTION Query_Rows
1001: ( p_discount_line_id IN NUMBER :=
1002: FND_API.G_MISS_NUM
1003: , p_method_type_code IN VARCHAR2 :=
1004: FND_API.G_MISS_CHAR
1005: , p_price_break_high IN NUMBER :=
1006: FND_API.G_MISS_NUM

Line 1004: FND_API.G_MISS_CHAR

1000: FUNCTION Query_Rows
1001: ( p_discount_line_id IN NUMBER :=
1002: FND_API.G_MISS_NUM
1003: , p_method_type_code IN VARCHAR2 :=
1004: FND_API.G_MISS_CHAR
1005: , p_price_break_high IN NUMBER :=
1006: FND_API.G_MISS_NUM
1007: , p_price_break_low IN NUMBER :=
1008: FND_API.G_MISS_NUM

Line 1006: FND_API.G_MISS_NUM

1002: FND_API.G_MISS_NUM
1003: , p_method_type_code IN VARCHAR2 :=
1004: FND_API.G_MISS_CHAR
1005: , p_price_break_high IN NUMBER :=
1006: FND_API.G_MISS_NUM
1007: , p_price_break_low IN NUMBER :=
1008: FND_API.G_MISS_NUM
1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1010: IS

Line 1008: FND_API.G_MISS_NUM

1004: FND_API.G_MISS_CHAR
1005: , p_price_break_high IN NUMBER :=
1006: FND_API.G_MISS_NUM
1007: , p_price_break_low IN NUMBER :=
1008: FND_API.G_MISS_NUM
1009: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
1010: IS
1011: l_Price_Break_rec OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
1012: l_Price_Break_tbl OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;

Line 1064: p_discount_line_id <> FND_API.G_MISS_NUM)

1060:
1061: IF
1062: (p_discount_line_id IS NOT NULL
1063: AND
1064: p_discount_line_id <> FND_API.G_MISS_NUM)
1065: AND
1066: (p_method_type_code IS NOT NULL
1067: AND
1068: p_method_type_code <> FND_API.G_MISS_CHAR)

Line 1068: p_method_type_code <> FND_API.G_MISS_CHAR)

1064: p_discount_line_id <> FND_API.G_MISS_NUM)
1065: AND
1066: (p_method_type_code IS NOT NULL
1067: AND
1068: p_method_type_code <> FND_API.G_MISS_CHAR)
1069: AND
1070: (p_price_break_high IS NOT NULL
1071: AND
1072: p_price_break_high <> FND_API.G_MISS_NUM)

Line 1072: p_price_break_high <> FND_API.G_MISS_NUM)

1068: p_method_type_code <> FND_API.G_MISS_CHAR)
1069: AND
1070: (p_price_break_high IS NOT NULL
1071: AND
1072: p_price_break_high <> FND_API.G_MISS_NUM)
1073: AND
1074: (p_price_break_low IS NOT NULL
1075: AND
1076: p_price_break_low <> FND_API.G_MISS_NUM)

Line 1076: p_price_break_low <> FND_API.G_MISS_NUM)

1072: p_price_break_high <> FND_API.G_MISS_NUM)
1073: AND
1074: (p_price_break_low IS NOT NULL
1075: AND
1076: p_price_break_low <> FND_API.G_MISS_NUM)
1077: THEN
1078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: OE_MSG_PUB.Add_Exc_Msg

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: ', discount_line_id = '|| p_discount_line_id
1089: );
1090: END IF;
1091:
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093:
1094: END IF;
1095:
1096:

Line 1147: p_discount_line_id <> FND_API.G_MISS_NUM)

1143:
1144: IF
1145: (p_discount_line_id IS NOT NULL
1146: AND
1147: p_discount_line_id <> FND_API.G_MISS_NUM)
1148: AND
1149: (p_method_type_code IS NOT NULL
1150: AND
1151: p_method_type_code <> FND_API.G_MISS_CHAR)

Line 1151: p_method_type_code <> FND_API.G_MISS_CHAR)

1147: p_discount_line_id <> FND_API.G_MISS_NUM)
1148: AND
1149: (p_method_type_code IS NOT NULL
1150: AND
1151: p_method_type_code <> FND_API.G_MISS_CHAR)
1152: AND
1153: (p_price_break_high IS NOT NULL
1154: AND
1155: p_price_break_high <> FND_API.G_MISS_NUM)

Line 1155: p_price_break_high <> FND_API.G_MISS_NUM)

1151: p_method_type_code <> FND_API.G_MISS_CHAR)
1152: AND
1153: (p_price_break_high IS NOT NULL
1154: AND
1155: p_price_break_high <> FND_API.G_MISS_NUM)
1156: AND
1157: (p_price_break_low IS NOT NULL
1158: AND
1159: p_price_break_low <> FND_API.G_MISS_NUM)

Line 1159: p_price_break_low <> FND_API.G_MISS_NUM)

1155: p_price_break_high <> FND_API.G_MISS_NUM)
1156: AND
1157: (p_price_break_low IS NOT NULL
1158: AND
1159: p_price_break_low <> FND_API.G_MISS_NUM)
1160: AND
1161: (l_Price_Break_tbl.COUNT = 0)
1162: THEN
1163: RAISE NO_DATA_FOUND;

Line 1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1169: RETURN l_Price_Break_tbl;
1170:
1171: EXCEPTION
1172:
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174:
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: WHEN OTHERS THEN

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: EXCEPTION
1172:
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174:
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: WHEN OTHERS THEN
1178:
1179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1183: , 'Query_Rows'
1184: );
1185: END IF;
1186:
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188:
1189: END Query_Rows;
1190:
1191: -- Procedure lock_Row

Line 1284: ((p_Price_Break_rec.amount = FND_API.G_MISS_NUM) OR

1280: -- Row locked. Compare IN attributes to DB attributes.
1281:
1282: IF ( (l_Price_Break_rec.amount =
1283: p_Price_Break_rec.amount) OR
1284: ((p_Price_Break_rec.amount = FND_API.G_MISS_NUM) OR
1285: ( (l_Price_Break_rec.amount IS NULL) AND
1286: (p_Price_Break_rec.amount IS NULL))))
1287: AND ( (l_Price_Break_rec.attribute1 =
1288: p_Price_Break_rec.attribute1) OR

Line 1289: ((p_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR) OR

1285: ( (l_Price_Break_rec.amount IS NULL) AND
1286: (p_Price_Break_rec.amount IS NULL))))
1287: AND ( (l_Price_Break_rec.attribute1 =
1288: p_Price_Break_rec.attribute1) OR
1289: ((p_Price_Break_rec.attribute1 = FND_API.G_MISS_CHAR) OR
1290: ( (l_Price_Break_rec.attribute1 IS NULL) AND
1291: (p_Price_Break_rec.attribute1 IS NULL))))
1292: AND ( (l_Price_Break_rec.attribute10 =
1293: p_Price_Break_rec.attribute10) OR

Line 1294: ((p_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR) OR

1290: ( (l_Price_Break_rec.attribute1 IS NULL) AND
1291: (p_Price_Break_rec.attribute1 IS NULL))))
1292: AND ( (l_Price_Break_rec.attribute10 =
1293: p_Price_Break_rec.attribute10) OR
1294: ((p_Price_Break_rec.attribute10 = FND_API.G_MISS_CHAR) OR
1295: ( (l_Price_Break_rec.attribute10 IS NULL) AND
1296: (p_Price_Break_rec.attribute10 IS NULL))))
1297: AND ( (l_Price_Break_rec.attribute11 =
1298: p_Price_Break_rec.attribute11) OR

Line 1299: ((p_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR) OR

1295: ( (l_Price_Break_rec.attribute10 IS NULL) AND
1296: (p_Price_Break_rec.attribute10 IS NULL))))
1297: AND ( (l_Price_Break_rec.attribute11 =
1298: p_Price_Break_rec.attribute11) OR
1299: ((p_Price_Break_rec.attribute11 = FND_API.G_MISS_CHAR) OR
1300: ( (l_Price_Break_rec.attribute11 IS NULL) AND
1301: (p_Price_Break_rec.attribute11 IS NULL))))
1302: AND ( (l_Price_Break_rec.attribute12 =
1303: p_Price_Break_rec.attribute12) OR

Line 1304: ((p_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR) OR

1300: ( (l_Price_Break_rec.attribute11 IS NULL) AND
1301: (p_Price_Break_rec.attribute11 IS NULL))))
1302: AND ( (l_Price_Break_rec.attribute12 =
1303: p_Price_Break_rec.attribute12) OR
1304: ((p_Price_Break_rec.attribute12 = FND_API.G_MISS_CHAR) OR
1305: ( (l_Price_Break_rec.attribute12 IS NULL) AND
1306: (p_Price_Break_rec.attribute12 IS NULL))))
1307: AND ( (l_Price_Break_rec.attribute13 =
1308: p_Price_Break_rec.attribute13) OR

Line 1309: ((p_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR) OR

1305: ( (l_Price_Break_rec.attribute12 IS NULL) AND
1306: (p_Price_Break_rec.attribute12 IS NULL))))
1307: AND ( (l_Price_Break_rec.attribute13 =
1308: p_Price_Break_rec.attribute13) OR
1309: ((p_Price_Break_rec.attribute13 = FND_API.G_MISS_CHAR) OR
1310: ( (l_Price_Break_rec.attribute13 IS NULL) AND
1311: (p_Price_Break_rec.attribute13 IS NULL))))
1312: AND ( (l_Price_Break_rec.attribute14 =
1313: p_Price_Break_rec.attribute14) OR

Line 1314: ((p_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR) OR

1310: ( (l_Price_Break_rec.attribute13 IS NULL) AND
1311: (p_Price_Break_rec.attribute13 IS NULL))))
1312: AND ( (l_Price_Break_rec.attribute14 =
1313: p_Price_Break_rec.attribute14) OR
1314: ((p_Price_Break_rec.attribute14 = FND_API.G_MISS_CHAR) OR
1315: ( (l_Price_Break_rec.attribute14 IS NULL) AND
1316: (p_Price_Break_rec.attribute14 IS NULL))))
1317: AND ( (l_Price_Break_rec.attribute15 =
1318: p_Price_Break_rec.attribute15) OR

Line 1319: ((p_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR) OR

1315: ( (l_Price_Break_rec.attribute14 IS NULL) AND
1316: (p_Price_Break_rec.attribute14 IS NULL))))
1317: AND ( (l_Price_Break_rec.attribute15 =
1318: p_Price_Break_rec.attribute15) OR
1319: ((p_Price_Break_rec.attribute15 = FND_API.G_MISS_CHAR) OR
1320: ( (l_Price_Break_rec.attribute15 IS NULL) AND
1321: (p_Price_Break_rec.attribute15 IS NULL))))
1322: AND ( (l_Price_Break_rec.attribute2 =
1323: p_Price_Break_rec.attribute2) OR

Line 1324: ((p_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR) OR

1320: ( (l_Price_Break_rec.attribute15 IS NULL) AND
1321: (p_Price_Break_rec.attribute15 IS NULL))))
1322: AND ( (l_Price_Break_rec.attribute2 =
1323: p_Price_Break_rec.attribute2) OR
1324: ((p_Price_Break_rec.attribute2 = FND_API.G_MISS_CHAR) OR
1325: ( (l_Price_Break_rec.attribute2 IS NULL) AND
1326: (p_Price_Break_rec.attribute2 IS NULL))))
1327: AND ( (l_Price_Break_rec.attribute3 =
1328: p_Price_Break_rec.attribute3) OR

Line 1329: ((p_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR) OR

1325: ( (l_Price_Break_rec.attribute2 IS NULL) AND
1326: (p_Price_Break_rec.attribute2 IS NULL))))
1327: AND ( (l_Price_Break_rec.attribute3 =
1328: p_Price_Break_rec.attribute3) OR
1329: ((p_Price_Break_rec.attribute3 = FND_API.G_MISS_CHAR) OR
1330: ( (l_Price_Break_rec.attribute3 IS NULL) AND
1331: (p_Price_Break_rec.attribute3 IS NULL))))
1332: AND ( (l_Price_Break_rec.attribute4 =
1333: p_Price_Break_rec.attribute4) OR

Line 1334: ((p_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR) OR

1330: ( (l_Price_Break_rec.attribute3 IS NULL) AND
1331: (p_Price_Break_rec.attribute3 IS NULL))))
1332: AND ( (l_Price_Break_rec.attribute4 =
1333: p_Price_Break_rec.attribute4) OR
1334: ((p_Price_Break_rec.attribute4 = FND_API.G_MISS_CHAR) OR
1335: ( (l_Price_Break_rec.attribute4 IS NULL) AND
1336: (p_Price_Break_rec.attribute4 IS NULL))))
1337: AND ( (l_Price_Break_rec.attribute5 =
1338: p_Price_Break_rec.attribute5) OR

Line 1339: ((p_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR) OR

1335: ( (l_Price_Break_rec.attribute4 IS NULL) AND
1336: (p_Price_Break_rec.attribute4 IS NULL))))
1337: AND ( (l_Price_Break_rec.attribute5 =
1338: p_Price_Break_rec.attribute5) OR
1339: ((p_Price_Break_rec.attribute5 = FND_API.G_MISS_CHAR) OR
1340: ( (l_Price_Break_rec.attribute5 IS NULL) AND
1341: (p_Price_Break_rec.attribute5 IS NULL))))
1342: AND ( (l_Price_Break_rec.attribute6 =
1343: p_Price_Break_rec.attribute6) OR

Line 1344: ((p_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR) OR

1340: ( (l_Price_Break_rec.attribute5 IS NULL) AND
1341: (p_Price_Break_rec.attribute5 IS NULL))))
1342: AND ( (l_Price_Break_rec.attribute6 =
1343: p_Price_Break_rec.attribute6) OR
1344: ((p_Price_Break_rec.attribute6 = FND_API.G_MISS_CHAR) OR
1345: ( (l_Price_Break_rec.attribute6 IS NULL) AND
1346: (p_Price_Break_rec.attribute6 IS NULL))))
1347: AND ( (l_Price_Break_rec.attribute7 =
1348: p_Price_Break_rec.attribute7) OR

Line 1349: ((p_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR) OR

1345: ( (l_Price_Break_rec.attribute6 IS NULL) AND
1346: (p_Price_Break_rec.attribute6 IS NULL))))
1347: AND ( (l_Price_Break_rec.attribute7 =
1348: p_Price_Break_rec.attribute7) OR
1349: ((p_Price_Break_rec.attribute7 = FND_API.G_MISS_CHAR) OR
1350: ( (l_Price_Break_rec.attribute7 IS NULL) AND
1351: (p_Price_Break_rec.attribute7 IS NULL))))
1352: AND ( (l_Price_Break_rec.attribute8 =
1353: p_Price_Break_rec.attribute8) OR

Line 1354: ((p_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR) OR

1350: ( (l_Price_Break_rec.attribute7 IS NULL) AND
1351: (p_Price_Break_rec.attribute7 IS NULL))))
1352: AND ( (l_Price_Break_rec.attribute8 =
1353: p_Price_Break_rec.attribute8) OR
1354: ((p_Price_Break_rec.attribute8 = FND_API.G_MISS_CHAR) OR
1355: ( (l_Price_Break_rec.attribute8 IS NULL) AND
1356: (p_Price_Break_rec.attribute8 IS NULL))))
1357: AND ( (l_Price_Break_rec.attribute9 =
1358: p_Price_Break_rec.attribute9) OR

Line 1359: ((p_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR) OR

1355: ( (l_Price_Break_rec.attribute8 IS NULL) AND
1356: (p_Price_Break_rec.attribute8 IS NULL))))
1357: AND ( (l_Price_Break_rec.attribute9 =
1358: p_Price_Break_rec.attribute9) OR
1359: ((p_Price_Break_rec.attribute9 = FND_API.G_MISS_CHAR) OR
1360: ( (l_Price_Break_rec.attribute9 IS NULL) AND
1361: (p_Price_Break_rec.attribute9 IS NULL))))
1362: AND ( (l_Price_Break_rec.context =
1363: p_Price_Break_rec.context) OR

Line 1364: ((p_Price_Break_rec.context = FND_API.G_MISS_CHAR) OR

1360: ( (l_Price_Break_rec.attribute9 IS NULL) AND
1361: (p_Price_Break_rec.attribute9 IS NULL))))
1362: AND ( (l_Price_Break_rec.context =
1363: p_Price_Break_rec.context) OR
1364: ((p_Price_Break_rec.context = FND_API.G_MISS_CHAR) OR
1365: ( (l_Price_Break_rec.context IS NULL) AND
1366: (p_Price_Break_rec.context IS NULL))))
1367: AND ( (l_Price_Break_rec.created_by =
1368: p_Price_Break_rec.created_by) OR

Line 1369: ((p_Price_Break_rec.created_by = FND_API.G_MISS_NUM) OR

1365: ( (l_Price_Break_rec.context IS NULL) AND
1366: (p_Price_Break_rec.context IS NULL))))
1367: AND ( (l_Price_Break_rec.created_by =
1368: p_Price_Break_rec.created_by) OR
1369: ((p_Price_Break_rec.created_by = FND_API.G_MISS_NUM) OR
1370: ( (l_Price_Break_rec.created_by IS NULL) AND
1371: (p_Price_Break_rec.created_by IS NULL))))
1372: AND ( (l_Price_Break_rec.creation_date =
1373: p_Price_Break_rec.creation_date) OR

Line 1374: ((p_Price_Break_rec.creation_date = FND_API.G_MISS_DATE) OR

1370: ( (l_Price_Break_rec.created_by IS NULL) AND
1371: (p_Price_Break_rec.created_by IS NULL))))
1372: AND ( (l_Price_Break_rec.creation_date =
1373: p_Price_Break_rec.creation_date) OR
1374: ((p_Price_Break_rec.creation_date = FND_API.G_MISS_DATE) OR
1375: ( (l_Price_Break_rec.creation_date IS NULL) AND
1376: (p_Price_Break_rec.creation_date IS NULL))))
1377: AND ( (l_Price_Break_rec.discount_line_id =
1378: p_Price_Break_rec.discount_line_id) OR

Line 1379: ((p_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM) OR

1375: ( (l_Price_Break_rec.creation_date IS NULL) AND
1376: (p_Price_Break_rec.creation_date IS NULL))))
1377: AND ( (l_Price_Break_rec.discount_line_id =
1378: p_Price_Break_rec.discount_line_id) OR
1379: ((p_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM) OR
1380: ( (l_Price_Break_rec.discount_line_id IS NULL) AND
1381: (p_Price_Break_rec.discount_line_id IS NULL))))
1382: AND ( (l_Price_Break_rec.end_date_active =
1383: p_Price_Break_rec.end_date_active) OR

Line 1384: ((p_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE) OR

1380: ( (l_Price_Break_rec.discount_line_id IS NULL) AND
1381: (p_Price_Break_rec.discount_line_id IS NULL))))
1382: AND ( (l_Price_Break_rec.end_date_active =
1383: p_Price_Break_rec.end_date_active) OR
1384: ((p_Price_Break_rec.end_date_active = FND_API.G_MISS_DATE) OR
1385: ( (l_Price_Break_rec.end_date_active IS NULL) AND
1386: (p_Price_Break_rec.end_date_active IS NULL))))
1387: AND ( (l_Price_Break_rec.last_updated_by =
1388: p_Price_Break_rec.last_updated_by) OR

Line 1389: ((p_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM) OR

1385: ( (l_Price_Break_rec.end_date_active IS NULL) AND
1386: (p_Price_Break_rec.end_date_active IS NULL))))
1387: AND ( (l_Price_Break_rec.last_updated_by =
1388: p_Price_Break_rec.last_updated_by) OR
1389: ((p_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM) OR
1390: ( (l_Price_Break_rec.last_updated_by IS NULL) AND
1391: (p_Price_Break_rec.last_updated_by IS NULL))))
1392: AND ( (l_Price_Break_rec.last_update_date =
1393: p_Price_Break_rec.last_update_date) OR

Line 1394: ((p_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE) OR

1390: ( (l_Price_Break_rec.last_updated_by IS NULL) AND
1391: (p_Price_Break_rec.last_updated_by IS NULL))))
1392: AND ( (l_Price_Break_rec.last_update_date =
1393: p_Price_Break_rec.last_update_date) OR
1394: ((p_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE) OR
1395: ( (l_Price_Break_rec.last_update_date IS NULL) AND
1396: (p_Price_Break_rec.last_update_date IS NULL))))
1397: AND ( (l_Price_Break_rec.last_update_login =
1398: p_Price_Break_rec.last_update_login) OR

Line 1399: ((p_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM) OR

1395: ( (l_Price_Break_rec.last_update_date IS NULL) AND
1396: (p_Price_Break_rec.last_update_date IS NULL))))
1397: AND ( (l_Price_Break_rec.last_update_login =
1398: p_Price_Break_rec.last_update_login) OR
1399: ((p_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM) OR
1400: ( (l_Price_Break_rec.last_update_login IS NULL) AND
1401: (p_Price_Break_rec.last_update_login IS NULL))))
1402: AND ( (l_Price_Break_rec.method_type_code =
1403: p_Price_Break_rec.method_type_code) OR

Line 1404: ((p_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR) OR

1400: ( (l_Price_Break_rec.last_update_login IS NULL) AND
1401: (p_Price_Break_rec.last_update_login IS NULL))))
1402: AND ( (l_Price_Break_rec.method_type_code =
1403: p_Price_Break_rec.method_type_code) OR
1404: ((p_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR) OR
1405: ( (l_Price_Break_rec.method_type_code IS NULL) AND
1406: (p_Price_Break_rec.method_type_code IS NULL))))
1407: AND ( (l_Price_Break_rec.percent =
1408: p_Price_Break_rec.percent) OR

Line 1409: ((p_Price_Break_rec.percent = FND_API.G_MISS_NUM) OR

1405: ( (l_Price_Break_rec.method_type_code IS NULL) AND
1406: (p_Price_Break_rec.method_type_code IS NULL))))
1407: AND ( (l_Price_Break_rec.percent =
1408: p_Price_Break_rec.percent) OR
1409: ((p_Price_Break_rec.percent = FND_API.G_MISS_NUM) OR
1410: ( (l_Price_Break_rec.percent IS NULL) AND
1411: (p_Price_Break_rec.percent IS NULL))))
1412: AND ( (l_Price_Break_rec.price =
1413: p_Price_Break_rec.price) OR

Line 1414: ((p_Price_Break_rec.price = FND_API.G_MISS_NUM) OR

1410: ( (l_Price_Break_rec.percent IS NULL) AND
1411: (p_Price_Break_rec.percent IS NULL))))
1412: AND ( (l_Price_Break_rec.price =
1413: p_Price_Break_rec.price) OR
1414: ((p_Price_Break_rec.price = FND_API.G_MISS_NUM) OR
1415: ( (l_Price_Break_rec.price IS NULL) AND
1416: (p_Price_Break_rec.price IS NULL))))
1417: AND ( (l_Price_Break_rec.price_break_high =
1418: p_Price_Break_rec.price_break_high) OR

Line 1419: ((p_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM) OR

1415: ( (l_Price_Break_rec.price IS NULL) AND
1416: (p_Price_Break_rec.price IS NULL))))
1417: AND ( (l_Price_Break_rec.price_break_high =
1418: p_Price_Break_rec.price_break_high) OR
1419: ((p_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM) OR
1420: ( (l_Price_Break_rec.price_break_high IS NULL) AND
1421: (p_Price_Break_rec.price_break_high IS NULL))))
1422: AND ( (l_Price_Break_rec.price_break_low =
1423: p_Price_Break_rec.price_break_low) OR

Line 1424: ((p_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM) OR

1420: ( (l_Price_Break_rec.price_break_high IS NULL) AND
1421: (p_Price_Break_rec.price_break_high IS NULL))))
1422: AND ( (l_Price_Break_rec.price_break_low =
1423: p_Price_Break_rec.price_break_low) OR
1424: ((p_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM) OR
1425: ( (l_Price_Break_rec.price_break_low IS NULL) AND
1426: (p_Price_Break_rec.price_break_low IS NULL))))
1427: AND ( (l_Price_Break_rec.program_application_id =
1428: p_Price_Break_rec.program_application_id) OR

Line 1429: ((p_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM) OR

1425: ( (l_Price_Break_rec.price_break_low IS NULL) AND
1426: (p_Price_Break_rec.price_break_low IS NULL))))
1427: AND ( (l_Price_Break_rec.program_application_id =
1428: p_Price_Break_rec.program_application_id) OR
1429: ((p_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM) OR
1430: ( (l_Price_Break_rec.program_application_id IS NULL) AND
1431: (p_Price_Break_rec.program_application_id IS NULL))))
1432: AND ( (l_Price_Break_rec.program_id =
1433: p_Price_Break_rec.program_id) OR

Line 1434: ((p_Price_Break_rec.program_id = FND_API.G_MISS_NUM) OR

1430: ( (l_Price_Break_rec.program_application_id IS NULL) AND
1431: (p_Price_Break_rec.program_application_id IS NULL))))
1432: AND ( (l_Price_Break_rec.program_id =
1433: p_Price_Break_rec.program_id) OR
1434: ((p_Price_Break_rec.program_id = FND_API.G_MISS_NUM) OR
1435: ( (l_Price_Break_rec.program_id IS NULL) AND
1436: (p_Price_Break_rec.program_id IS NULL))))
1437: AND ( (l_Price_Break_rec.program_update_date =
1438: p_Price_Break_rec.program_update_date) OR

Line 1439: ((p_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE) OR

1435: ( (l_Price_Break_rec.program_id IS NULL) AND
1436: (p_Price_Break_rec.program_id IS NULL))))
1437: AND ( (l_Price_Break_rec.program_update_date =
1438: p_Price_Break_rec.program_update_date) OR
1439: ((p_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE) OR
1440: ( (l_Price_Break_rec.program_update_date IS NULL) AND
1441: (p_Price_Break_rec.program_update_date IS NULL))))
1442: AND ( (l_Price_Break_rec.request_id =
1443: p_Price_Break_rec.request_id) OR

Line 1444: ((p_Price_Break_rec.request_id = FND_API.G_MISS_NUM) OR

1440: ( (l_Price_Break_rec.program_update_date IS NULL) AND
1441: (p_Price_Break_rec.program_update_date IS NULL))))
1442: AND ( (l_Price_Break_rec.request_id =
1443: p_Price_Break_rec.request_id) OR
1444: ((p_Price_Break_rec.request_id = FND_API.G_MISS_NUM) OR
1445: ( (l_Price_Break_rec.request_id IS NULL) AND
1446: (p_Price_Break_rec.request_id IS NULL))))
1447: AND ( (l_Price_Break_rec.start_date_active =
1448: p_Price_Break_rec.start_date_active) OR

Line 1449: ((p_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE) OR

1445: ( (l_Price_Break_rec.request_id IS NULL) AND
1446: (p_Price_Break_rec.request_id IS NULL))))
1447: AND ( (l_Price_Break_rec.start_date_active =
1448: p_Price_Break_rec.start_date_active) OR
1449: ((p_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE) OR
1450: ( (l_Price_Break_rec.start_date_active IS NULL) AND
1451: (p_Price_Break_rec.start_date_active IS NULL))))
1452: AND ( (l_Price_Break_rec.unit_code =
1453: p_Price_Break_rec.unit_code) OR

Line 1454: ((p_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR) OR

1450: ( (l_Price_Break_rec.start_date_active IS NULL) AND
1451: (p_Price_Break_rec.start_date_active IS NULL))))
1452: AND ( (l_Price_Break_rec.unit_code =
1453: p_Price_Break_rec.unit_code) OR
1454: ((p_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR) OR
1455: ( (l_Price_Break_rec.unit_code IS NULL) AND
1456: (p_Price_Break_rec.unit_code IS NULL))))
1457: THEN
1458:

Line 1465: x_return_status := FND_API.G_RET_STS_SUCCESS;

1461: x_Price_Break_rec := l_Price_Break_rec;
1462:
1463: -- Set return status
1464:
1465: x_return_status := FND_API.G_RET_STS_SUCCESS;
1466: x_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1467:
1468: ELSE
1469:

Line 1466: x_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1462:
1463: -- Set return status
1464:
1465: x_return_status := FND_API.G_RET_STS_SUCCESS;
1466: x_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1467:
1468: ELSE
1469:
1470: -- Row has changed by another user.

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR;

1468: ELSE
1469:
1470: -- Row has changed by another user.
1471:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1474:
1475: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN

Line 1473: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1469:
1470: -- Row has changed by another user.
1471:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1474:
1475: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN
1477:

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485: EXCEPTION
1486:
1487: WHEN NO_DATA_FOUND THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1493: THEN

Line 1490: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1486:
1487: WHEN NO_DATA_FOUND THEN
1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1493: THEN
1494:

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR;

1497:
1498: END IF;
1499: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN

Line 1502: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1498: END IF;
1499: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506:

Line 1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1509:
1510: END IF;
1511: WHEN OTHERS THEN
1512:
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: x_Price_Break_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1517: THEN

Line 1514: x_Price_Break_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1510: END IF;
1511: WHEN OTHERS THEN
1512:
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: x_Price_Break_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: OE_MSG_PUB.Add_Exc_Msg

Line 1538: p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM AND

1534: l_Price_Break_val_rec OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
1535: BEGIN
1536: /*
1537: IF p_Price_Break_rec.discount_line_id IS NOT NULL AND
1538: p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM AND
1539: NOT OE_GLOBALS.Equal(p_Price_Break_rec.discount_line_id,
1540: p_old_Price_Break_rec.discount_line_id)
1541: THEN
1542: l_Price_Break_val_rec.discount_line := OE_Id_To_Value.Discount_Line

Line 1548: p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR AND

1544: );
1545: END IF;
1546: */
1547: IF p_Price_Break_rec.method_type_code IS NOT NULL AND
1548: p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR AND
1549: NOT OE_GLOBALS.Equal(p_Price_Break_rec.method_type_code,
1550: p_old_Price_Break_rec.method_type_code)
1551: THEN
1552: l_Price_Break_val_rec.method_type := OE_Id_To_Value.Method_Type

Line 1558: p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR AND

1554: );
1555: END IF;
1556:
1557: IF p_Price_Break_rec.unit_code IS NOT NULL AND
1558: p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR AND
1559: NOT OE_GLOBALS.Equal(p_Price_Break_rec.unit_code,
1560: p_old_Price_Break_rec.unit_code)
1561: THEN
1562: l_Price_Break_val_rec.unit := OE_Id_To_Value.Unit

Line 1583: l_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1579: BEGIN
1580:
1581: -- initialize return_status.
1582:
1583: l_Price_Break_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: -- initialize l_Price_Break_rec.
1586:
1587: l_Price_Break_rec := p_Price_Break_rec;

Line 1589: IF p_Price_Break_val_rec.discount_line <> FND_API.G_MISS_CHAR

1585: -- initialize l_Price_Break_rec.
1586:
1587: l_Price_Break_rec := p_Price_Break_rec;
1588: /*
1589: IF p_Price_Break_val_rec.discount_line <> FND_API.G_MISS_CHAR
1590: THEN
1591:
1592: IF p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM THEN
1593:

Line 1592: IF p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM THEN

1588: /*
1589: IF p_Price_Break_val_rec.discount_line <> FND_API.G_MISS_CHAR
1590: THEN
1591:
1592: IF p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM THEN
1593:
1594: l_Price_Break_rec.discount_line_id := p_Price_Break_rec.discount_line_id;
1595:
1596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1611: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN

1607: l_Price_Break_rec.discount_line_id := OE_Value_To_Id.discount_line
1608: ( p_discount_line => p_Price_Break_val_rec.discount_line
1609: );
1610:
1611: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
1612: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;
1614:
1615: END IF;

Line 1612: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1608: ( p_discount_line => p_Price_Break_val_rec.discount_line
1609: );
1610:
1611: IF l_Price_Break_rec.discount_line_id = FND_API.G_MISS_NUM THEN
1612: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1613: END IF;
1614:
1615: END IF;
1616:

Line 1619: IF p_Price_Break_val_rec.method_type <> FND_API.G_MISS_CHAR

1615: END IF;
1616:
1617: END IF;
1618: */
1619: IF p_Price_Break_val_rec.method_type <> FND_API.G_MISS_CHAR
1620: THEN
1621:
1622: IF p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR THEN
1623:

Line 1622: IF p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR THEN

1618: */
1619: IF p_Price_Break_val_rec.method_type <> FND_API.G_MISS_CHAR
1620: THEN
1621:
1622: IF p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR THEN
1623:
1624: l_Price_Break_rec.method_type_code := p_Price_Break_rec.method_type_code;
1625:
1626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1641: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN

1637: l_Price_Break_rec.method_type_code := OE_Value_To_Id.method_type
1638: ( p_method_type => p_Price_Break_val_rec.method_type
1639: );
1640:
1641: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
1642: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1643: END IF;
1644:
1645: END IF;

Line 1642: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1638: ( p_method_type => p_Price_Break_val_rec.method_type
1639: );
1640:
1641: IF l_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR THEN
1642: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1643: END IF;
1644:
1645: END IF;
1646:

Line 1649: IF p_Price_Break_val_rec.unit <> FND_API.G_MISS_CHAR

1645: END IF;
1646:
1647: END IF;
1648:
1649: IF p_Price_Break_val_rec.unit <> FND_API.G_MISS_CHAR
1650: THEN
1651:
1652: IF p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR THEN
1653:

Line 1652: IF p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR THEN

1648:
1649: IF p_Price_Break_val_rec.unit <> FND_API.G_MISS_CHAR
1650: THEN
1651:
1652: IF p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR THEN
1653:
1654: l_Price_Break_rec.unit_code := p_Price_Break_rec.unit_code;
1655:
1656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1671: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN

1667: l_Price_Break_rec.unit_code := OE_Value_To_Id.unit
1668: ( p_unit => p_Price_Break_val_rec.unit
1669: );
1670:
1671: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN
1672: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1673: END IF;
1674:
1675: END IF;

Line 1672: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;

1668: ( p_unit => p_Price_Break_val_rec.unit
1669: );
1670:
1671: IF l_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR THEN
1672: l_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1673: END IF;
1674:
1675: END IF;
1676: