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

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_EXTEND_ATTRIB_VLD_PVT

Line 25547: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_instance_id

25543: IF l_exists_flag <> 'Y'
25544: THEN
25545: p_ext_count_rec.ext_count := p_ext_count_rec.ext_count + 1;
25546: p_ext_id_tbl(p_ext_count_rec.ext_count).instance_id := p_ext_attrib_rec.instance_id;
25547: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_instance_id
25548: (p_ext_attrib_rec.instance_id
25549: ,'INSERT'
25550: ,l_ori_inventory_item_id
25551: ,l_ori_master_org_id)) THEN

Line 25599: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_id

25595: IF l_exists_flag <> 'Y'
25596: THEN
25597: p_ext_count_rec.ext_attr_count := p_ext_count_rec.ext_attr_count + 1;
25598: p_ext_attr_tbl(p_ext_count_rec.ext_attr_count).attribute_id := p_ext_attrib_rec.attribute_id;
25599: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_id
25600: (p_ext_attrib_rec.attribute_id
25601: ,l_attribute_level
25602: ,l_master_organization_id
25603: ,l_inventory_item_id

Line 25684: IF NOT(csi_extend_attrib_vld_pvt.Alternate_PK_exists

25680: END IF;
25681: ELSE -- -- Added by sk for bug 2232880
25682: -- Verify that alternate PK is valid
25683: IF p_called_from_grp <> FND_API.G_TRUE THEN
25684: IF NOT(csi_extend_attrib_vld_pvt.Alternate_PK_exists
25685: (p_ext_attrib_rec.instance_id
25686: ,p_ext_attrib_rec.attribute_id
25687: )) THEN
25688: RAISE FND_API.G_EXC_ERROR;

Line 25694: IF NOT(csi_extend_attrib_vld_pvt.Is_StartDate_Valid

25690: END IF;
25691:
25692: -- Check start effective date
25693: IF p_called_from_grp <> FND_API.G_TRUE THEN
25694: IF NOT(csi_extend_attrib_vld_pvt.Is_StartDate_Valid
25695: (p_ext_attrib_rec.ACTIVE_START_DATE,
25696: p_ext_attrib_rec.ACTIVE_END_DATE ,
25697: p_ext_attrib_rec.INSTANCE_ID )) THEN
25698: RAISE FND_API.G_EXC_ERROR;

Line 25706: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid

25702:
25703: -- Check end effective date
25704: IF p_called_from_grp <> FND_API.G_TRUE THEN
25705: IF p_ext_attrib_rec.ACTIVE_END_DATE is NOT NULL THEN
25706: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid
25707: (p_ext_attrib_rec.ACTIVE_START_DATE,
25708: p_ext_attrib_rec.ACTIVE_END_DATE ,
25709: p_ext_attrib_rec.INSTANCE_ID ,
25710: p_ext_attrib_rec.ATTRIBUTE_VALUE_ID,

Line 25751: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content

25747: IF l_exists_flag <> 'Y'
25748: THEN
25749: p_ext_count_rec.ext_cat_count := p_ext_count_rec.ext_cat_count + 1;
25750: p_ext_cat_tbl(p_ext_count_rec.ext_cat_count).item_cat_id := l_item_category_id;
25751: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content
25752: ( l_attribute_level
25753: ,l_master_organization_id
25754: ,l_inventory_item_id
25755: ,l_item_category_id

Line 25771: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content

25767: END IF;
25768: END IF;
25769: END IF;
25770: ELSE -- attribute level <> 'CATEGORY'
25771: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content
25772: (l_attribute_level
25773: ,l_master_organization_id
25774: ,l_inventory_item_id
25775: ,l_item_category_id

Line 25790: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;

25786: -- and check if the value exists . If exists then generate again from the sequence
25787: -- till we get a value that does not exist
25788: IF l_attribute_value_id IS NULL OR
25789: l_attribute_value_id = FND_API.G_MISS_NUM THEN
25790: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
25791: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
25792: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
25793: (l_attribute_value_id))
25794: LOOP

Line 25792: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id

25788: IF l_attribute_value_id IS NULL OR
25789: l_attribute_value_id = FND_API.G_MISS_NUM THEN
25790: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
25791: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
25792: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
25793: (l_attribute_value_id))
25794: LOOP
25795: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
25796: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;

Line 25795: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;

25791: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
25792: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
25793: (l_attribute_value_id))
25794: LOOP
25795: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
25796: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
25797: END LOOP;
25798: ELSE
25799: -- Validate attribute_value_id

Line 25800: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id

25796: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
25797: END LOOP;
25798: ELSE
25799: -- Validate attribute_value_id
25800: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
25801: (p_ext_attrib_rec.attribute_value_id)) THEN
25802: RAISE FND_API.G_EXC_ERROR;
25803: END IF;
25804:

Line 25874: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;

25870: END IF;
25871:
25872:
25873: -- Get a unique org_assignment number from the sequence
25874: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
25875:
25876: l_dump_frequency_flag :='N';
25877: -- Create a history
25878: CSI_IEA_VALUES_H_PKG.Insert_Row(

Line 26081: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id

26077:
26078: -- Start API body
26079:
26080: -- Validate extended_attribute_value_id
26081: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id
26082: (p_ext_attrib_rec.attribute_value_id,
26083: l_ext_attrib_rec )) THEN
26084: RAISE FND_API.G_EXC_ERROR;
26085: END IF;

Line 26089: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_obj_ver_num

26085: END IF;
26086:
26087:
26088: -- Validate object_version_number
26089: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_obj_ver_num
26090: (p_ext_attrib_rec.object_version_number
26091: ,l_ext_attrib_rec.object_version_number
26092: )) THEN
26093: RAISE FND_API.G_EXC_ERROR;

Line 26098: IF NOT(csi_extend_attrib_vld_pvt.Is_Updatable

26094: END IF;
26095:
26096:
26097: -- Validate if the instance is updatable
26098: IF NOT(csi_extend_attrib_vld_pvt.Is_Updatable
26099: (l_ext_attrib_rec.active_end_date ,
26100: p_ext_attrib_rec.active_end_date )) THEN
26101: RAISE FND_API.G_EXC_ERROR;
26102: END IF;

Line 26105: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_instance_id

26101: RAISE FND_API.G_EXC_ERROR;
26102: END IF;
26103:
26104: -- Validate instance id for which the update is related to
26105: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_instance_id
26106: (l_ext_attrib_rec.instance_id
26107: ,'UPDATE'
26108: ,l_ori_inventory_item_id
26109: ,l_ori_master_org_id)) THEN

Line 26111: IF NOT(csi_extend_attrib_vld_pvt.Is_Expire_Op

26107: ,'UPDATE'
26108: ,l_ori_inventory_item_id
26109: ,l_ori_master_org_id)) THEN
26110: -- Check if it is an expire operation
26111: IF NOT(csi_extend_attrib_vld_pvt.Is_Expire_Op
26112: (p_ext_attrib_rec)) THEN
26113: RAISE FND_API.G_EXC_ERROR;
26114: END IF;
26115: END IF;

Line 26119: IF NOT(csi_extend_attrib_vld_pvt.Val_inst_id_for_update

26115: END IF;
26116:
26117: -- Validate instance id
26118: IF ( p_ext_attrib_rec.instance_id <> FND_API.G_MISS_NUM ) THEN
26119: IF NOT(csi_extend_attrib_vld_pvt.Val_inst_id_for_update
26120: (p_ext_attrib_rec.instance_id
26121: ,l_ext_attrib_rec.instance_id
26122: )) THEN
26123: RAISE FND_API.G_EXC_ERROR;

Line 26142: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid

26138: -- Verify end effective date
26139: IF ( p_ext_attrib_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
26140: IF p_ext_attrib_rec.active_end_date is NOT NULL THEN
26141: IF g_expire_ext_att_flag <> 'Y' THEN
26142: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid
26143: (p_ext_attrib_rec.active_start_date,
26144: p_ext_attrib_rec.active_end_date,
26145: p_ext_attrib_rec.instance_id ,
26146: p_ext_attrib_rec.attribute_value_id ,

Line 26167: csi_extend_attrib_vld_pvt.get_object_version_number(l_ext_attrib_rec.object_version_number);

26163:
26164:
26165: -- Get the new object version number
26166: l_ext_attrib_rec.object_version_number :=
26167: csi_extend_attrib_vld_pvt.get_object_version_number(l_ext_attrib_rec.object_version_number);
26168:
26169: CSI_IEA_VALUES_PKG.Update_Row
26170: (
26171: l_attribute_value_id

Line 26234: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;

26230: RAISE FND_API.G_EXC_ERROR;
26231: END IF;
26232:
26233: -- Get a unique org_assignment number from the sequence
26234: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
26235:
26236: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
26237: l_dump_frequency := csi_org_unit_vld_pvt.get_full_dump_frequency;
26238: --

Line 27155: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id

27151:
27152:
27153: -- Start API body
27154: -- Validate extended_attribute_value_id
27155: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id
27156: (p_ext_attrib_rec.attribute_value_id,
27157: l_ext_attrib_rec )) THEN
27158: RAISE FND_API.G_EXC_ERROR;
27159: END IF;