APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_UTIL_UC_PKG

Line 6988: AHL_UTIL_UC_PKG.GetCSI_Attribute_Value (l_serialnum_change_rec.instance_id,

6984: RAISE FND_API.G_EXC_ERROR;
6985: END IF;
6986:
6987: -- Retrieve existing value of serialNum_Tag_Code if present.
6988: AHL_UTIL_UC_PKG.GetCSI_Attribute_Value (l_serialnum_change_rec.instance_id,
6989: 'AHL_TEMP_SERIAL_NUM',
6990: l_attribute_value,
6991: l_attribute_value_id,
6992: l_object_version_number,

Line 7145: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);

7141: END IF;
7142: ELSIF (l_serial_tag_rec_found = 'N' ) THEN
7143: IF (l_serialnum_change_rec.New_Serial_Tag_Code IS NOT NULL) THEN
7144: -- create extended attributes.
7145: AHL_UTIL_UC_PKG.GetCSI_Attribute_ID('AHL_TEMP_SERIAL_NUM',l_attribute_id, l_return_val);
7146: IF NOT(l_return_val) THEN
7147: FND_MESSAGE.Set_Name('AHL','AHL_ATTRIB_CODE_MISSING');
7148: FND_MESSAGE.Set_Token('CODE', 'AHL_TEMP_SERIAL_NUM');
7149: FND_MSG_PUB.ADD;

Line 7175: AHL_UTIL_UC_PKG.GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);

7171: l_csi_transaction_rec.source_transaction_date := sysdate;
7172:
7173: -- get transaction_type_id .
7174: -- Balaji modified the transaction id type to 205--ITEM_SERIAL_CHANGE
7175: AHL_UTIL_UC_PKG.GetCSI_Transaction_ID('ITEM_SERIAL_CHANGE',l_transaction_type_id, l_return_val);
7176: IF NOT(l_return_val) THEN
7177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7178: END IF;
7179: