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.QP_FORMULA_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_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
13: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type

Line 31: IF p_attr_id = FND_API.G_MISS_NUM THEN

27:
28: -- If attr_id is missing compare old and new records and for
29: -- every changed attribute clear its dependent fields.
30:
31: IF p_attr_id = FND_API.G_MISS_NUM THEN
32:
33: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)
34: THEN
35: l_index := l_index + 1;

Line 446: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

442: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
443: BEGIN
444:
445: oe_debug_pub.add('Entering proc Complete_Record in Formula Util Pkg');
446: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
447: l_FORMULA_rec.attribute1 := p_old_FORMULA_rec.attribute1;
448: END IF;
449:
450: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 450: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

446: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
447: l_FORMULA_rec.attribute1 := p_old_FORMULA_rec.attribute1;
448: END IF;
449:
450: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
451: l_FORMULA_rec.attribute10 := p_old_FORMULA_rec.attribute10;
452: END IF;
453:
454: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 454: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

450: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
451: l_FORMULA_rec.attribute10 := p_old_FORMULA_rec.attribute10;
452: END IF;
453:
454: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
455: l_FORMULA_rec.attribute11 := p_old_FORMULA_rec.attribute11;
456: END IF;
457:
458: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 458: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

454: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
455: l_FORMULA_rec.attribute11 := p_old_FORMULA_rec.attribute11;
456: END IF;
457:
458: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
459: l_FORMULA_rec.attribute12 := p_old_FORMULA_rec.attribute12;
460: END IF;
461:
462: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 462: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

458: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
459: l_FORMULA_rec.attribute12 := p_old_FORMULA_rec.attribute12;
460: END IF;
461:
462: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
463: l_FORMULA_rec.attribute13 := p_old_FORMULA_rec.attribute13;
464: END IF;
465:
466: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 466: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

462: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
463: l_FORMULA_rec.attribute13 := p_old_FORMULA_rec.attribute13;
464: END IF;
465:
466: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
467: l_FORMULA_rec.attribute14 := p_old_FORMULA_rec.attribute14;
468: END IF;
469:
470: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 470: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

466: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
467: l_FORMULA_rec.attribute14 := p_old_FORMULA_rec.attribute14;
468: END IF;
469:
470: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
471: l_FORMULA_rec.attribute15 := p_old_FORMULA_rec.attribute15;
472: END IF;
473:
474: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 474: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

470: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
471: l_FORMULA_rec.attribute15 := p_old_FORMULA_rec.attribute15;
472: END IF;
473:
474: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
475: l_FORMULA_rec.attribute2 := p_old_FORMULA_rec.attribute2;
476: END IF;
477:
478: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 478: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

474: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
475: l_FORMULA_rec.attribute2 := p_old_FORMULA_rec.attribute2;
476: END IF;
477:
478: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
479: l_FORMULA_rec.attribute3 := p_old_FORMULA_rec.attribute3;
480: END IF;
481:
482: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 482: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

478: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
479: l_FORMULA_rec.attribute3 := p_old_FORMULA_rec.attribute3;
480: END IF;
481:
482: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
483: l_FORMULA_rec.attribute4 := p_old_FORMULA_rec.attribute4;
484: END IF;
485:
486: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 486: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

482: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
483: l_FORMULA_rec.attribute4 := p_old_FORMULA_rec.attribute4;
484: END IF;
485:
486: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
487: l_FORMULA_rec.attribute5 := p_old_FORMULA_rec.attribute5;
488: END IF;
489:
490: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 490: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

486: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
487: l_FORMULA_rec.attribute5 := p_old_FORMULA_rec.attribute5;
488: END IF;
489:
490: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
491: l_FORMULA_rec.attribute6 := p_old_FORMULA_rec.attribute6;
492: END IF;
493:
494: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 494: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

490: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
491: l_FORMULA_rec.attribute6 := p_old_FORMULA_rec.attribute6;
492: END IF;
493:
494: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
495: l_FORMULA_rec.attribute7 := p_old_FORMULA_rec.attribute7;
496: END IF;
497:
498: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 498: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

494: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
495: l_FORMULA_rec.attribute7 := p_old_FORMULA_rec.attribute7;
496: END IF;
497:
498: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
499: l_FORMULA_rec.attribute8 := p_old_FORMULA_rec.attribute8;
500: END IF;
501:
502: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 502: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

498: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
499: l_FORMULA_rec.attribute8 := p_old_FORMULA_rec.attribute8;
500: END IF;
501:
502: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
503: l_FORMULA_rec.attribute9 := p_old_FORMULA_rec.attribute9;
504: END IF;
505:
506: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

Line 506: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

502: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
503: l_FORMULA_rec.attribute9 := p_old_FORMULA_rec.attribute9;
504: END IF;
505:
506: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN
507: l_FORMULA_rec.context := p_old_FORMULA_rec.context;
508: END IF;
509:
510: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN

Line 510: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN

506: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN
507: l_FORMULA_rec.context := p_old_FORMULA_rec.context;
508: END IF;
509:
510: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN
511: l_FORMULA_rec.created_by := p_old_FORMULA_rec.created_by;
512: END IF;
513:
514: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 514: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN

510: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN
511: l_FORMULA_rec.created_by := p_old_FORMULA_rec.created_by;
512: END IF;
513:
514: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN
515: l_FORMULA_rec.creation_date := p_old_FORMULA_rec.creation_date;
516: END IF;
517:
518: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN

Line 518: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN

514: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN
515: l_FORMULA_rec.creation_date := p_old_FORMULA_rec.creation_date;
516: END IF;
517:
518: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN
519: l_FORMULA_rec.description := p_old_FORMULA_rec.description;
520: END IF;
521:
522: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 522: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN

518: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN
519: l_FORMULA_rec.description := p_old_FORMULA_rec.description;
520: END IF;
521:
522: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN
523: l_FORMULA_rec.end_date_active := p_old_FORMULA_rec.end_date_active;
524: END IF;
525:
526: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN

Line 526: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN

522: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN
523: l_FORMULA_rec.end_date_active := p_old_FORMULA_rec.end_date_active;
524: END IF;
525:
526: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN
527: l_FORMULA_rec.formula := p_old_FORMULA_rec.formula;
528: END IF;
529:
530: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 530: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

526: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN
527: l_FORMULA_rec.formula := p_old_FORMULA_rec.formula;
528: END IF;
529:
530: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
531: l_FORMULA_rec.last_updated_by := p_old_FORMULA_rec.last_updated_by;
532: END IF;
533:
534: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 534: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

530: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
531: l_FORMULA_rec.last_updated_by := p_old_FORMULA_rec.last_updated_by;
532: END IF;
533:
534: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN
535: l_FORMULA_rec.last_update_date := p_old_FORMULA_rec.last_update_date;
536: END IF;
537:
538: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 538: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

534: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN
535: l_FORMULA_rec.last_update_date := p_old_FORMULA_rec.last_update_date;
536: END IF;
537:
538: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN
539: l_FORMULA_rec.last_update_login := p_old_FORMULA_rec.last_update_login;
540: END IF;
541:
542: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN

Line 542: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN

538: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN
539: l_FORMULA_rec.last_update_login := p_old_FORMULA_rec.last_update_login;
540: END IF;
541:
542: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN
543: l_FORMULA_rec.name := p_old_FORMULA_rec.name;
544: END IF;
545:
546: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 546: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

542: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN
543: l_FORMULA_rec.name := p_old_FORMULA_rec.name;
544: END IF;
545:
546: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
547: l_FORMULA_rec.price_formula_id := p_old_FORMULA_rec.price_formula_id;
548: END IF;
549:
550: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 550: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN

546: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
547: l_FORMULA_rec.price_formula_id := p_old_FORMULA_rec.price_formula_id;
548: END IF;
549:
550: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN
551: l_FORMULA_rec.start_date_active := p_old_FORMULA_rec.start_date_active;
552: END IF;
553:
554: oe_debug_pub.add('Leaving proc Complete_Record in Formula Util Pkg');

Line 569: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

565: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type := p_FORMULA_rec;
566: BEGIN
567:
568: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in Formula Util Pkg');
569: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
570: l_FORMULA_rec.attribute1 := NULL;
571: END IF;
572:
573: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 573: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

569: IF l_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
570: l_FORMULA_rec.attribute1 := NULL;
571: END IF;
572:
573: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
574: l_FORMULA_rec.attribute10 := NULL;
575: END IF;
576:
577: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 577: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

573: IF l_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
574: l_FORMULA_rec.attribute10 := NULL;
575: END IF;
576:
577: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
578: l_FORMULA_rec.attribute11 := NULL;
579: END IF;
580:
581: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 581: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

577: IF l_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
578: l_FORMULA_rec.attribute11 := NULL;
579: END IF;
580:
581: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
582: l_FORMULA_rec.attribute12 := NULL;
583: END IF;
584:
585: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 585: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

581: IF l_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
582: l_FORMULA_rec.attribute12 := NULL;
583: END IF;
584:
585: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
586: l_FORMULA_rec.attribute13 := NULL;
587: END IF;
588:
589: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 589: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

585: IF l_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
586: l_FORMULA_rec.attribute13 := NULL;
587: END IF;
588:
589: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
590: l_FORMULA_rec.attribute14 := NULL;
591: END IF;
592:
593: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 593: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

589: IF l_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
590: l_FORMULA_rec.attribute14 := NULL;
591: END IF;
592:
593: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
594: l_FORMULA_rec.attribute15 := NULL;
595: END IF;
596:
597: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 597: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

593: IF l_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
594: l_FORMULA_rec.attribute15 := NULL;
595: END IF;
596:
597: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
598: l_FORMULA_rec.attribute2 := NULL;
599: END IF;
600:
601: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 601: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

597: IF l_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
598: l_FORMULA_rec.attribute2 := NULL;
599: END IF;
600:
601: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
602: l_FORMULA_rec.attribute3 := NULL;
603: END IF;
604:
605: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 605: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

601: IF l_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
602: l_FORMULA_rec.attribute3 := NULL;
603: END IF;
604:
605: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
606: l_FORMULA_rec.attribute4 := NULL;
607: END IF;
608:
609: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

605: IF l_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
606: l_FORMULA_rec.attribute4 := NULL;
607: END IF;
608:
609: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
610: l_FORMULA_rec.attribute5 := NULL;
611: END IF;
612:
613: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

609: IF l_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
610: l_FORMULA_rec.attribute5 := NULL;
611: END IF;
612:
613: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
614: l_FORMULA_rec.attribute6 := NULL;
615: END IF;
616:
617: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

613: IF l_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
614: l_FORMULA_rec.attribute6 := NULL;
615: END IF;
616:
617: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
618: l_FORMULA_rec.attribute7 := NULL;
619: END IF;
620:
621: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

617: IF l_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
618: l_FORMULA_rec.attribute7 := NULL;
619: END IF;
620:
621: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
622: l_FORMULA_rec.attribute8 := NULL;
623: END IF;
624:
625: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

621: IF l_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
622: l_FORMULA_rec.attribute8 := NULL;
623: END IF;
624:
625: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
626: l_FORMULA_rec.attribute9 := NULL;
627: END IF;
628:
629: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

Line 629: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

625: IF l_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
626: l_FORMULA_rec.attribute9 := NULL;
627: END IF;
628:
629: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN
630: l_FORMULA_rec.context := NULL;
631: END IF;
632:
633: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN

Line 633: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN

629: IF l_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN
630: l_FORMULA_rec.context := NULL;
631: END IF;
632:
633: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN
634: l_FORMULA_rec.created_by := NULL;
635: END IF;
636:
637: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 637: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN

633: IF l_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN
634: l_FORMULA_rec.created_by := NULL;
635: END IF;
636:
637: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN
638: l_FORMULA_rec.creation_date := NULL;
639: END IF;
640:
641: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN

Line 641: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN

637: IF l_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN
638: l_FORMULA_rec.creation_date := NULL;
639: END IF;
640:
641: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN
642: l_FORMULA_rec.description := NULL;
643: END IF;
644:
645: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 645: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN

641: IF l_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN
642: l_FORMULA_rec.description := NULL;
643: END IF;
644:
645: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN
646: l_FORMULA_rec.end_date_active := NULL;
647: END IF;
648:
649: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN

Line 649: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN

645: IF l_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN
646: l_FORMULA_rec.end_date_active := NULL;
647: END IF;
648:
649: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN
650: l_FORMULA_rec.formula := NULL;
651: END IF;
652:
653: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 653: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

649: IF l_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN
650: l_FORMULA_rec.formula := NULL;
651: END IF;
652:
653: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
654: l_FORMULA_rec.last_updated_by := NULL;
655: END IF;
656:
657: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 657: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

653: IF l_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
654: l_FORMULA_rec.last_updated_by := NULL;
655: END IF;
656:
657: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN
658: l_FORMULA_rec.last_update_date := NULL;
659: END IF;
660:
661: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 661: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

657: IF l_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN
658: l_FORMULA_rec.last_update_date := NULL;
659: END IF;
660:
661: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN
662: l_FORMULA_rec.last_update_login := NULL;
663: END IF;
664:
665: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN

Line 665: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN

661: IF l_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN
662: l_FORMULA_rec.last_update_login := NULL;
663: END IF;
664:
665: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN
666: l_FORMULA_rec.name := NULL;
667: END IF;
668:
669: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 669: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

665: IF l_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN
666: l_FORMULA_rec.name := NULL;
667: END IF;
668:
669: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
670: l_FORMULA_rec.price_formula_id := NULL;
671: END IF;
672:
673: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 673: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN

669: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
670: l_FORMULA_rec.price_formula_id := NULL;
671: END IF;
672:
673: IF l_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN
674: l_FORMULA_rec.start_date_active := NULL;
675: END IF;
676:
677: oe_debug_pub.add('Leaving proc Convert_Miss_To_Null in Formula Util Pkg');

Line 743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

739: , 'Update_Row'
740: );
741: END IF;
742:
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744:
745: END Update_Row;
746:
747: -- Procedure Insert_Row

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: , 'Insert_Row'
850: );
851: END IF;
852:
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:
855: END Insert_Row;
856:
857: -- Procedure Delete_Row

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

881: , 'Delete_Row'
882: );
883: END IF;
884:
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886:
887: END Delete_Row;
888:
889: -- Function Query_Row

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

972: , 'Query_Row'
973: );
974: END IF;
975:
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977:
978: END Query_Row;
979:
980: -- Procedure lock_Row

Line 1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

1103: x_FORMULA_rec := l_FORMULA_rec;
1104:
1105: -- Set return status
1106:
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: x_FORMULA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1109:
1110: ELSE
1111:

Line 1108: x_FORMULA_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1104:
1105: -- Set return status
1106:
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: x_FORMULA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1109:
1110: ELSE
1111:
1112: -- Row has changed by another user.

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: ELSE
1111:
1112: -- Row has changed by another user.
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1116:
1117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1118: THEN

Line 1115: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;

1111:
1112: -- Row has changed by another user.
1113:
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1116:
1117: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1118: THEN
1119:

Line 1132: x_return_status := FND_API.G_RET_STS_ERROR;

1128: EXCEPTION
1129:
1130: WHEN NO_DATA_FOUND THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1134:
1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1136: THEN

Line 1133: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;

1129:
1130: WHEN NO_DATA_FOUND THEN
1131:
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1134:
1135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1136: THEN
1137:

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140:
1141: END IF;
1142: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN

Line 1145: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;

1141: END IF;
1142: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: x_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149:

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152:
1153: END IF;
1154: WHEN OTHERS THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_FORMULA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN

Line 1157: x_FORMULA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1153: END IF;
1154: WHEN OTHERS THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_FORMULA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg

Line 1182: p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM AND

1178: BEGIN
1179:
1180: oe_debug_pub.add('Entering proc Get_Values in Formula Util Pkg');
1181: IF p_FORMULA_rec.price_formula_id IS NOT NULL AND
1182: p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1183: NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,
1184: p_old_FORMULA_rec.price_formula_id)
1185: THEN
1186: l_FORMULA_val_rec.price_formula := QP_Id_To_Value.Price_Formula

Line 1209: l_FORMULA_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1205:
1206: oe_debug_pub.add('Entering proc Get_Ids in Formula Util Pkg');
1207: -- initialize return_status.
1208:
1209: l_FORMULA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: -- initialize l_FORMULA_rec.
1212:
1213: l_FORMULA_rec := p_FORMULA_rec;

Line 1215: IF p_FORMULA_val_rec.price_formula <> FND_API.G_MISS_CHAR

1211: -- initialize l_FORMULA_rec.
1212:
1213: l_FORMULA_rec := p_FORMULA_rec;
1214:
1215: IF p_FORMULA_val_rec.price_formula <> FND_API.G_MISS_CHAR
1216: THEN
1217:
1218: IF p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
1219:

Line 1218: IF p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM THEN

1214:
1215: IF p_FORMULA_val_rec.price_formula <> FND_API.G_MISS_CHAR
1216: THEN
1217:
1218: IF p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
1219:
1220: l_FORMULA_rec.price_formula_id := p_FORMULA_rec.price_formula_id;
1221:
1222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1237: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

1233: l_FORMULA_rec.price_formula_id := QP_Value_To_Id.price_formula
1234: ( p_price_formula => p_FORMULA_val_rec.price_formula
1235: );
1236:
1237: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1238: l_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1239: END IF;
1240:
1241: END IF;

Line 1238: l_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;

1234: ( p_price_formula => p_FORMULA_val_rec.price_formula
1235: );
1236:
1237: IF l_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1238: l_FORMULA_rec.return_status := FND_API.G_RET_STS_ERROR;
1239: END IF;
1240:
1241: END IF;
1242: