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 26112: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_instance_id

26108: IF l_exists_flag <> 'Y'
26109: THEN
26110: p_ext_count_rec.ext_count := p_ext_count_rec.ext_count + 1;
26111: p_ext_id_tbl(p_ext_count_rec.ext_count).instance_id := p_ext_attrib_rec.instance_id;
26112: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_instance_id
26113: (p_ext_attrib_rec.instance_id
26114: ,'INSERT'
26115: ,l_ori_inventory_item_id
26116: ,l_ori_master_org_id)) THEN

Line 26164: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_id

26160: IF l_exists_flag <> 'Y'
26161: THEN
26162: p_ext_count_rec.ext_attr_count := p_ext_count_rec.ext_attr_count + 1;
26163: p_ext_attr_tbl(p_ext_count_rec.ext_attr_count).attribute_id := p_ext_attrib_rec.attribute_id;
26164: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_id
26165: (p_ext_attrib_rec.attribute_id
26166: ,l_attribute_level
26167: ,l_master_organization_id
26168: ,l_inventory_item_id

Line 26249: IF NOT(csi_extend_attrib_vld_pvt.Alternate_PK_exists

26245: END IF;
26246: ELSE -- -- Added by sk for bug 2232880
26247: -- Verify that alternate PK is valid
26248: IF p_called_from_grp <> FND_API.G_TRUE THEN
26249: IF NOT(csi_extend_attrib_vld_pvt.Alternate_PK_exists
26250: (p_ext_attrib_rec.instance_id
26251: ,p_ext_attrib_rec.attribute_id
26252: )) THEN
26253: RAISE FND_API.G_EXC_ERROR;

Line 26259: IF NOT(csi_extend_attrib_vld_pvt.Is_StartDate_Valid

26255: END IF;
26256:
26257: -- Check start effective date
26258: IF p_called_from_grp <> FND_API.G_TRUE THEN
26259: IF NOT(csi_extend_attrib_vld_pvt.Is_StartDate_Valid
26260: (p_ext_attrib_rec.ACTIVE_START_DATE,
26261: p_ext_attrib_rec.ACTIVE_END_DATE ,
26262: p_ext_attrib_rec.INSTANCE_ID )) THEN
26263: RAISE FND_API.G_EXC_ERROR;

Line 26271: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid

26267:
26268: -- Check end effective date
26269: IF p_called_from_grp <> FND_API.G_TRUE THEN
26270: IF p_ext_attrib_rec.ACTIVE_END_DATE is NOT NULL THEN
26271: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid
26272: (p_ext_attrib_rec.ACTIVE_START_DATE,
26273: p_ext_attrib_rec.ACTIVE_END_DATE ,
26274: p_ext_attrib_rec.INSTANCE_ID ,
26275: p_ext_attrib_rec.ATTRIBUTE_VALUE_ID,

Line 26316: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content

26312: IF l_exists_flag <> 'Y'
26313: THEN
26314: p_ext_count_rec.ext_cat_count := p_ext_count_rec.ext_cat_count + 1;
26315: p_ext_cat_tbl(p_ext_count_rec.ext_cat_count).item_cat_id := l_item_category_id;
26316: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content
26317: ( l_attribute_level
26318: ,l_master_organization_id
26319: ,l_inventory_item_id
26320: ,l_item_category_id

Line 26336: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content

26332: END IF;
26333: END IF;
26334: END IF;
26335: ELSE -- attribute level <> 'CATEGORY'
26336: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_attrib_level_content
26337: (l_attribute_level
26338: ,l_master_organization_id
26339: ,l_inventory_item_id
26340: ,l_item_category_id

Line 26355: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;

26351: -- and check if the value exists . If exists then generate again from the sequence
26352: -- till we get a value that does not exist
26353: IF l_attribute_value_id IS NULL OR
26354: l_attribute_value_id = FND_API.G_MISS_NUM THEN
26355: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
26356: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
26357: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
26358: (l_attribute_value_id))
26359: LOOP

Line 26357: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id

26353: IF l_attribute_value_id IS NULL OR
26354: l_attribute_value_id = FND_API.G_MISS_NUM THEN
26355: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
26356: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
26357: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
26358: (l_attribute_value_id))
26359: LOOP
26360: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
26361: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;

Line 26360: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;

26356: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
26357: WHILE NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
26358: (l_attribute_value_id))
26359: LOOP
26360: l_attribute_value_id := csi_extend_attrib_vld_pvt.get_attribute_value_id;
26361: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
26362: END LOOP;
26363: ELSE
26364: -- Validate attribute_value_id

Line 26365: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id

26361: p_ext_attrib_rec.attribute_value_id := l_attribute_value_id;
26362: END LOOP;
26363: ELSE
26364: -- Validate attribute_value_id
26365: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_attribute_value_id
26366: (p_ext_attrib_rec.attribute_value_id)) THEN
26367: RAISE FND_API.G_EXC_ERROR;
26368: END IF;
26369:

Line 26439: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;

26435: END IF;
26436:
26437:
26438: -- Get a unique org_assignment number from the sequence
26439: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
26440:
26441: l_dump_frequency_flag :='N';
26442: -- Create a history
26443: CSI_IEA_VALUES_H_PKG.Insert_Row(

Line 26650: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id

26646:
26647: -- Start API body
26648:
26649: -- Validate extended_attribute_value_id
26650: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id
26651: (p_ext_attrib_rec.attribute_value_id,
26652: l_ext_attrib_rec )) THEN
26653: RAISE FND_API.G_EXC_ERROR;
26654: END IF;

Line 26658: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_obj_ver_num

26654: END IF;
26655:
26656:
26657: -- Validate object_version_number
26658: IF NOT(csi_extend_attrib_vld_pvt.Is_valid_obj_ver_num
26659: (p_ext_attrib_rec.object_version_number
26660: ,l_ext_attrib_rec.object_version_number
26661: )) THEN
26662: RAISE FND_API.G_EXC_ERROR;

Line 26667: IF NOT(csi_extend_attrib_vld_pvt.Is_Updatable

26663: END IF;
26664:
26665:
26666: -- Validate if the instance is updatable
26667: IF NOT(csi_extend_attrib_vld_pvt.Is_Updatable
26668: (l_ext_attrib_rec.active_end_date ,
26669: p_ext_attrib_rec.active_end_date )) THEN
26670: RAISE FND_API.G_EXC_ERROR;
26671: END IF;

Line 26674: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_instance_id

26670: RAISE FND_API.G_EXC_ERROR;
26671: END IF;
26672:
26673: -- Validate instance id for which the update is related to
26674: IF NOT(csi_extend_attrib_vld_pvt.Is_Valid_instance_id
26675: (l_ext_attrib_rec.instance_id
26676: ,'UPDATE'
26677: ,l_ori_inventory_item_id
26678: ,l_ori_master_org_id)) THEN

Line 26680: IF NOT(csi_extend_attrib_vld_pvt.Is_Expire_Op

26676: ,'UPDATE'
26677: ,l_ori_inventory_item_id
26678: ,l_ori_master_org_id)) THEN
26679: -- Check if it is an expire operation
26680: IF NOT(csi_extend_attrib_vld_pvt.Is_Expire_Op
26681: (p_ext_attrib_rec)) THEN
26682: RAISE FND_API.G_EXC_ERROR;
26683: END IF;
26684: END IF;

Line 26688: IF NOT(csi_extend_attrib_vld_pvt.Val_inst_id_for_update

26684: END IF;
26685:
26686: -- Validate instance id
26687: IF ( p_ext_attrib_rec.instance_id <> FND_API.G_MISS_NUM ) THEN
26688: IF NOT(csi_extend_attrib_vld_pvt.Val_inst_id_for_update
26689: (p_ext_attrib_rec.instance_id
26690: ,l_ext_attrib_rec.instance_id
26691: )) THEN
26692: RAISE FND_API.G_EXC_ERROR;

Line 26711: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid

26707: -- Verify end effective date
26708: IF ( p_ext_attrib_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
26709: IF p_ext_attrib_rec.active_end_date is NOT NULL THEN
26710: IF g_expire_ext_att_flag <> 'Y' THEN
26711: IF NOT(csi_extend_attrib_vld_pvt.Is_EndDate_Valid
26712: (p_ext_attrib_rec.active_start_date,
26713: p_ext_attrib_rec.active_end_date,
26714: p_ext_attrib_rec.instance_id ,
26715: p_ext_attrib_rec.attribute_value_id ,

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

26732:
26733:
26734: -- Get the new object version number
26735: l_ext_attrib_rec.object_version_number :=
26736: csi_extend_attrib_vld_pvt.get_object_version_number(l_ext_attrib_rec.object_version_number);
26737:
26738: CSI_IEA_VALUES_PKG.Update_Row
26739: (
26740: l_attribute_value_id

Line 26803: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;

26799: RAISE FND_API.G_EXC_ERROR;
26800: END IF;
26801:
26802: -- Get a unique org_assignment number from the sequence
26803: l_attribute_value_h_id := csi_extend_attrib_vld_pvt.get_attribute_value_h_id;
26804:
26805: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
26806: l_dump_frequency := csi_org_unit_vld_pvt.get_full_dump_frequency;
26807: --

Line 27728: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id

27724:
27725:
27726: -- Start API body
27727: -- Validate extended_attribute_value_id
27728: IF NOT(csi_extend_attrib_vld_pvt.Val_and_get_ext_att_id
27729: (p_ext_attrib_rec.attribute_value_id,
27730: l_ext_attrib_rec )) THEN
27731: RAISE FND_API.G_EXC_ERROR;
27732: END IF;