[Home] [Help]
42: FND_MESSAGE.SET_TOKEN(p_token4_name, p_token4_val);
43: end if;
44: --
45: FND_MSG_PUB.Add;
46: RAISE FND_API.G_EXC_ERROR;
47: end ExitWithErrMsg;
48:
49: --|---------------------------------------------------
50: --| procedure name: validate_uom
480: l_minimum_value VARCHAR2(240);
481: l_maximum_value VARCHAR2(240);
482:
483: BEGIN
484: IF p_default_value = FND_API.G_MISS_CHAR THEN
485: l_default_value := NULL;
486: END IF;
487:
488: IF p_maximum_value = FND_API.G_MISS_CHAR THEN
484: IF p_default_value = FND_API.G_MISS_CHAR THEN
485: l_default_value := NULL;
486: END IF;
487:
488: IF p_maximum_value = FND_API.G_MISS_CHAR THEN
489: l_maximum_value := NULL;
490: END IF;
491:
492: IF p_minimum_value = FND_API.G_MISS_CHAR THEN
488: IF p_maximum_value = FND_API.G_MISS_CHAR THEN
489: l_maximum_value := NULL;
490: END IF;
491:
492: IF p_minimum_value = FND_API.G_MISS_CHAR THEN
493: l_minimum_value := NULL;
494: END IF;
495:
496: IF p_property_data_type = 'CHAR' THEN
616: -- Standard Start of API savepoint
617: SAVEPOINT create_counter_pvt;
618:
619: -- Standard call to check for call compatibility.
620: IF NOT FND_API.Compatible_API_Call (l_api_version,
621: p_api_version,
622: l_api_name ,
623: G_PKG_NAME )
624: THEN
621: p_api_version,
622: l_api_name ,
623: G_PKG_NAME )
624: THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627:
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: -- Initialize API return status to success
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: -- Initialize API return status to success
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: -- Read the debug profiles values in to global variable 7197402
637: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
638:
654: csi_ctr_gen_utility_pvt.dump_counter_instance_rec(p_counter_instance_rec);
655: END IF;
656:
657: -- Start of API Body
658: if p_counter_instance_rec.counter_id = FND_API.G_MISS_NUM then
659: l_counter_id := null;
660: else
661: l_counter_id := p_counter_instance_rec.counter_id;
662: end if;
659: l_counter_id := null;
660: else
661: l_counter_id := p_counter_instance_rec.counter_id;
662: end if;
663: if p_counter_instance_rec.group_id = FND_API.G_MISS_NUM then
664: l_group_id := null;
665: else
666: l_group_id := p_counter_instance_rec.group_id;
667: end if;
664: l_group_id := null;
665: else
666: l_group_id := p_counter_instance_rec.group_id;
667: end if;
668: if p_counter_instance_rec.name = FND_API.G_MISS_CHAR then
669: l_name := null;
670: else
671: l_name := p_counter_instance_rec.name;
672: end if;
669: l_name := null;
670: else
671: l_name := p_counter_instance_rec.name;
672: end if;
673: if p_counter_instance_rec.description = FND_API.G_MISS_CHAR then
674: l_description := null;
675: else
676: l_description := p_counter_instance_rec.description;
677: end if;
674: l_description := null;
675: else
676: l_description := p_counter_instance_rec.description;
677: end if;
678: if p_counter_instance_rec.counter_type = FND_API.G_MISS_CHAR then
679: l_counter_type := null;
680: else
681: l_counter_type := p_counter_instance_rec.counter_type;
682: end if;
679: l_counter_type := null;
680: else
681: l_counter_type := p_counter_instance_rec.counter_type;
682: end if;
683: if p_counter_instance_rec.uom_code = FND_API.G_MISS_CHAR then
684: l_uom_code := null;
685: else
686: l_uom_code := p_counter_instance_rec.uom_code;
687: end if;
684: l_uom_code := null;
685: else
686: l_uom_code := p_counter_instance_rec.uom_code;
687: end if;
688: if p_counter_instance_rec.usage_item_id = FND_API.G_MISS_NUM then
689: l_usage_item_id := null;
690: else
691: l_usage_item_id := p_counter_instance_rec.usage_item_id;
692: end if;
689: l_usage_item_id := null;
690: else
691: l_usage_item_id := p_counter_instance_rec.usage_item_id;
692: end if;
693: if p_counter_instance_rec.reading_type = FND_API.G_MISS_NUM then
694: l_reading_type := null;
695: else
696: l_reading_type := p_counter_instance_rec.reading_type;
697: end if;
694: l_reading_type := null;
695: else
696: l_reading_type := p_counter_instance_rec.reading_type;
697: end if;
698: if p_counter_instance_rec.direction = FND_API.G_MISS_CHAR then
699: l_direction := null;
700: else
701: l_direction := p_counter_instance_rec.direction;
702: end if;
699: l_direction := null;
700: else
701: l_direction := p_counter_instance_rec.direction;
702: end if;
703: if p_counter_instance_rec.estimation_id = FND_API.G_MISS_NUM then
704: l_estimation_id := null;
705: else
706: l_estimation_id := p_counter_instance_rec.estimation_id;
707: end if;
704: l_estimation_id := null;
705: else
706: l_estimation_id := p_counter_instance_rec.estimation_id;
707: end if;
708: if p_counter_instance_rec.derive_function = FND_API.G_MISS_CHAR then
709: l_derive_function := null;
710: else
711: l_derive_function := p_counter_instance_rec.derive_function;
712: end if;
709: l_derive_function := null;
710: else
711: l_derive_function := p_counter_instance_rec.derive_function;
712: end if;
713: if p_counter_instance_rec.formula_text = FND_API.G_MISS_CHAR then
714: l_formula_text := null;
715: else
716: l_formula_text := p_counter_instance_rec.formula_text;
717: end if;
714: l_formula_text := null;
715: else
716: l_formula_text := p_counter_instance_rec.formula_text;
717: end if;
718: if p_counter_instance_rec.derive_counter_id = FND_API.G_MISS_NUM then
719: l_derive_counter_id := null;
720: else
721: l_derive_counter_id := p_counter_instance_rec.derive_counter_id;
722: end if;
719: l_derive_counter_id := null;
720: else
721: l_derive_counter_id := p_counter_instance_rec.derive_counter_id;
722: end if;
723: if p_counter_instance_rec.filter_type = FND_API.G_MISS_CHAR then
724: l_filter_type := null;
725: else
726: l_filter_type := p_counter_instance_rec.filter_type;
727: end if;
724: l_filter_type := null;
725: else
726: l_filter_type := p_counter_instance_rec.filter_type;
727: end if;
728: if p_counter_instance_rec.filter_reading_count = FND_API.G_MISS_NUM then
729: l_filter_reading_count := null;
730: else
731: l_filter_reading_count := p_counter_instance_rec.filter_reading_count;
732: end if;
729: l_filter_reading_count := null;
730: else
731: l_filter_reading_count := p_counter_instance_rec.filter_reading_count;
732: end if;
733: if p_counter_instance_rec.filter_time_uom = FND_API.G_MISS_CHAR then
734: l_filter_time_uom := null;
735: else
736: l_filter_time_uom := p_counter_instance_rec.filter_time_uom;
737: end if;
734: l_filter_time_uom := null;
735: else
736: l_filter_time_uom := p_counter_instance_rec.filter_time_uom;
737: end if;
738: if p_counter_instance_rec.automatic_rollover = FND_API.G_MISS_CHAR then
739: l_automatic_rollover := null;
740: else
741: l_automatic_rollover := p_counter_instance_rec.automatic_rollover;
742: end if;
739: l_automatic_rollover := null;
740: else
741: l_automatic_rollover := p_counter_instance_rec.automatic_rollover;
742: end if;
743: if p_counter_instance_rec.rollover_last_reading = FND_API.G_MISS_NUM then
744: l_rollover_last_reading := null;
745: else
746: l_rollover_last_reading := p_counter_instance_rec.rollover_last_reading;
747: end if;
744: l_rollover_last_reading := null;
745: else
746: l_rollover_last_reading := p_counter_instance_rec.rollover_last_reading;
747: end if;
748: if p_counter_instance_rec.rollover_first_reading = FND_API.G_MISS_NUM then
749: l_rollover_first_reading := null;
750: else
751: l_rollover_first_reading := p_counter_instance_rec.rollover_first_reading;
752: end if;
749: l_rollover_first_reading := null;
750: else
751: l_rollover_first_reading := p_counter_instance_rec.rollover_first_reading;
752: end if;
753: if p_counter_instance_rec.tolerance_plus = FND_API.G_MISS_NUM then
754: l_tolerance_plus := null;
755: else
756: l_tolerance_plus := p_counter_instance_rec.tolerance_plus;
757: end if;
754: l_tolerance_plus := null;
755: else
756: l_tolerance_plus := p_counter_instance_rec.tolerance_plus;
757: end if;
758: if p_counter_instance_rec.tolerance_minus = FND_API.G_MISS_NUM then
759: l_tolerance_minus := null;
760: else
761: l_tolerance_minus := p_counter_instance_rec.tolerance_minus;
762: end if;
759: l_tolerance_minus := null;
760: else
761: l_tolerance_minus := p_counter_instance_rec.tolerance_minus;
762: end if;
763: if p_counter_instance_rec.used_in_scheduling = FND_API.G_MISS_CHAR then
764: l_used_in_scheduling := null;
765: else
766: l_used_in_scheduling := p_counter_instance_rec.used_in_scheduling;
767: end if;
764: l_used_in_scheduling := null;
765: else
766: l_used_in_scheduling := p_counter_instance_rec.used_in_scheduling;
767: end if;
768: if p_counter_instance_rec.initial_reading = FND_API.G_MISS_NUM then
769: l_initial_reading := null;
770: else
771: l_initial_reading := p_counter_instance_rec.initial_reading;
772: end if;
769: l_initial_reading := null;
770: else
771: l_initial_reading := p_counter_instance_rec.initial_reading;
772: end if;
773: if p_counter_instance_rec.default_usage_rate = FND_API.G_MISS_NUM then
774: l_default_usage_rate := null;
775: else
776: l_default_usage_rate := p_counter_instance_rec.default_usage_rate;
777: end if;
774: l_default_usage_rate := null;
775: else
776: l_default_usage_rate := p_counter_instance_rec.default_usage_rate;
777: end if;
778: if p_counter_instance_rec.use_past_reading = FND_API.G_MISS_NUM then
779: l_use_past_reading := null;
780: else
781: l_use_past_reading := p_counter_instance_rec.use_past_reading;
782: end if;
779: l_use_past_reading := null;
780: else
781: l_use_past_reading := p_counter_instance_rec.use_past_reading;
782: end if;
783: if p_counter_instance_rec.start_date_active = FND_API.G_MISS_DATE then
784: l_start_date_active := sysdate;
785: else
786: l_start_date_active := p_counter_instance_rec.start_date_active;
787: end if;
784: l_start_date_active := sysdate;
785: else
786: l_start_date_active := p_counter_instance_rec.start_date_active;
787: end if;
788: if p_counter_instance_rec.end_date_active = FND_API.G_MISS_DATE then
789: l_end_date_active := null;
790: else
791: l_end_date_active := p_counter_instance_rec.end_date_active;
792: end if;
789: l_end_date_active := null;
790: else
791: l_end_date_active := p_counter_instance_rec.end_date_active;
792: end if;
793: if p_counter_instance_rec.defaulted_group_id = FND_API.G_MISS_NUM then
794: l_defaulted_group_id := null;
795: else
796: l_defaulted_group_id := p_counter_instance_rec.defaulted_group_id;
797: end if;
794: l_defaulted_group_id := null;
795: else
796: l_defaulted_group_id := p_counter_instance_rec.defaulted_group_id;
797: end if;
798: if p_counter_instance_rec.created_from_counter_tmpl_id = FND_API.G_MISS_NUM then
799: l_created_from_counter_tmpl_id := null;
800: else
801: l_created_from_counter_tmpl_id := p_counter_instance_rec.created_from_counter_tmpl_id;
802: end if;
799: l_created_from_counter_tmpl_id := null;
800: else
801: l_created_from_counter_tmpl_id := p_counter_instance_rec.created_from_counter_tmpl_id;
802: end if;
803: if p_counter_instance_rec.attribute1 = FND_API.G_MISS_CHAR then
804: l_attribute1 := null;
805: else
806: l_attribute1 := p_counter_instance_rec.attribute1;
807: end if;
804: l_attribute1 := null;
805: else
806: l_attribute1 := p_counter_instance_rec.attribute1;
807: end if;
808: if p_counter_instance_rec.attribute2 = FND_API.G_MISS_CHAR then
809: l_attribute2 := null;
810: else
811: l_attribute2 := p_counter_instance_rec.attribute2;
812: end if;
809: l_attribute2 := null;
810: else
811: l_attribute2 := p_counter_instance_rec.attribute2;
812: end if;
813: if p_counter_instance_rec.attribute3 = FND_API.G_MISS_CHAR then
814: l_attribute3 := null;
815: else
816: l_attribute3 := p_counter_instance_rec.attribute3;
817: end if;
814: l_attribute3 := null;
815: else
816: l_attribute3 := p_counter_instance_rec.attribute3;
817: end if;
818: if p_counter_instance_rec.attribute4 = FND_API.G_MISS_CHAR then
819: l_attribute4 := null;
820: else
821: l_attribute4 := p_counter_instance_rec.attribute4;
822: end if;
819: l_attribute4 := null;
820: else
821: l_attribute4 := p_counter_instance_rec.attribute4;
822: end if;
823: if p_counter_instance_rec.attribute5 = FND_API.G_MISS_CHAR then
824: l_attribute5 := null;
825: else
826: l_attribute5 := p_counter_instance_rec.attribute5;
827: end if;
824: l_attribute5 := null;
825: else
826: l_attribute5 := p_counter_instance_rec.attribute5;
827: end if;
828: if p_counter_instance_rec.attribute6 = FND_API.G_MISS_CHAR then
829: l_attribute6 := null;
830: else
831: l_attribute6 := p_counter_instance_rec.attribute6;
832: end if;
829: l_attribute6 := null;
830: else
831: l_attribute6 := p_counter_instance_rec.attribute6;
832: end if;
833: if p_counter_instance_rec.attribute7 = FND_API.G_MISS_CHAR then
834: l_attribute7 := null;
835: else
836: l_attribute7 := p_counter_instance_rec.attribute7;
837: end if;
834: l_attribute7 := null;
835: else
836: l_attribute7 := p_counter_instance_rec.attribute7;
837: end if;
838: if p_counter_instance_rec.attribute8 = FND_API.G_MISS_CHAR then
839: l_attribute8 := null;
840: else
841: l_attribute8 := p_counter_instance_rec.attribute8;
842: end if;
839: l_attribute8 := null;
840: else
841: l_attribute8 := p_counter_instance_rec.attribute8;
842: end if;
843: if p_counter_instance_rec.attribute9 = FND_API.G_MISS_CHAR then
844: l_attribute9 := null;
845: else
846: l_attribute9 := p_counter_instance_rec.attribute9;
847: end if;
844: l_attribute9 := null;
845: else
846: l_attribute9 := p_counter_instance_rec.attribute9;
847: end if;
848: if p_counter_instance_rec.attribute10 = FND_API.G_MISS_CHAR then
849: l_attribute10 := null;
850: else
851: l_attribute10 := p_counter_instance_rec.attribute10;
852: end if;
849: l_attribute10 := null;
850: else
851: l_attribute10 := p_counter_instance_rec.attribute10;
852: end if;
853: if p_counter_instance_rec.attribute11 = FND_API.G_MISS_CHAR then
854: l_attribute11 := null;
855: else
856: l_attribute11 := p_counter_instance_rec.attribute11;
857: end if;
854: l_attribute11 := null;
855: else
856: l_attribute11 := p_counter_instance_rec.attribute11;
857: end if;
858: if p_counter_instance_rec.attribute12 = FND_API.G_MISS_CHAR then
859: l_attribute12 := null;
860: else
861: l_attribute12 := p_counter_instance_rec.attribute12;
862: end if;
859: l_attribute12 := null;
860: else
861: l_attribute12 := p_counter_instance_rec.attribute12;
862: end if;
863: if p_counter_instance_rec.attribute13 = FND_API.G_MISS_CHAR then
864: l_attribute13 := null;
865: else
866: l_attribute13 := p_counter_instance_rec.attribute13;
867: end if;
864: l_attribute13 := null;
865: else
866: l_attribute13 := p_counter_instance_rec.attribute13;
867: end if;
868: if p_counter_instance_rec.attribute14 = FND_API.G_MISS_CHAR then
869: l_attribute14 := null;
870: else
871: l_attribute14 := p_counter_instance_rec.attribute14;
872: end if;
869: l_attribute14 := null;
870: else
871: l_attribute14 := p_counter_instance_rec.attribute14;
872: end if;
873: if p_counter_instance_rec.attribute15 = FND_API.G_MISS_CHAR then
874: l_attribute15 := null;
875: else
876: l_attribute15 := p_counter_instance_rec.attribute15;
877: end if;
874: l_attribute15 := null;
875: else
876: l_attribute15 := p_counter_instance_rec.attribute15;
877: end if;
878: if p_counter_instance_rec.attribute16 = FND_API.G_MISS_CHAR then
879: l_attribute16 := null;
880: else
881: l_attribute16 := p_counter_instance_rec.attribute16;
882: end if;
879: l_attribute16 := null;
880: else
881: l_attribute16 := p_counter_instance_rec.attribute16;
882: end if;
883: if p_counter_instance_rec.attribute17 = FND_API.G_MISS_CHAR then
884: l_attribute17 := null;
885: else
886: l_attribute17 := p_counter_instance_rec.attribute17;
887: end if;
884: l_attribute17 := null;
885: else
886: l_attribute17 := p_counter_instance_rec.attribute17;
887: end if;
888: if p_counter_instance_rec.attribute18 = FND_API.G_MISS_CHAR then
889: l_attribute18 := null;
890: else
891: l_attribute18 := p_counter_instance_rec.attribute18;
892: end if;
889: l_attribute18 := null;
890: else
891: l_attribute18 := p_counter_instance_rec.attribute18;
892: end if;
893: if p_counter_instance_rec.attribute19 = FND_API.G_MISS_CHAR then
894: l_attribute19 := null;
895: else
896: l_attribute19 := p_counter_instance_rec.attribute19;
897: end if;
894: l_attribute19 := null;
895: else
896: l_attribute19 := p_counter_instance_rec.attribute19;
897: end if;
898: if p_counter_instance_rec.attribute20 = FND_API.G_MISS_CHAR then
899: l_attribute20 := null;
900: else
901: l_attribute20 := p_counter_instance_rec.attribute20;
902: end if;
899: l_attribute20 := null;
900: else
901: l_attribute20 := p_counter_instance_rec.attribute20;
902: end if;
903: if p_counter_instance_rec.attribute21 = FND_API.G_MISS_CHAR then
904: l_attribute21 := null;
905: else
906: l_attribute21 := p_counter_instance_rec.attribute21;
907: end if;
904: l_attribute21 := null;
905: else
906: l_attribute21 := p_counter_instance_rec.attribute21;
907: end if;
908: if p_counter_instance_rec.attribute22 = FND_API.G_MISS_CHAR then
909: l_attribute22 := null;
910: else
911: l_attribute22 := p_counter_instance_rec.attribute22;
912: end if;
909: l_attribute22 := null;
910: else
911: l_attribute22 := p_counter_instance_rec.attribute22;
912: end if;
913: if p_counter_instance_rec.attribute23 = FND_API.G_MISS_CHAR then
914: l_attribute23 := null;
915: else
916: l_attribute23 := p_counter_instance_rec.attribute23;
917: end if;
914: l_attribute23 := null;
915: else
916: l_attribute23 := p_counter_instance_rec.attribute23;
917: end if;
918: if p_counter_instance_rec.attribute24 = FND_API.G_MISS_CHAR then
919: l_attribute24 := null;
920: else
921: l_attribute24 := p_counter_instance_rec.attribute24;
922: end if;
919: l_attribute24 := null;
920: else
921: l_attribute24 := p_counter_instance_rec.attribute24;
922: end if;
923: if p_counter_instance_rec.attribute25 = FND_API.G_MISS_CHAR then
924: l_attribute25 := null;
925: else
926: l_attribute25 := p_counter_instance_rec.attribute25;
927: end if;
924: l_attribute25 := null;
925: else
926: l_attribute25 := p_counter_instance_rec.attribute25;
927: end if;
928: if p_counter_instance_rec.attribute26 = FND_API.G_MISS_CHAR then
929: l_attribute26 := null;
930: else
931: l_attribute26 := p_counter_instance_rec.attribute26;
932: end if;
929: l_attribute26 := null;
930: else
931: l_attribute26 := p_counter_instance_rec.attribute26;
932: end if;
933: if p_counter_instance_rec.attribute27 = FND_API.G_MISS_CHAR then
934: l_attribute27 := null;
935: else
936: l_attribute27 := p_counter_instance_rec.attribute27;
937: end if;
934: l_attribute27 := null;
935: else
936: l_attribute27 := p_counter_instance_rec.attribute27;
937: end if;
938: if p_counter_instance_rec.attribute28 = FND_API.G_MISS_CHAR then
939: l_attribute28 := null;
940: else
941: l_attribute28 := p_counter_instance_rec.attribute28;
942: end if;
939: l_attribute28 := null;
940: else
941: l_attribute28 := p_counter_instance_rec.attribute28;
942: end if;
943: if p_counter_instance_rec.attribute29 = FND_API.G_MISS_CHAR then
944: l_attribute29 := null;
945: else
946: l_attribute29 := p_counter_instance_rec.attribute29;
947: end if;
944: l_attribute29 := null;
945: else
946: l_attribute29 := p_counter_instance_rec.attribute29;
947: end if;
948: if p_counter_instance_rec.attribute30 = FND_API.G_MISS_CHAR then
949: l_attribute30 := null;
950: else
951: l_attribute30 := p_counter_instance_rec.attribute30;
952: end if;
949: l_attribute30 := null;
950: else
951: l_attribute30 := p_counter_instance_rec.attribute30;
952: end if;
953: if p_counter_instance_rec.attribute_category = FND_API.G_MISS_CHAR then
954: l_attribute_category := null;
955: else
956: l_attribute_category := p_counter_instance_rec.attribute_category;
957: end if;
954: l_attribute_category := null;
955: else
956: l_attribute_category := p_counter_instance_rec.attribute_category;
957: end if;
958: if p_counter_instance_rec.step_value = FND_API.G_MISS_NUM then
959: l_step_value := null;
960: else
961: l_step_value := p_counter_instance_rec.step_value;
962: end if;
960: else
961: l_step_value := p_counter_instance_rec.step_value;
962: end if;
963:
964: if p_counter_instance_rec.time_based_manual_entry = FND_API.G_MISS_CHAR then
965: l_time_based_manual_entry := 'N';
966: else
967: l_time_based_manual_entry := p_counter_instance_rec.time_based_manual_entry;
968: end if;
966: else
967: l_time_based_manual_entry := p_counter_instance_rec.time_based_manual_entry;
968: end if;
969:
970: if p_counter_instance_rec.eam_required_flag = FND_API.G_MISS_CHAR then
971: l_eam_required_flag := null;
972: else
973: l_eam_required_flag := p_counter_instance_rec.eam_required_flag;
974: end if;
983: IF l_start_date_active > sysdate THEN
984: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_INVALID_START_DATE');
985: END IF;
986:
987: if nvl(p_counter_instance_rec.initial_reading_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE then
988: l_initial_reading_date := sysdate;
989: else
990: l_initial_reading_date := p_counter_instance_rec.initial_reading_date;
991: end if;
1012: l_use_past_reading, -1, l_start_date_active, l_end_date_active
1013: );
1014:
1015: -- Check and Generate Counter_value_id
1016: IF l_counter_id IS NULL OR l_counter_id = FND_API.G_MISS_NUM THEN
1017: select CSI_COUNTERS_B_S.nextval
1018: into l_counter_id from dual;
1019: END IF;
1020: -- counter name suffix counter id is created from template or if duplicate exist.
1047: ,x_return_status => x_return_status
1048: ,x_msg_count => x_msg_count
1049: ,x_msg_data => x_msg_data
1050: );
1051: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1052: ROLLBACK TO create_counter_pvt;
1053: RETURN;
1054: END IF;
1055: l_defaulted_group_id := l_counter_groups_rec.counter_group_id;
1144: ,p_TIME_BASED_MANUAL_ENTRY => l_time_based_manual_entry
1145: ,p_EAM_REQUIRED_FLAG => l_eam_required_flag
1146: ,p_comments => NULL
1147: );
1148: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1149: ROLLBACK TO create_counter_pvt;
1150: RETURN;
1151: END IF;
1152: x_ctr_id := l_counter_id;
1152: x_ctr_id := l_counter_id;
1153: -- End of API body
1154:
1155: -- Standard check of p_commit.
1156: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1157: COMMIT WORK;
1158: END IF;
1159:
1160: EXCEPTION
1157: COMMIT WORK;
1158: END IF;
1159:
1160: EXCEPTION
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: x_return_status := FND_API.G_RET_STS_ERROR ;
1163: ROLLBACK TO create_counter_pvt;
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1158: END IF;
1159:
1160: EXCEPTION
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: x_return_status := FND_API.G_RET_STS_ERROR ;
1163: ROLLBACK TO create_counter_pvt;
1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168:
1169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: ROLLBACK TO create_counter_pvt;
1172: FND_MSG_PUB.Count_And_Get
1173: (p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168:
1169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: ROLLBACK TO create_counter_pvt;
1172: FND_MSG_PUB.Count_And_Get
1173: (p_count => x_msg_count,
1174: p_data => x_msg_data
1173: (p_count => x_msg_count,
1174: p_data => x_msg_data
1175: );
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: ROLLBACK TO create_counter_pvt;
1179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1180: THEN
1181: FND_MSG_PUB.Add_Exc_Msg
1255: -- Standard Start of API savepoint
1256: SAVEPOINT create_ctr_property_pvt;
1257:
1258: -- Standard call to check for call compatibility.
1259: IF NOT FND_API.Compatible_API_Call (l_api_version,
1260: p_api_version,
1261: l_api_name ,
1262: G_PKG_NAME )
1263: THEN
1260: p_api_version,
1261: l_api_name ,
1262: G_PKG_NAME )
1263: THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271:
1272: -- Initialize API return status to success
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271:
1272: -- Initialize API return status to success
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: -- Read the debug profiles values in to global variable 7197402
1276: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1277:
1293: csi_ctr_gen_utility_pvt.dump_ctr_properties_rec(p_ctr_properties_rec);
1294: END IF;
1295:
1296: -- Start of API Body
1297: if p_ctr_properties_rec.counter_id = FND_API.G_MISS_NUM then
1298: l_counter_id := null;
1299: else
1300: l_counter_id := p_ctr_properties_rec.counter_id;
1301: end if;
1298: l_counter_id := null;
1299: else
1300: l_counter_id := p_ctr_properties_rec.counter_id;
1301: end if;
1302: if p_ctr_properties_rec.name = FND_API.G_MISS_CHAR then
1303: l_name := null;
1304: else
1305: l_name := p_ctr_properties_rec.name;
1306: end if;
1303: l_name := null;
1304: else
1305: l_name := p_ctr_properties_rec.name;
1306: end if;
1307: if p_ctr_properties_rec.description = FND_API.G_MISS_CHAR then
1308: l_description := null;
1309: else
1310: l_description := p_ctr_properties_rec.description;
1311: end if;
1308: l_description := null;
1309: else
1310: l_description := p_ctr_properties_rec.description;
1311: end if;
1312: if p_ctr_properties_rec.property_data_type = FND_API.G_MISS_CHAR then
1313: l_property_data_type := null;
1314: else
1315: l_property_data_type := p_ctr_properties_rec.property_data_type;
1316: end if;
1313: l_property_data_type := null;
1314: else
1315: l_property_data_type := p_ctr_properties_rec.property_data_type;
1316: end if;
1317: if p_ctr_properties_rec.is_nullable = FND_API.G_MISS_CHAR then
1318: l_is_nullable := null;
1319: else
1320: l_is_nullable := p_ctr_properties_rec.is_nullable;
1321: if l_is_nullable not in ('Y', 'N') then
1321: if l_is_nullable not in ('Y', 'N') then
1322: l_is_nullable := 'N';
1323: end if;
1324: end if;
1325: if p_ctr_properties_rec.uom_code = FND_API.G_MISS_CHAR then
1326: l_uom_code := null;
1327: else
1328: l_uom_code := p_ctr_properties_rec.uom_code;
1329: end if;
1326: l_uom_code := null;
1327: else
1328: l_uom_code := p_ctr_properties_rec.uom_code;
1329: end if;
1330: if p_ctr_properties_rec.property_lov_type = FND_API.G_MISS_CHAR then
1331: l_property_lov_type := null;
1332: else
1333: l_property_lov_type := p_ctr_properties_rec.property_lov_type;
1334: end if;
1331: l_property_lov_type := null;
1332: else
1333: l_property_lov_type := p_ctr_properties_rec.property_lov_type;
1334: end if;
1335: if p_ctr_properties_rec.default_value = FND_API.G_MISS_CHAR then
1336: l_default_value := null;
1337: else
1338: l_default_value := p_ctr_properties_rec.default_value;
1339: end if;
1336: l_default_value := null;
1337: else
1338: l_default_value := p_ctr_properties_rec.default_value;
1339: end if;
1340: if p_ctr_properties_rec.minimum_value = FND_API.G_MISS_CHAR then
1341: l_minimum_value := null;
1342: else
1343: l_minimum_value := p_ctr_properties_rec.minimum_value;
1344: end if;
1341: l_minimum_value := null;
1342: else
1343: l_minimum_value := p_ctr_properties_rec.minimum_value;
1344: end if;
1345: if p_ctr_properties_rec.maximum_value = FND_API.G_MISS_CHAR then
1346: l_maximum_value := null;
1347: else
1348: l_maximum_value := p_ctr_properties_rec.maximum_value;
1349: end if;
1346: l_maximum_value := null;
1347: else
1348: l_maximum_value := p_ctr_properties_rec.maximum_value;
1349: end if;
1350: if p_ctr_properties_rec.start_date_active = FND_API.G_MISS_DATE then
1351: l_start_date_active := sysdate;
1352: else
1353: l_start_date_active := p_ctr_properties_rec.start_date_active;
1354: end if;
1351: l_start_date_active := sysdate;
1352: else
1353: l_start_date_active := p_ctr_properties_rec.start_date_active;
1354: end if;
1355: if p_ctr_properties_rec.end_date_active = FND_API.G_MISS_DATE then
1356: l_end_date_active := null;
1357: else
1358: l_end_date_active := p_ctr_properties_rec.end_date_active;
1359: end if;
1356: l_end_date_active := null;
1357: else
1358: l_end_date_active := p_ctr_properties_rec.end_date_active;
1359: end if;
1360: if p_ctr_properties_rec.created_from_ctr_prop_tmpl_id = FND_API.G_MISS_NUM then
1361: l_created_from_ctrprop_tmpl_id := null;
1362: else
1363: l_created_from_ctrprop_tmpl_id := p_ctr_properties_rec.created_from_ctr_prop_tmpl_id;
1364: end if;
1361: l_created_from_ctrprop_tmpl_id := null;
1362: else
1363: l_created_from_ctrprop_tmpl_id := p_ctr_properties_rec.created_from_ctr_prop_tmpl_id;
1364: end if;
1365: if p_ctr_properties_rec.attribute1 = FND_API.G_MISS_CHAR then
1366: l_attribute1 := null;
1367: else
1368: l_attribute1 := p_ctr_properties_rec.attribute1;
1369: end if;
1366: l_attribute1 := null;
1367: else
1368: l_attribute1 := p_ctr_properties_rec.attribute1;
1369: end if;
1370: if p_ctr_properties_rec.attribute2 = FND_API.G_MISS_CHAR then
1371: l_attribute2 := null;
1372: else
1373: l_attribute2 := p_ctr_properties_rec.attribute2;
1374: end if;
1371: l_attribute2 := null;
1372: else
1373: l_attribute2 := p_ctr_properties_rec.attribute2;
1374: end if;
1375: if p_ctr_properties_rec.attribute3 = FND_API.G_MISS_CHAR then
1376: l_attribute3 := null;
1377: else
1378: l_attribute3 := p_ctr_properties_rec.attribute3;
1379: end if;
1376: l_attribute3 := null;
1377: else
1378: l_attribute3 := p_ctr_properties_rec.attribute3;
1379: end if;
1380: if p_ctr_properties_rec.attribute4 = FND_API.G_MISS_CHAR then
1381: l_attribute4 := null;
1382: else
1383: l_attribute4 := p_ctr_properties_rec.attribute4;
1384: end if;
1381: l_attribute4 := null;
1382: else
1383: l_attribute4 := p_ctr_properties_rec.attribute4;
1384: end if;
1385: if p_ctr_properties_rec.attribute5 = FND_API.G_MISS_CHAR then
1386: l_attribute5 := null;
1387: else
1388: l_attribute5 := p_ctr_properties_rec.attribute5;
1389: end if;
1386: l_attribute5 := null;
1387: else
1388: l_attribute5 := p_ctr_properties_rec.attribute5;
1389: end if;
1390: if p_ctr_properties_rec.attribute6 = FND_API.G_MISS_CHAR then
1391: l_attribute6 := null;
1392: else
1393: l_attribute6 := p_ctr_properties_rec.attribute6;
1394: end if;
1391: l_attribute6 := null;
1392: else
1393: l_attribute6 := p_ctr_properties_rec.attribute6;
1394: end if;
1395: if p_ctr_properties_rec.attribute7 = FND_API.G_MISS_CHAR then
1396: l_attribute7 := null;
1397: else
1398: l_attribute7 := p_ctr_properties_rec.attribute7;
1399: end if;
1396: l_attribute7 := null;
1397: else
1398: l_attribute7 := p_ctr_properties_rec.attribute7;
1399: end if;
1400: if p_ctr_properties_rec.attribute8 = FND_API.G_MISS_CHAR then
1401: l_attribute8 := null;
1402: else
1403: l_attribute8 := p_ctr_properties_rec.attribute8;
1404: end if;
1401: l_attribute8 := null;
1402: else
1403: l_attribute8 := p_ctr_properties_rec.attribute8;
1404: end if;
1405: if p_ctr_properties_rec.attribute9 = FND_API.G_MISS_CHAR then
1406: l_attribute9 := null;
1407: else
1408: l_attribute9 := p_ctr_properties_rec.attribute9;
1409: end if;
1406: l_attribute9 := null;
1407: else
1408: l_attribute9 := p_ctr_properties_rec.attribute9;
1409: end if;
1410: if p_ctr_properties_rec.attribute10 = FND_API.G_MISS_CHAR then
1411: l_attribute10 := null;
1412: else
1413: l_attribute10 := p_ctr_properties_rec.attribute10;
1414: end if;
1411: l_attribute10 := null;
1412: else
1413: l_attribute10 := p_ctr_properties_rec.attribute10;
1414: end if;
1415: if p_ctr_properties_rec.attribute11 = FND_API.G_MISS_CHAR then
1416: l_attribute11 := null;
1417: else
1418: l_attribute11 := p_ctr_properties_rec.attribute11;
1419: end if;
1416: l_attribute11 := null;
1417: else
1418: l_attribute11 := p_ctr_properties_rec.attribute11;
1419: end if;
1420: if p_ctr_properties_rec.attribute12 = FND_API.G_MISS_CHAR then
1421: l_attribute12 := null;
1422: else
1423: l_attribute12 := p_ctr_properties_rec.attribute12;
1424: end if;
1421: l_attribute12 := null;
1422: else
1423: l_attribute12 := p_ctr_properties_rec.attribute12;
1424: end if;
1425: if p_ctr_properties_rec.attribute13 = FND_API.G_MISS_CHAR then
1426: l_attribute13 := null;
1427: else
1428: l_attribute13 := p_ctr_properties_rec.attribute13;
1429: end if;
1426: l_attribute13 := null;
1427: else
1428: l_attribute13 := p_ctr_properties_rec.attribute13;
1429: end if;
1430: if p_ctr_properties_rec.attribute14 = FND_API.G_MISS_CHAR then
1431: l_attribute14 := null;
1432: else
1433: l_attribute14 := p_ctr_properties_rec.attribute14;
1434: end if;
1431: l_attribute14 := null;
1432: else
1433: l_attribute14 := p_ctr_properties_rec.attribute14;
1434: end if;
1435: if p_ctr_properties_rec.attribute15 = FND_API.G_MISS_CHAR then
1436: l_attribute15 := null;
1437: else
1438: l_attribute15 := p_ctr_properties_rec.attribute15;
1439: end if;
1436: l_attribute15 := null;
1437: else
1438: l_attribute15 := p_ctr_properties_rec.attribute15;
1439: end if;
1440: if p_ctr_properties_rec.attribute_category = FND_API.G_MISS_CHAR then
1441: l_attribute_category := null;
1442: else
1443: l_attribute_category := p_ctr_properties_rec.attribute_category;
1444: end if;
1533: ,p_NAME => l_name
1534: ,p_DESCRIPTION => l_description
1535: ,p_create_from_ctr_prop_tmpl_id => l_created_from_ctrprop_tmpl_id
1536: );
1537: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1538: ROLLBACK TO create_ctr_property_pvt;
1539: RETURN;
1540: END IF;
1541:
1541:
1542: -- End of API body
1543:
1544: -- Standard check of p_commit.
1545: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1546: COMMIT WORK;
1547: END IF;
1548:
1549: EXCEPTION
1546: COMMIT WORK;
1547: END IF;
1548:
1549: EXCEPTION
1550: WHEN FND_API.G_EXC_ERROR THEN
1551: x_return_status := FND_API.G_RET_STS_ERROR ;
1552: ROLLBACK TO create_ctr_property_pvt;
1553: FND_MSG_PUB.Count_And_Get
1554: (p_count => x_msg_count,
1547: END IF;
1548:
1549: EXCEPTION
1550: WHEN FND_API.G_EXC_ERROR THEN
1551: x_return_status := FND_API.G_RET_STS_ERROR ;
1552: ROLLBACK TO create_ctr_property_pvt;
1553: FND_MSG_PUB.Count_And_Get
1554: (p_count => x_msg_count,
1555: p_data => x_msg_data
1554: (p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1560: ROLLBACK TO create_ctr_property_pvt;
1561: FND_MSG_PUB.Count_And_Get
1562: (p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1560: ROLLBACK TO create_ctr_property_pvt;
1561: FND_MSG_PUB.Count_And_Get
1562: (p_count => x_msg_count,
1563: p_data => x_msg_data
1562: (p_count => x_msg_count,
1563: p_data => x_msg_data
1564: );
1565: WHEN OTHERS THEN
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1567: ROLLBACK TO create_ctr_property_pvt;
1568: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1569: THEN
1570: FND_MSG_PUB.Add_Exc_Msg
1649: -- Standard Start of API savepoint
1650: SAVEPOINT create_ctr_associations_pvt;
1651:
1652: -- Standard call to check for call compatibility.
1653: IF NOT FND_API.Compatible_API_Call (l_api_version,
1654: p_api_version,
1655: l_api_name ,
1656: G_PKG_NAME )
1657: THEN
1654: p_api_version,
1655: l_api_name ,
1656: G_PKG_NAME )
1657: THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660:
1661: -- Initialize message list if p_init_msg_list is set to TRUE.
1662: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660:
1661: -- Initialize message list if p_init_msg_list is set to TRUE.
1662: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1663: FND_MSG_PUB.initialize;
1664: END IF;
1665:
1666: -- Initialize API return status to success
1663: FND_MSG_PUB.initialize;
1664: END IF;
1665:
1666: -- Initialize API return status to success
1667: x_return_status := FND_API.G_RET_STS_SUCCESS;
1668:
1669: -- Read the debug profiles values in to global variable 7197402
1670: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1671:
1688: END IF;
1689:
1690: -- Start of API Body
1691:
1692: if P_counter_associations_rec.source_object_code = FND_API.G_MISS_CHAR then
1693: l_source_object_code := null;
1694: else
1695: l_source_object_code := P_counter_associations_rec.source_object_code;
1696: end if;
1693: l_source_object_code := null;
1694: else
1695: l_source_object_code := P_counter_associations_rec.source_object_code;
1696: end if;
1697: if P_counter_associations_rec.source_object_id = FND_API.G_MISS_NUM then
1698: l_source_object_id := null;
1699: else
1700: l_source_object_id := P_counter_associations_rec.source_object_id;
1701: end if;
1698: l_source_object_id := null;
1699: else
1700: l_source_object_id := P_counter_associations_rec.source_object_id;
1701: end if;
1702: if P_counter_associations_rec.counter_id = FND_API.G_MISS_NUM then
1703: l_counter_id := null;
1704: else
1705: l_counter_id := P_counter_associations_rec.counter_id;
1706: end if;
1703: l_counter_id := null;
1704: else
1705: l_counter_id := P_counter_associations_rec.counter_id;
1706: end if;
1707: if P_counter_associations_rec.start_date_active = FND_API.G_MISS_DATE then
1708: l_start_date_active := sysdate;
1709: else
1710: l_start_date_active := P_counter_associations_rec.start_date_active;
1711: end if;
1708: l_start_date_active := sysdate;
1709: else
1710: l_start_date_active := P_counter_associations_rec.start_date_active;
1711: end if;
1712: if P_counter_associations_rec.end_date_active = FND_API.G_MISS_DATE then
1713: l_end_date_active := null;
1714: else
1715: l_end_date_active := P_counter_associations_rec.end_date_active;
1716: end if;
1713: l_end_date_active := null;
1714: else
1715: l_end_date_active := P_counter_associations_rec.end_date_active;
1716: end if;
1717: if p_counter_associations_rec.attribute1 = FND_API.G_MISS_CHAR then
1718: l_attribute1 := null;
1719: else
1720: l_attribute1 := p_counter_associations_rec.attribute1;
1721: end if;
1718: l_attribute1 := null;
1719: else
1720: l_attribute1 := p_counter_associations_rec.attribute1;
1721: end if;
1722: if p_counter_associations_rec.attribute2 = FND_API.G_MISS_CHAR then
1723: l_attribute2 := null;
1724: else
1725: l_attribute2 := p_counter_associations_rec.attribute2;
1726: end if;
1723: l_attribute2 := null;
1724: else
1725: l_attribute2 := p_counter_associations_rec.attribute2;
1726: end if;
1727: if p_counter_associations_rec.attribute3 = FND_API.G_MISS_CHAR then
1728: l_attribute3 := null;
1729: else
1730: l_attribute3 := p_counter_associations_rec.attribute3;
1731: end if;
1728: l_attribute3 := null;
1729: else
1730: l_attribute3 := p_counter_associations_rec.attribute3;
1731: end if;
1732: if p_counter_associations_rec.attribute4 = FND_API.G_MISS_CHAR then
1733: l_attribute4 := null;
1734: else
1735: l_attribute4 := p_counter_associations_rec.attribute4;
1736: end if;
1733: l_attribute4 := null;
1734: else
1735: l_attribute4 := p_counter_associations_rec.attribute4;
1736: end if;
1737: if p_counter_associations_rec.attribute5 = FND_API.G_MISS_CHAR then
1738: l_attribute5 := null;
1739: else
1740: l_attribute5 := p_counter_associations_rec.attribute5;
1741: end if;
1738: l_attribute5 := null;
1739: else
1740: l_attribute5 := p_counter_associations_rec.attribute5;
1741: end if;
1742: if p_counter_associations_rec.attribute6 = FND_API.G_MISS_CHAR then
1743: l_attribute6 := null;
1744: else
1745: l_attribute6 := p_counter_associations_rec.attribute6;
1746: end if;
1743: l_attribute6 := null;
1744: else
1745: l_attribute6 := p_counter_associations_rec.attribute6;
1746: end if;
1747: if p_counter_associations_rec.attribute7 = FND_API.G_MISS_CHAR then
1748: l_attribute7 := null;
1749: else
1750: l_attribute7 := p_counter_associations_rec.attribute7;
1751: end if;
1748: l_attribute7 := null;
1749: else
1750: l_attribute7 := p_counter_associations_rec.attribute7;
1751: end if;
1752: if p_counter_associations_rec.attribute8 = FND_API.G_MISS_CHAR then
1753: l_attribute8 := null;
1754: else
1755: l_attribute8 := p_counter_associations_rec.attribute8;
1756: end if;
1753: l_attribute8 := null;
1754: else
1755: l_attribute8 := p_counter_associations_rec.attribute8;
1756: end if;
1757: if p_counter_associations_rec.attribute9 = FND_API.G_MISS_CHAR then
1758: l_attribute9 := null;
1759: else
1760: l_attribute9 := p_counter_associations_rec.attribute9;
1761: end if;
1758: l_attribute9 := null;
1759: else
1760: l_attribute9 := p_counter_associations_rec.attribute9;
1761: end if;
1762: if p_counter_associations_rec.attribute10 = FND_API.G_MISS_CHAR then
1763: l_attribute10 := null;
1764: else
1765: l_attribute10 := p_counter_associations_rec.attribute10;
1766: end if;
1763: l_attribute10 := null;
1764: else
1765: l_attribute10 := p_counter_associations_rec.attribute10;
1766: end if;
1767: if p_counter_associations_rec.attribute11 = FND_API.G_MISS_CHAR then
1768: l_attribute11 := null;
1769: else
1770: l_attribute11 := p_counter_associations_rec.attribute11;
1771: end if;
1768: l_attribute11 := null;
1769: else
1770: l_attribute11 := p_counter_associations_rec.attribute11;
1771: end if;
1772: if p_counter_associations_rec.attribute12 = FND_API.G_MISS_CHAR then
1773: l_attribute12 := null;
1774: else
1775: l_attribute12 := p_counter_associations_rec.attribute12;
1776: end if;
1773: l_attribute12 := null;
1774: else
1775: l_attribute12 := p_counter_associations_rec.attribute12;
1776: end if;
1777: if p_counter_associations_rec.attribute13 = FND_API.G_MISS_CHAR then
1778: l_attribute13 := null;
1779: else
1780: l_attribute13 := p_counter_associations_rec.attribute13;
1781: end if;
1778: l_attribute13 := null;
1779: else
1780: l_attribute13 := p_counter_associations_rec.attribute13;
1781: end if;
1782: if p_counter_associations_rec.attribute14 = FND_API.G_MISS_CHAR then
1783: l_attribute14 := null;
1784: else
1785: l_attribute14 := p_counter_associations_rec.attribute14;
1786: end if;
1783: l_attribute14 := null;
1784: else
1785: l_attribute14 := p_counter_associations_rec.attribute14;
1786: end if;
1787: if p_counter_associations_rec.attribute15 = FND_API.G_MISS_CHAR then
1788: l_attribute15 := null;
1789: else
1790: l_attribute15 := p_counter_associations_rec.attribute15;
1791: end if;
1788: l_attribute15 := null;
1789: else
1790: l_attribute15 := p_counter_associations_rec.attribute15;
1791: end if;
1792: if p_counter_associations_rec.attribute_category = FND_API.G_MISS_CHAR then
1793: l_attribute_category := null;
1794: else
1795: l_attribute_category := p_counter_associations_rec.attribute_category;
1796: end if;
1794: else
1795: l_attribute_category := p_counter_associations_rec.attribute_category;
1796: end if;
1797:
1798: if p_counter_associations_rec.maint_organization_id = FND_API.G_MISS_NUM then
1799: l_maint_organization_id := null;
1800: else
1801: l_maint_organization_id := p_counter_associations_rec.maint_organization_id;
1802: end if;
1800: else
1801: l_maint_organization_id := p_counter_associations_rec.maint_organization_id;
1802: end if;
1803:
1804: if p_counter_associations_rec.primary_failure_flag = FND_API.G_MISS_CHAR then
1805: l_primary_failure_flag := null;
1806: else
1807: l_primary_failure_flag := p_counter_associations_rec.primary_failure_flag;
1808: end if;
1924: ,p_SECURITY_GROUP_ID => null
1925: ,p_MAINT_ORGANIZATION_ID => l_maint_organization_id
1926: ,p_PRIMARY_FAILURE_FLAG => l_primary_failure_flag
1927: );
1928: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1929: ROLLBACK TO create_ctr_associations_pvt;
1930: RETURN;
1931: END IF;
1932:
1932:
1933: -- End of API body
1934:
1935: -- Standard check of p_commit.
1936: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1937: COMMIT WORK;
1938: END IF;
1939:
1940: EXCEPTION
1937: COMMIT WORK;
1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR ;
1943: ROLLBACK TO create_ctr_associations_pvt;
1944: FND_MSG_PUB.Count_And_Get
1945: (p_count => x_msg_count,
1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR ;
1943: ROLLBACK TO create_ctr_associations_pvt;
1944: FND_MSG_PUB.Count_And_Get
1945: (p_count => x_msg_count,
1946: p_data => x_msg_data
1945: (p_count => x_msg_count,
1946: p_data => x_msg_data
1947: );
1948:
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: ROLLBACK TO create_ctr_associations_pvt;
1952: FND_MSG_PUB.Count_And_Get
1953: (p_count => x_msg_count,
1946: p_data => x_msg_data
1947: );
1948:
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: ROLLBACK TO create_ctr_associations_pvt;
1952: FND_MSG_PUB.Count_And_Get
1953: (p_count => x_msg_count,
1954: p_data => x_msg_data
1953: (p_count => x_msg_count,
1954: p_data => x_msg_data
1955: );
1956: WHEN OTHERS THEN
1957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1958: ROLLBACK TO create_ctr_associations_pvt;
1959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1960: THEN
1961: FND_MSG_PUB.Add_Exc_Msg
2028: -- Standard Start of API savepoint
2029: SAVEPOINT create_reading_lock_pvt;
2030:
2031: -- Standard call to check for call compatibility.
2032: IF NOT FND_API.Compatible_API_Call (l_api_version,
2033: p_api_version,
2034: l_api_name ,
2035: G_PKG_NAME )
2036: THEN
2033: p_api_version,
2034: l_api_name ,
2035: G_PKG_NAME )
2036: THEN
2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2038: END IF;
2039:
2040: -- Initialize message list if p_init_msg_list is set to TRUE.
2041: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2038: END IF;
2039:
2040: -- Initialize message list if p_init_msg_list is set to TRUE.
2041: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2042: FND_MSG_PUB.initialize;
2043: END IF;
2044:
2045: -- Initialize API return status to success
2042: FND_MSG_PUB.initialize;
2043: END IF;
2044:
2045: -- Initialize API return status to success
2046: x_return_status := FND_API.G_RET_STS_SUCCESS;
2047:
2048: -- Read the debug profiles values in to global variable 7197402
2049: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2050:
2067: END IF;
2068:
2069: -- Start of API Body
2070:
2071: if p_ctr_reading_lock_rec.counter_id = FND_API.G_MISS_NUM then
2072: l_counter_id := null;
2073: else
2074: l_counter_id := p_ctr_reading_lock_rec.counter_id;
2075: end if;
2072: l_counter_id := null;
2073: else
2074: l_counter_id := p_ctr_reading_lock_rec.counter_id;
2075: end if;
2076: if p_ctr_reading_lock_rec.reading_lock_date = FND_API.G_MISS_DATE then
2077: l_reading_lock_date := null;
2078: else
2079: l_reading_lock_date := p_ctr_reading_lock_rec.reading_lock_date;
2080: end if;
2078: else
2079: l_reading_lock_date := p_ctr_reading_lock_rec.reading_lock_date;
2080: end if;
2081: /*
2082: if p_ctr_reading_lock_rec.active_start_date = FND_API.G_MISS_DATE then
2083: l_active_start_date := null;
2084: else
2085: l_active_start_date := p_ctr_reading_lock_rec.active_start_date;
2086: end if;
2083: l_active_start_date := null;
2084: else
2085: l_active_start_date := p_ctr_reading_lock_rec.active_start_date;
2086: end if;
2087: if p_ctr_reading_lock_rec.active_end_date = FND_API.G_MISS_DATE then
2088: l_active_end_date := null;
2089: else
2090: l_active_end_date := p_ctr_reading_lock_rec.active_end_date;
2091: end if;
2089: else
2090: l_active_end_date := p_ctr_reading_lock_rec.active_end_date;
2091: end if;
2092: */
2093: if p_ctr_reading_lock_rec.source_group_ref_id = FND_API.G_MISS_NUM then
2094: l_source_group_ref_id := null;
2095: else
2096: l_source_group_ref_id := p_ctr_reading_lock_rec.source_group_ref_id;
2097: end if;
2094: l_source_group_ref_id := null;
2095: else
2096: l_source_group_ref_id := p_ctr_reading_lock_rec.source_group_ref_id;
2097: end if;
2098: if p_ctr_reading_lock_rec.source_group_ref = FND_API.G_MISS_CHAR then
2099: l_source_group_ref := null;
2100: else
2101: l_source_group_ref := p_ctr_reading_lock_rec.source_group_ref;
2102: end if;
2099: l_source_group_ref := null;
2100: else
2101: l_source_group_ref := p_ctr_reading_lock_rec.source_group_ref;
2102: end if;
2103: if p_ctr_reading_lock_rec.source_header_ref_id = FND_API.G_MISS_NUM then
2104: l_source_header_ref_id := null;
2105: else
2106: l_source_header_ref_id := p_ctr_reading_lock_rec.source_header_ref_id;
2107: end if;
2104: l_source_header_ref_id := null;
2105: else
2106: l_source_header_ref_id := p_ctr_reading_lock_rec.source_header_ref_id;
2107: end if;
2108: if p_ctr_reading_lock_rec.source_header_ref = FND_API.G_MISS_CHAR then
2109: l_source_header_ref := null;
2110: else
2111: l_source_header_ref := p_ctr_reading_lock_rec.source_header_ref;
2112: end if;
2109: l_source_header_ref := null;
2110: else
2111: l_source_header_ref := p_ctr_reading_lock_rec.source_header_ref;
2112: end if;
2113: if p_ctr_reading_lock_rec.source_line_ref_id = FND_API.G_MISS_NUM then
2114: l_source_line_ref_id := null;
2115: else
2116: l_source_line_ref_id := p_ctr_reading_lock_rec.source_line_ref_id;
2117: end if;
2114: l_source_line_ref_id := null;
2115: else
2116: l_source_line_ref_id := p_ctr_reading_lock_rec.source_line_ref_id;
2117: end if;
2118: if p_ctr_reading_lock_rec.source_line_ref = FND_API.G_MISS_CHAR then
2119: l_source_line_ref := null;
2120: else
2121: l_source_line_ref := p_ctr_reading_lock_rec.source_line_ref;
2122: end if;
2119: l_source_line_ref := null;
2120: else
2121: l_source_line_ref := p_ctr_reading_lock_rec.source_line_ref;
2122: end if;
2123: if p_ctr_reading_lock_rec.source_dist_ref_id1 = FND_API.G_MISS_NUM then
2124: l_source_dist_ref_id1 := null;
2125: else
2126: l_source_dist_ref_id1 := p_ctr_reading_lock_rec.source_dist_ref_id1;
2127: end if;
2124: l_source_dist_ref_id1 := null;
2125: else
2126: l_source_dist_ref_id1 := p_ctr_reading_lock_rec.source_dist_ref_id1;
2127: end if;
2128: if p_ctr_reading_lock_rec.source_dist_ref_id2 = FND_API.G_MISS_NUM then
2129: l_source_dist_ref_id2 := null;
2130: else
2131: l_source_dist_ref_id2 := p_ctr_reading_lock_rec.source_dist_ref_id2;
2132: end if;
2184: ,p_SOURCE_LINE_REF => l_source_line_ref
2185: ,p_SOURCE_DIST_REF_ID1 => l_source_dist_ref_id1
2186: ,p_SOURCE_DIST_REF_ID2 => l_source_dist_ref_id2
2187: );
2188: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2189: ROLLBACK TO create_reading_lock_pvt;
2190: RETURN;
2191: END IF;
2192:
2192:
2193: -- End of API body
2194:
2195: -- Standard check of p_commit.
2196: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2197: COMMIT WORK;
2198: END IF;
2199:
2200: EXCEPTION
2197: COMMIT WORK;
2198: END IF;
2199:
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR ;
2203: ROLLBACK TO create_reading_lock_pvt;
2204: FND_MSG_PUB.Count_And_Get
2205: (p_count => x_msg_count,
2198: END IF;
2199:
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR ;
2203: ROLLBACK TO create_reading_lock_pvt;
2204: FND_MSG_PUB.Count_And_Get
2205: (p_count => x_msg_count,
2206: p_data => x_msg_data
2205: (p_count => x_msg_count,
2206: p_data => x_msg_data
2207: );
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: ROLLBACK TO create_reading_lock_pvt;
2212: FND_MSG_PUB.Count_And_Get
2213: (p_count => x_msg_count,
2206: p_data => x_msg_data
2207: );
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: ROLLBACK TO create_reading_lock_pvt;
2212: FND_MSG_PUB.Count_And_Get
2213: (p_count => x_msg_count,
2214: p_data => x_msg_data
2213: (p_count => x_msg_count,
2214: p_data => x_msg_data
2215: );
2216: WHEN OTHERS THEN
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2218: ROLLBACK TO create_reading_lock_pvt;
2219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2220: THEN
2221: FND_MSG_PUB.Add_Exc_Msg
2273: -- Standard Start of API savepoint
2274: SAVEPOINT create_daily_usage_pvt;
2275:
2276: -- Standard call to check for call compatibility.
2277: IF NOT FND_API.Compatible_API_Call (l_api_version,
2278: p_api_version,
2279: l_api_name ,
2280: G_PKG_NAME )
2281: THEN
2278: p_api_version,
2279: l_api_name ,
2280: G_PKG_NAME )
2281: THEN
2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2283: END IF;
2284:
2285: -- Initialize message list if p_init_msg_list is set to TRUE.
2286: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2283: END IF;
2284:
2285: -- Initialize message list if p_init_msg_list is set to TRUE.
2286: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:
2290: -- Initialize API return status to success
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:
2290: -- Initialize API return status to success
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;
2292:
2293: -- Read the debug profiles values in to global variable 7197402
2294: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2295:
2312: END IF;
2313:
2314: -- Start of API Body
2315:
2316: if p_ctr_usage_forecast_rec.counter_id = FND_API.G_MISS_NUM then
2317: l_counter_id := null;
2318: else
2319: l_counter_id := p_ctr_usage_forecast_rec.counter_id;
2320: end if;
2317: l_counter_id := null;
2318: else
2319: l_counter_id := p_ctr_usage_forecast_rec.counter_id;
2320: end if;
2321: if p_ctr_usage_forecast_rec.usage_rate = FND_API.G_MISS_NUM then
2322: l_usage_rate := null;
2323: else
2324: l_usage_rate := p_ctr_usage_forecast_rec.usage_rate;
2325: end if;
2322: l_usage_rate := null;
2323: else
2324: l_usage_rate := p_ctr_usage_forecast_rec.usage_rate;
2325: end if;
2326: if p_ctr_usage_forecast_rec.use_past_reading = FND_API.G_MISS_NUM then
2327: l_use_past_reading := null;
2328: else
2329: l_use_past_reading := p_ctr_usage_forecast_rec.use_past_reading;
2330: end if;
2327: l_use_past_reading := null;
2328: else
2329: l_use_past_reading := p_ctr_usage_forecast_rec.use_past_reading;
2330: end if;
2331: if p_ctr_usage_forecast_rec.active_start_date = FND_API.G_MISS_DATE then
2332: l_active_start_date := null;
2333: else
2334: l_active_start_date := p_ctr_usage_forecast_rec.active_start_date;
2335: end if;
2357: END IF;
2358: END;
2359: END IF;
2360:
2361: if p_ctr_usage_forecast_rec.active_end_date = FND_API.G_MISS_DATE then
2362: l_active_end_date := null;
2363: else
2364: l_active_end_date := p_ctr_usage_forecast_rec.active_end_date;
2365: end if;
2408: ,p_creation_date => sysdate
2409: ,p_created_by => FND_GLOBAL.USER_ID
2410: ,p_last_update_login => FND_GLOBAL.USER_ID
2411: );
2412: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2413: ROLLBACK TO create_daily_usage_pvt;
2414: RETURN;
2415: END IF;
2416:
2416:
2417: -- End of API body
2418:
2419: -- Standard check of p_commit.
2420: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2421: COMMIT WORK;
2422: END IF;
2423:
2424: EXCEPTION
2421: COMMIT WORK;
2422: END IF;
2423:
2424: EXCEPTION
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: x_return_status := FND_API.G_RET_STS_ERROR ;
2427: ROLLBACK TO create_daily_usage_pvt;
2428: FND_MSG_PUB.Count_And_Get
2429: (p_count => x_msg_count,
2422: END IF;
2423:
2424: EXCEPTION
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: x_return_status := FND_API.G_RET_STS_ERROR ;
2427: ROLLBACK TO create_daily_usage_pvt;
2428: FND_MSG_PUB.Count_And_Get
2429: (p_count => x_msg_count,
2430: p_data => x_msg_data
2429: (p_count => x_msg_count,
2430: p_data => x_msg_data
2431: );
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2435: ROLLBACK TO create_daily_usage_pvt;
2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count,
2430: p_data => x_msg_data
2431: );
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2435: ROLLBACK TO create_daily_usage_pvt;
2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count,
2438: p_data => x_msg_data
2437: (p_count => x_msg_count,
2438: p_data => x_msg_data
2439: );
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2442: ROLLBACK TO create_daily_usage_pvt;
2443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2444: THEN
2445: FND_MSG_PUB.Add_Exc_Msg
2514: -- Standard Start of API savepoint
2515: SAVEPOINT update_counter_pvt;
2516:
2517: -- Standard call to check for call compatibility.
2518: IF NOT FND_API.Compatible_API_Call (l_api_version,
2519: p_api_version,
2520: l_api_name ,
2521: G_PKG_NAME )
2522: THEN
2519: p_api_version,
2520: l_api_name ,
2521: G_PKG_NAME )
2522: THEN
2523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2524: END IF;
2525:
2526: -- Initialize message list if p_init_msg_list is set to TRUE.
2527: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2524: END IF;
2525:
2526: -- Initialize message list if p_init_msg_list is set to TRUE.
2527: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Initialize API return status to success
2528: FND_MSG_PUB.initialize;
2529: END IF;
2530:
2531: -- Initialize API return status to success
2532: x_return_status := FND_API.G_RET_STS_SUCCESS;
2533:
2534: -- Read the debug profiles values in to global variable 7197402
2535: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2536:
2700: END IF;
2701:
2702: l_counter_instance_rec := p_counter_instance_rec;
2703:
2704: IF p_counter_instance_rec.group_id = FND_API.G_MISS_NUM THEN
2705: l_counter_instance_rec.group_id := NULL;
2706: ELSIF p_counter_instance_rec.group_id IS NULL THEN
2707: l_counter_instance_rec.group_id := l_old_counter_instance_rec.group_id;
2708: END IF;
2705: l_counter_instance_rec.group_id := NULL;
2706: ELSIF p_counter_instance_rec.group_id IS NULL THEN
2707: l_counter_instance_rec.group_id := l_old_counter_instance_rec.group_id;
2708: END IF;
2709: IF p_counter_instance_rec.counter_type = FND_API.G_MISS_CHAR THEN
2710: l_counter_instance_rec.counter_type := NULL;
2711: ELSIF p_counter_instance_rec.counter_type IS NULL THEN
2712: l_counter_instance_rec.counter_type := l_old_counter_instance_rec.counter_type;
2713: END IF;
2710: l_counter_instance_rec.counter_type := NULL;
2711: ELSIF p_counter_instance_rec.counter_type IS NULL THEN
2712: l_counter_instance_rec.counter_type := l_old_counter_instance_rec.counter_type;
2713: END IF;
2714: IF p_counter_instance_rec.initial_reading = FND_API.G_MISS_NUM THEN
2715: l_counter_instance_rec.initial_reading := NULL;
2716: ELSIF p_counter_instance_rec.initial_reading IS NULL THEN
2717: l_counter_instance_rec.initial_reading := l_old_counter_instance_rec.initial_reading;
2718: END IF;
2715: l_counter_instance_rec.initial_reading := NULL;
2716: ELSIF p_counter_instance_rec.initial_reading IS NULL THEN
2717: l_counter_instance_rec.initial_reading := l_old_counter_instance_rec.initial_reading;
2718: END IF;
2719: IF p_counter_instance_rec.initial_reading_date = FND_API.G_MISS_DATE THEN
2720: l_counter_instance_rec.initial_reading_date := NULL;
2721: ELSIF p_counter_instance_rec.initial_reading_date IS NULL THEN
2722: l_counter_instance_rec.initial_reading_date := l_old_counter_instance_rec.initial_reading_date;
2723: END IF;
2720: l_counter_instance_rec.initial_reading_date := NULL;
2721: ELSIF p_counter_instance_rec.initial_reading_date IS NULL THEN
2722: l_counter_instance_rec.initial_reading_date := l_old_counter_instance_rec.initial_reading_date;
2723: END IF;
2724: IF p_counter_instance_rec.created_from_counter_tmpl_id = FND_API.G_MISS_NUM THEN
2725: l_counter_instance_rec.created_from_counter_tmpl_id := NULL;
2726: ELSIF p_counter_instance_rec.created_from_counter_tmpl_id IS NULL THEN
2727: l_counter_instance_rec.created_from_counter_tmpl_id := l_old_counter_instance_rec.created_from_counter_tmpl_id;
2728: END IF;
2725: l_counter_instance_rec.created_from_counter_tmpl_id := NULL;
2726: ELSIF p_counter_instance_rec.created_from_counter_tmpl_id IS NULL THEN
2727: l_counter_instance_rec.created_from_counter_tmpl_id := l_old_counter_instance_rec.created_from_counter_tmpl_id;
2728: END IF;
2729: IF p_counter_instance_rec.tolerance_plus = FND_API.G_MISS_NUM THEN
2730: l_counter_instance_rec.tolerance_plus := NULL;
2731: ELSIF p_counter_instance_rec.tolerance_plus IS NULL THEN
2732: l_counter_instance_rec.tolerance_plus := l_old_counter_instance_rec.tolerance_plus;
2733: END IF;
2730: l_counter_instance_rec.tolerance_plus := NULL;
2731: ELSIF p_counter_instance_rec.tolerance_plus IS NULL THEN
2732: l_counter_instance_rec.tolerance_plus := l_old_counter_instance_rec.tolerance_plus;
2733: END IF;
2734: IF p_counter_instance_rec.tolerance_minus = FND_API.G_MISS_NUM THEN
2735: l_counter_instance_rec.tolerance_minus := NULL;
2736: ELSIF p_counter_instance_rec.tolerance_minus IS NULL THEN
2737: l_counter_instance_rec.tolerance_minus := l_old_counter_instance_rec.tolerance_minus;
2738: END IF;
2735: l_counter_instance_rec.tolerance_minus := NULL;
2736: ELSIF p_counter_instance_rec.tolerance_minus IS NULL THEN
2737: l_counter_instance_rec.tolerance_minus := l_old_counter_instance_rec.tolerance_minus;
2738: END IF;
2739: IF p_counter_instance_rec.uom_code = FND_API.G_MISS_CHAR THEN
2740: l_counter_instance_rec.uom_code := NULL;
2741: ELSIF p_counter_instance_rec.uom_code IS NULL THEN
2742: l_counter_instance_rec.uom_code := l_old_counter_instance_rec.uom_code;
2743: END IF;
2740: l_counter_instance_rec.uom_code := NULL;
2741: ELSIF p_counter_instance_rec.uom_code IS NULL THEN
2742: l_counter_instance_rec.uom_code := l_old_counter_instance_rec.uom_code;
2743: END IF;
2744: IF p_counter_instance_rec.derive_counter_id = FND_API.G_MISS_NUM THEN
2745: l_counter_instance_rec.derive_counter_id := NULL;
2746: ELSIF p_counter_instance_rec.derive_counter_id IS NULL THEN
2747: l_counter_instance_rec.derive_counter_id := l_old_counter_instance_rec.derive_counter_id;
2748: END IF;
2745: l_counter_instance_rec.derive_counter_id := NULL;
2746: ELSIF p_counter_instance_rec.derive_counter_id IS NULL THEN
2747: l_counter_instance_rec.derive_counter_id := l_old_counter_instance_rec.derive_counter_id;
2748: END IF;
2749: IF p_counter_instance_rec.derive_function = FND_API.G_MISS_CHAR THEN
2750: l_counter_instance_rec.derive_function := NULL;
2751: ELSIF p_counter_instance_rec.derive_function IS NULL THEN
2752: l_counter_instance_rec.derive_function := l_old_counter_instance_rec.derive_function;
2753: END IF;
2750: l_counter_instance_rec.derive_function := NULL;
2751: ELSIF p_counter_instance_rec.derive_function IS NULL THEN
2752: l_counter_instance_rec.derive_function := l_old_counter_instance_rec.derive_function;
2753: END IF;
2754: IF p_counter_instance_rec.valid_flag = FND_API.G_MISS_CHAR THEN
2755: l_counter_instance_rec.valid_flag := NULL;
2756: ELSIF p_counter_instance_rec.valid_flag IS NULL THEN
2757: l_counter_instance_rec.valid_flag := l_old_counter_instance_rec.valid_flag;
2758: END IF;
2755: l_counter_instance_rec.valid_flag := NULL;
2756: ELSIF p_counter_instance_rec.valid_flag IS NULL THEN
2757: l_counter_instance_rec.valid_flag := l_old_counter_instance_rec.valid_flag;
2758: END IF;
2759: IF p_counter_instance_rec.formula_incomplete_flag = FND_API.G_MISS_CHAR THEN
2760: l_counter_instance_rec.formula_incomplete_flag := NULL;
2761: ELSIF p_counter_instance_rec.formula_incomplete_flag IS NULL THEN
2762: l_counter_instance_rec.formula_incomplete_flag := l_old_counter_instance_rec.formula_incomplete_flag;
2763: END IF;
2760: l_counter_instance_rec.formula_incomplete_flag := NULL;
2761: ELSIF p_counter_instance_rec.formula_incomplete_flag IS NULL THEN
2762: l_counter_instance_rec.formula_incomplete_flag := l_old_counter_instance_rec.formula_incomplete_flag;
2763: END IF;
2764: IF p_counter_instance_rec.formula_text = FND_API.G_MISS_CHAR THEN
2765: l_counter_instance_rec.formula_text := NULL;
2766: ELSIF p_counter_instance_rec.formula_text IS NULL THEN
2767: l_counter_instance_rec.formula_text := l_old_counter_instance_rec.formula_text;
2768: END IF;
2765: l_counter_instance_rec.formula_text := NULL;
2766: ELSIF p_counter_instance_rec.formula_text IS NULL THEN
2767: l_counter_instance_rec.formula_text := l_old_counter_instance_rec.formula_text;
2768: END IF;
2769: IF p_counter_instance_rec.rollover_last_reading = FND_API.G_MISS_NUM THEN
2770: l_counter_instance_rec.rollover_last_reading := NULL;
2771: ELSIF p_counter_instance_rec.rollover_last_reading IS NULL THEN
2772: l_counter_instance_rec.rollover_last_reading := l_old_counter_instance_rec.rollover_last_reading;
2773: END IF;
2770: l_counter_instance_rec.rollover_last_reading := NULL;
2771: ELSIF p_counter_instance_rec.rollover_last_reading IS NULL THEN
2772: l_counter_instance_rec.rollover_last_reading := l_old_counter_instance_rec.rollover_last_reading;
2773: END IF;
2774: IF p_counter_instance_rec.rollover_first_reading = FND_API.G_MISS_NUM THEN
2775: l_counter_instance_rec.rollover_first_reading := NULL;
2776: ELSIF p_counter_instance_rec.rollover_first_reading IS NULL THEN
2777: l_counter_instance_rec.rollover_first_reading := l_old_counter_instance_rec.rollover_first_reading;
2778: END IF;
2775: l_counter_instance_rec.rollover_first_reading := NULL;
2776: ELSIF p_counter_instance_rec.rollover_first_reading IS NULL THEN
2777: l_counter_instance_rec.rollover_first_reading := l_old_counter_instance_rec.rollover_first_reading;
2778: END IF;
2779: IF p_counter_instance_rec.usage_item_id = FND_API.G_MISS_NUM THEN
2780: l_counter_instance_rec.usage_item_id := NULL;
2781: ELSIF p_counter_instance_rec.usage_item_id IS NULL THEN
2782: l_counter_instance_rec.usage_item_id := l_old_counter_instance_rec.usage_item_id;
2783: END IF;
2780: l_counter_instance_rec.usage_item_id := NULL;
2781: ELSIF p_counter_instance_rec.usage_item_id IS NULL THEN
2782: l_counter_instance_rec.usage_item_id := l_old_counter_instance_rec.usage_item_id;
2783: END IF;
2784: IF p_counter_instance_rec.ctr_val_max_seq_no = FND_API.G_MISS_NUM THEN
2785: l_counter_instance_rec.ctr_val_max_seq_no := NULL;
2786: ELSIF p_counter_instance_rec.ctr_val_max_seq_no IS NULL THEN
2787: l_counter_instance_rec.ctr_val_max_seq_no := l_old_counter_instance_rec.ctr_val_max_seq_no;
2788: END IF;
2785: l_counter_instance_rec.ctr_val_max_seq_no := NULL;
2786: ELSIF p_counter_instance_rec.ctr_val_max_seq_no IS NULL THEN
2787: l_counter_instance_rec.ctr_val_max_seq_no := l_old_counter_instance_rec.ctr_val_max_seq_no;
2788: END IF;
2789: IF p_counter_instance_rec.start_date_active = FND_API.G_MISS_DATE THEN
2790: l_counter_instance_rec.start_date_active := NULL;
2791: ELSIF p_counter_instance_rec.start_date_active IS NULL THEN
2792: l_counter_instance_rec.start_date_active := l_old_counter_instance_rec.start_date_active;
2793: END IF;
2790: l_counter_instance_rec.start_date_active := NULL;
2791: ELSIF p_counter_instance_rec.start_date_active IS NULL THEN
2792: l_counter_instance_rec.start_date_active := l_old_counter_instance_rec.start_date_active;
2793: END IF;
2794: IF p_counter_instance_rec.end_date_active = FND_API.G_MISS_DATE THEN
2795: l_counter_instance_rec.end_date_active := NULL;
2796: ELSIF p_counter_instance_rec.end_date_active IS NULL THEN
2797: l_counter_instance_rec.end_date_active := l_old_counter_instance_rec.end_date_active;
2798: END IF;
2795: l_counter_instance_rec.end_date_active := NULL;
2796: ELSIF p_counter_instance_rec.end_date_active IS NULL THEN
2797: l_counter_instance_rec.end_date_active := l_old_counter_instance_rec.end_date_active;
2798: END IF;
2799: IF p_counter_instance_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2800: l_counter_instance_rec.attribute1 := NULL;
2801: ELSIF p_counter_instance_rec.attribute1 IS NULL THEN
2802: l_counter_instance_rec.attribute1 := l_old_counter_instance_rec.attribute1;
2803: END IF;
2800: l_counter_instance_rec.attribute1 := NULL;
2801: ELSIF p_counter_instance_rec.attribute1 IS NULL THEN
2802: l_counter_instance_rec.attribute1 := l_old_counter_instance_rec.attribute1;
2803: END IF;
2804: IF p_counter_instance_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2805: l_counter_instance_rec.attribute2 := NULL;
2806: ELSIF p_counter_instance_rec.attribute2 IS NULL THEN
2807: l_counter_instance_rec.attribute2 := l_old_counter_instance_rec.attribute2;
2808: END IF;
2805: l_counter_instance_rec.attribute2 := NULL;
2806: ELSIF p_counter_instance_rec.attribute2 IS NULL THEN
2807: l_counter_instance_rec.attribute2 := l_old_counter_instance_rec.attribute2;
2808: END IF;
2809: IF p_counter_instance_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2810: l_counter_instance_rec.attribute3 := NULL;
2811: ELSIF p_counter_instance_rec.attribute3 IS NULL THEN
2812: l_counter_instance_rec.attribute3 := l_old_counter_instance_rec.attribute3;
2813: END IF;
2810: l_counter_instance_rec.attribute3 := NULL;
2811: ELSIF p_counter_instance_rec.attribute3 IS NULL THEN
2812: l_counter_instance_rec.attribute3 := l_old_counter_instance_rec.attribute3;
2813: END IF;
2814: IF p_counter_instance_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2815: l_counter_instance_rec.attribute4 := NULL;
2816: ELSIF p_counter_instance_rec.attribute4 IS NULL THEN
2817: l_counter_instance_rec.attribute4 := l_old_counter_instance_rec.attribute4;
2818: END IF;
2815: l_counter_instance_rec.attribute4 := NULL;
2816: ELSIF p_counter_instance_rec.attribute4 IS NULL THEN
2817: l_counter_instance_rec.attribute4 := l_old_counter_instance_rec.attribute4;
2818: END IF;
2819: IF p_counter_instance_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2820: l_counter_instance_rec.attribute5 := NULL;
2821: ELSIF p_counter_instance_rec.attribute5 IS NULL THEN
2822: l_counter_instance_rec.attribute5 := l_old_counter_instance_rec.attribute5;
2823: END IF;
2820: l_counter_instance_rec.attribute5 := NULL;
2821: ELSIF p_counter_instance_rec.attribute5 IS NULL THEN
2822: l_counter_instance_rec.attribute5 := l_old_counter_instance_rec.attribute5;
2823: END IF;
2824: IF p_counter_instance_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2825: l_counter_instance_rec.attribute6 := NULL;
2826: ELSIF p_counter_instance_rec.attribute6 IS NULL THEN
2827: l_counter_instance_rec.attribute6 := l_old_counter_instance_rec.attribute6;
2828: END IF;
2825: l_counter_instance_rec.attribute6 := NULL;
2826: ELSIF p_counter_instance_rec.attribute6 IS NULL THEN
2827: l_counter_instance_rec.attribute6 := l_old_counter_instance_rec.attribute6;
2828: END IF;
2829: IF p_counter_instance_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2830: l_counter_instance_rec.attribute7 := NULL;
2831: ELSIF p_counter_instance_rec.attribute7 IS NULL THEN
2832: l_counter_instance_rec.attribute7 := l_old_counter_instance_rec.attribute7;
2833: END IF;
2830: l_counter_instance_rec.attribute7 := NULL;
2831: ELSIF p_counter_instance_rec.attribute7 IS NULL THEN
2832: l_counter_instance_rec.attribute7 := l_old_counter_instance_rec.attribute7;
2833: END IF;
2834: IF p_counter_instance_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2835: l_counter_instance_rec.attribute8 := NULL;
2836: ELSIF p_counter_instance_rec.attribute8 IS NULL THEN
2837: l_counter_instance_rec.attribute8 := l_old_counter_instance_rec.attribute8;
2838: END IF;
2835: l_counter_instance_rec.attribute8 := NULL;
2836: ELSIF p_counter_instance_rec.attribute8 IS NULL THEN
2837: l_counter_instance_rec.attribute8 := l_old_counter_instance_rec.attribute8;
2838: END IF;
2839: IF p_counter_instance_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2840: l_counter_instance_rec.attribute9 := NULL;
2841: ELSIF p_counter_instance_rec.attribute9 IS NULL THEN
2842: l_counter_instance_rec.attribute9 := l_old_counter_instance_rec.attribute9;
2843: END IF;
2840: l_counter_instance_rec.attribute9 := NULL;
2841: ELSIF p_counter_instance_rec.attribute9 IS NULL THEN
2842: l_counter_instance_rec.attribute9 := l_old_counter_instance_rec.attribute9;
2843: END IF;
2844: IF p_counter_instance_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2845: l_counter_instance_rec.attribute10 := NULL;
2846: ELSIF p_counter_instance_rec.attribute10 IS NULL THEN
2847: l_counter_instance_rec.attribute10 := l_old_counter_instance_rec.attribute10;
2848: END IF;
2845: l_counter_instance_rec.attribute10 := NULL;
2846: ELSIF p_counter_instance_rec.attribute10 IS NULL THEN
2847: l_counter_instance_rec.attribute10 := l_old_counter_instance_rec.attribute10;
2848: END IF;
2849: IF p_counter_instance_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2850: l_counter_instance_rec.attribute11 := NULL;
2851: ELSIF p_counter_instance_rec.attribute11 IS NULL THEN
2852: l_counter_instance_rec.attribute11 := l_old_counter_instance_rec.attribute11;
2853: END IF;
2850: l_counter_instance_rec.attribute11 := NULL;
2851: ELSIF p_counter_instance_rec.attribute11 IS NULL THEN
2852: l_counter_instance_rec.attribute11 := l_old_counter_instance_rec.attribute11;
2853: END IF;
2854: IF p_counter_instance_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2855: l_counter_instance_rec.attribute12 := NULL;
2856: ELSIF p_counter_instance_rec.attribute12 IS NULL THEN
2857: l_counter_instance_rec.attribute12 := l_old_counter_instance_rec.attribute12;
2858: END IF;
2855: l_counter_instance_rec.attribute12 := NULL;
2856: ELSIF p_counter_instance_rec.attribute12 IS NULL THEN
2857: l_counter_instance_rec.attribute12 := l_old_counter_instance_rec.attribute12;
2858: END IF;
2859: IF p_counter_instance_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2860: l_counter_instance_rec.attribute13 := NULL;
2861: ELSIF p_counter_instance_rec.attribute13 IS NULL THEN
2862: l_counter_instance_rec.attribute13 := l_old_counter_instance_rec.attribute13;
2863: END IF;
2860: l_counter_instance_rec.attribute13 := NULL;
2861: ELSIF p_counter_instance_rec.attribute13 IS NULL THEN
2862: l_counter_instance_rec.attribute13 := l_old_counter_instance_rec.attribute13;
2863: END IF;
2864: IF p_counter_instance_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2865: l_counter_instance_rec.attribute14 := NULL;
2866: ELSIF p_counter_instance_rec.attribute14 IS NULL THEN
2867: l_counter_instance_rec.attribute14 := l_old_counter_instance_rec.attribute14;
2868: END IF;
2865: l_counter_instance_rec.attribute14 := NULL;
2866: ELSIF p_counter_instance_rec.attribute14 IS NULL THEN
2867: l_counter_instance_rec.attribute14 := l_old_counter_instance_rec.attribute14;
2868: END IF;
2869: IF p_counter_instance_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2870: l_counter_instance_rec.attribute15 := NULL;
2871: ELSIF p_counter_instance_rec.attribute15 IS NULL THEN
2872: l_counter_instance_rec.attribute15 := l_old_counter_instance_rec.attribute15;
2873: END IF;
2870: l_counter_instance_rec.attribute15 := NULL;
2871: ELSIF p_counter_instance_rec.attribute15 IS NULL THEN
2872: l_counter_instance_rec.attribute15 := l_old_counter_instance_rec.attribute15;
2873: END IF;
2874: IF p_counter_instance_rec.attribute16 = FND_API.G_MISS_CHAR THEN
2875: l_counter_instance_rec.attribute16 := NULL;
2876: ELSIF p_counter_instance_rec.attribute16 IS NULL THEN
2877: l_counter_instance_rec.attribute16 := l_old_counter_instance_rec.attribute16;
2878: END IF;
2875: l_counter_instance_rec.attribute16 := NULL;
2876: ELSIF p_counter_instance_rec.attribute16 IS NULL THEN
2877: l_counter_instance_rec.attribute16 := l_old_counter_instance_rec.attribute16;
2878: END IF;
2879: IF p_counter_instance_rec.attribute17 = FND_API.G_MISS_CHAR THEN
2880: l_counter_instance_rec.attribute17 := NULL;
2881: ELSIF p_counter_instance_rec.attribute17 IS NULL THEN
2882: l_counter_instance_rec.attribute17 := l_old_counter_instance_rec.attribute17;
2883: END IF;
2880: l_counter_instance_rec.attribute17 := NULL;
2881: ELSIF p_counter_instance_rec.attribute17 IS NULL THEN
2882: l_counter_instance_rec.attribute17 := l_old_counter_instance_rec.attribute17;
2883: END IF;
2884: IF p_counter_instance_rec.attribute18 = FND_API.G_MISS_CHAR THEN
2885: l_counter_instance_rec.attribute18 := NULL;
2886: ELSIF p_counter_instance_rec.attribute18 IS NULL THEN
2887: l_counter_instance_rec.attribute18 := l_old_counter_instance_rec.attribute18;
2888: END IF;
2885: l_counter_instance_rec.attribute18 := NULL;
2886: ELSIF p_counter_instance_rec.attribute18 IS NULL THEN
2887: l_counter_instance_rec.attribute18 := l_old_counter_instance_rec.attribute18;
2888: END IF;
2889: IF p_counter_instance_rec.attribute19 = FND_API.G_MISS_CHAR THEN
2890: l_counter_instance_rec.attribute19 := NULL;
2891: ELSIF p_counter_instance_rec.attribute19 IS NULL THEN
2892: l_counter_instance_rec.attribute19 := l_old_counter_instance_rec.attribute19;
2893: END IF;
2890: l_counter_instance_rec.attribute19 := NULL;
2891: ELSIF p_counter_instance_rec.attribute19 IS NULL THEN
2892: l_counter_instance_rec.attribute19 := l_old_counter_instance_rec.attribute19;
2893: END IF;
2894: IF p_counter_instance_rec.attribute20 = FND_API.G_MISS_CHAR THEN
2895: l_counter_instance_rec.attribute20 := NULL;
2896: ELSIF p_counter_instance_rec.attribute20 IS NULL THEN
2897: l_counter_instance_rec.attribute20 := l_old_counter_instance_rec.attribute20;
2898: END IF;
2895: l_counter_instance_rec.attribute20 := NULL;
2896: ELSIF p_counter_instance_rec.attribute20 IS NULL THEN
2897: l_counter_instance_rec.attribute20 := l_old_counter_instance_rec.attribute20;
2898: END IF;
2899: IF p_counter_instance_rec.attribute21 = FND_API.G_MISS_CHAR THEN
2900: l_counter_instance_rec.attribute21 := NULL;
2901: ELSIF p_counter_instance_rec.attribute21 IS NULL THEN
2902: l_counter_instance_rec.attribute21 := l_old_counter_instance_rec.attribute21;
2903: END IF;
2900: l_counter_instance_rec.attribute21 := NULL;
2901: ELSIF p_counter_instance_rec.attribute21 IS NULL THEN
2902: l_counter_instance_rec.attribute21 := l_old_counter_instance_rec.attribute21;
2903: END IF;
2904: IF p_counter_instance_rec.attribute22 = FND_API.G_MISS_CHAR THEN
2905: l_counter_instance_rec.attribute22 := NULL;
2906: ELSIF p_counter_instance_rec.attribute22 IS NULL THEN
2907: l_counter_instance_rec.attribute22 := l_old_counter_instance_rec.attribute22;
2908: END IF;
2905: l_counter_instance_rec.attribute22 := NULL;
2906: ELSIF p_counter_instance_rec.attribute22 IS NULL THEN
2907: l_counter_instance_rec.attribute22 := l_old_counter_instance_rec.attribute22;
2908: END IF;
2909: IF p_counter_instance_rec.attribute23 = FND_API.G_MISS_CHAR THEN
2910: l_counter_instance_rec.attribute23 := NULL;
2911: ELSIF p_counter_instance_rec.attribute23 IS NULL THEN
2912: l_counter_instance_rec.attribute23 := l_old_counter_instance_rec.attribute23;
2913: END IF;
2910: l_counter_instance_rec.attribute23 := NULL;
2911: ELSIF p_counter_instance_rec.attribute23 IS NULL THEN
2912: l_counter_instance_rec.attribute23 := l_old_counter_instance_rec.attribute23;
2913: END IF;
2914: IF p_counter_instance_rec.attribute24 = FND_API.G_MISS_CHAR THEN
2915: l_counter_instance_rec.attribute24 := NULL;
2916: ELSIF p_counter_instance_rec.attribute24 IS NULL THEN
2917: l_counter_instance_rec.attribute24 := l_old_counter_instance_rec.attribute24;
2918: END IF;
2915: l_counter_instance_rec.attribute24 := NULL;
2916: ELSIF p_counter_instance_rec.attribute24 IS NULL THEN
2917: l_counter_instance_rec.attribute24 := l_old_counter_instance_rec.attribute24;
2918: END IF;
2919: IF p_counter_instance_rec.attribute25 = FND_API.G_MISS_CHAR THEN
2920: l_counter_instance_rec.attribute25 := NULL;
2921: ELSIF p_counter_instance_rec.attribute25 IS NULL THEN
2922: l_counter_instance_rec.attribute25 := l_old_counter_instance_rec.attribute25;
2923: END IF;
2920: l_counter_instance_rec.attribute25 := NULL;
2921: ELSIF p_counter_instance_rec.attribute25 IS NULL THEN
2922: l_counter_instance_rec.attribute25 := l_old_counter_instance_rec.attribute25;
2923: END IF;
2924: IF p_counter_instance_rec.attribute26 = FND_API.G_MISS_CHAR THEN
2925: l_counter_instance_rec.attribute26 := NULL;
2926: ELSIF p_counter_instance_rec.attribute26 IS NULL THEN
2927: l_counter_instance_rec.attribute26 := l_old_counter_instance_rec.attribute26;
2928: END IF;
2925: l_counter_instance_rec.attribute26 := NULL;
2926: ELSIF p_counter_instance_rec.attribute26 IS NULL THEN
2927: l_counter_instance_rec.attribute26 := l_old_counter_instance_rec.attribute26;
2928: END IF;
2929: IF p_counter_instance_rec.attribute27 = FND_API.G_MISS_CHAR THEN
2930: l_counter_instance_rec.attribute27 := NULL;
2931: ELSIF p_counter_instance_rec.attribute27 IS NULL THEN
2932: l_counter_instance_rec.attribute27 := l_old_counter_instance_rec.attribute27;
2933: END IF;
2930: l_counter_instance_rec.attribute27 := NULL;
2931: ELSIF p_counter_instance_rec.attribute27 IS NULL THEN
2932: l_counter_instance_rec.attribute27 := l_old_counter_instance_rec.attribute27;
2933: END IF;
2934: IF p_counter_instance_rec.attribute28 = FND_API.G_MISS_CHAR THEN
2935: l_counter_instance_rec.attribute28 := NULL;
2936: ELSIF p_counter_instance_rec.attribute28 IS NULL THEN
2937: l_counter_instance_rec.attribute28 := l_old_counter_instance_rec.attribute28;
2938: END IF;
2935: l_counter_instance_rec.attribute28 := NULL;
2936: ELSIF p_counter_instance_rec.attribute28 IS NULL THEN
2937: l_counter_instance_rec.attribute28 := l_old_counter_instance_rec.attribute28;
2938: END IF;
2939: IF p_counter_instance_rec.attribute29 = FND_API.G_MISS_CHAR THEN
2940: l_counter_instance_rec.attribute29 := NULL;
2941: ELSIF p_counter_instance_rec.attribute29 IS NULL THEN
2942: l_counter_instance_rec.attribute29 := l_old_counter_instance_rec.attribute29;
2943: END IF;
2940: l_counter_instance_rec.attribute29 := NULL;
2941: ELSIF p_counter_instance_rec.attribute29 IS NULL THEN
2942: l_counter_instance_rec.attribute29 := l_old_counter_instance_rec.attribute29;
2943: END IF;
2944: IF p_counter_instance_rec.attribute30 = FND_API.G_MISS_CHAR THEN
2945: l_counter_instance_rec.attribute30 := NULL;
2946: ELSIF p_counter_instance_rec.attribute30 IS NULL THEN
2947: l_counter_instance_rec.attribute30 := l_old_counter_instance_rec.attribute30;
2948: END IF;
2945: l_counter_instance_rec.attribute30 := NULL;
2946: ELSIF p_counter_instance_rec.attribute30 IS NULL THEN
2947: l_counter_instance_rec.attribute30 := l_old_counter_instance_rec.attribute30;
2948: END IF;
2949: IF p_counter_instance_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2950: l_counter_instance_rec.attribute_category := NULL;
2951: ELSIF p_counter_instance_rec.attribute_category IS NULL THEN
2952: l_counter_instance_rec.attribute_category := l_old_counter_instance_rec.attribute_category;
2953: END IF;
2950: l_counter_instance_rec.attribute_category := NULL;
2951: ELSIF p_counter_instance_rec.attribute_category IS NULL THEN
2952: l_counter_instance_rec.attribute_category := l_old_counter_instance_rec.attribute_category;
2953: END IF;
2954: IF p_counter_instance_rec.customer_view = FND_API.G_MISS_CHAR THEN
2955: l_counter_instance_rec.customer_view := NULL;
2956: ELSIF p_counter_instance_rec.customer_view IS NULL THEN
2957: l_counter_instance_rec.customer_view := l_old_counter_instance_rec.customer_view;
2958: END IF;
2955: l_counter_instance_rec.customer_view := NULL;
2956: ELSIF p_counter_instance_rec.customer_view IS NULL THEN
2957: l_counter_instance_rec.customer_view := l_old_counter_instance_rec.customer_view;
2958: END IF;
2959: IF p_counter_instance_rec.direction = FND_API.G_MISS_CHAR THEN
2960: l_counter_instance_rec.direction := NULL;
2961: ELSIF p_counter_instance_rec.direction IS NULL THEN
2962: l_counter_instance_rec.direction := l_old_counter_instance_rec.direction;
2963: END IF;
2960: l_counter_instance_rec.direction := NULL;
2961: ELSIF p_counter_instance_rec.direction IS NULL THEN
2962: l_counter_instance_rec.direction := l_old_counter_instance_rec.direction;
2963: END IF;
2964: IF p_counter_instance_rec.filter_type = FND_API.G_MISS_CHAR THEN
2965: l_counter_instance_rec.filter_type := NULL;
2966: ELSIF p_counter_instance_rec.filter_type IS NULL THEN
2967: l_counter_instance_rec.filter_type := l_old_counter_instance_rec.filter_type;
2968: END IF;
2965: l_counter_instance_rec.filter_type := NULL;
2966: ELSIF p_counter_instance_rec.filter_type IS NULL THEN
2967: l_counter_instance_rec.filter_type := l_old_counter_instance_rec.filter_type;
2968: END IF;
2969: IF p_counter_instance_rec.filter_reading_count = FND_API.G_MISS_NUM THEN
2970: l_counter_instance_rec.filter_reading_count := NULL;
2971: ELSIF p_counter_instance_rec.filter_reading_count IS NULL THEN
2972: l_counter_instance_rec.filter_reading_count := l_old_counter_instance_rec.filter_reading_count;
2973: END IF;
2970: l_counter_instance_rec.filter_reading_count := NULL;
2971: ELSIF p_counter_instance_rec.filter_reading_count IS NULL THEN
2972: l_counter_instance_rec.filter_reading_count := l_old_counter_instance_rec.filter_reading_count;
2973: END IF;
2974: IF p_counter_instance_rec.filter_time_uom = FND_API.G_MISS_CHAR THEN
2975: l_counter_instance_rec.filter_time_uom := NULL;
2976: ELSIF p_counter_instance_rec.filter_time_uom IS NULL THEN
2977: l_counter_instance_rec.filter_time_uom := l_old_counter_instance_rec.filter_time_uom;
2978: END IF;
2975: l_counter_instance_rec.filter_time_uom := NULL;
2976: ELSIF p_counter_instance_rec.filter_time_uom IS NULL THEN
2977: l_counter_instance_rec.filter_time_uom := l_old_counter_instance_rec.filter_time_uom;
2978: END IF;
2979: IF p_counter_instance_rec.estimation_id = FND_API.G_MISS_NUM THEN
2980: l_counter_instance_rec.estimation_id := NULL;
2981: ELSIF p_counter_instance_rec.estimation_id IS NULL THEN
2982: l_counter_instance_rec.estimation_id := l_old_counter_instance_rec.estimation_id;
2983: END IF;
2981: ELSIF p_counter_instance_rec.estimation_id IS NULL THEN
2982: l_counter_instance_rec.estimation_id := l_old_counter_instance_rec.estimation_id;
2983: END IF;
2984:
2985: IF p_counter_instance_rec.time_based_manual_entry = FND_API.G_MISS_CHAR THEN
2986: l_counter_instance_rec.time_based_manual_entry := NULL;
2987: ELSIF p_counter_instance_rec.time_based_manual_entry IS NULL THEN
2988: l_counter_instance_rec.time_based_manual_entry := l_old_counter_instance_rec.time_based_manual_entry;
2989: END IF;
2987: ELSIF p_counter_instance_rec.time_based_manual_entry IS NULL THEN
2988: l_counter_instance_rec.time_based_manual_entry := l_old_counter_instance_rec.time_based_manual_entry;
2989: END IF;
2990:
2991: IF p_counter_instance_rec.reading_type = FND_API.G_MISS_NUM THEN
2992: l_counter_instance_rec.reading_type := NULL;
2993: ELSIF p_counter_instance_rec.reading_type IS NULL THEN
2994: l_counter_instance_rec.reading_type := l_old_counter_instance_rec.reading_type;
2995: END IF;
2992: l_counter_instance_rec.reading_type := NULL;
2993: ELSIF p_counter_instance_rec.reading_type IS NULL THEN
2994: l_counter_instance_rec.reading_type := l_old_counter_instance_rec.reading_type;
2995: END IF;
2996: IF p_counter_instance_rec.automatic_rollover = FND_API.G_MISS_CHAR THEN
2997: l_counter_instance_rec.automatic_rollover := NULL;
2998: ELSIF p_counter_instance_rec.automatic_rollover IS NULL THEN
2999: l_counter_instance_rec.automatic_rollover := l_old_counter_instance_rec.automatic_rollover;
3000: END IF;
2997: l_counter_instance_rec.automatic_rollover := NULL;
2998: ELSIF p_counter_instance_rec.automatic_rollover IS NULL THEN
2999: l_counter_instance_rec.automatic_rollover := l_old_counter_instance_rec.automatic_rollover;
3000: END IF;
3001: IF p_counter_instance_rec.default_usage_rate = FND_API.G_MISS_NUM THEN
3002: l_counter_instance_rec.default_usage_rate := NULL;
3003: ELSIF p_counter_instance_rec.default_usage_rate IS NULL THEN
3004: l_counter_instance_rec.default_usage_rate := l_old_counter_instance_rec.default_usage_rate;
3005: END IF;
3002: l_counter_instance_rec.default_usage_rate := NULL;
3003: ELSIF p_counter_instance_rec.default_usage_rate IS NULL THEN
3004: l_counter_instance_rec.default_usage_rate := l_old_counter_instance_rec.default_usage_rate;
3005: END IF;
3006: IF p_counter_instance_rec.use_past_reading = FND_API.G_MISS_NUM THEN
3007: l_counter_instance_rec.use_past_reading := NULL;
3008: ELSIF p_counter_instance_rec.use_past_reading IS NULL THEN
3009: l_counter_instance_rec.use_past_reading := l_old_counter_instance_rec.use_past_reading;
3010: END IF;
3007: l_counter_instance_rec.use_past_reading := NULL;
3008: ELSIF p_counter_instance_rec.use_past_reading IS NULL THEN
3009: l_counter_instance_rec.use_past_reading := l_old_counter_instance_rec.use_past_reading;
3010: END IF;
3011: IF p_counter_instance_rec.used_in_scheduling = FND_API.G_MISS_CHAR THEN
3012: l_counter_instance_rec.used_in_scheduling := NULL;
3013: ELSIF p_counter_instance_rec.used_in_scheduling IS NULL THEN
3014: l_counter_instance_rec.used_in_scheduling := l_old_counter_instance_rec.used_in_scheduling;
3015: END IF;
3012: l_counter_instance_rec.used_in_scheduling := NULL;
3013: ELSIF p_counter_instance_rec.used_in_scheduling IS NULL THEN
3014: l_counter_instance_rec.used_in_scheduling := l_old_counter_instance_rec.used_in_scheduling;
3015: END IF;
3016: IF p_counter_instance_rec.defaulted_group_id = FND_API.G_MISS_NUM THEN
3017: l_counter_instance_rec.defaulted_group_id := NULL;
3018: ELSIF p_counter_instance_rec.defaulted_group_id IS NULL THEN
3019: l_counter_instance_rec.defaulted_group_id := l_old_counter_instance_rec.defaulted_group_id;
3020: END IF;
3017: l_counter_instance_rec.defaulted_group_id := NULL;
3018: ELSIF p_counter_instance_rec.defaulted_group_id IS NULL THEN
3019: l_counter_instance_rec.defaulted_group_id := l_old_counter_instance_rec.defaulted_group_id;
3020: END IF;
3021: IF p_counter_instance_rec.name = FND_API.G_MISS_CHAR THEN
3022: l_counter_instance_rec.name := NULL;
3023: ELSIF p_counter_instance_rec.name IS NULL THEN
3024: l_counter_instance_rec.name := l_old_counter_instance_rec.name;
3025: END IF;
3022: l_counter_instance_rec.name := NULL;
3023: ELSIF p_counter_instance_rec.name IS NULL THEN
3024: l_counter_instance_rec.name := l_old_counter_instance_rec.name;
3025: END IF;
3026: IF p_counter_instance_rec.comments = FND_API.G_MISS_CHAR THEN
3027: l_counter_instance_rec.comments := NULL;
3028: ELSIF p_counter_instance_rec.comments IS NULL THEN
3029: l_counter_instance_rec.comments := l_old_counter_instance_rec.comments;
3030: END IF;
3027: l_counter_instance_rec.comments := NULL;
3028: ELSIF p_counter_instance_rec.comments IS NULL THEN
3029: l_counter_instance_rec.comments := l_old_counter_instance_rec.comments;
3030: END IF;
3031: IF p_counter_instance_rec.step_value = FND_API.G_MISS_NUM THEN
3032: l_counter_instance_rec.step_value := NULL;
3033: ELSIF p_counter_instance_rec.step_value IS NULL THEN
3034: l_counter_instance_rec.step_value := l_old_counter_instance_rec.step_value;
3035: END IF;
3032: l_counter_instance_rec.step_value := NULL;
3033: ELSIF p_counter_instance_rec.step_value IS NULL THEN
3034: l_counter_instance_rec.step_value := l_old_counter_instance_rec.step_value;
3035: END IF;
3036: IF p_counter_instance_rec.object_version_number = FND_API.G_MISS_NUM THEN
3037: l_counter_instance_rec.object_version_number := NULL;
3038: ELSIF p_counter_instance_rec.object_version_number IS NULL THEN
3039: l_counter_instance_rec.object_version_number := l_old_counter_instance_rec.object_version_number;
3040: END IF;
3044: csi_ctr_gen_utility_pvt.put_line('Object version mismatch in update counter');
3045: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_OBJ_VER_MISMATCH');
3046: END IF;
3047:
3048: IF p_counter_instance_rec.eam_required_flag = FND_API.G_MISS_CHAR THEN
3049: l_counter_instance_rec.eam_required_flag := NULL;
3050: ELSIF p_counter_instance_rec.eam_required_flag IS NULL THEN
3051: l_counter_instance_rec.eam_required_flag := l_old_counter_instance_rec.eam_required_flag;
3052: END IF;
3059: X_return_status => l_return_status,
3060: X_msg_count => l_msg_count,
3061: X_msg_data => l_msg_data
3062: );
3063: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3064: csi_ctr_gen_utility_pvt.put_line('used in scheduling cannot be updated');
3065: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_USEDINSCHED_NOT_UPDT');
3066: END IF;
3067:
3245: ,p_time_based_manual_entry => p_counter_instance_rec.time_based_manual_entry
3246: ,p_eam_required_flag => p_counter_instance_rec.eam_required_flag
3247: ,p_comments => NULL
3248: );
3249: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3250: ROLLBACK TO update_counter_pvt;
3251: RETURN;
3252: END IF;
3253:
3253:
3254: -- End of API body
3255:
3256: -- Standard check of p_commit.
3257: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3258: COMMIT WORK;
3259: END IF;
3260:
3261: EXCEPTION
3258: COMMIT WORK;
3259: END IF;
3260:
3261: EXCEPTION
3262: WHEN FND_API.G_EXC_ERROR THEN
3263: x_return_status := FND_API.G_RET_STS_ERROR ;
3264: ROLLBACK TO update_counter_pvt;
3265: FND_MSG_PUB.Count_And_Get
3266: (p_count => x_msg_count,
3259: END IF;
3260:
3261: EXCEPTION
3262: WHEN FND_API.G_EXC_ERROR THEN
3263: x_return_status := FND_API.G_RET_STS_ERROR ;
3264: ROLLBACK TO update_counter_pvt;
3265: FND_MSG_PUB.Count_And_Get
3266: (p_count => x_msg_count,
3267: p_data => x_msg_data
3266: (p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269:
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3272: ROLLBACK TO update_counter_pvt;
3273: FND_MSG_PUB.Count_And_Get
3274: (p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269:
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3272: ROLLBACK TO update_counter_pvt;
3273: FND_MSG_PUB.Count_And_Get
3274: (p_count => x_msg_count,
3275: p_data => x_msg_data
3274: (p_count => x_msg_count,
3275: p_data => x_msg_data
3276: );
3277: WHEN OTHERS THEN
3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3279: ROLLBACK TO update_counter_pvt;
3280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3281: THEN
3282: FND_MSG_PUB.Add_Exc_Msg
3330: -- Standard Start of API savepoint
3331: SAVEPOINT update_ctr_property_pvt;
3332:
3333: -- Standard call to check for call compatibility.
3334: IF NOT FND_API.Compatible_API_Call (l_api_version,
3335: p_api_version,
3336: l_api_name ,
3337: G_PKG_NAME )
3338: THEN
3335: p_api_version,
3336: l_api_name ,
3337: G_PKG_NAME )
3338: THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: END IF;
3341:
3342: -- Initialize message list if p_init_msg_list is set to TRUE.
3343: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: END IF;
3341:
3342: -- Initialize message list if p_init_msg_list is set to TRUE.
3343: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3344: FND_MSG_PUB.initialize;
3345: END IF;
3346:
3347: -- Initialize API return status to success
3344: FND_MSG_PUB.initialize;
3345: END IF;
3346:
3347: -- Initialize API return status to success
3348: x_return_status := FND_API.G_RET_STS_SUCCESS;
3349:
3350: -- Read the debug profiles values in to global variable 7197402
3351: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3352:
3438: END IF;
3439:
3440: l_ctr_properties_rec := p_ctr_properties_rec;
3441:
3442: IF p_ctr_properties_rec.NAME = FND_API.G_MISS_CHAR THEN
3443: l_ctr_properties_rec.NAME := NULL;
3444: ELSIF p_ctr_properties_rec.NAME IS NULL THEN
3445: l_ctr_properties_rec.NAME := l_old_ctr_properties_rec.NAME;
3446: END IF;
3443: l_ctr_properties_rec.NAME := NULL;
3444: ELSIF p_ctr_properties_rec.NAME IS NULL THEN
3445: l_ctr_properties_rec.NAME := l_old_ctr_properties_rec.NAME;
3446: END IF;
3447: IF p_ctr_properties_rec.DESCRIPTION = FND_API.G_MISS_CHAR THEN
3448: l_ctr_properties_rec.DESCRIPTION := NULL;
3449: ELSIF p_ctr_properties_rec.DESCRIPTION IS NULL THEN
3450: l_ctr_properties_rec.DESCRIPTION := l_old_ctr_properties_rec.DESCRIPTION;
3451: END IF;
3448: l_ctr_properties_rec.DESCRIPTION := NULL;
3449: ELSIF p_ctr_properties_rec.DESCRIPTION IS NULL THEN
3450: l_ctr_properties_rec.DESCRIPTION := l_old_ctr_properties_rec.DESCRIPTION;
3451: END IF;
3452: IF p_ctr_properties_rec.COUNTER_ID = FND_API.G_MISS_NUM THEN
3453: l_ctr_properties_rec.COUNTER_ID := NULL;
3454: ELSIF p_ctr_properties_rec.COUNTER_ID IS NULL THEN
3455: l_ctr_properties_rec.COUNTER_ID := l_old_ctr_properties_rec.COUNTER_ID;
3456: END IF;
3453: l_ctr_properties_rec.COUNTER_ID := NULL;
3454: ELSIF p_ctr_properties_rec.COUNTER_ID IS NULL THEN
3455: l_ctr_properties_rec.COUNTER_ID := l_old_ctr_properties_rec.COUNTER_ID;
3456: END IF;
3457: IF p_ctr_properties_rec.PROPERTY_DATA_TYPE = FND_API.G_MISS_CHAR THEN
3458: l_ctr_properties_rec.PROPERTY_DATA_TYPE := NULL;
3459: ELSIF p_ctr_properties_rec.PROPERTY_DATA_TYPE IS NULL THEN
3460: l_ctr_properties_rec.PROPERTY_DATA_TYPE := l_old_ctr_properties_rec.PROPERTY_DATA_TYPE;
3461: END IF;
3458: l_ctr_properties_rec.PROPERTY_DATA_TYPE := NULL;
3459: ELSIF p_ctr_properties_rec.PROPERTY_DATA_TYPE IS NULL THEN
3460: l_ctr_properties_rec.PROPERTY_DATA_TYPE := l_old_ctr_properties_rec.PROPERTY_DATA_TYPE;
3461: END IF;
3462: IF p_ctr_properties_rec.IS_NULLABLE = FND_API.G_MISS_CHAR THEN
3463: l_ctr_properties_rec.IS_NULLABLE := NULL;
3464: ELSIF p_ctr_properties_rec.IS_NULLABLE IS NULL THEN
3465: l_ctr_properties_rec.IS_NULLABLE := l_old_ctr_properties_rec.IS_NULLABLE;
3466: END IF;
3463: l_ctr_properties_rec.IS_NULLABLE := NULL;
3464: ELSIF p_ctr_properties_rec.IS_NULLABLE IS NULL THEN
3465: l_ctr_properties_rec.IS_NULLABLE := l_old_ctr_properties_rec.IS_NULLABLE;
3466: END IF;
3467: IF p_ctr_properties_rec.DEFAULT_VALUE = FND_API.G_MISS_CHAR THEN
3468: l_ctr_properties_rec.DEFAULT_VALUE := NULL;
3469: ELSIF p_ctr_properties_rec.DEFAULT_VALUE IS NULL THEN
3470: l_ctr_properties_rec.DEFAULT_VALUE := l_old_ctr_properties_rec.DEFAULT_VALUE;
3471: END IF;
3468: l_ctr_properties_rec.DEFAULT_VALUE := NULL;
3469: ELSIF p_ctr_properties_rec.DEFAULT_VALUE IS NULL THEN
3470: l_ctr_properties_rec.DEFAULT_VALUE := l_old_ctr_properties_rec.DEFAULT_VALUE;
3471: END IF;
3472: IF p_ctr_properties_rec.MINIMUM_VALUE = FND_API.G_MISS_CHAR THEN
3473: l_ctr_properties_rec.MINIMUM_VALUE := NULL;
3474: ELSIF p_ctr_properties_rec.MINIMUM_VALUE IS NULL THEN
3475: l_ctr_properties_rec.MINIMUM_VALUE := l_old_ctr_properties_rec.MINIMUM_VALUE;
3476: END IF;
3473: l_ctr_properties_rec.MINIMUM_VALUE := NULL;
3474: ELSIF p_ctr_properties_rec.MINIMUM_VALUE IS NULL THEN
3475: l_ctr_properties_rec.MINIMUM_VALUE := l_old_ctr_properties_rec.MINIMUM_VALUE;
3476: END IF;
3477: IF p_ctr_properties_rec.MAXIMUM_VALUE = FND_API.G_MISS_CHAR THEN
3478: l_ctr_properties_rec.MAXIMUM_VALUE := NULL;
3479: ELSIF p_ctr_properties_rec.MAXIMUM_VALUE IS NULL THEN
3480: l_ctr_properties_rec.MAXIMUM_VALUE := l_old_ctr_properties_rec.MAXIMUM_VALUE;
3481: END IF;
3478: l_ctr_properties_rec.MAXIMUM_VALUE := NULL;
3479: ELSIF p_ctr_properties_rec.MAXIMUM_VALUE IS NULL THEN
3480: l_ctr_properties_rec.MAXIMUM_VALUE := l_old_ctr_properties_rec.MAXIMUM_VALUE;
3481: END IF;
3482: IF p_ctr_properties_rec.UOM_CODE = FND_API.G_MISS_CHAR THEN
3483: l_ctr_properties_rec.UOM_CODE := NULL;
3484: ELSIF p_ctr_properties_rec.UOM_CODE IS NULL THEN
3485: l_ctr_properties_rec.UOM_CODE := l_old_ctr_properties_rec.UOM_CODE;
3486: END IF;
3483: l_ctr_properties_rec.UOM_CODE := NULL;
3484: ELSIF p_ctr_properties_rec.UOM_CODE IS NULL THEN
3485: l_ctr_properties_rec.UOM_CODE := l_old_ctr_properties_rec.UOM_CODE;
3486: END IF;
3487: IF p_ctr_properties_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE THEN
3488: l_ctr_properties_rec.START_DATE_ACTIVE := NULL;
3489: ELSIF p_ctr_properties_rec.START_DATE_ACTIVE IS NULL THEN
3490: l_ctr_properties_rec.START_DATE_ACTIVE := l_old_ctr_properties_rec.START_DATE_ACTIVE;
3491: END IF;
3488: l_ctr_properties_rec.START_DATE_ACTIVE := NULL;
3489: ELSIF p_ctr_properties_rec.START_DATE_ACTIVE IS NULL THEN
3490: l_ctr_properties_rec.START_DATE_ACTIVE := l_old_ctr_properties_rec.START_DATE_ACTIVE;
3491: END IF;
3492: IF p_ctr_properties_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE THEN
3493: l_ctr_properties_rec.END_DATE_ACTIVE := NULL;
3494: ELSIF p_ctr_properties_rec.END_DATE_ACTIVE IS NULL THEN
3495: l_ctr_properties_rec.END_DATE_ACTIVE := l_old_ctr_properties_rec.END_DATE_ACTIVE;
3496: END IF;
3493: l_ctr_properties_rec.END_DATE_ACTIVE := NULL;
3494: ELSIF p_ctr_properties_rec.END_DATE_ACTIVE IS NULL THEN
3495: l_ctr_properties_rec.END_DATE_ACTIVE := l_old_ctr_properties_rec.END_DATE_ACTIVE;
3496: END IF;
3497: IF p_ctr_properties_rec.PROPERTY_LOV_TYPE = FND_API.G_MISS_CHAR THEN
3498: l_ctr_properties_rec.PROPERTY_LOV_TYPE := NULL;
3499: ELSIF p_ctr_properties_rec.PROPERTY_LOV_TYPE IS NULL THEN
3500: l_ctr_properties_rec.PROPERTY_LOV_TYPE := l_old_ctr_properties_rec.PROPERTY_LOV_TYPE;
3501: END IF;
3498: l_ctr_properties_rec.PROPERTY_LOV_TYPE := NULL;
3499: ELSIF p_ctr_properties_rec.PROPERTY_LOV_TYPE IS NULL THEN
3500: l_ctr_properties_rec.PROPERTY_LOV_TYPE := l_old_ctr_properties_rec.PROPERTY_LOV_TYPE;
3501: END IF;
3502: IF p_ctr_properties_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
3503: l_ctr_properties_rec.ATTRIBUTE1 := NULL;
3504: ELSIF p_ctr_properties_rec.ATTRIBUTE1 IS NULL THEN
3505: l_ctr_properties_rec.ATTRIBUTE1 := l_old_ctr_properties_rec.ATTRIBUTE1;
3506: END IF;
3503: l_ctr_properties_rec.ATTRIBUTE1 := NULL;
3504: ELSIF p_ctr_properties_rec.ATTRIBUTE1 IS NULL THEN
3505: l_ctr_properties_rec.ATTRIBUTE1 := l_old_ctr_properties_rec.ATTRIBUTE1;
3506: END IF;
3507: IF p_ctr_properties_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
3508: l_ctr_properties_rec.ATTRIBUTE2 := NULL;
3509: ELSIF p_ctr_properties_rec.ATTRIBUTE2 IS NULL THEN
3510: l_ctr_properties_rec.ATTRIBUTE2 := l_old_ctr_properties_rec.ATTRIBUTE2;
3511: END IF;
3508: l_ctr_properties_rec.ATTRIBUTE2 := NULL;
3509: ELSIF p_ctr_properties_rec.ATTRIBUTE2 IS NULL THEN
3510: l_ctr_properties_rec.ATTRIBUTE2 := l_old_ctr_properties_rec.ATTRIBUTE2;
3511: END IF;
3512: IF p_ctr_properties_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
3513: l_ctr_properties_rec.ATTRIBUTE3 := NULL;
3514: ELSIF p_ctr_properties_rec.ATTRIBUTE3 IS NULL THEN
3515: l_ctr_properties_rec.ATTRIBUTE3 := l_old_ctr_properties_rec.ATTRIBUTE3;
3516: END IF;
3513: l_ctr_properties_rec.ATTRIBUTE3 := NULL;
3514: ELSIF p_ctr_properties_rec.ATTRIBUTE3 IS NULL THEN
3515: l_ctr_properties_rec.ATTRIBUTE3 := l_old_ctr_properties_rec.ATTRIBUTE3;
3516: END IF;
3517: IF p_ctr_properties_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
3518: l_ctr_properties_rec.ATTRIBUTE4 := NULL;
3519: ELSIF p_ctr_properties_rec.ATTRIBUTE4 IS NULL THEN
3520: l_ctr_properties_rec.ATTRIBUTE4 := l_old_ctr_properties_rec.ATTRIBUTE4;
3521: END IF;
3518: l_ctr_properties_rec.ATTRIBUTE4 := NULL;
3519: ELSIF p_ctr_properties_rec.ATTRIBUTE4 IS NULL THEN
3520: l_ctr_properties_rec.ATTRIBUTE4 := l_old_ctr_properties_rec.ATTRIBUTE4;
3521: END IF;
3522: IF p_ctr_properties_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
3523: l_ctr_properties_rec.ATTRIBUTE5 := NULL;
3524: ELSIF p_ctr_properties_rec.ATTRIBUTE5 IS NULL THEN
3525: l_ctr_properties_rec.ATTRIBUTE5 := l_old_ctr_properties_rec.ATTRIBUTE5;
3526: END IF;
3523: l_ctr_properties_rec.ATTRIBUTE5 := NULL;
3524: ELSIF p_ctr_properties_rec.ATTRIBUTE5 IS NULL THEN
3525: l_ctr_properties_rec.ATTRIBUTE5 := l_old_ctr_properties_rec.ATTRIBUTE5;
3526: END IF;
3527: IF p_ctr_properties_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
3528: l_ctr_properties_rec.ATTRIBUTE6 := NULL;
3529: ELSIF p_ctr_properties_rec.ATTRIBUTE6 IS NULL THEN
3530: l_ctr_properties_rec.ATTRIBUTE6 := l_old_ctr_properties_rec.ATTRIBUTE6;
3531: END IF;
3528: l_ctr_properties_rec.ATTRIBUTE6 := NULL;
3529: ELSIF p_ctr_properties_rec.ATTRIBUTE6 IS NULL THEN
3530: l_ctr_properties_rec.ATTRIBUTE6 := l_old_ctr_properties_rec.ATTRIBUTE6;
3531: END IF;
3532: IF p_ctr_properties_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
3533: l_ctr_properties_rec.ATTRIBUTE7 := NULL;
3534: ELSIF p_ctr_properties_rec.ATTRIBUTE7 IS NULL THEN
3535: l_ctr_properties_rec.ATTRIBUTE7 := l_old_ctr_properties_rec.ATTRIBUTE7;
3536: END IF;
3533: l_ctr_properties_rec.ATTRIBUTE7 := NULL;
3534: ELSIF p_ctr_properties_rec.ATTRIBUTE7 IS NULL THEN
3535: l_ctr_properties_rec.ATTRIBUTE7 := l_old_ctr_properties_rec.ATTRIBUTE7;
3536: END IF;
3537: IF p_ctr_properties_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
3538: l_ctr_properties_rec.ATTRIBUTE8 := NULL;
3539: ELSIF p_ctr_properties_rec.ATTRIBUTE8 IS NULL THEN
3540: l_ctr_properties_rec.ATTRIBUTE8 := l_old_ctr_properties_rec.ATTRIBUTE8;
3541: END IF;
3538: l_ctr_properties_rec.ATTRIBUTE8 := NULL;
3539: ELSIF p_ctr_properties_rec.ATTRIBUTE8 IS NULL THEN
3540: l_ctr_properties_rec.ATTRIBUTE8 := l_old_ctr_properties_rec.ATTRIBUTE8;
3541: END IF;
3542: IF p_ctr_properties_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
3543: l_ctr_properties_rec.ATTRIBUTE9 := NULL;
3544: ELSIF p_ctr_properties_rec.ATTRIBUTE9 IS NULL THEN
3545: l_ctr_properties_rec.ATTRIBUTE9 := l_old_ctr_properties_rec.ATTRIBUTE9;
3546: END IF;
3543: l_ctr_properties_rec.ATTRIBUTE9 := NULL;
3544: ELSIF p_ctr_properties_rec.ATTRIBUTE9 IS NULL THEN
3545: l_ctr_properties_rec.ATTRIBUTE9 := l_old_ctr_properties_rec.ATTRIBUTE9;
3546: END IF;
3547: IF p_ctr_properties_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
3548: l_ctr_properties_rec.ATTRIBUTE10 := NULL;
3549: ELSIF p_ctr_properties_rec.ATTRIBUTE10 IS NULL THEN
3550: l_ctr_properties_rec.ATTRIBUTE10 := l_old_ctr_properties_rec.ATTRIBUTE10;
3551: END IF;
3548: l_ctr_properties_rec.ATTRIBUTE10 := NULL;
3549: ELSIF p_ctr_properties_rec.ATTRIBUTE10 IS NULL THEN
3550: l_ctr_properties_rec.ATTRIBUTE10 := l_old_ctr_properties_rec.ATTRIBUTE10;
3551: END IF;
3552: IF p_ctr_properties_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
3553: l_ctr_properties_rec.ATTRIBUTE11 := NULL;
3554: ELSIF p_ctr_properties_rec.ATTRIBUTE11 IS NULL THEN
3555: l_ctr_properties_rec.ATTRIBUTE11 := l_old_ctr_properties_rec.ATTRIBUTE11;
3556: END IF;
3553: l_ctr_properties_rec.ATTRIBUTE11 := NULL;
3554: ELSIF p_ctr_properties_rec.ATTRIBUTE11 IS NULL THEN
3555: l_ctr_properties_rec.ATTRIBUTE11 := l_old_ctr_properties_rec.ATTRIBUTE11;
3556: END IF;
3557: IF p_ctr_properties_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
3558: l_ctr_properties_rec.ATTRIBUTE12 := NULL;
3559: ELSIF p_ctr_properties_rec.ATTRIBUTE12 IS NULL THEN
3560: l_ctr_properties_rec.ATTRIBUTE12 := l_old_ctr_properties_rec.ATTRIBUTE12;
3561: END IF;
3558: l_ctr_properties_rec.ATTRIBUTE12 := NULL;
3559: ELSIF p_ctr_properties_rec.ATTRIBUTE12 IS NULL THEN
3560: l_ctr_properties_rec.ATTRIBUTE12 := l_old_ctr_properties_rec.ATTRIBUTE12;
3561: END IF;
3562: IF p_ctr_properties_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
3563: l_ctr_properties_rec.ATTRIBUTE13 := NULL;
3564: ELSIF p_ctr_properties_rec.ATTRIBUTE13 IS NULL THEN
3565: l_ctr_properties_rec.ATTRIBUTE13 := l_old_ctr_properties_rec.ATTRIBUTE13;
3566: END IF;
3563: l_ctr_properties_rec.ATTRIBUTE13 := NULL;
3564: ELSIF p_ctr_properties_rec.ATTRIBUTE13 IS NULL THEN
3565: l_ctr_properties_rec.ATTRIBUTE13 := l_old_ctr_properties_rec.ATTRIBUTE13;
3566: END IF;
3567: IF p_ctr_properties_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
3568: l_ctr_properties_rec.ATTRIBUTE14 := NULL;
3569: ELSIF p_ctr_properties_rec.ATTRIBUTE14 IS NULL THEN
3570: l_ctr_properties_rec.ATTRIBUTE14 := l_old_ctr_properties_rec.ATTRIBUTE14;
3571: END IF;
3568: l_ctr_properties_rec.ATTRIBUTE14 := NULL;
3569: ELSIF p_ctr_properties_rec.ATTRIBUTE14 IS NULL THEN
3570: l_ctr_properties_rec.ATTRIBUTE14 := l_old_ctr_properties_rec.ATTRIBUTE14;
3571: END IF;
3572: IF p_ctr_properties_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3573: l_ctr_properties_rec.ATTRIBUTE15 := NULL;
3574: ELSIF p_ctr_properties_rec.ATTRIBUTE15 IS NULL THEN
3575: l_ctr_properties_rec.ATTRIBUTE15 := l_old_ctr_properties_rec.ATTRIBUTE15;
3576: END IF;
3573: l_ctr_properties_rec.ATTRIBUTE15 := NULL;
3574: ELSIF p_ctr_properties_rec.ATTRIBUTE15 IS NULL THEN
3575: l_ctr_properties_rec.ATTRIBUTE15 := l_old_ctr_properties_rec.ATTRIBUTE15;
3576: END IF;
3577: IF p_ctr_properties_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
3578: l_ctr_properties_rec.ATTRIBUTE_CATEGORY := NULL;
3579: ELSIF p_ctr_properties_rec.ATTRIBUTE_CATEGORY IS NULL THEN
3580: l_ctr_properties_rec.ATTRIBUTE_CATEGORY := l_old_ctr_properties_rec.ATTRIBUTE_CATEGORY;
3581: END IF;
3578: l_ctr_properties_rec.ATTRIBUTE_CATEGORY := NULL;
3579: ELSIF p_ctr_properties_rec.ATTRIBUTE_CATEGORY IS NULL THEN
3580: l_ctr_properties_rec.ATTRIBUTE_CATEGORY := l_old_ctr_properties_rec.ATTRIBUTE_CATEGORY;
3581: END IF;
3582: IF p_ctr_properties_rec.created_from_ctr_prop_tmpl_id = FND_API.G_MISS_NUM THEN
3583: l_ctr_properties_rec.created_from_ctr_prop_tmpl_id := NULL;
3584: ELSIF p_ctr_properties_rec.created_from_ctr_prop_tmpl_id IS NULL THEN
3585: l_ctr_properties_rec.created_from_ctr_prop_tmpl_id := l_old_ctr_properties_rec.created_from_ctr_prop_tmpl_id;
3586: END IF;
3583: l_ctr_properties_rec.created_from_ctr_prop_tmpl_id := NULL;
3584: ELSIF p_ctr_properties_rec.created_from_ctr_prop_tmpl_id IS NULL THEN
3585: l_ctr_properties_rec.created_from_ctr_prop_tmpl_id := l_old_ctr_properties_rec.created_from_ctr_prop_tmpl_id;
3586: END IF;
3587: IF p_ctr_properties_rec.object_version_number = FND_API.G_MISS_NUM THEN
3588: l_ctr_properties_rec.object_version_number := NULL;
3589: ELSIF p_ctr_properties_rec.object_version_number IS NULL THEN
3590: l_ctr_properties_rec.object_version_number := l_old_ctr_properties_rec.object_version_number;
3591: END IF;
3679: ,p_name => p_ctr_properties_rec.name
3680: ,p_description => p_ctr_properties_rec.description
3681: ,p_create_from_ctr_prop_tmpl_id => p_ctr_properties_rec.created_from_ctr_prop_tmpl_id
3682: );
3683: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3684: ROLLBACK TO update_ctr_property_pvt;
3685: RETURN;
3686: END IF;
3687:
3687:
3688: -- End of API body
3689:
3690: -- Standard check of p_commit.
3691: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3692: COMMIT WORK;
3693: END IF;
3694:
3695: EXCEPTION
3692: COMMIT WORK;
3693: END IF;
3694:
3695: EXCEPTION
3696: WHEN FND_API.G_EXC_ERROR THEN
3697: x_return_status := FND_API.G_RET_STS_ERROR ;
3698: ROLLBACK TO update_ctr_property_pvt;
3699: FND_MSG_PUB.Count_And_Get
3700: (p_count => x_msg_count,
3693: END IF;
3694:
3695: EXCEPTION
3696: WHEN FND_API.G_EXC_ERROR THEN
3697: x_return_status := FND_API.G_RET_STS_ERROR ;
3698: ROLLBACK TO update_ctr_property_pvt;
3699: FND_MSG_PUB.Count_And_Get
3700: (p_count => x_msg_count,
3701: p_data => x_msg_data
3700: (p_count => x_msg_count,
3701: p_data => x_msg_data
3702: );
3703:
3704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3706: ROLLBACK TO update_ctr_property_pvt;
3707: FND_MSG_PUB.Count_And_Get
3708: (p_count => x_msg_count,
3701: p_data => x_msg_data
3702: );
3703:
3704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3706: ROLLBACK TO update_ctr_property_pvt;
3707: FND_MSG_PUB.Count_And_Get
3708: (p_count => x_msg_count,
3709: p_data => x_msg_data
3708: (p_count => x_msg_count,
3709: p_data => x_msg_data
3710: );
3711: WHEN OTHERS THEN
3712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3713: ROLLBACK TO update_ctr_property_pvt;
3714: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3715: THEN
3716: FND_MSG_PUB.Add_Exc_Msg
3759: -- Standard Start of API savepoint
3760: SAVEPOINT update_ctr_associations_pvt;
3761:
3762: -- Standard call to check for call compatibility.
3763: IF NOT FND_API.Compatible_API_Call (l_api_version,
3764: p_api_version,
3765: l_api_name ,
3766: G_PKG_NAME )
3767: THEN
3764: p_api_version,
3765: l_api_name ,
3766: G_PKG_NAME )
3767: THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: END IF;
3770:
3771: -- Initialize message list if p_init_msg_list is set to TRUE.
3772: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3769: END IF;
3770:
3771: -- Initialize message list if p_init_msg_list is set to TRUE.
3772: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3773: FND_MSG_PUB.initialize;
3774: END IF;
3775:
3776: -- Initialize API return status to success
3773: FND_MSG_PUB.initialize;
3774: END IF;
3775:
3776: -- Initialize API return status to success
3777: x_return_status := FND_API.G_RET_STS_SUCCESS;
3778:
3779: -- Read the debug profiles values in to global variable 7197402
3780: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3781:
3854: END IF;
3855:
3856: l_counter_associations_rec := p_counter_associations_rec;
3857:
3858: IF p_counter_associations_rec.SOURCE_OBJECT_CODE = FND_API.G_MISS_CHAR THEN
3859: l_counter_associations_rec.SOURCE_OBJECT_CODE := NULL;
3860: ELSIF p_counter_associations_rec.SOURCE_OBJECT_CODE IS NULL THEN
3861: l_counter_associations_rec.SOURCE_OBJECT_CODE := l_old_counter_associations_rec.SOURCE_OBJECT_CODE;
3862: END IF;
3859: l_counter_associations_rec.SOURCE_OBJECT_CODE := NULL;
3860: ELSIF p_counter_associations_rec.SOURCE_OBJECT_CODE IS NULL THEN
3861: l_counter_associations_rec.SOURCE_OBJECT_CODE := l_old_counter_associations_rec.SOURCE_OBJECT_CODE;
3862: END IF;
3863: IF p_counter_associations_rec.SOURCE_OBJECT_ID = FND_API.G_MISS_NUM THEN
3864: l_counter_associations_rec.SOURCE_OBJECT_ID := NULL;
3865: ELSIF p_counter_associations_rec.SOURCE_OBJECT_ID IS NULL THEN
3866: l_counter_associations_rec.SOURCE_OBJECT_ID := l_old_counter_associations_rec.SOURCE_OBJECT_ID;
3867: END IF;
3864: l_counter_associations_rec.SOURCE_OBJECT_ID := NULL;
3865: ELSIF p_counter_associations_rec.SOURCE_OBJECT_ID IS NULL THEN
3866: l_counter_associations_rec.SOURCE_OBJECT_ID := l_old_counter_associations_rec.SOURCE_OBJECT_ID;
3867: END IF;
3868: IF p_counter_associations_rec.COUNTER_ID = FND_API.G_MISS_NUM THEN
3869: l_counter_associations_rec.COUNTER_ID := NULL;
3870: ELSIF p_counter_associations_rec.COUNTER_ID IS NULL THEN
3871: l_counter_associations_rec.COUNTER_ID := l_old_counter_associations_rec.COUNTER_ID;
3872: END IF;
3869: l_counter_associations_rec.COUNTER_ID := NULL;
3870: ELSIF p_counter_associations_rec.COUNTER_ID IS NULL THEN
3871: l_counter_associations_rec.COUNTER_ID := l_old_counter_associations_rec.COUNTER_ID;
3872: END IF;
3873: IF p_counter_associations_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE THEN
3874: l_counter_associations_rec.START_DATE_ACTIVE := NULL;
3875: ELSIF p_counter_associations_rec.START_DATE_ACTIVE IS NULL THEN
3876: l_counter_associations_rec.START_DATE_ACTIVE := l_old_counter_associations_rec.START_DATE_ACTIVE;
3877: END IF;
3874: l_counter_associations_rec.START_DATE_ACTIVE := NULL;
3875: ELSIF p_counter_associations_rec.START_DATE_ACTIVE IS NULL THEN
3876: l_counter_associations_rec.START_DATE_ACTIVE := l_old_counter_associations_rec.START_DATE_ACTIVE;
3877: END IF;
3878: IF p_counter_associations_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE THEN
3879: l_counter_associations_rec.END_DATE_ACTIVE := NULL;
3880: ELSIF p_counter_associations_rec.END_DATE_ACTIVE IS NULL THEN
3881: l_counter_associations_rec.END_DATE_ACTIVE := l_old_counter_associations_rec.END_DATE_ACTIVE;
3882: END IF;
3879: l_counter_associations_rec.END_DATE_ACTIVE := NULL;
3880: ELSIF p_counter_associations_rec.END_DATE_ACTIVE IS NULL THEN
3881: l_counter_associations_rec.END_DATE_ACTIVE := l_old_counter_associations_rec.END_DATE_ACTIVE;
3882: END IF;
3883: IF p_counter_associations_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
3884: l_counter_associations_rec.ATTRIBUTE1 := NULL;
3885: ELSIF p_counter_associations_rec.ATTRIBUTE1 IS NULL THEN
3886: l_counter_associations_rec.ATTRIBUTE1 := l_old_counter_associations_rec.ATTRIBUTE1;
3887: END IF;
3884: l_counter_associations_rec.ATTRIBUTE1 := NULL;
3885: ELSIF p_counter_associations_rec.ATTRIBUTE1 IS NULL THEN
3886: l_counter_associations_rec.ATTRIBUTE1 := l_old_counter_associations_rec.ATTRIBUTE1;
3887: END IF;
3888: IF p_counter_associations_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
3889: l_counter_associations_rec.ATTRIBUTE2 := NULL;
3890: ELSIF p_counter_associations_rec.ATTRIBUTE2 IS NULL THEN
3891: l_counter_associations_rec.ATTRIBUTE2 := l_old_counter_associations_rec.ATTRIBUTE2;
3892: END IF;
3889: l_counter_associations_rec.ATTRIBUTE2 := NULL;
3890: ELSIF p_counter_associations_rec.ATTRIBUTE2 IS NULL THEN
3891: l_counter_associations_rec.ATTRIBUTE2 := l_old_counter_associations_rec.ATTRIBUTE2;
3892: END IF;
3893: IF p_counter_associations_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
3894: l_counter_associations_rec.ATTRIBUTE3 := NULL;
3895: ELSIF p_counter_associations_rec.ATTRIBUTE3 IS NULL THEN
3896: l_counter_associations_rec.ATTRIBUTE3 := l_old_counter_associations_rec.ATTRIBUTE3;
3897: END IF;
3894: l_counter_associations_rec.ATTRIBUTE3 := NULL;
3895: ELSIF p_counter_associations_rec.ATTRIBUTE3 IS NULL THEN
3896: l_counter_associations_rec.ATTRIBUTE3 := l_old_counter_associations_rec.ATTRIBUTE3;
3897: END IF;
3898: IF p_counter_associations_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
3899: l_counter_associations_rec.ATTRIBUTE4 := NULL;
3900: ELSIF p_counter_associations_rec.ATTRIBUTE4 IS NULL THEN
3901: l_counter_associations_rec.ATTRIBUTE4 := l_old_counter_associations_rec.ATTRIBUTE4;
3902: END IF;
3899: l_counter_associations_rec.ATTRIBUTE4 := NULL;
3900: ELSIF p_counter_associations_rec.ATTRIBUTE4 IS NULL THEN
3901: l_counter_associations_rec.ATTRIBUTE4 := l_old_counter_associations_rec.ATTRIBUTE4;
3902: END IF;
3903: IF p_counter_associations_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
3904: l_counter_associations_rec.ATTRIBUTE5 := NULL;
3905: ELSIF p_counter_associations_rec.ATTRIBUTE5 IS NULL THEN
3906: l_counter_associations_rec.ATTRIBUTE5 := l_old_counter_associations_rec.ATTRIBUTE5;
3907: END IF;
3904: l_counter_associations_rec.ATTRIBUTE5 := NULL;
3905: ELSIF p_counter_associations_rec.ATTRIBUTE5 IS NULL THEN
3906: l_counter_associations_rec.ATTRIBUTE5 := l_old_counter_associations_rec.ATTRIBUTE5;
3907: END IF;
3908: IF p_counter_associations_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
3909: l_counter_associations_rec.ATTRIBUTE6 := NULL;
3910: ELSIF p_counter_associations_rec.ATTRIBUTE6 IS NULL THEN
3911: l_counter_associations_rec.ATTRIBUTE6 := l_old_counter_associations_rec.ATTRIBUTE6;
3912: END IF;
3909: l_counter_associations_rec.ATTRIBUTE6 := NULL;
3910: ELSIF p_counter_associations_rec.ATTRIBUTE6 IS NULL THEN
3911: l_counter_associations_rec.ATTRIBUTE6 := l_old_counter_associations_rec.ATTRIBUTE6;
3912: END IF;
3913: IF p_counter_associations_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
3914: l_counter_associations_rec.ATTRIBUTE7 := NULL;
3915: ELSIF p_counter_associations_rec.ATTRIBUTE7 IS NULL THEN
3916: l_counter_associations_rec.ATTRIBUTE7 := l_old_counter_associations_rec.ATTRIBUTE7;
3917: END IF;
3914: l_counter_associations_rec.ATTRIBUTE7 := NULL;
3915: ELSIF p_counter_associations_rec.ATTRIBUTE7 IS NULL THEN
3916: l_counter_associations_rec.ATTRIBUTE7 := l_old_counter_associations_rec.ATTRIBUTE7;
3917: END IF;
3918: IF p_counter_associations_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
3919: l_counter_associations_rec.ATTRIBUTE8 := NULL;
3920: ELSIF p_counter_associations_rec.ATTRIBUTE8 IS NULL THEN
3921: l_counter_associations_rec.ATTRIBUTE8 := l_old_counter_associations_rec.ATTRIBUTE8;
3922: END IF;
3919: l_counter_associations_rec.ATTRIBUTE8 := NULL;
3920: ELSIF p_counter_associations_rec.ATTRIBUTE8 IS NULL THEN
3921: l_counter_associations_rec.ATTRIBUTE8 := l_old_counter_associations_rec.ATTRIBUTE8;
3922: END IF;
3923: IF p_counter_associations_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
3924: l_counter_associations_rec.ATTRIBUTE9 := NULL;
3925: ELSIF p_counter_associations_rec.ATTRIBUTE9 IS NULL THEN
3926: l_counter_associations_rec.ATTRIBUTE9 := l_old_counter_associations_rec.ATTRIBUTE9;
3927: END IF;
3924: l_counter_associations_rec.ATTRIBUTE9 := NULL;
3925: ELSIF p_counter_associations_rec.ATTRIBUTE9 IS NULL THEN
3926: l_counter_associations_rec.ATTRIBUTE9 := l_old_counter_associations_rec.ATTRIBUTE9;
3927: END IF;
3928: IF p_counter_associations_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
3929: l_counter_associations_rec.ATTRIBUTE10 := NULL;
3930: ELSIF p_counter_associations_rec.ATTRIBUTE10 IS NULL THEN
3931: l_counter_associations_rec.ATTRIBUTE10 := l_old_counter_associations_rec.ATTRIBUTE10;
3932: END IF;
3929: l_counter_associations_rec.ATTRIBUTE10 := NULL;
3930: ELSIF p_counter_associations_rec.ATTRIBUTE10 IS NULL THEN
3931: l_counter_associations_rec.ATTRIBUTE10 := l_old_counter_associations_rec.ATTRIBUTE10;
3932: END IF;
3933: IF p_counter_associations_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
3934: l_counter_associations_rec.ATTRIBUTE11 := NULL;
3935: ELSIF p_counter_associations_rec.ATTRIBUTE11 IS NULL THEN
3936: l_counter_associations_rec.ATTRIBUTE11 := l_old_counter_associations_rec.ATTRIBUTE11;
3937: END IF;
3934: l_counter_associations_rec.ATTRIBUTE11 := NULL;
3935: ELSIF p_counter_associations_rec.ATTRIBUTE11 IS NULL THEN
3936: l_counter_associations_rec.ATTRIBUTE11 := l_old_counter_associations_rec.ATTRIBUTE11;
3937: END IF;
3938: IF p_counter_associations_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
3939: l_counter_associations_rec.ATTRIBUTE12 := NULL;
3940: ELSIF p_counter_associations_rec.ATTRIBUTE12 IS NULL THEN
3941: l_counter_associations_rec.ATTRIBUTE12 := l_old_counter_associations_rec.ATTRIBUTE12;
3942: END IF;
3939: l_counter_associations_rec.ATTRIBUTE12 := NULL;
3940: ELSIF p_counter_associations_rec.ATTRIBUTE12 IS NULL THEN
3941: l_counter_associations_rec.ATTRIBUTE12 := l_old_counter_associations_rec.ATTRIBUTE12;
3942: END IF;
3943: IF p_counter_associations_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
3944: l_counter_associations_rec.ATTRIBUTE13 := NULL;
3945: ELSIF p_counter_associations_rec.ATTRIBUTE13 IS NULL THEN
3946: l_counter_associations_rec.ATTRIBUTE13 := l_old_counter_associations_rec.ATTRIBUTE13;
3947: END IF;
3944: l_counter_associations_rec.ATTRIBUTE13 := NULL;
3945: ELSIF p_counter_associations_rec.ATTRIBUTE13 IS NULL THEN
3946: l_counter_associations_rec.ATTRIBUTE13 := l_old_counter_associations_rec.ATTRIBUTE13;
3947: END IF;
3948: IF p_counter_associations_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
3949: l_counter_associations_rec.ATTRIBUTE14 := NULL;
3950: ELSIF p_counter_associations_rec.ATTRIBUTE14 IS NULL THEN
3951: l_counter_associations_rec.ATTRIBUTE14 := l_old_counter_associations_rec.ATTRIBUTE14;
3952: END IF;
3949: l_counter_associations_rec.ATTRIBUTE14 := NULL;
3950: ELSIF p_counter_associations_rec.ATTRIBUTE14 IS NULL THEN
3951: l_counter_associations_rec.ATTRIBUTE14 := l_old_counter_associations_rec.ATTRIBUTE14;
3952: END IF;
3953: IF p_counter_associations_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3954: l_counter_associations_rec.ATTRIBUTE15 := NULL;
3955: ELSIF p_counter_associations_rec.ATTRIBUTE15 IS NULL THEN
3956: l_counter_associations_rec.ATTRIBUTE15 := l_old_counter_associations_rec.ATTRIBUTE15;
3957: END IF;
3954: l_counter_associations_rec.ATTRIBUTE15 := NULL;
3955: ELSIF p_counter_associations_rec.ATTRIBUTE15 IS NULL THEN
3956: l_counter_associations_rec.ATTRIBUTE15 := l_old_counter_associations_rec.ATTRIBUTE15;
3957: END IF;
3958: IF p_counter_associations_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
3959: l_counter_associations_rec.ATTRIBUTE_CATEGORY := NULL;
3960: ELSIF p_counter_associations_rec.ATTRIBUTE_CATEGORY IS NULL THEN
3961: l_counter_associations_rec.ATTRIBUTE_CATEGORY := l_old_counter_associations_rec.ATTRIBUTE_CATEGORY;
3962: END IF;
3959: l_counter_associations_rec.ATTRIBUTE_CATEGORY := NULL;
3960: ELSIF p_counter_associations_rec.ATTRIBUTE_CATEGORY IS NULL THEN
3961: l_counter_associations_rec.ATTRIBUTE_CATEGORY := l_old_counter_associations_rec.ATTRIBUTE_CATEGORY;
3962: END IF;
3963: IF p_counter_associations_rec.object_version_number = FND_API.G_MISS_NUM THEN
3964: l_counter_associations_rec.object_version_number := NULL;
3965: ELSIF p_counter_associations_rec.object_version_number IS NULL THEN
3966: l_counter_associations_rec.object_version_number := l_old_counter_associations_rec.object_version_number;
3967: END IF;
3965: ELSIF p_counter_associations_rec.object_version_number IS NULL THEN
3966: l_counter_associations_rec.object_version_number := l_old_counter_associations_rec.object_version_number;
3967: END IF;
3968:
3969: IF p_counter_associations_rec.maint_organization_id = FND_API.G_MISS_NUM THEN
3970: l_counter_associations_rec.maint_organization_id := NULL;
3971: ELSIF p_counter_associations_rec.maint_organization_id IS NULL THEN
3972: l_counter_associations_rec.maint_organization_id := l_old_counter_associations_rec.maint_organization_id;
3973: END IF;
3976: csi_ctr_gen_utility_pvt.put_line('Object version mismatch in update counter');
3977: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_OBJ_VER_MISMATCH');
3978: END IF;
3979:
3980: IF p_counter_associations_rec.primary_failure_flag = FND_API.G_MISS_CHAR THEN
3981: l_counter_associations_rec.primary_failure_flag := NULL;
3982: ELSIF p_counter_associations_rec.primary_failure_flag IS NULL THEN
3983: l_counter_associations_rec.primary_failure_flag := l_old_counter_associations_rec.primary_failure_flag;
3984: END IF;
4038: ,p_END_DATE_ACTIVE => p_counter_associations_rec.END_DATE_ACTIVE
4039: ,p_MAINT_ORGANIZATION_ID => p_counter_associations_rec.MAINT_ORGANIZATION_ID
4040: ,p_PRIMARY_FAILURE_FLAG => p_counter_associations_rec.PRIMARY_FAILURE_FLAG
4041: );
4042: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4043: ROLLBACK TO update_ctr_associations_pvt;
4044: RETURN;
4045: END IF;
4046:
4045: END IF;
4046:
4047: -- End of API body
4048: -- Standard check of p_commit.
4049: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
4050: COMMIT WORK;
4051: END IF;
4052:
4053: EXCEPTION
4050: COMMIT WORK;
4051: END IF;
4052:
4053: EXCEPTION
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: x_return_status := FND_API.G_RET_STS_ERROR ;
4056: ROLLBACK TO update_ctr_associations_pvt;
4057: FND_MSG_PUB.Count_And_Get
4058: (p_count => x_msg_count,
4051: END IF;
4052:
4053: EXCEPTION
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: x_return_status := FND_API.G_RET_STS_ERROR ;
4056: ROLLBACK TO update_ctr_associations_pvt;
4057: FND_MSG_PUB.Count_And_Get
4058: (p_count => x_msg_count,
4059: p_data => x_msg_data
4058: (p_count => x_msg_count,
4059: p_data => x_msg_data
4060: );
4061:
4062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4064: ROLLBACK TO update_ctr_associations_pvt;
4065: FND_MSG_PUB.Count_And_Get
4066: (p_count => x_msg_count,
4059: p_data => x_msg_data
4060: );
4061:
4062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4064: ROLLBACK TO update_ctr_associations_pvt;
4065: FND_MSG_PUB.Count_And_Get
4066: (p_count => x_msg_count,
4067: p_data => x_msg_data
4066: (p_count => x_msg_count,
4067: p_data => x_msg_data
4068: );
4069: WHEN OTHERS THEN
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4071: ROLLBACK TO update_ctr_associations_pvt;
4072: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4073: THEN
4074: FND_MSG_PUB.Add_Exc_Msg
4114: -- Standard Start of API savepoint
4115: SAVEPOINT update_ctr_val_max_seq_no;
4116:
4117: -- Standard call to check for call compatibility.
4118: IF NOT FND_API.Compatible_API_Call (l_api_version,
4119: p_api_version,
4120: l_api_name ,
4121: G_PKG_NAME )
4122: THEN
4119: p_api_version,
4120: l_api_name ,
4121: G_PKG_NAME )
4122: THEN
4123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4124: END IF;
4125:
4126: -- Initialize message list if p_init_msg_list is set to TRUE.
4127: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4124: END IF;
4125:
4126: -- Initialize message list if p_init_msg_list is set to TRUE.
4127: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4128: FND_MSG_PUB.initialize;
4129: END IF;
4130:
4131: -- Initialize API return status to success
4128: FND_MSG_PUB.initialize;
4129: END IF;
4130:
4131: -- Initialize API return status to success
4132: x_return_status := FND_API.G_RET_STS_SUCCESS;
4133:
4134: csi_ctr_gen_utility_pvt.read_debug_profiles;
4135:
4136: -- If debug_level = 1 then dump the procedure name
4168: csi_ctr_gen_utility_pvt.put_line('l_old_object_version_number : ' || l_old_object_version_number);
4169: END IF;
4170:
4171: IF (px_ctr_val_max_seq_no IS NOT NULL) AND
4172: (px_ctr_val_max_seq_no <> FND_API.G_MISS_NUM) THEN
4173: BEGIN
4174: SELECT 'Y', value_timestamp
4175: INTO l_ctr_val_id_exist, l_new_value_timestamp
4176: FROM csi_counter_readings
4179: AND NVL(disabled_flag, 'N') = 'N';
4180: EXCEPTION
4181: WHEN NO_DATA_FOUND THEN
4182: csi_ctr_gen_utility_pvt.put_line('Invalid parameter px_ctr_val_max_seq_no : '||px_ctr_val_max_seq_no);
4183: RAISE FND_API.G_EXC_ERROR;
4184: END;
4185:
4186: IF (l_ctr_val_id_exist = 'Y') AND (px_ctr_val_max_seq_no <> l_old_ctr_val_max_seq_no) THEN
4187: IF (l_old_ctr_val_max_seq_no <= 0) THEN
4202: END IF;
4203: ELSE --l_ctr_val_id_exist = 'N' or px_ctr_val_max_seq_no = l_old_ctr_val_max_seq_no
4204: l_new_reading_is_latest := 'N';
4205: END IF;
4206: ELSE --px_ctr_val_max_seq_no IS NULL or px_ctr_val_max_seq_no = FND_API.G_MISS_NUM
4207: --Need to figure out the latest valid counter reading
4208: px_ctr_val_max_seq_no := 0; --Default px_ctr_val_max_seq_no to 0
4209: BEGIN
4210: SELECT counter_value_id, value_timestamp, 'Y', 'Y'
4318: END IF;
4319: -- End of API body
4320:
4321: -- Standard check of p_commit.
4322: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
4323: COMMIT WORK;
4324: END IF;
4325:
4326: EXCEPTION
4323: COMMIT WORK;
4324: END IF;
4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN
4328: x_return_status := FND_API.G_RET_STS_ERROR;
4329: ROLLBACK TO update_ctr_val_max_seq_no;
4330: FND_MSG_PUB.Count_And_Get
4331: (p_count => x_msg_count,
4324: END IF;
4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN
4328: x_return_status := FND_API.G_RET_STS_ERROR;
4329: ROLLBACK TO update_ctr_val_max_seq_no;
4330: FND_MSG_PUB.Count_And_Get
4331: (p_count => x_msg_count,
4332: p_data => x_msg_data
4330: FND_MSG_PUB.Count_And_Get
4331: (p_count => x_msg_count,
4332: p_data => x_msg_data
4333: );
4334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4336: ROLLBACK TO update_ctr_val_max_seq_no;
4337: FND_MSG_PUB.Count_And_Get
4338: (p_count => x_msg_count,
4331: (p_count => x_msg_count,
4332: p_data => x_msg_data
4333: );
4334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4336: ROLLBACK TO update_ctr_val_max_seq_no;
4337: FND_MSG_PUB.Count_And_Get
4338: (p_count => x_msg_count,
4339: p_data => x_msg_data
4338: (p_count => x_msg_count,
4339: p_data => x_msg_data
4340: );
4341: WHEN OTHERS THEN
4342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: ROLLBACK TO update_ctr_val_max_seq_no;
4344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4345: THEN
4346: FND_MSG_PUB.Add_Exc_Msg